[GameMode] [MySQL R41-4] Login / Register Base Script

[GameMode] [MySQL R41-4] Login / Register 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 R41-4] Login / Register Base Script (/showthread.php?tid=659037)

Pages: 1 2 3 4

Re: [MySQL R41-4] Login / Register Base Script - Logic_ - 23.09.2018

Quote:

Originally Posted by ZigGamerx

Are you going to Complete it by adding more savings like Admin level And VIP or not?

Learn to script and then learn how to use MySQL. Both of them are two different things.

--

+4 reps though.

Re: [MySQL R41-4] Login / Register Base Script - solstice_ - 23.09.2018

Quote:

Originally Posted by ZigGamerx

Are you going to Complete it by adding more savings like Admin level And VIP or not?

Will see if I get free time, even if I add admin and VIP you'll have to finish them yourself since this is just a login / register system.

Quote:

Originally Posted by Logic_

Learn to script and then learn how to use MySQL. Both of them are two different things.

--

+4 reps though.

Thank you!

Re: [MySQL R41-4] Login / Register Base Script - severance - 27.09.2018

PHP Code:



    mysql_format(Database, query, sizeof(query), "INSERT INTO `users` (`Username`, `Password`, `IP`, `Cash`, `Kills`, `Deaths`) VALUES ('%e', '%e', '%e', 0, 0, 0)", PlayerName[playerid], PlayerInfo[playerid][Password], PlayerIP[playerid]);

    // Insert player's information into the MySQL database so we can load it later.

    mysql_tquery(Database, query, "RegisterPlayer", "i", playerid); // We'll call this as soon as the player successfully registers.

You should use pquery instead of tquery. Good job anyway it's the most updated mysql reg system out there

Re: [MySQL R41-4] Login / Register Base Script - sammp - 27.09.2018

For the love of good look up what an ERD is and use it to establish a far better database design. If you're creating an RDB with one table, you're doing it wrong.

Re: [MySQL R41-4] Login / Register Base Script - solstice_ - 27.09.2018

Quote:

Originally Posted by severance

PHP Code:



    mysql_format(Database, query, sizeof(query), "INSERT INTO `users` (`Username`, `Password`, `IP`, `Cash`, `Kills`, `Deaths`) VALUES ('%e', '%e', '%e', 0, 0, 0)", PlayerName[playerid], PlayerInfo[playerid][Password], PlayerIP[playerid]);

    // Insert player's information into the MySQL database so we can load it later.

    mysql_tquery(Database, query, "RegisterPlayer", "i", playerid); // We'll call this as soon as the player successfully registers.

You should use pquery instead of tquery. Good job anyway it's the most updated mysql reg system out there

Updated, thanks.

Re: [MySQL R41-4] Login / Register Base Script - v1k1nG - 27.09.2018

Good job.
Shame for the passwords though.

Re: [MySQL R41-4] Login / Register Base Script - solstice_ - 27.09.2018

Quote:

Originally Posted by v1k1nG

Good job.
Shame for the passwords though.

Why lol?

Re: [MySQL R41-4] Login / Register Base Script - Mobtiesgangsa - 27.09.2018

pquery - processed query
tquery - threaded query

i assume ?

or its sencless?

Re: [MySQL R41-4] Login / Register Base Script - NaS - 27.09.2018

Quote:

Originally Posted by Mobtiesgangsa

pquery - processed query
tquery - threaded query

i assume ?

or its sencless?

Both are threaded queries.

tquery puts the query into a queue (all queries you put in this queue will be executed in order, in one thread - very important to know actually).
pquery creates a seperate thread for each query, so they will be executed simultanously. Whichever query is faster will return the result first. Meaning they will not be ordered.

Re: [MySQL R41-4] Login / Register Base Script - ZigGamerx - 28.09.2018

You didnt created "Create Table if not exists" code?

Re: [MySQL R41-4] Login / Register Base Script - solstice_ - 28.09.2018

Quote:

Originally Posted by ZigGamerx

You didnt created "Create Table if not exists" code?

No - it's best you do that manually, I've uploaded the SQL file in the git repo.

Re: [MySQL R41-4] Login / Register Base Script - solstice_ - 07.10.2018

Should I update this to BCrypt or let it be as it is?

Re: [MySQL R41-4] Login / Register Base Script - TheToretto - 08.10.2018

let it be as it is

Re: [MySQL R41-4] Login / Register Base Script - NaS - 08.10.2018

Quote:

Originally Posted by willbedie

Should I update this to BCrypt or let it be as it is?

I'd update it with BCrypt, especially since it's not much to do anyway.

Re: [MySQL R41-4] Login / Register Base Script - solstice_ - 08.10.2018

Quote:

Originally Posted by NaS

I'd update it with BCrypt, especially since it's not much to do anyway.

Will update it later or tomorrow.

Re: [MySQL R41-4] Login / Register Base Script - zF3lKy3 - 08.10.2018

Quote:

Originally Posted by willbedie

Will update it later or tomorrow.

The code is good, you could update it and add more thing like admin levels, VIP's, see if the player is logged in and etc, but so the code looks great, congratulations, I'm not fluent in English, sorry!

Re: [MySQL R41-4] Login / Register Base Script - solstice_ - 08.10.2018

Quote:

Originally Posted by zF3lKy3

Thanks and the only thing that's going to get updated is by updating it to BCrypt from Whirlpool, I won't add admin, neither VIP. Neither a check if the player is logged, you may ask why?

Because I don't have a lot of free time, and this is just a login / register base script (as you can see in the title) so I don't want to complicate it much with other useless stuff, thanks once again.

Re: [MySQL R41-4] Login / Register Base Script - user5487 - 11.10.2018

every thing work fine and connect to sql but
for me it doesn't register anything

also when i input 1 character in register dialog it doesn't return and show register dialog again

Re: [MySQL R41-4] Login / Register Base Script - solstice_ - 11.10.2018

Quote:

Originally Posted by user5487

every thing work fine and connect to sql but
for me it doesn't register anything

also when i input 1 character in register dialog it doesn't return and show register dialog again

Show mysql_log

Re: [MySQL R41-4] Login / Register Base Script - KinderClans - 11.10.2018

From .sql dump file:

Quote:

-- PHP Version: 5.6.31

I don't know if you're using a VPS, but if you do, i suggest you to update your PHP version.

Quote:

-- Versione PHP: 7.2.9

On My VPS currently.

Just an advice.