It is also beta version
1.Please create file and save it as "decode.php"
2.Put the code below into it and save it
3.Upload to your server, forum root
4.Do the backup of your database
5.Turn off your forum
6.Log in as admin
7.In your browser, put url with destination to your "clearBB.php"
8.Press "clear" button
<?php echo "<input type=\"hidden\" name=\"securitytoken\" value=\"" . $vbulletin->userinfo['securitytoken'] . "\" />\n";?>
<p style="text-align: center">
Use this program to change asci html code into "normal" signs
</br>This script has big influence on your
database and changes are permanent - <b>can not be undone</b> therefore:
</br>
make sure you did the <b>backup of your database!</b> and remember to <b>turn
off your forum</b> during using this script!</p>
<form action="decode.php?do=execute" method="post"><input type="submit"
value="clear" style="width: 70%; margin-left: 15%" /></form>
<?php
function update_pagetext(&$new_message, $message_id) {
global $vbulletin;
$vbulletin->db->query_write("
UPDATE " . TABLE_PREFIX . "post
SET pagetext = '".addslashes($new_message)."'
WHERE postid = " .$message_id
);
}
function update_tittle(&$new_tittle, $tittle_id) {
global $vbulletin;
$vbulletin->db->query_write("
UPDATE " . TABLE_PREFIX . "post
SET title = '".addslashes($new_tittle)."'
WHERE postid = " .$tittle_id
);
$vbulletin->db->query_write("
UPDATE " . TABLE_PREFIX . "thread
SET title = '".addslashes($new_tittle)."'
WHERE firstpostid = " .$tittle_id
);
}
require_once('./global.php');
if ($_REQUEST['do'] == 'execute') {
$to_remove = array(">", "<", "&", "'", """);
$result = $vbulletin->db->query_read("SELECT * FROM ".TABLE_PREFIX."post WHERE pagetext LIKE '%>%' OR pagetext like '%<%' OR pagetext like '%&%' OR pagetext like '%'%' OR pagetext like '%"%' OR title LIKE '%&%' OR title LIKE '%'%' OR title LIKE '%<%' OR title LIKE '%>%' OR title LIKE '%"%' " );
while ($message = $db->fetch_array($result)){
$new_message = $message['pagetext'];
if ((strpos($message['pagetext'], '>')) !== FALSE){
$new_message = str_replace('>','>',$new_message);
}
if ((strpos($message['pagetext'], '<')) !== FALSE){
$new_message = str_replace('<','<',$new_message);
}
if ((strpos($message['pagetext'], '&')) !== FALSE){
$new_message = str_replace('&','&',$new_message);
}
if ((strpos($message['pagetext'], ''')) !== FALSE){
$new_message = str_replace(''',"'",$new_message);
}
if ((strpos($message['pagetext'], '"')) !== FALSE){
$new_message = str_replace('"','"',$new_message);
}
update_pagetext($new_message,$message['postid']);
$new_title = $message['title'];
if ((strpos($message['title'], '>')) !== FALSE){
$new_title = str_replace('>','>',$new_title);
}
if ((strpos($message['title'], '<')) !== FALSE){
$new_title = str_replace('<','<',$new_title);
}
if ((strpos($message['title'], '&')) !== FALSE){
$new_title = str_replace('&','&',$new_title);
}
if ((strpos($message['title'], ''')) !== FALSE){
$new_title = str_replace(''',"'",$new_title);
}
if ((strpos($message['title'], '"')) !== FALSE){
$new_title = str_replace('"','"',$new_title);
}
update_tittle($new_title, $message['postid']);
}
}
?>
