M72X2/X2/adm/browscap_converter.php



<title>M72X2/X2/adm/browscap_converter.php</title>


<div class="header">M72X2/X2/adm/browscap_converter.php</div>
<pre>&lt;?php
ini_set(&#039;memory_limit&#039;, &#039;-1&#039;);
require_once &#039;./_common.php&#039;;

// clean the output buffer
ob_end_clean();

if (!(version_compare(phpversion(), &#039;5.3.0&#039;, &#039;&gt;=&#039;) &amp;&amp; defined(&#039;G5_BROWSCAP_USE&#039;) &amp;&amp; G5_BROWSCAP_USE)) {
    die(&#039;사용할 수 없는 기능입니다.&#039;);
}

if ($is_admin != &#039;super&#039;) {
    die(&#039;최고관리자로 로그인 후 실행해 주세요.&#039;);
}

// browscap cache 파일 체크
if (!is_file(G5_DATA_PATH . &#039;/cache/browscap_cache.php&#039;)) {
    echo &#039;&lt;p&gt;Browscap 정보가 없습니다. 아래 링크로 이동해 Browscap 정보를 업데이트 하세요.&lt;/p&gt;&#039; . PHP_EOL;
    echo &#039;&lt;p&gt;&lt;a href=&quot;&#039; . G5_ADMIN_URL . &#039;/browscap.php&quot;&gt;Browscap 업데이트&lt;/a&gt;&lt;/p&gt;&#039; . PHP_EOL;
    exit;
}

require_once G5_PLUGIN_PATH . &#039;/browscap/Browscap.php&#039;;
$browscap = new phpbrowscap\Browscap(G5_DATA_PATH . &#039;/cache&#039;);
$browscap-&gt;doAutoUpdate = false;
$browscap-&gt;cacheFilename = &#039;browscap_cache.php&#039;;

// 데이터 변환
$rows = isset($_GET[&#039;rows&#039;]) ? preg_replace(&#039;#[^0-9]#&#039;, &#039;&#039;, $_GET[&#039;rows&#039;]) : 0;
if (!$rows) {
    $rows = 100;
}

$sql_common = &quot; from {$g5[&#039;visit_table&#039;]} where vi_agent &lt;&gt; &#039;&#039; and ( vi_browser = &#039;&#039; or vi_os = &#039;&#039; or vi_device = &#039;&#039; ) &quot;;
$sql_order  = &quot; order by vi_id desc &quot;;
$sql_limit  = &quot; limit 0, &quot; . strval($rows) . &quot; &quot;;

$sql = &quot; select count(vi_id) as cnt $sql_common &quot;;
$row = sql_fetch($sql);
$total_count = $row[&#039;cnt&#039;];

$sql = &quot; select vi_id, vi_agent, vi_browser, vi_os, vi_device
            $sql_common
            $sql_order
            $sql_limit &quot;;
$result = sql_query($sql);

$cnt = 0;
for ($i = 0; $row = sql_fetch_array($result); $i++) {
    $info = $browscap-&gt;getBrowser($row[&#039;vi_agent&#039;]);

    $brow = $row[&#039;vi_browser&#039;];
    if (!$brow) {
        $brow = $info-&gt;Comment;
    }

    $os = $row[&#039;vi_os&#039;];
    if (!$os) {
        $os = $info-&gt;Platform;
    }

    $device = $row[&#039;vi_device&#039;];
    if (!$device) {
        $device = $info-&gt;Device_Type;
    }

    $sql2 = &quot; update {$g5[&#039;visit_table&#039;]}
                set vi_browser  = &#039;$brow&#039;,
                    vi_os       = &#039;$os&#039;,
                    vi_device   = &#039;$device&#039;
                where vi_id = &#039;{$row[&#039;vi_id&#039;]}&#039; &quot;;
    sql_query($sql2);

    $cnt++;
}

if (($total_count - $cnt) == 0 || $total_count == 0) {
    echo &#039;&lt;div class=&quot;check_processing&quot;&gt;&lt;/div&gt;&lt;p&gt;변환완료&lt;/p&gt;&#039;;
} else {
    echo &#039;&lt;p&gt;총 &#039; . number_format($total_count) . &#039;건 중 &#039; . number_format($cnt) . &#039;건 변환완료&lt;br&gt;&lt;br&gt;접속로그를 추가로 변환하시려면 아래 업데이트 버튼을 클릭해 주세요.&lt;/p&gt;&lt;button type=&quot;button&quot; id=&quot;run_update&quot;&gt;업데이트&lt;/button&gt;&#039;;
}
</pre>