<?php include_once '../common/DatabaseConnection.php'; include 'mail.php'; require 'PHPMailerAutoload.php'; $db1 = new DatabaseConnection(); $db1->createConnection(); $res = wwwcopy("todayTask.php"); $sqlC = "select\n\t\t\t\ts.ScheduleMaintenancePK,\n\t\t\t\ts.ArtefactCode,\n\t\t\t\ta.ArtefactName,\n\t\t\t\ts.ScheduledServiceDate\n\t\t\t\tfrom scheduledmaintenance s\n\t\t\t\tinner join artefact a\n\t\t\t\ton s.ArtefactCode = a.ArtefactCode\n\t\t\t\twhere s.ScheduleMaintenancePK\n\t\t\t\tnot in (select ScheduleMaintenanceFK from tasklist)\n\t\t\t\tand s.ScheduledServiceDate <= current_date()\n\t\t\t\tand a.visiblestatus='on'"; $resu1 = $db1->setQuery($sqlC); if ($resu1->num_rows > 0) { $sql1 = "select FirstName,LastName,EmailId\n\t\t\t\t\tfrom user"; $resu1 = $db1->setQuery($sql1); if ($resu1->num_rows > 0) { while ($r = $resu1->fetch_assoc()) { $name = $r['FirstName'] . " " . $r['LastName']; $email = $r['EmailId']; $res1 = str_replace("{{user}}", $name, $res); echo sendMail($email, $res1); } } }
$time = explode(' ', $time); $time = $time[1] + $time[0]; $start = $time; for ($i = 0; $i < 2; $i++) { if ($i == 0) { $release = true; $folder = '../../../../_release/' . $app_version . '/_demo_site/'; } else { $release = false; $folder = '../../../../_release/' . $app_version . '/altair_v' . $app_version . '/admin/dist/'; } if (is_dir($folder)) { array_map('unlink', glob($folder . "*.html")); } wwwcopy($server_url . "login.php?generate&release=" . $release, $folder . "login.html"); wwwcopy($server_url . "error_404.php?generate&release=" . $release, $folder . "error_404.html"); wwwcopy($server_url . "error_500.php?generate&release=" . $release, $folder . "error_500.html"); $files = glob('../../php/views/*.php', GLOB_BRACE); foreach ($files as $file) { $file = str_replace('../../php/views/', '', $file); $file = str_replace('.php', '', $file); wwwcopy($server_url . "index.php?generate&release=" . $release . "&page=" . $file, $folder . $file . ".html"); } } $time = microtime(); $time = explode(' ', $time); $time = $time[1] + $time[0]; $finish = $time; $total_time = round($finish - $start, 4); echo "All done!<br>"; echo "Pages generated in " . $total_time . " seconds<br>";
<?php //abyasiId=ghj&firstName=ghj&middleName=j&lastName=jgh&email=fghf%40emnail.com&location=421&roles=2 include '../common/DatabaseConnection.php'; include '../mail/mail.php'; $db = new DatabaseConnection(); $db->createConnection(); $abyasiId = $_GET['abyasiId']; $fname = $_GET['firstName']; $nname = $_GET['middleName']; $lname = $_GET['lastName']; $password = $_GET['password']; $email = $_GET['email']; $location = $_GET['location']; $role = $_GET['roles']; $sql = "INSERT INTO user VALUES\n\t\t\t\t\t\t(NULL,\n\t\t\t\t\t\t'{$location}',\n\t\t\t\t\t\t'{$role}',\n\t\t\t\t\t\t'{$password}',\n\t\t\t\t\t\tNULL,\n\t\t\t\t\t\t'{$abyasiId}',\n\t\t\t\t\t\t'{$fname}',\n\t\t\t\t\t\t'{$nname}',\n\t\t\t\t\t\t'{$lname}',\n\t\t\t\t\t\t'{$email}',\n\t\t\t\t\t\t'1',\n\t\t\t\t\t\tCURRENT_TIMESTAMP,\n\t\t\t\t\t\t'1',\n\t\t\t\t\t\tCURRENT_TIMESTAMP,\n\t\t\t\t\t\t'on')"; $result = $db->setQuery($sql); if ($result) { $res = wwwcopy("mailfile.php"); $res1 = str_replace("{{user}}", $fname, $res); $res2 = str_replace("{{username}}", $abyasiId, $res1); $res3 = str_replace("{{password}}", $password, $res2); sendMail($email, $res3); echo 'success'; } else { echo $sql; }