Alexandru Alex

sper sa fie cum zictu, acum compilez si verific

[22:29:19 05/01/20] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column '5' in 'where clause' (Query: "UPDATE `users` SET `Pin` = `8` WHERE `id` = `5`") [18:31:09 05/02/20] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column '4' in 'where clause' (Query: "UPDATE `users` SET `Pin` = `{` WHERE `id` = `4`") [22:55:30 05/02/20] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ID`='4'' at line 1 (Query: "UPDATE `users` SET `Pin'='8' WHERE `ID`='4'") [22:58:32 05/02/20] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ID`='4'' at line 1 (Query: "UPDATE `users` SET `Pin'='8' WHERE `ID`='4'") [00:16:53 05/03/20] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ID`='4'' at line 1 (Query: "UPDATE `users` SET `Pin'='2104' WHERE `ID`='4'") [00:19:22 05/03/20] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ID`='2104'' at line 1 (Query: "UPDATE `users` SET `Pin'='e' WHERE `ID`='2104'") [00:37:39 05/03/20] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ID`='4'' at line 1 (Query: "UPDATE `users` SET `Pin'='8' WHERE `ID`='4'") [00:43:05 05/03/20] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ID`='4'' at line 1 (Query: "UPDATE `users` SET `Pin'='8' WHERE `ID`='4'") [00:46:07 05/03/20] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ID`='4'' at line 1 (Query: "UPDATE `users` SET `Pin'='8' WHERE `ID`='4'") [00:48:15 05/03/20] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ID`='4'' at line 1 (Query: "UPDATE `users` SET `Pin'='8' WHERE `ID`='4'") [00:49:56 05/03/20] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ID`='4'' at line 1 (Query: "UPDATE `users` SET `Pin'='8' WHERE `ID`='4'") [00:51:44 05/03/20] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ID`='4'' at line 1 (Query: "UPDATE `users` SET `Pin'='8' WHERE `ID`='4'") [00:59:55 05/03/20] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ID`='4'' at line 1 (Query: "UPDATE `users` SET `Pin'='2104' WHERE `ID`='4'") [01:17:37 05/03/20] [WARNING] cache_get_row_count - no active cache [01:18:02 05/03/20] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ID`='6'' at line 1 (Query: "UPDATE `users` SET `Pin'='2104' WHERE `ID`='6'") [01:32:25 05/03/20] [WARNING] cache_get_row_count - no active cache [12:23:13 05/03/20] [WARNING] cache_get_row_count - no active cache [12:23:28 05/03/20] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ID`='8'' at line 1 (Query: "UPDATE `users` SET `Pin'='2104' WHERE `ID`='8'") [13:36:37 05/03/20] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ID`='8'' at line 1 (Query: "UPDATE `users` SET `Pin'='2104' WHERE `ID`='8'") [13:43:20 05/03/20] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ID`='8'' at line 1 (Query: "UPDATE `users` SET `Pin'='2104' WHERE `ID`='8'") [13:49:10 05/03/20] [WARNING] cache_get_row_count - no active cache [13:49:25 05/03/20] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ID`='9'' at line 1 (Query: "UPDATE `users` SET `Pin'='1234' WHERE `ID`='9'") [13:53:03 05/03/20] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ID`='9'' at line 1 (Query: "UPDATE `users` SET `Pin'='2103' WHERE `ID`='9'") [13:56:28 05/03/20] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ID`='9'' at line 1 (Query: "UPDATE `users` SET `Pin'='2103' WHERE `ID`='9'") Mysql_log iar in baza de date am Pin int(10) No None

Ma poate ajuta cineva?

Pai am testat deja si nu merge

Nu merge

CMD:setpin(playerid, params[]) { if(playerVariables[playerid][pPin] != 0) return SCM(playerid, COLOR_LIGHTGREEN3, "Ai deja un pin setat!\nFoloseste comanda [/pin] pentru a te loga!"); ShowPlayerDialogEx(playerid, DIALOG_SETPIN, DIALOG_STYLE_INPUT, "Set Pin", "Seteza-ti pinul!\nPinul trebuie sa contina 4 numere!", "Ok", "Exit"); return 1; } CMD:pin(playerid, params[]) { if(playerVariables[playerid][pPinLogged] == 1) return SCM(playerid, COLOR_LIGHTGREEN3, "Deja te-ai logat cu pin-ul tau!"); if(playerVariables[playerid][pPin] == 0) return SCM(playerid, COLOR_LIGHTGREEN3, "Nu ai un pin setat!\nFoloseste comanda [/setpin] pentru ati seta unul!"); ShowPlayerDialogEx(playerid, DIALOG_PIN, DIALOG_STYLE_INPUT, " Login Pin", "Conecteaza-te cu pinul setat de tine!", "Ok", "Exit"); return 1; } CMD:changepin(playerid, params[]) { if(playerVariables[playerid][pPin] == 0) return SCM(playerid, COLOR_LIGHTGREEN3, "Nu ai un pin setat!\nFoloseste comanda [/setpin] pentru ati seta unul!"); if(playerVariables[playerid][pPinLogged] == 0) return SCM(playerid, COLOR_LIGHTGREEN3, "Pentru ati schimba pinul trebuie sa fi logat cu el!"); ShowPlayerDialogEx(playerid, DIALOG_CHANGEPIN, DIALOG_STYLE_INPUT, " Change Pin", "Conecteaza-te cu pinul setat de tine!", "Ok", "Exit"); return 1; } switch(dialogid) { case DIALOG_SETPIN: { if(!response) return 1; if(!IsNumeric(inputtext)) return SCM(playerid, COLOR_LIGHTGREEN3, "Pinul trebuie sa contina doar numere!"); if(strlen(inputtext) > 4) return SCM(playerid, COLOR_LIGHTGREEN3, "Pinul trebuie sa fie format din 4 numere!"); if(strlen(inputtext) < 4) return SCM(playerid, COLOR_LIGHTGREEN3, "Pinul trebuie sa fie format din 4 numere!"); new pin = strval(inputtext); playerVariables[playerid][pPin] = pin; playerVariables[playerid][pPinLogged] = 1; format(string, sizeof(string), "Pinul tau este %d!", pin); SCM(playerid, COLOR_ORANGE, string); new query[180]; format(query, sizeof(query), "UPDATE `users` SET `Pin'='%s' WHERE `ID`='%d'", pin, playerVariables[playerid][pSQLID]); mysql_query(SQL, query); } case DIALOG_PIN: { if(!response) return 1; new pin = strval(inputtext); if(playerVariables[playerid][pPin] != pin) return SCM(playerid, COLOR_RED, "Pin-ul introdus este Invalid!"); playerVariables[playerid][pPinLogged] = 1; SCM(playerid, COLOR_YELLOW, "Te-ai logat cu succes cu pin-ul setat de tine!"); } case DIALOG_CHANGEPIN: { if(!response) return 1; new pin = strval(inputtext); if(playerVariables[playerid][pPin] != pin) return SCM(playerid, COLOR_RED, "Pin-ul introdus este Invalid!"); ShowPlayerDialogEx(playerid, DIALOG_CHANGEPIN+1, DIALOG_STYLE_INPUT, "New Pin", "Seteaza-ti noul tau pin!", "Ok", "Exit"); } case DIALOG_CHANGEPIN+1: { if(!response) return 1; new pin = strval(inputtext); playerVariables[playerid][pPin] = pin; format(string, sizeof(string), "Noul tau pin este %d!", pin); SCM(playerid, COLOR_ORANGE, string); new query[180]; format(query, sizeof(query), "UPDATE `users` SET `Pin`='%s' WHERE `ID`='%d'", pin, playerVariables[playerid][pSQLID]); mysql_query(SQL, query); } } Cand scriu /setpin imi aleg pin-ul dar nu mi se pune in baza de date.. Ce as putea face?

Am facu si eu un sistem de pin pe dialog si la testare imi da kick pe motivul dialog hider function OnDialogResponse(playerid, dialogid, response, listitem, inputtext[]) { new string[500]; if(dialogID[playerid] == -1) return AdmBot(playerid, "Dialog Hider"); dialogID[playerid] = -1; new bool:anuntat = false; if(!isnull(inputtext)) { for(new _pos; inputtext[_pos] > 0; _pos++){ if(inputtext[_pos] == '%') { inputtext[_pos] = '#'; if(!anuntat) { anuntat = true; } } } } switch(dialogid) { case DIALOG_SETPIN: { if(!response) return 1; if(!IsNumeric(inputtext)) return SCM(playerid, COLOR_LIGHTGREEN3, "Pinul trebuie sa contina doar numere!"); if(strlen(inputtext) > 4) return SCM(playerid, COLOR_LIGHTGREEN3, "Pinul trebuie sa fie format din 4 numere!"); new pin = strval(inputtext); playerVariables[playerid][pPin] = pin; playerVariables[playerid][pPinLogged] = 1; format(string, sizeof(string), "Pinul tau este %d", pin); SCM(playerid, COLOR_ORANGE, string); new query[180]; mysql_query(SQL, query); } case DIALOG_PIN: { if(!response) return 1; new pin = strval(inputtext); if(playerVariables[playerid][pPin] != pin) return SCM(playerid, COLOR_RED, "Pin Invalid!"); playerVariables[playerid][pPinLogged] = 1; SCM(playerid, COLOR_YELLOW, "Te-ai logat cu succes cu pin-ul setat de tine!"); } case DIALOG_CHANGEPIN: { if(!response) return 1; new pin = strval(inputtext); if(playerVariables[playerid][pPin] != pin) return SCM(playerid, COLOR_RED, "Pin Invalid!"); ShowPlayerDialog(playerid, DIALOG_CHANGEPIN+1, DIALOG_STYLE_INPUT, "New Pin", "Seteaza-ti noul tau pin!", "Ok", "Exit"); } case DIALOG_CHANGEPIN+1: { if(!response) return 1; new pin = strval(inputtext); playerVariables[playerid][pPin] = pin; format(string, sizeof(string), "Noul tau pin este %d", pin); SCM(playerid, COLOR_ORANGE, string); new query[180]; mysql_query(SQL, query); } }