function API_Re($tid, $co) { global $Channel, $userid, $username, $onlineip; ToOnezCode($co); $arr = array('pid' => '', 'fid' => $Channel['forumid'], 'tid' => $tid, 'aid' => '0', 'author' => $username, 'authorid' => $userid, 'icon' => '0', 'postdate' => time(), 'subject' => '', 'userip' => $onlineip, 'ifsign' => '1', 'ipfrom' => getaddress($onlineip), 'ifconvert' => '2', 'ifwordsfb' => '2', 'ifcheck' => '1', 'content' => $co, 'anonymous' => '0', 'ifhide' => '0'); Conn()->insert("posts", $arr); $pid = (int) Conn()->select("posts", "pid", "1 order by tid desc"); Conn()->query("UPDATE " . Conn()->tbl . "threads SET replies=replies+1,hits=hits+1, lastposter='{$username}', lastpost='" . time() . "' WHERE tid= '{$tid}'"); Conn()->query("UPDATE " . Conn()->tbl . "memberdata SET postnum=postnum+1, todaypost=todaypost+1, monthpost=monthpost+1, lastpost='" . time() . "' WHERE uid= '1' "); Conn()->query("UPDATE " . Conn()->tbl . "forumdata SET tpost=tpost+'1',article=article+'1' ,lastpost= 'Re:\t{$username}\t" . time() . "\tread.php?tid={$tid}&page=e#a' WHERE fid= '{$Channel['forumid']}' "); $value = (int) Conn()->select("elements", "value", "type='replysort' and mark='{$Channel['forumid']}'"); $value++; Conn()->query("REPLACE INTO " . Conn()->tbl . "elements (type,mark,id,value,addition,special) VALUES ('replysort','{$Channel['forumid']}','{$tid}','{$value}','','0') , ('replysortday','{$Channel['forumid']}','{$tid}','{$value}','" . time() . "','0') "); return 1; }
$this->db->join('asset_size', 'asset_size.asi_id = campaign_transaction.asi_id'); $select_query4 = $this->db->get(); $ass_size = ''; foreach ($select_query4->result() as $dat){ $ass_size = $ass_size . ',' .$dat->asi_description; } ?> <tr> <td><?php echo $data->mec_description;?></td> <td><?php echo $ass_size;?><input type="hidden" id="media_category" name="media_category" value="<?php echo $data->cam_latitude.','.$data->cam_longitude ;?>"></input></td> <td><?php $lat= $data->cam_latitude;// 26.754347; //latitude $lng= $data->cam_longitude; //81.001640; //longitude $address= getaddress($lat,$lng); if($address) { echo $address; } else { echo "Not found"; } // echo $data->address;?> </td> <td><?php echo "5km";?></td> <?php $ids = $_GET['id']; $this->db->where('cam_id', $ids);
$error .= "<br/>Your password is invalid."; } } if ($error) { $error = 'You have mistakes with your enter:' . $error; } else { $checkexistquery = "SELECT * FROM user WHERE email='" . $_POST['email'] . "'"; $checkesistresult = mysqli_query($link, $checkexistquery); $checkexistrows = mysqli_num_rows($checkesistresult); if ($checkexistrows) { $error = "this email has registered, Do you want to Log in?"; } else { $addnewuserquery = "INSERT INTO `User`(`Email`, `Password`,`Address`,`Name`,`RegisterTime`,`LastAccessTime`) VALUES ('" . $_POST['registeremail'] . "','" . $_POST['registerpassword'] . "','" . $_POST['registeraddress'] . "','" . $_POST['registername'] . "','" . $registertime . "','" . $registertime . "')"; mysqli_query($link, $addnewuserquery); $_SESSION['id'] = mysqli_insert_id($link); $array = getaddress($_POST['registeraddress']); insertWaitingList($link, $_SESSION['id'], getBlockId($link, $array[1], $array[2])); //echo getBlockId($link,$array[1],$array[2]); header("Location:NotMemberYet.php"); } } } if ($_POST['submit'] == "Log in") { date_default_timezone_set("America/New_York"); $lastaccesstime = date("Y-m-d H:i:s"); $loginquery = "SELECT * FROM User WHERE Email='" . $_POST['loginemail'] . "' AND Password='******'loginpassword'] . "'"; $loginresult = mysqli_query($link, $loginquery); $rows = mysqli_fetch_array($loginresult); if ($rows) { $_SESSION['id'] = $rows['UserId']; $_SESSION['blockid'] = $rows['BlockId'];
function fbe_facebook_sdk($facebook_page,$appID,$appSecret){ FacebookSession::setDefaultApplication($appID,$appSecret); $session = FacebookSession::newAppSession(); try { $session->validate(); } catch (FacebookRequestException $ex) { echo $ex->getMessage(); } catch (\Exception $ex) { echo $ex->getMessage(); } $i=0; $u=0; try{ $eventResponse = (new FacebookRequest($session, 'GET', '/'.$facebook_page.'/events?fields=place,cover,attending_count,description,end_time,id,name,owner,start_time,ticket_uri,timezone&limit=99'))->execute()->getResponse(); $events = $eventResponse->data; foreach ($events as $e) { $session = FacebookSession::newAppSession(); $venue = (new FacebookRequest($session, 'GET', '/'.$facebook_page.'?fields=phone,photos,username,about,category,cover,emails,general_info,general_manager,location,website&limit=99'))->execute()->getResponse(); $startDate = $e->start_time; $endDate = $e->end_time; $timezone = $e->timezone; // Convert time for myEventON $c_evcal_srow = date("U",strtotime($startDate)); $c_evcal_erow = date("U",strtotime($endDate)); $custom_year = date("U",strtotime($StartDate)); $c_event_year = gmdate("Y", $custom_year); // $category = $e->owner->category; $event_id = $e->id; $eId = wp_strip_all_tags($e->id); $city = $e->place->location->city; $state = $e->place->location->state; $zip = $e->place->location->zip; $street = $e->place->location->street; $region = $e->place->location->region; $country = $e->place->location->country; $ticket_uri = $e->ticket_uri; $eventImage = $e->cover->source; $name = $e->place->name; $fb_event_uri = 'https://www.facebook.com/events/'.$event_id; $lat = $e->place->location->latitude; $long = $e->place->location->longitude; $venue_name = $e->place->name; $venue_phone = $venue->phone; $venue_desc = $venue->about; $emails = $venue->emails; $username = $venue->username; $emailAddress = $emails[0]; $venue_website = $venue->website; $event_tag = $venue->category; ////PRINT ////$posts_array = get_posts('post_type=post_title'); ////print_r($posts_array); //print_r($e->place->name); ////PRINT if($state){ $state = $state.' '; } if($street){ $street = $street.', '; } if($city){ $city = $city.', '; } if($country){ $country = $country.' '; } if($region){ $region = $region.' '; } if($zip){ $zip = $zip.' '; } $location = $street.$city.$state.$zip.$country.$region ; $location = str_replace('<<not-applicable>>', '', $location); if($location == ' ' || $location == '' ){ $location = getaddress(get_fbe_field($lat),get_fbe_field($long)); } $args = array ( 'post_type' => 'facebook_events', 'posts_per_page' => -1, 'meta_key' => 'facebook_event_id', 'meta_query' => array( 'key' => 'facebook_event_id', 'value' => $event_id, ), ); $loop = new WP_Query( $args ); if( $loop->have_posts() ){ $u++; while ( $loop->have_posts() ) : $loop->the_post(); $post_id = get_the_ID(); $curEventImage = get_post_meta( $post_id, 'image_url', true ); $post_information = array( 'post_type' => 'facebook_events', 'ID' => $post_id, 'post_title' => wp_strip_all_tags($e->name), 'post_content' => wp_strip_all_tags($e->description), 'tags_input' => $event_tag, ); if($eventImage != $curEventImage ){insert_image($eventImage,$post_id); } wp_update_post( $post_information ); endwhile; } else { $post_information = array( 'post_type' => 'facebook_events', 'post_title' => wp_strip_all_tags($e->name), 'post_content' => wp_strip_all_tags($e->description), 'post_status' => 'publish', 'tags_input' => $event_tag, ); $post_id = wp_insert_post( $post_information ); insert_image($eventImage,$post_id); } /* $i++; update_post_meta($post_id,'event_timezone',$timezone); update_post_meta($post_id,'start_time',$startDate); update_post_meta($post_id,'event_starts',$startDate); update_post_meta($post_id,'event_starts_sort_field',$startDate); update_post_meta($post_id,'event_ends',$endDate); update_post_meta($post_id,'end_time', $endDate); update_post_meta($post_id,'facebook_event_id', $eId); update_post_meta($post_id,'location',$location); update_post_meta($post_id,'ticket_uri',$ticket_uri); update_post_meta($post_id,'fb_event_uri',$fb_event_uri); update_post_meta($post_id,'geo_latitude',$lat); update_post_meta($post_id,'geo_longitude',$long); update_post_meta($post_id,'venue_email',$emailAddress); update_post_meta($post_id,'venue_phone',$phone); update_post_meta($post_id,'venue_website',$website); update_post_meta($post_id,'facebook','https://facebook.com/'.$username); update_post_meta($post_id,'venue_desc',$venue_desc); update_post_meta($post_id,'venue_name',$venue_name); */ ///////////////////////////////////// // Get the Old Post $old_post = get_post( $post_id ); //$my_post_meta = get_post_meta($post_id, 'image_url', true); $args = array( 'numberposts' => 1, 'order'=> 'DESC', 'post_mime_type' => 'image', 'post_parent' => $post->ID, 'post_type' => 'attachment' ); $get_children_array = get_children($args,ARRAY_A); //returns Array ( [$image_ID]... $rekeyed_array = array_values($get_children_array); $child_image = $rekeyed_array[0]; // Show Facebook Events ID & Title echo "FB_Id -$post_id<br>"; echo "FB_Title -$old_post->post_title <br>"; //print_r($child_image); //Show the contents of the $child_image array. //echo "Show the $child_image ID"; echo "Image_Id -"; echo $child_image['ID']; //Show the $child_image ID. echo "<br>"; $post_image_media = get_post_meta($child_image['ID'], '_wp_attached_file', true); echo "Media_file - $post_image_media <br>"; //image location 2015/08/11800415_396471520542665_8991308386259432158_n142.jpg $new_post = array( 'post_status' => 'publish', 'menu_order' => $old_post->menu_order, 'post_type' => 'ajde_events', 'comment_status' => $old_post->comment_status, 'ping_status' => $old_post->ping_status, 'pinged' => $old_post->pinged, 'post_author' => $old_post->post_author, 'post_category' => $old_post->post_category, 'post_content' => $old_post->post_content, 'post_excerpt' => $old_post->post_excerpt, 'post_name' => $old_post->post_name, 'post_parent' => $old_post->post_parent, 'post_password' => $old_post->post_password, 'post_title' => $old_post->post_title, 'tags_input' => $old_post->tags_input, 'to_ping' => $old_post->to_ping, 'tax_input' => $old_post->tax_input, ); $new_post_id = wp_insert_post( $new_post ); ///////////////////////////////////////// update_post_meta($new_post_id,'_thumbnail_id', $child_image['ID']); echo "New_Post_Id- $new_post_id<br>"; echo "$new_post_id - _thumbnail_id - "; echo $child_image['ID']; echo "<br>"; echo "______________________ <br><br>"; $i++; /* update_post_meta($new_post_id,'evcal_event_color', 206177); update_post_meta($new_post_id,'evcal_location', $location); update_post_meta($new_post_id,'evcal_location_name', $venue_name); update_post_meta($new_post_id,'evcal_name_over_img', no); // update_post_meta($new_post_id,'evcal_organizer', HHHEventOrganizerNameHHH); // update_post_meta($new_post_id,'evcal_org_contact', $emailAddress); // update_post_meta($new_post_id,'evcal_lmlink', JJJEventLinkJJJ); update_post_meta($new_post_id,'evcal_subtitle', $venue_desc); update_post_meta($new_post_id,'evcal_gmap_gen', yes); update_post_meta($new_post_id,'evcal_repeat', no); update_post_meta($new_post_id,'evcal_rep_freq', daily); update_post_meta($new_post_id,'evcal_rep_gap', 1); update_post_meta($new_post_id,'evcal_rep_num', 1); update_post_meta($new_post_id,'evp_repeat_rb', dom); update_post_meta($new_post_id,'evo_repeat_wom', none); update_post_meta($new_post_id,'_evcal_exlink_option', 1); update_post_meta($new_post_id,'evo_hide_endtime', no); update_post_meta($new_post_id,'evo_span_hidden_end', no); update_post_meta($new_post_id,'evo_year_long', no); update_post_meta($new_post_id,'event_year', $c_event_year); update_post_meta($new_post_id,'evo_evcrd_field_org', no); update_post_meta($new_post_id,'evo_exclude_ev', no); update_post_meta($new_post_id,'_cancel', no); update_post_meta($new_post_id,'evcal_lat', $lat); update_post_meta($new_post_id,'evcal_lon', $long); update_post_meta($new_post_id,'evcal_srow', $c_evcal_srow); update_post_meta($new_post_id,'evcal_erow', $c_evcal_erow); update_post_meta($new_post_id,'_evcal_ec_f1a1_cus', Link); update_post_meta($new_post_id,'_evcal_ec_f1a1_cusL', $fb_event_uri); update_post_meta($new_post_id,' _evcal_ec_f1_onw', yes); update_post_meta($new_post_id,'_evcal_ec_f2a1_cus', Buy); update_post_meta($new_post_id,'_evcal_ec_f2a1_cusL', $ticket_uri); update_post_meta($new_post_id,'_evcal_ec_f2_onw', yes); */ // Image } $a =''; $c =''; $n =''; $error =''; if($u > 1){ $c = $u; $a = $i-$u; $n = 'updated'; } else { $c = $i; $n = 'imported'; } } catch(Exception $ex){ $error = $ex->getCode(); $errorMsg = $ex->getMessage(); if($error == 100 ){ echo '<div class="error" style="color:#222222; font-weight:700; font-size:1em; padding:10px">Error '.$error.': <a href="https://www.facebook.com/'.$facebook_page.'/events" target="_blank">'.$facebook_page.'</a>. <i> Country or age restricted material. Check your app settings.</i> </div>'; } else if ($error == 102){ echo '<div class="error" style="color:#222222; font-weight:700; font-size:1em; padding:10px">Error '.$error.': Session key invalid or no longer valid.</div>'; } else { echo '<div class="error" style="color:#222222; font-weight:700; font-size:1em; padding:10px">Error '.$error.' '.$errorMsg .' : Troubleshooting tip <a href="https://developers.facebook.com/docs/marketing-api/error-reference" target="_blank">View API Error Codes</a></div>'; } } if($a >= 1){ echo '<div class="updated" style="color:#222222; font-weight:700; font-size:1em; padding:10px">'.$a. ' events added</div>'; } if($i > 1){ echo '<div class="updated" style="color:#222222; font-weight:700; font-size:1em; padding:10px">'.$c . ' events '.$n.'</div>'; } else if($i == 0){ if($error != 100){ echo '<div class="updated" style="color:#222222; font-weight:700; font-size:1em; padding:10px">There are <b>no upcoming</b> events to import at <a href="https://www.facebook.com/'.$facebook_page.'/events" target="_blank">'.$facebook_page.'</a></div>'; } } else { echo '<div class="updated" style="color:#222222; font-weight:700; font-size:1em; padding:10px">'.$c . ' event '.$n.'</div>'; } }
<?php /** * Created by PhpStorm. * User: bowang * Date: 12/23/15 * Time: 16:56 */ error_reporting(0); include "DataRetrieval.php"; include "getaddress.php"; $temp = getaddress("348 61st St Brooklyn"); echo $temp[0]; echo $temp[1]; echo $temp[2];
<span class="pl15 pr15">丨</span>发票: 普通发票 / 个人 </div> <div class="sub_h4 font14 dark">配送: <?php echo $address["name"]; ?> / <?php echo $address["mobile_phone"]; ?> /<?php $arr = explode(',', $address['addressid']); echo getaddress($arr[0]); echo getaddress($arr[1]); echo getaddress($arr[2]); ?> ,<?php echo $address["address"]; ?> </div> <!-- <div class="sub_h4 font14 dark">配送: 张三 / 138****1111 / 湖北,武汉市,武昌区,光谷广场</div> --> </div></div>
* Time: 8:38 PM */ session_start(); include "DataRetrieval.php"; include "connection.php"; error_reporting(0); $success = ''; $error = ''; $getexsitinginfo = "SELECT * FROM User WHERE UserId = '" . $_SESSION['id'] . "'"; $result = mysqli_query($link, $getexsitinginfo); $results = mysqli_fetch_array($result); if (isset($_POST['submit']) && $_POST['submit'] == 'Update') { // if($_SESSION['blockid']){ // echo "here"; // //echo getBlockId($link,$array[1],$array[2]); // echo "here1"; $array = getaddress($_POST['updateaddress']); if (isMoveout($link, $array[1], $array[2], $_SESSION['blockid'])) { // echo "moveout"; insertMoveIn($link, $_SESSION['id'], getBlockId($link, $array[1], $array[2])); // echo "here"; insertWaitingList($link, $_SESSION['id'], getBlockId($link, $array[1], $array[2])); } // } $updateinfo = "UPDATE User SET Name= '" . $_POST['updatename'] . "',Age='" . $_POST['updateage'] . "',Gender='" . $_POST['updategender'] . "',Phone1='" . $_POST['updatephone1'] . "',\n Phone2='" . $_POST['updatephone2'] . "',Address='" . $_POST['updateaddress'] . "',Intro='" . $_POST['updateintro'] . "',NotifyMessage='" . $_POST['updatenotifymessage'] . "',NotifyType='" . $_POST['updatenotifytype'] . "'\n WHERE UserId = '" . $_SESSION['id'] . "'"; if (mysqli_query($link, $updateinfo)) { $success = "User Infomation Updated Successfully"; } else { $error = "Update Failure"; } }
} //See if we have an authenticated user, if so, setup the appropriate message. if (isset($_SESSION["loggedinUserName"])) { // See if xml_data is set, if so see what action the user wants. if (isset($xml_data)) { $xmldoc = simplexml_load_string($xml_data); $request = $xmldoc->action; } $userID = getUserID($connection); /* Output the XML Prolog so the client can tell it is XML */ $xml = <<<PROLOG <?xml version="1.0" encoding="iso-8859-1"?> PROLOG; switch ($request) { case 'getAddress': $xml .= getaddress($userID, $connection); break; case 'getExercises': $xml .= getexercises($userID, $connection, $category); break; case 'saveTemplate': $xml .= savetemplate($userID, $connection, $xml_data); break; case 'deleteTemplate': $xml .= deletetemplate($userID, $connection, $template); break; case 'loadTemplate': $xml .= loadtemplate($userID, $connection, $template); break; case 'saveDay': $xml .= saveday($userID, $connection, $xml_data);