Thread Torrent

Description

After discussion with the Serence development team and several members of this community including cloudrunner would wrote KlipFolio Integration, I have decided to release Thread Torrent for Serence KlipFolio and vBulletin, moreover This hack was essentially requested by Koutaru here to provide a way to display newest threads. KlipFolio is a desktop application that allows you to easily view and manage live, automated and customizable channels to unique information sources called Klips. A Klip is a live, automated and customizable channel to a unique information source that runs in KlipFolio. For more information you can reference the KlipScript Guide for documentation (Also see Klip Tags). The basics are essentially self explanatory; let me know if you have any more questions concerning this topic.



Installation Information

Files to edit: (2) vbTT.php, vbTT.klip
Files to upload: (2) vbTT.php, vbTT.klip
Queries to Run: (0) nada
Templates to edit: (1) nada
Templates to add: (0) nada
Time to install: approx 3 minutes

[Kriek]

I'm so embarrassed :nervous:

Please change forumid to thread.forumid

[alesis404]

Kinda confused, isnt that what I already have?

PHP Code:

$dosql .= 'SELECT threadid,title,lastpost,replycount,postusername,thread.forumid'; 
    $dosql .= ' FROM thread LEFT JOIN forumpermission USING(forumid) WHERE visible=1'; 
    $dosql .= ' AND forumid NOT REGEXP ' . $privateforum; 
    $dosql .= ' AND forumpermission.forumid IS NULL ORDER BY lastpost DESC LIMIT ' . $showthreadnumber; 


My first code change looks like this

PHP Code:

 // Settings
  $reply = 'Replies'; 
  $description = 'Active Threads'; 
  $privateforum = '9'; 
  $showthreadnumber = '10'; 


**No need to be embarassed Kriek ,I'm embarassed having to ask so many questions but *love* this script

[Kriek]

Alesis, find this line

PHP Code:

$dosql .= ' AND forumid NOT REGEXP ' . $privateforum; 


Replace with the following

PHP Code:

$dosql .= ' AND thread.forumid NOT REGEXP ' . $privateforum; 


[alesis404]

Rock and roll Kriek, tested and working 100% with the NNTP News Gateway hack https://vborg.vbsupport.ru/showthrea...threadid=35247

**Thanks again for all your help resolving theses small problems

[Kriek]

Alesis, glad it works for you

[alesis404]

Just wondering Kriek, if a person would like to make multiple forums not show on the klipfolio would he just do something maybe like this?

PHP Code:

// Settings
$reply = 'Replies'; 
$description = 'Active Threads'; 
$privateforum = '9';
$privateforum = '2'; 
$privateforum = '6'; 
$privateforum = '4'; 
$showthreadnumber = '10'; 


[Kriek]

Alesis, perhaps the most expedient and practicable way.

PHP Code:

$privateforum = '9 OR 2 OR 6 OR 4 OR 10'; 


However if your forumid's run in numerical order with no exceptions (0, 1, 2, 3, 4, 5)

PHP Code:

$privateforum = '"[0-5]"'; 


[alesis404]

Kriek it appeared I had this working last night with banning more than one forum but when I try with different forum ID's it seems to not work and only a single forumid=x will work

**Here is what I am trying now and it appears to let all the posts through to the klipfolio, I really have no clue what might cause this and thought you might know...all the forumids are located in my main forum and are not in any sub forums etc, these are all the correct forumid's that I wanna block.

Here is my edited code maybe you can spot the problem, thank you

........

[Kriek]

My regular expressions are rusty, however

PHP Code:

$privateforum = '"([3]|[16]|[17])"'; 


Subsequently if that does not work, attempt this

PHP Code:

$privateforum = '"((3)|(16)|(17))"'; 


[alesis404]

I havent tried the second one yet Kriek but the first appears to work!!

PHP Code:

$privateforum = '"([3]|[16]|[17])"'; 


Thanks again, I tried few times downloading more posts from news servers and this time it didnt fill my klipfolio