PageRenderTime 37ms CodeModel.GetById 24ms RepoModel.GetById 0ms app.codeStats 1ms

/userbox/functions_autotag.inc

https://bitbucket.org/tsuchi/box
PHP | 2627 lines | 1969 code | 360 blank | 298 comment | 198 complexity | fbd91969d42392e2e30b571895a3f4a9 MD5 | raw file
Possible License(s): AGPL-1.0 
    

  1. <?php
    2. 

  2. /* Reminder: always indent with 4 spaces (no tabs). */
    3. 

  3. // +---------------------------------------------------------------------------+
    4. 

  4. // | UserBox プラグイン   function.inc からrequire
    5. 

  5. // | 自動タグおよび UserBox 専用関数
    6. 

  6. // +---------------------------------------------------------------------------+
    7. 

  7. // $Id: plugins/userbox/functions_autotag.inc
    8. 

  8. //20101223 tsuchitani AT ivywe DOT co DOT jp http://www.ivywe.co.jp/
    9. 

  9. //20120416 userbox_category {data_edit}
    10. 

  10. 

  11. if (strpos ($_SERVER['PHP_SELF'], 'functions_autotag.inc') !== false) {
    12. 

  12.     die ('This file can not be used on its own.');
    13. 

  13. }
    14. 

  14. 

  15. //=====自動タグ=================================================================
    16. 

  16. function plugin_autotags_userbox (
    17. 

  17.     $op
    18. 

  18.     , $content = ''
    19. 

  19.     , $autotag = '')
    20. 

  20. // +---------------------------------------------------------------------------+
    21. 

  21. // | 自動タグ
    22. 

  22. // | 書式 plugin_autotags_userbox ($op, $content, $autotag)
    23. 

  23. // +---------------------------------------------------------------------------+
    24. 

  24. // 20101229
    25. 

  25. {
    26. 

  26.     global $_TABLES;
    27. 

  27.     global $_CONF;
    28. 

  28.     global $LANG_USERBOX_autotag_desc;
    29. 

  29.          
    30. 

  30.     //Option Display
    31. 

  31.     if ($op == 'tagname' ) {
    32. 

  32.         $tagname[]='userbox';
    33. 

  33.         return $tagname;
    34. 

  34.     } elseif ($op == 'permission' || $op == 'nopermission') {
    35. 

  35.         if ($op == 'permission') {
    36. 

  36.             $flag = true;
    37. 

  37.         } else {
    38. 

  38.             $flag = false;
    39. 

  39.         }
    40. 

  40. 

  41.         if (isset($_GROUPS['UserBox Admin'])) {
    42. 

  42.             $group_id = $_GROUPS['UserBox Admin'];
    43. 

  43.         } else {
    44. 

  44.             $group_id = DB_getItem($_TABLES['groups'], 'grp_id',
    45. 

  45.                                    "grp_name = 'UserBox Admin'");
    46. 

  46.         }
    47. 

  47.         $owner_id = SEC_getDefaultRootUser();
    48. 

  48. 

  49.         if (COM_getPermTag(
    50. 

  50.             $owner_id
    51. 

  51.             , $group_id
    52. 

  52.             , $_USERBOX_CONF['autotag_permissions_userbox'][0]
    53. 

  53.             , $_USERBOX_CONF['autotag_permissions_userbox'][1]
    54. 

  54.             , $_USERBOX_CONF['autotag_permissions_userbox'][2]
    55. 

  55.             , $_USERBOX_CONF['autotag_permissions_userbox'][3]) == $flag) {
    56. 

  56.             return $tagname;
    57. 

  57.         }
    58. 

  58. 

  59.     } elseif ($op == 'description') {
    60. 

  60.         return $LANG_USERBOX_autotag_desc;
    61. 

  61.     } else if ($op == 'parse') {
    62. 

  62.         //引数チェック
    63. 

  63.         $p1 = COM_applyFilter ($autotag['parm1']);
    64. 

  64.         $p2 = COM_applyFilter ($autotag['parm2']);
    65. 

  65.         $tag = COM_applyFilter ($autotag['tag']);
    66. 

  66.         $tagstr = COM_applyFilter ($autotag['tagstr']);
    67. 

  67.         
    68. 

  68.         $parm2_ary[]="category_id";
    69. 

  69.         $parm2_ary[]="category_code";
    70. 

  70.         $parm2_ary[]="mode";
    71. 

  71.         $parm2_ary[]="rss_file";
    72. 

  72.         $parm2_ary[]="title_trim_length";
    73. 

  73.         $parm2_ary[]="intervalday";
    74. 

  74.         $parm2_ary[]="limitcnt";
    75. 

  75.         $parm2_ary[]="newmarkday";
    76. 

  76.         $parm2_ary[]="templatedir";
    77. 

  77.         $parm2_ary[]="id";
    78. 

  78.         $parm2_ary[]="uid";
    79. 

  79.         $parm2_ary[]="username";
    80. 

  80.         $parm2_ary[]="code";
    81. 

  81.         $parm2_ary[]="nohitmsg";
    82. 

  82.         $parm2_ary[]="perpage";
    83. 

  83.         $parm2_ary[]="page";
    84. 

  84.         $parm2_ary[]="order";
    85. 

  85.         $parm2_ary[]="templatesetvar";
    86. 

  86.         $parm2_ary[]="value";
    87. 

  87.         $parm2_ary[]="field_id";
    88. 

  88.         $parm2_ary[]="expired";
    89. 

  89.         $parm2_ary[]="group_id";
    90. 

  90.         $parm2_ary[]="group_code";
    91. 

  91.         $parm2_ary[]="field_code";
    92. 

  92.         $parm2_ary[]="option";
    93. 

  93.         $parm2_ary[]="method";
    94. 

  94.         $parm2_ary[]="roundprecision";
    95. 

  95.         $parm2_ary[]="numberformat";
    96. 

  96.         $parm2_ary[]="permission";
    97. 

  97.         $p=userbox_parm2($p2,$parm2_ary);
    98. 

  98. 

  99.         //各処理
    100. 

  100.         switch( $tag ) {
    101. 

  101.             case 'userbox' :
    102. 

  102.                 switch($p1) {
    103. 

  103.                     case 'count':
    104. 

  104.                         $rt= userbox_count(
    105. 

  105.                             $p['category_id']
    106. 

  106.                             ,$p['category_code']
    107. 

  107.                             ,$p['mode']
    108. 

  108.                             ,$p['permission']
    109. 

  109.                             ,$p['numberformat']
    110. 

  110.                             );
    111. 

  111.                         break;
    112. 

  112.                     case 'newlist':
    113. 

  113.                             if ($p['category_id']<>""){
    114. 

  114.                                 $m="id";
    115. 

  115.                                 $categories=$p['category_id'];
    116. 

  116.                             }elseif ($p['category_code']<>"") {
    117. 

  117.                                 $m="code";
    118. 

  118.                                 $categories=$p['category_code'];
    119. 

  119.                             }else{
    120. 

  120.                                 $m="ALL";
    121. 

  121.                                 $categories="";
    122. 

  122.                             }
    123. 

  123.                             $rt= userbox_newlist(
    124. 

  124.                             $m
    125. 

  125.                             ,$categories
    126. 

  126.                             ,$p['rss_file']
    127. 

  127.                             ,$p['title_trim_length']
    128. 

  128.                             ,$p['intervalday']
    129. 

  129.                             ,$p['limitcnt']
    130. 

  130.                             ,$p['newmarkday']
    131. 

  131.                             ,$p['templatedir']
    132. 

  132.                             ,$p['permission']
    133. 

  133.                             );
    134. 

  134.                         break;
    135. 

  135. 

  136.                     case 'profile':
    137. 

  137.                         $w= userbox_profile(
    138. 

  138.                             $p['uid']
    139. 

  139.                             ,$p['templatedir']
    140. 

  140.                             ,$p['nohitmsg']
    141. 

  141.                             ,""
    142. 

  142.                             ,$p['username']
    143. 

  143.                             );
    144. 

  144.                         $rt=$w['display'];
    145. 

  145.                         break;
    146. 

  146.                     case 'category':
    147. 

  147.                         $rt= userbox_category(
    148. 

  148.                             "autotag"
    149. 

  149.                             ,$p['category_id']
    150. 

  150.                             ,$p['templatedir']
    151. 

  151.                             ,$p['nohitmsg']
    152. 

  152.                             ,$p['perpage']
    153. 

  153.                             ,$p['page']
    154. 

  154.                             ,$p['order']
    155. 

  155.                             ,$p['category_code']
    156. 

  156.                             ,$p['mode']
    157. 

  157.                             ,$p['expired']
    158. 

  158.                         );
    159. 

  159.                         break;
    160. 

  160.                     case 'attributedatacount':
    161. 

  161.                         $rt=DATABOX_count_each_afield(
    162. 

  162.                             "userbox"
    163. 

  163.                             ,$p['templatesetvar']
    164. 

  164.        	                    ,$p['value']
    165. 

  165.                             ,$p['type_id']
    166. 

  166.                             ,$p['permission']
    167. 

  167.                             ,$p['numberformat']
    168. 

  168.                             );
    169. 

  169.                         break;
    170. 

  170.                     case 'lastmodified':
    171. 

  171.                         $rt= userbox_grp(
    172. 

  172.                             "modified"
    173. 

  173.                             ,"max"
    174. 

  174.                             ,"lastmodified"
    175. 

  175.                             ,$p['category_id']
    176. 

  176.                             ,$p['category_code']
    177. 

  177.                             );
    178. 

  178.                         break;
    179. 

  179.                     case 'lastcreated':
    180. 

  180.                         $rt= userbox_grp(
    181. 

  181.                             "created"
    182. 

  182.                             ,"max"
    183. 

  183.                             ,"lastcreated"
    184. 

  184.                             ,$p['category_id']
    185. 

  185.                             ,$p['category_code']
    186. 

  186.                             );
    187. 

  187.                             break;
    188. 

  188.                     case 'attribute':
    189. 

  189.                         $rt= userbox_field(
    190. 

  190.                             "autotag"
    191. 

  191.                             ,$p['field_id']
    192. 

  192.                             ,$p['value']
    193. 

  193.                             ,$p['templatedir']
    194. 

  194.                             ,$p['nohitmsg']
    195. 

  195.                             ,$p['perpage']
    196. 

  196.                             ,$p['page']
    197. 

  197.                             ,$p['order']
    198. 

  198.                             ,$p['field_code']
    199. 

  199.                         );
    200. 

  200.                         break;
    201. 

  201.                     case 'msg':
    202. 

  202.                         $rt=userbox_msg($p['for']) ;
    203. 

  203.                         break;
    204. 

  204.                     case 'categorycount':
    205. 

  205.                         $rt= DATABOX_categorycount(
    206. 

  206.                              "userbox"
    207. 

  207.                             ,$p['group_id']
    208. 

  208.                             ,$p['group_code']
    209. 

  209.                             ,$p['permission']
    210. 

  210.                             ,$p['numberformat']
    211. 

  211.                         );
    212. 

  212.                         break;
    213. 

  213.                     case 'attributevalue':
    214. 

  214.                         $rt=DATABOX_fieldvalue(
    215. 

  215.                                 "userbox"
    216. 

  216.                                 ,$p['id']
    217. 

  217.                                 ,$p['code']
    218. 

  218.                                 ,$p['field_id']
    219. 

  219.                                 ,$p['field_code']
    220. 

  220.                                 ,$p['option']
    221. 

  221.                             );
    222. 

  222.                         break;
    223. 

  223.                     case 'math':
    224. 

  224.                         $rt=DATABOX_math(
    225. 

  225.                                 "userbox"
    226. 

  226.                                 ,$p['method']
    227. 

  227.                                 ,$p['templatesetvar']
    228. 

  228.                                 ,$p['type_id']
    229. 

  229.                                 ,$p['category_id']
    230. 

  230.                                 ,$p['category_code']
    231. 

  231.                                 ,$p['mode']
    232. 

  232.                                 ,$p['roundprecision']
    233. 

  233.                                 ,$p['numberformat']
    234. 

  234.                                 ,$p['permission']
    235. 

  235.                             );
    236. 

  236.                         break;
    237. 

  237.                 }
    238. 

  238. 

  239.                 $content = str_replace ($autotag['tagstr'], $rt, $content);
    240. 

  240.                 return $content;
    241. 

  241.         }
    242. 

  242.     }
    243. 

  243. }
    244. 

  244. 

  245.  
    246. 

  246. 

  247. //第二引数分割
    248. 

  248. function userbox_parm2 ($p2,$parm2_ary)
    249. 

  249. {
    250. 

  250.     $ary=array();
    251. 

  251.     $px = explode (' ', trim ($p2));
    252. 

  252.     if (is_array ($px)) {
    253. 

  253.         foreach ($px as $part) {
    254. 

  254.             $a = explode (':', $part);
    255. 

  255.             if (in_array($a[0],$parm2_ary)){
    256. 

  256.                 $ary["{$a[0]}"]=$a[1];
    257. 

  257.                 $skip++;            
    258. 

  258.             }
    259. 

  259.         }
    260. 

  260.         
    261. 

  261.         if (count ($px) > $skip) {
    262. 

  262.             for ($i = 0; $i < $skip; $i++) {
    263. 

  263.                 array_shift ($px);
    264. 

  264.             }
    265. 

  265.             $ary["lastparm2"] = trim(implode (' ', $px));
    266. 

  266.         }
    267. 

  267. 

  268.     }else{
    269. 

  269.         $ary["lastparm2"]=trim($p2);
    270. 

  270.     }
    271. 

  271.     
    272. 

  272.     return $ary;
    273. 

  273. 

  274. }
    275. 

  275. //=====ブロック関数============================================================
    276. 

  276. function phpblock_shownewuserbox()
    277. 

  277. // +---------------------------------------------------------------------------+
    278. 

  278. // | 機能  ブロック用 新着data一覧出力                                         |
    279. 

  279. // | 書式 phpblock_shownewuserbox()                                            |
    280. 

  280. // +---------------------------------------------------------------------------+
    281. 

  281. {
    282. 

  282.     return userbox_newlist();
    283. 

  283. }
    284. 

  284. //=====専用関数============================================================
    285. 

  285. //
    286. 

  286. function userbox_category(
    287. 

  287.     $autotag
    288. 

  288.     ,$category_id=null
    289. 

  289.     ,$template=null
    290. 

  290.     ,$nohitmsg=""
    291. 

  291.     ,$perpage =0
    292. 

  292.     ,$page=null
    293. 

  293.     ,$order=null
    294. 

  294.     ,$category_code=null
    295. 

  295.     ,$mode=''
    296. 

  296.     ,$expired=''
    297. 

  297. )
    298. 

  298. 

  299. // +---------------------------------------------------------------------------+
    300. 

  300. // | 機能  カテゴリ別一覧表示
    301. 

  301. // | 書式  userbox_category($id,$template,"yes","page",$perpage)
    302. 

  302. // | 書式  userbox_category($p['category_id'],$p['thtml'],$p['nohitmsg']
    303. 

  303. // | 書式                    ,"",$p['perpage'],$p['order'],$p['code']
    304. 

  304. // +---------------------------------------------------------------------------+
    305. 

  305. // | 引数 $category_id:カテゴリid
    306. 

  306. // | 引数 $template:使用するテンプレートのフォルダ名
    307. 

  307. // | 引数 $nohitmsg      :"yes"の時nohitメッセージ表示
    308. 

  308. // | 引数 $m             :"page"の時ヘッダ表示
    309. 

  309. // | 引数 $perpage       :1pageあたりの件数、0の時改ページなし
    310. 

  310. // | 引数 $order         :順序
    311. 

  311. // | 引数 $code          :
    312. 

  312. // | 引数 $mode          :ブランク　または　AND
    313. 

  313. // +---------------------------------------------------------------------------+
    314. 

  314. // | public_html/category.php および　自動タグで使用
    315. 

  315. // | ヘッダはコンフィギュレーション設定により表示されない場合があります
    316. 

  316. // | idもcodeも指定されない場合は、全カテゴリ
    317. 

  317. // +---------------------------------------------------------------------------+
    318. 

  318. // | 戻値 nomal:category list
    319. 

  319. // +---------------------------------------------------------------------------+
    320. 

  320. {
    321. 

  321.     $pi_name="userbox";
    322. 

  322. 

  323.     global $_CONF;
    324. 

  324.     global $_TABLES;
    325. 

  325. 

  326.     global $_USERBOX_CONF;
    327. 

  327.     global $LANG_USERBOX;
    328. 

  328.     global $LANG_USERBOX_ADMIN;
    329. 

  329.     global $LANG28;
    330. 

  330.     global $_USER;
    331. 

  331.     
    332. 

  332.     global $_IMAGE_TYPE;
    333. 

  333.     global $LANG_confignames;
    334. 

  334. 

  335.     
    336. 

  336.     //ログイン要否チェック
    337. 

  337.     if (COM_isAnonUser()){
    338. 

  338.         if  ($_CONF['loginrequired']
    339. 

  339.                 OR ($_USERBOX_CONF['loginrequired'] >1) ){
    340. 

  340.             return $LANG_USERBOX['loginrequired'];
    341. 

  341.         }
    342. 

  342. 

  343.     }
    344. 

  344. 

  345.     //-----テーブル
    346. 

  346.     $tbl1=$_TABLES['USERBOX_category'] ;
    347. 

  347.     $tbl2=$_TABLES['USERBOX_base'] ;
    348. 

  348.     $tbl3=$_TABLES['USERBOX_addition'] ;
    349. 

  349.     $tbl4=$_TABLES['users'] ;
    350. 

  350.     //
    351. 

  351.     $tbl5=$_TABLES['USERBOX_def_category'] ;
    352. 

  352.     
    353. 

  353.     $tbl6=$_TABLES['USERBOX_stats'];
    354. 

  354.     
    355. 

  355.     $datefield=$_USERBOX_CONF['datefield'];//使用する日付（編集日付、作成日付）
    356. 

  356.     $new_img=$_USERBOX_CONF['new_img'];
    357. 

  357.     if ($new_img==""){
    358. 

  358.         $new_img="New!";
    359. 

  359.     }
    360. 

  360.     $newmarkday=$_USERBOX_CONF['newmarkday'];
    361. 

  361.     if ($newmarkday==""){
    362. 

  362.         $newmarkday=3;
    363. 

  363.     }
    364. 

  364.     $chkday=strtotime("- $newmarkday days",time());
    365. 

  365. 

  366.     //-----引数チェック
    367. 

  367.     $ids="";
    368. 

  368.     $idsary=array();
    369. 

  369.     if (is_null($category_id) OR $category_id==0){
    370. 

  370.         if (is_null($category_code)){
    371. 

  371.         }else{
    372. 

  372.             $w=explode("|",$category_code);
    373. 

  373.             foreach( $w as $val ){
    374. 

  374.                 if ($ids<>""){
    375. 

  375.                     $ids.=",";
    376. 

  376.                 }
    377. 

  377.                 $w_id=DATABOX_codetoid($val,'USERBOX_def_category',"category_id");
    378. 

  378.                 $idsary[]=$w_id;
    379. 

  379.                 $ids.=$w_id;
    380. 

  380.             }
    381. 

  381.         }
    382. 

  382.     }else{
    383. 

  383.         $ids=$category_id;
    384. 

  384.         $idsary[]=$category_id;
    385. 

  385.     }
    386. 

  386.     
    387. 

  387.     //--CATEGORY
    388. 

  388.     $category_name="";
    389. 

  389.     $defaulttemplatesdirectory = "";
    390. 

  390.     if (count($idsary)<>0){
    391. 

  391.         
    392. 

  392.         for ($i = 0; $i < count($idsary); $i++) {
    393. 

  393.             $sql = "SELECT ";
    394. 

  394.             $sql .= " name ".LB;
    395. 

  395.             $sql .= " ,code ".LB;
    396. 

  396.             $sql .= " ,description ".LB;
    397. 

  397.             $sql .= " ,defaulttemplatesdirectory".LB;
    398. 

  398.             $sql .= " FROM ".LB;
    399. 

  399.             $sql .= " {$tbl5} AS t5 ".LB;
    400. 

  400.             $sql .= " WHERE ".LB;
    401. 

  401.             $sql .= " t5.category_id =".$idsary[$i].LB;
    402. 

  402.         
    403. 

  403.             $result = DB_query ($sql);
    404. 

  404.             $numrows = DB_numRows ($result);
    405. 

  405.             if ($numrows > 0) {
    406. 

  406.                 $A = DB_fetchArray ($result);
    407. 

  407.                 $category_name.=COM_applyFilter($A['name'])." ";
    408. 

  408.                 $category_description.=COM_applyFilter($A['description'])." ";
    409. 

  409.                 if ($i==0){
    410. 

  410.                     $defaulttemplatesdirectory=COM_applyFilter($A['defaulttemplatesdirectory']);
    411. 

  411.                 }
    412. 

  412.             }
    413. 

  413.         }
    414. 

  414.     }
    415. 

  415. 

  416.     if (is_null($template) or ($template==="")){
    417. 

  417.         if ($defaulttemplatesdirectory===""){
    418. 

  418.             $template="default";
    419. 

  419.         }else{
    420. 

  420.             $template=$defaulttemplatesdirectory;
    421. 

  421.         }
    422. 

  422.     }
    423. 

  423.     
    424. 

  424.     //
    425. 

  425.     if (is_null($page) OR !isset($page) OR $page == 0) {
    426. 

  426.         $page = 1;
    427. 

  427.     }
    428. 

  428.     if ($perpage===0 OR is_null($perpage)){
    429. 

  429.         $perpage=$_USERBOX_CONF['perpage'];
    430. 

  430.     }
    431. 

  431.     //
    432. 

  432.     $w=userbox_orderby($datefield,$order,$orderby,$addfieldorder,$field_id);
    433. 

  433. 

  434.     //-----    
    435. 

  435.     $sql = "SELECT ";
    436. 

  436. 

  437.     $sql .= " t2.id ".LB;
    438. 

  438.     $sql .= " ,t2.description ".LB;
    439. 

  439.     $sql .= " ,t2.released ".LB;
    440. 

  440.     $sql .= " ,t2.expired ".LB;
    441. 

  441.     $sql .= " ,t2.".$datefield." AS datefield ".LB;
    442. 

  442.     $sql .= " ,t2.fieldset_id ".LB;
    443. 

  443.     $sql .= " ,UNIX_TIMESTAMP(t2.".$datefield.") AS datefield_un ".LB;
    444. 

  444.     $sql .= " ,UNIX_TIMESTAMP(t2.released ) AS released_un ".LB;
    445. 

  445.     $sql .= " ,UNIX_TIMESTAMP(t2.expired ) AS expired_un ".LB;
    446. 

  446. 

  447.     $sql .= " ,t2.group_id";
    448. 

  448.     $sql .= " ,t2.owner_id";
    449. 

  449. 

  450.     $sql .= " ,t4.username";
    451. 

  451.     $sql .= " ,t4.fullname";
    452. 

  452.     $sql .= " ,t4.photo";
    453. 

  453.     $sql .= " ,t4.email";
    454. 

  454.     if ($addfieldorder){
    455. 

  455.         $sql .= " ,t3.value ".LB;
    456. 

  456.     }
    457. 

  457.     
    458. 

  458.     //--FROM
    459. 

  459.     $sql .= " FROM ".LB;
    460. 

  460.     $sql .= " {$tbl2} AS t2 ".LB;
    461. 

  461.     $sql .= " ,{$tbl4} AS t4 ".LB;
    462. 

  462.     if ($addfieldorder){
    463. 

  463.         $sql .= " ,{$tbl3} AS t3 ".LB;
    464. 

  464.     }
    465. 

  465.     
    466. 

  466.     //--WHERE
    467. 

  467.     $sql .= " WHERE ".LB;
    468. 

  468.     $sql .= " t2.id=t4.uid ".LB;
    469. 

  469. 

  470.     if (count($idsary)<>0){
    471. 

  471.         if (strtoupper($mode)=="AND"){
    472. 

  472.             $w="";
    473. 

  473.             foreach( $idsary as $val ){
    474. 

  474.                 if ($w<>""){
    475. 

  475.                     $w.=" AND ";
    476. 

  476.                 }
    477. 

  477.                 $w.=$val." IN (SELECT t1.category_id";
    478. 

  478.                 $w.=" FROM {$tbl1} AS t1 ,{$tbl5} AS t5";
    479. 

  479.                 $w.=" WHERE t2.id = t1.id AND t1.category_id = t5.category_id AND t5.allow_display<2)";
    480. 

  480.             }
    481. 

  481.         }else{
    482. 

  482.             $w= "t2.id IN (SELECT id FROM {$tbl1} AS t1 ,{$tbl5} AS t5 ";
    483. 

  483.             $w.="WHERE t1.category_id = t5.category_id AND t5.allow_display<2 AND t1.category_id IN ({$ids})) ";
    484. 

  484.         }
    485. 

  485.         $sql.=" AND ({$w})".LB;
    486. 

  486.     }
    487. 

  487.     
    488. 

  488.     if ($addfieldorder){
    489. 

  489.         $sql .= " AND t3.field_id=".$field_id.LB;
    490. 

  490.         $sql .= " AND t3.id=t2.id".LB;
    491. 

  491.     }
    492. 

  492.     //下書データはのぞく
    493. 

  493.     $sql .= " AND t2.draft_flag=0".LB;
    494. 

  494.     //アクセス権のないデータ はのぞく
    495. 

  495.     $sql .= COM_getPermSql('AND',0,2,"t2");
    496. 

  496.     //公開日以前のデータはのぞく
    497. 

  497.     $sql .= " AND (released <= NOW())".LB;
    498. 

  498.     //公開終了日を過ぎたデータはのぞく
    499. 

  499.     if  (strtoupper($expired)=="NO"){
    500. 

  500.         $sql .= " AND (expired=0 OR expired > NOW())";
    501. 

  501.     }
    502. 

  502.     
    503. 

  503.     //--ORDER
    504. 

  504.     $sql .= " ORDER BY ".LB;
    505. 

  505.     $sql .= $orderby.LB;
    506. 

  506.     
    507. 

  507.     //
    508. 

  508.     $result = DB_query ($sql);
    509. 

  509.     $cnt = DB_numRows ($result);
    510. 

  510. 

  511.     $pages = 0;
    512. 

  512.      if ($perpage > 0) {
    513. 

  513.         $pages = ceil($cnt / $perpage);
    514. 

  514.     }
    515. 

  515.     $offset = ($page - 1) * $perpage;
    516. 

  516.     $sql .= " LIMIT $offset, $perpage";
    517. 

  517. 

  518.     //自動タグでない時　ヘッダ、左ブロック
    519. 

  519.     if ($autotag==="notautotag"){
    520. 

  520.         if ($page > 1) {
    521. 

  521.             $page_title = sprintf ('%s (%d)', $category_name, $page);
    522. 

  522.         } else {
    523. 

  523.             $page_title = sprintf ('%s ', $category_name);
    524. 

  524.         }
    525. 

  525.         // Meta Tags
    526. 

  526.         $headercode=DATABOX_getheadercode(    
    527. 

  527.             "category"
    528. 

  528.             ,$template
    529. 

  529.             ,$pi_name
    530. 

  530.             ,$category_id
    531. 

  531.             ,$category_name
    532. 

  532.             ,$category_description
    533. 

  533.             ,$category_name
    534. 

  534.             ,$category_description);
    535. 

  535.         $retval .= DATABOX_siteHeader($pi_name,'',$page_title,$headercode) ;
    536. 

  536.     }
    537. 

  537. 

  538. 

  539.     $result = DB_query ($sql);
    540. 

  540.     $numrows = DB_numRows ($result);
    541. 

  541. 

  542.     if ($numrows > 0) {
    543. 

  543.         
    544. 

  544.         $tmplfld=DATABOX_templatePath('category',$template,$pi_name);
    545. 

  545.         $templates = new Template($tmplfld);
    546. 

  546.         $templates->set_file (array (
    547. 

  547.             'list' => 'list_detail.thtml',
    548. 

  548.             'nav'   => 'navigation_detail.thtml',
    549. 

  549.             'row'   => 'row.thtml',
    550. 

  550.             'col'   => "col_detail.thtml",
    551. 

  551.             'pagenav'  => 'pagenavigation.thtml'
    552. 

  552.             ));
    553. 

  553.         $languageid=COM_getLanguageId();
    554. 

  554.         $language= COM_getLanguage();
    555. 

  555.         $templates->set_var ('languageid', $languageid);
    556. 

  556.         $templates->set_var ('language', $language);
    557. 

  557.         if ($languageid<>"") {
    558. 

  558.             $templates->set_var ('_languageid', "_".$languageid);
    559. 

  559.         }else{
    560. 

  560.             $templates->set_var ('_languageid', "");
    561. 

  561.         }
    562. 

  562.         
    563. 

  563.         $templates->set_var ('site_url',$_CONF['site_url']);
    564. 

  564.         $templates->set_var ('this_script',THIS_SCRIPT);
    565. 

  565. 

  566.         //bread
    567. 

  567.         $templates->set_var ('home',$LANG_USERBOX['home']);
    568. 

  568. 

  569.         $url=$_CONF['site_url']."/userbox/category.php";
    570. 

  570.         $category_top="<a href='".$url."'>".$LANG_USERBOX['category_top']."</a>";
    571. 

  571.         $templates->set_var ('category_top',$category_top);
    572. 

  572. 

  573.         $templates->set_var ('lang_category_list_h2',$LANG_USERBOX['category_list_h2']);
    574. 

  574. 

  575.         $templates->set_var ('category_name',$category_name);
    576. 

  576.         $templates->set_var ('category_code',$category_code);
    577. 

  577.         $templates->set_var ('category_description',$category_description);
    578. 

  578.     
    579. 

  579. 

  580.         //page
    581. 

  581.         $templates->set_var ('cnt', $cnt);
    582. 

  582.         $lin1=$offset+1;
    583. 

  583.         $lin2=$lin1+$perpage - 1;
    584. 

  584.         if ($lin2>$cnt){
    585. 

  585.             $lin2=$cnt;
    586. 

  586.         }
    587. 

  587. 

  588.         //summary navigation
    589. 

  589.         $templates->set_var ('lang_view', $LANG_USERBOX['view']);
    590. 

  590.         $templates->set_var ('lin', $lin1."-".($lin2));
    591. 

  591.         $templates->set_var ('cnt', $cnt);
    592. 

  592. 

  593.         $templates->set_var ('lang_name', $LANG_USERBOX_ADMIN['name']);
    594. 

  594. 

  595.         $templates->set_var ('lang_username', $LANG_USERBOX_ADMIN['username']);
    596. 

  596.         $templates->set_var ('lang_id', $LANG_USERBOX_ADMIN['id']);
    597. 

  597.         $templates->set_var ('lang_uid', $LANG28[2]);
    598. 

  598.         $templates->set_var ('lang_username', $LANG28[3]);
    599. 

  599.         $templates->set_var ('lang_fullname',$LANG28[4]);
    600. 

  600. 

  601.         //
    602. 

  602.         $templates->set_var ('lang_date', $LANG_USERBOX_ADMIN[$datefield]);
    603. 

  603.         $templates->set_var ('lang_released', $LANG_USERBOX_ADMIN['released']);
    604. 

  604.         $templates->set_var ('lang_expired', $LANG_USERBOX_ADMIN['expired']);
    605. 

  605.         $templates->set_var ('lang_remaingdays', $LANG_USERBOX_ADMIN['remaingdays']);
    606. 

  606.         $templates->set_var ('lang_description', $LANG_USERBOX_ADMIN['description']);
    607. 

  607.         $templates->set_var ('lang_addfield', $addfield_name);
    608. 

  608.         // 追加項目のヘッダ
    609. 

  609.         $addition_def=DATABOX_getadditiondef($pi_name);
    610. 

  610.         //
    611. 

  611. 

  612.         $templates->set_var('lang_imgfile_frd', $LANG_confignames['userbox']['imgfile_frd']);
    613. 

  613.         $templates->set_var ('imgfile_frd', $_USERBOX_CONF['imgfile_frd']);
    614. 

  614.         $templates->set_var ('data_img_url', $_CONF['site_url']."/".$_USERBOX_CONF['imgfile_frd']);
    615. 

  615.         $templates->set_var('lang_imgfile_thumb_frd', $LANG_confignames['userbox']['imgfile_thumb_frd']);
    616. 

  616.         $templates->set_var ('imgfile_thumb_frd', $_USERBOX_CONF['imgfile_thumb_frd']);
    617. 

  617.         $templates->set_var ('data_thumb_img_url', $_CONF['site_url']."/".$_DATABOX_CONF['imgfile_thumb_frd']);
    618. 

  618.             
    619. 

  619.         for ($i = 0; $i < $numrows; $i++) {
    620. 

  620.             $A = DB_fetchArray ($result);
    621. 

  621.             $A = array_map('stripslashes', $A);
    622. 

  622. 

  623.             $description=COM_applyFilter($A['description']);
    624. 

  624.             $username=COM_applyFilter($A['username']);
    625. 

  625.             $fullname=COM_applyFilter($A['fullname']);
    626. 

  626.             $id=COM_applyFilter($A['id']);
    627. 

  627.             $datefield=COM_applyFilter($A['datefield']);
    628. 

  628.             $released=COM_applyFilter($A['released']);
    629. 

  629.             $expired=COM_applyFilter($A['expired']);
    630. 

  630.             $datefield_ary = COM_getUserDateTimeFormat($A['datefield_un']);
    631. 

  631.             $released_ary = COM_getUserDateTimeFormat($A['released_un']);
    632. 

  632.             if ($expired==="0000-00-00 00:00:00"){
    633. 

  633.                 $expired_ary=array();
    634. 

  634.             }else{    
    635. 

  635.                 $expired_ary = COM_getUserDateTimeFormat($A['expired_un']);
    636. 

  636.             }
    637. 

  637.             $curdate_ary =  COM_getUserDateTimeFormat();
    638. 

  638. 

  639.             $value=COM_applyFilter($A['value']);
    640. 

  640.             $group_id = $A['group_id'];
    641. 

  641.             $owner_id = $A['owner_id'];
    642. 

  642.             $fieldset_id=COM_applyFilter($A['fieldset_id']);
    643. 

  643. 

  644.             $url=$_CONF['site_url'] . "/userbox/profile.php";
    645. 

  645.             $url.="?";
    646. 

  646.             //コード使用の時
    647. 

  647.             if ($_USERBOX_CONF['datacode']){
    648. 

  648.                 $url.="code=".$A['username'];
    649. 

  649.                 $url.="&amp;m=code";
    650. 

  650.             }else{
    651. 

  651.                 $url.="id=".$A['id'];
    652. 

  652.                 $url.="&amp;m=id";
    653. 

  653.             }
    654. 

  654.             $url = COM_buildUrl( $url );
    655. 

  655.             $link= COM_createLink($username, $url);
    656. 

  656. 

  657. 

  658.             $templates->set_var ('data_link', $link);
    659. 

  659. 

  660.             $templates->set_var ('data_fullname', $A['fullname']);
    661. 

  661.             $templates->set_var ('data_title', $A['fullname']);
    662. 

  662. 

  663.             $templates->set_var ('data_username', $username);
    664. 

  664.             $templates->set_var ('data_code', $username);
    665. 

  665. 

  666.             $templates->set_var ('data_description', $description);
    667. 

  667.             $templates->set_var ('data_id', $id);
    668. 

  668.             $templates->set_var ('data_url', $url);
    669. 

  669.             $templates->set_var ('data_datefield', $datefield_ary[0]);
    670. 

  670.             $templates->set_var ('data_value', $value);
    671. 

  671.             $templates->set_var ('data_datefield_shortdate', strftime( $_CONF['shortdate'], $A['datefield_un'] ));
    672. 

  672.             $templates->set_var ('data_released', $released_ary[0]);
    673. 

  673.             $templates->set_var ('data_released_shortdate', strftime( $_CONF['shortdate'], $A['released_un'] ));
    674. 

  674.             $templates->set_var ('data_released_date', strftime( $_CONF['date'], $A['released_un'] ));
    675. 

  675.             $templates->set_var ('data_released_daytime', strftime( $_CONF['daytime'], $A['released_un'] ));
    676. 

  676.             $templates->set_var ('data_released_dateonly', strftime( $_CONF['dateonly'], $A['released_un'] ));
    677. 

  677.             $templates->set_var ('data_released_timeonly', strftime( $_CONF['timeonly'], $A['released_un'] ));
    678. 

  678.             $templates->set_var ('data_released_b', strftime( "%b" , $A['released_un']));
    679. 

  679.             $templates->set_var ('data_released_B', strftime( "%B" , $A['released_un']));
    680. 

  680.             $templates->set_var ('data_released_d', strftime( "%d" , $A['released_un']));
    681. 

  681.             $templates->set_var ('data_released_e', strftime( "%e" , $A['released_un']));
    682. 

  682.             
    683. 

  683.             //公開終了日 Expired to publish
    684. 

  684.             if ($A['expired'] ==="0000-00-00 00:00:00"){
    685. 

  685.                 $templates->set_var ('data_expired', "");
    686. 

  686.                 $templates->set_var ('data_expired_shortdate', "" );
    687. 

  687.                 $templates->set_var ('data_expired_date', "" );
    688. 

  688.                 $templates->set_var ('data_expired_daytime', "" );
    689. 

  689.                 $templates->set_var ('data_expired_dateonly', "" );
    690. 

  690.                 $templates->set_var ('data_expired_timeonly', "" );
    691. 

  691.                 $templates->set_var ('data_expired_b', "" );
    692. 

  692.                 $templates->set_var ('data_expired_B', "" );
    693. 

  693.                 $templates->set_var ('data_expired_d', "" );
    694. 

  694.                 $templates->set_var ('data_expired_e', "" );
    695. 

  695.             }else{
    696. 

  696.                 $wary = COM_getUserDateTimeFormat($A['expired_un']);
    697. 

  697.                 $templates->set_var ('data_expired', $expired_ary[0]);
    698. 

  698.                 $templates->set_var ('data_expired_shortdate', strftime( $_CONF['shortdate'], $A['expired_un'] ));
    699. 

  699.                 $templates->set_var ('data_expired_date', strftime( $_CONF['date'], $A['expired_un'] ));
    700. 

  700.                 $templates->set_var ('data_expired_daytime', strftime( $_CONF['daytime'], $A['expired_un'] ));
    701. 

  701.                 $templates->set_var ('data_expired_dateonly', strftime( $_CONF['dateonly'], $A['expired_un'] ));
    702. 

  702.                 $templates->set_var ('data_expired_timeonly', strftime( $_CONF['timeonly'], $A['expired_un'] ));
    703. 

  703.                 $templates->set_var ('data_expired_b', strftime( "%b" , $A['expired_un']));
    704. 

  704.                 $templates->set_var ('data_expired_B', strftime( "%B" , $A['expired_un']));
    705. 

  705.                 $templates->set_var ('data_expired_d', strftime( "%d" , $A['expired_un']));
    706. 

  706.                 $templates->set_var ('data_expired_e', strftime( "%e" , $A['expired_un']));
    707. 

  707.             }
    708. 

  708.             $remaingdays="";
    709. 

  709.             if ($expired<>"0000-00-00 00:00:00") {
    710. 

  710.                 if  ($expired_ary[1]>=$curdate_ary[1]){
    711. 

  711.                     $remaingdays=COM_dateDiff( "d", $expired_ary[1], $curdate_ary[1] ) + 1;
    712. 

  712.                 }
    713. 

  713.             }
    714. 

  714.             $templates->set_var ('data_remaingdays', $remaingdays);//@@@@@@
    715. 

  715.             if (date("Ymd",strtotime($datefield)) >= date("Ymd",$chkday)){
    716. 

  716.                 $templates->set_var ('new_img', $new_img);
    717. 

  717.             }else{
    718. 

  718.                 $templates->set_var ('new_img', '');
    719. 

  719.             }
    720. 

  720.             
    721. 

  721.             //
    722. 

  722.             if (isset($A['photo']) && empty($A['photo'])) {
    723. 

  723.                 $A['photo'] = '(none)'; // user does not have a photo
    724. 

  724.                 $templates->set_var('data_photo', "");
    725. 

  725.             }else{
    726. 

  726.                 $templates->set_var('data_photo', $A['photo']);
    727. 

  727.             }
    728. 

  728.             $photo = USER_getPhoto($uid, $A['photo'], $A['email'], -1);
    729. 

  729.             $templates->set_var('data_user_photo', $photo);
    730. 

  730. 

  731.             $hits=COM_applyFilter(DB_getItem( $tbl6 ,"hits","id={$id}"),true);
    732. 

  732.             $templates->set_var('lang_hits', $LANG_USERBOX_ADMIN['hits']);
    733. 

  733.             $templates->set_var('data_hits', $hits);
    734. 

  734.             
    735. 

  735.             //カテゴリ@@@@@
    736. 

  736.             $templates->set_var('lang_category', $LANG_USERBOX_ADMIN['category']);
    737. 

  737.             DATABOX_getcategoriesDisp($A['id'],$templates,$chk_user,0,$pi_name);
    738. 

  738. 

  739.             //追加項目
    740. 

  740.             $chk_user=DATABOX_chkuser($group_id,$owner_id,"userbox.admin");
    741. 

  741.             $additionfields = DATABOX_getadditiondatas($id,$pi_name);
    742. 

  742.             DATABOX_getaddtionfieldsDisp($additionfields,$addition_def,$templates,$chk_user,$pi_name,$fieldset_id);
    743. 

  743.             
    744. 

  744.             //管理者の時「編集」
    745. 

  745.             $templates->set_var ('data_edit', "");
    746. 

  746.             if ( SEC_hasRights('userbox.admin')) {
    747. 

  747.                 $icon_url = $_CONF['layout_url'] . '/images/edit.' . $_IMAGE_TYPE;
    748. 

  748.                 $attr = array('title' => $username." ".$LANG_USERBOX_ADMIN['edit']);
    749. 

  749.                 $editiconhtml = COM_createImage($icon_url, $LANG_USERBOX_ADMIN['edit'], $attr);
    750. 

  750.                 $attr = array('class' => 'editlink', 'title' => $username." ".$LANG_USERBOX_ADMIN['edit']);
    751. 

  751.                 $url = $_CONF['site_admin_url'];
    752. 

  752.                 $url .= '/plugins/userbox/profile.php';
    753. 

  753.                 $url .= '?mode=edit';
    754. 

  754.                 $url .= '&amp;'."id={$id}";
    755. 

  755.                 $icon = '&nbsp;' ;
    756. 

  756.                 $icon .=  COM_createLink( $editiconhtml,  $url,   $attr   );
    757. 

  757.                 $templates->set_var ('data_edit', $icon);
    758. 

  758.             }else{
    759. 

  759.                 if ($id===$_USER['uid']){
    760. 

  760.                     $icon_url = $_CONF['layout_url'] . '/images/edit.' . $_IMAGE_TYPE;
    761. 

  761.                     $attr = array('title' => $LANG_USERBOX_ADMIN['edit']);
    762. 

  762.                     $editiconhtml = COM_createImage($icon_url, $LANG_USERBOX_ADMIN['edit'], $attr);
    763. 

  763.                     $attr = array('class' => 'editlink', 'title' => $username." ".$LANG_USERBOX_ADMIN['edit']);
    764. 

  764.                     $url = $_CONF['site_url'];
    765. 

  765.                     $url .= '/userbox/myprofile/profile.php';
    766. 

  766.                     $icon = '&nbsp;' ;
    767. 

  767.                     $icon .=  COM_createLink( $editiconhtml,  $url,   $attr   );
    768. 

  768.                     $templates->set_var ('data_edit', $icon);
    769. 

  769.                 }
    770. 

  770.             }
    771. 

  771.             
    772. 

  772.             //=====
    773. 

  773.             $templates->parse ('col_var', 'col', true);
    774. 

  774.             $templates->parse ('row_var', 'row', true);
    775. 

  775. 

  776.             $templates->set_var ('col_var', '');
    777. 

  777. 

  778.         }
    779. 

  779.         // Call to plugins to set template variables in the databox
    780. 

  780.         PLG_templateSetVars( 'userbox', $templates );
    781. 

  781. 

  782.         //------------
    783. 

  783.         //-----navigation
    784. 

  784.         $url = $_CONF['site_url']  . '/';
    785. 

  785.         if ($autotag==="notautotag"){
    786. 

  786.             $url.=THIS_SCRIPT;
    787. 

  787.         }else{
    788. 

  788.             $url.="userbox/category.php";
    789. 

  789.         }
    790. 

  790.         $url .= "?";
    791. 

  791.         if ($category_code<>""){
    792. 

  792.             $url .= "code=".$category_code;
    793. 

  793.             $url .= "&amp;m=code";
    794. 

  794.         }else{
    795. 

  795.             $url .= "id=".$category_id;
    796. 

  796.             $url .= "&amp;m=id";
    797. 

  797.         }
    798. 

  798.         $url .= "&amp;template=".$template;
    799. 

  799.         $url .= "&amp;order=";
    800. 

  800.         //-----order navigation
    801. 

  801.         userbox_order ($url, $templates, $order) ;
    802. 

  802.         //-----page navigation
    803. 

  803.         $url .= $order;
    804. 

  804.         $templates->set_var ('page_navigation',
    805. 

  805.                 COM_printPageNavigation ($url, $page, $pages));
    806. 

  806.         if ($order==="random"){
    807. 

  807.             $templates->set_var ( 'pagenavinone', 'style="display:none;"' );
    808. 

  808.         }else{
    809. 

  809.             $templates->set_var ( 'pagenavinone', '' );
    810. 

  810.         }
    811. 

  811.         //------------
    812. 

  812.         $templates->parse ('nav_var', 'nav', true);
    813. 

  813. 

  814.         $templates->set_var ('blockfooter',COM_endBlock());
    815. 

  815. 

  816.         $templates->set_var ('msg', "");
    817. 

  817.         //@@@@@@@@$templates->set_var ('search_link', $LANG_USERBOX['search_link']);
    818. 

  818.         //@@@@@@@@$templates->set_var ('search_var',"");
    819. 

  819. 

  820.         $templates->parse ('output', 'list');
    821. 

  821. 

  822.         $content = $templates->finish ($templates->get_var ('output'));
    823. 

  823.         $retval .=$content;
    824. 

  824. 

  825.     }else{
    826. 

  826.         if ($nohitmsg==="yes"){
    827. 

  827.             $tmplfld=DATABOX_templatePath('category',$template,$pi_name);
    828. 

  828.             $templates = new Template($tmplfld);
    829. 

  829.             $templates->set_file (array (
    830. 

  830.                 'list' => 'nohit.thtml',
    831. 

  831.             ));
    832. 

  832.             
    833. 

  833.             $templates->set_var ('home',$LANG_USERBOX['home']);
    834. 

  834.             
    835. 

  835.             $url=$_CONF['site_url']."/userbox/category.php";
    836. 

  836.             $category_top="<a href='".$url."'>".$LANG_USERBOX['category_top']."</a>";
    837. 

  837.             $templates->set_var ('category_top',$category_top);
    838. 

  838. 

  839.             $templates->set_var ('category_name',$category_name);
    840. 

  840.             $templates->set_var ('category_code',$category_code);
    841. 

  841.             $templates->set_var ('category_description',$category_description);
    842. 

  842.                         
    843. 

  843.             $templates->set_var('xhtml', XHTML);
    844. 

  844.             $templates->set_var('site_url', $_CONF['site_url']);
    845. 

  845.             $templates->set_var('site_admin_url', $_CONF['site_admin_url']);
    846. 

  846.             $templates->set_var('layout_url', $_CONF['layout_url']);
    847. 

  847.             
    848. 

  848.             $templates->set_var ('lang_nohit', $LANG_USERBOX['nohit']);
    849. 

  849. 

  850.             $templates->parse ('output', 'list');
    851. 

  851.             $content = $templates->finish ($templates->get_var ('output'));
    852. 

  852.             $retval .=$content;
    853. 

  853.         }
    854. 

  854.     }
    855. 

  855. 

  856.     $retval =PLG_replacetags ($retval);
    857. 

  857. 

  858.     //return $dbg.$retval;
    859. 

  859.     return $retval;
    860. 

  860. }
    861. 

  861. 

  862. 

  863. 

  864. 

  865. 

  866. function userbox_count(
    867. 

  867.     $category_id =null
    868. 

  868.     ,$category_code =null
    869. 

  869.     ,$mode=''
    870. 

  870.     ,$permission=""
    871. 

  871.     ,$numberformat=''
    872. 

  872. )
    873. 

  873. // +---------------------------------------------------------------------------+
    874. 

  874. // | 機能  件数表示
    875. 

  875. // +---------------------------------------------------------------------------+
    876. 

  876. // | 書式  userbox_count()
    877. 

  877. // | 書式  userbox_count(1)
    878. 

  878. // | 書式  userbox_count("japan")
    879. 

  879. // +---------------------------------------------------------------------------+
    880. 

  880. // | 引数 $category_id:カテゴリid　（優先）
    881. 

  881. // | 引数 $category_code:カテゴリコード
    882. 

  882. // | 引数 $mode          :ブランク　または　AND
    883. 

  883. // +---------------------------------------------------------------------------+
    884. 

  884. // | 戻値 nomal:データ総数、カテゴリ別データ件数
    885. 

  885. // +---------------------------------------------------------------------------+
    886. 

  886. {
    887. 

  887.     global $_TABLES;
    888. 

  888. 

  889.     //-----
    890. 

  890.     $tbl1=$_TABLES['USERBOX_base'] ;
    891. 

  891.     $tbl2=$_TABLES['USERBOX_category'] ;
    892. 

  892.     
    893. 

  893.     //カテゴリの指定がなければ全件、あればカテゴリ毎
    894. 

  894.     $exp="";
    895. 

  895.     if (is_null($category_id) AND is_null($category_code) ){
    896. 

  896.     }else{
    897. 

  897.         $ids="";
    898. 

  898.         $idsary=array();
    899. 

  899.         if (is_null($category_id) OR $category_id==0){
    900. 

  900.             if (is_null($category_code)){
    901. 

  901.             }else{
    902. 

  902.                 $w=explode("|",$category_code);
    903. 

  903.                 foreach( $w as $val ){
    904. 

  904.                     if ($ids<>""){
    905. 

  905.                         $ids.=",";
    906. 

  906.                     }
    907. 

  907.                     $w_id=DATABOX_codetoid($val,'USERBOX_def_category',"category_id");
    908. 

  908.                     $idsary[]=$w_id;
    909. 

  909.                     $ids.=$w_id;
    910. 

  910.                 }
    911. 

  911.             }
    912. 

  912.         }else{
    913. 

  913.             $ids=$category_id;
    914. 

  914.             $idsary[]=$category_id;
    915. 

  915.         }
    916. 

  916.         if (strtoupper($mode)=="AND"){
    917. 

  917.             $w="";
    918. 

  918.             foreach( $idsary as $val ){
    919. 

  919.                 if ($w<>""){
    920. 

  920.                     $w.=" AND ";
    921. 

  921.                 }
    922. 

  922.                 $w.=$val." IN (SELECT category_id";
    923. 

  923.                 $w.=" FROM {$tbl2} AS t2 ";
    924. 

  924.                 $w.=" WHERE t2.id = t1.id)";
    925. 

  925.             }
    926. 

  926.         }else{
    927. 

  927.             $w= "id IN (SELECT id FROM {$tbl2} ";
    928. 

  928.             $w.="WHERE category_id IN ({$ids})) ";
    929. 

  929.         }
    930. 

  930.         $exp=$w.LB;
    931. 

  931.     }
    932. 

  932. 

  933.     //-----
    934. 

  934.     $sql = "SELECT ".LB;
    935. 

  935. 

  936.     $sql .= " distinct t1.id ".LB;
    937. 

  937. 

  938.     $sql .= " FROM ".LB;
    939. 

  939. 

  940.     $sql .= " {$tbl1} AS t1 ".LB;
    941. 

  941. 

  942. 

  943.     $sql .= " WHERE ".LB;
    944. 

  944.     
    945. 

  945.     if ($exp<>""){
    946. 

  946.         $sql .= $exp. " AND ";
    947. 

  947.     }
    948. 

  948.     
    949. 

  949.     //@@@@@@@@@@@------>
    950. 

  950.     //下書はのぞく
    951. 

  951.     $sql .= " t1.draft_flag=0".LB;
    952. 

  952.     //アクセス権のないデータ はのぞく
    953. 

  953.     if  (strtoupper($permission)=="IGNORE"){
    954. 

  954.     }else{
    955. 

  955.         $sql .= COM_getPermSql('AND').LB;
    956. 

  956.     }
    957. 

  957.     //公開日以前のデータはのぞく
    958. 

  958.     $sql .= " AND (released <= NOW())".LB;
    959. 

  959.     //公開終了日を過ぎたデータはのぞく
    960. 

  960.     $sql .= " AND (expired=0 OR expired > NOW())".LB;
    961. 

  961.     //@@@@@@@@@@@<------
    962. 

  962. 

  963.     $result = DB_query ($sql);
    964. 

  964.     $cnt = DB_numRows ($result);
    965. 

  965.     if  (strtoupper($numberformat)=="YES"){
    966. 

  966.         $rt=COM_NumberFormat($cnt);
    967. 

  967.     }else{
    968. 

  968.         $rt=$cnt;
    969. 

  969.     }
    970. 

  970. 

  971.     return $rt;
    972. 

  972. 

  973. }
    974. 

  974. 

  975. 

  976. function userbox_grp(
    977. 

  977.     $field=null
    978. 

  978.     ,$function=null
    979. 

  979.     ,$format=null
    980. 

  980.     ,$category_id =null
    981. 

  981.     ,$category_code =null
    982. 

  982. )
    983. 

  983. // +---------------------------------------------------------------------------+
    984. 

  984. // | 機能  集計表示(max min sum)
    985. 

  985. // +---------------------------------------------------------------------------+
    986. 

  986. // | 書式  userbox_grp()
    987. 

  987. // | 書式  userbox_grp(1)
    988. 

  988. // | 書式  userbox_grp("japan")
    989. 

  989. // +---------------------------------------------------------------------------+
    990. 

  990. // | 引数 $field:項目　デフォルトmodified
    991. 

  991. // | 引数 $function:関数　デフォルトmax
    992. 

  992. // | 引数 $format:書式
    993. 

  993. // | 引数 $category_id:カテゴリid　（優先）
    994. 

  994. // | 引数 $category_code:カテゴリコード
    995. 

  995. // +---------------------------------------------------------------------------+
    996. 

  996. // | 戻値 nomal:データ総数、カテゴリ別データ件数
    997. 

  997. // +---------------------------------------------------------------------------+
    998. 

  998. {
    999. 

  999.     global $_TABLEdS;
    1000. 

  1000.     global $LANG_USERBOX;
    1001. 

  1001. 

  1002.     $rt="";
    1003. 

  1003. 

  1004.     if (is_null($field) ){
    1005. 

  1005.         $field="id";
    1006. 

  1006.     }
    1007. 

  1007.     if (is_null($function) ){
    1008. 

  1008.         $function="max";
    1009. 

  1009.     }
    1010. 

  1010. 

  1011.     if (is_null($category_id) AND is_null($category_code) ){
    1012. 

  1012.         $m="ALL";
    1013. 

  1013.     }else{
    1014. 

  1014.         if (is_null($category_id) ){
    1015. 

  1015.             $category_id=DATABOX_codetoid($category_code,'USERBOX_def_category',"category_id");
    1016. 

  1016.         }
    1017. 

  1017.         $m="CATEGORY";
    1018. 

  1018.     }
    1019. 

  1019.     //-----
    1020. 

  1020.     $tbl1=$_TABLES['USERBOX_base'] ;
    1021. 

  1021.     $tbl2=$_TABLES['USERBOX_category'] ;
    1022. 

  1022. 

  1023.     //-----
    1024. 

  1024.     $sql=LB;
    1025. 

  1025.     $sql .= "SELECT ".LB;
    1026. 

  1026. 

  1027.     $sql .= " {$function}(t1.{$field}) AS rt".LB;
    1028. 

  1028. 

  1029.     $sql .= " FROM ".LB;
    1030. 

  1030. 

  1031.     $sql .= " {$tbl1} AS t1 ".LB;
    1032. 

  1032. 

  1033.     if ($m==="ALL"){
    1034. 

  1034.     }else{
    1035. 

  1035.         $sql .= " ,{$tbl2} AS t2 ".LB;
    1036. 

  1036.     }
    1037. 

  1037. 

  1038.     $sql .= " WHERE ".LB;
    1039. 

  1039. 

  1040.     //@@@@@@@@@--------->
    1041. 

  1041.     //下書はのぞく
    1042. 

  1042.     $sql .= " t1.draft_flag=0".LB;
    1043. 

  1043.     //アクセス権のないデータ はのぞく
    1044. 

  1044.     $sql .= COM_getPermSql('AND').LB;
    1045. 

  1045.     //公開日以前のデータはのぞく
    1046. 

  1046.     $sql .= " AND (released <= NOW())".LB;
    1047. 

  1047.     //公開終了日を過ぎたデータはのぞく
    1048. 

  1048.     $sql .= " AND (expired=0 OR expired > NOW())".LB;
    1049. 

  1049.     //@@@@@@@@@<---------
    1050. 

  1050. 

  1051.     if ($m==="ALL"){
    1052. 

  1052.     }else{
    1053. 

  1053.         $sql .= " AND t1.id = t2.id ".LB;
    1054. 

  1054.         $sql .= " AND t2.category_id= ".$category_id .LB;
    1055. 

  1055.     }
    1056. 

  1056. 

  1057.     $result = DB_query ($sql);
    1058. 

  1058.     $numrows = DB_numRows ($result);
    1059. 

  1059. 

  1060.     if ($numrows > 0) {
    1061. 

  1061. 

  1062.         $A = DB_fetchArray ($result);
    1063. 

  1063. 

  1064.         $rt=$A['rt'];
    1065. 

  1065. 

  1066.         if ($rt<>""){
    1067. 

  1067.             switch($format){
    1068. 

  1068.                 case "lastmodified":// '%Y年%m%e日更新';
    1069. 

  1069.                 case "lastcreated"://'%Y年%m%e日追加';
    1070. 

  1070.                     $fm=$LANG_USERBOX[$format];
    1071. 

  1071.                     $rt=strftime($fm,strtotime($rt));
    1072. 

  1072.                     break;
    1073. 

  1073.                 default:
    1074. 

  1074.                     break;
    1075. 

  1075.             }
    1076. 

  1076.         }
    1077. 

  1077. 

  1078.     }
    1079. 

  1079. 

  1080.     return $rt;
    1081. 

  1081. 

  1082. }
    1083. 

  1083. 

  1084. function userbox_profile(
    1085. 

  1085.     $id=null
    1086. 

  1086.     ,$template=null
    1087. 

  1087.     ,$nohitmsg=""
    1088. 

  1088.     ,$m=""
    1089. 

  1089.     ,$code=null
    1090. 

  1090. )
    1091. 

  1091. // +---------------------------------------------------------------------------+
    1092. 

  1092. // | 機能  個別データ表示
    1093. 

  1093. // | 書式  userbox_profile($id,$template,"yes","page")
    1094. 

  1094. // | 書式  userbox_profile($p['id'],$p['thtml'],$p['nohitmsg'],$p['code']
    1095. 

  1095. // +---------------------------------------------------------------------------+
    1096. 

  1096. // | 引数 $id            :
    1097. 

  1097. // | 引数 $template      :テンプレートのdirectory
    1098. 

  1098. // | 引数 $nohitmsg      :"yes"の時nohitメッセージ表示
    1099. 

  1099. // | 引数 $m             :"page"の時ヘッダ表示
    1100. 

  1100. // | 引数 $code          :
    1101. 

  1101. // +---------------------------------------------------------------------------+
    1102. 

  1102. // | public_html/profile.php および　自動タグで使用
    1103. 

  1103. // | ヘッダはコンフィギュレーション設定により表示されない場合があります
    1104. 

  1104. // | idもcodeも指定されない場合は、直近に変更または追加されたデータを返します
    1105. 

  1105. // +---------------------------------------------------------------------------+
    1106. 

  1106. // | 戻値 nomal:profile
    1107. 

  1107. // +---------------------------------------------------------------------------+
    1108. 

  1108. // 20120125
    1109. 

  1109. {
    1110. 

  1110.     $pi_name="userbox";
    1111. 

  1111. 

  1112.     global $_CONF;
    1113. 

  1113.     global $_TABLES;
    1114. 

  1114.     global $_IMAGE_TYPE;
    1115. 

  1115.     global $_USER;
    1116. 

  1116. 

  1117.     global $LANG28;
    1118. 

  1118.     global $LANG04;
    1119. 

  1119.     
    1120. 

  1120.     global $_USERBOX_CONF;
    1121. 

  1121.     global $LANG_USERBOX;
    1122. 

  1122.     global $LANG_USERBOX_ADMIN;
    1123. 

  1123.     
    1124. 

  1124.     global $LANG_confignames;
    1125. 

  1125.     
    1126. 

  1126.     $layout=$_DATABOX_CONF['layout'];
    1127. 

  1127.     //-----
    1128. 

  1128.     if (is_null($id) AND (is_null($code))){
    1129. 

  1129.         $id=$_USER['uid'];
    1130. 

  1130.     }
    1131. 

  1131. 

  1132.     if (is_null($id)  OR ($id==0)){
    1133. 

  1133.         if ($code<>""){
    1134. 

  1134.             $id=DATABOX_codetoid($code,'users',"uid","username");
    1135. 

  1135.         }
    1136. 

  1136.     }
    1137. 

  1137. 

  1138.     //-----
    1139. 

  1139.     $display = '';
    1140. 

  1140. 

  1141. 

  1142.     $tbl=$_TABLES['USERBOX_base'] ;
    1143. 

  1143.     $tbl1=$_TABLES['users'] ;
    1144. 

  1144.     $tbl4=$_TABLES['USERBOX_def_fieldset'];
    1145. 

  1145.     $tbl5=$_TABLES['USERBOX_stats'];
    1146. 

  1146. 

  1147.     $addition_def=DATABOX_getadditiondef($pi_name);
    1148. 

  1148. 

  1149.     //-----
    1150. 

  1150.     $sql = "SELECT t.* ";
    1151. 

  1151.     
    1152. 

  1152.     $sql .= " ,UNIX_TIMESTAMP(t.modified) AS modified_un";
    1153. 

  1153.     $sql .= " ,UNIX_TIMESTAMP(t.released) AS released_un";
    1154. 

  1154.     $sql .= " ,UNIX_TIMESTAMP(t.comment_expire) AS comment_expire_un";
    1155. 

  1155.     $sql .= " ,UNIX_TIMESTAMP(t.expired) AS expired_un";
    1156. 

  1156.     $sql .= " ,UNIX_TIMESTAMP(t.created) AS created_un";
    1157. 

  1157.     $sql .= " ,UNIX_TIMESTAMP(t.udatetime) AS udatetime_un";
    1158. 

  1158.     
    1159. 

  1159.     $sql .= " ,t.fieldset_id";
    1160. 

  1160. 

  1161.     $sql .= " ,t1.username ";
    1162. 

  1162.     $sql .= " ,t1.fullname ";
    1163. 

  1163.     $sql .= " ,t1.photo ";
    1164. 

  1164.     $sql .= " ,t1.email";
    1165. 

  1165.     $sql .= " ,t3.username AS last_modify_name";
    1166. 

  1166.     $sql .= " ,t3.fullname AS last_modify_fullname";
    1167. 

  1167.     
    1168. 

  1168.     $sql .= " ,t4.name AS set_name";
    1169. 

  1169.     $sql .= " ,t4.description AS set_description";
    1170. 

  1170.     $sql .= " ,t4.defaulttemplatesdirectory AS set_defaulttemplatesdirectory";
    1171. 

  1171.     $sql .= " ,t4.layout AS set_layout";
    1172. 

  1172.     
    1173. 

  1173.     $sql .= " ,t5.hits";
    1174. 

  1174. 

  1175.     $sql .= " FROM ";
    1176. 

  1176.     $sql .= " {$tbl} AS t ";
    1177. 

  1177.     $sql .= " JOIN {$tbl4} AS t4       ON t.fieldset_id=t4.fieldset_id";
    1178. 

  1178.     $sql .= " JOIN {$tbl1} AS t1       ON t.id=t1.uid";//owner
    1179. 

  1179.     $sql .= " LEFT JOIN  {$tbl5} AS t5 ON t.id=t5.id";
    1180. 

  1180.     $sql .= " LEFT JOIN  {$tbl1} AS t3 ON t.uuid=t3.uid";//last_updateowner
    1181. 

  1181. 

  1182.     $sql .= " WHERE ";
    1183. 

  1183. 

  1184. 

  1185.     if (is_null($id)){//@@@@@
    1186. 

  1186.         $sql .= "1=1";
    1187. 

  1187.     }else{
    1188. 

  1188.         $sql .= " t.id=".$id;
    1189. 

  1189.     }
    1190. 

  1190. 

  1191.     //管理者の時,
    1192. 

  1192.     if ( SEC_hasRights('userbox.admin') OR $m==="view") {
    1193. 

  1193.     }else{
    1194. 

  1194.         //下書データはのぞく
    1195. 

  1195.        $sql .= " AND t.draft_flag=0".LB;
    1196. 

  1196.         //公開日以前のデータはのぞく
    1197. 

  1197.         $sql .= " AND (released <= NOW())";
    1198. 

  1198. 

  1199.         //公開終了日を過ぎたデータはのぞく
    1200. 

  1200.         $sql .= " AND (expired=0 OR expired > NOW())";
    1201. 

  1201.     }
    1202. 

  1202.     //アクセス権のないデータ はのぞく
    1203. 

  1203.     $sql .= COM_getPermSql('AND');
    1204. 

  1204. 

  1205.     if (is_null($id)){
    1206. 

  1206.         $sql .= " ORDER BY ".$_USERBOX_CONF['datefield'] . " DESC ";
    1207. 

  1207.         $sql .= " LIMIT 0 , 1";
    1208. 

  1208.     }
    1209. 

  1209. 

  1210.     $result = DB_query ($sql);
    1211. 

  1211.     $numrows = DB_numRows ($result);
    1212. 

  1212.     
    1213. 

  1213.     if  ($m==="page"  OR  $m==="view"){
    1214. 

  1214.         if ($numrows <= 0) {
    1215. 

  1215.             COM_handle404();
    1216. 

  1216.             exit;
    1217. 

  1217.         }
    1218. 

  1218.     }
    1219. 

  1219. 

  1220.     if ($numrows > 0) {
    1221. 

  1221. 

  1222.         $A = DB_fetchArray ($result);
    1223. 

  1223.         $A = array_map('stripslashes', $A);
    1224. 

  1224. 		
    1225. 

  1225. 		$cache_time=$A['cache_time'];
    1226. 

  1226.         $cache=false;
    1227. 

  1227. 		if  ($cache_time===0){
    1228. 

  1228. 		}else{
    1229. 

  1229. 		    if  ($m==="page"){
    1230. 

  1230.                 if ($cache_time > -1 ) {
    1231. 

  1231.                     // Don't need to cache per theme since not rendered in a block yet 
    1232. 

  1232.                     $cacheInstance = 'userbox__' . $id . '__' . CACHE_security_hash();
    1233. 

  1233.                     $retval = CACHE_check_instance($cacheInstance);
    1234. 

  1234.                     if ($retval AND $cache_time == -1) {
    1235. 

  1235.                         return $retval;
    1236. 

  1236.                     } elseif ($retval AND $cache_time > 0) {        
    1237. 

  1237.                         $lu = CACHE_get_instance_update($cacheInstance);
    1238. 

  1238.                         $now = time();
    1239. 

  1239.                         if (($now - $lu) < $cache_time) {
    1240. 

  1240.                             return $retval;
    1241. 

  1241.                         } else {
    1242. 

  1242.                             $retval = '';
    1243. 

  1243.                         }
    1244. 

  1244.                    }    
    1245. 

  1245.                 }
    1246. 

  1246.             }
    1247. 

  1247. 	    }
    1248. 

  1248.         
    1249. 

  1249.         if  ($cache){
    1250. 

  1250.             $display = CACHE_check_instance($cacheInstance."_display",$display);
    1251. 

  1251.             $layout = CACHE_check_instance($cacheInstance."_layout",$layout);
    1252. 

  1252.             $headercode = CACHE_check_instance($cacheInstance."_headercode",$headercode);
    1253. 

  1253.             $title = CACHE_check_instance($cacheInstance."_title",$title);
    1254. 

  1254.         }else{
    1255. 

  1255. 			
    1256. 

  1256.             if (is_null($template) or ($template==="")){
    1257. 

  1257.                 if ($A['defaulttemplatesdirectory']<>""){
    1258. 

  1258.                     $template=$A['defaulttemplatesdirectory'];
    1259. 

  1259.                 }elseif  ($A['set_defaulttemplatesdirectory']<>""){
    1260. 

  1260.                     $template=$A['set_defaulttemplatesdirectory'];
    1261. 

  1261.                 }else{
    1262. 

  1262.                     $template="default";
    1263. 

  1263.                 }
    1264. 

  1264.            }
    1265. 

  1265. 

  1266. 

  1267.             $group_id = $A['group_id'];
    1268. 

  1268.             $owner_id = $A['owner_id'];
    1269. 

  1269.             $fieldset_id= $A['fieldset_id'];
    1270. 

  1270.             if ($m==="view"){
    1271. 

  1271.                 $chk_user=1000;//ログインユーザ
    1272. 

  1272.             }else{
    1273. 

  1273.                 $chk_user=DATABOX_chkuser($group_id,$owner_id,"userbox.admin");
    1274. 

  1274.             }
    1275. 

  1275.             //
    1276. 

  1276.             $id=$A['id'];
    1277. 

  1277.             $additionfields = DATABOX_getadditiondatas($id,$pi_name);
    1278. 

  1278. 

  1279.             //ヘッダ、左ブロック start.............
    1280. 

  1280.             if ($m==="page"){
    1281. 

  1281.                 if  ($A['set_layout']<>"0") {
    1282. 

  1282.                     $layout=$A['set_layout'];
    1283. 

  1283.                 }
    1284. 

  1284.                 $title= $A['page_title'];
    1285. 

  1285.                 if ($title===""){
    1286. 

  1286.                     $title =$A['username'];
    1287. 

  1287.                 }
    1288. 

  1288.                 // Meta Tags
    1289. 

  1289.                 $headercode=DATABOX_getheadercode(    
    1290. 

  1290.                     "profile"
    1291. 

  1291.                     ,$template
    1292. 

  1292.                     ,$pi_name
    1293. 

  1293.                     ,$A['id']
    1294. 

  1294.                     ,$title
    1295. 

  1295.                     ,$A['meta_description']
    1296. 

  1296.                     ,$A['meta_keywords']
    1297. 

  1297.                     ,$A['description']);
    1298. 

  1298.             }
    1299. 

  1299. 

  1300.             $tmplfld=DATABOX_templatePath('profile',$template,$pi_name);
    1301. 

  1301.             $templates = new Template($tmplfld);
    1302. 

  1302.             $templates->set_file (array (
    1303. 

  1303.                 'list' => 'list_detail.thtml',
    1304. 

  1304.                 'row'   => 'row.thtml',
    1305. 

  1305.                 'col'   => "col_detail.thtml",
    1306. 

  1306.                 ));
    1307. 

  1307.             $languageid=COM_getLanguageId();
    1308. 

  1308.             $language= COM_getLanguage();
    1309. 

  1309.             $templates->set_var ('languageid', $languageid);
    1310. 

  1310.             $templates->set_var ('language', $language);
    1311. 

  1311.             if ($languageid<>"") {
    1312. 

  1312.                 $templates->set_var ('_languageid', "_".$languageid);
    1313. 

  1313.             }else{
    1314. 

  1314.                 $templates->set_var ('_languageid', "");
    1315. 

  1315.             }
    1316. 

  1316. 

  1317.             $templates->set_var ('site_admin_url', $_CONF['site_admin_url']);
    1318. 

  1318.             $templates->set_var ('site_url',$_CONF['site_url']);
    1319. 

  1319.         
    1320. 

  1320.             $templates->set_var('xhtml', XHTML);
    1321. 

  1321.             $templates->set_var('layout_url', $_CONF['layout_url']);
    1322. 

  1322.         
    1323. 

  1323.             $templates->set_var ('site_name', $_CONF['site_name']);
    1324. 

  1324.             $templates->set_var ('site_mail', $_CONF['site_mail']);
    1325. 

  1325.         
    1326. 

  1326.             $currenturl= COM_getCurrentURL();
    1327. 

  1327.             $templates->set_var ('currenturl', htmlspecialchars($currenturl, ENT_QUOTES, 'UTF-8'));
    1328. 

  1328.             //facebook
    1329. 

  1329.             $facebook_consumer_key = trim($_CONF['facebook_consumer_key']);
    1330. 

  1330.             $templates->set_var ('facebook_consumer_key', $facebook_consumer_key);
    1331. 

  1331.             //
    1332. 

  1332. 

  1333.             //daft_flag管理者の時
    1334. 

  1334.             if ($A['draft_flag']==1){
    1335. 

  1335.                 $templates->set_var ('draft', "draft!");
    1336. 

  1336.             }else{
    1337. 

  1337.                 $templates->set_var ('draft', "");
    1338. 

  1338.             }
    1339. 

  1339.             //------------
    1340. 

  1340. 

  1341.             //id
    1342. 

  1342.             $templates->set_var('lang_id', $LANG_USERBOX_ADMIN['id']);
    1343. 

  1343.             $templates->set_var ('id', $A['id']);
    1344. 

  1344. 

  1345.             $templates->set_var('lang_fields', $LANG_USERBOX_ADMIN['fields']);
    1346. 

  1346.             $templates->set_var('lang_field', $LANG_USERBOX_ADMIN['field']);
    1347. 

  1347.             $templates->set_var('lang_templatesetvar', $LANG_USERBOX_ADMIN['templatesetvar']);
    1348. 

  1348.             $templates->set_var('lang_content', $LANG_USERBOX_ADMIN['content']);
    1349. 

  1349.             $templates->set_var('lang_type', $LANG_USERBOX_ADMIN['type']);
    1350. 

  1350.             $templates->set_var('lang_byusingid', $LANG_USERBOX_ADMIN['byusingid']);
    1351. 

  1351.             $templates->set_var('lang_byusingcode', $LANG_USERBOX_ADMIN['byusingcode']);
    1352. 

  1352.             $templates->set_var('lang_byusingtemplatesetvar', $LANG_USERBOX_ADMIN['byusingtemplatesetvar']);
    1353. 

  1353.             $templates->set_var('lang_group', $LANG_USERBOX_ADMIN['group']);
    1354. 

  1354.             $templates->set_var('lang_withlink', $LANG_USERBOX_ADMIN['withlink']);
    1355. 

  1355.             $templates->set_var('lang_groupbygroup', $LANG_USERBOX_ADMIN['groupbygroup']);
    1356. 

  1356. 

  1357.             $templates->set_var('lang_uid', $LANG28['2']);
    1358. 

  1358.             $templates->set_var('lang_username', $LANG28['3']);
    1359. 

  1359.             $templates->set_var ('username', $A['username']);
    1360. 

  1360.             $templates->set_var('lang_fullname', $LANG28['4']);
    1361. 

  1361.             $templates->set_var ('fullname', $A['fullname']);
    1362. 

  1362.         
    1363. 

  1363.             $templates->set_var('lang_photo', $LANG04['77']);
    1364. 

  1364.             if (isset($A['photo']) && empty($A['photo'])) {
    1365. 

  1365.                 $A['photo'] = '(none)'; // user does not have a photo
    1366. 

  1366.                 $templates->set_var('photo', "");
    1367. 

  1367.             }else{
    1368. 

  1368.                 $templates->set_var('photo', $A['photo']);
    1369. 

  1369.             }
    1370. 

  1370.             //$photo = USER_getPhoto($A['id'], $A['photo'], $A['email'], -1);
    1371. 

  1371.             //$templates->set_var('user_photo', $photo);
    1372. 

  1372.         
    1373. 

  1373.         
    1374. 

  1374.             //$_USERBOX_CONF
    1375. 

  1375.             $templates->set_var('lang_imgfile_frd', $LANG_confignames['userbox']['imgfile_frd']);
    1376. 

  1376.             $templates->set_var ('imgfile_frd', $_USERBOX_CONF['imgfile_frd']);
    1377. 

  1377.             $templates->set_var ('data_img_url', $_CONF['site_url']."/".$_USERBOX_CONF['imgfile_frd']);
    1378. 

  1378.             $templates->set_var('lang_imgfile_thumb_frd', $LANG_confignames['userbox']['imgfile_thumb_frd']);
    1379. 

  1379.             $templates->set_var ('imgfile_thumb_frd', $_USERBOX_CONF['imgfile_thumb_frd']);
    1380. 

  1380.             $templates->set_var ('data_thumb_img_url', $_CONF['site_url']."/".$_USERBOX_CONF['imgfile_thumb_frd']);
    1381. 

  1381. 

  1382.             //基本項目
    1383. 

  1383.             $templates->set_var('lang_basicfields', $LANG_USERBOX_ADMIN['basicfields']);
    1384. 

  1384.             //コード＆タイトル＆説明
    1385. 

  1385.             $templates->set_var('lang_code', $LANG_USERBOX_ADMIN['code']);
    1386. 

  1386.             $templates->set_var ('code', $A['username']);
    1387. 

  1387.             $templates->set_var('lang_title', $LANG_USERBOX_ADMIN['title']);
    1388. 

  1388.             $templates->set_var ('title',$A['fullname']);
    1389. 

  1389. 

  1390.             $templates->set_var('lang_description', $LANG_USERBOX_ADMIN['description']);
    1391. 

  1391.             $templates->set_var ('description',$A['description']);
    1392. 

  1392.         
    1393. 

  1393.             $templates->set_var('lang_draft', $LANG_USERBOX_ADMIN['draft']);
    1394. 

  1394.             if ($A['draft_flag']){
    1395. 

  1395.                 $templates->set_var ('draft',$LANG_USERBOX_ADMIN['draft']);
    1396. 

  1396.             }else{
    1397. 

  1397.                 $templates->set_var ('draft',"");
    1398. 

  1398.             }
    1399. 

  1399.             //hits
    1400. 

  1400.             $templates->set_var('lang_hits', $LANG_USERBOX_ADMIN['hits']);
    1401. 

  1401.             $templates->set_var ('hits', $A['hits']);
    1402. 

  1402.             //カテゴリ@@@@@
    1403. 

  1403.             $templates->set_var('lang_category', $LANG_USERBOX_ADMIN['category']);
    1404. 

  1404.             DATABOX_getcategoriesDisp($A['id'],$templates,$chk_user,0,$pi_name);
    1405. 

  1405. 

  1406.             //追加項目
    1407. 

  1407.             $templates->set_var('lang_additionfields', $LANG_USERBOX_ADMIN['additionfields']);
    1408. 

  1408.             DATABOX_getaddtionfieldsDisp($additionfields,$addition_def,$templates,$chk_user,$pi_name,$fieldset_id);
    1409. 

  1409. 

  1410.             //編集日付
    1411. 

  1411.             $templates->set_var('lang_modified', $LANG_USERBOX_ADMIN['modified']);
    1412. 

  1412.             $wary = COM_getUserDateTimeFormat($A['modified_un']);
    1413. 

  1413.             $templates->set_var ('modified',$wary[0]);
    1414. 

  1414.             $templates->set_var ('modified_shortdate', strftime( $_CONF['shortdate'], $A['modified_un'] ));
    1415. 

  1415.             $templates->set_var ('modified_date', strftime( $_CONF['date'], $A['modified_un'] ));
    1416. 

  1416.             $templates->set_var ('modified_daytime', strftime( $_CONF['daytime'], $A['modified_un'] ));
    1417. 

  1417.             $templates->set_var ('modified_dateonly', strftime( $_CONF['dateonly'], $A['modified_un'] ));
    1418. 

  1418.             $templates->set_var ('modified_timeonly', strftime( $_CONF['timeonly'], $A['modified_un'] ));
    1419. 

  1419.             $templates->set_var ('modified_b', strftime( "%b" , $A['modified_un']));
    1420. 

  1420.             $templates->set_var ('modified_B', strftime( "%B" , $A['modified_un']));
    1421. 

  1421.             $templates->set_var ('modified_d', strftime( "%d" , $A['modified_un']));
    1422. 

  1422.             $templates->set_var ('modified_e', strftime( "%e" , $A['modified_un']));
    1423. 

  1423.             //作成日付
    1424. 

  1424.             $templates->set_var('lang_created', $LANG_USERBOX_ADMIN['created']);
    1425. 

  1425.             $wary = COM_getUserDateTimeFormat($A['created_un']);
    1426. 

  1426.             $templates->set_var ('created', $wary[0]);
    1427. 

  1427.             $templates->set_var ('created_shortdate', strftime( $_CONF['shortdate'], $A['created_un'] ));
    1428. 

  1428.             $templates->set_var ('created_date', strftime( $_CONF['date'], $A['created_un'] ));
    1429. 

  1429.             $templates->set_var ('created_daytime', strftime( $_CONF['daytime'], $A['created_un'] ));
    1430. 

  1430.             $templates->set_var ('created_dateonly', strftime( $_CONF['dateonly'], $A['created_un'] ));
    1431. 

  1431.             $templates->set_var ('created_timeonly', strftime( $_CONF['timeonly'], $A['created_un'] ));
    1432. 

  1432.             $templates->set_var ('created_b', strftime( "%b" , $A['created_un']));
    1433. 

  1433.             $templates->set_var ('created_B', strftime( "%B" , $A['created_un']));
    1434. 

  1434.             $templates->set_var ('created_d', strftime( "%d" , $A['created_un']));
    1435. 

  1435.             $templates->set_var ('created_e', strftime( "%e" , $A['created_un']));
    1436. 

  1436.             //公開日
    1437. 

  1437.             $templates->set_var('lang_released', $LANG_USERBOX_ADMIN['released']);
    1438. 

  1438.             $wary = COM_getUserDateTimeFormat($A['released_un']);
    1439. 

  1439.             $templates->set_var ('released', $wary[0]);
    1440. 

  1440.             $templates->set_var ('released_shortdate', strftime( $_CONF['shortdate'], $A['released_un'] ));
    1441. 

  1441.             $templates->set_var ('released_date', strftime( $_CONF['date'], $A['released_un'] ));
    1442. 

  1442.             $templates->set_var ('released_daytime', strftime( $_CONF['daytime'], $A['released_un'] ));
    1443. 

  1443.             $templates->set_var ('released_dateonly', strftime( $_CONF['dateonly'], $A['released_un'] ));
    1444. 

  1444.             $templates->set_var ('released_timeonly', strftime( $_CONF['timeonly'], $A['released_un'] ));
    1445. 

  1445.             $templates->set_var ('released_b', strftime( "%b" , $A['released_un']));
    1446. 

  1446.             $templates->set_var ('released_B', strftime( "%B" , $A['released_un']));
    1447. 

  1447.             $templates->set_var ('released_d', strftime( "%d" , $A['released_un']));
    1448. 

  1448.             $templates->set_var ('released_e', strftime( "%e" , $A['released_un']));
    1449. 

  1449.              //公開終了日
    1450. 

  1450.             $templates->set_var('lang_expired', $LANG_USERBOX_ADMIN['expired']);
    1451. 

  1451.             if ($A['expired'] ==="0000-00-00 00:00:00"){
    1452. 

  1452.                 $templates->set_var ('expired', "");
    1453. 

  1453.                 $templates->set_var ('expired_shortdate', "" );
    1454. 

  1454.                 $templates->set_var ('expired_date', "" );
    1455. 

  1455.                 $templates->set_var ('expired_daytime', "" );
    1456. 

  1456.                 $templates->set_var ('expired_dateonly', "" );
    1457. 

  1457.                 $templates->set_var ('expired_timeonly', "" );
    1458. 

  1458.                 $templates->set_var ('expired_b', "" );
    1459. 

  1459.                 $templates->set_var ('expired_B', "" );
    1460. 

  1460.                 $templates->set_var ('expired_d', "" );
    1461. 

  1461.                 $templates->set_var ('expired_e', "" );
    1462. 

  1462.             }else{
    1463. 

  1463.                 $wary = COM_getUserDateTimeFormat($A['expired_un']);
    1464. 

  1464.                 $templates->set_var ('expired', $wary[0]);
    1465. 

  1465.                 $templates->set_var ('expired_shortdate', strftime( $_CONF['shortdate'], $A['expired_un'] ));
    1466. 

  1466.                 $templates->set_var ('expired_date', strftime( $_CONF['date'], $A['expired_un'] ));
    1467. 

  1467.                 $templates->set_var ('expired_daytime', strftime( $_CONF['daytime'], $A['expired_un'] ));
    1468. 

  1468.                 $templates->set_var ('expired_dateonly', strftime( $_CONF['dateonly'], $A['expired_un'] ));
    1469. 

  1469.                 $templates->set_var ('expired_timeonly', strftime( $_CONF['timeonly'], $A['expired_un'] ));
    1470. 

  1470.                 $templates->set_var ('expired_b', strftime( "%b" , $A['expired_un']));
    1471. 

  1471.                 $templates->set_var ('expired_B', strftime( "%B" , $A['expired_un']));
    1472. 

  1472.                 $templates->set_var ('expired_d', strftime( "%d" , $A['expired_un']));
    1473. 

  1473.                 $templates->set_var ('expired_e', strftime( "%e" , $A['expired_un']));
    1474. 

  1474.             }
    1475. 

  1475. 

  1476.             $templates->set_var ('lang_uuid', $LANG_USERBOX_ADMIN['uuid']);
    1477. 

  1477.             $templates->set_var ('uuid', $A['uuid']);
    1478. 

  1478. 

  1479.             $templates->set_var ('lang_udatetime', $LANG_USERBOX_ADMIN['udatetime']);
    1480. 

  1480.             $wary = COM_getUserDateTimeFormat($A['udatetime_un']);
    1481. 

  1481.             $templates->set_var ('udatetime', $wary[0]);
    1482. 

  1482.             $templates->set_var ('last_modify_uid', $A['uuid']);
    1483. 

  1483.             $templates->set_var ('last_modify_name', $A['last_modify_name']);
    1484. 

  1484.             $templates->set_var ('last_modify_fullname', $A['last_modify_fullname']);
    1485. 

  1485. 

  1486.             //管理者の時「編集」
    1487. 

  1487.             $templates->set_var ('edit', "");
    1488. 

  1488. 

  1489.             if ($m<>"view"){
    1490. 

  1490. 

  1491.                 if ( SEC_hasRights('userbox.admin')) {
    1492. 

  1492.                     $icon_url = $_CONF['layout_url'] . '/images/edit.' . $_IMAGE_TYPE;
    1493. 

  1493.                     $attr = array('title' => $A['username']." ".$LANG_USERBOX_ADMIN['edit']);
    1494. 

  1494.                     $editiconhtml = COM_createImage($icon_url, $LANG_USERBOX_ADMIN['edit'], $attr);
    1495. 

  1495.                     $attr = array('class' => 'editlink', 'title' => $A['username']." ".   $LANG_USERBOX_ADMIN['edit']);
    1496. 

  1496.                     $url = $_CONF['site_admin_url'];
    1497. 

  1497.                     $url .= '/plugins/userbox/profile.php';
    1498. 

  1498.                     $url .= '?mode=edit';
    1499. 

  1499.                     $url .= '&amp;'."id={$id}";
    1500. 

  1500.                     $icon = '&nbsp;' ;
    1501. 

  1501.                     $icon .=  COM_createLink( $editiconhtml,  $url,   $attr   );
    1502. 

  1502.                     $templates->set_var ('edit', $icon);
    1503. 

  1503.                 }else{
    1504. 

  1504.                     if ($id===$_USER['uid']){
    1505. 

  1505.                         $icon_url = $_CONF['layout_url'] . '/images/edit.' . $_IMAGE_TYPE;
    1506. 

  1506.                         $attr = array('title' => $LANG_USERBOX_ADMIN['edit']);
    1507. 

  1507.                         $editiconhtml = COM_createImage($icon_url, $LANG_USERBOX_ADMIN['edit'], $attr);
    1508. 

  1508.                         $attr = array('class' => 'editlink', 'title' => $A['username']." ".$LANG_USERBOX_ADMIN['edit']);
    1509. 

  1509.                         $url = $_CONF['site_url'];
    1510. 

  1510.                         $url .= '/userbox/myprofile/profile.php';
    1511. 

  1511.                         $icon = '&nbsp;' ;
    1512. 

  1512.                         $icon .=  COM_createLink( $editiconhtml,  $url,   $attr   );
    1513. 

  1513.                         $templates->set_var ('edit', $icon);
    1514. 

  1514.                     }
    1515. 

  1515.                 }
    1516. 

  1516.             }
    1517. 

  1517.             // Call to plugins to set template variables in the databox
    1518. 

  1518.             PLG_templateSetVars( 'userbox', $templates );
    1519. 

  1519. 

  1520.             //------------
    1521. 

  1521.             $templates->parse ('output', 'list');
    1522. 

  1522. 

  1523.             $userbox_content = $templates->finish ($templates->get_var ('output'));
    1524. 

  1524.             $display=$userbox_content;
    1525. 

  1525. 			
    1526. 

  1526.             if ($A['draft_flag']!==1){
    1527. 

  1527.                 if (!SEC_hasRights('userbox.admin')) {
    1528. 

  1528.                     $id=$A['id'];
    1529. 

  1529.                     $hits=DB_getItem($_TABLES['USERBOX_stats'],"hits","id={$id}");
    1530. 

  1530.                     if (empty($hits)) {
    1531. 

  1531.                         $hits=0;
    1532. 

  1532.                     }
    1533. 

  1533.                     $fields.="id,hits ";
    1534. 

  1534.                     $values.="$id,$hits + 1";
    1535. 

  1535.                     DB_save($_TABLES['USERBOX_stats'],$fields,$values);
    1536. 

  1536.                 }
    1537. 

  1537.             }
    1538. 

  1538.         }
    1539. 

  1539.     }else{
    1540. 

  1540.         $cache_time=0;
    1541. 

  1541.         if ($nohitmsg==="yes"){
    1542. 

  1542.             $tmplfld=DATABOX_templatePath('profile',$template,$pi_name);
    1543. 

  1543.             $templates = new Template($tmplfld);
    1544. 

  1544.             $templates->set_file (array (
    1545. 

  1545.                 'list' => 'nohit.thtml',
    1546. 

  1546.             ));
    1547. 

  1547.             $templates->set_var ('lang_nohit', $LANG_USERBOX['nohit']);
    1548. 

  1548.             $templates->set_var('xhtml', XHTML);
    1549. 

  1549.             $templates->set_var('site_url', $_CONF['site_url']);
    1550. 

  1550.             $templates->set_var('site_admin_url', $_CONF['site_admin_url']);
    1551. 

  1551.             $templates->set_var('layout_url', $_CONF['layout_url']);
    1552. 

  1552. 

  1553.             $templates->parse ('output', 'list');
    1554. 

  1554.             $databox_content = $templates->finish ($templates->get_var ('output'));
    1555. 

  1555.             $display =$databox_content;
    1556. 

  1556.             
    1557. 

  1557.         }
    1558. 

  1558.     }
    1559. 

  1559.     $display =PLG_replacetags ($display);
    1560. 

  1560. 		
    1561. 

  1561.     if  (($cache_time > 0 OR $cache_time == -1)  AND  $m==="page" ){
    1562. 

  1562.         CACHE_create_instance($cacheInstance."_display", $display); 
    1563. 

  1563.         CACHE_create_instance($cacheInstance."_layout", $layout); 
    1564. 

  1564.         CACHE_create_instance($cacheInstance."_headercode", $headercode); 
    1565. 

  1565.         CACHE_create_instance($cacheInstance."_title", $title); 
    1566. 

  1566.     }
    1567. 

  1567. 

  1568.     $retval['display']=$display;
    1569. 

  1569.     $retval['layout']=$layout;
    1570. 

  1570.     $retval['headercode']=$headercode;
    1571. 

  1571.     $retval['title']=$title;
    1572. 

  1572. 

  1573. 

  1574.     return $retval;
    1575. 

  1575. }
    1576. 

  1576. 

  1577. 

  1578. 

  1579. function userbox_field(
    1580. 

  1580.     $autotag
    1581. 

  1581.     ,$field_id=null
    1582. 

  1582.     ,$value=""
    1583. 

  1583.     ,$template=null
    1584. 

  1584.     ,$nohitmsg=""
    1585. 

  1585.     ,$perpage =0
    1586. 

  1586.     ,$page=null
    1587. 

  1587.     ,$order=null
    1588. 

  1588.     ,$field_code=null
    1589. 

  1589. )
    1590. 

  1590. // +---------------------------------------------------------------------------+
    1591. 

  1591. // | 機能  アトリビュート別一覧表示
    1592. 

  1592. // | 書式
    1593. 

  1593. // +---------------------------------------------------------------------------+
    1594. 

  1594. // | 引数 $autotag:notautotagの時ヘッダを表示しない
    1595. 

  1595. // | 引数 $field_id:追加属性id
    1596. 

  1596. // | 引数 $value:表示する項目の値
    1597. 

  1597. // | 引数 $template:使用するテンプレートのフォルダ名
    1598. 

  1598. // | 引数 $nohitmsg      :"yes"の時nohitメッセージ表示
    1599. 

  1599. // | 引数 $perpage       :1pageあたりの件数、0の時改ページなし
    1600. 

  1600. // | 引数 $page           :
    1601. 

  1601. // | 引数 $order         :順序
    1602. 

  1602. // | 引数 $field_code    :
    1603. 

  1603. // +---------------------------------------------------------------------------+
    1604. 

  1604. // | public_html/attribute.php および　自動タグで使用
    1605. 

  1605. // | ヘッダはコンフィギュレーション設定により表示されない場合があります
    1606. 

  1606. // | idもcodeも指定されない場合は、全カテゴリ
    1607. 

  1607. // +---------------------------------------------------------------------------+
    1608. 

  1608. // | 戻値 nomal:category list
    1609. 

  1609. // +---------------------------------------------------------------------------+
    1610. 

  1610. {
    1611. 

  1611.     $pi_name="userbox";
    1612. 

  1612. 

  1613.     global $_CONF;
    1614. 

  1614.     global $_TABLES;
    1615. 

  1615.     global $_USERBOX_CONF;
    1616. 

  1616.     global $LANG_USERBOX;
    1617. 

  1617.     global $LANG_USERBOX_ADMIN;
    1618. 

  1618.     global $LANG_USERBOX_NOYES;
    1619. 

  1619.     global $_IMAGE_TYPE;
    1620. 

  1620.     global $LANG_confignames;
    1621. 

  1621. 

  1622.     //ログイン要否チェック
    1623. 

  1623.     if (COM_isAnonUser()){
    1624. 

  1624.         if  ($_CONF['loginrequired']
    1625. 

  1625.                 OR ($_USERBOX_CONF['loginrequired'] >1) ){
    1626. 

  1626.             return $LANG_USERBOX['loginrequired'];
    1627. 

  1627.         }
    1628. 

  1628. 

  1629.     }
    1630. 

  1630.     //-----table assign
    1631. 

  1631.     $tbl1=$_TABLES['USERBOX_addition'] ;
    1632. 

  1632.     $tbl2=$_TABLES['USERBOX_base'] ;
    1633. 

  1633.     $tbl3=$_TABLES['USERBOX_addition'] ;
    1634. 

  1634.     $tbl4=$_TABLES['users'] ;
    1635. 

  1635.     $tbl5=$_TABLES['USERBOX_stats'];
    1636. 

  1636.     
    1637. 

  1637.     //日付関連
    1638. 

  1638.     $datefield=$_USERBOX_CONF['datefield'];//使用する日付（編集日付、作成日付）
    1639. 

  1639.     $new_img=$_USERBOX_CONF['new_img'];
    1640. 

  1640.     if ($new_img==""){
    1641. 

  1641.         $new_img="New!";
    1642. 

  1642.     }
    1643. 

  1643.     $newmarkday=$_USERBOX_CONF['newmarkday'];
    1644. 

  1644.     if ($newmarkday==""){
    1645. 

  1645.         $newmarkday=3;
    1646. 

  1646.     }
    1647. 

  1647.     $chkday=strtotime("- $newmarkday days",time());
    1648. 

  1648. 

  1649.     //-----引数チェック
    1650. 

  1650.     if (is_null($value) OR $value==="") {
    1651. 

  1651.         return;
    1652. 

  1652.     }
    1653. 

  1653.     if (is_null($field_id)){
    1654. 

  1654.         if ($field_code===""){
    1655. 

  1655.             $field_id=0;
    1656. 

  1656.         }else{
    1657. 

  1657.             $field_id=DATABOX_codetoid($field_code,'USERBOX_def_field',"field_id","templatesetvar");
    1658. 

  1658. 

  1659.         }
    1660. 

  1660.     }
    1661. 

  1661.     if ($field_id===0) {
    1662. 

  1662.         return;
    1663. 

  1663.     }
    1664. 

  1664.     
    1665. 

  1665.     if ($field_code===""){
    1666. 

  1666.         $field_code=DB_getItem( $_TABLES['USERBOX_def_field']
    1667. 

  1667.                  ,"templatesetvar","field_id={$field_id}");
    1668. 

  1668.     }
    1669. 

  1669.     $field_def=DATABOX_getadditiondef($pi_name);
    1670. 

  1670.     $type=$field_def[$field_id]['type'];
    1671. 

  1671.     $w = array(0,2,3,4,7,8,9,16);
    1672. 

  1672.     if (in_array ($type,$w)){
    1673. 

  1673.     }else{
    1674. 

  1674.         return;
    1675. 

  1675.     }
    1676. 

  1676.     $allow_display=$field_def[$field_id]['allow_display'];
    1677. 

  1677.     if ($allow_display<2){
    1678. 

  1678.     }else{
    1679. 

  1679.         return;
    1680. 

  1680.     }
    1681. 

  1681. 

  1682.     if (is_null($page) OR !isset($page) OR $page == 0) {
    1683. 

  1683.         $page = 1;
    1684. 

  1684.     }
    1685. 

  1685. 

  1686.     if ($perpage===0 OR is_null($perpage)){
    1687. 

  1687.         $perpage=$_USERBOX_CONF['perpage'];
    1688. 

  1688.     }
    1689. 

  1689. 

  1690. 

  1691.     $w=userbox_orderby($datefield,$order,$orderby,$addfieldorder,$orderfield_id);
    1692. 

  1692.     $field_def[$field_id]['name'];
    1693. 

  1693.     $field_name=$field_def[$field_id]['name'];
    1694. 

  1694.     $field_templatesetvar=$field_def[$field_id]['templatesetvar'];
    1695. 

  1695.     $field_description=$field_def[$field_id]['description'];
    1696. 

  1696. 

  1697.     $fieldvalue=DATABOX_getfieldvalue(
    1698. 

  1698.           $value
    1699. 

  1699.          ,$field_def[$field_id]['type']
    1700. 

  1700.          ,$field_def[$field_id]['selectionary']
    1701. 

  1701.          ,$LANG_USERBOX_NOYES
    1702. 

  1702.          ,$field_def[$field_id]['selectlist']
    1703. 

  1703.          ,$pi_name
    1704. 

  1704.           );
    1705. 

  1705. 

  1706. 

  1707.     if (is_null($template) or ($template==="")){
    1708. 

  1708.         $template="default";
    1709. 

  1709.     }
    1710. 

  1710. 

  1711. 

  1712.     //-----
    1713. 

  1713.     $sql = "SELECT ";
    1714. 

  1714. 

  1715.     $sql .= " t2.id ".LB;
    1716. 

  1716.     $sql .= " ,t2.description ".LB;
    1717. 

  1717.     $sql .= " ,t2.released ".LB;
    1718. 

  1718.     $sql .= " ,t2.".$datefield." AS datefield ".LB;
    1719. 

  1719.     $sql .= " ,t2.expired ".LB;
    1720. 

  1720.     $sql .= " ,UNIX_TIMESTAMP(t2.".$datefield.") AS datefield_un ".LB;
    1721. 

  1721.     $sql .= " ,UNIX_TIMESTAMP(t2.released ) AS released_un ".LB;
    1722. 

  1722.     $sql .= " ,UNIX_TIMESTAMP(t2.expired ) AS expired_un ".LB;
    1723. 

  1723. 

  1724.     $sql .= " ,t2.group_id";
    1725. 

  1725.     $sql .= " ,t2.owner_id";
    1726. 

  1726.     $sql .= " ,t2.fieldset_id ".LB;
    1727. 

  1727. 

  1728.     $sql .= " ,t4.username";
    1729. 

  1729.     $sql .= " ,t4.fullname";
    1730. 

  1730.     $sql .= " ,t4.photo";
    1731. 

  1731.     $sql .= " ,t4.email";
    1732. 

  1732.     
    1733. 

  1733.     if ($addfieldorder){
    1734. 

  1734.         $sql .= " ,t3.value ".LB;
    1735. 

  1735.     }
    1736. 

  1736. 

  1737. 

  1738.     $sql .= " FROM ".LB;
    1739. 

  1739.     $sql .= " {$tbl2} AS t2 ".LB;
    1740. 

  1740.     $sql .= " ,{$tbl1} AS t1 ".LB;
    1741. 

  1741.     $sql .= " ,{$tbl4} AS t4 ".LB;
    1742. 

  1742.     if ($addfieldorder){
    1743. 

  1743.         $sql .= " ,{$tbl3} AS t3 ".LB;
    1744. 

  1744.     }
    1745. 

  1745. 

  1746.     $sql .= " WHERE ".LB;
    1747. 

  1747.     $sql .= " t1.field_id = ".$field_id.LB;
    1748. 

  1748.     $sql .= " AND t1.id = t2.id ".LB;
    1749. 

  1749.     $sql .= " AND t1.value = \"".$value."\"".LB;
    1750. 

  1750.     $sql .= " AND t2.id=t4.uid ".LB;
    1751. 

  1751.     if ($addfieldorder){
    1752. 

  1752.         $sql .= " AND t3.field_id=".$orderfield_id.LB;
    1753. 

  1753.         $sql .= " AND t3.id=t2.id".LB;
    1754. 

  1754.     }
    1755. 

  1755.     //管理者の時,下書データも含む
    1756. 

  1756.     //if ( SEC_hasRights('userbox.admin')) {
    1757. 

  1757.     //}else{
    1758. 

  1758.        $sql .= " AND t2.draft_flag=0".LB;
    1759. 

  1759.     //}
    1760. 

  1760. 

  1761.     //アクセス権のないデータ はのぞく
    1762. 

  1762.     $sql .= COM_getPermSql('AND',0,2,"t2");
    1763. 

  1763. 

  1764.     //公開日以前のデータはのぞく
    1765. 

  1765.     $sql .= " AND (released <= NOW())".LB;
    1766. 

  1766.     //公開終了日を過ぎたデータはのぞく
    1767. 

  1767.     $sql .= " AND (expired=0 OR expired > NOW())";
    1768. 

  1768.     
    1769. 

  1769.     $sql .= " ORDER BY ".LB;
    1770. 

  1770.     $sql .= $orderby.LB;
    1771. 

  1771. 

  1772.     $result = DB_query ($sql);
    1773. 

  1773.     $cnt = DB_numRows ($result);
    1774. 

  1774. 

  1775.     $pages = 0;
    1776. 

  1776.     if ($perpage > 0) {
    1777. 

  1777.         $pages = ceil($cnt / $perpage);
    1778. 

  1778.     }
    1779. 

  1779.     $offset = ($page - 1) * $perpage;
    1780. 

  1780.     $sql .= " LIMIT $offset, $perpage";
    1781. 

  1781.     
    1782. 

  1782.     //ヘッダ、左ブロック
    1783. 

  1783.     if ($autotag==="notautotag"){
    1784. 

  1784.         if ($page > 1) {
    1785. 

  1785.             $page_title = sprintf ('%s (%d)', $field_name, $page);
    1786. 

  1786.         } else {
    1787. 

  1787.             $page_title = sprintf ('%s ', $field_name);
    1788. 

  1788.         }
    1789. 

  1789.         $headercode=DATABOX_getheadercode(    
    1790. 

  1790.             "attribute"
    1791. 

  1791.             ,$template
    1792. 

  1792.             ,$pi_name
    1793. 

  1793.             ,$field_id
    1794. 

  1794.             ,$field_name
    1795. 

  1795.             ,$field_description
    1796. 

  1796.             ,$field_name
    1797. 

  1797.             ,$field_description);
    1798. 

  1798.         $retval .= DATABOX_siteHeader($pi_name,'',$page_title,$headercode);
    1799. 

  1799.     }
    1800. 

  1800.     
    1801. 

  1801.     $addition_def=DATABOX_getadditiondef($pi_name);
    1802. 

  1802.     //
    1803. 

  1803.     $url=$_CONF['site_url']."/userbox/attribute.php";
    1804. 

  1804.     $attribute_top="<a href='".$url."'>".$LANG_USERBOX['attribute_top']."</a>";
    1805. 

  1805.     $url=$_CONF['site_url']."/userbox/attribute.php";
    1806. 

  1806.     $url.="?";
    1807. 

  1807.     $url.="id=".$field_id;
    1808. 

  1808.     $url.="&amp;m=id";
    1809. 

  1809.     $field_top="<a href='".$url."'>".$field_name.$LANG_USERBOX['countlist']."</a>";
    1810. 

  1810. 

  1811.     $result = DB_query ($sql);
    1812. 

  1812.     $numrows = DB_numRows ($result);
    1813. 

  1813. 

  1814.     if ($numrows > 0) {
    1815. 

  1815.         $tmplfld=DATABOX_templatePath('attribute',$template,$pi_name);
    1816. 

  1816.         $templates = new Template($tmplfld);
    1817. 

  1817.         $templates->set_file (array (
    1818. 

  1818.             'list' => 'list_detail.thtml',
    1819. 

  1819.             'nav'   => 'navigation_detail.thtml',
    1820. 

  1820.             'row'   => 'row.thtml',
    1821. 

  1821.             'col'   => "col_detail.thtml",
    1822. 

  1822.             'pagenav'  => 'pagenavigation.thtml'
    1823. 

  1823.             ));
    1824. 

  1824.         
    1825. 

  1825.         $languageid=COM_getLanguageId();
    1826. 

  1826.         $language= COM_getLanguage();
    1827. 

  1827.         $templates->set_var ('languageid', $languageid);
    1828. 

  1828.         $templates->set_var ('language', $language);
    1829. 

  1829.         if ($languageid<>"") {
    1830. 

  1830.             $templates->set_var ('_languageid', "_".$languageid);
    1831. 

  1831.         }else{
    1832. 

  1832.             $templates->set_var ('_languageid', "");
    1833. 

  1833.         }
    1834. 

  1834.         
    1835. 

  1835.         //
    1836. 

  1836.         $templates->set_var ('site_url',$_CONF['site_url']);
    1837. 

  1837.         $templates->set_var ('this_script',THIS_SCRIPT);
    1838. 

  1838. 

  1839.         //bread
    1840. 

  1840.         $templates->set_var ('home',$LANG_USERBOX['home']);
    1841. 

  1841.         $templates->set_var ('attribute_top',$addition_top);
    1842. 

  1842.         $templates->set_var ('field_top',$field_top);
    1843. 

  1843.         
    1844. 

  1844.         $templates->set_var ('field_name',$field_name);
    1845. 

  1845.         $templates->set_var ('field_templatesetvar',$field_templatesetvar);
    1846. 

  1846.         $templates->set_var ('field_description',$field_description);
    1847. 

  1847. 

  1848.         $templates->set_var ('fieldvalue',$fieldvalue);
    1849. 

  1849. 

  1850.         //page
    1851. 

  1851.         $offset = ($page - 1) * $perpage;
    1852. 

  1852.         $templates->set_var ('cnt', $cnt);
    1853. 

  1853.         $lin1=$offset+1;
    1854. 

  1854.         $lin2=$lin1+$perpage - 1;
    1855. 

  1855.         if ($lin2>$cnt){
    1856. 

  1856.             $lin2=$cnt;
    1857. 

  1857.         }
    1858. 

  1858. 

  1859.         //summary navigation
    1860. 

  1860.         $templates->set_var ('lang_view', $LANG_USERBOX['view']);
    1861. 

  1861.         $templates->set_var ('lin', $lin1."-".($lin2));
    1862. 

  1862.         $templates->set_var ('cnt', $cnt);
    1863. 

  1863. 

  1864.         $templates->set_var ('lang_name', $LANG_USERBOX_ADMIN['name']);
    1865. 

  1865. 

  1866.         $templates->set_var ('lang_username', $LANG_USERBOX_ADMIN['username']);
    1867. 

  1867.         $templates->set_var ('lang_id', $LANG_USERBOX_ADMIN['id']);
    1868. 

  1868.         $templates->set_var ('lang_uid', $LANG28[2]);
    1869. 

  1869.         $templates->set_var ('lang_username', $LANG28[3]);
    1870. 

  1870.         $templates->set_var ('lang_fullname',$LANG28[4]);
    1871. 

  1871. 

  1872.         //
    1873. 

  1873.         $templates->set_var ('lang_date', $LANG_USERBOX_ADMIN[$datefield]);
    1874. 

  1874.         $templates->set_var ('lang_released', $LANG_USERBOX_ADMIN['released']);
    1875. 

  1875.         $templates->set_var ('lang_description', $LANG_USERBOX_ADMIN['description']);
    1876. 

  1876.         $templates->set_var ('lang_expired', $LANG_DATABOX_ADMIN['expired']);
    1877. 

  1877.         $templates->set_var ('lang_remaingdays', $LANG_DATABOX_ADMIN['remaingdays']);
    1878. 

  1878.         $templates->set_var ('lang_addfield', $addfield_name);
    1879. 

  1879.         
    1880. 

  1880.         //$_USERBOX_CONF
    1881. 

  1881.         $templates->set_var('lang_imgfile_frd', $LANG_confignames['userbox']['imgfile_frd']);
    1882. 

  1882.         $templates->set_var ('imgfile_frd', $_USERBOX_CONF['imgfile_frd']);
    1883. 

  1883.         $templates->set_var ('data_img_url', $_CONF['site_url']."/".$_USERBOX_CONF['imgfile_frd']);
    1884. 

  1884.         $templates->set_var('lang_imgfile_thumb_frd', $LANG_confignames['userbox']['imgfile_thumb_frd']);
    1885. 

  1885.         $templates->set_var ('imgfile_thumb_frd', $_USERBOX_CONF['imgfile_thumb_frd']);
    1886. 

  1886.         $templates->set_var ('data_thumb_img_url', $_CONF['site_url']."/".$_DATABOX_CONF['imgfile_thumb_frd']);
    1887. 

  1887.         
    1888. 

  1888.          for ($i = 0; $i < $numrows; $i++) {
    1889. 

  1889.             $A = DB_fetchArray ($result);
    1890. 

  1890.             $A = array_map('stripslashes', $A);
    1891. 

  1891. 

  1892.             $description=COM_applyFilter($A['description']);
    1893. 

  1893.             $username=COM_applyFilter($A['username']);
    1894. 

  1894.             $fullname=COM_applyFilter($A['fullname']);
    1895. 

  1895.             $id=COM_applyFilter($A['id']);
    1896. 

  1896.             $datefield=COM_applyFilter($A['datefield']);
    1897. 

  1897.             $released=COM_applyFilter($A['released']);
    1898. 

  1898.             $expired=COM_applyFilter($A['expired']);
    1899. 

  1899.             $datefield_ary = COM_getUserDateTimeFormat($A['datefield_un']);
    1900. 

  1900.             $released_ary = COM_getUserDateTimeFormat($A['released_un']);
    1901. 

  1901.             if ($expired==="0000-00-00 00:00:00"){
    1902. 

  1902.                 $expired_ary=array();
    1903. 

  1903.             }else{    
    1904. 

  1904.                 $expired_ary = COM_getUserDateTimeFormat($A['expired_un']);
    1905. 

  1905.             }
    1906. 

  1906.             $curdate_ary =  COM_getUserDateTimeFormat();
    1907. 

  1907.             
    1908. 

  1908.             $sortvalue=COM_applyFilter($A['value']);
    1909. 

  1909.             $group_id = $A['group_id'];
    1910. 

  1910.             $owner_id = $A['owner_id'];
    1911. 

  1911.             
    1912. 

  1912.             $fieldset_id=COM_applyFilter($A['fieldset_id']);
    1913. 

  1913. 

  1914.             $url=$_CONF['site_url'] . "/userbox/profile.php";
    1915. 

  1915.             $url.="?";
    1916. 

  1916.             //コード使用の時
    1917. 

  1917.             if ($_USERBOX_CONF['datacode']){
    1918. 

  1918.                 $url.="m=code";
    1919. 

  1919.                 $url.="&amp;code=".$A['username'];
    1920. 

  1920.             }else{
    1921. 

  1921.                 $url.="id=".$A['id'];
    1922. 

  1922.                 $url.="&amp;m=id";
    1923. 

  1923.             }
    1924. 

  1924.             $url = COM_buildUrl( $url );
    1925. 

  1925.             $link= COM_createLink($username, $url);
    1926. 

  1926. 

  1927. 

  1928.             $templates->set_var ('data_link', $link);
    1929. 

  1929. 

  1930.             $templates->set_var ('data_fullname', $fullname);
    1931. 

  1931.             $templates->set_var ('data_title', $fullname);
    1932. 

  1932. 

  1933.             $templates->set_var ('data_username', $username);
    1934. 

  1934.             $templates->set_var ('data_code', $username);
    1935. 

  1935. 

  1936.             $templates->set_var ('data_description', $description);
    1937. 

  1937.             $templates->set_var ('data_id', $id);
    1938. 

  1938.             $templates->set_var ('data_url', $url);
    1939. 

  1939.             //data_released
    1940. 

  1940.             $templates->set_var ('data_datefield', $datefield);
    1941. 

  1941.             $templates->set_var ('data_datefield_shortdate', strftime( $_CONF['shortdate'], $A['datefield_un'] ));
    1942. 

  1942.             $templates->set_var ('data_value', $sortvalue);
    1943. 

  1943.             
    1944. 

  1944.             $templates->set_var ('data_released', $released_ary[0]);//@@@@@@
    1945. 

  1945.             $templates->set_var ('data_released_shortdate', strftime( $_CONF['shortdate'], $A['released_un'] ));
    1946. 

  1946.             $templates->set_var ('data_released_date', strftime( $_CONF['date'], $A['released_un'] ));
    1947. 

  1947.             $templates->set_var ('data_released_daytime', strftime( $_CONF['daytime'], $A['released_un'] ));
    1948. 

  1948.             $templates->set_var ('data_released_dateonly', strftime( $_CONF['dateonly'], $A['released_un'] ));
    1949. 

  1949.             $templates->set_var ('data_released_timeonly', strftime( $_CONF['timeonly'], $A['released_un'] ));
    1950. 

  1950.             $templates->set_var ('data_released_b', strftime( "%b" , $A['released_un']));
    1951. 

  1951.             $templates->set_var ('data_released_B', strftime( "%B" , $A['released_un']));
    1952. 

  1952.             $templates->set_var ('data_released_d', strftime( "%d" , $A['released_un']));
    1953. 

  1953.             $templates->set_var ('data_released_e', strftime( "%e" , $A['released_un']));
    1954. 

  1954.             //公開終了日 Expired to publish
    1955. 

  1955.             if ($A['expired'] ==="0000-00-00 00:00:00"){
    1956. 

  1956.                 $templates->set_var ('data_expired', "");
    1957. 

  1957.                 $templates->set_var ('data_expired_shortdate', "" );
    1958. 

  1958.                 $templates->set_var ('data_expired_date', "" );
    1959. 

  1959.                 $templates->set_var ('data_expired_daytime', "" );
    1960. 

  1960.                 $templates->set_var ('data_expired_dateonly', "" );
    1961. 

  1961.                 $templates->set_var ('data_expired_timeonly', "" );
    1962. 

  1962.                 $templates->set_var ('data_expired_b', "" );
    1963. 

  1963.                 $templates->set_var ('data_expired_B', "" );
    1964. 

  1964.                 $templates->set_var ('data_expired_d', "" );
    1965. 

  1965.                 $templates->set_var ('data_expired_e', "" );
    1966. 

  1966.             }else{
    1967. 

  1967.                 $wary = COM_getUserDateTimeFormat($A['expired_un']);
    1968. 

  1968.                 $templates->set_var ('data_expired', $expired_ary[0]);
    1969. 

  1969.                 $templates->set_var ('data_expired_shortdate', strftime( $_CONF['shortdate'], $A['expired_un'] ));
    1970. 

  1970.                 $templates->set_var ('data_expired_daytime', strftime( $_CONF['daytime'], $A['expired_un'] ));
    1971. 

  1971.                 $templates->set_var ('data_expired_dateonly', strftime( $_CONF['dateonly'], $A['expired_un'] ));
    1972. 

  1972.                 $templates->set_var ('data_expired_timeonly', strftime( $_CONF['timeonly'], $A['expired_un'] ));
    1973. 

  1973.                 $templates->set_var ('data_expired_b', strftime( "%b" , $A['expired_un']));
    1974. 

  1974.                 $templates->set_var ('data_expired_B', strftime( "%B" , $A['expired_un']));
    1975. 

  1975.                 $templates->set_var ('data_expired_d', strftime( "%d" , $A['expired_un']));
    1976. 

  1976.                 $templates->set_var ('data_expired_e', strftime( "%e" , $A['expired_un']));
    1977. 

  1977.             }
    1978. 

  1978.             $remaingdays="";
    1979. 

  1979.             if ($expired<>"0000-00-00 00:00:00") {
    1980. 

  1980.                 if  ($expired_ary[1]>=$curdate_ary[1]){
    1981. 

  1981.                     $remaingdays=COM_dateDiff( "d", $expired_ary[1], $curdate_ary[1] ) + 1;
    1982. 

  1982.                 }
    1983. 

  1983.             }
    1984. 

  1984.             $templates->set_var ('data_remaingdays', $remaingdays);//@@@@@@
    1985. 

  1985. 

  1986.             if (date("Ymd",strtotime($datefield)) >= date("Ymd",$chkday)){
    1987. 

  1987.                 $templates->set_var ('new_img', $new_img);
    1988. 

  1988.             }else{
    1989. 

  1989.                 $templates->set_var ('new_img', '');
    1990. 

  1990.             }
    1991. 

  1991. 

  1992.             if (isset($A['photo']) && empty($A['photo'])) {
    1993. 

  1993.                 $A['photo'] = '(none)'; // user does not have a photo
    1994. 

  1994.                 $templates->set_var('data_photo', "");
    1995. 

  1995.             }else{
    1996. 

  1996.                 $templates->set_var('data_photo', $A['photo']);
    1997. 

  1997.             }
    1998. 

  1998.             $photo = USER_getPhoto($uid, $A['photo'], $A['email'], -1);
    1999. 

  1999.             $templates->set_var('data_user_photo', $photo);
    2000. 

  2000. 

  2001.             $hits=COM_applyFilter(DB_getItem( $tbl5 ,"hits","id={$id}"),true);
    2002. 

  2002.             $templates->set_var('lang_hits', $LANG_USERBOX_ADMIN['hits']);
    2003. 

  2003.             $templates->set_var('data_hits', $hits);
    2004. 

  2004.             //カテゴリ categories 
    2005. 

  2005.             $templates->set_var('lang_category', $LANG_DATABOX_ADMIN['category']);
    2006. 

  2006.             DATABOX_getcategoriesDisp($A['id'],$templates,$chk_user,0,$pi_name);
    2007. 

  2007. 

  2008.             //追加項目 fields
    2009. 

  2009.             $group_id = stripslashes($A['group_id']);
    2010. 

  2010.             $owner_id = stripslashes($A['owner_id']);
    2011. 

  2011.             $chk_user=DATABOX_chkuser($group_id,$owner_id,"userbox.admin");
    2012. 

  2012.             $additionfields = DATABOX_getadditiondatas($id,$pi_name);
    2013. 

  2013.             DATABOX_getaddtionfieldsDisp($additionfields,$addition_def,$templates,$chk_user,$pi_name,$fieldset_id);
    2014. 

  2014.             
    2015. 

  2015.             //管理者の時「編集」
    2016. 

  2016.             if ( SEC_hasRights('databox.admin')) {
    2017. 

  2017.                 $icon_url = $_CONF['layout_url'] . '/images/edit.' . $_IMAGE_TYPE;
    2018. 

  2018.                 $attr = array('title' => $title." ".$LANG_USERBOX_ADMIN['edit']);
    2019. 

  2019.                 $editiconhtml = COM_createImage($icon_url, $LANG_USERBOX_ADMIN['edit'], $attr);
    2020. 

  2020.                 
    2021. 

  2021.                 $attr = array('class' => 'editlink', 'title' => $title." ".$LANG_USERBOX_ADMIN['edit']);
    2022. 

  2022.                 $url = $_CONF['site_admin_url'];
    2023. 

  2023.                 $url .= '/plugins/userbox/profile.php';
    2024. 

  2024.                 $url .= '?mode=edit';
    2025. 

  2025.                 $url .= '&amp;'."id={$id}";
    2026. 

  2026.                 $icon = '&nbsp;' ;
    2027. 

  2027.                 $icon .=  COM_createLink( $editiconhtml,  $url,   $attr   );
    2028. 

  2028.                 $templates->set_var ('data_edit', $icon);
    2029. 

  2029.             }else{
    2030. 

  2030.                 $rt=databox_chk_loaddata($id);
    2031. 

  2031.                 //編集権限のあるMyProfile
    2032. 

  2032.                 if ( $rt==="OK") {
    2033. 

  2033.                     $icon_url = $_CONF['layout_url'] . '/images/edit.' . $_IMAGE_TYPE;
    2034. 

  2034.                     $attr = array('title' => $LANG_USERBOX_ADMIN['edit']);
    2035. 

  2035.                     $editiconhtml = COM_createImage($icon_url, $LANG_USERBOX_ADMIN['edit'], $attr);
    2036. 

  2036. 

  2037.                     $attr = array('class' => 'editlink', 'title' => $title." ".$LANG_USERBOX_ADMIN['edit']);
    2038. 

  2038. 

  2039.                     $url = $_CONF['site_url'];
    2040. 

  2040.                     $url .= '/databox/myprofile/profile.php';
    2041. 

  2041.                     $url .= '?mode=edit';
    2042. 

  2042.                     $url .= '&amp;'."id={$id}";
    2043. 

  2043. 

  2044.                     $icon = '&nbsp;' ;
    2045. 

  2045.                     $icon .=  COM_createLink( $editiconhtml,  $url,   $attr   );
    2046. 

  2046. 

  2047.                     $templates->set_var ('data_edit', $icon);
    2048. 

  2048.                 }else{
    2049. 

  2049.                     $templates->set_var ('data_edit', "");
    2050. 

  2050.                 }
    2051. 

  2051.                 
    2052. 

  2052.             }
    2053. 

  2053. 

  2054.             //=====
    2055. 

  2055.             $templates->parse ('col_var', 'col', true);
    2056. 

  2056.             $templates->parse ('row_var', 'row', true);
    2057. 

  2057. 

  2058.             $templates->set_var ('col_var', '');
    2059. 

  2059. 

  2060.         }
    2061. 

  2061. 

  2062.         //------------
    2063. 

  2063.         //-----navigation
    2064. 

  2064.         $url = $_CONF['site_url']  . '/';
    2065. 

  2065.         if ($autotag==="notautotag"){
    2066. 

  2066.             $url.=THIS_SCRIPT;
    2067. 

  2067.         }else{
    2068. 

  2068.             $url.="userbox/field.php";
    2069. 

  2069.         }
    2070. 

  2070.         $url .="?";
    2071. 

  2071.         $url .= "id=".$field_id;
    2072. 

  2072.         $url .= "&amp;m=id";
    2073. 

  2073.         $url .= "&amp;value=".$value;
    2074. 

  2074.         $url .= "&amp;template=".$template;
    2075. 

  2075.         $url .= "&amp;perpage=".$perpage;
    2076. 

  2076.         $url .= "&amp;order=";
    2077. 

  2077.         //-----order navigation
    2078. 

  2078.         userbox_order ($url, $templates, $order) ;
    2079. 

  2079.         //-----page navigation
    2080. 

  2080.         $url .= $order;
    2081. 

  2081.         $templates->set_var ('page_navigation',
    2082. 

  2082.                 COM_printPageNavigation ($url, $page, $pages));
    2083. 

  2083.         if ($order==="random"){
    2084. 

  2084.             $templates->set_var ( 'pagenavinone', 'style="display:none;"' );
    2085. 

  2085.         }else{
    2086. 

  2086.             $templates->set_var ( 'pagenavinone', '' );
    2087. 

  2087.         }
    2088. 

  2088.         // Call to plugins to set template variables in the databox
    2089. 

  2089.         PLG_templateSetVars( 'userbox', $templates );
    2090. 

  2090. 

  2091.         //------------
    2092. 

  2092.         $templates->parse ('nav_var', 'nav', true);
    2093. 

  2093. 

  2094.         $templates->set_var ('msg', "");
    2095. 

  2095. 

  2096.         $templates->parse ('output', 'list');
    2097. 

  2097. 

  2098.         $content = $templates->finish ($templates->get_var ('output'));
    2099. 

  2099.         $retval .=$content;
    2100. 

  2100. 

  2101.     }else{
    2102. 

  2102.         if ($nohitmsg==="yes"){
    2103. 

  2103.             $tmplfld=DATABOX_templatePath('attribute',$template,$pi_name);
    2104. 

  2104.             $templates = new Template($tmplfld);
    2105. 

  2105.             $templates->set_file (array (
    2106. 

  2106.                 'list' => 'nohit.thtml',
    2107. 

  2107.             ));
    2108. 

  2108.             
    2109. 

  2109.             //bread
    2110. 

  2110.             $templates->set_var ('home',$LANG_USERBOX['home']);
    2111. 

  2111.             $templates->set_var ('attribute_top',$attribute_top);
    2112. 

  2112.             $templates->set_var ('field_top',$field_top);
    2113. 

  2113.             
    2114. 

  2114.             $templates->set_var ('field_name',$field_name);
    2115. 

  2115.             $templates->set_var ('field_templatesetvar',$templatesetvar);
    2116. 

  2116.             $templates->set_var ('field_description',$field_description);
    2117. 

  2117.             
    2118. 

  2118.             $templates->set_var ('fieldvalue',$fieldvalue);
    2119. 

  2119.                         
    2120. 

  2120.             $templates->set_var('xhtml', XHTML);
    2121. 

  2121.             $templates->set_var('site_url', $_CONF['site_url']);
    2122. 

  2122.             $templates->set_var('site_admin_url', $_CONF['site_admin_url']);
    2123. 

  2123.             $templates->set_var('layout_url', $_CONF['layout_url']);
    2124. 

  2124.             
    2125. 

  2125.             $templates->set_var ('lang_nohit', $LANG_USERBOX['nohit']);
    2126. 

  2126. 

  2127.             $templates->parse ('output', 'list');
    2128. 

  2128.             $content = $templates->finish ($templates->get_var ('output'));
    2129. 

  2129.             $retval .=$content;
    2130. 

  2130.         }
    2131. 

  2131.     }
    2132. 

  2132. 

  2133.     $retval =PLG_replacetags ($retval);
    2134. 

  2134. 

  2135.     return $retval;
    2136. 

  2136. }
    2137. 

  2137. 

  2138. function userbox_orderby(
    2139. 

  2139.     $datefield
    2140. 

  2140.     ,&$order
    2141. 

  2141.     ,&$orderby
    2142. 

  2142.     ,&$addfieldorder
    2143. 

  2143.     ,&$field_id
    2144. 

  2144. 

  2145. )
    2146. 

  2146. // +---------------------------------------------------------------------------+
    2147. 

  2147. // | 機能  order orderby addfieldorder $field_id を編集
    2148. 

  2148. // | 書式  userbox_orderby($datefield,$order,$orderby,$addfieldorder,$field_id);
    2149. 

  2149. // +---------------------------------------------------------------------------+
    2150. 

  2150. // | 引数 $datefield
    2151. 

  2151. // | 引数戻値 $order
    2152. 

  2152. // | 引数戻値 $orderby
    2153. 

  2153. // | 引数戻値 $addfieldorder
    2154. 

  2154. // | 引数戻値 $field_id
    2155. 

  2155. // +---------------------------------------------------------------------------+
    2156. 

  2156. {
    2157. 

  2157. 

  2158.     global $_TABLES;
    2159. 

  2159. 

  2160.     $orderby="";
    2161. 

  2161.     $addfieldorder=false;
    2162. 

  2162.     switch($order){
    2163. 

  2163.         case "random":
    2164. 

  2164.             $orderby =" RAND()";
    2165. 

  2165.             break;
    2166. 

  2166.         case "":
    2167. 

  2167.         case "date":
    2168. 

  2168.             $order="date";
    2169. 

  2169.             $orderby = $datefield ." DESC";
    2170. 

  2170.             break;
    2171. 

  2171.         case "released":
    2172. 

  2172.             $orderby = " released DESC";
    2173. 

  2173.             break;
    2174. 

  2174.         case "orderno":
    2175. 

  2175.         case "code":
    2176. 

  2176.         case "title":
    2177. 

  2177.         case "description":
    2178. 

  2178.         case "id":
    2179. 

  2179.             $orderby = " t2.".$order;
    2180. 

  2180.             break;
    2181. 

  2181.         case "username":
    2182. 

  2182.         case "fullname":
    2183. 

  2183.             $orderby = " t4.".$order;
    2184. 

  2184.             break;
    2185. 

  2185.         default:
    2186. 

  2186.             $sql="SELECT ";
    2187. 

  2187.             $sql.= " field_id ";
    2188. 

  2188.             $sql.= ",name ";
    2189. 

  2189.             $sql.=" FROM";
    2190. 

  2190.             $sql.=" {$_TABLES['USERBOX_def_field']} ";
    2191. 

  2191.             $sql.=" WHERE templatesetvar='".$order."'";
    2192. 

  2192. 

  2193.             $result = DB_query ($sql);
    2194. 

  2194.             $numrows = DB_numRows ($result);
    2195. 

  2195. 

  2196.             if ($numrows>0){
    2197. 

  2197.                 $A = DB_fetchArray ($result);
    2198. 

  2198.                 $field_id=COM_stripslashes($A['field_id']);
    2199. 

  2199.                 $addfield_name=COM_stripslashes($A['name']);
    2200. 

  2200.                 $orderby = " t3.value IS NULL ASC ,cast(t3.value as DECIMAL) ASC ";
    2201. 

  2201.                 $addfieldorder=true;
    2202. 

  2202.             }else{
    2203. 

  2203.                 $order="date";
    2204. 

  2204.                 $orderby = $datefield ." DESC";
    2205. 

  2205.             }
    2206. 

  2206.     }
    2207. 

  2207. 

  2208.     return ;
    2209. 

  2209. 

  2210. }
    2211. 

  2211. 

  2212. 

  2213. function userbox_newlist(
    2214. 

  2214.      $m="ALL"
    2215. 

  2215.     ,$categories=""
    2216. 

  2216.     ,$rss_file=""
    2217. 

  2217.     ,$title_trim_length=""
    2218. 

  2218.     ,$intervalday=""
    2219. 

  2219.     ,$limitcnt=""
    2220. 

  2220.     ,$newmarkday=""
    2221. 

  2221.     ,$thtml=null
    2222. 

  2222.     ,$permission=null
    2223. 

  2223. )
    2224. 

  2224. // +---------------------------------------------------------------------------+
    2225. 

  2225. // | 機能  ブロック用 新着user一覧出力                                         |
    2226. 

  2226. // | 書式 userbox_newlist                                                      |
    2227. 

  2227. // +---------------------------------------------------------------------------+
    2228. 

  2228. // | 引数 $m             :省略時'ALL' id=id指定で選択 code指定で選択           |
    2229. 

  2229. // | 引数 $categories    :選択トピック 省略時設定値or'ALL'                     |
    2230. 

  2230. // | 引数 $rss_file      :RSS_file     省略時""                                |
    2231. 

  2231. // | 引数 $title_trim_length :タイトル長の制限 省略時設定値or20                |
    2232. 

  2232. // | 引数 $intervalday   :新着記事の期間 単位日  省略時設定値or90              |
    2233. 

  2233. // |                      0の時　全件                                          |
    2234. 

  2234. // | 引数 $limitcnt      :表示件数   省略時設定値or10                          |
    2235. 

  2235. // | 引数 $newmarkday    :新着マーク 省略時設定値or3                           |
    2236. 

  2236. // | 引数 $thtml         :テンプレートファイルのフォルダ  layout/テーマ/XXXX/  |
    2237. 

  2237. // |                      省略時は、プラグイン内のテンプレート                 |
    2238. 

  2238. // +---------------------------------------------------------------------------+
    2239. 

  2239. // | 戻値 nomal:新着user一覧                                                   |
    2240. 

  2240. // +---------------------------------------------------------------------------+
    2241. 

  2241. // update20101124
    2242. 

  2242. {
    2243. 

  2243.     $pi_name="userbox";
    2244. 

  2244. 

  2245.     global $_USER;
    2246. 

  2246.     global $_TABLES;
    2247. 

  2247.     global $_CONF;
    2248. 

  2248. 

  2249.     global $_USERBOX_CONF;
    2250. 

  2250.     global $LANG_USERBOX;
    2251. 

  2251. 

  2252.     //
    2253. 

  2253.     if ($title_trim_length==""){
    2254. 

  2254.         $title_trim_length=$_USERBOX_CONF['title_trim_length'];
    2255. 

  2255.         if ($title_trim_length==""){
    2256. 

  2256.             $title_trim_length=20;
    2257. 

  2257.         }
    2258. 

  2258.     }
    2259. 

  2259.     //
    2260. 

  2260.     if ($intervalday==""){
    2261. 

  2261.         $intervalday=$_USERBOX_CONF['intervalday'];
    2262. 

  2262.         if ($intervalday==""){
    2263. 

  2263.             $intervalday=90;
    2264. 

  2264.         }
    2265. 

  2265.     }
    2266. 

  2266.     //
    2267. 

  2267.     if ($limitcnt==""){
    2268. 

  2268.         $limitcnt=$_USERBOX_CONF['limitcnt'];
    2269. 

  2269.         if ($limitcnt==""){
    2270. 

  2270.             $limitcnt=10;
    2271. 

  2271.         }
    2272. 

  2272.     }
    2273. 

  2273.     if ($newmarkday==""){
    2274. 

  2274.         $newmarkday=$_USERBOX_CONF['newmarkday'];
    2275. 

  2275.         if ($newmarkday==""){
    2276. 

  2276.             $newmarkday=3;
    2277. 

  2277.         }
    2278. 

  2278.     }
    2279. 

  2279. 

  2280.     if ($m===""){
    2281. 

  2281.         $categories="ALL";
    2282. 

  2282.     }else{
    2283. 

  2283.         if ($categories==""){
    2284. 

  2284.             $categories=$_USERBOX_CONF['categories'];
    2285. 

  2285.             if ($categories==""){
    2286. 

  2286.                 $categories="ALL";
    2287. 

  2287.             }
    2288. 

  2288.         }elseif (strpos($categories,",")=="") {
    2289. 

  2289.             $categories="'$categories'";
    2290. 

  2290.         }else{
    2291. 

  2291.             $ary=explode(",",$categories);
    2292. 

  2292.             $b="";
    2293. 

  2293.             for ($i = 1; $i <= count($ary); $i++) {
    2294. 

  2294.                 if ($m==="code"){
    2295. 

  2295.                     $b.="'".current($ary)."',";
    2296. 

  2296.                 }else{
    2297. 

  2297.                     $b.=current($ary).",";
    2298. 

  2298.                 }
    2299. 

  2299.                 next($ary);
    2300. 

  2300.             }
    2301. 

  2301.             $categories=rtrim($b,",");
    2302. 

  2302.         }
    2303. 

  2303.     }
    2304. 

  2304. 

  2305.     //
    2306. 

  2306.     $new_img=$_USERBOX_CONF['new_img'];
    2307. 

  2307.     if ($new_img==""){
    2308. 

  2308.         $new_img="New!";
    2309. 

  2309.     }
    2310. 

  2310.     $rss_img=$_USERBOX_CONF['rss_img'];
    2311. 

  2311.     if ($rss_img=="") {
    2312. 

  2312.         $rss_img="[RSS]";
    2313. 

  2313.     }
    2314. 

  2314. 

  2315.     if (is_null($thtml)){
    2316. 

  2316.         $thtml="default";
    2317. 

  2317.     }
    2318. 

  2318. 

  2319. //-------------------------------------------
    2320. 

  2320.     $retval="";
    2321. 

  2321. 

  2322.     //テンプレートフォルダの設定
    2323. 

  2323.     $tmplfld=DATABOX_templatePath('newlist',$thtml,$pi_name);
    2324. 

  2324. 

  2325.     $list = new Template($tmplfld);
    2326. 

  2326.     $list->set_file (array (
    2327. 

  2327.         'list' => 'list.thtml',
    2328. 

  2328.         'col'   => 'list_col.thtml'
    2329. 

  2329.     ));
    2330. 

  2330. 

  2331.     $datefield=$_USERBOX_CONF['datefield'];//使用する日付（編集日付、作成日付）
    2332. 

  2332. 

  2333.     //-----
    2334. 

  2334.     $tbl1=$_TABLES['USERBOX_base'] ;
    2335. 

  2335.     $tbl2=$_TABLES['USERBOX_category'] ;
    2336. 

  2336.     $tbl3=$_TABLES['USERBOX_def_category'] ;
    2337. 

  2337.     $tbl4=$_TABLES['users'] ;
    2338. 

  2338. 

  2339. 

  2340.     $sql="SELECT ".LB;
    2341. 

  2341.     $sql.=" t4.fullname".LB;
    2342. 

  2342.     $sql.=" , UNIX_TIMESTAMP(t1.".$datefield .") AS day".LB;
    2343. 

  2343.     $sql.=" , t1.id".LB;
    2344. 

  2344. 	$sql.=" , t4.username".LB;
    2345. 

  2345. 

  2346.     $sql.=" ,t1.owner_id".LB;
    2347. 

  2347.     $sql.=" ,t1.group_id".LB;
    2348. 

  2348.     $sql.=" ,t1.perm_owner".LB;
    2349. 

  2349.     $sql.=" ,t1.perm_group".LB;
    2350. 

  2350.     $sql.=" ,t1.perm_members".LB;
    2351. 

  2351.     $sql.=" ,t1.perm_anon".LB;
    2352. 

  2352. 

  2353.     $sql .= " FROM ".LB;
    2354. 

  2354.     $sql .= " {$tbl1} AS t1 ".LB;
    2355. 

  2355.     $sql .= " , {$tbl4} AS t4 ".LB;
    2356. 

  2356. 

  2357.     if ($categories!=="ALL" ){
    2358. 

  2358.         $sql .= " ,{$tbl2} AS t2 ".LB;
    2359. 

  2359.         $sql .= " ,{$tbl3} AS t3 ".LB;
    2360. 

  2360.     }
    2361. 

  2361. 

  2362.     $sql.=" WHERE";
    2363. 

  2363.     if ($categories==="ALL" ){
    2364. 

  2364.         $sql.=" t1.id=t4.uid".LB;
    2365. 

  2365.     }else{
    2366. 

  2366.         $sql.= " t1.id = t4.id ".LB;
    2367. 

  2367.         $sql.= " AND t1.id=t2.uid".LB;
    2368. 

  2368.         $sql.= " AND t2.category_id = t3.category_id ".LB;
    2369. 

  2369.     }
    2370. 

  2370. 

  2371.     //管理者の時,下書データも含む
    2372. 

  2372.     //if ( SEC_hasRights('userbox.admin')) {
    2373. 

  2373.     //}else{
    2374. 

  2374.        $sql .= " AND t1.draft_flag=0".LB;
    2375. 

  2375.     //}
    2376. 

  2376.     //アクセス権のないデータ はのぞく
    2377. 

  2377.     if  ($_USERBOX_CONF['disable_permission_ignore']=="0" AND strtoupper($permission)=="IGNORE"){
    2378. 

  2378.     }else{
    2379. 

  2379.         $sql .= COM_getPermSql('AND').LB;
    2380. 

  2380.     }
    2381. 

  2381.     //公開日以前のデータはのぞく
    2382. 

  2382.     $sql .= " AND (released <= NOW())".LB;
    2383. 

  2383. 

  2384.     //公開終了日を過ぎたデータはのぞく
    2385. 

  2385.     $sql .= " AND (expired=0 OR expired > NOW())".LB;
    2386. 

  2386. 

  2387.     if ($intervalday<>0){
    2388. 

  2388.         $sql.=" AND (".$datefield ." >= (date_sub(NOW(), INTERVAL $intervalday day)))".LB;
    2389. 

  2389.     }
    2390. 

  2390. 

  2391.     if ($categories!=="ALL" ){
    2392. 

  2392.         if ($m==="id") {
    2393. 

  2393.             $sql.=" AND t2.category_id IN ($categories)";
    2394. 

  2394.         }else{
    2395. 

  2395.             $sql.=" AND t3.code IN ($categories)";
    2396. 

  2396.         }
    2397. 

  2397.     }
    2398. 

  2398.     $sql .= COM_getLangSQL ('username', 'AND', 't4').LB;
    2399. 

  2399. 

  2400.     $sql.=" ORDER BY ".$datefield ." DESC";
    2401. 

  2401.     $sql.=" LIMIT $limitcnt";
    2402. 

  2402. 

  2403.     $result = DB_query ($sql);
    2404. 

  2404. 

  2405.     $i=0;
    2406. 

  2406. 

  2407.     while( $A = DB_fetchArray( $result ) )    {
    2408. 

  2408. 

  2409.         $title= COM_truncate( $A['username'], $title_trim_length,'...' );
    2410. 

  2410. 

  2411.         $url=$_CONF['site_url'] . "/userbox/profile.php";
    2412. 

  2412.         $url.="?";
    2413. 

  2413.         //コード使用の時
    2414. 

  2414.         if ($_USERBOX_CONF['datacode']){
    2415. 

  2415.             $url.="m=code";
    2416. 

  2416.             $url.="&code=".$A['username'];
    2417. 

  2417.         }else{
    2418. 

  2418.             $url.="m=id";
    2419. 

  2419.             $url.="&id=".$A['id'];
    2420. 

  2420.         }
    2421. 

  2421.         $url = COM_buildUrl( $url );
    2422. 

  2422.         $link= COM_createLink($title, $url);
    2423. 

  2423. 

  2424. 

  2425.         $list->set_var ('site_url', $_CONF['site_url']);
    2426. 

  2426. 

  2427.         $list->set_var ('day', strftime($LANG_USERBOX['day'],$A['day']));
    2428. 

  2428. 

  2429.         $chkday=strtotime("- $newmarkday days",time());
    2430. 

  2430.         if (date("Ymd",$A['day']) >= date("Ymd",$chkday)){
    2431. 

  2431.             $list->set_var ('new_img', $new_img);
    2432. 

  2432.         }else{
    2433. 

  2433.             $list->set_var ('new_img', '');
    2434. 

  2434.         }
    2435. 

  2435.         $list->set_var ('link', $link);//@@@@@
    2436. 

  2436. 

  2437.         $list->set_var ('url', $url);
    2438. 

  2438. 		$list->set_var ('title', $title);
    2439. 

  2439. 

  2440.         $permission=SEC_hasAccess2($A);
    2441. 

  2441.         $list->set_var ('permission',$permission);
    2442. 

  2442.         if  ($permission>=2){
    2443. 

  2443.             $list->set_var ('class_a', 'class="gl-tooltip"');
    2444. 

  2444.             $list->set_var ('class_c', 'class="classic"');
    2445. 

  2445.         }else{
    2446. 

  2446.             $list->set_var ('class_a', 'class="userbox_nolink"');
    2447. 

  2447.             $list->set_var ('class_c', 'class="userbox_displaynon"');
    2448. 

  2448.         }
    2449. 

  2449. 

  2450.         $n=($i%2)+1;
    2451. 

  2451.         $class='class="row'.$n.'"';
    2452. 

  2452.         $list->set_var ('class', 'class="row'.$n.'"');
    2453. 

  2453.         
    2454. 

  2454.         //カテゴリ
    2455. 

  2455.         DATABOX_getcategoriesDisp($A['id'],$list,$chk_user,0,$pi_name);
    2456. 

  2456. 

  2457.         $list->parse ('list_col', 'col', true);
    2458. 

  2458. 

  2459.         $i++;
    2460. 

  2460.     }
    2461. 

  2461. 

  2462.     $list->set_var ('site_url', $_CONF['site_url']);
    2463. 

  2463.     $list->set_var ('day', strftime($LANG_USERBOXBOX['day'],$A['day']));
    2464. 

  2464. 

  2465.     //
    2466. 

  2466.     if ($rss_file<>""){
    2467. 

  2467.         $list->set_var ('rss_url', $_CONF['site_url'] . '/backend/'.$rss_file);
    2468. 

  2468.         $list->set_var ('rss_title', $rss_img);
    2469. 

  2469.     }
    2470. 

  2470.     //
    2471. 

  2471.     $more_title=$LANG_USERBOX['more'];
    2472. 

  2472.     if ($categories==="ALL" OR strpos($categories,",")<>"") {
    2473. 

  2473.         $more_url=COM_buildUrl($_CONF['site_url'] . '/userbox/index.php');//
    2474. 

  2474.     }else{
    2475. 

  2475.         //コード使用の時
    2476. 

  2476.         if ($m="code"){
    2477. 

  2477.             $more_url.="m=code";
    2478. 

  2478.             $more_url.="&code=".ltrim(rtrim($categories,"'"),"'");
    2479. 

  2479.         }else{
    2480. 

  2480.             $more_url.="m=id";
    2481. 

  2481.             $more_url.="&id=".ltrim(rtrim($categories,"'"),"'");
    2482. 

  2482.         }
    2483. 

  2483.         $more_url=$_CONF['site_url'] . "/userbox/index.php".$more_url;//@@@@@
    2484. 

  2484.     }
    2485. 

  2485. 

  2486.     $more_url = COM_buildUrl( $more_url );
    2487. 

  2487.     $more_link= COM_createLink($title, $more_url);
    2488. 

  2488.     $list->set_var ('more_url', $more_url);
    2489. 

  2489.     $list->set_var ('more_title', $more_title);
    2490. 

  2490. 

  2491.     $list->parse ('output', 'list');
    2492. 

  2492.     $retval .= $list->finish ($list->get_var ('output'));
    2493. 

  2493. 

  2494. 

  2495.     return $retval;
    2496. 

  2496. }
    2497. 

  2497. 

  2498. function userbox_order(
    2499. 

  2499.     $url=""
    2500. 

  2500.     ,$templates
    2501. 

  2501.     ,$cur_order="id"
    2502. 

  2502. )
    2503. 

  2503. // +---------------------------------------------------------------------------+
    2504. 

  2504. // | 機能 ORDER指定LINK出力
    2505. 

  2505. // | 書式 userbox_order()
    2506. 

  2506. // +---------------------------------------------------------------------------+
    2507. 

  2507. // | 引数 $url:
    2508. 

  2508. // | 引数 $templates
    2509. 

  2509. // | 引数 $cur_order:
    2510. 

  2510. // +---------------------------------------------------------------------------+
    2511. 

  2511. {
    2512. 

  2512. global $LANG_USERBOX_ORDER;
    2513. 

  2513. global $_TABLES;
    2514. 

  2514. 

  2515.     $templates->set_var('cur_order',$cur_order);
    2516. 

  2516. 

  2517.     $order_ary=array();
    2518. 

  2518.     $order_ary[]='random';
    2519. 

  2519.     $order_ary[]='date';
    2520. 

  2520.     $order_ary[]='orderno';
    2521. 

  2521.     $order_ary[]='username';
    2522. 

  2522.     $order_ary[]='fullname';
    2523. 

  2523.     $order_ary[]='description';
    2524. 

  2524.     $order_ary[]='id';
    2525. 

  2525.     $order_ary[]='released';
    2526. 

  2526. 

  2527.     $sql="SELECT ";
    2528. 

  2528.     $sql.= " field_id ";
    2529. 

  2529.     $sql.= ",name ";
    2530. 

  2530.     $sql.= ",templatesetvar";
    2531. 

  2531.     $sql.=" FROM";
    2532. 

  2532.     $sql.=" {$_TABLES['USERBOX_def_field']} ";
    2533. 

  2533.     $sql.=" where allow_display=0";
    2534. 

  2534. 

  2535.     $result = DB_query ($sql);
    2536. 

  2536.     $numrows = DB_numRows ($result);
    2537. 

  2537. 

  2538.     $addfield_ary=array();
    2539. 

  2539.     for ($i = 1; $i <= $numrows; $i++) {
    2540. 

  2540.         $A = DB_fetchArray ($result);
    2541. 

  2541.         $field_id=COM_stripslashes($A['field_id']);
    2542. 

  2542.         $addfield_ary[$field_id]['name']=COM_stripslashes($A['name']);
    2543. 

  2543.         $addfield_ary[$field_id]['templatesetvar']=COM_stripslashes($A['templatesetvar']);
    2544. 

  2544.         $order_ary[]="addfield".$field_id;
    2545. 

  2545.     }
    2546. 

  2546. 

  2547. 

  2548.     for ($i = 1; $i <= count($order_ary); $i++) {
    2549. 

  2549.         $c=current($order_ary);
    2550. 

  2550. 

  2551.         if (substr($c,0,8)==="addfield"){
    2552. 

  2552.             $field_id=substr($c,8);
    2553. 

  2553.             $order=$addfield_ary[$field_id]['templatesetvar'];
    2554. 

  2554.             $order_name=$addfield_ary[$field_id]['name'];
    2555. 

  2555.             $order_name.=$LANG_USERBOX_ORDER['order'];
    2556. 

  2556.         }else{
    2557. 

  2557.             $order=$c;
    2558. 

  2558.             $order_name=$LANG_USERBOX_ORDER[$c];
    2559. 

  2559.         }
    2560. 

  2560. 

  2561.         if ($order<>"random" AND $order===$cur_order){
    2562. 

  2562.             $rt=$order_name;
    2563. 

  2563.         }else{
    2564. 

  2564.             $order_url=$url;
    2565. 

  2565.             $order_url.=$order;
    2566. 

  2566.             //$order_url = COM_buildUrl( $order_url );
    2567. 

  2567.             $rt= COM_createLink($order_name, $order_url);
    2568. 

  2568.         }
    2569. 

  2569. 

  2570.         $templates->set_var('order_'.$order,$rt);
    2571. 

  2571. 

  2572.         next($order_ary);
    2573. 

  2573.     }
    2574. 

  2574. 

  2575.     return ;
    2576. 

  2576. 

  2577. 

  2578. }
    2579. 

  2579. 

  2580. 

  2581. 

  2582. function userbox_msg(
    2583. 

  2583.     $for=""
    2584. 

  2584. )
    2585. 

  2585. // +---------------------------------------------------------------------------+
    2586. 

  2586. // | 機能 メッセージ出力
    2587. 

  2587. // | 書式 userbox_msg()
    2588. 

  2588. // +---------------------------------------------------------------------------+
    2589. 

  2589. // | 引数 $for:誰宛
    2590. 

  2590. // +---------------------------------------------------------------------------+
    2591. 

  2591. {
    2592. 

  2592. global $LANG_USERBOX_MSG;
    2593. 

  2593. global $_USER;
    2594. 

  2594. global $_TABLES;
    2595. 

  2595.     
    2596. 

  2596.     $rt="";
    2597. 

  2597.     $uid=$_USER['uid'];
    2598. 

  2598.     
    2599. 

  2599.     switch ($for) {
    2600. 

  2600.         case '':
    2601. 

  2601.         case 'alluser':
    2602. 

  2602.             $rt=$LANG_USERBOX_MSG['alluser'];
    2603. 

  2603.             break;
    2604. 

  2604.         case 'draftuser':
    2605. 

  2605.             $draft_flag=DB_getItem($_TABLES['USERBOX_base'], 'draft_flag',
    2606. 

  2606.                         "id = '{$uid}'");
    2607. 

  2607.             if ($draft_flag==1){
    2608. 

  2608.                 $rt=$LANG_USERBOX_MSG['draftuser'];
    2609. 

  2609.             }
    2610. 

  2610.             break;
    2611. 

  2611.         case 'descriptionempty':
    2612. 

  2612.             if ($uid<>0){
    2613. 

  2613.                 if (userbox_descriptionemptycheck($uid)==false){
    2614. 

  2614.                     $rt=$LANG_USERBOX_MSG['descriptionempty'];
    2615. 

  2615.                 }
    2616. 

  2616.             }
    2617. 

  2617.             break;
    2618. 

  2618.         default:
    2619. 

  2619.         
    2620. 

  2620.     }
    2621. 

  2621.     
    2622. 

  2622.     return $rt;
    2623. 

  2623. 

  2624. }
    2625. 

  2625. 

  2626. 

  2627. ?>
    2628. 

  2628.