COMMAND:temp(playerid,params[])
{
new query[420];
format(query,sizeof(query),"SELECT * FROM vehicles WHERE owner='%s'",PlayerName(playerid));
mysql_function_query(dbhandle,query,true,"OnCarSpawnCommand","i",playerid);
return 1;
}
forward OnCarSpawnCommand(playerid);
public OnCarSpawnCommand(playerid)
{
new num_fields2,num_rows2;
new
string [ 500 ],
string1337[420],
temp_carowner[35];
cache_get_data(num_rows2,num_fields2,dbhandle);
if(num_rows2!=0)
{
for(new v = 0; v < sizeof(num_rows2); v++)
{
cache_get_field_content(v, "owner", temp_carowner);
format(string1337,sizeof(string1337),"%s",temp_carowner);
myStrcpy(cInfo[v][carowner], string1337);
if(!strcmp(cInfo[v][carowner], PlayerName(playerid), false))
{
format(string, sizeof(string), "%i (%i)\n", cache_get_field_content_int(v,"model",dbhandle),cache_get_field_content_int(v,"id",dbhandle));
}
else
{
return 1;
}
}
}
ShowPlayerDialog(playerid,DIALOG_CARSPAWN,DIALOG_STYLE_LIST,"Car spawning",string,"Spawn","Close");
return 1;
}
Even though the rules say you can only bump after 24 hours, I'd still understand if someone bumps their topic after 12 hours, but after only 17 minutes...?
|
for(new v = 0; v < sizeof(num_rows2); v++) |
for(new v = 0; v < num_rows2; v++)
You're making "v" increment if it's less than the string length of "num_rows2". You need to change it to:
Код:
for(new v = 0; v < num_rows2; v++) |
COMMAND:temp(playerid, params[]) { new query[62]; GetPlayerName(playerid, query, 24); format(query, sizeof(query), "SELECT * FROM vehicles WHERE owner='%s'", query); mysql_function_query(dbhandle, query, true, "OnCarSpawnCommand", "i", playerid); return 1; } forward OnCarSpawnCommand(playerid); public OnCarSpawnCommand(playerid) { new rows, fields; cache_get_data(rows, fields, dbhandle); if (rows) { new str[512]; for (new v = 0; v < rows; v++) { format(str, sizeof(str), "%s%i (%i)\n", str, cache_get_field_content_int(v, "model", dbhandle), cache_get_field_content_int(v, "id", dbhandle)); } ShowPlayerDialog(playerid, DIALOG_CARSPAWN, DIALOG_STYLE_LIST, "Car spawning", str, "Spawn", "Close"); return 1; } SendClientMessage(playerid, 0xFF0000FF, "Could not find anything in the database."); return 1; }