hjkhghopjkertteerterterterertertrtoirh
bnmbertsurhetertertertertertertertpdf'tdfg
/
home
/
ubuntu
/
bmse.net
/
Upload FileeE
HOME
<?php //ini_set('display_errors',1); include('includes/application_includes.php'); $visitorsinfo = $db->getRows('select * from `bmse_visitor_track` WHERE `status`="update" order by `id` limit 15000'); if (!empty($visitorsinfo)) { $i=0; foreach($visitorsinfo as $visitorsin){ $values = array( 'visitor_sessid'=>$visitorsin['visitor_sessid'], 'visitor_ip'=>$visitorsin['visitor_ip'], 'visited_page'=>$visitorsin['visited_page'], 'event_id'=>$visitorsin['event_id'], 'visitor_http_user_agent'=>$visitorsin['visitor_http_user_agent'], 'visitor_http_referrer'=>$visitorsin['visitor_http_referrer'], 'visitor_remote_host'=>$visitorsin['visitor_remote_host'], 'insert_dttm'=>$visitorsin['insert_dttm'], 'event_start_dttm'=>$visitorsin['event_start_dttm'] ); $dbtwo = new Database(DB_SERVER,DB_USER,DB_PASSWORD,'betterlivingshow'); $dbtwo->insert('bmse_visitor_track',$values); $db = new Database(DB_SERVER,DB_USER,DB_PASSWORD,DB_NAME); $db->query('update `bmse_visitor_track` set `status`="updated" WHERE `id`='.$visitorsin['id'].''); $i++; } } echo ''.$i.' Records are inserted.'; ?>