query( "SELECT art, id, nr, zusatz, titel, text, kategorie, unterkategorie
FROM lieder_synopse
WHERE art = '$art'
AND nr = '$nummer'
AND zusatz $zusatz" );
$row_lied = $result_lied->fetch_array();
$smarty->assign('liedanzeige_art', "$row_lied[art]");
$smarty->assign('liedanzeige_nr', "$row_lied[nr]");
$smarty->assign('liedanzeige_zusatz', "$row_lied[zusatz]");
$smarty->assign('liedanzeige_titel', "$row_lied[titel]");
$smarty->assign('liedanzeige_kategorie', "$row_lied[kategorie]");
$smarty->assign('liedanzeige_unterkategorie', "$row_lied[unterkategorie]");
$smarty->assign('liedanzeige_text', "$row_lied[text]");
$datum = date("Y-m-d", time());
$smarty->assign('liedanzeige_date', "$datum");
# Gottesdienst auslesen
if(!isset($_GET["more_gd"])){
$more_gd = 5;
setcookie("more_gd","$more_gd");
}else{
$more_gd = $_COOKIE["more_gd"]+5;
setcookie("more_gd","$more_gd");
}
$result_vorh_gd = $db->query( "SELECT count(*) Anz
FROM lieder_auffuehrung
WHERE VAID =$user_vaid
AND art = '$art'
AND Nr = '$nummer'
AND zusatz $zusatz
AND status = 'G'"
);
$row_vorh_gd = $result_vorh_gd->fetch_array();
$smarty->assign('liedanzeige_anz_gd', "$row_vorh_gd[Anz]");
$smarty->assign('liedanzeige_more_gd', "$more_gd");
$query_gd = "SELECT laid
, vaid
, DATE_Format(datum, '%d.%m.%Y')AS datum_form
, DATE_Format(datum, '%d')AS tag
, DATE_Format(datum, '%m')AS monat
, DATE_Format(datum, '%Y')AS jahr
, DATE_Format(datum, '%Y%m%d')AS datum_sort
FROM lieder_auffuehrung
WHERE VAID =$user_vaid
AND art = '$art'
AND Nr = '$nummer'
AND zusatz $zusatz
AND status = 'G'
ORDER BY datum_sort DESC
LIMIT 0,$more_gd
";
$result_gd = $db->query($query_gd);
while ($row_gd = $result_gd->fetch_array()) {
$result = $rate->getAllPost("$row_gd[laid]");
if(!empty($result)) {
$i=0;
foreach ($result as $tutorial) {
$star = "";
for($i=1;$i<=10;$i++) {
$selected = "";
if(!empty($tutorial["rating"]) && $i<=$tutorial["rating"]) {
$selected = "selected";
}
$star .= "★";
}
}
}
if($row_gd['vaid'] == $user_vaid){
$enable_del = 1;
}else{
$enable_del = 0;
}
$wochentag = date("l", mktime(0,0,0,$row_gd['monat'],$row_gd['tag'],$row_gd['jahr']));
switch($wochentag){
case 'Sunday':
$wochentag_wt = "So.";
break;
case 'Monday':
$wochentag_wt = "Mo.";
break;
case 'Tuesday':
$wochentag_wt = "Di.";
break;
case 'Wednesday':
$wochentag_wt = "Mi.";
break;
case 'Thursday':
$wochentag_wt = "Do.";
break;
case 'Friday':
$wochentag_wt = "Fr.";
break;
case 'Saturday':
$wochentag_wt = "Sa.";
break;
}
$row_gd['datum_form'] = "$wochentag_wt, ".$row_gd['datum_form'];
$row_gd['tutorial_enable_del'] = $enable_del;
$row_gd['tutorial_id'] = $tutorial["id"];
$row_gd['tutorial_rating'] = $tutorial["rating"];
$row_gd['tutorial_star'] = $star;
$value_gd[] = $row_gd;
}
$smarty->assign('table_data2', $value_gd);
# Chorproben auslesen
if(!isset($_GET["more_chor"])){
$more_chor = 5;
setcookie("more_chor","$more_chor");
}else{
$more_chor = $_COOKIE["more_chor"]+5;
setcookie("more_chor","$more_chor");
}
$result_vorh_chor = $db->query( "SELECT count(*) Anz
FROM lieder_auffuehrung
WHERE VAID =$user_vaid
AND art = '$art'
AND Nr = '$nummer'
AND zusatz $zusatz
AND status = 'C'"
);
$row_vorh_chor = $result_vorh_chor->fetch_array();
$smarty->assign('liedanzeige_anz_chor', "$row_vorh_chor[Anz]");
$smarty->assign('liedanzeige_more_chor', "$more_chor");
$query_chor = "SELECT laid
, vaid
, DATE_Format(datum, '%d.%m.%Y')AS datum_form
, DATE_Format(datum, '%d')AS tag
, DATE_Format(datum, '%m')AS monat
, DATE_Format(datum, '%Y')AS jahr
, DATE_Format(datum, '%Y%m%d')AS datum_sort
FROM lieder_auffuehrung
WHERE VAID =$user_vaid
AND art = '$art'
AND Nr = '$nummer'
AND zusatz $zusatz
AND status = 'C'
ORDER BY datum_sort DESC
";
$result_chor = $db->query($query_chor);
while ($row_chor = $result_chor->fetch_array()) {
$result = $rate->getAllPost("$row_chor[laid]");
if(!empty($result)) {
$i=0;
foreach ($result as $tutorial) {
$star = "";
for($i=1;$i<=10;$i++) {
$selected = "";
if(!empty($tutorial["rating"]) && $i<=$tutorial["rating"]) {
$selected = "selected";
}
$star .= "★";
}
}
}
if($row_chor['vaid'] == $user_vaid){
$enable_del = 1;
}else{
$enable_del = 0;
}
$wochentag = date("l", mktime(0,0,0,$row_chor['monat'],$row_chor['tag'],$row_chor['jahr']));
switch($wochentag){
case 'Sunday':
$wochentag_wt = "So.";
break;
case 'Monday':
$wochentag_wt = "Mo.";
break;
case 'Tuesday':
$wochentag_wt = "Di.";
break;
case 'Wednesday':
$wochentag_wt = "Mi.";
break;
case 'Thursday':
$wochentag_wt = "Do.";
break;
case 'Friday':
$wochentag_wt = "Fr.";
break;
case 'Saturday':
$wochentag_wt = "Sa.";
break;
}
$row_chor['datum_form'] = "$wochentag_wt, ".$row_chor['datum_form'];
$row_chor['tutorial_enable_del'] = $enable_del;
$row_chor['tutorial_id'] = $tutorial["id"];
$row_chor['tutorial_rating'] = $tutorial["rating"];
$row_chor['tutorial_star'] = $star;
$value_chor[] = $row_chor;
}
$smarty->assign('table_data', $value_chor);
}
if($action == 'gddatum'){
$datum = $_POST["datum_gd"];
$art=$_COOKIE["liedanzeige_art"];
$nummer=$_COOKIE["liedanzeige_nummer"];
$zusatz=$_COOKIE["liedanzeige_zusatz"];
if($zusatz == ''){
$zusatz1="IS NULL";
}else{
$zusatz1="= '$zusatz'";
}
$result_vorh = $db->query( "SELECT count(*) Anz
FROM lieder_auffuehrung
WHERE datum = '$datum'
AND VAID = '$user_vaid'
AND art = '$art'
AND nr = '$nummer'
AND zusatz $zusatz1
AND status = 'G'"
);
$row_vorh = $result_vorh->fetch_array();
if($row_vorh['Anz'] == 0){
if($zusatz == ''){
$zusatz2 = "NULL";
}else{
$zusatz2 = "'".$zusatz."'";
}
$result_1 = $db->query( "INSERT INTO lieder_auffuehrung (datum, VAID, art, Nr, zusatz, gemeinde, status)
VALUES ('$datum', '$user_vaid', '$art', '$nummer', $zusatz2, '0', 'G')");
}
echo "";
exit;
}
if($action == 'chordatum'){
$datum = $_POST["datum_chor"];
$art=$_COOKIE["liedanzeige_art"];
$nummer=$_COOKIE["liedanzeige_nummer"];
$zusatz=$_COOKIE["liedanzeige_zusatz"];
if($zusatz == ''){
$zusatz1="IS NULL";
}else{
$zusatz1="= '$zusatz'";
}
$result_vorh = $db->query( "SELECT count(*) Anz
FROM lieder_auffuehrung
WHERE datum = '$datum'
AND VAID = '$user_vaid'
AND art = '$art'
AND nr = '$nummer'
AND zusatz $zusatz1
AND status = 'C'"
);
$row_vorh = $result_vorh->fetch_array();
if($row_vorh['Anz'] == 0){
if($zusatz == ''){
$zusatz2 = "NULL";
}else{
$zusatz2 = "'".$zusatz."'";
}
$result_1 = $db->query( "INSERT INTO lieder_auffuehrung (datum, VAID, art, Nr, zusatz, gemeinde, status)
VALUES ('$datum', '$user_vaid', '$art', '$nummer', $zusatz2, '0', 'C')");
}
echo "";
exit;
}
if($action == 'del'){
$art=$_COOKIE["liedanzeige_art"];
$nummer=$_COOKIE["liedanzeige_nummer"];
$zusatz=$_COOKIE["liedanzeige_zusatz"];
$laid = $_GET["laid"];
# Nur die eigenen Bewertungen löschen
$result_1 = $db->query( "DELETE FROM lieder_auffuehrung WHERE laid=$laid AND vaid=$user_vaid");
echo "";
exit;
}
$smarty->assign('action', "$action");
$smarty->display("../templates/$template/lieder/$templatename");
?>