LAtest entry to guestbok

[jar]

i need a snnipet to show me LAtest entry to guestbok . something like the latest comments

someone? can help me ?

please

[ruebenwurzel]

Hello,

try it with the anynews snippet and replace the database query to query the guestbook.

Matthias

[jar]

Hello,

try it with the anynews snippet and replace the database query to query the guestbook.

Matthias

i dont know how !!   

it`s need to  replace just the name of the tabel ?
hmm !!
and i want to show just like the latest coments not like anynews ..  i try to modify the latest coments snipet and don`t work


hmmm .. can you help please .. 

[macsmet]

Hi Jar,

This one has been made before in 2007.
I searched the forum, downloaded it and attached it to this message.

MacSmet

[jar]

Hi Jar,

This one has been made before in 2007.
I searched the forum, downloaded it and attached it to this message.

MacSmet

where you find the snipet because i have a problem

the |show more link | does`n go on the page where is posted

[doc]

Hello,

I sent this code snippet some time ago to Escpro who asked for a feature to extract the latest entry from the guestbook. Maybe it helps. The code needs to be added to the index.php of your template where you want to display the guestbook entry.

Code:

<?php
// fetch last entry from guestbook table (order by timestamp)
$result = $database->query("SELECT * FROM `" .TABLE_PREFIX .
  "mod_guestbook` WHERE `approved`='1' ORDER BY `posted_when` DESC LIMIT 1");

// display last entry or a default message
if($result && $result->numRows() > 0) {
  $data = $result->fetchRow();
  // output header with author and time (month-day-year)
  echo '<strong>' .$wb->strip_slashes($data['name']) .' - ' .
    date('m-d-y', $wb->strip_slashes($data['posted_when'])) .'</strong><br />';
    
  // output guestbook message
  echo $wb->strip_slashes($data['message']);
    
} else {
  // no guestbook data found
  echo 'No guestbook entry available.';
}
?>

Regards Christian

P.S.: If you are only interested in the last entry one may want to use the WB database function get_one instead (/framework/class.db.php).

[jar]

Hello,

I sent this code snippet some time ago to Escpro who asked for a feature to extract the latest entry from the guestbook. Maybe it helps. The code needs to be added to the index.php of your template where you want to display the guestbook entry.

Code:

<?php
// fetch last entry from guestbook table (order by timestamp)
$result = $database->query("SELECT * FROM `" .TABLE_PREFIX .
  "mod_guestbook` WHERE `approved`='1' ORDER BY `posted_when` DESC LIMIT 1");

// display last entry or a default message
if($result && $result->numRows() > 0) {
  $data = $result->fetchRow();
  // output header with author and time (month-day-year)
  echo '<strong>' .$wb->strip_slashes($data['name']) .' - ' .
    date('m-d-y', $wb->strip_slashes($data['posted_when'])) .'</strong><br />';
    
  // output guestbook message
  echo $wb->strip_slashes($data['message']);
    
} else {
  // no guestbook data found
  echo 'No guestbook entry available.';
}
?>

Regards Christian

P.S.: If you are only interested in the last entry one may want to use the WB database function get_one instead (/framework/class.db.php).

its ok but i want to have a link to the page where is posted
and i want to have more than one comment
thanks!!

[erpe]

Hi @all

jar is absolutely right.
The zip posted by macsmet doesn't work right with the links.
Is there someone to modify this and make it work?

Thanks in advance.

erpe

[Bramus]

i think if you change LIMIT 1 to some other value u will get more, havent tested because still at school in a college room but think that will work.

[erpe]

That is right, I tested it.
But the problem is the wrong link.

rgds

erpe

[Bramus]

what do you mean by wrong link? do you have an example or something? Havent been following this thread pretty good, but will try to help

[erpe]

Hi Bramus

thanks for helping.

Here is a link:   http://www.rvb.bplaced.net/pages/last-gb-entry.php

Page bases on modul from macsmet some posts above.
Links are not pointing to the guestbook but to the start page, for pageID=29 seems to be not right, but
the guestbook on this site is pageID=29.
So there must be something wrong in the module.

rgds

erpe

[erpe]

Hi Bramus,

any ideas?

rgds

erpe

[jar]

another example is on adress : www.haiinoras.ro

[Bramus]

I'm very busy at this moment with some other projects, didnt have time to test, maybe i can test the module tomorrow cause i need to setup a test installation tomorrow anyway.

[erpe]

Thanks for helping us.

If you want, I create an account for my testpage.
Give me an info via pm.

Thanks

erpe

[jar]

nothing yet ?\

[erpe]

Hi Bramus,

thank you for working on this snippet.
For it was not that easy to "repair" the links and for they are not really neccessary (create a link to the guestbook at the bottom or the top of this item) Bramus removed the links.

The reworked snippet can be downloaded at latest guestbook entry

rgds

erpe

[Bramus]

nice to see the snippet is working, hope you can use it as it is now. If there needs to be any modification, let it know so i can see if i can fix it.

Bram

[Frediwan]

hi
the "read more" text/link does not appear by showing not the whole entry?

Code:

display_gb_items(368, 1, 300, 1, "The latest news", "read more", "uups, no news available",false);

and how can i use this as a droplet?

any help for me please
frediwan