Thread: Installation of New Check List on Join Form

I am trying to add another check list to the join form and no matter what I do keep getting errors. This is one of the errors.(#1062 - Duplicate entry '255' for key 1 ) 255 is state!
I have posted the code I am using below.
Smoge...If you are listening...I pay to have this fixed.
Any ideas anyone? I suspect the code for the profiledescript is no correct but I cannot find the error????? It may be that the primary key field is to small but I am not sure..

Thanks
Todd



INSERT INTO `ProfilesDesc` ( `ID` , `name` , `namedisp` , `namenote` , `extra` , `type` , `order` , `join_page` , `profile_type` , `visible` , `editable` , `check` , `because` , `group_mark` , `group_text_b` , `group_text_a` , `to_db` , `show_on_page` , `get_value` , `get_value_db` , `search_type` , `search_cols` , `search_hide` , `search_extra` , `search_order` , `search_default` , `search_where` , `match_field`, `match_type` , `match_extra` , `min_length` , `max_length` )
VALUES ('8000', 'Fetishes', 'Fetishes', '', 'global $prof; return $prof[fetishes];', 'set', '56.1', '1056.1', 'single', 'user,memb,adm', 'memb,adm', '', '', '', '', '', '1', '3', '', '', 'set', '3', '1', '', '10.1', '', '', '', 'none', '', '', '');


ALTER TABLE `Profiles` ADD `Fetishes` smallint(5) unsigned NOT NULL default '0';
ALTER TABLE `Profiles` ADD INDEX `Fetishes`(`Fetishes`);




INSERT INTO `LocalizationCategories` (`ID` , `Name`) VALUES (8000, 'Fetishes');

INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8000, 1, 'Fetishes');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8001, 1, 'Abduction');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8002, 1, 'Anal_Dilation');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8003, 1, 'Anal_Sex');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8004, 1, 'Asphyxiation');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8005, 1, 'Ass_Play');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8006, 1, 'Begging');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8007, 1, 'Biting');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8008, 1, 'Blind_Folds');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8009, 1, 'Blood_Sports');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8010, 1, 'Body_Modification');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8011, 1, 'Body_Painting');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8012, 1, 'Body_Worship');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8013, 1, 'Bondage');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8014, 1, 'Branding');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8015, 1, 'Breast_Play');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8016, 1, 'Butler_Maid');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8017, 1, 'Cages');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8018, 1, 'Canes');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8019, 1, 'CBT');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8020, 1, 'Chastity_Belts');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8021, 1, 'Chocking');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8022, 1, 'Clamping');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8023, 1, 'Collars');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8024, 1, 'Confinement');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8025, 1, 'Corner_Time');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8026, 1, 'Corsets');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8027, 1, 'Crops');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8028, 1, 'Crossdressing');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8029, 1, 'Cupping_Suction');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8030, 1, 'Diapers');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8031, 1, 'Discipline');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8032, 1, 'Dress_Control');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8033, 1, 'Electrical_Play');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8034, 1, 'Enemas');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8035, 1, 'Exhibitionism');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8036, 1, 'Eye_Contact_Control');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8037, 1, 'Face_Slapping');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8038, 1, 'Feet');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8039, 1, 'Fire_Play');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8040, 1, 'Fisting');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8041, 1, 'Food_Restrictions');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8042, 1, 'Foot_Worship');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8043, 1, 'Fucking_Machines');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8044, 1, 'Gags');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8045, 1, 'Garter_Belts');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8046, 1, 'Gas_Masks');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8047, 1, 'Genital_Torture');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8048, 1, 'Hair_Pulling');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8049, 1, 'Hoods');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8050, 1, 'Housework');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8051, 1, 'Humiliation');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8052, 1, 'Hypnosis');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8053, 1, 'Knife_Play');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8054, 1, 'Lace');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8055, 1, 'Latex');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8056, 1, 'Leashes');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8057, 1, 'Leather');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8058, 1, 'Masks');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8059, 1, 'Medical_Play');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8060, 1, 'Mental_Bondage');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8061, 1, 'Needle_Play');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8062, 1, 'Nipple_Torture');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8063, 1, 'Objectification');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8064, 1, 'Orgasm_Control');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8065, 1, 'Outdoor_Bondage');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8066, 1, 'Penis_Pumping');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8067, 1, 'Piercings');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8068, 1, 'Plastic_Wrap');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8069, 1, 'Pony_Play');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8070, 1, 'Public_Nudity');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8071, 1, 'Public_Sex');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8072, 1, 'Puppy_Play');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8073, 1, 'Pussy_Pumping');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8074, 1, 'Role_Playing');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8075, 1, 'Role_Reversal');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8076, 1, 'Rubber');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8077, 1, 'Scat');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8078, 1, 'Sensory_Deprivation');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8079, 1, 'Shoes');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8080, 1, 'Spanking');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8081, 1, 'Stockings_Nylons');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8082, 1, 'Suspension');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8083, 1, 'Tattoos');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8084, 1, 'Tickling');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8085, 1, 'Vaginal_Dilation');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8086, 1, 'Vibrators');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8087, 1, 'Water_Sports');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8088, 1, 'Wax_Play');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8089, 1, 'Whipping_Single_Tail');
INSERT INTO `LocalizationStrings` (`IDKey` , `IDLanguage` , `String`) VALUES (8090, 1, 'Whips_All');





INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8000, 300, '_fetishes');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8001, 100, '_Abduction');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8002, 100, '_Anal_Dilation');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8003, 100, '_Anal_Sex');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8004, 100, '_Asphyxiation');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8005, 100, '_Ass_Play');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8006, 100, '_Begging');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8007, 100, '_Biting');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8008, 100, '_Blind_Folds');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8009, 100, '_Blood_Sports');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8010, 100, '_Body_Modification');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8011, 100, '_Body_Painting');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8012, 100, '_Body_Worship');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8013, 100, '_Bondage');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8014, 100, '_Branding');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8015, 100, '_Breast_Play');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8016, 100, '_Butler_Maid');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8017, 100, '_Cages');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8018, 100, '_Canes');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8019, 100, '_CBT');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8020, 100, '_Chastity_Belts');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8021, 100, '_Chocking');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8022, 100, '_Clamping');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8023, 100, '_Collars');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8024, 100, '_Confinement');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8025, 100, '_Corner_Time');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8026, 100, '_Corsets');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8027, 100, '_Crops');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8028, 100, '_Crossdressing');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8029, 100, '_Cupping_Suction');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8030, 100, '_Diapers');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8031, 100, '_Discipline');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8032, 100, '_Dress_Control');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8033, 100, '_Electrical_Play');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8034, 100, '_Enemas');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8035, 100, '_Exhibitionism');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8036, 100, '_Eye_Contact_Control');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8037, 100, '_Face_Slapping');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8038, 100, '_Feet');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8039, 100, '_Fire_Play');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8040, 100, '_Fisting');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8041, 100, '_Food_Restrictions');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8042, 100, '_Foot_Worship');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8043, 100, '_Fucking_Machines');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8044, 100, '_Gags');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8045, 100, '_Garter_Belts');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8046, 100, '_Gas_Masks');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8047, 100, '_Genital_Torture');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8048, 100, '_Hair_Pulling');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8049, 100, '_Hoods');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8050, 100, '_Housework');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8051, 100, '_Humiliation');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8052, 100, '_Hypnosis');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8053, 100, '_Knife_Play');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8054, 100, '_Lace');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8055, 100, '_Latex');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8056, 100, '_Leashes');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8057, 100, '_Leather');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8058, 100, '_Masks');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8059, 100, '_Medical_Play');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8060, 100, '_Mental_Bondage');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8061, 100, '_Needle_Play');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8062, 100, '_Nipple_Torture');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8063, 100, '_Objectification');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8064, 100, '_Orgasm_Control');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8065, 100, '_Outdoor_Bondage');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8066, 100, '_Penis_Pumping');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8067, 100, '_Piercings');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8068, 100, '_Plastic_Wrap');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8069, 100, '_Pony_Play');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8070, 100, '_Public_Nudity');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8071, 100, '_Public_Sex');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8072, 100, '_Puppy_Play');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8073, 100, '_Pussy_Pumping');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8074, 100, '_Role_Playing');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8075, 100, '_Role_Reversal');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8076, 100, '_Rubber');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8077, 100, '_Scat');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8078, 100, '_Sensory_Deprivation');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8079, 100, '_Shoes');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8080, 100, '_Spanking');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8081, 100, '_Stockings_Nylons');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8082, 100, '_Suspension');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8083, 100, '_Tattoos');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8084, 100, '_Tickling');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8085, 100, '_Vaginal_Dilation');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8086, 100, '_Vibrators');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8087, 100, '_Water_Sports');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8088, 100, '_Wax_Play');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8089, 100, '_Whipping_Single_Tail');
INSERT INTO `LocalizationKeys` (`ID` , `IDCategory` , `Key`) VALUES (8090, 100, '_Whips_All');

Ok....I guess 20 some hours of melting in front of the screen had gotten to me... Ignore the below post..Total bs...I do not know what I was thinking. I coded and entered all that I need by hand.
If anyone would like to know how to add a searchable list to your site, (see
http://CageMe.com/join_form.php. for an example - Our list is quite long but it is what our members wanted) pm me or I will post the steps here...If Smoge doesn't care..
I am documenting the process that I used to create the list and have it be searchable.
I will post it here when I am finished.. ...You can add whatever type of list/catagory/profile field you like to your join page. It's just 2 easy steps (after your code your field) in MySQL using your phpAdMin. The ae admin panel is ...well..we all know what it is...If you have ever used the ae admin panel to try this you know what I mean.
Sorry for the brain dead post.
This is working on 4.1.2 ae3 perfectly.
Peace
Todd

Originally Posted by Prometheus

I will post the steps here...If Smoge doesn't care..

This would be great - posting it.

There was in the FAQ a post about adding states to pre-version 4.1.1 (with a lang file, not database) - but it could use some updates for the language database entries.... and whatever else you had to deal with / enhance.

Smoge

I shouldn't have to say this but backup your data first.

Then come up with a check list name and the options to check like below.
If you are going to list your choices on the search page in 3 columns like we have done you might want to create a list that is evenly divisable by 3 so your output looks clean and neat. We have 60 choices so we have 3 columns of 20. see http://cageme.com/search.php

Fetishes ( this is the Check list Title)

Abduction
Anal_Dilation
Anal_Sex
Asphyxiation
Ass_play
Beatings
Begging
Biting
Blind_Folds
Blood_Sports
Body_Modification
Body_Painting



Then alter your prfiles table to add the new field


ALTER TABLE `Profiles` ADD `Fetishes` smallint(5) unsigned NOT NULL default '0';
ALTER TABLE `Profiles` ADD INDEX `Fetishes`(`Fetishes`);

I used this code because it is already written. If you use this code you will have to edit your profiles table structure and change the type to set and enter the string you used to create the row in profiledesc or it will not save the changes or be searchable when someone updates their profile. If you need more info pm me.


Then convert your list into a string ready to be inserted into the new ProfileDesc row.


'Abduction','Anal_Dilation','Anal_Sex','Asphyxiati on','Ass_Play','Begging','Biting','Blind_Folds','B lood_Sports','Body_Modification','Body_Painting'



Go to phpMyAdmin, go to your database, go to ProfileDesc, go to the last page and at the bottom there is a link to "Insert a new row" click on this to insert a new row.
Tailor your enteries in the new row after what we have done (see attached)
You do not have to use 8000 for the ID you can use any number not used. We choose this to ensure there would not interfere with any other ID. Big gaps....lol...

We inserted our check list after relationship and before ideal match. If you wish to have the list appear some where else you will have to edit the order float, join_page float and ther search_order float number to reflect the location where you want the list to appear. This is dependant on the order "id" number. We wanted our list to appear after body type so we gave our list the order of 56.1. So it would appear after order 47 body type.
We also display our list in 3 columns on the search page. This is the search_cols int(11) field. You can edit which pages it is visable on "show on page" and who may see
"visible set' and edit "editable set" this field. After you have entered all the data in the fields click the go button and your almost done.

Next you have to edit your lang file.
This is what I looks like for the above example




'_Fetishes' => 'I like',
'_Abduction' => 'Abduction',
'_Anal_Dilation' => 'Anal Dilation',
'_Anal_Sex' => 'Anal Sex',
'_Asphyxiation' => 'Asphyxiation',
'_Ass_Play' => 'Ass Play',
'_Begging' => 'Begging',
'_Biting' => 'Biting',
'_Blind_Folds' => 'Blind Folds',
'_Blood_Sports' => 'Blood Sports',
'_Body_Modification' => 'Body Modification',
'_Body_Painting' => 'Body Painting',
'_Body_Worship' => 'Body Worship',
'_Bondage' => 'Bondage',
'_Branding' => 'Branding',
'_Breast_Play' => 'Breast Play',
'_Butler_Maid' => 'Butler Maid',
'_Cages' => 'Cages',
'_Canes' => 'Canes',
'_CBT' => 'CBT',

This is working perfectly in 4.1.2 ae3.
If you have any questions pm me.
Enjoy.
Todd

Sorry,
I guess I was really tired when I posted this.
Here is the correct code

ALTER TABLE `Profiles` ADD `Fetishes`;
ALTER TABLE `Profiles` ADD INDEX `Fetishes`(`Fetishes`);