<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright © 2002 - 2011 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: infusion.php
| Author: Khalid545
| URL: http://khalidb.co.cc/
| E-Mail: khalidd545@gmail.com
|
| Modification: Catzenjaeger
| URL: www.aliencollectors.com
| E-Mail: admin@aliencollectors.com
+--------------------------------------------------------+
| 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).
+--------------------------------------------------------*/
if (!defined("IN_FUSION")) { die("Access Denied"); }
include "infusion_db.php";
$inf_title = $locale['INF_TITLE'];
$inf_description = $locale['INF_DESC'];
$inf_developer = "Khalid545";
$inf_email = "khalidd545@gmail.com";
$inf_weburl = "http://khalidb.co.cc/";
$inf_newtable[1] = DB_FIGURE_CATS." (
figure_cat_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_cat_name varchar(100) NOT NULL DEFAULT '',
figure_cat_description text NOT NULL,
figure_cat_sorting varchar(50) NOT NULL DEFAULT 'download_title ASC',
figure_cat_access tinyint(3) unsigned NOT NULL DEFAULT '0',
figure_cat_parent mediumint(8) unsigned NOT NULL DEFAULT '0',
figure_cat_items int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (figure_cat_id)
) ENGINE=MyISAM;";
$inf_droptable[1] = DB_FIGURE_CATS;
$inf_newtable[2] = DB_FIGURE." (
figure_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
figure_title varchar(200) NOT NULL DEFAULT '',
figure_submanufacturer varchar(200) NOT NULL DEFAULT '',
figure_brand varchar(200) NOT NULL DEFAULT '',
figure_series varchar(200) NOT NULL DEFAULT '',
figure_variant varchar(200) NOT NULL DEFAULT '',
figure_scale varchar(200) NOT NULL DEFAULT '',
figure_weight varchar(200) NOT NULL DEFAULT '',
figure_height varchar(200) NOT NULL DEFAULT '',
figure_width varchar(200) NOT NULL DEFAULT '',
figure_depth varchar(200) NOT NULL DEFAULT '',
figure_material varchar(200) NOT NULL DEFAULT '',
figure_packaging varchar(200) NOT NULL DEFAULT '',
figure_retailprice varchar(200) NOT NULL DEFAULT '',
figure_limitation varchar(200) NOT NULL DEFAULT '',
figure_editionsize varchar(200) NOT NULL DEFAULT '',
figure_artists varchar(200) NOT NULL DEFAULT '',
figure_cat mediumint(8) unsigned NOT NULL DEFAULT '0',
figure_description text NOT NULL,
figure_url varchar(200) NOT NULL DEFAULT '',
figure_file varchar(100) NOT NULL DEFAULT '',
figure_image varchar(100) NOT NULL DEFAULT '',
figure_name mediumint(8) unsigned NOT NULL DEFAULT '1',
figure_filesize varchar(20) NOT NULL DEFAULT '',
figure_datestamp int(10) unsigned NOT NULL DEFAULT '0',
figure_author varchar(200) NOT NULL DEFAULT '',
figure_country varchar(200) NOT NULL DEFAULT '',
figure_manufacturer varchar(200) NOT NULL DEFAULT '',
figure_pubdate varchar(200) NOT NULL DEFAULT '',
figure_count int(10) unsigned NOT NULL DEFAULT '0',
figure_allow_comments tinyint(1) unsigned NOT NULL DEFAULT '1',
figure_allow_ratings tinyint(1) unsigned NOT NULL DEFAULT '1',
KEY figure_datestamp (figure_datestamp),
KEY figure_count (figure_count),
PRIMARY KEY (figure_id)
) ENGINE=MyISAM;";
$inf_droptable[2] = DB_FIGURE;
$inf_newtable[3] = DB_FIGURE_SETTINGS." (
figure_settings_name varchar(200) NOT NULL DEFAULT '',
figure_settings_value text NOT NULL
) ENGINE=MyISAM;";
$inf_droptable[3] = DB_FIGURE_SETTINGS;
$inf_newtable[4] = DB_FIGURE_SUBMISSIONS." (
submit_id mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
submit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
submit_datestamp INT(10) UNSIGNED DEFAULT '0' NOT NULL,
submit_criteria TEXT NOT NULL,
PRIMARY KEY (submit_id)
) ENGINE=MyISAM;";
$inf_droptable[4] = DB_FIGURE_SUBMISSIONS;
$inf_newtable[5] = DB_FIGURE_REPORTS." (
report_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
report_datestamp int(10) unsigned NOT NULL DEFAULT '0',
report_name varchar(50) NOT NULL DEFAULT '1',
report_ip varchar(20) NOT NULL DEFAULT '0.0.0.0',
report_figure mediumint(8) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (report_id)
) ENGINE=MyISAM;";
$inf_droptable[5] = DB_FIGURE_REPORTS;
$inf_insertdbrow[1] = DB_FIGURE_SETTINGS." VALUES ('figure_max_b','150000');";
$inf_insertdbrow[2] = DB_FIGURE_SETTINGS." VALUES ('figure_per_page','10');";
$inf_insertdbrow[3] = DB_FIGURE_SETTINGS." VALUES ('figure_types','.pdf,.doc,.html,.htm,.prc,.pdb,.zip,.rar');";
$inf_insertdbrow[4] = DB_FIGURE_SETTINGS." VALUES ('figure_submit','1');";
$inf_insertdbrow[5] = DB_FIGURE_SETTINGS." VALUES ('guestdownload','1');";
$inf_insertdbrow[6] = DB_FIGURE_SETTINGS." VALUES ('subcats','0');";
$inf_insertdbrow[7] = DB_FIGURE_SETTINGS." VALUES ('display','0');";
$inf_insertdbrow[8] = DB_FIGURE_SETTINGS." VALUES ('figure_per_line','2');";
$inf_insertdbrow[9] = DB_FIGURE_SETTINGS." VALUES ('social_sharing','1');";
$inf_insertdbrow[10] = DB_FIGURE_SETTINGS." VALUES ('related','1');";
$inf_altertable[1] = DB_FIGURE_CATS." ADD figure_cat_parent mediumint(8) unsigned NOT NULL DEFAULT '0'";
$inf_altertable[2] = DB_FIGURE." ADD figure_country varchar(200) NOT NULL DEFAULT ''";
$inf_altertable[3] = DB_FIGURE_CATS." ADD figure_cat_items int(10) unsigned NOT NULL DEFAULT '0'";
if (isset($_GET['defuse']) && isnum($_GET['defuse'])) {
$result = dbquery("DELETE FROM ".DB_BCOMMENTS." WHERE comment_type='BO'");
$result = dbquery("DELETE FROM ".DB_RATINGS." WHERE rating_type='B'");
}
$inf_sitelink[1] = array(
"title" => $locale['INF_TITLE'],
"url" => "figure.php",
"visibility" => "0"
);
$inf_sitelink[2] = array(
"title" => $locale['figure_521'],
"url" => "submit.php",
"visibility" => "101"
);
$inf_adminpanel[1] = array(
"title" => $locale['INF_ADMIN'],
"image" => "image.gif",
"panel" => "figure_admin.php",
"rights" => "BOL"
);
?>