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

許家豪@FB

; f+ }( m3 e( I1 K0 M+ F, \8 U用戶錯誤
/ [2 j) V& P! a+ r/ X' N& W) j訊息: SQL錯誤： Out of range value for column 'metal' at row 1
5 \* C$ v2 l5 g+ _. t" k0 s
0 L) T+ h( m5 U6 U8 I% d* ?7 D查詢代碼： 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
, ^8 q; K1 V4 T/ H8 T; J% e行數: 280
" o! K$ t, Q0 H' Z- Y網址: http://u1.myxnova.com/game.php
' y6 P5 V# l4 F2 [+ kPHP-版本: 5.6.11
PHP-API: apache2handler
* D* w6 g) c! l" W' s" w- vMySQL-客戶端-版本: mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
8 g" D/ L+ \+ O/ i6 ^. ^宇宙戰記版本: 1.3
9 \" m+ A) j. Z* F' B' m# s除錯追蹤路徑:
#0 /includes/classes/class.PlanetRessUpdate.php(722): Database->multi_query('LOCK TABLE uni1...')
2 y7 ^/ s% \2 u6 d$ h0 O5 K#1 /includes/classes/class.PlanetRessUpdate.php(654): ResourceUpdate->SavePlanetToDB(Array, Array)
8 x1 H1 [, A3 F5 `7 \1 F9 E5 f#2 /includes/classes/class.PlanetRessUpdate.php(534): ResourceUpdate->SetNextQueueTechOnTop()
#3 /includes/classes/class.PlanetRessUpdate.php(97): ResourceUpdate->ResearchQueue()
8 q3 t% p! Q! |# H. C#4 /includes/pages/game/class.AbstractPage.php(63): ResourceUpdate->CalcResource()
#5 /includes/pages/game/class.ShowOverviewPage.php(36): AbstractPage->__construct()
, q% i/ f) g: I1 J& m#6 /game.php(50): ShowOverviewPage->__construct()
#7 {main}
9 L2 Z9 S, @8 w( d7 v9 Y- u( L6 `

admin

好了
已經解決
' Y: O1 x9 j1 E2 Y* C  g, a

好吧
! Q- f/ J! T/ p' B# w! y看來只改一個檔案是不行的
* R% s" a# N5 K; r2 k; z  y% A要將所有會扣資源的地方
6 X# {8 S& @3 `都加上負值判斷代碼
. F' y$ X1 s: E! C6 f! w+ z7 I! q: |這樣應該就不會再有錯誤


就像星際財團頁輸入比自有資源多的數值
是不能成功購買的
也就不會出現錯誤
- @! j9 r: A7 t& r9 i5 B; I  Q
8 i6 v/ K6 g0 p詳細說明請閱讀更新後的公告:
http://bbs.myxnova.com/thread-17201-1-1.html