Source for file interface.php

Documentation is available at interface.php

  1. <?
  2. /**
  3. * interface.php
  4. *
  5. * This program is free software; you can redistribute it and/or modify
  6. * it under the terms of the GNU General Public License as published by
  7. * the Free Software Foundation; either version 2 of the License, or
  8. * (at your option) any later version.
  9. * This program is distributed in the hope that it will be useful,
  10. * but WITHOUT ANY WARRANTY; without even the implied warranty of
  11. * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  12. * GNU General Public License for more details.
  13. * @author Stephan Raabe
  14. */
  15.  
  16.  
  17. function getSitemapTable($homekey,$key,$level,$val)
  18. {
  19. global $output;
  20. $page_sitemap = get_page_key($key);
  21. if ($level == 0)
  22. {
  23. ?>
  24. <option value="<?= $page_sitemap["page_path"]; ?>" <? if ($val == $page_sitemap["page_path"]) { ?>selected<? } ?>><?= strip_tags($page_sitemap["page_headline"]); ?></option>
  25. <?
  26. }
  27. else
  28. {
  29. $line = "";
  30. for ($i = 1; $i <= $level; $i++)
  31. {
  32. $line .= "-";
  33. }
  34. $line .= " ";
  35. ?>
  36. <option value="<?= $page_sitemap["page_path"]; ?>" <? if ($val == $page_sitemap["page_path"]) { ?>selected<? } ?>><?= $line.strip_tags($page_sitemap["page_headline"]); ?></option>
  37. <?
  38. }
  39. $level++;
  40. $subpages = get_subpages_key($key);
  41. while ($row = mysql_fetch_array($subpages))
  42. {
  43. getSitemapTable($homekey,$row["page_key"],$level,$val);
  44. }
  45. }
  46.  
  47. /**
  48. * Writes a Table Interface
  49. */
  50. function writeTable($addhidden = "",$edit = "",$search="")
  51. {
  52. global $db_praefix;
  53. global $page;
  54. global $admin_lang;
  55. global $lang_list;
  56. global $table;
  57. global $query;
  58. global $fieldlist;
  59. global $locklist;
  60. global $requiredlist;
  61. global $widthlist;
  62. global $namelist;
  63. global $tablekey;
  64. global $information;
  65. $copy = "";
  66. $add = "";
  67. $info = "";
  68. $del = "";
  69. $test = "";
  70. $send = "";
  71. $export = "";
  72. $exportview = "";
  73. $stepsize = 20;
  74. if ($table == "template")
  75. {
  76. $info = "templates/use";
  77. }
  78. if (($table == "page") && ($fieldlist == "page_title,page_path"))
  79. {
  80. $del = "no";
  81. $add = "no";
  82. $edit = "no";
  83. }
  84. if (($table == "statistic") || ($table == "group"))
  85. {
  86. $add = "no";
  87. $del = "no";
  88. }
  89. if ($table == "newsletter")
  90. {
  91. $copy = "yes";
  92. $test = "yes";
  93. $send = "yes";
  94. }
  95. if (($table == "page") && ($locklist == ""))
  96. {
  97. $add = "no";
  98. $edit = "no";
  99. $del = "no";
  100. }
  101. if (($table == "page") && ($locklist != "") && ($fieldlist != "page_title,page_path"))
  102. {
  103. $add = "no";
  104. $export = "yes";
  105. $exportview = "yes";
  106. }
  107. if (($table == "page") && ($requiredlist == "page_exportfolder"))
  108. {
  109. $del = "no";
  110. }
  111. $namelist_arr = explode(",",$namelist);
  112. $fieldlist_arr = explode(",",$fieldlist);
  113. $widthlist_arr = explode(",",$widthlist);
  114.  
  115. $link = connectDB();
  116. $result = mysql_query($query);
  117. $anzahl_all = mysql_num_rows($result);
  118. if ((isset($_POST["action"])) && ($_POST["action"] == "searchitem"))
  119. {
  120. global $querysearch;
  121. $searchresult = mysql_query($querysearch);
  122. $counter = 0;
  123. if (mysql_num_rows($searchresult) > 0)
  124. {
  125. $anzahl = mysql_num_rows($searchresult);
  126. while ($row = mysql_fetch_array($searchresult))
  127. {
  128. $search_arr[$counter] = $row[$tablekey];
  129. $counter++;
  130. }
  131. }
  132. else
  133. {
  134. $anzahl = 0;
  135. }
  136. }
  137. closeDB($link);
  138. $step = 1;
  139. $stepcounter = 1;
  140. if (isset($_GET["step"]))
  141. {
  142. $step = $_GET["step"];
  143. }
  144. ?>
  145. <!-- openEngine Tooltip START -->
  146. <script type="text/javascript" src="system/admin/script/overlib414/overlib.js"><!-- overLIB (c) Erik Bosrup --></script>
  147. <div id="overDiv" style="position:absolute; visibility:hidden; z-index:1005;"></div>
  148. <!-- openEngine Tooltip END -->
  149.  
  150. <!-- Tab Script START -->
  151. <script language="javascript" src="system/admin/script/oe_tab.js"></script>
  152. <!-- Tab Script END -->
  153.  
  154. <script language="javascript">
  155. function del<?= $table; ?>Item(key)
  156. {
  157. if (confirm("<?= $admin_lang["table"][17]; ?>"))
  158. {
  159. document.del<?= $table; ?>Form.delkey.value = key;
  160. document.del<?= $table; ?>Form.submit();
  161. }
  162. }
  163.  
  164. function openGroupOrder(path)
  165. {
  166. groups = window.open("website.php?id=" + path + "&admin=group/order","order","width=400,height=600,scrollbars=yes");
  167. groups.focus();
  168. }
  169.  
  170. function confirmSend(path,key,target)
  171. {
  172. if (confirm("<?= $admin_lang["newsletter"][21]; ?>"))
  173. {
  174. window.open("website.php?id=" + path + "&admin=newsletter/send&action=sendnewsletter&step=1&nl_key=" + key,"sendnewsletter","width=300,height=200");
  175. }
  176. }
  177.  
  178. function startExport(path,key)
  179. {
  180. if (confirm("<?= $admin_lang["exporting"][2]; ?>"))
  181. {
  182. window.open("website.php?id=" + path + "&admin=exporting/export&folderdel=0&action=export_page&step=1&key=" + key,"exportpage","width=300,height=200");
  183. }
  184. }
  185.  
  186. function startExportEmpty(path,key)
  187. {
  188. if (confirm("<?= $admin_lang["exporting"][2]; ?>"))
  189. {
  190. window.open("website.php?id=" + path + "&admin=exporting/export&folderdel=1&action=export_page&step=1&key=" + key,"exportpage","width=300,height=200");
  191. }
  192. }
  193.  
  194. function copyNewsletter(nl_key)
  195. {
  196. if (confirm("<?= $admin_lang["newsletter"][31]; ?>"))
  197. {
  198. location.href="website.php?id=<?= $page["page_path"]; ?>&admin=newsletter&action=copynewsletter&nl_key=" + nl_key;
  199. }
  200. }
  201.  
  202. function oeunlocknewsletter(path)
  203. {
  204. if (confirm("<?= $admin_lang["newsletter"][37]; ?>"))
  205. {
  206. location.href = "website.php?id=" + path + "&admin=newsletter&action=unlocknewsletter";
  207. }
  208. }
  209. </script>
  210. <ul id="tablist">
  211. <li><a href="#" onClick="return expandcontent('sc1', this)" theme="#D7E5FF"><?= $admin_lang["table"][1]; ?></a></li>
  212. <li><a href="#" onClick="return expandcontent('sc2', this)" theme="#D7E5FF">Information</a></li>
  213. <? if ($search != "") { ?>
  214. <li><a href="#" onClick="return expandcontent('sc3', this)" theme="#D7E5FF"><?= $admin_lang["table"][25]; ?></a></li>
  215. <? } ?>
  216. </ul>
  217.  
  218. <div id="tabcontentcontainer">
  219.  
  220. <div id="sc1" class="tabcontent">
  221. <? if ((isset($_POST["action"])) && ($_POST["action"] == "searchitem")) { ?>
  222. <p class="adminText"><?= $admin_lang["table"][26]; ?> (<?= $anzahl; ?> <?= $admin_lang["table"][27]; ?>):</p>
  223. <? } ?>
  224. <div class="oeedittable">
  225. <form method="post" name="del<?= $table; ?>Form">
  226. <input type="hidden" name="action" value="delTableItem">
  227. <input type="hidden" name="table" value="<?= $table; ?>">
  228. <input type="hidden" name="tablekey" value="<?= $tablekey; ?>">
  229. <input type="hidden" name="step" value="<?= $step; ?>">
  230. <input type="hidden" name="delkey">
  231. </form>
  232. <table border="0" cellpadding="0" cellspacing="0" width="95%">
  233.  
  234. <thead>
  235. <tr>
  236. <? if ($edit != "no") { ?>
  237. <td width="1%">
  238. <? if ($add != "no") { ?>
  239. <a href="website.php?id=<?= $page["page_path"]; ?>&admin=<?= $_GET["admin"]; ?>&action=show<?= $table; ?>Item" onmouseover="return overlib('<?= $admin_lang["table"][2]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_add.png"></a>
  240. <? } else { ?>
  241. <img src="system/admin/img/blank.gif" width="16" height="16">
  242. <? } ?>
  243. </td>
  244. <? } ?>
  245. <? if ($info != "") { ?><td width="1%">&nbsp;</td><? } ?>
  246. <?
  247. $counter = 0;
  248. foreach($namelist_arr as $value)
  249. {
  250. $pos = strpos ($requiredlist, $fieldlist_arr[$counter]);
  251. if ($pos === false)
  252. {
  253. $required = "";
  254. }
  255. else
  256. {
  257. $required = "*";
  258. }
  259. ?>
  260. <td width="<?= $widthlist_arr[$counter]; ?>"><?= $value.$required; ?></td>
  261. <?
  262. $counter++;
  263. }
  264. ?>
  265. <? if ($exportview != "") { ?><td width="1%">&nbsp;</td><? } ?>
  266. <? if ($export != "") { ?><td width="1%">&nbsp;</td><td width="1%">&nbsp;</td><? } ?>
  267. <? if ($copy != "") { ?><td width="1%">&nbsp;</td><? } ?>
  268. <? if ($test != "") { ?><td width="1%">&nbsp;</td><? } ?>
  269. <? if ($send != "") { ?><td width="1%">&nbsp;</td><? } ?>
  270. <td width="1%"><img src="system/admin/img/blank.gif" width="16" height="16"></td>
  271. </tr>
  272. </thead>
  273.  
  274. <tbody>
  275. <? if ((isset($_GET["action"])) && ($_GET["action"] == "show".$table."Item")) { ?>
  276.  
  277. <? if ($requiredlist != "") { ?>
  278. <!-- Requiredlist START -->
  279. <script language="javascript" type="text/javascript">
  280. <? echo writeRequire("add".$table."Form", explode(",",$requiredlist)); ?>
  281. </script>
  282. <!-- Requiredlist END -->
  283. <? } ?>
  284.  
  285. <!-- Add Item START -->
  286. <form method="post" name="add<?= $table; ?>Form">
  287. <input type="hidden" name="action" value="addTableItem">
  288. <input type="hidden" name="table" value="<?= $table; ?>">
  289. <input type="hidden" name="tablekey" value="<?= $tablekey; ?>">
  290. <input type="hidden" name="fieldlist" value="<?= $fieldlist; ?>">
  291. <input type="hidden" name="addhidden" value="<?= $addhidden; ?>">
  292. <tr valign="top">
  293. <td><a href="Javascript:checkInput();" onmouseover="return overlib('<?= $admin_lang["table"][3]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_ok.png"></a></td>
  294. <? if ($info != "") { ?><td width="1%">&nbsp;</td><? } ?>
  295. <? foreach($fieldlist_arr as $value)
  296. {
  297. $pos = strpos ($locklist, $value);
  298. if ($pos === false)
  299. {
  300. if ($value == "task_description")
  301. {
  302. ?>
  303. <td><textarea name="<?= $value; ?>"></textarea></td>
  304. <?
  305. }
  306. elseif ($value == "task_page")
  307. {
  308. ?>
  309. <td>
  310. <select name="<?= $value; ?>">
  311. <option value=""><?= $admin_lang["table"][28]; ?></option>
  312. <?
  313. $homepages = get_homepages();
  314. while ($item = mysql_fetch_array($homepages))
  315. {
  316. getSitemapTable("home".$item["page_key"],$item["page_key"],0,"");
  317. }
  318. ?>
  319. </select>
  320. </td>
  321. <?
  322. }
  323. else
  324. {
  325. ?>
  326. <td><input type="text" name="<?= $value; ?>"></td>
  327. <?
  328. }
  329. }
  330. else
  331. {
  332. ?>
  333. <td>&nbsp;</td>
  334. <?
  335. }
  336. }
  337. ?>
  338. <? if ($exportview != "") { ?><td width="1%">&nbsp;</td><? } ?>
  339. <? if ($export != "") { ?><td width="1%">&nbsp;</td><td width="1%">&nbsp;</td><? } ?>
  340. <? if ($copy != "") { ?><td width="1%">&nbsp;</td><? } ?>
  341. <? if ($test != "") { ?><td width="1%">&nbsp;</td><? } ?>
  342. <? if ($send != "") { ?><td width="1%">&nbsp;</td><? } ?>
  343. <td><a href="website.php?id=<?= $page["page_path"]; ?>&admin=<?= $_GET["admin"]; ?>" onmouseover="return overlib('<?= $admin_lang["table"][4]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_cancel.png"></a></td>
  344. </tr>
  345. </form>
  346. <!-- Add Item END -->
  347. <? } ?>
  348.  
  349. <?
  350. while ($row = mysql_fetch_array($result))
  351. {
  352. if ((isset($_POST["action"])) && ($_POST["action"] == "searchitem"))
  353. {
  354. if (isset($search_arr))
  355. {
  356. $isresult = false;
  357. foreach ($search_arr as $value)
  358. {
  359. if ($value == $row[$tablekey])
  360. {
  361. $isresult = true;
  362. }
  363. }
  364. if ($isresult)
  365. {
  366. $step = ceil($stepcounter / $stepsize);
  367. ?>
  368. <tr>
  369. <? if ($edit != "no") { ?><td><a href="website.php?id=<?= $page["page_path"]; ?>&admin=<?= $_GET["admin"]; ?>&<?= $table; ?>key=<?= $row[$tablekey]; ?>&step=<?= $step; ?>" onmouseover="return overlib('<?= $admin_lang["table"][8]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_editor.png"></a></td><? } ?>
  370. <? if ($info != "") { ?><td width="1%"><a href="website.php?id=<?= $page["page_path"]; ?>&admin=<?= $info; ?>&key=<?= $row[$tablekey]; ?>" onmouseover="return overlib('<?= $admin_lang["table"][7]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_help.gif"></a></td><? } ?>
  371. <? foreach($fieldlist_arr as $value) { ?>
  372. <td>
  373. <?
  374. if ($row[$value] != "")
  375. {
  376. if (($table == "account") && ($value == "account_lastname"))
  377. {
  378. if ($row["account_lock"])
  379. {
  380. $lock_start = "<span style='color:red;'>";
  381. $lock_end = "</span>";
  382. }
  383. else
  384. {
  385. $lock_start = "";
  386. $lock_end = "";
  387. }
  388. echo $lock_start.$row[$value]." [".getGroup($row["account_group"])."]".$lock_end;
  389. }
  390. elseif ($value == "task_page")
  391. {
  392. if ($row[$value] != "")
  393. {
  394. ?>
  395. <a href="#" onClick="window.opener.location.href = 'website.php?id=<?= $row[$value] ?>'"><?= strip_tags($row[$value]); ?></a>
  396. <?
  397. }
  398. else
  399. {
  400. echo "&nbsp;";
  401. }
  402. }
  403. elseif ($value == "page_title")
  404. {
  405. ?>
  406. <a href="#" onClick="window.opener.location.href = 'website.php?id=<?= $row["page_path"] ?>'"><?= strip_tags($row[$value]); ?></a>
  407. <?
  408. }
  409. else
  410. {
  411. echo $row[$value];
  412. }
  413. }
  414. else
  415. {
  416. echo "&nbsp;";
  417. }
  418. ?>
  419. </td>
  420. <? } ?>
  421. <? if ($exportview != "") { ?><td><? if ($row["page_exportfolder"] != "") { ?><a href=".<?= $row["page_exportfolder"]; ?>/<?= getFile($row["page_path"]); ?>" target="_blank" onmouseover="return overlib('<?= $admin_lang["table"][9]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_preview.png"></a><? } else { ?>&nbsp;<? } ?></td><? } ?>
  422. <? if ($export != "") { ?>
  423. <td><? if ($row["page_exportfolder"] != "") { ?><a href="javascript:startExportEmpty('<?= $page["page_path"]; ?>',<?= $row[$tablekey]; ?>);" onmouseover="return overlib('<?= $admin_lang["table"][24]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_startexportempty.png"></a><? } else { ?>&nbsp;<? } ?></td>
  424. <td><? if ($row["page_exportfolder"] != "") { ?><a href="javascript:startExport('<?= $page["page_path"]; ?>',<?= $row[$tablekey]; ?>);" onmouseover="return overlib('<?= $admin_lang["table"][10]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_startexport.png"></a><? } else { ?>&nbsp;<? } ?></td>
  425. <? } ?>
  426. <? if ($copy != "") { ?><td width="1%"><a href="javascript:copyNewsletter(<?= $row[$tablekey]; ?>);" onmouseover="return overlib('<?= $admin_lang["table"][11]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_copy.png"></a></td><? } ?>
  427. <? if ($test != "") { ?><td width="1%"><a href="javascript:location.href='website.php?id=<?= $page["page_path"]; ?>&admin=newsletter&action=testnewsletter&nl_key=<?= $row[$tablekey]; ?>';" onmouseover="return overlib('<?= $admin_lang["table"][12]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_testnewsletter.png"></a></td><? } ?>
  428. <? if ($send != "") { ?><td width="1%"><? if ($row["nl_status"] == 0) { ?><a href="javascript:confirmSend('<?= $page["page_path"]; ?>','<?= $row[$tablekey]; ?>');" onmouseover="return overlib('<?= $admin_lang["table"][13]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_sendnewsletter.png"></a><? } else { ?><img src="system/admin/img/oes_sendnewsletter_off.png"><? } ?></td><? } ?>
  429. <? if ($table == "template") { ?>
  430. <td><? if (mysql_num_rows(get_template_page($row[$tablekey])) == 0) { ?><a href="Javascript:del<?= $table; ?>Item(<?= $row[$tablekey]; ?>);" onmouseover="return overlib('<?= $admin_lang["table"][14]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_delete.png"></a><? } else { ?><img src="system/admin/img/oes_delete_off.png"><? } ?></td>
  431. <? } else { ?>
  432. <td><? if ($del != "no") { ?><a href="Javascript:del<?= $table; ?>Item(<?= $row[$tablekey]; ?>);" onmouseover="return overlib('<?= $admin_lang["table"][14]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_delete.png"></a><? } else { ?><img src="system/admin/img/oes_delete_off.png"><? } ?></td>
  433. <? } ?>
  434. </tr>
  435. <?
  436. }
  437. }
  438. }
  439. else
  440. {
  441. if (($stepcounter > (($step - 1) * $stepsize)) && ($stepcounter <= ($step * $stepsize)))
  442. {
  443. if ((isset($_GET[$table."key"])) && ($_GET[$table."key"] == $row[$tablekey]))
  444. {
  445. if (($edit != "no") && ($edit != ""))
  446. {
  447. ?>
  448. <tr valign="top">
  449. <td><a href="Javascript:checkInput()" onmouseover="return overlib('<?= $admin_lang["table"][5]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_ok.png"></a></td>
  450. <? if ($info != "") { ?><td width="1%" valign="bottom"><a href="website.php?id=<?= $page["page_path"]; ?>&admin=<?= $info; ?>&key=<?= $row[$tablekey]; ?>" onmouseover="return overlib('<?= $admin_lang["table"][7]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_help.gif"></a></td><? } ?>
  451. <td colspan="<?= sizeof($fieldlist_arr); ?>">
  452. <div class="oeeditinc">
  453. <a name="<?= $row[$tablekey]; ?>"></a>
  454. <? include($edit); ?>
  455. </div>
  456. </td>
  457. <? if ($copy != "") { ?><td width="1%">&nbsp;</td><? } ?>
  458. <? if ($test != "") { ?><td width="1%">&nbsp;</td><? } ?>
  459. <? if ($send != "") { ?><td width="1%">&nbsp;</td><? } ?>
  460. <td><a href="website.php?id=<?= $page["page_path"]; ?>&admin=<?= $_GET["admin"]; ?>&step=<?= $step; ?>" onmouseover="return overlib('<?= $admin_lang["table"][4]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_cancel.png"></a></td>
  461. </tr>
  462. <?
  463. }
  464. else
  465. {
  466. ?>
  467.  
  468. <? if ($requiredlist != "") { ?>
  469. <!-- Requiredlist START -->
  470. <script language="javascript" type="text/javascript">
  471. <? echo writeRequire("edit".$table."Form", explode(",",$requiredlist)); ?>
  472. </script>
  473. <!-- Requiredlist END -->
  474. <? } ?>
  475.  
  476. <form method="post" name="edit<?= $table; ?>Form">
  477. <input type="hidden" name="action" value="editTableItem">
  478. <input type="hidden" name="table" value="<?= $table; ?>">
  479. <input type="hidden" name="tablekey" value="<?= $tablekey; ?>">
  480. <input type="hidden" name="fieldlist" value="<?= $fieldlist; ?>">
  481. <input type="hidden" name="editkey" value="<?= $row[$tablekey]; ?>">
  482. <tr valign="top">
  483. <td><a name="<?= $row[$tablekey]; ?>"></a><a href="Javascript:checkInput();" onmouseover="return overlib('<?= $admin_lang["table"][6]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_ok.png"></a></td>
  484. <? if ($info != "") { ?><td width="1%"><a href="website.php?id=<?= $page["page_path"]; ?>&admin=<?= $info; ?>&key=<?= $row[$tablekey]; ?>" onmouseover="return overlib('<?= $admin_lang["table"][7]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_help.gif"></a></td><? } ?>
  485. <? foreach($fieldlist_arr as $value)
  486. {
  487. $pos = strpos ($locklist, $value);
  488. if ($pos === false)
  489. {
  490. if ($value == "task_description")
  491. {
  492. ?>
  493. <td><textarea name="<?= $value; ?>"><?= $row[$value]; ?></textarea></td>
  494. <?
  495. }
  496. elseif ($value == "task_page")
  497. {
  498. ?>
  499. <td>
  500. <select name="<?= $value; ?>">
  501. <option value=""><?= $admin_lang["table"][3]; ?></option>
  502. <?
  503. $homepages = get_homepages();
  504. while ($item = mysql_fetch_array($homepages))
  505. {
  506. getSitemapTable("home".$item["page_key"],$item["page_key"],0,$row[$value]);
  507. }
  508. ?>
  509. </select>
  510. </td>
  511. <?
  512. }
  513. else
  514. {
  515. ?>
  516. <td><input type="text" name="<?= $value; ?>" value="<?= $row[$value]; ?>"></td>
  517. <?
  518. }
  519. }
  520. else
  521. {
  522. ?>
  523. <td><input type="hidden" name="<?= $value; ?>" value="<?= $row[$value]; ?>"><? if ($row[$value] != "") { ?><?= $row[$value]; ?><? } else { ?>&nbsp;<? } ?></td>
  524. <?
  525. }
  526. }
  527. ?>
  528. <? if ($exportview != "") { ?><td width="1%">&nbsp;</td><? } ?>
  529. <? if ($export != "") { ?><td width="1%">&nbsp;</td><td width="1%">&nbsp;</td><? } ?>
  530. <? if ($copy != "") { ?><td width="1%">&nbsp;</td><? } ?>
  531. <? if ($test != "") { ?><td width="1%">&nbsp;</td><? } ?>
  532. <? if ($send != "") { ?><td width="1%">&nbsp;</td><? } ?>
  533. <td><a href="website.php?id=<?= $page["page_path"]; ?>&admin=<?= $_GET["admin"]; ?>&step=<?= $step; ?>" onmouseover="return overlib('<?= $admin_lang["table"][4]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_cancel.png"></a></td>
  534. </tr>
  535. </form>
  536. <?
  537. }
  538. }
  539. else
  540. {
  541. ?>
  542. <tr>
  543. <? if ($edit != "no") { ?><td><a href="website.php?id=<?= $page["page_path"]; ?>&admin=<?= $_GET["admin"]; ?>&<?= $table; ?>key=<?= $row[$tablekey]; ?>&step=<?= $step; ?>" onmouseover="return overlib('<?= $admin_lang["table"][8]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_editor.png"></a></td><? } ?>
  544. <? if ($info != "") { ?><td width="1%"><a href="website.php?id=<?= $page["page_path"]; ?>&admin=<?= $info; ?>&key=<?= $row[$tablekey]; ?>" onmouseover="return overlib('<?= $admin_lang["table"][7]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_help.gif"></a></td><? } ?>
  545. <? foreach($fieldlist_arr as $value) { ?>
  546. <td>
  547. <?
  548. if ($row[$value] != "")
  549. {
  550. if (($table == "account") && ($value == "account_lastname"))
  551. {
  552. if ($row["account_lock"])
  553. {
  554. $lock_start = "<span style='color:red;'>";
  555. $lock_end = "</span>";
  556. }
  557. else
  558. {
  559. $lock_start = "";
  560. $lock_end = "";
  561. }
  562. echo $lock_start.$row[$value]." [".getGroup($row["account_group"])."]".$lock_end;
  563. }
  564. elseif ($value == "task_page")
  565. {
  566. if ($row[$value] != "")
  567. {
  568. ?>
  569. <a href="#" onClick="window.opener.location.href = 'website.php?id=<?= $row[$value] ?>'"><?= strip_tags($row[$value]); ?></a>
  570. <?
  571. }
  572. else
  573. {
  574. echo "&nbsp;";
  575. }
  576. }
  577. elseif ($value == "page_title")
  578. {
  579. ?>
  580. <a href="#" onClick="window.opener.location.href = 'website.php?id=<?= $row["page_path"] ?>'"><?= strip_tags($row[$value]); ?></a>
  581. <?
  582. }
  583. else
  584. {
  585. echo $row[$value];
  586. }
  587. }
  588. else
  589. {
  590. echo "&nbsp;";
  591. }
  592. ?>
  593. </td>
  594. <? } ?>
  595. <? if ($exportview != "") { ?><td><? if ($row["page_exportfolder"] != "") { ?><a href=".<?= $row["page_exportfolder"]; ?>/<?= getFile($row["page_path"]); ?>" target="_blank" onmouseover="return overlib('<?= $admin_lang["table"][9]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_preview.png"></a><? } else { ?>&nbsp;<? } ?></td><? } ?>
  596. <? if ($export != "") { ?>
  597. <td><? if ($row["page_exportfolder"] != "") { ?><a href="javascript:startExportEmpty('<?= $page["page_path"]; ?>',<?= $row[$tablekey]; ?>);" onmouseover="return overlib('<?= $admin_lang["table"][24]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_startexportempty.png"></a><? } else { ?>&nbsp;<? } ?></td>
  598. <td><? if ($row["page_exportfolder"] != "") { ?><a href="javascript:startExport('<?= $page["page_path"]; ?>',<?= $row[$tablekey]; ?>);" onmouseover="return overlib('<?= $admin_lang["table"][10]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_startexport.png"></a><? } else { ?>&nbsp;<? } ?></td>
  599. <? } ?>
  600. <? if ($copy != "") { ?><td width="1%"><a href="javascript:copyNewsletter(<?= $row[$tablekey]; ?>);" onmouseover="return overlib('<?= $admin_lang["table"][11]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_copy.png"></a></td><? } ?>
  601. <? if ($test != "") { ?><td width="1%"><a href="javascript:location.href='website.php?id=<?= $page["page_path"]; ?>&admin=newsletter&action=testnewsletter&nl_key=<?= $row[$tablekey]; ?>';" onmouseover="return overlib('<?= $admin_lang["table"][12]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_testnewsletter.png"></a></td><? } ?>
  602. <? if ($send != "") { ?><td width="1%"><? if ($row["nl_status"] == 0) { ?><a href="javascript:confirmSend('<?= $page["page_path"]; ?>','<?= $row[$tablekey]; ?>');" onmouseover="return overlib('<?= $admin_lang["table"][13]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_sendnewsletter.png"></a><? } else { ?><img src="system/admin/img/oes_sendnewsletter_off.png"><? } ?></td><? } ?>
  603. <? if ($table == "template") { ?>
  604. <td><? if (mysql_num_rows(get_template_page($row[$tablekey])) == 0) { ?><a href="Javascript:del<?= $table; ?>Item(<?= $row[$tablekey]; ?>);" onmouseover="return overlib('<?= $admin_lang["table"][14]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_delete.png"></a><? } else { ?><img src="system/admin/img/oes_delete_off.png"><? } ?></td>
  605. <? } else { ?>
  606. <td><? if ($del != "no") { ?><a href="Javascript:del<?= $table; ?>Item(<?= $row[$tablekey]; ?>);" onmouseover="return overlib('<?= $admin_lang["table"][14]; ?>', CAPTION, '', WIDTH, 100, FGCOLOR, '#ffffff', BGCOLOR, '#FF9933');" onmouseout="return nd();"><img src="system/admin/img/oes_delete.png"></a><? } else { ?><img src="system/admin/img/oes_delete_off.png"><? } ?></td>
  607. <? } ?>
  608. </tr>
  609. <?
  610. }
  611. }
  612. }
  613. $stepcounter++;
  614. }
  615. ?>
  616. </tbody>
  617. </table>
  618. <? if ((isset($_POST["action"])) && ($_POST["action"] == "searchitem")) { ?>
  619. <div class="oesubmitbuttons2" style="padding-top:10px;">
  620. <input style="background-image:url(system/admin/img/oes_cancelback.png);background-repeat:no-repeat;width:100px;" type="button" value="Cancel" class="adminsubmitbtn" onclick="location.href='website.php?id=/index.htm&admin=<?= $_GET["admin"]; ?>'">
  621. </div>
  622. <?
  623. }
  624. else
  625. {
  626. if (round($stepcounter / $stepsize) > 1)
  627. {
  628. ?>
  629. <table border="0" cellpadding="0" cellspacing="0" width="95%" style="border-top:0px; ">
  630. <tbody>
  631. <tr>
  632. <td style="background-color:#D7E5FF;">
  633. <? for ($i = 1; $i <= round($stepcounter / $stepsize); $i++)
  634. {
  635. if ($step == $i)
  636. {
  637. ?>
  638. <a href="website.php?id=<?= $page["page_path"]; ?>&admin=<?= $_GET["admin"]; ?>&step=<?= $i; ?>"><b><?= $i; ?></b></a> |
  639. <?
  640. }
  641. else
  642. {
  643. if (isset($_GET['key']))
  644. {
  645. $key = "&key=".$_GET['key'];
  646. }
  647. else
  648. {
  649. $key = "";
  650. }
  651. ?>
  652. <a href="website.php?id=<?= $page["page_path"]; ?>&admin=<?= $_GET["admin"]; ?>&step=<?= $i; ?>"><?= $i; ?></a> |
  653. <?
  654. }
  655. }
  656. }
  657. ?>
  658. </td>
  659. </tr>
  660. </tbody>
  661. </table>
  662. <? } ?>
  663. </div>
  664. </div>
  665.  
  666. <div id="sc2" class="tabcontent">
  667. <p class="adminText"><?= $admin_lang["table"][15]; ?> <b><?= $anzahl_all; ?> <?= $admin_lang["table"][16]; ?>.</b></p>
  668. <? if ($information != "") { ?><p class="adminText"><?= $information; ?></p><? } ?>
  669. <p class="adminText">
  670. <? if ($add != "no") { ?><img src="system/admin/img/oes_add.png"> <?= $admin_lang["table"][2]; ?><br><? } ?>
  671. <? if ($edit != "no") { ?><img src="system/admin/img/oes_editor.png"> <?= $admin_lang["table"][8]; ?><br><? } ?>
  672. <? if ($del != "no") { ?><img src="system/admin/img/oes_delete.png"> <?= $admin_lang["table"][14]; ?><br><? } ?>
  673. <? if (($add != "no") || ($edit != "no")) { ?><img src="system/admin/img/oes_ok.png"> <?= $admin_lang["table"][6]; ?><br><? } ?>
  674. <? if (($add != "no") || ($edit != "no")) { ?><img src="system/admin/img/oes_cancel.png"> <?= $admin_lang["table"][4]; ?><br><? } ?>
  675. <? if ($info == "yes") { ?><img src="system/admin/img/oes_help.gif"> <?= $admin_lang["table"][7]; ?><br><? } ?>
  676. <? if ($export == "yes") { ?><img src="system/admin/img/oes_startexport.png"> <?= $admin_lang["table"][10]; ?><br><? } ?>
  677. <? if ($export == "yes") { ?><img src="system/admin/img/oes_startexportempty.png"> <?= $admin_lang["table"][24]; ?><br><? } ?>
  678. <? if ($exportview == "yes") { ?><img src="system/admin/img/oes_preview.png"> <?= $admin_lang["table"][9]; ?><br><? } ?>
  679. <? if ($copy == "yes") { ?><img src="system/admin/img/oes_copy.png"> <?= $admin_lang["table"][11]; ?><br><? } ?>
  680. <? if ($test == "yes") { ?><img src="system/admin/img/oes_testnewsletter.png"> <?= $admin_lang["table"][12]; ?><br><? } ?>
  681. <? if ($send == "yes") { ?><img src="system/admin/img/oes_sendnewsletter.png"> <?= $admin_lang["table"][13]; ?><br><? } ?>
  682. </p>
  683. </div>
  684.  
  685. <? if ($search != "") { ?>
  686. <div id="sc3" class="tabcontent">
  687. <div class="oeedittable">
  688. <div class="oeeditinc">
  689. <? include($search); ?>
  690. </div>
  691. </div>
  692. </div>
  693. <? } ?>
  694. </div>
  695. <?
  696. }
  697.  
  698. /**
  699. * Adds a table item
  700. */
  701. function addTableItem()
  702. {
  703. global $db_praefix,$page;
  704. $table = $_POST["table"];
  705. $fieldlist = $_POST["fieldlist"];
  706. $fieldlist_arr = explode(",",$fieldlist);
  707. $addhidden = $_POST["addhidden"];
  708. $addhidden_arr = explode(",",$addhidden);
  709. $tablekey = $_POST["tablekey"];
  710. $link = connectDB();
  711. $hiddenlist = "";
  712. if ($addhidden != "")
  713. {
  714. foreach($addhidden_arr as $value)
  715. {
  716. $value_arr = explode("=",$value);
  717. $hiddenlist .= ",".$value_arr[0];
  718. }
  719. }
  720. $query = "INSERT INTO ".$db_praefix.$table." ($fieldlist$hiddenlist) VALUES (";
  721. foreach($fieldlist_arr as $value)
  722. {
  723. if ($value == "str_value")
  724. {
  725. $query .= "'".htmlencode($_POST[$value])."',";
  726. }
  727. else
  728. {
  729. $query .= "'".$_POST[$value]."',";
  730. }
  731. }
  732. if ($addhidden != "")
  733. {
  734. foreach($addhidden_arr as $value)
  735. {
  736. $value_arr = explode("=",$value);
  737. $query .= "'".$value_arr[1]."',";
  738. }
  739. }
  740. $query = substr($query,0,strlen($query)-1);
  741. $query .= ")";
  742. $result = mysql_query($query);
  743. closeDB($link);
  744. header("Location: website.php?id=".$page["page_path"]."&admin=".$_GET["admin"]);
  745. }
  746.  
  747. /**
  748. * Deletes a table item
  749. */
  750. function delTableItem()
  751. {
  752. global $db_praefix,$page;
  753. $table = $_POST["table"];
  754. $tablekey = $_POST["tablekey"];
  755. $delkey = $_POST["delkey"];
  756. $step = $_POST["step"];
  757. $link = connectDB();
  758. $query = "DELETE FROM ".$db_praefix.$table." where $tablekey = $delkey";
  759. $result = mysql_query($query);
  760. closeDB($link);
  761. header("Location: website.php?id=".$page["page_path"]."&admin=".$_GET["admin"]."&step=".$step);
  762. }
  763.  
  764. /**
  765. * Edits a table item
  766. */
  767. function editTableItem()
  768. {
  769. global $db_praefix,$page;
  770. $table = $_POST["table"];
  771. $tablekey = $_POST["tablekey"];
  772. $fieldlist = $_POST["fieldlist"];
  773. $fieldlist_arr = explode(",",$fieldlist);
  774. $editkey = $_POST["editkey"];
  775. $link = connectDB();
  776. $query = "UPDATE ".$db_praefix.$table." SET ";
  777. foreach($fieldlist_arr as $value)
  778. {
  779. if ($value == "str_value")
  780. {
  781. $query .= $value."='".htmlencode($_POST[$value])."',";
  782. }
  783. else
  784. {
  785. $query .= $value."='".$_POST[$value]."',";
  786. }
  787. }
  788. $query = substr($query,0,strlen($query)-1);
  789. $query .= " where $tablekey = $editkey";
  790. $result = mysql_query($query);
  791. closeDB($link);
  792. header("Location: website.php?id=".$page["page_path"]."&admin=".$_GET["admin"]."&step=".$_GET["step"]);
  793. }
  794. ?>

Documentation generated on Tue, 04 Oct 2005 11:13:40 +0200 by phpDocumentor 1.3.0RC3