[Help] MySQL registration/login system not compiling
#1

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);
Reply
#2

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

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?
Reply
#4

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.
Reply
#5

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);
Reply
#6

Make sure you have MySQL tag
new MySQL:g_Sql
Reply
#7

Quote:
Originally Posted by coool
Посмотреть сообщение
Make sure you have MySQL tag
new MySQL:g_Sql
I fixed those errors, I have new ones
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)