2 different Column - Printable Version

2 different Column - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: 2 different Column (/showthread.php?tid=595124)

2 different Column - vassilis - 28.11.2015

nevermind!

Re: 2 different Column - TwinkiDaBoss - 28.11.2015

pawn Код:

mysql_format(mysql,query,sizeof(query), "UPDATE `houses` SET `HOwned` = %i WHERE `ID`=%d",players.ID,HouseInfo[HouseID?]);
mysql_query(mysql, query);

Simple, change your `HOwned` value to players.ID or whatever you are using to get their SQL ID

Re: 2 different Column - vassilis - 29.11.2015

Quote:

Originally Posted by TwinkiDaBoss

pawn Код:

mysql_format(mysql,query,sizeof(query), "UPDATE `houses` SET `HOwned` = %i WHERE `ID`=%d",players.ID,HouseInfo[HouseID?]);
mysql_query(mysql, query);

Simple, change your `HOwned` value to players.ID or whatever you are using to get their SQL ID

Is it really so simple?

Re: 2 different Column - vassilis - 29.11.2015

Quote:

Originally Posted by Ralfie

The player is buying a house, so he is online. Then you can easily load the SQL ID when the player connects (which you should do) to a variable and use it...

If you don't mind could you give me an example?

Re: 2 different Column - vassilis - 30.11.2015

Any solution?

Re: 2 different Column - Kevln - 30.11.2015

Execute a query for each table, that's all.

Re: 2 different Column - vassilis - 01.12.2015

Quote:

Originally Posted by Kevln

Execute a query for each table, that's all.

I want to get the value from ID and set it to HouseOwnerID..

Re: 2 different Column - vassilis - 01.12.2015

Help D: