SimplePortal

Support => International Support => Turkish (Türkçe) => Topic started by: sayfam on April 03, 2009, 11:50:11 AM

Title: Bloklara Download System istatistikleri ekleme
Post by: sayfam on April 03, 2009, 11:50:11 AM

Yeni sürümde gelir  diye ummuştum ama göremedim..Bloklara downloads modunu (http://custom.simplemachines.org/mods/index.php?mod=992) nasıl yerleştireceğiz?
örneğin;
son yüklenen 10 dosya
en çok indirilen 10 dosya
bu arada 2.0 rc1+sp2.2

teşekkürler...

Title: Re: Bloklara Download System istatistikleri ekleme
Post by: grafitus on April 04, 2009, 05:43:22 AM

Code: (Smf 1.1.8 içindir.Yaz??z çevirsin bi zahmet 2.0a :)) [Select]

global $db_prefix, $scripturl;

$request = db_query("SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.title AS ftitle, f.totaldownloads,
c.title, m.realName, m.ID_MEMBER AS mID_MEMBER
FROM {$db_prefix}down_file AS f, {$db_prefix}down_cat AS c, {$db_prefix}members AS m
WHERE f.ID_CAT = c.ID_CAT
AND f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY f.ID_FILE DESC
LIMIT 10",__FILE__,__LINE__);
while($row = mysql_fetch_assoc($request)) {
echo '<table width="100%" cellpadding="2" cellspacing="0">
<tr>
<td valign="top" class="smalltext"> <a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'">',$row['ftitle'],'</a></td>
<td valign="top" class="smalltext" align="right">',$row['totaldownloads'],'</td>
</tr>
</table>';
}


$request = db_query("SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.title AS ftitle, f.totaldownloads,
c.title, m.realName, m.ID_MEMBER AS mID_MEMBER
FROM {$db_prefix}down_file AS f, {$db_prefix}down_cat AS c, {$db_prefix}members AS m
WHERE f.ID_CAT = c.ID_CAT
AND f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY totaldownloads DESC
LIMIT 35",__FILE__,__LINE__);
while($row = mysql_fetch_assoc($request)) {
echo '<table width="100%" cellpadding="2" cellspacing="0">
<tr>
<td valign="top" class="smalltext"> <a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'">',$row['ftitle'],'</a></td>
<td valign="top" class="smalltext" align="right">',$row['totaldownloads'],'</td>
</tr>
</table>';
}
[code]

[url=http://www.simplemachines.org/community/index.php?topic=240522.msg1621844#msg1621844]Orjinal Konu[/url]

Title: Re: Bloklara Download System istatistikleri ekleme
Post by: Yağız... on April 04, 2009, 05:52:43 AM

Code: [Select]

global $smcFunc, $scripturl;
$request = $smcFunc['db_query']('', '
SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.title AS ftitle, f.totaldownloads,
c.title, m.real_name, m.id_member AS mID_MEMBER
FROM {db_prefix}down_file AS f, {db_prefix}down_cat AS c, {db_prefix}members AS m
WHERE f.ID_CAT = c.ID_CAT
AND f.approved = {int:approved}
AND f.ID_MEMBER = m.id_member
ORDER BY f.ID_FILE DESC
LIMIT 10',
array(
'approved' => '1',
)
);
while($row = $smcFunc['db_fetch_assoc']($request))
{
echo '
<table width="100%" cellpadding="2" cellspacing="0">
<tr>
<td valign="top" class="smalltext"> <a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'">',$row['ftitle'],'</a></td>
<td valign="top" class="smalltext" align="right">',$row['totaldownloads'],'</td>
</tr>
</table>';
}

$request = $smcFunc['db_query']('', '
SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.title AS ftitle, f.totaldownloads,
c.title, m.real_name, m.id_member AS mID_MEMBER
FROM {db_prefix}down_file AS f, {db_prefix}down_cat AS c, {db_prefix}members AS m
WHERE f.ID_CAT = c.ID_CAT
AND f.approved = {int:approved}
AND f.ID_MEMBER = m.id_member
ORDER BY totaldownloads DESC
LIMIT 35',
array(
'approved' => '1',
)
);
while($row = $smcFunc['db_fetch_assoc']($request))
{
echo '
<table width="100%" cellpadding="2" cellspacing="0">
<tr>
<td valign="top" class="smalltext"> <a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'">',$row['ftitle'],'</a></td>
<td valign="top" class="smalltext" align="right">',$row['totaldownloads'],'</td>
</tr>
</table>';
}E?er çal??mazsa bunu deneyin:

Code: [Select]

global $smcFunc, $scripturl;
$request = $smcFunc['db_query']('', '
SELECT f.id_file, f.id_member, f.date, f.id_cat, f.title AS ftitle, f.totaldownloads,
c.title, m.real_name, m.id_member AS mID_MEMBER
FROM {db_prefix}down_file AS f, {db_prefix}down_cat AS c, {db_prefix}members AS m
WHERE f.id_cat = c.id_cat
AND f.approved = {int:approved}
AND f.id_member = m.id_member
ORDER BY f.id_file DESC
LIMIT 10',
array(
'approved' => '1',
)
);
while($row = $smcFunc['db_fetch_assoc']($request))
{
echo '
<table width="100%" cellpadding="2" cellspacing="0">
<tr>
<td valign="top" class="smalltext"> <a href="',$scripturl,'?action=downloads;sa=view;id=',$row['id_file'],'">',$row['ftitle'],'</a></td>
<td valign="top" class="smalltext" align="right">',$row['totaldownloads'],'</td>
</tr>
</table>';
}

$request = $smcFunc['db_query']('', '
SELECT f.id_file, f.id_member, f.date, f.id_cat, f.title AS ftitle, f.totaldownloads,
c.title, m.real_name, m.id_member AS mID_MEMBER
FROM {db_prefix}down_file AS f, {db_prefix}down_cat AS c, {db_prefix}members AS m
WHERE f.id_cat = c.id_cat
AND f.approved = {int:approved}
AND f.id_member = m.id_member
ORDER BY totaldownloads DESC
LIMIT 35',
array(
'approved' => '1',
)
);
while($row = $smcFunc['db_fetch_assoc']($request))
{
echo '
<table width="100%" cellpadding="2" cellspacing="0">
<tr>
<td valign="top" class="smalltext"> <a href="',$scripturl,'?action=downloads;sa=view;id=',$row['id_file'],'">',$row['ftitle'],'</a></td>
<td valign="top" class="smalltext" align="right">',$row['totaldownloads'],'</td>
</tr>
</table>';
}

Title: Re: Bloklara Download System istatistikleri ekleme
Post by: sayfam on April 09, 2009, 04:48:52 PM

Te?ekkürler Ya??z. Kodlar? düzenleyip ihtiyac? olanlar için çal???r vaziyette a?a??ya koyuyorum.

Son Yüklenen Dosyalar:

Code: [Select]

global $smcFunc, $scripturl;
$request = $smcFunc['db_query']('', '
      SELECT f.id_file, f.id_member, f.date, f.id_cat, f.title AS ftitle, f.totaldownloads,
         c.title, m.real_name, m.id_member AS mID_MEMBER
      FROM {db_prefix}down_file AS f, {db_prefix}down_cat AS c, {db_prefix}members AS m
      WHERE f.id_cat = c.id_cat
         AND f.approved = {int:approved}
         AND f.id_member = m.id_member
      ORDER BY f.id_file DESC
      LIMIT 10',
      array(
         'approved' => '1',
      )
);
while($row = $smcFunc['db_fetch_assoc']($request))
{
echo '
   <table width="100%" cellpadding="2" cellspacing="0">
      <tr>
         <td valign="top" class="smalltext"> <a href="',$scripturl,'?action=downloads;sa=view;id=',$row['id_file'],'">',$row['ftitle'],'</a></td>
         <td valign="top" class="smalltext" align="right">',$row['totaldownloads'],'</td>
      </tr>
   </table>';
}

En Çok ?ndirilen Dosyalar:

Code: [Select]

global $smcFunc, $scripturl;
$request = $smcFunc['db_query']('', '
      SELECT f.id_file, f.id_member, f.date, f.id_cat, f.title AS ftitle, f.totaldownloads,
         c.title, m.real_name, m.id_member AS mID_MEMBER
      FROM {db_prefix}down_file AS f, {db_prefix}down_cat AS c, {db_prefix}members AS m
      WHERE f.id_cat = c.id_cat
         AND f.approved = {int:approved}
         AND f.id_member = m.id_member
      ORDER BY totaldownloads DESC
      LIMIT 10',
      array(
         'approved' => '1',
      )
);
while($row = $smcFunc['db_fetch_assoc']($request))
{
echo '
   <table width="100%" cellpadding="2" cellspacing="0">
      <tr>
         <td valign="top" class="smalltext"> <a href="',$scripturl,'?action=downloads;sa=view;id=',$row['id_file'],'">',$row['ftitle'],'</a></td>
         <td valign="top" class="smalltext" align="right">',$row['totaldownloads'],'</td>
      </tr>
   </table>';
}

Title: Re: Bloklara Download System istatistikleri ekleme
Post by: sayfam on April 09, 2009, 04:50:35 PM

Bu arada dosya adlarının alt satıra geçmemesi için karakter sınırlaması yapabilir miyiz?

Title: Re: Bloklara Download System istatistikleri ekleme
Post by: Daydreamer on April 12, 2009, 08:17:33 AM

bul

Code: [Select]

',$row['ftitle'],'De?i?tir

Code: [Select]

',shorten_subject($row['ftitle'], 15),'
15 yerine kendine göre say? koy. Ama bunu yap?nca dosya isminin bir k?sm? silinecektir dolay?s?yla üzerine gelince dosya ad?n?n?n tamam?n?n ç?kmas?n? sa?laman laz?m. Onuda ?unu de?i?tirerek yapacaks?n
bul
<a href="',$scripturl,'?action=downloads;sa=view;id=',$row['id_file'],'">
de?i?tir
<a href="',$scripturl,'?action=downloads;sa=view;id=',$row['id_file'],'" title="',$row['ftitle'],'">

Title: Re: Bloklara Download System istatistikleri ekleme
Post by: Gurbet_42 on June 03, 2009, 03:57:10 PM

Quote from: sayfam on April 09, 2009, 04:48:52 PM

Teşekkürler Yağız. Kodları düzenleyip ihtiyacı olanlar için çalışır vaziyette aşağıya koyuyorum.

Son Yüklenen Dosyalar:

Code: [Select]

global $smcFunc, $scripturl;
$request = $smcFunc['db_query']('', '
      SELECT f.id_file, f.id_member, f.date, f.id_cat, f.title AS ftitle, f.totaldownloads,
         c.title, m.real_name, m.id_member AS mID_MEMBER
      FROM {db_prefix}down_file AS f, {db_prefix}down_cat AS c, {db_prefix}members AS m
      WHERE f.id_cat = c.id_cat
         AND f.approved = {int:approved}
         AND f.id_member = m.id_member
      ORDER BY f.id_file DESC
      LIMIT 10',
      array(
         'approved' => '1',
      )
);
while($row = $smcFunc['db_fetch_assoc']($request))
{
echo '
   <table width="100%" cellpadding="2" cellspacing="0">
      <tr>
         <td valign="top" class="smalltext"> <a href="',$scripturl,'?action=downloads;sa=view;id=',$row['id_file'],'">',$row['ftitle'],'</a></td>
         <td valign="top" class="smalltext" align="right">',$row['totaldownloads'],'</td>
      </tr>
   </table>';
}

En Çok İndirilen Dosyalar:

Code: [Select]

global $smcFunc, $scripturl;
$request = $smcFunc['db_query']('', '
      SELECT f.id_file, f.id_member, f.date, f.id_cat, f.title AS ftitle, f.totaldownloads,
         c.title, m.real_name, m.id_member AS mID_MEMBER
      FROM {db_prefix}down_file AS f, {db_prefix}down_cat AS c, {db_prefix}members AS m
      WHERE f.id_cat = c.id_cat
         AND f.approved = {int:approved}
         AND f.id_member = m.id_member
      ORDER BY totaldownloads DESC
      LIMIT 10',
      array(
         'approved' => '1',
      )
);
while($row = $smcFunc['db_fetch_assoc']($request))
{
echo '
   <table width="100%" cellpadding="2" cellspacing="0">
      <tr>
         <td valign="top" class="smalltext"> <a href="',$scripturl,'?action=downloads;sa=view;id=',$row['id_file'],'">',$row['ftitle'],'</a></td>
         <td valign="top" class="smalltext" align="right">',$row['totaldownloads'],'</td>
      </tr>
   </table>';
}

Arkadaşlar ikisinde de portalın düzeni bozuluyor...

Title: Re: Bloklara Download System istatistikleri ekleme
Post by: Gurbet_42 on June 03, 2009, 04:09:58 PM

Fussilet'in aşagıda verdigi kodla son eklenen dosyalar ve indirme sayısı gösteriyor.

Code: [Select]

global $db_prefix, $scripturl;

$request = db_query("SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.title AS ftitle, f.totaldownloads,
c.title, m.realName, m.ID_MEMBER AS mID_MEMBER
FROM {$db_prefix}down_file AS f, {$db_prefix}down_cat AS c, {$db_prefix}members AS m
WHERE f.ID_CAT = c.ID_CAT
AND f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY f.ID_FILE DESC
LIMIT 35",__FILE__,__LINE__);
while($row = mysql_fetch_assoc($request)) {
echo '<table width="100%" cellpadding="2" cellspacing="0">
<tr>
<td valign="top" class="smalltext"> <a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'">',$row['ftitle'],'</a></td>
<td valign="top" class="smalltext" align="right">',$row['totaldownloads'],'</td>
</tr>
</table>';
}

Title: Re: Bloklara Download System istatistikleri ekleme
Post by: Gurbet_42 on June 03, 2009, 04:14:42 PM

Buda popülar dasyalar blok

Code: [Select]

global $db_prefix, $scripturl;

$request = db_query("SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.title AS ftitle, f.totaldownloads,
c.title, m.realName, m.ID_MEMBER AS mID_MEMBER
FROM {$db_prefix}down_file AS f, {$db_prefix}down_cat AS c, {$db_prefix}members AS m
WHERE f.ID_CAT = c.ID_CAT
AND f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY totaldownloads DESC
LIMIT 35",__FILE__,__LINE__);
while($row = mysql_fetch_assoc($request)) {
echo '<table width="100%" cellpadding="2" cellspacing="0">
<tr>
<td valign="top" class="smalltext"> <a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'">',$row['ftitle'],'</a></td>
<td valign="top" class="smalltext" align="right">',$row['totaldownloads'],'</td>
</tr>
</table>';
}

Title: Re: Bloklara Download System istatistikleri ekleme
Post by: Gurbet_42 on June 03, 2009, 04:16:32 PM

Özgür aynı hatayı verdi.Fussilet kodu çalışıyor şu anda.

Title: Re: Bloklara Download System istatistikleri ekleme
Post by: Daydreamer on June 03, 2009, 04:17:12 PM

Quote from: Gurbet_42 on June 03, 2009, 04:16:32 PM

Özgür aynı hatayı verdi.Fussilet kodu çalışıyor şu anda.

Hata nedir tam olarak?

Title: Re: Bloklara Download System istatistikleri ekleme
Post by: Daydreamer on June 03, 2009, 04:31:21 PM

E zaten sen 1.1.x kullanıyorsun verdiğim kod 2.0 içindi.
Benim verdiğim kodun 1.1.x deki hali şu şekilde olmalı

Code: [Select]

global $db_prefix, $scripturl;

$request = db_query("SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.title AS ftitle, f.totaldownloads,
c.title, m.realName, m.ID_MEMBER AS mID_MEMBER
FROM {$db_prefix}down_file AS f, {$db_prefix}down_cat AS c, {$db_prefix}members AS m
WHERE f.ID_CAT = c.ID_CAT
AND f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY f.ID_FILE DESC
LIMIT 35",__FILE__,__LINE__);
while($row = mysql_fetch_assoc($request))
echo'<ul class="sp_list">';
{
echo '<li>', sp_embed_image('dot'), '<a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'">',$row['ftitle'],'</a> | ',$row['totaldownloads'],'</li>';
}
echo'</ul>';

Title: Re: Bloklara Download System istatistikleri ekleme
Post by: Gurbet_42 on June 03, 2009, 04:40:36 PM

Özgür eksik oldu galiba

(http://i44.tinypic.com/o0ntrk.png)


Fussilet'in verdigi

(http://i39.tinypic.com/2cy066p.png)

bunun önüne küçük resim eklenirse yeterli.

Nokta resimini nasıl eklerim?

Title: Re: Bloklara Download System istatistikleri ekleme
Post by: Daydreamer on June 03, 2009, 05:33:23 PM

Code: [Select]

', sp_embed_image('dot'), ' bu o imajı çağırmalı.

Code: [Select]

<a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'"> kodunun hemen önüne eklersen eklenmiş olur.

Title: Re: Bloklara Download System istatistikleri ekleme
Post by: Gurbet_42 on June 03, 2009, 05:39:57 PM

Teşekkürler oldu.