public OnPlayerConnect(playerid) { new vardas [MAX_PLAYER_NAME], query[64]; GetPlayerName(playerid, vardas, sizeof(vardas)); format(query, sizeof(query), "SELECT `id` FROM `user` WHERE `vardas` = '%s'", vardas); mysql_function_query(manomysql, query, true, "OnUserCheck", "i", playerid); return 1; }
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[]) { if(dialogid == DIALOG_REGISTER) { if(response) { //Slaptaћodћio ilgis new Vardas[MAX_PLAYER_NAME], query[64], slaptazodis[32]; GetPlayerName(playerid, Vardas, sizeof(Vardas)); if(strlen(inputtext) >= 6) { mysql_escape_string(inputtext, slaptazodis, manomysql); format(query, sizeof(query), "INSERT INTO `user` (`vardas`, `slaptazodis`) VALUES ('%s', '%s')", Vardas, inputtext); mysql_function_query(manomysql, query, false, " ", " "); SendClientMessage(playerid, LIME, "Sėkmingai uћsiregistravote serveryje! Gero ћaidimo"); } else { SendClientMessage(playerid, MELYNA, "Slaptaћodis turi būti bent 6 simbolių ilgio!"); ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, "Registracija", "Praљome įvesti sugalvotą slaptaћodį!", "Registruotis", "Iљeiti"); } } else { Kick(playerid); SendClientMessage(playerid, RAUDONA, "Atљaukėte registraciją!"); } }
[14:17:36] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
C:\Users\Nerijus\Desktop\Socotra.lt\gamemodes\garz a.pwn(34) : warning 213: tag mismatch C:\Users\Nerijus\Desktop\Socotra.lt\gamemodes\garz a.pwn(40) : warning 213: tag mismatch C:\Users\Nerijus\Desktop\Socotra.lt\gamemodes\garz a.pwn(55) : error 017: undefined symbol "cache_get_data" C:\Users\Nerijus\Desktop\Socotra.lt\gamemodes\garz a.pwn(54) : warning 203: symbol is never used: "num_fields" C:\Users\Nerijus\Desktop\Socotra.lt\gamemodes\garz a.pwn(73) : error 017: undefined symbol "mysql_fumction_query" C:\Users\Nerijus\Desktop\Socotra.lt\gamemodes\garz a.pwn(25 : error 017: undefined symbol "mysql_function_query" |
34. manomysql = mysql_connect(db_host, db_user, db_db, db_pass); 40. mysql_close(manomysql); 55. cache_get_data(num_rows, num_fields, manomysql); 54. new num_rows, num_fields; 73. mysql_fumction_query(manomysql, query, true, "OnUserCheck", "i", playerid); 258. mysql_function_query(manomysql, query, false, "", ""); |
mysql_pquery(manomysql, query, "OnUserCheck", "i", playerid); |
C:\Users\Nerijus\Desktop\Socotra.lt\gamemodes\garz a.pwn(74) : warning 213: tag mismatch |
new query[103];
mysql_format(manomysql, query, sizeof query, "SELECT `id` FROM `user` WHERE `vardas` = '%e' LIMIT 1", vardas);
mysql_tquery(manomysql, query, "OnUserCheck", "dd", playerid);
pawn Код:
|
I downloaded r41-3 mysql plugin. Updated files in plugins and includes. Where I have to paste libmariadb.dll and log-core.dll ?
|