mysql help please
#1

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"
How is use it:
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();
Reply
#2

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"
Reply
#3

You are using the old syntax with the new version. So basically you have a version mismatch with your plugin and code.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)