1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
INSERT INTO mysql error
OMonger
Big Clucker
***
Posts: 107
Threads: 34
Joined: Apr 2014
Reputation: 0
#1

10.01.2016, 13:27
[spoiler]
Код:
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    switch( dialogid )
    {
        case DIALOG_REGISTER:
        {
            if (!response) return Kick(playerid);
            if(response)
            {
                if(strlen(inputtext) < 4 || strlen(inputtext) > 50)
                return SendClientMessage(playerid, WARNRED, "Please choose a password between FOUR (4) and FIFTY (50) characters.");
                if(!strlen(inputtext)) return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""COLOR_WHITE"Registering...",""COLOR_RED"You have entered an invalid password.\n"COLOR_WHITE"Type your password below to register a new account.","Register","Quit");
				new INI:File = INI_Open(UserPath(playerid));
				PlayerInfo[playerid][pLogged] = 1;
                ShowPlayerDialog(playerid, DIALOG_SUCCESS_1, DIALOG_STYLE_MSGBOX,""COLOR_WHITE"Success!",""COLOR_GREEN"You are now registered!","Ok","");
                INI_SetTag(File,"data");
 				INI_WriteInt(File,"UserID",0);
                INI_WriteInt(File,"Password",udb_hash(inputtext));
                INI_WriteInt(File,"Cash",0);
    			INI_WriteInt(File,"Admin",0);
       			INI_WriteInt(File,"Moderator",0);
       			INI_WriteInt(File,"Helper",0);//
    			INI_WriteInt(File,"Gender",0);
    			INI_WriteInt(File,"Health",0);
    			INI_WriteInt(File,"Age",0);
    			INI_WriteInt(File,"Muted",0);
    			INI_WriteInt(File,"Skin",1);
    			INI_WriteInt(File,"Level",0);
    			INI_WriteInt(File,"Faction",0);
    			INI_WriteInt(File,"Rank",0);
    			INI_WriteInt(File,"AwayStatus",0);
    			INI_WriteInt(File,"SubmittedHelp",0);
   				INI_WriteInt(File,"Country",strlen(inputtext));
       			INI_WriteInt(File,"Test",0);
    			INI_WriteInt(File,"PhoneN",0);
    			INI_WriteInt(File,"Vehicle",0);
       			INI_WriteInt(File,"Logged",0);
       			INI_WriteInt(File,"InHosp",0);
       			PlayerInfo[playerid][pPass] = udb_hash(inputtext);
       			new query[1500];
       			{
					format(query,sizeof(query),"INSERT INTO `Accounts` (`Username`,`pPass`) VALUES ('%s','%s')",GetName(playerid),PlayerInfo[playerid][pPass]);
  				  	mysql_function_query(g_connectionHandle, query, false, "DefaultCallback", "");
				}
    			INI_Close(File);
				printf("%s (%d)'s has registered!", RPName(playerid), playerid);
                ShowPlayerDialog(playerid, DIALOG_AGE, DIALOG_STYLE_INPUT, ""COLOR_WHITE"Age registration",""""COLOR_WHITE"Please choose an age between 18 and 75.","Select age","");
            }
        }
	case DIALOG_AGE:
	{
 			if (!response) return Kick(playerid);
            if(response)
            {
		  		new string[128];
				if(PlayerInfo[playerid][pAge] >= 1)
				{
					PlayerInfo[playerid][pAge] = strval(inputtext);
					format(string, sizeof(string), "So you are %d years old.", PlayerInfo[playerid][pAge]);
					SendClientMessage(playerid, WHITE, string);
					new query[1500];
					{
						format(query, sizeof(query), "UPDATE `Accounts` (`Age`) VALUES (`%s`) WHERE `Username` = '%s'",PlayerInfo[playerid][pAge], GetName(playerid));
	                	mysql_function_query(g_connectionHandle, query, false, "DefaultCallback", "");
					}
				}
				ShowPlayerDialog(playerid, 7002, DIALOG_STYLE_LIST, "Registration -> Gender", "Male\nFemale", "Select", "Quit");
			}
	}
    case 7002:
            {
            	switch(listitem)
		        {
		            case 0:
		            {
		                SendClientMessage(playerid, WHITE, "So you are a Male.");
		                ShowPlayerDialog(playerid, 7003, DIALOG_STYLE_INPUT, "Registration -> Country", "{FFFFFF}Enter the country your Characters is comming from.", "Enter", "");
                  		new rand = random(sizeof(RandomMaleSkins));
						PlayerInfo[playerid][pSkin] = RandomMaleSkins[rand];
						SetPlayerSkin(playerid, PlayerInfo[playerid][pSkin]);
						new query[1500];
						{
							PlayerInfo[playerid][pGender] = 1;
							format(query, sizeof(query), "UPDATE `Accounts` (`Gender`) VALUES(`%s`) WHERE `Username` = '%s'",PlayerInfo[playerid][pGender], GetName(playerid));
	                		mysql_function_query(g_connectionHandle, query, false, "DefaultCallback", "");
						}
					}
		            case 1:
		            {
                        new rand = random(sizeof(RandomFemaleSkins));
						PlayerInfo[playerid][pSkin] = RandomFemaleSkins[rand][0];
						SetPlayerSkin(playerid, PlayerInfo[playerid][pSkin]);
                        SendClientMessage(playerid, WHITE, "So you are a Female.");
                        PlayerInfo[playerid][pGender] = 2;
                        ShowPlayerDialog(playerid, 7003, DIALOG_STYLE_INPUT, "Registration -> Country", "{FFFFFF}Enter the country your Characters is comming from.", "Enter", "");
						new query[1500];
						{
							format(query, sizeof(query), "UPDATE `Accounts` (`Gender`) VALUES(`%s`) WHERE `Username` = '%s'",PlayerInfo[playerid][pGender], GetName(playerid));
	                		mysql_function_query(g_connectionHandle, query, false, "DefaultCallback", "");
						}
		            }

          		}
            }
	case 7003:
 		{
   			new string[128];
			format(PlayerInfo[playerid][pCountry], 255, inputtext);
			format(string, sizeof(string), "So you are comming from %s.", inputtext);
			PlayerInfo[playerid][pCountry] = strlen(inputtext);
			SendClientMessage(playerid, WHITE, string);
			if(PlayerInfo[playerid][pGender] >= 1)
			{
   				SetSpawnInfo(playerid, 0, PlayerInfo[playerid][pSkin], 1503.277343, -1728.304809,  27.541816, 0, 0, 0, 0, 0, 0, 0);
       			SpawnPlayer(playerid);
				PlayerInfo[playerid][pLogged] = 1;
				SetTimerEx("CameraTutorial1", 10, false, "d", playerid);
		 		TogglePlayerControllable(playerid, false);
			}
   			new query[1500];
        	{
      				format(query, sizeof(query), "UPDATE `Accounts` ('Country') VALUES('%d') WHERE `Username` = '%s'",PlayerInfo[playerid][pCountry], GetName(playerid));
	                mysql_function_query(g_connectionHandle, query, false, "DefaultCallback", "");
         	}
		}
[/spoiler]

Код:
new query[2000];

    format(query, sizeof(query),"UPDATE `Accounts` SET `pAdmin` = %d, `pModerator` = %d, `pHelper` = %d, `pSkin` = %d, `pHealth` = %f,`pFaction` = %d,`pRank` = %d,`pRankName` = %s,`pJob` = %d, `pLevel` = %d, `pCountry` = %s, `SubmittedHelp` = %d, `HelpMessage` = %s, `pMuted` = %d, `pTest` = %d, `pPhoneN` = %d, `XPos` = %d, `ZPos` = %d, `YPos` = %d, `pCash` = %d, `pBonus` = %d, `AwayStatus` = %d, `pInHosp` = %d, `RentingVehicle` = %d WHERE `Username` = '%s'",
   		PlayerInfo[playerid][pAdmin],
		PlayerInfo[playerid][pModerator],
		PlayerInfo[playerid][pHelper],
		GetPlayerSkin(playerid),
		PlayerInfo[playerid][pFaction],
		PlayerInfo[playerid][pRank],
		PlayerInfo[playerid][pRankName],
		PlayerInfo[playerid][pJob],
		PlayerInfo[playerid][pLevel],
		PlayerInfo[playerid][pCountry],
		PlayerInfo[playerid][SubmittedHelp],
		PlayerInfo[playerid][HelpMessage],
		PlayerInfo[playerid][pMuted],
		PlayerInfo[playerid][pTest] = 1,
		PlayerInfo[playerid][pPhoneN],
		PlayerInfo[playerid][XPos],
		PlayerInfo[playerid][YPos],
		PlayerInfo[playerid][ZPos],
		PlayerInfo[playerid][pCash],
		PlayerInfo[playerid][pBonus],
		PlayerInfo[playerid][AwayStatus] = 1,
		PlayerInfo[playerid][pInHosp] = 0,
		PlayerInfo[playerid][RentingVehicle] = 0,
		GetName(playerid));
	mysql_function_query(g_connectionHandle, query, false, "DefaultCallback", "");
This is the entire code fr my registration dialogs. I am tryingt o make it save when a player registers, but it wont. Please ignore the INI stuff above it, I leave it there for icnase I want to return. These are the errors in the MYSQL log:

Код:
[14:14:43] Passing query UPDATE `Accounts` SET `pAdmin` = 0, `pModerator` = 0, `pHelper` = 0, `pSkin` = 1, `pHealth` = 0.000000,`pFaction` = 0,`pRank` = 0,`pRankName` = ,`pJob` = 0, `pLevel` = 56, `pCountry` = , `SubmittedHelp` = 0, `HelpMessage` = , `pMuted` = 1, `pTest` = 0, `pPhoneN` = -989728301, `XPos` = 1161174064, `ZPos` = 1168009377, `YPos` = 0, `pCash` = 0, `pBonus` = 1, `AwayStatus` = 0, `pInHosp` = 0, `RentingVehicle` = 116 WHERE `Username` = '' | 
[14:14:43] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[14:14:43] OnQueryError() - Called.
[14:15:44] >> mysql_query_callback( Connection handle: 1 )
[14:15:44] Passing query INSERT INTO `Accounts` (`Username`,`pPass`) VALUES ('testing_test','‹') | 
[14:15:44] ProcessQueryThread(DefaultCallback) - Query was successful. (INSERT INTO `Accounts` (`Username`,`pPass`) VALUES ('testing_test','‹'))
[14:15:44] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[14:15:44] DefaultCallback() - Threaded function called.
[14:15:46] >> mysql_query_callback( Connection handle: 1 )
[14:15:46] Passing query INSERT INTO `Accounts` (`Gender`) VALUES(``) WHERE `Username` = 'testing_test' | 
[14:15:46] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[14:15:46] OnQueryError() - Called.
[14:15:48] >> mysql_query_callback( Connection handle: 1 )
[14:15:48] Passing query INSERT INTO `Accounts` ('Country') VALUES('iami') WHERE `Username` = 'testing_test' | 
[14:15:48] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[14:15:48] OnQueryError() - Called.
[14:19:09] >> mysql_query_callback( Connection handle: 1 )
[14:19:09] Passing query UPDATE `Accounts` SET `pAdmin` = 0, `pModerator` = 0, `pHelper` = 0, `pSkin` = 21, `pHealth` = 0.000000,`pFaction` = 0,`pRank` = 0,`pRankName` = ,`pJob` = 0, `pLevel` = 5, `pCountry` = , `SubmittedHelp` = 0, `HelpMessage` = , `pMuted` = 1, `pTest` = 0, `pPhoneN` = 1147324878, `XPos` = -992466733, `ZPos` = 1085242186, `YPos` = 0, `pCash` = 0, `pBonus` = 1, `AwayStatus` = 0, `pInHosp` = 0, `RentingVehicle` = 116 WHERE `Username` = '' | 
[14:19:09] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[14:19:09] OnQueryError() - Called.

Please can someone help, Iwill rep+ you.
Find
Reply
OMonger
Big Clucker
***
Posts: 107
Threads: 34
Joined: Apr 2014
Reputation: 0
#2

10.01.2016, 15:25
can someone help?
Find
Reply
OwlIT
Little Clucker
**
Posts: 27
Threads: 7
Joined: Jul 2015
Reputation: 0
#3

10.01.2016, 15:39
The problem is in the function 'GetName(playerid)' post this function here.
Find
Reply
OMonger
Big Clucker
***
Posts: 107
Threads: 34
Joined: Apr 2014
Reputation: 0
#4

10.01.2016, 16:18
Код:
stock GetName(playerid)
{
    new PName[MAX_PLAYER_NAME];

    if(IsPlayerConnected(playerid))
    {
		GetPlayerName(playerid, PName, sizeof(PName));
	}
	else
	{
	    PName = "Disconnected/Nothing";
	}

	return PName;
}
This is the stock for GetName
Find
Reply
OMonger
Big Clucker
***
Posts: 107
Threads: 34
Joined: Apr 2014
Reputation: 0
#5

10.01.2016, 17:53
Quote:
Originally Posted by OMonger
Посмотреть сообщение
Код:
stock GetName(playerid)
{
    new PName[MAX_PLAYER_NAME];

    if(IsPlayerConnected(playerid))
    {
		GetPlayerName(playerid, PName, sizeof(PName));
	}
	else
	{
	    PName = "Disconnected/Nothing";
	}

	return PName;
}
This is the stock for GetName
(bump)

Does anyone know the fix of this problem?
Find
Reply
PrO.GameR
Gangsta
****
Posts: 694
Threads: 2
Joined: Oct 2012
Reputation: 0
#6

10.01.2016, 18:40
Cmon ppl, how is the problem in GetName ?!!! Dem random posts ..

PHP код:
[14:15:44] ProcessQueryThread(DefaultCallback) - Query was successful. (INSERT INTO `Accounts` (`Username`,`pPass`) VALUES ('testing_test','‹'))
[14:15:46] Passing query [U]INSERT[/U] INTO `Accounts` (`Gender`) VALUES(``) WHERE `Username` = 'testing_test' | 
[14:15:46] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[14:15:46] OnQueryError() - Called. 
First line tells us inserting was successful, therefore your insert query only needs 2 values to be a successful insert, therefore other columns all have defaults or just doesn't exist.
Here's the part, after you make a player's mysql row, you shouldn't use insert, but you should use UPDATE to update his gender and country (if those columns exist in your database, if not create them first and give them a default value).
PHP код:
`pRankName` = %s 
Here's another problem, whenever you are passing a string to MYSQL, you should use ' ' (and also better to use %e with mysql_format to escape the strings)
Correct code would be
PHP код:
`pRankName` = '%s' 
PHP код:
`XPos` = %d, `ZPos` = %d, `YPos` = %d 
%d is for integers, %f is for floats

PHP код:
WHERE `Username` = '' 
Oh and this suggests you missed some of variables, making username missing.
PHP код:
PlayerInfo[playerid][RentingVehicle] = 0 
^^And I'm not sure if this is gonna work


These are so far only problems I could see, fix these and update the thread with your updated code and we'll see if any more is wrong with it.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help