[Tutorial] MySQL - Event scheduler

[Tutorial] MySQL - Event scheduler - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Tutorials (https://sampforum.blast.hk/forumdisplay.php?fid=70)
+---- Thread: [Tutorial] MySQL - Event scheduler (/showthread.php?tid=546630)

Pages: 1 2

Re: MySQL - Event scheduler - RenovanZ - 18.11.2014

Wow! It's a great tutorial!
It will be very useful, thanks!

Re: MySQL - Event scheduler - Lordzy - 26.11.2014

I've added the following to the tutorial:

• Listing events.
- Retrieving event information using MySQL plugin on PAWN.
• Dropping events.

Re: MySQL - Event scheduler - Arastair - 26.11.2014

Seems awesome, I'll be useful for me someday

Re: MySQL - Event scheduler - Luis- - 26.11.2014

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.

Re: MySQL - Event scheduler - Finn - 26.11.2014

Quote:

Originally Posted by Luis-

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?

Re: MySQL - Event scheduler - Djole1337 - 26.11.2014

Quote:

Originally Posted by Finn

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)

Re: MySQL - Event scheduler - Luis- - 26.11.2014

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.

Re: MySQL - Event scheduler - Finn - 26.11.2014

Quote:

Originally Posted by Luis-

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

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?

Re: MySQL - Event scheduler - fall3n - 25.12.2014

Quote:

Originally Posted by Jay_

You learn something new every day - this is a feature I really did not know existed

I'm not really a fan of your example though - I haven't done any background reading around this yet so don't know how it works or performs, but surely it would be more efficient to check whether the user should be unbanned when they next attempt to join the server and login to their account.

I know I'm quoting this late but nevertheless - It's better to have automatic unbans instead of player trying to connect and then getting unbanned. It can be used to view ban logs or display ban data of the player which displays since when the player got unbanned and all.

OT : Nice one but you should also create an example on automatic backups like RajatPawar suggested.

Re: MySQL - Event scheduler - HydraHumza - 05.10.2015

Really nice one. I never knew that before about this thing.
REP +

Re: MySQL - Event scheduler - Lordzy - 19.12.2016

Tutorial updated by adding code for R40th version of MySQL plugin.

Re: MySQL - Event scheduler - Eoussama - 31.05.2018

Super useful, can't believe I'm this late to this.