"submit_criteria" => addslashes(serialize($criteriaArray))
// Form posted
if (isset($_POST['submit_figure'])) {
//$submit_info['figure_description'] = nl2br(parseubb(stripinput($_POST['figure_description'])));
// Check Fields
$criteriaArray = array(
"figure_datestamp" => form_sanitizer($_POST['figure_datestamp'], "", "figure_datestamp"),
"figure_freigabe" => form_sanitizer($_POST['figure_freigabe'], 0, "figure_freigabe"),
"figure_title" => form_sanitizer($_POST['figure_title'], "", "figure_title"),
"figure_variant" => form_sanitizer($_POST['figure_variant'], "", "figure_variant"),
"figure_manufacturer" => form_sanitizer($_POST['figure_manufacturer'], "", "figure_manufacturer"),
"figure_artists" => form_sanitizer($_POST['figure_artists'], "", "figure_artists"),
"figure_country" => form_sanitizer($_POST['figure_country'], "", "figure_country"),
"figure_brand" => form_sanitizer($_POST['figure_brand'], "", "figure_brand"),
"figure_series" => form_sanitizer($_POST['figure_series'], "", "figure_series"),
"figure_scale" => form_sanitizer($_POST['figure_scale'], "", "figure_scale"),
"figure_weight" => form_sanitizer($_POST['figure_weight'], "", "figure_weight"),
"figure_height" => form_sanitizer($_POST['figure_height'], "", "figure_height"),
"figure_width" => form_sanitizer($_POST['figure_width'], "", "figure_width"),
"figure_depth" => form_sanitizer($_POST['figure_depth'], "", "figure_depth"),
"figure_material" => form_sanitizer($_POST['figure_material'], "", "figure_material"),
"figure_poa" => form_sanitizer($_POST['figure_poa'], "", "figure_poa"),
"figure_packaging" => form_sanitizer($_POST['figure_packaging'], "", "figure_packaging"),
"figure_retailprice" => form_sanitizer($_POST['figure_retailprice'], "", "figure_retailprice"),
"figure_usedprice" => form_sanitizer($_POST['figure_usedprice'], "", "figure_usedprice"),
"figure_limitation" => form_sanitizer($_POST['figure_limitation'], "", "figure_limitation"),
"figure_cat" => form_sanitizer($_POST['figure_cat'], "", "figure_cat"),
"figure_editionsize" => form_sanitizer($_POST['figure_editionsize'], "", "figure_editionsize"),
"figure_pubdate" => form_sanitizer($_POST['figure_pubdate'], "", "figure_pubdate"),
"figure_agb" => form_sanitizer($_POST['figure_agb'], 0, "figure_agb"),
"figure_submitter" => form_sanitizer($_POST['figure_submitter'], "", "figure_submitter"),
"figure_description" => addslash(nl2br(parseubb(stripinput($_POST['figure_description'])))),
"figure_accessories" => addslash(nl2br(parseubb(stripinput($_POST['figure_accessories'])))),
);
//Save
if (defender::safe()) {
$inputArray = array(
"submit_type" => "f",
"submit_user" => $userdata['user_id'],
"submit_datestamp" => time(),
"submit_criteria" => addslashes(serialize($criteriaArray))
);
dbquery_insert(DB_SUBMISSIONS, $inputArray, "save", array(
'keep_session' => TRUE));
// Image Upload
$upload = form_sanitizer($_FILES['figure_image'], '', 'figure_image');
if (!empty($upload)) {
$totalFiles = count($upload);
for ($i = 0; $i < $totalFiles; $i++) {
$currentUpload = $upload[$i];
if ($currentUpload['error'] == 0) {
$imageArray = array(
'figure_images_figure_id' => $figureID,
'figure_images_image' => $currentUpload['image_name'],
'figure_images_thumb' => $currentUpload['thumb1_name']
);
dbquery_insert(DB_FIGURE_IMAGES, $imageArray, "save");
................
if (!defined("DB_FIGURE_USERFIGURES")) {
define("DB_FIGURE_USERFIGURES", DB_PREFIX."figure_userfigures");
}
if (!defined("DB_FIGURE_IMAGES")) {
define("DB_FIGURE_IMAGES", DB_PREFIX."figure_images");
$inf_folder = "figurelib";
// FOLDERS
if (!defined("FIGURES")) {
define("FIGURES", INFUSIONS.$inf_folder."/figures/");
}
if (!defined("IMAGES_FIGURES")) {
define("IMAGES_FIGURES", INFUSIONS.$inf_folder."/figures/images/");
}
if (!defined("THUMBS_FIGURES")) {
define("THUMBS_FIGURES", INFUSIONS.$inf_folder."/figures/images/thumbs/");
}
..............
$inf_newtable[] = DB_FIGURE_IMAGES." (
figure_images_image_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_images_figure_id varchar(100) NOT NULL DEFAULT '',
figure_images_image varchar(100) NOT NULL DEFAULT '',
figure_images_thumb varchar(100) NOT NULL DEFAULT '',
figure_images_sorting varchar(50) NOT NULL DEFAULT '',
figure_images_language VARCHAR(50) NOT NULL DEFAULT '".LANGUAGE."',
PRIMARY KEY (figure_images_image_id)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";
https://github.com/Catzenjaeger/FigureLib_3
dbquery_insert(DB_SUBMISSIONS, $inputArray, "save", array(
Quote
figurelib/infuison.php
$inf_newtable[] = DB_FIGURE_IMAGES." (
figure_images_image_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_images_figure_id varchar(100) NOT NULL DEFAULT '',
figure_images_image varchar(100) NOT NULL DEFAULT '',
figure_images_thumb varchar(100) NOT NULL DEFAULT '',
figure_images_sorting varchar(50) NOT NULL DEFAULT '',
figure_images_language VARCHAR(50) NOT NULL DEFAULT '".LANGUAGE."',
PRIMARY KEY (figure_images_image_id)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";
Quote
figurelib/infusion.db.php
if (!defined("DB_FIGURE_USERFIGURES") {
define("DB_FIGURE_USERFIGURES", DB_PREFIX."figure_userfigures"
}
// FOLDERS
if (!defined("FIGURES") {
define("FIGURES", INFUSIONS.$inf_folder."/figures/"
}
if (!defined("IMAGES_FIGURES") {
define("IMAGES_FIGURES", INFUSIONS.$inf_folder."/figures/images/"
}
if (!defined("THUMBS_FIGURES") {
define("THUMBS_FIGURES", INFUSIONS.$inf_folder."/figures/images/thumbs/"
}
Quote
figurelib/submit.php --> plz take a look in attachment
if (iMEMBER) {
echo form_hidden("item_status", 0);
} elseif (iADMIN && checkrights("FI)) {
echo form_select("item_status", .....);
}
$query = "
SELECT a.*, b.*
FROM ".YOUR_ITEM_TABLE." a
LEFT JOIN ".DB_FIGURE_IMAGE." b ON a.item_id = b. item_id
GROUP BY a.item_id
";
$result = dbquery($query);
Category Forum
Modifications and Requests - 9Labels
None yet
Statistics
3 participants
Notifications
You are not receiving notifications from this thread.
Related Questions