The Arcive of Official vBulletin Modifications Site.

vBRecycle v3.0.7 · **Released**: 07-10-2005

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-= vBRecycle
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-= Version : 3.0.7
=-=-=-=-=-=-=
=-=-=-=-=-=-=
-= For vBulletin: 3.5.x=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

::::::::::::::::::::::::::::::::::::::::
::::FEATURES
::::::::::::::::::::::::::::::::::::::::

Easily install & uninstall with Product Installer. *NEW
Main Settings
- Quick active or disable recycle.*NEW
- Select default recycle.
- Auto convert normal forum => recycle forum.*NEW
- Set type move(Copy thread to destination forum, Move and leave redirect in previous forum and Move to destination forum)
Recycle Manager*NEW
- Easily edit settings.*NEW
- Delete forum recycle.*NEW
- Unlimited recycle.*NEW
- Set default recycle.*NEW
- Select recycle for special forum.*NEW
Empty Recycle Bin.
Link After Moved.
- Options in showtheard, inline mod. *NEW
Quick Create Recycle*NEW
Scheduled Tasks Recycle*NEW
- Auto empty recycle*NEW
Set permissions for each usergroup.*NEW
Add "vBRecycle Options" in "Add New Forum" & "Edit Forum" *NEW

::::::::::::::::::::::::::::::::::::::::
::::INSTALL
::::::::::::::::::::::::::::::::::::::::

==================================
[Step 1][Upload Files]
==================================
Copy all files to their respective location:
admincp/vbrecycle_admin.php

images/misc/vbrecycle_lock.gif

images/misc/vbrecycle_default.gif

images/misc/vbrecycle_scheduledtask.gif

images/misc/vbrecycle_edit.gif

images/misc/vbrecycle_empty.gif

includes/adminfunctions_vbrecycle.php

includes/cron/vbrecycle_clean.php

includes/xml/bitfield_vbrecycle.xml

includes/xml/cpnav_vbrecycle.xml

==================================
[Step 2][Run the Product Installer]
==================================
URL: http://www.yoursite.com/admincp/plugin.php?do=productadd
Select product-vbrecycle***.xml.

=======================

==================================
[Installation Completed]
==================================

::::::::::::::::::::::::::::::::::::::::
::::HISTORY
::::::::::::::::::::::::::::::::::::::::

Version 1.0.0
- Initial release.
  - Version 1.0.1
    - Fixed: Hook Location.
Version 1.5.0
- Updated check permissions.
- Updated check password.
- Change $_POST['method'] => $vbulletin->GPC['method']
Version 2.0.0
- Optimize $_REQUEST['do'] = 'domovethread';
- Added vBR for vBulletin 3.5.0 Beta 4.
- Optimize Type Move
- Add funtion "Link after moved"
- Fixed error SQL
- Optimize Phrases Redirect
  - Version 2.0.1
    - Fixed phrase "move_recycle"

Version 2.5.0
- Fixed phrase redirect.
- Added vBR for vBulletin 3.5.0 RC 1
- Auto Installation: added file vbrecycle_install.php
- Easy Modify Settings: added file vbrecycle_config.php
- New Add-on: Empty Recycle Bin
- Integrate into Inline Mod.
  - Version 2.5.1
    - Fixed dont' show vBRecycle in AdminCP : added file cpnav_vbrecycle.xml
    - Some update for add-on "Empty Recycle Bin"
  - Version 2.5.2
    - Fixed some errors for vB 3.5.0 RC 2
Version 3.0.0
- Updated: Auto Install with Product Installer
- Updated: Active or Disable vBRecycle
- Updated: "Recycle Manager".
- Updated: Options for "Link After Moved"
- Updated: "Quick Create Recycle"
- Updated: "Scheduled Tasks Recycle"
- Updated: Set permissions for each usergroup.
- Updated: Set forum recycle from "Forum Manager"
- Integrated: for all vBulletin 3.5.x - added file adminfunctions_vbrecycle.php
- Optimized: Auto edit templates.
  - Version 3.0.1
    - Fixed: SQL Query
    - Fixed: XML Product Info.
  - Version 3.0.2
    - Fixed: Invalid Fields.
  - Version 3.0.3
    - Fixed: Upgrade Version
    - Fixed: Invalid Recycle ID in vBRTools
    - Fixed: Error Phares
  - Version 3.0.4
    - Fixed: Usergroup Permissions
    - Fixed: Forum Admin
    - Fixed: SQL Query
    - Fixed: Error Code
  - Version 3.0.5
    - Fixed: Install Code & Uninstall Code
  - Version 3.0.6
    - Fixed: Quick Create Recycle
    - Fixed: Add New Forum
    - Fixed: Inline Mod
    - Optimized: Source Code
  - Version 3.0.7
    - Fixed: Mark Forums Read

::::::::::::::::::::::::::::::::::::::::
::::HAVE FUN! Don't forget click Install! ^_^
::::::::::::::::::::::::::::::::::::::::

mtha · #**132** 10-06-2005, 10:50 PM

Quote:

Originally Posted by LNTT

i will release vbrecycle in version 3.0.4 (3.0.3 have some errors for vb3.5.0 Gold)

You should SAY it in your hack (first post) if you still have 3.0.3 there (that those who use 3.5.0 should NOT install until 3.0.4). otherwise, people will keep getting bad impressions of a ... buggie hack!

FROGGYJ · #**133** 10-06-2005, 11:11 PM

hrm I'm having the same problem, this install never created tables. So I tried running the above code and I get "Parse error: parse error, unexpected T_STRING".....help? Great idea, but doesn't work at the moment with 3.5

Blackbeard · #**134** 10-07-2005, 06:29 PM

Quote:

Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE forum SET
title_clean = 'Trash Can',
title = 'Trash Can',
description_clean = 'All Old and Broken posts will be transfered here.',
description = 'All Old and Broken posts will be transfered here.',
link = '',
displayorder = 1,
daysprune = -1,
parentid = 62,
newpostemail = '',
newthreademail = '',
### Bitfield: forum.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 16, options - 16, options),
options = IF(options & 32, options - 32, options),
options = IF(options & 131072, options - 131072, options),
options = IF(options & 32768, options - 32768, options),
options = IF(options & 8192, options - 8192, options),
options = IF(options & 4, options, options + 4),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 16384, options, options + 16384),
options = IF(options & 256, options - 256, options),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options, options + 128),
options = IF(options & 512, options, options + 512),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options, options + 4096),
options = IF(options & 65536, options, options + 65536),
styleid = 0,
password = '',
gallery = '0',
gallery_rows = '',
recycle = 0
WHERE forumid = 63;

MySQL Error : Unknown column 'recycle' in 'field list'
Error Number : 1054

I got this error when changing the settings in forums & mods for my trash can forum where i want all posts to be sent, tried in in all settings.

What could the problem be, and which of the 2 settings must be set for a forum u already have.

Xtremist · #**135** 10-08-2005, 07:07 PM

i did all the instructions but i try and open the Recycle bin Main Settings, Recycle Manager, Link After Moved and i get this error SQL i think

Code:

Database error in vBulletin 3.5.0:

Invalid SQL:
select * from vbr_config;

MySQL Error  : Table 'ross_Vbu.vbr_config' doesn't exist
Error Number : 1146
Date         : Saturday, October 8th 2005 @ 09:07:15 PM
Script       : http://interwebgaming.com/admincp/vbrecycle_admin.php?do=manager
Referrer     : http://interwebgaming.com/admincp/index.php
IP Address   : 86.132.118.60
Username     : Xtremist
Classname    : vb_database

danb00 · #**136** 10-08-2005, 07:20 PM

Manual fix
After running the install run these SQL commnads using build in SQL command

PHP Code:


			
CREATE TABLE vbr_config (oid int(11) NOT NULL default 1, active int(11) NOT NULL default 1, forumid int(11) NOT NULL default 0, linkamfd int(11) NOT NULL default 2, linkamst int(11) NOT NULL default 1, typem int(11) NOT NULL default 1) ENGINE=MyISAM COMMENT='vBRecycle Config';



INSERT INTO vbr_config VALUES(1, 1, '', 2, 1, 1);



ALTER TABLE usergroup ADD vbr_per INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;



ALTER TABLE forum ADD recycle INT NOT NULL;



ALTER TABLE forum ADD srecycle INT NOT NULL;

untold4you · #**137** 10-09-2005, 10:09 PM

This is the error i'm getting after i followed all your install steps, i get this error when i want to change settings in the ACP.

I checked and indeed the table is not made? Something wrong in the install file? Any suggestions? Tnx in advance!

Code:

  Database error in vBulletin 3.5.0:
  
  Invalid SQL:
  select * from vbr_config;
  
  MySQL Error  : Table 'vbull.vbr_config' doesn't exist
  Error Number : 1146
  Date		 : Monday, October 10th 2005 @ 01:03:31 AM
  Script	   : http://www.****/****/****/vbrecycle_admin.php?
  Referrer	 : http://www.*****/****/****/index.php?do=nav
  IP Address   : ******
  Username	 : *******
  Classname	: vb_database

Update: Sorry did not look at previous post, anyway created the table manually in phpMyAdmin and changed the install xml:

Quote:

Originally Posted by mtha

use this for install code:

PHP Code:


			
$db->query_write("INSERT INTO " . TABLE_PREFIX . "vbr_config VALUES(1, 1, '', 2, 1, 1);");
 $db->query_write("ALTER TABLE " . TABLE_PREFIX . "usergroup ADD vbr_per INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;");
 $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD recycle INT NOT NULL ;");
 $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD srecycle INT NOT NULL ;");

and do the same for uninstall

#**138** 10-09-2005, 11:37 PM

Hey LNTT, i think you can minimize a lot of the plugins so we can spare some space in our dB...

these:

Code:

/////////////////////////////////////
//      ::vBRecycle v3            //
///////////////////////////////////
// by LNTT(toai007@yahoo.com)   //
/////////////////////////////////
// http://www.fanfunvn.com    //
///////////////////////////////
// Start - IM - Fix Invalid //
/////////////////////////////

... completely useless, because they are never displayed anywhere... they are stored in the dB, in the plugin system, and only the scripts "see" them, so maybe in the next release you can save us these 6k (about 200 lines)

... i know you want your credits, but the system doesn't care... and we know you've done a great job... !!!

oh, btw, i have an alternative for the menu... instead of the bar you've created, i added an element in the tools bar... screenshot included... if you want it, i can send the modification next...

FROGGYJ · #**139** 10-09-2005, 11:59 PM

umm I think this is related to this mod so here goes.No matter what I try to change in any usergroup...whether default or a custom I get the following error.

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 635

MySQL Error : Unknown column 'vbr_per' in 'field list'
Error Number : 1054

FROGGYJ · #**140** 10-10-2005, 12:32 AM

ok I don't think any SQL actions in the script actually ran....I tried to run the xml file again with overwrite and still nothing....Ok I look in the product manager and copied what SQL was supposed to be performed...and tried to execute it, however I get an error Parse error: parse error, unexpected T_STRING on this line

Code:

$sql[] = "$run = "CREATE TABLE " . TABLE_PREFIX . "vbr_config (oid int(11) NOT NULL default 1, active int(11) NOT NULL default 1, forumid int(11) NOT NULL default 0, linkamfd int(11) NOT NULL default 2, linkamst int(11) NOT NULL default 1, typem int(11) NOT NULL default 1) ENGINE=MyISAM COMMENT='vBRecycle Config'";

but I'm not proficient in SQL and I'm not sure where the syntax error is?

FROGGYJ · #**141** 10-10-2005, 12:44 AM

ok well I went ahead and manually created the sql staments thought PhpMyAdmin however I am still having a problem. Here is a screenshot when I click on update usergroup. Although it says it saved...when I go back they are unchanged.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05217 seconds Memory Usage 2,337KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (4)bbcode_code (2)bbcode_php (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!