* Torrent Tracker for vB 3.5.4 *

[toolmanwill]

msn = vze27hv5@verizon.net
yahoo = wvatschool

I've got a new release coming by sunday which will include all bugfixes as well as additional features.

[Revpolar]

thank you.

[toolmanwill]

Originally Posted by ericgtr

Okay, so it's built in for the php version, thanks. Also, I had the issue with forumdisplay where it gave me the "Column 'size' in field list is ambiguous" error. for anyone else installing this, here is the fix http://borget.info/forum/viewtopic.php?p=444#p444

We are going to start testing it on my board, I will report back on how it's working. Thanks again for this, toolmanwill.

That site is down but the fix is in showthread.php find:

	// load attachments
	if ($thread['attach'])
	{
		$attachments = $db->query_read("
			SELECT dateline, thumbnail_dateline, filename, filesize, visible, attachmentid, counter,
				postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize,
				attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
			FROM " . TABLE_PREFIX . "attachment
			LEFT JOIN " . TABLE_PREFIX . "attachmenttype AS attachmenttype USING (extension)
			WHERE postid IN (-1" . $ids . ")
			ORDER BY attachmentid
		");

replace with :

// load attachments
	if ($thread['attach'])
	{
		$attachments = $db->query_read("
			SELECT info_hash, attachment.size,comment,created_by,announce_list,completed_by, completed, seeders, leechers, ulspeed, dlspeed, dateline, thumbnail_dateline, filename, filesize, visible, attachmentid, counter,
				postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize,
				attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
			FROM " . TABLE_PREFIX . "attachment
			LEFT JOIN " . TABLE_PREFIX . "attachmenttype AS attachmenttype USING (extension)
			WHERE postid IN (-1" . $ids . ")
			ORDER BY attachmentid
		");

Thanx to Rev for the fix!!!

[eXtremeTim]

I am also hard at work on a torrent tracker that wont rely on the forums and attachment systems. My torrent tracker will have unpresidented control over every aspect of it. As well as advanced reporting advanced perm controls and so much more. You will have the ability to ban users from downloading certain torrents as well as torrents in certain categories and so much more.

Not to mention ability to ban users from downloading torrents due to bad ratio and allow them to seed only.

[toolmanwill]

that will be interesting to see.

[eXtremeTim]

yea i have already figured out how to go about pulling everything off i just have to get the code finished but im not trying to rush it since its some complex code to pull off everything i want.

[Revpolar]

Originally Posted by toolmanwill

Thanx to Rev for the fix!!!

No problem at all bud. BTW we managed to fix all known bugs including the Division By Zero error. That error occurs when using mysql older than 5.0.20 but we found a work around for it. It was cool to help out Will on this. The Vbulletin tracker works better than any of the other out there. I know because Ive used them all. Im only speaking for the XBT version that hasnt been released yet.

[toolmanwill]

Now in FINAL release.
VBTT 3 for XBT v1.0 FINAL - http://sourceforge.net/project/showf...ease_id=459292

[LaCN]

And that one is for vb 3.6.2 ?

And as someone asked in here earlier, what exactly is this torrent-tracker for, and how does it work ?
I know torrents are p2p-stuff... so where does the forum step in ?
And how does this involve the bandwith ?

[toolmanwill]

Yes this is for 3.6.x versions only.
What a torrent tracker does is it manages torrent downloads thru your vbulletin forum, allowing you to post new torrents by attaching them as a normal attachment. As far as bandwidth goes, I have made VBTT 3 for XBT to be as lean as possible and it uses existing db tables rather than using extra tables. It also has a lot of visual features that would pertain to a torrent tracker(uploaded/downloaded, ratio, ul/dl speeds, etc)