New sql table create question

[moofta]

I'd also highly recommend installing the peq database editor using xampp (it's way easier than it sounds, but you might need to refer to the thread on the PEQ forum- peqtgc.com).

Other than the fact that it is a useful tool in it's own right, you can set sql logging=1 in the config. This means that it will log every query made against the peq database as you use the editor.

You can then look back through the logs to work out what queries were made to show the info you want. Some of the relationships like spawns, spawn groups, loot tables etc are relatively difficult to get your head round otherwise.

[AdrianD]

Thanks a bunch guys.

I have attempted to search for some things I want to change in the db such as skill_caps and spells_new but, my search was fruitless and I moved on to something I could actually accomplish. The main benefit to doing this stuff, even if there is a finished product out there that suits my needs, is that I'm very high on the learning curve and I imagine this will remain for some time. I could save a bunch of time by looking harder, although.

I have the db editor but I haven't installed it yet (see above). I'm sortof dividing my time on this project into making progress on my eqemu goal and learning about everything I have the patience for at that particular moment. They work hand-in-hand, yeah.

It's very duanting at times. I'm just a guy who does not work in the industry but has had a fleeting memory ergo, a vision for what is now possible.

Coming up with queries to change 50k lines in a tiny fraction of the time it would take to manually enter is gratifying, considering I thought a query was like a question two weeks ago.

Thank you for your help.

[moofta]

It might be worth grabbing a copy of something like "SQL for dummies" or "SQL in 24 hours" because your first hurdle is learning how to use SQL in the first place( http://it-ebooks.info/book/1498/ is free and I think, legit).

I basically learnt from a book like that before I went to college, 20 years down the line I'm STILL having to google this stuff from time to time