[Mod] Show user's comments from his profile

[Stoleti]

can we got the avatar (userpic) of the user of who had received the comment ?

[sy4k4]

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, i.image_allow_comments FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_id = 119 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, i.image_allow_comments FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_id = 114 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, i.image_allow_comments FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_id = 97 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, i.image_allow_comments FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_id = 31 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, i.image_allow_comments FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_id = 13 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, i.image_allow_comments FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_id = 118 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, i.image_allow_comments FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_id = 117 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, i.image_allow_comments FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_id = 116 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, i.image_allow_comments FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_id = 65 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, i.image_allow_comments FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_id = 20 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, i.image_allow_comments FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_id = 40 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, i.image_allow_comments FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_id = 53 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'



i use 4images 1.7.2

[ccsakuweb]

This mod is not compatible with integrations such as phpbb or vbuletin integrations.

V@no I installed this mod succesful and i have my gallery integrated with phpbb. it´s great! thanks a lot! ^^

um.. i modified the integrated mod to see 4images profile. my problem is when i try to add a new field in 4images profile..

[Darkness2001]

Hello,

i have 1.7.4 and i have an error :

Notice: Undefined variable: user_row in /homepages/35/d85936339/htdocs/0images/includes/page_header.php on line 117

what is the right code for page_header.php ?

I put this code in the includes/page_header.php

"lang_show_user_comments" => $lang['show_user_comments'],
  "url_show_user_comments" => $site_sess->url(ROOT_PATH."member.php?action=showcomments&user_id=".$user_row['user_id']),

Thanks for helping

Greez Darkness 

[Joss]

sy4k4,
this is a incompatibility with a MySQL5. Change the following string:

FROM ".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c

to

FROM (".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c)

V@no,
could you update your script accordingly?

[maus]

Hallo zusammen,

geht es das man dieses mod auch in deutsch erklären kann.
Leiter kann ich kein Wort englisch.

[Fragezeichen]

it is working with latest vesion 1.74?

i got that error by clicking show comments:

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, i.image_allow_comments FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_id = 347 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

DB Error: Bad SQL Query: SELECT i.image_id, i.cat_id, i.image_name, c.cat_name, i.image_media_file, i.image_thumb_file, i.image_allow_comments FROM 4images_images i, 4images_categories c LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_id = 231 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

[manurom]

Hello;
the answer is two posts before: http://www.4homepages.de/forum/index.php?topic=4131.msg88884#msg88884:

this is a incompatibility with a MySQL5. Change the following string:

FROM ".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c

to

FROM (".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c)

[Fragezeichen]

GREAT!!!

..now it works well,many thanks.

 

[ojoaldato]

How can i show only the comments in one concrete image?

Thanks

[Frank Götze]

This line from step 1.2 is resposible:

Code: [Select]

   $comments = "<TABLE width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"bordercolor\"><tr><td class=\"commentrow1\" colspan=\"2\">".$lang['member_no_comments']."</td></tr></table>";

Hi Vano,

thank you for this graet MOD. But i have the same problem if the user has no comments in profile. ( http://www.photography-portal.de/galerie/member.php?action=showcomments&user_id=19 )

I'm insert this code and it' work:

Code: [Select]

$comments = "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"bordercolor\">\n<tr>\n<td>\n<table width=\"100%\" border=\"0\" cellpadding=\"3\" cellspacing=\"1\"><td class=\"commentrow1\" colspan=\"2\">".$lang['member_no_comments']."</td>\n";
Frank.

[mato72]

I get an
Parse error: syntax error, unexpected ';', expecting ')' in /member.php on line 962

On this line is this:

961    "lang_icq" => $lang['icq'],
962    ));
963

>>>>EDIT<<<<

Sorry, I just found out...

>>><<<<<

[Schtorsch]

I have a problem with the mod...
I checked every step many times - and I can`t find the mistake...

The link in member profile is shown and works nice. But the "result-site" is damaged...
There are "frames" - the gallery is copying itself...  And the paging is at top of the site...

Here are the screenshot:



Can anybody help me?!

EDIT: Here are the link to my "mistake"...  http://www.dhk-galerie.de/4images/member.php?action=showcomments&user_id=29

[Tino23]

An welcher Stelle der member.php muß ich denn noch folgenden Code Einfügen, damit mit der Link "Angezeigt" wird und verknüpft ist?

"lang_show_user_comments" => $lang['show_user_comments'],
      "url_show_user_comments" => $site_sess->url(ROOT_PATH."member.php?action=showcomments&user_id=".$user_row['user_id']),

9.12.2007  :

[masterred]

hi

how show the comment in member_profile.html,

step

Step 3.
Open /templates/<yourtemplate>/member_profile.html

Add this tag, whereever u want to display link for comments:
Code:
<A href="{url_show_user_comments}">&nbsp;&nbsp;{lang_show_user_comments}&nbsp;&nbsp;</a>

I do like to look at the comments member_profiles.html no link to another page. Which are shown in profile.

thanks