Gatherer v0.9B [Roster 1.7.3 addon]

by **daddelkopp** » Tue Apr 03, 2007 11:54 pm

Can you please tell were exactly I have to insert your fix? I could not find it

daddelkopp

by **zeryl** » Tue Apr 03, 2007 11:57 pm

For EVERYONE, I need you to update your enUS.php from this URL

http://www.wowroster.net/websvn/filedet ... rev=0&sc=0

Also, anyone who is using a language other than enUS.php, you need to copy the zonecont array from the above file, into your language.

I will fix this in SVN, and I'm very sorry for this.

by **Foxy** » Wed Apr 04, 2007 12:01 am

My fault! :-P

by **daddelkopp** » Wed Apr 04, 2007 1:25 am

Okay, every node got a continent, but nodeNumber is still 0. Is that correct? And I dont see any node, again.

Thanks for your hard work

daddelkopp

by **yojimbo2k** » Wed Apr 04, 2007 2:49 am

psykotyk wrote:
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

I have the same problem, look : http://www.guilde-parabellum.fr/roster/addons/gatherer/convertdb.php

And dont show the field for upload in my Update.php

Sorry i'm a french boy ^^

by **Borsti** » Wed Apr 04, 2007 3:59 am

yojimbo2k wrote:
psykotyk wrote:
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

These errors means there is no old database...

edit your update.php like this
ds001 wrote: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** » Wed Apr 04, 2007 11:37 am

If I update Gatherer.lua my roster tells me this errors. if I upload only Charakter.lua no errors will be show.
Using german Roster and hope all changes will be done
(include $wordings['deDE']['zonecont'] = array(
"STRANGLETHORN_VALE" => 2,)

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

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

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

by **Foxy** » Wed Apr 04, 2007 2:29 pm

Seems many of the issues being posted are either from missing zonecont array in the languages file, database issues or update.php issues.

I have updated the SVN and the Beta download package with the updated languages files... This should resolve the majority of the issues.

Additionally just to make it easy on your selves go ahead and drop the old database before using the Beta... The convertdb.php was included to convert it for you but if your submitting the same file again it won't really matter either way. Just remember to go to the roster and click the link for the Gatherer addon after dropping the old database and before uploading...

Bortsti:

Do you have this array in your language file? Between zones and node_names...

Code: Select all: $wordings['deDE']['zonecont'] = array( "ASHENVALE" => 1, "AZSHARA" => 1, "AZUREMYST_ISLE" => 1, "BARRENS" => 1, "BLOODMYST_ISLE" => 1, "DARKSHORE" => 1, "DARNASSUS" => 1, "DESOLACE" => 1, "DUROTAR" => 1, "DUSTWALLOW_MARSH" => 1, "FELWOOD" => 1, "FERALAS" => 1, "MOONGLADE" => 1, "MULGORE" => 1, "ORGRIMMAR" => 1, "SILITHUS" => 1, "STONETALON_MOUNTAINS" => 1, "TANARIS" => 1, "TELDRASSIL" => 1, "EXODAR" => 1, "THOUSAND_NEEDLES" => 1, "THUNDER_BLUFF" => 1, "UNGORO_CRATER" => 1, "WINTERSPRING" => 1, "ALTERAC_MOUNTAINS" => 2, "ARATHI_HIGHLANDS" => 2, "BADLANDS" => 2, "BLASTED_LANDS" => 2, "BURNING_STEPPES" => 2, "DEADWIND_PASS" => 2, "DUN_MOROGH" => 2, "DUSKWOOD" => 2, "EASTERN_PLAGUELANDS" => 2, "ELWYNN_FOREST" => 2, "EVERSONG_WOODS" => 2, "GHOSTLANDS" => 2, "HILLSBRAD_FOOTHILLS" => 2, "HINTERLANDS" => 2, "IRONFORGE" => 2, "LOCH_MODAN" => 2, "REDRIDGE_MOUNTAINS" => 2, "SEARING_GORGE" => 2, "SILVERMOON" => 2, "SILVERPINE_FOREST" => 2, "STORMWIND" => 2, "STRANGLETHORN_VALE" => 2, "SWAMP_OF_SORROWS" => 2, "TIRISFAL_GLADES" => 2, "UNDERCITY" => 2, "WESTERN_PLAGUELANDS" => 2, "WESTFALL" => 2, "WETLANDS" => 2, "BLADES_EDGE_MOUNTAINS" => 3, "HELLFIRE_PENINSULA" => 3, "NAGRAND" => 3, "NETHERSTORM" => 3, "SHADOWMOON_VALLEY" => 3, "SHATTRATH" => 3, "TEROKKAR_FOREST" => 3, "ZANGARMARSH" => 3 );

by **Tyradil** » Wed Apr 04, 2007 4:13 pm

But I think the zonecont array isn't necessary, because it only lists data which is already there in another way ...
You have one array called zones, which already contains these values.
In zonecont you have the area as key and the continent number as value.
In zones you have the continent number as key for another array and in there you have the area(s), but you have to look it up via array_key_exists, because the area is the key for another value in that array. (Hmm, sounds really confusing. ;-) )

So if you change functions.php, line 129 and line 194

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

and replace both lines with

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;

you can get completly rid of the zonecont array, and only have to keep zones up to date. (for the next addon or whatever ... ;-) )

Greetings
Tyradil

by **daddelkopp** » Wed Apr 04, 2007 8:34 pm

@Foxy: I delete the whole AddOn + DB Table. I download your fixed zipfile. In this zipfile

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

is not fixed. And in english local are some typos. I compare the old and the new download with BeyoundCompare.

After fixing, I upload the files to the server and the AddOn insert the DatabaseTable. Fine.

I upload my Carthographer Mining & Herbalism files. No Errors. The numbers for the continents are written to the DatabaseTable. But all nodes still does have nodeNumber = 0.

Sorry for my bad english and thanks for your time

daddelkopp

by **Borsti** » Wed Apr 04, 2007 9:39 pm

Foxy wrote:Bortsti:

Do you have this array in your language file? Between zones and node_names...

Code: Select all
$wordings['deDE']['zonecont'] = array( "ASHENVALE" => 1, "AZSHARA" => 1, "AZUREMYST_ISLE" => 1, );

Yes I have the changes done before...
I will test your new package.

Drop Database, Update all files and create new Entry in DB, edit Update.php Gatherer to gatherer
Updating Charakter profiler and Gatherer.lua gives errormessages

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

by **Foxy** » Thu Apr 05, 2007 6:06 am

Borsti other than the errors, is the data being inserted correctly? No missing data in any columns?

by **Foxy** » Thu Apr 05, 2007 6:19 am

@ Tyradil
Tested that local and ran it by Zeryl, this change will be included in the next package... Thanks for the info.

@ daddelkopp
Thus far you're the only one reporting missing column data... Just so we're on the same page, are you uploading the CharacterProfiler.lua along with your Cartographer files? What is your mySql version? What errors if any are showing on the update page?

by **Foxy** » Thu Apr 05, 2007 6:46 am

@ daddelkopp
What changes if any have you made to the files... please list them by file and then per file what changes... This is important!

I stopped by your site and checked this URL:
http://forum.kinder-der-sonne.net/roste ... esults.php

and found errors....

Warning: Cannot modify header information - headers already sent by (output started at /var/www/web736/html/phpBB2/roster/addons/gatherer/languages/deDE.php:1) in /var/www/web736/html/phpBB2/roster/addons/gatherer/results.php on line 36

So I wanted to check if you changed results.php or deDE.php

by **Borsti** » Thu Apr 05, 2007 11:10 am

Foxy wrote:Borsti other than the errors, is the data being inserted correctly? No missing data in any columns?

my Spots are shown up in Roster but my Wife becomes an other error message and her Data wouldn`t be insert completly (only 12 spots)

Notice: Undefined variable: rosterUpdateMessages in /var/www/wow/roster/update.php on line 596