I Want to be a DB editing freak !

[Wumpas]

Well I feel a bit more releaved heh

I learned alot about the database today and thanks to all the commands above by vbemos I acomplished alot for 1 day I think

Really all I did so far was set up a database that drops all the tables if they exist and starts clean and I used the db.sql for most of the creation strings I then went through TCSMyworld, Myras, 0.5.2-Update, latest dumpeditems and pasting them together with a TON of scrolling back and forth

Note: Also through in some fixes from the community like the object fix by Kroeg to fix the forge bag issues. (Before I release this im going to change all those values the right was ad delete the replace strings)

Im going to redue much of it tommorow and try to get my shopkeepers/bankers working My goal was a complete DB with Full shopkeepers from TCS as many spawns as I could get from Myras and movment to be added by me empty grid table (another fun project for me to do!)

Im not sure what tables could be causing merchants/bankers to tell me in not in the magician class guild any thoughts?

When I get to the point where I learned what I will from It ill try to post it if it is mostly functional

Also I am going to start editing zone points they are mostly corect or ballpark, but a few oddballs in the mix.

<note I have no idea how to post it as It is 32MB in size so far ! Ill zip it once I finish with it and see from there>

These are the tables I have so far am I missing any?

aa_timers
acount
altadv_vars
books
bugs
character_
character_backup
city_defence
class_skill
doors
eventlog
faction_list
faction_values
forage
grid
ground_spawns
guild_aliances
guild_controllers
guilds
hackers
items
lootdrop
lootdrop_entries
loottable
loottable_entries
merchantlist
name_filter
npc_faction
npc_faction-entries
npc_spells
npc_spells_entries
npc_types
object
object_contents
petitions
pets
player_corpses
player_corpses_backup
sharedbank
spawn2
spawnentry
spawngroup
start_zones
starting_items
trader
tradeskillrecipe
variables
zone
zone_points
zone_server
zone_state_dump
zonepoints_raw
zoneserver_auth

I think i got a basic handle on the tables and functions of them but How do i figure out what each field means? and in defining them what things like in(11) mean?

Thank you for the help

[vbemos]

Your magcian prob sounds like your spawning magicain trainers rather than merchants maybe

as for your question on field types they are loads, this seems to be a good defination: http://scibit.com/help/mascon/linux/...ield_types.htm

(*whew* save myself some work there =p)

and the bracketed number dictates field size i.e. varchar(13) is a variable length string.. max length 13 =)

[Wumpas]

Thank you Vbemos ill look back through the spawns right quick
im using Myras spawns mabe she hasnt gotten any of her shopkeeppers functioning yet wich is fine. I am going to have fun trying to figure out how to fix it. Thank you for the help with the field definitions and im going to go through that link too it look very helpfull !

[bud9weiser]

Wump, if you really want to learn the ins and outs of db editing jump on irc and join #npcmovdb and ill do what i can to help

[Wumpas]

Thanks Bud9wieser Im going to hop on there tommorow after work The help would be great then I can help you and tcs mabe if i learn enough. I didn't want to try jumping into helping you guys untill i learned my way around but since your willing to take a noob under the wing ill gladly join in !! (im curently trying to help Omper with race gender texture combinations) tommorows all database thoug My work hours are flexable ill probably bew back around 4 mabe hehe well see how it goes. if your not on then dont worry about it ill get on and check in and out every so often from now on.

sorry omper ill still run your script at night and get one zone a day ready for you guys they take forever to run i devoted most of my cpu cycles today

[bud9weiser]

Wump, i apologize for not being on yesterday, i ended up working really late, i should be around the rest of the week

[flyrken]

Well, looks like you are on your way to being a db editting freak, because you joined the right project.

:lol:
LOL


EOF

[Lurker_005]

vbemos posted some nice started examples for manipulating hte DB. Always learn the commands, it makes life so much easier as you learn and try to do more with them.

I also suggest you check out some of the tools posted in http://www.everquestserver.com/forum...ic.php?t=11105

Both for file editing/comparing, and the MYsql GUI apps that make viewing data SOOOOO much nicer. Note you still have to know the commands vbemos posted!

As far as merging Databases... that is really a tough on to do bucause there are so many issues involved. At the very least I imaging it would take wrighting an external application that would take all the data that is referanced by ID elsewhere in the DB, and combine it. Then go back and insert that into the existing DB.

This applies to spawns, loot, factions, vendors.... vendors are fairly easy, Get all the items for a given vendor, plus the vendor name, and zone. Then after you had merged the spawns you would have to look up the ID of the spawn that originally had it (based on name and zone) and apply the items to that vendor. But you also have to make sure you didn't duplicate items on a vendor... so you se even for a "simple" example there is a lot to do.