Author Topic: Bloklara Download System istatistikleri ekleme (Read 6971 times)

sayfam · « **on:** April 03, 2009, 11:50:11 AM »

Yeni sürümde gelir diye ummuştum ama göremedim..Bloklara downloads modunu 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...

grafitus · « **Reply #1 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]

Yağız... · « **Reply #2 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>';
}

sayfam · « **Reply #3 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>';
}

sayfam · « **Reply #4 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?

Daydreamer · « **Reply #5 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'],'">

Gurbet_42 · « **Reply #6 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...

Gurbet_42 · « **Reply #7 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>';
}

Gurbet_42 · « **Reply #8 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>';
}

Gurbet_42 · « **Reply #9 on:** June 03, 2009, 04:16:32 PM »

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

Daydreamer · « **Reply #10 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?

Daydreamer · « **Reply #11 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>';

Gurbet_42 · « **Reply #12 on:** June 03, 2009, 04:40:36 PM »

Özgür eksik oldu galiba

Fussilet'in verdigi

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

Nokta resimini nasıl eklerim?

Daydreamer · « **Reply #13 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.

Gurbet_42 · « **Reply #14 on:** June 03, 2009, 05:39:57 PM »

Teşekkürler oldu.

Simple Portal Archived Forum

User Info

Who's Online

Sohbet Kutusu

Team Blog

Recent Posts

Author Topic: Bloklara Download System istatistikleri ekleme (Read 6971 times)

sayfam

Bloklara Download System istatistikleri ekleme

grafitus

Re: Bloklara Download System istatistikleri ekleme

Yağız...

Re: Bloklara Download System istatistikleri ekleme

sayfam

Re: Bloklara Download System istatistikleri ekleme

sayfam

Re: Bloklara Download System istatistikleri ekleme

Daydreamer

Re: Bloklara Download System istatistikleri ekleme

Gurbet_42

Re: Bloklara Download System istatistikleri ekleme

Gurbet_42

Re: Bloklara Download System istatistikleri ekleme

Gurbet_42

Re: Bloklara Download System istatistikleri ekleme

Gurbet_42

Re: Bloklara Download System istatistikleri ekleme

Daydreamer

Re: Bloklara Download System istatistikleri ekleme

Daydreamer

Re: Bloklara Download System istatistikleri ekleme

Gurbet_42

Re: Bloklara Download System istatistikleri ekleme

Daydreamer

Re: Bloklara Download System istatistikleri ekleme

Gurbet_42

Re: Bloklara Download System istatistikleri ekleme