<feed xmlns='http://www.w3.org/2005/Atom'>
<title>pomf/schema.sql, branch master</title>
<subtitle>[no description]</subtitle>
<link rel='alternate' type='text/html' href='http://repo2.mydevil.net/git/pub/wandystan/pomf/'/>
<entry>
<title>Added instructions and schema to use or migrate to SQLite (#17)</title>
<updated>2016-06-22T05:58:15+00:00</updated>
<author>
<name>akpu1</name>
<email>akpu1@inventati.org</email>
</author>
<published>2016-06-22T05:58:15+00:00</published>
<link rel='alternate' type='text/html' href='http://repo2.mydevil.net/git/pub/wandystan/pomf/commit/?id=424eea4f630d25158ec033a004666ecd0107f8b8'/>
<id>424eea4f630d25158ec033a004666ecd0107f8b8</id>
<content type='text'>
* Added MySQL to SQLite migration instructions; SQLite setup instructions

* Renamed schema.sql to mysql_schema.sql

* Produced modified schema suitable for SQLite

* Added SQLite setup and migration instructions
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
* Added MySQL to SQLite migration instructions; SQLite setup instructions

* Renamed schema.sql to mysql_schema.sql

* Produced modified schema suitable for SQLite

* Added SQLite setup and migration instructions
</pre>
</div>
</content>
</entry>
<entry>
<title>Deprecate file expiration support in Pomf 2.1.0</title>
<updated>2016-05-07T14:16:07+00:00</updated>
<author>
<name>Juuso Lapinlampi</name>
<email>wub@partyvan.eu</email>
</author>
<published>2016-05-07T14:11:03+00:00</published>
<link rel='alternate' type='text/html' href='http://repo2.mydevil.net/git/pub/wandystan/pomf/commit/?id=4fb3a0a9b300ecc896875bd4148a006f7887706e'/>
<id>4fb3a0a9b300ecc896875bd4148a006f7887706e</id>
<content type='text'>
File expiration support has never been properly implemented in Pomf core
or moe panel. It serves as legacy baggage before nekunekus got an idea
to create nokonoko/Uguu for temporary uploads.

In current plans, this non-feature will be removed in the 3.0.0 release
which is the next SemVer major version that allows to remove this.

Reviewed-by: Austin Gillmann &lt;alucard@cuntflaps.me&gt;
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
File expiration support has never been properly implemented in Pomf core
or moe panel. It serves as legacy baggage before nekunekus got an idea
to create nokonoko/Uguu for temporary uploads.

In current plans, this non-feature will be removed in the 3.0.0 release
which is the next SemVer major version that allows to remove this.

Reviewed-by: Austin Gillmann &lt;alucard@cuntflaps.me&gt;
</pre>
</div>
</content>
</entry>
<entry>
<title>Remove moe panel tables from core database schema</title>
<updated>2015-09-20T08:05:52+00:00</updated>
<author>
<name>WubTheCaptain</name>
<email>wub@partyvan.eu</email>
</author>
<published>2015-09-20T07:37:36+00:00</published>
<link rel='alternate' type='text/html' href='http://repo2.mydevil.net/git/pub/wandystan/pomf/commit/?id=0170069575c7b4cc8bb39515c3efc487decbcc4a'/>
<id>0170069575c7b4cc8bb39515c3efc487decbcc4a</id>
<content type='text'>
Accounts, invites and reports are not used in the core. These will be
moved to pomf-moe repository. You don't need it anymore.

While the change of `orginalname` to `originalname` is good to mention,
it is better served in the documentantion for those who are upgrading
instead of laying around useless here in this code repository.

OK pantsucat
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Accounts, invites and reports are not used in the core. These will be
moved to pomf-moe repository. You don't need it anymore.

While the change of `orginalname` to `originalname` is good to mention,
it is better served in the documentantion for those who are upgrading
instead of laying around useless here in this code repository.

OK pantsucat
</pre>
</div>
</content>
</entry>
<entry>
<title>Minor code refactoring and updates</title>
<updated>2015-02-03T20:39:47+00:00</updated>
<author>
<name>cenci0</name>
<email>alchimist94@gmail.com</email>
</author>
<published>2015-02-03T20:39:47+00:00</published>
<link rel='alternate' type='text/html' href='http://repo2.mydevil.net/git/pub/wandystan/pomf/commit/?id=5b77a4eaab418836820b2a0bad7c88f0b88136a0'/>
<id>5b77a4eaab418836820b2a0bad7c88f0b88136a0</id>
<content type='text'>
DATABASE UPDATE: `orginalname` renamed to `originalname` (run update.sql to update `files` table).
Run `update.sql` to update your database, no data will be lost (if you don't update it, pomf won't work properly).

`schema.sql`
- `id`s are now unsigned to double the maximum number of supported indexes
- `size` and `user` columns are unsigned too (we can't have a negative file size or a negative user id)

`static/classes/Response.class.php`
New class to manage responses and errors. Using a class for responses makes the code cleaner and easier to add new response type handlers in the future.
- The response type is declared while a new variable is initialized and the `error` and `send` methods will print a proper output according to it
- The header for the response is also set accordingly to the response type (`text/plain` for `csv`/`gyazo` output, `application/json` for `json` output)

`static/classes/UploadException.class.php`
`Exception` class extension to manage errors that may have occurred while uploading files to the server. This way every error is reported in detail.

`static/includes/settings.inc.php`
- `POMF_URL`: add an option to set the domain of the url to prepend to the newly generated filename (before it was hardcoded and it was `http://a.pomf.se/`) [this option is currently used only when the output is set to `gyazo`]

`upload.php`
- Add functions calls at the beginning to enable the output compression if possible (gzipped output)
- Include new classes
- `generate_name ()`
--- The new name generation algorithm is basically the same of the old one, but it's easier to add/remove characters if needed (eg. lower-case letters isn't enough and you need to add capital-case letters or digits)
--- Check directly the database instead of the filesystem to see if a generated filename is already in use
- `upload_file ()`
--- File errors generate a `UploadException` instead of a normal `Exception`
--- Move common code outside the `if` to avoid useless code repetition (only the query is now inside the condition)
--- Change file permissions of a file after moving it to the new directory (if the user didn't set a mask previouly these files wouldn't be world readable, we make sure they are)
- `diverse_array ()`
--- Function to reorder initial `$_FILES` array (easier to handle for `refiles`)
- `refiles ()`
--- Use a `foreach` cicle instead of a `for` one, easier to understand
- Create a new response object and set its response type (`csv`, `gyazo` or default to `json`)
- Edit response handling according to the new response class
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
DATABASE UPDATE: `orginalname` renamed to `originalname` (run update.sql to update `files` table).
Run `update.sql` to update your database, no data will be lost (if you don't update it, pomf won't work properly).

`schema.sql`
- `id`s are now unsigned to double the maximum number of supported indexes
- `size` and `user` columns are unsigned too (we can't have a negative file size or a negative user id)

`static/classes/Response.class.php`
New class to manage responses and errors. Using a class for responses makes the code cleaner and easier to add new response type handlers in the future.
- The response type is declared while a new variable is initialized and the `error` and `send` methods will print a proper output according to it
- The header for the response is also set accordingly to the response type (`text/plain` for `csv`/`gyazo` output, `application/json` for `json` output)

`static/classes/UploadException.class.php`
`Exception` class extension to manage errors that may have occurred while uploading files to the server. This way every error is reported in detail.

`static/includes/settings.inc.php`
- `POMF_URL`: add an option to set the domain of the url to prepend to the newly generated filename (before it was hardcoded and it was `http://a.pomf.se/`) [this option is currently used only when the output is set to `gyazo`]

`upload.php`
- Add functions calls at the beginning to enable the output compression if possible (gzipped output)
- Include new classes
- `generate_name ()`
--- The new name generation algorithm is basically the same of the old one, but it's easier to add/remove characters if needed (eg. lower-case letters isn't enough and you need to add capital-case letters or digits)
--- Check directly the database instead of the filesystem to see if a generated filename is already in use
- `upload_file ()`
--- File errors generate a `UploadException` instead of a normal `Exception`
--- Move common code outside the `if` to avoid useless code repetition (only the query is now inside the condition)
--- Change file permissions of a file after moving it to the new directory (if the user didn't set a mask previouly these files wouldn't be world readable, we make sure they are)
- `diverse_array ()`
--- Function to reorder initial `$_FILES` array (easier to handle for `refiles`)
- `refiles ()`
--- Use a `foreach` cicle instead of a `for` one, easier to understand
- Create a new response object and set its response type (`csv`, `gyazo` or default to `json`)
- Edit response handling according to the new response class
</pre>
</div>
</content>
</entry>
<entry>
<title>oops should be fine now</title>
<updated>2014-12-14T01:34:01+00:00</updated>
<author>
<name>Eric Johansson (neku)</name>
<email>neku@pomf.se</email>
</author>
<published>2014-12-14T01:34:01+00:00</published>
<link rel='alternate' type='text/html' href='http://repo2.mydevil.net/git/pub/wandystan/pomf/commit/?id=fd01fc8cd534ada91f941c963858bb32e1b378f4'/>
<id>fd01fc8cd534ada91f941c963858bb32e1b378f4</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Create schema.sql</title>
<updated>2014-12-07T18:33:55+00:00</updated>
<author>
<name>Neku</name>
<email>neku@pomf.se</email>
</author>
<published>2014-12-07T18:33:55+00:00</published>
<link rel='alternate' type='text/html' href='http://repo2.mydevil.net/git/pub/wandystan/pomf/commit/?id=88bc3d9cf3e249246375fbea3d841bcf9ea539e9'/>
<id>88bc3d9cf3e249246375fbea3d841bcf9ea539e9</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
</feed>
