[yagami]

Within sqlite I can use INSERT and SELECT in the same query, but I decided to change to MySQL at the last minute, and discovered that this is not possible to do here in amxx but I'm lost now to separate the Query

PHP Code:



SQLQuery_RegisterClan(id)
{
    formatex(Query, charsmax(Query),
        "INSERT INTO clans (name, tag, status, owner_id, created_by) VALUES (\
            ^"%s^",\
            ^"%s^",\
            %d,\
            %d,\
            %d\
        );\
        INSERT INTO clans_members (clan_id, player_id, privilegies) VALUES (\
            (SELECT id FROM clans ORDER BY id DESC LIMIT 1),\
            %d,\
            %d\
        );\
        SELECT * FROM clans ORDER BY id DESC LIMIT 1;",
        Player[id][pTemporaryClanName],
        Player[id][pTemporaryClanTag],
        CLAN_STATUS_ACTIVE,
        Player[id][pID],
        Player[id][pID],
        Player[id][pID],
        CLAN_MEMBER_PRIVILEGIES_ALL
    );

    log("SQLQuery_RegisterClan(id: %d) => %s", id, Query);

    new queryData[QueryDataEnum];

    queryData[qPlayerId] = id;

    SQL_ThreadQuery(DatabaseHandle, "@SQLCallback_RegisterClan", Query, queryData, QueryDataEnum);
}

SQLQuery_AcceptClanInvite(id, notificationId)
{
    new notification[NotificationEnum];

    ArrayGetArray(Player[id][pNotifications], notificationId, notification, NotificationEnum);

    formatex(Query, charsmax(Query),
        "UPDATE clans_members SET \
            status = 0 \
        WHERE player_id = %d \
        AND clan_id = %d; \
        INSERT INTO clans_members (player_id, clan_id) VALUES (\
            %d,\
            %d\
        );\
        SELECT \
            cm.clan_id, \
            member.id, \
            member.authid, \
            member.ip, \
            member.name, \
            cm.privilegies, \
            DATE_FORMAT('%%%%d/%%%%m/%%%%Y', cm.created_at) as created_at \
        FROM clans_members cm \
        INNER JOIN clans c \
            ON cm.clan_id = c.id \
        INNER JOIN players member \
            ON member.id = cm.player_id \
        WHERE \
            c.status = 1 \
        AND cm.status = 1 \
        ORDER BY cm.id DESC \
        LIMIT 1",
        Player[id][pID],
        notification[nActionID],
        Player[id][pID],
        notification[nActionID]
    );

    log("SQLQuery_AcceptClanInvite(id: %d) => %s", id, Query);

    new queryData[QueryDataEnum];

    queryData[qPlayerId] = id;
    queryData[qOtherId] = notificationId;

    SQL_ThreadQuery(DatabaseHandle, "@SQLCallback_AcceptClanInvite", Query, queryData, QueryDataEnum);
}

SQLQuery_CreateNotification(registerId, notification[NotificationEnum])
{
    formatex(Query, charsmax(Query),
        "INSERT INTO players_notifications (\
            player_id, \
            subject, \
            message, \
            action, \
            action_id \
        ) VALUES ( \
            %d, \
            ^"%s^", \
            ^"%s^", \
            %d, \
            %d \
        ); \
        SELECT \
            id, \
            player_id, \
            subject, \
            message, \
            action, \
            action_id \
        FROM players_notifications \
        ORDER BY id DESC LIMIT 1;",
        registerId,
        notification[nSubject],
        notification[nMessage],
        notification[nAction],
        notification[nActionID]
    );

    SQL_ThreadQuery(DatabaseHandle, "@SQLCallback_CreateNotification", Query);
} 


[mlibre]

so two formatex

[lexzor]

you can use more inserts in same query

for select use SQL_Execute so you won't don t need to use another function for callback

[Bugsy]

SQL_Execute() can interrupt gameplay. I typically only use it at plugin_cfg()/plugin_init() to create tables and stuff. So I'd stick with SQL_ThreadQuery().

Try something like this:

PHP Code:

enum QueryData_RegisterClan
{
    qd_AddClan,
    qd_AddMembers,
    qd_GetClans
}
enum _:QueryDataEnum
{
    qde_PlayerId,
    QueryData_RegisterClan:qdeTransType
}


SQLQuery_RegisterClan(id)
{
    new queryData[ QueryDataEnum ];
    
    queryData[ qde_PlayerId ] = id;
    
    queryData[ qdeTransType ] = qd_AddClan;
    formatex(Query, charsmax(Query),"INSERT INTO clans (name, tag, status, owner_id, created_by) VALUES (^"%s^",^"%s^",%d,%d,%d" ,     Player[id][pTemporaryClanName],Player[id][pTemporaryClanTag],CLAN_STATUS_ACTIVE,Player[id][pID],Player[id][pID]);
    SQL_ThreadQuery(DatabaseHandle, "@SQLCallback_RegisterClan", Query, queryData, QueryDataEnum);
    log_amx("AddClan(id: %d) => %s", id, Query);
    
    queryData[ qdeTransType ] = qd_AddMembers;
    formatex(Query, charsmax(Query),"INSERT INTO clans_members (clan_id, player_id, privilegies) VALUES ((SELECT id FROM clans ORDER BY id DESC LIMIT 1),%d,%d" , Player[id][pID],CLAN_MEMBER_PRIVILEGIES_ALL);
    SQL_ThreadQuery(DatabaseHandle, "@SQLCallback_RegisterClan", Query, queryData, QueryDataEnum);
    log_amx("AddClanMember(id: %d) => %s", id, Query);
    
    queryData[ qdeTransType ] = qd_GetClans;
    formatex(Query, charsmax(Query),"SELECT * FROM clans ORDER BY id DESC LIMIT 1;");
    SQL_ThreadQuery(DatabaseHandle, "@SQLCallback_RegisterClan", Query, queryData, QueryDataEnum);
    log_amx("GetClans(id: %d) => %s", id, Query);
} 


[yagami]

Originally Posted by Bugsy SQL_Execute() can interrupt gameplay. I typically only use it at plugin_cfg()/plugin_init() to create tables and stuff. So I'd stick with SQL_ThreadQuery(). Try something like this: PHP Code: enum QueryData_RegisterClan {     qd_AddClan,     qd_AddMembers,     qd_GetClans } enum _:QueryDataEnum {     qde_PlayerId,     QueryData_RegisterClan:qdeTransType } SQLQuery_RegisterClan(id) {     new queryData[ QueryDataEnum ];          queryData[ qde_PlayerId ] = id;          queryData[ qdeTransType ] = qd_AddClan;     formatex(Query, charsmax(Query),"INSERT INTO clans (name, tag, status, owner_id, created_by) VALUES (^"%s^",^"%s^",%d,%d,%d" ,     Player[id][pTemporaryClanName],Player[id][pTemporaryClanTag],CLAN_STATUS_ACTIVE,Player[id][pID],Player[id][pID]);     SQL_ThreadQuery(DatabaseHandle, "@SQLCallback_RegisterClan", Query, queryData, QueryDataEnum);     log_amx("AddClan(id: %d) => %s", id, Query);          queryData[ qdeTransType ] = qd_AddMembers;     formatex(Query, charsmax(Query),"INSERT INTO clans_members (clan_id, player_id, privilegies) VALUES ((SELECT id FROM clans ORDER BY id DESC LIMIT 1),%d,%d" , Player[id][pID],CLAN_MEMBER_PRIVILEGIES_ALL);     SQL_ThreadQuery(DatabaseHandle, "@SQLCallback_RegisterClan", Query, queryData, QueryDataEnum);     log_amx("AddClanMember(id: %d) => %s", id, Query);          queryData[ qdeTransType ] = qd_GetClans;     formatex(Query, charsmax(Query),"SELECT * FROM clans ORDER BY id DESC LIMIT 1;");     SQL_ThreadQuery(DatabaseHandle, "@SQLCallback_RegisterClan", Query, queryData, QueryDataEnum);     log_amx("GetClans(id: %d) => %s", id, Query); }

But then I would have to create several enums one for each request?

[Bugsy]

If you do not need to take specific action based on the result of the individual queries, no.