Konu: Günün, haftanın, ayın enleri - php blok  (Okunma sayısı 1360 defa)

0 Üye ve 1 Ziyaretçi konuyu incelemekte.

24 Şubat 2013, 22:42
  • *
    • İleti: 2018
    • Karma: 41
    • Spina Bifida
    • Profili Görüntüle



Demo için tıklayınız...

Aşağıdaki kodlarla php blok oluşturup kullanabilirsiniz.
Kod: [Seç]
  global $smcFunc, $scripturl, $context, $settings;

   // Top 10 Posters so far today
   // Change the time depending on server time offset
   list($year, $month, $day) = explode('-', date('Y-m-d'));
    $starttime = mktime(0, 0, 0, $month, $day, $year);
   // Offset based on forum time
   $starttime = forum_time(false, $starttime);
   
   $request = $smcFunc['db_query']('', '
      SELECT me.id_member, me.real_name, COUNT(*) as count_posts
      FROM {db_prefix}messages AS m
         LEFT JOIN {db_prefix}members AS me ON (me.id_member = m.id_member)
      WHERE m.poster_time > {int:start_time}
         AND m.id_member != 0
      GROUP BY me.id_member
      ORDER BY count_posts DESC
      LIMIT 5',
      array(
         'start_time' => $starttime,
      )
   );
         
   $context['top_posters_day'] = array();
   $max_num_posts = 1;
   while ($row_members = $smcFunc['db_fetch_assoc']($request))
   {
      $context['top_posters_day'][] = array(
         'name' => $row_members['real_name'],
         'id' => $row_members['id_member'],
         'num_posts' => $row_members['count_posts'],
         'href' => $scripturl . '?action=profile;u=' . $row_members['id_member'],
         'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_members['id_member'] . '">' . $row_members['real_name'] . '</a>'
      );

      if ($max_num_posts < $row_members['count_posts'])
         $max_num_posts = $row_members['count_posts'];
   }
   $smcFunc['db_free_result']($request);

   foreach ($context['top_posters_day'] as $i => $j)
      $context['top_posters_day'][$i]['post_percent'] = round(($j['num_posts'] * 100) / $max_num_posts);
   
   // Tidy up
   unset($max_num_posts, $row_members, $j, $i);

   echo '
   <table border="1" width="100%" style="border-collapse: collapse; border-width: 0px">
<tr>
<td style="border-style: none; border-width: medium" width="150">
      <font color=#000000><b> Günün En İyileri:</b></td> <td style="border-style: none; border-width: medium">  <table border="0" cellpadding="1" cellspacing="0" width="100%">
         <tr>
             
             
            </tr>';

   foreach ($context['top_posters_day'] as $poster)
      echo '
            <tr>
', sp_embed_image($user['name'] == 'H' ? 'tux' : 'user'), '&nbsp;', $poster['link'], '&nbsp;&nbsp;&nbsp;[', $poster['num_posts'], ']&nbsp;&nbsp;&nbsp;&nbsp;
            </tr>';
   echo '
         </table></td>
</tr>
</table>
';



   global $smcFunc, $scripturl, $context, $settings;

   // Top 10 Posters so far this week  (starts sunday)
   $starttime = mktime(0, 0, 0, date("n"), date("j"), date("Y")) - (date("N")*3600*24);
   // Offset based on forum time
   $starttime = forum_time(false, $starttime);
   
   $request = $smcFunc['db_query']('', '
      SELECT me.id_member, me.real_name, COUNT(*) as count_posts
      FROM {db_prefix}messages AS m
         LEFT JOIN {db_prefix}members AS me ON (me.id_member = m.id_member)
      WHERE m.poster_time > {int:start_time}
         AND m.id_member != 0
      GROUP BY me.id_member
      ORDER BY count_posts DESC
      LIMIT 5',
      array(
         'start_time' => $starttime,
      )
   );
   
   $context['top_posters_week'] = array();
   $max_num_posts = 1;
   while ($row_members = $smcFunc['db_fetch_assoc']($request))
   {
      $context['top_posters_week'][] = array(
         'name' => $row_members['real_name'],
         'id' => $row_members['id_member'],
         'num_posts' => $row_members['count_posts'],
         'href' => $scripturl . '?action=profile;u=' . $row_members['id_member'],
         'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_members['id_member'] . '">' . $row_members['real_name'] . '</a>'
      );

      if ($max_num_posts < $row_members['count_posts'])
         $max_num_posts = $row_members['count_posts'];
   }
   $smcFunc['db_free_result']($request);

   foreach ($context['top_posters_week'] as $i => $j)
      $context['top_posters_week'][$i]['post_percent'] = round(($j['num_posts'] * 100) / $max_num_posts);

   // Tidy up
   unset($max_num_posts, $row_members, $j, $i);

   echo '
   <table border="1" width="100%" style="border-collapse: collapse; border-width: 0px">
<tr>
<td style="border-style: none; border-width: medium" width="150">
<font color=#000000>   <b> Haftanın En İyileri:</b></font>
</td>
<td style="border-style: none; border-width: medium">
         <table border="0" cellpadding="1" cellspacing="0" width="100%">
              <tr>
             
               
            </tr>';

   foreach ($context['top_posters_week'] as $poster)
      echo '
            <tr>
              ', sp_embed_image($user['name'] == 'H' ? 'tux' : 'user'), '&nbsp;', $poster['link'], ' &nbsp;&nbsp;&nbsp; [', $poster['num_posts'], ']&nbsp;&nbsp;&nbsp;&nbsp;
            </tr>';
   echo '
         </table></td>
</tr>
</table>
';






   global $smcFunc, $scripturl, $context, $settings;

   // Top 10 Posters so far this month  (starts sunday)
   $starttime = mktime(0, 0, 0, date("n"), date("j"), date("Y")) - (3600*24*31);
   // Offset based on forum time
   $starttime = forum_time(false, $starttime);
   
   $request = $smcFunc['db_query']('', '
      SELECT me.id_member, me.real_name, COUNT(*) as count_posts
      FROM {db_prefix}messages AS m
         LEFT JOIN {db_prefix}members AS me ON (me.id_member = m.id_member)
      WHERE m.poster_time > {int:start_time}
         AND m.id_member != 0
      GROUP BY me.id_member
      ORDER BY count_posts DESC
      LIMIT 5',
      array(
         'start_time' => $starttime,
      )
   );
   
   $context['top_posters_month'] = array();
   $max_num_posts = 1;
   while ($row_members = $smcFunc['db_fetch_assoc']($request))
   {
      $context['top_posters_month'][] = array(
         'name' => $row_members['real_name'],
         'id' => $row_members['id_member'],
         'num_posts' => $row_members['count_posts'],
         'href' => $scripturl . '?action=profile;u=' . $row_members['id_member'],
         'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_members['id_member'] . '">' . $row_members['real_name'] . '</a>'
      );

      if ($max_num_posts < $row_members['count_posts'])
         $max_num_posts = $row_members['count_posts'];
   }
   $smcFunc['db_free_result']($request);

   foreach ($context['top_posters_month'] as $i => $j)
      $context['top_posters_month'][$i]['post_percent'] = round(($j['num_posts'] * 100) / $max_num_posts);

   // Tidy up
   unset($max_num_posts, $row_members, $j, $i);

echo '
<table border="1" width="100%" style="border-collapse: collapse; border-width: 0px">
<tr>
<td style="border-style: none; border-width: medium" width="150">
<font color=#000000>    <b> Ayın En İyileri:</b></font> </td>
<td style="border-style: none; border-width: medium">
         <table border="0" cellpadding="1" cellspacing="0" width="100%">
         <tr>

            </tr>';

   foreach ($context['top_posters_month'] as $poster)
      echo '
            <tr >
              ', sp_embed_image($user['name'] == 'H' ? 'tux' : 'user'), '&nbsp;', $poster['link'], '&nbsp;&nbsp;&nbsp;[', $poster['num_posts'], ']&nbsp;&nbsp;&nbsp;&nbsp;
            </tr>';
   echo '
         </table></td>
</tr>
</table>
';

Aşağıdaki resimdeki gibi olsun isteyenler için:



php kod:
Kod: [Seç]
  global $smcFunc, $scripturl, $context, $settings;

   // Top 10 Posters so far today
   // Change the time depending on server time offset
   list($year, $month, $day) = explode('-', date('Y-m-d'));
    $starttime = mktime(0, 0, 0, $month, $day, $year);
   // Offset based on forum time
   $starttime = forum_time(false, $starttime);
   
   $request = $smcFunc['db_query']('', '
      SELECT me.id_member, me.real_name, COUNT(*) as count_posts
      FROM {db_prefix}messages AS m
         LEFT JOIN {db_prefix}members AS me ON (me.id_member = m.id_member)
      WHERE m.poster_time > {int:start_time}
         AND m.id_member != 0
      GROUP BY me.id_member
      ORDER BY count_posts DESC
      LIMIT 5',
      array(
         'start_time' => $starttime,
      )
   );
         
   $context['top_posters_day'] = array();
   $max_num_posts = 1;
   while ($row_members = $smcFunc['db_fetch_assoc']($request))
   {
      $context['top_posters_day'][] = array(
         'name' => $row_members['real_name'],
         'id' => $row_members['id_member'],
         'num_posts' => $row_members['count_posts'],
         'href' => $scripturl . '?action=profile;u=' . $row_members['id_member'],
         'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_members['id_member'] . '">' . $row_members['real_name'] . '</a>'
      );

      if ($max_num_posts < $row_members['count_posts'])
         $max_num_posts = $row_members['count_posts'];
   }
   $smcFunc['db_free_result']($request);

   foreach ($context['top_posters_day'] as $i => $j)
      $context['top_posters_day'][$i]['post_percent'] = round(($j['num_posts'] * 100) / $max_num_posts);
   
   // Tidy up
   unset($max_num_posts, $row_members, $j, $i);
   global $smcFunc, $scripturl, $context, $settings;

   // Top 10 Posters so far this week  (starts sunday)
   $starttime = mktime(0, 0, 0, date("n"), date("j"), date("Y")) - (date("N")*3600*24);
   // Offset based on forum time
   $starttime = forum_time(false, $starttime);
   
   $request = $smcFunc['db_query']('', '
      SELECT me.id_member, me.real_name, COUNT(*) as count_posts
      FROM {db_prefix}messages AS m
         LEFT JOIN {db_prefix}members AS me ON (me.id_member = m.id_member)
      WHERE m.poster_time > {int:start_time}
         AND m.id_member != 0
      GROUP BY me.id_member
      ORDER BY count_posts DESC
      LIMIT 5',
      array(
         'start_time' => $starttime,
      )
   );
   
   $context['top_posters_week'] = array();
   $max_num_posts = 1;
   while ($row_members = $smcFunc['db_fetch_assoc']($request))
   {
      $context['top_posters_week'][] = array(
         'name' => $row_members['real_name'],
         'id' => $row_members['id_member'],
         'num_posts' => $row_members['count_posts'],
         'href' => $scripturl . '?action=profile;u=' . $row_members['id_member'],
         'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_members['id_member'] . '">' . $row_members['real_name'] . '</a>'
      );

      if ($max_num_posts < $row_members['count_posts'])
         $max_num_posts = $row_members['count_posts'];
   }
   $smcFunc['db_free_result']($request);

   foreach ($context['top_posters_week'] as $i => $j)
      $context['top_posters_week'][$i]['post_percent'] = round(($j['num_posts'] * 100) / $max_num_posts);

   // Tidy up
   unset($max_num_posts, $row_members, $j, $i);
      global $smcFunc, $scripturl, $context, $settings;

   // Top 10 Posters so far this month  (starts sunday)
   $starttime = mktime(0, 0, 0, date("n"), date("j"), date("Y")) - (3600*24*31);
   // Offset based on forum time
   $starttime = forum_time(false, $starttime);
   
   $request = $smcFunc['db_query']('', '
      SELECT me.id_member, me.real_name, COUNT(*) as count_posts
      FROM {db_prefix}messages AS m LEFT JOIN {db_prefix}members AS me ON (me.id_member = m.id_member)
      WHERE m.poster_time > {int:start_time}
         AND m.id_member != 0
      GROUP BY me.id_member
      ORDER BY count_posts DESC
      LIMIT 5',
      array(
         'start_time' => $starttime,
      )
   );
   
   $context['top_posters_month'] = array();
   $max_num_posts = 1;
   while ($row_members = $smcFunc['db_fetch_assoc']($request))
   {
      $context['top_posters_month'][] = array(
         'name' => $row_members['real_name'],
         'id' => $row_members['id_member'],
         'num_posts' => $row_members['count_posts'],
         'href' => $scripturl . '?action=profile;u=' . $row_members['id_member'],
         'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_members['id_member'] . '">' . $row_members['real_name'] . '</a>'
      );

      if ($max_num_posts < $row_members['count_posts'])
         $max_num_posts = $row_members['count_posts'];
   }
   $smcFunc['db_free_result']($request);

   foreach ($context['top_posters_month'] as $i => $j)
      $context['top_posters_month'][$i]['post_percent'] = round(($j['num_posts'] * 100) / $max_num_posts);

   // Tidy up
   unset($max_num_posts, $row_members, $j, $i);

   echo '


<table border="1" width="100%" style="border-collapse: collapse; border-width: 0px">
<tr>
<td style="border-style: none; border-width: medium">   <table border="1" width="100%" style="border-collapse: collapse; border-width: 0px">
<tr>
<td style="border-style: none; border-width: medium" width="100" align="right">
     <img border="0" src="http://www.spinabifidaturkey.com/images/makale/gununen.gif" width="75" height="98"></td> <td style="border-style: none; border-width: medium">  <table border="0" cellpadding="1" cellspacing="0" width="100%">
';

   foreach ($context['top_posters_day'] as $poster)
      echo '
            <tr>
<div>', sp_embed_image($user['name'] == 'H' ? 'tux' : 'user'), ' ', $poster['link'], '   [', $poster['num_posts'], ']</div>
            </tr>';
   echo '
         </table></td>
</tr>
</table></td>
<td style="border-style: none; border-width: medium">   <table border="1" width="100%" style="border-collapse: collapse; border-width: 0px">
<tr>
<td style="border-style: none; border-width: medium" width="100" align="right">
<img border="0" src="http://www.spinabifidaturkey.com/images/makale/haftaninen.gif" width="75" height="98">
</td>
<td style="border-style: none; border-width: medium">
         <table border="0" cellpadding="1" cellspacing="0" width="100%">
';

   foreach ($context['top_posters_week'] as $poster)
      echo '
            <tr>
              <div>', sp_embed_image($user['name'] == 'H' ? 'tux' : 'user'), ' ', $poster['link'], '     [', $poster['num_posts'], ']</div>
            </tr>';
   echo '
         </table></td>
</tr>
</table>
</td>
<td style="border-style: none; border-width: medium"><table border="1" width="100%" style="border-collapse: collapse; border-width: 0px">
<tr>
<td style="border-style: none; border-width: medium" width="100" align="right">
<img border="0" src="http://www.spinabifidaturkey.com/images/makale/ayinen.gif" width="75" height="98"> </td>
<td style="border-style: none; border-width: medium">
         <table border="0" cellpadding="1" cellspacing="0" width="100%">
';

   foreach ($context['top_posters_month'] as $poster)
      echo '
            <tr >
             <div> ', sp_embed_image($user['name'] == 'H' ? 'tux' : 'user'), ' ', $poster['link'], '   [', $poster['num_posts'], ']</div>
            </tr>';
   echo '
         </table></td>
</tr>
</table></td>
</tr>
</table>';

css kodlaması için blok görüntüleme seçeneklerinden aşağıdakileri yapıp:

Tanımlı İçerik Sınıfı: information
Özel içerik sınıfı: en

index.css şunun altına:
Kod: [Seç]
.information
{
padding: 0.5em 1em;
font-size: 0.9em;
line-height: 1.3em;
border: 1px solid #003c74;
background: #f5f5f5;
margin: 0.2em 1px 1em 1px;
}

Şunu ekleyin:
Kod: [Seç]
.en
{
padding: 0.5em 1em;
font-size: 0.9em;
line-height: 1.3em;
border: 1px solid #003c74;
background: #ffffff;
margin: 0.2em 1px 1em 1px;
}


19 Aralık 2013, 21:54
Yanıtla #1
  • *
    • İleti: 95
    • Karma: 2
    • Flatcast Destek Türkce Destek Sitesi
    • Profili Görüntüle

slm hocam altda verdım resım  suankı senın konudan ekledım foruma portala ama  bu sekılde cıkıyor    onun altındakı resım gıbı   uye yanıındakı sayıları daha duzenlı olmasını  istıyordum  nasıl yaparız ??


duzenli görunum


19 Aralık 2013, 22:53
Yanıtla #2
  • *
    • İleti: 273
    • Karma: 1
    • Diyabeturkey
    • Profili Görüntüle

tema index.css ye kodları ekle düzelir.


19 Aralık 2013, 23:15
Yanıtla #3
  • *
    • İleti: 95
    • Karma: 2
    • Flatcast Destek Türkce Destek Sitesi
    • Profili Görüntüle

tskler  cözdum normal gunun ayın  en iyileri modundaki BoardIndex.template.php en alta  ekliyecemiz kodu ben  direk  portal php icerikten ekledim   css ye gerek kalmadi yani


13 Ağustos 2014, 04:50
Yanıtla #4
  • *
    • İleti: 51
    • Karma: 0
    • Adalet Kılıcı Herkesi Kesmeli
    • http://www.dinogretmeni.com/
    • Profili Görüntüle

Hocam aşağıdaki hataları veriyor bu konuda ne yapabiliriz.
Yardımcı olursanız memnun olurum.


29 Eylül 2014, 00:44
Yanıtla #5
  • *
    • İleti: 331
    • Karma: 17
    • haksever,huutheme
    • haksever
    • Profili Görüntüle

Abi bunu konulara uygulayabilirmiyiz ? haftanın en konuları ayın en konuları ? birşeyler yapmaya calıstım ama pek olduğunu sanmıyorum.


29 Eylül 2014, 01:58
Yanıtla #6
  • *
    • İleti: 2018
    • Karma: 41
    • Spina Bifida
    • Profili Görüntüle

Bu aralar ilgilenebilecek vaktim yok. Gün gelir yaparsam ayrıca paylaşırım.


29 Eylül 2014, 14:20
Yanıtla #7
  • *
    • İleti: 331
    • Karma: 17
    • haksever,huutheme
    • haksever
    • Profili Görüntüle