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

[Stoleti]

I think i need help about make it look like my layout ...

comments rows (commentrow$row_bg_counter) like in details...

i dont understand...

alternate comments row / background colors like in details

yeah and that is the problem, i have it not make it with templates...
sorry. when somebody with enough knowledge to help me, to make a better version

PS: great site

well for now maybe one lil thing would help , its about make borders around comments would help to understand users , and make less confused !!

how can i do it ?

[b.o.fan]

do you mean this?

[Stoleti]

yes 

as u've said , with bbcode ill be perfect but for now its good enough 

[ccsakuweb]

hi! i have installed your mod. it´s great but i can´t view my messages... where can i see the received messages? i have wrote with my account (admin) a new entry but i don´t know how to read it. I can see in my profile that i have a new entry with a number (but in the userinfo box i see 0 new messages...) but where can i go to read it? and... the users can´t read my guesstbook?
the demo : www.myart.es
user: test
pass: test

my profile is: http://www.paxykochan.net/myart/member.php?action=showprofile&user_id=2

another question: where i write the message is too big how can i change the size?

..and i think this mod need anti-spam, rigth?

[b.o.fan]

yes 

as u've said , with bbcode ill be perfect but for now its good enough 

when you will make it..

get this gb.php

Code: [Select]

<?php
/**************************************************************************
 *                                                                        *
 *    4images - A Web Based Image Gallery Management System               *
 *    ----------------------------------------------------------------    *
 *                                                                        *
 *             File: member.php                                           *
 *        Copyright: (C) 2002 Jan Sorgalla                                *
 *            Email: jan@4homepages.de                                    *
 *              Web: http://www.4homepages.de                             *
 *    Scriptversion: 1.7.3                                                *
 *                                                                        *
 *    Never released without support from: Nicky (http://www.nicky.net)   *
 *                                                                        *
 **************************************************************************
 *                                                                        *
 *    Dieses Script ist KEINE Freeware. Bitte lesen Sie die Lizenz-       *
 *    bedingungen (Lizenz.txt) für weitere Informationen.                 *
 *    ---------------------------------------------------------------     *
 *    This script is NOT freeware! Please read the Copyright Notice       *
 *    (Licence.txt) for further information.                              *
 *                                                                        *
 **************************************************************************
 *                                                                        *
 *    User-Guestbook Version 1.0 betha for 4images                        *
 *                                                                        *
 *    Tested on 1.72 and 1.73                                             *
 *                                                                        *
 *    (C) 2006 by bofan                                                   *
 *                                                                        *
 *************************************************************************/

$main_template = "user_gb";

define('GET_CACHES', 1);
define('ROOT_PATH', './');
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
$user_access = get_permission();
include(ROOT_PATH.'includes/page_header.php');

if ($action == "")
{
  $action = "showgb";
}

if ($action == "showgb_new")
{
  $update_query = "UPDATE ".USERS_GB_TABLE." SET user_gb_read = NOW() WHERE user_id_gb =".$user_info['user_id']." AND user_gb_read = 0";
  $sql = mysql_query($update_query);
  $action = "showgb";
}

if ($action == "showgb") {
    if ($user_info['user_level'] == GUEST) {
    show_error_page($lang['no_permission']);
    exit;
  }
  if($_GET['id'] == "") $id = $user_info[user_id]; else $id = $_GET['id'];
  if(isset($id))
  {
   $query = "SELECT user_id, user_name FROM ".USERS_TABLE." WHERE user_id = ".$id."";
   $sql = mysql_query($query);
   $ds = mysql_fetch_object($sql);
   $user_name = "<a href='member.php?action=showprofile&user_id=".$ds->user_id."' target=_self>".$ds->user_name."</a>";
   $user_name2 = $ds->user_name;
  } else {
  $user_name = $user_info['user_name'];
  $user_name2 = $user_info['user_name'];
  }
  if(isset($id)) {$abf_id = $id;} else {$abf_id = $user_info['user_id'];}
  $user_gb_own = $lang['user_gb'].$user_name2."";
  $button_ein = "<a href='gb.php?action=new&id=".$abf_id."'><img border = 0 src = '".ROOT_PATH.TEMPLATE_PATH."/images/entry_new_".$config['language_dir'].".gif'></a>";
  $query2 = "SELECT COUNT(*) FROM ".USERS_GB_TABLE." WHERE user_id_gb = ".$abf_id."";
  $sql2 = mysql_query($query2);
  $erg = mysql_result($sql2,0);
  if($erg == "0"){$user_gb_entry = $erg.$lang['user_gb_entry'];}
  elseif($erg == "1"){$user_gb_entry = $erg.$lang['user_gb_entrys'];}
  elseif($erg > "1"){$user_gb_entry = $erg.$lang['user_gb_entrys'];}

  $offset = @$_GET['off'];
  if(isset($offset)) {$offset = $_GET['off'];} else {$offset = "0";}
  $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
              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";
  $gb_sql = mysql_query($gb_query);

  $user_gb_entry_text .= "<table width=100% cellpadding=1 cellspacing=0>";
  
  while($ds = mysql_fetch_object($gb_sql))
    {
    $user_gb_entry_text .= "<table width=100% cellpadding=2 cellspacing=1>\n<tr width=100%><td valign=top width=150px class=row1><b>";
    if($ds->user_level == "2") {$ds->user_level = $lang['userlevel_user'];}
    if($ds->user_level == "9") {$ds->user_level = $lang['userlevel_admin'];}
    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 ($ds->user_id == "")
    {
      $user_gb_entry_text .= $ds->user_name_gb."</b><br>".$ds->user_level."<br>";
    }
    else $user_gb_entry_text .= "<b><a href='member.php?action=showprofile&user_id=".$ds->user_id_ein."'>".$ds->user_name_gb."</a></b><br><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></b><br>".$ds->user_level."<br>";

    //if installed PERSONAL_PHOTO FROM V@noyou can uncomment
    //if(file_exists(ROOT_PATH."data/userpic/".$ds->user_id_ein.".gif")) {$user_gb_entry_text .= "<br><a href='gb.php?action=showgb&id=".$ds->user_id."'\n target=_self><img src='".ROOT_PATH."/data/userpic/".$ds->user_id_ein.".gif' width=90px></a><br>";}
    //if(file_exists(ROOT_PATH."data/userpic/".$ds->user_id_ein.".jpg")) {$user_gb_entry_text .= "<br><a href='gb.php?action=showgb&id=".$ds->user_id."'\n target=_self><img src='".ROOT_PATH."/data/userpic/".$ds->user_id_ein.".jpg' width=90px></a><br>";}
    //else $user_gb_entry_text .= "<br>";

    $text = $ds->user_gb_text;
    $pattern = '#(^|[^\"=]{1})(http://|ftp://|mailto:|news:)([^\s<>]+)([\s\n<>]|$)#sm';
    $text = preg_replace($pattern,"\\1<a href=\"\\2\\3\"><u>\\2\\3</u></a>\\4",$text);

    $user_gb_entry_text .= "<br>\n";
    $user_gb_entry_text .= $ds->user_gb_datum.$lang['user_gb_at'].$ds->user_gb_uhr." </td><td class=row2 valign=top>".nl2br($text)."</td>";
    if($abf_id == $user_info[user_id])
    {$user_gb_entry_text .= "<td class=row1 width=80px><center><a href='gb.php?action=delete_entry&entry=".$ds->users_gb_id."&user=".$ds->user_id_gb."'>".$lang[delete]."</a> ".$user_link_del."</center></td></tr>";}
    else {$user_gb_entry_text .= "<td class=row1 width=80px><center>".$user_link_del."</center></td></tr>";}
    $user_gb_entry_text .= "</table>\n";
  }
  $user_gb_entry_text .= "<tr><td>";
  if($offset == 0) {$vor = "";}
  else
  {
    $offset2 = $offset - 10;
    $vor = "<a href='gb.php?action=showgb&id=".$abf_id."&off=".$offset2."'>".$lang['user_gb_prev']."</a>";
  }
  $offset3 = $offset + 10;
  if($offset3 >= $erg ) { $weiter = "";}
  else {$weiter = "<a href='gb.php?action=showgb&id=".$abf_id."&off=".$offset3."'>".$lang['user_gb_next']."</a>";}
  $user_gb_entry_text .= "<center>".$vor."&nbsp;".$weiter."</center></td></tr>";

    $site_template->register_vars(array(
    "user_gb_own" => $user_gb_own,
    "button_ein" => $button_ein,
    "user_gb_entry" => $user_gb_entry,
    "user_gb_entry_text" => $user_gb_entry_text
  ));
  $txt_clickstream = $lang['user_gb'].$user_name;
  $content = $site_template->parse_template("user_gb_showgb");
}

if ($action == "delete_entry")
{
  if(isset($_GET['aktion']))
  {
    if($_GET['aktion'] == $lang['user_gb_delete_yes'])
    {
      $query = "DELETE FROM ".USERS_GB_TABLE." WHERE users_gb_id = ".@$_GET['entry']."";
      $sql = $site_db->query($query);
      $user_gb .= $lang['user_gb_delete']."<br><br><a href='gb.php?action=showgb&id=".$_GET['id']."'>".$lang['user_gb_back']."</a>";
      $txt_clickstream = $lang['user_gb_delete_ok'];
    }
    if($_GET['aktion'] == $lang['user_gb_delete_no'])
    {
      $user_gb .= "<meta http-equiv=refresh content=\"0; URL=gb.php?action=showgb&id=".$_GET['id']."\">";
    }
  }
  else
  {
    $user_gb .= "<form action='?action=delete_entry' method=get>\n";
    $user_gb .= "<table>\n
    <tr class=tableheader>
    <td colspan=2 width=600px>\n
    <span class=tableheader><center>\n
    ".$lang['user_gb_delete_quest']."</span>
    </center></td></tr>\n
    <tr>
    <td><center>
    <input type=hidden name=action value=delete_entry>\n
    <input type=hidden name=entry value=".$_GET['entry'].">\n
    <input type=hidden name=id value=".$_GET['id'].">\n
    <input type=submit name=aktion value='".$lang['user_gb_delete_yes']."' class=button>&nbsp;\n
    <input type=submit name=aktion value='".$lang['user_gb_delete_no']."' class=button>\n
    </center>
    </td>
    </tr>
    </table></form>";
    $txt_clickstream = $lang['user_gb_delete_click'];
  }
    if ($user_info['user_level'] == GUEST)
    {
       show_error_page($lang['no_permission']);
    exit;
    }

    $site_template->register_vars(array(
    "user_gb" => $user_gb
    ));
    $content = $site_template->parse_template("user_gb_delete");
}

if ($action == "new")
{
  if($_GET['ent'] == "") $afg = "false"; else $afg = $_GET['ent'];
  if ($_POST['text'] == "" & $_GET['ent'] == "true")
    {
      $msg = $lang['error_no_text'];
      $afg = "false";
    }
  if($afg == "true")
  {
    $text = $_POST['text'];

    if($_POST['id'] == $user_info[user_id]) { $a = "NOW()";}
    else {$a = "'0'";}
    $query = "INSERT INTO ".USERS_GB_TABLE."
              (user_id_gb, user_id_ein, user_name_gb, user_gb_text, user_gb_date, user_gb_read)
              VALUES
              ('".$_POST['id']."', '".$user_info[user_id]."', '".$user_info[user_name]."','".$text."', NOW(), ".$a.")";
    $sql = mysql_query($query);
    
    $user_gb .= "<meta http-equiv=refresh content=\"5; URL=gb.php?action=showgb&ent=true&id=".$_POST['id']."\">\n
    <fieldset style=border : 1px solid blue><legend style=color: black;><b>".$lang['user_gb_new_ok']."</b>\n
    </legend>\n<table border=0 cellspacing=0 cellpadding=8><tr><td><img src='".TEMPLATE_PATH."/images/danger.gif' /></td>\n
    <td><p>&nbsp;".$lang['user_gb_new_wait']."
    <a href=gb.php?action=showgb&id=".$_POST['id'].">".$lang['user_gb_new_to']."</a><br></p></td></tr></table></fieldset>";
  }
  elseif ($afg == "false")
  {
    $user_gb .= "<center>
    <form name=gb action='?action=new&ent=true&id=".$_GET['id']."' method=post>
    <table width=450px><tr><td class=head1 colspan=11>".$lang['user_gb_new']."</td></tr>\n
    <tr><td colspan=11><center><textarea class=input name=text rows=6 cols=90></textarea></center></td></tr>\n
    <tr>
    <tr><td colspan=2>&nbsp;</td><td colspan=7><center><input type=submit class=button value=Absenden>&nbsp;\n
    <input type=reset class=button value=Zurücksetzen>
    <input type=hidden name=id value=".$_GET['id'].">\n
    </center></td><td clospan=2>&nbsp;</td></tr>\n
    </table>
    </form></center>";
  }
    if ($user_info['user_level'] == GUEST)
    {
       show_error_page($lang['no_permission']);
    exit;
    }

    $site_template->register_vars(array(
    "user_gb" => $user_gb
    ));
    $txt_clickstream = $lang['user_gb_new'];
    $content = $site_template->parse_template("user_gb_delete");
}

//-----------------------------------------------------
//--- Clickstream -------------------------------------
//-----------------------------------------------------
if($txt_clickstream == ""){
  $txt_clickstream = $lang['bug'];
}

$clickstream = "<span class=\"clickstream\"><a href=\"".$site_sess->url(ROOT_PATH."index.php")."\" class=\"clickstream\">".$lang['home']."</a>".$config['category_separator'].$txt_clickstream."</span>";

//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$site_template->register_vars(array(
  "content" => $content,
  "msg" => $msg,
  "clickstream" => $clickstream,
  "lang_control_panel" => $lang['control_panel']
));
$site_template->print_template($site_template->parse_template($main_template));
include(ROOT_PATH.'includes/page_footer.php');
?>
and this user_gb_showgb.html

Code: [Select]

<table border="0" cellpadding="0" cellspacing="0"><tr><tr><td>{user_gb_entry}</td></tr><td bgcolor="#000000" cellpadding="0" cellspacing="0">
{user_gb_entry_text}</td></tr></table>


<td bgcolor="#000000" <--- define the color

[b.o.fan]

hi! i have installed your mod. it´s great but i can´t view my messages... where can i see the received messages? i have wrote with my account (admin) a new entry but i don´t know how to read it. I can see in my profile that i have a new entry with a number (but in the userinfo box i see 0 new messages...) but where can i go to read it? and... the users can´t read my guesstbook?
the demo : www.myart.es
user: test
pass: test

my profile is: http://www.paxykochan.net/myart/member.php?action=showprofile&user_id=2

another question: where i write the message is too big how can i change the size?

..and i think this mod need anti-spam, rigth?

have you a user_gb_showgb.html?

anti-spam? jeah i think so, but only member can post

[ccsakuweb]

you forgot to say that we have to translate "neue Gästebucheinträge" from includes/page_header in:

 

Code: [Select]

"//-----------------------------------------
//---[MOD] User_Guestbook V.1.0 betha -----
//----2006 by bofan for 4images gallery ---
//-----------------------------------------
$query = "SELECT COUNT(*) FROM ".USERS_GB_TABLE."
          WHERE user_id_gb = ".$user_info['user_id']."
          AND user_gb_read = '0'";
$sql = mysql_query($query);
$erg = mysql_result($sql,0);
  if($erg == "0"){$user_gb_neu = $erg." neue Gästebucheinträge";}
  elseif($erg == "1"){$user_gb_neu = "<b>".$erg." neuer Gästebucheintrag</b>";}
  elseif($erg > "1"){$user_gb_neu = "<b>".$erg." neue Gästebucheinträge</b>";}

//--END USER-Guestbook MOD---
and this other code from gb.php

Code: [Select]

    <tr><td colspan=2>&nbsp;</td><td colspan=7><center><input type=submit class=button value=Absenden>&nbsp;\n
    <input type=reset class=button value=Zurücksetzen>
Absenden and Zurücksetzen    isn´t it?

[ccsakuweb]

anti-spam? jeah i think so, but only member can post

your rigth 

great work!!

[ccsakuweb]

have you a user_gb_showgb.html?

yes... but i don´t know why it doesn´t show the messages.... maybe i forgot anything about {user_gb_entry_text}

[b.o.fan]

you forgot to say that we have to translate "neue Gästebucheinträge" from includes/page_header in:

 

Code: [Select]

"//-----------------------------------------
//---[MOD] User_Guestbook V.1.0 betha -----
//----2006 by bofan for 4images gallery ---
//-----------------------------------------
$query = "SELECT COUNT(*) FROM ".USERS_GB_TABLE."
          WHERE user_id_gb = ".$user_info['user_id']."
          AND user_gb_read = '0'";
$sql = mysql_query($query);
$erg = mysql_result($sql,0);
  if($erg == "0"){$user_gb_neu = $erg." neue Gästebucheinträge";}
  elseif($erg == "1"){$user_gb_neu = "<b>".$erg." neuer Gästebucheintrag</b>";}
  elseif($erg > "1"){$user_gb_neu = "<b>".$erg." neue Gästebucheinträge</b>";}

//--END USER-Guestbook MOD---
and this other code from gb.php

Code: [Select]

    <tr><td colspan=2>&nbsp;</td><td colspan=7><center><input type=submit class=button value=Absenden>&nbsp;\n
    <input type=reset class=button value=Zurücksetzen>
Absenden and Zurücksetzen    isn´t it?

part I is solved^^ it's with main.php and $lang['...'] , or not?


change

Code: [Select]

<td colspan=7><center><input type=submit class=button value=Absenden>&nbsp;\n
    <input type=reset class=button value=Zurücksetzen>

to

Code: [Select]

<td colspan=7><center><input type=submit class=button value='".$lang['submit']."'>&nbsp;\n
    <input type=reset class=button value='".$lang['reset']."'>

[ccsakuweb]

ok ^^ thanks

but... My guesstbook doesn´t show the messages... 

[ccsakuweb]

when i send a entry on the left from "Please you wait 5 seconds up to the automatic forwarding! <br> Or you klick" it shown a image danger.gif is it normaly???

and the number from logininfo isn´t right about new entrys (but profile is right)

[Stoleti]

now to be perfect its bbcode(smiles) work there

[Stoleti]

how can i added a extra-field at gb.php?

user_css !? from USERS_TABLES  , and put at user_gb.html as {user_css} ??????

[ccsakuweb]

i have installed again and it´s the same.. no messages in the guessbook ..

please.. could you help me? 

in page_header.php you have a syntax error:

Code: [Select]

if($erg == "0"){$user_gb_neu = $erg.$lang['user_gb_new'].$lang['user_gb_entry'].";}delete " in the end of the line..

please.. help me with the messages.. -.-