Thread

/* @Function insert_update
 *
 * Global Function for a Database Entry
 * There  a distinction between new entry and update.
 * All entries are automatically qoutet.
 *
 * @param      table without Suffix
 * @param      Data as Array
 *
 */
function insert_update( $table = NULL , $set = NULL )
{

    if (empty($table) || !is_array($set) || !count($set))
    {
       return FALSE;
    }

    $this->db->protect_identifiers($table, TRUE);

    foreach ($set as $key => $value)
    {
        // $table . '_date' is always created date
        if( $key != $table . '_date' )
        {
            $update[] = $key." = ".$this->db->escape($value);
        }
    }
    $sql = $this->db->insert_string($table, $set)." ON DUPLICATE KEY UPDATE ".implode(', ', $update);

    return $this->db->simple_query($sql);
}