[Peepagg-cvs] PA SVN Commit r62 - in trunk: docs publicroot schema

[<sv...@2n...>]

Author: crschmidt
Date: 2004-04-06 13:35:28 -0700 (Tue, 06 Apr 2004)
New Revision: 62

Modified:
   trunk/docs/INSTALL
   trunk/publicroot/.htaccess
   trunk/schema/rdf_database.sql
Log:
Updating .htaccess to set allow_furl_open, for getimagesize() and other=20
similar functions. Turning it on globally is considered a security risk=20
for some things, (namely because then people could do evil things with=20
your machine) but we know the code we're doing will be good and not=20
evil.



Modified: trunk/docs/INSTALL
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- trunk/docs/INSTALL	2004-04-06 16:08:54 UTC (rev 61)
+++ trunk/docs/INSTALL	2004-04-06 20:35:28 UTC (rev 62)
@@ -15,6 +15,9 @@
 This allows PA to use its .htaccess file to rewrite URLs, as well as ena=
bling=20
 blocking of a variety of rude or broken spiders.
=20
+This also allows the .htaccess to turn on allow_furl_open. This is neede=
d in=20
+order to fetch images in some case - for example, in the getimagesize fu=
nction.
+
 This section is most likely incomplete.
=20
 PeopleAggregator Installation:

Modified: trunk/publicroot/.htaccess
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- trunk/publicroot/.htaccess	2004-04-06 16:08:54 UTC (rev 61)
+++ trunk/publicroot/.htaccess	2004-04-06 20:35:28 UTC (rev 62)
@@ -1,3 +1,5 @@
+php_flag allow_url_fopen 1
+
 RewriteEngine on
 RewriteCond %{HTTP_HOST} ^www\.peopleaggregator\.com$ [NC]
 RewriteRule ^(.*)$ http://peopleaggregator.com/$1 [R=3D301,L]

Modified: trunk/schema/rdf_database.sql
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- trunk/schema/rdf_database.sql	2004-04-06 16:08:54 UTC (rev 61)
+++ trunk/schema/rdf_database.sql	2004-04-06 20:35:28 UTC (rev 62)
@@ -4,9 +4,8 @@
    baseURI varchar(255) DEFAULT '',
    primary key (modelID)
 );
-     =20
 CREATE UNIQUE INDEX m_modURI_idx ON models (modelURI);
-                          =20
+
 CREATE TABLE statements (
    modelID bigint NOT NULL,
    subject varchar(255) NOT NULL,
@@ -18,7 +17,7 @@
    object_is varchar(1) NOT NULL,
    FULLTEXT(object)
 );
-  =20
+
 CREATE INDEX s_mod_idx ON statements (modelID);
 CREATE INDEX s_sub_pred_idx ON statements (subject(200),predicate(200));
 CREATE INDEX s_obj_idx ON statements (object(250));
@@ -33,6 +32,6 @@
 );
=20
 CREATE TABLE ban_regex (
-   id bigint NOT NULL AUTO_INCREMENT,
+   id bigint NOT NULL AUTO_INCREMENT PRIMARY KEY,
    regex text NOT NULL
 );