Follow along with the video below to see how to install our site as a web app on your home screen.
Примечание: This feature may not be available in some browsers.
SELECT * FROM forum_sessions ORDER BY running_time desc LIMIT 0, 25
это стольок народу постоянно на форуме? 8 страниц?
сдается мне что большая часть строк - устаревшие, просто они не удалились
попробуй обнулить эту таблицу
SHUTDOWN: UPDATE forum_sessions SET member_name='',member_id=0,member_group=2,login_type=0,running_time=1238189566,location='Login,0,01',in_error=0,location_1_type='',location_1_id=0,location_2_type='',location_2_id=0,location_3_type='',location_3_id=0 WHERE id='874dc3c1cd4918a5d1a2b7a7ce55fe8a'
$this->ipsclass->DB->simple_construct( array( 'select' => 'id, member_id, member_name, login_type, running_time, member_group',
'from' => 'sessions',
'where' => "running_time > $time",
//'order' => "running_time DESC" // Sort in PHP to avoid filesort in SQL
) );
SELECT id, member_id, member_name, login_type, running_time, member_group FROM ibf_sessions
SELECT a.id, a.member_id, b.name, a.login_type, a.running_time, a.member_group FROM ibf_sessions a,
ibf_members b WHERE a.id=b.id
$this->ipsclass->DB->do_shutdown_insert( 'sessions',
array(
'id' => $this->session_id,
'member_name' => $this->member['members_display_name'],
'member_id' => intval($this->member['id']),
'member_group' => $this->member['mgroup'],
'login_type' => intval(substr($this->member['login_anonymous'],0, 1)),
'running_time' => $this->time_now,
'ip_address' => $this->ipsclass->ip_address,
'browser' => substr( $this->ipsclass->user_agent, 0, 200 ),
'location' => $vars['location'],
'in_error' => 0,
'location_1_type' => isset($vars['1_type']) ? $vars['1_type'] : '',
'location_1_id' => isset($vars['1_id']) ? intval($vars['1_id']) : 0,
'location_2_type' => isset($vars['2_type']) ? $vars['2_type'] : '',
'location_2_id' => isset($vars['2_id']) ? intval($vars['2_id']) : 0,
'location_3_type' => isset($vars['3_type']) ? $vars['3_type'] : '',
'location_3_id' => isset($vars['3_id']) ? intval($vars['3_id']) : 0,
SHUTDOWN: INSERT INTO forum_sessions (id,member_name,member_id,member_group,login_type,running_time,ip_address,browser,location,in_error,location_1_type,location_1_id,location_2_type,location_2_id,location_3_type,location_3_id) VALUES('a97f3178fecf7a19038570b60585bd7a','',0,2,0,1238230913,'127.0.0.1','Opera/9.63 (Windows NT 6.1; U; ru) Presto/2.1.1','idx,0,',0,'',0,'',0,'',0)
SHUTDOWN: INSERT INTO forum_sessions (id,member_name,member_id,member_group,login_type,running_time,ip_address,browser,location,in_error,location_1_type,location_1_id,location_2_type,location_2_id,location_3_type,location_3_id) VALUES('2af78ae772e6580fce04dda64ecbc309','Виллен',1048,4,0,1238231172,'127.0.0.1','Opera/9.63 (Windows NT 6.1; U; ru) Presto/2.1.1','idx,0,',0,'',0,'',0,'',0)
'ip_address' => '10.100.100.1'