| |
1 |
1 |
<?xml version="1.0"?> |
| |
2 |
2 |
<queryset> |
| |
3 |
3 |
|
| |
4 |
|
<fullquery name="callback::MergePackageUser::impl::forums.upd_poster"> |
| |
|
4 |
<fullquery name="callback::merge::MergePackageUser::impl::forums.upd_poster"> |
| |
5 |
5 |
<querytext> |
| |
6 |
6 |
update forums_messages |
| |
7 |
7 |
set last_poster = :to_user_id |
| |
8 |
8 |
where last_poster = :from_user_id |
| |
9 |
9 |
</querytext> |
| |
10 |
10 |
</fullquery> |
| |
11 |
11 |
|
| |
12 |
|
<fullquery name="callback::MergePackageUser::impl::forums.upd_user_id"> |
| |
|
12 |
<fullquery name="callback::merge::MergePackageUser::impl::forums.upd_user_id"> |
| |
13 |
13 |
<querytext> |
| |
14 |
14 |
update forums_messages |
| |
15 |
15 |
set user_id = :to_user_id |
| |
16 |
16 |
where user_id = :from_user_id |
| |
17 |
17 |
</querytext> |
| |
18 |
18 |
</fullquery> |
| |
19 |
19 |
|
| |
20 |
|
<fullquery name="callback::MergeShowUserInfo::impl::forums.sel_user_id"> |
| |
|
20 |
<fullquery name="callback::merge::MergeShowUserInfo::impl::forums.sel_user_id"> |
| |
21 |
21 |
<querytext> |
| |
22 |
22 |
select message_id, subject |
| |
23 |
23 |
from forums_messages |
| |
24 |
24 |
where user_id = :user_id |
| |
25 |
25 |
</querytext> |
| |
26 |
26 |
</fullquery> |
| |
27 |
27 |
|
| |
28 |
|
<fullquery name="callback::MergeShowUserInfo::impl::forums.sel_poster"> |
| |
|
28 |
<fullquery name="callback::merge::MergeShowUserInfo::impl::forums.sel_poster"> |
| |
29 |
29 |
<querytext> |
| |
30 |
30 |
select message_id, subject |
| |
31 |
31 |
from forums_messages |
| |
32 |
32 |
where last_poster = :user_id |
| |
33 |
33 |
</querytext> |
| |
34 |
34 |
</fullquery> |
| |
35 |
35 |
|
| |
36 |
36 |
</queryset> |
