[GameMode] Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords]

[GameMode] Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - 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: Gamemode Scripts (https://sampforum.blast.hk/forumdisplay.php?fid=71)
+--- Thread: [GameMode] Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] (/showthread.php?tid=390428)

Pages: 1 2

Basic MySQL R8 Account Script [cache functions, easydialog, Whirlpool, salted passwords] - ReneG - 06.11.2012

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.

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - XtremeR - 06.11.2012

nice and useful, +3 reps

btw it should be in Filterscripts section no?

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - RajatPawar - 06.11.2012

Thanks, will be useful for beginners like me!

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - Davevid - 06.11.2012

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

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - Team_PRO - 06.11.2012

Um Nice Work

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - iOmar - 06.11.2012

Great And really Helpfull +Rep

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - sgtjones12 - 06.11.2012

Nice work man

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - AliceCullen - 06.11.2012

DB ?

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - marmigs - 06.11.2012

Quote:

Originally Posted by AliceCullen

DB ?

Is already on the script.

Thanks it will be useful to begginers in MySQL like me

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - TheArcher - 06.11.2012

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

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - Calgon - 06.11.2012

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

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - Roddan - 06.11.2012

Nice !!

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - CoDeZ - 06.11.2012

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]

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - Ironboy - 06.11.2012

It usefull, good work

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - ReneG - 06.11.2012

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.

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - Calgon - 06.11.2012

Quote:

Originally Posted by VincentDunn

You're lying.

Try crack an unsalted Whirlpool password.

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - ReneG - 06.11.2012

Quote:

Originally Posted by Calgon

Try crack an unsalted Whirlpool password.

I think you already know I can't.

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - Mikkel - 06.11.2012

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.

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - Emmet_ - 06.11.2012

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

Re: Basic MySQL Account Script [MySQL R7, cache functions, easydialog, Whirlpool, salted passwords] - AliceCullen - 07.11.2012

run time error 19 file or function is not found