Leaderboard

View File Nydhoggs Nest Instance with Difficulty Reuploaded: Edited Nydhoggs Nest Instance with different difficulties. (see attachments) Submitter Louis T Steinhil Submitted 07/04/24 Category Games, Events, Quests Video Content Author LS  

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; }

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; }

Good afternoon friends, resolved, for those who don't know or don't understand, it's very simple, put I enter my paid phpmyadmin database or vertrigo or whatever you use, you look for the line called "char" you click on it to open, it will open all your acc's = user accounts, don't mess with that, at the top there is a file called "SQL" you click on it and it will open a screen in which you can put lines of SQL commands, well I don't know anything about scripting or programming I went to chatgpt and it even generated a compatible file for me to put there in the "write SQL" option ALTER TABLE `char` ADD `pvp_kill` INT(11) NOT NULL DEFAULT 0; This file is responsible for creating the column "pvp_kill" in your database because initially it doesn't exist, after that you click on execute, ready if you go to the "char" tab, open it and go to the second column option there a column will be created with the name "pvp_kill" it is responsible for counting player kills. I hope I helped with details for new people who are after this, because I don't understand anything I had a lot of difficulty, thanks to the guy above my post, you made me go back until I resolved it. Apparently everything worked correctly, although a message "nothing found in the selected map" is appearing, I still don't know the reason but without any errors in the emulator so far.

View File Map Information w/ Visuals Heya rA folks! Today i bring you this awesome function that imitates MapInfo for 2020+ clients. This is for 2018 clients and below. Just install the script and merge the files to your main grf and viola! Also, if you dont want the cutins version i made text version as well. Just set .@cutinmode into 0. PSD file Included. ENJOY!!! P.S. I'm not good at graphic designs but this will do. ? Submitter Gidz Cross Submitted 07/18/22 Category Other Video Content Author Gidz