Ok so I went a little overboard in MYSQL database...
I think making myself a GM went to my head a little bit and actually made me think I knew how to work a database in the real world.
I wanted to make all of the alternate advancement skills available to all classes. It seemed to work on most but then I started noticing a lot of them was missing from all the classes (slay undead, endless quiver, ect) mainly class specific AAs. So is there a way to change that table back to the original PEQ table? Or at least fix my table somehow? Also can you edit a whole column at once in mysql? Say I wanted to make all of the rows the number "1" in the "wis" column. Also do I actually need to set up some of the spawns in certain zones? An example is Plane of Time B. If I go to potb nothing is spawned. |
Quote:
|
If you look in the peqdb_rev1751.sql file in an editor that doesn't freak out about opening a 150mb file (notepad++ will work, but it might be a little slow to initially load the file) you can find the statement to create the table you want along with the data. If you save that part out as a new file you should be able to drop the table in your current database and then source that file to restore it back.
I don't think there are any spawns in potimeb if you just zone there. You get sent there with a script when you click the pedestals that start the trials in potimea, and then the appropriate mobs are spawned. |
Notepad++ rocks for almost everything over any other editor ACCEPT for opening large files. For large files, I recommend trying Textpad instead.
|
All times are GMT -4. The time now is 04:46 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.