vbFavorites

/*================================================= =====================*\
|| vbFavorites
|| Author : Psionic Vision
|| Works on : vBulletin 3.0.7
\*================================================ ======================*/

Did you ever find a useful thread on a bb? Did you want to save it for reading later? Did you have to choosing between subscribing to the thread and clogging your mailbox or adding it to your browser favorites and never finding it afterwards?
The problem has been solved!

With this hack, you can create your own personalized favorites menu within the bulletin board itself. You can add both posts and threads to the favorites. You can access the favorites from your usercp homepage. You can also specify a custom name for your favorites entry. It will also display latest 5 threads and posts in the nabar... See screenshots for more.

If you like it, do not forget to click INSTALL

The hack is free, however if you like that hack, feel free to DONATE (paypal it using my email which is written on top of this post)

[T_Montana]

Can't find this in my function-databuild file......

---------------------------------------------------------------------------------------------------------------------------
FIND
---------------------------------------------------------------------------------------------------------------------------

			$DB_site->query("DELETE FROM " . TABLE_PREFIX . "deletionlog WHERE type = 'post' AND primaryid IN ($postids" . "0)");

this is the closest thing to it

$DB_site->query("DELETE FROM " . TABLE_PREFIX . "deletionlog WHERE primaryid = $postid AND type = 'post'");

[akanevsky]

What version do you have? of vB?

[akanevsky]

UPDATE: v1.01

By T Montana's request, this hack now also includes last 5 threads and posts in the navbar. Screenshot includes. Upgrade instructions also includes.

[T_Montana]

3.0.7

[akanevsky]

In my 3.0.7, there is such a line. Try one of there (you can add the line after any of these):

$DB_site->query("DELETE FROM " . TABLE_PREFIX . "editlog WHERE postid IN ($postids" . "0)");
$DB_site->query("DELETE FROM " . TABLE_PREFIX . "moderation WHERE postid IN ($postids" . "0)");
$DB_site->query("DELETE FROM " . TABLE_PREFIX . "reputation WHERE postid IN ($postids" . "0)");
$DB_site->query("DELETE FROM " . TABLE_PREFIX . "post_parsed WHERE postid IN ($postids" . "0)");
$DB_site->query("DELETE FROM " . TABLE_PREFIX . "post WHERE postid IN ($postids" . "0)");

[goyo]

Great hack...although there's a problem:

From 1.0.1 install text:

CREATE TABLE `favorites` (
`entry_id` INT( 10 ) UNSIGNED NOT NULL ,
`entry_type` VARCHAR( 10 ) NOT NULL ,
`entry_title` VARCHAR( 255 ) NOT NULL ,
`userid` INT( 10 ) UNSIGNED NOT NULL 
`dateline` int(100) unsigned NOT NULL default '0'
);

I'm receiving this error after running on mysql:
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'dateline` int(100) unsigned NOT NULL default '0'
)' at line 6

[goyo]

ehh a comma missing :nervous:

The right code:

CREATE TABLE `favorites` (
`entry_id` INT( 10 ) UNSIGNED NOT NULL ,
`entry_type` VARCHAR( 10 ) NOT NULL ,
`entry_title` VARCHAR( 255 ) NOT NULL ,
`userid` INT( 10 ) UNSIGNED NOT NULL ,
`dateline` INT(100) unsigned NOT NULL default '0'
);

[Cap'n Steve]

Cool idea, I'm surprised this hasn't been done before.

You should always use TABLE_PREFIX though. You never know how people's databases are set up and they might rely on the prefix.

[Lionel]

Suggestions: When you click on "Complete List of Favorites" link in navbar, if there are none, can we say it, instead of looking at a page and wondering what that is supposed to be?

never mind, I forgot to put the conditionals

[artonex]

overgrow.com is ran on vb2 and they have a hack like this.