function singleselect($string) { list($s_id, $singleselect) = explode(chr(9), $string, 2); $webservice = '1'; # include("../includes/select.php"); include "../includes/connect.php"; include "../includes/online.php"; $fp = fopen("../temp/soap.log", "a"); fwrite($fp, "A: " . $singleselect . "\n"); $linje = NULL; $singleselect = "select " . $singleselect; fwrite($fp, "B: " . $singleselect . "\n"); $r = 0; $q = db_select("{$singleselect}", __FILE__ . " linje " . __LINE__); while ($r < db_num_fields($q)) { $fieldName = db_field_name($q, $r); $fieldType = db_field_type($q, $r); $linje ? $linje .= chr(9) . $fieldName . "(" . $fieldType . ")" : ($linje = $fieldName . "(" . $fieldType . ")"); $r++; } $linje = NULL; $arraysize = $r; $fp = fopen("../temp/soap.log", "a"); fwrite($fp, "C: " . $singleselect . "\n"); $q = db_select("{$singleselect}", __FILE__ . " linje " . __LINE__); if ($r = db_fetch_array($q)) { $linje = NULL; for ($x = 0; $x < $arraysize; $x++) { $linje ? $linje .= chr(9) . $r[$x] : ($linje = $r[$x]); } } fwrite($fp, $linje . "\n"); fclose($fp); return '0' . chr(9) . $linje; }
function multiselect($string) { list($s_id, $multiselect) = explode(chr(9), $string); $webservice = '1'; # include("../includes/select.php"); include "../includes/connect.php"; include "../includes/online.php"; $linje = NULL; $filnavn = "../temp/{$db}/{$bruger_id}.csv"; if (!file_exists("../temp/{$db}")) { mkdir("../temp/{$db}"); } $fp = fopen($filnavn, "w"); $multiselect = "select " . $multiselect; $r = 0; $q = db_select("{$multiselect}", __FILE__ . " linje " . __LINE__); while ($r < db_num_fields($q)) { $fieldName = db_field_name($q, $r); $fieldType = db_field_type($q, $r); $linje ? $linje .= chr(9) . $fieldName . "(" . $fieldType . ")" : ($linje = $fieldName . "(" . $fieldType . ")"); $r++; } if (!$linje) { return '1' . chr(9) . 'fejl i query (' . $multiselect . ')'; } if ($fp) { fwrite($fp, "{$linje}\n"); } $q = db_select("{$multiselect}", __FILE__ . " linje " . __LINE__); while ($r = db_fetch_array($q)) { $linje = NULL; $arraysize = count($r); for ($x = 0; $x < $arraysize; $x++) { if (isset($r[$x])) { $r[$x] = str_replace(chr(9), "<TAB>", $r[$x]); $r[$x] = str_replace(chr(10), "<LF>", $r[$x]); $r[$x] = str_replace(chr(13), "<CR>", $r[$x]); $linje ? $linje .= chr(9) . $r[$x] : ($linje = $r[$x]); } } if ($fp) { fwrite($fp, "{$linje}\n"); } } fclose($fp); return "0" . chr(9) . "{$filnavn}"; /* #return ("$selectquery"); $q=db_select("$selectquery"); while ($r < db_num_fields($q)) { $fieldName = db_field_name($q, $r); { $svar.=$fieldName .chr(9); $r++; } } return ("$svar"); */ }
function tabeller($query, $header, $ny_side, $naeste_side, $print_table) { global $person; global $operation; global $ordrenr; global $ordre_id; global $sql_array; $result = db_select($query); if ($result) { print "<br><TABLE BORDER=\"1\">\n"; for ($header1 = 0; $header1 < count($header); ++$header1) { if ($header1 == 0) { print "<TR>\n"; } print "<TD>{$header[$header1]}</TD>\n"; if ($header1 == count($header)) { print "</TR>\n"; } } $antal_felter = db_num_fields($result); for ($raekke = 1; $r = db_fetch_row($result); ++$raekke) { for ($felter = 1; $felter <= $antal_felter; ++$felter) { if ($felter == 1 and $print_table == "ja") { print "<TR>\n"; } if ($print_table == "ja") { if ($felter == 1 and $ny_side == "ja") { print "<TR>\n"; $vaerdi = $r[$felter - 1]; print "<TD><A HREF=\"{$naeste_side}?id={$vaerdi}&person={$person}&operation={$operation}&ordrenr={$ordrenr}\">{$vaerdi}</A></TD>\n"; } else { $vaerdi = $r[$felter - 1]; print "<TD>{$vaerdi}</TD>"; } } $vaerdi = $r[$felter - 1]; $sql_array[$raekke][$felter] = $vaerdi; if ($antal_felter == $felter) { print "</TR>\n"; } } } print "</TABLE>"; } }
/** Get the content of $table as a series of INSERT statements. */ function get_table_content($table, $crlf) { $result = db_query("SELECT * FROM {$table}"); //prefix if required to table name before exporting. if (strlen(get_opendb_config_var('db_server', 'table_prefix')) > 0) { $table = get_opendb_config_var('db_server', 'table_prefix') . $table; } $i = 0; while ($row = db_fetch_row($result)) { $table_list = ""; for ($j = 0; $j < db_num_fields($result); $j++) { if (strlen($table_list) > 0) { $table_list .= ", "; } $table_list .= db_field_name($result, $j); } $table_list = "(" . $table_list . ")"; $schema_insert = ""; for ($j = 0; $j < db_num_fields($result); $j++) { if (strlen($schema_insert) > 0) { $schema_insert .= ", "; } if (!isset($row[$j])) { $schema_insert .= "NULL"; } else { if ($row[$j] != "") { $row[$j] = replace_newlines($row[$j]); // Escape normal addslashes: \', \", \\, \0 add to that \n $row[$j] = addcslashes($row[$j], "\\'\"\\\n"); $schema_insert .= "'" . $row[$j] . "'"; } else { $schema_insert .= "''"; } } } $schema_insert = "INSERT INTO {$table} {$table_list} VALUES (" . $schema_insert . ")"; // Get rid of newlines. $schema_insert = str_replace("\n", "", $schema_insert); $schema_insert = str_replace("\r", "", $schema_insert); echo trim($schema_insert) . ";" . $crlf; $i++; } return TRUE; }
function opdat_3_4($under_nr, $lap_nr) { $title = "opdat"; global $version; global $db; global $db_id; global $regnskab; global $regnaar; global $db_type; $s_id = session_id(); $nextver = '3.4.1'; if ($lap_nr < "1") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; if ($db != $sqdb) { transaktion('begin'); db_modify("ALTER TABLE ansatte ADD password text", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE ansatte ADD overtid numeric(1,0)", __FILE__ . " linje " . __LINE__); db_modify("UPDATE grupper set box1 = '{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); transaktion('commit'); } include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.4.2'; if ($lap_nr < "2") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; if ($db != $sqdb) { transaktion('begin'); $q = db_select("select * from ansatte", __FILE__ . " linje " . __LINE__); while ($i < db_num_fields($q)) { $feltnavne[$i] = db_field_name($q, $i); $i++; } if (!in_array('gruppe', $feltnavne)) { db_modify("ALTER TABLE ansatte ADD gruppe numeric(15,0)", __FILE__ . " linje " . __LINE__); db_modify("update ansatte set gruppe = '0'", __FILE__ . " linje " . __LINE__); } $q = db_select("select * from varer", __FILE__ . " linje " . __LINE__); while ($i < db_num_fields($q)) { $feltnavne[$i] = db_field_name($q, $i); $i++; } if (!in_array('indhold', $feltnavne)) { db_modify("ALTER TABLE varer ADD indhold numeric(15,3)", __FILE__ . " linje " . __LINE__); } db_modify("UPDATE grupper set box1 = '{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); transaktion('commit'); } include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.4.3'; if ($lap_nr < "3") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { $q = db_select("select * from regnskab", __FILE__ . " linje " . __LINE__); while ($i < db_num_fields($q)) { $feltnavne[$i] = db_field_name($q, $i); $i++; } if (!in_array('gruppe', $feltnavne)) { db_modify("ALTER TABLE regnskab ADD bilag numeric(1,0)", __FILE__ . " linje " . __LINE__); db_modify("UPDATE regnskab set bilag='0'", __FILE__ . " linje " . __LINE__); } echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version='{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; if ($db != $sqdb) { db_modify("UPDATE grupper set beskrivelse='Bilag og dokumenter',art='bilag' where art = 'FTP'", __FILE__ . " linje " . __LINE__); $r = db_fetch_array(db_select("select box6 from grupper where art='bilag'", __FILE__ . " linje " . __LINE__)); if ($r['box6']) { $bilag = 1; } else { $bilag = 0; } db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); } else { $bilag = 0; } include "../includes/connect.php"; db_modify("UPDATE regnskab set version='{$nextver}',bilag='{$bilag}' where db='{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.4.4'; if ($lap_nr < "4") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { db_modify("UPDATE regnskab set version='{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; if ($db != $sqdb) { $q = db_select("select * from ordrelinjer", __FILE__ . " linje " . __LINE__); while ($i < db_num_fields($q)) { $feltnavne[$i] = db_field_name($q, $i); $i++; } if (!in_array('omvbet', $feltnavne)) { db_modify("ALTER TABLE ordrer ADD omvbet varchar(2)", __FILE__ . " linje " . __LINE__); db_modify("UPDATE ordrer set omvbet=''", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE ordrelinjer ADD omvbet varchar(2)", __FILE__ . " linje " . __LINE__); db_modify("UPDATE ordrelinjer set omvbet=''", __FILE__ . " linje " . __LINE__); db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); } } include "../includes/connect.php"; db_modify("UPDATE regnskab set version='{$nextver}' where db='{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.4.5'; if ($lap_nr < "5") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { db_modify("UPDATE regnskab set version='{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; if ($db != $sqdb) { $r = db_fetch_array(db_select("select email from adresser where art = 'S'", __FILE__ . " linje " . __LINE__)); $email = $r['email']; include "../includes/ordrefunc.php"; include "../includes/std_func.php"; $q = db_select("select ordrelinjer.id ,ordrelinjer.vare_id, ordrelinjer.kostpris, ordrer.valutakurs from ordrelinjer,ordrer where ordrelinjer.ordre_id=ordrer.id and ordrer.status>='3' and ordrer.art = 'DO' and ordrer.fakturadate >= '2014-01-01' and ordrelinjer.vare_id != '0'", __FILE__ . " linje " . __LINE__); while ($r = db_fetch_array($q)) { list($koordpr, $koordnr, $koordant, $koordid, $koordart) = explode(chr(9), find_kostpris($r['vare_id'], $r['id'])); $kobs_ordre_pris = explode(",", $koordpr); $ko_ant = count($kobs_ordre_pris); $kostpris = 0; for ($y = 0; $y < $ko_ant; $y++) { if ($r['valutakurs'] && $r['valutakurs'] != 100) { $kobs_ordre_pris[$y] *= 100 / $r['valutakurs']; } $kostpris += $kobs_ordre_pris[$y]; } $kostpris /= $ko_ant; $kostpris = afrund($kostpris, 3); if ($kostpris != $r['kostpris']) { db_modify("update ordrelinjer set kostpris='{$kostpris}' where id = '{$r['id']}'", __FILE__ . " linje " . __LINE__); } } db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); } include "../includes/connect.php"; db_modify("UPDATE regnskab set version='{$nextver}',email='{$email}' where db='{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.4.6'; if ($lap_nr < "6") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { db_modify("UPDATE regnskab set version='{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; if ($db != $sqdb) { transaktion('begin'); if ($db_type == "mysql") { db_modify("CREATE TABLE IF NOT EXISTS pos_betalinger (id serial NOT NULL,ordre_id integer,betalingstype text,amount numeric(15,3),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); } else { if (!db_fetch_array(db_select("select * from pg_tables where tablename='pos_betalinger'", __FILE__ . " linje " . __LINE__))) { db_modify("CREATE TABLE pos_betalinger (id serial NOT NULL,ordre_id integer,betalingstype text,amount numeric(15,3),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); } } $q = db_select("select id,felt_1,felt_2,felt_3,felt_4 from ordrer where art='PO' and status>='3'", __FILE__ . " linje " . __LINE__); while ($r = db_fetch_array($q)) { if (is_numeric($r['felt_2']) && $r['felt_2']) { db_modify("insert into pos_betalinger(ordre_id,betalingstype,amount) values ('{$r['id']}','{$r['felt_1']}','{$r['felt_2']}')", __FILE__ . " linje " . __LINE__); } if (is_numeric($r['felt_4']) && $r['felt_4']) { db_modify("insert into pos_betalinger(ordre_id,betalingstype,amount) values ('{$r['id']}','{$r['felt_3']}','{$r['felt_4']}')", __FILE__ . " linje " . __LINE__); } } db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); transaktion('commit'); } include "../includes/connect.php"; db_modify("UPDATE regnskab set version='{$nextver}' where db='{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.4.7'; if ($lap_nr < "7") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { db_modify("UPDATE regnskab set version='{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; if ($db != $sqdb) { db_modify("CREATE INDEX batch_kob_kobsdate_idx ON batch_kob (kobsdate)", __FILE__ . " linje " . __LINE__); db_modify("CREATE INDEX batch_kob_antal_idx ON batch_kob (antal)", __FILE__ . " linje " . __LINE__); db_modify("CREATE INDEX batch_kob_vare_id_idx ON batch_kob (vare_id)", __FILE__ . " linje " . __LINE__); db_modify("CREATE INDEX batch_salg_salgsdate_idx ON batch_salg (salgsdate)", __FILE__ . " linje " . __LINE__); db_modify("CREATE INDEX batch_salg_antal_idx ON batch_salg (antal)", __FILE__ . " linje " . __LINE__); db_modify("CREATE INDEX batch_salg_vare_id_idx ON batch_salg (vare_id)", __FILE__ . " linje " . __LINE__); db_modify("CREATE INDEX transaktioner_transdate_idx ON transaktioner (transdate)", __FILE__ . " linje " . __LINE__); db_modify("CREATE INDEX transaktioner_kontonr_idx ON transaktioner (kontonr)", __FILE__ . " linje " . __LINE__); transaktion('begin'); if ($db_type == "mysql") { db_modify("CREATE TABLE IF NOT EXISTS mappe (id serial NOT NULL,beskrivelse text,sort numeric(15,0),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE IF NOT EXISTS mappebilag (id serial NOT NULL,navn text,beskrivelse text,datotid text,hvem text,assign_to text,assign_id int4,filtype text,sort numeric(15,0),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); } else { if (!db_fetch_array(db_select("select * from pg_tables where tablename='mappe'", __FILE__ . " linje " . __LINE__))) { db_modify("CREATE TABLE mappe (id serial NOT NULL,beskrivelse text,sort numeric(15,0),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); } if (!db_fetch_array(db_select("select * from pg_tables where tablename='mappebilag'", __FILE__ . " linje " . __LINE__))) { db_modify("CREATE TABLE mappebilag (id serial NOT NULL,navn text,beskrivelse text,datotid text,hvem text,assign_to text,assign_id int4,filtype text,sort numeric(15,0),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); } } db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); transaktion('commit'); } include "../includes/connect.php"; db_modify("UPDATE regnskab set version='{$nextver}' where db='{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.4.8'; if ($lap_nr < "8") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { db_modify("UPDATE regnskab set version='{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; if ($db != $sqdb) { transaktion('begin'); db_modify("ALTER TABLE batch_salg ADD lager integer", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE lagerstatus ADD lok1 text", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE lagerstatus ADD lok2 text", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE lagerstatus ADD lok3 text", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE lagerstatus ADD lok4 text", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE lagerstatus ADD lok5 text", __FILE__ . " linje " . __LINE__); db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); transaktion('commit'); } include "../includes/connect.php"; db_modify("UPDATE regnskab set version='{$nextver}' where db='{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.4.9'; if ($lap_nr < "9") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { db_modify("UPDATE regnskab set version='{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; if ($db != $sqdb) { transaktion('begin'); db_modify("ALTER TABLE ordrelinjer ADD saet integer", __FILE__ . " linje " . __LINE__); db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); transaktion('commit'); } include "../includes/connect.php"; db_modify("UPDATE regnskab set version='{$nextver}' where db='{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.5.0'; include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { db_modify("UPDATE regnskab set version='{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; if ($db != $sqdb) { transaktion('begin'); if ($db_type == "mysql") { db_modify("CREATE TABLE IF NOT EXISTS ansatmappe (id serial NOT NULL,beskrivelse text,ans_id int4,sort numeric(15,0),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE IF NOT EXISTS ansatmappebilag (id serial NOT NULL,navn text,beskrivelse text,datotid text,hvem text,assign_to text,assign_id int4,filtype text,sort numeric(15,0),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE IF NOT EXISTS kostpriser (id serial NOT NULL,vare_id integer,transdate date,kostpris numeric(15,3),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); } else { if (!db_fetch_array(db_select("select * from pg_tables where tablename='ansatmappe'", __FILE__ . " linje " . __LINE__))) { db_modify("CREATE TABLE ansatmappe (id serial NOT NULL,beskrivelse text,ans_id int4,sort numeric(15,0),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); } if (!db_fetch_array(db_select("select * from pg_tables where tablename='ansatmappebilag'", __FILE__ . " linje " . __LINE__))) { db_modify("CREATE TABLE ansatmappebilag (id serial NOT NULL,navn text,beskrivelse text,datotid text,hvem text,assign_to text,assign_id int4,filtype text,sort numeric(15,0),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); } if (!db_fetch_array(db_select("select * from pg_tables where tablename='kostpriser'", __FILE__ . " linje " . __LINE__))) { db_modify("CREATE TABLE kostpriser (id serial NOT NULL,vare_id integer,transdate date,kostpris numeric(15,3),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); } } db_modify("update batch_kob set kobsdate = fakturadate where kobsdate is NULL and fakturadate > '2014-01-01'", __FILE__ . " linje " . __LINE__); $q = db_select("select linje_id from batch_salg,ordrelinjer where ordrelinjer.antal < 0 and batch_salg.antal > 0 and batch_salg.linje_id = ordrelinjer.id", __FILE__ . " linje " . __LINE__); while ($r = db_fetch_array($q)) { db_modify("update batch_salg set antal=antal*-1 where linje_id='{$r['linje_id']}'", __FILE__ . " linje " . __LINE__); } $lgrp = array(); $x = 0; $q = db_select("select kodenr from grupper where art='VG' and box8='on'", __FILE__ . " linje " . __LINE__); while ($r = db_fetch_array($q)) { $lgrp[$x] = $r['kodenr'] * 1; $x++; } $x = 0; $kostpris = array(); db_modify("delete from kostpriser", __FILE__ . " linje " . __LINE__); $q = db_select("select id,kostpris,gruppe from varer where lukket != 'on' order by id", __FILE__ . " linje " . __LINE__); while ($r = db_fetch_array($q)) { if (in_array($r['gruppe'], $lgrp)) { $kostpris = $r['kostpris'] * 1; db_modify("insert into kostpriser(vare_id,kostpris,transdate)values('{$r['id']}','{$kostpris}','2015-01-01')", __FILE__ . " linje " . __LINE__); } } db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); transaktion('commit'); } include "../includes/connect.php"; db_modify("UPDATE regnskab set version='{$nextver}' where db='{$db}'", __FILE__ . " linje " . __LINE__); }
$content .= "<input type=text name=option value='" . date("Y") . "' size=4>"; break; } // End switch $content .= "<br />"; $content .= "<input type=submit value='" . lang("Show list", "listing") . "'>"; $content .= "</form>"; } elseif ($action == "viewlist" && isset($list)) { $SQL = $listingtype[$list]['SQL']; if ($listingtype[$list]['displaymode'] == 'CSV') { $hide_smarty = 1; $format = "CSV"; } $content .= "<table>"; $qListing = db_query($SQL); $column_count = db_num_fields($qListing); $content .= "<tr>"; for ($column_num = 0; $column_num < $column_count; $column_num++) { $field_name = db_field_name($qListing, $column_num); $content .= "<th>" . lang($field_name, "listing") . "</th>"; } $content .= "</tr>"; while ($rListing = db_fetch_assoc($qListing)) { $content .= "<tr>"; foreach ($rListing as $name => $value) { $content .= "<td>" . $value . "</td>"; } // End for $content .= "</tr>"; # print_r($rListing); }
} $mailtext .= "I dag den {$dd} kl. {$tp} er der blevet rekvireret en midlertidig adgangskode til"; if ($brugernavn) { $mailtext .= " brugeren {$brugernavn} i"; } $mailtext .= " regnskabet {$regnskab} <br><br>"; $tidspunkt += 3600; $dd = date("d-m-Y", $tidspunkt); $tp = date("H:i", $tidspunkt); $mailtext .= "Indtil den {$dd} kl. {$tp} kan anvendes adgangskoden: {$tmp_kode}<br><br>"; $mailtext .= "Efter login kan adgangskoden ændres under \"Indstillinger -> Brugere\"<br><br>"; $tmp_kode = $tidspunkt . "|" . $tmp_kode; $i = 0; $feltnavne = array(); $q = db_select("select * from brugere", __FILE__ . " linje " . __LINE__); while ($i < db_num_fields($q)) { $feltnavne[$i] = db_field_name($q, $i); $i++; } if (!in_array('tmp_kode', $feltnavne)) { db_modify("ALTER TABLE brugere ADD tmp_kode text", __FILE__ . " linje " . __LINE__); } db_modify("update brugere set tmp_kode='{$tmp_kode}' where id='{$bruger_id}'"); } elseif (!$ansat_id && !$regnskaber && $db) { $subjekt = "Brugerliste til regnskabet {$regnskab}"; $mailtext .= "I dag den {$dd} kl. {$tp} er der blevet rekvireret en brugerliste til regnskabet {$regnskab} <br><br>Brugerne er: {$brugere}.\t<br><br>"; } elseif ($regnskaber) { $subjekt = "Saldi regnskab"; $mailtext .= "I dag den {$dd} kl. {$tp} er der blevet rekvireret en liste over regnskaber tilknyttet {$firmamail}<br><br>{$firmamail} et tilknyttet : {$regnskaber}.\t<br><br>"; } $mailtext .= "God fornøjelse fra dit Saldi team<br>";
function sqlquery_io($sqlstreng) { global $bgcolor; global $bgcolor5; $titletxt = "Skriv en SQL forespørgsel uden 'select'. F.eks: * from varer eller: varenr,salgspris from varer where lukket != 'on'"; print "<form name=exportselect action=diverse.php?sektion=sqlquery_io method=post>"; print "<tr><td colspan='6'><hr></td></tr>"; print "<tr bgcolor='{$bgcolor5}'><td colspan='6'><b><u>Dataudtræk</u></b></td></tr>"; print "<tr><td colspan='6'><br></td></tr>"; print "<input type=hidden name=id value='{$id}'>"; print "<tr><td valign='top' title='{$titletxt}'>SELECT</td><td colspan='2'><textarea name='sqlstreng' rows='5' cols='80'>{$sqlstreng}</textarea></td>"; print "<td align = center><input style='width: 8em' type=submit accesskey='g' value='Send' name='submit'></td>"; print "</form>"; $x = 0; if ($sqlstreng = trim($sqlstreng)) { global $db; global $bruger_id; $linje = NULL; $filnavn = "../temp/{$db}/{$bruger_id}.csv"; $fp = fopen($filnavn, "w"); $sqlstreng = strtolower($sqlstreng); list($del1, $del2) = explode("where", $sqlstreng, 2); $fy_ord = array('brugere', 'grupper'); for ($x = 0; $x < count($fy_ord); $x++) { if (strpos($del1, $fy_ord[$x])) { print "<BODY onLoad=\"JavaScript:alert('Illegal værdi i søgestreng')\">"; exit; } } #cho "del 1 $del1<br>"; #cho "del2 $del2<br>"; for ($x = 0; $x < strlen($del2); $x++) { $t = substr($del2, $x, 1); if (!$tilde) { if ($t == "'") { $tilde = 1; $var = ''; } else { $streng .= $t; } } else { if ($t == "'") { $tilde = 0; $streng .= "'" . db_escape_string($var) . "'"; } } } #cho "$sqlstreng<br>"; $query = "select " . db_escape_string($del1); #cho "$query<br>"; $query = "select " . $sqlstreng; #cho "$query<br>"; $r = 0; $q = db_select("{$query}", __FILE__ . " linje " . __LINE__); while ($r < db_num_fields($q)) { $fieldName[$r] = db_field_name($q, $r); $fieldType[$r] = db_field_type($q, $r); $linje ? $linje .= '";"' . $fieldName[$r] . "(" . $fieldType[$r] . ")" : ($linje = '"' . $fieldName[$r] . "(" . $fieldType[$r] . ")"); $r++; } $linje ? $linje .= '"' : ($linje = NULL); if ($fp) { fwrite($fp, "{$linje}\n"); } $q = db_select("{$query}"); while ($r = db_fetch_array($q)) { $linje = NULL; $arraysize = count($r); for ($x = 0; $x < $arraysize; $x++) { if ($fieldType[$x] == 'numeric') { $r[$x] = dkdecimal($r[$x]); } else { $r[$x] = utf8_decode($r[$x]); } $linje ? $linje .= '";"' . $r[$x] : ($linje = '"' . $r[$x]); } $linje ? $linje .= '"' : ($linje = NULL); if ($fp) { fwrite($fp, "{$linje}\n"); } } fclose($fp); print "<tr><td></td><td align='left' colspan='3'> Højreklik her: <a href='{$filnavn}'>Datafil</a> og vælg 'gem destination som'</td></tr>"; } }
/** * Returns an array of column names and fieldtype for a table. * */ function getTableColumns($table) { $sql = "SELECT * FROM {$table} LIMIT 1"; $columnArray = array(); $v = array(); $t = array(); $res = db_prep_query($sql, $v, $t); $i = 0; while ($i < db_num_fields($res)) { if (db_field_type($res, $i) == "varchar") { $fieldType = "s"; } else { $fieldType = "i"; } $columnArray[db_fieldname($res, $i)] = $fieldType; $i++; } return $columnArray; }
function InitPOReq($req,$Base="",$DirEcho=true,$TypEdit="",$limit=1,$co_user="",$othparams = array("hashwnmtb"=>false)) { global $debug, $DBName,$sepNmTableNmChp; if(!defined("sepNmTableNmChp")) { define("sepNmTableNmChp","#"); // sécurité } if ($Base=="") $Base=$DBName; if($limit!="no") $req = addwherefORlimit($req,$limit); // ajoute proprement la clause limit, meme avec Oracle (belle merde) $resreq = db_query($req); if ($limit==1) { $tbValChp = db_fetch_array($resreq); // tableau des valeurs de l'enregistrement // if (db_num_rows($resreq)== 0 && !($_SESSION['db_type'] == "oracle")) return (false); // le oci_num_rows ne fonctionne pas avec Oracle !! } $CIL['db_num_rows'] = db_num_rows($resreq); $CIL['db_resreq'] = $resreq; // print_r($tbValChp); for ($i=0;$i<db_num_fields($resreq);$i++) { $NmChamp=db_field_name($resreq,$i); //echo "Chp traité : $NmChamp "; // la fonction db_field_table est tres aproximative avec Oracle et Pgsql // on peut préciser le nom de la table en faisant select toto as latable#toto dans la req cust if (strstr($NmChamp,sepNmTableNmChp)) { $tb = explode(sepNmTableNmChp,$NmChamp); $NmChp4hash = $NmChamp; $NTBL = $tb[0]; $NmChamp = $tb[1]; } else { $NTBL = db_field_table($resreq,$i); $NmChp4hash = $othparams['hashwnmtb'] ? $NTBL.sepNmTableNmChp.$NmChamp : $NmChamp; } $CIL[$NmChp4hash]=new PYAobj(); // nouvel objet $CIL[$NmChp4hash]->NmBase=$Base; $CIL[$NmChp4hash]->NmTable=$NTBL; $CIL[$NmChp4hash]->NmChamp=$NmChamp; $CIL[$NmChp4hash]->TypEdit=$TypEdit; $CIL[$NmChp4hash]->DirEcho=$DirEcho; // requetes custom : initialise pas le PO si mot clé ou nom de champ est un entier //echo $CIL[$NmChp4hash]->NmChamp.":".preg_match("/^[0-9]+$/",$CIL[$NmChp4hash]->NmChamp)."<br/>"; /// TODO TODO faut améliorer ce test if (!(preg_match("/sum\(|count\(|min\(|max\(|avg\(/i",$NmChamp) || preg_match("/^[0-9]+$/",$NmChamp))) { $err = $CIL[$NmChp4hash]->InitPO(); if ($err) $CIL[$NmChp4hash]->Libelle = '<i>'.$NmChp4hash.'</i>'; // si champ pas trouvé (table non définie) on garde son libellé } else { $CIL[$NmChp4hash]->Libelle = $NmChp4hash; } if ($TypEdit!="N" && $TypEdit!="" && $limit==1) { $CIL[$NmChp4hash]->ValChp=$tbValChp[$NmChamp]; //echo $NmChamp."->".$tbValChp[$NmChamp]; } if ($co_user!="" && $TypEdit!="C") $CIL[$NmChp4hash]->InitAvMaj($co_user); $strdbgIPOR.=$NmChp4hash.", "; } // fin boucle sur les champs du r�ultat if ($debug) echo("Champs traites par la fct InitPOReq :".$strdbgIPOR."<br/>\n"); return($CIL); }
if ($sql == "") { $error = SQL_ERROR1; display_error($error); exit; } page("Report Generator REPGEN", true); display_heading(SQL_STATEMENT); $sql = stripslashes($sql); $sqle = urldecode($sql); // print the SQL-Command display_notification($sqle); $sql = str_replace("0_", TB_PREF, $sql); $res = db_query($sql, SQL_ERROR); // test, if SQL-statement is correct $th = array(); $num = db_num_fields($res); $i = 0; while ($i < $num) { $meta = mysql_fetch_field($res, $i); $th[] = $meta->name; $i++; } /* * * show 10 records of this resultset * * */ display_heading(SQL_ERG); start_table(TABLESTYLE); table_header($th);
function opdat_3_2($under_nr, $lap_nr) { global $version; global $db; global $db_id; global $regnskab; global $regnaar; global $db_type; $s_id = session_id(); $nextver = '3.2.1'; if ($lap_nr < "1") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; transaktion('begin'); $q = db_select("select m_rabat from ordrelinjer", __FILE__ . " linje " . __LINE__); $fieldType = db_field_type($q, 0); if ($fieldType != 'numeric') { if ($db_type == "mysql") { db_modify("ALTER TABLE ordrelinjer CHANGE m_rabat m_rabat numeric(15,3)", __FILE__ . " linje " . __LINE__); } else { db_modify("ALTER TABLE ordrelinjer ALTER column m_rabat TYPE numeric(15,3)", __FILE__ . " linje " . __LINE__); } } if ($db_type == "mysql") { db_modify("ALTER TABLE ordrelinjer CHANGE rabatart rabatart varchar(10)", __FILE__ . " linje " . __LINE__); } else { db_modify("ALTER TABLE ordrelinjer ALTER column rabatart TYPE varchar(10)", __FILE__ . " linje " . __LINE__); } echo "opdaterer til ver {$nextver}<br />"; db_modify("UPDATE grupper set box1 = '{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); transaktion('commit'); include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.2.2'; if ($lap_nr < "2") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; transaktion('begin'); if ($db_type == "mysql") { db_modify("CREATE TABLE IF NOT EXISTS ordretekster (id serial NOT NULL,tekst text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE IF NOT EXISTS navigator (bruger_id integer,session_id text,side text,returside text,konto_id integer,ordre_id integer,vare_id integer)", __FILE__ . " linje " . __LINE__); } else { if (!db_fetch_array(db_select("select * from pg_tables where tablename='ordretekster'"))) { db_modify("CREATE TABLE ordretekster (id serial NOT NULL,tekst text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); } if (!db_fetch_array(db_select("select * from pg_tables where tablename='navigator'"))) { db_modify("CREATE TABLE navigator (bruger_id integer,session_id text,side text,returside text,konto_id integer,ordre_id integer,vare_id integer)", __FILE__ . " linje " . __LINE__); } } $i = 0; $feltnavne = array(); $q = db_select("select * from jobkort", __FILE__ . " linje " . __LINE__); while ($i < db_num_fields($q)) { $feltnavne[$i] = db_field_name($q, $i); $i++; } if (!in_array('ordre_id', $feltnavne)) { db_modify("ALTER TABLE jobkort ADD ordre_id integer", __FILE__ . " linje " . __LINE__); } $i = 0; $feltnavne = array(); $q = db_select("select * from adresser", __FILE__ . " linje " . __LINE__); while ($i < db_num_fields($q)) { $feltnavne[$i] = db_field_name($q, $i); $i++; } if (!in_array('status', $feltnavne)) { db_modify("ALTER TABLE adresser ADD status text", __FILE__ . " linje " . __LINE__); } $id1 = 0; $cat_id = NULL; $cat_beskrivelse = NULL; $q = db_select("select id,box1 from grupper where art='DGCAT' order by id", __FILE__ . " linje " . __LINE__); while ($r = db_fetch_array($q)) { if (!$id0) { $id0 = $r['id']; } $cat_id ? $cat_id .= chr(9) . $r['id'] : ($cat_id = $r['id']); $cat_beskrivelse ? $cat_beskrivelse .= chr(9) . db_escape_string($r['box1']) : ($cat_beskrivelse = db_escape_string($r['box1'])); } if ($id0) { db_modify("update grupper set beskrivelse='Div DebitorInfo',art='DebInfo',box1='{$cat_id}',box2='{$cat_beskrivelse}' where id = '{$id0}'", __FILE__ . " linje " . __LINE__); } if ($db_type == "mysql") { db_modify("CREATE TABLE IF NOT EXISTS ordretekster (id serial NOT NULL,tekst text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE IF NOT EXISTS navigator (bruger_id integer,session_id text,side text,returside text,konto_id integer,ordre_id integer,vare_id integer)", __FILE__ . " linje " . __LINE__); } else { if (!db_fetch_array(db_select("select * from pg_tables where tablename='ordretekster'"))) { db_modify("CREATE TABLE ordretekster (id serial NOT NULL,tekst text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); } if (!db_fetch_array(db_select("select * from pg_tables where tablename='navigator'"))) { db_modify("CREATE TABLE navigator (bruger_id integer,session_id text,side text,returside text,konto_id integer,ordre_id integer,vare_id integer)", __FILE__ . " linje " . __LINE__); } } echo "opdaterer til ver {$nextver}<br />"; db_modify("UPDATE grupper set box1 = '{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); transaktion('commit'); include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.2.3'; if ($lap_nr < "3") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; transaktion('begin'); if ($db_type == "mysql") { db_modify("CREATE TABLE IF NOT EXISTS shop_adresser (id serial NOT NULL,saldi_id integer,shop_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE IF NOT EXISTS shop_varer (id serial NOT NULL,saldi_id integer,shop_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE IF NOT EXISTS shop_ordrer (id serial NOT NULL,saldi_id integer,shop_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE IF NOT EXISTS varianter (id serial NOT NULL,beskrivelse text,shop_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE IF NOT EXISTS variant_typer (id serial NOT NULL,variant_id integer,shop_id integer,beskrivelse text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE IF NOT EXISTS variant_varer (id serial NOT NULL,vare_id integer,variant_type text,variant_beholdning numeric(15,3),variant_stregkode text,lager integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); } else { if (!db_fetch_array(db_select("select * from pg_tables where tablename='shop_adresser'"))) { db_modify("CREATE TABLE shop_adresser (id serial NOT NULL,saldi_id integer,shop_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); } if (!db_fetch_array(db_select("select * from pg_tables where tablename='shop_varer'"))) { db_modify("CREATE TABLE shop_varer (id serial NOT NULL,saldi_id integer,shop_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); } if (!db_fetch_array(db_select("select * from pg_tables where tablename='shop_ordrer'"))) { db_modify("CREATE TABLE shop_ordrer (id serial NOT NULL,saldi_id integer,shop_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); } if (!db_fetch_array(db_select("select * from pg_tables where tablename='varianter'"))) { db_modify("CREATE TABLE varianter (id serial NOT NULL,beskrivelse text,shop_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); } if (!db_fetch_array(db_select("select * from pg_tables where tablename='variant_typer'"))) { db_modify("CREATE TABLE variant_typer (id serial NOT NULL,variant_id integer,shop_id integer,beskrivelse text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); } if (!db_fetch_array(db_select("select * from pg_tables where tablename='variant_varer'"))) { db_modify("CREATE TABLE variant_varer (id serial NOT NULL,vare_id integer,variant_type text,variant_beholdning numeric(15,3),variant_stregkode text,lager integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); } } db_modify("delete from grupper where art = 'DGCAT'", __FILE__ . " linje " . __LINE__); $i = 0; $feltnavne = array(); $q = db_select("select * from varer", __FILE__ . " linje " . __LINE__); while ($i < db_num_fields($q)) { $feltnavne[$i] = db_field_name($q, $i); $i++; } if (!in_array('kategori', $feltnavne)) { db_modify("ALTER TABLE varer ADD kategori text", __FILE__ . " linje " . __LINE__); db_modify("UPDATE varer set kategori = ''", __FILE__ . " linje " . __LINE__); } if (!in_array('varianter', $feltnavne)) { db_modify("ALTER TABLE varer ADD varianter text", __FILE__ . " linje " . __LINE__); db_modify("UPDATE varer set varianter = ''", __FILE__ . " linje " . __LINE__); } if (!in_array('publiceret', $feltnavne)) { db_modify("ALTER TABLE varer ADD publiceret varchar(2)", __FILE__ . " linje " . __LINE__); db_modify("UPDATE varer set publiceret = '0'", __FILE__ . " linje " . __LINE__); } $i = 0; $feltnavne = array(); $q = db_select("select * from ordrelinjer", __FILE__ . " linje " . __LINE__); while ($i < db_num_fields($q)) { $feltnavne[$i] = db_field_name($q, $i); $i++; } if (!in_array('variant_id', $feltnavne)) { db_modify("ALTER TABLE ordrelinjer ADD variant_id text", __FILE__ . " linje " . __LINE__); db_modify("UPDATE ordrelinjer set variant_id = ''", __FILE__ . " linje " . __LINE__); } echo "opdaterer til ver {$nextver}<br />"; db_modify("UPDATE grupper set box1 = '{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); transaktion('commit'); include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.2.4'; if ($lap_nr < "4") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; transaktion('begin'); $i = 0; $feltnavne = array(); $q = db_select("select * from ordrelinjer", __FILE__ . " linje " . __LINE__); while ($i < db_num_fields($q)) { $feltnavne[$i] = db_field_name($q, $i); $i++; } if (!in_array('variant_id', $feltnavne)) { db_modify("ALTER TABLE ordrelinjer ADD variant_id text", __FILE__ . " linje " . __LINE__); db_modify("UPDATE ordrelinjer set variant_id = ''", __FILE__ . " linje " . __LINE__); } if (in_array('varianter', $feltnavne)) { db_modify("ALTER TABLE ordrelinjer drop column varianter", __FILE__ . " linje " . __LINE__); } # echo "opdaterer til ver $nextver<br />"; db_modify("UPDATE grupper set box1 = '{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); transaktion('commit'); include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.2.5'; if ($lap_nr < "5") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; db_modify("UPDATE grupper set box1 = '{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.2.6'; if ($lap_nr < "6") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; db_modify("UPDATE grupper set box1 = '{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.2.7'; if ($lap_nr < "7") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; print "<body onload=\"javascript:window.open('../utils/momskontrol.php?email=1', '', '');\">"; db_modify("UPDATE grupper set box1 = '{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.2.8'; if ($lap_nr < "8") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; $feltnavne = array(); $q = db_select("select * from transaktioner", __FILE__ . " linje " . __LINE__); while ($i < db_num_fields($q)) { $feltnavne[$i] = db_field_name($q, $i); $i++; } if (!in_array('moms', $feltnavne)) { db_modify("ALTER TABLE transaktioner ADD moms numeric(15,3)", __FILE__ . " linje " . __LINE__); } db_modify("UPDATE grupper set box1 = '{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.2.9'; if ($lap_nr < "9") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("ALTER TABLE online ADD column sag_rettigheder text", __FILE__ . " linje " . __LINE__); db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; db_modify("CREATE TABLE sager (id serial NOT NULL,konto_id integer,firmanavn text,addr1 text,addr2 text,postnr text,bynavn text,land text,kontakt text,email text,beskrivelse text,omfang text,ref text,udf_firmanavn text,udf_addr1 text,udf_addr2 text,udf_postnr text,udf_bynavn text,udf_kontakt text,status text,tidspkt text,hvem text,oprettet_af text,kunde_ref text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE bilag (id serial NOT NULL,navn text,beskrivelse text,datotid text,hvem text,assign_to text,assign_id int,fase numeric(15,3),kategori text,filtype text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE noter (id serial NOT NULL,notat text,beskrivelse text,datotid text,hvem text,besked_til text,assign_to text,assign_id integer,status integer,fase numeric(15,3), PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE tjekliste (id serial NOT NULL,tjekpunkt text,fase numeric(15,3),assign_to text,assign_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE tjekpunkter (id serial NOT NULL,tjekliste_id integer,assign_id integer,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE sagstekster (id serial NOT NULL,tekstnr numeric(15,0),beskrivelse text,tekst text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE loen (id serial NOT NULL,nummer numeric(15,0),kategori integer,loendate date,sag_id integer, sag_nr numeric(15,0),tekst text,ansatte text,fordeling text,timer text,t50pct text,t100pct text,hvem text,oprettet text,afsluttet text,godkendt text,sum numeric(15,3),oprettet_af text,afsluttet_af text,godkendt_af text,master_id integer,loen text,afvist text,afvist_af text,udbetalt text,art text,skur text,datoer text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE loen_enheder (id serial NOT NULL,loen_id integer,vare_id integer,op numeric(15,3),ned numeric(15,3),tekst text,pris_op numeric(15,3),pris_ned numeric(15,3),procent numeric(15,3),PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("alter table ansatte add column nummer numeric(15,0)", __FILE__ . " linje " . __LINE__); db_modify("alter table ansatte add column loen numeric", __FILE__ . " linje " . __LINE__); db_modify("alter table ansatte add column extraloen numeric(15,3)", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE ansatte ADD COLUMN bank text", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE ansatte ADD COLUMN startdate date", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE ansatte ADD COLUMN slutdate date", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE ansatte ADD COLUMN trainee text", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE ordrer ADD COLUMN betalings_id text", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE openpost ADD COLUMN betalings_id text", __FILE__ . " linje " . __LINE__); db_modify("UPDATE grupper set box1 = '{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.3.0'; include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id=1", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { db_modify("UPDATE regnskab set version = '{$nextver}' where id = 1", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; db_modify("CREATE TABLE opgaver (id serial NOT NULL,assign_id integer,assign_to text,nr numeric(15,0),beskrivelse text,omfang text,ref text,status text,tidspkt text,hvem text,oprettet_af text,kunde_ref text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE simulering (id serial NOT NULL,kontonr int4,bilag numeric(15,0),transdate date,beskrivelse text,debet numeric(15,3),kredit numeric(15,3),faktura text,kladde_id int4,projekt text,ansat numeric(15,0),logdate date,logtime time,afd int4,ordre_id int4,valuta text,valutakurs numeric(15,3),moms numeric(15,3),adresser_id int4,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("CREATE TABLE tjekskema (id serial NOT NULL,tjekliste_id integer,datotid text,opg_art text,sjak text,sag_id integer,hvem text,PRIMARY KEY (id))", __FILE__ . " linje " . __LINE__); db_modify("alter table loen add column afregnet text", __FILE__ . " linje " . __LINE__); db_modify("alter table loen add column afregnet_af text", __FILE__ . " linje " . __LINE__); db_modify("alter table loen add column korsel text", __FILE__ . " linje " . __LINE__); db_modify("alter table loen add column korsel text", __FILE__ . " linje " . __LINE__); db_modify("alter table loen add column opg_id integer", __FILE__ . " linje " . __LINE__); db_modify("alter table loen add column opg_nr integer", __FILE__ . " linje " . __LINE__); db_modify("alter table loen add column afvist_pga text", __FILE__ . " linje " . __LINE__); db_modify("alter table loen_enheder add column op_25 numeric(15,3)", __FILE__ . " linje " . __LINE__); db_modify("alter table loen_enheder add column ned_25 numeric(15,3)", __FILE__ . " linje " . __LINE__); db_modify("alter table loen_enheder add column op_40 numeric(15,3)", __FILE__ . " linje " . __LINE__); db_modify("alter table loen_enheder add column ned_40 numeric(15,3)", __FILE__ . " linje " . __LINE__); db_modify("alter table loen_enheder add column op_60 numeric(15,3)", __FILE__ . " linje " . __LINE__); db_modify("alter table loen_enheder add column ned_60 numeric(15,3)", __FILE__ . " linje " . __LINE__); db_modify("alter table loen_enheder add column op_30m numeric(15,3)", __FILE__ . " linje " . __LINE__); db_modify("alter table loen_enheder add column ned_30m numeric(15,3)", __FILE__ . " linje " . __LINE__); db_modify("alter table bilag add column bilag_fase text", __FILE__ . " linje " . __LINE__); db_modify("alter table noter add column notat_fase text", __FILE__ . " linje " . __LINE__); db_modify("alter table noter add column kategori text", __FILE__ . " linje " . __LINE__); db_modify("alter table noter add column nr numeric(15,0)", __FILE__ . " linje " . __LINE__); db_modify("alter table ordrer add column sag_id integer", __FILE__ . " linje " . __LINE__); db_modify("alter table ordrer add column tilbudnr numeric(15,0)", __FILE__ . " linje " . __LINE__); db_modify("alter table ordrer add column datotid text", __FILE__ . " linje " . __LINE__); db_modify("alter table ordrer add column nr numeric(15,0)", __FILE__ . " linje " . __LINE__); db_modify("alter table ordrer add column returside text", __FILE__ . " linje " . __LINE__); db_modify("alter table ordrer add column sagsnr numeric(15,0)", __FILE__ . " linje " . __LINE__); db_modify("alter table transaktioner add column adresser_id integer", __FILE__ . " linje " . __LINE__); db_modify("alter table tjekpunkter add column status integer", __FILE__ . " linje " . __LINE__); db_modify("alter table tjekpunkter add column status_tekst text", __FILE__ . " linje " . __LINE__); db_modify("alter table tjekpunkter add column tjekskema_id integer", __FILE__ . " linje " . __LINE__); db_modify("update transaktioner set moms=moms*-1 where kredit > 0 and moms > 0", __FILE__ . " linje " . __LINE__); db_modify("UPDATE grupper set box1 = '{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); }
<?php include "../../include.php"; $r = db_grab("SELECT \n\t\t\t\tq.query, \n\t\t\t\tq.name,\n\t\t\t\td.dbname\n\t\t\tFROM queries q\n\t\t\tJOIN queries_databases d ON q.databaseID = d.id\n\t\t\tWHERE q.id = " . $_GET["id"]); db_switch($r["dbname"]); if (!($result = db_query($r["query"], false, true))) { url_change("./query_edit.php?id=" . $_GET["id"], true); } $filename = $r["name"]; $num_columns = db_num_fields($result); $num_rows = 0; $fields = array(); //get header row for ($i = 0; $i < $num_columns; $i++) { $name = db_fetch_field($result, $i); array_push($fields, $name->name . "|||" . db_field_type($result, $i)); } $return = ' <table border="1"> <tr bgcolor="#fffceo">'; foreach ($fields as $field) { list($name, $datatype) = explode("|||", $field); $return .= ' <td><b>' . trim(str_replace("_", " ", $name)) . '</b></td> '; } $return .= '</tr>'; while ($r = db_fetch($result)) { $return .= '<tr>'; reset($fields); foreach ($fields as $field) {
function opdat_3_5($under_nr, $lap_nr) { global $version; global $db; global $db_id; global $regnskab; global $regnaar; global $db_type; $s_id = session_id(); $nextver = '3.5.1'; if ($lap_nr < "1") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; if ($db != $sqdb) { db_modify("CREATE INDEX pos_betalinger_ordre_id_idx ON pos_betalinger (ordre_id)", __FILE__ . " linje " . __LINE__); db_modify("CREATE INDEX pos_betalinger_betalingstype_idx ON pos_betalinger (betalingstype)", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE regulering add column lager integer", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE ordrelinjer add column fast_db numeric(15,2)", __FILE__ . " linje " . __LINE__); db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); } include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.5.2'; if ($lap_nr < "2") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; if ($db != $sqdb) { db_modify("ALTER TABLE ordrer add column afd integer", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE ordrelinjer add column afd integer", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE ordrelinjer add column lager integer", __FILE__ . " linje " . __LINE__); db_modify("DELETE FROM tekster where tekst_id = '677'", __FILE__ . " linje " . __LINE__); db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); } include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.5.3'; if ($lap_nr < "3") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; if ($db != $sqdb) { db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); } include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.5.4'; if ($lap_nr < "4") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; if ($db != $sqdb) { db_modify("CREATE INDEX openpost_id_idx ON openpost (id)", __FILE__ . " linje " . __LINE__); db_modify("CREATE INDEX openpost_konto_id_idx ON openpost (konto_id)", __FILE__ . " linje " . __LINE__); db_modify("CREATE INDEX openpost_udlign_id_idx ON openpost (udlign_id)", __FILE__ . " linje " . __LINE__); db_modify("CREATE INDEX ordrer_art_idx ON ordrer (art)", __FILE__ . " linje " . __LINE__); db_modify("CREATE INDEX ordrer_ordrenr_idx ON ordrer (ordrenr)", __FILE__ . " linje " . __LINE__); db_modify("CREATE INDEX ordrer_betalt_idx ON ordrer (betalt)", __FILE__ . " linje " . __LINE__); db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); } include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.5.5'; if ($lap_nr < "5") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; if ($db != $sqdb) { db_modify("delete from tekster where id = '731'", __FILE__ . " linje " . __LINE__); db_modify("delete from tekster where id = '732'", __FILE__ . " linje " . __LINE__); $r = db_fetch_array(db_select("select box6 from grupper where art = 'DIV' and kodenr = '3'", __FILE__ . " linje " . __LINE__)); $fifo = $r['box6']; if ($fifo) { if ($r = db_fetch_array(db_select("select id from grupper where art = 'DIV' and kodenr='5'", __FILE__ . " linje " . __LINE__))) { $id = $r['id']; db_modify("update grupper set box6='1' where id = '{$id}'", __FILE__ . " linje " . __LINE__); } else { db_modify("insert into grupper (beskrivelse,kodenr,art,box1,box2,box3,box4,box5,box6,box7,box8,box9,box10,box11,box12,box13) values ('Div_valg','5','DIV','','','','','','1','','','','','','','')", __FILE__ . " linje " . __LINE__); } } db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); } include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.5.6'; if ($lap_nr < "6") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; if ($db != $sqdb) { db_modify("ALTER TABLE ordrelinjer add column tilfravalg text", __FILE__ . " linje " . __LINE__); db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); } include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.5.7'; if ($lap_nr < "7") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; if ($db != $sqdb) { db_modify("ALTER TABLE sager add column planfraop text", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE sager add column plantilop text", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE sager add column planfraned text", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE sager add column plantilned text", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE opgaver add column opg_planfra text", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE opgaver add column opg_plantil text", __FILE__ . " linje " . __LINE__); $i = 0; $feltnavne = array(); $q = db_select("select * from ordrelinjer", __FILE__ . " linje " . __LINE__); while ($i < db_num_fields($q)) { $feltnavne[$i] = db_field_name($q, $i); $i++; } if (!in_array('tilfravalg', $feltnavne)) { db_modify("ALTER TABLE ordrelinjer ADD tilfravalg text", __FILE__ . " linje " . __LINE__); } db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); } include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } $nextver = '3.5.8'; if ($lap_nr < "8") { include "../includes/connect.php"; $r = db_fetch_array(db_select("select * from regnskab where id='1'", __FILE__ . " linje " . __LINE__)); $tmp = $r['version']; if ($tmp < $nextver) { echo "opdaterer hovedregnskab til ver {$nextver}<br />"; db_modify("UPDATE regnskab set version = '{$nextver}' where id = '1'", __FILE__ . " linje " . __LINE__); } include "../includes/online.php"; if ($db != $sqdb) { db_modify("ALTER TABLE varer add column special_from_time time", __FILE__ . " linje " . __LINE__); db_modify("ALTER TABLE varer add column special_to_time time", __FILE__ . " linje " . __LINE__); $i = 0; $feltnavne = array(); $q = db_select("select * from ordrelinjer", __FILE__ . " linje " . __LINE__); while ($i < db_num_fields($q)) { $feltnavne[$i] = db_field_name($q, $i); $i++; } if (!in_array('tilfravalg', $feltnavne)) { db_modify("ALTER TABLE ordrelinjer ADD tilfravalg text", __FILE__ . " linje " . __LINE__); } db_modify("UPDATE grupper set box1='{$nextver}' where art = 'VE'", __FILE__ . " linje " . __LINE__); } include "../includes/connect.php"; db_modify("UPDATE regnskab set version = '{$nextver}' where db = '{$db}'", __FILE__ . " linje " . __LINE__); } }
function lineHasFieldNames($arr, $table) { if (!is_array($arr)) { #echo '<!-- lineHasFieldNames: line '.__LINE__.' -->'; return false; } // get field names of table $res = sql('select * from `' . $table . '` limit 1', $eo); for ($i = 0; $i < db_num_fields($res); $i++) { $arrTableFieldName[] = db_field_name($res, $i); } $arrCommon = array_intersect($arrTableFieldName, noSpaces($arr)); //echo '<!-- lineHasFieldNames: arrTableFieldName: '.count($arrTableFieldName).' -->'; //echo '<!-- lineHasFieldNames: arr: '.count($arr).' -->'; //echo '<!-- lineHasFieldNames: arrCommon: '.count($arrCommon).' -->'; return count($arrCommon) < count($arr) ? false : true; }
function setBackup() { global $dbname, $dbh; global $PARAM, $SUBS, $MSG, $MONTHS; if (!is_dir(getAdmSetting('BACKUP_DIR'))) { MkDir(getAdmSetting('BACKUP_DIR'), 0777); } if ($PARAM['upload'] == 1) { global $bckFile, $bckFile_name; if ($bckFile_name == '') { $SUBS['ERROR'] = $MSG[20108]; $SUBS['BACKUP_ERROR'] = fileParse('_admin_error.htmlt'); } else { if (!($UPLOAD = @file($bckFile))) { setLogAndStatus("Reading", $bckFile, 0, "setBackup()", 'READ_UPLOAD'); } $file = date('d F Y H_i_s'); $filename = getAdmSetting('BACKUP_DIR') . "/{$file}.sql"; $upload = '## ' . $MSG[20109] . date(' d F Y H:i:s') . "\n"; $upload .= "## {$MSG['20110']} {$bckFile_name}\n"; $upload .= join('', $UPLOAD); if (!($fp = fopen($filename, 'w'))) { setLogAndStatus("Opening", $filename, 0, "setBackup()", 'OPEN_FILE'); } fwrite($fp, $upload); fclose($fp); $SUBS['COMMAND'] = $PARAM['cmd'] . "&err=20050"; printPage('_admin_done.htmlt'); return; } } //export database backup if ($PARAM['export'] == 1) { $file = date('d F Y H_i_s'); $filename = getAdmSetting('BACKUP_DIR') . "/{$file}.sql"; if (!($fp = fopen($filename, 'w'))) { setLogAndStatus("Opening", 0, $filename, "setBackup()", 'OPEN_FILE'); } //write comments if any if ($PARAM['bckComments'] != '') { $comments = '##' . ereg_replace("\n", "\n##", $PARAM['bckComments']) . "\n"; fwrite($fp, $comments); } if (!($res = db_list_tables($dbname, $dbh))) { setLogAndStatus("db_list_tables()", 0, $dbname, "setBackup()", 'LIST_TABLES'); } $num_tables = db_num_rows($res); $i = 0; while ($i < $num_tables) { $table = db_tablename($res, $i); $fields = db_list_fields($dbname, $table, $dbh); $columns = db_num_fields($fields); $tablelist = ''; for ($j = 0; $j < $columns; $j++) { if ($columns - $j == 1) { $tablelist .= db_field_name($fields, $j); } else { $tablelist .= db_field_name($fields, $j) . ','; } } $schema = "REPLACE INTO {$table} ({$tablelist}) VALUES ("; $query = "SELECT * FROM {$dbname}.{$table}"; $result = runQuery($query, 'setBackup()', 'SELECT_TABLES'); while ($row = db_fetch_row($result)) { $schema_insert = ''; for ($j = 0; $j < $columns; $j++) { if (!isset($row[$j])) { $schema_insert .= ' NULL,'; } else { $schema_insert .= ' ' . dbQuote($row[$j]) . ','; } } $schema_insert = $schema . ereg_replace(',$', '', $schema_insert); $schema_insert .= ");\r\n"; fwrite($fp, $schema_insert); } $i++; } fclose($fp); // the ZIP thing -------------------- $fp = fopen($filename, "rb"); $data = fread($fp, filesize($filename)); fclose($fp); $name = array(baseName($filename)); $data = array($data); $content = makezip($name, $data); $fp = fopen('./zip/' . basename($filename) . '.ZIP', "wb"); fputs($fp, $content); fclose($fp); // the ZIP thing -------------------- $SUBS['COMMAND'] = $PARAM['cmd'] . "&err=20052"; printPage('_admin_done.htmlt'); return; } //prepare for import or delete $backups = opendir(getAdmSetting('BACKUP_DIR')); while (($file = readdir($backups)) != false) { if (!is_dir($file)) { $BCKUPS[eregi_replace('[^a-z0-9]', '_', $file)] = getAdmSetting('BACKUP_DIR') . "/{$file}"; } } closedir($backups); reset($PARAM); while (list($k, $v) = each($PARAM)) { if (ereg('^bck_(.*)$', $k, $R)) { $BACKUPS[] = $R[1]; } } reset($PARAM); //delete backups if ($PARAM['delete'] == 1) { if (count($BACKUPS) == 0) { $SUBS['COMMAND'] = $PARAM['cmd'] . "&err=20008"; printPage('_admin_done.htmlt'); return; } for ($i = 0; $i < count($BACKUPS); $i++) { if (!@unlink($BCKUPS[$BACKUPS[$i]])) { setLogAndStatus("Deleting", $BCKUPS[$BACKUPS[$i]], "setBackup()", 'DEL_BACKUP'); } } $SUBS['COMMAND'] = $PARAM['cmd'] . "&err=20054"; printPage('_admin_done.htmlt'); return; } //import database backup if ($PARAM['import'] == 1) { if (count($BACKUPS) > 1) { $SUBS['COMMAND'] = $PARAM['cmd'] . "&err=20053"; printPage('_admin_done.htmlt'); return; } if (count($BACKUPS) == 0) { $SUBS['COMMAND'] = $PARAM['cmd'] . "&err=20008"; printPage('_admin_done.htmlt'); return; } //get backup file $file = fread(fopen($BCKUPS[$BACKUPS[0]], 'r'), filesize($BCKUPS[$BACKUPS[0]])); ////---- [Mrasnika's] Edition 21.03.2002 split_sql_file($BACKUP, $file); //reset tables if (!($res = db_list_tables($dbname, $dbh))) { setLogAndStatus("db_list_tables()", 1, $dbname, "databaseBackup()", 'LIST_TABLES_2'); } $num_tables = db_num_rows($res); $i = 0; while ($i < $num_tables) { $table = db_tablename($res, $i); $query = "DELETE FROM {$dbname}.{$table}"; $result = runQuery($query, 'setBackup()', 'RESET_TABLES'); $i++; } //fill tables while (list($k, $query) = each($BACKUP)) { if (!ereg('^#', $query)) { if (!($result = db_query($query, $dbh))) { setLogAndStatus($query, db_errno($dbh), db_error($dbh), "databaseBackup()", 'RESTORE_DB'); $SUBS['COMMAND'] = $PARAM['cmd'] . "&err=20055"; printPage('_admin_done.htmlt'); return; } } } $SUBS['COMMAND'] = $PARAM['cmd'] . "&err=20056"; printPage('_admin_done.htmlt'); return; } $backups = opendir(getAdmSetting('BACKUP_DIR')); $last = 0; while (($file = readdir($backups)) != false) { if (!is_dir($file)) { $date = stat(getAdmSetting('BACKUP_DIR') . "/{$file}"); if ($last < $date[9]) { $month = intval(date('m')); $SUBS['LAST'] = $MSG[20051] . date(' d ', $date[9]) . $MONTHS[$month] . date(' Y H.i.s', $date[9]); } $SUBS['SIZE'] = sprintf('%0.2f KB', $date[7] / 1024); $SUBS['NAME'] = eregi_replace('_', ':', $file); $SUBS['CHECK'] = eregi_replace('[^a-z0-9]', '_', $file); //checkbox name $SUBS['WHERE'] = getAdmSetting('BACKUP_DIR') . "/{$file}"; if (!($BACKUP = @file(getAdmSetting('BACKUP_DIR') . "/{$file}"))) { setLogAndStatus("Reading", 0, getAdmSetting('BACKUP_DIR') . "/{$file}", "setBackup()", 'READ_FILE'); } $comments = ''; //get comments from the beginning of the file for ($i = 0; $i < count($BACKUP); $i++) { if (eregi('^##(.*)$', $BACKUP[$i], $R)) { $comments .= $R[1]; } } if ($comments != '') { $SUBS['COMMENTS'] = ' ' . ereg_replace("\n", '<BR> ', htmlEncode($comments)); $SUBS['COMMENTS'] = ereg_replace('<BR> $', '', $SUBS['COMMENTS']); } else { $SUBS['COMMENTS'] = ''; } $SUBS['BACKUPS'] .= fileParse('_admin_backup_row.htmlt'); } } closedir($backups); if ($PARAM['err'] != '') { $SUBS['ERROR'] = $MSG[$PARAM['err']]; $SUBS['BACKUP_ERROR'] = fileParse('_admin_error.htmlt'); } printPage('_admin_backup.htmlt'); }
function copy_row($table, $id) { if (!$table || !$id) { return '0'; } $r = 0; $x = 0; $fieldstring = NULL; $q_string = "select * from {$table} where pris != '0' and m_rabat != '0' and rabat = '0' and id='{$id}'"; $q = db_select("{$q_string}", __FILE__ . " linje " . __LINE__); while ($r < db_num_fields($q)) { if (db_field_name($q, $r) != 'id') { $x++; $fieldName[$x] = db_field_name($q, $r); $fieldType[$x] = db_field_type($q, $r); $fieldstring ? $fieldstring .= "," . $fieldName[$x] : ($fieldstring = $fieldName[$x]); } $r++; } $feltantal = $x; $ordre_id = NULL; $posnr = NULL; $x = 0; $q = db_select("{$q_string}"); if ($r = db_fetch_array($q)) { $fieldvalues = NULL; $selectstring = NULL; for ($y = 1; $y <= $feltantal; $y++) { $linjerabat = afrund($r['pris'] / $r['m_rabat'], 2); $feltnavn = $fieldName[$y]; $felt[$y] = $r[$feltnavn]; if ($fieldType[$y] == 'varchar' || $fieldType[$y] == 'text') { $felt[$y] = addslashes($felt[$y]); } if (substr($fieldType[$y], 0, 3) == 'int' || $fieldType[$y] == 'numeric') { $felt[$y] *= 1; } if ($fieldName[$y] == 'posnr') { $felt[$y]++; $posnr = $felt[$y]; } if ($fieldName[$y] == 'ordre_id') { $ordre_id = $felt[$y]; } $fieldvalues ? $fieldvalues .= ",'" . $felt[$y] . "'" : ($fieldvalues = "'" . $felt[$y] . "'"); $selectstring ? $selectstring .= " and " . $fieldName[$y] . "='" . $felt[$y] . "'" : ($selectstring = $fieldName[$y] . "='" . $felt[$y] . "'"); } } if ($posnr && $ordre_id) { db_modify("update {$table} set posnr=posnr+1 where ordre_id = '{$ordre_id}' and posnr >= '{$posnr}'", __FILE__ . " linje " . __LINE__); } db_modify("insert into ordrelinjer ({$fieldstring}) values ({$fieldvalues})", __FILE__ . " linje " . __LINE__); $r = db_fetch_array(db_select("select id from {$table} where {$selectstring}", __FILE__ . " linje " . __LINE__)); $ny_id = $r['id']; return $ny_id; }
if (db_num_rows($rqlibt) >0) { $rwlibt=db_fetch_assoc($rqlibt); $table0cexists=true; } else { $table0cexists=false; } $ult=rtb_ultchp(); echo "<H3>Table <I>".$NM_TABLE."</I> (".$rwlibt[$ult[LIBELLE]].")</H3>"; if ($rwlibt[$ult[$GLOBALS["NmChpComment"]]]) echo "<small>".$rwlibt[$ult[$GLOBALS["NmChpComment"]]]."</small><br/>"; if ($CREATION=="false") { // on affiche les champ dans l'ordre d�ition $resf= db_query("SELECT NM_CHAMP FROM $TBDname WHERE NM_TABLE='$NM_TABLE' AND NM_CHAMP!='$NmChDT' ORDER BY ORDAFF"); while ($rf=db_fetch_row($resf)) $tbLCHP[]=$rf[0]; } $resf=db_query(addwherefORlimit("select * from $CSpIC$NM_TABLE$CSpIC",1)); // uniquement pour avoir la liste des champs $nfields=db_num_fields($resf); if ($AFFALL=="vrai") echo "<BLOCKQUOTE>La table $NM_TABLE comporte ".$nfields." champs :<BR><FONT SIZE=\"-1\">"; echo '<TABLE BORDER="1"><THEAD><TH>NOM CHAMP</TH><TH>TYPE</TH><TH>LIBELLE</TH><TH>TYP. AFF</TH><TH>VALEURS</TH><TH>COMMENTAIRE</TH></THEAD>'; // DU au fait que la fonction mysql_field_flags ne fonctionne correctement qu'avec un resultat "NORMAL" et pas avec une requete du type SHOW FIELDS if ($_SESSION[db_type]=="mysql") $table_def = mysql_query("SHOW FIELDS FROM $CSpIC$NM_TABLE$CSpIC"); //$resf=mysql_list_fields ($DBName, $CSpIC$NM_TABLE$CSpIC); // ins�e un champ commun de description de la table s'il n'existe pas $rpct=db_query("SELECT NM_CHAMP FROM $TBDname WHERE NM_TABLE='$NM_TABLE' AND NM_CHAMP='$NmChDT'"); if (db_num_rows($rpct)==0) db_query("INSERT INTO $TBDname (NM_TABLE, NM_CHAMP,LIBELLE, ORDAFF, ORDAFF_L) values ('$NM_TABLE','$NmChDT','$NM_TABLE', '$i', '$i')"); for ($j = 0; $j < $nfields; $j++) {
/** count the number fields in table */ function count_opendb_table_columns($table) { $result = db_query("SELECT * FROM {$table} LIMIT 0,1"); if ($result) { // count fields (columns) in table return db_num_fields($result); } //else return FALSE; }