[GameMode] [MySQL/SQLite] Advance Login & Register System (base script)

[GameMode] [MySQL/SQLite] Advance Login & Register System (base script) - 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] [MySQL/SQLite] Advance Login & Register System (base script) (/showthread.php?tid=625195)

Pages: 1 2 3 4 5

Re: [MySQL/SQLite] Advance Login & Register System (base script) - Neom - 27.06.2018

hmm its good am using it for my server

Re: [MySQL/SQLite] Advance Login & Register System (base script) - homelessdrop - 24.12.2018

which mysql version is it?

Re: [MySQL/SQLite] Advance Login & Register System (base script) - feheristi97 - 24.12.2018

Quote:

Originally Posted by wallee

1) I registered my account and when i disconnected and reconnected it didn't accept my password
2) then i try to register again but this time it wouldn't save my account at all (mysql didn't create new row) and this is the error i found: Duplicate entry '0' for key 'PRIMARY'

I'm using mysql R41-4 ... help pls

This gamamode is bugged do not use it. I agree with this post. ^

Re: [MySQL/SQLite] Advance Login & Register System (base script) - DyduShxD - 16.01.2019

Does anyone know how to solve the problem whit SHA ? I use 41-4 aswell. it s just letting me to create a new account but after i restart the server password and security pass aswel they just stop working, thank you.

Re: [MySQL/SQLite] Advance Login & Register System (base script) - DandYxD - 17.01.2019

what different MySQL and SQLite

Re: [MySQL/SQLite] Advance Login & Register System (base script) - OuDayas - 22.01.2019

It's possible to add another string only for numbers in the "forgot password" dialog, like another step where the user can insert a secret number after insert the answer for the "security question"?

Quote:

Originally Posted by Gammix

Advance Login & Register System
MySQL and SQLite - v2.0 - last updated 5th Jan, 2017

Dialogs based login and register. There is a limit on login attempts (default is 3) you can edit the limit in script:

PHP код:

#define MAX_LOGIN_ATTEMPTS 3 #define MAX_ACCOUNT_LOCKTIME 2 // in minutes - this is the time interval for locking the account when a user fails to login in Max Attempts given

http://i.imgur.com/lD8XDLm.jpg
SECURE_PASSWORD_ONLY
This forces the user to have atleast 1 Lowercase, 1 Highercase and 1 Number in their password while registration or changing password.
Modify in script:

PHP код:

//#define SECURE_PASSWORD_ONLY // this forces the user to have atleast 1 Lowercase, 1 Highercase and 1 Number in their password
Per player based password salts, every player has their own SALT for SHA256 salt.
When you are unsure about your login credentials, there is a button "OPTIONS" in login or register dialog:
- Forgot password: gives a dialog where you can answer your security question and reset password:
  
  When you answer it right (note: you are given the same number of max tries as given in login)
- Forgot username: gives a dialog where you can get all the accounts that are registered on your IP Address (it cover IP range)!
This is what happens when you fail all login attempts:
The accounts gets temp locked for the given time "MAX_ACCOUNT_LOCKTIME" only for your IP. in case the original user isn't being abused by fake attempts from other IP.s.

You can also set the maximum login attempts via setting: (note this value also sets maximum attempts to reset password through answering security question)

PHP код:

#define MAX_LOGIN_ATTEMPTS 3

Account getting locked (when you fail all 3 attempts):

When you try to come back right after:
/changepass
Change your account's password. (salt remains the same)
/changeques
Change your account's security question and answer. (salt remains the same)

You can also add your own questions list by editing this constant array:

PHP код:

new const SECURITY_QUESTIONS[][MAX_SECURITY_QUESTION_SIZE] = { "What was your childhood nickname?", ... };
/stats

Download
SQLite Version - https://github.com/Agneese-Saini/SA-...ase/sqlite.pwn
MySQL Version - https://github.com/Agneese-Saini/SA-...base/mysql.pwn

Libraries required:
zcmd.inc - https://sampforum.blast.hk/showthread.php?tid=576114
sscanf2.inc - https://sampforum.blast.hk/showthread.php?tid=602923
easydialog.inc - https://sampforum.blast.hk/showthread.php?tid=602886
kickban.inc - https://github.com/Agneese-Saini/SA-...kickbanfix.inc

Re: [MySQL/SQLite] Advance Login & Register System (base script) - Robertsamp - 29.01.2019

Nice work!

Re: [MySQL/SQLite] Advance Login & Register System (base script) - Kincaid - 04.02.2019

Thanks for releasing such a gamemode.
I have faced the following errors:
1. We can't register more than 1 account
2. Security answer is not accepted

Re: [MySQL/SQLite] Advance Login & Register System (base script) - m3shys - 26.02.2019

Quote:

Originally Posted by Kincaid

Thanks for releasing such a gamemode.
I have faced the following errors:
1. We can't register more than 1 account
2. Security answer is not accepted

its only advance login & register system, thats all. this means it's really only a starting point, you have to be a scripter to use it regardless. 1) master account system you have to implement it yourself. 2) not sure what you mean.

secondly I would recommend just using bcrypt as its more secure and easier, its designed to be slow rather than SHA designed to be fast. you want it slow in case database gets hacked.