1.0.1999 RC2 block errors

View planned events from the WoW AddOn GroupCalendar

Moderator: Ulminia

1.0.1999 RC2 block errors

Postby MattM » Thu Jun 19, 2008 2:49 pm

Some files are missing. And it may be that not regarding os specific directory delimiters is bad in this case.

Code: Select all
blocks/block-Group_Calendar.php

    * Warning line 27: include_once(/data/htm/doblivion.com/modules/WoWRosterDF/addons\GroupCalendar\locale\block-enUS.php) [function.include-once]: failed to open stream: No such file or directory
    * Warning line 27: include_once() [function.include]: Failed opening '/data/htm/doblivion.com/modules/WoWRosterDF/addons\GroupCalendar\locale\block-enUS.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php')
    * Warning line 28: include(/data/htm/doblivion.com/modules/WoWRosterDF/lib\cmslink.lib.php) [function.include]: failed to open stream: No such file or directory
    * Warning line 28: include() [function.include]: Failed opening '/data/htm/doblivion.com/modules/WoWRosterDF/lib\cmslink.lib.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php')

includes/db/db.php

    * CMS Warning line 75: On /index.php While executing query "SELECT id, title, start AS start_time, DATE_ADD(`start`, INTERVAL `duration` MINUTE) AS `end_time`, type, description, duration, TIME_FORMAT(`start`, '%l:%i%p') AS stime, TIME_FORMAT(DATE_ADD(`start`, INTERVAL `duration` MINUTE), '%l:%i%p') AS etime, TIME_FORMAT(`start`, '%H:%i:%s') AS s_time, TIME_FORMAT(DATE_ADD(`start`, INTERVAL `duration` MINUTE), '%H:%i:%s') AS e_time, DAYOFMONTH(`start`) AS d, MONTH(`start`) AS m, YEAR(`start`) AS y FROM df_roster_roster_addons_groupcalendar_info WHERE MONTH(`start`) = 6 AND YEAR(`start`) = 2008 AND TIME_FORMAT(`start`, '%H:%i:%s')='00:00:25' ORDER BY `start`" the following error occured: Table 'doblivion.df_roster_roster_addons_groupcalendar_info' doesn't exist In: /data/htm/doblivion.com/blocks/block-Group_Calendar.php on line: 149


if you need I can give you access to ftp/db/cmsadmin via pm
Last edited by MattM on Thu Jun 19, 2008 2:51 pm, edited 2 times in total.
MattM
UA/UU Developer
UA/UU Developer
Gimpy Developer
Gimpy Developer
 
Posts: 886
Joined: Tue Jul 04, 2006 9:53 pm
Location: USA

1.0.1999 RC2 block errors

Postby Ulminia » Thu Jun 19, 2008 4:42 pm

yea this block is so much harder to debug because every one will be different and i cone in windows to so that does not help

open the file

from like 14-37 past this fix in

Code: Select all
if (!defined('CPG_NUKE')) { exit; }
global $db, $prefix;
$disabled = false;
//set this to your path to roster df
define ( 'WOSTERDF_PATH', 'modules/roster/');
if ($disabled != True){

$content .= '<div id="overDiv" style="position:absolute; visibility:hidden; z-index:1000;"></div>
<script type="text/javascript" src="'.WOSTERDF_PATH.'js/overlib.js"></script>
<script type="text/javascript" src="'.WOSTERDF_PATH.'js/overlib_hideform.js"></script>
';


define('IN_ROSTER',True);
include_once (''.WOSTERDF_PATH.'addons/GroupCalendar/locale/enUS.php');
include ''.WOSTERDF_PATH.'lib/cmslink.lib.php';

//echo $lang['gcType']['SlavePensH'].'<br>';
$prefixs = $prefix.'_wowrosterdf';
define('CALENDAR_TABLE',$prefixs.'_roster_addons_groupcalendar_info');
   
define('ATTENDANCE_TABLE',$prefixs.'_roster_addons_groupcalendar_attend');
   
define('OTHERINFO_TABLE',$prefixs.'_roster_addons_groupcalendar_other');


manualy set what define ( 'WOSTERDF_PATH', 'modules/roster/'); path is for the roster "/modules/WoWRosterDF/" for you mattm
and $prefixs should be what ever the wowroster df prefix is
after this it should be fine
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Re: 1.0.1999 RC2 block errors

Postby Equisetum » Fri Jun 20, 2008 12:33 am

I'm getting an error on the block as well, but mine seems to be a SQL error.

Code: Select all
On /index.php
While executing query "SELECT id, title, start AS start_time, DATE_ADD(`start`, INTERVAL `duration` MINUTE) AS `end_time`, type, description, duration, TIME_FORMAT(`start`, '%l:%i%p') AS stime, TIME_FORMAT(DATE_ADD(`start`, INTERVAL `duration` MINUTE), '%l:%i%p') AS etime, TIME_FORMAT(`start`, '%H:%i:%s') AS s_time, TIME_FORMAT(DATE_ADD(`start`, INTERVAL `duration` MINUTE), '%H:%i:%s') AS e_time, DAYOFMONTH(`start`) AS d, MONTH(`start`) AS m, YEAR(`start`) AS y FROM cms_rosterdf_roster_addons_groupcalendar_info WHERE MONTH(`start`) = 6 AND YEAR(`start`) = 2008 AND TIME_FORMAT(`start`, '%H:%i:%s')='00:00:25' ORDER BY `start`"

the following error occured: Table 'dragonfly.cms_rosterdf_roster_addons_groupcalendar_info' doesn't exist

In: /home/httpd/vhosts/rage-and-mana.com/subdomains/wow/httpdocs/blocks/block-Group_Calendar.php on line: 149


I doublechecked the database and I have the table there, only it is "cms_rosterdf_roster_addons_GroupCalendar_info" (notice caps). I don't know if this would make a difference (I'm on a linux box). Just to try it out, though, I edited the block to reflect the caps on the table, but this caused the whole site to not come up giving me a, "Detected invalid access to this file!" error.

Thoughts?

BTW, my guild and I have been anxiously awaiting this addon!! Thanks so much for building it.
Image
User avatar
Equisetum
WR.net Apprentice
WR.net Apprentice
 
Posts: 65
Joined: Mon Jul 24, 2006 6:44 am

Re: 1.0.1999 RC2 block errors

Postby MattM » Fri Jun 20, 2008 1:52 am

block-enUS file is in fact not existing.

Where do I get that, or how to I create it?
MattM
UA/UU Developer
UA/UU Developer
Gimpy Developer
Gimpy Developer
 
Posts: 886
Joined: Tue Jul 04, 2006 9:53 pm
Location: USA

1.0.1999 RC2 block errors

Postby MattM » Fri Jun 20, 2008 2:35 am

I fixed the block, it was missing a roster installed define.

It was using Windows dir slashes.

It was trying to include "/addons/GroupCalendar/locale/block-enUS.php" changed that to "/addons/GroupCalendar/locale/enUS.php"

Now the pages with the block hang because it tries to use wow-europe site for data retrieval
Last edited by MattM on Fri Jun 20, 2008 2:36 am, edited 1 time in total.
MattM
UA/UU Developer
UA/UU Developer
Gimpy Developer
Gimpy Developer
 
Posts: 886
Joined: Tue Jul 04, 2006 9:53 pm
Location: USA

1.0.1999 RC2 block errors

Postby Anaxent » Fri Jun 20, 2008 2:43 am

Here is an example block which was used for 1.7.3
I would like to see all rosterdf blocks to be in this format as the format allows for us to maybe have many installs of roster which there own blocks which it will define the blocks module name based on the file name

Code: Select all
<?php

if (!defined('CPG_NUKE')) { exit; }

global $db, $prefix;

# Get the name of the module from the filename
# Filename should be in the format:
#   block-$module_name[-center][-scroll][-extra_info].php
#
# Where:
#   $module_name is the name of the module
#   -center is added if this is a center block
#   -scroll is added if this is a scrolling block
#   -extra_info is added if there is extra information for this block (ie. Last 5 Topics, Last 5 Posts, Hottest 5 Topics, etc)
$block_file_info = explode('-', substr(basename(__FILE__), 6, (basename(__FILE__) - 4)));

$module_name= $block_file_info[0];

if (is_active($module_name))
{
    $result = $db->sql_query('SELECT guild_motd FROM '.$prefix.'_'.$module_name.'_roster_guild');

    while( $row = $db->sql_fetchrow($result) )
    {
       $guildMOTD = $row['guild_motd'];
    }

    $db->sql_freeresult($result);

    $content .= '<center>'.$guildMOTD.'</center><br /> ';
}
User avatar
Anaxent
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 642
Joined: Tue Jul 04, 2006 6:27 am
Location: Phoenix, Az

Re: 1.0.1999 RC2 block errors

Postby MattM » Fri Jun 20, 2008 2:47 am

This thing is trying to leach data from

Code: Select all
http://www.mediocrityinmotion.com/RSS/dungeons.php?month=6&year=2008〈=en


What's the left paren for?


I used
Code: Select all
http://www.mediocrityinmotion.com/RSS/dungeons.php?month=6&year=2008=en


which works fine.

In that data feed wow-europe appears as a source for some images.

Please, I detest this sort of leeching. Especially when it slows or hangs my pages :(
Last edited by MattM on Fri Jun 20, 2008 2:50 am, edited 1 time in total.
MattM
UA/UU Developer
UA/UU Developer
Gimpy Developer
Gimpy Developer
 
Posts: 886
Joined: Tue Jul 04, 2006 9:53 pm
Location: USA

Re: 1.0.1999 RC2 block errors

Postby MattM » Fri Jun 20, 2008 3:04 am

I'm going to make a tool to mine these images, then I'll make a function to translate the url's to make them local

http://www.worldofwarcraft.com/calendar/images/zg.gif
http://www.worldofwarcraft.com/calendar/images/aq20.gif
http://www.worldofwarcraft.com/calendar/images/onx.gif
http://www.worldofwarcraft.com/calendar/images/bwl.gif
http://www.worldofwarcraft.com/calendar/images/mc.gif
http://www.worldofwarcraft.com/calendar/images/aq40.gif
http://www.worldofwarcraft.com/calendar/images/nax.gif
http://www.worldofwarcraft.com/calendar/images/mag.gif
http://www.worldofwarcraft.com/calendar ... /gruul.gif
http://www.worldofwarcraft.com/calendar/images/cot.gif
http://www.worldofwarcraft.com/calendar ... empest.gif
http://www.worldofwarcraft.com/calendar ... ilfang.gif
http://www.worldofwarcraft.com/calendar ... razhan.gif
http://www.wow-europe.com/shared/wow-co ... /en/za.gif
http://www.worldofwarcraft.com/calendar/images/zg.gif
http://www.worldofwarcraft.com/calendar/images/aq20.gif
http://www.wow-europe.com/shared/wow-co ... /en/za.gif
http://www.worldofwarcraft.com/calendar/images/onx.gif
http://www.worldofwarcraft.com/calendar/images/zg.gif
http://www.worldofwarcraft.com/calendar/images/aq20.gif
http://www.wow-europe.com/shared/wow-co ... /en/za.gif
http://www.worldofwarcraft.com/calendar/images/bwl.gif
http://www.worldofwarcraft.com/calendar/images/mc.gif
http://www.worldofwarcraft.com/calendar/images/aq40.gif
http://www.worldofwarcraft.com/calendar/images/zg.gif
http://www.worldofwarcraft.com/calendar/images/aq20.gif
http://www.worldofwarcraft.com/calendar/images/nax.gif
http://www.worldofwarcraft.com/calendar/images/mag.gif
http://www.worldofwarcraft.com/calendar ... /gruul.gif
http://www.worldofwarcraft.com/calendar/images/cot.gif
http://www.worldofwarcraft.com/calendar ... empest.gif
http://www.worldofwarcraft.com/calendar ... ilfang.gif
http://www.worldofwarcraft.com/calendar ... razhan.gif
http://www.worldofwarcraft.com/calendar/images/onx.gif
http://www.wow-europe.com/shared/wow-co ... /en/za.gif
http://www.worldofwarcraft.com/calendar/images/zg.gif
http://www.worldofwarcraft.com/calendar/images/aq20.gif
http://www.wow-europe.com/shared/wow-co ... /en/za.gif
http://www.worldofwarcraft.com/calendar/images/zg.gif
http://www.worldofwarcraft.com/calendar/images/aq20.gif
http://www.worldofwarcraft.com/calendar/images/bwl.gif
http://www.worldofwarcraft.com/calendar/images/mc.gif
http://www.worldofwarcraft.com/calendar/images/aq40.gif
http://www.worldofwarcraft.com/calendar/images/onx.gif
http://www.worldofwarcraft.com/calendar/images/nax.gif
http://www.worldofwarcraft.com/calendar/images/mag.gif
http://www.worldofwarcraft.com/calendar ... /gruul.gif
http://www.worldofwarcraft.com/calendar/images/cot.gif
http://www.worldofwarcraft.com/calendar ... empest.gif
http://www.worldofwarcraft.com/calendar ... ilfang.gif
http://www.worldofwarcraft.com/calendar ... razhan.gif
http://www.wow-europe.com/shared/wow-co ... /en/za.gif
http://www.worldofwarcraft.com/calendar/images/zg.gif
http://www.worldofwarcraft.com/calendar/images/aq20.gif
http://www.wow-europe.com/shared/wow-co ... /en/za.gif
http://www.worldofwarcraft.com/calendar/images/onx.gif
http://www.worldofwarcraft.com/calendar/images/zg.gif
http://www.worldofwarcraft.com/calendar/images/aq20.gif
http://www.worldofwarcraft.com/calendar/images/bwl.gif
http://www.worldofwarcraft.com/calendar/images/mc.gif
http://www.worldofwarcraft.com/calendar/images/aq40.gif
http://www.worldofwarcraft.com/calendar/images/nax.gif
http://www.worldofwarcraft.com/calendar/images/mag.gif
http://www.worldofwarcraft.com/calendar ... /gruul.gif
http://www.worldofwarcraft.com/calendar/images/cot.gif
http://www.worldofwarcraft.com/calendar ... empest.gif
http://www.worldofwarcraft.com/calendar ... ilfang.gif
http://www.worldofwarcraft.com/calendar ... razhan.gif
http://www.wow-europe.com/shared/wow-co ... /en/za.gif
http://www.worldofwarcraft.com/calendar/images/zg.gif
http://www.worldofwarcraft.com/calendar/images/aq20.gif
http://www.worldofwarcraft.com/calendar/images/onx.gif
http://www.wow-europe.com/shared/wow-co ... /en/za.gif
http://www.worldofwarcraft.com/calendar/images/zg.gif
http://www.worldofwarcraft.com/calendar/images/aq20.gif
http://www.wow-europe.com/shared/wow-co ... /en/za.gif
MattM
UA/UU Developer
UA/UU Developer
Gimpy Developer
Gimpy Developer
 
Posts: 886
Joined: Tue Jul 04, 2006 9:53 pm
Location: USA

1.0.1999 RC2 block errors

Postby Ulminia » Fri Jun 20, 2008 3:28 am

send me the images when you are done ial add them to the core addon and so the hole addon does not hang at all..
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

Re: 1.0.1999 RC2 block errors

Postby MattM » Fri Jun 20, 2008 3:47 am

here ya go :D after i edit the block file ill attach it
Attachments
imagemine20080619174627.rar
(38.14 KiB) Downloaded 346 times
icons.rar
(30.6 KiB) Downloaded 369 times
Last edited by MattM on Fri Jun 20, 2008 3:47 am, edited 1 time in total.
MattM
UA/UU Developer
UA/UU Developer
Gimpy Developer
Gimpy Developer
 
Posts: 886
Joined: Tue Jul 04, 2006 9:53 pm
Location: USA

Re: 1.0.1999 RC2 block errors

Postby MattM » Fri Jun 20, 2008 4:26 am

here it is, fixed.

I managed to clean up most notices and warnings, but I can't figure out the last 2:


Code: Select all
blocks/block-Group_Calendar.php

    * Warning line 155: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
    * Warning line 207: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
Attachments
fixed.rar
(8 KiB) Downloaded 340 times
MattM
UA/UU Developer
UA/UU Developer
Gimpy Developer
Gimpy Developer
 
Posts: 886
Joined: Tue Jul 04, 2006 9:53 pm
Location: USA

Re: 1.0.1999 RC2 block errors

Postby MattM » Fri Jun 20, 2008 5:04 am

you dont take into account mysqli users.
the getlink function does not work....
it does not respect admin choice to show/hide reset times

I put some defines in there to fix these problems.
Attachments
fixed2.rar
(3.87 KiB) Downloaded 356 times
MattM
UA/UU Developer
UA/UU Developer
Gimpy Developer
Gimpy Developer
 
Posts: 886
Joined: Tue Jul 04, 2006 9:53 pm
Location: USA

1.0.1999 RC2 block errors

Postby Ulminia » Fri Jun 20, 2008 5:38 am

reset times are GC Roster addon defined and not called by the block... not yet tho lol worken on it
Ulminia of Zangarmarsh
Zonous of Zangarmarsh
Author of Roster Gallery
WoWRoster-Profiler Redesigner
User avatar
Ulminia
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 1223
Joined: Tue Jul 04, 2006 4:41 pm
Location: New Brunswick, Canada
Realm: Zangarmarsh (PvE) - US
gmail/gtalk: ulminia@gmail.com

1.0.1999 RC2 block errors

Postby foreseit » Fri Jun 20, 2008 5:53 am

just checking... this DF block is designed to work with DF only? I tried looking at the page directly (http://www.thehateguild.com/anetheronBe ... lendar.php) and it comes up blank. I'm guessing it's not designed to work as a stand alone page?
<a href="thehateguild.com"><img src="/anetheron/addons/siggen/sig.php?name=Foreseit"></a>
User avatar
foreseit
WR.net Journeyman
WR.net Journeyman
 
Posts: 139
Joined: Tue Jul 25, 2006 10:03 pm

1.0.1999 RC2 block errors

Postby Anaxent » Fri Jun 20, 2008 6:50 am

it is designed to work only as a block using the df block style coding. Im sure you could download the block and find away to make it just a page
User avatar
Anaxent
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 642
Joined: Tue Jul 04, 2006 6:27 am
Location: Phoenix, Az

Next

Return to Group Calendar

Who is online

Users browsing this forum: No registered users and 0 guests

cron