Mysql problem
#1

Hello

I've a little script for connecting to my server :

Код:
new query[128], data[256];
	GetPlayerName(playerid, pPseudo[playerid], sizeof(pPseudo[]));
	
	format(query, sizeof(query), "SELECT `password` FROM `members` WHERE `pseudo` = '%s'", pPseudo[playerid]);
	mysql_query(query);
	mysql_store_result();
	
	if(mysql_fetch_field("password", pPassword[playerid])) {
		new sConnexion[128];
		format(sConnexion, sizeof(sConnexion), "{009FFB}Hello, {0032FB}%s !\n\n{009FFB}Please enter your password :", pPseudo[playerid]);
		ShowPlayerDialog(playerid, 1, DIALOG_STYLE_PASSWORD, "Connexion", sConnexion, "Connexion", "Exit");
	}
The problem is that when I go on this server, it is rebooted and the script doesn't function.

Here is mysql_log.txt :

[Mon Jul 02 18:43:52 2012] Connected (0) to root @ localhost via TCP/IP.
[Mon Jul 02 18:43:52 2012] MySQL Server Version 5.5.24-log.
[Mon Jul 02 18:44:26 2012] Function: mysql_query executed: "SELECT `password` FROM `members` WHERE `pseudo` = 'Urefeu'" with result: "0".
[Mon Jul 02 18:44:26 2012] Function: mysql_store_result executed with result: "1"
[Mon Jul 02 18:44:26 2012] Function: mysql_fetch_field executed.

Thanks in advance !

Urefeu
Reply


Messages In This Thread
Mysql problem - by Urefeu - 02.07.2012, 17:04
Respuesta: Mysql problem - by [DOG]irinel1996 - 02.07.2012, 17:13
Re: Mysql problem - by Urefeu - 02.07.2012, 18:42
Re: Mysql problem - by Urefeu - 02.07.2012, 20:28
Re: Mysql problem - by Urefeu - 03.07.2012, 14:19
Respuesta: Mysql problem - by [DOG]irinel1996 - 03.07.2012, 14:46
Re: Mysql problem - by Urefeu - 03.07.2012, 15:46
Respuesta: Mysql problem - by [DOG]irinel1996 - 03.07.2012, 16:59
Re: Mysql problem - by Urefeu - 03.07.2012, 17:02
Re: Mysql problem - by Urefeu - 03.07.2012, 17:11

Forum Jump:


Users browsing this thread: 1 Guest(s)