Adding an augment slot to armor pieces
I am still learning SQL context and queries, and hoping someone can teach me something here. I want to run a query on the database in the ITEMS table that:
I figure once I know how to format this query, I can make my own for other solutions. Thanks a ton in advance. |
It's been awhile since I dug around the database, this is rough and might not work but it looks ok - Somebody can probably chime in if my syntax is screwy..
Code:
update items set augslot2type=7 and augslot2visible=1 where augslot1type>0 and augslot2type=0 and reqlevel>54 AND damage=0 |
When I run that I get
Code:
1054 - Unknown column 'reqlvl' in 'where clause' |
EDIT: reqlevel, not reqlvl. I miss obvious things too much. Sorry aboot that
|
If you run that query in that order, you'll just add 2 augment slots to any item with 1 augment slot. You need to run them in reverse.
|
Even with both lines checking for a greater than zero in augslot2type in addition to the reqlevel check per query? I'll admit I'm self learned so I'm probably missing something, I'll read up a bit when I'm not exhausted. Thanks for the heads up Krabbers.
|
Yeah I had to fix it, but it taught me how to fix it by making this mistake after logging in and seeing what it did, then looking in the database. That, and I changed one of the armor aug slots to type 7 in Navicat and then looked at the bottom and it actually gives you a query for what you just did, that you can copy paste in a console and edit.
|
Apologies for gettin it backwards now I know. Plus that's a handy tip fridge, thanks to both of you.
|
All times are GMT -4. The time now is 05:04 PM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.