View file components/extras.php

<?php
if(!defined('DRK'))die('Hacking attempt...');

$uid=IdFromSes($ses);

function countlinks()
{
return num_rows("id",extras,"type='L'");
}

function user_can_vote()
{
global $uid;
if(num_rows("id",vote,"type='U' AND text=$uid")>0)return false;
else return true;
}

function vote_active()
{
if(num_rows("id",vote,"(type=1 OR type=2 OR type=3 OR type=4 OR type=5 OR type=6 OR type=7 OR type=8 OR type=9 OR type=10) AND text!=''")>0)return true;
else return false;
}

/////VOTE/////
if($act=="vote")
{
if($mode=="vote"&&user_can_vote()&&vote_active()){
$vid=get_var("vid");
if(empty($vid))$vid=0;
if($vid>0&&$vid<=10){
insert(vote,"NULL,'U',$uid,0");
update(vote,"votes=votes+1","type=$vid");
}
Location("act=vote");
}
else{
if(!user_can_vote()){
$title=fetch_array("text",vote,"type='T'");
$question=fetch_array("text",vote,"type='Q'")."<br/>";
$votes=fetch_array("SUM(votes)",vote,"type>=1 AND type<=10 AND text!=''");
$rr=0;
for($rr=1;$rr<=10;$rr++){
$rx=fetch_array("text",vote,"type='$rr'");
if(!empty($rx)){
$getvotes=fetch_array("votes",vote,"type='$rr'");
$percent=0;
if($votes>0)$percent=substr(($getvotes*100)/$votes,0,4);
$r.="$rx $percent%<br/>\n";
}
}
if(CanEditExtras($uid))$votelink="<a href=\"".$action."admin".$mod."editvote".$session."\">edit vote</a><br/>";
$what=Array("sitename","username","title","votes","question","r","votelink");
$with=Array($sitename,users_table("username",IdFromSes($ses)),$title,$votes,$question,$r,$votelink);
Template($what,$with,"showvote");
exit;
}
else{
$title=fetch_array("text",vote,"type='T'");
$question=fetch_array("text",vote,"type='Q'")."<br/>";
$rr=0;
$r.="<br/>\n";
for($rr=1;$rr<=10;$rr++){
$rx=fetch_array("text",vote,"type='$rr'");
if(!empty($rx))$r.="<a href=\"".$action."vote".$mod."vote&amp;vid=$rr".$session."\">$rx</a><br/>\n";
}
if(CanEditExtras($uid))$votelink="-&gt; <a href=\"".$action."admin".$mod."editvote".$session."\">edit vote</a><br/>";
}
}  
}

/////LINKS/////
else if($act=="links")
{
$page=get_var("page");
if(empty($page))$page=1;
$query=query("*",extras,"type='L' ORDER BY id LIMIT ".($page-1)*$linksperpage.",$linksperpage");
if(mysql_num_rows($query)>0){
while($row=mysql_fetch_array($query)){
if(!empty($row[text]))$title="<img src=\"/phpThumb/phpThumb.php?src=$row[text]&amp;w=128&amp;f=png\" height=\"30\" width=\"100\" alt=\"$row[comment]\"/>";
else $title=$row['comment'];
if(CanEditExtras($uid))$linkslist.="<a href=\"$row[link]\">$title</a>\n[<a href=\"".$action."admin".$mod."editlinks&amp;id=$row[id]".$session."\">edit</a>] \n[<a href=\"".$action."admin".$mod."editlinks&amp;delete=1&amp;id=$row[id]".$session."\">delete</a>]<br/>\n";
else $linkslist.="<a href=\"$row[link]\">$title</a><br/>\n";
}
}
else $linkslist.="<img src=\"./images/point.gif\" alt=\"[!]\"/><small>no links at the moment!!</small><br/>";
if(CanEditExtras($uid))$addlink="-&gt; <a href=\"".$action."admin".$mod."editlinks".$session."\">create link</a><br/>";
if($page>1)$controls.="<a href=\"".$action."links&amp;page=".($page-1).$session."\">&lt;- prev</a>";
if($page>1&&countlinks()>$page*$linksperpage)$controls.="\n | ";
if(countlinks()>$page*$linksperpage)$controls.="<a href=\"".$action."links&amp;page=".($page+1).$session."\">next -&gt;</a>";
if($page>1||countlinks()>$page*$linksperpage)$controls.="<br/>";
}

/////EXTRAS/////
$time=time();
$onlineusers=num_rows("id",users,"$time-lastseen<=$offlinetime");
$adminonline=num_rows("id",users,"$time-lastseen<=$offlinetime AND admin='Y'");
$admins=num_rows("id",users,"admin='Y'");
if(num_rows("id",chapel,"uid='$uid' AND accepted='N'")>0)$chapelrequest="<img src=\"./images/point.gif\" alt=\"[!]\"/>";

?>