\n";
exit;
}
// Constructor
function Zoom505DB($cfg) {
$this->CONFIG = $cfg;
}
function init () {
$user = $this->CONFIG["user"];
$server = $this->CONFIG["host"];
$pass = $this->CONFIG["password"];
$dbase = $this->CONFIG["db"];
$conn = mysql_pconnect($server, $user, $pass);
if(!$conn) {
$this->error("Impossible de se connecter !");
}
if(!mysql_select_db($dbase,$conn)) {
$this->error("Echec de connexion à la Base");
}
$this->CONN = $conn;
return true;
}
function get_newsrow_init ($st,$nb,$r,$o) {
$queryr=" and (nom like '%$r%' or effet like '%$r%' ) ";
$table = $this->CONFIG["usertable"];
$tablec = $this->CONFIG["cattable"];
// $query = "SELECT * FROM $table ORDER BY nom LIMIT $st,$nb";
// $query = "SELECT *,$table.nom as NOM FROM $table order by $table.nom LIMIT $st,$nb";
$query = "SELECT * FROM $table,$tablec where $tablec.id=$table.type";
if ($r) $query.=$queryr;
if ($o) { $query.=" order by $table.$o,$table.nom LIMIT $st,$nb"; }
else{$query.=" order by $table.nom LIMIT $st,$nb"; }
$result = mysql_query($query) or $this->error("DB Error!");
$this->DB_RESULT = $result;
return true;
}
function get_patche ($nb,$r) {
$queryr=" and (nom like '%$r%' or effet like '%$r%') ";
$table = $this->CONFIG["usertable"];
$query = "SELECT * FROM $table where id=$nb";
if ($r) $query.=$queryr;
$result = mysql_query($query) or $this->error("DB Error!");
$this->DB_RESULT = $result;
return true;
}
function get_newsrow () {
$result = $this->DB_RESULT;
$row = mysql_fetch_array ($result);
return $row;
}
function insert_patche ($n,$e,$c,$d,$g,$z,$eq,$m,$dl,$l) {
$table = $this->CONFIG["usertable"];
$query = "insert into $table values (
'$n','$e','$c','$d','$g','$z','$eq','$m','$dl','$l',0,'')";
$result = mysql_query($query) or $this->error("DB Error!");
return $result;
}
function update_patche ($i,$n,$e,$c,$d,$g,$z,$eq,$m,$dl,$l) {
$table = $this->CONFIG["usertable"];
$query = "update $table set nom='$n',effet='$e',comp='$c',dist='$d',gain='$g',znr_amp='$z',eq='$eq',mod='$m',dly_rev='$dl',level='$l' where id=$i";
$result = mysql_query($query) or $this->error("DB Error!");
return $result;
}
function get_nrow ($r) {
$queryr=" where nom like '%$r%' or effet like '%$r%' ";
$table = $this->CONFIG["usertable"];
$query = "SELECT count(*) FROM $table ";
if ($r) $query.=$queryr;
$result = mysql_query($query) or $this->error("DB Error!");
$row = mysql_fetch_array ($result);
return $row[0];
}
}
function var_module($v1,$v2,$v3,$v4,$v5,$v6,$v7 ) {
// $v1 la valeur de la BdD
// $v2 la valeur a tester
// $v4 le libelé de la variable
// $v5 la variable array
// $v6 le nom de l'objet
// $v7 le nom du block
global $tpl;
if (strtoupper($v1) != strtoupper($v2) ) {
$tpl->assign(array( $v5 => "$v4 ($v2)"));
} else {
$tpl->assign(array( $v5 => " $v4 ($v2)"));
}
$tpl->parse($v6, $v7);
}
function zoom_comp($c) {
global $tpl;
$ll=".zoomlistcomp";
$LL="ZOOMBC";
$ZB="ZOOM_BLOCK_COMP";
$n="zoom_comp";
var_module($c,"Of",$n,"Off",$ZB,$LL,$ll);
$l="Compresseur";
$L="C";
for ($y=1; $y < 10; $y++ ) {
$v=$L.$y;
$vv=$l." ".$y;
var_module($c,$v,$n,$vv,$ZB,$LL,$ll);
}
$l="Limiteur";
$L="L";
for ($y=1; $y < 10; $y++ ) {
$v=$L.$y;
$vv=$l." ".$y;
var_module($c,$v,$n,$vv,$ZB,$LL,$ll);
}
$l="Auto WahWah";
$L="A";
for ($y=1; $y < 10; $y++ ) {
$v=$L.$y;
$vv=$l." ".$y;
var_module($c,$v,$n,$vv,$ZB,$LL,$ll);
}
$l="Pédale WahWah";
$L="P";
for ($y=1; $y < 10; $y++ ) {
$v=$L.$y;
$vv=$l." ".$y;
var_module($c,$v,$n,$vv,$ZB,$LL,$ll);
}
}
function zoom_dist($d){
global $tpl;
$ll=".zoomlistdist";
$LL="ZOOMBD";
$ZB="ZOOM_BLOCK_DIST";
$n="zoom_dist";
var_module($d,"Of",$n,"Off",$ZB,$LL,$ll);
var_module($d,"Ac",$n,"Accoustique",$ZB,$LL,$ll);
var_module($d,"rY",$n,"Rythme",$ZB,$LL,$ll);
var_module($d,"Od",$n,"Overdrive",$ZB,$LL,$ll);
var_module($d,"dt",$n,"Distorsion",$ZB,$LL,$ll);
var_module($d,"bl",$n,"Blues",$ZB,$LL,$ll);
var_module($d,"Fu",$n,"Fuzz",$ZB,$LL,$ll);
var_module($d,"Ld",$n,"Lead",$ZB,$LL,$ll);
var_module($d,"Mt",$n,"Metal",$ZB,$LL,$ll);
}
function zoom_gain($g){
global $tpl;
$ll=".zoomlistgain";
$LL="ZOOMBG";
$ZB="ZOOM_BLOCK_GAIN";
$n="zoom_gain";
var_module($g,"--",$n,"Off",$ZB,$LL,$ll);
for ($x=1; $x < 31 ; $x++ ) {
$v="Gain ".$x;
var_module($g,$x,$n,$v,$ZB,$LL,$ll);
}
}
function zoom_znr_amp($z){
global $tpl;
$ll=".zoomlistznramp";
$LL="ZOOMBZA";
$ZB="ZOOM_BLOCK_ZNR_AMP";
$n="zoom_znr_amp";
var_module($z,"Of",$n,"Off",$ZB,$LL,$ll);
for ($x=1; $x < 10 ; $x++ ) {
var_module($z,$x,$n,$x,$ZB,$LL,$ll);
}
$L="A";
for ($x=1; $x < 10; $x++ ) {
$v=$L.$x;
var_module($z,$v,$n,$v,$ZB,$LL,$ll);
}
}
function zoom_eq($e){
global $tpl;
$ll=".zoomlisteq";
$LL="ZOOMBEQ";
$ZB="ZOOM_BLOCK_EQ";
$n="zoom_eq";
var_module($e,"Of",$n,"Off",$ZB,$LL,$ll);
for ($x=1; $x < 51 ; $x++ ) {
var_module($e,$x,$n,$x,$ZB,$LL,$ll);
}
$l="Phase";
$L="P";
for ($x=1; $x < 10; $x++ ) {
$v=$L.$x;
$vv=$l." ".$x;
var_module($e,$v,$n,$vv,$ZB,$LL,$ll);
}
}
function zoom_mod($m){
global $tpl;
$ll=".zoomlistmod";
$LL="ZOOMBMOD";
$ZB="ZOOM_BLOCK_MOD";
$n="zoom_mod";
var_module($m,"Of",$n,"Off",$ZB,$LL,$ll);
$l="Chorus";
$L="C";
for ($x=1; $x < 10; $x++ ) {
$v=$L.$x;
$vv=$l." ".$x;
var_module($m,$v,$n,$vv,$ZB,$LL,$ll);
}
$l="Flanger";
$L="F";
for ($x=1; $x < 10; $x++ ) {
$v=$L.$x;
$vv=$l." ".$x;
var_module($m,$v,$n,$vv,$ZB,$LL,$ll);
}
$l="Doublage";
$L="d";
for ($x=1; $x < 10; $x++ ) {
$v=$L.$x;
$vv=$l." ".$x;
var_module($m,$v,$n,$vv,$ZB,$LL,$ll);
}
$l="Pas";
$L="S";
for ($x=1; $x < 10; $x++ ) {
$v=$L.$x;
$vv=$l." ".$x;
var_module($m,$v,$n,$vv,$ZB,$LL,$ll);
}
$l="Transposition";
$L="P";
for ($x=1; $x < 10; $x++ ) {
$v=$L.$x;
$vv=$l." ".$x;
var_module($m,$v,$n,$vv,$ZB,$LL,$ll);
}
var_module($m,"Pd",$n,"Transposition d",$ZB,$LL,$ll);
var_module($m,"Pu",$n,"Transposition u",$ZB,$LL,$ll);
}
function zoom_dly_rev($d){
global $tpl;
$ll=".zoomlistdlyrev";
$LL="ZOOMBDR";
$ZB="ZOOM_BLOCK_DLY_REV";
$n="zoom_dly_rev";
var_module($d,"Of",$n,"Off",$ZB,$LL,$ll);
$l="Retard/Delay";
$L="d";
for ($x=1; $x < 10; $x++ ) {
$v=$L.$x;
$vv=$l." ".$x;
var_module($d,$v,$n,$vv,$ZB,$LL,$ll);
}
$l="Hall Reverbération";
$L="H";
for ($x=1; $x < 10; $x++ ) {
$v=$L.$x;
$vv=$l." ".$x;
var_module($d,$v,$n,$vv,$ZB,$LL,$ll);
}
$l="Room Reverbération";
$L="r";
for ($x=1; $x < 10; $x++ ) {
$v=$L.$x;
$vv=$l." ".$x;
var_module($d,$v,$n,$vv,$ZB,$LL,$ll);
}
}
function zoom_level($l){
global $tpl;
$ll=".zoomlistlevel";
$LL="ZOOMBLEVEL";
$ZB="ZOOM_BLOCK_LEVEL";
$n="zoom_level";
var_module($l,"Of",$n,"Off",$ZB,$LL,$ll);
for ($x=1; $x < 31 ; $x++ ) {
var_module($l,$x,$n,$x,$ZB,$LL,$ll);
}
}
// ouverture de la Base
$db = new Zoom505DB($config);
if (!$db->init()) {
die("Impossible d'initialiser la Base !!!");
}
$tpl = new FastTemplate(".");
$tpl->no_strict();
$tpl->define(array("main" => "zoom505.main.html",
"head" => "zoom505.head.html",
"bas" => "zoom505.bas.html",
"prev" => "zoom505.prev.html",
"suivant" => "zoom505.suiv.html",
"insert" => "zoom505.insert.html",
"valid" => "zoom505.valid.html",
"modif" => "zoom505.modif.html"
));
$tpl->define_dynamic("zoomlist", "main");
if ($modif_patch) {
$tpl->define_dynamic("zoomlistcomp","modif");
$tpl->define_dynamic("zoomlistdist","modif");
$tpl->define_dynamic("zoomlistgain","modif");
$tpl->define_dynamic("zoomlistznramp","modif");
$tpl->define_dynamic("zoomlisteq","modif");
$tpl->define_dynamic("zoomlistlevel","modif");
$tpl->define_dynamic("zoomlistdlyrev","modif");
$tpl->define_dynamic("zoomlistmod","modif");
}
$tpl->assign(array( "PAGETITLE" => $pagetitle,
"PHP_SELF" => $PHP_SELF
));
if (! $nav) { $nav=0;}
$total=$db->get_nrow($recherche);
if ($recherche) {
$r="Recherche sur \"$recherche\" ."; }
else { $r=""; }
$tpl->assign(array(
"ZOOM_MINI" => $nav,
"ZOOM_MAX" => $nav + $NB,
"ZOOM_TOTAL" => $total,
"ZOOM_NAVTOTAL" => $total - $NB,
"ZOOM_NAVP" => $nav - $NB,
"ZOOM_NAVS" => $nav + $NB,
"ZOOM_RECHERCHE" => $r,
"ZOOM_R" => $recherche,
"ZOOM_O" => $order
));
if (! $id && ! $modif_patch ) {
if ( $nav < $NB+1 ) { $db->get_newsrow_init($nav,$NB,$recherche,$order); }
else { $db->get_newsrow_init($nav,$NB,$recherche,$order); }
while ($db_data = $db->get_newsrow($recherche)) {
$zn=htmlspecialchars($db_data["nom"]);
$ID= $db_data["id"];
if ( $modif_patch ) { $znn="$zn \n";}
else { $znn=$zn;}
$tpl->assign(array(
"ZOOM_NOM" => $znn,
"ZOOM_EFFET" => htmlspecialchars($db_data["effet"]),
"ZOOM_COMP" => htmlspecialchars($db_data["comp"]),
"ZOOM_DIST" => htmlspecialchars($db_data["dist"]),
"ZOOM_GAIN" => htmlspecialchars($db_data["gain"]),
"ZOOM_ZNR_AMP" => htmlspecialchars($db_data["znr_amp"]),
"ZOOM_EQ" => htmlspecialchars($db_data["eq"]),
"ZOOM_MOD" => htmlspecialchars($db_data["mod"]),
"ZOOM_DLY_REV" => htmlspecialchars($db_data["dly_rev"]),
"ZOOM_LEVEL" => htmlspecialchars($db_data["level"]),
"ZOOM_ID" => $ID,
"ZOOM_CAT" => htmlspecialchars($db_data["nomcat"])
));
$tpl->parse("ZOOML", ".zoomlist");
}
$tpl->parse("HEAD", "head");
$tpl->parse("MAIN", "main");
if ($nav >= $NB) { $tpl->parse("PREV", "prev"); }
if ($nav < ( $total - $NB )) { $tpl->parse("SUIV", "suivant");}
$tpl->FastPrint("HEAD");
if ($nav >= $NB ) { $tpl->FastPrint("PREV"); }
if ($nav < ($total - $NB )) { $tpl->FastPrint("SUIV"); }
$tpl->FastPrint("MAIN");
if ($nav >= $NB ) { $tpl->FastPrint("PREV"); }
if ($nav < ($total - $NB )) { $tpl->FastPrint("SUIV"); }
}
else {
if ( $id=="new") {
$tpl->parse("INSERT", "insert");
$tpl->FastPrint("INSERT");
}
elseif ( ($id=="val") && ($zoom_nom != "") ) {
$db->insert_patche($zoom_nom,$zoom_effet,$zoom_comp,$zoom_dist,
$zoom_gain,$zoom_znr_amp,$zoom_eq,$zoom_mod,$zoom_dly_rev,$zoom_level);
$tpl->assign(array(
"ZOOM_MSG" => "Inséré !",
"ZOOM_NOM" => $zoom_nom,
"ZOOM_EFFET" => $zoom_effet,
"ZOOM_COMP" => $zoom_comp,
"ZOOM_DIST" => $zoom_dist,
"ZOOM_GAIN" => $zoom_gain,
"ZOOM_ZNR_AMP" => $zoom_znr_amp,
"ZOOM_EQ" => $zoom_eq,
"ZOOM_MOD" => $zoom_mod,
"ZOOM_DLY_REV" => $zoom_dly_rev,
"ZOOM_LEVEL" => $zoom_level
));
$tpl->parse("VALID", "valid");
$tpl->FastPrint("VALID");
}
elseif ( ($id=="modif") && ($zoom_nom != "") ) {
$db->update_patche($patche,$zoom_nom,$zoom_effet,$zoom_comp,$zoom_dist,$zoom_gain,$zoom_znr_amp,$zoom_eq,$zoom_mod,$zoom_dly_rev,$zoom_level);
$tpl->assign(array(
"ZOOM_MSG" => "Modifié !",
"ZOOM_COMP" => $zoom_comp,
"ZOOM_NUM" => $patche,
"ZOOM_NOM" => $zoom_nom,
"ZOOM_EFFET" => $zoom_effet,
"ZOOM_DIST" => $zoom_dist,
"ZOOM_GAIN" => $zoom_gain,
"ZOOM_ZNR_AMP" => $zoom_znr_amp,
"ZOOM_EQ" => $zoom_eq,
"ZOOM_MOD" => $zoom_mod,
"ZOOM_DLY_REV" => $zoom_dly_rev,
"ZOOM_LEVEL" => $zoom_level
));
$tpl->parse("VALID", "valid");
$tpl->FastPrint("VALID");
}
else {
if ( ($id > 0) && ($id <= $total) ) {
$db->get_patche($id);
$db_data=$db->get_newsrow($recherche);
$tpl->assign(array(
"ZOOM_NOM" => htmlspecialchars($db_data["nom"]),
"ZOOM_EFFET" => htmlspecialchars($db_data["effet"]),
"ZOOM_ID" => $db_data["id"]
));
zoom_comp($db_data["comp"]);
zoom_dist($db_data["dist"]);
zoom_gain($db_data["gain"]);
zoom_znr_amp($db_data["znr_amp"]);
zoom_eq($db_data["eq"]);
zoom_mod($db_data["mod"]);
zoom_dly_rev($db_data["dly_rev"]);
zoom_level($db_data["level"]);
$tpl->parse("MODIF", "modif");
$tpl->FastPrint("MODIF");
}
}
}
if ( $modif_patch) {
$tpl->assign(array(
"ZOOM_NOUVEAU_PATCH" => "Nouveau Patche " ));
}
else { $tpl->assign(array(
"ZOOM_NOUVEAU_PATCH" => "" ));
}
$tpl->parse("BAS", "bas");
$tpl->FastPrint("BAS");
?>