<?php

/************************************************************************/
/* NUKE-Auktion                                                         */
/* ===========================                                          */
/*                                                                      */
/* Copyright (c) 2003 ATrösch                                           */
/* http://www.nukemodule.de                                             */
/* http://www.webdesign-troesch.de                                      */
/* ================================                                     */
/*                                                                      */
/************************************************************************/

if (!eregi("modules.php", $PHP_SELF)) {
    die ("You can't access this file directly...");
}

$result1 = $db->sql_query("select last from ".$prefix."_auction_config");
list ($last) = $db->sql_fetchrow($result1);

if (time()-$last > 3600) {

      $result = $db->sql_query("update ".$prefix."_auction_config set last=".time());

      $result = $db->sql_query("select * from ".$prefix."_auction_items");
      while(list($cid2,$catid2,$title2,$description2,$price2,$place2,$bids2,$seller2,$buyer2,$start2,$end2,$picture2,$shipinfo2,
         $transfer2,$cash2,$card2,$bill2,$byname2,$counter2,$startprice2,$report2) = $db->sql_fetchrow($result)) {
       if (timediff($end2) == "Auktion beendet!") {
        $header  ="From: $sitename Auktion'\n";
        $header .="Content-Type: text/plain; charset=iso-8859-1\n";
        $header .="Content-Transfer-Encoding: 8bit\n";
        $subject="Auktion beendet! Artikelnummer:$cid2 Artikel:$title2";

        if ($seller2 <> "Administrator")
         $result1 = $db->sql_query("select user_email from ".$prefix."_users where username = '$seller2'");
        else
         $result1 = $db->sql_query("select email from ".$prefix."_authors where name = 'God'");
        list ($selleremail) = $db->sql_fetchrow($result1);
        if ($buyer2 <> "Administrator")
         $result1 = $db->sql_query("select user_email from ".$prefix."_users where username = '$buyer2'");
        else
         $result1 = $db->sql_query("select email from ".$prefix."_authors where name = 'God'");
        list ($buyeremail) = $db->sql_fetch_row($result1);
        if ($buyeremail = " ") {
         $emailbody  ="Auktion beendet!\n";
         $emailbody .="Es wurden keine Gebote abgegeben.\n";
         $emailbody .="Sie können den Artikel in Ihrem Account neu einstellen.";

         mail($selleremail,$subject,$emailbody,$header);
        }
        else {
         $emailbody  ="Verkäufer: $seller2\n";
         $emailbody .="Email des Verkäufers: $selleremail\n";
         $emailbody .="Preis: $price2\n";

         mail($buyeremail,$subject,$emailbody,$header);

         $emailbody  ="Käufer: $buyer2\n";
         $emailbody .="Email des Käufers: $buyeremail\n";
         $emailbody .="Preis: $price2\n";

         mail($selleremail,$subject,$emailbody,$header);
        }
       $end2=countend($end2,30);
       $result1 = $db->sql_query("insert into ".$prefix."_auction_doneitems values (NULL, '$cid2', '$catid2',
         '$titel2', '$desc2', '$startprice2', '$place2', '$bids2', '$seller2', '$buyer2', '$startdate2',
         '$enddate2', '$gfxfile2', '$shipinfo2', '$transfer2', '$cash2', '$card2', '$bill2',
         '$byname2', '$counter2', '$startprice2', '$report2')");
       $result1 = $db->sql_query("delete from ".$prefix."_auction_items where cid = '$cid2'");

       }
      }
}


$result = $db->sql_query("select cid,end from ".$prefix."_auction_doneitems");
while (list($cid2,$end2) = $db->sql_fetchrow($result)) {
 if (timediff($end2) == "Auktion beendet!")
  $result1 = $db->sql_query("delete from ".$prefix."_auction_doneitems where cid='$cid2'");

}


?>

find . -name "*.php" | xargs grep -Ei sql_fetch_row