Add-On Releases - vbRosterMaster

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

[pedigree]

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

[Sarcoth]

Originally Posted by Abhean

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.

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

Touch?

[redtailboa]

ran into these errors today

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

[pedigree]

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

[redtailboa]

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

No roster data has been found in the database

[pedigree]

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)

[pedigree]

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

[SuprSurfr]

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:

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?

[pedigree]

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?

[SuprSurfr]

Originally Posted by pedigree

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?

I found my biggest problem in my php.ini

; 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:

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