"Roster Master" - Guild Roster for Your Personal Guild Website

[Caela]

Well, not sure what is going on.

 Edited the new config file and uploaded it - still would not upgrade.

 Deleted the Roster_Master directory entirely and uploaded 6.0.5 again.

 Still could not do the upgrade.

 However, it appears to be working - HOF bug fixed, etc. 

 Admin Modules shows we are using 5.14...

[Dark_Grue]

Caela wrote:

Well, not sure what is going on.

 Edited the new config file and uploaded it - still would not upgrade.

 Deleted the Roster_Master directory entirely and uploaded 6.0.5 again.

 Still could not do the upgrade.

 However, it appears to be working - HOF bug fixed, etc. 

 Admin Modules shows we are using 5.14...

I don't think the config.inc file will cause interactions in an upgrade - the upgrade code is running out of the cpg_inst.php file, which is run/interpreted by the Dragonfly core.

 What is happening is something is failing inside of the upgrader code - either because you're doing something I didn't anticipate, or your DB has something funny going on. I'd need the detailed error message so see what it is. I believe the SQL statement that failed would appear at the bottom of the page.

Because the upgrade failed, it wouldn't update the version number in the Dragonfly module table, but it is very likely that your Roster Master tables are now in an indeterminate state (because some of the upgrade SQL probably ran, but not all). Not sure why you're running into problems, since no one's (yet) come forward with upgrader problems. Worst case, I can diagnose your tables if you send me a copy of the Roster Master tables by e-mail. But let's see first if you can get a hold of the SQL statement that's causing the error.

[Seagoat]

I think Grue may be right, Caela.  :-/

My recommended action:

-  Print out your claims page (the "Manage Roster" admin link), or save a copy somewhere that you can reference later. (Edited to add that you should do this for your HQ and Access quest claims too.)

-  Uninstall the Roster Master module from your Dragonfly Modules admin page.

-  Delete all the existing Roster Master files (/modules, /language, and /blocks directories) from the server.

-  Upload the 6.0.5 files, making sure that config.inc contains the correct values for your guild.

-  Install 6.0.5 from the DF Modules admin page.

-  Once the installation is complete, go back to your "Manage Roster" page and manually reenter all of your guildmates' claims.

If for some reason the installation has problems again this time, copy and paste the error message you're getting here so we can help troubleshoot it. 

[Caela]

Sorry to take so long to get back...

Here is the exact error message I get when trying to upgrade:

includes/db/db.php

• CMS Warning line 51: On /cms/admin.php?op=modules&upgrade=16 While executing query "ALTER TABLE dfly_roster_master_users CHANGE Char_ID characterId INT NOT NULL" the following error occured: Unknown column 'Char_ID' in 'dfly_roster_master_users' In: /home/aovguild/public_html/cms/modules/Roster_Master/cpg_inst.php(343) : eval()'d code on line: 245

[Seagoat]

Caela, I had this exact problem a while back...check out this post (third section), and in the next post.    If you have any questions, please let me know...

[Lantis]

Greetings, I have completed the ring event, killing a whole slew of bugs, quirks and albinos ninjas armed with wheellock pistols, and this is what dropped: RosterMaster Stand Alone 2.2.0 Mainly a maintenance and optimization release, with no new feature. Changes in 2.2.0:

• IMPROVED: Improved performance when there's a cache update (we now display the parsed data instead of reloading it from the cache that we just saved)
• IMPROVED: Various code optimization in parsing and display code aimed at improving performance for larger guilds.
• FIXED: XML-less parsing was still using XML.
• FIXED: XML-less parsing wasn't properly updating the database entries.
• FIXED: Feature test in the configuration module would list XML as required when it is now optional.
• FIXED: No longer attempt to update the flatfile if there's nothing to update due to a parsing failure.
• FIXED: After using a header click sort, there was no second column sort order set in the advanced sort block. Now properly defaults to same sort as for the first column.

Project webpage is here. View the demo here. Download it here. Comments, questions and bug reports: here.

[Seagoat]

Lantis@Antonia Bayle wrote:

I have completed the ring event, killing a whole slew of bugs, quirks and albinos ninjas armed with wheellock pistols, and this is what dropped: RosterMaster Stand Alone 2.2.0

LOL

The OP has been updated. 

[Malloc]

Is there a way to change the background color for the pie charts?  Doesn't look quite right using the light.css

[Lantis]

Hi, Piecharts are transparent PNGs.  They will only properly display with fully compliant browsers, which means IE7, Firefox (any version) and Opera (any version) for instance.  IE5-IE6 have a bug that prevents them from properly displaying transparent PNGs.  The same issue applies to the avatar icons - transparency only works with compliant browsers. The default background colour that shows when the browser fails to display transparency for piecharts can be changed inside piechart.png: --- $trans = imagecolorallocate($img,1,1,1); ImageColorTransparent($img,$trans); ImageFill($img, 0, 0, colorHex($img, "010101"); --- Change the (1,1,1) and (010101) by (255,255,255) and ("FFFFFF" to use a white background.  You can also use any other RGB colour that you wish there. I'll see about implementing some basic logic where the transparent colour will always be the RGB opposite of the text colour, to at least provide proper contrast.  But the real fix is, unfortunately, for people to stop using broken browsers. Edit: the reason why I used 010101 instead of 000000 is to handle the situation where someone would use 000000 for text colour - I don't want the background AND the text to end up transparent.  So, you might also want to use FEFEFE (and 254,254,254) here.

[Malloc]

Thanks a bunch Lantis.

[Dark_Grue]

Seagoat wrote:

Lantis@Antonia Bayle wrote:

I have completed the ring event, killing a whole slew of bugs, quirks and albinos ninjas armed with wheellock pistols, and this is what dropped: RosterMaster Stand Alone 2.2.0

LOL

Hey! I started that whole funny-saying-before-the-release-notes thing, and I don't get teh LOLs! I even busted out the Mothra and everything... /grumble

If imitation is the sincerest form of flattery, is litigation the same, but for envy? My lawyers will be in touch!

Besides, everyone knows that pirates can kick ninja's [Removed for Content], even albino ones.

[Seagoat]

Aww, c'mon...my "LOL"s at your jokes are always implied, Grue!    The Mothra joke did invoke strange mental images of the Mothra Fairies, though, and that creepy little song.  I was chuckling about that one for a couple of days, trust me!

ITA on the pirates.  If Lantis won a battle vs. albino ninjas, does that mean he's a pirate too?! 

[Lantis]

Back when I was developing software for the AmigaOS platform, I would usually leave one easter egg in almost every  program I developed.  My favorite one would, when pressing the correct key sequence, display a window stating: "I'd like to change the world, but they won't give me the source code" Good times... And finally... more food for thought here for you:  how comes a (pirate) chest dropped off ninjas?

[Dark_Grue]

Seagoat wrote:

ITA on the pirates.  If Lantis won a battle vs. albino ninjas, does that mean he's a pirate too?! 

Hmmn, Lantis being a pirate is a chilling thought, but when forced under the keen edge of Occam's Razor, I think we can bring him to heel: not all who defeat ninjas are pirates.

Of course, should that logic fail, we know how to deal with pirates:

 

I too, leave easter eggs in my software. But, for some reason, people keep mis-identifying them as bugs! Imagine! It just goe to show how The Man is crushing the creative spirit of we poor, benighted, Open Source authors...

Lantis@Antonia Bayle wrote:

And finally... more food for thought here for you:  how comes a (pirate) chest dropped off ninjas?

There was no pirate chest introduced in the discovery phase, your honor! Furthermore, the arbitrary labeling of a chest in the possession of a ninja is, by definition, ninja lewts!

Ladies and gentlemen of the jury, Lantis would have you believe that ninjas can take pirate lewts. And they make a good case. Hell, I almost felt pity myself! But, ladies and gentlemen of this supposed jury, I have one final thing I want you to consider. Ladies and gentlemen, this is Chewbacca. Chewbacca is a Wookiee from the planet Kashyyyk. But Chewbacca lives on the planet Endor. Now think about it; that does not make sense!

[Seagoat]

OMG!!  It's the Chewbacca Defense!  Everybody RUN!!

Someone, please save us from ourselves...throw us a project update or something, before things get really hairy.  And when I say really hairy, I mean harrier-than-Chewbacca-hairy, which is pretty [Removed for Content]' hairy.

[Lantis]

Oh noes!  He's using the Chewbacca defense!  Your honor, we'd like to change our plea to 'guilty'. Project update...  Hm...  Not much for me lately, just some code in the piechart generation code to ensure better contrast between background and text colour for broken browsers.  And some experiment with short scripts that will pull data from the database, and output simple stats from it.  Mostly of interest to use on portals, as a sidebar block. I'm also in touch with someone making a vBulletin port of RMSA.  Yay for another head to the RosterMaster hydra! Otherwise, the last big feature that was on my ToDO list was implemented in 2.1.0 (the charts).  Time for a well-earned break I guess. How about you Grue?

[Dark_Grue]

Lantis@Antonia Bayle wrote:

Time for a well-earned break I guess. How about you Grue?

I'm taking a break as well while new ideas percolate. It took a long while to get v6 stable, and after having to rapid-fire 5 point patches out... probably a good idea to enjoy the stable version, sit back, do some other things for a bit and recharge.

I think the next big feature will be a re-write of the quest trackers. I'm probably going to unify them into one module and restructure the quest arrays into one big structure that can handle multiple quest types (and multiple steps in a single series). I haven't started on that because I look like a raccoon with these rings under my eyes already.

I see you've added graphing. I must tip my hat to you, I did something similar when I wrote QstatList (I wish I had screenshots of it running now, it really was pretty impressive... alas). Was a unique feature at the time, and very interesting to do. Got to learn a lot more about the [Removed for Content] library and Perl as a result. I don't know I'd backport the feature into RM4DF (if people insisted on it, I guess). But I bet it was fun, challenging, and interesting to do.

[Lantis]

Dark_Grue wrote:

I see you've added graphing. I must tip my hat to you, I did something similar when I wrote QstatList (I wish I had screenshots of it running now, it really was pretty impressive... alas). Was a unique feature at the time, and very interesting to do. Got to learn a lot more about the [Removed for Content] library and Perl as a result. I don't know I'd backport the feature into RM4DF (if people insisted on it, I guess). But I bet it was fun, challenging, and interesting to do.

Actually I went the easy way - I found an open source PHP script that would take a list of names and values as argument, and output a piechart out of it.  The original script would output JPEGs - I modified it a bit to output transparent PNGs instead.  It was pretty much an evening or two of work there, the longest was having to write the code to support data pulling from both the database and the flatfile. The whole RMSA project has been a learning experience for me - my previous PHP experience could be summed up in about 20 lines of code for my old website's menu.  And RMSA was also my first steps into working with SQL databases.  So I'd say the whole RMSA project has been fun, challenging and interesting to do.

[Shaister]

Hi & congratulations on a great addition to any EQ2 website, very easy to use & simple to set up. Well, it was simple when I set it up on a test server (I use DragonflyCMS & the RosterMaster module for it) but I have a bit of a problem that I just can't seem to figure out as to why it's happening on the main site we're putting together but not my test server. Anyway, the problem is this... When I set it up on my test server all went perfect, I could get the blocks on the left & right to display perfectly etc etc but on the main server we installed DragonflyCMS, no issues there, then installed Rostermaster for Dragonfly, all seemed fine except that we can't get the blocks to display on the left side (yes, we have played with the setting for the module in the admin panel lol). You can take a look to see what I mean by going to http://www.teutonic-knights.net/ind...er_Master  all other pages dispaly the modules correctly. I would post any other info but not sure what else you would need so if i can help any further I would be more than happy to. Any ideas on what may be causing my dilemma??? Many thanks in advance Shaister

[Silverpaws]

Thanks for the updated stand alone. I was wondering what I needed to do to add the quest column.  I dont know php/sql very much, so be gentle.

[Lantis]

Denuve@Mistmoore wrote:

Thanks for the updated stand alone. I was wondering what I needed to do to add the quest column.  I dont know php/sql very much, so be gentle.

Log in into the Configuration module, select 'Edit Configuration'. Under the 'Display Settings' section edit the "List of columns to display" entry.  Insert 'quests' where you want the Quests column to display.  Save settings, then return to the roster.

[Dark_Grue]

Shaister@Runnyeye wrote:

Anyway, the problem is this... When I set it up on my test server all went perfect, I could get the blocks on the left & right to display perfectly etc etc but on the main server we installed DragonflyCMS, no issues there, then installed Rostermaster for Dragonfly, all seemed fine except that we can't get the blocks to display on the left side (yes, we have played with the setting for the module in the admin panel lol). You can take a look to see what I mean by going to http://www.teutonic-knights.net/ind...er_Master  all other pages dispaly the modules correctly.

It's a side-effect of the new way blocks are handled/displayed. It's a Dragonfly feature, not an issue with Roster Master. It's just that the DF feature is a little counter-intuitive. And, at one point, there was also a bug in the way new blocks were displayed.

Go into the DF Admin console, then go to Blocks Administration. Edit the blocks you want to appear. You'll see a listing of modules where this block should appear in a multi-select list. Highlight the modules where you want the block to appear and save the changes. I'd bet good money that Roster Master isn't currently selected for any of your blocks, and that's why none are displayed.

I believe there's also a setting in Module Administration on a per-module basis that says display blocks left, right, both, none that also needs to be set appropriately (though I believe the default is "both&quot.

I don't have my admin panel in front of me, so I'm describing from memory...

[Shaister]

WOW!!!! Fantastic, thanks Dark_Grue, it worked perfectly, you have a great memory. I'm very happy now, your module is a "must have".

[Dyse]

    Just checking in.  Things are still working great.  Although I still can't 'Upgrade' it works fine on 6.0.5.

 Question,  does the 'Block' module  Update on the 24 hour or just when someone enters the Module?  Just wondering why sometimes it takes forever and a day for our site to come up. (Generally once per day)

  www.eq2daggers.com

--Edit:  yeah, I know the Banner went back to DF's... but upgraded to the 9.2.2.1.2.3.2. or whatever.  I'm just to lazy to pull a backup of the logo

[Dark_Grue]

Dyse wrote:

    Just checking in.  Things are still working great.  Although I still can't 'Upgrade' it works fine on 6.0.5.

Probably a corrupted database schema. You'd have to look at the error to find out what the upgrader's choking on. You could then fix the schema by hand and then set the version manually. If you don't, you're going to be unable to upgrade to later version of RM4DF, because *that* upgrader won't run properly either. And the next big version of RM4DF will probably end up merging the keys and access quests tables...

Dyse wrote:

 Question,  does the 'Block' module  Update on the 24 hour or just when someone enters the Module?  Just wondering why sometimes it takes forever and a day for our site to come up. (Generally once per day)

Err, from memory: the block updates itself from the local Roster Master tables based upon whether the tables were updated since the last time the block was run (I think, may not have done that real well). The Roster Master tables aren't updated until someone actually visits the module (regardless of whether it's the roster, key, or access quest tables).

I don't think the block currently can force a roster update itself. I was looking into doing that at one point, and either I decided it was too messy at the time, or (more likely) I got sidetracked and forgot.

[VulcanDarksoul]

I hate to hijack, but i know some folks that use GEM frequent this topic. I am back to coding and taking suggestions. Same site as always, www.eq2caladrius.com. Direct link to most recent forum topic on GEM. Download the latest non-beta release.

[Seagoat]

Thanks for the update, Vulcan!  I'm heading there to check it out now. 

[_Quebecker_]

Hi first let me say Roster master is great.

I m using it with Dragonfly. I have a problem. I created a new guild, and roster master wont parse any data on the characters that were in the guild before it got to level 5 and showed up on eq2players... it parses data just fine for all other characters.

Been looking into it for days... can't figure it out.

 site url : http://pantheon.ulmb.com

[Seagoat]

_Quebecker_ wrote:

Hi first let me say Roster master is great.

I m using it with Dragonfly. I have a problem. I created a new guild, and roster master wont parse any data on the characters that were in the guild before it got to level 5 and showed up on eq2players... it parses data just fine for all other characters.

Been looking into it for days... can't figure it out.

 site url : http://pantheon.ulmb.com

We'd love to help; can you provide us with a little more info?

• Please post the contents of your config.inc file here.
• Let us know which version of RM4DF you're using.
• Copy & paste the error messages you're seeing at the very bottom of the roster page when you're logged in as admin, if there are any.
• Did you change any of the files besides config.inc before installing the module?

Thanks in advance. 

[_Quebecker_]

config.inc :

// *************************** Setup Options *************************** // guild_id:   Set this to the guild id of your guild on the eq2players.com site. It //    can be found in the URL. //    i.e. http://eq2players.station.sony.com/...guildId=1013203 $config['guild_id'] = 4372120;

// guild_name:   Your Guild name, exactly as it appears on the eq2players.com site. $config['guild_name'] = 'Pantheon';

// lookup_rank:   Translates the Guild Rank terms for use in sorting. //    Based on the default rank names - if your guild changes the default rank //    names, this MUST be updated to reflect that or rank sorts will not be in //    heirarchical order. $config['lookup_rank'] = array(  'Leader' => 1,  'Senior Officer' => 2,  'Officer' => 3,  'Senior Member' => 4,  'Member' => 5,  'Junior Member' => 6,  'Initiate' => 7,  'Alts' => 8);

// officers:   Defines Guild Ranks that are officers. //    Based on the default rank names - if your guild changes the default rank //    names, this MUST be updated to reflect changes and correspond to the //    $config['lookup_rank'] settings, above. $config['officers'] = array(  'Leader',  'Senior Officer',  'Officer');

// popup:   1 - Open external links in a new window. (Default) //    0 - Open external links in the same window. $config['popup'] = 1;

didn't change anything in the rest of the file...

I get no error message at all

 The site is hosted on a public server, how do I get the version of that?