[Tutorial] MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - 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 Registration System [Threaded Queries(R33+) + Whirlpool] (/showthread.php?tid=485633)
+- 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 Registration System [Threaded Queries(R33+) + Whirlpool] (/showthread.php?tid=485633)
Re : MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - Maxime_Creteur - 05.04.2014
Hello, mysql plugins do not load it with the tutorial, Do you know what the problem is?
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - Thomixio - 24.07.2014
Quote:
|
Originally Posted by iFarbod
 Look at the previous posts.
|
Why should I? If this is correct, it should work.
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - adithegman - 25.08.2014
Errors!! Please help me, I copied everything from the tutorial...
Code:
C:\Users\Adi\Desktop\Test\gamemodes\Mysql.pwn(67) : error 017: undefined symbol "mysql" C:\Users\Adi\Desktop\Test\gamemodes\Mysql.pwn(67) : error 017: undefined symbol "host" C:\Users\Adi\Desktop\Test\gamemodes\Mysql.pwn(68) : error 017: undefined symbol "mysql" C:\Users\Adi\Desktop\Test\gamemodes\Mysql.pwn(89) : error 001: expected token: ";", but found "-identifier-" C:\Users\Adi\Desktop\Test\gamemodes\Mysql.pwn(89) : error 017: undefined symbol "Name" C:\Users\Adi\Desktop\Test\gamemodes\Mysql.pwn(89) : warning 215: expression has no effect C:\Users\Adi\Desktop\Test\gamemodes\Mysql.pwn(89) : error 001: expected token: ";", but found "]" C:\Users\Adi\Desktop\Test\gamemodes\Mysql.pwn(89) : fatal error 107: too many error messages on one line Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 7 Errors.
Code:
public OnGameModeInit()
{
mysql_log(LOG_ERROR | LOG_WARNING | LOG_DEBUG);
mysql = mysql_connect(host, user, db, pass); // Line 67
if(mysql_errno(mysql) != 0) print("Could not connect to database!"); // Line 68
AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
return 1;
}
public OnPlayerConnect(playerid)
{
new query[128]
GetPlayerName(playerid, Name[playerid], 24); // Line 89
GetPlayerIp(playerid, IP[playerid], 16);
mysql_format(mysql, query, sizeof(query),"SELECT `Password`, `ID` FROM `players` WHERE `Username` = '%e' LIMIT 1", Name[playerid]);
mysql_tquery(mysql, query, "OnAccountCheck", "i", playerid);
return 1;
}
Code:
#define host "localhost"
#define user "root"
#define db "server"
#define pass ""
//dialogs
#define dregister 6287 //dialog register id
#define dlogin 6288 // ^
static
mysql, //This variable will be used to manage our database
Name[MAX_PLAYERS][24], //We will use this variable to store player's name.
IP[MAX_PLAYERS][16] //We will use this variable to store player's ip.
;
native WP_Hash(buffer[], len, const str[]);
enum PDATA
{
ID,
Password[129],
Admin,
VIP,
Money,
Float:posX,
Float:posY,
Float:posZ
}
new pInfo[MAX_PLAYERS][PDATA]; //Variable that stores enumerator above
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - FlipperK119 - 29.08.2014
Thank you mate, thank you so much!
AW: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - klaus1n3 - 21.09.2014
Hi, please help me there: https://sampforum.blast.hk/showthread.php?tid=538330
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - JeaSon - 21.09.2014
i tried your tutorial and made a simple login/register system but login and register works but not updating
like i made /setlevel and i set my level to 5 but when i quit the server level didnt update on db idk why i tried everything
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - TakeiT - 21.09.2014
Quote:
|
Originally Posted by Namer
i tried your tutorial and made a simple login/register system but login and register works but not updating
like i made /setlevel and i set my level to 5 but when i quit the server level didnt update on db idk why i tried everything |
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - Baltimore - 21.09.2014
If i use WP_Hash:
Run time error 19: "File or function is not found"
...
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - WopsS - 21.09.2014
Quote:
|
Originally Posted by Baltimore
If i use WP_Hash:
Run time error 19: "File or function is not found" ... |
https://sampforum.blast.hk/showthread.php?tid=65290
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - Baltimore - 21.09.2014
Thank you.
However if I go once a wrong password it will indeed send me another dialog with the error, but if I re-enters another wrong password I do not have the dialog of error and I can spawn ...
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - JeaSon - 22.09.2014
Quote:
|
Originally Posted by TakeiT
Check your mysql_log, you probably have an error in your syntax.
|
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - StegooPs - 25.09.2014
Logging in dosen't work for me. It tells me my password is wrong even though it's right, also it dosen't turn the characters I type in into those circle things.
mysql_log.txt
Quote:
|
[13:51:59] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "server", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [13:51:59] [DEBUG] CMySQLHandle::Create - creating new connection.. [13:51:59] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [13:51:59] [DEBUG] CMySQLHandle::Create - connection created (id: 1) [13:51:59] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [13:51:59] [DEBUG] CMySQLConnection::Connect - connection was successful [13:51:59] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [13:51:59] [DEBUG] mysql_errno - connection: 1 [13:51:59] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [13:51:59] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [13:51:59] [DEBUG] CMySQLConnection::Connect - connection was successful [13:51:59] [DEBUG] CMySQLConnection::Connect - connection was successful [13:51:59] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [13:51:59] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [13:52:38] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `players` WHERE `Username` = '%e' LIMIT 1" [13:52:38] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `players` WHERE `Username` = 'aaa' ", callback: "OnAccountCheck", format: "i" [13:52:38] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution [13:52:38] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.382 milliseconds [13:52:38] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [13:52:38] [DEBUG] Calling callback "OnAccountCheck".. [13:52:38] [DEBUG] cache_get_data - connection: 1 [13:52:38] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [13:52:42] [DEBUG] mysql_format - connection: 1, len: 300, format: "INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `Money`, `PosX` ,`PosY`, `PosZ`) VALUES ('%e', '%s', '%s', 0, 0, 0..." [13:52:42] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `M", callback: "OnAccountRegister", format: "i" [13:52:42] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - starting query execution [13:52:43] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - query was successfully executed within 20.534 milliseconds [13:52:43] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [13:52:43] [DEBUG] Calling callback "OnAccountRegister".. [13:52:43] [DEBUG] cache_insert_id - connection: 1 [13:52:43] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [13:52:49] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `players` SET `Admin`=%d, `Money`=%d, `posX`=%f, `posY`=%f, `posZ`=%f WHERE `ID`=%d" [13:52:49] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `players` SET `Admin`=0, `Money`=0, `posX`=131.999, `posY", callback: "(null)", format: "(null)" [13:52:49] [DEBUG] CMySQLQuery::Execute[] - starting query execution [13:52:49] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 22.90 milliseconds [13:52:49] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving |
Quote:
|
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3z-R4, ©2005-2014 SA-MP Team [13:51:59] filterscripts = "" (string) [13:51:59] [13:51:59] Server Plugins [13:51:59] -------------- [13:51:59] Loading plugin: mysql [13:51:59] >> plugin.mysql: R39-2 successfully loaded. [13:51:59] Loaded. [13:51:59] Loading plugin: Whirlpool [13:51:59] [13:51:59] ================== [13:51:59] [13:51:59] Whirlpool loaded [13:51:59] [13:51:59] ================== [13:51:59] [13:51:59] Loaded. [13:51:59] Loaded 2 plugins. [13:51:59] [13:51:59] Filterscripts [13:51:59] --------------- [13:51:59] Loaded 0 filterscripts. [13:51:59] main() has been called. [13:51:59] Number of vehicle models: 0 [13:52:38] Incoming connection: 127.0.0.1:51323 [13:52:38] [join] aaa has joined the server (0:127.0.0.1) [13:52:43] New account registered. ID: 3 [13:52:49] [part] aaa has left the server (0:1) |
http://pastebin.com/FRp2Jw6k
Thanks in advance if you help me, sorry if this post is too long!
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - Justinclaveria123 - 10.10.2014
How if i am not using xampp? im using a mysql database from my web hosting ? what do i need to define?
please fast reply and i will give REP+
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - zwoorelook - 11.10.2014
Quote:
|
Originally Posted by Justinclaveria123
How if i am not using xampp? im using a mysql database from my web hosting ? what do i need to define?
please fast reply and i will give REP+ |
Send me pm with your skype I can be helping you
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - Vince - 11.10.2014
Quote:
|
Originally Posted by Justinclaveria123
im using a mysql database from my web hosting
|
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - Ryz - 06.01.2015
Nevermind fixed!
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - Bondage - 13.01.2015
Which mysql version is this, it says "file or function not found"
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - AgusZ - 16.01.2015
nice tutorial +
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - VenomMancer - 01.02.2015
how to add add more column when our table has already made ?
Re: MySQL Registration System [Threaded Queries(R33+) + Whirlpool] - Nicker - 01.02.2015
Quote:
|
Originally Posted by VenomMancer
how to add add more column when our table has already made ?
|