Phoca Forum

Warning: Invalid argument supplied for foreach() in x:\home\test1.ru\www\components\com_phocagallery\helpers\phocagallery.php on line 618

    // Create tree of categories and subcategories - we need strings e.g. (first, first >> second, ...)
    // text is name because of select
    // value is id because of select
    function CategoryTree($data, $tree, $id=0, $text='') {        
        
        foreach ($data as $key)
        {    
            $show_text =  $text . $key->text;    
            if ($key->parentid == $id)
            {    

Warning: Invalid argument supplied for foreach() in x:\home\test1.ru\www\administrator\components\com_phocagallery\helpers\phocagallery.php on line 1248

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in x:\home\test1.ru\www\libraries\joomla\database\database\mysql.php on line 342

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in x:\home\test1.ru\www\libraries\joomla\database\database\mysql.php on line 342

DROP TABLE IF EXISTS `jos_phocagallery`;

CREATE TABLE `jos_phocagallery` (
`id` int(11) unsigned NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`filename` varchar(250) NOT NULL default '',
`description` text NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`hits` int(11) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`published`)
) TYPE=MyISAM CHARACTER SET `utf8`;


DROP TABLE IF EXISTS `jos_phocagallery_categories`;

CREATE TABLE `jos_phocagallery_categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default 0,
`title` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`image` varchar(255) NOT NULL default '',
`section` varchar(50) NOT NULL default '',
`image_position` varchar(30) NOT NULL default '',
`description` text NOT NULL,
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`count` int(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) TYPE=MyISAM CHARACTER SET `utf8`;


DROP TABLE IF EXISTS `jos_phocagallery_votes`;
CREATE TABLE `jos_phocagallery_votes` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default 0,
`userid` int(11) NOT NULL default 0,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`rating` tinyint(1) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `jos_phocagallery_comments`;
CREATE TABLE `jos_phocagallery_comments` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default 0,
`userid` int(11) NOT NULL default 0,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(255) NOT NULL default '',
`comment` text NOT NULL,
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `jos_phocagallery_votes_statistics`;
CREATE TABLE `jos_phocagallery_votes_statistics` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default 0,
`count` tinyint(11) NOT NULL default '0',
`average` float(8,6) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `jos_phocagallery_user_category`;
CREATE TABLE `jos_phocagallery_user_category` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default 0,
`userid` int(11) NOT NULL default 0,
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`userid`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;


# ALTER TABLE `jos_phocagallery_categories` ADD `hits` INT( 11 ) NOT NULL DEFAULT '0' AFTER `count` ;