Skadate Genders Modification And Bug

I have skadate dating software.

What I want:

1-Firstly, This bug should be fixed.

When I enable this in admin area "Members can see only profiles of preferred sex in Profile lists" in additional settings, the site gives a error. This problem need to solve. And certainly the females members won't see each other in the site, in the same way, also the males members won't see each other in the site.

the error is:

Warning: MySQL error: Unknown column '[url removed, login to view]' in 'where clause'

in query: SELECT COUNT( `main`.`profile_id` ) FROM `skadate_profile` AS `main` LEFT JOIN `skadate_profile_extended` AS `extend` USING( `profile_id` ) LEFT JOIN `skadate_profile_online` AS `online` USING( `profile_id` ) WHERE 1 AND `main`.`profile_id` NOT IN ( SELECT `blocked_id` FROM `skadate_profile_block_list` WHERE `profile_id` =1 ) AND YEAR('2012-02-27 03:12:38')-YEAR(`birthdate`)- IF( DAYOFYEAR(`birthdate`) >= DAYOFYEAR('2012-02-27 03:12:38'),1,0) >= 20 AND YEAR('2012-02-27 03:12:38')-YEAR(`birthdate`)-IF( DAYOFYEAR(`birthdate`) >= DAYOFYEAR('2012-02-27 03:12:38'),1,0) <=102 AND SUBSTRING_INDEX( `match_agerange`, '-', 1 ) <= 25 AND SUBSTRING_INDEX( `match_agerange`, '-', -1 ) >= 25 AND ( 2&IF( ISNULL(`match_sex`) OR `match_sex`=0, 0xffffffffffffffff, `match_sex` ) AND 1&IF( ISNULL(`sex`) OR `sex`=0, 0xffffffffffffffff, `sex` ) ) AND ( `main`.`status`='active' ) AND `main in /home/site/public_html/site1/internals/SK6_inc/[url removed, login to view] on line 299


2- The modifications should make real in the site.

So, my site is religion site. It must not ask to the members "looking for male or famale" fields in join. So, when the members select to their gender, system should detect the gender and If the member select the male, it should detect and show famales members. And If the member select the female, it should detect and show males members. And CERTAINLY the females members won't see each other in the site, in the same way, also the males members won't see each other in the site. And also system must not ask to members their gender in search and quick search. It should detect automatically genders. I want to remove "looking for maile or famale". System should detect automatically. If the member is a male, he should reach to only famales in the site. If the member is famale, she should reach to only males in the site. The gender should be asked only in the join page. and then the gender should not be asked in the site (search page etc.)

Kemahiran: AJAX, Pentarikhan, Javascript, MySQL, PHP

Lihat lagi: skadate birthdate, skadate problem join year, female members, solve php error, skadate, Males, c# bug, c bug, php javascript class, skadate mysql, male column, javascript page modifications, php detect system, online bug system, skadate dating profiles, javascript select remove, error bug, php mysql error unknown column, dating site real members, javascript extend, bug problem, php quick profile, bug fixed, dating profiles mysql, sex male

Tentang Majikan:
( 9 ulasan ) Tepebasi, Turkey

ID Projek: #1561191

4 pekerja bebas membida secara purata $81 untuk pekerjaan ini


Greetings! Thanks for the invite I just got home. I would love to assist you! I give you 99 days support even after you pay and review!

$100 USD dalam 99 hari
(151 Ulasan)

Hi We could do as per your requirement. u could check that out. we would work till your satisfaction. -- Please check inbox for our previous work.

$77 USD dalam sehari
(44 Ulasan)

Fix Gender selection in dating site.

$80 USD dalam sehari
(46 Ulasan)

Hi, I am ready.

$65 USD dalam sehari
(17 Ulasan)