[2.0.21] Country Flags MOD

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.

Rating:

Excellent!
26
57%
Very Good
8
17%
Good
5
11%
Fair
2
4%
Poor
5
11%
 
Total votes: 46

ScorpAL
Registered User
Posts: 15
Joined: Mon Nov 20, 2006 11:15 am

Post by ScorpAL » Thu Nov 23, 2006 7:45 am

8. Then try your EASY MOD with this file:

Code: Select all

########################################################
## MOD Title: Country/Location Flags MOD
## MOD Author: ycl6 < ycl6@users.sourceforge.net > (Y.C. LIN) http://macphpbbmod.sourceforge.net/
## MOD Author: Nuttzy99 < n/a > (Nuttzy) http://www.spellingcow.com/
## MOD Author: AbelaJohnB < n/a > (John B. Abela) n/a
## MOD Description: This mod allows your registered board members to select the flag of their country/location.
## MOD Version: 2.3.3
## 
## Installation Level: Intermediate
## Installation Time: 15 - 20 Minutes
##
## Files To Edit: 10
##	viewtopic.php
##	admin/admin_users.php
##	includes/constants.php
##	includes/usercp_viewprofile.php
##	includes/usercp_register.php
##	includes/usercp_avatar.php
##	language/lang_english/lang_main.php
##	language/lang_english/lang_admin.php
##	templates/subSilver/profile_add_body.tpl
##	templates/subSilver/admin/user_edit_body.tpl
##
## Included Files: 3 + 261 images
##	root/images/flags/*.gif
##	root/admin/admin_flags.php
##	root/templates/subSilver/admin/flags_list_body.tpl
##	root/templates/subSilver/admin/flags_edit_body.tpl
##
## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2 
################################################################# 
## For security purposes, please check: http://www.phpbb.com/mods/
## for the latest version of this MOD. Although MODs are checked
## before being allowed in the MODs Database there is no guarantee
## that there are no security problems within the MOD. No support
## will be given for MODs not found within the MODs Database which
## can be found at http://www.phpbb.com/mods/
############################################################## 
## Author Notes:
##
## 	Tested on 2.0.21. Can be installed using EasyMOD 0.3.0
##	Flag images are from CIA - The World Factbook - Flags of the World
##	http://www.cia.gov/cia/publications/factbook/docs/flagsoftheworld.html
##
## 	Monitor update status: http://sourceforge.net/project/filemodule_monitor.php?filemodule_id=187608
##
############################################################## 
## Version History:
##
##   2002-02-28 - Version ???
##      - Updated for phpBB 2.0 RC2 - Nuttzy
##
##   2002-04-01 - Version ???
##      - Updated for phpBB 2.0 RC4
##	- Right justified flags in members listing
##
##   2002-04-14 - Version 2.0.4
##	- Release for phpBB 2.0 final
##
##   2002-05-18 - Version 2.0.5
##	- Fixed a bug with edit profile sometimes reinitializing the settings - thanks sj26!
##	- Display flag when selecting from edit profile - coded by sj26
##	- Flags can be changed when editing a user in the admin panel
##	- Upgrade script from 2.0.4 released
##
##   2002-08-13 - Version 2.0.6
##	- Made for 2.0.2 of phpBB
##	- Made EasyMod alpha 2 compliant
##
##   2003-02-20 - Version 2.2.0
##	- Updated for phpBB 2.0.4
##	- Added admin tools to edit/add/remove flags
##
##   2006-04-15 - Version 2.3.0
##	- MOD took over by ycl6
##	- Updated for phpBB 2.0.20
##	- Added more countries/locations and flags
##	- Rewrote some of the codes and fix a couple of bugs
##
##   2006-05-05 - Version 2.3.1
##	- Fix a bug with flag setting become missing when profile is re-edited (thanks kenn)
##
##   2006-06-24 - Version 2.3.2
##	- Include EasyMOD compatible SQL update script separately
##
##   2006-09-24 - Version 2.3.3
##	- Display country name instead of flag name when hover over flag image
## 
############################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
##############################################################

#
#-----[ OPEN ]------------------------------------------ 
#
includes/constants.php
#
#-----[ FIND ]------------------------------------------ 
#
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');
#
#-----[ AFTER, ADD ]------------------------------------------ 
#
define('FLAG_TABLE', $table_prefix.'flags');	// Country/Location Flags
# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/usercp_viewprofile.php
#
#-----[ FIND ]------------------------------------------ 
#
$pm = '<a href="' . $temp_url . '">' . $lang['Send_private_message'] . '</a>';
#
#-----[ AFTER, ADD ]------------------------------------------ 
#
// Country/Location Flags
$sql = "SELECT flag_name
	FROM " . FLAG_TABLE . "
	WHERE flag_image = '" . $profiledata['user_from_flag'] . "'";
if ( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'No_such_flag');
}

if ( $flagrow = $db->sql_fetchrow($result) )
{
	$flag_name = $flagrow['flag_name'];
}

$location = ( $profiledata['user_from'] ) ? $profiledata['user_from'] : '&nbsp;';
$flag = ( !empty($profiledata['user_from_flag']) ) ? '&nbsp;<img src="images/flags/' . $profiledata['user_from_flag'] . '" alt="' . $flag_name . '" title="' . $flag_name . '" border="1" />' : '';
$location .= $flag;
#
#-----[ FIND ]------------------------------------------ 
#
	'LOCATION' => ( $profiledata['user_from'] ) ? $profiledata['user_from'] : '&nbsp;',
#
#-----[ REPLACE WITH ]------------------------------------------ 
#
	'LOCATION' => $location,	// Country/Location Flags
# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/usercp_register.php
#
#-----[ FIND ]------------------------------------------ 
#
	$user_timezone = ( isset($HTTP_POST_VARS['timezone']) ) ? doubleval($HTTP_POST_VARS['timezone']) : $board_config['board_timezone'];
#
#-----[ AFTER, ADD ]------------------------------------------ 
#
	$user_flag = ( !empty($HTTP_POST_VARS['user_flag']) && $HTTP_POST_VARS['user_flag'] != 'blank.gif' ) ? htmlspecialchars($HTTP_POST_VARS['user_flag']) : '' ;	// Country/Location Flags
#
#-----[ FIND ]------------------------------------------ 
# 
#
			$sql = "UPDATE " . USERS_TABLE . "
				SET " . $username_sql . $passwd_sql
#
#-----[ IN-LINE FIND ]------------------------------------------ 
#
user_from = '" . str_replace("\'", "''", $location) . "',
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
#
 user_from_flag = '" . str_replace("\'", "''", $user_flag) . "',
#
#-----[ FIND ]------------------------------------------ 
#
			$sql = "INSERT INTO " . USERS_TABLE . "	(user_id
				VALUES ($user_id
#
#-----[ IN-LINE FIND ]------------------------------------------ 
#
user_from,
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
#
 user_from_flag,
#
#-----[ IN-LINE FIND ]------------------------------------------ 
#
'" . str_replace("\'", "''", $location) . "',
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
#
'" . str_replace("\'", "''", $user_flag) . "',
#
#-----[ FIND ]------------------------------------------ 
#
	$location = $userdata['user_from'];
#
#-----[ AFTER, ADD ]------------------------------------------ 
#
	$user_flag = $userdata['user_from_flag'];	// Country/Location Flags
#
#-----[ FIND ]------------------------------------------ 
#
	display_avatar_gallery($mode,
#
#-----[ IN-LINE FIND ]------------------------------------------ 
#
$location,
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
#
 $user_flag,
#
#-----[ FIND ]------------------------------------------ 
#
		$template->assign_block_vars('switch_edit_profile', array());
	}
#
#-----[ AFTER, ADD ]------------------------------------------ 
#
	// Country/Location Flags
	// Query to get the list of flags
	$sql = "SELECT *
		FROM " . FLAG_TABLE . "
		ORDER BY flag_name";
	if(!$flags_result = $db->sql_query($sql))
	{
		message_die(GENERAL_ERROR, "Couldn't obtain flags information.", "", __LINE__, __FILE__, $sql);
	}

	// Build the html select statement
	$flag_start_image = 'blank.gif';
	$user_flag = ( !empty($user_flag) ) ? $user_flag : 'blank.gif';
	$flag_select = '<select name="user_flag" onChange="document.images[\'user_flag\'].src = \'images/flags/\' + this.value;">';
	$flag_select .= '<option value="blank.gif">' . $lang['Select_country'] . '</option>';
	while ( $flag_row = $db->sql_fetchrow($flags_result) )
	{
		$flag_name = $flag_row['flag_name'];
		$flag_image = $flag_row['flag_image'];
		$selected = ( $user_flag == $flag_image ) ? ' selected="selected"' : '';
		if ( !empty($flag_name) )
		{
			$flag_select .= '&nbsp;&nbsp;&nbsp;<option value="' . $flag_image . '"' . $selected . '>' . $flag_name . '</option>';
		}
		if ( isset( $user_flag) && ($user_flag == $flag_image))
		{
			$flag_start_image = $flag_image;
		}
	}
	$flag_select .= '</select>';
#
#-----[ FIND ]------------------------------------------ 
#
		'LOCATION' => $location,
#
#-----[ AFTER, ADD ]------------------------------------------ 
#
		'L_FLAG' => $lang['Country_flag'],	// Country/Location Flags
		'FLAG_SELECT' => $flag_select,		// Country/Location Flags
		'FLAG_START' => $flag_start_image,	// Country/Location Flags
# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/usercp_avatar.php
#
#-----[ FIND ]------------------------------------------ 
#
function display_avatar_gallery($mode,
#
#-----[ IN-LINE FIND ]------------------------------------------ 
#
&$location,
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
#
 &$user_flag,
#
#-----[ FIND ]------------------------------------------ 
#
	$params = array(
#
#-----[ IN-LINE FIND ]------------------------------------------ 
#
'location',
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
#
 'user_flag',
# 
#-----[ OPEN ]------------------------------------------ 
# 
viewtopic.php
#
#-----[ FIND ]------------------------------------------ 
#
$sql = "SELECT u.username,
	FROM " . POSTS_TABLE
	WHERE p.topic_id = $topic_id
#
#-----[ IN-LINE FIND ]------------------------------------------ 
#
u.user_from
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
#
, u.user_from_flag
#
#-----[ IN-LINE FIND ]------------------------------------------ 
#
pt.bbcode_uid
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
#
, ft.flag_name
#
#-----[ IN-LINE FIND ]------------------------------------------ 
#
POSTS_TEXT_TABLE . " pt
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
#
, " . FLAG_TABLE . " ft
#
#-----[ FIND ]------------------------------------------ 
#
		AND u.user_id = p.poster_id
#
#-----[ AFTER, ADD ]------------------------------------------ 
#
		AND ft.flag_image = u.user_from_flag
#
#-----[ FIND ]------------------------------------------ 
#
	$poster_from = ( $postrow[$i]['user_from'] && $postrow[$i]['user_id'] != ANONYMOUS ) ? $lang['Location'] . ': ' . $postrow[$i]['user_from'] : '';
#
#-----[ AFTER, ADD ]------------------------------------------ 
#
	// Country/Location Flags
	$poster_from_flag = ( $postrow[$i]['user_from_flag'] && $postrow[$i]['user_id'] != ANONYMOUS ) ? '<br /><img src="images/flags/' . $postrow[$i]['user_from_flag'] . '" alt="' . $postrow[$i]['flag_name'] . '" title="' . $postrow[$i]['flag_name'] . '" border="1" /><br />' : '';
#
#-----[ FIND ]------------------------------------------ 
#
		'POSTER_FROM' => $poster_from,
#
#-----[ IN-LINE FIND ]------------------------------------------ 
#
$poster_from
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
#
 . $poster_from_flag
#
#-----[ OPEN ]------------------------------------------
#
admin/admin_users.php
#
#-----[ FIND ]------------------------------------------ 
#
		$user_timezone = ( isset( $HTTP_POST_VARS['timezone']) ) ? doubleval( $HTTP_POST_VARS['timezone'] ) : $board_config['board_timezone'];
#
#-----[ AFTER, ADD ]------------------------------------------ 
#
		$user_flag = ( !empty($HTTP_POST_VARS['user_flag']) && $HTTP_POST_VARS['user_flag'] != 'blank.gif' ) ? htmlspecialchars($HTTP_POST_VARS['user_flag']) : '' ;	// Country/Location Flags
#
#-----[ FIND ]------------------------------------------ 
#
			$sql = "UPDATE " . USERS_TABLE . "
				SET " . $username_sql
#
#-----[ IN-LINE FIND ]------------------------------------------ 
#
user_from = '" . str_replace("\'", "''", $location) . "',
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
#
 user_from_flag = '" . str_replace("\'", "''", $user_flag) . "',
#
#-----[ FIND ]------------------------------------------ 
#
			$location = htmlspecialchars(stripslashes($location));
#
#-----[ AFTER, ADD ]------------------------------------------ 
#
			$user_flag = htmlspecialchars(stripslashes($user_flag));	// Country/Location Flags
#
#-----[ FIND ]------------------------------------------ 
#
		$location = htmlspecialchars($this_userdata['user_from']);
#
#-----[ AFTER, ADD ]------------------------------------------ 
#
		$user_flag = htmlspecialchars($this_userdata['user_from_flag']);	// Country/Location Flags
#
#-----[ FIND ]------------------------------------------ 
#
			$s_hidden_fields .= '<input type="hidden" name="location" value="' . str_replace("\"", """, $location) . '" />';
#
#-----[ AFTER, ADD ]------------------------------------------ 
#
			$s_hidden_fields .= '<input type="hidden" name="user_flag" value="' . str_replace("\"", """, $user_flag) . '" />';	// Country/Location Flags
#
#-----[ FIND ]------------------------------------------ 
#
		$form_enctype = ( !@$ini_val('file_uploads')
#
#-----[ AFTER, ADD ]------------------------------------------ 
#
		// Country/Location Flags
		// Query to get the list of flags
		$sql = "SELECT *
			FROM " . FLAG_TABLE . "
			ORDER BY flag_name";
		if(!$flags_result = $db->sql_query($sql))
		{
			message_die(GENERAL_ERROR, "Couldn't obtain flags information.", "", __LINE__, __FILE__, $sql);
		}

		// Build the html select statement
		$flag_start_image = 'blank.gif';
		$user_flag = ( !empty($user_flag) ) ? $user_flag : 'blank.gif';
		$flag_select = '<select name="user_flag" onChange="document.images[\'user_flag\'].src = \'../images/flags/\' + this.value;">';
		$flag_select .= '<option value="blank.gif">' . $lang['Select_country'] . '</option>';
		while ( $flag_row = $db->sql_fetchrow($flags_result) )
		{
			$flag_name = $flag_row['flag_name'];
			$flag_image = $flag_row['flag_image'];
			$selected = ( $user_flag == $flag_image ) ? ' selected="selected"' : '';
			if ( !empty($flag_name) )
			{
				$flag_select .= '&nbsp;&nbsp;&nbsp;<option value="' . $flag_image . '"' . $selected . '>' . $flag_name . '</option>';
			}
			if ( isset( $user_flag) && ($user_flag == $flag_image))
			{
				$flag_start_image = $flag_image;
			}
		}
		$flag_select .= '</select>';
#
#-----[ FIND ]------------------------------------------ 
#
			'LOCATION' => $location,
#
#-----[ AFTER, ADD ]------------------------------------------ 
#
			'L_FLAG' => $lang['Country_flag'],	// Country/Location Flags
			'FLAG_SELECT' => $flag_select,		// Country/Location Flags
			'FLAG_START' => $flag_start_image,	// Country/Location Flags
# 
#-----[ OPEN ]------------------------------------------ 
# 
language/lang_english/lang_main.php
# 
#-----[ FIND ]------------------------------------------ 
#
?>
# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
$lang['Country_flag'] = 'Flag';				// Country/Location Flags
$lang['Select_country'] = 'SELECT COUNTRY/LOCATION';	// Country/Location Flags
$lang['No_such_flag'] = 'No such flag exists';		// Country/Location Flags
# 
#-----[ OPEN ]------------------------------------------ 
# 
language/lang_english/lang_admin.php
# 
#-----[ FIND ]------------------------------------------ 
#
?>
# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
// Country/Location Flags
$lang['Flags'] = 'Flags';
$lang['Flags_title'] = 'Flag Administration';
$lang['Flags_explain'] = 'Using this form you can add, edit, view and delete flags. You can also create custom flags which can be applied to a user via the user management facility';
$lang['Add_new_flag'] = 'Add new flag';
$lang['Flag_name'] = 'Flag Name';
$lang['Flag_pic'] = 'Image';
$lang['Flag_image'] = 'Flag Image (in the images/flags/ directory)';
$lang['Flag_image_explain'] = 'Use this to define a small image associated with the flag';
$lang['Must_select_flag'] = 'You must select a flag';
$lang['Flag_updated'] = 'The flag was successfully updated';
$lang['Flag_added'] = 'The flag was successfully added';
$lang['Flag_removed'] = 'The flag was successfully deleted';
$lang['No_update_flags'] = 'The flag was successfully deleted. However, user accounts using this flag were not updated.  You will need to manually reset the flag on these accounts';
$lang['Flag_confirm'] = 'Delete Flag';
$lang['Confirm_delete_flag'] = 'Are you sure you want to remove the selected flag?';
$lang['Click_return_flagadmin'] = 'Click %sHere%s to return to Flag Administration';
# 
#-----[ OPEN ]------------------------------------------ 
# 
templates/subSilver/profile_add_body.tpl
#
#-----[ FIND ]------------------------------------------ 
#
		<input type="text" class="post" style="width: 200px"  name="location" size="25" maxlength="100" value="{LOCATION}" />
	  </td>
	</tr>
#
#-----[ AFTER, ADD ]------------------------------------------ 
#
	<tr>
	  <td class="row1"><span class="gen">{L_FLAG}:</span></td>
	  <td class="row2"><span class="gensmall">
		<table><tr>
			<td>{FLAG_SELECT}&nbsp;&nbsp;&nbsp;</td>
	  		<td><img src="images/flags/{FLAG_START}" name="user_flag" /></td>
		</tr></table>
	  </span></td>
	</tr>
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/admin/user_edit_body.tpl
#
#-----[ FIND ]------------------------------------------ 
#
		<input class="post" type="text" name="location" size="35" maxlength="100" value="{LOCATION}" />
	  </td>
	</tr>
#
#-----[ AFTER, ADD ]------------------------------------------ 
#
	<tr>
	  <td class="row1"><span class="gen">{L_FLAG}:</span></td>
	  <td class="row2"><span class="gensmall">
		<table><tr>
			<td>{FLAG_SELECT}&nbsp;&nbsp;&nbsp;</td>
	  		<td><img src="../images/flags/{FLAG_START}" name="user_flag" /></td>
		</tr></table>
	  </span></td>
	</tr>
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
#
# EoM

aussiewal
Registered User
Posts: 169
Joined: Tue Nov 14, 2006 5:47 am
Location: Sydney, Australia

Post by aussiewal » Thu Nov 23, 2006 11:07 am

Ye Hah!
Whooooo Hoooooo!

Thanks Dude, All installed with no errors.

THANKS! THANKS! THANKS!

You are a God!

Will

Wasrana
Registered User
Posts: 20
Joined: Tue Nov 28, 2006 6:08 am
Location: Pakistan

Post by Wasrana » Tue Nov 28, 2006 11:13 am

I installed the mod first i had an sql error but then executed it with easymod and the sql error was eliminated. I could see the flags in the profile and also in registration area.

I also installed the "Ranks summarize" mod and had problem with that but soon re uploaded the backup files.

I then install this mod and now blank pages open when clicked on a topic.


pls check www.simracingf1.com/forum

to login use
user:test
pass:azam

I am a complete rookie and doesn't know anything about php

dimz
Registered User
Posts: 3
Joined: Sun Dec 03, 2006 4:22 pm

Problem in admin view after installing

Post by dimz » Sun Dec 03, 2006 4:26 pm

After installing this mod when entering admin mode of my forum there is no left side (main admin menu). Everything else seems to work fine.

Any idea, guys?? Thanks. :roll:

Jackcorzine
Registered User
Posts: 13
Joined: Sat Feb 12, 2005 4:25 pm

Post by Jackcorzine » Mon Dec 04, 2006 2:03 am

hey a couple of years ago there was a posting about someone who had modified this mod to include different religions. Anyone know either who did this modification and where I might be able to find it?

Jack

Reeses
Registered User
Posts: 15
Joined: Wed Oct 18, 2006 6:51 pm

Post by Reeses » Mon Dec 04, 2006 7:25 pm

Okay, well, I have done everything it tells me, but the mod isnt even showing up. I have fixed multiple errors, and still nothing. I try to find it in the edit profile, there is no "choose a country" or anything... Help?

aussiewal
Registered User
Posts: 169
Joined: Tue Nov 14, 2006 5:47 am
Location: Sydney, Australia

Post by aussiewal » Tue Dec 05, 2006 12:18 am

Hey Dude

Did you manually install it or use EasyMod?

If EasyMod, what errors did you get?

Will

Reeses
Registered User
Posts: 15
Joined: Wed Oct 18, 2006 6:51 pm

Post by Reeses » Tue Dec 05, 2006 3:58 am

I did it manually.

aussiewal
Registered User
Posts: 169
Joined: Tue Nov 14, 2006 5:47 am
Location: Sydney, Australia

Post by aussiewal » Tue Dec 05, 2006 10:43 pm

Reeses wrote: I did it manually.


I had problems installing it also but used easymod, and installed after a few tries with some tweaking.

Try using easymod.

Will

Reeses
Registered User
Posts: 15
Joined: Wed Oct 18, 2006 6:51 pm

Post by Reeses » Wed Dec 06, 2006 11:37 pm

Well, I just installed easymod and everytime I try to install it I get errors...

Frustrating...

aussiewal
Registered User
Posts: 169
Joined: Tue Nov 14, 2006 5:47 am
Location: Sydney, Australia

Post by aussiewal » Thu Dec 07, 2006 2:32 am

Reeses wrote: Well, I just installed easymod and everytime I try to install it I get errors...

Frustrating...


You got errors installing easymod?

Or you still get errors installing the Country Flags Mod?

Will

dimz
Registered User
Posts: 3
Joined: Sun Dec 03, 2006 4:22 pm

Re: Problem in admin view after installing

Post by dimz » Thu Dec 07, 2006 11:41 am

dimz wrote: After installing this mod when entering admin mode of my forum there is no left side (main admin menu). Everything else seems to work fine.

Any idea, guys?? Thanks. :roll:


Hey guyz, please help me! What could be the problemm?? Anyone? :roll:

aussiewal
Registered User
Posts: 169
Joined: Tue Nov 14, 2006 5:47 am
Location: Sydney, Australia

Re: Problem in admin view after installing

Post by aussiewal » Thu Dec 07, 2006 11:55 pm

dimz wrote:
dimz wrote:After installing this mod when entering admin mode of my forum there is no left side (main admin menu). Everything else seems to work fine.

Any idea, guys?? Thanks. :roll:


Hey guyz, please help me! What could be the problemm?? Anyone? :roll:


Hey Dude

From my experience with this mod, it could be a number of things. I would check the following:

1. Was the mod designed to work on your version of phpbb
2. Are you installing the latest version

Hope this helps

Will

dimz
Registered User
Posts: 3
Joined: Sun Dec 03, 2006 4:22 pm

Re: Problem in admin view after installing

Post by dimz » Sun Dec 10, 2006 2:49 pm

Never mind. I reinstalled my backed up forums and tried to install this mod with EM. Now everything is good. I think it was just my mistake somewhere in the code when doing it manually. Thanks for your help anyways.

hatake
Registered User
Posts: 9
Joined: Wed Dec 20, 2006 8:08 am
Location: Ontario
Contact:

Post by hatake » Wed Dec 20, 2006 9:02 am

Hi all, first time poster, anyway I have a problem with the MOD, I wonna remove the mod from my forums. so I did just that. but when I go to see any one of my posts, I get this message.

Code: Select all

DEBUG MODE

SQL Error : 1054 Unknown column 'u.user_from_flag' in 'field list'

SELECT u.username, u.user_cash, u.user_id, u.user_posts, u.user_from, u.user_from_flag, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 18 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 404
File : viewtopic.php
You can go to my site and see for your self. http://www.animegears.ej.am/forum/phpBB2/index.php just go to anytopic and see if you can view it. you will get the error message.
Any idea on how to fix this? remember I am trying to remove the MOD. it seems that I removed all the files correctly, but why do I get this error still? please help.

Post Reply

Return to “[2.0.x] MOD Database Releases”