top 2 who died the most

[luizinhomt]

Good evening everyone, could someone show me an example of how to create two scripts where it will show the two players who died the most on the server, when clicking on the script, show the number of times they died and a menu to reset the NPC, thank you very much everyone

[Racaae]

Hi

prontera,161,220,5	script	Top 2 who died the most	4_BOARD3,{
	mes "[Top 2 who died the most]";
	
	.@nb = query_sql( "SELECT count(2) as deaths, (SELECT name FROM `char` where char_id = died_id) FROM diedlog GROUP BY died_id ORDER BY deaths DESC LIMIT 2", .@kills, .@name$ );
	query_sql( "SELECT count(2) as deaths FROM diedlog where died_id = '" + getcharid(0) + "'", .@personal );
	if (.@nb) {
		for ( .@i = 0; .@i < .@nb; ++.@i )
			mes F_GetNumSuffix(.@i+1) + " ^0000FF" + .@name$[.@i] + "^000000 - "+ .@kills[.@i] + " death" + (.@kills==1?"":"s");
	} 
	else
		mes "no entry";
	mes " ", "Your deaths : " + .@personal;	

	if (getgroupid() > 80) {
		if (select("Cancel.", "^FF0000Reset^000000") == 2) {
			query_sql(" TRUNCATE TABLE `diedlog`; ");
			mes "Reset done.";
		}
	}
	close;

OnInit:
	query_sql("CREATE TABLE IF NOT EXISTS `diedlog` (`id` mediumint(9) unsigned NOT NULL auto_increment, `date` datetime NOT NULL, `died_id` int(11) NOT NULL default '0', PRIMARY KEY  (`id`)) ENGINE=MyISAM AUTO_INCREMENT=1;");
	end;

OnPCDieEvent:
	query_sql("INSERT INTO `diedlog` (`date`, `died_id`) VALUES (now(), '" + getcharid(0) + "');");
	end;
}

 

[Poring King]

Here i have top 30 or you can adjust it using the configuration

 

//=============================
// NPC Script: Top 30 Deaths
//=============================
prontera,150,150,4	script	Top Deaths	837,{

    // Configuration Section
    OnInit:
        // Configurable variables
        .npc_name$ = "[Top Deaths]";
        .limit = 30; // Limit of players to display

        // End of Configuration
        end;

    OnTalk:
        // Fetch the top 30 players with the most deaths
        query_sql("SELECT `name`, `death` FROM `char` ORDER BY `death` DESC LIMIT " + .limit, .@name$, .@deaths);

        // Display the top 30 players
        mes .npc_name$;
        mes "Top " + .limit + " Players Who Died the Most:";
        for (.@i = 0; .@i < getarraysize(.@name$); .@i++) {
            mes (.@i + 1) + ". " + .@name$[.@i] + " - " + .@deaths[.@i] + " deaths";
        }
        close;
}

 

Edited July 15, 2024 by Poring King

[luizinhomt]

Thank you very much I will test