I see a few mistakes in here.
First, we need to normalize the tables. You have stated the house ownership depends on the player's name, but what if that player changes his nickname? We must assign a unique id for each registered player and when a player buys a house, we set the owner to the player's ID, not the player's name.
Normalized tables:
Код:
CREATE TABLE 'houses' (ID int NOT NULL AUTO_INCREMENT, NAME varchar(50) DEFAULT NULL, OWNER INT, S_X FLOAT, S_Y FLOAT, S_Z FLOAT, S_W INT, S_I INT, S_A FLOAT, PRIMARY KEY(ID));
//both the name and ID must be primary keys! We cannot have two players with the same name!
CREATE TABLE 'users' (ID int NOT NULL AUTO_INCREMENT, NAME varchar(50) NOT NULL, PRIMARY KEY(ID, NAME));
So, we need these:
Код:
enum pDB
{
Id,
name[50],
houses
}
new Player[MAX_PLAYERS][pDB];
enum hDB
{
id,
name[50],
owner,
Float:sPos[6], //used for spawn pos
}
new House[MAX_HOUSES+1][hDB];
When server is loaded:
Код:
public OnGameModeInit()
{
//loading all houses
new Cache: cache, row;
cache = mysql_query(1, "SELECT * FROM houses", true);
for(new i = 0; i<cache_get_row_count(1)+1; i++)
{
row = i - 1;
House[i][id] = cache_get_field_content_int(row, "ID");
House[i][name] = cache_get_field_content_int(row, "NAME");
House[i][owner] = cache_get_field_content_int(row, "OWNER");
House[i][sPos][0] = cache_get_field_content_float(id, "S_X");
House[i][sPos][1] = cache_get_field_content_float(id, "S_Y");
House[i][sPos][2] = cache_get_field_content_float(id, "S_Z");
House[i][sPos][3] = cache_get_field_content_float(id, "S_ANG");
House[i][sPos][4] = cache_get_field_content_float(id, "S_W");
House[i][sPos][5] = cache_get_field_content_float(id, "S_I");
}
cache_delete(cache, 1);
}
Now assigning number of houses to players on connect:
Код:
public OnPlayerConnect(playerid)
{
//loading player info
new Cache: cache, query[128], name[50], rows;
GetPlayerName(playerid, name, MAX_PLAYER_NAME);
mysql_format(1, query, sizeof query, "SELECT * FROM USERS WHERE NAME='%s' LIMIT 1",name);
cache = mysql_query(1, query, true);
rows = cache_get_row_count(1);
if(rows != 0)
{
Player[playerid][id] = cache_get_field_content_int(0, "ID");
//house number!
for(new i = 0; i<MAX_HOUSES; i++)
{
if(House[i][id] > 0 && House[i][owner] == Player[playerid][id])
Player[playerid][id]++;
}
}
else
{
// player isn't registered...
}
cache_delete(cache, 1);
}
So when a player buys the house, we update the house table by running this query:
Код:
stock buyHouse(playerid, houseid)
{
new query[128];
format(query, sizeof query, 'UPDATE houses SET OWNER = %d WHERE ID = %d', Player[playerid][id], House[housed][id]);
mysql_query(1, query, false);
}
stock sellHouse(playerid, houseid)
{
new query[128];
format(query, sizeof query, 'UPDATE houses SET OWNER = 0 WHERE OWNER = %d AND ID = %d', Player[playerid][id], House[housed][id]);
mysql_query(1, query, false);
}
And finally, to answer your question!
Код:
public OnplayerSpawn(playerid)
{
if(Player[playerid][houses] == 0)
{
switch(random(2))
{
case 0: SetPlayerPos(playerid, 1742.7836, -1860.1030, 13.5791);
case 1: SetPlayerPos(playerid, 837.7275, -1341.4581, 7.1719);
}
}
return 1;
}
Now of course, this merely represents what your system is like. So, if you have any other questions, ask!
