1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
| dkd@crautcher-desktop:/var/www/absolux/class$ grep 'USERPREFIX' /home/dkd/Documents/upload/engine/
/home/dkd/Documents/upload/engine/classes/uploads/upload.class.php: if ($user_group[$member_id['user_group']]['allow_admin']) $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$added_time}', '{$_IP}', '36', '{$uploaded_filename}')" );
/home/dkd/Documents/upload/engine/classes/uploads/upload.class.php: if ($user_group[$member_id['user_group']]['allow_admin']) $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$added_time}', '{$_IP}', '36', '{$uploaded_filename}')" );
/home/dkd/Documents/upload/engine/init.php: $db->query("SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC");
/home/dkd/Documents/upload/engine/init.php: $db->query("SELECT * FROM " . USERPREFIX . "_banned");
/home/dkd/Documents/upload/engine/init.php: $db->query("UPDATE " . USERPREFIX . "_users set user_group='{$user_group[$member_id['user_group']]['rid']}', time_limit='' WHERE user_id='$member_id[user_id]'");
/home/dkd/Documents/upload/engine/modules/pm_alert.php:$row = $db->super_query("SELECT subj, text, user_from FROM " . USERPREFIX . "_pm WHERE user = '$member_id[user_id]' AND folder = 'inbox' ORDER BY pm_read ASC, date DESC LIMIT 0,1");
/home/dkd/Documents/upload/engine/modules/changemail.php: $row = $db->super_query( "SELECT * FROM " . USERPREFIX . "_mail_log WHERE hash='{$hashid}'" );
/home/dkd/Documents/upload/engine/modules/changemail.php: $db->query( "UPDATE " . USERPREFIX . "_users SET email='{$row['mail']}' WHERE user_id = '{$row['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/changemail.php: $db->query( "DELETE FROM " . USERPREFIX . "_mail_log WHERE user_id='{$row['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/addcomments.php: $db->query( "SELECT name from " . USERPREFIX . "_users where LOWER(name) = '" . strtolower( $name ) . "'" );
/home/dkd/Documents/upload/engine/modules/addcomments.php: $db->query( "UPDATE " . USERPREFIX . "_users set comm_num=comm_num+1 where user_id ='$member_id[user_id]'" );
/home/dkd/Documents/upload/engine/modules/feedback.php: $db->query( "SELECT name from " . USERPREFIX . "_users where LOWER(name) = '" . strtolower( $name ) . "' OR LOWER(email) = '" . strtolower( $email ) . "'" );
/home/dkd/Documents/upload/engine/modules/feedback.php: $recipient = $db->super_query( "SELECT name, email, fullname FROM " . USERPREFIX . "_users WHERE user_id='" . $recip . "' AND user_group = '1'" );
/home/dkd/Documents/upload/engine/modules/feedback.php: $recipient = $db->super_query( "SELECT name, email, fullname FROM " . USERPREFIX . "_users WHERE user_id='" . $recip . "' AND allow_mail = '1'" );
/home/dkd/Documents/upload/engine/modules/feedback.php: if( ! $user ) $db->query( "SELECT name, user_group, user_id FROM " . USERPREFIX . "_users WHERE user_group < '$group' AND allow_mail = '1' ORDER BY user_group" );
/home/dkd/Documents/upload/engine/modules/feedback.php: else $db->query( "SELECT name, user_group, user_id FROM " . USERPREFIX . "_users WHERE user_id = '$user' AND allow_mail = '1'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $row = $db->super_query( "SELECT id, user, user_from, pm_read, folder FROM " . USERPREFIX . "_pm where id= '{$pmid}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "DELETE FROM " . USERPREFIX . "_pm WHERE id='{$row['id']}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "UPDATE " . USERPREFIX . "_users SET pm_unread=pm_unread-1 where user_id='{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "UPDATE " . USERPREFIX . "_users SET pm_all=pm_all-1 where user_id='{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $row = $db->super_query( "SELECT id, user, user_from, pm_read, folder FROM " . USERPREFIX . "_pm where id= '{$pmid}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "UPDATE " . USERPREFIX . "_users SET pm_unread=pm_unread+1 WHERE user_id='{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "UPDATE " . USERPREFIX . "_pm SET pm_read='0' WHERE id='{$row['id']}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $row = $db->super_query( "SELECT id, user, user_from, pm_read, folder FROM " . USERPREFIX . "_pm where id= '{$pmid}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "UPDATE " . USERPREFIX . "_users SET pm_unread=pm_unread-1 WHERE user_id='{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "UPDATE " . USERPREFIX . "_pm SET pm_read='1' WHERE id='{$row['id']}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "SELECT email, name, user_id, pm_all, user_group FROM " . USERPREFIX . "_users WHERE name = '$name'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "SELECT id FROM " . USERPREFIX . "_ignore_list WHERE user='{$row['user_id']}' AND user_from='{$member_id['name']}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "INSERT INTO " . USERPREFIX . "_pm (subj, text, user, user_from, date, pm_read, folder) values ('$subj', '$comments', '{$row['user_id']}', '{$member_id['name']}', '{$time}', '0', 'outbox')" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "UPDATE " . USERPREFIX . "_users SET pm_all=pm_all+1 WHERE user_id='{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "INSERT INTO " . USERPREFIX . "_pm (subj, text, user, user_from, date, pm_read, folder, sendid) values ('$subj', '$comments', '{$row['user_id']}', '{$member_id['name']}', '{$time}', '0', 'inbox', '{$send_id}')" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "UPDATE " . USERPREFIX . "_users SET pm_all=pm_all+1, pm_unread=pm_unread+1 WHERE user_id='{$row['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "UPDATE " . USERPREFIX . "_pm SET reply=1 WHERE id= '{$replyid}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $row = $db->super_query( "SELECT id, user, user_from, pm_read, folder FROM " . USERPREFIX . "_pm where id= '{$pmid}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "DELETE FROM " . USERPREFIX . "_pm WHERE id='{$row['id']}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "UPDATE " . USERPREFIX . "_users SET pm_unread=pm_unread-1 WHERE user_id='{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "UPDATE " . USERPREFIX . "_users SET pm_all=pm_all-1 WHERE user_id='{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "SELECT id, subj, text, user, user_from, date, pm_read, folder, sendid, news_num, comm_num, user_group, reg_date, signature, foto, fullname, land, icq, xfields FROM " . USERPREFIX . "_pm LEFT JOIN " . USERPREFIX . "_users ON " . USERPREFIX . "_pm.user_from=" . USERPREFIX . "_users.name WHERE " . USERPREFIX . "_pm.id= '$pmid'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "UPDATE " . USERPREFIX . "_users SET pm_unread=pm_unread-1 WHERE user_id='{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "UPDATE " . USERPREFIX . "_pm SET pm_read='1' WHERE id='{$row['id']}'{$addwhere}" );
/home/dkd/Documents/upload/engine/modules/pm.php: $row = $db->super_query( "SELECT * FROM " . USERPREFIX . "_pm WHERE id= '$replyid'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $row = $db->super_query( "SELECT user_id, pm_all, user_group FROM " . USERPREFIX . "_users WHERE name = '" . $db->safesql( $row['user_from'] ) . "'" );
/home/dkd/Documents/upload/engine/modules/pm.php: if( $user ) $row = $db->super_query( "SELECT user_id, name, pm_all, user_group FROM " . USERPREFIX . "_users WHERE user_id = '$user'" );
/home/dkd/Documents/upload/engine/modules/pm.php: elseif( $username != "" ) $row = $db->super_query( "SELECT user_id, name, pm_all, user_group FROM " . USERPREFIX . "_users where name='$username'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "SELECT id FROM " . USERPREFIX . "_ignore_list WHERE user='{$row['user_id']}' AND user_from='{$member_id['name']}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $db->query( "UPDATE " . USERPREFIX . "_users SET pm_unread='0' WHERE user_id='{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/pm.php: $sql = "SELECT SQL_CALC_FOUND_ROWS id, subj, name as user_from, date, pm_read FROM " . USERPREFIX . "_pm LEFT JOIN " . USERPREFIX . "_users ON " . USERPREFIX . "_pm.user=" . USERPREFIX . "_users.user_id WHERE user_from = '{$member_id['name']}' AND folder = 'outbox' ORDER BY date DESC LIMIT " . $cstart . "," . $pm_per_page;
/home/dkd/Documents/upload/engine/modules/pm.php: $sql = "SELECT SQL_CALC_FOUND_ROWS id, subj, user_from, date, pm_read, reply FROM " . USERPREFIX . "_pm where user = '{$member_id['user_id']}' AND folder = 'inbox' ORDER BY pm_read ASC, date DESC LIMIT " . $cstart . "," . $pm_per_page;
/home/dkd/Documents/upload/engine/modules/banned.php:$sel_banned = $db->query( "SELECT users_id FROM " . USERPREFIX . "_banned WHERE days != '0' AND date < '$this_time'" );
/home/dkd/Documents/upload/engine/modules/banned.php: if( $row['users_id'] ) $db->query( "UPDATE " . USERPREFIX . "_users SET banned='' WHERE user_id = '{$row['users_id']}'" );
/home/dkd/Documents/upload/engine/modules/banned.php: $db->query( "DELETE FROM " . USERPREFIX . "_banned WHERE days != '0' AND date < '$this_time'" );
/home/dkd/Documents/upload/engine/modules/lastcomments.php: $comments->query = "SELECT " . PREFIX . "_comments.id, post_id, " . PREFIX . "_comments.user_id, " . PREFIX . "_comments.date, " . PREFIX . "_comments.autor as gast_name, " . PREFIX . "_comments.email as gast_email, text, ip, is_register, name, " . USERPREFIX . "_users.email, news_num, " . USERPREFIX . "_users.comm_num, user_group, lastdate, reg_date, signature, foto, fullname, land, icq, " . USERPREFIX . "_users.xfields, " . PREFIX . "_post.title, " . PREFIX . "_post.date as newsdate, " . PREFIX . "_post.alt_name, " . PREFIX . "_post.category FROM " . PREFIX . "_comments LEFT JOIN " . PREFIX . "_post ON " . PREFIX . "_comments.post_id=" . PREFIX . "_post.id LEFT JOIN " . USERPREFIX . "_users ON " . PREFIX . "_comments.user_id=" . USERPREFIX . "_users.user_id " . $where . " ORDER BY id desc";
/home/dkd/Documents/upload/engine/modules/deletenews.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '26', '".$db->safesql($row['title'])."')" );
/home/dkd/Documents/upload/engine/modules/deletenews.php: $db->query("UPDATE " . USERPREFIX . "_users set news_num=news_num-1 where name='{$row['autor']}'");
/home/dkd/Documents/upload/engine/modules/addnews.php: $db->query( "UPDATE LOW_PRIORITY " . USERPREFIX . "_users SET restricted='0', restricted_days='0', restricted_date='' WHERE user_id='{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/addnews.php: $db->query( "UPDATE " . USERPREFIX . "_users set news_num=news_num+1 where user_id='{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/cron.php: $db->query( "DELETE FROM " . USERPREFIX . "_banned WHERE days != '0' AND date < '$_TIME' AND users_id = '0'" );
/home/dkd/Documents/upload/engine/modules/cron.php: $sql_result = $db->query( "SELECT name, user_id, foto FROM " . USERPREFIX . "_users WHERE lastdate < '$thisdate' and user_group = '4'" );
/home/dkd/Documents/upload/engine/modules/cron.php: $db->query( "DELETE FROM " . USERPREFIX . "_pm WHERE user_from = '{$row['name']}' AND folder = 'outbox'" );
/home/dkd/Documents/upload/engine/modules/cron.php: $db->query( "DELETE FROM " . USERPREFIX . "_pm WHERE user='{$row['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/cron.php: $db->query( "DELETE FROM " . USERPREFIX . "_banned WHERE users_id='{$row['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/cron.php: $db->query( "DELETE FROM " . USERPREFIX . "_users WHERE user_id = '{$row['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/lostpassword.php: $row = $db->super_query( "SELECT lostid FROM " . USERPREFIX . "_lostdb WHERE lostname='$douser'" );
/home/dkd/Documents/upload/engine/modules/lostpassword.php: $row = $db->super_query( "SELECT email, name FROM " . USERPREFIX . "_users WHERE user_id='$douser' LIMIT 0,1" );
/home/dkd/Documents/upload/engine/modules/lostpassword.php: $db->query( "UPDATE " . USERPREFIX . "_users SET allowed_ip = '' WHERE user_id='$douser'" );
/home/dkd/Documents/upload/engine/modules/lostpassword.php: $db->query( "DELETE FROM " . USERPREFIX . "_lostdb WHERE lostname='$douser'" );
/home/dkd/Documents/upload/engine/modules/lostpassword.php: $db->query( "UPDATE " . USERPREFIX . "_users set password='" . md5( md5( $new_pass ) ) . "', allowed_ip = '' WHERE user_id='$douser'" );
/home/dkd/Documents/upload/engine/modules/lostpassword.php: $db->query( "DELETE FROM " . USERPREFIX . "_lostdb WHERE lostname='$douser'" );
/home/dkd/Documents/upload/engine/modules/lostpassword.php: $db->query( "DELETE FROM " . USERPREFIX . "_lostdb WHERE lostname='$douser'" );
/home/dkd/Documents/upload/engine/modules/lostpassword.php: $db->query( "SELECT email, password, name, user_id FROM " . USERPREFIX . "_users where {$search} LIMIT 0,1" );
/home/dkd/Documents/upload/engine/modules/lostpassword.php: $db->query( "DELETE FROM " . USERPREFIX . "_lostdb WHERE lostname='$userid'" );
/home/dkd/Documents/upload/engine/modules/lostpassword.php: $db->query( "INSERT INTO " . USERPREFIX . "_lostdb (lostname, lostid) values ('$userid', '$lostid')" );
/home/dkd/Documents/upload/engine/modules/stats.php: $row = $db->super_query( "SELECT COUNT(*) as count FROM " . USERPREFIX . "_users" );
/home/dkd/Documents/upload/engine/modules/stats.php: $row = $db->super_query( "SELECT COUNT(*) as count FROM " . USERPREFIX . "_users WHERE banned='yes'" );
/home/dkd/Documents/upload/engine/modules/stats.php: $row = $db->super_query( "SELECT COUNT(*) as count FROM " . USERPREFIX . "_users WHERE reg_date > '$temp_date'" );
/home/dkd/Documents/upload/engine/modules/stats.php: $row = $db->super_query( "SELECT COUNT(*) as count FROM " . USERPREFIX . "_users WHERE reg_date > '$temp_date'" );
/home/dkd/Documents/upload/engine/modules/stats.php: $row = $db->super_query( "SELECT COUNT(*) as count FROM " . USERPREFIX . "_users WHERE reg_date > '$temp_date'" );
/home/dkd/Documents/upload/engine/modules/stats.php: $db->query( "SELECT user_id, name, user_group, reg_date, lastdate, news_num, comm_num FROM " . USERPREFIX . "_users WHERE news_num > '0' ORDER BY news_num DESC LIMIT 0,10" );
/home/dkd/Documents/upload/engine/modules/show.short.php: if ( $member_id['favorites'] AND !$count_all ) $db->query( "UPDATE " . USERPREFIX . "_users SET favorites='' WHERE user_id = '{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/search.php: $comms_fields = "SELECT SQL_CALC_FOUND_ROWS " . PREFIX . "_comments.id AS coms_id, post_id AS id, " . PREFIX . "_comments.date, " . PREFIX . "_comments.autor AS autor, " . PREFIX . "_comments.email AS gast_email, " . PREFIX . "_comments.text AS story, ip, is_register, name, " . USERPREFIX . "_users.email, news_num, " . USERPREFIX . "_users.comm_num, reg_date, banned, signature, foto, fullname, land, icq, " . PREFIX . "_post.date AS newsdate, " . PREFIX . "_post.title, " . PREFIX . "_post.category, " . PREFIX . "_post.alt_name, '1' AS output_comms";
/home/dkd/Documents/upload/engine/modules/search.php: $comms_from = "FROM " . PREFIX . "_comments LEFT JOIN " . PREFIX . "_post ON " . PREFIX . "_comments.post_id=" . PREFIX . "_post.id LEFT JOIN " . USERPREFIX . "_users ON " . PREFIX . "_comments.user_id=" . USERPREFIX . "_users.user_id";
/home/dkd/Documents/upload/engine/modules/comments.php: $db->query( "UPDATE " . USERPREFIX . "_users set comm_num=comm_num-1 where name ='$author'" );
/home/dkd/Documents/upload/engine/modules/comments.php: $db->query( "UPDATE " . USERPREFIX . "_users set comm_num=comm_num-1 where name ='$author'" );
/home/dkd/Documents/upload/engine/modules/profile.php: $row = $db->super_query( "SELECT * FROM " . USERPREFIX . "_users WHERE user_id = '{$id}'" );
/home/dkd/Documents/upload/engine/modules/profile.php: $db->query( "UPDATE " . USERPREFIX . "_users set foto='$foto_name' WHERE user_id = '{$id}'" );
/home/dkd/Documents/upload/engine/modules/profile.php: $db->query( "UPDATE " . USERPREFIX . "_users set foto='' WHERE user_id = '{$id}'" );
/home/dkd/Documents/upload/engine/modules/profile.php: $db->query( "SELECT name FROM " . USERPREFIX . "_users WHERE email = '$email' AND user_id != '{$id}'" );
/home/dkd/Documents/upload/engine/modules/profile.php: $sql_user = "UPDATE " . USERPREFIX . "_users set fullname='$fullname', land='$land', icq='$icq',{$mailchange} info='$info', signature='$signature', password='$password1', allow_mail='$allow_mail', xfields='$filecontents', allowed_ip='$allowed_ip' WHERE user_id = '{$id}'";
/home/dkd/Documents/upload/engine/modules/profile.php: $sql_user = "UPDATE " . USERPREFIX . "_users set fullname='$fullname', land='$land', icq='$icq',{$mailchange} info='$info', signature='$signature', allow_mail='$allow_mail', xfields='$filecontents', allowed_ip='$allowed_ip' WHERE user_id = '{$id}'";
/home/dkd/Documents/upload/engine/modules/profile.php: if ($user_group[$member_id['user_group']]['admin_editusers']) $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '64', '{$row['name']}')" );
/home/dkd/Documents/upload/engine/modules/profile.php: $db->query( "DELETE FROM " . USERPREFIX . "_mail_log WHERE user_id='{$row['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/profile.php: $db->query( "INSERT INTO " . USERPREFIX . "_mail_log (user_id, mail, hash) values ('{$row['user_id']}', '{$email}', '{$hashid}')" );
/home/dkd/Documents/upload/engine/modules/profile.php:$sql_result = $db->query( "SELECT * FROM " . USERPREFIX . "_users WHERE name = '$user'" );
/home/dkd/Documents/upload/engine/modules/profile.php: $temp_result = $db->query( "SELECT * FROM " . USERPREFIX . "_ignore_list WHERE user='{$row['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/favorites.php: $row = $db->super_query( "SELECT favorites FROM " . USERPREFIX . "_users where user_id = '$member_id[user_id]'" );
/home/dkd/Documents/upload/engine/modules/favorites.php: $db->query( "UPDATE " . USERPREFIX . "_users set favorites='$favorites' where user_id = '$member_id[user_id]'" );
/home/dkd/Documents/upload/engine/modules/favorites.php: $db->query( "UPDATE " . USERPREFIX . "_users set favorites='$member_id[favorites]' where user_id = '$member_id[user_id]'" );
/home/dkd/Documents/upload/engine/modules/sitelogin.php: $member_id = $db->super_query( "SELECT * FROM " . USERPREFIX . "_users WHERE {$where_name} AND password='" . md5( $_POST['login_password'] ) . "'" );
/home/dkd/Documents/upload/engine/modules/sitelogin.php: $db->query( "UPDATE " . USERPREFIX . "_users set hash='" . $hash . "', lastdate='{$_TIME}', logged_ip='" . $_IP . "' WHERE user_id='{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/sitelogin.php: $db->query( "UPDATE LOW_PRIORITY " . USERPREFIX . "_users set lastdate='{$_TIME}', logged_ip='" . $_IP . "' WHERE user_id='{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/sitelogin.php: $member_id = $db->super_query( "SELECT * FROM " . USERPREFIX . "_users WHERE user_id='" . intval( $_SESSION['dle_user_id'] ) . "'" );
/home/dkd/Documents/upload/engine/modules/sitelogin.php: $member_id = $db->super_query( "SELECT * FROM " . USERPREFIX . "_users WHERE user_id='" . intval( $_COOKIE['dle_user_id'] ) . "'" );
/home/dkd/Documents/upload/engine/modules/sitelogin.php: $db->query( "UPDATE LOW_PRIORITY " . USERPREFIX . "_users SET lastdate='{$_TIME}' WHERE user_id='{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/register.php: $row = $db->super_query( "SELECT COUNT(*) as count FROM " . USERPREFIX . "_users WHERE email = '$email' OR LOWER(name) REGEXP '[[:<:]]{$search_name}[[:>:]]' OR name = '$name'" );
/home/dkd/Documents/upload/engine/modules/register.php: $row = $db->super_query( "SELECT COUNT(*) as count FROM " . USERPREFIX . "_users" );
/home/dkd/Documents/upload/engine/modules/register.php: $row = $db->super_query( "SELECT COUNT(*) as count FROM " . USERPREFIX . "_users WHERE logged_ip = '{$_IP}'" );
/home/dkd/Documents/upload/engine/modules/register.php: $row = $db->super_query( "SELECT * FROM " . USERPREFIX . "_users WHERE name = '$user' AND password='$pass'" );
/home/dkd/Documents/upload/engine/modules/register.php: $db->query( "UPDATE " . USERPREFIX . "_users SET foto='$foto_name' WHERE user_id='{$row['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/register.php: $db->query( "UPDATE " . USERPREFIX . "_users SET fullname='$fullname', info='$info', land='$land', icq='$icq', xfields='$filecontents' WHERE user_id='{$row['user_id']}'" );
/home/dkd/Documents/upload/engine/modules/register.php: $db->query( "INSERT INTO " . USERPREFIX . "_users (name, password, email, reg_date, lastdate, user_group, info, signature, favorites, xfields, logged_ip) VALUES ('$name', '$regpassword', '$email', '$add_time', '$add_time', '" . $config['reg_group'] . "', '', '', '', '', '" . $_IP . "')" );
/home/dkd/Documents/upload/engine/modules/show.full.php: $comments->query = "SELECT " . PREFIX . "_comments.id, post_id, " . PREFIX . "_comments.user_id, date, autor as gast_name, " . PREFIX . "_comments.email as gast_email, text, ip, is_register, name, " . USERPREFIX . "_users.email, news_num, comm_num, user_group, lastdate, reg_date, signature, foto, fullname, land, icq, xfields FROM " . PREFIX . "_comments LEFT JOIN " . USERPREFIX . "_users ON " . PREFIX . "_comments.user_id=" . USERPREFIX . "_users.user_id WHERE " . PREFIX . "_comments.post_id = '$news_id'" . $where_approve . " ORDER BY date " . $config['comm_msort'];
/home/dkd/Documents/upload/engine/modules/show.full.php: $db->query( "UPDATE LOW_PRIORITY " . USERPREFIX . "_users SET restricted='0', restricted_days='0', restricted_date='' WHERE user_id='{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/ajax/complaint.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/complaint.php: $row = $db->super_query( "SELECT id, text, user, user_from FROM " . USERPREFIX . "_pm WHERE id='{$id}'" );
/home/dkd/Documents/upload/engine/ajax/editnews.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/editnews.php: if ($user_group[$member_id['user_group']]['allow_admin']) $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '25', '{$_POST['title']}')" );
/home/dkd/Documents/upload/engine/ajax/addcomments.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/addcomments.php: $db->query ( "SELECT * FROM " . USERPREFIX . "_banned" );
/home/dkd/Documents/upload/engine/ajax/addcomments.php: $comments->query = "SELECT " . PREFIX . "_comments.id, post_id, " . PREFIX . "_comments.user_id, date, autor as gast_name, " . PREFIX . "_comments.email as gast_email, text, ip, is_register, name, " . USERPREFIX . "_users.email, news_num, comm_num, user_group, lastdate, reg_date, signature, foto, fullname, land, icq, xfields FROM " . PREFIX . "_comments LEFT JOIN " . USERPREFIX . "_users ON " . PREFIX . "_comments.user_id=" . USERPREFIX . "_users.user_id WHERE " . PREFIX . "_comments.post_id = '$post_id' order by id DESC";
/home/dkd/Documents/upload/engine/ajax/feedback.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/feedback.php: $db->query( "SELECT name FROM " . USERPREFIX . "_users WHERE name = '" . $name . "' OR email = '" . $email . "'" );
/home/dkd/Documents/upload/engine/ajax/feedback.php: $recipient = $db->super_query( "SELECT name, email, fullname FROM " . USERPREFIX . "_users WHERE user_id='" . $recip . "' AND user_group = '1'" );
/home/dkd/Documents/upload/engine/ajax/feedback.php: $recipient = $db->super_query( "SELECT name, email, fullname FROM " . USERPREFIX . "_users WHERE user_id='" . $recip . "' AND allow_mail = '1'" );
/home/dkd/Documents/upload/engine/ajax/sitemap.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/clean.php: $db->query("TRUNCATE TABLE " . USERPREFIX . "_lostdb");
/home/dkd/Documents/upload/engine/ajax/clean.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '18', '')" );
/home/dkd/Documents/upload/engine/ajax/clean.php: $db->query("TRUNCATE TABLE " . USERPREFIX . "_pm");
/home/dkd/Documents/upload/engine/ajax/clean.php: $db->query("UPDATE " . USERPREFIX . "_users set pm_all='0', pm_unread='0'");
/home/dkd/Documents/upload/engine/ajax/clean.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '17', '')" );
/home/dkd/Documents/upload/engine/ajax/clean.php: $db->query("UPDATE " . USERPREFIX . "_users, " . PREFIX . "_post SET " . USERPREFIX . "_users.news_num = (SELECT COUNT(*) FROM " . PREFIX . "_post WHERE " . PREFIX . "_post.autor = " . USERPREFIX . "_users.name ) WHERE " . USERPREFIX . "_users.name = " . PREFIX . "_post.autor");
/home/dkd/Documents/upload/engine/ajax/clean.php: $db->query("UPDATE " . USERPREFIX . "_users, " . PREFIX . "_comments SET " . USERPREFIX . "_users.comm_num = (SELECT COUNT(*) FROM " . PREFIX . "_comments WHERE " . PREFIX . "_comments.user_id = " . USERPREFIX . "_users.user_id ) WHERE " . USERPREFIX . "_users.user_id = " . PREFIX . "_comments.user_id");
/home/dkd/Documents/upload/engine/ajax/clean.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '16', '{$_REQUEST['date']}')" );
/home/dkd/Documents/upload/engine/ajax/clean.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '15', '{$_REQUEST['date']}')" );
/home/dkd/Documents/upload/engine/ajax/pm.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/pm.php: $row = $db->super_query( "SELECT id, user, user_from FROM " . USERPREFIX . "_pm WHERE id='{$id}'" );
/home/dkd/Documents/upload/engine/ajax/pm.php: $db->query( "SELECT id FROM " . USERPREFIX . "_ignore_list WHERE user_from='{$row['user_from']}' AND user='{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/ajax/pm.php: $row_group = $db->super_query( "SELECT user_group FROM " . USERPREFIX . "_users WHERE name='{$row['user_from']}'" );
/home/dkd/Documents/upload/engine/ajax/pm.php: $db->query( "INSERT INTO " . USERPREFIX . "_ignore_list (user, user_from) values ('{$row['user']}', '{$row['user_from']}')" );
/home/dkd/Documents/upload/engine/ajax/pm.php: $row = $db->super_query( "SELECT * FROM " . USERPREFIX . "_ignore_list WHERE id='{$id}'" );
/home/dkd/Documents/upload/engine/ajax/pm.php: if ($row['id'] AND ($row['user'] == $member_id['user_id'] OR $member_id['user_group'] == 1) ) { $db->query( "DELETE FROM " . USERPREFIX . "_ignore_list WHERE id = '{$row['id']}'" ); echo $lang['ignore_del_ok']; die(); }
/home/dkd/Documents/upload/engine/ajax/templates.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '69', '{$template}/{$file}.tpl')" );
/home/dkd/Documents/upload/engine/ajax/templates.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '70', '{$file_path}/{$file_name}')" );
/home/dkd/Documents/upload/engine/ajax/deletecomments.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/deletecomments.php: $db->query( "UPDATE " . USERPREFIX . "_users set comm_num=comm_num-1 where name ='$author'" );
/home/dkd/Documents/upload/engine/ajax/poll.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/adminfunction.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/adminfunction.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '11', '')" );
/home/dkd/Documents/upload/engine/ajax/newsletter.php: $db->query ( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/newsletter.php:$result = $db->query("SELECT user_id, name, fullname FROM " . USERPREFIX . "_users WHERE {$empfanger} LIMIT ".$startfrom.",".$limit);
/home/dkd/Documents/upload/engine/ajax/newsletter.php:$result = $db->query("SELECT user_id, name, fullname FROM " . USERPREFIX . "_users LIMIT ".$startfrom.",".$limit);
/home/dkd/Documents/upload/engine/ajax/newsletter.php: $db->query("INSERT INTO " . USERPREFIX . "_pm (subj, text, user, user_from, date, pm_read, folder) values ('$title', '$message_send', '$row[user_id]', '$member_id[name]', '$time', 'no', 'inbox')");
/home/dkd/Documents/upload/engine/ajax/newsletter.php: $db->query("UPDATE " . USERPREFIX . "_users set pm_all=pm_all+1, pm_unread=pm_unread+1 where user_id='$row[user_id]'");
/home/dkd/Documents/upload/engine/ajax/newsletter.php: $db->query("SELECT email FROM " . USERPREFIX . "_users".$where." LIMIT ".$startfrom.",".$limit);
/home/dkd/Documents/upload/engine/ajax/newsletter.php: $db->query("SELECT email, name, fullname FROM " . USERPREFIX . "_users".$where." LIMIT ".$startfrom.",".$limit);
/home/dkd/Documents/upload/engine/ajax/rating.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/allvotes.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/editcomments.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/search.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/rebuild.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/vote.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/upload.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/upload.php: if ($user_group[$member_id['user_group']]['allow_admin']) $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '32', '{$news_id}')" );
/home/dkd/Documents/upload/engine/ajax/upload.php: if ($user_group[$member_id['user_group']]['allow_admin']) $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '34', '{$news_id}')" );
/home/dkd/Documents/upload/engine/ajax/upload.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '33', '{$news_id}')" );
/home/dkd/Documents/upload/engine/ajax/find_relates.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/comments.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/comments.php:$comments->query = "SELECT " . PREFIX . "_comments.id, post_id, " . PREFIX . "_comments.user_id, date, autor as gast_name, " . PREFIX . "_comments.email as gast_email, text, ip, is_register, name, " . USERPREFIX . "_users.email, news_num, comm_num, user_group, lastdate, reg_date, signature, foto, fullname, land, icq, xfields FROM " . PREFIX . "_comments LEFT JOIN " . USERPREFIX . "_users ON " . PREFIX . "_comments.user_id=" . USERPREFIX . "_users.user_id WHERE " . PREFIX . "_comments.post_id = '$news_id'" . $where_approve . " ORDER BY date " . $config['comm_msort'];
/home/dkd/Documents/upload/engine/ajax/rss.php: $db->query ( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/registration.php: $db->query ("SELECT name FROM " . USERPREFIX . "_users WHERE LOWER(name) REGEXP '[[:<:]]{$search_name}[[:>:]]' OR name = '$name'");
/home/dkd/Documents/upload/engine/ajax/registration.php:$db->query("SELECT * FROM " . USERPREFIX . "_banned");
/home/dkd/Documents/upload/engine/ajax/message.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/message.php:$row = $db->super_query( "SELECT email, name, user_id FROM " . USERPREFIX . "_users WHERE name = '{$row['autor']}'" );
/home/dkd/Documents/upload/engine/ajax/message.php:$db->query( "INSERT INTO " . USERPREFIX . "_pm (subj, text, user, user_from, date, pm_read, folder) values ('{$lang['message_pm']}', '$message', '{$row['user_id']}', '{$member_id['name']}', '$time', 'no', 'inbox')" );
/home/dkd/Documents/upload/engine/ajax/message.php:$db->query( "UPDATE " . USERPREFIX . "_users SET pm_all=pm_all+1, pm_unread=pm_unread+1 WHERE user_id='{$row['user_id']}'" );
/home/dkd/Documents/upload/engine/ajax/profile.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/profile.php:$row = $db->super_query( "SELECT * FROM " . USERPREFIX . "_users WHERE name = '{$name}'" );
/home/dkd/Documents/upload/engine/ajax/typograf.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/ajax/favorites.php: $db->query( "UPDATE " . USERPREFIX . "_users SET favorites='$favorites' WHERE user_id = '{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/ajax/favorites.php: $db->query( "UPDATE " . USERPREFIX . "_users SET favorites='$member_id[favorites]' WHERE user_id = '{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/preview.php: $db->query ( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/rss.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/download.php: $db->query ( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/print.php: $db->query( "SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC" );
/home/dkd/Documents/upload/engine/inc/dboption.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '23', '')" );
/home/dkd/Documents/upload/engine/inc/options.php: $db->query( "SELECT name FROM " . USERPREFIX . "_users WHERE email = '{$editmail}' AND user_id != '{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/inc/options.php: $sql_update = "UPDATE " . USERPREFIX . "_users SET email='$editmail', fullname='$editfullname', land='$editland', icq='$editicq', allow_mail='$edithidemail', password='$editpassword' where user_id='{$member_id['user_id']}'";
/home/dkd/Documents/upload/engine/inc/options.php: $sql_update = "UPDATE " . USERPREFIX . "_users set email='$editmail', fullname='$editfullname', land='$editland', icq='$editicq', allow_mail='$edithidemail' where user_id='{$member_id['user_id']}'";
/home/dkd/Documents/upload/engine/inc/options.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '48', '')" );
/home/dkd/Documents/upload/engine/inc/main.php: $row = $db->super_query( "SELECT COUNT(*) as count FROM " . USERPREFIX . "_users" );
/home/dkd/Documents/upload/engine/inc/main.php: $row = $db->super_query( "SELECT COUNT(*) as count FROM " . USERPREFIX . "_users where banned='yes'" );
/home/dkd/Documents/upload/engine/inc/complaint.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '22', '')" );
/home/dkd/Documents/upload/engine/inc/complaint.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '22', '')" );
/home/dkd/Documents/upload/engine/inc/editnews.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '25', '{$title}')" );
/home/dkd/Documents/upload/engine/inc/editnews.php: $row = $db->super_query( "SELECT user_id FROM " . USERPREFIX . "_users WHERE name = '{$_POST['new_author']}'" );
/home/dkd/Documents/upload/engine/inc/editnews.php: $db->query( "UPDATE " . USERPREFIX . "_users SET news_num=news_num+1 where user_id='{$row['user_id']}'" );
/home/dkd/Documents/upload/engine/inc/editnews.php: $db->query( "UPDATE " . USERPREFIX . "_users SET news_num=news_num-1 where name='$item_db[1]'" );
/home/dkd/Documents/upload/engine/inc/editnews.php: $db->query( "UPDATE " . USERPREFIX . "_users set news_num=news_num-1 where name='$item_db[1]'" );
/home/dkd/Documents/upload/engine/inc/editnews.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '26', '{$item_db[4]}')" );
/home/dkd/Documents/upload/engine/inc/videoconfig.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '78', '')" );
/home/dkd/Documents/upload/engine/inc/files.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '37', '{$image}')" );
/home/dkd/Documents/upload/engine/inc/xfields.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '73', '{$xfields[$xfieldsindex][0]}')" );
/home/dkd/Documents/upload/engine/inc/xfields.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '74', '{$editedxfield[0]}')" );
/home/dkd/Documents/upload/engine/inc/templates.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '66', '{$_REQUEST['do_template']}')" );
/home/dkd/Documents/upload/engine/inc/templates.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '67', '{$template_name}')" );
/home/dkd/Documents/upload/engine/inc/templates.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '68', '{$do_template}')" );
/home/dkd/Documents/upload/engine/inc/cmoderation.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '19', '')" );
/home/dkd/Documents/upload/engine/inc/cmoderation.php: if( $row['user_id'] ) $db->query( "UPDATE " . USERPREFIX . "_users SET comm_num=comm_num-1 where user_id='{$row['user_id']}'" );
/home/dkd/Documents/upload/engine/inc/cmoderation.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '19', '')" );
/home/dkd/Documents/upload/engine/inc/banners.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '4', '{$banner_tag}')" );
/home/dkd/Documents/upload/engine/inc/banners.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '5', '{$banner_tag}')" );
/home/dkd/Documents/upload/engine/inc/banners.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '6', '{$id}')" );
/home/dkd/Documents/upload/engine/inc/banners.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '7', '{$id}')" );
/home/dkd/Documents/upload/engine/inc/banners.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '8', '{$id}')" );
/home/dkd/Documents/upload/engine/inc/rssinform.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '53', '{$rss_tag}')" );
/home/dkd/Documents/upload/engine/inc/rssinform.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '54', '{$rss_tag}')" );
/home/dkd/Documents/upload/engine/inc/rssinform.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '55', '{$id}')" );
/home/dkd/Documents/upload/engine/inc/rssinform.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '56', '{$id}')" );
/home/dkd/Documents/upload/engine/inc/rssinform.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '57', '{$id}')" );
/home/dkd/Documents/upload/engine/inc/editvote.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '27', '{$id}')" );
/home/dkd/Documents/upload/engine/inc/editvote.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '28', '{$id}')" );
/home/dkd/Documents/upload/engine/inc/editvote.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '29', '{$id}')" );
/home/dkd/Documents/upload/engine/inc/editvote.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '30', '{$id}')" );
/home/dkd/Documents/upload/engine/inc/newsletter.php: $row = $db->super_query("SELECT COUNT(*) as count FROM " . USERPREFIX . "_users".$where);
/home/dkd/Documents/upload/engine/inc/newsletter.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '47', '{$type_send}')" );
/home/dkd/Documents/upload/engine/inc/addnews.php: $db->query( "UPDATE " . USERPREFIX . "_users set news_num=news_num+1 where user_id='{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/inc/addnews.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '1', '{$title}')" );
/home/dkd/Documents/upload/engine/inc/iptools.php: $db->query( "UPDATE " . USERPREFIX . "_users set comm_num='0' WHERE user_id ='$id'" );
/home/dkd/Documents/upload/engine/inc/iptools.php: $db->query( "SELECT * FROM " . USERPREFIX . "_users WHERE logged_ip LIKE '{$ip}%'" );
/home/dkd/Documents/upload/engine/inc/iptools.php: $db->query( "SELECT " . PREFIX . "_comments.user_id, " . PREFIX . "_comments.ip, " . USERPREFIX . "_users.comm_num, banned, user_group, reg_date, lastdate, " . USERPREFIX . "_users.name, " . USERPREFIX . "_users.news_num FROM " . PREFIX . "_comments LEFT JOIN " . USERPREFIX . "_users ON " . PREFIX . "_comments.user_id=" . USERPREFIX . "_users.user_id WHERE " . PREFIX . "_comments.ip LIKE '{$ip}%' AND " . PREFIX . "_comments.is_register = '1' AND " . USERPREFIX . "_users.name != '' GROUP BY " . PREFIX . "_comments.user_id" );
/home/dkd/Documents/upload/engine/inc/iptools.php: $row = $db->super_query( "SELECT user_id, name, logged_ip FROM " . USERPREFIX . "_users WHERE name='" . $name . "'" );
/home/dkd/Documents/upload/engine/inc/mass_static_actions.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '39', '')" );
/home/dkd/Documents/upload/engine/inc/mass_static_actions.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '40', '')" );
/home/dkd/Documents/upload/engine/inc/categories.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '12', '{$cat_name}')" );
/home/dkd/Documents/upload/engine/inc/categories.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '13', '{$catid}')" );
/home/dkd/Documents/upload/engine/inc/categories.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '13', '{$catid}')" );
/home/dkd/Documents/upload/engine/inc/categories.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '14', '{$cat_name}')" );
/home/dkd/Documents/upload/engine/inc/include/init.php: $db->query("SELECT * FROM " . USERPREFIX . "_usergroups ORDER BY id ASC");
/home/dkd/Documents/upload/engine/inc/include/init.php: $db->query("UPDATE " . USERPREFIX . "_users set hash='" . $hash . "', lastdate='{$time_now}', logged_ip='" . $_IP . "' WHERE user_id='{$member_id['user_id']}'");
/home/dkd/Documents/upload/engine/inc/include/init.php: $db->query("UPDATE " . USERPREFIX . "_users set lastdate='{$time_now}', logged_ip='" . $_IP . "' WHERE user_id='{$member_id['user_id']}'");
/home/dkd/Documents/upload/engine/inc/include/functions.inc.php: $member_id = $db->super_query( "SELECT * FROM " . USERPREFIX . "_users WHERE {$where_name} AND password='{$md5_password}'" );
/home/dkd/Documents/upload/engine/inc/include/functions.inc.php: $member_id = $db->super_query( "SELECT * FROM " . USERPREFIX . "_users WHERE user_id='$username'" );
/home/dkd/Documents/upload/engine/inc/include/functions.inc.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '{$a_id}', '{$extr}')" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $row = $db->super_query( "SELECT user_id, user_group, name, foto FROM " . USERPREFIX . "_users WHERE user_id='$id'" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '41', '{$row['name']}')" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $db->query( "DELETE FROM " . USERPREFIX . "_pm WHERE user_from = '{$row['name']}' AND folder = 'outbox'" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $db->query( "delete FROM " . USERPREFIX . "_users WHERE user_id='$id'" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $db->query( "delete FROM " . USERPREFIX . "_banned WHERE users_id='$id'" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $db->query( "delete FROM " . USERPREFIX . "_pm WHERE user='$id'" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $db->query( "UPDATE " . USERPREFIX . "_users set comm_num='0' WHERE user_id ='$id'" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '42', '{$id}')" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $row = $db->super_query( "SELECT name, user_group FROM " . USERPREFIX . "_users WHERE user_id='$id'" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $db->query( "UPDATE " . USERPREFIX . "_users SET user_group='$editlevel', time_limit='$time_limit' WHERE user_id ='$id'" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '43', '{$row['name']}')" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $row = $db->super_query( "SELECT name, user_group FROM " . USERPREFIX . "_users WHERE user_id='$id'" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '44', '{$row['name']}')" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $row = $db->super_query( "SELECT users_id, days FROM " . USERPREFIX . "_banned WHERE users_id = '$id'" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: if( ! $row['users_id'] ) $db->query( "INSERT INTO " . USERPREFIX . "_banned (users_id, descr, date, days) values ('$id', '$banned_descr', '$this_time', '$banned_date')" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: if( $row['days'] != $banned_date ) $db->query( "UPDATE " . USERPREFIX . "_banned SET descr='$banned_descr', days='$banned_date', date='$this_time' WHERE users_id = '$id'" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: else $db->query( "UPDATE " . USERPREFIX . "_banned set descr='$banned_descr' WHERE users_id = '$id'" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $db->query( "UPDATE " . USERPREFIX . "_users SET banned='yes' WHERE user_id ='$id'" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $row = $db->super_query( "SELECT name FROM " . USERPREFIX . "_users WHERE user_id='$id'" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '45', '{$row['name']}')" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $db->query( "DELETE FROM " . USERPREFIX . "_pm WHERE user='$id' AND folder = 'inbox'" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $db->query( "DELETE FROM " . USERPREFIX . "_pm WHERE user_from='{$row['name']}' AND folder = 'outbox'" );
/home/dkd/Documents/upload/engine/inc/mass_user_actions.php: $db->query( "UPDATE " . USERPREFIX . "_users SET pm_unread='0', pm_all='0' WHERE user_id ='$id'" );
/home/dkd/Documents/upload/engine/inc/search.php: $db->query("UPDATE `" . USERPREFIX . "_pm` SET `text`=REPLACE(`text`,'$find','$replace')");
/home/dkd/Documents/upload/engine/inc/search.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '58', '".htmlspecialchars("find: ".$find." replace: ".$replace, ENT_QUOTES, $config['charset'])."')" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $query_count = "SELECT COUNT(*) as count FROM " . USERPREFIX . "_users WHERE $where";
/home/dkd/Documents/upload/engine/inc/editusers.php: $db->query( "SELECT user_id, name, user_group, reg_date, lastdate, news_num, comm_num, banned FROM " . USERPREFIX . "_users WHERE {$where} ORDER BY {$order_by} LIMIT {$start_from},{$news_per_page}" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $row = $db->super_query( "SELECT name, email FROM " . USERPREFIX . "_users WHERE name = '$regusername' OR email = '$regemail'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $db->query( "INSERT INTO " . USERPREFIX . "_users (name, password, email, user_group, reg_date, lastdate, info, signature, favorites, xfields) values ('$regusername', '$regpassword', '$regemail', '$reglevel', '$add_time', '$add_time','','','','')" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '63', '{$regusername}')" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $row = $db->super_query( "SELECT user_id FROM " . USERPREFIX . "_users WHERE name = '$user'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $row = $db->super_query( "SELECT " . USERPREFIX . "_users.*, " . USERPREFIX . "_banned.days, " . USERPREFIX . "_banned.descr, " . USERPREFIX . "_banned.date as banned_date FROM " . USERPREFIX . "_users LEFT JOIN " . USERPREFIX . "_banned ON " . USERPREFIX . "_users.user_id=" . USERPREFIX . "_banned.users_id WHERE user_id = '$id'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $row = $db->super_query( "SELECT user_id, name, user_group, email FROM " . USERPREFIX . "_users WHERE user_id = '$id'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '64', '{$row['name']}')" );
/home/dkd/Documents/upload/engine/inc/editusers.php: if ( $db->num_rows( $db->query( "SELECT user_id FROM " . USERPREFIX . "_users WHERE email = '$editmail'" ) ) )
/home/dkd/Documents/upload/engine/inc/editusers.php: $db->query( "UPDATE " . USERPREFIX . "_users set foto='$foto_name' WHERE user_id='$id'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $row = $db->super_query( "SELECT foto FROM " . USERPREFIX . "_users WHERE user_id='$id'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $db->query( "UPDATE " . USERPREFIX . "_users set foto='' WHERE user_id='$id'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $sql_update = "UPDATE " . USERPREFIX . "_users set user_group='$editlevel', banned='$banned', icq='$editicq', land='$editland', info='$editinfo', signature='$editsignature', email='$editmail', fullname='$editfullname', time_limit='$time_limit', xfields='$filecontents'";
/home/dkd/Documents/upload/engine/inc/editusers.php: $row = $db->super_query( "SELECT user_id FROM " . USERPREFIX . "_users WHERE name='$editlogin'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $row = $db->super_query( "SELECT name FROM " . USERPREFIX . "_users WHERE user_id='$id'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $db->query( "UPDATE " . USERPREFIX . "_pm SET user_from='$editlogin' WHERE user_from='{$row['name']}'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $row = $db->super_query( "SELECT users_id, days FROM " . USERPREFIX . "_banned WHERE users_id = '$id'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: if( ! $row['users_id'] ) $db->query( "INSERT INTO " . USERPREFIX . "_banned (users_id, descr, date, days) values ('$id', '$banned_descr', '$this_time', '$banned_date')" );
/home/dkd/Documents/upload/engine/inc/editusers.php: if( $row['days'] != $banned_date ) $db->query( "UPDATE " . USERPREFIX . "_banned set descr='$banned_descr', days='$banned_date', date='$this_time' WHERE users_id = '$id'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: else $db->query( "UPDATE " . USERPREFIX . "_banned set descr='$banned_descr' WHERE users_id = '$id'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $db->query( "DELETE FROM " . USERPREFIX . "_banned WHERE users_id = '$id'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $db->query( "UPDATE " . USERPREFIX . "_users set comm_num='0' where user_id ='$id'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $row = $db->super_query( "SELECT user_id, user_group, name, foto FROM " . USERPREFIX . "_users WHERE user_id='$id'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $db->query( "DELETE FROM " . USERPREFIX . "_pm WHERE user_from = '{$row['name']}' AND folder = 'outbox'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $db->query( "delete FROM " . USERPREFIX . "_users WHERE user_id='$id'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $db->query( "delete FROM " . USERPREFIX . "_banned WHERE users_id='$id'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $db->query( "delete FROM " . USERPREFIX . "_pm WHERE user='$id'" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '65', '{$row['name']}')" );
/home/dkd/Documents/upload/engine/inc/editusers.php: $db->query( "UPDATE " . USERPREFIX . "_users set comm_num='0' WHERE user_id ='$id'" );
/home/dkd/Documents/upload/engine/inc/static.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '59', '{$name}')" );
/home/dkd/Documents/upload/engine/inc/static.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '60', 'dle-rules-page')" );
/home/dkd/Documents/upload/engine/inc/static.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '60', '{$name}')" );
/home/dkd/Documents/upload/engine/inc/rebuild.php:$db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '49', '')" );
/home/dkd/Documents/upload/engine/inc/wordfilter.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '79', '".htmlspecialchars($word_find, ENT_QUOTES, $config['charset'])."')" );
/home/dkd/Documents/upload/engine/inc/wordfilter.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '80', '')" );
/home/dkd/Documents/upload/engine/inc/wordfilter.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '81', '".htmlspecialchars($word_find, ENT_QUOTES, $config['charset'])."')" );
/home/dkd/Documents/upload/engine/inc/dumper.php:$db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '24', '')" );
/home/dkd/Documents/upload/engine/inc/userfields.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '71', '{$xfields[$xfieldsindex][0]}')" );
/home/dkd/Documents/upload/engine/inc/userfields.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '72', '{$editedxfield[0]}')" );
/home/dkd/Documents/upload/engine/inc/massactions.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '46', '')" );
/home/dkd/Documents/upload/engine/inc/massactions.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '26', '".$db->safesql($row['title'])."')" );
/home/dkd/Documents/upload/engine/inc/massactions.php: $db->query( "UPDATE " . USERPREFIX . "_users set news_num=news_num-1 where name='{$row['autor']}'" );
/home/dkd/Documents/upload/engine/inc/massactions.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '46', '')" );
/home/dkd/Documents/upload/engine/inc/massactions.php: $row = $db->super_query( "SELECT user_id, name FROM " . USERPREFIX . "_users WHERE name = '{$new_author}'" );
/home/dkd/Documents/upload/engine/inc/massactions.php: $db->query( "UPDATE " . USERPREFIX . "_users SET news_num=news_num+1 WHERE user_id='{$row['user_id']}'" );
/home/dkd/Documents/upload/engine/inc/massactions.php: $db->query( "UPDATE " . USERPREFIX . "_users SET news_num=news_num-1 WHERE name='{$old['autor']}'" );
/home/dkd/Documents/upload/engine/inc/massactions.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '46', '')" );
/home/dkd/Documents/upload/engine/inc/massactions.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '46', '')" );
/home/dkd/Documents/upload/engine/inc/massactions.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '46', '')" );
/home/dkd/Documents/upload/engine/inc/comments.php: $db->query( "UPDATE " . USERPREFIX . "_users SET comm_num=comm_num-{$row['count']} where user_id='{$row['user_id']}'" );
/home/dkd/Documents/upload/engine/inc/comments.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '20', '$id')" );
/home/dkd/Documents/upload/engine/inc/comments.php: $db->query( "UPDATE " . USERPREFIX . "_users SET comm_num=comm_num-1 where name ='$author'" );
/home/dkd/Documents/upload/engine/inc/comments.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '21', '')" );
/home/dkd/Documents/upload/engine/inc/rss.php: $db->query( "UPDATE " . USERPREFIX . "_users set news_num=news_num+1 where user_id='{$member_id['user_id']}'" );
/home/dkd/Documents/upload/engine/inc/rss.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '1', '{$title}')" );
/home/dkd/Documents/upload/engine/inc/rss.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '51', '{$url}')" );
/home/dkd/Documents/upload/engine/inc/rss.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '52', '{$url}')" );
/home/dkd/Documents/upload/engine/inc/rss.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '50', '{$id}')" );
/home/dkd/Documents/upload/engine/inc/usergroup.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '75', '{$id}')" );
/home/dkd/Documents/upload/engine/inc/usergroup.php: $row = $db->super_query( "SELECT count(*) as count FROM " . USERPREFIX . "_users WHERE user_group='$id'" );
/home/dkd/Documents/upload/engine/inc/usergroup.php: $db->query( "DELETE FROM " . USERPREFIX . "_usergroups WHERE id = '$id'" );
/home/dkd/Documents/upload/engine/inc/usergroup.php: $db->query( "UPDATE " . USERPREFIX . "_users set user_group='$grouplevel' WHERE user_group='$id'" );
/home/dkd/Documents/upload/engine/inc/usergroup.php: $db->query( "DELETE FROM " . USERPREFIX . "_usergroups WHERE id = '$id'" );
/home/dkd/Documents/upload/engine/inc/usergroup.php: $db->query( "INSERT INTO " . USERPREFIX . "_usergroups (group_name, allow_cats, allow_adds, cat_add, allow_admin, allow_addc, allow_editc, allow_delc, edit_allc, del_allc, moderation, allow_all_edit, allow_edit, allow_pm, max_pm, max_foto, allow_files, allow_hide, allow_short, time_limit, rid, allow_fixed, allow_feed, allow_search, allow_poll, allow_main, captcha, icon, allow_modc, allow_rating, allow_offline, allow_image_upload, allow_file_upload, allow_signature, allow_url, news_sec_code, allow_image, max_signature, max_info, admin_addnews, admin_editnews, admin_comments, admin_categories, admin_editusers, admin_wordfilter, admin_xfields, admin_userfields, admin_static, admin_editvote, admin_newsletter, admin_blockip, admin_banners, admin_rss, admin_iptools, admin_rssinform, admin_googlemap, allow_html, group_prefix, group_suffix, allow_subscribe, allow_image_size, cat_allow_addnews, flood_news, max_day_news, force_leech, edit_limit, captcha_pm, max_pm_day, max_mail_day, admin_tagscloud, allow_vote, admin_complaint, news_question, comments_question, max_comment_day, max_images, max_files, disable_news_captcha, disable_comments_captcha, pm_question, captcha_feedback, feedback_question, files_type, max_file_size, files_max_speed) values ('$group_name', '$allow_cats', '$allow_adds', '$cat_add', '$allow_admin', '$allow_addc', '$allow_editc', '$allow_delc', '$edit_allc', '$del_allc', '$moderation', '$allow_all_edit', '$allow_edit', '$allow_pm', '$max_pm', '$max_foto', '$allow_files', '$allow_hide', '$allow_short', '$time_limit', '$rid', '$allow_fixed', '$allow_feed', '$allow_search', '$allow_poll', '$allow_main', '$captcha', '$group_icon', '$allow_modc', '$allow_rating', '$allow_offline', '$allow_image_upload', '$allow_file_upload', '$allow_signature', '$allow_url', '$news_sec_code', '$allow_image', '$max_signature', '$max_info', '$admin_addnews', '$admin_editnews', '$admin_comments', '$admin_categories', '$admin_editusers', '$admin_wordfilter', '$admin_xfields', '$admin_userfields', '$admin_static', '$admin_editvote', '$admin_newsletter', '$admin_blockip', '$admin_banners', '$admin_rss', '$admin_iptools', '$admin_rssinform', '$admin_googlemap', '$allow_html', '$group_prefix', '$group_suffix', '$allow_subscribe', '$allow_image_size', '$cat_allow_addnews', '$flood_news', '$max_day_news', '$force_leech', '$edit_limit', '$captcha_pm', '$max_pm_day', '$max_mail_day', '$admin_tagscloud', '$allow_vote', '$admin_complaint', '$news_question', '$comments_question', '$max_comment_day', '$max_images', '$max_files', '$disable_news_captcha', '$disable_comments_captcha', '$pm_question', '$captcha_feedback', '$feedback_question', '$files_type', '$max_file_size', '$files_max_speed')" );
/home/dkd/Documents/upload/engine/inc/usergroup.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '76', '{$group_name}')" );
/home/dkd/Documents/upload/engine/inc/usergroup.php: $db->query( "UPDATE " . USERPREFIX . "_usergroups SET group_name='$group_name', allow_cats='$allow_cats', allow_adds='$allow_adds', cat_add='$cat_add', allow_admin='$allow_admin', allow_addc='$allow_addc', allow_editc='$allow_editc', allow_delc='$allow_delc', edit_allc='$edit_allc', del_allc='$del_allc', moderation='$moderation', allow_all_edit='$allow_all_edit', allow_edit='$allow_edit', allow_pm='$allow_pm', max_pm='$max_pm', max_foto='$max_foto', allow_files='$allow_files', allow_hide='$allow_hide', allow_short='$allow_short', time_limit='$time_limit', rid='$rid', allow_fixed='$allow_fixed', allow_feed='$allow_feed', allow_search='$allow_search', allow_poll='$allow_poll', allow_main='$allow_main', captcha='$captcha', icon='$group_icon', allow_modc='$allow_modc', allow_rating='$allow_rating', allow_offline='$allow_offline', allow_image_upload='$allow_image_upload', allow_file_upload='$allow_file_upload', allow_signature='$allow_signature', allow_url='$allow_url', news_sec_code='$news_sec_code', allow_image='$allow_image', max_signature='$max_signature', max_info='$max_info', admin_addnews='$admin_addnews', admin_editnews='$admin_editnews', admin_comments='$admin_comments', admin_categories='$admin_categories', admin_editusers='$admin_editusers', admin_wordfilter='$admin_wordfilter', admin_xfields='$admin_xfields', admin_userfields='$admin_userfields', admin_static='$admin_static', admin_editvote='$admin_editvote', admin_newsletter='$admin_newsletter', admin_blockip='$admin_blockip', admin_banners='$admin_banners', admin_rss='$admin_rss', admin_iptools='$admin_iptools', admin_rssinform='$admin_rssinform', admin_googlemap='$admin_googlemap', allow_html='$allow_html', group_prefix='$group_prefix', group_suffix='$group_suffix', allow_subscribe='$allow_subscribe', allow_image_size='$allow_image_size', cat_allow_addnews='$cat_allow_addnews', flood_news='$flood_news', max_day_news='$max_day_news', force_leech='$force_leech', edit_limit='$edit_limit', captcha_pm='$captcha_pm', max_pm_day='$max_pm_day', max_mail_day='$max_mail_day', admin_tagscloud='$admin_tagscloud', allow_vote='$allow_vote', admin_complaint='$admin_complaint', news_question='$news_question', comments_question='$comments_question', max_comment_day='$max_comment_day', max_images='$max_images', max_files='$max_files', disable_news_captcha='$disable_news_captcha', disable_comments_captcha='$disable_comments_captcha', pm_question='$pm_question', captcha_feedback='$captcha_feedback', feedback_question='$feedback_question', files_type='$files_type', max_file_size='$max_file_size', files_max_speed='$files_max_speed' WHERE id='{$id}'" );
/home/dkd/Documents/upload/engine/inc/usergroup.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '77', '{$group_name}')" );
/home/dkd/Documents/upload/engine/inc/usergroup.php: $db->query( "SELECT user_group, count(*) as count FROM " . USERPREFIX . "_users GROUP BY user_group" );
/home/dkd/Documents/upload/engine/inc/tagscloud.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '61', '{$name}')" );
/home/dkd/Documents/upload/engine/inc/tagscloud.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '61', '{$_GET['name']}')" );
/home/dkd/Documents/upload/engine/inc/tagscloud.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '62', '{$_GET['oldname']} to: {$_GET['newname']}')" );
/home/dkd/Documents/upload/engine/inc/question.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '84', '".htmlspecialchars($question, ENT_QUOTES, $config['charset'])."')" );
/home/dkd/Documents/upload/engine/inc/question.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '83', '".htmlspecialchars($question, ENT_QUOTES, $config['charset'])."')" );
/home/dkd/Documents/upload/engine/inc/question.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '85', '{$id}')" );
/home/dkd/Documents/upload/engine/inc/email.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '31', '')" );
/home/dkd/Documents/upload/engine/inc/addvote.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '2', '{$title}')" );
/home/dkd/Documents/upload/engine/inc/addvote.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '3', '{$title}')" );
/home/dkd/Documents/upload/engine/inc/blockip.php: $db->query( "INSERT INTO " . USERPREFIX . "_banned (descr, date, days, ip) values ('$banned_descr', '$this_time', '$days', '$ip_add')" );
/home/dkd/Documents/upload/engine/inc/blockip.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '9', '{$ip_add}')" );
/home/dkd/Documents/upload/engine/inc/blockip.php: $db->query( "DELETE FROM " . USERPREFIX . "_banned WHERE id = '$id'" );
/home/dkd/Documents/upload/engine/inc/blockip.php: $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '10', '')" );
/home/dkd/Documents/upload/engine/inc/blockip.php:$db->query( "SELECT * FROM " . USERPREFIX . "_banned WHERE users_id = '0' ORDER BY id DESC" );
/home/dkd/Documents/upload/engine/inc/googlemap.php: if(defined('AUTOMODE')) die("done"); else $db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '38', '')" );
/home/dkd/Documents/upload/engine/inc/logs.php:$db->query( "DELETE FROM " . USERPREFIX . "_admin_logs WHERE date < '{$thisdate}'" );
/home/dkd/Documents/upload/engine/inc/logs.php: $db->query( "SELECT SQL_CALC_FOUND_ROWS * FROM " . USERPREFIX . "_admin_logs ORDER BY date DESC LIMIT {$start_from},{$news_per_page}" );
/home/dkd/Documents/upload/engine/api/api.class.php: $row = $this->load_table(USERPREFIX."_users", $select_list, "user_id = '$id'");
/home/dkd/Documents/upload/engine/api/api.class.php: $row = $this->load_table(USERPREFIX."_users", $select_list, "name = '$name'");
/home/dkd/Documents/upload/engine/api/api.class.php: $row = $this->load_table(USERPREFIX."_users", $select_list, "email = '$email'");
/home/dkd/Documents/upload/engine/api/api.class.php: $data = $this->load_table(USERPREFIX."_users", $select_list, "user_group = '$group'", true, 0, $limit);
/home/dkd/Documents/upload/engine/api/api.class.php: $data = $this->load_table(USERPREFIX."_users", $select_list, $condition, true, 0, $limit);
/home/dkd/Documents/upload/engine/api/api.class.php: $count_arr = $this->load_table(USERPREFIX."_users", "count(user_id) as count", "name = '$new_name'");
/home/dkd/Documents/upload/engine/api/api.class.php: $old_name_arr = $this->load_table(USERPREFIX."_users", "name", "user_id = '$user_id'");
/home/dkd/Documents/upload/engine/api/api.class.php: $this->db->query( "UPDATE " . USERPREFIX . "_pm SET user_from='$new_name' WHERE user_from='{$old_name}'" );
/home/dkd/Documents/upload/engine/api/api.class.php: $this->db->query( "update " . USERPREFIX . "_users set name = '$new_name' where user_id = '$user_id'" );
/home/dkd/Documents/upload/engine/api/api.class.php: $this->db->query( "update " . USERPREFIX . "_users set password = '$new_password' where user_id = '$user_id'" );
/home/dkd/Documents/upload/engine/api/api.class.php: $email_exist_arr = $this->load_table(USERPREFIX."_users", "count(user_id) as count", "email = '$new_email'");
/home/dkd/Documents/upload/engine/api/api.class.php: $q = $this->db->query( "update " . USERPREFIX . "_users set email = '$new_email' where user_id = '$user_id'" );
/home/dkd/Documents/upload/engine/api/api.class.php: $this->db->query( "update " . USERPREFIX . "_users set user_group = '$new_group' where user_id = '$user_id'" );
/home/dkd/Documents/upload/engine/api/api.class.php: $arr = $this->load_table(USERPREFIX."_users", "user_id", "name = '$login' AND password = '$password'");
/home/dkd/Documents/upload/engine/api/api.class.php: $login_exist_arr = $this->load_table(USERPREFIX."_users", "count(user_id) as count", "name = '$login'");
/home/dkd/Documents/upload/engine/api/api.class.php: $email_exist_arr = $this->load_table(USERPREFIX."_users", "count(user_id) as count", "email = '$email'");
/home/dkd/Documents/upload/engine/api/api.class.php: $q = $this->db->query( "insert into " . USERPREFIX . "_users (email, password, name, user_group, reg_date) VALUES ('$email', '$password', '$login', '$group', '$now')" );
/home/dkd/Documents/upload/engine/api/api.class.php: $count_arr = $this->load_table(USERPREFIX."_users", "count(user_id) as count", "user_id = '$user_id'");
/home/dkd/Documents/upload/engine/api/api.class.php: $this->db->query( "update " . USERPREFIX . "_users set pm_unread = pm_unread + 1, pm_all = pm_all+1 where user_id = '$user_id'" );
/home/dkd/Documents/upload/engine/api/api.class.php: $row = $this->db->super_query('SELECT group_name FROM '.USERPREFIX.'_usergroups WHERE id = '.intval($group)); |