Commit | Line | Data |
---|---|---|
e586807d H |
1 | <?php |
2 | function smarty_function_get_movement($params,&$smarty) { | |
3 | global $db; | |
4 | ||
5 | if (is_numeric($params['user_id'])) { | |
6 | $user_id=$params['user_id']; | |
7 | } | |
8 | if (is_numeric($params['listing_amount'])) { | |
9 | $listing_amount=$params['listing_amount']; | |
10 | } | |
11 | else $listing_amount=DEFAULT_LISTING_AMOUNT; | |
12 | if (is_numeric($params['offset'])) { | |
13 | $offset=$params['offset']; | |
14 | } | |
15 | else $offset=0; | |
16 | ||
17 | if ($user_id) { | |
18 | $q="select * from node_access left join nodes on node_access.node_id=nodes.node_id where user_id='$user_id' and nodes.node_system_access='public' order by last_visit desc limit $offset,$listing_amount"; | |
19 | $set=$db->query($q); | |
20 | while ($set->next()) { | |
21 | $array[]=$set->getRecord(); | |
22 | } | |
23 | $smarty->assign('get_movement',$array); | |
24 | return false; | |
25 | } | |
26 | ||
27 | } | |
28 | ?> |