We had an issue as to where characters were not being displayed correctly within posts/threads. In order to resolve there is a one time queries that needs to be triggered to replace those characters and then we found a conflict with VaultWiki BBCode parse plugin area that was debugged and fixed as well.
SQL queries:
UPDATE `post` SET `pagetext` = REPLACE(`pagetext` ,'–','–');
UPDATE `post` SET `pagetext` = REPLACE(`pagetext`,'’','\'');
UPDATE `post` SET `pagetext` = REPLACE(`pagetext`,'…','...');
UPDATE `post` SET `pagetext` = REPLACE(`pagetext`,'–','-');
UPDATE `post` SET `pagetext` = REPLACE(`pagetext`,'“','"');
UPDATE `post` SET `pagetext` = REPLACE(`pagetext`,'â€','"');
UPDATE `post` SET `pagetext` = REPLACE(`pagetext`,'‘','\'');
UPDATE `post` SET `pagetext` = REPLACE(`pagetext`,'•','-');
UPDATE `post` SET `pagetext` = REPLACE(`pagetext`,'‡','c');
VaultWiki Conflict correction:
The hook is bbcode_parse_start had this code
it has check for null of $this->instance and this is never null because it is set in the hook itself and so ideally the new code will be what we have here
PHP Code:
if (!class_exists('vB'))
{
require_once(DIR . '/packages/vw/core.php');
}
if (VW_Core::init())
{
if (!isset($this->instance))
{
$this->instance = vw_Hard_Core::model('Parser')->create($this);
}
}
if ($forumid == 'vw')
{
if (isset($this->instance) AND $this->instance->get_class() == 'wysiwyg')
{
vw_Hard_Core::model('Plugins/BBCode/WYSIWYG')->bbcode_parse_start($this, $forumid);
}
$dobbcode = $this->options['do_bbcode'];
$dosmilies = $this->options['do_smilies'];
$dobbimagecode = $this->options['do_imgcode'];
$dobbvideocode = $this->options['do_videocode'];
$dohtml = $this->options['do_html'];
$tmp = vw_Hard_Core::model('Plugins/BBCode')->bbcode_parse_start($this, $text, $parsedtext, $forumid, $dobbcode, $dosmilies, $htmlstate == 'off' ? false : $dohtml);
if ($parsedtext)
{
$parsedtext = $tmp;
}
else
{
$text = $tmp;
}
}