function set_jury($nazov) { if ($link = db_connect()) { $sql = "UPDATE organisators as o SET validated = '1' WHERE o.user_id='" . $nazov . "'"; // echo "sql = $sql <br>"; $result = mysqli_query($link, $sql); // vykonaj dopyt if ($result) { // dopyt sa podarilo vykonať echoMessage('m-acc-validated'); } else { // dopyt sa NEpodarilo vykonať! echoError('err-acc-validation'); } mysqli_close($link); } else { // NEpodarilo sa spojiť s databázovým serverom! echoError('err-db-connection-fail'); } }
function set_date($contextid, $start_dat, $end_dat) { if ($link = db_connect()) { $sql = "UPDATE assignments as a SET begin = '" . $start_dat . "' , end='" . $end_dat . "' WHERE a.context_id='" . $contextid . "'"; // echo "sql = $sql <br>"; $result = mysqli_query($link, $sql); // vykonaj dopyt if ($result) { // dopyt sa podarilo vykonať echoMessage('m-date-changed'); } else { // dopyt sa NEpodarilo vykonať! echoError('err-date-changing'); } mysqli_close($link); } else { // NEpodarilo sa spojiť s databázovým serverom! echoError('err-db-connection-fail'); } }
<!-- LINKS DHTMLX --> <script src="<?php echo $dhtmlx; ?> dhtmlxGrid/codebase/excells/dhtmlxgrid_excell_link.js"></script> <script language="javascript" src="<?php echo $jquery; ?> jquery.js"></script> </head> <body> <div style="width:100%; height:7%"><h3 style="font-family: verdana; font-style:italic; color:#B0B0B0">Listado de Marcas <div id='divMsje' style="float: right;"><?php echoMessage(); ?> </div></h3> <hr style="background-color:#EBEAEA; border:medium none; color:#5A83BA; height:1px; "/> </div> <div> </div> <div> <img src="<?php echo $url_images; ?> delete.png" title="Eliminar marca" style="vertical-align: middle;cursor: pointer;" height="16" width="16" onclick="eliminar();"/> <img src="<?php echo $url_images; ?>
<div> <?php echoMessage("index.about1"); ?> </div> <div> <h2> <?php echo createLink("general", "index.whatsnew"); ?> </h2> </div> <div> <img class="newsimage" src="images/newsimage1.jpg"/> </div> <div> <?php echoMessage("index.news.n1"); ?> </div> <div> <?php echoMessage("index.news.about2"); ?> </div> </div>
public function addBestSolutionOpen($pom) { if ($link = db_connect()) { $sql = "UPDATE solutions as s , contexts c, teams t SET best = 0 WHERE c.context_id = s.context_id AND t.sk_league =0\nAND t.user_id = c.user_id AND s.assignment_id = " . $this->id; $result = mysqli_query($link, $sql); $sql = "UPDATE solutions as s , contexts c, teams t SET best = 1 WHERE c.context_id = s.context_id AND s.assignment_id = '" . $this->id . "' AND t.user_id =c.user_id AND c.user_id =" . $pom; $result = mysqli_query($link, $sql); if ($result) { echoMessage('m-best-solution-selected'); ?> <meta http-equiv="refresh" content="1;url=bestSolution.php?id=<?php echo $this->id; ?> "> <?php } } }
public function deleteAttachments1($conn, $prilohy, $kde) { foreach ($prilohy as $value) { $pole = explode(";", $value); $sql = "SELECT * FROM " . $pole[0] . "s WHERE " . $pole[0] . "_id='" . $pole[1] . "'"; $result = mysqli_query($conn, $sql); if ($result) { if ($pole[0] != "video") { $attachment = mysqli_fetch_array($result); $ext = pathinfo($attachment['original_name'], PATHINFO_EXTENSION); } $sql = "DELETE FROM " . $pole[0] . "s WHERE " . $pole[0] . "_id='" . $pole[1] . "'"; $result = mysqli_query($conn, $sql); if ($result) { if ($pole[0] != "video") { if ($pole[0] == "image") { if (unlink($kde . $pole[0] . "s/big/" . $pole[1] . "." . $ext) && unlink($kde . $pole[0] . "s/small/" . $pole[1] . "." . $ext)) { echoMessage("m-attachment-deleted"); } else { echoError("err-attachment-deletion"); } } else { if (unlink($kde . $pole[0] . "s/" . $pole[1] . "." . $ext)) { echoMessage("m-attachment-deleted"); } else { echoError("err-attachment-deletion"); } } } } else { echoMessage("m-attachment-deleted"); } } else { echoError("err-attachment-db-deletion", mysqli_error($conn)); } } /*else { echoError("err-attachment-not-in-db"); } }*/ }
function delete_assignment($id) { if ($link = db_connect()) { $sql = "SELECT context_id, text_id_name, text_id_description FROM assignments WHERE context_id = " . $id; $result = mysqli_query($link, $sql); if ($result && mysqli_num_rows($result) != 0) { $assignment = mysqli_fetch_array($result); $sql = "DELETE FROM texts WHERE text_id = " . $assignment['text_id_name'] . " OR text_id = " . $assignment['text_id_description']; if (!mysqli_query($link, $sql)) { echoError('err-assignment-deleting'); return; } $sql = "DELETE FROM videos WHERE context_id = " . $assignment['context_id']; if (!mysqli_query($link, $sql)) { echoError('err-assignment-deleting'); return; } $sql = "DELETE FROM images WHERE context_id = " . $assignment['context_id']; if (!mysqli_query($link, $sql)) { echoError('err-assignment-deleting'); return; } $sql = "DELETE FROM programs WHERE context_id = " . $assignment['context_id']; if (!mysqli_query($link, $sql)) { echoError('err-assignment-deleting'); return; } $sql = "DELETE FROM assignments WHERE context_id = " . $assignment['context_id']; if (!mysqli_query($link, $sql)) { echoError('err-assignment-deleting'); return; } if (!deleteDir(dirname(__FILE__) . "/../attachments/assignments/" . $assignment['context_id'])) { echoError('err-assignment-deleting'); return; } echoMessage('m-assignment-deleted'); } else { echoError('err-assignment-deleting'); } } else { echoError('err-db-connection-fail'); } }
echo $udaje["description"]; } ?> </textarea></td> </tr> <tr> <td><input type="radio" checked name="liga" value=1<?php if (isset($udaje['sk_league']) && $udaje["sk_league"] == 1) { echo ' checked'; } ?> ><span data-trans-key="edit-team-form"></span></td> <td><input type="radio" name="liga" value=0<?php if (isset($udaje['sk_league']) && $udaje["sk_league"] == 0) { echo ' checked'; } ?> ><span data-trans-key="edit-team-form"></span></td> </tr> <tr> <td><input type="submit" name="save" data-trans-key="edit-team-form"></td> </tr> </table> </form> <?php echoMessage($edit->GetMessage()); $err = $val->GetErrorMessage(); echoError(!empty($err) ? $err : $edit->GetErrorMessage()); page_footer();
<body class="body" title="Irish Bar"> <div class="webcontainer"> <div class="headerbanner"> <img src="images/banner.gif" alt="Irish Bar"/> </div> <div class="logo"> <img src="images/logo.gif" alt="Irish Pubs"/> </div> <div> <?php include "navigation.php"; ?> </div> <?php if (isDemo()) { echo '<div class="demomode">'; echoMessage("admin.demo"); echo "</div>"; } include "address.php"; include "sportpreview.php"; ?> <div class="centercontainer" title="Irish Pubs Germany">
echo ' checked'; } ?> ><span data-trans-key="reg-form"></span></td> </tr> <tr> <td><input type="submit" name="registrovat" data-trans-key="reg-form"></td> </tr> </table> </form> <script> $("[name=type]").change(function (){ var disabled = $("[name=type]:checked").val() == 1; $("#uname").attr("disabled", disabled); $("#os").attr("disabled", disabled); $("[name=liga]").attr("disabled", disabled); }); $(document).ready(function(){ $("[name=type]").change(); }); </script> <?php echoMessage($reg->GetMessage()); $err = $val->GetErrorMessage(); echoError(!empty($err) ? $err : $reg->GetErrorMessage()); page_footer(); ?>
<?php include "navigation.php"; ?> <div id="wb"> <?php if (isDemo()) { echo '<div class="demomode">'; echoMessage("admin.demo"); echo "</div>"; } if (adminMode()) { echo '<div id="admincontrolcontainer">'; createNavigationLinks("navlinks", 1); echo '<div class="clear"></div>'; echo '</div>'; } ?> <div id="centercontainer"> <?php if (messageMode()) { echo '<div class="editwebtitle">'; echoMessage("website.title"); echo '</div>'; } ?>
if (!isset($_POST["stop"]) || empty($_POST["stop"])) { echoError("err-no-end-date"); } else { if (!isset($_POST["id"]) || empty($_POST["id"])) { echoError("err-no-assignment-chosen"); } else { $start = date("Y-m-d H:i", strtotime($_POST["start"])); $end = date("Y-m-d H:i", strtotime($_POST["stop"])); if ($start >= $end) { echoError("err-time-logic"); } else { if ($link = db_connect()) { $sql = "UPDATE assignments SET begin = '" . $start . "', end='" . $end . "' WHERE context_id='" . $_POST["id"] . "'"; $result = mysqli_query($link, $sql); if ($result) { echoMessage('m-date-changed'); } else { echoError('err-date-changing'); } mysqli_close($link); } else { echoError('err-db-connection-fail'); } } } } } } else { if ($action == 2 && isUserTypeLogged("Administrator")) { if (!isset($_POST["id"]) || empty($_POST["id"])) { echoError("err-no-assignment-chosen");