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