"2010-01-01") {
return $diffindays." ".$GLOBALS['txt']['days_ago'];
}else{
return "Ismeretlen";
}
}
function daysAgoNum($thisdate){
$datetoday=date('Y-m-d');
$differencedays=abs(strtotime($datetoday) - strtotime($thisdate));
$diffindays=floor($differencedays / (60*60*24));
return $diffindays;
}
if(isset($_GET["type"])){
echo "
";
}
}
echo "";
echo " ".$txt['polls']."";
}else{
echo "
";
echo "";
echo " ".$txt['general']." ".$txt['movies']." / ".$txt['series']." ".$txt['persons']." ".$txt['cult_characters']."";
}
if($_SESSION['role']=="admin"){
echo " ".$txt["create_new_poll"]."";
}else{
if($lng=="hun"){
$pollidea="Új Szavazás Ötlet";
}else{
$pollidea="New Idea for Poll";
}
echo " ".$pollidea."";
}
echo "
";
?>
";
if($orderby=="last"){
$orderbyactive2=" class='activeorder' ";
}else if($orderby=="pop"){
$orderbyactive3=" class='activeorder' ";
}else if($orderby=="less"){
$orderbyactive4=" class='activeorder' ";
}else{
$orderbyactive1=" class='activeorder' ";
}
echo "";
$max_num=0;
if($_SESSION['role']=="admin"){
$notConfirmedQ="";
}else{
if(strlen($typequery)<3){
$notConfirmedQ="WHERE ";
}else{
$notConfirmedQ="AND ";
}
$notConfirmedQ.=" confirmed>0";
}
$pollarray=array();
$answerarray=array();
$votearray=array();
if($orderby=="last"){
//LEGUTOBBIAK
$voteq="SELECT answer_id FROM poll_votes WHERE answer_id >0 AND answer_id IS NOT NULL ORDER BY datetime DESC ";
$eredmenybasev = mysql_query($voteq, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
while ( $sor = mysql_fetch_array($eredmenybasev)) {
if($sor["answer_id"]>0){
$votearray[]="".$sor["answer_id"]."";
}
}
//var_dump($votearray);
//echo count($votearray)."
"; $votearray=array_unique($votearray, SORT_REGULAR); for($i=0;$i0){
$answerq="SELECT poll_id FROM poll_answers WHERE id = '".$votearray[$i]."' AND poll_id >0 AND poll_id IS NOT NULL AND poll_id NOT IN (".implode(',',$pollarray).")";
}else{
$answerq="SELECT poll_id FROM poll_answers WHERE id = '".$votearray[$i]."' AND poll_id >0 AND poll_id IS NOT NULL";
}
$eredmenybasea = mysql_query($answerq, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
while ( $sor = mysql_fetch_array($eredmenybasea)) {
if($sor["poll_id"]>0){
//echo "((".$sor["poll_id"].")) ";
$pollarray[]="".$sor["poll_id"]."";
}
}
}
}else if($orderby=="pop"){
$voteq="SELECT poll_id, COUNT(DISTINCT nick) as countanswer FROM poll_votes szavazatok, poll_answers valaszok WHERE szavazatok.answer_id >0 AND szavazatok.answer_id IS NOT NULL AND valaszok.id=szavazatok.answer_id GROUP BY poll_id ORDER BY countanswer DESC ";
$eredmenybasev = mysql_query($voteq, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
while ( $sor = mysql_fetch_array($eredmenybasev)) {
if($sor["poll_id"]>0){
$pollarray[]="".$sor["poll_id"]."";
}
}
}else if($orderby=="less"){
$voteq="SELECT poll_id, COUNT(DISTINCT nick) as countanswer FROM poll_votes szavazatok, poll_answers valaszok WHERE szavazatok.answer_id >0 AND szavazatok.answer_id IS NOT NULL AND valaszok.id=szavazatok.answer_id GROUP BY poll_id ORDER BY countanswer ASC ";
$eredmenybasev = mysql_query($voteq, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
while ( $sor = mysql_fetch_array($eredmenybasev)) {
if($sor["poll_id"]>0){
$pollarray[]="".$sor["poll_id"]."";
}
}
}else{
//LEGFRISSEBB
$pollqbase="SELECT id,question,question_eng,owner,confirmed FROM polls ORDER BY datetime DESC";
$eredmenybase = mysql_query($pollqbase, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
while ( $sor = mysql_fetch_array($eredmenybase)) {
$pollarray[]=$sor["id"];
}
}
for($i=0;$i";
$tickicon="src='/pix/style/tick_g.png' class='questionTick'";
if($_SESSION['belepett']==true){
$userq="SELECT id FROM poll_votes WHERE nick='".$_SESSION['nick']."' AND answer_id IN (SELECT id FROM poll_answers WHERE poll_id='".$sor['id']."')";
$eredmeny3 = mysql_query($userq, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
if(mysql_num_rows($eredmeny3)>0){
$tickicon="src='/pix/style/tick_c.png' class='questionTickOn'";
}
}
if($_SESSION['role']=="admin" && $sor['confirmed']<1){
$tickicon="src='/pix/style/tick_g.png' class='notconfirmedTick'";
}
echo "
";
echo ""; $votearray=array_unique($votearray, SORT_REGULAR); for($i=0;$i
";
echo "![]()
";
if($lng=="hun" || strlen($sor['question_eng'])<2){
echo $sor['question'];
}else{
echo $sor['question_eng'];
}
echo "";
echo "
";
$memnumq="SELECT nick FROM poll_votes WHERE answer_id IN (SELECT id FROM poll_answers WHERE poll_id='".$sor['id']."') GROUP BY nick";
$eredmeny4 = mysql_query($memnumq, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
$votemembers=mysql_num_rows($eredmeny4);
$memnumq="SELECT MAX(datetime) FROM poll_votes WHERE answer_id IN (SELECT id FROM poll_answers WHERE poll_id='".$sor['id']."')";
$eredmeny4 = mysql_query($memnumq, $conn) or die("Nem tudtam az adatokat lekérni. A hiba oka: ".mysql_error());
while ( $sor4 = mysql_fetch_array($eredmeny4)) {
$lastvotedate=date('Y-m-d',strtotime($sor4['MAX(datetime)']));
}
$lastvotedaysago=daysAgoNum($lastvotedate);
if($lastvotedaysago==0){
$memnumclass="memberNumCat1";
}else if($lastvotedaysago==1){
$memnumclass="memberNumCat2";
}else if($lastvotedaysago==2 || $lastvotedaysago==3){
$memnumclass="memberNumCat3";
}else if($lastvotedaysago==4 || $lastvotedaysago==5 || $lastvotedaysago==6){
$memnumclass="memberNumCat4";
}else{
$memnumclass="memberNumDefault";
}
echo "";
echo "".$txt["last_time"].": ".daysAgo($lastvotedate)."' >";
echo $votemembers;
echo "
";
echo "