HB9EIK	Courses	Speech	Projects	Photos	Code	My Profile
2013-03-28 Easter Egg 2011-06-12 OpenGL Radio Interface 2010-08-07 "Analog" encoder 2010-06-18 MyLinScope V4.0 code 2009-02-16 MyLinScope V2 screenshots 2009-02-15 MyLinScope V2 code 2008-05-24 MySqlManager code 2008-05-22 MyLinScope code 2008-05-19 MyLinScope Screenshots	$version="2008-05-21 v6.1"; class Dxf_table_management { // general var $id; // configuration tables and columns name var $user_table; var $user_login; var $user_passwd; var $user_name; var $user_langue; var $user_linestyle; var $user_buttonstyle; var $user_breakable; var $user_contesto; var $procedure_table_name; var $procedure_sequence_name; var $procedure_name; var $procedure_description; var $procedure_startup; var $procedure_langue; var $procedure_header; var $db_table_num; var $db_langue_name; var $user_level; var $db_level; var $db_linestyle; var $db_buttonstyle; var $db_breakable; var $db_contesto; var $db_langue; // langue setup var $insert; var $delete; var $update; var $db_proc_name; var $db_proc_ref; // other columns to manage various tables hints // the following items define column names for table var $db_table; var $db_table_name; var $db_table_descr; var $db_table_short; var $db_table_progress; var $db_table_use; var $db_table_order; var $db_table_seldisplay; var $db_table_postinsert; var $db_table_postupdate; var $db_table_postdelete; var $db_table_postcondit; var $db_column; var $db_column_name; var $db_column_descr; var $db_column_type; var $db_column_length; var $db_column_short; var $db_column_view; var $db_column_operator; var $db_column_lkup_use; var $db_column_lkup_tbl; var $db_column_lkup_col; var $db_column_lkup_alt; var $db_column_lkup_dis; var $db_column_lkup_lan; var $db_column_ext_col; var $db_column_ext_from; var $db_column_main_index; var $db_column_selection; var $db_column_default; var $db_column_protected; var $db_column_base; var $db_column_urlbase; var $db_column_progress; var $db_column_main_field; var $db_column_rule; var $db_column_selez; // info for db connection (we can search on many different db, more than we can manage) var $db_host; var $db_user; var $db_password; var $db_name; var $db_conn_table; var $db_conn_hostname; var $db_conn_username; var $db_conn_passwd; var $db_conn_dbname; var $db_conn_conname; var $db_conn_rank; // columns for internazionalisation var $db_name_table; var $db_name_langue; var $db_name_see; var $db_name_not_see; var $db_name_insert; var $db_name_update; var $db_name_delete; var $db_name_search; var $db_name_clear; var $db_name_action; var $db_name_go; var $db_name_auto; var $db_name_unavail; var $db_auth_realm; var $db_access_denied; var $db_auth_failure; var $db_auth_instruct; var $db_start_list; var $db_name_prec; var $db_name_segu; var $db_max_list; var $db_name_home; var $db_name_back; var $db_name_proc; var $db_name_giveup; var $db_name_error; var $db_name_index; var $db_name_title; var $db_lunghezza; var $db_name_id; var $db_name_link; var $db_host_link; // connection variables var $conn_number; var $conn_hostname; var $conn_username; var $conn_passwd; var $conn_dbname; var $conn_conname; // query operator variable var $db_operator_table; var $db_operator_langue; var $db_operator; var $db_operator_descr; var $operator; var $operator_descr; var $num_operators; // tables var $num_tables; var $table_name; var $table_value; var $table_short; var $table_use; var $table_order; var $table_seldisplay; var $table_postinsert; var $table_postupdate; var $table_postdelete; var $table_postcondit; var $no_selection; // columns var $num_columns; var $column_name; var $column_value; var $column_type; var $column_length; var $column_short; var $column_view; var $column_operator; var $column_lkup_use; var $column_lkup_tbl; var $column_lkup_col; var $column_lkup_alt; var $column_lkup_dis; var $column_lkup_lan; var $column_ext_col; var $column_ext_from; var $column_main_index; var $column_selection; var $column_default; var $column_protected; var $column_base; var $column_urlbase; var $column_main_field; var $column_rule; var $column_selez; var $column_ext_num; var $column_lkup_num; var $column_lkup_val; // localization var $name_see; var $name_not_see; var $name_insert; var $name_update; var $name_delete; var $name_search; var $name_clear; var $name_action; var $name_go; var $name_auto; var $name_unavail; var $auth_realm; var $access_denied; var $auth_failure; var $auth_instruct; var $name_prec; var $name_segu; var $max_list; var $name_home; var $name_back; var $name_proc; var $name_giveup; var $name_error; var $name_index; var $name_title; var $lunghezza; // form and post handle var $fcall; var $fnum; // lists handling var $start_list; var $stop_list; var $noinput; // db handling var $db; // file handling var $uploadfileurl; // initialization function Dxf_table_management() { // configuration tables and columns name $this->user_table = "people"; // authentication table $this->user_login = "user"; // userid column name $this->user_passwd = "passwd"; // password column name $this->user_name = "name"; // username column name $this->user_langue = "langue"; // user langue column name $this->user_linestyle = "linestyle"; // user rows style column name $this->user_buttonstyle = "buttonstyle"; // user button style column name $this->user_breakable = "breakable"; // user button style column name $this->user_contesto = "contesto"; // user context (may be used to reduce access to a single context) $this->procedure_table_name = "procs"; // procedure description table name $this->procedure_sequence_name = "sequence"; // order sequence $this->procedure_name = "procedura"; // procedure name $this->procedure_description = "descrizione"; // procedure descriprion $this->procedure_startup = "partenza"; // start point of provedure // "start" = normal management // "search" = extended searches $this->procedure_visible = "visibile"; // "yes" means listed, "no" means hidden $this->procedure_authentication = "access"; // access type needed // "manage" to manage data // "search" to look for data // "admin" to manage schema $this->procedure_langue = "langue"; // langue to manage ("it", "en") $this->procedure_url = "url"; // url to manage external procedure $this->procedure_group = "gruppo"; // name to group similar procedures $this->procedure_limited = "limited"; // name to limit procedures $this->db_table_num = "table_num"; $this->db_langue_name = "lingua"; // langue column name $this->user_level = "level"; // user authorization name $this->db_level = "none"; // default authorization level $db_linestyle = ""; // default line style $db_buttonstyle = ""; // default button style $db_breakable = ""; // default breakable lines $db_contesto = ""; // default context (=unlimited) // langue setup $this->insert = "insert"; $this->delete = "delete"; $this->update = "update"; $this->db_proc_name = "procedura"; $this->db_proc_ref = "x_proc_ref"; // other columns to manage various tables hints // the following items define column names for table $this->db_table = "gestioni"; // table-definition table name $this->db_table_name = "tabella"; // table name $this->db_table_descr = "descrizione"; // table description $this->db_table_short = "short"; // table short descriptions $this->db_table_progress = "progress"; // table display sequence into procedure $this->db_table_use = "utilizzo"; // type of management $this->db_table_order = "order_by"; // order-by clause for table management $this->db_table_seldisplay = "seldisplay"; // if yes table must be included into query results $this->db_table_postinsert = "postinsert"; // do something after insert $this->db_table_postupdate = "postupdate"; // do something after update $this->db_table_postdelete = "postdelete"; // do something after delete $this->db_table_postcondit = "postcondit"; // condition to do something $this->db_column = "gestioni_dett"; // column-definition table $this->db_column_name = "colonna"; // column name $this->db_column_descr = "descrizione"; // column description $this->db_column_type = "tipo"; // column type $this->db_column_length = "lunghezza"; // column display length $this->db_column_short = "corta"; // column short description $this->db_column_view = "mostra"; // if 'no' hide column into query result $this->db_column_operator = "ricerca"; // default operator into query $this->db_column_lkup_use = "lookup_usage"; // type of lookup: lookup( ,+,-,+-) or default // lookup: normal lookup // lookup+: list code+lookup // lookup-: non exclusive lookup // lookup+-: non exclusive, list code+lookup // default: to prepare data for insertion $this->db_column_lkup_tbl = "lookup_table"; // table where look for data $this->db_column_lkup_col = "lookup_column"; // column to be esarched $this->db_column_lkup_alt = "lookup_alternate"; // other column as default when inserting) // useful to use another column to prepare a // selection of data on which select the value // for the column (ie alternate for invoice# can be // year to dselect one of the invoices of the year $this->db_column_lkup_dis = "lookup_display"; // column to be displayed $this->db_column_lkup_lan = "lookup_langue"; // langue (for localized tables) $this->db_column_ext_col = "extent_column"; // extent column to be searched $this->db_column_ext_from = "extent_from"; // column on wich extent must be searched $this->db_column_main_index = "main_index"; // main index part number for this column $this->db_column_selection = "selection"; // 0=hidden, non-zero=display $this->db_column_default = "defaul"; // default value // $TODAY means today // $PROX means next value // $USER means user // $USERS means pick one of the users from a list // $BLANK force blanking of a field $this->db_column_protected = "protected"; // protected // yes means protected // auto means protect when inserting (see default) $this->db_column_base = "base"; // base directory for attached documents $this->db_column_urlbase = "urlbase"; // base url for www-display of attached documents $this->db_column_progress = "progress"; // order number for display columns $this->db_column_main_field = "main_field"; // if present, part number of a sort of 'main index' // the columns that describe the procedure // for example: year and number for invoices are // main fields 1,2 of tables for procedure invoices $this->db_column_rule = "regola"; // regex to be checked against insertion and updates $this->db_column_selez = "selezione"; // restriction // '#LANGUE' means that the column contain // info about langue // and we must add where .... column=langue $this->db_column_funzione = "funzione"; // function pre insert/update // query operator variable $this->db_operator_table = 'operatore'; // operator table name $this->db_operator_langue = 'langue'; // langue $this->db_operator = 'operatore'; // operator $this->db_operator_descr = 'descrizione'; // operator description // info for connection (we can search on many different db, more than we can manage) $this->db_conn_table = "conns"; // connection definition table name $this->db_conn_hostname = "host_name"; // host name $this->db_conn_username = "user_name"; // user name for authentication $this->db_conn_passwd = "passwd"; // password for authentication $this->db_conn_dbname = "db_name"; // database name $this->db_conn_conname = "conn_name"; // connection name (for display) $this->db_conn_rank = "rank"; // order of connection // columns for internazionalisation $this->db_name_table = "parole"; // table 'parole' contains a row for // each usable language $this->db_name_langue = "langue"; // language name column $this->db_name_see = "visualizza"; // column with translation for 'display' $this->db_name_not_see = "nascondi"; // column with translation for 'hide' $this->db_name_insert = "inserisci"; // column with translation for 'insert' $this->db_name_update = "aggiorna"; // column with translation for 'update' $this->db_name_delete = "cancella"; // column with translation for 'delete' $this->db_name_search = "ricerca"; // column with translation for 'search' $this->db_name_clear = "azzera"; // column with translation for 'clear' $this->db_name_action = "azione"; // column with translation for 'go!' $this->db_name_go = "procedi"; // column with translation for 'go!' $this->db_name_auto = "auto"; // column with translation for 'auto' $this->db_name_unavail = "unavail"; // column with translation for 'unavailable' $this->db_auth_realm = "gruppo"; // column with translation for 'group' $this->db_access_denied = "acce_den"; // column with translation for 'access denied' $this->db_auth_failure = "auth_fail"; // column with translation for 'authorizationFailed' $this->db_auth_instruct = "istruzioni"; // column with translation for retry authentication $this->db_start_list = "start_list"; // column with translation for '' $this->db_name_prec = "precedente"; // column with translation for 'previous' $this->db_name_segu = "seguente"; // column with translation for 'next' $this->db_max_list = "massimo"; // column with translation for '' $this->db_name_home = "casa"; // column with translation for 'home' $this->db_name_back = "indietro"; // column with translation for 'back' $this->db_name_proc = "proc"; // column with translation for 'proc' $this->db_name_giveup = "annulla"; // column with translation for 'giveup' $this->db_name_error = "errore"; // column with translation for 'error' $this->db_name_index = "invalidkey"; // column with translation for 'Non unique index' $this->db_name_title = "titolo"; // column with title for site $this->db_lunghezza = "lunghezza"; // column with title for max input length // connection variables $this->conn_number = 0; $this->conn_hostname; // form and post handle $this->db_name_id = "ajax_id"; // Name of POST variable with DIV id $this->db_name_link = "LINK"; // Name of POST variable with phase to perform $this->db_host_link = "http"; // Content of POST variable with LINK id if( isset( $_SERVER['HTTPS'] ) ) { $this->db_host_link .= "s"; } $this->db_host_link .= "://" . $_SERVER['SERVER_NAME'] . "/"; $this->fcall = 'DXF'; $this->fnum = 0; // lists handling $this->start_list = 0 ; $this->stop_list = 0 ; } // db_config : Database connection and selection function db_config () { $this->db = mysql_connect($this->db_host, $this->db_user, $this->db_password) or die(mysql_error()); if ($this->db == FALSE) { die ("Error connecting to database. Please contact the site administrator."); } // mysql_query('set character set utf8',$this->db); mysql_select_db($this->db_name, $this->db) or die ("Error selecting database. Please contact the site administrator."); return( $this->db ); } // tbl_config : main configuration routine function tbl_config ( $needed_level, $db_proc ) { $debug = 0; $db=$this->db_config(); // id is the div identifier for Ajax if( $_POST ) { if( isset( $_POST[$this->db_name_id] ) ) { $this->id=$_POST[$this->db_name_id]; } } // langue setup $this->db_langue = "it"; if( isset( $_POST[$this->db_langue_name] ) ) { $this->db_langue = $_POST[$this->db_langue_name]; } // Procedure identifies which tables must be managed together $this->db_proc = $db_proc; if( $_POST ) { if( isset( $_POST[$this->db_proc_ref] ) ) { $this->db_proc = $_POST[$this->db_proc_ref]; } } if( !isset( $this->db_proc ) ) { $this->db_proc = "Reg"; } // select connections $query0 = "select $this->db_conn_hostname, "; $query0 .= "$this->db_conn_username, "; $query0 .= "$this->db_conn_passwd, "; $query0 .= "$this->db_conn_dbname, "; $query0 .= "$this->db_conn_conname, "; $query0 .= "$this->db_conn_rank "; $query0 .= "from $this->db_conn_table "; $query0 .= "order by $this->db_conn_rank"; $result0 = mysql_query( $query0 ) or die("Query a failed: " . $query0 . " " . mysql_error()); $this->conn_number=0; for( $table_num=0; $line0 = mysql_fetch_assoc( $result0 ); $table_num++ ) { $this->conn_number=$table_num; $this->conn_hostname[$table_num] = $line0["$this->db_conn_hostname"]; $this->conn_username[$table_num] = $line0["$this->db_conn_username"]; $this->conn_passwd[$table_num] = $line0["$this->db_conn_passwd"]; $this->conn_dbname[$table_num] = $line0["$this->db_conn_dbname"]; $this->conn_conname[$table_num] = $line0["$this->db_conn_conname"]; } mysql_free_result( $result0 ); // look for internazionalisation $this->tbl_words(); if( $needed_level == '' ) { return; } // make login $this->tbl_login( $needed_level ); // look for internazionalisation again $this->tbl_words(); // look for query operator variable $query = "select $this->db_operator, $this->db_operator_descr from $this->db_operator_table "; $query .= "where $this->db_operator_langue = '" . $this->db_langue . "' order by 2;"; if( $debug ) { echo $query . "<br>\n"; } $result = mysql_query( $query ) or die("Query failed: " . $query . " - " . mysql_error()); for( $operator_num=0; $line = mysql_fetch_assoc( $result ); $operator_num++ ) { $this->num_operators = $operator_num; $this->operator[$operator_num] = $line[$this->db_operator]; $this->operator_descr[$operator_num] = $line[$this->db_operator_descr]; } // look for table data $query = "select $this->db_table_name, "; $query .= "$this->db_table_descr, "; $query .= "$this->db_table_short, "; $query .= "$this->db_table_progress, "; $query .= "$this->db_table_use, "; $query .= "$this->db_table_order, "; $query .= "$this->db_table_seldisplay, "; $query .= "$this->db_table_postinsert, "; $query .= "$this->db_table_postupdate, "; $query .= "$this->db_table_postdelete, "; $query .= "$this->db_table_postcondit "; $query .= "from $this->db_table "; $query .= "where $this->db_proc_name = '$this->db_proc' "; $query .= "and $this->db_langue_name = '" . $this->db_langue . "' "; $query .= "order by $this->db_table_progress"; if( $debug ) { echo $query . "<br>\n"; } $result = mysql_query( $query ) or die("Query b failed: " . $query . " - " . mysql_error()); for( $table_num=0; $line = mysql_fetch_assoc( $result ); $table_num++ ) { $this->num_tables = $table_num; $this->table_name[$table_num] = $line[$this->db_table_name]; $this->table_value[$table_num] = $line[$this->db_table_descr]; $this->table_short[$table_num] = $line[$this->db_table_short]; $this->table_use[$table_num] = $line[$this->db_table_use]; $this->table_order[$table_num] = $line[$this->db_table_order]; $this->table_seldisplay[$table_num] = $line[$this->db_table_seldisplay]; $this->table_postinsert[$table_num] = $line[$this->db_table_postinsert]; $this->table_postupdate[$table_num] = $line[$this->db_table_postupdate]; $this->table_postdelete[$table_num] = $line[$this->db_table_postdelete]; $this->table_postcondit[$table_num] = $line[$this->db_table_postcondit]; // look for columns data $query1 = "select $this->db_column_name, "; $query1 .= "$this->db_column_descr, "; $query1 .= "$this->db_column_type, "; $query1 .= "$this->db_column_length, "; $query1 .= "$this->db_column_short, "; $query1 .= "$this->db_column_view, "; $query1 .= "$this->db_column_operator, "; $query1 .= "$this->db_column_lkup_use, "; $query1 .= "$this->db_column_lkup_tbl, "; $query1 .= "$this->db_column_lkup_col, "; $query1 .= "$this->db_column_lkup_dis, "; $query1 .= "$this->db_column_lkup_lan, "; $query1 .= "$this->db_column_ext_col, "; $query1 .= "$this->db_column_ext_from, "; $query1 .= "$this->db_column_lkup_alt, "; $query1 .= "$this->db_column_main_index, "; $query1 .= "$this->db_column_selection, "; $query1 .= "$this->db_column_default, "; $query1 .= "$this->db_column_protected, "; $query1 .= "$this->db_column_base, "; $query1 .= "$this->db_column_urlbase, "; $query1 .= "$this->db_column_progress, "; $query1 .= "$this->db_column_main_field, "; $query1 .= "$this->db_column_rule, "; $query1 .= "$this->db_column_selez, "; $query1 .= "$this->db_column_funzione "; $query1 .="from $this->db_column "; $query1 .= "where $this->db_table_name = '" . $this->table_name[$table_num] . "' "; $query1 .= "and $this->db_langue_name = '$this->db_langue'"; $query1 .= "order by $this->db_column_progress"; if( $debug ) { echo $query1 . "<br>\n"; } $result1 = mysql_query( $query1 ) or die("Query1 failed : " . mysql_error()); $this->no_selection=0; for( $column_nr=0; $line1 = mysql_fetch_assoc( $result1 ); $column_nr++ ) { $this->num_columns[$table_num] = $column_nr; $this->column_name[$table_num][$column_nr] = $line1[$this->db_column_name]; $this->column_value[$table_num][$column_nr] = $line1[$this->db_column_descr]; $this->column_type[$table_num][$column_nr] = $line1[$this->db_column_type]; $this->column_length[$table_num][$column_nr] = $line1[$this->db_column_length]; $this->column_short[$table_num][$column_nr] = $line1[$this->db_column_short]; $this->column_view[$table_num][$column_nr] = $line1[$this->db_column_view]; $this->column_operator[$table_num][$column_nr] = $line1[$this->db_column_operator]; $this->column_lkup_use[$table_num][$column_nr] = $line1[$this->db_column_lkup_use]; $this->column_lkup_tbl[$table_num][$column_nr] = $line1[$this->db_column_lkup_tbl]; $this->column_lkup_col[$table_num][$column_nr] = $line1[$this->db_column_lkup_col]; $this->column_lkup_alt[$table_num][$column_nr] = $line1[$this->db_column_lkup_alt]; $this->column_lkup_dis[$table_num][$column_nr] = $line1[$this->db_column_lkup_dis]; $this->column_lkup_lan[$table_num][$column_nr] = $line1[$this->db_column_lkup_lan]; $this->column_ext_col[$table_num][$column_nr] = $line1[$this->db_column_ext_col]; $this->column_ext_from[$table_num][$column_nr] = $line1[$this->db_column_ext_from]; $this->column_main_index[$table_num][$column_nr] = $line1[$this->db_column_main_index]; $this->column_selection[$table_num][$column_nr] = $line1[$this->db_column_selection]; $this->column_default[$table_num][$column_nr] = $line1[$this->db_column_default]; $this->column_protected[$table_num][$column_nr] = $line1[$this->db_column_protected]; $this->column_base[$table_num][$column_nr] = $line1[$this->db_column_base]; $this->column_urlbase[$table_num][$column_nr] = $line1[$this->db_column_urlbase]; $this->column_main_field[$table_num][$column_nr] = $line1[$this->db_column_main_field]; $this->column_rule[$table_num][$column_nr] = $line1[$this->db_column_rule]; $this->column_selez[$table_num][$column_nr] = $line1[$this->db_column_selez]; $this->column_funzione[$table_num][$column_nr] = $line1[$this->db_column_funzione]; $this->column_ext_num[$table_num][$column_nr] = -1; $this->column_lkup_num[$table_num][$column_nr] = -1; $this->column_lkup_val[$table_num][$column_nr] = ''; if( $this->column_selection[$table_num][$column_nr] > 0 ) { $this->no_selection++; } } // look for extended lookup from colum (to get the value) for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_ext_from[$table_num][$column_nr] ) { for( $n=0; $n<=$this->num_columns[$table_num]; $n++ ) { if( $this->column_ext_from[$table_num][$column_nr] == $this->column_name[$table_num][$n] ) { $this->column_ext_num[$table_num][$column_nr] = $n; break; } } } } // look for alternate lookup from colum (to get the value) for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_lkup_alt[$table_num][$column_nr] ) { for( $n=0; $n<=$this->num_columns[$table_num]; $n++ ) { if( $this->column_lkup_alt[$table_num][$column_nr] == $this->column_name[$table_num][$n] ) { $this->column_lkup_num[$table_num][$column_nr] = $n; break; } } } } mysql_free_result($result1); } mysql_free_result($result); // procedure name $query = "select " . $this->procedure_sequence_name . ", "; $query .= $this->procedure_name . ", " . $this->procedure_description . ", "; $query .= $this->procedure_startup . ", " . $this->procedure_visible . ", "; $query .= $this->procedure_authentication . ", "; $query .= $this->procedure_url . ", " . $this->procedure_group . ", "; $query .= $this->procedure_url . ", " . $this->procedure_limited; $query .= " from " . $this->procedure_table_name . " where "; $query .= $this->procedure_name . "='" . $this->db_proc . "' "; $query .= " and " . $this->procedure_langue . "='"; $query .= $this->db_langue; $query .= "' order by " . $this->procedure_sequence_name; $result = mysql_query( $query ) or die("Query PRE failed: " . $query . " " . mysql_error()); if( $result ) { $line = mysql_fetch_assoc( $result ); $this->procedure_header = $line[$this->procedure_description]; } mysql_free_result($result); // head data echo "<HEAD>\n"; echo "<TITLE>SGQ</TITLE>\n"; echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"dr_style.css\" >\n"; echo "</HEAD>\n"; echo "<BODY>\n"; // debug data if( $debug ) { echo "No selection = " . $this->no_selection . "<br>\n"; echo "<table border=1>\n"; for( $table_num=0; $table_num<=$this->conn_number; $table_num++ ) { echo "<tr><td>" . $this->db_conn_hostname; echo "</td><td>" . $this->conn_hostname[$table_num]; echo "</td></tr>"; echo "<tr><td>" . $this->db_conn_username; echo "</td><td>" . $this->conn_username[$table_num]; echo "</td></tr>"; echo "<tr><td>" . $this->db_conn_passwd; echo "</td><td>" . $this->conn_passwd[$table_num]; echo "</td></tr>"; echo "<tr><td>" . $this->db_conn_dbname; echo "</td><td>" . $this->conn_dbname[$table_num]; echo "</td></tr>"; echo "<tr><td>" . $this->db_conn_conname; echo "</td><td>" . $this->conn_conname[$table_num]; echo "</td></tr>"; } echo "</table>\n"; echo $this->name_see . "<br>\n"; echo $this->name_not_see . "<br>\n"; echo $this->name_insert . "<br>\n"; echo $this->name_update . "<br>\n"; echo $this->name_delete . "<br>\n"; echo $this->name_search . "<br>\n"; echo $this->name_clear . "<br>\n"; echo $this->name_action . "<br>\n"; echo $this->name_go . "<br>\n"; echo $this->name_auto . "<br>\n"; echo $this->name_unavail . "<br>\n"; echo $this->auth_realm . "<br>\n"; echo $this->access_denied . "<br>\n"; echo $this->auth_failure . "<br>\n"; echo $this->auth_instruct . "<br>\n"; echo $this->name_prec . "<br>\n"; echo $this->name_segu . "<br>\n"; echo $this->max_list . "<br>\n"; echo $this->name_home . "<br>\n"; echo $this->name_back . "<br>\n"; echo $this->name_proc . "<br>\n"; echo $this->name_giveup . "<br>\n"; echo $this->name_error . "<br>\n"; echo $this->name_index . "<br>\n"; echo $this->name_title . "<br>\n"; echo $this->lunghezza . "<br>\n"; for( $table_num=0; $table_num<=$this->num_tables; $table_num++ ) { echo "Table <B>" . $this->table_name[$table_num] . "</B><br>\n"; echo "<table border=1>\n"; echo "<tr><td>" . $this->db_table_name; echo "</td><td>" . $this->table_name[$table_num]; echo "</td></tr>"; echo "<tr><td>" . $this->db_table_descr; echo "</td><td>" . $this->table_value[$table_num]; echo "</td></tr>"; echo "<tr><td>" . $this->db_table_short; echo "</td><td>" . $this->table_short[$table_num]; echo "</td></tr>"; echo "<tr><td>" . $this->db_table_use; echo "</td><td>" . $this->table_use[$table_num]; echo "</td></tr>"; echo "<tr><td>" . $this->db_table_order; echo "</td><td>" . $this->table_order[$table_num]; echo "</td></tr>"; echo "<tr><td>" . $this->db_table_seldisplay; echo "</td><td>" . $this->table_seldisplay[$table_num]; echo "</td></tr>"; echo "<tr><td>" . $this->db_table_postinsert; echo "</td><td>" . $this->table_postinsert[$table_num]; echo "</td></tr>"; echo "<tr><td>" . $this->db_table_postupdate; echo "</td><td>" . $this->table_postupdate[$table_num]; echo "</td></tr>"; echo "<tr><td>" . $this->db_table_postdelete; echo "</td><td>" . $this->table_postdelete[$table_num]; echo "</td></tr>"; echo "<tr><td>" . $this->db_table_postcondit; echo "</td><td>" . $this->table_postcondit[$table_num]; echo "</td></tr>"; echo "</table>\n"; echo "<table border=1>\n"; echo "<tr>"; echo "<td>" . " " . $this->db_column_name . "</td>\n"; echo "<td>" . " " . $this->db_column_name . "</td>\n"; echo "<td>" . " " . $this->db_column_type . "</td>\n"; echo "<td>" . " " . $this->db_column_length . "</td>\n"; echo "<td>" . " " . $this->db_column_short . "</td>\n"; echo "<td>" . " " . $this->db_column_view . "</td>\n"; echo "<td>" . " " . $this->db_column_operator . "</td>\n"; echo "<td>" . " " . $this->db_column_lkup_use . "</td>\n"; echo "<td>" . " " . $this->db_column_lkup_tbl . "</td>\n"; echo "<td>" . " " . $this->db_column_lkup_col . "</td>\n"; echo "<td>" . " " . $this->db_column_lkup_alt . "</td>\n"; echo "<td>" . " " . $this->db_column_lkup_dis . "</td>\n"; echo "<td>" . " " . $this->db_column_lkup_lan . "</td>\n"; echo "<td>" . " " . $this->db_column_ext_col . "</td>\n"; echo "<td>" . " " . $this->db_column_ext_from . "</td>\n"; echo "<td>" . " " . $this->db_column_ext_from . "</td>\n"; echo "<td>" . " " . $this->db_column_main_index . "</td>\n"; echo "<td>" . " " . $this->db_column_selection . "</td>\n"; echo "<td>" . " " . $this->db_column_default . "</td>\n"; echo "<td>" . " " . $this->db_column_protected . "</td>\n"; echo "<td>" . " " . $this->db_column_base . "</td>\n"; echo "<td>" . " " . $this->db_column_urlbase . "</td>\n"; echo "<td>" . " " . $this->db_column_main_field . "</td>\n"; echo "<td>" . " " . $this->db_column_rule . "</td>\n"; echo "<td>" . " " . $this->db_column_selez . "</td>\n"; echo "<td>" . " " . $this->db_column_funzione . "</td>\n"; echo "</tr>\n"; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { echo "<tr>"; echo "<td>" . " " . $this->column_name[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_value[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_type[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_length[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_short[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_view[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_operator[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_lkup_use[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_lkup_tbl[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_lkup_col[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_lkup_num[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_lkup_dis[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_lkup_lan[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_ext_col[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_ext_from[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_ext_num[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_main_index[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_selection[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_default[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_protected[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_base[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_urlbase[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_main_field[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_rule[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_selez[$table_num][$column_nr] . "</td>\n"; echo "<td>" . " " . $this->column_funzione[$table_num][$column_nr] . "</td>\n"; echo "</tr>\n"; } echo "</table>\n"; } } /* to allow different table configuration we can use table name prefixed with spaces */ for( $j=0; $j<$table_num; $j++ ) { $this->table_name[$j] = ltrim($this->table_name[$j]); } } // select keywords / translations function tbl_words() { $query0 = "select $this->db_name_not_see, "; $query0 .= "$this->db_name_see, "; $query0 .= "$this->db_name_insert, "; $query0 .= "$this->db_name_update, "; $query0 .= "$this->db_name_delete, "; $query0 .= "$this->db_name_search, "; $query0 .= "$this->db_name_clear, "; $query0 .= "$this->db_name_action, "; $query0 .= "$this->db_name_go, "; $query0 .= "$this->db_auth_realm, "; $query0 .= "$this->db_access_denied, "; $query0 .= "$this->db_auth_failure, "; $query0 .= "$this->db_auth_instruct, "; $query0 .= "$this->db_name_unavail, "; $query0 .= "$this->db_name_auto, "; $query0 .= "$this->db_name_prec, "; $query0 .= "$this->db_name_segu, "; $query0 .= "$this->db_max_list, "; $query0 .= "$this->db_name_home, "; $query0 .= "$this->db_name_back, "; $query0 .= "$this->db_name_proc, "; $query0 .= "$this->db_name_giveup, "; $query0 .= "$this->db_name_error, "; $query0 .= "$this->db_name_index, "; $query0 .= "$this->db_name_title, "; $query0 .= "$this->db_lunghezza "; $query0 .= "from $this->db_name_table "; $query0 .= "where $this->db_name_langue = '$this->db_langue'"; $result0 = mysql_query( $query0 ) or die("Query c failed: " . $query . " - " . mysql_error()); $line0 = mysql_fetch_assoc( $result0 ); $this->name_see = $line0[$this->db_name_see]; $this->name_not_see = $line0[$this->db_name_not_see]; $this->name_insert = $line0[$this->db_name_insert]; $this->name_update = $line0[$this->db_name_update]; $this->name_delete = $line0[$this->db_name_delete]; $this->name_search = $line0[$this->db_name_search]; $this->name_clear = $line0[$this->db_name_clear]; $this->name_action = $line0[$this->db_name_action]; $this->name_go = $line0[$this->db_name_go]; $this->name_auto = $line0[$this->db_name_auto]; $this->name_unavail = $line0[$this->db_name_unavail]; $this->auth_realm = $line0[$this->db_auth_realm]; $this->access_denied = $line0[$this->db_access_denied]; $this->auth_failure = $line0[$this->db_auth_failure]; $this->auth_instruct = $line0[$this->db_auth_instruct]; $this->name_prec = $line0[$this->db_name_prec]; $this->name_segu = $line0[$this->db_name_segu]; $this->max_list = $line0[$this->db_max_list]; $this->name_home = $line0[$this->db_name_home]; $this->name_back = $line0[$this->db_name_back]; $this->name_proc = $line0[$this->db_name_proc]; $this->name_giveup = $line0[$this->db_name_giveup]; $this->name_error = $line0[$this->db_name_error]; $this->name_index = $line0[$this->db_name_index]; $this->name_title = $line0[$this->db_name_title]; $this->lunghezza = $line0[$this->db_lunghezza]; mysql_free_result( $result0 ); } // tbl_login - verify user and password function tbl_login( $needed_level ) { if ( !isset($_POST[$this->db_name_id]) && ( !isset($_SERVER['PHP_AUTH_USER']) || !isset($_SERVER['PHP_AUTH_PW']) ) ) { $this->displayLogin( $this->auth_realm, $this->access_denied, $this->auth_failure, $this->auth_instruct ); } else { if ( isset($_POST[$this->db_name_id]) ) { // $PHP_AUTH_USER = addslashes( 'hb9eik' ); // $PHP_AUTH_PW = md5( 'iw2qdniw3dxf' ); } else { $PHP_AUTH_USER = addslashes( $_SERVER['PHP_AUTH_USER'] ); $PHP_AUTH_PW = md5( $_SERVER['PHP_AUTH_PW'] ); } $query0 = "SELECT $this->user_name, "; $query0 .= "$this->user_langue, "; $query0 .= "$this->user_level, "; $query0 .= "$this->user_linestyle, "; $query0 .= "$this->user_buttonstyle, "; $query0 .= "$this->user_breakable, "; $query0 .= "$this->user_contesto "; $query0 .= "FROM $this->user_table "; $query0 .= "WHERE $this->user_login='$PHP_AUTH_USER' "; $query0 .= "AND $this->user_passwd='$PHP_AUTH_PW'"; $result = mysql_query( $query0 ) or die( mysql_error() ); $user_data = mysql_fetch_assoc( $result ); if( !$user_data ) { $this->displayLogin( $this->auth_realm, $this->access_denied, $this->auth_failure, $this->auth_instruct ); } $this->db_langue = $user_data[$this->user_langue]; $this->db_level = $user_data[$this->user_level]; $this->db_linestyle = $user_data[$this->user_linestyle]; $this->db_buttonstyle = $user_data[$this->user_buttonstyle]; $this->db_breakable = $user_data[$this->user_breakable]; $this->db_contesto = $user_data[$this->user_contesto]; if( $this->db_level != $needed_level ) { $this->displayLogin( $this->auth_realm, $this->access_denied, $this->auth_failure, $this->auth_instruct ); } mysql_free_result( $result ); } } // Asks for authentication. Included at every page from tbl_config function displayLogin( $auth_realm, $access_denied, $auth_failure, $auth_instruct ) { $realm = "WWW-Authenticate: Basic realm=" . $auth_realm; header( $realm ); header( "HTTP/1.0 401 Unauthorized" ); echo "<HTML>\n"; echo "<HEAD><TITLE>$access_denied</TITLE></HEAD>\n"; echo "<BODY>\n"; echo "<H2>$auth_failure</H2>\n"; echo $auth_instruct . "\n"; echo "</BODY>\n"; exit; } // Create table query function tableQueryCreate( $table_num ) { $query = 'select '; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { $query .= $this->column_name[$table_num][$column_nr]; if( $column_nr<$this->num_columns[$table_num] ) { $query .= ', '; } } $query .= ' from ' . $this->table_name[$table_num]; $query1 = ""; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_selection[$table_num][$column_nr]>0 ) { $column_select[$column_nr] = $_POST[$this->column_name[$table_num][$column_nr]]; if( $column_select[$column_nr] ) { if( $query1 ) { $query1 .= " and "; } $query1 .= $this->column_name[$table_num][$column_nr]; $query1 .= "='"; $query1 .= $column_select[$column_nr]; $query1 .= "'"; } } else { if ( $this->column_selez[$table_num][$column_nr] == "#LANGUE" ) { if( $query1 ) { $query1 .= " and "; } $query1 .= $this->column_name[$table_num][$column_nr]; $query1 .= "='"; $query1 .= $this->db_langue; $query1 .= "'"; } if ( $this->column_selez[$table_num][$column_nr] == "#CONTEXT" && $this->db_contesto !="" ) { if( $query1 ) { $query1 .= " and "; } $query1 .= $this->column_name[$table_num][$column_nr]; $query1 .= "='"; $query1 .= $this->db_contesto; $query1 .= "'"; } } } if( $query1 ) { $query .= " where " . $query1; } if( $this->table_order[$table_num] ) { $query .= " order by " . $this->table_order[$table_num]; } $result = mysql_query( $query ) or die("Query failed xx: " . $query . " " . mysql_error()); return( $result ); } // Create startup query function startQueryCreate() { $where=""; $order=""; $query=""; for( $column_nr=0; $column_nr<=$this->num_columns[0]; $column_nr++ ) { if( $this->column_selection[0][$column_nr]>0 ) { if( strlen( $order ) ) { $order .= ", "; } $order = $order . $this->column_name[0][$column_nr]; if( strlen( $query ) ) { $query .= ", "; } $query = $query . $this->column_name[0][$column_nr]; } if( $this->column_main_field[0][$column_nr]>0 ) { if( strlen( $query ) ) { $query .= ", "; } $query = $query . $this->column_name[0][$column_nr]; } if( $this->column_selez[0][$column_nr]=="#LANGUE" ) { if( strlen( $where ) ) { $where .= " and "; } $where .= $this->column_name[0][$column_nr]; $where .= "='"; $where .= $this->db_langue; $where .= "'"; } if ( $this->column_selez[0][$column_nr] == "#CONTEXT" && $this->db_contesto !="" ) { if( strlen( $where ) ) { $where .= " and "; } $where .= $this->column_name[0][$column_nr]; $where .= "='"; $where .= $this->db_contesto; $where .= "'"; } } if( strlen( $query ) ) { $query = "select $query from " . $this->table_name[0]; if( strlen( $where ) ) { $query .= " where " . $where ; } if( strlen( $order ) ) { $query .= " order by $order"; } $result = mysql_query( $query ) or die("Query d failed: $query " . mysql_error()); } else { return( "" ); } return( $result ); } // Prepare start page header function startPageHeader() { echo "<TR>"; for( $column_nr=0, $jj=0; $column_nr<=$this->num_columns[0]; $column_nr++ ) { if ( $this->column_selez[0][$column_nr] == "#LANGUE" ) { $jj=1; break; } if ( $this->column_selez[0][$column_nr] == "#CONTEXT" && $this->db_contesto !="" ) { $jj=1; break; } } for( $column_nr=0; $column_nr<=$this->num_columns[0]; $column_nr++ ) { if( $column_nr== 0 ) { echo "<TD id=\"listhea\">"; if( $jj ) { echo "<center> " . $this->db_langue_name . " = " . $this->db_langue . " </center>\n"; } else { echo " "; } echo "</TD>"; } if( $this->column_selection[0][$column_nr]>0 ) { echo "<TD id=\"listhea\">"; echo $this->column_short[0][$column_nr]; echo "</TD>"; } else { if( $this->column_main_field[0][$column_nr]>0 ) { echo "<TD id=\"listhea\">"; echo $this->column_short[0][$column_nr]; echo "</TD>"; } } } return( $jj ); } // Buttons function dxfButton( $link, $name, $complete, $from, $table_num, $uscita ) { $iidd = "STAND"; if( isset( $this->id ) ) { $iidd = $this->id; } if( $uscita !="" ) { $prtuscita=0; } else { $prtuscita=1; } if( $link != "Submit" ) { $this->fnum++; // echo "<FORM NAME=\"" . $iidd . $this->table_name[0] . $this->fcall . $this->fnum ."\" "; // echo $this->db_name_id . "=\"" . $iidd . $this->table_name[0] . $this->fcall . $this->fnum ."\" "; // echo "METHOD=\"POST\" ENCTYPE=\"multipart/form-data\""; $uscita .= "<FORM NAME=\"" . $iidd . $this->table_name[0] . $this->fcall . $this->fnum ."\" "; $uscita .= $this->db_name_id . "=\"" . $iidd . $this->table_name[0] . $this->fcall . $this->fnum ."\" "; $uscita .= "METHOD=\"POST\" ENCTYPE=\"multipart/form-data\""; if( !isset( $this->id ) ) { // echo " ACTION=\"" . $this->db_host_link . ltrim( $_SERVER['PHP_SELF'], '/' ) . "\">\n"; $uscita .= " ACTION=\"" . $this->db_host_link . ltrim( $_SERVER['PHP_SELF'], '/' ) . "\">\n"; } else { // echo " ACTION=\"javascript:ajaxHTTPHandler('"; // echo $this->id; // echo "','"; // echo $this->db_host_link . ltrim( $_SERVER['PHP_SELF'], '/' ); // echo "',document.getElementById('"; // echo $this->id . $this->table_name[0] . $this->fcall . $this->fnum; // echo "'));\">\n"; $uscita .= " ACTION=\"javascript:ajaxHTTPHandler('"; $uscita .= $this->id; $uscita .= "','"; $uscita .= $this->db_host_link . ltrim( $_SERVER['PHP_SELF'], '/' ); $uscita .= "',document.getElementById('"; $uscita .= $this->id . $this->table_name[0] . $this->fcall . $this->fnum; $uscita .= "'));\">\n"; } // echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_name_link . "\" VALUE=\"" . $link . "\">\n"; $uscita .= "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_name_link . "\" VALUE=\"" . $link . "\">\n"; // echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_table_num . "\" VALUE=\"" . $table_num . "\">\n"; // echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_proc_ref . "\" VALUE=\"" . $this->db_proc . "\">\n"; // echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_langue_name . "\" VALUE=\"" . $this->db_langue . "\">\n"; $uscita .= "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_table_num . "\" VALUE=\"" . $table_num . "\">\n"; $uscita .= "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_proc_ref . "\" VALUE=\"" . $this->db_proc . "\">\n"; $uscita .= "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_langue_name . "\" VALUE=\"" . $this->db_langue . "\">\n"; if( $complete == "index" || $complete == "delete" ) { // echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_langue_name . "\" VALUE=\"" . $this->db_langue . "\">\n"; $uscita .= "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_langue_name . "\" VALUE=\"" . $this->db_langue . "\">\n"; if( $complete == "delete" ) { // echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->delete; // echo "\" VALUE=\"" . $this->delete . "\">\n"; $uscita .= "<INPUT TYPE=\"hidden\" NAME=\"" . $this->delete; $uscita .= "\" VALUE=\"" . $this->delete . "\">\n"; } for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_main_index[$table_num][$column_nr]>0 ) { // echo "<INPUT TYPE=\"hidden\" NAME=\""; // echo $this->column_name[$table_num][$column_nr]; // echo "\" VALUE=\""; $uscita .= "<INPUT TYPE=\"hidden\" NAME=\""; $uscita .= $this->column_name[$table_num][$column_nr]; $uscita .= "\" VALUE=\""; if( $from == "POST" ) { if( isset( $_POST[$this->column_name[$table_num][$column_nr]] ) ) { // echo eregi_replace( "\"", """, $_POST[$this->column_name[$table_num][$column_nr]] ); $uscita .= eregi_replace( "\"", """, $_POST[$this->column_name[$table_num][$column_nr]] ); } } else { if( isset( $from[$this->column_name[$table_num][$column_nr]] ) ) { // echo $from[$this->column_name[$table_num][$column_nr]]; $uscita .= $from[$this->column_name[$table_num][$column_nr]]; } } // echo "\">\n"; $uscita .= "\">\n"; } } } } if( $link == "Submit" || $complete == "yes" || $complete == "index" || $complete == "delete" ) { if( $this->db_buttonstyle == "" || $this->db_buttonstyle == "form" ) { // echo "<INPUT TYPE=\"Submit\" VALUE=\" " . $name . " \">"; $uscita .= "<INPUT TYPE=\"Submit\" VALUE=\" " . $name . " \">"; } else { if( !isset( $this->id ) ) { // echo "<A HREF=\"" . "javascript:document." . $iidd . $this->table_name[0] . $this->fcall . $this->fnum . ".submit();" . "\"><IMG SRC=\"images/" . $name . ".png\" ALT=\"" . $name . "\" TITLE=\"" . $name . "\" BORDER=\"0\"></A>"; $uscita .= "<A HREF=\"" . "javascript:document." . $iidd . $this->table_name[0] . $this->fcall . $this->fnum . ".submit();" . "\"><IMG SRC=\"images/" . $name . ".png\" ALT=\"" . $name . "\" TITLE=\"" . $name . "\" BORDER=\"0\"></A>"; } else { // echo "<A HREF=\"javascript:"; // echo "javascript:document." . $iidd . $this->table_name[0] . $this->fcall . $this->fnum . ".submit();"; // echo "ajaxHTTPHandler('"; // echo $this->id; // echo "','"; // echo $this->db_host_link . ltrim( $_SERVER['PHP_SELF'], '/' ); // echo "',document.getElementById('"; // echo $this->id . $this->table_name[0] . $this->fcall . $this->fnum; // echo "'));\">"; // echo "<IMG SRC=\"images/" . $name . ".png\" ALT=\"" . $name . "\" TITLE=\"" . $name . "\" BORDER=\"0\"></A>"; $uscita .= "<A HREF=\"javascript:"; $uscita .= "javascript:document." . $iidd . $this->table_name[0] . $this->fcall . $this->fnum . ".submit();"; $uscita .= "ajaxHTTPHandler('"; $uscita .= $this->id; $uscita .= "','"; $uscita .= $this->db_host_link . ltrim( $_SERVER['PHP_SELF'], '/' ); $uscita .= "',document.getElementById('"; $uscita .= $this->id . $this->table_name[0] . $this->fcall . $this->fnum; $uscita .= "'));\">"; $uscita .= "<IMG SRC=\"images/" . $name . ".png\" ALT=\"" . $name . "\" TITLE=\"" . $name . "\" BORDER=\"0\"></A>"; } } if( $link != "Submit" ) { // echo "</FORM>\n"; $uscita .= "</FORM>\n"; } } if( $prtuscita==1 ) { echo $uscita; } return $uscita; } // Start Page 'previous' and 'next' button function startPagePreviousOrNext( $pre_post ) { if( $pre_post == "pre" ) { if( isset( $_POST[$this->db_start_list] ) ) { $this->start_list = $_POST[$this->db_start_list]; } if( $this->start_list <= 1 ) { return; } $new_start_list = $this->start_list - $this->max_list; } if( $pre_post == "post" ) { if( $this->stop_list <= 1 ) { return; } } $this->fnum++; echo "<TR>"; echo "<TD id=\"listrgh\">"; if( $pre_post == "pre" ) { $this->dxfButton( "start", "$this->name_prec", "no", "", 0, "" ); echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_start_list . "\" VALUE=\""; echo $new_start_list . "\">\n"; $this->dxfButton( "Submit", "$this->name_prec", "no", "", 0, "" ); } else { $this->dxfButton( "start", "$this->name_segu", "no", "", 0, "" ); echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_start_list . "\" VALUE=\""; echo $this->stop_list . "\">\n"; $this->dxfButton( "Submit", "$this->name_segu", "no", "", 0, "" ); } echo "</FORM>"; echo "</TD>"; echo "<TD id=\"listrgh\" colspan=\"" . ($this->num_columns[0]-1) . "\">"; echo " "; echo "</TD>"; echo "</TR>"; } // Start Page list function startPageList( $result, $limited ) { $table_num=0; if( $result=="" || mysql_num_rows( $result ) == 0 ) { return; } $or = 1; $conta = 1; if( $limited=="yes" && $this->start_list > 1 ) { for( $jk=1; $jk<$this->start_list ; $jk++ ) { $line1 = mysql_fetch_assoc( $result ); $conta++; } } $uscita = ""; $lista = 0; $liststyle = 1; while( $line1 = mysql_fetch_assoc( $result ) ) { $liststyle = 1 - $liststyle; $or++; $conta++; $lista++; if( $limited=="yes" && ( $lista > $this->max_list ) ) { $this->stop_list = $conta -1; break; } // echo "<TR>"; $uscita .= "<TR>"; // echo "<TD id=\"listrgh" . $liststyle . "\">"; $uscita .= "<TD id=\"listrgh" . $liststyle . "\">"; $uscita .= $this->dxfButton( "ins2", "$this->name_update", "index", $line1, $table_num, " " ); for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $column_nr== 0 ) { $uscita .= "</TD>"; } if( $this->column_selection[$table_num][$column_nr]>0 || $this->column_main_field[$table_num][$column_nr]>0 ) { $uscita .= "<TD id=\"listrgh" . $liststyle . "\">"; $value = $line1[$this->column_name[$table_num][$column_nr]]; if( $this->db_linestyle == "" || $this->db_linestyle == "form" ) { $uscita .= "<INPUT TYPE=\"text\" NAME=\""; $uscita .= $this->column_name[$table_num][$column_nr]; $uscita .= "\" VALUE=\"" . $value; $uscita .= "\" SIZE=\"" . $this->column_length[$table_num][$column_nr] . "\">"; } else { $uscita .= $value; } $uscita .= "</TD>"; } } $uscita .= "</TR>"; } echo $uscita; return; } // Start page insertion function startPageInsert( ) { $table_num=0; if( $this->num_columns[$table_num] > 2 ) { $this->dxfButton( "ins2", "$this->name_insert", "no", "", 0, "" ); } else { $this->dxfButton( "ins2", "$this->name_go", "no", "", 0, "" ); } echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->insert . "\" VALUE=\"" . $this->insert . "Start\">\n"; echo "<TABLE>\n"; echo "<TR>"; for( $column_nr=0, $omit=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_selection[$table_num][$column_nr]>0 ) { if ( $this->column_selez[$table_num][$column_nr] == "#CONTEXT" && $this->db_contesto !="" ) { $omit=1; } else { $omit=0; break; } } } for( $column_nr=0; $column_nr<=$this->num_columns[$table_num] && $omit==0; $column_nr++ ) { if( $column_nr== 0 ) { echo "<TD id=\"rgh\">"; // if( $this->num_columns[$table_num] > 2 ) { $this->dxfButton( "Submit", "$this->name_insert", "no", "", $table_num, "" ); // } else { // $this->dxfButton( "Submit", "$this->name_go", "no", "", $table_num, "" ); // } echo "</TD>"; } if( $this->column_selection[$table_num][$column_nr]>0 ) { echo "<TD id=\"lft\">"; echo $this->column_short[$table_num][$column_nr]; echo "</TD>"; echo "<TD id=\"rgh\">"; if( ( !strncmp( $this->column_lkup_use[$table_num][$column_nr], "lookup", 6 ) || !strncmp( $this->column_lkup_use[$table_num][$column_nr], "default", 6 ) ) && $this->column_lkup_tbl[$table_num][$column_nr] ) { $query2 = "select " . $this->column_lkup_dis[$table_num][$column_nr] . ", " . $this->column_lkup_col[$table_num][$column_nr]; $query2 = $query2 . " from " . $this->column_lkup_tbl[$table_num][$column_nr]; if( isset( $this->column_lkup_lan[$table_num][$column_nr] ) ) { $query2 = $query2 . " where "; $query2 = $query2 . $this->column_lkup_lan[$table_num][$column_nr] . "= '" . $this->db_langue ."'"; } $result2 = mysql_query( $query2 ) or die("Query2 failed: " . $query2 . " " . mysql_error()); echo "<SELECT NAME=\"" . $this->column_name[$table_num][$column_nr] . "\" size=\"1\">\n"; $j=0; while( $line2 = mysql_fetch_assoc( $result2 ) ) { if( $j==0 && substr($this->column_lkup_use[$table_num][$column_nr],-1,1)=='-' ) { $j++; echo "<OPTION VALUE=\"\">\n"; } $value = $line2[$this->column_lkup_col[$table_num][$column_nr]]; $value1 = $line2[$this->column_lkup_dis[$table_num][$column_nr]]; echo "<OPTION VALUE=\"" . $value . "\">" . $value1 . "\n"; } echo "</SELECT>\n"; } else { $value=""; if ( $this->column_selez[$table_num][$column_nr] == "#CONTEXT" && $this->db_contesto !="" ) { $value=$this->db_contesto; } echo "<INPUT TYPE=\"text\" NAME=\"" . $this->column_name[$table_num][$column_nr]; echo "\"VALUE=\"" . $value . "\" SIZE=\"" . $this->column_length[$table_num][$column_nr] . "\">"; } echo "</TD>"; echo "\n"; } } echo "</TR>"; echo "</TABLE>"; echo "</FORM>"; } // 'Back' button function goBack( ) { $this->dxfButton( "index", $this->name_home, "yes", "", 0, "" ); } // Closing connection function endDxfTableManagement( ) { mysql_close($this->db); echo "<P>\n"; echo "</BODY>\n"; exit(); } // Master table display: query by primary key function tableDisplay( $table_num ) { $printed=0; $query = 'select '; for( $col_num=0; $col_num<=$this->num_columns[$table_num]; $col_num++ ) { $query .= $this->column_name[$table_num][$col_num]; if( $col_num<$this->num_columns[$table_num] ) { $query .= ', '; } } $query = $query . ' from ' . $this->table_name[$table_num]; $query1 = ""; for( $col_num=0; $col_num<=$this->num_columns[$table_num]; $col_num++ ) { if( $this->column_main_index[$table_num][$col_num]>0 ) { if( $query1 ) { $query1 .= " and "; } $query1 .= $this->column_name[$table_num][$col_num] . "='" . $_POST[$this->column_name[$table_num][$col_num]] . "'"; } } if( $query1 ) { $query .= " where " . $query1; } $result = mysql_query( $query ) or die("Query failed dd : " . $query . " " . mysql_error()); echo "<TABLE>\n"; while( $line = mysql_fetch_assoc( $result ) ) { $value1 = ""; for( $col_num=0; $col_num<=$this->num_columns[$table_num]; $col_num++ ) { for( $n=0; $n<=$this->num_columns[$table_num]; $n++ ) { if( $this->column_ext_num[$table_num][$col_num] == $n ) { $this->column_ext_val[$table_num][$col_num]=$line[$this->column_name[$table_num][$n]]; break; } } for( $n=0; $n<=$this->num_columns[$table_num]; $n++ ) { if( $this->column_lkup_num[$table_num][$col_num] == $n ) { $this->column_lkup_val[$table_num][$col_num]=$line[$this->column_name[$table_num][$n]]; break; } } } $linestyle = 1; for( $col_num=0; $col_num<=$this->num_columns[$table_num]; $col_num++ ) { $linestyle = 1 - $linestyle; $value = $line[$this->column_name[$table_num][$col_num]]; $value1 = $this->column_lkup_val[$table_num][$col_num]; $length = $this->column_length[$table_num][$col_num]; if( $this->column_lkup_num[$table_num][$col_num] == -1 ) { $value1 = $value; } if( !strncmp( $this->column_lkup_use[$table_num][$col_num], "lookup", 6 ) && $this->column_lkup_tbl[$table_num][$col_num] ) { $query2 = "select " . $this->column_lkup_dis[$table_num][$col_num]; $query2 .= " from " . $this->column_lkup_tbl[$table_num][$col_num]; $query2 .= " where " . $this->column_lkup_col[$table_num][$col_num] . "= '" . eregi_replace ( "'", "\\'", eregi_replace( "\"", "\\\"", $value1 ) ) . "' "; if( $this->column_lkup_lan[$table_num][$col_num] ) { $query2 = $query2 . "and " . $this->column_lkup_lan[$table_num][$col_num]; $query2 .= "= '" . $this->db_langue . "'"; } if( $this->column_ext_col[$table_num][$col_num] ) { $query2 = $query2 . " and " . $this->column_ext_col[$table_num][$col_num]; $query2 .= "= '" . $this->column_ext_val[$table_num][$col_num] ."'"; } $result2 = mysql_query( $query2 ) or die("Query2 failed: " . $query2 . " " . mysql_error()); $line2 = mysql_fetch_assoc( $result2 ); if( $this->column_lkup_use[$table_num][$col_num]=="lookup+" ) { if( isset( $line2 ) ) { $value = $value . " - " . $line2[$this->column_lkup_dis[$table_num][$col_num]]; } } else { $value = $line2[$this->column_lkup_dis[$table_num][$col_num]]; } $length = strlen( $value ); } if( $this->column_selection[$table_num][$col_num]>0 ) { continue; } $printed=1; echo "<TR>"; echo "<TD id=\"lft" . $linestyle . "\">"; echo $this->column_value[$table_num][$col_num]; echo "</TD>"; echo "<TD id=\"rgh" . $linestyle . "\">"; if( $this->column_type[$table_num][$col_num]=="file" ) { echo "<A HREF=\"" . $value . "\">" . basename( $value ) . "</A>"; } else { if( $this->column_type[$table_num][$col_num] == "integer" ) { echo "<div align=right>"; } echo $value; if( $this->column_type[$table_num][$col_num] == "integer" ) { echo "</div>"; } } echo "</TD>"; echo "</TR>"; echo "\n"; } } echo "</TABLE>\n"; mysql_free_result($result); return $printed; } // Count items into master-type tables function howManyRows( $table_num ) { $query = "select count(*) quanti from " . $this->table_name[$table_num]; $query1 = ""; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_selection[$table_num][$column_nr]>0 ) { $column_select = $_POST[$this->column_name[$table_num][$column_nr]]; if( $column_select ) { if( $query1 ) { $query1 .= " and "; } $query1 .= $this->column_name[$table_num][$column_nr]; $query1 .= "='"; $query1 .= $column_select; $query1 .= "'"; } } } if( $query1 != "" ) { $query .= " where " . $query1; } $result = mysql_query( $query ) or die("Query failed zz: " . $query . " " . mysql_error() ); $line = mysql_fetch_assoc( $result ); $quanti = $line['quanti']; mysql_free_result( $result ); for( $column_nr=0, $cols=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_selection[$table_num][$column_nr]>0 ) { continue; } if( $this->column_view[$table_num][$column_nr]>0 ) { $cols++; } } $retval[0]= $quanti; $retval[1]= $cols; return( $retval ); } // Output detail table list header function detailTableHeader( $table_num ) { $result = $this->tableQueryCreate( $table_num ); echo "<TABLE>\n"; echo "<TR>"; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $column_nr== 0 ) { if( $this->noinput != "yes" ) { echo "<TD id=\"listhea\" COLSPAN=\"3\">"; echo $this->name_action; echo "</TD>"; } } if( $this->column_selection[$table_num][$column_nr]>0 ) { continue; } if ( $this->column_selez[$table_num][$column_nr] == "#LANGUE" ) { continue; } if ( $this->column_selez[$table_num][$column_nr] == "#CONTEXT" && $this->db_contesto !="" ) { continue; } if ( $this->column_view[$table_num][$column_nr] == 0 ) { continue; } echo "<TD id=\"listhea\">"; echo $this->column_short[$table_num][$column_nr]; echo "</TD>"; } echo "</TR>"; echo "\n"; } // Create detail table list function detailTableManage( $table_num ) { $result = $this->tableQueryCreate( $table_num ); $uscita = ""; echo "<TABLE>\n"; // $uscita .= "<TABLE>\n"; $this->detailTableHeader( $table_num ); $del=0; if( strcasecmp( $this->noinput, "yes" ) ) { // echo "<TR>"; // echo "<TD id=\"listlft\" colspan=\"" . ( $this->num_columns[$table_num] -$del +3 ). "\">"; $uscita .= "<TR>"; $uscita .= "<TD id=\"listlft\" colspan=\"" . ( $this->num_columns[$table_num] -$del +3 ). "\">"; $uscita .= $this->dxfButton( "ins", $this->name_insert, "index", "POST", $table_num, " " ); // echo "</TD>"; // echo "</TR>"; $uscita .= "</TD>"; $uscita .= "</TR>"; $del++; } $num_line = 0; $liststyle = 1; while( $line = mysql_fetch_assoc( $result ) ) { $liststyle = 1 - $liststyle; $num_line++; // echo "<TR>"; $uscita .= "<TR>"; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { for( $n=0; $n<=$this->num_columns[$table_num]; $n++ ) { if( $this->column_ext_num[$table_num][$column_nr] == $n ) { $this->column_ext_val[$table_num][$column_nr]=$line[$this->column_name[$table_num][$n]]; } } } $value1=""; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { for( $n=0; $n<=$this->num_columns[$table_num]; $n++ ) { if( $this->column_lkup_num[$table_num][$column_nr] == $n ) { $this->column_lkup_val[$table_num][$column_nr]=$line[$this->column_name[$table_num][$n]]; } } } if( strcasecmp( $this->noinput, "yes" ) ) { $uscita .= "<TD id=\"listlft" . $liststyle . "\">"; $uscita .= $this->dxfButton( "mod", $this->name_update, "index", $line, $table_num, " " ); $uscita .= "</TD>"; $uscita .= "<TD id=\"listlft" . $liststyle . "\">"; $uscita .= $this->dxfButton( "del", $this->name_delete, "index", $line, $table_num, " " ); $uscita .= "</TD>"; $uscita .= "<TD id=\"listlft" . $liststyle . "\">"; $uscita .= $this->dxfButton( "dis", $this->name_see, "index", $line, $table_num, " " ); $uscita .= "</TD>"; } for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { $value = $line[$this->column_name[$table_num][$column_nr]]; $value2 = $line[$this->column_name[$table_num][$column_nr]]; $value1 = $this->column_lkup_val[$table_num][$column_nr]; $length = $this->column_length[$table_num][$column_nr]; if( $this->column_lkup_num[$table_num][$column_nr] == -1 ) { $del++; $value1 = $value; } if ( $this->column_selez[$table_num][$column_nr] == "#LANGUE" ) { $del++; continue; } if ( $this->column_selez[$table_num][$column_nr] == "#CONTEXT" && $this->db_contesto !="" ) { $del++; continue; } if ( $this->column_view[$table_num][$column_nr] == 0 ) { $del++; continue; } if( !strncmp( $this->column_lkup_use[$table_num][$column_nr], "lookup", 6 ) && $this->column_lkup_tbl[$table_num][$column_nr] ) { $query2 = "select "; $query2 .= $this->column_lkup_dis[$table_num][$column_nr]; $query2 .= " from "; $query2 .= $this->column_lkup_tbl[$table_num][$column_nr]; $query2 .= " where "; $query2 .= $this->column_lkup_col[$table_num][$column_nr]; $query2 .= "= '"; $query2 .= eregi_replace ( "'", "\\'", eregi_replace( "\"", "\\\"", $value1 ) ); $query2 .= "' "; if( $this->column_lkup_lan[$table_num][$column_nr] ) { $query2 .= "and "; $query2 .= $this->column_lkup_lan[$table_num][$column_nr]; $query2 .= "= '"; $query2 .= $this->db_langue; $query2 .= "'"; } if( $this->column_ext_col[$table_num][$column_nr] ) { $query2 .= " and "; $query2 .= $this->column_ext_col[$table_num][$column_nr]; $query2 .= "= '"; $query2 .= $this->column_ext_val[$table_num][$column_nr]; $query2 .= "'"; } $result2 = mysql_query( $query2 ) or die("Query2 failed: " . $query2 . " " . mysql_error()); $line2 = mysql_fetch_assoc( $result2 ); $value = $line2[$this->column_lkup_dis[$table_num][$column_nr]]; $length = strlen( $value ); } if( $this->column_lkup_use[$table_num][$column_nr] == "lookup+" && $this->column_lkup_tbl[$table_num][$column_nr] && $value != "" ) { if( $this->user_breakable == "no" ) { $value = $value2 . " - " . $value; } else { $value = $value2 . " <br> " . $value; } } $length = strlen( $value ); if( $this->column_selection[$table_num][$column_nr]>0 ) { continue; // echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->column_name[$table_num][$column_nr]; // echo "\" SIZE=\"" . $length . "\""; // echo " VALUE=\"" . eregi_replace( "\"", """, $value ) . "\">"; $uscita .= "<INPUT TYPE=\"hidden\" NAME=\"" . $this->column_name[$table_num][$column_nr]; $uscita .= "\" SIZE=\"" . $length . "\""; $uscita .= " VALUE=\"" . eregi_replace( "\"", """, $value ) . "\">"; } // echo "<TD id=\"listrgh" . $liststyle . "\">"; $uscita .= "<TD id=\"listrgh" . $liststyle . "\">"; if( $this->column_type[$table_num][$column_nr]=="file" ) { if( $this->db_linestyle == "" || $this->db_linestyle == "form" ) { // echo "<A HREF=\"" . $value . "\">"; // echo "<INPUT TYPE=\"text\" NAME=\""; // echo $this->column_name[$table_num][$column_nr] . "web"; // echo "\" SIZE=\"" . strlen( basename( $value ) ) . "\" "; // echo " VALUE=\"" . eregi_replace( "\"", """, basename( $value ) ) . "\">"; // echo "</A>"; $uscita .= "<A HREF=\"" . $value . "\">"; $uscita .= "<INPUT TYPE=\"text\" NAME=\""; $uscita .= $this->column_name[$table_num][$column_nr] . "web"; $uscita .= "\" SIZE=\"" . strlen( basename( $value ) ) . "\" "; $uscita .= " VALUE=\"" . eregi_replace( "\"", """, basename( $value ) ) . "\">"; $uscita .= "</A>"; } else { // echo eregi_replace( "\"", """, basename( $value ) ); // $uscita .= eregi_replace( "\"", """, basename( $value ) ); $uscita .= "<A HREF=\"" . $value . "\">"; $uscita .= eregi_replace( "\"", """, basename( $value ) ); $uscita .= "</A>"; } // echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->column_name[$table_num][$column_nr]; // echo "\" SIZE=\"" . $length . "\""; // echo " VALUE=\"" . eregi_replace( "\"", """, $value ) . "\">"; $uscita .= "<INPUT TYPE=\"hidden\" NAME=\"" . $this->column_name[$table_num][$column_nr]; $uscita .= "\" SIZE=\"" . $length . "\""; $uscita .= " VALUE=\"" . eregi_replace( "\"", """, $value ) . "\">"; } else { if( $this->db_linestyle == "" || $this->db_linestyle == "form" ) { // echo "<INPUT TYPE=\"text\" NAME=\""; // echo $this->column_name[$table_num][$column_nr]; // echo "\" SIZE=\"" . $length . "\""; // echo " VALUE=\"" . eregi_replace( "\"", """, $value ) . "\">"; $uscita .= "<INPUT TYPE=\"text\" NAME=\""; $uscita .= $this->column_name[$table_num][$column_nr]; $uscita .= "\" SIZE=\"" . $length . "\""; $uscita .= " VALUE=\"" . eregi_replace( "\"", """, $value ) . "\">"; } else { // echo eregi_replace ( " ", " ", eregi_replace( "\"", """, $value )); if( $this->column_type[$table_num][$column_nr] == "integer" ) { $uscita.= "<div align=right>"; } if( $this->user_breakable == "no" ) { $uscita .= eregi_replace ( " ", " ", eregi_replace( "\"", """, $value )); } else { $uscita .= eregi_replace( "\"", """, $value ); } if( $this->column_type[$table_num][$column_nr] == "integer" ) { $uscita.= "</div>"; } } } // echo "</TD>"; $uscita .= "</TD>"; } // echo "</TR>"; // echo "\n"; $uscita .= "</TR>"; $uscita .= "\n"; } if( strcasecmp( $this->noinput, "yes" ) ) { // echo "<TR>"; // echo "<TD id=\"listlft\" colspan=\"" . ( $this->num_columns[$table_num] -$del +3 ). "\">"; $uscita .= "<TR>"; $uscita .= "<TD id=\"listlft\" colspan=\"" . ( $this->num_columns[$table_num] -$del +3 ). "\">"; $uscita .= $this->dxfButton( "ins", $this->name_insert, "index", "POST", $table_num, " " ); // echo "</TD>"; // echo "</TR>"; $uscita .= "</TD>"; $uscita .= "</TR>"; } // echo "</TABLE>\n"; $uscita .= "</TABLE>\n"; echo $uscita; mysql_free_result( $result ); } // Manage complete table management (all tables in a 'procedure') function procedureManagement( ) { for( $table_num=0; $table_num<=$this->num_tables; $table_num++ ) { if( $this->no_selection == 0 || !strncasecmp( $this->table_use[$table_num], "details", 7 ) ) { // if( $this->no_selection > 0 ) { echo "<p><DIV ID=\"tut\">" . $this->table_value[$table_num] . "<p>"; // } $this->detailTableManage( $table_num ); } else { if( $this->table_use[$table_num]=="master" ) { $retval = $this->howManyRows( $table_num ); $rowss = $retval[0]; $colss = $retval[1]; if( $colss>0 ) { if( $rowss>0 ) { if( $this->no_selection > 0 ) { echo "<p><DIV ID=\"tut\">" . $this->table_value[$table_num] . "<p>"; } if( $this->tableDisplay( $table_num ) ) { if( strcasecmp( $this->noinput, "yes" ) ) { echo "<TABLE id=nasc><TR><TD id=hea>\n"; $this->dxfButton( "mod", $this->name_update, "index", "POST", $table_num, "" ); echo "</TD><TD>\n"; $this->dxfButton( "del", $this->name_delete, "index", "POST", $table_num, "" ); echo "</TD></TR></TABLE>\n"; } } } else { if( strcasecmp( $this->noinput, "yes" ) ) { $this->dxfButton( "ins", $this->name_insert, "index", "POST", $table_num, "" ); } } } } } echo "<p>\n"; } $this->goBack(); } // Prints page header function pageHeader( $table_num, $mode ) { for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_selection[$table_num][$column_nr]>0 ) { $column_select[$column_nr]=$_POST[$this->column_name[$table_num][$column_nr]]; } } if( $this->no_selection > 0 ) { if( $mode=="proc" ) { echo "<DIV ID=\"tit\">" . $this->procedure_header . "<br>"; } else { echo "<DIV ID=\"tit\">" . $this->table_value[$table_num] . "<br>"; } for( $column_nr=0, $q=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( isset ( $column_select[$column_nr] ) ) { $value = $column_select[$column_nr]; $value1 = $column_select[$column_nr]; $value2 = $column_select[$column_nr]; $length = $this->column_length[$table_num][$column_nr]; if( $this->column_lkup_num[$table_num][$column_nr] == -1 ) { $value1 = $value; } if( !strncmp( $this->column_lkup_use[$table_num][$column_nr], "lookup", 6 ) && $this->column_lkup_tbl[$table_num][$column_nr] ) { $query2 = "select "; $query2 .= $this->column_lkup_dis[$table_num][$column_nr]; $query2 .= " from "; $query2 .= $this->column_lkup_tbl[$table_num][$column_nr]; $query2 = $query2 . " where " . $this->column_lkup_col[$table_num][$column_nr] . "= '" . eregi_replace ( "'", "\\'", eregi_replace( "\"", "\\\"", $value1 ) ) . "' "; if( $this->column_lkup_lan[$table_num][$column_nr] ) { $query2 .= "and "; $query2 .= $this->column_lkup_lan[$table_num][$column_nr]; $query2 .= "= '"; $query2 .= $this->db_langue; $query2 .= "'"; } if( $this->column_ext_col[$table_num][$column_nr] ) { $query2 .= " and "; $query2 .= $this->column_ext_col[$table_num][$column_nr]; $query2 .= "= '"; $query2 .= $this->column_ext_val[$table_num][$column_nr]; $query2 .= "'"; } $result2 = mysql_query( $query2 ) or die("Query2 failed: " . $query2 . " " . mysql_error()); $line2 = mysql_fetch_assoc( $result2 ); $value = $line2[$this->column_lkup_dis[$table_num][$column_nr]]; if( !strcmp( $this->column_lkup_use[$table_num][$column_nr], "lookup+" ) && $this->column_lkup_tbl[$table_num][$column_nr] ) { $value = $value2 . " " . $value; } } if( !$q ) { $q++; } echo " - ". $this->column_value[$table_num][$column_nr]; echo " : " . $value; } } if( $q ) { echo " - "; } echo "</DIV>\n"; } echo "<P>\n"; if( strcasecmp( $this->noinput, "yes" ) ) { if( $this->no_selection > 0 ) { $this->dxfButton( "start", $this->name_proc, "yes", "", $table_num, "" ); echo "<br>\n"; } } else { echo "<TABLE><TR><TD>\n"; $this->dxfButton( "search", $this->name_search, "yes", "", $table_num, "" ); echo "</TD><TD>\n"; $this->dxfButton( "index", $this->name_proc, "yes", "", $table_num, "" ); // $this->dxfButton( "qbe2", $this->name_back, "index", "POST", $table_num, "" ); echo "</TD></TR></TABLE>\n"; } } // Verify inserted/updated values function verifyValues( $table_num ) { $queryv = "SELECT * from " . $this->table_name[$table_num] . " where "; $queryu = ""; for( $column_nr=0, $errore=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { $this->column_error[$column_nr] = ""; if( isset( $_POST[$this->column_name[$table_num][$column_nr]] ) ) { $value = $_POST[$this->column_name[$table_num][$column_nr]]; } else { $value = ''; } // indexes must be non null if( $this->column_main_index[$table_num][$column_nr]>0 ) { if( !strlen( $value ) ) { $this->column_error[$column_nr] = $this->name_error; $errore++; continue; } if( $queryu != "" ) { $queryu .= " and "; } $queryu .= $this->column_name[$table_num][$column_nr] . "='" . $value . "'"; } if( isset( $this->column_rule[$table_num][$column_nr] ) && strlen( $this->column_rule[$table_num][$column_nr] ) ) { // regex control $ccc = preg_match( $this->column_rule[$table_num][$column_nr], $value ); if( $ccc == 0 ) { $this->column_error[$column_nr] = $this->name_error; $errore++; } } } // unique index if( $errore == 0 && isset( $_POST[$this->insert] ) ) { $queryv .= $queryu . ";"; $resultv = mysql_query( $queryv ) or die("Queryv failed: " . $queryv . " " . mysql_error()); $linev = mysql_fetch_assoc( $resultv ); if( $linev ) { for( $column_nr=0, $errore=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_main_index[$table_num][$column_nr]>0 ) { $this->column_error[$column_nr] = $this->name_index; $errore++; } } } mysql_free_result( $resultv ); } return( $errore ); } // file input management function fileManagement( $table_num ) { for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_type[$table_num][$column_nr]=="file" ) { $this->uploadfileurl[$column_nr]=""; if( $_FILES ) { $userfile = $this->column_name[$table_num][$column_nr] . "file"; if( $_FILES[$userfile]['name'] ) { if( $_FILES[$userfile]['error'] ) { die( "file " . $_FILES[$userfile]['name'] . "not transferred. Error: " . $_FILES[$userfile]['error'] ); } $uploaddir = $this->column_base[$table_num][$column_nr]; $uploadurl[$column_nr] = $this->column_urlbase[$table_num][$column_nr]; for( $n=0; $n<=$this->num_columns[$table_num]; $n++ ) { if( $this->column_selection[$table_num][$n] ) { $uploaddir = $uploaddir . $_POST[$this->column_name[$table_num][$n]] . "/"; $uploadurl[$$column_nr] = $uploadurl[$column_nr] . $_POST[$this->column_name[$table_num][$n]] . "/"; if( !is_dir( $uploaddir ) ) { mkdir( $uploaddir ) or die ( "mkdir " . $n . " - " . $uploaddir . " failed\n" ); } } } $uploadfile = $uploaddir . basename($_FILES[$userfile]['name']); $this->uploadfileurl[$column_nr] = $uploadurl[$column_nr] . basename($_FILES[$userfile]['name']); if( !move_uploaded_file( $_FILES[$userfile]['tmp_name'], $uploadfile)) { die( "file " . $_FILES[$userfile]['tmp_name'] . " - " . $uploadfile . " not recorded." ); } } } } } } // update of a row into a table function tableUpdate( $table_num ) { for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { for( $n=0; $n<=$this->num_columns[$table_num]; $n++ ) { if( $this->column_lkup_num[$table_num][$column_nr] == $n ) { $this->column_lkup_val[$table_num][$column_nr]=$_POST[$this->column_name[$table_num][$n]]; break; } } } for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { for( $n=0; $n<=$this->num_columns[$table_num]; $n++ ) { if( $this->column_ext_num[$table_num][$column_nr] == $n ) { if( $this->column_selection[$table_num][$n] ) { $this->column_ext_val[$table_num][$column_nr] = $column_select[$n]; $this->column_ext_val[$table_num][$column_nr]=$_POST[$this->column_name[$table_num][$n]]; } break; } } } for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( isset( $_POST[$this->column_name[$table_num][$column_nr]] ) ) { $value = $_POST[$this->column_name[$table_num][$column_nr]]; $colnam=$this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr]; $$colnam=$_POST[$this->column_name[$table_num][$column_nr]]; } else { $value = ''; } $value1 = $this->column_lkup_val[$table_num][$column_nr]; $length = $this->column_length[$table_num][$column_nr]; if( $this->column_lkup_num[$table_num][$column_nr] == -1 ) { $value1 = $value; } if( !strncmp( $this->column_lkup_use[$table_num][$column_nr], "lookup", 6 ) && $this->column_lkup_tbl[$table_num][$column_nr] && !strcasecmp( $this->column_protected[$table_num][$column_nr], "auto" ) ) { $query2 = "select " . $this->column_lkup_dis[$table_num][$column_nr] . " from " . $this->column_lkup_tbl[$table_num][$column_nr]; $query2 = $query2 . " where " . $this->column_lkup_col[$table_num][$column_nr] . "= '" . eregi_replace ( "'", "\\'", eregi_replace( "\"", "\\\"", $value1 ) ) . "' "; if( $this->column_lkup_lan[$table_num][$column_nr] ) { $query2 = $query2 . "and " . $this->column_lkup_lan[$table_num][$column_nr] . "= '" . $this->db_langue . "'"; } if( $this->column_ext_col[$table_num][$column_nr] ) { $query2 = $query2 . " and " . $this->column_ext_col[$table_num][$column_nr] . "= '" . $this->column_ext_val[$table_num][$column_nr] ."'"; } $result2 = mysql_query( $query2 ) or die("Query2 failed: " . $query2 . " " . mysql_error()); $line2 = mysql_fetch_assoc( $result2 ); $value = $line2[$this->column_lkup_dis[$table_num][$column_nr]]; $length = strlen( $value ); mysql_free_result( $result2 ); $autoval[$column_nr]=$value; } } $query = "update " . $this->table_name[$table_num] . " set "; $query1 = ""; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_main_index[$table_num][$column_nr]<=0 ) { if( $query1 ) { $query1 = $query1 . ", "; } if( $this->column_type[$table_num][$column_nr]=="file" && $this->uploadfileurl[$column_nr] ) { $query1 = $query1 . $this->column_name[$table_num][$column_nr] . "='" . $this->uploadfileurl[$column_nr] . "'" ; $colnam=$this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr]; $$colnam= $this->uploadfileurl[$column_nr]; } else { if( !strcasecmp( $this->column_protected[$table_num][$column_nr], "auto" ) ) { $query1 = $query1 . $this->column_name[$table_num][$column_nr] . "='" . $autoval[$column_nr] . "'"; $colnam=$this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr]; $$colnam= $autoval[$column_nr]; } else { if( isset( $_POST[$this->column_name[$table_num][$column_nr]] ) ) { $vle = $_POST[$this->column_name[$table_num][$column_nr]]; } else { $vle = ''; } if( $this->column_funzione[$table_num][$column_nr]=="MD5" ) { $query1 = $query1 . $this->column_name[$table_num][$column_nr] . "='" . md5($vle) . "'"; $colnam=$this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr]; $$colnam=md5($vle); /* } else if $this->column_funzione[$table_num][$column_nr]=="PEM" { $query1 = $query1 . $this->column_name[$table_num][$column_nr] . "='" . $this->pem() . "'"; $colnam=$this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr]; $$colnam=$this->pem(); */ } else { $query1 = $query1 . $this->column_name[$table_num][$column_nr] . "='" . $vle . "'"; $colnam=$this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr]; $$colnam=$vle; } } } } } $query2 = ""; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_main_index[$table_num][$column_nr]>0 ) { if( $query2 ) { $query2 = $query2 . " and "; } $query2 = $query2 . $this->column_name[$table_num][$column_nr] . "='" . $_POST[$this->column_name[$table_num][$column_nr]] . "'"; } } $condiz=$this->table_postcondit[$table_num]; if( $condiz !="" ) { $res = eval("\$condiz = \"$condiz\";"); $condiz="if(" . $condiz . ") { return( 1 ); } else { return( 0 ); }"; $res = eval("$condiz"); $command = $this->table_postdelete[$table_num]; eval("\$command = \"$command\";"); $result = mysql_query( $command ) or die("Query failed: " . $command . " " . mysql_error()); if( $res ) { $command = $this->table_postinsert[$table_num]; eval("\$command = \"$command\";"); $result = mysql_query( $command ) or die("Query failed: " . $command . " " . mysql_error()); } } $query = $query . $query1 . " where " . $query2; $result = mysql_query( $query ) or die("Query failed: " . $query . " " . mysql_error()); } // deletion of a row into a table function tableDelete( $table_num ) { $query = "delete from " . $this->table_name[$table_num] . " "; $query1 = ""; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_main_index[$table_num][$column_nr]>0 ) { if( $query1 ) { $query1 .= " and "; } $query1 .= $this->column_name[$table_num][$column_nr]; $query1 .= "='"; $query1 .= $_POST[$this->column_name[$table_num][$column_nr]]; $query1 .= "'"; $colnam=$this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr]; $$colnam=$_POST[$this->column_name[$table_num][$column_nr]]; } } $query .= " where " . $query1; $command = $this->table_postdelete[$table_num]; if( $command !="" ) { eval("\$command = \"$command\";"); $result = mysql_query( $command ) or die("Query failed: " . $command . " " . mysql_error()); } $result = mysql_query( $query ) or die("Query failed: " . $query . " " . mysql_error()); } // insertion of a row into a table function tableInsert( $table_num ) { for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { for( $n=0; $n<=$this->num_columns[$table_num]; $n++ ) { if( $this->column_lkup_num[$table_num][$column_nr] == $n ) { $this->column_lkup_val[$table_num][$column_nr]=$_POST[$this->column_name[$table_num][$n]]; break; } } for( $n=0; $n<=$this->num_columns[$table_num]; $n++ ) { if( $this->column_ext_num[$table_num][$column_nr] == $n ) { $this->column_ext_val[$table_num][$column_nr]=$_POST[$this->column_name[$table_num][$n]]; break; } } } for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_type[$table_num][$column_nr]=="file" ) { $value=""; } else { $value=""; if( isset( $_POST[$this->column_name[$table_num][$column_nr]] ) ) { $colnam=$this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr]; $$colnam=$_POST[$this->column_name[$table_num][$column_nr]]; $value = $_POST[$this->column_name[$table_num][$column_nr]]; } } $value1 = $this->column_lkup_val[$table_num][$column_nr]; $length = $this->column_length[$table_num][$column_nr]; if( $this->column_lkup_num[$table_num][$column_nr] == -1 ) { $value1 = $value; } if( !strncmp( $this->column_lkup_use[$table_num][$column_nr], "lookup", 6 ) && $this->column_lkup_tbl[$table_num][$column_nr] && !strcasecmp( $this->column_protected[$table_num][$column_nr], "auto" ) ) { $query2 = "select "; $query2 .= $this->column_lkup_dis[$table_num][$column_nr]; $query2 .= " from " . $this->column_lkup_tbl[$table_num][$column_nr]; $query2 .= " where " . $this->column_lkup_col[$table_num][$column_nr]; $query2 .= "= '" . eregi_replace ( "'", "\\'", eregi_replace( "\"", "\\\"", $value1 ) ) . "' "; if( $this->column_lkup_lan[$table_num][$column_nr] ) { $query2 .= "and " . $this->column_lkup_lan[$table_num][$column_nr]; $query2 .= "= '" . $this->db_langue . "'"; } if( $this->column_ext_col[$table_num][$column_nr] ) { $query2 .= " and " . $this->column_ext_col[$table_num][$column_nr]; $query2 .= "= '" . $this->column_ext_val[$table_num][$column_nr] ."'"; } $result2 = mysql_query( $query2 ) or die("Query2 failed: " . $query2 . " " . mysql_error()); $line2 = mysql_fetch_assoc( $result2 ); $value = $line2[$this->column_lkup_dis[$table_num][$column_nr]]; $length = strlen( $value ); mysql_free_result( $result2 ); $autoval[$column_nr]=$value; } } $query = "insert into " . $this->table_name[$table_num] . " ( "; $query1 = "values ( "; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { $query .= $this->column_name[$table_num][$column_nr]; if( $this->column_type[$table_num][$column_nr]=="file" && $this->uploadfileurl[$column_nr] ) { $query1 .= "'" . $this->uploadfileurl[$column_nr] . "'" ; } else { if( !strcasecmp( $this->column_protected[$table_num][$column_nr], "auto" ) ) { $query1 .= "'" . $autoval[$column_nr] . "'" ; } else { if( $this->column_funzione[$table_num][$column_nr]=="MD5" ) { $query1 .= "'" . md5($_POST[$this->column_name[$table_num][$column_nr]]) . "'" ; $colnam=$this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr]; $$colnam=md5($_POST[$this->column_name[$table_num][$column_nr]]); } else { if( isset( $_POST[$this->column_name[$table_num][$column_nr]] ) ) { $query1 .= "'" . $_POST[$this->column_name[$table_num][$column_nr]] . "'" ; } else { $query1 .= "''" ; } } } } if( $column_nr<$this->num_columns[$table_num] ) { $query .= ", "; $query1 .= ", "; } } $query .= " ) " . $query1 . " ); "; $condiz=$this->table_postcondit[$table_num]; if( $condiz !="" ) { $res = eval("\$condiz = \"$condiz\";"); $condiz="if(" . $condiz . ") { return( 1 ); } else { return( 0 ); }"; $res = eval("$condiz"); $command = $this->table_postdelete[$table_num]; eval("\$command = \"$command\";"); $result = mysql_query( $command ) or die("Query failed: " . $command . " " . mysql_error()); if( $res ) { $command = $this->table_postinsert[$table_num]; eval("\$command = \"$command\";"); $result = mysql_query( $command ) or die("Query failed: " . $command . " " . mysql_error()); } } $result = mysql_query( $query ) or die("Query failed yy: " . $query . " " . mysql_error()); return( $result ); } // Prepare insertion of a row into a table function tablePrepareInsert( $table_num ) { for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_selection[$table_num][$column_nr]>0 ) { $column_select[$column_nr]=$_POST[$this->column_name[$table_num][$column_nr]]; } } $this->pageHeader( $table_num, "insert" ); $this->dxfButton( "ins2", $this->name_insert, "no", "", $table_num, "" ); echo "<TABLE>\n"; $value1 = ""; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { for( $n=0; $n<=$this->num_columns[$table_num]; $n++ ) { if( $this->column_ext_num[$table_num][$column_nr] == $n ) { if( $this->column_selection[$table_num][$n] ) { $this->column_ext_val[$table_num][$column_nr] = $column_select[$n]; } break; } } } for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { $errore = ""; if( isset ($this->column_error[$column_nr] ) ) { $errore = $this->column_error[$column_nr]; } if( isset( $_POST[$this->column_name[$table_num][$column_nr]] ) ) { $value = $_POST[$this->column_name[$table_num][$column_nr]]; $valuez = $_POST[$this->column_name[$table_num][$column_nr]]; } else { $value = ""; $valuez = ""; } $value1 = $this->column_lkup_val[$table_num][$column_nr]; $length = $this->column_length[$table_num][$column_nr]; if( $this->column_lkup_num[$table_num][$column_nr] == -1 ) { $value1 = $value; } if( $this->column_selection[$table_num][$column_nr]>0 ) { echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->column_name[$table_num][$column_nr]; echo "\" VALUE=\"" . eregi_replace( "\"", """, $column_select[$column_nr] ) . "\">"; continue; } else { echo "<TR>"; echo "<TD id=\"lft\">"; echo $this->column_value[$table_num][$column_nr]; echo "</TD>"; echo "<TD id=\"rgh\">"; } if( ( !strncmp( $this->column_lkup_use[$table_num][$column_nr], "lookup", 6 ) || !strcmp( $this->column_lkup_use[$table_num][$column_nr], "default" ) ) && $this->column_lkup_tbl[$table_num][$column_nr] && strcasecmp( $this->column_protected[$table_num][$column_nr], "auto" ) ) { $query2 = "select " . $this->column_lkup_dis[$table_num][$column_nr]; $query2 = $query2 . ", " . $this->column_lkup_col[$table_num][$column_nr]; $query2 = $query2 . " from " . $this->column_lkup_tbl[$table_num][$column_nr]; $query3 = ""; if( $this->column_lkup_lan[$table_num][$column_nr] ) { $query3 = $query3 . " where " . $this->column_lkup_lan[$table_num][$column_nr] . "= '" . $this->db_langue ."'"; } if( $this->column_ext_col[$table_num][$column_nr] && isset( $this->column_ext_val[$table_num][$column_nr]) ) { if( $query3 ) { $query3 = $query3 . " and " . $this->column_ext_col[$table_num][$column_nr]; } else { $query3 = $query3 . " where " . $this->column_ext_col[$table_num][$column_nr]; } $query3 = $query3 . "= '" . $this->column_ext_val[$table_num][$column_nr] ."'"; } $query2 = $query2 . $query3; if( !strcmp( $this->column_lkup_use[$table_num][$column_nr], "lookup+" ) ) { $query2 = $query2 . " order by " . $this->column_lkup_col[$table_num][$column_nr]; } else{ $query2 = $query2 . " order by " . $this->column_lkup_dis[$table_num][$column_nr]; } $result2 = mysql_query( $query2 ) or die("Query2 failed: " . $query2 . " " . mysql_error()); echo "<SELECT NAME=\"" . $this->column_name[$table_num][$column_nr] . "\" size=\"1\">\n"; $j=0; while( $line2 = mysql_fetch_assoc( $result2 ) ) { if( $j==0 && substr($this->column_lkup_use[$table_num][$column_nr],-1,1)=='-' ) { $j++; echo "<OPTION VALUE=\"\">\n"; } $value = $line2[$this->column_lkup_col[$table_num][$column_nr]]; $value1 = $line2[$this->column_lkup_dis[$table_num][$column_nr]]; echo "<OPTION VALUE=\"" . $value . "\""; echo ">"; if( !strcmp( $this->column_lkup_use[$table_num][$column_nr], "lookup+" ) ) { echo $value . " - "; } echo $value1 . "\n"; } echo "</SELECT>\n"; mysql_free_result($result2); } else { if( $this->column_default[$table_num][$column_nr]=="\$USERS" ) { $PHP_AUTH_USER = addslashes( $_SERVER['PHP_AUTH_USER'] ); $PHP_AUTH_PW = md5( $_SERVER['PHP_AUTH_PW'] ); $query0 = "SELECT " . $this->user_name . ", " . $this->user_langue; $query0 = $query0 . " FROM " . $this->user_table; $query0 = $query0 . " WHERE " . $this->user_login . "='" . $PHP_AUTH_USER . "'"; $query0 = $query0 . " AND " . $this->user_passwd . "='" . $PHP_AUTH_PW . "'"; $result0 = mysql_query( $query0 ) or die( mysql_error() ); $user_data = mysql_fetch_assoc( $result0 ); $utente = $user_data[$user_name]; mysql_free_result( $result0 ); $query0 = "SELECT " . $this->user_name . ", " . $this->user_langue; $query0 = $query0 . " FROM " . $this->user_table; $query0 = $query0 . " ORDER BY " . $this->user_name; $result0 = mysql_query( $query0 ) or die( mysql_error() ); echo "<SELECT NAME=\"" . $this->column_name[$table_num][$column_nr] . "\" size=\"1\">\n"; while( $user_data = mysql_fetch_assoc( $result0 )) { $value = $user_data[$user_name]; $value1 = $user_data[$user_name]; echo "<OPTION VALUE=\"" . $value . "\""; if( !strcmp( $utente, $value ) ) { echo " SELECTED"; } echo ">" . $value1 . "\n"; } echo "</SELECT>\n"; mysql_free_result( $result0 ); } else { if( $this->column_default[$table_num][$column_nr]=="\$PROX" ) { $query0 = "select max(" . $this->column_name[$table_num][$column_nr] . ") massimo"; $query0 = $query0 . " from " . $this->table_name[$table_num]; $query1 = ""; for( $n=0; $n<=$this->num_columns[$table_num]; $n++ ) { if( $this->column_selection[$table_num][$n]>0 ) { $column_select[$n] = $_POST[$this->column_name[$table_num][$n]]; if( $column_select[$n] ) { if( $query1 ) { $query1 = $query1 . " and "; } $query1 = $query1 . $this->column_name[$table_num][$n] . "='" . $column_select[$n] . "'"; } } } if( $query1 ) { $query0 = $query0 . " where " . $query1; } $result0 = mysql_query( $query0 ) or die("Query failed : " . $query0 . " " . mysql_error()); $line0 = mysql_fetch_assoc( $result0 ); $value = $line0["massimo"]; $value++; mysql_free_result($result0); } if( $this->column_default[$table_num][$column_nr]=="\$TODAY" ) { $value = date( "Y-m-d H:i:s" ); $length = strlen( $value ); } if( $this->column_default[$table_num][$column_nr]=="\$USER" ) { $PHP_AUTH_USER = addslashes( $_SERVER['PHP_AUTH_USER'] ); $PHP_AUTH_PW = md5( $_SERVER['PHP_AUTH_PW'] ); $query0 = "SELECT " . $this->user_name . ", " . $this->user_langue; $query0 = $query0 . " FROM " . $this->user_table; $query0 = $query0 . " WHERE " . $this->user_login . "='" . $PHP_AUTH_USER . "'"; $query0 = $query0 . " AND " . $this->user_passwd . "='" . $PHP_AUTH_PW . "'"; $result0 = mysql_query( $query0 ) or die( mysql_error() ); $user_data = mysql_fetch_assoc( $result0 ); $utente = $user_data[$user_name]; mysql_free_result( $result0 ); $value = $utente; $length = strlen( $value ); } if( $this->column_default[$table_num][$column_nr]=="\$BLANK" ) { $value = ""; $length = 0; } if( strlen( $this->column_default[$table_num][$column_nr] ) && $this->column_default[$table_num][$column_nr][0]!='$' ) { $value = $this->column_default[$table_num][$column_nr]; $length = strlen( $value ); } $tipo = "text"; if( !strcasecmp( $this->column_protected[$table_num][$column_nr], "yes" ) ) { $tipo = "hidden"; echo $value; } if( !strcasecmp( $this->column_protected[$table_num][$column_nr], "auto" ) ) { $tipo = "hidden"; echo $name_auto; } if( $this->column_type[$table_num][$column_nr]=="file" ) { $tipo = "file"; $length = 0; } echo "<INPUT TYPE=\"" . $tipo . "\" NAME=\"" . $this->column_name[$table_num][$column_nr]; if( $this->column_type[$table_num][$column_nr]=="file" ) { echo "file"; } echo "\" SIZE=\"" . $length . "\""; echo "\" VALUE=\"" . eregi_replace( "\"", """, $value ) . "\">"; } } if( strlen( $errore ) ) { echo "  " . $errore; } if( $this->column_selection[$table_num][$column_nr]>0 ) { echo "</TD>"; echo "</TR>"; } echo "\n"; } echo "</TABLE>\n"; echo "<P><TABLE id=nasc><TR><TD id=hea>\n"; echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->insert . "\" VALUE=\"" . $this->insert . "\">\n"; echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_table_num . "\" VALUE=\"" . $table_num . "\">\n"; echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_proc_ref . "\" VALUE=\"" . $this->db_proc . "\">\n"; echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_langue_name . "\" VALUE=\"" . $this->db_langue . "\">\n"; $this->dxfButton( "Submit", "$this->name_insert", "no", "", $table_num, "" ); echo "\n"; echo "</FORM>\n"; echo "</TD><TD id=hea>\n"; $this->dxfButton( "ins2", $this->name_giveup, "index", "POST", $table_num, "" ); echo "</TD></TR></TABLE>\n"; } // Prepare update of a row into a table function tablePrepareUpdate( $table_num ) { $this->pageHeader( $table_num, "update" ); $this->dxfButton( "mod2", $this->name_update, "no", "", $table_num, "" ); echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->update . "\" VALUE=\"" . $this->update . "\">\n"; echo "<TABLE id=\"" . $this->fcall . $this->fnum . "tbl\">\n"; $value1 = ""; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_selection[$table_num][$column_nr]>0 ) { $column_select[$column_nr]=$_POST[$this->column_name[$table_num][$column_nr]]; } } for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { for( $n=0; $n<=$this->num_columns[$table_num]; $n++ ) { if( $this->column_ext_num[$table_num][$column_nr] == $n ) { if( $this->column_selection[$table_num][$n] ) { $this->column_ext_val[$table_num][$column_nr] = $column_select[$n]; } break; } } } $query = 'select '; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { $query = $query . $this->column_name[$table_num][$column_nr]; if( $column_nr<$this->num_columns[$table_num] ) { $query = $query . ', '; } } $query = $query . ' from ' . $this->table_name[$table_num]; $query1 = ""; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_main_index[$table_num][$column_nr]>0 ) { $column_select[$column_nr] = $_POST[$this->column_name[$table_num][$column_nr]]; if( $query1 ) { $query1 = $query1 . " and "; } $query1 = $query1 . $this->column_name[$table_num][$column_nr] . "='" . $column_select[$column_nr] . "'"; } } if( $query1 ) { $query = $query . " where " . $query1; } $result = mysql_query( $query ) or die("Query failed : " . $query . " " . mysql_error()); $line = mysql_fetch_assoc( $result ); for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { $errore = ""; if( isset ($this->column_error[$column_nr] ) ) { $errore = $this->column_error[$column_nr]; } if( isset( $_POST[$this->column_name[$table_num][$column_nr]] ) ) { $value = $_POST[$this->column_name[$table_num][$column_nr]]; $valuez = $value; } else { $value = $line[$this->column_name[$table_num][$column_nr]]; $valuez = $value; } $value1 = $this->column_lkup_val[$table_num][$column_nr]; $length = $this->column_length[$table_num][$column_nr]; if( $this->column_lkup_num[$table_num][$column_nr] == -1 ) { $value1 = $value; } if( $this->column_selection[$table_num][$column_nr]>0 ) { echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->column_name[$table_num][$column_nr]; echo "\" VALUE=\"" . eregi_replace( "\"", """, $column_select[$column_nr] ) . "\">"; continue; } else { echo "<TR>"; echo "<TD id=\"lft\">"; echo $this->column_value[$table_num][$column_nr]; echo "</TD>"; echo "<TD id=\"rgh\">"; } if( ( !strncmp( $this->column_lkup_use[$table_num][$column_nr], "lookup", 6 ) || !strcmp( $this->column_lkup_use[$table_num][$column_nr], "default" ) ) && $this->column_lkup_tbl[$table_num][$column_nr] && strcasecmp( $this->column_protected[$table_num][$column_nr], "auto" ) ) { for( $co_nr=0; $co_nr<=$this->num_columns[$table_num]; $co_nr++ ) { for( $n=0; $n<=$this->num_columns[$table_num]; $n++ ) { if( $this->column_ext_num[$table_num][$co_nr] == $n ) { $this->column_ext_val[$table_num][$co_nr]=$line[$this->column_name[$table_num][$n]]; break; } } } $query2 = "select " . $this->column_lkup_dis[$table_num][$column_nr]; $query2 = $query2 . ", " . $this->column_lkup_col[$table_num][$column_nr]; $query2 = $query2 . " from " . $this->column_lkup_tbl[$table_num][$column_nr]; $query3 = ""; if( $this->column_lkup_lan[$table_num][$column_nr] ) { $query3 = " where " . $this->column_lkup_lan[$table_num][$column_nr] . "= '" . $this->db_langue ."'"; } if( $this->column_ext_col[$table_num][$column_nr] && isset( $this->column_ext_val[$table_num][$column_nr]) ) { if( $query3 ) { $query3 = $query3 . " and " . $this->column_ext_col[$table_num][$column_nr]; } else { $query3 = $query3 . " where " . $this->column_ext_col[$table_num][$column_nr]; } $query3 = $query3 . "= '" . $this->column_ext_val[$table_num][$column_nr] ."'"; } $query2 = $query2 . $query3; if( !strcmp( $this->column_lkup_use[$table_num][$column_nr], "lookup+" ) ) { $query2 = $query2 . " order by " . $this->column_lkup_col[$table_num][$column_nr]; } else{ $query2 = $query2 . " order by " . $this->column_lkup_dis[$table_num][$column_nr]; } $result2 = mysql_query( $query2 ) or die("Query2 failed: " . $query2 . " " . mysql_error()); if( $this->column_main_index[$table_num][$column_nr]==0 ) { echo "<SELECT NAME=\"" . $this->column_name[$table_num][$column_nr] . "\" size=\"1\">\n"; } $j=0; while( $line2 = mysql_fetch_assoc( $result2 ) ) { if( $j==0 && substr($this->column_lkup_use[$table_num][$column_nr],-1,1)=='-' ) { $j++; if( $valuez == "" ) { echo "<OPTION VALUE=\"\" SELECTED>\n"; } else { echo "<OPTION VALUE=\"\">\n"; } } $value = $line2[$this->column_lkup_col[$table_num][$column_nr]]; $value1 = $line2[$this->column_lkup_dis[$table_num][$column_nr]]; if( $this->column_main_index[$table_num][$column_nr]==0 ) { echo "<OPTION VALUE=\"" . $value . "\""; if( !strcmp( $valuez, $value ) ) { echo " SELECTED"; } echo ">"; if( !strcmp( $this->column_lkup_use[$table_num][$column_nr], "lookup+" ) ) { echo $value . " - "; } echo $value1 . "\n"; } else { if( !strcmp( $line[$this->column_name[$table_num][$column_nr]], $value ) ) { echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->column_name[$table_num][$column_nr]; echo "\" VALUE=\"" . eregi_replace( "\"", """, $value ) . "\">\n"; if( !strcmp( $this->column_lkup_use[$table_num][$column_nr], "lookup+" ) ) { echo $value . " - "; } echo $value1 . "\n"; } } } if( $this->column_main_index[$table_num][$column_nr]==0 ) { echo "</SELECT>\n"; } } else { if( !strcmp( $this->column_default[$table_num][$column_nr], "\$USERS" ) ) { $PHP_AUTH_USER = addslashes( $_SERVER['PHP_AUTH_USER'] ); $PHP_AUTH_PW = md5( $_SERVER['PHP_AUTH_PW'] ); $query0 = "SELECT " . $this->user_name . ", " . $this->user_langue; $query0 = $query0 . " FROM " . $this->user_table; $query0 = $query0 . " WHERE " . $this->user_login . "='" . $PHP_AUTH_USER . "'"; $query0 = $query0 . " AND " . $this->user_passwd . "='" . $PHP_AUTH_PW . "'"; $result0 = mysql_query( $query0 ) or die( mysql_error() ); $user_data = mysql_fetch_assoc( $result0 ); $utente = $user_data[$this->user_name]; mysql_free_result( $result0 ); $query0 = "SELECT " . $this->user_name . ", " . $this->user_langue; $query0 = $query0 . " FROM " . $this->user_table; $query0 = $query0 . " ORDER BY " . $this->user_name; $result0 = mysql_query( $query0 ) or die( mysql_error() ); echo "<SELECT NAME=\"" . $this->column_name[$table_num][$column_nr] . "\" size=\"1\">\n"; while( $user_data = mysql_fetch_assoc( $result0 )) { $value = $user_data[$this->user_name]; $value1 = $user_data[$this->user_name]; echo "<OPTION VALUE=\"" . $value . "\""; if( !strcmp( $values, $value ) ) { echo " SELECTED"; } echo ">" . $value1 . "\n"; } echo "</SELECT>\n"; mysql_free_result( $result0 ); } else { if( $this->column_default[$table_num][$column_nr]=="\$TODAY" && !strcasecmp( $this->column_protected[$table_num][$column_nr], "yes" ) ) { $value = date( "Y-m-d H:i:s" ); $length = strlen( $value ); } if( $this->column_default[$table_num][$column_nr]=="\$USER" && !strcasecmp( $this->column_protected[$table_num][$column_nr], "yes" ) ) { $PHP_AUTH_USER = addslashes( $_SERVER['PHP_AUTH_USER'] ); $PHP_AUTH_PW = md5( $_SERVER['PHP_AUTH_PW'] ); $query0 = "SELECT " . $this->user_name . ", " . $this->user_langue; $query0 = $query0 . " FROM " . $this->user_table; $query0 = $query0 . " WHERE " . $this->user_login . "='" . $PHP_AUTH_USER . "'"; $query0 = $query0 . " AND " . $this->user_passwd . "='" . $PHP_AUTH_PW . "'"; $result0 = mysql_query( $query0 ) or die( mysql_error() ); $user_data = mysql_fetch_assoc( $result0 ); $utente = $user_data[$this->user_name]; mysql_free_result( $result0 ); $value = $utente; $length = strlen( $value ); } $tipo = "text"; if( !strcasecmp( $this->column_protected[$table_num][$column_nr], "yes" ) || $this->column_main_index[$table_num][$column_nr]>0 ) { $tipo = "hidden"; echo $value; } if( $this->column_type[$table_num][$column_nr]=="file" ) { $tipo = "file"; echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->column_name[$table_num][$column_nr]; echo "\" VALUE=\"" . eregi_replace( "\"", """, $value ) . "\">"; echo "<INPUT TYPE=\"" . $tipo . "\" NAME=\"" . $this->column_name[$table_num][$column_nr] . "file"; echo "\" VALUE=\"" . eregi_replace( "\"", """, $value ) . "\" "; if( $this->lunghezza != 0 ) { echo "style=\"width:" . ( $this->lunghezza - 70 ). "\""; } echo ">"; if( $value ) { echo " (" . basename( $value ) . ")"; } } else { if( !strcasecmp( $this->column_protected[$table_num][$column_nr], "auto" ) ) { echo $this->name_auto; } else { echo "<INPUT TYPE=\"" . $tipo . "\" NAME=\"" . $this->column_name[$table_num][$column_nr]; echo "\" SIZE=\"" . $length . "\""; echo " VALUE=\"" . eregi_replace( "\"", """, $value ) . "\" "; if( $this->lunghezza != 0 ) { echo "style=\"width:" . $this->lunghezza . "\""; } echo ">"; } } } } if( strlen( $errore ) ) { echo "  " . $errore; } if( $this->column_selection[$table_num][$column_nr]>0 ) { echo "</TD>"; echo "</TR>"; } echo "\n"; } echo "</TABLE>\n"; echo "<P><TABLE id=nasc><TR><TD id=hea>"; $this->dxfButton( "Submit", "$this->name_go", "no", "", $table_num, "" ); echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->update . "\" VALUE=\"" . $this->update . "\">"; echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_table_num . "\" VALUE=\"" . $table_num . "\">"; echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_proc_ref . "\" VALUE=\"" . $this->db_proc . "\">"; echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_langue_name . "\" VALUE=\"" . $this->db_langue . "\">"; echo "\n"; echo "</FORM>\n"; echo "</TD>\n<TD id=hea>"; $this->dxfButton( "ins2", $this->name_giveup, "index", "POST", $table_num, "" ); echo "</TD></TR></TABLE>"; } // Prepare general query function tablePrepareQBE( ) { $table_num=0; echo "<DIV ID=\"tit\">" . $this->table_value[$table_num] . "</DIV>\n"; echo "<P>\n"; $this->dxfButton( "qbe2", $this->name_search, "no", "", 0, "" ); echo "<TABLE id=nasc>\n"; echo "<TR>"; echo "<TD id=\"tit\" colspan=\"9\">"; // echo $this->table_value[$table_num]; echo "</TD></TR>\n"; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_selection[$table_num][$column_nr]>0 ) { echo "<TR>"; echo "<TD id=\"lft\">"; echo $this->column_short[$table_num][$column_nr]; echo "</TD>"; echo "<TD id=\"mid\">"; echo "<SELECT NAME=\"" . $this->table_name[$table_num] . $this->column_name[$table_num][$column_nr] . "_view\" size=\"1\">\n"; if( $this->column_view[$table_num][$column_nr] ) { echo "<OPTION VALUE=\"1\" SELECTED>"; echo $this->name_see . "\n"; echo "<OPTION VALUE=\"0\">"; echo $this->name_not_see . "\n"; } else { echo "<OPTION VALUE=\"0\" SELECTED>"; echo $this->name_not_see . "\n"; echo "<OPTION VALUE=\"1\">"; echo $this->name_see . "\n"; } echo "</SELECT>\n"; echo "</TD>"; echo "<TD id=\"mid\">"; echo "<SELECT NAME=\"" . $this->table_name[$table_num] . $this->column_name[$table_num][$column_nr] . "_oper\" SIZE=\"1\">\n"; for( $o=0; $o<=$this->num_operators; $o++ ) { echo "<OPTION VALUE=\"" . $this->operator[$o] . "\""; if( $this->column_operator[$table_num][$column_nr]==$this->operator[$o] ) { echo " SELECTED"; } echo ">" . $this->operator_descr[$o] . "\n"; } echo "</SELECT>\n"; echo "</TD>"; echo "<TD id=\"rgh\">"; if( ( !strncmp( $this->column_lkup_use[$table_num][$column_nr], "lookup", 6 ) || !strncmp( $this->column_lkup_use[$table_num][$column_nr], "default", 6 ) ) && $this->column_lkup_tbl[$table_num][$column_nr] ) { $query2 = "select " . $this->column_lkup_dis[$table_num][$column_nr] . ", " . $this->column_lkup_col[$table_num][$column_nr]; $query2 = $query2 . " from " . $this->column_lkup_tbl[$table_num][$column_nr]; if( isset( $this->column_lkup_lan[$table_num][$column_nr] ) ) { $query2 = $query2 . " where "; $query2 = $query2 . $this->column_lkup_lan[$table_num][$column_nr] . "= '" . $this->db_langue ."'"; } $result2 = mysql_query( $query2 ) or die("Query2 failed: " . $query2 . " " . mysql_error()); echo "<SELECT NAME=\"" . $this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr] . "\" size=\"1\">\n"; echo "<OPTION VALUE=\"\">\n"; while( $line2 = mysql_fetch_assoc( $result2 ) ) { $value = $line2[$this->column_lkup_col[$table_num][$column_nr]]; $value1 = $line2[$this->column_lkup_dis[$table_num][$column_nr]]; echo "<OPTION VALUE=\"" . $value . "\">" . $value1 . "\n"; } echo "</SELECT>\n"; } else { echo "<INPUT TYPE=\"text\" NAME=\"" . $this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr]; if( $this->column_type[$table_num][$column_nr]=="file" ) { echo "\">"; } else { echo "\" SIZE=\"" . $this->column_length[$table_num][$column_nr] . "\">"; } } echo "</TD>"; echo "</TR>"; echo "\n"; } } for( $table_num=0; $table_num<=$this->num_tables; $table_num++ ) { if( $table_num ) { echo "<TR>"; echo "<TD id=\"tit\" colspan=\"9\">"; echo $this->table_value[$table_num]; echo "</TD></TR>\n"; } // echo "<TR><TD id=\"rgh\"> </TD><TD id=\"rgh\"> </TD></TR>\n"; $value1 = ""; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { $value = ""; $length = $this->column_length[$table_num][$column_nr]; if( $this->column_lkup_num[$table_num][$column_nr] == -1 ) { $value1 = $value; } if( $this->column_selection[$table_num][$column_nr]>0 ) { continue; } echo "<TR>"; echo "<TD id=\"lft\">"; echo $this->column_short[$table_num][$column_nr]; echo "</TD>"; echo "<TD id=\"mid\">"; echo "<SELECT NAME=\"" . $this->table_name[$table_num] . $this->column_name[$table_num][$column_nr] . "_view\" size=\"1\">\n"; if( $this->column_view[$table_num][$column_nr] ) { echo "<OPTION VALUE=\"1\" SELECTED>"; echo $this->name_see . "\n"; echo "<OPTION VALUE=\"0\">"; echo $this->name_not_see . "\n"; } else { echo "<OPTION VALUE=\"0\" SELECTED>"; echo $this->name_not_see . "\n"; echo "<OPTION VALUE=\"1\">"; echo $this->name_see . "\n"; } echo "</SELECT>\n"; echo "</TD>"; echo "<TD id=\"mid\">"; echo "<SELECT NAME=\"" . $this->table_name[$table_num] . $this->column_name[$table_num][$column_nr] . "_oper\" SIZE=\"1\">\n"; for( $o=0; $o<=$this->num_operators; $o++ ) { echo "<OPTION VALUE=\"" . $this->operator[$o] . "\""; if( $this->column_operator[$table_num][$column_nr]==$this->operator[$o] ) { echo " SELECTED"; } echo ">" . $this->operator_descr[$o] . "\n"; } echo "</SELECT>\n"; echo "</TD>"; echo "<TD id=\"rgh\">"; if( ( !strncmp( $this->column_lkup_use[$table_num][$column_nr], "lookup", 6 ) || !strcmp( $this->column_lkup_use[$table_num][$column_nr], "default" ) ) && $this->column_lkup_tbl[$table_num][$column_nr] && strcasecmp( $this->column_protected[$table_num][$column_nr], "auto" ) ) { $query2 = "select " . $this->column_lkup_dis[$table_num][$column_nr]; $query2 = $query2 . ", " . $this->column_lkup_col[$table_num][$column_nr]; $query2 = $query2 . " from " . $this->column_lkup_tbl[$table_num][$column_nr]; $query3 = ""; if( $this->column_lkup_lan[$table_num][$column_nr] ) { $query3 = $query3 . " where " . $this->column_lkup_lan[$table_num][$column_nr] . "= '" . $this->db_langue ."'"; } $query2 = $query2 . $query3; if( !strcmp( $this->column_lkup_use[$table_num][$column_nr], "lookup+" ) ) { $query2 = $query2 . " order by " . $this->column_lkup_col[$table_num][$column_nr]; } else{ $query2 = $query2 . " order by " . $this->column_lkup_dis[$table_num][$column_nr]; } $result2 = mysql_query( $query2 ) or die("Query2 failed: " . $query2 . " " . mysql_error()); echo "<SELECT NAME=\"" . $this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr] . "\" size=\"1\">\n"; echo "<OPTION VALUE=\"\">\n"; while( $line2 = mysql_fetch_assoc( $result2 ) ) { $value = $line2[$this->column_lkup_col[$table_num][$column_nr]]; $value1 = $line2[$this->column_lkup_dis[$table_num][$column_nr]]; echo "<OPTION VALUE=\"" . $value . "\">"; if( !strcmp( $this->column_lkup_use[$table_num][$column_nr], "lookup+" ) ) { echo $value . " - " . $value1 . "\n"; } else{ echo $value1 . "\n"; } } echo "</SELECT>\n"; mysql_free_result($result2); } else { if( $this->column_default[$table_num][$column_nr]=="\$USERS" || $this->column_default[$table_num][$column_nr]=="\$USER" ) { $PHP_AUTH_USER = addslashes( $_SERVER['PHP_AUTH_USER'] ); $PHP_AUTH_PW = md5( $_SERVER['PHP_AUTH_PW'] ); $query0 = "SELECT " . $this->user_name . ", " . $this->user_langue; $query0 = $query0 . " FROM " . $this->user_table; $query0 = $query0 . " WHERE " . $this->user_login . "='" . $PHP_AUTH_USER . "'"; $query0 = $query0 . " AND " . $this->user_passwd . "='" . $PHP_AUTH_PW . "'"; $result0 = mysql_query( $query0 ) or die( mysql_error() ); $user_data = mysql_fetch_assoc( $result0 ); $utente = $user_data[$user_name]; mysql_free_result( $result0 ); $query0 = "SELECT " . $this->user_name . ", " . $this->user_langue; $query0 = $query0 . " FROM " . $this->user_table; $query0 = $query0 . " ORDER BY " . $this->user_name; $result0 = mysql_query( $query0 ) or die( mysql_error() ); echo "<SELECT NAME=\"" . $this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr] . "\" size=\"1\">\n"; echo "<OPTION VALUE=\"\">\n"; while( $user_data = mysql_fetch_assoc( $result0 )) { $value = $user_data[$this->user_name]; $value1 = $user_data[$this->user_name]; echo "<OPTION VALUE=\"" . $value . "\""; echo ">" . $value1 . "\n"; } echo "</SELECT>\n"; mysql_free_result( $result0 ); } else { echo "<INPUT TYPE=\"text\" NAME=\"" . $this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr]; if( $this->column_type[$table_num][$column_nr]=="file" ) { echo "\">"; } else { echo "\" SIZE=\"" . $this->column_length[$table_num][$column_nr] . "\">"; } } } if( $this->column_selection[$table_num][$column_nr]>0 ) { echo "</TD>"; echo "</TR>"; } echo "\n"; } echo "<TR><TD id=\"rgh\"> </TD><TD id=\"rgh\"> </TD></TR>\n"; echo "<TR>"; } echo "<TR><TD id=\"rgh\" colspan=4>"; $this->dxfButton( "Submit", "$this->name_search", "no", "", $table_num, "" ); echo "</TD></TR>\n"; echo "</TABLE>\n"; echo "</FORM>\n"; echo "<TABLE>\n"; echo "<TR><TD id=\"rgh\" colspan=4>"; $this->goBack(); echo "</TD></TR>\n"; echo "</TABLE>\n"; echo "</BODY>\n"; } // Execute general query function tableExecQBE( ) { // error_reporting(E_ALL ^ E_NOTICE); error_reporting( 0 ); $table_num = 0; echo "<DIV ID=\"tit\">" . $this->table_value[$table_num] . "</DIV>\n"; echo "<P>\n"; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { for( $n=0; $n<=$this->num_columns[$table_num]; $n++ ) { if( $this->column_lkup_num[$table_num][$column_nr] == $n ) { $this->column_lkup_val[$table_num][$column_nr]=$_POST[$this->table_name[$table_num] . "_" . $this->column_name[$table_num][$n]]; break; } } } for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { $value = $_POST[$this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr]]; $value1 = $this->column_lkup_val[$table_num][$column_nr]; $length = $this->column_length[$table_num][$column_nr]; if( $this->column_lkup_num[$table_num][$column_nr] == -1 ) { $value1 = $value; } } $query1 = ""; for( $table_num=0; $table_num<=$this->num_tables; $table_num++ ) { if( strcasecmp( $this->table_seldisplay[$table_num], "yes" ) ) { continue; } for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { $view = $this->table_name[$table_num] . $this->column_name[$table_num][$column_nr] . "_view"; if( $this->column_main_index[$table_num][$column_nr] || $_POST[$view] ) { if( $query1 ) { $query1 = $query1 . ", "; } $query1 = $query1 . $this->table_name[$table_num] . "." . $this->column_name[$table_num][$column_nr]; $query1 = $query1 . " " . $this->table_name[$table_num] . $this->column_name[$table_num][$column_nr]; } } } $query = "select distinct " . $query1; $query1 = ""; for( $table_num=0; $table_num<=$this->num_tables; $table_num++ ) { $seldisplay[$table_num]=1; if( strcasecmp( $this->table_seldisplay[$table_num], "yes" ) ) { $seldisplay[$table_num]=0; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( strlen( $_POST[$this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr]] ) ) { $seldisplay[$table_num]=1; break; } } } if( !$seldisplay[$table_num] ) { continue; } if( $query1 ) { $query1 = $query1 . ", "; } $query1 = $query1 . $this->table_name[$table_num]; } $query = $query . " from " . $query1; $query1 = ""; for( $table_num=0; $table_num<=$this->num_tables; $table_num++ ) { for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( strlen( $_POST[$this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr]] ) ) { if( $query1 ) { $query1 = $query1 . " and "; } $oper = $_POST[$this->table_name[$table_num] . $this->column_name[$table_num][$column_nr] . "_oper" ]; if( $oper == "match" ) { $query1 .= "match ( "; $query1 .= $this->table_name[$table_num] . "." . $this->column_name[$table_num][$column_nr]; $query1 .= " ) against ( '"; $query1 .= $_POST[$this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr]] . "'"; $query1 .= " IN BOOLEAN MODE ) "; } else { $query1 .= $this->table_name[$table_num] . "." . $this->column_name[$table_num][$column_nr] . " "; $query1 .= $_POST[$this->table_name[$table_num] . $this->column_name[$table_num][$column_nr] . "_oper" ] . "'"; $query1 .= $_POST[$this->table_name[$table_num] . "_" . $this->column_name[$table_num][$column_nr]] . "'"; } } } } for( $column_nr=0; $column_nr<=$this->num_columns[0]; $column_nr++ ) { if( $this->column_selection[0][$column_nr] ) { for( $table_num=1; $table_num<=$this->num_tables; $table_num++ ) { if( !$seldisplay[$table_num] ) { continue; } if( $query1 ) { $query1 = $query1 . " and "; } $query1 = $query1 . $this->table_name[0] . "." . $this->column_name[0][$column_nr] . "="; $query1 = $query1 . $this->table_name[$table_num] . "." . $this->column_name[$table_num][$column_nr]; } } } if( $query1 ) { $query .= " where " . $query1; } $query1 = ""; for( $table_num=0; $table_num<=$this->num_tables; $table_num++ ) { if( !$seldisplay[$table_num] ) { continue; } for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { if( $this->column_main_index[$table_num][$column_nr]>0 ) { if( $query1 ) { $query1 = $query1 . ", "; } $query1 = $query1 . $this->table_name[$table_num] . "." . $this->column_name[$table_num][$column_nr]; } } } $query = $query . " group by " . $query1 . " order by " . $query1; // echo $query . "<br>\n"; echo "<table>\n"; echo "<tr>\n"; for( $table_num=0; $table_num<=$this->num_tables; $table_num++ ) { for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { $selee[$column_nr]=0; } } $z=0; for( $table_num=0; $table_num<=$this->num_tables; $table_num++ ) { if( strcasecmp( $this->table_seldisplay[$table_num], "yes" ) ) { continue; } echo "<TD id=\"listhea\">"; echo $name_action; $z++; echo "</TD>"; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { $view = $this->table_name[$table_num] . $this->column_name[$table_num][$column_nr] . "_view"; if( $this->column_main_index[$table_num][$column_nr] || $_POST[$view] ) { if( $this->column_selection[$table_num][$column_nr]>0 ) { if( $selee[$column_nr]==1 ) { continue; } else { $selee[$column_nr]=1; } } echo "<TD id=\"listhea\">"; echo $this->column_short[$table_num][$column_nr]; $z++; echo "</td>\n"; } } } echo "</tr>\n"; for( $m=0; $m<=$this->conn_number; $m++ ) { $db = mysql_connect( $this->conn_hostname[$m], $this->conn_username[$m], $this->conn_passwd[$m] ); if ($db == FALSE) { echo "<tr><td colspan=\"$z\"><DIV Id=\"Err\"><CENTER>" . $this->conn_conname[$m] . " " . $this->name_unavail . "</CENTER></DIV></td></tr>\n"; continue; } mysql_select_db($this->conn_dbname[$m], $db) or die( mysql_error() ); $result = mysql_query( $query ) or die("Query failed: " . $query . " " . mysql_error()); $liststyle=0; while( $line = mysql_fetch_assoc( $result ) ) { for( $table_num=0; $table_num<=$this->num_tables; $table_num++ ) { for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { $sele[$column_nr]=0; } } $liststyle = 1 - $liststyle; echo "<tr>\n"; for( $table_num=0; $table_num<=$this->num_tables; $table_num++ ) { if( strcasecmp( $this->table_seldisplay[$table_num], "yes" ) ) { continue; } echo "<TD id=\"listrgh" . $liststyle . "\">"; $this->dxfButton( "vis", "$this->name_see", "no", "", $table_num, "" ); $this->dxfButton( "Submit", "$this->name_see", "no", "", $table_num, "" ); for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { $view = $this->table_name[$table_num] . $this->column_name[$table_num][$column_nr] . "_view"; if( $this->column_main_index[$table_num][$column_nr] || $_POST[$view] ) { echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->column_name[$table_num][$column_nr]; $ncl = $this->table_name[$table_num] . $this->column_name[$table_num][$column_nr]; echo "\" VALUE=\"" . eregi_replace( "\"", """, $line[$ncl] ) . "\">"; } } echo "<INPUT TYPE=\"hidden\" NAME=\"" . $this->db_conn_conname . "\" VALUE=\"" . $this->conn_conname[$m] . "\">"; echo "</FORM>\n"; echo "</TD>"; for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { for( $n=0; $n<=$this->num_columns[$table_num]; $n++ ) { if( $this->column_ext_num[$table_num][$column_nr] == $n ) { $ncl = $this->table_name[$table_num] . $this->column_name[$table_num][$n]; $this->column_ext_val[$table_num][$column_nr]=$line[$ncl]; break; } } } for( $column_nr=0; $column_nr<=$this->num_columns[$table_num]; $column_nr++ ) { $view = $this->table_name[$table_num] . $this->column_name[$table_num][$column_nr] . "_view"; if( $this->column_main_index[$table_num][$column_nr] || $_POST[$view] ) { if( $this->column_selection[$table_num][$column_nr]>0 ) { if( $sele[$column_nr]==1 ) { continue; } else { $sele[$column_nr]=1; } } echo "<TD id=\"listrgh" . $liststyle . "\">"; $ncl = $this->table_name[$table_num] . $this->column_name[$table_num][$column_nr]; $value = $line[$ncl]; if( !strncmp( $this->column_lkup_use[$table_num][$column_nr], "lookup", 6 ) && $this->column_lkup_tbl[$table_num][$column_nr] && strcasecmp( $this->column_protected[$table_num][$column_nr], "auto" ) ) { $query2 = "select " . $this->column_lkup_dis[$table_num][$column_nr] . " from " . $this->column_lkup_tbl[$table_num][$column_nr]; $query2 = $query2 . " where " . $this->column_lkup_col[$table_num][$column_nr] . "= '" . eregi_replace ( "'", "\\'", eregi_replace( "\"", "\\\"", $value ) ) . "' "; if( $this->column_lkup_lan[$table_num][$column_nr] ) { $query2 = $query2 . "and " . $this->column_lkup_lan[$table_num][$column_nr] . "= '" . $this->db_langue . "'"; } if( $this->column_ext_col[$table_num][$column_nr] ) { $query2 = $query2 . " and " . $this->column_ext_col[$table_num][$column_nr] . "= '" . $this->column_ext_val[$table_num][$column_nr] ."'"; } $result2 = mysql_query( $query2 ) or die("Query2 failed: " . $query2 . " " . mysql_error()); $line2 = mysql_fetch_assoc( $result2 ); if( $this->column_lkup_use[$table_num][$column_nr]=="lookup+" ) { $value = $value . " - " . $line2[$this->column_lkup_dis[$table_num][$column_nr]]; } else { $value = $line2[$this->column_lkup_dis[$table_num][$column_nr]]; } } if( $this->column_type[$table_num][$column_nr]=="file" ) { if( $value ) { echo "<A HREF=\"" . $line[$ncl] . "\">" . basename( $value ) . "</A>"; } } else { // echo "<INPUT TYPE=\"text\" NAME=\"" . $this->table_name[$table_num] . $this->column_name[$table_num][$column_nr]; // echo "\" SIZE=\"" . strlen($value) . "\""; // echo " VALUE=\"" . eregi_replace( "\"", """, $value ) . "\">"; echo eregi_replace( "\"", """, $value ); } echo "</TD>"; } } } echo "</tr>\n"; } ob_flush(); flush(); mysql_free_result($result); mysql_close($db); } echo "</table>\n"; echo "<table><tr><td>\n"; $this->dxfButton( "search", $this->name_back, "yes", "", 0, "" ); echo "</td><td>\n"; $this->dxfButton( "index", $this->name_proc, "yes", "", 0, "" ); echo "</td></tr></table>\n"; echo "<P>\n"; echo "</BODY>\n"; } // main loop for procedures function mainProcedures( $langue, $proce ) { $needed_level = "manage"; $this->noinput="no"; $this->tbl_config( $needed_level, "" ); if ( $this->db_langue ) { $langue = $this->db_langue; } // $db=$this->tbl_config( '', '' ); echo "<HEAD>\n"; echo "<meta http-equiv=\"Content-Type\" content=\"text/html;charset=utf8\" />"; echo "<TITLE>$this->name_title</TITLE>\n"; echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"dr_style.css\" >\n"; echo "</HEAD>\n"; echo "<BODY><CENTER>\n"; $query = "select " . $this->procedure_sequence_name . ", "; $query .= $this->procedure_name . ", " . $this->procedure_description . ", "; $query .= $this->procedure_startup . ", " . $this->procedure_visible . ", "; $query .= $this->procedure_authentication . ", "; $query .= $this->procedure_url . ", " . $this->procedure_group . ", "; $query .= $this->procedure_url . ", " . $this->procedure_limited; $query .= " from " . $this->procedure_table_name . " where "; $query .= $this->procedure_visible . "='yes' "; $query .= "and " . $this->procedure_group . "='" . $proce . "' "; $query .= " and " . $this->procedure_langue . "='"; // if( isset( $_SERVER["HTTP_ACCEPT_LANGUAGE"] ) ) { // $query .= substr( $_SERVER["HTTP_ACCEPT_LANGUAGE"], 0, 2 ) . "' "; // } else { $query .= $langue . "' "; // } if( strlen( $this->db_contesto ) ) { $query .= " and " . $this->procedure_limited . "<>'#CONTEXT'"; } else { $query .= " and " . $this->procedure_limited . "<>'#NOCONTEXT'"; } $query .= " order by " . $this->procedure_sequence_name; $result = mysql_query( $query ) or die("Query PRE failed: " . $query . " " . mysql_error()); echo "<H2>$this->name_title</H2>"; for( $j=0 ; $line = mysql_fetch_assoc( $result ); $j++ ) { if( isset( $_POST[$this->db_name_id] ) ) { echo "<FORM NAME='index" . $j . "' ID='index$j'>\n"; echo "<INPUT TYPE=hidden NAME=\""; echo $this->db_proc_ref . "\" VALUE=\"" . $line[$this->procedure_name] . "\">\n"; echo "<INPUT TYPE=hidden NAME=\""; echo $this->db_name_link . "\" VALUE=\"" . $line[$this->procedure_startup] . "\">\n"; echo "<A HREF=\"javascript:ajaxHTTPHandler(" . $_POST[$this->db_name_id] . ",'" ; echo $this->db_host_link . ltrim( $_SERVER['PHP_SELF'], '/' ); echo "',document.getElementById('index$j'));\">"; echo $line[$this->procedure_description]; echo "</A><BR>"; echo "</FORM>\n"; } else { echo "<A HREF=\""; if( isset( $line[$this->procedure_url] ) ) { if( $line[$this->procedure_url][strlen($line[$this->procedure_url])-1] == '@' ) { echo "http"; if( isset( $_SERVER['HTTPS'] ) ) { echo "s"; } echo "://"; echo $line[$this->procedure_url]; echo $_SERVER['SERVER_NAME'] . "/"; echo ltrim( $_SERVER['PHP_SELF'], '/' ); } else { echo $this->db_host_link . ltrim( $_SERVER['PHP_SELF'], '/' ); echo "/../" . $line[$this->procedure_url]; if( $this->db_contesto != "" && $line[$this->procedure_url][strlen($line[$this->procedure_url])-1]=="=" ) { echo $this->db_contesto . "&"; } } } else { echo $this->db_host_link . ltrim( $_SERVER['PHP_SELF'], '/' ); echo "?" . $this->db_proc_ref; echo "=" . $line[$this->procedure_name]; echo "&" . $this->db_name_link; echo "=" . $line[$this->procedure_startup]; } echo "\">" . $line[$this->procedure_description] ."</A><BR>\n"; } } $this->endDxfTableManagement(); } // main program loop function mainLoop( $db_host, $db_name, $db_user, $db_passwd, $proce, $startup, $langue ) { // force browser to use correct language header('Content-Type: text/html; charset=utf-8'); $this->db_host = $db_host; $this->db_name = $db_name; $this->db_user = $db_user; $this->db_password = $db_passwd; $link = $startup; $procedure = $proce; if( isset( $_GET[$this->db_proc_ref] ) ) { $procedure = $_GET[$this->db_proc_ref]; } if( isset( $_GET[$this->db_name_link] ) ) { $link = $_GET[$this->db_name_link]; } if( isset( $_POST[$this->db_proc_ref] ) ) { $procedure = $_POST[$this->db_proc_ref]; } if( isset( $_POST[$this->db_name_link] ) ) { $link = $_POST[$this->db_name_link]; } switch( $link ) { case "" : case "index" : // Displays initial table management $this->mainProcedures( $langue, $proce ); break; case "del" : // Displays data and asks confirmation before deletion // Posts deletion to del2 $needed_level = "manage"; $this->tbl_config( $needed_level, $procedure ); $j = $_POST[$this->db_table_num]; for( $k=0; $k<=$this->num_columns[$j]; $k++ ) { if( $this->column_selection[$j][$k]>0 ) { $this->column_select[$k]=$_POST[$this->column_name[$j][$k]]; } } $this->pageHeader( $j, "delete" ); $this->tableDisplay( $j ); echo "<P><TABLE id=nasc><TR><TD id=hea>\n"; $this->dxfButton( "del2", $this->name_go, "delete", "POST", $j, "" ); echo "</TD><TD id=hea>\n"; $this->dxfButton( "ins2", $this->name_giveup, "index", "POST", $j, "" ); echo "</TD></TR></TABLE>\n"; $this->endDxfTableManagement(); exit(); break; case "del2" : // Performs deletion and then displays data $needed_level = "manage"; $this->tbl_config( $needed_level, $procedure ); $j = $_POST[$this->db_table_num]; if( $_POST[$this->delete] ) { $this->tableDelete( $j ); } $j=0; $this->pageHeader( $j, "proc" ); $this->procedureManagement(); $this->endDxfTableManagement(); exit(); break; case "ins" : // Prepares form to collect data to be inserted $needed_level = "manage"; $this->tbl_config( $needed_level, $procedure ); $j = $_POST[$this->db_table_num]; $this->tablePrepareInsert( $j ); exit(); break; case "ins2" : // if any, inserts data. Then displays data $needed_level = "manage"; $this->tbl_config( $needed_level, $procedure ); $j = $_POST[$this->db_table_num]; if( isset( $_POST[$this->insert] ) ) { if( $_POST[$this->insert] == $this->insert ) { if( $this->verifyValues( $j ) ) { $this->fileManagement( $j ); $this->tablePrepareInsert( $j ); $this->endDxfTableManagement(); exit(); } $this->fileManagement( $j ); $this->tableInsert( $j ); } else { if( $this->verifyValues( $j ) ) { if( $this->no_selection > 0 ) { echo "<DIV ID=\"tit\">" . $this->procedure_header . "</DIV>\n"; echo "<P>\n"; $result = $this->startQueryCreate(); echo "<TABLE>\n"; $this->startPageHeader(); $this->startPagePreviousOrNext( "pre" ); $this->startPageList( $result, "yes" ); $this->startPagePreviousOrNext( "post" ); echo "</TABLE>"; $this->startPageInsert( ); echo "<P>"; $this->goBack( ); } else { echo "<P>\n"; $this->procedureManagement( ); } $this->endDxfTableManagement( ); exit(); } $this->fileManagement( $j ); $this->tableInsert( $j ); } } $this->pageHeader( 0, "proc" ); $this->procedureManagement(); $this->endDxfTableManagement(); exit(); break; case "mod" : // Prepares to modify row data on tables $needed_level = "manage"; $this->tbl_config( $needed_level, $procedure ); $j = $_POST[$this->db_table_num]; $this->tablePrepareUpdate( $j ); $this->endDxfTableManagement(); exit(); break; case "mod2" : // Performs update on tables and then re-displays data $needed_level = "manage"; $this->tbl_config( $needed_level, $procedure ); $j = $_POST[$this->db_table_num]; if( $_POST[$this->update] ) { if( $this->verifyValues( $j ) ) { $this->fileManagement( $j ); $this->tablePrepareUpdate( $j ); $this->endDxfTableManagement(); exit(); } $this->fileManagement( $j ); $this->tableUpdate( $j ); } $this->pageHeader( 0, "proc" ); $this->procedureManagement(); $this->endDxfTableManagement(); exit(); break; case "qbe2" : // Performs query-by-example and displays result data $needed_level = "search"; $this->tbl_config( $needed_level, $procedure ); $this->tableExecQBE( ); $this->endDxfTableManagement(); exit(); break; case "search" : // Prepares query-by-example $needed_level = "search"; $this->tbl_config( $needed_level, $procedure ); $this->tablePrepareQBE(); $this->endDxfTableManagement(); exit(); break; case "start" : // Asks common columns data and posts to table management $needed_level = "manage"; $this->noinput="no"; $this->tbl_config( $needed_level, $procedure ); if( $this->no_selection > 0 ) { echo "<DIV ID=\"tit\">" . $this->procedure_header . "</DIV>\n"; echo "<P>\n"; $result = $this->startQueryCreate(); echo "<TABLE>\n"; $this->startPageHeader(); $this->startPagePreviousOrNext( "pre" ); $this->startPageList( $result, "yes" ); $this->startPagePreviousOrNext( "post" ); echo "</TABLE>"; $this->startPageInsert( ); echo "<P>"; $this->goBack( ); } else { echo "<P>\n"; $this->procedureManagement( ); } $this->endDxfTableManagement( ); exit(); break; case "vis" : // Displays details on rows from query-by-example $needed_level = "search"; $this->tbl_config( $needed_level, $procedure ); $j = $_POST[$this->db_table_num]; $this->noinput="yes"; $this->pageHeader( $j, "display" ); if( $conname = $_POST[$this->db_conn_conname] ) { for( $m=0; $m<=$this->conn_number; $m++ ) { if( $this->conn_conname[$m]==$conname ) { $db = mysql_connect( $this->conn_hostname[$m], $this->conn_username[$m], $this->conn_passwd[$m] ) or die( mysql_error( ) ); if ($db == FALSE) die ("Errore nella connessione al database. $this->conn_hostname[$m] - $this->conn_username[$m] - $this->conn_passwd[$m] - Contattare l'amministratore del sistema per segnalare il malfunzionamento della pagina."); mysql_select_db($this->conn_dbname[$m], $db) or die ("Errore nella selezione del database. $this->conn_dbname[$m] user - $this->conn_username[$m] - $this->conn_passwd[$m] - $this->conn_hostname[$m] Contattare l'amministratore del sistema per segnalare il malfunzionamento della pagina."); break; } } } if( $j==0 && $this->num_tables > 1 ) { $this->procedureManagement(); } else { $this->tableDisplay( $j ); } $this->endDxfTableManagement(); exit(); break; case "dis" : // Displays detail-table rows $needed_level = "manage"; $this->tbl_config( $needed_level, $procedure ); $j = $_POST[$this->db_table_num]; $this->noinput="no"; $this->pageHeader( $j, "display" ); $this->tableDisplay( $j ); echo "<P><TABLE id=nasc><TR><TD id=hea>\n"; $this->dxfButton( "ins2", $this->name_back, "index", "POST", $j, "" ); echo "</TD></TR></TABLE>\n"; $this->endDxfTableManagement(); exit(); break; } } } // Convenience script to ignite the device. function dxf_table_management_ignite( $db_host, $db_name, $db_user, $db_passwd, $db_proc, $db_start, $db_langue ) { // phpinfo(); error_reporting(E_ALL); // $db_proc=''; // $db_start=''; // $db_langue='it'; $dxf_table_management = new Dxf_table_management; $dxf_table_management->mainLoop( $db_host, $db_name, $db_user, $db_passwd, $db_proc, $db_start, $db_langue ); }						2011-07-28 Perseus Demo in Ligornetto Tnx HB9OAR / HB9TUZ 2011-06-12 OpenGL Radio Interface Proof of concept, see Projects, Code 2010-06-18 Rewrite MyLinScope V 4.0 Configuration from file, threaded X 2008-05-22 First ,MyLinScope release First MyLinScope code release, see projects and photos sections