Gatherer v0.9B [Roster 1.7.3 addon]

by **Foxy** » Tue Apr 03, 2007 8:51 am

http://gatherer.dragonkillers.us/gatherer_0.9b.zip

This beta require you to run convertdb.php before uploading additional data!

Enjoy!

by **Foxy** » Tue Apr 03, 2007 10:27 am

Working for everyone? Any errors or bugs?

by **arcadin** » Tue Apr 03, 2007 11:37 am

Just installed this as a replacement for version 0.9 and ran

http://www.xyzzy.ancpl.com/roster/addon ... vertdb.php

Which gave me 4,000 or so copies of the following message:

Code: Select all: Notice: Undefined index: zonecont in /var/www/htmlxyzzy/roster/addons/gatherer/convertdb.php on line 87

The first message though was "Drop Successful".

My maps were then empty, so I reuploaded. No data and I received the following message:

Code: Select all: Notice: Undefined variable: output in /var/www/htmlxyzzy/roster/update.php on line 203 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099 Notice: Undefined index: realm in /var/www/htmlxyzzy/roster/lib/wowdb.php on line 2099

I do have a customised update.php file (for phpbb->wowroster authentication) which I tried to retrofit with your changes, but it's really hard to be sure that I picked up all the changes to this file. Could you please consider marking changes with comments? I'm sure I missed soem changes :-(

In short, it didn't work for me.

A.

by **zeryl** » Tue Apr 03, 2007 12:32 pm

The updated localization file wasn't included (or you are using a lang other than enUS.php)

by **arcadin** » Tue Apr 03, 2007 12:38 pm

I'm using enUS, and installed the complete archive except for the update.php file which I tried to hack to support the phpbb->wowroster authentication. This archive has localization.php dated 2007-04-02 2:23am and enUS.php in this archive is dated 2007-04-01 12:33pm.

A.

by ds » Tue Apr 03, 2007 12:42 pm

I had to edit your supplied update.php to get the input fields to show.
Find in File update.php line: 494

Code: Select all: if(file_exists(ROSTER_ADDONS.'Gatherer'))

Change to:

Code: Select all: if(file_exists(ROSTER_ADDONS.'gatherer'))

by **Borsti** » Tue Apr 03, 2007 2:42 pm

I think ther`s something wrong...
Using deDe version... convertdb.php gave me some errors so I drop the Table from hand an let the addon creat a new Table

If I upload Charakter Profiler.lua it looks all good
If I upload CharakterProfiler and Gatherer.lua Update.php tells me
Notice: Undefined index: PvpLogData in /var/www/wow/roster/update.php on line 195
Notice: Undefined variable: updatePvPMessages in /var/www/wow/roster/update.php on line 595
Notice: Undefined variable: updatePvPMessages in /var/www/wow/roster/update.php on line 603

Test with the Gatherer.lua from a Guild member

Notice: Undefined index: BLOODMYST_ISLE in /var/www/wow/roster/addons/gatherer/functions.php on line 61

Notice: Undefined index: TELDRASSIL in /var/www/wow/roster/addons/gatherer/functions.php on line 61

by **Foxy** » Tue Apr 03, 2007 2:53 pm

@ Arcadin:

Changes to the Update.php:

Code: Select all: // Files that we accept for upload. Up to the first dot, lowercase. // add the following $filefields[] = 'gatherer'; // Adds gatherer uploads $filefields[] = 'cartographer_herbalism'; // Adds cart herb uploads $filefields[] = 'cartographer_mining'; // Adds cart mine uploads // If Gatherer data is there, assign it to $uploadData['GathererItems'] if(isset($data['GatherItems'])) { $uploadData['GatherItems'] = $data['GatherItems']; } // If Cartographer Herb data is there, assign it to $uploadData['Cartographer_HerbalismDB'] if(isset($data['Cartographer_HerbalismDB'])) { $uploadData['Cartoherb'] = $data['Cartographer_HerbalismDB']; } // If Cartographer Mine data is there, assign it to $uploadData['Cartographer_MiningDB'] if(isset($data['Cartographer_MiningDB'])) { $uploadData['Cartomine'] = $data['Cartographer_MiningDB']; } // Create the Gatherer input field if addon exists if(file_exists(ROSTER_ADDONS.'gatherer')) { $gathererInputField = " <tr> <td class=\"membersRow1\" style=\"cursor:help;\" onmouseover=\"overlib('<b>gatherer.lua</b> ".$wordings[$roster_conf['roster_lang']]['filelocation']."\\\\gatherer.lua',WRAP,RIGHT);\" onmouseout=\"return nd();\"><img src=\"".$roster_conf['img_url']."blue-question-mark.gif\" alt=\"\" /> gatherer.lua</td> <td class=\"membersRowRight1\"><input type=\"file\" accept=\"gatherer.lua\" name=\"gatherer\"></td> </tr> <tr> <td class=\"membersRow1\" style=\"cursor:help;\" onmouseover=\"overlib('<b>cartographer_herbalism.lua</b> ".$wordings[$roster_conf['roster_lang']]['filelocation']."\\\\cartographer_herbalism.lua',WRAP,RIGHT);\" onmouseout=\"return nd();\"><img src=\"".$roster_conf['img_url']."blue-question-mark.gif\" alt=\"\" /> cartographer_herbalism.lua</td> <td class=\"membersRowRight1\"><input type=\"file\" accept=\"cartographer_herbalism.lua\" name=\"cartographer_herbalism\"></td> </tr> <tr> <td class=\"membersRow1\" style=\"cursor:help;\" onmouseover=\"overlib('<b>cartographer_mining.lua</b> ".$wordings[$roster_conf['roster_lang']]['filelocation']."\\\\cartographer_mining.lua',WRAP,RIGHT);\" onmouseout=\"return nd();\"><img src=\"".$roster_conf['img_url']."blue-question-mark.gif\" alt=\"\" /> cartographer_mining.lua</td> <td class=\"membersRowRight1\"><input type=\"file\" accept=\"cartographer_mining.lua\" name=\"cartographer_mining\"></td> </tr>"; } else { $gathererInputField = ''; }

If you have edited the update.php file before I'm sure you know where these lines go. As for the convertdb.php issue, I'm not sure what caused this.

by **Foxy** » Tue Apr 03, 2007 3:02 pm

@ ds001

Corrected for this for next package.

@ Borsti

Errors the same as arcadin's when running convertdb.php?

by **Borsti** » Tue Apr 03, 2007 3:22 pm

Foxy wrote:@ ds001

@ Borsti

Errors the same as arcadin's when running convertdb.php?

It was the same errors

by **Borsti** » Tue Apr 03, 2007 4:45 pm

I tested again to run convertdb.php after create a new database via addon, just the convertdb.php tells me

Notice: Use of undefined constant ROSTER_DIED - assumed 'ROSTER_DIED' in /var/www/wow/roster/lib/commonfunctions.lib.php on line 192

Notice: Use of undefined constant ROSTER_DIED - assumed 'ROSTER_DIED' in /var/www/wow/roster/lib/commonfunctions.lib.php on line 202

Database Error

1054: Unknown column 'xPos' in 'field list'
SQL:
SELECT `map`,`xPos`,`yPos`, `nodeType`, `nodeNumber` FROM `roster_addon_gatherer_nodes`;
File: convertdb.php
Line: 29

by **Foxy** » Tue Apr 03, 2007 4:57 pm

No need to run convertdb.php after creating the table via the addon... We have updated the install_db.php to reflect the new database layout...

The convertdb.php is only needed to convert the old database layout to the new one, nothing more.

What it does is a mathmatical conversion of the x and y cords to a single numeric column.

by **psykotyk** » Tue Apr 03, 2007 7:35 pm

Notice: Use of undefined constant ROSTER_DIED - assumed 'ROSTER_DIED' in /var/www/wow/roster/lib/commonfunctions.lib.php on line 192

Notice: Use of undefined constant ROSTER_DIED - assumed 'ROSTER_DIED' in /var/www/wow/roster/lib/commonfunctions.lib.php on line 202

Database Error

1054: Unknown column 'xPos' in 'field list'
SQL:
SELECT `map`,`xPos`,`yPos`, `nodeType`, `nodeNumber` FROM `roster_addon_gatherer_nodes`;
File: convertdb.php
Line: 29

I've got the same message and I can't see anything on the map.
Should i create this 2 column "xpos"and "ypos" to resolve the problem or is there something i'm doing wrong ?

Sorry for my english, i'm french

by **daddelkopp** » Tue Apr 03, 2007 8:23 pm

Edit:

During upload Characterprofiler.lua & cartographer_herbalism.lua & cartographer_mining.lua no errors. But the AddOn shows no nodes. No one in the guild use Gatherer anymore.

I take a look into my SQL Database. Kontinent & Nodenumer is always 0 at all nodes.

I use Version 0.9b
I use a german Roster. All RosterUsers use the german client.
I fixed line: 494 in update.php

Link to Roster: Link

daddelkopp

by **Tyradil** » Tue Apr 03, 2007 10:03 pm

I've been having the same behavior like daddelkopp in my local test roster ("out of the box" installation) ...

First I thought this was because of my "clean" characterprofiler.lua with no data in there, to get the update triggers working, but after checking it without sending gatherer/cartographer data the first 5 lines don't appear.
The data to test cartographer support is from the forum here (posted by fewyn: http://www.wowroster.net/Forums/viewtop ... html#18014)

Using Herb data I get the "Undefined index: zonecont" in line 129, using mining I get it in line 194:

Code: Select all: $index = $gatherwords['zonecont'][$map];

By looking over the code $gatherwords is the same as $wordings['enUS'] (or whatever your roster lang is) and there is no zonecont defined ...

I asumed $index should be the number for the continent, so 1 for Kalimdor, 2 for Eastern Kingdoms and 3 for Outlands, and tried it with array_key_exists:

Code: Select all: $index = 0; if (array_key_exists($map, $gatherwords['zones']['1'])) $index = 1; if (array_key_exists($map, $gatherwords['zones']['2'])) $index = 2; if (array_key_exists($map, $gatherwords['zones']['3'])) $index = 3;

and for me it seams to work. :-)

Greetings
Tyradil