what language are you using?
need you to try these new files please
5.php
Code:
<?php
/*
*-------------------------------phpMyBitTorrent--------------------------------*
*--- The Ultimate BitTorrent Tracker and BMS (Bittorrent Management System) ---*
*-------------- Created By Antonio Anzivino (aka DJ Echelon) --------------*
*------------- http://www.p2pmania.it -------------*
*------------ Based on the Bit Torrent Protocol made by Bram Cohen ------------*
*------------- http://www.bittorrent.com -------------*
*------------------------------------------------------------------------------*
*------------------------------------------------------------------------------*
*-- This program is free software; you can redistribute it and/or modify --*
*-- it under the terms of the GNU General Public License as published by --*
*-- the Free Software Foundation; either version 2 of the License, or --*
*-- (at your option) any later version. --*
*-- --*
*-- This program is distributed in the hope that it will be useful, --*
*-- but WITHOUT ANY WARRANTY; without even the implied warranty of --*
*-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the --*
*-- GNU General Public License for more details. --*
*-- --*
*-- You should have received a copy of the GNU General Public License --*
*-- along with this program; if not, write to the Free Software --*
*-- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA --*
*-- --*
*------------------------------------------------------------------------------*
*------ �2005 phpMyBitTorrent Development Team ------*
*----------- http://phpmybittorrent.com -----------*
*------------------------------------------------------------------------------*
*/
require_once("../include/configdata.php");
require_once("udl/database.php");
//require_once("../FCKeditor/fckeditor.php");
require_once'../include/textarea.php';
echo"<script type=\"text/javascript\" src=\"../bbcode.js\"></script>";
$db = new sql_db($db_host, $db_user, $db_pass, $db_name, $db_persistency);
function is_url($url) {
return preg_match('/^http[s]{0,1}:\/\/[\\w\\.]*\\.[\\w]{2,6}(\/[\\w]*){0,}/', $url);
}
function is_email($email) {
return preg_match("/^(([A-Za-z0-9]+_+)|([A-Za-z0-9]+\\-+)|([A-Za-z0-9]+\\.+)|([A-Za-z0-9]+\\++))*[A-Za-z0-9]+@((\\w+\\-+)|(\\w+\\.))*\\w{1,63}\\.[a-zA-Z]{2,6}$/",$email);
}
function esc_magic($x) {
if (!get_magic_quotes_gpc()) return addslashes($x);
else return $x;
}
function help($name,$help,$title = "") {
echo "<span onmouseover=\"return overlib('".addslashes(str_replace("\n","",$help)),"'";
if ($title != "") echo ",CAPTION, '".addslashes(str_replace("\n","",$title))."'";
echo ",FGCOLOR,'#3989A6',CAPICON,'graphics/help.gif',SHADOW,SHADOWOPACITY,40,SHADOWCOLOR,'#000000',SHADOWX,2,SHADOWY,2,HAUTO,VAUTO);\" onmouseout=\"return nd();\" style=\"cursor:help\">".$name."</span>";
}
function drawRow($param, $type, $options = NULL) {
global $cfgrow, $textarea;
echo "<tr>";
echo "<td width=\"16\"><p>";
help("<img src=\"graphics/help.gif\" />",constant("_admp".$param."explain"),constant("_admp".$param));
echo "</p></td>\n";
echo "<td><p>".constant("_admp".$param)."</p></td>\n";
echo "<td align=\"right\"><p>";
if ($type == "text") {
echo "<input type=\"text\" name=\"sub_".$param."\" value=\"".$cfgrow[$param]."\" size=\"40\" />";
} elseif ($type == "select") {
echo "<select name=\"sub_".$param."\">\n";
foreach ($options as $key=>$val) {
echo "<option ";
if ($cfgrow[$param] == $key) echo "selected";
echo " value=\"".$key."\">".$val."</option>\n";
}
echo "</select>";
} elseif ($type == "checkbox") {
echo "<input type=\"checkbox\" name=\"sub_".$param."\" value=\"true\" ";
if ($cfgrow[$param] == "true") echo "checked";
echo "/>";
} elseif ($type == "textarea") {
echo $textarea->quick_bbcode('formdata',"sub_".$param);
echo $textarea->input("sub_".$param,'center','2','10','60',$cfgrow[$param]);
echo "</table>\n";
echo "</p>";
}
echo "</p></td>\n";
echo "</tr>\n";
}
function drawConfig() {
echo "<table width=\"100%\">\n";
echo "<tr><td></td><td><p><b>"._basicsettings."</b></p></td><td></td></tr>\n";
echo "<tr><td></td><td><p> </p></td><td></td></tr>\n";
echo "<tr><td></td><td><p> </p></td><td></td></tr>\n";
drawRow("sitename","text");
drawRow("siteurl","text");
drawRow("cookiedomain","text");
drawRow("cookiepath","text");
drawRow("admin_email","text");
echo "<tr><td></td><td><p> </p></td><td></td></tr>\n";
echo "<tr><td></td><td><p> </p></td><td></td></tr>\n";
echo "<tr><td></td><td><p><b>"._advancedsettings."</b></p></td><td></td></tr>\n";
echo "<tr><td></td><td><p> </p></td><td></td></tr>\n";
echo "<tr><td></td><td><p> </p></td><td></td></tr>\n";
//Language handling
{
$languages = Array();
$langdir = "../language";
$langhandle = opendir($langdir);
while ($langfile = readdir($langhandle)) {
if (eregi("\.php$",$langfile) AND strtolower($langfile) != "mailtexts.php")
$languages[str_replace(".php","",$langfile)] = ucwords(str_replace(".php","",$langfile));
}
closedir($langhandle);
unset($langdir,$langfile);
}
drawRow("language","select",$languages);
unset($languages);
//Theme handling
{
$themes = Array();
$thememaindir = "../themes";
$themehandle = opendir($thememaindir);
while ($themedir = readdir($themehandle)) {
if (is_dir($thememaindir."/".$themedir) AND $themedir != "." AND $themedir != ".." AND $themedir != "CVS")
$themes[$themedir] = $themedir;
}
closedir($themehandle);
unset($thememaindir,$themedir);
}
drawRow("theme","select",$themes);
unset($themes);
drawRow("welcome_message","textarea");
drawRow("announce_text","text");
drawRow("allow_html","checkbox");
drawRow("rewrite_engine","checkbox");
drawRow("torrent_prefix","text");
drawRow("torrent_per_page","text");
drawRow("onlysearch","checkbox");
drawRow("pivate_mode","checkbox");
drawRow("force_passkey","checkbox");
drawRow("max_torrent_size","text");
drawRow("announce_interval","text");
drawRow("announce_interval_min","text");
drawRow("dead_torrent_interval","text");
drawRow("minvotes","text");
drawRow("time_tracker_update","text");
drawRow("best_limit","text");
drawRow("down_limit","text");
drawRow("torrent_complaints","checkbox");
drawRow("torrent_global_privacy","checkbox");
drawRow("disclaimer_check","checkbox");
drawRow("gfx_check","checkbox");
drawRow("upload_level","select",Array("all"=>_admpupload_levelopt1, "user"=>_admpupload_levelopt2, "premium"=>_admpupload_levelopt3));
drawRow("download_level","select",Array("all"=>_admpdownload_levelopt1, "user"=>_admpdownload_levelopt2, "premium" => _admpdownload_levelopt3));
drawRow("announce_level","select",Array("all"=>_admpannounce_levelopt1, "user"=>_admpannounce_levelopt2));
drawRow("max_num_file","text");
drawRow("max_share_size","text");
drawRow("global_min_ratio","text");
drawRow("autoscrape","checkbox");
drawrow("upload_dead","checkbox");
drawRow("min_num_seed_e","text");
drawRow("min_size_seed_e","text");
drawRow("minupload_file_size","text");
drawRow("allow_backup_tracker","checkbox");
drawRow("stealthmode","checkbox");
drawRow("upload_dead","checkbox");
drawRow("invites_open","checkbox");
drawRow("invite_only","checkbox");
drawRow("max_members","text");
drawRow("auto_clean","text");
drawRow("free_dl","checkbox");
drawRow("addprivate","checkbox");
drawRow("wait_time","checkbox");
drawRow("GIGSA","text");
drawRow("RATIOA","text");
drawRow("WAITA","text");
drawRow("GIGSB","text");
drawRow("RATIOB","text");
drawRow("WAITB","text");
drawRow("GIGSC","text");
drawRow("RATIOC","text");
drawRow("WAITC","text");
drawRow("GIGSD","text");
drawRow("RATIOD","text");
drawRow("WAITD","text");
echo "</table>\n\n";
}
if (!isset($postback)) { //Set default parameters
$script_uri = array_key_exists("SCRIPT_URI",$_SERVER) ? $_SERVER["SCRIPT_URI"] : "http://".$_SERVER["SERVER_NAME"].$_SERVER["PHP_SELF"];
$pmbturl = parse_url($script_uri);
if (preg_match("/(.*)\/setup\/index\.php/i",$pmbturl["path"],$pmreg)) $pmpath = $pmreg[1];
else $pmpath = "/";
$cfgrow["sitename"] = "phpMyBitTorrent";
$cfgrow["siteurl"] = $pmbturl["scheme"]."://".$pmbturl["host"].$pmpath;
$cfgrow["cookiedomain"] = $pmbturl["host"];
$cfgrow["cookiepath"] = $pmpath;
$cfgrow["admin_email"] = array_key_exists("SERVER_ADMIN",$_SERVER) ? $_SERVER["SERVER_ADMIN"] : "admin@".$pmbturl["host"];
$cfgrow["language"] = $language;
$cfgrow["theme"] = "Ubuntu";
$cfgrow["welcome_message"] = "";
$cfgrow["announce_text"] = "";
$cfgrow["allow_html"] = true;
$cfgrow["rewrite_engine"] = false;
$cfgrow["torrent_prefix"] = "";
$cfgrow["torrent_per_page"] = 10;
$cfgrow["onlysearch"] = false;
$cfgrow["pivate_mode"] = false;
$cfgrow["force_passkey"] = false;
$cfgrow["max_torrent_size"] = 0;
$cfgrow["announce_interval"] = 300;
$cfgrow["announce_interval_min"] = 0;
$cfgrow["dead_torrent_interval"] = 1500;
$cfgrow["minvotes"] = 0;
$cfgrow["time_tracker_update"] = 3600;
$cfgrow["best_limit"] = 0;
$cfgrow["down_limit"] = 0;
$cfgrow["torrent_complaints"] = false;
$cfgrow["torrent_global_privacy"] = false;
$cfgrow["disclaimer_check"] = true;
$cfgrow["gfx_check"] = (extension_loaded("gd")) ? true : false;
$cfgrow["upload_level"] = "user";
$cfgrow["download_level"] = "all";
$cfgrow["announce_level"] = "all";
$cfgrow["max_num_file"] = 0;
$cfgrow["max_share_size"] = 0;
$cfgrow["global_min_ratio"] = 0;
$cfgrow["autoscrape"] = true;
$cfgrow["min_num_seed_e"] = 0;
$cfgrow["min_size_seed_e"] = 0;
$cfgrow["minupload_file_size"] = 0;
$cfgrow["allow_backup_tracker"] = true;
$cfgrow["stealthmode"] = false;
$cfgrow["upload_dead"] = false;
$cfgrow["version"] = _VERSION;
$cfgrow["invites_open"] = false;
$cfgrow["invite_only"] = false;
$cfgrow["max_members"] = 50000;
$cfgrow["auto_clean"] = 600;
$cfgrow["free_dl"] = false;
$cfgrow["addprivate"] = false;
$cfgrow["wait_time"] = false;
$cfgrow["GIGSA"] = 0;
$cfgrow["RATIOA"] = 0.0;
$cfgrow["WAITA"] = 0;
$cfgrow["GIGSB"] = 0;
$cfgrow["RATIOB"] = 0.0;
$cfgrow["WAITB"] = 0;
$cfgrow["GIGSC"] = 0;
$cfgrow["RATIOC"] = 0.0;
$cfgrow["WAITC"] = 0;
$cfgrow["GIGSD"] = 0;
$cfgrow["RATIOD"] = 0.0;
$cfgrow["WAITD"] = 0;
} else {
$cfgrow["sitename"] = $sub_sitename;
$cfgrow["siteurl"] = $sub_siteurl;
$cfgrow["cookiedomain"] = $sub_cookiedomain;
$cfgrow["cookiepath"] = $sub_cookiepath;
$cfgrow["admin_email"] = $sub_admin_email;
$cfgrow["language"] = $sub_language;
$cfgrow["theme"] = $sub_theme;
$cfgrow["welcome_message"] = $sub_welcome_message;
$cfgrow["announce_text"] = $sub_announce_text;
$cfgrow["allow_html"] = (isset($sub_allow_html) AND $sub_allow_html == "true") ? true : false;
$cfgrow["rewrite_engine"] = (isset($sub_rewrite_engine) AND $sub_rewrite_engine == "true") ? true : false;
$cfgrow["torrent_prefix"] = $sub_torrent_prefix;
$cfgrow["torrent_per_page"] = $sub_torrent_per_page;
$cfgrow["onlysearch"] = (isset($sub_onlysearch) AND $sub_onlysearch == "true") ? true : false;
$cfgrow["pivate_mode"] = (isset($sub_pivate_mode) AND $sub_pivate_mode == "true") ? true : false;
$cfgrow["force_passkey"] = (isset($sub_force_passkey) AND $sub_force_passkey == "true") ? true : false;
$cfgrow["max_torrent_size"] = $sub_max_torrent_size;
$cfgrow["announce_interval"] = $sub_announce_interval;
$cfgrow["announce_interval_min"] = $sub_announce_interval_min;
$cfgrow["dead_torrent_interval"] = $sub_dead_torrent_interval;
$cfgrow["minvotes"] = $sub_minvotes;
$cfgrow["time_tracker_update"] = $sub_time_tracker_update;
$cfgrow["best_limit"] = $sub_best_limit;
$cfgrow["down_limit"] = $sub_down_limit;
$cfgrow["torrent_complaints"] = (isset($sub_torrent_complaints) AND $sub_torrent_complaints == "true") ? true : false;
$cfgrow["torrent_global_privacy"] = (isset($sub_torrent_global_privacy) AND $sub_torrent_global_privacy == "true") ? true : false;
$cfgrow["disclaimer_check"] = (isset($sub_disclaimer_check) AND $sub_disclaimer_check == "true") ? true : false;
$cfgrow["gfx_check"] = (isset($sub_gfx_check) AND $sub_gfx_check == "true") ? true : false;
$cfgrow["upload_level"] = $sub_upload_level;
$cfgrow["download_level"] = $sub_download_level;
$cfgrow["announce_level"] = $sub_announce_level;
$cfgrow["max_num_file"] = $sub_max_num_file;
$cfgrow["max_share_size"] = $sub_max_share_size;
$cfgrow["global_min_ratio"] = $sub_global_min_ratio;
$cfgrow["autoscrape"] = (isset($sub_autoscrape) AND $sub_autoscrape == "true") ? true : false;
$cfgrow["min_num_seed_e"] = $sub_min_num_seed_e;
$cfgrow["min_size_seed_e"] = $sub_min_size_seed_e;
$cfgrow["minupload_file_size"] = $sub_minupload_file_size;
$cfgrow["allow_backup_tracker"] = (isset($sub_allow_backup_tracker) AND $sub_allow_backup_tracker == "true") ? true : false;
$cfgrow["stealthmode"] = (isset($sub_stealthmode) AND $sub_stealthmode == "true") ? true : false;
$cfgrow["upload_dead"] = (isset($sub_upload_dead) And $sub_upload_dead == "true") ? true : false;
$cfgrow["invites_open"] = (isset($sub_invites_open) And $sub_invites_open == "true") ? true : false;
$cfgrow["invite_only"] = (isset($sub_invite_only) And $sub_invite_only == "true") ? true : false;
$cfgrow["max_members"] = $sub_max_members;
$cfgrow["auto_clean"] = $sub_auto_clean;
$cfgrow["free_dl"] = (isset($sub_free_dl) AND $sub_free_dl == "true") ? true : false;
$cfgrow["addprivate"] = (isset($sub_addprivate) AND $sub_addprivate == "true") ? true : false;
$cfgrow["wait_time"] = (isset($sub_wait_time) AND $sub_wait_time == "true") ? true : false;
$cfgrow["GIGSA"] = $sub_GIGSA;
$cfgrow["RATIOA"] = $sub_RATIOA;
$cfgrow["WAITA"] = $sub_WAITA;
$cfgrow["GIGSB"] = $sub_GIGSB;
$cfgrow["RATIOB"] = $sub_RATIOB;
$cfgrow["WAITB"] = $sub_WAITB;
$cfgrow["GIGSC"] = $sub_GIGSC;
$cfgrow["RATIOC"] = $sub_RATIOC;
$cfgrow["WAITC"] = $sub_WAITC;
$cfgrow["GIGSD"] = $sub_GIGSD;
$cfgrow["RATIOD"] = $sub_RATIOD;
$cfgrow["WAITD"] = $sub_WAITD;
$cfgrow["version"] = _VERSION;
}
if (isset($postback)) {
//Process Request
//First I create the two SQL arrays
$params = Array();
$values = Array();
//Then I accurately check each parameter before inserting it in SQL statement
//Some parameters that must be numeric have to be checked with an if clause because intval() function truncates to max integer
array_push($params,"sitename"); array_push($values,esc_magic($sub_sitename));
if (is_url($sub_siteurl)) { array_push($params,"siteurl"); array_push($values,esc_magic($sub_siteurl)); }
array_push($params,"cookiedomain"); array_push($values,$sub_cookiedomain);
if (preg_match('/^\/.*/', $sub_cookiepath)) { array_push($params,"cookiepath"); array_push($values,esc_magic($sub_cookiepath)); }
if (is_email($sub_admin_email)) { array_push($params,"admin_email"); array_push($values,esc_magic($sub_admin_email)); }
if (file_exists("language/".$sub_language.".php")) { array_push($params,"language"); array_push($values,$sub_language); }
if (is_dir("themes/".$sub_theme)) { array_push($params,"theme"); array_push($values,$sub_theme); }
array_push($params,"welcome_message"); array_push($values,esc_magic($sub_welcome_message));
array_push($params,"announce_text"); array_push($values,esc_magic($sub_announce_text));
if ($sub_allow_html != "true") $sub_allow_html = "false"; array_push($params,"allow_html"); array_push($values,$sub_allow_html);
if ($sub_rewrite_engine != "true") $sub_rewrite_engine = "false"; array_push($params,"rewrite_engine"); array_push($values,$sub_rewrite_engine);
array_push($params,"torrent_prefix"); array_push($values,$sub_torrent_prefix);
array_push($params,"torrent_per_page"); array_push($values,intval($sub_torrent_per_page));
if (!isset($sub_onlysearch) OR $sub_onlysearch != "true") $sub_onlysearch = "false"; array_push($params,"onlysearch"); array_push($values,$sub_onlysearch);
if (!isset($sub_force_passkey) OR $sub_force_passkey != "true") $sub_force_passkey = "false"; array_push($params,"force_passkey"); array_push($values,$sub_force_passkey);
if (!isset($sub_pivate_mode) OR $sub_pivate_mode != "true") $sub_pivate_mode = "false"; array_push($params,"pivate_mode"); array_push($values,$sub_pivate_mode);
array_push($params,"max_torrent_size"); array_push($values,intval($sub_max_torrent_size));
array_push($params,"announce_interval"); array_push($values,intval($sub_announce_interval));
array_push($params,"announce_interval_min"); if($sub_announce_interval_min > $sub_announce_interval) array_push($values,intval($sub_announce_interval)); else array_push($values,intval($sub_announce_interval_min));
array_push($params,"dead_torrent_interval"); array_push($values,intval($sub_dead_torrent_interval));
array_push($params,"minvotes"); array_push($values,intval($sub_minvotes));
array_push($params,"time_tracker_update"); array_push($values,intval($sub_time_tracker_update));
array_push($params,"best_limit"); array_push($values,intval($sub_best_limit));
array_push($params,"down_limit"); array_push($values,intval($sub_down_limit));
if (!isset($sub_torrent_complaints) OR $sub_torrent_complaints != "true") $sub_torrent_complaints = "false"; array_push($params,"torrent_complaints"); array_push($values,$sub_torrent_complaints);
if (!isset($sub_torrent_global_privacy) OR $sub_torrent_global_privacy != "true") $sub_torrent_global_privacy = "false"; array_push($params,"torrent_global_privacy"); array_push($values,$sub_torrent_global_privacy);
if (!isset($sub_disclaimer_check) OR $sub_disclaimer_check != "true") $sub_disclaimer_check = "false"; array_push($params,"disclaimer_check"); array_push($values,$sub_disclaimer_check);
if (!isset($sub_gfx_check) OR $sub_gfx_check != "true") $sub_gfx_check = "false"; array_push($params,"gfx_check"); array_push($values,$sub_gfx_check);
if (in_array($sub_upload_level,Array("all","user","premium"))) { array_push($params,"upload_level"); array_push($values,$sub_upload_level); }
if (in_array($sub_download_level,Array("all","user","premium"))) { array_push($params,"download_level"); array_push($values,$sub_download_level); }
if ($sub_announce_level != "all") $sub_announce_level = "user"; array_push($params,"announce_level"); array_push($values,$sub_announce_level);
array_push($params,"max_num_file"); array_push($values,intval($sub_max_num_file));
if (is_numeric($sub_max_share_size)) { array_push($params,"max_share_size"); array_push($values,$sub_max_share_size); }
array_push($params,"global_min_ratio"); array_push($values,number_format($sub_global_min_ratio,2));
if (!isset($sub_autoscrape) OR $sub_autoscrape != "true") $sub_autoscrape = "false"; array_push($params,"autoscrape"); array_push($values,$sub_autoscrape);
if (is_numeric($sub_min_num_seed_e)) { array_push($params,"min_num_seed_e"); array_push($values,$sub_min_num_seed_e); }
if (is_numeric($sub_min_size_seed_e)) { array_push($params,"min_size_seed_e"); array_push($values,$sub_min_size_seed_e); }
if (is_numeric($sub_minupload_size_file)) {array_push($params,"minupload_size_file"); array_push($values,$sub_minupload_size_file); }
if (!isset($sub_allow_backup_tracker) OR $sub_allow_backup_tracker != "true") $sub_allow_backup_tracker = "false"; array_push($params,"allow_backup_tracker"); array_push($values,$sub_allow_backup_tracker);
if (!isset($sub_stealthmode) OR $sub_stealthmode != "true") $sub_stealthmode = "false"; array_push($params,"stealthmode"); array_push($values,$sub_stealthmode);
if (!isset($sub_upload_dead) OR $sub_upload_dead != "true") $sub_upload_dead = "false"; array_push($params,"upload_dead"); array_push($values,$sub_upload_dead);
if (!isset($sub_invites_open) OR $sub_invites_open != "true") $sub_invites_open = "false"; array_push($params,"invites_open"); array_push($values,$sub_invites_open);
if (!isset($sub_invite_only) OR $sub_invite_only != "true") $sub_invite_only = "false"; array_push($params,"invite_only"); array_push($values,$sub_invite_only);
if (is_numeric($sub_max_members)) {array_push($params,"max_members"); array_push($values,$sub_max_members); }
if (is_numeric($sub_auto_clean)) {array_push($params,"auto_clean"); array_push($values,$sub_auto_clean); }
if (!isset($sub_free_dl) OR $sub_free_dl != "true") $sub_free_dl = "false"; array_push($params,"free_dl"); array_push($values,$sub_free_dl);
if (!isset($sub_addprivate) OR $sub_addprivate != "true") $sub_addprivate = "false"; array_push($params,"addprivate"); array_push($values,$sub_addprivate);
if (is_numeric($sub_GIGSA)) {array_push($params,"GIGSA"); array_push($values,$sub_GIGSA); }
if (is_numeric($sub_RATIOA)) {array_push($params,"RATIOA"); array_push($values,$RATIOA); }
if (is_numeric($sub_WAITA)) {array_push($params,"WAITA"); array_push($values,$sub_WAITA); }
if (is_numeric($sub_GIGSB)) {array_push($params,"GIGSB"); array_push($values,$sub_GIGSB); }
if (is_numeric($sub_RATIOB)) {array_push($params,"RATIOB"); array_push($values,$sub_RATIOB); }
if (is_numeric($sub_WAITB)) {array_push($params,"WAITB"); array_push($values,$sub_WAITB); }
if (is_numeric($sub_GIGSC)) {array_push($params,"GIGSC"); array_push($values,$sub_GIGSC); }
if (is_numeric($sub_RATIOC)) {array_push($params,"RATIOC"); array_push($values,$sub_RATIOC); }
if (is_numeric($sub_WAITC)) {array_push($params,"WAITC"); array_push($values,$sub_WAITC); }
if (is_numeric($sub_GIGSD)) {array_push($params,"GIGSD"); array_push($values,$sub_GIGSD); }
if (is_numeric($sub_RATIOD)) {array_push($params,"RATIOD"); array_push($values,$sub_RATIOD); }
if (is_numeric($sub_WAITD)) {array_push($params,"WAITD"); array_push($values,$sub_WAITD); }
array_push($params,"version"); array_push($values,_VERSION);
$db->sql_query("TRUNCATE TABLE ".$db_prefix."_config;");
$sql = "INSERT INTO ".$db_prefix."_config (".implode(", ",$params).") VALUES ('".implode("', '",$values)."');";
if (!$db->sql_query($sql)) {
//Error Handling
$err = $db->sql_error();
echo "<input type=\"hidden\" name=\"step\" value=\"5\" />\n";
echo "<p align=\"center\"><font size=\"5\">"._step5."</font></p>\n";
echo "<p> </p>\n";
echo "<p>";
echo "<font class=\"err\">";
echo _btsqlerror1."<br />\n<textarea rows=\"4\" cols=\"65\">".htmlspecialchars($sql)."</textarea>";
echo "<br />" ;
echo _btsqlerror2.$err["code"];
echo "<br />";
echo _btsqlerror3.$err["message"];
echo "</font></p>";
echo "<p>"._step5explain."</p>\n";
echo "<p> </p>\n";
drawConfig();
echo "<p><input type=\"submit\" name=\"postback\" value=\""._nextstep."\" /><input type=\"reset\" value=\""._reset."\" /></p>\n";
} else {
echo "<input type=\"hidden\" name=\"step\" value=\"6\" />\n";
echo "<p>"._step5complete."</p>";
echo "<p><input type=\"submit\" value=\""._nextstep."\" /></p>\n";
}
} else {
echo "<input type=\"hidden\" name=\"step\" value=\"5\" />\n";
echo "<p align=\"center\"><font size=\"5\">"._step5."</font></p>\n";
echo "<p> </p>\n";
echo "<p>"._step5explain."</p>\n";
echo "<p> </p>\n";
drawConfig();
echo "<p><input type=\"submit\" name=\"postback\" value=\""._nextstep."\" /><input type=\"reset\" value=\""._reset."\" /></p>\n";
}
$db->sql_query("",END_TRANSACTION);
$db->sql_close();
?>
and setup/sql/install-MySQL4.sql
Code:
CREATE TABLE `#prefix#_addedrequests` (
`id` int(10) unsigned NOT NULL auto_increment,
`requestid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `pollid` (`id`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_admin_forum` (
`prefix` varchar(60) NOT NULL default '',
`cookie_name` varchar(60) NOT NULL default '',
`cookie_domain` varchar(60) NOT NULL default '',
`cookie_path` varchar(60) NOT NULL default '',
`cookie_time` varchar(60) NOT NULL default '0',
`base_folder` varchar(60) NOT NULL default '',
`forum_share` enum('true','false') NOT NULL default 'true',
`auto_post` enum('true','false') NOT NULL default 'false',
`auto_post_forum` varchar(60) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_avps` (
`arg` varchar(20) NOT NULL default '',
`value_s` text NOT NULL,
`value_i` int(11) NOT NULL default '0',
`value_u` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`arg`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_bans` (
`id` int(11) unsigned NOT NULL auto_increment,
`ipstart` int(10) unsigned NOT NULL default '0',
`ipend` int(10) unsigned NOT NULL default '0',
`reason` varchar(255) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `ip_unique` (`ipstart`,`ipend`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_blackjack` (
`userid` int(11) NOT NULL default '0',
`points` int(11) NOT NULL default '0',
`status` enum('playing','waiting') NOT NULL default 'playing',
`cards` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_bonus` (
`id` int(5) NOT NULL auto_increment,
`bonusname` varchar(50) NOT NULL default '',
`points` decimal(4,1) NOT NULL default '000.0',
`description` text NOT NULL,
`art` varchar(10) NOT NULL default 'traffic',
`menge` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_cards` (
`id` int(11) NOT NULL auto_increment,
`points` int(11) NOT NULL default '0',
`pic` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_casino` (
`userid` int(10) NOT NULL default '0',
`win` bigint(20) default NULL,
`lost` bigint(20) default NULL,
`trys` int(11) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`enableplay` enum('yes','no') NOT NULL default 'yes',
`deposit` bigint(20) NOT NULL default '0',
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_casino_bets` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) NOT NULL default '0',
`proposed` varchar(40) NOT NULL default '',
`challenged` varchar(40) NOT NULL default '',
`amount` bigint(20) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `userid` (`userid`,`proposed`,`challenged`,`amount`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_casino_config` (
`name` varchar(255) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_categories` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`sort_index` int(10) unsigned NOT NULL default '0',
`image` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `sort_index` (`sort_index`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_comments` (
`id` int(10) unsigned NOT NULL auto_increment,
`user` int(10) unsigned NOT NULL default '0',
`torrent` int(10) unsigned NOT NULL default '0',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`text` text NOT NULL,
`ori_text` text NOT NULL,
`news` int(10) NOT NULL default '0',
`nzb` int(10) NOT NULL default '0',
`offer` int(11) NOT NULL default '0',
`editedat` datetime NOT NULL default '0000-00-00 00:00:00',
`editedby` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `user` (`user`),
KEY `torrent` (`torrent`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_comments_notify` (
`torrent` int(11) NOT NULL default '0',
`user` int(11) NOT NULL default '0',
`status` enum('active','stopped') NOT NULL default 'active',
PRIMARY KEY (`torrent`,`user`),
KEY `torrent` (`torrent`,`status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_complaints` (
`torrent` int(15) unsigned NOT NULL default '0',
`user` int(11) unsigned NOT NULL default '0',
`host` varchar(60) NOT NULL default '',
`datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`score` smallint(1) unsigned zerofill NOT NULL default '0',
PRIMARY KEY (`torrent`,`user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_config` (
`sitename` varchar(255) NOT NULL default '',
`siteurl` varchar(255) NOT NULL default '',
`cookiedomain` varchar(30) NOT NULL default '',
`cookiepath` varchar(60) NOT NULL default '',
`admin_email` varchar(60) NOT NULL default '',
`language` varchar(15) NOT NULL default '',
`theme` varchar(255) NOT NULL default '',
`force_passkey` enum('true','false') NOT NULL default 'false',
`welcome_message` longtext,
`announce_text` varchar(255) default NULL,
`allow_html` enum('true','false') NOT NULL default 'true',
`rewrite_engine` enum('true','false') NOT NULL default 'true',
`torrent_prefix` varchar(255) default NULL,
`torrent_per_page` int(10) unsigned NOT NULL default '10',
`onlysearch` enum('true','false') NOT NULL default 'true',
`max_torrent_size` int(11) unsigned NOT NULL default '0',
`announce_interval_min` int(10) unsigned NOT NULL default '0',
`announce_interval` int(10) unsigned NOT NULL default '0',
`dead_torrent_interval` int(10) unsigned NOT NULL default '0',
`minvotes` smallint(5) unsigned NOT NULL default '0',
`time_tracker_update` int(10) unsigned NOT NULL default '0',
`best_limit` smallint(5) unsigned NOT NULL default '0',
`down_limit` smallint(5) unsigned NOT NULL default '0',
`torrent_complaints` enum('true','false') NOT NULL default 'false',
`#prefix#_global_privacy` enum('true','false') NOT NULL default 'true',
`disclaimer_check` enum('true','false') NOT NULL default 'false',
`gfx_check` enum('true','false') NOT NULL default 'true',
`upload_level` enum('all','user','premium') NOT NULL default 'user',
`download_level` enum('all','user','premium') NOT NULL default 'all',
`announce_level` enum('all','user') NOT NULL default 'all',
`max_num_file` smallint(5) unsigned NOT NULL default '0',
`max_share_size` bigint(8) unsigned NOT NULL default '0',
`min_size_seed` mediumint(8) unsigned NOT NULL default '0',
`min_share_seed` bigint(8) unsigned NOT NULL default '0',
`global_min_ratio` float unsigned NOT NULL default '0',
`autoscrape` enum('true','false') NOT NULL default 'true',
`min_num_seed_e` smallint(5) unsigned NOT NULL default '0',
`min_size_seed_e` bigint(8) unsigned NOT NULL default '0',
`minupload_size_file` int(10) unsigned NOT NULL default '0',
`allow_backup_tracker` enum('true','false') NOT NULL default 'false',
`stealthmode` enum('true','false') NOT NULL default 'true',
`version` varchar(5) NOT NULL default '',
`upload_dead` enum('true','false') NOT NULL default 'false',
`invites_open` enum('true','false') NOT NULL default 'false',
`invite_only` enum('true','false') NOT NULL default 'false',
`max_members` int(10) unsigned NOT NULL default '0',
`auto_clean` int(10) unsigned NOT NULL default '0',
`free_dl` enum('true','false') NOT NULL default 'false',
`GIGSA` int(10) NOT NULL default '0',
`RATIOA` decimal(10,2) NOT NULL default '0.00',
`WAITA` int(10) NOT NULL default '0',
`GIGSB` int(10) NOT NULL default '0',
`RATIOB` decimal(10,2) NOT NULL default '0.00',
`WAITB` int(10) NOT NULL default '0',
`GIGSC` int(10) NOT NULL default '0',
`RATIOC` decimal(10,2) NOT NULL default '0.00',
`WAITC` int(10) NOT NULL default '0',
`GIGSD` int(10) NOT NULL default '0',
`RATIOD` decimal(10,2) NOT NULL default '0.00',
`WAITD` int(10) NOT NULL default '0',
`wait_time` enum('true','false') NOT NULL default 'false',
`addprivate` enum('true','false') NOT NULL default 'false',
`search_cloud_block` enum('true','false') NOT NULL default 'true',
`pivate_mode` enum('true','false') NOT NULL default 'false'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_countries` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) default NULL,
`flagpic` varchar(50) default NULL,
`domain` char(3) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_download_completed` (
`user` int(11) unsigned NOT NULL default '0',
`torrent` int(15) unsigned NOT NULL default '0',
`completed` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`user`,`torrent`),
KEY `torrent` (`torrent`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_faq` (
`id` int(10) NOT NULL auto_increment,
`type` set('categ','item') NOT NULL default 'item',
`question` text NOT NULL,
`answer` text NOT NULL,
`flag` set('0','1','2','3') NOT NULL default '1',
`categ` int(10) NOT NULL default '0',
`order` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_files` (
`id` int(20) unsigned NOT NULL auto_increment,
`torrent` int(15) unsigned NOT NULL default '0',
`filename` varchar(255) NOT NULL default '',
`size` bigint(20) unsigned NOT NULL default '0',
`md5sum` varchar(32) default NULL,
`ed2k` varchar(255) default NULL,
`magnet` varchar(255) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `#prefix#_2` (`torrent`,`filename`),
KEY `torrent` (`torrent`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_filter` (
`id` int(10) unsigned NOT NULL auto_increment,
`keyword` varchar(50) NOT NULL default '',
`reason` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `keyword` (`keyword`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_flashscores` (
`ID` int(11) NOT NULL auto_increment,
`game` int(11) NOT NULL default '0',
`user` int(11) NOT NULL default '0',
`level` int(11) NOT NULL default '0',
`score` int(11) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_lottery_config` (
`name` varchar(255) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_offers` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`name` varchar(225) default NULL,
`descr` text NOT NULL,
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`for` int(10) unsigned NOT NULL default '0',
`against` int(10) unsigned NOT NULL default '0',
`category` int(11) NOT NULL default '0',
`comments` int(11) NOT NULL default '0',
`allowed` enum('allowed','pending','denied') NOT NULL default 'pending',
`votes` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_offervotes` (
`id` int(10) unsigned NOT NULL auto_increment,
`offerid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`vote` enum('for','against') NOT NULL default 'for',
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_offres_config` (
`name` varchar(255) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_online_users` (
`id` int(60) unsigned NOT NULL default '0',
`page` varchar(255) NOT NULL default '',
`logged_in` datetime NOT NULL default '0000-00-00 00:00:00',
`last_action` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_paypal` (
`siteurl` varchar(255) NOT NULL default '',
`paypal_email` varchar(60) NOT NULL default '',
`sitecost` varchar(60) NOT NULL default '',
`reseaved_donations` varchar(60) NOT NULL default '',
`donatepage` longtext NOT NULL,
`donation_block` enum('true','false') NOT NULL default 'true',
`nodonate` enum('EU','UK','US') NOT NULL default 'US'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_peers` (
`id` int(10) unsigned NOT NULL auto_increment,
`uid` int(11) unsigned NOT NULL default '0',
`torrent` int(10) unsigned NOT NULL default '0',
`peer_id` varchar(20) character set latin1 collate latin1_bin NOT NULL default '',
`unique_id` varchar(20) default NULL,
`ip` int(10) unsigned NOT NULL default '0',
`port` smallint(5) unsigned NOT NULL default '0',
`real_ip` int(10) unsigned NOT NULL default '0',
`uploaded` bigint(20) unsigned NOT NULL default '0',
`downloaded` bigint(20) unsigned NOT NULL default '0',
`download_speed` int(11) unsigned NOT NULL default '0',
`upload_speed` int(11) unsigned NOT NULL default '0',
`to_go` bigint(20) unsigned NOT NULL default '0',
`seeder` enum('yes','no') NOT NULL default 'no',
`started` datetime NOT NULL default '0000-00-00 00:00:00',
`last_action` datetime NOT NULL default '0000-00-00 00:00:00',
`connectable` enum('yes','no') NOT NULL default 'yes',
`client` varchar(60) default NULL,
`version` varchar(10) NOT NULL default '',
`user_agent` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `#prefix#_peer_id` (`torrent`,`peer_id`),
UNIQUE KEY `#prefix#_3` (`torrent`,`unique_id`),
KEY `torrent` (`torrent`),
KEY `last_action` (`last_action`),
KEY `#prefix#_2` (`torrent`,`seeder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_pollanswers` (
`id` int(10) unsigned NOT NULL auto_increment,
`pollid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`selection` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `pollid` (`pollid`),
KEY `selection` (`selection`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_polls` (
`id` int(10) unsigned NOT NULL auto_increment,
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`question` varchar(255) NOT NULL default '',
`option0` varchar(40) NOT NULL default '',
`option1` varchar(40) NOT NULL default '',
`option2` varchar(40) NOT NULL default '',
`option3` varchar(40) NOT NULL default '',
`option4` varchar(40) NOT NULL default '',
`option5` varchar(40) NOT NULL default '',
`option6` varchar(40) NOT NULL default '',
`option7` varchar(40) NOT NULL default '',
`option8` varchar(40) NOT NULL default '',
`option9` varchar(40) NOT NULL default '',
`sort` enum('yes','no') NOT NULL default 'yes',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_privacy_backup` (
`master` int(11) unsigned NOT NULL default '0',
`slave` int(11) NOT NULL default '0',
`torrent` int(11) NOT NULL default '0',
`status` enum('pending','denied','granted') NOT NULL default 'pending',
PRIMARY KEY (`slave`,`torrent`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_privacy_file` (
`master` int(11) unsigned NOT NULL default '0',
`slave` int(11) unsigned NOT NULL default '0',
`torrent` int(15) unsigned NOT NULL default '0',
`status` enum('pending','denied','granted') NOT NULL default 'pending',
PRIMARY KEY (`slave`,`torrent`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_privacy_global` (
`master` int(11) unsigned NOT NULL default '0',
`torrent` int(11) NOT NULL default '0',
`slave` int(11) unsigned NOT NULL default '0',
`status` enum('blacklist','whitelist') NOT NULL default 'whitelist',
PRIMARY KEY (`master`,`slave`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_private_messages` (
`id` int(20) unsigned zerofill NOT NULL auto_increment,
`sender` int(11) unsigned NOT NULL default '0',
`recipient` int(11) unsigned NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`text` longtext NOT NULL,
`is_read` enum('true','false') NOT NULL default 'false',
`sent` datetime NOT NULL default '0000-00-00 00:00:00',
`sender_del` enum('true','false') NOT NULL default 'false',
`recipient_del` enum('true','false') NOT NULL default 'false',
PRIMARY KEY (`id`),
KEY `from` (`sender`),
KEY `to` (`recipient`),
FULLTEXT KEY `text` (`text`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_private_messages_blacklist` (
`master` int(11) unsigned NOT NULL default '0',
`slave` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`master`,`slave`),
KEY `master` (`master`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_private_messages_bookmarks` (
`master` int(11) unsigned NOT NULL default '0',
`slave` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`master`,`slave`),
KEY `master` (`master`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_ratings` (
`torrent` int(10) unsigned NOT NULL default '0',
`user` int(10) unsigned NOT NULL default '0',
`rating` tinyint(3) unsigned NOT NULL default '0',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`torrent`,`user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_ratiowarn` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`warned` enum('yes','no') NOT NULL default 'no',
`banned` enum('yes','no') NOT NULL default 'no',
`ratiodate` datetime NOT NULL default '0000-00-00 00:00:00',
`warntime` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_ratiowarn_config` (
`name` varchar(255) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_requests` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`request` varchar(225) default NULL,
`descr` text NOT NULL,
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`hits` int(10) unsigned NOT NULL default '0',
`cat` int(10) unsigned NOT NULL default '0',
`filled` varchar(75) NOT NULL default '',
`filledby` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_requist_config` (
`name` varchar(255) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_rules` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`text` tinytext NOT NULL,
`public` enum('yes','no') NOT NULL default 'yes',
`level` enum('user','premium','moderator','admin') NOT NULL default 'user',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_search_text` (
`id` int(20) unsigned NOT NULL auto_increment,
`text` varchar(25) NOT NULL default '',
`hit` int(20) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `text` (`text`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_seeder_notify` (
`torrent` int(11) NOT NULL default '0',
`user` int(11) NOT NULL default '0',
`status` enum('active','stopped') NOT NULL default 'active',
PRIMARY KEY (`torrent`,`user`),
KEY `contacts` (`torrent`,`status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_shouts` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`user` int(10) unsigned NOT NULL default '0',
`text` varchar(255) NOT NULL default '',
`posted` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `anti_flood` (`user`,`text`),
KEY `posted` (`posted`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_smiles` (
`id` int(5) unsigned NOT NULL auto_increment,
`code` varchar(15) NOT NULL default '',
`file` varchar(30) NOT NULL default '',
`alt` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `code` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_snatched` (
`id` int(10) unsigned NOT NULL auto_increment,
`torrent` int(10) unsigned NOT NULL default '0',
`torrentid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`ip` bigint(20) unsigned NOT NULL default '0',
`#prefix#_name` varchar(255) NOT NULL default '',
`#prefix#_category` int(10) unsigned NOT NULL default '0',
`port` smallint(5) unsigned NOT NULL default '0',
`uploaded` bigint(20) unsigned NOT NULL default '0',
`downloaded` bigint(20) unsigned NOT NULL default '0',
`to_go` bigint(20) unsigned NOT NULL default '0',
`speedup` bigint(20) unsigned NOT NULL default '0',
`speeddown` bigint(20) unsigned NOT NULL default '0',
`seeder` enum('yes','no') NOT NULL default 'no',
`last_action` datetime NOT NULL default '0000-00-00 00:00:00',
`startdat` datetime NOT NULL default '0000-00-00 00:00:00',
`completedat` datetime NOT NULL default '0000-00-00 00:00:00',
`connectable` enum('yes','no') NOT NULL default 'yes',
`agent` varchar(60) NOT NULL default '',
`finished` enum('yes','no') NOT NULL default 'no',
PRIMARY KEY (`id`),
UNIQUE KEY `torrentid_3` (`torrentid`,`userid`),
KEY `finished` (`finished`,`torrentid`),
KEY `torrentid` (`userid`),
KEY `torrentid_2` (`torrentid`),
KEY `userid` (`userid`,`torrentid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_thanks` (
`tid` bigint(10) NOT NULL auto_increment,
`uid` bigint(10) NOT NULL default '0',
`torid` bigint(10) NOT NULL default '0',
`thank_date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_tickets` (
`id` int(4) NOT NULL auto_increment,
`user` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_time_offset` (
`id` smallint(4) NOT NULL auto_increment,
`name` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_torrents` (
`id` int(15) unsigned NOT NULL auto_increment,
`info_hash` varchar(20) character set latin1 collate latin1_bin default NULL,
`md5sum` varchar(32) default NULL,
`name` varchar(255) NOT NULL default '',
`filename` varchar(255) NOT NULL default '',
`save_as` varchar(255) NOT NULL default '',
`search_text` text NOT NULL,
`descr` text NOT NULL,
`#prefix#_descr` text NOT NULL,
`plen` bigint(6) unsigned NOT NULL default '0',
`size` bigint(20) unsigned NOT NULL default '0',
`category` int(10) unsigned NOT NULL default '0',
`type` enum('single','multi','link') NOT NULL default 'single',
`numfiles` int(10) unsigned NOT NULL default '0',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`exeem` varchar(250) default NULL,
`dht` enum('yes','no') NOT NULL default 'no',
`backup_tracker` enum('true','false') NOT NULL default 'false',
`views` int(10) unsigned NOT NULL default '0',
`downloaded` int(10) unsigned NOT NULL default '0',
`completed` int(10) unsigned NOT NULL default '0',
`banned` enum('yes','no') NOT NULL default 'no',
`password` varchar(255) default NULL,
`private` enum('true','false') NOT NULL default 'false',
`min_ratio` float unsigned NOT NULL default '0',
`visible` enum('yes','no') NOT NULL default 'yes',
`evidence` tinyint(1) NOT NULL default '0',
`owner` int(10) unsigned NOT NULL default '0',
`ownertype` tinyint(1) unsigned NOT NULL default '0',
`uploader_host` varchar(100) NOT NULL default '',
`numratings` int(10) unsigned NOT NULL default '0',
`ratingsum` int(10) unsigned NOT NULL default '0',
`seeders` int(10) unsigned NOT NULL default '0',
`leechers` int(10) unsigned NOT NULL default '0',
`tot_peer` int(11) unsigned NOT NULL default '0',
`speed` int(10) unsigned NOT NULL default '0',
`comments` int(10) unsigned NOT NULL default '0',
`complaints` char(3) NOT NULL default '0,0',
`tracker` varchar(250) default NULL,
`tracker_list` text,
`tracker_update` datetime NOT NULL default '0000-00-00 00:00:00',
`last_action` datetime NOT NULL default '0000-00-00 00:00:00',
`nuked` enum('yes','no','unnuked') NOT NULL default 'no',
`ratiobuild` enum('yes','no') NOT NULL default 'no',
`nukereason` varchar(225) NOT NULL default '',
`thanks` int(10) NOT NULL default '0',
`imdb` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `info_hash` (`info_hash`),
KEY `owner` (`owner`),
KEY `visible` (`visible`),
KEY `added` (`added`),
KEY `seeders` (`seeders`),
KEY `leechers` (`leechers`),
KEY `tot_peer` (`tot_peer`),
KEY `banned` (`banned`),
KEY `password` (`password`),
KEY `tracker` (`tracker`),
KEY `evidence` (`evidence`),
KEY `rating` (`numratings`,`ratingsum`),
KEY `numfiles` (`numfiles`),
KEY `downloaded` (`downloaded`),
KEY `category` (`category`),
KEY `type` (`type`),
FULLTEXT KEY `ft_search` (`search_text`),
FULLTEXT KEY `filename` (`filename`),
FULLTEXT KEY `#prefix#_descr` (`#prefix#_descr`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 CHECKSUM=1;
CREATE TABLE `#prefix#_trackers` (
`id` tinyint(5) unsigned NOT NULL auto_increment,
`url` varchar(120) NOT NULL default '',
`support` enum('selective','global','single') NOT NULL default 'selective',
`status` enum('active','dead','blacklisted') NOT NULL default 'active',
`updated` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `url` (`url`),
KEY `update` (`updated`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `#prefix#_users` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(25) NOT NULL default '',
`clean_username` varchar(25) character set utf8 collate utf8_bin NOT NULL default '',
`name` varchar(50) default NULL,
`email` varchar(255) NOT NULL default '',
`regdate` datetime NOT NULL default '0000-00-00 00:00:00',
`password` varchar(40) NOT NULL default '',
`theme` varchar(255) default NULL,
`language` varchar(15) default NULL,
`avatar` varchar(255) NOT NULL default 'blank.gif',
`accept_mail` enum('yes','no') NOT NULL default 'no',
`pm_notify` enum('true','false') NOT NULL default 'true',
`aim` varchar(255) default NULL,
`icq` varchar(10) default NULL,
`jabber` varchar(255) default NULL,
`msn` varchar(255) default NULL,
`skype` varchar(255) default NULL,
`yahoo` varchar(255) default NULL,
`level` enum('user','premium','moderator','admin') NOT NULL default 'user',
`uploaded` bigint(32) unsigned NOT NULL default '0',
`downloaded` bigint(32) unsigned NOT NULL default '0',
`active` tinyint(1) default '0',
`ban` int(1) unsigned NOT NULL default '0',
`act_key` varchar(32) default NULL,
`passkey` varchar(32) default NULL,
`newpasswd` varchar(40) default NULL,
`banreason` varchar(255) default NULL,
`lastip` int(10) unsigned NOT NULL default '0',
`lasthost` varchar(255) NOT NULL default '',
`lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
`rem` enum('yes','no') NOT NULL default 'no',
`modcomment` varchar(225) NOT NULL default '',
`warned` int(1) unsigned NOT NULL default '0',
`warn_kapta` int(11) NOT NULL default '0',
`warn_hossz` int(11) NOT NULL default '0',
`invited_by` int(10) NOT NULL default '0',
`invitees` varchar(100) NOT NULL default '',
`invites` smallint(5) NOT NULL default '0',
`country` int(10) NOT NULL default '0',
`seedbonus` decimal(10,1) NOT NULL default '0.0',
`seedbox` int(10) unsigned NOT NULL default '0',
`tzoffset` smallint(4) NOT NULL default '0',
`can_shout` enum('true','false') character set utf8 collate utf8_bin NOT NULL default 'true',
`Show_online` enum('true','false') character set utf8 collate utf8_bin NOT NULL default 'true',
`invitedate` datetime NOT NULL default '0000-00-00 00:00:00',
`donated` int(5) unsigned NOT NULL default '0',
`dondate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`),
UNIQUE KEY `passkey` (`passkey`),
KEY `lastip` (`lastip`),
KEY `lasthost` (`lasthost`),
KEY `date` (`regdate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0;
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent
Do not ask me to make a mod for any other source
Do not Ask me to setup your site.
I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Manager™ forum
My Current Demo is here http://demo.btmanager.org/
|