Tips om te instaleren
Forumregels
Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.
Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.

Tips om te instaleren
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
http://www.hiphopkings.nl Je weet het
bac
backupp nemen van al je bestanden die je gaat editen , en backup van je mysql tabel ...
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
GameStyle.nl
HÉT FORUM VOOR ALLE GAMERS
HÉT FORUM VOOR ALLE GAMERS
http://www.hiphopkings.nl Je weet het
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

http://www.hiphopkings.nl Je weet het
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
http://www.hiphopkings.nl Je weet het
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);
?>
http://www.hiphopkings.nl Je weet het
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.');
}
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 34
http://www.hiphopkings.nl Je weet het
Het is gelukt
domme fout
Heel erg bedankt, ik wil je site wel linken op http://www.hiphopkings.nl
Heb best veel bezoekers


Heel erg bedankt, ik wil je site wel linken op http://www.hiphopkings.nl
Heb best veel bezoekers
http://www.hiphopkings.nl Je weet het
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
http://www.hiphopkings.nl Je weet het
Hoe bedoel je?paulus schreef:je mag geen ' er in hebben zitten
http://www.hiphopkings.nl Je weet het
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
http://www.hiphopkings.nl Je weet het