function backfill_target($server_cfg, $game_cfg, $target_path, $command, $logger, $content = false)
{
$command = strtolower($command);
$xhProfModelObject = new XhProfModel($server_cfg, $game_cfg, false);
$tmp_file = $_FILES['uploadedfile']['tmp_name'];
$uploaded_file_name = basename($_FILES['uploadedfile']['name']);
if (isset($tmp_file)) {
$content = file_get_contents($tmp_file);
}
$timestamp = get_timestamp($uploaded_file_name, $content !== false);
$result = insert_event($xhProfModelObject, $server_cfg, $game_cfg, $timestamp, $command, $content);
if ($result) {
$logger->log("uploader", $content . " has been inserted", Logger::INFO);
return "\"{$content}\" as a \"{$command}\" event at {$timestamp}";
}
$target_file = "{$target_path}/{$timestamp}.{$command}";
if (isset($tmp_file) && move_uploaded_file($tmp_file, $target_file) || file_put_contents($target_file, $content)) {
$logger->log("uploader", $target_file . " has been uploaded", Logger::INFO);
echo "SUCCESS: {$target_file} has been uploaded<br></br>\n";
touch("{$target_path}/.{$command}");
} else {
$logger->log("uploader", "could not move " . $tmp_file . " to " . $target_file, Logger::ERR);
$target_file = null;
header("HTTP/1.1 500 Server error");
echo "FAILED: could not move {$tmp_file} to {$target_file}<br></br>\n";
}
return $target_file;
}
function input_html($event)
{
//For each team in the event
//Insert Player. Get player id
//Insert Team. Get team id
//Insert Player_Team.
insert_teams($event->teams);
sync_team_ids($event);
//Insert Basic Event Information. Get event id
$event->event_id = insert_event($event);
//Insert Event Rankings for each team.
insert_rankings($event->ranking_list, $event->event_id);
//For each game
echo "\n\nCount of Games: " . count($event->games);
insert_games($event->games, $event->event_id);
//Insert game with the dates and event_id. Get game id
//For each player
//Insert into player_game: player_id, game_id, percentage, num_shots
//For each end
//Insert relevant info
//Insert winners into game_team table
//Done!
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Evénement créé</title>
</head>
<body>
<?php
include "Header.php";
require 'fonctions_crea_event.php';
// On fait appel à la fonction insert_event permettant d'insérer les données récupérées du formulaire
insert_event($_POST['sponsor1'], $_POST['sponsor2'], $_POST['sponsor3'], $_POST['sponsor4'], $_POST['codepostal'], $_POST['numerorue'], nl2br(htmlspecialchars(addslashes($_POST['pays']))), nl2br(htmlspecialchars(addslashes($_POST['rue']))), nl2br(htmlspecialchars(addslashes($_POST['ville']))), $_POST['date_e'], $_POST['date_f'], nl2br(htmlspecialchars(addslashes($_POST['description_e']))), $_POST['heuredebut'], $_POST['heurefin'], nl2br(htmlspecialchars(addslashes($_POST['nb_max_participant']))), nl2br(htmlspecialchars(addslashes($_POST['Nom_e']))), $_POST['privacy'], $_POST['prix'], nl2br(htmlspecialchars(addslashes($_POST['urlsite_event']))));
// On fait une requête permettant de trouver le dernier événement créé, celui-ci est l'événement en cours de création
$id_event = mysqli_fetch_assoc(mysqli_query($connect, "select max(Event_id) as max from event"));
$idevent = $id_event['max'];
// On précise le chemin dans lequel seront sauvegardées les images
$uploaddir = '../reste/photo_event/';
// On attribue un chemin au fichier à télécharger composé du chemin défini au dessus ainsi que du nom du fichier
$uploadfile1 = $uploaddir . $_FILES['photo_principale']['name'];
// On exécute la fonction permettant de télécharger le fichier
upload('photo_principale', $uploadfile1, 20000000, array('png', 'gif', 'jpg', 'jpeg', 'PNG', 'JPG'));
mysqli_query($connect, "insert into multimedia(Event_id, urlimg_event, principale) values ('{$idevent}', '{$uploadfile1}', 1)");
// On vérifie en suite qu'une autre image a été fournie par l'utilisateur et ainsi de suite
if ($_FILES['photo_secondaire']['size'] != 0) {
$uploadfile2 = $uploaddir . $_FILES['photo_secondaire']['name'];
upload('photo_secondaire', $uploadfile2, 20000000, array('png', 'gif', 'jpg', 'jpeg', 'PNG', 'JPG'));
mysqli_query($connect, "insert into multimedia(Event_id, urlimg_event, principale) values ('{$idevent}', '{$uploadfile2}', 0)");
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<link type="text/css" rel="stylesheet" href="Header.css"/>
<?php
include "Header.php";
?>
<?php
require 'fonctions_crea_event.php';
insert_event($_POST['Nom_e'], $_POST['lieu'], $_POST['prix'], $_POST['date_e'], $_POST['heuredebut'], $_POST['heurefin'], $_POST['nb_max_participant'], $_POST['description_e'], $_POST['privacy'], $_SESSION['id_utilisateur']);
?>
<?php
header("Refresh:0, url = Accueil.php");
exit;
?>
</body>
</html>
<!-- insert_teacher.php
A PHP script to insert a new ad event into the test database
-->
<?php
require 'db_cn.inc';
require 'db_access.inc';
//This file contains php code that will be executed after the
//insert operation is done.
require 'event_insert_result_ui.inc';
// Main control logic
insert_event();
//-------------------------------------------------------------
function insert_event()
{
// Connect to the 'test' database
// The parameters are defined in the db_cn.inc file
// These are global constants
connect_and_select_db(DB_SERVER, DB_UN, DB_PWD, DB_NAME);
// Get the information entered into the webpage by the user
// These are available in the super global variable $_POST
// This is actually an associative array, indexed by a string
$eventCode = mysql_real_escape_string($_POST['eventCode']);
$eventName = mysql_real_escape_string($_POST['eventName']);
$startDate = mysql_real_escape_string($_POST['startDate']);
$endDate = mysql_real_escape_string($_POST['endDate']);
$description = mysql_real_escape_string($_POST['description']);
$type = mysql_real_escape_string($_POST['type']);
// Create a String consisting of the SQL command. Remember that
// . is the concatenation operator. $varname within double quotes
// will be evaluated by PHP
function run_mail_queue()
{
global $config;
include_once $config["homedir"] . "/include/functions.php";
require_once $config["homedir"] . "/include/swiftmailer/swift_required.php";
$utimestamp = date("U");
// $current_date = date ("Y/m/d H:i:s");
if (isset($config["batch_newsletter"])) {
$limit = " LIMIT " . $config['batch_newsletter'];
} else {
$limit = "";
}
// get pending mails
$mails = get_db_all_rows_sql("SELECT * FROM tpending_mail WHERE status = 0" . $limit);
if ($mails) {
foreach ($mails as $email) {
// Use local mailer if host not provided - Attach not supported !!
//Headers must be comma separated
if (isset($email["extra_headers"])) {
$extra_headers = explode(",", $email["extra_headers"]);
} else {
$extra_headers = array();
}
if ($config["smtp_host"] == "") {
// Use internal mail() function
$headers = array();
$headers[] = "MIME-Version: 1.0";
$headers[] = "Content-type: text/plain; charset=utf-8";
$headers = array_merge($headers, $extra_headers);
if ($email["from"] == "") {
$from = $config["mail_from"];
} else {
$from = $email["from"];
}
$headers[] = "From: " . $from;
$headers[] = "Subject: " . safe_output($email["subject"]);
if ($email["cc"]) {
$aux_cc = implode(",", $email["cc"]);
$headers[] = "Cc: " . $aux_cc;
}
$dest_email = trim(ascii_output($email['recipient']));
$body = safe_output($email['body']);
$error = mail($dest_email, safe_output($email["subject"]), $body, implode("\r\n", $headers));
if (!$error) {
process_sql("UPDATE tpending_mail SET status = {$status}, attempts = {$retries} WHERE id = " . $email["id"]);
} else {
// no errors found
process_sql("DELETE FROM tpending_mail WHERE id = " . $email["id"]);
}
} else {
// Use swift mailer library to connect to external SMTP
try {
// If SMTP port is not configured, abort mails directly!
if ($config["smtp_port"] == 0) {
return;
}
$transport = Swift_SmtpTransport::newInstance($config["smtp_host"], $config["smtp_port"]);
$transport->setUsername($config["smtp_user"]);
$transport->setPassword($config["smtp_pass"]);
$mailer = Swift_Mailer::newInstance($transport);
$message = Swift_Message::newInstance($email["subject"]);
if ($email["from"] == "") {
$message->setFrom($config["mail_from"]);
} else {
$message->setFrom($email["from"]);
}
if ($email["cc"]) {
$message->setCc($email["cc"]);
}
$to = trim(ascii_output($email['recipient']));
$toArray = array_map('trim', explode(",", $to));
if ($toArray) {
$to = $toArray;
}
$message->setTo($to);
$message->setBody($email['body'], 'text/plain', 'utf-8');
if ($email["attachment_list"] != "") {
$attachments = explode(",", $email["attachment_list"]);
foreach ($attachments as $attachment) {
if (is_file($attachment)) {
$message->attach(Swift_Attachment::fromPath($attachment));
}
}
}
$message->setContentType("text/plain");
$headers = $message->getHeaders();
foreach ($extra_headers as $eh) {
$aux_header = explode(":", $eh);
$headers->addTextHeader($aux_header[0], $aux_header[1]);
}
//Check if the email was sent at least once
if ($mailer->send($message) >= 1) {
process_sql("DELETE FROM tpending_mail WHERE id = " . $email["id"]);
} else {
throw new Exception(__('The mail send failed'));
}
} catch (Exception $e) {
$retries = $email["attempts"] + 1;
if ($retries > $config["smtp_queue_retries"]) {
$status = 1;
insert_event('MAIL_FAILURE', 0, 0, $email["recipient"] . " - " . $e);
} else {
$status = 0;
}
process_sql("UPDATE tpending_mail SET status = {$status}, attempts = {$retries} WHERE id = " . $email["id"]);
integria_logwrite(sprintf("SMTP error sending to %s (%s)"), implode(',', $toArray), $e);
}
}
}
}
}
$new_rank = $bs['classId'] * $active / 2;
$db->query(sprintf("UPDATE `businesses` SET `busYCust` = `busCust`, `busYProfit` = `busProfit`, `busCust` = '%d', `busProfit` = '%d', `busCash` = '%d' WHERE `busId` = '%u'", $new_customers, $new_profit, $new_profit + $bs['busCash'], $bs['busId']));
$db->query(sprintf("UPDATE `businesses` SET `busDays` = `busDays` + '1'"));
$db->query(sprintf("UPDATE `users` SET `activedays` = `activedays` + '1' WHERE `active` = '1'"));
$db->query(sprintf("UPDATE `users` SET `active` = '0' WHERE `active` = '1'"));
$db->query(sprintf("UPDATE `businesses` SET `brank` = `brank` + '%d' WHERE `busId` = '%u'", $new_rank, $bs['busId']));
$fetch_members = $db->query(sprintf("SELECT * FROM `businesses_members` LEFT JOIN `users` ON (`userid` = `bmembMember`) LEFT JOIN `businesses_ranks` ON (`rankId` = `bmembRank`) WHERE `bmembBusiness` = '%u'", $bs['busId'])) or die('Cron not run');
$db->query("UPDATE userstats SET labour = labour + 50, IQ = IQ + 50, strength = strength + 50 WHERE userid = {$bs['busDirector']}");
$db->query("UPDATE users SET comppoints = comppoints + 1 WHERE userid = {$bs['busDirector']}");
while ($fm = $db->fetch_row($fetch_members)) {
$db->query(sprintf("UPDATE `userstats` SET `{$fm['rankPrim']}` = `{$fm['rankPrim']}` + '%.6f', `{$fm['rankSec']}` = `{$fm['rankSec']}` + '%.6f' WHERE (`userid` = '%u')", $fm['rankPGain'], $fm['rankSGain'], $fm['userid'])) or die('Cron not run');
$db->query(sprintf("UPDATE `users` SET `money` = `money` + '%d' WHERE `userid` = '%u'", $fm['bmembCash'], $fm['userid'])) or die('Cron not run');
$db->query(sprintf("UPDATE `users` SET `comppoints` = `comppoints` + '1' WHERE `userid` = '%u'", $fm['userid'])) or die('Cron not run');
if ($bs['busCash'] < $fm['bmembCash']) {
$text = "Member ID {$fm['bmembMember']} was not paid their \$" . number_format($fm['bmembCash']) . " due to lack of funds." or die('Cron not run');
$db->query(sprintf("INSERT INTO `businesses_alerts` (`alertId`, `alertBusiness`, `alertText`, `alertTime`) VALUES ('NULL', '%u', '%s', '%d')", $bs['busId'], $text, time())) or die('Cron not run');
$db->query(sprintf("UPDATE `businesses` SET `busDebt` = `busDebt` + '%d' WHERE `busId` = '%u'", $fm['bmembCash'], $bs['busId'])) or die('Cron not run');
} else {
$db->query(sprintf("UPDATE `businesses` SET `busCash` = `busCash` - '%d' WHERE `busId` = '%u'", $fm['bmembCash'], $bs['busId'])) or die('Cron not run');
}
}
if ($bs['busDebt'] > $bs['classCost']) {
$send_event = $db->query(sprintf("SELECT `bmembMember` FROM WHERE `bmembBusiness` = '%u' ORDER BY `bmembId` DESC", $bs['busId'])) or die('Cron not run');
while ($se = $db->fetch_row($send_event)) {
$text = "The {$bs['busName']} business went bankrupt\\, all members have been made redundent." or die('Cron not run');
insert_event($se['bmembMember'], $text);
}
$db->query(sprintf("DELETE FROM `businesses_members` WHERE (`bmembBusiness` = '%u')", $bs['busId'])) or die('Cron not run');
$db->query(sprintf("DELETE FROM `businesses` WHERE (`busId` = '%u')", $bs['busId'])) or die('Cron not run');
}
}
function run_mail_queue()
{
global $config;
// Get pending mails
$filter = array('status' => 0);
$mails = get_db_all_rows_filter('tpending_mail', $filter);
// No pending mails
if ($mails === false) {
return;
}
// Init mailer
$mailer = null;
try {
// Use local mailer if host not provided - Attach not supported !!
if (empty($config['smtp_host'])) {
// Empty snmp conf. System sendmail transport
$transport = mail_get_transport();
$mailer = mail_get_mailer($transport);
} else {
$mailer = mail_get_mailer();
}
} catch (Exception $e) {
integria_logwrite(sprintf("Mail transport failure: %s", $e->getMessage()));
return;
}
foreach ($mails as $email) {
try {
//Check if the email was sent at least once
if (mail_send($email, $mailer) > 0) {
process_sql_delete('tpending_mail', array('id' => (int) $email['id']));
} else {
throw new Exception(__('The mail send failed'));
}
} catch (Exception $e) {
$retries = $email['attempts'] + 1;
if ($retries > $config['smtp_queue_retries']) {
$status = 1;
insert_event('MAIL_FAILURE', 0, 0, $email['recipient'] . ' - ' . $e->getMessage());
} else {
$status = 0;
}
$values = array('status' => $status, 'attempts' => $retries);
$where = array('id' => (int) $email['id']);
process_sql_update('tpending_mail', $values, $where);
$to = trim(ascii_output($email['recipient']));
integria_logwrite(sprintf('SMTP error sending to %s (%s)', $to, $e->getMessage()));
}
}
}
return $result;
}
?>
<!DOCTYPE HTML>
<html>
<head>
<title>Exemple simple de site en PHP </title>
</head>
<body>
<h1>Liste des utilisateurs</h1>
<?php
if (isset($_GET['action']) && $_GET['action'] == "save") {
if (!empty($_GET['Event_id'])) {
update_event($_GET['nom'], $_GET['description'], $_GET['Event_id']);
} else {
insert_event($_GET['nom'], $_GET['description']);
}
}
if (isset($_GET['action']) && $_GET['action'] == "ajouter" || isset($_GET['action']) && $_GET['action'] == "modifier") {
$nom = "";
$description = "";
$Event_id = "";
$prix = "";
if ($_GET['action'] == "modifier") {
$result = select_one_event($_GET['id']);
$event = mysqli_fetch_assoc($result);
$nom = $event['nom'];
$description = $event['description_e'];
$Event_id = $event['Event_id'];
}
?>
function bankrupt_business()
{
global $ir, $inf, $db;
if (!$_GET['confirm']) {
echo '
<div class="generalinfo_txt">
<div><img src="images/info_left.jpg" alt="" /></div>
<div class="info_mid"><h2 style="padding-top:10px;"> Declare Bankrupt</h2></div>
<div><img src="images/info_right.jpg" alt="" /></div> </div>
<div class="generalinfo_simple"><br> <br><br>
You are about to bankrupt the ' . stripslashes($inf['busName']) . ' Company. Please confirm this action.<br />
Once this has been confirmed there is no chance to go back.<br /><br />
<a href="business_manage.php?p=bankrupt&confirm=1">Bankrupt the Company</a> </div><div><img src="images/generalinfo_btm.jpg" alt="" /></div><br></div></div></div></div></div> ';
} else {
$send_event = $db->query(sprintf("SELECT `bmembMember` FROM businesses_members WHERE `bmembBusiness` = '%u' ORDER BY `bmembId` DESC", $bs['busId']));
while ($se = $db->fetch_row($send_event)) {
$text = "The director has chosen to bankrupt the {$inf['busName']} Company\\, all members have been made redundent.";
insert_event($se['bmembMember'], $text);
}
$db->query(sprintf("DELETE FROM `businesses_members` WHERE (`bmembBusiness` = '%u')", $inf['busId']));
$db->query(sprintf("DELETE FROM `businesses` WHERE (`busId` = '%u')", $inf['busId']));
$db->query(sprintf("UPDATE `users` SET `business` = '0' WHERE `business` = '%u'", $inf['busId']));
echo 'You have decided to bankrupt the Company, all members have been made redundent.';
}
}
