}
// check cmail column to separate to URL and cemail
- mysql_query(
+ DB::execute(
'UPDATE ' . sql_table('comment') . ' ' .
"SET cemail = cmail, cmail = '' " .
"WHERE cmail LIKE '%@%'"
// check to see if user turn on Weblogs.com ping, if so, suggest to install the plugin
$query = "SELECT bsendping FROM " . sql_table('blog') . " WHERE bsendping='1'";
- $res = mysql_query($query);
- if (mysql_num_rows($res) > 0) {
+ $res = DB::getResult($query);
+ if ($res->rowCount() > 0) {
echo "<li>Note: The weblogs.com ping function is improved and moved into a plugin. To activate this function in v3.3, please go to plugin menu and install NP_Ping plugin. Also, NP_Ping is replacing NP_PingPong. If you have NP_PingPing installed, please also remove it.</li>";
}
}