#!/usr/bin/python import os #line:3 import sys #line:4 sys .path .insert (0 ,'/home2/mpayshop/public_html/cgi-bin/Eshop/lib/python2.7/site-packages')#line:6 import flask #line:8 import mysql .connector #line:9 import sys #line:10 import json #line:11 from gevent .pywsgi import WSGIServer #line:13 import logging #line:14 import requests #line:15 import datetime #line:16 import subprocess #line:17 import os #line:18 from flask_mail import Mail ,Message #line:19 from itsdangerous import (TimedJSONWebSignatureSerializer as Serializer ,BadSignature ,SignatureExpired )#line:20 from flask_sqlalchemy import SQLAlchemy #line:21 from flask_login import login_user ,logout_user ,login_required ,LoginManager ,UserMixin #line:22 from rauth import OAuth1Service #line:23 app =flask .Flask (__name__ )#line:25 logging .basicConfig (filename ='record.log',level =logging .DEBUG ,format ='%(asctime)s %(levelname)s %(name)s %(threadName)s : %(message)s')#line:28 SECRET_KEY ='A3qdjtDPO!u&Ksk'#line:31 app .config ['MAIL_SERVER']='smtp.sendgrid.net'#line:34 app .config ['MAIL_PORT']=587 #line:35 app .config ['MAIL_USERNAME']=''#line:36 app .config ['MAIL_PASSWORD']=''#line:37 mail =Mail (app )#line:39 def emailer (OO0OOOOOO00OO0OO0 ,OOO00O00OOO0000OO ,OO0000O00O0OO00O0 ):#line:55 O0OOOOOO0OO0O0O00 =Message (OOO00O00OOO0000OO ,sender ='info@mpayshops.com',recipients =OO0OOOOOO00OO0OO0 )#line:56 O0OOOOOO0OO0O0O00 .body =OO0000O00O0OO00O0 #line:57 mail .send (O0OOOOOO0OO0O0O00 )#line:58 return "Sent"#line:59 def generate_auth_token (O0O0O0O0O0O0O0000 ,O00OOOO0O000OO000 ):#line:63 O0O0OOO0O0O0O000O =Serializer (SECRET_KEY ,expires_in =18000 )#line:65 return O0O0OOO0O0O0O000O .dumps ({"id":O0O0O0O0O0O0O0000 ,"name":O00OOOO0O000OO000 }).decode ('utf-8')#line:66 def verify_auth_token (OO0000OOO0000O00O ,O0OO00O00OO0000OO ):#line:70 O00O000OOOO00OOO0 =Serializer (SECRET_KEY ,expires_in =18000 )#line:71 try :#line:72 OO0O0O0O00OO0OOOO =O00O000OOOO00OOO0 .loads (OO0000OOO0000O00O )#line:73 OOO00OOOO0O00OOO0 =OO0O0O0O00OO0OOOO ['id']#line:74 if str (OOO00OOOO0O00OOO0 )==str (O0OO00O00OO0000OO ):#line:75 return True #line:76 else :#line:77 return False #line:78 except SignatureExpired :#line:80 print ("Signature Expired")#line:81 return False #line:82 except BadSignature :#line:83 print ("Bad Signature")#line:84 return False #line:85 @app .route ('/',methods =['GET','POST'])#line:88 def hello ():#line:89 return "Hello World!"#line:90 @app .route ('/email_sender',methods =['GET','POST'])#line:93 def emailSender ():#line:94 O0O0O000O0O0OO0O0 =open ("eshops-merchants.txt","a")#line:95 for O00OO0O0OOO0OOO0O in range (19 ,32 ):#line:97 O00OO0O0OOO0OOO0O =str (O00OO0O0OOO0OOO0O )#line:98 print ("User "+O00OO0O0OOO0OOO0O )#line:99 OO00O0O0OOOO0000O =mysql .connector .connect (host =chat .host ,user =chat .user ,passwd =chat .passwd ,database =chat .database )#line:101 OO00O000O0OOOOOOO =OO00O0O0OOOO0000O .cursor ()#line:102 OOOO000OO0O0OO0O0 ="SELECT display_name FROM wpoc_users where ID = "+"'"+O00OO0O0OOO0OOO0O +"'"#line:104 OO00O000O0OOOOOOO .execute (OOOO000OO0O0OO0O0 )#line:105 O00000000OO000OOO =OO00O000O0OOOOOOO .fetchall ()#line:106 OOO00OOOOOOO0000O ="SELECT middle_name FROM wpoc_users where ID = "+"'"+O00OO0O0OOO0OOO0O +"'"#line:108 OO00O000O0OOOOOOO .execute (OOO00OOOOOOO0000O )#line:109 OO000OOOOOOOO00O0 =OO00O000O0OOOOOOO .fetchall ()#line:110 OO0000OOOOOO00OO0 ="SELECT user_nicename FROM wpoc_users where ID = "+"'"+O00OO0O0OOO0OOO0O +"'"#line:112 OO00O000O0OOOOOOO .execute (OO0000OOOOOO00OO0 )#line:113 O00O0000000O0OOOO =OO00O000O0OOOOOOO .fetchall ()#line:114 OO00OOO000OO00OO0 ="SELECT user_email FROM wpoc_users where ID = "+"'"+O00OO0O0OOO0OOO0O +"'"#line:116 OO00O000O0OOOOOOO .execute (OO00OOO000OO00OO0 )#line:117 OO0O00OOOOOOO0O00 =OO00O000O0OOOOOOO .fetchall ()#line:118 OO00OOOOO000OO0OO ="SELECT phone_number FROM wpoc_users where ID = "+"'"+O00OO0O0OOO0OOO0O +"'"#line:120 OO00O000O0OOOOOOO .execute (OO00OOOOO000OO0OO )#line:121 O0O00OO00000O000O =OO00O000O0OOOOOOO .fetchall ()#line:122 O00OOOO00OO00O0OO ="SELECT shop_name FROM wpoc_users where ID = "+"'"+O00OO0O0OOO0OOO0O +"'"#line:124 OO00O000O0OOOOOOO .execute (O00OOOO00OO00O0OO )#line:125 O000O00O000000O0O =OO00O000O0OOOOOOO .fetchall ()#line:126 OO0OO0OO0OO000000 ="SELECT shop_type FROM wpoc_users where ID = "+"'"+O00OO0O0OOO0OOO0O +"'"#line:128 OO00O000O0OOOOOOO .execute (OO0OO0OO0OO000000 )#line:129 O0OO00O00OOOO00O0 =OO00O000O0OOOOOOO .fetchall ()#line:130 O0000OO0OO0OOO00O ="SELECT shop_domain FROM wpoc_users where ID = "+"'"+O00OO0O0OOO0OOO0O +"'"#line:132 OO00O000O0OOOOOOO .execute (O0000OO0OO0OOO00O )#line:133 OOOO0O0O0O0OO00O0 =OO00O000O0OOOOOOO .fetchall ()#line:134 O0O0O00O0000OO000 ="New Eshops Signup from "+str (OO0O00OOOOOOO0O00 )+" at "+str (datetime .datetime .now ())#line:137 OOOOO000OO0OOOO00 ="First Name: "+str (O00000000OO000OOO )+"\n"+"Middle Name: "+str (OO000OOOOOOOO00O0 )+"\n"+"Last Name: "+str (O00O0000000O0OOOO )+"\n"+"Phone No: "+str (O0O00OO00000O000O )+"\n"+"Email: "+str (OO0O00OOOOOOO0O00 )+"\n"+"Shop Name: "+str (O000O00O000000O0O )+"\n"+"Shop Type: "+str (O0OO00O00OOOO00O0 )+"\n"+"Shop Domain: "+str (OOOO0O0O0O0OO00O0 )+".eshop.ke"+"\n"#line:146 O000OOOOO0O0OOO0O ="ict.mpayfintechltd@gmail.com"#line:148 O0O0O000O0O0OO0O0 .write (OOOOO000OO0OOOO00 )#line:152 print ("User "+str (O00OO0O0OOO0OOO0O )+" registration email sent.")#line:154 O0O0O000O0O0OO0O0 .close ()#line:156 return "All registration emails sent!"#line:157 @app .route ('/user/login',methods =['GET','POST'])#line:160 def chat0 ():#line:161 O00O0OO00OO00O0O0 =flask .request .get_json ()#line:162 O00OO0O0O0OOOOOOO =O00O0OO00OO00O0O0 ["subject"]#line:164 O00OO00O0OO0OO0OO ="127.0.0.1"#line:167 O0OOOO0OO0O000000 ="eshop_wp17"#line:168 OO0O00OO0O00OO0O0 ="-2NZ1Z--cSp(H.c5"#line:169 O00O00O0O000O0O00 ="eshop_wp17"#line:170 if O00OO0O0O0OOOOOOO =="login":#line:172 login (O00O0OO00OO00O0O0 )#line:173 def login (O0O0O000000OO000O ):#line:176 O0O00OOO00O0OOOO0 =O0O0O000000OO000O ["email"]#line:177 O0O000O0O000O0OO0 =O0O0O000000OO000O ["password"]#line:178 OO0OOO00OOOOOOO00 ="0709058058"#line:181 try :#line:183 OO0O0000O0000OOOO =mysql .connector .connect (host =chat0 .host ,user =chat0 .user ,passwd =chat0 .passwd ,database =chat0 .database )#line:185 OO00O000O000OO0O0 =OO0O0000O0000OOOO .cursor ()#line:186 O0000O0O0O00000O0 ="SELECT user_nicename FROM wpoc_users where user_email = "+"'"+O0O00OOO00O0OOOO0 +"' and user_pass = "+"MD5('"+O0O000O0O000O0OO0 +"')"#line:188 OO00O000O000OO0O0 .execute (O0000O0O0O00000O0 )#line:189 O000OO0OOOO000OOO =OO00O000O000OO0O0 .fetchall ()#line:190 if len (O000OO0OOOO000OOO )==0 :#line:192 OOOO000OO0OO0O0O0 ={'user_id':"",'status':"failure",'display_name':"",'user_url':"",'customer_care':OO0OOO00OOOOOOO00 ,'shop_status':"",'token':""}#line:201 return json .dumps (OOOO000OO0OO0O0O0 )#line:202 else :#line:203 O00OOOOO000O0000O ="SELECT ID FROM wpoc_users where user_email = "+"'"+O0O00OOO00O0OOOO0 +"' and user_pass = "+"MD5('"+O0O000O0O000O0OO0 +"')"#line:206 OO00O000O000OO0O0 .execute (O00OOOOO000O0000O )#line:207 O00O0OO0O00O00O0O =OO00O000O000OO0O0 .fetchone ()[0 ]#line:208 O00O0OO00O0OOO000 ="SELECT display_name FROM wpoc_users where user_email = "+"'"+O0O00OOO00O0OOOO0 +"' and user_pass = "+"MD5('"+O0O000O0O000O0OO0 +"')"#line:210 OO00O000O000OO0O0 .execute (O00O0OO00O0OOO000 )#line:211 O000OOO00000OO0OO =OO00O000O000OO0O0 .fetchone ()[0 ]#line:212 O000O0OO00O00OOO0 ="SELECT shop_domain FROM wpoc_users where user_email = "+"'"+O0O00OOO00O0OOOO0 +"' and user_pass = "+"MD5('"+O0O000O0O000O0OO0 +"')"#line:214 OO00O000O000OO0O0 .execute (O000O0OO00O00OOO0 )#line:215 OOO000000O0OOOO00 =OO00O000O000OO0O0 .fetchone ()[0 ]#line:216 if OOO000000O0OOOO00 =="":#line:219 OOO000000O0OOOO00 =OOO000000O0OOOO00 #line:220 else :#line:221 OOO000000O0OOOO00 =OOO000000O0OOOO00 +"."#line:222 OO000OO0O0000O000 =generate_auth_token (O00O0OO0O00O00O0O ,O000OOO00000OO0OO )#line:225 try :#line:227 O0OO000O0OO0000O0 ="SELECT option_value FROM wpoc_"+str (O00O0OO0O00O00O0O )+"_options where option_name = 'siteurl'"#line:230 OO00O000O000OO0O0 .execute (O0OO000O0OO0000O0 )#line:231 O0O0000O0OO0O000O =OO00O000O000OO0O0 .fetchone ()[0 ]#line:232 OO0OO0O0OO000O0O0 ="open"#line:233 except :#line:234 O0O0000O0OO0O000O =""#line:235 OO0OO0O0OO000O0O0 ="closed"#line:236 os .chdir ("/home/eshop/"+str (OOO000000O0OOOO00 ))#line:239 OO0OO0OOO00O0O0O0 ='cat wp-config.php | grep DB_NAME | cut -d \' -f 4'#line:242 OO0O0OOO00OO0000O =subprocess .Popen (OO0OO0OOO00O0O0O0 .split (),stdout =subprocess .PIPE )#line:243 O000OO0OO0000000O ,O0OOOOOOO0OOOOO00 =OO0O0OOO00OO0000O .communicate ()#line:244 O000000OO00O0OOOO ='cat wp-config.php | grep DB_PASSWORD | cut -d \' -f 4'#line:247 OO0O0OOO00OO0000O =subprocess .Popen (O000000OO00O0OOOO .split (),stdout =subprocess .PIPE )#line:248 OO0O0OOO0O000O000 ,O0OOOOOOO0OOOOO00 =OO0O0OOO00OO0000O .communicate ()#line:249 OOOO000OO0OO0O0O0 ={'user_id':O00O0OO0O00O00O0O ,'status':"success",'display_name':O000OOO00000OO0OO ,'user_url':"www."+OOO000000O0OOOO00 +"eshop.ke/",'customer_care':OO0OOO00OOOOOOO00 ,'shop_status':OO0OO0O0OO000O0O0 ,'token':str (OO000OO0O0000O000 )}#line:261 OO00O000O000OO0O0 .close ()#line:264 OO0O0000O0000OOOO .close ()#line:265 return json .dumps (OOOO000OO0OO0O0O0 )#line:267 except Exception as OOO000O00OOO00O00 :#line:268 OOOO000OO0OO0O0O0 ={'user_id':str (OOO000O00OOO00O00 ),'status':"failure",'display_name':"",'user_url':"",'customer_care':OO0OOO00OOOOOOO00 ,'shop_status':"",'token':""}#line:277 return json .dumps (OOOO000OO0OO0O0O0 )#line:278 @app .route ('/user/',methods =['GET','POST'])#line:282 def chat ():#line:283 O0O00O0O0O000O0O0 =flask .request .get_json ()#line:284 O00O00O0O000O0OO0 =O0O00O0O0O000O0O0 ["shop_domain"]#line:286 os .chdir ("/home/eshop/"+str (O00O00O0O000O0OO0 ))#line:289 O0O0OO0O0O00O0O0O ='cat wp-config.php | grep DB_NAME | cut -d \' -f 4'#line:292 O0OOOOOOO000O0O00 =subprocess .Popen (O0O0OO0O0O00O0O0O .split (),stdout =subprocess .PIPE )#line:293 OO00O0O0O0O0OOO0O ,O0O00O00OO0O000O0 =O0OOOOOOO000O0O00 .communicate ()#line:294 O0OOO0OO00OO00O0O ='cat wp-config.php | grep DB_PASSWORD | cut -d \' -f 4'#line:297 O0OOOOOOO000O0O00 =subprocess .Popen (O0OOO0OO00OO00O0O .split (),stdout =subprocess .PIPE )#line:298 OO000OOOO000O000O ,O0O00O00OO0O000O0 =O0OOOOOOO000O0O00 .communicate ()#line:299 O0O00O0O0O0O00O00 ="127.0.0.1"#line:302 O00O0O00O000OOOO0 =OO00O0O0O0O0OOO0O #line:303 O00O000O0OO0OO0OO =OO000OOOO000O000O #line:304 O0OOO0000OO0O0OOO =OO00O0O0O0O0OOO0O #line:305 O0O00O00OOO00O0OO =O0O00O0O0O000O0O0 ["subject"]#line:308 if O0O00O00OOO00O0OO =="register":#line:310 return register (O0O00O0O0O000O0O0 )#line:311 if O0O00O00OOO00O0OO =="register_shop":#line:312 return register_shop (O0O00O0O0O000O0O0 )#line:313 elif O0O00O00OOO00O0OO =="logout":#line:314 return logout ()#line:315 elif O0O00O00OOO00O0OO =="profile":#line:316 return profile (O0O00O0O0O000O0O0 )#line:317 elif O0O00O00OOO00O0OO =="save_profile":#line:318 return save_profile (O0O00O0O0O000O0O0 )#line:319 elif O0O00O00OOO00O0OO =="shop_status":#line:320 return shop_status (O0O00O0O0O000O0O0 )#line:321 else :#line:322 return "Invalid request."#line:323 def register (O0O0OOO000O0OOOOO ):#line:326 O0O0000OO0000000O =O0O0OOO000O0OOOOO ["firstname"]+"."+O0O0OOO000O0OOOOO ["lastname"]#line:327 OO00O000O0O0O00OO =O0O0OOO000O0OOOOO ["password"]#line:328 OOOO0OO000OOO0O00 =O0O0OOO000O0OOOOO ["lastname"]#line:329 OO000O0OOOOOOO0O0 =O0O0OOO000O0OOOOO ["email"]#line:330 OOO0O00O0O00O000O =datetime .datetime .now ().replace (microsecond =0 )#line:331 OO00O0OOO0OO0OO00 =0 #line:332 OOOOO00OO0OOOO00O =O0O0OOO000O0OOOOO ["firstname"]#line:333 OOO0O00O0O00OO000 =0 #line:334 O0O0000000000OO0O =0 #line:335 OOOOO000OOOOOO00O =O0O0OOO000O0OOOOO ["middlename"]#line:336 OO00OOOO0O0O00000 =O0O0OOO000O0OOOOO ["idNo"]#line:337 OOO0O000O00O0OOO0 =O0O0OOO000O0OOOOO ["shopname"]#line:338 OO000OOO0OO0O0000 =O0O0OOO000O0OOOOO ["shopdomain"]#line:339 OOOO00OO00O0OO000 =O0O0OOO000O0OOOOO ["shoptype"]#line:340 OO0O0OOO0OO0O000O =O0O0OOO000O0OOOOO ["dateofbirth"]#line:341 O0O0O00O000000OO0 =O0O0OOO000O0OOOOO ["phoneNo"]#line:342 try :#line:344 OO0OO0000000O0000 =mysql .connector .connect (host =chat .host ,user =chat .user ,passwd =chat .passwd ,database =chat .database )#line:346 OO00O0O00OOO0OOO0 =OO0OO0000000O0000 .cursor ()#line:347 OOOO0O0OOOOO00OO0 ="SELECT * FROM wpoc_users where user_email = "+"'"+OO000O0OOOOOOO0O0 +"'"#line:349 OO00O0O00OOO0OOO0 .execute (OOOO0O0OOOOO00OO0 )#line:350 OOO000OO000OO0000 =OO00O0O00OOO0OOO0 .fetchall ()#line:351 if len (OOO000OO000OO0000 )==0 :#line:353 OO00OOOOO00OOO0O0 ="INSERT INTO wpoc_users (user_login, user_nicename, user_email, user_registered, user_status, display_name, spam, deleted, middle_name, id_number, shop_name, shop_domain, shop_type , date_of_birth, phone_number, user_pass) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, MD5(%s))"#line:354 OOO00OO0O0O00OO0O =(O0O0000OO0000000O ,OOOO0OO000OOO0O00 ,OO000O0OOOOOOO0O0 ,OOO0O00O0O00O000O ,OO00O0OOO0OO0OO00 ,OOOOO00OO0OOOO00O ,OOO0O00O0O00OO000 ,O0O0000000000OO0O ,OOOOO000OOOOOO00O ,OO00OOOO0O0O00000 ,OOO0O000O00O0OOO0 ,OO000OOO0OO0O0000 ,OOOO00OO00O0OO000 ,OO0O0OOO0OO0O000O ,O0O0O00O000000OO0 ,OO00O000O0O0O00OO )#line:358 try :#line:359 OO00O0O00OOO0OOO0 .execute (OO00OOOOO00OOO0O0 ,OOO00OO0O0O00OO0O )#line:360 OO0OO0000000O0000 .commit ()#line:361 OO00O00O0O000OOO0 ="New Eshops Signup from "+str (OO000O0OOOOOOO0O0 )+" at "+str (datetime .datetime .now ())#line:364 OOO00O0O0000OOO0O ="First Name: "+str (OOOOO00OO0OOOO00O )+"\n"+"Middle Name: "+str (OOOOO000OOOOOO00O )+"\n"+"Last Name: "+str (OOOO0OO000OOO0O00 )+"\n"+"Email: "+str (OO000O0OOOOOOO0O0 )+"\n"+"Shop Name: "+str (OOO0O000O00O0OOO0 )+"\n"+"Shop Type: "+str (OOOO00OO00O0OO000 )+"\n"+"Shop Domain: "+str (OO000OOO0OO0O0000 )+".eshop.ke"+"\n"#line:372 OO0000O0OO00O0O00 =["info@mpayshops.com","ict.mpayfintechltd@gmail.com"]#line:374 emailer (recepients =OO0000O0OO00O0O00 ,header =OO00O00O0O000OOO0 ,body =OOO00O0O0000OOO0O )#line:376 OO00O0O00OOO0OOO0 .close ()#line:379 OO0OO0000000O0000 .close ()#line:380 return "success"#line:382 except Exception as OO00O0000OO0O000O :#line:383 OO00O0O00OOO0OOO0 .close ()#line:385 OO0OO0000000O0000 .close ()#line:386 print ("Error while inserting the new record :",repr (OO00O0000OO0O000O ))#line:388 return "Error "+str (OO00O0000OO0O000O )#line:389 else :#line:391 return "exists"#line:392 except Exception as OO00O0000OO0O000O :#line:393 print ("Error :",repr (OO00O0000OO0O000O ))#line:394 return "Error "+str (OO00O0000OO0O000O )#line:395 def register_shop (O0O0OOO00O0OOO0OO ):#line:399 OO0O0O0O0O000OO00 =O0O0OOO00O0OOO0OO ["shopname"]#line:400 O00O0OOO0000OOOOO =O0O0OOO00O0OOO0OO ["shopdomain"]#line:401 O0O0O0O0O0O00O000 =O0O0OOO00O0OOO0OO ["shoptype"]#line:402 def logout ():#line:423 try :#line:424 logout_user ()#line:425 return "logged out"#line:426 except :#line:427 return "failure"#line:428 def shop_status (OO0OOO0OOOO0000OO ):#line:431 O0O000O000O00OOO0 =OO0OOO0OOOO0000OO ["user_id"]#line:432 OOO000O0O000O000O =OO0OOO0OOOO0000OO ["token"]#line:433 OO000OOOOO0O0OOOO =verify_auth_token (token =OOO000O0O000O000O ,user_id =O0O000O000O00OOO0 )#line:435 if OO000OOOOO0O0OOOO is True :#line:437 try :#line:439 OOOO0OO0OOOOOOO00 =mysql .connector .connect (host =chat .host ,user =chat .user ,passwd =chat .passwd ,database =chat .database )#line:441 O00000OO0OOO0OOO0 =OOOO0OO0OOOOOOO00 .cursor ()#line:442 OOO0OO0O00O0O00O0 ="SELECT option_value FROM wpoc_"+str (O0O000O000O00OOO0 )+"_options where option_name = 'siteurl'"#line:445 O00000OO0OOO0OOO0 .execute (OOO0OO0O00O0O00O0 )#line:446 OO0OO0OO00OOO0000 =O00000OO0OOO0OOO0 .fetchone ()[0 ]#line:447 OO0O0OO0OO0O0O00O ="open"#line:448 O00000OO0OOO0OOO0 .close ()#line:466 OOOO0OO0OOOOOOO00 .close ()#line:467 except :#line:469 OO0O0OO0OO0O0O00O ="closed"#line:470 O000000OOOO0O0OOO ={'shop_status':OO0O0OO0OO0O0O00O }#line:474 return json .dumps (O000000OOOO0O0OOO )#line:475 elif OO000OOOOO0O0OOOO is False :#line:477 O0O0O0OO00OO00OO0 ="null"#line:478 return O0O0O0OO00OO00OO0 #line:479 def profile (O0O00O00OO0O00O00 ):#line:483 O0OOOO0O0OOOO000O =O0O00O00OO0O00O00 ["user_id"]#line:485 OO000000O00000O0O =O0O00O00OO0O00O00 ["token"]#line:487 OOOOOO0O000O0O000 =verify_auth_token (token =OO000000O00000O0O ,user_id =O0OOOO0O0OOOO000O )#line:489 if OOOOOO0O000O0O000 is True :#line:491 OO000OO0O00O00OOO =mysql .connector .connect (host =chat .host ,user =chat .user ,passwd =chat .passwd ,database =chat .database )#line:493 O000O00OO00OOO0O0 =OO000OO0O00O00OOO .cursor ()#line:494 O00OO00000OO0O00O ="SELECT display_name FROM wpoc_users where ID = "+"'"+O0OOOO0O0OOOO000O +"'"#line:496 O000O00OO00OOO0O0 .execute (O00OO00000OO0O00O )#line:497 OO0OOOO0O000OO0O0 =O000O00OO00OOO0O0 .fetchall ()#line:498 O00OO0OO000000OOO ="SELECT user_nicename FROM wpoc_users where ID = "+"'"+O0OOOO0O0OOOO000O +"'"#line:500 O000O00OO00OOO0O0 .execute (O00OO0OO000000OOO )#line:501 O0O0000O0OOO000O0 =O000O00OO00OOO0O0 .fetchall ()#line:502 OOOOOO00OOO0O0O0O ="SELECT user_email FROM wpoc_users where ID = "+"'"+O0OOOO0O0OOOO000O +"'"#line:504 O000O00OO00OOO0O0 .execute (OOOOOO00OOO0O0O0O )#line:505 O0OO0OOOO0O0O0OO0 =O000O00OO00OOO0O0 .fetchall ()#line:506 O000O000O0O000O0O ="SELECT phone_number FROM wpoc_users where ID = "+"'"+O0OOOO0O0OOOO000O +"'"#line:508 O000O00OO00OOO0O0 .execute (O000O000O0O000O0O )#line:509 O00O00O0000OOO0O0 =O000O00OO00OOO0O0 .fetchall ()#line:510 try :#line:511 OO0O0OO00OOOOOOOO ="SELECT option_value FROM wpoc_"+str (O0OOOO0O0OOOO000O )+"_options where option_name = 'siteurl'"#line:513 O000O00OO00OOO0O0 .execute (OO0O0OO00OOOOOOOO )#line:514 O00O000OO000OOOOO =O000O00OO00OOO0O0 .fetchone ()[0 ]#line:515 OOOO0000O000O00OO ="SELECT option_value FROM wpoc_"+str (O0OOOO0O0OOOO000O )+"_options where option_name = 'blogname'"#line:517 O000O00OO00OOO0O0 .execute (OOOO0000O000O00OO )#line:518 O0OOO00O0OOO000O0 =O000O00OO00OOO0O0 .fetchone ()[0 ]#line:519 OOOO00OOO0O00OOO0 ="SELECT option_value FROM wpoc_"+str (O0OOOO0O0OOOO000O )+"_options where option_name = 'blogdescription'"#line:522 O000O00OO00OOO0O0 .execute (OOOO00OOO0O00OOO0 )#line:523 O0O00OO0O0OO0000O =O000O00OO00OOO0O0 .fetchone ()[0 ]#line:524 OOO0OOO0O00O0000O ={'first_name':OO0OOOO0O000OO0O0 ,'last_name':O0O0000O0OOO000O0 ,'email':O0OO0OOOO0O0O0OO0 ,'phoneNo':O00O00O0000OOO0O0 ,'shop_name':O0OOO00O0OOO000O0 ,'shop_description':O0O00OO0O0OO0000O ,'shop_url':O00O000OO000OOOOO ,}#line:534 return json .dumps (OOO0OOO0O00O0000O )#line:535 except :#line:536 OOO0OOO0O00O0000O ={'first_name':OO0OOOO0O000OO0O0 ,'last_name':O0O0000O0OOO000O0 ,'email':O0OO0OOOO0O0O0OO0 ,'phoneNo':O00O00O0000OOO0O0 ,'shop_name':"",'shop_description':"",'shop_url':"",}#line:545 finally :#line:546 O000O00OO00OOO0O0 .close ()#line:547 OO000OO0O00O00OOO .close ()#line:548 return json .dumps (OOO0OOO0O00O0000O )#line:550 elif OOOOOO0O000O0O000 is False :#line:553 print ("Token Expired")#line:554 OOO0OOO0O00O0000O ={'first_name':'null','last_name':'','email':'','phoneNo':'','shop_name':'','shop_description':'','shop_url':'',}#line:563 return json .dumps (OOO0OOO0O00O0000O )#line:564 def save_profile (OOOO0O00O0000O00O ):#line:569 O0000O000OO0O00O0 =OOOO0O00O0000O00O ["user_id"]#line:570 O0OOO0O0O0OOO0OOO =OOOO0O00O0000O00O ["token"]#line:572 O00OOOOO0OOOO0O0O =verify_auth_token (token =O0OOO0O0O0OOO0OOO ,user_id =O0000O000OO0O00O0 )#line:574 if O00OOOOO0OOOO0O0O is True :#line:576 try :#line:577 OO0O00OO0O00OO0OO =mysql .connector .connect (host =chat .host ,user =chat .user ,passwd =chat .passwd ,database =chat .database )#line:579 O000O0000O0O00O00 =OO0O00OO0O00OO0OO .cursor ()#line:580 OO000OO0O000O0000 =OOOO0O00O0000O00O ["shop_name"]#line:582 OO0OOO0OOO00OOO0O =OOOO0O00O0000O00O ["shop_description"]#line:583 O0OO0O0OOOO000O0O ="UPDATE `wpoc_"+str (O0000O000OO0O00O0 )+"_options` SET `option_value` = '"+OO000OO0O000O0000 +"' WHERE option_name = 'blogname'"#line:586 O000O0000O0O00O00 .execute (O0OO0O0OOOO000O0O )#line:587 OO0O00OO0O00OO0OO .commit ()#line:588 O000OO000000OO00O ="UPDATE `wpoc_"+str (O0000O000OO0O00O0 )+"_options` SET `option_value` = '"+OO0OOO0OOO00OOO0O +"' WHERE option_name = 'blogdescription'"#line:591 O000O0000O0O00O00 .execute (O000OO000000OO00O )#line:592 OO0O00OO0O00OO0OO .commit ()#line:593 O000O0000O0O00O00 .close ()#line:596 OO0O00OO0O00OO0OO .close ()#line:597 return "success"#line:599 except :#line:600 return "failure"#line:601 elif O00OOOOO0OOOO0O0O is False :#line:603 return "null"#line:604 @app .route ('/product/',methods =['GET','POST'])#line:608 def chat2 ():#line:609 O00OOO0OOOOO0O0OO =flask .request .get_json ()#line:610 O0OOOO0O00OO000OO =O00OOO0OOOOO0O0OO ["subject"]#line:611 if O0OOOO0O00OO000OO =="get_all_products":#line:613 return getAllProd (O00OOO0OOOOO0O0OO )#line:614 if O0OOOO0O00OO000OO =="get_one_product":#line:615 return getOneProd (O00OOO0OOOOO0O0OO )#line:616 else :#line:617 return "Invalid request."#line:618 def getAllProd (OO0OO0OOO0O00O0O0 ):#line:621 OO0OOOO0O0O00OOOO =OO0OO0OOO0O00O0O0 ["user_id"]#line:622 OOO0O0O0O0O0OO0OO =OO0OO0OOO0O00O0O0 ["shop_url"]#line:624 O00OO00O00OOOOOO0 =OO0OO0OOO0O00O0O0 ["token"]#line:626 O0O000OOO000OOO0O =verify_auth_token (token =O00OO00O00OOOOOO0 ,user_id =OO0OOOO0O0O00OOOO )#line:628 if O0O000OOO000OOO0O is True :#line:630 try :#line:631 OO000O0OOO0OOO0O0 =mysql .connector .connect (host =chat2 .host ,user =chat2 .user ,passwd =chat2 .passwd ,database =chat2 .database )#line:633 OOO000OO0OO00O00O =OO000O0OOO0OOO0O0 .cursor ()#line:634 OO0000OOO00OO0O00 ="SELECT ID FROM wpoc_"+str (OO0OOOO0O0O00OOOO )+"_posts where post_type = 'product'"#line:636 OOO000OO0OO00O00O .execute (OO0000OOO00OO0O00 )#line:637 OO0OOO0OO0OOOO0OO =OOO000OO0OO00O00O .fetchall ()#line:638 O00OOOOOO00OOOO0O =[]#line:640 for OO00000OOO0O0O000 in OO0OOO0OO0OOOO0OO :#line:641 O00OOOOOO00OOOO0O .extend (OO00000OOO0O0O000 )#line:642 OOOO00O00OO00O0OO =[]#line:644 O0O0OO0OOO0OOOO00 =""#line:645 for O0000000OO00O0OOO in O00OOOOOO00OOOO0O :#line:647 try :#line:648 OO0000OOO00OO0O00 ="SELECT post_title FROM wpoc_"+str (OO0OOOO0O0O00OOOO )+"_posts where post_type = 'product' and ID = "+str (O0000000OO00O0OOO )+""#line:650 OOO000OO0OO00O00O .execute (OO0000OOO00OO0O00 )#line:651 O0OO00OO0OOOOOO0O =OOO000OO0OO00O00O .fetchone ()[0 ]#line:652 OO00O0O0000O00OOO ="SELECT meta_value FROM wpoc_"+str (OO0OOOO0O0O00OOOO )+"_postmeta where meta_key = '_price' and post_id = '"+str (O0000000OO00O0OOO )+"'"#line:656 OOO000OO0OO00O00O .execute (OO00O0O0000O00OOO )#line:657 OO00OO0O0OOO0O000 =OOO000OO0OO00O00O .fetchone ()[0 ]#line:658 O000000O000OOOO0O ="SELECT post_content FROM wpoc_"+str (OO0OOOO0O0O00OOOO )+"_posts where post_type = 'product' and ID = '"+str (O0000000OO00O0OOO )+"'"#line:662 OOO000OO0OO00O00O .execute (O000000O000OOOO0O )#line:663 OOOOOOOOOOOO0000O =OOO000OO0OO00O00O .fetchone ()[0 ]#line:664 O0O0000OOO00O000O ="SELECT meta_value FROM wpoc_"+str (OO0OOOO0O0O00OOOO )+"_postmeta WHERE meta_key = '_thumbnail_id' and post_id = '"+str (O0000000OO00O0OOO )+"'"#line:668 OOO000OO0OO00O00O .execute (O0O0000OOO00O000O )#line:669 try :#line:670 O00OOO0OOO0OO0OOO ="SELECT ID FROM wpoc_"+str (OO0OOOO0O0O00OOOO )+"_posts WHERE post_type = 'attachement' and post_parent = '"+str (O0000000OO00O0OOO )+"'"#line:672 OOOOOO00OOOO0000O =OOO000OO0OO00O00O .execute (O00OOO0OOO0OO0OOO )#line:673 O0OO0O0O0000000O0 ="SELECT meta_value FROM wpoc_"+str (OO0OOOO0O0O00OOOO )+"_postmeta where post_id = '"+str (OOOOOO00OOOO0000O )+"'"#line:677 OOO000OO0OO00O00O .execute (O0OO0O0O0000000O0 )#line:678 O000OOOOOOO0OO0OO =OOO000OO0OO00O00O .fetchone ()[0 ]#line:679 O0000000OOO0OOO0O =str (OOO0O0O0O0O0OO0OO )+"/wp-content/uploads/"+str (O000OOOOOOO0OO0OO )#line:681 except :#line:682 O0000000OOO0OOO0O =""#line:683 OOO0OOOOOOO00O0O0 ={'status':"success",'id':str (O0000000OO00O0OOO ),"images":O0000000OOO0OOO0O ,'product_name':str (O0OO00OO0OOOOOO0O ),'product_price':str (OO00OO0O0OOO0O000 ),'product_description':""}#line:692 OOOO00O00OO00O0OO .append (OOO0OOOOOOO00O0O0 )#line:693 O0O0OO0OOO0OOOO00 =OOOO00O00OO00O0OO #line:694 except :#line:695 OOO0OOOOOOO00O0O0 ={'status':"failure",'id':'',"images":'','product_name':'','product_price':'','product_description':''}#line:703 O0O0OO0OOO0OOOO00 =OOO0OOOOOOO00O0O0 #line:704 OOO000OO0OO00O00O .close ()#line:707 OO000O0OOO0OOO0O0 .close ()#line:708 except :#line:709 OOO0OOOOOOO00O0O0 ={'status':"failure",'id':'',"images":'','product_name':'','product_price':'','product_description':''}#line:717 O0O0OO0OOO0OOOO00 =OOO0OOOOOOO00O0O0 #line:718 O0OO0O0O000O00000 =json .dumps (O0O0OO0OOO0OOOO00 )#line:720 return O0OO0O0O000O00000 #line:721 elif O0O000OOO000OOO0O is False :#line:723 OOO0OOOOOOO00O0O0 ={'status':"null",'id':'',"images":'','product_name':'','product_price':'','product_description':''}#line:731 O0O0OO0OOO0OOOO00 =OOO0OOOOOOO00O0O0 #line:732 return json .dumps (O0O0OO0OOO0OOOO00 )#line:733 def getOneProd (OO00O00OO00OOOO00 ):#line:737 O0OO00O0O0OOO0OOO =OO00O00OO00OOOO00 ["user_id"]#line:738 O0O0OO0O00O00O0O0 =OO00O00OO00OOOO00 ["token"]#line:740 OOOO00000OO0O00OO =verify_auth_token (token =O0O0OO0O00O00O0O0 ,user_id =O0OO00O0O0OOO0OOO )#line:742 if OOOO00000OO0O00OO is True :#line:744 try :#line:745 OOO0O00OOO00O0O00 =OO00O00OO00OOOO00 ["product_id"]#line:746 O0O000OOO0OOO0O00 =mysql .connector .connect (host =chat2 .host ,user =chat2 .user ,passwd =chat2 .passwd ,database =chat2 .database )#line:749 O000O0OOO00OOO00O =O0O000OOO0OOO0O00 .cursor ()#line:750 O0000O000O00OOO00 ="SELECT post_title FROM wpoc_"+str (O0OO00O0O0OOO0OOO )+"_posts where post_type = 'product' and ID = "+OOO0O00OOO00O0O00 +""#line:753 O000O0OOO00OOO00O .execute (O0000O000O00OOO00 )#line:754 OO00OOO0OO0O0O000 =O000O0OOO00OOO00O .fetchone ()[0 ]#line:755 OOO0OO00OOO0OO00O ="SELECT meta_value FROM wpoc_"+str (O0OO00O0O0OOO0OOO )+"_postmeta where meta_key = '_price' and post_id = '"+OOO0O00OOO00O0O00 +"'"#line:758 O000O0OOO00OOO00O .execute (OOO0OO00OOO0OO00O )#line:759 OO0OO0O0O0O0OO000 =O000O0OOO00OOO00O .fetchone ()[0 ]#line:760 OOOOO0OO00O000O0O ="SELECT post_content FROM wpoc_"+str (O0OO00O0O0OOO0OOO )+"_posts where post_type = 'product' and ID = '"+OOO0O00OOO00O0O00 +"'"#line:763 O000O0OOO00OOO00O .execute (OOOOO0OO00O000O0O )#line:764 OO0OOOOOOOOO00O00 =O000O0OOO00OOO00O .fetchone ()[0 ]#line:765 O0O000OO00O00O0OO ="SELECT meta_value FROM wpoc_"+str (O0OO00O0O0OOO0OOO )+"_postmeta WHERE meta_key = '_thumbnail_id' and post_id = '"+OOO0O00OOO00O0O00 +"'"#line:768 O000O0OOO00OOO00O .execute (O0O000OO00O00O0OO )#line:769 try :#line:770 O00O00OO000OO00O0 =O000O0OOO00OOO00O .fetchone ()[0 ]#line:771 OO0000O00000OO0OO ="SELECT meta_value FROM wpoc_"+str (O0OO00O0O0OOO0OOO )+"_postmeta WHERE meta_key = '_wp_attached_file' and post_id = '"+str (O00O00OO000OO00O0 )+"'"#line:774 O000O0OOO00OOO00O .execute (OO0000O00000OO0OO )#line:775 O0OOO0000O000O00O =O000O0OOO00OOO00O .fetchone ()[0 ]#line:776 except :#line:777 O0OOO0000O000O00O =""#line:778 O0OO0O0000O0OO0O0 ={'status':"success","images":"https://freshfarms.eshop.ke/wp-content/uploads/sites/2/2020/07/"+str (O0OOO0000O000O00O ),'product_name':str (OO00OOO0OO0O0O000 ),'product_price':str (OO0OO0O0O0O0OO000 ),'product_description':OO0OOOOOOOOO00O00 }#line:786 O000O0OOO00OOO00O .close ()#line:789 O0O000OOO0OOO0O00 .close ()#line:790 OOOO0O00OO0OOOO0O =json .dumps (O0OO0O0000O0OO0O0 )#line:792 return OOOO0O00OO0OOOO0O #line:793 except :#line:794 O0OO0O0000O0OO0O0 ={'status':"failure","images":"",'product_name':"",'product_price':"",'product_description':""}#line:801 OOOO0O00OO0OOOO0O =json .dumps (O0OO0O0000O0OO0O0 )#line:802 return OOOO0O00OO0OOOO0O #line:803 elif OOOO00000OO0O00OO is False :#line:805 O0OO0O0000O0OO0O0 ={'status':"null","images":"",'product_name':"",'product_price':"",'product_description':""}#line:812 OOOO0O00OO0OOOO0O =json .dumps (O0OO0O0000O0OO0O0 )#line:813 return OOOO0O00OO0OOOO0O #line:814 def updateOneProd (O0O00000O000OOO00 ):#line:818 OOO000O0OOO0OO0OO =O0O00000O000OOO00 ["user_id"]#line:819 OO0OOOO00000O0O0O =O0O00000O000OOO00 ["token"]#line:821 OO0OOO00O000O0O00 =verify_auth_token (token =OO0OOOO00000O0O0O ,user_id =OOO000O0OOO0OO0OO )#line:823 if OO0OOO00O000O0O00 is True :#line:825 try :#line:826 O000O0O0O0000O00O =O0O00000O000OOO00 ["product_id"]#line:828 O0O0O000O00O0OOOO =mysql .connector .connect (host =chat2 .host ,user =chat2 .user ,passwd =chat2 .passwd ,database =chat2 .database )#line:831 O00OOO0OO0OO0OOOO =O0O0O000O00O0OOOO .cursor ()#line:832 O0O0O0OO0O00O00O0 ="UPDATE post_title SET wpoc_"+str (OOO000O0OOO0OO0OO )+"_posts where post_type = 'product' and ID = "+O000O0O0O0000O00O +""#line:835 O00OOO0OO0OO0OOOO .execute (O0O0O0OO0O00O00O0 )#line:836 O00OOOO00OOO0OOO0 =O00OOO0OO0OO0OOOO .fetchone ()[0 ]#line:837 O00OO0O00OOO00OO0 ="UPDATE meta_value SET wpoc_"+str (OOO000O0OOO0OO0OO )+"_postmeta where meta_key = '_price' and post_id = '"+O000O0O0O0000O00O +"'"#line:840 O00OOO0OO0OO0OOOO .execute (O00OO0O00OOO00OO0 )#line:841 O0OO0O000OO00OO0O =O00OOO0OO0OO0OOOO .fetchone ()[0 ]#line:842 O0OOO0O000O0O0O00 ="UPDATE post_content SET wpoc_"+str (OOO000O0OOO0OO0OO )+"_posts where post_type = 'product' and ID = '"+O000O0O0O0000O00O +"'"#line:845 O00OOO0OO0OO0OOOO .execute (O0OOO0O000O0O0O00 )#line:846 O0OOOOOOOO0O00OO0 =O00OOO0OO0OO0OOOO .fetchone ()[0 ]#line:847 OOOO0OO000OO00000 ="UPDATE meta_value SET wpoc_"+str (OOO000O0OOO0OO0OO )+"_postmeta WHERE meta_key = '_thumbnail_id' and post_id = '"+O000O0O0O0000O00O +"'"#line:850 O00OOO0OO0OO0OOOO .execute (OOOO0OO000OO00000 )#line:851 try :#line:852 O000000O000OOO000 =O00OOO0OO0OO0OOOO .fetchone ()[0 ]#line:853 OO0O0O0OOO000000O ="UPDATE meta_value SET wpoc_"+str (OOO000O0OOO0OO0OO )+"_postmeta WHERE meta_key = '_wp_attached_file' and post_id = '"+str (O000000O000OOO000 )+"'"#line:856 O00OOO0OO0OO0OOOO .execute (OO0O0O0OOO000000O )#line:857 O0OOO000O00O0OO00 =O00OOO0OO0OO0OOOO .fetchone ()[0 ]#line:858 except :#line:859 O0OOO000O00O0OO00 =""#line:860 OO0O0OO0O0O00000O ={'status':"success","images":"https://freshfarms.eshop.ke/wp-content/uploads/sites/2/2020/07/"+str (O0OOO000O00O0OO00 ),'product_name':str (O00OOOO00OOO0OOO0 ),'product_price':str (O0OO0O000OO00OO0O ),'product_description':O0OOOOOOOO0O00OO0 }#line:868 O00OOO0OO0OO0OOOO .close ()#line:871 O0O0O000O00O0OOOO .close ()#line:872 except :#line:874 OO0O0OO0O0O00000O ={'status':"failure","images":"",'product_name':"",'product_price':"",'product_description':""}#line:881 O0000O00OO0O0000O =json .dumps (OO0O0OO0O0O00000O )#line:883 return O0000O00OO0O0000O #line:884 elif OO0OOO00O000O0O00 is False :#line:886 return "null"#line:887 @app .route ('/orders/',methods =['GET','POST'])#line:892 def chat3 ():#line:893 OOO0O000O0O00OOOO =flask .request .get_json ()#line:894 OO000O0OO00OO0OOO =OOO0O000O0O00OOOO ["shop_domain"]#line:896 os .chdir ("/home/eshop/"+str (OO000O0OO00OO0OOO ))#line:899 OOOOOO000000OO0OO ='cat wp-config.php | grep DB_NAME | cut -d \' -f 4'#line:902 OO0O0OO0000OO0000 =subprocess .Popen (OOOOOO000000OO0OO .split (),stdout =subprocess .PIPE )#line:903 O0OOOO0000O0O0OOO ,O000O00O0O00OO00O =OO0O0OO0000OO0000 .communicate ()#line:904 O00OO0OO000OOO0OO ='cat wp-config.php | grep DB_PASSWORD | cut -d \' -f 4'#line:907 OO0O0OO0000OO0000 =subprocess .Popen (O00OO0OO000OOO0OO .split (),stdout =subprocess .PIPE )#line:908 OO00OOOOO00O00000 ,O000O00O0O00OO00O =OO0O0OO0000OO0000 .communicate ()#line:909 OO0OO00O0O000OO00 ="127.0.0.1"#line:912 OOO00OO00O0000OOO =O0OOOO0000O0O0OOO #line:913 OOO00000O0O00O00O =OO00OOOOO00O00000 #line:914 OOO00O0O00OOOOO0O =O0OOOO0000O0O0OOO #line:915 O0O000O0000OOO00O =OOO0O000O0O00OOOO ["subject"]#line:917 if O0O000O0000OOO00O =="get_all_orders":#line:919 return getAllOrders (OOO0O000O0O00OOOO )#line:920 else :#line:921 return "Invalid request."#line:922 def getAllOrders (O0OOOO000O0OOO000 ):#line:926 OOO000OO00000OO00 =O0OOOO000O0OOO000 ["user_id"]#line:927 O00O0OOO0O00000O0 =O0OOOO000O0OOO000 ["token"]#line:929 O0O0OOO0OOOO00O00 =verify_auth_token (token =O00O0OOO0O00000O0 ,user_id =OOO000OO00000OO00 )#line:931 if O0O0OOO0OOOO00O00 is True :#line:933 try :#line:934 O0O0OO000OO0OOOO0 =mysql .connector .connect (host =chat3 .host ,user =chat3 .user ,passwd =chat3 .passwd ,database =chat3 .database )#line:937 OO0000O0O00OOOOO0 =O0O0OO000OO0OOOO0 .cursor ()#line:938 OO0O00O0OO0O00O00 ="SELECT ID FROM wpoc_"+str (OOO000OO00000OO00 )+"_posts where post_type = 'shop_order' and post_status != 'trash'"#line:941 OO0000O0O00OOOOO0 .execute (OO0O00O0OO0O00O00 )#line:942 OO00OOO0000O0OOOO =OO0000O0O00OOOOO0 .fetchall ()#line:943 O000000OO0O0000OO =[]#line:945 for O0O0OOOOO00O0O0OO in OO00OOO0000O0OOOO :#line:946 O000000OO0O0000OO .extend (O0O0OOOOO00O0O0OO )#line:947 O000000OO0O0000OO .sort (key =int )#line:950 O000000OO0O0000OO .reverse ()#line:951 O0O0O0OO00O000000 =[]#line:953 OO0OOO0O0O00O00OO =""#line:954 for OO0O0O0O00O0000OO in O000000OO0O0000OO :#line:956 try :#line:957 OO0O00O0OO0O00O00 ="SELECT post_title FROM wpoc_"+str (OOO000OO00000OO00 )+"_posts where post_type = 'shop_order' and ID = "+str (OO0O0O0O00O0000OO )+""#line:959 OO0000O0O00OOOOO0 .execute (OO0O00O0OO0O00O00 )#line:960 O0OOOOOO0OO00OOO0 =OO0000O0O00OOOOO0 .fetchone ()[0 ]#line:961 O00OOOO0OO0000000 ="SELECT post_status FROM wpoc_"+str (OOO000OO00000OO00 )+"_posts where post_type = 'shop_order' and ID = '"+str (OO0O0O0O00O0000OO )+"'"#line:965 OO0000O0O00OOOOO0 .execute (O00OOOO0OO0000000 )#line:966 O0O0O0OO000OOO0OO =OO0000O0O00OOOOO0 .fetchone ()[0 ]#line:967 OO0OOO0O0OO00O0O0 ="SELECT meta_value FROM wpoc_"+str (OOO000OO00000OO00 )+"_postmeta where meta_key = '_order_total' and post_id = '"+str (OO0O0O0O00O0000OO )+"'"#line:971 OO0000O0O00OOOOO0 .execute (OO0OOO0O0OO00O0O0 )#line:972 O0OO0O00O000O0O0O =OO0000O0O00OOOOO0 .fetchone ()[0 ]#line:973 O0O0O000O00OO00O0 ={'status':"success",'order_status':str (O0O0O0OO000OOO0OO ),'order_name':str (O0OOOOOO0OO00OOO0 ),'order_total':str (O0OO0O00O000O0O0O )}#line:980 O0O0O0OO00O000000 .append (O0O0O000O00OO00O0 )#line:981 OO0OOO0O0O00O00OO =O0O0O0OO00O000000 #line:982 except :#line:983 O0O0O000O00OO00O0 ={'status':"failure",'order_status':"",'order_name':"",'order_total':""}#line:989 OO0OOO0O0O00O00OO =O0O0O000O00OO00O0 #line:990 OO0000O0O00OOOOO0 .close ()#line:993 O0O0OO000OO0OOOO0 .close ()#line:994 except :#line:996 O0O0O000O00OO00O0 ={'status':"failure",'order_status':"",'order_name':"",'order_total':""}#line:1002 OO0OOO0O0O00O00OO =O0O0O000O00OO00O0 #line:1003 O0OO0OOO00OO00OO0 =json .dumps (OO0OOO0O0O00O00OO )#line:1005 return O0OO0OOO00OO00OO0 #line:1006 elif O0O0OOO0OOOO00O00 is False :#line:1008 O0O0O000O00OO00O0 ={'status':"null",'order_status':"",'order_name':"",'order_total':""}#line:1014 OO0OOO0O0O00O00OO =O0O0O000O00OO00O0 #line:1015 return json .dumps (OO0OOO0O0O00O00OO )#line:1016 print ("Beginning server \n")#line:1033 http_server =WSGIServer (('',5000 ),app )#line:1040 http_server .serve_forever ()