InceMan

fa uploade la mysq.so si sscanf.so

la public OnPlayerDisconnect(playerid, reason) pui asa new qqerry[128]; mysql_format(SQL,qqerry, sizeof(qqerry), "UPDATE `users` SET `Status` = '0' WHERE `id` = '%d'", PlayerInfo[playerid][pSQLID]); mysql_tquery(SQL,qqerry,"",""); si la public OnPlayerLogin UPDATE `users` SET `Status` = '1

ei bine na acuma respecta si tu macar regulamentul de postare dupa o sa ai si rezultate!

https://wiki.sa-mp.com/wiki/GangZoneShowForPlayer

EDITOR_OBJECT[objectid][OBJ_X] = x; EDITOR_OBJECT[objectid][OBJ_Y] = y; EDITOR_OBJECT[objectid][OBJ_Z] = z; EDITOR_OBJECT[objectid][OBJ_RX] = rx; EDITOR_OBJECT[objectid][OBJ_RY] = ry; EDITOR_OBJECT[objectid][OBJ_RZ] = rz; SetDynamicObjectPos(objectid,x,y,z); SetDynamicObjectRot(objectid,rx,ry,rz); new EDITOR_QUERY[256]; format(EDITOR_QUERY, sizeof(EDITOR_QUERY), "UPDATE `OBJECTS` SET `X`='%f', `Y`='%f', `Z`='%f', `RX`='%f', `RY`='%f', `RZ`='%f' WHERE `ID`=%d", EDITOR_OBJECT[objectid][OBJ_X], EDITOR_OBJECT[objectid][OBJ_Y], EDITOR_OBJECT[objectid][OBJ_Z], EDITOR_OBJECT[objectid][OBJ_RX], EDITOR_OBJECT[objectid][OBJ_RY], EDITOR_OBJECT[objectid][OBJ_RZ], EDITOR_OBJECT[objectid][OBJ_DB_ID]); db_free_result(db_query(EDITOR_DATABASE, EDITOR_QUERY));/// se salveaza aici nu mai inteleg nici eu

ok incearca sa pui asa Update(playerid,pGift); finca se salveaza doar in PlayerInfo[playerid][pGift],

si la baza de date ai tabelul Gift ?

aratane ce aveti la public Update(playerid

am incercat ori me-a scapat ceva si nu am fost atent ca acelasi erori le am acum mai nou nu mai imi salveaza pozitia si locul la acela id object

finca comanda care o aveti nu comunica si cu baza de date doar cu serverul posibil nu ai comanda bine facuta ca sa comunice si cu baza de date, mai mult tie nu-ti salveaza acele 20 de puncte incearca sa ii pui ceva de genul Update(id,pPremiumPointsx);

Pasul 1 Primul lucru pe care trebuie sa il faceti este sa adaugati aceasta variabila, pday langa celelalte de la pinfo enum pInfo { //// pDay, }; new PlayerInfo[MAX_PLAYERS][pInfo]; Pasul 2 Acum va trebuie sa stocam aceasta data, o vom salva si desigur o vom incarca cand jucatorul va intra pe server Adaugam langa celelalte la OnPlayerRegister format(var, 32, "pDay=%d\n",PlayerInfo[playerid][pDay]);fwrite(hFile, var); Pentru a salva adaugam langa celelalte la SavePlayerData format(var, 32, "pDay=%d\n",PlayerInfo[playerid][pDay]);fwrite(hFile, var); Iar cand jucatorul intra pe server, adaugam langa celelalte la OnPlayerLogin if( strcmp( key , "pDay" , true ) == 0 ) { val = ini_GetValue( Data ); PlayerInfo[playerid][pDay] = strval( val ); } Pasul 3 In acest pas trebuie sa determinam timpul pe care trebuie sa il indeplineasca utilizatorul pt a lua paycheck Mergem la OnPlayerConnect si adaugam jos de tot langa celelalte PlayerInfo[playerid][pDay] = 3600; // 3600 inseamna o ora in secunde Pasul 4 Ca sa creeam timpul scurs trebuie sa adaugam urmatorul cod la public OtherTime if(PlayerInfo[i][pDay] >= 0) { PlayerInfo[i][pDay]--; if(PlayerInfo[i][pDay] <= 0) { PlayerInfo[i][pDay] = 3600; PayDay(); } } Pasul 5 Aici am creeat special comanda pentru acest sistem, deci toate creditele imi vin mie CMD:pday(playerid, params[]) { if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_GRAD1, "You havent logged in yet !"); new ttext[20]; if(PlayerInfo[playerid][pMember] == 4 || PlayerInfo[playerid][pLeader] == 4) { ttext = "Medic"; } else if(gTeam[playerid] == 3) { ttext = "Civilian"; } else if(PlayerInfo[playerid][pMember] == 1 || PlayerInfo[playerid][pLeader] == 1) { ttext = "Police Departament"; } else if(PlayerInfo[playerid][pMember] == 2 || PlayerInfo[playerid][pLeader] == 2) { ttext = "FBI Agent"; } else if(PlayerInfo[playerid][pMember] == 3 || PlayerInfo[playerid][pLeader] == 3) { ttext = "National Guard"; } else if(PlayerInfo[playerid][pMember] == 4 || PlayerInfo[playerid][pLeader] == 4) { ttext = "Firemen/Paramedic"; } else if(PlayerInfo[playerid][pMember] == 5 || PlayerInfo[playerid][pLeader] == 5) { ttext = "LCN"; } else if(PlayerInfo[playerid][pMember] == 6 || PlayerInfo[playerid][pLeader] == 6) { ttext = "Yakuza"; } else if(PlayerInfo[playerid][pMember] == 8 || PlayerInfo[playerid][pLeader] == 8) { ttext = "Hitmen"; } else if(PlayerInfo[playerid][pMember] == 9 || PlayerInfo[playerid][pLeader] == 9) { ttext = "News Reporter"; } else if(PlayerInfo[playerid][pMember] == 10 || PlayerInfo[playerid][pLeader] == 10) { ttext = "Taxi"; } else if(PlayerInfo[playerid][pMember] == 11 || PlayerInfo[playerid][pLeader] == 11) { ttext = "FMA"; } else if(PlayerInfo[playerid][pMember] == 12 || PlayerInfo[playerid][pLeader] == 12) { ttext = "Crips Gang"; } else if(PlayerInfo[playerid][pMember] == 13 || PlayerInfo[playerid][pLeader] == 13) { ttext = "Bloods Gang"; } else if(PlayerInfo[playerid][pMember] == 14 || PlayerInfo[playerid][pLeader] == 14) { ttext = "Surenos Gang"; } else if(PlayerInfo[playerid][pMember] == 15 || PlayerInfo[playerid][pLeader] == 15) { ttext = "Nortenos Gang"; } new coordsstring[256]; new plevel = PlayerInfo[playerid][pLevel]; new ptime = PlayerInfo[playerid][pConnectTime]; new pday = PlayerInfo[playerid][pDay]; new name[MAX_PLAYER_NAME]; GetPlayerName(playerid, name, sizeof(name)); SendClientMessage(playerid, COLOR_GREEN,"________________________________________________________________________________________"); format(coordsstring, sizeof(coordsstring)," xxx [ %s - Level %d, %s] xxx",name,plevel,ttext); SendClientMessage(playerid, COLOR_LIGHTGREEN,coordsstring); format(coordsstring, sizeof(coordsstring),"» NextPay [%d] OnlineHours [%d]",pday/60,ptime); SendClientMessage(playerid, 0xCFCFCFFF,coordsstring); SendClientMessage(playerid, COLOR_GREEN,"________________________________________________________________________________________"); return 1; } Pasul 6 Aici trebuie sa eliminati payday-ul anterior care va venea la si fix, cum faceti asta ? Simplu, inlocuiti SyncTime cu acesta de mai jos public SyncTime() { new string[64]; new tmphour; new tmpminute; new tmpsecond; gettime(tmphour, tmpminute, tmpsecond); FixHour(tmphour); tmphour = shifthour; if ((tmphour > ghour) || (tmphour == 0 && ghour == 23)) { format(string, sizeof(string), "SERVER: The time is now %d:00 hours",tmphour+1); BroadCast(COLOR_WHITE,string); ghour = tmphour; if (realtime) { SetWorldTime(tmphour); }

pai manuesc ca ai pe baza de sql si inde ai house este ceva de genu ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=467 ; /// modifici valoare aia cu numarul de case care il ai + ce ai adaugat tu daca e 200 de case pui 201 si tot asa

new DB:EDITOR_DATABASE; public OnFilterScriptInit() { print("SA-MP Object Edit-Save-Load"); EDITOR_DATABASE = db_open("objects.db"); FUNCTION_LoadObjects(); return 1; } public OnPlayerEditDynamicObject(playerid, objectid, response, Float:x, Float:y, Float:z)/// edit { EDITOR_OBJECT[objectid][OBJ_X] = x; EDITOR_OBJECT[objectid][OBJ_Y] = y; EDITOR_OBJECT[objectid][OBJ_Z] = z; EDITOR_OBJECT[objectid][OBJ_RX] = rx; EDITOR_OBJECT[objectid][OBJ_RY] = ry; EDITOR_OBJECT[objectid][OBJ_RZ] = rz; SetDynamicObjectPos(objectid,x,y,z); SetDynamicObjectRot(objectid,rx,ry,rz); new EDITOR_QUERY[256]; format(EDITOR_QUERY, sizeof(EDITOR_QUERY), "UPDATE `OBJECTS` SET `X`='%f', `Y`='%f', `Z`='%f', `RX`='%f', `RY`='%f', `RZ`='%f' WHERE `ID`=%d", EDITOR_OBJECT[objectid][OBJ_X], EDITOR_OBJECT[objectid][OBJ_Y], EDITOR_OBJECT[objectid][OBJ_Z], EDITOR_OBJECT[objectid][OBJ_RX], EDITOR_OBJECT[objectid][OBJ_RY], EDITOR_OBJECT[objectid][OBJ_RZ], EDITOR_OBJECT[objectid][OBJ_DB_ID]); db_free_result(db_query(EDITOR_DATABASE, EDITOR_QUERY)); return 1; } public FUNCTION_LoadObjects() { new DBResult:EDITOR_RESULT,IDX; EDITOR_RESULT = db_query(EDITOR_DATABASE, "SELECT * FROM `OBJECTS`"); if(db_num_rows(EDITOR_RESULT) > 0) // Logged In { new EDITOR_VALEU[26][11],id; for (new x=0; x<db_num_rows(EDITOR_RESULT); x++) { IDX = 0; db_get_field_assoc(EDITOR_RESULT, "ID", EDITOR_VALEU[IDX], 26),IDX++; db_get_field_assoc(EDITOR_RESULT, "MODEL", EDITOR_VALEU[IDX], 26),IDX++; db_get_field_assoc(EDITOR_RESULT, "X", EDITOR_VALEU[IDX],26),IDX++; db_get_field_assoc(EDITOR_RESULT, "Y", EDITOR_VALEU[IDX],26),IDX++; db_get_field_assoc(EDITOR_RESULT, "Z", EDITOR_VALEU[IDX],26),IDX++; db_get_field_assoc(EDITOR_RESULT, "RX", EDITOR_VALEU[IDX],26),IDX++; db_get_field_assoc(EDITOR_RESULT, "RY", EDITOR_VALEU[IDX],26),IDX++; db_get_field_assoc(EDITOR_RESULT, "RZ", EDITOR_VALEU[IDX],26),IDX++; db_get_field_assoc(EDITOR_RESULT, "VW", EDITOR_VALEU[IDX],26),IDX++; db_get_field_assoc(EDITOR_RESULT, "INT", EDITOR_VALEU[IDX],26),IDX++; db_get_field_assoc(EDITOR_RESULT, "DISTANCE", EDITOR_VALEU[IDX],26); id = CreateDynamicObject(strval(EDITOR_VALEU[1]), floatstr( EDITOR_VALEU[2]),floatstr(EDITOR_VALEU[3]),floatstr(EDITOR_VALEU[4]), floatstr( EDITOR_VALEU[5]),floatstr(EDITOR_VALEU[6]),floatstr(EDITOR_VALEU[7]), strval(EDITOR_VALEU[8]), strval(EDITOR_VALEU[9]),-1, floatstr(EDITOR_VALEU[10])); if(id > DEF_MAX_OBJECTS) return SendClientMessageToAll(DEF_COL_WHITE,"Error while loading objects, it seems you are trying to load more objects then the max amount of objects."); EDITOR_OBJECT[id][OBJ_DB_ID] = strval(EDITOR_VALEU[0]); EDITOR_OBJECT[id][OBJ_MODEL] = strval(EDITOR_VALEU[1]); EDITOR_OBJECT[id][OBJ_X] = floatstr(EDITOR_VALEU[2]); EDITOR_OBJECT[id][OBJ_Y] = floatstr(EDITOR_VALEU[3]); EDITOR_OBJECT[id][OBJ_Z] = floatstr(EDITOR_VALEU[4]); EDITOR_OBJECT[id][OBJ_RX] = floatstr(EDITOR_VALEU[5]); EDITOR_OBJECT[id][OBJ_RY] = floatstr(EDITOR_VALEU[6]); EDITOR_OBJECT[id][OBJ_RZ] = floatstr(EDITOR_VALEU[7]); EDITOR_OBJECT[id][OBJ_VW] = strval(EDITOR_VALEU[8]); EDITOR_OBJECT[id][OBJ_INTERIOR] = strval(EDITOR_VALEU[9]); EDITOR_OBJECT[id][OBJ_STREAM_DISTANCE] = floatstr(EDITOR_VALEU[10]); db_next_row(EDITOR_RESULT); } } new string[128]; format(string,sizeof(string),"%d objects have been loaded.",db_num_rows(EDITOR_RESULT)); SendClientMessageToAll(DEF_COL_WHITE,string); db_free_result(EDITOR_RESULT); return 1; }

daca nu vii cu un model de postare nu te pot ajuta banuesc ca trebuie creat o fctiune de stock cu cordonatele respective IfAaventurier

da mysql_format mysql_tquery de asta am zis trebuie sai facu o baza de date cu cordonatele gamemod-ului

am sa verific maine cu mai multa atentie acum sunt obosit revin cu raspuns daca am rezolvat ceva !

am incercat si asta si tot imi da erorile alea in log

pai astai problema ca eu am doar o baza temporara ea find in scriptfiles object.db UP

daca nu vii cu sursa ceva nu stim la ce vrei sa te referi ca sunt 10000 de gamemod-uri diferite poate te referi la ceva de genul new HouseInfo[120][hInfo]

Problema intalnita (descriere): am gasit un system util de createobject dynamic idea este ca cand creez un object in samp se creaza dar nu se salveaza si in log imi da erori ceva de genul [20:09:20] Andu has been connected to the server (IP: 46.102.90.25). [20:09:53] [Error] db_query: invalid database handle 0 [20:09:53] [Error] db_free_result(): invalid result handle 0 [20:09:53] [Error] db_query: invalid database handle 0 [20:09:53] [Error] db_num_rows(): invalid result handle 0 [20:09:53] [Error] db_free_result(): invalid result handle 0 [20:09:53] [Error] db_query: invalid database handle 0 [20:09:53] [Error] db_free_result(): invalid result handle 0 [20:10:04] [Error] db_query: invalid database handle 0 [20:10:04] [Error] db_free_result(): invalid result handle 0 [20:10:04] [Error] db_query: invalid database handle 0 [20:10:04] [Error] db_free_result(): invalid result handle 0 [20:10:04] [Error] db_query: invalid database handle 0 [20:10:04] [Error] db_free_result(): invalid result handle 0 [20:10:05] [Error] db_query: invalid database handle 0 [20:10:05] [Error] db_free_result(): invalid result handle 0 [20:10:05] [Error] db_query: invalid database handle 0 [20:10:05] [Error] db_free_result(): invalid result handle 0 [20:10:05] [Error] db_query: invalid database handle 0 [20:10:05] [Error] db_free_result(): invalid result handle 0 [20:10:07] [Error] db_query: invalid database handle 0 [20:10:07] [Error] db_free_result(): invalid result handle 0 [20:10:08] [Error] db_query: invalid database handle 0 [20:10:08] [Error] db_free_result(): invalid result handle 0 [20:10:08] [Error] db_query: invalid database handle 0 [20:10:08] [Error] db_free_result(): invalid result handle 0 [20:10:08] [Error] db_query: invalid database handle 0 [20:10:08] [Error] db_free_result(): invalid result handle 0 [20:10:10] [Error] db_query: invalid database handle 0 [20:10:10] [Error] db_free_result(): invalid result handle 0 [20:10:10] [Error] db_query: invalid database handle 0 [20:10:10] [Error] db_free_result(): invalid result handle 0 [20:10:11] [Error] db_query: invalid database handle 0 [20:10:11] [Error] db_free_result(): invalid result handle 0 [20:10:11] [Error] db_query: invalid database handle 0 [20:10:11] [Error] db_free_result(): invalid result handle 0 [20:10:11] [Error] db_query: invalid database handle 0 [20:10:11] [Error] db_free_result(): invalid result handle 0 [20:10:12] [Error] db_query: invalid database handle 0 [20:10:12] [Error] db_free_result(): invalid result handle 0 [20:10:12] [Error] db_query: invalid database handle 0 [20:10:12] [Error] db_free_result(): invalid result handle 0 [20:10:12] [Error] db_query: invalid database handle 0 [20:10:12] [Error] db_free_result(): invalid result handle 0 [20:10:14] [Error] db_query: invalid database handle 0 [20:10:14] [Error] db_free_result(): invalid result handle 0 deci nu se salveaza cu configul objects.db ma intreb oare trebuie sai fac o baza de date ?Liniile de cod / sursa / script-ul(obligatoriu): public OnDialogResponse if(dialogid == 10002 && response) { if(!Numbers(inputtext) && strval(inputtext) != -1) return SendClientMessage(playerid,DEF_COL_RED,"You only can use numbers!"),ShowPlayerDialog(playerid,10001,DIALOG_STYLE_LIST,"{A80000}Edit Object","Position\nVirtual World\nInterior ID\nStream Distance\nDelete Object","Next","Close"); new id = EDIT_OBJECT_ID[playerid]; new EDITOR_QUERY[256]; format(EDITOR_QUERY, sizeof(EDITOR_QUERY), "UPDATE `OBJECTS` SET `VW`=%d WHERE `ID`=%d", strval(inputtext), EDITOR_OBJECT[id][OBJ_DB_ID]); db_free_result(db_query(EDITOR_DATABASE, EDITOR_QUERY)); SendClientMessage(playerid,DEF_COL_WHITE,"You successful changed to virtualworld of this object."); return ShowPlayerDialog(playerid,10001,DIALOG_STYLE_LIST,"{A80000}Edit Object","Position\nVirtual World\nInterior ID\nStream Distance\nDelete Object","Next","Close"); } if(dialogid == 10003 && response) { if(!Numbers(inputtext) && strval(inputtext) != -1) return SendClientMessage(playerid,DEF_COL_RED,"You only can use numbers!"),ShowPlayerDialog(playerid,10001,DIALOG_STYLE_LIST,"{A80000}Edit Object","Position\nVirtual World\nInterior ID\nStream Distance\nDelete Object","Next","Close"); new id = EDIT_OBJECT_ID[playerid]; new EDITOR_QUERY[256]; format(EDITOR_QUERY, sizeof(EDITOR_QUERY), "UPDATE `OBJECTS` SET `INT`=%d WHERE `ID`=%d", strval(inputtext), EDITOR_OBJECT[id][OBJ_DB_ID]); db_free_result(db_query(EDITOR_DATABASE, EDITOR_QUERY)); SendClientMessage(playerid,DEF_COL_WHITE,"You successful changed to interior of this object."); return ShowPlayerDialog(playerid,10001,DIALOG_STYLE_LIST,"{A80000}Edit Object","Position\nVirtual World\nInterior ID\nStream Distance\nDelete Object","Next","Close"); } if(dialogid == 10004 && response) { if(!Numbers(inputtext) && strval(inputtext) != -1) return SendClientMessage(playerid,DEF_COL_RED,"You only can use numbers!"),ShowPlayerDialog(playerid,10001,DIALOG_STYLE_LIST,"{A80000}Edit Object","Position\nVirtual World\nInterior ID\nStream Distance\nDelete Object","Next","Close"); new id = EDIT_OBJECT_ID[playerid]; new EDITOR_QUERY[256]; format(EDITOR_QUERY, sizeof(EDITOR_QUERY), "UPDATE `OBJECTS` SET `DISTANCE`=%d WHERE `ID`=%d", strval(inputtext), EDITOR_OBJECT[id][OBJ_DB_ID]); db_free_result(db_query(EDITOR_DATABASE, EDITOR_QUERY)); SendClientMessage(playerid,DEF_COL_WHITE,"You successful changed to distance of this object."); return ShowPlayerDialog(playerid,10001,DIALOG_STYLE_LIST,"{A80000}Edit Object","Position\nVirtual World\nInterior ID\nStream Distance\nDelete Object","Next","Close"); } if(dialogid == 10001 && response) { if(listitem == 0) { EditDynamicObject(playerid, EDIT_OBJECT_ID[playerid]); return SendClientMessage(playerid,DEF_COL_WHITE,"Usage ESC or the save icon to save the position."); } if(listitem == 1) { ShowPlayerDialog(playerid,10002,DIALOG_STYLE_INPUT,"{A80000}Virtual World","Insert the virtualworld you wan't to only stream this object in.\nUsage -1 to show it in all virtualworlds.","Save","Close"); } if(listitem == 2) { ShowPlayerDialog(playerid,10003,DIALOG_STYLE_INPUT,"{A80000}Virtual World","Insert the interior you wan't to only stream this object in.\nUsage -1 to show it in all interior\nUsage /interior to see your currently interior.","Save","Close"); } if(listitem == 3) { ShowPlayerDialog(playerid,10004,DIALOG_STYLE_INPUT,"{A80000}Virtual World","Insert the stream distance of this object. Default is 100.","Save","Close"); } if(listitem == 4) { new EDITOR_QUERY[256]; format(EDITOR_QUERY, sizeof(EDITOR_QUERY), "DELETE FROM `OBJECTS` WHERE `ID`=%d",EDITOR_OBJECT[EDIT_OBJECT_ID[playerid]][OBJ_DB_ID]); db_free_result(db_query(EDITOR_DATABASE, EDITOR_QUERY)); DestroyDynamicObject(EDIT_OBJECT_ID[playerid]); return SendClientMessage(playerid,DEF_COL_WHITE,"You succesful deleted this object."); } } if(dialogid == 10000 && response) { if(!Numbers(inputtext)) return SendClientMessage(playerid,DEF_COL_RED,"You only can use numbers!"),ShowPlayerDialog(playerid,10000,DIALOG_STYLE_INPUT,"{A80000}Insert Object ID","Insert the object ID that you wan't to create.","Create","Close"); new Float:editor[3],id; GetPlayerPos(playerid,editor[0],editor[1],editor[2]); id = CreateDynamicObject(strval(inputtext), editor[0]+1, editor[1]+1, editor[2], 0.0,0.0,0.0, -1, -1, -1, 100.0); if(id > DEF_MAX_OBJECTS) return SendClientMessageToAll(DEF_COL_WHITE,"Error while creating object, it seems you are trying to create more objects then the max amount of objects."); EDITOR_OBJECT[id][OBJ_MODEL] = strval(inputtext); EDITOR_OBJECT[id][OBJ_X] = editor[0]+1; EDITOR_OBJECT[id][OBJ_Y] = editor[1]+1; EDITOR_OBJECT[id][OBJ_Z] = editor[2]; EDITOR_OBJECT[id][OBJ_RX] = 0.0; EDITOR_OBJECT[id][OBJ_RY] = 0.0; EDITOR_OBJECT[id][OBJ_RZ] = 0.0; EDITOR_OBJECT[id][OBJ_VW] = -1; EDITOR_OBJECT[id][OBJ_INTERIOR] = -1; EDITOR_OBJECT[id][OBJ_STREAM_DISTANCE] = 100.0; EDIT_OBJECT_ID[playerid] = id; EditDynamicObject(playerid, id); new EDITOR_QUERY[256]; format(EDITOR_QUERY, sizeof(EDITOR_QUERY), "INSERT INTO `OBJECTS` (`MODEL`, `X`, `Y`, `Z`, `INT`) VALUES (%d,'%f','%f','%f',%d)", EDITOR_OBJECT[id][OBJ_MODEL], EDITOR_OBJECT[id][OBJ_X], EDITOR_OBJECT[id][OBJ_Y], EDITOR_OBJECT[id][OBJ_Z], id+1000); db_free_result(db_query(EDITOR_DATABASE, EDITOR_QUERY)); new DBResult:EDITOR_RESULT; format(EDITOR_QUERY,sizeof(EDITOR_QUERY),"SELECT `ID` FROM `OBJECTS` WHERE `INT`=%d",id+1000); EDITOR_RESULT = db_query(EDITOR_DATABASE,EDITOR_QUERY); if(db_num_rows(EDITOR_RESULT) == 1) { new temp[16]; db_get_field(EDITOR_RESULT,0,temp,16); EDITOR_OBJECT[id][OBJ_DB_ID] = strval(temp); SendClientMessage(playerid,DEF_COL_WHITE,"Object ID received."); } db_free_result(EDITOR_RESULT); format(EDITOR_QUERY, sizeof(EDITOR_QUERY), "UPDATE `OBJECTS` SET `INT`=-1 WHERE `ID`=%d",EDITOR_OBJECT[id][OBJ_DB_ID]); db_free_result(db_query(EDITOR_DATABASE, EDITOR_QUERY)); SendClientMessage(playerid,DEF_COL_WHITE,"Object saved to database, Usage /editobject or /selectobject to edit this object."); } Imagini / Video (optional):--Ati incercat sa rezolvati singur?: Da am incercat dar am obtinut rezultate

incearca sa pui dupa #include asta static const antisqlinjection[][] = { "'", "#", "`", "%e", "%s", "%d", "%f" }; si la OnDialogResponse adaugi asta for(new i; i < sizeof(antisqlinjection); i++) { if(strfind(inputtext, antisqlinjection, true) != -1) { SCM(playerid, -1, "Server protected by sistem FiveGame."); return 1; } }

frumos numai ca este prea incarcat in culori dar este bine 5/10

daca este obiectul din imagine este 1316

descurcate cauta vezi care iti sunt compatibile cu gm-ul

cauta pe google mysql plugins