[問題]vault 1.0.0外掛的問題(已解決)

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

版主: 版主管理群

主題已鎖定
。。鳳凰寺 風。。
星球公民
星球公民
文章: 91
註冊時間: 2004-09-17 04:48
聯繫:
聯繫 。。鳳凰寺 風。。

[問題]vault 1.0.0外掛的問題(已解決)

文章 由 。。鳳凰寺 風。。 »

問題外掛： Vault 1.0.0外掛的問題
參考連結：http://phpbb-tw.net/phpbb/viewtopic.php?t=24523
使用版本：phpBB 2.0.10
網站位置：水雲寨
狀況描述：你好!! 我知道這問題有人問過了，但是那個人的已經解決了，我也看過我的資料庫了!!還是不行，因為我畢竟是個新手，這個網站我也是看了一百多篇文章架出來的，因為我不敢發問，只好一直找文章囉^^，但是這個問題真的需要大家的幫助，我時在找不到原因在哪= =?所以想說有誰可以幫幫我嗎T^T

問題:無法在後台新增上市公司\r
錯誤訊息如下:

代碼: 選擇全部

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 20, 20, 20, 20)' at line 2

INSERT INTO phpbb_vault_exchange (stock_id, stock_name, stock_desc,stock_total,stock_price,stock_previous_price,stock_worst_price,stock_best_price) VALUES ( 1, '。。白色巨塔。。' , '專屬於。。白色巨塔。。的股票上市囉!!' ,, 20, 20, 20, 20)

Line : 254
File : c:\AppServ\www\phpBB2\admin\admin_vault_exchange.php
我是用在這個檔案"vault_db_update.php"在瀏覽器新增資料庫的，他新增成功內容如下:

代碼: 選擇全部

INSERT INTO phpbb_config (config_name, config_value) VALUES ('vault_enable', '1')
+++ Successfull

INSERT INTO phpbb_config (config_name, config_value) VALUES ('vault_name', 'Vault')
+++ Successfull

INSERT INTO phpbb_config (config_name, config_value) VALUES ('stock_use', '1')\r
+++ Successfull

INSERT INTO phpbb_config (config_name, config_value) VALUES ('stock_time', '86400')
+++ Successfull

INSERT INTO phpbb_config (config_name, config_value) VALUES ('stock_last_change', '0')
+++ Successfull

INSERT INTO phpbb_config (config_name, config_value) VALUES ('vault_display_profile' , '1')
+++ Successfull

INSERT INTO phpbb_config (config_name, config_value) VALUES ('vault_display_topics' , '0')
+++ Successfull

CREATE TABLE phpbb_vault_blacklist ( user_id int(8) NOT NULL default '0', user_due int(8) NOT NULL default '0', PRIMARY KEY (user_id) ) TYPE=MyISAM
+++ Successfull

CREATE TABLE phpbb_vault_exchange ( stock_id int(8) NOT NULL default '0', stock_name varchar(40) NOT NULL default '', stock_desc varchar(255) NOT NULL default '', stock_total int(5) default '30', stock_price int(8) NOT NULL default '0', stock_previous_price int(8) NOT NULL default '0', stock_best_price int(8) NOT NULL default '0', stock_worst_price int(8) NOT NULL default '0', chairman int(8) default '2', PRIMARY KEY (stock_id) ) TYPE=MyISAM
+++ Successfull

INSERT INTO phpbb_vault_exchange (stock_id, stock_name, stock_desc, stock_price, stock_previous_price, stock_best_price, stock_worst_price) VALUES (1, 'Vault_action_name_1', 'Vault_action_desc_1', 100, 100, 100, 100)
+++ Successfull

INSERT INTO phpbb_vault_exchange (stock_id, stock_name, stock_desc, stock_price, stock_previous_price, stock_best_price, stock_worst_price) VALUES (2, 'Vault_action_name_2', 'Vault_action_desc_2', 200, 200, 200, 200)
+++ Successfull

INSERT INTO phpbb_vault_exchange (stock_id, stock_name, stock_desc, stock_price, stock_previous_price, stock_best_price, stock_worst_price) VALUES (3, 'Vault_action_name_3', 'Vault_action_desc_3', 300, 300, 300, 300)
+++ Successfull

CREATE TABLE phpbb_vault_exchange_users ( stock_id mediumint(8) NOT NULL default '0', user_id mediumint(8) NOT NULL default '0', stock_amount mediumint(8) NOT NULL default '0', stock_price mediumint(8) NOT NULL default '0', KEY stock_id (stock_id), KEY user_id (user_id) ) TYPE=MyISAM
+++ Successfull

CREATE TABLE phpbb_vault_general ( config_name varchar(255) NOT NULL default '', config_value int(15) NOT NULL default '0', PRIMARY KEY (config_name) ) TYPE=MyISAM
+++ Successfull

INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('vault_loan_enable', 1)
+++ Successfull

INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('interests_rate', 4)
+++ Successfull

INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('interests_time', 86400)
+++ Successfull

INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('loan_interests', 15)
+++ Successfull

INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('loan_interests_time', 864000)
+++ Successfull

INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('loan_max_sum', 5000)
+++ Successfull

INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('loan_requirements', 0)
+++ Successfull

INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('stock_max_change', 10)
+++ Successfull

INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('stock_min_change', 0)
+++ Successfull

INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('base_amount', 10)
+++ Successfull

INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('num_items', 20)
+++ Successfull

INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('change_fee', 1)
+++ Successfull

CREATE TABLE phpbb_vault_users ( owner_id int(8) NOT NULL default '0', account_id int(8) NOT NULL default '0', account_sum int(8) NOT NULL default '0', account_time int(11) NOT NULL default '0', loan_sum int(8) NOT NULL default '0', loan_time int(11) NOT NULL default '0', account_protect tinyint(1) NOT NULL default '0', loan_protect tinyint(1) NOT NULL default '0', newsletter tinyint(1) NOT NULL default '0', PRIMARY KEY (owner_id) ) TYPE=MyISAM
+++ Successfull
如果需要我PO一些文件的內容的話，請跟我說一聲，我一定盡力配合!!
如果需要的話請用這個吧!
測試帳號:test 密碼:1234
最後由 。。鳳凰寺 風。。 於 2004-10-08 00:31 編輯，總共編輯了 1 次。
如果驕傲沒被現實大海冷冷拍響，又怎會懂得要多努力才走得到遠方；
如果夢想不曾墜落懸崖千均一髮，又怎會曉得執著的人擁有隱形翅膀。
回頂端
動機不明
喝咖啡的綠皮猴
喝咖啡的綠皮猴
文章: 1179
註冊時間: 2002-03-06 20:37
來自: GOP (重啟)

文章 由 動機不明 »

到 phpmyadmin 控制台去手動輸入這一行試試看...

代碼: 選擇全部

INSERT INTO phpbb_vault_exchange (stock_id, stock_name, stock_desc, stock_total,stock_price,stock_previous_price,stock_worst_price,stock_best_price) VALUES ( 1, '。。白色巨塔。。' , '專屬於。。白色巨塔。。的股票上市囉!!' ,30, 20, 20, 20, 20)
大概是 stock_total 的問題... :oops:
非官方外掛問題區公告: [必看]請配合發問格式及明確主題發問(2006 02/24更新)
七點要求：
1. 發問前先搜尋，確定沒有重複後再發表
2. 主題要明確
3. 依照發問格式
4. 禁連續推文
5. 請盡量減少使用地方性語言
6. 解決問題後請修改第一篇主題，並感謝曾經幫過你的前輩們 ^^
7. 請不要將檔案內容完整貼出喔! 只要提供問題行及上下各五行就可以了
回頂端
。。鳳凰寺 風。。
星球公民
星球公民
文章: 91
註冊時間: 2004-09-17 04:48
聯繫:
聯繫 。。鳳凰寺 風。。

文章 由 。。鳳凰寺 風。。 »

phpMyAdmin控制台新增是OK的，但是我以後新增編輯都要這樣嗎= =?

但是我發現你叫我輸入的那一行

代碼: 選擇全部

INSERT INTO phpbb_vault_exchange (stock_id, stock_name, stock_desc, stock_total,stock_price,stock_previous_price,stock_worst_price,stock_best_price) VALUES ( 1, '。。白色巨塔。。' , '專屬於。。白色巨塔。。的股票上市囉!!' ,30, 20, 20, 20, 20)
跟我出現的錯誤訊息有一個地方不相同，不知你有沒有發現\r

代碼: 選擇全部

INSERT INTO phpbb_vault_exchange (stock_id, stock_name, stock_desc,stock_total,stock_price,stock_previous_price,stock_worst_price,stock_best_price) VALUES ( 1, '。。白色巨塔。。' , '專屬於。。白色巨塔。。的股票上市囉!!' ,, 20, 20, 20, 20)
就是在股票上市囉!!' 後面，你的是一個逗點，但是我卻有兩個逗點出來，所以我在想是不是這個檔案"admin_vault_exchange.php"的問題，因為我不覺得是"stock_total"的問題耶QQ

下面是"admin_vault_exchange.php"的內容，因為我還不太會看QQ

代碼: 選擇全部

<?php
/***************************************************************************
 *                              admin_vault_exchange.php
 *                            ------------------
 *   begin                : 10/01/2004
 *
 *
 ***************************************************************************/

if( !empty($setmodules) )
{
	$file = basename(__FILE__);
	$module['Vault']['Vault_exchange'] = $file;
	return;
}

define('IN_PHPBB', true);

$phpbb_root_path = '../';
require($phpbb_root_path . 'extension.inc');
require("pagestart.$phpEx");

\n$template->set_filenames(array(
	'body' => 'admin/config_vault_exchange_body.tpl')
);

$submit = isset($HTTP_POST_VARS['submit']); 

$sql = "SELECT *
FROM " . VAULT_GENERAL_TABLE ;
if(!$result = $db->sql_query($sql))
{
	message_die(CRITICAL_ERROR, "Could not query config information in admin_board", "", __LINE__, __FILE__, $sql);
}
while( $row = $db->sql_fetchrow($result) )
{
	$vault[$row['config_name']] = $row['config_value'];
}

if ( $submit )
{
	$use = intval ( $HTTP_POST_VARS['use']);
	$min = intval ( $HTTP_POST_VARS['min']);
	$max = intval ( $HTTP_POST_VARS['max']);
	$time = intval ( $HTTP_POST_VARS['time']);

	$lsql= "UPDATE ". CONFIG_TABLE . " SET config_value = '$use' WHERE config_name = 'stock_use' ";
	if ( !($lresult = $db->sql_query($lsql)) ) 
	{ 
		message_die(GENERAL_ERROR, $lang['Vault_update_error'] , "", __LINE__, __FILE__, $lsql); 
	} 
	$lsql= "UPDATE ". VAULT_GENERAL_TABLE . " SET config_value = '$min' WHERE config_name = 'stock_min_change' ";
	if ( !($lresult = $db->sql_query($lsql)) ) 
	{ 
		message_die(GENERAL_ERROR, $lang['Vault_update_error'] , "", __LINE__, __FILE__, $lsql); 
	} 
	$lsql= "UPDATE ". VAULT_GENERAL_TABLE . " SET config_value = '$max' WHERE config_name = 'stock_max_change' ";
	if ( !($lresult = $db->sql_query($lsql)) ) 
	{ 
		message_die(GENERAL_ERROR, $lang['Vault_update_error'] , "", __LINE__, __FILE__, $lsql); 
	} 	
	$lsql= "UPDATE ". CONFIG_TABLE . " SET config_value = '$time' WHERE config_name = 'stock_time' ";
	if ( !($lresult = $db->sql_query($lsql)) ) 
	{ 
		message_die(GENERAL_ERROR, $lang['Vault_update_error'] , "", __LINE__, __FILE__, $lsql); 
	} 

	vault_update_general_config();
	message_die(GENERAL_MESSAGE, sprintf($lang['Vault_exchange_updated_return_settings'], '<a href="' . append_sid(basename(__FILE__)) . '">', '</a>'), $lang['Vault_settings']);
}

if( isset($HTTP_POST_VARS['mode']) || isset($HTTP_GET_VARS['mode']) )
{
	$mode = ( isset($HTTP_POST_VARS['mode']) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode'];
}
else
{
	$mode = "";
}

if( isset($HTTP_POST_VARS['add']) || isset($HTTP_GET_VARS['add']) )
{

	$template->set_filenames(array(
		"body" => 'admin/config_vault_exchange_add_body.tpl')
	);
	$template->assign_block_vars('exchange_add',array());

	$s_hidden_fields = '<input type="hidden" name="mode" value="savenew" />';

	$template->assign_vars(array(
		'L_VAULT_EXCHANGE_ADD_SETTINGS' => $lang['Vault_exchange_settings_add'],
		'L_VAULT_EXCHANGE_ADD_SETTINGS_EXPLAIN' => $lang['Vault_exchange_settings_explain_add'],
		'L_STOCK_EXCHANGE_ACTIONS_ADD' => $lang['Vault_exchange_actions_add'],
		'L_STOCK_TOTAL' => $lang['Vault_exchange_stock_total'],
		'L_STOCK_NAME' => $lang['Vault_exchange_actions_name'],
		'L_STOCK_DESC' => $lang['Vault_exchange_actions_desc'],
		'L_STOCK_AMOUNT' => $lang['Vault_exchange_actions_amount'],
		"S_HIDDEN_FIELDS" => $s_hidden_fields) 
	);

}
else if ( $mode != "" )
{
	switch( $mode )
	{
		case 'delete':

			$stock_id = ( !empty($HTTP_POST_VARS['id']) ) ? $HTTP_POST_VARS['id'] : $HTTP_GET_VARS['id'];

			$sql = "SELECT * FROM " . VAULT_EXCHANGE_USERS_TABLE . "
				WHERE stock_id = " . $stock_id;
			$result = $db->sql_query($sql);
			if( !$result )
			{
				message_die(GENERAL_ERROR, "Couldn't delete stock", "", __LINE__, __FILE__, $sql);
			}
			$users = $db->sql_fetchrowset($result);
			for ( $i = 0 ; $i < count ( $users ) ; $i ++ )
			{
				$ssql = "SELECT stock_price FROM " . VAULT_EXCHANGE_TABLE . "
					WHERE stock_id = " . $stock_id;
				$sresult = $db->sql_query($ssql);
				if( !$sresult )
				{
					message_die(GENERAL_ERROR, "Couldn't delete stock", "", __LINE__, __FILE__, $ssql);
				}
				$prize = $db->sql_fetchrow($sresult);
				$price = $prize['stock_price'] * $users[$i]['stock_amount'];
				$usql = "UPDATE " . USERS_TABLE . "
					SET user_points = user_points + $price 
					WHERE user_id =  ".$users[$i]['user_id'];
				$uresult = $db->sql_query($usql);
				if( !$uresult )
				{
					message_die(GENERAL_ERROR, "Couldn't delete stock", "", __LINE__, __FILE__, $usql);
				}
			}

			$sql = "DELETE FROM " . VAULT_EXCHANGE_USERS_TABLE . " 
 				WHERE stock_id = " . $stock_id;
			$result = $db->sql_query($sql);
			if( !$result )
			{
				message_die(GENERAL_ERROR, "Couldn't delete stock", "", __LINE__, __FILE__, $sql);
			}

			$sql = "DELETE FROM " . VAULT_EXCHANGE_TABLE . "
				WHERE stock_id = " . $stock_id;
			$result = $db->sql_query($sql);
			if( !$result )
			{
				message_die(GENERAL_ERROR, "Couldn't delete stock", "", __LINE__, __FILE__, $sql);
			}

			message_die(GENERAL_MESSAGE, sprintf($lang['Vault_exchange_deleted_return_settings'], '<a href="' . append_sid(basename(__FILE__)) . '">', '</a>'), $lang['Vault_settings']);
			break;

		case 'edit':

			$stock_id = ( !empty($HTTP_POST_VARS['id']) ) ? $HTTP_POST_VARS['id'] : $HTTP_GET_VARS['id'];

			$sql = "SELECT *
				FROM " . VAULT_EXCHANGE_TABLE . "
				WHERE stock_id = " . $stock_id;
			$result = $db->sql_query($sql);
			if( !$result )
			{
				message_die(GENERAL_ERROR, 'Could not obtain stock exchange information', "", __LINE__, __FILE__, $sql);
			}
			$stock_data = $db->sql_fetchrow($result);

			$template->set_filenames(array(
				"body" => 'admin/config_vault_exchange_add_body.tpl')
			);

			$template->assign_block_vars('exchange_edit',array());

			$s_hidden_fields = '<input type="hidden" name="mode" value="save" /><input type="hidden" name="stock_id" value="' . $stock_data['stock_id'] . '" />';

			$template->assign_vars(array(
				'STOCK_TOTAL' => $stock_data['stock_total'],
				'STOCK_NAME' => $stock_data['stock_name'],
				'STOCK_DESC' => $stock_data['stock_desc'],
				'STOCK_AMOUNT' => $stock_data['stock_price'],
				'L_STOCK_EXCHANGE_ACTIONS_EDIT'  => $lang['Vault_exchange_actions_edit'],
				'L_VAULT_EXCHANGE_EDIT_SETTINGS' => $lang['Vault_exchange_settings_edit'],
				'L_VAULT_EXCHANGE_EDIT_SETTINGS_EXPLAIN' => $lang['Vault_exchange_settings_explain_edit'],
				'L_STOCK_TOTAL' => $lang['Vault_exchange_stock_total'],
				'L_STOCK_NAME' => $lang['Vault_exchange_actions_name'],
				'L_STOCK_DESC' => $lang['Vault_exchange_actions_desc'],
				'L_STOCK_AMOUNT' => $lang['Vault_exchange_actions_amount'],
				"S_HIDDEN_FIELDS" => $s_hidden_fields) 
			);

			break;

		case "save":

			$stock_name = ( isset($HTTP_POST_VARS['stock_name']) ) ? trim($HTTP_POST_VARS['stock_name']) : trim($HTTP_GET_VARS['stock_name']);
			$stock_desc = ( isset($HTTP_POST_VARS['stock_desc']) ) ? trim($HTTP_POST_VARS['stock_desc']) : trim($HTTP_GET_VARS['stock_desc']);
			$stock_total = ( isset($HTTP_POST_VARS['stock_total']) ) ? intval($HTTP_POST_VARS['stock_total']) : intval($HTTP_GET_VARS['stock_total']);
			$stock_price = ( isset($HTTP_POST_VARS['stock_price']) ) ? intval($HTTP_POST_VARS['stock_price']) : intval($HTTP_GET_VARS['stock_price']);
			$stock_id = ( isset($HTTP_POST_VARS['stock_id']) ) ? intval($HTTP_POST_VARS['stock_id']) : intval($HTTP_GET_VARS['stock_id']);

			if ($stock_name == '' || $stock_desc == '' || $stock_total == '' || $stock_price == '')
			{
				message_die(MESSAGE, $lang['Fields_empty']);
			}

			$sql = "UPDATE " . VAULT_EXCHANGE_TABLE . "
				SET stock_name = '" . str_replace("\'", "''", $stock_name) . "', 
				stock_desc = '" . str_replace("\'", "''", $stock_desc) . "', 
				stock_total = $stock_total,
				stock_price = $stock_price
				WHERE stock_id = " . $stock_id;
			$result = $db->sql_query($sql);
			if( !$result )
			{
				message_die(GENERAL_ERROR, "Couldn't update stock", "", __LINE__, __FILE__, $sql);
			}

			message_die(GENERAL_MESSAGE, sprintf($lang['Vault_exchange_edited_return_settings'], '<a href="' . append_sid(basename(__FILE__)) . '">', '</a>'), $lang['Vault_settings']);
			break;

		case "savenew":

			$sql = "SELECT *
			FROM " . VAULT_EXCHANGE_TABLE ."
			ORDER BY stock_id 
			DESC LIMIT 1";
			$result = $db->sql_query($sql);
			if( !$result )
			{
				message_die(GENERAL_ERROR, 'Could not obtain stock exchange information', "", __LINE__, __FILE__, $sql);
			}
			$stock_data = $db->sql_fetchrow($result);

			$stock_name = ( isset($HTTP_POST_VARS['stock_name']) ) ? trim($HTTP_POST_VARS['stock_name']) : trim($HTTP_GET_VARS['stock_name']);
			$stock_desc = ( isset($HTTP_POST_VARS['stock_desc']) ) ? trim($HTTP_POST_VARS['stock_desc']) : trim($HTTP_GET_VARS['stock_desc']);
			$stock_price = ( isset($HTTP_POST_VARS['stock_price']) ) ? intval($HTTP_POST_VARS['stock_price']) : intval($HTTP_GET_VARS['stock_price']);
			$stock_id = $stock_data['stock_id'] +1;

			if ($stock_name == '' || $stock_desc == '' || $stock_price == '' )
			{
				message_die(MESSAGE, $lang['Fields_empty']);
			}

			$sql = "INSERT INTO " . VAULT_EXCHANGE_TABLE . " (stock_id, stock_name, stock_desc,stock_total,stock_price,stock_previous_price,stock_worst_price,stock_best_price)
				VALUES ( $stock_id, '" . str_replace("\'", "''", $stock_name) . "' , '" . str_replace("\'", "''", $stock_desc) . "' ,$stock_total, $stock_price, $stock_price, $stock_price, $stock_price)";
			$result = $db->sql_query($sql);
			if( !$result )
			{
				message_die(GENERAL_ERROR, "Couldn't insert new stock", "", __LINE__, __FILE__, $sql);
			}

			message_die(GENERAL_MESSAGE, sprintf($lang['Vault_exchange_added_return_settings'], '<a href="' . append_sid(basename(__FILE__)) . '">', '</a>'), $lang['Vault_settings']);
			break;
	}
}
else
{
	$sql = "SELECT *
		FROM " . VAULT_EXCHANGE_TABLE ."
		ORDER BY stock_id ";
	$result = $db->sql_query($sql);
	if( !$result )
	{
		message_die(GENERAL_ERROR, "Couldn't obtain stock exchange from database", "", __LINE__, __FILE__, $sql);
	}

	$exchange = $db->sql_fetchrowset($result);

	for($i = 0; $i < count($exchange); $i++)
	{		
		$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
		$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];

		$stock_name = isset($lang[$exchange[$i]['stock_name']]) ? $lang[$exchange[$i]['stock_name']] : $exchange[$i]['stock_name'];
		$stock_desc = isset($lang[$exchange[$i]['stock_desc']]) ? $lang[$exchange[$i]['stock_desc']] : $exchange[$i]['stock_desc'];

		$template->assign_block_vars("exchange", array(
			"ROW_COLOR" => "#" . $row_color,
			"ROW_CLASS" => $row_class,
			"STOCK_NAME" =>  $stock_name,
			"STOCK_DESC" =>  $stock_desc,
			"STOCK_AMOUNT" =>  $exchange[$i]['stock_price'], 
			"U_STOCK_EDIT" => append_sid("admin_vault_exchange.$phpEx?mode=edit&id=" . $exchange[$i]['stock_id']), 
			"U_STOCK_DELETE" => append_sid("admin_vault_exchange.$phpEx?mode=delete&id=" . $exchange[$i]['stock_id']))
		);
	}
	$template->assign_vars(array(
		'L_STOCK_EXCHANGE_ACTIONS' => $lang['Vault_exchange_actions'],
		'L_STOCK_NAME' => $lang['Vault_exchange_actions_name'],
		'L_STOCK_DESC' => $lang['Vault_exchange_actions_desc'],
		'L_STOCK_AMOUNT' => $lang['Vault_exchange_actions_amount'],
		'L_ACTION' => $lang['Vault_exchange_action'],
		'L_EDIT' => $lang['Vault_exchange_edit'],
		'L_DELETE' => $lang['Vault_exchange_delete'],
		'L_STOCK_ADD' => $lang['Vault_exchange_actions_add'],
	));

}

$template->assign_vars(array(
	'VAULT_EXCHANGE_USE_CHECKED' => ( $board_config['stock_use'] ? 'CHECKED' :'' ),
	'VAULT_EXCHANGE_TIME' => $board_config['stock_time'],
	'VAULT_EXCHANGE_TIME_EXPLAIN' => $lang['Vault_time_explain'].vault_make_time($board_config['stock_time']),
	'VAULT_EXCHANGE_MAX' => $vault['stock_max_change'],
	'VAULT_EXCHANGE_MIN' => $vault['stock_min_change'],
	'L_VAULT_EXCHANGE_LANGUAGE_KEY' => $lang['Vault_language_key'],
	'L_VAULT_EXCHANGE_SETTINGS' => $lang['Vault_exchange_settings'],
	'L_VAULT_EXCHANGE_SETTINGS_EXPLAIN' => $lang['Vault_exchange_settings_explain'],
	'L_VAULT_EXCHANGE_USE' => $lang['Vault_exchange_use'],
	'L_VAULT_EXCHANGE_MIN' => $lang['Vault_exchange_min'],
	'L_VAULT_EXCHANGE_MIN_EXPLAIN' => $lang['Vault_exchange_min_explain'],
	'L_VAULT_EXCHANGE_MAX' => $lang['Vault_exchange_max'],
	'L_VAULT_EXCHANGE_MAX_EXPLAIN' => $lang['Vault_exchange_max_explain'],
	'L_VAULT_EXCHANGE_TIME' => $lang['Vault_exchange_time'],
	'L_VAULT_EXCHANGE_TIME_EXPLAIN' => $lang['Vault_exchange_time_explain'],
	'L_SUBMIT' => $lang['Submit'],
	'S_VAULT_ACTION' => append_sid(basename(__FILE__)),
	"S_HIDDEN_FIELDS" => $s_hidden_fields)
);

$template->pparse('body');

include('./page_footer_admin.'.$phpEx);

?>
如果還是沒辦法的話，沒關係啦^^，那就這樣就好了
如果驕傲沒被現實大海冷冷拍響，又怎會懂得要多努力才走得到遠方；
如果夢想不曾墜落懸崖千均一髮，又怎會曉得執著的人擁有隱形翅膀。
回頂端
動機不明
喝咖啡的綠皮猴
喝咖啡的綠皮猴
文章: 1179
註冊時間: 2002-03-06 20:37
來自: GOP (重啟)

文章 由 動機不明 »

尋找\r

代碼: 選擇全部

      case "savenew": 

         $sql = "SELECT * 
         FROM " . VAULT_EXCHANGE_TABLE ." 
         ORDER BY stock_id 
         DESC LIMIT 1"; 
         $result = $db->sql_query($sql); 
         if( !$result ) 
         { 
            message_die(GENERAL_ERROR, 'Could not obtain stock exchange information', "", __LINE__, __FILE__, $sql); 
         } 
         $stock_data = $db->sql_fetchrow($result); 

         $stock_name = ( isset($HTTP_POST_VARS['stock_name']) ) ? trim($HTTP_POST_VARS['stock_name']) : trim($HTTP_GET_VARS['stock_name']); 
         $stock_desc = ( isset($HTTP_POST_VARS['stock_desc']) ) ? trim($HTTP_POST_VARS['stock_desc']) : trim($HTTP_GET_VARS['stock_desc']); 
         $stock_price = ( isset($HTTP_POST_VARS['stock_price']) ) ? intval($HTTP_POST_VARS['stock_price']) : intval($HTTP_GET_VARS['stock_price']); 
         $stock_id = $stock_data['stock_id'] +1; 

         if ($stock_name == '' || $stock_desc == '' || $stock_price == '' ) 
         { 
            message_die(MESSAGE, $lang['Fields_empty']); 
         }

取代為\r

代碼: 選擇全部

      case "savenew": 

         $sql = "SELECT * 
         FROM " . VAULT_EXCHANGE_TABLE ." 
         ORDER BY stock_id 
         DESC LIMIT 1"; 
         $result = $db->sql_query($sql); 
         if( !$result ) 
         { 
            message_die(GENERAL_ERROR, 'Could not obtain stock exchange information', "", __LINE__, __FILE__, $sql); 
         } 
         $stock_data = $db->sql_fetchrow($result); 

         $stock_name = ( isset($HTTP_POST_VARS['stock_name']) ) ? trim($HTTP_POST_VARS['stock_name']) : trim($HTTP_GET_VARS['stock_name']); 
         $stock_desc = ( isset($HTTP_POST_VARS['stock_desc']) ) ? trim($HTTP_POST_VARS['stock_desc']) : trim($HTTP_GET_VARS['stock_desc']); 
         [color=red]$stock_total = ( isset($HTTP_POST_VARS['stock_total']) ) ? intval($HTTP_POST_VARS['stock_total']) : intval($HTTP_GET_VARS['stock_total']);[/color]
         $stock_price = ( isset($HTTP_POST_VARS['stock_price']) ) ? intval($HTTP_POST_VARS['stock_price']) : intval($HTTP_GET_VARS['stock_price']); 
         $stock_id = $stock_data['stock_id'] +1; 

         if ($stock_name == '' || $stock_desc == '' [color=red]|| $stock_total == ''[/color] || $stock_price == '')
         { 
            message_die(MESSAGE, $lang['Fields_empty']); 
         }

炎之虛空 叫我無論如何都要去看 "白色巨塔" XD
所以我要先離開了~ 就麻煩你測試囉! 如果沒問題我再更新 ;)
非官方外掛問題區公告: [必看]請配合發問格式及明確主題發問(2006 02/24更新)
七點要求：
1. 發問前先搜尋，確定沒有重複後再發表
2. 主題要明確
3. 依照發問格式
4. 禁連續推文
5. 請盡量減少使用地方性語言
6. 解決問題後請修改第一篇主題，並感謝曾經幫過你的前輩們 ^^
7. 請不要將檔案內容完整貼出喔! 只要提供問題行及上下各五行就可以了
回頂端
神川小羽
調皮の小羽
調皮の小羽
文章: 1461
註冊時間: 2004-05-01 05:55
來自: 謎樣之筱語
聯繫:
聯繫 神川小羽

文章 由 神川小羽 »

其實這支 我也是用 phpMyAdmin 來加入新的資料 其實做一個文件來執行也是可以@@
-.-
回頂端
。。鳳凰寺 風。。
星球公民
星球公民
文章: 91
註冊時間: 2004-09-17 04:48
聯繫:
聯繫 。。鳳凰寺 風。。

文章 由 。。鳳凰寺 風。。 »

動機不明 寫:尋找\r

代碼: 選擇全部

      case "savenew": 

         $sql = "SELECT * 
         FROM " . VAULT_EXCHANGE_TABLE ." 
         ORDER BY stock_id 
         DESC LIMIT 1"; 
         $result = $db->sql_query($sql); 
         if( !$result ) 
         { 
            message_die(GENERAL_ERROR, 'Could not obtain stock exchange information', "", __LINE__, __FILE__, $sql); 
         } 
         $stock_data = $db->sql_fetchrow($result); 

         $stock_name = ( isset($HTTP_POST_VARS['stock_name']) ) ? trim($HTTP_POST_VARS['stock_name']) : trim($HTTP_GET_VARS['stock_name']); 
         $stock_desc = ( isset($HTTP_POST_VARS['stock_desc']) ) ? trim($HTTP_POST_VARS['stock_desc']) : trim($HTTP_GET_VARS['stock_desc']); 
         $stock_price = ( isset($HTTP_POST_VARS['stock_price']) ) ? intval($HTTP_POST_VARS['stock_price']) : intval($HTTP_GET_VARS['stock_price']); 
         $stock_id = $stock_data['stock_id'] +1; 

         if ($stock_name == '' || $stock_desc == '' || $stock_price == '' ) 
         { 
            message_die(MESSAGE, $lang['Fields_empty']); 
         }

取代為\r

代碼: 選擇全部

      case "savenew": 

         $sql = "SELECT * 
         FROM " . VAULT_EXCHANGE_TABLE ." 
         ORDER BY stock_id 
         DESC LIMIT 1"; 
         $result = $db->sql_query($sql); 
         if( !$result ) 
         { 
            message_die(GENERAL_ERROR, 'Could not obtain stock exchange information', "", __LINE__, __FILE__, $sql); 
         } 
         $stock_data = $db->sql_fetchrow($result); 

         $stock_name = ( isset($HTTP_POST_VARS['stock_name']) ) ? trim($HTTP_POST_VARS['stock_name']) : trim($HTTP_GET_VARS['stock_name']); 
         $stock_desc = ( isset($HTTP_POST_VARS['stock_desc']) ) ? trim($HTTP_POST_VARS['stock_desc']) : trim($HTTP_GET_VARS['stock_desc']); 
         [color=red]$stock_total = ( isset($HTTP_POST_VARS['stock_total']) ) ? intval($HTTP_POST_VARS['stock_total']) : intval($HTTP_GET_VARS['stock_total']);[/color]
         $stock_price = ( isset($HTTP_POST_VARS['stock_price']) ) ? intval($HTTP_POST_VARS['stock_price']) : intval($HTTP_GET_VARS['stock_price']); 
         $stock_id = $stock_data['stock_id'] +1; 

         if ($stock_name == '' || $stock_desc == '' [color=red]|| $stock_total == ''[/color] || $stock_price == '')
         { 
            message_die(MESSAGE, $lang['Fields_empty']); 
         }

炎之虛空 叫我無論如何都要去看 "白色巨塔" XD
所以我要先離開了~ 就麻煩你測試囉! 如果沒問題我再更新 ;)


感謝動機大大的幫忙^^，已經可以在後台正常新增公司了，哈~~
怎麼辦~~我覺得我高興無法言喻耶QQ

對了 我忘記要問你一件事，就是阿~~
在股票交易市場裡，上市公司的上面有一條連結是到你的版面，
那如果我以後不需要這個連結，我要去哪一個檔案改掉呢?
如果驕傲沒被現實大海冷冷拍響，又怎會懂得要多努力才走得到遠方；
如果夢想不曾墜落懸崖千均一髮，又怎會曉得執著的人擁有隱形翅膀。
回頂端
動機不明
喝咖啡的綠皮猴
喝咖啡的綠皮猴
文章: 1179
註冊時間: 2002-03-06 20:37
來自: GOP (重啟)

文章 由 動機不明 »

改 .tpl 吧... 哪一個檔忘記了
這個後來不是我整合的 :-? (小小聲：是幻狼...)

晚點才一並更新吧!

---
已經更新好了

http://home.pchome.com.tw/togo/szyang/vault_1008.rar

------
1008 修正
  • ● 漲跌幅比例修正 (較不會有股票市值不斷升高的問題)
    ● 修正後台無法新增上市公司的問題
    ● 取消說明連結
http://phpbb-tw.net/phpbb/viewtopic.php?p=143998#143998
非官方外掛問題區公告: [必看]請配合發問格式及明確主題發問(2006 02/24更新)
七點要求：
1. 發問前先搜尋，確定沒有重複後再發表
2. 主題要明確
3. 依照發問格式
4. 禁連續推文
5. 請盡量減少使用地方性語言
6. 解決問題後請修改第一篇主題，並感謝曾經幫過你的前輩們 ^^
7. 請不要將檔案內容完整貼出喔! 只要提供問題行及上下各五行就可以了
回頂端
。。鳳凰寺 風。。
星球公民
星球公民
文章: 91
註冊時間: 2004-09-17 04:48
聯繫:
聯繫 。。鳳凰寺 風。。

文章 由 。。鳳凰寺 風。。 »

呵~
那我也(小小聲告訴你：我已經改好了) :-) (ro12)
如果驕傲沒被現實大海冷冷拍響，又怎會懂得要多努力才走得到遠方；
如果夢想不曾墜落懸崖千均一髮，又怎會曉得執著的人擁有隱形翅膀。
回頂端
主題已鎖定

回到「外掛問題討論」