Форум программистов, компьютерный форум, киберфорум
DataLife Engine (DLE)
Войти
Регистрация
Восстановить пароль
Блоги Сообщество Поиск Заказать работу  
 
Рейтинг 4.56/9: Рейтинг темы: голосов - 9, средняя оценка - 4.56
грОмотей
 Аватар для maxvel0007
239 / 175 / 17
Регистрация: 01.04.2011
Сообщений: 1,435

Объединение аватара не двух сайтах

23.05.2013, 10:53. Показов 1846. Ответов 14
Метки нет (Все метки)

Студворк — интернет-сервис помощи студентам
Всем привет, кто сталкивался с единой регистрацией на DLE поймут что мне требуется сразу...
По такому же примеру мне нужно объединить вывов аватара пользователя...

Кому ещё известны префиксы для объединения пишите, всё важно и интерестно )))
0
Programming
Эксперт
39485 / 9562 / 3019
Регистрация: 12.04.2006
Сообщений: 41,671
Блог
23.05.2013, 10:53
Ответы с готовыми решениями:

Определить объединение из двух полей Первое поле - массив из двух байт, второе - слово
Помогите написать программу( лучше с комментариями чтобы разобраться) Определить объединение из двух полей Первое поле - массив из двух...

Определить объединение двух полей. Первое поле – массив из двух байт, второе – слово
Помогите написать программу( лучше с комментариями чтобы разобраться) Определить объединение из двух полей Первое поле - массив из двух...

Определить объединение из двух полей. Первое поле - массив из двух байт, второе - слово
Определить объединение из двух полей. Первое поле - массив из двух байт, второе - слово. Ввести x в диапазоне от 1 до 15. Вычислить целое...

14
 Аватар для crautcher
2450 / 2301 / 597
Регистрация: 27.05.2011
Сообщений: 7,845
23.05.2013, 11:31
сайты на разных машинах лежат?
0
грОмотей
 Аватар для maxvel0007
239 / 175 / 17
Регистрация: 01.04.2011
Сообщений: 1,435
23.05.2013, 12:27  [ТС]
Цитата Сообщение от crautcher Посмотреть сообщение
сайты на разных машинах лежат?
Иденьтичные...
0
 Аватар для crautcher
2450 / 2301 / 597
Регистрация: 27.05.2011
Сообщений: 7,845
23.05.2013, 12:38
Цитата Сообщение от maxvel0007 Посмотреть сообщение
Иденьтичные...
это, я так понимаю, значит нет.
Надо найти модуль отвечающий за отправку аватара на хостинге, где нужно изменить загрузку и подправить на отправку файлу другого сайта. Возможно немного подпилить сессию надо.
0
грОмотей
 Аватар для maxvel0007
239 / 175 / 17
Регистрация: 01.04.2011
Сообщений: 1,435
23.05.2013, 13:03  [ТС]
Цитата Сообщение от crautcher Посмотреть сообщение
это, я так понимаю, значит нет.
Одлин и тот же скрипт... Ты не правильно понял, Иденьтичные, значение одинаковых...

По этому примеру надо сделать: http://dle-news.ru/tips/152-ed... jtakh.html
0
 Аватар для crautcher
2450 / 2301 / 597
Регистрация: 27.05.2011
Сообщений: 7,845
23.05.2013, 13:09
Цитата Сообщение от maxvel0007 Посмотреть сообщение
Ты не правильно понял, Иденьтичные, значение одинаковых...
какие значения, тебя о чем спросили?
0
грОмотей
 Аватар для maxvel0007
239 / 175 / 17
Регистрация: 01.04.2011
Сообщений: 1,435
23.05.2013, 14:29  [ТС]
Хм... смотри, вот префикс
HTML5
1
(define ("USERPREFIX", "site");)
для объединения пользователей, а мне нужен префикс который объединит опросы и вывод аватара пользователей, переформулирую: как сделать на сайте запрос для вывода аватара из другой БД ??

Или ещё раз переформулирую, мне нужный префиксы каторые тебе известны, если вообще известны ))
0
 Аватар для crautcher
2450 / 2301 / 597
Регистрация: 27.05.2011
Сообщений: 7,845
23.05.2013, 15:17
Походу понял, у тебя сейчас таблица _images , _vote и _vote_result для каждого сайта свои, а ты хочешь сделать одни?
0
грОмотей
 Аватар для maxvel0007
239 / 175 / 17
Регистрация: 01.04.2011
Сообщений: 1,435
24.05.2013, 13:46  [ТС]
[quote=crautcher;4602984Для каждого сайта свои...[/quote]
Да, да, да... В правильном направлении мыслишь )) Так у меня авторизация сделана, а теперь мне нужно сделать опрос и аватары пользователей...
0
 Аватар для crautcher
2450 / 2301 / 597
Регистрация: 27.05.2011
Сообщений: 7,845
24.05.2013, 14:02
найди все обращения к "_images"
Кликните здесь для просмотра всего текста
Bash
1
2
3
4
5
6
7
grep '_images' /home/dkd/Documents/upload/engine/
 
 
/home/dkd/Documents/upload/engine/classes/uploads/upload.class.php:         if( $this->area != "template" AND $user_group[$member_id['user_group']]['max_images'] ) {
/home/dkd/Documents/upload/engine/classes/uploads/upload.class.php:             $row = $db->super_query( "SELECT images  FROM " . PREFIX . "_images WHERE author = '{$this->author}' AND news_id = '{$this->news_id}'" );
/home/dkd/Documents/upload/engine/classes/uploads/upload.class.php:             if ($row['images']) $count_images = count(explode( "|||", $row['images'] )); else $count_images = false;        
...

по дефолту всезде подставляется обычный префикс
PHP
1
$row = $db->super_query( "SELECT images  FROM " . PREFIX . "_images WHERE author = '{$this->author}' AND news_id = '{$this->news_id}'" );
замени во всех местах в коде префикс на юзерпрефикс и переименуй таблицу
PHP
1
$row = $db->super_query( "SELECT images  FROM " . USERPREFIX . "_images WHERE author = '{$this->author}' AND news_id = '{$this->news_id}'" );
0
грОмотей
 Аватар для maxvel0007
239 / 175 / 17
Регистрация: 01.04.2011
Сообщений: 1,435
24.05.2013, 17:32  [ТС]
Цитата Сообщение от crautcher Посмотреть сообщение
и переименуй таблицу
А вот тут я не понял тебя, какую и на что переменовать ??
0
 Аватар для crautcher
2450 / 2301 / 597
Регистрация: 27.05.2011
Сообщений: 7,845
24.05.2013, 17:36
ну если у тебя нету таблицы для хранения инфы о аватарках с юзерпрефиксом
0
грОмотей
 Аватар для maxvel0007
239 / 175 / 17
Регистрация: 01.04.2011
Сообщений: 1,435
24.05.2013, 17:44  [ТС]
Цитата Сообщение от crautcher Посмотреть сообщение
ну если у тебя нету таблицы для хранения инфы о аватарках с юзерпрефиксом
У меня 4 таблици: новости: fb_, кино: kino_ и тройная база dle_ (в ней все перечисленные базы)
Сразу вопрос, какие базы имеют префикс userprefix ??
P.S. единую регистрация подключал на новостной сайт (новости: fb_)
0
 Аватар для crautcher
2450 / 2301 / 597
Регистрация: 27.05.2011
Сообщений: 7,845
24.05.2013, 17:52
Цитата Сообщение от maxvel0007 Посмотреть сообщение
Сразу вопрос, какие базы имеют префикс userprefix ??
ну смотри я грепанул все строки всех файлов движка на содержание USERPREFIX , смотри в логе к каким таблицам обращается с ним:
Кликните здесь для просмотра всего текста
Bash
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));


Добавлено через 2 минуты
следовательно все остальные он юзает обычный префикс - третьего нету
0
грОмотей
 Аватар для maxvel0007
239 / 175 / 17
Регистрация: 01.04.2011
Сообщений: 1,435
25.05.2013, 10:30  [ТС]
Цитата Сообщение от crautcher Посмотреть сообщение
ну смотри я грепанул все строки всех файлов движка на содержание USERPREFIX , смотри в логе к каким таблицам обращается с ним:
Не, ты меня не так понял, попробую переформулировать: в каком файле и что изминить что бы аватар выводился только в login.tpl ??

А где лог посмотреть можно ??

Добавлено через 16 часов 25 минут
Что то ни фига не получается, фото по умолчанию остаётсяя

HTML5
1
www/engine/classes/uploads/upload.class.php
Поменял все префиксы с направлением на _images, в итоге не чего (( Из чего следует что не он отвечает за вывод аватара в login.tpl
0
Надоела реклама? Зарегистрируйтесь и она исчезнет полностью.
inter-admin
Эксперт
29715 / 6470 / 2152
Регистрация: 06.03.2009
Сообщений: 28,500
Блог
25.05.2013, 10:30
Помогаю со студенческими работами здесь

Объявить объединение из двух структур и структуру из двух объединений
Объявить объединение из двух структур и структуру из двух объединений. Заполнить значениями, вывести на экран.

Объединение двух векторов в матрицу, состоящую из двух столбцов
Помогите очередному студенту! Есть задание: Объединение двух векторов в матрицу, состоящую из двух столбцов. Реализация:...

один № телефона на двух сайтах
Друзья,возникла необходимость сделать сайт,но № контактного телефона хочу разместить такой же, какой на другом моем сайте.Вопрос:не...

Дублирование новостей на двух сайтах компании с разными доменами
&lt;p&gt;У компании несколько сайтов. Но основная проблема в том, что шеф поручил одному редактору ставить новости в одинаковом виде на двух...

Как интегрировать друг с другом две формы одинаковые бронирования на двух разных сайтах?
Есть два разных сайта. Первый на Wordpress, второй нет. Нужно форму бронирования, которая имеется на первом сайте, что на Wordpress,...


Искать еще темы с ответами

Или воспользуйтесь поиском по форуму:
15
Ответ Создать тему
Новые блоги и статьи
SDL3 для Web (WebAssembly): Реализация движения на Box2D v3 - трение и коллизии с повёрнутыми стенами
8Observer8 20.02.2026
Содержание блога Box2D позволяет легко создать главного героя, который не проходит сквозь стены и перемещается с заданным трением о препятствия, которые можно располагать под углом, как верхнее. . .
Конвертировать закладки radiotray-ng в m3u-плейлист
damix 19.02.2026
Это можно сделать скриптом для PowerShell. Использование . \СonvertRadiotrayToM3U. ps1 <path_to_bookmarks. json> Рядом с файлом bookmarks. json появится файл bookmarks. m3u с результатом. # Check if. . .
Семь CDC на одном интерфейсе: 5 U[S]ARTов, 1 CAN и 1 SSI
Eddy_Em 18.02.2026
Постепенно допиливаю свою "многоинтерфейсную плату". Выглядит вот так: https:/ / www. cyberforum. ru/ blog_attachment. php?attachmentid=11617&stc=1&d=1771445347 Основана на STM32F303RBT6. На борту пять. . .
Камера Toupcam IUA500KMA
Eddy_Em 12.02.2026
Т. к. у всяких "хикроботов" слишком уж мелкий пиксель, для подсмотра в ESPriF они вообще плохо годятся: уже 14 величину можно рассмотреть еле-еле лишь на экспозициях под 3 секунды (а то и больше),. . .
И ясному Солнцу
zbw 12.02.2026
И ясному Солнцу, и светлой Луне. В мире покоя нет и люди не могут жить в тишине. А жить им немного лет.
«Знание-Сила»
zbw 12.02.2026
«Знание-Сила» «Время-Деньги» «Деньги -Пуля»
SDL3 для Web (WebAssembly): Подключение Box2D v3, физика и отрисовка коллайдеров
8Observer8 12.02.2026
Содержание блога Box2D - это библиотека для 2D физики для анимаций и игр. С её помощью можно определять были ли коллизии между конкретными объектами и вызывать обработчики событий столкновения. . . .
SDL3 для Web (WebAssembly): Загрузка PNG с прозрачным фоном с помощью SDL_LoadPNG (без SDL3_image)
8Observer8 11.02.2026
Содержание блога Библиотека SDL3 содержит встроенные инструменты для базовой работы с изображениями - без использования библиотеки SDL3_image. Пошагово создадим проект для загрузки изображения. . .
КиберФорум - форум программистов, компьютерный форум, программирование
Powered by vBulletin
Copyright ©2000 - 2026, CyberForum.ru