Again I can't speak for foxy. He hasn't really asked for my help. But I hope he doesn't mind me doing so. I see this addon having wonderful potential. But there is lots of work to be done. I'm just hoping to lighten that load just a bit.

Foxy wrote:This is going to sound silly but can someone post me the functions.php, I over wrote mine with a test script before I backed it up:-P

Code: Select all

SQL Queries 
 SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'xyzzy' AND `server` = 'Frostmourne'
SELECT * FROM roster_gatherer_nodes
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'xyzzy' AND `server` ='Frostmourne'
SELECT IF(`note` LIKE '%alt%',1,0) AS 'isalt',
FLOOR(`level`/10) AS levelgroup,
COUNT(`level`) AS amount,
SUM(`level`) AS sum
FROM `roster_members`
GROUP BY isalt, levelgroup
ORDER BY isalt ASC, levelgroup DESC

Code: Select all

// Files that we accept for upload. Up to the first dot, lowercase.
$filefields[] = 'characterprofiler';
$filefields[] = 'pvplog';
$filefields[] = 'ct_raidtracker';
$filefields[] = 'bookworm';
$filefields[] = 'guildeventmanager2';
$filefields[] = 'groupcalendar';
$filefields[] = 'gatherer';

...

               // If Gather data is there, assign it to $uploadData['GatherItems']
               if( isset($data['GatherItems']) )
                 {
                   $uploadData['GatherItems'] = $data['GatherItems'];
                 }
               // Clear the $data variable
               unset($data);
...
   {
      $bookwormInputField = '';
   }

   // Create the gatherer input field if addon exists

   if(file_exists(ROSTER_ADDONS.'gatherer'))
     {
       $gathererInputField = "
                   <tr>
                     <td class=\"membersRow1\" style=\"cursor:help;\" onmouseover=\"overlib('<b>gatherer.lua</b> ".$wordings[$roster_conf['roster_lang']]['filelocation']."\\\\gatherer.lua',WRAP,RIGHT);\" onmouseout=\"return nd();\"><img src=\"".$roster_conf['img_url']."blue-question-mark.gif\" alt=\"\" /> gatherer.lua</td>
                      <td class=\"membersRowRight1\"><input type=\"file\" accept=\"gatherer.lua\" name=\"gatherer\"></td>
                   </tr>";
     }
   else
     {
       $gathererInputField = '';
     }


Code: Select all

<?php
/******************************
 * WoWRoster.net  Roster
 * Copyright 2002-2006
 * Licensed under the Creative Commons
 * "Attribution-NonCommercial-ShareAlike 2.5" license
 *
 * Short summary
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/
 *
 * Full license information
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/legalcode
 * -----------------------------
 *
 * $Id: bookworm.php 59 2006-06-14 21:17:28Z Sahasrahla $
 *
 ******************************/

foreach (array_keys( $_REQUEST ) as $k)
{
${$k} = $_REQUEST[ $k ]; 
}

include('../../conf.php');
MYSQL_CONNECT($db_host, $db_user, $db_passwd) OR DIE("DB connection unavailable");
@mysql_select_db( "$db_name") or die( "Unable to select database");

global $wowdb, $roster_conf, $wordings, $db_prefix, $addonDir;

$query  = "SELECT * FROM `".$db_prefix."gatherer_nodes` WHERE continent ='$continent' and map = '$map' ORDER BY nodeType DESC";
$result = mysql_query($query) or die("Error: " . mysql_error());
if(mysql_num_rows($result) == 0){
echo("<map>\n <a_map continent=\"$continent\" map=\"$map\" image=\"/roster/addons/gatherer/images/MAP/$continent/$map.jpg\"> \n");
}

echo ("<map>\n <a_map continent=\"$continent\" map=\"$map\" image=\"/roster/addons/gatherer/images/MAP/$continent/$map.jpg\"> \n");
while ($row = mysql_fetch_array($result)) {
foreach (array_keys( $row ) as $k)
{               
${$k} = $row[ $k ]; 
}
echo ("<Gatherable
                  Gtype=\"$nodeType\"
                  XPos=\""); echo $xPos * 1002; echo("\"
                  YPos=\""); echo $yPos * 668; echo("\"
                  Icon=\"/roster/addons/gatherer/images/$nodeType/$nodeNumber.png\"
                  GatherableName=\"$nodeTypeWord\" />
");
}
echo("</a_map> \n </map> \n");
?>