_Tomas
VIP narys
Terminatorius
Pranešimai: 1319
Įstojęs: 2007 Rugp. 26 20:08:12
|
Sveiki. Turiu kodą kuriame keičiasi nuotrauka kas kelias sekundes. Jame rodo galerija kurioje buvo pirma foto įdėta o man įdomu ar įmanoma padaryti, kad rodytu pagal ID:
Pvz:
Parodo 5 foto iš 1 albumo paskui iš 2-3 ir dar daugiau kol visus pereina ir vėl išnaujo.
Manau reikia užklausau kažką keisti...
openside("Atsitiktinė Nuotrauka");
?>
<center>
<?php
$result = dbquery("SELECT tp.*, tpa.album_title FROM ".$db_prefix."photos tp
LEFT JOIN ".$db_prefix."photo_albums tpa ON tpa.album_id=tp.album_id ORDER BY photo_id DESC LIMIT 10");
if (dbrows($result)) {
$i=0;
while($data=dbarray($result)) {
$photodir = PHOTOS.(!@ini_get("safe_mode") ? "album_".$data['album_id']."/" : "");
$images .= "fadeimages[$i]=[\"".$photodir.$data['photo_thumb1']."\", \"".BASEDIR."photogallery.php?photo_id=".$data['photo_id']."\", \"\"]
dropdesc[$i]='<span class=\"small\">".$data['photo_title']."</span><br><span class=\"small2\">".$data['album_title']."</span>'
dropalt[$i]='".$data['photo_title']."'\n";
$i++;
}
}
?>
<script type='text/javascript' language='JavaScript1.2'>
var fadeimages=new Array()
var dropdesc=new Array()
var dropalt=new Array()
//SET IMAGE PATHS. Extend or contract array as needed
<?php
echo $images;
?>
var fadebgcolor="515033"
////NO need to edit beyond here/////////////
var fadearray=new Array() //array to cache fadeshow instances
var fadeclear=new Array() //array to cache corresponding clearinterval pointers
var dom=(document.getElementById) //modern dom browsers
var iebrowser=document.all
function fadeshow(theimages, fadewidth, fadeheight, borderwidth, delay, pause, displayorder){
this.pausecheck=pause
this.mouseovercheck=0
this.delay=delay
this.degree=10 //initial opacity degree (10%)
this.curimageindex=0
this.nextimageindex=1
fadearray[fadearray.length]=this
this.slideshowid=fadearray.length-1
this.canvasbase="canvas"+this.slideshowid
this.curcanvas=this.canvasbase+"_0"
if (typeof displayorder!="undefined")
theimages.sort(function() {return 0.5 - Math.random();})
this.theimages=theimages
this.imageborder=parseInt(borderwidth)
this.postimages=new Array() //preload images
for (p=0;p<theimages.length;p++){
this.postimages[p]=new Image()
this.postimages[p].src=theimages[p][0]
}
var fadewidth=fadewidth+this.imageborder*2
var fadeheight=fadeheight+this.imageborder*2
if (iebrowser&&dom||dom) //if IE5+ or modern browsers (ie: Firefox)
document.write('<div id="master'+this.slideshowid+'" style="position:relative;width:'+fadewidth+'px;height:'+fadeheight+'px;overflow:hidden;"><div id="'+this.canvasbase+'_0" style="position:absolute;width:'+fadewidth+'px;height:'+fadeheight+'px;top:0;left:0;filter:progid:DXImageTransform.Microsoft.alpha(opacity=10);-moz-opacity:10;-khtml-opacity:10;background-color:'+fadebgcolor+'"></div><div id="'+this.canvasbase+'_1" style="position:absolute;width:'+fadewidth+'px;height:'+fadeheight+'px;top:0;left:0;filter:progid:DXImageTransform.Microsoft.alpha(opacity=10);-moz-opacity:10;background-color:'+fadebgcolor+'"></div></div>')
else
document.write('<div><img name="defaultslide'+this.slideshowid+'" src="'+this.postimages[0].src+'"></div>')
if (iebrowser&&dom||dom) //if IE5+ or modern browsers such as Firefox
this.startit()
else{
this.curimageindex++
setInterval("fadearray["+this.slideshowid+"].rotateimage()", this.delay)
}
}
function fadepic(obj){
if (obj.degree<100){
obj.degree+=10
if (obj.tempobj.filters&&obj.tempobj.filters[0]){
if (typeof obj.tempobj.filters[0].opacity=="number") //if IE6+
obj.tempobj.filters[0].opacity=obj.degree
else //else if IE5.5-
obj.tempobj.style.filter="alpha(opacity="+obj.degree+")"
}
else if (obj.tempobj.style.MozOpacity)
obj.tempobj.style.MozOpacity=obj.degree/101
else if (obj.tempobj.style.KhtmlOpacity)
obj.tempobj.style.KhtmlOpacity=obj.degree/100
}
else{
clearInterval(fadeclear[obj.slideshowid])
obj.nextcanvas=(obj.curcanvas==obj.canvasbase+"_0")? obj.canvasbase+"_0" : obj.canvasbase+"_1"
obj.tempobj=iebrowser? iebrowser[obj.nextcanvas] : document.getElementById(obj.nextcanvas)
obj.populateslide(obj.tempobj, obj.nextimageindex)
obj.nextimageindex=(obj.nextimageindex<obj.postimages.length-1)? obj.nextimageindex+1 : 0
setTimeout("fadearray["+obj.slideshowid+"].rotateimage()", obj.delay)
}
}
fadeshow.prototype.populateslide=function(picobj, picindex){
var slideHTML=""
if (this.theimages[picindex][1]!="") //if associated link exists for image
slideHTML='<a href="'+this.theimages[picindex][1]+'" target="'+this.theimages[picindex][2]+'">'
slideHTML+='<img src="'+this.postimages[picindex].src+'" border="'+this.imageborder+'px" alt="'+dropalt[picindex]+'" title="'+dropalt[picindex]+'"><br>'+dropdesc[picindex]+''
if (this.theimages[picindex][1]!="") //if associated link exists for image
slideHTML+='</a>'
picobj.innerHTML=slideHTML
}
fadeshow.prototype.rotateimage=function(){
if (this.pausecheck==1) //if pause onMouseover enabled, cache object
var cacheobj=this
if (this.mouseovercheck==1)
setTimeout(function(){cacheobj.rotateimage()}, 100)
else if (iebrowser&&dom||dom){
this.resetit()
var crossobj=this.tempobj=iebrowser? iebrowser[this.curcanvas] : document.getElementById(this.curcanvas)
crossobj.style.zIndex++
fadeclear[this.slideshowid]=setInterval("fadepic(fadearray["+this.slideshowid+"])",50)
this.curcanvas=(this.curcanvas==this.canvasbase+"_0")? this.canvasbase+"_1" : this.canvasbase+"_0"
}
else{
var ns4imgobj=document.images['defaultslide'+this.slideshowid]
ns4imgobj.src=this.postimages[this.curimageindex].src
}
this.curimageindex=(this.curimageindex<this.postimages.length-1)? this.curimageindex+1 : 0
}
fadeshow.prototype.resetit=function(){
this.degree=10
var crossobj=iebrowser? iebrowser[this.curcanvas] : document.getElementById(this.curcanvas)
if (crossobj.filters&&crossobj.filters[0]){
if (typeof crossobj.filters[0].opacity=="number") //if IE6+
crossobj.filters(0).opacity=this.degree
else //else if IE5.5-
crossobj.style.filter="alpha(opacity="+this.degree+")"
}
else if (crossobj.style.MozOpacity)
crossobj.style.MozOpacity=this.degree/101
else if (crossobj.style.KhtmlOpacity)
crossobj.style.KhtmlOpacity=obj.degree/100
}
fadeshow.prototype.startit=function(){
var crossobj=iebrowser? iebrowser[this.curcanvas] : document.getElementById(this.curcanvas)
this.populateslide(crossobj, this.curimageindex)
if (this.pausecheck==1){ //IF SLIDESHOW SHOULD PAUSE ONMOUSEOVER
var cacheobj=this
var crossobjcontainer=iebrowser? iebrowser["master"+this.slideshowid] : document.getElementById("master"+this.slideshowid)
crossobjcontainer.onmouseover=function(){cacheobj.mouseovercheck=1}
crossobjcontainer.onmouseout=function(){cacheobj.mouseovercheck=0}
}
this.rotateimage()
}
</script>
<script type='text/javascript'>
//new fadeshow(IMAGES_ARRAY_NAME, slideshow_width, slideshow_height, borderwidth, delay, pause (0=no, 1=yes), optionalRandomOrder)
new fadeshow(fadeimages, 135, 130, 0, 5000, 1)
</script>
</center>
<?php
closeside();
Redagavo bad_user 2008 Gru. 20 14:12:38 |
Pongis
Narys
Tankas
Pranešimai: 2272
Įstojęs: 2007 Vas. 18 11:02:23
|
Gudruolis ištrynė seną temą ir sukūrė naują su tuo pačiu tūriniu..
|
_Tomas
VIP narys
Terminatorius
Pranešimai: 1319
Įstojęs: 2007 Rugp. 26 20:08:12
|
Oi oi tragedija ane? Pats neišsprendžiu prašau pagalbos, nenoriu floodinti sukuriu naują temą seną ištrinu
|
RobInHo
Narys
Margas
Pranešimai: 84
Įstojęs: 2007 Lap. 2 09:11:28
|
Galit kas sitoj panelei smailus isjungt ?
|
Lukšius
Narys
Kapitonas
Pranešimai: 741
Įstojęs: 2008 Vas. 25 17:02:03
|
Be smailų
openside("Atsitiktinė Nuotrauka");
?>
<center>
<?php
$result = dbquery("SELECT tp.*, tpa.album_title FROM ".$db_prefix."photos tp
LEFT JOIN ".$db_prefix."photo_albums tpa ON tpa.album_id=tp.album_id ORDER BY photo_id DESC LIMIT 10");
if (dbrows($result)) {
$i=0;
while($data=dbarray($result)) {
$photodir = PHOTOS.(!@ini_get("safe_mode") ? "album_".$data['album_id']."/" : "");
$images .= "fadeimages[$i]=[\"".$photodir.$data['photo_thumb1']."\", \"".BASEDIR."photogallery.php?photo_id=".$data['photo_id']."\", \"\"]
dropdesc[$i]='<span class=\"small\">".$data['photo_title']."</span><br><span class=\"small2\">".$data['album_title']."</span>'
dropalt[$i]='".$data['photo_title']."'\n";
$i++;
}
}
?>
<script type='text/javascript' language='JavaScript1.2'>
var fadeimages=new Array()
var dropdesc=new Array()
var dropalt=new Array()
//SET IMAGE PATHS. Extend or contract array as needed
<?php
echo $images;
?>
var fadebgcolor="515033"
////NO need to edit beyond here/////////////
var fadearray=new Array() //array to cache fadeshow instances
var fadeclear=new Array() //array to cache corresponding clearinterval pointers
var dom=(document.getElementById) //modern dom browsers
var iebrowser=document.all
function fadeshow(theimages, fadewidth, fadeheight, borderwidth, delay, pause, displayorder){
this.pausecheck=pause
this.mouseovercheck=0
this.delay=delay
this.degree=10 //initial opacity degree (10%)
this.curimageindex=0
this.nextimageindex=1
fadearray[fadearray.length]=this
this.slideshowid=fadearray.length-1
this.canvasbase="canvas"+this.slideshowid
this.curcanvas=this.canvasbase+"_0"
if (typeof displayorder!="undefined")
theimages.sort(function() {return 0.5 - Math.random();})
this.theimages=theimages
this.imageborder=parseInt(borderwidth)
this.postimages=new Array() //preload images
for (p=0;p<theimages.length;p++){
this.postimages[p]=new Image()
this.postimages[p].src=theimages[p][0]
}
var fadewidth=fadewidth+this.imageborder*2
var fadeheight=fadeheight+this.imageborder*2
if (iebrowser&&dom||dom) //if IE5+ or modern browsers (ie: Firefox)
document.write('<div id="master'+this.slideshowid+'" style="position:relative;width:'+fadewidth+'px;height:'+fadeheight+'px;overflow:hidden;"><div id="'+this.canvasbase+'_0" style="position:absolute;width:'+fadewidth+'px;height:'+fadeheight+'px;top:0;left:0;filter:progid:DXImageTransform.Microsoft.alpha(opacity=10);-moz-opacity:10;-khtml-opacity:10;background-color:'+fadebgcolor+'"></div><div id="'+this.canvasbase+'_1" style="position:absolute;width:'+fadewidth+'px;height:'+fadeheight+'px;top:0;left:0;filter:progid:DXImageTransform.Microsoft.alpha(opacity=10);-moz-opacity:10;background-color:'+fadebgcolor+'"></div></div>')
else
document.write('<div><img name="defaultslide'+this.slideshowid+'" src="'+this.postimages[0].src+'"></div>')
if (iebrowser&&dom||dom) //if IE5+ or modern browsers such as Firefox
this.startit()
else{
this.curimageindex++
setInterval("fadearray["+this.slideshowid+"].rotateimage()", this.delay)
}
}
function fadepic(obj){
if (obj.degree<100){
obj.degree+=10
if (obj.tempobj.filters&&obj.tempobj.filters[0]){
if (typeof obj.tempobj.filters[0].opacity=="number") //if IE6+
obj.tempobj.filters[0].opacity=obj.degree
else //else if IE5.5-
obj.tempobj.style.filter="alpha(opacity="+obj.degree+")"
}
else if (obj.tempobj.style.MozOpacity)
obj.tempobj.style.MozOpacity=obj.degree/101
else if (obj.tempobj.style.KhtmlOpacity)
obj.tempobj.style.KhtmlOpacity=obj.degree/100
}
else{
clearInterval(fadeclear[obj.slideshowid])
obj.nextcanvas=(obj.curcanvas==obj.canvasbase+"_0")? obj.canvasbase+"_0" : obj.canvasbase+"_1"
obj.tempobj=iebrowser? iebrowser[obj.nextcanvas] : document.getElementById(obj.nextcanvas)
obj.populateslide(obj.tempobj, obj.nextimageindex)
obj.nextimageindex=(obj.nextimageindex<obj.postimages.length-1)? obj.nextimageindex+1 : 0
setTimeout("fadearray["+obj.slideshowid+"].rotateimage()", obj.delay)
}
}
fadeshow.prototype.populateslide=function(picobj, picindex){
var slideHTML=""
if (this.theimages[picindex][1]!="") //if associated link exists for image
slideHTML='<a href="'+this.theimages[picindex][1]+'" target="'+this.theimages[picindex][2]+'">'
slideHTML+='<img src="'+this.postimages[picindex].src+'" border="'+this.imageborder+'px" alt="'+dropalt[picindex]+'" title="'+dropalt[picindex]+'"><br>'+dropdesc[picindex]+''
if (this.theimages[picindex][1]!="") //if associated link exists for image
slideHTML+='</a>'
picobj.innerHTML=slideHTML
}
fadeshow.prototype.rotateimage=function(){
if (this.pausecheck==1) //if pause onMouseover enabled, cache object
var cacheobj=this
if (this.mouseovercheck==1)
setTimeout(function(){cacheobj.rotateimage()}, 100)
else if (iebrowser&&dom||dom){
this.resetit()
var crossobj=this.tempobj=iebrowser? iebrowser[this.curcanvas] : document.getElementById(this.curcanvas)
crossobj.style.zIndex++
fadeclear[this.slideshowid]=setInterval("fadepic(fadearray["+this.slideshowid+"])",50)
this.curcanvas=(this.curcanvas==this.canvasbase+"_0")? this.canvasbase+"_1" : this.canvasbase+"_0"
}
else{
var ns4imgobj=document.images['defaultslide'+this.slideshowid]
ns4imgobj.src=this.postimages[this.curimageindex].src
}
this.curimageindex=(this.curimageindex<this.postimages.length-1)? this.curimageindex+1 : 0
}
fadeshow.prototype.resetit=function(){
this.degree=10
var crossobj=iebrowser? iebrowser[this.curcanvas] : document.getElementById(this.curcanvas)
if (crossobj.filters&&crossobj.filters[0]){
if (typeof crossobj.filters[0].opacity=="number") //if IE6+
crossobj.filters(0).opacity=this.degree
else //else if IE5.5-
crossobj.style.filter="alpha(opacity="+this.degree+")"
}
else if (crossobj.style.MozOpacity)
crossobj.style.MozOpacity=this.degree/101
else if (crossobj.style.KhtmlOpacity)
crossobj.style.KhtmlOpacity=obj.degree/100
}
fadeshow.prototype.startit=function(){
var crossobj=iebrowser? iebrowser[this.curcanvas] : document.getElementById(this.curcanvas)
this.populateslide(crossobj, this.curimageindex)
if (this.pausecheck==1){ //IF SLIDESHOW SHOULD PAUSE ONMOUSEOVER
var cacheobj=this
var crossobjcontainer=iebrowser? iebrowser["master"+this.slideshowid] : document.getElementById("master"+this.slideshowid)
crossobjcontainer.onmouseover=function(){cacheobj.mouseovercheck=1}
crossobjcontainer.onmouseout=function(){cacheobj.mouseovercheck=0}
}
this.rotateimage()
}
</script>
<script type='text/javascript'>
//new fadeshow(IMAGES_ARRAY_NAME, slideshow_width, slideshow_height, borderwidth, delay, pause (0=no, 1=yes), optionalRandomOrder)
new fadeshow(fadeimages, 135, 130, 0, 5000, 1)
</script>
</center>
<?php
closeside();
|
bad_user
Narys
Antras po Dievo
Pranešimai: 4956
Įstojęs: 2007 Spa. 26 20:10:01
|
Pridedi WHERE photo_id = '1' AND photo_id = '2' AND photo_id = '3' ir etc 
Rules: 21 & 22 Read first! |
ex-it
Narys
Ekspertas
Pranešimai: 2696
Įstojęs: 2007 Gru. 24 11:12:58
|
song nereik situ photo_id = '1'. (kabuciu)
Redagavo ex-it 2008 Gru. 20 16:12:00 |
bad_user
Narys
Antras po Dievo
Pranešimai: 4956
Įstojęs: 2007 Spa. 26 20:10:01
|
http://www.w3schools.com/php/php..._where.asp pasimokyk išminčiau
Rules: 21 & 22 Read first! |
ex-it
Narys
Ekspertas
Pranešimai: 2696
Įstojęs: 2007 Gru. 24 11:12:58
|
This is correct:
SELECT * FROM Persons WHERE Year=1965
This is wrong:
SELECT * FROM Persons WHERE Year='1965'
Tai cia blogai pagal tave? 
Redagavo ex-it 2008 Gru. 20 20:12:46 |
bad_user
Narys
Antras po Dievo
Pranešimai: 4956
Įstojęs: 2007 Spa. 26 20:10:01
|
Koks trauma šitą rašė? :?
$result = mysql_query("SELECT * FROM Persons
WHERE FirstName='Peter'");
Rules: 21 & 22 Read first!
Redagavo bad_user 2008 Gru. 20 20:12:32 |
ex-it
Narys
Ekspertas
Pranešimai: 2696
Įstojęs: 2007 Gru. 24 11:12:58
|
This is correct:
SELECT * FROM Persons WHERE FirstName='Tove'
This is wrong:
SELECT * FROM Persons WHERE FirstName=Tove
This is correct:
SELECT * FROM Persons WHERE Year=1965
This is wrong:
SELECT * FROM Persons WHERE Year='1965'
Tureta galvoje kad jei rasai su skaiciais tai nereik ' ' , jei rasai raidem reikia.
|
bad_user
Narys
Antras po Dievo
Pranešimai: 4956
Įstojęs: 2007 Spa. 26 20:10:01
|
Reikia visais atvėjais kitaip užskaitys ir toliau tarkim WHERE lalala=1 AND lala=2
Tai ir ieškos servas column su 1 AND lala=2
Rules: 21 & 22 Read first! |
ex-it
Narys
Ekspertas
Pranešimai: 2696
Įstojęs: 2007 Gru. 24 11:12:58
|
Tai kokio ***** ten parasyta taip?
|
bad_user
Narys
Antras po Dievo
Pranešimai: 4956
Įstojęs: 2007 Spa. 26 20:10:01
|
Nes žmonės neskaito knygų ir nežino kas yra sql injekcija
Rules: 21 & 22 Read first!
Redagavo bad_user 2008 Gru. 21 02:12:59 |
