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

[Jan-Lukas]

hab den gleichen Fehler

Harald

[ccsakuweb]

i would like to show the guestbook to all people (unregistered too) but only registered user can sign it is possible? please could you helpme??

thank you ^^

[megaman]

is this going to work for 4images 1.7.4 ?
because i got an error

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

[ccsakuweb]

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 ? :

Hi I did it to my gallery and i added a quick reply in guestbook ^^ demo: http://www.myart.es/member.php?user_id=2&action=showprofile&l=spanish

Search in member.php

Code: [Select]

    $site_template->register_vars(array(
    "user_gb_ein" => $user_gb_ein,
    "user_gb_ge" => $user_gb_ge,
    "lang_gb_ein" => $lang['user_gb_ein'],
    "lang_user_gb_er" => $lang['user_gb_er'],
    "lang_user_gb_ge" => $lang['user_gb_ge'],
    "user_gb_link" => $user_gb_link
    ));
Add After:

Code: [Select]

///////// Show user guestbook in profile by patri www.myart.es
    $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,user_gender,userpic,user_signature
                  FROM (".USERS_GB_TABLE." i), (".USERS_TABLE." u)
                  WHERE user_id_gb = ".$user_row['user_id']." AND u.user_id = i.user_id_ein
                  ORDER BY user_gb_date DESC
                  LIMIT 5"; //Last comments

  $gb_sql =  mysql_query($gb_query);
$num_rows2 =$user_gb_ein;

if (!$num_rows2)  {
  $user_libro = "<table width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\"><tr class=\"imagerow1\"><td>";
  $user_libro .= $lang['no_new_images'];
  $user_libro .= "</td></tr></table>";
}
else  {
  while($ds = mysql_fetch_object($gb_sql))
    {
$user_libro .= "<table width=\"100%\" class=\"head1\" cellpadding=\"1\" cellspacing=\"0\">";
$user_libro .= "<tr><td><table class=\"row2\" cellpadding=\"3\" cellspacing=\"0\" width=\"100%\"><tr>";
$user_libro .= "<td width=\"100px\" rowspan=\"2\" align=\"left\" valign=\"top\"><b>";

    //For the Gender-MOD ;)
    if ($ds->user_gender == "m") $gender = "<img border = 0 src = '".ROOT_PATH.TEMPLATE_PATH."/images/m.gif'>";
    elseif ($ds->user_gender == "w") $gender = "<img border = 0 src = '".ROOT_PATH.TEMPLATE_PATH."/images/w.gif'>";
    elseif ($ds->user_gender == "b") $gender = "<img border = 0 src = '".ROOT_PATH.TEMPLATE_PATH."/images/b.gif'>";
    if ($ds->user_id == "")
    {
      $user = $ds->user_name_gb;
      $gb_link = "";
      $gender = "";
    }
    else
    {
      $user = "<b><a href='member.php?action=showprofile&user_id=".$ds->user_id_ein."'>".$ds->user_name_gb."</a></b>";
      $gb_link = "<a href='gb.php?action=showgb&id=".$ds->user_id."'\n target=_self><img src='".ROOT_PATH.TEMPLATE_PATH."/images/gb_".$config['language_dir'].".gif' border=0></a>";
    }

    //if installed PERSONAL_PHOTO FROM V@noyou can uncomment
    $userpic = $ds->userpic;
    if ($userpic == "") $user_pic = "<img src='".ROOT_PATH."data/userpic/default.jpg'>";
    else $user_pic = "<img src='".ROOT_PATH."data/userpic/".$userpic."'>";

$gb_time = $ds->user_gb_datum.$lang['user_gb_at'].$ds->user_gb_uhr;
    $level = $ds->user_level;
    if($level == "9") {$level = $lang['level_admin'];}
    elseif($level == "5") {$level = $lang['userlevel_moderador'];}
    elseif($level == "2") {$level = $lang['level_user'];}
    else {$level = "";}
    $text = $ds->user_gb_text;
$sig = $ds->user_signature;
$user_libro .= $user."</b> ".$gender."<br>".$level."<br>".$user_pic."<br>".$gb_link;
$user_libro .= "</td> <td align=\"left\" valign=\"top\">".format_text($text, $config['html_comments'], $config['wordwrap_comments'], $config['bb_comments'], $config['bb_img_comments'])."<hr size=\"1\">".format_text($sig, $config['html_comments'], $config['wordwrap_comments'], $config['bb_comments'], $config['bb_img_comments'])." </td></tr>";
    $user_libro .= "<tr> <td valign=\"bottom\" height=\"1\"><hr size=\"1\">";
$user_libro .= "<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"><tr><td align=\"left\"><small>";
$user_libro .= $gb_time."</small></td><td align=\"right\"></td></tr></table></td></tr></table></td></tr><tr><td class=\"row1\"></td></tr></table><br>";

  }
}
 if ($user_info['user_level'] != GUEST){
$user_firma .= "<b>Firma Rapida</b>";
$user_firma .= "<table align=\"center\" width=\"100%\" border=\"0\" cellpadding=\"3\" cellspacing=\"0\"><form name=\"commentform\" action='http://www.myart.es/gb.php?action=new&ent=true&id=".$user_row['user_id']."' method=\"post\">";
$user_firma .= "<tr><td class=head1 colspan=11>".$lang['user_gb_new']."</td></tr>";
$user_firma .= "<tr><td class=row1 align=\"center\"><textarea class=\"input\" name=\"comment_text\" id=\"comment_text\" rows=4 cols=60></textarea>";
$user_firma .= "    <input type=\"hidden\" name=\"id\" value=".$user_row['user_id']."></td></tr>";
$user_firma .= "<tr><td class=\"row1\" align=\"center\"><input type=\"submit\" class=\"button\" value=".$lang['submit'].">";
$user_firma .= "<input type=\"reset\" class=\"button\" value=".$lang['reset']."></td></tr>";
$user_firma .= "</form></table>";
}
$site_template->register_vars(array("user_libro" => $user_libro, "user_firma" => $user_firma));

///////// End show user guestbook ////////////////
Open member_profile.html
now you can add where you want tags {user_libro} (the last 5 comments, if you want another number change it in LIMIT of member.php) and {user_firma} (the quick reply form)
  good luck

[UFOSWORLD]

Great Mod...  it worked after i installed the Gender Mod... 

but when i post a Guestbook entry, there is that 5 seconds waiting...   

with no picture... 

the name of the picture is danger.gif...

can anybody post it??

danger.gif  24x24

[UFOSWORLD]

ok got it... 

[UFOSWORLD]

Another Question...  how could i post any member a welcome message in the private guestbook

any idea...  maybe sql statement??

[UFOSWORLD]

ok hab jetzt tabelle gefunden in die das ganze rein soll

4images_users_gb

da sind aber drei felder drin die ich net ganz checke... bzw zwei davon

users_gb_id   ?? da steht autoincrement...
user_id_gb   ist das die ID vom Gästebuch des Users in dem es auftauchen soll
user_id_ein  die eigene ID .. dessen der den GB Eintrag gepostet hat.

hat jemand von euch ein kleines SQL Statement, mit dem ich allen Usern einen GB eintrag reinschreiben kann??

[[M]ike]

Looks nice, I've no personal need for it as of yet but layout and whatnot looks good.

[Suricata]

Ich habe leider keine Lösung für folgende Fehlermeldung bei der Version 1.74 gefunden:

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /xxx/4images/gb.php on line 119

Wer kann mir helfen?

Danke im Voraus
Suricata

[Suricata]

Hallo,

ist diese MOD überhaupt für 1.7.4 geeignet?

Viele Grüße
Suricata

[thunderstrike]

Keine 4images Code (oder Kleiner). einige bugs ...

[Suricata]

Tja, es scheint so, als müsste ich diese MOD deinstallieren. Weder hier im Forum noch der Autor persönlich scheint weiter helfen zu können oder zu wollen.   

Vielleicht ist das MOD auch etwas oversized. Ich bin der einzige der Bilder uploaded, und ich wollte den besuchern/Gäste nur eine Möglichkeit geben, mir Nachrichten im Gästebuch zu hinterlassen.
Werde dies wohl anders lösen müssen. Gute Ideen willkommen. 

[thunderstrike]

lang Zeit nein Sehen Sie Autor ...

[Tino23]

Hatt jemand schon eine Lösung für den Fehler

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /xxx/4images/gb.php on line 119

gefunden? Währe ärgerlich wenn der MOD für die 1.7.4 Ver. nicht gehen sollte!