UnrealCatze
commented
7 years ago ALSO HIER MAL MIT BILDER
im Admin- Menue einer jeden Figur ist jetzt ein zusätziche Area wo ich "Nummern" erfassen kann
Das Amazon Menu, wo vorher immer die ASIN eingetragen wurde, habe ich so umgebaut, dass ich dort nur noch ein Haken setzen kann ob das jeweilige Land am programm teilnimmt bzw ich einen Account habe . .. weil wir erwähnt ... die ASIN ist ja immer gleich und ich hatte die immer 8 mal eingetragen was ja quatsch ist
Wenn ich mir jetzt eine Figur darstelle wo ich die ASIN erfasst habe und auch das Feld Amazon de = 1 ist == also Haken gesetzt ... wird nur die ASIN angezeigt ... nicht aber der komplette code.
Ich denke das ist wieder irgendwo in der classes umzubauen hier mal die ganze Datei figures_class
`<?php
// Check Access if (!defined("IN_FUSION")) { die("Access Denied!"); }
// Figurelib Fronted class FigurelibFrontedList {
// Variables
private $figurelibSettings = array();
private $listmode = "";
private $listview = "";
private $searchText = false;
private $series = false;
private $variant = false;
private $pubdate = false;
private $brandID = false;
private $scaleID = false;
private $categoryID = false;
private $manufacturerID = false;
private $figureID = false;
// Start Class
public function __construct() {
// Get Settings
$this -> figurelibSettings = get_settings("figurelib");
// Set Default
$this -> listmode = "by-categories";
$this -> listview = "as-gallery";
// Check Cookies
if (isset($_COOKIE['listmode']) && in_array($_COOKIE['listmode'], ["by-categories", "by-manufacturers"])) {
$this -> listmode = $_COOKIE['listmode'];
}
if (isset($_COOKIE['listview']) && in_array($_COOKIE['listview'], ["as-list", "as-gallery"])) {
$this -> listview = $_COOKIE['listview'];
}
// Get Listmode
if (isset($_GET['listmode']) && in_array($_GET['listmode'], ["by-categories", "by-manufacturers"])) {
$this -> listmode = $_GET['listmode'];
setCookie("listmode", $this -> listmode, (time() + (365 * 24 * 60 *60)));
}
// Get Listview
if (isset($_GET['listview']) && in_array($_GET['listview'], ["as-list", "as-gallery"])) {
$this -> listview = $_GET['listview'];
setCookie("listview", $this -> listview, (time() + (365 * 24 * 60 *60)));
}
// Get Category
if (isset($_GET['category_id']) && isNum($_GET['category_id']) && dbcount("(figure_cat_id)", DB_FIGURE_CATS, "figure_cat_id='".$_GET['category_id']."'")) {
$this -> categoryID = $_GET['category_id'];
}
// Get Manufacturer
if (isset($_GET['manufacturer_id']) && isNum($_GET['manufacturer_id']) && dbcount("(figure_manufacturer_id)", DB_FIGURE_MANUFACTURERS, "figure_manufacturer_id='".$_GET['manufacturer_id']."'")) {
$this -> manufacturerID = $_GET['manufacturer_id'];
}
// Get Scale
if (isset($_GET['scale_id']) && isNum($_GET['scale_id']) && dbcount("(figure_scale_id)", DB_FIGURE_SCALES, "figure_scale_id='".$_GET['scale_id']."'")) {
$this -> scaleID = $_GET['scale_id'];
}
// Get Brand
if (isset($_GET['brand_id']) && isNum($_GET['brand_id']) && dbcount("(figure_brand_id)", DB_FIGURE_BRANDS, "figure_brand_id='".$_GET['brand_id']."'")) {
$this -> brandID = $_GET['brand_id'];
}
// Get Figure
if (isset($_GET['figure_id']) && isNum($_GET['figure_id']) && dbcount("(figure_id)", DB_FIGURE_ITEMS, "figure_id='".$_GET['figure_id']."' AND ".groupaccess("figure_visibility")." AND figure_freigabe='1'")) {
$this -> figureID = $_GET['figure_id'];
}
// Get Searchtext
if (isset($_GET['searchtext']) && stripinput(trim($_GET['searchtext'])) && $_GET['searchtext']) {
$this -> searchText = $_GET['searchtext'];
}
// Get Series
if (isset($_GET['series']) && stripinput(trim($_GET['series'])) && $_GET['series']) {
$this -> series = $_GET['series'];
}
// Get Variant
if (isset($_GET['variant']) && stripinput(trim($_GET['variant'])) && $_GET['variant']) {
$this -> variant = $_GET['variant'];
}
// Get Pubdate
if (isset($_GET['pubdate']) && stripinput(trim($_GET['pubdate'])) && $_GET['pubdate']) {
$this -> pubdate = $_GET['pubdate'];
}
// Add Sitetitle and Breadcrumb
add_to_title("Database");
\PHPFusion\BreadCrumbs::getInstance() -> addBreadCrumb(["link" => INFUSIONS."figurelib/figures.php", "title" => "Database"]);
}
// Display a List with Manufacturers
private function displayManufacturersList() {
// Set Standard Array
$info = array("rows" => "0", "items" => [], "no-items-msg" => ($this -> categoryID ? "There are no Manufacturers and Figures in this Category!" : "There are no Manufacturers and Figures in the Database!"));
// Get all Manufacturers
$result = dbquery("
SELECT
fm.figure_manufacturer_id, fm.figure_manufacturer_name, COUNT(f.figure_id) AS figure_counter
FROM ".DB_FIGURE_ITEMS." AS f
LEFT JOIN ".DB_FIGURE_MANUFACTURERS." AS fm ON fm.figure_manufacturer_id=f.figure_manufacturer
WHERE
".(multilang_table("FI") ? "f.figure_language='".LANGUAGE."' AND " : "")."
".($this -> categoryID ? "f.figure_cat='".$this -> categoryID."' AND " : "")."
".($this -> searchText ? "f.figure_title LIKE '%".$this -> searchText."%' AND " : "")."
".($this -> series ? "f.figure_series LIKE '%".$this -> series."%' AND " : "")."
".($this -> variant ? "f.figure_variant LIKE '%".$this -> variant."%' AND " : "")."
".($this -> pubdate ? "f.figure_pubdate LIKE '%".$this -> pubdate."%' AND " : "")."
".($this -> scaleID ? "f.figure_scale='".$this -> scaleID."' AND " : "")."
".($this -> brandID ? "f.figure_brand='".$this -> brandID."' AND " : "")."
".groupaccess("f.figure_visibility")." AND f.figure_freigabe='1'
GROUP BY fm.figure_manufacturer_id
ORDER BY fm.figure_manufacturer_name ASC
");
$info['rows'] = dbrows($result);
// Save Datas to Array
while ($data = dbarray($result)) {
$info['items'][$data['figure_manufacturer_id']] = [
"manufacturer-id" => $data['figure_manufacturer_id'],
"manufacturer-title" => $data['figure_manufacturer_name'],
"manufacturer-counter" => $data['figure_counter'],
"manufacturer-link" => FUSION_SELF."?".($this -> searchText ? "searchtext=".$this -> searchText."&" : "").($this -> categoryID ? "category_id=".$this -> categoryID."&" : "")."manufacturer_id=".$data['figure_manufacturer_id'],
"manufacturer-image" => figures_getImagePath("manufacturers", "thumb", $data['figure_manufacturer_id'])
];
}
// Display Template
require_once INFUSIONS."figurelib/templates/manufacturer-lists.php";
renderFigurelibManufacturersList($info);
}
// Display a List with Categories
private function displayCategoriesList() {
// Set Standard Array
$info = array("rows" => "0", "items" => [], "no-items-msg" => ($this -> categoryID ? "There are no Categories and Figures by this Manufacturer!" : "There are no Categories and Figures in the Database!"));
// Get all Categories
$result = dbquery("
SELECT
fc.figure_cat_id, fc.figure_cat_name, COUNT(f.figure_id) AS figure_counter
FROM ".DB_FIGURE_ITEMS." AS f
LEFT JOIN ".DB_FIGURE_CATS." AS fc ON fc.figure_cat_id=f.figure_cat
WHERE
".(multilang_table("FI") ? "f.figure_language='".LANGUAGE."' AND " : "")."
".($this -> manufacturerID ? "f.figure_manufacturer='".$this -> manufacturerID."' AND " : "")."
".($this -> searchText ? "f.figure_title LIKE '%".$this -> searchText."%' AND " : "")."
".($this -> series ? "f.figure_series LIKE '%".$this -> series."%' AND " : "")."
".($this -> variant ? "f.figure_variant LIKE '%".$this -> variant."%' AND " : "")."
".($this -> pubdate ? "f.figure_pubdate LIKE '%".$this -> pubdate."%' AND " : "")."
".($this -> scaleID ? "f.figure_scale='".$this -> scaleID."' AND " : "")."
".($this -> brandID ? "f.figure_brand='".$this -> brandID."' AND " : "")."
".groupaccess("f.figure_visibility")." AND f.figure_freigabe='1'
GROUP BY fc.figure_cat_id
ORDER BY fc.figure_cat_name ASC
");
$info['rows'] = dbrows($result);
// Save Datas to Array
while ($data = dbarray($result)) {
$info['items'][$data['figure_cat_id']] = [
"category-id" => $data['figure_cat_id'],
"category-title" => $data['figure_cat_name'],
"category-counter" => $data['figure_counter'],
"category-link" => FUSION_SELF."?".($this -> searchText ? "searchtext=".$this -> searchText."&" : "").($this -> manufacturerID ? "manufacturer_id=".$this -> manufacturerID."&" : "")."category_id=".$data['figure_cat_id'],
"category-image" => figures_getImagePath("cats", "thumb", $data['figure_cat_id'])
];
}
// Display Template
require_once INFUSIONS."figurelib/templates/category-lists.php";
renderFigurelibCategoriesList($info);
}
// Display a List with all Figures
private function displayFiguresList() {
// Count all Figures
$counter = dbcount("(figure_id)", DB_FIGURE_ITEMS, "
figure_cat='".$this -> categoryID."' AND figure_manufacturer='".$this -> manufacturerID."' AND
".($this -> searchText ? "figure_title LIKE '%".$this -> searchText."%' AND " : "")."
".($this -> series ? "figure_series LIKE '%".$this -> series."%' AND " : "")."
".($this -> pubdate ? "figure_pubdate LIKE '%".$this -> pubdate."%' AND " : "")."
".($this -> variant ? "figure_variant LIKE '%".$this -> variant."%' AND " : "")."
".($this -> scaleID ? "figure_scale='".$this -> scaleID."' AND " : "")."
".($this -> brandID ? "figure_brand='".$this -> brandID."' AND " : "")."
".(multilang_table("FI") ? "figure_language='".LANGUAGE."' AND" : "")."
".groupaccess("figure_visibility")." AND figure_freigabe='1'
");
// Fill Array
$info = ["rows" => $counter, "page-nav" => false, "items" => false, "settings" => $this -> figurelibSettings];
// Get Manufacturer Informations
$dataMan = dbarray(dbquery("
SELECT * FROM ".DB_FIGURE_MANUFACTURERS." WHERE figure_manufacturer_id='".$this -> manufacturerID."' LIMIT 0,1
"));
// Add Manufacturer Informations into Array
$manufacturer= [
"manufacturer-id" => $dataMan['figure_manufacturer_id'],
"manufacturer-name" => $dataMan['figure_manufacturer_name'],
"manufacturer-url" => $dataMan['figure_manufacturer_url'],
"manufacturer-email" => $dataMan['figure_manufacturer_email'],
"manufacturer-facebook" => $dataMan['figure_manufacturer_facebook'],
"manufacturer-twitter" => $dataMan['figure_manufacturer_twitter'],
"manufacturer-youtube" => $dataMan['figure_manufacturer_youtube'],
"manufacturer-pinterest" => $dataMan['figure_manufacturer_pinterest'],
"manufacturer-instagram" => $dataMan['figure_manufacturer_instagram'],
"manufacturer-googleplus" => $dataMan['figure_manufacturer_googleplus'],
"manufacturer-image" => figures_getImagePath("manufacturers", "thumb", $dataMan['figure_manufacturer_id']),
"manufacturer-address" => strip_tags(parse_textarea($dataMan['figure_manufacturer_address'])),
"manufacturer-description" => nl2br(parse_textarea($dataMan['figure_manufacturer_description'])),
"manufacturer-admin-info" => nl2br(parse_textarea($dataMan['figure_manufacturer_info_admin'])),
"manufacturer-admin-edit" => INFUSIONS."figurelib/admin.php".fusion_get_aidlink()."&section=figurelib_manufacturers&action=edit&manufacturer_id=".$this -> manufacturerID
];
// Merge Arrays
$info = array_merge($info, $manufacturer);
// Sitetitle and Breadcrumbs
@list($categoryName) = dbarraynum(dbquery("SELECT figure_cat_name FROM ".DB_FIGURE_CATS." WHERE figure_cat_id='".$this -> categoryID."' LIMIT 0,1"));
add_to_title("» ".$categoryName." » ".$manufacturer['manufacturer-name']." » All Figures");
\PHPFusion\BreadCrumbs::getInstance() -> addBreadCrumb(["link" => INFUSIONS."figurelib/figures.php?category_id=".$this -> categoryID, "title" => $categoryName]);
\PHPFusion\BreadCrumbs::getInstance() -> addBreadCrumb(["link" => INFUSIONS."figurelib/figures.php?manufacturer_id=".$this -> manufacturerID, "title" => $manufacturer['manufacturer-name']]);
// Only do other Actions, if there is a positiv Counter
if ($counter) {
// Check Rowstart
$_GET['rowstart'] = isset($_GET['rowstart']) && isnum($_GET['rowstart']) && $_GET['rowstart'] <= $counter ? $_GET['rowstart'] : 0;
// Get all Figures for these Page
$result = dbquery("
SELECT
f.figure_id, f.figure_title, f.figure_variant, f.figure_pubdate, f.figure_series, f.figure_clickcount, f.figure_datestamp,
fm.figure_manufacturer_name, fm.figure_manufacturer_id,
fb.figure_brand_name, fb.figure_brand_id,
fs.figure_scale_name, fs.figure_scale_id,
fu.user_id, fu.user_name, fu.user_status
FROM ".DB_FIGURE_ITEMS." AS f
LEFT JOIN ".DB_FIGURE_MANUFACTURERS." AS fm ON fm.figure_manufacturer_id=f.figure_manufacturer
LEFT JOIN ".DB_FIGURE_BRANDS." AS fb ON fb.figure_brand_id=f.figure_brand
LEFT JOIN ".DB_FIGURE_SCALES." AS fs ON fs.figure_scale_id=f.figure_scale
LEFT JOIN ".DB_USERS." AS fu ON fu.user_id=f.figure_submitter
WHERE
f.figure_cat='".$this -> categoryID."' AND f.figure_manufacturer='".$this -> manufacturerID."' AND
".($this -> searchText ? "f.figure_title LIKE '%".$this -> searchText."%' AND " : "")."
".($this -> series ? "f.figure_series LIKE '%".$this -> series."%' AND " : "")."
".($this -> variant ? "f.figure_variant LIKE '%".$this -> variant."%' AND " : "")."
".($this -> pubdate ? "f.figure_pubdate LIKE '%".$this -> pubdate."%' AND " : "")."
".($this -> scaleID ? "f.figure_scale='".$this -> scaleID."' AND " : "")."
".($this -> brandID ? "f.figure_brand='".$this -> brandID."' AND " : "")."
".(multilang_table("FI") ? "f.figure_language='".LANGUAGE."' AND" : "")."
".groupaccess("f.figure_visibility")." AND f.figure_freigabe='1'
ORDER BY f.figure_title ASC
LIMIT ".$_GET['rowstart'].",".$this -> figurelibSettings['figure_per_page']."
");
// Do we need a Page Nav?
if ($counter > $this -> figurelibSettings['figure_per_page']) {
$info['page-nav'] = makepagenav(
$_GET['rowstart'], $this -> figurelibSettings['figure_per_page'], $counter, 3,
FUSION_SELF."?".($this -> searchText ? "searchtext=".$this -> searchText."&" : "")."category_id=".$this -> categoryID."&manufacturer_id=".$this -> manufacturerID."&"
);
}
// Add Figure Informations into Array
while ($data = dbarray($result)) {
$drating = dbarray(dbquery("
SELECT
SUM(rating_vote) sum_rating, COUNT(rating_item_id) count_votes
FROM ".DB_RATINGS."
WHERE rating_type='FI' AND rating_item_id='".$data['figure_id']."'
"));
$info['items'][$data['figure_id']] = [
"figure-id" => $data['figure_id'],
"figure-title" => $data['figure_title'],
"figure-scale" => $data['figure_scale_name'],
"figure-brand" => $data['figure_brand_name'],
"figure-series" => $data['figure_series'],
"figure-variant" => $data['figure_variant'],
"figure-pubdate" => $data['figure_pubdate'],
"figure-clicks" => $data['figure_clickcount'],
"figure-datestamp" => $data['figure_datestamp'],
"figure-userid" => $data['user_id'],
"figure-username" => $data['user_name'],
"figure-userstatus" => $data['user_status'],
"figure-image" => figures_getImagePath("figure", "thumb", $data['figure_id']),
"figure-new" => ($data['figure_datestamp'] + 604800 > time() + (fusion_get_settings("timeoffset") * 3600)) ? true : false,
"figure-link" => FUSION_SELF."?figure_id=".$data['figure_id'],
"figure-usercount" => dbcount("(figure_userfigures_id)", DB_FIGURE_USERFIGURES, "figure_userfigures_figure_id='".$data['figure_id']."'"),
"figure-commentcount" => dbcount("(comment_id)", DB_COMMENTS, "comment_type='FI' AND comment_item_id='".$data['figure_id']."'"),
"figure-rating-sum" => $drating['sum_rating'],
"figure-rating-count" => $drating['count_votes'],
"figure-admin-editlink" => ""
];
}
}
// Display Template
require_once INFUSIONS."figurelib/templates/figure-lists.php";
renderFigurelibFiguresList($info, $this -> listview);
}
// Display Details of a Figure
private function displayFigureDetails() {
// Get Figure
$result = dbquery("
SELECT
f.figure_id, f.figure_title, f.figure_variant, f.figure_artists, f.figure_country, f.figure_series, f.figure_status, f.figure_pubdate, f.figure_retailprice, f.figure_usedprice, f.figure_hand_painted, f.figure_color, f.figure_hand_cast, f.figure_hand_finished, f.figure_numbered, f.figure_signature, f.figure_certificate, f.figure_accessories, f.figure_description, f.figure_datestamp, f.figure_clickcount, f.figure_editionsize, f.figure_credits,
f.figure_upc, f.figure_ean, f.figure_jan, f.figure_isbn, f.figure_itf14, f.figure_asin, f.figure_ebay_item_id,
f.figure_weight, f.figure_videourl, f.figure_forum_url, f.figure_eshop,
f.figure_affiliate_various_1, f.figure_affiliate_various_2, f.figure_affiliate_various_3, f.figure_affiliate_various_4, f.figure_affiliate_various_5, f.figure_affiliate_various_6, f.figure_affiliate_various_7, f.figure_affiliate_various_8, f.figure_affiliate_various_9, f.figure_affiliate_various_10,
f.figure_affiliate_ebay_1, f.figure_affiliate_ebay_2, f.figure_affiliate_ebay_3, f.figure_affiliate_ebay_4, f.figure_affiliate_ebay_5, f.figure_affiliate_ebay_6, f.figure_affiliate_ebay_7, f.figure_affiliate_ebay_8, f.figure_affiliate_ebay_9, f.figure_affiliate_ebay_10,
f.figure_amazon_de, f.figure_amazon_uk, f.figure_amazon_fr, f.figure_amazon_es, f.figure_amazon_it, f.figure_amazon_jp, f.figure_amazon_com, f.figure_amazon_ca,
f.figure_show_images, f.figure_show_data, f.figure_show_videos, f.figure_show_affiliates_various, f.figure_show_affiliates_amazon, f.figure_show_affiliates_ebay,
f.figure_show_collection, f.figure_show_related, f.figure_show_comments, f.figure_show_ratings, f.figure_show_social_sharing,
fc.figure_cat_id, fc.figure_cat_name,
fm.figure_manufacturer_id, fm.figure_manufacturer_name,
fb.figure_brand_id, fb.figure_brand_name,
fs.figure_scale_id, fs.figure_scale_name,
fl.figure_limitation_id, fl.figure_limitation_name,
fp.figure_poa_id, fp.figure_poa_name,
fpa.figure_packaging_id, fpa.figure_packaging_name,
fma.figure_material_id, fma.figure_material_name,
fcol.figure_color_id, fcol.figure_color_name,
fstat.figure_status_id, fstat.figure_status_name,
fsig.figure_signature_id, fsig.figure_signature_name,
foptn.figure_option_id AS figure_numbered_id, foptn.figure_option_name AS figure_numbered_name,
foptc.figure_option_id AS figure_certificate_id, foptc.figure_option_name AS figure_certificate_name,
fopthc.figure_option_id AS figure_hand_cast_id, fopthc.figure_option_name AS figure_hand_cast_name,
fopthp.figure_option_id AS figure_hand_painted_id, fopthp.figure_option_name AS figure_hand_painted_name,
fopthf.figure_option_id AS figure_hand_finished_id, fopthf.figure_option_name AS figure_hand_finished_name,
fh.figure_measurements_id AS figure_height_id, fh.figure_measurements_inch AS figure_height_name,
fw.figure_measurements_id AS figure_width_id, fw.figure_measurements_inch AS figure_width_name,
fd.figure_measurements_id AS figure_depth_id, fd.figure_measurements_inch AS figure_depth_name,
fu.user_id, fu.user_name, fu.user_status, fu.user_avatar
FROM ".DB_FIGURE_ITEMS." AS f
LEFT JOIN ".DB_FIGURE_CATS." AS fc ON f.figure_cat=fc.figure_cat_id
LEFT JOIN ".DB_FIGURE_MANUFACTURERS." AS fm ON f.figure_manufacturer=fm.figure_manufacturer_id
LEFT JOIN ".DB_FIGURE_BRANDS." AS fb ON f.figure_brand=fb.figure_brand_id
LEFT JOIN ".DB_FIGURE_SCALES." AS fs ON f.figure_scale=fs.figure_scale_id
LEFT JOIN ".DB_FIGURE_LIMITATIONS." AS fl ON f.figure_limitation=fl.figure_limitation_id
LEFT JOIN ".DB_FIGURE_POAS." AS fp ON f.figure_poa=fp.figure_poa_id
LEFT JOIN ".DB_FIGURE_PACKAGINGS." AS fpa ON f.figure_packaging=fpa.figure_packaging_id
LEFT JOIN ".DB_FIGURE_MATERIALS." AS fma ON f.figure_material=fma.figure_material_id
LEFT JOIN ".DB_FIGURE_COLORS." AS fcol ON f.figure_color=fcol.figure_color_id
LEFT JOIN ".DB_FIGURE_STATUS." AS fstat ON f.figure_status=fstat.figure_status_id
LEFT JOIN ".DB_FIGURE_SIGNATURES." AS fsig ON f.figure_signature=fsig.figure_signature_id
LEFT JOIN ".DB_FIGURE_OPTIONS." AS foptn ON f.figure_numbered=foptn.figure_option_id
LEFT JOIN ".DB_FIGURE_OPTIONS." AS foptc ON f.figure_certificate=foptc.figure_option_id
LEFT JOIN ".DB_FIGURE_OPTIONS." AS fopthc ON f.figure_hand_cast=fopthc.figure_option_id
LEFT JOIN ".DB_FIGURE_OPTIONS." AS fopthp ON f.figure_hand_painted=fopthp.figure_option_id
LEFT JOIN ".DB_FIGURE_OPTIONS." AS fopthf ON f.figure_hand_finished=fopthf.figure_option_id
LEFT JOIN ".DB_FIGURE_MEASUREMENTS." AS fh ON f.figure_height=fh.figure_measurements_id
LEFT JOIN ".DB_FIGURE_MEASUREMENTS." AS fw ON f.figure_width=fw.figure_measurements_id
LEFT JOIN ".DB_FIGURE_MEASUREMENTS." AS fd ON f.figure_depth=fd.figure_measurements_id
LEFT JOIN ".DB_USERS." AS fu ON f.figure_submitter=fu.user_id
".(multilang_table("FI") ? "WHERE f.figure_language='".LANGUAGE."' AND" : "WHERE")." f.figure_freigabe='1'
AND f.figure_id='".$this -> figureID."'
");
// Check if Figure exists
if (dbrows($result)) {
$data = dbarray($result);
} else {
redirect(BASEDIR."index.php");
}
// Update Counter and correct "at the Moment"-View
dbquery("UPDATE ".DB_FIGURE_ITEMS." SET figure_clickcount=figure_clickcount+1 WHERE figure_id='".$this -> figureID."'");
$data['figure_clickcount']++;
// Figure Array
$figureArray = [
// General Informations
"general" => [
// Main Info
"id" => $data['figure_id'],
"title" => $data['figure_title'],
"variant" => $data['figure_variant'],
"artists" => $data['figure_artists'],
"country" => figures_getCountryName($data['figure_country']),
"series" => $data['figure_series'],
"pubdate" => $data['figure_pubdate'],
"retail-price" => $data['figure_retailprice'],
"used-price" => $data['figure_usedprice'],
"datestamp" => $data['figure_datestamp'],
"clicks" => $data['figure_clickcount'],
"edition" => $data['figure_editionsize'],
"credits" => $data['figure_credits'],
"weight" => $data['figure_weight'],
// Accessories and Description
"accessories" => parse_textarea($data['figure_accessories']),
"description" => parse_textarea($data['figure_description']),
// Images
"images" => figures_getImagePath("figures", "", $this -> figureID, "all"),
// Categories
"category-id" => $data['figure_cat_id'],
"category-name" => $data['figure_cat_name'],
// Manufacturers
"manufacturer-id" => $data['figure_manufacturer_id'],
"manufacturer-name" => $data['figure_manufacturer_name'],
// Brands
"brand-id" => $data['figure_brand_id'],
"brand-name" => $data['figure_brand_name'],
// Scales
"scale-id" => $data['figure_scale_id'],
"scale-name" => $data['figure_scale_name'],
// Limitations
"limitation-id" => $data['figure_limitation_id'],
"limitation-name" => $data['figure_limitation_name'],
// Poas
"poa-id" => $data['figure_poa_id'],
"poa-name" => $data['figure_poa_name'],
// Packaging
"packaging-id" => $data['figure_packaging_id'],
"packaging-name" => $data['figure_packaging_name'],
// Materials
"material-id" => $data['figure_material_id'],
"material-name" => $data['figure_material_name'],
// Sizes
"width-id" => $data['figure_width_id'],
"height-id" => $data['figure_height_id'],
"depth-id" => $data['figure_depth_id'],
"width-name" => $data['figure_width_name'],
"height-name" => $data['figure_height_name'],
"depth-name" => $data['figure_depth_name'],
// Colors
"color-id" => $data['figure_color_id'],
"color-name" => $data['figure_color_name'],
// Status
"status-id" => $data['figure_status_id'],
"status-name" => $data['figure_status_name'],
// Signatures
"signature-id" => $data['figure_signature_id'],
"signature-name"=> $data['figure_signature_name'],
// Options
"numbered-id" => $data['figure_numbered_id'],
"certificate-id" => $data['figure_certificate_id'],
"hand-cast-id" => $data['figure_hand_cast_id'],
"hand-painted-id" => $data['figure_hand_painted_id'],
"hand-finished-id" => $data['figure_hand_finished_id'],
"numbered-name" => $data['figure_numbered_name'],
"certificate-name" => $data['figure_certificate_name'],
"hand-cast-name" => $data['figure_hand_cast_name'],
"hand-painted-name" => $data['figure_hand_painted_name'],
"hand-finished-name" => $data['figure_hand_finished_name'],
// Submitter
"user-id" => $data['user_id'],
"user-name" => $data['user_name'],
"user-status" => $data['user_status'],
"user-avatar" => $data['user_avatar'],
// Product Numbers
"figure-upc" => $data['figure_upc'],
"figure-ean" => $data['figure_ean'],
"figure-jan" => $data['figure_jan'],
"figure-isbn" => $data['figure_isbn'],
"figure-itf14" => $data['figure_itf14'],
"figure-asin" => $data['figure_asin'],
"figure-ebay-item-id" => $data['figure_ebay_item_id'],
// Adminlinks
"adminlink-figure" => "",
"adminlink-manufacturer" => INFUSIONS."figurelib/admin",
"adminlink-category" => INFUSIONS."figurelib/admin/",
"adminlink-settings" => ""
#echo " <a class='fa fa-cog' href='".INFUSIONS."figurelib/admin.php".$aidlink."&section=figurelib_brands&action=edit&brand_id=".$data['figure_brand']."'></a> ";
],
// Affiliates Informations
"affiliates" => [
"video-url" => $data['figure_videourl'],
"forum-url" => $data['figure_forum_url'],
"eshop-url" => $data['figure_eshop'],
"amazon-de" => $data['figure_amazon_de'],
"amazon-uk" => $data['figure_amazon_uk'],
"amazon-fr" => $data['figure_amazon_fr'],
"amazon-es" => $data['figure_amazon_es'],
"amazon-it" => $data['figure_amazon_it'],
"amazon-jp" => $data['figure_amazon_jp'],
"amazon-ca" => $data['figure_amazon_ca'],
"amazon-com" => $data['figure_amazon_com'],
"affiliate-various-1" => parse_textarea($data['figure_affiliate_various_1']),
"affiliate-various-2" => parse_textarea($data['figure_affiliate_various_2']),
"affiliate-various-3" => parse_textarea($data['figure_affiliate_various_3']),
"affiliate-various-4" => parse_textarea($data['figure_affiliate_various_4']),
"affiliate-various-5" => parse_textarea($data['figure_affiliate_various_5']),
"affiliate-various-6" => parse_textarea($data['figure_affiliate_various_6']),
"affiliate-various-7" => parse_textarea($data['figure_affiliate_various_7']),
"affiliate-various-8" => parse_textarea($data['figure_affiliate_various_8']),
"affiliate-various-9" => parse_textarea($data['figure_affiliate_various_9']),
"affiliate-various-10" => parse_textarea($data['figure_affiliate_various_10']),
"affiliate-ebay-1" => parse_textarea($data['figure_affiliate_ebay_1']),
"affiliate-ebay-2" => parse_textarea($data['figure_affiliate_ebay_2']),
"affiliate-ebay-3" => parse_textarea($data['figure_affiliate_ebay_3']),
"affiliate-ebay-4" => parse_textarea($data['figure_affiliate_ebay_4']),
"affiliate-ebay-5" => parse_textarea($data['figure_affiliate_ebay_5']),
"affiliate-ebay-6" => parse_textarea($data['figure_affiliate_ebay_6']),
"affiliate-ebay-7" => parse_textarea($data['figure_affiliate_ebay_7']),
"affiliate-ebay-8" => parse_textarea($data['figure_affiliate_ebay_8']),
"affiliate-ebay-9" => parse_textarea($data['figure_affiliate_ebay_9']),
"affiliate-ebay-10" => parse_textarea($data['figure_affiliate_ebay_10'])
],
// Display Informations
"settings" => [
"show-data" => $data['figure_show_data'],
"show-videos" => $data['figure_show_videos'],
"show-images" => $data['figure_show_images'],
"show-collection" => $data['figure_show_collection'],
"show-related" => $data['figure_show_related'],
"show-sharing" => $data['figure_show_social_sharing'],
"show-comments" => $data['figure_show_comments'],
"show-ratings" => $data['figure_show_ratings'],
"show-affiliates-amazon" => $data['figure_show_affiliates_amazon'],
"show-affiliates-ebay" => $data['figure_show_affiliates_ebay'],
"show-affiliates-various" => $data['figure_show_affiliates_various'],
]
];
// Get all Users with this Figure
$result2 = dbquery("
SELECT
u.user_id, u.user_name, u.user_status, u.user_avatar
FROM ".DB_FIGURE_USERFIGURES." AS f
LEFT JOIN ".DB_USERS." AS u ON u.user_id=f.figure_userfigures_user_id
WHERE f.figure_userfigures_figure_id='".$this -> figureID."'
");
$usersArray = [];
// Fill Array
if (dbrows($result2)) {
while ($data2 = dbarray($result2)) {
$usersArray[] = ["user-id" => $data2['user_id'], "user-name" => $data2['user_name'], "user-status" => $data2['user_status'], "user-avatar" => $data2['user_avatar']];
}
}
// Get all similar Figures (max. 5 Items)
$result3 = dbquery("
SELECT
f.figure_id, f.figure_title, f.figure_datestamp,
fc.figure_cat_id, fc.figure_cat_name,
fm.figure_manufacturer_id, fm.figure_manufacturer_name
FROM ".DB_FIGURE_ITEMS." AS f
LEFT JOIN ".DB_FIGURE_CATS." fc ON f.figure_cat=fc.figure_cat_id
LEFT JOIN ".DB_FIGURE_MANUFACTURERS." fm ON f.figure_manufacturer=fm.figure_manufacturer_id
WHERE
MATCH (f.figure_title) AGAINST ('".$data['figure_title']."' IN BOOLEAN MODE)
AND f.figure_id != '".$this -> figureID."'
AND ".groupaccess("f.figure_visibility")."
AND f.figure_freigabe='1'
ORDER BY RAND()
LIMIT 0,5
");
$similarArray = [];
// Fill Array
if (dbrows($result3)) {
while ($data3 = dbarray($result3)) {
// Rating Informations
$data3b = dbarray(dbquery("
SELECT
SUM(rating_vote) AS sum_rating, COUNT(rating_item_id) AS count_votes
FROM ".DB_RATINGS."
WHERE rating_item_id='".$this -> figureID."' AND rating_type='FI'
"));
$similarArray[] = [
// Main
"id" => $data3['figure_id'],
"title" => $data3['figure_title'],
"datestamp" => $data3['figure_datestamp'],
"link" => FUSION_SELF."?figure_id=".$data3['figure_id'],
// Categories
"category-id" => $data3['figure_cat_id'],
"category-name" => $data3['figure_cat_name'],
// Manufacturers
"manufacturer-id" => $data3['figure_manufacturer_id'],
"manufacturer-name" => $data3['figure_manufacturer_name'],
// Ratings
"rating-sum" => $data3b['sum_rating'],
"rating-votes" => $data3b['count_votes']
];
}
}
// Load Comments and Ratings
require_once INCLUDES."comments_include.php";
require_once INCLUDES."ratings_include.php";
// Save into Variable
ob_start();
showcomments("FI", DB_FIGURE_ITEMS, "figure_id", $this -> figureID, FUSION_SELF."?figure_id=".$this -> figureID);
$comments = ob_get_contents();
ob_end_clean();
ob_start();
showratings("FI", $this -> figureID, FUSION_SELF."?figure_id=".$this -> figureID);
$ratings = ob_get_contents();
ob_end_clean();
// Build Display Array
$displayArray = [
"comments" => $comments,
"ratings" => $ratings
];
// Build Social Array
$mainLink = fusion_get_settings("siteurl")."infusions/figurelib/figures.php?figure_id=".$this -> figureID;
$socialArray = [
"facebook" => "http://www.facebook.com/share.php?u=".$mainLink,
"twitter" => "http://www.twitter.com/share?url=".$mainLink,
"digg" => "http://www.digg.com/submit?url=".$mainLink,
"reddit" => "http://www.reddit.com/submit?url=".$mainLink,
"delicious" => "http://del.icio.us/post?url=".$mainLink,
];
// Build Master Array
$masterArray = [
"settings" => $this -> figurelibSettings,
"figure" => $figureArray,
"users" => $usersArray,
"similar" => $similarArray,
"socials" => $socialArray,
"display" => $displayArray
];
// Add Meta Tags Facebook
add_to_head("<meta property='og:url' content='".fusion_get_settings("siteurl")."infusions/figurelib/figures.php?figure_id=".$masterArray['figure']['general']['id']."' />");
add_to_head("<meta property='og:type' content='article' />");
add_to_head("<meta property='og:title' content='".$masterArray['figure']['general']['title']."' />");
add_to_head("<meta property='og:description' content='".strip_tags($masterArray['figure']['general']['description'])."' />");
if (!empty($masterArray['figure']['general']['images'])) {
add_to_head("<meta property='og:image' content='".$masterArray['figure']['general']['images'][0]['image-full']."' />");
}
// Add Meta Tags Twitter
add_to_head("<meta name='twitter:card' content='summary' />");
add_to_head("<meta name='twitter:url' content='".fusion_get_settings("siteurl")."infusions/figurelib/figures.php?figure_id=".$masterArray['figure']['general']['id']."' />");
add_to_head("<meta name='twitter:title' content='".$masterArray['figure']['general']['title']."' />");
add_to_head("<meta name='twitter:description' content='".strip_tags($masterArray['figure']['general']['description'])."' />");
if (!empty($masterArray['figure']['general']['images'])) {
add_to_head("<meta name='twitter:image' content='".$masterArray['figure']['general']['images'][0]['image-full']."' />");
}
// Sitetitle and Breadcrumbs
add_to_title(" » ".$masterArray['figure']['general']['category-name']." » ".$masterArray['figure']['general']['manufacturer-name']." » ".$masterArray['figure']['general']['title']."");
\PHPFusion\BreadCrumbs::getInstance() -> addBreadCrumb(["link" => INFUSIONS."figurelib/figures.php?category_id=".$masterArray['figure']['general']['category-id'], "title" => $masterArray['figure']['general']['category-name']]);
\PHPFusion\BreadCrumbs::getInstance() -> addBreadCrumb(["link" => INFUSIONS."figurelib/figures.php?manufacturer_id=".$masterArray['figure']['general']['manufacturer-id'], "title" => $masterArray['figure']['general']['manufacturer-name']]);
\PHPFusion\BreadCrumbs::getInstance() -> addBreadCrumb(["link" => INFUSIONS."figurelib/figures.php?figure_id=".$masterArray['figure']['general']['id'], "title" => $masterArray['figure']['general']['title']]);
// Display Template
require_once INFUSIONS."figurelib/templates/figure-details.php";
renderFigurelibFigureDetails($masterArray);
}
// Display Sorting Options
private function displaySortingMethods() {
// Get all Series
$resultSeries = dbquery("
SELECT
fs.figure_series
FROM ".DB_FIGURE_ITEMS." AS fs
WHERE
".(multilang_table("FI") ? "fs.figure_language='".LANGUAGE."' AND " : "")."
".groupaccess("fs.figure_visibility")." AND fs.figure_freigabe='1' AND fs.figure_series != ''
GROUP BY fs.figure_series
ORDER BY fs.figure_series ASC
");
$seriesArray = [];
// Build Series Array
if (dbrows($resultSeries)) {
while ($dataSeries = dbarray($resultSeries)) {
$seriesArray[$dataSeries['figure_series']] = $dataSeries['figure_series'];
}
}
// Get all Variant
$resultVariant = dbquery("
SELECT
fv.figure_variant
FROM ".DB_FIGURE_ITEMS." AS fv
WHERE
".(multilang_table("FI") ? "fv.figure_language='".LANGUAGE."' AND " : "")."
".groupaccess("fv.figure_visibility")." AND fv.figure_freigabe='1' AND fv.figure_variant != ''
GROUP BY fv.figure_variant
ORDER BY fv.figure_variant ASC
");
$variantArray = [];
// Build Variant Array
if (dbrows($resultVariant)) {
while ($dataVariant = dbarray($resultVariant)) {
$variantArray[$dataVariant['figure_variant']] = $dataVariant['figure_variant'];
}
}
// Get all Pubdates
$resultPubdates = dbquery("
SELECT
fp.figure_pubdate
FROM ".DB_FIGURE_ITEMS." AS fp
WHERE
".(multilang_table("FI") ? "fp.figure_language='".LANGUAGE."' AND " : "")."
".groupaccess("fp.figure_visibility")." AND fp.figure_freigabe='1' AND fp.figure_pubdate != ''
GROUP BY fp.figure_pubdate
ORDER BY fp.figure_pubdate ASC
");
$pubdatesArray = [];
// Build Pubdates Array
if (dbrows($resultPubdates)) {
while ($dataPubdates = dbarray($resultPubdates)) {
$pubdatesArray[$dataPubdates['figure_pubdate']] = $dataPubdates['figure_pubdate'];
}
}
// Get all Brands
$resultBrands = dbquery("
SELECT
fb.figure_brand_id, fb.figure_brand_name
FROM ".DB_FIGURE_ITEMS." AS f
LEFT JOIN ".DB_FIGURE_BRANDS." AS fb ON fb.figure_brand_id=f.figure_brand
WHERE
".(multilang_table("FI") ? "f.figure_language='".LANGUAGE."' AND " : "")."
".groupaccess("f.figure_visibility")." AND f.figure_freigabe='1' AND f.figure_brand != ''
GROUP BY fb.figure_brand_id
ORDER BY fb.figure_brand_name ASC
");
$brandsArray = [];
// Build Brands Array
if (dbrows($resultBrands)) {
while ($dataBrands = dbarray($resultBrands)) {
$brandsArray[$dataBrands['figure_brand_id']] = $dataBrands['figure_brand_name'];
}
}
// Get all Scales
$resultScales = dbquery("
SELECT
fs.figure_scale_id, fs.figure_scale_name
FROM ".DB_FIGURE_ITEMS." AS f
LEFT JOIN ".DB_FIGURE_SCALES." AS fs ON fs.figure_scale_id=f.figure_scale
WHERE
".(multilang_table("FI") ? "f.figure_language='".LANGUAGE."' AND " : "")."
".groupaccess("f.figure_visibility")." AND f.figure_freigabe='1' AND f.figure_scale != ''
GROUP BY fs.figure_scale_id
ORDER BY fs.figure_scale_name ASC
");
$scalesArray = [];
// Build Scales Array
if (dbrows($resultScales)) {
while ($dataScales = dbarray($resultScales)) {
$scalesArray[$dataScales['figure_scale_id']] = $dataScales['figure_scale_name'];
}
}
// Select change
add_to_jquery("
// Thanks to Fredrick Chan at PHP-Fusion.co.uk! ;)
$('#filter-button').bind('click', function(e) {
e.preventDefault();
$('#filter-div').slideToggle();
var caret_status = $('#filter-button i').hasClass('fa-caret-down');
if (caret_status == 1) {
$('#filter-button i').removeClass('fa-caret-down').addClass('fa-caret-up');
$(this).removeClass('btn-primary').addClass('btn-default');
} else {
$('#filter-button i').removeClass('fa-caret-up').addClass('fa-caret-down');
$(this).removeClass('btn-default').addClass('btn-primary');
}
});
$('#brand_id, #scale_id, #series, #variant, #pubdate').bind('change', function(e){
$(this).closest('form').submit();
});
");
// Build Mainlink
$mainLink = FUSION_SELF."?";
$mainLink .= ($this -> categoryID ? "category_id=".$this -> categoryID."&" : "");
$mainLink .= ($this -> manufacturerID ? "manufacturer_id=".$this -> manufacturerID."&" : "");
$mainLink .= ($this -> brandID ? "brand_id=".$this -> brandID."&" : "");
$mainLink .= ($this -> scaleID ? "scale_id=".$this -> scaleID."&" : "");
$mainLink .= ($this -> searchText ? "searchtext=".$this -> searchText."&" : "");
$mainLink .= ($this -> series ? "series=".$this -> series."&" : "");
$mainLink .= ($this -> variant ? "variant=".$this -> variant."&" : "");
$mainLink .= ($this -> pubdate ? "pubdate=".$this -> pubdate."&" : "");
// Build Master Array for Display
$masterArray = [
// Current Values
"current-values" => [
"listmode" => $this -> listmode,
"listview" => $this -> listview,
"searchtext" => $this -> searchText,
"manufacturer-id" => $this -> manufacturerID,
"category-id" => $this -> categoryID,
"brand-id" => $this -> brandID,
"scale-id" => $this -> scaleID,
"series" => $this -> series,
"variant" => $this -> variant,
"pubdate" => $this -> pubdate,
"filter-active" => ($this -> brandID || $this -> scaleID || $this -> series || $this -> variant || $this -> pubdate) ? true : false
],
// Avaiable Options
"avaible-options" => [
"brands" => $brandsArray,
"scales" => $scalesArray,
"series" => $seriesArray,
"variants" => $variantArray,
"pubdates" => $pubdatesArray
],
// Button Links
"button-links" => [
"list-mode-categories" => $mainLink."listmode=by-categories",
"list-mode-manufacturers" => $mainLink."listmode=by-manufacturers",
"list-view-list" => $mainLink."listview=as-list",
"list-view-gallery" => $mainLink."listview=as-gallery"
],
// Settings
"settings" => $this -> figurelibSettings
];
// Display Template
require_once INFUSIONS."figurelib/templates/figure-sorting-options.php";
renderFigurelibSortingOptions($masterArray);
}
// Display Output
public function displayFigurelib() {
// Render Output
ob_start();
// Display a Figure
if ($this -> figureID) {
$this -> displayFigureDetails();
// Display List
} else {
// Display Sorting
$this -> displaySortingMethods();
// Display list by Categories
if ($this -> listmode == "by-categories") {
// Display Figures
if ($this -> categoryID && $this -> manufacturerID) {
$this -> displayFiguresList();
// Display Manufacturers
} elseif ($this -> categoryID && !$this -> manufacturerID) {
$this -> displayManufacturersList();
// Sitetitle
@list($categoryName) = dbarraynum(dbquery("SELECT figure_cat_name FROM ".DB_FIGURE_CATS." WHERE figure_cat_id='".$this -> categoryID."' LIMIT 0,1"));
add_to_title("» ".$categoryName." » All Manufacturers");
\PHPFusion\BreadCrumbs::getInstance() -> addBreadCrumb(["link" => INFUSIONS."figurelib/figures.php?category_id=".$this -> categoryID, "title" => $categoryName]);
// Display Categories
} else {
$this -> displayCategoriesList();
}
// Display list by Manufacturers
} elseif ($this -> listmode == "by-manufacturers") {
// Display Figures
if ($this -> categoryID && $this -> manufacturerID) {
$this -> displayFiguresList();
// Display Categories
} elseif ($this -> manufacturerID && !$this -> categoryID) {
$this -> displayCategoriesList();
// Sitetitle
@list($manufacturerName) = dbarraynum(dbquery("SELECT figure_manufacturer_name FROM ".DB_FIGURE_MANUFACTURERS." WHERE figure_manufacturer_id='".$this -> manufacturerID."' LIMIT 0,1"));
add_to_title("» ".$manufacturerName." » All Categories");
\PHPFusion\BreadCrumbs::getInstance() -> addBreadCrumb(["link" => INFUSIONS."figurelib/figures.php?manufacturer_id=".$this -> manufacturerID, "title" => $manufacturerName]);
// Display Manufacturers
} else {
$this -> displayManufacturersList();
}
}
}
// Render Output
$figurelibOutput = ob_get_contents();
ob_end_clean();
// Display Output
echo render_breadcrumbs();
echo $figurelibOutput;
}}
?>`
DavidGuetl
wie erwähnt habe ich das komplette AFFILATE System umgebaut folgendes ist neu bzw geändert: zu jeder Figur kann jetzt folgendes noch zusätzkich abgespeichert werden
das sind:
diese "Nummern" sind bei Affilate immer wichtig und auch um die Figure eindeutig zu indentifizieren. ok die abzuspeichern klappt.
jetzt habe ich die Felder
zu tinyint gemacht weil ich jetzt nur ankreuzen will ob das amazon land freigeschalten ist oder nicht. Hintergrund ist ,,,, die ASIN ist immer gleich ... weltweit. Da wäre es Blödsinn die immer 8 mal abzuspeichern.
da habe ich aber einen Fehler
in der classes datei habe ich alles umgebaut aber der code wird nicht ausgführt. es wird nur die ASIN angezeigt aber nicht code drumherum
hier der umbau: in der classes: unter [general] habe ich engebaut
in [affilates]
und hier der code den ich den view figure ausführen will:
es wird aber nur die ASIN angezeigt . nicht der code (also das widget)