function todolists() { if (isset($_POST['create'])) { $this->createList($_POST['title'], $_POST['project']); } if (isset($_POST['delete'])) { $tdid = $this->db->clean($_POST['delete'], '', ''); $this->db->del("todo_main", "`id`='{$tdid}'", 1); $this->db->del("todo_list", "`tid`='{$tdid}'"); Main::message("To-do deleted."); } ?> <table width="90%" id="list" class="tablesorter" border="0" align="center" cellpadding="0" cellspacing="0"> <thead> <tr> <td><div id="headings">Список необходимых нововведений</div></td> </tr> </thead> <tbody> <tr class="L2"> <td> <h3> <?php if (REGISTERED == 0 || $this->user->getUID() > 0) { ?> <form name="" method="POST" action="">Создать список: <input name="title" /> <select name="project"> <?php $tpr = $this->db->query("SELECT * FROM projects ORDER BY `name` ASC"); while ($r = mysql_fetch_array($tpr)) { echo '<option value="' . $r['id'] . '">' . $r['name'] . '</option>'; } ?> </select><input type="submit" name="create" value="Создать" /> </form></h3> <script> function addTo(id){ <?php $addthis = "<div id='item_" . $r["id"] . "'> <input type='checkbox' name='' onclick='finish(" . $r["id"] . ");''> "; ?> var itemvalue = document.getElementById('title'+id).value; $.post('ajax.php', { addtodo: '1', id: id, item: document.getElementById('title'+id).value, username: '******', password: '******' }, function(data){ $('#project'+id).append("<div id='item_"+data+"'><input type='checkbox' name='' onclick='finish("+data+");'> " + itemvalue + '</div>'); } ); document.getElementById('title'+id).value=''; } function finish(id){ $('#item_'+id).fadeOut(); $.post('ajax.php', { markfinish: '1', id: id, username: '******', password: '******' } ); } function deletetd(id){ var c = confirm("Удалить этот список?"); if(c) document.getElementById('delete'+id).submit(); } </script> <?php } ?> <br><br> <div id="todo"> <?php $todos = $this->db->query("SELECT * FROM todo_main ORDER BY id DESC"); while ($r = mysql_fetch_array($todos)) { echo '<h3>' . $r['title']; // check to see if they're admin if ($this->user->adminCheck()) { echo "<form name='' style='margin: 0; padding: 0; float: left; ' method='post' action='' id='delete{$r['id']}'><input type='hidden' name='delete' value='{$r['id']}' /></form><input type='image' src='images/bin_closed.png' onclick='deletetd({$r['id']});' name='delete' />"; } echo '</h3>'; ?> <?php if (REGISTERED == 0 || $this->user->getUID() > 0) { ?> <div id="itemadd"> <input name="title" id="title<?php echo $r['id']; ?> " class="quick" style="width: 300px;" /> <input type="hidden" name="project" value="<?php echo $r['id']; ?> " /> <input type="submit" name="add" style="width: 90px;" onclick="addTo(<?php echo $r['id']; ?> )" value="Добавить" /> </div> <?php } ?> <div id="project<?php echo $r['id']; ?> " style='margin-left: 65px;'> <?php $tdlist = $this->db->query("SELECT * FROM todo_list WHERE tid='" . $r["id"] . "' AND status='0' ORDER BY id DESC"); while ($t = mysql_fetch_array($tdlist)) { echo "<div id='item_" . $t["id"] . "'>"; if (REGISTERED == 0 || $this->user->getUID() > 0) { echo "<input type='checkbox' name='' onclick='finish({$t['id']});'> "; } echo $t['content'] . "</div>"; } ?> </div> <?php echo '<hr>'; } ?> </div> </td> </tr> </tbody> </table> <?php }
function bblist($type = -1) { if (isset($_POST['deleterer'])) { $tdid = $this->db->clean($_POST['deleterer'], '', ''); $this->db->del("list", "`id`='{$tdid}'", 1); Main::message("Report deleted."); } if (isset($_GET["page"])) { $page = $_GET["page"]; } else { $page = ""; } if (isset($_GET['specialrefiner'])) { $_SESSION['esql'] = ""; $srf = $_GET['specialrefiner']; if ($srf == "open") { $_SESSION['esql'] = "AND `status`='1'"; } elseif ($srf == "closed") { $_SESSION['esql'] = "AND `status`='0'"; } elseif ($srf == "all") { $_SESSION['esql'] = ""; } elseif (is_numeric($srf)) { $_SESSION['esql'] = "AND `project`='" . $this->db->clean($srf, '', 'num') . "'"; } } if (!isset($_SESSION['esql'])) { $_SESSION['esql'] = ""; } /* Handle paging */ /* if( isset($_GET["page"]) ) $_GET["page"]=$_GET["page"]; else $_GET["page"] = 1; */ if (isset($_GET["page"])) { $page = $_GET["page"]; $lower = $page * $this->db->pagenums - $this->db->pagenums; $limit = "LIMIT {$lower}," . $this->db->pagenums; } else { $limit = "LIMIT 0," . $this->db->pagenums; } if ($page == 1) { $limit = "LIMIT 0," . $this->db->pagenums; } if ($type == 0) { $this->db->query("SELECT * FROM list WHERE `type`='0' AND `parent`='0' " . $_SESSION['esql'] . " ORDER BY `id` DESC {$limit};"); } if ($type == 1) { $this->db->query("SELECT * FROM list WHERE `type`='1' AND `parent`='0' " . $_SESSION['esql'] . " ORDER BY `id` DESC {$limit};"); } if ($type == -1) { $this->db->query("SELECT * FROM list WHERE `parent`='0' " . $_SESSION['esql'] . " ORDER BY `id` DESC {$limit};"); } $cssclass = "L1"; while ($r = $this->db->fetch_array()) { if ($cssclass == "L1") { $cssclass = "L2"; } elseif ($cssclass == "L2") { $cssclass = "L1"; } ?> <script> function deletetd(id){ var c = confirm("Удалить этот список?"); if(c) document.getElementById('delete'+id).submit(); } </script> <tr class="<?php echo $cssclass; ?> "> <td align="center"><?php echo $r["id"]; ?> </td> <td width="16" align="center"><div style='position: relative;'><img src="<?php echo $this->img($r["type"]); ?> " style='' /> <?php if ($r["status"] == 0) { ?> <img id=cansel src="images/cancel.png"/><?php } ?> </div></td> <td><a href="?cmd=view&id=<?php echo $r["id"]; ?> &open=<?php echo $r["status"]; ?> "><?php if ($r["title"] == "") { echo "[Без Названия]"; } else { echo $r["title"]; } ?> </a> <?php $comments = $this->db->first("SELECT COUNT(*) FROM list WHERE parent=" . $r["id"] . ";"); if ($comments != 0) { echo "<font color=#A9A9A9 size=1>[Комментариев: {$comments}]</font>"; } ?> </td> <td align="center"><?php if ($r["status"] == 1) { echo "Открыто"; } else { echo "Закрыто"; } ?> </td> <?php /* <td> Taken out to reduce clutter if($r[by] == 0) echo "Гость"; else echo $this->user->uidToName($r[by]); </td> */ ?> <td align="center"><?php echo $this->ProjectIDtoName($r['project']); ?> </td> <td align="center" class="pri<?php echo $r["priority"]; ?> " id="<?php echo $r["priority"]; ?> "><?php echo $this->adminPriHover($r["id"], $r["priority"]); ?> </td> <td align="center"><?php echo $this->the_date($r["started"]); ?> </td> <td><?php if ($r["finished"] == 0) { echo "Никогда"; } else { echo $this->the_date($r["finished"]); } ?> </td> <?php if ($this->user->adminCheck()) { echo "<td><form name='' style='margin: 0; padding: 0; float: left; ' method='post' action='' id='delete{$r['id']}'><input type='hidden' name='deleterer' value='{$r['id']}' /></form><input type='image' src='images/bin_closed.png' onclick='deletetd({$r['id']});' name='delete' /></td>"; } ?> </tr><?php } ?> </tbody> <?php if (REGISTERED == 0 || isset($_SESSION["userName"])) { $this->quickadd(); } ?> </table> <div style="width: 100%;" width="100%" id="subnav"> <?php if ($type == 0) { $this->db->paginate("SELECT * FROM list WHERE `type`='0' AND `parent`='0' " . $_SESSION['esql'] . " ORDER BY `id` DESC;"); } if ($type == 1) { $this->db->paginate("SELECT * FROM list WHERE `type`='1' AND `parent`='0' " . $_SESSION['esql'] . " ORDER BY `id` DESC;"); } if ($type == -1) { $this->db->paginate("SELECT * FROM list WHERE `parent`='0' " . $_SESSION['esql'] . " ORDER BY `id` DESC;"); } ?> </div> <div style="clear:both;"/></div> <?php }
<script type="text/javascript" src="js/jq-sort.js"></script> </head> <body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <div class="clear"></div> <div align="center"> <div id="contentArea" width="91%"> <h1>Installing BlueBug...</h1> <?php if ($_POST) { $mydb->query_insert("users", array('id' => null, 'username' => $_POST[username], 'password' => md5($_POST[password]), 'email' => $_POST[email], 'acl' => 0)); $main->message("Admin user account created"); echo "<h2 style='color: red;'>Make sure you delete this file or anyone can create another admin user.</h2>"; } else { $listSQL = "CREATE TABLE `list` (\r\n `id` int(11) NOT NULL auto_increment,\r\n `project` int(11) NOT NULL default '0',\r\n `parent` int(11) NOT NULL default '0',\r\n `title` varchar(200) NOT NULL default '',\r\n `report` longtext NOT NULL,\r\n `status` tinyint(1) NOT NULL default '0',\r\n `by` int(11) NOT NULL default '0',\r\n `priority` tinyint(1) NOT NULL default '0',\r\n `type` tinyint(1) NOT NULL default '0',\r\n `started` int(11) NOT NULL default '0',\r\n `finished` int(11) NOT NULL default '0',\r\n `due` int(11) NOT NULL default '0',\r\n `assigned` int(11) NOT NULL default '0',\r\n KEY `id` (`id`,`title`),\r\n KEY `priority` (`priority`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=latin1; "; $mydb->query($listSQL); if (strlen($mydb->errorno) == 0) { echo "<b>Bug table created....</b><br/>"; } $projectSQL = "\r\nCREATE TABLE `projects` (\r\n `id` int(11) NOT NULL auto_increment,\r\n `name` varchar(255) NOT NULL default '',\r\n `mini` varchar(255) NOT NULL default '',\r\n `description` longtext NOT NULL,\r\n UNIQUE KEY `id` (`id`),\r\n KEY `subname` (`mini`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=latin1; "; $mydb->query($projectSQL); if (strlen($mydb->errorno) == 0) { echo "<b>Project table created....</b><br/>"; } $userSQL = "\r\nCREATE TABLE `users` (\r\n `id` int(11) NOT NULL auto_increment,\r\n `username` varchar(100) NOT NULL default '',\r\n `password` varchar(100) NOT NULL default '',\r\n `email` varchar(100) NOT NULL default '',\r\n `acl` tinyint(2) NOT NULL default '0',\r\n UNIQUE KEY `id` (`id`),\r\n KEY `username` (`username`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=latin1;\r\n"; $mydb->query($userSQL); if (strlen($mydb->errorno) == 0) {
<?php $todoSQL = "CREATE TABLE `todo_main` (\n`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,\n`title` VARCHAR( 100 ) NOT NULL ,\n`project` INT( 11 ) NOT NULL ,\nINDEX ( `id` )\n) ENGINE = MYISAM; "; $mydb->query($todoSQL); if (strlen($mydb->errorno) == 0) { echo "<b>ToDo_main table created....</b><br/>"; } $todoLSQL = " CREATE TABLE `todo_list` (\n`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,\n`content` TEXT NOT NULL ,\n`status` INT( 2 ) NOT NULL ,\nINDEX ( `id` )\n) ENGINE = MYISAM;"; $mydb->query($todoLSQL); if (strlen($mydb->errorno) == 0) { echo "<b>ToDo_List table created....</b><br/>"; } $projModSQL = "ALTER TABLE `projects` ADD `client_exec` VARCHAR( 255 ) NOT NULL ;"; $mydb->query($projModSQL); $mydb->query("ALTER TABLE `projects` ADD `github` VARCHAR( 255 ) NOT NULL ;"); $mydb->query("ALTER TABLE `list` ADD `attachment` VARCHAR( 100 ) NOT NULL ;"); $main->message("BlueBug tables updated."); ?> <?php ?> <div style="clear: both; height: 100px;"></div> </div> <div id="bottomContent" width="90%"> <img src="/images/index_15.gif" id="cLeft" /> <img src="/images/index_18.gif" id="cRight" />
echo "Ваше сообщение было опубликовано, но вложение не было загружено. Запрещенный тип файла."; $file_name = ""; $target = ""; } } else { } $bugData = array('id' => 'null', 'project' => $this->db->first("SELECT `project` FROM list WHERE `id`='{$bugid}'", 0, 0), 'parent' => $bugid, 'title' => $_POST["subject"], 'report' => nl2br(strip_tags($_POST["report"])), 'status' => '0', 'by' => $reportedby, 'priority' => 0, 'type' => 0, 'started' => time(), 'finished' => '0', 'due' => '0', 'assigned' => '0', 'character' => $_POST["character"], 'attachment' => $target . $file_name); $this->db->query_insert('list', $bugData); $this->message("<center><h3>Комментарий добавлен.</h3></center>"); unset($_POST); } } elseif (isset($_POST['deletecomm'])) { //check if its parent ticket $commentidid = $this->db->clean($_POST["deletecomm"], '', ''); $this->db->del("list", "id='{$commentidid}'", '1'); Main::message("Запись удалена."); } ?> <script> function deletetd(id){ var c = confirm("Удалить этот список?"); if(c) document.getElementById('delete'+id).submit(); } </script> <?php // view original ticket if ($bugid > 0) { $bugView->original($bugid); $bugView->responses($bugid);