function add_fb_page_sub_category($sub_category) { if (!empty($sub_category)) { $id_sub_category = get_fb_page_sub_category($sub_category); if (empty($id_sub_category)) { $sub_category = mysql_real_escape_string($sub_category); $sql = "INSERT INTO facebook_page_sub_category VALUES(NULL, '{$sub_category}');"; $res = mysql_query($sql) or die(mysql_error()); if (mysql_affected_rows() > 0) { return mysql_insert_id(); } } else { return $id_sub_category; } } return NULL; }
$first_local_fans_country_audience = "NULL"; if (!empty($pages['first_local_fans_country'])) { $first_country_code = $countries[$pages['first_local_fans_country']]['code']; $first_country_name = $countries[$pages['first_local_fans_country']]['name']; $first_country_name_en = $countries[$pages['first_local_fans_country']]['name_en']; $first_local_fans_country_audience = $countries[$pages['first_local_fans_country']]['audience']; if (!in_array($pages['first_local_fans_country'], $id_country_uses)) { $id_country_uses[] = $pages['first_local_fans_country']; } } $idiom = "NULL"; if ($pages['hispanic'] == 1) { $idiom = "es"; } //Category $sub_category = get_fb_page_sub_category($id_page); $sub_category_id = $sub_category['id']; $sub_category_name = $sub_category['name']; //Subcategory $category = get_fb_page_category($sub_category_id); $category_id = $category['id']; $category_name = $category['name']; $general_ranking = 'NULL'; $first_local_fans_country_ranking = 'NULL'; $in_owloo_from = $pages['date_add']; $query = 'SELECT id_page FROM facebook_pages WHERE id_page = $10;'; $que_page = db_query_table_results($query, array($id_page)); if ($row = mysql_fetch_assoc($que_page)) { $query = "UPDATE facebook_pages SET \n parent = \$10,\n fb_id = \$11, \n username = '******', \n name = '\$13', \n about = " . ($about != "NULL" ? "'\$14'" : "\$14") . ",\n description = " . ($description != "NULL" ? "'\$15'" : "\$15") . ",\n link = '\$16',\n picture = '\$17',\n cover = " . ($cover != "NULL" ? "'\$18'" : "\$18") . ",\n is_verified = \$19, \n likes = \$20, \n likes_history_30 = '\$21',\n likes_grow_1 = \$22, \n likes_grow_7 = \$23, \n likes_grow_15 = \$24, \n likes_grow_30 = \$25, \n likes_grow_60 = \$26, \n talking_about = \$27, \n talking_about_history_30 = '\$28',\n talking_about_grow_1 = \$29, \n talking_about_grow_7 = \$30, \n talking_about_grow_15 = \$31, \n talking_about_grow_30 = \$32, \n talking_about_grow_60 = \$33,\n country_code = " . ($country_code != "NULL" ? "'\$34'" : "\$34") . ", \n country_name = " . ($country_name != "NULL" ? "'\$35'" : "\$35") . ", \n country_name_en = " . ($country_name_en != "NULL" ? "'\$36'" : "\$36") . ", \n first_country_code = " . ($first_country_code != "NULL" ? "'\$37'" : "\$37") . ", \n first_country_name = " . ($first_country_name != "NULL" ? "'\$38'" : "\$38") . ",\n first_country_name_en = " . ($first_country_name_en != "NULL" ? "'\$39'" : "\$39") . ", \n idiom = " . ($idiom != "NULL" ? "'\$40'" : "\$40") . ",\n category_id = \$41,\n category_name = " . ($category_name != "NULL" ? "'\$42'" : "\$42") . ",\n sub_category_id = \$43,\n sub_category_name = " . ($sub_category_name != "NULL" ? "'\$44'" : "\$44") . ",\n first_local_fans_country_audience = \$45,\n in_owloo_from = '\$46',\n updated_at = NOW()\n \n WHERE id_page = \$47;"; $values = array($parent, $fb_id, $username, $name, $about, $description, $link, $picture, $cover, $is_verified, $likes, $likes_history_30, $likes_grow_1, $likes_grow_7, $likes_grow_15, $likes_grow_30, $likes_grow_60, $talking_about, $talking_about_history_30, $talking_about_grow_1, $talking_about_grow_7, $talking_about_grow_15, $talking_about_grow_30, $talking_about_grow_60, $country_code, $country_name, $country_name_en, $first_country_code, $first_country_name, $first_country_name_en, $idiom, $category_id, $category_name, $sub_category_id, $sub_category_name, $first_local_fans_country_audience, $in_owloo_from, $id_page); $res = db_query_table_results($query, $values, 1);