Deprecated Darkstar fourms

Okay I've been adding numbers to theroam column in mob_group sql for over an hour. I've barely made a dent. There's gotta be a way to edit an entire column at once. I have sublime, visual, and notepad++. Who's my hero?

Notepad ++ ctrl+h?

use an sql query?

Yeah, we figured out how to write an update query.

Got another question though. How can I import a custom sql? Like, I have a custom item_mod sql that I usually just execute after item_mod, but I'd like to be able to add it so that it shows in Navicat and has its tables shown.

sql file is just a bunch of queries
since your queries have it'll run the queries on the item_mods table (since that's the table you're making changes to)

easiest way would be to write a separate SELECT query for your custom items and save it in navicat e.g.
SELECT * FROM item_mods WHERE itemid IN(itemid, anotheritemid, etc)

demolish wrote:sql file is just a bunch of queries
since your queries have

Code: Select all

UPDATE `item_mods`

it'll run the queries on the item_mods table (since that's the table you're making changes to)

easiest way would be to write a separate SELECT query for your custom items and save it in navicat e.g.
SELECT * FROM item_mods WHERE itemid IN(itemid, anotheritemid, etc)

Okay. Always learning something new lol. Thanks all.