SA-MP Forums Archive
MySQL & y_inline & y_dialog - 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: MySQL & y_inline & y_dialog (/showthread.php?tid=604268)


MySQL & y_inline & y_dialog - d3ll - 02.04.2016

I have this function, when I try to register it doesn't insert.... in to the database.

PHP код:
stock Construct_PlayerConnected(playerid) {
    inline OnCheckPlayerAccount() {
        new rows, fields, content[129];
        cache_get_data(rows, fields, SQLConnection);
        if(rows) {
            new loadedPassword[129];
            cache_get_field_content(0, "ID", content, SQLConnection);
            PlayerInfo[playerid][SQLID] = strval(content);
            cache_get_field_content(0, "Password", loadedPassword, SQLConnection);
            inline LoginResponse(pid, response, listitem, string:inputtext[]) {
                #pragma unused pid, listitem
                switch(response) {
                    case 0: {
                        // SetTimerEx("ToKick", 500, false, "dsd", playerid, "Quit on Login!", ADMIN_ANNOUCE);
                    }
                    default: {
                        new passWordLogged[129];
                        WP_Hash(passWordLogged, 129, inputtext);
                        if(!strcmp(passWordLogged, loadedPassword)) {
                            inline LoadPlayerAccount() {
                                new iGet[256];
                                cache_get_field_content(0, "Money", iGet, SQLConnection); PlayerInfo[playerid][Money] = strval(iGet); ResetPlayerMoney(playerid), GivePlayerMoney(playerid, strval(iGet));
                                cache_get_field_content(0, "Bank", iGet, SQLConnection); PlayerInfo[playerid][Bank] = strval(iGet);
                                cache_get_field_content(0, "Score", iGet, SQLConnection); PlayerInfo[playerid][Score] = strval(iGet); SetPlayerScore(playerid, strval(iGet));
                                cache_get_field_content(0, "Points", iGet, SQLConnection); PlayerInfo[playerid][Points] = strval(iGet);
                                cache_get_field_content(0, "TotalPlayTime", iGet, SQLConnection); PlayerInfo[playerid][TotalPlayTime] = strval(iGet);
                                SetSpawnInfo( playerid, 0, 0, 1958.33, 1343.12, 15.36, 269.15, 26, 36, 28, 150, 0, 0 );
                                SpawnPlayer(playerid);
                                return 1;
                            }
                            new iQuery[128];
                            mysql_format(SQLConnection, iQuery, sizeof(iQuery), "SELECT * FROM `PlayerInfo` WHERE `ID` = %d LIMIT 1", PlayerInfo[playerid][SQLID]);
                            mysql_tquery_inline(SQLConnection, iQuery, using inline LoadPlayerAccount, "");
                        } else {
                            PlayerTemp[playerid][loginAttempts]++;
                            if(PlayerTemp[playerid][loginAttempts] >= 3) {
                                // SetTimerEx("ToKick", 500, false, "dsd", playerid, "Login limit exceeded!", ADMIN_ANNOUCE);
                                return 1;
                            } else {
                                return Construct_PlayerConnected(playerid), 0;
                            }
                        }
                    }
                }
            }
            Dialog_ShowCallback(playerid, using inline LoginResponse, DIALOG_STYLE_PASSWORD, "{3196ef} - "SERVER_GM"{adc7e7}", "  {FFFFFF}Please enter your password to Login", "Login", " ");
        } else {
            inline RegisterResponse(pid, response, listitem, string:inputtext[]) {
                #pragma unused pid, listitem
                switch(response) {
                    case 0: {
                        // SetTimerEx("ToKick", 500, false, "dsd", playerid, "Quit on Register!", ADMIN_ANNOUCE);
                    }
                    default: {
                        if(strlen(inputtext) > 40 || strlen(inputtext) < 5 || !strlen(inputtext)) {
                            //SendClientWarning(playerid, "Invalid Password, please try again!");
                            return Construct_PlayerConnected(playerid), 1;
                        } else {
                            new iQuery[256], passwordHashed[129];
                            WP_Hash(passwordHashed, 129, inputtext);
                            mysql_format(SQLConnection, iQuery, sizeof(iQuery), "INSERT INTO `PlayerInfo` (`PlayerName`, `Password`) VALUES ('%e', '%s')", ReturnPlayerName(playerid), passwordHashed);
                            mysql_tquery(SQLConnection, iQuery);
                            Construct_PlayerConnected(playerid);
                            return 1;
                        }
                    }
                }
            }
            Dialog_ShowCallback(playerid, using inline RegisterResponse, DIALOG_STYLE_PASSWORD, "{3196ef} - "SERVER_GM"{adc7e7}", "  {FFFFFF}Please enter your password to Register", "Register", "");
        }
    }
    new iQuery[128];
    mysql_format(SQLConnection, iQuery, sizeof(iQuery), "SELECT `ID`, `Password` FROM `PlayerInfo` WHERE `PlayerName` = '%e' LIMIT 1", ReturnPlayerName(playerid));
    mysql_tquery_inline(SQLConnection, iQuery, using inline OnCheckPlayerAccount, "");
    return 1;
} 


Re: MySQL & y_inline & y_dialog - Misiur - 02.04.2016

Do you see any errors in mysql_log?

Re: MySQL & y_inline & y_dialog - d3ll - 02.04.2016

Sorry, I've fixed it forgot to add dialogid in the response line! Stupid mistake.