Leaderboards

[Guest]

Welcome, Guest. Please login or register.
Did you miss your activation email?

1 Hour 1 Day 1 Week 1 Month Forever

Login with username, password and session length

Getting Started

Rules

Character Mover

Optimization Guide

EZ Wiki

EZ Guide

Magelo

Zone List

Spell Recipes

T10.5 Spell Recipes

Crafting Recipes

Donate

EZ Player Discord

[EZ Server Files]

EZ Server Files

EZ Client Downloads

Custom UF MiniMap

Custom UF Inventory

EQEmu Server Status

EQEmulator Home

Allakhazam Home

UFMissingFilesList

TwitchTV

[Hunter]

More testing, changing array @table to string $table via using '.' for concat, didn't make any difference, works for top 10 but not 15.

Still trying to figure out why large variable / array crashing popup window

void quest::popup(char *title, char *text, int32 popupid, int32 buttons, int32 Duration);

void $client->SendPopupToClient(const char *Title, const char *Text, int32 PopupID, int32 Buttons, int32 Duration);

Maybe max size of const char or something? Guessing its size issue in eqemu source code some where.

[Hunter]

Just thought of an idea. Could turn players names into a website link to bring up the players Magelo.

Just a neat feature short cut idea, but would probably conflict with size of info being passed to the popup window which we need to fix first.

Showing 10 results per popup is good idea anyways.

[Natedog]

The text length in game is a client issue I think...

Sending a HUGE Array to chat WILL crash you... doing it in the Popup box just makes the box not work.  (Just a guess)

But this is what it seems like.

[lerxst2112]

The client can handle just under 4k for a chat message from the server.  I'm not sure if the same limit applies to the popup box as I didn't test that.

[Natedog]

I'd suggest a minimum level for the Leaderboard... when you create a Level 1 Wizard it has a bugged amount of AC lol

Erudite Wizards have 65,534 AC  which is odd... 1 more AC than a level 1 Gnome Wizard


#Mystats  .... Erudite Wizard starts with -2 AC

ATK they start with is 65,531


Going negative in stats makes them really high.



Level 2 Erudite Wizard has the most AC though at -1 AC heh... wonder why they start with negative AC.. =\

[Hunter]

Maybe minimum level 60, pointless for lower levels.

[Hunter]

Now that we have a working beta leaderboards, I can expand on it.

Make minimum level 60 to be on it.

Also other stats like HP regen and Mana Regen.

Since we're limited to 4k size of message, then maybe top 10's would combine hp and hp regen, then mana and mana regen. Either way, I can't display all stat cause we'd go over the 4k size limit.

So what do we want to see? How do we get the info?

We want hp/mana regens? Whats the code to get that info?

I could easily do who got killed most by buff bot but that'd only encourage spamming.

I could do who died most times via global_npc.pl, haven't tried yet but sure its possible.

I thought about money but some people said thats private info. Same with days played.

[red2]

have it do a unique query, to tell you what # you are on the list? have it just return you are #37 .. etc

[Natedog]

have it do a unique query, to tell you what # you are on the list? have it just return you are #37 .. etc

Code:

if ($text=~/MY RANK/i)
	{
		$sth = $dbh->prepare("SELECT hp from leaderboard WHERE name = '$name'");
		$sth->execute();
		my $rankedHP = $sth->fetchrow_array();
		$sth = $dbh->prepare("SELECT COUNT(hp) from leaderboard WHERE hp > $rankedHP");
		$sth->execute();
		my $ranked = int($sth->fetchrow_array()+1);
		$client->Message(315,"You are Ranked Number $ranked on HP!");
		if ($ranked > 10)
		{
			$ranklist = int($ranked -10);
		}
		else
		{
			$ranklist = int(1);
		}
		@table = "<table><TR><TD>#<TD>$Yel NAME </c><TD>$grn HP </c><TD>$Blu MANA </c><TD>$Pink CLASS </c>/$orange Race </c><TD>$Red LEVEL </c><TD>AC<TD>$purp AA </c><TD>";
	$sth = $dbh->prepare("SELECT  name, hp, mana, class, level, armor, aa, race FROM leaderboard ORDER BY hp DESC LIMIT $ranklist,10");
	$sth->execute();
		$n = $ranklist;
		if ($n > 1)
		{
			$n = $n+1;
		}
		while (my ($pname, $php, $pmana, $pclass, $plevel, $pac, $paa, $prace) = $sth->fetchrow_array())
		{
		my $php2 = plugin::commify($php);
		my $pmana2 = plugin::commify($pmana);
		my $pac2 = plugin::commify($pac);
		my $paa2 = plugin::commify($paa);
			push(@table, "<TR><TD>$n<TD>$Yel $pname </c><TD>$grn $php2 </c><TD>$Blu $pmana2 </c><TD>$Pink $pclass </c>/$orange $prace </c><TD>$Red $plevel </c><TD>$pac2<TD>$purp $paa2 </c><TD>");
		$n++;
		}
		push(@table, "</table>");
	quest::popup("Your Rank", "@table");
	$sth->finish ();
	$dbh->disconnect();
	}

This will show the 9 players AHEAD of you in HP.. its fairly sloppy and probably could be written better... but this works and gives you an idea of how I did it heh.


Heres what it looks like...

[Hunter]

Went out today and beat from the heat, but will probably use some of that code soon into our current leaderboards, thanks again!

[Natedog]

That code had a small error need to change how $n was calculated.

Code:

if ($text=~/MY RANK/i)
	{
		$sth = $dbh->prepare("SELECT hp from leaderboard WHERE name = '$name'");
		$sth->execute();
		my $rankedHP = $sth->fetchrow_array();
		$sth = $dbh->prepare("SELECT COUNT(hp) from leaderboard WHERE hp > $rankedHP");
		$sth->execute();
		my $ranked = int($sth->fetchrow_array()+1);
		$client->Message(315,"You are Ranked Number $ranked on HP!");
		if ($ranked > 10)
		{
			$ranklist = int($ranked -10);
		}
		else
		{
			$ranklist = 0;
		}
		@table = "<table><TR><TD>#<TD>$Yel NAME </c><TD>$grn HP </c><TD>$Blu MANA </c><TD>$Pink CLASS </c>/$orange Race </c><TD>$Red LEVEL </c><TD>AC<TD>$purp AA </c><TD>";
		$sth = $dbh->prepare("SELECT  name, hp, mana, class, level, armor, aa, race FROM leaderboard ORDER BY hp DESC LIMIT $ranklist,10");
		$sth->execute();
		$n = $ranklist;  #Set Rank to the Ranklist number
		if ($ranked > 10)
		{
			$n = $n+1;   #If their rank is over 10 you must add 1 otherwise it won't be correct
		}
		if ($n == 0)
		{
			$n = 1;   #If they are in the top 10 need this part
		}
		while (my ($pname, $php, $pmana, $pclass, $plevel, $pac, $paa, $prace) = $sth->fetchrow_array())
		{
		my $php2 = plugin::commify($php);
		my $pmana2 = plugin::commify($pmana);
		my $pac2 = plugin::commify($pac);
		my $paa2 = plugin::commify($paa);
			push(@table, "<TR><TD>$n<TD>$Yel $pname </c><TD>$grn $php2 </c><TD>$Blu $pmana2 </c><TD>$Pink $pclass </c>/$orange $prace </c><TD>$Red $plevel </c><TD>$pac2<TD>$purp $paa2 </c><TD>");
		$n++;
		}
		push(@table, "</table>");
	quest::popup("Your Rank", "@table");
	$sth->finish ();
	$dbh->disconnect();
	}

This one works better... had to find a way to get the numbered list to show up correctly for players ranked in the Top 10 when they checked their rank.

[Natedog]

We want hp/mana regens? Whats the code to get that info?

I could do who died most times via global_npc.pl, haven't tried yet but sure its possible.

I don't see any Perl export for HP/Mana Regen.


Doing deaths would be awesome though!


Could maybe even do Boss kills?  Only for end bosses like OMM and such

[Hunter]

Added Resist and Richest leaderboards.

Might get some other ideas here:

https://github.com/EQEmu/Server/blob/master/zone/client.h

[Natedog]

Took me all day... but I did it!


Used a bit of script from the AllaClone ... modified the script .. added some HTML and bam!

Hopefully EZs gets up soon! I wanna keep tabs on Fugitives HPz when I cant play! lol


http://108.239.155.107/AllaClone/leaderboard.php

[Brokyn]

That is awesome Nate!  Any chance to add a guild tag in there?

Advanced search

• Unable to log in by Chieftan [November 23, 2024, 07:04:51 am]
• Everquest Tweaks and Sett... by Pubis [November 18, 2024, 11:18:15 am]
• Broken Stuff Repair Shop ... by Draca [November 12, 2024, 08:47:03 am]
• Update to Halls of Honor by Sarthin [November 10, 2024, 04:57:40 pm]
• Halloween 2024 by clbreastmilk [November 04, 2024, 07:55:17 am]
• Some T12 Questions by Miriya [October 28, 2024, 01:38:59 pm]
• HW 2024 by Raygan [October 21, 2024, 08:03:01 am]
• Ninja Looting by zefirus [October 20, 2024, 04:55:10 pm]
• Official Guild Creation R... by Tylperion [September 15, 2024, 11:54:54 am]
• T11 Feedback Thread by Sarthin [August 28, 2024, 12:45:01 pm]
• What's next for the rest ... by Mixlor [August 27, 2024, 02:01:07 pm]
• Hard Mode NPC by Mixlor [August 06, 2024, 09:37:00 am]
• Looking for some advice (... by Draca [July 31, 2024, 10:55:17 am]
• 4th of July Event by orkiho [July 12, 2024, 07:35:22 pm]
• New Server update causing... by Mixlor [June 02, 2024, 01:01:54 am]
• Memorial Day Event by wachna [May 30, 2024, 01:52:28 pm]
• EZServer Rules by Sarthin [May 30, 2024, 01:10:12 pm]
• Fear Itself, testing week... by torotornot [May 24, 2024, 09:29:42 am]
• Fear Itself, the new Even... by kendiian [April 26, 2024, 11:48:38 pm]
• Recent & Upcoming Changes by Dokplayer2 [April 23, 2024, 10:48:30 pm]
• Issue with my epic by fangzy [April 22, 2024, 07:32:32 pm]
• Few Changes - T11, VP, Gu... by clbreastmilk [April 10, 2024, 11:32:33 am]
• Combine HoH tokens macro.... by Dbeast [April 04, 2024, 05:10:46 pm]
• Warlock self buffs by Fecs [April 04, 2024, 03:56:08 pm]

Members

• Total Members: 6156
• Latest: Rin1

Stats

• Total Posts: 65127
• Total Topics: 5066
• Online Today: 379
• Online Ever: 8678
• (December 19, 2022, 02:32:09 pm)

Users Online

Users: 0
Guests: 324
Total: 324