Page 1 of 1

World of Warcraft Guild tools

PostPosted: Sat Mar 10, 2007 7:47 am
Author: Whisky
Hi all,

Here's a public pack of some of the tools I have developped for my WoW guild portal.

It contains the following tools:
  • Raid booker
  • Guild Target block
  • Guild Recruitment block
  • WoW Server status bloc
  • Teamspeak block
This pack is compatible with English, French and Deutsch languages (World of Warcraft European servers languages)
However the deutsch translation still need to be done.

The Server status and Teamspeak blocks core code is not from me, I only adapted them for an IM utilization, all the rest has been coded by me over the past year.
You can see those tools in action on my guild portal: http://rebirthoflight.net/

Here are 2 screenshots of the Raid booker:

Officer view (french and signed in)
[flash=,:2035pwgh]http://www.rebirthoflight.net/ara/bookerraidadmin.jpg[/flash:2035pwgh]

Members view (english)
[flash=,:2035pwgh]http://www.rebirthoflight.net/ara/bookerraid.jpg[/flash:2035pwgh]

This is a BETA release, meaning that they are probably some minor bugs remaining and/or maybe a few things I forgot in this pack.

The following posts will describe in detail the features, the installation pocedure and the configuration. DO NOT pay attention to INSTALLATION.TXT file in this zip, it's incomplete. Follow the procedures below instead, they will be updated if losts or bugs are found.

I am waiting your returns to correct and improve it before an official release. And I have some other stuff to share but not yet ready for a multi-langual utilization, I'll add them later....

Happy raiding! <img>

Re: [BETA] WOrld of Warcraft Guild tools

PostPosted: Sat Mar 10, 2007 7:47 am
Author: Whisky
[size=99px]-- -- 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');  [/code]
You can delete the install folder afterwards.


2. If you want to use the Teamspeak block:

Open the file blocks/blocks_imp_ts.php

Fill in serveraddress, serverudpport and serverqueryport.

Save and close the file.


3. If you want to use the WoW Server Status block

open/wowserverstatus.php

Fill in server, messages, language and URL.

Save and close the file.


4. Clone the templates/Integra2 folder to match the themes installed on your board.


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



[size=99px]list_classes[/color]
Don't populate the others fields

Click the "Add a new value" button and start encoding the wow classes either in french, english or deutsch.
This is important to encode them right, keep exactly the names below, without accentued characters and with the first letter capitalized, otherwise the mod will not work properly]FRANCAIS: Chaman, Chasseur, Demoniste, Druide, Guerrier, Mage, Paladin, Pretre, Voleur [/i]
ENGLISH : Druid, Hunter, Mage, Paladin, Priest, Rogue, Shaman, Warlock, Warrior
DEUTSCH: Druide, Hexenmeister, Jager, Krieger, Magier, Paladin, Priester, Schamane, Schurke
Give the same values to each field inline (Value, Text, Image)

4. Click the "Send" button to save your changes


Adding a WoW Class field to the users data

1. Go to your board ACP => P.C.P. => Fields definition

2. Click the "Add a new field" bouton at the bottom of the page

3. Fill in the Name field with this value: classe
ATTENTION do not put anyting else then "classe" there, this is important!

Fill in the legend field with "Class", "Classe" or "Klasse" following your language

Fill in the explanation field with wathever you want, this is to explain the user that this field is his main wow character class

Once this is done, click the "Input" option on the top menu

Choose "No" to all 4 questions there (Not a config value, System field, Required field, Show Visibility)

For the "Get mode" field, choose "LIST_DROP" in the dropdown list

Let "Get function", "Check function", "Default value" empty

For the "Values list", choose "list_classes" in the dropdow list (this is the one we created above)

Let "Input Template style" empty

Choose "Registered user" for the last "Auth level" option

4. Click the "Send" button to save your new field



Adding the WoW Class field to the users registration form

1. Go to your board ACP => P.C.P. => PCP Wizard => Alter Form Display

2. In the top dropdown list, you should already have this page select:
Profil ÂÂÂ » Profile ÂÂÂ » Your profile ÂÂÂ » Registration information
If not, find it and click the Select button

3. Click "Add / Remove Page Fields"
At this point, if you are running an IM 1.4.1 board and never used the PCP wizard before, you will more then probably receive the following (damn) alert message]
/*CBACK CrackerTracker* has detected a potential attack on this site with a worm or exploit .script so the Security System stopped the .script.

If you can see this page after including a new MOD into your board or after clicking on a link please contact the Board Administrator with this error message and a de.scription what you have done before you could see this page, that the Admin has the possibility to fix the problem./

Don't panic, here's the workaround for it: <img>
Code: Select all
##-----[ OPEN ]------------------------------------------#/admin/admin_pcp_wizard.php  ##-----[ FIND ]------------------------------------------#define('IN_PHPBB', true);  ##-----[ AFTER, ADD ]------------------------------------------#define('CT_SECLEVEL', 'LOW');  ##-----[ SAVE/CLOSE ALL FILES ]------------------------------------------## EoM  


4. Once you are on the page "[b]PCP Wizard ÂÂÂ » Add / Remove Page Fields
"

In the left list, find the field "Classe" and select it, then click the middle button "->" to sent it on the right side. Then, on the right list, select "Classe" and click the "Move up button" until the field is where you want it to appear in the registration form.

Click the "Send" button.

You are back on the first page, verify that your new field is there and then click the "Send" button again

And that's all <!-- s]Now all your users can define their WoW character class from their profile control panel[/b]

Re: [BETA] WOrld of Warcraft Guild tools

PostPosted: Sat Mar 10, 2007 7:48 am
Author: Whisky
If the mod has been properly installed, you should now have some new options in your ACP => ROL WoW Tools

Here's an overview

[size=99px]ATTENTION [/color]This is really important, you have to separate the forum groups Id with commas ","
The string you encode there will be used in an SQL instruction of the booker code, so failure to populate this field the right way will make the booker utilization impossible!
Example]33,14,6,8[/code]
I hope I have not to explain how to manage forum groups and find their ID <img>

Members
The same then above, but for the members of your guild, meaning the guys who will have the authorization to subcribe to the raids, and to create "small raids"

Raid Leader

This is used to populate automatically the field "Raid Leader" when a new raid is created

"Small raids" module
Small raids, or "Chill out" raids, can be created by every guild member and are displayed separately of the raids created by the officers
Ideal to let the opportunity to your members to plan 5/10 persons dungeons, arenas, quests, farming or PvP sessions, weddings or whatever!!
Check the box to activate this option.

[size=99px]http://www.rebirthoflight.net/ara/recruit_bloc.JPG[/img]

The link "Demande de recrutement" that you can see in lower part of the block should be adapted to point on your recruitment forum, or removed. I'll explain that in the following section.

Current Objective Block

This is used to show the current PVE encounter your guild is fighting against, like this:

[img=left:3224h2rk]http://www.rebirthoflight.net/ara/obj_bloc.JPG[/img]

Re: [BETA] World of Warcraft Guild tools

PostPosted: Sat Mar 10, 2007 8:26 am
Author: Whisky
[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 phpmyadmin 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:2xl2gfu4]

[size=99px]http://rebirthoflight.net/portail/mods/bbcode_box/images/item.gif[/img] item1.gif=>[img=left:2xl2gfu4]http://rebirthoflight.net/portail/mods/bbcode_box/images/item1.gif[/img]

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>

Re: [BETA] World of Warcraft Guild tools

PostPosted: Sat Mar 10, 2007 11:23 am
Author: Whisky
[size=99px]

[size=99px]http://rebirthoflight.net/ara/itemsblock.jpg[/img]
I assume your DKP system is eqdkp

Like for every block, you need 2 files to make this working: a php file and a template file

For each file copy/past the following code in a text file on you destop, rename the file exactly like I suggest it (in bold red) and then upload them on their respective directories]/blocks/blocks_imp_ROL_items.php[/color]
Code: Select all
<php>sql_query($query))         {             message_die(GENERAL_ERROR, 'Could not query eqdkp_items information', '', __LINE__, __FILE__, $sql);         }                         $texte = "";         $brol = "";         $nom= "";                 while ($row = $db->sql_fetchrow($result))         {                 $nom = addslashes($row['item_name']);             $membre = $row['item_buyer'];                         $query2 = "  SELECT * FROM `item_cache` WHERE item_name ='".$nom."'";               $result2 = mysql_query($query2) or die(mysql_error());                         if ( $row2 = mysql_fetch_assoc( $result2 ))             {                 $objet = '<div><a><span>['.$row['item_name'].']</span></span></a>';             }                                             /*      UNCOMMENT THE FOLLOWING CODE ONLY IF:             //            * you are using the mod "Advanced Color group color"             //            * Your members are registered on your forum with their raiding character's name                                       $sqlU = "SELECT user_id, user_group_id, user_session_time FROM phpbb_users WHERE username='".$row['item_buyer']."'";                               if ( !($resultU = $db->sql_query($sqlU)) ) message_die(GENERAL_ERROR, 'Could not read phpbb_users', '', __LINE__, __FILE__, $sqlU);                         if( $rowU = $db->sql_fetchrow($resultU) )             {                     $style_color = '';                     $style_color = $agcm_color->get_user_color($rowU['user_group_id'], $rowU['user_session_time']);                     $membre = '<a><span>' . $row['item_buyer'] . '</span></a> ';             }                                 */                         $texte .= $objet.'</br> win by '.$membre.'<br><br>';                                         }                 $template->assign_vars(array('ROL_ITEMS' => sprintf($texte)));       }}  ROL_items();  ?>


/templates/yourtheme/blocks/ROL_items_block.tpl
Code: Select all
<table>     <tr>         <td><span>{ROL_ITEMS}</span></td>     </tr></table>


When those 2 files are uploaded, you will be able to select this new bloc on your ACM in bloc management


[hr]
more to come...

Re: [BETA] World of Warcraft Guild tools

PostPosted: Tue Mar 13, 2007 7:59 am
Author: jnicholson56
I am having a few issues with your wow tools package.

Issue 1:

I am trying to setup the status block with a US server. the server name is hellscream and the server status page location is either http://www.worldofwarcraft.com/realmstatus/status.xml or http://www.worldofwarcraft.com/realmstatus/. Neither of them work. Any suggestions?

I realized I hadn't tried this on a EU server yet so I set it up using Eonar and several other servers and I was not able to get a status from them either.


Issue 2:

The pictures on the recruitment block were not working at first. I discovered that the pictures names were misspelt and would not work on a linux web server. The pictures names all start with uppercase letters and the block was looking for the same file names but will all lowercase first letters. I changed the names of the files so that they all had lowercase letters at the begining of each name and they started working.

Re: [BETA] World of Warcraft Guild tools

PostPosted: Wed Mar 14, 2007 2:15 am
Author: Whisky
1. For the serverstatus block that's really strange, at least you should get it working on my onw server "Khaz Modan" (EU) without make modifications to the files.
Could you provide me a link to you website in order to see what the block is displaying exactly? That could help me to understand

2. For the images, somebody told me about that. I personally run my sites on a linux webserver and I never saw those porblems, that's why it's hard to correct them and that's why this is a BETA <img>
I'll correct this.

Are all of the other modules (especially the raid booker) working properly?

PostPosted: Wed Mar 14, 2007 4:14 am
Author: jnicholson56
I sent you the URL in a PM. I haven't yet worked with the booker program. I have everything installed as instructed. But it does seem to be in order. I am contemplating on using phpraid since we had used it before and I already have it integrated with phpbb.

I also went ahead and put the original wowserverstatus.php file back into place from a fresh download of the package and it still is not working. You should see that block when you go to the page.

i appreciate your help.

PostPosted: Tue Mar 20, 2007 1:43 pm
Author: jnicholson56
Any updates? I am still having issues with this.

Re: [BETA] World of Warcraft Guild tools

PostPosted: Sun Mar 25, 2007 8:53 am
Author: jnicholson56
"jnicholson56";p="22884" wrote:I am having a few issues with your wow tools package.
Issue 2:

The pictures on the recruitment block were not working at first. I discovered that the pictures names were misspelt and would not work on a linux web server. The pictures names all start with uppercase letters and the block was looking for the same file names but will all lowercase first letters. I changed the names of the files so that they all had lowercase letters at the begining of each name and they started working.


I fixed this issue today. All I will say is that I should have followed all of the instructions. I skipped some by mistake and didn't realize it.

Re: [BETA] World of Warcraft Guild tools

PostPosted: Mon Mar 26, 2007 5:20 am
Author: Whisky
Hi,

Sorry for the delay, I took a large "developping" pause after having ding my shaman lvl 70 in order to focus on in instances accesses and Karazhan raids...

For the images problem I am happy to see that you finally solved it and that my installation procedure was correct <img>

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.

Re: [BETA] World of Warcraft Guild tools

PostPosted: Thu Apr 05, 2007 5:44 am
Author: Lighttaker
Hello There,

Very nice mod, just installed raidbooker on my guilds website, but have a question about it.

Do u know a way to copy organised raids into the calendar?

Other then these question, my compliments on a very nice mod

Re: [BETA] World of Warcraft Guild tools

PostPosted: Fri Apr 06, 2007 11:45 am
Author: Whisky
Hi

Txs for your comments ;)

Re: [BETA] World of Warcraft Guild tools

PostPosted: Wed Apr 11, 2007 5:30 am
Author: Lighttaker
"Whisky";p="23801" wrote:Hi

Txs for your comments ;)


NP m8,

Currently implementing the raidplanner in my guilds new website and we really like it, so keep up the good work :) it looks imba, only wish I was that good with modifying/building these themes :P

Re: [BETA] World of Warcraft Guild tools

PostPosted: Wed Apr 11, 2007 5:35 am
Author: Whisky
About my themes, read this: http://www.integramod.com/forum/viewtop ... highlight= <img>

About the wow armury it's not yet possible to do a such think because Blizzard don't want to open his WoW databases to all, and I understand that. that's probably a reason why they developped the armury in Flash => impossible to pick up any data from the pages

PostPosted: Wed Apr 11, 2007 5:58 am
Author: Lighttaker
Z0mg, paid themes :P
not going to take that though :P

Re: [BETA] World of Warcraft Guild tools

PostPosted: Wed Apr 11, 2007 6:18 am
Author: Whisky
wow that's amazing! :) except for WoWroster & co who'll not have any utility in a few months, sad....

PostPosted: Wed Apr 11, 2007 6:37 am
Author: Lighttaker
Aye, that readout looks promosing, would be nice to implement this in a site, after searching on the wowroster site, ive seen that their building a addon for the current version to sync with the armory, this addon is currently in beta, couldnt find a download location for it at first glance though.

Currently searching for more kwl stuff that reads out the armory <img>

PostPosted: Fri Apr 20, 2007 12:17 pm
Author: jbl7979
Nice Whisky, been waiting for the itemstats stuff for a few months.

Question though, anyway to get it to do the [itemico] tag? Which shows icons instead of the text in the forum?

PostPosted: Sat Apr 21, 2007 5:20 am
Author: Whisky
I have not added this function coz I do not find it usefull, do you?

PostPosted: Sat Apr 21, 2007 10:31 am
Author: jbl7979
Oh i personally prefer it to the link of the name, and so do most of my guildies.

Actually it works, you didnt remove the old code or anything. Just [itemico][/itemico]

I just wish the mouseovers werent so slow <img>

Re: World of Warcraft Guild tools

PostPosted: Sun Apr 22, 2007 5:36 am
Author: Whisky
ok fine then, I'll add another button for this icon function on my board <img>

About the mouseover, you have the possbility to choose a much ligher java.script in the options:

OPEN itemstats/config_itemstats.php
Code: Select all
define('tooltip_js', 'overlib');


[color=green]REPLACE WITH]
Code: Select all
define('tooltip_js', 'light');


[color=green]SAVE AND CLOSE]

PostPosted: Mon Apr 23, 2007 10:15 am
Author: jbl7979
Thanks for that. I actually didnt update the itemstats on my dkp site just my forum, once I did hte update on the dkp site and cleared the sql table, the mouseovers have been back to very fast.

Yeah, im gonna add a button for [itemico] too.

Re: [BETA] World of Warcraft Guild tools

PostPosted: Tue Apr 24, 2007 2:21 pm
Author: Quotrax
"Whisky";p="22773" wrote:[[size=99px]http://rebirthoflight.net/ara/itemsblock.jpg[/flash:4454306k]
My eqdkp database is not the same as my forum database. I don't know much about SQL queries, how do I modify the select statement you provided to pull the "latest items" from a a different database.

My integramod forum database is called: guild_forum
My eqdkp database is called: guild_eqdkp
... so the select statement needs to call "eqdkp_items" from "guild_eqdkp" but I believe it's defaulting to the forum db.

PostPosted: Tue Apr 24, 2007 11:23 pm
Author: Whisky
I tried to run several databases when I firstly installed IM but I never got my custom code working as intended and I finally let down and merged all my tables into the same DB and now I am just happy.
I do not say it is impossible to do but if I give you a method I am pretty sure it will not work since I can't test it on my side.

I would simply suggest you to extract your eqdkp tables and to reload them all in your IM database.
It's fast and safe and your DB performances will not be impacted at all you can trust me. And overall your pages loading time will be much faster if you only use 1 DB

I've got myself 201 tables for 4 different php systems and it's running smooth

Re: World of Warcraft Guild tools

PostPosted: Wed Apr 25, 2007 9:14 am
Author: Quotrax
Well, like I said, I'm not very skilled with SQL. In attempting to move my eqdkp info from it's DB to the forum DB, I backed up my existing DB and then imported it into my forum database. I modified my config.php file in my eqdkp directory, but now I get these errors.
[code]  Warning]I must have missed something, got any suggestions? Is there another way to do this? Should I uninstall custom styles and the itemstats mod from EQDKP first?

PostPosted: Thu Apr 26, 2007 1:02 am
Author: Whisky
I don't think so, it should be running fine directly after you adapted the config file.

Where exactly do you receive this error? IM portal or eqdkp?

give me the links to both systems I'll try this myself

Maybe I missed something in the eqdkp config since I do not use this system, I'll have a look as soon as you provide me with the links

Re: [BETA] World of Warcraft Guild tools

PostPosted: Thu Apr 26, 2007 12:22 pm
Author: jbl7979
"Quotrax";p="24376" wrote:
"Whisky";p="22773" wrote:[[size=99px]http://rebirthoflight.net/ara/itemsblock.jpg[/flash:c084lhx4]
My eqdkp database is not the same as my forum database. I don't know much about SQL queries, how do I modify the select statement you provided to pull the "latest items" from a a different database.

My integramod forum database is called: guild_forum
My eqdkp database is called: guild_eqdkp
... so the select statement needs to call "eqdkp_items" from "guild_eqdkp" but I believe it's defaulting to the forum db.


Same here, I want to tuse this feature but I cant figure out how to connect it to the seperate database <img>
Maybe ill merge to one database as well. The only issue is that this makes the backups even more huge than they are.

PostPosted: Thu Apr 26, 2007 11:47 pm
Author: Whisky
I agree the backups are huge but on the other hand eqdkp tables do not take a lot of space and it's easier to make 1 backup

Re: World of Warcraft Guild tools

PostPosted: Tue May 01, 2007 2:30 pm
Author: r1Pped
ok ran into a small problem with this section:-

"Whisky";p="22767" wrote:[size=99px]list_classes[/color]
Don't populate the others fields

Click the "Add a new value" button and start encoding the wow classes either in french, english or deutsch.
This is important to encode them right, keep exactly the names below, without accentued characters and with the first letter capitalized, otherwise the mod will not work properly]FRANCAIS: Chaman, Chasseur, Demoniste, Druide, Guerrier, Mage, Paladin, Pretre, Voleur [/i]
ENGLISH : Druid, Hunter, Mage, Paladin, Priest, Rogue, Shaman, Warlock, Warrior
DEUTSCH: Druide, Hexenmeister, Jager, Krieger, Magier, Paladin, Priester, Schamane, Schurke
Give the same values to each field inline (Value, Text, Image)

4. Click the "Send" button to save your changes



I have a funky mouse that when it has a fit, clicks or unclicks randomly. In this case it selected one of the options. The ranks I think.

I cant actively do anything on the site and I am recieving this error
[code]General ErrorCould not read list informations  DEBUG MODE  SQL Error ]

Is there any way i can revert the options or rectify the problem?

[url=http]Linky to the site here[/url]

Ok I have rectified it, opened the profilcp folder and replaced the contents. This sorted the problem.

PostPosted: Thu May 03, 2007 1:52 pm
Author: r1Pped
A slightly different problem to above. Having made modifications for the raid booker to the relivant files, but nobody can change their class, nor even see the options to change their class.
I have checked them over and over again and still nothing is showing in the profile.

Any ideas? link in last post.

Re: World of Warcraft Guild tools

PostPosted: Thu May 03, 2007 2:58 pm
Author: Whisky
Are you sur you made all the PCP steps well?

The last one is:

4. Once you are on the page "PCP Wizard ÂÂÂ » Add / Remove Page Fields"

In the left list, find the field "Classe" and select it, then click the middle button "->" to sent it on the right side. Then, on the right list, select "Classe" and click the "Move up button" until the field is where you want it to appear in the registration form.

Click the "Send" button.

You are back on the first page, verify that your new field is there and then click the "Send" button again

Can you see the field "Classe" in the right column which is defining how the register form looks like?
Be extra carefull that you have to clik on "Send" 2 times to save your modfications

PostPosted: Fri May 04, 2007 6:05 am
Author: r1Pped
yup all things done just like that.

Here are some pics.
[flash=,:zioi74h3]http://www.r1pped.com/wow/booker/title-fields1.jpg[/flash:zioi74h3]
[flash=,:zioi74h3]http://www.r1pped.com/wow/booker/title-fields.jpg[/flash:zioi74h3]
[flash=,:zioi74h3]http://www.r1pped.com/wow/booker/fields-def.jpg[/flash:zioi74h3]
[flash=,:zioi74h3]http://www.r1pped.com/wow/booker/page-field.jpg[/flash:zioi74h3]
[flash=,:zioi74h3]http://www.r1pped.com/wow/booker/form-disp.jpg[/flash:zioi74h3]




This is where things go funny.

The example it shows the drop down box

[flash=,:zioi74h3]http://www.r1pped.com/wow/booker/disp-examp.jpg[/flash:zioi74h3]


BUT the ACTUAL profile shows nothing

[flash=,:zioi74h3]http://www.r1pped.com/wow/booker/profile.jpg[/flash:zioi74h3]

PostPosted: Fri May 04, 2007 7:15 am
Author: Whisky
I see something that could explain the problem there:

[flash=,:3f31wq06]http://www.r1pped.com/wow/booker/form-disp.jpg[/flash:3f31wq06]

The "Show visibility" box is not checked for the classe field

PostPosted: Fri May 04, 2007 7:17 am
Author: r1Pped
Even with it ticked, still nothing shows.

Just thinking, my server is on a linux server, so is there anything thats case dependent written in any files that i may have to change?

Re: World of Warcraft Guild tools

PostPosted: Fri May 04, 2007 7:25 am
Author: Whisky
Try to empty your theme cache in extreme styles, I do not see anything else <img>

PostPosted: Fri May 04, 2007 7:28 am
Author: r1Pped
sadly nothing.
I will have a hunt through the files when i get a chance and see if there is anything there that would cause any problems.

Anyone else having similar problems?

PostPosted: Fri May 04, 2007 2:29 pm
Author: r1Pped
Where is the data stored to state who is what class?

PostPosted: Fri May 04, 2007 2:39 pm
Author: Whisky
you added a field at the end of the phpbb_users table

PostPosted: Fri May 04, 2007 4:35 pm
Author: r1Pped
Then that might be whats the problem, there is no additional field in the database for the class.

Re: World of Warcraft Guild tools

PostPosted: Sat May 05, 2007 5:11 am
Author: Whisky
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))

PostPosted: Sat May 05, 2007 6:04 am
Author: r1Pped
Already done, but thanks <img>

PostPosted: Sat May 05, 2007 6:28 am
Author: Whisky
and workin' now?

PostPosted: Sat May 05, 2007 7:20 am
Author: r1Pped
yup, like a dream
any word about calender injection yet?
10/10 <img>

PostPosted: Sat May 05, 2007 7:59 am
Author: Whisky
well the calendar injection is done and running sweet for 2 weeks you can check it on my forum, but I still have to make a public pack of it I'll do taht next week

PostPosted: Sat May 05, 2007 8:47 am
Author: 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>

PostPosted: Sat May 05, 2007 2:45 pm
Author: 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...

PostPosted: Sun May 06, 2007 3:45 am
Author: 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

Re: World of Warcraft Guild tools

PostPosted: Tue May 08, 2007 6:35 am
Author: 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?

PostPosted: Tue May 08, 2007 7:18 am
Author: 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...

Re: World of Warcraft Guild tools

PostPosted: Tue May 08, 2007 7:31 am
Author: 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...

Re: World of Warcraft Guild tools

PostPosted: Tue May 08, 2007 9:00 am
Author: 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...

Re: World of Warcraft Guild tools

PostPosted: Tue May 08, 2007 9:08 am
Author: Comsin
Is there something I am missing here?

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

PostPosted: Wed May 09, 2007 12:05 am
Author: 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

Re: [BETA] World of Warcraft Guild tools

PostPosted: Wed May 23, 2007 7:41 am
Author: DarkRaver
"Whisky";p="22769" wrote:[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

PostPosted: Wed May 23, 2007 12:30 pm
Author: r1Pped
check the bbcode_box.js has been modified properly and uploaded correctly. Its this file that makes the [item][/item] appear.

PostPosted: Thu May 24, 2007 7:45 am
Author: DarkRaver
"r1Pped";p="25879" wrote: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 :P so everything was a mess <img> lol

PostPosted: Fri May 25, 2007 10:57 am
Author: clanpunisher
it looks really creat !!!

Re: World of Warcraft Guild tools

PostPosted: Tue May 29, 2007 9:30 am
Author: 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 .

Re: World of Warcraft Guild tools

PostPosted: Thu Jun 14, 2007 10:12 am
Author: 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.

Re: World of Warcraft Guild tools

PostPosted: Fri Jun 15, 2007 6:54 am
Author: ckilmer75
"Whisky";p="24835" wrote: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?

Re: World of Warcraft Guild tools

PostPosted: Fri Jun 15, 2007 7:03 am
Author: 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.

Re: World of Warcraft Guild tools

PostPosted: Fri Jun 15, 2007 8:21 am
Author: 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>

PostPosted: Fri Jun 15, 2007 10:00 am
Author: 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.

Re: World of Warcraft Guild tools

PostPosted: Fri Jun 15, 2007 10:21 am
Author: ckilmer75
Thanks for the info. It worked. <img>

Re: [BETA] World of Warcraft Guild tools

PostPosted: Thu Jun 21, 2007 11:43 am
Author: ckilmer75
"Whisky";p="23363" wrote: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.

Re: World of Warcraft Guild tools

PostPosted: Fri Jun 22, 2007 12:03 pm
Author: 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

Re: World of Warcraft Guild tools

PostPosted: Wed Jul 18, 2007 2:08 am
Author: 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.

Re: World of Warcraft Guild tools

PostPosted: Fri Jul 20, 2007 8:17 am
Author: Whisky
"soapbar89";p="26760" wrote: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

Re: [BETA] World of Warcraft Guild tools

PostPosted: Fri Jul 20, 2007 8:22 am
Author: Whisky
"ckilmer75";p="26731" wrote:
"Whisky";p="23363" wrote: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

Re: [BETA] World of Warcraft Guild tools

PostPosted: Fri Jul 20, 2007 8:31 am
Author: ckilmer75
"Whisky";p="27459" wrote:
"ckilmer75";p="26731" wrote:
"Whisky";p="23363" wrote: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. :)

PostPosted: Tue Dec 11, 2007 5:47 pm
Author: onsitede
These mods are great. Tank you.

Has anyone integrated with their calendar yet?

Re: World of Warcraft Guild tools

PostPosted: Mon Feb 18, 2008 9:37 am
Author: 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.

Re: World of Warcraft Guild tools

PostPosted: Mon Apr 14, 2008 9:32 pm
Author: 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

Re: World of Warcraft Guild tools

PostPosted: Mon Apr 14, 2008 11:12 pm
Author: 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.

Re: World of Warcraft Guild tools

PostPosted: Mon Apr 14, 2008 11:52 pm
Author: Watcher
Thanks that was what i thought, just needed to make sure before i started doing any changes

Re: World of Warcraft Guild tools

PostPosted: Tue Apr 15, 2008 7:22 pm
Author: 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');

Re: World of Warcraft Guild tools

PostPosted: Sat Apr 19, 2008 8:40 pm
Author: 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?

Re: World of Warcraft Guild tools

PostPosted: Sun Apr 20, 2008 12:58 am
Author: Watcher
Solved

Re: World of Warcraft Guild tools

PostPosted: Sat Jul 05, 2008 1:26 pm
Author: 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

PostPosted: Sun Jul 06, 2008 2:20 am
Author: 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.

Re: World of Warcraft Guild tools

PostPosted: Sun Jul 06, 2008 3:17 am
Author: Kribba
Thanks.
Yeah I had a blondie moment yesterday <img>

Re: World of Warcraft Guild tools

PostPosted: Thu Mar 05, 2009 2:03 pm
Author: 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?