In my forum, I've only updated the installation script manually, I've renamed le.gif to lb.gif and didn't upload all the flags, apart from that everything else is the same. I will try the DB on my localhost and tell you what will happen.ycl6 wrote:And, does your local demo version have similar database content?
Thank you SO much - perfect fix !!!ycl6 wrote:Okey, I found the problemchery wrote:The update files work for the profile but somehow stuff up my memberlist so that it shows only one member per page?
OPEN
memberlist.php
FIND
REPLACE WITHCode: Select all
if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'No_such_flag'); } if ( $flagrow = $db->sql_fetchrow($result) )
~MacCode: Select all
if ( !($flagresult = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'No_such_flag'); } if ( $flagrow = $db->sql_fetchrow($flagresult) )
Code: Select all
Parse error: parse error, unexpected T_VARIABLE in /phpBB2/admin/admin_users.php on line 2243
Code: Select all
$sql = "SELECT *
Code: Select all
// 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';
$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"' : '';
$flag_select .= ' <option value="' . $flag_image . '"' . $selected . '">' . $flag_name . '</option>';
if ( isset( $user_flag) && ($user_flag == $flag_image))
{
$flag_start_image = $flag_image;
}
}
$flag_select .= '</select>';
Quuipo wrote:is it possible to display the name of the country next to the flag instead of just the flag image?
if so, how?
ycl6 wrote:The new version hasn't made it to the MODDB, but is available on sourceforgechery wrote: I would like to change the mouseover text from the flag_image to the flag_name - is this possible and what files would I have to edit please?
~MacCode: Select all
## MOD Version: 2.3.3 ## 2006-09-24 - Version 2.3.3 ## - Display country name instead of flag name when hover over flag image
thank you, but i don't mean on mouse over but as text next to the flag image.jalaln wrote:Quuipo wrote:is it possible to display the name of the country next to the flag instead of just the flag image?
if so, how?ycl6 wrote:The new version hasn't made it to the MODDB, but is available on sourceforgechery wrote: I would like to change the mouseover text from the flag_image to the flag_name - is this possible and what files would I have to edit please?
~MacCode: Select all
## MOD Version: 2.3.3 ## 2006-09-24 - Version 2.3.3 ## - Display country name instead of flag name when hover over flag image
Code: Select all
$poster_logo = ( $postrow[$i]['user_logo'] && $postrow[$i]['user_id'] != ANONYMOUS ) ? "<img src=\"" . $phpbb_root_path . "images/logos/" . $postrow[$i]['user_logo'] . "\" border=\"0\" width=\"23 \" height=\"16\" />" : "<img src=\"" . $phpbb_root_path . "images/logos/default.gif\" border=\"0\" width=\"23 \" height=\"16\" />";
Code: Select all
$poster_logo_name = ( $postrow[$i]['user_logo_name'] && $postrow[$i]['user_id'] != ANONYMOUS ) ? $lang['logo_name'] . ': ' . $postrow[$i]['user_logo_name'] : '';
Code: Select all
'Do it yourself' instructions need to be executed by you manually, EasyMOD can not perform these actions
* Method 1: Copy root/install/db_update_en.php to install/db_update_en.php. Execute and delete after it has been run
* Method 2: Use EasyMOD to run contrib/install/db_update_en.txt
* Method 3: Copy the SQL query from contrib/install/db_update_en.txt and execute it manually
Code: Select all
Could not obtain post/user information.
DEBUG MODE
SQL Error : 1054 Unknown column 'u.user_from_flag' in 'field list'
SELECT u.username, 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 = 67 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15
Line : 400
File : viewtopic.php
Code: Select all
Couldn't obtain flags information.
DEBUG MODE
SQL Error : 1146 Table 'lifeinto.phpbb_flags' doesn't exist
SELECT * FROM phpbb_flags ORDER BY flag_name
Line : 952
File : usercp_register.php