[MOD] Paging for comments

[Joss]

Thank you very much, Vano!
I think, may be to move this link to the start of this topic?

[Aleksey]

how do then open photo,
automatic open last page comments?

[Aleksey]

up...

[V@no]

If you can answer this question...how would you open the first page of comments, if when you open the page without page=xx in the url it will open the last page? (no page=xx in the url is eaqual to page=1)
If you have an idea on how to make it work, then we'll talk

[V@no]

Ok, I'll answer it for you
In details.php replace

Code: [Select]

 if ($action == "postcomment") {with this:

Code: [Select]

 if (isset($HTTP_GET_VARS[URL_PAGE]) || isset($HTTP_POST_VARS[URL_PAGE])) {
    $page = (isset($HTTP_POST_VARS[URL_PAGE])) ? intval($HTTP_POST_VARS[URL_PAGE]) : intval($HTTP_GET_VARS[URL_PAGE]);
    if (!$page) {
      $page = 0;
    }
  }
  else {
    $page = 0;
  }
  if (!$page || $action == "postcomment") {
P.S. I like this idea of yours

[Aleksey]

YES! YES! YES! This work! Thank you very much Vano!  You super coder
В общем спасибо большое Это самое правильное дополнение к этому хаку, иначе людям приходится постоянно жать последнюю страницу чтобы посмотреть нет ли новых сообщений

[IcEcReaM]

Das ist ein netter Mod! Nur wie kann man folgendes noch dazu einstellen damit immer die letzten Kommentare sichtbar sind? Also die letzte Kommentarseite des ausgewählten Bildes?

Du kannst die Sortierreihenfolge umstellen.

I have made a little change,
so it will not display from oldest to newest.
I think to change the order from ascending to descending is better,
so u see the latest comments always on the first site.

Search

Code: [Select]

$sql = "SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS comment_user_name, c.comment_headline, c.comment_text, c.comment_ip, c.comment_date".get_user_table_field(", u.", "user_level").get_user_table_field(", u.", "user_name").get_user_table_field(", u.", "user_email").get_user_table_field(", u.", "user_showemail").get_user_table_field(", u.", "user_invisible").get_user_table_field(", u.", "user_joindate").get_user_table_field(", u.", "user_lastaction").get_user_table_field(", u.", "user_comments").get_user_table_field(", u.", "user_homepage").get_user_table_field(", u.", "user_icq").$additional_sql."
         FROM ".COMMENTS_TABLE." c
         LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = c.user_id)
         WHERE c.image_id = $image_id
         ORDER BY c.comment_date ASC
         LIMIT $offset, $commentperpage";
and replace with

Code: [Select]

$sql = "SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS comment_user_name, c.comment_headline, c.comment_text, c.comment_ip, c.comment_date".get_user_table_field(", u.", "user_level").get_user_table_field(", u.", "user_name").get_user_table_field(", u.", "user_email").get_user_table_field(", u.", "user_showemail").get_user_table_field(", u.", "user_invisible").get_user_table_field(", u.", "user_joindate").get_user_table_field(", u.", "user_lastaction").get_user_table_field(", u.", "user_comments").get_user_table_field(", u.", "user_homepage").get_user_table_field(", u.", "user_icq").$additional_sql."
         FROM ".COMMENTS_TABLE." c
         LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = c.user_id)
         WHERE c.image_id = $image_id
         ORDER BY c.comment_date DESC
         LIMIT $offset, $commentperpage";
The only change is the changed order from ASC to DESC.

[V@no]

I have made a little change,
so it will not display from oldest to newest.
I think to change the order from ascending to descending is better,
so u see the latest comments always on the first site.

Yes, you are right, its better that way. Thanks. I've updated the original code too

[mawenzi]

Yes, you are right, its better that way. Thanks. I've updated the original code too

... mmm ... but not at the right place (new paging code) ... 

[V@no]

ahaha, I'm an idiot
good save thanks

[insane]

hi, i've got a big problem, hope anyone is able to help me

first of all i made a test account in my gallery

www.p4ddy-online.de.vu/4images
name: test password: test

so that u can take a look on this problem.
when u click on a thumbnail u won't get the big version of the photo and the comments below - it looks like the page is just refreshing and do not link u to the next page (photo+comments)

how can i fix this problem? (we came to the solution that this problem has come by installing this mod http://www.4homepages.de/forum/index.php?topic=11371.0)

please help, other wise my gallery suxX -.- (anyway)

greetz (again sorry about my english..)

[V@no]

Here is a tip:
never install more the one mod at a time. Install only one, test the gallery in every possible ways, make sure it works properly, then continue with another mod. Acording to the problems you've had recently, you are installing everything at once and then test it and if something goes wrong you dont know where to look at, because you dont know what modifications could possible caused it.
So, my advice to you is start over and do it the proper way, with backups for each change you make.
I'm not going even bother to guess what possible could be wrong there.

Good luck.

[insane]

ok my nightmare became reality ;P
can i reset everything without deleting my pics and comments?
(just keep the data folder there) does it work?

[V@no]

Yes, simply replacing all .php files with fresh ones should not break your gallery, yet, you will loose all the installed mods/changes you've made (obviously), but again, backup the current files before you replace them!

P.S. personaly I hate making backups, but, using UltraEdit and with help of this little trick let me do backups by pressing two keys

[TheOracle]

P.S. personaly I hate making backups, but, using UltraEdit and with help of this little trick let me do backups by pressing two keys

In addition, there's always Winmerge (which is free) so you could compare and make the proper codings replacement without affecting your gallery.