谢谢,最近在研究架设单机玩.

一切都还在有序研究中....

下午发现,解压需要密码....

帖子也没发现密码是多少?

谢谢!
从数据库追踪了一下,就是一条update语句,修改的都是同一个参数.

stefaniecc 发表于 2014-10-14 09:23
谢谢!
从数据库追踪了一下,就是一条update语句,修改的都是同一个参数.

对，其实它这个工具很简单。分享你几个比较实用的sql调炉命令
一 、单独调整暗金的炉子

1. UPDATE ITEM_UPGRADE SET nGenRate='100'
   
2. WHERE nOriginItem like '%7' AND  nReqItem1='379021000' AND nReqNoah='480000';
   
3. 
   
4. UPDATE ITEM_UPGRADE SET nGenRate='1000'
   
5. WHERE nOriginItem like '%6' AND nReqItem1='379021000' AND nReqNoah='480000';
   
6. 
   
7. UPDATE ITEM_UPGRADE SET nGenRate='4500'
   
8. WHERE nOriginItem like '%5' AND nReqItem1='379021000' AND nReqNoah='480000';
   
9. 
   
10. UPDATE ITEM_UPGRADE SET nGenRate='7500'
    
11. WHERE nOriginItem like '%4' AND nReqItem1='379021000' AND nReqNoah='480000';
    
12. 
    
13. UPDATE ITEM_UPGRADE SET nGenRate='9000'
    
14. WHERE nOriginItem like '%3' AND nReqItem1='379021000' AND nReqNoah='480000';
    
15. 
    
16. UPDATE ITEM_UPGRADE SET nGenRate='9500'
    
17. WHERE nOriginItem like '%2' AND nReqItem1='379021000' AND nReqNoah='480000';
    
18. 
    
19. 
    
20. UPDATE ITEM_UPGRADE SET nGenRate='200'
    
21. WHERE nOriginItem like '%7' AND nReqItem1='700002000' AND nReqItem2='379021000' AND nReqNoah='480000';
    
22. UPDATE ITEM_UPGRADE SET nGenRate='2000'
    
23. WHERE nOriginItem like '%6' AND nReqItem1='700002000' AND nReqItem2='379021000' AND nReqNoah='480000';
    
24. 
    
25. //普卷
    
26. UPDATE ITEM_UPGRADE SET nGenRate='5000'
    
27. WHERE nOriginItem like '%4' AND nReqItem1='379016000' ;
    
28. UPDATE ITEM_UPGRADE SET nGenRate='7000'
    
29. WHERE nOriginItem like '%3' AND nReqItem1='379016000' ;
    
30. UPDATE ITEM_UPGRADE SET nGenRate='8000'
    
31. WHERE nOriginItem like '%2' AND nReqItem1='379016000' ;
    
32. UPDATE ITEM_UPGRADE SET nGenRate='9500'
    
33. WHERE nOriginItem like '%1' AND nReqItem1='379016000' ;

复制代码

炉子多样化收费

1. -----普通物品普通卷轴
   
2. UPDATE ITEM_UPGRADE SET nReqNoah='20000'
   
3. WHERE  nOriginItem like '%1' AND  nReqItem1='379016000' AND nReqNoah='1000'
   
4. UPDATE ITEM_UPGRADE SET nReqNoah='30000'
   
5. WHERE  nOriginItem like '%2' AND  nReqItem1='379016000' AND nReqNoah='1000'
   
6. UPDATE ITEM_UPGRADE SET nReqNoah='40000'
   
7. WHERE  nOriginItem like '%3' AND  nReqItem1='379016000' AND nReqNoah='1000'
   
8. UPDATE ITEM_UPGRADE SET nReqNoah='500000'
   
9. WHERE  nOriginItem like '%4' AND  nReqItem1='379016000' AND nReqNoah='1000'
   
10. -----普通物品高卷
    
11. UPDATE ITEM_UPGRADE SET nReqNoah='200'
    
12. WHERE  nOriginItem like '%1' AND  nReqItem1='379021000' AND nReqNoah='1000'
    
13. UPDATE ITEM_UPGRADE SET nReqNoah='300'
    
14. WHERE  nOriginItem like '%2' AND  nReqItem1='379021000' AND nReqNoah='1000'
    
15. UPDATE ITEM_UPGRADE SET nReqNoah='400'
    
16. WHERE  nOriginItem like '%3' AND  nReqItem1='379021000' AND nReqNoah='1000'
    
17. UPDATE ITEM_UPGRADE SET nReqNoah='500'
    
18. WHERE  nOriginItem like '%4' AND  nReqItem1='379021000' AND nReqNoah='1000'
    
19. UPDATE ITEM_UPGRADE SET nReqNoah='600'
    
20. WHERE  nOriginItem like '%5' AND  nReqItem1='379021000' AND nReqNoah='1000'
    
21. UPDATE ITEM_UPGRADE SET nReqNoah='270000'
    
22. WHERE  nOriginItem like '%6' AND  nReqItem1='379021000' AND nReqNoah='1000'
    
23. UPDATE ITEM_UPGRADE SET nReqNoah='800000'
    
24. WHERE  nOriginItem like '%7' AND  nReqItem1='379021000' AND nReqNoah='1000'
    
25. 
    
26. -----暗金
    
27. UPDATE ITEM_UPGRADE SET nReqNoah='200000'
    
28. WHERE  nOriginItem like '%1' AND  nReqItem1='379021000' AND nReqNoah='480000'
    
29. UPDATE ITEM_UPGRADE SET nReqNoah='300000'
    
30. WHERE  nOriginItem like '%2' AND  nReqItem1='379021000' AND nReqNoah='480000'
    
31. UPDATE ITEM_UPGRADE SET nReqNoah='400000'
    
32. WHERE  nOriginItem like '%3' AND  nReqItem1='379021000' AND nReqNoah='480000'
    
33. UPDATE ITEM_UPGRADE SET nReqNoah='500000'
    
34. WHERE  nOriginItem like '%4' AND  nReqItem1='379021000' AND nReqNoah='480000'
    
35. UPDATE ITEM_UPGRADE SET nReqNoah='600000'
    
36. WHERE  nOriginItem like '%5' AND  nReqItem1='379021000' AND nReqNoah='480000'
    
37. UPDATE ITEM_UPGRADE SET nReqNoah='700000'
    
38. WHERE  nOriginItem like '%6' AND  nReqItem1='379021000' AND nReqNoah='480000'
    
39. UPDATE ITEM_UPGRADE SET nReqNoah='800000'
    
40. WHERE  nOriginItem like '%7' AND  nReqItem1='379021000' AND nReqNoah='480000'
    
41. ----暗金开光
    
42. UPDATE ITEM_UPGRADE SET nReqNoah='100000'
    
43. WHERE  nReqNoah='500000'
    

复制代码

调整炉子

1. UPDATE ITEM_UPGRADE SET nGenRate='10000'
   
2. WHERE nOriginItem like '%1' AND nReqItem1='379021000';
   
3. UPDATE ITEM_UPGRADE SET nGenRate='9000'
   
4. WHERE nOriginItem like '%2' AND nReqItem1='379021000';
   
5. UPDATE ITEM_UPGRADE SET nGenRate='5000'
   
6. WHERE nOriginItem like '%3' AND nReqItem1='379021000';
   
7. UPDATE ITEM_UPGRADE SET nGenRate='4000'
   
8. WHERE nOriginItem like '%4' AND nReqItem1='379021000';
   
9. UPDATE ITEM_UPGRADE SET nGenRate='2000'
   
10. WHERE nOriginItem like '%5' AND nReqItem1='379021000';
    
11. UPDATE ITEM_UPGRADE SET nGenRate='1000'
    
12. WHERE nOriginItem like '%6' AND nReqItem1='379021000';
    
13. UPDATE ITEM_UPGRADE SET nGenRate='300'
    
14. WHERE nOriginItem like '%7' AND nReqItem1='379021000';
    
15. 
    
16. 普通加新星
    
17. 
    
18. UPDATE ITEM_UPGRADE SET nGenRate='10000'
    
19. WHERE nOriginItem like '%1' AND nReqItem1='700002000' AND nReqItem2='379021000';
    
20. UPDATE ITEM_UPGRADE SET nGenRate='10000'
    
21. WHERE nOriginItem like '%2' AND nReqItem1='700002000' AND nReqItem2='379021000';
    
22. UPDATE ITEM_UPGRADE SET nGenRate='9500'
    
23. WHERE nOriginItem like '%3' AND nReqItem1='700002000' AND nReqItem2='379021000';
    
24. UPDATE ITEM_UPGRADE SET nGenRate='9000'
    
25. WHERE nOriginItem like '%4' AND nReqItem1='700002000' AND nReqItem2='379021000';
    
26. UPDATE ITEM_UPGRADE SET nGenRate='6000'
    
27. WHERE nOriginItem like '%5' AND nReqItem1='700002000' AND nReqItem2='379021000';
    
28. UPDATE ITEM_UPGRADE SET nGenRate='1300'
    
29. WHERE nOriginItem like '%6' AND nReqItem1='700002000' AND nReqItem2='379021000';
    
30. UPDATE ITEM_UPGRADE SET nGenRate='500'
    
31. WHERE nOriginItem like '%7' AND nReqItem1='700002000' AND nReqItem2='379021000';
    
32. 
    
33. 暗金
    
34. UPDATE ITEM_UPGRADE SET nGenRate='100'
    
35. WHERE nOriginItem like '%7' AND  nReqItem1='379021000' AND nReqNoah='240000';
    
36. UPDATE ITEM_UPGRADE SET nGenRate='500'
    
37. WHERE nOriginItem like '%6' AND nReqItem1='379021000' AND nReqNoah='240000';
    
38. UPDATE ITEM_UPGRADE SET nGenRate='1000'
    
39. WHERE nOriginItem like '%5' AND nReqItem1='379021000' AND nReqNoah='240000';
    
40. UPDATE ITEM_UPGRADE SET nGenRate='2000'
    
41. WHERE nOriginItem like '%4' AND nReqItem1='379021000' AND nReqNoah='240000';
    
42. UPDATE ITEM_UPGRADE SET nGenRate='6000'
    
43. WHERE nOriginItem like '%3' AND nReqItem1='379021000' AND nReqNoah='240000';
    
44. UPDATE ITEM_UPGRADE SET nGenRate='10000'
    
45. WHERE nOriginItem like '%2' AND nReqItem1='379021000' AND nReqNoah='240000';
    
46. UPDATE ITEM_UPGRADE SET nGenRate='10000'
    
47. WHERE nOriginItem like '%1' AND nReqItem1='379021000' AND nReqNoah='240000';
    
48. 
    
49. 暗金加星星
    
50. 
    
51. UPDATE ITEM_UPGRADE SET nGenRate='300'
    
52. WHERE nOriginItem like '%7' AND nReqItem1='700002000' AND nReqItem2='379021000' AND nReqNoah='240000';
    
53. UPDATE ITEM_UPGRADE SET nGenRate='2000'
    
54. WHERE nOriginItem like '%6' AND nReqItem1='700002000' AND nReqItem2='379021000' AND nReqNoah='240000';
    
55. UPDATE ITEM_UPGRADE SET nGenRate='6000'
    
56. WHERE nOriginItem like '%5' AND nReqItem1='700002000' AND nReqItem2='379021000' AND nReqNoah='240000';
    
57. UPDATE ITEM_UPGRADE SET nGenRate='4500'
    
58. WHERE nOriginItem like '%4' AND nReqItem1='700002000' AND nReqItem2='379021000' AND nReqNoah='240000';
    
59. UPDATE ITEM_UPGRADE SET nGenRate='7500'
    
60. WHERE nOriginItem like '%3' AND nReqItem1='700002000' AND nReqItem2='379021000' AND nReqNoah='240000';
    
61. UPDATE ITEM_UPGRADE SET nGenRate='10000'
    
62. WHERE nOriginItem like '%2' AND nReqItem1='700002000' AND nReqItem2='379021000' AND nReqNoah='240000';
    
63. UPDATE ITEM_UPGRADE SET nGenRate='10000'
    
64. WHERE nOriginItem like '%1' AND nReqItem1='700002000' AND nReqItem2='379021000' AND nReqNoah='240000';

复制代码

谢谢.其实这些都是些基本的SQL语句.

加上游戏的知识,很好理解的.

需要24W的就是暗金升级.
需要2个物品的就是+X的升级.


这些都是个显式的,很好理解.

一些隐性的炉子设置,暂时没有那方面的知识,待研究....

收了，多谢