Make event for vip

[Proximity]

How do I make a navicat mysql event to give 175 credits to ranks 3-5 so it updates.. etc this is phoenix emu
 
BUMP no one be helping me for SHIT

 

[Wickd]

What?

 

[Proximity]

How do I make it so users with vip ranks get more credits each hour

 

[Donnyschr]

That's C# related, i think like just copy the little script that is giving users credits on a hour, and make them like rank 2/3/4 whatever your VIP rank is.

 

[Proximity]

Donny add me on skype kyle.fibre

 

[Divide]

I never knew you people at DevBest could be so retarded. ( aimed towards @Donnyschr and @Wickd )

@ProjectAssassin here's a tutorial for you.
1. Click on 'Event' at the top (open a database first):

2. Click 'New Event':

3. In the 'Definition' tab put the following:

UPDATE users SET credits = credits + 175 WHERE rank >= 3 AND rank <= 5

4. In the 'Schedule' tab press the '+ INTERVAL' and set when you want to give 175 credits to rank 3-5.

5. Press Save.


If this error comes up:

Please run the following query if this error occurs.

SET GLOBAL event_scheduler = ON;
SET @@global.event_scheduler = ON;
SET GLOBAL event_scheduler = 1;
SET @@global.event_scheduler = 1;

 

[Proximity]

Thanks! @Divide

 

[Wickd]

I never knew you people at DevBest could be so retarded. ( aimed towards @Donnyschr and @Wickd )

@ProjectAssassin here's a tutorial for you.
1. Click on 'Event' at the top (open a database first):

2. Click 'New Event':

3. In the 'Definition' tab put the following:

UPDATE users SET credits = credits + 175 WHERE rank >= 3 AND rank <= 5

4. In the 'Schedule' tab press the '+ INTERVAL' and set when you want to give 175 credits to rank 3-5.

5. Press Save.


If this error comes up:

Please run the following query if this error occurs.

SET GLOBAL event_scheduler = ON;
SET @@global.event_scheduler = ON;
SET GLOBAL event_scheduler = 1;
SET @@global.event_scheduler = 1;

Woah pal

 

[Donnyschr]

I thought he ment a event in the client. Not the website lol, and im not retarted ff.