PHP Classes

File: keyprop.php

Recommend this page to a friend!
  Classes of Claudia Neu   HTTP class   keyprop.php   Download  
File: keyprop.php
Role: Example script
Content type: text/plain
Description: solution output in html
Class: HTTP class
Retrieve data from remote servers via HTTP
Author: By
Last change:
Date: 18 years ago
Size: 15,012 bytes
 

Contents

Class file image Download
<!doctype html public "-//W3C//DTD HTML 4.0 //EN"> <html> <head> <title>key properties</title> <meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0"> <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"> <link href="../common/si_admin.css" type="text/css" rel="stylesheet"> </head> <body class="si"> <form action="keyprop.php" method="post" name="getkeyproperties"> <table align="center" cellSpacing="0" cellPadding="0" width="100%" border="0" ID="Table2"> <colgroup> <col width="10%"> <col width="30%"> <col width="25%"> <col width="35%"> </colgroup> <caption class="caption"> Key properties anzeigen </caption> <tr> <td>&nbsp;</td> <td class="label"> <font class="label">&nbsp;Eingabe Key&nbsp;<br><br><input type="text" name="keyproperties" size=30 maxlength="29">&nbsp;&nbsp;<input class="button" type="submit" value="Anzeigen" name="show"> </td> <td align="left" class="label"><br> <font class="properties_normal">Keyliste:&nbsp;<font class="label">Fehler >&nbsp; <input type="text" name="bid" size="4" maxlength="5"></td><td align="left" class="label">&nbsp;&nbsp;oder Fehler genau:&nbsp;&nbsp;<input type="text" name="bidgenau" size="4" maxlength="5" values="10">&nbsp;&nbsp;<input class="button" type="submit" value="Anzeigen" name="list"> </td> </form> </tr> <?php require_once("../common/mysql.php"); require_once("../common/si_define.php"); require_once("../common/errorhandler.php"); $keyId = 0; $db = &new CMySql; $id = 0; if (isset($_GET['id'])) $id = $_GET['id']; if ($db->Connect(SI_DB_SERVER, SI_DB_LOGIN_USER, SI_DB_LOGIN_PASS)) { if ($db->SelectDatabase(SI_DATABASE)) { if ($keyproperties) { $key=$keyproperties; // auf Länge prüfen, wenn Bindestriche, dann Bindestriche rausziehen // und Abfrage nach ähnlichen Keys nach dem 1-5. Zeichen $keysplit=(substr($key,5,1)); if ($keysplit=="-") { $key=str_replace( "-", "", $key); } $strSelect = "SELECT KeyVal, Start, ExpireDate, ExpireSpan, InitDownloads, Downloads, Enabled, BIDFailed FROM ".SI_KS_KEY_TABLE." WHERE KeyVal=".$db->MakeSqlString($key); if ($result = $db->Select($strSelect)) { if ($data = $db->FetchArray($result)) { if ($data['ExpireDate'] || $data['InitDownloads'] || $data['Start'] || $data['BIDFailed'] || $data['Downloads'] || $data['Enabled']) { $key=$data['KeyVal']; $key1=substr($key,0,5); $key2=substr($key,5,5); $key3=substr($key,10,5); $key4=substr($key,15,5); $key5=substr($key,20,5); $keyges=sprintf("%05s-%05s-%05s-%05s-%05s", $key1, $key2, $key3, $key4, $key5); $dAdate=$data['Start']; $expirespan=$data['ExpireSpan']; $expiremain=$data['ExpireDate']; $dDownloads=$data['Downloads']; $gesdown=$data['InitDownloads']; $dEnabled=$data['Enabled']; $dBIDFailed=$data['BIDFailed']; echo "<table><form action=keymodify.php?id=$key&keyproperties=$keyproperties&expiremain=$expiremain&expirespan=$expirespan method=post name=andern><colgroup><col width=1%><col width=45%><col width=20%><col width=3%><col width=3%><col width=1%><col width=1%><col width=1%></colgroup><tr><br><br><td></td><td bgcolor=#C0C0C0 class=properties_normal>Aktueller Key </td><td bgcolor=#8F8F8F class=properties_normal>Beginndatum</td><td bgcolor=#C0C0C0 class=properties_normal>Ablaufdatum</td><td bgcolor=#8F8F8F class=properties_normal>Downloads gesamt</td><td bgcolor=#C0C0C0 class=properties_normal>Downloads verbleibend</td><td bgcolor=#8F8F8F class=properties_normal>Gültig</td><td bgcolor=#C0C0C0 class=properties_normal>Fehler</td></tr>"; echo "<tr><td></td><td class=properties_normal>$keyges</td><td class=properties_normal>$dAdate</td><td class=properties_normal>"; if ($data['ExpireDate']==NULL) { $data['ExpireDate']="Null"; } $dExpire=$data['ExpireDate']; echo "<input name=expire type=text class=properties_normal value=$dExpire></td><td class=properties_normal><input type=text name=gesdownloads class=properties_normal value=$gesdown></td><td class=properties_normal><input type=text name=downloads class=properties_normal value=$dDownloads></td><td class=properties_normal><input type=text name=enabled class=properties_normal value=$dEnabled></td><td class=properties_normal><input type=text name=bidfailed class=properties_normal value=$dBIDFailed></td></tr>"; echo "<tr></tr><tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td align=right><input type=submit name=mod value=modify>&nbsp;&nbsp;<input type=submit name=del value=delete></td></tr></table></form>"; } else echo "<table ><tr><td class=caption_err>Fehler in Abfrage</td></tr></table >"; } else { echo "<table><colgroup><col width=1%><col width=18%><col width=8%><col width=11%><col width=11%><col width=11%><col width=12%><col width=11%></colgroup><tr><br><br><td></td><td bgcolor=#C0C0C0 class=properties_normal>Aktueller Key </td><td bgcolor=#8F8F8F class=properties_normal>Beginndatum</td><td bgcolor=#C0C0C0 class=properties_normal>Ablaufdatum</td><td bgcolor=#8F8F8F class=properties_normal>Downloads gesamt</td><td bgcolor=#C0C0C0 class=properties_normal>Downloads verbleibend</td><td bgcolor=#8F8F8F class=properties_normal>Gültig</td><td bgcolor=#C0C0C0 class=properties_normal>Fehler</td></tr></table>"; $strSelect = "SELECT KeyVal, Start, ExpireDate, ExpireSpan, InitDownloads, Downloads, Enabled, BIDFailed FROM ".SI_KS_KEY_TABLE." WHERE KeyVal like ".$db->MakeSqlString($key."%")." order by KeyVal"; if ($result = $db->Select($strSelect)) { $anz=mysql_num_rows($result); for ($i=1;$i<=$anz;$i++) { if ($data = $db->FetchArray($result)) { if ($data['ExpireDate'] || $data['Start'] || $data['BIDFailed'] || $data['InitDownloads'] || $data['Downloads'] || $data['Enabled']) { $key=$data['KeyVal']; $key1=substr($key,0,5); $key2=substr($key,5,5); $key3=substr($key,10,5); $key4=substr($key,15,5); $key5=substr($key,20,5); $keyges=sprintf("%05s-%05s-%05s-%05s-%05s", $key1, $key2, $key3, $key4, $key5); $dAdate=$data['Start']; $expirespan=$data['ExpireSpan']; if ($data['ExpireDate']==NULL) { $data['ExpireDate']="Null"; } $dExpire=$data['ExpireDate']; $expiremain=$data['ExpireDate']; $dExpire=$data['ExpireDate']; $dDownloads=$data['Downloads']; $gesdown=$data['InitDownloads']; $dEnabled=$data['Enabled']; $dBIDFailed=$data['BIDFailed']; echo "<table><form action=keymodify.php?id=$key&keyproperties=$keyproperties&expiremain=$expiremain&expirespan=$expirespan method=post name=andern><colgroup><col width=1%><col width=24%><col width=10%><col width=10%><col width=10%><col width=10%><col width=10%><col width=10%></colgroup>"; echo "<tr><td></td><td class=properties_normal>$keyges</td><td class=properties_normal>$dAdate</td><td class=properties_normal><input name=expire type=text class=properties_normal value=$dExpire></td><td class=properties_normal><input type=text name=gesdownloads class=properties_normal value=$gesdown></td><td class=properties_normal><input type=text name=downloads class=properties_normal value=$dDownloads></td><td class=properties_normal><input type=text name=enabled class=properties_normal value=$dEnabled></td><td class=properties_normal><input type=text name=bidfailed class=properties_normal value=$dBIDFailed></td></tr>"; echo "<tr></tr><tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td align=right><input type=submit name=mod value=modify>&nbsp;&nbsp;<input type=submit name=del value=delete></td></tr></table></form>"; } else echo "<table ><tr><td class=caption_err>Fehler in Abfrage</td></tr></table >"; } } } } } // else echo "keine Eingabe"; } else if ($bid || $bidgenau) { echo "<table><colgroup><col width=1%><col width=18%><col width=8%><col width=11%><col width=11%><col width=11%><col width=12%><col width=11%></colgroup><tr><br><br><td></td><td bgcolor=#C0C0C0 class=properties_normal>Aktueller Key </td><td bgcolor=#8F8F8F class=properties_normal>Beginndatum</td><td bgcolor=#C0C0C0 class=properties_normal>Ablaufdatum</td><td bgcolor=#8F8F8F class=properties_normal>Downloads gesamt</td><td bgcolor=#C0C0C0 class=properties_normal>Downloads verbleibend</td><td bgcolor=#8F8F8F class=properties_normal>Gültig</td><td bgcolor=#C0C0C0 class=properties_normal>Fehler</td></tr>"; echo "<tr><form action=keyprop.php?id=$key&bidgenau=$bidgenau&bid=$bid method=post name=sort><td></td><td align=center><input type=submit name=sortkey value=auf>&nbsp;<input type=submit name=sortkeyab value=ab></td><td align=center><input type=submit name=sortdate value=auf>&nbsp;<input type=submit name=sortdateab value=ab></td><td align=center><input type=submit name=sortexp value=auf>&nbsp;<input type=submit name=sortexpab value=ab></td><td align=center><input type=submit name=sortgesdown value=auf>&nbsp;<input type=submit name=sortgesdownab value=ab></td><td align=center><input type=submit name=sortdown value=auf>&nbsp;<input type=submit name=sortdownab value=ab></td><td align=center><input type=submit name=sortcurr value=auf>&nbsp;<input type=submit name=sortcurrab value=ab></td><td align=center><input type=submit name=sortfehler value=auf>&nbsp;<input type=submit name=sortfehlerab value=ab></td></form></tr></table>"; if ($sortfehler) { //sortieren order by ... $sort=" order by BIDFailed"; } if ($sortcurr) { //sortieren order by ... $sort=" order by Enabled"; } if ($sortkey) { //sortieren order by ... $sort=" order by KeyVal"; } if ($sortdate) { //sortieren order by ... $sort=" order by Start"; } if ($sortexp) { //sortieren order by ... $sort=" order by ExpireDate"; } if ($sortgesdown) { //sortieren order by ... $sort=" order by InitDownloads"; } if ($sortdown) { //sortieren order by ... $sort=" order by Downloads"; } if ($sortfehlerab) { //sortieren order by ... $sort=" order by BIDFailed desc"; } if ($sortcurrab) { //sortieren order by ... $sort=" order by Enabled desc"; } if ($sortkeyab) { //sortieren order by ... $sort=" order by KeyVal desc"; } if ($sortdateab) { //sortieren order by ... $sort=" order by Start desc"; } if ($sortexpab) { //sortieren order by ... $sort=" order by ExpireDate desc"; } if ($sortgesdownab) { //sortieren order by ... $sort=" order by InitDownloads desc"; } if ($sortdownab) { //sortieren order by ... $sort=" order by Downloads desc"; } if ($bid) { if ($sortfehler || sortdown || sortgesdown || sortexp || sortkey || sortcurr || $sortfehlerab || sortdownab || sortgesdownab || sortexpab || sortkeyab || sortcurrab) { $strSelect = "SELECT KeyVal, Start, ExpireDate, ExpireSpan, InitDownloads, Downloads, Enabled, BIDFailed FROM ".SI_KS_KEY_TABLE." WHERE BIDFailed > ".$db->MakeSqlString($bid).$sort; } else $strSelect = "SELECT KeyVal, Start, ExpireDate, ExpireSpan, InitDownloads, Downloads, Enabled, BIDFailed FROM ".SI_KS_KEY_TABLE." WHERE BIDFailed > ".$db->MakeSqlString($bid)." order by KeyVal"; } if ($bidgenau) { if ($sortfehler || sortdown || sortgesdown || sortexp || sortkey || sortcurr || $sortfehlerab || sortdownab || sortgesdownab || sortexpab || sortkeyab || sortcurrab) { $strSelect = "SELECT KeyVal, Start, ExpireDate, ExpireSpan, InitDownloads, Downloads, Enabled, BIDFailed FROM ".SI_KS_KEY_TABLE." WHERE BIDFailed=".$db->MakeSqlString($bidgenau).$sort; } else $strSelect = "SELECT KeyVal, Start, ExpireDate, ExpireSpan, InitDownloads, Downloads, Enabled, BIDFailed FROM ".SI_KS_KEY_TABLE." WHERE BIDFailed=".$db->MakeSqlString($bidgenau)." order by KeyVal"; } if ($result = $db->Select($strSelect)) { $anz=mysql_num_rows($result); for ($i=1;$i<=$anz;$i++) { if ($data = $db->FetchArray($result)) { if ($data['ExpireDate'] || $data['Start'] || $data['BIDFailed'] || $data['InitDownloads'] || $data['Downloads'] || $data['Enabled']) { $key=$data['KeyVal']; $key1=substr($key,0,5); $key2=substr($key,5,5); $key3=substr($key,10,5); $key4=substr($key,15,5); $key5=substr($key,20,5); $keyges=sprintf("%05s-%05s-%05s-%05s-%05s", $key1, $key2, $key3, $key4, $key5); $dAdate=$data['Start']; $expirespan=$data['ExpireSpan']; $expiremain=$data['ExpireDate']; $dExpire=$data['ExpireDate']; $dDownloads=$data['Downloads']; $gesdown=$data['InitDownloads']; $dEnabled=$data['Enabled']; $dBIDFailed=$data['BIDFailed']; echo "<table><form action=keymodify.php?id=$key&bidgenau=$bidgenau&bid=$bid&expiremain=$expiremain&expirespan=$expirespan method=post name=andern><colgroup><col width=1%><col width=24%><col width=10%><col width=10%><col width=10%><col width=10%><col width=10%><col width=10%></colgroup>"; echo "<tr><td></td><td class=properties_normal>$keyges</td><td class=properties_normal>$dAdate</td><td class=properties_normal><input name=expire type=text class=properties_normal value=$dExpire></td><td class=properties_normal><input type=text name=gesdownloads class=properties_normal value=$gesdown></td><td class=properties_normal><input type=text name=downloads class=properties_normal value=$dDownloads></td><td class=properties_normal><input type=text name=enabled class=properties_normal value=$dEnabled></td><td class=properties_normal><input type=text name=bidfailed class=properties_normal value=$dBIDFailed></td></tr>"; echo "<tr></tr><tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td align=right><input type=submit name=mod value=modify>&nbsp;&nbsp;<input type=submit name=del value=delete></td></tr></table></form>"; } else echo "<table ><tr><td class=caption_err>Fehler in Abfrage</td></tr></table >"; } } } } } }$db->Close(); ?> </body> </html>