
--
-- Table structure for table `sys_shared_sites`
--

CREATE TABLE `sys_shared_sites` (
  `ID` tinyint(4) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) DEFAULT NULL,
  `URL` varchar(255) NOT NULL DEFAULT '',
  `Icon` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_shared_sites`
--

INSERT INTO `sys_shared_sites` VALUES (1,'digg','http://digg.com/submit?phase=2&url=','digg.png'),(2,'delicious','http://del.icio.us/post?url=','delicious.png'),(4,'newsvine','http://www.newsvine.com/_tools/seed&save?u=','newsvine.png'),(5,'reddit','http://reddit.com/submit?url=','reddit.png'),(9,'facebook','http://www.facebook.com/sharer/sharer.php?u=','facebook.png'),(10,'twitter','https://twitter.com/share?url=','twitter.png');

--
-- Table structure for table `sys_stat_member`
--

CREATE TABLE `sys_stat_member` (
  `Type` varchar(20) NOT NULL,
  `SQL` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_stat_member`
--

INSERT INTO `sys_stat_member` VALUES ('mma','SELECT COUNT(*) FROM `sys_messages` WHERE `Recipient`=\'__member_id__\' AND NOT FIND_IN_SET(\'Recipient\', `sys_messages`.`Trash`)'),('mmn','SELECT COUNT(*) FROM `sys_messages` WHERE `Recipient`=\'__member_id__\' AND `New`=\'1\' AND NOT FIND_IN_SET(\'Recipient\', `sys_messages`.`Trash`)'),('mfl','SELECT COUNT(*) FROM `sys_fave_list` WHERE `ID` = \'__member_id__\' '),('mfr','SELECT COUNT(*) FROM `sys_friend_list` as f LEFT JOIN `Profiles` as p ON p.`ID` = f.`ID` WHERE f.`Profile` = __member_id__ AND f.`Check` = \'0\' AND p.`Status`=\'Active\''),('mfa','SELECT COUNT(*) FROM `sys_friend_list` WHERE ( `ID`=\'__member_id__\' OR `Profile`=\'__member_id__\' ) AND `Check`=\'1\''),('mgc','SELECT COUNT(*) FROM `sys_greetings` WHERE `ID` = \'__member_id__\' AND New = \'1\''),('mbc','SELECT COUNT(*) FROM `sys_block_list` WHERE `ID` = \'__member_id__\''),('mgmc','SELECT COUNT(*) FROM `sys_greetings` WHERE `Profile` = \'__member_id__\' AND New = \'1\''),('bx_events','SELECT COUNT(*) FROM `bx_events_main` WHERE `ResponsibleID` = \'__member_id__\' AND `Status`=\'approved\''),('bx_eventsp','SELECT COUNT(*) FROM `bx_events_main` WHERE `ResponsibleID` = \'__member_id__\' AND `Status`!=\'approved\''),('phs','SELECT COUNT(*) FROM `bx_photos_main` WHERE `Owner` = \'__member_id__\' AND `Status` = \'approved\''),('bx_groups','SELECT COUNT(*) FROM `bx_groups_main` WHERE `author_id` = \'__member_id__\' AND `status`=\'approved\''),('mad','SELECT COUNT(*) FROM `bx_ads_main` WHERE `IDProfile` = \'__member_id__\' AND `Status`=\'active\''),('mop','SELECT COUNT(*) FROM `bx_forum_post` WHERE `user` = \'__member_nick__\''),('mot','SELECT COUNT(*) FROM `bx_forum_topic` WHERE `first_post_user` = \'__member_nick__\''),('bx_groupsp','SELECT COUNT(*) FROM `bx_groups_main` WHERE `author_id` = \'__member_id__\' AND `Status`!=\'approved\''),('bx_sites','SELECT COUNT(*) FROM `bx_sites_main` WHERE `ownerid` = \'__member_id__\' AND `status`=\'approved\''),('bx_sitesp','SELECT COUNT(*) FROM `bx_sites_main` WHERE `ownerid` = \'__member_id__\' AND `status`!=\'approved\''),('modzzz_articles','SELECT COUNT(*) FROM `modzzz_articles_main` WHERE `author_id` = \'__member_id__\' AND `status`=\'approved\''),('modzzz_articlesp','SELECT COUNT(*) FROM `modzzz_articles_main` WHERE `author_id` = \'__member_id__\' AND `Status`!=\'approved\'');

--
-- Table structure for table `sys_stat_site`
--

CREATE TABLE `sys_stat_site` (
  `ID` tinyint(4) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(20) NOT NULL DEFAULT '',
  `Title` varchar(50) NOT NULL DEFAULT '',
  `UserLink` varchar(255) NOT NULL DEFAULT '',
  `UserQuery` varchar(255) NOT NULL DEFAULT '',
  `AdminLink` varchar(255) NOT NULL DEFAULT '',
  `AdminQuery` varchar(255) NOT NULL DEFAULT '',
  `IconName` varchar(50) NOT NULL DEFAULT '',
  `StatOrder` int(4) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_stat_site`
--

INSERT INTO `sys_stat_site` VALUES (1,'all','Members','browse.php','SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status`=\'Active\' AND (`Couple`=\'0\' OR `Couple`>`ID`)','{admin_url}profiles.php?action=browse&by=status&value=approval','SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status`=\'Approval\' AND (`Couple`=\'0\' OR `Couple`>`ID`)','user',1),(2,'evs','bx_events','modules/?r=events/browse/recent','SELECT COUNT(`ID`) FROM `bx_events_main` WHERE `Status`=\'approved\'','modules/?r=events/administration','SELECT COUNT(`ID`) FROM `bx_events_main` WHERE `Status`=\'pending\'','calendar',2),(3,'phs','bx_photos','modules/?r=photos/browse/all','SELECT COUNT(`ID`) FROM `bx_photos_main` WHERE `Status`=\'approved\'','modules/?r=photos/administration/home/pending','SELECT COUNT(*) FROM `bx_photos_main` as a left JOIN `sys_albums_objects` as b ON b.`id_object`=a.`ID` left JOIN `sys_albums` as c ON c.`ID`=b.`id_album` WHERE a.`Status` =\'pending\' AND c.`AllowAlbumView` NOT IN(8) AND c.`Type`=\'bx_photos\'','picture-o',3),(4,'fdb','feedback_ss','modules/?r=feedback/index/','SELECT COUNT(`ID`) FROM `bx_fdb_entries` WHERE `status`=\'0\'','modules/?r=feedback/admin/','SELECT COUNT(`ID`) FROM `bx_fdb_entries` WHERE `status`=\'1\'','thumbs-up',4),(5,'news','news_ss','modules/?r=news/archive/','SELECT COUNT(`ID`) FROM `bx_news_entries` WHERE `status`=\'0\'','modules/?r=news/admin/','SELECT COUNT(`ID`) FROM `bx_news_entries` WHERE `status`=\'1\'','bullhorn',5),(10,'bx_groups','bx_groups','modules/?r=groups/browse/recent','SELECT COUNT(`id`) FROM `bx_groups_main` WHERE `status`=\'approved\'','modules/?r=groups/administration','SELECT COUNT(`id`) FROM `bx_groups_main` WHERE `status`=\'pending\'','users',10),(8,'cls','bx_ads_Ads','modules/boonex/ads/classifieds.php?action=show_all_ads','SELECT COUNT(`ID`) FROM `bx_ads_main` WHERE `Status`=\'active\' AND UNIX_TIMESTAMP() - `bx_ads_main`.`LifeTime`*24*60*60 < `bx_ads_main`.`DateTime`','modules/boonex/ads/post_mod_ads.php','SELECT COUNT(`ID`) FROM `bx_ads_main` WHERE `Status`=\'new\' AND UNIX_TIMESTAMP() - `bx_ads_main`.`LifeTime`*24*60*60 < `bx_ads_main`.`DateTime`','money',8),(9,'tps','bx_forum_discussions','forum/','SELECT IF( NOT ISNULL( SUM(`forum_topics`)), SUM(`forum_posts`), 0) AS `Num` FROM `bx_forum`','','','comments',9),(15,'modzzz_articles','modzzz_articles','modules/?r=articles/browse/recent','SELECT COUNT(`id`) FROM `modzzz_articles_main` WHERE `status`=\'approved\'','modules/?r=articles/administration','SELECT COUNT(`id`) FROM `modzzz_articles_main` WHERE `status`=\'pending\'','file',13),(12,'sts','bx_sites','modules/?r=sites/browse/all','SELECT COUNT(`ID`) FROM `bx_sites_main` WHERE `status`=\'approved\'','modules/?r=sites/administration','SELECT COUNT(`ID`) FROM `bx_sites_main` WHERE `status`=\'pending\'','link',12);

--
-- Table structure for table `sys_tags`
--

CREATE TABLE `sys_tags` (
  `Tag` varchar(32) NOT NULL DEFAULT '',
  `ObjID` int(10) unsigned NOT NULL DEFAULT '0',
  `Type` varchar(20) NOT NULL DEFAULT 'profile',
  `Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`Tag`,`ObjID`,`Type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sys_tags`
--

INSERT INTO `sys_tags` VALUES ('profile photos',1,'bx_photos','2015-04-08 16:11:54'),('profile photos',2,'bx_photos','2015-04-08 16:18:13'),('something',1,'bx_events','2015-04-08 16:24:18'),('events',3,'bx_photos','2015-04-08 16:33:48'),('profile photos',4,'bx_photos','2015-04-10 03:58:19'),('loft',2,'ad','2015-10-21 01:20:42'),('sunny',2,'ad','2015-10-21 01:20:42'),('fun',2,'bx_events','2015-06-02 14:35:49'),('halloween',3,'bx_events','2015-10-21 01:25:24'),('fun',3,'bx_events','2015-10-21 01:25:24'),('africa',3,'bx_events','2015-10-21 01:25:24'),('test',1,'bx_groups','2015-11-13 16:26:58'),('profile photos',15,'bx_photos','2015-12-22 20:35:41');


