Back to Modification Graveyard

vBH-Bot's ~ Your site a better effective at search engine
Mod Version: 2.00, by BuRaCh

This thread is in the Modification Graveyard.
vB Version: 3.6.8 Rating: (2 votes - 3.00 average) Installs: 9
Released: 30 Jul 2007 Last Update: Never Downloads: 82
Not Supported Uses Plugins Additional Files  

Staff notice: This script version 2.0 is using an invalid product-id. Result of this is that you might not be able to uninstall or disable the modfication. We strongly recommend against installing this script until the author provided a fixed version.

For those who alreadey have installed this and can not remove it, see post

Spoiler (click to open)


Those that have this modification installed (version 2.0) might have problems to uninstall or disable the product.

This is caused by the use of an invalid product-id:
- Current product-id is "vBH-Bot's"
- No product should ever use a product-id that starts with "vb" as this is reserved to official Jelsoft products.
- The product-id should be lowercase and only alphanumeric characters and underscore. Using a single-quote (') in the productid will break some javascript that is needed when uninstalling/disabling the product.

We strongly suggest not to install this product until the author releases an updated version.

For those who already have installed this product and need to disable or remove it, the attached script should correct the product-id by changing it from "vBH-Bot's" to "burach_bot_070731". This should allow for normal uninstall.

Please note that running the attached script might break the functioning of this modification, so only use the attached script if you plan on uninstalling the modification.

Place the following script in your 'admincp' directory and point your browser to http://myboard.com/admincp/fix_quoted_prodid.php

The script will not ask for a confirmation and will immediate make the needed changes. Once completed please remove the script again.

PS:
- This script has been undergoing a limited test. Use at own risk!
- If you have 2 boards installed in a single database, 1 without table-prefix and 1 with a table-prefix, then running this script for the board without a table-prefix might result in also the tables for the prefixed board to be updated (if this modification was also installed there)

As this modification has now been withdrawn by the author, the attachment is not downloadable anymore. If you still need this solution, please copy and paste the script below into a file named fix_quoted_prodid.php and place this file in your admincp directory.
PHP Code:
<?php
// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### settings for this script ######################
// The product-id to search for
$prod_find "vBH-Bot's";
// The product-id to use as replacement
$prod_replace "burach_bot_070731";
// #################### PRE-CACHE TEMPLATES AND DATA ######################
$phrasegroups = array();
$specialtemplates = array();
// ########################## REQUIRE BACK-END ############################
require_once('./global.php');
// loop thru all table names
$tables $db->query_read("SHOW TABLES LIKE '" TABLE_PREFIX "%'");
while (
$tablename $db->fetch_array($tablesDBARRAY_NUM))
{
 
// Check for columnname 'productid'
 
$tbl_columns $db->query_read("SHOW COLUMNS FROM $tablename[0] LIKE 'productid'");
 if (
$db->num_rows($tbl_columns) > 0)
 {
  
replace_productid($tablename[0], 'productid');
 }
 
 
// Check for columnname 'product'
 
$tbl_columns $db->query_read("SHOW COLUMNS FROM $tablename[0] LIKE 'product'");
 if (
$db->num_rows($tbl_columns) > 0)
 {
  
replace_productid($tablename[0], 'product');
 }
}
function 
replace_productid($tablename$column)
{
 global 
$db$prod_replace$prod_find;
 
 echo 
"<br />Updating table: " $tablename;
 
 
$result $db->query_write("UPDATE $tablename SET $column = '" $db->escape_string($prod_replace) . "' WHERE $column = '" $db->escape_string($prod_find) . "'");
 
 echo 
"<br />Updated " $db->affected_rows() . " row(s).";
 
}
?>
Attached Files
File Type: php fix_quoted_prodid.php (1.5 KB, 9 views)

Close
for a solution.


End Staff Notice

The hack powered by BuRaCH
i'am use myself website.
http://www.vB-Hacker.com


Hack name
vBH-Bot's

Hack description
Your site a better effective at search engine..
(Advanced Robots.txt )
(Works also on 3.6......)


Hack Target
Your Website Top turn arise at search engine's => Google,yahoo,msn ....

Hack options
admincp -->vbulletin options ---> vBH-Bot's here..

Hack info
File uploads: 1
Template edits: 0
File edits: 0
Plugins: 1
SQL Queries: 12
Phrases: 0
Settings: 4

Install time: 9 secs
Install level: Easy

Hack installation
Step 1:import the xml at in the Additional ..

If you enjoy my mod and want to be kept up to date >>> "Click install"

Download

This modification cannot be downloaded.

Screenshots

   

Similar Mods

Forum Home Enhancements Add QnQ.Me Mp3 Search Engine to your site Modification Graveyard

vblts.ru supports vBulletin®, 2022-2024