[Micko123]

Okay I want to make /createdrugs cmd and it is creating it and everything.

PHP код:

CMD:createdrugs(playerid)
{
    if(PlayerInfo[playerid][Admin] < 5)
    {
        ERROR(playerid, "You are not allowed to use that command");
        return 1;
    }
    new Float:X, Float:Y, Float:Z, place, query[128];
    GetPlayerPos(playerid, X, Y, Z);
    DrugsPickup[place] = CreateDynamicPickup(1279, 1, X, Y, Z);
    DrugsLabel[place] = CreateDynamic3DTextLabel(""SERVERBLUE"[ DRUGS ]\n"WHITE"To buy drugs type /buydrugs", 0x1D9F00AA, X, Y, Z,  10.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 20.0);
    DrugsInfo[place][ID] = cache_insert_id();
    DrugsInfo[place][dPosX] = X;
    DrugsInfo[place][dPosY] = Y;
    DrugsInfo[place][dPosZ] = Z;
    mysql_format(g_SQL, query, sizeof(query), "INSERT INTO `drugs` (`ID`, `X`, `Y`, `Z`) VALUES (%d, %f, %f, %f)", cache_insert_id(), X, Y, Z);
    mysql_tquery(g_SQL, query);
    return 1;
} 


How can I make that Id increase everytime I type command. Table ID has Auto-Increasment..

Don't laught to me I am begginer

[Konstantinos]

You specify a callback in mysql_tquery and call cache_insert_id() in there.

[Micko123]

I did it like this

PHP код:

mysql_format(g_SQL, query, sizeof(query), "INSERT INTO `drugs` (`X`, `Y`, `Z`) VALUES (%d, %f, %f, %f)", X, Y, Z);
    mysql_tquery(g_SQL, query, "CreatePickupA");

forward CreatePickupA(place);
public CreatePickupA(place)
{
    DrugsInfo[place][ID] = cache_insert_id();
    return 1;
} 


And housl tquery go like this??

[Micko123]

Okay I did that and it is saving. But problem is that every ID is 0.. any fix?

[oMa37]

PHP код:

mysql_tquery(g_SQL, query, "CreatePickupA", "i", place); 


[Micko123]

I did this

PHP код:

Iter_Add(i_Drugs, id);
     mysql_format(g_SQL, query, sizeof(query), "INSERT INTO `drugs` (`X`, `Y`, `Z`) VALUES (%f, %f, %f)", X, Y, Z);
    mysql_tquery(g_SQL, query, "CreatePickupA", "d", id); 


Still the same. ID is 0 for every pickup

[oMa37]

PHP код:

CMD:createdrugs(playerid) 
{ 
    if(PlayerInfo[playerid][Admin] < 5) 
    { 
        ERROR(playerid, "You are not allowed to use that command"); 
        return 1; 
    }
    new Float:X, Float:Y, Float:Z, query[128]; 
    GetPlayerPos(playerid, X, Y, Z); 
    new id = Iter_Free(i_Drugs);
    DrugsPickup[id] = CreateDynamicPickup(1279, 1, X, Y, Z); 
    DrugsLabel[id] = CreateDynamic3DTextLabel(""SERVERBLUE"[ DRUGS ]\n"WHITE"To buy drugs type /buydrugs", 0x1D9F00AA, X, Y, Z,  10.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 20.0); 
    DrugsInfo[id][dPosX] = X; 
    DrugsInfo[id][dPosY] = Y; 
    DrugsInfo[id][dPosZ] = Z;
    mysql_format(g_SQL, query, sizeof(query), "INSERT INTO `drugs` (`X`, `Y`, `Z`) VALUES (%f, %f, %f)", X, Y, Z); 
    mysql_tquery(g_SQL, query, "CreatePickupA", "i", id);
    return 1; 
}  
forward CreatePickupA(id);
public CreatePickupA(id)
{
    DrugsInfo[id][ID] = cache_insert_id();
    Iter_Add(i_Drugs, id);
    return 1;
} 


[Micko123]

Okay there is problem. It won't let me check Auto-Increasment box.
It gives me this

Incorrect table definition; there can be only one auto column and it must be defined as a key

EDIT: FIXED!!!
Thank you all