The problem of loading the data from the registration / login of MySQL
#1

Hi, my problem is that when you want to add you to register and log (GUI) mysql Score, in general does not charge me a score or cash. Modified the order, but does not work:

LoginPlayer(playerid,pass[])
{
new
pName4[MAX_PLAYER_NAME],
query[256];

GetPlayerName(playerid,pName4,sizeof(pName4));
MySQLCheck();

mysql_real_escape_string(pName4,pName4);
mysql_real_escape_string(pass,pass);

format(query,sizeof(query),"SELECT Score FROM `"TABLENAME"`, SELECT Money FROM `"TABLENAME"` WHERE Username = '%s' AND Password = md5('%s') LIMIT 1",pName4,pass);
mysql_query(query,LOGIN_THREAD_ID,playerid);
//format(query,sizeof(query),"SELECT Money FROM `"TABLENAME"` WHERE Username = '%s' AND Password = md5('%s') LIMIT 1",pName4,pass);
//mysql_query(query,LOGIN_THREAD_ID,playerid); Przedtem to było ale pobierało kase i dodawało do niej Score.

return 1;
}
Reply


Messages In This Thread
The problem of loading the data from the registration / login of MySQL - by pl2010 - 03.08.2010, 16:51

Forum Jump:


Users browsing this thread: 1 Guest(s)