paFileDB Exteme Edition Development blog

Hey,

PHPArena just released a NEW paFileDB (3.6) and extreme edition isn`t made for that so i`m putting it on hold again!! history seems to be repeating because the forst Extreme Edition that i made was also putted on hold because 3.5 came out.

paFileDB 3.6 is a good new version which includes almost all the changes that i wanted to make for Extreme Edition so there is basically no point in continuing with Extreme Edition anymore.. i can make some mods for it like thumbnailing, better search and design improvements but that`s not enough to call it Extreme Edition.. o well.. i will just wait and see how i continue with this..

for now Extreme Edition is

ON HOLD UNTIL FURTHER NOTICE

Thanx for your time so far anyway.

EDIT:://
Countdowns thrown away
do i need to say more? i just removed them.

Hey,

yesterday i released a patch for sec_notify.php and today i found ANOTHER mistake in sec_notify.php... this one isn`t really a big problem.. it just causes one more query to be used when it shouldn`t be used and it`s making a array when it doensn`t need to do that.. thiese bugs are minor and just cause some more pageload.. nothing that i consider risky.. so i won`t release a patch for this one becuase it is fixed in beta 2 anyway.

Another bug i`ve just fixed is the inheritance bug.. for example:
User 1 ads the category Test with ID 1
User 2 ads a sub category in the main category Test.. (the sub category now has id 2 and parent 1)

In this user that made the main category won`t get the rights to the sub category.. now those permissions are inherited so that anyone that has the main category in his permission list will also get the permissions for the sub categories of that main category. this is only in effect when adding category`s!! when you give permissions to a user you need to select ALL the categories that you want him to have permissions in.. if he doesn`t have the permission to a certain category it won`t be inherited!!

One problem with this is this:
User 1 ads a main category
User 2 also ads another main category (so both category`s don`t have a parent)

In this case user 1 won`t get permissions to the category that user 2 made and user 2 won`t have the permissions in the category that user 1 made.. now this could be seen as a advantage, but also as a disadvantage... and i find it hard to solve this problem.. i think i gonna add another permission entry with the name: "This user gets permissions on all category`s" and that permission will overwrite the Add/Edit/Delete category permissions to "Full Control" over all category`s. and that`s the last "big" bug in extreme edition.. the rest is just finishing unfinished stuff.

Now for a new feature..
in the original pafiledb i always missed the option that you couldn`t say how long you wanted to stay logged in.. i`ve added that option in the admin login screen.. you can now choose between the following times:

- 1 Hour
- 2 Hours
- 4 Hours
- 8 Hours
- 1 Day
- 1 Week
- 2 Weeks
- 1 Month (actually the double value of 2 weeks... so it`s well over 1 month)

and "1 Day" is selected by default. in beta 1 of Extreme Edition the default time is 1 Hour.

the progress towards beta 2 is going good..
till next blog.

Hey,

i was completely rewriting the category stuff and i didn`t do it for nothing.. at least it looks like that

the Extreme Edition main page of beta 1 was taking 7 queries. and everything else (when not logged in) was taking 7 queries
the Extreme Edition main page of beta 2 is only taking 4 queries!! the category view is taking 5 and the rest is also taking 4 queries. i think this is a major (speed) improvement. note that this is WITH 2 top 5 lists which both take 1 query. the lowesrt query number you can possibly get on extreme edition is 2 because it needs to fetch the pafiledb settings table and the extreme edition settings table. (i might give that a change in the 1.x.0 versions)

Furthermore i`ve greatly enhanced the speeds of category caching stuff in some tests that i did some parts are about 6 times faster now than they where before.. though this is mostly thanx to the ban on the global function (i don`t use it anymore which is a good thing)

now for the bad news.
beta 2 was meant to be the release that had the user registration stuff in it, had the invalid action! bug fixed and had a complete category backup system which would make a backup once a week and send it to the admins e-mail (only the admin that installed pafiledb exed). i`ve put in so much time in the category rewrite that i simply didn`t even touched the other issues.. i`m gonna start with them now i think since the category stuff is done.

other bad news is the host that is/was sponsoring me.. the host didn`t gave up on me but he sure as hell isn`t friendly with my subdomain ... becuase it`s offline now for a few days!!! if this continues for the next few days i will just quit that host and probably ask Ala (a person that`s on extreme edition for almost the beginning since i started with it) to host Extreme Edition bacause his site is online for quite some time now

As a result of that subdomain being offline you will get a verry big error message on your site starting with this:
Warning: fopen() [function.fopen]: php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/redsaiya/public_html/includes/exed/xml2array.php on line 87

i could have prevented this from happening by first checking if that url is really existing.. and as long as that darn subdomain isn`t online i can`t send a update message to anyone..

and as if this wasn`t enough.. i will also delay the release for beta 2 to the release dat that you see on this site for beta 3. and i might pass beta 3.

o well.. i will keep you guys posted.

Hey,

that categories where a pain in the ass is a known fact but that i could improve it was something i wasn`t sure about.. now i am. At this moment i am actually rewriting the complete category and sub category stuff. and this will also save!! more queries.

What have i done so far in this?
well.. the dropdown was already fetched in the original pafiledb and that has been manipulated alot by Andrew to make a unlimited sub category mod. now i`ve splitted the dropdown stuff and category stuff. the category stuff is now a edited full array from the pafiledb_cat table with some extra calculations in it. this is than stored in the pafiledb_settings table in the column: "modified_category_results". from there is`s using loops.. and alot of them.

remaking the dropdown was annoying and took me the most time.. than after doing that i remade the title and navbar code (that where plain ugly) and they are now also working in a new way. all that`s left to do now is showing the category`s from the modified_category_results column instead of fetching them.

the only disadvantage i can think of is the sorting stuff.. now it`s hard to make a Ascending/Descending sorting for the category`s so i`m not quite sure if i will use my way for the category showing or keep using the original way.. the difference in queries is 1. (1 less with mine)

the thing i don`t like in this is that NOT ONE PERSON will see the difference between beta 1 (old way) and beta 2 (new way)... but the coding that`s behind it really makes it alot easyer to mod parts without having to rewrite serveral files and it is (or atleast should be) faster than the default beta 1 way.

all this stuff also meant that the "Recount Category" need to be used more when you think something is displayed wrong... but it`s done automatically when you add or edit anything that is category related.

o well.. that`s it so far..
till next time.

Hey,

beta 1 has been released for serveral days now and i`m getting some feedback from it aswell.. not from many persons but i do get alot from the persons that do send me feedback.

As of now there are serveral bugs that are known to be in beta 1:

• sec_notify.php has some bugs. Status: fixed for beta 2
• "Invalid Action!" happens to ofter for admins. Status: new admin login is in the making
• Permalink mod seems to have some issues. Status: not changed yet
• When a admin adds a thread other admins should have permissions in that thread. Status: not changed yet
• Top 5 ratings aren`t ratings at all. Status: i knew that before i released it.. not changed yet
• All the top 5`s should have truncated text and changeable dates. Status: not changed yet
• the sorting stuff isn`t working nicely.. it`s working but not how i want it
• If a mod is off in the admin panel it should be OFF and not still working

That`s about it for the bugs so far.

Now for some of the new features that i will be working on as soon as the bugs are killed

• New default theme. old theme will at least be supported till the 1.0.0 final
• User Registration (huge mod and very hard to do.. it`s a real challenge for me)
• Way more cleaner admin panel in coding and look (i`m just having a hard time with the div and css hell)
• Database backup script
• and ofcause bug and improvement fixed.

so.. it seems that i have a load of work to do in something like 8 or 9 days..
beta 2 might be a little delayed.

That`s it for now
cya next blog.

===========================================================
paFileDB Extreme Edition 1.0.0 Beta 1 - Changelog

Date: 29-12-2006
User: Mark aka markg85
Mail: markg852@hotmail.com
===========================================================


[ADD] = Added
[UPD] = Updated


Gread new features

Comments X
-------------

Comments X allows users to make comments on certain files.
Admins can delete those comments if they want to or they
can choose to "hide" a comment meaning that normal users
won`t be bothered with spam comments. Admins will see the
hidden comments.


Thumbnailing X
----------------

Thumbnailing X is a mod that took the most work of all up
till this moment. With this mod you can make thumbnails of
large files and thus reducing the bandwidth to your site
that could be caused by oversized images. (or you can use
plain text links) This mod will also be used to expand
paFileDB Extreme Edition some more with thumbnails for
category`s or other user chosen things.


Filesize X
-------------

Filesize X wasn`t a verry hard mod to do in time and lines
but it did gave alot of problems, mainly because not all
hosts are supporting the fopen things to get the filesize
and the same goos for curl, so fsockopen is used now
although some people could still have the problem that the
filesize isn`t popping up. if they want it they will need
to switch hosts.


Advanced rights
-----------------

on paFileDB you can choose 3 things: Admin, Super admin or mod.
With Extreme Edition you can give a member the right to for
example make a new file in just one category. more is possible
with this but that`s up to you to find out.


Notifications
---------------

Perhaps one of the most functional mods in Extreme Edition
are the notifications that i (the creator of this stuff) can
control with a XML file. for example: when a security hole is
found i enter all that information in a new notification and
Extreme Edition users will be notified of the new bug within
seven days or faster when you click the fetch link. one the new
information has been collected and it found a bug that you still
have it will mail you with that information and how to fix it on
your mail (that you supplied during the installation). and the
mail will be send to all persons in hte admin table (so mods,
super admins and admins). This feature is still a testing feature
to see if users like it. the notifications will be skinned for
beta 2 and some options can be edited in beta 2.


Permenent Links
----------------

This feature got requested to make pafiledb more google
(or just any search engine) friendly. i`ve included the
permanent links in the Top 5 things and in the file details.
normal links are still done in php coding.


Top 5`s
---------

There is a mod for paFileDB to get the Top 5 uploads or downloads
but i didn`t liked the style of that mod so i made my own version.
With this mod you can display the top 5 (or any other number)
downloads, uploaded and highes rated files. you can also change
a few options of it in the admin panel.


Extreme Edition part in Admin Panel
-------------------------------------

This is a part that is also still in testing. all that`s fully
working in that part is the enable/disable part for all mods.
the seperate settings for each mod aren`t fully done yet.
This will be greadly expanded for beta 2.


Other enhancements.
---------------------
The search in Extreme Edition has been greadly expanded in order
to allow a quick search through a large database. in my timing the
new search is about 10 times faster than the default search that
comes with paFileDB.

I also greadly improved the mysql.php class (no not mysqli.php!!
that will come in beta 2) so that more things can be done is as
little queries as possible. The new search is taking the most
use out of the mysql improvements.

And countless things changed under the hood.




[ADD] Error documents through .htaccess
[ADD] Thumbnailing X
[ADD] Comments X
[ADD] New File indicator
[ADD] Extreme Edition admin section
[ADD] Top 5 uploads, downloads and ratings
[ADD] Permanent links
[ADD] Notifications
[ADD] Filesize X
[ADD] Advanced Rights
[ADD] Downtime mod (indicates how long it takes to download a file)
[ADD] Waiting screen before the download starts
[ADD] Added some php 5 checks and use php 5 coding if found


[UPD] Search
[UPD] MySQL talk
[UPD] Cookies

i probly forget some so i will just wait a while and look over it again to make sure i don`t forget things
till next blog.

Hey all. i would first like to wish every reader here a Merry Christmas!! don`t eat to much and i have a small present for everyone. i`ve just completed the first part of the database backup system.. this part is just a script that grabs tons of mysql info and makes a table dump. it doesn`t make the data dump yet (so that are all the entries you made in pafiledb) but i`m gonna try to finish the data dump part as soon as possible. in the code below it`s extending the pafiledb sql class but you can remove the "extends padb_mysql" because it just needs the database connection.. nothing more of the class. so as long as you have a db connection you don`t need the extends part. here is the code so far.

<?php
    /*=================================================================
    |                      MySQL Backup DB 1.0                        |
    +-----------------------------------------------------------------+
    |     Backup DB is a php script that is used to make database     |
    |     backups. With this script you can not only make a dump of   |
    |     the table structure but also a complete dump of the entire  |
    |     entire database.                                            |
    |                                                                 |
    |                                                                 |
    |     Creator  : Mark also known as markg85                       |
    |     E-Mail   : markg852@hotmail.com                             |
    |     Licence  : GPL V2                                           |
    |     Version  : 1.0                                              |
    |                                                                 |
    =================================================================*/
    require ('../db/mysql.php');
    
    class backupdb extends padb_mysql
    {
        // Public Vars
        var $show_charset   =       'no';       // useless at this moment
        var $do_table       =       '*.*';      // useless at this moment
        
        // Private Vars
        var $types = array(MYSQL_ASSOC, MYSQL_NUM, MYSQL_BOTH);
        var $engines;
        var $auto_increment;
        
        // Constructor
        function structure_dbbackup()
        {
            $table_names = $this->fetch_all(mysql_list_tables($this->dbname));
            $this->engines = array();
            $structure = '';
            $table_status_array = $this->fetch_all(mysql_query("show table status from pafiledb353"));
            
            foreach ($table_status_array as $table_status)
            {
                $this->engines[$table_status['Name']] = $table_status['Engine'];
                $this->auto_increment[$table_status['Name']] = $table_status['Auto_increment'];
                //echo $table_status['Engine'] . '<br>';
            }
            
            foreach ($table_names as $table_array)
            {
                foreach ($table_array as $table)
                {
                    $structure .= '-- ' . str_repeat('-', 80) . '<br>';
                    $structure .= '-- ' . $table . '<br>';
                    $structure .= '-- ' . str_repeat('-', 80) . '<br><br>';
                    $structure .= 'CREATE TABLE IF NOT EXISTS `' . $table . '`<br>(<br>';
                    $index_query = mysql_query("SHOW INDEX FROM " . $table . " FROM pafiledb353");
                    $index_array = $this->fetch_all($index_query);
                    $num_rows = mysql_num_rows($index_query);
                    $columns_array = $this->fetch_all(mysql_query("SHOW COLUMNS FROM " . $table . ""));
                    $num_fields = mysql_num_fields(mysql_query("SELECT * FROM " . $table . ""));
                    
                    foreach ($columns_array as $key => $column)
                    {
                        $structure .= str_repeat('&nbsp;', 4) . '`' . $column['Field'] . '` ' . $column['Type'];
                        if (empty($column['Extra']))
                        {
                            if (!preg_match('/text/i', $column['Type']))
                            {
                                $structure .= (trim($column['Default']) == '') ? '' : ' DEFAULT \'' . $column['Default'] . '\'';
                            }
                        }
                        $structure .= ($column['Null'] == 'NO') ? ' NOT NULL' : ' NULL';
                        $structure .= (!empty($column['Extra'])) ? ' ' . strtoupper($column['Extra']) : '';
                        $structure .= ($num_fields -1 == $key AND $num_rows == 0) ? '<br>' : ',<br>';

                    }
                    
                    foreach ($index_array as $key => $index)
                    {
                        if ($index['Non_unique'] == 0 and $index['Index_type'] == 'BTREE')
                        {
                            $structure .= str_repeat('&nbsp;', 4) . 'PRIMARY KEY (`' . $index['Column_name'] . '`)';
                        }
                        if ($index['Non_unique'] == 1 and $index['Index_type'] == 'BTREE')
                        {
                            $structure .= str_repeat('&nbsp;', 4) . 'KEY `' . $index['Key_name'] . '` (`' . $index['Column_name'] . '`)';
                        }
                        
                        $structure .= ($key == $num_rows - 1) ? '<br>' : ',<br>';
                    }
                    $structure .= ') ';
                    $structure .= 'ENGINE=' . $this->engines[$table] . ((!empty($this->auto_increment[$table])) ? ' AUTO_INCREMENT=' . $this->auto_increment[$table] : '') . ';<br><br><br>';
                }
            }
        
            return $structure;
        }
        
        // This function fetches all sql data and puts it in a multidimensional array
        function fetch_all($result, $type = MYSQL_ASSOC)
        {
            if (!in_array($type, $this->types)) die("Invalid Action!");
            $all = array();
            while ($row = mysql_fetch_array($result, $type))
            {
                $all[] = $row;
            }
            return $all;
        }
    }
    
    $test = new backupdb;
    echo $test->structure_dbbackup();

?>

en here is how a output looks like:

-- --------------------------------------------------------------------------------
-- pafiledb_admin
-- --------------------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `pafiledb_admin`
(
    `admin_id` int(5) NOT NULL AUTO_INCREMENT,
    `admin_username` varchar(20) NULL,
    `admin_password` varchar(32) NULL,
    `admin_email` varchar(50) NULL,
    `admin_status` int(1) NULL,
    PRIMARY KEY (`admin_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2;


-- --------------------------------------------------------------------------------
-- pafiledb_cat
-- --------------------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `pafiledb_cat`
(
    `cat_id` int(5) NOT NULL AUTO_INCREMENT,
    `cat_name` varchar(75) NULL,
    `cat_desc` varchar(150) NULL,
    `cat_files` int(10) NULL,
    `cat_parent` int(5) NULL,
    `cat_order` int(5) NULL,
    `cat_sort` varchar(25) NULL,
    PRIMARY KEY (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=103;


-- --------------------------------------------------------------------------------
-- pafiledb_comments
-- --------------------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `pafiledb_comments`
(
    `comments_id` int(10) NOT NULL AUTO_INCREMENT,
    `file_id` int(10) DEFAULT '0' NOT NULL,
    `news_id` int(10) DEFAULT '0' NOT NULL,
    `comments_text` text NOT NULL,
    `comments_poster` text NOT NULL,
    `comments_ip` text NOT NULL,
    `comments_title` text NOT NULL,
    `comments_time` int(50) DEFAULT '0' NOT NULL,
    `show_comment` int(2) DEFAULT '1',
    `comments_warning` int(2) DEFAULT '0' NULL,
    PRIMARY KEY (`comments_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4;


-- --------------------------------------------------------------------------------
-- pafiledb_custom
-- --------------------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `pafiledb_custom`
(
    `custom_id` int(5) NOT NULL AUTO_INCREMENT,
    `custom_name` varchar(50) NOT NULL,
    `custom_description` varchar(150) NOT NULL,
    PRIMARY KEY (`custom_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;


-- --------------------------------------------------------------------------------
-- pafiledb_customdata
-- --------------------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `pafiledb_customdata`
(
    `customdata_file` int(5) DEFAULT '0' NOT NULL,
    `customdata_custom` int(5) DEFAULT '0' NOT NULL,
    `data` text NOT NULL
) ENGINE=MyISAM;


-- --------------------------------------------------------------------------------
-- pafiledb_emaillog
-- --------------------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `pafiledb_emaillog`
(
    `e_id` int(6) NOT NULL AUTO_INCREMENT,
    `e_date` int(20) DEFAULT '0' NOT NULL,
    `e_ip` varchar(15) NOT NULL,
    `e_fromname` text NOT NULL,
    `e_fromaddress` text NOT NULL,
    `e_toname` text NOT NULL,
    `e_toaddress` text NOT NULL,
    `e_headers` text NOT NULL,
    `e_subject` text NOT NULL,
    `e_message` text NOT NULL,
    PRIMARY KEY (`e_id`)
) ENGINE=MyISAM AUTO_INCREMENT=100;


-- --------------------------------------------------------------------------------
-- pafiledb_exed
-- --------------------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `pafiledb_exed`
(
    `id` smallint(1) unsigned NOT NULL AUTO_INCREMENT,
    `newindicator` tinyint(1) unsigned DEFAULT '1',
    `displaynewindicatordays` tinyint(1) unsigned DEFAULT '5',
    `downtime` tinyint(1) unsigned DEFAULT '1',
    `filesize` tinyint(1) unsigned DEFAULT '1',
    `filesize_type` tinyint(1) unsigned DEFAULT '1',
    `filesize_intervalcheck` tinyint(1) unsigned DEFAULT '0' NOT NULL,
    `filesize_interval` smallint(1) unsigned DEFAULT '1000',
    `pleasewait` tinyint(1) unsigned DEFAULT '0' NOT NULL,
    `waittime` tinyint(1) unsigned DEFAULT '5',
    `commentskin` tinyint(1) unsigned DEFAULT '1',
    `permalink` tinyint(1) unsigned DEFAULT '1',
    `commentsx` tinyint(1) unsigned DEFAULT '1',
    `thumbnailingx` tinyint(1) unsigned DEFAULT '1',
    `enabledisablefile` tinyint(1) unsigned DEFAULT '0' NOT NULL,
    `enabledisabledownload` tinyint(1) unsigned DEFAULT '0' NOT NULL,
    `toplist` tinyint(1) unsigned DEFAULT '1',
    `toplist_where` tinyint(1) unsigned DEFAULT '1',
    `toplist_downloads` tinyint(1) unsigned DEFAULT '1',
    `toplist_ratings` tinyint(1) unsigned DEFAULT '1',
    `toplist_newest` tinyint(1) unsigned DEFAULT '1',
    `show_drop_down` tinyint(1) unsigned DEFAULT '1',
    `show_file_log` tinyint(1) unsigned DEFAULT '0' NOT NULL,
    `icon_or_thumb` tinyint(1) unsigned DEFAULT '1',
    `pagination_style` tinyint(1) unsigned DEFAULT '1',
    `sec_xml` text NOT NULL,
    `sec_last_xml_fetch` char(10) NOT NULL,
    `version` varchar(10) NOT NULL,
    `sec_version` text NOT NULL,
    `sec_last_mail` char(10) NOT NULL,
    `readable_version` varchar(15) NOT NULL,
    `register_mod` tinyint(1) unsigned DEFAULT '1',
    `guest_must_register` tinyint(1) unsigned DEFAULT '0' NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2;


-- --------------------------------------------------------------------------------
-- pafiledb_files
-- --------------------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `pafiledb_files`
(
    `file_id` int(10) NOT NULL AUTO_INCREMENT,
    `file_name` varchar(150) NULL,
    `file_desc` varchar(200) NULL,
    `file_creator` varchar(100) NULL,
    `file_version` varchar(20) NULL,
    `file_longdesc` text NULL,
    `file_ssurl` text NULL,
    `file_dlurl` text NULL,
    `file_size` varchar(20) DEFAULT '0|0',
    `file_mirrors` text NOT NULL,
    `file_time` int(50) NULL,
    `file_catid` int(5) NULL,
    `file_posticon` varchar(30) NULL,
    `file_license` int(5) NULL,
    `file_dls` int(10) NULL,
    `file_last` int(50) NULL,
    `file_pin` int(1) NULL,
    `file_docsurl` text NULL,
    `file_rating` int(10) DEFAULT '0' NOT NULL,
    `file_totalvotes` int(10) DEFAULT '0' NOT NULL,
    `file_disabled` tinyint(1) unsigned DEFAULT '0' NOT NULL,
    `file_download_disabled` tinyint(1) unsigned DEFAULT '0' NOT NULL,
    `file_added_by` text NOT NULL,
    `file_edited` text NOT NULL,
    PRIMARY KEY (`file_id`),
    KEY `file_dls` (`file_dls`),
    KEY `file_time` (`file_time`),
    KEY `file_name` (`file_name`)
) ENGINE=MyISAM AUTO_INCREMENT=254;


-- --------------------------------------------------------------------------------
-- pafiledb_filestats
-- --------------------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `pafiledb_filestats`
(
    `fs_id` smallint(1) unsigned NOT NULL AUTO_INCREMENT,
    PRIMARY KEY (`fs_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;


-- --------------------------------------------------------------------------------
-- pafiledb_license
-- --------------------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `pafiledb_license`
(
    `license_id` int(5) NOT NULL AUTO_INCREMENT,
    `license_name` varchar(30) NULL,
    `license_text` text NULL,
    PRIMARY KEY (`license_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;


-- --------------------------------------------------------------------------------
-- pafiledb_permissions
-- --------------------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `pafiledb_permissions`
(
    `id` smallint(1) unsigned NOT NULL AUTO_INCREMENT,
    `cat_id` text NOT NULL,
    `admin_id` smallint(1) unsigned NOT NULL,
    `perm_add_files` tinyint(1) unsigned NOT NULL,
    `perm_edit_files` tinyint(1) unsigned NOT NULL,
    `perm_del_files` tinyint(1) unsigned NOT NULL,
    `perm_manage_files` tinyint(1) unsigned NOT NULL,
    `perm_add_cats` tinyint(1) unsigned NOT NULL,
    `perm_edit_cats` tinyint(1) unsigned NOT NULL,
    `perm_del_cats` tinyint(1) unsigned NOT NULL,
    `perm_add_ums` tinyint(1) unsigned NOT NULL,
    `perm_edit_ums` tinyint(1) unsigned NOT NULL,
    `perm_del_ums` tinyint(1) unsigned NOT NULL,
    `perm_manage_ums` tinyint(1) unsigned NOT NULL,
    `perm_create_db_backup` tinyint(1) unsigned NOT NULL,
    `perm_edit_pafiledb_info` tinyint(1) unsigned NOT NULL,
    `perm_enable_disable_mod` tinyint(1) unsigned NOT NULL,
    `perm_change_mod_settings` tinyint(1) unsigned NOT NULL,
    `perm_view_mail_log` tinyint(1) unsigned NOT NULL,
    `perm_manage_licence` tinyint(1) unsigned NOT NULL,
    `perm_manage_custom` tinyint(1) unsigned NOT NULL,
    `perm_view_phpinfo` tinyint(1) unsigned NOT NULL,
    `perm_rebuild_categorymenu` tinyint(1) unsigned NOT NULL,
    `perm_versioncheck` tinyint(1) unsigned NOT NULL,
    `perm_seccheck` tinyint(1) unsigned NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2;


-- --------------------------------------------------------------------------------
-- pafiledb_searchquery
-- --------------------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `pafiledb_searchquery`
(
    `id` smallint(1) unsigned NOT NULL AUTO_INCREMENT,
    `query` varchar(50) NOT NULL,
    `key` char(32) NOT NULL,
    `in` varchar(20) NOT NULL,
    `sort_on` varchar(20) NOT NULL,
    `order` char(4) NOT NULL,
    `results` varchar(10) NOT NULL,
    `timeout` char(10) NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=52;


-- --------------------------------------------------------------------------------
-- pafiledb_settings
-- --------------------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `pafiledb_settings`
(
    `id` int(1) NOT NULL AUTO_INCREMENT,
    `dbname` text NOT NULL,
    `dburl` text NOT NULL,
    `topnumber` int(5) DEFAULT '0' NOT NULL,
    `homeurl` text NOT NULL,
    `timeoffset` int(5) DEFAULT '0' NOT NULL,
    `timezone` varchar(100) NOT NULL,
    `skin` varchar(20) NOT NULL,
    `stats` int(1) DEFAULT '0' NOT NULL,
    `lang` varchar(20) NOT NULL,
    `viewall` int(1) DEFAULT '0' NOT NULL,
    `showss` int(1) DEFAULT '0' NOT NULL,
    `date_format` varchar(40) NOT NULL,
    `time_format` varchar(40) NOT NULL,
    `dropdown` text NOT NULL,
    `enable_email` int(1) DEFAULT '0' NOT NULL,
    `perpage` int(3) DEFAULT '0' NOT NULL,
    `enable_report` int(1) DEFAULT '1',
    PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2;


-- --------------------------------------------------------------------------------
-- pafiledb_users
-- --------------------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `pafiledb_users`
(
    `user_id` mediumint(1) unsigned NOT NULL AUTO_INCREMENT,
    `user_username` varchar(25) NOT NULL,
    `user_password` varchar(32) NOT NULL,
    `user_mail` varchar(50) NOT NULL,
    `user_permission` mediumint(1) unsigned NOT NULL,
    PRIMARY KEY (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

nice huh till next blog.

Hey,

i totally forgot about the feature to send mails if there is a bug, security hole or a new release. that feature has now also been implanted but it doesn`t work quite well yet.. something seems wrong with the pafiledb_mail() function so i suppose i will need to rewrite it.

and i found out that my date compare function wasn`t quite as good as expected.. so i remade that one and now it works how i originally expected it to work.

That`s it

Update
i just finished the notifications system. the looks of the notifications can improve alot but that`s stuff for beta 2. for now it`s just done

just 2 more things to do:
1. Update the update script
2. Create and Finish the installation script

than it`s ready to go live
btw.. i didn`t rebuild the pafiledb_mail() thing.. it looks like there was a small bug in it that caused it to fail.. i have reported the bug to the pafiledb team (todd and andrew).

Countdown to 15 march 2007
look at the right of this blog and you will see that i`m planning to have the Extreme Edition 1.0.0 Final Release ready in about 89 days!! that`s on 15 march 2007.. will i make it? or not? i sure hope i do but if i look at my planning history it`s even possible that it`s done in 189 days ... or in 50... i really don`t know.

That`s really it for this post.

Hey,

the first beta release is getting closer and closer
i just squashed the remaining bugs.
those where:

1. (search on file dates)
---------------------------
This was quite a annoying bug.. the dates are stored as a unix timestamp in the database so i couldn`t just use mysql`s DATE_FORMAT() function because that would only work well on timestamps made with mysql`s NOW() function.. luckaly there also is a FROM_UNIXTIME() function that can work with unix time stamps it has about the same powers as DATE_FORMAT() so that fixed that bug. the date is now seen as: YEAR MONTH DAY HOUR MINUTE and you can search through that. i don`t know if i`m gonna link that with the date format field that you have in the admin panel.

2. (forgotten bug)
---------------------------
i forgot what it was.. but it is fixed


now all that is left to do is:

1. update the update script
2. make and finish the installation script
3. finish the security notifications (fetching is working oke.. i just need to make up some styles with it and the security notification needs to popup when there is a new hole found.. AND when multiple holes are found it doesn`t need to show multiple notifications but it needs to show the number of bugs and some info.

For the security notifications.. i think i`m gonna forcefully make a admin LOCK when there are more than 3 holes that aren`t closed.. than the admin can only get in the admin panel to see the security holes and how to fix them.. other than that he can`t do anything.

The other 2 points (update and install script) are special.. i think i will make one script that can do both.. update a currently existsing pafiledb version (any version to extreme edition) and install a brand new version..

for the release date.. i think i`m gonna make it for beta 1

cya on the next blog.

Hey again,

first the exed banner


as you can see this is the banner for beta 1. i will change the colors of each beta and release candidate just a bit the final release won`t have a banner.. it will just have a text row.

now for the version numbers.
the first final release will be: paFileDB Extreme Edition 1.0.0
now the 1.0.0 is the importend part.. here is it explainer number by number

1 This number indicates the major release version.. this can include anything.
.
0 This is just a sub release with a few new features or just alot of bug fixes
.
0 This is for bug fixes only.

and the dots.. they are just dots .................

furthermore i`m happy to announce that Beta 1 is closer to his release the security bug has been resolved (though i don`t like the current admin system.. i will probably redo it again) and some other optimizations have also been done.

all that`s left to do:

• Fix the admin category adding bug (very hard one)
• Finish the Security Checking script (i almost have a host for that one )
• Make and finish the Extreme Edition installation script
• Update the update script with some new table info
• look around if i can optimize anything else... if not.. release to the public. the first place that will have beta 1 is: http://mag.tipsclub.com (it`s currently running a Extreme Edition build from a month ago)

done for now
sleeping time.

Hey,

the bug i found
i just found a security hole in my "Advanced Administration System"...
luckily this script hasn`t been released yet so not many people are affected but 1 site where i test Extreme Edition (it`s a magazine site.. i`m not gonna tell the url) is effected by this hole.

The hole can only be abused when you already have admin powers, BUT if you have admin powers with the lowest possible settings (or moderator level) you can still access all other admin options..

the mistake i made is with the checkaccess function and the $allowed_acts in admin.php the only thing that should be allowed there always is 'logon' and 'main'.. all other act should be calculated from the permissions table which they aren`t at the moment.. and it`s pritty mean to fix this hole..

an example of how this bug can be abused by people that don`t have all rights... when you logged on ad admin/mod you have this in your url: http://............../admin.php?act=main now the error in in act.. you can change main to all values that are in the $allowed_acts variable in admin.php.. so that you don`t see the menu options on the left doesn`t mean that you don`t have access to them.. and that`s wrong.. i will try to fix this ASAP.

the security checking/patching script
Oke recently pafiledb released 2 security patches (relesed over a period of about 2 or 3 months) but i strongly disagree with the way how they release the patches.. they do have some kind of patch notify mail or something like that but i think it`s not enough.. i think there should be a place from where every pafiledb extreme edition user can see the latest holes and can get the latest patches. now it`s stupid if i made public what a security hole can do without making a patch to prevent it so i`ve just added another menu section in the admin panel called: Security Check. when you click on this the script will check what is the latest version of your extreme edition and will check if there is a bug. if that`s found it will check if there is a patch and if that`s avalible you will be able to patch your pafiledb without editing your files. that can be done with diff and patch functions that come with php. I haven`t got this working yet.. i didn`t even experimented with it but i think it`s better to have this than a not patched pafiledb. also when a admin is logged it and a patch is avalible he will see a security warning all over pafiledb extreme edition till you patched ofcause there will be a option to disable this security warning


oke those 2 subjects discussed in this blog post are points that take some time to actually implant and fully test..

beta 1 might suffer some delay because of those 2 points.. but that security and patching system just MUST be in extreme edition before i release beta 1 that system can also be used to update extreme edition beta 1 to beta 2 if all is going fine of cause.

till next blog and i hope i`ve fixed all bugs by than.

Hey,

i`ve just finished the pagination2() function so it can print the pagination in a good looking style. and as i said.. when the pagination is finished i will start working on the upgrade script.

and so i will.

i`ve already made the update sql file (the file that carries all database changes) now i will only need to create the actual update script.. when the upgrade script is done i will start on the install script and as soon as thats done the first beta release is close

just to name a date.. i think the first beta could be here by the edn of the next week (before december) but don`t hold me on this!!

That`s it for now.
cya.

Hey all,

i`ve been sitting still on pafiledb extreme edition for a few weeks, but i`m back on it again.
i`ve made some major changes in the way pafiledb searches through database entry`s and i`m still making improvements on it.

Currently when you see a page that has pagination (so pag: 1 2 3 4 5 6 ...) it`s done with a pagination script BUT that script actually "hides" the rest of the results.. so what is hapening in the code is that pafiledb is fetching ALL the results and the pagination function decides what to display. i`m in the progress of changing this to just grab what it needs to grab for the forst page, second and so on. this is more query friendly than the current system.

SO the improvement i made the last few days:
- Fixed a security hole (www.phparena.net)
- Redone the search page with some gread new functions in it and way more effective
- Modified "mysql.php" so that it can count search results and display them (needed for the new pagination)
- Fixed some toplist issues

Bugs so far that needs to be fixed:
- toplist ratings are currently not working (so the top 5 highest rated files.. it`s hard to make a good top 5 with this..)
- searching on dates is not working because the dates are a full text string instead of human readable text (possible fix is adding another column in the files table that contains the human readable date)


Some other gread things that still needs to be made:
- user login system (so that users need to login to download something)
- thumbnails in category/viewall view
- statistics page
- database backup system
- pagination "the new style"
- update script from a pafiledb 3.1 and pafiledb 3.5.x database to a extreme edition database

parhaps:
- forum intergration (don`t count on that vor Extreme Edition Version 1)
- alternative design
- ajax based ratings and more things made in ajax (i don`t have the ajax knowledge to do this.. help anyone?)
- security hole notify system

when the "needs to be fixed" and the "some other gread things" are made it`s verry likely that i will start releasing BETA`s than. that will be in a way like this:

Beta`s
beta 1 - first beta release. other new features can still be added
beta 2 - second beta release. other new features can still be added
beta 3 - third beta release. development freeze!! no new features in this one.. (could be seen as pre RC 1)

Release Candidates
RC 1 - bug fixes release.. code optimizing also possible, no new features, no database changes
RC 2 - bug fixes release.. code optimizing also possible, no new features, no database changes

Final Release
paFileDB Extreme Edition 1.00

That`s it for now

// EDIT //
Fedora Core 6 just got broken on my pc so i will need to use knoppix to copy my pafiledb progress to a SAFE location when that`s done i will remove Fedora Core 6 (i have to many issues with it anyway) and install the latest version of Ubuntu edgy eft 6.10 that should work way more smooth and easyer anyway and it looks better

Hey,

i`m currently not bussy with pafiledb exed... i`m working on a highly advanced member system that works with groups and user rights.

This post is just to tell a bit about my current projects. pafiledb exed is one of them but just not at this moment

Here are some examples.
lets take the moderator group for example

array('moderator' => array('login' => true,
'edit' => true,
'delete' => true,
'manage' => true,));
Now as you can see the group 'moderator' has the following rights: login, edit, delete and manage.
this is just fine.. but now imagine that you want to keep the group rights like this BUT you also want to add aother user in this group but you don`t want it to have the delete rights.. i made something for that aswell

there is a overrule function that kinda opens the group and simply disables that one right for that user and that`s done like this (sorta)

1st input is the group name
2nd input is the right name
3rd input is the right value (true or false)

array('moderator', 'delete', false)

and besides this there also is the feature to show a admin menu (or just the menu where the user has the rights for) and also a option to show a 'short' menu meaning that it basicly contains a link to his/her menu and maybe a logout link. (like you see on most forums when you are logged in but not in your control panel).

Now for the LightAdmin thing..
Lightadmin is something i`ve tought about for a few years!! but i never had the knowledge to make it. now i have that knowledge and i`m attempting to make it. it`s meant as a alternative mysql web based management system. the featurs you will have in there will be just for mysql and NO other bullshit or nog needed features like phpmyadmin does.. though there will probly be a plugin system for it which allows you to simply implant some plugins in a verry easy way.

i was pritty far with phpmyadmin but like i do with most scripts.. i first make a previes thing with some of the functions in it.. than i rebuild it again in a proper php coding and adding everything i added in the ugly coded thing

sometimes i rebuild a script alot of times.. like the Thumbnailing X script.. that one has been rebuild about 3 or 4 times till it got released and it can still be improved..

o well.. this was my progress for so far.. more pafiledb progress will follow shortly and probly with the release announchment of the so called 'Filesize in Category' mod (it`s being requited 2 few times now so i guess i need to make it..)

Hey,

a few hours ago i started with the advanced search mod and i think it`s about done now
The new search features are this:

• Search in (file name, file id and 3 others)
• Sort on (than a box where you can choose where you want to sort on)
• In Order (again a dropdown box with Ascending or Descending)

It`s not much but it`s what was needed in pafiledb and added
btw.. this mod is NOT!! compatible with a default pafiledb because i changed the database driver for this.

And the permalink system is at about 50%

For the release date.. there is a countdown on the right here which was a indication for when pafiledb extreme edition is done.. don`t expect it to be done within those days probly somewhere arround december 2006.

Cya.

Hey,

(not that alot of poeple read here...)

The thumbnailing x mod was always a pain in the ass because it could have so manny places where things could go wrong.. and i just got a notice of that.. it took me nearly an entire day to track a bug down and fix it the proper way.. for that single bug nearly 50% or perhaps even more of the code has CHANGED!!! and that`s alot when a file is 20 kB!! (20.000 letters and numbers) and in about 470 lines of code!! but now you really have something wonderfull.. though i wasn`t expecting to write such a BIG (in lines) thumbnailing mod.. i well that`s basicly because i wanted to do every single input in a function to be able to manipulate the input in his own function and not just in a function that happens to be the first one called.

I also tried to keep the mod as fast as possible and therefore the mod won`t look any further if it finds the thumbnail in his proper directory. I tought about makking a url check to see if it works but those checks aren`t that fast so i skipped it.. those url checks are only being made when they are needed and that`s mostly when a source file needs to be downloaded.

Though the code is big.. some parts are left out because they where to hard or just not importend enough it add in.

Deleted:
- Option to add watermarks
- Option to add all the image filters that the php imagefilter() option supports

those 2 would be verry nice but just not importend at this time.. i might add the watermark in a later version.

So the Thumbnailing X mod is done and will be posted on pamods shortly.
o btw.. i`m put ALOT of time in this mod and i`m not planning on supporting this version the next few days give me my rest

O and the class CAN be used in pafiledb (designed for that) but it can work fine in any other script aswell. i release it under the GPLv2 licence so you better report improvements of any kind to me!!

Hey,

The warning system that i had planned for the comment mod proves to be alot more complicated than expected.. i`m having a hard time fixing it all together.. with that i mean the coding.. putty gives me the most problems of all o well.. i will probly get it working..

The editing in the comments has been finished and comments can be edited now by admins. for now there isn`t a line appearing in the comment that tells who edited the comment but i`m thinking of adding that in aswell but in order to do that i will need to bypass xhtml_convert() and that could mean a security risk if it`s not done correctly..

comment mod x progress stays on 95%.

Cya

Hey again,

The comments mod x is nearly done.. all that`s left to do is putting some kind of edit in for the admins and some kind of add warning... warning themselve are shown now if there are any.

CommentsX Progress: 95%

The "Enable/Disable Mod" is a admin panel feature which i just completed.. till now the status (enebled or disabled) where always on enabled even if they where disabled but some help from andrew and making a new function made it so that the status of a disabled mod is on disabled instead of enabled.. same for the enabled mods ofcause.

Enable/Disable Mod progress: 100% (done)

Next thing to do: finishing the commentsx and adding some more options in the "Change mod settings" which is located in the admin panel.

Cye till next blog.

Hey,

a few days ago i started on making a completely new php script. the name is LightAdmin and i`m planning on making it THE phpmyadmin alternative.. and i need a break from the extreme edition modding so this is a good way to do it

This won`t mean that Extreme Edition will stop... ohh noo it`s just on hold for a while till i get enough of LightAdmin than i continue with Extreme Edition.

i probly continue within 1 or 2 weeks so don`t be worried

Thanx.

hey there

i just finished with choosing the color parts for the stats graphical part.
here is a screenshot:



that`s basicly it.. have fun

Hey,

i was just trying to find a way to make that new comments style in divs only while i came across this that made me think of adding a printer friendly page in all pafiledb exed sections... with no images and as little colors as possible.

So i`m not sure if this is gonna be in for sure but i will give it a try so for now it`s on the TODO list.

Current TODO status:
Items on TODO: 18
Items Completed: 5
Items left: 13

well.. i will be bussy for some time

:O 2 posts on 1 day... and i bet just a handfull of people are actually reading this blog but o well.. it`s nice anyway.

To the point.

i just finished with the thumbnailing mod. all features are now working in php 5 and most features are working in php 4 (except the downloading stuff ofcause).

When you use php 4 and you also use external links to images you will just get the full scale version so i advice you all to use the link option in that case.. that meand that you get a text link which will go to the image.

In order to get this all working again i did some code (execute_thumbnail_checks() function and one other) all over again because it was just getting a mess. now it should all work fine when you install EXED. though the thumbnailing feature is besicly for php 5 only so i thing i will include some kind of php check in the installer which will look at you php version and turn the required functions on or off depending on your php version.

Though the thumbnailing stuff will work fine again on php 4 when you put you screenshots on the same server as your pafiledb is on.

Oke.. that`s it for the Thumbnailing X mod. now it`s time to start with the 5 seconds waiting mod.

//me makes a note that Thumbnailing X is completed.

till next blog.

Hey,

i just finished the thumbnailing class.
i added one verry nice feature: debug option. This option allows me to see what the function combination is to find uot in which function it might have gone wrong.

i also perfected the file_exists replicate to check for a variation of possible links where the thumbnail or main image can be located.

next thing to do: import the thumbnailing class in the view look.

till next time.

Hey,

i was planning on adding some kind of member system so that a site administrator can manage the users that want to download and limit the users. new in this idea is User Levels (something like a forum) the following levels might get in:

• Level 1 (download up to XX MB a week)
• Level 2 (Download up to XX MB a week with the extra option to select multiple files, put them in one archive and download that file.)
• Level 3 (you can compare this with forum mods.. they can change info of a file if needed and have all rights of level 2)
• Level X (x as in X not as in a number.. this level is the administrator level.)

Putting multiple files in a archive is a feature on it`s own but that feature has some other featurs to.. here is a selection of the features that the class can do:

• add multiple files to a compressed archive
• set the compression level (0 = none 9 = highest)
• recursive adding (handy for adding folders)

now for the progress.. i`ve made a function that can handle the sorting of the view lists.. so now you can sort on.. date, file name and dowloads. it`s working perfectly BUT the bad think about it is that i have buttons now.. and i want a link. but it`s hard to post things through a form and use a hyperlink for the posting.. so i think i will switch to $_GET variables instead of $_POST bad thing about $_GET is that it`s not my intention to add more things in the url..