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;
}