Changeset 590364
- Timestamp:
- 08/25/2012 09:27:46 PM (14 years ago)
- Location:
- paid-business-listings/trunk/inc
- Files:
-
- 2 added
- 6 edited
-
display_functions.php (added)
-
functions.php (modified) (3 diffs)
-
inc_admin_menu_hooks.php (modified) (1 diff)
-
inc_display_form.php (modified) (3 diffs)
-
inc_install_func.php (modified) (3 diffs)
-
inc_pbl_settings_page.php (modified) (2 diffs)
-
inc_pbl_trans_log_page.php (added)
-
inc_thankyou_page_function.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
paid-business-listings/trunk/inc/functions.php
r490123 r590364 5 5 $secondary_color=get_option('pbl_secondary_hex_color'); 6 6 7 function pbl_clean($string){ 8 return strip_tags(nl2br($string),"<br>"); 9 } 7 10 8 11 function getCategoryName($id){ … … 158 161 159 162 function stateSelect($state_province_field,$selected=""){ 160 $us_state_array=array(' AK'=>'Alaska', 'AL'=>'Alabama', 'AR'=>'Arkansas', 'AZ'=>'Arizona', 'CA'=>'California', 'CO'=>'Colorado', 'CT'=>'Connecticut', 'DC'=>'District of Columbia', 'DE'=>'Delaware', 'FL'=>'Florida', 'GA'=>'Georgia', 'HI'=>'Hawaii', 'IA'=>'Iowa', 'ID'=>'Idaho', 'IL'=>'Illinois', 'IN'=>'Indiana', 'KS'=>'Kansas', 'KY'=>'Kentucky', 'LA'=>'Louisiana', 'MA'=>'Massachusetts', 'MD'=>'Maryland', 'ME'=>'Maine', 'MI'=>'Michigan', 'MN'=>'Minnesota', 'MO'=>'Missouri', 'MS'=>'Mississippi', 'MT'=>'Montana', 'NC'=>'North Carolina', 'ND'=>'North Dakota', 'NE'=>'Nebraska', 'NH'=>'New Hampshire', 'NJ'=>'New Jersey', 'NM'=>'New Mexico', 'NV'=>'Nevada', 'NY'=>'New York', 'OH'=>'Ohio', 'OK'=>'Oklahoma', 'OR'=>'Oregon', 'PA'=>'Philadelphia', 'RI'=>'Rhode Island', 'SC'=>'South Carolina', 'SD'=>'South Dakota', 'TN'=>'Tennessee', 'TX'=>'Texas', 'UT'=>'Utah', 'VA'=>'Virginia', 'VT'=>'Vermont', 'WA'=>'Washington', 'WI'=>'Wisconsin', 'WV'=>'West Virginia', 'WY'=>'Wyoming');163 $us_state_array=array(''=>'Select Your State', 'AK'=>'Alaska', 'AL'=>'Alabama', 'AR'=>'Arkansas', 'AZ'=>'Arizona', 'CA'=>'California', 'CO'=>'Colorado', 'CT'=>'Connecticut', 'DC'=>'District of Columbia', 'DE'=>'Delaware', 'FL'=>'Florida', 'GA'=>'Georgia', 'HI'=>'Hawaii', 'IA'=>'Iowa', 'ID'=>'Idaho', 'IL'=>'Illinois', 'IN'=>'Indiana', 'KS'=>'Kansas', 'KY'=>'Kentucky', 'LA'=>'Louisiana', 'MA'=>'Massachusetts', 'MD'=>'Maryland', 'ME'=>'Maine', 'MI'=>'Michigan', 'MN'=>'Minnesota', 'MO'=>'Missouri', 'MS'=>'Mississippi', 'MT'=>'Montana', 'NC'=>'North Carolina', 'ND'=>'North Dakota', 'NE'=>'Nebraska', 'NH'=>'New Hampshire', 'NJ'=>'New Jersey', 'NM'=>'New Mexico', 'NV'=>'Nevada', 'NY'=>'New York', 'OH'=>'Ohio', 'OK'=>'Oklahoma', 'OR'=>'Oregon', 'PA'=>'Philadelphia', 'RI'=>'Rhode Island', 'SC'=>'South Carolina', 'SD'=>'South Dakota', 'TN'=>'Tennessee', 'TX'=>'Texas', 'UT'=>'Utah', 'VA'=>'Virginia', 'VT'=>'Vermont', 'WA'=>'Washington', 'WI'=>'Wisconsin', 'WV'=>'West Virginia', 'WY'=>'Wyoming'); 161 164 162 $au_state_array=array(' ACT'=>'Australian Capital Territory', 'NSW'=>'New South Wales', 'VIC'=>'Victoria', 'QLD'=>'Queensland', 'SA'=>'South Australia', 'WA'=>'Western Australia', 'TAS'=>'Tasmania', 'NT'=>'Northern Territory');165 $au_state_array=array(''=>'Select Your Province', 'ACT'=>'Australian Capital Territory', 'NSW'=>'New South Wales', 'VIC'=>'Victoria', 'QLD'=>'Queensland', 'SA'=>'South Australia', 'WA'=>'Western Australia', 'TAS'=>'Tasmania', 'NT'=>'Northern Territory'); 163 166 164 $ca_state_array=array(' ON'=>'Ontario', 'QC'=>'Quebec', 'NS'=>'Nova Scotia', 'NB'=>'New Brunswick', 'MB'=>'Manitoba', 'BC'=>'British Columbia', 'PE'=>'Prince Edward Island', 'SK'=>'Saskatchewan', 'AB'=>'Alberta', 'NL'=>'Newfoundland and Labrador');167 $ca_state_array=array(''=>'Select Your Province', 'ON'=>'Ontario', 'QC'=>'Quebec', 'NS'=>'Nova Scotia', 'NB'=>'New Brunswick', 'MB'=>'Manitoba', 'BC'=>'British Columbia', 'PE'=>'Prince Edward Island', 'SK'=>'Saskatchewan', 'AB'=>'Alberta', 'NL'=>'Newfoundland and Labrador'); 165 168 166 167 169 if($state_province_field=="US"){$array_to_use=$us_state_array;} 168 170 if($state_province_field=="AU"){$array_to_use=$au_state_array;} … … 171 173 foreach($array_to_use as $state_abbr=>$state_name){ 172 174 if(($selected==$state_abbr)||($selected==$state_name)){$select_status="selected ";}else{$select_status="";} 173 $return.="<option $select_status value='$state_name'>$state_name</option> ";175 $return.="<option $select_status value='$state_name'>$state_name</option>\n"; 174 176 } 175 177 -
paid-business-listings/trunk/inc/inc_admin_menu_hooks.php
r482503 r590364 13 13 add_submenu_page('pbl_settings','Categories','Listings Categories','administrator','pbl_settings_categories','pbl_categories_page'); 14 14 add_submenu_page('pbl_settings','Listings','Business Listings','administrator','pbl_settings_listings','pbl_listings_page'); 15 add_submenu_page('pbl_settings','Transactions','Transactions','administrator','pbl_settings_trans_log','pbl_trans_log_page'); 15 16 add_submenu_page('','Edit Listings','Edit Listings','administrator','pbl_settings_edit_listings','pbl_edit_listing_page'); 16 17 -
paid-business-listings/trunk/inc/inc_display_form.php
r570116 r590364 4 4 global $wpdb; 5 5 6 $site_url=get_site_url(); 7 $pbl_page_id=get_option('pbl_page_id'); 8 $pbl_page_link=get_permalink($pbl_page_id); 9 if(strpos($pbl_page_link,"?") === false){$pretty_permalinks=1;}else{$pretty_permalinks=0;} 10 $pbl_pp_button=get_option('pbl_buttimg'); 6 $this_url=get_permalink($post->ID); 11 7 $pbl_step_one_message=get_option('pbl_step_one_message'); 12 8 $pbl_step_two_message=get_option('pbl_step_two_message'); 13 $pbl_ppemail=get_option('pbl_ppemail');14 9 $pbl_submit_button_text=get_option('pbl_butttext'); 15 10 16 11 //FORM VALIDATION 17 12 if($_POST['action']=="paypal_form"){ 18 $name= $_POST['pbl_listing_name'];13 $name=pbl_clean($_POST['pbl_listing_name']); 19 14 $logo_url=$_POST['pbl_listing_logo_url']; 20 $description= $_POST['pbl_listing_description'];21 $phone= $_POST['pbl_listing_phone'];22 $url= $_POST['pbl_listing_url'];23 $email= $_POST['pbl_listing_email'];24 $address= $_POST['pbl_listing_address'];25 $city= $_POST['pbl_listing_city'];26 $state= $_POST['pbl_listing_state'];27 $zip= $_POST['pbl_listing_zip'];15 $description=pbl_clean($_POST['pbl_listing_description']); 16 $phone=pbl_clean($_POST['pbl_listing_phone']); 17 $url=pbl_clean($_POST['pbl_listing_url']); 18 $email=pbl_clean($_POST['pbl_listing_email']); 19 $address=pbl_clean($_POST['pbl_listing_address']); 20 $city=pbl_clean($_POST['pbl_listing_city']); 21 $state=pbl_clean($_POST['pbl_listing_state']); 22 $zip=pbl_clean($_POST['pbl_listing_zip']); 28 23 $cat_id=$_POST['pbl_listing_cat_id']; 29 24 $pkg_id=$_POST['pbl_listing_pkg_id']; … … 42 37 } 43 38 39 if((isset($_GET['subid']))&&(isset($_GET['sc']))){ 40 $return.=($_GET['sc']==1) ? "<p>".get_option('pbl_thank_you_message')."</p>" : "<p>".get_option('pbl_bail_message')."</p>"; 41 42 } 43 44 if(isset($_GET['ppn'])){ 45 // PAYPAL IPN LISTENER 46 $req = 'cmd=' . urlencode('_notify-validate'); 47 48 foreach ($_POST as $key => $value) { 49 $value = urlencode(stripslashes($value)); 50 $req .= "&$key=$value"; 51 } 52 53 $ch = curl_init(); 54 curl_setopt($ch, CURLOPT_URL, 'https://www.paypal.com/cgi-bin/webscr'); 55 curl_setopt($ch, CURLOPT_HEADER, 0); 56 curl_setopt($ch, CURLOPT_POST, 1); 57 curl_setopt($ch, CURLOPT_RETURNTRANSFER,1); 58 curl_setopt($ch, CURLOPT_POSTFIELDS, $req); 59 curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 1); 60 curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2); 61 curl_setopt($ch, CURLOPT_HTTPHEADER, array('Host: www.paypal.com')); 62 $res = curl_exec($ch); 63 curl_close($ch); 64 65 // assign posted variables to local variables 66 $item_number = $_POST['item_number']; 67 $item_name = $_POST['item_name']; 68 $submission_id = $_POST['custom']; 69 $payment_status = $_POST['payment_status']; 70 $payment_amount = $_POST['mc_gross']; 71 $payment_currency = $_POST['mc_currency']; 72 $txn_id = $_POST['txn_id']; 73 $receiver_email = $_POST['receiver_email']; 74 $payer_email = $_POST['payer_email']; 75 76 if (strcmp ($res, "VERIFIED") == 0) { 77 ($payment_status=="Completed")? $wpdb->update($wpdb->prefix.'pbl_listings',array('active'=>1),array('id'=>$submission_id)) : null; 78 } 79 else if (strcmp ($res, "INVALID") == 0) { 80 // log for manual investigation 81 } 82 $time=time(); 83 $wpdb->insert($wpdb->prefix.'pbl_trans_log',array('listing_id'=>$submission_id,'package_id'=>$item_number,'trans_type'=>'paypal','payment_status'=>$payment_status,'payment_amount'=>$payment_amount,'trans_id'=>$txn_id,'timestamp'=>$time,'email'=>$payer_email)); 84 } 44 85 45 86 if(($_POST['action']=="paypal_form")&&(!isset($err))){ 46 //global $wpdb;47 87 48 88 $time_listed=time(); 49 50 89 $durmonths=getPackageDuration($pkg_id); 51 90 $time_expired=strtotime($durmonths); … … 59 98 if($package_info->cost=="0"){ //SHOW THIS FORM IF COST IS 0 60 99 61 $return.="<p>You have selected a Free Package.</p>"; 62 $return.="<div id='pbl-form-wrapper'>"; 63 $return.="<form action='$site_url' method='GET'>"; 64 $return.="<input type='hidden' name='page_id' value='$pbl_page_id'>"; 65 $return.="<input type='hidden' name='subid' value='$submission_id'>"; 66 $return.="<input type='hidden' name='sc' value='1'>"; 67 $return.="<input type='submit' value='Click Here To Complete Your Submission' />"; 68 $return.="</form>"; 69 $return.="<div style='clear:both;'></div></div>"; 70 71 }else{ //SHOW THIS FORM IF COST IS NOT ZERO 100 $wpdb->update($wpdb->prefix.'pbl_listings',array('active'=>1),array('id'=>$submission_id)); 101 $return.="<p>".get_option('pbl_thank_you_message')."</p>"; 102 103 104 }else{ //SHOW THIS FORM IF COST IS NOT 0 72 105 106 $pbl_package_id=$package_info->id; 73 107 $pbl_package_name=$package_info->name; 74 108 $pbl_package_cost=$package_info->cost; 75 $pbl_package_currency=get_option('pbl_ppcurrency'); 76 77 $return.="<p>$pbl_step_two_message</p>"; 78 $return.="<div id='pbl-form-wrapper'>"; 79 $return.="<form action='https://www.paypal.com/cgi-bin/webscr' method='post'>"; 80 $return.="<input type='hidden' name='cmd' value='_xclick'>"; 81 $return.="<input type='hidden' name='business' value='$pbl_ppemail'>"; 82 $return.="<input type='hidden' name='lc' value='US'>"; 83 $return.="<input type='hidden' name='item_name' value='$pbl_package_name'>"; 84 $return.="<input type='hidden' name='amount' value='$pbl_package_cost'>"; 85 $return.="<input type='hidden' name='currency_code' value='$pbl_package_currency'>"; 86 $return.="<input type='hidden' name='button_subtype' value='services'>"; 87 $return.="<input type='hidden' name='no_note' value='1'>"; 88 $return.="<input type='hidden' name='no_shipping' value='1'>"; 89 $return.="<input type='hidden' name='rm' value='1'>"; 90 if($pretty_permalinks==1){ 91 $return.="<input type='hidden' name='return' value='$pbl_page_link?subid=$submission_id&sc=1'>"; 92 $return.="<input type='hidden' name='cancel_return' value='$pbl_page_link?subid=$submission_id&sc=0'>"; 93 }else{ 94 $return.="<input type='hidden' name='return' value='$pbl_page_link&subid=$submission_id&sc=1'>"; 95 $return.="<input type='hidden' name='cancel_return' value='$pbl_page_link&subid=$submission_id&sc=0'>"; 96 } 97 $return.="<input type='hidden' name='bn' value='PP-BuyNowBF:btn_buynowCC_LG.gif:NonHosted'>"; 98 $return.="<input type='hidden' name='notify_url' value='$pbl_page_link'>"; 99 $return.="<input type='image' src='$pbl_pp_button' border='0' name='submit' alt='PayPal - The safer, easier way to pay online!'>"; 100 $return.="<img alt='' border='0' src='https://www.paypalobjects.com/WEBSCR-640-20110306-1/en_US/i/scr/pixel.gif' width='1' height='1'>"; 101 $return.="</form>"; 102 103 } //END BRACKET FOR FORM TO DISPLAY IF COST IS NOT 0 109 110 $return.=displayPayPalForm($pbl_step_two_message,$pbl_package_id,$pbl_package_name,$pbl_package_cost,$submission_id,$this_url); 111 } 104 112 105 113 }else{ 106 114 107 $return.="<p>$pbl_step_one_message</p>"; 108 $return.="<div id='pbl-form-wrapper'>"; 109 $return.="<form method='post'>"; 110 $return.="<input type='hidden' name='action' value='paypal_form' />"; 111 $return.="<table>"; 112 113 if(isset($err)){ 114 $return.="<tr><td class='err' colspan='2'><p>The following errors were encountered:</p><ul>$err</ul><p>Please correct these errors and resumbit the form. Thank you.</p></td></tr>"; 115 if((!isset($_GET['subid']))&&(!isset($_GET['sc']))){ 116 $form_array[] = array('type'=>"hidden", 'name'=>"action", 'value'=>"paypal_form"); 117 $form_array[] = array('type'=>"text", 'label'=>"Company Name", 'name'=>"pbl_listing_name", 'value'=>$name); 118 $form_array[] = array('type'=>"text", 'label'=>"Logo URL", 'name'=>"pbl_listing_logo_url", 'value'=>$logo_url, 'note'=>"NOTE: If no logo is provided, a placeholder graphic will be displayed."); 119 $form_array[] = array('type'=>"textarea", 'label'=>"Business Description", 'name'=>"pbl_listing_description", 'value'=>$description); 120 $form_array[] = array('type'=>"text", 'label'=>"Business Phone", 'name'=>"pbl_listing_phone", 'value'=>$phone); 121 $form_array[] = array('type'=>"text", 'label'=>"Website URL", 'name'=>"pbl_listing_url", 'value'=>$url); 122 $form_array[] = array('type'=>"text", 'label'=>"Business Email Address", 'name'=>"pbl_listing_email", 'value'=>$email); 123 $form_array[] = array('type'=>"text", 'label'=>"Street Address", 'name'=>"pbl_listing_address", 'value'=>$address); 124 $form_array[] = array('type'=>"text", 'label'=>"City", 'name'=>"pbl_listing_city", 'value'=>$city); 125 $state_field=(get_option('pbl_state_province_field')=="") ? "TEXT" : get_option('pbl_state_province_field'); 126 switch($state_field){ case TEXT: 127 $form_array[] = array('type'=>"text", 'label'=>"State/Province", 'name'=>"pbl_listing_state", 'value'=>$state); 128 break; 129 default: 130 $form_array[] = array('type'=>"select", 'label'=>"State/Province", 'name'=>"pbl_listing_state", 'options'=>stateSelect($state_field,$state)); 115 131 } 116 117 $return.="<tr><td class='label'>Company Name</td>"; 118 $return.="<td class='input'><input type='text' name='pbl_listing_name' value='$name' /></td></tr>"; 119 120 $return.="<tr><td class='label'>Logo URL</td>"; 121 $return.="<td class='input'><input type='text' name='pbl_listing_logo_url' value='$logo_url' /></td></tr>"; 122 $return.="<tr><td> </td><td class='formnote'>NOTE: If no logo is provided, a placeholder graphic will be displayed.</td></tr>"; 123 124 $return.="<tr><td class='label'>Business Description</td>"; 125 $return.="<td class='input'><textarea name='pbl_listing_description' >$description</textarea></td></tr>"; 126 127 $return.="<tr><td class='label'>Business Phone</td>"; 128 $return.="<td class='input'><input type='text' name='pbl_listing_phone' value='$phone' /></td></tr>"; 129 130 $return.="<tr><td class='label'>Website URL</td>"; 131 $return.="<td class='input'><input type='text' name='pbl_listing_url' value='$url' /></td></tr>"; 132 133 $return.="<tr><td class='label'>Business Email Address</td>"; 134 $return.="<td class='input'><input type='text' name='pbl_listing_email' value='$email' /></td></tr>"; 135 136 $return.="<tr><td class='label'>Street Address</td>"; 137 $return.="<td class='input'><input type='text' name='pbl_listing_address' value='$address' /></td></tr>"; 138 139 $return.="<tr><td class='label'>City</td>"; 140 $return.="<td class='input'><input type='text' name='pbl_listing_city' value='$city' /></td></tr>"; 141 142 $return.="<tr><td class='label'>State/Province</td>"; 143 $return.="<td class='input'>"; 144 145 $state_province_field=get_option('pbl_state_province_field'); 146 147 if(($state_province_field=="TEXT")||($state_province_field=="")){ 148 $return.="<input type='text' name='pbl_listing_state' value='$state' />"; 149 }else{ 150 $return.="<select name='pbl_listing_state'>"; 151 $return.="<option value=''>Select Your State/Province</option>"; 152 $return.=stateSelect($state_province_field,$state); 153 $return.="</select>"; 132 $form_array[] = array( 133 'type'=>"text", 'label'=>"Postal Code", 'name'=>"pbl_listing_zip", 'value'=>$zip); 134 $form_array[] = array('type'=>"taxonomy", 'taxonomy-type'=>"category", 'value'=>$cat_id,); 135 $form_array[] = array('type'=>"taxonomy", 'taxonomy-type'=>"package", 'value'=>$pkg_id,); 136 $form_array[] = array('type'=>"submit", 'value'=>$pbl_submit_button_text,); 137 $return.=displayFormTable($pbl_step_one_message,"pbl-form-wrapper",$err,$form_array); 154 138 } 155 $return.="</td></tr>";156 157 $return.="<tr><td class='label'>Postal Code</td>";158 $return.="<td class='input'><input type='text' name='pbl_listing_zip' value='$zip' /></td></tr>";159 160 $return.="<tr><td class='label'>Category</td>";161 $return.="<td class='input'>";162 $return.=getCategoryList($cat_id);163 $return.="</td></tr>";164 165 $return.="<tr><td class='label'>Package</td>";166 $return.="<td class='input'>";167 $return.=getPackageList($pkg_id);168 $return.="</td></tr>";169 170 $return.="<tr><td> </td><td class='submit'><input type='submit' value='$pbl_submit_button_text' /></td></tr>";171 172 $return.="</table>";173 174 $return.="</form>";175 139 } 176 140 177 $return.="<div style='clear:both;'></div></div>";178 179 141 return $return; 180 142 } -
paid-business-listings/trunk/inc/inc_install_func.php
r490120 r590364 3 3 4 4 global $pbl_db_version; 5 $pbl_db_version = "1. 1";5 $pbl_db_version = "1.2"; 6 6 7 7 function pbl_db_install() { … … 62 62 );"; 63 63 64 $wpdb->query($sql); 65 $wpdb->insert($wpdb->prefix.'pbl_categories',array('name'=>'General','description'=>'General business listings.')); 66 67 add_option("pbl_db_version",$pbl_db_version); 68 } 69 64 $wpdb->query($sql); 65 $wpdb->insert($wpdb->prefix.'pbl_categories',array('name'=>'General','description'=>'General business listings.')); 66 } 67 68 $table_name = $wpdb->prefix."pbl_trans_log"; 69 if($wpdb->get_var("SHOW TABLES LIKE '$table_name'")!=$table_name) { 70 $sql = "CREATE TABLE ".$table_name." ( 71 id mediumint(9) NOT NULL AUTO_INCREMENT, 72 listing_id mediumint(9) NOT NULL, 73 package_id mediumint(9) NOT NULL, 74 trans_type VARCHAR(32) NOT NULL, 75 payment_status VARCHAR(32) NOT NULL, 76 payment_amount VARCHAR(32) NOT NULL, 77 trans_id VARCHAR(32) NOT NULL, 78 timestamp INT(11) NOT NULL, 79 email VARCHAR(64) NOT NULL, 80 UNIQUE KEY id (id) 81 );"; 82 $wpdb->query($sql); 83 add_option("pbl_db_version",$pbl_db_version); 84 } 85 86 //DB UPDATE 87 switch (get_option('pbl_db_version')){ 88 case 1.0: 89 $table_name = $wpdb->prefix."pbl_listings"; 90 $sql = "ALTER TABLE " .$table_name. " MODIFY state VARCHAR(64)"; 91 $wpdb->query($sql); 92 93 $table_name = $wpdb->prefix."pbl_trans_log"; 94 if($wpdb->get_var("SHOW TABLES LIKE '$table_name'")!=$table_name) { 95 $sql = "CREATE TABLE ".$table_name." ( 96 id mediumint(9) NOT NULL AUTO_INCREMENT, 97 package_id mediumint(9) NOT NULL, 98 trans_type VARCHAR(32) NOT NULL, 99 payment_status VARCHAR(32) NOT NULL, 100 payment_amount VARCHAR(32) NOT NULL, 101 trans_id VARCHAR(32) NOT NULL, 102 timestamp INT(11) NOT NULL, 103 email VARCHAR(64) NOT NULL, 104 UNIQUE KEY id (id) 105 );"; 106 $wpdb->query($sql); 107 } 108 delete_option('pbl_db_version'); 109 add_option("pbl_db_version",$pbl_db_version); 110 break; 111 case 1.1: 112 $table_name = $wpdb->prefix."pbl_trans_log"; 113 if($wpdb->get_var("SHOW TABLES LIKE '$table_name'")!=$table_name) { 114 $sql = "CREATE TABLE ".$table_name." ( 115 id mediumint(9) NOT NULL AUTO_INCREMENT, 116 listing_id mediumint(9) NOT NULL, 117 package_id mediumint(9) NOT NULL, 118 trans_type VARCHAR(32) NOT NULL, 119 payment_status VARCHAR(32) NOT NULL, 120 payment_amount VARCHAR(32) NOT NULL, 121 trans_id VARCHAR(32) NOT NULL, 122 timestamp INT(11) NOT NULL, 123 email VARCHAR(64) NOT NULL, 124 UNIQUE KEY id (id) 125 );"; 126 $wpdb->query($sql); 127 } 128 delete_option('pbl_db_version'); 129 add_option("pbl_db_version",$pbl_db_version); 130 break; 131 } 70 132 if(get_option('pbl_db_version')=="1.0"){ 71 133 $table_name = $wpdb->prefix."pbl_listings"; … … 77 139 delete_option('pbl_db_version'); 78 140 add_option("pbl_db_version",$pbl_db_version); 79 } 80 141 } 81 142 82 143 //clean up old gd_ options if present -
paid-business-listings/trunk/inc/inc_pbl_settings_page.php
r501323 r590364 16 16 <li>Paste this shortcode into the page you would like to use to display your listings: [pbl-listings]</li> 17 17 <li>Paste this shortcode into the page you would like to use to display your submission form: [pbl-form]</li> 18 <li>Paste this shortcode into the page you would like to use as your "Submission Status" page: [pbl-substatus]</li>19 18 </ul> 20 19 … … 98 97 99 98 <tr valign="top"> 100 <th scope="row">Submission Status Page</th>101 <td>102 <?php103 $currently_selected_page=get_option('pbl_page_id');104 wp_dropdown_pages(array('selected'=>$currently_selected_page,'name'=>'pbl_page_id'));105 ?>106 <p>NOTE: The following shortcode MUST be pasted into the "Submission Status Page" in order for listings to be marked active after payment.</p>107 <p>[pbl-substatus]</p>108 </td>109 </tr>110 99 111 100 <tr valign="top"> -
paid-business-listings/trunk/inc/inc_thankyou_page_function.php
r570116 r590364 2 2 3 3 function thankyou_page_function($atts) { 4 global $wpdb; 5 6 if($_GET['subid']!=""){ 7 if($_GET['sc']==1){ 8 //MARK SUBMISSION ACTIVE AND DISPLAY THANK YOU MESSAGE 9 $id=$_GET['subid']; 10 $wpdb->update($wpdb->prefix.'pbl_listings',array('active'=>1),array('id'=>$id)); 11 12 $return.="<p>".get_option('pbl_thank_you_message')."</p>"; 13 }else{ 14 //LEAVE SUBMISSION INACTIVE AND DISPLAY BAIL MESSAGE 15 $return.="<p>".get_option('pbl_bail_message')."</p>"; 16 } 17 } 18 4 $site_url=get_site_url(); 5 $return="<p><a href='$site_url'>click here</a></p>"; 19 6 return $return; 20 21 7 }
Note: See TracChangeset
for help on using the changeset viewer.