Register - Printable Version

Register - 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: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Register (/showthread.php?tid=629181)

PHP код:



//OnAccount check

ShowPlayerDialog(playerid, dREGISTER, DIALOG_STYLE_INPUT, "Register", "Welcome To ZoneX your Username is not founded in our Database Please Register.", "Register", "Quit");


On Dialog Response


        case dREGISTER: //register dialog

        {

            if(!response) return Kick(playerid); //if they clicked Quit, we will kick them

            if(strlen(inputtext) < 6) return ShowPlayerDialog(playerid, dREGISTER, DIALOG_STYLE_INPUT, "Register", "In order to play, you need to register.\nYour password must be at least 6 characters long!", "Register", "Quit");

            //strlen checks a lenght of a string. so if player types their password that is lower than 6, we tell them; Your password must be at least 6 characters long!

                WP_Hash(pData[playerid][Password], 129, inputtext); //hashing inputtext

                new Msg[130], str[800];

                pData[playerid][ID] = cache_insert_id(); //loads the ID of the player in the variable once they registered.

                printf("New account registered. ID: %d", pData[playerid][ID]); //just for debugging.

                pData[playerid][Money] = 50000;

                GivePlayerMoney(playerid, 50000);

                format(str, sizeof(str), "INSERT INTO `players`(`ID`, `Username`, `Password`, `IP`, `Admin`, `VIP`, `Kills`, `Cookies`, `Cakes`, `Icecream`, `Deaths`, `Score`, `Money`, `Hours`, `Minutes`) VALUES ('%d','%s','%s','%s',0,0,0,0,0,0,0,0,0,0,0)", pData[playerid][ID], GetName(playerid), pData[playerid][Password], IP[playerid]);

                mysql_query(mysql, str);

                format(joinMsg, sizeof(joinMsg), "02[%d] 03*** 11,12* Player %s has registered new at ZoneX (Zx)",playerid, GetName(playerid));

                IRC_GroupSay(groupID, IRC_CHANNEL, joinMsg);

                new rows, Cache:getCache;

                getCache = mysql_query(mysql, "SELECT * FROM `players`");

                cache_get_row_count(rows);

                format(Msg, sizeof(Msg), "{00FF50}%s has registered at ZX {FF0000}[Total Registered Players: %i]",GetName(playerid), rows);

             SendClientMessageToAll(playerid,Msg);

             pData[playerid][Admin] = 1;

             pData[playerid][RaceWon] = 0;

              cache_delete(getCache);

            //let's execute the query

        }

When a player register it doesn't insert name, data in players database

Re: Register - Vince - 21.02.2017

Obviously you can't get the insert_id before the actual insert takes place. That's the point. It is the insert statement that generates the ID. This function merely returns that value. If the ID column is set to auto_increment then you can leave it out of the query. Alternatively you can specify the value as null, default or 0.

Also NEVER use row_count if the only thing you're interested in is a count of something. That is terribly inefficient. Use the aggregate COUNT() function. This always returns exactly one row and one column with the value being the count.

Check the logs as well.

Re: Register - Loinal - 22.02.2017

Quote:

Originally Posted by Vince

Obviously you can't get the insert_id before the actual insert takes place. That's the point. It is the insert statement that generates the ID. This function merely returns that value. If the ID column is set to auto_increment then you can leave it out of the query. Alternatively you can specify the value as null, default or 0.

Also NEVER use row_count if the only thing you're interested in is a count of something. That is terribly inefficient. Use the aggregate COUNT() function. This always returns exactly one row and one column with the value being the count.

Check the logs as well.

I don't understand can you solve and send me solve?

Re: Register - Loinal - 22.02.2017

help?

Re: Register - Loinal - 24.02.2017

bumb

Re: Register - Loinal - 24.02.2017

That code every one register it give him same id is -1

Respuesta: Register - Eloy - 25.02.2017

Show your log mysql please

Re: Register - JaKe Elite - 25.02.2017

You do not deserve a help if you don't even know a single bit of MySQL, go and start off with SQLite.

Re: Register - Loinal - 25.02.2017

Quote:

Originally Posted by JaKe Elite

You do not deserve a help if you don't even know a single bit of MySQL, go and start off with SQLite.

I know mysql and iam learning + If you don't have some thing good to say so shut up + Fixed

Re: Register - Vince - 25.02.2017

Quote:

Originally Posted by Vince

you can't get the insert_id before the actual insert takes place

Take specific notice of the words "can't" and "before". What would be the logical thing to do then? Invert the statement: you can get the insert_id after the actual insert takes place.

I'm severely allergic to bumps that provide no additional information because then it appears to me that the person that asked the question is merely waiting for a response without having tried anything else in the meantime.