<script language="javascript" type="text/javascript">
function gup( name, url ) {
if (!url) url = location.href;
name = name.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");
var regexS = "[\\?&]"+name+"=([^&#]*)";
var regex = new RegExp( regexS );
var results = regex.exec( url );
return results == null ? null : results[1];
}
function Validate2() { if((document.getElementById("from").value=="")||(document.getElementById("sub").value=="")||(document.getElementById("mes").value=="")) alert("Please fill in all the required fields!"); else document.getElementById("exp_frm").submit(); }
</script>
</p> <body onload="document.getElementById('to').value=gup('to','');"> <form action="send-message" method="get" id="exp_frm"> <input name="to" type="hidden" id="to" /> From: <input name="from" type="text" id="from" /> Subject: <input name="sub" type="text" id="sub" /> Message: <textarea cols="50" name="mes" rows="4" id="mes">Enter your message...</textarea> </form> <p><button onclick="Validate2()">Send</button></p> </body>
<script language="javascript" type="text/javascript">
function gup( name, url ) {
if (!url) url = location.href;
name = name.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");
var regexS = "[\\?&]"+name+"=([^&#]*)";
var regex = new RegExp( regexS );
var results = regex.exec( url );
return results == null ? null : results[1];
}
function Validate2() { if((document.getElementById("from").value=="")||(document.getElementById("sub").value=="")||(document.getElementById("mes").value=="")) alert("Please fill in all the required fields!"); else document.getElementById("exp_frm").submit(); }
</script>
</p> <body onload="document.getElementById('to').value=gup('to','');"> <form action="send-message" method="get" id="exp_frm"> <input name="to" type="hidden" id="to" /> From: <input name="from" type="text" id="from" /> Subject: <input name="sub" type="text" id="sub" /> Message: <textarea cols="50" name="mes" rows="4" id="mes">Enter your message...</textarea> </form> <p><button onclick="Validate2()">Send</button></p> </body>
<?php
$mailer = JFactory::getMailer();
$config = JFactory::getConfig();
$sender = array(
$config->get( 'mailfrom' ),
$config->get( 'fromname' )
);
$mailer->setSender($sender);
$user = JFactory::getUser();
$recipient = $user->email;
$mailer->addRecipient($recipient);
$recipient = array( 'radub_m@yaho.com', 'rocsense39@yahoo.com', 'evrika4you@yahoo.com');
$mailer->addRecipient($recipient);
$body = "Your body string\nin double quotes if you want to parse the \nnewlines etc";
$mailer->setSubject('Your subject string');
$mailer->setBody($body);
// Optional file attached
//$mailer->addAttachment(JPATH_COMPONENT.'/assets/document.pdf');
$send = $mailer->Send();
if ( $send !== true ) {
echo 'Error sending email: ';
} else {
echo 'Mail sent';
}
?>
</p>---->
<p>
<?php
session_start();
if(isset($_GET["to"]) && isset($_GET["from"]) && isset($_GET["sub"]) && isset($_GET["mes"])){
$to = $_GET["to"];
$from = $_GET["from"];
$sub = $_GET["sub"];
$mes = $_GET["mes"];
$servername = "94.176.180.19";
$username = "db-usr-cercetare";
$password = "8BYDrE2KcyjGtJKH";
$dbname = "Experts";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$result = $conn->query("SELECT `email` from info a where a.`date` = (select max(b.`date`) from info b where a.`idu` = b.`idu`) and `idu`=" . $to);
if ($result->num_rows > 0)
while($row = $result->fetch_array())
$rec = $row[0];
$conn->close();
$mailer = JFactory::getMailer();
$config = JFactory::getConfig();
$sender = array(
$config->get( 'mailfrom' ),
$config->get( 'fromname' )
);
$mailer->setSender($sender);
$user = JFactory::getUser();
$recipient = $user->email;
$mailer->addRecipient($recipient);
$recipient = array($rec);
$mailer->addRecipient($recipient);
//$body = "Testare script email \nYour body string\nin double quotes if you want to parse the \nnewlines etc";
$mailer->setSubject($sub);
$mailer->setBody($from . " has just said: \n" . $mes);
// Optional file attached
//$mailer->addAttachment(JPATH_COMPONENT.'/assets/document.pdf');
$send = $mailer->Send();
if ( $send !== true ) {
echo 'Error sending email: ';
} else {
echo 'Email trimis';
}
} else {
echo "Please fill in all the fields!";
}
?>
</p>
<?php
$mailer = JFactory::getMailer();
$config = JFactory::getConfig();
$sender = array(
$config->get( 'mailfrom' ),
$config->get( 'fromname' )
);
$mailer->setSender($sender);
$user = JFactory::getUser();
$recipient = $user->email;
$mailer->addRecipient($recipient);
$recipient = array( 'radub_m@yaho.com', 'rocsense39@yahoo.com', 'evrika4you@yahoo.com');
$mailer->addRecipient($recipient);
$body = "Your body string\nin double quotes if you want to parse the \nnewlines etc";
$mailer->setSubject('Your subject string');
$mailer->setBody($body);
// Optional file attached
//$mailer->addAttachment(JPATH_COMPONENT.'/assets/document.pdf');
$send = $mailer->Send();
if ( $send !== true ) {
echo 'Error sending email: ';
} else {
echo 'Mail sent';
}
?>
</p>---->
<p>
<?php
session_start();
if(isset($_GET["to"]) && isset($_GET["from"]) && isset($_GET["sub"]) && isset($_GET["mes"])){
$to = $_GET["to"];
$from = $_GET["from"];
$sub = $_GET["sub"];
$mes = $_GET["mes"];
$servername = "94.176.180.19";
$username = "db-usr-cercetare";
$password = "8BYDrE2KcyjGtJKH";
$dbname = "Experts";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$result = $conn->query("SELECT `email` from info a where a.`date` = (select max(b.`date`) from info b where a.`idu` = b.`idu`) and `idu`=" . $to);
if ($result->num_rows > 0)
while($row = $result->fetch_array())
$rec = $row[0];
$conn->close();
$mailer = JFactory::getMailer();
$config = JFactory::getConfig();
$sender = array(
$config->get( 'mailfrom' ),
$config->get( 'fromname' )
);
$mailer->setSender($sender);
$user = JFactory::getUser();
$recipient = $user->email;
$mailer->addRecipient($recipient);
$recipient = array($rec);
$mailer->addRecipient($recipient);
//$body = "Testare script email \nYour body string\nin double quotes if you want to parse the \nnewlines etc";
$mailer->setSubject($sub);
$mailer->setBody($from . " has just said: \n" . $mes);
// Optional file attached
//$mailer->addAttachment(JPATH_COMPONENT.'/assets/document.pdf');
$send = $mailer->Send();
if ( $send !== true ) {
echo 'Error sending email: ';
} else {
echo 'Email trimis';
}
} else {
echo "Please fill in all the fields!";
}
?>
</p>
<?php
session_start();
$servername = "94.176.180.19";
$username = "db-usr-cercetare";
$password = "8BYDrE2KcyjGtJKH";
$dbname = "Experts";
$idu = $_SESSION["idm"];
if($_SESSION["logged"]=="yes") {
$target_dir = "./";
$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);
$uploadOk = 1;
$imageFileType = pathinfo($target_file,PATHINFO_EXTENSION);
// Check if image file is a actual image or fake image
if(isset($_POST["submit"])) {
$check = getimagesize($_FILES["fileToUpload"]["tmp_name"]);
if($check !== false) {
echo "File is an image - " . $check["mime"] . ".";
$uploadOk = 1;
} else {
echo "File is not an image.";
$uploadOk = 0;
}
}
// Check if file already exists
if (file_exists($target_file)) {
echo "Sorry, file already exists.";
$uploadOk = 0;
}
// Check file size
if ($_FILES["fileToUpload"]["size"] > 500000) {
echo "Sorry, your file is too large.";
$uploadOk = 0;
}
// Allow certain file formats
if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg"
&& $imageFileType != "gif" ) {
echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
$uploadOk = 0;
}
// Check if $uploadOk is set to 0 by an error
if ($uploadOk == 0) {
echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "update info set image = '$target_file' where idu = $idu";
if ($conn->query($sql) === TRUE) {
header("Location: http://spiruharet.qareer.ro/platform/experts-database");
die();
} else {
//echo "Error: " . $sql . "<br>" . $conn->error;
echo "You have to add your data first!";
}
$conn->close();
echo "The file ". basename( $_FILES["fileToUpload"]["name"]). " has been uploaded.";
} else {
echo "Sorry, there was an error uploading your file.";
}
}
} else {
echo "Sorry, we are unable to submit your image. Please login first!";}
?>
</p>
<?php
session_start();
$servername = "94.176.180.19";
$username = "db-usr-cercetare";
$password = "8BYDrE2KcyjGtJKH";
$dbname = "Experts";
$idu = $_SESSION["idm"];
if($_SESSION["logged"]=="yes") {
$target_dir = "./";
$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);
$uploadOk = 1;
$imageFileType = pathinfo($target_file,PATHINFO_EXTENSION);
// Check if image file is a actual image or fake image
if(isset($_POST["submit"])) {
$check = getimagesize($_FILES["fileToUpload"]["tmp_name"]);
if($check !== false) {
echo "File is an image - " . $check["mime"] . ".";
$uploadOk = 1;
} else {
echo "File is not an image.";
$uploadOk = 0;
}
}
// Check if file already exists
if (file_exists($target_file)) {
echo "Sorry, file already exists.";
$uploadOk = 0;
}
// Check file size
if ($_FILES["fileToUpload"]["size"] > 500000) {
echo "Sorry, your file is too large.";
$uploadOk = 0;
}
// Allow certain file formats
if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg"
&& $imageFileType != "gif" ) {
echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
$uploadOk = 0;
}
// Check if $uploadOk is set to 0 by an error
if ($uploadOk == 0) {
echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "update info set image = '$target_file' where idu = $idu";
if ($conn->query($sql) === TRUE) {
header("Location: http://spiruharet.qareer.ro/platform/experts-database");
die();
} else {
//echo "Error: " . $sql . "<br>" . $conn->error;
echo "You have to add your data first!";
}
$conn->close();
echo "The file ". basename( $_FILES["fileToUpload"]["name"]). " has been uploaded.";
} else {
echo "Sorry, there was an error uploading your file.";
}
}
} else {
echo "Sorry, we are unable to submit your image. Please login first!";}
?>
</p>
<?php
session_start();
$servername = "94.176.180.19";
$username = "db-usr-cercetare";
$password = "8BYDrE2KcyjGtJKH";
$dbname = "Experts";
//$idu=$_GET["idu"];
$fname = $_GET["fname"];
$lname = $_GET["lname"];
$profile= $_GET["profile"];
$co=$_GET["co"];
$org=$_GET["org"];
$email=$_GET["email"];
$site=$_GET["site"];
//$user=$_GET["user"];
//$pwd=$_GET["pwd"];
$idu = $_SESSION["idm"];
if($_SESSION["logged"]=="yes") {
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "INSERT INTO info (`fname`, `lname`, `profile`, `institution`, `country`, `email`, `site`, `idu`) VALUES ('$fname', '$lname', '$profile', '$org', '$co', '$email', '$site', $idu)";
if ($conn->query($sql) === TRUE) {
header("Location: http://spiruharet.qareer.ro/platform/experts-database");
die();
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
} else {
echo "Sorry, we are unable to submit your data. Please login first!";}
?>
</p>
<?php
session_start();
$servername = "94.176.180.19";
$username = "db-usr-cercetare";
$password = "8BYDrE2KcyjGtJKH";
$dbname = "Experts";
//$idu=$_GET["idu"];
$fname = $_GET["fname"];
$lname = $_GET["lname"];
$profile= $_GET["profile"];
$co=$_GET["co"];
$org=$_GET["org"];
$email=$_GET["email"];
$site=$_GET["site"];
//$user=$_GET["user"];
//$pwd=$_GET["pwd"];
$idu = $_SESSION["idm"];
if($_SESSION["logged"]=="yes") {
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "INSERT INTO info (`fname`, `lname`, `profile`, `institution`, `country`, `email`, `site`, `idu`) VALUES ('$fname', '$lname', '$profile', '$org', '$co', '$email', '$site', $idu)";
if ($conn->query($sql) === TRUE) {
header("Location: http://spiruharet.qareer.ro/platform/experts-database");
die();
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
} else {
echo "Sorry, we are unable to submit your data. Please login first!";}
?>
</p>
<?php
echo "
<html>
<body>
<form method='get' action=''>
Find expert by <select name='country'>
<option value='%'>country...</option>
<option value='Italy'>Italy</option>
<option value='Poland'>Poland</option>
<option value='Romania'>Romania</option>
<option value='Spain'>Spain</option>
</select>
<input type='submit' value='Find'>
</form>
";
$servername = "94.176.180.19";
$username = "db-usr-cercetare";
$password = "8BYDrE2KcyjGtJKH";
$dbname = "Experts";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
if (isset($_GET["country"])) {
$cty=$_GET["country"];
$sql = "SELECT `fname`,`lname`,`profile`,`institution`,`country`,`idu`,`image` from info a where a.`date` = (select max(b.`date`) from info b where a.`idu` = b.`idu`) AND (country LIKE '$cty')";
} else {
$sql = "SELECT `fname`,`lname`,`profile`,`institution`,`country`,`idu`,`image` from info a where a.`date` = (select max(b.`date`) from info b where a.`idu` = b.`idu`) order by `country`";}
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
echo "<table border=1 cellspacing=5><tr><th>First Name</th><th >Last Name</th><th >Profile</th><th >Institution</th><th >Country</th><th >Email</th></tr>";
while($row = $result->fetch_array()) {
$x++;
$class = ($x%2 == 0)? 'white': 'lightgray';echo "<tr bgcolor='$class'><td>" . $row[0] . "</td><td>" . $row[1] . "</td><td>" . $row[2] . "</td><td>" . $row[3] . "</td><td>" . $row[4] .
"</td><td><a href='new-message?to=" . $row[5] . "'>email</a></td><td></td></tr>";
}
echo "</table>";
} else {
echo "0 results";
}
$conn->close();
echo "
</body>
</html>
";
?>
</p> <p> </p>
<?php
echo "
<html>
<body>
<form method='get' action=''>
Find expert by <select name='country'>
<option value='%'>country...</option>
<option value='Italy'>Italy</option>
<option value='Poland'>Poland</option>
<option value='Romania'>Romania</option>
<option value='Spain'>Spain</option>
</select>
<input type='submit' value='Find'>
</form>
";
$servername = "94.176.180.19";
$username = "db-usr-cercetare";
$password = "8BYDrE2KcyjGtJKH";
$dbname = "Experts";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
if (isset($_GET["country"])) {
$cty=$_GET["country"];
$sql = "SELECT `fname`,`lname`,`profile`,`institution`,`country`,`idu`,`image` from info a where a.`date` = (select max(b.`date`) from info b where a.`idu` = b.`idu`) AND (country LIKE '$cty')";
} else {
$sql = "SELECT `fname`,`lname`,`profile`,`institution`,`country`,`idu`,`image` from info a where a.`date` = (select max(b.`date`) from info b where a.`idu` = b.`idu`) order by `country`";}
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
echo "<table border=1 cellspacing=5><tr><th>First Name</th><th >Last Name</th><th >Profile</th><th >Institution</th><th >Country</th><th >Email</th></tr>";
while($row = $result->fetch_array()) {
$x++;
$class = ($x%2 == 0)? 'white': 'lightgray';echo "<tr bgcolor='$class'><td>" . $row[0] . "</td><td>" . $row[1] . "</td><td>" . $row[2] . "</td><td>" . $row[3] . "</td><td>" . $row[4] .
"</td><td><a href='new-message?to=" . $row[5] . "'>email</a></td><td></td></tr>";
}
echo "</table>";
} else {
echo "0 results";
}
$conn->close();
echo "
</body>
</html>
";
?>
</p> <p> </p>
<?php
session_start();
$servername = "94.176.180.19";
$username = "db-usr-cercetare";
$password = "8BYDrE2KcyjGtJKH";
$dbname = "Experts";
$usr_name=$_GET["user"];
$usr_pwd=$_GET["pwd"];
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT * FROM `users` WHERE `user` LIKE '$usr_name' AND `pwd` LIKE '$usr_pwd'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$_SESSION["logged"] = "yes";
// output data of each row
while($row =mysqli_fetch_array($result,MYSQLI_ASSOC)) {
$idm = $row["idu"];
//echo $idm;
echo "Wellcome, " . $row["user"] . "!</br>";
}
$_SESSION["idm"] = $idm;
echo "<a href='http://spiruharet.qareer.ro/platform'>Click here to enter your data:</a>";
} else {
$_SESSION["logged"] = "no";
echo "Sorry, your credentials are wrong!";
}
$conn->close();
?>
</p>
<?php
session_start();
$servername = "94.176.180.19";
$username = "db-usr-cercetare";
$password = "8BYDrE2KcyjGtJKH";
$dbname = "Experts";
$usr_name=$_GET["user"];
$usr_pwd=$_GET["pwd"];
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT * FROM `users` WHERE `user` LIKE '$usr_name' AND `pwd` LIKE '$usr_pwd'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$_SESSION["logged"] = "yes";
// output data of each row
while($row =mysqli_fetch_array($result,MYSQLI_ASSOC)) {
$idm = $row["idu"];
//echo $idm;
echo "Wellcome, " . $row["user"] . "!</br>";
}
$_SESSION["idm"] = $idm;
echo "<a href='http://spiruharet.qareer.ro/platform'>Click here to enter your data:</a>";
} else {
$_SESSION["logged"] = "no";
echo "Sorry, your credentials are wrong!";
}
$conn->close();
?>
</p>