[Tanush123]

So i have a command called /settax which sets everyone Tax to the amount on the server and on my mysql database (accounts\Tax). How can i make that if someone registers, it will set their tax to the one the president has?

[DaTa[X]]

example

pawn Код:

new Query[200];
format(Query,sizeof(Query)," INSERT INTO `PlayerData`(/*name,pass,etc..*/`Tax`) VALUES('%s')",tax);

[Tanush123]

i need to detect the Tax from the president on mysql if they are offline.

[Vince]

Subqueries.

[Tanush123]

Quote:

Originally Posted by Vince Subqueries.

How i do that?

[Vince]

PHP код:

UPDATE playerdata SET tax = (SELECT tax FROM sometable WHERE status = 'president') WHERE psqlid = 1;