Avatar of poster on Index and Viewforum

[lefty74]

Code: Select all

Parse error: parse error in C:\xampp\htdocs\forum\includes\functions_admin.php on line 1765

FIle includes\functions_admin.php

Code: Select all

1760				delete_topics('topic_id', $delete_topic_ids, false);
1761				unset($delete_topics, $delete_topic_ids);
1762		}
1763
1764		$sql = 'SELECT p.post_id, p.topic_id, p.post_approved, p.poster_id, p.post_subject, p.post_username, p.post_time, u.username, u.user_colour, u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height, u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height
1765			$forum_data[$forum_id]['last_poster_avatar'] = $post_info[$data['last_post_id']]['user_avatar'];
1766			$forum_data[$forum_id]['last_poster_avatar_type'] = $post_info[$data['last_post_id']]['user_avatar_type'];
1767			$forum_data[$forum_id]['last_poster_avatar_width'] = $post_info[$data['last_post_id']]['user_avatar_width'];
1768			$forum_data[$forum_id]['last_poster_avatar_height'] = $post_info[$data['last_post_id']]['user_avatar_height'];
1769
1770				FROM ' . POSTS_TABLE . ' p, ' . USERS_TABLE . ' u

Help me, I can't go to ACP

the edits you have made are not correct. please go over the edits one more time for this particular file.

[lefty74]

Here's Viewforum.php


I'm pretty sure there's no mistakes.

sorry, will have to have a look later, am only on my lunch break and it is almost up...

[lefty74]

@lefty74: Did you read my post about this being implemented on the search pages? Any thoughts on that?

this mod is for index and viewforum

if i find some time i will try and have a look.

[vskylabv]

Error trying to copy in SQL as it told me to do in the xml manual.

Code: Select all

SQL query: 

ALTER TABLE phpbb_forums ADD forum_last_poster_avatar VARCHAR( 255 ) COLLATE utf8_bin NOT NULL default '';



MySQL said:  

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_bin NOT NULL default ''' at line 1 

[lefty74]

try to take out the COLLATE utf8_bin part from the SQL statement

[vskylabv]

Thanks well that solved that issue. I followed the rest of the directions pretty well I thought but now in adm - board settings, board features, avatar settings, private message settings, post settings, signature settings, user reg settings - do not work. These pages show up as a blank screen. Any ideas?

[lefty74]

no, not really.
you may wish to contact your host if they have error reporting turned on or not and ask them to turn it off if they have not.

white pages are normally suppressed errors as far as i know.

also, i am afraid, i would recommend to doublecheck all your edits one more time as it has been working fine for me.

[vskylabv]

Not sure what happened but I ran the SQL again but in parts this time. It works now.
Thanks for the help and great mod! Wasn't that bad of an install, much easier then most of the other mods out there that do a lot less.

[mezzer99]

Hi again lefty! Got a question for you re this mod: I have the 'universal no avatar' mod installed (http://www.phpbb.com/community/viewtopi ... &t=1098215), is there a way to tweak your mod so that the default avatar gets reduced in size like the normal (non-default) avatars? I think this is the same issue that ANgelArvil was asking about on Dec 25th but he didn't explain properly what was happening.

Appreciate your help.

[lefty74]

hi, i shall try to have a look soon

[mezzer99]

hi, i shall try to have a look soon

You da man, as they say over here!

[lefty74]

is there a way to tweak your mod so that the default avatar gets reduced in size like the normal (non-default) avatars? I think this is the same issue that ANgelArvil was asking about on Dec 25th but he didn't explain properly what was happening.

try this:

open viewforum.php
find

Code: Select all

		$avatar_img = $avatar_max_dimensions = $topic_last_poster_avatar_height = $topic_last_poster_avatar_width = $topic_first_poster_avatar_width = $topic_first_poster_avatar_height = '';

replace with

Code: Select all

		$avatar_img = $avatar_max_dimensions = $topic_last_poster_avatar_height = $topic_last_poster_avatar_width = $topic_first_poster_avatar_width = $topic_first_poster_avatar_height = 40;

open includes/functions_display.php

find

Code: Select all

		$avatar_max_dimensions = $avatar_width = $avatar_height = '';

replace with

Code: Select all

		$avatar_max_dimensions = $avatar_width = $avatar_height = 40;

find

Code: Select all

			return '<img src="images/avatars/no_avatar.gif" alt="' . ((!empty($user->lang[$alt])) ? $user->lang[$alt] : $alt) . '" />';

replace with

Code: Select all

			return '<img src="images/avatars/no_avatar.gif" ' . (($avatar_width) ? ' width="' . $avatar_width . '" height="' . $avatar_height . '"' : '' ) . ' alt="' . ((!empty($user->lang[$alt])) ? $user->lang[$alt] : $alt) . '" />';

[mezzer99]

Tht did it - thanks! Just need to get the guy who did the 'avatar on memberlist' do offer the same thing. Thanks lefty! I'll send corrected instructions for the ACP Announcement setup as payback!

Edit: Actually the way its stated in the current instructions will work, having read it a few more times, it just wasn't the way I intuitively approached it.

[Kaqu]

When I run avatar_update.php I get the following message:

SQL ERROR [ mysqli ]

Unknown column 'topic_last_poster_avatar_type' in 'field list' [1054]

SQL

UPDATE phpbb3_topics SET topic_last_poster_avatar = 'http://img5.imageshack.us/img5/6859/je0627.jpg', topic_last_poster_avatar_type = 2, topic_last_poster_avatar_width = 100, topic_last_poster_avatar_height = 100 WHERE topic_last_poster_id = 54

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: avatar_update.php
LINE: 51
CALL: dbal_mysqli->sql_query()

What did I do wrong?

[lefty74]

when you executed the sql statement, did you change the prefix of the sql from phpbb_ to phpbb3_?