SysRq
Narys
Margas
Pranešimai: 103
Įstojęs: 2011 Rugs. 1 19:09:06
|
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?
|
Kižas
Narys
Kapitonas
Pranešimai: 509
Įstojęs: 2009 Lie. 24 17:07:10
|
Pagal mane tai tikrai ne taip turėtų būti
WHERE download_license='"
download_license keisk į savo downloads.php faile esantį kintamąjį
Pigiausia SMS reklama !
http://topwarez.lt/reklama/uzsak... |
SysRq
Narys
Margas
Pranešimai: 103
Įstojęs: 2011 Rugs. 1 19:09:06
|
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";
?>
|
Creatium
Administratorius
Viršesnis už Dievą
Pranešimai: 5868
Įstojęs: 2007 Rugp. 9 17:08:20
|
Paprasčiau bus atsidaryt mysql ir pažiūrėt kurioje lentelėje kokiame stulpelyje yra įrašomas žmogaus, kuris įdėjo siuntinį, nickas.
www.creatium.lt |
SysRq
Narys
Margas
Pranešimai: 103
Įstojęs: 2011 Rugs. 1 19:09:06
|
Kas pateikė dainą įrašomą į dbprefix_downloads lentelę, download_license stulpelyje.
|
MaFetas
Administratorius
Ekspertas
Pranešimai: 3453
Įstojęs: 2005 Lie. 16 13:07:41
|
Tai geriau tegul įrašinėja to nario ID o ne user name, lengviau bus ištraukt duomenis
Adminas - ban'o laisvė
www.KIETEKAS.com |
Jaunelis
Narys
Antras po Dievo
Pranešimai: 4735
Įstojęs: 2007 Rugs. 23 08:09:32
|
download_license='".$data['user_name']."' - tai tu nori pasakyt kad licence laukelyje rašo tavo nicką ?  šeip geriausia pagal nario ID atvaizduoti ir viskas.
code and design solutions tinklalapių kūrimas |
SysRq
Narys
Margas
Pranešimai: 103
Įstojęs: 2011 Rugs. 1 19:09:06
|
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.
|
mAnaXi
Narys
Margas
Pranešimai: 101
Įstojęs: 2011 Rugp. 16 12:08:21
|
Tai niekas nepadės? Man irgi šito dalyko labai reikėtų.
|
avice
Narys
Terminatorius
Pranešimai: 1441
Įstojęs: 2010 Bir. 25 20:06:33
|
Jum reikia jog atvaizduotu jo dainas tik jam vienam?
|
SysRq
Narys
Margas
Pranešimai: 103
Įstojęs: 2011 Rugs. 1 19:09:06
|
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.
|
avice
Narys
Terminatorius
Pranešimai: 1441
Įstojęs: 2010 Bir. 25 20:06:33
|
$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
|
SysRq
Narys
Margas
Pranešimai: 103
Įstojęs: 2011 Rugs. 1 19:09:06
|
Dėkoju viskas puikiai veikia  Kaip visada avice!
|
