PageRenderTime 68ms CodeModel.GetById 15ms RepoModel.GetById 0ms app.codeStats 1ms

/databox/functions_autotag.inc

https://bitbucket.org/tsuchi/box
PHP | 3915 lines | 2988 code | 514 blank | 413 comment | 324 complexity | a47b1d5123c60bfba65c9f980a9bd4f9 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. // | DataBox プラグイン   function.inc からrequire
    5. 

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

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

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

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

  9. //20120416 databox_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. 

  15. function plugin_autotags_databox (
    16. 

  16.     $op
    17. 

  17.     , $content = ''
    18. 

  18.     , $autotag = ''
    19. 

  19. )
    20. 

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

  21. // | 自動タグ
    22. 

  22. // +---------------------------------------------------------------------------+
    23. 

  23. {
    24. 

  24.     global $_TABLES;
    25. 

  25.     global $_CONF;
    26. 

  26.     global $LANG_DATABOX_autotag_desc;
    27. 

  27. 

  28.     //Option Display
    29. 

  29.     if ($op == 'tagname' ) {
    30. 

  30.         $tagname[]='databox';
    31. 

  31.         return $tagname;
    32. 

  32.     } elseif ($op == 'permission' || $op == 'nopermission') {
    33. 

  33.         if ($op == 'permission') {
    34. 

  34.             $flag = true;
    35. 

  35.         } else {
    36. 

  36.             $flag = false;
    37. 

  37.         }
    38. 

  38. 

  39.         if (isset($_GROUPS['DataBox Admin'])) {
    40. 

  40.             $group_id = $_GROUPS['DataBox Admin'];
    41. 

  41.         } else {
    42. 

  42.             $group_id = DB_getItem($_TABLES['groups'], 'grp_id',
    43. 

  43.                                    "grp_name = 'DataBox Admin'");
    44. 

  44.         }
    45. 

  45.         $owner_id = SEC_getDefaultRootUser();
    46. 

  46. 

  47.         if (COM_getPermTag(
    48. 

  48.             $owner_id
    49. 

  49.             , $group_id
    50. 

  50.             , $_DATABOX_CONF['autotag_permissions_databox'][0]
    51. 

  51.             , $_DATABOX_CONF['autotag_permissions_databox'][1]
    52. 

  52.             , $_DATABOX_CONF['autotag_permissions_databox'][2]
    53. 

  53.             , $_DATABOX_CONF['autotag_permissions_databox'][3]) == $flag) {
    54. 

  54.             return $tagname;
    55. 

  55.         }
    56. 

  56.     } elseif ($op == 'description') {
    57. 

  57.         return $LANG_DATABOX_autotag_desc;
    58. 

  58.     } else if ($op == 'parse') {
    59. 

  59.         //引数チェック
    60. 

  60.         $p1 = COM_applyFilter ($autotag['parm1']);
    61. 

  61.         $p2 = COM_applyFilter ($autotag['parm2']);
    62. 

  62.         $tag = COM_applyFilter ($autotag['tag']);
    63. 

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

  64.         
    65. 

  65.         $parm2_ary[]="category_id";
    66. 

  66.         $parm2_ary[]="category_code";
    67. 

  67.         $parm2_ary[]="mode";
    68. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  96.         $p=databox_parm2($p2,$parm2_ary);
    97. 

  97.         //各処理
    98. 

  98.         switch( $tag ) {
    99. 

  99.             case 'databox' :
    100. 

  100.                 switch($p1) {
    101. 

  101.                     case 'count':
    102. 

  102.                         $rt= databox_count(
    103. 

  103.                             $p['category_id']
    104. 

  104.                             ,$p['category_code']
    105. 

  105.                             ,$p['mode']
    106. 

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

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

  108.                             );
    109. 

  109.                         break;
    110. 

  110.                     case 'newlist':
    111. 

  111.                             if ($p['category_id']<>""){
    112. 

  112.                                 $m="id";
    113. 

  113.                                 $categories=$p['category_id'];
    114. 

  114.                             }elseif ($p['category_code']<>"") {
    115. 

  115.                                 $m="code";
    116. 

  116.                                 $categories=$p['category_code'];
    117. 

  117.                             }else{
    118. 

  118.                                 $m="ALL";
    119. 

  119.                                 $categories="";
    120. 

  120.                             }
    121. 

  121.                             $rt= databox_newlist(
    122. 

  122.                             $m
    123. 

  123.                             ,$categories
    124. 

  124.                             ,$p['rss_file']
    125. 

  125.                             ,$p['title_trim_length']
    126. 

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

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

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

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

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

  131.                             );
    132. 

  132.                         break;
    133. 

  133.                     case 'data':
    134. 

  134.                         $w= databox_data(
    135. 

  135.                             $p['id']
    136. 

  136.                             ,$p['templatedir']
    137. 

  137.                             ,$p['nohitmsg']
    138. 

  138.                             ,""
    139. 

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

  140.                             );
    141. 

  141.                         $rt=$w['display'];
    142. 

  142.                         break;
    143. 

  143.                     case 'category':
    144. 

  144.                         $rt= databox_category(
    145. 

  145.                             "autotag"
    146. 

  146.                             ,$p['category_id']
    147. 

  147.                             ,$p['templatedir']
    148. 

  148.                             ,$p['nohitmsg']
    149. 

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

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

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

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

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

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

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

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

  157.                         );
    158. 

  158.                         break;
    159. 

  159.                     case 'attributedatacount':
    160. 

  160.                         $rt=DATABOX_count_each_afield(
    161. 

  161.                             "databox"
    162. 

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

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

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

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

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

  167.                             );
    168. 

  168.                         break;
    169. 

  169. 

  170.                     case 'lastmodified':
    171. 

  171.                         $rt= databox_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= databox_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= databox_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 'datalink':
    202. 

  202.                         $rt= databox_datalink(
    203. 

  203.                             $p['id']
    204. 

  204.                             ,$p['code']
    205. 

  205.                             ,$p['lastparm2']
    206. 

  206.                         );
    207. 

  207.                         break;
    208. 

  208.                     case 'mydataentrylink':
    209. 

  209.                     case 'mydataentry':
    210. 

  210.                         $rt= databox_mydataentrylink(
    211. 

  211.                             $p['type_id']
    212. 

  212.                             ,$p['templatedir']
    213. 

  213.                             ,$p['lastparm2']
    214. 

  214.                         );
    215. 

  215.                         break;
    216. 

  216.                     case 'mydata':
    217. 

  217.                         $rt= databox_mydata(
    218. 

  218.                              $p['templatedir']
    219. 

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

  220.                         );
    221. 

  221.                         break;
    222. 

  222.                     case 'categorycount':
    223. 

  223.                         $rt= DATABOX_categorycount(
    224. 

  224.                              "databox"
    225. 

  225.                             ,$p['group_id']
    226. 

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

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

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

  229.                         );
    230. 

  230.                         break;
    231. 

  231.                     case 'categorycheck':
    232. 

  232.                           $rt= DATABOX_getcheckList(
    233. 

  233.                              "categorygroup"
    234. 

  234.                             ,""
    235. 

  235.                             ,"databox"
    236. 

  236.                             ,$p['group_id']
    237. 

  237.                             ,$p['iname']
    238. 

  238.                         );
    239. 

  239.                         break;
    240. 

  240.                     case 'mastercheck':
    241. 

  241.                         if  ($p['field_id']<>""){
    242. 

  242.                             $kind=COM_applyFilter(
    243. 

  243.                                 DB_getItem($_TABLES['DATABOX_def_field'] 
    244. 

  244.                                     ,"selectlist","field_id={$p['field_id']}"));
    245. 

  245.                             if  ($kind<>""){
    246. 

  246.                                   $rt= DATABOX_getcheckList(
    247. 

  247.                                      $kind
    248. 

  248.                                      ,""
    249. 

  249.                                      ,"databox"
    250. 

  250.                                      ,""
    251. 

  251.                                      ,$p['iname']
    252. 

  252.                                   );
    253. 

  253.                             }
    254. 

  254.                         }
    255. 

  255.                         break;
    256. 

  256.                     case 'search':
    257. 

  257.                         $argary=databox_searcharg("autotag",$p['lastparm2']);
    258. 

  258.                         $rt=databox_search("autotag",$argary);
    259. 

  259.                         break;
    260. 

  260.                     case 'attributevalue':
    261. 

  261.                         $rt=DATABOX_fieldvalue(
    262. 

  262.                                 "databox"
    263. 

  263.                                 ,$p['id']
    264. 

  264.                                 ,$p['code']
    265. 

  265.                                 ,$p['field_id']
    266. 

  266.                                 ,$p['field_code']
    267. 

  267.                                 ,$p['option']
    268. 

  268.                             );
    269. 

  269.                         break;
    270. 

  270.                     case 'math':
    271. 

  271.                         $rt=DATABOX_math(
    272. 

  272.                                 "databox"
    273. 

  273.                                 ,$p['method']
    274. 

  274.                                 ,$p['templatesetvar']
    275. 

  275.                                 ,$p['type_id']
    276. 

  276.                                 ,$p['category_id']
    277. 

  277.                                 ,$p['category_code']
    278. 

  278.                                 ,$p['mode']
    279. 

  279.                                 ,$p['roundprecision']
    280. 

  280.                                 ,$p['numberformat']
    281. 

  281.                                 ,$p['permission']
    282. 

  282.                             );
    283. 

  283.                         break;
    284. 

  284.                 }
    285. 

  285. 

  286.                 $content = str_replace ($autotag['tagstr'], $rt, $content);
    287. 

  287.                 return $content;
    288. 

  288.                 break;
    289. 

  289. 

  290.         }
    291. 

  291.     }
    292. 

  292. }
    293. 

  293. 

  294. //第二引数分割
    295. 

  295. function databox_parm2 ($p2,$parm2_ary)
    296. 

  296. {
    297. 

  297.     $ary=array();
    298. 

  298.     $px = explode (' ', trim ($p2));
    299. 

  299.     if (is_array ($px)) {
    300. 

  300.         foreach ($px as $part) {
    301. 

  301.             $a = explode (':', $part);
    302. 

  302.             if (in_array($a[0],$parm2_ary)){
    303. 

  303.                 $ary["{$a[0]}"]=$a[1];
    304. 

  304.                 $skip++;            
    305. 

  305.             }
    306. 

  306.         }
    307. 

  307.         
    308. 

  308.         if (count ($px) > $skip) {
    309. 

  309.             for ($i = 0; $i < $skip; $i++) {
    310. 

  310.                 array_shift ($px);
    311. 

  311.             }
    312. 

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

  313.         }
    314. 

  314. 

  315.     }else{
    316. 

  316.         $ary["lastparm2"]=trim($p2);
    317. 

  317.     }
    318. 

  318.     
    319. 

  319.     return $ary;
    320. 

  320. 

  321. }
    322. 

  322. //=====ブロック関数============================================================
    323. 

  323. // +---------------------------------------------------------------------------+
    324. 

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

  325. // | 書式 phpblock_shownewdatabox()                                            |
    326. 

  326. // +---------------------------------------------------------------------------+
    327. 

  327. function phpblock_shownewdatabox()
    328. 

  328. {
    329. 

  329.     return databox_newlist();
    330. 

  330. }
    331. 

  331. 

  332. //=====専用関数============================================================
    333. 

  333. //
    334. 

  334. function databox_category(
    335. 

  335.     $autotag
    336. 

  336.     ,$category_id=null
    337. 

  337.     ,$template=null
    338. 

  338.     ,$nohitmsg=""
    339. 

  339.     ,$perpage =0
    340. 

  340.     ,$page=null
    341. 

  341.     ,$order=null
    342. 

  342.     ,$category_code=null
    343. 

  343.     ,$mode=''
    344. 

  344.     ,$expired=''
    345. 

  345.     ,$without_code=''
    346. 

  346.     ,$without_id=''
    347. 

  347. )
    348. 

  348. // +---------------------------------------------------------------------------+
    349. 

  349. // | 機能  カテゴリ別一覧表示
    350. 

  350. // | 書式  databox_category($id,$template,"yes","page",$perpage)
    351. 

  351. // | 書式  databox_category($p['category_id'],$p['thtml'],$p['nohitmsg']
    352. 

  352. // | 書式                    ,"",$p['perpage'],$p['order'],$p['code']
    353. 

  353. // +---------------------------------------------------------------------------+
    354. 

  354. // | 引数 $autotag:notautotagの時ヘッダを表示しない
    355. 

  355. // | 引数 $category_id:カテゴリid
    356. 

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

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

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

  359. // | 引数 $page            :
    360. 

  360. // | 引数 $order         :順序
    361. 

  361. // | 引数 $category_code :
    362. 

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

  363. // +---------------------------------------------------------------------------+
    364. 

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

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

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

  367. // +---------------------------------------------------------------------------+
    368. 

  368. // | 戻値 nomal:category list
    369. 

  369. // +---------------------------------------------------------------------------+
    370. 

  370. {
    371. 

  371.     $pi_name="databox";
    372. 

  372.     
    373. 

  373.     global $_CONF;
    374. 

  374.     global $_TABLES;
    375. 

  375.     
    376. 

  376.     global $_DATABOX_CONF;
    377. 

  377.     global $LANG_DATABOX;
    378. 

  378.     global $LANG_DATABOX_ADMIN;
    379. 

  379.     global $_IMAGE_TYPE;
    380. 

  380.     global $LANG_confignames;
    381. 

  381. 

  382.     //ログイン要否チェック
    383. 

  383.     if (COM_isAnonUser()){
    384. 

  384.         if  ($_CONF['loginrequired']
    385. 

  385.                 OR ($_DATABOX_CONF['loginrequired'] >1) ){
    386. 

  386.             return $LANG_DATABOX['loginrequired'];
    387. 

  387.         }
    388. 

  388. 

  389.     }
    390. 

  390.     //-----テーブル
    391. 

  391.     $tbl1=$_TABLES['DATABOX_category'] ;
    392. 

  392.     $tbl2=$_TABLES['DATABOX_base'] ;
    393. 

  393.     $tbl3=$_TABLES['DATABOX_addition'] ;
    394. 

  394.     //
    395. 

  395.     $tbl5=$_TABLES['DATABOX_def_category'] ;
    396. 

  396.     
    397. 

  397.     $tbl6=$_TABLES['DATABOX_stats'];
    398. 

  398. 

  399.     //
    400. 

  400.     $datefield=$_DATABOX_CONF['datefield'];//使用する日付（編集日付、作成日付、公開日）
    401. 

  401.     $new_img=$_DATABOX_CONF['new_img'];
    402. 

  402.     if ($new_img==""){
    403. 

  403.         $new_img="New!";
    404. 

  404.     }
    405. 

  405.     $newmarkday=$_DATABOX_CONF['newmarkday'];
    406. 

  406.     if ($newmarkday==""){
    407. 

  407.         $newmarkday=3;
    408. 

  408.     }
    409. 

  409.     $chkday=strtotime("- $newmarkday days",time());
    410. 

  410. 

  411.     //-----引数チェック
    412. 

  412.     $ids="";
    413. 

  413.     $idsary=array();
    414. 

  414.     if (is_null($category_id) OR $category_id==0){
    415. 

  415.         if (is_null($category_code)){
    416. 

  416.         }else{
    417. 

  417.             $w=explode("|",$category_code);
    418. 

  418.             foreach( $w as $val ){
    419. 

  419.                 if ($ids<>""){
    420. 

  420.                     $ids.=",";
    421. 

  421.                 }
    422. 

  422.                 $w_id=DATABOX_codetoid($val,'DATABOX_def_category',"category_id");
    423. 

  423.                 $idsary[]=$w_id;
    424. 

  424.                 $ids.=$w_id;
    425. 

  425.             }
    426. 

  426.         }
    427. 

  427.     }else{
    428. 

  428.         $ids=$category_id;
    429. 

  429.         $idsary[]=$category_id;
    430. 

  430.     }
    431. 

  431.     
    432. 

  432.     //--CATEGORY
    433. 

  433.     $category_name="";
    434. 

  434.     $defaulttemplatesdirectory = "";
    435. 

  435.     if (count($idsary)<>0){
    436. 

  436.         
    437. 

  437.         for ($i = 0; $i < count($idsary); $i++) {
    438. 

  438.             $sql = "SELECT ";
    439. 

  439.             $sql .= " name ".LB;
    440. 

  440.             $sql .= " ,code ".LB;
    441. 

  441.             $sql .= " ,description ".LB;
    442. 

  442.             $sql .= " ,defaulttemplatesdirectory".LB;
    443. 

  443.             $sql .= " FROM ".LB;
    444. 

  444.             $sql .= " {$tbl5} AS t5 ".LB;
    445. 

  445.             $sql .= " WHERE ".LB;
    446. 

  446.             $sql .= " t5.category_id =".$idsary[$i].LB;
    447. 

  447.         
    448. 

  448.             $result = DB_query ($sql);
    449. 

  449.             $numrows = DB_numRows ($result);
    450. 

  450.             if ($numrows > 0) {
    451. 

  451.                 $A = DB_fetchArray ($result);
    452. 

  452.                 $category_name.=COM_applyFilter($A['name'])." ";
    453. 

  453.                 $category_description.=COM_applyFilter($A['description'])." ";
    454. 

  454.                 if ($i==0){
    455. 

  455.                     $defaulttemplatesdirectory=COM_applyFilter($A['defaulttemplatesdirectory']);
    456. 

  456.                 }
    457. 

  457.             }
    458. 

  458.         }
    459. 

  459.     }
    460. 

  460. 

  461.     if (is_null($template) or ($template==="")){
    462. 

  462.         if ($defaulttemplatesdirectory===""){
    463. 

  463.             $template="default";
    464. 

  464.         }else{
    465. 

  465.             $template=$defaulttemplatesdirectory;
    466. 

  466.         }
    467. 

  467.     }
    468. 

  468.     
    469. 

  469.     //
    470. 

  470.     if (is_null($page) OR !isset($page) OR $page == 0) {
    471. 

  471.         $page = 1;
    472. 

  472.     }
    473. 

  473.     if ($perpage===0 OR is_null($perpage)){
    474. 

  474.         $perpage=$_DATABOX_CONF['perpage'];
    475. 

  475.     }
    476. 

  476.     //
    477. 

  477.     $w=databox_orderby($datefield,$order,$orderby,$addfieldorder,$field_id);
    478. 

  478.     //
    479. 

  479.     if (is_null($expired) or ($expired==="")){
    480. 

  480.         $expired="no";
    481. 

  481.     }
    482. 

  482.     //-----
    483. 

  483.     $sql = "SELECT ";
    484. 

  484. 

  485.     $sql .= " t2.id ".LB;
    486. 

  486.     $sql .= " ,t2.title ".LB;
    487. 

  487.     $sql .= " ,t2.code ".LB;
    488. 

  488.     $sql .= " ,t2.description ".LB;
    489. 

  489.     $sql .= " ,t2.released ".LB;
    490. 

  490.     $sql .= " ,t2.expired ".LB;
    491. 

  491.     $sql .= " ,t2.".$datefield." AS datefield ".LB;
    492. 

  492.     $sql .= " ,t2.fieldset_id ".LB;
    493. 

  493.     $sql .= " ,UNIX_TIMESTAMP(t2.".$datefield.") AS datefield_un ".LB;
    494. 

  494.     $sql .= " ,UNIX_TIMESTAMP(t2.released ) AS released_un ".LB;
    495. 

  495.     $sql .= " ,UNIX_TIMESTAMP(t2.expired ) AS expired_un ".LB;
    496. 

  496. 

  497.     $sql .= " ,t2.group_id";
    498. 

  498.     $sql .= " ,t2.owner_id";
    499. 

  499. 

  500.     if ($addfieldorder){
    501. 

  501.         $sql .= " ,t3.value ".LB;
    502. 

  502.     }
    503. 

  503.     
    504. 

  504.     //--FROM
    505. 

  505.     $sql .= " FROM ".LB;
    506. 

  506.     $sql .= " {$tbl2} AS t2 ".LB;
    507. 

  507. 

  508.     //if ($category_id<>0){
    509. 

  509.     //    $sql .= " ,{$tbl1} AS t1 ".LB;
    510. 

  510.     //}
    511. 

  511.     if ($addfieldorder){
    512. 

  512.         $sql .= " ,{$tbl3} AS t3 ".LB;
    513. 

  513.     }
    514. 

  514.     
    515. 

  515.     //--WHERE
    516. 

  516.     $sql .= " WHERE ".LB;
    517. 

  517.     
    518. 

  518.     if (count($idsary)<>0){
    519. 

  519.         if (strtoupper($mode)=="AND"){
    520. 

  520.             $w="";
    521. 

  521.             foreach( $idsary as $val ){
    522. 

  522.                 if ($w<>""){
    523. 

  523.                     $w.=" AND ";
    524. 

  524.                 }
    525. 

  525.                 $w.=$val." IN (SELECT t1.category_id";
    526. 

  526.                 $w.=" FROM {$tbl1} AS t1 ,{$tbl5} AS t5";
    527. 

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

  528.             }
    529. 

  529.         }else{
    530. 

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

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

  532.         }
    533. 

  533.         $sql.=" ({$w})".LB;
    534. 

  534.     }else{
    535. 

  535.         $sql.=" 1=1".LB;
    536. 

  536.     }
    537. 

  537.     
    538. 

  538.     if ($addfieldorder){
    539. 

  539.     
    540. 

  540.         $sql .= " AND t3.field_id=".$field_id.LB;
    541. 

  541.         $sql .= " AND t3.id=t2.id".LB;
    542. 

  542.     }
    543. 

  543. 

  544.     //管理者の時,下書データも含む
    545. 

  545.     //20110529 Del
    546. 

  546.     //if ( SEC_hasRights('databox.admin')) {
    547. 

  547.     //}else{
    548. 

  548.        $sql .= " AND t2.draft_flag=0".LB;
    549. 

  549.     //}
    550. 

  550. 

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

  552.     $sql .= COM_getPermSql('AND',0,2,"t2");
    553. 

  553. 

  554.     //公開日以前のデータはのぞく
    555. 

  555.     $sql .= " AND (released <= NOW())".LB;
    556. 

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

  557.     if  (strtoupper($expired)=="NO"){
    558. 

  558.         $sql .= " AND (expired=0 OR expired > NOW())";
    559. 

  559.     }
    560. 

  560.     if  ($without_code<>""){
    561. 

  561.         $sql .= " AND (t2.code<>'$without_code')";
    562. 

  562.     }
    563. 

  563.     if  ($without_id<>""){
    564. 

  564.         $sql .= " AND (t2.id<>$without_id)";
    565. 

  565.     }
    566. 

  566.     
    567. 

  567.     //--ORDER
    568. 

  568.     $sql .= " ORDER BY ".LB;
    569. 

  569.     $sql .= $orderby.LB;
    570. 

  570.     
    571. 

  571.     $result = DB_query ($sql);
    572. 

  572.     $cnt = DB_numRows ($result);
    573. 

  573. 

  574.     $pages = 0;
    575. 

  575.     if ($perpage > 0) {
    576. 

  576.         $pages = ceil($cnt / $perpage);
    577. 

  577.     }
    578. 

  578.     $offset = ($page - 1) * $perpage;
    579. 

  579.     $sql .= " LIMIT $offset, $perpage";
    580. 

  580. 

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

  582.     if ($autotag==="notautotag"){
    583. 

  583.         if ($page > 1) {
    584. 

  584.             $page_title = sprintf ('%s (%d)', $category_name, $page);
    585. 

  585.         } else {
    586. 

  586.             $page_title = sprintf ('%s ', $category_name);
    587. 

  587.         }
    588. 

  588.         
    589. 

  589.         // Meta Tags
    590. 

  590.         $headercode=DATABOX_getheadercode(
    591. 

  591.             "category"
    592. 

  592.             ,$template
    593. 

  593.             ,$pi_name
    594. 

  594.             ,$category_id
    595. 

  595.             ,$category_name
    596. 

  596.             ,$category_description
    597. 

  597.             ,$category_name
    598. 

  598.             ,$category_description);
    599. 

  599.         $retval .= DATABOX_siteHeader($pi_name,'',$page_title,$headercode) ;
    600. 

  600.     }
    601. 

  601.     
    602. 

  602. 

  603.     $result = DB_query ($sql);
    604. 

  604.     $numrows = DB_numRows ($result);
    605. 

  605. 

  606.     if ($numrows > 0) {
    607. 

  607.         
    608. 

  608.         $tmplfld=DATABOX_templatePath('category',$template,$pi_name);
    609. 

  609.         $templates = new Template($tmplfld);
    610. 

  610.         $templates->set_file (array (
    611. 

  611.             'list' => 'list_detail.thtml',
    612. 

  612.             'nav'   => 'navigation_detail.thtml',
    613. 

  613.             'row'   => 'row.thtml',
    614. 

  614.             'col'   => "col_detail.thtml",
    615. 

  615.             ));
    616. 

  616. 

  617.         $languageid=COM_getLanguageId();
    618. 

  618.         $language= COM_getLanguage();
    619. 

  619.         $templates->set_var ('languageid', $languageid);
    620. 

  620.         $templates->set_var ('language', $language);
    621. 

  621.         if ($languageid<>"") {
    622. 

  622.             $templates->set_var ('_languageid', "_".$languageid);
    623. 

  623.         }else{
    624. 

  624.             $templates->set_var ('_languageid', "");
    625. 

  625.         }
    626. 

  626. 

  627.         //
    628. 

  628.         $templates->set_var ('site_url',$_CONF['site_url']);
    629. 

  629.         $templates->set_var ('this_script',THIS_SCRIPT);
    630. 

  630. 

  631.         //bread
    632. 

  632.         $templates->set_var ('home',$LANG_DATABOX['home']);
    633. 

  633.         
    634. 

  634.         $templates->set_var ('lang_category_list_h2',$LANG_DATABOX['category_list_h2']);
    635. 

  635. 

  636.         $templates->set_var ('category_name',$category_name);
    637. 

  637.         $templates->set_var ('category_code',$category_code);
    638. 

  638.         $templates->set_var ('category_description',$category_description);
    639. 

  639. 

  640.         //page
    641. 

  641.         $templates->set_var ('cnt', $cnt);
    642. 

  642.         $lin1=$offset+1;
    643. 

  643.         $lin2=$lin1+$perpage - 1;
    644. 

  644.         if ($lin2>$cnt){
    645. 

  645.             $lin2=$cnt;
    646. 

  646.         }
    647. 

  647. 

  648.         //summary navigation
    649. 

  649.         $templates->set_var ('lang_view', $LANG_DATABOX['view']);
    650. 

  650.         $templates->set_var ('lin', $lin1."-".($lin2));
    651. 

  651.         $templates->set_var ('cnt', $cnt);
    652. 

  652. 

  653.         //
    654. 

  654.         $templates->set_var ('lang_title', $LANG_DATABOX_ADMIN['title']);
    655. 

  655.         $templates->set_var ('lang_code', $LANG_DATABOX_ADMIN['code']);
    656. 

  656.         $templates->set_var ('lang_id', $LANG_DATABOX_ADMIN['id']);
    657. 

  657.         $templates->set_var ('lang_description', $LANG_DATABOX_ADMIN['description']);
    658. 

  658.         $templates->set_var ('lang_date', $LANG_DATABOX_ADMIN[$datefield]);
    659. 

  659.         $templates->set_var ('lang_released', $LANG_DATABOX_ADMIN['released']);
    660. 

  660.         $templates->set_var ('lang_expired', $LANG_DATABOX_ADMIN['expired']);
    661. 

  661.         $templates->set_var ('lang_remaingdays', $LANG_DATABOX_ADMIN['remaingdays']);
    662. 

  662.         $templates->set_var ('lang_addfield', $addfield_name);
    663. 

  663.         // 追加項目のヘッダ
    664. 

  664.         $addition_def=DATABOX_getadditiondef($pi_name);
    665. 

  665.         
    666. 

  666.         //
    667. 

  667.         $templates->set_var('lang_imgfile_frd', $LANG_confignames['databox']['imgfile_frd']);
    668. 

  668.         $templates->set_var ('imgfile_frd', $_DATABOX_CONF['imgfile_frd']);
    669. 

  669.         $templates->set_var ('data_img_url', $_CONF['site_url']."/".$_DATABOX_CONF['imgfile_frd']);
    670. 

  670.         $templates->set_var('lang_imgfile_thumb_frd', $LANG_confignames['databox']['imgfile_thumb_frd']);
    671. 

  671.         $templates->set_var ('imgfile_thumb_frd', $_DATABOX_CONF['imgfile_thumb_frd']);
    672. 

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

  673.         
    674. 

  674.         for ($i = 0; $i < $numrows; $i++) {
    675. 

  675.             $A = DB_fetchArray ($result);
    676. 

  676.             $A = array_map('stripslashes', $A);
    677. 

  677. 

  678.             $title=$A['title'];
    679. 

  679.             $description=$A['description'];
    680. 

  680.             $code=COM_applyFilter($A['code']);
    681. 

  681.             $id=COM_applyFilter($A['id']);
    682. 

  682.             $datefield=COM_applyFilter($A['datefield']);
    683. 

  683.             $released=COM_applyFilter($A['released']);
    684. 

  684.             $expired=COM_applyFilter($A['expired']);
    685. 

  685.             $fieldset_id=COM_applyFilter($A['fieldset_id']);
    686. 

  686.             $datefield_ary = COM_getUserDateTimeFormat($A['datefield_un']);
    687. 

  687.             $released_ary = COM_getUserDateTimeFormat($A['released_un']);
    688. 

  688.             if ($expired==="0000-00-00 00:00:00"){
    689. 

  689.                 $expired_ary=array();
    690. 

  690.             }else{
    691. 

  691.                 $expired_ary = COM_getUserDateTimeFormat($A['expired_un']);
    692. 

  692.             }
    693. 

  693.             $curdate_ary =  COM_getUserDateTimeFormat();
    694. 

  694. 

  695.             
    696. 

  696.             $value=COM_applyFilter($A['value']);
    697. 

  697.             $group_id = $A['group_id'];
    698. 

  698.             $owner_id = $A['owner_id'];
    699. 

  699. 

  700.             $rt= databox_detail_link($id,$code,$title);
    701. 

  701. 

  702.             $templates->set_var ('data_link', $rt['link']);
    703. 

  703.             $templates->set_var ('data_title', $title);
    704. 

  704.             $templates->set_var ('data_code', $code);
    705. 

  705.             $templates->set_var ('data_description', $description);
    706. 

  706.             $templates->set_var ('data_id', $id);
    707. 

  707.             $templates->set_var ('data_url', $rt['url']);
    708. 

  708. 

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

  710.             $templates->set_var ('data_value', $value);
    711. 

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

  712.             $templates->set_var ('data_datefield_date', strftime( $_CONF['date'], $A['datefield_un'] ));
    713. 

  713.             $templates->set_var ('data_datefield_daytime', strftime( $_CONF['daytime'], $A['datefield_un'] ));
    714. 

  714.             $templates->set_var ('data_datefield_dateonly', strftime( $_CONF['dateonly'], $A['datefield_un'] ));
    715. 

  715.             $templates->set_var ('data_datefield_timeonly', strftime( $_CONF['timeonly'], $A['datefield_un'] ));
    716. 

  716.             $templates->set_var ('data_datefield_b', strftime( "%b" , $A['datefield_un']));
    717. 

  717.             $templates->set_var ('data_datefield_B', strftime( "%B" , $A['datefield_un']));
    718. 

  718.             $templates->set_var ('data_datefield_d', strftime( "%d" , $A['datefield_un']));
    719. 

  719.             $templates->set_var ('data_datefield_e', strftime( "%e" , $A['datefield_un']));
    720. 

  720.             
    721. 

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

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

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

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

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

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

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

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

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

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

  731.             //公開終了日 Expired to publish
    732. 

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

  733.                 $templates->set_var ('data_expired', "");
    734. 

  734.                 $templates->set_var ('data_expired_shortdate', "" );
    735. 

  735.                 $templates->set_var ('data_expired_date', "" );
    736. 

  736.                 $templates->set_var ('data_expired_daytime', "" );
    737. 

  737.                 $templates->set_var ('data_expired_dateonly', "" );
    738. 

  738.                 $templates->set_var ('data_expired_timeonly', "" );
    739. 

  739.                 $templates->set_var ('data_expired_b', "" );
    740. 

  740.                 $templates->set_var ('data_expired_B', "" );
    741. 

  741.                 $templates->set_var ('data_expired_d', "" );
    742. 

  742.                 $templates->set_var ('data_expired_e', "" );
    743. 

  743.             }else{
    744. 

  744.                 $wary = COM_getUserDateTimeFormat($A['expired_un']);
    745. 

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

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

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

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

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

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

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

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

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

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

  755.             }
    756. 

  756.             $remaingdays="";
    757. 

  757.             if ($expired<>"0000-00-00 00:00:00") {
    758. 

  758.                 if  ($expired_ary[1]>=$curdate_ary[1]){
    759. 

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

  760.                 }
    761. 

  761.             }
    762. 

  762.             $templates->set_var ('data_remaingdays', $remaingdays);//@@@@@@
    763. 

  763.             if (date("Ymd",strtotime($datefield)) >= date("Ymd",$chkday)){
    764. 

  764.                 $templates->set_var ('new_img', $new_img);
    765. 

  765.             }else{
    766. 

  766.                 $templates->set_var ('new_img', '');
    767. 

  767.             }
    768. 

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

  769.             $templates->set_var('lang_hits', $LANG_DATABOX_ADMIN['hits']);
    770. 

  770.             $templates->set_var('data_hits', $hits);
    771. 

  771.             
    772. 

  772.             //カテゴリ@@@@@
    773. 

  773.             $templates->set_var('lang_category', $LANG_DATABOX_ADMIN['category']);
    774. 

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

  775. 

  776.             //追加項目
    777. 

  777.             $chk_user=DATABOX_chkuser($group_id,$owner_id,"databox.admin");
    778. 

  778.             $additionfields = DATABOX_getadditiondatas($id,$pi_name);
    779. 

  779.             DATABOX_getaddtionfieldsDisp($additionfields,$addition_def,$templates,$chk_user,$pi_name,$fieldset_id);
    780. 

  780.             
    781. 

  781.             //管理者の時「編集」
    782. 

  782.             if ( SEC_hasRights('databox.admin')) {
    783. 

  783.                 $icon_url = $_CONF['layout_url'] . '/images/edit.' . $_IMAGE_TYPE;
    784. 

  784.                 $attr = array('title' => $title." ".$LANG_DATABOX_ADMIN['edit']);
    785. 

  785.                 $editiconhtml = COM_createImage($icon_url, $LANG_DATABOX_ADMIN['edit'], $attr);
    786. 

  786.                 
    787. 

  787.                 $attr = array('class' => 'editlink', 'title' => $title." ".$LANG_DATABOX_ADMIN['edit']);
    788. 

  788.                 $url = $_CONF['site_admin_url'];
    789. 

  789.                 $url .= '/plugins/databox/data.php';
    790. 

  790.                 $url .= '?mode=edit';
    791. 

  791.                 $url .= '&amp;'."id={$id}";
    792. 

  792.                 $icon = '&nbsp;' ;
    793. 

  793.                 $icon .=  COM_createLink( $editiconhtml,  $url,   $attr   );
    794. 

  794.                 $templates->set_var ('data_edit', $icon);
    795. 

  795.             }else{
    796. 

  796.                 $rt=databox_chk_loaddata($id);
    797. 

  797.                 //編集権限のあるMyData
    798. 

  798.                 if ( $rt==="OK") {
    799. 

  799.                     $icon_url = $_CONF['layout_url'] . '/images/edit.' . $_IMAGE_TYPE;
    800. 

  800.                     $attr = array('title' => $LANG_DATABOX_ADMIN['edit']);
    801. 

  801.                     $editiconhtml = COM_createImage($icon_url, $LANG_DATABOX_ADMIN['edit'], $attr);
    802. 

  802. 

  803.                     $attr = array('class' => 'editlink', 'title' => $title." ".$LANG_DATABOX_ADMIN['edit']);
    804. 

  804. 

  805.                     $url = $_CONF['site_url'];
    806. 

  806.                     $url .= '/databox/mydata/data.php';
    807. 

  807.                     $url .= '?mode=edit';
    808. 

  808.                     $url .= '&amp;'."id={$id}";
    809. 

  809. 

  810.                     $icon = '&nbsp;' ;
    811. 

  811.                     $icon .=  COM_createLink( $editiconhtml,  $url,   $attr   );
    812. 

  812. 

  813.                     $templates->set_var ('data_edit', $icon);
    814. 

  814.                 }else{
    815. 

  815.                     $templates->set_var ('data_edit', "");
    816. 

  816.                 }
    817. 

  817.                 
    818. 

  818.             }
    819. 

  819. 

  820.             
    821. 

  821.             //=====
    822. 

  822.             $templates->parse ('col_var', 'col', true);
    823. 

  823.             $templates->parse ('row_var', 'row', true);
    824. 

  824. 

  825.             $templates->set_var ('col_var', '');
    826. 

  826. 

  827.         }
    828. 

  828.         // Call to plugins to set template variables in the databox
    829. 

  829.         PLG_templateSetVars( 'databox', $templates );
    830. 

  830. 

  831.         //------------
    832. 

  832.         //-----navigation
    833. 

  833.         $url = $_CONF['site_url']  . '/';
    834. 

  834.         if ($autotag==="notautotag"){
    835. 

  835.             $url.=THIS_SCRIPT;
    836. 

  836.         }else{
    837. 

  837.             $url.="databox/category.php";
    838. 

  838.         }
    839. 

  839.         $url.="?";
    840. 

  840.         if ($category_code<>""){
    841. 

  841.             $url.="code=".$category_code;
    842. 

  842.             $url.="&amp;m=code";
    843. 

  843.         }else{
    844. 

  844.             $url .= "id=".$category_id;
    845. 

  845.             $url .= "&amp;m=id";
    846. 

  846.         }    
    847. 

  847.         $url .= "&amp;template=".$template;
    848. 

  848.         $url .= "&amp;order=";
    849. 

  849.         
    850. 

  850.         //-----order navigation
    851. 

  851.         databox_order ($url, $templates, $order) ;
    852. 

  852.         //-----page navigation
    853. 

  853.         $url .= $order;
    854. 

  854.         $templates->set_var ('page_navigation',
    855. 

  855.                 COM_printPageNavigation ($url, $page, $pages));
    856. 

  856.         if ($order==="random"){
    857. 

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

  858.         }else{
    859. 

  859.             $templates->set_var ( 'pagenavinone', '' );
    860. 

  860.         }
    861. 

  861.         //------------
    862. 

  862.         $templates->parse ('nav_var', 'nav', true);
    863. 

  863. 

  864.         $templates->set_var ('msg', "");
    865. 

  865. 

  866.         $templates->parse ('output', 'list');
    867. 

  867. 

  868.         $content = $templates->finish ($templates->get_var ('output'));
    869. 

  869.         $retval .=$content;
    870. 

  870. 

  871.     }else{
    872. 

  872.         if ($nohitmsg==="yes"){
    873. 

  873.             $tmplfld=DATABOX_templatePath('category',$template,$pi_name);
    874. 

  874.             $templates = new Template($tmplfld);
    875. 

  875.             $templates->set_file (array (
    876. 

  876.                 'list' => 'nohit.thtml',
    877. 

  877.             ));
    878. 

  878.             
    879. 

  879.             $templates->set_var ('home',$LANG_DATABOX['home']);
    880. 

  880.             
    881. 

  881.             $url=$_CONF['site_url']."/databox/category.php";
    882. 

  882.             $category_top="<a href='".$url."'>".$LANG_DATABOX['category_top']."</a>";
    883. 

  883.             $templates->set_var ('category_top',$category_top);
    884. 

  884. 

  885.             $templates->set_var ('category_name',$category_name);
    886. 

  886.             $templates->set_var ('category_code',$category_code);
    887. 

  887.             $templates->set_var ('category_description',$category_description);
    888. 

  888.             
    889. 

  889.                         
    890. 

  890.             $templates->set_var('xhtml', XHTML);
    891. 

  891.             $templates->set_var('site_url', $_CONF['site_url']);
    892. 

  892.             $templates->set_var('site_admin_url', $_CONF['site_admin_url']);
    893. 

  893.             $templates->set_var('layout_url', $_CONF['layout_url']);
    894. 

  894.             
    895. 

  895.             $templates->set_var ('lang_nohit', $LANG_DATABOX['nohit']);
    896. 

  896. 

  897.             $templates->parse ('output', 'list');
    898. 

  898.             $content = $templates->finish ($templates->get_var ('output'));
    899. 

  899.             $retval .=$content;
    900. 

  900. 

  901.         }
    902. 

  902.         
    903. 

  903.         
    904. 

  904.         
    905. 

  905.         
    906. 

  906.         
    907. 

  907.     }
    908. 

  908. 

  909.     $retval =PLG_replacetags ($retval);
    910. 

  910. 

  911.     return $retval;
    912. 

  912. }
    913. 

  913. 

  914. function databox_count(
    915. 

  915.     $category_id =null
    916. 

  916.     ,$category_code =null
    917. 

  917.     ,$mode=''
    918. 

  918.     ,$permission=''
    919. 

  919.     ,$numberformat=''
    920. 

  920. )
    921. 

  921. // +---------------------------------------------------------------------------+
    922. 

  922. // | 機能  件数表示                                                          |
    923. 

  923. // +---------------------------------------------------------------------------+
    924. 

  924. // | 書式  databox_count()
    925. 

  925. // | 書式  databox_count(1)
    926. 

  926. // | 書式  databox_count("japan")
    927. 

  927. // +---------------------------------------------------------------------------+
    928. 

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

  929. // | 引数 $category_code:カテゴリコード
    930. 

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

  931. // | 引数 $permission    :ブランク　または　ignore
    932. 

  932. // | 引数 $numberformat  :ブランク　または　yes
    933. 

  933. // +---------------------------------------------------------------------------+
    934. 

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

  935. // +---------------------------------------------------------------------------+
    936. 

  936. {
    937. 

  937.     global $_TABLES;
    938. 

  938.     
    939. 

  939.     //-----
    940. 

  940.     $tbl1=$_TABLES['DATABOX_base'] ;
    941. 

  941.     $tbl2=$_TABLES['DATABOX_category'] ;
    942. 

  942. 

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

  944.     $exp="";
    945. 

  945.     if (is_null($category_id) AND is_null($category_code) ){
    946. 

  946.     }else{
    947. 

  947.         $ids="";
    948. 

  948.         $idsary=array();
    949. 

  949.         if (is_null($category_id) OR $category_id==0){
    950. 

  950.             if (is_null($category_code)){
    951. 

  951.             }else{
    952. 

  952.                 $w=explode("|",$category_code);
    953. 

  953.                 foreach( $w as $val ){
    954. 

  954.                     if ($ids<>""){
    955. 

  955.                         $ids.=",";
    956. 

  956.                     }
    957. 

  957.                     $w_id=DATABOX_codetoid($val,'DATABOX_def_category',"category_id");
    958. 

  958.                     $idsary[]=$w_id;
    959. 

  959.                     $ids.=$w_id;
    960. 

  960.                 }
    961. 

  961.             }
    962. 

  962.         }else{
    963. 

  963.             $ids=$category_id;
    964. 

  964.             $idsary[]=$category_id;
    965. 

  965.         }
    966. 

  966.         if (strtoupper($mode)=="AND"){
    967. 

  967.             $w="";
    968. 

  968.             foreach( $idsary as $val ){
    969. 

  969.                 if ($w<>""){
    970. 

  970.                     $w.=" AND ";
    971. 

  971.                 }
    972. 

  972.                 $w.=$val." IN (SELECT category_id";
    973. 

  973.                 $w.=" FROM {$tbl2} AS t2 ";
    974. 

  974.                 $w.=" WHERE t2.id = t1.id)";
    975. 

  975.             }
    976. 

  976.         }else{
    977. 

  977.             $w= "id IN (SELECT id FROM {$tbl2} ";
    978. 

  978.             $w.="WHERE category_id IN ({$ids})) ";
    979. 

  979.         }
    980. 

  980.         $exp=$w.LB;
    981. 

  981.     }
    982. 

  982.     
    983. 

  983.     //-----
    984. 

  984.     $sql = "SELECT ".LB;
    985. 

  985. 

  986.     $sql .= " distinct t1.id ".LB;
    987. 

  987. 

  988.     $sql .= " FROM ".LB;
    989. 

  989. 

  990.     $sql .= " {$tbl1} AS t1 ".LB;
    991. 

  991. 

  992.     $sql .= " WHERE ".LB;
    993. 

  993.     
    994. 

  994.     if ($exp<>""){
    995. 

  995.         $sql .= $exp. " AND ";
    996. 

  996.     }
    997. 

  997. 

  998.     //@@@@@@@@@--------->
    999. 

  999.     //下書はのぞく
    1000. 

  1000.     $sql .= " t1.draft_flag=0".LB;
    1001. 

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

  1002.     if  (strtoupper($permission)=="IGNORE"){
    1003. 

  1003.     }else{
    1004. 

  1004.         $sql .= COM_getPermSql('AND').LB;
    1005. 

  1005.     }
    1006. 

  1006.     //公開日以前のデータはのぞく
    1007. 

  1007.     $sql .= " AND (released <= NOW())".LB;
    1008. 

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

  1009.     $sql .= " AND (expired=0 OR expired > NOW())".LB;
    1010. 

  1010.     //@@@@@@@@@<---------
    1011. 

  1011. 

  1012.     $result = DB_query ($sql);
    1013. 

  1013.     $cnt = DB_numRows ($result);
    1014. 

  1014.     
    1015. 

  1015.     if  (strtoupper($numberformat)=="YES"){
    1016. 

  1016.         $rt=COM_NumberFormat($cnt);
    1017. 

  1017.     }else{
    1018. 

  1018.         $rt=$cnt;
    1019. 

  1019.     }
    1020. 

  1020.     
    1021. 

  1021.     return $rt;
    1022. 

  1022. 

  1023. }
    1024. 

  1024. 

  1025. function databox_field(
    1026. 

  1026.     $autotag
    1027. 

  1027.     ,$field_id=null
    1028. 

  1028.     ,$value=""
    1029. 

  1029.     ,$template=null
    1030. 

  1030.     ,$nohitmsg=""
    1031. 

  1031.     ,$perpage =0
    1032. 

  1032.     ,$page=null
    1033. 

  1033.     ,$order=null
    1034. 

  1034.     ,$field_code=null
    1035. 

  1035. )
    1036. 

  1036. // +---------------------------------------------------------------------------+
    1037. 

  1037. // | 機能  アトリビュート別一覧表示
    1038. 

  1038. // | 書式
    1039. 

  1039. // +---------------------------------------------------------------------------+
    1040. 

  1040. // | 引数 $autotag:notautotagの時ヘッダを表示しない
    1041. 

  1041. // | 引数 $field_id:追加属性id
    1042. 

  1042. // | 引数 $value:表示する項目の値
    1043. 

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

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

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

  1046. // | 引数 $page           :
    1047. 

  1047. // | 引数 $order         :順序
    1048. 

  1048. // | 引数 $field_code    :
    1049. 

  1049. // +---------------------------------------------------------------------------+
    1050. 

  1050. // | public_html/attribute.php および　自動タグで使用
    1051. 

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

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

  1053. // +---------------------------------------------------------------------------+
    1054. 

  1054. // | 戻値 nomal:attribute list
    1055. 

  1055. // +---------------------------------------------------------------------------+
    1056. 

  1056. {
    1057. 

  1057. 

  1058.     $pi_name="databox";
    1059. 

  1059. 

  1060.     global $_CONF;
    1061. 

  1061.     global $_TABLES;
    1062. 

  1062.     global $_DATABOX_CONF;
    1063. 

  1063.     global $LANG_DATABOX;
    1064. 

  1064.     global $LANG_DATABOX_ADMIN;
    1065. 

  1065.     global $LANG_DATABOX_NOYES;
    1066. 

  1066.     global $_IMAGE_TYPE;
    1067. 

  1067.     global $LANG_confignames;
    1068. 

  1068.     global $_PLUGINS;
    1069. 

  1069.     global $_MAPS_CONF;
    1070. 

  1070. 

  1071.     //ログイン要否チェック
    1072. 

  1072.     if (COM_isAnonUser()){
    1073. 

  1073.         if  ($_CONF['loginrequired']
    1074. 

  1074.                 OR ($_DATABOX_CONF['loginrequired'] >1) ){
    1075. 

  1075.             return $LANG_DATABOX['loginrequired'];
    1076. 

  1076.         }
    1077. 

  1077. 

  1078.     }
    1079. 

  1079.     //-----table assign
    1080. 

  1080.     $tbl1=$_TABLES['DATABOX_addition'] ;
    1081. 

  1081.     $tbl2=$_TABLES['DATABOX_base'] ;
    1082. 

  1082.     $tbl3=$_TABLES['DATABOX_addition'] ;
    1083. 

  1083.     $tbl5=$_TABLES['DATABOX_stats'];
    1084. 

  1084. 

  1085.     //日付関連
    1086. 

  1086.     $datefield=$_DATABOX_CONF['datefield'];//使用する日付（編集日付、作成日付、公開日）
    1087. 

  1087.     $new_img=$_DATABOX_CONF['new_img'];
    1088. 

  1088.     if ($new_img==""){
    1089. 

  1089.         $new_img="New!";
    1090. 

  1090.     }
    1091. 

  1091.     $newmarkday=$_DATABOX_CONF['newmarkday'];
    1092. 

  1092.     if ($newmarkday==""){
    1093. 

  1093.         $newmarkday=3;
    1094. 

  1094.     }
    1095. 

  1095.     $chkday=strtotime("- $newmarkday days",time());
    1096. 

  1096. 

  1097. 

  1098.     //-----引数チェック
    1099. 

  1099.     if (is_null($value) OR $value==="") {
    1100. 

  1100.         return;
    1101. 

  1101.     }
    1102. 

  1102.     if (is_null($field_id)){
    1103. 

  1103.         if ($field_code===""){
    1104. 

  1104.             $field_id=0;
    1105. 

  1105.         }else{
    1106. 

  1106.             $field_id=DATABOX_codetoid($field_code,'DATABOX_def_field',"field_id","templatesetvar");
    1107. 

  1107.         }
    1108. 

  1108.     }
    1109. 

  1109.     if ($field_id===0) {
    1110. 

  1110.         return;
    1111. 

  1111.     }
    1112. 

  1112.     if ($field_code===""){
    1113. 

  1113.         $field_code=DB_getItem( $_TABLES['DATABOX_def_field']
    1114. 

  1114.                  ,"templatesetvar","field_id={$field_id}");
    1115. 

  1115.     }
    1116. 

  1116.     
    1117. 

  1117.     $field_def=DATABOX_getadditiondef($pi_name);
    1118. 

  1118.     $type=$field_def[$field_id]['type'];
    1119. 

  1119.     $w = array(0,2,3,4,7,8,9,16);
    1120. 

  1120.     if (in_array ($type,$w)){
    1121. 

  1121.     }else{
    1122. 

  1122.         return;
    1123. 

  1123.     }
    1124. 

  1124.     $allow_display=$field_def[$field_id]['allow_display'];
    1125. 

  1125.     if ($allow_display<2){
    1126. 

  1126.     }else{
    1127. 

  1127.         return;
    1128. 

  1128.     }
    1129. 

  1129.     //
    1130. 

  1130.     if (is_null($page) OR !isset($page) OR $page == 0) {
    1131. 

  1131.         $page = 1;
    1132. 

  1132.     }
    1133. 

  1133.     if ($perpage===0 OR is_null($perpage)){
    1134. 

  1134.         $perpage=$_DATABOX_CONF['perpage'];
    1135. 

  1135.     }
    1136. 

  1136.     
    1137. 

  1137.     $w=databox_orderby($datefield,$order,$orderby,$addfieldorder,$orderfield_id);
    1138. 

  1138.     
    1139. 

  1139.     $field_def[$field_id]['name'];
    1140. 

  1140.     $field_name=$field_def[$field_id]['name'];
    1141. 

  1141.     $field_templatesetvar=$field_def[$field_id]['templatesetvar'];
    1142. 

  1142.     $field_description=$field_def[$field_id]['description'];
    1143. 

  1143. 

  1144.     $fieldvalue=DATABOX_getfieldvalue(
    1145. 

  1145.           $value
    1146. 

  1146.          ,$field_def[$field_id]['type']
    1147. 

  1147.          ,$field_def[$field_id]['selectionary']
    1148. 

  1148.          ,$LANG_DATABOX_NOYES
    1149. 

  1149.          ,$field_def[$field_id]['selectlist']
    1150. 

  1150.          ,$pi_name
    1151. 

  1151.           );
    1152. 

  1152. 

  1153. 

  1154.     if (is_null($template) or ($template==="")){
    1155. 

  1155.         $template="default";
    1156. 

  1156.     }
    1157. 

  1157. 

  1158. 

  1159.     $sql = "SELECT DISTINCT";
    1160. 

  1160. 

  1161.     $sql .= " t2.id ".LB;
    1162. 

  1162.     $sql .= " ,t2.title ".LB;
    1163. 

  1163.     $sql .= " ,t2.code ".LB;
    1164. 

  1164.     $sql .= " ,t2.description ".LB;
    1165. 

  1165.     $sql .= " ,t2.".$datefield." AS datefield ".LB;
    1166. 

  1166.     $sql .= " ,t2.expired ".LB;
    1167. 

  1167.     $sql .= " ,UNIX_TIMESTAMP(t2.".$datefield.") AS datefield_un ".LB;
    1168. 

  1168.     $sql .= " ,UNIX_TIMESTAMP(t2.released ) AS released_un ".LB;
    1169. 

  1169.     $sql .= " ,UNIX_TIMESTAMP(t2.expired ) AS expired_un ".LB;
    1170. 

  1170. 

  1171.     $sql .= " ,t2.group_id";
    1172. 

  1172.     $sql .= " ,t2.owner_id";
    1173. 

  1173.     
    1174. 

  1174.     $sql .= " ,t2.fieldset_id ".LB;
    1175. 

  1175.     
    1176. 

  1176.     if ($addfieldorder){
    1177. 

  1177.         $sql .= " ,t3.value ".LB;
    1178. 

  1178.     }
    1179. 

  1179. 

  1180.     $sql .= " FROM ".LB;
    1181. 

  1181.     $sql .= " {$tbl2} AS t2 ".LB;
    1182. 

  1182.     $sql .= " ,{$tbl1} AS t1 ".LB;
    1183. 

  1183.     if ($addfieldorder){
    1184. 

  1184.         $sql .= " ,{$tbl3} AS t3 ".LB;
    1185. 

  1185.     }
    1186. 

  1186. 

  1187.     $sql .= " WHERE ".LB;
    1188. 

  1188.     $sql .= " t1.field_id = ".$field_id.LB;
    1189. 

  1189.     $sql .= " AND t1.id = t2.id ".LB;
    1190. 

  1190.     $sql .= " AND t1.value = \"".$value."\"".LB;
    1191. 

  1191.     if ($addfieldorder){
    1192. 

  1192.         $sql .= " AND t3.field_id=".$orderfield_id.LB;
    1193. 

  1193.         $sql .= " AND t3.id=t2.id".LB;
    1194. 

  1194.     }
    1195. 

  1195. 

  1196. 

  1197.     //管理者の時,下書データも含む
    1198. 

  1198.     //if ( SEC_hasRights('databox.admin')) {
    1199. 

  1199.     //}else{
    1200. 

  1200.        $sql .= " AND t2.draft_flag=0".LB;
    1201. 

  1201.     //}
    1202. 

  1202.     
    1203. 

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

  1204.     $sql .= COM_getPermSql('AND',0,2,"t2");
    1205. 

  1205.     //公開日以前のデータはのぞく
    1206. 

  1206.     $sql .= " AND (released <= NOW())".LB;
    1207. 

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

  1208.     $sql .= " AND (expired=0 OR expired > NOW())";
    1209. 

  1209. 

  1210.     $sql .= " ORDER BY ".LB;
    1211. 

  1211.     $sql .= $orderby.LB;
    1212. 

  1212.     
    1213. 

  1213.     $result = DB_query ($sql);
    1214. 

  1214.     $cnt = DB_numRows ($result);
    1215. 

  1215. 

  1216.     $pages = 0;
    1217. 

  1217.     if ($perpage > 0) {
    1218. 

  1218.         $pages = ceil($cnt / $perpage);
    1219. 

  1219.     }
    1220. 

  1220.     $offset = ($page - 1) * $perpage;
    1221. 

  1221.     $sql .= " LIMIT $offset, $perpage";
    1222. 

  1222. 

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

  1224.     if ($autotag==="notautotag"){
    1225. 

  1225.         if ($page > 1) {
    1226. 

  1226.             $page_title = sprintf ('%s (%d)', $field_name, $page);
    1227. 

  1227.         } else {
    1228. 

  1228.             $page_title = sprintf ('%s ', $field_name);
    1229. 

  1229.         }
    1230. 

  1230.         $headercode=DATABOX_getheadercode(    
    1231. 

  1231.             "attribute"
    1232. 

  1232.             ,$template
    1233. 

  1233.             ,$pi_name
    1234. 

  1234.             ,$field_id
    1235. 

  1235.             ,$field_name
    1236. 

  1236.             ,$field_description
    1237. 

  1237.             ,$field_name
    1238. 

  1238.             ,$field_description);
    1239. 

  1239. 

  1240.         $retval .= DATABOX_siteHeader($pi_name,'',$page_title,$headercode);
    1241. 

  1241.     }
    1242. 

  1242. 

  1243.     
    1244. 

  1244.     //
    1245. 

  1245.     $addition_def=DATABOX_getadditiondef($pi_name);
    1246. 

  1246.     //
    1247. 

  1247.     $url=$_CONF['site_url']."/databox/attribute.php";
    1248. 

  1248.     $attribute_top="<a href='".$url."'>".$LANG_DATABOX['attribute_top']."</a>";
    1249. 

  1249.     $url=$_CONF['site_url']."/databox/attribute.php?";
    1250. 

  1250.     $url.="m=id&amp;id=".$field_id;
    1251. 

  1251.     $field_top="<a href='".$url."'>".$field_name.$LANG_DATABOX['countlist']."</a>";
    1252. 

  1252.     $result = DB_query ($sql);
    1253. 

  1253.     $numrows = DB_numRows ($result);
    1254. 

  1254. 

  1255.     if ($numrows > 0) {
    1256. 

  1256.         $tmplfld=DATABOX_templatePath('attribute',$template,$pi_name);
    1257. 

  1257.         $templates = new Template($tmplfld);
    1258. 

  1258.         $templates->set_file (array (
    1259. 

  1259.             'list' => 'list_detail.thtml',
    1260. 

  1260.             'nav'   => 'navigation_detail.thtml',
    1261. 

  1261.             'row'   => 'row.thtml',
    1262. 

  1262.             'col'   => "col_detail.thtml",
    1263. 

  1263.             ));
    1264. 

  1264.         
    1265. 

  1265.         $languageid=COM_getLanguageId();
    1266. 

  1266.         $language= COM_getLanguage();
    1267. 

  1267.         $templates->set_var ('languageid', $languageid);
    1268. 

  1268.         $templates->set_var ('language', $language);
    1269. 

  1269.         if ($languageid<>"") {
    1270. 

  1270.             $templates->set_var ('_languageid', "_".$languageid);
    1271. 

  1271.         }else{
    1272. 

  1272.             $templates->set_var ('_languageid', "");
    1273. 

  1273.         }
    1274. 

  1274. 

  1275.         //
    1276. 

  1276.         $templates->set_var ('site_url',$_CONF['site_url']);
    1277. 

  1277.         $templates->set_var ('this_script',THIS_SCRIPT);
    1278. 

  1278. 

  1279.         //bread
    1280. 

  1280.         $templates->set_var ('home',$LANG_DATABOX['home']);
    1281. 

  1281.         $templates->set_var ('attribute_top',$attribute_top);
    1282. 

  1282.         $templates->set_var ('field_top',$field_top);
    1283. 

  1283.         
    1284. 

  1284.         $templates->set_var ('field_name',$field_name);
    1285. 

  1285.         $templates->set_var ('field_templatesetvar',$field_templatesetvar);
    1286. 

  1286.         $templates->set_var ('field_description',$field_description);
    1287. 

  1287.         
    1288. 

  1288.         $templates->set_var ('fieldvalue',$fieldvalue);
    1289. 

  1289. 

  1290.         $templates->set_var ('addition_name',$additon_name);
    1291. 

  1291.         $templates->set_var ('addition_code',$additon_code);
    1292. 

  1292. 

  1293.         //page
    1294. 

  1294.         $templates->set_var ('cnt', $cnt);
    1295. 

  1295.         $lin1=$offset+1;
    1296. 

  1296.         $lin2=$lin1+$perpage - 1;
    1297. 

  1297.         if ($lin2>$cnt){
    1298. 

  1298.             $lin2=$cnt;
    1299. 

  1299.         }
    1300. 

  1300. 

  1301.         //summary navigation
    1302. 

  1302.         $templates->set_var ('lang_view', $LANG_DATABOX['view']);
    1303. 

  1303.         $templates->set_var ('lin', $lin1."-".($lin2));
    1304. 

  1304.         $templates->set_var ('cnt', $cnt);
    1305. 

  1305. 

  1306.         $templates->set_var ('lang_code', $LANG_DATABOX_ADMIN['code']);
    1307. 

  1307.         $templates->set_var ('lang_id', $LANG_DATABOX_ADMIN['id']);
    1308. 

  1308. 

  1309.         //
    1310. 

  1310.         $templates->set_var ('lang_date', $LANG_DATABOX_ADMIN[$datefield]);
    1311. 

  1311.         $templates->set_var ('lang_title', $LANG_DATABOX_ADMIN['title']);
    1312. 

  1312.         $templates->set_var ('lang_description', $LANG_DATABOX_ADMIN['description']);
    1313. 

  1313.         $templates->set_var ('lang_released', $LANG_DATABOX_ADMIN['released']);
    1314. 

  1314.         $templates->set_var ('lang_expired', $LANG_DATABOX_ADMIN['expired']);
    1315. 

  1315.         $templates->set_var ('lang_remaingdays', $LANG_DATABOX_ADMIN['remaingdays']);
    1316. 

  1316.         $templates->set_var ('lang_addfield', $addfield_name);
    1317. 

  1317.         
    1318. 

  1318.         //$_DATABOX_CONF
    1319. 

  1319.         $templates->set_var('lang_imgfile_frd', $LANG_confignames['databox']['imgfile_frd']);
    1320. 

  1320.         $templates->set_var ('imgfile_frd', $_DATABOX_CONF['imgfile_frd']);
    1321. 

  1321.         $templates->set_var ('data_img_url', $_CONF['site_url']."/".$_DATABOX_CONF['imgfile_frd']);
    1322. 

  1322.         $templates->set_var('lang_imgfile_thumb_frd', $LANG_confignames['databox']['imgfile_thumb_frd']);
    1323. 

  1323.         $templates->set_var ('imgfile_thumb_frd', $_DATABOX_CONF['imgfile_thumb_frd']);
    1324. 

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

  1325.         
    1326. 

  1326.         $mkids="";
    1327. 

  1327.         for ($i = 0; $i < $numrows; $i++) {
    1328. 

  1328.             $A = DB_fetchArray ($result);
    1329. 

  1329.             $A = array_map('stripslashes', $A);
    1330. 

  1330. 

  1331.             $title=COM_applyFilter($A['title']);
    1332. 

  1332.             $description=COM_applyFilter($A['description']);
    1333. 

  1333.             $code=COM_applyFilter($A['code']);
    1334. 

  1334.             $id=COM_applyFilter($A['id']);
    1335. 

  1335.             $datefield=COM_applyFilter($A['datefield']);
    1336. 

  1336.             $released=COM_applyFilter($A['released']);
    1337. 

  1337.             $expired=COM_applyFilter($A['expired']);
    1338. 

  1338.             $datefield_ary = COM_getUserDateTimeFormat($A['datefield_un']);
    1339. 

  1339.             $released_ary = COM_getUserDateTimeFormat($A['released_un']);
    1340. 

  1340.             if ($expired==="0000-00-00 00:00:00"){
    1341. 

  1341.                 $expired_ary=array();
    1342. 

  1342.             }else{    
    1343. 

  1343.                 $expired_ary = COM_getUserDateTimeFormat($A['expired_un']);
    1344. 

  1344.             }
    1345. 

  1345.             $curdate_ary =  COM_getUserDateTimeFormat();
    1346. 

  1346.             
    1347. 

  1347.             $sortvalue=COM_applyFilter($A['value']);
    1348. 

  1348.             $group_id = $A['group_id'];
    1349. 

  1349.             $owner_id = $A['owner_id'];
    1350. 

  1350.             
    1351. 

  1351.             $fieldset_id=COM_applyFilter($A['fieldset_id']);
    1352. 

  1352. 

  1353.             $rt=databox_detail_link($id,$code,$title);
    1354. 

  1354.             
    1355. 

  1355.             $templates->set_var ('data_link', $rt['link']);
    1356. 

  1356.             $templates->set_var ('data_title', $title);
    1357. 

  1357.             $templates->set_var ('data_code', $code);
    1358. 

  1358.             $templates->set_var ('data_description', $description);
    1359. 

  1359.             $templates->set_var ('data_id', $id);
    1360. 

  1360.             $templates->set_var ('data_url', $rt['url']);
    1361. 

  1361.             
    1362. 

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

  1363.             $templates->set_var ('data_value', $sortvalue);
    1364. 

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

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

  1366.             $templates->set_var ('data_datefield_date', strftime( $_CONF['date'], $A['datefield_un'] ));
    1367. 

  1367.             $templates->set_var ('data_datefield_daytime', strftime( $_CONF['daytime'], $A['datefield_un'] ));
    1368. 

  1368.             $templates->set_var ('data_datefield_dateonly', strftime( $_CONF['dateonly'], $A['datefield_un'] ));
    1369. 

  1369.             $templates->set_var ('data_datefield_timeonly', strftime( $_CONF['timeonly'], $A['datefield_un'] ));
    1370. 

  1370.             $templates->set_var ('data_datefield_b', strftime( "%b" , $A['datefield_un']));
    1371. 

  1371.             $templates->set_var ('data_datefield_B', strftime( "%B" , $A['datefield_un']));
    1372. 

  1372.             $templates->set_var ('data_datefield_d', strftime( "%d" , $A['datefield_un']));
    1373. 

  1373.             $templates->set_var ('data_datefield_e', strftime( "%e" , $A['datefield_un']));
    1374. 

  1374.             
    1375. 

  1375.             $templates->set_var ('data_released', $released_ary[0]);//@@@@@@
    1376. 

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

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

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

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

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

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

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

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

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

  1385.             
    1386. 

  1386.             //公開終了日 Expired to publish
    1387. 

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

  1388.                 $templates->set_var ('data_expired', "");
    1389. 

  1389.                 $templates->set_var ('data_expired_shortdate', "" );
    1390. 

  1390.                 $templates->set_var ('data_expired_date', "" );
    1391. 

  1391.                 $templates->set_var ('data_expired_daytime', "" );
    1392. 

  1392.                 $templates->set_var ('data_expired_dateonly', "" );
    1393. 

  1393.                 $templates->set_var ('data_expired_timeonly', "" );
    1394. 

  1394.                 $templates->set_var ('data_expired_b', "" );
    1395. 

  1395.                 $templates->set_var ('data_expired_B', "" );
    1396. 

  1396.                 $templates->set_var ('data_expired_d', "" );
    1397. 

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

  1398.             }else{
    1399. 

  1399.                 $wary = COM_getUserDateTimeFormat($A['expired_un']);
    1400. 

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

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

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

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

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

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

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

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

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

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

  1410.             }
    1411. 

  1411.             
    1412. 

  1412.             $remaingdays="";
    1413. 

  1413.             if ($expired<>"0000-00-00 00:00:00") {
    1414. 

  1414.                 if  ($expired_ary[1]>=$curdate_ary[1]){
    1415. 

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

  1416.                 }
    1417. 

  1417.             }
    1418. 

  1418.             $templates->set_var ('data_remaingdays', $remaingdays);//@@@@@@
    1419. 

  1419.             if (date("Ymd",strtotime($datefield)) >= date("Ymd",$chkday)){
    1420. 

  1420.                 $templates->set_var ('new_img', $new_img);
    1421. 

  1421.             }else{
    1422. 

  1422.                 $templates->set_var ('new_img', '');
    1423. 

  1423.             }
    1424. 

  1424.             
    1425. 

  1425.             $hits=COM_applyFilter(DB_getItem( $tbl5 ,"hits","id={$id}"),true);
    1426. 

  1426.             $templates->set_var('lang_hits', $LANG_DATABOX_ADMIN['hits']);
    1427. 

  1427.             $templates->set_var('data_hits', $hits);
    1428. 

  1428. 

  1429.             //カテゴリ@@@@@
    1430. 

  1430.             $templates->set_var('lang_category', $LANG_DATABOX_ADMIN['category']);
    1431. 

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

  1432. 

  1433.             //追加項目
    1434. 

  1434.             $group_id = stripslashes($A['group_id']);
    1435. 

  1435.             $owner_id = stripslashes($A['owner_id']);
    1436. 

  1436.             $chk_user=DATABOX_chkuser($group_id,$owner_id,"databox.admin");
    1437. 

  1437.             $additionfields = DATABOX_getadditiondatas($id,$pi_name);
    1438. 

  1438.             DATABOX_getaddtionfieldsDisp($additionfields,$addition_def,$templates,$chk_user,$pi_name,$fieldset_id);
    1439. 

  1439.             
    1440. 

  1440.             //管理者の時「編集」
    1441. 

  1441.             if ( SEC_hasRights('databox.admin')) {
    1442. 

  1442.                 $icon_url = $_CONF['layout_url'] . '/images/edit.' . $_IMAGE_TYPE;
    1443. 

  1443.                 $attr = array('title' => $title." ".$LANG_DATABOX_ADMIN['edit']);
    1444. 

  1444.                 $editiconhtml = COM_createImage($icon_url, $LANG_DATABOX_ADMIN['edit'], $attr);
    1445. 

  1445.                 
    1446. 

  1446.                 $attr = array('class' => 'editlink', 'title' => $title." ".$LANG_DATABOX_ADMIN['edit']);
    1447. 

  1447.                 $url = $_CONF['site_admin_url'];
    1448. 

  1448.                 $url .= '/plugins/databox/data.php';
    1449. 

  1449.                 $url .= '?mode=edit';
    1450. 

  1450.                 $url .= '&amp;'."id={$id}";
    1451. 

  1451.                 $icon = '&nbsp;' ;
    1452. 

  1452.                 $icon .=  COM_createLink( $editiconhtml,  $url,   $attr   );
    1453. 

  1453.                 $templates->set_var ('data_edit', $icon);
    1454. 

  1454.             }else{
    1455. 

  1455.                 $rt=databox_chk_loaddata($id);
    1456. 

  1456.                 //編集権限のあるMyData
    1457. 

  1457.                 if ( $rt==="OK") {
    1458. 

  1458.                     $icon_url = $_CONF['layout_url'] . '/images/edit.' . $_IMAGE_TYPE;
    1459. 

  1459.                     $attr = array('title' => $LANG_DATABOX_ADMIN['edit']);
    1460. 

  1460.                     $editiconhtml = COM_createImage($icon_url, $LANG_DATABOX_ADMIN['edit'], $attr);
    1461. 

  1461. 

  1462.                     $attr = array('class' => 'editlink', 'title' => $title." ".$LANG_DATABOX_ADMIN['edit']);
    1463. 

  1463. 

  1464.                     $url = $_CONF['site_url'];
    1465. 

  1465.                     $url .= '/databox/mydata/data.php';
    1466. 

  1466.                     $url .= '?mode=edit';
    1467. 

  1467.                     $url .= '&amp;'."id={$id}";
    1468. 

  1468. 

  1469.                     $icon = '&nbsp;' ;
    1470. 

  1470.                     $icon .=  COM_createLink( $editiconhtml,  $url,   $attr   );
    1471. 

  1471. 

  1472.                     $templates->set_var ('data_edit', $icon);
    1473. 

  1473.                 }else{
    1474. 

  1474.                     $templates->set_var ('data_edit', "");
    1475. 

  1475.                 }
    1476. 

  1476.                 
    1477. 

  1477.             }
    1478. 

  1478.             //maps plugin link
    1479. 

  1479.             $mkid="";
    1480. 

  1480.             if (in_array("maps", $_PLUGINS)){
    1481. 

  1481.                 if ($code<>""){
    1482. 

  1482.                     $mkid=DB_getItem($_TABLES['maps_markers'],"mkid","item_10='$code'");
    1483. 

  1483.                     $mkids.=$mkid." ";
    1484. 

  1484.                 }
    1485. 

  1485.             }
    1486. 

  1486. 

  1487.             //=====
    1488. 

  1488.             $templates->parse ('col_var', 'col', true);
    1489. 

  1489.             $templates->parse ('row_var', 'row', true);
    1490. 

  1490. 

  1491.             $templates->set_var ('col_var', '');
    1492. 

  1492. 

  1493.         }
    1494. 

  1494.         $mkids=rtrim($mkids," ");
    1495. 

  1495.         $mkidary=array();
    1496. 

  1496.         $mkid_ary=split(" " , $mkids);
    1497. 

  1497.         $selectedMarkers="";
    1498. 

  1498.         if (function_exists("MAPS_selectedMarkers") AND $mkids<>"") {
    1499. 

  1499.             $selectedMarkers=MAPS_selectedMarkers(
    1500. 

  1500.               $_MAPS_CONF['map_width']
    1501. 

  1501.              ,$_MAPS_CONF['map_height']
    1502. 

  1502.              ,$_MAPS_CONF['map_zoom']
    1503. 

  1503.              ,$mkid_ary);
    1504. 

  1504.         }
    1505. 

  1505.         $templates->set_var ('mkids', $mkids);
    1506. 

  1506.         $templates->set_var ('selectedMarkers', $selectedMarkers);
    1507. 

  1507. 

  1508.         //------------
    1509. 

  1509.         //-----navigation
    1510. 

  1510.         $url = $_CONF['site_url']  . '/';
    1511. 

  1511.         if ($autotag==="notautotag"){
    1512. 

  1512.             $url.=THIS_SCRIPT;
    1513. 

  1513.         }else{
    1514. 

  1514.             $url.="databox/attribute.php";
    1515. 

  1515.         }
    1516. 

  1516.         $url .= "?m=id";
    1517. 

  1517.         $url .= "&amp;id=".$field_id;
    1518. 

  1518.         $url .= "&amp;value=".$value;
    1519. 

  1519.         $url .= "&amp;template=".$template;
    1520. 

  1520.         $url .= "&amp;perpage=".$perpage;
    1521. 

  1521.         $url .= "&amp;order=";
    1522. 

  1522. 

  1523.         //-----order navigation
    1524. 

  1524.         databox_order($url, $templates, $order) ;
    1525. 

  1525.         //-----page navigation
    1526. 

  1526.         $url .= $order;
    1527. 

  1527.         $templates->set_var ('page_navigation',
    1528. 

  1528.                 COM_printPageNavigation ($url, $page, $pages));
    1529. 

  1529.         if ($order==="random"){
    1530. 

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

  1531.         }else{
    1532. 

  1532.             $templates->set_var ( 'pagenavinone', '' );
    1533. 

  1533.         }
    1534. 

  1534.         // Call to plugins to set template variables in the databox
    1535. 

  1535.         PLG_templateSetVars( 'databox', $templates );
    1536. 

  1536. 

  1537.         //------------
    1538. 

  1538.         $templates->parse ('nav_var', 'nav', true);
    1539. 

  1539. 

  1540.         $templates->set_var ('msg', "");
    1541. 

  1541. 

  1542.         $templates->parse ('output', 'list');
    1543. 

  1543. 

  1544.         $content = $templates->finish ($templates->get_var ('output'));
    1545. 

  1545.         $retval .=$content;
    1546. 

  1546. 

  1547.     }else{
    1548. 

  1548. 

  1549.         if ($nohitmsg==="yes"){
    1550. 

  1550.             $tmplfld=DATABOX_templatePath('attribute',$template,$pi_name);
    1551. 

  1551.             $templates = new Template($tmplfld);
    1552. 

  1552.             $templates->set_file (array (
    1553. 

  1553.                 'list' => 'nohit.thtml',
    1554. 

  1554.             ));
    1555. 

  1555.             
    1556. 

  1556.             //bread
    1557. 

  1557.             $templates->set_var ('home',$LANG_DATABOX['home']);
    1558. 

  1558.             $templates->set_var ('attribute_top',$attribute_top);
    1559. 

  1559.             $templates->set_var ('field_top',$field_top);
    1560. 

  1560.             
    1561. 

  1561.             $templates->set_var ('field_name',$field_name);
    1562. 

  1562.             $templates->set_var ('field_templatesetvar',$templatesetvar);
    1563. 

  1563.             $templates->set_var ('field_description',$field_description);
    1564. 

  1564.             
    1565. 

  1565.             $templates->set_var ('fieldvalue',$fieldvalue);
    1566. 

  1566.                         
    1567. 

  1567.             $templates->set_var('xhtml', XHTML);
    1568. 

  1568.             $templates->set_var('site_url', $_CONF['site_url']);
    1569. 

  1569.             $templates->set_var('site_admin_url', $_CONF['site_admin_url']);
    1570. 

  1570.             $templates->set_var('layout_url', $_CONF['layout_url']);
    1571. 

  1571.             
    1572. 

  1572.             $templates->set_var ('lang_nohit', $LANG_DATABOX['nohit']);
    1573. 

  1573. 

  1574.             $templates->parse ('output', 'list');
    1575. 

  1575.             $content = $templates->finish ($templates->get_var ('output'));
    1576. 

  1576.             $retval .=$content;
    1577. 

  1577. 

  1578.         }
    1579. 

  1579.     }
    1580. 

  1580. 

  1581.     $retval =PLG_replacetags ($retval);
    1582. 

  1582. 

  1583.     return $retval;
    1584. 

  1584. }
    1585. 

  1585. function databox_orderby(
    1586. 

  1586.     $datefield
    1587. 

  1587.     ,&$order
    1588. 

  1588.     ,&$orderby
    1589. 

  1589.     ,&$addfieldorder
    1590. 

  1590.     ,&$field_id
    1591. 

  1591. )
    1592. 

  1592. // +---------------------------------------------------------------------------+
    1593. 

  1593. // | 機能  order orderby addfieldorder $field_id を編集
    1594. 

  1594. // | 書式  databox_orderby($order,$orderby,$addfieldorder,$field_id);
    1595. 

  1595. // +---------------------------------------------------------------------------+
    1596. 

  1596. // | 引数 $datefield
    1597. 

  1597. // | 引数戻値 $order
    1598. 

  1598. // | 引数戻値 $orderby
    1599. 

  1599. // | 引数戻値 $addfieldorder
    1600. 

  1600. // | 引数戻値 $field_id
    1601. 

  1601. // +---------------------------------------------------------------------------+
    1602. 

  1602. 

  1603. {
    1604. 

  1604. 

  1605.     global $_TABLES;
    1606. 

  1606. 

  1607.     $orderby="";
    1608. 

  1608.     $addfieldorder=false;
    1609. 

  1609.     switch($order){
    1610. 

  1610.         case "random":
    1611. 

  1611.             $orderby =" RAND()";
    1612. 

  1612.             break;
    1613. 

  1613.         case "":
    1614. 

  1614.         case "date":
    1615. 

  1615.             $order="date";
    1616. 

  1616.             $orderby = $datefield ." DESC";
    1617. 

  1617.             break;
    1618. 

  1618.         case "released":
    1619. 

  1619.             $orderby = " released DESC";
    1620. 

  1620.             break;
    1621. 

  1621.         case "orderno":
    1622. 

  1622.         case "code":
    1623. 

  1623.         case "title":
    1624. 

  1624.         case "description":
    1625. 

  1625.         case "id":
    1626. 

  1626.             $orderby = " t2.".$order;
    1627. 

  1627.             break;
    1628. 

  1628.         default:
    1629. 

  1629.             $sql="SELECT ";
    1630. 

  1630.             $sql.= " field_id ";
    1631. 

  1631.             $sql.= ",name ";
    1632. 

  1632.             $sql.=" FROM";
    1633. 

  1633.             $sql.=" {$_TABLES['DATABOX_def_field']} ";
    1634. 

  1634.             $sql.=" WHERE templatesetvar='".$order."'";
    1635. 

  1635. 

  1636.             $result = DB_query ($sql);
    1637. 

  1637.             $numrows = DB_numRows ($result);
    1638. 

  1638. 

  1639.             if ($numrows>0){
    1640. 

  1640.                 $A = DB_fetchArray ($result);
    1641. 

  1641.                 $field_id=COM_stripslashes($A['field_id']);
    1642. 

  1642.                 $addfield_name=COM_stripslashes($A['name']);
    1643. 

  1643.                 $orderby = " t3.value IS NULL ASC ,cast(t3.value as DECIMAL) ASC ";
    1644. 

  1644.                 $addfieldorder=true;
    1645. 

  1645.             }else{
    1646. 

  1646.                 $order="date";
    1647. 

  1647.                 $orderby = $datefield ." DESC";
    1648. 

  1648.             }
    1649. 

  1649.     }
    1650. 

  1650. 

  1651.     return ;
    1652. 

  1652. 

  1653. }
    1654. 

  1654. 

  1655. 

  1656. 

  1657. // +---------------------------------------------------------------------------+
    1658. 

  1658. // | 機能  集計表示(max min sum)
    1659. 

  1659. // +---------------------------------------------------------------------------+
    1660. 

  1660. // | 書式  databox_grp()
    1661. 

  1661. // | 書式  databox_grp(1)
    1662. 

  1662. // | 書式  databox_grp("japan")
    1663. 

  1663. // +---------------------------------------------------------------------------+
    1664. 

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

  1665. // | 引数 $function:関数　デフォルトmax
    1666. 

  1666. // | 引数 $format:書式
    1667. 

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

  1668. // | 引数 $category_code:カテゴリコード
    1669. 

  1669. // +---------------------------------------------------------------------------+
    1670. 

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

  1671. // +---------------------------------------------------------------------------+
    1672. 

  1672. 

  1673. function databox_grp(
    1674. 

  1674.     $field=null
    1675. 

  1675.     ,$function=null
    1676. 

  1676.     ,$format=null
    1677. 

  1677.     ,$category_id =null
    1678. 

  1678.     ,$category_code =null
    1679. 

  1679. )
    1680. 

  1680. {
    1681. 

  1681.     global $_TABLES;
    1682. 

  1682.     global $LANG_DATABOX;
    1683. 

  1683. 

  1684.     $rt="";
    1685. 

  1685. 

  1686.     if (is_null($field) ){
    1687. 

  1687.         $field="id";
    1688. 

  1688.     }
    1689. 

  1689.     if (is_null($function) ){
    1690. 

  1690.         $function="max";
    1691. 

  1691.     }
    1692. 

  1692. 

  1693.     if (is_null($category_id) AND is_null($category_code) ){
    1694. 

  1694.         $m="ALL";
    1695. 

  1695.     }else{
    1696. 

  1696.         if (is_null($category_id) ){
    1697. 

  1697.             $category_id=DATABOX_codetoid($category_code,'DATABOX_def_category',"category_id");
    1698. 

  1698.         }
    1699. 

  1699.         $m="CATEGORY";
    1700. 

  1700.     }
    1701. 

  1701.     //-----
    1702. 

  1702.     $tbl1=$_TABLES['DATABOX_base'] ;
    1703. 

  1703.     $tbl2=$_TABLES['DATABOX_category'] ;
    1704. 

  1704. 

  1705.     //-----
    1706. 

  1706.     $sql=LB;
    1707. 

  1707.     $sql .= "SELECT ".LB;
    1708. 

  1708. 

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

  1710. 

  1711.     $sql .= " FROM ".LB;
    1712. 

  1712. 

  1713.     $sql .= " {$tbl1} AS t1 ".LB;
    1714. 

  1714. 

  1715.     if ($m==="ALL"){
    1716. 

  1716.     }else{
    1717. 

  1717.         $sql .= " ,{$tbl2} AS t2 ".LB;
    1718. 

  1718.     }
    1719. 

  1719. 

  1720.     $sql .= " WHERE ".LB;
    1721. 

  1721. 

  1722.     //@@@@@@@@@--------->
    1723. 

  1723.     //下書はのぞく
    1724. 

  1724.     $sql .= " t1.draft_flag=0".LB;
    1725. 

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

  1726.     $sql .= COM_getPermSql('AND').LB;
    1727. 

  1727.     //公開日以前のデータはのぞく
    1728. 

  1728.     $sql .= " AND (released <= NOW())".LB;
    1729. 

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

  1730.     $sql .= " AND (expired=0 OR expired > NOW())".LB;
    1731. 

  1731.     //@@@@@@@@@<---------
    1732. 

  1732. 

  1733.     if ($m==="ALL"){
    1734. 

  1734.     }else{
    1735. 

  1735.         $sql .= " AND t1.id = t2.id ".LB;
    1736. 

  1736.         $sql .= " AND t2.category_id= ".$category_id .LB;
    1737. 

  1737.     }
    1738. 

  1738. 

  1739.     $result = DB_query ($sql);
    1740. 

  1740.     $numrows = DB_numRows ($result);
    1741. 

  1741. 

  1742. 

  1743.     if ($numrows > 0) {
    1744. 

  1744. 

  1745.         $A = DB_fetchArray ($result);
    1746. 

  1746. 

  1747.         $rt=$A['rt'];
    1748. 

  1748.         if ($rt<>""){
    1749. 

  1749.             switch($format){
    1750. 

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

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

  1752.                     $fm=$LANG_DATABOX[$format];
    1753. 

  1753.                     $rt=strftime($fm,strtotime($rt));
    1754. 

  1754.                     break;
    1755. 

  1755.                 default:
    1756. 

  1756.                     break;
    1757. 

  1757.             }
    1758. 

  1758.         }
    1759. 

  1759.     }
    1760. 

  1760. 

  1761.     return $rt;
    1762. 

  1762. 

  1763. }
    1764. 

  1764. 

  1765. 

  1766. 

  1767. function databox_data(
    1768. 

  1768.     $id=null
    1769. 

  1769.     ,$template=null
    1770. 

  1770.     ,$nohitmsg=""
    1771. 

  1771.     ,$m=""
    1772. 

  1772.     ,$code=null
    1773. 

  1773. )
    1774. 

  1774. // +---------------------------------------------------------------------------+
    1775. 

  1775. // | 機能  個別データ表示
    1776. 

  1776. // | 書式  databox_data($id,$template,"yes","page")
    1777. 

  1777. // | 書式  databox_data($p['id'],$p['thtml'],$p['nohitmsg'],$p['code']
    1778. 

  1778. // +---------------------------------------------------------------------------+
    1779. 

  1779. // | 引数 $id            :
    1780. 

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

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

  1782. // | 引数 $m             :"page"の時は　レイアウト設定
    1783. 

  1783. // | 引数 $code          :
    1784. 

  1784. // +---------------------------------------------------------------------------+
    1785. 

  1785. // | public_html/data.php および　自動タグで使用
    1786. 

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

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

  1788. // +---------------------------------------------------------------------------+
    1789. 

  1789. // | 戻値 nomal:data
    1790. 

  1790. // +---------------------------------------------------------------------------+
    1791. 

  1791. {
    1792. 

  1792. 

  1793.     $pi_name="databox";
    1794. 

  1794. 

  1795.     global $_CONF;
    1796. 

  1796.     global $_TABLES;
    1797. 

  1797.     global $_DATABOX_CONF;
    1798. 

  1798.     global $LANG_DATABOX;
    1799. 

  1799.     global $LANG_DATABOX_ADMIN;
    1800. 

  1800.     global $_IMAGE_TYPE;
    1801. 

  1801.     global $_USER;
    1802. 

  1802.     global $LANG_ACCESS;
    1803. 

  1803.     global $LANG_confignames;
    1804. 

  1804.     global $_PLUGINS;
    1805. 

  1805.     
    1806. 

  1806.     $layout=$_DATABOX_CONF['layout'];
    1807. 

  1807.     
    1808. 

  1808.     //ログイン要否チェック
    1809. 

  1809.     if (COM_isAnonUser()){
    1810. 

  1810.         if  ($_CONF['loginrequired']
    1811. 

  1811.                 OR ($_DATABOX_CONF['loginrequired'] >0) ){
    1812. 

  1812.             return $LANG_DATABOX['loginrequired'];
    1813. 

  1813.         }
    1814. 

  1814. 

  1815.     }
    1816. 

  1816. 

  1817.     //-----
    1818. 

  1818. 

  1819.     if (is_null($id)  OR ($id==0)){
    1820. 

  1820.         if ($code<>""){
    1821. 

  1821.             if (substr($code,0,4)==="@fb_"){
    1822. 

  1822.                 if (function_exists('assistfb_getNestAutotag')) {
    1823. 

  1823.                     $code=assistfb_getNestAutotag(substr($code,4));
    1824. 

  1824.                 }
    1825. 

  1825.             }    
    1826. 

  1826.         }
    1827. 

  1827.         if ($code<>""){
    1828. 

  1828.             $id=DATABOX_codetoid($code,'DATABOX_base',"id");
    1829. 

  1829.         }
    1830. 

  1830.     }
    1831. 

  1831. 	
    1832. 

  1832.     //-----
    1833. 

  1833.     $display = '';
    1834. 

  1834. 

  1835.     $tbl=$_TABLES['DATABOX_base'] ;
    1836. 

  1836.     $tbl2=$_TABLES['users'] ;
    1837. 

  1837.     $tbl4=$_TABLES['DATABOX_def_fieldset'];
    1838. 

  1838.     $tbl5=$_TABLES['DATABOX_stats'];
    1839. 

  1839.     
    1840. 

  1840.     $addition_def=DATABOX_getadditiondef($pi_name);
    1841. 

  1841. 

  1842.     //-----
    1843. 

  1843.     $sql = "SELECT t.* ";
    1844. 

  1844.     
    1845. 

  1845.     $sql .= " ,UNIX_TIMESTAMP(t.modified) AS modified_un";
    1846. 

  1846.     $sql .= " ,UNIX_TIMESTAMP(t.released) AS released_un";
    1847. 

  1847.     $sql .= " ,UNIX_TIMESTAMP(t.comment_expire) AS comment_expire_un";
    1848. 

  1848.     $sql .= " ,UNIX_TIMESTAMP(t.expired) AS expired_un";
    1849. 

  1849.     $sql .= " ,UNIX_TIMESTAMP(t.created) AS created_un";
    1850. 

  1850.     $sql .= " ,UNIX_TIMESTAMP(t.udatetime) AS udatetime_un";
    1851. 

  1851.     
    1852. 

  1852.     $sql .= " ,t.fieldset_id";
    1853. 

  1853.     
    1854. 

  1854.     $sql .= " ,t2.username AS owner_name";
    1855. 

  1855.     $sql .= " ,t3.username AS last_modify_name";
    1856. 

  1856.     $sql .= " ,t3.fullname AS last_modify_fullname";
    1857. 

  1857.     
    1858. 

  1858.     $sql .= " ,t4.name AS set_name";
    1859. 

  1859.     $sql .= " ,t4.description AS set_description";
    1860. 

  1860.     $sql .= " ,t4.defaulttemplatesdirectory AS set_defaulttemplatesdirectory";
    1861. 

  1861.     $sql .= " ,t4.layout AS set_layout";
    1862. 

  1862.     
    1863. 

  1863.     $sql .= " ,t5.hits";
    1864. 

  1864.     
    1865. 

  1865.     $sql .= " FROM ";
    1866. 

  1866.     $sql .= " {$tbl} AS t ";//base
    1867. 

  1867.     $sql .= " JOIN {$tbl4} AS t4       ON t.fieldset_id=t4.fieldset_id";
    1868. 

  1868.     $sql .= " JOIN {$tbl2} AS t2       ON t.owner_id=t2.uid";//owner
    1869. 

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

  1870.     $sql .= " LEFT JOIN  {$tbl2} AS t3 ON t.uuid=t3.uid";//last_updateowner
    1871. 

  1871. 

  1872.     $sql .= " WHERE ";
    1873. 

  1873.     if (is_null($id)){//@@@@@
    1874. 

  1874.         $sql .= "1=1";
    1875. 

  1875.     }else{
    1876. 

  1876.         $sql .= " t.id=".$id;
    1877. 

  1877.     }
    1878. 

  1878. 

  1879. 

  1880.     //管理者の時
    1881. 

  1881.     if ( SEC_hasRights('databox.admin') OR $m==="view") {
    1882. 

  1882.     }else{
    1883. 

  1883.         //下書データはのぞく
    1884. 

  1884.         $sql .= " AND t.draft_flag=0".LB;
    1885. 

  1885.         //公開日以前のデータはのぞく
    1886. 

  1886.         $sql .= " AND (released <= NOW())";
    1887. 

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

  1888.         $sql .= " AND (expired=0 OR expired > NOW())";
    1889. 

  1889.     }
    1890. 

  1890.     
    1891. 

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

  1892.     $sql .= COM_getPermSql('AND');
    1893. 

  1893.     
    1894. 

  1894. 

  1895.     if (is_null($id)){
    1896. 

  1896.         $sql .= " ORDER BY ".$_DATABOX_CONF['datefield'] . " DESC ";
    1897. 

  1897.         $sql .= " LIMIT 0 , 1";
    1898. 

  1898.     }
    1899. 

  1899.     
    1900. 

  1900.     
    1901. 

  1901.     $result = DB_query ($sql);
    1902. 

  1902.     $numrows = DB_numRows ($result);
    1903. 

  1903.     
    1904. 

  1904.     if  ($m==="page"  OR  $m==="view"){
    1905. 

  1905.         if ($numrows <= 0) {
    1906. 

  1906.             COM_handle404();
    1907. 

  1907.             exit;
    1908. 

  1908.         }
    1909. 

  1909.     }
    1910. 

  1910. 

  1911.     if ($numrows > 0) {
    1912. 

  1912.         $A = DB_fetchArray ($result);
    1913. 

  1913.         $A = array_map('stripslashes', $A);
    1914. 

  1914. 

  1915.         $cache_time=$A['cache_time'];
    1916. 

  1916.         $cache=false;
    1917. 

  1917.         if  ($cache_time===0){
    1918. 

  1918.         }else{
    1919. 

  1919.             if  ($m==="page"){
    1920. 

  1920.                 $cacheInstance = 'databox__' . $id .'__' . CACHE_security_hash();
    1921. 

  1921.                 $rt = CACHE_check_instance($cacheInstance."_title");
    1922. 

  1922.                 if ($rt  AND $cache_time == -1) {
    1923. 

  1923.                     $cache=true;
    1924. 

  1924.                 } elseif ($cache AND $cache_time > 0) {        
    1925. 

  1925.                     $lu = CACHE_get_instance_update($cacheInstance."_title");
    1926. 

  1926.                     $now = time();
    1927. 

  1927.                     if (($now - $lu) < $cache_time ){
    1928. 

  1928.                          $cache=true;
    1929. 

  1929.                     }
    1930. 

  1930.                 }
    1931. 

  1931.             }
    1932. 

  1932.         }
    1933. 

  1933.         
    1934. 

  1934.         
    1935. 

  1935.         if  ($cache){
    1936. 

  1936.             $display = CACHE_check_instance($cacheInstance."_display",$display);
    1937. 

  1937.             $layout = CACHE_check_instance($cacheInstance."_layout",$layout);
    1938. 

  1938.             $headercode = CACHE_check_instance($cacheInstance."_headercode",$headercode);
    1939. 

  1939.             $title = CACHE_check_instance($cacheInstance."_title",$title);
    1940. 

  1940.         }else{
    1941. 

  1941.             if (is_null($template) or ($template==="")){
    1942. 

  1942.                 if ($A['defaulttemplatesdirectory']<>""){
    1943. 

  1943.                     $template=$A['defaulttemplatesdirectory'];
    1944. 

  1944.                 }elseif  ($A['set_defaulttemplatesdirectory']<>""){
    1945. 

  1945.                     $template=$A['set_defaulttemplatesdirectory'];
    1946. 

  1946.                 }else{
    1947. 

  1947.                     $template="default";
    1948. 

  1948.                 }
    1949. 

  1949.             }
    1950. 

  1950. 

  1951.             $code=$A['code'];
    1952. 

  1952.             $group_id = $A['group_id'];
    1953. 

  1953.             $owner_id = $A['owner_id'];
    1954. 

  1954.         
    1955. 

  1955.             $fieldset_id= $A['fieldset_id'];
    1956. 

  1956.             //
    1957. 

  1957.             if ($m==="view"){    
    1958. 

  1958.                 $chk_user=1000;//ログインユーザ
    1959. 

  1959.             }else{
    1960. 

  1960.                 $chk_user=DATABOX_chkuser($group_id,$owner_id,"databox.admin");
    1961. 

  1961.             }
    1962. 

  1962. 

  1963.             $id=$A['id'];
    1964. 

  1964.             $additionfields = DATABOX_getadditiondatas($id,$pi_name);
    1965. 

  1965. 

  1966.             //ヘッダ、左ブロック start.............
    1967. 

  1967.             if ($m==="page"){
    1968. 

  1968.                 if  ($A['set_layout']<>"0") {
    1969. 

  1969.                     $layout=$A['set_layout'];
    1970. 

  1970.                 }
    1971. 

  1971.                 // Meta Tags
    1972. 

  1972.                 $headercode=DATABOX_getheadercode(    
    1973. 

  1973.                     "data"
    1974. 

  1974.                     ,$template
    1975. 

  1975.                     ,$pi_name
    1976. 

  1976.                     ,$A['id']
    1977. 

  1977.                     ,$A['title']
    1978. 

  1978.                     ,$A['meta_description']
    1979. 

  1979.                     ,$A['meta_keywords']
    1980. 

  1980.                     ,$A['description']
    1981. 

  1981.                     ,$additionfields 
    1982. 

  1982.                     ,$addition_def 
    1983. 

  1983.                     ,$chk_user 
    1984. 

  1984.                     ,$fieldset_id 
    1985. 

  1985.                     );
    1986. 

  1986.             
    1987. 

  1987.                 if  ($A['page_title']<>""){
    1988. 

  1988.                     $title = $A['page_title'] ;
    1989. 

  1989.                 }else{    
    1990. 

  1990.                     $title = $A['title'] ;
    1991. 

  1991.                 }
    1992. 

  1992.             }
    1993. 

  1993. 

  1994. 

  1995.             $tmplfld=DATABOX_templatePath('data',$template,$pi_name);
    1996. 

  1996.             $templates = new Template($tmplfld);
    1997. 

  1997.             $templates->set_file (array (
    1998. 

  1998.                     'list' => 'list_detail.thtml',
    1999. 

  1999.                     'row'   => 'row.thtml',
    2000. 

  2000.                     'col'   => "col_detail.thtml",
    2001. 

  2001.                     ));
    2002. 

  2002.         
    2003. 

  2003.             $languageid=COM_getLanguageId();
    2004. 

  2004.             $language= COM_getLanguage();
    2005. 

  2005.             $templates->set_var ('languageid', $languageid);
    2006. 

  2006.             $templates->set_var ('language', $language);
    2007. 

  2007.             if ($languageid<>"") {
    2008. 

  2008.                 $templates->set_var ('_languageid', "_".$languageid);
    2009. 

  2009.             }else{
    2010. 

  2010.                 $templates->set_var ('_languageid', "");
    2011. 

  2011.             }
    2012. 

  2012.         
    2013. 

  2013.             $templates->set_var ('site_admin_url', $_CONF['site_admin_url']);
    2014. 

  2014.             $templates->set_var ('site_url',$_CONF['site_url']);
    2015. 

  2015.             //
    2016. 

  2016.             $templates->set_var('xhtml', XHTML);
    2017. 

  2017.             $templates->set_var('layout_url', $_CONF['layout_url']);
    2018. 

  2018.         
    2019. 

  2019.             $templates->set_var ('site_name', $_CONF['site_name']);
    2020. 

  2020.             $templates->set_var ('site_mail', $_CONF['site_mail']);
    2021. 

  2021.         
    2022. 

  2022.             $currenturl= COM_getCurrentURL();
    2023. 

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

  2024.             //facebook
    2025. 

  2025.             $facebook_consumer_key = trim($_CONF['facebook_consumer_key']);
    2026. 

  2026.             $templates->set_var ('facebook_consumer_key', $facebook_consumer_key);
    2027. 

  2027.             //
    2028. 

  2028.         
    2029. 

  2029.             //daft_flag管理者の時
    2030. 

  2030.             if ($A['draft_flag']==1){
    2031. 

  2031.                 $templates->set_var ('draft', "draft!");
    2032. 

  2032.             }else{
    2033. 

  2033.                 $templates->set_var ('draft', "");
    2034. 

  2034.             }
    2035. 

  2035.             //------------
    2036. 

  2036. 

  2037.             //id
    2038. 

  2038.             $templates->set_var('lang_id', $LANG_DATABOX_ADMIN['id']);
    2039. 

  2039.             $templates->set_var ('id', $A['id']);
    2040. 

  2040. 

  2041.             $templates->set_var('lang_fields', $LANG_DATABOX_ADMIN['fields']);
    2042. 

  2042.             $templates->set_var('lang_field', $LANG_DATABOX_ADMIN['field']);
    2043. 

  2043.             $templates->set_var('lang_templatesetvar', $LANG_DATABOX_ADMIN['templatesetvar']);
    2044. 

  2044.             $templates->set_var('lang_content', $LANG_DATABOX_ADMIN['content']);
    2045. 

  2045.             $templates->set_var('lang_type', $LANG_DATABOX_ADMIN['type']);
    2046. 

  2046.             $templates->set_var('lang_byusingid', $LANG_DATABOX_ADMIN['byusingid']);
    2047. 

  2047.             $templates->set_var('lang_byusingcode', $LANG_DATABOX_ADMIN['byusingcode']);
    2048. 

  2048.             $templates->set_var('lang_byusingtemplatesetvar', $LANG_DATABOX_ADMIN['byusingtemplatesetvar']);
    2049. 

  2049.             $templates->set_var('lang_group', $LANG_DATABOX_ADMIN['group']);
    2050. 

  2050.             $templates->set_var('lang_withlink', $LANG_DATABOX_ADMIN['withlink']);
    2051. 

  2051.             $templates->set_var('lang_groupbygroup', $LANG_DATABOX_ADMIN['groupbygroup']);
    2052. 

  2052.         
    2053. 

  2053.             //$_DATABOX_CONF
    2054. 

  2054.             $templates->set_var('lang_imgfile_frd', $LANG_confignames['databox']['imgfile_frd']);
    2055. 

  2055.             $templates->set_var ('imgfile_frd', $_DATABOX_CONF['imgfile_frd']);
    2056. 

  2056.             $templates->set_var ('data_img_url', $_CONF['site_url']."/".$_DATABOX_CONF['imgfile_frd']);
    2057. 

  2057.             $templates->set_var('lang_imgfile_thumb_frd', $LANG_confignames['databox']['imgfile_thumb_frd']);
    2058. 

  2058.             $templates->set_var ('imgfile_thumb_frd', $_DATABOX_CONF['imgfile_thumb_frd']);
    2059. 

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

  2060.         
    2061. 

  2061.             //基本項目
    2062. 

  2062.             $templates->set_var('lang_basicfields', $LANG_DATABOX_ADMIN['basicfields']);
    2063. 

  2063.             //コード＆タイトル＆説明
    2064. 

  2064.             $templates->set_var('lang_code', $LANG_DATABOX_ADMIN['code']);
    2065. 

  2065.             $templates->set_var ('code', $A['code']);
    2066. 

  2066.             $templates->set_var('lang_title', $LANG_DATABOX_ADMIN['title']);
    2067. 

  2067.             $templates->set_var ('title',$A['title']);
    2068. 

  2068.             $templates->set_var('lang_description', $LANG_DATABOX_ADMIN['description']);
    2069. 

  2069.             $templates->set_var ('description',$A['description']);
    2070. 

  2070. 

  2071.             //@@@@@
    2072. 

  2072.             $templates->set_var('lang_owner', $LANG_ACCESS['owner']);
    2073. 

  2073.             $templates->set_var ('owner_name',$A['owner_name']);
    2074. 

  2074.             $templates->set_var ('owner_id',$A['owner_id']);
    2075. 

  2075. 

  2076.             //hits
    2077. 

  2077.             $templates->set_var('lang_hits', $LANG_DATABOX_ADMIN['hits']);
    2078. 

  2078.             $templates->set_var ('hits', $A['hits']);
    2079. 

  2079.             //カテゴリ@@@@@
    2080. 

  2080.             $templates->set_var('lang_category', $LANG_DATABOX_ADMIN['category']);
    2081. 

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

  2082. 

  2083.             //追加項目
    2084. 

  2084.             $templates->set_var('lang_additionfields', $LANG_DATABOX_ADMIN['additionfields']);
    2085. 

  2085.             DATABOX_getaddtionfieldsDisp($additionfields,$addition_def,$templates,$chk_user,$pi_name,$fieldset_id);
    2086. 

  2086. 

  2087.             //編集日付
    2088. 

  2088.             $templates->set_var('lang_modified', $LANG_DATABOX_ADMIN['modified']);
    2089. 

  2089.             $wary = COM_getUserDateTimeFormat($A['modified_un']);
    2090. 

  2090.             $templates->set_var ('modified',$wary[0]);
    2091. 

  2091.             $templates->set_var ('modified_shortdate', strftime( $_CONF['shortdate'], $A['modified_un'] ));
    2092. 

  2092.             $templates->set_var ('modified_date', strftime( $_CONF['date'], $A['modified_un'] ));
    2093. 

  2093.             $templates->set_var ('modified_daytime', strftime( $_CONF['daytime'], $A['modified_un'] ));
    2094. 

  2094.             $templates->set_var ('modified_dateonly', strftime( $_CONF['dateonly'], $A['modified_un'] ));
    2095. 

  2095.             $templates->set_var ('modified_timeonly', strftime( $_CONF['timeonly'], $A['modified_un'] ));
    2096. 

  2096.             $templates->set_var ('modified_b', strftime( "%b" , $A['modified_un']));
    2097. 

  2097.             $templates->set_var ('modified_B', strftime( "%B" , $A['modified_un']));
    2098. 

  2098.             $templates->set_var ('modified_d', strftime( "%d" , $A['modified_un']));
    2099. 

  2099.             $templates->set_var ('modified_e', strftime( "%e" , $A['modified_un']));
    2100. 

  2100.             //作成日付
    2101. 

  2101.             $templates->set_var('lang_created', $LANG_DATABOX_ADMIN['created']);
    2102. 

  2102.             $wary = COM_getUserDateTimeFormat($A['created_un']);
    2103. 

  2103.             $templates->set_var ('created', $wary[0]);
    2104. 

  2104.             $templates->set_var ('created_shortdate', strftime( $_CONF['shortdate'], $A['created_un'] ));
    2105. 

  2105.             $templates->set_var ('created_date', strftime( $_CONF['date'], $A['created_un'] ));
    2106. 

  2106.             $templates->set_var ('created_daytime', strftime( $_CONF['daytime'], $A['created_un'] ));
    2107. 

  2107.             $templates->set_var ('created_dateonly', strftime( $_CONF['dateonly'], $A['created_un'] ));
    2108. 

  2108.             $templates->set_var ('created_timeonly', strftime( $_CONF['timeonly'], $A['created_un'] ));
    2109. 

  2109.             $templates->set_var ('created_b', strftime( "%b" , $A['created_un']));
    2110. 

  2110.             $templates->set_var ('created_B', strftime( "%B" , $A['created_un']));
    2111. 

  2111.             $templates->set_var ('created_d', strftime( "%d" , $A['created_un']));
    2112. 

  2112.             $templates->set_var ('created_e', strftime( "%e" , $A['created_un']));
    2113. 

  2113.             //公開日
    2114. 

  2114.             $templates->set_var('lang_released', $LANG_DATABOX_ADMIN['released']);
    2115. 

  2115.             $wary = COM_getUserDateTimeFormat($A['released_un']);
    2116. 

  2116.             $templates->set_var ('released', $wary[0]);
    2117. 

  2117.             $templates->set_var ('released_shortdate', strftime( $_CONF['shortdate'], $A['released_un'] ));
    2118. 

  2118.             $templates->set_var ('released_date', strftime( $_CONF['date'], $A['released_un'] ));
    2119. 

  2119.             $templates->set_var ('released_daytime', strftime( $_CONF['daytime'], $A['released_un'] ));
    2120. 

  2120.             $templates->set_var ('released_dateonly', strftime( $_CONF['dateonly'], $A['released_un'] ));
    2121. 

  2121.             $templates->set_var ('released_timeonly', strftime( $_CONF['timeonly'], $A['released_un'] ));
    2122. 

  2122.             $templates->set_var ('released_b', strftime( "%b" , $A['released_un']));
    2123. 

  2123.             $templates->set_var ('released_B', strftime( "%B" , $A['released_un']));
    2124. 

  2124.             $templates->set_var ('released_d', strftime( "%d" , $A['released_un']));
    2125. 

  2125.             $templates->set_var ('released_e', strftime( "%e" , $A['released_un']));
    2126. 

  2126.             //公開終了日
    2127. 

  2127.             $templates->set_var('lang_expired', $LANG_DATABOX_ADMIN['expired']);
    2128. 

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

  2129.                 $templates->set_var ('expired', "");
    2130. 

  2130.                 $templates->set_var ('expired_shortdate', "" );
    2131. 

  2131.                 $templates->set_var ('expired_date', "" );
    2132. 

  2132.                 $templates->set_var ('expired_daytime', "" );
    2133. 

  2133.                 $templates->set_var ('expired_dateonly', "" );
    2134. 

  2134.                 $templates->set_var ('expired_timeonly', "" );
    2135. 

  2135.                 $templates->set_var ('expired_b', "" );
    2136. 

  2136.                 $templates->set_var ('expired_B', "" );
    2137. 

  2137.                 $templates->set_var ('expired_d', "" );
    2138. 

  2138.                 $templates->set_var ('expired_e', "" );
    2139. 

  2139.             }else{
    2140. 

  2140.                 $wary = COM_getUserDateTimeFormat($A['expired_un']);
    2141. 

  2141.                 $templates->set_var ('expired', $wary[0]);
    2142. 

  2142.                 $templates->set_var ('expired_shortdate', strftime( $_CONF['shortdate'], $A['expired_un'] ));
    2143. 

  2143.                 $templates->set_var ('expired_date', strftime( $_CONF['date'], $A['expired_un'] ));
    2144. 

  2144.                 $templates->set_var ('expired_daytime', strftime( $_CONF['daytime'], $A['expired_un'] ));
    2145. 

  2145.                 $templates->set_var ('expired_dateonly', strftime( $_CONF['dateonly'], $A['expired_un'] ));
    2146. 

  2146.                 $templates->set_var ('expired_timeonly', strftime( $_CONF['timeonly'], $A['expired_un'] ));
    2147. 

  2147.                 $templates->set_var ('expired_b', strftime( "%b" , $A['expired_un']));
    2148. 

  2148.                 $templates->set_var ('expired_B', strftime( "%B" , $A['expired_un']));
    2149. 

  2149.                 $templates->set_var ('expired_d', strftime( "%d" , $A['expired_un']));
    2150. 

  2150.                 $templates->set_var ('expired_e', strftime( "%e" , $A['expired_un']));
    2151. 

  2151.              }
    2152. 

  2152.         
    2153. 

  2153.             $templates->set_var ('lang_uuid', $LANG_DATABOX_ADMIN['uuid']);
    2154. 

  2154.             $templates->set_var ('uuid', $uuid);
    2155. 

  2155.         
    2156. 

  2156.             $templates->set_var ('lang_udatetime', $LANG_DATABOX_ADMIN['udatetime']);
    2157. 

  2157.             $wary = COM_getUserDateTimeFormat($A['udatetime_un']);
    2158. 

  2158.             $templates->set_var ('udatetime', $wary[0]);
    2159. 

  2159.             $templates->set_var ('last_modify_uid', $A['uuid']);
    2160. 

  2160.         
    2161. 

  2161.             $templates->set_var ('last_modify_name', $A['last_modify_name']);
    2162. 

  2162.             $templates->set_var ('last_modify_fullname', $A['last_modify_fullname']);
    2163. 

  2163.         
    2164. 

  2164.             //maps plugin link
    2165. 

  2165.             $mkid="";
    2166. 

  2166.             $marker="";
    2167. 

  2167.             if (in_array("maps", $_PLUGINS)){
    2168. 

  2168.                 $mkid=DB_getItem($_TABLES['maps_markers'],"mkid","item_10='$code'");
    2169. 

  2169.                 if (! empty($mkid)) {
    2170. 

  2170.                     $sql = "SELECT * FROM {$_TABLES['maps_markers']} WHERE mkid = {$mkid} LIMIT 1";
    2171. 

  2171.                     $res = DB_query($sql, 0);
    2172. 

  2172.                     $AM = DB_fetchArray($res);
    2173. 

  2173.                     if (!SEC_hasAccess2($AM)) {
    2174. 

  2174.                     } else {
    2175. 

  2175.                          $marker = MAPS_getMarkerDetail($AM['mid'], $mkid);
    2176. 

  2176.                     }
    2177. 

  2177.                 }
    2178. 

  2178.             }
    2179. 

  2179.             $templates->set_var ('mkid', $mkid);
    2180. 

  2180.             $templates->set_var ('marker', $marker);
    2181. 

  2181.         
    2182. 

  2182.             //管理者の時「編集」
    2183. 

  2183.             if ($m<>"view"){
    2184. 

  2184.                 if ( SEC_hasRights('databox.admin')) {
    2185. 

  2185.                     $icon_url = $_CONF['layout_url'] . '/images/edit.' . $_IMAGE_TYPE;
    2186. 

  2186.                     $attr = array('title' => $A['title']." ".$LANG_DATABOX_ADMIN['edit']);
    2187. 

  2187.                     $editiconhtml = COM_createImage($icon_url, $LANG_DATABOX_ADMIN['edit'], $attr);
    2188. 

  2188.                 
    2189. 

  2189.                     $attr = array('class' => 'editlink', 'title' => $A['title']." ".$LANG_DATABOX_ADMIN['edit']);
    2190. 

  2190.                     $url = $_CONF['site_admin_url'];
    2191. 

  2191.                     $url .= '/plugins/databox/data.php';
    2192. 

  2192.                     $url .= '?mode=edit';
    2193. 

  2193.                     $url .= '&amp;'."id={$id}";
    2194. 

  2194.                     $icon = '&nbsp;' ;
    2195. 

  2195.                     $icon .=  COM_createLink( $editiconhtml,  $url,   $attr   );
    2196. 

  2196.                     $templates->set_var ('edit', $icon);
    2197. 

  2197.                 }else{
    2198. 

  2198.                     $rt=databox_chk_loaddata($id);
    2199. 

  2199.                     //編集権限のあるMyData
    2200. 

  2200.                     if ( $rt==="OK") {
    2201. 

  2201.                         $icon_url = $_CONF['layout_url'] . '/images/edit.' . $_IMAGE_TYPE;
    2202. 

  2202.                         $attr = array('title' => $LANG_DATABOX_ADMIN['edit']);
    2203. 

  2203.                         $editiconhtml = COM_createImage($icon_url, $LANG_DATABOX_ADMIN['edit'], $attr);
    2204. 

  2204. 

  2205.                         $attr = array('class' => 'editlink', 'title' => $A['title']." ".$LANG_DATABOX_ADMIN['edit']);
    2206. 

  2206. 

  2207.                         $url = $_CONF['site_url'];
    2208. 

  2208.                         $url .= '/databox/mydata/data.php';
    2209. 

  2209.                         $url .= '?mode=edit';
    2210. 

  2210.                         $url .= '&amp;'."id={$id}";
    2211. 

  2211. 

  2212.                         $icon = '&nbsp;' ;
    2213. 

  2213.                         $icon .=  COM_createLink( $editiconhtml,  $url,   $attr   );
    2214. 

  2214. 

  2215.                         $templates->set_var ('edit', $icon);
    2216. 

  2216.                     }else{
    2217. 

  2217.                         $templates->set_var ('edit', "");
    2218. 

  2218.                     }
    2219. 

  2219.                 }
    2220. 

  2220.             } 
    2221. 

  2221.             // Call to plugins to set template variables in the databox
    2222. 

  2222.             PLG_templateSetVars( 'databox', $templates );
    2223. 

  2223. 

  2224.             if (function_exists('databox_custom_templateSetVars')) {
    2225. 

  2225.                 databox_custom_templateSetVars("data", $templates);
    2226. 

  2226.             }
    2227. 

  2227.         
    2228. 

  2228.             //------------
    2229. 

  2229.             $templates->parse ('output', 'list');
    2230. 

  2230. 

  2231.             $databox_content = $templates->finish ($templates->get_var ('output'));
    2232. 

  2232.             $display=$databox_content;
    2233. 

  2233. 

  2234.             if ($A['draft_flag']!==1){
    2235. 

  2235.                 if (!SEC_hasRights('databox.admin')) {
    2236. 

  2236.                     $id=$A['id'];
    2237. 

  2237.                     $hits=DB_getItem($_TABLES['DATABOX_stats'],"hits","id={$id}");
    2238. 

  2238.                     if (empty($hits)) {
    2239. 

  2239.                         $hits=0;
    2240. 

  2240.                     }
    2241. 

  2241.                     $fields.="id,hits ";
    2242. 

  2242.                     $values.="$id,$hits + 1";
    2243. 

  2243.                     DB_save($_TABLES['DATABOX_stats'],$fields,$values);
    2244. 

  2244.                 }
    2245. 

  2245.             }
    2246. 

  2246.         } 
    2247. 

  2247.     }else{
    2248. 

  2248.         $cache_time=0;
    2249. 

  2249.         if ($nohitmsg==="yes"){
    2250. 

  2250.             $tmplfld=DATABOX_templatePath('data',$template,$pi_name);
    2251. 

  2251.             $templates = new Template($tmplfld);
    2252. 

  2252.             $templates->set_file (array (
    2253. 

  2253.                 'list' => 'nohit.thtml',
    2254. 

  2254.             ));
    2255. 

  2255.             $templates->set_var ('lang_nohit', $LANG_DATABOX['nohit']);
    2256. 

  2256.             $templates->set_var('xhtml', XHTML);
    2257. 

  2257.             $templates->set_var('site_url', $_CONF['site_url']);
    2258. 

  2258.             $templates->set_var('site_admin_url', $_CONF['site_admin_url']);
    2259. 

  2259.             $templates->set_var('layout_url', $_CONF['layout_url']);
    2260. 

  2260. 

  2261.             $templates->parse ('output', 'list');
    2262. 

  2262.             $databox_content = $templates->finish ($templates->get_var ('output'));
    2263. 

  2263.             $display=$databox_content;
    2264. 

  2264.         }
    2265. 

  2265.     }
    2266. 

  2266.     $display =PLG_replacetags ($display);
    2267. 

  2267.     
    2268. 

  2268.     if  (($cache_time > 0 OR $cache_time == -1)  AND  $m==="page" ){
    2269. 

  2269.         CACHE_create_instance($cacheInstance."_display", $display); 
    2270. 

  2270.         CACHE_create_instance($cacheInstance."_layout", $layout); 
    2271. 

  2271.         CACHE_create_instance($cacheInstance."_headercode", $headercode); 
    2272. 

  2272.         CACHE_create_instance($cacheInstance."_title", $title); 
    2273. 

  2273.     }
    2274. 

  2274.     
    2275. 

  2275.     $retval['display']=$display;
    2276. 

  2276.     $retval['layout']=$layout;
    2277. 

  2277.     $retval['headercode']=$headercode;
    2278. 

  2278.     $retval['title']=$title;
    2279. 

  2279.     
    2280. 

  2280.     return $retval;
    2281. 

  2281. }
    2282. 

  2282. 

  2283. //
    2284. 

  2284. function databox_chk_loaddata(
    2285. 

  2285.     $id
    2286. 

  2286. ){
    2287. 

  2287.     $pi_name="databox";
    2288. 

  2288. 

  2289.     global $_TABLES;
    2290. 

  2290.     global $LANG_DATABOX_ADMIN;
    2291. 

  2291. 

  2292. 

  2293.     $rt="";
    2294. 

  2294. 

  2295.     $sql = "SELECT ";
    2296. 

  2296.     $sql .= " id";
    2297. 

  2297. 

  2298.     $sql .= " ,owner_id";
    2299. 

  2299.     $sql .= " ,group_id";
    2300. 

  2300.     $sql .= " ,perm_owner";
    2301. 

  2301.     $sql .= " ,perm_group";
    2302. 

  2302.     $sql .= " ,perm_members";
    2303. 

  2303.     $sql .= " ,perm_anon";
    2304. 

  2304. 

  2305.     $sql .= " FROM ";
    2306. 

  2306.     $sql .= " {$_TABLES['DATABOX_base']} AS t";
    2307. 

  2307.     $sql .= " WHERE ";
    2308. 

  2308. 

  2309.     $sql .= " id=".$id;
    2310. 

  2310. 

  2311.     $result = DB_query ($sql);
    2312. 

  2312.     $numrows = DB_numRows ($result);
    2313. 

  2313. 

  2314.     if ($numrows>0){
    2315. 

  2315. 

  2316.         $A = DB_fetchArray($result);
    2317. 

  2317. 

  2318.         if (!isset($A['owner_id'])) {
    2319. 

  2319.              $A['owner_id'] = 1;
    2320. 

  2320.         }
    2321. 

  2321. 

  2322. 

  2323.         $access = SEC_hasAccess(
    2324. 

  2324.                             $A['owner_id']
    2325. 

  2325.                             , $A['group_id']
    2326. 

  2326.                             , $A['perm_owner']
    2327. 

  2327.                             , $A['perm_group']
    2328. 

  2328.                             , $A['perm_members']
    2329. 

  2329.                             , $A['perm_anon']);
    2330. 

  2330.         if ($access >2) {
    2331. 

  2331.             $rt="OK";
    2332. 

  2332.         }else{
    2333. 

  2333.             $rt=$LANG_DATABOX_ADMIN['err_permission_denied'];
    2334. 

  2334.         }
    2335. 

  2335.     }else{
    2336. 

  2336.         $rt=$LANG_DATABOX_ADMIN['err_invalid'];
    2337. 

  2337.     }
    2338. 

  2338. 

  2339. 

  2340.     return $rt;
    2341. 

  2341. }    
    2342. 

  2342. //$rt=databox_createdatabycode("aaa");
    2343. 

  2343. function databox_createdatabycode(
    2344. 

  2344.     $code
    2345. 

  2345.     ,$title=""
    2346. 

  2346. ){
    2347. 

  2347.     $pi_name="databox";
    2348. 

  2348. 

  2349.     global $_TABLES;
    2350. 

  2350.     global $LANG_DATABOX_ADMIN;
    2351. 

  2351.     global $_DATABOX_CONF;
    2352. 

  2352.     global $_USER;
    2353. 

  2353.     
    2354. 

  2354.     $rt=array();
    2355. 

  2355.     $rt['st']="";
    2356. 

  2356.     $rt['id']=0;
    2357. 

  2357.     
    2358. 

  2358.     $id=DB_getItem($_TABLES['DATABOX_base'],"id","code='{$code}'");
    2359. 

  2359.     if ($id<>""){
    2360. 

  2360.         $rt['st']="ok";
    2361. 

  2361.         $rt['id']=$id;
    2362. 

  2362.         return $rt;
    2363. 

  2363.     };
    2364. 

  2364. 

  2365.     if ($_DATABOX_CONF['allow_data_insert'] 
    2366. 

  2366.             OR SEC_hasRights('databox.submit')){
    2367. 

  2367.     }else{
    2368. 

  2368.          $rt['st']=$LANG_DATABOX_ADMIN['err_permission_denied'];
    2369. 

  2369.          return $rt;
    2370. 

  2370.     }
    2371. 

  2371. 

  2372.     $uuid=$_USER['uid'];    
    2373. 

  2373.     if ($uuid===""){
    2374. 

  2374.         $uuid=0;
    2375. 

  2375.     }
    2376. 

  2376.     $uid=$_USER['uid'];
    2377. 

  2377. 

  2378. 

  2379.     $w=DB_getItem($_TABLES['DATABOX_base'],"max(id)","1=1");
    2380. 

  2380.     if ($w=="") {
    2381. 

  2381.         $w=0;
    2382. 

  2382.     }
    2383. 

  2383.     $id=$w+1;
    2384. 

  2384.     if  ($title==""){
    2385. 

  2385.         $title=$code;
    2386. 

  2386.     }
    2387. 

  2387.     $group_id =$_DATABOX_CONF['grp_id_default'];//@@@@@20110613
    2388. 

  2388. 

  2389.     $array = array();
    2390. 

  2390.     SEC_setDefaultPermissions($array, $_DATABOX_CONF['default_perm']);
    2391. 

  2391.     $perm_owner = $array['perm_owner'];
    2392. 

  2392.     $perm_group = $array['perm_group'];
    2393. 

  2393.     $perm_anon = $array['perm_anon'];
    2394. 

  2394.     $perm_members = $array['perm_members'];
    2395. 

  2395. 

  2396.     $sql=LB;
    2397. 

  2397.     $sql.="INSERT INTO {$_TABLES['DATABOX_base']} (".LB;
    2398. 

  2398.     $sql.=" `id`,`owner_id`,`modified`,`created`,`released`".LB;
    2399. 

  2399.     $sql.=" ,`uuid`".LB;
    2400. 

  2400.     $sql.=" ,`group_id`,`perm_owner`,`perm_group`,`perm_anon`,`perm_members`".LB;
    2401. 

  2401.     $sql.=" ,`code`,`title`".LB;
    2402. 

  2402.     $sql.=")".LB;
    2403. 

  2403. 

  2404.     $sql .= " VALUES (".LB;
    2405. 

  2405.     $sql .= "'{$id}','{$uid}',NOW( ),NOW( ),NOW( )".LB;
    2406. 

  2406.     $sql.=" ,".$uuid .LB;
    2407. 

  2407.     $sql.=" ,".$group_id.LB ;
    2408. 

  2408.     $sql.=" ,".$perm_owner.LB ;
    2409. 

  2409.     $sql.=" ,".$perm_group.LB ;
    2410. 

  2410.     $sql.=" ,".$perm_anon.LB ;
    2411. 

  2411.     $sql.=" ,".$perm_members.LB ;
    2412. 

  2412.     $sql.=" ,'{$code}','{$title}'".LB ;
    2413. 

  2413.     
    2414. 

  2414.     $sql .= ")";
    2415. 

  2415.     DB_query ($sql);
    2416. 

  2416. 

  2417.     //カテゴリ
    2418. 

  2418.     //追加項目
    2419. 

  2419.     $sql = "SELECT ";
    2420. 

  2420.     $sql .= " field_id";
    2421. 

  2421.     $sql .= " ,type";
    2422. 

  2422.     $sql .= " ,selection";
    2423. 

  2423. 

  2424.     $sql .= " FROM ";
    2425. 

  2425.     $sql .= $_TABLES['DATABOX_def_field'];
    2426. 

  2426.     $sql .= " order by field_id ";
    2427. 

  2427. 

  2428.     $result = DB_query ($sql);
    2429. 

  2429.     $numrows = DB_numRows ($result);
    2430. 

  2430.     if ($numrows > 0) {
    2431. 

  2431.         for ($i = 0; $i < $numrows; $i++) {
    2432. 

  2432.             $A = DB_fetchArray ($result);
    2433. 

  2433. 

  2434.             $field_id=$A['field_id'];
    2435. 

  2435.             $type=$A['type'];
    2436. 

  2436.             $selection=$A['selection'];
    2437. 

  2437. 

  2438.             $sql2="INSERT INTO ".$_TABLES['DATABOX_addition'].LB;
    2439. 

  2439.             $sql2.=" (`id`,`field_id`,`value`)".LB;
    2440. 

  2440.             $sql2.=" VALUES (";
    2441. 

  2441.             $sql2.=" ".$id;
    2442. 

  2442.             $sql2.=" ,".$field_id;
    2443. 

  2443.             //7 = 'オプションリスト';
    2444. 

  2444.             //8 = 'ラジオボタンリスト';
    2445. 

  2445.             if (($type==7 OR $type==8) AND ($selection<>"")){
    2446. 

  2446.                 $sql2.=",'0' ";
    2447. 

  2447.             }else{
    2448. 

  2448.                 $sql2.=",'' ";
    2449. 

  2449.             }
    2450. 

  2450.             $sql2.=" )";
    2451. 

  2451. 

  2452.             DB_query($sql2);
    2453. 

  2453.         }
    2454. 

  2454. 

  2455.     }
    2456. 

  2456. 

  2457. 

  2458.     $rt['st']="created";
    2459. 

  2459.     $rt['id']=$id;
    2460. 

  2460.         
    2461. 

  2461.     return $rt;
    2462. 

  2462. }
    2463. 

  2463. 

  2464. // +---------------------------------------------------------------------------+
    2465. 

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

  2466. // | 書式 databox_newlist                                                      |
    2467. 

  2467. // +---------------------------------------------------------------------------+
    2468. 

  2468. // | 引数 $m             :省略時'ALL' id=id指定で選択 code指定で選択           |
    2469. 

  2469. // | 引数 $categories    :選択トピック 省略時設定値or'ALL'                     |
    2470. 

  2470. // | 引数 $rss_file      :RSS_file     省略時""                                |
    2471. 

  2471. // | 引数 $title_trim_length :タイトル長の制限 省略時設定値or20                |
    2472. 

  2472. // | 引数 $intervalday   :新着記事の期間 単位日  省略時設定値or90              |
    2473. 

  2473. // |                      0の時　全件                                          |
    2474. 

  2474. // | 引数 $limitcnt      :表示件数   省略時設定値or10                          |
    2475. 

  2475. // | 引数 $newmarkday    :新着マーク 省略時設定値or3                           |
    2476. 

  2476. // | 引数 $thtml         :テンプレートファイルのフォルダ  layout/テーマ/XXXX/  |
    2477. 

  2477. // |                      省略時は、プラグイン内のテンプレート                 |
    2478. 

  2478. // +---------------------------------------------------------------------------+
    2479. 

  2479. // | 戻値 nomal:新着data一覧                                                   |
    2480. 

  2480. // +---------------------------------------------------------------------------+
    2481. 

  2481. // 2009/04/02　引数 $thtml追加
    2482. 

  2482. // 2009/04/02　テンプレート変数 class 追加
    2483. 

  2483. // 2009/04/02　$intervalday=0の時全件
    2484. 

  2484. // update20110128
    2485. 

  2485. function databox_newlist(
    2486. 

  2486.      $m="ALL"
    2487. 

  2487.     ,$categories=""
    2488. 

  2488.     ,$rss_file=""
    2489. 

  2489.     ,$title_trim_length=""
    2490. 

  2490.     ,$intervalday=""
    2491. 

  2491.     ,$limitcnt=""
    2492. 

  2492.     ,$newmarkday=""
    2493. 

  2493.     ,$thtml=null
    2494. 

  2494.     ,$permission=null)
    2495. 

  2495. {
    2496. 

  2496. 

  2497.     $pi_name="databox";
    2498. 

  2498. 

  2499.     global $_USER;
    2500. 

  2500.     global $_TABLES;
    2501. 

  2501.     global $_CONF;
    2502. 

  2502.     global $_DATABOX_CONF;
    2503. 

  2503.     global $LANG_DATABOX;
    2504. 

  2504. 

  2505.     //
    2506. 

  2506.     if ($title_trim_length==""){
    2507. 

  2507.         $title_trim_length=$_DATABOX_CONF['title_trim_length'];
    2508. 

  2508.         if ($title_trim_length==""){
    2509. 

  2509.             $title_trim_length=20;
    2510. 

  2510.         }
    2511. 

  2511.     }
    2512. 

  2512.     //
    2513. 

  2513.     if ($intervalday==""){
    2514. 

  2514.         $intervalday=$_DATABOX_CONF['intervalday'];
    2515. 

  2515.         if ($intervalday==""){
    2516. 

  2516.             $intervalday=90;
    2517. 

  2517.         }
    2518. 

  2518.     }
    2519. 

  2519.     //
    2520. 

  2520.     if ($limitcnt==""){
    2521. 

  2521.         $limitcnt=$_DATABOX_CONF['limitcnt'];
    2522. 

  2522.         if ($limitcnt==""){
    2523. 

  2523.             $limitcnt=10;
    2524. 

  2524.         }
    2525. 

  2525.     }
    2526. 

  2526.     if ($newmarkday==""){
    2527. 

  2527.         $newmarkday=$_DATABOX_CONF['newmarkday'];
    2528. 

  2528.         if ($newmarkday==""){
    2529. 

  2529.             $newmarkday=3;
    2530. 

  2530.         }
    2531. 

  2531.     }
    2532. 

  2532. 

  2533.     if ($m===""){
    2534. 

  2534.         $categories="ALL";
    2535. 

  2535.     }else{
    2536. 

  2536.         if ($categories==""){
    2537. 

  2537.             $categories=$_DATABOX_CONF['categories'];
    2538. 

  2538.             if ($categories==""){
    2539. 

  2539.                 $categories="ALL";
    2540. 

  2540.             }
    2541. 

  2541.         }elseif (strpos($categories,",")=="") {
    2542. 

  2542.             $categories="'$categories'";
    2543. 

  2543.         }else{
    2544. 

  2544.             $ary=explode(",",$categories);
    2545. 

  2545.             $b="";
    2546. 

  2546.             for ($i = 1; $i <= count($ary); $i++) {
    2547. 

  2547.                 if ($m==="code"){
    2548. 

  2548.                     $b.="'".current($ary)."',";
    2549. 

  2549.                 }else{
    2550. 

  2550.                     $b.=current($ary).",";
    2551. 

  2551.                 }
    2552. 

  2552.                 next($ary);
    2553. 

  2553.             }
    2554. 

  2554.             $categories=rtrim($b,",");
    2555. 

  2555.         }
    2556. 

  2556.     }
    2557. 

  2557. 

  2558.     //
    2559. 

  2559.     $new_img=$_DATABOX_CONF['new_img'];
    2560. 

  2560.     if ($new_img==""){
    2561. 

  2561.         $new_img="New!";
    2562. 

  2562.     }
    2563. 

  2563.     $rss_img=$_DATABOX_CONF['rss_img'];
    2564. 

  2564.     if ($rss_img=="") {
    2565. 

  2565.         $rss_img="[RSS]";
    2566. 

  2566.     }
    2567. 

  2567. 

  2568.     if (is_null($thtml)){
    2569. 

  2569.         $thtml="default";
    2570. 

  2570.     }
    2571. 

  2571. 

  2572. //-------------------------------------------
    2573. 

  2573.     $retval="";
    2574. 

  2574. 

  2575.     //テンプレートフォルダの設定
    2576. 

  2576.     $tmplfld=DATABOX_templatePath('newlist',$thtml,$pi_name);
    2577. 

  2577. 

  2578.     $list = new Template($tmplfld);
    2579. 

  2579.     $list->set_file (array (
    2580. 

  2580.         'list' => 'list.thtml',
    2581. 

  2581.         'col'   => 'list_col.thtml'
    2582. 

  2582.     ));
    2583. 

  2583. 

  2584.     $datefield=$_DATABOX_CONF['datefield'];//使用する日付（編集日付、作成日付）
    2585. 

  2585. 

  2586.     //-----
    2587. 

  2587.     $tbl1=$_TABLES['DATABOX_base'] ;
    2588. 

  2588.     $tbl2=$_TABLES['DATABOX_category'] ;
    2589. 

  2589.     $tbl3=$_TABLES['DATABOX_def_category'] ;
    2590. 

  2590. 

  2591. 

  2592.     $sql="SELECT ".LB;
    2593. 

  2593.     $sql.=" t1.title".LB;
    2594. 

  2594.     $sql.=" , UNIX_TIMESTAMP(t1.".$datefield .") AS day".LB;
    2595. 

  2595.     $sql.=" , t1.id".LB;
    2596. 

  2596.     $sql.=" , t1.code".LB;
    2597. 

  2597.     $sql.=" , t1.description".LB;
    2598. 

  2598. 

  2599.     $sql.=" ,t1.owner_id".LB;
    2600. 

  2600.     $sql.=" ,t1.group_id".LB;
    2601. 

  2601.     $sql.=" ,t1.perm_owner".LB;
    2602. 

  2602.     $sql.=" ,t1.perm_group".LB;
    2603. 

  2603.     $sql.=" ,t1.perm_members".LB;
    2604. 

  2604.     $sql.=" ,t1.perm_anon".LB;
    2605. 

  2605. 

  2606.     $sql .= " FROM ".LB;
    2607. 

  2607.     $sql .= " {$tbl1} AS t1 ".LB;
    2608. 

  2608. 

  2609.     if ($categories!=="ALL" ){
    2610. 

  2610.         $sql .= " ,{$tbl2} AS t2 ".LB;
    2611. 

  2611.         $sql .= " ,{$tbl3} AS t3 ".LB;
    2612. 

  2612.     }
    2613. 

  2613. 

  2614.     $sql.=" WHERE";
    2615. 

  2615.     if ($categories==="ALL" ){
    2616. 

  2616.         $sql.=" 1=1";
    2617. 

  2617.     }else{
    2618. 

  2618.         $sql.= " t1.id = t2.id ".LB;
    2619. 

  2619.         $sql.= " AND t2.category_id = t3.category_id ".LB;
    2620. 

  2620.     }
    2621. 

  2621. 

  2622.     //管理者の時,下書データも含む
    2623. 

  2623.     //if ( SEC_hasRights('databox.admin')) {
    2624. 

  2624.     //}else{
    2625. 

  2625.        $sql .= " AND t1.draft_flag=0".LB;
    2626. 

  2626.     //}
    2627. 

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

  2628.     if  ($_DATABOX_CONF['disable_permission_ignore']=="0" AND strtoupper($permission)=="IGNORE"){
    2629. 

  2629.     }else{
    2630. 

  2630.         $sql .= COM_getPermSql('AND').LB;
    2631. 

  2631.     }
    2632. 

  2632.     //公開日以前のデータはのぞく
    2633. 

  2633.     $sql .= " AND (released <= NOW())".LB;
    2634. 

  2634. 

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

  2636.     $sql .= " AND (expired=0 OR expired > NOW())".LB;
    2637. 

  2637. 

  2638.     if ($intervalday<>0){
    2639. 

  2639.         $sql.=" AND (".$datefield ." >= (date_sub(NOW(), INTERVAL $intervalday day)))".LB;
    2640. 

  2640.     }
    2641. 

  2641. 

  2642.     if ($categories!=="ALL" ){
    2643. 

  2643.         if ($m==="id") {
    2644. 

  2644.             $sql.=" AND t2.category_id IN ($categories)";
    2645. 

  2645.         }else{
    2646. 

  2646.             $sql.=" AND t3.code IN ($categories)";
    2647. 

  2647.         }
    2648. 

  2648.     }
    2649. 

  2649. 

  2650.     $sql .= COM_getLangSQL ('code', 'AND', 't1').LB;
    2651. 

  2651. 

  2652.     $sql.=" ORDER BY ".$datefield ." DESC";
    2653. 

  2653.     $sql.=" LIMIT $limitcnt";
    2654. 

  2654. 

  2655.     $result = DB_query ($sql);
    2656. 

  2656. 

  2657.     $i=0;
    2658. 

  2658. 

  2659.     while( $A = DB_fetchArray( $result ) )    {
    2660. 

  2660.         $A = array_map('stripslashes', $A);
    2661. 

  2661. 

  2662.         $title= COM_truncate( $A['title'], $title_trim_length,'...' );
    2663. 

  2663.         $description = $A['description'];
    2664. 

  2664.         $id = $A['id'];
    2665. 

  2665.         $code = $A['code'];
    2666. 

  2666. 

  2667.         $rt= databox_detail_link($id,$code,$title);
    2668. 

  2668. 

  2669.         $list->set_var ('site_url', $_CONF['site_url']);
    2670. 

  2670. 

  2671.         $list->set_var ('day', strftime($LANG_DATABOX['day'],$A['day']));
    2672. 

  2672. 

  2673.         $chkday=strtotime("- $newmarkday days",time());
    2674. 

  2674.         if (date("Ymd",$A['day']) >= date("Ymd",$chkday)){
    2675. 

  2675.             $list->set_var ('new_img', $new_img);
    2676. 

  2676.         }else{
    2677. 

  2677.             $list->set_var ('new_img', '');
    2678. 

  2678.         }
    2679. 

  2679.         $list->set_var ('link', $rt['link']);//@@@@@
    2680. 

  2680. 

  2681.         $list->set_var ('url', $rt['url']);
    2682. 

  2682.         $list->set_var ('title', $title);
    2683. 

  2683. 

  2684. 		$list->set_var ('description', $description);
    2685. 

  2685. 

  2686.         $permission=SEC_hasAccess2($A);
    2687. 

  2687.         $list->set_var ('permission',$permission);
    2688. 

  2688.         if  ($permission>=2){
    2689. 

  2689.             $list->set_var ('class_a', 'class="gl-tooltip"');
    2690. 

  2690.             $list->set_var ('class_c', 'class="classic"');
    2691. 

  2691.         }else{
    2692. 

  2692.             $list->set_var ('class_a', 'class="databox_nolink"');
    2693. 

  2693.             $list->set_var ('class_c', 'class="databox_displaynon"');
    2694. 

  2694.         }
    2695. 

  2695. 

  2696. 

  2697.         $n=($i%2)+1;
    2698. 

  2698.         $class='class="row'.$n.'"';
    2699. 

  2699.         $list->set_var ('class', 'class="row'.$n.'"');
    2700. 

  2700. 

  2701.         //カテゴリ
    2702. 

  2702.         DATABOX_getcategoriesDisp($A['id'],$list,$chk_user,0,$pi_name);
    2703. 

  2703. 

  2704.         $list->parse ('list_col', 'col', true);
    2705. 

  2705. 

  2706.         $i++;
    2707. 

  2707.     }
    2708. 

  2708. 

  2709.     $list->set_var ('site_url', $_CONF['site_url']);
    2710. 

  2710.     $list->set_var ('day', strftime($LANG_DATABOX['day'],$A['day']));
    2711. 

  2711. 

  2712.     //
    2713. 

  2713.     if ($rss_file<>""){
    2714. 

  2714.         $list->set_var ('rss_url', $_CONF['site_url'] . '/backend/'.$rss_file);
    2715. 

  2715.         $list->set_var ('rss_title', $rss_img);
    2716. 

  2716.     }
    2717. 

  2717.     //
    2718. 

  2718.     $more_title=$LANG_DATABOX['more'];
    2719. 

  2719.     if ($categories==="ALL" OR strpos($categories,",")<>"") {
    2720. 

  2720.         $more_url=COM_buildUrl($_CONF['site_url'] . '/databox/index.php');//
    2721. 

  2721.     }else{
    2722. 

  2722.         //コード使用の時
    2723. 

  2723.         if ($m="code"){
    2724. 

  2724.             $more_url.="m=code";
    2725. 

  2725.             $more_url.="&amp;code=".ltrim(rtrim($categories,"'"),"'");
    2726. 

  2726.         }else{
    2727. 

  2727.             $more_url.="m=id";
    2728. 

  2728.             $more_url.="&amp;id=".ltrim(rtrim($categories,"'"),"'");
    2729. 

  2729.         }
    2730. 

  2730.         $more_url=$_CONF['site_url'] . "/databox/index.php".$more_url;//@@@@@
    2731. 

  2731.     }
    2732. 

  2732. 

  2733.     $more_url = COM_buildUrl( $more_url );
    2734. 

  2734.     $more_link= COM_createLink($title, $more_url);
    2735. 

  2735.     $list->set_var ('more_url', $more_url);
    2736. 

  2736.     $list->set_var ('more_title', $more_title);
    2737. 

  2737. 

  2738.     $list->parse ('output', 'list');
    2739. 

  2739.     $retval .= $list->finish ($list->get_var ('output'));
    2740. 

  2740. 

  2741. 

  2742.     return $retval;
    2743. 

  2743. }
    2744. 

  2744. 

  2745. 

  2746. // | 書式 databox_order ($url, $templates, $order)
    2747. 

  2747. 

  2748. // +---------------------------------------------------------------------------+
    2749. 

  2749. // | 機能 ORDER指定LINK出力
    2750. 

  2750. // | 書式 databox_order()
    2751. 

  2751. // +---------------------------------------------------------------------------+
    2752. 

  2752. // | 引数 $url:
    2753. 

  2753. // | 引数 $templates
    2754. 

  2754. // | 引数 $cur_order:
    2755. 

  2755. // +---------------------------------------------------------------------------+
    2756. 

  2756. function databox_order(
    2757. 

  2757.     $url=""
    2758. 

  2758.     ,$templates
    2759. 

  2759.     ,$cur_order="id"
    2760. 

  2760. 

  2761. )
    2762. 

  2762. {
    2763. 

  2763. global $LANG_DATABOX_ORDER;
    2764. 

  2764. global $_TABLES;
    2765. 

  2765. 

  2766.     $templates->set_var('cur_order',$cur_order);
    2767. 

  2767. 

  2768. 

  2769.     $order_ary=array();
    2770. 

  2770.     $order_ary[]='random';
    2771. 

  2771.     $order_ary[]='date';
    2772. 

  2772.     $order_ary[]='orderno';
    2773. 

  2773.     $order_ary[]='code';
    2774. 

  2774.     $order_ary[]='title';
    2775. 

  2775.     $order_ary[]='description';
    2776. 

  2776.     $order_ary[]='id';
    2777. 

  2777.     $order_ary[]='released';
    2778. 

  2778. 

  2779.     $sql="SELECT ";
    2780. 

  2780.     $sql.= " field_id ";
    2781. 

  2781.     $sql.= ",name ";
    2782. 

  2782.     $sql.= ",templatesetvar";
    2783. 

  2783.     $sql.=" FROM";
    2784. 

  2784.     $sql.=" {$_TABLES['DATABOX_def_field']} ";
    2785. 

  2785.     $sql.=" where allow_display=0";
    2786. 

  2786. 

  2787. 

  2788.     $result = DB_query ($sql);
    2789. 

  2789.     $numrows = DB_numRows ($result);
    2790. 

  2790. 

  2791.     $addfield_ary=array();
    2792. 

  2792.     for ($i = 1; $i <= $numrows; $i++) {
    2793. 

  2793.         $A = DB_fetchArray ($result);
    2794. 

  2794.         $field_id=COM_stripslashes($A['field_id']);
    2795. 

  2795.         $addfield_ary[$field_id]['name']=COM_stripslashes($A['name']);
    2796. 

  2796.         $addfield_ary[$field_id]['templatesetvar']=COM_stripslashes($A['templatesetvar']);
    2797. 

  2797.         $order_ary[]="addfield".$field_id;
    2798. 

  2798.     }
    2799. 

  2799. 

  2800.     for ($i = 1; $i <= count($order_ary); $i++) {
    2801. 

  2801.         $c=current($order_ary);
    2802. 

  2802. 

  2803.         if (substr($c,0,8)==="addfield"){
    2804. 

  2804.             $field_id=substr($c,8);
    2805. 

  2805.             $order=$addfield_ary[$field_id]['templatesetvar'];
    2806. 

  2806.             $order_name=$addfield_ary[$field_id]['name'];
    2807. 

  2807.             $order_name.=$LANG_DATABOX_ORDER['order'];
    2808. 

  2808.         }else{
    2809. 

  2809.             $order=$c;
    2810. 

  2810.             $order_name=$LANG_DATABOX_ORDER[$c];
    2811. 

  2811.         }
    2812. 

  2812. 

  2813.         $order_url=$url;
    2814. 

  2814.         $order_url.=$order;
    2815. 

  2815.         //$order_url = COM_buildUrl( $order_url );
    2816. 

  2816.         $rt= COM_createLink($order_name, $order_url);
    2817. 

  2817. 

  2818.         $templates->set_var('order_'.$order,$rt);
    2819. 

  2819. 

  2820.         next($order_ary);
    2821. 

  2821.     }
    2822. 

  2822. 

  2823. 

  2824.     return ;
    2825. 

  2825. 

  2826. 

  2827. }
    2828. 

  2828. 

  2829. function databox_datalink(
    2830. 

  2830.     $id
    2831. 

  2831.     ,$code
    2832. 

  2832.     ,$linktext
    2833. 

  2833. )
    2834. 

  2834. {
    2835. 

  2835.     global $_CONF;
    2836. 

  2836.     global $_TABLES;
    2837. 

  2837.     
    2838. 

  2838.     $url="";
    2839. 

  2839.     if ($id<>"") {
    2840. 

  2840.         $url=$_CONF['site_url']."/databox/data.php?";
    2841. 

  2841.         $url.="m=id&amp;id=".$id;
    2842. 

  2842.         if  ($linktext==""){
    2843. 

  2843.             $linktext = stripslashes(DB_getItem($_TABLES['DATABOX_base'],'title', "id = '$id'"));
    2844. 

  2844.         }
    2845. 

  2845.     }else if ($code<>""){
    2846. 

  2846.         $code=DATABOX_swichlang($code);
    2847. 

  2847.         $url=$_CONF['site_url']."/databox/data.php?";
    2848. 

  2848.         $url.="code=".$code;
    2849. 

  2849.         $url.="&amp;m=code";
    2850. 

  2850.         if  ($linktext==""){
    2851. 

  2851.             $linktext = stripslashes(DB_getItem($_TABLES['DATABOX_base'],'title', "code = '$code'"));
    2852. 

  2852.         }
    2853. 

  2853.     }
    2854. 

  2854.     if  ($url<>""){
    2855. 

  2855.         $url = COM_buildUrl($url);
    2856. 

  2856.         $url = COM_createLink($linktext, $url);
    2857. 

  2857.     }
    2858. 

  2858.     return $url;
    2859. 

  2859. }
    2860. 

  2860. 

  2861. function databox_mydataentrylink(
    2862. 

  2862.     $fieldset_id = ""
    2863. 

  2863.     ,$templatedir =""
    2864. 

  2864.     ,$linktext =""
    2865. 

  2865. )
    2866. 

  2866. {
    2867. 

  2867.     global $_CONF;
    2868. 

  2868.     global $_TABLES;
    2869. 

  2869.     global $LANG_DATABOX_ADMIN;
    2870. 

  2870.     global $_DATABOX_CONF;
    2871. 

  2871.     
    2872. 

  2872.     $url="";
    2873. 

  2873.     //ユーザに更新と新規登録を許可するかまたは、新規登録権を持ったユーザの場合
    2874. 

  2874.     if ($_DATABOX_CONF['allow_data_update'] AND $_DATABOX_CONF['allow_data_insert'] OR
    2875. 

  2875.         SEC_hasRights('databox.submit')){
    2876. 

  2876.         if ($fieldset_id=="" OR $fieldset_id==0) {
    2877. 

  2877.             $url=$_CONF['site_url']."/databox/mydata/data.php?";
    2878. 

  2878.             $url.="mode=new";
    2879. 

  2879.             if  ($templatedir){
    2880. 

  2880.                 $url.="&amp;template=".$templatedir;
    2881. 

  2881.             }
    2882. 

  2882.             if  ($linktext==""){
    2883. 

  2883.                 $linktext = $LANG_DATABOX_ADMIN["new"];
    2884. 

  2884.             }
    2885. 

  2885.         }else{
    2886. 

  2886.             if (DB_getItem($_TABLES['DATABOX_def_fieldset'],'fieldset_id', "fieldset_id = '$fieldset_id'")==$fieldset_id){
    2887. 

  2887.                 $url=$_CONF['site_url']."/databox/mydata/data.php?";
    2888. 

  2888.                 $url.="type_id=".$fieldset_id;
    2889. 

  2889.                 if  ($templatedir){
    2890. 

  2890.                     $url.="&amp;template=".$templatedir;
    2891. 

  2891.                 }
    2892. 

  2892.                 if  ($linktext==""){
    2893. 

  2893.                     $linktext = stripslashes(DB_getItem($_TABLES['DATABOX_def_fieldset'],'name', "fieldset_id = '$fieldset_id'"));
    2894. 

  2894.                 }
    2895. 

  2895.             }
    2896. 

  2896.         }
    2897. 

  2897.         $url = COM_createLink($linktext, $url);
    2898. 

  2898.     }
    2899. 

  2899.     return $url;
    2900. 

  2900. }
    2901. 

  2901. function databox_mydata(
    2902. 

  2902.     $templatedir =""
    2903. 

  2903.     ,$linktext =""
    2904. 

  2904. )
    2905. 

  2905. {
    2906. 

  2906.     global $_CONF;
    2907. 

  2907.     global $_TABLES;
    2908. 

  2908.     global $_DATABOX_CONF;
    2909. 

  2909.     global $LANG_DATABOX;
    2910. 

  2910.     $url="";
    2911. 

  2911.     //ユーザに更新を許可するかまたは、更新権を持ったユーザの場合
    2912. 

  2912.     if ($_DATABOX_CONF['allow_data_update'] OR SEC_hasRights('databox.edit')){
    2913. 

  2913.         $url=$_CONF['site_url']."/databox/mydata/data.php?";
    2914. 

  2914.         if  ($templatedir){
    2915. 

  2915.             $url.="&amp;template=".$templatedir;
    2916. 

  2916.         }
    2917. 

  2917.         if  ($linktext==""){
    2918. 

  2918.             $linktext = $LANG_DATABOX['mydata'];
    2919. 

  2919.         }
    2920. 

  2920.         $url = COM_createLink($linktext, $url);
    2921. 

  2921.     }
    2922. 

  2922.     return $url;
    2923. 

  2923. }
    2924. 

  2924. function databox_Comment(
    2925. 

  2925.     $id
    2926. 

  2926.     ,$code
    2927. 

  2927. )
    2928. 

  2928. // +---------------------------------------------------------------------------+
    2929. 

  2929. // | 機能 コメント表示
    2930. 

  2930. // | 書式 databox_Comment($id,$code)
    2931. 

  2931. // +---------------------------------------------------------------------------+
    2932. 

  2932. // | 戻値 nomal:
    2933. 

  2933. // +---------------------------------------------------------------------------+
    2934. 

  2934. {
    2935. 

  2935.     global $_CONF;
    2936. 

  2936.     global $_TABLES;
    2937. 

  2937.     //    
    2938. 

  2938.     $order = '';
    2939. 

  2939.     if (isset ($_REQUEST['order'])) {
    2940. 

  2940.         $order = COM_applyFilter ($_REQUEST['order']);
    2941. 

  2941.     }
    2942. 

  2942.     $mode = '';
    2943. 

  2943.     if (isset ($_REQUEST['mode'])) {
    2944. 

  2944.         $mode = COM_applyFilter ($_POST['mode']);
    2945. 

  2945.     }
    2946. 

  2946.     
    2947. 

  2947.     $page = 1;
    2948. 

  2948.     if (isset ($_REQUEST['cpage'])) {
    2949. 

  2949.         $page = COM_applyFilter ($_REQUEST['cpage']);
    2950. 

  2950.     }
    2951. 

  2951.     //
    2952. 

  2952.     
    2953. 

  2953.     $tbl=$_TABLES['DATABOX_base'] ;
    2954. 

  2954. 

  2955.     //-----
    2956. 

  2956.     $sql = "SELECT ";
    2957. 

  2957.     
    2958. 

  2958.     $sql .= "commentcode "; 
    2959. 

  2959.     $sql .= ",owner_id";
    2960. 

  2960.     $sql .= ",group_id";
    2961. 

  2961.     $sql .= ",perm_owner";
    2962. 

  2962.     $sql .= ",perm_group";
    2963. 

  2963.     $sql .= ",perm_members";
    2964. 

  2964.     $sql .= ",perm_anon";
    2965. 

  2965.     $sql .= ",title";
    2966. 

  2966.     $sql .= ",id";
    2967. 

  2967. 

  2968.     $sql .= " FROM ";
    2969. 

  2969.     $sql .= " {$tbl} AS t ";//base
    2970. 

  2970.     $sql .= " WHERE ";
    2971. 

  2971.     if   ($id<>0) {
    2972. 

  2972.         $sql .= " id=".$id;
    2973. 

  2973.     }else{
    2974. 

  2974.         $sql .= " code='".$code."'";
    2975. 

  2975.     }
    2976. 

  2976.     $sql .= " AND t.draft_flag=0".LB;
    2977. 

  2977.     
    2978. 

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

  2979.     $sql .= COM_getPermSql('AND');
    2980. 

  2980.     //公開日以前のデータはのぞく
    2981. 

  2981.     $sql .= " AND (released <= NOW())";
    2982. 

  2982. 

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

  2984.     $sql .= " AND (expired=0 OR expired > NOW())";
    2985. 

  2985.     //
    2986. 

  2986.     
    2987. 

  2987.     $result = DB_query ($sql);
    2988. 

  2988.     $numrows = DB_numRows ($result);
    2989. 

  2989.     
    2990. 

  2990.     if ($numrows > 0) {
    2991. 

  2991. 

  2992.         $A = DB_fetchArray ($result);
    2993. 

  2993.         $A = array_map('stripslashes', $A);
    2994. 

  2994.         if  ($A['commentcode']>=0){
    2995. 

  2995.             $delete_option = (SEC_hasRights('databox.edit') &&
    2996. 

  2996.                     SEC_hasAccess($A['owner_id'], $A['group_id'],
    2997. 

  2997.                     $A['perm_owner'], $A['perm_group'], $A['perm_members'],
    2998. 

  2998.                     $A['perm_anon']) == 3 ? true : false);
    2999. 

  2999.     
    3000. 

  3000.             require_once $_CONF['path_system'] . 'lib-comment.php';
    3001. 

  3001.             $retval .= CMT_userComments(
    3002. 

  3002.                             $A['id']
    3003. 

  3003.                             , $A['title']
    3004. 

  3004.                             , 'databox'
    3005. 

  3005.                             , $order
    3006. 

  3006.                             , $mode
    3007. 

  3007.                             , 0
    3008. 

  3008.                             , $page
    3009. 

  3009.                             , false
    3010. 

  3010.                             , $delete_option
    3011. 

  3011.                             , $A['commentcode']
    3012. 

  3012.                             );
    3013. 

  3013.         }
    3014. 

  3014.     }
    3015. 

  3015.     
    3016. 

  3016. 

  3017.     return $retval;
    3018. 

  3018. }
    3019. 

  3019. 

  3020. function databox_detail_link(
    3021. 

  3021.     $id
    3022. 

  3022.     ,$code
    3023. 

  3023.     ,$title
    3024. 

  3024. )
    3025. 

  3025. // +---------------------------------------------------------------------------+
    3026. 

  3026. // | 機能  個別データlink
    3027. 

  3027. // | 書式  databox_detail_link($id,$code,$title);
    3028. 

  3028. // +---------------------------------------------------------------------------+
    3029. 

  3029. // | 引数 $id            :
    3030. 

  3030. // | 引数 $code          :
    3031. 

  3031. // | 引数 $title         :
    3032. 

  3032. // +---------------------------------------------------------------------------+
    3033. 

  3033. // | 戻値 nomal:$return['link'] $return['url']
    3034. 

  3034. // +---------------------------------------------------------------------------+
    3035. 

  3035. {
    3036. 

  3036.     global $_CONF;
    3037. 

  3037.     global $_DATABOX_CONF;
    3038. 

  3038.     
    3039. 

  3039.     $return['link']="" ;
    3040. 

  3040.     $return['url']="" ;
    3041. 

  3041.     
    3042. 

  3042.     if  ($id==0  AND $code==""){
    3043. 

  3043.         return $return;
    3044. 

  3044.     }
    3045. 

  3045.     if  ($_DATABOX_CONF['detail']==""){
    3046. 

  3046.         $prg="data.php";
    3047. 

  3047.     }else{
    3048. 

  3048.         $prg=$_DATABOX_CONF['detail'];
    3049. 

  3049.     }
    3050. 

  3050.     
    3051. 

  3051.     $url=$_CONF['site_url'] . "/databox/".$_DATABOX_CONF['detail'];
    3052. 

  3052.     $url.="?";
    3053. 

  3053.     
    3054. 

  3054.     if  ($prg=="data.php"){
    3055. 

  3055.         if ($_DATABOX_CONF['datacode'] OR $id==0){
    3056. 

  3056.             $url.="code=".$code;
    3057. 

  3057.             $url.="&amp;m=code";
    3058. 

  3058.         }else{
    3059. 

  3059.             $url.="id=".$id; 
    3060. 

  3060.             $url.="&amp;m=id";
    3061. 

  3061.         }
    3062. 

  3062.     }else{
    3063. 

  3063.         if  ($code<>""){
    3064. 

  3064.             $url.="code=".$code;
    3065. 

  3065.         }
    3066. 

  3066. 	}
    3067. 

  3067.     $return['url']=  COM_buildUrl( $url );
    3068. 

  3068.     $return['link']= COM_createLink($title, $return['url']);
    3069. 

  3069.     return $return;
    3070. 

  3070. }
    3071. 

  3071. 

  3072. function databox_search(
    3073. 

  3073.     $autotag
    3074. 

  3074.     ,$argary
    3075. 

  3075. )
    3076. 

  3076. // +---------------------------------------------------------------------------+
    3077. 

  3077. // | 機能  検索リスト
    3078. 

  3078. // | 書式  databox_search($autotag,$argary);
    3079. 

  3079. // +---------------------------------------------------------------------------+
    3080. 

  3080. // | 引数 $autotag :
    3081. 

  3081. // | 引数 $argary  :
    3082. 

  3082. // +---------------------------------------------------------------------------+
    3083. 

  3083. // | 戻値 nomal:検索リスト
    3084. 

  3084. // +---------------------------------------------------------------------------+
    3085. 

  3085. {
    3086. 

  3086. 

  3087.     $pi_name="databox";
    3088. 

  3088.     
    3089. 

  3089.     global $_CONF;
    3090. 

  3090.     global $_TABLES;
    3091. 

  3091.     
    3092. 

  3092.     global $_DATABOX_CONF;
    3093. 

  3093.     global $LANG_DATABOX;
    3094. 

  3094.     global $LANG_DATABOX_ADMIN;
    3095. 

  3095.     global $_IMAGE_TYPE;
    3096. 

  3096.     global $LANG_confignames;
    3097. 

  3097.     global $_PLUGINS;
    3098. 

  3098.     global $_MAPS_CONF;
    3099. 

  3099. 

  3100.     //ログイン要否チェック
    3101. 

  3101.     if (COM_isAnonUser()){
    3102. 

  3102.         if  ($_CONF['loginrequired']
    3103. 

  3103.                 OR ($_DATABOX_CONF['loginrequired'] >1) ){
    3104. 

  3104.             return $LANG_DATABOX['loginrequired'];
    3105. 

  3105.         }
    3106. 

  3106.     }
    3107. 

  3107.           
    3108. 

  3108.     if (! defined('THIS_SCRIPT')) {
    3109. 

  3109.         define ('THIS_SCRIPT', 'databox/search.php');
    3110. 

  3110.     }
    3111. 

  3111.           
    3112. 

  3112.     //-----テーブル
    3113. 

  3113.     $tbl1=$_TABLES['DATABOX_category'] ;
    3114. 

  3114.     $tbl2=$_TABLES['DATABOX_base'] ;
    3115. 

  3115.     $tbl3=$_TABLES['DATABOX_addition'] ;
    3116. 

  3116.     //
    3117. 

  3117.     $tbl5=$_TABLES['DATABOX_def_category'] ;
    3118. 

  3118.     
    3119. 

  3119.     $tbl6=$_TABLES['DATABOX_stats'];
    3120. 

  3120.     $tbl7=$_TABLES['DATABOX_def_fieldset'];
    3121. 

  3121. 

  3122.     //
    3123. 

  3123.     $datefield=$_DATABOX_CONF['datefield'];//使用する日付（編集日付、作成日付、公開日）
    3124. 

  3124.     $new_img=$_DATABOX_CONF['new_img'];
    3125. 

  3125.     if ($new_img==""){
    3126. 

  3126.         $new_img="New!";
    3127. 

  3127.     }
    3128. 

  3128.     $newmarkday=$_DATABOX_CONF['newmarkday'];
    3129. 

  3129.     if ($newmarkday==""){
    3130. 

  3130.         $newmarkday=3;
    3131. 

  3131.     }
    3132. 

  3132.     $chkday=strtotime("- $newmarkday days",time());
    3133. 

  3133.     
    3134. 

  3134.     //-----Argument checking　引数チェック
    3135. 

  3135.     $arg_sv="";//---Argument save 引数退避　order page を除く
    3136. 

  3136.     foreach((array)$argary as $key => $value) {
    3137. 

  3137.         if (is_array($value)){
    3138. 

  3138.             $ary=$value;
    3139. 

  3139.             foreach($ary as $key2 => $value2){
    3140. 

  3140.                 if  ($arg_sv<>""){
    3141. 

  3141.                     $arg_sv.="&amp;";
    3142. 

  3142.                 }
    3143. 

  3143.                 $arg_sv.=$key."[]=".$value2;
    3144. 

  3144.             }
    3145. 

  3145.         }else{
    3146. 

  3146.             if  ($key=="order"  OR $key=="page"){
    3147. 

  3147.             }else{
    3148. 

  3148.                 if  ($arg_sv<>""){
    3149. 

  3149.                     $arg_sv.="&amp;";
    3150. 

  3150.                 }
    3151. 

  3151.                 $arg_sv.=$key."=".$value;
    3152. 

  3152.             }
    3153. 

  3153.         }
    3154. 

  3154. 	}
    3155. 

  3155.     if  ($argary['fieldset_id']==""){
    3156. 

  3156.         $argary['fieldset_id']=0;
    3157. 

  3157.     }
    3158. 

  3158. 

  3159. 

  3160.     $fieldset_name=COM_applyFilter(DB_getItem( $tbl7 ,"name","fieldset_id={$argary['fieldset_id']}"));
    3161. 

  3161. 

  3162.     if ($argary['perpage']===0 OR is_null($argary['perpage'])){
    3163. 

  3163.         $argary['perpage']=$_DATABOX_CONF['perpage'];
    3164. 

  3164.     }
    3165. 

  3165.     if ($argary['page']===0 OR is_null($argary['page'])){
    3166. 

  3166.         $argary['page']=1;
    3167. 

  3167.     }
    3168. 

  3168.     if (is_null($argary['nohitmsg'])){
    3169. 

  3169.         $argary['nohitmsg']="yes";
    3170. 

  3170.     }
    3171. 

  3171.     if (is_null($argary['expired'])){
    3172. 

  3172.         $argary['expired']="no";
    3173. 

  3173.     }
    3174. 

  3174.     if (is_null($argary['order'])){
    3175. 

  3175.         $argary['order']="date";
    3176. 

  3176.     }
    3177. 

  3177.     //============
    3178. 

  3178.     $cary=array();
    3179. 

  3179.     $acnt=0;
    3180. 

  3180.     $afield=array();
    3181. 

  3181.     $afile=array();
    3182. 

  3182.     $awhere=array();
    3183. 

  3183.           
    3184. 

  3184.     foreach((array)$argary as $key => $value) {
    3185. 

  3185.         if (is_array($value)){
    3186. 

  3186.             $k = explode ('_', $key);
    3187. 

  3187.             $ids="";
    3188. 

  3188.             $ary=$value;
    3189. 

  3189.             if  ($k[0]=="gor"){
    3190. 

  3190.                 foreach($ary as $key2 => $value2){
    3191. 

  3191.                     $w= COM_applyFilter($value2);
    3192. 

  3192.                     if  ($w<>""){
    3193. 

  3193.                         if ($ids<>""){
    3194. 

  3194.                             $ids.=",";
    3195. 

  3195.                         }
    3196. 

  3196.                         $ids.= COM_applyFilter($value2);
    3197. 

  3197.                     }
    3198. 

  3198.                 }
    3199. 

  3199.                 if  ($ids<>""){
    3200. 

  3200.                     $cary[]= "(t2.id IN (SELECT id FROM {$tbl1}"
    3201. 

  3201.                            ." WHERE t2.id=id AND category_id IN ({$ids})) )";
    3202. 

  3202.                 }
    3203. 

  3203.             }else if ($k[0]=="gand"){
    3204. 

  3204.                 foreach($ary as $key2 => $value2){
    3205. 

  3205.                     $w= COM_applyFilter($value2);
    3206. 

  3206.                     if  ($w<>""){
    3207. 

  3207.                         if ($ids<>""){
    3208. 

  3208.                             $ids.=" AND ";
    3209. 

  3209.                         }
    3210. 

  3210.                         $ids.= $w;
    3211. 

  3211.                         $ids.= " IN (SELECT category_id";
    3212. 

  3212.                         $ids.=" FROM {$tbl1}  ";
    3213. 

  3213.                         $ids.=" WHERE t2.id = id )";
    3214. 

  3214.                     }
    3215. 

  3215.                 }
    3216. 

  3216.                 if  ($ids<>""){
    3217. 

  3217.                     $cary[]= " (" .$ids." ) ";
    3218. 

  3218.                 }
    3219. 

  3219.             }else if ($k[0]=="ams"){
    3220. 

  3220.                 foreach($ary as $key2 => $value2){
    3221. 

  3221.                     $w= COM_applyFilter($value2);
    3222. 

  3222.                     if  ($w<>""){
    3223. 

  3223.                         if ($ids<>""){
    3224. 

  3224.                             $ids.=",";
    3225. 

  3225.                         }
    3226. 

  3226.                         $ids.= COM_applyFilter($value2);
    3227. 

  3227.                     }
    3228. 

  3228.                 }
    3229. 

  3229.                 if  ($ids<>""){
    3230. 

  3230.                     $dummy= databox_searchfield($k[0],COM_applyFilter($k[1]),$ids,$acnt,$afield,$afile,$awhere);
    3231. 

  3231.                 }
    3232. 

  3232.             }
    3233. 

  3233.         }else if  ( substr($key,0,3)=="aeq" OR substr($key,0,3)=="afr" 
    3234. 

  3234.                               OR substr($key,0,3)=="ato" OR substr($key,0,1)=="a") {
    3235. 

  3235.             $k = explode ('_', $key);
    3236. 

  3236. 

  3237.             if  ($value<>""){
    3238. 

  3238.                 $dummy= databox_searchfield($k[0],COM_applyFilter($k[1]),$value,$acnt,$afield,$afile,$awhere);
    3239. 

  3239.             }
    3240. 

  3240.         }
    3241. 

  3241.     }
    3242. 

  3242. 

  3243.     $dummy=databox_orderby($datefield,$argary['order'],$orderby,$addfieldorder,$field_id);
    3244. 

  3244. 

  3245.     //-----
    3246. 

  3246.     $sql = "SELECT ";
    3247. 

  3247. 

  3248.     $sql .= " t2.id ".LB;
    3249. 

  3249.     $sql .= " ,t2.title ".LB;
    3250. 

  3250.     $sql .= " ,t2.code ".LB;
    3251. 

  3251.     $sql .= " ,t2.description ".LB;
    3252. 

  3252.     $sql .= " ,t2.released ".LB;
    3253. 

  3253.     $sql .= " ,t2.expired ".LB;
    3254. 

  3254.     $sql .= " ,t2.".$datefield." AS datefield ".LB;
    3255. 

  3255.     $sql .= " ,t2.fieldset_id ".LB;
    3256. 

  3256.     $sql .= " ,UNIX_TIMESTAMP(t2.".$datefield.") AS datefield_un ".LB;
    3257. 

  3257.     $sql .= " ,UNIX_TIMESTAMP(t2.released ) AS released_un ".LB;
    3258. 

  3258.     $sql .= " ,UNIX_TIMESTAMP(t2.expired ) AS expired_un ".LB;
    3259. 

  3259. 

  3260.     $sql .= " ,t2.group_id".LB;
    3261. 

  3261.     $sql .= " ,t2.owner_id".LB;
    3262. 

  3262.           
    3263. 

  3263.     if  ($acnt>0){
    3264. 

  3264.         for ($i = 1; $i <= $acnt; $i++) {
    3265. 

  3265.              $sql .= $afield[$i].LB;
    3266. 

  3266.         }
    3267. 

  3267.     }
    3268. 

  3268.           
    3269. 

  3269.     if ($addfieldorder){
    3270. 

  3270.         $sql .= " ,t3.value ".LB;
    3271. 

  3271.     }
    3272. 

  3272.     
    3273. 

  3273.     //--FROM
    3274. 

  3274.     $sql .= " FROM ".LB;
    3275. 

  3275.     $sql .= " {$tbl2} AS t2 ".LB;
    3276. 

  3276.     if ($addfieldorder){
    3277. 

  3277.         $sql .= " ,{$tbl3} AS t3 ".LB;
    3278. 

  3278.     }
    3279. 

  3279.           
    3280. 

  3280.     if  ($acnt>0){
    3281. 

  3281.         for ($i = 1; $i <= $acnt; $i++) {
    3282. 

  3282.              $sql .= $afile[$i].LB;
    3283. 

  3283.         }
    3284. 

  3284.     }
    3285. 

  3285.     
    3286. 

  3286.     //--WHERE
    3287. 

  3287.     $sql .= " WHERE ".LB;
    3288. 

  3288.                 
    3289. 

  3289.     //タイプ
    3290. 

  3290.     $sql .= " t2.fieldset_id=".$argary['fieldset_id'].LB;
    3291. 

  3291.           //additionfield 追加項目でsort する時
    3292. 

  3292.     if ($addfieldorder){
    3293. 

  3293.         $sql .= " AND t3.field_id=".$field_id.LB;
    3294. 

  3294.         $sql .= " AND t3.id=t2.id".LB;
    3295. 

  3295.     }
    3296. 

  3296. 

  3297.     //条件
    3298. 

  3298.     if  ($argary['teq']<>""){
    3299. 

  3299.         $sql .= " AND (title="."'".$argary['teq']."')".LB;
    3300. 

  3300.     }
    3301. 

  3301.     if  ($argary['t']<>""){
    3302. 

  3302.         $sql .= " AND (title LIKE '%".$argary['t']."%')".LB;
    3303. 

  3303.     }
    3304. 

  3304.     foreach((array)$cary as $value) {
    3305. 

  3305.         $sql .= " AND ".$value.LB;
    3306. 

  3306.     }
    3307. 

  3307.     if  ($acnt>0){
    3308. 

  3308.         for ($i = 1; $i <= $acnt; $i++) {
    3309. 

  3309.             $sql .= " AND ".$awhere[$i].LB;
    3310. 

  3310.         }
    3311. 

  3311.     }
    3312. 

  3312.     //下書データを除く
    3313. 

  3313.     $sql .= " AND t2.draft_flag=0".LB;
    3314. 

  3314. 

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

  3316.     $sql .= COM_getPermSql('AND',0,2,"t2");
    3317. 

  3317. 

  3318.     //公開日以前のデータはのぞく
    3319. 

  3319.     $sql .= " AND (released <= NOW())".LB;
    3320. 

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

  3321.     if  (strtoupper($argary['expired'])=="NO"){
    3322. 

  3322.         $sql .= " AND (expired=0 OR expired > NOW())";
    3323. 

  3323.     }
    3324. 

  3324.     //--ORDER
    3325. 

  3325.     $sql .= " ORDER BY ".LB;
    3326. 

  3326.     $sql .= $orderby.LB;
    3327. 

  3327. 

  3328. //echo "sql=".$sql."<br>";    
    3329. 

  3329.     $result = DB_query ($sql);
    3330. 

  3330.     $cnt = DB_numRows ($result);
    3331. 

  3331. 

  3332.     $pages = 0;
    3333. 

  3333.     if ($argary['perpage'] > 0) {
    3334. 

  3334.         $pages = ceil($cnt / $argary['perpage']);
    3335. 

  3335.     }
    3336. 

  3336.     $offset = ($argary['page'] - 1) * $argary['perpage'];
    3337. 

  3337.     $sql .= " LIMIT $offset, ".$argary['perpage'];
    3338. 

  3338.           
    3339. 

  3339.           
    3340. 

  3340.           
    3341. 

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

  3342.     if ($autotag==="notautotag"){
    3343. 

  3343. 

  3344.         if ($argary['page'] > 1) {
    3345. 

  3345.             $page_title = sprintf ('%s (%d)', $LANG_DATABOX_ADMIN['piname'], $argary['page']);
    3346. 

  3346.         } else {
    3347. 

  3347.             $page_title = sprintf ('%s ', $LANG_DATABOX_ADMIN['piname']);
    3348. 

  3348.         }
    3349. 

  3349.         // Meta Tags
    3350. 

  3350.         $title=$_CONF['site_name'] ."-". $fieldset_name;//og_title
    3351. 

  3351.         $description=$_CONF['meta_description'];//og_description
    3352. 

  3352.         $keywords=$_CONF['meta_keywords'];//og_description
    3353. 

  3353.         //meta 
    3354. 

  3354.         $headercode=DATABOX_getheadercode(          
    3355. 

  3355.            "search"
    3356. 

  3356.             ,$argary['templatedir']
    3357. 

  3357.             ,$pi_name
    3358. 

  3358.             ,""
    3359. 

  3359.             ,$title
    3360. 

  3360.             ,$description
    3361. 

  3361.             ,$keywords
    3362. 

  3362.             ,$description
    3363. 

  3363.             ,""
    3364. 

  3364.             ,""
    3365. 

  3365.             ,""
    3366. 

  3366.             ,$argary['fieldset_id']
    3367. 

  3367.             ,$fieldset_name
    3368. 

  3368.                     );
    3369. 

  3369.           }
    3370. 

  3370.           
    3371. 

  3371.     $result = DB_query ($sql);
    3372. 

  3372.     $numrows = DB_numRows ($result);
    3373. 

  3373. 

  3374. 

  3375.     if ($numrows > 0) {
    3376. 

  3376.         $tmplfld=DATABOX_templatePath('search',$argary['templatedir'],$pi_name);
    3377. 

  3377.         $templates = new Template($tmplfld);
    3378. 

  3378.         $templates->set_file (array (
    3379. 

  3379.             'list' => 'list_detail.thtml',
    3380. 

  3380.             'arg'   => 'argument.thtml',
    3381. 

  3381.             'nav'   => 'navigation_detail.thtml',
    3382. 

  3382.             'row'   => 'row.thtml',
    3383. 

  3383.             'col'   => "col_detail.thtml",
    3384. 

  3384.             ));
    3385. 

  3385.         
    3386. 

  3386.         $dummy=databox_searchargedit($argary,$templates);
    3387. 

  3387.         
    3388. 

  3388.         $languageid=COM_getLanguageId();
    3389. 

  3389.         $language= COM_getLanguage();
    3390. 

  3390.         $templates->set_var ('languageid', $languageid);
    3391. 

  3391.         $templates->set_var ('language', $language);
    3392. 

  3392.         if ($languageid<>"") {
    3393. 

  3393.             $templates->set_var ('_languageid', "_".$languageid);
    3394. 

  3394.         }else{
    3395. 

  3395.             $templates->set_var ('_languageid', "");
    3396. 

  3396.         }
    3397. 

  3397. 

  3398.         //
    3399. 

  3399.         $templates->set_var ('site_url',$_CONF['site_url']);
    3400. 

  3400.         $templates->set_var ('this_script',THIS_SCRIPT);
    3401. 

  3401. 

  3402.         //bread
    3403. 

  3403.         $templates->set_var ('home',$LANG_DATABOX['home']);
    3404. 

  3404.         
    3405. 

  3405.         //page
    3406. 

  3406.         $templates->set_var ('cnt', $cnt);
    3407. 

  3407.         $lin1=$offset+1;
    3408. 

  3408.         $lin2=$lin1+$argary['perpage'] - 1;
    3409. 

  3409.         if ($lin2>$cnt){
    3410. 

  3410.             $lin2=$cnt;
    3411. 

  3411.         }
    3412. 

  3412. 

  3413.         //summary navigation
    3414. 

  3414.         $templates->set_var ('lang_view', $LANG_DATABOX['view']);
    3415. 

  3415.         $templates->set_var ('lin', $lin1."-".($lin2));
    3416. 

  3416.         $templates->set_var ('cnt', $cnt);
    3417. 

  3417. 

  3418.         //
    3419. 

  3419.         $templates->set_var ('lang_title', $LANG_DATABOX_ADMIN['title']);
    3420. 

  3420.         $templates->set_var ('lang_code', $LANG_DATABOX_ADMIN['code']);
    3421. 

  3421.         $templates->set_var ('lang_id', $LANG_DATABOX_ADMIN['id']);
    3422. 

  3422.         $templates->set_var ('lang_description', $LANG_DATABOX_ADMIN['description']);
    3423. 

  3423.         $templates->set_var ('lang_date', $LANG_DATABOX_ADMIN[$datefield]);
    3424. 

  3424.         $templates->set_var ('lang_released', $LANG_DATABOX_ADMIN['released']);
    3425. 

  3425.         $templates->set_var ('lang_expired', $LANG_DATABOX_ADMIN['expired']);
    3426. 

  3426.         $templates->set_var ('lang_remaingdays', $LANG_DATABOX_ADMIN['remaingdays']);
    3427. 

  3427.         $templates->set_var ('lang_addfield', $addfield_name);
    3428. 

  3428.         // 追加項目のヘッダ
    3429. 

  3429.         $addition_def=DATABOX_getadditiondef($pi_name);
    3430. 

  3430.         
    3431. 

  3431.         //
    3432. 

  3432.         $templates->set_var('lang_imgfile_frd', $LANG_confignames['databox']['imgfile_frd']);
    3433. 

  3433.         $templates->set_var ('imgfile_frd', $_DATABOX_CONF['imgfile_frd']);
    3434. 

  3434.         $templates->set_var ('data_img_url', $_CONF['site_url']."/".$_DATABOX_CONF['imgfile_frd']);
    3435. 

  3435.         $templates->set_var('lang_imgfile_thumb_frd', $LANG_confignames['databox']['imgfile_thumb_frd']);
    3436. 

  3436.         $templates->set_var ('imgfile_thumb_frd', $_DATABOX_CONF['imgfile_thumb_frd']);
    3437. 

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

  3438.         
    3439. 

  3439.         $referer =$_SERVER['HTTP_REFERER'];
    3440. 

  3440.         $templates->set_var ('referer', $referer);
    3441. 

  3441.         $templates->set_var ('lang_referer',$LANG_DATABOX['return']);
    3442. 

  3442.         $templates->set_var ('fieldset_name',$fieldset_name);
    3443. 

  3443.         $mkids="";
    3444. 

  3444.         for ($i = 0; $i < $numrows; $i++) {
    3445. 

  3445.             $A = DB_fetchArray ($result);
    3446. 

  3446.             $A = array_map('stripslashes', $A);
    3447. 

  3447. 

  3448.             $title=$A['title'];
    3449. 

  3449.             $description=$A['description'];
    3450. 

  3450.             $code=COM_applyFilter($A['code']);
    3451. 

  3451.             $id=COM_applyFilter($A['id']);
    3452. 

  3452.             $datefield=COM_applyFilter($A['datefield']);
    3453. 

  3453.             $released=COM_applyFilter($A['released']);
    3454. 

  3454.             $expired=COM_applyFilter($A['expired']);
    3455. 

  3455.             $fieldset_id=COM_applyFilter($A['fieldset_id']);
    3456. 

  3456.             $datefield_ary = COM_getUserDateTimeFormat($A['datefield_un']);
    3457. 

  3457.             $released_ary = COM_getUserDateTimeFormat($A['released_un']);
    3458. 

  3458.             if ($expired==="0000-00-00 00:00:00"){
    3459. 

  3459.                 $expired_ary=array();
    3460. 

  3460.             }else{    
    3461. 

  3461.                 $expired_ary = COM_getUserDateTimeFormat($A['expired_un']);
    3462. 

  3462.             }
    3463. 

  3463.             $curdate_ary =  COM_getUserDateTimeFormat();
    3464. 

  3464. 

  3465.             
    3466. 

  3466.             $value=COM_applyFilter($A['value']);
    3467. 

  3467.             $group_id = $A['group_id'];
    3468. 

  3468.             $owner_id = $A['owner_id'];
    3469. 

  3469. 

  3470.             $url=$_CONF['site_url'] . "/databox/data.php";
    3471. 

  3471.             $url.="?";
    3472. 

  3472.             //コード使用の時
    3473. 

  3473.             if ($_DATABOX_CONF['datacode']){
    3474. 

  3474.                 $url.="code=".$code;
    3475. 

  3475.                 $url.="&amp;m=code";
    3476. 

  3476.             }else{
    3477. 

  3477.                 $url.="id=".$id;
    3478. 

  3478.                 $url.="&amp;m=id";
    3479. 

  3479.             }
    3480. 

  3480.             $url = COM_buildUrl( $url );
    3481. 

  3481.             $link= COM_createLink($title, $url);
    3482. 

  3482. 

  3483.             $templates->set_var ('data_link', $link);
    3484. 

  3484.             $templates->set_var ('data_title', $title);
    3485. 

  3485.             $templates->set_var ('data_code', $code);
    3486. 

  3486.             $templates->set_var ('data_description', $description);
    3487. 

  3487.             $templates->set_var ('data_id', $id);
    3488. 

  3488.             $templates->set_var ('data_url', $url);
    3489. 

  3489. 

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

  3491.             $templates->set_var ('data_value', $value);
    3492. 

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

  3493.             $templates->set_var ('data_datefield_date', strftime( $_CONF['date'], $A['datefield_un'] ));
    3494. 

  3494.             $templates->set_var ('data_datefield_daytime', strftime( $_CONF['daytime'], $A['datefield_un'] ));
    3495. 

  3495.             $templates->set_var ('data_datefield_dateonly', strftime( $_CONF['dateonly'], $A['datefield_un'] ));
    3496. 

  3496.             $templates->set_var ('data_datefield_timeonly', strftime( $_CONF['timeonly'], $A['datefield_un'] ));
    3497. 

  3497.             $templates->set_var ('data_datefield_b', strftime( "%b" , $A['datefield_un']));
    3498. 

  3498.             $templates->set_var ('data_datefield_B', strftime( "%B" , $A['datefield_un']));
    3499. 

  3499.             $templates->set_var ('data_datefield_d', strftime( "%d" , $A['datefield_un']));
    3500. 

  3500.             $templates->set_var ('data_datefield_e', strftime( "%e" , $A['datefield_un']));
    3501. 

  3501.             
    3502. 

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

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

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

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

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

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

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

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

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

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

  3512.             //公開終了日 Expired to publish
    3513. 

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

  3514.                 $templates->set_var ('data_expired', "");
    3515. 

  3515.                 $templates->set_var ('data_expired_shortdate', "" );
    3516. 

  3516.                 $templates->set_var ('data_expired_date', "" );
    3517. 

  3517.                 $templates->set_var ('data_expired_daytime', "" );
    3518. 

  3518.                 $templates->set_var ('data_expired_dateonly', "" );
    3519. 

  3519.                 $templates->set_var ('data_expired_timeonly', "" );
    3520. 

  3520.                 $templates->set_var ('data_expired_b', "" );
    3521. 

  3521.                 $templates->set_var ('data_expired_B', "" );
    3522. 

  3522.                 $templates->set_var ('data_expired_d', "" );
    3523. 

  3523.                 $templates->set_var ('data_expired_e', "" );
    3524. 

  3524.             }else{
    3525. 

  3525.                 $wary = COM_getUserDateTimeFormat($A['expired_un']);
    3526. 

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

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

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

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

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

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

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

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

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

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

  3536.             }
    3537. 

  3537.             $remaingdays="";
    3538. 

  3538.             if ($expired<>"0000-00-00 00:00:00") {
    3539. 

  3539.                 if  ($expired_ary[1]>=$curdate_ary[1]){
    3540. 

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

  3541.                 }
    3542. 

  3542.             }
    3543. 

  3543.             $templates->set_var ('data_remaingdays', $remaingdays);//@@@@@@
    3544. 

  3544.             if (date("Ymd",strtotime($datefield)) >= date("Ymd",$chkday)){
    3545. 

  3545.                 $templates->set_var ('new_img', $new_img);
    3546. 

  3546.             }else{
    3547. 

  3547.                 $templates->set_var ('new_img', '');
    3548. 

  3548.             }
    3549. 

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

  3550.             $templates->set_var('lang_hits', $LANG_DATABOX_ADMIN['hits']);
    3551. 

  3551.             $templates->set_var('data_hits', $hits);
    3552. 

  3552.             
    3553. 

  3553.             //カテゴリ@@@@@
    3554. 

  3554.             $templates->set_var('lang_category', $LANG_DATABOX_ADMIN['category']);
    3555. 

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

  3556. 

  3557.             //追加項目
    3558. 

  3558.             $chk_user=DATABOX_chkuser($group_id,$owner_id,"databox.admin");
    3559. 

  3559.             $additionfields = DATABOX_getadditiondatas($id,$pi_name);
    3560. 

  3560.             DATABOX_getaddtionfieldsDisp($additionfields,$addition_def,$templates,$chk_user,$pi_name,$fieldset_id);
    3561. 

  3561.             
    3562. 

  3562.             //管理者の時「編集」
    3563. 

  3563.             if ( SEC_hasRights('databox.admin')) {
    3564. 

  3564.                 $icon_url = $_CONF['layout_url'] . '/images/edit.' . $_IMAGE_TYPE;
    3565. 

  3565.                 $attr = array('title' => $title." ".$LANG_DATABOX_ADMIN['edit']);
    3566. 

  3566.                 $editiconhtml = COM_createImage($icon_url, $LANG_DATABOX_ADMIN['edit'], $attr);
    3567. 

  3567.                 
    3568. 

  3568.                 $attr = array('class' => 'editlink', 'title' => $title." ".$LANG_DATABOX_ADMIN['edit']);
    3569. 

  3569.                 $url = $_CONF['site_admin_url'];
    3570. 

  3570.                 $url .= '/plugins/databox/data.php';
    3571. 

  3571.                 $url .= '?mode=edit';
    3572. 

  3572.                 $url .= '&amp;'."id={$id}";
    3573. 

  3573.                 $icon = '&nbsp;' ;
    3574. 

  3574.                 $icon .=  COM_createLink( $editiconhtml,  $url,   $attr   );
    3575. 

  3575.                 $templates->set_var ('data_edit', $icon);
    3576. 

  3576.             }else{
    3577. 

  3577.                 $rt=databox_chk_loaddata($id);
    3578. 

  3578.                 //編集権限のあるMyData
    3579. 

  3579.                 if ( $rt==="OK") {
    3580. 

  3580.                     $icon_url = $_CONF['layout_url'] . '/images/edit.' . $_IMAGE_TYPE;
    3581. 

  3581.                     $attr = array('title' => $LANG_DATABOX_ADMIN['edit']);
    3582. 

  3582.                     $editiconhtml = COM_createImage($icon_url, $LANG_DATABOX_ADMIN['edit'], $attr);
    3583. 

  3583. 

  3584.                     $attr = array('class' => 'editlink', 'title' => $title." ".$LANG_DATABOX_ADMIN['edit']);
    3585. 

  3585. 

  3586.                     $url = $_CONF['site_url'];
    3587. 

  3587.                     $url .= '/databox/mydata/data.php';
    3588. 

  3588.                     $url .= '?mode=edit';
    3589. 

  3589.                     $url .= '&amp;'."id={$id}";
    3590. 

  3590. 

  3591.                     $icon = '&nbsp;' ;
    3592. 

  3592.                     $icon .=  COM_createLink( $editiconhtml,  $url,   $attr   );
    3593. 

  3593. 

  3594.                     $templates->set_var ('data_edit', $icon);
    3595. 

  3595.                 }else{
    3596. 

  3596.                     $templates->set_var ('data_edit', "");
    3597. 

  3597.                 }
    3598. 

  3598.              }
    3599. 

  3599.              //maps plugin link
    3600. 

  3600.              $mkid="";
    3601. 

  3601.              if (in_array("maps", $_PLUGINS)){
    3602. 

  3602.                  if ($code<>""){
    3603. 

  3603.                      $mkid=DB_getItem($_TABLES['maps_markers'],"mkid","item_10='$code'");
    3604. 

  3604.                      if  ($mkid<>""){
    3605. 

  3605.                          $mkids.=$mkid." ";
    3606. 

  3606.                      }
    3607. 

  3607.                  }
    3608. 

  3608.              }
    3609. 

  3609. 

  3610.             //=====
    3611. 

  3611.             $templates->parse ('col_var', 'col', true);
    3612. 

  3612.             $templates->parse ('row_var', 'row', true);
    3613. 

  3613. 

  3614.             $templates->set_var ('col_var', '');
    3615. 

  3615. 

  3616.         }
    3617. 

  3617.         $mkids=rtrim($mkids," ");
    3618. 

  3618.         $mkidary=array();
    3619. 

  3619.         $mkid_ary=split(" " , $mkids);
    3620. 

  3620.         $selectedMarkers="";
    3621. 

  3621.         if (function_exists("MAPS_selectedMarkers") AND $mkids<>"") {
    3622. 

  3622.             $selectedMarkers=MAPS_selectedMarkers(
    3623. 

  3623.               $_MAPS_CONF['map_width']
    3624. 

  3624.              ,$_MAPS_CONF['map_height']
    3625. 

  3625.              ,$_MAPS_CONF['map_zoom']
    3626. 

  3626.              ,$mkid_ary);
    3627. 

  3627.         }
    3628. 

  3628.         $templates->set_var ('mkids', $mkids);
    3629. 

  3629.         $templates->set_var ('selectedMarkers', $selectedMarkers);
    3630. 

  3630. 

  3631.         // Call to plugins to set template variables in the databox
    3632. 

  3632.         PLG_templateSetVars( 'databox', $templates );
    3633. 

  3633. 

  3634.         //------------
    3635. 

  3635.         //-----navigation
    3636. 

  3636.         $url = $_CONF['site_url']  . '/';
    3637. 

  3637.         $url.=THIS_SCRIPT;
    3638. 

  3638.         $url.="?";
    3639. 

  3639.         $url.=$arg_sv;
    3640. 

  3640.         $url .= "&amp;order=";
    3641. 

  3641.         //-----order navigation
    3642. 

  3642.         $dummy=databox_order ($url, $templates, $argary['order']) ;
    3643. 

  3643.         //-----page navigation
    3644. 

  3644.         $url .= $argary['order'];
    3645. 

  3645.         $templates->set_var ('page_navigation',
    3646. 

  3646.         COM_printPageNavigation ($url,$argary['page'], $pages));
    3647. 

  3647.         $templates->set_var ( 'pagenavinone', '' );
    3648. 

  3648.         //------------
    3649. 

  3649.         $templates->parse ('arg_var', 'arg', true);
    3650. 

  3650.         $templates->parse ('nav_var', 'nav', true);
    3651. 

  3651. 

  3652.         $templates->set_var ('msg', "");
    3653. 

  3653. 

  3654.         $templates->parse ('output', 'list');
    3655. 

  3655. 

  3656.         $content = $templates->finish ($templates->get_var ('output'));
    3657. 

  3657. 

  3658.     }else{
    3659. 

  3659.         if ($argary['nohitmsg']==="yes"){
    3660. 

  3660.             $tmplfld=DATABOX_templatePath('search',$argary['templatedir'],$pi_name);
    3661. 

  3661.             $templates = new Template($tmplfld);
    3662. 

  3662.             $templates->set_file (array (
    3663. 

  3663.                 'list' => 'nohit.thtml',
    3664. 

  3664.                 'arg'   => 'argument.thtml',
    3665. 

  3665.             ));
    3666. 

  3666. 

  3667.             $dummy=databox_searchargedit($argary,$templates);
    3668. 

  3668.             
    3669. 

  3669.             $templates->set_var ('home',$LANG_DATABOX['home']);
    3670. 

  3670.             $referer =$_SERVER['HTTP_REFERER'];
    3671. 

  3671.             $templates->set_var ('referer', $referer);
    3672. 

  3672.             $templates->set_var ('lang_referer',$LANG_DATABOX['return']);
    3673. 

  3673.             $templates->set_var ('fieldset_name',$fieldset_name);
    3674. 

  3674.                         
    3675. 

  3675.             $templates->set_var('xhtml', XHTML);
    3676. 

  3676.             $templates->set_var('site_url', $_CONF['site_url']);
    3677. 

  3677.             $templates->set_var('site_admin_url', $_CONF['site_admin_url']);
    3678. 

  3678.             $templates->set_var('layout_url', $_CONF['layout_url']);
    3679. 

  3679.             
    3680. 

  3680.             $templates->set_var ('lang_nohit', $LANG_DATABOX['nohit']);
    3681. 

  3681. 

  3682.             $templates->parse ('arg_var', 'arg', true);
    3683. 

  3683.             
    3684. 

  3684.             $templates->parse ('output', 'list');
    3685. 

  3685.             $content = $templates->finish ($templates->get_var ('output'));
    3686. 

  3686.         }
    3687. 

  3687.     }
    3688. 

  3688. 

  3689.     if ($autotag==="notautotag"){
    3690. 

  3690. 

  3691.         $retval["pagetitle"] =$pagetitle;
    3692. 

  3692.         $retval["headercode"] =$headercode;
    3693. 

  3693.         $retval["display"] =PLG_replacetags ($content);
    3694. 

  3694.     }else{
    3695. 

  3695.         $retval=PLG_replacetags ($content);
    3696. 

  3696.     }
    3697. 

  3697.     return $retval;
    3698. 

  3698. } 
    3699. 

  3699. 

  3700. 

  3701. function databox_searcharg(
    3702. 

  3702.     $autotag
    3703. 

  3703.     ,$arg
    3704. 

  3704. )
    3705. 

  3705. // +---------------------------------------------------------------------------+
    3706. 

  3706. // | 機能  検索リスト
    3707. 

  3707. // | 書式  databox_searcharg($autotag,$arg);
    3708. 

  3708. // +---------------------------------------------------------------------------+
    3709. 

  3709. // | 引数 $autotag :notautotag 自動タグでない 
    3710. 

  3710. // | 引数 $arg  :
    3711. 

  3711. // +---------------------------------------------------------------------------+
    3712. 

  3712. // | 戻値 $argary:検索引数配列
    3713. 

  3713. // +---------------------------------------------------------------------------+
    3714. 

  3714. {
    3715. 

  3715.     if ($autotag==="notautotag"){
    3716. 

  3716.         foreach((array)$arg as $key => $value){
    3717. 

  3717.             $key=COM_applyFilter($key);
    3718. 

  3718.             if  ($key<>""){
    3719. 

  3719.                 if  (is_array($value)  ) {
    3720. 

  3720.                     foreach($value as $key2 => $value2){
    3721. 

  3721.                         $argary[$key][]=Ltrim(COM_applyFilter($value2,true),0);
    3722. 

  3722.                     }
    3723. 

  3723.                 }else{
    3724. 

  3724.                     if  ($key=="fieldset") {
    3725. 

  3725.                         $argary['fieldset']=COM_applyFilter($value,true);
    3726. 

  3726.                         $argary['fieldset_id']=COM_applyFilter($value,true);
    3727. 

  3727.                     }else if  ($key=="page"  OR  $key=="perpage") {
    3728. 

  3728.                         $argary[$key]=COM_applyFilter($value,true);
    3729. 

  3729.                     }else {
    3730. 

  3730.                         $argary[$key]=COM_applyFilter($value);
    3731. 

  3731.                     }
    3732. 

  3732.                 }
    3733. 

  3733.             }
    3734. 

  3734.         }
    3735. 

  3735.     }else{
    3736. 

  3736.         $ary = explode ('&', $arg);
    3737. 

  3737.         $argary = array();
    3738. 

  3738.         foreach($ary as $key => $value){
    3739. 

  3739.             $k = explode ('=', $value);
    3740. 

  3740.             $k0= COM_applyFilter($k[0]);
    3741. 

  3741.             //$k1= COM_applyFilter($k[1]);
    3742. 

  3742.             if  ($k0<>""){
    3743. 

  3743.                 if  ($k0=="fieldset") {
    3744. 

  3744.                     $argary['fieldset']=COM_applyFilter($k[1],true);
    3745. 

  3745.                     $argary['fieldset_id']=COM_applyFilter($k[1],true);
    3746. 

  3746.                 }else if  ($k0=="page"  OR  $k0=="perpage") {
    3747. 

  3747.                     $argary[$k0]=COM_applyFilter($k[1],true);
    3748. 

  3748.                 }else if  ( substr($k0,0,3)=="gor" OR substr($k0,0,4)=="gand" OR substr($k0,0,3)=="ams" ) {
    3749. 

  3749.                     $argary[$k0][]=ltrim(COM_applyFilter($k[1],true),0);
    3750. 

  3750.                 }else {
    3751. 

  3751.                     $argary[$k0]=COM_applyFilter($k[1]);
    3752. 

  3752.                 }
    3753. 

  3753.             }
    3754. 

  3754.         }
    3755. 

  3755.     }
    3756. 

  3756. 

  3757.     return $argary;
    3758. 

  3758. }
    3759. 

  3759. 

  3760. 

  3761. function databox_searchfield(
    3762. 

  3762.     $operate
    3763. 

  3763.     ,$field_id
    3764. 

  3764.     ,$value
    3765. 

  3765.     ,&$acnt
    3766. 

  3766.     ,&$afield
    3767. 

  3767.     ,&$afile
    3768. 

  3768.     ,&$awhere
    3769. 

  3769. 

  3770. )
    3771. 

  3771. // +---------------------------------------------------------------------------+
    3772. 

  3772. // | 機能  追加項目の条件 を編集
    3773. 

  3773. // | 書式  databox_searchfield($operate,$field_id,$value,$acnt,$afield,$afile,$awhere);
    3774. 

  3774. // +---------------------------------------------------------------------------+
    3775. 

  3775. // | 引数 $operate
    3776. 

  3776. // | 引数 $field_id
    3777. 

  3777. // | 引数戻値 $acnt
    3778. 

  3778. // | 引数戻値 $afield
    3779. 

  3779. // | 引数戻値 $afile
    3780. 

  3780. // | 引数戻値 $awhire
    3781. 

  3781. // +---------------------------------------------------------------------------+
    3782. 

  3782. 

  3783. {
    3784. 

  3784.     global $_TABLES;
    3785. 

  3785.           
    3786. 

  3786.     $return=false;
    3787. 

  3787.           
    3788. 

  3788.     $sql="SELECT ";
    3789. 

  3789.     $sql.= " field_id ";
    3790. 

  3790.     $sql.= ",name ";
    3791. 

  3791.     $sql.= ",type ";
    3792. 

  3792.     $sql.=" FROM";
    3793. 

  3793.     $sql.=" {$_TABLES['DATABOX_def_field']} ";
    3794. 

  3794.     $sql.=" WHERE field_id=".$field_id;
    3795. 

  3795.     // 表示する項目のみ
    3796. 

  3796.     $sql.=" AND allow_display='0'";
    3797. 

  3797.     if  ($operate=="ams"){
    3798. 

  3798.         //9:オプションリスト（マスター）
    3799. 

  3799.         //16:ラジオボタンリスト（マスター）
    3800. 

  3800.         //18:マルチセレクトリスト（マスター）
    3801. 

  3801.         $sql.=" AND type IN (9,16,18)";
    3802. 

  3802.     }else{
    3803. 

  3803.         //0: 一行テキストフィールド
    3804. 

  3804.         //1: 複数行テキストフィールド
    3805. 

  3805.         //20:HTML  10:TinyMCE 19:CKEditor
    3806. 

  3806.         //15:数値  21:通貨
    3807. 

  3807.         $sql.=" AND type IN (0,1,10,19,20,15,21)";
    3808. 

  3808.     }
    3809. 

  3809.           
    3810. 

  3810.     $result = DB_query ($sql);
    3811. 

  3811.     $numrows = DB_numRows ($result);
    3812. 

  3812.     if ($numrows>0){
    3813. 

  3813.        $A = DB_fetchArray ($result);
    3814. 

  3814.        $acnt=$acnt+1;
    3815. 

  3815.        $afield[$acnt]=" ,a".$acnt.".value AS value".$acnt;
    3816. 

  3816.        $afile[$acnt]=" ,{$_TABLES['DATABOX_addition']} AS a".$acnt;
    3817. 

  3817.        $w="a".$acnt.".field_id=".$field_id;
    3818. 

  3818.        $w.=" AND a".$acnt.".id=t2.id";
    3819. 

  3819.        if  ($operate=="aeq"){
    3820. 

  3820.            $w.=" AND a".$acnt.".value='".$value."'";
    3821. 

  3821.        }else if ($operate=="a"){
    3822. 

  3822.             $w.=" AND a".$acnt.".value LIKE '%".$value."%'";
    3823. 

  3823.        }else if ($operate=="afr"){
    3824. 

  3824.            if  ($A['type']==15  OR $A['type']==21){
    3825. 

  3825.                 $w.=" AND (a".$acnt.".value + 0) >='".$value."'";
    3826. 

  3826.            }else{
    3827. 

  3827.                 $w.=" AND a".$acnt.".value>='".$value."'";
    3828. 

  3828.            }
    3829. 

  3829.        }else if ($operate=="ato"){
    3830. 

  3830.            if  ($A['type']==15  OR $A['type']==21){
    3831. 

  3831.                $w.=" AND (a".$acnt.".value + 0) <='".$value."'";
    3832. 

  3832.            }else{
    3833. 

  3833.                $w.=" AND a".$acnt.".value<='".$value."'";
    3834. 

  3834.            }
    3835. 

  3835.        }else if ($operate=="ams"){
    3836. 

  3836.             $w.=" AND a".$acnt.".value  IN  ({$value})";
    3837. 

  3837.        }
    3838. 

  3838.        $awhere[$acnt]=$w;
    3839. 

  3839.        $return=true;
    3840. 

  3840.     }
    3841. 

  3841. 

  3842.     return ;
    3843. 

  3843. 

  3844. }
    3845. 

  3845. function databox_searchargedit(
    3846. 

  3846.     $arg
    3847. 

  3847.     ,&$templates
    3848. 

  3848. )
    3849. 

  3849. {
    3850. 

  3850.     global $LANG_DATABOX;
    3851. 

  3851.     global $_CONF;
    3852. 

  3852.     global $_TABLES;
    3853. 

  3853.     
    3854. 

  3854.     $rt="";
    3855. 

  3855.     $templates->set_var ('site_url',$_CONF['site_url']);
    3856. 

  3856.     $templates->set_var ('this_script',THIS_SCRIPT);
    3857. 

  3857.     $templates->set_var ("lang_search",$LANG_DATABOX['search']);
    3858. 

  3858.     foreach((array)$arg as $key => $value) {
    3859. 

  3859.         if (is_array($value)){
    3860. 

  3860.             $k = explode ('_', $key);
    3861. 

  3861.             $ary=$value;
    3862. 

  3862.             if  ($k[0]=="gor"  OR  $k[0]=="gand"){
    3863. 

  3863.                 $wnames="";
    3864. 

  3864.                 foreach($ary as $key2 => $value2){
    3865. 

  3865.                     $key2p1=$key2+1;
    3866. 

  3866.                     $w= COM_applyFilter($value2);
    3867. 

  3867.                     $ary[$key2]=$w;
    3868. 

  3868.                     $templates->set_var ($key."_".$key2p1."_id",$w);
    3869. 

  3869.                     if  ($w<>""){
    3870. 

  3870.                         $wname=COM_applyFilter(
    3871. 

  3871.                         DB_getItem($_TABLES['DATABOX_def_category'] 
    3872. 

  3872.                             ,"name","category_id={$w}"));
    3873. 

  3873.                             $wnames.=$wname." ";
    3874. 

  3874.                     }else{
    3875. 

  3875.                         $wname="";
    3876. 

  3876.                     }
    3877. 

  3877.                     $templates->set_var ($key."_".$key2p1."_name",$wname);
    3878. 

  3878.                 }
    3879. 

  3879.                 $checklist=DATABOX_getcheckList ("categorygroup",$ary,"databox",$k[1],$key);
    3880. 

  3880.                 $templates->set_var ($key,$checklist);
    3881. 

  3881.                 $templates->set_var ($key."_names",$wnames);
    3882. 

  3882.             }else if  ($k[0]=="ams" ){
    3883. 

  3883.                 $kind=COM_applyFilter(
    3884. 

  3884.                 DB_getItem($_TABLES['DATABOX_def_field'] 
    3885. 

  3885.                      ,"selectlist","field_id={$k[1]}"));
    3886. 

  3886.                 $wnames="";
    3887. 

  3887.                 foreach($ary as $key2 => $value2){
    3888. 

  3888.                     $key2p1=$key2+1;
    3889. 

  3889.                     $w= COM_applyFilter($value2);
    3890. 

  3890.                     $ary[$key2]=$w;
    3891. 

  3891.                     $templates->set_var ($key."_".$key2p1."_no",$w);
    3892. 

  3892.                     if  ($w<>""){
    3893. 

  3893.                          $wname=COM_applyFilter(
    3894. 

  3894.                          DB_getItem($_TABLES['DATABOX_mst'] 
    3895. 

  3895.                              ,"value","kind='{$kind}' AND no={$w}"));
    3896. 

  3896.                                                             $wnames.=$wname." ";
    3897. 

  3897.                      }else{
    3898. 

  3898.                          $wname="";
    3899. 

  3899.                      }
    3900. 

  3900.                      $templates->set_var ($key."_".$key2p1."_name",$wname);
    3901. 

  3901.                 }
    3902. 

  3902.                 $checklist=DATABOX_getcheckList ($kind,$ary,"databox",$k[1],$key);
    3903. 

  3903.                 $templates->set_var ($key,$checklist);
    3904. 

  3904.                 $templates->set_var ($key."_names",$wnames);
    3905. 

  3905.             }
    3906. 

  3906.         }else if ($value<>""){
    3907. 

  3907.             $w=COM_applyFilter($value);
    3908. 

  3908.             $templates->set_var ($key,$w);
    3909. 

  3909.         }
    3910. 

  3910.     }
    3911. 

  3911. 

  3912.     return ;
    3913. 

  3913. }
    3914. 

  3914. 

  3915. ?>
    3916. 

  3916.