SA-MP Forums Archive
[Tutorial] Mysql Register/Login system! - 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)
+---- Forum: Tutorials (https://sampforum.blast.hk/forumdisplay.php?fid=70)
+---- Thread: [Tutorial] Mysql Register/Login system! (/showthread.php?tid=305994)

Pages: 1 2 3

Re: Mysql Register/Login system! - XMoonBladerX - 24.12.2012

Nice tutorial , thanks for it .

Re: Mysql Register/Login system! - michaelcosyns - 18.04.2013

Awesome tut.!

Re: Mysql Register/Login system! - x96664 - 29.06.2013

It took me 20 minutes to fix your errors for myself.

Re: Mysql Register/Login system! - Alazam - 11.07.2013

My errors
C:\Users\Alazam\Desktop\Samp\gamemodes\France.pwn( 46) : error 001: expected token: ";", but found "public"
C:\Users\Alazam\Desktop\Samp\gamemodes\France.pwn( 259) : error 017: undefined symbol "Logindialog"
C:\Users\Alazam\Desktop\Samp\gamemodes\France.pwn( 263) : error 017: undefined symbol "Regdialog"
C:\Users\Alazam\Desktop\Samp\gamemodes\France.pwn( 263) : error 017: undefined symbol "NPUT"
C:\Users\Alazam\Desktop\Samp\gamemodes\France.pwn( 263) : error 029: invalid expression, assumed zero
C:\Users\Alazam\Desktop\Samp\gamemodes\France.pwn( 263) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase


6 Errors.


My script

http://pastebin.com/ccCincpV

What is the problem please?

Re: Mysql Register/Login system! - Dugzor - 11.09.2013

Quote:

C:\samp\gamemodes\dugi.pwn(60) : warning 204: symbol is assigned a value that is never used: "pInfo"
C:\samp\gamemodes\dugi.pwn(59) : warning 203: symbol is never used: "Money"
C:\samp\gamemodes\dugi.pwn(57) : warning 203: symbol is never used: "Password"
C:\samp\gamemodes\dugi.pwn(56) : warning 203: symbol is never used: "Username"
C:\samp\gamemodes\dugi.pwn(356) : error 017: undefined symbol "pInfo"
C:\samp\gamemodes\dugi.pwn(356) : warning 215: expression has no effect
C:\samp\gamemodes\dugi.pwn(356) : error 001: expected token: ";", but found "]"
C:\samp\gamemodes\dugi.pwn(356) : error 029: invalid expression, assumed zero
C:\samp\gamemodes\dugi.pwn(356) : fatal error 107: too many error messages on one line
These are all the errors I am getting and this is my code:
pawn Code:
stock load_stats(playerid)
{
    new pName[24], query[80];
    GetPlayerName(playerid, pName, 24);

    format(query, sizeof(query), "SELECT * FROM server_players WHERE playername = '%s'", pName);
    mysql_query(query);
    mysql_store_result();

    mysql_fetch_row_format(query, "|");
    sscanf(query, "e<p<|>s[24]s[23]i>", pInfo[playerid]);
    mysql_free_result();

    GivePlayerMoney(playerid, pInfo[playerid][Money]);

    return 1;
}
Can you please help me out?

Re: Mysql Register/Login system! - Yves - 21.12.2013

way to awful didn't help.

Re: Mysql Register/Login system! - anou1 - 04.01.2014

UP,

I have the same problem...

Re: Mysql Register/Login system! - anou1 - 05.01.2014

No ideas ?


Thank you.

Re: Mysql Register/Login system! - anou1 - 05.01.2014

UP please...

Re: Mysql Register/Login system! - Ramin - 05.12.2014

I Have Problem
Quote:

F:\Sa-mp 3z alimash\MYSQL Iranian DeathMatch\gamemodes\DeathMatch.pwn(95) : error 035: argument type mismatch (argument 1)
F:\Sa-mp 3z alimash\MYSQL Iranian DeathMatch\gamemodes\DeathMatch.pwn(96) : error 017: undefined symbol "mysql_store_result"
F:\Sa-mp 3z alimash\MYSQL Iranian DeathMatch\gamemodes\DeathMatch.pwn(97) : error 017: undefined symbol "mysql_fetch_row_format"
F:\Sa-mp 3z alimash\MYSQL Iranian DeathMatch\gamemodes\DeathMatch.pwn(9 : error 017: undefined symbol "PInfo"
F:\Sa-mp 3z alimash\MYSQL Iranian DeathMatch\gamemodes\DeathMatch.pwn(9 : warning 215: expression has no effect
F:\Sa-mp 3z alimash\MYSQL Iranian DeathMatch\gamemodes\DeathMatch.pwn(9 : error 001: expected token: ";", but found "]"
F:\Sa-mp 3z alimash\MYSQL Iranian DeathMatch\gamemodes\DeathMatch.pwn(9 : error 029: invalid expression, assumed zero
F:\Sa-mp 3z alimash\MYSQL Iranian DeathMatch\gamemodes\DeathMatch.pwn(9 : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase


7 Errors.
Quote:

stock LoadStats(playerid)
{
new pName[24],Query[80];
GetPlayerName(playerid,pName,24);
format(Query, sizeof(Query), "SELECT * FROM `Users` WHERE `Username` = '%s' ", pName);
mysql_query(Query);//Line 95
mysql_store_result();//Line 96
mysql_fetch_row_format(Query, "|");//Line 97
sscanf(Query, "e<p<|>s[24]s[23]i>", PInfo[playerid]);//Line 98
mysql_free_result();
GivePlayerMoney(playerid,PInfo[playerid][Money]);
return 1;
}
Please Help Me

Re: Mysql Register/Login system! - cyberlord - 10.12.2014

would some1 help my with this i got 14 error did something wrong

Re: Mysql Register/Login system! - Vadyanga - 11.12.2015

FU**ing images die :ccc

Re: Mysql Register/Login system! - AndreiWow - 21.04.2016

Why is it not creating the Users table?