WordPress.org
Get WordPress

Plugin Directory

Changeset 656528


Ignore:
Timestamp:
01/21/2013 09:54:27 PM (13 years ago)
Author:
blazingtorch
Message:

PrayBox v1.0.8

Location:
praybox
Files:
25 added
4 edited

Legend:

Unmodified
Added
Removed

  • praybox/trunk/inc/functions.php

    r585375 r656528  
    1717function isIPBanned($ip){
    1818    global $wpdb;
    19     $result = $wpdb->get_var($wpdb->prepare("SELECT COUNT(id) FROM ".$wpdb->prefix."pb_banned_ips WHERE ip_address='$ip'"));
     19    $result=count($wpdb->get_results("SELECT id FROM ".$wpdb->prefix."pb_banned_ips WHERE ip_address='$ip'"));
    2020    if($result==0){return "pass";}else{return "fail";}
    2121}
    … …  
    4646function isDuplicate($fname,$lname,$email,$title,$ipaddy){
    4747    global $wpdb;
    48     $result = $wpdb->get_var($wpdb->prepare("SELECT COUNT(id) FROM ".$wpdb->prefix."pb_requests WHERE first_name='$fname' AND last_name='$lname' AND email='$email' AND title='$title' AND ip_address='$ipaddy'"));
     48    $result = count($wpdb->get_results("SELECT id FROM ".$wpdb->prefix."pb_requests WHERE first_name='$fname' AND last_name='$lname' AND email='$email' AND title='$title' AND ip_address='$ipaddy'"));
    4949    if($result==0){return "pass";}else{return "fail";}
    5050}
    … …  
    114114   
    115115    $active_requests=$wpdb->get_results("SELECT id,title,body,submitted $this_display_qry_from");
    116     $num_requests=$wpdb->get_var($wpdb->prepare("SELECT COUNT(id) $this_display_qry_from"));
    117     $total_num_requests=$wpdb->get_var($wpdb->prepare("SELECT COUNT(id) $total_display_qry_from"));
     116    $num_requests=count($wpdb->get_results("SELECT id $this_display_qry_from"));
     117    $total_num_requests=count($wpdb->get_results("SELECT id $total_display_qry_from"));
    118118       
    119119    $req_list_output.="<div id='praybox'>";

  • praybox/trunk/inc/inc_pb_crons.php

    r585375 r656528  
    6161        $request_id=$prayer->request_id;
    6262       
    63         $num_prayers=$wpdb->get_var($wpdb->prepare("SELECT COUNT(id) FROM ".$wpdb->prefix."pb_prayedfor WHERE prayedfor_date>'$onedayago' AND request_id='$request_id'"));
     63        $num_prayers=count($wpdb->get_var("SELECT id FROM ".$wpdb->prefix."pb_prayedfor WHERE prayedfor_date>'$onedayago' AND request_id='$request_id'"));
    6464   
    6565        $prayer_request=$wpdb->get_row("SELECT first_name,last_name,email,title,notify,authcode FROM ".$wpdb->prefix."pb_requests WHERE id='$request_id'");

  • praybox/trunk/praybox.php

    r585375 r656528  
    44Plugin URI: http://www.praybox.com/
    55Description: This is a plugin that facilitates intercessory prayer by allowing visitors to post prayer requests and/or respond to prayer requests that have been posted by clicking on a button indicating that the prayer request has been prayed for. At the end of each day, visitors who have submitted prayer requests receive an email that tells them how many times they have been prayed for that day.
    6 Version: 1.0.7
     6Version: 1.0.8
    77Author: Blazing Torch, Inc.
    88Author URI: http://www.blazingtorch.com

  • praybox/trunk/readme.txt

    r585375 r656528  
    44Tags: church, pray, prayer, religion, ministry, prayer request, ministry tools
    55Requires at least: 3.0
    6 Tested up to: 3.4.1
    7 Stable tag: 1.0.7
     6Tested up to: 3.5
     7Stable tag: 1.0.8
    88
    99PrayBox is a prayer request application that allows users to submit requests, or pray for existing requests, as well as allowing site administrators to manage prayer requests.
    … …  
    9191= August 14, 2012 - 1.0.7 =
    9292* Updated url variable validation to protect against vulnerabilities.
     93
     94= January 21, 2013 - 1.0.8 =
     95* Updated for better functionality in WP v3.5.
Note: See TracChangeset for help on using the changeset viewer.