DB Editing

[jdam7459]

Ok this is driving me insane!!! I am trying to change to starting zones for all characters and well, with the combinations of races classes and deities, it makes quite a few entries... and im tired of doing them one by one... does anyone know how to just copy and paste a certain value to certain rows and columns only...or just a faster way of doing this would be GREATLY appreciated...THANKS!

[mattmeck]

The class / race combo's are hard coded into the client, as are deities.

[kedra]

I am trying to change to starting zones for all characters and well, with the combinations of races classes and deities, it makes quite a few entries... and im tired of doing them one by one...

Assuming you have a populated start_zone table in your db, you could do the following:


UPDATE start_zone
SET zone_id = 'desired_zone_id'

Of course, you'd probably want to modify that to update the x, y, and z coordinates as well as the player's initial bind location.

[kedra]

I should mention,

It sounds like what you want to do is modify your table like a spreadsheet. This can be done, but it's ugly, slow, and could be done with much less trouble by simply running the query in my previous post.

To do it this way, you would need to use a program such as Navicat and copy the entire contents of a table to an excel spreadsheet. You will occasionally run into problems when attempting to paste certain types of data... You would then need to modify the data accordingly in excel, clear the appropriate data from the original table, then paste it in. It's very ugly and not very reliable, so I don't recommend this method.

[jdam7459]

Thanks for all the posts that helped more than you know it

- you have gotten better at preventing carpal tunnel! (47)

[ChaosSlayer]

get mySQL query browser/analyser of their official site - its free and it works very close to spreadsheet

[techguy84]

get mySQL query browser/analyser of their official site - its free and it works very close to spreadsheet

I disagree there. I use the QB and I find it a PAIN to use like a spreadsheet. To edit large amounts of data, as far as a DB goes. the best bet is like Kedra said. Query's are the way to go. I would be more leaning towards picking up a guide to MySQL querys and learning them as it will pay off greatly. One query can change a columns data for all rows, where as if you do it like a spreadsheet, you would have to go line to line to change it.

Now the features to view and edit individual information in a GUI interface would be good for things like the MOTD, XP rate, and among others. Or to troubleshoot certain NPC's, but to do mass data munipulation, query query query. Change all 0's to 3's or something like that.

Exporting to a Excel type spreadsheet for anything revolving around data munipulation is just a bad idea. Rulesets are lost in the translation, things wont copy right, like BLOB style fields that have no true viewable value like your character informaition. You'll have a very hard time trying this method but if you got the time, paitence and sanity to give it a shot, well, give it a shot.

Just my 2 cents on the subject though. Take it with a grain of salt as I can only go on what I currently know of MySQL as the noob that I am. I have tried all the above and I found that leaning a query for the thing your wanting to do is the best overall way to do it. Best of all, you can put that query in a txt file and just cut and paste later to repeat common task, or just excute the text file as a sql file and do the changes automatically.

[ChaosSlayer]

oh I totaly agree that Queries are the only way to go when you editing anything more than 20 lines of data.

No way i am manualy setting hps on all lev 37 mobs in the game, when query can do this instantly

but for single line editing having a nice gui table look is good- specialy when you want to compare the data of couple rows.

[John Adams]

Another great tool I use is SQLyog. Google it. It's cool.

[jdam7459]

XP rate

Speaking of xp rate (i know this is changing the subject but thanks for all the posts im learning query commands now!) is there an algorithm for xp rates. I'm trying to make quests that give good xp and idk the numbers to use because idk how much xp increases per lvl...

[kedra]

I don't know any algorithms, but you can use this:

Clicky (http://www.eqemulator.net/wiki/wikka.php?wakka=ExpByLevel)

[sonicintuition]

Back to the original question and for future reference:

I know it was answered but there is an even easier way than editing the database to set the starting zone for your server.

Open the command prompt and navigate to the directory in which your World.exe file is located in. Then type "world startzone zonename" without the quotes. There, done. Also be sure to use the zone's short name, not long name.

Regards,
Sonic

[jdam7459]

thanks for all the help i appreciate it!

[gernblan]

The class / race combo's are hard coded into the client, as are deities.

True, though it is possible to manually modify them on a toon by toon basis after the character is created though.

I play a DE shaman for the hell of it, for example.