|
news TOP10
|
| niukas9 |
parašyta 2008-01-27 07:41
|
Apšylantis
Reputacija:
0
Pranešimai: 71
Įstojo: 2007-05-11
|
kas gali duoti normaliai veikiancia top news panel:) |
| |
|
|
| Nepster |
parašyta 2008-01-27 08:00
|
S.Administratorius
Reputacija:
0
Pranešimai: 670
Įstojo: 2007-01-02
|
 Codeopentable(\"TOP10\");
$supergerasqluzklausa=dbquery(\"select * from {$db_prefix}news order by news_reads desc limit 10\");
while($supergerauzklausadu=dbarray($supergerasqluzklausa)){
echo \"{$supergerauzklausadu['news_subject']}
\";
}
closetable();
bet kas tau tokia panele padarytu...
Redagavo Nepster 2008-01-27 08:32 |
| |
|
|
| niukas9 |
parašyta 2008-01-27 08:27
|
Apšylantis
Reputacija:
0
Pranešimai: 71
Įstojo: 2007-05-11
|
bet kazkodel neveikia ta tavo padaryta panele:) |
| |
|
|
| Nepster |
parašyta 2008-01-27 08:33
|
S.Administratorius
Reputacija:
0
Pranešimai: 670
Įstojo: 2007-01-02
|
vadinasi kitiems veikia tau ne |
| |
|
|
| snaiperis |
parašyta 2008-01-27 08:44
|
Apšylantis
Reputacija:
0
Pranešimai: 83
Įstojo: 2007-10-31
|
Na katik pats dar patikrinau viskas veikia gal tu netaip ka?ka darai.... |
| |
|
|
| niukas9 |
parašyta 2008-01-27 09:08
|
Apšylantis
Reputacija:
0
Pranešimai: 71
Įstojo: 2007-05-11
|
ai aha veikia, ka reikia daryti sitoj triguboj panelej kad nebutu "; gale top albumu paneleje |
| |
|
|
| niukas9 |
parašyta 2008-01-27 09:09
|
Apšylantis
Reputacija:
0
Pranešimai: 71
Įstojo: 2007-05-11
|
va ta panele
echo "
";
openside("TOP10 albumai");
$result = dbquery(
"SELECT tn.*, tc.*, user_id, user_name FROM ".$db_prefix."news tn
LEFT JOIN ".$db_prefix."users tu ON tn.news_name=tu.user_id
LEFT JOIN ".$db_prefix."news_cats tc ON tn.news_cat=tc.news_cat_id
WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")
ORDER BY news_reads DESC LIMIT 0,10"
);
if (dbrows($result) != 0) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['news_subject'], 23);
echo "!['']('".THEME."images/bullet.gif') $itemsubject
\n";
}
} else {
echo "".$locale['004']."\n";}
closeside();
echo " |
";
openside("Naujausia muzika");
$result = dbquery(
"SELECT td.*,tdc.* FROM ".$db_prefix."downloads td
INNER JOIN ".$db_prefix."download_cats tdc ON td.download_cat=tdc.download_cat_id
WHERE ".groupaccess('download_cat_access')." ORDER BY download_datestamp DESC LIMIT 0,10"
);
if (dbrows($result) != 0) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['download_title'], 23);
echo " $itemsubject
\n";
}
} else {
echo "".$locale['004']."\n";
}
closeside();
echo " |
";
openside("Top 10 dainos");
echo "
\n";
$result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_count DESC LIMIT 0,10");
if (dbrows($result) != 0) {
echo "";
while($data = dbarray($result)) {
$itemsubject = trimlink($data['download_title'], 23);
echo "\n| $itemsubject | \n
".$data['download_count']." | \n \n";
}
echo " ";
} else {
echo "".$locale['004']."\n";
}
closeside();
?>
|
"; |
| |
|
|
| snaiperis |
parašyta 2008-01-27 09:11
|
Apšylantis
Reputacija:
0
Pranešimai: 83
Įstojo: 2007-10-31
|
O kas tau blogai neveikia ji tau kitaip... ? |
| |
|
|
| niukas9 |
parašyta 2008-01-27 09:16
|
Apšylantis
Reputacija:
0
Pranešimai: 71
Įstojo: 2007-05-11
|
nu man gale top 10albumai rodo ";
|
| |
|
|
| Sharkman |
parašyta 2008-01-27 10:11
|
Geradarys
Reputacija:
0
Pranešimai: 928
Įstojo: 2007-08-24
|
VA:
Code
echo \"
\";
openside(\"TOP10 albumai\");
$result = dbquery(
\"SELECT tn.*, tc.*, user_id, user_name FROM \".$db_prefix.\"news tn
LEFT JOIN \".$db_prefix.\"users tu ON tn.news_name=tu.user_id
LEFT JOIN \".$db_prefix.\"news_cats tc ON tn.news_cat=tc.news_cat_id
WHERE \".groupaccess('news_visibility').\" AND (news_start='0'||news_start<=\".time().\") AND (news_end='0'||news_end>=\".time().\")
ORDER BY news_reads DESC LIMIT 0,10\"
);
if (dbrows($result) != 0) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['news_subject'], 23);
echo \"!['']('\".THEME.\"images/bullet.gif') $itemsubject
\n\";
}
} else {
echo \"\".$locale['004'].\"\n\";}
closeside();
echo \" |
\";
openside(\"Naujausia muzika\");
$result = dbquery(
\"SELECT td.*,tdc.* FROM \".$db_prefix.\"downloads td
INNER JOIN \".$db_prefix.\"download_cats tdc ON td.download_cat=tdc.download_cat_id
WHERE \".groupaccess('download_cat_access').\" ORDER BY download_datestamp DESC LIMIT 0,10\"
);
if (dbrows($result) != 0) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['download_title'], 23);
echo \" $itemsubject
\n\";
}
} else {
echo \"\".$locale['004'].\"\n\";
}
closeside();
echo \" |
\";
openside(\"Top 10 dainos\");
echo \"
\n\";
$result = dbquery(\"SELECT * FROM \".$db_prefix.\"downloads ORDER BY download_count DESC LIMIT 0,10\");
if (dbrows($result) != 0) {
echo \"\";
while($data = dbarray($result)) {
$itemsubject = trimlink($data['download_title'], 23);
echo \"\n| $itemsubject | \n
\".$data['download_count'].\" | \n \n\";
}
echo \" \";
} else {
echo \"\".$locale['004'].\"\n\";
}
closeside();
?>
echo \" |
\";
|
| |
|
|
| niukas9 |
parašyta 2008-01-27 11:12
|
Apšylantis
Reputacija:
0
Pranešimai: 71
Įstojo: 2007-05-11
|
tai kad vistiek nepranyko:) |
| |
|
|
| niukas9 |
parašyta 2008-01-27 19:08
|
Apšylantis
Reputacija:
0
Pranešimai: 71
Įstojo: 2007-05-11
|
taj padesit kasnors???:D |
| |
|
|
| snapsas |
parašyta 2008-01-27 19:34
|
Geradarys
Reputacija:
0
Pranešimai: 534
Įstojo: 2007-04-09
|
Code opentable(\"TOP10\");
$result = dbquery(\"SELECT * FROM \".$db_prefix.\"news ORDER BY news_reads DESC LIMIT 10\");
if (dbrows($result) != 0) {
$c=1;
while($data = dbarray($result)) {
echo \"$c \".trimlink($data['news_subject'], 20).\"
\";
$c=$c+1;
}
}
closetable();
Redagavo snapsas 2008-01-27 19:38
I'm back. |
| |
|
|
| niukas9 |
parašyta 2008-01-28 12:42
|
Apšylantis
Reputacija:
0
Pranešimai: 71
Įstojo: 2007-05-11
|
na va jau susitvarkiau, o kaip padaryt kad nerodytu kiek sykiu parsiusta sitoje paneleje:
Code openside(\"Top 10\");
echo \"
\n\";
$result = dbquery(\"SELECT * FROM \".$db_prefix.\"downloads ORDER BY download_count DESC LIMIT 0,10\");
if (dbrows($result) != 0) {
echo \"\";
while($data = dbarray($result)) {
$itemsubject = trimlink($data['download_title'], 23);
echo \"\n| $itemsubject | \n
\".$data['download_count'].\" | \n \n\";
}
echo \" \";
} else {
echo \"\".$locale['004'].\"\n\";
}
closeside();
|
| |
|
|
| Paranoja |
parašyta 2008-01-28 12:57
|
Draugas
Reputacija:
0
Pranešimai: 302
Įstojo: 2007-06-12
|
Code openside(\"Top 10\");
echo \"
\n\";
$result = dbquery(\"SELECT * FROM \".$db_prefix.\"downloads ORDER BY download_count DESC LIMIT 0,10\");
if (dbrows($result) != 0) {
echo \"\";
while($data = dbarray($result)) {
$itemsubject = trimlink($data['download_title'], 23);
echo \"\n| $itemsubject | \n
\n \n\";
}
echo \" \";
} else {
echo \"\".$locale['004'].\"\n\";
}
closeside();
|
| |
|
|
| niukas9 |
parašyta 2008-01-28 13:45
|
Apšylantis
Reputacija:
0
Pranešimai: 71
Įstojo: 2007-05-11
|
dekui;);) |
| |
|
