<ensure variable="GLOBAL.att_family_default_for_iqtpi_get_client" value="0">
<if isdefined("att.family") AND (att.family EQ 1 OR att.family EQ 0)>
<var GLOBAL.att_family_default_for_iqtpi_get_client = att.family>
</if>
<ensure variable="att.family" value="#GLOBAL.att_family_default_for_iqtpi_get_client#">
<if att.family NEQ 1 AND att.family NEQ 0>
<var att.family = 0>
</if>

<if isdefined("GLOBAL.did_iqtpi_get_client_already_#att.family#") AND evaluate('GLOBAL.did_iqtpi_get_client_already_#att.family#') EQ 1 AND NOT ( isDefined("att.fresh") AND att.fresh EQ 1 )>
<BREAK>
</if>

<var "GLOBAL.did_iqtpi_get_client_already_#att.family#" = 1>




<var GLOBAL.Def.Client = QueryNew('id')>
<var _uid = client_id><fake_person><var _uid = 0></fake_person>
<var _extra = "">
<if att.family EQ 1>
<var _extra = ".i_ggk.i_gk.i_k.i_sibs.i_p.i_gp.i_ggp.i_sigs.i_students.i_classmates.i_teachers.i_bff">
</if>
<!--- whole

bunch

of

friggin

fields --->
<!---
Note:
- tables have |gutitles|
- sites have |gutitles|
- users have |id numbers|
--->
<var _fields = reReplace("
.so_lastupdated
.published_unsignedint
.account_complete_unsignedint
.emailoptout_protected
.acct_flavor_protected
.accounttype

.gender_protected
.organization
.dftoken

.location
.country
.address
.city
.state
.zip
.phone

.dfpledge_protected_double
.fav_charity_code_protected

.headline
.paragraph
.supports
.benefactors
.likes
.tagline
.keywords
.herefor
.website

.spsitecount_unsignedint
.spappcount_unsignedint


.dob_datetime
.iqtpi_agetype
.parentemail_protected

.spots.tables.sites.users.uindex
.iqtpi_protected

.invite_utoken_protected.outstanding_codes_protected.key_answer_protected_unsignedint.key_memo_protected_unsignedint.key_content_protected_unsignedint.key_profilepic_protected_unsignedint.goodquestions.badquestions

.email.potentialemail_protected.emails_protected

.balloon
.affiliations
.facts

.spf_share_protected.spf_rate_protected.spf_secretstory_protected.fname.spfcats.spfroutines
.joelie_protected
","[[:space:]]+","","all")>
<set j="/user-#_uid##_fields##_extra#" maxrows="1">
<var GLOBAL.Def.Client = set>
</set><!---
got rid of:
.ps
--->
<var GLOBAL.Def.client_idstr = client_id>
<if GLOBAL.Def.Client.recordcount GT 0 AND GLOBAL.Def.Client.gutitle NEQ "">
<var GLOBAL.Def.client_idstr = trim(lcase(GLOBAL.Def.Client.gutitle))>
</if>


<fake_person> <BREAK> </fake_person>


<!--- dftoken --->
<if reFindNoCase("^[A-Z0-9]{1,6}$",GLOBAL.Def.Client.dftoken) NEQ 1><!--- AND GLOBAL.Def.Client.accounttype NEQ "nonprofit" --->
<var _dftoken = create_df_utoken()>
<update orb="user" where="user.id = #client_id#"
dftoken="#_dftoken#">
<var QuerySetCell(GLOBAL.Def.Client,"dftoken",_dftoken)>
</if>


<!--- tables --->
<if GLOBAL.Def.Client.tables EQ "">
<var _tables = "|blog_post|#CHR(10)#|photo|#CHR(10)#|audio|#CHR(10)#|video|">
<update orb="user" where="user.id = #client_id#"
tables="#_tables#">
<var QuerySetCell(GLOBAL.Def.Client,"tables",_tables)>
</if>

<!--- tables --->
<if GLOBAL.Def.Client.sites EQ "">
<var _sites = "|iqtpi|">
<update orb="user" where="user.id = #client_id#"
sites="#_sites#">
<var QuerySetCell(GLOBAL.Def.Client,"sites",_sites)>
</if>





<!--- very basic info --->
<var GLOBAL.Def.did_finish_vbi = 1>
<if trim(GLOBAL.Def.Client.gutitle) EQ "" OR trim(GLOBAL.Def.Client.dob_datetime) EQ "">
<var GLOBAL.Def.did_finish_vbi = 0>
<tag.qz_def_try_to_fix_vbi>
</if>





<!--- age type --->
<var GLOBAL.Def.did_finish_agetype = 1>
<if listFindNoCase("kid,teen,grown_up,way_grown_up",GLOBAL.Def.Client.iqtpi_agetype) EQ 0>
<var GLOBAL.Def.did_finish_agetype = 0>
</if>
<var GLOBAL.Def.iqtpi_age_num = 1>
<if GLOBAL.Def.Client.iqtpi_agetype EQ "teen">
<var GLOBAL.Def.iqtpi_age_num = 2>
<elseif GLOBAL.Def.Client.iqtpi_agetype EQ "grown_up">
<var GLOBAL.Def.iqtpi_age_num = 3>
<elseif GLOBAL.Def.Client.iqtpi_agetype EQ "way_grown_up">
<var GLOBAL.Def.iqtpi_age_num = 4>
</if>
<!--- enforce data rules about age types: --->
<if GLOBAL.Def.Client.iqtpi_agetype EQ "kid">
<!--- "kid" users must have name same as gutitle --->
<if GLOBAL.Def.Client.name NEQ GLOBAL.Def.Client.gutitle>
<var _new = lcase(GLOBAL.Def.Client.gutitle)>
<update orb="user" where="user.id = #client_id#"
gutitle="#_new#"
name="#_new#">
<var QuerySetCell(GLOBAL.Def.Client,"gutitle",_new)>
<var QuerySetCell(GLOBAL.Def.Client,"name",_new)>
</if>
</if>
<var GLOBAL.Def.age_in_years = 21>
<try>
<var GLOBAL.Def.age_in_years = Abs(DateDiff("yyyy",Now(),GLOBAL.Def.Client.dob_datetime))>
<catch></catch>
</try>





<var GLOBAL.Def.did_finish_all_basics = 0>
<if GLOBAL.Def.did_finish_agetype EQ 1 AND GLOBAL.Def.did_finish_vbi EQ 1>
<var GLOBAL.Def.did_finish_all_basics = 1>
</if>




<if GLOBAL.Def.did_finish_all_basics EQ 1>

<!--- proper init of answer, memo, content keys --->
<if listFindNoCase(GLOBAL.Def.Client.iqtpi_protected,"keyvars_init_a","|#CHR(10)#") EQ 0>

<var _default_key_answer_protected_unsignedint = 1>
<var _default_key_memo_protected_unsignedint = 5>
<var _default_key_content_protected_unsignedint = 5>
<var _default_key_profilepic_protected_unsignedint = 5>
<if GLOBAL.Def.iqtpi_age_num LTE 1>
<var _default_key_answer_protected_unsignedint = 5>
<var _default_key_memo_protected_unsignedint = 9>
<var _default_key_content_protected_unsignedint = 9>
<var _default_key_profilepic_protected_unsignedint = 5>
</if>

<var _new_iqtpi_protected = GLOBAL.Def.Client.iqtpi_protected & CHR(10) & "|keyvars_init_a|">

<update orb="user" where="user.id = #client_id#"
key_answer_protected_unsignedint="#_default_key_answer_protected_unsignedint#"
key_memo_protected_unsignedint="#_default_key_memo_protected_unsignedint#"
key_content_protected_unsignedint="#_default_key_content_protected_unsignedint#"
key_profilepic_protected_unsignedint="#_default_key_profilepic_protected_unsignedint#"
iqtpi_protected="#_new_iqtpi_protected#">

<var QuerySetCell(GLOBAL.Def.Client,"key_answer_protected_unsignedint",_default_key_answer_protected_unsignedint)>
<var QuerySetCell(GLOBAL.Def.Client,"key_memo_protected_unsignedint",_default_key_memo_protected_unsignedint)>
<var QuerySetCell(GLOBAL.Def.Client,"key_content_protected_unsignedint",_default_key_content_protected_unsignedint)>
<var QuerySetCell(GLOBAL.Def.Client,"key_profilepic_protected_unsignedint",_default_key_profilepic_protected_unsignedint)>
<var QuerySetCell(GLOBAL.Def.Client,"iqtpi_protected",_new_iqtpi_protected)>

</if>

</if>