Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #16  
Old 09-26-2007, 03:38 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

You can write anything you want - who knows - It may end up being a classic emu killer app.

Novel ways of doing things are my style - I tend to create apps with a sorta out of the box way of thinking - and that's with Rush or Triumph playing in the background...

GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #17  
Old 09-27-2007, 04:41 AM
Theeper
Discordant
 
Join Date: May 2004
Posts: 290
Default

Quote:
Originally Posted by GeorgeS
that's with Rush or Triumph playing in the background
I love you george.
Reply With Quote
  #18  
Old 09-29-2007, 10:27 PM
Lalolyen
Banned
 
Join Date: Aug 2007
Location: Sneeking up behind a admin IRL
Posts: 169
Default

I've been thinking about a web app to edit items using DHTML and maybe even switch/destory/add items to players with the DHTML.. Not sure how many people would actually like that and still trying to figure out how the hex blobs can be translated from the mysql database =S
Reply With Quote
  #19  
Old 10-06-2007, 01:02 PM
gernblan
Discordant
 
Join Date: Aug 2006
Posts: 394
Default

Probably the most important thing all serverops need right now is something that will allow them to easily browse, view (and even edit) coin on players.

That way, we at least have a way to look if players have been successful in doing any PP exploits and have ungodly amounts of coin stashed somewhere.

Heck, even an SQl query that would allow us to get into that blob and run a report of who has what would be a godsend!

Every character editor I've seen so far conveniently skips coin.
__________________
--
Keelyeh
Owner, ServerOp and Developer
Jest 4 Server
Linux (Jest3 runs on Fedora, our Dev servers usually run on Ubuntu and/or Gentoo), OC-12 Connection = Hella Fast
Reply With Quote
  #20  
Old 10-06-2007, 11:05 PM
Lalolyen
Banned
 
Join Date: Aug 2007
Location: Sneeking up behind a admin IRL
Posts: 169
Default

I'm not familiar with the blobs they are using... I've tried the reverse hexidecimal forumulas in php to decode the blobs to about 25% success...

Categorizing the blobs, setting it up in its own array is a pain in the ass by itself... coin, is one of those 75%'s I haven't had the time or patience to figure out yet =( *along with skills, flags, which I really want to be able to get into soon!*
Reply With Quote
  #21  
Old 10-07-2007, 04:06 AM
gernblan
Discordant
 
Join Date: Aug 2006
Posts: 394
Default

Yeah once that is sorted out and understood it will make everyones' lives much easier... because then maybe a tool can be created to be able to view/edit these things.

As far as EQEMU tools go, I think this sort of toolset is probably the most severely lacking out of anything.
__________________
--
Keelyeh
Owner, ServerOp and Developer
Jest 4 Server
Linux (Jest3 runs on Fedora, our Dev servers usually run on Ubuntu and/or Gentoo), OC-12 Connection = Hella Fast
Reply With Quote
  #22  
Old 10-13-2007, 04:24 AM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,474
Default

Everything can be figured out from the source cpp files. Took me an hour to figure out the binary blob struct - even tho im not an expert in c++, translating is not too hard.

I've got a tool working which can edit character profiles, including coins.

GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #23  
Old 10-13-2007, 05:29 AM
Windcatcher
Demi-God
 
Join Date: Jan 2002
Posts: 1,175
Default

My Admin tool up on Sourceforge can do much of this, but I haven't updated it in a while. The latest EQEmu version I've tested it with is 0.5.8. Maybe that can help you?
Reply With Quote
  #24  
Old 10-14-2007, 02:58 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

Yeah, Wind's tool can be more or else updated to work with the current EQEmu build. It's very flexible and is very lenient on new columns and such. The blob crap is stored in a text file for easy editing. I once had his tool updated, but once I took over PEQ I've strictly been on *nix so command line and PHP have been my way as of late. If I can find my altered version I'll post it (if that is OK, Wind) If not, as I said it isn't too hard to get up to date.
Reply With Quote
  #25  
Old 10-14-2007, 06:04 AM
Windcatcher
Demi-God
 
Join Date: Jan 2002
Posts: 1,175
Default

Go for it, cavedude
Reply With Quote
  #26  
Old 10-23-2007, 01:05 PM
gernblan
Discordant
 
Join Date: Aug 2006
Posts: 394
Default

Quote:
Originally Posted by GeorgeS View Post
Everything can be figured out from the source cpp files. Took me an hour to figure out the binary blob struct - even tho im not an expert in c++, translating is not too hard.

I've got a tool working which can edit character profiles, including coins.

GeorgeS
I have a dev server and am HAPPY to help you test the tool if you're up for it. PM me. I would have no problem trashing my test database for ya
__________________
--
Keelyeh
Owner, ServerOp and Developer
Jest 4 Server
Linux (Jest3 runs on Fedora, our Dev servers usually run on Ubuntu and/or Gentoo), OC-12 Connection = Hella Fast
Reply With Quote
  #27  
Old 10-23-2007, 01:06 PM
gernblan
Discordant
 
Join Date: Aug 2006
Posts: 394
Default

Quote:
Originally Posted by cavedude View Post
Yeah, Wind's tool can be more or else updated to work with the current EQEmu build. It's very flexible and is very lenient on new columns and such. The blob crap is stored in a text file for easy editing. I once had his tool updated, but once I took over PEQ I've strictly been on *nix so command line and PHP have been my way as of late. If I can find my altered version I'll post it (if that is OK, Wind) If not, as I said it isn't too hard to get up to date.
Been looking for it on sourceforge.. if it just needs structs updated, I'm willing to give it a shot for us.

Anyone got a link? We all know that searching on SF is the kiss of death
__________________
--
Keelyeh
Owner, ServerOp and Developer
Jest 4 Server
Linux (Jest3 runs on Fedora, our Dev servers usually run on Ubuntu and/or Gentoo), OC-12 Connection = Hella Fast
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 06:05 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3