[SOLVED] making this bit vbulletin friendly php mysql

[Dr.CustUmz]

$query = $db->query_first( "select * from redirect where(url = '$drc_url')");
if ($query == false){
  $hits =  "1";
  $query2 =  $db->query_write( "INSERT INTO redirect (url,hits) VALUES('$drc_url','$hits')");
} else {
  $hitquery =  $db->query_first( "select hits from redirect where url = '$drc_url'");
  $result = mysql_query($hitquery);
  $hits = mysql_result($result, 0,  "hits");
  $query2 =  $db->query_write( "update redirect set hits = hits+1 where url = '$drc_url'");
}
$db->query($query2);

cant seem to get the else to function properly

Call to undefined function mysql_query()

i know the result and hits variable need updated im just not sure how
mysql_ is depricated, and changing them to mysqli just breaks it worse =/