EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)
-   -   Ok so I went a little overboard in MYSQL database... (https://www.eqemulator.org/forums/showthread.php?t=33536)

Garraty24 05-13-2011 09:13 AM

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.

Astal 05-13-2011 09:19 AM

Quote:

Originally Posted by Garraty24 (Post 199863)
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 05-13-2011 10:50 AM

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 05-16-2011 12:46 AM

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.