14.08.2012, 05:29
Sorry it is Untested. Try using it. Let me know what happens.
pawn Код:
stock SpawnPlayerAtHouse(playerid)
{
foreach(Houses, i)
{
if(!strcmp(HouseInfo[i][hOwner], GetName(playerid), false) || !strcmp(HouseInfo[i][hRentUser], GetName(playerid), false) && HouseInfo[i][hOwned] == 1)
{
new HQuery2[200];
format(HQuery2, sizeof(HQuery2), "SELECT HouseID FROM `houses` WHERE `HouseID` = '%d'", i);
mysql_query(HQuery2);
mysql_store_result();
if(mysql_num_rows() == 1)
{
SendInfo(playerid, "Succesfuly spawned to your ~g~~h~House");
SetPlayerPos(playerid, HouseInfo[i][hExitX], HouseInfo[i][hExitY], HouseInfo[i][hExitZ]);
SetPlayerInterior(playerid, HouseInfo[i][hInterior]);
SetPlayerVirtualWorld(playerid, HouseInfo[i][hVirtualWorld]);
PlayerEnteredHisHouse[playerid] = true;
mysql_free_result();
return 1;
}
}
else
{
SetPlayerPos(playerid,1481.0189 , -1770.3466 , 18.7958 ); // Add your Coordinates here where you want the player to be spawned.
SetPlayerInterior(playerid, 0);
SetPlayerVirtualWorld(playerid, 0);
}
}
return 0;
}