You can subscribe to this list here.
2002 |
Jan
|
Feb
|
Mar
|
Apr
(29) |
May
(39) |
Jun
(14) |
Jul
(46) |
Aug
(26) |
Sep
(73) |
Oct
(34) |
Nov
(28) |
Dec
(93) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2003 |
Jan
(171) |
Feb
(58) |
Mar
(149) |
Apr
(160) |
May
(230) |
Jun
(49) |
Jul
(46) |
Aug
(123) |
Sep
(120) |
Oct
(91) |
Nov
(66) |
Dec
(82) |
2004 |
Jan
(40) |
Feb
(72) |
Mar
(36) |
Apr
(31) |
May
(141) |
Jun
(86) |
Jul
(136) |
Aug
(58) |
Sep
(41) |
Oct
(9) |
Nov
(55) |
Dec
(24) |
2005 |
Jan
(29) |
Feb
(74) |
Mar
(112) |
Apr
(45) |
May
(49) |
Jun
(95) |
Jul
(48) |
Aug
(57) |
Sep
(21) |
Oct
(52) |
Nov
(73) |
Dec
(40) |
2006 |
Jan
(16) |
Feb
|
Mar
(4) |
Apr
(9) |
May
(18) |
Jun
(43) |
Jul
(5) |
Aug
(30) |
Sep
(13) |
Oct
(8) |
Nov
(13) |
Dec
(28) |
2007 |
Jan
(65) |
Feb
(10) |
Mar
(29) |
Apr
(96) |
May
(41) |
Jun
(26) |
Jul
(49) |
Aug
(7) |
Sep
(61) |
Oct
(45) |
Nov
(40) |
Dec
(66) |
2008 |
Jan
(24) |
Feb
(33) |
Mar
(12) |
Apr
(8) |
May
|
Jun
(3) |
Jul
(13) |
Aug
(10) |
Sep
(3) |
Oct
(10) |
Nov
(7) |
Dec
(15) |
2009 |
Jan
(1) |
Feb
(7) |
Mar
(10) |
Apr
(6) |
May
(2) |
Jun
(4) |
Jul
(8) |
Aug
(1) |
Sep
(4) |
Oct
(12) |
Nov
(3) |
Dec
|
2010 |
Jan
(5) |
Feb
(1) |
Mar
(12) |
Apr
(7) |
May
(11) |
Jun
(6) |
Jul
(8) |
Aug
(9) |
Sep
(31) |
Oct
(5) |
Nov
(21) |
Dec
(13) |
2011 |
Jan
(7) |
Feb
(3) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2012 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(2) |
Jun
(1) |
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
(3) |
Dec
|
2013 |
Jan
|
Feb
|
Mar
(7) |
Apr
(12) |
May
(11) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(10) |
Dec
(1) |
2014 |
Jan
(1) |
Feb
|
Mar
(5) |
Apr
(1) |
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
2015 |
Jan
(5) |
Feb
(10) |
Mar
(4) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2016 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(3) |
Sep
|
Oct
|
Nov
|
Dec
|
2018 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(5) |
Nov
(18) |
Dec
|
2019 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
(10) |
Aug
|
Sep
(8) |
Oct
(8) |
Nov
|
Dec
(7) |
2020 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(12) |
Nov
(5) |
Dec
(1) |
2021 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2023 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
From: Christopher Kings-L. <ch...@us...> - 2002-05-15 03:29:58
|
Update of /cvsroot/phppgadmin/phpPgAdmin In directory usw-pr-cvs1:/tmp/cvs-serv26818 Modified Files: tbl_create.php Log Message: SERIAL types should never have lengths or defaults set. Index: tbl_create.php =================================================================== RCS file: /cvsroot/phppgadmin/phpPgAdmin/tbl_create.php,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** tbl_create.php 2 Feb 2001 06:03:08 -0000 1.3 --- tbl_create.php 15 May 2002 03:29:55 -0000 1.4 *************** *** 10,14 **** if (!empty($field_name[$i])) { $query .= "$cfgQuotes$field_name[$i]$cfgQuotes $field_type[$i]"; ! if (!empty($field_length[$i])) { $query .= " (".stripslashes($field_length[$i]).")"; } --- 10,14 ---- if (!empty($field_name[$i])) { $query .= "$cfgQuotes$field_name[$i]$cfgQuotes $field_type[$i]"; ! if (!empty($field_length[$i]) && !eregi("SERIAL", $field_type[$i])) { $query .= " (".stripslashes($field_length[$i]).")"; } *************** *** 16,20 **** $query .= " $field_attribute[$i]"; } ! if (!empty($field_default[$i])) { $query .= " DEFAULT ".stripslashes($field_default[$i]); } --- 16,20 ---- $query .= " $field_attribute[$i]"; } ! if (!empty($field_default[$i]) && !eregi("SERIAL", $field_type[$i])) { $query .= " DEFAULT ".stripslashes($field_default[$i]); } |
From: Dan W. <kil...@us...> - 2002-05-13 14:32:47
|
Update of /cvsroot/phppgadmin/phpPgAdmin In directory usw-pr-cvs1:/tmp/cvs-serv27775 Modified Files: db_create.php Log Message: Added display of 'Database ' cosmetic change when creating new db Index: db_create.php =================================================================== RCS file: /cvsroot/phppgadmin/phpPgAdmin/db_create.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** db_create.php 2 Feb 2001 06:03:08 -0000 1.2 --- db_create.php 13 May 2002 14:32:45 -0000 1.3 *************** *** 10,13 **** --- 10,14 ---- pg_die(pg_errormessage(), $qrCreateDB, __FILE__, __LINE__); } else { + echo "<h1> $strDatabase $newdb</h1>"; $message = "$strDatabase $newdb $strHasBeenCreated"; $db = $newdb; |
From: Dan W. <kil...@us...> - 2002-05-13 14:08:14
|
Update of /cvsroot/phppgadmin/phpPgAdmin In directory usw-pr-cvs1:/tmp/cvs-serv17597 Modified Files: db_details.php Log Message: Fixed hard-coded reference to template1 Index: db_details.php =================================================================== RCS file: /cvsroot/phppgadmin/phpPgAdmin/db_details.php,v retrieving revision 1.21 retrieving revision 1.22 diff -C2 -d -r1.21 -r1.22 *** db_details.php 17 Apr 2002 22:51:20 -0000 1.21 --- db_details.php 13 May 2002 14:08:11 -0000 1.22 *************** *** 473,477 **** <li><a href="db_details.php?server=<?php echo $server;?>&db=<?php echo $db; ?>&rel_type=<?php echo $rel_type; ?>&printview=1"><?php echo $strPrintScreen;?></a> ! <li><a href="sql.php?server=<?php echo $server;?>&db=template1&sql_query=<?php echo urlencode("DROP DATABASE $cfgQuotes$db$cfgQuotes");?>&zero_rows=<?php echo urlencode($strDatabase." ".$db." ".$strHasBeenDropped);?>&goto=main.php&reload=true"><?php echo $strDropDB." ".$db;?></a> <br><br> <!--li><a href="reports.php?server=<?php echo $server;?>&dbname=<?php echo $db; ?>&goto=main.php"><?php echo $strReports; ?></a--> --- 473,477 ---- <li><a href="db_details.php?server=<?php echo $server;?>&db=<?php echo $db; ?>&rel_type=<?php echo $rel_type; ?>&printview=1"><?php echo $strPrintScreen;?></a> ! <li><a href="sql.php?server=<?php echo $server;?>&db=<?php echo $cfgDefaultDB; ?>&sql_query=<?php echo urlencode("DROP DATABASE $cfgQuotes$db$cfgQuotes");?>&zero_rows=<?php echo urlencode($strDatabase." ".$db." ".$strHasBeenDropped);?>&goto=main.php&reload=true"><?php echo $strDropDB." ".$db;?></a> <br><br> <!--li><a href="reports.php?server=<?php echo $server;?>&dbname=<?php echo $db; ?>&goto=main.php"><?php echo $strReports; ?></a--> |
From: Robert T. <xz...@us...> - 2002-05-10 18:23:40
|
Update of /cvsroot/phppgadmin/phpPgAdmin In directory usw-pr-cvs1:/tmp/cvs-serv2800 Modified Files: portuguese.inc.php Log Message: $strLogin was missing from the translation list. Thanks to Roberto Bertó (darkelder) Index: portuguese.inc.php =================================================================== RCS file: /cvsroot/phppgadmin/phpPgAdmin/portuguese.inc.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** portuguese.inc.php 10 Nov 2000 04:35:58 -0000 1.1.1.1 --- portuguese.inc.php 10 May 2002 18:23:37 -0000 1.2 *************** *** 60,63 **** --- 60,64 ---- $strLines = "Linhas"; $strLocationTextfile = "Local do arquivo texto"; + $strLogin = "Login"; $strLogout = "Sair"; $strModifications = "Modificações foram salvas"; |
From: Christopher Kings-L. <ch...@us...> - 2002-05-08 08:38:11
|
Update of /cvsroot/phppgadmin/phpPgAdmin In directory usw-pr-cvs1:/tmp/cvs-serv577 Modified Files: german.inc.php Log Message: New german translations from Jurgen Nagel [jn...@fi...] Index: german.inc.php =================================================================== RCS file: /cvsroot/phppgadmin/phpPgAdmin/german.inc.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** german.inc.php 10 Nov 2000 04:35:55 -0000 1.1.1.1 --- german.inc.php 8 May 2002 08:38:08 -0000 1.2 *************** *** 1,121 **** ! <?php ! /* $Id$ */ ! ! $strAPrimaryKey = "Ein Primarschlüssel wurde für folgendes Feld hinzugefügt: "; ! $strAccessDenied = "Zugriff verweigert."; ! $strAction = "Aktion"; ! $strAddNewField = "Neues Feld hinzufügen"; ! $strAddSearchConditions = "Suchkondition (Argumente für das WHERE-Statement):"; ! $strAnIndex = "Ein Index wurde für folgendes Feld hinzugefügt: "; ! $strAttr = "Attribute"; ! $strBrowse = "Anzeigen"; ! $strCarriage = "Carriage return: \\r"; ! $strChange = "Ändern"; ! $strColumnNames = "Spaltennamen"; ! $strCopyTable = "Tabelle kopieren nach:"; ! $strCopyTableOK = "Tabelle \$table wurde kopiert nach \$new_name."; ! $strCreate = "Erzeugen"; ! $strCreateNewDatabase = "Neue Datenbank erzeugen"; ! $strCreateNewTable = "Neue Tabelle erstellen in Datenbank "; ! $strDatabase = "Datenbank "; ! $strDatabases = "Datenbanken"; ! $strDefault = "Default"; ! $strDelete = "Löschen"; ! $strDeleted = "Die Zeile wurde gelöscht."; ! $strDoAQuery = "Suche über Beispielwerte (\"query by example\") (Platzhalter: \"%\")"; ! $strDoYouReally = "Möchten Sie wirklich diese Abfrage ausführen: "; ! $strDocu = "Dokumentation"; ! $strDrop = "Löschen"; ! $strDropDB = "Datenbank löschen:"; ! $strDumpingData = "Daten für Tabelle"; ! $strEdit = "Ändern"; ! $strEmpty = "Leeren"; ! $strEmptyResultSet = "PostgreSQL lieferte ein leeres Resultset zurück (d.h. null Zeilen)."; ! $strEnclosedBy = "eingeschlossen von"; ! $strEnd = "Ende"; ! $strError = "Fehler"; ! $strEscapedBy = "escaped von"; ! $strExtra = "Extra"; ! $strField = "Feld"; ! $strFields = "Felder"; ! $strFunction = "Funktion"; ! $strGo = "OK"; ! $strHasBeenAltered = "wurde geändert."; ! $strHasBeenCreated = "wurde erzeugt."; ! $strHasBeenDropped = "wurde gelöscht."; ! $strHasBeenEmptied = "wurde geleert."; ! $strHome = "Home"; ! $strHost = "Host"; ! $strIfYouWish = "Wenn Sie nur bestimmte Spalten importieren möchten, geben Sie diese bitte hier an."; ! $strIndex = "Index"; ! $strInsert = "Einfügen"; ! $strInsertIntoTable = "In Tabelle einfügen"; ! $strInsertNewRow = "Neue Zeile einfügen"; ! $strInsertTextfiles = "Textdatei in Tabelle einfügen"; ! $strKeyname = "Name"; ! $strLengthSet = "Länge/Set"; ! $strLineFeed = "Linefeed: \\n"; ! $strLines = "Zeilen"; ! $strLocationTextfile = "Datei"; ! $strModifications = "Änderungen gespeichert."; ! $strPostgreSQLReloaded = "PostgreSQL neu gestartet."; ! $strPostgreSQLSaid = "PostgreSQL meldet: "; ! $strPostgreSQLShowStatus = "PostgreSQL-Laufzeit-Informationen anzeigen"; ! $strPostgreSQLShowVars = "PostgreSQL-System-Variablen anzeigen"; ! $strName = "Name"; ! $strNext = "Nächste"; ! $strNo = "Nein"; ! $strNoTablesFound = "Keine Tabellen in der Datenbank gefunden."; ! $strNull = "Null"; ! $strOftenQuotation = "Häufig Anführungszeichen. OPTIONALLY bedeutet, daß nur Textfelder von den angegeben Zeichen eingeschlossen sind."; ! $strOptionalControls = "Optional. Bestimmt, wie Sonderzeichen kenntlich gemacht werden.."; ! $strOptionally = "OPTIONALLY"; ! $strPos1 = "Anfang"; ! $strPrevious = "Vorherige"; ! $strPrimary = "Primärschlüssel"; ! $strPrimaryKey = "Primärschlüssel"; ! $strProducedAnError = "erzeugte einen Fehler."; ! $strProperties = "Eigenschaften"; ! $strReadTheDocs = "PostgreSQL-Dokumentation zu LOAD DATA INFILE lesen"; ! $strRecords = "Einträge"; ! $strReloadFailed = "PostgreSQL Neuladen fehlgeschlagen."; ! $strReloadPostgreSQL = "PostgreSQL neu starten"; ! $strRenameTable = "Tabelle umbennen in"; ! $strRenameTableOK = "Tabelle \$table wurde umbenannt in \$new_name."; ! $strReplace = "Ersetzen"; ! $strReplaceTable = "Tabelleninhalt ersetzen"; ! $strReset = "Zurücksetzen"; ! $strRunSQLQuery = "SQL-Befehl(e) ausführen in Datenbank "; ! $strRunning = "auf "; ! $strSQLQuery = "SQL-Befehl"; ! $strSave = "Speichern"; ! $strSelect = "Teilw. anzeigen"; ! $strSelectFields = "Felder auswählen (mind. eines):"; ! $strSend = "senden"; ! $strShowingRecords = "Zeige Records "; ! $strStrucCSV = "CSV-Daten"; ! $strStrucData = "Struktur und Daten"; ! $strStrucDrop = "Mit 'drop table'"; ! $strStrucOnly = "Nur Struktur"; ! $strSubmit = "Abschicken"; ! $strSuccess = "Ihr SQL-Befehl wurde erfolgreich ausgeführt."; ! $strTable = "Tabelle "; ! $strTableStructure = "Tabellenstruktur für Tabelle"; ! $strTerminatedBy = "getrennt mit"; ! $strTheContent = "Der Inhalt Ihrer Datei wurde eingefügt."; ! $strTheContents = "Der Inhalt der CSV-Datei ersetzt die Einträge mit den gleichen Primär- oder Unique-Schlüsseln."; ! $strTheTerminator = "Der Trenner zwischen den Feldern."; ! $strTotal = "insgesamt"; ! $strType = "Typ"; ! $strUnique = "Unique"; ! $strValue = "Wert"; ! $strViewDump = "Dump (Schema) der Tabelle anzeigen"; ! $strViewDumpDB = "Dump (Schema) der Datenbank anzeigen"; ! $strWelcome = "Willkommen bei "; ! $strWrongUser = "Falscher Benutzername/Passwort. Zugriff verweigert."; ! $strYes = "Ja"; ! $strPostgreSQLShowProcess = "Prozesse anzeigen"; ! $strLogout = "Neu einloggen"; ! $strQBE = "Query by Example"; ! $strBack = "Zurück"; ! ?> --- 1,236 ---- ! <?php ! /* $Id$ */ ! ! $strAPrimaryKey = "Ein Primarschlüssel wurde für folgendes Feld hinzugefügt: "; ! $strAccessDenied = "Zugriff verweigert."; ! $strAction = "Aktion"; ! $strAddNewField = "Neues Feld hinzufügen"; ! $strAddSearchConditions = "Suchkondition (Argumente für das WHERE-Statement):"; ! $strAnIndex = "Ein Index wurde für folgendes Feld hinzugefügt: "; ! $strAttr = "Attribute"; ! $strBack = "Zurück"; ! $strBrowse = "Anzeigen"; ! $strCarriage = "Carriage return: \\r"; ! $strChange = "ändern"; ! $strColumnNames = "Spaltennamen"; ! $strConstraintName = "Constraint Name"; ! $strCopyTable = "Tabelle kopieren nach:"; ! $strCopyTableOK = "Tabelle \$table wurde kopiert nach \$new_name."; ! $strCreate = "Erzeugen"; ! $strCreateNewDatabase = "Neue Datenbank erzeugen"; ! $strCreateNewTable = "Neue Tabelle erstellen in Datenbank "; ! $strDatabase = "Datenbank "; ! $strDatabases = "Datenbanken"; ! $strDefault = "Default"; ! $strDeferrable = "Deferrable"; ! $strDelete = "Löschen"; ! $strDeleted = "Die Zeile wurde gelöscht."; ! $strDoAQuery = "Suche über Beispielwerte (\"query by example\") (Platzhalter: \"%\")"; ! $strDoYouReally = "Möchten Sie wirklich diese Abfrage ausführen: "; ! $strDocu = "Dokumentation"; ! $strDrop = "Löschen"; ! $strDropDB = "Datenbank löschen:"; ! $strDumpingData = "Daten für Tabelle"; ! $strEdit = "ändern"; ! $strEmpty = "Leeren"; ! $strEmptyResultSet = "PostgreSQL lieferte ein leeres Resultset zurück (d.h. null Zeilen)."; ! $strEnabled = "Enabled"; ! $strEnclosedBy = "eingeschlossen von"; ! $strEnd = "Ende"; ! $strError = "Fehler"; ! $strEscapedBy = "escaped von"; ! $strExtra = "Extra"; ! $strField = "Feld"; ! $strNumFields = "Anzahl an Feldern"; ! $strFunction = "Funktion"; ! $strGo = "OK"; ! $strHasBeenAltered = "wurde geändert."; ! $strHasBeenCreated = "wurde erzeugt."; ! $strHasBeenDropped = "wurde gelöscht."; ! $strHasBeenEmptied = "wurde geleert."; ! $strHome = "Home"; ! $strHost = "Host"; ! $strIfYouWish = "Wenn Sie nur bestimmte Spalten importieren möchten, geben Sie diese bitte hier an."; ! $strIndex = "Index"; ! $strInitDeferred = "Init. Deferred"; ! $strInsert = "Einfügen"; ! $strInsertIntoTable = "In Tabelle einfügen"; ! $strInsertNewRow = "Neue Zeile einfügen"; ! $strInsertTextfiles = "Textdatei in Tabelle einfügen"; ! $strIsConstraint = "Constraint"; ! $strKeyname = "Name"; ! $strLengthSet = "Länge/Set"; ! $strLineFeed = "Linefeed: \\n"; ! $strLines = "Zeilen"; ! $strLocationTextfile = "Datei"; ! $strLogout = "Log out"; ! $strModifications = "Änderungen gespeichert."; ! $strMySQLReloaded = "PostgreSQL neu gestartet."; ! $strMySQLSaid = "PostgreSQL meldet: "; ! $strMySQLShowProcess = "Show processes"; ! $strMySQLShowStatus = "PostgreSQL-Laufzeit-Informationen anzeigen"; ! $strMySQLShowVars = "PostgreSQL-System-Variablen anzeigen"; ! $strName = "Name"; ! $strNext = "Nächste"; ! $strNo = "Nein"; ! $strNoTablesFound = "Keine Tabellen in der Datenbank gefunden."; ! $strNull = "Null"; ! $strOftenQuotation = "Häufig Anführungszeichen. OPTIONALLY bedeutet, daß nur Textfelder von den angegeben Zeichen eingeschlossen sind."; ! $strOptionalControls = "Optional. Bestimmt, wie Sonderzeichen kenntlich gemacht werden.."; ! $strOptionally = "OPTIONALLY"; ! $strPos1 = "Anfang"; ! $strPrevious = "Vorherige"; ! $strPrimary = "Primärschlüssel"; ! $strPrimaryKey = "Primärschlüssel"; ! $strProducedAnError = "erzeugte einen Fehler."; ! $strProperties = "Eigenschaften"; ! $strQBE = "Query by Example"; ! $strReadTheDocs = "PostgreSQL-Dokumentation zu LOAD DATA INFILE lesen"; ! $strRecords = "Einträge"; ! $strRefresh = "Refresh"; ! $strReferences = "References"; ! $strReloadFailed = "PostgreSQL Neuladen fehlgeschlagen."; ! $strReloadMySQL = "PostgreSQL neu starten"; ! $strRenameTable = "Tabelle umbennen in"; ! $strRenameTableOK = "Tabelle \$table wurde umbenannt in \$new_name."; ! $strReplace = "Ersetzen"; ! $strReplaceTable = "Tabelleninhalt ersetzen"; ! $strReset = "Zurücksetzen"; ! $strRun = "Run"; ! $strRunSQLQuery = "SQL-Befehl(e) ausführen in Datenbank "; ! $strRunning = "auf "; ! $strSQLQuery = "SQL-Befehl"; ! $strSave = "Speichern"; ! $strSelect = "Auswählen"; ! $strSelectFields = "Felder auswählen (mind. eines):"; ! $strSend = "senden"; ! $strShowingRecords = "Zeige Records "; ! $strStrucCSV = "CSV-Daten"; ! $strStrucData = "Struktur und Daten"; ! $strStrucDrop = "Mit 'drop table'"; ! $strStrucOnly = "Nur Struktur"; ! $strSubmit = "Abschicken"; ! $strSuccess = "Ihr SQL-Befehl wurde erfolgreich ausgeführt."; ! $strTable = "Tabelle "; ! $strTableStructure = "Tabellenstruktur für Tabelle"; ! $strTerminatedBy = "getrennt mit"; ! $strTheContent = "Der Inhalt Ihrer Datei wurde eingefügt."; ! $strTheContents = "Der Inhalt der CSV-Datei ersetzt die Einträge mit den gleichen Primär- oder Unique-Schlüsseln."; ! $strTheTerminator = "Der Trenner zwischen den Feldern."; ! $strTotal = "insgesamt"; ! $strType = "Typ"; ! $strUnique = "Unique"; ! $strValue = "Wert"; ! $strViewDump = "Dump (Schema) der Tabelle anzeigen"; ! $strViewDumpDB = "Dump (Schema) der Datenbank anzeigen"; ! $strWelcome = "Willkommen bei "; ! $strWrongUser = "Falscher Benutzername/Passwort. Zugriff verweigert."; ! $strYes = "Ja"; ! ! ! // Added for phpPgAdmin ! $strAddGroup = "Gruppe hinzufügen"; ! $strAddConditions = "Additional Conditions"; ! $strAddUser = "Benutzer hinzufügen"; ! $strAffected = "Affected Rows"; ! $strAllDatabases = "Alle Datenbanken"; ! $strArg = "Argument"; ! $strArgs = "Arguments"; ! $strCancel = "Abbrechen"; ! $strCommutator = "Commutator"; ! $strCreateNew = "Erstellen von neuer "; ! $strCreateDB = "DB erstellen"; ! $strCreated = "Created"; ! $strCatUpd = "Update Catalog"; ! $strDate = "Datum"; ! $strDefinition = "Definition"; ! $strDescription = "Beschreibung"; ! $strDisplay = "Anzeige von"; ! $strOnEvents = "On Events"; ! $strEncoding = "Encoding"; ! $strExecute = "Execute"; ! $strExpires = "Expires"; ! $strFileLocation = "oder aus Textdatei"; ! $strFound = "gefunden"; ! $strFunc = "Funktion"; ! $strFuncs = "Funktionen"; ! $strGroup = "Gruppe"; ! $strGroupAdmin = "Group Admin"; ! $strGroupDeleted = "Group deleted"; ! $strGroupField = "Group Name"; ! $strGroupID = "SysID"; ! $strGroupMessage = "Gruppentabelle ist leer."; ! $strGroupModify = "Ändern"; ! $strGroups = "Available Groups"; ! $strGroupUpdated = "Group updated"; ! $strGroupUpdate = "Update"; ! $strHasBeenVacuumed = "has been vacuumed (analyzed)"; ! $strHashes = "Hashes"; ! $strIndicies = "Indicies"; ! $strJoin = "Join"; ! $strLang = "Sprache"; ! $strLeft = "Left"; ! $strLength = "Länge"; ! $strLinkKeys = "Linking keys"; ! $strLogin = "Login"; ! $strLogOutInst = "Reload afterwards"; ! $strLoggedInAs = "You are logged in as"; ! $strMax = "Max"; ! $strMember = "Members"; ! $strMore = "More"; ! $strNegator = "Negator"; ! $strNewUser = "Neuer Benutzer"; ! $strNewGroup = "Neue Gruppe"; ! $strNonMember = "Non-Members"; ! $strNoAuth = "Not authorized"; ! $strNoData = "Keine Daten"; ! $strNoReports = "No Reports"; ! $strNotDisplayed = "Not displayed"; ! $strNotNull = "Not Null"; ! $strNotImp = "The PostgreSQL ALTER TABLE only supports renaming of the column.<br>Other options are left for (hopefull) future support"; ! $strOnDB = " in Datenbank "; ! $strOwner = "Eigentümer"; ! $strOperator = "Operator"; ! $strOperators = "Operatoren"; ! $strPassword = "Paßwort"; ! $strPrintScreen = "Drucken"; ! $strPrivileges = "Privileges"; ! $strProperty = "Eigenschaft"; ! $strPostgres = "PostgreSQL"; ! $strReport = "Report"; ! $strReports = "Reports"; ! $strReportName = "Report Name"; ! $strReportsRequire = "The reporting utility requires the creation of the phppgadmin database. You must create the database to continue."; ! $strRename = "Umbenennen"; ! $strRetType = "Returns"; ! $strRestart = "Restart"; ! $strRestrict = "Restrict"; ! $strRevokeGroup = "Revoke Group"; ! $strRevokeUser = "Revoke User"; ! $strRight = "Right"; ! $strRule = "Regel"; ! $strSequence = "Sequenz"; ! $strSequences = "Sequenzen"; ! $strSort = "Sort"; ! $strSrc = "Source"; ! $strStart = "Start"; ! $strSuperUser = "Super User"; ! $strSystemTables = "Systemtabellen"; ! $strSysID = "SysID"; ! $strTable = "Tabelle"; ! $strTables = "Tabellen"; ! $strTrigger = "Trigger"; ! $strTriggers = "Triggers"; ! $strUpdate = "Update"; ! $strUpdated = "updated"; ! $strUseDefault = "Use default value"; ! $strUserAdmin = "User Admin"; ! $strUserUpdated = "User table updated"; ! $strUserName = "Username"; ! $strUserGroup = "User/Group"; ! $strVacuumDB = "Datenbank aufräumen: "; ! $strVacuumAnalyzeDB = "Datenbank aufräumen und analysieren: "; ! $strView = "View"; ! $strViews = "Views"; ! $strWhen = "When"; ! ?> |
From: Dan W. <kil...@us...> - 2002-05-02 20:12:44
|
Update of /cvsroot/phppgadmin/www-site/pages In directory usw-pr-cvs1:/tmp/cvs-serv17543/pages Modified Files: main.php Log Message: Updated version of pgsql required Index: main.php =================================================================== RCS file: /cvsroot/phppgadmin/www-site/pages/main.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** main.php 19 Dec 2001 19:46:21 -0000 1.2 --- main.php 2 May 2002 20:12:41 -0000 1.3 *************** *** 43,47 **** Requirements:<br /> PHP 3.x+ (4+ suggested)<br /> ! PostgreSQL 6.5+ (7+ suggested for full functionality)<br /> PHP enabled web server<br /> 4.0+ Browser (NS,IE) [NS6 -- functionality is limited in navigation]<br /> --- 43,47 ---- Requirements:<br /> PHP 3.x+ (4+ suggested)<br /> ! PostgreSQL 7+ <br /> PHP enabled web server<br /> 4.0+ Browser (NS,IE) [NS6 -- functionality is limited in navigation]<br /> |
From: Dan W. <kil...@us...> - 2002-05-01 15:42:24
|
Update of /cvsroot/phppgadmin/phpPgAdmin In directory usw-pr-cvs1:/tmp/cvs-serv21165 Modified Files: lib.inc.php Log Message: Fixed super-user variable name Index: lib.inc.php =================================================================== RCS file: /cvsroot/phppgadmin/phpPgAdmin/lib.inc.php,v retrieving revision 1.55 retrieving revision 1.56 diff -C2 -d -r1.55 -r1.56 *** lib.inc.php 20 Mar 2002 05:20:17 -0000 1.55 --- lib.inc.php 1 May 2002 15:42:17 -0000 1.56 *************** *** 296,301 **** // Let's determine whether the user logged in is a superuser ! $strSuperUser = $PHP_PGADMIN_USER; ! $qrIsSuper = "SELECT usesuper FROM pg_user WHERE usename = '$strSuperUser' AND usesuper = 't'"; $rsIsSuper = @pg_exec($link, pre_query($qrIsSuper)); if (@pg_numrows($rsIsSuper)) { --- 296,301 ---- // Let's determine whether the user logged in is a superuser ! $strBigSuper = $PHP_PGADMIN_USER; ! $qrIsSuper = "SELECT usesuper FROM pg_user WHERE usename = '$strBigSuper' AND usesuper = 't'"; $rsIsSuper = @pg_exec($link, pre_query($qrIsSuper)); if (@pg_numrows($rsIsSuper)) { |
From: Christopher Kings-L. <ch...@us...> - 2002-05-01 09:37:34
|
Update of /cvsroot/phppgadmin/webdb/lang In directory usw-pr-cvs1:/tmp/cvs-serv13987/lang Modified Files: template.php Log Message: Basic user admin support. Doesn't do password changing yet. Index: template.php =================================================================== RCS file: /cvsroot/phppgadmin/webdb/lang/template.php,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** template.php 15 Apr 2002 11:57:29 -0000 1.5 --- template.php 1 May 2002 09:37:30 -0000 1.6 *************** *** 30,32 **** --- 30,40 ---- $strAggregates = 'Aggregates'; + // Users + $strUsername = 'Username'; + $strPassword = 'Password'; + $strSuper = 'Superuser?'; + $strCreateDB = 'Create DB?'; + $strExpires = 'Expires'; + $strNoUsers = 'No users found.'; + ?> |
From: Christopher Kings-L. <ch...@us...> - 2002-05-01 09:37:34
|
Update of /cvsroot/phppgadmin/webdb/classes/database In directory usw-pr-cvs1:/tmp/cvs-serv13987/classes/database Modified Files: ADODB_base.php Postgres71.php Log Message: Basic user admin support. Doesn't do password changing yet. Index: ADODB_base.php =================================================================== RCS file: /cvsroot/phppgadmin/webdb/classes/database/ADODB_base.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** ADODB_base.php 18 Feb 2002 09:46:49 -0000 1.2 --- ADODB_base.php 1 May 2002 09:37:30 -0000 1.3 *************** *** 35,38 **** --- 35,50 ---- /** + * Cleans (escapes) an array + * @param $arr The array to clean, by reference + * @return The cleaned array + */ + function arrayClean(&$arr) { + reset($arr); + while(list($k, $v) = each($arr)) + $arr[$k] = addslashes($v); + return $arr; + } + + /** * Executes a query on the underlying connection * @param $sql The SQL query to execute Index: Postgres71.php =================================================================== RCS file: /cvsroot/phppgadmin/webdb/classes/database/Postgres71.php,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** Postgres71.php 15 Apr 2002 12:16:35 -0000 1.7 --- Postgres71.php 1 May 2002 09:37:30 -0000 1.8 *************** *** 17,20 **** --- 17,21 ---- var $tbFields = array('tbname' => 'tablename', 'tbowner' => 'tableowner'); var $vwFields = array('vwname' => 'viewname', 'vwowner' => 'viewowner', 'vwdef' => 'definition'); + var $uFields = array('uname' => 'usename', 'usuper' => 'usesuper', 'ucreatedb' => 'usecreatedb', 'uexpires' => 'valuntil'); // @@ Should we bother querying for this? *************** *** 557,560 **** --- 558,649 ---- * Creates a new operator */ + + // User and group functions + + /** + * Returns all users in the database cluster + * @return All users + */ + function &getUsers() { + $sql = "SELECT usename, usesuper, usecreatedb, valuntil FROM pg_shadow ORDER BY usename"; + + return $this->selectSet($sql); + } + + /** + * Return information about a single user + * @param $username The username of the user to retrieve + * @return The user's data + */ + function &getUser($username) { + $this->clean($username); + + $sql = "SELECT usename, usesuper, usecreatedb, valuntil FROM pg_shadow WHERE usename='{$username}'"; + + return $this->selectSet($sql); + } + + /** + * Creates a new user + * @param $username The username of the user to create + * @param $password A password for the user + * @param $createdb boolean Whether or not the user can create databases + * @param $createuser boolean Whether or not the user can create other users + * @param $expiry string Format 'YYYY-MM-DD HH:MM:SS'. When the account expires. + * @param $group (array) The groups to create the user in + * @return 0 success + */ + function createUser($username, $password, $createdb, $createuser, $expiry, $groups) { + $this->clean($username); + // @@ THIS IS A PROBLEM FOR TRIMMING PASSWORD!!! + $this->clean($password); + $this->clean($expiry); + $this->arrayClean($groups); + + $sql = "CREATE USER \"{$username}\""; + if ($password != '') $sql .= " WITH PASSWORD '{$password}'"; + $sql .= ($createdb) ? ' CREATEDB' : ' NOCREATEDB'; + $sql .= ($createuser) ? ' CREATEUSER' : ' NOCREATEUSER'; + if (is_array($groups) && sizeof($groups) > 0) $sql .= " IN GROUP '" . join("', '", $groups) . "'"; + if ($expiry != '') $sql .= " VALID UNTIL '{$expiry}'"; + + return $this->execute($sql); + } + + /** + * Adjusts a user's info + * @param $username The username of the user to modify + * @param $password A new password for the user + * @param $createdb boolean Whether or not the user can create databases + * @param $createuser boolean Whether or not the user can create other users + * @param $expiry string Format 'YYYY-MM-DD HH:MM:SS'. When the account expires. + * @return 0 success + */ + function setUser($username, $password, $createdb, $createuser, $expiry) { + $this->clean($username); + $this->clean($password); + $this->clean($expiry); + + $sql = "ALTER USER \"{$username}\""; + if ($password != '') $sql .= " WITH PASSWORD '{$password}'"; + $sql .= ($createdb) ? ' CREATEDB' : ' NOCREATEDB'; + $sql .= ($createuser) ? ' CREATEUSER' : ' NOCREATEUSER'; + if ($expiry != '') $sql .= " VALID UNTIL '{$expiry}'"; + + return $this->execute($sql); + } + + /** + * Removes a user + * @param $username The username of the user to drop + * @return 0 success + */ + function dropUser($username) { + $this->clean($username); + + $sql = "DROP USER \"{$username}\""; + + return $this->execute($sql); + } // Capabilities |
From: Christopher Kings-L. <ch...@us...> - 2002-05-01 09:37:34
|
Update of /cvsroot/phppgadmin/webdb/public_html In directory usw-pr-cvs1:/tmp/cvs-serv13987/public_html Modified Files: topbar.php Added Files: users.php Log Message: Basic user admin support. Doesn't do password changing yet. --- NEW FILE: users.php --- <?php /** * Manage users in a database cluster * * $Id: users.php,v 1.1 2002/05/01 09:37:30 chriskl Exp $ */ // Include application functions include_once('../conf/config.inc.php'); if (!isset($action)) $action = ''; if (!isset($msg)) $msg = ''; /** * Function to save after editing a user */ function doSaveEdit() { global $data, $username, $formCreateDB, $formSuper, $formExpires, $form; $status = $data->setUser($username, '', isset($formCreateDB), isset($formSuper), $formExpires); if ($status == 0) doProperties('User updated.'); else doEdit('User update failed.'); } /** * Function to allow editing of a user */ function doEdit($msg = '') { global $data, $misc, $username; global $PHP_SELF, $strUsername, $strSuper, $strCreateDB, $strExpires, $strActions, $strNoUsers; echo "<h2>Users: ", htmlspecialchars($username), ": Edit</h2>\n"; $misc->printMsg($msg); $userdata = &$data->getUser($username); if ($userdata->recordCount() > 0) { $userdata->f[$data->uFields['ucreatedb']] = $data->phpBool($userdata->f[$data->uFields['ucreatedb']]); $userdata->f[$data->uFields['usuper']] = $data->phpBool($userdata->f[$data->uFields['usuper']]); echo "<form action=\"$PHP_SELF\" method=post>\n"; echo "<table>\n"; echo "<tr><th class=data>{$strUsername}</th><th class=data>{$strSuper}</th><th class=data>{$strCreateDB}</th><th class=data>{$strExpires}</th></tr>\n"; echo "<tr><td class=data1>", htmlspecialchars($userdata->f[$data->uFields['uname']]), "</td>\n"; echo "<td class=data1><input type=checkbox name=formSuper", ($userdata->f[$data->uFields['usuper']]) ? ' checked' : '', "></td>\n"; echo "<td class=data1><input type=checkbox name=formCreateDB", ($userdata->f[$data->uFields['ucreatedb']]) ? ' checked' : '', "></td>\n"; echo "<td class=data1><input size=30 name=formExpires value=\"", htmlspecialchars($userdata->f[$data->uFields['uexpires']]), "\"></td></tr>\n"; echo "</table>\n"; echo "<input type=hidden name=action value=save_edit>\n"; echo "<input type=hidden name=username value=\"", htmlspecialchars($username), "\">\n"; echo "<input type=submit value=Save> <input type=reset>\n"; echo "</form>\n"; } else echo "<p>No data.</p>\n"; echo "<p><a class=navlink href=\"$PHP_SELF\">Show All Users</a> |\n"; echo "<a class=navlink href=\"$PHP_SELF?action=properties&username=", urlencode($username), "\">Properties</a></p>\n"; } /** * Show read only properties for a user */ function doProperties($msg = '') { global $data, $misc, $username; global $PHP_SELF, $strUsername, $strSuper, $strCreateDB, $strExpires, $strActions, $strNoUsers; echo "<h2>Users: ", htmlspecialchars($username), ": Properties</h2>\n"; $misc->printMsg($msg); $userdata = &$data->getUser($username); if ($userdata->recordCount() > 0) { echo "<table>\n"; echo "<tr><th class=data>{$strUsername}</th><th class=data>{$strSuper}</th><th class=data>{$strCreateDB}</th><th class=data>{$strExpires}</th></tr>\n"; echo "<tr><td class=data1>", htmlspecialchars($userdata->f[$data->uFields['uname']]), "</td>\n"; echo "<td class=data1>", $userdata->f[$data->uFields['usuper']], "</td>\n"; echo "<td class=data1>", $userdata->f[$data->uFields['ucreatedb']], "</td>\n"; echo "<td class=data1>", htmlspecialchars($userdata->f[$data->uFields['uexpires']]), "</td></tr>\n"; echo "</table>\n"; } else echo "<p>No data.</p>\n"; echo "<p><a class=navlink href=\"$PHP_SELF\">Show All Users</a> |\n"; echo "<a class=navlink href=\"$PHP_SELF?action=edit&username=", urlencode($username), "\">Edit</a></p>\n"; } /** * Show confirmation of drop and perform actual drop */ function doDrop($confirm) { global $data, $username; global $PHP_SELF; if ($confirm) { echo "<h2>Users: ", htmlspecialchars($username), ": Drop</h2>\n"; echo "<p>Are you sure you want to drop the user \"", htmlspecialchars($username), "\"?</p>\n"; echo "<form action=\"$PHP_SELF\" method=\"post\">\n"; echo "<input type=hidden name=action value=drop>\n"; echo "<input type=hidden name=username value=\"", htmlspecialchars($username), "\">\n"; echo "<input type=submit name=choice value=\"Yes\"> <input type=submit name=choice value=\"No\">\n"; echo "</form>\n"; } else { $status = $data->dropUser($username); if ($status == 0) doDefault('User dropped.'); else doDefault('User drop failed.'); } } /** * Displays a screen where they can enter a new user */ function doCreate($msg = '') { global $data, $misc, $username; global $formUsername, $formPassword, $formSuper, $formCreateDB, $formExpires; global $PHP_SELF, $strUsername, $strPassword, $strSuper, $strCreateDB, $strExpires, $strActions, $strNoUsers; if (!isset($formUsername)) $formUsername = ''; if (!isset($formUsername)) $formPassword = ''; if (!isset($formExpires)) $formExpires = ''; echo "<h2>Users: Create User</h2>\n"; $misc->printMsg($msg); echo "<form action=\"$PHP_SELF\" method=post>\n"; echo "<table>\n"; echo "<tr><th class=data>{$strUsername}</th><th class=data>{$strPassword}</th><th class=data>{$strSuper}</th><th class=data>{$strCreateDB}</th><th class=data>{$strExpires}</th></tr>\n"; echo "<tr><td class=data1><input size=15 name=formUsername value=\"", htmlspecialchars($formUsername), "\"></td>\n"; echo "<td class=data1><input size=15 name=formPassword value=\"", htmlspecialchars($formPassword), "\"></td>\n"; echo "<td class=data1><input type=checkbox name=formSuper", (isset($formSuper)) ? ' checked' : '', "></td>\n"; echo "<td class=data1><input type=checkbox name=formCreateDB", (isset($formCreateDB)) ? ' checked' : '', "></td>\n"; echo "<td class=data1><input size=30 name=formExpires value=\"", htmlspecialchars($formExpires), "\"></td></tr>\n"; echo "</table>\n"; echo "<input type=hidden name=action value=save_create>\n"; echo "<input type=submit value=Save> <input type=reset>\n"; echo "</form>\n"; echo "<p><a class=navlink href=\"$PHP_SELF\">Show All Users</a></p>\n"; } /** * Actually creates the new view in the database */ function doSaveCreate() { global $data, $formUsername, $formPassword, $formSuper, $formCreateDB, $formExpires; // @@ NOTE: No groups handled yet $status = $data->createUser($formUsername, $formPassword, isset($formSuper), isset($formCreateDB), $formExpires, array()); if ($status == 0) doDefault('User created.'); else doCreate('User creation failed.'); } /** * Show default list of users in the database */ function doDefault($msg = '') { global $data, $misc; global $PHP_SELF, $strUsername, $strSuper, $strCreateDB, $strExpires, $strActions, $strNoUsers; echo "<h2>Users</h2>\n"; $misc->printMsg($msg); $users = &$data->getUsers(); if ($users->recordCount() > 0) { echo "<table>\n"; echo "<tr><th class=data>{$strUsername}</th><th class=data>{$strSuper}</th>"; echo "<th class=data>{$strCreateDB}</th><th class=data>{$strExpires}</th><th colspan=2 class=data>{$strActions}</th>\n"; $i = 0; while (!$users->EOF) { $id = (($i % 2) == 0 ? '1' : '2'); echo "<tr><td class=data{$id}>", htmlspecialchars($users->f[$data->uFields['uname']]), "</td>\n"; echo "<td class=data{$id}>", htmlspecialchars($users->f[$data->uFields['usuper']]), "</td>\n"; echo "<td class=data{$id}>", htmlspecialchars($users->f[$data->uFields['ucreatedb']]), "</td>\n"; echo "<td class=data{$id}>", htmlspecialchars($users->f[$data->uFields['uexpires']]), "</td>\n"; echo "<td class=opbutton{$id}><a href=\"$PHP_SELF?action=properties&username=", urlencode($users->f[$data->uFields['uname']]), "\">Properties</a></td>\n"; echo "<td class=opbutton{$id}><a href=\"$PHP_SELF?action=confirm_drop&username=", urlencode($users->f[$data->uFields['uname']]), "\">Drop</a></td>\n"; echo "</tr>\n"; $users->moveNext(); $i++; } echo "</table>\n"; } else { echo "<p>{$strNoUsers}</p>\n"; } echo "<p><a class=navlink href=\"$PHP_SELF?action=create\">Create User</a></p>\n"; } echo "<html>\n"; echo "<body>\n"; switch ($action) { case 'save_create': doSaveCreate(); break; case 'create': doCreate(); break; case 'drop': if ($choice == 'Yes') doDrop(false); else doDefault(); break; case 'confirm_drop': doDrop(true); break; case 'save_edit': doSaveEdit(); break; case 'edit': doEdit(); break; case 'properties': doProperties(); break; default: doDefault(); break; } echo "</body>\n"; echo "</html>\n"; ?> Index: topbar.php =================================================================== RCS file: /cvsroot/phppgadmin/webdb/public_html/topbar.php,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** topbar.php 10 Apr 2002 04:09:47 -0000 1.3 --- topbar.php 1 May 2002 09:37:30 -0000 1.4 *************** *** 24,29 **** <tr> <td> ! <a class=toplink href="usrlist.php">User Admin</a> | ! <a class=toplink href="grplist.php">Group Admin</a> | <a class=toplink href="login.php?mode=logout" target="_parent">Logout</a> </td> --- 24,29 ---- <tr> <td> ! <a class=toplink href="users.php" target="detail">User Admin</a> | ! <a class=toplink href="groups.php" target="detail">Group Admin</a> | <a class=toplink href="login.php?mode=logout" target="_parent">Logout</a> </td> |
From: Dan W. <kil...@us...> - 2002-04-29 15:51:29
|
Update of /cvsroot/phppgadmin/phpPgAdmin In directory usw-pr-cvs1:/tmp/cvs-serv20587 Added Files: turkish.inc.php Log Message: Added turkish translation --- NEW FILE: turkish.inc.php --- <?php /* $Id: turkish.inc.php,v 1.1 2002/04/29 15:51:26 killroyboy Exp $ */ $strAPrimaryKey = "Bir primary key eklendi, tablo adý: "; $strAccessDenied = "Eriþim engellendi"; $strAction = "Eylem"; $strAddNewField = "Yeni bir alan ekle"; $strAddSearchConditions = "Add search conditions (body of the \"where\" clause):"; $strAnIndex = "Index eklenen tablonun adý: "; $strAttr = "Attributes"; $strBack = "Geri"; $strBrowse = "Gözat"; $strCarriage = "Carriage return: \\r"; $strChange = "Deðiþtir"; $strColumnNames = "Kolon adlarý"; $strConstraintName = "Constraint Name"; $strCopyTable = "Tablonun kopyalanacaðý yer:"; $strCopyTableOK = "\$table tablosunun adý \$new_name olarak deðiþtirildi."; $strCreate = "Yarat"; $strCreateNewDatabase = "Yeni bir veritabaný yarat"; $strCreateNewTable = "Tablo yarat: Kullanýlacak veritabaný:"; $strDatabase = "Veritabaný "; $strDatabases = "veritabanlarý"; $strDefault = "Varsayýlan"; $strDeferrable = "Deferrable"; $strDelete = "Sil"; $strDeleted = "Satýr silindi"; $strDoAQuery = "Do a \"query by example\" (wildcard: \"%\")"; $strDoYouReally = "Gerçekten de "; $strDocu = "Belgelendirme"; $strDrop = "Drop"; $strDropDB = "Drop database "; $strDumpingData = "Verinin dump edildiði tablonun adý :"; $strEdit = "Düzenle"; $strEmpty = "Boþalt"; $strEmptyResultSet = "PostgreSQL returned an empty result set (i.e. zero rows)."; $strEnabled = "Enabled"; $strEnclosedBy = "enclosed by"; $strEnd = "Son"; $strError = "Hata"; $strEscapedBy = "escaped by"; $strExtra = "Extra"; $strField = "Veri Alaný"; $strNumFields = "Field sayýsý"; $strFunction = "Function"; $strGo = "Git"; $strHasBeenAltered = "has been altered."; $strHasBeenCreated = "yaratýldý."; $strHasBeenDropped = "silindi (dropped)."; $strHasBeenEmptied = "boþaltýldý (emptied)."; $strHome = "Ana Sayfa"; $strHost = "Host"; $strIfYouWish = "If you wish to load only some of a table's columns, specify a comma separated field list."; $strIndex = "Index"; $strInitDeferred = "Init. Deferred"; $strInsert = "Insert"; $strInsertIntoTable = "Insert into table"; $strInsertNewRow = "Yeni bir kayýt ekle"; $strInsertTextfiles = "Tabloya dosyadan ekle: Eklenecek tablonun adý:"; $strIsConstraint = "Constraint"; $strKeyname = "Keyname"; $strLengthSet = "Length/Set"; $strLineFeed = "Linefeed: \\n"; $strLines = "Lines"; $strLocationTextfile = "Dosyanýn konumu"; $strLogout = "Çýkýþ Yap"; $strModifications = "Yapýlan deðiþiklikler kaydedildi"; $strMySQLReloaded = "PostgreSQL reload edildi."; $strMySQLSaid = "PostgreSQL mesajý: "; $strMySQLShowProcess = "Ýþlemleri (process) göster"; $strMySQLShowStatus = "Show PostgreSQL runtime information"; $strMySQLShowVars = "PostgreSQL sistem deðiþkenlerini göster"; $strName = "Ad"; $strNext = "Ýleri"; $strNo = "Hayýr"; $strNoTablesFound = "Veritabanýnda tablo bulunamadý."; $strNull = "Null"; $strOftenQuotation = "Often quotation marks. OPTIONALLY means that only char and varchar fields are enclosed by the \"enclosed by\"-character."; $strOptionalControls = "Optional. Controls how to write or read special characters."; $strOptionally = "SEÇÝMSEL"; $strPos1 = "Baþla"; $strPrevious = "Önceki"; $strPrimary = "Primary"; $strPrimaryKey = "Primary key"; $strProducedAnError = "bir hata oluþturdu."; $strProperties = "Özellikler"; $strQBE = "Örnek bir sorgu"; $strReadTheDocs = "Belgeleri oku"; $strRecords = "Kayýtlar"; $strRefresh = "Yenile"; $strReferences = "References"; $strReloadFailed = "PostgreSQL reload iþlemi baþarýsýz oldu."; $strReloadMySQL = "PostgreSQL yeniden yükle"; $strRenameTable = "Tablo adýný deðiþtir:"; $strRenameTableOK = "Table \$table has been renamed to \$new_name"; $strReplace = "Replace"; $strReplaceTable = "Replace table data with file"; $strReset = "Reset"; $strRun = "Çalýþtýr"; $strRunSQLQuery = "SQL sorgusunun/sorgularýnýn çalýþtýrýlacaðý veritabaný: "; $strRunning = "running on "; $strSQLQuery = "SQL-query"; $strSave = "Kaydet"; $strSelect = "Select"; $strSelectFields = "Alanlarý(field) seçiniz (En az bir tane):"; $strSend = "gönder"; $strShowingRecords = "Showing records "; $strStrucCSV = "CSV data"; $strStrucData = "Yapý ve veri"; $strStrucDrop = "Dosya baþýna 'drop table' ekle"; $strStrucOnly = "Sadece tablo yapýsý"; $strSubmit = "Gönder"; $strSuccess = "SQL sorgunuz baþarýyla çalýþtýrýldý."; $strTable = "Tablo"; $strTableStructure = "Yapýsý verilen tablo adý:"; $strTerminatedBy = "terminated by"; $strTheContent = "Dosyanýn içeriði girildi."; $strTheContents = "The contents of the file replaces the contents of the selected table for rows with identical primary or unique key."; $strTheTerminator = "The terminator of the fields."; $strTotal = "toplam"; $strType = "Veri Tipi"; $strUnique = "Unique"; $strValue = "Deðer"; $strViewDump = "dump'u (þema) gösterilecek tablo:"; $strViewDumpDB = "dump (schema) gösterilecek veritabaný:"; $strWelcome = "Hoþgeldiniz: "; $strWrongUser = "Wrong username/password. Access denied."; $strYes = "Yes"; // Added for phpPgAdmin $strAddGroup = "Grup Ekle"; $strAddConditions = "Additional Conditions"; $strAddUser = "Kullanýcý Ekle"; $strAffected = "Affected Rows"; $strAllDatabases = "Tüm veritabanlarý"; $strArg = "Argument"; $strArgs = "Arguments"; $strCancel = "Ýptal et"; $strCommutator = "Commutator"; $strCreateNew = "Create new "; $strCreateDB = "Veritabaný Yarat"; $strCreated = "Created"; $strCatUpd = "Update Catalog"; $strDate = "Date"; $strDefinition = "Definition"; $strDescription = "Description"; $strDisplay = "Göster:"; $strOnEvents = "On Events"; $strEncoding = "Encoding"; $strExecute = "Execute"; $strExpires = "Expires"; $strFileLocation = "ya da dosyadan yükle:"; $strFound = "bulundu"; $strFunc = "Function"; $strFuncs = "Functions"; $strGroup = "Group"; $strGroupAdmin = "Grup Yönetimi"; $strGroupDeleted = "Grup silindi"; $strGroupField = "Grup Adý"; $strGroupID = "SysID"; $strGroupMessage = "Grup Tablosu boþ."; $strGroupModify = "Deðiþiklik yap"; $strGroups = "Available Groups"; $strGroupUpdated = "Group updated"; $strGroupUpdate = "Güncellendi"; $strHasBeenVacuumed = "vakumlandý (analiz edildi)"; $strHashes = "Hashes"; $strIndicies = "Indicies"; $strJoin = "Join"; $strLang = "Dil"; $strLeft = "Sol"; $strLength = "Uzunluk"; $strLinkKeys = "Linking keys"; $strLogin = "Sisteme Giriþ Yap"; $strLogOutInst = "Reload afterwards"; $strLoggedInAs = "Sisteme giriþ yaptýðýnýz kullanýcý adý:"; $strMax = "Max"; $strMember = "Üyeler"; $strMore = "More"; $strNegator = "Negator"; $strNewUser = "Yeni kullanýcý"; $strNewGroup = "Yeni Grup"; $strNonMember = "Üye olmayanlar"; $strNoAuth = "Yetkili deðilsiniz"; $strNoData = "Veri Yok"; $strNoReports = "No Reports"; $strNotDisplayed = "Not displayed"; $strNotNull = "Null deðil"; $strNotImp = "PostgreSQL ALTER TABLE sadece kolonun yeniden adlandýrýlmasýný desteklemektedir.<br> Diðer seçenekler gelecekte desteklenecektir."; $strOnDB = " on database "; $strOwner = "Tablo Sahibi"; $strOperator = "Operator"; $strOperators = "Operators"; $strPassword = "Þifre"; $strPrintScreen = "Yazdýr"; $strPrivileges = "Eriþim Haklarý"; $strProperty = "Özellik"; $strPostgres = "PostgreSQL"; $strReport = "Rapor"; $strReports = "Raporlar"; $strReportName = "Report Adý"; $strReportsRequire = "Raporlama iþlevi phppgadmin veritabanýnýn yaratýlmasýný gerektirir. Devam etmek için veritabanýný yaratmalýsýnýz."; $strRename = "Yeniden Adlandýr"; $strRetType = "Returns"; $strRestart = "Yeniden Baþlat"; $strRestrict = "Kýsýtlama"; $strRevokeGroup = "Revoke Group"; $strRevokeUser = "Revoke User"; $strRight = "Right"; $strRule = "Rule"; $strSequence = "Sequence"; $strSequences = "Sequences"; $strSort = "Sýrala"; $strSrc = "Kaynak"; $strStart = "Baþla"; $strSuperUser = "Super Kullanýcý"; $strSystemTables = "System Tablolarý"; $strSysID = "SysID"; $strTable = "Tablo"; $strTables = "Tablolar"; $strTrigger = "Trigger"; $strTriggers = "Triggerlar"; $strUpdate = "Güncelle"; $strUpdated = "güncellendi"; $strUseDefault = "Use default value"; $strUserAdmin = "Kullanýcý Yönetimi"; $strUserUpdated = "Kullanýcý tablosu güncellendi"; $strUserName = "Kullanýcý Adý"; $strUserGroup = "Kullanýcý adý/Grup"; $strVacuumDB = "Vacuum Database"; $strVacuumAnalyzeDB = "Vacuum Analyze Database"; $strView = "View"; $strViews = "Views"; $strWhen = "When"; ?> |
From: Dan W. <kil...@us...> - 2002-04-29 15:47:48
|
Update of /cvsroot/phppgadmin/www-site/functions In directory usw-pr-cvs1:/tmp/cvs-serv19045 Modified Files: mail.php Log Message: Changed email to which the contact form is sent Index: mail.php =================================================================== RCS file: /cvsroot/phppgadmin/www-site/functions/mail.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** mail.php 19 Dec 2001 19:46:21 -0000 1.2 --- mail.php 29 Apr 2002 15:47:45 -0000 1.3 *************** *** 5,9 **** } ! $recipient = "Contact Form <kil...@us...>"; $subject = "Online Contact Form"; --- 5,9 ---- } ! $recipient = "Dev List <php...@li...>"; $subject = "Online Contact Form"; |
From: Dan W. <kil...@us...> - 2002-04-17 22:51:24
|
Update of /cvsroot/phppgadmin/phpPgAdmin In directory usw-pr-cvs1:/tmp/cvs-serv9501 Modified Files: config.inc.php-dist db_details.php Log Message: Made sql-query box bigger... it was just too small Index: config.inc.php-dist =================================================================== RCS file: /cvsroot/phppgadmin/phpPgAdmin/config.inc.php-dist,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** config.inc.php-dist 25 Jan 2002 17:15:11 -0000 1.7 --- config.inc.php-dist 17 Apr 2002 22:51:20 -0000 1.8 *************** *** 4,8 **** // Set the name and version $cfgProgName = "phpPgAdmin"; ! $cfgVersion = "2.4a-dev"; // The default database is used to connect to the database to check the adv_auth --- 4,8 ---- // Set the name and version $cfgProgName = "phpPgAdmin"; ! $cfgVersion = "2.4.2"; // The default database is used to connect to the database to check the adv_auth *************** *** 110,113 **** --- 110,114 ---- $cfgMaxRows = 30; $cfgMaxInputsize = "300px"; + $cfgMaxTextAreaSize = "400px"; $cfgOrder = "ASC"; *************** *** 125,127 **** include("english.inc.php"); ! ?> \ No newline at end of file --- 126,128 ---- include("english.inc.php"); ! ?> Index: db_details.php =================================================================== RCS file: /cvsroot/phppgadmin/phpPgAdmin/db_details.php,v retrieving revision 1.20 retrieving revision 1.21 diff -C2 -d -r1.20 -r1.21 *** db_details.php 20 Mar 2002 04:39:53 -0000 1.20 --- db_details.php 17 Apr 2002 22:51:20 -0000 1.21 *************** *** 410,414 **** <input type="hidden" name="zero_rows" value="<?php echo $strSuccess; ?>"> <?php echo $strRunSQLQuery.$db." ".show_docu("sql-select.htm");?>:<br> ! <textarea name="sql_query" cols="40" rows="3" wrap="VIRTUAL" style="width: <?php echo $cfgMaxInputsize;?>"><?php echo stripslashes($sql_query); ?></textarea> <input type="submit" name="SQL" value="<?php echo $strGo; ?>"> </form> --- 410,414 ---- <input type="hidden" name="zero_rows" value="<?php echo $strSuccess; ?>"> <?php echo $strRunSQLQuery.$db." ".show_docu("sql-select.htm");?>:<br> ! <textarea name="sql_query" cols="60" rows="6" wrap="VIRTUAL" style="width: <?php echo $cfgMaxTextAreaSize;?>"><?php echo stripslashes($sql_query); ?></textarea> <input type="submit" name="SQL" value="<?php echo $strGo; ?>"> </form> |
From: Dan W. <kil...@us...> - 2002-04-17 22:49:53
|
Update of /cvsroot/phppgadmin/phpPgAdmin In directory usw-pr-cvs1:/tmp/cvs-serv8974 Modified Files: reports.php tbl_qbe.php Log Message: Removed duplicate includes Index: reports.php =================================================================== RCS file: /cvsroot/phppgadmin/phpPgAdmin/reports.php,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** reports.php 31 Jan 2002 04:25:51 -0000 1.6 --- reports.php 17 Apr 2002 22:49:48 -0000 1.7 *************** *** 2,6 **** /* $Id$ */ - include("lib.inc.php"); include("header.inc.php"); --- 2,5 ---- Index: tbl_qbe.php =================================================================== RCS file: /cvsroot/phppgadmin/phpPgAdmin/tbl_qbe.php,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** tbl_qbe.php 10 Nov 2000 04:36:01 -0000 1.1.1.1 --- tbl_qbe.php 17 Apr 2002 22:49:48 -0000 1.2 *************** *** 1,4 **** <?php ! include( "header.inc.php"); if(empty($Columns)){$Columns = 3;} # initial number of columns --- 1,4 ---- <?php ! include("header.inc.php"); if(empty($Columns)){$Columns = 3;} # initial number of columns |
From: Christopher Kings-L. <ch...@us...> - 2002-04-15 12:16:39
|
Update of /cvsroot/phppgadmin/webdb/classes/database In directory usw-pr-cvs1:/tmp/cvs-serv833/classes/database Modified Files: Postgres71.php Log Message: Forgot to add support for creating a view. A few other stylistic improvements also. Definitely a good template now. Index: Postgres71.php =================================================================== RCS file: /cvsroot/phppgadmin/webdb/classes/database/Postgres71.php,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** Postgres71.php 15 Apr 2002 11:57:28 -0000 1.6 --- Postgres71.php 15 Apr 2002 12:16:35 -0000 1.7 *************** *** 20,23 **** --- 20,24 ---- // @@ Should we bother querying for this? var $_lastSystemOID = 18539; + var $_maxNameLen = 31; function Postgres71($host, $port, $database, $user, $password) { |
From: Christopher Kings-L. <ch...@us...> - 2002-04-15 12:16:39
|
Update of /cvsroot/phppgadmin/webdb/public_html In directory usw-pr-cvs1:/tmp/cvs-serv833/public_html Modified Files: views.php Log Message: Forgot to add support for creating a view. A few other stylistic improvements also. Definitely a good template now. Index: views.php =================================================================== RCS file: /cvsroot/phppgadmin/webdb/public_html/views.php,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** views.php 15 Apr 2002 11:57:29 -0000 1.1 --- views.php 15 Apr 2002 12:16:35 -0000 1.2 *************** *** 33,37 **** global $PHP_SELF, $strName, $strDefinition; ! echo "<h2>", htmlspecialchars($database), ": ", htmlspecialchars($view), "</h2>\n"; $misc->printMsg($msg); --- 33,37 ---- global $PHP_SELF, $strName, $strDefinition; ! echo "<h2>", htmlspecialchars($database), ": Views: ", htmlspecialchars($view), ": Edit</h2>\n"; $misc->printMsg($msg); *************** *** 40,44 **** if ($viewdata->recordCount() > 0) { echo "<form action=\"$PHP_SELF\" method=post>\n"; ! echo "<table>\n"; echo "<tr><th class=data>{$strName}</th></tr>\n"; echo "<tr><td class=data1>", htmlspecialchars($viewdata->f[$data->vwFields['vwname']]), "</td></tr>\n"; --- 40,44 ---- if ($viewdata->recordCount() > 0) { echo "<form action=\"$PHP_SELF\" method=post>\n"; ! echo "<table width=100%>\n"; echo "<tr><th class=data>{$strName}</th></tr>\n"; echo "<tr><td class=data1>", htmlspecialchars($viewdata->f[$data->vwFields['vwname']]), "</td></tr>\n"; *************** *** 57,61 **** echo "<p><a class=navlink href=\"$PHP_SELF?database=", urlencode($database), "\">Show All Views</a> |\n"; echo "<a class=navlink href=\"$PHP_SELF?action=properties&database=", urlencode($database), "&view=", ! urlencode($view), "\">Properties</a>\n"; } --- 57,61 ---- echo "<p><a class=navlink href=\"$PHP_SELF?database=", urlencode($database), "\">Show All Views</a> |\n"; echo "<a class=navlink href=\"$PHP_SELF?action=properties&database=", urlencode($database), "&view=", ! urlencode($view), "\">Properties</a></p>\n"; } *************** *** 67,71 **** global $PHP_SELF, $strName, $strDefinition; ! echo "<h2>", htmlspecialchars($database), ": ", htmlspecialchars($view), "</h2>\n"; $misc->printMsg($msg); --- 67,71 ---- global $PHP_SELF, $strName, $strDefinition; ! echo "<h2>", htmlspecialchars($database), ": Views: ", htmlspecialchars($view), ": Properties</h2>\n"; $misc->printMsg($msg); *************** *** 73,77 **** if ($viewdata->recordCount() > 0) { ! echo "<table>\n"; echo "<tr><th class=data>{$strName}</th></tr>\n"; echo "<tr><td class=data1>", htmlspecialchars($viewdata->f[$data->vwFields['vwname']]), "</td></tr>\n"; --- 73,77 ---- if ($viewdata->recordCount() > 0) { ! echo "<table width=100%>\n"; echo "<tr><th class=data>{$strName}</th></tr>\n"; echo "<tr><td class=data1>", htmlspecialchars($viewdata->f[$data->vwFields['vwname']]), "</td></tr>\n"; *************** *** 84,88 **** echo "<p><a class=navlink href=\"$PHP_SELF?database=", urlencode($database), "\">Show All Views</a> |\n"; echo "<a class=navlink href=\"$PHP_SELF?action=edit&database=", urlencode($database), "&view=", ! urlencode($view), "\">Edit</a>\n"; } --- 84,88 ---- echo "<p><a class=navlink href=\"$PHP_SELF?database=", urlencode($database), "\">Show All Views</a> |\n"; echo "<a class=navlink href=\"$PHP_SELF?action=edit&database=", urlencode($database), "&view=", ! urlencode($view), "\">Edit</a></p>\n"; } *************** *** 94,100 **** global $PHP_SELF; - echo "<h2>", htmlspecialchars($database), ": ", htmlspecialchars($view), "</h2>\n"; - if ($confirm) { echo "<p>Are you sure you want to drop the view \"", htmlspecialchars($view), "\"?</p>\n"; --- 94,100 ---- global $PHP_SELF; if ($confirm) { + echo "<h2>", htmlspecialchars($database), ": Views: ", htmlspecialchars($view), ": Drop</h2>\n"; + echo "<p>Are you sure you want to drop the view \"", htmlspecialchars($view), "\"?</p>\n"; *************** *** 114,117 **** --- 114,161 ---- } + } + + /** + * Displays a screen where they can enter a new view + */ + function doCreate($msg = '') { + global $data, $localData, $misc, $database, $view; + global $PHP_SELF, $strName, $strDefinition; + global $formView, $formDefinition; + + if (!isset($formView)) $formView = ''; + if (!isset($formDefinition)) $formDefinition = ''; + + echo "<h2>", htmlspecialchars($database), ": Views: Create View</h2>\n"; + $misc->printMsg($msg); + + echo "<form action=\"$PHP_SELF\" method=post>\n"; + echo "<table width=100%>\n"; + echo "<tr><th class=data>{$strName}</th></tr>\n"; + echo "<tr><td class=data1><input name=formView size={$data->_maxNameLen} maxlength={$data->_maxNameLen} value=\"", + htmlspecialchars($formView), "\"></td></tr>\n"; + echo "<tr><th class=data>{$strDefinition}</th></tr>\n"; + echo "<tr><td class=data1><textarea style=\"width:100%;\" rows=20 cols=50 name=formDefinition wrap=virtual>", + htmlspecialchars($formDefinition), "</textarea></td></tr>\n"; + echo "</table>\n"; + echo "<input type=hidden name=action value=save_create>\n"; + echo "<input type=hidden name=database value=\"", htmlspecialchars($database), "\">\n"; + echo "<input type=submit value=Save> <input type=reset>\n"; + echo "</form>\n"; + + echo "<p><a class=navlink href=\"$PHP_SELF?database=", urlencode($database), "\">Show All Views</a></p>\n"; + } + + /** + * Actually creates the new view in the database + */ + function doSaveCreate() { + global $localData, $formView, $formDefinition; + + $status = $localData->createView($formView, $formDefinition); + if ($status == 0) + doDefault('View created.'); + else + doCreate('View creation failed.'); } *************** *** 123,127 **** global $PHP_SELF, $strView, $strOwner, $strActions, $strNoViews; ! echo "<h2>", htmlspecialchars($database), "</h2>\n"; $misc->printMsg($msg); --- 167,171 ---- global $PHP_SELF, $strView, $strOwner, $strActions, $strNoViews; ! echo "<h2>", htmlspecialchars($database), ": Views</h2>\n"; $misc->printMsg($msg); *************** *** 147,154 **** --- 191,202 ---- $i++; } + echo "</table>\n"; } else { echo "<p>{$strNoViews}</p>\n"; } + + echo "<p><a class=navlink href=\"$PHP_SELF?action=create&database=", urlencode($database), "\">Create View</a></p>\n"; + } *************** *** 156,160 **** echo "<body>\n"; ! switch ($action) { case 'drop': if ($choice == 'Yes') doDrop(false); --- 204,214 ---- echo "<body>\n"; ! switch ($action) { ! case 'save_create': ! doSaveCreate(); ! break; ! case 'create': ! doCreate(); ! break; case 'drop': if ($choice == 'Yes') doDrop(false); *************** *** 173,208 **** doProperties(); break; ! case 'browse': ! /* ! echo "<h2>", htmlspecialchars($database), ": ", htmlspecialchars($table), "</h2>\n"; ! $rs = &$localData->browseTable($table, $offset, $limit); ! ! if ($rs->recordCount() > 0) { ! echo "<table>\n<tr>"; ! reset($rs->f); ! while(list($k, ) = each($rs->f)) { ! echo "<th class=data>", htmlspecialchars($k), "</td>"; ! } ! echo "<th colspan=2 class=data>{$strActions}</th>\n"; ! ! $i = 0; ! reset($rs->f); ! while (!$rs->EOF) { ! $id = (($i % 2) == 0 ? '1' : '2'); ! echo "<tr>\n"; ! while(list(, $v) = each($rs->f)) { ! echo "<td class=data{$id} nowrap>", nl2br(htmlspecialchars($v)), "</td>"; ! } ! echo "<td class=opbutton{$id}>Edit</td>\n"; ! echo "<td class=opbutton{$id}>Delete</td>\n"; ! echo "</tr>\n"; ! $rs->moveNext(); ! $i++; ! } ! } ! else echo "<p>No data.</p>\n"; ! ! break; ! */ default: doDefault(); --- 227,232 ---- doProperties(); break; ! case 'browse': ! // @@ Not yet implemented default: doDefault(); |
From: Christopher Kings-L. <ch...@us...> - 2002-04-15 11:57:33
|
Update of /cvsroot/phppgadmin/webdb/themes/default In directory usw-pr-cvs1:/tmp/cvs-serv26951/themes/default Modified Files: global.css Log Message: Support for VIEW manipulation. Use this as a template for functions, operators, etc. Index: global.css =================================================================== RCS file: /cvsroot/phppgadmin/webdb/themes/default/global.css,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** global.css 10 Apr 2002 04:09:47 -0000 1.2 --- global.css 15 Apr 2002 11:57:29 -0000 1.3 *************** *** 100,104 **** } ! a.toplink { font-weight: bold; } --- 100,104 ---- } ! a.toplink, a.navlink { font-weight: bold; } *************** *** 115,118 **** --- 115,123 ---- padding: 0px; margin: 0px; + } + + p.message + { + color: blue; } |
From: Christopher Kings-L. <ch...@us...> - 2002-04-15 11:57:33
|
Update of /cvsroot/phppgadmin/webdb/lang In directory usw-pr-cvs1:/tmp/cvs-serv26951/lang Modified Files: template.php Log Message: Support for VIEW manipulation. Use this as a template for functions, operators, etc. Index: template.php =================================================================== RCS file: /cvsroot/phppgadmin/webdb/lang/template.php,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** template.php 10 Apr 2002 04:09:47 -0000 1.4 --- template.php 15 Apr 2002 11:57:29 -0000 1.5 *************** *** 13,21 **** --- 13,25 ---- $strLogin = 'Login'; $strNoTables = 'No tables found.'; + $strNoViews = 'No views found.'; $strOwner = 'Owner'; $strActions = 'Actions'; + $strName = 'Name'; $strTable = 'Table'; $strTables = 'Tables'; + $strView = 'View'; $strViews = 'Views'; + $strDefinition = 'Definition'; $strTriggers = 'Triggers'; $strRules = 'Rules'; |
From: Christopher Kings-L. <ch...@us...> - 2002-04-15 11:57:33
|
Update of /cvsroot/phppgadmin/webdb/conf In directory usw-pr-cvs1:/tmp/cvs-serv26951/conf Modified Files: config.inc.php Log Message: Support for VIEW manipulation. Use this as a template for functions, operators, etc. Index: config.inc.php =================================================================== RCS file: /cvsroot/phppgadmin/webdb/conf/config.inc.php,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** config.inc.php 10 Apr 2002 04:09:47 -0000 1.5 --- config.inc.php 15 Apr 2002 11:57:28 -0000 1.6 *************** *** 76,79 **** --- 76,83 ---- } + // Create Misc class references + include_once('../classes/Misc.php'); + $misc = new Misc(); + // Theme echo "<style type=\"text/css\">\n<!--\n"; |
From: Christopher Kings-L. <ch...@us...> - 2002-04-15 11:57:32
|
Update of /cvsroot/phppgadmin/webdb/public_html In directory usw-pr-cvs1:/tmp/cvs-serv26951/public_html Added Files: views.php Log Message: Support for VIEW manipulation. Use this as a template for functions, operators, etc. --- NEW FILE: views.php --- <?php /** * Manage views in a database * * $Id: views.php,v 1.1 2002/04/15 11:57:29 chriskl Exp $ */ // Include application functions include_once('../conf/config.inc.php'); if (!isset($action)) $action = ''; if (!isset($msg)) $msg = ''; /** * Function to save after editing a view */ function doSaveEdit() { global $localData, $view, $formDefinition; $status = $localData->setView($view, $formDefinition); if ($status == 0) doProperties('View updated.'); else doEdit('View update failed.'); } /** * Function to allow editing of a view */ function doEdit($msg = '') { global $data, $localData, $misc, $database, $view; global $PHP_SELF, $strName, $strDefinition; echo "<h2>", htmlspecialchars($database), ": ", htmlspecialchars($view), "</h2>\n"; $misc->printMsg($msg); $viewdata = &$localData->getView($view); if ($viewdata->recordCount() > 0) { echo "<form action=\"$PHP_SELF\" method=post>\n"; echo "<table>\n"; echo "<tr><th class=data>{$strName}</th></tr>\n"; echo "<tr><td class=data1>", htmlspecialchars($viewdata->f[$data->vwFields['vwname']]), "</td></tr>\n"; echo "<tr><th class=data>{$strDefinition}</th></tr>\n"; echo "<tr><td class=data1><textarea style=\"width:100%;\" rows=20 cols=50 name=formDefinition wrap=virtual>", htmlspecialchars($viewdata->f[$data->vwFields['vwdef']]), "</textarea></td></tr>\n"; echo "</table>\n"; echo "<input type=hidden name=action value=save_edit>\n"; echo "<input type=hidden name=view value=\"", htmlspecialchars($view), "\">\n"; echo "<input type=hidden name=database value=\"", htmlspecialchars($database), "\">\n"; echo "<input type=submit value=Save> <input type=reset>\n"; echo "</form>\n"; } else echo "<p>No data.</p>\n"; echo "<p><a class=navlink href=\"$PHP_SELF?database=", urlencode($database), "\">Show All Views</a> |\n"; echo "<a class=navlink href=\"$PHP_SELF?action=properties&database=", urlencode($database), "&view=", urlencode($view), "\">Properties</a>\n"; } /** * Show read only properties for a view */ function doProperties($msg = '') { global $data, $localData, $misc, $database, $view; global $PHP_SELF, $strName, $strDefinition; echo "<h2>", htmlspecialchars($database), ": ", htmlspecialchars($view), "</h2>\n"; $misc->printMsg($msg); $viewdata = &$localData->getView($view); if ($viewdata->recordCount() > 0) { echo "<table>\n"; echo "<tr><th class=data>{$strName}</th></tr>\n"; echo "<tr><td class=data1>", htmlspecialchars($viewdata->f[$data->vwFields['vwname']]), "</td></tr>\n"; echo "<tr><th class=data>{$strDefinition}</th></tr>\n"; echo "<tr><td class=data1>", nl2br(htmlspecialchars($viewdata->f[$data->vwFields['vwdef']])), "</td></tr>\n"; echo "</table>\n"; } else echo "<p>No data.</p>\n"; echo "<p><a class=navlink href=\"$PHP_SELF?database=", urlencode($database), "\">Show All Views</a> |\n"; echo "<a class=navlink href=\"$PHP_SELF?action=edit&database=", urlencode($database), "&view=", urlencode($view), "\">Edit</a>\n"; } /** * Show confirmation of drop and perform actual drop */ function doDrop($confirm) { global $localData, $database, $view; global $PHP_SELF; echo "<h2>", htmlspecialchars($database), ": ", htmlspecialchars($view), "</h2>\n"; if ($confirm) { echo "<p>Are you sure you want to drop the view \"", htmlspecialchars($view), "\"?</p>\n"; echo "<form action=\"$PHP_SELF\" method=\"post\">\n"; echo "<input type=hidden name=action value=drop>\n"; echo "<input type=hidden name=view value=\"", htmlspecialchars($view), "\">\n"; echo "<input type=hidden name=database value=\"", htmlspecialchars($database), "\">\n"; echo "<input type=submit name=choice value=\"Yes\"> <input type=submit name=choice value=\"No\">\n"; echo "</form>\n"; } else { $status = $localData->dropView($view); if ($status == 0) doDefault('View dropped.'); else doDefault('View drop failed.'); } } /** * Show default list of views in the database */ function doDefault($msg = '') { global $data, $localData, $misc, $database, $view; global $PHP_SELF, $strView, $strOwner, $strActions, $strNoViews; echo "<h2>", htmlspecialchars($database), "</h2>\n"; $misc->printMsg($msg); $views = &$localData->getViews(); if ($views->recordCount() > 0) { echo "<table>\n"; echo "<tr><th class=data>{$strView}</th><th class=data>{$strOwner}</th><th colspan=4 class=data>{$strActions}</th>\n"; $i = 0; while (!$views->EOF) { $id = (($i % 2) == 0 ? '1' : '2'); echo "<tr><td class=data{$id}>", htmlspecialchars($views->f[$data->vwFields['vwname']]), "</td>\n"; echo "<td class=data{$id}>", htmlspecialchars($views->f[$data->vwFields['vwowner']]), "</td>\n"; echo "<td class=opbutton{$id}><a href=\"$PHP_SELF?action=browse&offset=0&limit=30&database=", htmlspecialchars($database), "&table=", urlencode($views->f[$data->vwFields['vwname']]), "\">Browse</a></td>\n"; echo "<td class=opbutton{$id}>Select</td>\n"; echo "<td class=opbutton{$id}><a href=\"$PHP_SELF?action=properties&database=", htmlspecialchars($database), "&view=", urlencode($views->f[$data->vwFields['vwname']]), "\">Properties</a></td>\n"; echo "<td class=opbutton{$id}><a href=\"$PHP_SELF?action=confirm_drop&database=", htmlspecialchars($database), "&view=", urlencode($views->f[$data->vwFields['vwname']]), "\">Drop</a></td>\n"; echo "</tr>\n"; $views->moveNext(); $i++; } } else { echo "<p>{$strNoViews}</p>\n"; } } echo "<html>\n"; echo "<body>\n"; switch ($action) { case 'drop': if ($choice == 'Yes') doDrop(false); else doDefault(); break; case 'confirm_drop': doDrop(true); break; case 'save_edit': doSaveEdit(); break; case 'edit': doEdit(); break; case 'properties': doProperties(); break; case 'browse': /* echo "<h2>", htmlspecialchars($database), ": ", htmlspecialchars($table), "</h2>\n"; $rs = &$localData->browseTable($table, $offset, $limit); if ($rs->recordCount() > 0) { echo "<table>\n<tr>"; reset($rs->f); while(list($k, ) = each($rs->f)) { echo "<th class=data>", htmlspecialchars($k), "</td>"; } echo "<th colspan=2 class=data>{$strActions}</th>\n"; $i = 0; reset($rs->f); while (!$rs->EOF) { $id = (($i % 2) == 0 ? '1' : '2'); echo "<tr>\n"; while(list(, $v) = each($rs->f)) { echo "<td class=data{$id} nowrap>", nl2br(htmlspecialchars($v)), "</td>"; } echo "<td class=opbutton{$id}>Edit</td>\n"; echo "<td class=opbutton{$id}>Delete</td>\n"; echo "</tr>\n"; $rs->moveNext(); $i++; } } else echo "<p>No data.</p>\n"; break; */ default: doDefault(); break; } echo "</body>\n"; echo "</html>\n"; ?> |
From: Christopher Kings-L. <ch...@us...> - 2002-04-15 11:57:31
|
Update of /cvsroot/phppgadmin/webdb/classes/database In directory usw-pr-cvs1:/tmp/cvs-serv26951/classes/database Modified Files: Postgres71.php Log Message: Support for VIEW manipulation. Use this as a template for functions, operators, etc. Index: Postgres71.php =================================================================== RCS file: /cvsroot/phppgadmin/webdb/classes/database/Postgres71.php,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** Postgres71.php 10 Apr 2002 04:09:47 -0000 1.5 --- Postgres71.php 15 Apr 2002 11:57:28 -0000 1.6 *************** *** 16,19 **** --- 16,20 ---- var $dbFields = array('dbname' => 'datname', 'dbcomment' => 'description'); var $tbFields = array('tbname' => 'tablename', 'tbowner' => 'tableowner'); + var $vwFields = array('vwname' => 'viewname', 'vwowner' => 'viewowner', 'vwdef' => 'definition'); // @@ Should we bother querying for this? *************** *** 436,439 **** --- 437,527 ---- */ + // View functions + + /** + * Returns a list of all views in the database + * @return All views + */ + function getViews() { + if (!$this->_showSystem) + $where = "WHERE viewname NOT LIKE 'pg_%'"; + else $where = ''; + + $sql = "SELECT viewname, viewowner FROM pg_views {$where} ORDER BY viewname"; + + return $this->selectSet($sql); + } + + /** + * Returns all details for a particular view + * @param $view The name of the view to retrieve + * @return View info + */ + function getView($view) { + $this->clean($view); + + $sql = "SELECT viewname, viewowner, definition FROM pg_views WHERE viewname='$view'"; + + return $this->selectSet($sql); + } + + /** + * Creates a new view. + * @param $viewname The name of the view to create + * @param $definition The definition for the new view + * @return 0 success + */ + function createView($viewname, $definition) { + $this->clean($viewname); + // Note: $definition not cleaned + + $sql = "CREATE VIEW \"{$viewname}\" AS {$definition}"; + + return $this->execute($sql); + } + + /** + * Drops a view. + * @param $viewname The name of the view to drop + * @return 0 success + */ + function dropView($viewname) { + $this->clean($viewname); + + $sql = "DROP VIEW \"{$viewname}\""; + + return $this->execute($sql); + } + + /** + * Updates a view. Postgres doesn't have CREATE OR REPLACE view, + * so we do it with a drop and a recreate. + * @param $viewname The name fo the view to update + * @param $definition The new definition for the view + * @return 0 success + * @return -1 transaction error + * @return -2 drop view error + * @return -3 create view error + */ + function setView($viewname, $definition) { + $status = $this->beginTransaction(); + if ($status != 0) return -1; + + $status = $this->dropView($viewname); + if ($status != 0) { + $this->rollbackTransaction(); + return -2; + } + + $status = $this->createView($viewname, $definition); + if ($status != 0) { + $this->rollbackTransaction(); + return -3; + } + + $status = $this->endTransaction(); + return ($status == 0) ? 0 : -1; + } + // Operator functions *************** *** 443,447 **** */ function getOperators() { ! if ($this->_showSystem) $where = "WHERE po.oid > '{$this->_lastSystemOID}'::oid"; else $where = ''; --- 531,535 ---- */ function getOperators() { ! if (!$this->_showSystem) $where = "WHERE po.oid > '{$this->_lastSystemOID}'::oid"; else $where = ''; |
From: Christopher Kings-L. <ch...@us...> - 2002-04-15 11:57:31
|
Update of /cvsroot/phppgadmin/webdb/classes In directory usw-pr-cvs1:/tmp/cvs-serv26951/classes Added Files: Misc.php Log Message: Support for VIEW manipulation. Use this as a template for functions, operators, etc. --- NEW FILE: Misc.php --- <?php /** * Class to hold various commonly used functions * * $Id: Misc.php,v 1.1 2002/04/15 11:57:28 chriskl Exp $ */ class Misc { /* Empty constructor */ function Misc() {} /** * Print out a message * @param $msg The message to print */ function printMsg($msg) { if ($msg != '') echo "<p class=message>", htmlspecialchars($msg), "</p>\n"; } } ?> |
From: Christopher Kings-L. <ch...@us...> - 2002-04-10 04:21:44
|
Update of /cvsroot/phppgadmin/webdb/public_html/images/themes/default In directory usw-pr-cvs1:/tmp/cvs-serv18927 Added Files: functions.gif operators.gif sequences.gif tables.gif title.gif triggers.gif views.gif Log Message: left nav images for default theme --- NEW FILE: functions.gif --- GIF89a %%%...333;;;EEEPPPWWWaaaiiiqqqyyy ¥¥¥´´´½½½ÇÇÇÐÐÐÕÕÕßßßÚÚÚåååêêêîîî!ù Üà!¡<ùAL?TP t @@V èúáA·´¤À Q --- NEW FILE: operators.gif --- GIF89a ***---222777BBBFFFLLLSSSZZZ```gggtttyyy¤¤¤ªªª±±±···ÈÈÈÍÍÍÚÚÚÞÞÞæææîîî!ù À ^pðÃ.6pU --- NEW FILE: sequences.gif --- GIF89a 9ð@´hÀ6àÁ` h p --- NEW FILE: tables.gif --- GIF89a --- NEW FILE: title.gif --- GIF89aÓ .I±Bd¦ã¢Dù"Æ?êtRÓ'^æÁ¡?:CF#@üÛʵ«×¯`½´raųhÓªMLF¡ CE$I(U6¡ã¦LHFhA" / @@hó@£V¡,ª´fÔ°ZHU«XµMú+Ù²kS«^öbÆ\Ê|¤+rLÉ)WR¥LMCdÉÃ<}£§R]B)6» [sÕÿ¥Ä)¤'T´ô~"1Ü4 Óa.Gs¡('`ö !EJxÇ^¶dªª²ª-E®r+HY¢×¢º !Ê®ùÅè«ÀRscʱé&ÐÒi!b§]Tzòy-¶Ùn+0CÝÆf(²ÞÕeJ_º¸«Lê×Î ¼ëÓmµ©)H1+Äh2 ©!À~<°#, H s©¨åÄ÷ͤ«i'ÈÂ%¨òi¨ÙýÑÇV{Õ¿(§¬òª,çwå\Û%ó|·ºÖ\<g£Ï0W pPrÿ¸ü`>P3*"D"ñFÜà·ÐëqØYVÑ Qþè Ñvÿ¶¶NØ(]QÚXNªq§¾¬ï ÖxÓªêk97ªNãB¹ÕèX{NNºv¬ôÚºÓ9¼ôFȬ[G\ex}pÐìî¶øôTÙV'¬A¸|#®:W):Ò»`Õi<ãºß-ô÷ °Jþx@7úò"ð¿|«¬zK ô±PgëÖûâ7ªgiËE0UT(6/[ûQ¯Ø9^ç&=ËYO°µ¶<à[ÑZaHn°>qy@£vòQêݾ5¦=pñçä-¯É°jÕs^ÿjdl!ÙfG¾YÈG²!ùÐ$ï4 Vl»Õr~ Cc FÕ^·ã ¢+Ê/zËÃN £¹ªeHûÛÉ^vª m)ø;Ô¦À@p-Íjßl«;÷]n7÷ƧªeÎÆõÛT®pv¨Ê'£SÊ,/°çíè-;Èÿn±¾ÿ°<\³Éã0ØÀBHov·êKYçs$PºÂ ¦,ÈnhSzÝ[:á¥ýHÇÇ7Éõn÷ê#?9½eÍu¤¼Ò`gÒÙ³¨¨Êϧ$jìmkë·G÷²·ì¶a ÃÁð,e éëRηÄL,Akòµ_´âKÞøÇ+;òâ±¼'ϰ±+!óàôêUeÊÕÊYùBhþ]Ð Ð: ~S$}?å@Þ´cZ¦d%Ô|¥~oÅ~íò7ôGpGt Yð5P p¡`kÕJxhx°QTĤ ¿ @ ¥¬ ³p¤x Ð 9`sYhyS9 (À±p º ¸ P¨ ª³:'À:àç °ðséðHQòhy v˰ Ûð Ò` ÍÐÏ` iÉ(mPÎhШ@c ÿ £ °È £Ð °ÀhæØ,`pîhwÃIÐ¥W ÓéÕ©L9¨?é |ÔÙðK¹ 0©ÛÉ(zªÙ³°¡¤Ø¡©éÅàðYp¢ô©¢*9 ¸¹êÈü2J£óx£y¹yn°¦~Ð |`I¤zàH¡X P K*åY§È »ÿ°¥]ú¥ûéþI¦ej¦ÃoJ>ø XEÚuy ©§\ ^¹¡~z ©À ¢§@¨¨¯¢ ¨ú ³¥yÖ «TJ Ýzòy¢ºm)®äÚ¹¹.*éHë*¬îz±_A¯õj¯¬¯|Ú¤¡¼P §é骫9 à#J¨ÞWʰ`ª¢¼8®piøÙ«+©Õ¬5±Bûù: K"K²¬Êº°(ËÅ«ïI .k°½à(³·Z³¹ª ö³^ºúÙ³19©Ú®Cë®$KË´N©²QÛÊ0µÜ µ`°ªµl ³4;Ä`³^»9k®Ë³é£Àz!Oc±iû¸`Ø: s[·Ã0§@µ´P¨V»·p¢%¹µ+¸0®\ê°+¶/:±§h*Ë®h¹C --- NEW FILE: triggers.gif --- GIF89a TÈ ÀåC @hèÁÁ ?2p`°©Ó§=`P0 10`Aa¢I-Ð0@B2üì0a@B(4XÀ¸q f¡ --- NEW FILE: views.gif --- GIF89a |
From: Christopher Kings-L. <ch...@us...> - 2002-04-10 04:21:06
|
Update of /cvsroot/phppgadmin/webdb/public_html/images/themes/default In directory usw-pr-cvs1:/tmp/cvs-serv18789/themes/default Log Message: Directory /cvsroot/phppgadmin/webdb/public_html/images/themes/default added to the repository |
From: Christopher Kings-L. <ch...@us...> - 2002-04-10 04:20:54
|
Update of /cvsroot/phppgadmin/webdb/public_html/images/themes In directory usw-pr-cvs1:/tmp/cvs-serv18727/themes Log Message: Directory /cvsroot/phppgadmin/webdb/public_html/images/themes added to the repository |