Experienced Elementalist
- Joined
- Jan 3, 2008
- Messages
- 299
- Reaction score
- 1
Quick, easy query. Only did it because I want a stronger HB ![Wink ;) ;)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png)
Well, here you go. This will set your Forgotten Temple items to stats equivalent to present time USKO.
The only requirement for this query to work is that you already have the forgotten temple items already in your database(should be in every 1299 database, unless someone funked it up) because this script only updates. It doesn't make new rows, so you can avoid that duplicate error thingy(if you know what I mean).
![Wink ;) ;)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png)
Well, here you go. This will set your Forgotten Temple items to stats equivalent to present time USKO.
The only requirement for this query to work is that you already have the forgotten temple items already in your database(should be in every 1299 database, unless someone funked it up) because this script only updates. It doesn't make new rows, so you can avoid that duplicate error thingy(if you know what I mean).
Code:
update item set damage='82' where num='119101206'
update item set damage='88' where num='119101207'
update item set damage='97' where num='119101208'
update item set damage='110' where num='119101209'
update item set damage='130' where num='119101210'
update item set damage='82' where num='119101206'
update item set damage='87' where num='129101216'
update item set damage='93' where num='129101217'
update item set damage='102' where num='129101218'
update item set damage='115' where num='129101219'
update item set damage='135' where num='129101220'
update item set damage='161' where num='149101226'
update item set damage='169' where num='149101227'
update item set damage='181' where num='149101228'
update item set damage='199' where num='149101229'
update item set damage='227' where num='149101230'
update item set damage='111' where num='169101236'
update item set damage='117' where num='149101227'
update item set damage='126' where num='149101228'
update item set damage='139' where num='149101229'
update item set damage='159' where num='149101230'
update item set damage='85' where num='189101306'
update item set damage='91' where num='189101307'
update item set damage='100' where num='189101308'
update item set damage='113' where num='189101309'
update item set damage='133' where num='189101310'
update item set damage='85' where num='189101266'
update item set damage='91' where num='189201267'
update item set damage='100' where num='189201268'
update item set damage='113' where num='189201269'
update item set damage='133' where num='189201270'
update item set damage='85' where num='189301266'
update item set damage='91' where num='189301267'
update item set damage='100' where num='189301268'
update item set damage='113' where num='189301269'
update item set damage='133' where num='189301270'
update item set damage='80' where num='189401266'
update item set damage='86' where num='189301267'
update item set damage='95' where num='189301268'
update item set damage='108' where num='189301269'
update item set damage='128' where num='189301270'
update item set damage='112' where num='199101246'
update item set damage='118' where num='199101247'
update item set damage='127' where num='199101248'
update item set damage='140' where num='199101249'
update item set damage='160' where num='199101250'
Last edited by a moderator: