Find Jobs
Hire Freelancers

Skadate Genders

$30-60 USD

Cancelled
Posted about 12 years ago

$30-60 USD

Paid on delivery
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 '[login to view URL]' 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/[login to view URL] 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.
Project ID: 1557359

About the project

6 proposals
Remote project
Active 12 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
6 freelancers are bidding on average $38 USD for this job
User Avatar
Respected Sir, Lets start it Please check the message box Regards Ashwin
$50 USD in 0 day
5.0 (218 reviews)
7.3
7.3
User Avatar
Hi, Let us fix these right now. Please see the PM. Thanks Harish.
$40 USD in 1 day
5.0 (78 reviews)
6.3
6.3
User Avatar
Hi, let start now
$30 USD in 1 day
4.9 (77 reviews)
6.2
6.2
User Avatar
Hi! I'm interested on the job! Best!
$50 USD in 0 day
4.3 (11 reviews)
5.4
5.4
User Avatar
Hi, I can do it for you.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm interested in this job. I have many experiences with bug fixing of php/mysql applications.
$30 USD in 0 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of TURKEY
Tepebasi, Turkey
5.0
9
Payment method verified
Member since Mar 4, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.