01.02.2009, 16:43
Hey can some one check my code!
When I spawn I get a message of:
SPAWNED: Playerid:0 SpawnPoint:22 POS_X:0 POS_Y:1 POS_Z:2
Playerid and spawnpoint work fine!
Thanks
PS: There are values in the table for spawn point 22
When I spawn I get a message of:
SPAWNED: Playerid:0 SpawnPoint:22 POS_X:0 POS_Y:1 POS_Z:2
Playerid and spawnpoint work fine!
Код:
public SetPlayerRandomSpawn(playerid)
{
MySQLCheckConnection();
new sql[64], fields[4][74], row[10];
new rand;
format(sql, sizeof(sql), "SELECT COUNT(*) FROM prandomspawn");
samp_mysql_query(sql);
samp_mysql_store_result();
samp_mysql_fetch_row(row);
rand = random(strval(row));
samp_mysql_free_result();
{
format(sql, sizeof(sql), "SELECT * FROM prandomspawn WHERE id=%d");
samp_mysql_query(sql);
samp_mysql_store_result();
samp_mysql_fetch_row(row);
split(row, fields, '|');
samp_mysql_free_result();
pspawns[rand][posa] = floatstr(fields[1]);
pspawns[rand][posb] = floatstr(fields[2]);
pspawns[rand][posc] = floatstr(fields[3]);
SetPlayerToTeamColor(playerid);
SetPlayerPos(playerid, pspawns[rand][posa], pspawns[rand][posb], pspawns[rand][posc]);
if (gdebug >=1){printf("DEBUG SPAWNED: Playerid:%d SpawnPoint:%d", playerid, rand);}
SetPlayerFacingAngle(playerid, 270.0);
SetPlayerInterior(playerid,0);
PlayerInfo[playerid][pInt] = 0;
}
// format(row, sizeof(row), "PlayerSpawn(): %d spawns", rand);
printf("SPAWNED: Playerid:%d SpawnPoint:%d POS_X:%d POS_Y:%d POS_Z:%d", playerid, rand, posa, posb, posc);
return 1;
}
PS: There are values in the table for spawn point 22

