{

echo "Checking $content_field on $table_name\n";

$ids = get_table_flash_bbcode_pkids($table_name, $id_field, $content_field, $uid_field, $bitfield_field);

$size = count($ids);

if ($size)

{

echo "Found $size potentially dangerous flash bbcodes.\n";

echo "$id_field: " . implode(', ', $ids) . "\n";

}

else

{

echo "No potentially dangerous flash bbcodes found.\n";

}

echo "\n";

{

global $db;

$ids = array();

$sql = "SELECT $id_field, $content_field, $uid_field, $bitfield_field

AND $bitfield_field <> ''";

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result))

{

$uid = $row[$uid_field];

// thanks support toolkit

$content = html_entity_decode_utf8($row[$content_field]);

set_var($content, $content, 'string', true);

$content = utf8_normalize_nfc($content);

$bitfield_data = $row[$bitfield_field];

if (!is_valid_flash_bbcode($content, $uid) && has_flash_enabled($bitfield_data))

{

$ids[] = (int) $row[$id_field];

}

}

$db->sql_freeresult($result);

return $ids;

{

$regex = get_flash_regex($uid);

$url_regex = get_preg_expression('url');

$www_url_regex = get_preg_expression('www_url');

if (preg_match_all($regex, $cleaned_content, $matches))

{

foreach ($matches[3] as $flash_url)

{

if (!preg_match("#^($url_regex|$www_url_regex)$#i", $flash_url))

{

return false;

}

}

}

return true;

{

$bitfield = new bitfield($bitfield_data);

return $bitfield->get(11);

{

static $trans_tbl;

// replace numeric entities

$string = preg_replace_callback('~&#x([0-9a-f]+);~i', function ($match) {

return code2utf8(hexdec($match[1]));

}, $string);

$string = preg_replace_callback('~&#([0-9]+);~', function ($match) {

return code2utf8($match[1]);

}, $string);

// replace literal entities

if (!isset($trans_tbl))

{

$trans_tbl = array();

foreach (get_html_translation_table(HTML_ENTITIES) as $val=>$key)

$trans_tbl[$key] = utf8_encode($val);

}

return strtr($string, $trans_tbl);

{

if ($num < 128) return chr($num);

if ($num < 2048) return chr(($num >> 6) + 192) . chr(($num & 63) + 128);

if ($num < 65536) return chr(($num >> 12) + 224) . chr((($num >> 6) & 63) + 128) . chr(($num & 63) + 128);

if ($num < 2097152) return chr(($num >> 18) + 240) . chr((($num >> 12) & 63) + 128) . chr((($num >> 6) & 63) + 128) . chr(($num & 63) + 128);

return '';