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


aikyam 27th September 2008 15:09

The installation just went perfectly.... :ok:

I am just checking the integration options from the tracker control panel

Starter issues seen:

1) Header logo is not seen on the main screen.

2) when i click on forums i get

Code:

Warning: include(./tforum/html/index.php) [function.include]: failed to open stream: No such file or directory in /home/aikyam0/public_html/tforum/html/phpBB.php on line 289

Warning: include(./tforum/html/index.php) [function.include]: failed to open stream: No such file or directory in /home/aikyam0/public_html/tforum/html/phpBB.php on line 289

Warning: include() [function.include]: Failed opening './tforum/html/index.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/aikyam0/public_html/tforum/html/phpBB.php on line 289

Actually my phpbb3 files are located in tforum/html folder (No phpBB3 folder)

and thus the main page to the forum should be linked to aikyam.org • Index page

Also Joe please clarify why the does the forum point to /phpbb.php instead of index.php ? :s

joeroberts 27th September 2008 15:27

can you post content of tracker admin/forum settings??
you need to use the included phpBB3 folder for intergration as it is very much modded to work

aikyam 27th September 2008 15:38

The admin/forum settings are as follows,

Forum Data Base Prefix phpbb
Cookie Name phpbb3_k27c3
Forum Domain Aikyam - Where our family unites
Forum Cookie Path /
Cookie Time 3
Base Folder Your Forum Is in tforum/html
Turn on Forum Share Ticked
Turn on Auto Posting Ticked
Post New Toppic In 2

Quote:

you need to use the included phpBB3 folder for intergration as it is very much modded to work
Oh :wallbash:

I will delete everything and try from start again if i am unable to link the forum from the torrent page..Is it not possible to do any edit on the header file for the links?

joeroberts 27th September 2008 15:42

Quote:

Is it not possible to do any edit on the header file for the links?
you can edit the theme header yes got to Themes/pmbt/main.php find function themeheader() and the header is in there


Forum Data Base Prefix phpbb this is right
Cookie Name phpbb3_k27c3 this is ok
Forum Domain Aikyam - Where our family unites
Forum Cookie Path /
Cookie Time 3
Base Folder Your Forum Is in tforum/html this is wayyy wrong it you want to do away with tracker index you can just leave blank
Turn on Forum Share Ticked
Turn on Auto Posting Ticked

Krypto 27th September 2008 22:17

Looking good Joe :D

Managed to get it all installed, uploaded a torrent but I cannot seem to download it in order to Seed I just get a blank page!

The torrent is in the DB and the torrents Dir and seems to be linking to the correct torrent id which being the first upload in 1.

This is the only part I've found an issue with so far.

Edit just noticed that I don't need to re-download the torrent, I presume the Passkey is not installed as yet? As in the setting I tick to use the Passkey but the setting does not save.

Issues:-

Font on Polls unreadable too small

Torrent Search if no input string is entered receive this error

Quote:

SQL Error

Error executing SQL Query SELECT COUNT(*) as tot FROM torrent_torrents WHERE AND visible = 'yes'
Error ID: 0
Error Message:
Edit Torrents - Unable to edit all the torrent details, plus no way of saving

Viewing Forum Posts - Receive this error
Quote:

[phpBB Debug] PHP Notice: in file /viewtopic.php on line 1582: include(/includes/prime_quick_reply.php): failed to open stream: No such file or directory
[phpBB Debug] PHP Notice: in file /viewtopic.php on line 1582: include(): Failed opening '/includes/prime_quick_reply.php' for inclusion (include_path='.;C:/apache2triad/php;C:/apache2triad/php/smarty;C:/apache2triad/php/pear')

joeroberts 27th September 2008 23:53

give me a few let me clean and find errors

Quote:

Originally Posted by joeroberts (Post 4530)
give me a few let me clean and find errors

ok here we go phpMyBitTorrent V2.0 beta 2 is ready for testing
SourceForge.net: Files



Made some fixes
fixed Ajax for being in sub folder
fixed phpBB3 viewtopic for missplaced modd
fixed web install for many errors
fixed ajax pm notice
fixed minor lay out problems
fixed minor sql error

Krypto 28th September 2008 14:02

Testing now.

One issue is that until you change your 'Complete Name' in your Profile the Who's Online always shows you as your email address.

joeroberts 28th September 2008 14:04

Quote:

Originally Posted by Krypto (Post 4540)
Testing now.

One issue is that until you change your 'Complete Name' in your Profile the Who's Online always shows you as your email address.

is that what you entered as user name when you created admin??

Krypto 28th September 2008 14:45

I could have sworn I entered my username in the username field? Will check it out further.

Upon logging out and then logging in I get redirected to a blank page http://xxxxxxxxxxx/user.php?returnto=/index.php

Download still returns a blank page http://xxxxxxxxxxxx/download.php?id=1

Edit Torrent still does not load the complete page
http://img258.imageshack.us/img258/4717/86093338at7.png

BBCodes do not show on torrent details page it appears as :thankyou: instead of the graphical representation.

joeroberts 28th September 2008 14:52

Quote:

Originally Posted by Krypto (Post 4542)
I could have sworn I entered my username in the username field? Will check it out further.

Upon logging out and then logging in I get redirected to a blank page http://xxxxxxxxxxx/user.php?returnto=/index.php

Download still returns a blank page http://xxxxxxxxxxxx/download.php?id=1

Edit Torrent still does not load the complete page
http://img258.imageshack.us/img258/4717/86093338at7.png

BBCodes do not show on torrent details page it appears as :thankyou: instead of the graphical representation.

please go to admin pannel and check what you have intered as site url let me know if it is blank

ancraz 28th September 2008 16:04

thz a lot for this great script :).i love it

Krypto 29th September 2008 07:54

This is what I have:-

Site Name: Test Site
Site URL: http://www.xxxxx.com
Cookie Domain: http://www.xxxxx.com
Cookie Path:
Administrator E-Mail: myemailaddress

Cookie Path is empty as am testing the code in the root dir.

joeroberts 29th September 2008 11:15

cookie Domain is with out http://

ancraz 29th September 2008 17:13

i fund some bugs
when using imdb mod to add data

Code:

IMDB INFO

Warning: unlink(./cache/index.html) [function.unlink]: Permission denied in /home/public_html/imdb/imdb.class.php on line 235

Warning: gzopen(./cache//0265086.Title) [function.gzopen]: failed to open stream: Permission denied in /home/public_html/imdb/imdb.class.php on line 116

Warning: gzputs(): supplied argument is not a valid stream resource in /home/public_html/imdb/imdb.class.php on line 117

Warning: gzclose(): supplied argument is not a valid stream resource in /home/public_html/imdb/imdb.class.php on line 118

Warning: gzopen(./cache//0265086.Credits) [function.gzopen]: failed to open stream: Permission denied in /home/public_html/imdb/imdb.class.php on line 116

Warning: gzputs(): supplied argument is not a valid stream resource in /home/public_html/imdb/imdb.class.php on line 117

Warning: gzclose(): supplied argument is not a valid stream resource in /home/public_html/imdb/imdb.class.php on line 118

Warning: gzopen(./cache//0265086.Plot) [function.gzopen]: failed to open stream: Permission denied in /home/public_html/imdb/imdb.class.php on line 116

Warning: gzputs(): supplied argument is not a valid stream resource in /home/public_html/imdb/imdb.class.php on line 117

Warning: gzclose(): supplied argument is not a valid stream resource in /home/public_html/imdb/imdb.class.php on line 118

Warning: fopen(./imdb_images/0265086.jpg) [function.fopen]: failed to open stream: Permission denied in /home/public_html/imdb/imdb.class.php on line 530

this what i got when i tried to upload torrent.only some times
Code:

Error executing SQL Query INSERT INTO torrent_torrents (info_hash, name, filename, save_as, md5sum, search_text, descr, size, plen, category, type, numfiles, added, exeem, dht, backup_tracker, views, downloaded, completed, banned, password, visible, evidence, owner, ownertype, uploader_host, numratings, ratingsum, seeders, leechers, tot_peer, speed, comments, complaints, tracker, tracker_list, tracker_update, last_action, imdb) VALUES ('?`,?jC???????', 'XXX 2 The Next Level KLAXXON [mininova]', 'XXX 2 The Next Level KLAXXON', 'XXX 2 The Next Level KLAXXON [mininova]', '17dc4ee747f8d388ecaed3342d26e963', 'XXX 2 The Next Level KLAXXON [mininova] XXX 2 The Next Level KLAXXON xxx 2 KLAXXON.nfo 271 XXX 2 The Next Level KLAXXON.avi 1079214080 ', 'xxx 2', '1079214351', '65536', '1', 'multi', '2', NOW(), '', 'no', 'false', '0', '0', '1350', 'no', NULL, 'no', '0', '2', '0', '59.92.36.85', '0', '0', '117', '187', '304', '0', '0', '0,0', 'http://vip.tracker.thepiratebay.org:80/announce', 'http://vip.tracker.thepiratebay.org:80/announce http://tracker4.finalgear.com:80/announce http://vtv.tracker.prq.to:80/announce http://tracker.prq.to:80/announce', NOW(), NOW(), '');
Error ID: 2006
Error Message: MySQL server has gone aw

in the admin panel there is duplication of offres_config and i get the error
Code:

Warning: require_once(admin/files/offres_config.php) [function.require-once]: failed to open stream: No such file or directory in /home/public_html/admin.php on line 129

Fatal error: require_once() [function.require]: Failed opening required 'admin/files/offres_config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/public_html/admin.php on line 129

one more thing no one is geeting any e-mail for verification
plz help :)

sorry if the above detail is confusing
iam using v2beta2

Krypto 29th September 2008 18:33

Quote:

Originally Posted by joeroberts (Post 4567)
cookie Domain is with out http://

Have removed the http:// part and it's still the same!

joeroberts 1st October 2008 08:20

Quote:

Originally Posted by Krypto (Post 4577)
Have removed the http:// part and it's still the same!

remove www. to

Quote:

Originally Posted by ancraz (Post 4576)
i fund some bugs
when using imdb mod to add data

Code:

IMDB INFO

Warning: unlink(./cache/index.html) [function.unlink]: Permission denied in /home/public_html/imdb/imdb.class.php on line 235

Warning: gzopen(./cache//0265086.Title) [function.gzopen]: failed to open stream: Permission denied in /home/public_html/imdb/imdb.class.php on line 116

Warning: gzputs(): supplied argument is not a valid stream resource in /home/public_html/imdb/imdb.class.php on line 117

Warning: gzclose(): supplied argument is not a valid stream resource in /home/public_html/imdb/imdb.class.php on line 118

Warning: gzopen(./cache//0265086.Credits) [function.gzopen]: failed to open stream: Permission denied in /home/public_html/imdb/imdb.class.php on line 116

Warning: gzputs(): supplied argument is not a valid stream resource in /home/public_html/imdb/imdb.class.php on line 117

Warning: gzclose(): supplied argument is not a valid stream resource in /home/public_html/imdb/imdb.class.php on line 118

Warning: gzopen(./cache//0265086.Plot) [function.gzopen]: failed to open stream: Permission denied in /home/public_html/imdb/imdb.class.php on line 116

Warning: gzputs(): supplied argument is not a valid stream resource in /home/public_html/imdb/imdb.class.php on line 117

Warning: gzclose(): supplied argument is not a valid stream resource in /home/public_html/imdb/imdb.class.php on line 118

Warning: fopen(./imdb_images/0265086.jpg) [function.fopen]: failed to open stream: Permission denied in /home/public_html/imdb/imdb.class.php on line 530


please chmod cache folder and imdb_images to 777
Quote:

Originally Posted by ancraz (Post 4576)
this what i got when i tried to upload torrent.only some times
Code:

Error executing SQL Query INSERT INTO torrent_torrents (info_hash, name, filename, save_as, md5sum, search_text, descr, size, plen, category, type, numfiles, added, exeem, dht, backup_tracker, views, downloaded, completed, banned, password, visible, evidence, owner, ownertype, uploader_host, numratings, ratingsum, seeders, leechers, tot_peer, speed, comments, complaints, tracker, tracker_list, tracker_update, last_action, imdb) VALUES ('?`,?jC???????', 'XXX 2 The Next Level KLAXXON [mininova]', 'XXX 2 The Next Level KLAXXON', 'XXX 2 The Next Level KLAXXON [mininova]', '17dc4ee747f8d388ecaed3342d26e963', 'XXX 2 The Next Level KLAXXON [mininova] XXX 2 The Next Level KLAXXON xxx 2 KLAXXON.nfo 271 XXX 2 The Next Level KLAXXON.avi 1079214080 ', 'xxx 2', '1079214351', '65536', '1', 'multi', '2', NOW(), '', 'no', 'false', '0', '0', '1350', 'no', NULL, 'no', '0', '2', '0', '59.92.36.85', '0', '0', '117', '187', '304', '0', '0', '0,0', 'http://vip.tracker.thepiratebay.org:80/announce', 'http://vip.tracker.thepiratebay.org:80/announce http://tracker4.finalgear.com:80/announce http://vtv.tracker.prq.to:80/announce http://tracker.prq.to:80/announce', NOW(), NOW(), '');
Error ID: 2006
Error Message: MySQL server has gone aw


I well look into this

Quote:

Originally Posted by ancraz (Post 4576)
in the admin panel there is duplication of offres_config and i get the error
Code:

Warning: require_once(admin/files/offres_config.php) [function.require-once]: failed to open stream: No such file or directory in /home/public_html/admin.php on line 129

Fatal error: require_once() [function.require]: Failed opening required 'admin/files/offres_config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/public_html/admin.php on line 129

one more thing no one is geeting any e-mail for verification
plz help :)

sorry if the above detail is confusing
iam using v2beta2

remove the folder that refres to offres_config it is the wrong link I removed it from source now

Krypto 1st October 2008 21:05

Quote:

Originally Posted by joeroberts (Post 4606)
remove www. to

Done that still makes no difference?

STill unable to use the download torrent or edit torrent options, plus once I log out I cannot log back in again!

I have to remove this part fropm the URL to be able to login user.php?returnto=/index.php

EDIT:
I can edit torrents if I Disable 'Use HTML Editor' in the Site Settings

No Option available to UnSticky a Torrent.

joeroberts 2nd October 2008 01:28

where are you trying to login from that well not log you In and that you have to remove
Code:

user.php?returnto=/index.php
Quote:

Originally Posted by Krypto (Post 4614)
Done that still makes no difference?


Quote:

Originally Posted by Krypto (Post 4614)
STill unable to use the download torrent or edit torrent options, plus once I log out I cannot log back in again!

I have found this error and repared
Quote:

Originally Posted by Krypto (Post 4614)
I have to remove this part fropm the URL to be able to login user.php?returnto=/index.php

Need more in put

Quote:

Originally Posted by Krypto (Post 4614)
EDIT:
I can edit torrents if I Disable 'Use HTML Editor' in the Site Settings

No Option available to UnSticky a Torrent.

found and repaired

Krypto 2nd October 2008 07:30

Quote:

Originally Posted by joeroberts (Post 4617)
where are you trying to login from that well not log you In and that you have to remove
Code:

user.php?returnto=/index.php

If I logout then try to log back in again it take me to this URL http://www.xxxxxxxxx/user.php?returnto=/index.php which gives me a white screen, but if I remove user.php?returnto=/index.php from the end of the URL then I'm logged in!

joeroberts 2nd October 2008 13:24

can you open
user.php
and find
Code:

                                                                                header("Refresh: 0; url=".$siteurl."/user.php?op=loginconfirm&returnto=".$returnto);
on or about line 94
and replace it with
Code:

                                                                                header("Location: ".$siteurl."/user.php?op=loginconfirm&returnto=".$returnto);
and
Code:

                        header("Refresh: 3; url=" . $returnto);
at or about line 111
replace with
Code:

                        echo "";
and tell me if that helps your login?

Krypto 2nd October 2008 19:00

Thanks Joe, but still the same I'm afraid.

joeroberts 3rd October 2008 02:09

Quote:

Originally Posted by Krypto (Post 4630)
Thanks Joe, but still the same I'm afraid.

is your site set to private mode?

Krypto 3rd October 2008 07:33

Private Tracker Mode is Enabled.

joeroberts 4th October 2008 09:45

phpMyBitTorrentV2.0 Beta3
 
we are now moving in to beta3 testing with any luck we have got all the errors straight that have been posted here and look forward to finding more and getting them fixed!!
you can get your copy now here https://sourceforge.net/project/show...kage_id=203349

Krypto 4th October 2008 22:18

Reinstalled with latest version and when I log in I get logged straight back out again!

piku2008 5th October 2008 08:53

Quote:

Originally Posted by Krypto (Post 4710)
Reinstalled with latest version and when I log in I get logged straight back out again!

thats the same problem i have faced thats the biggeest bug in this source i have seen:coffee:

joeroberts 5th October 2008 14:17

looking into this now dose any one have a link I can fallow to test this? please pm it to me

joeroberts 5th October 2008 14:41

Quote:

Originally Posted by piku2008 (Post 4717)
thats the same problem i have faced thats the biggeest bug in this source i have seen:coffee:

can you pm me you siteurl cookiedomain and cookie path?

piku2008 5th October 2008 17:30

Quote:

Originally Posted by joeroberts (Post 4728)
can you pm me you siteurl cookiedomain and cookie path?

sorry but i have deleted the source from web hosting some time ago so sorry but plzz fix the bug :wallbash:

joeroberts 5th October 2008 17:47

Quote:

Originally Posted by piku2008 (Post 4734)
sorry but i have deleted the source from web hosting some time ago so sorry but plzz fix the bug :wallbash:

i well with some help as it works fine in test site


All times are GMT +2. The time now is 21:49.

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