Update 11/16/06
While I am no longer playing the game, I will continue to keep the software up to date so long as my guild is playing.  My support e-mail address is still rostermaster@bellumaeternus.com.

Message Edited by SaintPeter on 11-16-2006 09:54 AM

Message Edited by Manitos on 03-21-2005 08:21 AM

Great job, Peter!

---

thedump wrote:
This is great! I just saw they added completed quests to the list on SOE as well. I was wondering in anyone knew how properly convert it to be a module in PhpNuke?

---

---

Homeslice wrote:

---

thedump wrote:
This is great! I just saw they added completed quests to the list on SOE as well. I was wondering in anyone knew how properly convert it to be a module in PhpNuke?

---

Just curious where did you see this?

---

---

SaintPeter wrote:

---

thedump wrote: This is great! I just saw they added completed quests to the list on SOE as well. I was wondering in anyone knew how properly convert it to be a module in PhpNuke?

---

I know how to properly convert it into a phpNuke Module, since I orginally wrote it for phpNuke (My Personal Implementation).  I am going to be wrapping up the code in a phpNuke Module in my next release, which should be in the next few days, my schedule permitting.

 

At the same time, I will also be adding a $config['prefix'] variable, as requested, so you may have multiple versions of the roster in a single SQL database.

 

I hope to add the capability to map usernames to character names soon as well.  This will be no problem for the 'nuke implementation, but more complex for non-nuke/non-database implementations.

 

I'm interested to know what CMS or website backend folks are running.  So long as there is a user table and some method of session tracking, I should be able to write an interface for the username->character name mapping.

 

Watch this space for updates

---

---

aiyl wrote:
I'd like to see sorting by archetype (i.e. Priest, Mage, etc) which also automatically sorts by the class field too (i.e. Priests all together and within that, Defiler all together preceeding Templar, etc.).  Lower levels just sort by Priest, Cleric, etc.

---

That's a very interesting idea.  It would be fairly simple to implement. Not sure how useful it'd be, though. What I find is much more handy is this interactive class graph code that I wrote.  You can see the distribution of characters and classes, and when you click on a bar, it brings up a list of the characters.  It is my plan to include this code in a future version of Roster Master.

---

Linkagge wrote:
How about a way to list alts, and who their main charachters are ?

---

---

aiyl wrote:
True, your graph does answer a lot of the questions I'm interested in.  Can you add a total though?  i.e. another bar for Levels 0..50?

---

A Pie Chart for all levels would probably make more sense and is certainly possible.

What would be helpful to me would be for you to explain what you hope to understand or accomplish.  Maybe there is some third way that would give you EXACTLY the information you're looking for, rather than having to work up to it.  My chart is part of a "stats page" which I anticipate adding useful queries to.  There is no practical reason why your specific query couldn't be added to a similar stats page.

However, at this time I'm hesitant to talk about additional features for a portion of code that has not been written yet.  Let me see if I can't get the "Easy" stuff written first, then we can talk about adding other features.

---

thedump wrote:

---

Homeslice wrote:

---

thedump wrote:
This is great! I just saw they added completed quests to the list on SOE as well. I was wondering in anyone knew how properly convert it to be a module in PhpNuke?

---

Just curious where did you see this?

---

Homeslice, if you go the guild roster page now on the SOE page, it has column added for number of quests completed.

---

---

Original Cinadien wrote: I just want to say thank you Peter, your work is appreciated sir. I have been following this since Vertile posted his original code. Can view example integration to postnuke with postwrap mod here www.eq2five-rings.com

---

You're welcome.  I've never seen postwrap, that's pretty amazing!  What a trip, to see my code already in a CMS. I expect that my phpNuke version (coming soon) will be easily adaptable to postNuke - I'll look into what changes need to be made to make it so.

---

Linkagge wrote:

Would it be possible to include support for Phpbb ? It's used just as much, maybe more than invision board is ?

 

BTW Great work, I have done a little coding / tweaking to get the roster to work on my guild's website, if you would like I could Email you the alt/main code that i have already done.

---

phpBB would be no problem at all.  You're right, it's probably more popular than invision.  I'm just responding to the requests I get here.  I spent a bit of time investigating both Invision and phpBB and they both use similar login mechanisims.  Once I get my phpNuke version done I'll work on the CMS-less version.

I would be VERY interested in seeing your code.  I can be reached at rostermaster@bellumaeternus.com. I have a slightly different take on character types, as I don't break them out into a seperate list.

BTW, your integration of the roster looks simply amazing.  Gorgeous, really!  I love the wood panel effect.  I wish I were as good at graphic design/CSS.  I'll be the first to admit I'm a programmer at heart.

SaintPeter..  Just wanted to stop by here and Say excellent work...   this is Laethorn by the way.  Thanks for getting back to me so promptly on my issue.

S.P.

Hopefully I can add my great work comment to this thread soon... I installed and chmod'd the files ran the install and even added a prefix and ran it again.

When I type the rostermaster.php I get the following

Warning: Invalid argument supplied for foreach() in /home/risingd/public_html/roster_master/rostermaster.php on line 165

Any ideas?

---

Kevlin wrote:
Warning: Invalid argument supplied for foreach() in /home/risingd/public_html/roster_master/rostermaster.php on line 165
Error

---

There are two possibilies for this error:
1)  Most likely, your configuration variable in rm_config.php, $config['guild_name'] is not set to EXACTLY your guild name, as it appears on the roster site.
For example, if my Guild name is "Bellum Aeternus" and I typed "bellum Aeternus", I would get this error.

2)  It's possible that your $config['guild_id'] is not set correctly. 
You can find your guild_id at the end of the URL which links to your eq2players.com site.
http://eq2players.station.sony.com/en/guild.vm?guildId=15101

I will ensure that there is a better error message in future versions Stand Alone parser.

Message Edited by SaintPeter on 03-24-2005 12:02 PM

---

SaintPeter wrote:

...

What would be helpful to me would be for you to explain what you hope to understand or accomplish.

...

Let me see if I can't get the "Easy" stuff written first, then we can talk about adding other features.

---

---

Sorvani wrote:
phpNuke a message board or something?

---

phpNuke is a "Content Management System" or CMS.  It is a php based web script that allows you to easily add content, such as news posts, HTML type content, and other features without having to compose them manually.  Most notably, CMSes typically have the capability to quickly add prewritten modules to expand their capabilities.  In this way, you can increase the functionality of your website without having to write any code.  Another handy feature of CMSes is "Themeability" - phpNuke has many hundreds of themes avalible that allow you to put a uniform look and feel across the entire site. 

phpNuke in particular integrates the phpBB message board system into its suite.  It's essentially a "Website in a box".  The downside, of course, is that your site can LOOK like it was a "Website in a box" - too many people roll out a CMS with the default options and don't customize it at all.  This can give a site a fairly generic/cookie-cutter look.

'Nuke has been criticised for being incredibly sloppily written and full of security holes.  I can attest to the slopiness of it, but the security situation has been improving.  The most recent versions are reasonably secure.  There are a large number of 'nuke derivitives, with varying amounts of rewritten and "cleaned up" code.  A notable example is postNuke, although I found little substantial difference between it and phpNuke.

The greatest advantage to phpNuke, for me, is the ease of development.  Say what you will about the carptacular internal code of phpNuke, it's a breeze to develop new modules for.  It uses the phpBB SQL Abstraction Layer (which I leveraged for my Stand Alone version) to expidite portable database operations.  It has some standard theming options which can give you a complete website shell in only a few lines of code.  I have heavily modified my version of 'nuke and written 3-4 complete modules for it.  You can see it here:  www.bellumaeternus.com.  While I was initially hesitant to use nuke because of its bad reputation, I was won over by the AMAZING number of modules for it.  Because it is so ubiqutious, it's easy to find modules and themes for.

No worries, though - I will be rolling out a version of the Stand Alone roster that will use the login information for phpBB and Invision PowerBoard shortly.  Your site looks well put together.

Resources:
http://www.cmsreview.com/ - This site has a HUGE number of demo CMS systems set up for you to play with.  I used this site extensivly when I was first trying to figure out what CMS was right for me.
http://www.phpnuke.org/ - The phpNuke Homepage.  Advanced warning: MANY popups.  Also, don't go to the .com site, it's a "warez" site.

Message Edited by thedump on 03-24-2005 07:05 PM

I emailed you the roster files for my guild's website, and the php / tpl files for what we use to manage forum users and in Game charachters and the alts.

I hope it helps you with the project.

Link =)

Message Edited by Sorvani on 03-27-2005 09:45 PM

---

Sorvani wrote: but i have one question. in the log file, what are you looking for when you insert new data? i basically want to kow so i know how far i can go with adding in stuff to the log file without it busting. granted i'm not adding much. just style, my header images and a return link.

---

So long as the HTML comment "<!-- Insert Log Here -->" is in the logfile.html at the point where the log information should be inserted, you can change any other aspect of the code you'd like.  That comment is replaced by the new text, with the comment prepended (so the next insert will always happen at top).

Note that this only applies to the Stand Alone version of the code.  In the phpNuke version, JUST the update text is stored and is just displayed in a standard 'nuke template.

Message Edited by SaintPeter on 03-27-2005 11:44 PM

SaintPeter.. Thanks for helping me out with my page.. its working great now..

---

Faeandil wrote:
SaintPeter.. Thanks for helping me out with my page.. its working great now..

---

No problem.  Glad to help.

Just a quick overview in case other folks run into the problem -
The symptoms were that the phpNuke version of the Roster was not updating, but it wasn't failing.  The problem turned out to be that when he filled out the configuration file, he had a trailing space at the end of his guild name.  That caused the wrong portion of the guild website to be chopped off, resulting in an apperent no members listed.

I will be putting in code to detect similar errors in the future.

For anyone interested, I created a PHP-Nuke block that pulls member info from roster masters's database (nuke_roster_master) and shows you total members, officers, regular members, trial members, how many fighters, priests, mages and scouts you have, average level of the guild, and average status.

If you want to see it in use, its here, on the bottom left: http://creign.heartofsword.us and you can download it from here: http://creign.heartofsword.us/modules.php?name=Downloads&d_op=getit&lid=1

Btw, excuse the site linked above - its still 'under construction' as I learn more about customizing Nuke.

You'll need to edit the funcs.php file with your DB info, and upload both files into your blocks folder.

Message Edited by Kanoldari on 03-30-2005 07:49 AM

First off I must say bravo and thank you! SaintPeter, you rock!  

He graciously helped me offline to get the roster up-and-running on my site. I was receiving a "failed to open data stream: Permission denied" error when accessing the main page. Come to find out it was an issue with my web host. When accessing an external site in this manner it apparently requires them to add it to a list of "approved" sites. So if any of y'all are getting a similar error, you might want to check to make sure that isn't the problem.

That being said, I have a suggestion and a question. The suggestion is just to second what Belin already mentioned. It would be cool if when you click on the header title it sorts from low to high, and if you click it again that flip-flops and sorts from high to low.

My question falls into the category of "I wish I knew more than I do". I'm interested in having the default page sort in a particular way, and I'm having trouble making it happen. For example:

SELECT * from roster_master order by rank='Guild Leader' DESC, rank='Officer' DESC,  rank='Member' DESC, rank='Initiate' DESC, Adv_Level DESC, Name

How might I translate that query into your lovely code? I presume it has to do with the "Sort Code" section, but I don't seem to know enough about multi-sorting in arrays to make it happen by troubleshooting. Might any of you folks who are more familiar with PHP and MySQL have a suggestion?

Well, you certainly ask the hard questions . . .

Let me give you a little primer on sort code, followed by some speculation on how what you describe could be achived.

My function, 'cmpi', is pretty basic, once you know how a user defined sort function works.
Consider the simplest possible sort function:
function simple_compare($a, $b)  {
       if($a == $b) { return 0; }
       if($a < $b) { return -1; }
       if($a > $b) { return 1; }
}
Or, if you wanted to sort strings:
function string_compare($a, $b)  {
     return strcmp($a, $b);  // Because strcmp already returns -1/0/1
}
There are always only 3 possible outcomes.  However, if you want to increase the number of fields by 1, there are 5 possibilities.
F1 | F2 | Result
<  | x  | -1
>  | x  |  1
=  | <  | -1
=  | >  |  1
=  | =  |  0
Remember what is being passed to the comparison function - two diffrent indexes of the array being sorted.  Looking at my "Row" example above, here are some possible examples of ONE compare (The compare function is called for ALL of the compares that the sort function does.) -
$a = Array("name" => "bob", "Rank" => 1, "Level" => 12); 
$b = Array("name" => "joe", "Rank" => 2, "Level" => 33); 
So, we can compare individual FIELDS of $a and $b with standard notation:
strcmp($a[name], $b[name]);

If you look at my code, it's pretty easy to see what happens - We compare field 1(the name of which is defined in the global varibale "sort_field1") first.  The only time we need to compare field 2 is if Field1.a and Field1.b are EQUAL (IE, the result of the first compare is 0).  In both other cases, it doesn't matter, field 1 is the controlling field and their compare result is returned.  When they are equal, however, and we are sure that the second search field is SET at all, then we can compare Field 2.

I'm going to stop this post here and continue in the next post with how to do something different.

Then there would need to be a change to the decode_sort() function to sort by the non-visable field
case "R":  return "rank_value";  // Change from "Rank", which is actually displayed. 

This is probably MUCH easier than the alternative, creating a specialized sort function, so I won't write code for it.  There are may be good reasons for solving it in that manner, though - This takes up more memory, particularly on long lists.  However, it may never be an issue until you have a 300+ member guild, which is probably a problem in and of itself.

You could also turn the problem on it's head - do the translation when the values are stored and only convert them back when you display.  That has the advantage of taking less database space and memory, but more computational time when you display.

Maybe I've given you WAY more information than you needed to know.  It's been fun for me, and I'll probably include these changes in the next versions of Roster Master, now that I've written them . . .

Again AWESOME program, now is there a way to pull in data like quests completed, max melee and max magic along with other things from the achievements page?

Of course I like the majority have expressed have zero or little experience with PHP so I have no idea how hard it is.

We are using CPG-Nuke Dragonfly and you can see the roster on the left hand side click on Guild Roster.

http://risingdawn.net

---

Kevlin wrote:
Again AWESOME program, now is there a way to pull in data like quests completed, max melee and max magic along with other things from the achievements page.

---

Possible, yes.  By me?  Not something that I'm interested in doing.

I wrote this module with the idea of allowing the average guild to be able to "host" their own guild roster and integrate it into the look and feel of their own website.  I also created it with an eye to expansion by the many talented coders our there who are in charge of their own websites.  It's handy, from a guild management perspective, to have a quick view of your roster.  To that end, I've imported what I consider to be the "essentials" to guild management.  Everything else is gravy.

SaintPeter,

Thank you for this wonderful program and the helpful information!  My guild absolutely loves it on our site.  Now if they would just stop asking me to figure out coding to add stuff to it.

Fey

Message Edited by Aelona on 03-30-2005 06:03 PM

[EDIT]
Nevermind, just figured it out.

Had to replace
if(ereg("([^~]+)~([0-9]+)~([^~]+)~([^~]+)~([0-9]+)~([^~]+)~([0-9]+)~[0-9]+~[0-9]+~([0-9,]+)~([^~]+)", $line, $match))
with
if(ereg("([^~]+)~([0-9]+)~([^~]+)~([^~]+)~([0-9]+)~([^~]+)~([0-9]+)~([0-9,]+)~([0-9,]+)~([0-9,]+)~([^~]+)", $line, $match))

After that adding 2 new fields in my database and alter the sql-insert a bit.

Again: Great piece of work and coding

Message Edited by Vindicare on 03-30-2005 11:30 PM