formatTime = function (millisecs){ 
  	var secs = Math.floor(millisecs/1000); 
  	var mins = Math.floor(secs/60); 
  	secs %= 60; 
  	if (secs < 10) secs = "0"+ secs; 
  	if (mins < 10) mins = "0"+ mins; 
  	return mins +":"+ secs;	 
  } 
   
  var snd = this.createEmptyMovieClip("SoundController", 1); 
   
  snd.init = function(){ 
  	snd._sound = new Sound(this); 
  	this.isPlaying = false; 
  	this.position = 0; 
  	loadingbar_mc._xscale = 0; 
  	progressbar_mc._xscale = 0; 
  	pause_btn._visible = false; 
  } 
  snd.loadSound = function(url){ 
  	this._sound.loadSound(url, true); 
  	snd.position = 0; 
  	stop_btn.onRelease(); 
  	this.updateTime(); 
  	snd._sound.setVolume(((soundbutton_mc._x-soundbar_mc._x)/soundbar_mc._width)*100); 
  } 
  snd.updateTime = function(){ 
  	var time = formatTime(snd.position); 
  	if (time_txt.text != time) time_txt.text = time; 
  } 
  snd._sound.onSoundComplete = function(){ 
  	stop_btn.onRelease(); 
  } 
  snd.onEnterFrame = function(){ 
  	if (this.isPlaying) this.position = this._sound.position; 
  	this.loaded = this._sound.getBytesLoaded()/this._sound.getBytesTotal(); 
  	loadingbar_mc._xscale = scrubber_mc._xscale * this.loaded; 
  	progressbar_mc._xscale = loadingbar_mc._xscale * this.position/this._sound.duration; 
  	this.updateTime(); 
  	if (draggingvolmeslider) { 
  		updatevolume(); 
  	} 
  } 
   
   
  play_btn.onRelease = function(){ 
  	if (!isPlaying){ 
  		snd._sound.start(snd.position/1000);	 
  		snd.isPlaying = true; 
  		play_btn._visible=false; 
  		pause_btn._visible = true; 
  	} 
  } 
  pause_btn.onRelease = function(){ 
  	if (!snd.isPlaying) return (0); 
  	snd.position = snd._sound.position; 
  	snd._sound.stop(); 
  	snd.isPlaying = false; 
  	pause_btn._visible = false; 
  	play_btn._visible = true; 
  } 
  stop_btn.onRelease = function(){ 
  	snd.position = 0; 
  	snd._sound.stop(); 
  	snd.isPlaying = false; 
  } 
  prev_btn.onRelease = function(){ 
  	if (snd.node){ 
  		if (snd.node.previousSibling) SetSong(snd.node.previousSibling); 
  		else SetSong(snd.node.parentNode.lastChild) 
  	} 
  } 
  next_btn.onRelease = function(){ 
  	if (snd.node){ 
  		if (snd.node.nextSibling) SetSong(snd.node.nextSibling); 
  		else SetSong(snd.node.parentNode.firstChild); 
  	} 
  } 
   
  scrubber_mc.onPress = function(){ 
  	if (!snd.loaded) return (0); 
  	var pos = this._xmouse/100; 
  	snd.position = Math.min(snd._sound.duration, pos * snd._sound.duration/snd.loaded); 
  	if (snd.isPlaying) snd._sound.start(snd.position/1000); 
  } 
   
  soundbutton_mc.onPress = function() { 
  	draggingvolmeslider = true; 
  	soundbutton_mc.startDrag(true,soundbar_mc._x, soundbutton_mc._y, soundbar_mc._x + soundbar_mc._width, soundbutton_mc._y); 
  } 
  soundbutton_mc.onRelease = soundbutton_mc.onReleaseOutside = function () { 
  	draggingvolmeslider = false; 
  	soundbutton_mc.stopDrag(); 
  	updatevolume(); 
  } 
  function updatevolume() { 
  	snd._sound.setVolume(((soundbutton_mc._x-soundbar_mc._x)/soundbar_mc._width)*100); 
  } 
   
   
  SetSong = function(node){ 
  	snd.node = node; 
  	snd.loadSound(node.attributes.src); 
  	title_txt.text = node.attributes.title; 
  } 
   
  snd.init(); 
  

 
  rs = SELECT * FROM tblkat ORDER BY katsira DESC 
   
  while (rs.read) 
  { 
      rs2 = SELECT TOP 1 * FROM tblurun WHERE urunkat = [b]rs["katid"][/b] ORDER BY urunsira DESC 
  }