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

許家豪@FB

用戶錯誤
9 }$ `' ?) C; L$ I訊息: SQL錯誤： Out of range value for column 'metal' at row 1
' D% k: O8 K. d5 g, u" N
0 G; C% |: {% ^查詢代碼： 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
# W, \! E& d& }! t: b/ u行數: 280
+ p4 u1 {: _' v網址: http://u1.myxnova.com/game.php
PHP-版本: 5.6.11
% V6 l: l, y7 TPHP-API: apache2handler
  e/ a+ J) A, ^" AMySQL-客戶端-版本: mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
/ I5 P  f) k6 T+ U2 y$ w; \宇宙戰記版本: 1.3
6 ?- H, \2 t" t: w0 J除錯追蹤路徑:
0 a3 j# [5 ~/ [0 E#0 /includes/classes/class.PlanetRessUpdate.php(722): Database->multi_query('LOCK TABLE uni1...')
3 V. m  `+ F' ?  S#1 /includes/classes/class.PlanetRessUpdate.php(654): ResourceUpdate->SavePlanetToDB(Array, Array)
$ h5 [7 K% B! t3 B8 j2 r. q#2 /includes/classes/class.PlanetRessUpdate.php(534): ResourceUpdate->SetNextQueueTechOnTop()
" x9 S: T! S% i  q% X  ?' g#3 /includes/classes/class.PlanetRessUpdate.php(97): ResourceUpdate->ResearchQueue()
#4 /includes/pages/game/class.AbstractPage.php(63): ResourceUpdate->CalcResource()
#5 /includes/pages/game/class.ShowOverviewPage.php(36): AbstractPage->__construct()
  F7 u: @1 _: B  R- E#6 /game.php(50): ShowOverviewPage->__construct()
3 \; u' F: J$ X* \3 ~9 a% S  y8 s' d; g#7 {main}

admin

好了
已經解決

* Y4 v$ i: v2 T% b1 w. G9 M2 M; \
7 c. ]! t4 C' l& B* p好吧
, \7 g7 \! q( p+ w; n看來只改一個檔案是不行的
3 l! q( l" m4 i+ y% W0 y* G要將所有會扣資源的地方
; U) Q; P1 {5 D3 V. u8 w0 M都加上負值判斷代碼
0 z# u- S2 a0 g6 x! P5 Z這樣應該就不會再有錯誤


. c" D$ a# L6 }# b" O' _; Y% q就像星際財團頁輸入比自有資源多的數值
是不能成功購買的
5 m" h/ Q, m* X: C4 y也就不會出現錯誤
1 T) ], L: g0 n9 h4 `8 l6 s
詳細說明請閱讀更新後的公告:
$ {4 m0 s3 c+ N. D. f; _http://bbs.myxnova.com/thread-17201-1-1.html