Revision 1 | Blame | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed
<?session_start();require_once "../connect2.php";require_once "system/loadSettings.php";loadSettings( $webs[datenbank] );define( "modul_name", "online_shop" );define( "tool_name", "eBay" );function shutdown(){?><script language="JavaScript">window.close();</script><?exit;}if ( $_GET[edit] ){$query = "select * from eBay_Auktionen where ID = " . $_GET[edit];$result = mysql_query( $query ) or die( mysql_errno() . ": " .mysql_error() . "<hr>" . $query . "<hr>" );$editCount = mysql_num_rows( $result );$_SESSION[eBay][editor] = mysql_fetch_assoc( $result );$_SESSION[eBay][editor][GalleryImg] = $_SESSION[eBay][editor][Gallery];}if ( $_GET[edit] ){ // editif ( ( isset( $user_rechte[modul_name][tool_name][editWaitingAuction] ) ) and( $editCount > 0 ) ){}else{shutdown();}}else{if ( !isset( $user_rechte[modul_name][tool_name][addAuction] ) ){shutdown();}}$steps = array( "Was", "Was genau", "Wie", "Wann" );foreach ( array_keys( $_POST ) as $key ){$_SESSION[eBay][editor][$key] = stripslashes( $_POST[$key] );}if ( $_REQUEST[template] ){$Artikel = $_SESSION[eBay][Artikel];eval( "\$buffer=\"" . addslashes( $_SESSION[eBay][settings][Description][$_REQUEST[template_NR]] ) ."\";" );$_SESSION[eBay][editor][Description] = $buffer;}if ( $_GET[artikel_ID] ){unset( $_SESSION[eBay][editor] );$_SESSION[eBay][editor] = array( "ListingStartTime" => $_SESSION[eBay][settings][ListingStartTime],"Duration" => $_SESSION[eBay][settings][Duration] );// Daten des Artikel aus der Tabelle "artikel" laden$query = "SELECTFather,preis1,preis1 as MinimumBid,preis1+" . $_SESSION[eBay][settings][BuyItNowPriceAddon][0] ." as BuyItNowPrice,kurzbezeichnung as Title,langbezeichnung as kurzbeschreibung,beschreibung as Description,'" . $_SESSION[eBay][settings][GalleryURLpfad][0] ."' AS bild_pfad_1,'" . $_SESSION[eBay][settings][GalleryURLpfad_big][0] ."' AS bild_pfad_big_1," . $_SESSION[eBay][settings][GalleryURLfeld][0] ." AS bild_url_1,";if ( $_SESSION[eBay][settings][GalleryURLfeld][1] ){$query .= "'" . $_SESSION[eBay][settings][GalleryURLpfad][1] ."' AS bild_pfad_2," . $_SESSION[eBay][settings][GalleryURLfeld][1] ." AS bild_url_2,'" . $_SESSION[eBay][settings][GalleryURLpfad_big][1] ."' AS bild_pfad_big_2,";}if ( $_SESSION[eBay][settings][GalleryURLfeld][2] ){$query .= "'" . $_SESSION[eBay][settings][GalleryURLpfad][2] ."' AS bild_pfad_3," . $_SESSION[eBay][settings][GalleryURLfeld][2] ." AS bild_url_3,'" . $_SESSION[eBay][settings][GalleryURLpfad][2] ."' AS bild_pfad_big_3,";}if ( $_SESSION[eBay][settings][GalleryURLfeld][3] ){$query .= "'" . $_SESSION[eBay][settings][GalleryURLpfad][3] ."' AS bild_pfad_4," . $_SESSION[eBay][settings][GalleryURLfeld][3] ." AS bild_url_4,'" . $_SESSION[eBay][settings][GalleryURLpfad_big][3] ."' AS bild_pfad_big_4,";}$query .= "1 as QuantityFROMartikelWHEREID = " . $_GET[artikel_ID] . "ANDLanguage='DE'";$result = mysql_query( $query ) or die( mysql_errno() . ": " .mysql_error() . "<hr>" . $query . "<hr>" );if ( $zeile = mysql_fetch_assoc( $result ) ){$zeile["Description"] = nl2br( $zeile["Description"] );for ( $i = 1; $i <= 4; $i++ ){if ( $zeile["bild_url_$i"] ){$key1 = "bild$i";$key2 = "mouseover$i";$img_kl = $zeile["bild_pfad_$i"] . $zeile["bild_url_$i"];$img_gr = $zeile["bild_pfad_big_$i"] . $zeile["bild_url_$i"];$img = '<img src=' . $img_gr . '>';$img = htmlentities( $img );$ol = "return overlib('" . $img . "',CAPTION,'" . $zeile["Title"] ."');";$_SESSION[eBay][editor][$key1] = $img_kl;$_SESSION[eBay][editor][$key2] = $ol;unset( $zeile["bild_url_$i"], $zeile["bild_pfad_$i"] );}}foreach ( array_keys( $zeile ) as $key ){$_SESSION[eBay][editor][$key] = $zeile[$key];}$Artikel = $_SESSION[eBay][editor];$_SESSION[eBay][Artikel] = $Artikel;//var_dump($_SESSION[eBay][settings][Description]);eval( "\$buffer=\"" . addslashes( $_SESSION[eBay][settings][Description][0] ) ."\";" );$_SESSION[eBay][editor][Description] = $buffer;}// Daten eines Schwesterartikel aus der vorherigen Auktionen$query = "SELECT DISTINCTeBay_Auktionen.MinimumBid,eBay_Auktionen.Category,eBay_Auktionen.ListingStartTime,eBay_Auktionen.Duration,eBay_Auktionen.PrivateFROMartikel,eBay_AuktionenWHEREartikel.Father = " . $_SESSION[eBay][editor][Father] . "ANDeBay_Auktionen.artikel_ID = artikel.IDORDER BYeBay_Auktionen.IDLIMIT 1";$result = mysql_query( $query ) or die( mysql_errno() . ": " .mysql_error() . "<hr>" . $query . "<hr>" );if ( $sibling = mysql_fetch_assoc( $result ) ){foreach ( array_keys( $sibling ) as $key ){$_SESSION[eBay][editor][$key] = $sibling[$key];}}// Daten des Artikel aus der vorherigen Auktionen laden$query = "select * from eBay_Auktionen where artikel_ID = " . $_GET[artikel_ID] ." order by ID desc";$result = mysql_query( $query ) or die( mysql_errno() . ": " .mysql_error() . "<hr>" . $query . "<hr>" );if ( $previous = mysql_fetch_assoc( $result ) ){foreach ( array_keys( $previous ) as $key ){$_SESSION[eBay][editor][$key] = $previous[$key];}}$_SESSION[eBay][editor][ListingStartDay] = date( "Y-m-d" );unset( $_SESSION[eBay][editor][eBay_Id] );unset( $_SESSION[eBay][editor][eBay_error] );}if ( $_POST[step] == $steps[count( $steps ) - 1] ){foreach ( array( "preis1", "step", "PHPSESSID", "Father","_Category", "_Category2", "ID", "edit", "bild", "GalleryImg","template_NR" ) as $elem ){unset( $_SESSION[eBay][editor][$elem] );}if ( $_POST[edit] ){$_SESSION[eBay][editor][ID] = $_POST[edit];$_SESSION[eBay][editor][eBay_error] = '';}$_SESSION[eBay][editor][Description] = addslashes( $_SESSION[eBay][editor][Description] );$dataKeys = implode( ", ", array_keys( $_SESSION[eBay][editor] ) );$dataValues = "'" . implode( "', '", $_SESSION[eBay][editor] ) . "'";$query = "replace into eBay_Auktionen ($dataKeys) values ($dataValues)";$result = mysql_query( $query ) or die( mysql_errno() . ": " .mysql_error() . "<hr>" . $query . "<hr>" );unset( $_SESSION[eBay][editor] );?><script language="JavaScript">opener.location.reload();</script><script language="JavaScript">window.close();</script><?}function getCatName( $ID ){if ( $ID ){$query ="select CategoryName from eBay.Categories where CategoryId = $ID order by CategoryName";$result = mysql_query( $query ) or die( mysql_errno() . ": " .mysql_error() . "<hr>$query<hr>" );$Category = mysql_fetch_assoc( $result );return $Category[CategoryName];}else{return "Kategorie wählen";}}?><html><head><title>Online-Shop Ebay-Interface</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css"><!--td { font-family: Arial, Helvetica, sans-serif; font-size: 14px}.bold { font-family: Arial, Helvetica, sans-serif; font-size: 14px; font-weight: bold}.small { font-family: Arial, Helvetica, sans-serif; font-size: 9px}.catButton { width: 2in}--></style><script type="text/javascript">_editor_url = "../../htmlarea/";_editor_lang = "de";</script><script type="text/javascript" src="../../htmlarea/htmlarea.js"></script><script language="JavaScript" src="../../checkDate.js"></script><script language="JavaScript">function AuktionOnly(form){if ((form.MinimumBid.value > 0) && (form.Quantity.value > 1)){if (confirm('Bei einer Auktion kann immer nur EIN Artikel versteigert werden!\nSoll die Menge auf \"1\" zurückgesetzt gesetzt werden?')){form.Quantity.value=1;}else{alert('Menge wird nicht zurückgesetzt!\nAuktion nicht möglich!');form.MinimumBid.value='';}}}function SofortKaufOnly(form){if ((form.MinimumBid.value > 0) && (form.Quantity.value > 1)){if (confirm('Bei einer Auktion kann immer nur EIN Artikel versteigert werden!\nSoll das Mindestgebot entfernt werden?')){form.MinimumBid.value='';}else{alert('Mindestgebot wird nicht zurückgesetzt!\nMenge wird auf \"1\" zurückgesetzt!');form.Quantity.value=1;}}}function browseCategories(source){eval("addon=document.eBay."+source+".value;");if (addon){addon="?ID="+addon;}window.open("browseCategories.php"+addon,source,"width=850,height=350,scrollbars=yes,resizable=yes");}function triggerObject(obj, stat){with (obj.style){if (stat){display="";}else{display="none";}}}function killkomma(w){return w.replace(/,/,'.');}window.moveTo(0,0);</script></head><body><form name="eBay" method="post" action="<?= $self ?>"><?if ( $_GET[artikel_ID] ){?><input type="hidden" name="artikel_ID" value="<?= $_GET[artikel_ID]; ?>"><?}?><table width="100%" height="100%" border=0 cellspacing="0" cellpadding="0"><tr><td><?if ( !$_REQUEST[step] ){$step = $steps[0];}else{$step = $steps[array_search( $step, $steps ) + 1];}foreach ( $steps as $current_step ){if ( $step == $current_step ){$class = "bold";}else{$class = "";}echo "<span class=" . $class . ">" . $current_step . "</span> ";}?>? </td><td align="right"><?if ( $step == $steps[1] ){?>Template:<select name="template_NR"><?for ( $i = 0; $i < count( $_SESSION[eBay][settings][Description] );$i++ ){?><option value="<?= $i; ?>"><?= $i + 1; ?></option><?}?></select><inputtype="submit"name="template"value="anwenden"onclick="this.form.step.value='<?= $steps[array_search( $step, $steps ) -1]; ?>';"><?}?></td></tr><tr><td colspan="2"><hr noshade></td></tr><tr><td valign="top" width="100%" colspan="2" height="100%"><table border=0 width="100%" cellpadding="0" cellspacing="0"><?switch ( $step ){case "Wie":?><tr><td width="32%" valign="top" rowspan="2">Auktion:<br><span class="small">(Verkauf zum Höchstgebot)</span></td><td width="4%" nowrap><input name="MinimumBid" type="text" size="5" value="<?= $_SESSION[eBay][editor][MinimumBid]; ?>" onBlur="this.value=killkomma(this.value);AuktionOnly(this.form);">€ </td><td colspan="2" nowrap>Mindestgebot</td></tr><tr><td width="4%"> </td><td colspan="2"><span class="small">Aktueller Shop-Preis:<?= $_SESSION[eBay][editor][preis1]; ?></span></td></tr><tr><td width="32%">SofortKauf:<br><span class="small">(Verkauf zum Festpreis)</span></td><td colspan="3"><input name="BuyItNowPrice" type="text" size="5" value="<?= $_SESSION[eBay][editor][BuyItNowPrice]; ?>" onChange="this.value=killkomma(this.value);">€ </td></tr><tr><td width="32%">Menge:<br><span class="small">(bei Auktionen immer 1)</span> </td><td colspan="3"><input name="Quantity" type="text" size="5" value="<?= $_SESSION[eBay][editor][Quantity]; ?>" onBlur="SofortKaufOnly(this.form)">Stück</td></tr><tr><td colspan="4"> </td></tr><tr><td width="32%">Privatauktion:</td><td colspan="3"><input type="hidden" name="Private" value=""><input type="checkbox" name="Private" value="1" <? if ( $_SESSION[eBay][editor]['Private'] ){echo " checked";} ?>></td></tr><tr><td colspan="4"> </td></tr><tr><td width="32%">Galeriebild:</td><td width="8%" colspan="2"><input type="hidden" name="Gallery" value=""><input type="checkbox" id="GallerySwitch" name="Gallery" value="<?= $_SESSION[eBay][editor][GalleryImg]; ?>" <? if ( $_SESSION[eBay][editor][Gallery] ){ ?> checked="checked"<? } ?> onclick="triggerObject(document.getElementById('GalleryView'),this.checked)"></td><td align="center" rowspan="7" width="60%"> <img id="GalleryView" src="<?= $_SESSION[eBay][editor][GalleryImg]; ?>"><script language="Javascript">triggerObject(document.getElementById('GalleryView'),document.getElementById('GallerySwitch').checked)</script></td></tr><tr><td width="32%" nowrap>Top-Angebot in Kategorie und Suche:</td><td width="8%" colspan="2"><input type="hidden" name="Featured" value=""><input type="checkbox" name="Featured" value="1" <? if ( $_SESSION[eBay][editor][Featured] ){echo " checked";} ?>></td></tr><tr><td width="32%">Fettschrift:</td><td width="8%" colspan="2"><input type="hidden" name="BoldTitle" value=""><input type="checkbox" name="BoldTitle" value="1" <? if ( $_SESSION[eBay][editor][BoldTitle] ){echo " checked";} ?>></td></tr><tr><td width="32%">Highlight:</td><td width="8%" colspan="2"><input type="hidden" name="HighLight" value=""><input type="checkbox" name="HighLight" value="1" <? if ( $_SESSION[eBay][editor][HighLight] ){echo " checked";} ?>></td></tr><tr><td width="32%"> </td><td width="8%" colspan="2"> </td></tr><tr><td width="32%">Versand:</td><td width="8%" colspan="2"><select name="VersandCarrier" onChange="document.eBay.VersandCost.value=this.options[this.selectedIndex].preis;document.eBay.VersandID.value=this.options[this.selectedIndex].VersandID;"><option VersandID="" preis=""></option><?$query = "select*fromartikelwhereFather=-3andstatus = " . $_SESSION[eBay][editor][confDatei];$result = mysql_query( $query ) or die( mysql_errno() . ": " .mysql_error() . "<hr>$query<hr>" );while ( $zeile = mysql_fetch_assoc( $result ) ){?><option value="<?= $zeile[kennung]; ?>" VersandID="<?= $zeile[ID]; ?>" preis="<?= $zeile[preis1]; ?>" <? if ( $zeile[kennung] ==$_SESSION[eBay][editor][VersandCarrier] ){echo " selected";} ?>><?= $zeile[kurzbezeichnung]; ?></option><?}?></select></td></tr><tr><td width="32%">Versandkosten:</td><td width="8%" colspan="2"><input type="text" name="VersandCost" size="5" value="<?= $_SESSION[eBay][editor][VersandCost]; ?>" onChange="this.value=killkomma(this.value);"><input type="hidden" name="VersandID" size="5" value="<?= $_SESSION[eBay][editor][VersandID]; ?>"><script language="JavaScript">document.eBay.VersandID.value=document.eBay.VersandCarrier.options[document.eBay.VersandCarrier.selectedIndex].VersandID;//alert(document.eBay.VersandCarrier.options[document.eBay.VersandCarrier.selectedIndex].VersandID);</script></td></tr><?break;case "Was":?><tr><td width="32%">Artikel:</td><td colspan="3"><input name="Title" type="text" value="<?= $_SESSION[eBay][editor][Title]; ?>" maxlength="55"></td></tr><tr><td width="32%">Untertitel:<br><span class="small">(kostenpflichtig!)</span></td><td colspan="3"><input name="SubtitleText" type="text" value="<?= $_SESSION[eBay][editor][SubtitleText]; ?>" maxlength="55"></td></tr><tr><td width="32%">Kategorie:</td><td colspan="3"><input type="text" name="Category" value="<?= $_SESSION[eBay][editor][Category]; ?>" size="4"><input type="button" name="_Category" value="<?= getCatName( $_SESSION[eBay][editor][Category] ); ?>" onclick="browseCategories('Category')" class="catButton"></td></tr><tr><td width="32%">Kategorie2:<br><span class="small"><span class="small">(kostenpflichtig!)</span></span></td><td colspan="3"><input type="text" name="Category2" value="<?= $_SESSION[eBay][editor][Category2]; ?>" size="4"><input type="button" name="_Category2" value="<?= getCatName( $_SESSION[eBay][editor][Category2] ); ?>" onclick="browseCategories('Category2')" class="catButton"></td></tr><tr><td valign="top" class="border" colspan="4"> </td></tr><tr><td valign="top" class="border">User / conf-Datei:</td><td colspan="3" valign="top" class="border"><select name="confDatei"><?$query = "selecteBay_settings.Name,eBay_settings.Inhalt,shops.name as shop_namefromeBay_settings,shopswhereTyp = 'confDatei'andeBay_settings.Name=shops.ID";$result = mysql_query( $query ) or die( mysql_errno() . ": " .mysql_error() . "<hr>$query<hr>" );while ( $zeile = mysql_fetch_assoc( $result ) ){?><option value="<?= $zeile[Name]; ?>"<? if ( $zeile[Name] ==$_SESSION[eBay][editor][confDatei] ){echo " selected";} ?>><?= $zeile[shop_name]; ?></option><?}?></select></td></tr><?break;case "Was genau":?><tr><td colspan="4" valign="top" class="border"><textarea id="Description" name="Description" cols="110" rows="35"><?= $_SESSION[eBay][editor][Description]; ?></textarea><!-- Einbindung TinyMCE --><script type="text/javascript" src="/js/jquery-1.6.4.min.js"></script><script type="text/javascript" src="../../tiny_mce/tiny_mce.js"></script><script type="text/javascript">tinyMCE.init({// General optionsmode : "exact",elements: "Description",theme : "advanced",language: "de",inline_styles : true,cleanup : false,plugins : "safari,spellchecker,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,imagemanager,filemanager",// Theme optionstheme_advanced_buttons1 : "bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull",theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,preview,|,forecolor,backcolor",theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,ltr,rtl,|,fullscreen",theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,spellchecker,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,blockquote,pagebreak,|,insertfile,insertimage",theme_advanced_toolbar_location : "top",theme_advanced_toolbar_align : "left",theme_advanced_statusbar_location : "bottom",theme_advanced_resizing : true,// Example content CSS (should be your site CSS)content_css : "css/example.css",// Drop lists for link/image/media/template dialogstemplate_external_list_url : "js/template_list.js",external_link_list_url : "js/link_list.js",external_image_list_url : "js/image_list.js",media_external_list_url : "js/media_list.js",// Replace values for the template plugintemplate_replace_values : {username : "Some User",staffid : "991234"}});</script></td></tr><?break;case "Wann":?><tr><td width="32%">Start:</td><td colspan="3"><input name="ListingStartDay" type="text" size="10" value="<?= $_SESSION[eBay][editor][ListingStartDay]; ?>" onFocus="if (this.value=='') {this.value=now('')};this.select();"><input name="ListingStartTime" type="text" size="5" value="<?= $_SESSION[eBay][editor][ListingStartTime]; ?>" onFocus="if (this.value=='') {this.value='19:00';};this.select();"></td></tr><tr><td width="32%">Dauer:</td><td colspan=3><select name="Duration"><option value="1"<? if ( $_SESSION[eBay][editor][Duration] ==1 ){ ?> selected<? } ?>>1 Tag</option><option value="3"<? if ( $_SESSION[eBay][editor][Duration] ==3 ){ ?> selected<? } ?>>3 Tage</option><option value="5"<? if ( $_SESSION[eBay][editor][Duration] ==5 ){ ?> selected<? } ?>>5 Tage</option><option value="7"<? if ( $_SESSION[eBay][editor][Duration] ==7 ){ ?> selected<? } ?>>7 Tage</option><option value="10"<? if ( $_SESSION[eBay][editor][Duration] ==10 ){ ?> selected<? } ?>>10 Tage</option></select></td></tr><?break;}?></table></td></tr><tr><td colspan="2" align="center"><hr noshade><input type="submit" value="< Zurück" onclick="this.form.step.value='<?= $steps[array_search( $step,$steps ) - 2]; ?>';"><input type="reset" value="Zurücksetzen"><input type="submit" value="Weiter >"><input type="hidden" name="step" value="<?= $step; ?>"><?if ( $_REQUEST[edit] ){?><input type="hidden" name="edit" value="<?= $_REQUEST[edit]; ?>"><?}?></td></tr></table></form></body></html>