MVP Rank Help

[Hossam]

//= ---
//= MvP Rank Improved v1.0
//= ---
//= This Rank will count every MvP you kill,
//= to be more clear, will count every mob
//= defined inside the array ".mobid[0]",
//= so, if you add the poring ID will count in the rank
//= you can modify and ad miniBoss because this array
//= only have all MvPs, that's the idea, only MvPs...
//= ---

// --- Re-coded by Cookie ---


-	script	Rank MvP	-1,{

OnInit:


setarray .mobid[0],1511,1647,1785,1630,1399,1039,1874,2068,1272,1719,1046,1389,1112,1115,1957,1418,1871,1252,1768,1086,1688,1646,1373,1147,1059,1150,1956,2022,1087,1190,1038,1157,1159,1502,1623,1650,1583,1708,1312,1751,1685,1648,1917,1658;
set .a, 1; // [ 1 - Enable global announcement on MvP kill ] [ 0 - Disable global announcement ]
set $@top, 10; // Number of top rankings that will be shown.
end;

OnNPCKillEvent:
if (getgmlevel() > 10) end;

for (set .@c, 0; .@c < getarraysize(.mobid); set .@c, .@c + 1) { if (killedrid == .mobid[.@c]) set .@s, 1; } // Check MvP
if (!.@s) end;
if (.a) announce "قام اللاعب [" +strcharinfo(0) +"] بقتل [" +getmonsterinfo(killedrid,0) +"] فى خريطة [" +strcharinfo(3) +"]",bc_blue|bc_all;

query_sql "SELECT char_id FROM mvp_ranking WHERE char_id = "+getcharid(0),@char_id;

if (@char_id == getcharid(0)) {
	query_sql "SELECT mvp_count FROM mvp_ranking WHERE char_id = "+getcharid(0),@mvptotal;
	set @mvptotal, @mvptotal +1;
	query_sql "UPDATE mvp_ranking SET mvp_count = '"+@mvptotal+"' WHERE char_id = "+getcharid(0);
	} else {
	set @mvptotal, 1;
	query_sql "INSERT INTO mvp_ranking (id,char_id,mvp_count) VALUES ('','"+getcharid(0)+"','"+@mvptotal+"')";
	}
	end;
}


// ===== Functions =====
function	script	mvp_rank	{
    set @mvptotal, getarg(0);
    set @nomb$, getarg(1);
    for (set .@c, 0; .@c < $@top; set .@c, .@c + 1)
    {
        if (@mvptotal >= getd("$topmvp" +.@c))
        {
            if (strcharinfo(0) == getd("$topmvp" +.@c +"$"))
            {
                setd "$topmvp" +.@c, @mvptotal;
                setd "$topmvp" +.@c +"$", @nomb$;
                return;
            }
            else
            {
                if (getd("$topmvp" +(.@c + 1) +"$") == "")
                {
                    setd "$topmvp" +.@c, @mvptotal;
                    setd "$topmvp" +.@c +"$", @nomb$;
                    return;
                }
                else
                {
                    setd "$topmvp" +(.@c + 1), getd("$topmvp" +.@c);
                    setd "$topmvp" +(.@c + 1) +"$", getd("$topmvp"+.@c+"$");
                    setd "$topmvp" +.@c, @mvptotal;
                    setd "$topmvp" +.@c +"$", @nomb$;
                    return;
                }
            }
        }
    }
	return;
}

// ===== Script ======
-	script	Rank MvP	-1,{
	OnInit:
        // Set npc-specific variables
        setarray .mobid[0],1511,1647,1785,1630,1399,1039,1874,2068,1272,1719,1046,1389,1112,1115,1957,1418,1871,1252,1768,1086,1688,1646,
        1373,1147,1059,1150,1956,2022,1087,1190,1038,1157,1159,1502,1623,1650,1583,1708,1312,1751,1685,1648,1917,1658,2362,1832,1885,1373,1251,1492; // MvP Ids
        set .a, 0; // Broadcast who killed the MvP and wich MvP and wick Map [0 Off - 1 On]
        set $@top, 10; // Max. Top Rank (Hihgly recommended between 5~10, more maybe bug the server (limited variables)
        end;

	OnNPCKillEvent: // Script execution
        for (set .@c, 0; .@c < getarraysize(.mobid); set .@c, .@c + 1)
        {
        	if (killedrid == .mobid[.@c])
            {
        		set .@s, 1; // If a MvP
			}
		}
        if (!.@s) // Indicates if not a MVP; if so, end script execution.
        	end;
        if (.a) // If announcement is toggled, execute broadcast.
			announce "The user [" +strcharinfo(0) +"] has killed a [" +getmonsterinfo(killedrid,0) +"] in the map [" +strcharinfo(3) +"]",bc_blue|bc_all;
        set MvP, MvP + 1;
        mvp_rank(MvP,strcharinfo(0));
        end;
}

prontera,139,171,6	script	MvP Rank	661,{
	
waitingroom "MVP Ranking",0;


    function	checkPerm;
    // Check GM level;
    if (checkPerm())
    {
    	set .@sel, select ("Show Ranking:^FF0000Reset MVP Ranking^000000");
        if (.@sel == 2)
        { // Reset Ranking
        	mes .npcname$;
            mes "Are you sure you would like to reset the MVP Ranking?";
            next;
            set .@confirm, select ("Confirm:Cancel");
            if (.@confirm == 1)
            {
            	for (set .@i, 0; .@i < $@top; set .@i, .@i + 1)
                {
                	setd "$topmvp" +.@i, 0;
                    setd "$topmvp" +.@i +"$", "";
                }
                mes .npcname$;
                mes "The Ranking has been reset.";
                close;
                end;
			}
			else
			{
				close;
				end;
			}
        }
    }
	mes .npcname$;
	for (set .@c, 0; .@c < $@top; set .@c, .@c + 1)
	{
		mes "#^FF0000" +(.@c + 1) +"^000000 [ ^0000FF" +getd("$topmvp" +.@c +"$") +"^000000 ] with ^FF0000" +getd("$topmvp" +.@c) +"^000000 MvP killed.";
	}
	close;
    end;
    
    // =========================
    // ===== Configuration =====
    // =========================
    OnInit:
    	set .npcname$, "[ MvP Rankings ]";
    	setarray .gm_perm[0],99; // Set all of the GMs that can access this
        end;
    
    function	checkPerm	{
    	for (set .@i, 0; .@i < getarraysize(.gm_perm); set .@i, .@i + 1)
        {
        	if (getgmlevel() >= .gm_perm[.@i]) // Change this to >= or == dependent on if you're specifically wanting to set individual GM levels (==) or hierarchy (>=)
            	return 1;
        }
        return 0;
    }
}

I need help
I want to make the script delete the rank of players if online or offline
When I delete, only the connected players are deleted