竹貓星球

發表於 : **2004-03-23 03:10**

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

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

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

發表於 : **2004-03-23 20:31**

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

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

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 了嗎 ?

發表於 : **2004-03-23 20:41**

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
綠字後方又少了一個 "," 加上去吧~

發表於 : **2004-04-07 23:06**

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 動機

發表於 : **2004-04-08 00:22**

to動機:下次改進\r
那麼請問怎麼修正呢?

發表於 : **2004-04-11 22:19**

代碼: 選擇全部

   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;

請問紅色的部分要怎麼改?

發表於 : **2004-04-11 23:25**

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

取代成 :
[php]<?php
}
LevelUp_post($user_id);
}
?>[/php]

發表於 : **2004-04-11 23:39**

改了...
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);
	}

發表於 : **2004-04-11 23:43**

請再加入判斷升級 :

代碼: 選擇全部

//以下判斷升級 
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); 
} 
//判斷升級結束

發表於 : **2004-04-12 00:36**

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

代碼: 選擇全部

//以下判斷升級 
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); 
} 
//判斷升級結束

請問這是加在哪的...我在安裝說明沒有看到這一段????

發表於 : **2004-04-12 22:08**

判斷升級我本來就有加了..

發表於 : **2004-04-14 10:33**

jessie 寫:判斷升級我本來就有加了..

那請把 Line 503 上下5行貼一下@_@

發表於 : **2004-04-14 11:03**

我發現我只有這一段\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]

發表於 : **2004-05-05 21:58**

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

呼叫時就要用 ABC(變數) 不可以變成 AB(變數)

發表於 : **2004-12-10 23:46**

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

代碼: 選擇全部

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

竹貓星球

[問題]水怪RPG之問題

[問題]水怪RPG之問題

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