Menu
▾
▴
meshdb-cvs — Mailing list for CVS commit messages
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(49) |
Sep
(25) |
Oct
(2) |
Nov
|
Dec
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(24) |
Nov
(50) |
Dec
(4) |
| 2004 |
Jan
(2) |
Feb
(2) |
Mar
(5) |
Apr
|
May
(10) |
Jun
|
Jul
(10) |
Aug
(22) |
Sep
(10) |
Oct
|
Nov
(57) |
Dec
(5) |
| 2005 |
Jan
(24) |
Feb
(12) |
Mar
|
Apr
|
May
(3) |
Jun
(2) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2006 |
Jan
|
Feb
|
Mar
|
Apr
(9) |
May
(5) |
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
(1) |
|
From: <unl...@us...> - 2002-08-10 14:11:02
|
Update of /cvsroot/meshdb/www/deal
In directory usw-pr-cvs1:/tmp/cvs-serv14389
Modified Files:
index.php
Log Message:
Changed the file to test my commit skills.
Index: index.php
===================================================================
RCS file: /cvsroot/meshdb/www/deal/index.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- index.php 10 Aug 2002 11:51:42 -0000 1.2
+++ index.php 10 Aug 2002 14:10:59 -0000 1.3
@@ -1,7 +1,7 @@
<?
include "../db2/config.php";
-
+ #CVS comment
function quote($s) {
if ($s == "") return "null";
else return "'".mysql_escape_string($s)."'";
|
|
From: <le...@us...> - 2002-08-10 11:57:22
|
Update of /cvsroot/meshdb/www/deal In directory usw-pr-cvs1:/tmp/cvs-serv2431 Modified Files: deal.sql Log Message: oops, forgot the product table Index: deal.sql =================================================================== RCS file: /cvsroot/meshdb/www/deal/deal.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -d -r1.1 -r1.2 --- deal.sql 10 Aug 2002 10:09:47 -0000 1.1 +++ deal.sql 10 Aug 2002 11:57:18 -0000 1.2 @@ -58,3 +58,18 @@ PRIMARY KEY (id) ) TYPE=MyISAM; +# +# Table structure for table 'product' +# + +DROP TABLE IF EXISTS product; +CREATE TABLE product ( + id int(11) NOT NULL auto_increment, + class tinytext, + name mediumtext, + url mediumtext, + manuf tinytext, + description mediumtext, + PRIMARY KEY (id) +) TYPE=MyISAM; + |
|
From: <le...@us...> - 2002-08-10 11:51:45
|
Update of /cvsroot/meshdb/www/deal
In directory usw-pr-cvs1:/tmp/cvs-serv357
Modified Files:
index.php
Log Message:
use MYSQLPASS and MYSQLDB
Index: index.php
===================================================================
RCS file: /cvsroot/meshdb/www/deal/index.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- index.php 10 Aug 2002 03:11:58 -0000 1.1.1.1
+++ index.php 10 Aug 2002 11:51:42 -0000 1.2
@@ -21,8 +21,8 @@
exit;
}
- $db = mysql_connect($MYSQLHOST, $MYSQLUSER);
- mysql_select_db("mesh", $db) or die(mysql_error($db));
+ $db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
+ mysql_select_db($MYSQLDB, $db) or die(mysql_error($db));
if ($op == "deletedeal") {
$id = intval($id);
|
|
From: <le...@us...> - 2002-08-10 11:46:40
|
Update of /cvsroot/meshdb/www/db2 In directory usw-pr-cvs1:/tmp/cvs-serv30768 Modified Files: index.php Log Message: avoid division by zero error Index: index.php =================================================================== RCS file: /cvsroot/meshdb/www/db2/index.php,v retrieving revision 1.3 retrieving revision 1.4 diff -u -d -r1.3 -r1.4 --- index.php 10 Aug 2002 11:42:39 -0000 1.3 +++ index.php 10 Aug 2002 11:46:37 -0000 1.4 @@ -84,7 +84,7 @@ , $db) or die(mysql_error($db)); $row = mysql_fetch_assoc($result); -$mwid = max( $row["maxn"]-$row["minn"] , $row["maxe"]-$row["mine"] ); +$mwid = max(max( $row["maxn"]-$row["minn"] , $row["maxe"]-$row["mine"] ), 1); $mapscale = $len/$mwid/1.1; $mapn = ($row["minn"]+$row["maxn"])/2; $mape = ($row["mine"]+$row["maxe"])/2; |
|
From: <le...@us...> - 2002-08-10 11:42:44
|
Update of /cvsroot/meshdb/www/db2
In directory usw-pr-cvs1:/tmp/cvs-serv29203
Modified Files:
config-local.php-dist gawd.php index.php info.php
lookup.inc.php map2b.php map2d.php map3b.php map4b.php
select.php submit.php touch.php vrml3b.php
Log Message:
factor out the database name to the config file
Index: config-local.php-dist
===================================================================
RCS file: /cvsroot/meshdb/www/db2/config-local.php-dist,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- config-local.php-dist 10 Aug 2002 10:42:56 -0000 1.2
+++ config-local.php-dist 10 Aug 2002 11:42:39 -0000 1.3
@@ -8,12 +8,14 @@
* ========README=====README=====README======README======
*/
- global $MYSQLHOST, $MYSQLUSER, $MYSQLPASS, $READONLY, $OURPROXY;
+ global $MYSQLHOST, $MYSQLUSER, $MYSQLPASS, $MYSQLDB;
+ global $READONLY, $OURPROXY;
global $ZONE, $SHIFTFILE, $ALTFILE;
$MYSQLHOST = "host"; /* MySQL hostname */
$MYSQLUSER = "user"; /* MySQL username */
$MYSQLPASS = "pass"; /* MySQL password */
+ $MYSQLDB = "mesh"; /* Database name */
$READONLY = 0; /* Set to 1 for db maintennance */
$OURPROXY = "proxy"; /* an HTTP proxy host available to us */
Index: gawd.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/gawd.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- gawd.php 10 Aug 2002 10:42:56 -0000 1.2
+++ gawd.php 10 Aug 2002 11:42:39 -0000 1.3
@@ -10,7 +10,7 @@
include("util.php");
$db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
-mysql_select_db("mesh", $db)
+mysql_select_db($MYSQLDB, $db)
or die(mysql_error($db));
/* Generated the Last-modified header */
Index: index.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/index.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- index.php 10 Aug 2002 10:42:56 -0000 1.2
+++ index.php 10 Aug 2002 11:42:39 -0000 1.3
@@ -10,7 +10,7 @@
if ($len < 50) $len = $DEFAULTLEN;
$db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
- mysql_select_db("mesh", $db)
+ mysql_select_db($MYSQLDB, $db)
or die(mysql_error($db));
$result = mysql_query("SELECT max(unix_timestamp(updated)) from admin", $db)
or die(mysql_error($db));
Index: info.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/info.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- info.php 10 Aug 2002 10:42:56 -0000 1.2
+++ info.php 10 Aug 2002 11:42:39 -0000 1.3
@@ -3,7 +3,7 @@
<?
include("config.php");
$db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
- mysql_select_db("mesh", $db)
+ mysql_select_db($MYSQLDB, $db)
or die(mysql_error($db));
function q1($query) {
Index: lookup.inc.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/lookup.inc.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- lookup.inc.php 10 Aug 2002 10:42:56 -0000 1.2
+++ lookup.inc.php 10 Aug 2002 11:42:39 -0000 1.3
@@ -6,7 +6,7 @@
global $PREF;
$db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
- mysql_select_db("mesh", $db)
+ mysql_select_db($MYSQLDB, $db)
or die(mysql_error($db));
$nodeid = intval($nodeid);
Index: map2b.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/map2b.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- map2b.php 10 Aug 2002 10:42:56 -0000 1.2
+++ map2b.php 10 Aug 2002 11:42:39 -0000 1.3
@@ -26,7 +26,7 @@
if (!$im) die("image load failed");
$db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
-mysql_select_db("mesh", $db)
+mysql_select_db($MYSQLDB, $db)
or die(mysql_error($db));
/* Generated the Last-modified header */
Index: map2d.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/map2d.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- map2d.php 10 Aug 2002 10:42:56 -0000 1.2
+++ map2d.php 10 Aug 2002 11:42:39 -0000 1.3
@@ -39,7 +39,7 @@
header("X-source: $mburl");
$db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
-mysql_select_db("mesh", $db)
+mysql_select_db($MYSQLDB, $db)
or die(mysql_error($db));
/* If the image is in the cache, use it */
Index: map3b.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/map3b.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- map3b.php 10 Aug 2002 10:42:56 -0000 1.2
+++ map3b.php 10 Aug 2002 11:42:39 -0000 1.3
@@ -20,7 +20,7 @@
$vrml = intval($vrml);
$db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
-mysql_select_db("mesh", $db)
+mysql_select_db($MYSQLDB, $db)
or die(mysql_error($db));
/* Generated the Last-modified header */
Index: map4b.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/map4b.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- map4b.php 10 Aug 2002 10:42:56 -0000 1.2
+++ map4b.php 10 Aug 2002 11:42:39 -0000 1.3
@@ -16,7 +16,7 @@
$s = doubleval($_GET["s"]);
$db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
-mysql_select_db("mesh", $db)
+mysql_select_db($MYSQLDB, $db)
or die(mysql_error($db));
/* Generated the Last-modified header */
Index: select.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/select.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- select.php 10 Aug 2002 10:42:56 -0000 1.2
+++ select.php 10 Aug 2002 11:42:39 -0000 1.3
@@ -25,7 +25,7 @@
include("config.php");
/* Connect */ $db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
- mysql_select_db("mesh", $db)
+ mysql_select_db($MYSQLDB, $db)
or die(mysql_error($db));
$result = mysql_query("SELECT max(unix_timestamp(updated)) from admin", $db)
or die(mysql_error($db));
Index: submit.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/submit.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- submit.php 10 Aug 2002 10:42:56 -0000 1.2
+++ submit.php 10 Aug 2002 11:42:39 -0000 1.3
@@ -108,7 +108,7 @@
$db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
- mysql_select_db("mesh", $db)
+ mysql_select_db($MYSQLDB, $db)
or die(mysql_error($db));
if (isset($VAR["redirect"]))
Index: touch.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/touch.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- touch.php 10 Aug 2002 10:42:56 -0000 1.2
+++ touch.php 10 Aug 2002 11:42:39 -0000 1.3
@@ -14,7 +14,7 @@
die("invalid nodeid - change the '12345' in the URL to your node's ID!");
$db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
- mysql_select_db("mesh", $db)
+ mysql_select_db($MYSQLDB, $db)
or die(mysql_error($db));
$result = mysql_query("UPDATE admin SET updated = NOW()"
Index: vrml3b.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/vrml3b.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- vrml3b.php 10 Aug 2002 10:42:56 -0000 1.2
+++ vrml3b.php 10 Aug 2002 11:42:39 -0000 1.3
@@ -19,7 +19,7 @@
$s = doubleval($s);
$db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
-mysql_select_db("mesh", $db)
+mysql_select_db($MYSQLDB, $db)
or die(mysql_error($db));
/* Generated the Last-modified header */
|
|
From: <le...@us...> - 2002-08-10 10:43:01
|
Update of /cvsroot/meshdb/www/db2
In directory usw-pr-cvs1:/tmp/cvs-serv10501
Modified Files:
gawd.php index.php info.php lookup.inc.php map2b.php map2d.php
map3b.php map4b.php select.php submit.php touch.php vrml3b.php
config-local.php-dist
Log Message:
add a MYSQLPASS password config var
Index: gawd.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/gawd.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- gawd.php 10 Aug 2002 03:33:24 -0000 1.1.1.1
+++ gawd.php 10 Aug 2002 10:42:56 -0000 1.2
@@ -9,7 +9,7 @@
include("config.php");
include("util.php");
-$db = mysql_connect($MYSQLHOST, $MYSQLUSER);
+$db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
mysql_select_db("mesh", $db)
or die(mysql_error($db));
Index: index.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/index.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- index.php 10 Aug 2002 03:33:55 -0000 1.1.1.1
+++ index.php 10 Aug 2002 10:42:56 -0000 1.2
@@ -9,7 +9,7 @@
$len = intval($_GET["imgsz"]);
if ($len < 50) $len = $DEFAULTLEN;
- $db = mysql_connect($MYSQLHOST, $MYSQLUSER);
+ $db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
mysql_select_db("mesh", $db)
or die(mysql_error($db));
$result = mysql_query("SELECT max(unix_timestamp(updated)) from admin", $db)
Index: info.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/info.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- info.php 10 Aug 2002 03:33:55 -0000 1.1.1.1
+++ info.php 10 Aug 2002 10:42:56 -0000 1.2
@@ -2,7 +2,7 @@
<?
include("config.php");
- $db = mysql_connect($MYSQLHOST, $MYSQLUSER);
+ $db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
mysql_select_db("mesh", $db)
or die(mysql_error($db));
Index: lookup.inc.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/lookup.inc.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- lookup.inc.php 10 Aug 2002 03:33:55 -0000 1.1.1.1
+++ lookup.inc.php 10 Aug 2002 10:42:56 -0000 1.2
@@ -5,7 +5,7 @@
*/
global $PREF;
- $db = mysql_connect($MYSQLHOST, $MYSQLUSER);
+ $db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
mysql_select_db("mesh", $db)
or die(mysql_error($db));
Index: map2b.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/map2b.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- map2b.php 10 Aug 2002 03:33:55 -0000 1.1.1.1
+++ map2b.php 10 Aug 2002 10:42:56 -0000 1.2
@@ -25,7 +25,7 @@
$im = ImageCreateFromPNG("http://box:80/~mesh/db2/map2d.php?w=$w&h=$h&s=$s&e=$e&n=$n");
if (!$im) die("image load failed");
-$db = mysql_connect($MYSQLHOST, $MYSQLUSER);
+$db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
mysql_select_db("mesh", $db)
or die(mysql_error($db));
Index: map2d.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/map2d.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- map2d.php 10 Aug 2002 03:33:55 -0000 1.1.1.1
+++ map2d.php 10 Aug 2002 10:42:56 -0000 1.2
@@ -38,7 +38,7 @@
header("X-scale: $s m/pixel");
header("X-source: $mburl");
-$db = mysql_connect($MYSQLHOST, $MYSQLUSER);
+$db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
mysql_select_db("mesh", $db)
or die(mysql_error($db));
Index: map3b.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/map3b.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- map3b.php 10 Aug 2002 03:33:55 -0000 1.1.1.1
+++ map3b.php 10 Aug 2002 10:42:56 -0000 1.2
@@ -19,7 +19,7 @@
$s = doubleval($s);
$vrml = intval($vrml);
-$db = mysql_connect($MYSQLHOST, $MYSQLUSER);
+$db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
mysql_select_db("mesh", $db)
or die(mysql_error($db));
Index: map4b.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/map4b.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- map4b.php 10 Aug 2002 03:33:55 -0000 1.1.1.1
+++ map4b.php 10 Aug 2002 10:42:56 -0000 1.2
@@ -15,7 +15,7 @@
$h = intval($_GET["h"]);
$s = doubleval($_GET["s"]);
-$db = mysql_connect($MYSQLHOST, $MYSQLUSER);
+$db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
mysql_select_db("mesh", $db)
or die(mysql_error($db));
Index: select.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/select.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- select.php 10 Aug 2002 03:33:55 -0000 1.1.1.1
+++ select.php 10 Aug 2002 10:42:56 -0000 1.2
@@ -24,7 +24,7 @@
include("config.php");
- /* Connect */ $db = mysql_connect($MYSQLHOST, $MYSQLUSER);
+ /* Connect */ $db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
mysql_select_db("mesh", $db)
or die(mysql_error($db));
$result = mysql_query("SELECT max(unix_timestamp(updated)) from admin", $db)
Index: submit.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/submit.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- submit.php 10 Aug 2002 03:33:55 -0000 1.1.1.1
+++ submit.php 10 Aug 2002 10:42:56 -0000 1.2
@@ -107,7 +107,7 @@
}
- $db = mysql_connect($MYSQLHOST, $MYSQLUSER);
+ $db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
mysql_select_db("mesh", $db)
or die(mysql_error($db));
Index: touch.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/touch.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- touch.php 10 Aug 2002 03:33:55 -0000 1.1.1.1
+++ touch.php 10 Aug 2002 10:42:56 -0000 1.2
@@ -13,7 +13,7 @@
if ($nodeid == 12345)
die("invalid nodeid - change the '12345' in the URL to your node's ID!");
- $db = mysql_connect($MYSQLHOST, $MYSQLUSER);
+ $db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
mysql_select_db("mesh", $db)
or die(mysql_error($db));
Index: vrml3b.php
===================================================================
RCS file: /cvsroot/meshdb/www/db2/vrml3b.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- vrml3b.php 10 Aug 2002 03:34:07 -0000 1.1.1.1
+++ vrml3b.php 10 Aug 2002 10:42:56 -0000 1.2
@@ -18,7 +18,7 @@
$h = intval($h);
$s = doubleval($s);
-$db = mysql_connect($MYSQLHOST, $MYSQLUSER);
+$db = mysql_connect($MYSQLHOST, $MYSQLUSER, $MYSQLPASS);
mysql_select_db("mesh", $db)
or die(mysql_error($db));
Index: config-local.php-dist
===================================================================
RCS file: /cvsroot/meshdb/www/db2/config-local.php-dist,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- config-local.php-dist 10 Aug 2002 10:24:39 -0000 1.1
+++ config-local.php-dist 10 Aug 2002 10:42:56 -0000 1.2
@@ -8,11 +8,12 @@
* ========README=====README=====README======README======
*/
- global $MYSQLHOST, $MYSQLUSER, $READONLY, $OURPROXY;
+ global $MYSQLHOST, $MYSQLUSER, $MYSQLPASS, $READONLY, $OURPROXY;
global $ZONE, $SHIFTFILE, $ALTFILE;
$MYSQLHOST = "host"; /* MySQL hostname */
$MYSQLUSER = "user"; /* MySQL username */
+ $MYSQLPASS = "pass"; /* MySQL password */
$READONLY = 0; /* Set to 1 for db maintennance */
$OURPROXY = "proxy"; /* an HTTP proxy host available to us */
|
|
From: <le...@us...> - 2002-08-10 10:24:43
|
Update of /cvsroot/meshdb//www/db2
In directory usw-pr-cvs1:/tmp/cvs-serv5639
Modified Files:
config.php
Added Files:
config-local.php-dist
Log Message:
change to using config-local.php as config file, and do not keep that file in the repository. instead, keep a "dist" file
--- NEW FILE: config-local.php-dist ---
<?
/* $Id: config-local.php-dist,v 1.1 2002/08/10 10:24:39 leonard Exp $ */
/*
* ========README=====README=====README======README======
* THIS FILE SHOULD BE RENAMED config-local.php AND THEN EDITED
* to suit your local setup.
* ========README=====README=====README======README======
*/
global $MYSQLHOST, $MYSQLUSER, $READONLY, $OURPROXY;
global $ZONE, $SHIFTFILE, $ALTFILE;
$MYSQLHOST = "host"; /* MySQL hostname */
$MYSQLUSER = "user"; /* MySQL username */
$READONLY = 0; /* Set to 1 for db maintennance */
$OURPROXY = "proxy"; /* an HTTP proxy host available to us */
$ZONE = 56; /* UTM zone (56 for Brisbane) */
$SHIFTFILE = "lib/QLD_0900.gsb";/* Shift file */
$ALTFILE = "lib/alt.desc"; /* Altitude file */
?>
Index: config.php
===================================================================
RCS file: /cvsroot/meshdb//www/db2/config.php,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -u -d -r1.1.1.1 -r1.2
--- config.php 10 Aug 2002 03:33:24 -0000 1.1.1.1
+++ config.php 10 Aug 2002 10:24:39 -0000 1.2
@@ -1,21 +1,7 @@
<?
+ /* $Id$ */
- global $MYSQLHOST, $MYSQLUSER, $READONLY, $OURPROXY;
- global $ZONE, $SHIFTFILE, $ALTFILE;
-
- /* General config variables */
-
- $MYSQLHOST = "bo";
- $MYSQLUSER = "www";
-
- $READONLY = 0;
-
- $OURPROXY = "proxy"; /* http proxy host available to us */
-
- $ZONE = 56;
- $SHIFTFILE = "lib/QLD_0900.gsb";
- $ALTFILE = "lib/alt.desc";
-
+ include("config-local.php");
include("cookies.inc");
?>
|
|
From: <le...@us...> - 2002-08-10 10:09:51
|
Update of /cvsroot/meshdb/www/deal In directory usw-pr-cvs1:/tmp/cvs-serv1367 Added Files: deal.sql Log Message: An SQL script to create the deal tables --- NEW FILE: deal.sql --- # MySQL dump 8.12 # # Host: bo Database: mesh #-------------------------------------------------------- # Server version 3.23.39-log # # Table structure for table 'rhp' # DROP TABLE IF EXISTS rhp; CREATE TABLE rhp ( id int(11) NOT NULL auto_increment, status tinytext, class tinytext, description mediumtext, descriptionurl mediumtext, donator mediumtext, donatedwhen datetime default NULL, donatorurl mediumtext, user mediumtext, usedwhen datetime default NULL, userurl mediumtext, lostwhen datetime default NULL, comment text, PRIMARY KEY (id) ) TYPE=MyISAM; # # Table structure for table 'vendor' # DROP TABLE IF EXISTS vendor; CREATE TABLE vendor ( id int(11) NOT NULL auto_increment, name tinytext, url mediumtext, PRIMARY KEY (id) ) TYPE=MyISAM; # # Table structure for table 'deal' # DROP TABLE IF EXISTS deal; CREATE TABLE deal ( id int(11) NOT NULL auto_increment, vendorid int(11) default NULL, productid int(11) default NULL, minqty int(11) default NULL, unitprice float default NULL, spotted datetime default NULL, expires datetime default NULL, spotter mediumtext, note mediumtext, keypass varchar(64) default NULL, url mediumtext, PRIMARY KEY (id) ) TYPE=MyISAM; |
|
From: <le...@us...> - 2002-08-10 10:04:22
|
Update of /cvsroot/meshdb/src/geo/dist In directory usw-pr-cvs1:/tmp/cvs-serv32181 Added Files: create.sql Log Message: an SQL create script --- NEW FILE: create.sql --- # MySQL dump 8.12 # # Host: bo Database: mesh #-------------------------------------------------------- # Server version 3.23.39-log # # Table structure for table 'admin' # DROP TABLE IF EXISTS admin; CREATE TABLE admin ( nodeid int(11) NOT NULL auto_increment, nodename tinytext, created datetime default NULL, updated datetime default NULL, url mediumtext NOT NULL, comment text NOT NULL, policy text, status tinytext, mailonupdate tinyint(4) default '0', updatedip tinytext, PRIMARY KEY (nodeid) ) TYPE=MyISAM; # # Table structure for table 'config' # DROP TABLE IF EXISTS config; CREATE TABLE config ( nodeid int(11) NOT NULL default '0', carddesc tinytext, cardurl tinytext, antdesc tinytext, anturl tinytext, imageurl tinytext, estgain double default NULL, protocol tinytext, antspread double default NULL, channel tinyint(4) default NULL, ifname varchar(16) NOT NULL default '', direction double default NULL, PRIMARY KEY (nodeid,ifname) ) TYPE=MyISAM; # # Table structure for table 'contact' # DROP TABLE IF EXISTS contact; CREATE TABLE contact ( nodeid int(11) NOT NULL default '0', contactname tinytext, contactemail tinytext, contactphone tinytext, PRIMARY KEY (nodeid) ) TYPE=MyISAM; # # Table structure for table 'netloc' # DROP TABLE IF EXISTS netloc; CREATE TABLE netloc ( nodeid int(11) NOT NULL default '0', family tinytext, address tinytext, peerid int(11) default NULL, mac mediumtext, ifname varchar(16) NOT NULL default '', active tinyint(4) NOT NULL default '0', comment mediumtext, channel tinyint(4) default NULL, PRIMARY KEY (nodeid,ifname), KEY nodeid (nodeid) ) TYPE=MyISAM; # # Table structure for table 'physaddr' # DROP TABLE IF EXISTS physaddr; CREATE TABLE physaddr ( nodeid int(11) NOT NULL default '0', streetno tinytext, suburb tinytext, state tinytext, country char(2) default NULL, postcode tinytext, imageurl tinytext, PRIMARY KEY (nodeid) ) TYPE=MyISAM; # # Table structure for table 'physloc' # DROP TABLE IF EXISTS physloc; CREATE TABLE physloc ( nodeid int(11) NOT NULL default '0', e double default NULL, n double default NULL, h double default NULL, error double default NULL, PRIMARY KEY (nodeid) ) TYPE=MyISAM; # # Table structure for table 'imgcache' # DROP TABLE IF EXISTS imgcache; CREATE TABLE imgcache ( url varchar(255) NOT NULL default '', img mediumblob, cached datetime default NULL, retreived datetime default NULL, PRIMARY KEY (url) ) TYPE=MyISAM; |
