01.<?php
02. $result = $cachedb->get_results("SELECT ".DB_PREFIX."videos.title,".DB_PREFIX."videos.id as
03.
04.vid,".DB_PREFIX."videos.thumb,".DB_PREFIX."videos.duration,".DB_PREFIX."users.name, ".DB_PREFIX."users.id as owner FROM
05.
06.".DB_PREFIX."videos LEFT JOIN ".DB_PREFIX."users ON ".DB_PREFIX."videos.user_id = ".DB_PREFIX."users.id where
07.
08.".DB_PREFIX."videos.category ='".$video->category."' and ".DB_PREFIX."videos.id <> '".$video->id."' ORDER BY ".DB_PREFIX."videos.id DESC
09.
10.limit 0,".get_option('related-nr')." ");
11.if ($result) {
12. foreach ($result as $related) {
13.
14.echo '
15. <li data-id="'.$related->vid.'" class="item-post">
16. <div class="inner">
17.
18. <div class="thumb">
19. <a class="clip-link" data-id="'.$related->vid.'" title="'.stripslashes($related->title).'" href="'.video_url($related->vid ,
20.
21.$related->title).'">
22. <span class="clip">
23. <img src="'.thumb_fix($related->thumb, true, 100, 64).'" alt="'.stripslashes($related->title).'"
24.
25./><span class="vertical-align"></span>
26. </span>
27. <span class="timer">'.video_time($related->duration).'</span>
28. <span class="overlay"></span>
29. </a>
30. </div>
31. <div class="data">
32. <span class="title"><a href="'.video_url($related->vid , $related->title).'"
33.
34.rel="bookmark" title="'.stripslashes($related->title).'">'._cut(_html($related->title),54 ).'</a></span>
35.
36. <span class="usermeta">
37. '._lang('by').' <a href="'.profile_url($related->owner, $related-
38.
39.>name).'"> '._html($related->name).' </a></span>
40. </span>
41. </div>
42. </div>
43. </li>
44.
45. ';
46. }
47.}
48.
49.?>
Load balance : Server 00
