[MOD] User-Guestbook / User-Gästebuch V1.0.2[beta]

[beule]

hallo!
probiere mal dieses in der gb.php einzusetzen:

Code: [Select]

$gb_query = "SELECT users_gb_id,user_id_gb,user_id_ein,user_name_gb,user_gb_text,user_gb_date,DATE_FORMAT(user_gb_date,'%e.%c.%Y') AS user_gb_datum,DATE_FORMAT(user_gb_date,'%H:%i:%s') AS user_gb_uhr, user_id, user_name, user_level, userpic
               FROM (".USERS_GB_TABLE." i)
               LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id_ein)
             WHERE user_id_gb = ".$abf_id."
              ORDER BY user_gb_date DESC
             LIMIT $offset, 10";die anderen $gb_query kommentiere bitte aus.
vielleicht hilft das weiter.

Haut leider nicht hin, genau das gleiche Bild! Aber danke!

[Stoleti]

How make it show the comments at member_profile ?

Like first 10 (first page) at member_profile and the another comments shows at gb.php ???

any ideia ? :

[b.o.fan]

How make it show the comments at member_profile ?

Like first 10 (first page) at member_profile and the another comments shows at gb.php ???

any ideia ? :

hmmm.... i don't unterstand...

[Stoleti]

Very simple.

Show the last 10 comments at user profile, or make guestbook work at profile all in 1 page

[b.o.fan]

Very simple.

Show the last 10 comments at user profile, or make guestbook work at profile all in 1 page

sry. i can't help...

[ccsakuweb]

ohh.. it would be great..  althouth the mod is really great now

and what about smiles??

[Stoleti]

I've added a user_gb_title ( its the same of headlines at images ) , so i would know how show the last one at user profile , example:

user XXX have posted a comment with headline " hi" at user ... , so i pretend show at user XXX profile , Last Comment: {headline_title}

  i need help !!

[mariano]

Great Mod.

I want to integrate this mod with "Small Credit System Mod":

http://www.4homepages.de/forum/index.php?topic=9811.0

I mind, when user1 make an entry in another users guestbook, user1 obtain xx points.

Wath is the correct sql query for credists.php

I try with

    $sql8 = "SELECT COUNT(user_id_ein) AS firmas
            FROM ".USERS_GB_TABLE."
         WHERE  ".get_user_table_field("", "user_id_ein")." = $user_id";
    $row8 = $site_db->query_firstrow($sql8);
      $firmas = (isset($row8['firmas'])) ? $row8['firmas'] : 0;
    $user_firmas = "<B> ".$row8['firmas']."</B>\n";
    $site_template->register_vars("user_firmas", $user_firmas);

but do not work.

Thanks.

[Fragezeichen]

how to add the guestbook link/logo at details? (by picture vote-member coments with profile/email/pm-link)

[__G__]

I am sorry i may sound dumb but how do i create a new database field ?

[b.o.fan]

I am sorry i may sound dumb but how do i create a new database field ?

with phpMYAdmin. or something like this.

there you insert in a SQL field:

Code: [Select]

CREATE TABLE `4images_users_gb` (
  `users_gb_id` smallint(5) NOT NULL auto_increment,
  `user_id_gb` smallint(5) NOT NULL default '0',
  `user_id_ein` smallint(5) NOT NULL default '0',
  `user_name_gb` varchar(50) NOT NULL default '',
  `user_gb_text` text NOT NULL,
  `user_gb_date` timestamp NOT NULL default '0000-00-00 00:00:00',
  `user_gb_read` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`users_gb_id`)
) TYPE=MyISAM;

[glitzer]

Hi!

Vielen Dank für dieses wunderbare super script das ich mir schon solange gewünscht hatte!! Vielen Dank!

Nach der Anleitung auf der ersten Seite hatte es zwar nicht auf anhieb geklappt aber ich glaub auf seite 3 oder so, hatte Loda einen Tipp gegeben und damit funktionierte es.

Nun 2 kleine Fragen bzw. Fehlerchen:

- bei meinem Template user_gb_new für einen neuen Eintrag werden die Variablen {user_gb_own} und {user_gb_own} nicht erkannt bzw. angezeigt..wie kann ich dieses problem beheben?

- wie kann ich es ermöglichen dass der user eine Emailbenachrichtung bekommt sobald ein neuer eintrag bei ihm gemacht wird?

and now in my bad english

First, thanks for the very nice script, it works great!

I have one question and one mistake:

- in my template user_gb_new it doesent shows the variables {user_gb_own} and {user_gb_own}. What is the problem?
- it is possible that the user get an email when somebody write an entry on his guestbook?

Vielen Dank für eure Hilfe & Liebe Grüße / thanks and greets
glitzer

[glitzer]

One more question..

How can i use the Avatar Script for the guestbook entries? I don´t like use the Userpix mod.
thanks a lot

[newgsm]

Just one little suggestion.

I didn't looked at the code in detail,
but wouldn't it be better to split html and php code to templates,
so layout changes could be done more easily?

yea would be more easy to edit

script  works fine, its more about "layout"

[Parasco]

Hiya,  I'm getting this error:

Code: [Select]

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/gaspe/public_html/new/gb.php on line 119

Which is caused by this:

Code: [Select]

while($ds = mysql_fetch_object($gb_sql))
    {
    if($ds->user_id_ein == $user_info[user_id] AND $ds->user_id != $ds->user_id_gb)
    {
      $user_link_del = "<a href='gb.php?action=delete_entry&entry=".$ds->users_gb_id."&id=".$ds->user_id_gb."'>".$lang['delete']."</a>";} else {$user_link_del ="";
    }
    if($abf_id == $user_info[user_id])
    {
      $user_gb_delete = "<a href='gb.php?action=delete_entry&entry=".$ds->users_gb_id."&user=".$ds->user_id_gb."'>".$lang[delete]."</a> ".$user_link_del;
    }
    else {$user_gb_delete = $user_link_del;}
Any idea how I can fix it?