MySQL Player Vehicles.
#8

1st Script:
pawn Код:
format(sql, sizeof(sql), "SELECT * FROM playervehicles WHERE ID = %d", i);
It's selecting from the playervehicle's database, where the "ID" is the playersid (Which is RANDOM). - I don't see how that works, it should be:
pawn Код:
// Get the player's name & store in int 'name'.
format(sql, sizeof(sql), SELECT * FROM playervehicles WHERE owner='%s', name);
Don't know if that is right ..

2nd Script:

pawn Код:
format(sql, sizeof(sql), "SELECT COUNT(*) FROM playervehicles");
Shouldnt you use:
pawn Код:
//Get player's name & store as 'name'
format(sql, sizeof(sql), "SELECT * FROM playervehicles WHERE owner = '%s'", name");
I'm not sure if i'm right or wrong as i dont even understand your script .. or what you want it to do.
Reply


Messages In This Thread
MySQL Player Vehicles. - by Feli97 - 24.05.2011, 08:17
Re: MySQL Player Vehicles. - by Feli97 - 24.05.2011, 09:48
Re: MySQL Player Vehicles. - by Feli97 - 24.05.2011, 10:47
Re: MySQL Player Vehicles. - by dannyk0ed - 24.05.2011, 10:49
Re: MySQL Player Vehicles. - by Feli97 - 24.05.2011, 11:15
Re: MySQL Player Vehicles. - by Feli97 - 24.05.2011, 17:30
Re: MySQL Player Vehicles. - by Feli97 - 24.05.2011, 17:56
Re: MySQL Player Vehicles. - by GamingTurf - 24.05.2011, 18:13
Re: MySQL Player Vehicles. - by Feli97 - 24.05.2011, 18:15
Re: MySQL Player Vehicles. - by GamingTurf - 24.05.2011, 18:20

Forum Jump:


Users browsing this thread: 5 Guest(s)