Dibatalkan

Skadate Genders

I have skadate dating software. And There's a bug in the software.

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

--------------------------------

And then:

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.

Kemahiran: AJAX, Pentarikhan, Javascript, MySQL, PHP

Lihat lebih lanjut: female members, solve php error, skadate, Males, php javascript class, skadate mysql, male column, php detect system, online bug system, skadate dating profiles, php mysql error unknown column, javascript extend, php quick profile, dating profiles mysql, sex male, need female profile, male members dating, skadate software, unknown column php, query javascript select, online query, sex female, unknown column admin clause, skadate birthdate, class dating

Tentang Majikan:
( 9 ulasan ) Tepebasi, Turkey

ID Projek: #1557359

6 pekerja bebas membida secara purata $38 untuk pekerjaan ini

gslogics123

Respected Sir, Lets start it Please check the message box Regards Ashwin

$50 USD dalam 0 hari
(218 Ulasan)
7.3
harish1984

Hi, Let us fix these right now. Please see the PM. Thanks Harish.

$40 USD dalam sehari
(78 Ulasan)
6.3
developershut

Hi, let start now

$30 USD dalam sehari
(77 Ulasan)
6.2
neliobuchadas

Hi! I'm interested on the job! Best!

$50 USD dalam 0 hari
(11 Ulasan)
5.4
blanking

Hi, I can do it for you.

$30 USD dalam sehari
(0 Ulasan)
0.0
hribek

Hi, I'm interested in this job. I have many experiences with bug fixing of php/mysql applications.

$30 USD dalam 0 hari
(0 Ulasan)
0.0