[vassilis]

nevermind!

[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

[vassilis]

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?

[vassilis]

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?

[vassilis]

Any solution?

[Kevln]

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

[vassilis]

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..

[vassilis]

Help D: