[Tutorial] Easy MySQL Register/Login system!
#41

1. NEVER save passwords as plain text, never. Hash it (I'd recommend Whirlpool or SHA2) and salt it (prevents dictionary attacks).
Storing the password as text is a major security threat. If the database is ever compromised, the hacker will get the password immediately.

2. Add `id` field to the table (primary index, auto increment, unsigned integer)
This makes it easier and more efficient to deal with the accounts.

3. You should utilize the great caching functionality of the MySQL plugin. Fetching data is much more efficient using the cache.

4. Consider using ZCMD or YCMD instead OF DCMD, they are both faster than DCMD.

Quote:
Originally Posted by [HiC]TheKiller
View Post
1. Instead of using a enum just use PVars for all of them.
I would recommend this only if you might need to access the data for example from filterscripts as well. https://sampforum.blast.hk/showthread.php?tid=268499
Reply


Messages In This Thread
Easy MySQL Register/Login system! (Includes every single step!) - by WackoX - 18.07.2010, 12:24
Re: Easy MySQL Register/Login system! - by Calgon - 18.07.2010, 13:08
Re: Easy MySQL Register/Login system! - by WackoX - 18.07.2010, 14:21
Re: Easy MySQL Register/Login system! - by Kar - 18.07.2010, 15:18
Re: Easy MySQL Register/Login system! - by Lewwy - 18.07.2010, 15:21
Re: Easy MySQL Register/Login system! - by WackoX - 18.07.2010, 16:01
Re: Easy MySQL Register/Login system! - by Lewwy - 18.07.2010, 16:25
Re: Easy MySQL Register/Login system! - by WackoX - 18.07.2010, 17:36
Re: Easy MySQL Register/Login system! - by [HiC]TheKiller - 18.07.2010, 19:32
Re: Easy MySQL Register/Login system! - by Lewwy - 18.07.2010, 19:48
Re: Easy MySQL Register/Login system! - by WackoX - 18.07.2010, 20:12
Re: Easy MySQL Register/Login system! - by [HiC]TheKiller - 19.07.2010, 06:28
Re: Easy MySQL Register/Login system! - by Scenario - 19.07.2010, 06:35
Re: Easy MySQL Register/Login system! - by Яσскѕтая - 21.07.2010, 11:17
Re: Easy MySQL Register/Login system! - by Gforcez - 21.07.2010, 14:31
Re: Easy MySQL Register/Login system! - by Luis_Leone - 31.07.2010, 22:07
Re: Easy MySQL Register/Login system! - by WackoX - 02.08.2010, 16:44
Re: Easy MySQL Register/Login system! - by RealLifeRP - 03.08.2010, 04:41
Re: Easy MySQL Register/Login system! - by Vince - 03.08.2010, 12:37
Re: Easy MySQL Register/Login system! - by WackoX - 03.08.2010, 17:16
Re: Easy MySQL Register/Login system! - by Martin_Santiago - 05.08.2010, 07:39
Re: Easy MySQL Register/Login system! - by WackoX - 05.08.2010, 08:45
Re: Easy MySQL Register/Login system! - by Kyle - 09.08.2010, 19:34
Re: Easy MySQL Register/Login system! - by playbox12 - 17.08.2010, 20:23
Re: Easy MySQL Register/Login system! - by KotoK - 26.12.2010, 21:27
Re: Easy MySQL Register/Login system! - by Anthonyx3' - 08.01.2011, 20:08
Re: Easy MySQL Register/Login system! - by [MWR]Blood - 15.01.2011, 14:26
Re: Easy MySQL Register/Login system! - by Anthonyx3' - 15.01.2011, 14:45
Re: Easy MySQL Register/Login system! - by THE_KNOWN - 15.01.2011, 15:27
Re: Easy MySQL Register/Login system! - by THE_KNOWN - 21.01.2011, 04:35
Re: Easy MySQL Register/Login system! - by HyperZ - 31.01.2011, 07:31
Re: Easy MySQL Register/Login system! - by jesse237 - 05.02.2011, 13:00
Re: Easy MySQL Register/Login system! - by TheLazySloth - 11.10.2011, 12:04
Re : Easy MySQL Register/Login system! - by falor - 22.02.2012, 03:29
Re: Easy MySQL Register/Login system! - by ArmyOps - 22.02.2012, 10:02
Re: Easy MySQL Register/Login system! - by swindle69 - 22.02.2012, 23:43
Respuesta: Easy MySQL Register/Login system! - by ValenRatti - 26.02.2012, 07:48
Re: Easy MySQL Register/Login system! - by x96664 - 19.07.2012, 13:33
Re: Easy MySQL Register/Login system! - by Yashas - 04.12.2012, 00:22
Re: Easy MySQL Register/Login system! - by x96664 - 04.12.2012, 15:00
Re: Easy MySQL Register/Login system! - by Johnson_boy - 05.12.2012, 14:36
Re : Easy MySQL Register/Login system! - by [HRD]Mar1 - 06.12.2012, 12:39
Re: Easy MySQL Register/Login system! - by SAMPHacker - 23.01.2013, 16:20
Re: Easy MySQL Register/Login system! - by Yashas - 05.02.2013, 12:56
Re: Easy MySQL Register/Login system! - by Kiweeh - 30.05.2013, 13:37
Re: Easy MySQL Register/Login system! - by Mr.R - 26.06.2013, 19:19
Re: Easy MySQL Register/Login system! - by Vince - 26.06.2013, 20:52
Re : Easy MySQL Register/Login system! - by TomYeager - 17.08.2013, 22:15
Re: Easy MySQL Register/Login system! - by Dejan12345 - 19.07.2016, 12:14
Re: Easy MySQL Register/Login system! - by Melktert - 11.04.2017, 19:25
Re: Easy MySQL Register/Login system! - by FatihBey - 11.07.2017, 19:16
Re: Easy MySQL Register/Login system! - by coool - 12.07.2017, 07:36

Forum Jump:


Users browsing this thread: 1 Guest(s)