03.08.2010, 16:51
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;
}
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;
}