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

許家豪@FB

' j/ `( i5 X/ v3 R; |) N$ U0 H2 M用戶錯誤
. ~  B3 ~* s1 ~訊息: SQL錯誤： Out of range value for column 'metal' at row 1

; w2 j. K4 P4 l0 J查詢代碼： 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;
. {/ V) B+ k1 Z7 t4 m* S" ^6 S檔案: /includes/classes/class.Database.php
; h+ b" B, ?+ Q行數: 280
網址: http://u1.myxnova.com/game.php
6 B* j* C) I' _# f- h2 PPHP-版本: 5.6.11
PHP-API: apache2handler
# @  O+ y3 P" l0 TMySQL-客戶端-版本: mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
& j; ?- W$ m& n+ W1 G3 `# h宇宙戰記版本: 1.3
除錯追蹤路徑:
9 i+ e0 G5 T5 A4 ^6 r0 l/ X#0 /includes/classes/class.PlanetRessUpdate.php(722): Database->multi_query('LOCK TABLE uni1...')
#1 /includes/classes/class.PlanetRessUpdate.php(654): ResourceUpdate->SavePlanetToDB(Array, Array)
8 [% v2 Q! d0 ]+ j' E' N#2 /includes/classes/class.PlanetRessUpdate.php(534): ResourceUpdate->SetNextQueueTechOnTop()
8 t2 z4 l5 a, H" s$ b#3 /includes/classes/class.PlanetRessUpdate.php(97): ResourceUpdate->ResearchQueue()
4 e+ h# r( H; ?0 n" w, }( I/ b2 f, O' t#4 /includes/pages/game/class.AbstractPage.php(63): ResourceUpdate->CalcResource()
#5 /includes/pages/game/class.ShowOverviewPage.php(36): AbstractPage->__construct()
#6 /game.php(50): ShowOverviewPage->__construct()
: Y( D4 t$ s8 Y% M; [, z; }#7 {main}
& G# |- g4 x) g: H. V

admin

好了
" T3 z* [6 _4 I: Q  ?2 X已經解決
: L$ U# T2 S% p7 Q( k7 \7 O

8 Z5 [  Z/ K7 E好吧
看來只改一個檔案是不行的
要將所有會扣資源的地方
都加上負值判斷代碼
3 e5 j( V. h2 w1 z4 W這樣應該就不會再有錯誤
1 E1 X1 ?! n* B, [! n$ @; a. E
: Z  E+ h1 v: F1 S( z
& P; G: z. M/ Y5 E+ a! ?8 }就像星際財團頁輸入比自有資源多的數值
8 h9 S" ?' [0 m  V% m- {$ x: D. I是不能成功購買的
也就不會出現錯誤
: w3 V% Y; \- p$ _
詳細說明請閱讀更新後的公告:
http://bbs.myxnova.com/thread-17201-1-1.html