[delachambre]

doesn't works.

[11530]

Originally Posted by delachambre doesn't works.

Well, it does work because I tried it, and posted you the output. This means that when I asked:

Originally Posted by 11530 Stupid question, but since nothing works for you, I may as well ask: Have you actually created the roleplay database for the plugin already? Have you used the right log-in details with databases.cfg? Does the MySQL user have the necessary privileges (SELECT, UPDATE)?

And you said 'yes' to all, one or more of those answers is wrong...

We'll have to go through each one carefully.

1) Post your databases.cfg file without passswords.
2) Can you use other MySQL plugins ok?
3) Post the MySQL output of

show grants for 'YOUR_USERNAME_HERE'@'localhost';

[delachambre]

The problem is not SQL side, it is in the loop .... the PrintToChat not done in the game and iNum is not added to the variable "bank"

[xbatista]

Your mysql handle kind of weird, it is easier to register mysql connection on plugin start and then do whatever you want, without need hundred times connecting.

PHP Code:

SQL_TQuery(db, GetBank, query, data);
        
CloseHandle(db); 


I'm not sure, but I think first of these functions -> CloseHandle, will function firstly, then TQuery, because query has a time that is passed to execute it.

Or at 11530 given code, try to add a timer for 0.5 seconds delay, then use this code:

PHP Code:

    SQL_TConnect(ConnectCallback, "roleplay"); 


[11530]

Originally Posted by delachambre The problem is not SQL side, it is in the loop .... the PrintToChat not done in the game and iNum is not added to the variable "bank"

[DONS-RP] : Vous avez reçu 100$ pour votre achat en ligne.
[ADMIN] [DRACO] 11530 :  !givemoney "STEAM_0:0:6070829" 100
...
[DONS-RP] : Vous avez reçu 300$ pour votre achat en ligne.
[ADMIN] [DRACO] 11530 :  !givemoney "STEAM_0:0:6070829" 300

Like I said, everything is working well.

[delachambre]

Fixed ! Thanks a lot !

[11530]

What was the answer that fixed it? Or did you forget something?

[delachambre]

I have forget a little code ^^