[Tutorial] How to make a register system ( Dialogs, SQLite and rBits )
#14

Nicely explained, however, there are a few errors and or unnecessary things done I would like to point out:
  • You free a result when you don't select anything (when creating the table if not exists)
  • You don't free the result after selecting information (under OnPlayerConnect)
  • You use ` around field names (only necessary around table names)
  • You use ' around integer values (only necessary around strings)
  • You check if the player is registered under OnDialogResponse in the registration dialog, even though you only show it if they are registered
  • When seeing if the player is registered, you select ALL their information, which is unnecessary, and even inefficient with large amounts of fields. Just retrieve one value.
That was just a quick look at the code, didn't study it much. Not to put you down! I'm just trying to help you improve this tutorial.
Reply


Messages In This Thread
How to make a register system ( Dialogs, SQLite and rBits ) - by Lorenc_ - 21.08.2011, 03:54
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Jack_Wilson - 21.08.2011, 03:55
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Lorenc_ - 21.08.2011, 04:19
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Kush - 21.08.2011, 07:21
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Davz*|*Criss - 21.08.2011, 07:24
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by juraska - 21.08.2011, 08:17
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Kaperstone - 21.08.2011, 10:08
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Darnell - 21.08.2011, 10:57
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Lorenc_ - 21.08.2011, 11:27
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Kush - 21.08.2011, 12:06
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Scenario - 21.08.2011, 12:09
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by antonio112 - 21.08.2011, 13:02
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Lorenc_ - 21.08.2011, 22:01
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Bakr - 22.08.2011, 02:13
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Lorenc_ - 22.08.2011, 06:41
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Tee - 22.08.2011, 08:43
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Lorenc_ - 22.08.2011, 09:08
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Cowboy - 22.08.2011, 11:48
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by HyperZ - 22.08.2011, 13:44
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Gh0sT_ - 22.08.2011, 14:32
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Bakr - 22.08.2011, 14:40
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Cowboy - 22.08.2011, 14:50
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by AndreT - 22.08.2011, 18:05
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Lorenc_ - 23.08.2011, 06:52
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by XFlawless - 23.08.2011, 11:15
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Lorenc_ - 23.08.2011, 11:19
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by AndreT - 24.08.2011, 15:48
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by vIBIENNYx - 24.08.2011, 20:18
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Lorenc_ - 25.08.2011, 06:31
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Cowboy - 25.08.2011, 08:22
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Lorenc_ - 26.08.2011, 17:26
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by HotPlayer - 26.08.2011, 17:44
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by JaTochNietDan - 28.08.2011, 01:11
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Lorenc_ - 28.08.2011, 01:46
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Mr.Fames - 07.11.2011, 19:01
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Lorenc_ - 30.11.2011, 09:06
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Mr.Fames - 02.12.2011, 11:58
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by TRIPLE-xXx-GAMEING - 02.03.2012, 14:29
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Edvin - 04.03.2012, 13:34
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Konstantinos - 04.03.2012, 13:36
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by nitrochegs - 10.03.2012, 04:18
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by HDFord - 11.03.2012, 15:49
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Lorenc_ - 12.03.2012, 02:27
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by TTJJ - 13.03.2012, 11:32
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Karl[NDZ] - 19.03.2012, 17:47
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Danny1 - 18.04.2012, 15:28
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Danny1 - 20.04.2012, 12:49
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by KaWavan - 20.04.2012, 21:20
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Djumza - 21.04.2012, 22:42
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Jonny5 - 25.04.2012, 21:17
Re : How to make a register system ( Dialogs, SQLite and rBits ) - by yusei - 26.07.2012, 16:35
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by iSaad - 10.09.2012, 07:26
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by jamesmercer1947 - 10.09.2012, 14:46
Respuesta: How to make a register system ( Dialogs, SQLite and rBits ) - by u3games - 19.12.2012, 11:01
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Lorenc_ - 21.12.2012, 21:54
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by denilson_staff - 22.12.2012, 03:09
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by DJTunes - 22.12.2012, 04:16
Respuesta: Re: How to make a register system ( Dialogs, SQLite and rBits ) - by u3games - 23.12.2012, 00:46
Respuesta: How to make a register system ( Dialogs, SQLite and rBits ) - by RiChArD_A - 23.01.2013, 21:47
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Djean - 24.01.2013, 00:05
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by MyNinja - 24.01.2013, 04:07
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Madeline - 28.01.2013, 14:54
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by proSeryoga - 08.02.2013, 09:17
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by proSeryoga - 09.03.2013, 07:32
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Xeiss - 09.03.2013, 10:00
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Bennyy - 09.03.2013, 10:05
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by proSeryoga - 09.03.2013, 11:03
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by proSeryoga - 10.03.2013, 04:23
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by RVRP - 21.04.2013, 18:13
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Ayham - 23.11.2013, 13:30
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Cuhz - 23.11.2013, 14:23
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Nightangle - 29.07.2014, 07:53
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by freeze98 - 12.10.2014, 14:31
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by naveen - 18.04.2015, 12:22
Re: How to make a register system ( Dialogs, SQLite and rBits ) - by Uberanwar - 25.04.2015, 00:26

Forum Jump:


Users browsing this thread: 1 Guest(s)