Aeria - Item Info SQL DB

Heya everyone, I made a program to generate SQL data from data in the game.
So so far we have Item Info :)...

There is still alot of data that exists that I have no idea what it is for hence the Uknown's in the sql file.

Just restore it into a MySQL Server to see the data. Ill be using this for the pserver but thought others might be able to use it for some cool php thing to view items characters have on them or a database of item lookups or something.
If you don't know how to do that then oh well :D

Ill try to do skill's and monsters later too.

Nice work Mega downloaded it going to look at later on today might play with some of the info and make somthing out of it.

Sweet try to match up some of the uknown data with stats you see on weapons and such please :).

Quote:

Originally Posted by Mega Byte Sweet try to match up some of the uknown data with stats you see on weapons and such please :).

hmm i don't know how you found this stuff, but it could be extremely useful! I wonder it's possible to make a script to gather this data from any item you point at/select/pickup and store in a database automatically.

Oh I had a thought last night while spamming ads about SBv3. I wonder if it's possible to send a chat message to a faction chat of another map. Example standing in saigo sending messages to faction chat for yanggok. I would love to find this info so I can advertise in on all maps using one character/script.

I gathered this data from the game's memory, by looking at what the function read when i moused over the image finding the structures and understanding what the bytes in the structures belonged too. Theres still uknown data though i found one out already :). Just gota match them up to items to see what is what.

Its possible to hook the function for mouse over or look at the items on ground etc and match them up to see if you want to loot it or not. Hence the main reason why I released this so people could think up those sorts of ideas.

However you wouldnt use SQL if you were making an auto looter you would just read it from the game's memory :).

But I have to learn about all this stuff some how and collect it.