World of Warcraft Guild tools

[r1Pped]

Excellent. What you have done is really rather good, tho i am REALLY interested on how you integrated the roster too.. But that i will grab off you another time <img>

[Comsin]

Extremely new to this stuff so you might laugh =)

Are we supposed to create a block for Raid Booker?

I am probably missing something really dumb here, but I just cant figure out how to access it...

[r1Pped]

You have to create a link for it in your Qbar

If you have uploaded the files to the server then you can access the page by entering [your web address]/ROLbooker_index.php

[Comsin]

THanks!!

kk, so worked out a couple of issues on my boards...
1.) The Images to delete/edit were in the wrong file so just cut them out and uploaded to images/icons folder. Can not delete/edit w/out them.
2.) The "Save" was in French for the Chill Out Raid, easy to search for Programme ...... so fixed.
3.) Renaming the .gif icons for the classes was my bad, should have edited the file instead, lol so now I have 2 sets of Icons one with Uppercase and one with lowercase.
4.) Timeformat was 24 hour and I was able to change to 12 hour format.

The last issue I am having is still with the timezone. It is showing a 2 hour difference. When I put 6:00pm in the calendar (the one you edit when setting up a raid) it shows 8:00pm. Anyone have the quick fix? I know this is tied directly to my Profile Settings (GMT -6) and the Board Settings (GMT -7). This is correct for forum posts etc..., but still having the issue. Can I just subtract 2 hours by editing the file?

[Whisky]

This is obviously a problem coming from the small calendar where you pick up the date, and probably not from my booker.
I used the same system as when you create a thread and then schedule it in the board claendar, I bet you'll have the same problem here too, give it a try...

[Comsin]

Maybe, but looky here <img>

[flash=,:bojd60wa]http://i96.photobucket.com/albums/l182/NWebb2002/forumtime-1.jpg[/flash:bojd60wa]

[flash=,:bojd60wa]http://i96.photobucket.com/albums/l182/NWebb2002/raidtime-1.jpg[/flash:bojd60wa]

[flash=,:bojd60wa]http://i96.photobucket.com/albums/l182/NWebb2002/raidtime2-1.jpg[/flash:bojd60wa]

[flash=,:bojd60wa]http://i96.photobucket.com/albums/l182/NWebb2002/raidtime3-1.jpg[/flash:bojd60wa]

There has been a 2 hour time difference prior to any changes...

[Comsin]

If I change the admin timezone it does change the date in the RaidBooker. If I change my profile it changes the date...

but it is not = to the forum date. It is always off by +2 hours...

Either it makes my board time off by 2 hours or the Raidbooker off by 2 hours.

btw... This mod is incredible!!! I probably should have let you know that prior to all this info.

Just want to maximize its use!

Thanks...

[Comsin]

Is there something I am missing here?

Code: Select all

'RAIDDATE' => create_date("l j F, g]['date'], $board_config['board_timezone']),

[Whisky]

Missing? dunno...

create_date is a standard IM function used for scheduled threads for instance, I applied it to my mod and that's why I do not undestand why you only have this 2h-offset issue on the raid booker.

If you want you may change the "l j F, g:i" to match your own settings, this is used to format the date and hour... I know it's quiet different from EU to US

[DarkRaver]

[size=99px]

[size=99px]http://rebirthoflight.net/ara/ItemStatsIM.rar[/url]

Unzip the contain on your HDD

OPEN itemstats/config.php
adapt the values to match your IM Database settings and your WoW icon store location
SAVE and CLOSE


Before moving further, backup the following files from your host site in order to be able to recover them in case of problem]

Upload the whole contain of the ItemStatsIM folder into your IM directory and replace all existing files.

Then, upgrade your existing IM templates files:

[color=green]OPEN templates/yourtheme/overall_header.tpl

FIND]

Code: Select all

<script></script>

[color=green]AFTER, ADD]

Code: Select all

<link><script><overLIB></script>

[b]FIND]

Code: Select all

<link>

[color=green]AFTER, ADD]

Code: Select all

{ITEMSTATS_REFS}

[color=green]
SAVE and CLOSE

Last step, create the item cache table in your IM DB...go to phopmyadmin and execute this query]CREATE TABLE IF NOT EXISTS `item_cache`  (`item_name` varchar(100) NOT NULL DEFAULT '',    `item_id` varchar(100) DEFAULT '0',    `item_lang` varchar(2) DEFAULT '',    `item_link` varchar(100) DEFAULT NULL,    `item_color` varchar(20) NOT NULL DEFAULT '',    `item_icon` varchar(50) NOT NULL DEFAULT '',    `item_html` text NOT NULL,    UNIQUE KEY `item_name` (`item_name`),    FULLTEXT KEY `item_html` (`item_html`))[/code]

You can now link any WoW item in your forum like this][item]Nefarian's balls[/item][/code]

[hr:2i3rdgwn]

[size=99px]http://rebirthoflight.net/portail/mods/bbcode_box/images/item.gif[/flash:2i3rdgwn] item1.gif=>[flash=,:2i3rdgwn]http://rebirthoflight.net/portail/mods/bbcode_box/images/item1.gif[/flash:2i3rdgwn]

Then upload them to your /mods/bbcode_box/images/ directory


OPEN templates/yourtheme/posting_body.tpl

FIND

Code: Select all

<td><a>Advanced BBCode Box v5.0.0</a> </td>

BEFORE, ADD

Code: Select all

<td><img></td>

OPEN mods/bbcode_box/bbcode_box.js

FIND

Code: Select all

table_help = "Creates a Table using BBCode";

AFTER, ADD

Code: Select all

wowitem_help = "Display a WoW item]Nefarian's balls[/item]";

GO AT THE END OF THE FILE, ADD]

Code: Select all

// Function added by Aranel for the itemstat buttonfunction BBCitem() {     var txtarea = document.post.message;         if ((clientVer >= 4) && is_ie && is_win) {         theSelection = document.selection.createRange().text;         if (theSelection != '') {         document.selection.createRange().text = "[item]" + theSelection + "[/item]";         document.post.message.focus();         return;         }     }     else if (txtarea.selectionEnd && (txtarea.selectionEnd - txtarea.selectionStart > 0))     {         mozWrap(txtarea, "[item]", "[/item]");         return;     }     if (wowitem == 0) {         ToAdd = "[item]";         document.post.wowitem.src = "mods/bbcode_box/images/item1.gif";         wowitem = 1;     } else {         ToAdd = "[/item]";         document.post.wowitem.src = "mods/bbcode_box/images/item.gif";         wowitem = 0;     }     PostWrite(ToAdd);}  

[color=green]SAVE AND CLOSE ALL FILES


I can't do more...
if it is working pleaz edit your post tittle, remove my name and add a "[SOLVED]" instead <img>

I've made this modifications the button is visible but whem i click on it nothing happens ... anything else i should check ?
And to add the item icon ?

Tks

[r1Pped]

check the bbcode_box.js has been modified properly and uploaded correctly. Its this file that makes the [item][/item] appear.

[DarkRaver]

check the bbcode_box.js has been modified properly and uploaded correctly. Its this file that makes the [item][/item] appear.

Tks but problem solved ... was something else so everything was a mess <img> lol

[clanpunisher]

it looks really creat !!!

[Whisky]

Hi all,

You don't see me so much those moments and this will not change in the future.

I've got a new job in video games industry

I'll do my best to finish this as I know these are some great features for any guild using my tools .

[ckilmer75]

Excellent pack of tools. I just put up a new guild site and was wanting to integrate a Teamspeak block into the IM Portal. I'll check these out and see how it goes. Thanks for all the hard work.

[ckilmer75]

I dont know PCP hasnt added it

Here's the SQL query to run against your phpmyadmin

Code: Select all

ALTER TABLE `phpbb_users` ( ADD COLUMN (`classe` varchar(15) default NULL))

I'm having the same issue as r1Pped. I noticed after reading the post that my phpbb_users table is missing the classe column as well. I tired running the SQL query above and it gives me a syntax error.

Any suggestions?

[ckilmer75]

Well, disregard my previous post. I figured out the issue.

The syntax was wrong for the Alter Table command.

Here is the correct syntax that worked for me:

Code: Select all

ALTER TABLE phpbb_users ADD COLUMN classe varchar (15) default NULL;

I pretty much just removed all the () and ' characters, except for the varchar value, and also added the ; at the end.

[ckilmer75]

I have 2 questions that I have not been able to answer for myself:


1. When adding a raid, the submit button is still displayed in French. The rest of the module is in English per my language choice in the setup. What file do I edit to change what the raid submit button displays?

Here is a screen shot:
[img=center:3d71a2qd]http://www.ntin.net/~ckilmer75/images/screenshot.jpg[/img]
or
[url=http]Image Link[/url]

2. When subscribing to a raid, it uses the class you registered on the forums with; however, many people have alts and are not always using the class they registered on the forums with. Is there someway to be able to alter the class you are registering for the raid with (without having to change your Primary Class in your Profile)?


Thanks for the great tools by the way. <img>

[r1Pped]

You need to change the word in ROLbooker_raid_add.tpl to what ever you want it to be, if my memory serves me right.
It will be in ROL_wow_toolsROL wow toolstemplatesIntegra2 from the zip folder


I have no direct idea about the 2nd question, but would be really interested myself in that.

[ckilmer75]

Thanks for the info. It worked. <img>

[ckilmer75]

Hi,
For the server status block, after having verified and tested again, I still not have any explanations.
In my opinion, this is due to your host web server that either doesnt allow php to read the contain of an "external" web page, or that cannot even ping any other machine outside his network.

Hey Whiskey,

I also have the same issue he had with the Server Status Block not working with US Servers. It works with Khaz Modan.

And US Server Status works on my WoW Roster install.

Any ideas? I PM'd you my website.

[soapbar89]

hello, I installed your recent loot block on my IMPortal and I have a problem. It brings up the items correctly, but the mouse over doesn't appear. Here is a pic:
[url=http]http://seraphaction.net/files/itemstats_nope.jpg[/url]
Any ideas?
Thanks

[ubelong2matt]

Does anyone know enough about php to break the server status part of this mod down into an IM Portal block? Keeping copyright and creative rights intact of course! I attempted to do this myself but failed as I know just enough to be dangerous with PHP.

Any help or idea's would be appreciated!

P.S. My guild is finding it hard to use phpBB yet alone moving to something far more complex like Integramod so installing this mod is out of the question! This is just a simple request, also. If it is frowned upon, please don't flame too hard. I was just curious if it could be done or if anyone had successfully done this already perhaps.

[Whisky]

hello, I installed your recent loot block on my IMPortal and I have a problem. It brings up the items correctly, but the mouse over doesn't appear. Here is a pic:
[url=http]http://seraphaction.net/files/itemstats_nope.jpg[/url]
Any ideas?
Thanks

This is normal, I haven't find a proper way to display the mouseover box in a block without highly increase the page loading time so I've just displayed the name of the object with his in-game color.

Does anyone know enough about php to break the server status part of this mod down into an IM Portal block? Keeping copyright and creative rights intact of course! I attempted to do this myself but failed as I know just enough to be dangerous with PHP.

I am sorry I don't understand your request. This block should be working in this state with an IM portal
For some people it seems to not wotk but I am pretty sure it's coming from the hosting webserver so nothing I can really do

[Whisky]

Hi,
For the server status block, after having verified and tested again, I still not have any explanations.
In my opinion, this is due to your host web server that either doesnt allow php to read the contain of an "external" web page, or that cannot even ping any other machine outside his network.

Hey Whiskey,

I also have the same issue he had with the Server Status Block not working with US Servers. It works with Khaz Modan.

And US Server Status works on my WoW Roster install.

Any ideas? I PM'd you my website.

in the file wowserverstatus.php, you have to change the line:

Code: Select all

$url         = 'http://www.wow-europe.com/fr/serverstatus';

with

Code: Select all

$url         = 'http://www.worldofwarcraft.com/realmstatus/';

because you are playing on an US server

[ckilmer75]

Hi,
For the server status block, after having verified and tested again, I still not have any explanations.
In my opinion, this is due to your host web server that either doesnt allow php to read the contain of an "external" web page, or that cannot even ping any other machine outside his network.

Hey Whiskey,

I also have the same issue he had with the Server Status Block not working with US Servers. It works with Khaz Modan.

And US Server Status works on my WoW Roster install.

Any ideas? I PM'd you my website.

in the file wowserverstatus.php, you have to change the line:

Code: Select all

$url         = 'http://www.wow-europe.com/fr/serverstatus';

with

Code: Select all

$url         = 'http://www.worldofwarcraft.com/realmstatus/';

because you are playing on an US server

Thanks for the reply, but that was the first thing I tried.

[onsitede]

These mods are great. Tank you.

Has anyone integrated with their calendar yet?

[BitingMonkey]

Regarding realm status .script

I was unable to get this .script to work either. I did a Google search for this and found another website with the same .script. [url=http]This one works[/url]. Of note there are two separate zip files. One for Europe and one for regular. I tested it and it works as it should. I just had to plug in the wow realm info I wanted and I re uploaded the image files and did the font files separately with a binary transfer as they recommend and this works with Whisky's ROL block just fine.
From that site:

During peak hours, Blizzard's website connection can become overloaded and unreliable. In previous versions of this .script, it would hang indefinitely while waiting for Blizzard's server status page. This version solves that problem by caching data and only checking for updates at definable intervals.

Hope this helps someone. And thank you to Whisky for helping us by sharing these .scripts, much appreciated.

[Watcher]

I dont understand #4 about cloneing, can someone explain this to me in a simple way that a dummy can understand? does it mean all the changes i did in one theme to do the same changes in all the other themes?
-------------------------------------------------------------------------------------------
Installation Procedure Part 1

Unzip the contain of the zip file to your HD

Then,

1. Create the new tables in your database

The SQL .script is located in install/ROLwowtools.sql, or there:

Code: Select all

 -- -- Structure de la table `ROL_booker_raids`--  CREATE TABLE `ROL_booker_raids` (   `id` int(10) unsigned NOT NULL auto_increment,   `name` varchar(45) NOT NULL default '',   `text` text NOT NULL,   `date` varchar(90) NOT NULL default '',   `estimated` varchar(45) NOT NULL default '0',   `user` varchar(45) NOT NULL default '',   `raid_leader` varchar(45) NOT NULL default '',   `max_signups` int(10) unsigned NOT NULL default '0',   `small_raid` int(10) unsigned NOT NULL default '0',   PRIMARY KEY  (`id`)) TYPE=MyISAM ;  -- -- Structure de la table `ROL_booker_signups`--  CREATE TABLE `ROL_booker_signups` (   `id` int(10) unsigned NOT NULL auto_increment,   `name` varchar(45) NOT NULL default '',   `class` varchar(20) NOT NULL default '',   `guild` varchar(45) NOT NULL default '',   `raid_id` int(10) unsigned NOT NULL default '0',   `have_acc` smallint(5) unsigned NOT NULL default '0',   `text` text NOT NULL,   PRIMARY KEY  (`id`)) TYPE=MyISAM ;  -- -- Structure de la table `ROL_config`--  CREATE TABLE `ROL_config` (   `id` int(6) NOT NULL auto_increment,   `type` varchar(20) NOT NULL default '',   `param` varchar(50) NOT NULL default '',   `value` varchar(200) NOT NULL default '',   PRIMARY KEY  (`id`)) TYPE=MyISAM;  -- -- Contenu de la table `ROL_config`--  INSERT INTO `ROL_config` VALUES (1, 'recruit', 'hunter', '0');INSERT INTO `ROL_config` VALUES (2, 'recruit', 'warlock', '0');INSERT INTO `ROL_config` VALUES (3, 'recruit', 'druid', '0');INSERT INTO `ROL_config` VALUES (4, 'recruit', 'warrior', '0');INSERT INTO `ROL_config` VALUES (5, 'recruit', 'mage', '0');INSERT INTO `ROL_config` VALUES (6, 'recruit', 'priest', '0');INSERT INTO `ROL_config` VALUES (7, 'recruit', 'paladin', '0');INSERT INTO `ROL_config` VALUES (8, 'recruit', 'rogue', '0');INSERT INTO `ROL_config` VALUES (9, 'recruit', 'shaman', '0');INSERT INTO `ROL_config` VALUES (10, 'booker', 'officers', '33,14,6,8');INSERT INTO `ROL_config` VALUES (11, 'booker', 'members', '3,29,40');INSERT INTO `ROL_config` VALUES (12, 'booker', 'smallraid', '1');INSERT INTO `ROL_config` VALUES (13, 'booker', 'lang', 'EN');INSERT INTO `ROL_config` VALUES (14, 'booker', 'raidleader', 'Aranel');INSERT INTO `ROL_config` VALUES (15, 'objective', 'target', 'Nefarian');

You can delete the install folder afterwards.


2. If you want to use the Teamspeak block]4. Clone the templates/Integra2 folder to match the themes installed on your board.
[/color]

5. Once all files have been edited, upload the contain of the folder "ROL wow tools" to your IM root directory.

You are done with the files installation

[BitingMonkey]

I believe he just means that you you copy all the files or makes changes to any other templates the same as was made to Integra2 style.

[Watcher]

Thanks that was what i thought, just needed to make sure before i started doing any changes

[Watcher]

can someone explain to me how to add these to my sql data?

Code: Select all

 -- Structure de la table `ROL_config`--  CREATE TABLE `ROL_config` (   `id` int(6) NOT NULL auto_increment,   `type` varchar(20) NOT NULL default '',   `param` varchar(50) NOT NULL default '',   `value` varchar(200) NOT NULL default '',   PRIMARY KEY  (`id`)) TYPE=MyISAM;---------------------------------------------------------------Have added the ROL_config, just cant figure out how to add the other stuff below?----------------------------------------------------------------- -- Contenu de la table `ROL_config`--  INSERT INTO `ROL_config` VALUES (1, 'recruit', 'hunter', '0');INSERT INTO `ROL_config` VALUES (2, 'recruit', 'warlock', '0');INSERT INTO `ROL_config` VALUES (3, 'recruit', 'druid', '0');INSERT INTO `ROL_config` VALUES (4, 'recruit', 'warrior', '0');INSERT INTO `ROL_config` VALUES (5, 'recruit', 'mage', '0');INSERT INTO `ROL_config` VALUES (6, 'recruit', 'priest', '0');INSERT INTO `ROL_config` VALUES (7, 'recruit', 'paladin', '0');INSERT INTO `ROL_config` VALUES (8, 'recruit', 'rogue', '0');INSERT INTO `ROL_config` VALUES (9, 'recruit', 'shaman', '0');INSERT INTO `ROL_config` VALUES (10, 'booker', 'officers', '33,14,6,8');INSERT INTO `ROL_config` VALUES (11, 'booker', 'members', '3,29,40');INSERT INTO `ROL_config` VALUES (12, 'booker', 'smallraid', '1');INSERT INTO `ROL_config` VALUES (13, 'booker', 'lang', 'EN');INSERT INTO `ROL_config` VALUES (14, 'booker', 'raidleader', 'Aranel');INSERT INTO `ROL_config` VALUES (15, 'objective', 'target', 'Nefarian');

[Watcher]

hate to be a pest, but i sure could use some help with adding this to mysql, if you cant explain how to add it, but know how, i can give you access to add it. it has to be simple to do, I just cant figure it out?

[Watcher]

Solved

[Kribba]

hi, thanks for really great mod package <img>
I might gone blind and dont see the obvious, but on recruit block no images shows

"The requested URL /luma/images/ROLbooker/class_EN/warlock_icon.gif was not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request."

Folder and files are there


/Thanks, Kribba

[BitingMonkey]

check the spelling of the image.
"W" of:
/warlock_icon.gif
should be capitalized according to the way that the files were released. My directory has 2 versions of each with both lower and upper case. That should fix your problem.

[Kribba]

Thanks.
Yeah I had a blondie moment yesterday <img>

[ckilmer75]

Hey guys.

Is Itemstats broken with Integramod now? I've had it working just fine in the past, but I just created a fresh install of Integramod yesterday and then installed Itemstats like I have before in the past, and it will not work. If I use the [item][/item] bbcode in a post, it will not display the post. any post without the bbcode posts normally. It has something to do with the files in the itemstats modded version of 'bbcode.php' as once I replace that file with the original, the post start working again, albeit it simply displays the text [item][/item] but it does not error.

Any ideas?