Thread Verfasser: Catzenjaeger
Thread ID: 858
Thread Info
Es gibt 3 Beiträge zu diesem Thema, und es wurde 2896 Mal angesehen.  Ausserdem wurden Dateien angehängt.
 Thema drucken
Booklib infusion umgebaut - Fehler
Catzenjaeger
Hallo,
sorry ich habe das ganze Thema auch in UK gepostet (https://www.php-fusion.co.uk/forum/viewthread.php?thread_id=37480) aber ich kann besser deutsch und vielleicht kann mir jemand hier helfen. Ich habe die Booklib Infusion zu einer Figurendatenbank umgebaut.

Im Adminbereich dieser Infuion gibt es die Datei admin_items.php.

Wenn ich die aufrufe und dort einen vorhandene Figur ändere bekomme ich folgenden Fehler: Undefined index: figure_filesize. Aber die daten werden gespeichert so wie sie sollen.

Also habe ich alle Vorkommen von file_size auskommentiert und auch dort wo in die DB eingetragen wird. Aber nun werden alle Figuren wenn ich etwas ändere geändert. Sieht so aus als weiss er nicht mehr welche Figut ich editiere.

ich habe das:


$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_packaging='$figure_packaging',   figure_retailprice='$figure_retailprice', 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_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']."'");


zu das geändert:


$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_packaging='$figure_packaging',   figure_retailprice='$figure_retailprice', 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_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_datestamp." WHERE figure_id='".$_GET['figure_id']."'");


ich habe praktisch nur figure_filesize='$figure_filesize' rausgelöscht. Nun kommt aber ein neuer Fehler und die Daten werden nicht richtig geupdatet. ich bin am verzweifeln. Ich sitze da schon tage dran. Sorry ich bin nur ein Gelegenheitsprogramierer und das ist meine rstes großes Projekt

Hier der Fehler:
(SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE figure_id='10'' at line 1)

Hier mal das ganze File:

WÄRE TOLL WENN MIR JEMAND AUS DER PATSCHE HILFT


<?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'] = 400000;
$asettings['figure_photo_max_w'] = 1000;
$asettings['figure_photo_max_h'] = 1000;

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']."'");
/*AUSKOMMENTIERT WEGEN FEHLER --> Driver/PDOMySQL.php site/infusions/figurelib/admin/figure_items.php?aid=3e41833f2adc7085&action=delete&figure_cat_id=1&figure_id=11 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'aliencollectors_com_.DB_BCOMMENTS' doesn't exist Line: 106         
         $result = dbquery("DELETE FROM ".DB_BCOMMENTS." WHERE comment_item_id='".$_POST['figure_id']."' and comment_type='BO'");         
AUSKOMMENTIEREN ENDE*/      

/*AUSKOMMENTIERT WEGEN FEHLER -->  admin/figure_items.php/site/infusions/figurelib/admin/figure_items.php?aid=3e41833f2adc7085&action=delete&figure_cat_id=1&figure_id=12 Undefined index: news_idLine: 80   
         $result = dbquery("DELETE FROM ".DB_RATINGS." WHERE rating_item_id='".$_POST['news_id']."' and rating_type='B'");         
AUSKOMMENTIEREN ENDE*/   
      }   
      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_packaging = stripinput($_POST['figure_packaging']);
      $figure_retailprice = stripinput($_POST['figure_retailprice']);
      $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']);
      $figure_description = trim(stripinput($_POST['figure_description']));
      $figure_filesize = stripinput($_POST['figure_filesize']);
      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, 180, 180);
            }
         }
         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_packaging='$figure_packaging',   figure_retailprice='$figure_retailprice', 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_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_packaging,   figure_retailprice,   figure_limitation, figure_editionsize, figure_artists, figure_country, figure_manufacturer, figure_pubdate, figure_image, 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_packaging', '$figure_retailprice', '$figure_limitation', '$figure_editionsize', '$figure_artists', '$figure_country', '$figure_manufacturer', '$figure_pubdate', '$figure_image', '$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_retailprice = $data['figure_retailprice'];
         $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'];
         $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."&amp;action=edit&amp;figure_cat_id=".$data['figure_cat']."&amp;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_retailprice = "";
      $figure_limitation = "";
      $figure_editionsize = "";
      $figure_artists = "";
   //ENDE
      //$figure_author = "";
      $figure_country = "";
      $figure_manufacturer = "";
      $figure_pubdate = "";
      $figure_image = "";
      $figure_description = "";
      $figure_url = "";
      $figure_file = "";
      $figure_comments = " checked='checked'";
      $figure_ratings = " checked='checked'";
      $figure_filesize = "";
      $formaction = FUSION_SELF.$aidlink;
      opentable($locale['figure_100']);
   }
   $editlist = ""; if (isset($_GET['action']) && $_GET['action'] == "edit") { $figure_cat = $data['figure_cat']; } else { $figure_cat = ""; }
   $result2 = dbquery("SELECT * FROM ".DB_FIGURE_CATS." WHERE figure_cat_parent='0' ORDER BY figure_cat_name");
   if (dbrows($result2) != 0) {
      while ($data2 = dbarray($result2)) {
         $editlist .= menu_subcats($data2['figure_cat_id'], $data2['figure_cat_name'],1);
      }
   }
   echo "<form id='inputform' method='post' action='".$formaction."' enctype='multipart/form-data'>\n";
   echo "<table cellpadding='0' cellspacing='0' width='460' class='center'>\n<tr>\n";
   //TITLE 411
   echo "<td width='80' 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='80' 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";
   
   //AUTHOR = MANUFACTURER 417
   //echo "<td width='80' class='tbl'>".$locale['figure_417'].":</td>\n";
   //echo "<td class='tbl'><input type='text' name='figure_author' value='".$figure_author."' class='textbox' style='width:380px;' /></td>\n";
   //echo "</tr>\n<tr>\n";
   
   //MANUFACTURER 417
   echo "<td width='80' class='tbl'>".$locale['figure_417'].":</td>\n";
   echo "<td class='tbl'><input type='text' name='figure_manufacturer' value='".$figure_manufacturer."' class='textbox' style='width:380px;' /></td>\n";
   echo "</tr>\n<tr>\n";
   
   //SubManufacturer 415
   echo "<td width='80' 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='80' 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='80' 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";
   
   //BRAND   438
   echo "<td width='80' class='tbl'>".$locale['figure_438'].":</td>\n";
   echo "<td class='tbl'><input type='text' name='figure_brand' value='".$figure_brand."' class='textbox' style='width:380px;' /></td>\n";
   echo "</tr>\n<tr>\n";
   
   //SERIES 439
   echo "<td width='80' 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";
   
echo "<td width='80' class='tbl'>&nbsp;</td>\n";
echo "<td class='tbl'>&nbsp;</td>\n";
echo "</tr>\n<tr>\n";

   //Scale (locale 442)
   echo "<td width='80' class='tbl'>".$locale['figure_442'].":</td>\n";
   echo "<td class='tbl'><input type='text' name='figure_scale' value='".$figure_scale."' class='textbox' style='width:380px;' /></td>\n";
   echo "</tr>\n<tr>\n";
   
   //Weight (locale 443)
   echo "<td width='80' 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='80' 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='80' 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='80' 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";
   
   //Material (locale 447)
   echo "<td width='80' class='tbl'>".$locale['figure_447'].":</td>\n";
   echo "<td class='tbl'><input type='text' name='figure_material' value='".$figure_material."' class='textbox' style='width:380px;' /></td>\n";
   echo "</tr>\n<tr>\n";
   
   //Packaging (locale 448)
   echo "<td width='80' class='tbl'>".$locale['figure_448'].":</td>\n";
   echo "<td class='tbl'><input type='text' name='figure_packaging' value='".$figure_packaging."' class='textbox' style='width:380px;' /></td>\n";
   echo "</tr>\n<tr>\n";

echo "<td width='80' class='tbl'>&nbsp;</td>\n";
echo "<td class='tbl'>&nbsp;</td>\n";
echo "</tr>\n<tr>\n";

   //RELASE DATE 419
   echo "<td width='80' 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='80' 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";
   
   //Limited Edition (locale 450)
   echo "<td width='80' class='tbl'>".$locale['figure_450'].":</td>\n";
   echo "<td class='tbl'><input type='text' name='figure_limitation' value='".$figure_limitation."' class='textbox' style='width:380px;' /></td>\n";
   echo "</tr>\n<tr>\n";
   
   //Edition Size (locale 451)
   echo "<td width='80' 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";

echo "<td width='80' class='tbl'>&nbsp;</td>\n";
echo "<td class='tbl'>&nbsp;</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='80' class='tbl'>&nbsp;</td>\n";
echo "<td class='tbl'>&nbsp;</td>\n";
echo "</tr>\n<tr>\n";
   
   //IMAGE UPLOAD
   echo "<td width='80' 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."' 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='80' 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='80' 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='80' class='tbl'>".$locale['figure_123'].":</td>\n";
   echo "<td class='tbl'><select name='figure_cat' class='textbox'>\n".$editlist."</select></td>\n";
   echo "</tr>\n<tr>\n";
   //echo "<td width='80' 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."&amp;action=edit&amp;figure_cat_id=".$data['figure_cat_id']."&amp;figure_id=".$data2['figure_id']."'>".$locale['figure_142']."</a> -\n";
               echo "<a href='".FUSION_SELF.$aidlink."&amp;action=delete&amp;figure_cat_id=".$data['figure_cat_id']."&amp;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']."</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("&mdash; ",$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."&amp;action=edit&amp;figure_cat_id=".$sdata[$id]['figure_cat_id']."&amp;figure_id=".$bdata[$id]['figure_id']."'>".$locale['figure_142']."</a> -\n";
               $sublist .= "<a href='".FUSION_SELF.$aidlink."&amp;action=delete&amp;figure_cat_id=".$sdata[$id]['figure_cat_id']."&amp;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("&nbsp;&nbsp;&nbsp;&nbsp;",$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";
?>
Catzenjaeger hat folgende Datei angehängt:
Du hast nicht die Berechtigung die Anhäge dieses Themas zu sehen.
Information:
PHP Version: Nicht ausgewählt •  MySQL Version: Nicht ausgewählt •  PHP-Fusion: Nicht ausgewählt
 
Wemi
Theoretisch musst du nur in Zeile 108

$figure_filesize = stripinput($_POST['figure_filesize']);


ändern in


$figure_filesize = 1;


Der Fehler resultiert daraus, dass du den File Upload auskommentiert hast und nicht nutzt.

Trägst du gar nichts ein in das Datenbankfeld, dann könnte eventuell noch ein Fehler im Frontend auftreten, wo versucht wird die Dateigröße anzuzeigen.

Aber könnte man für deine Zwecke nicht auch die Fotogallerie missbrauchen?
"Es geht hier um die Frage, ob die Menschheit ohne Religion besser dastünde. Und ich sagte: ja" Ben Moore
Information:
PHP Version: Nicht ausgewählt •  MySQL Version: Nicht ausgewählt •  PHP-Fusion: Nicht ausgewählt
 
Catzenjaeger
DANKE für deinen Antwort. Also das schein schon mal zu funktionieren. Fotogallery umzubauen traue ich mir nicht zu. Die Booklil schien mir am einfachsten aber nicht für mich als Laie.

ich stoße hier echt an meine Grenzen. problem ist ja das ich viel rausgehauen habe was ich nicht brauchte aber doch irgendwie alles zusammenhängt.

ich teste das mal ob noch Fehler auflaufen.

Andere Fragen: ich wollte Limitation ein aj/nein feld einbauen also Radio Buttons. Die Buttons bekomme ich hin auch die Einträge in die DB funktioinieren aber wenn ich die Figur dann editiere sind beide radios wieder leer.

weiterhin ... immer wenn ich was eintrage dort in der Datenbank oder ändere bekomme ich oben eine Fehlermeldung obwohl kein Fehler in Queue ist

There was an error while processing your request

was ist das?

Zusammengefügt am 02. Mai 2016 um 13:!39:44:
Hallo,

also ich habe die seite komplett neu aufgesttzt. wenn ich jetzt meinen eingenen Infusion hochlade bekomme ich schon fehler:

Driver/PDOMySQL.php
/site/administration/index.php?aid=756779a99ec4ddb2&pagenum=3
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ac_com_.fusion352tt_figure_settings' doesn't exist
Line: 106
2 seconds ago
Error generated by user using trigger_error() function
Driver/PDOMySQL.php
/site/administration/errors.php?aid=756779a99ec4ddb2
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ac_com_.fusion352tt_figure_settings' doesn't exist
Line: 106
just now

alerdings kommt tt_figure_settings nirgends vor
Bearbeitet von Catzenjaeger am 02. Mai 2016 11:39:44
Information:
PHP Version: Nicht ausgewählt •  MySQL Version: Nicht ausgewählt •  PHP-Fusion: Nicht ausgewählt
 
Springe ins Forum: