View Single Post
  #1  
Old 01-26-2002, 10:08 AM
hogger
Sarnak
 
Join Date: Jan 2002
Posts: 52
Default Oh, the power of ODBC!!!

Wow. That's about all I can say. Wow.

Some time in the past few days I decided that I'd prefer some more random spawns than was in Drawde's work (and excellent work it is). So, I dropped the spawn tables all together and went about making spawn groups by race and level. Quite a task, really. I got two of them done in an hour and a half last night. Orcs levels 1-3 and levels 4-5. Ug. That's when it hit me: I need to query this stuff.

Long story short, here's what worked best for me. I went to mysql.com and downloaded myodbc. I established table links with Access 97 (all I had here at home) and started playing around. As of right now I am running queries by race and level, using them to develop reports, veiwing those reports in Word, and copy-pasting my way to fuller spawn tables. In three hours today I did all the orcs, the goblins twice (I realized too late that Kunark goblins are not in the Misty Thicket). Plus I gave them all faction entries in about two minutes.

Pretty darn cool if I don't say so myself. If anyone out there would like to know any details, I'd be happy to provide them, but I need a break. Later I'm going on to Gnolls, Froglocks, etc.
Reply With Quote