Error, bij installeren mod.
Geplaatst: 01 mar 2008, 09:28
door larsisgoed9
- 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.