Changeset 4 for www/share/playlist.php

Timestamp:

Jan 14, 2008, 9:48:39 PM (16 years ago)

Author:

george

Message:

Upraveno: Změna přístupu k databázi na třídu rozšířenou mysqli.
Upraveno: Sjednocení
Upraveno: Změna kódování všech stránek na UTF-8.
Odstraňeno: Staré nepotřebné soubory.

Location:

www

Files:

• . (modified) (1 prop)
• share/playlist.php (modified) (2 diffs)

www/share/playlist.php

@@ -1 @@
-<?
-include('../is/db.php');
+<?php
+include('../global.php');
 // Omezení na online/offline uµivatele
-DB_Init('localhost','root','','is');
 
-DB_Query('SELECT id FROM hosts WHERE online=1 AND block=0 AND user>0');
+$DbResult = $Database->query('SELECT id FROM hosts WHERE online=1 AND block=0 AND user>0');
 $Vyber = '';
 $Podminka = '';
-while($Row = DB_Row()) $Vyber .= $Row['id'].',';
-  $Podminka .= ' AND (host IN ('.substr($Vyber,0,-1).'))';
+while($Row = $DbResult->fetch_array()) 
+  $Vyber .= $Row['id'].',';
+$Podminka .= ' AND (host IN ('.substr($Vyber,0,-1).'))';
 //echo($Podminka.'<br>');
 
-DB_Init('localhost', 'root', '', 'share');
+$Database->select_db('share');
 
 // Maximální vnoøení
@@ -19 +19 @@
 function PlnaCesta($Row)
 {
-  global $MaxNesting;
+  global $MaxNesting, $Database;
+  
   // Vyhledání cesty
   $Otec = $Row['parent'];
   $Cesta = ''; //$Row['name'];
-  DB_Save();
   $i = 0;
   while(($Otec>1)&&($i<$MaxNesting))
   {
-    DB_Query("SELECT id,name,parent FROM items WHERE id=$Otec");
-    $Row = DB_Row();
+    $DbResult = $Database->query("SELECT id,name,parent FROM items WHERE id=$Otec");
+    $Row = $DbResult->fetch_array();
     $Cesta = $Row['name'].'\\'.$Cesta;
     $Otec = $Row['parent'];
     $i++;
   }
-  DB_Load();
   if($i >= $MaxNesting) $Cesta = '?'.'\\'.$Cesta;
   return('\\\\'.$Cesta);
 }
 
+function mime_content_type($FileName)
+{
+  //$FileInfo = new finfo(FILEINFO_MIME);
+  //return($FileInfo->file($FileName));
+  return('');
+}
+
 $Name = 'playlist.m3u';
-Header('Content-type: '+mime_content_type($Name));
+Header('Content-type: audio/x-mpegurl');
 Header('Content-Disposition: attachment; filename='.$Name);
 echo("#EXTM3U\n");
 $Parent = '0';
 $Dir = '';
-DB_Select('items', '*', 'ext="mp3"'.$Podminka); //.' LIMIT 0,1000');
-while($Row = DB_Row())
+$DbResult = $Database->select('items', '*', 'ext="mp3"'.$Podminka); //.' LIMIT 0,1000');
+while($Row = $DbResult->fetch_array())
 {
-  DB_Save();
   if($Parent != $Row['parent']) $Dir = PlnaCesta($Row); //echo('d'.PlnaCesta($Row)."\n");
   $Parent = $Row['parent'];
   echo($Dir.$Row['name'].'.'.$Row['ext']."\n");
-  DB_Load();
 }