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!

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

[gernblan]

Originally Posted by mattmeck

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.