<?php
/************************************************************************/
/* PHP-NUKE: Web Portal System                                          */
/* ===========================                                          */
/*                                                                      */
/* Copyright (c) 2005 by Francisco Burzi                                */
/* http://phpnuke.org                                                   */
/*                                                                      */
/* Based on Atomic Journal                                              */
/* Copyright (c) by Trevor Scott                                        */
/*                                                                      */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License.       */
/************************************************************************/
defined('MAXIMUS') or Header("Location: ../../index.php");

$module_name = "Journal";
get_lang($module_name);

$pagetitle = "- "._USERSJOURNAL."";

incoh();
include_once("modules/$module_name/functions.php");

cookiedecode($user);
$username = $cookie[1];

$jid = intval($jid);
if ($edit == 1) {
	$htime = date(h);
	$mtime = date(i);
	$ntime = date(a);
	$mtime = "$htime:$mtime $ntime";
	$mdate = date(m);
	$ddate = date(d);
	$ydate = date(Y);
	$ndate = "$mdate-$ddate-$ydate";
	$pdate = $ndate;
	$ptime = $mtime;
	$micro = microtime();
	$sql = "SELECT * FROM ".$prefix."_journal WHERE jid = '$jid'";
	$result = $db->sql_query($sql);
	while ($row = $db->sql_fetchrow($result)) {
		if ($username != $row[aid]):
		echo ("<br />");
		openTable();
		echo ("<div align=center>".NOTYOURS."</div>");
		Max_CloseTable();
		journalfoot();
		die();
		endif;
	}
	echo ("<div align=center><strong>"._UPDATEOK."</strong></div><br />");
	$sql="UPDATE `".$prefix."_journal` SET `title`='$title', `bodytext`='$bodytext', `mood`='$mood', `status`='$status', `mdate`='$ndate', `mtime`='$mtime' WHERE `jid`='$jid'";
	$db->sql_query($sql);
	$edited = "<br /><br /><center><b>"._UPDATED."</b></center>";
} else {
	$edited = "";
}

if ($debug == "true") :
echo ("UserName:$username<br />SiteName: $sitename");
endif;

startjournal($sitename,$user);

br('1');
Max_OpenTable();
echo ("<div align='center' class='title'>"._JOURNALFOR." $username</div><br />");
echo ("<div align='center'> [ <a href=\"modules.php?name=$module_name&file=add\">"._ADDENTRY."</a> | <a href=\"modules.php?name=$module_name&file=edit&disp=last\">"._YOURLAST20."</a> | <a href=\"modules.php?name=$module_name&file=edit&disp=all\">"._LISTALLENTRIES."</a> ]</div>");
echo "$edited";
Max_CloseTable();
br('1');

function list20($username,$bgcolor1,$bgcolor2,$bgcolor3) {
	global $prefix, $user_prefix, $db, $module_name;
	max_openTable();
	echo ("<div align=\"center\" class='title'>"._LAST20FOR." $username</div><br />");
	echo ("<table align='center' border='1' width=\"90%\">");
	echo ("<tr>");
	echo ("<td align='center' bgcolor='$bgcolor1' width='70'><strong><div align=\"center\">"._DATE."</div></strong></td>");
	echo ("<td align=center bgcolor=$bgcolor1 width=70><strong><div align=\"center\">"._TIME."</div></strong></td>");
	echo ("<td align=center bgcolor=$bgcolor1><strong>"._TITLE."</strong> "._CLICKTOVIEW."</td>");
	echo ("<td align=center bgcolor=$bgcolor1 width=\"5%\"><strong><div align=\"center\">"._PUBLIC."</div></strong></td>");
	echo ("<td align=center bgcolor=$bgcolor1 width=\"5%\"><strong><div align=\"center\">"._EDIT."</div></strong></td>");
	echo ("<td align=center bgcolor=$bgcolor1 width=\"5%\"><strong><div align=\"center\">"._DELETE."</div></strong></td>");
	echo ("</tr>");
	$sql = "SELECT jid, aid, title, pdate, ptime, mdate, mtime, status, mood FROM ".$prefix."_journal WHERE aid='$username' order by 'jid' DESC";
	$result = $db->sql_query($sql);
	while ($row = $db->sql_fetchrow($result)) {
		if ($dcount >= 21) :
		echo ("</tr></table>");
		Max_CloseTable();
		echo ("<br />");
		journalfoot();
		die();
		else :
		$dcount = $dcount + 1;
		print  ("<tr>");
		printf ("<td align=center bgcolor=$bgcolor2><div align=\"center\">%s</div></td>", $row[pdate]);
		printf ("<td align=center bgcolor=$bgcolor2><div align=\"center\">%s</div></td>", $row[ptime]);
		printf ("<td align=left bgcolor=$bgcolor2>&nbsp;<a href=\"modules.php?name=$module_name&file=display&jid=%s\">%s</a>", $row[jid], $row[title]);
		$sqlscnd = "SELECT cid from ".$prefix."_journal_comments where rid='$row[jid]'";
		$rstscnd = $db->sql_query($sqlscnd);
		$scndcount=0;
		while ($rowscnd = $db->sql_fetchrow($rstscnd)) {
			$scndcount = $scndcount + 1;
		}
		if ($scndcount == 1) {
			printf (" &#151&#151 $scndcount "._COMMENT."</td>");
		} else {
			printf (" &#151&#151 $scndcount "._COMMENTS."</td>");
		}
		if ($row[status] == "yes") {
			$row[status] = _YES;
		} else {
			$row[status] = _NO;
		}
		printf ("<td align=center bgcolor=$bgcolor2><div align=\"center\">%s</div></td>", $row[status]);
		printf ("<td align=center bgcolor=$bgcolor2><div align=\"center\"><a href=\"modules.php?name=$module_name&file=modify&jid=%s\"><img src='modules/$module_name/images/edit.gif' border='0' alt=\""._EDIT."\" title=\""._EDIT."\"></a></div></td>", $row[jid], $row[title]);
		printf ("<td align=center bgcolor=$bgcolor2><div align=\"center\"><a href=\"modules.php?name=$module_name&file=delete&jid=%s\"><img src='modules/$module_name/images/trash.gif' border='0' alt=\""._DELETE."\" title=\""._DELETE."\"></a></div></td>", $row[jid], $row[title]);
		print  ("</tr>");
		endif;
	}
	echo ("</table>");
	Max_CloseTable();
}

function listall($username,$bgcolor1,$bgcolor2,$bgcolor3,$sitename) {
	global $prefix, $user_prefix, $db, $module_name;
	max_openTable();
	echo ("<div align=\"center\" class=title>"._COMPLETELIST." $username</div><br />");
	echo ("<table align=center border=1 width=\"90%\">");
	echo ("<tr>");
	echo ("<td align=center bgcolor=$bgcolor1 width=70><strong><div align=\"center\">"._DATE."</div></strong></td>");
	echo ("<td align=center bgcolor=$bgcolor1 width=70><strong><div align=\"center\">"._TIME."</div></strong></td>");
	echo ("<td align=center bgcolor=$bgcolor1><strong>Title</strong></td>");
	echo ("<td align=center bgcolor=$bgcolor1 width=\"5%\"><strong><div align=\"center\">"._PUBLIC."</div></strong></td>");
	echo ("<td align=center bgcolor=$bgcolor1 width=\"5%\"><strong><div align=\"center\">"._EDIT."</div></strong></td>");
	echo ("<td align=center bgcolor=$bgcolor1 width=\"5%\"><strong><div align=\"center\">"._DELETE."</div></strong></td>");
	echo ("</tr>");
	$sql = "SELECT jid, aid, title, pdate, ptime, mdate, mtime, status, mood FROM ".$prefix."_journal WHERE aid='$username' order by 'jid' DESC";
	$result = $db->sql_query($sql);
	while ($row = $db->sql_fetchrow($result)) {
		$dcount = $dcount + 1;
		if ($row[status] == "yes"):
		$pubcount = $pubcount +1;
		$row[status] = _YES;
		else:
		$prvcount = $prvcount + 1;
		$row[status] = _NO;
		endif;
		print  ("<tr>");
		printf ("<td align=center bgcolor=$bgcolor2><div align=\"center\">%s</div></td>", $row[pdate]);
		printf ("<td align=center bgcolor=$bgcolor2><div align=\"center\">%s</div></td>", $row[ptime]);
		printf ("<td align=left bgcolor=$bgcolor2><a href=\"modules.php?name=$module_name&file=display&jid=%s\">%s</a>", $row[jid], $row[title]);
		$sqlscnd = "SELECT cid from ".$prefix."_journal_comments where rid='$row[jid]'";
		$rstscnd = $db->sql_query($sqlscnd);
		$scndcount=0;
		while ($rowscnd = $db->sql_fetchrow($rstscnd)) {
			$scndcount = $scndcount + 1;
		}
		if ($scndcount == 1) {
			printf (" &#151&#151 $scndcount "._COMMENT."</td>");
		} else {
			printf (" &#151&#151 $scndcount "._COMMENTS."</td>");
		}
		printf ("<td align=center bgcolor=$bgcolor2><div align=\"center\">%s</div></td>", $row[status]);
		printf ("<td align=center bgcolor=$bgcolor2><div align=\"center\"><a href=\"modules.php?name=$module_name&file=modify&jid=%s\"><img src='modules/$module_name/images/edit.gif' border='0' alt='"._EDIT."'></a></div></td>", $row[jid]);
		printf ("<td align=center bgcolor=$bgcolor2><div align=\"center\"><a href=\"modules.php?name=$module_name&file=delete&jid=%s\"><img src='modules/$module_name/images/trash.gif' border='0' alt='"._DELETE."'></a></div></td>", $row[jid]);
		print  ("</tr>");
	}
	echo ("</table>");
	if ($prvcount == "") {
		$prvcount = 0;
	}
	if ($pubcount == "") {
		$pubcount = 0;
	}
	if ($dcount == "") {
		$dcount = 0;
	}
	echo "<br /><div align=center>$pubcount "._PUBLICENTRIES." - "
	."$prvcount "._PRIVATEENTRIES." - "
	."$dcount "._TOTALENTRIES."</div>";
	Max_CloseTable();
}

switch($disp) {

	case "last":
	list20($username,$bgcolor1,$bgcolor2,$bgcolor3);
	break;

	case "all":
	listall($username,$bgcolor1,$bgcolor2,$bgcolor3,$sitename);
	break;

	default:
	list20($username,$bgcolor1,$bgcolor2,$bgcolor3);
	break;

}

journalfoot();