Skip to content

Instantly share code, notes, and snippets.

@marceljuenemann

marceljuenemann/dwz-update.php

Created April 2, 2023 13:55
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save marceljuenemann/f45df9919fc283bebbc724a9f2f4318a to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save marceljuenemann/f45df9919fc283bebbc724a9f2f4318a to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. marceljuenemann revised this gist Apr 2, 2023. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions dwz-update.php
    View file
    Original file line number Diff line number Diff line change
    @@ -1,3 +1,4 @@
    <?php
    function autodwz ( $lv, $db )
    {
    $zip = new ZipArchive;
  2. marceljuenemann renamed this gist Apr 2, 2023. 1 changed file with 0 additions and 0 deletions.
    0 gistfile1.txt → dwz-update.php
    View file
    File renamed without changes.
  3. marceljuenemann created this gist Apr 2, 2023.
    57 changes: 57 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,57 @@
    function autodwz ( $lv, $db )
    {
    $zip = new ZipArchive;

    $url = "https://dwz.svw.info/services/files/export/sql/LV-$lv-sql.zip";
    echo "Lade $lv.\r\n";
    if ( !copy ( $url, "dwz.zip" ) )
    { echo "Fehler!"; return; }

    $res = $zip->open("dwz.zip");
    if ($res === TRUE)
    {
    $sql = explode ( "\n", $zip->getFromName('vereine.sql') );
    if ( count ( $sql ) > 10 )
    {
    if ( !query ( "DELETE FROM dwz_vereine WHERE ZPS LIKE '$lv%'", $db ) )
    echo "Fehler beim Leeren!<br>";

    foreach ( $sql as $q )
    {
    if ( trim ( $q ) ) {
    if ( !query ( trim ( $q ), $db ) )
    echo "Fehler in Abfrage: ".trim($q)."<br>";
    }
    }
    }
    else
    echo "Fehler beim Öffnen!<br>";

    $sql = explode ( "\n", $zip->getFromName('spieler.sql') );
    if ( count ( $sql ) > 10 )
    {
    if ( !query ( "DELETE FROM dwz_spieler WHERE ZPS LIKE '$lv%'", $db ) )
    echo "Fehler beim Leeren!<br>";

    foreach ( $sql as $q )
    {
    if ( $q = trim ( $q ) )
    if ( !query ( $q, $db ) )
    echo "Fehler in Abfrage: ".trim($q)."<br>";
    }

    query ( "UPDATE dwz_spieler SET geschlecht='M' WHERE geschlecht is null", $db );
    }
    else
    echo "Fehler beim Öffnen!<br>";

    $zip->close ();
    }
    else
    echo "Fehler beim Öffnen!<br>";
    }

    function query ( $q, $db )
    {
    return mysql_query ( $q, $db );
    }