Bravo List
Register
Go Back   > Bravo List > P2P > Forum > Downloads
Reply
  #1  
Old 22nd September 2008, 14:21
joeroberts's Avatar
joeroberts joeroberts is offline
BT.Manager Owner
 
Join Date: Jan 2008
United States
Posts: 2,112
Lightbulb phpMyBitTorrent v2.0
PMBT v2

You must creat an account there to see the full system.
If you would like a look at the admin panel you must pm a admin there and let them know so that they can change you permission.
this is the change log

.::phpMyBitTorrent Change log::.

you may now down load for beta testing PMBT2.0 beta from sourceforge
At This link phpMyBitTorrent-V2.0 Please test and let me know of any error's only We well work on changes at a later time and New Themes well come shortly.
Welcome to phpMyBitTorrent!

phpMyBitTorrent is the brand new Open Source solution for BitTorrent communities! phpMyBitTorrent is not just a simple tracker like the ones you see around. It has so many amazing features that it cannot be called simply a "Tracker". In fact, it is a BMS (Bittorrent Management System), something like a BitTorrent-oriented Content Management System.

Some points to convince you of phpMyBitTorrent's supremacy:

phpMyBitTorrent is Free Software!
phpMyBitTorrent is Open Source Software, distributed under the GNU/GPL license. This means that the code is open for scrutiny by anyone, and anybody can join in the development effort.

phpMyBitTorrent is easy!

phpMyBitTorrent is provided with full documentation to help you install it step by step in no time, even if you've never heard of PHP/MySQL.

When you start phpMyBitTorrent, you'll discover help system based on OverLib and image-popups. Just point the mouse over the "Info" icon and read what the item in question is about, and how to use it.

phpMyBitTorrent is up-to-date!

phpMyBitTorrent supports all the latest BitTorrent Protocol Extensions, including Compact Announce, MultiScrape, DHT, Peer Count, Tracker ID, Unique Peer ID, Backup Tracker, etc.

phpMyBitTorrent is not only BitTorrent!

There are many ways other than BitTorrent to share your files. GNutella, Direct Connect, eDonkey are some of them. ed2k and Magnet URIs are automatically generated for all files in a torrent, and are presented as alternate Links. You can also allow users to submit Magnet and ed2k links without a torrent.

phpMyBitTorrent has low requirements!

All you need is some webspace with PHP and a MySQL database to start building your File-Sharing Community.

phpMyBitTorrent is secure!

Stop leechers from downloading more than their share! Choose who can download your files and who can't. See who is downloading your Torrent and who is helping you share it. Define rules to avoid annoyance by Download Requests. Choose friends and foes. Keep your anonymity. And that's just the tip of the iceberg....

phpMyBitTorrent is easy on the eye!

You can choose your personal theme that reflects your style, choose your avatar displayed next to comments you make

phpMyBitTorrent is fast!

phpMyBitTorrent uses the minimum number of code lines required to do all the amazing things it does. Memory usage is low because every single variable is deleted when not needed any more.

phpMyBitTorrent is easy to m0d!

If you know some PHP, you will find incredibly easy to add new features to phpMyBitTorrent. Just include the header and footer pages at the beginning and end of your script, and you'll be able to access all phpMyBitTorrent incredible code layer with basic functions for theming, database access and Torrent encoding.
__________________
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/

Last edited by joeroberts; 20th October 2008 at 12:42.
Reply With Quote
The Following 8 Users Say Thank You to joeroberts For This Useful Post:
aikyam (27th September 2008), D4n63L (22nd January 2009), Fooker (8th January 2009), SafariMan (7th November 2008), Security (10th January 2009), Subzero (21st November 2008), ViRtUoZ (19th October 2008), zenja7777 (27th October 2008)
  #2  
Old 26th September 2008, 14:45
Fynnon's Avatar
Fynnon Fynnon is offline
xxx
 
Join Date: Nov 2007
P2P
Posts: 971
Default
great news joe, the new tracker theme looks great ;-)
Reply With Quote
  #3  
Old 26th September 2008, 21:26
aikyam's Avatar
aikyam aikyam is offline
Member
 
Join Date: Sep 2008
Posts: 8
Default
Quote:
Originally Posted by joeroberts View Post
you may now down load for beta testing PMBT2.0 beta from sourceforge
At This link phpMyBitTorrent-V2.0 Please test and let me know of any error's only We well work on changes at a later time and New Themes well come shortly.
Will try the installation package today n will let know
Reply With Quote
  #4  
Old 26th September 2008, 21:40
Fynnon's Avatar
Fynnon Fynnon is offline
xxx
 
Join Date: Nov 2007
P2P
Posts: 971
Default
Don`t forget this is still BETA, joe is working hard to release the final version as soon as posible
Please report if you find any problems !
Reply With Quote
  #5  
Old 27th September 2008, 00:17
aikyam's Avatar
aikyam aikyam is offline
Member
 
Join Date: Sep 2008
Posts: 8
Default
Quote:
Originally Posted by Fynnon View Post
Don`t forget this is still BETA, joe is working hard to release the final version as soon as posible
Please report if you find any problems !
I have installed the same..And i found a few issues..

Starting with the sql queries during the intial setup of the torrent database i faced with query issues in Step 5 (like torrent_global_galaxy - column not found issues)

I removed them(those lines) from the setup sql 5.php file and continued with the installation but i couldnt proceed anymore after 5.php..But i guess after

After that i installed phpbb3 which dint have any issues...except for the issue that i couldnt merge it with the same database prefix as the system didnt except an installation with the same database prefix..But i inserted the phpbb3 into the same database table but with different table prefix ( i think i might have login issues using the same username with the torrent page and the forum)

Then i took /admin.php where i could see the torrent page but i cant seem to find/login with the admin username and password(Need help here). So i registered like a user and i seem to login properly after the email verification.

Well the torrent site is sort of setup but i feelthe integration isnt still complete as i believe everyone at phpBB would want a tracker MOD(like a add-on) rather than a complete tracker+phpbb installation to be done. But the start is a good one

Demo: www.aikyam.org
Reply With Quote
  #6  
Old 27th September 2008, 01:22
joeroberts's Avatar
joeroberts joeroberts is offline
BT.Manager Owner
 
Join Date: Jan 2008
United States
Posts: 2,112
Default
Quote:
Starting with the sql queries during the intial setup of the torrent database i faced with query issues in Step 5 (like torrent_global_galaxy - column not found issues)
I have no clue where torrent_global_galaxy came from I well have to look at this what line did you coment out??
Quote:
After that i installed phpbb3 which dint have any issues...except for the issue that i couldnt merge it with the same database prefix as the system didnt except an installation with the same database prefix..But i inserted the phpbb3 into the same database table but with different table prefix ( i think i might have login issues using the same username with the torrent page and the forum)
you do not use the same prefix that is a big no no may be I should have been more clear in setting-up.txt
Quote:
Then i took /admin.php where i could see the torrent page but i cant seem to find/login with the admin username and password(Need help here). So i registered like a user and i seem to login properly after the email verification.
WHAT??
__________________
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/
Reply With Quote
  #7  
Old 27th September 2008, 03:01
aikyam's Avatar
aikyam aikyam is offline
Member
 
Join Date: Sep 2008
Posts: 8
Default
Quote:
Originally Posted by joeroberts View Post
I have no clue where torrent_global_galaxy came from I well have to look at this what line did you coment out??
Wait Wait !!!

After reading your comments i just tried reloading the setup files and folder back through my ftp and rerun the setup...this time around...i could finish all the steps...last time around i was stuck in step 5 and couldnt add the administrator username and password...This time around i succeeded...But i dint do anything different :blink:

Okay i shall try to delete the entire mysql tables later today and i shall rerun from the beginning...I have a strange feeling it has run properly maybe because the phpbb3 is installed...Because the only different thing that has happened now is the installation of phpbb3 whereas in the first trial i had installed the bittorrent setup and then run the phpbb3 installation..

But i shall confirfm the same and report :hi:

N.B. : Also I am able to login into the admin now...

But can you tell me even after entering the phpBB integration options and i click on forums it goes to phpMyBitTorrent
and not http://aikyam.org/tforum/html/phpBB3/index.php

Any reasons or where i can update the settings?

Hey Joe,



--------------------------------------------------------------------


EDITED :

I tried to delete the tables from phpmyadmin and started the installer setup again and these are the errors that followed ( the same ones that i got during my first initial tracker setup...

Code:
Notice: Undefined variable: sub_rewrite_engine in /home/aikyam0/public_html/tforum/html/setup/steps/5.php on line 343

Notice: Undefined variable: sub_minupload_size_file in /home/aikyam0/public_html/tforum/html/setup/steps/5.php on line 370

Notice: Undefined variable: RATIOA in /home/aikyam0/public_html/tforum/html/setup/steps/5.php on line 381

Notice: Use of undefined constant _admresetbtn - assumed '_admresetbtn' in /home/aikyam0/public_html/tforum/html/setup/steps/5.php on line 419


-----------------------------------------------------------------------


Code:
Error executing SQL Query 

INSERT INTO phpbb__config (sitename, siteurl, cookiedomain, cookiepath, admin_email, language, welcome_message, announce_text, allow_html, rewrite_engine, torrent_prefix, torrent_per_page, onlysearch, force_passkey, pivate_mode, max_torrent_size, announce_interval, announce_interval_min, dead_torrent_interval, minvotes, time_tracker_update, best_limit, down_limit, torrent_complaints, torrent_global_privacy, disclaimer_check, gfx_check, upload_level, download_level, announce_level, max_num_file, max_share_size, global_min_ratio, autoscrape, min_num_seed_e, min_size_seed_e, allow_backup_tracker, stealthmode, upload_dead, invites_open, invite_only, max_members, auto_clean, free_dl, addprivate, GIGSA, RATIOA, WAITA, GIGSB, RATIOB, WAITB, GIGSC, RATIOC, WAITC, GIGSD, RATIOD, WAITD, version) VALUES ('aikyam.org', 'http://aikyam.org/tforum/html', 'aikyam.org', '/tforum/html', 'admin@aikyam.org', 'english', '', '', 'true', 'false', '', '10', 'false', 'false', 'false', '0', '300', '0', '1500', '0', '3600', '0', '0', 'false', 'false', 'true', 'true', 'user', 'all', 'all', '0', '0', '0.00', 'true', '0', '0', 'true', 'false', 'false', 'false', 'false', '50000', '600', 'false', 'false', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.2.1');

Error ID: 1054
Error Message: Unknown column 'torrent_complaints' in 'field list'
-------------------------------------------------------------------

This was the error i was speaking about...Now what i did in my first setup was that i removed the lines from thes step5 of whatever contained the torrent_complains field so that i could go ahead with the rest of the installation...

BUt then the next error came torrent_global_privacy which again i tried to edit but couldnt let me forward to the next step...so i stopped my installation there and continued to my phpBB3 setup (as it mentions that i could setup these within my admin tracker options)

Maybe if Joe can start helping in the bugging from here itself i could hold on with the installation...
Reply With Quote
  #8  
Old 27th September 2008, 07:14
joeroberts's Avatar
joeroberts joeroberts is offline
BT.Manager Owner
 
Join Date: Jan 2008
United States
Posts: 2,112
Default
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>&nbsp;</p></td><td></td></tr>\n";
        echo "<tr><td></td><td><p>&nbsp;</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>&nbsp;</p></td><td></td></tr>\n";
        echo "<tr><td></td><td><p>&nbsp;</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>&nbsp;</p></td><td></td></tr>\n";
        echo "<tr><td></td><td><p>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</p>\n";
        echo "<p>"._step5explain."</p>\n";
        echo "<p>&nbsp;</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/
Reply With Quote
  #9  
Old 27th September 2008, 09:53
aikyam's Avatar
aikyam aikyam is offline
Member
 
Join Date: Sep 2008
Posts: 8
Default
I have changed both the files and now i get at step 5 the following errors,

Code:
Notice: Undefined variable: sub_rewrite_engine in /home/aikyam0/public_html/tforum/html/setup/steps/5.php on line 343

Notice: Undefined variable: sub_minupload_size_file in /home/aikyam0/public_html/tforum/html/setup/steps/5.php on line 370

Notice: Undefined variable: RATIOA in /home/aikyam0/public_html/tforum/html/setup/steps/5.php on line 381
Code:
Error executing SQL Query 

INSERT INTO phpbb__config (sitename, siteurl, cookiedomain, cookiepath, admin_email, language, welcome_message, announce_text, allow_html, rewrite_engine, torrent_prefix, torrent_per_page, onlysearch, force_passkey, pivate_mode, max_torrent_size, announce_interval, announce_interval_min, dead_torrent_interval, minvotes, time_tracker_update, best_limit, down_limit, torrent_complaints, torrent_global_privacy, disclaimer_check, gfx_check, upload_level, download_level, announce_level, max_num_file, max_share_size, global_min_ratio, autoscrape, min_num_seed_e, min_size_seed_e, allow_backup_tracker, stealthmode, upload_dead, invites_open, invite_only, max_members, auto_clean, free_dl, addprivate, GIGSA, RATIOA, WAITA, GIGSB, RATIOB, WAITB, GIGSC, RATIOC, WAITC, GIGSD, RATIOD, WAITD, version) VALUES ('www.aikyam.org', 'http://aikyam.org/tforum/html', 'aikyam.org', '/tforum/html', 'webmaster@aikyam.org', 'english', '', 'Downloaded from aikyam.org', 'true', 'false', '', '10', 'false', 'false', 'false', '0', '300', '0', '1500', '0', '3600', '0', '0', 'false', 'false', 'true', 'true', 'user', 'all', 'all', '0', '0', '0.00', 'true', '0', '0', 'true', 'false', 'false', 'false', 'false', '50000', '600', 'false', 'false', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1.2.1');

Error ID: 1054
Error Message: Unknown column 'torrent_global_privacy' in 'field list'
Quote:
Originally Posted by joeroberts View Post
what language are you using?
This is what is shown in step 1

Checking PHP Version - 5.2.6 - OK
Checking Zlib - OK
Checking MySQL - OK - 5.0.51a
Checking installed DOM XML - OK
Testing outgoing connections - OK
Checking Operating System - Linux


I use Mysql database and have used the setting Mysql >= 4.1 in Step 3
Reply With Quote
  #10  
Old 27th September 2008, 14:10
joeroberts's Avatar
joeroberts joeroberts is offline
BT.Manager Owner
 
Join Date: Jan 2008
United States
Posts: 2,112
Default
ok lets try this first make tracker prefix (leave it torrent) if it is not set or is something else do not add underscore here (_) and the forum well be phpbb

second is my fault replase step 5.php (I posted wrong one)
with

PHP Code:
<?php
/*
*----------------------------phpMyBitTorrent V 2.0-----------------------------*
*--- 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 --*
*--                                                                          --*
*------------------------------------------------------------------------------*
*------
__________________
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/
Reply With Quote
Reply

Tags
phpmybittorrent , v20

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
What is phpMyBitTorrent joeroberts BT.Manager (phpMyBitTorrent) 0 14th October 2009 15:43
phpMyBitTorrent 2.0.3 joeroberts BT.Manager (phpMyBitTorrent) 54 21st September 2009 13:10
req phpmybittorrent TheArcadeMaster BT.Manager (phpMyBitTorrent) 1 9th May 2009 06:33
What I Think Of phpMyBittorrent dark_dragon BT.Manager (phpMyBitTorrent) 1 10th November 2008 07:43
phpMyBitTorrent v1.0 zenja7777 BT.Manager (phpMyBitTorrent) 8 27th October 2008 17:58



All times are GMT +2. The time now is 22:22. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2022, vBulletin Solutions Inc.