House help
#4

PHP код:
mysql_format(g_SQLquerysizeof(query), "UPDATE `houses` SET `OwnerCheck` = 1, `Locked` = 1, `OwnerName` = '%s'"GetName(playerid)); 
might be wrong cause it will update to all rows in table

you have to add

WHERE `house_id_field_name` = '%d'

like

PHP код:
mysql_format(g_SQLquerysizeof(query), "UPDATE `houses` SET `OwnerCheck` = 1, `Locked` = 1, `OwnerName` = '%s' WHERE `house_id_field_name` = '%d'"GetName(playerid), i);
//or change i that is you use to house id 
if you haven't that var of house_id in mysql,
create it and load it when load houses and create house
Reply


Messages In This Thread
House help - by Micko123 - 27.11.2016, 09:53
Re: House help - by BrianFaria - 27.11.2016, 09:58
Re: House help - by Micko123 - 27.11.2016, 09:59
Re: House help - by Alvitr - 27.11.2016, 10:05
Re: House help - by BrianFaria - 27.11.2016, 10:05
Re: House help - by Micko123 - 27.11.2016, 10:20

Forum Jump:


Users browsing this thread: 1 Guest(s)