format(Query, sizeof(Query), "SELECT * FROM players WHERE nombre='%s'", NOMBRE);
mysql_query(Query); // No query line
mysql_free_result();
if(mysql_num_rows())
{
new
apc[50],
string[215],
savingstring[256],
anickc[30],
plakc[45];
mysql_fetch_field_row(apc, "apple");
mysql_fetch_field_row(anickc, "nickplaq");
mysql_fetch_field_row(plakc, "plakic");
mysql_fetch_field_row(savingstring, "apple"); apc = strval(savingstring);
mysql_fetch_field_row(savingstring, "nickplaq"); anickc = strval(savingstring);
mysql_fetch_field_row(savingstring, "plakic"); plakc = strval(savingstring);
format(string, sizeof string, "PLAYER: %s", NOMBRE);
SendClientMessage(playerid, -1, string);
format(string, sizeof string, "APPLE: %s - ANICKC: %s - PLAKC: %s", apc, anickc, plakc);
SendClientMessage(playerid, -1, string);
New apc[50]
mysql_fetch_field("apple", Data);
mysql_fetch_field("apple", Data, 35);
try
Код:
mysql_fetch_field("apple", Data, 35); |
format(Query, sizeof(Query), "SELECT apple FROM players WHERE Nick='%s'", Nombre);
//mysql_query(Query,UPDATES,playerid);
mysql_query(Query); // No query line
mysql_store_result();
new
rows = mysql_num_rows();
if(rows >= 0)
{
new
data[16],
string[226];
mysql_fetch_row(data);
format(string, sizeof string, "Nick: {00CCFF}%s{FFFFFF} | APPLE: {ffff00}%s", Nombre, data);
SendClientMessage(playerid, -1, string);
return 1;
}
he uses MySQL R5
OT: you're getting wrong data or you're getting nothing? |