07.05.2012, 11:14
PHP код:
why for me not uploading info from mysql
here is loading car system from mysql
new resultline[1024],fetch[258];
format(query,256,"SELECT * FROM `"TRANSPORT"` WHERE Owner = '%s'",PlayerName(playerid));
mysql_query(query);
mysql_store_result();
mysql_fetch_row(resultline);
mysql_fetch_field_row(fetch,"Tipas");
sscanf(fetch, "i", Carlist[playerid][Typ]);
//
mysql_fetch_field_row(fetch,"X");
sscanf(fetch, "f", Carlist[playerid][X]);
//
mysql_fetch_field_row(fetch,"Y");
sscanf(fetch, "f", Carlist[playerid][Y]);
//
mysql_fetch_field_row(fetch,"Z");
sscanf(fetch, "f", Carlist[playerid][Z]);
//
mysql_fetch_field_row(fetch,"Laipsnis");
sscanf(fetch, "f", Carlist[playerid][Rotation]);
//
mysql_fetch_field_row(fetch,"Statusas");
sscanf(fetch, "i", Carlist[playerid][Status]);
//
mysql_fetch_field_row(fetch,"Rakinimas");
sscanf(fetch, "i", Carlist[playerid][Lock]);
//
mysql_fetch_field_row(fetch,"Dazymas");
sscanf(fetch, "i", Carlist[playerid][Paintjob]);
//
mysql_fetch_field_row(fetch,"Spalva1");
sscanf(fetch, "i", Carlist[playerid][Color1]);
//
mysql_fetch_field_row(fetch,"Spalva2");
sscanf(fetch, "i", Carlist[playerid][Color2]);
//
mysql_fetch_field_row(fetch,"Modas1");
sscanf(fetch, "i", Carlist[playerid][mod1]);
//
mysql_fetch_field_row(fetch,"Modas2");
sscanf(fetch, "i", Carlist[playerid][mod2]);
//
mysql_fetch_field_row(fetch,"Modas3");
sscanf(fetch, "i", Carlist[playerid][mod3]);
//
mysql_fetch_field_row(fetch,"Modas4");
sscanf(fetch, "i", Carlist[playerid][mod4]);
//
mysql_fetch_field_row(fetch,"Modas5");
sscanf(fetch, "i", Carlist[playerid][mod5]);
//
mysql_fetch_field_row(fetch,"Modas6");
sscanf(fetch, "i", Carlist[playerid][mod6]);
//
mysql_fetch_field_row(fetch,"Modas7");
sscanf(fetch, "i", Carlist[playerid][mod7]);
//
mysql_fetch_field_row(fetch,"Modas8");
sscanf(fetch, "i", Carlist[playerid][mod8]);
//
mysql_fetch_field_row(fetch,"Modas9");
sscanf(fetch, "i", Carlist[playerid][mod9]);
//
mysql_fetch_field_row(fetch,"Modas10");
sscanf(fetch, "i", Carlist[playerid][mod10]);
//
mysql_fetch_field_row(fetch,"Modas11");
sscanf(fetch, "i", Carlist[playerid][mod11]);
//
mysql_fetch_field_row(fetch,"Modas12");
sscanf(fetch, "i", Carlist[playerid][mod12]);
//
mysql_fetch_field_row(fetch,"Modas13");
sscanf(fetch, "i", Carlist[playerid][mod13]);
//
mysql_fetch_field_row(fetch,"Modas14");
sscanf(fetch, "i", Carlist[playerid][mod14]);
//
mysql_fetch_field_row(fetch,"Modas15");
sscanf(fetch, "i", Carlist[playerid][mod15]);
//
mysql_fetch_field_row(fetch,"Modas16");
sscanf(fetch, "i", Carlist[playerid][mod16]);
//
mysql_fetch_field_row(fetch,"Modas17");
sscanf(fetch, "i", Carlist[playerid][mod17]);
//
mysql_fetch_field_row(fetch,"Modas18");
sscanf(fetch, "i", Carlist[playerid][mod18]);
//
mysql_fetch_field_row(fetch,"Benzas");
sscanf(fetch, "i", Carlist[playerid][gas]);
//
mysql_fetch_field_row(fetch,"Numeris");
sscanf(fetch, "i", Carlist[playerid][numeris]);
//
mysql_fetch_field_row(fetch,"Rida");
sscanf(fetch, "f", Carlist[playerid][prav]);
//
mysql_free_result();
if(Carlist[playerid][Typ]!=-1 && Carlist[playerid][Status]==1)
{
Carlist[playerid][Carid]=CreateTunedCar(playerid);
playerDB[playerid][pcar]=Carlist[playerid][Carid];
vehicleDB[Carlist[playerid][Carid]][owner_name]=PlayerName(playerid);
if(Carlist[playerid][gas]>0)
vehicleDB[Carlist[playerid][Carid]][gas]=Carlist[playerid][gas];
vehicleDB[Carlist[playerid][Carid]][gas]=20;
}
if any script needed say i upload