Quote:
Originally Posted by introzen
Seeing you trying to store "Username" into "UserID" just f*cks my mind right up. Change it please.
OT: Why do you need to return it? Just set the variable inside the callback?
pawn Код:
stock UserFromID(ID)
{
new query[200];
mysql_format(MySQL, query, sizeof(query), "SELECT `Username` FROM `Users` WHERE `ID` = %d LIMIT 0,1", ID);
mysql_tquery(MySQL, query, "OnUserFromIDCheck", "i", ID);
return 1;
}
new UserNAME[MAX_PLAYERS];
forward OnUserFromIDCheck(ID);
public OnUserFromIDCheck(ID)
{
new rows, fields;
cache_get_data(rows, fields, MySQL);
if(rows == 1)
{
cache_get_field_content(0, "Username", UserNAME[ID], MySQL, MAX_PLAYER_NAME);
} else format(UserNAME[ID], MAX_PLAYER_NAME, "");
return 1;
}
|
Hmm sorry about that... Yeah it would but this Function like i said aims to be used globally in a sense that even the system in itself (Without the players) will use this.... so yeah....
Quote:
Originally Posted by jlalt
PHP код:
UserFromID(ID, UserID[MAX_PLAYER_NAME])
{
new query[200];
mysql_format(MySQL, query, sizeof(query), "SELECT `Username` FROM `Users` WHERE `ID` = %d LIMIT 0,1", ID);
new Cache:Result = mysql_query(MySQL, query);
if(cache_num_rows()) cache_get_field_content(0, "Username", UserID, MySQL, sizeof(UserID));
else UserID = "NULL";
cache_delete(Result);
return 1;
}
usage:
PHP код:
new name[MAX_PLAYER_NAME];
UserFromID(ID,name);
// THe Name will be player name you wanna get you can print it to see
printf("%s",name);
|
EDIT Second thought this might just work.. i'll go ahead and try it now
EDIT 2: Works well! Thanks jlalt
