[anou1]

Hi,

Pastbin: http://pastebin.com/Pbd2n7vf


Question:
1)
How can I do to spawn a player, once he entered his password ?
But only when he login, not when he register.


2) If a player lost his password or something like this, how can I do to delete the previous and replace it with a new one in mysql table ?



Problem:

When I register for the first time and then I spawn, I'm not at the place I should be, I spawn at 0,0,0 I think.


Maybe a video will help

[ame]http://www.youtube.com/watch?v=ilZRL2yD8lY[/ame]

[offon]

https://sampwiki.blast.hk/wiki/SetSpawnInfo
https://sampwiki.blast.hk/wiki/SpawnPlayer

[anou1]

Thank you problem solved for 1) question

I forgot to "SpawnPlayer(playerid);

[Nero_3D]

For the second you just need a security question or something like that to reset the password if he entered it more than x times than just update the password in the mysql table

[anou1]

Thank you,

for my problem anyone got an idea ?

[anou1]

UP please

[Lidor124]

For your problem i think https://sampwiki.blast.hk/wiki/SetSpawnInfo also will help

[anou1]

I putted in below

Код:

case 2: //register dialog
        {
            if(!response) return Kick(playerid); //if they clicked Quit, we will kick them
            if(strlen(inputtext) < 6) return ShowPlayerDialog(playerid, 2, DIALOG_STYLE_INPUT, "S'enregistrer", "Ton mot de passe doit faire plus de 6 caractиres !", "S'enregistrer", "Quitter");
            //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(pInfo[playerid][Password], 129, inputtext); //hashing inputtext
            mysql_format(mysql, query, sizeof(query), "INSERT INTO `joueurs` (`Username`, `Password`, `IP`, `Admin`, `VIP`, `Argent`, `posX` ,`posY`, `posZ`, `Interieur`, `World`, `Skin`) VALUES ('%e', '%s', '%s', 0, 0, 1000, 1527.5634, -1738.9218, 13.5469, 0, 0, 26)", Name[playerid], pInfo[playerid][Password], IP[playerid]);
            //Now let's create a new row and insert player's information in it
            mysql_tquery(mysql, query, "", "");
            //let's execute the query	
			SetSpawnInfo( playerid, 0, pInfo[playerid][Skin], pInfo[playerid][posX],pInfo[playerid][posY],pInfo[playerid][posZ], 0.0, 0, 0, 0, 0, 0, 0 );
        }

But it changed nothing, they player still spawn at 0,0,0 when he register and enter in the game for the first time.

Other ideas ?




My mysql log:

Код:

 mysql_format - connection: 1, len: 512, format: "INSERT INTO `joueurs` (`Username`, `Password`, `IP`, `Admin`, `VIP`, `Argent`, `posX` ,`posY`, `posZ`, `Interieur`, `World`, `Sk..."
[13:27:57] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `joueurs` (`Username`, `Password`, `IP`, `Admin`, `V", callback: "(null)", format: "(null)"

[Lidor124]

SetSpawnInfo( playerid, 0, pInfo[playerid][Skin], pInfo[playerid][posX],pInfo[playerid][posY],pInfo[playerid][posZ]

the posX posY posZ did you make it save on the ini file of the user?

[anou1]

It saves in mysql database.



PS: When I register, when I enter the password, and don't click on spawn button.
If I go on my mysql database, I can see that the posX,Y and Z are good.




EDIT: Problem solved, thank you