vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)
-   -   Nu Torrent Tracker 0.74 (https://vborg.vbsupport.ru/showthread.php?t=82635)

yoyoyoyo 06-08-2005 02:27 PM

Everything seemed to install fine, however when I went to upload a torrent file I got this error:

Quote:

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*,

avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,
level,
NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE threadid = 2165 AND post.visible = 1
ORDER BY dateline ASC
LIMIT 1

mysql error: Unknown column 'level' in 'field list'

mysql error number: 1054

Date: Wednesday 08th of June 2005 10:23:31 AM
Script: http://mysite.com/nutt/details.php?t=1&uploaded=1
Referer: http://mysite.com/nutt/upload.php
Username: ADMINISTRATOR
IP Address: 67.00.200.205

afusion 06-08-2005 02:38 PM

try the details.php in the new zip

Outdoor 06-08-2005 04:30 PM

in NUTT template you still have 1 hard coded link, it is who's online that links back to your website.

afusion 06-08-2005 04:44 PM

Thanks for the notice, updated the zip.

Outdoor 06-08-2005 05:11 PM

having one other problem, in the navbar on the Nutt pages it always has mywebsite/nutt/index.php when trying to get back into the forum, mywebsite/nutt/memberlist.php when trying to access my forum memberlist. Not sure what setting to change for it.

thanks again, looks very nice, can't wait to get a torrent going

afusion 06-08-2005 05:28 PM

Ok, I added a function to fix the urls. Update to 0.72 with functions.php and nutt_global.php changed.

Outdoor 06-08-2005 05:47 PM

looks good, thanks again

yoyoyoyo 06-08-2005 06:16 PM

that fixed the errors.. thanks much! works great! However, I tried deleting the upload that got a database error via the NUTT maintenance php, but nothing was deleted, it was still listed as an "unseeded" torrent. Is there any way to reset all of the uploads, including unseeded torrents? Also the ability to add comments, etc. seems to be not working in this version for some reason.

afusion 06-08-2005 06:25 PM

The only deletion option in nutt_maintenance is to delete all threads generate by NuTT. To delete the torrent itself you have to make sure you got the permissions to do so (Usergroup Permissions) and do it via the details page, in the bottom there should be an edit area.

And the comments don't work how exactly? The New Comment link is broken or... ?

yoyoyoyo 06-08-2005 06:39 PM

Quote:

Originally Posted by afusion
The only deletion option in nutt_maintenance is to delete all threads generate by NuTT. To delete the torrent itself you have to make sure you got the permissions to do so (Usergroup Permissions) and do it via the details page, in the bottom there should be an edit area.

And the comments don't work how exactly? The New Comment link is broken or... ?

When I click on the "new comment" link I am taken back to the main NuTT page instead. Also- I tried logging in to the tracker from a remote computer to test the download/connection, and when I click on the NUTT forum link I am taken to a login page, and when I enter the login details I am taken to an error page.

afusion 06-08-2005 06:45 PM

hmm by the sound of it, it seems another lil bit got missing in the instructions...

you need to manually create a forum for NuTT torrent threads and then specify the forum id in NuTT Settings

yoyoyoyo 06-08-2005 06:56 PM

Quote:

Originally Posted by afusion
hmm by the sound of it, it seems another lil bit got missing in the instructions...

you need to manually create a forum for NuTT torrent threads and then specify the forum id in NuTT Settings

I did that, and then put the link to the NUTT in the forum settings, so when people click on the forum link they will go to http://mysite.com/nutt As I said I am able to upload the torrent, etc. successfully, so the forum has been created. Now my members are telling me that they can download the bittorrent file, but it isn't connecting to the seeded file (and yes, I am seeding it with the new torrent as mentioned in the NUTT after you upload the file).

IS the TORRENT DIRECTORY supposed to have a trailing slash or not (in the NUTT settings). I see that it says to not add one to the NUTT URL, but not sure if the TORRENT DIRECTORY is supposed to have one. how about the NuTT's root directory?

afusion 06-08-2005 07:09 PM

None of the urls or dirs should have a trailing slash...

Now, just to avoid confusion download the attached testvars.php, upload it to /nutt, run it and send me the output.

yoyoyoyo 06-08-2005 07:12 PM

Quote:

Originally Posted by afusion
None of the urls or dirs should have a trailing slash...

Now, just to avoid confusion download the attached testvars.php, upload it to /nutt, run it and send me the output.

Okee Dokey.. will do.

yoyoyoyo 06-08-2005 07:48 PM

The problem with the forum commenting I had was that I had the forum set as a link instead of a forum, so people couldn't leave a comment... I changed it to a forum and all is well as far as that goes, but guests still are having a problem connecting to the seed... I am sure it is an end-user error (on my part) and we will get it straightened out

afusion 06-08-2005 08:12 PM

^ Although the connectability check should check if the user is blocked by a router/proxy, it might report things incorrectly if fsockopen() is disabled on the server or has limitations.

yoyoyoyo 06-08-2005 08:16 PM

I didn't upgrade to the new version yet, but it started working for some reason.. I will upgrade anyway and will let you know how it goes :D Thanks much! Awesome hack! Much requested and much needed! thanks again!

Outdoor 06-08-2005 08:46 PM

are all the files upgraded in the later versions or just the ones you state?

do you want the support questions over on your board?

afusion 06-08-2005 08:52 PM

All the files have are most up to date in the zip. The changes listed are the files I change in every release so for example compared to 0.70, 0.72 has details.php, functions.php and nutt_global.php changed.

where ever you feel more comfortable ^^

COBRAws 06-08-2005 09:31 PM

shake your boom, yeh, shake it! :D

thanx pal, i was really waiting for this one to be released. Thanks for keeping up your word on the old thread ;)

Selene 06-08-2005 11:21 PM

so how many have installed it? is it working well?

is it like VBTT that sqrtboy made or is it better?

nexialys 06-08-2005 11:55 PM

@selene... please don't talk about sqrtboy.. lol

it's completely different in the structure, the functions and the integration, and my opinion of the code is that it's better... but did not tested it intensively... need some tests in the next days with 100 or more torrents... (ok, i have a big group)

yoyoyoyo 06-08-2005 11:58 PM

Quote:

Originally Posted by Selene
so how many have installed it? is it working well?

is it like VBTT that sqrtboy made or is it better?

It seems to be leaner yet more robust and less awkward than VBTT, though it would be nice to have:

real time ul/dl speed on the tracker, on each torrent, and for each peer
display each user upload and download statistics in user panel
ratio tracking and user banning according to some ratio rules
stats retrieved from any user, with graphs associated
the ability to keep the original file name, rather than rename to a number (and this would help avoid any seeding confusion)

afusion 06-09-2005 05:47 AM

Quote:

Originally Posted by yoyoyoyo
1. real time ul/dl speed on the tracker, on each torrent, and for each peer
2. display each user upload and download statistics in user panel
3. ratio tracking and user banning according to some ratio rules
4. stats retrieved from any user, with graphs associated
5. the ability to keep the original file name, rather than rename to a number (and this would help avoid any seeding confusion)

1. I used to have something like that included but I removed it since most of time it was completely incorrect.
2. That's definitely coming up along with users download history
3. Well it already has a wait time system but I suppose I can add a lil cron job.
4. Isn't that basically the same as 2?
5. The browser can be tricked into thinking it's any filename you want though I think server-side they should be numbered. Otherwise it would add a query when downloading the .torrent. A rather nasty query looking at the fancy names people tend to use.

yoyoyoyo 06-09-2005 08:53 AM

I uploaded the new announce.php file, but it still won't let me connect to other users - it says that I am not connectable. I am able to connect using other torrent sites, as well as at afusion's site, so I don't think it is a firewall issue here. As I said I added the updated announce.php file, but it still doesn't seem to be connecting when I try to download files that others have posted on my site.

Also- I noticed that one person who was trying to seed a file is showing up as a peer, and not a seed, when I try to grab the file.

afusion 06-09-2005 09:37 AM

Btw, which client were you both using?

nexialys 06-09-2005 11:24 AM

...

me too, would prefer to have the .torrent file named as the archive itself, not with a number... like "torrentname[trackername].torrent" ...

i download from a lot of trackers, and having numbers is not really funny to have...

afusion 06-09-2005 11:30 AM

Well like I said, it can easily be made so that server-side the torrent is numbered but when downloaded, it's properly named. Anyways, gonna include that in the next update since I can't have an update over every little thing.

I'm btw looking into php scraping atm so external torrents might also be included in the next update.

yoyoyoyo 06-09-2005 11:34 AM

Quote:

Originally Posted by afusion
Btw, which client were you both using?

I was using bittornado, and he is using bittorrent 3.4.2

yoyoyoyo 06-09-2005 11:49 AM

I uploaded the new upload.php file, but there seems to be a new bug with this one:

when I click on the link to my forum on the upper left part of the NAVBAR it takes me to the root because the link supplied is: "http://www.mysite.com/?" when it should be "http://mysite.com/forum"

afusion 06-09-2005 12:09 PM

Ok now I don't know about your friend but bittornado is plain dag nasty evil. Banned from most trackers since it has no idea what "correct stats" even means.

Abou the navbar though, that isn't because of the new upload.php but try this functions.php

yoyoyoyo 06-09-2005 12:15 PM

Quote:

Originally Posted by afusion
Ok now I don't know about your friend but bittornado is plain dag nasty evil. Banned from most trackers since it has no idea what "correct stats" even means.

Abou the navbar though, that isn't because of the new upload.php but try this functions.php

OK- I will change clients (never had a problem with it before) and will give the new functions.php file a go

yoyoyoyo 06-09-2005 02:20 PM

as far as the layout goes it all is fine, except it would be nice to have the download link at the top of the torrent page, or more prominent so it is easier to find

arabuser 06-09-2005 03:12 PM

when I try to install the tracker it is taked long time to create the table & altering it so reinstall the tracker but i get error message sadi that tables & coulumns already in database , Also tried to use step=6 so I can uninstall the tracker but I did'nt see any uninstall button there so how I can uninstall the tracker to reinstall it correctly or is there anyway to complete the missing steps manually coz I still not able to see ( Nutt ) inside the admin panle & the main page of nutt give me this message

Fatal error: Cannot increment/decrement overloaded objects nor string offsets in /home/httpd/vhosts/httpdocs/nutt/index.php on line 49

afusion 06-09-2005 03:44 PM

Not sure about the error but you can uninstall via /forum/admincp/nutt_install.php?step=uninstall as stated in the description post.

yoyoyoyo 06-09-2005 04:58 PM

is there anyway to unblock the blocked ports? bittorrent is a popular client, but the hack FAQ says that certain ports are being blocked when people are attempting to connect to the tracker to seed. So far I have only had one successful download among all of the people who tried to connect, and they were able to connect at around 40 kbs - most of them are getting a login error when attempting to click on the torrent names, and other are getting no connection or 0 kbs

nexialys 06-09-2005 05:05 PM

SUGG: make a new setting about ports to keep opened, as many private trackers use some strange ports to share their files...

afusion 06-09-2005 06:02 PM

although it's for their own good to use alternate ports, will do so soon...

OT: woot, I'm in the coder club :D

now to more serious issues... here is the current planned list of things for future versions:
Quote:



  • External torrents
  • Torrent reuploading
  • Improved browsing (option persistency)
  • Detailed user stats (including torrent history)
  • AdminCP Category Editor
  • AJAX Torrent Editing

After I get these done, I probably won't work on NuTT atleast until autumn because I've long had a huge project for my board planned and just waiting for vB 3.5. Since it's out, I can start the project and it will definitely take months. So I'll add these features, make NuTT as bugfree as possible and stop for a good few months. And for anyone wondering what more besides that is there to do anyway: ALOT! There's always room for improvement and I've got some nice things planned for when ever I continue the work on it.
Man, this is a long post...

ushkand 06-09-2005 06:17 PM

How come after installing I don't see Nutt options in Forums AdminCP?

afusion 06-09-2005 06:26 PM

You mean under vBulletin Options?


All times are GMT. The time now is 12:55 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01393 seconds
  • Memory Usage 1,832KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete