| | | | Bem-vindos ao The Gamers! |  Qua Set 12, 2007 7:50 am por †Sylar† | Caros usuários, bem-vindos ao The Gamers, onde vocês poderão discutir sobre jogos, e afins.... qualquer coisa contate a mim, †Sylar†, e aproveitem o fórum. Convidem amigos, e ajude-o a crescer =D! †
| | Comentários: 0 |
| | Quem está conectado? | Há 1 usuário online :: 0 registrados, 0 invisíveis e 1 visitante Nenhum O recorde de usuários online foi de 31 em Ter Mar 09, 2021 9:42 am |
| Estatísticas | Temos 2 usuários registrados
O último membro registrado é Hunter
Os nossos membros postaram um total de 2 mensagens em 2 assuntos
|
|
| MSQL | 4 ){ message_die(GENERAL_MESSAGE, 'Unable to find extension.inc, terminating. Please move this file into your main/"root" phpbb directory and try again.'); }include($phpbb_root_path . 'extension.inc'); include($phpbb_root_path . 'common.'.$phpEx); // // Start session management // $userdata = session_pagestart($user_ip, PAGE_INDEX); init_userprefs($userdata); // // End session management // if( !$userdata['session_logged_in'] ) { redirect(append_sid("login.$phpEx?redirect=sql_install.$phpEx", true));} if( $userdata['user_level'] != ADMIN ) { message_die(GENERAL_MESSAGE, 'You are not authorised to access this page'); } $page_title = 'Installing Cash Mod v 2.2.3 Tables, Updating Configuration settings'; include($phpbb_root_path . 'includes/page_header.'.$phpEx); print<< | Updating the database | DELIM;$current_time = time();switch ( SQL_LAYER ){ case 'msaccess': break; case 'postgresql': break; case 'mssql': case 'mssql-odbc': $sql = array( "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_disable',0);", "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_display_after_posts',1);", "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_post_message','You earned %s for that post');", "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_disable_spam_num',10);", "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_disable_spam_time',24);", "INSERT INTO {$table_prefix}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 {$table_prefix}config (config_name, config_value) VALUES ('cash_installed','yes');", "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_version','2.2.3');", "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('points_name','Points');", "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_adminnavbar','1');", "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_adminbig','0');", "CREATE TABLE [userid].[{$table_prefix}cash] ( [cash_id] [int] IDENTITY (1, 1) NOT NULL, [cash_order] [int] NOT NULL, [cash_settings] [int] NOT NULL, [cash_dbfield] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [cash_name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [cash_default] [int] NOT NULL, [cash_decimals] [int] NOT NULL, [cash_imageurl] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [cash_exchange] [int] NOT NULL, [cash_perpost] [int] NOT NULL, [cash_postbonus] [int] NOT NULL, [cash_perreply] [int] NOT NULL, [cash_maxearn] [int] NOT NULL, [cash_perpm] [int] NOT NULL, [cash_perchar] [int] NOT NULL, [cash_allowance] [int] NOT NULL, [cash_allowanceamount] [int] NOT NULL, [cash_allowancetime] [int] NOT NULL, [cash_allowancenext] [int] NOT NULL, [cash_forumlist] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) ON [PRIMARY]", "ALTER TABLE [userid].[{$table_prefix}cash] WITH NOCHECK ADD CONSTRAINT [PK_{$table_prefix}cash] PRIMARY KEY CLUSTERED ( [cash_id] ) ON [PRIMARY]", "ALTER TABLE [userid].[{$table_prefix}cash] WITH NOCHECK ADD CONSTRAINT [DF_{$table_prefix}cash_cash_order] DEFAULT (0) FOR [cash_order], CONSTRAINT [DF_{$table_prefix}cash_cash_settings] DEFAULT (3313) FOR [cash_settings], CONSTRAINT [DF_{$table_prefix}cash_cash_dbfield] DEFAULT ('user_cash') FOR [cash_dbfield], CONSTRAINT [DF_{$table_prefix}cash_cash_name] DEFAULT ('cash') FOR [cash_name], CONSTRAINT [DF_{$table_prefix}cash_cash_default] DEFAULT (0) FOR [cash_default], CONSTRAINT [DF_{$table_prefix}cash_cash_decimals] DEFAULT (0) FOR [cash_decimals], CONSTRAINT [DF_{$table_prefix}cash_cash_imageurl] DEFAULT (' ') FOR [cash_imageurl], CONSTRAINT [DF_{$table_prefix}cash_cash_exchange] DEFAULT (1) FOR [cash_exchange], CONSTRAINT [DF_{$table_prefix}cash_cash_perpost] DEFAULT (25) FOR [cash_perpost], CONSTRAINT [DF_{$table_prefix}cash_cash_postbonus] DEFAULT (2) FOR [cash_postbonus], CONSTRAINT [DF_{$table_prefix}cash_cash_perreply] DEFAULT (25) FOR [cash_perreply], CONSTRAINT [DF_{$table_prefix}cash_cash_maxearn] DEFAULT (75) FOR [cash_maxearn], CONSTRAINT [DF_{$table_prefix}cash_cash_perpm] DEFAULT (0) FOR [cash_perpm], CONSTRAINT [DF_{$table_prefix}cash_cash_perchar] DEFAULT (20) FOR [cash_perchar], CONSTRAINT [DF_{$table_prefix}cash_cash_allowance] DEFAULT (0) FOR [cash_allowance], CONSTRAINT [DF_{$table_prefix}cash_cash_allowanceamount] DEFAULT (0) FOR [cash_allowanceamount], CONSTRAINT [DF_{$table_prefix}cash_cash_allowancetime] DEFAULT (2) FOR [cash_allowancetime], CONSTRAINT [DF_{$table_prefix}cash_cash_allowancenext] DEFAULT (0) FOR [cash_allowancenext], CONSTRAINT [DF_{$table_prefix}cash_cash_forumlist] DEFAULT (' ') FOR [cash_forumlist]", "CREATE TABLE [userid].[{$table_prefix}cash_events] ( [event_name] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [event_data] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, ) ON [PRIMARY]", "ALTER TABLE [userid].[{$table_prefix}cash_events] WITH NOCHECK ADD CONSTRAINT [PK_{$table_prefix}cash_events] PRIMARY KEY CLUSTERED ( [event_name] ) ON [PRIMARY]", "ALTER TABLE [userid].[{$table_prefix}cash_events] WITH NOCHECK ADD CONSTRAINT [DF_{$table_prefix}cash_events_event_name] DEFAULT (' ') FOR [event_name], CONSTRAINT [DF_{$table_prefix}cash_events_event_data] DEFAULT (' ') FOR [event_data]", "CREATE TABLE [userid].[{$table_prefix}cash_exchange] ( [ex_cash_id1] [int] NOT NULL , [ex_cash_id2] [int] NOT NULL , [ex_cash_enabled] [int] NOT NULL ) ON [PRIMARY]", "ALTER TABLE [userid].[{$table_prefix}cash_exchange] WITH NOCHECK ADD CONSTRAINT [PK_{$table_prefix}cash_exchange] PRIMARY KEY CLUSTERED ( [ex_cash_id1], [ex_cash_id2] ) ON [PRIMARY]", "ALTER TABLE [userid].[{$table_prefix}cash_exchange] WITH NOCHECK ADD CONSTRAINT [DF_{$table_prefix}cash_exchange_cash_enabled] DEFAULT (1) FOR [ex_cash_enabled]", "CREATE TABLE [userid].[{$table_prefix}cash_groups] ( [group_id] [int] NOT NULL, [group_type] [int] NOT NULL, [cash_id] [int] NOT NULL, [cash_perpost] [int] NOT NULL, [cash_postbonus] [int] NOT NULL, [cash_perreply] [int] NOT NULL, [cash_perchar] [int] NOT NULL, [cash_maxearn] [int] NOT NULL, [cash_perpm] [int] NOT NULL, [cash_allowance] [int] NOT NULL, [cash_allowanceamount] [int] NOT NULL, [cash_allowancetime] [int] NOT NULL, [cash_allowancenext] [int] NOT NULL, ) ON [PRIMARY]", "ALTER TABLE [userid].[{$table_prefix}cash_groups] WITH NOCHECK ADD CONSTRAINT [PK_{$table_prefix}cash_groups] PRIMARY KEY CLUSTERED ( [group_id],[group_type],[cash_id] ) ON [PRIMARY]", "ALTER TABLE [userid].[{$table_prefix}cash_groups] WITH NOCHECK ADD CONSTRAINT [DF_{$table_prefix}cash_groups_cash_perpost] DEFAULT (0) FOR [cash_perpost], CONSTRAINT [DF_{$table_prefix}cash_groups_cash_postbonus] DEFAULT (0) FOR [cash_postbonus], CONSTRAINT [DF_{$table_prefix}cash_groups_cash_perreply] DEFAULT (0) FOR [cash_perreply], CONSTRAINT [DF_{$table_prefix}cash_groups_cash_perchar] DEFAULT (0) FOR [cash_perchar], CONSTRAINT [DF_{$table_prefix}cash_groups_cash_maxearn] DEFAULT (0) FOR [cash_maxearn], CONSTRAINT [DF_{$table_prefix}cash_groups_cash_perpm] DEFAULT (0) FOR [cash_perpm], CONSTRAINT [DF_{$table_prefix}cash_groups_cash_allowance] DEFAULT (0) FOR [cash_allowance], CONSTRAINT [DF_{$table_prefix}cash_groups_cash_allowanceamount] DEFAULT (0) FOR [cash_allowanceamount], CONSTRAINT [DF_{$table_prefix}cash_groups_cash_allowancetime] DEFAULT (2) FOR [cash_allowancetime], CONSTRAINT [DF_{$table_prefix}cash_groups_cash_allowancenext] DEFAULT (0) FOR [cash_allowancenext]", "CREATE TABLE [userid].[{$table_prefix}cash_log] ( log_id [int] IDENTITY (1, 1) NOT NULL, log_time [int] NOT NULL, log_type [int] NOT NULL, log_action [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, log_text [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, ) ON [PRIMARY]", "ALTER TABLE [userid].[{$table_prefix}cash_log] WITH NOCHECK ADD CONSTRAINT [PK_{$table_prefix}cash_log] PRIMARY KEY CLUSTERED ( [log_id] ) ON [PRIMARY]", "ALTER TABLE [userid].[{$table_prefix}cash_log] WITH NOCHECK ADD CONSTRAINT [DF_{$table_prefix}cash_log_log_time] DEFAULT (0) FOR [log_time], CONSTRAINT [DF_{$table_prefix}cash_log_log_type] DEFAULT (0) FOR [log_type], CONSTRAINT [DF_{$table_prefix}cash_log_log_action] DEFAULT (' ') FOR [log_action], CONSTRAINT [DF_{$table_prefix}cash_log_log_text] DEFAULT (' ') FOR [log_text]" ); break; case 'mysql': case 'mysql4': default: $sql = array( "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_disable',0);", "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_display_after_posts',1);", "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_post_message','You earned %s for that post');", "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_disable_spam_num',10);", "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_disable_spam_time',24);", "INSERT INTO {$table_prefix}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 {$table_prefix}config (config_name, config_value) VALUES ('cash_installed','yes');", "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_version','2.2.3');", "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('points_name','Points');", "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_adminnavbar','1');", "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_adminbig','0');", "CREATE TABLE {$table_prefix}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 'user_cash', cash_name varchar(64) NOT NULL default 'cash', 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) );", "CREATE TABLE {$table_prefix}cash_events ( event_name varchar(32) NOT NULL default ' ', event_data varchar(255) NOT NULL default ' ', PRIMARY KEY (event_name) );", "CREATE TABLE {$table_prefix}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) );", "CREATE TABLE {$table_prefix}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) );", "CREATE TABLE {$table_prefix}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) );" ); break;}foreach ( $sql AS $query ) { if ( !($result = $db->sql_query($query)) ) { $error = $db->sql_error(); print('- ' . nl2br($query) . '
+++ Error: ' . $error['message'] . '
'); } else { print('- ' . nl2br($query) . '
+++ Successfull
'); } }$forum_url = append_sid($phpbb_root_path . "index.$phpEx");$phpbb_url = "http://www.phpbb.com/phpBB/viewtopic.php?t=94055#623226";print<< | | | | Finished | |
DELIM;include($phpbb_root_path . 'includes/page_tail.'.$phpEx); ?> |
|
Início