phpBB.de

Code: Alles auswählen

Could not insert new word matches

DEBUG MODE

SQL Error : 1054 Unknown column 'test' in 'field list'

INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) SELECT test, word_id, 0 FROM phpbb_search_wordlist WHERE word_text IN ('test')

Line : 242
File : /home/www/wev155/html/Forum/includes/functions_search.php

Code: Alles auswählen

################################################################# 
## Mod Title: phpBB-book (Livre d'Or) 
## Mod Version: 1.2 
## Rev Date: November 24, 2002 
## 
## by: DREAMY <david.cuignet@orange.fr -support guestbook http://www.agb-phpbb.fr.st/> 
## 
## Description: This MOD makes it possible to add a guestbook to your phpBB forum 
## 
## Installation Level: Easy 
## Installation Time: 3 Minutes 
## Files To Edit: 1 
## Included Files: 11 
## 
## 
################################################################# 
## Security Disclaimer: This MOD Cannot Be Posted To Or Added At Any Non-Official phpBB Sites 
################################################################# 
## 
#-----[ UPLOAD]------------------------------------------ 
# 

Copy all files to their respective Location (the directory structure is in the folder root) 

-> posting2.php 
-> admin.php 
-> guestbook.php 
-> db_guestbook.php 

-> images/ 
-> includes/ 
-> langages/ 
Attention au template qui est ici "suBsilver" ! 

-> templates/suBsilver/ 


# 
#-----[ SQL tables]------------------------------------------ 
# 

root/forum/db_guestbook.php 

the update of the tables will be done automatically 


# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/page_header.php 

# 
#-----[ FIND ]------------------------------------------ 
# 
'L_WHOSONLINE_MOD' => sprintf($lang['Mod_online_color'], '<span style="color:#' . $theme['fontcolor2'] . '">', '</span>'), 

# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
'L_GUESTBOOK' => $lang['Guestbook'], 

# 
#-----[ OPEN ]------------------------------------------ 
# 
language/lang_french/lang_main.php 

# 
#-----[ FIND ]------------------------------------------ 
# 
// 
// That's all Folks! 
// 
# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
//Add on for Guestbook 
$lang['Gender'] = 'Sex'; 
$lang['Male'] = 'Male'; 
$lang['Female']='Female'; 
$lang['Guestbook']='Guestbook'; 
$lang['Return']='return Guestbook'; 
$lang['Name']='Name'; 
$lang['Comment']='Comments'; 
$lang['From']='From'; 
$lang['Sign']='Sign guestbook'; 


# 
#-----[ OPEN ADMIN FORUM ]------------------------------------------ 
# 
1 - Create a new category "Guestbook" in the administration of your forum 
2 - Create a new forum "Guestbook" in the Guestbook category 

# 
#-----[ RETURN INDEX FORUM ]------------------------------------------ 
# 
1 - Go in the forum "Guestbook" in the category "Guestbook" 
2 - Copy the link "create a new message" 

This URL must be like this 
http://www.votre-site/votre-forum/posting.php?mode=newtopic&f=1&sid=xxxxxxxxxxxxxxxxxxxx 

Stick your URL in your navigator and change in this URL posting.php by admin.php 

This URL must be like this 
http://www.votre-site/votre-forum/admin.php?mode=newtopic&f=1&sid=xxxxxxxxxxxxxxxxxxxxxxx 

3 - You can now validate the address and establish your first message as 
an administrator. If you want to be informed with each new signature 
do not forget to notch the option 
" To inform me when an answer is posted " 

4 - Now look at your new message and locate the number of this one by 
looking at the URL in top of your navigator. 

That must give for example http://www.votre-site/votre-forum/viewtopic.php?t=1 ->ici le chiffre à retenir c'est -1- 

# 
#-----[ OPEN ]------------------------------------------ 
# 
templates/subSilver/overall_header.tpl 

# 
#-----[ FIND ]------------------------------------------ 
# 

<td height="25" align="center" valign="top" nowrap><span class="mainmenu"><a href="viewtopic.php?p=4" 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> 


# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 

<a href="guestbook.php?t=x" class="mainmenu"><img src="templates/subSilver/images/icon_mini_guestbook.gif" width="12" height="13" border="0" alt="{L_GUESTBOOK}" hspace="3" />{L_GUESTBOOK}</a> 

- and in this line replace X by the number which you retained. (Either the 1 in the example) 

that will give 

<a href="guestbook.php?t=1" class="mainmenu"><img src="templates/subSilver/images/icon_mini_guestbook.gif" width="12" height="13" border="0" alt="{L_GUESTBOOK}" hspace="3" />{L_GUESTBOOK}</a> 

# 
#-----[ OPEN TABLE phpbb_categories with PHPmyadmin ]------------------------------------------ 
# 
# 

erase the category "Guestbook" 


# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 

#-----[ SECURITY ]------------------------------------------ 
# 
Before using your Guestbook please remove the following files on your ftp 

admin.php, posting_body3.tpl et db_guestbook.php 

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

Your guestbook is ready!! You can reach it while clicking on the bond delivers of gold in top of your forum.