[ReneG]

MySQL Example Account Script
WARNING: Not for scripters unfamiliar with MySQL.

About

I quickly made this script to hopefully encourage the use of the most up-to-date methods of MySQL, and to encourage scripters to practice password-salting. This script includes.

• A very basic dialog-based, login/register feature.
• Salted passwords, hashed with Whirlpool.
• Use of threaded queries with the advantage of the cache functions for lighting fast data parsing.

Image

GitHub

Credits

BlueG - MySQL Plugin
RyDeR` - Random string function used as the salt
Emmet_ - Easydialog include
AndreT - His tutorial on the cache functions
****** - Whirlpool
Glint - Tutorial on password salting
VincentDunn - Writing the script

You are free to do whatever you want with this script.

[XtremeR]

nice and useful, +3 reps

btw it should be in Filterscripts section no?

[RajatPawar]

Thanks, will be useful for beginners like me!

[Davevid]

Thanks alot! my friend's been looking for this, don't wanna share my scripts with him :P

[Team_PRO]

Um Nice Work

[iOmar]

Great And really Helpfull +Rep

[sgtjones12]

Nice work man

[AliceCullen]

DB ?

[marmigs]

Quote:

Originally Posted by AliceCullen DB ?

Is already on the script.

---

Thanks it will be useful to begginers in MySQL like me

[TheArcher]

Awesome, I was really waiting for MySQL cache examples into a gamemode

[Calgon]

There's not really any need to salt with Whirlpool IMO.

[Roddan]

Nice !!

[CoDeZ]

Thanks you, but can you please explain this part because i don't get it :/

pawn Код:

#define     posArr{%0}      %0[0], %0[1], %0[2]   
#define     posArrEx{%0}    %0[0], %0[1], %0[2], %0[3]

[Ironboy]

It usefull, good work

[ReneG]

Quote:

Originally Posted by Calgon There's not really any need to salt with Whirlpool IMO.

You're lying.

Quote:

Originally Posted by CoDeZ Thanks you, but can you please explain this part because i don't get it :/ pawn Код: #define     posArr{%0}      %0[0], %0[1], %0[2]   #define     posArrEx{%0}    %0[0], %0[1], %0[2], %0[3]

http://forum.sa-mp.com/showpost.php?...postcount=3711

Quote:

Originally Posted by XtremeR nice and useful, +3 reps btw it should be in Filterscripts section no?

This script isn't intended to be used on a public server. It's just to give current MySQL scripters an idea on how to build an account script using threaded queries and the cache functions that were introduced to MySQL R7.

[Calgon]

Quote:

Originally Posted by VincentDunn You're lying.

Try crack an unsalted Whirlpool password.

[ReneG]

Quote:

Originally Posted by Calgon Try crack an unsalted Whirlpool password.

I think you already know I can't.

[Mikkel]

I think this script is a good idea, and nonetheless I think it's nice that you're using a lot of different features, such as the "salted" passwords which there are a little arguing going on about, however I think it's nice to draw in such features, the more the better lol, also when people learn from a script like this they should be able to erase the "salted passwords" feature if they think it's a waste of time and work. Definitely going to look into this if I'm going to use MySQL at some point.

[Emmet_]

Thanks for this, been waiting for a while for a basic GM that uses R7 cache functions. I'll probably use it to improve my MySQL cache knowledge and eventually build off it!

EDIT: Also noticed that you're using easydialog.inc! Didn't think I'd see a released script using it. Glad you used it though

[AliceCullen]

run time error 19 file or function is not found