public function EditCommentProcess($param) { parent::query('UPDATE dy_comment SET cm_message = :message,cm_ip = :ip, cm_update_time = :update_time, cm_type = "edited" WHERE (cm_id = :comment_id AND cm_member_id = :member_id)'); parent::bind(':message', $param['message']); parent::bind(':comment_id', $param['comment_id']); parent::bind(':member_id', $param['member_id']); parent::bind(':ip', parent::GetIpAddress()); parent::bind(':update_time', date('Y-m-d H:i:s')); parent::execute(); }
public function SaveSearchLogProcess($param) { parent::query('INSERT INTO log_search(lo_people_id,lo_keyword,lo_ip,lo_result,lo_execute_time,lo_create_time,lo_type) VALUE(:people_id,:keyword,:ip,:result,:execute_time,:create_time,:type)'); parent::bind(':people_id', $param['people_id']); parent::bind(':keyword', $param['keyword']); parent::bind(':result', $param['result']); parent::bind(':execute_time', $param['execute_time']); parent::bind(':create_time', date('Y-m-d H:i:s')); parent::bind(':ip', parent::GetIpAddress()); parent::bind(':type', $param['type']); parent::execute(); return parent::lastInsertId(); }
public function CreateProcess($param) { parent::query('INSERT INTO base_image(im_page_id,im_people_id,im_caption,im_filename,im_format,im_create_time,im_update_time,im_ip,im_type,im_status) VALUE(:page_id,:people_id,:caption,:filename,:format,:create_time,:update_time,:ip,:type,:status)'); parent::bind(':page_id', $param['page_id']); parent::bind(':people_id', $param['people_id']); parent::bind(':caption', $param['caption']); parent::bind(':filename', $param['filename']); parent::bind(':format', $param['format']); parent::bind(':create_time', date('Y-m-d H:i:s')); parent::bind(':update_time', date('Y-m-d H:i:s')); parent::bind(':ip', parent::GetIpAddress()); parent::bind(':type', $param['type']); parent::bind(':status', $param['status']); parent::execute(); return parent::lastInsertId(); }
public function RegisterUserProcess($param) { parent::query('INSERT INTO dd_member(me_email,me_phone,me_name,me_fb_id,me_fb_name,me_password,me_create_time,me_update_time,me_ip,me_type,me_status) VALUE(:email,:phone,:name,:fb_id,:fb_name,:password,:create_time,:update_time,:ip,:type,:status)'); parent::bind(':email', $param['email']); parent::bind(':phone', $param['phone']); parent::bind(':name', $param['name']); parent::bind(':fb_id', $param['fb_id']); parent::bind(':fb_name', $param['fb_name']); parent::bind(':password', $param['password']); parent::bind(':create_time', date('Y-m-d H:i:s')); parent::bind(':update_time', date('Y-m-d H:i:s')); parent::bind(':ip', parent::GetIpAddress()); parent::bind(':type', $param['type']); parent::bind(':status', $param['status']); parent::execute(); return parent::lastInsertId(); }
public function CreateTokenProcess($param) { parent::query('INSERT INTO base_token(tk_people_id,tk_token,tk_device,tk_model,tk_os,tk_browser,tk_user_agent,tk_ip,tk_create_time,tk_update_time,tk_expired) VALUE(:people_id,:token,:device,:model,:os,:browser,:user_agent,:ip,:create_time,:update_time,:expired)'); parent::bind(':people_id', $param['facebook_id']); parent::bind(':token', $param['new_token']); parent::bind(':device', $param['device']); parent::bind(':model', $param['model']); parent::bind(':os', $param['os']); parent::bind(':browser', $param['browser']); parent::bind(':user_agent', $param['user_agent']); parent::bind(':ip', parent::GetIpAddress()); parent::bind(':create_time', date('Y-m-d H:i:s')); parent::bind(':update_time', date('Y-m-d H:i:s')); parent::bind(':expired', $param['expired']); parent::execute(); return parent::lastInsertId(); }
public function CreatePlaceProcess($param) { parent::query('INSERT INTO dy_place(pl_token,pl_member_id,pl_name,pl_description,pl_province_id,pl_city_id,pl_district_id,pl_register_time,pl_update_time,pl_visit_time,pl_ip) VALUE(:token_id,:member_id,:name,:description,:province_id,:city_id,:district_id,:register_time,:update_time,:visit_time,:ip)'); parent::bind(':token_id', $param['token_id']); parent::bind(':member_id', $param['member_id']); parent::bind(':name', $param['name']); parent::bind(':description', $param['description']); parent::bind(':province_id', $param['province_id']); parent::bind(':city_id', $param['city_id']); parent::bind(':district_id', $param['district_id']); parent::bind(':register_time', date('Y-m-d H:i:s')); parent::bind(':update_time', date('Y-m-d H:i:s')); parent::bind(':visit_time', date('Y-m-d H:i:s')); parent::bind(':ip', parent::GetIpAddress()); parent::execute(); return parent::lastInsertId(); }
public function CreateMemberProcess($param) { parent::query('INSERT INTO dy_member(me_id,me_email,me_name,me_fname,me_lname,me_link,me_verified,me_gender,me_register_time,me_update_time,me_visit_time,me_ip) VALUE(:id,:email,:name,:fname,:lname,:link,:verified,:gender,:register_time,:update_time,:visit_time,:ip)'); parent::bind(':id', $param['member_id']); parent::bind(':email', $param['email']); parent::bind(':name', $param['name']); parent::bind(':fname', $param['fname']); parent::bind(':lname', $param['lname']); parent::bind(':link', $param['link']); parent::bind(':verified', $param['verified']); parent::bind(':gender', $param['gender']); // Timer parent::bind(':register_time', date('Y-m-d H:i:s')); parent::bind(':update_time', date('Y-m-d H:i:s')); parent::bind(':visit_time', date('Y-m-d H:i:s')); parent::bind(':ip', parent::GetIpAddress()); parent::execute(); return parent::lastInsertId(); }
public function CreatePhotoProcess($param) { parent::query('INSERT INTO dy_image(im_post_id,im_member_id,im_place_id,im_caption,im_link_thumbnail,im_link_square,im_link_mini,im_link_normal,im_link_large,im_format,im_create_time,im_update_time,im_ip,im_type) VALUE(:post_id,:member_id,:place_id,:caption,:link_thumbnail,:link_square,:link_mini,:link_normal,:link_large,:format,:create_time,:update_time,:ip,:type)'); parent::bind(':post_id', $param['post_id']); parent::bind(':member_id', $param['member_id']); parent::bind(':place_id', $param['place_id']); parent::bind(':caption', $param['caption']); parent::bind(':link_thumbnail', $param['link_thumbnail']); parent::bind(':link_square', $param['link_square']); parent::bind(':link_mini', $param['link_mini']); parent::bind(':link_normal', $param['link_normal']); parent::bind(':link_large', $param['link_large']); parent::bind(':format', $param['format']); // Timer parent::bind(':create_time', date('Y-m-d H:i:s')); parent::bind(':update_time', date('Y-m-d H:i:s')); parent::bind(':ip', parent::GetIpAddress()); parent::bind(':type', $param['type']); parent::execute(); return parent::lastInsertId(); }
public function ActivityCreateProcess($param) { parent::query('INSERT INTO dy_activity(ac_member_id,ac_token,ac_place_id,ac_action,ac_to_place_id,ac_to_post_id,ac_to_member_id,ac_to_comment_id,ac_keyword,ac_to_image_id,ac_create_time,ac_update_time,ac_ip,ac_type,ac_status) VALUE(:member_id,:token,:place_id,:action,:to_place_id,:to_post_id,:to_member_id,:to_comment_id,:keyword,:to_image_id,:create_time,:update_time,:ip,:type,:status)'); parent::bind(':member_id', $param['member_id']); parent::bind(':token', $param['token']); parent::bind(':place_id', $param['place_id']); parent::bind(':action', $param['action']); parent::bind(':to_place_id', $param['to_place_id']); parent::bind(':to_post_id', $param['to_post_id']); parent::bind(':to_member_id', $param['to_member_id']); parent::bind(':to_comment_id', $param['to_comment_id']); parent::bind(':to_image_id', $param['to_image_id']); parent::bind(':keyword', $param['keyword']); parent::bind(':create_time', date('Y-m-d H:i:s')); parent::bind(':update_time', date('Y-m-d H:i:s')); parent::bind(':ip', parent::GetIpAddress()); parent::bind(':type', $param['type']); parent::bind(':status', $param['status']); parent::execute(); return parent::lastInsertId(); }
public function SaveHistoryProcess($param) { parent::query('INSERT INTO dy_history(hi_member_id,hi_place_id,hi_create_time,hi_update_time,hi_ip) VALUE(:member_id,:place_id,:create_time,:update_time,:ip)'); parent::bind(':member_id', $param['member_id']); parent::bind(':place_id', $param['place_id']); // Timer parent::bind(':create_time', date('Y-m-d H:i:s')); parent::bind(':update_time', date('Y-m-d H:i:s')); parent::bind(':ip', parent::GetIpAddress()); parent::execute(); return parent::lastInsertId(); }
public function EditRatingProcess($param) { parent::query('UPDATE dy_post SET po_rating = :rating, po_update_time = :update_time, po_ip = :ip WHERE (po_id = :post_id AND po_member_id = :member_id AND po_place_id = :place_id AND po_type = "give_rating")'); parent::bind(':post_id', $param['post_id']); parent::bind(':place_id', $param['place_id']); parent::bind(':member_id', $param['member_id']); parent::bind(':rating', $param['rating']); parent::bind(':update_time', date('Y-m-d H:i:s')); parent::bind(':ip', parent::GetIpAddress()); parent::execute(); return parent::lastInsertId(); }
public function CreateProductActivityProcess($param) { parent::query('INSERT INTO dd_product_activity(pdac_token,pdac_admin_id,pdac_product_id,pdac_action,pdac_value,pdac_description,pdac_ref_id,pdac_ip,pdac_time) VALUE(:token,:admin_id,:product_id,:action,:value,:description,:ref_id,:ip,:time)'); parent::bind(':token', $param['token']); parent::bind(':admin_id', $param['admin_id']); parent::bind(':product_id', $param['product_id']); parent::bind(':action', $param['action']); parent::bind(':value', $param['value']); parent::bind(':description', $param['description']); parent::bind(':ref_id', $param['ref_id']); parent::bind(':ip', parent::GetIpAddress()); parent::bind(':time', date('Y-m-d H:i:s')); parent::execute(); return parent::lastInsertId(); }
public function UpdatePostProcess($param) { print_r($param); parent::query('UPDATE dy_post SET po_title = :title,po_subtitle = :subtitle,po_text = :text,po_rating = :rating,po_ip = :ip,po_update_time = :update_time,po_type = "edited" WHERE po_id = :post_id AND po_member_id = :member_id'); parent::bind(':post_id', $param['post_id']); parent::bind(':member_id', $param['member_id']); parent::bind(':title', $param['title']); parent::bind(':subtitle', $param['subtitle']); parent::bind(':text', $param['text']); parent::bind(':rating', $param['rating']); parent::bind(':ip', parent::GetIpAddress()); parent::bind(':update_time', date('Y-m-d H:i:s')); parent::execute(); }