Gesamtansicht der Events |
fetch_array($DB->query("SELECT * FROM ".$db_tab['user']." WHERE user_name='".$USER['name']."' AND user_pw='".$USER['pass']."' AND user_status='".$USER['status']."' LIMIT 1"));
//if ($info['user_status']==$USER['status'] && $USER['id']>=0)
if ($USER['status']=='mod'|| $USER['status']=='admin')
{
echo "Admin : Alte Events löschen |";
}
echo " Neues Event eintragen ... ";
//if(($USER['status']=="user" && $status_e<="1") || ($USER['status']=="member" && $status_e<="2") || ($USER['status']=="mod" && $status_e<="3") || ($USER['status']=="admin" && $status_e<="4")) echo " Neues Event eintragen
|
";
?>
fetch_array($DB->query("SELECT * FROM guide_config"));
$status_e=$get_status['event_status_e'];
$status_b=$get_status['event_status_b'];
$status_l=$get_status['event_status_l'];
$imagepath=$get_status['event_imagepath'];
$anz=$get_status['event_anz'];
$limit=$get_status['event_eps'];
$senderanz="0";
$plzanz="0";
$einlassanz="0";
$linkanz= "0";
$event_einsender=" | Einsender | ";
$event_datum="Datum | ";
//$event_flyer="Flyer | ";
$event_titel="Titel | ";
$event_location="Location | ";
$event_stadtplz="PLZStadt | ";
$event_stadt="Stadt | ";
$event_einlass="Einlass | ";
//$event_link="Link | ";
echo "";
if ($senderanz =="1" && $plzanz=="1" && $einlassanz=="1" && $linkanz=="1") echo "$event_einsender $event_datum $event_flyer $event_titel $event_location $event_plz $event_stadtplz $event_einlass $event_link
";
elseif ($senderanz =="0" && $plzanz=="1" && $einlassanz=="1" && $linkanz=="1") echo "$event_einsender $event_datum $event_flyer $event_titel $event_location $event_plz $event_stadtplz $event_einlass $event_link
";
elseif ($senderanz =="0" && $plzanz=="0" && $einlassanz=="1" && $linkanz=="1") echo "$event_einsender $event_datum $event_flyer $event_titel $event_location $event_stadt $event_einlass $event_link
";
elseif ($senderanz =="0" && $plzanz=="0" && $einlassanz=="0" && $linkanz=="1") echo "$event_einsender $event_datum $event_flyer $event_titel $event_location $event_stadt $event_link
";
elseif ($senderanz =="0" && $plzanz=="0" && $einlassanz=="0" && $linkanz=="0") echo "$event_einsender $event_datum $event_flyer $event_titel $event_location $event_stadt $event_link
";
elseif ($senderanz =="1" && $plzanz=="1" && $einlassanz=="1" && $linkanz=="0") echo "$event_einsender $event_datum $event_flyer $event_titel $event_location $event_plz $event_stadtplz $event_einlass $event_link
";
elseif ($senderanz =="1" && $plzanz=="1" && $einlassanz=="0" && $linkanz=="0") echo "$event_einsender $event_datum $event_flyer $event_titel $event_location $event_plz $event_stadtplz $event_link
";
elseif ($senderanz =="1" && $plzanz=="0" && $einlassanz=="0" && $linkanz=="0") echo "$event_einsender $event_datum $event_flyer $event_titel $event_location $event_stadt $event_link
";
elseif ($senderanz =="1" && $plzanz=="0" && $einlassanz=="1" && $linkanz=="1") echo "$event_einsender $event_datum $event_flyer $event_titel $event_location $event_stadt $event_einlass $event_link
";
elseif ($senderanz =="1" && $plzanz=="0" && $einlassanz=="1" && $linkanz=="0") echo "$event_einsender $event_datum $event_flyer $event_titel $event_location $event_stadt $event_einlass $event_link
";
elseif ($senderanz =="0" && $plzanz=="1" && $einlassanz=="0" && $linkanz=="1") echo "$event_einsender $event_datum $event_flyer $event_titel $event_location $event_plz $event_stadtplz $event_link
";
elseif ($senderanz =="1" && $plzanz=="1" && $einlassanz=="0" && $linkanz=="1") echo "$event_einsender $event_datum $event_flyer $event_titel $event_location $event_stadtplz $event_link
";
elseif ($senderanz =="1" && $plzanz=="0" && $einlassanz=="0" && $linkanz=="1") echo "$event_einsender $event_datum $event_flyer $event_titel $event_location $event_stadt $event_link
";
elseif ($senderanz =="0" && $plzanz=="1" && $einlassanz=="1" && $linkanz=="0") echo "$event_einsender $event_datum $event_flyer $event_titel $event_location $event_plz $event_stadtplz $event_einlass $event_link
";
elseif ($senderanz =="0" && $plzanz=="0" && $einlassanz=="1" && $linkanz=="0") echo "$event_einsender $event_datum $event_flyer $event_titel $event_location $event_stadt $event_einlass $event_link
";
elseif ($senderanz =="0" && $plzanz=="1" && $einlassanz=="0" && $linkanz=="0") echo "$event_einsender $event_datum $event_flyer $event_titel $event_location $event_plz $event_stadtplz $event_link
";
elseif ($senderanz =="1" && $plzanz=="1" && $einlassanz=="1" && $linkanz=="1") echo "$event_einsender $event_datum $event_flyer $event_titel $event_location $event_plz $event_stadtplz $event_einlass $event_link
";
$weekday_array=array("Montag","Dienstag","Mittwoch","Donnerstag","Freitag","Samstag","Sonntag");
if($rep=='alle') $eventinfoinfo=$DB->query("SELECT * FROM guide_events WHERE guide_events.termin_ID='585' ORDER by guide_events. termin_YEAR ASC, guide_events.termin_MONTH ASC, guide_events.termin_DAY ASC, guide_events.termin_WEEKDAY ASC, guide_events.termin_REPEAT ASC LIMIT ".$entries.",".$limit."");
elseif($rep=='dateup') $eventinfoinfo=$DB->query("SELECT * FROM guide_events ORDER by guide_events.termin_YEAR ASC, guide_events.termin_MONTH ASC, guide_events.termin_DAY ASC, guide_events.termin_WEEKDAY ASC LIMIT ".$entries.",".$limit."");
elseif($rep=='datedw') $eventinfoinfo=$DB->query("SELECT * FROM guide_events ORDER by guide_events.termin_YEAR DESC, guide_events.termin_MONTH DESC, guide_events.termin_DAY DESC, guide_events.termin_WEEKDAY DESC LIMIT ".$entries.",".$limit."");
else if ($rep=='titelup') $eventinfoinfo=$DB->query("SELECT * FROM guide_events ORDER by guide_events.termin_TITEL ASC LIMIT ".$entries.",$limit");
else if ($rep=='titeldw') $eventinfoinfo=$DB->query("SELECT * FROM guide_events ORDER by guide_events.termin_TITEL DESC LIMIT ".$entries.",$limit");
else if ($rep=='plzup') $eventinfoinfo=$DB->query("SELECT * FROM guide_events ORDER by guide_events.termin_PLZ ASC LIMIT ".$entries.",$limit");
else if ($rep=='plzdw') $eventinfoinfo=$DB->query("SELECT * FROM guide_events ORDER by guide_events.termin_PLZ DESC LIMIT ".$entries.",$limit");
else if ($rep=='stadtup') $eventinfoinfo=$DB->query("SELECT * FROM guide_events ORDER by guide_events.termin_STADT ASC LIMIT ".$entries.",$limit");
else if ($rep=='stadtdw') $eventinfoinfo=$DB->query("SELECT * FROM guide_events ORDER by guide_events.termin_STADT DESC LIMIT ".$entries.",$limit");
else if($rep=='timeup') $eventinfoinfo=$DB->query("SELECT * FROM guide_events ORDER by guide_events.termin_BUNDES ASC LIMIT ".$entries.",$limit");
else if($rep=='timedw') $eventinfoinfo=$DB->query("SELECT * FROM guide_events ORDER by guide_events.termin_BUNDES DESC LIMIT ".$entries.",$limit");
else if($rep=='locup') $eventinfoinfo=$DB->query("SELECT * FROM guide_events ORDER by guide_events.termin_TYP ASC LIMIT ".$entries.",$limit");
else if($rep=='locdw') $eventinfoinfo=$DB->query("SELECT * FROM guide_events ORDER by guide_events.termin_TYP DESC LIMIT ".$entries.",$limit");
else if ($rep=='jährlich') $eventinfoinfo=$DB->query("SELECT * FROM guide_events WHERE guide_events.termin_REPEAT='$rep' ORDER by guide_events.termin_MONTH ASC, guide_events.termin_DAY ASC LIMIT ".$entries.",".$limit."");
else $eventinfoinfo=$DB->query("SELECT guide_events.* FROM guide_events WHERE guide_events.termin_REPEAT='$rep' ORDER by guide_events.termin_REPEAT ASC, guide_events.termin_YEAR ASC, guide_events.termin_MONTH ASC, guide_events.termin_DAY ASC, guide_events.termin_WEEKDAY ASC LIMIT ".$entries.",".$limit."");
while ($eventinfo=$DB->fetch_array($eventinfoinfo))
{
$termin_ID=$eventinfo['termin_ID'];
$termin_DAY=$eventinfo['termin_DAY'];
$termin_MONTH=$eventinfo['termin_MONTH'];
$termin_YEAR=$eventinfo['termin_YEAR'];
$termin_LOCATION=$eventinfo['termin_LOCATION'];
$termin_ORT=$eventinfo['termin_ORT'];
$termin_BUNDES=$eventinfo['termin_BUNDES'];
$termin_STADT=$eventinfo['termin_STADT'];
$termin_PLZ=$eventinfo['termin_PLZ'];
$termin_ZEIT=$eventinfo['termin_ZEIT'];
//$termin_FLYER=$eventinfo['termin_FLYER'];
$termin_TITEL=$eventinfo['termin_TITEL'];
$termin_TEXT=$eventinfo['termin_TEXT'];
$termin_LINK=$eventinfo['termin_LINK'];
$termin_REPEAT=$eventinfo['termin_REPEAT'];
$termin_WEEKDAY=$eventinfo['termin_WEEKDAY'];
$termin_USERID=$eventinfo['termin_USERID'];
//if ($termin_FLYER=="") eval ("\$flyer_pic.= \"".templateinclude("guide/events/event_all_noflyer_pic")."\";");
//else eval ("\$flyer_pic.= \"".templateinclude("guide/events/event_all_flyer_pic")."\";");
$infonick=$DB->fetch_array($DB->query("SELECT * FROM ".$db_tab['user']." WHERE user_id='$termin_USERID' LIMIT 1"));
$usernick=$infonick['user_nick'];
$userstatus=$infonick['user_status'];
$info=$DB->fetch_array($DB->query("SELECT * FROM ".$db_tab['user']." WHERE user_name='".$USER['name']."' AND user_pw='".$USER['pass']."' AND user_id='".$USER['id']."' LIMIT 1"));
if ($row == "even"){$row = "odd";}
else
{$row = "even";}
echo "";
if($termin_REPEAT=='einmalig')
{
if ($senderanz==1)
// {
if ($info['user_id']==$USER['id'] && ($USER['id']==$termin_USERID || $USER['status']=="admin" || ($USER['status']=="member" && $userstatus=="user") || ($USER['status']=="mod" && ($userstatus=="user" || $userstatus=="member"))) && (($USER['status']=="user" && $status_b<="1") || ($USER['status']=="member" && $status_b<="2") || ($USER['status']=="mod" && $status_b<="3") || ($USER['status']=="admin" && $status_b<="4"))) echo "";
else echo "";
if ($info['user_id']==$USER['id'] && ($USER['id']==$termin_USERID || $USER['status']=="admin" || ($USER['status']=="member" && $userstatus=="user") || ($USER['status']=="mod" && ($userstatus=="user" || $userstatus=="member"))) && (($USER['status']=="user" && $status_l<="1") || ($USER['status']=="member" && $status_l<="2") || ($USER['status']=="mod" && $status_l<="3") || ($USER['status']=="admin" && $status_l<="4"))) echo"";
else echo "";
// }
if ($anz==1) echo "$usernick";
echo " | ";
echo "$termin_DAY.$termin_MONTH.$termin_YEAR |
$termin_TITEL | $termin_LOCATION | ";
//DIES AN 170 ANHÄNGEN um flyer anzuzeigen $flyer_pic |
if ($plzanz==1) echo "$termin_PLZ $termin_STADT $termin_ORT | ";
else echo "$termin_STADT $termin_ORT | ";
if ($einlassanz==1) echo "$termin_ZEIT | ";
if ($linkanz==1) {
if ($termin_LINK=="") echo" |
";
else echo" | ";
}
echo "";
}
elseif($termin_REPEAT=='wöchentlich')
{
if ($senderanz==1)
//{
if ($info['user_id']==$USER['id'] && ($USER['id']==$termin_USERID || $USER['status']=="admin" || ($USER['status']=="member" && $userstatus=="user") || ($USER['status']=="mod" && ($userstatus=="user" || $userstatus=="member"))) && (($USER['status']=="user" && $status_b<="1") || ($USER['status']=="member" && $status_b<="2") || ($USER['status']=="mod" && $status_b<="3") || ($USER['status']=="admin" && $status_b<="4"))) echo "";
else echo "";
if ($info['user_id']==$USER['id'] && ($USER['id']==$termin_USERID || $USER['status']=="admin" || ($USER['status']=="member" && $userstatus=="user") || ($USER['status']=="mod" && ($userstatus=="user" || $userstatus=="member"))) && (($USER['status']=="user" && $status_l<="1") || ($USER['status']=="member" && $status_l<="2") || ($USER['status']=="mod" && $status_l<="3") || ($USER['status']=="admin" && $status_l<="4"))) echo"";
else echo "";
if ($anz==1) echo "$usernick";
echo "";
// }
echo "Jeden $weekday_array[$termin_WEEKDAY] |
$termin_TITEL | $termin_LOCATION | ";
//Dies an 204 anhängen um Flyer wieder anzuzeigen : $flyer_pic |
if ($plzanz==1) echo "$termin_PLZ $termin_STADT $termin_ORT | ";
else echo "$termin_STADT $termin_ORT | ";
if ($einlassanz==1) echo "$termin_ZEIT | ";
if ($linkanz==1) {
if ($termin_LINK=="") echo" | ";
else echo" | ";
}
}
elseif($termin_REPEAT=='monatlich')
{
if ($senderanz==1)
// {
if ($info['user_id']==$USER['id'] && ($USER['id']==$termin_USERID || $USER['status']=="admin" || ($USER['status']=="member" && $userstatus=="user") || ($USER['status']=="mod" && ($userstatus=="user" || $userstatus=="member"))) && (($USER['status']=="user" && $status_b<="1") || ($USER['status']=="member" && $status_b<="2") || ($USER['status']=="mod" && $status_b<="3") || ($USER['status']=="admin" && $status_b<="4"))) echo "";
else echo "";
if ($info['user_id']==$USER['id'] && ($USER['id']==$termin_USERID || $USER['status']=="admin" || ($USER['status']=="member" && $userstatus=="user") || ($USER['status']=="mod" && ($userstatus=="user" || $userstatus=="member"))) && (($USER['status']=="user" && $status_l<="1") || ($USER['status']=="member" && $status_l<="2") || ($USER['status']=="mod" && $status_l<="3") || ($USER['status']=="admin" && $status_l<="4"))) echo"";
else echo "";
if ($anz==1) echo "$usernick";
echo "";
// }
echo "$termin_REPEAT am $termin_DAY. |
$termin_TITEL | $termin_LOCATION | ";
//Dies an 233 anhängen um Flyer wieder anzuzeigen $flyer_pic
if ($plzanz==1) echo " | $termin_PLZ $termin_STADT $termin_ORT | ";
else echo "$termin_STADT $termin_ORT | ";
if ($einlassanz==1) echo "$termin_ZEIT | ";
if ($linkanz==1) {
if ($termin_LINK=="") echo" | ";
else echo" | ";
}
}
elseif($termin_REPEAT=='jährlich')
{
if ($senderanz==1)
// {
if ($info['user_id']==$USER['id'] && ($USER['id']==$termin_USERID || $USER['status']=="admin" || ($USER['status']=="member" && $userstatus=="user") || ($USER['status']=="mod" && ($userstatus=="user" || $userstatus=="member"))) && (($USER['status']=="user" && $status_b<="1") || ($USER['status']=="member" && $status_b<="2") || ($USER['status']=="mod" && $status_b<="3") || ($USER['status']=="admin" && $status_b<="4"))) echo "";
else echo "";
if ($info['user_id']==$USER['id'] && ($USER['id']==$termin_USERID || $USER['status']=="admin" || ($USER['status']=="member" && $userstatus=="user") || ($USER['status']=="mod" && ($userstatus=="user" || $userstatus=="member"))) && (($USER['status']=="user" && $status_l<="1") || ($USER['status']=="member" && $status_l<="2") || ($USER['status']=="mod" && $status_l<="3") || ($USER['status']=="admin" && $status_l<="4"))) echo"";
else echo "";
if ($anz==1) echo "$usernick";
echo "";
// }
echo "$termin_REPEAT am $termin_DAY.$termin_MONTH. |
$termin_TITEL | $termin_LOCATION | ";
//Dies an 263 ansetzten um flyer wieder anzuzeigen : $flyer_pic |
if ($plzanz==1) echo "$termin_PLZ $termin_STADT $termin_ORT | ";
else echo "$termin_STADT $termin_ORT | ";
if ($einlassanz==1) echo "$termin_ZEIT | ";
if ($linkanz==1) {
if ($termin_LINK=="") echo" | ";
else echo" | ";
}
}
// unset ($flyer_pic) ;
}
echo "
";
if($rep=='alle') $counter=$DB->num_rows($DB->query("SELECT * FROM guide_events"));
else if($rep=='titelup') $counter=$DB->num_rows($DB->query("SELECT * FROM guide_events"));
else if($rep=='locup') $counter=$DB->num_rows($DB->query("SELECT * FROM guide_events"));
else if($rep=='plzup') $counter=$DB->num_rows($DB->query("SELECT * FROM guide_events"));
else if($rep=='stadtup') $counter=$DB->num_rows($DB->query("SELECT * FROM guide_events"));
else if($rep=='timeup') $counter=$DB->num_rows($DB->query("SELECT * FROM guide_events"));
else if($rep=='dateup') $counter=$DB->num_rows($DB->query("SELECT * FROM guide_events"));
else if($rep=='titeldw') $counter=$DB->num_rows($DB->query("SELECT * FROM guide_events"));
else if($rep=='plzdw') $counter=$DB->num_rows($DB->query("SELECT * FROM guide_events"));
else if($rep=='locdw') $counter=$DB->num_rows($DB->query("SELECT * FROM guide_events"));
else if($rep=='stadtdw') $counter=$DB->num_rows($DB->query("SELECT * FROM guide_events"));
else if($rep=='timedw') $counter=$DB->num_rows($DB->query("SELECT * FROM guide_events"));
else if($rep=='datedw') $counter=$DB->num_rows($DB->query("SELECT * FROM guide_events"));
else $counter=$DB->num_rows($DB->query("SELECT * FROM guide_events WHERE guide_events.termin_REPEAT='$rep'"));
$content_side=sidelinkfull($counter,$limit,$entries,'include.php?path=guide/event_all.php&rep='.$rep,"headssmall");
echo "";
echo "
";
echo "";
echo " ";
echo " ";
echo " ";
echo " $content_side | ";
echo " $counter Events | ";
?>
|