[Logic_]

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.

[solstice_]

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!

[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

[sammp]

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.

[solstice_]

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.

[v1k1nG]

Good job.
Shame for the passwords though.

[solstice_]

Quote:

Originally Posted by v1k1nG Good job. Shame for the passwords though.

Why lol?

[Mobtiesgangsa]

pquery - processed query
tquery - threaded query

i assume ?

or its sencless?

[NaS]

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.

[ZigGamerx]

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

[solstice_]

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.

[solstice_]

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

[TheToretto]

let it be as it is

[NaS]

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.

[solstice_]

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.

[zF3lKy3]

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!

[solstice_]

Quote:

Originally Posted by zF3lKy3 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!

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.

[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

[solstice_]

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

[KinderClans]

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.