Hello, The problem, is when I do that: Код: format(query,sizeof(query),"UPDATE cars SET realid='%d' WHERE id=%d",i,CarInfo[i][cID]); mysql_query(query); (id is a auto increment) The "realid" var...

Hello, This is my code: Код: mysql_query("SELECT * FROM cars"); mysql_store_result(); new i=1,query[256]; while(mysql_retrieve_row()) { format(query,sizeof(query),"UPDATE cars SE...

Sorry, I didn't say, but I had already reload it and don't work too..

Hello, This is my command for load plate number: (plaque(fr) = plate (en) ) Код: mysql_get_field("plaque",Field); CarInfo[i][cPlate] = strval(Field); And the code for create vehicle: Код:...

Resolve! to delete plz

to delete

bump !

I want to have the value of a float, I make this: Код: format(query, sizeof(query), "SELECT pos_x FROM cars WHERE id = %d LIMIT 1",i); mysql_query(query); mysql_store_result(); new Float:po...

Thank you

Ok, I did this: Код: format(query, sizeof(query), "SELECT model FROM cars WHERE id = %d LIMIT 1",i); mysql_query(query); CarInfo[i][cModel] = mysql_store_result(); printf("model: %d",CarInfo[i][c...

Hello, I would like to know how I can get the value of ID 3 in the field "Modelid" in mysql ? (in cars table) Regards

Oh, yes sorry Код: format(string, sizeof(string), "UPDATE players SET Mission=%d,Warnings=%d,VirWorld=%d,Fuel=%d,Married=%d,MarriedTo=%d,FishTool=%d,Note1='%s',Note1s=%d,Note2='%s',Note2s=%d...

Код: format(string, sizeof(string), "UPDATE players SET InvWeapon=%d,InvAmmo=%d,Lighter=%d,Cigarettes=%d,RequestingBackup=%d,Roadblock=%d,Mask=%d,Maskuse=%d,HideNumber=%d,Speaker=%d WHERE id=%...

Ok, I got this: Код: string: UPDATE players SET Mission=0,Warnings=0,VirWorld=0,Fuel=0,Married=78,MarriedTo=0,FishTool=78,Note1='',Note1s=78,Note2='',Note2s=78,Note3='',Note3s=78,Note4='',Note4s=...

How to debug the string(query) please ? UPDATE players SET Note1= '%s' WHERE id = '%d' don't work :/

Hello, There is my code who save the variable Note1: Код: format(string, sizeof(string), "UPDATE players SET Note1=%s WHERE id=%d", PlayerInfo[playerid][pNote1], PlayerInfo[pSQLID]); But, I got ...

Ah yes, I think he wanted to restrict is vehicle id 432 just !

Hello, OnPlayerEnterVehicle new vehicleid = GetPlayerVehicleID(playerid); if(vehicleid == 432) ... Regards

Hello, I have 3 questions about Mysql. NB: I use BlueG's R6 plugin. 1st question: To check if a value exists in a table, I make this: Code: new nplayer[MAX_PLAYER_NAME+1]; GetPlayerName(playerid,...

Now, I'm doing this: Код: new tmp; mysql_query("SELECT PlayerLevel FROM players LIMIT 1"); mysql_store_result(); tmp = mysql_fetch_int(); PlayerInfo[playerid][pLevel] = ...