IP : 18.119.157.155Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
softaculous/
hizup/
../
gnu/
../
atutor/
../
./
magento241/
../
dolph/
dolph.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
CREATE TABLE `Profiles` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `NickName` varchar(255) NOT NULL DEFAULT '', `Email` varchar(255) NOT NULL DEFAULT '', `Password` varchar(40) NOT NULL DEFAULT '', `Salt` varchar(10) NOT NULL DEFAULT '', `Status` enum('Unconfirmed','Approval','Active','Rejected','Suspended') NOT NULL DEFAULT 'Unconfirmed', `Role` tinyint(4) unsigned NOT NULL DEFAULT '1', `Couple` int(10) unsigned NOT NULL DEFAULT '0', `Sex` varchar(255) NOT NULL DEFAULT '', `LookingFor` set('male','female') NOT NULL DEFAULT '', `DescriptionMe` text NOT NULL, `Country` varchar(255) NOT NULL DEFAULT '', `City` varchar(255) NOT NULL, `DateOfBirth` date NOT NULL, `Featured` tinyint(1) NOT NULL DEFAULT '0', `DateReg` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `DateLastEdit` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `DateLastLogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `DateLastNav` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `aff_num` int(10) unsigned NOT NULL DEFAULT '0', `Tags` varchar(255) NOT NULL DEFAULT '', `zip` varchar(255) NOT NULL, `EmailNotify` tinyint(1) NOT NULL DEFAULT '1', `LangID` int(11) NOT NULL, `UpdateMatch` tinyint(1) NOT NULL DEFAULT '1', `Views` int(11) NOT NULL, `Rate` float NOT NULL, `RateCount` int(11) NOT NULL, `CommentsCount` int(11) NOT NULL, `PrivacyDefaultGroup` int(11) NOT NULL DEFAULT '3', `allow_view_to` int(11) NOT NULL DEFAULT '3', `UserStatus` varchar(64) NOT NULL DEFAULT 'online', `UserStatusMessage` varchar(255) NOT NULL DEFAULT '', `UserStatusMessageWhen` int(10) NOT NULL, `Avatar` int(10) unsigned NOT NULL, `Height` varchar(255) NOT NULL, `Weight` varchar(255) NOT NULL, `Income` varchar(255) NOT NULL, `Occupation` varchar(255) NOT NULL, `Religion` varchar(255) NOT NULL, `Education` varchar(255) NOT NULL, `RelationshipStatus` enum('Single','In a Relationship','Engaged','Married','It''s Complicated','In an Open Relationship') DEFAULT NULL, `Hobbies` text NOT NULL, `Interests` text NOT NULL, `Ethnicity` varchar(255) NOT NULL, `FavoriteSites` text NOT NULL, `FavoriteMusic` text NOT NULL, `FavoriteFilms` text NOT NULL, `FavoriteBooks` text NOT NULL, `FullName` varchar(255) NOT NULL, `FirstName` varchar(255) NOT NULL, `LastName` varchar(255) NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `NickName` (`NickName`), KEY `Country` (`Country`), KEY `DateOfBirth` (`DateOfBirth`), KEY `DateReg` (`DateReg`), KEY `DateLastNav` (`DateLastNav`), FULLTEXT KEY `NickName_2` (`NickName`,`FullName`,`FirstName`,`LastName`,`City`,`DescriptionMe`,`Tags`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
CREATE TABLE `RayChatRooms` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(255) NOT NULL DEFAULT '', `Password` varchar(255) NOT NULL DEFAULT '', `Desc` text NOT NULL, `OwnerID` varchar(20) NOT NULL DEFAULT '0', `When` int(11) DEFAULT NULL, `Status` enum('normal','delete') NOT NULL DEFAULT 'normal', PRIMARY KEY (`ID`), UNIQUE KEY `Name` (`Name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
-- -- Dumping data for table `RayChatRooms` --
INSERT INTO `RayChatRooms` VALUES (1, 'Lobby', '', 'Welcome to our chat! You are in the "Lobby" now, but you can pass into any other public room you wish to - take a look at the "All rooms" box.', '0', 0, 'normal'), (2, 'Friends', '', 'Welcome to the "Friends" room! This is a public room where you can have a fun chat with existing friends or make new ones! Enjoy!', '0', 1, 'normal');
-- -- Table structure for table `sys_email_templates` --
CREATE TABLE `sys_email_templates` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `Name` varchar(255) NOT NULL, `Subject` varchar(255) NOT NULL, `Body` text NOT NULL, `Desc` varchar(255) NOT NULL, `LangID` tinyint(4) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`ID`), KEY `Name` (`Name`,`LangID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;
-- -- Dumping data for table `sys_email_templates` --
INSERT INTO `sys_email_templates` VALUES (1, 't_Activation', 'Your Profile Is Now Active', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>Your profile was reviewed and activated!</p>\r\n\r\n<p>Your Account: <a href="<Domain>member.php"><Domain>member.php</a></p>\r\n\r\n<p>Member ID: <b><recipientID></b></p>\r\n\r\n<p>Your E-mail: <span style="color:#FF6633"><Email></span></p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Profile activation notification.', 0), (2, 't_AdminEmail', '<SiteName> Admin: <MessageSubject>', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p><a href="<Domain>"><SiteName></a> Admin sent you a message:</p>\r\n\r\n<hr>\r\n<p style="color:#3B5C8E"><MessageText></p>\r\n<hr>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Message from the site Admin.', 0), (3, 't_AdminStats', 'Content Pending Admin Review', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p><MessageText></p>\r\n\r\n<p>Go to <a href="<ViewLink>">administration panel</a> to review pending content.</p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Message to admin about content pending review', 0), (4, 't_Compose', 'You''ve Got A New Message', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Hello <RealName></b>,</p>\r\n\r\n<p>You have received a message from <a href="<ProfileUrl>"><ProfileReference></a>!</p>\r\n\r\n<p>Go to your account to read and reply: <a href="<Domain>member.php"><Domain>member.php</a></p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'New message notification without message text', 0), (5, 't_Confirmation', 'Email Confirmation Request', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>Thank you for registering at <SiteName>!</p>\r\n\r\n<p>Click to confirm your email:\r\n<a href="<ConfirmationLink>"><ConfirmationLink></a></p>\r\n\r\n<p>CONFIRMATION CODE: <ConfCode></p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Email confirmation message.', 0), (6, 't_CupidMail', 'Your Matches', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Hello <RealName></b>,</p>\r\n\r\n<p>Check out some <SiteName> members that may be a good match with you:</p>\r\n\r\n<p><a href="<MatchProfileLink>"><MatchProfileLink></a></p>\r\n\r\n\r\n<bx_include_auto:_email_footer.html />', 'Matching profiles notification.', 0), (7, 't_Forgot', 'Your Account Password', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>Your member ID: <b><recipientID></b></p>\r\n\r\n<p>Your password: <b><Password></b></p>\r\n\r\n<p>You may login here: <a href="<Domain>member.php"><Domain>member.php</a></p>\r\n\r\n\r\n<bx_include_auto:_email_footer.html />', 'Password retrieval', 0), (8, 't_FreeEmail', 'Member Email Address', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p><profileNickName>''s contact info:</p> \r\n\r\n<p><profileContactInfo></p>\r\n\r\n\r\n<bx_include_auto:_email_footer.html />', 'Requested Member Email Address', 0), (9, 't_MemExpiration', 'Your Membership Is About To Expire', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Hello <RealName></b>,</p>\r\n\r\n<p>Your <SiteName> <MembershipName> membership will expire in <ExpireDays> days.</p>\r\n\r\n<p>NOTE: -1 means it has already expired</p>\r\n\r\n\r\n<p><a href="<Domain>modules/?r=membership/index/">Renew Membership</a></p>\r\n<bx_include_auto:_email_footer.html />', 'Membership expiration notice', 0), (10, 't_MemChanged', 'Your Membership Changed', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Hello <RealName></b>,</p>\r\n\r\n<p>Your membership level was changed to: <b><a href="<Domain>modules/?r=membership/index/"><MembershipLevel></a></b></p>\r\n\r\n\r\n<bx_include_auto:_email_footer.html />', 'Membership change', 0), (11, 't_Message', 'You''ve Got A New Message', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p><a href="<ProfileUrl>"><ProfileReference></a> sent you a message: </p>\r\n\r\n<hr>\r\n<p><MessageText></p>\r\n<hr>\r\n\r\n<p>Go to your account to reply: <a href="<Domain>member.php"><Domain>member.php</a></p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'New message notification with message text', 0), (12, 't_UserJoined', 'New Member Joined', '<bx_include_auto:_email_header.html />\r\n\r\n<p>New user: <RealName></p> \r\n<p>Email: <Email></p> \r\n\r\n<bx_include_auto:_email_footer.html />', 'Admin notification about new member', 0), (13, 't_UserConfirmed', 'User Confirmed Email', '<bx_include_auto:_email_header.html />\r\n\r\n<p>User: <RealName></p> \r\n<p>Email: <Email></p> \r\n\r\n<bx_include_auto:_email_footer.html />', 'Admin notification - user confirmed email', 0), (14, 't_UserMemChanged', 'Member Membership Changed', '<bx_include_auto:_email_header.html />\r\n\r\n<p><RealName>''s membership level was changed to: <b><MembershipLevel></b></p>\r\n\r\n\r\n<bx_include_auto:_email_footer.html />', 'Admin notification about membership change', 0), (15, 't_UserUnregistered', 'Member Unregistered', '<bx_include_auto:_email_header.html />\r\n\r\n<p>User: <NickName></p> \r\n<p>Email: <Email></p> \r\n<p>was unregistered.</p> \r\n\r\n<bx_include_auto:_email_footer.html />', 'Admin notification about unregistered member', 0), (16, 't_SpamReport', 'Profile Spam Report', '<bx_include_auto:_email_header.html />\r\n\r\n<p><a href="<Domain>profile.php?ID=<reporterID>"><reporterNick></a> reported Profile SPAM: <a href="<Domain>profile.php?ID=<spamerID>"><b><spamerNick></b></a></p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Profile Spam Report', 0), (17, 't_TellFriend', 'Check This Out!', '<bx_include_auto:_email_header.html />\r\n\r\n\r\n<p>I thought you''d be interested: <a href="<Link>"><Link></a><br />\r\n---<br />\r\n<a href="<SenderLink>"><SenderName></a>\r\n</p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Friend Invitation', 0), (18, 't_TellFriendProfile', 'Look At This Profile', '<bx_include_auto:_email_header.html />\r\n\r\n\r\n\r\n<p>Check out this profile: <a href="<Link>"><Link></a><br />\r\n---<br />\r\n<a href="<SenderLink>"><SenderName></a>\r\n</p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Email profile to a friend', 0), (19, 't_VKiss', 'Greeting notification', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p><ProfileReference> sent you a greeting!</p>\r\n\r\n<p><ProfileReference> may be interested in you or maybe just wants to say Hello!\r\n</p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Greeting notification ', 0), (20, 't_VKiss_visitor', 'Greeting notification', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>Our site visitor sent you a greeting!</p>\r\n\r\n\r\n<bx_include_auto:_email_footer.html />', 'Greeting from visitor notification', 0), (21, 't_MessageCopy', 'Copy Of Your Message : <your subject here>', '<bx_include_auto:_email_header.html />\r\n\r\n<p>You wrote:</p>\r\n<hr>\r\n<p><your message here></p>\r\n<hr>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Message copy', 0), (22, 't_Subscription', 'Your Subscription', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>You subscribed to <a href="<ViewLink>"><Subscription></a></p>\r\n\r\n<p>You may cancel the subscription here: <a href="<SysUnsubscribeLink>"><SysUnsubscribeLink></a></p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Subscription confirmation', 0), (23, 't_sbsProfileComments', 'New Profile Comments', '<bx_include_auto:_email_header.html />\r\n\r\n <p><b>Dear <RealName></b>,</p>\r\n\r\n<p>Profile you subscribed to got <a href="<ViewLink>">new comments</a>.</p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'New comments to profile subscription', 0), (24, 't_sbsProfileEdit', 'Subscription: Profile Edited', '<bx_include_auto:_email_header.html />\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p><a href="<ViewLink>">Profile you subscribed to</a> has been updated.</p>\r\n\r\n<bx_include_auto:_email_footer.html />', 'Profile info subscription.', 0), (25, 't_FriendRequest', 'Friendship Request', '<bx_include_auto:_email_header.html />\r\n\r\n <p><b>Dear <Recipient></b>,</p>\r\n \r\n <p><a href="<SenderLink>"><Sender></a> wants to be friends with you. <a href="<RequestLink>">Respond</a>.</p>\r\n <br /> \r\n <bx_include_auto:_email_footer.html />', 'Friendship Request', 0), (26, 't_FriendRequestAccepted', 'Friendship Request Accepted', '<bx_include_auto:_email_header.html />\r\n\r\n <p><b>Dear <Recipient></b>,</p>\r\n \r\n <p><a href="<SenderLink>"><Sender></a> accepted your friendship request.</p>\r\n <br /> \r\n <bx_include_auto:_email_footer.html />', 'Friendship Request Accepted', 0), (27, 't_SpamReportAuto', '<SiteName> Automatic Spam Report', '<bx_include_auto:_email_header.html />\r\n\r\n\r\n<b>Profile:</b> <a href="<SpammerUrl>"><SpammerNickName></a><br />\r\n\r\n<b>Page:</b> <Page><br />\r\n\r\n<b>GET variables:</b>\r\n<pre>\r\n<Get>\r\n</pre>\r\n\r\n<b>Spam Content:</b>\r\n<pre>\r\n<SpamContent>\r\n</pre>\r\n\r\n\r\n<bx_include_auto:_email_footer.html />', 'Automatic spam report', 0), (28, 't_ModulesUpdates', '<SiteName> Automatic modules updates checker', '<bx_include_auto:_email_header.html />\r\n\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>The following updates are available:</p>\r\n\r\n<p><MessageText></p>\r\n\r\n<p>If you want to install any of them you need to go to your site''s admin panel -> Modules -> Add & Manage and click Check For Updates button in Installed Modules block. It will load all available updates.</p>\r\n\r\n\r\n<bx_include_auto:_email_footer.html />', 'Message to admin about modules updates', 0), (29, 't_ExportReady', '<SiteName> Your data export is ready', '<bx_include_auto:_email_header.html />\r\n\r\n\r\n<p><b>Dear <RealName></b>,</p>\r\n\r\n<p>Your data download link:</p>\r\n\r\n<p><FileUrl></p>\r\n\r\n<p>Link will be availiable for 24 hours.</p>\r\n\r\n\r\n<bx_include_auto:_email_footer.html />', 'Notification about user data export', 0);
-- -- Table structure for table `sys_menu_member` --
CREATE TABLE `sys_menu_member` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Caption` varchar(100) NOT NULL, `Name` varchar(200) NOT NULL, `Icon` varchar(100) NOT NULL, `Link` varchar(250) NOT NULL, `Script` varchar(250) NOT NULL, `Eval` text NOT NULL, `PopupMenu` text NOT NULL, `Order` int(5) NOT NULL, `Active` enum('1','0') NOT NULL, `Movable` tinyint(4) NOT NULL DEFAULT '3', `Clonable` tinyint(1) NOT NULL DEFAULT '1', `Editable` tinyint(1) NOT NULL DEFAULT '1', `Deletable` tinyint(1) NOT NULL DEFAULT '1', `Target` varchar(200) NOT NULL, `Position` enum('top','bottom','top_extra') NOT NULL DEFAULT 'top', `Type` enum('link','system','linked_item') NOT NULL, `Parent` int(11) NOT NULL, `Bubble` text NOT NULL, `Description` varchar(50) NOT NULL, PRIMARY KEY (`ID`), KEY `Parent` (`Parent`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
-- -- Table structure for table `sys_menu_mobile` --
CREATE TABLE `sys_menu_mobile` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(32) NOT NULL, `page` varchar(32) NOT NULL, `title` varchar(255) NOT NULL, `icon` varchar(255) NOT NULL, `action` int(11) NOT NULL, `action_data` varchar(255) NOT NULL, `eval_bubble` text NOT NULL, `eval_hidden` text NOT NULL, `order` int(11) NOT NULL, `active` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
-- -- Table structure for table `sys_objects_cmts` --
CREATE TABLE `sys_objects_cmts` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `ObjectName` varchar(50) NOT NULL, `TableCmts` varchar(50) NOT NULL, `TableTrack` varchar(50) NOT NULL, `AllowTags` smallint(1) NOT NULL, `Nl2br` smallint(1) NOT NULL, `SecToEdit` smallint(6) NOT NULL, `PerView` smallint(6) NOT NULL, `IsRatable` smallint(1) NOT NULL, `ViewingThreshold` smallint(6) NOT NULL, `AnimationEffect` varchar(50) NOT NULL, `AnimationSpeed` smallint(6) NOT NULL, `IsOn` smallint(1) NOT NULL, `IsMood` smallint(1) NOT NULL, `RootStylePrefix` varchar(16) NOT NULL DEFAULT 'cmt', `TriggerTable` varchar(32) NOT NULL, `TriggerFieldId` varchar(32) NOT NULL, `TriggerFieldComments` varchar(32) NOT NULL, `ClassName` varchar(32) NOT NULL, `ClassFile` varchar(256) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- -- Dumping data for table `sys_objects_cmts` --
-- -- Table structure for table `sys_pre_values` --
CREATE TABLE `sys_pre_values` ( `Key` varchar(255) NOT NULL DEFAULT '' COMMENT 'Key which defines link to values list', `Value` varchar(255) NOT NULL DEFAULT '' COMMENT 'Simple value stored in the database', `Order` int(10) unsigned NOT NULL DEFAULT '0', `LKey` varchar(255) NOT NULL DEFAULT '' COMMENT 'Primary language key used for displaying this value', `LKey2` varchar(255) NOT NULL DEFAULT '' COMMENT 'Additional key used in some other places', `LKey3` varchar(255) NOT NULL DEFAULT '', `Extra` varchar(255) NOT NULL DEFAULT '' COMMENT 'Some extra values. For example image link for sex', `Extra2` varchar(255) NOT NULL DEFAULT '', `Extra3` varchar(255) NOT NULL DEFAULT '' ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- -- Table structure for table `sys_stat_member` --
CREATE TABLE `sys_stat_member` ( `Type` varchar(10) 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''');
-- -- 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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- -- 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);
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;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;