$value) {
$variable[$i] = add_slashes_recursive($value);
}
}
return $variable ;
}
/**
* @deprecated Use WP's stripslashes_deep()
*/
function strip_slashes_recursive( $variable )
{
if ( is_string( $variable ) )
return stripslashes( $variable ) ;
if ( is_array( $variable ) )
foreach( $variable as $i => $value )
$variable[ $i ] = strip_slashes_recursive( $value ) ;
return $variable ;
}
function string_contains_string_at_position($haystack, $needle, $pos = 0, $case=true) {
if ($case) {
$result = (strpos($haystack, $needle, 0) === $pos);
} else {
$result = (stripos($haystack, $needle, 0) === $pos);
}
return $result;
}
function string_starts_with($haystack, $needle, $case=true) {
return string_contains_string_at_position($haystack, $needle, 0, $case);
}
function string_ends_with($haystack, $needle, $case=true) {
return string_contains_string_at_position($haystack, $needle, (strlen($haystack) - strlen($needle)), $case);
}
/**
* TODO: update to use newer Akismet functions.
*/
function awpcp_submit_spam($ad_id) {
if (function_exists('akismet_init')) {
$wpcom_api_key = get_option('wordpress_api_key');
if (!empty($wpcom_api_key)) {
require_once(ABSPATH . WPINC . '/pluggable.php');
_log("Now submitting ad " . $ad_id . " as spam");
global $wpdb, $akismet_api_host, $akismet_api_port, $current_user, $current_site;
$ad = AWPCP_Ad::find_by_id( (int) $ad_id );
if ( ! is_null( $ad ) ) {
if ( $ad->disabled == 1 ) {
_log("Ad " . $ad_id . " already marked as spam");
return;
}
$content = array();
_log("Ad " . $ad_id . " constructing Akismet call");
//Construct an Akismet-like query:
$content['user_ip'] = $ad->posterip;
$content['comment_author'] = $ad->ad_contact_name;
$content['comment_author_email'] = $ad->ad_contact_email;
$content['comment_author_url'] = $ad->websiteurl;
$content['comment_content'] = $ad->ad_details;
$content['blog'] = get_option('home');
$content['blog_lang'] = get_locale();
$content['blog_charset'] = get_option('blog_charset');
$content['permalink'] = '';
get_currentuserinfo();
if ( is_object($current_user) ) {
$content['reporter'] = $current_user->user_login;
}
if ( is_object($current_site) ) {
$content['site_domain'] = $current_site->domain;
}
$content['user_role'] = 'Editor'; // probably best to present the user with some level of authority
$query_string = '';
foreach ( $content as $key => $data ) {
$query_string .= $key . '=' . urlencode( stripslashes($data) ) . '&';
}
_log("Ad " . $ad_id . " query: " . $query_string);
$response = akismet_http_post($query_string, $akismet_api_host, "/1.1/submit-spam", $akismet_api_port);
_log("Ad " . $ad_id . " spammed, Akismet said: ");
foreach ($response as $key => $value) {
_log($key." - ".$value."");
}
} else {
_log("Ad " . $ad_id . " not found, cannot mark as spam");
}
} else {
global $message;
$message="
";
$message.=__("Please disable spam control on your AWPCP settings because you do not have Akismet properly configured (missing API key)","AWPCP");
$message.="
";
}
} else {
global $message;
$message="
";
$message.=__("Please disable spam control on your AWPCP settings because you do not have Akismet installed","AWPCP");
$message.="
";
}
}
//Function to detect spammy posts. Requires Akismet to be installed.
function awpcp_check_spam($name, $website, $email, $details) {
$content = array();
//Construct an Akismet-like query:
$content['comment_type'] = 'comment';
//$content['comment_author'] = $name; // don't send this, it reduces accuracy
$content['comment_author_email'] = $email;
//$content['comment_author_url'] = $website; // don't send this, it reduces accuracy
$content['comment_content'] = $details;
// innocent until proven guilty
$isSpam = FALSE;
if (function_exists('akismet_init')) {
$wpcom_api_key = get_option('wordpress_api_key');
if (!empty($wpcom_api_key)) {
global $akismet_api_host, $akismet_api_port;
// set remaining required values for akismet api
$content['user_ip'] = preg_replace( '/[^0-9., ]/', '', awpcp_getip() );
$content['user_agent'] = $_SERVER['HTTP_USER_AGENT'];
$content['referrer'] = get_option('home'); // use site home page instead of $_SERVER['HTTP_REFERER']; seems to work better
$content['blog'] = get_option('home');
//if (empty($content['referrer'])) {
// $content['referrer'] = get_permalink();
//}
$queryString = '';
foreach ($content as $key => $data) {
if (!empty($data)) {
$queryString .= $key . '=' . urlencode(stripslashes($data)) . '&';
}
}
$response = akismet_http_post($queryString, $akismet_api_host, '/1.1/comment-check', $akismet_api_port);
if ($response[1] == 'true') {
//update_option('akismet_spam_count', get_option('akismet_spam_count') + 1);
$isSpam = TRUE;
}
} else {
global $message;
$message="
";
$message.=__("Please disable spam control on your AWPCP settings because you do not have Akismet properly configured (missing API key)","AWPCP");
$message.="
";
}
} else {
global $message;
$message="
";
$message.=__("Please disable spam control on your AWPCP settings because you do not have Akismet installed","AWPCP");
$message.="
";
}
// Akismet says it's not spam or Akismet disabled? Check using the blacklisted words configured in WP, if any:
if ( !$isSpam)
$isSpam = wp_blacklist_check($name, $email, $website, $details, preg_replace( '/[^0-9., ]/', '', awpcp_getip() ), $_SERVER['HTTP_USER_AGENT']);
_log("Ad spam check final answer: " . $isSpam);
return $isSpam;
}
function awpcp_blacklist_check($author, $email, $url, $comment, $user_ip, $user_agent) {
// hook similar the related WP hook, lets people develop their own ad scanning filters
do_action('awpcp_blacklist_check', $author, $email, $url, $comment, $user_ip, $user_agent);
$mod_keys = trim( get_option('blacklist_keys') );
if ( '' == $mod_keys )
return false; // If no blacklist words are set then there's nothing to do here
$words = explode("\n", $mod_keys );
foreach ( (array) $words as $word ) {
$word = trim($word);
// Skip empty lines
if ( empty($word) ) { continue; }
// Do some escaping magic so that '#' chars in the spam words don't break things:
$word = preg_quote($word, '#');
$pattern = "#$word#i";
if (
preg_match($pattern, $author)
|| preg_match($pattern, $email)
|| preg_match($pattern, $url)
|| preg_match($pattern, $comment)
|| preg_match($pattern, $user_ip)
|| preg_match($pattern, $user_agent)
)
return true;
}
return false;
}
// START FUNCTION: retrieve individual options from settings table
function get_awpcp_setting($column, $option) {
global $wpdb;
$tbl_ad_settings = $wpdb->prefix . "awpcp_adsettings";
$myreturn=0;
$tableexists=checkfortable($tbl_ad_settings);
if($tableexists)
{
$query="SELECT ".$column." FROM ".$tbl_ad_settings." WHERE config_option='$option'";
$res = $wpdb->get_var($query);
$myreturn = strip_slashes_recursive($res);
}
return $myreturn;
}
function get_awpcp_option($option, $default='', $reload=false) {
return AWPCP_Settings_API::instance()->get_option($option, $default, $reload);
}
function get_awpcp_option_group_id($option) {
return get_awpcp_setting('config_group_id', $option);
}
function get_awpcp_option_type($option) {
return get_awpcp_setting('option_type', $option);
}
function get_awpcp_option_config_diz($option) {
return get_awpcp_setting('config_diz', $option);
}
// START FUNCTION: Check if the user is an admin
function checkifisadmin() {
return awpcp_current_user_is_admin() ? 1 : 0;
}
function awpcpistableempty($table){
global $wpdb;
$query = 'SELECT COUNT(*) FROM ' . $table;
$results = $wpdb->get_var( $query );
if ( $results !== false && intval( $results ) === 0 ) {
return true;
} else {
return false;
}
}
function awpcpisqueryempty($table, $where){
global $wpdb;
$query = 'SELECT COUNT(*) FROM ' . $table . ' ' . $where;
$count = $wpdb->get_var( $query );
if ( $count !== false && intval( $count ) === 0 ) {
return true;
} else {
return false;
}
}
function adtermsset(){
global $wpdb;
$myreturn = !awpcpistableempty(AWPCP_TABLE_ADFEES);
return $myreturn;
}
function categoriesexist(){
global $wpdb;
$tbl_categories = $wpdb->prefix . "awpcp_categories";
$myreturn=!awpcpistableempty($tbl_categories);
return $myreturn;
}
// END FUNCTION
function adtermidinuse($adterm_id)
{
global $wpdb;
$tbl_ads = $wpdb->prefix . "awpcp_ads";
$myreturn=!awpcpisqueryempty($tbl_ads, " WHERE adterm_id='$adterm_id'");
return $myreturn;
}
function countlistings($is_active) {
global $wpdb;
$query = 'SELECT COUNT(*) FROM ' . AWPCP_TABLE_ADS . ' WHERE disabled = %d';
$query = $wpdb->prepare( $query, $is_active ? false : true );
return $wpdb->get_var( $query );
}
function countcategories(){
return AWPCP_Category::query( array( 'fields' => 'count' ) );
}
function countcategoriesparents() {
$params = array(
'fields' => 'count',
'where' => 'category_parent_id = 0'
);
return AWPCP_Category::query( $params );
}
function countcategorieschildren(){
$params = array(
'fields' => 'count',
'where' => 'category_parent_id != 0'
);
return AWPCP_Category::query( $params );
}
// this way if user paid for ad user continues to be allowed number of images paid for
// START FUNCTION: Check to see how many images an ad is currently using
function get_total_imagesuploaded($ad_id) {
global $wpdb;
$query = "SELECT count(*) FROM " . AWPCP_TABLE_MEDIA . " WHERE ad_id=%d";
$images = absint( $wpdb->get_var( $wpdb->prepare( $query, $ad_id ) ) );
return $images;
}
// END FUNCTION
function awpcp_get_term_duration($adtermid) {
global $wpdb;
$query = 'SELECT rec_period, rec_increment FROM ' . AWPCP_TABLE_ADFEES . ' ';
$query.= 'WHERE adterm_id = %d';
$term = $wpdb->get_row($wpdb->prepare($query, $adtermid));
if (is_null($term)) {
return array();
}
$duration = $term->rec_period;
$increment = $term->rec_increment;
// a value of zero or less means "never expires" or in AWPCP
// terms: it will expire in 10 years
if ($duration <= 0) {
if ($increment == 'D') {
$duration = 3650;
} else if ($increment == 'W') {
$duration = 520;
} else if ($increment == 'M') {
$duration = 120;
} else if ($increment == 'Y') {
$duration = 10;
}
}
return array('duration' => $duration, 'increment' => $increment);
}
function get_adpostername($adid) {
return get_adfield_by_pk('ad_contact_name', $adid);
}
function get_adposteremail($adid) {
return get_adfield_by_pk('ad_contact_email', $adid);
}
function get_adstartdate($adid) {
return get_adfield_by_pk('ad_startdate', $adid);
}
// END FUNCTION
// START FUNCTION: Get the number of times an ad has been viewed
function get_numtimesadviewd($adid)
{
return get_adfield_by_pk('ad_views', $adid);
}
// END FUNCTION: Get the number of times an ad has been viewed
// START FUNCTION: Get the ad title based on having the ad ID
function get_adtitle($adid) {
return strip_slashes_recursive(get_adfield_by_pk('ad_title', $adid));
}
// START FUNCTION: Create list of top level categories for admin category management
function get_categorynameid($cat_id = 0,$cat_parent_id= 0,$exclude)
{
global $wpdb;
$optionitem='';
$tbl_categories = $wpdb->prefix . "awpcp_categories";
if(isset($exclude) && !empty($exclude))
{
$excludequery="AND category_id !='$exclude'";
}else{$excludequery='';}
$catnid=$wpdb->get_results("select category_id as cat_ID, category_parent_id as cat_parent_ID, category_name as cat_name from " . AWPCP_TABLE_CATEGORIES . " WHERE category_parent_id=0 AND category_name <> '' $excludequery");
foreach($catnid as $categories)
{
if($categories->cat_ID == $cat_parent_id)
{
$optionitem .= "";
}
else
{
$optionitem .= "";
}
}
return $optionitem;
}
// END FUNCTION: create list of top level categories for admin category management
// START FUNCTION: Create the list with both parent and child categories selection for ad post form
function get_categorynameidall($cat_id = 0) {
global $wpdb;
$optionitem='';
// Start with the main categories
$query = "SELECT category_id,category_name FROM " . AWPCP_TABLE_CATEGORIES . " ";
$query.= "WHERE category_parent_id=0 AND category_name <> '' ";
$query.= "ORDER BY category_order, category_name ASC";
$query_results = $wpdb->get_results( $query, ARRAY_N );
foreach ( $query_results as $rsrow ) {
$cat_ID = $rsrow[0];
$cat_name = stripslashes(stripslashes($rsrow[1]));
$opstyle = "class=\"dropdownparentcategory\"";
if($cat_ID == $cat_id) {
$maincatoptionitem = "";
} else {
$maincatoptionitem = "";
}
$optionitem.="$maincatoptionitem";
// While still looping through main categories get any sub categories of the main category
$maincatid = $cat_ID;
$query = "SELECT category_id,category_name FROM " . AWPCP_TABLE_CATEGORIES . " ";
$query.= "WHERE category_parent_id=%d ";
$query.= "ORDER BY category_order, category_name ASC";
$query = $wpdb->prepare( $query, $maincatid );
$sub_query_results = $wpdb->get_results( $query, ARRAY_N );
foreach ( $sub_query_results as $rsrow2) {
$subcat_ID = $rsrow2[0];
$subcat_name = stripslashes(stripslashes($rsrow2[1]));
if($subcat_ID == $cat_id) {
$subcatoptionitem = "";
} else {
$subcatoptionitem = "";
}
$optionitem.="$subcatoptionitem";
}
}
return $optionitem;
}
// END FUNCTION: create drop down list of categories for ad post form
// START FUNCTION: Retrieve the category name
function get_adcatname($cat_ID) {
global $wpdb;
$cname='';
$tbl_categories = $wpdb->prefix . "awpcp_categories";
if(isset($cat_ID) && (!empty($cat_ID))){
$query="SELECT category_name from " . AWPCP_TABLE_CATEGORIES . " WHERE category_id='$cat_ID'";
$cname = $wpdb->get_results($query, ARRAY_A);
foreach($cname as $cn) {
$cname = $cn['category_name'];
}
}
return empty($cname) ? '' : stripslashes_deep($cname);
}
function get_adcatorder($cat_ID){
global $wpdb;
$corder='';
$tbl_categories = $wpdb->prefix . "awpcp_categories";
if(isset($cat_ID) && (!empty($cat_ID))){
$query="SELECT category_order from " . AWPCP_TABLE_CATEGORIES . " WHERE category_id='$cat_ID'";
$corder = $wpdb->get_var($query);
}
return $corder;
}
//Function to retrieve ad location data:
function get_adfield_by_pk($field, $adid) {
global $wpdb;
$tbl_ads = $wpdb->prefix . "awpcp_ads";
$thevalue='';
if(isset($adid) && (!empty($adid))){
$query="SELECT ".$field." from ".$tbl_ads." WHERE ad_id='$adid'";
$thevalue = $wpdb->get_var($query);
}
return $thevalue;
}
function get_adcategory($adid){
return get_adfield_by_pk('ad_category_id', $adid);
}
function get_adparentcatname($cat_ID){
global $wpdb;
if ( $cat_ID == 0 ) {
return __( 'Top Level Category', 'AWPCP' );
}
$query = 'SELECT category_name FROM ' . AWPCP_TABLE_CATEGORIES . ' WHERE category_id = %d';
$query = $wpdb->prepare( $query, $cat_ID );
return $wpdb->get_var( $query );
}
function get_cat_parent_ID($cat_ID){
global $wpdb;
$query = 'SELECT category_parent_id FROM ' . AWPCP_TABLE_CATEGORIES . ' WHERE category_id = %d';
$query = $wpdb->prepare( $query, $cat_ID );
return $wpdb->get_var( $query );
}
function ads_exist() {
global $wpdb;
$tbl_ads = $wpdb->prefix . "awpcp_ads";
$myreturn=!awpcpistableempty($tbl_ads);
return $myreturn;
}
// END FUNCTION: check if any ads exist in the system
// START FUNCTION: Check if there are any ads in a specified category
function ads_exist_cat($catid) {
global $wpdb;
$tbl_ads = $wpdb->prefix . "awpcp_ads";
$myreturn=!awpcpisqueryempty($tbl_ads, " WHERE ad_category_id='$catid' OR ad_category_parent_id='$catid'");
return $myreturn;
}
// END FUNCTION: check if a category has ads
function category_has_children($catid) {
global $wpdb;
$tbl_categories = $wpdb->prefix . "awpcp_categories";
$myreturn=!awpcpisqueryempty($tbl_categories, " WHERE category_parent_id='$catid'");
return $myreturn;
}
function category_is_child($catid) {
global $wpdb;
$query = 'SELECT category_parent_id FROM ' . AWPCP_TABLE_CATEGORIES . ' WHERE category_id = %d';
$query = $wpdb->prepare( $query, $catid );
$parent_id = $wpdb->get_var( $query );
if ( $parent_id !== false && $parent_id != 0 ) {
return true;
} else {
return false;
}
}
// TODO: cache the results of this function
function total_ads_in_cat($catid) {
global $wpdb, $hasregionsmodule;
$totaladsincat = '';
// never allow Unpaid Ads
$filter = " AND payment_status != 'Unpaid' ";
$filter = " AND verified = 1 ";
// the name of the disablependingads setting gives the wrong meaning,
// it actually means "Enable Paid Ads that are Pendings payment", so when
// the setting has a value of 1, pending Ads should NOT be excluded.
// I'll change the next condition considering the above
if((get_awpcp_option('disablependingads') == 0) && (get_awpcp_option('freepay') == 1)){
$filter = " AND payment_status != 'Pending'";
}
// TODO: ideally there would be a function to get all visible Ads,
// and modules, like Regions, would use hooks to include their own
// conditions.
if ($hasregionsmodule == 1) {
if (isset($_SESSION['theactiveregionid'])) {
$theactiveregionid = $_SESSION['theactiveregionid'];
if (function_exists('awpcp_regions_api')) {
$regions = awpcp_regions_api();
$filter .= ' AND ' . $regions->sql_where($theactiveregionid);
}
}
}
// TODO: at some point we should start using the Category model.
$query = "SELECT count(*) FROM " . AWPCP_TABLE_ADS . " ";
$query.= "WHERE (ad_category_id='$catid' OR ad_category_parent_id='$catid') ";
// $query.= "AND disabled = 0 AND (flagged IS NULL OR flagged =0) $filter";
$query.= "AND disabled = 0 $filter";
return $wpdb->get_var( $query );
}
//Function to replace addslashes_mq, which is causing major grief. Stripping of undesireable characters now done
// through above strip_slashes_recursive_gpc.
function clean_field($foo) {
return add_slashes_recursive($foo);
}
// END FUNCTION: replace underscores with dashes for search engine friendly urls
// START FUNCTION: get the page ID when the page name is known
// Get the id of a page by its name
function awpcp_get_page_id($name) {
global $wpdb;
if (!empty($name)) {
$sql = "SELECT ID FROM $wpdb->posts WHERE post_name = '$name'";
$id = $wpdb->get_var($sql);
return $id;
}
return 0;
}
/**
* Returns the ID of WP Page associated to a page-name setting.
*
* TOOD: get all page entries in one query an cache the result during the request
*
* @param $refname the name of the setting that holds the name of the page
*/
function awpcp_get_page_id_by_ref($refname) {
global $wpdb;
$query = 'SELECT page, id FROM ' . AWPCP_TABLE_PAGES . ' WHERE page = %s';
$page = $wpdb->get_results($wpdb->prepare($query, $refname));
if (!empty($page)) {
return array_shift($page)->id;
} else {
return false;
}
}
/**
* Return the IDs of WP pages associated with AWPCP pages.
*
* @return array Array of Page IDs
*/
function awpcp_get_page_ids_by_ref($refnames) {
global $wpdb;
$refnames = (array) $refnames;
$query = 'SELECT id FROM ' . AWPCP_TABLE_PAGES . ' ';
if (!empty($refnames))
$query = sprintf("%s WHERE page IN ('%s')", $query, join("','", $refnames));
return $wpdb->get_col($query);
}
/**
* Setup the structure of the URLs based on if permalinks are on and SEO urls
* are turned on.
*
* Actually it doesn't take into account if SEO urls are on. It also takes an
* argument that is expected to have the same value ALWAYS.
*
* Is easier to get the URL for a given page using:
* get_permalink(awpcp_get_page_id(sanitize-title($human-readable-pagename)));
* or
* get_permalink(awpcp_get_page_id_by_ref())
*/
function setup_url_structure($awpcpthepagename) {
$quers = '';
$theblogurl = get_bloginfo('url');
$permastruc = get_option('permalink_structure');
if(strstr($permastruc,'index.php')) {
$theblogurl.="/index.php";
}
if(isset($permastruc) && !empty($permastruc)) {
$quers="$theblogurl/$awpcpthepagename";
} else {
$quers="$theblogurl";
}
return $quers;
}
function url_showad($ad_id) {
$ad = AWPCP_Ad::find_by_id( $ad_id );
if ( is_null( $ad ) ) return false;
$modtitle = sanitize_title( $ad->get_title() );
$seoFriendlyUrls = get_awpcp_option('seofriendlyurls');
$permastruc = get_option('permalink_structure');
$awpcp_showad_pageid = awpcp_get_page_id_by_ref('show-ads-page-name');
$base_url = get_permalink($awpcp_showad_pageid);
$url = false;
$params = array('id' => $ad_id);
if($seoFriendlyUrls && isset($permastruc) && !empty($permastruc)) {
$url = sprintf('%s/%s/%s', trim($base_url, '/'), $ad_id, $modtitle);
$region = $ad->get_first_region();
$parts = array();
if( get_awpcp_option( 'showcityinpagetitle' ) && $region ) {
$parts[] = sanitize_title( awpcp_array_data( 'city', '', $region ) );
}
if( get_awpcp_option( 'showstateinpagetitle' ) && $region ) {
$parts[] = sanitize_title( awpcp_array_data( 'state', '', $region ) );
}
if( get_awpcp_option( 'showcountryinpagetitle' ) && $region ) {
$parts[] = sanitize_title( awpcp_array_data( 'country', '', $region ) );
}
if( get_awpcp_option( 'showcountyvillageinpagetitle' ) && $region ) {
$parts[] = sanitize_title( awpcp_array_data( 'county', '', $region ) );
}
if( get_awpcp_option('showcategoryinpagetitle') ) {
$awpcp_ad_category_id = $ad->ad_category_id;
$parts[] = sanitize_title(get_adcatname($awpcp_ad_category_id));
}
// always append a slash (RSS module issue)
$url = sprintf( "%s%s", trailingslashit( $url ), join( '/', array_filter( $parts ) ) );
$url = user_trailingslashit($url);
} else {
$base_url = user_trailingslashit($base_url);
$url = add_query_arg($params, $base_url);
}
return $url;
}
function url_browsecategory($cat_id) {
$permalinks = get_option('permalink_structure');
$base_url = awpcp_get_page_url('browse-categories-page-name');
$cat_name = get_adcatname($cat_id);
$cat_slug = sanitize_title($cat_name);
if (get_awpcp_option('seofriendlyurls')) {
if (!empty($permalinks)) {
$url_browsecats = sprintf('%s/%s/%s', trim($base_url, '/'), $cat_id, $cat_slug);
} else {
$params = array('a' => 'browsecat', 'category_id' => $cat_id);
$url_browsecats = add_query_arg($params, $base_url);
}
} else {
if (!empty($permalinks)) {
$params = array('category_id' => "$cat_id/$cat_slug");
} else {
$params = array('a' => 'browsecat', 'category_id' => $cat_id);
}
$url_browsecats = add_query_arg($params, $base_url);
}
return user_trailingslashit($url_browsecats);
}
function url_placead() {
return user_trailingslashit(awpcp_get_page_url('place-ad-page-name'));
}
/**
* @deprecated deprecated since 2.0.6.
*/
function url_classifiedspage() {
return awpcp_get_main_page_url();
}
function url_searchads() {
return user_trailingslashit(awpcp_get_page_url('search-ads-page-name'));
}
function url_editad() {
return user_trailingslashit(awpcp_get_page_url('edit-ad-page-name'));
}
/**
* @deprecated since 2.0.7
*/
function checkfortable($table) {
return awpcp_table_exists($table);
}
function add_config_group_id($cvalue,$coption) {
global $wpdb;
$query = 'UPDATE ' . AWPCP_TABLE_ADSETTINGS . ' SET config_group_id = %d WHERE config_option = %s';
$query = $wpdb->prepare( $query, $cvalue, $coption );
$wpdb->query( $query );
}
/**
* Returns the current name of the AWPCP main page.
*/
function get_currentpagename() {
return get_awpcp_option('main-page-name');
}
function field_exists($field) {
global $wpdb;
if ( ! checkfortable( AWPCP_TABLE_ADSETTINGS ) ) {
return false;
}
$query = 'SELECT config_value FROM ' . AWPCP_TABLE_ADSETTINGS . ' WHERE config_option = %s';
$query = $wpdb->prepare( $query, $field );
$value = $wpdb->get_var( $config_value );
if ( $value === false || is_null( $value ) ) {
return false;
} else {
return true;
}
}
function isValidURL($url) {
return preg_match('|^http(s)?://[a-z0-9-]+(.[a-z0-9-]+)*(:[0-9]+)?(/.*)?$|i', $url);
}
/**
* @since 3.0.2
*/
function awpcp_is_valid_email_address($email) {
return filter_var( $email, FILTER_VALIDATE_EMAIL ) !== false;
}
/**
* @deprecated since 3.0.2. @see awpcp_is_valid_email_address()
*/
function isValidEmailAddress($email) {
return awpcp_is_valid_email_address( $email );
}
function defaultcatexists($defid) {
global $wpdb;
$query = 'SELECT COUNT(*) FROM ' . AWPCP_TABLE_CATEGORIES . ' WHERE category_id = %d';
$query = $wpdb->prepare( $query, $defid );
$count = $wpdb->get_var( $query );
if ( $count !== false && $count > 0 ) {
return true;
} else {
return false;
}
}
// START FUNCTION: function to create a default category with an ID of 1 in the event a default category with ID 1 does not exist
function createdefaultcategory($idtomake,$titletocallit) {
global $wpdb;
$wpdb->insert( AWPCP_TABLE_CATEGORIES, array( 'category_name' => $titletocallit, 'category_parent_id' => 0 ) );
$query = 'UPDATE ' . AWPCP_TABLE_CATEGORIES . ' SET category_id = 1 WHERE category_id = %d';
$query = $wpdb->prepare( $query, $wpdb->insert_id );
$wpdb->query( $query );
}
// END FUNCTION: create default category
//////////////////////
// START FUNCTION: function to delete multiple ads at once used when admin deletes a category that contains ads but does not move the ads to a new category
//////////////////////
function massdeleteadsfromcategory($catid) {
$ads = AWPCP_Ad::find_by_category_id($catid);
foreach ($ads as $ad) {
$ad->delete();
}
}
// END FUNCTION: sidebar widget
// START FUNCTION: make sure there's not more than one page with the name of the classifieds page
function checkforduplicate($cpagename_awpcp) {
global $wpdb, $table_prefix;
$awpcppagename = sanitize_title( $cpagename_awpcp );
$query = "SELECT ID {$table_prefix}posts WHERE post_name = %s AND post_type = %s";
$query = $wpdb->prepare( $query, $awpcppagename, 'post' );
$post_ids = $wpdb->get_col( $query );
if ( $post_ids !== false ) {
return count( $post_ids );
} else {
return '';
}
}
function create_ad_postedby_list($name) {
global $wpdb;
$output = '';
$query = 'SELECT DISTINCT ad_contact_name FROM ' . AWPCP_TABLE_ADS . ' WHERE disabled = 0';
$results = $wpdb->get_col( $query );
foreach ( $results as $contact_name ) {
if ( strcmp( $contact_name, $name ) === 0 ) {
$output .= "";
} else {
$output .= "";
}
}
return $output;
}
function awpcp_strip_html_tags( $text )
{
// Remove invisible content
$text = preg_replace(
array(
'@]*?>.*?@siu',
'@]*?>.*?@siu',
'@]*?.*?@siu',
'@]*?.*?@siu',
'@]*?.*?@siu',
'@]*?.*?@siu',
'@]*?.*?@siu',
'@]*?.*?@siu',
'@]*?.*?@siu',
// Add line breaks before and after blocks
'@Mailer = 'smtp';
$phpmailer->Host = $host;
$phpmailer->Port = $port;
// If there's a username and password then assume SMTP Auth is necessary and set the vars:
if ( '' != trim( $username ) && '' != trim( $password ) ) {
$phpmailer->SMTPAuth = true;
$phpmailer->Username = $username;
$phpmailer->Password = $password;
}
// that's it!
}
function awpcp_process_mail($senderemail='', $receiveremail='', $subject='',
$body='', $sendername='', $replytoemail='', $html=false)
{
$headers = "MIME-Version: 1.0\n" .
"From: $sendername <$senderemail>\n" .
"Reply-To: $replytoemail\n";
if ($html) {
$headers .= "Content-Type: text/html; charset=\"" . get_option('blog_charset') . "\"\n";
} else {
$headers .= "Content-Type: text/plain; charset=\"" . get_option('blog_charset') . "\"\n";
}
$subject = $subject;
$message = "$body\n\n" . awpcp_format_email_sent_datetime() . "\n\n";
_log("Processing email");
if (wp_mail($receiveremail, $subject, $message, $headers )) {
_log("Sent via WP");
return 1;
} elseif (awpcp_send_email($senderemail, $receiveremail, $subject, $body,true)) {
_log("Sent via send_email");
return 1;
} elseif (@mail($receiveremail, $subject, $body, $headers)) {
_log("Sent via mail");
return 1;
} else {
_log("SMTP not configured properly, all attempts failed");
return 0;
}
}
function awpcp_format_email_sent_datetime() {
$time = date_i18n( awpcp_get_datetime_format(), current_time( 'timestamp' ) );
return sprintf( __( 'Email sent %s.', 'AWPCP' ), $time );
}
// make sure the IP isn't a reserved IP address
function awpcp_validip($ip) {
if (!empty($ip) && ip2long($ip)!=-1) {
$reserved_ips = array (
array('0.0.0.0','2.255.255.255'),
array('10.0.0.0','10.255.255.255'),
array('127.0.0.0','127.255.255.255'),
array('169.254.0.0','169.254.255.255'),
array('172.16.0.0','172.31.255.255'),
array('192.0.2.0','192.0.2.255'),
array('192.168.0.0','192.168.255.255'),
array('255.255.255.0','255.255.255.255')
);
foreach ($reserved_ips as $r) {
$min = ip2long($r[0]);
$max = ip2long($r[1]);
if ((ip2long($ip) >= $min) && (ip2long($ip) <= $max))
return false;
}
return true;
} else {
return false;
}
}
// retrieve the ad poster's IP if possible
function awpcp_getip() {
if ( awpcp_validip(awpcp_array_data("HTTP_CLIENT_IP", '', $_SERVER)) ) {
return $_SERVER["HTTP_CLIENT_IP"];
}
foreach ( explode(",", awpcp_array_data("HTTP_X_FORWARDED_FOR", '', $_SERVER)) as $ip ) {
if ( awpcp_validip(trim($ip) ) ) {
return $ip;
}
}
if (awpcp_validip(awpcp_array_data("HTTP_X_FORWARDED", '', $_SERVER))) {
return $_SERVER["HTTP_X_FORWARDED"];
} elseif (awpcp_validip(awpcp_array_data('HTTP_FORWARDED_FOR', '', $_SERVER))) {
return $_SERVER["HTTP_FORWARDED_FOR"];
} elseif (awpcp_validip(awpcp_array_data("HTTP_FORWARDED", '', $_SERVER))) {
return $_SERVER["HTTP_FORWARDED"];
} else {
return awpcp_array_data("REMOTE_ADDR", '', $_SERVER);
}
}
function awpcp_get_ad_share_info($id) {
global $wpdb;
$ad = AWPCP_Ad::find_by_id($id);
$info = array();
if (is_null($ad)) {
return null;
}
$info['url'] = url_showad($id);
$info['title'] = stripslashes($ad->ad_title);
$info['description'] = strip_tags(stripslashes($ad->ad_details));
$info['description'] = str_replace("\n", " ", $info['description']);
if ( awpcp_utf8_strlen( $info['description'] ) > 300 ) {
$info['description'] = awpcp_utf8_substr( $info['description'], 0, 300 ) . '...';
}
$info['images'] = array();
$info['published-time'] = awpcp_datetime( 'Y-m-d', $ad->ad_postdate );
$info['modified-time'] = awpcp_datetime( 'Y-m-d', $ad->ad_last_updated );
$images = awpcp_media_api()->find_by_ad_id( $ad->ad_id, array( 'enabled' => true ) );
foreach ( $images as $image ) {
$info[ 'images' ][] = $image->get_url( 'large' );
}
return $info;
}
//
// Metadata API.
//
function awpcp_add_ad_meta( $ad_id, $meta_key, $meta_value, $unique = false ) {
return add_metadata( 'awpcp_ad', $ad_id, $meta_key, $meta_value, $unique );
}
function awpcp_update_ad_meta( $ad_id, $meta_key, $meta_value, $prev_value = '' ) {
return update_metadata( 'awpcp_ad', $ad_id, $meta_key, $meta_value, $prev_value );
}
function awpcp_delete_ad_meta( $ad_id, $meta_key, $meta_value = '', $delete_all = false) {
return delete_metadata( 'awpcp_ad', $ad_id, $meta_key, $meta_value, $delete_all );
}
function awpcp_get_ad_meta( $ad_id, $meta_key='', $single = false ) {
return get_metadata( 'awpcp_ad', $ad_id, $meta_key, $single );
}