Changeset 1608

Show
Ignore:
Timestamp:
04/21/08 12:04:14 (3 months ago)
Author:
Neal
Message:

Removed the use of unbuffered queries. The performance gains are minimal and they can cause problems that are difficult to track down.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • branches/punbb-1.3-dev/upload/extern.php

    r1597 r1608  
    307307 
    308308                ($hook = get_hook('ex_qr_get_posts')) ? eval($hook) : null; 
    309                 $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     309                $result = $db->query_build($query) or error(__FILE__, __LINE__); 
    310310                while ($cur_post = $db->fetch_assoc($result)) 
    311311                { 
    …… 
    392392 
    393393                ($hook = get_hook('ex_qr_get_topics')) ? eval($hook) : null; 
    394                 $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     394                $result = $db->query_build($query) or error(__FILE__, __LINE__); 
    395395                while ($cur_topic = $db->fetch_assoc($result)) 
    396396                { 
    …… 
    438438 
    439439        ($hook = get_hook('ex_qr_get_users_online')) ? eval($hook) : null; 
    440         $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     440        $result = $db->query_build($query) or error(__FILE__, __LINE__); 
    441441        while ($pun_user_online = $db->fetch_assoc($result)) 
    442442        { 

  • branches/punbb-1.3-dev/upload/footer.php

    r1592 r1608  
    103103 
    104104                ($hook = get_hook('ft_qr_get_online_info')) ? eval($hook) : null; 
    105                 $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     105                $result = $db->query_build($query) or error(__FILE__, __LINE__); 
    106106                $num_guests = 0; 
    107107                $users = array(); 

  • branches/punbb-1.3-dev/upload/include/cache.php

    r1565 r1608  
    4343 
    4444        ($hook = get_hook('ch_qr_get_config')) ? eval($hook) : null; 
    45         $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     45        $result = $db->query_build($query) or error(__FILE__, __LINE__); 
    4646 
    4747        $output = array(); 
    …… 
    8181 
    8282        ($hook = get_hook('ch_qr_get_bans')) ? eval($hook) : null; 
    83         $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     83        $result = $db->query_build($query) or error(__FILE__, __LINE__); 
    8484 
    8585        $output = array(); 
    …… 
    113113 
    114114        ($hook = get_hook('ch_qr_get_ranks')) ? eval($hook) : null; 
    115         $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     115        $result = $db->query_build($query) or error(__FILE__, __LINE__); 
    116116 
    117117        $output = array(); 
    …… 
    145145 
    146146        ($hook = get_hook('ch_qr_get_censored_words')) ? eval($hook) : null; 
    147         $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     147        $result = $db->query_build($query) or error(__FILE__, __LINE__); 
    148148 
    149149        $output = array(); 
    …… 
    218218 
    219219                ($hook = get_hook('ch_qr_get_cats_and_forums')) ? eval($hook) : null; 
    220                 $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     220                $result = $db->query_build($query) or error(__FILE__, __LINE__); 
    221221 
    222222                $cur_category = 0; 
    …… 
    272272 
    273273        ($hook = get_hook('ch_qr_get_hooks')) ? eval($hook) : null; 
    274         $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     274        $result = $db->query_build($query) or error(__FILE__, __LINE__); 
    275275 
    276276        $output = array(); 

  • branches/punbb-1.3-dev/upload/include/common_admin.php

    r1526 r1608  
    142142 
    143143        ($hook = get_hook('ca_qr_get_topics_to_prune')) ? eval($hook) : null; 
    144         $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     144        $result = $db->query_build($query) or error(__FILE__, __LINE__); 
    145145 
    146146        $topic_ids = ''; 
    …… 
    158158 
    159159                ($hook = get_hook('ca_qr_get_posts_to_prune')) ? eval($hook) : null; 
    160                 $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     160                $result = $db->query_build($query) or error(__FILE__, __LINE__); 
    161161 
    162162                $post_ids = ''; 

  • branches/punbb-1.3-dev/upload/include/search_idx.php

    r1375 r1608  
    9595        if ($mode == 'edit') 
    9696        { 
    97                 $result = $db->query('SELECT w.id, w.word, m.subject_match FROM '.$db->prefix.'search_words AS w INNER JOIN '.$db->prefix.'search_matches AS m ON w.id=m.word_id WHERE m.post_id='.$post_id, true) or error(__FILE__, __LINE__); 
     97                $result = $db->query('SELECT w.id, w.word, m.subject_match FROM '.$db->prefix.'search_words AS w INNER JOIN '.$db->prefix.'search_matches AS m ON w.id=m.word_id WHERE m.post_id='.$post_id) or error(__FILE__, __LINE__); 
    9898 
    9999                // Declare here to stop array_keys() and array_diff() from complaining if not set 
    …… 
    130130        if (!empty($unique_words)) 
    131131        { 
    132                 $result = $db->query('SELECT id, word FROM '.$db->prefix.'search_words WHERE word IN('.implode(',', preg_replace('#^(.*)$#', '\'\1\'', $unique_words)).')', true) or error(__FILE__, __LINE__); 
     132                $result = $db->query('SELECT id, word FROM '.$db->prefix.'search_words WHERE word IN('.implode(',', preg_replace('#^(.*)$#', '\'\1\'', $unique_words)).')') or error(__FILE__, __LINE__); 
    133133 
    134134                $word_ids = array(); 

  • branches/punbb-1.3-dev/upload/index.php

    r1533 r1608  
    5757 
    5858        ($hook = get_hook('in_qr_get_new_topics')) ? eval($hook) : null; 
    59         $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     59        $result = $db->query_build($query) or error(__FILE__, __LINE__); 
    6060 
    6161        $new_topics = array(); 
    …… 
    9191 
    9292($hook = get_hook('in_qr_get_cats_and_forums')) ? eval($hook) : null; 
    93 $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     93$result = $db->query_build($query) or error(__FILE__, __LINE__); 
    9494 
    9595?> 

  • branches/punbb-1.3-dev/upload/moderate.php

    r1606 r1608  
    379379 
    380380        ($hook = get_hook('mr_qr_get_posts')) ? eval($hook) : null; 
    381         $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     381        $result = $db->query_build($query) or error(__FILE__, __LINE__); 
    382382        while ($cur_post = $db->fetch_assoc($result)) 
    383383        { 

  • branches/punbb-1.3-dev/upload/search.php

    r1606 r1608  
    168168 
    169169                                                ($hook = get_hook('se_qr_get_keyword_hits')) ? eval($hook) : null; 
    170                                                 $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     170                                                $result = $db->query_build($query) or error(__FILE__, __LINE__); 
    171171 
    172172                                                $row = array(); 
    …… 
    291291 
    292292                ($hook = get_hook('se_qr_get_hits')) ? eval($hook) : null; 
    293                 $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     293                $result = $db->query_build($query) or error(__FILE__, __LINE__); 
    294294 
    295295                $search_ids = array(); 
    …… 
    11901190 
    11911191($hook = get_hook('se_qr_get_cats_and_forums')) ? eval($hook) : null; 
    1192 $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     1192$result = $db->query_build($query) or error(__FILE__, __LINE__); 
    11931193 
    11941194$cur_category = 0; 

  • branches/punbb-1.3-dev/upload/viewtopic.php

    r1606 r1608  
    295295 
    296296($hook = get_hook('vt_qr_get_posts')) ? eval($hook) : null; 
    297 $result = $db->query_build($query, true) or error(__FILE__, __LINE__); 
     297$result = $db->query_build($query) or error(__FILE__, __LINE__); 
    298298while ($cur_post = $db->fetch_assoc($result)) 
    299299{