vb.org Archive - Add-On Releases

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Add-On Releases - vbRosterMaster (https://vborg.vbsupport.ru/showthread.php?t=149275)

A mod that displays your Everqeust II guild roster.

This is a port of the Stand Alone version by Eric Sauvageau (and therefore isnt all my code) There was PHP template code in there and Ive changed a lot of it into vBulletin templates but some still exists. It was faster to leave it in php but I might change it a later version.

Changes
Plugin / Hook : 3
Templates : 12

If you use it, PLEASE click Installed. This is my first ever released mod. If you find a bug or have a suggestion, please post it, I want to make people use it and like it.

10 Nov 2007 - Updated a page to fix the missing navbar, school boy error, sorry, just extract the files in rostermaster_navbar_fix.zip, overwritting the existing one

Troubleshooting

If you follow all the instructions and your roster wont update.
- Turn off CURL support in the admin settings. Its enabled by default and it seems that a lot of PHP hosts dont support it. Will be fixed in the next version of the code

First post, reserved for future use, give me a couple of minutes to get it uploaded

Interesting. Looks neat. Never did get into those games. You should have the usernames marked up they look too plane with everythng else being flashy. Keep up the good work

Pedigree, post your info here on the EQ2 Rostermaster board so they can see your work.

Thanks for working on this!

Quote:

Originally Posted by rjmjr69 (Post 1264680)

Interesting. Looks neat. Never did get into those games. You should have the usernames marked up they look too plane with everythng else being flashy. Keep up the good work

Usernames marked up? A bit better looking, maybe in bold perhaps? Is that what you mean. Ill add that to the new version though, good idea, thanks :)

Quote:

Originally Posted by pedigree (Post 1264788)

Usernames marked up? A bit better looking, maybe in bold perhaps? Is that what you mean. Ill add that to the new version though, good idea, thanks :)

Coming as an actual player of the game , I would disagree with using markup on the usernames. I might just hide them from all but admins. Typically you will find that people who play these games use their forum name and game name as the same..

Linking forum userid to the character(s) is brilliant though. You now have a game data->forum data link and allows for all kinds of neat tricks on the postbit I am thrilled with this mod, kudos
pedigree

Installed here btw http://www.eq2trinitas.com/forum/rostermaster.php?

edit;

what table do you store userid -> character ids in ?

table_prefix . "_roster_master"

thanks, I tried :)
the problem with postbits that I found on the last autoimport roster code I wrote is that no one fulls them in properly, sounds familiar?? :) If you claim a toon, there is a JOINable way to get a forum account/game ID linked

This is definitely a great port, my members are already loving it. Thanks again.

Quote:

Originally Posted by pedigree (Post 1264788)

Usernames marked up? A bit better looking, maybe in bold perhaps? Is that what you mean. Ill add that to the new version though, good idea, thanks :)

Yes exactly what I was getting at. Keep up the good work.

I love the roster! However I am running a guild that s going to be for Warhammer Online and as they do not have a automatic download for their characters is there any way you can set t up that I or the members on the forums can enter their own information?

Also it would be nice if there were a few more fields such as race.

I guess what I am looking for is a more generic version as there would be alot more guilds picking this up to use it.

Firstly, thanks :)

Secondly, its all built around importing data so a "generic" version would be better done in HTML or as a template without all the import code :(

Race, well, Im sure that cant be too hard to add :)

Quote:

Originally Posted by Abhean (Post 1266934)

Abhean, check out Customizable Roster (Member List). That should work for you.

Touch?

ran into these errors today

Quote:

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE clawusergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '180',
`passwordhistory` = '360',
`forumpermissions` = '1048575',
`genericpermissions` = '1040187327',
`attachlimit` = '0',
`pmquota` = '300',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericoptions` = '63',
`profilepicmaxwidth` = '200',
`profilepicmaxheight` = '200',
`profilepicmaxsize` = '655350',
`avatarmaxwidth` = '200',
`avatarmaxheight` = '150',
`avatarmaxsize` = '307200',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '150',
`sigpicmaxsize` = '60000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`photoplogpermissions` = '32767',
`photoplogmaxfilesize` = '512000',
`photoplogmaxfilelimit` = '100',
`infernopermissions` = '0',
`showrosteraccesspermissions` = '0',
`showrosterviewpermissions` = '0',
`rostermastermanagepermissions` = '1',
`rostermasterviewpermissions` = '1',
`rostermasterclaimpermissions` = '1',
`rostermasterviewlogpermissions` = '1'
WHERE usergroupid=6;

MySQL Error : Unknown column 'infernopermissions' in 'field list'
Error Number : 1054
Date : Wednesday, June 20th 2007 @ 07:54:46 PM
Script : http://xxxx.org/forums/admincp/usergroup.php?do=update
Referrer : http://xxxx.org/forums/admincp/userg...&usergroupid=6
IP Address :
Username :
Classname : vb_database

Hmm, I found one bug in the code, only obvious when you have cookies disabled but I havent seen this one.

infernopermissions isnt a row that vbRostermaster adds, its RPG inferno and it seems to be a known issue

https://vborg.vbsupport.ru/showthrea...=103792&page=5

ok cleared out all the inferno stuff.

I reinstalled and ran the task now when i go to \forums\rostermaster.php

i get this error.. its as if it didnt pull anything from the sony website

Quote:

No roster data has been found in the database

I suggest you read the documentation when you install something next time. Thats not an error, its a notification that you dont have any data imported. You need to run a scheduled task to import the database

4 - Run the Scheduled Task once to populate the database with your guilds information. The task will run once per hour afterwards.
(AdminCP -> Scheduled Task Manager -> RosterMasterUpdate -> Run Now)

Ive got a new version of the code that Im going to work on that displays by group, either rank, class or crafting goon.

I am not sure what I did wrong...
I am using PHP Version 5.2.3 and mysql 5.0.41

When I try and run the scheduled task to populate the database I get the following error:

Code:

RosterMasterUpdater 



db)) { exit; } //require_once(DIR . '/includes/rostermaster/logging.php'); function error_message($message, $sql="") { //todo vbulletin log error echo "

" ."

Roster Master Error



" ."Error:

" ."$message



"; // Show's over. exit; } // FUNCTION: rm_prune_log() // Delete log entries older than specified number of days. // Arguments: $days - Maximum age (in days) to keep // Returns: None. function rm_prune_log($days) { global $vbulletin; $cutoff = (time() - ($days * 60 * 60 * 24)); $query = "DELETE FROM " . TABLE_PREFIX . "roster_master_log " ."WHERE date < $cutoff"; if(!($result = $vbulletin->db->query($query))) { error_message('rostermaster_unable_to_prune_database',$query); } } function add_to_log($type, $message, $level=1) { global $vbulletin; if ($level <= $vbulletin->options['rostermaster_logging_verbosity']) { $query = "INSERT INTO " . TABLE_PREFIX . "roster_master_log " ."(date, type, message, level) " ."VALUES (" .time().",'$type','".addSlashes($message)."', $level)"; } } // *********************************XML Parser ***************************************** function startElement($parser, $name, $attr) { global $member, $currentElement, $row; if ($name == 'member') { $member = TRUE; $row = array(); } // name and level are sub-elements of characterclass/artisanclass. // If we were handling something involving char/artisanclass, we modify the element // name to discern wether we're working on the name or the level sub-elements. $matches = array(); if ($member && preg_match('/^(characterclass|artisanclass)/', $currentElement, $matches)) { $currentElement = $matches[1].'<'.$name; } else { $currentElement = $name; } } function characterData($parser, $data) { global $member, $currentElement, $row; if ($member) { $data = trim($data); switch ($currentElement) { case 'link': $field = 'Char_id'; break; case 'name': $field = 'Name'; break; case 'lastname': $field = 'Lastname'; break; case 'rank': $field = 'Rank'; break; case 'characterclass~\\1~<",$row[$field]); } } } } function endElement($parser, $name) { global $member, $currentElement, $row, $rm_roster_data, $vbulletin; switch ($name) { // We were working on sub-elements of either of these case 'characterclass': case 'artisanclass': $currentElement = ''; break; // We just finished processing a member. case 'member': // We have everything expected to form a full member - processing it if (count($row) == 14) { // Convert date to timestamp. if ($row['Joined']) { $row['Joined'] = strtotime($row['Joined']); } // Clean up numbers, so they can be easily sorted. // We can reformat at display time if needed. $row['Quests'] = str_replace(',', '', $row['Quests']); // $row['KVD'] = floatval($row['KVD']); $row['Points'] = str_replace(',', '', $row['Points']); // $row['highestmeleehit'] = intval($row['highestmeleehit']); // $row['highestmagichit'] = intval($row['highestmagichit']); $row['rank_value'] = (!empty($rmconfig['lookup_rank'][$row['Rank']])) ? $rmconfig['lookup_rank'][$row['Rank']] : 99; // Create a rank_value based on the lookup // Store element data in global array. $rm_roster_data[$row['Name']] = $row; // Reset for next member element. $member = FALSE; } else { $GLOBALS['badlines']++; } break; } } // Function: fetch_URL() // Retrieve the requested webpage and returns it // Arguments: $url_fetch = the url of the desired webpage // // Return: The content of the retrieved URL, or NULL if an error occured. function fetch_URL($url_fetch) { global $vbulletin; if ($vbulletin->options['rostermaster_curluse']) { $cUrl = curl_init(); curl_setopt($cUrl, CURLOPT_URL, $url_fetch); curl_setopt($cUrl, CURLOPT_RETURNTRANSFER, 1); curl_setopt($cUrl, CURLOPT_TIMEOUT, '30'); if (($vbulletin->options['rostermaster_curlip']) && ($vbulletin->options['rostermaster_curlport'])) { curl_setopt($cUrl, CURLOPT_PROXY, "{$vbulletin->options['rostermaster_curlip']}:{$vbulletin->options['rostermaster_curlport']}"); } $pageContent = curl_exec($cUrl); // If there was an error, close the handle and report error message. if (curl_errno($cUrl)) { // Build error message before closing handle and exiting to the error display function. $errormsg = "(CURL) Error ".curl_errno($cUrl).": ".curl_error($cUrl)."



\n" ."Cannot retrieve data from the EQ2Players website!"; curl_close($cUrl); add_to_log("Error",$errormsg,1); return NULL; } curl_close($cUrl); } else { if (!($pageContent = file_get_contents($url_fetch))) { add_to_log("Error","Cannot retrieve data from the EQ2Players website!",1); } } return $pageContent; } // Function: parse_guild_HTML() // Retrieves and parses the HTML guild summary page from the EQ2players.com site. // Arguments: &$log = pointer to the log array (used by the flatfile log) // $url = URL of the Guild Summary page on EQ2Players.com // Returns: TRUE on success. function parse_guild_HTML(&$log, $url) { global $vbulletin, $mod_dirname,$rm_roster_data,$rm_summary_data; // Fetch and parse the guild summary page. $i = 0; $rlimit = 1; do { if ($raw_data = fetch_URL($url)) { // Got the data, bail out of the loop. break; } $stime = pow(3, $i++); if ($i < $rlimit) { // Sleep for 3^n seconds... sleep($stime); } } while ($i < $rlimit); if (empty($raw_data)) { // Unable to read the URL as presented add_to_log("Error","Unable to access EQ2Players for HTML parsing!",1); return FALSE; } // Verify that the configured guild name is found on the webpage. if (strpos($raw_data, $vbulletin->options['rostermaster_guild_name']) === FALSE) { error_message(''.sprintf('(XML) '._ERR_GRGNSC, $vbulletin->options['rostermaster_guild_name'])."

I couldnt post the entire output, if you need more let me know.
any suggestions?

Whats the guild ID and guild name? Ill get a box installed with those mysql/php versions and try an import. If ti all goes well my end, Ill add some more debug code to the updater and see just whats going on? What path do you have the forum installed into? / or /forums?

Quote:

Originally Posted by pedigree (Post 1280449)

I found my biggest problem in my php.ini

Code:

; Allow the <? tag.  Otherwise, only <?php and <script> tags are recognized.

; NOTE: Using short tags should be avoided when developing applications or

; libraries that are meant for redistribution, or deployment on PHP

; servers which are not under your control, because short tags may not

; be supported on the target server. For portable, redistributable code,

; be sure not to use short tags.

short_open_tag = Off

I turned it on.

But i am still having an issue, i get the following error:

Code:

Database error in vBulletin 3.6.7:



Invalid SQL:

SELECT rmu.username username, rmu.char_type char_type, rm.* FROM roster_master rm LEFT JOIN roster_master_users rmu ON rm.Name LIKE rmu.char_name WHERE 1;;



MySQL Error  : Table 'koc.roster_master' doesn't exist

Error Number : 1146

Date         : Sunday, July 1st 2007 @ 12:21:12 PM

Script       : http://www.knightsofthecataclysm.com/admincp/cronadmin.php?do=runcron&cronid=19

Referrer     : http://www.knightsofthecataclysm.com/admincp/index.php

IP Address   : 71.205.116.184

Username     : Lupe

Classname    : vB_Database

Well sorry for the confusion...

It appears that after I changed the PHP.ini to allow short tags, I uninstalled the product reinstalled and the tables were then created in the DB. Problem solved.

Thanks!

Good, I was scratching my head for a minute there until I woke up this morning and though "oh, short tags". What Ill do in the next version is replace all the short tags with <?php long tags.

Did you click installed??? :)

how can I change the color of the cell padding? I would like it darker

Can you post a screenshot of the area as an example? The cell padding is all taken from your skin style but it can be editted in the PHP file or template. PM me your URL and I can have a look

Quote:

Originally Posted by pedigree (Post 1297290)

Can you post a screenshot of the area as an example? The cell padding is all taken from your skin style but it can be editted in the PHP file or template. PM me your URL and I can have a look

I'll post a pic....

http://img517.imageshack.us/img517/2483/image2bt8.jpg
I want to change the white bars, to something darker to match my style.

also I noticed the roster page wasn't updating, so I ran it under scheduled tasks and got this error:

Quote:

Fatal error: Call to undefined function: sql_query() in forums/includes/cron/rostermaster_import.php on line 760

Yeah, I found that one. Edit the PHP file and, on line 760, change sql_query to just query. Ive uploaded the fix for that just now

Ill dig around in the mod tonight for you.

Two ways of doing it, both in the same template

Edit template RosterMaster / rostermaster

search for

HTML Code:

<table class="tborder" style="border-collapse:collapse" cellpadding="$stylevar[cellpadding]" cellspacing="0" border="1" width="100%" align="center">

#1 Remove borders

Change the

HTML Code:

border="1"

HTML Code:

border="0"

#2 - Edit the style for the table

Change

HTML Code:

style="border-collapse:collapse"

HTML Code:

style="border-collapse:collapse; border-color: black;"

Quote:

Originally Posted by pedigree (Post 1299367)

Yeah, I found that one. Edit the PHP file and, on line 760, change sql_query to just query. Ive uploaded the fix for that just now

Ill dig around in the mod tonight for you.

that worked perfect, thank you.... I'll work on those edits later tonight and report back. Thank you for your help.

EDIT***

Ok I just tried to change the border color, and its not working... I tried "black" and "#000000" but it still stays white =\

uhh no files uploaded?

its in the zip file in the first post of the thread. Its the includes/cron file.

I HATE IE, its the most god awful non-compliant crap out there but some people still use it (I dont care, I dont code for it) .

If your borders are some colour you didnt expect, its because of IE.

Edit rostermaster.php

Find line 524(ish) and replace it with this

HTML Code:

        if($vbulletin->options['rostermaster_char_mapping'])  {

            $columns_array['username'] = "<td style=\"border-color:black;\">{$line['username']}</td>";

            $columns_array['type'] = "<td style=\"border-color:black;\">{$line['char_type']}</td>";

        }



        $columns_array['name']       = "<td style=\"border-color:black;text-align: center\"><a href=\"http://eq2players.station.sony.com/en/characters/character_profile.vm?characterId={$line['Char_id']}\"$target>{$line['Name']}$tmplastname</a></td>";

        $columns_array['rank']       = "<td style=\"border-color:black;border-right: none; width: " . $vbulletin->options['rostermaster_rankwidth'] . "px \">" . $imagerank . "</td><td style=\"border-color:black;border-left: none; text-align: left\">{$line['Rank']}</td>";

        $columns_array['advclass']   = "<td style=\"border-color:black;border-right: none; width: " . $vbulletin->options['rostermaster_advwidth']. "px \">" . $classimagename . "</td><td style=\"border-color:black;border-left: none; text-align: center\">{$line['Adv_Class']}$classlevelsep({$line['Adv_Level']})</td>";

        $columns_array['tradeclass'] = "<td style=\"border-color:black;border-right: none; width: " . $vbulletin->options['rostermaster_artisanwidth']. "px \">" . $artisanimagename . "</td><td style=\"border-color:black;border-left: none; text-align: center\">{$line['Art_Class']}$classlevelsep({$line['Art_Level']})</td>";

        $columns_array['status']     = "<td style=\"border-color:black;\" align=\"right\">$formattedstatus</td>";

        $columns_array['quests']     = "<td style=\"border-color:black;\" align=\"right\">$formattedquests</td>";

        $columns_array['joined']     = "<td style=\"border-color:black;text-align: center\">".vbdate($vbulletin->options['dateformat'], $line['Joined'], 1)."</td>";

replacing black in the style with whatever colour you want, either if its a default web colour, by using black, white, lightgrey, orange etc or by using a hexcode #338899 etc.

If you must have IE, maybe just use the borders="0" fix, its easier and looks much better

Quote:

Originally Posted by Jargs (Post 1301100)

uhh no files uploaded?

Oh, hmmm, weird, I attached it but Ive uploaded it again now.

Since this is using vbulletin, is it possible to allow other users to create a roster page for themselves? Instead of just one standalone?

Not with this, if they want to create their own roster (no idea what they would have in it), then youll need to use something else.

Great mod, but for some reason it totally ignores my $navbar (which is by default on top of pretty much every vB template and also on top of the rostermaster templates).

So the roster page is kinda cut off the rest of the forum...

Hmm, Ill look at the template code and see why its doing that.

Not sure if that helps, but I might add that after a fresh install with unpopulated DBs (as long as it says "No roster data has been found in the database") the $navbar works just fine.

But as soon as I run the cronjob to pull the data, the $navbar just disappears...
(The actual roster script works perfectly fine, though.)

[edit] Clicked on the link to the Trinitas board in this thread, and seems like they got the same issue - missing vB navbar on top.

Quote:

Originally Posted by pedigree (Post 1275695)

Hey, I have the same problem, but I did all this and it still says empty.

Any ideas?

Great work btw :

Alli

Have you put a correct guild id in the admin section?

Ive just finished my current project but Ill get on this one over the weekend.

Whats the guild ID youre using? Ill use that for testing the code

http://eq2players.station.sony.com/g...uildId=2025303

Took this guild id and the name hmm

Gimme a shout when youre online :)

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01937 seconds Memory Usage 1,882KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (6)bbcode_html_printable (12)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: