- 精华
- 阅读权限
- 120
- 好友
- 相册
- 分享
- 听众
- 收听
- 注册时间
- 2014-11-17
- 在线时间
- 小时
- 最后登录
- 1970-1-1
|
发表于 2016-12-28 16:00:16
|
显示全部楼层
一串代码可以把宝石颜色说明纠正,懂数据库的用用吧。对此端适用,不保证对所有端适用。
update item_template
set description=replace(description,'对应黄色插槽','对应红色插槽'), description=replace(description,'对应蓝色插槽','对应红色插槽'), description=replace(description,'对应红色或黄色插槽','对应红色插槽'), description=replace(description,'对应红色或蓝色插槽','对应红色插槽'), description=replace(description,'对应黄色或蓝色插槽','对应红色插槽')
Where class=3 and subclass=0;
update item_template
set description=replace(description,'对应黄色插槽','对应蓝色插槽'), description=replace(description,'对应红色插槽','对应蓝色插槽'), description=replace(description,'对应红色或黄色插槽','对应蓝色插槽'), description=replace(description,'对应红色或蓝色插槽','对应蓝色插槽'), description=replace(description,'对应黄色或蓝色插槽','对应蓝色插槽')
Where class=3 and subclass=1;
update item_template
set description=replace(description,'对应红色插槽','对应黄色插槽'), description=replace(description,'对应蓝色插槽','对应黄色插槽'), description=replace(description,'对应红色或黄色插槽','对应黄色插槽'), description=replace(description,'对应红色或蓝色插槽','对应黄色插槽'), description=replace(description,'对应黄色或蓝色插槽','对应黄色插槽')
Where class=3 and subclass=2;
update item_template
set description=replace(description,'对应红色插槽','对应红色或蓝色插槽'), description=replace(description,'对应黄色插槽','对应红色或蓝色插槽'), description=replace(description,'对应蓝色插槽','对应红色或蓝色插槽'), description=replace(description,'对应黄色或蓝色插槽','对应红色或蓝色插槽'), description=replace(description,'对应红色或黄色插槽','对应红色或蓝色插槽')
Where class=3 and subclass=3;
update item_template
set description=replace(description,'对应红色插槽','对应黄色或蓝色插槽'), description=replace(description,'对应黄色插槽','对应黄色或蓝色插槽'), description=replace(description,'对应蓝色插槽','对应黄色或蓝色插槽'), description=replace(description,'对应红色或蓝色插槽','对应黄色或蓝色插槽'), description=replace(description,'对应红色或黄色插槽','对应黄色或蓝色插槽')
Where class=3 and subclass=4;
update item_template
set description=replace(description,'对应红色插槽','对应红色或黄色插槽'), description=replace(description,'对应黄色插槽','对应红色或黄色插槽'), description=replace(description,'对应蓝色插槽','对应红色或黄色插槽'), description=replace(description,'对应黄色或蓝色插槽','对应红色或黄色插槽'), description=replace(description,'对应红色或蓝色插槽','对应红色或黄色插槽')
Where class=3 and subclass=5; |
|