Global Node Database

[SwInY]

Hey Guys,


about a month ago i started to create a global database with nodes XYZ in it.
ive decided im going to release to community and to try build up this database?

your prob thinking, So what a database with node locations?
there is alot you can do with this information.

the website for the database is this
http://botdata.wowgather.com/getlist.php

i really dont care if there is other ones out there,
and YES i do know there is wowhead and all them others....

internal static void InitRetreive()
        {
            try
            {
                HttpWebRequest myRequest = (HttpWebRequest)WebRequest.Create(sWebsite + "getlist.php");
                myRequest.Method = "GET";
                WebResponse myResponse = myRequest.GetResponse();
                StreamReader sr = new StreamReader(myResponse.GetResponseStream(), System.Text.Encoding.UTF8);

                string Type;
                string Name;
                float X;
                float Y;
                float Z;
                int ZoneID;
                int BlackList;

                while (true)
                {
                    string Line = sr.ReadLine();
                    string[] SplitLine = Line.Split(';');

                    Type = SplitLine[0];
                    if (Type == "END") break;
                    Name = SplitLine[1];
                    X = float.Parse(SplitLine[2]);
                    Y = float.Parse(SplitLine[3]);
                    Z = float.Parse(SplitLine[4]);
                    ZoneID = int.Parse(SplitLine[5]);
                    BlackList = int.Parse(SplitLine[6]);

                    if (NodeManager.DBExists(Type, Name, X, Y, Z, ZoneID) == false)
                    {
                        Utils.WriteDebug("WebManager Node Added - [{0}]   {1}, {2}, {3}", Name, X, Y, Z);
                        NodeManager.DBInsert(Type, Name, X, Y, Z, ZoneID, BlackList);
                    }
                }

                myResponse.Close();
            }
            catch (Exception e)
            {
                Utils.WriteDebug("WebManager - Init Error - Could not retrieve Global node list [Check Debug Log]");
                Utils.WriteDebug("WebManager - Init Error - " + e.Message);
            }
        }

i will be making this DB bigger over time as i need to,
if you would like the logging program to do a zone let me know

[lanman92]

This is a brilliant idea. Thank you for making this public.

My only recommendation would be to make the web interface more efficient. (i.e. use a binary format as opposed to string based)

[SwInY]

this will also be getting very populated in next coming couple of days. me and like 10 other people will be running the log tool and exploring.

this is a little stats thing we have atm
http://www.wowgather.com/

[miceiken]

You could throw in some work to make it more parsable, like encoding it with json?

[TOM_RUS]

Yeah, XML or JSON would be nice, so me can use Serializers, something like this:

public enum NodeType
{
    Herb,
    Mine
}

public class Node
{
    public NodeType NodeType { get; private set; }
    public string Name { get; private set; }
    public float X { get; private set; }
    public float Y { get; private set; }
    public float Z { get; private set; }
    public int Zone { get; private set; }
    public int Blacklist { get; private set; }
}

class Nodes
{
    public List<Node> MineNodes { get; private set; }
    public List<Node> HerbNodes { get; private set; }
}

Also, it's bad idea to store Name of the node as string because it's locale dependent and won't work on clients other then English.

[SwInY]

Yeah, XML or JSON would be nice, so me can use Serializers, something like this:

public enum NodeType
{
    Herb,
    Mine
}

public class Node
{
    public NodeType NodeType { get; private set; }
    public string Name { get; private set; }
    public float X { get; private set; }
    public float Y { get; private set; }
    public float Z { get; private set; }
    public int Zone { get; private set; }
    public int Blacklist { get; private set; }
}

class Nodes
{
    public List<Node> MineNodes { get; private set; }
    public List<Node> HerbNodes { get; private set; }
}

Also, it's bad idea to store Name of the node as string because it's locale dependent and won't work on clients other then English.

very good idea,
i will do this in next couple of days..

if you could link me some info on how to export on PHP how you would like it,
would be helpful just a push in right direction as i have never exported as such in PHP

and yeah, we learnt the hard way about english only, had a logger who was using german lanuage package. caused problems.
his now using english haha we found out german use "," instead of "."

the database has went from 2.5k to 5k nodes in around 4 hours.
so keep a eye out on it its growing fast.

also if you would like to help be a logger let me know.

[SwInY]

2.5k nodes to 8.5k nodes overnight

[jimmy06]

you mean something like this ?

http://www.retro-hosting.co.uk/test.php

[SwInY]

15k nodes.