PHP-FUSION DEUTSCHLAND
  • DEIN CMS - DEINE ZUKUNFT
Thread Verfasser: Catzenjaeger
Thread ID: 858
Thread Info
Es gibt 3 Beiträge zu diesem Thema, und es wurde 3017 Mal angesehen.  Ausserdem wurden Dateien angehängt.

PHP-Fusion Deutschland - Offizielle Supportseite » Support Allgemein » Infusionen / Mods / Panels

 Thema drucken
Booklib infusion umgebaut - Fehler
Catzenjaeger
Top  #1 Beitrag drucken
Geschrieben am 01. Mai 2016 14:51:56
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:

Code Download Code  

$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:

Code Download Code  

$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

Code Download 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'] = 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
 
WWW
Wemi
Top  #2 Beitrag drucken
Geschrieben am 01. Mai 2016 17:35:51
Theoretisch musst du nur in Zeile 108
Code Download Code  

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


ändern in

Code Download Code  

$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
 
WWW
Catzenjaeger
Top  #3 Beitrag drucken
Geschrieben am 01. Mai 2016 17:50:55
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
 
WWW
Springe ins Forum: