customizing privacy settings

I am using  Extra Privacy Mod by ModZZZ I am trying to customize it to my own site personal settings as needed.  with the following options (gay male, lesbian, bisexual male etc...)

This is what I did to copy his coding

 

db_res("
INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES
('sys_ps_enabled_group_18', 'on', 9, 'Enable ''Males Only'' group', 'checkbox', '', '', 15, ''),
('sys_ps_group_18_title', 'Males Only', 9, 'Title for ''Males Only'' group', 'digit', '', '', 16, ''),

('sys_ps_enabled_group_19', 'on', 9, 'Enable ''Females Only'' group', 'checkbox', '', '', 17, ''),
('sys_ps_group_19_title', 'Females Only', 9, 'Title for ''Females Only'' group', 'digit', '', '', 18, ''),

('sys_ps_enabled_group_20', 'on', 9, 'Enable ''Gay Males Only'' group', 'checkbox', '', '', 19, ''),
('sys_ps_group_20_title', 'Gay Males Only', 9, 'Title for ''Gay Males Only'' group', 'digit', '', '', 20, ''),

('sys_ps_enabled_group_21', 'on', 9, 'Enable ''Lesbians Only'' group', 'checkbox', '', '', 21, ''),
('sys_ps_group_21_title', 'Lesbians Only', 9, 'Title for ''Lesbians Only'' group', 'digit', '', '', 22, ''),

('sys_ps_enabled_group_22', 'on', 9, 'Enable ''BiSexual Males Only'' group', 'checkbox', '', '', 23, ''),
('sys_ps_group_22_title', 'BiSexual Males Only', 9, 'Title for ''BiSexual Males Only'' group', 'digit', '', '', 24, '');

('sys_ps_enabled_group_23', 'on', 9, 'Enable ''BiSexual Females Only'' group', 'checkbox', '', '', 25, ''),
('sys_ps_group_23_title', 'BiSexual Females Only', 9, 'Title for ''BiSexual Females Only'' group', 'digit', '', '', 26, '');

('sys_ps_enabled_group_24', 'on', 9, 'Enable ''Tranny Only'' group', 'checkbox', '', '', 27, ''),
('sys_ps_group_24_title', 'Tranny Only', 9, 'Title for ''Tranny Only'' group', 'digit', '', '', 28, '');
");


db_res("
INSERT INTO `sys_privacy_groups` (`id`, `owner_id`, `parent_id`, `title`, `home_url`, `get_parent`, `get_content`, `members_count`) VALUES
(18, 0, 0, '', '', '', '\$aProfile = getProfileInfo((int)\$_COOKIE[''memberID'']);return (\$aProfile === false) ? false : (\$aProfile[''Sex'']==''male'');', 0),

(19, 0, 0, '', '', '', '\$aProfile = getProfileInfo((int)\$_COOKIE[''memberID'']);return (\$aProfile === false) ? false : (\$aProfile[''Sex'']==''female'');', 0),

(20, 0, 0, '', '', '', '\$aProfile = getProfileInfo((int)\$_COOKIE[''memberID'']);return (\$aProfile === false) ? false : (\$aProfile[''Sex'']==''gaymale'');', 0),

(21, 0, 0, '', '', '', '\$aProfile = getProfileInfo((int)\$_COOKIE[''memberID'']);return (\$aProfile === false) ? false : (\$aProfile[''Sex'']==''lesbian'');', 0),

(22, 0, 0, '', '', '', '\$aProfile = getProfileInfo((int)\$_COOKIE[''memberID'']);return (\$aProfile === false) ? false : (\$aProfile[''Sex'']==''bimale'');', 0),

(23, 0, 0, '', '', '', '\$aProfile = getProfileInfo((int)\$_COOKIE[''memberID'']);return (\$aProfile === false) ? false : (\$aProfile[''Sex'']==''bifemale'');', 0),

(24, 0, 0, '', '', '', '\$aProfile = getProfileInfo((int)\$_COOKIE[''memberID'']);return (\$aProfile === false) ? false : (\$aProfile[''Sex'']==''tranny'');', 0),
");

echo "FINISHED <br />";

 

When I run it i get the following error

Mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('sys_ps_enabled_group_23', 'on', 9, 'Enable ''BiSexual Females Only'' group', '' at line 17

Found error in the file '/home/myadult/public_html/sqlinstall.php' at line 70.
Called 'db_res' function with erroneous argument #0.

Any help to correct this will be greatly appreciated.  Smile

Quote · 21 Jan 2011

Remove the comma at the end of this line :

(24, 0, 0, '', '', '', '\$aProfile = getProfileInfo((int)\$_COOKIE[''memberID'']);return (\$aProfile === false) ? false : (\$aProfile[''Sex'']==''tranny'');', 0),

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 21 Jan 2011

I still got the same error message after doing your change....  Frown

Quote · 21 Jan 2011

Hello why don't you go to redefined values and make Orientation

lesbian

bisexual

transgender

ect

ect

Add this to profile fields for members to choose options.

Then you will have this option to add for extra privacy just like adding sex you can add orientation.

 

Jennifer

Jennifer Bogan .. Acc. Dip. Psychology - EMAIL: jennifer.bogan@gmail.com
Quote · 19 Jun 2011

replace with this

 

db_res("
INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`, `AvailableValues`) VALUES
('sys_ps_enabled_group_18', 'on', 9, 'Enable ''Males Only'' group', 'checkbox', '', '', 15, ''),
('sys_ps_group_18_title', 'Males Only', 9, 'Title for ''Males Only'' group', 'digit', '', '', 16, ''),

('sys_ps_enabled_group_19', 'on', 9, 'Enable ''Females Only'' group', 'checkbox', '', '', 17, ''),
('sys_ps_group_19_title', 'Females Only', 9, 'Title for ''Females Only'' group', 'digit', '', '', 18, ''),

('sys_ps_enabled_group_20', 'on', 9, 'Enable ''Gay Males Only'' group', 'checkbox', '', '', 19, ''),
('sys_ps_group_20_title', 'Gay Males Only', 9, 'Title for ''Gay Males Only'' group', 'digit', '', '', 20, ''),

('sys_ps_enabled_group_21', 'on', 9, 'Enable ''Lesbians Only'' group', 'checkbox', '', '', 21, ''),
('sys_ps_group_21_title', 'Lesbians Only', 9, 'Title for ''Lesbians Only'' group', 'digit', '', '', 22, ''),

('sys_ps_enabled_group_22', 'on', 9, 'Enable ''BiSexual Males Only'' group', 'checkbox', '', '', 23, ''),
('sys_ps_group_22_title', 'BiSexual Males Only', 9, 'Title for ''BiSexual Males Only'' group', 'digit', '', '', 24, ''),

('sys_ps_enabled_group_23', 'on', 9, 'Enable ''BiSexual Females Only'' group', 'checkbox', '', '', 25, ''),
('sys_ps_group_23_title', 'BiSexual Females Only', 9, 'Title for ''BiSexual Females Only'' group', 'digit', '', '', 26, ''),

('sys_ps_enabled_group_24', 'on', 9, 'Enable ''Tranny Only'' group', 'checkbox', '', '', 27, ''),
('sys_ps_group_24_title', 'Tranny Only', 9, 'Title for ''Tranny Only'' group', 'digit', '', '', 28, '');
");


db_res("
INSERT INTO `sys_privacy_groups` (`id`, `owner_id`, `parent_id`, `title`, `home_url`, `get_parent`, `get_content`, `members_count`) VALUES
(18, 0, 0, '', '', '', '\$aProfile = getProfileInfo((int)\$_COOKIE[''memberID'']);return (\$aProfile === false) ? false : (\$aProfile[''Sex'']==''male'');', 0),

(19, 0, 0, '', '', '', '\$aProfile = getProfileInfo((int)\$_COOKIE[''memberID'']);return (\$aProfile === false) ? false : (\$aProfile[''Sex'']==''female'');', 0),

(20, 0, 0, '', '', '', '\$aProfile = getProfileInfo((int)\$_COOKIE[''memberID'']);return (\$aProfile === false) ? false : (\$aProfile[''Sex'']==''gaymale'');', 0),

(21, 0, 0, '', '', '', '\$aProfile = getProfileInfo((int)\$_COOKIE[''memberID'']);return (\$aProfile === false) ? false : (\$aProfile[''Sex'']==''lesbian'');', 0),

(22, 0, 0, '', '', '', '\$aProfile = getProfileInfo((int)\$_COOKIE[''memberID'']);return (\$aProfile === false) ? false : (\$aProfile[''Sex'']==''bimale'');', 0),

(23, 0, 0, '', '', '', '\$aProfile = getProfileInfo((int)\$_COOKIE[''memberID'']);return (\$aProfile === false) ? false : (\$aProfile[''Sex'']==''bifemale'');', 0),

(24, 0, 0, '', '', '', '\$aProfile = getProfileInfo((int)\$_COOKIE[''memberID'']);return (\$aProfile === false) ? false : (\$aProfile[''Sex'']==''tranny'');', 0);
");

echo "FINISHED <br />";

hope it work for you

if i did help you .. it wont hurt to go to my profile and add a recommendation for me ;)
Quote · 19 Jun 2011
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.