[Help] MySQL registration/login system not compiling

[Help] MySQL registration/login system not compiling - 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: [Help] MySQL registration/login system not compiling (/showthread.php?tid=630772)

[SOLVED] MySQL registration/login system not compiling - Sibuscus - 18.03.2017

I followed this tutorial ->https://sampforum.blast.hk/showthread.php?tid=574714, as it seemed most recent and when I compile I get there errors:

Код:

gamemodes\test.pwn(367) : error 017: undefined symbol "cache_get_data"
gamemodes\test.pwn(370) : error 017: undefined symbol "cache_get_field_content"
gamemodes\test.pwn(371) : error 017: undefined symbol "cache_get_field_content_int"
gamemodes\test.pwn(366) : warning 203: symbol is never used: "fields"
gamemodes\test.pwn(384) : error 017: undefined symbol "cache_get_field_content_int"
gamemodes\test.pwn(385) : error 017: undefined symbol "cache_get_field_content_int"
gamemodes\test.pwn(386) : error 017: undefined symbol "cache_get_field_content_int"
gamemodes\test.pwn(387) : error 017: undefined symbol "cache_get_field_content_int"
gamemodes\test.pwn(388) : error 017: undefined symbol "cache_get_field_content_int"
gamemodes\test.pwn(390) : error 017: undefined symbol "cache_get_field_content_float"
gamemodes\test.pwn(391) : error 017: undefined symbol "cache_get_field_content_float"
gamemodes\test.pwn(392) : error 017: undefined symbol "cache_get_field_content_float"
gamemodes\test.pwn(393) : error 017: undefined symbol "cache_get_field_content_float"
gamemodes\test.pwn(395) : error 017: undefined symbol "cache_get_field_content_int"
gamemodes\test.pwn(396) : error 017: undefined symbol "cache_get_field_content_int"
gamemodes\test.pwn(576) : error 017: undefined symbol "LOG_ALL"
gamemodes\test.pwn(577) : warning 213: tag mismatch
gamemodes\test.pwn(602) : warning 225: unreachable code
gamemodes\test.pwn(847) : warning 213: tag mismatch
gamemodes\test.pwn(848) : warning 213: tag mismatch
gamemodes\test.pwn(870) : warning 213: tag mismatch
gamemodes\test.pwn(870) : error 017: undefined symbol "Player"
gamemodes\test.pwn(870) : warning 215: expression has no effect
gamemodes\test.pwn(870) : error 001: expected token: ";", but found "]"
gamemodes\test.pwn(870) : error 029: invalid expression, assumed zero
gamemodes\test.pwn(870) : fatal error 107: too many error messages on one line

I HAVE THE LATEST mysql plugins. I have the R41-2 version, this is my server.cfg plugins line:

Код:

plugins mysql nativechecker sscanf Whirlpool streamer

My includes:

Код:

#include <a_samp>
#include <a_mysql>
#include <nex-ac>
#include <foreach>
#include <streamer>
#include <YSI\y_ini>
#include <zcmd>
#include <sscanf2>

THE THINGS ABOVE IN GREEN WERE FIXED. I have new warnings:

I get this:

Код:

(578) : warning 213: tag mismatch
(847) : warning 213: tag mismatch
(848) : warning 213: tag mismatch

here

Код:

577     mysql_log(ALL);
578 	g_Sql = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE);

847    mysql_format(g_Sql, query, sizeof(query), "SELECT `Password`, `ID` FROM `accounts` WHERE `Name` = '%e' LIMIT 1", PlayerName);
    
848    mysql_tquery(g_Sql, query, "OnAccountCheck", "i", playerid);

Re: [Help] MySQL registration/login system not compiling - Konstantinos - 18.03.2017

R40+ had code-breaking changes so either downgrade to R39-5 or update the script: https://sampforum.blast.hk/showthread.php?tid=616103

Re: [Help] MySQL registration/login system not compiling - Sibuscus - 18.03.2017

Quote:

Originally Posted by Konstantinos

R40+ had code-breaking changes so either downgrade to R39-5 or update the script: https://sampforum.blast.hk/showthread.php?tid=616103

Will rep u up If this works...Would this work for R41-2?

Re: [Help] MySQL registration/login system not compiling - Konstantinos - 18.03.2017

For any version above R40 (R41-2 included), you'll need to update the script according to the tutorial I linked you to. For example, function cache_get_data was removed and cache_num_rows() macro or cache_get_row_count function should be used instead.

Re: [Help] MySQL registration/login system not compiling - Sibuscus - 18.03.2017

I get this:

Код:

(578) : warning 213: tag mismatch
(847) : warning 213: tag mismatch
(848) : warning 213: tag mismatch

here

Код:

577     mysql_log(ALL);
578 	g_Sql = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE);

847    mysql_format(g_Sql, query, sizeof(query), "SELECT `Password`, `ID` FROM `accounts` WHERE `Name` = '%e' LIMIT 1", PlayerName);
    
848    mysql_tquery(g_Sql, query, "OnAccountCheck", "i", playerid);

Re: [Help] MySQL registration/login system not compiling - coool - 18.03.2017

Make sure you have MySQL tag
new MySQL:g_Sql

Re: [Help] MySQL registration/login system not compiling - Sibuscus - 18.03.2017

Quote:

Originally Posted by coool

Make sure you have MySQL tag
new MySQL:g_Sql

I fixed those errors, I have new ones