function sql($query, $debug = 0){
    global $LASTINSERTID;
    if (LOCAL) {
        $dbserver = 'localhost';
        $dbuser = 'root';
        $dbname = 'administration';
        $dbpassword = '';
    } else {
        $dbserver = 'xxx';
        $dbuser = 'xxx';
        $dbname = 'xxx';
        $dbpassword = 'xxx';
    }

    if ($debug) {
        echo '<pre class="debug" style="font: normal normal 10pt \'Courier New\'">';
        echo $query;
        echo '</pre>';
    }

    $connect = mysql_connect($dbserver, $dbuser, $dbpassword);
    mysql_select_db($dbname, $connect);
    mysql_query('SET NAMES \'utf-8\'');
    mysql_query('SET character_set_client=utf8');
    mysql_query('SET character_set_connection=utf8');
    mysql_query('SET character_set_results=utf8');
    $res = mysql_query($query);
    if(mysql_errno()) die(mysql_errno() .' : '. mysql_error());
    if(mysql_insert_id()){
        $LASTINSERTID = mysql_insert_id();
    }

    mysql_close($connect);
    return $res;
}