Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: Atvaizduoja nario pateiktas dainas
Parašė SysRq· 2012 Sau. 6 16:01:29
#1
Sveiki nariai, norėjau paprašyti pagalbos su kodu. Kodas dedasi į profile.php failą. Jis turėtų atvaizduoti kokias žmogus įkėlęs dainas. Žmogų atpažysta nuo Licenze laukelio esančio submit.php faile. Kodas:
$result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_license='".$data['user_name']."' ORDER BY download_datestamp DESC LIMIT 0,20");
if (dbrows($result) !=0) {
opentable("Naujausia <b>".$data['user_name']."</b> ikelta muzika");
while ($data = dbarray($result)) {
$pavadinimas = trimlink($data['download_title'], 60);
echo"<table cellpadding='0' cellspacing='0' width='100%'><tr>";
echo"<a href='".FUSION_SELF."?cat_id=$cat_id&download_id=".$data['download_id']."' target='_blank' style='font-size:11px; tetx-align:left;'>".$pavadinimas."</a><br>";
echo"
</tr></table>";
}
closetable();
} else {echo"Narys dar neikele muzikos"; }
Tačiau šis kodas atvaziduoja net ne tokias dainas, gal padėsit išspręst kur šaknys?
Redagavo SysRq· 2012 Sau. 6 16:01:07
Parašė Kižas· 2012 Sau. 6 16:01:21
#2
Pagal mane tai tikrai ne taip turėtų būti
WHERE download_license='"
download_license keisk į savo downloads.php faile esantį kintamąjį
Parašė SysRq· 2012 Sau. 6 17:01:03
#3
Na nerandu aš to kintamojo.. Suprantu jog turi būti $kintamojo_pavadinimas kuris būtų download_license... Štai mano downloads.php
<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2011 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: articles.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "maincore.php";
require_once THEMES."templates/header.php";
include LOCALE.LOCALESET."downloads.php";
add_to_title($locale['global_200'].$locale['400']);
function nuoroda($url) {
$search = array("ą", "č", "ę", "ė", "į", "š", "ų", "ū", "ž");
$replace = array("a", "c", "e", "e", "i", "s", "u", "u", "z");
$url = str_replace($search, $replace, $url);
return $url;
}
function zip($urla) {
if(!preg_match('/locale/i', $urla)) {$idx = explode('/', $urla); $idx=$idx[4]; } else {$idx = explode('=', $urla);
$idx=$idx[2]; }
$urla = explode('.', $urla);
$urla = str_replace('http://www', '', $urla['0']);
return "<script type='text/javascript'>var zippywww='www".$urla."';var zippyfile='".$idx."';var zippydown='ffffff';var zippyfront='000000';var zippyback='ffffff';var zippylight='000000';var zippywidth=480;var zippyauto=false;var zippyvol=80;var zippydwnbtn = 0;</script><script type='text/javascript' src='http://api.zippyshare.com/api/embed.js'></script>";
}
if (isset($_GET['download_id']) && isnum($_GET['download_id'])) {
$res = 0;
if ($data = dbarray(dbquery("SELECT download_url,download_cat FROM ".$db_prefix."downloads WHERE download_id='".$_GET['download_id']."'"))) {
$cdata = dbarray(dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id='".$data['download_cat']."'"));
if (checkgroup($cdata['download_cat_access'])) {
$res = 1;
$result = dbquery("UPDATE ".$db_prefix."downloads SET download_count=download_count+1 WHERE download_id='".$_GET['download_id']."'");
redirect($data['download_url']);
}
}
if ($res == 0) redirect("downloads.php");
}
if (isset($_GET['d_id']) && isnum($_GET['d_id'])) {
$numrows = dbrows($result);
include INCLUDES."ratings_include.php";
include INCLUDES."comments_include.php";
$result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_id='".$_GET['d_id']."'");
while ($data = dbarray($result)) {
$id = $data['download_cat'];
if ($data['download_datestamp']+604800 > time()+($settings['timeoffset']*3600)) {
$new = " <span class='small'>".$locale['410']."</span>";
} else {
$new = "";
}
$time = $data['download_datestamp'];
$laikas = showdate( "%d.%m.%y", $time);
$kat = dbresult(dbquery("SELECT download_cat_name FROM ".$db_prefix."download_cats WHERE download_cat_id='$id'"), 0);
echo "<table width='100%' cellpadding='0' cellspacing='1' class='tbl-border'>\n";
echo "<tr>
<td colspan='5' class='forum-caption'>
<table style='border-collapse: collapse;' border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td> <a href='".FUSION_SELF."' class='small' title='Siuntiniai'><b>Siuntiniai</b></a> >> <a href='".FUSION_SELF."?cat_id=".$data['download_cat']."' class='small' title='Siuntinio Kategorija'><b>$kat</b></a> > <a class='small' href='".FUSION_SELF."?cat_id=".$data['download_cat']."&download_id=".$data['download_id']."' title='Atsisiųsti Siuntinį'><b>".$data['download_title']."</b></a> </td>
<td align='right'><span class='small2'><b>Pridėtas:</b> $laikas</span></td>
</tr></table></td>
</tr>\n";
echo "<tr>\n
<td colspan='5' class='tbl1'>";
echo zip($data['download_url']);
echo "</td>\n</tr>\n";
echo "<tr>\n
<td rowspan='2' class='tbl1' align='center' valign='middle' width='1%'><a class='small' href='".FUSION_SELF."?cat_id=".$data['download_cat']."&download_id=".$data['download_id']."' title='Atsisiųsti Failą' style='font-weight: bold;'><img src='".IMAGES."download.png' alt='Atsisiųsti Failą' border='0'></a></td>
<td width='30%' class='tbl1'><b>".$locale['411']."</b> ".$data['download_license']."</td>\n";
$kom = dbquery("SELECT count(comment_id) FROM ".$db_prefix."comments WHERE comment_type='D' AND comment_item_id='$id'");
$kon = dbresult($kom, 0);
if ($kon == 0) { $komentarai = 0; } else { $komentarai = $kon; }
echo "<td width='40%' class='tbl2'><b>Komentarai:</b> $komentarai</td>\n</tr>\n<tr>\n";
echo "<td width='30%' class='tbl1'><b>".$locale['415']."</b> ".$data['download_count']."</td>\n<td width='40%' class='tbl2'><b>Dydis:</b> ".($data['download_filesize'] ? "".$data['download_filesize']."" : "Nėra")."</td>\n</tr>\n";
echo "</table>\n";
if ($i != $numrows) { echo "<div align='center'><img src='".THEME."images/blank.gif' alt='' height='15' width='1'></div>\n"; $i++; }
}
showcomments("D", DB_DOWNLOADS, "download_id", $_GET['d_id'], FUSION_SELF."?d_id=".$_GET['d_id']."");
showratings("D", $_GET['d_id'], FUSION_SELF."?d_id=".$_GET['d_id']."");
} elseif (!isset($_GET['cat_id']) || !isnum($_GET['cat_id'])) {
opentable($locale['400']);
$result = dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE ".groupaccess('download_cat_access')." ORDER BY download_cat_name");
$rows = dbrows($result);
if ($rows != 0) {
$counter = 0; $columns = 2;
echo "<center><img src='".IMAGES."downloads.png' alt='' border='0'></center>";
echo "<table class='tbl-border' style='margin-top: 10px;' cellpadding='0' cellspacing='1' width='100%' align='center'>";
echo "<tr>
<td class='tbl1' colspan='2' align='center'>
<form name='searchform' method='post' action='search.php' style='display: inline;'>
<b>Ieškoti Siuntinių:</b> <input name='stext' class='textbox' style='width: 200px;' type='text'>
<input name='stype' value='d' type='hidden'><input name='search' value='Ieškoti!' class='button' type='submit'>
</form>
</td>
</tr>";
while ($data = dbarray($result)) {
$num = dbcount("(download_cat)", DB_PREFIX."downloads", "download_cat='".$data['download_cat_id']."'");
echo "<tr>
<td class='tbl1' width='1%'><a class='small' href='".FUSION_SELF."?cat_id=".$data['download_cat_id']."' style='font-weight: bold;'>";
$imgname = strtolower(str_replace(" ","_",nuoroda($data['download_cat_name'])));
if (file_exists(IMAGES."dl_cats/".$imgname.".png")) {
$c_img = "<img src='".IMAGES."dl_cats/".$imgname.".png' border='0' alt='".$data['download_cat_name']."' /> \n";
} else {
$c_img = "<img src='".IMAGES."dl_cats/0.png' border='0' alt='".$data['download_cat_name']."' /> \n";
}
echo $c_img;
echo "</a></td>
<td class='tbl2' align='left' valign='center'><img src='".THEME."images/bullet.gif' alt='' border='0'>
<a class='small' href='".FUSION_SELF."?cat_id=".$data['download_cat_id']."' style='font-weight: bold;'>".$data['download_cat_name']."</a> <span class='small2'>($num)</span><br>
<span class='small'>".$data['download_cat_description']."</span></td>
</tr>";
$counter++;
}
echo "<table class='tbl-border' style='margin-top: 10px;' cellpadding='0' cellspacing='1' width='100%'>
<tr>
<td class='forum-caption' colspan='2' width='1%'>Statistika</td>
</tr>
<tr>
<td class='tbl1' align='center' width='1%'><img src='images/dl_stats.png' alt='Siuntinių statistika' border='0'></td>
<td class='tbl2'>
<table border='0' cellpadding='0' cellspacing='1'>";
$dataq = dbarray(dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_id DESC LIMIT 0,1"));
echo "<tr><td>Naujausias siuntinys: </td>
<td> <a class='small' href='".FUSION_SELF."?d_id=".$dataq['download_id']."' title=''>".$dataq['download_title']."</a></td>
</tr>";
$datax = dbarray(dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_count DESC LIMIT 0,1"));
echo "<tr><td>Populiariausias: </td>
<td> <a class='small' href='".FUSION_SELF."?d_id=".$datax['download_id']."' title=''>".$datax['download_title']."</a></td>
</tr>";
$cats = dbresult(dbquery("SELECT count(download_cat_id) FROM ".$db_prefix."download_cats"), 0);
echo "<tr><td>Kategorijų: </td>
<td class='small2'> $cats</td></tr>";
$countd = dbresult(dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads"), 0);
echo "<tr>
<td>Siuntinių: </td>
<td class='small2'> $countd</td>
</tr>";
$counth = dbresult(dbquery("SELECT SUM(download_count) FROM ".$db_prefix."downloads"), 0);
echo "<tr><td>Atsisiųsta: </td>
<td class='small2'> $counth</td></tr>";
echo "</table>
</td>
</tr>
</table>";
$result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_id DESC LIMIT 0,20");
if (dbrows($result)) {
echo "<table class='tbl-border' style='margin-top: 10px;' border='0' cellpadding='0' cellspacing='1' width='100%'>
<tr>
<td class='forum-caption' style='white-space: nowrap;'>Naujausi siuntiniai</td>
<td class='forum-caption' style='white-space: nowrap;' align='center' width='1%'>Data</td>
<td class='forum-caption' style='white-space: nowrap;' align='center' width='1%'>Siuntimai</td>
</tr>";
while ($data = dbarray($result)) {
$time = $data['download_datestamp'];
$laikas = showdate( "%d.%m.%y", $time);
echo "<tr>
<td class='tbl1'><img src='".THEME."images/bullet.gif' alt='' border='0'> <a class='small' href='downloads.php?d_id=".$data['download_id']."'>".$data['download_title']."</a></td>
<td class='tbl1' align='center'>$laikas</td>
<td class='tbl1' align='center'>".$data['download_count']."</td>
</tr>";
}
echo "</table>";
}
} else {
echo "<center><br>\n".$locale['430']."<br><br>\n</center>\n";
}
closetable();
} else {
$res = 0;
if (!isNum($_GET['cat_id'])) fallback(FUSION_SELF);
$result = dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id='".$_GET['cat_id']."'");
if (dbrows($result) != 0) {
$cdata = dbarray($result);
if (checkgroup($cdata['download_cat_access'])) {
$res = 1;
opentable($locale['400'].": ".$cdata['download_cat_name']);
$rows = dbcount("(*)", DB_PREFIX."downloads", "download_cat='".$_GET['cat_id']."'");
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
$result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_cat='".$_GET['cat_id']."' ORDER BY ".$cdata['download_cat_sorting']." LIMIT ".$rowstart.",15");
//s
$catdata = dbarray(dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id='".$_GET['cat_id']."'"));
$count = dbresult(dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads WHERE download_cat='".$_GET['cat_id']."'"), 0);
echo "
<table class='tbl-border' cellpadding='0' cellspacing='1' width='100%'>
<tr>
<td class='tbl2' style='white-space: nowrap;' align='center' valign='middle' width='1%'><a class='small' href='downloads.php?cat_id=".$_GET['cat_id']."' title='".$catdata['download_cat_name']."'>";
$imgname = strtolower(str_replace(" ","_",nuoroda($catdata['download_cat_name'])));
if (file_exists(IMAGES."dl_cats/".$imgname.".png")) {
$c_img = "<img src='".IMAGES."dl_cats/".$imgname.".png' border='0' alt='".$catdata['download_cat_name']."' /> \n";
} else {
$c_img = "<img src='".IMAGES."dl_cats/0.png' border='0' alt='".$catdata['download_cat_name']."' /> \n";
}
echo $c_img;
echo"</a></td>
<td class='tbl1' valign='top'><span><a class='small' href='downloads.php'>Siuntiniai</a> » ".$catdata['download_cat_name']."</span><br>
".$catdata['download_cat_description']."<br><br>Siuntimų kategorijoje: <span class='small2'>$count</span></td>
</tr>
</table>
<table cellpadding='0' cellspacing='0' width='100%'><tbody><tr>
<td height='8'>
</td>
</tr>
</tbody></table>";
//e
$numrows = dbrows($result); $i = 1;
while ($data = dbarray($result)) {
$id = $data['download_id'];
if ($data['download_datestamp']+604800 > time()+($settings['timeoffset']*3600)) {
$new = " <span class='small'>".$locale['410']."</span>";
} else {
$new = "";
}
$time = $data['download_datestamp'];
$laikas = showdate( "%d.%m.%y", $time);
echo "<table width='100%' cellpadding='0' cellspacing='1' class='tbl-border'>\n";
echo "<tr>
<td colspan='5' class='forum-caption'>
<table style='border-collapse: collapse;' border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td width='1%'><a class='small' href='".FUSION_SELF."?d_id=".$data['download_id']."' title='Žiūrėti failą' style='font-weight: bold;'><img src='".IMAGES."down.png' alt='Žiūrėti failą' border='0'></a></td>
<td> <a class='small' href='".FUSION_SELF."?d_id=".$data['download_id']."' title='Žiūrėti failą' style='font-weight: bold;'><b>".$data['download_title']."</b></a> </td>
<td align='right'><span class='small2'><b>Pridėtas:</b> $laikas</span></td>
</tr></table></td>
</tr>\n";
echo "<tr>\n
<td colspan='5' class='tbl1'>";
echo zip($data['download_url']);
echo"</td>\n</tr>\n<td rowspan='2' class='tbl1' align='center' valign='middle' width='1%'><a class='small' href='".FUSION_SELF."?cat_id=".$_GET['cat_id']."&download_id=".$data['download_id']."' title='Atsisiųsti Failą' style='font-weight: bold;'><img src='".IMAGES."download.png' alt='Atsisiųsti Failą' border='0'></a></td>
<td width='30%' class='tbl1'><b>".$locale['411']."</b> ".$data['download_license']."</td>\n";
$kom = dbquery("SELECT count(comment_id) FROM ".$db_prefix."comments WHERE comment_type='D' AND comment_item_id='$id'");
$kon = dbresult($kom, 0);
if ($kon == 0) { $komentarai = 0; } else { $komentarai = $kon; }
echo "<td width='40%' class='tbl2'><b>Komentarai:</b> $komentarai</td>
<td class='tbl1' rowspan='2' colspan='1' align='right' valign='bottom' width='1%'>
<a href='".FUSION_SELF."?d_id=".$data['download_id']."' title='Žiūrėti failo komentarus'><img src='images/comments.png' alt='Komentuoti' border='0'></a><br>
<a href='".FUSION_SELF."?d_id=".$data['download_id']."' title='Žiūrėti failo reitingus'><img src='images/ratings.png' alt='Vertinti' border='0'></a>
</td>\n</tr>\n<tr>\n";
echo "<td width='30%' class='tbl1'><b>".$locale['415']."</b> ".$data['download_count']."</td>\n<td width='40%' class='tbl2'><b>Dydis:</b> ".($data['download_filesize'] ? "".$data['download_filesize']."" : "Nėra")."</td>\n</tr>\n";
echo "</table>\n";
if ($i != $numrows) { echo "<div align='center'><img src='".THEME."images/blank.gif' alt='' height='15' width='1'></div>\n"; $i++; }
}
closetable();
if ($rows > 15) echo "<div align='center' style='margin-top:5px;'>\n".makePageNav($rowstart,15,$rows,3,FUSION_SELF."?cat_id=".$_GET['cat_id']."&")."\n</div>\n";
} else {
echo $locale['431']."\n";
closetable();
}
}
}
if ($res == 0) redirect(FUSION_SELF);
}
require_once THEMES."templates/footer.php";
?>
Parašė Creatium· 2012 Sau. 6 17:01:05
#4
Paprasčiau bus atsidaryt
mysql ir pažiūrėt kurioje lentelėje kokiame stulpelyje yra įrašomas žmogaus, kuris įdėjo siuntinį, nickas.
Parašė SysRq· 2012 Sau. 6 17:01:36
#5
Kas pateikė dainą įrašomą į dbprefix_downloads lentelę, download_license stulpelyje.
Parašė MaFetas· 2012 Sau. 6 18:01:47
#6
Tai geriau tegul įrašinėja to nario ID o ne user name, lengviau bus ištraukt duomenis ;)
Parašė Jaunelis· 2012 Sau. 6 18:01:37
#7
download_license='".$data['user_name']."' - tai tu nori pasakyt kad licence laukelyje rašo tavo nicką ? :D šeip geriausia pagal nario ID atvaizduoti ir viskas.
Parašė SysRq· 2012 Sau. 6 18:01:34
#8
Taip, noriu pasakyt jog Licenze langelyja atvaizduoja vartotojo vardą, nes šio kodo kurėjas to reikalavo.. O jūsų prašau tik pataisyt kodą nes jis rodo visas dainas o ne nario pateiktas.
Parašė mAnaXi· 2012 Sau. 6 19:01:07
#9
Tai niekas nepadės? Man irgi šito dalyko labai reikėtų.
Parašė avice· 2012 Sau. 6 19:01:40
#10
Jum reikia jog atvaizduotu jo dainas tik jam vienam?
Parašė SysRq· 2012 Sau. 6 19:01:51
#11
Ne, jog profilyje atvaizduotų jo pateiktas dainas visiems. Šį kdą radau ir buvo paaiškinta jog pasidaryti kad license laukelyje įvesti vardą, tai padarė, tada įdėt šitą kodą ir atvaizduos pateiktas dainas, tačiau atvaziduoja kitas dainas nei tas žmogus pateikė. Ir svarbiausia jog šitas kodas atvaziduoja visiems žmoniems tas pačias ir ta pačia seka.
Parašė avice· 2012 Sau. 6 20:01:32
#12
$result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_license='".$user_data['user_name']."' ORDER BY download_datestamp DESC LIMIT 0,20");
if (dbrows($result) !=0) {
opentable("Naujausia <b>".$user_data['user_name']."</b> ikelta muzika");
while ($data = dbarray($result)) {
$pavadinimas = trimlink($data['download_title'], 60);
echo"<table cellpadding='0' cellspacing='0' width='100%'><tr>";
echo"<a href='".FUSION_SELF."?cat_id=$cat_id&download_id=".$data['download_id']."' target='_blank' style='font-size:11px; tetx-align:left;'>".$pavadinimas."</a><br>";
echo"
</tr></table>";
}
closetable();
} else {echo"Narys dar neikele muzikos"; }
sita koda dek i profile.php
zemiau closetable(); ji rasi mazdaug pacioj pabaigoj
Parašė SysRq· 2012 Sau. 6 20:01:28
#13
Dėkoju viskas puikiai veikia :) Kaip visada
avice!