[問題]cash mod 2.2.1安裝sql_instal
發表於 : 2004-06-26 22:19
開始時要安裝sql_install
但出現錯誤
有些顯示成功,但有些顯示失敗
該怎麼辦好﹖
如果要手動,該怎樣做,我是個新手來的
希望多指教~~
但出現錯誤
有些顯示成功,但有些顯示失敗
該怎麼辦好﹖
如果要手動,該怎樣做,我是個新手來的
希望多指教~~
cashmod資料夾下有個檔案kamudi 寫:開始時要安裝sql_install
但出現錯誤
有些顯示成功,但有些顯示失敗
該怎麼辦好﹖
如果要手動,該怎樣做,我是個新手來的
希望多指教~~
代碼: 選擇全部
#
#-----[ SQL ]------------------------------------------
#
# If you don't know how to execute sql queries, then copy
# sql_install.php into your phpbb directory and run it.
# (assuming you use mysql or mssql)
#
# If you don't use mysql or mssql, you'll have to edit these queries accordingly
#
# If you have a different table prefix then change this command accordingly.
# I have used the default table prefix!
#
[color=red]INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_disable',0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_display_after_posts',1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_post_message','You earned %s for that post');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_disable_spam_num',10);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_disable_spam_time',24);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_disable_spam_message','You have exceeded the alloted amount of posts and will not earn anything for your post');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_installed','yes');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_version','2.2.1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_adminbig','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cash_adminnavbar','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('points_name','Points');[/color]
#
#-----[ SQL ]------------------------------------------
#
# If you have a different table prefix then change this command accordingly.
# I have used the default table prefix!
#
[color=darkred]CREATE TABLE phpbb_cash (
cash_id smallint(6) NOT NULL auto_increment,
cash_order smallint(6) NOT NULL default '0',
cash_settings smallint(4) NOT NULL default '3313',
cash_dbfield varchar(64) NOT NULL default '',
cash_name varchar(64) NOT NULL default 'GP',
cash_default int(11) NOT NULL default '0',
cash_decimals tinyint(2) NOT NULL default '0',
cash_imageurl varchar(255) NOT NULL default '',
cash_exchange int(11) NOT NULL default '1',
cash_perpost int(11) NOT NULL default '25',
cash_postbonus int(11) NOT NULL default '2',
cash_perreply int(11) NOT NULL default '25',
cash_maxearn int(11) NOT NULL default '75',
cash_perpm int(11) NOT NULL default '0',
cash_perchar int(11) NOT NULL default '20',
cash_allowance tinyint(1) NOT NULL default '0',
cash_allowanceamount int(11) NOT NULL default '0',
cash_allowancetime tinyint(2) NOT NULL default '2',
cash_allowancenext int(11) NOT NULL default '0',
cash_forumlist varchar(255) NOT NULL default '',
PRIMARY KEY (cash_id)
);[/color]
#
#-----[ SQL ]------------------------------------------
#
# If you have a different table prefix then change this command accordingly.
# I have used the default table prefix!
#
[color=red]CREATE TABLE phpbb_cash_events (
event_name varchar(32) NOT NULL default '',
event_data varchar(255) NOT NULL default '',
PRIMARY KEY (event_name)
);[/color]
#
#-----[ SQL ]------------------------------------------
#
# If you have a different table prefix then change this command accordingly.
# I have used the default table prefix!
#
[color=darkred]CREATE TABLE phpbb_cash_exchange (
ex_cash_id1 int(11) NOT NULL default '0',
ex_cash_id2 int(11) NOT NULL default '0',
ex_cash_enabled int(1) NOT NULL default '0',
PRIMARY KEY (ex_cash_id1,ex_cash_id2)
);[/color]
#
#-----[ SQL ]------------------------------------------
#
# If you have a different table prefix then change this command accordingly.
# I have used the default table prefix!
#
[color=red]CREATE TABLE phpbb_cash_groups (
group_id mediumint(6) NOT NULL default '0',
group_type tinyint(2) NOT NULL default '0',
cash_id smallint(6) NOT NULL default '0',
cash_perpost int(11) NOT NULL default '0',
cash_postbonus int(11) NOT NULL default '0',
cash_perreply int(11) NOT NULL default '0',
cash_perchar int(11) NOT NULL default '0',
cash_maxearn int(11) NOT NULL default '0',
cash_perpm int(11) NOT NULL default '0',
cash_allowance tinyint(1) NOT NULL default '0',
cash_allowanceamount int(11) NOT NULL default '0',
cash_allowancetime tinyint(2) NOT NULL default '2',
cash_allowancenext int(11) NOT NULL default '0',
PRIMARY KEY (group_id,group_type,cash_id)
);[/color]
#
#-----[ SQL ]------------------------------------------
#
# If you have a different table prefix then change this command accordingly.
# I have used the default table prefix!
#
[color=darkred]CREATE TABLE phpbb_cash_log (
log_id int(11) NOT NULL auto_increment,
log_time int(11) NOT NULL default '0',
log_type smallint(6) NOT NULL default '0',
log_action varchar(255) NOT NULL default '',
log_text varchar(255) NOT NULL default '',
PRIMARY KEY (log_id)
);[/color]

你的意思是我已經有那些資料對嗎﹖Mac 寫:那些字你查過字典嗎?
如果查過,你便會知道它意指你想要新增的欄位已經存在了
~Mac


我要你注意的是這一句話kamudi 寫:但我把所有的安裝都做好了,還未能用到
先謝謝你們的幫忙Mac 寫:我要你注意的是這一句話kamudi 寫:但我把所有的安裝都做好了,還未能用到
到底是怎麼樣一個不能用的情況
你都沒有提到,我們怎麼會知道問題在哪裡?
~Mac


代碼: 選擇全部
#
#-----[ OPEN ]------------------------------------------
#
includes/functions.php
#
#-----[ FIND ]------------------------------------------
#
include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main.' . $phpEx);
#
#-----[ AFTER, ADD ]------------------------------------------
#
if ( defined('IN_CASHMOD') )
{
if ( !file_exists(@phpbb_realpath($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_cash.'.$phpEx)) )
{
include($phpbb_root_path . 'language/lang_english/lang_cash.' . $phpEx);
}
else
{
include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_cash.' . $phpEx);
}
}是不是把這個lang_cash.php擺上去就可以正常使用啦﹖Mac 寫:文字的方面,的確是附加的語系沒有上傳至正確的地方\r
記得,中文化的語系要擺在中文的文件夾中\r
~Mac