[問題]水怪RPR的問題

[銀薰]

RPG英雄榜按下去都會出現這樣的錯誤
搜尋過沒發現有人有這樣的問題
我確定我資料庫裡面有rpg_robbed_cnt這個表格\r
拜託知道為什麼的大大解答一下阿~~
小弟萬分感謝..

無法取得被搶次數\r

DEBUG MODE

SQL Error : 1054 Unknown column 'rpg_robbed_cnt' in 'field list'

SELECT username, rpg_robbed_cnt FROM phpbb_users ORDER BY 2 DESC LIMIT 0, 10

Line : 13
File : c:\appserv\www\phpbb2
pg\stat.php

[bbsbsai]

Line : 13
File : c:\appserv\www\phpbb2
pg\stat.php

stat.php可以貼出來看看嗎??

[銀薰]

FTP掛掉了...可能要等幾天喔
在此先感激了>"<

[Ricky Zero]

有裝搶劫嗎？
有把sql完整安裝嗎？

代碼: 選擇全部

# 個人資料
ALTER TABLE `phpbb_users`
ADD `user_bank` int(11) unsigned NOT NULL default '0',
ADD `user_bank_time` int(11) default '0',
ADD `user_robfail` smallint(5) default '0',
ADD `rpg_rob_cnt` smallint(5) unsigned default '0',
ADD `rpg_robbed_cnt` smallint(5) unsigned default '0',
ADD `rpg_rob_succ` smallint(5) unsigned default '0',
ADD `rpg_rob_fail` smallint(5) unsigned default '0',
ADD `rpg_rob_money` int(11) unsigned default '0',
ADD `rpg_robbed_money` int(11) unsigned default '0',
ADD `rpg_level` smallint(5) NOT NULL default '1',
ADD `rpg_cur_exp` mediumint(8) NOT NULL default '0',
ADD `rpg_max_exp` mediumint(8) NOT NULL default '9',
ADD `rpg_cur_hp` mediumint(8) NOT NULL default '18',
ADD `rpg_max_hp` mediumint(8) NOT NULL default '18',
ADD `rpg_cur_mp` mediumint(8) NOT NULL default '8',
ADD `rpg_max_mp` mediumint(8) NOT NULL default '8',
ADD `rpg_attack` mediumint(8) NOT NULL default '1',
ADD `rpg_defense` mediumint(8) NOT NULL default '1',
ADD `rpg_magic` mediumint(8) NOT NULL default '1',
ADD `rpg_speed` mediumint(8) NOT NULL default '1',
ADD `rpg_medals` varchar(200) default '路人',
ADD `rpg_richer_pos` int(10) default NULL;

代碼: 選擇全部

function GetList($listfield, $displayname)
{
	global $db;

	$htmllist = '';
	$sql = 'SELECT username, ' . $listfield . ' FROM phpbb_users ORDER BY 2 DESC LIMIT 0, 10';
	if ( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, '無法取得' . $displayname, '!!', __LINE__, __FILE__, $sql);
	}
	if ( $row = $db->sql_fetchrow($result) )
	{
		$i = 1;
		$htmllist = '<table class="forumline" width="90%" cellspacing="1" cellpadding="3" border="0">
			<tr><td align="center" class="catLeft"><b><span class="gen">#</span></b></td>
			<td align="center" class="catLeft"><b><span class="gen">獵人名稱</span></b></td>
			<td align="center" class="catLeft"><b><span class="gen">' . $displayname. '</span></b></td></tr>';
		do
		{
			$htmllist .= '<tr><td class="row3" align="center"><span class="gensmall">' . $i .
					'</span></td><td><span class="gensmall">' . $row['username'] .
					'</span></td><td align="right"><span class="gensmall">' . number_format($row[$listfield]) .
					'</span></td></tr>';
			$i++;
		}
		while ( $row = $db->sql_fetchrow($result) );
		$htmllist .= '</table>';
	}
	return $htmllist;
}

代碼: 選擇全部

// 取得個人資料
$profiledata = get_userdata(intval($userdata['user_id']));
$itemerror = '';

if ( CheckRefresh(99, intval($userdata['user_id']), 10) )
{
	message_die(GENERAL_MESSAGE, '為了避免系統負荷過重，請間隔 10 秒再重新整理!!' . $returnurl);
}



$cashlist = GetList('user_money', '持有酷幣');
\n$banklist = GetList('user_bank', '銀行存款');
$levellist = GetList('rpg_level', '貪婪等級排行');
$robcount = GetList('rpg_rob_cnt', '搶劫次數');
$robbedcount = GetList('rpg_robbed_cnt', '被搶次數');
$robsucc = GetList('rpg_rob_succ', '成功次數');
$robfail = GetList('rpg_rob_fail', '失敗次數');
$robmoney = GetList('rpg_rob_money', '搶劫金額');
$robbedmoney = GetList('rpg_robbed_money', '被搶金額');
$dollcount = GetList('user_robfail', '詛咒草人');
$eol_kill = GetList('rpg_eol_kill', '砍人次數');
$eol_killed = GetList('rpg_eol_killed', '陣亡次數');

看一下是不是哪一段沒加進入吧