rallysystem.php

<?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>';