Plugin: Player Leaderboards (In-Game)
Purpose:
To display an in-game leaderboards for players to see where they rank. ------------------------ I've had this code written for ages so the quality is so-so. But it definitely does what it needs to do. Feel free to modify if want. ------------------------ Required: Perl DBI - See Google for installing Perl DBI/DBD for Mysql, until I create an article explaining otherwise. Required: plugin::LoadMysql(); - See thread HERE Required: Popup Window plugin utils Required: Mysql table `cust_ext_leaderboards` http://wiki.eqemulator.org/i?Module=...Paste=BgtI3fWi http://i.imgur.com/stzAiqT.png Source Table: Code:
-- ---------------------------- Code:
sub EVENT_SAY{ Code:
plugin::LeaderBoardsUpdate(); Name: Leaderboards.pl Options: You can set your website Magelo Path under LoadMageloPath, or you can put in javascript:; or # if you don't have a site. Enjoy, let me know if you experience issues. |
Quote:
Nice Akkadius! +1 I prefer to run the collection routine in this sub: sub EVENT_CONNECT {} That way code runs only 1 time when player logs in, instead of every time they zone. That way it won't spam update the database each time a player dies or zones. |
Is this still working? I installed everything, and queries are working. When I say 'player leaderboards' I get the text "Player Leaderboards" and a list of classes in saylink format. If I click any of the saylinks, nothing happens. If I manually type the trigger, nothing happens as well.
Im not sure if Im missing a plugin. I downloaded the popup_window_utils, DBI is working, and the database table is working and being populated. |
Quote:
I would download a fresh batch of plugins from the stickied SVN in the thread: http://www.eqemulator.org/forums/showthread.php?t=32608 |
I have tried this plugin, and I am running into the same issue that Nibiuno stated above. Verified DBI is working, the cust_ext_leaderboards is being populated correctly. The popup_windows_utils and leaderboards.pl are in the plugin folder. I get the saylinks for classes, but once I click one of them, nothing happens.
|
Quote:
|
yes I have logging set to 3, I can see the queries happening, but no errors
|
Quote:
THE GIRLS NEVER CAME. I have to help someone quick but I will check into this plugin. Thanks for reporting. |
LMAO Akka, thanks
|
Looking at this now
|
OK, spent about an hour cleaning this up.
Replace Leaderboards.pl in your plugins folder with this code: http://wiki.eqemulator.org/i?Module=...Paste=BgtI3fWi http://i.imgur.com/stzAiqT.png Source Table: Code:
-- ---------------------------- |
Thanks for the update. Copied the new code to Leaderboards.pl in my plugins folder and resourced my DB. Do not get the popup window, but that maybe because the cust_ext_leaderboards table has not been populated yet. I have the following in my global_player.pl file.
Code:
sub EVENT_ENTERZONE { |
Quote:
It has become apparent to me we need a decent way to update plugins because people are apparently downloading the wrong ones... |
Yup. I have it. I downloaded all the plugins from the repository. Check them daily to see if there are any new changes.
Here is the Diawind.pl plugin. Code:
#::: Author: Akkadius |
Quote:
|
http://i.imgur.com/nAeiXH6.jpgyes its installed. SS below.
|
Quote:
#logs quest gmsay 38 1 What do you see when you try to show a window. |
Nothing displayed when setting logging to 1 or 3. No errors. Tested on other quest NPCs also. Very strange. Verified the log settings are in the logsys_categories table.
Turned on MYSQL Queries and Errors. This is all that was returned when clicking on Top HPs. http://i.imgur.com/Yvs1Pbk.jpg |
Also, no one is on the server but myself atm. Its not open to public yet. The DB is not populating my stats. It was before.
|
Quote:
https://code.google.com/p/eqemuplugi..._formatting.pl |
Nope. I have text_formatting.pl in my plugins folder.
Code:
###AKKADIUS### |
Quote:
|
no way man. I have been working on my server for about 2 months. I come from a very technical background, but not in programming. Learned a lot from this community. I can give you access to my server if you want to look.
|
Quote:
|
PMing you now
|
Thanks Akka for the help. I will make changes later tonight and update this thread
|
Ok Akka, Cleaned up the system of incorrect version of perl and updated DBI and DBD:mysql. Only issue that I am having now is the popup windows does not populate the information from the DB. Below are SS's.
http://i.imgur.com/9ZDfLmj.jpg Logging. http://i.imgur.com/PGIbs7Y.jpg cust_ext_leaderboards view http://i.imgur.com/tjuKMEh.jpg Thanks again for the assistance last night. |
Quote:
|
ahh ok, cool! Thanks
|
I made the following modification to the Leaderboards.pl script to report unbuffed hitpoints. Just in case anybody hadn't figure it out yet. :)
Code:
my $hp1 = $client->GetMaxHP(); |
Quote:
|
Hah, yep. Now I gotta figure how to do the same for mana.
|
Quote:
If I do #showstats on a myself or player as GM a stat box pops up with cancel or update with all the stats, but the quest npc is not popping up the box after clicking the links, just saying Fine! |
This is only for Perl, you'd have to write something separate for lua
|
I know this is an old post, but I have gotten everything to work except the Top HP and AC portion. basically anything linked to the commify plugin yet im fairly certain i have the latest one.
Also, apprently SK's and Warriors no longer show up now lol |
All times are GMT -4. The time now is 02:59 PM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.