mysql help please - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql help please (/showthread.php?tid=533375)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql help please (/showthread.php?tid=533375)
mysql help please - LocMax - 24.08.2014
So I'm getting these errors while using BlueG's R39-2 MySQL version.
I recently switched from SQLite to MySQL and I'm confused with all the 1651 versions of MySQL
Код:
C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1083) : error 035: argument type mismatch (argument 1) C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1084) : error 017: undefined symbol "mysql_store_result" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1087) : error 017: undefined symbol "mysql_free_result" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1165) : error 035: argument type mismatch (argument 1) C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1525) : error 035: argument type mismatch (argument 1) C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1526) : error 017: undefined symbol "mysql_store_result" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1527) : error 017: undefined symbol "mysql_num_rows" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1545) : error 035: argument type mismatch (argument 1) C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1546) : error 017: undefined symbol "mysql_store_result" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1547) : error 017: undefined symbol "mysql_num_rows" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1550) : error 017: undefined symbol "mysql_free_result" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1551) : error 017: undefined symbol "mysql_clear_result" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1871) : error 035: argument type mismatch (argument 1) C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1872) : error 017: undefined symbol "mysql_store_result" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1875) : error 017: undefined symbol "mysql_free_result" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1982) : error 035: argument type mismatch (argument 1) C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1983) : error 017: undefined symbol "mysql_store_result" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1986) : error 017: undefined symbol "mysql_free_result" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(2582) : error 035: argument type mismatch (argument 1) C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(2583) : error 017: undefined symbol "mysql_store_result" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(2584) : error 017: undefined symbol "mysql_num_rows" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(2605) : error 017: undefined symbol "mysql_free_result" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(2606) : error 017: undefined symbol "mysql_clear_result" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(2623) : error 035: argument type mismatch (argument 1) C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(2624) : error 017: undefined symbol "mysql_store_result" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(2636) : error 017: undefined symbol "mysql_free_result"
pawn Код:
format(Query, sizeof(Query), "INSERT INTO banned (name, ip, reason, admin, date, time) VALUES ('%s', '%s', 'Weapon hacks', 'Server', '%d/%d/%d', '%d:%d:%d')", PlayerInfo[i][Name], PlayerInfo[i][IP], day, month, year, hour, minute, second);
mysql_query(Query);
new result = mysql_store_result();
if(result) printf("--- BAN: %s has been banned by Server for fake kill - BAN SAVED", PlayerInfo[i][Name]);
else if(!result) printf("------ [ERROR]: %s has been banned by Server for fake kill - BAN FAILED (912)", PlayerInfo[i][Name]);
mysql_free_result();
pawn Код:
format(Query, sizeof(Query), "UPDATE users SET ip = '%s', money = %d, score = %d, kills = %d, deaths = %d, adminlevel = %d, viplevel = %d, license = %d, laston = '%d/%d/%d' WHERE name = '%s'",
PlayerInfo[playerid][IP], PlayerInfo[playerid][Money], GetPlayerScore(playerid), PlayerInfo[playerid][Kills], PlayerInfo[playerid][Deaths], PlayerInfo[playerid][Admin], PlayerInfo[playerid][VIP], PlayerInfo[playerid][License], day, month, year, PlayerInfo[playerid][Name]);
mysql_query(Query);
new result = mysql_store_result();
if(result) printf("-- Account of %s saved successfully.", PlayerInfo[playerid][Name]);
else if(!result) printf("-- Account of %s NOT saved.", PlayerInfo[playerid][Name]);
mysql_free_result();
Re: mysql help please - LocMax - 24.08.2014
EDIT: I changed it and now I only get errors:
Код:
C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1522) : error 017: undefined symbol "mysql_store_result" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1523) : error 017: undefined symbol "mysql_num_rows" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1542) : error 017: undefined symbol "mysql_store_result" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1543) : error 017: undefined symbol "mysql_num_rows" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(1546) : error 017: undefined symbol "mysql_clear_result" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(2570) : error 017: undefined symbol "mysql_store_result" C:\Program Files (x86)\SAMP\gamemodes\CODMW.pwn(2571) : error 017: undefined symbol "mysql_num_rows"
Re: mysql help please - mamorunl - 24.08.2014
You are using the old syntax with the new version. So basically you have a version mismatch with your plugin and code.