Senior Mitglied
Beiträge: 341
Registriert am: 23.09.14
In folgender Datei fülle ich einzelne Formularfelder mittels Dropdown das sich die Werte aus einer anderen DB Tabelle holt. Das kalppt auch. Beim editieren jedoch werden nicht die aktuell gespeicherten Werte aus der DB sondern andere (falsche) angezeigt.
Was ist da falsch bzw was habe ich übersehen?
Beispiel: die CAT (also figure_cat ) wird ordenungsgemass als Dropdown angezeigt und bei Aufruf wo ich den Datensatz wieder editieren kann wird der richtige Wert ebenfalls wieder angezeigt. Das ist aber nur bei den CATS so . Cei allen anderen Feldern die ich via Dropdown füllen lasse bekomme ich nicht die aktuell gepeicherten Werte die in der Datenbank stehen angezeigt und ich weiss nicht warum. Irgendwo habe ich einen Aktualisierung vergessen bzw übersehen.
Kann jemand helfen?
Hier das ganze file
Code <?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2011 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: figure_items.php
| Author: Khalid545
| URL: http://khalidb.co.cc/
| E-Mail: khalidd545@gmail.com
|
| Modification: Catzenjaeger
| URL: www.aliencollectors.com
| E-Mail: admin@aliencollectors.com
|
| Original file: downloads.php By Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "../../../maincore.php";
require_once THEMES."templates/admin_header.php";
require_once INCLUDES."bbcode_include.php";
include "../infusion_db.php";
$asettings['figure_photo_max_b'] = 4500000;
$asettings['figure_photo_max_w'] = 3840; //3.840 x 2.160 = 4K Auflösung
$asettings['figure_photo_max_h'] = 2160;
if (!checkrights("BOL") || !defined("iAUTH") || $_GET['aid'] != iAUTH) { redirect(BASEDIR."index.php"); }
if (isset($_GET['status']) && !isset($message)) {
if ($_GET['status'] == "sn") {
$message = $locale['figure_110'];
} elseif ($_GET['status'] == "su") {
$message = $locale['figure_111'];
} elseif ($_GET['status'] == "se") {
$message = $locale['figure_113']."<br />\n<span class='small'>";
if ($_GET['error'] == 0) { $message .= $locale['figure_117']."</span>"; }
elseif ($_GET['error'] == 1) { $message .= $locale['figure_114']."</span>"; }
elseif ($_GET['error'] == 2) { $message .= sprintf($locale['figure_115'], parsebytesize($asettings['figure_max_b']))."</span>"; }
elseif ($_GET['error'] == 3) { $message .= sprintf($locale['figure_116'], str_replace(',', ' ', $asettings['figure_types']))."</span>"; }
elseif ($_GET['error'] == 4) { $message .= $locale['figure_118']."</span>"; }
elseif ($_GET['error'] == 5) { $message .= $locale['figure_170']."</span>";}
elseif ($_GET['error'] == 6) { $message .= sprintf($locale['figure_171'], parsebytesize($asettings['figure_photo_max_b']))."</span>";}
elseif ($_GET['error'] == 7) { $message .= $locale['figure_172']."</span>";}
elseif ($_GET['error'] == 8) { $message .= sprintf($locale['figure_173'], $asettings['figure_photo_max_w'], $asettings['figure_photo_max_h'])."</span>";}
} elseif ($_GET['status'] == "del") {
$message = $locale['figure_112'];
}
if ($message) { echo "<div id='close-message'><div class='admin-message'>".$message."</div></div>\n"; }
}
$result = dbquery("SELECT * FROM ".DB_FIGURE_CATS);
if (dbrows($result)) {
if ((isset($_GET['action']) && $_GET['action'] == "delete") && (isset($_GET['figure_id']) && isnum($_GET['figure_id']))) {
$result = dbquery("SELECT figure_file, figure_cat FROM ".DB_FIGURE." WHERE figure_id='".$_GET['figure_id']."'");
if (dbrows($result)) {
$data = dbarray($result);
if (!empty($data['figure_file']) && file_exists(FIGURES.$data['figure_file'])) {
@unlink(FIGURES.$data['figure_file']);
}
if (!empty($data['figure_image']) && file_exists(IMAGES_FIGURE.$data['figure_image'])) {
@unlink(IMAGES_FIGURE.$data['figure_image']);
}
$result = dbquery("DELETE FROM ".DB_FIGURE." WHERE figure_id='".$_GET['figure_id']."'");
$result = dbquery("UPDATE ".DB_FIGURE_CATS." SET figure_cat_items=figure_cat_items-1 WHERE figure_cat_id='".$data['figure_cat']."'");
$result = dbquery("DELETE FROM ".DB_COMMENTS." WHERE comment_item_id='".$_POST['figure_id']."' and comment_type='BO'");
$result = dbquery("DELETE FROM ".DB_RATINGS." WHERE rating_item_id='".$_POST['news_id']."' and rating_type='B'");
}
redirect(FUSION_SELF.$aidlink."&figure_cat_id=".intval($_GET['figure_cat_id'])."&status=del");
} elseif (isset($_POST['save_download'])) {
$valid_ext = explode(",", $asettings['figure_types']);
$error = 0;
$figure_title = stripinput($_POST['figure_title']);
//NEU ANFANG
//$figure_submanufacturer = stripinput($_POST['figure_submanufacturer']);
$figure_brand = stripinput($_POST['figure_brand']);
$figure_series = stripinput($_POST['figure_series']);
$figure_variant = stripinput($_POST['figure_variant']);
$figure_scale = stripinput($_POST['figure_scale']);
$figure_weight = stripinput($_POST['figure_weight']);
$figure_height = stripinput($_POST['figure_height']);
$figure_width = stripinput($_POST['figure_width']);
$figure_depth = stripinput($_POST['figure_depth']);
$figure_material = stripinput($_POST['figure_material']);
$figure_poa = stripinput($_POST['figure_poa']);
//$figure_tpoa = stripinput($_POST['figure_tpoa']);
$figure_packaging = stripinput($_POST['figure_packaging']);
$figure_retailprice = stripinput($_POST['figure_retailprice']);
$figure_usedprice = stripinput($_POST['figure_usedprice']);
$figure_limitation = stripinput($_POST['figure_limitation']);
$figure_editionsize = stripinput($_POST['figure_editionsize']);
$figure_artists = stripinput($_POST['figure_artists']);
//NEU ENDE
//$figure_author = stripinput($_POST['figure_author']);
$figure_country = stripinput($_POST['figure_country']);
$figure_manufacturer = stripinput($_POST['figure_manufacturer']);
$figure_pubdate = stripinput($_POST['figure_pubdate']);
//NEU
$figure_accessories = trim(stripinput($_POST['figure_accessories']));
$figure_description = trim(stripinput($_POST['figure_description']));
//NEU ENDE
//$figure_filesize = stripinput($_POST['figure_filesize']);
$figure_filesize = 1;
if (isset($_POST['del_upload']) && isset($_GET['figure_id']) && isnum($_GET['figure_id'])) {
$result = dbquery("SELECT figure_file FROM ".DB_FIGURE." WHERE figure_id='".$_GET['figure_id']."'");
if (dbrows($result)) {
$data = dbarray($result);
if (!empty($data['figure_file']) && file_exists(FIGURES.$data['figure_file'])) {
@unlink(FIGURES.$data['figure_file']);
}
}
$figure_file = "";
} elseif (!empty($_FILES['figure_file']['name']) && is_uploaded_file($_FILES['figure_file']['tmp_name'])) {
$figure_url = "";
$file = $_FILES['figure_file'];
$file_name = str_replace(" ", "_", strtolower(substr($file['name'], 0, strrpos($file['name'], "."))));
$file_ext = strtolower(strrchr($file['name'],"."));
$target_folder = FIGURES;
if (!preg_match("/^[-0-9A-Z_\.\[\]]+$/i", $file_name)) {
// Invalid file name
$error = 1;
} elseif ($file['size'] > $asettings['figure_max_b']){
// Invalid file size
$error = 2;
} elseif (!in_array($file_ext, $valid_ext)) {
// Invalid file extension
$error = 3;
} else {
if (file_exists($target_folder.$file_name.$file_ext)) {
$i = 1; $file_name_2 = $file_name;
while (file_exists($target_folder.$file_name_2.$file_ext)) {
$file_name_2 = $file_name."_".$i;
$i++;
}
$file_name = $file_name_2;
}
move_uploaded_file($file['tmp_name'], $target_folder.$file_name.$file_ext);
chmod($target_folder.$file_name.$file_ext, 0644);
$figure_file = $file_name.$file_ext;
if (isset($_POST['calc_upload'])) {
$figure_filesize = parsebytesize($file['size']);
}
}
} elseif ((isset($_POST['figure_url']) && $_POST['figure_url'] != "") || isset($_POST['figure_file'])) {
$figure_url = (isset($_POST['figure_url']) ? stripinput($_POST['figure_url']) : "");
$figure_file = (isset($_POST['figure_file']) ? $_POST['figure_file'] : "");
} else {
$error = 4;
}
if (isset($_FILES['figure_image']) && is_uploaded_file($_FILES['figure_image']['tmp_name'])) {
require_once INCLUDES."photo_functions_include.php";
$image = $_FILES['figure_image'];
$image_name = str_replace(" ", "_", strtolower(substr($image['name'], 0, strrpos($image['name'], "."))));
$image_ext = strtolower(strrchr($image['name'],"."));
if ($image_ext == ".gif") { $filetype = 1;
} elseif ($image_ext == ".jpg") { $filetype = 2;
} elseif ($image_ext == ".png") { $filetype = 3;
} else { $filetype = false; }
if (!preg_match("/^[-0-9A-Z_\.\[\]]+$/i", $image_name)) {
$error = 5;
} elseif ($image['size'] > $asettings['figure_photo_max_b']){
$error = 6;
} elseif (!$filetype) {
$error = 7;
} else {
$image_full = image_exists(IMAGES_FIGURE, $image_name.$image_ext);
move_uploaded_file($_FILES['figure_image']['tmp_name'], IMAGES_FIGURE.$image_full);
if (function_exists("chmod")) { chmod(IMAGES_FIGURE.$image_full, 0644); }
$imagefile = @getimagesize(IMAGES_FIGURE.$image_full);
if ($imagefile[0] > $asettings['figure_photo_max_w'] || $imagefile[1] > $asettings['figure_photo_max_h']) {
$error = 8;
unlink(IMAGES_FIGURE.$image_full);
} else {
createthumbnail($filetype, IMAGES_FIGURE.$image_full, IMAGES_FIGURE.$image_full, 3840, 2160);
}
}
if (!$error) {
$figure_image = $image_full;
} else {
$figure_image = "";
}
} else {
$figure_image = (isset($_POST['figure_image']) ? $_POST['figure_image'] : "");
}
$figure_cat = intval($_POST['figure_cat']);
$figure_comments = isset($_POST['figure_comments']) ? "1" : "0";
$figure_ratings = isset($_POST['figure_ratings']) ? "1" : "0";
if ($figure_title && $error == 0) {
if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_GET['figure_id']) && isnum($_GET['figure_id']))) {
if (isset($_POST['del_image'])) {
if (!empty($data['figure_image']) && file_exists(IMAGES_FIGURE.$data['figure_image'])) { unlink(IMAGES_FIGURE.$data['figure_image']); }
$figure_image = "";
}
$figure_datestamp = isset($_POST['update_datestamp']) ? ", figure_datestamp='".time()."'" : "";
$result = dbquery("SELECT figure_cat FROM ".DB_FIGURE." WHERE figure_id='".$_GET['figure_id']."'");
if (dbrows($result)) {
$data = dbarray($result);
if ($data['figure_cat']!=$figure_cat) {
$result = dbquery("UPDATE ".DB_FIGURE_CATS." SET figure_cat_items=figure_cat_items-1 WHERE figure_cat_id='".$data['figure_cat']."'");
$result = dbquery("UPDATE ".DB_FIGURE_CATS." SET figure_cat_items=figure_cat_items+1 WHERE figure_cat_id='".$figure_cat."'");
}
}
/*
//ÄNDERUNG
$result = dbquery("UPDATE ".DB_FIGURE." SET figure_title='$figure_title', figure_submanufacturer='$figure_submanufacturer', figure_brand='$figure_brand', figure_series='$figure_series', figure_variant='$figure_variant', figure_scale='$figure_scale', figure_weight='$figure_weight', figure_height='$figure_height', figure_width='$figure_width', figure_depth='$figure_depth', figure_material='$figure_material', figure_poa='$figure_poa', figure_tpoa='$figure_tpoa', figure_packaging='$figure_packaging', figure_retailprice='$figure_retailprice', figure_usedprice='$figure_usedprice', figure_limitation='$figure_limitation', figure_editionsize='$figure_editionsize', figure_artists='$figure_artists', figure_country='$figure_country', figure_manufacturer='$figure_manufacturer', figure_pubdate='$figure_pubdate', figure_image='$figure_image', figure_accessories='$figure_accessories', figure_description='$figure_description', figure_url='$figure_url', figure_file='$figure_file', figure_cat='$figure_cat', figure_allow_comments='$figure_comments', figure_allow_ratings='$figure_ratings', figure_filesize='$figure_filesize'".$figure_datestamp." WHERE figure_id='".$_GET['figure_id']."'");
//ÄNDERUNG ENDE
redirect(FUSION_SELF.$aidlink."&figure_cat_id=".$figure_cat."&status=su");
} else {
//ÄNDERUNG
$result = dbquery("INSERT INTO ".DB_FIGURE." (figure_title, figure_submanufacturer, figure_brand, figure_series, figure_variant, figure_scale, figure_weight, figure_height, figure_width, figure_depth, figure_material, figure_poa, figure_tpoa, figure_packaging, figure_retailprice, figure_usedprice, figure_limitation, figure_editionsize, figure_artists, figure_country, figure_manufacturer, figure_pubdate, figure_image, figure_accessories, figure_description, figure_url, figure_file, figure_cat, figure_name, figure_filesize, figure_datestamp, figure_count, figure_allow_comments, figure_allow_ratings) VALUES ('$figure_title', '$figure_submanufacturer', '$figure_brand', '$figure_series', '$figure_variant', '$figure_scale', '$figure_weight', '$figure_height', '$figure_width', '$figure_depth', '$figure_material', '$figure_poa', '$figure_tpoa', '$figure_packaging', '$figure_retailprice', '$figure_usedprice', '$figure_limitation', '$figure_editionsize', '$figure_artists', '$figure_country', '$figure_manufacturer', '$figure_pubdate', '$figure_image', '$figure_accessories', '$figure_description', '$figure_url', '$figure_file', '$figure_cat', '".$userdata['user_id']."', '$figure_filesize', '".time()."', '0', '$figure_comments', '$figure_ratings')");
//ÄNDERUNG ENDE
*/
//ÄNDERUNG
$result = dbquery("UPDATE ".DB_FIGURE." SET figure_title='$figure_title', figure_brand='$figure_brand', figure_series='$figure_series', figure_variant='$figure_variant', figure_scale='$figure_scale', figure_weight='$figure_weight', figure_height='$figure_height', figure_width='$figure_width', figure_depth='$figure_depth', figure_material='$figure_material', figure_poa='$figure_poa', figure_packaging='$figure_packaging', figure_retailprice='$figure_retailprice', figure_usedprice='$figure_usedprice', figure_limitation='$figure_limitation', figure_editionsize='$figure_editionsize', figure_artists='$figure_artists', figure_country='$figure_country', figure_manufacturer='$figure_manufacturer', figure_pubdate='$figure_pubdate', figure_image='$figure_image', figure_accessories='$figure_accessories', figure_description='$figure_description', figure_url='$figure_url', figure_file='$figure_file', figure_cat='$figure_cat', figure_allow_comments='$figure_comments', figure_allow_ratings='$figure_ratings', figure_filesize='$figure_filesize'".$figure_datestamp." WHERE figure_id='".$_GET['figure_id']."'");
//ÄNDERUNG ENDE
redirect(FUSION_SELF.$aidlink."&figure_cat_id=".$figure_cat."&status=su");
} else {
//ÄNDERUNG
$result = dbquery("INSERT INTO ".DB_FIGURE." (figure_title, figure_brand, figure_series, figure_variant, figure_scale, figure_weight, figure_height, figure_width, figure_depth, figure_material, figure_poa, figure_packaging, figure_retailprice, figure_usedprice, figure_limitation, figure_editionsize, figure_artists, figure_country, figure_manufacturer, figure_pubdate, figure_image, figure_accessories, figure_description, figure_url, figure_file, figure_cat, figure_name, figure_filesize, figure_datestamp, figure_count, figure_allow_comments, figure_allow_ratings) VALUES ('$figure_title', '$figure_brand', '$figure_series', '$figure_variant', '$figure_scale', '$figure_weight', '$figure_height', '$figure_width', '$figure_depth', '$figure_material', '$figure_poa', ' $figure_packaging', '$figure_retailprice', '$figure_usedprice', '$figure_limitation', '$figure_editionsize', '$figure_artists', '$figure_country', '$figure_manufacturer', '$figure_pubdate', '$figure_image', '$figure_accessories', '$figure_description', '$figure_url', '$figure_file', '$figure_cat', '".$userdata['user_id']."', '$figure_filesize', '".time()."', '0', '$figure_comments', '$figure_ratings')");
//ÄNDERUNG ENDE
$result = dbquery("UPDATE ".DB_FIGURE_CATS." SET figure_cat_items=figure_cat_items+1 WHERE figure_cat_id='".$figure_cat."'");
redirect(FUSION_SELF.$aidlink."&figure_cat_id=".$figure_cat."&status=sn");
}
} else {
redirect(FUSION_SELF.$aidlink."&status=se&error=$error");
}
}
if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_GET['figure_id']) && isnum($_GET['figure_id']))) {
$result = dbquery("SELECT * FROM ".DB_FIGURE." WHERE figure_id='".$_GET['figure_id']."'");
if (dbrows($result)) {
$data = dbarray($result);
$figure_title = $data['figure_title'];
//NEU ANFANG
//$figure_submanufacturer = $data['figure_submanufacturer'];
$figure_brand = $data['figure_brand'];
$figure_series = $data['figure_series'];
$figure_variant = $data['figure_variant'];
$figure_scale = $data['figure_scale'];
$figure_weight = $data['figure_weight'];
$figure_height = $data['figure_height'];
$figure_width = $data['figure_width'];
$figure_depth = $data['figure_depth'];
$figure_material = $data['figure_material'];
$figure_packaging = $data['figure_packaging'];
$figure_poa = $data['figure_poa'];
//$figure_tpoa = $data['figure_tpoa'];
$figure_retailprice = $data['figure_retailprice'];
$figure_usedprice = $data['figure_usedprice'];
$figure_limitation = $data['figure_limitation'];
$figure_editionsize = $data['figure_editionsize'];
$figure_artists = $data['figure_artists'];
//NEU ENDE
//$figure_author = $data['figure_author'];
$figure_country = $data['figure_country'];
$figure_manufacturer = $data['figure_manufacturer'];
$figure_pubdate = $data['figure_pubdate'];
$figure_image = $data['figure_image'];
//NEU
$figure_accessories = stripinput($data['figure_accessories']);
//NEU ENDE
$figure_description = stripinput($data['figure_description']);
$figure_url = $data['figure_url'];
$figure_file = $data['figure_file'];
$figure_filesize = $data['figure_filesize'];
$figure_comments = $data['figure_allow_comments'] == "1" ? " checked='checked'" : "";
$figure_ratings = $data['figure_allow_ratings'] == "1" ? " checked='checked'" : "";
$formaction = FUSION_SELF.$aidlink."&action=edit&figure_cat_id=".$data['figure_cat']."&figure_id=".$data['figure_id'];
opentable($locale['figure_101']);
} else {
redirect(FUSION_SELF.$aidlink);
}
} else {
$figure_title = "";
//ANFANG
//$figure_submanufacturer = "";
$figure_brand = "";
$figure_series = "";
$figure_variant = "";
$figure_scale = "";
$figure_weight = "";
$figure_height = "";
$figure_width = "";
$figure_depth = "";
$figure_material = "";
$figure_packaging = "";
$figure_poa = "";
//$figure_tpoa = "";
$figure_retailprice = "";
$figure_usedprice = "";
$figure_limitation = "";
$figure_editionsize = "";
$figure_artists = "";
//ENDE
//$figure_author = "";
$figure_country = "";
$figure_manufacturer = "";
$figure_pubdate = "";
$figure_image = "";
//NEU
$figure_accessories = "";
//ENDE
$figure_description = "";
$figure_url = "";
$figure_file = "";
$figure_comments = " checked='checked'";
$figure_ratings = " checked='checked'";
$figure_filesize = "";
$formaction = FUSION_SELF.$aidlink;
opentable($locale['figure_100']);
}
//CAT
$editlistcat = "";
if (isset($_GET['action']) && $_GET['action'] == "edit") { $figure_cat = $data['figure_cat']; } else { $figure_cat = ""; }
$resultcat = dbquery("SELECT * FROM ".DB_FIGURE_CATS." WHERE figure_cat_parent='0' ORDER BY figure_cat_name");
if (dbrows($resultcat) != 0) {
while ($datacat = dbarray($resultcat)) {
$editlistcat .= menu_subcats($datacat['figure_cat_id'], $datacat['figure_cat_name'],1);
}
}
//Scale (locale 442)
$editlistscale = "";
if (isset($_GET['action']) && $_GET['action'] == "edit") { $figure_scale = $data['figure_scale']; } else { $figure_scale = ""; }
$resultscale = dbquery("SELECT * FROM ".DB_FIGURE_SCALES." WHERE figure_scale_parent='0' ORDER BY figure_scale_name");
if (dbrows($resultscale) != 0) {
while ($datascale = dbarray($resultscale)) {
$editlistscale .= menu_subcats($datascale['figure_scale_id'], $datascale['figure_scale_name'],1);
}
}
//MANUFACTURER 417
$editlistmanufacturer = "";
if (isset($_GET['action']) && $_GET['action'] == "edit") { $figure_manufacturer = $data['figure_manufacturer']; } else { $figure_manufacturer = ""; }
$resultmanufacturer = dbquery("SELECT * FROM ".DB_FIGURE_MANUFACTURERS." WHERE figure_manufacturer_parent='0' ORDER BY figure_manufacturer_name");
if (dbrows($resultmanufacturer) != 0) {
while ($datamanufacturer = dbarray($resultmanufacturer)) {
$editlistmanufacturer .= menu_subcats($datamanufacturer['figure_manufacturer_id'], $datamanufacturer['figure_manufacturer_name'],1);
}
}
//Material (locale 447)
$editlistmaterial = "";
if (isset($_GET['action']) && $_GET['action'] == "edit") { $figure_material = $data['figure_material']; } else { $figure_material = ""; }
$resultmaterial = dbquery("SELECT * FROM ".DB_FIGURE_MATERIALS." WHERE figure_material_parent='0' ORDER BY figure_material_name");
if (dbrows($resultmaterial) != 0) {
while ($datamaterial = dbarray($resultmaterial)) {
$editlistmaterial .= menu_subcats($datamaterial['figure_material_id'], $datamaterial['figure_material_name'],1);
}
}
//BRAND 438
$editlistbrand = "";
if (isset($_GET['action']) && $_GET['action'] == "edit") { $figure_brand = $data['figure_brand']; } else { $figure_brand = ""; }
$resultbrand = dbquery("SELECT * FROM ".DB_FIGURE_BRANDS." WHERE figure_brand_parent='0' ORDER BY figure_brand_name");
if (dbrows($resultbrand) != 0) {
while ($databrand = dbarray($resultbrand)) {
$editlistbrand .= menu_subcats($databrand['figure_brand_id'], $databrand['figure_brand_name'],1);
}
}
//POINT OF ARTICULATION (455)
$editlistpoa = "";
if (isset($_GET['action']) && $_GET['action'] == "edit") { $figure_poa = $data['figure_poa']; } else { $figure_poa = ""; }
$resultpoa = dbquery("SELECT * FROM ".DB_FIGURE_POAS." WHERE figure_poa_parent='0' ORDER BY figure_poa_name");
if (dbrows($resultpoa) != 0) {
while ($datapoa = dbarray($resultpoa)) {
$editlistpoa .= menu_subcats($datapoa['figure_poa_id'], $datapoa['figure_poa_name'],1);
}
}
/*
//TYP POINT OF ARTICULATION (458)
$editlisttpoa = ""; if (isset($_GET['action']) && $_GET['action'] == "edit") { $figure_tpoa = $data['figure_tpoa']; } else { $figure_tpoa = ""; }
$resulttpoa = dbquery("SELECT * FROM ".DB_FIGURE_TPOAS." WHERE figure_tpoa_parent='0' ORDER BY figure_tpoa_name");
if (dbrows($resulttpoa) != 0) {
while ($datatpoa = dbarray($resulttpoa)) {
$editlisttpoa .= menu_subcats($datatpoa['figure_tpoa_id'], $datatpoa['figure_tpoa_name'],1);
}
}
*/
//Packaging (locale 448)
$editlistpackaging = "";
if (isset($_GET['action']) && $_GET['action'] == "edit") { $figure_packaging = $data['figure_packaging']; } else { $figure_packaging = ""; }
$resultpackaging = dbquery("SELECT * FROM ".DB_FIGURE_PACKAGINGS." WHERE figure_packaging_parent='0' ORDER BY figure_packaging_name");
if (dbrows($resultpackaging) != 0) {
while ($datapackaging = dbarray($resultpackaging)) {
$editlistpackaging .= menu_subcats($datapackaging['figure_packaging_id'], $datapackaging['figure_packaging_name'],1);
}
}
//lIMITATIONS (locale 450)
$editlistlimitation = "";
if (isset($_GET['action']) && $_GET['action'] == "edit") { $figure_limitation = $data['figure_limitation']; } else { $figure_limitation = ""; }
$resultlimitation = dbquery("SELECT * FROM ".DB_FIGURE_LIMITATIONS." WHERE figure_limitation_parent='0' ORDER BY figure_limitation_name");
if (dbrows($resultlimitation) != 0) {
while ($datalimitation = dbarray($resultlimitation)) {
$editlistlimitation .= menu_subcats($datalimitation['figure_limitation_id'], $datalimitation['figure_limitation_name'],1);
}
}
echo "<form id='inputform' method='post' action='".$formaction."' enctype='multipart/form-data'>\n";
echo "<table cellpadding='0' cellspacing='0' width='660' class='center'>\n<tr>\n";
//Category
echo "<td width='130' class='tbl'>".$locale['figure_123'].":</td>\n";
echo "<td class='tbl'><select name='figure_cat' class='textbox'>\n".$editlistcat."</select></td>\n";
echo "</tr>\n<tr>\n";
//LEERZEILE
echo "<td class='tbl'> </td>\n";
echo "<td class='tbl'> </td>\n";
echo "</tr>\n<tr>\n";
//TITLE 411
echo "<td width='130' class='tbl'>".$locale['figure_411'].":</td>\n";
echo "<td class='tbl'><input type='text' name='figure_title' value='".$figure_title."' class='textbox' style='width:380px;' /></td>\n";
echo "</tr>\n<tr>\n";
//VARIANT 441
echo "<td width='130' class='tbl'>".$locale['figure_441'].":</td>\n";
echo "<td class='tbl'><input type='text' name='figure_variant' value='".$figure_variant."' class='textbox' style='width:380px;' /></td>\n";
echo "</tr>\n<tr>\n";
//MANUFACTURER 417
echo "<td width='130' class='tbl'>".$locale['figure_417'].":</td>\n";
echo "<td class='tbl'><select name='figure_manufacturer' class='textbox'>\n".$editlistmanufacturer."</select></td>\n";
echo "</tr>\n<tr>\n";
//SubManufacturer 415
//echo "<td width='130' class='tbl'>".$locale['figure_415'].":</td>\n";
//echo "<td class='tbl'><input type='text' name='figure_submanufacturer' value='".$figure_submanufacturer."' class='textbox' style='width:380px;' /></td>\n";
//echo "</tr>\n<tr>\n";
//Sculper/Artists 452
echo "<td width='130' class='tbl'>".$locale['figure_452'].":</td>\n";
echo "<td class='tbl'><input type='text' name='figure_artists' value='".$figure_artists."' class='textbox' style='width:380px;' /></td>\n";
echo "</tr>\n<tr>\n";
//COUNTRY 436
echo "<td width='130' class='tbl'>".$locale['figure_436'].":</td>\n";
echo "<td class='tbl'><input type='text' name='figure_country' value='".$figure_country."' class='textbox' style='width:380px;' /></td>\n";
echo "</tr>\n<tr>\n";
//LEERZEILE
echo "<td class='tbl'> </td>\n";
echo "<td class='tbl'> </td>\n";
echo "</tr>\n<tr>\n";
//BRAND 438
echo "<td width='130' class='tbl'>".$locale['figure_438'].":</td>\n";
echo "<td class='tbl'><select name='figure_brand' class='textbox'>\n".$editlistbrand."</select></td>\n";
echo "</tr>\n<tr>\n";
//SERIES 439
echo "<td width='130' class='tbl'>".$locale['figure_439'].":</td>\n";
echo "<td class='tbl'><input type='text' name='figure_series' value='".$figure_series."' class='textbox' style='width:380px;' /></td>\n";
echo "</tr>\n<tr>\n";
//LEERZEILE
echo "<td class='tbl'> </td>\n";
echo "<td class='tbl'> </td>\n";
echo "</tr>\n<tr>\n";
//Scale (locale 442)
echo "<td width='130' class='tbl'>".$locale['figure_442'].":</td>\n";
echo "<td class='tbl'><select name='figure_scale' class='textbox'>\n".$editlistscale."</select></td>\n";
echo "</tr>\n<tr>\n";
//Weight (locale 443)
echo "<td width='130' class='tbl'>".$locale['figure_443'].":</td>\n";
echo "<td class='tbl'><input type='text' name='figure_weight' value='".$figure_weight."' class='textbox' style='width:380px;' /></td>\n";
echo "</tr>\n<tr>\n";
//Height (locale 444)
echo "<td width='130' class='tbl'>".$locale['figure_444'].":</td>\n";
echo "<td class='tbl'><input type='text' name='figure_height' value='".$figure_height."' class='textbox' style='width:380px;' /></td>\n";
echo "</tr>\n<tr>\n";
//Width (locale 445)
echo "<td width='130' class='tbl'>".$locale['figure_445'].":</td>\n";
echo "<td class='tbl'><input type='text' name='figure_width' value='".$figure_width."' class='textbox' style='width:380px;' /></td>\n";
echo "</tr>\n<tr>\n";
//Depth (locale 446)
echo "<td width='130' class='tbl'>".$locale['figure_446'].":</td>\n";
echo "<td class='tbl'><input type='text' name='figure_depth' value='".$figure_depth."' class='textbox' style='width:380px;' /></td>\n";
echo "</tr>\n<tr>\n";
//LEERZEILE
echo "<td class='tbl'> </td>\n";
echo "<td class='tbl'> </td>\n";
echo "</tr>\n<tr>\n";
//Material (locale 447)
echo "<td width='130' class='tbl'>".$locale['figure_447'].":</td>\n";
echo "<td class='tbl'><select name='figure_material' class='textbox'>\n".$editlistmaterial."</select></td>\n";
echo "</tr>\n<tr>\n";
//POINT OF ARTICULATION (455)
echo "<td width='130' class='tbl'>".$locale['figure_455'].":</td>\n";
echo "<td class='tbl'><select name='figure_poa' class='textbox'>\n".$editlistpoa."</select></td>\n";
echo "</tr>\n<tr>\n";
/*
//TYP POINT OF ARTICULATION (458)
echo "<td width='130' class='tbl'>".$locale['figure_455'].":</td>\n";
echo "<td class='tbl'><select name='figure_tpoa' class='textbox'>\n".$editlisttpoa."</select></td>\n";
echo "</tr>\n<tr>\n";
*/
//Packaging (locale 448)
echo "<td width='130' class='tbl'>".$locale['figure_448'].":</td>\n";
echo "<td class='tbl'><select name='figure_packaging' class='textbox'>\n".$editlistpackaging."</select></td>\n";
echo "</tr>\n<tr>\n";
//LEERZEILE
echo "<td class='tbl'> </td>\n";
echo "<td class='tbl'> </td>\n";
echo "</tr>\n<tr>\n";
//RELASE DATE 419
echo "<td width='130' class='tbl'>".$locale['figure_419'].":</td>\n";
echo "<td class='tbl'><input type='text' name='figure_pubdate' value='".$figure_pubdate."' class='textbox' style='width:380px;' /></td>\n";
echo "</tr>\n<tr>\n";
//Original Retail Price (locale 449)
echo "<td width='130' class='tbl'>".$locale['figure_449'].":</td>\n";
echo "<td class='tbl'><input type='text' name='figure_retailprice' value='".$figure_retailprice."' class='textbox' style='width:380px;' /></td>\n";
echo "</tr>\n<tr>\n";
//USED Price (locale 456)
echo "<td width='130' class='tbl'>".$locale['figure_456'].":</td>\n";
echo "<td class='tbl'><input type='text' name='figure_usedprice' value='".$figure_usedprice."' class='textbox' style='width:380px;' /></td>\n";
echo "</tr>\n<tr>\n";
//LEERZEILE
echo "<td class='tbl'> </td>\n";
echo "<td class='tbl'> </td>\n";
echo "</tr>\n<tr>\n";
//Limited Edition (locale 450)
echo "<td width='130' class='tbl'>".$locale['figure_450'].":</td>\n";
echo "<td class='tbl'><select name='figure_limitation' class='textbox'>\n".$editlistlimitation."</select></td>\n";
echo "</tr>\n<tr>\n";
//Edition Size (locale 451)
echo "<td width='130' class='tbl'>".$locale['figure_451'].":</td>\n";
echo "<td class='tbl'><input type='text' name='figure_editionsize' value='".$figure_editionsize."' class='textbox' style='width:380px;' /></td>\n";
echo "</tr>\n<tr>\n";
//LEERZEILE
echo "<td class='tbl'> </td>\n";
echo "<td class='tbl'> </td>\n";
echo "</tr>\n<tr>\n";
//Accessories: 457
echo "<td width='130' class='tbl'>".$locale['figure_457'].":</td>\n";
echo "<td class='tbl'><textarea name='figure_accessories' cols='60' rows='5' class='textbox' style='width:380px;'>".$figure_accessories."</textarea></td>\n";
echo "</tr>\n<tr>\n";
echo "<td class='tbl'></td><td class='tbl'>\n";
echo display_bbcodes("360px", "figure_accessories")."</td>\n";
echo "</tr>\n<tr>\n";
//DISCRIPTION 423
echo "<td valign='top' width='80' class='tbl'>".$locale['figure_423'].":</td>\n";
echo "<td class='tbl'><textarea name='figure_description' cols='60' rows='5' class='textbox' style='width:380px;'>".$figure_description."</textarea></td>\n";
echo "</tr>\n<tr>\n";
echo "<td class='tbl'></td><td class='tbl'>\n";
echo display_bbcodes("360px", "figure_description")."</td>\n";
echo "</tr>\n<tr>\n";
echo "<td width='130' class='tbl'> </td>\n";
echo "<td class='tbl'> </td>\n";
echo "</tr>\n<tr>\n";
//IMAGE UPLOAD
echo "<td width='130' class='tbl' valign='top'>".$locale['figure_136']."</td>\n<td class='tbl' valign='top'>\n";
if ($figure_image != "") {
echo "<label><img src='".IMAGES_FIGURE.$figure_image."' height='350px' width='350px' alt='' /><br />\n";
echo "<input type='checkbox' name='del_image' value='y' /> ".$locale['figure_131']."</label>\n";
echo "<input type='hidden' name='figure_image' value='".$figure_image."' />\n";
} else {
echo "<input type='file' name='figure_image' class='textbox' style='width:250px;' /><br />\n";
echo sprintf($locale['figure_137'], parsebytesize($asettings['figure_photo_max_b']))."\n";
}
echo "</td>\n</tr>\n<tr>\n";
//IMAGE SOURCE
echo "<td width='130' class='tbl'>".$locale['figure_122']."</td>\n";
echo "<td class='tbl'><input type='text' name='figure_url' value='".$figure_url."' class='textbox' style='width:380px;' /></td>\n";
echo "</tr>\n<tr>\n";
/* WIRD NICHT BENÖTIGT FILEUPLOAD
echo "<td width='130' class='tbl' valign='top'>".$locale['figure_130']."</td>\n<td class='tbl' valign='top'>\n";
if (!empty($figure_file)) {
echo "<a href='".FIGURES.$figure_file."'>".FIGURES.$figure_file."</a><br />\n";
echo "<label><input type='checkbox' name='del_upload' value='1' /> ".$locale['figure_131']."</label>\n";
echo "<input type='hidden' name='figure_file' value='".$figure_file."' />";
} else {
echo "<input type='file' name='figure_file' class='textbox' style='width:150px;' /><br />\n";
echo sprintf($locale['figure_133'], parsebytesize($asettings['figure_max_b']), str_replace(',', ' ', $asettings['figure_types']))."<br />\n";
echo "<label><input type='checkbox' name='calc_upload' id='calc_upload' value='1' /> ".$locale['figure_132']."</label>\n";
}
echo "</td>\n</tr>\n<tr>\n";
*/
//echo "<td width='130' class='tbl'>".$locale['figure_422'].":</td>\n";
//echo "<td class='tbl'><input type='text' name='figure_filesize' id='figure_filesize' value='".$figure_filesize."' class='textbox' style='width:150px;' /></td>\n";
//echo "</tr>\n<tr>\n";
echo "<td class='tbl'></td><td class='tbl'>\n";
echo "<label><input type='checkbox' name='figure_comments' value='yes''".$figure_comments." /> ".$locale['figure_124']."</label>\n";
echo "<br /><label><input type='checkbox' name='figure_ratings' value='yes''".$figure_ratings." /> ".$locale['figure_125']."</label>\n</td>\n";
echo "</tr>\n<tr>\n";
echo "<td align='center' colspan='2' class='tbl'>";
if (isset($_GET['action']) && $_GET['action'] == "edit") {
echo "<label><input type='checkbox' name='update_datestamp' value='1' /> ".$locale['figure_129']."</label><br />\n";
}
echo "<input type='submit' name='save_download' value='".$locale['figure_128']."' class='button' /></td>\n";
echo "</tr>\n</table>\n</form>\n";
closetable();
opentable($locale['figure_102']);
echo "<table cellpadding='0' cellspacing='0' width='400' class='center'>\n";
$result = dbquery("SELECT * FROM ".DB_FIGURE_CATS." WHERE figure_cat_parent='0' ORDER BY figure_cat_name");
if (dbrows($result)) {
echo "<tr>\n";
echo "<td class='tbl2'>".$locale['figure_140']."</td>\n";
echo "<td align='right' class='tbl2'>".$locale['figure_141']."</td>\n";
echo "</tr>\n<tr>\n";
echo "<td colspan='2' height='1'></td>\n";
echo "</tr>\n";
if (!isset($_GET['figure_cat_id']) || !isnum($_GET['figure_cat_id'])) { $_GET['figure_cat_id'] = 0; }
while ($data = dbarray($result)) {
if ($data['figure_cat_id'] == $_GET['figure_cat_id']) { $p_img = "off"; $div = ""; } else { $p_img = "on"; $div = "style='display:none'"; }
echo "<tr>\n";
echo "<td class='tbl2'>".$data['figure_cat_name']."</td>\n";
echo "<td class='tbl2' align='right'><img src='".get_image("panel_$p_img")."' name='b_".$data['figure_cat_id']."' alt='' onclick=\"javascript:flipBox('".$data['figure_cat_id']."')\" /></td>\n";
echo "</tr>\n";
$result2 = dbquery("SELECT * FROM ".DB_FIGURE." WHERE figure_cat='".$data['figure_cat_id']."' ORDER BY figure_title");
if (dbrows($result2) != 0) {
echo "<tr>\n<td colspan='2'>\n";
echo "<div id='box_".$data['figure_cat_id']."'".$div.">\n";
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n";
while ($data2 = dbarray($result2)) {
if (!empty($data2['figure_file']) && file_exists(FIGURES.$data2['figure_file'])) {
$figure_url = FIGURES.$data2['figure_file'];
} elseif (!strstr($data2['figure_url'],"http://") && !strstr($data2['figure_url'],"../")) {
$figure_url = BASEDIR.$data2['figure_url'];
} else {
$figure_url = $data2['figure_url'];
}
echo "<tr>\n<td class='tbl'><a href='$figure_url' target='_blank'>".$data2['figure_title']."</a></td>\n";
echo "<td align='right' width='100' class='tbl'><a href='".FUSION_SELF.$aidlink."&action=edit&figure_cat_id=".$data['figure_cat_id']."&figure_id=".$data2['figure_id']."'>".$locale['figure_142']."</a> -\n";
echo "<a href='".FUSION_SELF.$aidlink."&action=delete&figure_cat_id=".$data['figure_cat_id']."&figure_id=".$data2['figure_id']."' onclick=\"return confirm('".$locale['figure_160']."');\">".$locale['figure_131']."</a></td>\n";
echo "</tr>\n";
}
echo "</table>\n</div>\n</td>\n</tr>\n";
}
echo subcats($data['figure_cat_id'], 1);
}
echo "</table>\n";
} else {
echo "<tr>\n<td align='center'><br />\n";
echo $locale['figure_150']."<br /><br /></td>\n";
echo "</tr>\n</table>\n";
}
closetable();
} else {
opentable($locale['figure_102']);
echo "<div style='text-align:center'>".$locale['figure_151']."<br />\n".$locale['figure_152']."<br /><br />\n";
echo "<a href='figure_cats.php".$aidlink."'>".$locale['figure_153']."</a>".$locale['figure_154']."<br />\n";
echo "<a href='figure_manufacturers.php".$aidlink."'>".$locale['figure_153']."</a>".$locale['figure_180']."<br />\n";
echo "<a href='figure_brands.php".$aidlink."'>".$locale['figure_153']."</a>".$locale['figure_181']."<br />\n";
echo "<a href='figure_materials.php".$aidlink."'>".$locale['figure_153']."</a>".$locale['figure_182']."<br />\n";
echo "<a href='figure_scales.php".$aidlink."'>".$locale['figure_153']."</a>".$locale['figure_183']."<br />\n";
echo "<a href='figure_poas.php".$aidlink."'>".$locale['figure_153']."</a>".$locale['figure_184']."<br />\n";
//echo "<a href='figure_tpoas.php".$aidlink."'>".$locale['figure_153']."</a>".$locale['figure_185']."<br />\n";
echo "<a href='figure_packagings.php".$aidlink."'>".$locale['figure_153']."</a>".$locale['figure_186']."<br />\n";
echo "<a href='figure_limitations.php".$aidlink."'>".$locale['figure_153']."</a>".$locale['figure_187']."</div>\n";
closetable();
}
echo "<script country='JavaScript' type='text/javascript'>
$(document).ready(function() {
$('#calc_upload').click(
function() {
if ($('#calc_upload').attr('checked')) {
$('#figure_filesize').attr('readonly', 'readonly');
$('#calc_upload').attr('checked', 'checked');
} else {
$('#figure_filesize').removeAttr('readonly');
$('#calc_upload').removeAttr('checked');
}
});
});
</script>";
function subcats ($id, $level) {
global $aidlink, $locale;
$sublist = "";
$sresult[$id] = dbquery("SELECT figure_cat_id, figure_cat_name, figure_cat_description, figure_cat_access FROM ".DB_FIGURE_CATS." WHERE figure_cat_parent='".$id."' ORDER BY figure_cat_name");
if (dbrows($sresult[$id]) != 0) {
while ($sdata[$id] = dbarray($sresult[$id])) {
if ($sdata[$id]['figure_cat_id'] == $_GET['figure_cat_id']) { $p_img = "off"; $div = ""; } else { $p_img = "on"; $div = "style='display:none'"; }
$sublist .= "<tr>\n";
$sublist .= "<td class='tbl2'>".str_repeat("— ",$level)." ".$sdata[$id]['figure_cat_name']."</td>\n";
$sublist .= "<td class='tbl2' align='right'><img src='".get_image("panel_$p_img")."' name='b_".$sdata[$id]['figure_cat_id']."' alt='' onclick=\"javascript:flipBox('".$sdata[$id]['figure_cat_id']."')\" /></td>\n";
$sublist .= "</tr>\n";
$bresult[$id] = dbquery("SELECT * FROM ".DB_FIGURE." WHERE figure_cat='".$sdata[$id]['figure_cat_id']."' ORDER BY figure_title");
if (dbrows($bresult[$id]) != 0) {
$sublist .= "<tr>\n<td colspan='2'>\n";
$sublist .= "<div id='box_".$sdata[$id]['figure_cat_id']."'".$div.">\n";
$sublist .= "<table cellpadding='0' cellspacing='0' width='100%'>\n";
while ($bdata[$id] = dbarray($bresult[$id])) {
if (!empty($bdata[$id]['figure_file']) && file_exists(FIGURES.$bdata[$id]['figure_file'])) {
$figure_url = FIGURES.$bdata[$id]['figure_file'];
} elseif (!strstr($bdata[$id]['figure_url'],"http://") && !strstr($bdata[$id]['figure_url'],"../")) {
$figure_url = BASEDIR.$bdata[$id]['figure_url'];
} else {
$figure_url = $bdata[$id]['figure_url'];
}
$sublist .= "<tr>\n<td class='tbl'><a href='$figure_url' target='_blank'>".$bdata[$id]['figure_title']."</a></td>\n";
$sublist .= "<td align='right' width='100' class='tbl'><a href='".FUSION_SELF.$aidlink."&action=edit&figure_cat_id=".$sdata[$id]['figure_cat_id']."&figure_id=".$bdata[$id]['figure_id']."'>".$locale['figure_142']."</a> -\n";
$sublist .= "<a href='".FUSION_SELF.$aidlink."&action=delete&figure_cat_id=".$sdata[$id]['figure_cat_id']."&figure_id=".$bdata[$id]['figure_id']."' onclick=\"return confirm('".$locale['figure_160']."');\">".$locale['figure_131']."</a></td>\n";
$sublist .= "</tr>\n";
}
$sublist .= "</table>\n</div>\n</td>\n</tr>\n";
}
$sublist .= subcats($sdata[$id]['figure_cat_id'], $level+1);
}
}
return $sublist;
}
function menu_subcats($id, $name, $level) {
global $figure_cat, $asettings; $sel = "";
if (isset($_GET['action']) && $_GET['action'] == "edit") { $sel = ($figure_cat == $id ? " selected='selected'" : ""); }
$list = "<option value='".$id."'$sel>".str_repeat(" ",$level-1)." ".$name."</option>\n";
if ($asettings['subcats']) {
$sresult[$id] = dbquery("SELECT figure_cat_id, figure_cat_name FROM ".DB_FIGURE_CATS." WHERE figure_cat_parent='".$id."' ORDER BY figure_cat_name");
if (dbrows($sresult[$id]) != 0) {
while ($sdata[$id] = dbarray($sresult[$id])) {
$list .= menu_subcats($sdata[$id]['figure_cat_id'], $sdata[$id]['figure_cat_name'], $level+1);
}
}
}
return $list;
}
require_once THEMES."templates/footer.php";
?>