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

hmm its good am using it for my server
Reply
#82

which mysql version is it?
Reply
#83

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. ^
Reply
#84

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.
Reply
#85

what different MySQL and SQLite
Reply
#86

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
Reply
#87

Nice work!
Reply
#88

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
Reply
#89

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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)