SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Gamemode Scripts

Reply
 
Thread Tools Display Modes
Old 24/12/2018, 12:27 AM   #91
homelessdrop
Little Clucker
 
homelessdrop's Avatar
 
Join Date: Jan 2016
Posts: 40
Reputation: 17
Default Re: [MySQL/SQLite] Advance Login & Register System (base script)

which mysql version is it?
homelessdrop is offline   Reply With Quote
Old 24/12/2018, 10:01 PM   #92
feheristi97
Big Clucker
 
Join Date: Jun 2014
Location: Canada
Posts: 103
Reputation: 4
Default Re: [MySQL/SQLite] Advance Login & Register System (base script)

Quote:
Originally Posted by wallee View Post
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. ^
feheristi97 is offline   Reply With Quote
Old 16/01/2019, 06:15 AM   #93
DyduShxD
Gangsta
 
DyduShxD's Avatar
 
Join Date: Jan 2013
Location: United Kingdom
Posts: 613
Reputation: 6
Default Re: [MySQL/SQLite] Advance Login & Register System (base script)

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.
DyduShxD is offline   Reply With Quote
Old 17/01/2019, 06:18 AM   #94
DandYxD
Little Clucker
 
Join Date: Dec 2018
Posts: 1
Reputation: 0
Default Re: [MySQL/SQLite] Advance Login & Register System (base script)

what different MySQL and SQLite
DandYxD is offline   Reply With Quote
Old 22/01/2019, 10:52 AM   #95
OuDayas
Big Clucker
 
Join Date: Jan 2019
Posts: 81
Reputation: 0
Default Re: [MySQL/SQLite] Advance Login & Register System (base script)

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 View Post
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 Code:
    #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 Code:
    //#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 Code:
    #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 Code:
    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 - http://forum.sa-mp.com/showthread.php?t=576114
sscanf2.inc - http://forum.sa-mp.com/showthread.php?t=602923
easydialog.inc - http://forum.sa-mp.com/showthread.php?t=602886
kickban.inc - https://github.com/Agneese-Saini/SA-...kickbanfix.inc
OuDayas is offline   Reply With Quote
Old 29/01/2019, 07:23 PM   #96
Robertsamp
Little Clucker
 
Robertsamp's Avatar
 
Join Date: Feb 2017
Location: Pitesti, Romania
Posts: 7
Reputation: 0
Default Re: [MySQL/SQLite] Advance Login & Register System (base script)

Nice work!
Robertsamp is offline   Reply With Quote
Old 04/02/2019, 06:20 PM   #97
Kincaid
Little Clucker
 
Join Date: Oct 2018
Posts: 22
Reputation: 0
Default Re: [MySQL/SQLite] Advance Login & Register System (base script)

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
Kincaid is offline   Reply With Quote
Old 26/02/2019, 10:10 PM   #98
m3shys
Big Clucker
 
m3shys's Avatar
 
Join Date: Jul 2014
Posts: 77
Reputation: 23
Default Re: [MySQL/SQLite] Advance Login & Register System (base script)

Quote:
Originally Posted by Kincaid View Post
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.
m3shys is offline   Reply With Quote
Old 14/07/2019, 11:25 AM   #99
ShadowMortar
Big Clucker
 
Join Date: Jul 2016
Location: Croatia
Posts: 93
Reputation: 10
Default Re: [MySQL/SQLite] Advance Login & Register System (base script)

Quote:
Originally Posted by m3shys View Post
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.
I really love you dude, I was searching for like one hour why bcrypt is slow as hell, you answered my question.
THANKS!
ShadowMortar is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to disable Register/Login system in a script StrikerZ Scripting Help 9 03/08/2016 02:57 PM
I am getting a mysql register and login script and im getting a error kingcrome Scripting Help 1 28/10/2013 10:27 PM


All times are GMT. The time now is 11:33 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.