[MOD] All Comments (Alle Kommentare) V.1.6

[darkcurves]

Thanks. I thought that was for error.html. I manage to log in to my PHPMYADMIN but where am i suppose to search? phpbb_users or 4images_users?

[mawenzi]

this mod used user_id from table ...
- 4images_users
- 4images_comments
- 4images_images

[darkcurves]

Thanks for the reply. I tried afew but it still doesn't seem to work. Below are my tables, any idea which one? Also, i have PHPBB integration, possible if it's in PHPBB table? Thanks for your replies, appreciate your help.

4images_4images
http://i1.tinypic.com/rvhlsi.jpg

4images_comments
http://i1.tinypic.com/rvhm2u.jpg

4images_users
http://i1.tinypic.com/rvhm4i.jpg

[mawenzi]

@darkcurves,
look at your comments_all.php ...

this is your error message :

DB Error: Bad SQL Query: ... c.userid, ...
Unknown column 'c.userid'

and the query in comments_all.php must be (see the first page...) :

$sql = "SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS ...

In your tables you use only user_id ... !

[V@no]

In your tables you use only user_id ... !

They have to use userid for the users table because of phpbb integration...

[mawenzi]

They have to use userid for the users table because of phpbb integration...

... but not in the tables which are above shown as pictures ... 

[darkcurves]

Thanks again for your reply. After changing c.userid to c.user_id, i get a different error below:

Code: [Select]

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, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 10341 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, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 10327 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, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 10366 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, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 10366 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, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 5605 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, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 6231 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, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 8544 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, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 10366 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, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 10324 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, u.user_id, u.user_level, u.username FROM 4images_images i, 4images_categories c LEFT JOIN phpbb_users u ON (u.user_id = i.user_id) WHERE i.image_id = 10366 AND c.cat_id = i.cat_id
Unknown column 'i.user_id' in 'on clause'

I have changed all userid to user_id at comments_all.php. What could be the problem this time? Thanks.

[V@no]

u.user_id

[darkcurves]

Vano and Mawenzi, thanks alot guys! It works finally, really appreciate spending time to reply my posts. I am one happy webmaster! 

Btw, below the pics it says Anonymous, is it because i dont have the other two mods? Below is the link to my comments_all.php:
http://www.ktmrailwayfan.com/pics/comments_all.php

[waleed]

i installed this MOD and evrything is fine except one thing
here you can see:
http://www.maghna.com/comments_all.php

white page why ?

[waleed]

fixed

[koikonut]

Ich habe leider das gleiche Problem wie ein User ein paar Seiten zuvor, obwohl ich NICHTS an den Seiten verändert habe, noch am Style von 4images - es müsste also alles perfekt wie im "Auslieferungszustand" sein. Also bei mir wir auch blau auf blau geschrieben:

Siehe hier: http://www.konradin.net/comments_all.php

Vielen Dank beim Fehler finden helfen

Chao, übrigens ein toller Mod,
Konradin

[mawenzi]

Hallo konradin,

in der comments_all_bit.html muss für den Tabellenkopf die Schriftfarbe geändert werden. Entweder du machst das über deine style.css mit einer neuen "class" ... oder du findest in der comments_all_bit.html folgendes ...

Code: [Select]

<tr>
   <td colspan="2" class="head2" height="20">
        <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr><td width="75%">
        <b>{comment_counter}. {lang_com}</b> <small>{lang_for_image}</small><b> {comment_image_name}</b> <small>- [{lang_in_cat} {comment_cat_name}]</td>
        <td align="right" width="25%">
        <small>[{lang_com_date} <b>{comment_date}</b>]</small></td>
        </tr></table>
   </td>
</tr>

und tauscht es gegen dieses aus ...

Code: [Select]

<tr>
   <td colspan="2" class="head2" height="20">
        <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr><td width="75%"><font color="#ffffff">
        <b>{comment_counter}. {lang_com}</b> <small>{lang_for_image}</small><b> {comment_image_name}</b> <small>- [{lang_in_cat} {comment_cat_name}]</font></td>
        <td align="right" width="25%"><font color="#ffffff">
        <small>[{lang_com_date} <b>{comment_date}</b>]</small></font></td>
        </tr></table>
   </td>
</tr>

mawenzi

[Sopur]

Hallo!
Bei mir funktioniert der Mod sehr gut
Ein kleines (kosmetisches) Problem habe ich: wie bringe ich die Links auch weiss? Ich habe da schon in cer style.css rumgepröbelt, aber leider nichts gefunden
Konkret geht es um diese Seite: http://www.harassenlauf.ch/comments_all.php

Vielen Dank!
M
F
G
Sopur

[mawenzi]

@ Sopur,

entweder du definierst in der style.css eine neue "class" für die Links im Tabellenkopf und verwendest diese dann in der comments_all_bit.html ... oder du machst das so wie hier -> http://www.4homepages.de/forum/index.php?topic=10632.msg59159#msg59159

mawenzi