帳號無法登入 依然是負資源的問題

許家豪@FB

$ X* X6 ~! w2 f: m/ \2 G! e用戶錯誤
8 g4 h- d0 q; z訊息: SQL錯誤： Out of range value for column 'metal' at row 1
8 E9 e  u: [0 K7 t
查詢代碼： LOCK TABLE uni1_planets as p WRITE, uni1_users as u WRITE; UPDATE uni1_planets as p, uni1_users as u SET p.metal = -1444538204.6976, p.crystal = -1963755854.4481, p.deuterium = 1347831682.3314, p.eco_hash = '6ea80716f967dec259ed4889b24cd0b3', p.last_update = 1440137127, p.b_building = '0', p.b_building_id = '', p.field_current = 294, p.b_hangar_id = '', p.metal_perhour = 1523109908.6729, p.crystal_perhour = 1431044288.0929, p.deuterium_perhour = 440460745.93045, p.metal_max = 2033500000000, p.crystal_max = 2033500000000, p.deuterium_max = 2033500000000, p.energy_used = -131788.07552324, p.energy = 8030844, p.b_hangar = 0, p.crystal_mine = p.crystal_mine + 3, p.metal_mine = p.metal_mine + 1, u.darkmatter = 145, u.b_tech = '1440139464', u.b_tech_id = '132', u.b_tech_planet = '21912', u.b_tech_queue = 'a:1:{i:0;a:5:{i:0;i:132;i:1;i:23;i:2;d:2337;i:3;d:1440139464;i:4;s:5:"21912";}}' WHERE p.id = 21912 AND u.id = 2170; UNLOCK TABLES;
檔案: /includes/classes/class.Database.php
2 H+ V. h) C* g4 l( N7 U% c7 x4 }行數: 280
4 ~# @- [; \7 r. |5 G: u網址: http://u1.myxnova.com/game.php
2 b. M6 ]+ v9 o( K1 XPHP-版本: 5.6.11
PHP-API: apache2handler
5 {2 E' t1 A$ d, VMySQL-客戶端-版本: mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
宇宙戰記版本: 1.3
除錯追蹤路徑:
4 E+ U0 L- P' {5 l9 i#0 /includes/classes/class.PlanetRessUpdate.php(722): Database->multi_query('LOCK TABLE uni1...')
: m5 a  O$ ^8 {; K( G#1 /includes/classes/class.PlanetRessUpdate.php(654): ResourceUpdate->SavePlanetToDB(Array, Array)
" k8 m" z! J3 ^& [, Q, S#2 /includes/classes/class.PlanetRessUpdate.php(534): ResourceUpdate->SetNextQueueTechOnTop()
$ `( b$ y& ~7 J& a' Y' I" u9 o7 V#3 /includes/classes/class.PlanetRessUpdate.php(97): ResourceUpdate->ResearchQueue()
5 {6 d$ [# b& f0 D( N7 G/ {" b$ ?! c#4 /includes/pages/game/class.AbstractPage.php(63): ResourceUpdate->CalcResource()
#5 /includes/pages/game/class.ShowOverviewPage.php(36): AbstractPage->__construct()
9 N7 j8 \) B3 |, y#6 /game.php(50): ShowOverviewPage->__construct()
/ _0 E3 w5 v1 q1 o! f" R2 D#7 {main}

admin

好了
已經解決
* ^& ^6 E1 S+ r$ w* |, u8 g  _- Q7 D
2 m0 t; F0 M8 z5 e% h9 R3 J. Z
, K  j, m# _' L4 h好吧
看來只改一個檔案是不行的
* l9 G9 T. r% n& T6 w要將所有會扣資源的地方
( e* Y0 b* b$ L$ N% p) N9 R都加上負值判斷代碼
這樣應該就不會再有錯誤
5 R3 F0 }% Z2 t3 [5 x$ y! x. {

2 `& }' G& z8 L+ x' G, p/ @就像星際財團頁輸入比自有資源多的數值
  z- [! G* o8 u: t+ H! k是不能成功購買的
9 Y- w* o  U3 R0 u* Z$ |1 [; @也就不會出現錯誤

$ x4 T) U- N+ W) w! o詳細說明請閱讀更新後的公告:
http://bbs.myxnova.com/thread-17201-1-1.html