Viewing file:  listNews.inc.php3 (4.11 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
if(checkSuperSession($superSession, $REMOTE_ADDR))
{
include("include/rootGui.inc.php3");
require("$mysqlCall");
$userId = getUserSUId($superSession);
$userInfo = getUserInfo($userId);
if(($userInfo[SuperUser] == 1) && ($userInfo[manageNews]==1) && ($userInfo[active]==1))
{
$query = sqlQuery($seg, $news);
$mysql_result = mysql_query($query, $mysql_link);
$rows=countRows($news);
if($rows>0)
{
navGen($seg, $news, "index.php3?mode=listNews&superSession=$superSession");
}
while($row2 = mysql_fetch_row($mysql_result))
{
$item_ID = $row2[0];
$item_title = $row2[1];
$item_details = $row2[2];
$item_date = $row2[3];
$item_topic = $row2[4];
$userId = $row2[5];
$item_slag = $row2[6];
if($item_topic != 0)
{
require("$mysqlCall");
$query = "SELECT * FROM $topics where Id=\"$item_topic\"";
$mysql_result2 = mysql_query($query, $mysql_link);
if($row = mysql_fetch_row($mysql_result2))
{
$imageId = $row[3];
}
else
{
print("Something wrong: get image data<br>");
}
}
$userInfo = getUserInfo($userId);
print("<table width=100% border=0 cellpadding=3 cellspacing=0 >");
print("<tr><td bgcolor=$border_colour align=center>");
print("<table width=100% border=0 cellpadding=5 cellspacing=0 >");
printf("<tr>\n");
print("<td bgcolor=$table_colour2 width=100% colspan=2>\n");
print("<b>$item_date</b>\n");
print("Unio <a href=\"mailto:$userInfo[email]\" class=\"navigation\">$userInfo[user]</a>\n");
print("</td>");
print("<td rowspan=2 bgcolor=$table_colour >");
print("<form method=\"post\" action=\"index.php3?mode=delNews&superSession=$superSession&newsId=$item_ID\">");
print("<input type=submit value=Obrisi></form>");
print("<form method=\"post\" action=\"index.php3?mode=editNews&superSession=$superSession&newsId=$item_ID\">");
print("<input type=submit value=Edituj></form>");
print("</td>");
printf("</tr>\n");
printf("<tr>\n");
print("<td bgcolor=$bgcolour>\n");
print("<div align=\"justify\"><p>$item_slag\n</p></div>");
$prazno=nl2br($item_details);
print("<h1><u>$item_title</u></h1>\n");
print("<div align=\"justify\"><p>$prazno\n</p></div>");
print("</td>\n");
if($item_topic != 0)
{
print("<td bgcolor=$bgcolour align=right>\n");
print("</td>\n");
}
else
{
print("<td bgcolor=$bgcolour align=right>\n");
print("");
print("</td>\n");
}
print("</tr>\n");
print("</table>");
print("<tr><td>");
print("</table>");
print("<br><br>");
}
if($rows>0)
{
navGen($seg, $news, "index.php3?mode=listNews&superSession=$superSession");
}
else
{
print("Nema informacija");
}
}
else
{
print("You do not have access to this function");
}
include("include/guiBase.inc.php3");
}
else
{
//session is bad
print("Bad Session ID ($session)!<BR>\n");
$superSession = "";
}
?>
|