user_info['user_id']; //$_SESSION["pagename"]="Caption This Pic Admin"; $_SESSION["nickname"]=$user->user_info['user_username']; $_SESSION["blocklist"]=$user->user_info['user_blocklist']; $_SESSION["invisible"]=$user->user_info['user_invisible']; $_SESSION["userphoto"]=$user->user_photo("./images/nophoto.png",true); $_SESSION["cp_useremail"]=$user->user_info['user_email']; $_SESSION["cp_userlevel"]=$user->user_info['user_level_id']; $entrysubmitted=""; $sql="SELECT `caption_this_pic`.`hcidu`, `caption_this_pic`.`hcuid`, `caption_this_pic`.`hcuname`, `caption_this_pic`.`hcemail`, `caption_this_pic`.`hcimgurl`, `caption_this_pic`.`hcimgwdth`, `caption_this_pic`.`hcimgheight`, `caption_this_pic`.`hccomtotal`, `caption_this_pic`.`hcimagename`, `caption_this_pic`.`thedate`, `caption_this_pic`.`ctpactive`, `caption_this_pic`.`badurl`, `caption_this_pic`.`hctrash`, `caption_this_pic`.`hc_path`, `caption_this_pic`.`hc_name`, `caption_this_pic`.`hc_ext`, `caption_this_pic`.`blogid`, `caption_this_pic`.`ctpused` FROM `caption_this_pic` ORDER BY `caption_this_pic`.`hcidu` ASC"; $result=$database->database_query($sql) or $em=$em.$database->database_error(); $entries=""; while ($row = $database->database_fetch_assoc($result)) { $fullimg=$row["hc_path"]."/".$row["hc_name"]."_full.".$row["hc_ext"]."?id=".$row["hcidu"]; $thumbimg=$row["hc_path"]."/".$row["hc_name"]."_thumbnail.".$row["hc_ext"]; $origimg=$row["hc_path"]."/".$row["hc_name"].".".$row["hc_ext"]."?id=".$row["hcidu"]; if($row["ctpactive"] == "yes" || $user->user_info['user_id'] == "21092" || $user->user_info['user_id'] == "8" || $user->user_info['user_id'] == "9") { $entries .=' '; } if($row["hcuid"]==$user->user_info['user_id']) { $entrysubmitted=$row["ctpactive"]; } } $smarty->assign('esub',$entrysubmitted); $smarty->assign('thetitle',"Halloween Contest"); $smarty->assign('entries',$entries); $smarty->assign('em',$em); include "footer.php"; ?>