The Arcive of Official vBulletin Modifications Site.

Nu Torrent Tracker 0.74 · **Released**: 06-06-2005

Finally, my bittorrent tracker for vBulletin has reached a somewhat betaish level. Meaning, it functions but some things are still missing like AdminCP Category Editing and so on. But only a few. All needed things are there and it works well as I've been running it on my board for a month now.

I decided to write this thing after firsthand witnessing the problems with VBTT and what was first meant to be quite simple turned out into a full fledged tracker with features like commenting, rating, etc.

Note that this is a beta which means it has only been tested on one system AND I won't be responsible if you go blind from the messy code. But hey, it works! :nervous:

I don't have any screenshots but you are welcome to come and check out the live demo at: http://www.tokyo-nights.com/nutt
Heck, I'll even throw in a test user for ya:

Code:

user: kjustice
pass: useme

I'll prolly be updating the distro as I find and fix bugs. When the instructions say so or if you wish to, you can uninstall it by going to /forum/admincp/nutt_install.php?step=uninstall

0.74 - Made upload use vB's new thread function to fix the nasty apostrophe issue in 0.73
Changed:
upload.php

0.73 - Improved conditions for users the tracker reports as 'unconnectable'.
Changed:
announce.php

0.72 - Added a function to fix the navbar urls.
Changed:
functions.php
nutt_global.php

0.71 - Fixed a bug in details.php.
Changed:
details.php

DjTaz · #**162** 07-10-2005, 12:53 PM

I commented this bit on the Upload.php and it seems to let me upload from any tracker now ... havent tested to see if they actually work yet but they do upload no problems

Upload.php line 206-208

Code:

//////	//if ($ann !== $vboptions['nutt_announceurl']){
//////	//	eval(print_standard_redirect('redirect_invannurl'));
//////     }

DjTaz · #**163** 07-10-2005, 04:21 PM

Im not sure if this would be a help to anyone , and itll prob be included in the next version anyway , but i did a quick script for myself to edit the catagories in version .74 - its 3 new files , and one replaced file (just one line edited at the bottom to add in a link to the catagories section)

Anyway , it will let you edit the catagories , delete some , and add in new ones ... hope it works ok for everyone .. the connect.php is needed as im unsure of the codes for VBB to connect the the database , but ill learn that soon.

efd702 · #**164** 07-10-2005, 06:32 PM

when i try to generate a passkey i get this error

mysql error: Table 'wireles3_efd702.vb3_nutt_peers' doesn't exist

when i check my database for this directory its 'wireles3_efd702.nutt_peers' and not 'wireles3_efd702.vb3_nutt_peers' what can i do to correct this.
thanks

DjTaz · #**165** 07-11-2005, 11:13 PM

I think sketch is having the same issue efd .. i think the database prefix issue needs to be addressed here for the next version also - it works great if you dont have a prefix , but theres issues if you have

sketch42 · #**166** 07-12-2005, 02:02 AM

PHP Code:


			
// ################################ Create NuTT Tables ###############################

if ($_REQUEST['step'] == 5)

{

        echo "Adding Table nutt_cats<br />";

        

        $DB_site->query("CREATE TABLE `nutt_cats` (

                                        `id` mediumint(9) NOT NULL auto_increment,

                                        `title` varchar(50) NOT NULL default '',

                                        `options` int(10) NOT NULL default '0',

                                        `pic` varchar(255) NOT NULL default '',

                                        PRIMARY KEY  (`id`),

                                        KEY `id` (`id`)

                                        ) TYPE=MyISAM;");

        

        echo "Adding Table nutt_files<br />";

        $DB_site->query("CREATE TABLE `nutt_files` (

                                        `id` int(10) NOT NULL auto_increment,

                                        `torrent` int(10) NOT NULL default '0',

                                        `filename` varchar(150) NOT NULL default '',

                                        `size` int(25) NOT NULL default '0',

                                        PRIMARY KEY  (`id`)

                                        ) TYPE=MyISAM;");

        

        echo "Adding Table nutt_peers<br />";

        $DB_site->query("CREATE TABLE `nutt_peers` (

                                        `id` int(10) unsigned NOT NULL auto_increment,

                                        `torrent` int(10) unsigned NOT NULL default '0',

                                        `peer_id` varchar(20) NOT NULL default '',

                                        `ip` varchar(64) NOT NULL default '',

                                        `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',

                                        `seeder` enum('yes','no') NOT NULL default 'no',

                                        `started` int(11) NOT NULL default '0',

                                        `last_action` int(11) NOT NULL default '0',

                                        `connectable` enum('yes','no') NOT NULL default 'yes',

                                        `userid` int(10) unsigned NOT NULL default '0',

                                        `agent` varchar(60) NOT NULL default '',

                                        `finishedat` int(10) unsigned NOT NULL default '0',

                                        `downloadoffset` bigint(20) unsigned NOT NULL default '0',

                                        `uploadoffset` bigint(20) unsigned NOT NULL default '0',

                                        `passkey` varchar(32) NOT NULL default '',

                                        PRIMARY KEY  (`id`),

                                        UNIQUE KEY `torrent_peer_id` (`torrent`,`peer_id`),

                                        KEY `torrent` (`torrent`),

                                        KEY `torrent_seeder` (`torrent`,`seeder`),

                                        KEY `last_action` (`last_action`),

                                        KEY `connectable` (`connectable`),

                                        KEY `userid` (`userid`)

                                        ) TYPE=MyISAM;");

        

        echo "Adding Table nutt_rate<br />";

        $DB_site->query("CREATE TABLE `nutt_rate` (

                                        `id` int(11) NOT NULL auto_increment,

                                        `rate` int(11) NOT NULL default '0',

                                        `torrent` int(11) NOT NULL default '0',

                                        `userid` int(11) NOT NULL default '0',

                                        `ip` varchar(62) NOT NULL default '',

                                        `time` int(11) NOT NULL default '0',

                                        PRIMARY KEY  (`id`)

                                        ) TYPE=MyISAM;");

        

        echo "Adding Table nutt_torrents<br />";

        $DB_site->query("CREATE TABLE `nutt_torrents` (

                                        `id` int(10) NOT NULL auto_increment,

                                        `threadid` int(10) NOT NULL default '0',

                                        `filename` varchar(255) NOT NULL default '',

                                        `owner` varchar(255) NOT NULL default '0',

                                        `ownerm` varchar(255) NOT NULL default '',

                                        `ownerid` int(10) NOT NULL default '0',

                                        `visible` varchar(5) NOT NULL default '',

                                        `deleted` varchar(10) NOT NULL default 'no',

                                        `hash` varchar(255) NOT NULL default '',

                                        `name` varchar(255) NOT NULL default '',

                                        `size` int(25) NOT NULL default '0',

                                        `numfiles` int(10) NOT NULL default '0',

                                        `type` varchar(10) NOT NULL default '',

                                        `descr` mediumtext NOT NULL,

                                        `cat` int(10) NOT NULL default '0',

                                        `save` varchar(255) NOT NULL default '',

                                        `added` int(25) NOT NULL default '0',

                                        `last_action` int(25) NOT NULL default '0',

                                        `downloaded` int(10) NOT NULL default '0',

                                        `seeders` int(10) NOT NULL default '0',

                                        `leechers` int(10) NOT NULL default '0',

                                        `rated` mediumtext NOT NULL,

                                        `comments` int(11) NOT NULL default '0',

                                        PRIMARY KEY  (`id`)

                                        ) TYPE=MyISAM;");



        echo "<br />NuTT Tables Added!<br /><br />";



        //         insert data

        $DB_site->query("INSERT INTO `nutt_cats` VALUES (1, 'MP3', 0, 'mp3.gif')");

        $DB_site->query("INSERT INTO `nutt_cats` VALUES (2, 'Single', 0, 'single.gif')");

        $DB_site->query("INSERT INTO `nutt_cats` VALUES (3, 'Album', 0, 'album.gif')");

        $DB_site->query("INSERT INTO `nutt_cats` VALUES (4, 'PV', 0, 'pv.gif')");

        $DB_site->query("INSERT INTO `nutt_cats` VALUES (5, 'DVD', 0, 'dvd.gif')");

        $DB_site->query("INSERT INTO `nutt_cats` VALUES (6, 'Images', 0, 'img.gif')");

        $DB_site->query("INSERT INTO `nutt_cats` VALUES (7, 'TV', 0, 'tv.gif')");

        $DB_site->query("INSERT INTO `nutt_cats` VALUES (8, 'Performance', 0, 'perf.gif')");

        $DB_site->query("INSERT INTO `nutt_cats` VALUES (9, 'Misc', 0, 'misc.gif')");



        echo "<br />NuTT Tables Populated!<br /><br />";



        $DB_site->query("ALTER TABLE ".TABLE_PREFIX."usergroup ADD nuttpermissions INT(10) UNSIGNED DEFAULT '0' NOT NULL");

        $DB_site->query("UPDATE ".TABLE_PREFIX."usergroup SET nuttpermissions='511' WHERE usergroupid='6'");

        $DB_site->query("ALTER TABLE ".TABLE_PREFIX."user ADD uploaded BIGINT(20) DEFAULT '0' NOT NULL");

        $DB_site->query("ALTER TABLE ".TABLE_PREFIX."user ADD downloaded BIGINT(20) DEFAULT '0' NOT NULL");

        $DB_site->query("ALTER TABLE ".TABLE_PREFIX."user ADD tempuploaded BIGINT(20) DEFAULT '0' NOT NULL");

        $DB_site->query("ALTER TABLE ".TABLE_PREFIX."user ADD tempdownloaded BIGINT(20) DEFAULT '0' NOT NULL");

        $DB_site->query("ALTER TABLE ".TABLE_PREFIX."user ADD tempreset INT(10) UNSIGNED DEFAULT '0' NOT NULL");

        $DB_site->query("ALTER TABLE ".TABLE_PREFIX."user ADD passkey VARCHAR(32) DEFAULT '0' NOT NULL");

        $DB_site->query("ALTER TABLE ".TABLE_PREFIX."user ADD agent VARCHAR(255) DEFAULT '0' NOT NULL");



        echo "<br />vBulletin Tables Updated!<br /><br />";

        

}

this is from the nut_install.php , i need to know is it as simple as changing this

PHP Code:


			
$DB_site->query("CREATE TABLE `nutt_rate` (

                                        `id` int(11) NOT NULL auto_increment,

                                        `rate` int(11) NOT NULL default '0',

                                        `torrent` int(11) NOT NULL default '0',

                                        `userid` int(11) NOT NULL default '0',

                                        `ip` varchar(62) NOT NULL default '',

                                        `time` int(11) NOT NULL default '0',

                                        PRIMARY KEY  (`id`)

                                        ) TYPE=MyISAM;");

to this???

PHP Code:


			
$DB_site->query("CREATE TABLE . TABLE PREFIX. `nutt_rate` (

                                        `id` int(11) NOT NULL auto_increment,

                                        `rate` int(11) NOT NULL default '0',

                                        `torrent` int(11) NOT NULL default '0',

                                        `userid` int(11) NOT NULL default '0',

                                        `ip` varchar(62) NOT NULL default '',

                                        `time` int(11) NOT NULL default '0',

                                        PRIMARY KEY  (`id`)

                                        ) TYPE=MyISAM;");

And if so what other files do i need to edit that call to the tables

sketch42 · #**167** 07-12-2005, 06:14 AM

ok well Marco64 helped me out in finding what queries to run in phpmyadmin to rename the table names
for anyone else that needs it

Quote:

Originally Posted by MarcoH64

[sql]RENAME TABLE tablename TO prefix_tablename;[/sql]

sketch42 · #**168** 07-12-2005, 06:23 AM

a few questions now that finally everything is setup
1) I created a forum and specified its forum id in the nutt settings .. however when i click on the forum link it doesnt goto /nutt any idea why its doing that?

and
2) whenever i try uploading a torrent i keep getting this error that the announce url is wrong(see attachment) but the announce url is correct ( see attachment2) any ideas?

afusion · #**169** 07-12-2005, 08:19 AM

1) The forum is for torrent commenting functions. It's supposed to be a normal forum.

2) You need to set the announce URL in the settings.

sketch42 · #**170** 07-12-2005, 08:36 AM

Quote:

Originally Posted by afusion

1) The forum is for torrent commenting functions. It's supposed to be a normal forum.

2) You need to set the announce URL in the settings.

it is set in the nutt settings

DjTaz · #**171** 07-13-2005, 09:03 AM

sketch - yeah - the settings in the admincp - vboptions- nutt options .. theres an announce url in there ... use the same url as that to make torrents. i discovered mine had an extra space at the end , and it wouldnt work, so make sure theres no spaces

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05227 seconds Memory Usage 2,385KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (3)bbcode_php (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!