API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 10th, 2017
97
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 35.42 KB | None | 0 0
raw download clone embed print report
  1. <?php session_start();
  2. ### POŁĄCZENIE Z BAZĄ DANYCH ###
  3. $host = ""; // Hosting bazy danych
  4. $user = ""; // Użytkownik bazy danych
  5. $pass = ""; // Hasło bazy danych
  6. $db = ""; // Używana baza danych
  7. $table = ""; // Używana tabela bazy danych
  8. $error = "..."; // Informacja o błędnym połączeniu z bazą danych
  9.  
  10. ### KONFIGURACJA SERWISU ###
  11. $title = "Tytuł"; // Nazwa strony w nagłówku
  12. $background = "http://i63.tinypic.com/23kf5gj.jpg"; // Obraz tła na stronie
  13. $admin_login = "admin"; // Login do konta administratora
  14. $admin_pass = "admin"; // Hasło do konta administratora
  15. $info_guest = "Pełny dostęp wymaga uprzedniego zalogowania się do panelu."; // Informacja o wymaganym zalogowaniu do panelu
  16. $alert_login = "Wpisano nieprawidłowy login lub hasło."; // Komunikat o niepomyślnym logowaniu
  17. $alert_access = "Brak dostępu do wykonania tej czynności."; // Komunikat o nieupoważnionej interakcji
  18. $alert_limit = "Osiągnięto limit dostępnych komórek w tabeli."; // Komunikat o przekroczonym limicie komórek
  19. $alert_block = "Zablokowano usunięcie tej komórki w tabeli."; // Komunikat o przekroczonym limicie komórek
  20. $alert_space = "Brak wystarczającej ilości wolnych miejsc."; // Komunikat o braku wystarczającej przestrzeni
  21. $button_login = "Zaloguj"; // Nazwa przycisku logowania
  22. $button_logout = "Wyloguj"; // Nazwa przycisku wylogowania
  23. $button_add = "Dodaj"; // Nazwa przycisku dodawania zamówienia
  24. $button_clear = "Wyczyść"; // Nazwa przycisku czyszczącego komórkę
  25. $button_create = "Utwórz"; // Nazwa przycisku tworzącego komórkę
  26. $td_width = "250px"; // Domyślna szerokość komórki w tabelach
  27. $td_color = Array(
  28. 0 => "FFFFFF",
  29. // Kolor pustej komórki w tabelach
  30. 1 => Array("zaległy towar", "FF0000"),
  31. 2 => Array("wysyłka", "FFFF00"),
  32. 3 => Array("Nowa wysyłka", "00FF00"),
  33. // Kolory zajętych komórek w tabelach
  34. );
  35. $td_name = Array(
  36. 0 => "lp.",
  37. // Nazwa identyfikatora komórek w tabelach
  38. 1 => "T1",
  39. 2 => "T2",
  40. 3 => "T3",
  41. 4 => "T4",
  42. 5 => "T5",
  43. // Nazwy kolumn nadrzędnych w tabeli pierwszej
  44. 6 => "T6",
  45. 7 => "T7",
  46. 8 => "T8",
  47. 9 => "T9",
  48. 10 => "T10",
  49. // Nazwy kolumn nadrzędnych w tabeli drugiej
  50. );
  51. $td_limit = 21; // Limit wszystkich komórek w tabeli razem z dodatkowymi
  52. $td_block = 6; // Ilość zablokowanych komórek z niemożliwością usunięcia
  53. ?>
  54.  
  55. <?php
  56. mysql_connect($host, $user, $pass) or die($error);
  57. mysql_select_db($db) or die($error);
  58. mysql_query("SET CHARACTER SET UTF8");
  59.  
  60. $account_login = mysql_real_escape_string($_POST['account_login']);
  61. $account_password = mysql_real_escape_string($_POST['account_password']);
  62. $add_name = mysql_real_escape_string($_POST['add_name']);
  63. $add_info = mysql_real_escape_string($_POST['add_info']);
  64. $add_count = mysql_real_escape_string($_POST['add_count']);
  65. $add_color = mysql_real_escape_string($_POST['add_color']);
  66. $delete_id = mysql_real_escape_string($_GET['delete']);
  67. $t1 = mysql_real_escape_string($_GET['t1']);
  68. $t2 = mysql_real_escape_string($_GET['t2']);
  69. $t3 = mysql_real_escape_string($_GET['t3']);
  70. $t4 = mysql_real_escape_string($_GET['t4']);
  71. $t5 = mysql_real_escape_string($_GET['t5']);
  72. $t6 = mysql_real_escape_string($_GET['t6']);
  73. $t7 = mysql_real_escape_string($_GET['t7']);
  74. $t8 = mysql_real_escape_string($_GET['t8']);
  75. $t9 = mysql_real_escape_string($_GET['t9']);
  76. $t10 = mysql_real_escape_string($_GET['t10']);
  77. $rows = mysql_query("SELECT * FROM `".$table."` LIMIT ".$td_limit.";");
  78.  
  79. if(!empty($account_login) && !empty($account_password)) {
  80. if($admin_login == $account_login && $admin_pass == $account_password) {
  81. $_SESSION['cookies_ok'] = TRUE;
  82. $_SESSION['account_login'] = $account_login;
  83. } else {
  84. echo '<script type="text/javascript">alert("'.$alert_login.'");</script>';
  85. echo '<meta http-equiv="refresh" content="0; URL=index.php">';
  86. }
  87. }
  88.  
  89. if(isset($_GET['add']) && !empty($add_name) && !empty($add_info) && !empty($add_count) && !empty($add_color) && $_SESSION['cookies_ok'] == TRUE) {
  90. $add_rows = mysql_query("SELECT * FROM `".$table."` WHERE `T".$add_name."_INFO` = '';");
  91. if($add_count <= mysql_num_rows($add_rows)) {
  92. $add_select = mysql_query("SELECT * FROM `".$table."` WHERE `T".$add_name."_INFO` = '' LIMIT ".$add_count.";");
  93. while($add_update = mysql_fetch_array($add_select)){
  94. mysql_query("UPDATE `".$table."` SET `T".$add_name."_INFO` = '".$add_info."', `T".$add_name."_COLOR` = '".$add_color."' WHERE `ID` = '".$add_update['ID']."';");
  95. }
  96. echo '<meta http-equiv="refresh" content="0; URL=index.php">';
  97. } else {
  98. echo '<script type="text/javascript">alert("'.$alert_space.'");</script>';
  99. echo '<meta http-equiv="refresh" content="0; URL=index.php">';
  100. }
  101. }
  102.  
  103. if(isset($_GET['more'])) {
  104. if($_SESSION['cookies_ok'] == TRUE) {
  105. $add_more = mysql_num_rows(mysql_query("SELECT * FROM `".$table."`;"));
  106. if($add_more < $td_limit) {
  107. mysql_query("INSERT INTO `".$table."` (`ID`, `T1_INFO`, `T2_INFO`, `T3_INFO`, `T4_INFO`, `T5_INFO`, `T6_INFO`, `T7_INFO`, `T8_INFO`, `T9_INFO`, `T10_INFO`, `T1_COLOR`, `T2_COLOR`, `T3_COLOR`, `T4_COLOR`, `T5_COLOR`, `T6_COLOR`, `T7_COLOR`, `T8_COLOR`, `T9_COLOR`, `T10_COLOR`) VALUES (NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');");
  108. echo '<meta http-equiv="refresh" content="0; URL=index.php">';
  109. } else {
  110. echo '<script type="text/javascript">alert("'.$alert_limit.'");</script>';
  111. echo '<meta http-equiv="refresh" content="0; URL=index.php">';
  112. }
  113. } else {
  114. echo '<script type="text/javascript">alert("'.$alert_access.'");</script>';
  115. echo '<meta http-equiv="refresh" content="0; URL=index.php">';
  116. }
  117. }
  118.  
  119. if(isset($_GET['delete'])) {
  120. if($_SESSION['cookies_ok'] == TRUE) {
  121. if($_GET['delete'] > $td_block) {
  122. mysql_query("DELETE FROM `".$table."` WHERE `ID` = '".$delete_id."';");
  123. mysql_query("ALTER TABLE `".$table."` AUTO_INCREMENT = 1;");
  124. echo '<meta http-equiv="refresh" content="0; URL=index.php">';
  125. } else {
  126. echo '<script type="text/javascript">alert("'.$alert_block.'");</script>';
  127. echo '<meta http-equiv="refresh" content="0; URL=index.php">';
  128. }
  129. } else {
  130. echo '<script type="text/javascript">alert("'.$alert_access.'");</script>';
  131. echo '<meta http-equiv="refresh" content="0; URL=index.php">';
  132. }
  133. }
  134.  
  135. if(isset($_GET['color'])) {
  136. if($_SESSION['cookies_ok'] == TRUE) {
  137. if(isset($_GET['t1'])) {
  138. mysql_query("UPDATE `".$table."` SET `T1_COLOR` = '".$_GET['color']."' WHERE `ID` = '".$t1."';");
  139. } elseif(isset($_GET['t2'])) {
  140. mysql_query("UPDATE `".$table."` SET `T2_COLOR` = '".$_GET['color']."' WHERE `ID` = '".$t2."';");
  141. } elseif(isset($_GET['t3'])) {
  142. mysql_query("UPDATE `".$table."` SET `T3_COLOR` = '".$_GET['color']."' WHERE `ID` = '".$t3."';");
  143. } elseif(isset($_GET['t4'])) {
  144. mysql_query("UPDATE `".$table."` SET `T4_COLOR` = '".$_GET['color']."' WHERE `ID` = '".$t4."';");
  145. } elseif(isset($_GET['t5'])) {
  146. mysql_query("UPDATE `".$table."` SET `T5_COLOR` = '".$_GET['color']."' WHERE `ID` = '".$t5."';");
  147. } elseif(isset($_GET['t6'])) {
  148. mysql_query("UPDATE `".$table."` SET `T6_COLOR` = '".$_GET['color']."' WHERE `ID` = '".$t6."';");
  149. } elseif(isset($_GET['t7'])) {
  150. mysql_query("UPDATE `".$table."` SET `T7_COLOR` = '".$_GET['color']."' WHERE `ID` = '".$t7."';");
  151. } elseif(isset($_GET['t8'])) {
  152. mysql_query("UPDATE `".$table."` SET `T8_COLOR` = '".$_GET['color']."' WHERE `ID` = '".$t8."';");
  153. } elseif(isset($_GET['t9'])) {
  154. mysql_query("UPDATE `".$table."` SET `T9_COLOR` = '".$_GET['color']."' WHERE `ID` = '".$t9."';");
  155. } elseif(isset($_GET['t10'])) {
  156. mysql_query("UPDATE `".$table."` SET `T10_COLOR` = '".$_GET['color']."' WHERE `ID` = '".$t10."';");
  157. }
  158. echo '<meta http-equiv="refresh" content="0; URL=index.php">';
  159. } else {
  160. echo '<script type="text/javascript">alert("'.$alert_access.'");</script>';
  161. echo '<meta http-equiv="refresh" content="0; URL=index.php">';
  162. }
  163. }
  164.  
  165. if(isset($_GET['clear'])) {
  166. if($_SESSION['cookies_ok'] == TRUE) {
  167. if(isset($_GET['t1'])) {
  168. mysql_query("UPDATE `".$table."` SET `T1_INFO` = '', `T1_COLOR` = '' WHERE `ID` = '".$t1."';");
  169. } elseif(isset($_GET['t2'])) {
  170. mysql_query("UPDATE `".$table."` SET `T2_INFO` = '', `T2_COLOR` = '' WHERE `ID` = '".$t2."';");
  171. } elseif(isset($_GET['t3'])) {
  172. mysql_query("UPDATE `".$table."` SET `T3_INFO` = '', `T3_COLOR` = '' WHERE `ID` = '".$t3."';");
  173. } elseif(isset($_GET['t4'])) {
  174. mysql_query("UPDATE `".$table."` SET `T4_INFO` = '', `T4_COLOR` = '' WHERE `ID` = '".$t4."';");
  175. } elseif(isset($_GET['t5'])) {
  176. mysql_query("UPDATE `".$table."` SET `T5_INFO` = '', `T5_COLOR` = '' WHERE `ID` = '".$t5."';");
  177. } elseif(isset($_GET['t6'])) {
  178. mysql_query("UPDATE `".$table."` SET `T6_INFO` = '', `T6_COLOR` = '' WHERE `ID` = '".$t6."';");
  179. } elseif(isset($_GET['t7'])) {
  180. mysql_query("UPDATE `".$table."` SET `T7_INFO` = '', `T7_COLOR` = '' WHERE `ID` = '".$t7."';");
  181. } elseif(isset($_GET['t8'])) {
  182. mysql_query("UPDATE `".$table."` SET `T8_INFO` = '', `T8_COLOR` = '' WHERE `ID` = '".$t8."';");
  183. } elseif(isset($_GET['t9'])) {
  184. mysql_query("UPDATE `".$table."` SET `T9_INFO` = '', `T9_COLOR` = '' WHERE `ID` = '".$t9."';");
  185. } elseif(isset($_GET['t10'])) {
  186. mysql_query("UPDATE `".$table."` SET `T10_INFO` = '', `T10_COLOR` = '' WHERE `ID` = '".$t10."';");
  187. }
  188. echo '<meta http-equiv="refresh" content="0; URL=index.php">';
  189. } else {
  190. echo '<script type="text/javascript">alert("'.$alert_access.'");</script>';
  191. echo '<meta http-equiv="refresh" content="0; URL=index.php">';
  192. }
  193. }
  194.  
  195. if(isset($_GET['logout']) && $_SESSION['cookies_ok'] == TRUE) {
  196. $_SESSION['cookies_ok'] = FALSE;
  197. $_SESSION['account_login'] = '';
  198. echo '<meta http-equiv="refresh" content="0; URL=index.php">';
  199. }
  200. ?>
  201. <html>
  202. <head>
  203. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  204. <style type="text/css">
  205. body {
  206. background: url(<?php echo $background; ?>);
  207. background-repeat: no-repeat;
  208. background-position: center;
  209. background-size: 100% 100%;
  210. }
  211.  
  212. a {
  213. text-decoration: none;
  214. }
  215.  
  216. #table td {
  217. font-family: Verdana, Arial, sans-serif;
  218. border: 1px solid black;
  219. padding: 5px;
  220. }
  221.  
  222. .popup {
  223. position: relative;
  224. display: inline-block;
  225. cursor: pointer;
  226. -webkit-user-select: none;
  227. -moz-user-select: none;
  228. -ms-user-select: none;
  229. user-select: none;
  230. }
  231.  
  232. .popup .popuptext {
  233. visibility: hidden;
  234. width: 160px;
  235. background-color: #555;
  236. color: #fff;
  237. text-align: center;
  238. border-radius: 6px;
  239. padding: 8px 0;
  240. position: absolute;
  241. z-index: 1;
  242. bottom: 125%;
  243. left: 50%;
  244. margin-left: -80px;
  245. }
  246.  
  247. /* Popup arrow */
  248. .popup .popuptext::after {
  249. content: "";
  250. position: absolute;
  251. top: 100%;
  252. left: 50%;
  253. margin-left: -5px;
  254. border-width: 5px;
  255. border-style: solid;
  256. border-color: #555 transparent transparent transparent;
  257. }
  258.  
  259. /* Toggle this class - hide and show the popup */
  260. .popup .show {
  261. visibility: visible;
  262. -webkit-animation: fadeIn 1s;
  263. animation: fadeIn 1s;
  264. }
  265.  
  266. /* Add animation (fade in the popup) */
  267. @-webkit-keyframes fadeIn {
  268. from {opacity: 0;}
  269. to {opacity: 1;}
  270. }
  271.  
  272. @keyframes fadeIn {
  273. from {opacity: 0;}
  274. to {opacity:1 ;}
  275. }
  276. </style>
  277. <script type="text/javascript">
  278. <?php
  279. $select_popupT1 = 1;
  280. while($select_popupT1 <= $td_limit) {
  281. ?>
  282. function T1myFunction<?php echo $select_popupT1; ?>() {
  283. var popup = document.getElementById("T1myPopup<?php echo $select_popupT1; ?>");
  284. popup.classList.toggle("show");
  285. }
  286. <?php
  287. $select_popupT1++;
  288. }
  289. ?>
  290. <?php
  291. $select_popupT2 = 1;
  292. while($select_popupT2 <= $td_limit) {
  293. ?>
  294. function T2myFunction<?php echo $select_popupT2; ?>() {
  295. var popup = document.getElementById("T2myPopup<?php echo $select_popupT2; ?>");
  296. popup.classList.toggle("show");
  297. }
  298. <?php
  299. $select_popupT2++;
  300. }
  301. ?>
  302. <?php
  303. $select_popupT3 = 1;
  304. while($select_popupT3 <= $td_limit) {
  305. ?>
  306. function T3myFunction<?php echo $select_popupT3; ?>() {
  307. var popup = document.getElementById("T3myPopup<?php echo $select_popupT3; ?>");
  308. popup.classList.toggle("show");
  309. }
  310. <?php
  311. $select_popupT3++;
  312. }
  313. ?>
  314. <?php
  315. $select_popupT4 = 1;
  316. while($select_popupT4 <= $td_limit) {
  317. ?>
  318. function T4myFunction<?php echo $select_popupT4; ?>() {
  319. var popup = document.getElementById("T4myPopup<?php echo $select_popupT4; ?>");
  320. popup.classList.toggle("show");
  321. }
  322. <?php
  323. $select_popupT4++;
  324. }
  325. ?>
  326. <?php
  327. $select_popupT5 = 1;
  328. while($select_popupT5 <= $td_limit) {
  329. ?>
  330. function T5myFunction<?php echo $select_popupT5; ?>() {
  331. var popup = document.getElementById("T5myPopup<?php echo $select_popupT5; ?>");
  332. popup.classList.toggle("show");
  333. }
  334. <?php
  335. $select_popupT5++;
  336. }
  337. ?>
  338. <?php
  339. $select_popupT6 = 1;
  340. while($select_popupT6 <= $td_limit) {
  341. ?>
  342. function T6myFunction<?php echo $select_popupT6; ?>() {
  343. var popup = document.getElementById("T6myPopup<?php echo $select_popupT6; ?>");
  344. popup.classList.toggle("show");
  345. }
  346. <?php
  347. $select_popupT6++;
  348. }
  349. ?>
  350. <?php
  351. $select_popupT7 = 1;
  352. while($select_popupT7 <= $td_limit) {
  353. ?>
  354. function T7myFunction<?php echo $select_popupT7; ?>() {
  355. var popup = document.getElementById("T7myPopup<?php echo $select_popupT7; ?>");
  356. popup.classList.toggle("show");
  357. }
  358. <?php
  359. $select_popupT7++;
  360. }
  361. ?>
  362. <?php
  363. $select_popupT8 = 1;
  364. while($select_popupT8 <= $td_limit) {
  365. ?>
  366. function T8myFunction<?php echo $select_popupT8; ?>() {
  367. var popup = document.getElementById("T8myPopup<?php echo $select_popupT8; ?>");
  368. popup.classList.toggle("show");
  369. }
  370. <?php
  371. $select_popupT8++;
  372. }
  373. ?>
  374. <?php
  375. $select_popupT9 = 1;
  376. while($select_popupT9 <= $td_limit) {
  377. ?>
  378. function T9myFunction<?php echo $select_popupT9; ?>() {
  379. var popup = document.getElementById("T9myPopup<?php echo $select_popupT9; ?>");
  380. popup.classList.toggle("show");
  381. }
  382. <?php
  383. $select_popupT9++;
  384. }
  385. ?>
  386. <?php
  387. $select_popupT10 = 1;
  388. while($select_popupT10 <= $td_limit) {
  389. ?>
  390. function T10myFunction<?php echo $select_popupT10; ?>() {
  391. var popup = document.getElementById("T10myPopup<?php echo $select_popupT10; ?>");
  392. popup.classList.toggle("show");
  393. }
  394. <?php
  395. $select_popupT10++;
  396. }
  397. ?>
  398. </script>
  399. <title><?php echo $title; ?></title>
  400. </head>
  401. <body>
  402. <center>
  403. <fieldset style="width:450px;height:70px;background-color:#CCCCCC;">
  404. <?php
  405. if($_SESSION['cookies_ok'] == FALSE) {
  406. echo '<form method="post"><input type="text" id="input" name="account_login" placeholder="Login" required="required"> <input type="password" id="input" name="account_password" placeholder="Hasło" required="required"> <input type="submit" id="submit" value="'.$button_login.'"></form>';
  407. } elseif($_SESSION['cookies_ok'] == TRUE) {
  408. echo '<form action="?logout" method="post"><input type="text" id="input" value="Witaj, '.$_SESSION['account_login'].'!" disabled="disabled"> <input type="submit" id="submit" value="'.$button_logout.'"></form>';
  409. }
  410. echo '<hr>';
  411. if($_SESSION['cookies_ok'] == FALSE) {
  412. echo '<b>'.$info_guest.'</b>';
  413. } elseif($_SESSION['cookies_ok'] == TRUE) {
  414. echo '<form action="?add" method="post">';
  415. $select_name = 1;
  416. echo '<select name="add_name">';
  417. while($select_name <= count($td_name)-1) {
  418. echo '<option value="'.$select_name.'">'.$td_name[$select_name].'</option>';
  419. $select_name++;
  420. }
  421. echo '</select>';
  422. echo '&nbsp;';
  423. echo '<input type="text" id="input" name="add_info" placeholder="Nazwa" required="required">';
  424. echo '&nbsp;';
  425. $select_count = 1;
  426. echo '<select name="add_count">';
  427. if(mysql_num_rows($rows) == 0) {
  428. echo '<option>0</option>';
  429. }
  430. while($select_count <= mysql_num_rows($rows)) {
  431. echo '<option value="'.$select_count.'">'.$select_count.'</option>';
  432. $select_count++;
  433. }
  434. echo '</select>';
  435. echo '&nbsp;';
  436. $select_color = 1;
  437. echo '<select name="add_color">';
  438. while($select_color <= count($td_color)-1) {
  439. echo '<option style="background-color:#'.$td_color[$select_color][1].'" value="'.$td_color[$select_color][1].'">'.$td_color[$select_color][0].'</option>';
  440. $select_color++;
  441. }
  442. echo '</select>';
  443. echo '&nbsp;';
  444. echo '<input type="submit" id="submit" value="'.$button_add.'">';
  445. echo '</form>';
  446. }
  447. ?>
  448. </fieldset>
  449. <br>
  450. <table id="table">
  451. <?php
  452. $rows = mysql_query("SELECT * FROM `".$table."` LIMIT ".$td_limit.";");
  453. if(mysql_num_rows($rows) >= 1) {
  454. echo '<tr>';
  455. echo '<td align="center" style="background:#CCCCCC"><b>'.$td_name[0].'</b></td><td align="center" style="background:#CCCCCC"><b>'.$td_name[1].'</b></td><td align="center" style="background:#CCCCCC"><b>'.$td_name[2].'</b></td><td align="center" style="background:#CCCCCC"><b>'.$td_name[3].'</b></td><td align="center" style="background:#CCCCCC"><b>'.$td_name[4].'</b></td><td align="center" style="background:#CCCCCC"><b>'.$td_name[5].'</b></td>';
  456. echo '</tr>';
  457. while($array = mysql_fetch_array($rows)) {
  458. $lp_a = $lp_a+1;
  459. echo '<tr>';
  460. echo '<td align="center" width="30px" style="background:#CCCCCC"><b>'.$lp_a.'.</b></td>';
  461. if($array['T1_INFO'] == "" && $array['T1_COLOR'] == "") {
  462. echo '<td align="center" width="'.$td_width.'" style="background:#'.$td_color[0].'">'.$array['T1_INFO'].'</td>';
  463. } else {
  464. echo '<td align="center" width="'.$td_width.'" style="background:#'.$array['T1_COLOR'].'">';
  465. echo '<div class="popup" onclick="T1myFunction'.$lp_a.'()"><font color="#000000">'.$array['T1_INFO'].'</font>';
  466. echo '<span class="popuptext" id="T1myPopup'.$lp_a.'">';
  467. $select_color = 1;
  468. while($select_color <= count($td_color)-1) {
  469. echo '<a href="?color='.$td_color[$select_color][1].'&t1='.$array['ID'].'"><button style="width:125px;background-color:#'.$td_color[$select_color][1].';">'.$td_color[$select_color][0].'</button></a>';
  470. $select_color++;
  471. }
  472. echo '<hr>';
  473. echo '<a href="?clear&t1='.$array['ID'].'"><button style="width:125px">'.$button_clear.'</button></a>';
  474. echo '</span></div></td>';
  475. }
  476. if($array['T2_INFO'] == "" && $array['T2_COLOR'] == "") {
  477. echo '<td align="center" width="'.$td_width.'" style="background:#'.$td_color[0].'">'.$array['T2_INFO'].'</td>';
  478. } else {
  479. echo '<td align="center" width="'.$td_width.'" style="background:#'.$array['T2_COLOR'].'">';
  480. echo '<div class="popup" onclick="T2myFunction'.$lp_a.'()"><font color="#000000">'.$array['T2_INFO'].'</font>';
  481. echo '<span class="popuptext" id="T2myPopup'.$lp_a.'">';
  482. $select_color = 1;
  483. while($select_color <= count($td_color)-1) {
  484. echo '<a href="?color='.$td_color[$select_color][1].'&t2='.$array['ID'].'"><button style="width:125px;background-color:#'.$td_color[$select_color][1].';">'.$td_color[$select_color][0].'</button></a>';
  485. $select_color++;
  486. }
  487. echo '<hr>';
  488. echo '<a href="?clear&t2='.$array['ID'].'"><button style="width:125px">'.$button_clear.'</button></a>';
  489. echo '</span></div></td>';
  490. }
  491. if($array['T3_INFO'] == "" && $array['T3_COLOR'] == "") {
  492. echo '<td align="center" width="'.$td_width.'" style="background:#'.$td_color[0].'">'.$array['T3_INFO'].'</td>';
  493. } else {
  494. echo '<td align="center" width="'.$td_width.'" style="background:#'.$array['T3_COLOR'].'">';
  495. echo '<div class="popup" onclick="T3myFunction'.$lp_a.'()"><font color="#000000">'.$array['T3_INFO'].'</font>';
  496. echo '<span class="popuptext" id="T3myPopup'.$lp_a.'">';
  497. $select_color = 1;
  498. while($select_color <= count($td_color)-1) {
  499. echo '<a href="?color='.$td_color[$select_color][1].'&t3='.$array['ID'].'"><button style="width:125px;background-color:#'.$td_color[$select_color][1].';">'.$td_color[$select_color][0].'</button></a>';
  500. $select_color++;
  501. }
  502. echo '<hr>';
  503. echo '<a href="?clear&t3='.$array['ID'].'"><button style="width:125px">'.$button_clear.'</button></a>';
  504. echo '</span></div></td>';
  505. }
  506. if($array['T4_INFO'] == "" && $array['T4_COLOR'] == "") {
  507. echo '<td align="center" width="'.$td_width.'" style="background:#'.$td_color[0].'">'.$array['T4_INFO'].'</td>';
  508. } else {
  509. echo '<td align="center" width="'.$td_width.'" style="background:#'.$array['T4_COLOR'].'">';
  510. echo '<div class="popup" onclick="T4myFunction'.$lp_a.'()"><font color="#000000">'.$array['T4_INFO'].'</font>';
  511. echo '<span class="popuptext" id="T4myPopup'.$lp_a.'">';
  512. $select_color = 1;
  513. while($select_color <= count($td_color)-1) {
  514. echo '<a href="?color='.$td_color[$select_color][1].'&t4='.$array['ID'].'"><button style="width:125px;background-color:#'.$td_color[$select_color][1].';">'.$td_color[$select_color][0].'</button></a>';
  515. $select_color++;
  516. }
  517. echo '<hr>';
  518. echo '<a href="?clear&t4='.$array['ID'].'"><button style="width:125px">'.$button_clear.'</button></a>';
  519. echo '</span></div></td>';
  520. }
  521. if($array['T5_INFO'] == "" && $array['T5_COLOR'] == "") {
  522. echo '<td align="center" width="'.$td_width.'" style="background:#'.$td_color[0].'">'.$array['T5_INFO'].'</td>';
  523. } else {
  524. echo '<td align="center" width="'.$td_width.'" style="background:#'.$array['T5_COLOR'].'">';
  525. echo '<div class="popup" onclick="T5myFunction'.$lp_a.'()"><font color="#000000">'.$array['T5_INFO'].'</font>';
  526. echo '<span class="popuptext" id="T5myPopup'.$lp_a.'">';
  527. $select_color = 1;
  528. while($select_color <= count($td_color)-1) {
  529. echo '<a href="?color='.$td_color[$select_color][1].'&t5='.$array['ID'].'"><button style="width:125px;background-color:#'.$td_color[$select_color][1].';">'.$td_color[$select_color][0].'</button></a>';
  530. $select_color++;
  531. }
  532. echo '<hr>';
  533. echo '<a href="?clear&t5='.$array['ID'].'"><button style="width:125px">'.$button_clear.'</button></a>';
  534. echo '</span></div></td>';
  535. }
  536. if($lp_a > $td_block) {
  537. echo '<td align="center" width="30px" style="background:#CCCCCC"><b><a href="?delete='.$array['ID'].'"><font color="#000000">[<font color="#CC0000">-</font>]</font></a></b></td>';
  538. }
  539. echo '</tr>';
  540. }
  541. echo '<tr><th></th><th></th><th></th><th></th><th></th><th></th><td align="center" width="30px" style="background:#CCCCCC"><b><a href="?more"><font color="#000000">[<font color="#00CC00">+</font>]</font></a></b></td></tr>';
  542. }
  543. ?>
  544. </table>
  545. <br>
  546. <table id="table">
  547. <?php
  548. $rows = mysql_query("SELECT * FROM `".$table."` LIMIT ".$td_limit.";");
  549. if(mysql_num_rows($rows) >= 1) {
  550. echo '<tr>';
  551. echo '<td align="center" style="background:#CCCCCC"><b>'.$td_name[0].'</b></td><td align="center" style="background:#CCCCCC"><b>'.$td_name[6].'</b></td><td align="center" style="background:#CCCCCC"><b>'.$td_name[7].'</b></td><td align="center" style="background:#CCCCCC"><b>'.$td_name[8].'</b></td><td align="center" style="background:#CCCCCC"><b>'.$td_name[9].'</b></td><td align="center" style="background:#CCCCCC"><b>'.$td_name[10].'</b></td>';
  552. echo '</tr>';
  553. while($array = mysql_fetch_array($rows)) {
  554. $lp_b = $lp_b+1;
  555. echo '<tr>';
  556. echo '<td align="center" width="30px" style="background:#CCCCCC"><b>'.$lp_b.'.</b></td>';
  557. if($array['T6_INFO'] == "" && $array['T6_COLOR'] == "") {
  558. echo '<td align="center" width="'.$td_width.'" style="background:#'.$td_color[0].'">'.$array['T6_INFO'].'</td>';
  559. } else {
  560. echo '<td align="center" width="'.$td_width.'" style="background:#'.$array['T6_COLOR'].'">';
  561. echo '<div class="popup" onclick="T6myFunction'.$lp_b.'()"><font color="#000000">'.$array['T6_INFO'].'</font>';
  562. echo '<span class="popuptext" id="T6myPopup'.$lp_b.'">';
  563. $select_color = 1;
  564. while($select_color <= count($td_color)-1) {
  565. echo '<a href="?color='.$td_color[$select_color][1].'&t6='.$array['ID'].'"><button style="width:125px;background-color:#'.$td_color[$select_color][1].';">'.$td_color[$select_color][0].'</button></a>';
  566. $select_color++;
  567. }
  568. echo '<hr>';
  569. echo '<a href="?clear&t6='.$array['ID'].'"><button style="width:125px">'.$button_clear.'</button></a>';
  570. echo '</span></div></td>';
  571. }
  572. if($array['T7_INFO'] == "" && $array['T7_COLOR'] == "") {
  573. echo '<td align="center" width="'.$td_width.'" style="background:#'.$td_color[0].'">'.$array['T7_INFO'].'</td>';
  574. } else {
  575. echo '<td align="center" width="'.$td_width.'" style="background:#'.$array['T7_COLOR'].'">';
  576. echo '<div class="popup" onclick="T7myFunction'.$lp_b.'()"><font color="#000000">'.$array['T7_INFO'].'</font>';
  577. echo '<span class="popuptext" id="T7myPopup'.$lp_b.'">';
  578. $select_color = 1;
  579. while($select_color <= count($td_color)-1) {
  580. echo '<a href="?color='.$td_color[$select_color][1].'&t7='.$array['ID'].'"><button style="width:125px;background-color:#'.$td_color[$select_color][1].';">'.$td_color[$select_color][0].'</button></a>';
  581. $select_color++;
  582. }
  583. echo '<hr>';
  584. echo '<a href="?clear&t7='.$array['ID'].'"><button style="width:125px">'.$button_clear.'</button></a>';
  585. echo '</span></div></td>';
  586. }
  587. if($array['T8_INFO'] == "" && $array['T8_COLOR'] == "") {
  588. echo '<td align="center" width="'.$td_width.'" style="background:#'.$td_color[0].'">'.$array['T8_INFO'].'</td>';
  589. } else {
  590. echo '<td align="center" width="'.$td_width.'" style="background:#'.$array['T8_COLOR'].'">';
  591. echo '<div class="popup" onclick="T8myFunction'.$lp_b.'()"><font color="#000000">'.$array['T8_INFO'].'</font>';
  592. echo '<span class="popuptext" id="T8myPopup'.$lp_b.'">';
  593. $select_color = 1;
  594. while($select_color <= count($td_color)-1) {
  595. echo '<a href="?color='.$td_color[$select_color][1].'&t8='.$array['ID'].'"><button style="width:125px;background-color:#'.$td_color[$select_color][1].';">'.$td_color[$select_color][0].'</button></a>';
  596. $select_color++;
  597. }
  598. echo '<hr>';
  599. echo '<a href="?clear&t8='.$array['ID'].'"><button style="width:125px">'.$button_clear.'</button></a>';
  600. echo '</span></div></td>';
  601. }
  602. if($array['T9_INFO'] == "" && $array['T9_COLOR'] == "") {
  603. echo '<td align="center" width="'.$td_width.'" style="background:#'.$td_color[0].'">'.$array['T9_INFO'].'</td>';
  604. } else {
  605. echo '<td align="center" width="'.$td_width.'" style="background:#'.$array['T9_COLOR'].'">';
  606. echo '<div class="popup" onclick="T9myFunction'.$lp_b.'()"><font color="#000000">'.$array['T9_INFO'].'</font>';
  607. echo '<span class="popuptext" id="T9myPopup'.$lp_b.'">';
  608. $select_color = 1;
  609. while($select_color <= count($td_color)-1) {
  610. echo '<a href="?color='.$td_color[$select_color][1].'&t9='.$array['ID'].'"><button style="width:125px;background-color:#'.$td_color[$select_color][1].';">'.$td_color[$select_color][0].'</button></a>';
  611. $select_color++;
  612. }
  613. echo '<hr>';
  614. echo '<a href="?clear&t9='.$array['ID'].'"><button style="width:125px">'.$button_clear.'</button></a>';
  615. echo '</span></div></td>';
  616. }
  617. if($array['T10_INFO'] == "" && $array['T10_COLOR'] == "") {
  618. echo '<td align="center" width="'.$td_width.'" style="background:#'.$td_color[0].'">'.$array['T10_INFO'].'</td>';
  619. } else {
  620. echo '<td align="center" width="'.$td_width.'" style="background:#'.$array['T10_COLOR'].'">';
  621. echo '<div class="popup" onclick="T10myFunction'.$lp_b.'()"><font color="#000000">'.$array['T10_INFO'].'</font>';
  622. echo '<span class="popuptext" id="T10myPopup'.$lp_b.'">';
  623. $select_color = 1;
  624. while($select_color <= count($td_color)-1) {
  625. echo '<a href="?color='.$td_color[$select_color][1].'&t10='.$array['ID'].'"><button style="width:125px;background-color:#'.$td_color[$select_color][1].';">'.$td_color[$select_color][0].'</button></a>';
  626. $select_color++;
  627. }
  628. echo '<hr>';
  629. echo '<a href="?clear&t10='.$array['ID'].'"><button style="width:125px">'.$button_clear.'</button></a>';
  630. echo '</span></div></td>';
  631. }
  632. if($lp_b > $td_block) {
  633. echo '<td align="center" width="30px" style="background:#CCCCCC"><b><a href="?delete='.$array['ID'].'"><font color="#000000">[<font color="#CC0000">-</font>]</font></a></b></td>';
  634. }
  635. echo '</tr>';
  636. }
  637. echo '<tr><th></th><th></th><th></th><th></th><th></th><th></th><td align="center" width="30px" style="background:#CCCCCC"><b><a href="?more"><font color="#000000">[<font color="#00CC00">+</font>]</font></a></b></td></tr>';
  638. }
  639. ?>
  640. </table>
  641. <?php
  642. $rows = mysql_query("SELECT * FROM `".$table."` LIMIT ".$td_limit.";");
  643. if(mysql_num_rows($rows) == 0) {
  644. echo '<a href="?more"><button>'.$button_create.'</button></a>';
  645. }
  646. ?>
  647. <br>
  648. </center>
  649. </body>
  650. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!