<?php $rallys = explode('|', $_GET['rallys']); for ($i = 0; $i < count($rallys); $i++) { echo $rallys[$i] . '-Auswertung beginnt--------------------------<br>'; $rp = 0; $ralleydaten = mysqli_fetch_array(db_query("SELECT * FROM vms_rallydaten WHERE name='" . $rallys[$i] . "' LIMIT 1")); $platz = db_query("SELECT * FROM vms_rallyuser WHERE rally >= '" . $ralleydaten['name'] . "' AND ausgezahlt = '0' AND punkte >= '" . $ralleydaten['mindestpunktzhl'] . "' ORDER BY punkte DESC LIMIT " . $ralleydaten['gewinner_anzahl'] . ""); // echo "SELECT * FROM vms_rallyuser WHERE rally >= '".$ralleydaten['name']."' AND ausgezahlt = '0' AND punkte >= '".$ralleydaten['mindestpunktzhl']."' ORDER BY punkte DESC LIMIT ".$ralleydaten['gewinner_anzahl'].""; $x1 = 0; while ($pa = mysqli_fetch_array($platz)) { $x1 ++; $rp++; $buchungssumme = $ralleydaten['gewinn_topf'] / 100 * $ralleydaten['p' . $rp]; db_query("UPDATE vms_rallyuser SET auszahlungssumme = '" . $buchungssumme . "' WHERE uid='" . $pa['uid'] . "' AND ausgezahlt = '0' AND rally = '" . $ralleydaten['name'] . "' LIMIT 1"); $buchungs_id = create_code(14); kontobuchung ('+', $buchungssumme, $pa['uid']); buchungsliste ($buchungs_id, '+' . $buchungssumme, $ralleydaten['name'] . ' (Platz ' . $rp . ')', $pa['uid']); echo' Die UID ' . $pa['uid'] . ' wahr auf Platz' . $x1 . 'und hatt' . $buchungssumme . ' erhalten <br>'; } db_query("UPDATE vms_rallyuser SET ausgezahlt = '" . time() . "' WHERE rally = '" . $ralleydaten['name'] . "' AND ausgezahlt = '0'"); db_query ("DELETE FROM " . $db_prefix . "_LKT_rallyuser WHERE rally = '" . $ralleydaten['name'] . "' and ausgezahlt = '0'"); db_query ("UPDATE " . $db_prefix . "_LKT_rallydaten SET ende_punkte_aktuell='0', gewinn_topf = '" . $ralleydaten['tagpotstart'] . "' WHERE name='" . $ralleydaten['name'] . "' LIMIT 1"); } echo '<br><br>Auswertung Durch<strong></strong><br>';