e.g:
$xoopsDB->query("UPDATE ".$xoopsDB->prefix("users_gal")." SET visit_count = visit_count + 1, visit_lastip='".$_SERVER['REMOTE_ADDR']."' WHERE pid=$pid");
There is no update after executing the file. Using MySQL directly
mysql_query("UPDATE ".$xoopsDB->prefix("users_gal")." SET visit_count = visit_count + 1, visit_lastip='".$_SERVER['REMOTE_ADDR']."' WHERE pid=$pid");
it works. So why??