Question on the database

[mByte]

Ok first off here is what I want to do.

I want to be able to view all the enteries from the database items, zones, spawn information, character's and there information, as well as guild information.

so far I have gotten spawns, zone, and charater list.

Here is my question/problem
When pulling the blob field from the database I can return the lines that are in the text file with out the \0\0's. I am assuming its a binary field because only the binarywrite function works.

Now here is what I get

Leather TunicIT6363d



[Drawde]

If you want to edit the items, etc in the DB or view information on them, the best way I think is to use Windcatcher's EQEmu Admin program, there should be a link to it on the 3rd Party Tools forum.

[mByte]

Yea I use that but, It dosnt work on the web to view the information making it avaialbe to the players of the server.

Anybody know how to get in contact with windcatcher so I can create a com file or something.

[Drawde]

I see what you mean now, you want to put in code to view item info in-game. Sorry I can't help you with it as I've no idea how the binary item data is organised either (binary data is not my strong point programming-wise, to say the least)

[Trumpcard]

Im working on creating a emu specific admin tool that will allow you too play with this stuff from the web.. Im doing it because I wanted a way to mess with my database thats inside the firewall, so the solution was to write some PHP pages that would allow me to do it..

Now if I can just figure out how to handle BLOBS in PHP, I'll be good too go..

[ZeroDegrez]

BLOBS?

[Minara]

(B)inary (L)arge (O)(B)jects

[ZeroDegrez]

ahhh, makes more since now

Why not ask W.C. to let you add a net code to EQAdmin so you can access it remotely, if that is what you are trying to do...as i understand it.

[Trumpcard]

What i need to do is look at WC's sql calls to handle spreading out the columns in the BLOB. Dumping the raw data out, and i can see the values, just need to figure out how to properly sort them and edit them and get them back in.. never dealt with this struct before.

As far as the net code goes, his admin tool will work over the net (if the database is accessible from the outside world). Im doing this so I can make an editor to go over my firewall through the webserver

[mByte]

I wrote mine in a C# and compiled it into a COM file but stuck on the blobk filed

Anybody know where I can get the source file for the admin utility so I can see how the bolb field is done?

[Trumpcard]

Im pretty close to getting it working, I'll send you what Ive got once I get it completely in and feel comfortable I havent *%&^$ anything up.

[Yodason]

look at the structure for item_struct in the header file with all the structs in it =)