Gatherer v0.9 [Roster 1.7.3 addon]

Share Gatherer and Cartographer data via your Roster

Moderator: Foxy

Gatherer v0.9 [Roster 1.7.3 addon]

Postby Foxy » Sat Mar 31, 2007 6:51 pm

Gatherer v0.9 [Roster 1.7.3 addon]

This version has many changes!

First off the urls are all localized; this includes Zone images, and Zone selections.

Configuration changes for non-English -> array.php

Change only the full name and leave the index name.

For those of you with image location issues or even wrongly named files. Delete your current images and upload the packaged. I strongly recommend everyone do this.

The database has changed. In order to speed queries and move to a Normalized database we have removed columns method, uploads and nodeName.

Uploads might or might-not return to the database structure.

Duplicates check on upload has not been implemented.

SPECIAL THANKS:

Zeryl and Zanix for the quick localization fixes and the late night chit chat.
Last edited by Foxy on Sat Mar 31, 2007 7:37 pm, edited 1 time in total.
Foxy
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 111
Joined: Tue Aug 22, 2006 9:49 am

Gatherer v0.9 [Roster 1.7.3 addon]

Postby Deeo » Sat Mar 31, 2007 7:24 pm

404 Error
Deeo
WR.net Journeyman
WR.net Journeyman
 
Posts: 80
Joined: Mon Jul 10, 2006 2:02 pm

Gatherer v0.9 [Roster 1.7.3 addon]

Postby Foxy » Sat Mar 31, 2007 7:32 pm

Yeah sorry about that try again, I posted an update too soon...

MAJOR CHANGES!!!

Please delete all files you currently have and drop your database.

This is from scratch, all files changed, language localization, images added and renamed...

ENJOY!

Show Zanix & Zeryl some love, localization changes in a matter of hours :-D FAST PARSE & FAST LOADS!
Last edited by Foxy on Sat Mar 31, 2007 7:39 pm, edited 1 time in total.
Foxy
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 111
Joined: Tue Aug 22, 2006 9:49 am

Gatherer v0.9 [Roster 1.7.3 addon]

Postby Foxy » Sat Mar 31, 2007 7:33 pm

Need volunteers to translate the language files.
Foxy
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 111
Joined: Tue Aug 22, 2006 9:49 am

Gatherer v0.9 [Roster 1.7.3 addon]

Postby Foxy » Sat Mar 31, 2007 7:36 pm

Please check manually for duplicates, might still be an issue.
Foxy
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 111
Joined: Tue Aug 22, 2006 9:49 am

Gatherer v0.9 [Roster 1.7.3 addon]

Postby zeryl » Sun Apr 01, 2007 1:34 am

The way I set up the table and the queries, there should NEVER be a true duplicate.
User avatar
zeryl
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 194
Joined: Tue Jul 04, 2006 12:59 pm
Location: Saint Louis

Gatherer v0.9 [Roster 1.7.3 addon]

Postby zanix » Sun Apr 01, 2007 3:51 am

The real problem with dupes, is that the coords are so presise, that if one user uploads
x=0.2365
y=0.865

And the next user uploads
x=0.2364
y=0.865

They are not counted as dupes

What we need is to work out a range, or "Dupe Zone"
When a value is +- (a certain amount) to what we already have in the db, then skip it
It may also be a good idea to make the xPos and yPos fields in the db float values, instead of varchar(10)
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Gatherer v0.9 [Roster 1.7.3 addon]

Postby Borsti » Sun Apr 01, 2007 3:53 am

Foxy wrote:Need volunteers to translate the language files.


I think tomorrow i can release a deDe translation here :bigsmurf:
User avatar
Borsti
WR.net Journeyman
WR.net Journeyman
 
Posts: 87
Joined: Sat Jul 08, 2006 11:37 am
Location: Hamburg/Germany

Gatherer v0.9 [Roster 1.7.3 addon]

Postby zanix » Sun Apr 01, 2007 3:59 am

Also, languages/addon.php should not exist
All localization is in it's own file
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Gatherer v0.9 [Roster 1.7.3 addon]

Postby Foxy » Sun Apr 01, 2007 6:51 am

Zanix, I can verify there is duplicates... As for the "dupe zone" I'm checking with some mod authors that have this in their todo lists...

If there is a range, I'm sure it is a very small one and perhaps a round to the nearest whole number would be fine?
Foxy
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 111
Joined: Tue Aug 22, 2006 9:49 am

Gatherer v0.9 [Roster 1.7.3 addon]

Postby zeryl » Sun Apr 01, 2007 8:32 am

Only problem, is that how precise should it stay. I mean, I don't recall how much .001 is in WoW, but I'm sure there is a reason the precision is there.

What about an external process that can be run occasionally, and will pull all rows, and do some data checking. Not sure how time consuming that would be though.
User avatar
zeryl
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 194
Joined: Tue Jul 04, 2006 12:59 pm
Location: Saint Louis

Gatherer v0.9 [Roster 1.7.3 addon]

Postby Foxy » Sun Apr 01, 2007 8:40 am

External like a a cron job?
Foxy
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 111
Joined: Tue Aug 22, 2006 9:49 am

Re: Gatherer v0.9 [Roster 1.7.3 addon]

Postby Vasting » Sun Apr 01, 2007 9:53 am

Ok I went looking through the gatherer lua files to see what I could dig up... And here's a basic explanation shamelessly stolen from gatherer and Astrolabe (a library gatherer uses).
We'll take a mithril node at the top of my database for an example it's located at x=0.19387744, and y=0.60970711 and this is a mine in azshara so when you're reading the new data file and we get to a mine in azshara we would do an sql select query where the map, zone, nodeType, and nodeTypeWord are the same and it would return that node.
So we have a new coordinate uploaded that is located at x=0.19399000 and y=0.60842301 so lets see if they match up with the following formula:
Code: Select all
xDelta = (x2 - x1) * 1002;
yDelta = (y2 - y1) * 668;
dist = sqrt(xDelta*xDelta + yDelta*yDelta);

So using my example numbers above:
Code: Select all
xDelta = (0.19399 - 0.19387744) * 1002
yDelta = (0.60842301 - 0.60970711) * 668
dist = sqrt[(0.11278512 * 0.11278512) + -(0.8577788 * -0.8577788)]
dist = 0.865161807

if dist is greater than or = 1 then you've got a unique node. If it's less than or equal to 1 like in the case above where dist would be 0.865161807 then the node can be considered a duplicate.

Now I might be misinterpretting the way this is done. But that's what it looks like to me. I'd say code it up, backup your gatherer.lua savedvariable file and go find a mine that's already in there, but just before tapping it use the gatherer command to clear all node information to wipe the data clean then mine it. It should then record the gather to the savedvariables with a different location than before since gatherer takes the precise position the player is at as the location of the mine.
Vasting
WR.net Apprentice
WR.net Apprentice
 
Posts: 10
Joined: Thu Mar 22, 2007 12:32 am

Re: Gatherer v0.9 [Roster 1.7.3 addon]

Postby tnaflintman » Sun Apr 01, 2007 7:53 pm

update file??

Is there a update.php file so this can be added to the upload.
tnaflintman
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Sun Jul 23, 2006 7:51 pm

Re: Gatherer v0.9 [Roster 1.7.3 addon]

Postby zeryl » Mon Apr 02, 2007 12:30 am

Vasting wrote:Ok I went looking through the gatherer lua files to see what I could dig up... And here's a basic explanation shamelessly stolen from gatherer and Astrolabe (a library gatherer uses).
We'll take a mithril node at the top of my database for an example it's located at x=0.19387744, and y=0.60970711 and this is a mine in azshara so when you're reading the new data file and we get to a mine in azshara we would do an sql select query where the map, zone, nodeType, and nodeTypeWord are the same and it would return that node.
So we have a new coordinate uploaded that is located at x=0.19399000 and y=0.60842301 so lets see if they match up with the following formula:
Code: Select all
xDelta = (x2 - x1) * 1002;
yDelta = (y2 - y1) * 668;
dist = sqrt(xDelta*xDelta + yDelta*yDelta);

So using my example numbers above:
Code: Select all
xDelta = (0.19399 - 0.19387744) * 1002
yDelta = (0.60842301 - 0.60970711) * 668
dist = sqrt[(0.11278512 * 0.11278512) + -(0.8577788 * -0.8577788)]
dist = 0.865161807

if dist is greater than or = 1 then you've got a unique node. If it's less than or equal to 1 like in the case above where dist would be 0.865161807 then the node can be considered a duplicate.

Now I might be misinterpretting the way this is done. But that's what it looks like to me. I'd say code it up, backup your gatherer.lua savedvariable file and go find a mine that's already in there, but just before tapping it use the gatherer command to clear all node information to wipe the data clean then mine it. It should then record the gather to the savedvariables with a different location than before since gatherer takes the precise position the player is at as the location of the mine.


Wow, nice research. I'll see if I can get something going for a backend process to do this per continent.

Thanks a ton for that info.
User avatar
zeryl
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 194
Joined: Tue Jul 04, 2006 12:59 pm
Location: Saint Louis

Next

Return to Gatherer

Who is online

Users browsing this forum: No registered users and 0 guests

cron