PHP report_sql_error函数代码示例

function fun_images_create($image)
{
    $query = 'INSERT INTO fun_images (timestamp, handle, title, description, category)';
    $query .= ' VALUES("' . time() . '", "' . $image['handle'] . '", "' . $image['title'] . '", "' . $image['description'] . '", "' . $image['category'] . '")';
    mysql_query($query) or report_sql_error($query);
    echo 'Running query: ' . $query;
}

function rss_create_items($param)
{
    $query = 'SELECT l.username AS sender_name, gb.message, gb.timestamp AS sent, gb.id
FROM traffa_guestbooks AS gb, login AS l
WHERE gb.recipient = ' . $param['uid'] . ' AND gb.is_private = 0 AND gb.deleted = 0 AND l.id = gb.sender AND gb.sender != 2348
ORDER BY gb.timestamp DESC
LIMIT ' . $param['limit'];
    $res = mysql_query($query) or report_sql_error($query, __FILE__, __LINE__);
    if (mysql_num_rows($res) > 0) {
        while ($data = mysql_fetch_assoc($res)) {
            $data['sent'] = date('r', $data['sent']);
            $out .= "\t" . '<item>' . "\n";
            $out .= "\t\t" . '<title><![CDATA[' . (strlen($data['message']) > 37 ? substr($data['message'], 0, 40) . '...' : $data['message']) . ']]></title>' . "\n";
            //title
            $out .= "\t\t" . '<link>http://www.hamsterpaj.net/traffa/guestbook.php?view=' . $param['uid'] . '#guestbook_entry_' . $data['id'] . '</link>' . "\n";
            //link
            $out .= "\t\t" . '<description><![CDATA[' . (strlen($data['message']) > 150 ? substr($data['message'], 0, 147) . '...' : $data['message']) . ']]></description>' . "\n";
            //description
            $out .= "\t\t" . '<author>' . $data['sender_name'] . '</author>' . "\n";
            //author
            $out .= "\t\t" . '<pubDate>' . $data['sent'] . '</pubDate>' . "\n";
            //date when sent
            $out .= '<guid>http://www.hamsterpaj.net/traffa/guestbook.php?view=' . $param['uid'] . '#guestbook_entry_' . $data['id'] . '</guid>';
            $out .= "\t" . '</item>' . "\n\n";
        }
    }
    return $out;
}

function query_cache($options)
{
    global $QUERY_CACHE_CACHE;
    if (strpos('u.birthday < 1970', $options['query']) === true) {
        die('ERROR!!!');
    }
    $options['category'] = isset($options['category']) ? $options['category'] : 'other';
    $options['max_delay'] = isset($options['max_delay']) ? $options['max_delay'] : 300;
    $path = PATHS_INCLUDE . 'cache/query_cache/' . $options['category'] . '/';
    $filename = md5($options['query']) . '.phpserialized';
    if (isset($QUERY_CACHE_CACHE[$filename])) {
        return $QUERY_CACHE_CACHE[$filename];
    }
    if (!is_dir($path)) {
        mkdir($path);
    }
    if (!file_exists($path . $filename)) {
        trace('new_query_cache_' . $options['category'], $options['query']);
    }
    if (filemtime($path . $filename) < time() - $options['max_delay']) {
        $result = mysql_query($options['query']) or report_sql_error($query, __FILE__, __LINE__);
        while ($row = mysql_fetch_assoc($result)) {
            $data[] = $row;
        }
        $serialized = serialize($data);
        //trace('query_cache', 'Creating file for query: ' . $options['query']);
        file_put_contents($path . $filename, $serialized);
    } else {
        $data = unserialize(file_get_contents($path . $filename));
    }
    $QUERY_CACHE_CACHE[$filename] = $data;
    return $data;
}

function digga_like($artist)
{
    $query = 'INSERT INTO user_artists (user, artist) VALUES("' . $_SESSION['login']['id'] . '", "' . $artist . '")';
    if (mysql_query($query)) {
        $query = 'UPDATE artists SET popularity = popularity + 1 WHERE id = "' . $artist . '"';
        mysql_query($query) or die(report_sql_error($query, __FILE__, __LINE__));
    }
    digga_view_info($artist);
}

function register_username_exists($username)
{
    $query = 'SELECT id FROM login WHERE username LIKE "' . $username . '" LIMIT 1';
    $result = mysql_query($query) or die(report_sql_error($query));
    if (mysql_num_rows($result) == 1) {
        return true;
    }
    return false;
}

function friends_actions_insert($options)
{
    $friends_options['friend_id'] = $_SESSION['login']['id'];
    $friends = friends_fetch($friends_options);
    foreach ($friends as $friend) {
        $query = 'INSERT INTO friends_notices (user_id, timestamp, friend_id, action, url, label)';
        $query .= ' VALUES("' . $friend['user_id'] . '", "' . time() . '", "' . $_SESSION['login']['id'] . '", "' . $options['action'] . '", "' . $options['url'] . '", "' . $options['label'] . '")';
        $result = mysql_query($query) or report_sql_error($query, __FILE__, __LINE__);
    }
}

function post_get_timestamp($post_id)
{
    $query = 'SELECT timestamp FROM posts WHERE id = "' . $matches[2] . '"';
    $result = mysql_query($query) or die(report_sql_error($query));
    if ($data = mysql_fetch_assoc($result)) {
        $timestamp = $data['timestamp'];
    } else {
        $timestamp = null;
    }
    return $timestamp;
}

function parlino_sms_credits($user)
{
    $credits = 3;
    $query = 'SELECT sms_sent FROM parlino_sms_credits WHERE user = "' . $user . '" AND date = "' . date('Y-m-d') . '"';
    $result = mysql_query($query) or die(report_sql_error($query, __FILE__, __LINE__));
    if (mysql_num_rows($result) == 1) {
        $data = mysql_fetch_assoc($result);
        $credits -= $data['sms_sent'];
    }
    return $credits;
}

function digga_fetch_diggers($artist_id)
{
    $query = 'SELECT ua.user AS id, l.username, l.lastaction, u.gender, u.birthday, z.spot ';
    $query .= 'FROM user_artists AS ua, login AS l, userinfo AS u, zip_codes AS z ';
    $query .= 'WHERE ua.artist = "' . $artist_id . '" AND l.id = ua.user AND u.userid = ua.user AND ';
    $query .= 'z.zip_code = u.zip_code ';
    $query .= 'ORDER BY l.lastaction DESC LIMIT 50';
    $result = mysql_query($query) or die(report_sql_error($query, __FILE__, __LINE__));
    while ($data = mysql_fetch_assoc($result)) {
        $return[] = $data;
    }
    return $return;
}

function groups_create($options)
{
    $options['founder'] = !isset($options['founder']) ? $_SESSION['login']['id'] : $options['founder'];
    $options['handle'] = !isset($options['handle']) ? url_secure_string($options['name']) : $options['handle'];
    $query = 'INSERT INTO groups(handle, name, description, member_count, created_timestamp, founder, forum_id, auto_join, visible)' . "\n";
    $query .= 'VALUES("' . $options['handle'] . '", "' . $options['name'] . '", "' . $options['description'] . '", 0, ' . time() . ', "' . $options['founder'] . '", 0, "' . $options['auto_join'] . '", "' . $options['visible'] . '")';
    mysql_query($query) or report_sql_error($query);
    $options['id'] = mysql_insert_id();
    if ($options['disable_founder_join'] != true) {
        groups_add_user_to_group(array('group_id' => $options['id'], 'user_id' => $options['founder']));
    }
    return $options;
}

function friends_actions_insert($options)
{
    $query = 'SELECT user_id';
    $query .= ' FROM friendslist';
    $query .= ' WHERE';
    $query .= '	friend_id = "' . $_SESSION['login']['id'] . '"';
    $result = mysql_query($query) or report_sql_error($query, __FILE__, __LINE__);
    while ($data = mysql_fetch_assoc($result)) {
        $query_insert = 'INSERT INTO friends_notices (user_id, timestamp, friend_id, action, url, label)';
        $query_insert .= ' VALUES("' . $data['user_id'] . '", "' . time() . '", "' . $_SESSION['login']['id'] . '", "' . $options['action'] . '", "' . $options['url'] . '", "' . $options['label'] . '")';
        $result_insert = mysql_query($query_insert) or report_sql_error($query_insert, __FILE__, __LINE__);
    }
}

function guestbook_insert($entry)
{
    if ($entry['is_mass_gb'] !== true) {
        if ($_SESSION['login']['id'] == $entry['sender']) {
            if ($_SESSION['last_gb_entry'] > time() - 5) {
                return false;
            }
        }
        if (strlen($entry['message']) == 0) {
            return false;
        }
        if ($entry['recipient'] == 2348 && $entry['sender'] != 2348) {
            $_SESSION['posted_gb_to_webmaster'] = true;
        }
    }
    $entry['is_private'] = $entry['is_private'] == 1 ? 1 : 0;
    $query = 'INSERT INTO traffa_guestbooks(timestamp, recipient, sender, message, is_private)';
    $query .= ' VALUES("' . time() . '", "' . $entry['recipient'] . '", "' . $entry['sender'] . '", "' . $entry['message'] . '", "' . $entry['is_private'] . '")';
    mysql_query($query) or report_sql_error($query, __FILE__, __LINE__);
    $entry['id'] = mysql_insert_id();
    $query = 'UPDATE userinfo SET gb_entries = gb_entries + 1 WHERE userid = "' . $entry['recipient'] . '" LIMIT 1';
    if (!mysql_query($query)) {
        report_sql_error($query, __FILE__, __LINE__);
        return false;
    }
    if (isset($entry['reply-to'])) {
        $query = 'UPDATE traffa_guestbooks SET answered = "Y", `read` =  1 WHERE id = "' . $entry['reply-to'] . '" AND recipient = "' . $entry['sender'] . '" LIMIT 1';
        if (!mysql_query($query)) {
            report_sql_error($query, __FILE__, __LINE__);
            return false;
        }
    }
    if ($entry['is_mass_gb'] !== true) {
        $query = 'SELECT session_id FROM login WHERE id = "' . $entry['recipient'] . '" LIMIT 1';
        $result = mysql_query($query) or report_sql_error($query, __FILE__, __LINE__);
        $data = mysql_fetch_assoc($result);
        if (strlen($data['session_id']) > 5) {
            $remote_session = session_load($data['session_id']);
            $remote_session['notices']['unread_gb_entries'] += 1;
            $entry['image'] = $_SESSION['userinfo']['image'];
            $entry['timestamp'] = time();
            $entry['message'] = stripslashes($entry['message']);
            $entry['username'] = $_SESSION['login']['username'];
            $remote_session['unread_gb_entries'][] = $entry;
            session_save($data['session_id'], $remote_session);
        }
    }
    $_SESSION['last_gb_entry'] = time();
    return true;
}

function fp_modules_fetch($options)
{
    $query = 'SELECT * FROM fp_modules WHERE 1';
    $query .= isset($options['removal_min']) ? ' AND removal >= "' . $options['removal_min'] . '"' : '';
    $query .= isset($options['removal_max']) ? ' AND removal <= "' . $options['removal_max'] . '"' : '';
    $query .= isset($options['launch_min']) ? ' AND launch >= "' . $options['launch_min'] . '"' : '';
    $query .= isset($options['launch_max']) ? ' AND launch <= "' . $options['launch_max'] . '"' : '';
    $query .= isset($options['id']) ? ' AND id = "' . $options['id'] . '"' : '';
    $query .= isset($options['order-by']) ? ' ORDER BY ' . $options['order-by'] : ' ORDER BY priority';
    $query .= isset($options['order-direction']) ? ' ' . $options['order-direction'] : ' DESC';
    $result = mysql_query($query) or report_sql_error($query);
    while ($data = mysql_fetch_assoc($result)) {
        $modules[] = $data;
    }
    return $modules;
}

function tips_reciever_status_set($options)
{
    /*
    options				kommentar
    reciever			e-mail
    hash				hash password
    status				'accepts', 'denies'
    */
    $query = 'UPDATE tips_recievers SET status="' . $options['status'] . '" WHERE';
    if (isset($options['hash'])) {
        $query .= ' hash="' . $options['hash'] . '"';
    } else {
        $query .= ' reciever="' . $options['reciever'] . '"';
    }
    $result = mysql_query($query) or die(report_sql_error($query, __FILE__, __LINE__));
    return $result > 0;
}

function suggestion_fetch($fetch)
{
    $fetch['display_level'] = isset($fetch['display_level']) ? $fetch['display_level'] : array('normal');
    $query = 'SELECT s.*, al.username AS author_username, login.username AS responsible_username FROM login AS al, suggestions AS s';
    $query .= ' LEFT JOIN login ON s.responsible = login.id';
    $query .= ' WHERE al.id = s.author';
    $query .= isset($fetch['display_level']) ? ' AND s.display_level IN("' . implode('", "', $fetch['display_level']) . '")' : '';
    $query .= isset($fetch['id']) ? ' AND s.id IN("' . implode('", "', $fetch['id']) . '")' : '';
    $query .= isset($fetch['category']) ? ' AND s.category IN("' . implode('", "', $fetch['category']) . '")' : '';
    $query .= isset($fetch['classification']) ? ' AND s.classification IN("' . implode('", "', $fetch['classification']) . '")' : '';
    $query .= ' ORDER BY s.last_update DESC, s.id DESC';
    $query .= isset($fetch['limit']) ? ' LIMIT ' . $fetch['limit'] : '';
    $result = mysql_query($query) or die(report_sql_error($query, __FILE__, __LINE__));
    while ($data = mysql_fetch_assoc($result)) {
        $return[$data['id']] = $data;
    }
    return $return;
}