Bravo List

Bravo List (http://www.bvlist.com/index.php)
-   Downloads (http://www.bvlist.com/forumdisplay.php?f=16)
-   -   phpMyBitTorrent v2.0 (http://www.bvlist.com/showthread.php?t=1042)

joeroberts 22nd September 2008 14:21

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.

Fynnon 26th September 2008 14:45

great news joe, the new tracker theme looks great ;-)

aikyam 26th September 2008 21:26

Quote:

Originally Posted by joeroberts (Post 4405)
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 :smack:

Fynnon 26th September 2008 21:40

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 !

aikyam 27th September 2008 00:17

Quote:

Originally Posted by Fynnon (Post 4475)
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 :friend:

Demo: www.aikyam.org

joeroberts 27th September 2008 01:22

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??

aikyam 27th September 2008 03:01

Quote:

Originally Posted by joeroberts (Post 4481)
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... :drink:

";
        echo "\n";
        echo "\n";
        echo "
joeroberts 27th September 2008 07:14

what language are you using?

need you to try these new files please
5.php
Code:

/*
*-------------------------------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"";

$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 "         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."
";
}

function drawRow($param, $type, $options = NULL) {
        global $cfgrow, $textarea;
        echo "

";
        help("",constant("_admp".$param."explain"),constant("_admp".$param));
        echo "

".constant("_admp".$param)."

";
        if ($type == "text") {
                echo "";
        } elseif ($type == "select") {
                echo "";
        } elseif ($type == "checkbox") {
                echo "                 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 "

\n";
                echo "

";


        }
        echo "

\n";
        echo "\n";
}
function drawConfig() {
        echo "\n";
        echo "\n";
        echo "\n";
        echo "\n";
        drawRow("sitename","text");
        drawRow("siteurl","text");
        drawRow("cookiedomain","text");
        drawRow("cookiepath","text");
        drawRow("admin_email","text");
        echo "\n";
        echo "\n";
        echo "\n";
        echo "\n";
        echo "\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 "

"._basicsettings."

 

 

 

 

"._advancedsettings."

 

 

\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 "\n";

                echo "

"._step5."

\n";
                echo "

 

\n";

                echo "

";
                echo "";
                echo _btsqlerror1."\n";
                echo "" ;
                echo _btsqlerror2.$err["code"];
                echo "";
                echo _btsqlerror3.$err["message"];
                echo "

";


                echo "

"._step5explain."

\n";
                echo "

 

\n";

                drawConfig();

                echo "

\n";
        } else {
                echo "\n";
                echo "

"._step5complete."

";
                echo "

\n";
        }
} else {
        echo "\n";

        echo "

"._step5."

\n";
        echo "

 

\n";
        echo "

"._step5explain."

\n";
        echo "

 

\n";

        drawConfig();

        echo "

\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;


aikyam 27th September 2008 09:53

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 (Post 4488)
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

joeroberts 27th September 2008 14:10

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 --*
*--                                                                          --*
*------------------------------------------------------------------------------*
*------



All times are GMT +2. The time now is 10:08.

Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2021, vBulletin Solutions Inc.