[問題]水怪RPG之問題

phpBB 2 MOD Support
無論是官方或非官方認證之外掛，安裝與使用問題討論。
(發表文章請按照公告格式發表，違者砍文)

版主: 版主管理群

主題已鎖定
Furlong
星球普通子民
星球普通子民
文章: 18
註冊時間: 2002-06-03 19:59

[問題]水怪RPG之問題

文章 由 Furlong »

我安裝完依夢兒大大的水怪整合版後
可以發文章...
卻不能看文章耶... :cry:

出現訊息如下....請各位幫幫我... :-(

Could not obtain post/user information.

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'u.user_robfail, u.rpg_level, u.rpg_cur_hp, u.rpg_max_hp, u.rpg_cur_mp, u.rpg_max' at line 1

SELECT u.username, u.user_money, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile,,u.user_robfail, u.rpg_level, u.rpg_cur_hp, u.rpg_max_hp, u.rpg_cur_mp, u.rpg_max_mp, u.rpg_cur_exp, u.rpg_max_exp, u.rpg_attack, u.rpg_defense, u.rpg_magic, u.rpg_speed, u.rpg_medals p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 10 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 396
File : /home/www/bime94/supersky/www/phpbb/viewtopic.php
回頂端
吉川拓也
竹貓忠實會員
竹貓忠實會員
文章: 1215
註冊時間: 2003-02-09 18:24
來自: [ G.I.T ]
聯繫:
聯繫 吉川拓也

Re: [問題]水怪RPG之問題

文章 由 吉川拓也 »

Furlong 寫:我安裝完依夢兒大大的水怪整合版後
可以發文章...
卻不能看文章耶... :cry:

出現訊息如下....請各位幫幫我... :-(

Could not obtain post/user information.

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'u.user_robfail, u.rpg_level, u.rpg_cur_hp, u.rpg_max_hp, u.rpg_cur_mp, u.rpg_max' at line 1

SELECT u.username, u.user_money, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile,,u.user_robfail, u.rpg_level, u.rpg_cur_hp, u.rpg_max_hp, u.rpg_cur_mp, u.rpg_max_mp, u.rpg_cur_exp, u.rpg_max_exp, u.rpg_attack, u.rpg_defense, u.rpg_magic, u.rpg_speed, u.rpg_medals p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 10 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 396
File : /home/www/bime94/supersky/www/phpbb/viewtopic.php
請問你執行 sql 了嗎 ?
善用 搜尋 可以解決您 90% 的問題
頭腦清晰，選擇正確。 (╯▔︹▔)╯~╘═╛
回頂端
hk_andy_hk
星球公民
星球公民
文章: 93
註冊時間: 2002-10-31 14:23
來自: CrAzY ZoNe
聯繫:
聯繫 hk_andy_hk

文章 由 hk_andy_hk »

SELECT u.username, u.user_money, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile,,u.user_robfail, u.rpg_level, u.rpg_cur_hp, u.rpg_max_hp, u.rpg_cur_mp, u.rpg_max_mp, u.rpg_cur_exp, u.rpg_max_exp, u.rpg_attack, u.rpg_defense, u.rpg_magic, u.rpg_speed, u.rpg_medals p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 10 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

紅字的地方出現了兩個 "," 刪除其中一個吧\r
綠字後方又少了一個 "," 加上去吧~
圖檔
http://crazy-zone.com
CrAzY ZoNe 已轉換到v4.5了~

http://crazy-zone.com/topsitesphp/index.php
小站的登錄及投票系統
回頂端
jessie
星球公民
星球公民
文章: 149
註冊時間: 2004-03-05 19:49
來自: Fann.City
聯繫:
聯繫 jessie

文章 由 jessie »

Fatal error: Call to undefined function: levelup() in c:\appserv\www\phpbb\includes\functions_post.php on line 503
可否幫我看看是哪裡有問題..

代碼: 選擇全部

   if ($mode != 'poll_delete') 
   { 
      // 水怪 RPG 
      if ( $mode == "newtopic" ) 
      { 
         $reward_sql = ", rpg_cur_hp = rpg_cur_hp - 3, rpg_cur_mp = rpg_cur_mp - 3, rpg_cur_exp = rpg_cur_exp + 3"; // 發表主題 HP - 3 , MP - 3 , 經驗值 + 3 
      } 
      if ( $mode == "reply" ) 
      { 
         $reward_sql = ", rpg_cur_hp = rpg_cur_hp - 2, rpg_cur_mp = rpg_cur_mp - 2, rpg_cur_exp = rpg_cur_exp + 2"; // 回覆文章 HP - 2 , MP - 2 , 經驗值 + 2 
      } 
      $sql = "UPDATE " . USERS_TABLE . " 
         SET user_posts = user_posts $sign $reward_sql 
         WHERE user_id = $user_id"; 
      if (!$db->sql_query($sql, END_TRANSACTION)) 
      { 
         message_die(GENERAL_ERROR, 'Error in posting' . $sql, '', __LINE__, __FILE__, $sql); 
      } 
[color=red]      LevelUp($user_id); [/color]
   } 
   return;

-----
幫妳將關鍵行標記出來了...下次請不要將整個檔案貼上來 ^^|| 那樣很佔空間 ~ by 動機
●架設主機作業系統：WindowsXP
●快速架站程式：Appserv2.3.0
●上網方式：中華電信ADSL
●安裝的程式：Apache + php + MySql
●phpBB2 版本： 2.0.8a
●安裝的外掛
圖檔
回頂端
jessie
星球公民
星球公民
文章: 149
註冊時間: 2004-03-05 19:49
來自: Fann.City
聯繫:
聯繫 jessie

文章 由 jessie »

to動機:下次改進\r
那麼請問怎麼修正呢?
●架設主機作業系統：WindowsXP
●快速架站程式：Appserv2.3.0
●上網方式：中華電信ADSL
●安裝的程式：Apache + php + MySql
●phpBB2 版本： 2.0.8a
●安裝的外掛
圖檔
回頂端
jessie
星球公民
星球公民
文章: 149
註冊時間: 2004-03-05 19:49
來自: Fann.City
聯繫:
聯繫 jessie

文章 由 jessie »

代碼: 選擇全部

   if ($mode != 'poll_delete') 
   { 
      // 水怪 RPG 
      if ( $mode == "newtopic" ) 
      { 
         $reward_sql = ", rpg_cur_hp = rpg_cur_hp - 3, rpg_cur_mp = rpg_cur_mp - 3, rpg_cur_exp = rpg_cur_exp + 3"; // 發表主題 HP - 3 , MP - 3 , 經驗值 + 3 
      } 
      if ( $mode == "reply" ) 
      { 
         $reward_sql = ", rpg_cur_hp = rpg_cur_hp - 2, rpg_cur_mp = rpg_cur_mp - 2, rpg_cur_exp = rpg_cur_exp + 2"; // 回覆文章 HP - 2 , MP - 2 , 經驗值 + 2 
      } 
      $sql = "UPDATE " . USERS_TABLE . " 
         SET user_posts = user_posts $sign $reward_sql 
         WHERE user_id = $user_id"; 
      if (!$db->sql_query($sql, END_TRANSACTION)) 
      { 
         message_die(GENERAL_ERROR, 'Error in posting' . $sql, '', __LINE__, __FILE__, $sql); 
      } 
[color=red]      LevelUp($user_id); [/color]
   } 
   return;

請問紅色的部分要怎麼改?
●架設主機作業系統：WindowsXP
●快速架站程式：Appserv2.3.0
●上網方式：中華電信ADSL
●安裝的程式：Apache + php + MySql
●phpBB2 版本： 2.0.8a
●安裝的外掛
圖檔
回頂端
吉川拓也
竹貓忠實會員
竹貓忠實會員
文章: 1215
註冊時間: 2003-02-09 18:24
來自: [ G.I.T ]
聯繫:
聯繫 吉川拓也

文章 由 吉川拓也 »

把這段 :
[php]<?php
}
LevelUp($user_id);
}
?>[/php]

取代成 :
[php]<?php
}
LevelUp_post($user_id);
}
?>[/php]
善用 搜尋 可以解決您 90% 的問題
頭腦清晰，選擇正確。 (╯▔︹▔)╯~╘═╛
回頂端
jessie
星球公民
星球公民
文章: 149
註冊時間: 2004-03-05 19:49
來自: Fann.City
聯繫:
聯繫 jessie

文章 由 jessie »

改了...
Fatal error: Call to undefined function: levelup_post() in c:\appserv\www\phpbb\includes\functions_post.php on line 503

代碼: 選擇全部

if ($mode != 'poll_delete')
	{
		// 水怪 RPG
		if ( $mode == "newtopic" )
		{
			$reward_sql = ", rpg_cur_hp = rpg_cur_hp - 3, rpg_cur_mp = rpg_cur_mp - 3, rpg_cur_exp = rpg_cur_exp + 3"; // 發表主題 HP - 3 , MP - 3 , 經驗值 + 3
		}
		if ( $mode == "reply" )
		{
			$reward_sql = ", rpg_cur_hp = rpg_cur_hp - 2, rpg_cur_mp = rpg_cur_mp - 2, rpg_cur_exp = rpg_cur_exp + 2"; // 回覆文章 HP - 2 , MP - 2 , 經驗值 + 2
		}
		$sql = "UPDATE " . USERS_TABLE . "
			SET user_posts = user_posts $sign $reward_sql
			WHERE user_id = $user_id";
		if (!$db->sql_query($sql, END_TRANSACTION))
		{
			message_die(GENERAL_ERROR, 'Error in posting' . $sql, '', __LINE__, __FILE__, $sql);
		}
		LevelUp_post($user_id);
	}
●架設主機作業系統：WindowsXP
●快速架站程式：Appserv2.3.0
●上網方式：中華電信ADSL
●安裝的程式：Apache + php + MySql
●phpBB2 版本： 2.0.8a
●安裝的外掛
圖檔
回頂端
吉川拓也
竹貓忠實會員
竹貓忠實會員
文章: 1215
註冊時間: 2003-02-09 18:24
來自: [ G.I.T ]
聯繫:
聯繫 吉川拓也

文章 由 吉川拓也 »

請再加入判斷升級 :

代碼: 選擇全部

//以下判斷升級 
function UpdateRPGProperties_Post($uid) 
{ 
   global $db; 

   $attplus = 1.0; 
   $defplus = 1.0; 
   $magplus = 1.0; 
   $spdplus = 1.0; 
   $hp_plus = 0.0; 
   $mp_plus = 0.0; 
   $sql = 'SELECT MAX(position_order) as basetop FROM phpbb_rpg_position WHERE position_class = 0'; 
   if ( !($result = $db->sql_query($sql)) ) 
   { 
      message_die(GENERAL_ERROR, '無法取得基礎職業屬性!!', '', __LINE__, __FILE__, $sql); 
   } 
   if ( $row = $db->sql_fetchrow($result) ) 
   { 
      $sql = 'SELECT * FROM phpbb_rpg_position WHERE position_class = 0 AND position_order = ' . $row['basetop']; 
      if ( !($result = $db->sql_query($sql)) ) 
      { 
         message_die(GENERAL_ERROR, '無法取得基礎職業屬性!!', '', __LINE__, __FILE__, $sql); 
      } 
      if ( $row = $db->sql_fetchrow($result) ) 
      { 
         // 取得基礎職業的標準值 
         $base_att = $row['attack_property']; 
         $base_def = $row['defense_property']; 
         $base_mag = $row['magic_property']; 
         $base_spd = $row['speed_property']; 
         $base_hpp = $row['hp_property']; 
         $base_mpp = $row['magic_property']; 
      } 
      $sql = 'SELECT p.* FROM phpbb_rpg_position p, phpbb_rpg_medals m WHERE p.position_class = m.position_class 
         AND p.position_order = m.position_order AND m.last_class = 1 AND m.position_class <> 0 AND m.user_id = ' . $uid; 
      if ( !($result = $db->sql_query($sql)) ) 
      { 
         message_die(GENERAL_ERROR, '無法取得專業職業屬性!!', '', __LINE__, __FILE__, $sql); 
      } 
      if ( $row = $db->sql_fetchrow($result) ) 
      { 
         $i = 1; 
         $newposition = ''; 
         do 
         { 
            if ($i == 1) 
            { 
               $attplus = $row['attack_property']; 
               $defplus = $row['defense_property']; 
               $magplus = $row['magic_property']; 
               $spdplus = $row['speed_property']; 
               $hp_plus = $row['hp_property']; 
               $mp_plus = $row['magic_property']; 
               $newposition = $row['position_name']; 
            } 
            else 
            { 
               $attplus += $row['attack_property'] - $base_att; 
               $defplus += $row['defense_property'] - $base_def; 
               $magplus += $row['magic_property'] - $base_mag; 
               $spdplus += $row['speed_property'] - $base_spd; 
               $hp_plus += $row['hp_property'] - $base_hpp; 
               $mp_plus += $row['magic_property'] - $base_mpp; 
               $newposition .= '<br />' . $row['position_name']; 
            } 
            $i++; 
         } 
         while ( $row = $db->sql_fetchrow($result) ); 

         if(strlen($newposition) > 200) 
         { 
            $newposition = substr($newposition, 0, 200); 
         } 
      } 
      else 
      { 
         // 只有基礎職業 
         $sql = 'SELECT p.* FROM phpbb_rpg_position p, phpbb_rpg_medals m WHERE p.position_class = 0 AND m.last_class = 1 
            AND m.position_class = 0 AND p.position_order = m.position_order AND m.user_id = ' . $uid; 
         if ( !($result = $db->sql_query($sql)) ) 
         { 
            message_die(GENERAL_ERROR, '無法取得基礎職業屬性!!', '', __LINE__, __FILE__, $sql); 
         } 
         if ( $row = $db->sql_fetchrow($result) ) 
         { 
            $attplus = $row['attack_property']; 
            $defplus = $row['defense_property']; 
            $magplus = $row['magic_property']; 
            $spdplus = $row['speed_property']; 
            $hp_plus = $row['hp_property']; 
            $mp_plus = $row['magic_property']; 
            $newposition = $row['position_name']; 
         } 
      } 
   } 

   $sql = 'SELECT IFNULL(SUM(i.attack_property), 0) as attack_x, IFNULL(SUM(i.defense_property), 0) as defense_x, 
      IFNULL(SUM(i.magic_property), 0) as magic_x, IFNULL(SUM(i.speed_property), 0) as speed_x, 
      IFNULL(SUM(i.hp_property), 0) as hp_x, IFNULL(SUM(i.mp_property), 0) as mp_x FROM phpbb_rpg_items i, 
      phpbb_rpg_owns o WHERE i.item_id = o.item_id AND o.user_id = ' . $uid; 
   if ( !($result = $db->sql_query($sql)) ) 
   { 
      message_die(GENERAL_ERROR, '無法取得攜帶物品屬性!!', '', __LINE__, __FILE__, $sql); 
   } 
   if ( $row = $db->sql_fetchrow($result) ) 
   { 
      $attplus += $row['attack_x']; 
      $defplus += $row['defense_x']; 
      $magplus += $row['magic_x']; 
      $spdplus += $row['speed_x']; 
      $hp_plus += $row['hp_x']; 
      $mp_plus += $row['mp_x']; 
   } 

   $sql = "update phpbb_users set rpg_max_hp = floor(rpg_level * (100 + $hp_plus + rpg_level)), 
      rpg_max_mp = floor(rpg_level * (80 + rpg_level) + rpg_level * $mp_plus), 
      rpg_attack = round(rpg_level * $attplus), rpg_defense = round(rpg_level * $defplus), 
      rpg_magic = round(rpg_level * $magplus), rpg_speed = round(rpg_level * $spdplus), 
      rpg_medals = '$newposition' where user_id = $uid"; 
   if ( !($result = $db->sql_query($sql)) ) 
   { 
      message_die(GENERAL_ERROR, '無法更新 RPG 屬性!!', '', __LINE__, __FILE__, $sql); 
   } 
} 


function LevelUp_Post($uid, $full_mh = false) 
{ 
   global $db; 

   $sql = "select rpg_level, rpg_cur_exp, rpg_max_exp from phpbb_users where user_id = $uid"; 
   $result = $db->sql_query($sql); 
   if ( $row2 = $db->sql_fetchrow($result) ) 
   { 
      if ( $row2['rpg_cur_exp'] >= $row2['rpg_max_exp'] ) 
      { 
         if ( $row2['rpg_level'] < 250 ) 
         { 
            $sql = "update phpbb_users set rpg_level = rpg_level + 1, rpg_cur_exp = rpg_cur_exp - rpg_max_exp, rpg_cur_hp = rpg_max_hp, rpg_cur_mp = rpg_max_mp, 
               rpg_max_exp = FLOOR( POW( 10, POW( rpg_level, (1/3) ) ) ) - FLOOR( POW( 10, POW( rpg_level - 1, (1/3) ) ) ) 
               where user_id = $uid"; 
            $db->sql_query($sql); 
            UpdateRPGProperties_Post($uid); 
         } 
         if ( $full_mh ) 
         { 
            $sql = "update phpbb_users set rpg_cur_hp = rpg_max_hp, rpg_cur_mp = rpg_max_mp where user_id = $uid"; 
            $db->sql_query($sql); 
         } 
      } 
   } 
   unset($sql); 
   unset($row2); 
   unset($result); 
} 
//判斷升級結束
善用 搜尋 可以解決您 90% 的問題
頭腦清晰，選擇正確。 (╯▔︹▔)╯~╘═╛
回頂端
jessie
星球公民
星球公民
文章: 149
註冊時間: 2004-03-05 19:49
來自: Fann.City
聯繫:
聯繫 jessie

文章 由 jessie »

吉川拓也 寫:請再加入判斷升級 :

代碼: 選擇全部

//以下判斷升級 
function UpdateRPGProperties_Post($uid) 
{ 
   global $db; 

   $attplus = 1.0; 
   $defplus = 1.0; 
   $magplus = 1.0; 
   $spdplus = 1.0; 
   $hp_plus = 0.0; 
   $mp_plus = 0.0; 
   $sql = 'SELECT MAX(position_order) as basetop FROM phpbb_rpg_position WHERE position_class = 0'; 
   if ( !($result = $db->sql_query($sql)) ) 
   { 
      message_die(GENERAL_ERROR, '無法取得基礎職業屬性!!', '', __LINE__, __FILE__, $sql); 
   } 
   if ( $row = $db->sql_fetchrow($result) ) 
   { 
      $sql = 'SELECT * FROM phpbb_rpg_position WHERE position_class = 0 AND position_order = ' . $row['basetop']; 
      if ( !($result = $db->sql_query($sql)) ) 
      { 
         message_die(GENERAL_ERROR, '無法取得基礎職業屬性!!', '', __LINE__, __FILE__, $sql); 
      } 
      if ( $row = $db->sql_fetchrow($result) ) 
      { 
         // 取得基礎職業的標準值 
         $base_att = $row['attack_property']; 
         $base_def = $row['defense_property']; 
         $base_mag = $row['magic_property']; 
         $base_spd = $row['speed_property']; 
         $base_hpp = $row['hp_property']; 
         $base_mpp = $row['magic_property']; 
      } 
      $sql = 'SELECT p.* FROM phpbb_rpg_position p, phpbb_rpg_medals m WHERE p.position_class = m.position_class 
         AND p.position_order = m.position_order AND m.last_class = 1 AND m.position_class <> 0 AND m.user_id = ' . $uid; 
      if ( !($result = $db->sql_query($sql)) ) 
      { 
         message_die(GENERAL_ERROR, '無法取得專業職業屬性!!', '', __LINE__, __FILE__, $sql); 
      } 
      if ( $row = $db->sql_fetchrow($result) ) 
      { 
         $i = 1; 
         $newposition = ''; 
         do 
         { 
            if ($i == 1) 
            { 
               $attplus = $row['attack_property']; 
               $defplus = $row['defense_property']; 
               $magplus = $row['magic_property']; 
               $spdplus = $row['speed_property']; 
               $hp_plus = $row['hp_property']; 
               $mp_plus = $row['magic_property']; 
               $newposition = $row['position_name']; 
            } 
            else 
            { 
               $attplus += $row['attack_property'] - $base_att; 
               $defplus += $row['defense_property'] - $base_def; 
               $magplus += $row['magic_property'] - $base_mag; 
               $spdplus += $row['speed_property'] - $base_spd; 
               $hp_plus += $row['hp_property'] - $base_hpp; 
               $mp_plus += $row['magic_property'] - $base_mpp; 
               $newposition .= '<br />' . $row['position_name']; 
            } 
            $i++; 
         } 
         while ( $row = $db->sql_fetchrow($result) ); 

         if(strlen($newposition) > 200) 
         { 
            $newposition = substr($newposition, 0, 200); 
         } 
      } 
      else 
      { 
         // 只有基礎職業 
         $sql = 'SELECT p.* FROM phpbb_rpg_position p, phpbb_rpg_medals m WHERE p.position_class = 0 AND m.last_class = 1 
            AND m.position_class = 0 AND p.position_order = m.position_order AND m.user_id = ' . $uid; 
         if ( !($result = $db->sql_query($sql)) ) 
         { 
            message_die(GENERAL_ERROR, '無法取得基礎職業屬性!!', '', __LINE__, __FILE__, $sql); 
         } 
         if ( $row = $db->sql_fetchrow($result) ) 
         { 
            $attplus = $row['attack_property']; 
            $defplus = $row['defense_property']; 
            $magplus = $row['magic_property']; 
            $spdplus = $row['speed_property']; 
            $hp_plus = $row['hp_property']; 
            $mp_plus = $row['magic_property']; 
            $newposition = $row['position_name']; 
         } 
      } 
   } 

   $sql = 'SELECT IFNULL(SUM(i.attack_property), 0) as attack_x, IFNULL(SUM(i.defense_property), 0) as defense_x, 
      IFNULL(SUM(i.magic_property), 0) as magic_x, IFNULL(SUM(i.speed_property), 0) as speed_x, 
      IFNULL(SUM(i.hp_property), 0) as hp_x, IFNULL(SUM(i.mp_property), 0) as mp_x FROM phpbb_rpg_items i, 
      phpbb_rpg_owns o WHERE i.item_id = o.item_id AND o.user_id = ' . $uid; 
   if ( !($result = $db->sql_query($sql)) ) 
   { 
      message_die(GENERAL_ERROR, '無法取得攜帶物品屬性!!', '', __LINE__, __FILE__, $sql); 
   } 
   if ( $row = $db->sql_fetchrow($result) ) 
   { 
      $attplus += $row['attack_x']; 
      $defplus += $row['defense_x']; 
      $magplus += $row['magic_x']; 
      $spdplus += $row['speed_x']; 
      $hp_plus += $row['hp_x']; 
      $mp_plus += $row['mp_x']; 
   } 

   $sql = "update phpbb_users set rpg_max_hp = floor(rpg_level * (100 + $hp_plus + rpg_level)), 
      rpg_max_mp = floor(rpg_level * (80 + rpg_level) + rpg_level * $mp_plus), 
      rpg_attack = round(rpg_level * $attplus), rpg_defense = round(rpg_level * $defplus), 
      rpg_magic = round(rpg_level * $magplus), rpg_speed = round(rpg_level * $spdplus), 
      rpg_medals = '$newposition' where user_id = $uid"; 
   if ( !($result = $db->sql_query($sql)) ) 
   { 
      message_die(GENERAL_ERROR, '無法更新 RPG 屬性!!', '', __LINE__, __FILE__, $sql); 
   } 
} 


function LevelUp_Post($uid, $full_mh = false) 
{ 
   global $db; 

   $sql = "select rpg_level, rpg_cur_exp, rpg_max_exp from phpbb_users where user_id = $uid"; 
   $result = $db->sql_query($sql); 
   if ( $row2 = $db->sql_fetchrow($result) ) 
   { 
      if ( $row2['rpg_cur_exp'] >= $row2['rpg_max_exp'] ) 
      { 
         if ( $row2['rpg_level'] < 250 ) 
         { 
            $sql = "update phpbb_users set rpg_level = rpg_level + 1, rpg_cur_exp = rpg_cur_exp - rpg_max_exp, rpg_cur_hp = rpg_max_hp, rpg_cur_mp = rpg_max_mp, 
               rpg_max_exp = FLOOR( POW( 10, POW( rpg_level, (1/3) ) ) ) - FLOOR( POW( 10, POW( rpg_level - 1, (1/3) ) ) ) 
               where user_id = $uid"; 
            $db->sql_query($sql); 
            UpdateRPGProperties_Post($uid); 
         } 
         if ( $full_mh ) 
         { 
            $sql = "update phpbb_users set rpg_cur_hp = rpg_max_hp, rpg_cur_mp = rpg_max_mp where user_id = $uid"; 
            $db->sql_query($sql); 
         } 
      } 
   } 
   unset($sql); 
   unset($row2); 
   unset($result); 
} 
//判斷升級結束
請問這是加在哪的...我在安裝說明沒有看到這一段????
●架設主機作業系統：WindowsXP
●快速架站程式：Appserv2.3.0
●上網方式：中華電信ADSL
●安裝的程式：Apache + php + MySql
●phpBB2 版本： 2.0.8a
●安裝的外掛
圖檔
回頂端
jessie
星球公民
星球公民
文章: 149
註冊時間: 2004-03-05 19:49
來自: Fann.City
聯繫:
聯繫 jessie

文章 由 jessie »

判斷升級我本來就有加了..
●架設主機作業系統：WindowsXP
●快速架站程式：Appserv2.3.0
●上網方式：中華電信ADSL
●安裝的程式：Apache + php + MySql
●phpBB2 版本： 2.0.8a
●安裝的外掛
圖檔
回頂端
吉川拓也
竹貓忠實會員
竹貓忠實會員
文章: 1215
註冊時間: 2003-02-09 18:24
來自: [ G.I.T ]
聯繫:
聯繫 吉川拓也

文章 由 吉川拓也 »

jessie 寫:判斷升級我本來就有加了..
那請把 Line 503 上下5行貼一下@_@
善用 搜尋 可以解決您 90% 的問題
頭腦清晰，選擇正確。 (╯▔︹▔)╯~╘═╛
回頂端
jessie
星球公民
星球公民
文章: 149
註冊時間: 2004-03-05 19:49
來自: Fann.City
聯繫:
聯繫 jessie

文章 由 jessie »

我發現我只有這一段\r

代碼: 選擇全部

 if ($mode != 'poll_delete')
	{
		
$sql = "SELECT forum_postcount
			FROM " . FORUMS_TABLE . "
			WHERE forum_id = $forum_id AND forum_postcount = 0";
		if (!($result = $db->sql_query($sql)))
		{
			message_die(GENERAL_ERROR, 'Error in deleting post', '', __LINE__, __FILE__, $sql);
		}
		if ($row = $db->sql_fetchrow($result))
		{
			return;
		}
[color=red]$sql = "UPDATE " . USERS_TABLE . "
			SET user_posts = user_posts $sign 
			WHERE user_id = $user_id";
		if (!$db->sql_query($sql, END_TRANSACTION))
		{
			message_die(GENERAL_ERROR, 'Error in posting', '', __LINE__, __FILE__, $sql);
		}
	}[/color]
	
	return;
}
沒有[php]if ($mode != 'poll_delete')
{[/php]
●架設主機作業系統：WindowsXP
●快速架站程式：Appserv2.3.0
●上網方式：中華電信ADSL
●安裝的程式：Apache + php + MySql
●phpBB2 版本： 2.0.8a
●安裝的外掛
圖檔
回頂端
頭像
shihchieh
竹貓忠實會員
竹貓忠實會員
文章: 509
註冊時間: 2002-10-07 13:02

文章 由 shihchieh »

函式名稱要一樣不能自已隨易簡化~
你有一個FUNCTION ABC()
{
}

呼叫時就要用 ABC(變數) 不可以變成 AB(變數)
---
Do you fear death ?
回頂端
abc91047
星球普通子民
星球普通子民
文章: 1
註冊時間: 2004-12-05 12:20
聯繫:
聯繫 abc91047

文章 由 abc91047 »

我裝了水怪之後.出現了問題...
跟第一位的有點類似..又不太一樣..請救救我吧!!

代碼: 選擇全部

Could not obtain post/user information.

DEBUG MODE

SQL Error : 1054 Unknown column 'u.user_robfail' in 'field list'

SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_robfail, u.rpg_level, u.rpg_cur_hp, u.rpg_max_hp, u.rpg_cur_mp, u.rpg_max_mp, u.rpg_cur_exp, u.rpg_max_exp, u.rpg_attack, u.rpg_defense, u.rpg_magic, u.rpg_speed, u.rpg_medals, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, u.user_money, u.user_bank FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 3 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 10

Line : 398
File : c:\appserv\www\phpbb2\viewtopic.php
回頂端
主題已鎖定

回到「外掛問題討論」