[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)

---

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

Update v2.0:
- Now failed login attempts will block the user's IP who was attempting to login not the whole account. So for example if you are trying to login into your friend's account and you fail, your friend would still be able to login (assume they both are not on wifi) but the account will be temp locked for your IP.

---

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

Security questions should probably be stored in the database as well and referential integrity enforced. If the array is changed the security questions won't match up anymore (unless extreme care is taken to only add new questions to the end of the list).

For the IpToLong function; since you are already using sscanf you can use that to very simply explode the IP parts.

---

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

I love your scripting! Expecting MYSQL version soon

---

Re: [MySQL/SQLite] Advance Login & Register System (base script) - Variable™ - 06.01.2017

This is your second reply to the thread .. You could have edited the first one already.

OT: Not bad.

---

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

Useful

---

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

Update v2.1:
- Security questions are saved as strings instead of saving the array index to retrieve security question later on. This will give scripter advantage of changing the array of security question anytime without effecting user data.
- IpToLong removed upon sscanf. (thanks to Vince)

---

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

Good job man

---

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

when me open database there is nothing help

---

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

Awesome. You should make a gm.

---

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

Delete the database file and start samp-server.exe.

See if the database and the tables are created or not.

---

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

Will the mysql version be released soon?

---

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

Indeed. I was waiting if someone would report a bug in SQLite version so that i could fix that first and then work on MySQL when everything on SQLite side is stable. Cause all we have to do is change function names!

---

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

Nice but there is too many questions i think 3 is good

---

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

Alright because I really wait for the release, I can't find a good example for a mysql registration and I want to learn how mysql work but all I find are old tutorials :/

---

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

Can't wait for the MySQL release

---

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

Very nice

---

Respuesta: [MySQL/SQLite] Advance Login & Register System (base script) - TheKeviXz - 07.02.2017

excellent work... +Rep

---

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

Nice

---

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

UPDATE kickban.inc download link

---

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

I am not aware of this issue but i once found that there is a bug in salting due to which you could bypass password by typing few first letters. I will update the password and salt system soon.

Done!

---