竹貓星球

代碼: 選擇全部

一般錯誤 

無法取得攜帶物品屬性!!

DEBUG MODE

SQL Error : 1146 Table 'lovelymo_phpbb.lovelymonster_phpbb_rpg_owns' doesn't exist

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, lovelymonster_phpbb_rpg_owns o WHERE i.item_id = o.item_id AND o.user_id = 2

Line : 652
File : /home/lovelymo/public_html/forum/rpg/function_rpg.php
 

代碼: 選擇全部

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, lovelymonster_phpbb_rpg_owns o WHERE i.item_id = o.item_id AND o.user_id = 2 

代碼: 選擇全部

<?php

define('PAGE_JOBS', 30);

include($phpbb_root_path . 'rpg/function_rpg.'.$phpEx);


if ( !defined('IN_PHPBB') )
{
	die("Hacking attempt");
	exit;
}

$returnurl = '<br /><br /><a href="rpg.php?action=extra">返回上一頁</a>';

$template->set_filenames(array(
	'menu' => 'rpg_header.tpl',
	'body' => 'rpg_joinjobs.tpl')
);

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

if (isset($HTTP_GET_VARS['cancel']) || isset($HTTP_POST_VARS['cancel']))
{
	$sql = 'DELETE FROM phpbb_rpg_joinjobs WHERE user_id = ' . $profiledata['user_id'];
	if ( !$db->sql_query($sql) )
	{
		message_die(GENERAL_ERROR, '取消排班失敗!!', '', __LINE__, __FILE__, $sql);
	}
}


$which_store = intval(( isset($HTTP_GET_VARS['store']) ) ? $HTTP_GET_VARS['store'] : $HTTP_POST_VARS['store']);
$start_join = intval(( isset($HTTP_GET_VARS['start']) ) ? $HTTP_GET_VARS['start'] : $HTTP_POST_VARS['start']);

$joinjobslist = '<span class="gensmall"><a href="rpg.php?action=joinjobs&cancel=1"><b>取消排班</b></a>&nbsp;&nbsp;::&nbsp;&nbsp;' .
		($which_store != 1 ? '<a href="rpg.php?action=joinjobs&store=1&start=0">黑暗的武器店</a>' : '黑暗的武器店') .
		'&nbsp;&nbsp;' .
		($which_store != 2 ? '<a href="rpg.php?action=joinjobs&store=2&start=0">沒光的防具店</a>' : '沒光的防具店') .
		'&nbsp;&nbsp;' .
		($which_store != 3 ? '<a href="rpg.php?action=joinjobs&store=3&start=0">魔法技能學園</a>' : '魔法技能學園') .
		'&nbsp;&nbsp;' .
		($which_store != 0 ? '<a href="rpg.php?action=joinjobs&store=0&start=0">水怪的道具店</a>' : '水怪的道具店') .
		'</span><br />';

// 計算總頁次\r
$sql = 'SELECT COUNT(*) as join_count FROM phpbb_rpg_joinjobs WHERE in_which_store = ' . $which_store;
if ( $result = $db->sql_query($sql) )
{
	$row = $db->sql_fetchrow($result);
	$page_count = floor(($row['join_count'] - 1) / PAGE_JOBS) + 1;
}

$sql = 'SELECT w.job_name, u.username, j.join_time FROM phpbb_rpg_joinjobs j, phpbb_users u, phpbb_rpg_jobs w
	WHERE j.in_which_store = ' . $which_store . ' AND w.in_which_store = ' . $which_store .
	' AND j.user_id = u.user_id AND j.job_id = w.job_id ORDER BY j.job_id, j.join_time LIMIT ' . $start_join . ', ' . PAGE_JOBS;
if ( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, '無法取得排班列表!!', '', __LINE__, __FILE__, $sql);
}
if ( $row = $db->sql_fetchrow($result) )
{
	if ($page_count > 0)
	{
		$joinjobslist .= '<span class="gensmall"><b>頁次:';
		for ($i = 1; $i <= $page_count ; $i++)
		{
			if ($i == (floor($start_join / PAGE_JOBS) + 1) )
			{
				$joinjobslist .= ' ' . $i;
			}
			else
			{
				$joinjobslist .= ' <a href="rpg.php?action=joinjobs&store=' . $which_store . '&start=' . (($i - 1) * PAGE_JOBS) . '">' . $i . '</a>';
			}
		}
		$joinjobslist .= '</span>';
	}
	$i = $start_join + 1;
	$joinjobslist .= '<table width="50%" cellpadding="3" cellspacing="1" border="0" class="forumline">
		<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">工作人員</span></b></td>
		<td align="center" class="catLeft"><b><span class="gen">加入時間</span></b></td></tr>';
	$old_jobname = '';
	do
	{
		$joinjobslist .= '<tr>
		<td class="row3">
		<span class="gensmall">';
		if ($old_jobname != $row['job_name'])
		{
			$i = 1;
			$old_jobname = $row['job_name'];
			$joinjobslist .= $old_jobname;
		}
		$joinjobslist .= '</span>
			<td align="center"><span class="gensmall">' . $i . '</span></td>
			<td><span class="gensmall">' . $row['username'] . '</span></td>\r
			<td align="center"><span class="gensmall">' . (create_date($userdata['user_dateformat'], $row['join_time'], $board_config['board_timezone'])) . '</span></td>
		</tr>';
		$i++;
	}
	while ( $row = $db->sql_fetchrow($result) );
	$joinjobslist .= '';
}
else
{
	$joinjobslist .= '<span class="gensmall">目前沒有任何人加入排班!!</span>';
}

// 產生資料頁面\r
$page_title = "水怪大陸 RPG 首頁";
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

$template->assign_vars(array(
	'USERNAME' => $profiledata['username'],
	'AVATAR_IMG' => GetAvatar($profiledata),
	'RPG_JOIN_JOBS_LIST' => $joinjobslist,
	'L_NOWMENU' => '打工排班列表') );

$template->pparse('menu');
$template->pparse('body');

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?> 

代碼: 選擇全部

# 打工機會
CREATE TABLE `phpbb_rpg_jobs` (
  `job_id` smallint(5) NOT NULL auto_increment,
  `in_which_store` tinyint(1) default '0',
  `job_name` varchar(30) default NULL,
  `start_day` int(11) default '0',
  `working_days` tinyint(3) default '1',
  `apply_fee` int(11) default '0',
  `profit_percent` decimal(5,2) default '1.00',
  `worker_id` mediumint(8) default NULL,
  `worker_name` varchar(25) default NULL,
  `job_salary` int(11) default '0',
  PRIMARY KEY  (`job_id`)
) TYPE=MyISAM;

INSERT INTO phpbb_rpg_jobs VALUES("1", "0", "店長", "0", "0", "20000", "10.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("2", "0", "副店長", "0", "0", "15000", "7.50", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("3", "0", "業務員", "0", "0", "10000", "5.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("4", "0", "店員", "0", "0", "6000", "3.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("5", "0", "工讀生", "0", "0", "4000", "2.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("6", "0", "招待生", "0", "0", "2000", "1.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("7", "0", "清潔工", "0", "0", "1000", "0.50", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("8", "1", "店長", "0", "1", "20000", "10.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("9", "1", "副店長", "0", "1", "15000", "7.50", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("10", "1", "業務員", "0", "1", "10000", "5.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("11", "1", "店員", "0", "1", "6000", "3.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("12", "1", "工讀生", "0", "1", "4000", "2.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("13", "1", "招待生", "0", "1", "2000", "1.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("14", "1", "清潔工", "0", "1", "1000", "0.50", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("15", "2", "店長", "0", "2", "20000", "10.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("16", "2", "副店長", "0", "2", "15000", "7.50", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("17", "2", "業務員", "0", "2", "10000", "5.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("18", "2", "店員", "0", "2", "6000", "3.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("19", "2", "工讀生", "0", "2", "4000", "2.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("20", "2", "招待生", "0", "2", "2000", "1.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("21", "2", "清潔工", "0", "2", "1000", "0.50", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("22", "3", "校長", "0", "3", "20000", "10.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("23", "3", "副校長", "0", "3", "15000", "7.50", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("24", "3", "系主任", "0", "3", "10000", "5.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("25", "3", "教授", "0", "3", "6000", "3.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("26", "3", "助教", "0", "3", "4000", "2.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("27", "3", "警衛", "0", "3", "2000", "1.00", NULL, NULL, "0");
INSERT INTO phpbb_rpg_jobs VALUES("28", "3", "工友", "0", "3", "1000", "0.50", NULL, NULL, "0");

代碼: 選擇全部

一般錯誤 

僱主扣款發生錯誤!!

DEBUG MODE

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

UPDATE phpbb_users SET user_bank = user_bank - 99, user_bank_time = 1104473079 WHERE user_id = 3

Line : 793
File : /home/lovelymo/public_html/forum/rpg/rob.php