[Xessive]

Hello,

I'm trying to try out Gammix's advance mysql registration system base. First I want to run it and then learn how it was made. However, I'm not able to compile it.

These are the errors:

C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(135) : error 017: undefined symbol "mysql_init_options"
C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(135) : warning 213: tag mismatch
C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(136) : error 017: undefined symbol "mysql_set_option"
C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(13 : error 017: undefined symbol "ALL"
C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(140) : warning 213: tag mismatch
C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(140) : warning 213: tag mismatch
C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(161) : warning 213: tag mismatch
C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(166) : warning 213: tag mismatch
C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(176) : warning 213: tag mismatch
C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(186) : warning 213: tag mismatch
C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(187) : warning 213: tag mismatch
C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(200) : warning 213: tag mismatch
C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(200 -- 201) : error 017: undefined symbol "e_USER_SALT"
C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(202) : warning 213: tag mismatch
C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(255) : error 017: undefined symbol "e_USER_SALT"
C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(255) : error 029: invalid expression, assumed zero
C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(255) : warning 215: expression has no effect
C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(255) : error 001: expected token: ";", but found "]"
C:\Users\Ahmed\Desktop\sampservercod\gamemodes\Unt itled.pwn(255) : fatal error 107: too many error messages on one line

Here is my server folder:

https://www.mediafire.com/file/18rrq...pservercod.zip

Please I kindly request you to help fix all the errors. I really want this.

[Fratello]

Can you provide the code via CODE tags or Pastebin? Following link might be considered as a threat and removed without notice.

Anyway, have you updated MySQL include?

[elhanan]

please post these lines here. and not the whole file

[Xessive]

Hello. Thanks for replying.

This is the code: https://pastebin.com/e97aXas1

@Elhannan

C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 135) : error 017: undefined symbol "mysql_init_options"
C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 135) : warning 213: tag mismatch

new MySQLOptptions = mysql_init_options();


C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 136) : error 017: undefined symbol "mysql_set_option"

mysql_set_option(options, SERVER_PORT, 3306);


C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 13 : error 017: undefined symbol "ALL"

mysql_log(ALL);

C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 140) : warning 213: tag mismatch
C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 140) : warning 213: tag mismatch

conn = mysql_connect("localhost", "root", "", "sa-mp", options);

C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 161) : warning 213: tag mismatch

mysql_tquery(conn, string);

C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 166) : warning 213: tag mismatch

`user_id` INT)");

C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 176) : warning 213: tag mismatch

mysql_close(conn);

C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 186) : warning 213: tag mismatch

mysql_format(conn, string, sizeof(string), "SELECT * FROM `users` WHERE `name` = '%e' LIMIT 1", name);

C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 187) : warning 213: tag mismatch

mysql_tquery(conn, string, "OnPlayerJoin", "i", playerid);

C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 200) : warning 213: tag mismatch
C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 200 -- 201) : error 017: undefined symbol "e_USER_SALT"

mysql_format(conn, string, sizeof(string), "UPDATE `users` SET `name` = '%s', `password` = '%e', `salt` = '%e', `sec_question` = '%e', `sec_answer` = '%e', `kills` = %i, `deaths` = %i, `score` = %i, `money` = %i, `adminlevel` = %i, `viplevel` = %i WHERE `id` = %i",

C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 202) : warning 213: tag mismatch

mysql_tquery(conn, string);

C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 255) : error 017: undefined symbol "e_USER_SALT"
C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 255) : error 029: invalid expression, assumed zero
C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 255) : warning 215: expression has no effect
C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 255) : error 001: expected token: ";", but found "]"
C:\Users\Ahmed\Desktop\xw2\gamemodes\Untitled.pwn( 255) : fatal error 107: too many error messages on one line

eUser[playerid][e_USER_SALT][0] = EOS;

[Escobabe]

Please use
[PHP1]
//Your code
[/PHP1]

Remove the number. And voila.