View difference between Paste ID: BmwLsNHW and ND2xBJYg
SHOW: | | - or go back to the newest paste.
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', '[email protected]', '<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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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', '[email protected]', '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, '[email protected]', 'dbac0c91d0a01f82bba30175c2219c6cf816aaa6', 'client');
654
INSERT INTO pay_user (id, usname, uspass, status) VALUES (69, '[email protected]', '6c768be099f35b41266c8d70a7031ed841f30a82', 'client');
655
INSERT INTO pay_user (id, usname, uspass, status) VALUES (73, '[email protected]', '09d3983dfdb56defe13dcc845188b3dce3620a47', 'client');
656
INSERT INTO pay_user (id, usname, uspass, status) VALUES (53, '[email protected]', '6cd5243900d6d33ba03f2c5030d31d0ee4b554e6', 'client');
657
INSERT INTO pay_user (id, usname, uspass, status) VALUES (54, '[email protected]', 'c05863449317ba8ce0f4c7ee3aac393524c47ff0', 'client');
658
INSERT INTO pay_user (id, usname, uspass, status) VALUES (68, '[email protected]', 'dbac0c91d0a01f82bba30175c2219c6cf816aaa6', 'client');
659
INSERT INTO pay_user (id, usname, uspass, status) VALUES (56, '[email protected]', 'f760e60d76c581cb09c30c942af56058f169f35c', 'client');
660
INSERT INTO pay_user (id, usname, uspass, status) VALUES (57, '[email protected]', '431c87279b018ff3a202f6fa35028c656e3be3ab', 'client');
661
INSERT INTO pay_user (id, usname, uspass, status) VALUES (58, '[email protected]', '299166373d653de4b07e8c47c9f3e10b6144ed6c', 'client');
662
INSERT INTO pay_user (id, usname, uspass, status) VALUES (59, '[email protected]', '6ba52a293ce070caa816d1fe0799141523ee8667', 'client');
663
INSERT INTO pay_user (id, usname, uspass, status) VALUES (60, '[email protected]', '13b804a60dc32884bbc454e3ec384034e37304b8', 'client');
664
INSERT INTO pay_user (id, usname, uspass, status) VALUES (61, '[email protected]', '70e90761e44d54fa3ec44a0946b37d5925f41a84', 'client');
665
INSERT INTO pay_user (id, usname, uspass, status) VALUES (62, '[email protected]', 'e729b25265a5b1d4fe7559797f9bcadda17107fa', 'client');
666
INSERT INTO pay_user (id, usname, uspass, status) VALUES (74, '[email protected]', '466e732d0d4ffbdbe1f988eae63dd203aa28f40c', 'client');
667
INSERT INTO pay_user (id, usname, uspass, status) VALUES (75, '[email protected]', '42365c485f4cbe9cebdb06988055a612f7a202e3', 'client');
668
INSERT INTO pay_user (id, usname, uspass, status) VALUES (76, '[email protected]', 'a9fda9c36521b5865d1e523833009e0f047b0288', 'client');
669
INSERT INTO pay_user (id, usname, uspass, status) VALUES (77, '[email protected]', '4db0a238dd9196522f70ba9ead01a2900b26a1cd', 'client');
670
INSERT INTO pay_user (id, usname, uspass, status) VALUES (78, '[email protected]', 'edff46d9d8d2133063e9d54d152957e23b65375b', 'client');
671
INSERT INTO pay_user (id, usname, uspass, status) VALUES (79, '[email protected]', '4328a119d008b21e41701f0dec3979c70e2ce158', 'client');
672
INSERT INTO pay_user (id, usname, uspass, status) VALUES (80, '[email protected]', 'd369784c78eece22eaec9043fc50749e0a565ae9', 'client');
673
INSERT INTO pay_user (id, usname, uspass, status) VALUES (81, '[email protected]', '1669873af6f1843afa0569e077a518cb99d0f35a', 'client');
674
INSERT INTO pay_user (id, usname, uspass, status) VALUES (82, '[email protected]', '81347f81da1b4d4574b96b783487174a16f22e47', 'client');
675
INSERT INTO pay_user (id, usname, uspass, status) VALUES (83, '[email protected]', 'dbac0c91d0a01f82bba30175c2219c6cf816aaa6', 'client');
676
INSERT INTO pay_user (id, usname, uspass, status) VALUES (84, '[email protected]', 'a907550d93e31481603a69e0204387e1eba5df52', 'client');
677
INSERT INTO pay_user (id, usname, uspass, status) VALUES (85, '[email protected]', '4db0a238dd9196522f70ba9ead01a2900b26a1cd', 'client');
678
INSERT INTO pay_user (id, usname, uspass, status) VALUES (86, '[email protected]', '4db0a238dd9196522f70ba9ead01a2900b26a1cd', 'agent');
679
INSERT INTO pay_user (id, usname, uspass, status) VALUES (87, '[email protected]', 'c36aec2146ebc1e4f203b8f01123af360c5d8f14', 'client');
680
INSERT INTO pay_user (id, usname, uspass, status) VALUES (88, '[email protected]', '00667b6c268b65756b5516d4903340d035f6731e', 'client');
681
INSERT INTO pay_user (id, usname, uspass, status) VALUES (89, '[email protected]', '269495de14f52970b8c369413da3761eade1c4c2', 'client');
682
INSERT INTO pay_user (id, usname, uspass, status) VALUES (90, '[email protected]', '45dbbf1ccda29f50614f0c32a9f87929cf8d5141', 'client');
683
INSERT INTO pay_user (id, usname, uspass, status) VALUES (91, '[email protected]', '3bdbd81d1c0481c08cb31910e2e4e0a4413e00dd', 'client');
684
INSERT INTO pay_user (id, usname, uspass, status) VALUES (92, '[email protected]', '4158f94c69b0c8e5cc2f351e6414f97b8c9767ca', 'client');
685
INSERT INTO pay_user (id, usname, uspass, status) VALUES (93, '[email protected]', '4a79b06f369d08b746435193b829e0961ac3765b', 'client');
686
INSERT INTO pay_user (id, usname, uspass, status) VALUES (94, '[email protected]', 'dd4cda980033d70ac40a211630c439d9d9014e27', 'client');
687
INSERT INTO pay_user (id, usname, uspass, status) VALUES (95, '[email protected]', 'e678aa3ed9d86f0fb6c76060f62df1f67c002077', 'client');
688
INSERT INTO pay_user (id, usname, uspass, status) VALUES (96, '[email protected]', '021262fcb0353d3813ed4ec7bcc53a35fb043d3e', 'client');
689
INSERT INTO pay_user (id, usname, uspass, status) VALUES (97, '[email protected]', '99f4446bd590564a9343bb762612c53082d2054b', 'client');
690
INSERT INTO pay_user (id, usname, uspass, status) VALUES (98, '[email protected]', '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:[email protected]<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
--