*

LightBulb

"AA" apearing in address profile
« on: June 21, 2013, 06:14:35 PM »
Is there a way to stop AA appearing in the address profile that appears if county and state are set to "accept No" ?
« Last Edit: January 05, 2015, 06:44:20 AM by Pharg »

Re: "AA" apearing in address profile
« Reply #1 on: December 05, 2013, 09:31:10 PM »
How come no one has answered this question? I have the same problem too!

*

Pharg

  • *****
  • 2,065
  • osDate Version: osDate Evo v1.0
Re: "AA" apearing in address profile
« Reply #2 on: December 06, 2013, 06:00:23 AM »
Hi LightBulb,

Go into the admin global settings, Global Configurations > User Controls

Find:
Accept county/district?   Y change to N and save   
County/district to be made mandatory field?   Y change to N  and save that should fix it.

Is there a way to stop "AA" appearing in the address profile that appears if county and state are set to "accept No" ?
Regards,
Pharg ( Phill )

REMEMBER: ALWAYS BACKUP BEFORE YOU MAKE ANY CHANGES!!

osDateEvo v1.0 | PHP: 5.3.42 & PHP: 5.6.18 | MySQL: 5.5.35

Re: "AA" apearing in address profile
« Reply #3 on: February 17, 2014, 05:22:24 AM »
I have Accept and Mandatory set to N and I have left the default blank for both county and state. The system still assigns AA for both on new signups.

So the members profile reads like this for location:  AA,AA,Country

Have a fix?

MTL

osdate 2.6  php 5.3

*

pimpi4life

  • *
  • 10
  • im a webdesigner / webmaster
Re: "AA" apearing in address profile
« Reply #4 on: April 01, 2014, 06:45:15 PM »
i have the same problem cant get rid of the AA

its really annoying how can we fix this im using osdate 2.6
PHP Version 5.4.26
Build Date    Mar 16 2014 00:22:21

Re: "AA" apearing in address profile
« Reply #5 on: April 02, 2014, 12:43:28 PM »
Here you go. Always keep a backup of the original.

Re: "AA" apearing in address profile
« Reply #6 on: July 19, 2015, 09:36:23 AM »
can you tell me what you have changed ?
i have modded mine so when i put this in my root a lot will be changed

*

Pharg

  • *****
  • 2,065
  • osDate Version: osDate Evo v1.0
Re: "AA" apearing in address profile
« Reply #7 on: July 19, 2015, 09:43:27 AM »
Download it and do a file compare with WinMerge software
Regards,
Pharg ( Phill )

REMEMBER: ALWAYS BACKUP BEFORE YOU MAKE ANY CHANGES!!

osDateEvo v1.0 | PHP: 5.3.42 & PHP: 5.6.18 | MySQL: 5.5.35

Re: "AA" apearing in address profile
« Reply #8 on: July 19, 2015, 10:00:58 AM »
i checked that and if i use that i will not get the city where someone is living

$user = $osDB->getRow('SELECT id, username , level, country , firstname , lastname, gender , lookgender,  lastvisit, about_me, couple_usernames,
      picture , floor((to_days(curdate())-to_days(birth_date))/365.25)  as age
      FROM ! WHERE id = ? AND status = ?' ,array( USER_TABLE, $_REQUEST['id'], 'active' ));

When i put city in it
$user = $osDB->getRow('SELECT id, username , level, country , firstname , lastname, gender , lookgender, lastvisit, about_me, couple_usernames,
      picture , city , county, floor((to_days(curdate())-to_days(birth_date))/365.25)  as age
      FROM ! WHERE id = ? AND status = ?' ,array( USER_TABLE, $_REQUEST['id'], 'active' ));

i get the following error
Input Array does not match ?: select name from osdate_cities where countrycode = 'NL' and statecode = 'Meppel' and code =
 Meppel,  Netherlands

and i want to have showed the city but not the state
« Last Edit: July 19, 2015, 10:07:23 AM by Wim77 »