vb.org Archive - vbFavorites

Page 2 of 7

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - vbFavorites (https://vborg.vbsupport.ru/showthread.php?t=81870)

T_Montana

05-22-2005 09:36 PM

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

Code:

---------------------------------------------------------------------------------------------------------------------------

FIND

---------------------------------------------------------------------------------------------------------------------------



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

this is the closest thing to it

Code:

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

akanevsky

05-22-2005 10:11 PM

What version do you have? of vB?

akanevsky

05-22-2005 10:36 PM

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

05-22-2005 11:10 PM

3.0.7

akanevsky

05-23-2005 12:04 AM

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	05-23-2005 04:38 AM

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

From 1.0.1 install text:

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'

);

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	05-23-2005 04:53 AM

ehh a comma missing :nervous:

The right code:

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

05-23-2005 05:55 AM

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

05-23-2005 08:01 AM

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

05-23-2005 09:07 AM

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

All times are GMT. The time now is 04:18 AM.

Page 2 of 7

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01872 seconds Memory Usage 1,732KB 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 (4)bbcode_code_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 (10)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
Messages: