Convert to MySQL (sqlite_escape_string)
#1

pawn Код:
case DIALOG_MAIN_MENU_CHARACTER_DELETE:
        {
            if(response)
            {
                if(strlen(inputtext) >= 1)
                {
                    if(CharacterExists(sqlite_escape_string(InsertPlayerUnderscoreString(inputtext))))
                    {
                        if(PlayerOwnsCharacter_Name(playerid, sqlite_escape_string(InsertPlayerUnderscoreString(inputtext))))
                        {
                            format(query, sizeof(query), "DELETE FROM `Character` WHERE `name` = '%s'", sqlite_escape_string(InsertPlayerUnderscoreString(inputtext)));
                            db_free_result(db_query(database,query));
                            format(query, sizeof(query), "[I:] You have successfully deleted character: %s.", inputtext);
                            SendClientMessage(playerid, COLOR_YELLOW, query);
                            ShowMenuDialog(playerid);
                        }
                        else
                        {
                            ShowPlayerDialog(playerid,DIALOG_MAIN_MENU_CHARACTER_DELETE,DIALOG_STYLE_INPUT,"Master Account - Delete Character","What is the name of the character you wish to delete?\nYou will not be able to recover it after it has been deleted!\n(Firstname Lastname format)","Delete","Go Back");
                        }
                    }
                    else
                    {
                         ShowPlayerDialog(playerid,DIALOG_MAIN_MENU_CHARACTER_DELETE,DIALOG_STYLE_INPUT,"Master Account - Delete Character","What is the name of the character you wish to delete?\nYou will not be able to recover it after it has been deleted!\n(Firstname Lastname format)","Delete","Go Back");
                    }
                }
                else
                {
                     ShowPlayerDialog(playerid,DIALOG_MAIN_MENU_CHARACTER_DELETE,DIALOG_STYLE_INPUT,"Master Account - Delete Character","What is the name of the character you wish to delete?\nYou will not be able to recover it after it has been deleted!\n(Firstname Lastname format)","Delete","Go Back");
                }
            }
            else
            {
                ShowPlayerDialog(playerid, DIALOG_MAIN_MENU_OPTIONS, DIALOG_STYLE_LIST, "Main Menu - Options", "Create New Character\nDelete Character\nChange Password\nDisconnect", "Continue", "Go Back");
            }
        }

pawn Код:
sqlite_escape_string
What would I use instead?
Reply


Messages In This Thread
Convert to MySQL (sqlite_escape_string) - by AMouldyLemon - 22.06.2014, 17:41
Re: Convert to MySQL (sqlite_escape_string) - by RenovanZ - 22.06.2014, 17:55
Re: Convert to MySQL (sqlite_escape_string) - by AMouldyLemon - 22.06.2014, 18:05
Re: Convert to MySQL (sqlite_escape_string) - by Clad - 22.06.2014, 18:08
Re: Convert to MySQL (sqlite_escape_string) - by AMouldyLemon - 22.06.2014, 18:09
Re: Convert to MySQL (sqlite_escape_string) - by RenovanZ - 22.06.2014, 18:11
Re: Convert to MySQL (sqlite_escape_string) - by AMouldyLemon - 22.06.2014, 19:02
Re: Convert to MySQL (sqlite_escape_string) - by AMouldyLemon - 22.06.2014, 19:19

Forum Jump:


Users browsing this thread: 1 Guest(s)