How to remove links from a database field?

[Adrian Schneider]

Sorry it's from the strip_bbcode() documentation above.

You want

PHP Code:

<?php

error_reporting(E_ALL ^ E_NOTICE ^ 8192);

require('./global.php');

$result = $vbulletin->db->query_write("
    SELECT linkid
         , linkdesc
      FROM " . TABLE_PREFIX . "linkslink
");

while ($link = $vbulletin->db->fetch_array($result)) {    
    $vbulletin->db->query_write(fetch_query_sql(
        array('linkdesc' => strip_bbcode($link['linkdesc'], false, false, false)), // third false disables links as (URL)
        'linkslink',
        "WHERE linkid = $link[linkid]"
    ));
}  

die('Done');