Changeset 4294 for sandbox

Show
Ignore:
Timestamp:
06/18/2008 06:14:05 PM (3 months ago)
Author:
zero
Message:

현재 접속자 추출시 쿼리가 잘못 작성되는 오류 수정

Location:
sandbox/modules/session
Files:
3 modified

Legend:

Unmodified
Added
Removed

  • sandbox/modules/session/queries/getLoggedMembers.xml

    r4292 r4294  
    77    </columns> 
    88    <conditions> 
    9         <condition operation="more" column="last_update" var="last_update" notnull="notnull" /> 
     9        <condition operation="more" column="member_srl" default="1" pipe="and" /> 
     10        <condition operation="more" column="last_update" var="last_update" notnull="notnull" pipe="and" /> 
    1011        <condition operation="equal" column="cur_mid" var="mid" pipe="and" /> 
    1112    </conditions> 

  • sandbox/modules/session/session.class.php

    r4292 r4294  
    2727 
    2828            $oDB = &DB::getInstance(); 
    29             $oDB->addIndex("session","idx_session_update_mid", array("last_update","cur_mid")); 
     29            $oDB->addIndex("session","idx_session_update_mid", array("member_srl","last_update","cur_mid")); 
    3030 
    3131            return new Object(); 
    … …  
    6868 
    6969            if(!$oDB->isIndexExists("session","idx_session_update_mid"))  
    70                 $oDB->addIndex("session","idx_session_update_mid", array("last_update","cur_mid")); 
     70                $oDB->addIndex("session","idx_session_update_mid", array("member_srl","last_update","cur_mid")); 
    7171 
    7272        } 

  • sandbox/modules/session/session.model.php

    r4293 r4294  
    5050         **/ 
    5151        function getLoggedMembers($args) { 
    52             if(!$args->limit_count) $args->limit_count = 20; 
     52            if(!$args->list_count) $args->list_count = 20; 
    5353            if(!$args->page) $args->page = 1; 
    5454            if(!$args->period_time) $args->period_time = 3;