phpBB.de

##############################################################
## MOD Title: Hangman Mod
## MOD Author: unTouched < p.s16@web.de > Pete® http://pete.dsl-inet.com/
## MOD Description: Hangman Mod, Adds a word-quessing game to your phpBB
## board
## MOD Version: 1.5.0
##
## MOD phpBB Version needed:
## phpbb2 plus 1.52 or phpbb at least 2.0.11
## may work on older versions
##
## Installation Level: Very Easy
## Installation Time: 10 Minutes (EMC 1 Minute)
## Files To Edit: overall_header.tpl,page_header.php
## Included Files: hangman.php
## db_update.php (only for installing DB Tables)
## /template/hangman/hangman_create.tpl
## /template/hangman/hangman_overview.tpl
## /template/hangman/hangman_new.tpl
## /template/hangman/hangman_help.tpl
## /template/hangman/hangman_admin.tpl
## /template/hangman/hangman_highscore.tpl
## /template/hangman/hangman_window.tpl
## /language/lang_english/lang_hangman.php
## /language/lang_german/lang_hangman.php
## /template/hangman/admin/admin_hangman.tpl
## /template/hangman/admin/admin_hangman_import.tpl
## /admin/admin_hangman.php
## /admin/admin_hangman_import.php
## /images/hangman_pics/trans_lost_0.gif
## /images/hangman_pics/trans_lost_1.gif
## /images/hangman_pics/trans_lost_2.gif
## /images/hangman_pics/trans_lost_3.gif
## /images/hangman_pics/trans_lost_4.gif
## /images/hangman_pics/trans_lost_5.gif
## /images/hangman_pics/trans_lost_6.gif
## /images/hangman_pics/trans_lost_7.gif
## /images/hangman_pics/trans_lost_8.gif
## /images/hangman_pics/trans_lost_9.gif
## /images/hangman_pics/won.gif
## /images/hangman_pics/time.gif
## /images/hangman_pics/trans_hangman_link.gif
##############################################################
#############################################################
## Author Notes: Have a lot of fun, questions and ideas
## relating this mod could be posted in the
## support forum.
##
## if you are using phpBB - Plus Code -> use following line,
## to get a link in the header
## •&nbsp;&nbsp;<a href="{U_HANGMAN}" class="mainmenu">{L_HANGMAN}</a>
##
##
## Addons: -bbcode (more info in install_bbcode.txt
##
##############################################################
## MOD History:
##
## 18-04-2004 - Version 0.1.0
## - first test release (on local pc)
## - mod includes 6 tpls,1 php and 1 sql files (3 tables)
## - mod gives> hangman creating> hangman highscore> hangman playing> hangman overview
## - known bugs: people are able to add letters which aren't able to quess
## 0 isn't quessable
## - missing features: *administration*pictures*layout*readme.txt*language_support
## 18-04-2004 - Version 0.2.0
## - one tpl deleted (wasn't usefull)
## - bug: bug that created and lost aren't updated to score is
## - some layout >> fisubsilver is used (phpBB plus!)
## - included a lang file (lang_hangman.php) >> userfull for english support
## - known bugs: NULL ;)
## - missing features:*administration*pictures*readme.txt*lang_english
## 19-04-2004 - Version 0.2.1
## - bug that there are wrong winners in the overview (added won_by to HANGMAN_WORDS-table)
## - first release in my official forum (only for students ;)
## 19-04-2004 - Version 0.2.4
## - added navigation in the overall_header.tpl
## - bug @ showing multiple line helps ( '\n' >>> <br />)
## - changed some layout
## 19-04-2004 - Version 0.3.0
## - added administration -> 6 tpls (just deleting and hangman is avaible)
## - changed some layout
## - missing features:*pictures*readme.txt*lang_english
## 19-04-2004 - Version 0.3.1
## - some db renaming... (for better english style and releasing official
## - added navigation @ creating -> error
## 20-04-2004 - Version 0.4.0
## - added help -> 7 tpls
## - some layout
## - some lang...
## - missing features:*pictures*readme.txt*lang_english
## 20-04-2004 - Version 0.4.5
## - added 11 pictures
## - added check_word function
## - added some signs (!.?-_)
## - missing features:*readme.txt*lang_english
## 20-04-2004 - Version 0.4.6
## - some layout
## - added English lang but help is remaining in german
## 20-04-2004 Version 0.5.0 Beta
## - beta release, learn what public says ;)
## - added readme.txt with introductions
## - first release ;)
## 01-05-2004 Version 0.7.0 Beta
## - added some history and corrected the install.txt ;)
## - changed some code > ',' correct display and replaced some german (still remaining some words )
## - fixed, that if a hangman has a lease date, that when it is quessed that there isn't a remaining time in overview
## - added the picture for subSilver - Theme - Link ;)
## - creator is shown @ quess page
## - fixed offset bug
## 02-05-2004 Version 0.7.1 Beta
## - fixed bug that users already lost where counted if watching game status
## 04-06-2004 Version 0.9.0 still Beta
## - added filter to overview page
## - added administration
## - added points_mod support
## - added ACP
## - fixed bug that users lost only see there first tried letter (not all letters quessed)
## - one config table and table hangman_quess was altered
## - supported themes >bluetabs >subSilver >fisubsilversh >fiblue3d
## 10-06-2004 Version 0.9.1
## 10-06-2004 Version 0.9.2 still Beta
## - changed Wordcheck
## - added points mod -> erased cash mod (both are the same in adding points
## - added option to use other chars (edit lang_hangman.php)
## - config will load a standart config so updating TABLES in new versions is not necessary
## - fixed layout in subSilver, fisubsilversh, bluetabs, fiblue3d
## 24-06-2004 Version 1.0.0 First [non-BETA] Release
## - much code change for better understanding / working
## - added admin option to delete multiple hangmans in overview
## - added one field to HANGMAN_SCORE -> gives better highscore system ;)
## - added much more data to overview
## - changed code for word quessing -> now will work "perfect" on words (excluding words containing zeros -> never allow!)
## - changed template subSilver an fisubsilversh -> i mean looks better ^^
## - created a db_install.php -> !!!!USE AT OWN RISK!!!!
## - changed config handling -> now easier to update/add new fields
## - fixed bug on quessing page when author of hangman looks at, including changed layout of quessing page...
## - added much more security on checking the post/get vars offset,game_index and filter
## 25-06-2004 Version 1.0.1
## - fixed highscore bug
## 27-06-2004 Version 1.0.2
## - fixed zero bug
## - added [bold] for user who is looking at overview
## 08-07-2004 Version 1.0.3
## - + allowed
## - help for points/highscore system
## - fixed filter bug
## - fixed lang bugs
## - added some administration (highscore_system)
## 10-07-2004 Version 1.1.0
## - more admin features (allowed letters, auto_replace_letters)
## - fixed overview bugs (i hope these were all now!)
## - fixed highscore layout
## - added XML - Export and Import functions for admin
## 24-09-2004 Version 1.2.0
## - much much more ACP features
## - some more options fox XML feature
## - little stat in overview (ACP to click on/off)
## - filter and offset will be kept when quessing and returning overview page
## - Hangman Moderator Group can be created
## - some structure changes -> tpls will be find in /template/hangman/*.tpl
## -> there comes a includes/functions_hangman.php
## - time_play_again is now in minutes
## - per ACP allowed to configure that a user can't wait on quessing a hangman
## by pressing "F5" - he will lose one try every time he hits ;p
## 21-10-2004 Version 1.3.0
## - ACP feature -> give a standart subject to hangman
## - ACP feature -> show or not show hangman IDs in Overview
## - ACP feature -> allow guests to visit Hangman (Overview, Highscore and Help)
## - ACP feature -> min help length
## - fixed bbcode Version up to 0.0.2 (bugfixing see more in install_bbcode.txt)
## - ACP feature -> max per day value
## - XML feature - filename contains number of hangmans inside ( %number%_hangman_%timestamp%.xml)
## - Fixed subSilver style
## - Fixed if no help given - it won't be shown @ quess page
## - Fixed bugs with pafiledb and other mods including functions_% filenames in include folder (again much more install instructions...)
## - ... FINAL Version before 2.0.0! or Hangman @ phpbb2.2.x
## - mode=window added (with given game_index) ex. hangman.php?mode=window&game_index=1
## 05-12-2004 Version 1.3.1
## - fixed Layout in overview, create
## - fixed moderator group bug in admin_hangman.php
## 01-01-2005 Version 1.4.0
## - added feature give points per quessed letter
## - highscore now counts letters wrong or right quessed per user
## 22-01-2005 Version 1.5.0 EMC*
## - Maximum Word Length (DB Update Needed!)
## - fixed ACP bug (minletters unchangeable)
## - Easy Mod Compatible! (just tested on a clean phpBB2.0.11)
## - Header and Viewonline now in install.txt (EM* will process them)
## - Fixed Bug in ACP -> importing with username will updatescore @ count of hangmans
## - Added option to submit whole words by quessing
## - Fixed Bug - best Player == user with most points not with most quessed
## - Fixed Bug that letters are displayed which are "autoreplaced"
## - ANONYMOUS can visit quessed hangmans (if ANONYMOUS allowed on overview)
## 06-02-2005 Version 1.5.1 EMC
## - Fixed BBCode Bug in functions_hangman.php - just upload new functions_hangman.php
## 08-02-2005 Version 1.5.2 EMC
## - German Language - Update
## - Fixed "Zero" Bug again
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################
#
#-----[ SQL ] -----
#
CREATE TABLE phpbb_hangman_configs ( config_name varchar(20) NOT NULL default '', config_value varchar(255) NOT NULL default '' ) TYPE=MyISAM;
CREATE TABLE phpbb_hangman_quess ( userid mediumint(8) NOT NULL default '0', hangmanid mediumint(8) NOT NULL default '0', tries tinyint(2) default NULL, losttime int(11) default NULL, quesscount int(4) NOT NULL default '1' ) TYPE=MyISAM;
CREATE TABLE phpbb_hangman_score ( userid mediumint(8) NOT NULL default '0', created mediumint(8) NOT NULL default '0', won mediumint(8) NOT NULL default '0', lost mediumint(8) NOT NULL default '0', points mediumint(8) NOT NULL default '0', r_letters mediumint(8) NOT NULL default '0', w_letters mediumint(8) NOT NULL default '0' ) TYPE=MyISAM;
CREATE TABLE phpbb_hangman_words ( hangmanid mediumint(8) NOT NULL auto_increment, userid mediumint(8) NOT NULL default '0', hangman_word text, hangman_help text, hangman_subject varchar(70) NOT NULL default '', max_tries tinyint(2) default NULL, time_created int(11) NOT NULL default '0', time_limit int(11) NOT NULL default '0', bwon tinyint(1) NOT NULL default '0', quessed_letters varchar(35) default NULL, bbcodeid varchar(10) NOT NULL default '', winner mediumint(8) default '0', PRIMARY KEY (hangmanid) ) TYPE=MyISAM;
#
#-----[ COPY ]------------------------------------------
#
copy templates/subSilver/hangman/*.tpl to templates/subSilver/hangman/
copy templates/subSilver/hangman/admin/*.tpl to templates/subSilver/hangman/admin/
copy hangman.php to /
copy /language/lang_english/lang_hangman.php to /language/lang_english/
copy /language/lang_german/lang_hangman.php to /language/lang_german/
copy /images/hangman_pics/*.* to /images/hangman_pics/
copy /admin/admin_hangman.php to /admin/
copy /admin/admin_hangman_import.php to /admin/
copy /includes/functions_hangman.php to /includes/
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/overall_header.tpl
#
#-----[ FIND ]------------------------------------------
#
<td height="25" align="center" valign="top" nowrap="nowrap"><span class="mainmenu">&nbsp;<a href="{U_PROFILE}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_profile.gif" width="12" height="13" border="0" alt="{L_PROFILE}" hspace="3" />{L_PROFILE}</a>&nbsp; &nbsp;<a href="{U_PRIVATEMSGS}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_message.gif" width="12" height="13" border="0" alt="{PRIVATE_MESSAGE_INFO}" hspace="3" />{PRIVATE_MESSAGE_INFO}</a>&nbsp; &nbsp;<a href="{U_LOGIN_LOGOUT}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_login.gif" width="12" height="13" border="0" alt="{L_LOGIN_LOGOUT}" hspace="3" />{L_LOGIN_LOGOUT}</a>&nbsp;</span></td>
#
#-----[ IN-LINE FIND ]------------------------------------------
#
<a href="{U_LOGIN_LOGOUT}" class="mainmenu">
#
#-----[ IN-LINE BEFORE, ADD ]------------------------------------------
#
<a href="{U_HANGMAN}" class="mainmenu"><img src="images/hangman_pics/hangman_link_trans.gif" width="12" height="13" border="0" alt="{L_HANGMAN}" hspace="3">{L_HANGMAN}</a>&nbsp;&nbsp;
#
#-----[ OPEN ]------------------------------------------
#
includes/page_header.php
#
#-----[ FIND ] ------
#
$template->assign_vars(array(
'SITENAME' => $board_config['sitename'],
#
#-----[ BEFORE, ADD] -----
#
$hang_stats_count = NULL;
$hang_stats_left = NULL;
if (!defined('IN_HANGMAN'))
{
define('IN_HANGMAN',true);
include($phpbb_root_path.'includes/functions_hangman.php');
}
$hang_stats = get_hangman_stats();
$hang_stats_count = intval($hang_stats['count']);
$hang_stats_left = $hang_stats_count - intval($hang_stats['won']);
#
#-----[ FIND ]------------------------------------------
#
'U_INDEX' => append_sid('index.'.$phpEx),
#
#-----[ AFTER, ADD ]------------------------------------------
#
'U_HANGMAN' => append_sid('hangman.'.$phpEx),
'L_HANGMAN'=>'Hangman('.$hang_stats_left.'/'.$hang_stats_count.')',
#
#-----[ OPEN ]------------------------------------------
#
includes/constants.php
#
#-----[ FIND ]------------------------------------------
# at the end of file
?>
#
#-----[ BEFORE, ADD ]------------------------------------------
#
/* Begin Mod HANGMAN*/
define('PAGE_HANGMAN',-212);
//define tables
define('HANGMAN_WORDS', $table_prefix.'hangman_words');
define('HANGMAN_QUESS', $table_prefix.'hangman_quess');
define('HANGMAN_SCORE', $table_prefix.'hangman_score');
define('HANGMAN_CONFIGS', $table_prefix.'hangman_configs');
define('EXPORT_LETTER_SET','ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyz.!? ');
/* End Mod Hangman*/
#
#-----[ OPEN ] ------
#
viewonline.php
#
#-----[ FIND ] ------
#
case PAGE_FAQ:
$location = $lang['Viewing_FAQ'];
$location_url = "faq.$phpEx";
break;
#
#-----[AFTER, ADD] -----
#
case PAGE_HANGMAN:
$location = 'Hangman';
$location_url = "hangman.$phpEx";
break;
#
#-----[ OPEN ] ------
#
admin/index.php
#
#-----[ FIND ] ------
#
case PAGE_FAQ:
$location = $lang['Viewing_FAQ'];
$location_url = "index.$phpEx?pane=right";
break;
#
#-----[ AFTER, ADD] -----
#
case PAGE_HANGMAN:
$location = 'Hangman';
$location_url = "hangman.$phpEx";
break;
#
#-----[ FIND ] ------
#
case PAGE_FAQ:
$location = $lang['Viewing_FAQ'];
$location_url = "index.$phpEx?pane=right";
break;
#
#-----[ AFTER, ADD] -----
#
case PAGE_HANGMAN:
$location = 'Hangman';
$location_url = "hangman.$phpEx";
break;
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
#-----[ !!!CONFIGURE YOUR ACP!!! ]--------------------------------------
# EofM

modbo hat geschrieben:Das wird doch alles automatisch angelegt, wenn du die komplette SQL Anweisung in die SQL Eingabe kopiert.
Einfach in deiner Datenbank auf SQL klicken, den kompletten Code einfügen und absenden.

Das wird doch alles automatisch angelegt, wenn du die komplette SQL Anweisung in die SQL Eingabe kopiert.
Einfach in deiner Datenbank auf SQL klicken, den kompletten Code einfügen und absenden.