Error, bij installeren mod.

larsisgoed9 · Bericht door **larsisgoed9** » 01 mar 2008, 09:28

Modificatie & Versie: Simple Points System
Directe link naar de modificatie: viewtopic.php?f=56&t=37586
Adres van je forum: http://criminalssetup.xtreemhost.com/forum
phpBB versie: 3.00
Heb je onlangs een andere modificatie of stijl geïnstalleerd? Ja. Visual Warning Mod

Wat is het probleem? Ik heb alles gedaan, wat ik moest doen voor die mod, die Simpel punten systeem.
Toen wou ik wat instellingen gaan doen, voor dat systeem, en dan krijg ik deze foutmelding(en)

Algemene fout
SQL ERROR [ mysqli ]

Duplicate entry 'points_enable' for key 1 [1062]

SQL

INSERT INTO phpbb3_config (config_name, config_value, is_dynamic) VALUES ('points_enable', 1, 0)

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()

FILE: includes/functions.php
LINE: 156
CALL: dbal_mysqli->sql_query()

FILE: includes/acp/acp_board.php
LINE: 420
CALL: set_config()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_board->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

Gelieve de beheerder of webmaster te contacteren: info@larsgroot.nl.

Zou iemand mij kunnen vertellen, wat ik fout gedaan heb?

Onderstaande code, is de installatie file van de mod:

Spoiler: bekijk

Code: Selecteer alles

Installation Instructions for 'Simpel Punten Systeem' Version 0.4.0c
Select Language:  English  
About this MOD
Title:
nl 
Simpel Punten Systeem

en-gb 
Simple Points System

Description:
nl 
Deze mod voegt een simpel beloningen systeem toe aan je forum.
Deze ondersteunt een enkele valuta. Je kan het aantal punten per nieuw onderwerp en reactie instellen. Ook kan je de naam van de valuta configureren. Gebruikers kunnen punten aan anderen doneren.

en-gb 
This mod adds a simple rewards system to your forum.
It supports only one currency. You can set the amount of points per new topic and reply. You can also set the name of the currency. Users can donate points to others.

Version:
0.4.0c

Installation Level:
Easy

Installation Time:
~15minutes

Author
Username:
Ganon_master 
Email:
hidde@electricnation.nl 
Name:
Hidde Jansen 
WWW:
http://www.electricnation.nl 

Files to Edit
memberlist.php, 
posting.php, 
viewtopic.php, 
adm/style/acp_users_profile.html, 
includes/acp/acp_board.php, 
includes/acp/acp_users.php, 
includes/acp/acp_permissions.php 
Included Files
root/donate.php, 
root/includes/mods/functions_points.php, 
root/language/en/mods/donate.php 

--------------------------------------------------------------------------------

Disclaimer
For security purposes, please check: http://www.phpbb.com/mods/ for the latest version of this MOD. Downloading this MOD from other sites could cause malicious code to enter into your phpBB Forum. As such, phpBB will not offer support for MODs not offered in our MODs database, located at: http://www.phpbb.com/mods/

Author Notes
nl 
Als je de SQL aanpassingen niet handmatig kan uitvoeren kan je in plaats daarvan, het bestand db_update.php naar de phpBB root map uploaden en openen in je browser. Zorg ervoor dat je dit bestand na het uitvoeren verwijdert.

Zorg ervoor dat je de cache update na het handmatig uitvoeren van de SQL queries.

De Nederlandse taal aanpassingen kan je vinden in de /language map.

Je zult de permissies voor ieder forum moeten instellen voordat de gebruikers punten kunnen verdienen. 
en-gb 
If you are unable to make the SQL changes manually, you can also upload db_update.php to your phpBB root directory and open it in your browser. Make sure you delete this file afterwards.

Make sure you update the cache after adding the SQL queries manually.

You'll have to update the permissions for each forum before users can earn points. 
MOD History
2007-06-01- Version 0.4.0b

nl 
Bugfixes. Een hoop missende code in het installatie bestand...

en-gb 
Bugfixes. Lots of missing code in the install file.

2007-06-01- Version 0.4.0a

nl 
Bugfixes. Een hoop missende code in het installatie bestand...

Implementatie van de m_points permissie.

en-gb 
Bugfixes. Lots of missing code in the install file.

Implementation of the m_points permission.

2007-05-31- Version 0.4.0

nl 
Punten donatie.

Moderator punten aanpassen.

RC2 compatible.

en-gb 
Points donation.

Moderator points modification.

RC2 compatible.

2007-05-29- Version 0.3.1

nl 
Punten bericht niet te zien voor gebruikers die geen punten permissies hebben in bepaalde forums.

Vernieuwd prosilver MODX stylesheet toegevoegd.

en-gb 
Points message doesn't show for users who don't have points permission in certain forums.

Added the updated prosilver MODX stylesheet.

2007-05-28- Version 0.3.0

nl 
Forum permissies. Je kan het verdienen van punten per forum in- of uitschakelen.

en-gb 
Forum permissions. You can now enable the earning of points per forum.

2007-05-23- Version 0.2.3

nl 
Updates om overeen te komen met de MODX standaard.

db_update.php aangepast met set_config().

en-gb 
Updates to meet the MODX standards.

db_update.php adjusted with set_config().

2007-05-20- Version 0.2.2

nl 
Installatie bestand geupdate.

db_update.php toegevoegd.

en-gb 
Install file updated.

db_update.php added.

2007-05-13- Version 0.2.1

nl 
Punten telling gefixt voor quotes. Met dank aan Marihuan.

De punten display veranderd op de gebruikersprofiel pagina.

Het subSilver MODX stylesheet verwijderd en het prosilver stylesheet toegevoegd.

Nederlandse taal aanpassingen toegevoegd.

MODX bestanden nu ook in het Nederlands.

en-gb 
Fixed points count for quotes. Thank you, Marihuan.

Changed the points display on a user's profile page.

Discarded the subSilver MODX stylesheet and added the prosilver stylesheet.

Added Dutch language edits.

Provided the MODX files in Dutch.

2007-04-25- Version 0.2.0b

nl 
Een kleine typfout verbeterd. Met dank aan Marihuan.

en-gb 
Fixed a little typo. Thank you, Marihuan.

2007-04-25- Version 0.2.0a

nl 
Het eerder missende SQL commando geupdate. Het bevatte niet de juiste tabel prefix. :x

en-gb 
Updated the previously missing SQL command. It didn't have the default table prefix. :x

2007-04-24- Version 0.2.0

nl 
Administrator kan gebruiker's punten aanpassen

Een missend SQL commando toegevoegd.

en-gb 
Admin edit points.

Included a missing SQL command.

2007-04-22- Version 0.1.0

nl 
Eerste BETA release.

en-gb 
First BETA release.

2007-07-02- Version 0.4.0c

nl 
Bugfixes.

en-GB 
Bugfixes.

License
This MOD has been licensed under the following license:

http://opensource.org/licenses/gpl-license.php GNU General Public License v2

Other Notes
Before adding this MOD to your forum, you should back up all files related to this MOD

This MOD was designed for phpBB3.0.RC2and may not function as stated on other phpBB versions. MODs for phpBB3.0 will not work on phpBB2.0 and vice versa.

This MOD is development quality. It is not recommended that you install it on a live forum.

English Support
English support can be obtained at http://www.phpbb.com/mods/ for released MODs.

 
--------------------------------------------------------------------------------
SQL
Code: Select All
INSERT INTO phpbb_config (config_name, config_value) VALUES ('points_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('points_name', 'Points');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('points_topic', '20');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('points_post', '10');

INSERT INTO phpbb_acl_options( auth_option, is_global, is_local ) VALUES ('f_points', 0, 1);
INSERT INTO phpbb_acl_options( auth_option, is_global, is_local ) VALUES ('m_points', 1, 0);

ALTER TABLE `phpbb_users` ADD `user_points` INT( 11 ) NOT NULL DEFAULT '0';
		
File Copy

Copy: root/donate.php 
To: donate.php 

Copy: root/includes/mods/functions_points.php 
To: includes/mods/functions_points.php 

Copy: root/language/en/mods/donate.php 
To: language/en/mods/donate.php 
Edits
s↑↓
Use your keyboard to navigate the code boxes. You may also hit 's' on your keyboard to go to the first code box.

Open: memberlist.php
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
$user->setup(array('memberlist', 'groups'));
			
In-line Find
Tip: This is a partial match of a line for in-line operations.

Code: Select All
, 'groups'
In-line Add after


Code: Select All
, 'mods/points'
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
'U_REMOVE_FOE'		=> ($foe) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=zebra&remove=1&mode=foes&usernames[]=' . $user_id) : '',
			
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code: Select All
			'POINTS_NAME'		=> $config['points_name'],
			'POINTS'			=> $member['user_points'],
			'POINTS_ENABLE'		=> $config['points_enable'],
			'U_POINTS_DONATE'	=> append_sid("{$phpbb_root_path}donate.$phpEx", "user_id=".$user_id),
			'L_DONATE'			=> sprintf($user->lang['DONATE'], $config['points_name']),
			'L_MOD_USER_POINTS'	=> ($auth->acl_get('a_') || $auth->acl_get('m_points')) ? sprintf($user->lang['MODIFY_POINTS'], $config['points_name']) : '',
			'U_POINTS_MODIFY'	=> ($auth->acl_get('a_') || $auth->acl_get('m_points')) ? append_sid("{$phpbb_root_path}donate.$phpEx", "user_id=".$user_id."&adm_points=1")  : '',
				
Open: posting.php
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
include($phpbb_root_path . 'includes/functions_display.' . $phpEx);
include($phpbb_root_path . 'includes/message_parser.' . $phpEx);
			
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code: Select All
include($phpbb_root_path . 'includes/mods/functions_points.' . $phpEx);
				
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
$redirect_url = submit_post($mode, $post_data['post_subject'], $post_data['username'], $post_data['topic_type'], $poll, $data, $update_message);
			
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code: Select All
			//Simple Points System
			$user->add_lang('mods/points');
			if($user->data['is_registered'] && ($mode == 'reply' || $mode == 'post' || $mode == 'quote') && $auth->acl_get('f_points', $data['forum_id']))
			{
				$amount = (($mode == 'reply') || ($mode == "quote")) ? $config['points_post'] : $config['points_topic'];
				add_points($user->data['user_id'], $amount);
			}
			$points_message = ($config['points_enable'] && ($mode == 'reply' || $mode == 'post' || $mode == 'quote') && $auth->acl_get('f_points', $data['forum_id'])) ? '<br /><br />' . sprintf($user->lang['POINTS_EARNED'], $amount, $config['points_name']) . '<br /><br />' : '';
				
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
$message = ($mode == 'edit') ? $user->lang['POST_EDITED_MOD'] : $user->lang['POST_STORED_MOD'];
			
In-line Find
Tip: This is a partial match of a line for in-line operations.

Code: Select All
: $user->lang['POST_STORED_MOD']
In-line Add after


Code: Select All
 . $points_message
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
$message = $user->lang[$message] . sprintf($user->lang['VIEW_MESSAGE'], '<a href="' . $redirect_url . '">', '</a>');
			
In-line Find
Tip: This is a partial match of a line for in-line operations.

Code: Select All
$user->lang[$message] . 
In-line Add after


Code: Select All
 $points_message . 
Open: viewtopic.php
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
// Start session management
$user->session_begin();
$auth->acl($user->data);
			
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code: Select All
$user->add_lang('mods/points');
				
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
'allow_pm'			=> 0,
			
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code: Select All
'points'		=> '',
				
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
'search'		=> ($auth->acl_get('u_search')) ? append_sid("{$phpbb_root_path}search.$phpEx", 'search_author=' . urlencode($row['username']) .'&showresults=posts') : '',
			
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code: Select All
'points'		=> $row['user_points'],
				
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
'L_IGNORE_POST'		=> ($row['hide_post']) ? sprintf($user->lang['POST_BY_FOE'], get_username_string('full', $poster_id, $row['username'], $row['user_colour'], $row['post_username']), '<a href="' . $viewtopic_url . "&p={$row['post_id']}&view=show#p{$row['post_id']}" . '">', '</a>') : '',
			
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code: Select All
'POINTS_NAME'		=> $config['points_name'],
		'POINTS'			=> $user_cache[$poster_id]['points'],
		'POINTS_ENABLE'		=> $config['points_enable'],
		'U_POINTS_DONATE'	=> append_sid("{$phpbb_root_path}donate.$phpEx", "user_id=".$poster_id."&post_id=".$row['post_id']),
		'L_DONATE'			=> sprintf($user->lang['DONATE'], $config['points_name']),
		'L_MOD_USER_POINTS'	=> ($auth->acl_get('a_') || $auth->acl_get('m_points')) ? sprintf($user->lang['MODIFY_POINTS'], $config['points_name']) : '',
		'U_POINTS_MODIFY'	=> ($auth->acl_get('a_') || $auth->acl_get('m_points')) ? append_sid("{$phpbb_root_path}donate.$phpEx", "user_id=".$poster_id."&adm_points=1&post_id=".$row['post_id'])  : '',
				
Open: adm/style/acp_users_profile.html
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
	<dl>
		<dt><label for="interests">{L_INTERESTS}:</label></dt>
		<dd><textarea id="interests" name="interests" rows="3" cols="30">{INTERESTS}</textarea></dd>
	</dl>
			
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code: Select All
	<dl>
		<dt><label for="points">{L_POINTS}:</label></dt>
		<dd><input id="points" type="text" name="points" value="{POINTS}" /></dd>
	</dl>
			
Open: includes/acp/acp_board.php
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
'max_post_img_height'	=> array('lang' => 'MAX_POST_IMG_HEIGHT',	'validate' => 'int',	'type' => 'text:5:4', 'explain' => true, 'append' => ' ' . $user->lang['PIXEL']),
			
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code: Select All
'legend3'				=> 'GENERAL_POINTS',
						'points_enable'			=> array('lang' => 'ENABLE_POINTS',		'validate' => 'bool',	'type' => 'radio:yes_no', 'explain' => false),
						'points_topic'			=> array('lang' => 'POINTS_PER_TOPIC',	'validate' => 'int',	'type' => 'text:5:4', 'explain' => false),
						'points_post'			=> array('lang' => 'POINTS_PER_POST',	'validate' => 'int',	'type' => 'text:5:4', 'explain' => false),
						'points_name'			=> array('lang' => 'POINTS_NAME',		'validate' => 'string',	'type' => 'text:25:100', 'explain' => false),
				
Open: includes/acp/acp_users.php
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
				'interests'		=> utf8_normalize_nfc(request_var('interests', $user_row['user_interests'], true)),
				
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code: Select All
				'points'		=> request_var('points', $user_row['user_points']),
				
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
				'interests'		=> array('string', true, 2, 500),
				
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code: Select All
				'points'		=> array('num', true, 1),
				
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
				$sql_ary = array(
					'user_icq'		=> $data['icq'],
					'user_aim'		=> $data['aim'],
					'user_msnm'		=> $data['msn'],
					'user_yim'		=> $data['yim'],
					'user_jabber'	=> $data['jabber'],
					'user_website'	=> $data['website'],
					'user_from'		=> $data['location'],
					'user_occ'		=> $data['occupation'],
					'user_interests'=> $data['interests'],
				
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code: Select All
				'user_points'	=> $data['points'],
				
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
				'OCCUPATION'	=> $data['occupation'],
				'INTERESTS'		=> $data['interests'],
				
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code: Select All
				'POINTS'		=> $data['points'],
				'L_POINTS'		=> $config['points_name'],
				
Open: includes/acp/acp_permissions.php
Find
Tip: This may be a partial find and not the whole line.

Code: Select All
				$user->add_lang('acp/permissions');
				
Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code: Select All
				$user->add_lang('mods/points');
				

--------------------------------------------------------------------------------

Save all files. End of MOD.
You have finished the installation for this MOD. Upload all changed files to your website. If the installation went bad, simply restore your backed up files.
 
MOD UA XSLT File Copyright © 2007 The phpBB Group, this MOD is copyright to the authors listed above.

Alvast bedankt!

BetaDevil · Bericht door **BetaDevil** » 01 mar 2008, 12:23

Er word geprobeerd de rij points_enable aan te maken terwijl die al bestaat, waar kreeg je precies die foutmelding?

larsisgoed9 · Bericht door **larsisgoed9** » 01 mar 2008, 12:26

Toen ik in het admin paneel, de post instellingen had aangepast, en op OK klikte...

BetaDevil · Bericht door **BetaDevil** » 01 mar 2008, 12:43

Wat gebeurt er als je deze query uitvoert en het nog eens probeert?

Code: Selecteer alles

DELETE FROM phpbb3_config WHERE config_name = 'points_enable';
INSERT INTO phpbb3_config (config_name, config_value) VALUES ('points_enable', '0');

larsisgoed9 · Bericht door **larsisgoed9** » 02 mar 2008, 20:13

Ja, gedaan, hij werkt bijna, maar waar kan ik de punten bekijken, van de leden? want bijmezelf zie ik in het profiel, en in het geposte bericht, geen punten staan: Points: , waar zijn die dan te zien?

Ik heb, gezet bij mezelf, dat ik ze kan ontvangen, en bij admin staan ze aan

???

-Larsisgoed9

BetaDevil · Bericht door **BetaDevil** » 02 mar 2008, 20:19

Heb je de buffer geleegd?

larsisgoed9 · Bericht door **larsisgoed9** » 02 mar 2008, 21:00

Nee, had ik nog niet gedaan.

Werkt niet...

Error, bij installeren mod.

Error, bij installeren mod.

Re: Error, bij installeren mod.

Re: Error, bij installeren mod.

Re: Error, bij installeren mod.

Re: Error, bij installeren mod.

Re: Error, bij installeren mod.

Re: Error, bij installeren mod.