1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Help loading houses
leo9
Little Clucker
**
Posts: 46
Threads: 10
Joined: May 2014
Reputation: 0
#1

12.07.2014, 17:05
Hey guys i have this code but my houses didnt load if u can pls help
Код:
forward LoadHouses();
public LoadHouses()
{
	for(new i=0; i<=MAX_HOUSES; i++)
	{
	    mysql_format(SQL, query, sizeof(query),"SELECT * FROM `"Houses_Table"` WHERE `ID` = '%i'", i);
	    mysql_tquery(SQL, query, "", "");
	    mysql_store_result();
	    if(mysql_num_rows() == 0) break; 
	    else if(mysql_num_rows() != 0)
	    {
	     	mysql_fetch_row_format(query);
	     	sscanf(query, "e<p<|>is[25]iiiiiffffff>", HouseInfo[i]);
			new lString[256];
			switch(HouseInfo[i][Owned])
			{
				case 0:
				{
					format(lString, sizeof(lString), "House Owned: No\nHouse Owner: None\nHouse Price: $%i", HouseInfo[i][Price]);
					HouseInfo[i][Label] = CreateDynamic3DTextLabel(lString, -1, HouseInfo[i][OX], HouseInfo[i][OY], HouseInfo[i][OZ]+0.5, 20.0);
					HouseInfo[i][Icon] = CreateDynamicMapIcon(HouseInfo[i][OX], HouseInfo[i][OY], HouseInfo[i][OZ], 31, -1);
					HouseInfo[i][EnterPickup] = CreateDynamicPickup(1273, 23, HouseInfo[i][OX], HouseInfo[i][OY], HouseInfo[i][OZ], -1, -1, -1, 20.0);
					HouseInfo[i][ExitPickup] = CreateDynamicPickup(1273, 23, HouseInfo[i][IX], HouseInfo[i][IY], HouseInfo[i][IZ], -1, -1, -1, 20.0);
				}
				case 1:
				{
					format(lString, sizeof(lString),"House Owned: Yes\nHouse Owner: %s\nHouse Price: $%i\nHouse Locked: %s", HouseInfo[i][Owner], HouseInfo[i][Price], (HouseInfo[i][Locked] == 1) ? ("Yes") : ("No"));
					HouseInfo[i][Label] = CreateDynamic3DTextLabel(lString, -1, HouseInfo[i][OX], HouseInfo[i][OY], HouseInfo[i][OZ]+0.5, 20.0);
					HouseInfo[i][Icon] = CreateDynamicMapIcon(HouseInfo[i][OX], HouseInfo[i][OY], HouseInfo[i][OZ], 32, -1);
					HouseInfo[i][EnterPickup] = CreateDynamicPickup(1273, 23, HouseInfo[i][OX],HouseInfo[i][OY], HouseInfo[i][OZ], -1, -1, -1, 20.0);
					HouseInfo[i][ExitPickup] = CreateDynamicPickup(1273, 23, HouseInfo[i][IX], HouseInfo[i][IY], HouseInfo[i][IZ], -1, -1, -1, 20.0);
				}
			}
			CreatedHouses++;
		}
	}
	mysql_free_result();
	printf("[House System] %i houses were retrieved..", CreatedHouses);
	return 1;
}
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#2

12.07.2014, 17:11
You use mysql_tquery which executes a query (threaded queries) and you use functions from R5/R6 at the same time.

If you use R7+ then that's not how it supposed to load data (check AndreT's tutorial about that) and it needs a callback.
If not, then use mysql_query and it'd be recommended to just execute 1 query and with a loop to go to the next row than having many queries executed.
Find
Reply
leo9
Little Clucker
**
Posts: 46
Threads: 10
Joined: May 2014
Reputation: 0
#3

12.07.2014, 17:15
I used mysql_query() but still dont work. im using version R33
Find
Reply
electrux
Big Clucker
***
Posts: 108
Threads: 13
Joined: May 2012
Reputation: 0
#4

12.07.2014, 17:20
i dont think u should use " in
Код:
mysql_format(SQL, query, sizeof(query),"SELECT * FROM `"Houses_Table"` WHERE `ID` = '%i'";
You should use
Код:
mysql_format(SQL, query, sizeof(query),"SELECT * FROM `Houses_Table` WHERE `ID` = '%i'";
(notice there should be no " before and after Houses_Table
Find
Reply
leo9
Little Clucker
**
Posts: 46
Threads: 10
Joined: May 2014
Reputation: 0
#5

12.07.2014, 17:21
Still dont work , can i send u whole Filterscript and u check it?
Find
Reply
electrux
Big Clucker
***
Posts: 108
Threads: 13
Joined: May 2012
Reputation: 0
#6

12.07.2014, 17:24
Also, ur sscanf usage is completely wrong
Код:
sscanf(query, "e<p<|>is[25]iiiiiffffff>", HouseInfo[i]);
U need to specify the correct enumerated variables as parameters too eg.
Код:
sscanf(query, "e<p<|>is[25]iiiiiffffff>", HouseInfo[i][var1],HouseInfo[i][var2]..... etc);
Find
Reply
leo9
Little Clucker
**
Posts: 46
Threads: 10
Joined: May 2014
Reputation: 0
#7

12.07.2014, 17:24
hey guys please someone fix this
Код:
#include <a_samp>
#include <a_mysql>
#include <streamer>
#include <zcmd>
#include <sscanf2>

#define MySQL_Host      	"127.0.0.1"
#define MySQL_User			"root"
#define MySQL_Pass 			""
#define MySQL_DB			"samp"

#define Houses_Table		"houses"

enum PlayerInfo
{
	CurrentHID
};
new pInfo[MAX_PLAYERS][PlayerInfo];

#define HMenu                                                           1234
#define CInt                                                            1235
#define MAX_HOUSES 2000
enum HInfo
{
	ID,
	Owner[25],
	Owned,
	Locked,
	InteriorID,
	World,
	Price,
	Float:OX,
	Float:OY,
	Float:OZ,
	Float:IX,
	Float:IY,
	Float:IZ,
	Text3D:Label,
	Icon,
	EnterPickup,
	ExitPickup
};
new HouseInfo[MAX_HOUSES][HInfo];
new CreatedHouses = 0;
new query[256];
new SQL = -1;

public OnFilterScriptInit()
{
	SQL = mysql_connect(MySQL_Host, MySQL_User, MySQL_DB, MySQL_Pass);
	LoadHouses();
	return 1;
}
public OnFilterScriptExit()
{
	return 1;
}
public OnPlayerConnect(playerid)
{
	pInfo[playerid][CurrentHID] = -1;
	return 1;
}
public OnPlayerDisconnect(playerid, reason)
{
	pInfo[playerid][CurrentHID] = -1;
	return 1;
}

public OnPlayerPickUpDynamicPickup(playerid, pickupid)
{
	for(new i=1; i<=CreatedHouses; i++)
	{
	    if(pickupid == HouseInfo[i][ExitPickup])
	    {
	        KickFromHouse(playerid, i);
	    }
	    else if(pickupid == HouseInfo[i][EnterPickup])
	    {
	        if(HouseInfo[i][Owned] == 0)
			{
				SendClientMessage(playerid, -1, "You can buy this house using /buyhouse!");
				return 1;
			}
	        else if(HouseInfo[i][Owned] == 1)
	        {
	            if(HouseInfo[i][Locked] == 1)
	            {
					new name[MAX_PLAYER_NAME];
					GetPlayerName(playerid, name, sizeof(name));
					if(strcmp(name, HouseInfo[i][Owner]) != 0)
					{
						SendClientMessage(playerid, -1, "This house is currently locked! You cannot enter it!");
						return 1;
					}
				}
				PutPlayerInHouse(playerid, i);
				break;
			}
			else continue;
		}
	}
	return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
	if(dialogid == HMenu)
	{
	    new hID = pInfo[playerid][CurrentHID], lString[256];
	    if(response)
	    {
	        if(listitem == 0)
	        {
	            if(HouseInfo[hID][Locked] == 0)
	            {
	                HouseInfo[hID][Locked] = 1;
	                SendClientMessage(playerid, -1, "House has been locked!");
	                format(lString, sizeof(lString),"House Owned: Yes\nHouse Owner: %s\nHouse Price: $%i\nHouse Locked: %s", HouseInfo[hID][Owner], HouseInfo[hID][Price], (HouseInfo[hID][Locked] == 1) ? ("Yes") : ("No"));
	            	UpdateDynamic3DTextLabelText(Text3D:HouseInfo[hID][Label], -1, lString);
                	mysql_format(SQL, query, sizeof(query), "UPDATE `"Houses_Table"` SET `Locked` = '%i' WHERE `ID` = '%i'", HouseInfo[hID][Locked], hID);
					mysql_tquery(SQL, query, "", "");
	            }
	            else if(HouseInfo[hID][Locked] == 1)
	            {
	                HouseInfo[hID][Locked] = 0;
	                SendClientMessage(playerid, -1, "House successfully unlocked!");
	                format(lString, sizeof(lString),"House Owned: Yes\nHouse Owner: %s\nHouse Price: $%i\nHouse Locked: %s", HouseInfo[hID][Owner], HouseInfo[hID][Price], (HouseInfo[hID][Locked] == 1) ? ("Yes") : ("No"));
	            	UpdateDynamic3DTextLabelText(Text3D:HouseInfo[hID][Label], -1, lString);
	                mysql_format(SQL, query, sizeof(query), "UPDATE `"Houses_Table"` SET `Locked` = '%i' WHERE `ID` = '%i'", HouseInfo[hID][Locked], hID);
					mysql_tquery(SQL, query, "", "");
	            }
	        }
	        if(listitem == 1)
	        {
	            ShowPlayerDialog(playerid, CInt, DIALOG_STYLE_LIST, "Interior List", "Ryder's house($3000000)\nUnused house($1000000)\n", "Change", "Back");
	        }
	        if(listitem == 2)
	        {
	            new name[25];
	            format(name,25,"None");
	            HouseInfo[hID][Owner] = name;
	            HouseInfo[hID][Locked] = 0;
	            HouseInfo[hID][Owned] = 0;
	            format(lString, sizeof(lString), "House Owned: No\nHouse Owner: None\nHouse Price: $%i", HouseInfo[hID][Price]);
                UpdateDynamic3DTextLabelText(Text3D:HouseInfo[hID][Label], -1, lString);
	            mysql_format(SQL, query, sizeof(query), "UPDATE `"Houses_Table"` SET `Owner` = '%s', `Owned` = '%i', `Locked` = '%i'", HouseInfo[hID][Owner], HouseInfo[hID][Owned], HouseInfo[hID][Locked]);
				mysql_tquery(SQL, query, "", "");
	            DestroyDynamicMapIcon(HouseInfo[hID][Icon]);
	            HouseInfo[hID][Icon] = CreateDynamicMapIcon(HouseInfo[hID][OX], HouseInfo[hID][OY], HouseInfo[hID][OZ], 31, -1);
				GivePlayerMoney(playerid, HouseInfo[hID][Price]/2);
				new string[128];
				format(string, sizeof(string),"You've successfully sold the house and recieved $%i!", HouseInfo[hID][Price]/2);
	            SendClientMessage(playerid, -1, string);
	            KickFromHouse(playerid, hID);
	        }
	    }
	}
	if(dialogid == CInt)
	{
	    new hID = pInfo[playerid][CurrentHID];
	    if(!response)
	    {
	        ShowPlayerDialog(playerid, HMenu, DIALOG_STYLE_LIST, "House Menu", "(UN)Lock House\nChange Interior\nSell House\n", "Select", "Cancel");
		}
		if(response)
		{
			if(listitem == 0)
			{
			    if(GetPlayerMoney(playerid) < 3000000) return SendClientMessage(playerid,-1, "You don't have enough money to buy this interior!");
			    if(HouseInfo[hID][InteriorID] == 1) return SendClientMessage(playerid, -1, "The current house interior is already the same!");
			    HouseInfo[hID][InteriorID] = 1;
			    SendClientMessage(playerid, -1, "Interior changed. Please re-enter your house!");
			    DestroyDynamicPickup(HouseInfo[hID][ExitPickup]);
			    SetHouseExit(playerid, hID);
	            KickFromHouse(playerid, hID);
			}
			if(listitem == 1)
			{
			    if(GetPlayerMoney(playerid) < 1000000) return SendClientMessage(playerid,-1, "You don't have enough money to buy this interior!");
			    if(HouseInfo[hID][InteriorID] == 2) return SendClientMessage(playerid,-1, "The current house interior is already the same!");
			    HouseInfo[hID][InteriorID] = 2;
			    SendClientMessage(playerid, -1, "Interior changed. Please re-enter your house!");
			    DestroyDynamicPickup(HouseInfo[hID][ExitPickup]);
			    SetHouseExit(playerid, hID);
			    KickFromHouse(playerid, hID);
			}
		}
	}
	return 1;
}
//==================================[Commands]==================================
CMD:chid(playerid,params[])
{
	new string[127];
	format(string,127,"house id %i",pInfo[playerid][CurrentHID]);
	SendClientMessage(playerid,-1,string);
	return 1;
}

CMD:createhouse(playerid,params[])
{
	new HID = CreatedHouses+1, price, interior, Float:x, Float:y, Float:z;
	if(!IsPlayerAdmin(playerid)) return 0; //Do nothing if the player is not admin..
	if(sscanf(params, "ii", price, interior)) return SendClientMessage(playerid,-1,"Usage: /createhouse (price) (interior)"); //If they didn't enter the house price and interior or if they entered it wrongly, then send this message.
	if(interior >= 3 || interior <= 0) return SendClientMessage(playerid,-1,"Valid house interiors are 1 and 2 only!");
	if(CreatedHouses == MAX_HOUSES-1) return SendClientMessage(playerid, -1,"House creation limit has been exceeded! [500]"); //If the created houses is equal to max houses -1, then send this message
	GetPlayerPos(playerid, x, y, z);
	//=============================[Lets set it up]=============================
	HouseInfo[HID][ID] = HID;
	new name[25];
	format(name,25,"None");
	HouseInfo[HID][Owner] = name;
	HouseInfo[HID][Locked] = 0;
	HouseInfo[HID][World] = HID;
	HouseInfo[HID][InteriorID] = interior;
	HouseInfo[HID][Price] = price;
	HouseInfo[HID][OX] = x;
	HouseInfo[HID][OY] = y;
	HouseInfo[HID][OZ] = z;
	new string[256];
    format(string, sizeof(string), "House Owned: No\nHouse Owner: None\nHouse Price: $%i", HouseInfo[HID][Price]);
	HouseInfo[HID][Label] = CreateDynamic3DTextLabel(string, -1, HouseInfo[HID][OX], HouseInfo[HID][OY], HouseInfo[HID][OZ]+0.5, 20.0);
	HouseInfo[HID][Icon] = CreateDynamicMapIcon(HouseInfo[HID][OX], HouseInfo[HID][OY], HouseInfo[HID][OZ], 31, -1);
	HouseInfo[HID][EnterPickup] = CreateDynamicPickup(1273, 23, HouseInfo[HID][OX], HouseInfo[HID][OY], HouseInfo[HID][OZ], -1, -1, -1, 20.0);
    mysql_format(SQL, query, sizeof(query), "INSERT INTO `"Houses_Table"` (ID, Owner, Owned, Locked, InteriorID, World, Price, OX, OY, OZ) VALUES ('%i', '%s', '%i', '%i', '%i', '%i', '%i', '%f', '%f', '%f')",
	HouseInfo[HID][ID], HouseInfo[HID][Owner], HouseInfo[HID][Owned], HouseInfo[HID][Locked], HouseInfo[HID][InteriorID], HouseInfo[HID][World], HouseInfo[HID][Price], HouseInfo[HID][OX], HouseInfo[HID][OY], HouseInfo[HID][OZ]);
	if(mysql_tquery(SQL, query, "", ""))
	    SendClientMessage(playerid, -1, "House was successfully created!");
	else
	    SendClientMessage(playerid, -1, "House was not created!");
	SetHouseExit(playerid, HID);
	CreatedHouses++;
	return 1;
}

CMD:housemenu(playerid,params[])
{
	new name[MAX_PLAYER_NAME];
	GetPlayerName(playerid,name,sizeof(name));
	if(pInfo[playerid][CurrentHID] == -1) return SendClientMessage(playerid,-1,"You are not inside an house!"); //If the player is not inside an house, then send this message..
	if(strcmp(name, HouseInfo[pInfo[playerid][CurrentHID]][Owner]) != 0) return SendClientMessage(playerid, -1, "You don't own this house!");

	ShowPlayerDialog(playerid, HMenu, DIALOG_STYLE_LIST, "House Menu", "(UN)Lock House\nChange Interior\nSell House\n", "Select", "Cancel");
	return 1;
}

CMD:gotohouse(playerid,params[])
{
	new hID;
	if(sscanf(params, "i", hID)) return SendClientMessage(playerid,-1, "Usage: /gotohouse (house id)");
	if(hID == 0 || hID < CreatedHouses) return SendClientMessage(playerid, -1, "Invalid house ID!");
	SetPlayerPos(playerid, HouseInfo[hID][OX], HouseInfo[hID][OY], HouseInfo[hID][OZ]);
	SetPlayerVirtualWorld(playerid, 0);
	SetPlayerInterior(playerid, 0);
	return 1;
}

CMD:buyhouse(playerid,params[])
{
	new id = 0, name[25], count = 0;
	for(new i=1; i<=CreatedHouses; i++)
	{
	    if(IsPlayerInRangeOfPoint(playerid, 4.0, HouseInfo[i][OX], HouseInfo[i][OY], HouseInfo[i][OZ]))
	    {
	        id = i;
	        break;
	    }
	}
	for(new i=1; i<=CreatedHouses; i++)
	{
	    GetPlayerName(playerid, name, sizeof(name));
	    if(strcmp(name, HouseInfo[i][Owner]) == 0)
	    {
	        count++;
	    }
	}
	if(id == 0) return SendClientMessage(playerid, -1, "You aren't near an house!");
	if(count >= 2) return SendClientMessage(playerid, -1, "You can't own more than 2 houses!");
	if(HouseInfo[id][Owned] == 1) return SendClientMessage(playerid, -1, "This house is already owned!");
	if(GetPlayerMoney(playerid) < HouseInfo[id][Price]) return SendClientMessage(playerid, -1, "You don't have enough money to buy this house!");
	GetPlayerName(playerid, name, 25);
	HouseInfo[id][Owned] = 1;
	HouseInfo[id][Owner] = name;
	GivePlayerMoney(playerid,-HouseInfo[id][Price]);
	new lString[256];
	DestroyDynamicMapIcon(HouseInfo[id][Icon]);
	HouseInfo[id][Icon] = CreateDynamicMapIcon(HouseInfo[id][OX], HouseInfo[id][OY], HouseInfo[id][OZ], 32, -1);
	format(lString, sizeof(lString),"House Owned: Yes\nHouse Owner: %s\nHouse Price: $%i\nHouse Locked: %s", HouseInfo[id][Owner], HouseInfo[id][Price], (HouseInfo[id][Locked] == 1) ? ("Yes") : ("No"));
   	UpdateDynamic3DTextLabelText(Text3D:HouseInfo[id][Label], -1, lString);
    mysql_format(SQL, query, sizeof(query),"UPDATE `"Houses_Table"` SET `Owned` = '%i', `Owner` = '%s' WHERE `ID` = '%i'",HouseInfo[id][Owned], HouseInfo[id][Owner], id);
	if(mysql_tquery(SQL, query, "", ""))
	    SendClientMessage(playerid, -1, "Congratulations on buying an new house! Access your house menu using /housemenu!");
	else
	    SendClientMessage(playerid, -1, "Some error occured! Please contact an admin!");
	PutPlayerInHouse(playerid, id);
	return 1;
}
//==============================================================================
forward LoadHouses();
public LoadHouses()
{
	for(new i=0; i<=MAX_HOUSES; i++)
	{
 	mysql_format(SQL, query, sizeof(query),"SELECT * FROM `"Houses_Table"` WHERE `ID` = '%i'", i);
 	mysql_query(SQL, query);
 	mysql_store_result();
	if(mysql_num_rows() == 0) break;
	else if(mysql_num_rows() != 0)
	    {
   	 	mysql_fetch_row_format(query);
   	 	sscanf(query, "e<p<|>is[25]iiiiiffffff>", HouseInfo[i]);
		new lString[256];
		switch(HouseInfo[i][Owned])
			{
				case 0:
				{
					format(lString, sizeof(lString), "House Owned: No\nHouse Owner: None\nHouse Price: $%i", HouseInfo[i][Price]);
					HouseInfo[i][Label] = CreateDynamic3DTextLabel(lString, -1, HouseInfo[i][OX], HouseInfo[i][OY], HouseInfo[i][OZ]+0.5, 20.0);
					HouseInfo[i][Icon] = CreateDynamicMapIcon(HouseInfo[i][OX], HouseInfo[i][OY], HouseInfo[i][OZ], 31, -1);
					HouseInfo[i][EnterPickup] = CreateDynamicPickup(1273, 23, HouseInfo[i][OX], HouseInfo[i][OY], HouseInfo[i][OZ], -1, -1, -1, 20.0);
					HouseInfo[i][ExitPickup] = CreateDynamicPickup(1273, 23, HouseInfo[i][IX], HouseInfo[i][IY], HouseInfo[i][IZ], -1, -1, -1, 20.0);
				}
				case 1:
				{
					format(lString, sizeof(lString),"House Owned: Yes\nHouse Owner: %s\nHouse Price: $%i\nHouse Locked: %s", HouseInfo[i][Owner], HouseInfo[i][Price], (HouseInfo[i][Locked] == 1) ? ("Yes") : ("No"));
					HouseInfo[i][Label] = CreateDynamic3DTextLabel(lString, -1, HouseInfo[i][OX], HouseInfo[i][OY], HouseInfo[i][OZ]+0.5, 20.0);
					HouseInfo[i][Icon] = CreateDynamicMapIcon(HouseInfo[i][OX], HouseInfo[i][OY], HouseInfo[i][OZ], 32, -1);
					HouseInfo[i][EnterPickup] = CreateDynamicPickup(1273, 23, HouseInfo[i][OX],HouseInfo[i][OY], HouseInfo[i][OZ], -1, -1, -1, 20.0);
					HouseInfo[i][ExitPickup] = CreateDynamicPickup(1273, 23, HouseInfo[i][IX], HouseInfo[i][IY], HouseInfo[i][IZ], -1, -1, -1, 20.0);
				}
			}
		CreatedHouses++;
	}
 }
	mysql_free_result();
	printf("[House System] %i houses were retrieved..", CreatedHouses);
	return 1;
}
//==============================================================================
forward SetHouseExit(playerid, houseid);
public SetHouseExit(playerid, houseid)
{
	switch(HouseInfo[houseid][InteriorID])
	{
	    case 1:
	    {
	        HouseInfo[houseid][IX] = 2466.5610;
	        HouseInfo[houseid][IY] = -1698.3323;
	        HouseInfo[houseid][IZ] = 1013.5078;
	        HouseInfo[houseid][ExitPickup] = CreateDynamicPickup(1273, 23, HouseInfo[houseid][IX], HouseInfo[houseid][IY], HouseInfo[houseid][IZ], -1, -1, -1, 20.0);
            mysql_format(SQL, query, sizeof(query),"UPDATE `"Houses_Table"` SET `IX` = '%f', `IY` = '%f', `IZ` = '%f' WHERE `ID` = '%i'", HouseInfo[houseid][IX], HouseInfo[houseid][IY], HouseInfo[houseid][IZ], houseid);
			mysql_tquery(SQL, query, "", "");
		}
		case 2:
		{
            HouseInfo[houseid][IX] = 327.9615;
	        HouseInfo[houseid][IY] = 1478.2103;
	        HouseInfo[houseid][IZ] = 1084.4375;
	        HouseInfo[houseid][ExitPickup] = CreateDynamicPickup(1273, 23, HouseInfo[houseid][IX], HouseInfo[houseid][IY], HouseInfo[houseid][IZ], -1, -1, -1, 20.0);
			mysql_format(SQL, query, sizeof(query),"UPDATE `"Houses_Table"` SET `IX` = '%f', `IY` = '%f', `IZ` = '%f' WHERE `ID` = '%i'", HouseInfo[houseid][IX], HouseInfo[houseid][IY], HouseInfo[houseid][IZ], houseid);
	        mysql_tquery(SQL, query, "", "");
		}
	}
	return 1;
}

forward PutPlayerInHouse(playerid, houseid);
public PutPlayerInHouse(playerid, houseid)
{
	switch(HouseInfo[houseid][InteriorID])
	{
	    case 1:
	    {
	        SetPlayerInterior(playerid, 2);
	        SetPlayerPos(playerid, 2465.2151, -1698.3086, 1013.5078);
	        SetPlayerVirtualWorld(playerid, HouseInfo[houseid][World]);
	        pInfo[playerid][CurrentHID] = houseid;
	    }
	    case 2:
	    {
	        SetPlayerInterior(playerid, 15);
	        SetPlayerPos(playerid, 328.6252, 1480.5461, 1084.4375);
	        SetPlayerVirtualWorld(playerid, HouseInfo[houseid][World]);
	        pInfo[playerid][CurrentHID] = houseid;
	    }
	}
	return 1;
}

forward KickFromHouse(playerid, houseid);
public KickFromHouse(playerid, houseid)
{
	SetPlayerInterior(playerid, 0);
	SetPlayerPos(playerid, HouseInfo[houseid][OX]+0.5, HouseInfo[houseid][OY]+0.5, HouseInfo[houseid][OZ]);
	SetPlayerVirtualWorld(playerid, 0);
	pInfo[playerid][CurrentHID] = -1;
	return 1;
}
My problem is only while when the filterscript start and the house doesnt load
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#8

12.07.2014, 17:25
Read the tutorial: https://sampforum.blast.hk/showthread.php?tid=337810
Read the wiki (R33+): https://sampwiki.blast.hk/wiki/MySQL/R33

Update to R39-2 and use:
pawn Код:
LoadHouses()
{
    mysql_tquery(SQL, "SELECT * FROM "Houses_Table"", "CB_LoadHouses", "");
}

forward CB_LoadHouses();
public CB_LoadHouses()
{
    for (new i = 0, rows = cache_num_rows(); i != rows; ++i)
    {
        if (i >= sizeof (HouseInfo)) break;
        
        // assign the values to the variables.. and use "i" as rowid.
        // cache_get_row(_int/_float) or cache_get_field_content(_int/_float)
        
        new lString[100];
        switch(HouseInfo[i][Owned])
        {
            case 0:
            {
                format(lString, sizeof(lString), "House Owned: No\nHouse Owner: None\nHouse Price: $%i", HouseInfo[i][Price]);
                HouseInfo[i][Label] = CreateDynamic3DTextLabel(lString, -1, HouseInfo[i][OX], HouseInfo[i][OY], HouseInfo[i][OZ]+0.5, 20.0);
                HouseInfo[i][Icon] = CreateDynamicMapIcon(HouseInfo[i][OX], HouseInfo[i][OY], HouseInfo[i][OZ], 31, -1);
                HouseInfo[i][EnterPickup] = CreateDynamicPickup(1273, 23, HouseInfo[i][OX], HouseInfo[i][OY], HouseInfo[i][OZ], -1, -1, -1, 20.0);
                HouseInfo[i][ExitPickup] = CreateDynamicPickup(1273, 23, HouseInfo[i][IX], HouseInfo[i][IY], HouseInfo[i][IZ], -1, -1, -1, 20.0);
            }
            case 1:
            {
                format(lString, sizeof(lString),"House Owned: Yes\nHouse Owner: %s\nHouse Price: $%i\nHouse Locked: %s", HouseInfo[i][Owner], HouseInfo[i][Price], (HouseInfo[i][Locked] == 1) ? ("Yes") : ("No"));
                HouseInfo[i][Label] = CreateDynamic3DTextLabel(lString, -1, HouseInfo[i][OX], HouseInfo[i][OY], HouseInfo[i][OZ]+0.5, 20.0);
                HouseInfo[i][Icon] = CreateDynamicMapIcon(HouseInfo[i][OX], HouseInfo[i][OY], HouseInfo[i][OZ], 32, -1);
                HouseInfo[i][EnterPickup] = CreateDynamicPickup(1273, 23, HouseInfo[i][OX],HouseInfo[i][OY], HouseInfo[i][OZ], -1, -1, -1, 20.0);
                HouseInfo[i][ExitPickup] = CreateDynamicPickup(1273, 23, HouseInfo[i][IX], HouseInfo[i][IY], HouseInfo[i][IZ], -1, -1, -1, 20.0);
            }
        }
        CreatedHouses++;
    }
    printf("[House System] %i houses were retrieved..", CreatedHouses);
}
@electrux: "Houses_Table" is defined and the usage of the sscanf is fine even though it's not needed.
Find
Reply
electrux
Big Clucker
***
Posts: 108
Threads: 13
Joined: May 2012
Reputation: 0
#9

12.07.2014, 17:29
is it? ok my bad then :/ gotta check that up again... thanks for correcting
Find
Reply
leo9
Little Clucker
**
Posts: 46
Threads: 10
Joined: May 2014
Reputation: 0
#10

12.07.2014, 17:31
and the sql is
Код:
-- phpMyAdmin SQL Dump
-- version 4.1.5
-- http://www.phpmyadmin.netnl674d154ec384b...8.12463179-- Host: localhost
-- Generation Time: May 28, 2014 at 09:29 AM
-- Server version: 5.5.35
-- PHP Version: 5.4.24

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `ESTUNT_6517`
--

-- --------------------------------------------------------

--
-- Table structure for table `Houses`
--

CREATE TABLE IF NOT EXISTS `Houses` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Owner` varchar(25) NOT NULL,
  `Owned` int(11) NOT NULL,
  `Locked` int(11) NOT NULL,
  `InteriorID` int(11) NOT NULL,
  `World` int(11) NOT NULL,
  `Price` int(11) NOT NULL,
  `OX` float NOT NULL,
  `OY` float NOT NULL,
  `OZ` float NOT NULL,
  `IX` float NOT NULL,
  `IY` float NOT NULL,
  `IZ` float NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ID` (`ID`,`Owner`,`Owned`,`Locked`,`InteriorID`,`World`,`Price`,`OX`,`OY`,`OZ`,`IX`,`IY`,`IZ`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help