06.07.2011, 14:20
pawn Код:
GetNameFromSql(accId)
{
new
query[STR_MAX],
strid[32]
;
format(query, sizeof(query), "SELECT Name FROM players WHERE accid = '%d' LIMIT 1", accId);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows()==0)
{
format(strid, sizeof(strid), "None");
return strid;
}
else
{
new name[3][128];
mysql_fetch_row(strid);
mysql_free_result();
split(strid, name, '_');
format(strid, sizeof(strid), "%s %s", name[0], name[1]);
return strid;
}
}
and if you don't have split function here it is,
pawn Код:
stock split(const strsrc[], strdest[][], delimiter)
{
new i, li;
new aNum;
new len;
while(i <= strlen(strsrc))
{
if(strsrc[i] == delimiter || i == strlen(strsrc))
{
len = strmid(strdest[aNum], strsrc, li, i, 128);
strdest[aNum][len] = 0;
li = i+1;
aNum++;
}
i++;
}
return 1;
}