MyBBCode

**Noah** · 01-10-2021, 08:00 PM

Bu modifikasyon, forumunuzda bulunan istatistik sayfasının grafik şeklinde görüntülenmesini sağlayacaktır.

Görünüm (Demo)

Nasıl Yapılır?

Adım 1:

Web site dizininizde bulunan stats.php dosyasını açın. Aşağıdaki kodu bulun.

$plugins->run_hooks("stats_end");

Aşağıda vermiş olduğum kodları yukarıdaki kodun altına ekleyin.

// İstatistik Sayfası [Özel]

$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))));



    // Posts

    $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"));



    // Threads

    $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"));



    // New Users

    $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"));



    // Active Users

    $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;

}

// Son

Adım 2:

Bu adımları eksiksiz yaptıktan sonra Admin Panelinize girin. Şablonlar > Kullandığınız Temanın Şablonları > İstatistik Şablonları > stats kısmına gelin. Daha sonra {$headerinclude} bileşeninin altına aşağıdaki kodu ekleyin.

<script src="https://code.highcharts.com/highcharts.src.js"></script>

Adım 3:

Tekrardan Şablonlar > Kullandığınız Temanın Şablonları > İstatistik Şablonları > stats kısmına gelin. Daha sonra {$header} bileşeninin altına aşağıdaki kodu ekleyin.

<table border="0" cellspacing="{$theme['borderwidth']}" cellpadding="{$theme['tablespace']}" class="tborder showhide fullwidth">

<tr>

<td class="tcat"><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: 'Miktar'

        },

            gridLineColor: '#2f2f2f'

    },

    tooltip: {

        shared: true

    },

    credits: {

        enabled: false

    },

    plotOptions: {

        areaspline: {

            fillOpacity: 0.4

        }

    },

    series: [{

        name: 'Yorumlar',

        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>

<table border="0" cellspacing="{$theme['borderwidth']}" cellpadding="{$theme['tablespace']}" class="tborder showhide fullwidth">

yusufdj · 01-12-2021, 12:05 AM

Güzel bir paylaşım, ellerine sağlık.

CrawLTR · 01-12-2021, 09:46 PM

Teşekkürler

CrawLTR · 01-12-2021, 09:50 PM

Böyle oldu napmalıyım

**Noah** · 01-12-2021, 11:21 PM

(01-12-2021, 09:50 PM)CrawLTR Wrote:

Böyle oldu napmalıyım

Merhaba @CrawLTR.

Lütfen ayarları doğru yaptığından emin ol. Yorumunu gördükten sonra tekrar test forumuma kurulum yaptım. Herhangi bir sorun yok. Test forumumdaki güncel durum aşağıdaki gibidir:

[Image: 1gj8mI.jpg]

CrawLTR · 01-13-2021, 12:06 AM

Teşekkürler Yaptım.

**Noah** · 01-13-2021, 12:07 AM

(01-13-2021, 12:06 AM)CrawLTR Wrote: Teşekkürler Yaptım.

Rica ederim @CrawLTR. İyi forumlar.

MyBB Eklentisiz Grafikli Forum İstatistikleri

MyBB Eklentisiz Grafikli Forum İstatistikleri

Görünüm (Demo)

Nasıl Yapılır?