Group Rank Hack Install problem!

Nightrider · Post by **Nightrider** » Mon Dec 25, 2006 5:40 am

Ok, I created an EM Friendlier version of the MOD. But this MOD author uses A LOT of REPLACE WITH commands. I figured I would leave them alone and see how many of the FIND statements need to be adjusted. We may get lucky to find that none of the FIND statements need adjustments where the following is a REPLACE WITH command...

So try this and see what happens. Since this is completely untested, you are the guinea pig here. This may require additional adjustments...

Code: Select all

############################################################## 
## MOD Title: phpBB_CMS - EM Friendly
## MOD Version: 1.0.0 
## MOD Author: sold_out < [email protected] > (Ingmar Kohl) http://www.kohl-net.de 
## MOD Description:  
##
##	This is a phpBB-based content management system. Maybe this is a good system for you until the phpBB Portal 
##	is released, although this is primarily a CMS and not a portal!
##	You can set up a website in minutes via the comfortable phpBB GUI, just like making forum posts.
##	Besides using the great BB_Code to format your pages, you can use HTML, PHP and external pages as you wish.
##	Although some would argue that this is no longer a hack, this system is still so deeply rooted in phpBB that 
##      I do not consider it anything else than a MOD / Add-on to the greatest forum on the web! 
##
##	Features:
##		- Integrated with phpBB2 (DB, sessions, templates, users, etc.)
##		- Easy-to-use Admin CP
##		- Dynamic Nuke-like block system, with 8 blocks that are installed & positioned via Admin CP
##		- Includes a dynamic sitemap
##		- You can make the first page of a category a news page (like with portals)
##		- Can be added to any existing phpBB 2.0.4
##		- The site is completely dynamic, showing users only, what they are allowed to see
##		- This system supporst several users adding content 
##		- Managing the content pages is exactly like managing a forum
##		- Works with lot's of other phpBB MODs and all templates
##
##	Requirements:
##		A running phpBB 2.0.4 (I recommend you use only the latest version if phpBB - may or may not work with 
##		lower versions).
##		Read these instructions completely and carefully.
##
##	Tested with:	
##		phpBB 2.0.4 - PHP4 - MySQL 3.23.x
##
##	Notes:  
##		If you want to create a new phpBB anyway, you might want to save yourself the trouble and download phpBB_CMS  
##		in the pre-modded version at my website (see above).
##
##	IMPORTANT: 
##		I MUST ask you to read the instructions very thouroughly. During the time of development, I have had 
##		many people test it. Many of them made small mistakes like overreading simple, yet important changes. This is 
##		why I have labeled this MOD as advanced.
##
## 
## Installation Level: (advanced) 
## Installation Time: 30 Minutes 
## Files To Edit: (17)
##	cms.php 
##      forum.php
##      posting.php 
##      search.php
##	admin/admin_db_utilities.php
##      admin/admin_forums.php
##      includes/constants.php 
##      includes/functions.php
##      includes/functions_post.php 
##      includes/page_header.php 
##      includes/page_tail.php
##      language/lang_english/lang_main.php 
##      language/lang_english/lang_admin.php
##      templates/subSilver/overall_footer.tpl 
##      templates/subSilver/overall_header.tpl 
##      templates/subSilver/posting_body.tpl
##      templates/subSilver/admin/forum_admin_body.tpl
##                     
## Included Files: (35)
##	archive.php	
##	install_help.txt
##	index.php			
##	install_cms.php		
##	site_search.php		
##	admin/admin_cms.php			
##	admin/admin_cms_blocks.php		
##	cms_blocks/block_affiliates.php		
##	cms_blocks/block_counter.php		
##	cms_blocks/block_last_content.php	
## 	cms_blocks/block_last_posts.php		
## 	cms_blocks/block_last_topics.php	
##	cms_blocks/block_laston.php		
## 	cms_blocks/block_site_search.php	
## 	cms_blocks/block_user_cp.php		
## 	includes/left_menu.php			
## 	includes/center.php			
## 	includes/sitemap.php			
##	templates/subSilver/archive_body.tpl		
## 	templates/subSilver/block_affiliates.tpl	
## 	templates/subSilver/block_counter.tpl		
## 	templates/subSilver/block_last_content.tpl		
## 	templates/subSilver/block_laston_body.tpl	
## 	templates/subSilver/block_login.tpl			
## 	templates/subSilver/block_most_recent_posts.tpl	
## 	templates/subSilver/block_site_search.tpl		
## 	templates/subSilver/block_user_cp.tpl		
## 	templates/subSilver/center.tpl			
## 	templates/subSilver/left_menu.tpl			
## 	templates/subSilver/site_search_results_posts.tpl
## 	templates/subSilver/sitemap.tpl			
## 	templates/subSilver/admin/cms_management.tpl		
## 	templates/subSilver/admin/cms_block_management.tpl	
## 	templates/subSilver/images/icon_mini_hi.gif		
##	templates/subSilver/images/logo_phpBB.jpg			
##
############################################################## 
##
## For Security Purposes, Please Check: http://www.phpbb.com/mods/downloads/ 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 MOD's not offered 
## in our MOD-Database, located at: http://www.phpbb.com/mods/downloads/ 
##
############################################################## 
##
## Author Notes: 
##
##	1. Please also read the file install_help.txt
##
##	2. If you're using the CSS, you have to make the first change to templates/subSilver/overall_header.tpl 
##	   as specified below not to that .tpl file, but to templates/subSilver/subSilver.css
##
##	3. For a tutorial on how to run the CMS or on how to create your own blocks, please visit http://www.kohl-net.de
##
##	4. If you want to see what you can do with this, look at my site - I'm using it there and am VERY happy
##	   with the functionality! I will also list more sites that use the MOD, after I know of them :)
##
##	5. Thanks to the phpBB group for creating their great program !!!
##
############################################################## 
##
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
##
############################################################## 
##
## NEW ACTION: RENAME
##
## Code:    file1 -> file2
## Meaning: rename file1 to file2 [the files refered to are on the webserver]
##
##
## NEW ACTION: RUN
##
## Code:    file
## Meaning: access the file on your webserver via your webbrowser, e.g. http://www.yourdomain.com/file
##
##
## NEW ACTION: CREATE DIR
##
## Code:    dir
## Meaning: create the directory dir on your webserver
##
##############################################################

#
#-----[ DIY INSTRUCTIONS ]-------------------------------------------------------
#
  It is very important that you do this BEFORE installing this MOD...
  
  1) Create a good backup of the index.php file

  2) rename index.php to forum.php

  3) create another copy of the fourm.php file and name it cms.php

  4) Upload the install_cms.php file to your phpBB forum folder and run
  	 it from your browser.  The path to the install_cms.php DB Update 
	 file could look something like this:
	 
	 http://yourdomain.com/phpBB2/install_cms.php

  5) Delete the install_cms.php file from your phpBB forum folder...

#
#-----[ COPY ]-------------------------------------------------------
# 
copy archive.php to archive.php
copy index.php to index.php			
copy install_cms.php to install_cms.php		
copy site_search.php to site_search.php	

copy admin/admin_cms.php to admin/admin_cms.php
copy admin/admin_cms_blocks.php to admin/admin_cms_blocks.php	

copy cms_blocks/block_affiliates.php to cms_blocks/block_affiliates.php	
copy cms_blocks/block_counter.php to cms_blocks/block_counter.php	
copy cms_blocks/block_last_content.php to cms_blocks/block_last_content.php	
copy cms_blocks/block_last_posts.php to cms_blocks/block_last_posts.php		
copy cms_blocks/block_last_topics.php to cms_blocks/block_last_topics.php	
copy cms_blocks/block_laston.php to cms_blocks/block_laston.php		
copy cms_blocks/block_site_search.php to cms_blocks/block_site_search.php	
copy cms_blocks/block_user_cp.php to cms_blocks/block_user_cp.php	

copy includes/left_menu.php to includes/left_menu.php			
copy includes/center.php to includes/center.php			
copy includes/sitemap.php to includes/sitemap.php			

copy templates/subSilver/archive_body.tpl to templates/subSilver/archive_body.tpl		
copy templates/subSilver/block_affiliates.tpl to templates/subSilver/block_affiliates.tpl	
copy templates/subSilver/block_counter.tpl to templates/subSilver/block_counter.tpl		
copy templates/subSilver/block_last_content.tpl to templates/subSilver/block_last_content.tpl		
copy templates/subSilver/block_laston_body.tpl to templates/subSilver/block_laston_body.tpl	
copy templates/subSilver/block_login.tpl to templates/subSilver/block_login.tpl			
copy templates/subSilver/block_most_recent_posts.tpl to templates/subSilver/block_most_recent_posts.tpl	
copy templates/subSilver/block_site_search.tpl to templates/subSilver/block_site_search.tpl		
copy templates/subSilver/block_user_cp.tpl to templates/subSilver/block_user_cp.tpl		
copy templates/subSilver/center.tpl to templates/subSilver/center.tpl			
copy templates/subSilver/left_menu.tpl to templates/subSilver/left_menu.tpl			
copy templates/subSilver/site_search_results_posts.tpl to templates/subSilver/site_search_results_posts.tpl
copy templates/subSilver/sitemap.tpl to templates/subSilver/sitemap.tpl			

copy templates/subSilver/admin/cms_management.tpl to templates/subSilver/admin/cms_management.tpl		
copy templates/subSilver/admin/cms_block_management.tpl to templates/subSilver/admin/cms_block_management.tpl	

copy templates/subSilver/images/icon_mini_hi.gif to templates/subSilver/images/icon_mini_hi.gif		
copy templates/subSilver/images/logo_phpBB.jpg to templates/subSilver/images/logo_phpBB.jpg			

# 
#-----[ OPEN ]------------------------------------------ 
# 
cms.php
# 
#-----[ FIND ]------------------------------------------ 
# 
FROM " . CATEGORIES_TABLE . " c  
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
	WHERE c.cat_type>0 
# 
#-----[ OPEN ]------------------------------------------ 
# 
forum.php
# 
#-----[ FIND ]------------------------------------------ 
# 
FROM " . CATEGORIES_TABLE . " c  
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
	WHERE c.cat_type=0 

# 
#-----[ OPEN ]------------------------------------------ 
# 
posting.php

# 
#-----[ FIND ]------------------------------------------ 
# 
// End session management
//

# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
// BEGIN CMS MOD

$ppt = 0;
if (($portal_post_type)&&($userdata['user_level']==ADMIN))
{
	if	($portal_post_type == "internal_link") { $ppt = 1; }
	elseif	($portal_post_type == "external_link") { $ppt = 2; }
	elseif	($portal_post_type == "php_file")      { $ppt = 3; }
}

// END CMS MOD

# 
#-----[ FIND ]------------------------------------------ 
# The actual line is much longer...
submit_post(
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
// BEGIN CMS MOD

$sql = "UPDATE " . POSTS_TABLE . " SET portal_post_type = $ppt WHERE post_id = $post_id";
if( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Could not write portal post type', '', __LINE__, __FILE__, $sql);
}

// END CMS MOD

# 
#-----[ FIND ]------------------------------------------ 
# 
//
// Output the data to the template

# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
// BEGIN CMS MOD

$write_ppt = "";
if ($userdata['user_level'] == ADMIN){
	
	$write_ppt = "<tr><td><select name=\"portal_post_type\"><option selected>forum</option><option>internal_link</option><option>external_link</option><option>php_file</option></select></td></tr>";
}

// END CMS MOD

# 
#-----[ FIND ]------------------------------------------ 
# 	
'L_STYLES_TIP' =>
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
'P_PPT' => $write_ppt, 
# 
#-----[ OPEN ]------------------------------------------ 
# 
search.php 
# 
#-----[ FIND ]------------------------------------------ 
# 
$sql = "SELECT post_id 
	FROM " . POSTS_TABLE . " 
	WHERE post_time >= " . $userdata['user_lastvisit'];

# 
#-----[ REPLACE WITH ]------------------------------------------ 
# 
$sql = "SELECT p.post_id 
	FROM " . POSTS_TABLE . " p, " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c 
	WHERE p.post_time >= " . $userdata['user_lastvisit'] . " AND p.forum_id=f.forum_id AND f.cat_id=c.cat_id AND c.cat_type=0";


# 
#-----[ FIND ]------------------------------------------ 
# 		
$sql = "SELECT post_id 
	FROM " . POSTS_TABLE . " 
	WHERE poster_id = " . $userdata['user_id'];

# 
#-----[ REPLACE WITH ]------------------------------------------ 
# 
$sql = "SELECT p.post_id 
	FROM " . POSTS_TABLE . " p, " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c 
	WHERE p.poster_id = " . $userdata['user_id'] . " AND p.forum_id=f.forum_id AND f.cat_id=c.cat_id AND c.cat_type=0";


# 
#-----[ FIND ]------------------------------------------ 
# 	
$sql = "SELECT post_id 
	FROM " . POSTS_TABLE . " 
	WHERE poster_id IN ($matching_userids)";

# 
#-----[ REPLACE WITH ]------------------------------------------ 
# 
$sql = "SELECT p.post_id 
	FROM " . POSTS_TABLE . " p, " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c 
	WHERE p.poster_id IN ($matching_userids) AND p.forum_id=f.forum_id AND f.cat_id=c.cat_id AND c.cat_type=0";



# 
#-----[ FIND ]------------------------------------------ 
# 	
$sql = "SELECT m.post_id 
	FROM " . SEARCH_WORD_TABLE . " w, " . SEARCH_MATCH_TABLE . " m 
	WHERE w.word_text LIKE '$match_word' 
	AND m.word_id = w.word_id 
	AND w.word_common <> 1 
	$search_msg_only";

# 
#-----[ REPLACE WITH ]------------------------------------------ 
# 
$sql = "SELECT m.post_id 
	FROM " . SEARCH_WORD_TABLE . " w, " . SEARCH_MATCH_TABLE . " m, " . POSTS_TABLE . " p, " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c  
	WHERE w.word_text LIKE '$match_word' 
	AND m.word_id = w.word_id 
	AND w.word_common <> 1 
	$search_msg_only AND m.post_id=p.post_id AND p.forum_id=f.forum_id AND f.cat_id=c.cat_id AND c.cat_type=0";


# 
#-----[ FIND ]------------------------------------------ 
# 	
$sql = "SELECT post_id
	FROM " . POSTS_TEXT_TABLE . "
	WHERE post_text LIKE '$match_word'
	$search_msg_only";

# 
#-----[ REPLACE WITH ]------------------------------------------ 
# 
$sql = "SELECT pt.post_id
	FROM " . POSTS_TEXT_TABLE . " pt, " . POSTS_TABLE . " p, " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c  
	WHERE pt.post_text LIKE '$match_word' 
	$search_msg_only AND pt.post_id=p.post_id AND p.forum_id=f.forum_id AND f.cat_id=c.cat_id AND c.cat_type=0";

# 
#-----[ FIND ]------------------------------------------ 
# 	
$sql = "SELECT c.cat_title, c.cat_id, f.forum_name, f.forum_id  
	FROM " . CATEGORIES_TABLE . " c, " . FORUMS_TABLE . " f
	WHERE f.cat_id = c.cat_id 
	ORDER BY c.cat_id, f.forum_order";

# 
#-----[ REPLACE WITH ]------------------------------------------ 
# 
$sql = "SELECT c.cat_title, c.cat_id, f.forum_name, f.forum_id  
	FROM " . CATEGORIES_TABLE . " c, " . FORUMS_TABLE . " f
	WHERE f.cat_id = c.cat_id AND c.cat_type = 0 
	ORDER BY c.cat_id, f.forum_order";
# 
#-----[ OPEN ]------------------------------------------ 
# 
admin/admin_forums.php

# 
#-----[ FIND ]------------------------------------------ 
# 
//
// There is no problem having duplicate forum names so we won't check for it.
//

# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
//BEGIN CMS MOD

if ($cat_status=="portal") { $cat_stat = 1; }
else { $cat_stat = 0; }

// END CMS MOD

# 
#-----[ FIND ]------------------------------------------ 
# 			
$sql = "INSERT INTO " . CATEGORIES_TABLE . " (cat_title, cat_order)
				VALUES ('" . str_replace("\'", "''", $HTTP_POST_VARS['categoryname']) . "', $next_order)";

# 
#-----[ REPLACE WITH ]------------------------------------------ 
# 
$sql = "INSERT INTO " . CATEGORIES_TABLE . " (cat_title, cat_type, cat_order) 
	VALUES ('" . str_replace("\'", "''", $HTTP_POST_VARS['categoryname']) . "', $cat_stat, $next_order)";	


# 
#-----[ OPEN ]------------------------------------------ 
# 
admin/admin_db_utilities.php

# 
#-----[ FIND ]------------------------------------------ 
#  			
$tables = array(
# 
#-----[ IN-LINE FIND ]------------------------------------------ 
#  			
'categories'	
# 
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
#
, 'cms', 'cms_blocks'  			
# 
#-----[ IN-LINE FIND ]------------------------------------------ 
#
'config'  			
# 
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
#
, 'counter'
# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/constants.php
# 
#-----[ FIND ]------------------------------------------ 
# 
?>
# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
define('CMS_TABLE', $table_prefix.'cms');
define('CMS_BLOCK_TABLE', $table_prefix.'cms_blocks');
define('COUNTER_TABLE', $table_prefix.'counter');
# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/functions.php
# 
#-----[ FIND ]------------------------------------------ 
# 
$sql = "SELECT c.cat_id, c.cat_title, c.cat_order
	FROM " . CATEGORIES_TABLE . " c, " . FORUMS_TABLE . " f
	WHERE f.cat_id = c.cat_id
	GROUP BY c.cat_id, c.cat_title, c.cat_order
	ORDER BY c.cat_order";

# 
#-----[ REPLACE WITH ]------------------------------------------ 
# 
$sql = "SELECT c.cat_id, c.cat_title, c.cat_order
	FROM " . CATEGORIES_TABLE . " c, " . FORUMS_TABLE . " f
	WHERE f.cat_id = c.cat_id AND c.cat_type = 0 
	GROUP BY c.cat_id, c.cat_title, c.cat_order
	ORDER BY c.cat_order";

# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/functions_post.php
# 
#-----[ FIND ]------------------------------------------ 
# 
$tagallowed = false;
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
// BEGIN CMS MOD

if ($userdata['user_level'] == ADMIN) { $tagallowed = true; }

// END CMS MOD
# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/page_header.php
# 
#-----[ FIND ]------------------------------------------ 
# 
//
// The following assigns all _common_ variables that may be used at any point
// in a template.
# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
// BEGIN CMS MOD

	$sql = "SELECT cat_id, cat_title FROM " . CATEGORIES_TABLE . " WHERE cat_type=1 ORDER BY cat_order ASC";
	if( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, 'Could not obtain forums for top menu creation', '', __LINE__, __FILE__, $sql);
	}
	$cat_rows = array();
	while( $row = $db->sql_fetchrow($result) )
	{
		$cat_rows[] = $row;
	}
	$total_cats = count($cat_rows);

	$sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
				FROM (( " . FORUMS_TABLE . " f
				LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
				LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id )
				ORDER BY f.cat_id, f.forum_order";	
	if ( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, 'Could not query forums information', '', __LINE__, __FILE__, $sql);
	}

	$forum_data = array();
	while( $row = $db->sql_fetchrow($result) )
	{
		$forum_data[] = $row;
	}

	if ( !($total_forums = count($forum_data)) )
	{
		//message_die(GENERAL_MESSAGE, $lang['No_forums']);
	}

	//
	// Find which forums are visible for this user
	//
	$is_auth_ary = array();
	$is_auth_ary = auth(AUTH_VIEW, AUTH_LIST_ALL, $userdata, $forum_data);

	$top_menu = "";
	$top_menu_counter = 0;
	
	for($i = 0; $i < count($cat_rows); $i++)
	{
		//
		// Should we display this category/forum set?
		//
		$display_forums = false;
		for($j = 0; $j < $total_forums; $j++)
		{
			if ( ($is_auth_ary[$forum_data[$j]['forum_id']]['auth_view']) && ($forum_data[$j]['cat_id'] == $cat_rows[$i]['cat_id']) )
			{
				$display_forums = true;
			}
		}
		if ($display_forums)
		{ 
			if ($top_menu_counter>0) { $top_menu .= "&nbsp;::&nbsp;"; }
			$top_menu .= "<a href=\"";
			$top_link = $phpbb_root_path."index.".$phpEx."?cat=".$cat_rows[$i]['cat_id'];
			$top_menu .= append_sid($top_link);
			$top_menu .= "\">".$cat_rows[$i]['cat_title']."</a>";
			$top_menu_counter++;
		}
	}


// END CMS MOD

# 
#-----[ FIND ]------------------------------------------ 
# 	
'L_FAQ' => $lang['FAQ'],

# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
'L_FORUMS' => $lang['Forums'],

# 
#-----[ FIND ]------------------------------------------ 
# 
'U_GROUP_CP' => append_sid('groupcp.'.$phpEx),

# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
'U_FORUMS' => append_sid('forum.'.$phpEx),

# 
#-----[ FIND ]------------------------------------------ 
# 
'L_WHOSONLINE_MOD' =>
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
'P_TOP_MENU' => $top_menu,

# 
#-----[ FIND ]------------------------------------------ 
# 
'U_INDEX' => append_sid('index.'.$phpEx),

# 
#-----[ REPLACE WITH ]------------------------------------------ 
# 
'U_INDEX' => append_sid('forum.'.$phpEx),

# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/page_tail.php
# 
#-----[ FIND ]------------------------------------------ 
# 
$admin_link = ( $userdata['user_level'] == ADMIN ) ? '<a href="admin/index.' . $phpEx . '?sid=' . $userdata['session_id'] . '">' . $lang['Admin_panel'] . '</a><br /><br />' : '';
# 
#-----[ REPLACE WITH ]------------------------------------------ 
# 
$admin_link = ( $userdata['user_level'] == ADMIN ) ? '<a href="admin/index.' . $phpEx . '?sid=' . $userdata['session_id'] . '">' . $lang['Admin_panel'] . '</a>&nbsp;&nbsp;&nbsp;' : '';
$cms_link = ( $userdata['user_level'] == ADMIN ) ? '<a href="./' . append_sid('cms.' . $phpEx) . '">' . $lang['cms_link'] . '</a><br /><br />' : '';
# 
#-----[ FIND ]------------------------------------------ 
# 
'ADMIN_LINK' => $admin_link)
# 
#-----[ REPLACE WITH ]------------------------------------------ 
# 
'ADMIN_LINK' => $admin_link,
'CMS_LINK' => $cms_link)
# 
#-----[ OPEN ]------------------------------------------ 
# 
language/lang_english/lang_main.php
# 
#-----[ FIND ]------------------------------------------ 
# 
$lang['Search'] = 'Search';

# 
#-----[ REPLACE WITH ]------------------------------------------ 
# 
$lang['Search'] = 'Search forums';
# 
#-----[ FIND ]------------------------------------------ 
# 
?>
# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
// CMS language vars

$lang['ppt'] = 'Admin select post type:';
$lang['Forums'] = 'Forums';
$lang['cms_link'] = 'Go to CMS Panel';
$lang['cms_index'] = 'CMS Index';
$lang['go_to_archive'] = "Go to archive";
$lang['archive'] = "Archive";
$lang['cms_return_index'] = "Return to Category";

// CMS_BLOCK language vars

// Site search block
$lang['Site_search'] = 'Site search';
$lang['Page'] = 'Page';
$lang['Search_button'] = 'Search';
$lang['go_back'] = 'Go back to category ';
$lang['b_OR'] = "OR";
$lang['b_AND'] = "AND";

// Affiliates block
$lang['aff_title'] = "Affiliates";
$lang['aff_text'] = 'become an affiliate';

// Counter block
$lang['counter_title'] = "Counter";
$lang['hits_since'] = "hits since ";

// Last on block
$lang['b_last_on'] = "Last on";
$lang['b_last_users'] = "view current users";

// Lastest pages block
$lang['go_sitemap'] = "go to sitemap";
$lang['latest_pages'] = " latest pages";

// Last forum posts/topics
$lang['last'] = "Last ";
$lang['forum_topics'] = " forum topics";
$lang['forum_posts'] = " forum posts";
$lang['go_forums'] = "go to forums";

// User CP block
$lang['cp_on'] = "User control panel";
$lang['cp_off'] = "Log in";
$lang['Welcome'] = "Welcome";
$lang['persistent'] = "persistent login";


# 
#-----[ OPEN ]------------------------------------------ 
# 
language/lang_english/lang_admin.php
# 
#-----[ FIND ]------------------------------------------ 
# 
?>
# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
// phpBB_CMS

$lang['Block_left'] = 'Blocks installed on the left side';
$lang['Block_right'] = 'Blocks installed on the right side';
$lang['Block_uninstalled'] = 'Uninstalled blocks';
$lang['Block_index'] = 'phpBB_CMS Block adminstration';
$lang['Block_description'] = 'Here you can install, deinstall and move around blocks for the phpBB_CMS';

$lang['Block_name'] = 'Block name';
$lang['Block_actions'] = 'Block actions';

$lang['Block_install'] = 'Install block';
$lang['Block_deinstall'] = 'Deinstall block';
$lang['Block_move_left'] = 'Move block to the left side';
$lang['Block_move_right'] = 'Move block to the right side';
$lang['Block_install_left'] = 'Install block to the left side';
$lang['Block_install_right'] = 'Install block to the right side';

$lang['CMS_mngm_index'] = 'phpBB_CMS Administration';
$lang['CMS_mngm_description'] = 'This is the configuration panel for your phpBB_CMS.';

$lang['CMS_portal_news'] = 'Number of News on Portal sites';
$lang['CMS_portal_news_explain'] = 'This limits the number of posts that will be displayed on your category front pages / portals<br>E.g. if this value is set to 5 and you create a topic in a forum of the Portals category, the five newest posts (the topic post and replies) will be displayed there. If you have more than 4 replies, a link with the name archive will appear to take the user to the archive';
$lang['CMS_main_config'] = 'CMS configuration';

$lang['CMS_column_width'] = 'Column width';
$lang['CMS_column_left'] = 'Left column';
$lang['CMS_column_right'] = 'Right column';
$lang['CMS_column_left_explain'] = 'Enter the width of the left column (in pixel)';
$lang['CMS_column_right_explain'] = 'Enter the width of the right column (in pixel)<br />NOTE: The right column will only appear once you install a block there.';

$lang['CMS_sitemap'] = 'Sitemap configuration';
$lang['CMS_sitemap_cats'] = '# of sitemap categories';
$lang['CMS_sitemap_cats_explain'] = 'Number of category columns per row in sitemap';
# 
#-----[ OPEN ]------------------------------------------ 
# 
templates/subSilver/overall_footer.tpl
# 
#-----[ FIND ]------------------------------------------ 
# 
{ADMIN_LINK}
# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
{ADMIN_LINK}
# 
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
# 
{CMS_LINK}
# 
#-----[ FIND ]------------------------------------------ 
# 
{TRANSLATION_INFO}
# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
{TRANSLATION_INFO}
# 
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
# 
<br />phpBB_CMS code by <a href="http://www.kohl-net.de" target="_blank" class="copyright">IK</a> &copy; 2003
# 
#-----[ OPEN ]------------------------------------------ 
# 
templates/subSilver/overall_header.tpl

# 
#-----[ FIND ]------------------------------------------ 
# 
/* This is the line in the posting page which shows the rollover
  help line. This is actually a text box, but if set to be the same
  colour as the background no one will know ;)
*/

# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
font.content	{ text-decoration: none; font-size: 12px; }

.post_nav { font-size : 11px; }
a.post_nav {  text-decoration: none; }
a.post_nav:hover {  text-decoration: underline; }

.topic_nav			{ font-weight: bold; font-size: 11px; }
a.topic_nav			{ text-decoration: none;  }
a.topic_nav:hover	{ text-decoration: underline;  }

# 
#-----[ FIND ]------------------------------------------ 
# 
{U_INDEX}
# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
{U_INDEX}
# 
#-----[ IN-LINE REPLACE WITH ]------------------------------------------ 
# 
./index.php

# 
#-----[ FIND ]------------------------------------------ 
# 
<span class="maintitle">{SITENAME}</span><br /><span class="gen">{SITE_DESCRIPTION}<br />&nbsp; </span> 
# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
<span class="maintitle">{SITENAME}</span><br /><span class="gen">{SITE_DESCRIPTION}<br />&nbsp; </span>
# 
#-----[ IN-LINE REPLACE WITH ]------------------------------------------ 
# 
&nbsp;<br />{P_TOP_MENU}<br />&nbsp;
# 
#-----[ FIND ]------------------------------------------ 
# 
&nbsp;<a href="{U_FAQ}" 
# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
&nbsp;<a href="{U_FAQ}"
# 
#-----[ IN-LINE BEFORE, ADD ]------------------------------------------ 
# 
&nbsp;<a href="{U_FORUMS}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_hi.gif" width="12" height="13" border="0" alt="{L_FORUMS}" hspace="3" />{L_FORUMS}</a></span><span class="mainmenu">&nbsp; 
# 
#-----[ OPEN ]------------------------------------------ 
# 
templates/subSilver/posting_body.tpl
# 
#-----[ FIND ]------------------------------------------ 
# 
{MESSAGE}
</td>
</tr>	
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
{P_PPT}
# 
#-----[ OPEN ]------------------------------------------ 
# 
templates/subSilver/admin/forum_admin_body.tpl
# 
#-----[ FIND ]------------------------------------------ 
# 
{L_CREATE_CATEGORY}
# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
<input class="post"
# 
#-----[ IN-LINE BEFORE, ADD ]------------------------------------------ 
# 
<select name="cat_status"><option selected>regular</option><option>portal</option></select>
# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM

RyosukeZ · Post by **RyosukeZ** » Thu Dec 28, 2006 10:22 am

i think i'll use the CMS for later use.
i need a help here, but this isn't for phpBB 2

when i imported a vb data of my forum.
it gives me this error,

Code: Select all

Error

SQL query:

INSERT INTO `adminhelp`
VALUES (
'1', 'accessmask', '', '', '1', '1', 'vbulletin'
);

MySQL said: Documentation
#1146 - Table 'lootmafia_php.adminhelp' doesn't exist

RyosukeZ · Post by **RyosukeZ** » Thu Dec 28, 2006 10:29 am

Well, i can't test it because my hosting shutting doors. sadly..
They'll be reopened in new year.

I need your help above this post thanks.

Nightrider · Post by **Nightrider** » Thu Dec 28, 2006 11:11 am

RyosukeZ wrote: MySQL said: Documentation
#1146 - Table 'lootmafia_php.adminhelp' doesn't exist

This is the key of the error message that should give you a good hint of what has gone wrong. Whenever you see that a table, field, or record doesn't exist, that should alert you that there should be a Database update. So if you just installed a MOD or Update, you can probably find instructions and/or a file that you can use to update your database to work with the new addition...

Nightrider · Post by **Nightrider** » Thu Dec 28, 2006 11:14 am

RyosukeZ wrote: Well, i can't test it because my hosting shutting doors. sadly..
They'll be reopened in new year.

What kind of host do you have that would close it's doors until the new year? That's not something I would be willing to tolerate from a host...

RyosukeZ · Post by **RyosukeZ** » Thu Dec 28, 2006 12:02 pm

Because of hackers, thats why.
well its ahplace.com .. sadly its my favourite hosting ever..

So do you have any clues for the error sql?

Nightrider · Post by **Nightrider** » Thu Dec 28, 2006 12:30 pm

The answer is two posts back...

RyosukeZ · Post by **RyosukeZ** » Thu Dec 28, 2006 12:35 pm

huh? don't understand lol..

Nightrider · Post by **Nightrider** » Thu Dec 28, 2006 12:45 pm

If the error message is saying that the table doesn't exist, that means that you need to create the table. The MOD author probably included a DB Update file that you can run from your browser to update your database. You should get in the habit of reading the Author's Notes and DIY INSTRUCTIONS if they exist before installing the MOD...

RyosukeZ · Post by **RyosukeZ** » Fri Dec 29, 2006 1:07 am

haha, i see, then i need to re-install my vbulletin in order for it to work.
this is crap..
never mind.. thanks by the way night. ^^ maybe i should call you brother nightrider or something ^^.
your too far older then me.

Development Discussion Board

Group Rank Hack Install problem!

Re: Group Rank Hack Install problem!

Re: Group Rank Hack Install problem!

Re: Group Rank Hack Install problem!

Re: Group Rank Hack Install problem!

Re: Group Rank Hack Install problem!

Re: Group Rank Hack Install problem!

Re: Group Rank Hack Install problem!

Re: Group Rank Hack Install problem!

Re: Group Rank Hack Install problem!

Re: Group Rank Hack Install problem!