Ok so I went a little overboard in MYSQL database...

[Garraty24]

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.

[Astal]

Originally Posted by Garraty24

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.

get someone to source out their original table or, just make a seperate database, load the original peq one, source out the table, and source it in to your database

[lerxst2112]

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.

[trevius]

Notepad++ rocks for almost everything over any other editor ACCEPT for opening large files. For large files, I recommend trying Textpad instead.