DB functions

Important change: return value 0 means that nothing was changed. It is not an error. With update() it returns the number of changed records, with insert() inserted ID.

Original function	Replacement
dbquery("UPDATE...")	e107::getDb()->gen("UPDATE...")
dbquery("INSERT INTO...")	e107::getDb()->gen("INSERT INTO...")
dbquery("SELECT... + LIMIT 1) (*)	e107::getDb()->retrieve("SELECT ... LIMIT 1)

(*) Example :

$pagequery = dbquery("SELECT... + LIMIT 1); 
$result = dbassoc($pagequery);
$field = $result['field'];

Replace with:

$result = e107::getDb()->retrieve("SELECT... + LIMIT 1); 
$field = $result['field'];