Next, I have a game server and I'm trying to automate the purchase of cash on my site (the user buys cash to spend on the game).
I have a table in my bank called USERS:
user_id (A.I)
user_name
user_pass
user_email
dias_vip (definido por padrão = 0 )
And I have a table called REQUESTS:
id (A.I)
descricao
status
user_name
The USERS table is controlled by my registration page, OK.
The orders table only works when the person is logged into the site and buys "cash" to spend on the game. And it is activated along with the pagseguro. In short, the user logs into the site and has a buy button of 100 cashs, he clicks on this button and then I record user_name on the ORDERS table and status = 1 (q is the default for "WAITING FOR PAYMENT"). When the person makes the payment automatically I get a notification of the pagseguro and a function changes the status to 3 that means "PAYMENT".
Let's ask the question itself: I would like to know if I can create an EVENT that adds 100 in the days_vip field of the USERS table when the payment status is 3.
If someone can help me, I just need to finish this process, thanks!