* This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php"; include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php"; user_enforce_has_access($Bickerdike_id); $start = $_POST['start']; $end = $_POST['end']; $start_sqlsafe = mysqli_real_escape_string($cnnBickerdike, $start); $end_sqlsafe = mysqli_real_escape_string($cnnBickerdike, $end); ?> <!-- Gets surveys within the date range specified for all types of surveys. Returns a table of average responses for each question. --> <table class="all_projects"> <tr> <th></th> <th colspan="3">Average Responses</th> <!-- would it make sense to do median/mode? --> </tr> <?php
* This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php"; include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php"; user_enforce_has_access($Bickerdike_id, $AdminAccess); //need to first take care of any possible foreign key constraints: //activities_users, participant survey responses, program dates users, programs users, user health data // //Then finally delete the user him/herself. This is probably going to be phased out once the merge //tool is in use. // include "../include/dbconnopen.php"; $user_id_sqlsafe = mysqli_real_escape_string($cnnBickerdike, $_POST['user_id']); $delete_activities_query_sqlsafe = "DELETE FROM Activities_Users WHERE User_ID='" . $user_id_sqlsafe . "'"; $delete_surveys_query_sqlsafe = "DELETE FROM Participant_Survey_Responses WHERE User_ID='" . $user_id_sqlsafe . "'"; $delete_attendance_query_sqlsafe = "DELETE FROM Program_Dates_Users WHERE User_ID='" . $user_id_sqlsafe . "'"; $delete_programs_query_sqlsafe = "DELETE FROM Programs_Users WHERE User_ID='" . $user_id_sqlsafe . "'"; $delete_health_query_sqlsafe = "DELETE FROM User_Health_Data WHERE User_ID='" . $user_id_sqlsafe . "'"; $delete_user_query_sqlsafe = "DELETE FROM Users WHERE User_ID='" . $user_id_sqlsafe . "'"; mysqli_query($cnnBickerdike, $delete_activities_query_sqlsafe);
mysqli_query($cnnEnlace, $delete_participant); include "../include/dbconnclose.php"; //delete participant from future expectations $delete_participant = "DELETE FROM Participants_Future_Expectations WHERE Participant_ID='" . $participant_id_sqlsafe . "'"; echo $delete_participant; include "../include/dbconnopen.php"; mysqli_query($cnnEnlace, $delete_participant); include "../include/dbconnclose.php"; //delete participant from referrals $delete_participant = "DELETE FROM Referrals WHERE Participant_ID='" . $participant_id_sqlsafe . "'"; echo $delete_participant; include "../include/dbconnopen.php"; mysqli_query($cnnEnlace, $delete_participant); include "../include/dbconnclose.php"; } elseif ($_POST['action'] == 'delete_participant_from_program') { user_enforce_has_access($Enlace_id, $AdminAccess); date_default_timezone_set('America/Chicago'); include "../include/dbconnopen.php"; $link_id_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['link_id']); //delete participant from program $delete_participant_from_program = "DELETE FROM Participants_Programs WHERE Participant_Program_ID='" . $link_id_sqlsafe . "'"; echo $delete_participant_from_program; mysqli_query($cnnEnlace, $delete_participant_from_program); include "../include/dbconnclose.php"; } elseif ($_POST['action'] == 'drop') { date_default_timezone_set('America/Chicago'); include "../include/dbconnopen.php"; $link_id_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['link_id']); $drop_from_program = "UPDATE Participants_Programs SET Date_Dropped='" . date('Y-m-d') . "' WHERE Participant_Program_ID='" . $link_id_sqlsafe . "'"; echo $drop_from_program; mysqli_query($cnnEnlace, $drop_from_program);
* This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ include_once $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php"; include_once $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php"; user_enforce_has_access($TRP_id); ?> <link href="/styles/styles.css" rel="stylesheet" type="text/css" /> <link href="/include/jquery/1.9.1/css/redmond/jquery-ui-1.8.23.custom.css" rel="stylesheet" type="text/css" /> <script src="/include/jquery/1.9.1/js/jquery-1.8.2.js" type="text/javascript"></script> <script src="/include/jquery/1.9.1/development-bundle/ui/jquery.ui.core.js" type="text/javascript"></script> <script src="/include/jquery/1.9.1/development-bundle/ui/jquery.ui.widget.js" type="text/javascript"></script> <script src="/include/jquery/1.9.1/development-bundle/ui/jquery.ui.datepicker.js" type="text/javascript"></script> <!-- adds to a calendar to text boxes for consistent date format --> <script> //on search events $(function() { $(".hasDatepickers").datepicker({dateFormat: "mm/dd/yy", changeYear: true,
* This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ include_once $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php"; include_once $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php"; user_enforce_has_access($LSNA_id); include "../../header.php"; include "../header.php"; include "../include/datepicker.php"; //filter by dates and funder(s) (probably by checkbox?) // show table of activities in funding period ?> <h3>Search Events by Funder</h3> <table class="all_projects"> <form method = "post" action="<?php echo $_SERVER['PHP_SELF']; ?> " > <tr> <th class="all_projects">Funder:</th><td>
<?php /* * TTM is a web application to manage data collected by community organizations. * Copyright (C) 2014, 2015 Local Initiatives Support Corporation (lisc.org) * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php"; include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php"; user_enforce_has_access($LSNA_id, $DataEntryAccess); /*after a participant already exists, adding them to another institution (or vice versa) */ include "../include/dbconnopen.php"; $inst_sqlsafe = mysqli_real_escape_string($cnnLSNA, $_POST['inst']); $parti_sqlsafe = mysqli_real_escape_string($cnnLSNA, $_POST['parti']); $link_query = "INSERT INTO Institutions_Participants (Institution_ID, Participant_ID)\r\n VALUES('" . $inst_sqlsafe . "', '" . $parti_sqlsafe . "')"; mysqli_query($cnnLSNA, $link_query); include "../include/dbconnclose.php";
* This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ include_once $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php"; include_once $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php"; user_enforce_has_access($SWOP_id, $DataEntryAccess); include "../../header.php"; include "../header.php"; include "reports_menu.php"; //include ($_SERVER['DOCUMENT_ROOT']."/include/block_group_finder.php"); ?> <!-- export information from the database. Will change once Taryn gets back to me with the compound exports she needs: --> <h2>Export All</h2> <table class="all_projects"> <tr> <td> <h4>Export Everything </h4> <table class="inner_table">
* This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php"; include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php"; user_enforce_has_access($SWOP_id); //I'm going to follow the same partial search mechanism that I've used before. If a search term //is chosen, then I'll use it for searching. One thing I may have to change is allowing them to search for the //null - that is, find people who /don't have/ a primary institution or something like that. if ($_POST['inst'] != 0) { $institution_sqlsafe = " AND Institution_ID='" . mysqli_real_escape_string($cnnSWOP, $_POST['inst']) . "' AND Is_Primary=1 "; $join_inst_sqlsafe = " INNER JOIN Institutions_Participants ON Participants.Participant_ID=Institutions_Participants.Participant_ID "; } else { $institution_sqlsafe = ""; $join_inst_sqlsafe = ""; } $join_inst_sqlsafe = " INNER JOIN Institutions_Participants ON Participants.Participant_ID=Institutions_Participants.Participant_ID "; if ($_POST['type'] != 0) { $type_sqlsafe = " AND member_type.Member_Type='" . mysqli_real_escape_string($cnnSWOP, $_POST['type']) . "' "; $member_type_join_sqlsafe = " INNER JOIN \r\n (SELECT Active, Participant_ID, max(Date_Changed) as lastdate FROM Pool_Status_Changes\r\n GROUP BY Participant_ID) lasttypestatus\r\n ON member_type.Date_Changed=lasttypestatus.lastdate "; } else {
* This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php"; include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php"; user_enforce_has_access($Enlace_id); /*Add a new program quality survey here: */ include "../../header.php"; include "../header.php"; include "../classes/program.php"; $survey_program = new Program(); $survey_program->load_with_program_id($_GET['prog']); include "../include/dbconnopen.php"; $prog_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_GET['prog']); ?> <script type="text/javascript"> $(document).ready(function() { $('#programs_selector').addClass('selected'); $('#ajax_loader').hide(); });
include "../include/dbconnopen.php"; $make_household_sqlsafe = "INSERT INTO Households (Household_Name) VALUES ('" . mysqli_real_escape_string($cnnSWOP, $_POST['household']) . "')"; mysqli_query($cnnSWOP, $make_household_sqlsafe); $last_id = mysqli_insert_id($cnnSWOP); $add_to_household_sqlsafe = "INSERT INTO Households_Participants(Household_ID, Participant_ID, Head_of_Household) \r\n VALUES ('" . $last_id . "', '" . mysqli_real_escape_string($cnnSWOP, $_POST['participant']) . "', '" . mysqli_real_escape_string($cnnSWOP, $_POST['head']) . "')"; echo $add_to_household_sqlsafe; mysqli_query($cnnSWOP, $add_to_household_sqlsafe); include "../include/dbconnclose.php"; } elseif ($_POST['action'] == 'add') { /* add a new person to an existing household: */ include "../include/dbconnopen.php"; $add_to_household_sqlsafe = "INSERT INTO Households_Participants(Household_ID, Participant_ID, Head_of_Household) \r\n VALUES ('" . mysqli_real_escape_string($cnnSWOP, $_POST['household']) . "', '" . mysqli_real_escape_string($cnnSWOP, $_POST['participant']) . "', '" . mysqli_real_escape_string($cnnSWOP, $_POST['head']) . "')"; echo $add_to_household_sqlsafe; mysqli_query($cnnSWOP, $add_to_household_sqlsafe); include "../include/dbconnclose.php"; } elseif ($_POST['action'] == 'edit') { /* change household name. */ include "../include/dbconnopen.php"; $change_name_sqlsafe = "UPDATE Households SET Household_Name='" . mysqli_real_escape_string($cnnSWOP, $_POST['name']) . "' WHERE New_Household_ID='" . mysqli_real_escape_string($cnnSWOP, $_POST['id']) . "'"; echo $change_name_sqlsafe; mysqli_query($cnnSWOP, $change_name_sqlsafe); include "../include/dbconnclose.php"; } elseif ($_POST['action'] == 'delete') { user_enforce_has_access($SWOP_id, $AdminAccess); /* remove a person from a household */ $remove_household_sqlsafe = "DELETE FROM Households_Participants WHERE Households_Participants_ID='" . mysqli_real_escape_string($cnnSWOP, $_POST['id']) . "'"; echo $remove_household_sqlsafe; include "../include/dbconnopen.php"; mysqli_query($cnnSWOP, $remove_household_sqlsafe); include "../include/dbconnclose.php"; }
* This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ include_once $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php"; include_once $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php"; user_enforce_has_access($Enlace_id, $ReadOnlyAccess, $_COOKIE['program']); include "../../header.php"; include "../header.php"; include "../classes/program.php"; require_once "../classes/assessment.php"; $program = new Program(); $program->load_with_program_id($_COOKIE['program']); ?> <!-- Shows all program information. --> <div style="display:none;"> <?php include "../include/datepicker_wtw.php"; ?>
* This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php"; include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php"; user_enforce_has_access($Enlace_id, $DataEntryAccess); /*add new event, either to a campaign or to the Little Village-wide events*/ include $_SERVER['DOCUMENT_ROOT'] . "/include/block_group_finder.php"; /*find the block group for the entered address */ $this_address = $_POST['address_num'] . " " . $_POST['address_dir'] . " " . $_POST['address_street'] . " " . $_POST['address_suffix'] . " Chicago IL"; $block_group = do_it_all($this_address, $map); echo $block_group; include "../include/dbconnopen.php"; $event_name_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['event_name']); $campaign_id_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['campaign_id']); $date_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['date']); $address_num_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['address_num']); $address_dir_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['address_dir']); $address_street_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['address_street']); $address_suffix_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['address_suffix']); $event_type_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['event_type']);
<?php /* * TTM is a web application to manage data collected by community organizations. * Copyright (C) 2014, 2015 Local Initiatives Support Corporation (lisc.org) * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php"; include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php"; user_enforce_has_access($Bickerdike_id, $DataEntryAccess); /* * Add new aldermanic record (just an amount of money added at a given date). */ include "../include/dbconnopen.php"; $money_sqlsafe = mysqli_real_escape_string($cnnBickerdike, $_POST['money']); $date_sqlsafe = mysqli_real_escape_string($cnnBickerdike, $_POST['date']); $add_bike_miles_sqlsafe = "INSERT INTO Aldermanic_Records (Environmental_Improvement_Money, Date) VALUES\r\n ('" . $money_sqlsafe . "',\r\n '" . $date_sqlsafe . "')"; mysqli_query($cnnBickerdike, $add_bike_miles_sqlsafe); include "../include/dbconnclose.php";
* This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php"; include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php"; user_enforce_has_access($Enlace_id, $AdminAccess, $_POST['program_id']); // Delete a program (if the user has access to that program). //if delete program action if ($_POST['action'] == "delete_program") { //get all program sessions include "../include/dbconnopen.php"; $program_id_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['program_id']); $all_program_sessions = "SELECT Session_ID FROM Session_Names " . "WHERE Program_ID='" . $program_id_sqlsafe . "'"; $all_program_sessions = mysqli_query($cnnEnlace, $all_program_sessions); include "../include/dbconnclose.php"; //loop through program sessions while ($program_session = mysqli_fetch_array($all_program_sessions)) { //delete all program's sessions and details //delete session from baseline assessments $delete_session = "DELETE FROM Participants_Baseline_Assessments WHERE Program='" . $program_session['Session_ID'] . "'"; echo $delete_session;
* This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php"; include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php"; user_enforce_has_access($LSNA_id, $AdminAccess); /*delete various elements from places in the system (relatively self-explanatory).*/ include "../include/dbconnopen.php"; $id_sqlsafe = mysqli_real_escape_string($cnnLSNA, $_POST['id']); if ($_POST['action'] == 'program') { $delete_query = "DELETE FROM Subcategories WHERE Subcategory_ID='" . $id_sqlsafe . "'"; } elseif ($_POST['action'] == 'institution') { $delete_query = "DELETE FROM Institutions WHERE Institution_ID='" . $id_sqlsafe . "'"; } elseif ($_POST['action'] == 'institution_affiliation') { $delete_query = "DELETE FROM Institutions_Participants WHERE Institutions_Participants_ID='" . $id_sqlsafe . "'"; } elseif ($_POST['action'] == 'participant') { $delete_query = "DELETE FROM Participants WHERE Participant_ID='" . $id_sqlsafe . "'"; } elseif ($_POST['action'] == 'event') { $delete_query = "DELETE FROM Subcategory_Dates WHERE Wright_College_Program_Date_ID='" . $id_sqlsafe . "'"; } elseif ($_POST['action'] == 'family') { $delete_query = "DELETE FROM Parent_Mentor_Children WHERE Parent_Mentor_Children_Link_ID='" . $id_sqlsafe . "'";
/* * TTM is a web application to manage data collected by community organizations. * Copyright (C) 2014, 2015 Local Initiatives Support Corporation (lisc.org) * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php"; include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php"; user_enforce_has_access($Enlace_id, $ReadOnlyAccess); /*check for duplicate campaigns (warn before creating two campaigns with the same name)*/ include "../include/dbconnopen.php"; $name_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['name']); $get_duplicate_campaigns = "SELECT COUNT(Campaign_Name) FROM Campaigns\r\n WHERE Campaign_Name='" . $name_sqlsafe . "'"; //echo $get_duplicate_campaigns; $is_duplicate = mysqli_query($cnnEnlace, $get_duplicate_campaigns); $duplicate = mysqli_fetch_row($is_duplicate); if ($duplicate[0] > 0) { echo 'A campaign named ' . $_POST['name'] . ' is already in the database. Are you sure you want to enter this campaign?'; } include "../include/dbconnclose.php";