From 23d7eab76104a44a70702f8fcc612f7ffe88a615 Mon Sep 17 00:00:00 2001 From: friendica Date: Tue, 2 Jul 2013 22:22:13 -0700 Subject: age was not syncing to the directory --- include/zot.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'include/zot.php') diff --git a/include/zot.php b/include/zot.php index f10a02d47..ea80ebc1d 100644 --- a/include/zot.php +++ b/include/zot.php @@ -1328,6 +1328,7 @@ function import_directory_profile($hash,$profile) { $x = q("update xprof set xprof_desc = '%s', xprof_dob = '%s', + xprof_age = %d xprof_gender = '%s', xprof_marital = '%s', xprof_sexual = '%s', @@ -1339,6 +1340,7 @@ function import_directory_profile($hash,$profile) { where xprof_hash = '%s' limit 1", dbesc($arr['xprof_desc']), dbesc($arr['xprof_dob']), + intval($arr['xprof_age']), dbesc($arr['xprof_gender']), dbesc($arr['xprof_marital']), dbesc($arr['xprof_sexual']), @@ -1353,10 +1355,11 @@ function import_directory_profile($hash,$profile) { } else { $update = true; - $x = q("insert into xprof (xprof_hash, xprof_desc, xprof_dob, xprof_gender, xprof_marital, xprof_sexual, xprof_locale, xprof_region, xprof_postcode, xprof_country, xprof_keywords) values ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s') ", + $x = q("insert into xprof (xprof_hash, xprof_desc, xprof_dob, xprof_age, xprof_gender, xprof_marital, xprof_sexual, xprof_locale, xprof_region, xprof_postcode, xprof_country, xprof_keywords) values ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s') ", dbesc($arr['xprof_hash']), dbesc($arr['xprof_desc']), dbesc($arr['xprof_dob']), + intval($arr['xprof_age']), dbesc($arr['xprof_gender']), dbesc($arr['xprof_marital']), dbesc($arr['xprof_sexual']), -- cgit v1.2.3 From 2ecd5a763228fce8f7ca2f379edd4fdd3fd3f44c Mon Sep 17 00:00:00 2001 From: friendica Date: Tue, 2 Jul 2013 22:29:24 -0700 Subject: missing comma --- include/zot.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'include/zot.php') diff --git a/include/zot.php b/include/zot.php index ea80ebc1d..2e3b01149 100644 --- a/include/zot.php +++ b/include/zot.php @@ -1328,7 +1328,7 @@ function import_directory_profile($hash,$profile) { $x = q("update xprof set xprof_desc = '%s', xprof_dob = '%s', - xprof_age = %d + xprof_age = %d, xprof_gender = '%s', xprof_marital = '%s', xprof_sexual = '%s', -- cgit v1.2.3 From fd74c5b2ce303ba7018b139c033c6f92ea134751 Mon Sep 17 00:00:00 2001 From: friendica Date: Tue, 2 Jul 2013 22:41:17 -0700 Subject: really, truly fix the age missing in directory bug --- include/zot.php | 1 - 1 file changed, 1 deletion(-) (limited to 'include/zot.php') diff --git a/include/zot.php b/include/zot.php index 2e3b01149..f9b40c06f 100644 --- a/include/zot.php +++ b/include/zot.php @@ -1312,7 +1312,6 @@ function import_directory_profile($hash,$profile) { $arr['xprof_keywords'] = implode(' ',$clean); - $r = q("select * from xprof where xprof_hash = '%s' limit 1", dbesc($hash) ); -- cgit v1.2.3