Need help with MySQL-based command
#1

pawn Код:
CMD:setlevel(playerid, params[])
{
    new targetid, level;
    {
        if(PlayerInfo[playerid][pLevel] < 5 && !IsPlayerAdmin(playerid))
        {
            SCM(playerid, COLOR_RED, "** You are not authorize to use this command.");
            return 1;
        }
        if(PlayerInfo[playerid][pLevel] < 9 && PlayerInfo[playerid][pLevel] > 5 )
        {
            SCM(playerid, COLOR_YELLOW, "** Your admin level is not high enough to use this command.");
            return 1;
        }
        if(targetid == INVALID_PLAYER_ID)
        {
            SCM(playerid, COLOR_YELLOW, "** You have entered invalid player id");
            return 1;
        }
        if(sscanf(params, "ui", targetid, level))
        {
            SCM(playerid, COLOR_YELLOW, "** SETLEVEL: /setlevel <PlayerID/PlayerName> <level>");
            SCM(playerid, COLOR_YELLOW, "* Valid Level: 1 = Regged Player, 2 = VIP, 3 = Special VIP.");
            SCM(playerid, COLOR_YELLOW, "* 4 = Permanent VIP, 5 = Moderator, 6 = Junior Admin.");
            SCM(playerid, COLOR_YELLOW, "* 7 = General Admin, 8 = Uber Admin, 9 = Management.");
            return 1;
        }
        if(level == 2)
        {
            SCM(playerid, COLOR_YELLOW, "** You have made %s a VIP.");
            SCM(targetid, COLOR_GREEN, "*** Congratulations...");
            SCM(targetid, COLOR_GREEN, "** You have been made a VIP by %s.");
            SCM(targetid, COLOR_GREEN, "** To check when your VIP will be expired use /vipstatus");
            new query[300], pname[24];
            GetPlayerName(playerid, pname, 24);
            format(query, sizeof(query), "UPDATE playerdata SET vip=%d  WHERE user='%s'",level, pname);
            mysql_query(query);
            return 1;
        }
        else if(level == 3)
        {
            SCM(playerid, COLOR_YELLOW, "** You have made %s a Special VIP");
            SCM(targetid, COLOR_GREEN, "*** Congratulations...");
            SCM(targetid, COLOR_GREEN, "** You have been made a Special VIP by %s.");
            SCM(targetid, COLOR_GREEN, "** To check when your VIP will be expired use /vipstatus");
            new query[300], pname[24];
            GetPlayerName(playerid, pname, 24);
            format(query, sizeof(query), "UPDATE playerdata SET vip=%d  WHERE user='%s'",level, pname);
            mysql_query(query);
            return 1;
        }
        else if(level == 4)
        {
            SCM(playerid, COLOR_YELLOW, "** You have made %s a Permanent VIP");
            SCM(targetid, COLOR_GREEN, "*** Congratulations...");
            SCM(targetid, COLOR_GREEN, "** You have been made a Permanent VIP by %s.");
            SCM(targetid, COLOR_GREEN, "** Your VIP Status will not be expired anymore.");
            new query[300], pname[24];
            GetPlayerName(playerid, pname, 24);
            format(query, sizeof(query), "UPDATE playerdata SET vip=%d  WHERE user='%s'",level, pname);
            mysql_query(query);
            return 1;
        }
        else if(level == 5)
        {
            SCM(playerid, COLOR_YELLOW, "** You have made %s a Moderator");
            SCM(targetid, COLOR_GREEN, "*** Congratulations...");
            SCM(targetid, COLOR_GREEN, "** You have been made a Moderator by %s.");
            SCM(targetid, COLOR_GREEN, "** Your VIP Status has been changed to Permanent VIP.");
            SCM(targetid, COLOR_GREEN, "** Your VIP Status will not be expired anymore.");
            new query[300], pname[24];
            GetPlayerName(playerid, pname, 24);
            format(query, sizeof(query), "UPDATE playerdata SET vip=3, level=%d,  WHERE user='%s'",level, pname);
            mysql_query(query);
            return 1;
        }
        else if(level == 6)
        {
            SCM(playerid, COLOR_YELLOW, "** You have made %s a Junior Admin");
            SCM(targetid, COLOR_GREEN, "*** Congratulations...");
            SCM(targetid, COLOR_GREEN, "** You have been made a Junior Admin by %s.");
            new query[300], pname[24];
            GetPlayerName(playerid, pname, 24);
            format(query, sizeof(query), "UPDATE playerdata SET level=%d,  WHERE user='%s'",level, pname);
            mysql_query(query);
            return 1;
        }
        else if(level == 7)
        {
            SCM(playerid, COLOR_YELLOW, "** You have made %s a General Admin");
            SCM(targetid, COLOR_GREEN, "*** Congratulations...");
            SCM(targetid, COLOR_GREEN, "** You have been made a General Admin by %s.");
            new query[300], pname[24];
            GetPlayerName(playerid, pname, 24);
            format(query, sizeof(query), "UPDATE playerdata SET level=%d,  WHERE user='%s'",level, pname);
            mysql_query(query);
            return 1;
        }
        else if(level == 8)
        {
            SCM(playerid, COLOR_YELLOW, "** You have made %s a Uber Admin");
            SCM(targetid, COLOR_GREEN, "*** Congratulations...");
            SCM(targetid, COLOR_GREEN, "** You have been made a Uber Admin by %s.");
            new query[300], pname[24];
            GetPlayerName(playerid, pname, 24);
            format(query, sizeof(query), "UPDATE playerdata SET level=%d,  WHERE user='%s'",level, pname);
            mysql_query(query);
            return 1;
        }
        else if(level == 9)
        {
            SCM(playerid, COLOR_YELLOW, "** You have made %s a Management");
            SCM(targetid, COLOR_GREEN, "*** Congratulations...");
            SCM(targetid, COLOR_GREEN, "** You have been made a Management by %s.");
            SCM(targetid, COLOR_GREEN, "** Now, you will be able to Promote/Demote a Player.");
            new query[300], pname[24];
            GetPlayerName(playerid, pname, 24);
            format(query, sizeof(query), "UPDATE playerdata SET level=%d,  WHERE user='%s'",level, pname);
            mysql_query(query);
            return 1;
        }
        else
        {
            new query[300], pname[24];
            GetPlayerName(playerid, pname, 24);
            format(query, sizeof(query), "UPDATE playerdata SET level=%d,  WHERE user='%s'",level, pname);
            mysql_query(query);
        }
        return 1;
    }
}
So, the problem is when i tried to execute the command.. samp-server.exe crashes. I don't know how to fix this. And i'm still new to MySQL thing
Reply
#2

Post your mysql log (debug log) and samp log
Reply
#3

there's nothing there..
Reply
#4

put this ongamemodeinit
mysql_debug(1);
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)