From: <wis...@us...> - 2016-01-27 12:32:58
|
Revision: 13197 http://sourceforge.net/p/xoops/svn/13197 Author: wishcraft Date: 2016-01-27 12:32:56 +0000 (Wed, 27 Jan 2016) Log Message: ----------- Fontier+ MySQL Database Schemer - mysql.sql Added Paths: ----------- XoopsModules/fontier+/trunk/modules/fontier/sql/ XoopsModules/fontier+/trunk/modules/fontier/sql/mysql.sql Added: XoopsModules/fontier+/trunk/modules/fontier/sql/mysql.sql =================================================================== --- XoopsModules/fontier+/trunk/modules/fontier/sql/mysql.sql (rev 0) +++ XoopsModules/fontier+/trunk/modules/fontier/sql/mysql.sql 2016-01-27 12:32:56 UTC (rev 13197) @@ -0,0 +1,314 @@ + +CREATE TABLE `fontier_callbacks` ( + `when` int(12) NOT NULL, + `uri` varchar(250) NOT NULL DEFAULT '', + `timeout` int(4) NOT NULL DEFAULT '0', + `connection` int(4) NOT NULL DEFAULT '0', + `data` mediumtext NOT NULL, + `queries` mediumtext NOT NULL, + `fails` int(3) NOT NULL DEFAULT '0', + PRIMARY KEY (`when`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_elements` ( + `id` mediumint(18) NOT NULL AUTO_INCREMENT, + `theme-id` int(11) NOT NULL DEFAULT '0', + `fonting-id` mediumint(20) NOT NULL DEFAULT '0', + `source` enum('theming','html') NOT NULL DEFAULT 'html', + `element-id` mediumint(26) NOT NULL DEFAULT '0', + `important` enum('yes','no') NOT NULL DEFAULT 'yes', + `uid` int(13) NOT NULL DEFAULT '0', + `created` int(12) NOT NULL DEFAULT '0', + `last` int(12) NOT NULL DEFAULT '0', + `deleted` int(12) NOT NULL DEFAULT '0', + `hits` mediumint(32) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_emails` ( + `id` varchar(32) NOT NULL, + `emails` longtext, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_fonting` ( + `id` mediumint(20) NOT NULL, + `mode` enum('nodes','id') NOT NULL DEFAULT 'id', + `nodes-string` tinytext NOT NULL, + `font-ids` tinytext NOT NULL, + `random` enum('yes','no') NOT NULL DEFAULT 'no', + `current-font-id` varchar(32) NOT NULL DEFAULT '', + `last-font-id` varchar(32) NOT NULL DEFAULT '', + `created` int(12) NOT NULL DEFAULT '0', + `change` int(12) NOT NULL DEFAULT '0', + `last` int(12) NOT NULL DEFAULT '0', + `deleted` int(12) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_fonts` ( + `id` varchar(32) NOT NULL DEFAULT '', + `archive_id` mediumint(24) NOT NULL DEFAULT '0', + `peer_id` varchar(32) DEFAULT '', + `names` int(6) DEFAULT '0', + `nodes` int(8) DEFAULT '0', + `created` int(12) DEFAULT '0', + `accessed` int(12) DEFAULT '0', + `cached` int(12) DEFAULT '0', + `failed` int(12) DEFAULT '0', + `failures` mediumint(20) DEFAULT '0', + `downloaded` mediumint(20) DEFAULT '0', + `hits` mediumint(20) DEFAULT '0', + `normal` enum('yes','no') DEFAULT 'no', + `italic` enum('yes','no') DEFAULT 'no', + `bold` enum('yes','no') DEFAULT 'no', + `wide` enum('yes','no') DEFAULT 'no', + `condensed` enum('yes','no') DEFAULT 'no', + `light` enum('yes','no') DEFAULT 'no', + `semi` enum('yes','no') DEFAULT 'no', + `book` enum('yes','no') DEFAULT 'no', + `body` enum('yes','no') DEFAULT 'no', + `header` enum('yes','no') DEFAULT 'no', + `heading` enum('yes','no') DEFAULT 'no', + `footer` enum('yes','no') DEFAULT 'no', + `graphic` enum('yes','no') DEFAULT 'no', + `system` enum('yes','no') DEFAULT 'no', + `quote` enum('yes','no') DEFAULT 'no', + `block` enum('yes','no') DEFAULT 'no', + `message` enum('yes','no') DEFAULT 'no', + `admin` enum('yes','no') DEFAULT 'no', + `logo` enum('yes','no') DEFAULT 'no', + `slogon` enum('yes','no') DEFAULT 'no', + `legal` enum('yes','no') DEFAULT 'no', + `script` enum('yes','no') DEFAULT 'no', + PRIMARY KEY (`id`), + KEY `PINGERING` (`names`,`nodes`,`hits`,`failed`,`failures`,`cached`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_fonts_archiving` ( + `id` mediumint(24) NOT NULL AUTO_INCREMENT, + `font_id` varchar(32) NOT NULL DEFAULT '', + `filename` varchar(255) NOT NULL DEFAULT '', + `path` varchar(255) NOT NULL DEFAULT '', + `repository` varchar(300) NOT NULL DEFAULT '', + `files` int(10) NOT NULL DEFAULT '0', + `bytes` int(18) NOT NULL DEFAULT '0', + `fingerprint` varchar(32) NOT NULL DEFAULT '', + `hits` int(24) NOT NULL DEFAULT '0', + `packing` enum('7z','zip','rar','rar5','zoo','tar.gz','store') NOT NULL DEFAULT 'zip', + PRIMARY KEY (`id`), + KEY `PINGERING` (`font_id`(17),`fingerprint`(14),`id`) +) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_fonts_callbacks` ( + `id` varchar(32) NOT NULL DEFAULT '', + `type` enum('upload','archive','fonthit') NOT NULL DEFAULT 'upload', + `font_id` varchar(32) NOT NULL DEFAULT '', + `archive_id` mediumint(24) NOT NULL DEFAULT '0', + `upload_id` int(18) NOT NULL DEFAULT '0', + `uri` varchar(350) NOT NULL DEFAULT 'http://', + `email` varchar(198) NOT NULL DEFAULT '', + `last` int(13) NOT NULL DEFAULT '0', + `calls` int(20) NOT NULL DEFAULT '0', + `fails` int(20) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`,`font_id`(12),`upload_id`), + KEY `SEARCH` (`font_id`(12),`upload_id`,`uri`(12),`last`,`calls`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_fonts_files` ( + `id` mediumint(24) NOT NULL AUTO_INCREMENT, + `font_id` varchar(32) NOT NULL DEFAULT '', + `archive_id` mediumint(24) NOT NULL DEFAULT '0', + `type` enum('json','diz','pfa','pfb','pt3','t42','sfd','ttf','bdf','otf','otb','cff','cef','gai','woff','svg','ufo','pf3','ttc','gsf','cid','bin','hqx','dfont','mf','ik','fon','fnt','pcf','pmf','pdb','eot','afm','data','css','other') NOT NULL DEFAULT 'other', + `extension` varchar(12) NOT NULL DEFAULT '', + `filename` varchar(128) NOT NULL DEFAULT '', + `path` varchar(255) NOT NULL DEFAULT '', + `bytes` int(12) NOT NULL DEFAULT '0', + `hits` int(20) NOT NULL DEFAULT '0', + `created` int(13) NOT NULL DEFAULT '0', + `accessed` int(13) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`), + KEY `SEARCH` (`font_id`(14),`archive_id`,`type`,`extension`,`filename`(12),`path`,`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_fonts_names` ( + `font_id` varchar(32) DEFAULT '', + `upload_id` int(18) DEFAULT '0', + `name` varchar(64) DEFAULT '', + `longitude` float(12,8) DEFAULT '0.00000000', + `latitude` float(12,8) DEFAULT '0.00000000', + `country` varchar(3) DEFAULT 'USA', + `region` varchar(64) DEFAULT '', + `city` varchar(64) DEFAULT '', + KEY `POINTING` (`upload_id`,`font_id`(14),`name`(12)), + KEY `LOCALITY` (`longitude`,`latitude`,`country`(2),`region`(10),`city`(10),`font_id`(13),`upload_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_html_elements` ( + `id` mediumint(26) NOT NULL AUTO_INCREMENT, + `position` int(14) NOT NULL DEFAULT '0', + `value` varchar(200) NOT NULL DEFAULT '', + PRIMARY KEY (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8; + +INSERT INTO `fontier_html_elements` VALUES (1,1,'a'),(2,2,'abbr'),(3,3,'acronym'),(4,4,'address'),(5,5,'applet'),(6,6,'area'),(7,7,'b'),(8,8,'base'),(9,9,'basefont'),(10,10,'bdo'),(11,11,'big'),(12,12,'blockquote'),(13,13,'body'),(14,14,'br'),(15,15,'button'),(16,16,'caption'),(17,17,'center'),(18,18,'cite'),(19,19,'code'),(20,20,'col'),(21,21,'colgroup'),(22,22,'dd'),(23,23,'del'),(24,24,'dfn'),(25,25,'dir'),(26,26,'div'),(27,27,'dl'),(28,28,'dt'),(29,29,'em'),(30,30,'fieldset'),(31,31,'font'),(32,32,'form'),(33,33,'frame'),(34,34,'frameset'),(35,35,'h1'),(36,36,'h2'),(37,37,'h3'),(38,38,'h4'),(39,39,'h5'),(40,40,'h6'),(41,41,'head'),(42,42,'hr'),(43,43,'html'),(44,44,'i'),(45,45,'iframe'),(46,46,'img'),(47,47,'input'),(48,48,'ins'),(49,49,'isindex'),(50,50,'kbd'),(51,51,'label'),(52,52,'legend'),(53,53,'li'),(54,54,'link'),(55,55,'map'),(56,56,'menu'),(57,57,'meta'),(58,58,'noframes'),(59,59,'noscript'),(60,60,'object'),(61,61,'ol'),(62,62,'optgroup'),(63,63,'option'),(64,64,'p'),(65,65,'param'),(66,66,'pre'),(67,67,'q'),(68,68,'s'),(69,69,'samp'),(70,70,'script'),(71,71,'select'),(72,72,'small'),(73,73,'span'),(74,74,'strike'),(75,75,'strong'),(76,76,'style'),(77,77,'sub'),(78,78,'sup'),(79,79,'table'),(80,80,'tbody'),(81,81,'td'),(82,82,'textarea'),(83,83,'tfoot'),(84,84,'th'),(85,85,'thead'),(86,86,'title'),(87,87,'tr'),(88,88,'tt'),(89,89,'u'),(90,90,'ul'),(91,91,'var'); + + +CREATE TABLE `fontier_networking` ( + `ip_id` varchar(32) NOT NULL DEFAULT '', + `type` enum('ipv4','ipv6') NOT NULL DEFAULT 'ipv4', + `ipaddy` varchar(64) NOT NULL DEFAULT '', + `netbios` varchar(198) NOT NULL DEFAULT '', + `domain` varchar(128) NOT NULL DEFAULT '', + `country` varchar(3) NOT NULL DEFAULT '', + `region` varchar(128) NOT NULL DEFAULT '', + `city` varchar(128) NOT NULL DEFAULT '', + `postcode` varchar(15) NOT NULL DEFAULT '', + `timezone` varchar(10) NOT NULL DEFAULT '', + `longitude` float(12,8) NOT NULL DEFAULT '0.00000000', + `latitude` float(12,8) NOT NULL DEFAULT '0.00000000', + `contributes` int(16) NOT NULL DEFAULT '0', + `downloads` int(16) NOT NULL DEFAULT '0', + `uploads` int(16) NOT NULL DEFAULT '0', + `fonts` int(16) NOT NULL DEFAULT '0', + `surveys` int(16) NOT NULL DEFAULT '0', + `created` int(13) NOT NULL DEFAULT '0', + `last` int(13) NOT NULL DEFAULT '0', + `data` mediumtext, + `whois` varchar(32) DEFAULT NULL, + PRIMARY KEY (`ip_id`,`type`,`ipaddy`(15)), + KEY `SEARCH` (`type`,`ipaddy`(15),`netbios`(12),`domain`(12),`country`(2),`city`(12),`region`(12),`postcode`(6),`longitude`,`latitude`,`created`,`last`,`timezone`(6)) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_nodes` ( + `id` int(23) NOT NULL AUTO_INCREMENT, + `type` enum('typal','fixes','keys') DEFAULT NULL, + `node` varchar(64) DEFAULT '0', + `usage` int(12) DEFAULT '0', + `weight` int(12) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `PINGERING` (`node`(21),`type`,`usage`,`weight`) +) ENGINE=InnoDB AUTO_INCREMENT=388 DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_nodes_linking` ( + `font_id` varchar(32) DEFAULT NULL, + `node_id` int(23) DEFAULT '0', + KEY `PINGERING` (`node_id`,`font_id`(11)) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_theming` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `theme` varchar(45) NOT NULL DEFAULT 'default', + `elements` int(8) NOT NULL DEFAULT '0', + `scanned` int(12) NOT NULL DEFAULT '0', + `created` int(12) NOT NULL, + `last` int(12) NOT NULL DEFAULT '0', + `deleted` int(12) NOT NULL DEFAULT '0', + `hits-admin` mediumint(32) NOT NULL DEFAULT '0', + `hits-user` mediumint(32) NOT NULL DEFAULT '0', + `hits-guest` mediumint(32) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_theming_css` ( + `id` int(18) NOT NULL AUTO_INCREMENT, + `theme-id` int(11) NOT NULL DEFAULT '0', + `path` varchar(200) NOT NULL DEFAULT '', + `file` varchar(200) NOT NULL DEFAULT '', + `classes` int(14) NOT NULL DEFAULT '0', + `identities` int(14) NOT NULL DEFAULT '0', + `elements` int(14) NOT NULL DEFAULT '0', + `scanned` int(12) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_theming_elements` ( + `id` mediumint(26) NOT NULL AUTO_INCREMENT, + `theme-id` int(11) NOT NULL DEFAULT '0', + `theme-css-id` int(18) NOT NULL, + `type` enum('identity','class','element','unknown') NOT NULL DEFAULT 'unknown', + `position` int(14) NOT NULL DEFAULT '0', + `value` varchar(200) NOT NULL DEFAULT '', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_uploads` ( + `id` int(10) NOT NULL AUTO_INCREMENT, + `session` varchar(32) NOT NULL DEFAULT '', + `email` varchar(200) NOT NULL DEFAULT '', + `name` varchar(200) NOT NULL DEFAULT '', + `organisation` varchar(200) NOT NULL DEFAULT '', + `accepted` int(16) NOT NULL DEFAULT '0', + `rejected` int(16) NOT NULL DEFAULT '0', + `responses` int(16) NOT NULL DEFAULT '0', + `uid` int(13) NOT NULL DEFAULT '0', + `created` int(12) NOT NULL DEFAULT '0', + `last` int(12) NOT NULL DEFAULT '0', + `finished` int(12) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_uploads_answers` ( + `id` mediumint(28) NOT NULL AUTO_INCREMENT, + `upload-id` int(10) NOT NULL DEFAULT '0', + `key` varchar(32) NOT NULL DEFAULT '', + `fingerprint` varchar(32) NOT NULL DEFAULT '', + `email` varchar(198) NOT NULL DEFAULT '', + `name` varchar(198) NOT NULL DEFAULT '', + `expires` int(12) NOT NULL DEFAULT '0', + `data` mediumtext NOT NULL, + `created` int(12) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_uploads_files` ( + `id` mediumint(14) NOT NULL AUTO_INCREMENT, + `upload-id` int(10) NOT NULL, + `state` enum('ignored','uploaded') NOT NULL DEFAULT 'ignored', + `file-md5` varchar(32) NOT NULL DEFAULT '', + `filename` varchar(200) NOT NULL DEFAULT '', + `created` int(12) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_uploads_surveys` ( + `id` mediumint(28) NOT NULL AUTO_INCREMENT, + `upload-id` int(10) NOT NULL DEFAULT '0', + `key` varchar(32) NOT NULL DEFAULT '', + `fingerprint` varchar(32) NOT NULL DEFAULT '', + `emails-id` varchar(32) NOT NULL DEFAULT '', + `scope` varchar(200) NOT NULL DEFAULT '', + `expires` int(12) NOT NULL DEFAULT '0', + `subject` varchar(160) NOT NULL DEFAULT '', + `created` int(12) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + +CREATE TABLE `fontier_whois` ( + `id` varchar(32) NOT NULL, + `whois` mediumtext NOT NULL, + `created` int(12) NOT NULL DEFAULT '0', + `last` int(12) NOT NULL DEFAULT '0', + `instances` mediumint(18) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + |
From: <wis...@us...> - 2016-01-27 16:30:38
|
Revision: 13199 http://sourceforge.net/p/xoops/svn/13199 Author: wishcraft Date: 2016-01-27 16:30:35 +0000 (Wed, 27 Jan 2016) Log Message: ----------- Back after a coffee and a break and Elpiniki Iosif got to use ebay.com.au for a bit\! Modified Paths: -------------- XoopsModules/fontier+/trunk/modules/fontier/.htaccess XoopsModules/fontier+/trunk/modules/fontier/header.php XoopsModules/fontier+/trunk/modules/fontier/sql/mysql.sql Modified: XoopsModules/fontier+/trunk/modules/fontier/.htaccess =================================================================== --- XoopsModules/fontier+/trunk/modules/fontier/.htaccess 2016-01-27 12:45:42 UTC (rev 13198) +++ XoopsModules/fontier+/trunk/modules/fontier/.htaccess 2016-01-27 16:30:35 UTC (rev 13199) @@ -1,6 +1,4 @@ php_value memory_limit 360M -php_value upload_max_filesize 999999M -php_value post_max_size 999999M php_value error_reporting 0 php_value display_errors 0 @@ -8,40 +6,19 @@ RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d -RewriteRule ^([a-z0-9]{2})/(.*?)/callback.api$ callback.php?version=$1&mode=$2 [L,NC,QSA] +RewriteRule ^bin/(.*?)/(font).ufo/(.*?)$ $2.php?mode=ufo&clause=$1&path=$3 [L,NC,QSA] +RewriteRule ^bin/(.*?)/(font).(.*?)?(.*?)$ $2.php?mode=$3&clause=$1&$4 [L,NC,QSA] +RewriteRule ^bin/(.*?)/(font).(.*?)$ $2.php?mode=$3&clause=$1 [L,NC,QSA] +RewriteRule ^css/(.*?)/(.*?).(css)?(.*?)$ $3.php?clause=$1&$4 [L,NC,QSA] +RewriteRule ^css/(.*?)/(.*?).(css)$ $3.php?clause=$1 [L,NC,QSA] +RewriteRule ^api/(.*?)/(callback).api?(.*?)$ $2.php?mode=$1&$3 [L,NC,QSA] +RewriteRule ^api/(.*?)/(callback).api$ $2.php?mode=$1 [L,NC,QSA] +RewriteRule ^(download)/([0-9]+)$ $1.php?mode=$1&clause=$2 [L,NC,QSA] +RewriteRule ^([0-9a-z]+)/upload.html$ index.php?mode=upload&clause=$1 [L,NC,QSA] +RewriteRule ^([0-9a-z]+)/surveys.html$ index.php?mode=surveys&clause=$1 [L,NC,QSA] +RewriteRule ^([0-9a-z]+)/survey.html$ index.php?mode=survey&clause=$1 [L,NC,QSA] +RewriteRule ^([0-9a-z]+)/(.*?)/font.html$ index.php?mode=font&clause=$1&name=$2 [L,NC,QSA] +RewriteRule ^([0-9a-z]+)/node.html$ index.php?mode=node&clause=$1 [L,NC,QSA] +RewriteRule ^(keys|fixes|typal)/nodes.html$ index.php?mode=nodes&clause=$1 [L,NC,QSA] +RewriteRule ^index.html$ index.php?mode=index [L,NC,QSA] -RewriteRule ^([a-z0-9]{2})/(font)/(.*?)/(preview)/image.(gif|jpg|png)$ index.php?version=$1&mode=$2&clause=$3&state=$5&output=$4 [L] -RewriteRule ^([a-z0-9]{2})/survey/(preview)/(.*?)/image.(jpg|png|gif)$ survey-$2.php?version=$1&mode=$4&key=$3&output=$2 [L] -RewriteRule ^([a-z0-9]{2})/(font)/(.*?)/(preview)/(gif|jpg|png).api$ index.php?version=$1&mode=$2&clause=$3&state=$5&output=$4 [L] -RewriteRule ^([a-z0-9]{2})/survey/(preview)/(.*?)/(jpg|png|gif).api$ survey-$2.php?version=$1&mode=$4&key=$3&output=$2 [L] -RewriteRule ^([a-z0-9]{2})/(font)/(.*?)/(glyph)/([0-9]+)/image.(gif|jpg|png)$ index.php?version=$1&mode=$2&clause=$3&state=$6&output=$4&char=$5 [L] -RewriteRule ^([a-z0-9]{2})/(font)/(.*?)/(glyph)/([0-9]+)/(gif|jpg|png).api$ index.php?version=$1&mode=$2&clause=$3&state=$6&output=$4&char=$5 [L] -RewriteRule ^([a-z0-9]{2})/(font)/(.*?)/(ufo).api$ index.php?version=$1&mode=$2&clause=$3&output=$4 [L] -RewriteRule ^([a-z0-9]{2})/(font)/(.*?)/(ufo).api/(.*?)$ index.php?version=$1&mode=$2&clause=$3&state=$5&output=$4 [L] -RewriteRule ^([a-z0-9]{2})/(font)/(.*?)/(.*?).api$ index.php?version=$1&mode=$2&clause=$3&state=$5&output=$4 [L] - - -RewriteRule ^([a-z0-9]{2})/survey/page-([0-9]+)/(.*?)/(.*?).api$ survey-page-$2.php?version=$1&mode=$2&key=$3&output=$4& [L] -RewriteRule ^([a-z0-9]{2})/survey/(.*?)/(.*?)/(.*?).api?(.*?)$ survey-$2.php?version=$1&mode=$2&key=$3&output=$4&$5 [L] -RewriteRule ^([a-z0-9]{2})/survey/(.*?)/(.*?)/(.*?).api$ survey-$2.php?version=$1&mode=$2&key=$3&output=$4 [L] -RewriteRule ^([a-z0-9]{2})/survey/(.*?)/(.*?).api$ survey-$2.php?version=$1&key=$2&output=$3& [L] - -RewriteRule ^([a-z0-9]{2})/(.*?)/upload.api$ upload.php?version=$1&field=$2 [L] -RewriteRule ^([a-z0-9]{2})/(.*?)/releases.api$ releases.php?version=$1&field=$2 [L] -RewriteRule ^([a-z0-9]{2})/(uploads|releases)/(.*?)/(.*?).api?(.*?)$ index.php?version=$1&mode=$2&clause=$3&state=&output=$4&$5 [L] -RewriteRule ^([a-z0-9]{2})/(uploads|releases)/(.*?)/(.*?).api$ index.php?version=$1&mode=$2&clause=$3&state=&output=$4 [L] -RewriteRule ^([a-z0-9]{2})/(uploads|releases)/(forms).api$ index.php?version=$1&mode=$2&clause=&state=&output=$3 [L] - -RewriteRule ^([a-z0-9]{2})/(fonts|nodes|random|data|callbacks|downloads)/(.*?)/(.*?)/(.*?)/(.*?).api?(.*?)$ index.php?version=$1&mode=$2&clause=$3&state=$4&output=$5&name=$6&$7 [L] -RewriteRule ^([a-z0-9]{2})/(fonts|nodes|random|data|callbacks|downloads)/(.*?)/(.*?)/(.*?).api?(.*?)$ index.php?version=$1&mode=$2&clause=$3&state=$4&output=$5&$6 [L] -RewriteRule ^([a-z0-9]{2})/(fonts|nodes|random|data|callbacks|downloads|fonthit|archive)/(.*?)/(.*?).api?(.*?)$ index.php?version=$1&mode=$2&clause=$3&state=&output=$4&$5 [L] -RewriteRule ^([a-z0-9]{2})/(fonts|nodes|random|data|callbacks|downloads)/(.*?).api?(.*?)$ index.php?version=$1&mode=$2&clause=&state=&output=$3&$4 [L] - -RewriteRule ^([a-z0-9]{2})/(fonts|nodes|random|data|callbacks|downloads)/(.*?)/(.*?)/(.*?)/(.*?).api$ index.php?version=$1&mode=$2&clause=$3&state=$4&output=$5&name=$6 [L] -RewriteRule ^([a-z0-9]{2})/(fonts|nodes|random|data|callbacks|downloads)/(.*?)/(.*?)/(.*?).api$ index.php?version=$1&mode=$2&clause=$3&state=$4&output=$5 [L] -RewriteRule ^([a-z0-9]{2})/(fonts|nodes|random|data|callbacks|downloads|fonthit|archive)/(.*?)/(.*?).api$ index.php?version=$1&mode=$2&clause=$3&state=&output=$4 [L] -RewriteRule ^([a-z0-9]{2})/(fonts|nodes|random|data|callbacks|downloads)/(.*?).api$ index.php?version=$1&mode=$2&clause=&state=&output=$3& [L] - -RewriteRule ^font-download-example.zip$ examples/sample-font-api2-download.zip [L] -RewriteRule ^callback-example.php$ examples/callback-example.php.txt [L] -RewriteRule ^(.*?).(css|txt|php|jpg|png|gif|ico)$ $1.$2 [L] \ No newline at end of file Modified: XoopsModules/fontier+/trunk/modules/fontier/header.php =================================================================== --- XoopsModules/fontier+/trunk/modules/fontier/header.php 2016-01-27 12:45:42 UTC (rev 13198) +++ XoopsModules/fontier+/trunk/modules/fontier/header.php 2016-01-27 16:30:35 UTC (rev 13199) @@ -1,6 +1,6 @@ <?php /** - * Chronolabs Fonting Repository Services REST API API + * Chronolabs Fonting Repository Services REST FONTIER FONTIER * * You may not change or alter any portion of this comment or credits * of supporting developers from this source code or any supporting source code @@ -14,15 +14,18 @@ * @package fonts * @since 2.1.9 * @author Simon Roberts <wis...@us...> -* @subpackage api -* @description Fonting Repository Services REST API -* @link http://sourceforge.net/projects/chronolabsapis +* @subpackage FONTIER +* @description Fonting Repository Services REST FONTIER +* @link http://sourceforge.net/projects/chronolabsFONTIERs * @link http://cipher.labs.coop */ error_reporting(E_ERROR); ini_set('display_errors', true); + global $source, $ipid, $fontnames, $salter; + $fontnames = array(); + /** * Opens Access Origin Via networking Route NPN */ @@ -35,18 +38,8 @@ ini_set("zlib.output_compression", 'Off'); ini_set("zlib.output_compression_level", -1); - /** - * - * @var constants - */ - define("API_FILE_IO_PEERS", __DIR__ . DIRECTORY_SEPARATOR . 'data' . DIRECTORY_SEPARATOR . 'peers.diz'); - define("API_FILE_IO_DOMAINS", __DIR__ . DIRECTORY_SEPARATOR . 'data' . DIRECTORY_SEPARATOR . 'domains.diz'); - define("API_FILE_IO_FOOTER", __DIR__ . DIRECTORY_SEPARATOR . 'data' . DIRECTORY_SEPARATOR . 'api-%s.html'); + require_once XOOPS_PATH.'/modules/fontier/include/functions.php'; - require_once __DIR__.'/class/fontages.php'; - require_once __DIR__.'/functions.php'; - require_once __DIR__.'/apiconfig.php'; - $parts = explode(".", microtime(true)); mt_srand(mt_rand(-microtime(true), microtime(true))/$parts[1]); mt_srand(mt_rand(-microtime(true), microtime(true))/$parts[1]); @@ -55,33 +48,19 @@ $salter = ((float)(mt_rand(0,1)==1?'':'-').$parts[1].'.'.$parts[0]) / sqrt((float)$parts[1].'.'.intval(cosh($parts[0])))*tanh($parts[1]) * mt_rand(1, intval($parts[0] / $parts[1])); header('Blowfish-salt: '. $salter); - global $domain, $protocol, $business, $entity, $contact, $referee, $peerings, $source, $ipid, $fontnames; - $fontnames = array(); - define('FONTS_CACHE', DIRECTORY_SEPARATOR . 'tmp' . DIRECTORY_SEPARATOR . 'fonts' . DIRECTORY_SEPARATOR . 'cache'); if (!is_dir(FONTS_CACHE)) mkdirSecure(FONTS_CACHE, 0777, true); - /** - * Global API Configurations and Setting from file Constants! - */ - $domain = getDomainSupportism('domain', $_SERVER["HTTP_HOST"]); - $protocol = getDomainSupportism('protocol', $_SERVER["HTTP_HOST"]); - $business = getDomainSupportism('business', $_SERVER["HTTP_HOST"]); - $entity = getDomainSupportism('entity', $_SERVER["HTTP_HOST"]); - $contact = getDomainSupportism('contact', $_SERVER["HTTP_HOST"]); - $referee = getDomainSupportism('referee', $_SERVER["HTTP_HOST"]); - - /** - * URI Path Finding of API URL Source Locality + * URI Path Finding of FONTIER URL Source Locality * @var unknown_type */ $pu = parse_url($_SERVER['REQUEST_URI']); $source = (isset($_SERVER['HTTPS'])?'https://':'http://').strtolower($_SERVER['HTTP_HOST']); /** - * URI Path Finding of API URL Source Locality + * URI Path Finding of FONTIER URL Source Locality * @var unknown_type */ $ipid = getIPIdentity(whitelistGetIP(true)); \ No newline at end of file Modified: XoopsModules/fontier+/trunk/modules/fontier/sql/mysql.sql =================================================================== --- XoopsModules/fontier+/trunk/modules/fontier/sql/mysql.sql 2016-01-27 12:45:42 UTC (rev 13198) +++ XoopsModules/fontier+/trunk/modules/fontier/sql/mysql.sql 2016-01-27 16:30:35 UTC (rev 13199) @@ -122,6 +122,19 @@ ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +CREATE TABLE `fontier_fonts_downloads` ( + `id` mediumint(18) ZEROFILL NOT NULL AUTO_INCREMENT , + `font-id` varchar(32) NOT NULL DEFAULT '', + `type` varchar(20) NOT NULL DEFAULT '', + `file` varchar(200) NOT NULL DEFAULT '', + `url` varchar(300) NOT NULL DEFAULT '', + `created` int(12) NOT NULL DEFAULT '0', + `last` int(12) NOT NULL DEFAULT '0', + `hits` mediumint(32) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + + CREATE TABLE `fontier_fonts_files` ( `id` mediumint(24) NOT NULL AUTO_INCREMENT, `font_id` varchar(32) NOT NULL DEFAULT '', |
From: <wis...@us...> - 2016-01-27 16:50:32
|
Revision: 13200 http://sourceforge.net/p/xoops/svn/13200 Author: wishcraft Date: 2016-01-27 16:50:29 +0000 (Wed, 27 Jan 2016) Log Message: ----------- Back after a coffee and a break and Elpiniki Iosif got to use ebay.com.au for a bit\! Modified Paths: -------------- XoopsModules/fontier+/trunk/modules/fontier/.htaccess XoopsModules/fontier+/trunk/modules/fontier/callback.php XoopsModules/fontier+/trunk/modules/fontier/header.php XoopsModules/fontier+/trunk/modules/fontier/language/english/style.css Modified: XoopsModules/fontier+/trunk/modules/fontier/.htaccess =================================================================== --- XoopsModules/fontier+/trunk/modules/fontier/.htaccess 2016-01-27 16:30:35 UTC (rev 13199) +++ XoopsModules/fontier+/trunk/modules/fontier/.htaccess 2016-01-27 16:50:29 UTC (rev 13200) @@ -1,3 +1,26 @@ +############################################################################################################################ +# +# Chronolabs Cooperative Fontier+ +# +# You may not change or alter any portion of this comment or credits +# of supporting developers from this source code or any supporting source code +# which is considered copyrighted (c) material of the original comment or credit authors. +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. +# +# @copyright Chronolabs Cooperative http://labs.coop +# @license General Public License version 3 (http://labs.coop/briefs/legal/general-public-licence/13,3.html) +# @package fontier+ +# @since 1.0.1 +# @author Simon Roberts <wis...@us...> +# @subpackage fontier+ +# @description XOOPS Client for Fonts REST API - http://fonts.labs.coop +# @link http://fonts.labs.coop +# @link http://sourceforge.net/projects/chronolabs +# @link http://cipher.labs.coop +# +############################################################################################################################ php_value memory_limit 360M php_value error_reporting 0 php_value display_errors 0 Modified: XoopsModules/fontier+/trunk/modules/fontier/callback.php =================================================================== --- XoopsModules/fontier+/trunk/modules/fontier/callback.php 2016-01-27 16:30:35 UTC (rev 13199) +++ XoopsModules/fontier+/trunk/modules/fontier/callback.php 2016-01-27 16:50:29 UTC (rev 13200) @@ -1,6 +1,6 @@ <?php /** - * Chronolabs Entitiesing Repository Services REST API API + * Chronolabs Cooperative Fontier+ * * You may not change or alter any portion of this comment or credits * of supporting developers from this source code or any supporting source code @@ -11,12 +11,13 @@ * * @copyright Chronolabs Cooperative http://labs.coop * @license General Public License version 3 (http://labs.coop/briefs/legal/general-public-licence/13,3.html) - * @package entities - * @since 2.1.9 + * @package fontier+ + * @since 1.0.1 * @author Simon Roberts <wis...@us...> - * @subpackage api - * @description Entitiesing Repository Services REST API - * @link http://sourceforge.net/projects/chronolabsapis + * @subpackage fontier+ + * @description XOOPS Client for Fonts REST API - http://fonts.labs.coop + * @link http://fonts.labs.coop + * @link http://sourceforge.net/projects/chronolabs * @link http://cipher.labs.coop */ Modified: XoopsModules/fontier+/trunk/modules/fontier/header.php =================================================================== --- XoopsModules/fontier+/trunk/modules/fontier/header.php 2016-01-27 16:30:35 UTC (rev 13199) +++ XoopsModules/fontier+/trunk/modules/fontier/header.php 2016-01-27 16:50:29 UTC (rev 13200) @@ -1,24 +1,25 @@ <?php /** - * Chronolabs Fonting Repository Services REST FONTIER FONTIER -* -* You may not change or alter any portion of this comment or credits -* of supporting developers from this source code or any supporting source code -* which is considered copyrighted (c) material of the original comment or credit authors. -* This program is distributed in the hope that it will be useful, -* but WITHOUT ANY WARRANTY; without even the implied warranty of -* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. -* -* @copyright Chronolabs Cooperative http://labs.coop -* @license General Public License version 3 (http://labs.coop/briefs/legal/general-public-licence/13,3.html) -* @package fonts -* @since 2.1.9 -* @author Simon Roberts <wis...@us...> -* @subpackage FONTIER -* @description Fonting Repository Services REST FONTIER -* @link http://sourceforge.net/projects/chronolabsFONTIERs -* @link http://cipher.labs.coop -*/ + * Chronolabs Cooperative Fontier+ + * + * You may not change or alter any portion of this comment or credits + * of supporting developers from this source code or any supporting source code + * which is considered copyrighted (c) material of the original comment or credit authors. + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. + * + * @copyright Chronolabs Cooperative http://labs.coop + * @license General Public License version 3 (http://labs.coop/briefs/legal/general-public-licence/13,3.html) + * @package fontier+ + * @since 1.0.1 + * @author Simon Roberts <wis...@us...> + * @subpackage fontier+ + * @description XOOPS Client for Fonts REST API - http://fonts.labs.coop + * @link http://fonts.labs.coop + * @link http://sourceforge.net/projects/chronolabs + * @link http://cipher.labs.coop + */ error_reporting(E_ERROR); ini_set('display_errors', true); Modified: XoopsModules/fontier+/trunk/modules/fontier/language/english/style.css =================================================================== --- XoopsModules/fontier+/trunk/modules/fontier/language/english/style.css 2016-01-27 16:30:35 UTC (rev 13199) +++ XoopsModules/fontier+/trunk/modules/fontier/language/english/style.css 2016-01-27 16:50:29 UTC (rev 13200) @@ -8,11 +8,6 @@ @import url(https://fonts.ringwould.com.au/v1/random/any/Api-Main/css.api); @import url(https://fonts.ringwould.com.au/v1/random/courier-terminal-shell-system/Api-Code-Examples/css.api); -body { - font-family: "Api Content", "Trebuchet MS", Arial, Helvetica, sans-serif; - font-size:85%em; - text-align:justify; -} .main { font-family: "Api Main" !important; border:3px solid #000000; |
From: <wis...@us...> - 2016-01-27 16:50:50
|
Revision: 13201 http://sourceforge.net/p/xoops/svn/13201 Author: wishcraft Date: 2016-01-27 16:50:48 +0000 (Wed, 27 Jan 2016) Log Message: ----------- Back after a coffee and a break and Elpiniki Iosif got to use ebay.com.au for a bit\! Added Paths: ----------- XoopsModules/fontier+/trunk/modules/fontier/admin/.htaccess XoopsModules/fontier+/trunk/modules/fontier/language/english/admin.php XoopsModules/fontier+/trunk/modules/fontier/language/english/mail_template/ XoopsModules/fontier+/trunk/modules/fontier/language/english/main.php XoopsModules/fontier+/trunk/modules/fontier/language/english/modinfo.php Added: XoopsModules/fontier+/trunk/modules/fontier/admin/.htaccess =================================================================== --- XoopsModules/fontier+/trunk/modules/fontier/admin/.htaccess (rev 0) +++ XoopsModules/fontier+/trunk/modules/fontier/admin/.htaccess 2016-01-27 16:50:48 UTC (rev 13201) @@ -0,0 +1,38 @@ +############################################################################################################################ +# +# Chronolabs Cooperative Fontier+ +# +# You may not change or alter any portion of this comment or credits +# of supporting developers from this source code or any supporting source code +# which is considered copyrighted (c) material of the original comment or credit authors. +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. +# +# @copyright Chronolabs Cooperative http://labs.coop +# @license General Public License version 3 (http://labs.coop/briefs/legal/general-public-licence/13,3.html) +# @package fontier+ +# @since 1.0.1 +# @author Simon Roberts <wis...@us...> +# @subpackage fontier+ +# @description XOOPS Client for Fonts REST API - http://fonts.labs.coop +# @link http://fonts.labs.coop +# @link http://sourceforge.net/projects/chronolabs +# @link http://cipher.labs.coop +# +############################################################################################################################ +php_value memory_limit 360M +php_value error_reporting 0 +php_value display_errors 0 + +RewriteEngine On +RewriteCond %{REQUEST_FILENAME} !-f +RewriteCond %{REQUEST_FILENAME} !-d + +RewriteRule ^([0-9a-z]+)/upload.html$ admin.php?op=upload&clause=$1 [L,NC,QSA] +RewriteRule ^([0-9a-z]+)/surveys.html$ admin.php?op=surveys&clause=$1 [L,NC,QSA] +RewriteRule ^([0-9a-z]+)/survey.html$ admin.php?op=survey&clause=$1 [L,NC,QSA] +RewriteRule ^([0-9a-z]+)/(.*?)/font.html$ admin.php?op=font&clause=$1&name=$2 [L,NC,QSA] +RewriteRule ^([0-9a-z]+)/node.html$ admin.php?op=node&clause=$1 [L,NC,QSA] +RewriteRule ^(keys|fixes|typal)/nodes.html$ admin.php?op=nodes&clause=$1 [L,NC,QSA] + Property changes on: XoopsModules/fontier+/trunk/modules/fontier/admin/.htaccess ___________________________________________________________________ Added: svn:executable ## -0,0 +1 ## +* \ No newline at end of property Added: XoopsModules/fontier+/trunk/modules/fontier/language/english/admin.php =================================================================== --- XoopsModules/fontier+/trunk/modules/fontier/language/english/admin.php (rev 0) +++ XoopsModules/fontier+/trunk/modules/fontier/language/english/admin.php 2016-01-27 16:50:48 UTC (rev 13201) @@ -0,0 +1,22 @@ +<?php +/** + * Chronolabs Cooperative Fontier+ + * + * You may not change or alter any portion of this comment or credits + * of supporting developers from this source code or any supporting source code + * which is considered copyrighted (c) material of the original comment or credit authors. + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. + * + * @copyright Chronolabs Cooperative http://labs.coop + * @license General Public License version 3 (http://labs.coop/briefs/legal/general-public-licence/13,3.html) + * @package fontier+ + * @since 1.0.1 + * @author Simon Roberts <wis...@us...> + * @subpackage fontier+ + * @description XOOPS Client for Fonts REST API - http://fonts.labs.coop + * @link http://fonts.labs.coop + * @link http://sourceforge.net/projects/chronolabs + * @link http://cipher.labs.coop + */ Added: XoopsModules/fontier+/trunk/modules/fontier/language/english/main.php =================================================================== --- XoopsModules/fontier+/trunk/modules/fontier/language/english/main.php (rev 0) +++ XoopsModules/fontier+/trunk/modules/fontier/language/english/main.php 2016-01-27 16:50:48 UTC (rev 13201) @@ -0,0 +1,22 @@ +<?php +/** + * Chronolabs Cooperatiev Fontier+ + * + * You may not change or alter any portion of this comment or credits + * of supporting developers from this source code or any supporting source code + * which is considered copyrighted (c) material of the original comment or credit authors. + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. + * + * @copyright Chronolabs Cooperative http://labs.coop + * @license General Public License version 3 (http://labs.coop/briefs/legal/general-public-licence/13,3.html) + * @package fontier+ + * @since 1.0.1 + * @author Simon Roberts <wis...@us...> + * @subpackage fontier+ + * @description XOOPS Client for Fonts REST API - http://fonts.labs.coop + * @link http://fonts.labs.coop + * @link http://sourceforge.net/projects/chronolabs + * @link http://cipher.labs.coop + */ Added: XoopsModules/fontier+/trunk/modules/fontier/language/english/modinfo.php =================================================================== --- XoopsModules/fontier+/trunk/modules/fontier/language/english/modinfo.php (rev 0) +++ XoopsModules/fontier+/trunk/modules/fontier/language/english/modinfo.php 2016-01-27 16:50:48 UTC (rev 13201) @@ -0,0 +1,22 @@ +<?php +/** + * Chronolabs Cooperative Fontier+ + * + * You may not change or alter any portion of this comment or credits + * of supporting developers from this source code or any supporting source code + * which is considered copyrighted (c) material of the original comment or credit authors. + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. + * + * @copyright Chronolabs Cooperative http://labs.coop + * @license General Public License version 3 (http://labs.coop/briefs/legal/general-public-licence/13,3.html) + * @package fontier+ + * @since 1.0.1 + * @author Simon Roberts <wis...@us...> + * @subpackage fontier+ + * @description XOOPS Client for Fonts REST API - http://fonts.labs.coop + * @link http://fonts.labs.coop + * @link http://sourceforge.net/projects/chronolabs + * @link http://cipher.labs.coop + */ |