\n"; echo "\n"; echo "$cfg[site_name] Memos repository $title\n"; print_meta(); print_style(); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "$cfg[site_name] Memos page"; echo "\n"; echo "\n\n"; echo "Help | \n"; echo "Home\n"; echo "
\n"; if($cfg[debug]) { global $debug_time_start; $debug_time_end = microtime(); $start = explode(" ", $debug_time_start); $end = explode(" ", $debug_time_end); $elapsed = ($end[0] - $start[0]) + ($end[1] - $start[1]); } echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "\"[\n"; echo "\n"; echo "\n"; echo "
\n"; // echo "
\n"; echo "\n"; echo "\n"; echo "
\n"; echo "

SDMS v$cfg[version], Copyright (C) 2000 Cafuego; LICENSE\n"; if( $cfg[debug] ) echo "
debug: Generated in ". number_format( $elapsed, 3, ".", ",") ." seconds.\n"; echo "

\n"; neutral_table_start("center", 1, 1); mysql_connect("$cfg[server]", "$cfg[user]", "$cfg[pass]") or die("Unable to connect to SQL Server."); mysql_select_db("$cfg[memosdb]") or die("Unable to select database '$cfg[memosdb]'"); echo "\n"; printf(" .\n"); printf(" ID\n", ($order == "id DESC" ) ? "id%20ASC" : "id%20DESC" ); printf(" Author\n", ($order == "author DESC" ) ? "author%20ASC" : "author%20DESC" ); printf(" Title\n", ($order == "title DESC" ) ? "title%20ASC" : "title%20DESC" ); printf(" Filename\n", ($order == "name DESC" ) ? "name%20ASC" : "name%20DESC" ); printf(" Size\n", ($order == "size DESC" ) ? "size%20ASC" : "size%20DESC" ); printf(" Created\n", ($order == "cdate DESC" ) ? "cdate%20ASC" : "cdate%20DESC" ); echo "\n"; if(isset($order)) $res = mysql_query("SELECT d.id AS id,d.name AS name,d.size AS size,d.title AS title,d.author AS author,DATE_FORMAT(d.created, '%d-%m-%Y, %H:%i:%S') AS created,d.created AS cdate FROM documents AS d WHERE ( d.name LIKE '%$query%' OR d.title LIKE '%$query%' OR d.author LIKE '%$query%') ORDER BY ". rawurldecode($order) ); else $res = mysql_query("SELECT d.id AS id,d.name AS name,d.size AS size,d.title AS title,d.author AS author,DATE_FORMAT(d.created, '%d-%m-%Y, %H:%i:%S') AS created,d.created AS cdate FROM documents AS d WHERE ( d.name LIKE '%$query%' OR d.title LIKE '%$query%' OR d.author LIKE '%$query%') ORDER BY id ASC"); if( ! ($count = mysql_num_rows($res)) ) { echo "\n"; echo " No memos found\n"; echo "\n"; } else { echo "

Listing $count memos

\n"; while($row = @mysql_fetch_array($res)) { echo "\n"; echo " \"[".\n"; echo " $row[id]\n"; echo " $row[author]\n"; echo " $row[title]\n"; if ( $row[name] != "") echo " $row[name]\n"; else echo " (No file available)\n"; if($row[size] < 0) continue; if( $row[size] < 10240 ) { $size_str = sprintf("%d bytes", $row[size]); } else if( $row[size] < 1048576 ) { $size_str = sprintf("%.1f Kb", ($row[size]/1024)); } else { $size_str = sprintf("%.1f Mb", ($row[size])/(1024*1024)); } echo " $size_str\n"; echo " $row[created]\n"; echo "\n"; } } table_end(); echo "
\n"; echo "\n"; echo "\n"; ?>