API tools faq
paste
Advertisement
Guest User

Uganda Online Money Transfer HACKED | @Zer0Pwn @GSec_

a guest
Jun 25th, 2012
478
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 70.23 KB | None | 0 0
raw download clone embed print report
  1. _____ _____
  2. / ____|/ ____|
  3. | | __| (___ ___ ___
  4. | | |_ |\___ \ / _ \/ __|
  5. | |__| |____) | __/ (__
  6. \_____|_____/ \___|\___| #Fucking Security since day 1.
  7. // @GSec_, @Zer0Pwn, @AnonTeenUSA, @Codeinesec, @INST1NCT_, @Voxiaa
  8. // Xecurity
  9. // INST1NCT
  10. // Codeine
  11. // Dread
  12. // Netstop
  13. // Voxia
  14. // Hilt
  15. // Zer0Pwn
  16. ####################################################################
  17.  
  18. Today's dump includes:
  19. Usernames, Passwords, Emails, Credit-Card Numbers and Names from PayUganda.com.
  20.  
  21. Message:
  22.  
  23. We hacked PayUganda.com, and we have full access.
  24. We hacked it, because of Uganda's statement pointed towards LGTB people.
  25. They stated that they believe that they should be put to death.
  26. This is intolerable, and we will show them who is boss.
  27.  
  28. #OpFuckUganda
  29.  
  30. ####################################################################
  31.  
  32. -- Database: `payug_payug`
  33. --
  34.  
  35. -- --------------------------------------------------------
  36.  
  37. --
  38. -- Table structure for table `pay_agent`
  39. --
  40.  
  41. DROP TABLE IF EXISTS pay_agent;
  42. CREATE TABLE pay_agent (
  43. id int(6) NOT NULL auto_increment,
  44. usname varchar(25) NOT NULL,
  45. `names` varchar(200) NOT NULL,
  46. phone varchar(20) NOT NULL,
  47. email varchar(70) NOT NULL,
  48. paddress varchar(250) NOT NULL,
  49. location varchar(200) NOT NULL,
  50. date_created datetime NOT NULL,
  51. PRIMARY KEY (id)
  52. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  53.  
  54. --
  55. -- Dumping data for table `pay_agent`
  56. --
  57.  
  58. INSERT INTO pay_agent (id, usname, names, phone, email, paddress, location, date_created) VALUES (1, '86', 'Musoke Timothy', '4428893601982', 'almozm@hotmail.com', '<p>To be verified"</p>\r\n<p>Central London</p>', 'United Kingdom', '2008-08-12 11:38:16');
  59.  
  60. -- --------------------------------------------------------
  61.  
  62. --
  63. -- Table structure for table `pay_audit`
  64. --
  65.  
  66. DROP TABLE IF EXISTS pay_audit;
  67. CREATE TABLE pay_audit (
  68. id int(6) NOT NULL auto_increment,
  69. username varchar(40) NOT NULL,
  70. `action` varchar(100) NOT NULL,
  71. tranferno varchar(50) NOT NULL,
  72. date_logged datetime NOT NULL,
  73. PRIMARY KEY (id)
  74. ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  75.  
  76. --
  77. -- Dumping data for table `pay_audit`
  78. --
  79.  
  80. INSERT INTO pay_audit (id, username, action, tranferno, date_logged) VALUES (2, '86', '<font color = ''green''>Finalised Payment</font>', 'PU120808-798197887', '2008-08-12 11:40:26');
  81.  
  82. -- --------------------------------------------------------
  83.  
  84. --
  85. -- Table structure for table `pay_bankaccounts`
  86. --
  87.  
  88. DROP TABLE IF EXISTS pay_bankaccounts;
  89. CREATE TABLE pay_bankaccounts (
  90. id int(6) NOT NULL auto_increment,
  91. `name` varchar(200) NOT NULL,
  92. accountno varchar(100) NOT NULL,
  93. date_entered datetime NOT NULL,
  94. PRIMARY KEY (id)
  95. ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
  96.  
  97. --
  98. -- Dumping data for table `pay_bankaccounts`
  99. --
  100.  
  101. INSERT INTO pay_bankaccounts (id, name, accountno, date_entered) VALUES (7, 'stanbic', '779835576829901', '2008-07-11 13:19:33');
  102. INSERT INTO pay_bankaccounts (id, name, accountno, date_entered) VALUES (8, 'Stanbic Bank Soroti Branch', '0121051135301', '2008-07-14 14:09:08');
  103. INSERT INTO pay_bankaccounts (id, name, accountno, date_entered) VALUES (9, 'Stanbic Bank Soroti', '0121053511301', '2008-08-01 15:06:59');
  104. INSERT INTO pay_bankaccounts (id, name, accountno, date_entered) VALUES (10, 'Bank of Africa', '0209739032132', '2008-08-02 12:50:36');
  105. INSERT INTO pay_bankaccounts (id, name, accountno, date_entered) VALUES (11, 'Uganda Finance Trust', '20000006539', '2008-08-20 09:28:06');
  106. INSERT INTO pay_bankaccounts (id, name, accountno, date_entered) VALUES (12, 'Standard Charted Bank - Kampala,Uganda.', '012104567777', '2008-09-15 09:20:04');
  107.  
  108. -- --------------------------------------------------------
  109.  
  110. --
  111. -- Table structure for table `pay_comment`
  112. --
  113.  
  114. DROP TABLE IF EXISTS pay_comment;
  115. CREATE TABLE pay_comment (
  116. id int(4) NOT NULL auto_increment,
  117. message text NOT NULL,
  118. sender tinyint(4) NOT NULL,
  119. vetted enum('0','1') NOT NULL,
  120. date_posted datetime NOT NULL,
  121. PRIMARY KEY (id)
  122. ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  123.  
  124. --
  125. -- Dumping data for table `pay_comment`
  126. --
  127.  
  128. INSERT INTO pay_comment (id, message, sender, vetted, date_posted) VALUES (1, '<p>Testing - Pay Uganda has come at an opportune time. With low rates and convinient send methods.</p>', 60, '1', '2008-06-05 06:54:38');
  129. INSERT INTO pay_comment (id, message, sender, vetted, date_posted) VALUES (2, 'PayUganda, this is an amazing and really innovative product. I am sure to continue using your service after just one try', 85, '1', '2008-08-09 10:59:05');
  130. INSERT INTO pay_comment (id, message, sender, vetted, date_posted) VALUES (3, 'This service is very excellent, its long overdue, thank you for introducing a simple efficient way of sending money!', 98, '0', '2008-09-15 08:18:28');
  131.  
  132. -- --------------------------------------------------------
  133.  
  134. --
  135. -- Table structure for table `pay_countries`
  136. --
  137.  
  138. DROP TABLE IF EXISTS pay_countries;
  139. CREATE TABLE pay_countries (
  140. id tinyint(4) NOT NULL auto_increment,
  141. country varchar(100) NOT NULL,
  142. abbre varchar(20) NOT NULL,
  143. date_entered datetime NOT NULL,
  144. PRIMARY KEY (id)
  145. ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  146.  
  147. --
  148. -- Dumping data for table `pay_countries`
  149. --
  150.  
  151. INSERT INTO pay_countries (id, country, abbre, date_entered) VALUES (1, 'USA', 'US', '2008-04-29 09:46:38');
  152. INSERT INTO pay_countries (id, country, abbre, date_entered) VALUES (2, 'UK', 'UK', '2008-04-29 09:46:38');
  153. INSERT INTO pay_countries (id, country, abbre, date_entered) VALUES (3, 'Uganda', 'UG', '2008-04-29 09:46:38');
  154.  
  155. -- --------------------------------------------------------
  156.  
  157. --
  158. -- Table structure for table `pay_forexrates`
  159. --
  160.  
  161. DROP TABLE IF EXISTS pay_forexrates;
  162. CREATE TABLE pay_forexrates (
  163. id tinyint(4) NOT NULL auto_increment,
  164. currency varchar(30) NOT NULL,
  165. symbol varchar(10) NOT NULL,
  166. rate int(6) NOT NULL,
  167. date_entered datetime NOT NULL,
  168. PRIMARY KEY (id)
  169. ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  170.  
  171. --
  172. -- Dumping data for table `pay_forexrates`
  173. --
  174.  
  175. INSERT INTO pay_forexrates (id, currency, symbol, rate, date_entered) VALUES (1, 'US Dollars', 'USD', 1690, '2008-04-29 09:06:31');
  176. INSERT INTO pay_forexrates (id, currency, symbol, rate, date_entered) VALUES (2, 'Great Britain Pound', 'GBP', 2300, '2008-04-29 09:23:11');
  177. INSERT INTO pay_forexrates (id, currency, symbol, rate, date_entered) VALUES (3, 'European Union Currency', 'Euro', 3300, '2008-04-29 09:23:57');
  178.  
  179. -- --------------------------------------------------------
  180.  
  181. --
  182. -- Table structure for table `pay_mainadvert`
  183. --
  184.  
  185. DROP TABLE IF EXISTS pay_mainadvert;
  186. CREATE TABLE pay_mainadvert (
  187. id tinyint(3) NOT NULL auto_increment,
  188. title varchar(100) NOT NULL,
  189. image varchar(100) NOT NULL,
  190. featured enum('0','1') NOT NULL,
  191. date_entered datetime NOT NULL,
  192. PRIMARY KEY (id)
  193. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  194.  
  195. --
  196. -- Dumping data for table `pay_mainadvert`
  197. --
  198.  
  199. INSERT INTO pay_mainadvert (id, title, image, featured, date_entered) VALUES (1, 'Send Money to Friends and family', 'homecenter.jpg', '1', '2008-04-28 14:16:16');
  200.  
  201. -- --------------------------------------------------------
  202.  
  203. --
  204. -- Table structure for table `pay_myreceivers`
  205. --
  206.  
  207. DROP TABLE IF EXISTS pay_myreceivers;
  208. CREATE TABLE pay_myreceivers (
  209. id int(6) NOT NULL auto_increment,
  210. senderid bigint(16) NOT NULL,
  211. rfname varchar(60) NOT NULL,
  212. rothername varchar(60) NOT NULL,
  213. rlname varchar(60) NOT NULL,
  214. rgender varchar(10) NOT NULL,
  215. remail varchar(120) NOT NULL,
  216. rphone varchar(30) NOT NULL,
  217. date_entered datetime NOT NULL,
  218. PRIMARY KEY (id)
  219. ) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
  220.  
  221. --
  222. -- Dumping data for table `pay_myreceivers`
  223. --
  224.  
  225. INSERT INTO pay_myreceivers (id, senderid, rfname, rothername, rlname, rgender, remail, rphone, date_entered) VALUES (4, 77, 'trevor', '', 'did', 'Male', '338@778.com', '009772', '2008-07-11 13:14:44');
  226. INSERT INTO pay_myreceivers (id, senderid, rfname, rothername, rlname, rgender, remail, rphone, date_entered) VALUES (5, 73, 'Carol', '', 'Amito', 'Female', 'camito@eyit.co.ug', '0712564356', '2008-07-14 14:09:08');
  227. INSERT INTO pay_myreceivers (id, senderid, rfname, rothername, rlname, rgender, remail, rphone, date_entered) VALUES (6, 0, 'test', '', 'test', 'Male', 'hv@snapcard.com', '447834488610', '2008-07-24 14:49:15');
  228. INSERT INTO pay_myreceivers (id, senderid, rfname, rothername, rlname, rgender, remail, rphone, date_entered) VALUES (7, 81, 'Mama Small', '', 'Kintu', 'Female', 'msmall@yahoo.com', '0884324', '2008-07-25 10:13:50');
  229. INSERT INTO pay_myreceivers (id, senderid, rfname, rothername, rlname, rgender, remail, rphone, date_entered) VALUES (8, 83, 'Abahoo', '', 'Doreen', 'Female', 'mydoreen@yahoo.co.ug', '0723125666', '2008-08-01 14:18:07');
  230. INSERT INTO pay_myreceivers (id, senderid, rfname, rothername, rlname, rgender, remail, rphone, date_entered) VALUES (9, 84, 'yusuf', '', 'opad', 'Male', 'jjyusuf@gmail.com', '98', '2008-08-02 09:53:59');
  231. INSERT INTO pay_myreceivers (id, senderid, rfname, rothername, rlname, rgender, remail, rphone, date_entered) VALUES (10, 81, 'Damulira', '', 'Missus', 'Male', 'dmissus@gmail.com', '0287234234', '2008-08-02 12:43:10');
  232. INSERT INTO pay_myreceivers (id, senderid, rfname, rothername, rlname, rgender, remail, rphone, date_entered) VALUES (11, 69, 'Joan', '', 'Mpezi', 'Female', 'jo@gmail.com', '0752839276', '2008-08-06 12:45:42');
  233. INSERT INTO pay_myreceivers (id, senderid, rfname, rothername, rlname, rgender, remail, rphone, date_entered) VALUES (12, 85, 'Ted', '', 'Turner', 'Male', 'almozm@hotmail.com', '0782444253', '2008-08-09 10:37:54');
  234. INSERT INTO pay_myreceivers (id, senderid, rfname, rothername, rlname, rgender, remail, rphone, date_entered) VALUES (13, 60, 'Samuel', '', 'Kabagambe', 'Male', 'sbaguma@payuganda.com', '0752502424', '2008-08-14 06:25:10');
  235. INSERT INTO pay_myreceivers (id, senderid, rfname, rothername, rlname, rgender, remail, rphone, date_entered) VALUES (20, 96, 'Ami', '', 'Mansaray', 'Female', 'aminata@yahoo.com', '033442975', '2008-09-10 13:03:28');
  236. INSERT INTO pay_myreceivers (id, senderid, rfname, rothername, rlname, rgender, remail, rphone, date_entered) VALUES (15, 0, 'Julius', '', 'bagonza', 'Male', 'sbaguma@hotmail.com', '0772433689', '2008-08-20 10:54:50');
  237. INSERT INTO pay_myreceivers (id, senderid, rfname, rothername, rlname, rgender, remail, rphone, date_entered) VALUES (16, 60, 'Irene', 'Karugaba', 'Baguma', 'Female', 'sbaguma@hotmail.com', '0752502424', '2008-09-02 13:55:05');
  238. INSERT INTO pay_myreceivers (id, senderid, rfname, rothername, rlname, rgender, remail, rphone, date_entered) VALUES (17, 85, 'Alla', '', 'micheal', 'Male', 'a@a.com', '88824444', '2008-09-02 14:28:13');
  239. INSERT INTO pay_myreceivers (id, senderid, rfname, rothername, rlname, rgender, remail, rphone, date_entered) VALUES (18, 62, 'Irene', '', 'Baguma', 'Female', 'sbaguma@hotmail.com', '0752502424', '2008-09-04 06:44:52');
  240. INSERT INTO pay_myreceivers (id, senderid, rfname, rothername, rlname, rgender, remail, rphone, date_entered) VALUES (19, 60, 'Irene', '', 'Baguma', 'Female', 'sbaguma@payuganda.com', '0752502424', '2008-09-04 07:28:38');
  241. INSERT INTO pay_myreceivers (id, senderid, rfname, rothername, rlname, rgender, remail, rphone, date_entered) VALUES (21, 98, 'Valentine', '', 'Ojoro', 'Male', 'vojaro@eyitronald.com', '0702151417', '2008-09-15 08:28:30');
  242.  
  243. -- --------------------------------------------------------
  244.  
  245. --
  246. -- Table structure for table `pay_orderstransfer`
  247. --
  248.  
  249. DROP TABLE IF EXISTS pay_orderstransfer;
  250. CREATE TABLE pay_orderstransfer (
  251. id int(10) NOT NULL auto_increment,
  252. senderid int(6) NOT NULL,
  253. orderno varchar(20) NOT NULL,
  254. amount varchar(20) NOT NULL,
  255. paid varchar(1) NOT NULL,
  256. archived varchar(1) NOT NULL,
  257. assignagent int(6) NOT NULL,
  258. ordertype varchar(20) NOT NULL,
  259. bankid int(6) NOT NULL,
  260. rateattime varchar(20) NOT NULL,
  261. date_logged datetime NOT NULL,
  262. PRIMARY KEY (id)
  263. ) ENGINE=MyISAM AUTO_INCREMENT=82 DEFAULT CHARSET=latin1;
  264.  
  265. --
  266. -- Dumping data for table `pay_orderstransfer`
  267. --
  268.  
  269. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (55, 77, 'PU110708-1461364278', '585 USD', '0', '0', 0, 'Direct Bank Transfer', 7, '1 USD = 1690 Ugx<br>', '2008-07-11 13:19:33');
  270. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (56, 73, 'PU140708-124857832', '528 USD', '0', '0', 0, 'Direct Bank Transfer', 8, '1 USD = 1690 Ugx<br>', '2008-07-14 14:09:08');
  271. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (57, 0, 'PU240708-593264521', '10 GBP', '0', '0', 0, 'SNAP', 0, '1 GBP = 2300 Ugx<br>', '2008-07-24 14:49:15');
  272. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (58, 81, 'PU250708-1040011469', '362 USD', '0', '0', 0, 'Google Checkout', 0, '1 USD = 1690 Ugx<br>', '2008-07-25 10:13:50');
  273. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (59, 83, 'PU010808-1340647182', '126 USD', '0', '0', 0, 'Direct Bank Transfer', 0, '1 USD = 1690 Ugx<br>', '2008-08-01 15:06:05');
  274. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (60, 84, 'PU020808-1497301985', '165 GBP', '0', '0', 0, 'Paypal', 0, '1 GBP = 2300 Ugx<br>', '2008-08-02 09:53:59');
  275. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (61, 84, 'PU020808-1223005982', '2,375 USD', '0', '0', 0, 'Direct Bank Transfer', 0, '1 USD = 1690 Ugx<br>', '2008-08-02 11:11:56');
  276. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (62, 84, 'PU020808-1742855708', '43 GBP', '0', '0', 0, 'SNAP', 0, '1 GBP = 2300 Ugx<br>', '2008-08-02 11:22:31');
  277. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (63, 84, 'PU020808-429608592', '89 USD', '0', '0', 0, 'Paypal', 0, '1 USD = 1690 Ugx<br>', '2008-08-02 11:31:25');
  278. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (66, 69, 'PU060808-167766273', '135 USD', '0', '0', 0, 'Google Checkout', 0, '1 USD = 1,690 Ugx<br', '2008-08-06 12:45:42');
  279. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (65, 81, 'PU020808-596750392', '830 USD', '0', '0', 0, 'Direct Bank Transfer', 0, '1 USD = 1690 Ugx<br>', '2008-08-02 12:43:10');
  280. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (67, 85, 'PU090808-1484817663', '530 USD', '0', '0', 0, 'Google Checkout', 0, '1 USD = 1,690 Ugx<br', '2008-08-09 10:37:54');
  281. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (68, 85, 'PU120808-798197887', '374 GBP', '3', '1', 0, 'SNAP', 0, '1 GBP = 2,300 Ugx<br', '2008-08-12 11:14:04');
  282. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (69, 60, 'PU140808-352530293', '162 USD', '0', '0', 0, 'Google Checkout', 0, '1 USD = 1,690 Ugx<br', '2008-08-14 06:25:10');
  283. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (70, 60, 'PU200808-1281630167', '369 USD', '0', '0', 0, 'Direct Bank Transfer', 11, '1 USD = 1,690 Ugx<br', '2008-08-20 09:28:06');
  284. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (71, 60, 'PU200808-683832406', '258 GBP', '0', '0', 0, 'SNAP', 0, '1 GBP = 2,300 Ugx<br', '2008-08-20 09:33:58');
  285. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (72, 60, '', ' GBP', '0', '0', 0, '', 0, '1 GBP = 2,300 Ugx<br', '2008-08-20 10:17:14');
  286. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (73, 60, 'PU200808-1908138311', '168 GBP', '0', '0', 0, 'Google Checkout', 0, '1 GBP = 2,300 Ugx<br', '2008-08-20 10:29:00');
  287. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (74, 0, 'PU200808-302225678', '162 USD', '0', '0', 0, 'Google Checkout', 0, '1 USD = 1,690 Ugx<br', '2008-08-20 10:54:50');
  288. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (75, 60, 'PU020908-1930036181', '250 USD', '0', '0', 0, '', 0, '1 USD = 1690 Ugx<br>', '2008-09-02 13:55:05');
  289. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (76, 85, 'PU020908-1510261833', '513 GBP', '0', '0', 0, 'SNAP', 0, '1 GBP = 2300 Ugx<br>', '2008-09-02 14:28:13');
  290. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (77, 62, 'PU040908-1253964532', '482 USD', '0', '0', 0, 'Google Checkout', 0, '1 USD = 1690 Ugx<br>', '2008-09-04 06:44:52');
  291. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (78, 60, 'PU040908-658418392', '362 GBP', '0', '0', 0, 'SNAP', 0, '1 GBP = 2300 Ugx<br>', '2008-09-04 07:28:38');
  292. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (79, 60, 'PU040908-1081563759', '352 USD', '0', '0', 0, 'Google Checkout', 0, '1 USD = 1690 Ugx<br>', '2008-09-04 10:06:18');
  293. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (80, 96, 'PU100908-1569790305', '110 USD', '0', '0', 0, 'Google Checkout', 0, '1 USD = 1690 Ugx<br>', '2008-09-10 13:03:28');
  294. INSERT INTO pay_orderstransfer (id, senderid, orderno, amount, paid, archived, assignagent, ordertype, bankid, rateattime, date_logged) VALUES (81, 98, 'PU150908-6018311', '107.2 USD', '1', '0', 0, 'Direct Bank Transfer', 12, '1 USD = 1690 Ugx<br>', '2008-09-15 09:20:04');
  295.  
  296. -- --------------------------------------------------------
  297.  
  298. --
  299. -- Table structure for table `pay_paymentmethods`
  300. --
  301.  
  302. DROP TABLE IF EXISTS pay_paymentmethods;
  303. CREATE TABLE pay_paymentmethods (
  304. id tinyint(4) NOT NULL auto_increment,
  305. `name` varchar(150) NOT NULL,
  306. tarifflist tinyint(1) NOT NULL,
  307. nocolumns tinyint(1) NOT NULL,
  308. date_entered datetime NOT NULL,
  309. PRIMARY KEY (id)
  310. ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
  311.  
  312. --
  313. -- Dumping data for table `pay_paymentmethods`
  314. --
  315.  
  316. INSERT INTO pay_paymentmethods (id, name, tarifflist, nocolumns, date_entered) VALUES (1, 'Online', 10, 3, '2008-05-04 09:46:38');
  317. INSERT INTO pay_paymentmethods (id, name, tarifflist, nocolumns, date_entered) VALUES (2, 'Cash Payment', 7, 3, '2008-05-04 09:46:38');
  318. INSERT INTO pay_paymentmethods (id, name, tarifflist, nocolumns, date_entered) VALUES (3, 'Direct Bank Transfer', 7, 3, '2008-05-04 09:46:38');
  319.  
  320. -- --------------------------------------------------------
  321.  
  322. --
  323. -- Table structure for table `pay_paymenttariff`
  324. --
  325.  
  326. DROP TABLE IF EXISTS pay_paymenttariff;
  327. CREATE TABLE pay_paymenttariff (
  328. id tinyint(6) NOT NULL auto_increment,
  329. paymentmethodid tinyint(6) NOT NULL,
  330. amountstart float NOT NULL,
  331. amountend float NOT NULL,
  332. payuganda float NOT NULL,
  333. date_entered datetime NOT NULL,
  334. PRIMARY KEY (id)
  335. ) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
  336.  
  337. --
  338. -- Dumping data for table `pay_paymenttariff`
  339. --
  340.  
  341. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (9, 1, 0, 100, 10, '2008-05-05 12:06:21');
  342. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (10, 1, 101, 200, 12, '2008-05-05 12:06:21');
  343. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (11, 1, 201, 300, 18, '2008-05-05 12:06:21');
  344. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (12, 1, 301, 400, 24, '2008-05-05 12:06:21');
  345. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (13, 1, 401, 500, 30, '2008-05-05 12:06:21');
  346. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (14, 1, 501, 600, 36, '2008-05-05 12:06:21');
  347. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (15, 1, 601, 700, 42, '2008-05-05 12:06:21');
  348. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (16, 1, 701, 800, 48, '2008-05-05 12:06:21');
  349. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (17, 1, 801, 899, 56, '2008-05-05 12:06:21');
  350. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (18, 1, 900, 3000, 6, '2008-05-05 12:06:22');
  351. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (19, 2, 0, 100, 8, '2008-05-05 12:06:40');
  352. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (20, 2, 101, 300, 9, '2008-05-05 12:14:03');
  353. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (21, 2, 301, 500, 10, '2008-05-05 12:14:03');
  354. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (22, 2, 501, 700, 14, '2008-05-05 12:14:03');
  355. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (23, 2, 701, 900, 16, '2008-05-05 12:14:03');
  356. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (24, 2, 901, 1000, 20, '2008-05-05 12:14:03');
  357. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (25, 2, 1001, 10000, 2, '2008-05-05 12:14:03');
  358. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (26, 3, 0, 100, 7.2, '2008-05-05 12:18:53');
  359. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (27, 3, 101, 300, 8.1, '2008-05-05 12:18:53');
  360. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (28, 3, 301, 500, 9, '2008-05-05 12:18:53');
  361. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (29, 3, 501, 700, 12.6, '2008-05-05 12:18:53');
  362. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (30, 3, 701, 900, 14.4, '2008-05-05 12:18:53');
  363. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (31, 3, 901, 1000, 18, '2008-05-05 12:18:53');
  364. INSERT INTO pay_paymenttariff (id, paymentmethodid, amountstart, amountend, payuganda, date_entered) VALUES (32, 3, 1001, 10000, 1.8, '2008-05-05 12:18:53');
  365.  
  366. -- --------------------------------------------------------
  367.  
  368. --
  369. -- Table structure for table `pay_receivers`
  370. --
  371.  
  372. DROP TABLE IF EXISTS pay_receivers;
  373. CREATE TABLE pay_receivers (
  374. id int(6) NOT NULL auto_increment,
  375. senderid bigint(16) NOT NULL,
  376. orderno varchar(20) NOT NULL,
  377. rfname varchar(60) NOT NULL,
  378. rothername varchar(60) NOT NULL,
  379. rlname varchar(60) NOT NULL,
  380. rgender varchar(10) NOT NULL,
  381. remail varchar(120) NOT NULL,
  382. rphone varchar(30) NOT NULL,
  383. rpickup varchar(200) NOT NULL,
  384. date_entered datetime NOT NULL,
  385. PRIMARY KEY (id)
  386. ) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
  387.  
  388. --
  389. -- Dumping data for table `pay_receivers`
  390. --
  391.  
  392. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (1, 72, 'PU030708-1395923182', 'Tony ', '', 'Yayo', 'Male', 'yayo@gunitsoldierug.com', '034234523422', 'office', '2008-07-03 12:13:51');
  393. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (2, 77, 'PU110708-1461364278', 'trevor', '', 'did', 'Male', '338@778.com', '009772', 'office', '2008-07-11 13:19:33');
  394. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (3, 73, 'PU140708-124857832', 'Carol', '', 'Amito', 'Female', 'camito@eyit.co.ug', '0712564356', 'office', '2008-07-14 14:09:08');
  395. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (4, 0, 'PU240708-593264521', 'test', '', 'test', 'Male', 'hv@snapcard.com', '447834488610', 'office', '2008-07-24 14:49:15');
  396. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (5, 81, 'PU250708-1040011469', 'Mama Small', '', 'Kintu', 'Female', 'msmall@yahoo.com', '0884324', 'office', '2008-07-25 10:13:50');
  397. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (6, 83, 'PU010808-1340647182', 'Abahoo', '', 'Doreen', 'Female', 'mydoreen@yahoo.co.ug', '0723125666', 'office', '2008-08-01 15:06:05');
  398. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (7, 84, 'PU020808-1497301985', 'Mama Small', '', 'Kintu', 'Female', 'msmall@yahoo.com', '0884324', 'office', '2008-08-02 09:53:59');
  399. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (8, 84, 'PU020808-1223005982', 'yusuf', '', 'opad', 'Male', 'jjyusuf@gmail.com', '98', 'office', '2008-08-02 11:11:56');
  400. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (9, 84, 'PU020808-1742855708', 'yusuf', '', 'opad', 'Male', 'jjyusuf@gmail.com', '98', 'office', '2008-08-02 11:22:31');
  401. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (10, 84, 'PU020808-429608592', 'yusuf', '', 'opad', 'Male', 'jjyusuf@gmail.com', '98', 'office', '2008-08-02 11:31:25');
  402. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (11, 81, 'PU020808-1396699155', 'Mama Small', '', 'Kintu', 'Female', 'msmall@yahoo.com', '0884324', 'office', '2008-08-02 12:16:29');
  403. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (12, 81, 'PU020808-596750392', 'Ted', '', 'Turner', 'Male', 'almozm@hotmail.com', '0782444253', 'office', '2008-08-02 12:43:10');
  404. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (13, 69, 'PU060808-167766273', 'Samuel', '', 'Kabagambe', 'Male', 'sbaguma@hotmail.com', '0752502424', 'office', '2008-08-06 12:45:42');
  405. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (14, 85, 'PU090808-1484817663', 'Irene', '', 'Karugaba', 'Male', 'karuirene@hotmail.com', '0772354147', 'office', '2008-08-09 10:37:54');
  406. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (15, 85, 'PU120808-798197887', 'Ted', '', 'Turner', 'Male', 'almozm@hotmail.com', '0782444253', 'office', '2008-08-12 11:14:04');
  407. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (16, 60, 'PU140808-352530293', 'Irene', '', 'baguma', 'Female', 'kasam99@yahoo.com', '0752502424', 'office', '2008-08-14 06:25:10');
  408. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (17, 60, 'PU200808-1281630167', 'Samuel', '', 'Kabagambe', 'Male', 'sbaguma@payuganda.com', '0752502424', 'office', '2008-08-20 09:28:06');
  409. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (18, 60, 'PU200808-683832406', 'Samuel', '', 'Kabagambe', 'Male', 'sbaguma@hotmail.com', '0752502424', 'office', '2008-08-20 09:33:58');
  410. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (19, 60, '', 'Irene', '', 'Karugaba', 'Male', 'karuirene@hotmail.com', '0772354147', 'account', '2008-08-20 10:17:14');
  411. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (20, 60, 'PU200808-1908138311', 'Irene', '', 'Karugaba', 'Male', 'karuirene@hotmail.com', '0772354147', 'office', '2008-08-20 10:29:00');
  412. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (21, 0, 'PU200808-302225678', 'Valentine', '', 'Ojoro', 'Male', 'vojaro@eyitronald.com', '0702151417', 'office', '2008-08-20 10:54:50');
  413. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (22, 60, 'PU020908-1930036181', 'Irene', '', 'Baguma', 'Female', 'sbaguma@hotmail.com', '0752502424', 'office', '2008-09-02 13:55:05');
  414. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (23, 85, 'PU020908-1510261833', 'Alla', '', 'micheal', 'Male', 'a@a.com', '88824444', 'office', '2008-09-02 14:28:13');
  415. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (24, 62, 'PU040908-1253964532', 'Irene', '', 'Baguma', 'Female', 'sbaguma@hotmail.com', '0752502424', 'office', '2008-09-04 06:44:52');
  416. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (25, 60, 'PU040908-658418392', 'Irene', '', 'Baguma', 'Female', 'sbaguma@payuganda.com', '0752502424', 'office', '2008-09-04 07:28:38');
  417. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (26, 60, 'PU040908-1081563759', 'Irene', '', 'baguma', 'Female', 'kasam99@yahoo.com', '0752502424', 'office', '2008-09-04 10:06:18');
  418. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (27, 96, 'PU100908-1569790305', 'Ami', '', 'Mansaray', 'Female', 'aminata@yahoo.com', '033442975', 'office', '2008-09-10 13:03:28');
  419. INSERT INTO pay_receivers (id, senderid, orderno, rfname, rothername, rlname, rgender, remail, rphone, rpickup, date_entered) VALUES (28, 98, 'PU150908-6018311', 'Valentine', '', 'Ojoro', 'Male', 'vojaro@eyitronald.com', '0702151417', 'office', '2008-09-15 09:20:04');
  420.  
  421. -- --------------------------------------------------------
  422.  
  423. --
  424. -- Table structure for table `pay_rights`
  425. --
  426.  
  427. DROP TABLE IF EXISTS pay_rights;
  428. CREATE TABLE pay_rights (
  429. id tinyint(3) NOT NULL auto_increment,
  430. persons varchar(20) NOT NULL,
  431. righttype varchar(5) NOT NULL,
  432. PRIMARY KEY (id)
  433. ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  434.  
  435. --
  436. -- Dumping data for table `pay_rights`
  437. --
  438.  
  439. INSERT INTO pay_rights (id, persons, righttype) VALUES (1, 'root', 'r11');
  440. INSERT INTO pay_rights (id, persons, righttype) VALUES (2, 'agent', 'r12');
  441. INSERT INTO pay_rights (id, persons, righttype) VALUES (3, 'client', 'r13');
  442.  
  443. -- --------------------------------------------------------
  444.  
  445. --
  446. -- Table structure for table `pay_senders`
  447. --
  448.  
  449. DROP TABLE IF EXISTS pay_senders;
  450. CREATE TABLE pay_senders (
  451. id int(6) NOT NULL auto_increment,
  452. senderid int(6) NOT NULL,
  453. sfname varchar(60) NOT NULL,
  454. sothername varchar(60) NOT NULL,
  455. slname varchar(60) NOT NULL,
  456. sgender varchar(10) NOT NULL,
  457. sphone varchar(30) NOT NULL,
  458. saddress text NOT NULL,
  459. date_entered datetime NOT NULL,
  460. PRIMARY KEY (id)
  461. ) ENGINE=MyISAM AUTO_INCREMENT=109 DEFAULT CHARSET=latin1;
  462.  
  463. --
  464. -- Dumping data for table `pay_senders`
  465. --
  466.  
  467. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (67, 69, 'Luwambo', 'Kabisa', 'Ash', 'Male', '0752810020', 'Nwt, 30 Jinja Rd', '2008-06-13 13:21:57');
  468. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (69, 72, 'Ronald', '', 'Eyit', 'Male', '0782151413', 'None', '2008-07-02 13:54:17');
  469. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (71, 73, 'Ronald', '', 'Eyit', 'Male', '0707010101', 'None', '2008-07-03 13:48:43');
  470. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (70, 73, 'Ronald', '', 'Eyit', 'Male', '0707010101', 'None', '2008-07-03 13:48:43');
  471. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (15, 58, 'Mutungi', '', 'Tumusiime', 'Male', '4109610325', '6 Hartley Circle apt 715\r\nOwings Mills, MD \r\n21117', '2008-05-30 15:13:40');
  472. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (16, 60, 'Samuel', 'Kabagambe', 'Baguma', 'Male', '0772502424', 'Buganda Road', '2008-05-31 12:33:48');
  473. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (72, 74, 'Irene', 'Kayiwa', 'Nakayiwa', 'Female', '0782523325', 'Jinja Rd', '2008-07-11 07:36:14');
  474. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (73, 74, 'Irene', 'Kayiwa', 'Nakayiwa', 'Female', '0782523325', 'Jinja Rd', '2008-07-11 07:36:14');
  475. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (74, 75, 'James', 'Ssaba', 'lwanga', 'Male', '0772318566', 'South Beach', '2008-07-11 11:56:00');
  476. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (75, 76, 'Farouk', '', 'Kigozi', 'Male', '0782264168', '1833 kampala', '2008-07-11 12:08:23');
  477. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (76, 76, 'Farouk', '', 'Kigozi', 'Male', '0782264168', '1833 kampala', '2008-07-11 12:08:23');
  478. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (77, 77, 'Micheal', '', 'trump', 'Male', '778262663', '863, kyengera', '2008-07-11 13:02:03');
  479. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (78, 78, 'Henry', '', 'Kato', 'Male', '0772346789', 'Flat 17B\r\nBugolobi\r\nKampala\r\nUganda', '2008-07-16 00:44:44');
  480. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (79, 79, 'Ronald', '', 'Odong', 'Male', '0782151413', 'None', '2008-07-16 11:58:17');
  481. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (80, 79, 'Ronald', '', 'Odong', 'Male', '0782151413', 'None', '2008-07-16 11:58:17');
  482. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (81, 80, 'Hiske', '', 'Verder', 'Female', '447834488610', 'test', '2008-07-24 14:47:33');
  483. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (82, 81, 'Almond', 'Sekamatte', 'TESTER', 'Male', '0895635345', 'Plot 30 Jinja Rd.', '2008-07-25 08:29:41');
  484. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (83, 82, 'Ronald', '', 'Eyit', 'Male', '0782151413', 'None', '2008-07-29 06:50:59');
  485. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (84, 82, 'Ronald', '', 'Eyit', 'Male', '0782151413', 'None', '2008-07-29 06:50:59');
  486. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (85, 83, 'Ronald', '', 'Odong', 'Male', '0772434556', 'None', '2008-08-01 12:21:49');
  487. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (86, 83, 'Ronald', '', 'Odong', 'Male', '0772434556', 'None', '2008-08-01 12:21:49');
  488. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (87, 84, 'Maggie', '', 'Matovu', 'Female', '4423345', 'LONDON craydon', '2008-08-02 09:31:55');
  489. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (88, 84, 'Maggie', '', 'Matovu', 'Female', '4423345', 'LONDON craydon', '2008-08-02 09:53:59');
  490. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (89, 85, 'Allan', '', 'Zaramba', 'Male', '993787656273', '8903903', '2008-08-09 10:35:03');
  491. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (90, 85, 'Allan', '', 'Zaramba', 'Male', '993787656273', '8903903', '2008-08-09 10:37:54');
  492. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (91, 87, 'John', '', 'Jones', 'Male', '99999999', '41 Jones st\r\nDawser\r\nAustralia', '2008-08-13 12:01:26');
  493. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (92, 88, 'John', '', 'Eattell', 'Male', '61893590939', '48 Tallerack Way\r\nForrestfield\r\nWestern Australia\r\nAustralia', '2008-08-16 05:39:21');
  494. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (93, 88, 'John', '', 'Eattell', 'Male', '61893590939', '48 Tallerack Way\r\nForrestfield\r\nWestern Australia\r\nAustralia', '2008-08-16 05:39:21');
  495. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (94, 89, 'Ash', 'Luwambo', 'Kabisa', 'Male', '0752810020', 'jinja road', '2008-08-29 19:03:27');
  496. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (95, 90, 'Alice', '', 'Babirye', 'Female', '00447984819604', '180a Queens Road\r\nPeckham\r\nLondon\r\nse15 2hp', '2008-09-02 14:35:20');
  497. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (96, 91, 'Samuel', '', 'Buka', 'Female', '00447984819604', '5 Millfields Road\r\nLondon E5 0AB', '2008-09-02 14:39:45');
  498. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (97, 91, 'Samuel', '', 'Buka', 'Female', '00447984819604', '5 Millfields Road\r\nLondon E5 0AB', '2008-09-02 14:39:45');
  499. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (98, 92, 'Samuel', '', 'baguma', 'Male', '0772502424', 'Buganda Road', '2008-09-04 07:20:00');
  500. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (99, 60, 'Samuel', 'Kabagambe', 'Baguma', 'Male', '0772502424', 'Buganda Road', '2008-09-04 07:28:38');
  501. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (100, 93, 'Samuel', '', 'Baguma', 'Male', '0704018193', 'Buganda Road', '2008-09-04 08:52:58');
  502. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (101, 93, 'Samuel', '', 'Baguma', 'Male', '0704018193', 'Buganda Road', '2008-09-04 08:52:58');
  503. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (102, 94, 'JOHN', '', 'CONNOLLY', 'Male', '07506775646', '60 ROUNDWOOD ROAD LONDON NW10 9TJ', '2008-09-08 02:49:52');
  504. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (103, 95, 'JOHN', '', 'CONNOLLY', 'Male', '07506775646', '60 ROUNDWOOD ROAD LONDON NW10 9TJ', '2008-09-08 02:51:23');
  505. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (104, 96, 'Fatmatta', '', 'Mansaray', 'Female', '07939455782', 'Gravesend \nKent ', '2008-09-10 12:58:57');
  506. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (105, 96, 'Fatmatta', '', 'Mansaray', 'Female', '07939455782', 'Gravesend \nKent ', '2008-09-10 12:58:57');
  507. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (106, 97, 'John', '', 'Smith', 'Male', '947578322', '12 Gumnur St\r\nFremantle', '2008-09-13 07:47:35');
  508. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (107, 98, 'Ronald', '', 'Eyit', 'Male', '0782151413', 'None', '2008-09-15 07:47:02');
  509. INSERT INTO pay_senders (id, senderid, sfname, sothername, slname, sgender, sphone, saddress, date_entered) VALUES (108, 98, 'Ronald', '', 'Eyit', 'Male', '0782151413', 'None', '2008-09-15 07:47:02');
  510.  
  511. -- --------------------------------------------------------
  512.  
  513. --
  514. -- Table structure for table `pay_specialoffer`
  515. --
  516.  
  517. DROP TABLE IF EXISTS pay_specialoffer;
  518. CREATE TABLE pay_specialoffer (
  519. id tinyint(3) NOT NULL auto_increment,
  520. title varchar(100) NOT NULL,
  521. image varchar(100) NOT NULL,
  522. featured enum('0','1') NOT NULL,
  523. date_entered datetime NOT NULL,
  524. PRIMARY KEY (id)
  525. ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  526.  
  527. --
  528. -- Dumping data for table `pay_specialoffer`
  529. --
  530.  
  531. INSERT INTO pay_specialoffer (id, title, image, featured, date_entered) VALUES (1, 'Uchumi Shopping Voucher', 'ad1.jpg', '1', '2008-04-28 11:14:11');
  532. INSERT INTO pay_specialoffer (id, title, image, featured, date_entered) VALUES (6, 'hghg', 'topimage.jpg', '0', '2008-04-28 13:09:39');
  533.  
  534. -- --------------------------------------------------------
  535.  
  536. --
  537. -- Table structure for table `pay_transactiontotal`
  538. --
  539.  
  540. DROP TABLE IF EXISTS pay_transactiontotal;
  541. CREATE TABLE pay_transactiontotal (
  542. id int(9) NOT NULL auto_increment,
  543. senderid bigint(16) NOT NULL,
  544. amount int(6) NOT NULL,
  545. date_posted int(10) unsigned NOT NULL,
  546. PRIMARY KEY (id)
  547. ) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;
  548.  
  549. --
  550. -- Dumping data for table `pay_transactiontotal`
  551. --
  552.  
  553. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (2, 77, 556, 1215723600);
  554. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (3, 73, 0, 1215982800);
  555. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (4, 0, 0, 1216846800);
  556. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (5, 81, 0, 1216933200);
  557. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (6, 83, 126, 1217538000);
  558. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (7, 84, 165, 1217624400);
  559. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (8, 84, 2375, 1217624400);
  560. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (9, 84, 43, 1217624400);
  561. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (10, 84, 89, 1217624400);
  562. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (11, 81, 614, 1217624400);
  563. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (12, 81, 830, 1217624400);
  564. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (13, 69, 135, 1217970000);
  565. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (14, 85, 530, 1218229200);
  566. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (15, 85, 374, 1218495600);
  567. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (16, 60, 162, 1218668400);
  568. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (17, 60, 369, 1219186800);
  569. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (18, 60, 258, 1219186800);
  570. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (19, 60, 142, 1219186800);
  571. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (20, 60, 168, 1219186800);
  572. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (21, 0, 162, 1219186800);
  573. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (22, 85, 680, 1220310000);
  574. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (23, 62, 469, 1220482800);
  575. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (24, 60, 476, 1220482800);
  576. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (25, 60, 340, 1220482800);
  577. INSERT INTO pay_transactiontotal (id, senderid, amount, date_posted) VALUES (26, 96, 100, 1221001200);
  578.  
  579. -- --------------------------------------------------------
  580.  
  581. --
  582. -- Table structure for table `pay_transfer`
  583. --
  584.  
  585. DROP TABLE IF EXISTS pay_transfer;
  586. CREATE TABLE pay_transfer (
  587. id tinyint(4) NOT NULL auto_increment,
  588. `name` varchar(50) NOT NULL,
  589. paymentmethod tinyint(2) NOT NULL,
  590. date_entered datetime NOT NULL,
  591. PRIMARY KEY (id)
  592. ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  593.  
  594. --
  595. -- Dumping data for table `pay_transfer`
  596. --
  597.  
  598. INSERT INTO pay_transfer (id, name, paymentmethod, date_entered) VALUES (1, 'Paypal', 1, '2008-05-04 20:48:04');
  599. INSERT INTO pay_transfer (id, name, paymentmethod, date_entered) VALUES (5, 'Direct Bank Transfer', 3, '2008-07-02 12:50:42');
  600. INSERT INTO pay_transfer (id, name, paymentmethod, date_entered) VALUES (3, 'Cash to Agent', 2, '2008-05-04 20:56:50');
  601. INSERT INTO pay_transfer (id, name, paymentmethod, date_entered) VALUES (4, 'SNAP', 1, '2008-05-21 12:38:25');
  602. INSERT INTO pay_transfer (id, name, paymentmethod, date_entered) VALUES (6, 'Google Checkout', 1, '2008-07-10 07:30:17');
  603.  
  604. -- --------------------------------------------------------
  605.  
  606. --
  607. -- Table structure for table `pay_transferrates`
  608. --
  609.  
  610. DROP TABLE IF EXISTS pay_transferrates;
  611. CREATE TABLE pay_transferrates (
  612. id tinyint(6) NOT NULL auto_increment,
  613. countryfrom tinyint(3) NOT NULL,
  614. countryto tinyint(3) NOT NULL,
  615. paymethod tinyint(3) NOT NULL,
  616. payrate int(6) NOT NULL,
  617. date_entered datetime NOT NULL,
  618. PRIMARY KEY (id)
  619. ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
  620.  
  621. --
  622. -- Dumping data for table `pay_transferrates`
  623. --
  624.  
  625. INSERT INTO pay_transferrates (id, countryfrom, countryto, paymethod, payrate, date_entered) VALUES (1, 3, 3, 1, 5000, '2008-04-29 11:07:33');
  626. INSERT INTO pay_transferrates (id, countryfrom, countryto, paymethod, payrate, date_entered) VALUES (2, 2, 2, 2, 10000, '2008-04-29 11:27:08');
  627. INSERT INTO pay_transferrates (id, countryfrom, countryto, paymethod, payrate, date_entered) VALUES (4, 3, 3, 2, 7000, '2008-04-30 08:08:01');
  628. INSERT INTO pay_transferrates (id, countryfrom, countryto, paymethod, payrate, date_entered) VALUES (5, 3, 3, 3, 10000, '2008-04-30 08:08:26');
  629. INSERT INTO pay_transferrates (id, countryfrom, countryto, paymethod, payrate, date_entered) VALUES (6, 3, 3, 4, 25000, '2008-04-30 08:08:39');
  630. INSERT INTO pay_transferrates (id, countryfrom, countryto, paymethod, payrate, date_entered) VALUES (7, 3, 2, 1, 30000, '2008-04-30 08:13:46');
  631.  
  632. -- --------------------------------------------------------
  633.  
  634. --
  635. -- Table structure for table `pay_user`
  636. --
  637.  
  638. DROP TABLE IF EXISTS pay_user;
  639. CREATE TABLE pay_user (
  640. id int(6) NOT NULL auto_increment,
  641. usname varchar(100) NOT NULL,
  642. uspass varchar(50) NOT NULL,
  643. `status` varchar(6) NOT NULL,
  644. PRIMARY KEY (id),
  645. UNIQUE KEY usname (usname)
  646. ) ENGINE=MyISAM AUTO_INCREMENT=99 DEFAULT CHARSET=latin1;
  647.  
  648. --
  649. -- Dumping data for table `pay_user`
  650. --
  651.  
  652. INSERT INTO pay_user (id, usname, uspass, status) VALUES (8, 'Admin', '524981e3837d42db6b0b57f5503a43af80796ca4', 'root');
  653. INSERT INTO pay_user (id, usname, uspass, status) VALUES (72, 'eyitronald@yahoo.com', 'dbac0c91d0a01f82bba30175c2219c6cf816aaa6', 'client');
  654. INSERT INTO pay_user (id, usname, uspass, status) VALUES (69, 'aluwambo@newwavetech.co.ug', '6c768be099f35b41266c8d70a7031ed841f30a82', 'client');
  655. INSERT INTO pay_user (id, usname, uspass, status) VALUES (73, 'ronieyit@yahoo.com', '09d3983dfdb56defe13dcc845188b3dce3620a47', 'client');
  656. INSERT INTO pay_user (id, usname, uspass, status) VALUES (53, 'info@snapcard.com', '6cd5243900d6d33ba03f2c5030d31d0ee4b554e6', 'client');
  657. INSERT INTO pay_user (id, usname, uspass, status) VALUES (54, 'leonkalgg@gg.jik', 'c05863449317ba8ce0f4c7ee3aac393524c47ff0', 'client');
  658. INSERT INTO pay_user (id, usname, uspass, status) VALUES (68, 'reyit@newwavetech.co.ug', 'dbac0c91d0a01f82bba30175c2219c6cf816aaa6', 'client');
  659. INSERT INTO pay_user (id, usname, uspass, status) VALUES (56, 'hv@snapcard.com', 'f760e60d76c581cb09c30c942af56058f169f35c', 'client');
  660. INSERT INTO pay_user (id, usname, uspass, status) VALUES (57, 'almozm@hotmail.com', '431c87279b018ff3a202f6fa35028c656e3be3ab', 'client');
  661. INSERT INTO pay_user (id, usname, uspass, status) VALUES (58, 'tungi75@gmail.com', '299166373d653de4b07e8c47c9f3e10b6144ed6c', 'client');
  662. INSERT INTO pay_user (id, usname, uspass, status) VALUES (59, 'sbaguma@payuganda.com', '6ba52a293ce070caa816d1fe0799141523ee8667', 'client');
  663. INSERT INTO pay_user (id, usname, uspass, status) VALUES (60, 'kabsam99@gmail.com', '13b804a60dc32884bbc454e3ec384034e37304b8', 'client');
  664. INSERT INTO pay_user (id, usname, uspass, status) VALUES (61, 'jnkeragasani@newwavetech.co.ug', '70e90761e44d54fa3ec44a0946b37d5925f41a84', 'client');
  665. INSERT INTO pay_user (id, usname, uspass, status) VALUES (62, 'kabsam99@yahoo.com', 'e729b25265a5b1d4fe7559797f9bcadda17107fa', 'client');
  666. INSERT INTO pay_user (id, usname, uspass, status) VALUES (74, 'inakayiwa@ewwavetech.co.ug', '466e732d0d4ffbdbe1f988eae63dd203aa28f40c', 'client');
  667. INSERT INTO pay_user (id, usname, uspass, status) VALUES (75, 'ssabaj@yahoo.com', '42365c485f4cbe9cebdb06988055a612f7a202e3', 'client');
  668. INSERT INTO pay_user (id, usname, uspass, status) VALUES (76, 'farouk7k@gmail.com', 'a9fda9c36521b5865d1e523833009e0f047b0288', 'client');
  669. INSERT INTO pay_user (id, usname, uspass, status) VALUES (77, 'almoz77@yahoo.co.uk', '4db0a238dd9196522f70ba9ead01a2900b26a1cd', 'client');
  670. INSERT INTO pay_user (id, usname, uspass, status) VALUES (78, 'hkatoo@yahoo.com', 'edff46d9d8d2133063e9d54d152957e23b65375b', 'client');
  671. INSERT INTO pay_user (id, usname, uspass, status) VALUES (79, 'roniodong@hotmail.com', '4328a119d008b21e41701f0dec3979c70e2ce158', 'client');
  672. INSERT INTO pay_user (id, usname, uspass, status) VALUES (80, 'hiskemail@mac.com', 'd369784c78eece22eaec9043fc50749e0a565ae9', 'client');
  673. INSERT INTO pay_user (id, usname, uspass, status) VALUES (81, 'azziwa@newwavetech.co.ug', '1669873af6f1843afa0569e077a518cb99d0f35a', 'client');
  674. INSERT INTO pay_user (id, usname, uspass, status) VALUES (82, 'reyit@cit.mak.ac.ug', '81347f81da1b4d4574b96b783487174a16f22e47', 'client');
  675. INSERT INTO pay_user (id, usname, uspass, status) VALUES (83, 'roniodong@yahoo.com', 'dbac0c91d0a01f82bba30175c2219c6cf816aaa6', 'client');
  676. INSERT INTO pay_user (id, usname, uspass, status) VALUES (84, 'jjyusuf@gmail.com', 'a907550d93e31481603a69e0204387e1eba5df52', 'client');
  677. INSERT INTO pay_user (id, usname, uspass, status) VALUES (85, 'allanz@atechuganda.com', '4db0a238dd9196522f70ba9ead01a2900b26a1cd', 'client');
  678. INSERT INTO pay_user (id, usname, uspass, status) VALUES (86, 'azm772002@yahoo.co.uk', '4db0a238dd9196522f70ba9ead01a2900b26a1cd', 'agent');
  679. INSERT INTO pay_user (id, usname, uspass, status) VALUES (87, 'john@optusnet.com.au', 'c36aec2146ebc1e4f203b8f01123af360c5d8f14', 'client');
  680. INSERT INTO pay_user (id, usname, uspass, status) VALUES (88, 'eattell@optusnet.com.au', '00667b6c268b65756b5516d4903340d035f6731e', 'client');
  681. INSERT INTO pay_user (id, usname, uspass, status) VALUES (89, 'lemyas@yahoo.com', '269495de14f52970b8c369413da3761eade1c4c2', 'client');
  682. INSERT INTO pay_user (id, usname, uspass, status) VALUES (90, 'baborye24@gmail.com', '45dbbf1ccda29f50614f0c32a9f87929cf8d5141', 'client');
  683. INSERT INTO pay_user (id, usname, uspass, status) VALUES (91, 'buka2015@excite.com', '3bdbd81d1c0481c08cb31910e2e4e0a4413e00dd', 'client');
  684. INSERT INTO pay_user (id, usname, uspass, status) VALUES (92, 'kabsam00@gmail.com', '4158f94c69b0c8e5cc2f351e6414f97b8c9767ca', 'client');
  685. INSERT INTO pay_user (id, usname, uspass, status) VALUES (93, 'sbaguma@hotmail.com', '4a79b06f369d08b746435193b829e0961ac3765b', 'client');
  686. INSERT INTO pay_user (id, usname, uspass, status) VALUES (94, 'VEARAUK@YAHOO.VOM', 'dd4cda980033d70ac40a211630c439d9d9014e27', 'client');
  687. INSERT INTO pay_user (id, usname, uspass, status) VALUES (95, 'VEARAUK@YAHOO.COM', 'e678aa3ed9d86f0fb6c76060f62df1f67c002077', 'client');
  688. INSERT INTO pay_user (id, usname, uspass, status) VALUES (96, 'lmansaray@gmail.com', '021262fcb0353d3813ed4ec7bcc53a35fb043d3e', 'client');
  689. INSERT INTO pay_user (id, usname, uspass, status) VALUES (97, 'John@yahoo.com', '99f4446bd590564a9343bb762612c53082d2054b', 'client');
  690. INSERT INTO pay_user (id, usname, uspass, status) VALUES (98, 'eyitronnie@yahoo.co.uk', 'dbac0c91d0a01f82bba30175c2219c6cf816aaa6', 'client');
  691.  
  692. -- --------------------------------------------------------
  693.  
  694. --
  695. -- Table structure for table `pay_websitecontent`
  696. --
  697.  
  698. DROP TABLE IF EXISTS pay_websitecontent;
  699. CREATE TABLE pay_websitecontent (
  700. id tinyint(3) NOT NULL auto_increment,
  701. `name` varchar(20) NOT NULL,
  702. content blob NOT NULL,
  703. PRIMARY KEY (id)
  704. ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
  705.  
  706. --
  707. -- Dumping data for table `pay_websitecontent`
  708. --
  709.  
  710. INSERT INTO pay_websitecontent (id, name, content) VALUES (1, 'aboutus', '<p>PAYUGANDA is registered as a Money Services Business (MSB) in the USA and is regulated by the US Department of Treasury under Document Control Number:20080650029925.</p>\r\n<p>Pay Uganda Limited is in the business of money remittance. The target market for Pay Uganda Limited are Ugandans living in the Diaspora whose remittance are growing year by year and stood at USD 700 million in 2006. <br />Pay Uganda Limited identified the need for formal channels to enable Ugandans living and working abroad send their money home in a fast, secure and cost effective way. <br /><br />Pay Uganda Limited was started to address the high rates of informality and the persistence of monopolies by banks and the few money transfer operators which in turn results in higher transfer costs and clients obtaining less value for their money.<br /><br />Pay Uganda&rsquo;s offer is simple: to provide a complete integrated on-line off-line payment solution at a very low cost enabling our customers to send and receive money through a range of options using the internet. Pay Uganda is designed to offer a fair and transparent money transfer service, leveraging the power of technology keep cost to the minimum and enrich the lives of our customers with the most complete end-to-end portfolio of solutions and services to become a leader in all the major areas that define next-generation remittance flows. <br /><br />Contact us<br /><br />PAY UGANDA LIMITED<br />Kalungi Commercial Plaza<br />Plot 48 Kla Rd/Plot 1 Johnston Street <br />Mobile: 0712 502424<br /><br />General inquiries:info@payuganda.com<br /><br />Support: If you can''t find the information you need, please contact us by calling our customer support hotline.</p>');
  711. INSERT INTO pay_websitecontent (id, name, content) VALUES (2, 'payuganda', '<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><strong><span style=\\"\\\\\\">How PAYUGANDA Works</span></strong></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><strong><span style=\\"\\\\\\">&nbsp;</span></strong></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\">Pay Uganda is an online service that allows you to conveniently use the Internet to send Money to Uganda. We offer the most secure and efficient yet affordable money transfer service to Uganda. Best of all our fees are guaranteed to be the lowest in the market and our exchange rate higher than most other money transfer establishments. Check out our Fee Schedule here.</span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\">&nbsp;</span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\">Its a very simple five step process:</span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\">&nbsp;</span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\"><strong>Step 1.</strong></span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\"><span>&nbsp;</span>Click Send Money on our menu OR Start Sending Money at our home page by using our Fees Calculator to determine the transfer charge and amount recipient will receive OR Register and account OR Login to your pre-registered account.</span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\">&nbsp;</span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\"><strong>Step 2.</strong></span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\">Enter recipient information.</span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\">&nbsp;</span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\"><strong>Step 3.</strong> </span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\">Enter your information.</span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\">&nbsp;</span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\"><strong>Step 4.</strong></span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\">Login and view the Transaction invoice. Changes can still be made at this stage.</span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\">&nbsp;</span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\"><strong>Step 5.</strong> </span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\">Complete the transaction. </span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\">Contact the person to whom you&rsquo;re sending the money, and give the recipient the Transaction Number. Their money will be ready to be collected. The recipient may then go to the most convenient pick up location and complete the Pay Uganda Funds Collection Form and present it at any counter for payment.</span></p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\">&nbsp;</p>\r\n<p class=\\"\\\\&quot;MsoNormal\\\\&quot;\\" style=\\"\\\\\\"><span style=\\"\\\\\\">Our objective is to provide a simple and secure means of sending money. Sending money to Uganda has never been easier, just one click away.... Send money Now!</span></p>\r\n<p>We pride ourselves in offering all our clients the best online experience in sending money to Uganda. Sending money is an easy 5 step process. <br /><br /><strong>Our competative exchange rate and our fees are provided online</strong></p>');
  712. INSERT INTO pay_websitecontent (id, name, content) VALUES (3, 'loyalty', '<p>Lorem ipsum ...</p>');
  713. INSERT INTO pay_websitecontent (id, name, content) VALUES (4, 'terms', '<p><strong>TERMS AND CONDITIONS</strong><br /><br /><br />Pay Uganda Limited MONEY TRANSFER SERVICE IS SUBJECT TO THE FOLLOWING TERMS AND CONDITIONS:<br />Note: The Terms and Conditions (\\"Terms and Conditions\\") below are in effect for all Pay Uganda Limited transactions on or after 28th of August, 2006. The Terms and Conditions set forth below describe the terms and conditions that apply to and govern Your access to and use of the Pay Uganda Limited website, Services and agents (as defined below). Do not use or access the Pay Uganda Limited website, or any of its Services or agents if you do not agree to be bound by such Terms and Conditions.</p>\r\n<p><br /><strong>Pay Uganda Limited MONEY TRANSFER SERVICE.</strong><br />An Pay Uganda Limited Money Transfer&reg; consumer may send a money transfer to be picked up by a designated recipient at any Pay Uganda Limited Agent location around the world through the PayUganda.com website subject to the hours of operation that the Agent location offers the Service.<br />Certain money transfer services, transfers that exceed certain principal amounts, and/or transfers to certain destinations may take longer or be subject to additional restrictions. Receivers must present a valid form of identification in accordance with Pay Uganda Limited policies.<br />Senders and Receivers must represent, warrant and certify to Pay Uganda Limited that their use of the Services shall not in any way, directly or indirectly:<br />(a) violate any law, statute, ordinance, contract or regulation, including but not limited to any law, statute, ordinance, contract or regulation relating to money laundering, illegal gambling activities, support for terrorist activities, fraud or theft, and/or<br />(b) Violate any of the Terms and Conditions of use. When required by applicable law, money transfers will be reported to federal, state, local or foreign authorities. In addition,<br />Pay Uganda Limited will cooperate with law enforcement in the prosecution of illegal activities to the fullest extent permitted by applicable law. You will be required to provide Pay Uganda Limited with certain information to allow Pay Uganda Limited, among other things: to verify<br />a)Your identity;<br />b) To receive appropriate bank card authorization to complete the transaction.<br />You agree that the information You provide is not false, inaccurate or misleading. Please contact Pay Uganda Limited at the customer service telephone number listed to obtain information regarding the conditions applicable to the Service You have selected or your expected payment location. Please refer to Pay Uganda Limited\\''s Online Privacy Statement for information concerning Pay Uganda Limited\\''s use of this information. It is important to carefully review the information concerning REFUNDS and CURRENCY EXCHANGE. Pay Uganda Limited may amend these Terms and Conditions at any time by posting the amended terms on the Pay Uganda Limited website, and all amended terms shall be effective immediately after they are posted to the website.</p>\r\n<p><br /><strong>FEES, PAYMENT AND CURRENCY EXCHANGE.</strong><br />In consideration for the use of the Service, You agree to pay to Pay Uganda Limited a fee for each money transfer initiated by You at the applicable rate then in effect (the \\"transfer fee\\"). The applicable transfer fee for Your transaction will be provided to You prior to Your final authorization of the transaction, in addition to any applicable fees for additional services.</p>');
  714. INSERT INTO pay_websitecontent (id, name, content) VALUES (5, 'privacy', '<p><strong>CUSTOMER PRIVACY POLICY</strong><br /><br /><br />Your privacy is as important to us as it is to you. To better protect your privacy we have created this notice to explain our online information practices and the choices you can make about the way your personal information is collected and used</p>\r\n<p><br /><strong>The Information We Collect</strong><br />From time to time, we may make changes to our privacy policy. These changes will be posted on this page so that you are always aware of the information we collect, how we use it, and under what circumstances we disclose it.</p>\r\n<p><br /><strong>Required Information:</strong><br />we need to know your name, e-mail address, the recipients name and address. This information is required and necessary for us to process transactions, protect you against credit card or debit card or bank account fraud, and allow us to contact you should the need arise.</p>\r\n<p><br /><strong>Transaction Information:</strong><br />To process transactions, we collect information related to each transaction, such as the amount you wish to transfer and the necessary delivery and identification information, including the email addresses of the parties involved.</p>\r\n<p><br /><strong>Questionnaires, Surveys and Profile Data:</strong><br />We may offer optional questionnaires and surveys to our users for collecting demographic information or assessing user interests and needs. The use of the information collected will be explained in the survey itself. Participation in such surveys is always optional.</p>\r\n<p><br /><strong>The Way We Use Information</strong><br />We use the information you provide about yourself only to provide the specific services you request.<br />We may use your IP address to help diagnose problems with our server and to administer our website. Your IP address is used to help identify you and your account and to reduce credit card or debit card fraud. IP addresses are not linked to personally identifiable information.<br />From time to time, we may also use the information we collect to notify you about new services and special offers we think you will find valuable. However, you may choose to be removed from our e-mail list if you do not wish to receive our periodic updates on our products and services.<br />Finally, we never use or share the personally identifiable information provided to us online in ways unrelated to the ones described above without also providing you an opportunity to opt-out or otherwise prohibit such unrelated uses.<br />The Terrorism Act 2000 (as amended by the Anti-terrorism, Crime and Security Act 2001) deals with suspicion of terrorist financing. Under section 21A, firms in the regulated sector are obliged to report where there are reasonable grounds to know or suspect offences relating to terrorist financing. These offences include:<br />&bull; fund-raising for the purposes of terrorism;<br />&bull; using or possessing money for the purposes of terrorism;<br />&bull; involvement in funding arrangements; and<br />&bull; money laundering (facilitating the retention or control of money which is destined for, or is the proceeds of, &ndash; terrorism).</p>\r\n<p><br /><strong>Our Commitment to Data Security</strong><br />To prevent unauthorized access, maintain data accuracy, and ensure the correct use of information, we have put in place certain physical, electronic, and managerial procedures to safeguard and secure the information we collect online. Our secure server software (SSL) encrypts all of your personal and credit card or debit card information before it is sent to us, to increase safety from interception or theft over the Internet.</p>\r\n<p><br /><strong>Links</strong><br />Our website may contain links to other sites, and we make all reasonable efforts to only link to sites that share our high standards and respect for privacy. However, we are not responsible for the content or the privacy practices used by other sites.</p>\r\n<p><br /><strong>Cookies</strong><br />Our website may also use a feature called a cookie. Cookies are small files that your web browser places on your computer\\''s hard drive. The cookies we use are called session cookies and are only active when you visit our website. This cookie conveniently keeps track of the transactional events you conduct while you are on the Pay Uganda website. The cookie expires when you leave our website and close your browser. Usage of a cookie is in no way linked to any personally identifiable information while on our site.</p>');
  715.  
  716. -- --------------------------------------------------------
  717.  
  718. --
  719. -- Table structure for table `paypal_transactions`
  720. --
  721.  
  722. DROP TABLE IF EXISTS paypal_transactions;
  723. CREATE TABLE paypal_transactions (
  724. id bigint(25) NOT NULL auto_increment,
  725. item_name text NOT NULL,
  726. item_number text NOT NULL,
  727. custom text NOT NULL,
  728. receiver_email text NOT NULL,
  729. receiver_id text NOT NULL,
  730. quantity text NOT NULL,
  731. memo text NOT NULL,
  732. payment_type text NOT NULL,
  733. payment_status text NOT NULL,
  734. payment_date datetime NOT NULL default '0000-00-00 00:00:00',
  735. payment_gross text NOT NULL,
  736. payment_fee text NOT NULL,
  737. mc_gross text NOT NULL,
  738. mc_fee text NOT NULL,
  739. mc_currency text NOT NULL,
  740. settle_amount text NOT NULL,
  741. settle_currency text NOT NULL,
  742. exchange_rate text NOT NULL,
  743. txn_id text NOT NULL,
  744. parent_txn_id text NOT NULL,
  745. txn_type text NOT NULL,
  746. first_name text NOT NULL,
  747. last_name text NOT NULL,
  748. payer_business_name text NOT NULL,
  749. address_name text NOT NULL,
  750. address_street text NOT NULL,
  751. address_city text NOT NULL,
  752. address_zip text NOT NULL,
  753. address_status text NOT NULL,
  754. address_country text NOT NULL,
  755. payer_email text NOT NULL,
  756. payer_id text NOT NULL,
  757. payer_status text NOT NULL,
  758. pending_reason text NOT NULL,
  759. reason_code text NOT NULL,
  760. notify_version text NOT NULL,
  761. verify_sign varchar(100) NOT NULL default '',
  762. date_of_entry datetime NOT NULL default '0000-00-00 00:00:00',
  763. PRIMARY KEY (id)
  764. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  765.  
  766. --
  767. -- Dumping data for table `paypal_transactions`
  768. --
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!