MyBB Aylık İstatistikler Tablosu Ekleme

[023]

Kaynak: Stats Page Using Chart
Türkçe Çeviridir, hem rehber hem kodlar.
Adım 1
stats.php dosyasını açın.
Aşağıdaki kodu bulun:

$plugins->run_hooks("stats_end");

Ve onun öncesine bu kodu yapıştırın.

$i = 1;

while ($i <= 30) {
    $daily[$i] = TIME_NOW - (86400 * $i);
    $before[$i] = TIME_NOW - (86400 * ($i + 1));

    $datestats[$i] = date('Y,m,d', strtotime("-1 months", TIME_NOW - (86400 * ($i - 1))));

    $postquery[$i] = $db->query("SELECT COUNT(*) AS newposts FROM `".TABLE_PREFIX."posts` WHERE dateline BETWEEN '".$before[$i]."' AND '".$daily[$i]."'");
    $postsdata[$i] = my_number_format($db->fetch_field($postquery[$i], "newposts"));

    $threadquery[$i] = $db->query("SELECT COUNT(*) AS newthreads FROM `".TABLE_PREFIX."threads` WHERE dateline BETWEEN '".$before[$i]."' AND '".$daily[$i]."' AND closed NOT LIKE 'moved|%'");
    $threadsdata[$i] = my_number_format($db->fetch_field($threadquery[$i], "newthreads"));

    $newuserquery[$i] = $db->query("SELECT COUNT(*) AS newusers FROM `".TABLE_PREFIX."users` WHERE regdate BETWEEN '".$before[$i]."' AND '".$daily[$i]."'");
    $newusersdata[$i] = my_number_format($db->fetch_field($newuserquery[$i], "newusers"));

    $activequery[$i] = $db->query("SELECT COUNT(*) AS activeusers FROM `".TABLE_PREFIX."users` WHERE lastvisit BETWEEN '".$before[$i]."' AND '".$daily[$i]."'");
    $activesdata[$i] = my_number_format($db->fetch_field($activequery[$i], "activeusers"));

    $i = $i + 1;
}

Şunun gibi:

Adım 2
Bu dosyayı indirin ve sitenizdeki jscripts klasörüne atın (Türkçe'ye çevrilmiştir.)
Admin panelinden Şablonlar>{Şablonunuz}>İstatik Şablonlar>stats şablonuna gidin.
{headerinclude}'den sonrasına şu kodu yapıştırın: (site.adresiniz.com yazan yeri site adresinize göre değiştirin.)

<script src="https://site.adresiniz.com/jscripts/highcharts.src.js"></script>

{header}'dan sonrasına şu kodu yapıştırın:

<table border="0" cellspacing="{$theme['borderwidth']}" cellpadding="{$theme['tablespace']}" class="tborder showhide fullwidth">
<tr>
<td class="thead"><strong>Aylık İstatistikler</strong></td>
</tr>
<tr>
<td class="trow1">
<div id="graphstats" style="width:100%; height:300px;"></div>
<script type="text/javascript">
Highcharts.chart('graphstats', {
    chart: {
        type: 'areaspline'
    },
    title: {
        text: ''
    },
    legend: {
        layout: 'horizontal',
        align: 'center',
        verticalAlign: 'bottom',
        backgroundColor: (Highcharts.theme && Highcharts.theme.legendBackgroundColor) || 'transparent',
        itemStyle: {
            color: 'white'
        },
        itemHoverStyle:{
            color: 'gray'
        },
        itemHiddenStyle:{
            color: '#444'
        }  
    },
    xAxis: {
            gridLineColor: '#2f2f2f',
            type:'datetime'
    },
    yAxis: {
        title: {
            text: 'Sayı'
        },
            gridLineColor: '#2f2f2f'
    },
    tooltip: {
        shared: true
    },
    credits: {
        enabled: false
    },
    plotOptions: {
        areaspline: {
            fillOpacity: 0.4
        }
    },
    series: [{
        name: 'Gönderiler',
        data: [[Date.UTC({$datestats[1]}),{$postsdata[1]}],
                    [Date.UTC({$datestats[2]}),{$postsdata[2]}],
                    [Date.UTC({$datestats[3]}),{$postsdata[3]}],
                    [Date.UTC({$datestats[4]}),{$postsdata[4]}],
                    [Date.UTC({$datestats[5]}),{$postsdata[5]}],
                    [Date.UTC({$datestats[6]}),{$postsdata[6]}],
                    [Date.UTC({$datestats[7]}),{$postsdata[7]}],
                    [Date.UTC({$datestats[8]}),{$postsdata[8]}],
                    [Date.UTC({$datestats[9]}),{$postsdata[9]}],
                    [Date.UTC({$datestats[10]}),{$postsdata[10]}],
                    [Date.UTC({$datestats[11]}),{$postsdata[11]}],
                    [Date.UTC({$datestats[12]}),{$postsdata[12]}],
                    [Date.UTC({$datestats[13]}),{$postsdata[13]}],
                    [Date.UTC({$datestats[14]}),{$postsdata[14]}],
                    [Date.UTC({$datestats[15]}),{$postsdata[15]}],
                    [Date.UTC({$datestats[16]}),{$postsdata[16]}],
                    [Date.UTC({$datestats[17]}),{$postsdata[17]}],
                    [Date.UTC({$datestats[18]}),{$postsdata[18]}],
                    [Date.UTC({$datestats[19]}),{$postsdata[19]}],
                    [Date.UTC({$datestats[20]}),{$postsdata[20]}],
                    [Date.UTC({$datestats[21]}),{$postsdata[21]}],
                    [Date.UTC({$datestats[22]}),{$postsdata[22]}],
                    [Date.UTC({$datestats[23]}),{$postsdata[23]}],
                    [Date.UTC({$datestats[24]}),{$postsdata[24]}],
                    [Date.UTC({$datestats[25]}),{$postsdata[25]}],
                    [Date.UTC({$datestats[26]}),{$postsdata[26]}],
                    [Date.UTC({$datestats[27]}),{$postsdata[27]}],
                    [Date.UTC({$datestats[28]}),{$postsdata[28]}],
                    [Date.UTC({$datestats[29]}),{$postsdata[29]}],
                    [Date.UTC({$datestats[30]}),{$postsdata[30]}]],
            pointStart: Date.UTC({$datestats[1]})
    }, {
        color:'#c84040',
        name: 'Konular',
        data: [[Date.UTC({$datestats[1]}),{$threadsdata[1]}],
                    [Date.UTC({$datestats[2]}),{$threadsdata[2]}],
                    [Date.UTC({$datestats[3]}),{$threadsdata[3]}],
                    [Date.UTC({$datestats[4]}),{$threadsdata[4]}],
                    [Date.UTC({$datestats[5]}),{$threadsdata[5]}],
                    [Date.UTC({$datestats[6]}),{$threadsdata[6]}],
                    [Date.UTC({$datestats[7]}),{$threadsdata[7]}],
                    [Date.UTC({$datestats[8]}),{$threadsdata[8]}],
                    [Date.UTC({$datestats[9]}),{$threadsdata[9]}],
                    [Date.UTC({$datestats[10]}),{$threadsdata[10]}],
                    [Date.UTC({$datestats[11]}),{$threadsdata[11]}],
                    [Date.UTC({$datestats[12]}),{$threadsdata[12]}],
                    [Date.UTC({$datestats[13]}),{$threadsdata[13]}],
                    [Date.UTC({$datestats[14]}),{$threadsdata[14]}],
                    [Date.UTC({$datestats[15]}),{$threadsdata[15]}],
                    [Date.UTC({$datestats[16]}),{$threadsdata[16]}],
                    [Date.UTC({$datestats[17]}),{$threadsdata[17]}],
                    [Date.UTC({$datestats[18]}),{$threadsdata[18]}],
                    [Date.UTC({$datestats[19]}),{$threadsdata[19]}],
                    [Date.UTC({$datestats[20]}),{$threadsdata[20]}],
                    [Date.UTC({$datestats[21]}),{$threadsdata[21]}],
                    [Date.UTC({$datestats[22]}),{$threadsdata[22]}],
                    [Date.UTC({$datestats[23]}),{$threadsdata[23]}],
                    [Date.UTC({$datestats[24]}),{$threadsdata[24]}],
                    [Date.UTC({$datestats[25]}),{$threadsdata[25]}],
                    [Date.UTC({$datestats[26]}),{$threadsdata[26]}],
                    [Date.UTC({$datestats[27]}),{$threadsdata[27]}],
                    [Date.UTC({$datestats[28]}),{$threadsdata[28]}],
                    [Date.UTC({$datestats[29]}),{$threadsdata[29]}],
                    [Date.UTC({$datestats[30]}),{$threadsdata[30]}]],
            pointStart: Date.UTC({$datestats[1]})
    }, {
        color:'#800080',
        name: 'Kullanıcılar',
        data: [[Date.UTC({$datestats[1]}),{$newusersdata[1]}],
                    [Date.UTC({$datestats[2]}),{$newusersdata[2]}],
                    [Date.UTC({$datestats[3]}),{$newusersdata[3]}],
                    [Date.UTC({$datestats[4]}),{$newusersdata[4]}],
                    [Date.UTC({$datestats[5]}),{$newusersdata[5]}],
                    [Date.UTC({$datestats[6]}),{$newusersdata[6]}],
                    [Date.UTC({$datestats[7]}),{$newusersdata[7]}],
                    [Date.UTC({$datestats[8]}),{$newusersdata[8]}],
                    [Date.UTC({$datestats[9]}),{$newusersdata[9]}],
                    [Date.UTC({$datestats[10]}),{$newusersdata[10]}],
                    [Date.UTC({$datestats[11]}),{$newusersdata[11]}],
                    [Date.UTC({$datestats[12]}),{$newusersdata[12]}],
                    [Date.UTC({$datestats[13]}),{$newusersdata[13]}],
                    [Date.UTC({$datestats[14]}),{$newusersdata[14]}],
                    [Date.UTC({$datestats[15]}),{$newusersdata[15]}],
                    [Date.UTC({$datestats[16]}),{$newusersdata[16]}],
                    [Date.UTC({$datestats[17]}),{$newusersdata[17]}],
                    [Date.UTC({$datestats[18]}),{$newusersdata[18]}],
                    [Date.UTC({$datestats[19]}),{$newusersdata[19]}],
                    [Date.UTC({$datestats[20]}),{$newusersdata[20]}],
                    [Date.UTC({$datestats[21]}),{$newusersdata[21]}],
                    [Date.UTC({$datestats[22]}),{$newusersdata[22]}],
                    [Date.UTC({$datestats[23]}),{$newusersdata[23]}],
                    [Date.UTC({$datestats[24]}),{$newusersdata[24]}],
                    [Date.UTC({$datestats[25]}),{$newusersdata[25]}],
                    [Date.UTC({$datestats[26]}),{$newusersdata[26]}],
                    [Date.UTC({$datestats[27]}),{$newusersdata[27]}],
                    [Date.UTC({$datestats[28]}),{$newusersdata[28]}],
                    [Date.UTC({$datestats[29]}),{$newusersdata[29]}],
                    [Date.UTC({$datestats[30]}),{$newusersdata[30]}]],
            pointStart: Date.UTC({$date01})
    }, {
        color:'#FFD700',
        name: 'Aktif Kullanıcılar',
       data: [[Date.UTC({$datestats[1]}),{$activesdata[1]}],
                    [Date.UTC({$datestats[2]}),{$activesdata[2]}],
                    [Date.UTC({$datestats[3]}),{$activesdata[3]}],
                    [Date.UTC({$datestats[4]}),{$activesdata[4]}],
                    [Date.UTC({$datestats[5]}),{$activesdata[5]}],
                    [Date.UTC({$datestats[6]}),{$activesdata[6]}],
                    [Date.UTC({$datestats[7]}),{$activesdata[7]}],
                    [Date.UTC({$datestats[8]}),{$activesdata[8]}],
                    [Date.UTC({$datestats[9]}),{$activesdata[9]}],
                    [Date.UTC({$datestats[10]}),{$activesdata[10]}],
                    [Date.UTC({$datestats[11]}),{$activesdata[11]}],
                    [Date.UTC({$datestats[12]}),{$activesdata[12]}],
                    [Date.UTC({$datestats[13]}),{$activesdata[13]}],
                    [Date.UTC({$datestats[14]}),{$activesdata[14]}],
                    [Date.UTC({$datestats[15]}),{$activesdata[15]}],
                    [Date.UTC({$datestats[16]}),{$activesdata[16]}],
                    [Date.UTC({$datestats[17]}),{$activesdata[17]}],
                    [Date.UTC({$datestats[18]}),{$activesdata[18]}],
                    [Date.UTC({$datestats[19]}),{$activesdata[19]}],
                    [Date.UTC({$datestats[20]}),{$activesdata[20]}],
                    [Date.UTC({$datestats[21]}),{$activesdata[21]}],
                    [Date.UTC({$datestats[22]}),{$activesdata[22]}],
                    [Date.UTC({$datestats[23]}),{$activesdata[23]}],
                    [Date.UTC({$datestats[24]}),{$activesdata[24]}],
                    [Date.UTC({$datestats[25]}),{$activesdata[25]}],
                    [Date.UTC({$datestats[26]}),{$activesdata[26]}],
                    [Date.UTC({$datestats[27]}),{$activesdata[27]}],
                    [Date.UTC({$datestats[28]}),{$activesdata[28]}],
                    [Date.UTC({$datestats[29]}),{$activesdata[29]}],
                    [Date.UTC({$datestats[30]}),{$activesdata[30]}]],
            pointStart: Date.UTC({$date01})
    }]
});
</script>
</td>
</tr>
</table>
<br>

Bitti
Örnek:

Farklı tablo türleri için şablona eklediğiniz,

type: 'areaspline'

satırındaki 'areaspline' değerini şuraya göre değiştirebilirsiniz. Rehberin orijinalinde areaspline yazdığı için öyle yazdım, ama ben spline öneriyorum. Daha hoş duruyor.

Bazı yerleri değiştirdim, bazı yerlere ekleme yaptım, 2. adımdan sonra gelen CSS bölümünü işe yaramadığı için çıkarttım. Orijinal rehberi, konunun başında bulabilirsiniz.
Rehberin katkısı olmuştur umarım.