<?php
// ----------------------------------------------------------------------
// GeBlog - Weblogging system
// Copyright (C) 2003 by the GeBlog Development Team.
// https://sourceforge.net/projects/geblog/
// ----------------------------------------------------------------------
// LICENSE
//
// This program is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License (GPL)
// as published by the Free Software Foundation; either version 2
// of the License, or (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// To read the license please visit http://www.gnu.org/copyleft/gpl.html
// ----------------------------------------------------------------------
// Original Author of file: Jay Talbot
// Purpose of file: To house the user display and database functions for
//                  the "About Me" module.
// ----------------------------------------------------------------------

if (eregi("func.php", $_SERVER['PHP_SELF']))
{
    die ("You can't access this file directly...");
}

function GetAboutInfo()
{
    extract($GLOBALS);
    $conn->Connect($dbserver,$dbuser,$dbpass,$dbname);
    $sql = "SELECT id,DATE_FORMAT(updated, '%m/%d/%Y %l:%i%p'),name,place,fav_foods,fave_movies,bio FROM about_me";
    $rs = &$conn->Execute($sql);
    $about['id'] = $rs->fields[0];
    $about['updated'] = $rs->fields[1];
    $about['aname'] = $rs->fields[2];
    $about['res'] = $rs->fields[3];
    $about['foods'] = $rs->fields[4];
    $about['movies'] = $rs->fields[5];
    $about['bio'] = $rs->fields[6];
    FormatAboutMe($about);
    //echo $format;
}

function FormatAboutMe($about)
{
    extract($GLOBALS);
    extract($about);

    echo "<FONT FACE=\"ARIAL\">";
    echo "<table cellpadding=\"2\" cellspacing=\"2\" border=\"0\" width=\"80%\">\n";
    echo "<tr>\n";
    echo "<td valign=\"top\"><b>My Name:</b> ".$aname."\n";
    echo "</td>\n";
    echo "<td valign=\"top\"><b>Last Updated:</b> ".$updated."\n";
    echo "</td>\n";
    echo "</tr>\n";
    echo "<tr>\n";
    echo "<td valign=\"top\" rowspan=\"1\" colspan=\"2\"><b>I Live In:</b> ".$res."\n";
    echo "</td>\n";
    echo "</tr>\n";
    echo "<tr>\n";
    echo "<td valign=\"top\" rowspan=\"1\" colspan=\"2\"><b>My Favorite Foods Are:</b>\n";
    echo "</td>\n";
    echo "</tr>\n";
    echo "<tr>\n";
    echo "<tr>\n";
    echo "<td valign=\"top\" rowspan=\"1\" colspan=\"2\">".$foods."\n";
    echo "</td>\n";
    echo "</tr>\n";
    echo "<td valign=\"top\" rowspan=\"1\" colspan=\"2\"><b>My Favorite Movies Are:</b>\n";
    echo "</td>\n";
    echo "</tr>\n";
    echo "<tr>\n";
    echo "<td valign=\"top\" rowspan=\"1\" colspan=\"2\">".$movies."\n";
    echo "</td>\n";
    echo "</tr>\n";
    echo "<tr>\n";
    echo "<td valign=\"top\" rowspan=\"1\" colspan=\"2\"><b>My Bio:</b>";
    echo "</td>\n";
    echo "</tr>\n";
    echo "<tr>\n";
    echo "<td valign=\"top\" rowspan=\"1\" colspan=\"2\">".$bio."\n";
    echo "</td>\n";
    echo "</tr>\n";
    echo "</table>\n";
    echo "</FONT>";
    //echo $format;
}
?>