Very cool ! Thats exactly what I need...
I had tried using unpack before (just too display the blob into column seperated field), but I have a feeling I was screwing something up in the usage.
Since you did it with the character table, I shouldnt have too much trouble doing it for the items/character table. Just need to do my pack()/unpack() homework a bit.
Thanks a ton Hogie!
If you get the chance, mind sending me a snippet of the code you use too display the data once you nab it from the database, that way I will have a practical example of how unpack's used?
I wrote a few general pages/scripts that will display all tables, and allow you too edit them all. . It's general enough that it will pick up any new tables that are added from release to release, without having to add componets or change anything in the configuration.. It basically grabs all the tables out of the database, gives you a view/add/search option for all of them, then formats those operations based on the indivudual table structure. The only ones it doesnt work for are tables that contain blob structs (char. and items only I think).
I was trying to make a framework that was close to myPhpAdmin , but tailored for the eq database, but general and customizable enough I could use for any database. I have quite a few databases that I run, so wanted to make something I could port over to be a tool for any of the others ones without having to rewrite anything.
|