Location: PHPKode > projects > IntraMessenger > public/shoutbox_message.php
<?php 	
/*******************************************************
 **                  IntraMessenger - server          **
 **                                                   **
 **  Copyright:      (C) 2006 - 2011 THeUDS           **
 **  Web:            http://www.theuds.com            **
 **                  http://www.intramessenger.net    **
 **  Licence :       GPL (GNU Public License)         **
 **  http://opensource.org/licenses/gpl-license.php   **
 *******************************************************/

/*******************************************************
 **       This file is part of IntraMessenger-server  **
 **                                                   **
 **  IntraMessenger is a free software.               **
 **  IntraMessenger is distributed in the hope that   **
 **  it will be useful, but WITHOUT ANY WARRANTY.     **
 *******************************************************/
//
//
require ("../common/display_errors.inc.php"); 
//
if (isset($_GET['lang'])) $lang = $_GET['lang']; else $lang = "";
if (isset($_GET['i'])) $id = $_GET['i']; else $id = 0;
if (isset($_GET['c'])) $check = $_GET['c']; else $check = "";
//
define('INTRAMESSENGER',true);
require ("../common/styles/style.css.inc.php");
require ("../common/config/config.inc.php");
require ("lang.inc.php");
require ("../common/menu.inc.php"); // apr├Ęs config.inc.php !
echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">';
echo "<html><head>";
echo "<title>[IM] " . $l_admin_options_shoutbox_title_short . "</title>";
display_header();
//
$id_shout = intval(f_decode64_wd($id));
if ( $check <> md5(md5($id) . md5($id_shout)) )  $id_shout = 0;
if ( (_SHOUTBOX == "") or (_SHOUTBOX_PUBLIC == "") or ($id_shout <= 0) ) // not allowed to display...
{
  echo '<META http-equiv="refresh" content="0;url=../"> ';
  die();
}
echo "</head>";
//echo "<body background='" . _FOLDER_IMAGES . f_background_image_color() . "background.jpg'>";
echo "<body>";
require ("../common/sql.inc.php");
//
echo "<font face=verdana size=2>";
//echo "<CENTER>";
//
$requete  = " select ID_USER_AUT, SBX_TIME, SBX_DATE, SBX_RATING, SBX_TEXT";
$requete .= " FROM " . $PREFIX_IM_TABLE . "SBX_SHOUTBOX ";
$requete .= " WHERE SBX_DISPLAY > 0 ";
//$requete .= " and ID_GROUP_DEST = 0 ";
$requete .= " and ID_SHOUT = " . $id_shout;
$requete .= " limit 1 ";
$result = mysql_query($requete);
if (!$result) error_sql_log("[ERR-V1c]", $requete);
$nb_row = mysql_num_rows($result);
if ( $nb_row > 0 )
{
  while( list ($id_aut, $s_time, $s_date, $rating, $txt) = mysql_fetch_row ($result) )
	{
    $s_date = date($l_date_format_display, strtotime($s_date));
    $s_time = date($l_time_short_format_display, strtotime($s_time));
    //$username = f_get_username_of_id($id_aut);
    $username = f_get_username_nickname_of_id($id_aut); // affichage avec majuscules et espaces
    //
    //if ( $s_date != date($l_date_format_display) )      echo "<font color='gray'>";
    //echo "&nbsp;" . $s_date . " - " . $s_time . "&nbsp;";
    //
    echo "<font size='3'><B>";
    echo f_decode64_wd($txt) . "</B>";
    echo "</font><BR/>";
    //
    echo "<font color='gray'>";
    if ( $s_date != date($l_date_format_display) ) echo $s_date . " - ";
    echo $s_time;
    echo "&nbsp;" . $username . " &nbsp;";
    echo "</font>";
    //
    echo "&nbsp; &nbsp; &nbsp; ";
    if (intval($rating) > 0) 
    {
      echo "<IMG SRC='" . _FOLDER_IMAGES . "flag-green.png' WIDTH='16' HEIGHT='16' ALT='+" . $rating . "' TITLE='+" . $rating . "'>";
      echo "<font color='green'>&nbsp;+" . $rating . "</font>";
    }
    if (intval($rating) < 0) 
    {
      echo "<IMG SRC='" . _FOLDER_IMAGES . "flag-red.png' WIDTH='16' HEIGHT='16' ALT='" . $rating . "' TITLE='" . $rating . "'>";
      echo "<font color='red'>&nbsp;" . $rating . "</font>";
    }
	}
}
//else
  //echo $l_admin_shoutbox_empty;
echo "\n";
//
mysql_close($id_connect);
//
//
echo "</body></html>";
Return current item: IntraMessenger