How to remove links from a database field?

[Alfa1]

Originally Posted by Adrian Schneider

If you want, try it again, and set $showlinks to false (4th argument to strip_bbcode). That should do the trick.

Where? Im not seeing showlinks. I used this:

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'])),
        'linkslink',
        "WHERE linkid = $link[linkid]"
    ));
}  

die('Done');

[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');

[Alfa1]

Übercool! Will try that.

[Adrian Schneider]

Let me know how it goes.