Tips om te instaleren
Geplaatst: 09 jun 2005, 18:01
Hey ik wil de cashmod instaleren, wat moet ik doen om te voorkomen dat het fout gaat? dat is al zo vaak gebeurt, dat wil ik niet nog een keer, zeker omdat ik nu 111 members heb
Pagina 1 van 2
bac
Geplaatst: 09 jun 2005, 18:02
backupp nemen van al je bestanden die je gaat editen , en backup van je mysql tabel ...
Geplaatst: 09 jun 2005, 18:16
wat maakt het uit 
Heel erg actief zijn je members niet
ja psies, ik zou ook een backup nemen. Dan behou je alle posts (tog?!) en alle members
Heel erg actief zijn je members niet
ja psies, ik zou ook een backup nemen. Dan behou je alle posts (tog?!) en alle members
Geplaatst: 10 jun 2005, 15:28
Geplaatst: 11 jun 2005, 10:42
Bedankt voor de tips, ik ga nu aan de slag
Als ik problemen krijg dan zeg ik het hier wel
Als ik problemen krijg dan zeg ik het hier wel
Geplaatst: 11 jun 2005, 11:38
Ik heb alles gedaan, alleen nog de sql, maar dat mislukt 
ik heb sql_install.php erin gezet en ben ernaar toe gegaan
maar dan krijg je dit
Wat moet ik doen?
alvast bedankt
ik heb sql_install.php erin gezet en ben ernaar toe gegaan
maar dan krijg je dit
Code: Selecteer alles
Fatal error: Call to undefined function: message_die() in /home/virtual/site59/fst/var/www/html/sql_install.php on line 33
alvast bedankt
Geplaatst: 11 jun 2005, 11:52
Geef de eerste 30 regels van het bestand eens.
Geplaatst: 11 jun 2005, 12:09
Code: Selecteer alles
<?php
/***************************************************************************
* sql_install.php
* -------------------
* begin : Thursday, Apr 17, 2003
* copyright : (C) 2003 Xore
* email : mods@xore.ca
*
* $Id: sql_install.php,v 2.2.0.0 2003/10/18 00:49:26 Xore $
*
*
***************************************************************************/
/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
***************************************************************************/
define('IN_PHPBB', true);
$phpbb_root_path = './';
$i = 0;
while ( !file_exists($phpbb_root_path . 'extension.inc') && ($i++ < 4) )
{
$phpbb_root_path .= '../';
}
if ( $i > 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.2 Tables, Updating Configuration settings';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
print<<<DELIM
<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">
<tr>
<th class="thHead">Updating the database</th>
</tr>
<tr>
<td>
<span class="genmed">
<ul type="circle">
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.2');",
"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.2');",
"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('<li>' . nl2br($query) . '<br /> +++ <font color="#FF0000"><b>Error:</b></font> ' . $error['message'] . '</li><br />');
}
else
{
print('<li>' . nl2br($query) . '<br /> +++ <font color="#00AA00"><b>Successfull</b></font></li><br />');
}
}
$forum_url = append_sid($phpbb_root_path . "index.$phpEx");
$phpbb_url = "http://www.phpbb.com/phpBB/viewtopic.php?t=94055#623226";
print<<<DELIM
</ul>
</span>
</td>
</tr>
<tr>
<td class="catBottom" height="28"> </td>
</tr>
<tr>
<td class="catBottom" colspan="2" align="center">Finished</td>
</tr>
</table>
<br />
<br />
<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">
<tr>
<th class="thHead">SQL Installation complete</th>
</tr>
<tr>
<td>
<span class="genmed">Please delete this file (sql_install.{$phpEx}).<br />
If you have any problems, please visit <a href="{$phpbb_url}" target="_new">phpbb.com (CashMod v 2.2.2 Support Thread)</a> and ask for help.</span>
</td>
</tr>
<tr>
<td class="catBottom" height="28" align="center">
<span class="genmed"><a href="{$forum_url}">Click Here to return to your forum.</a>
</span>
</td>
</tr>
</table>
DELIM;
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>
Geplaatst: 11 jun 2005, 12:42
Haal dit eens weg uit het bestand
Code: Selecteer alles
$i = 0;
while ( !file_exists($phpbb_root_path . 'extension.inc') && ($i++ < 4) )
{
$phpbb_root_path .= '../';
}
if ( $i > 4 )
{
message_die(GENERAL_MESSAGE, 'Unable to find extension.inc, terminating. Please move this file into your main/"root" phpbb directory and try again.');
} Geplaatst: 11 jun 2005, 13:02
Nu staat er dit:
Code: Selecteer alles
Warning: main(): Unable to access ./extension.inc in /home/virtual/site59/fst/var/www/html/sql_install.php on line 28
Warning: main(./extension.inc): failed to open stream: No such file or directory in /home/virtual/site59/fst/var/www/html/sql_install.php on line 28
Warning: main(): Unable to access ./extension.inc in /home/virtual/site59/fst/var/www/html/sql_install.php on line 28
Warning: main(./extension.inc): failed to open stream: No such file or directory in /home/virtual/site59/fst/var/www/html/sql_install.php on line 28
Warning: main(): Failed opening './extension.inc' for inclusion (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site59/fst/var/www/html/sql_install.php on line 28
Warning: main(): Unable to access ./common. in /home/virtual/site59/fst/var/www/html/sql_install.php on line 29
Warning: main(./common.): failed to open stream: No such file or directory in /home/virtual/site59/fst/var/www/html/sql_install.php on line 29
Warning: main(): Unable to access ./common. in /home/virtual/site59/fst/var/www/html/sql_install.php on line 29
Warning: main(./common.): failed to open stream: No such file or directory in /home/virtual/site59/fst/var/www/html/sql_install.php on line 29
Warning: main(): Failed opening './common.' for inclusion (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site59/fst/var/www/html/sql_install.php on line 29
Fatal error: Call to undefined function: session_pagestart() in /home/virtual/site59/fst/var/www/html/sql_install.php on line 34Geplaatst: 11 jun 2005, 14:00
Je moet hem in de forum map zetten 
Geplaatst: 11 jun 2005, 16:11
Het is gelukt 
domme fout
Heel erg bedankt, ik wil je site wel linken op http://www.hiphopkings.nl
Heb best veel bezoekers
domme fout Heel erg bedankt, ik wil je site wel linken op http://www.hiphopkings.nl
Heb best veel bezoekers
Geplaatst: 11 jun 2005, 16:29
Weer iets 
Als ik een currencie aanmaak komt er dit te staan
Moet ik de sql handmatig doen?
Als ik een currencie aanmaak komt er dit te staan
Code: Selecteer alles
phpBB : Critical Error
Unable to insert new record into cash table
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near 's','user_money',1,0)' at line 3
INSERT INTO cash (cash_name, cash_dbfield, cash_order, cash_decimals) VALUES ('Doekoe's','user_money',1,0)
Line : 376
File : /home/virtual/site59/fst/var/www/html/forum/admin/cash_currencies.php Geplaatst: 11 jun 2005, 16:53
je mag geen ' er in hebben zitten 
Geplaatst: 11 jun 2005, 19:03
Hoe bedoel je?paulus schreef:je mag geen ' er in hebben zitten
Geplaatst: 11 jun 2005, 19:05
dat het teken ' niet in de naam of veldnaam mag zitten
Geplaatst: 11 jun 2005, 20:35
Ik heb geen ' erin staan
Geplaatst: 11 jun 2005, 20:36
dat had je wel, als naam ervoorINSERT INTO cash (cash_name, cash_dbfield, cash_order, cash_decimals) VALUES ('Doekoe's','user_money',1,0)
Geplaatst: 11 jun 2005, 22:28
Ooh zo, toch wel sorry
sorryGeplaatst: 11 jun 2005, 22:29
MAar ik krijg nog steeds dezelfde error
Code: Selecteer alles
phpBB : Critical Error
Could not update user table (possibly duplicate cash db field)
DEBUG MODE
SQL Error : 1060 Duplicate column name 'user_doekoe'
ALTER TABLE users ADD user_doekoe DECIMAL(11,0) NOT NULL DEFAULT '5'
Line : 352
File : /home/virtual/site59/fst/var/www/html/forum/admin/cash_currencies.php