SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help > Tutorials

Reply
 
Thread Tools Display Modes
Old 18/11/2014, 08:48 AM   #21
RenovanZ
Gangsta
 
RenovanZ's Avatar
 
Join Date: Jul 2012
Location: Jogjakarta, Indonesia
Posts: 600
Reputation: 32
Default Re: MySQL - Event scheduler

Wow! It's a great tutorial!
It will be very useful, thanks!
__________________
__________________________________________________
My Work(s)
__________________________________________________

RenovanZ is offline   Reply With Quote
Old 26/11/2014, 10:16 AM   #22
Lordzy
High-roller
 
Join Date: Mar 2012
Location: NetherRealm
Posts: 2,765
Reputation: 1172
Default Re: MySQL - Event scheduler

I've added the following to the tutorial:

• Listing events.
- Retrieving event information using MySQL plugin on PAWN.
• Dropping events.
__________________
Currently inactive - I don't play at any SA-MP servers nor work on anything in PAWN for now. The projects that I've done so far in PAWN, which requires updates will be taking some time.
Lordzy is offline   Reply With Quote
Old 26/11/2014, 10:42 AM   #23
Arastair
Gangsta
 
Join Date: Jun 2014
Posts: 832
Reputation: 49
Default Re: MySQL - Event scheduler

Seems awesome, I'll be useful for me someday
__________________
"War does not determine who is right... only who is left"
Arastair is offline   Reply With Quote
Old 26/11/2014, 12:24 PM   #24
Luis-
High-roller
 
Luis-'s Avatar
 
Join Date: Jan 2010
Location: England
Posts: 4,076
Reputation: 378
Default Re: MySQL - Event scheduler

This is actually very useful for cleaning my database! I can now add in to schedule it to delete accounts that haven't logged in for over x amount of days.

Thanks.
Luis- is offline   Reply With Quote
Old 26/11/2014, 01:34 PM   #25
Finn
High-roller
 
Join Date: Jan 2008
Posts: 1,703
Reputation: 382
Default Re: MySQL - Event scheduler

Quote:
Originally Posted by Luis- View Post
This is actually very useful for cleaning my database! I can now add in to schedule it to delete accounts that haven't logged in for over x amount of days.

Thanks.
Woah, that's cruel, why would you do that?
Finn is offline   Reply With Quote
Old 26/11/2014, 01:41 PM   #26
Djole1337
Gangsta
 
Join Date: Apr 2012
Posts: 905
Reputation: 303
Default Re: MySQL - Event scheduler

Quote:
Originally Posted by Finn View Post
Woah, that's cruel, why would you do that?
Personally I'd do the same thing, if the player hasn't logged in for 2 months. (Of course only if the player hasn't purchased VIP/Donator status)
Djole1337 is offline   Reply With Quote
Old 26/11/2014, 01:56 PM   #27
Luis-
High-roller
 
Luis-'s Avatar
 
Join Date: Jan 2010
Location: England
Posts: 4,076
Reputation: 378
Default Re: MySQL - Event scheduler

Yeah, should of said months instead of days, personally, I think it's only fair, if they haven't logged in over say 2 or 3 months they should start again.
Luis- is offline   Reply With Quote
Old 26/11/2014, 01:58 PM   #28
MD5
Huge Clucker
 
MD5's Avatar
 
Join Date: Nov 2014
Location: United Kingdom
Posts: 256
Reputation: 24
Default Re: MySQL - Event scheduler

Just redid my VIP expiration system using this method, thanks.
__________________
MD5 is offline   Reply With Quote
Old 26/11/2014, 04:24 PM   #29
Lordzy
High-roller
 
Join Date: Mar 2012
Location: NetherRealm
Posts: 2,765
Reputation: 1172
Default Re: MySQL - Event scheduler

I just noticed that moments ago while editing, I removed one-third of my tutorial. I've fixed them now, if there's any corrections to be made, please feel free to post it here. Part from "listing events" to the end has been rewritten.
__________________
Currently inactive - I don't play at any SA-MP servers nor work on anything in PAWN for now. The projects that I've done so far in PAWN, which requires updates will be taking some time.
Lordzy is offline   Reply With Quote
Old 26/11/2014, 05:47 PM   #30
Finn
High-roller
 
Join Date: Jan 2008
Posts: 1,703
Reputation: 382
Default Re: MySQL - Event scheduler

Quote:
Originally Posted by Luis- View Post
Yeah, should of said months instead of days, personally, I think it's only fair, if they haven't logged in over say 2 or 3 months they should start again.
Quote:
Originally Posted by Djole1337 View Post
Personally I'd do the same thing, if the player hasn't logged in for 2 months. (Of course only if the player hasn't purchased VIP/Donator status)
Neither of you answered my question: why would you punish a player who comes back to your server?
Finn is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[FilterScript] Rajat's Event system! (Lockable, Event wins, guns) RajatPawar Filterscripts 14 07/03/2015 06:30 PM
[FilterScript] S-Event (Advanced Event System) marcelodell Lançamentos/Releases 54 12/04/2014 03:54 AM
Task scheduler Dragony92 Scripting Help 4 17/02/2012 12:35 AM
How to make /event start an actual event Snowman12 Help Archive 7 03/04/2011 11:39 PM


All times are GMT. The time now is 08:18 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.