File Manager

✏️ Edit File: /var/www/vhosts/nursoft.al/public_html/NurSoft/bdc/Bank Gjaku.php

<?php
ob_start();
error_reporting(0);
include "BDC/check.php";
$u = "";
// Make sure the _GET username is set, and sanitize it
if(isset($_GET["u"])){
	$u = preg_replace('#[^a-z0-9]#i', '', $_GET['u']);
} else {
    header("location: index?v=Login");
    exit();	
}

// Select the member from the users table
$sql = "SELECT * FROM users WHERE username='$u' And kategoria='Bank Gjaku'";
$user_query = mssql_query($sql);
// Now make sure that user exists in the table
$numrows = mssql_num_rows($user_query);
if($numrows < 1){
	header("location: index?v=Login");
    exit();	
}
if($u == $log_username  && $user_ok == true){
	$isOwner = "yes";
}
else
{
$isOwner == "no";	header("location: index?v=Login");
}
while ($row = mssql_fetch_array($user_query, MYSQLI_ASSOC)) 
{
$profile_id = $row["id"];
$emri = $row["emri"];
$mbiemri = $row["mbiemri"];	
$email = $row["email"];	
$cel = $row["cel"];	
$dtl = $row["dtl"];	
$gener = $row["gener"];		
$kategoria = $row["kategoria"];
$avatar=$row["avatar"];
$grupi=$row["grupi"];
}
?>
<!DOCTYPE html>   
<html lang="sq" xml:lang="sq" xmlns="http://www.w3.org/1999/xhtml">
<head>

</ul>
   </div>
</nav>
			<div class="clear"> </div>
			
		</div>
		
	</div>
			<section style=' padding:20px;margin:0 auto;min-height:700px;border-top: 1px solid #e0e0e0;background-color: white;'>
		<article style='float:left; padding:5px; border-right: 1px solid #e0e0e0;background-color: white;' >
		
<?php 
		if(isset($_POST['fshi']))
{
	$fshi="DELETE FROM post where id='$_POST[fshi]'";
	$fshir=mssql_query($fshi);
	if($fshir)
	{
	header("location: Bank Gjaku?u=$u");
    exit();		
	}
}
echo"<h2>Aktivitete</h2>";
$ak="SELECT TOP 5 data,id, SUBSTRING(artikulli,1,50) as artikulli2 FROM post ORDER BY id desc";
			  $akr = mssql_query($ak); 
			  while($akrow=mssql_fetch_array($akr))
			  {$ak2="SELECT TOP 1 * FROM foto where postimi = '$akrow[id]'";
			  $akr2 = mssql_query($ak2);

?><div class="njoftime" style='width: 97%;'>
				<form action='' method='post'>
		<input type='hidden' name='fshi' value='<?php echo $akrow['id'];?>'>
		<button style='float:right;'>Fshi</button>
		</form>
<a href='posts?pid=<?php echo $akrow['id'];?>'> <?php while($akrow2=mssql_fetch_array($akr2)) { ?>
				 <img src='images/postime/<?php echo $akrow2['foto']; ?>' width='80' height='50'> <?php } ?>
		<p style='font-size:12px;'><?php echo $akrow['artikulli2'];?>...</p><p style='float:right;'><?php echo $akrow['data'];?></p>
				</a>
		</div>
			  <?php } ?>
		</article>
		<aside style='float:right; padding:5px;background-color: white; height:auto;'>
		<div style='border-bottom:1px solid #e0e0e0; padding-bottom:30px;'>
<script>
function div_show() {
document.getElementById('abc').style.display = "block";
}
//Function to Hide Popup
function div_hide(){
document.getElementById('abc').style.display = "none";
}
</script>
	<?php	
$noFile = $_FILES['photo']['size'][0] == 0 && $_FILES['photo']['tmp_name'][0] == '';
if(isset($_POST['artikulli']))
{	$artikulli = preg_replace('#[^a-z 0-9.,+]#i', '', $_POST['artikulli']);
	mssql_query ( 'SET TEXTSIZE 65536' , $conn );
ini_set ( 'mssql.textlimit' , '65536' );
ini_set ( 'mssql.textsize' , '65536' );
date_default_timezone_set("Europe/Berlin"); 
$s1232="INSERT INTO post(artikulli,postuesi,data) VALUES('$artikulli','$u',getdate())";
$r1232 = mssql_query($s1232);
    $res = mssql_query("SELECT @@identity AS id"); 
$row = mssql_fetch_array($res);
        $gallery = $row["id"]; 
    if (!$noFile) { 
if (isset($_FILES["photo"]["name"]) && isset($gallery)){
foreach($_FILES['photo']['tmp_name'] as $key => $tmp_name )
{
	$fileName =  $key.$_FILES["photo"]["name"] [$key];
    $fileTmpLoc = $_FILES["photo"]["tmp_name"][$key];
	$fileType = $_FILES["photo"]["type"][$key];
	$fileSize = $_FILES["photo"]["size"][$key];
	$fileErrorMsg = $_FILES["photo"]["error"];
	$kaboom = explode(".", $fileName);
	$fileExt = end($kaboom);
	$db_file_name = date("DMjGisY")."".rand(1000,9999).".".$fileExt; // WedFeb272120452013RAND.jpg
	list($width, $height) = getimagesize($fileTmpLoc);
	$moveResult = move_uploaded_file($fileTmpLoc, "images/postime/$db_file_name");
date_default_timezone_set("Europe/Berlin"); 
	$sql = "INSERT INTO foto(postimi, foto, data) VALUES ('$gallery','$db_file_name',getdate())";
	$query = mssql_query($sql);
}
}
}
if($r1232)
{
echo "<p class='fgh'>";
echo "<span style='color:green; font-weight:bold; font-size:13px;margin-top:-40px;'><b>Aktiviteti u postua me sukses !</b></style>";
echo '</p>';
header("location: Users?u=$u");
    exit();	
}
}
		?>
		<form action='' method='POST' enctype="multipart/form-data" style=''>
		<textarea name='artikulli' style='width:99%;'></textarea>
		<input type='file'  name='photo[]' multiple accept="image/*">
		<button style='float:right;'>Posto</button>
		</form>
		</div></br>	
		<?php if($_GET['v']=='Mer'){
						  if(isset($_POST['usm']))
{
	date_default_timezone_set("Europe/Berlin"); 
$date = date('Y-m-d H:i:s');
$qs="UPDATE kerkesat SET pojo='1', dhuruar ='$date' where users='$_POST[usm]' AND merjep='Mer' AND pojo='0'";
	$qsr=mssql_query($qs);
$njesigjaku="UPDATE qesetegjakut SET sasia=sasia-1 where  CONVERT(VARCHAR, grupi)='$_POST[urupi]' AND institucion='$profile_id'";
$njesigjakur=mssql_query($njesigjaku);
	if($qsr)
	{
echo "<p style='color:green; font-size:16px; font-weight:bold;'>Veprimi u krye me sukses! </p>";
	}
}	?>	<h1>Kerkesat Per te Mar Gjak</h1>
		<table border=1 style='padding:10px; width:100%; text-align:center;'>
		<tr>
		<td style='padding:10px;'>Emri</td>
		<td style='padding:10px;'>Mbiemri</td>
		<td style='padding:10px;'>Grupi i gjakut</td>
		<td style='padding:10px;'>DT e zgjedhur</td>
		<td style='padding:10px;'>Ora e zgjedhur per te mar gjak</td>
		<td style='padding:10px;'>U mor</td>
		</tr><?php
		$mer="SELECT users.grupi as ugrupi, users.emri,users.mbiemri,users.id,users.pesha,kerkesat.users,kerkesat.date,kerkesat.start,kerkesat.grupi as kgrupi,kerkesat.anonim
		FROM kerkesat JOIN users ON users.username=kerkesat.users AND kerkesat.spitali='$profile_id' AND merjep='Mer'  AND pojo=''ORDER BY kerkesat.id asc";
			  $merr = mssql_query($mer); 
			  while($akrow=mssql_fetch_array($merr))
			  {
		?>
		<tr>
		<td style='padding:10px;'><?php if ($akrow['anonim'] != '1') {echo $akrow['emri'];} else {echo "Përdoruesi dëshiron të jetë anonim";} ?></td>
		<td style='padding:10px;'><?php if ($akrow['anonim'] != '1') {echo $akrow['mbiemri'];} else {echo "Përdoruesi dëshiron të jetë anonim";} ?></td>
		<td style='padding:10px;'><?php if ($akrow['kgrupi'] != '') {echo $akrow['kgrupi'];} else {echo $akrow['ugrupi']; } ?></td>
		<td style='padding:10px;'><?php echo $akrow['date']; ?></td>
		<td style='padding:10px;'><?php echo $akrow['start']; ?></td>
		<td style='padding:10px;'><form method='POST' action=''>
				<input type='hidden' value='<?php echo $akrow['users']; ?>' name='usm'>
				<input type='hidden' value='<?php if ($akrow['kgrupi'] != '') {echo $akrow['kgrupi'];} else {echo $akrow['ugrupi']; } ?>' name='urupi'><input type='submit' value='Marja e gjakut u krye'></form></td>
		</tr>
		
			  <?php } ?></table></br></br> <?php } ?>
			  	<?php if($_GET['v']=='Jep'){if(isset($_POST['usdh']))
{
	date_default_timezone_set("Europe/Berlin"); 
$date = date('Y-m-d H:i:s');
$qs="UPDATE kerkesat SET pojo='1', dhuruar ='$date' where id='$_POST[usdh]' AND merjep='Jep'";
	$qsr=mssql_query($qs);
$njesigjaku123="UPDATE qesetegjakut SET sasia=sasia+1 where  CONVERT(VARCHAR, grupi)='$_POST[urup2i]' AND institucion='$profile_id'";
$njesigjakur123=mssql_query($njesigjaku123);
	if($qsr)
	{
echo "<p style='color:green; font-size:16px; font-weight:bold;'>Veprimi u krye me sukses! </p>";
	}
}	?> 	<h1>Kërkesat Për Dhurim Gjaku</h1>
		<table border=1 style='padding:10px; width:100%; text-align:center;'>
		<tr>
		<td style='padding:10px;'>Id</td>
		<td style='padding:10px;'>Emri</td>
		<td style='padding:10px;'>Mbiemri</td>
		<td style='padding:10px;'>Pesha</td>
		<td style='padding:10px;'>Grupi i gjakut</td>
		<td style='padding:10px;'>DT zgjedhur për të dhuruar</td>
		<td style='padding:10px;'>Ora zgjedhur për të dhuruar</td>
		<td style='padding:10px;'>Dhurimi u krye</td>
		</tr><?php
		$mer="SELECT kerkesat.id as kid,users.emri,users.mbiemri,kerkesat.anonim,users.id,users.pesha,users.username as uusa,users.grupi as ugrupi,kerkesat.date,kerkesat.start,kerkesat.grupi 
		FROM kerkesat JOIN users ON users.username=kerkesat.users AND kerkesat.spitali='$profile_id' AND merjep='Jep' AND pojo='0' ORDER BY kerkesat.id asc";
			  $merr = mssql_query($mer); 
			  while($akrow=mssql_fetch_array($merr))
			  {
		?>
		<tr>
		<td style='padding:10px;'><?php echo $akrow['id']; ?></td>
		<td style='padding:10px;'><?php if ($akrow['anonim'] != '1') {echo $akrow['emri'];} else {echo "Perdoruesi deshiron te jete anonim";} ?></td>
		<td style='padding:10px;'><?php if ($akrow['anonim'] != '1') {echo $akrow['mbiemri'];} else {echo "Perdoruesi deshiron te jete anonim";} ?></td>
		<td style='padding:10px;'><?php echo $akrow['pesha']; ?></td>
		<td style='padding:10px;'><?php echo $akrow['ugrupi']; ?></td>
		<td style='padding:10px;'><?php echo $akrow['date']; ?></td>
		<td style='padding:10px;'><?php echo $akrow['start']; ?></td>
                <td style='padding:10px;'><form method='POST' action=''>
				<input type='hidden' value='<?php echo $akrow['kid']; ?>' name='usdh'>
				<input type='hidden' value='<?php echo $akrow['ugrupi']; ?>' name='urup2i'><input type='submit' value='Dhurimi u krye'></form></td>
		</tr>
		
			  <?php } ?></table></br></br> <?php } ?><?php if($_GET['v']=='KNJGJ'){
			?> 	<h1>Kerkesat Per Njesi Gjaku</h1>
		<table border=1 style='padding:10px; width:100%; text-align:center;'>
		<tr>
		<td style='padding:10px;'>Emri i Institucionit</td>
		<td style='padding:10px;'>Grupi i gjakut</td>
		<td style='padding:10px;'>Dergo</td>
		</tr><?php
	if(isset($_POST['sasiaederguar']))
{
 $njesigjaku="UPDATE qesetegjakut SET sasia=sasia+$_POST[sasiaederguar] where CONVERT(VARCHAR, grupi)='$_POST[grupiii]' AND institucion='$_POST[iid]'";
$njesigjakur=mssql_query($njesigjaku);
 $njesigjaku2="UPDATE qesetegjakut SET sasia=sasia-$_POST[sasiaederguar]  where  CONVERT(VARCHAR, grupi)='$_POST[grupiii]' AND institucion='$profile_id'";
$njesigjakur2=mssql_query($njesigjaku2);
 $njesigjaku3="UPDATE njoftime SET seen='0' where id='$_POST[njofid]'";
$njesigjakur3=mssql_query($njesigjaku3);
	if($njesigjakur)
	{
echo "<p style='color:green; font-size:16px; font-weight:bold;'>Veprimi u krye me sukses! </p>";
	}
}
		 $mer="SELECT users.emri,users.mbiemri,users.id,njoftime.institucioni,njoftime.grupi,njoftime.users, njoftime.id as njofid FROM njoftime 
		JOIN users ON users.id=njoftime.users AND njoftime.institucioni='$profile_id' AND CONVERT(VARCHAR, njoftime.njoftimi)='Spital' AND njoftime.seen='1' ORDER BY njoftime.id asc";
			  $merr = mssql_query($mer); 
			  while($akrow=mssql_fetch_array($merr))
			  {
		?>
		<tr>
		<td style='padding:10px;'><?php echo "$akrow[emri] $akrow[mbiemri]"; ?></td>
		<td style='padding:10px;'><?php echo $akrow['grupi']; ?></td>
		<td style='padding:10px;'><form action='' method='POST'>
		<input style='width:74%;'type='text' placeholder='Sasia e derguar' name='sasiaederguar' required> 
<input type='hidden' value='<?php echo $akrow['users']; ?>' name='iid'>
<input type='hidden' value='<?php echo $akrow['grupi']; ?>' name='grupiii'>
<input type='hidden' value='<?php echo $akrow['njofid']; ?>' name='njofid'>
<input type='submit' value='Njesit e gjakut u derguan me sukses !'></form></td>
		</tr>
		
			  <?php } ?></table></br></br> <?php } ?>
			  	<?php if($_GET['v']=='Njesit'){?> 	<h1>Njesit e Gjakut</h1>
				 <?php if(isset($_POST['plus']) )
{
$njesigjaku="UPDATE qesetegjakut SET sasia=sasia+1 where id='$_POST[plus]' AND institucion='$profile_id'";
$njesigjakur=mssql_query($njesigjaku);
}
if(isset($_POST['minus']) )
{
$njesigjaku="UPDATE qesetegjakut SET sasia=sasia-1 where id='$_POST[minus]' AND institucion='$profile_id'";
$njesigjakur=mssql_query($njesigjaku);
}
if(isset($_POST['sasia']) )
{
$njesigjaku="UPDATE qesetegjakut SET sasia='$_POST[sasia]' where id='$_POST[sasid]' AND institucion='$profile_id'";
$njesigjakur=mssql_query($njesigjaku);
}
	if($njesigjakur)
	{
echo "<p style='color:green; font-size:16px; font-weight:bold;'>Veprimi u krye me sukses! </p>";
	}	?> 
		<table border=1 style='padding:10px; width:100%; text-align:center;'>
		<tr>
		<td style='padding:10px; width:5%;'>Grupi i gjakut</td>
		<td style='padding:10px;width:50%;'>Sasia</td>
		<td style='padding:10px;width:30%;'>+ / -</td></tr><?php
		$mer="SELECT * FROM qesetegjakut where institucion='$profile_id' ORDER BY id asc";
			  $merr = mssql_query($mer); 
			  while($akrow=mssql_fetch_array($merr))
			  {
		?>	
		<tr>
		<td style='padding:5px;'><?php echo $akrow['grupi']; ?></td>
		<td style='padding:5px;'><form action='' method='POST'><input type='hidden' value='<?php echo $akrow['id']; ?>' name='sasid'>
		<input type='text' style='width:100%;width: 99%;height: 100%;padding: 0;margin: 0;' value="<?php echo $akrow['sasia']; ?>" name='sasia'></td>
		<td style='padding:5px;'><button style='float: left;height: 26px;margin-top: 0px;'>Ndrysho</button> </form><form action='' style='float:left;' method='POST'><input type='hidden' value='<?php echo $akrow['id']; ?>' name='plus'>
		<button>+ 1</button></form>
		<form action='' style='float:left;' method='POST'><input type='hidden' value='<?php echo $akrow['id']; ?>' name='minus'><button>- 1</button></form></td>
		</tr>
			  <?php } ?> </table></br></br><?php } ?>
			  <?php if($_GET['v']=='Perdoruesit'){?> 	<h1>Perdoruesit e regjistruar</h1>
				 <?php if(isset($_POST['fshije']) )
{
$njesigjaku="DELETE from users where id='$_POST[fshije]'";
$njesigjakur=mssql_query($njesigjaku);
}
	if($njesigjakur)
	{
echo "<p style='color:green; font-size:16px; font-weight:bold;'>Veprimi u krye me sukses! </p>";
	}	?> 
		<table border=1 style='padding:10px; width:100%; text-align:center;'>
		<tr>
		<td style='padding:6px; width:5%;'>id</td>
		<td style='padding:6px;width:50%;'>Emri</td>
		<td style='padding:6px;width:30%;'>Mbiemri</td>
		<td style='padding:6px;width:30%;'>E-mail</td>
		<td style='padding:6px;width:30%;'>Fshi</td>
		
		</tr>
		
		<?php
		$mer="SELECT * FROM users where kategoria='users' ORDER BY id asc";
			  $merr = mssql_query($mer); 
			  while($akrow=mssql_fetch_array($merr))
			  {
		?>	
		<tr>
		<td style='padding:2px;'><?php echo $akrow['id']; ?></td>
		<td style='padding:2px;'><?php echo $akrow['emri']; ?></td>
		<td style='padding:2px;'><?php echo $akrow['mbiemri']; ?></td>
		<td style='padding:2px;'><?php echo $akrow['email']; ?></td>
		<td style='padding:2px;'><form action='' style='float:left;' method='POST'><input type='hidden' value='<?php echo $akrow['id']; ?>' name='fshije'><button>Fshi</button></form></td>
		</tr>
			  <?php } ?> </table></br></br><?php } ?>
			    <?php if($_GET['v']=='Institucione'){?> 	<h1>Institucionet e regjistruara</h1>
				 <?php if(isset($_POST['fshiin']) )
{
$njesigjaku="DELETE from users where id='$_POST[fshiin]'";
$njesigjakur=mssql_query($njesigjaku);
}
	if($njesigjakur)
	{
echo "<p style='color:green; font-size:16px; font-weight:bold;'>Veprimi u krye me sukses! </p>";
	}	?> 
		<table border=1 style='padding:10px; width:100%; text-align:center;'>
		<tr>
		<td style='padding:6px; width:5%;'>id</td>
		<td style='padding:6px;width:50%;'>Emri i institucionit</td>
		<td style='padding:6px;width:30%;'>E-mail</td>
		<td style='padding:6px;width:30%;'>Fshi</td>
		
		</tr>
		
		<?php
		$mer="SELECT * FROM users where kategoria !='users' ORDER BY id asc";
			  $merr = mssql_query($mer); 
			  while($akrow=mssql_fetch_array($merr))
			  {
		?>	
		<tr>
		<td style='padding:2px;'><?php echo $akrow['id']; ?></td>
		<td style='padding:2px;'><?php echo $akrow['emri']; ?> <?php echo $akrow['mbiemri']; ?></td>
		<td style='padding:2px;'><?php echo $akrow['email']; ?></td>
		<td style='padding:2px;'><form action='' style='float:left;' method='POST'><input type='hidden' value='<?php echo $akrow['id']; ?>' name='fshiin'><button>Fshi</button></form></td>
		</tr>
			  <?php } ?> </table></br></br><?php } if($_GET['v']=='shtoinstitucion'){
				  
				  if(isset($_POST['ema']))
{
$shtoin="INSERT INTO users (emri, mbiemri, username, password,email,qyteti,lat,long,cel,kategoria) values ('$_POST[kat]','$_POST[emri]','$_POST[username]','$_POST[pass]',
'$_POST[ema]','$_POST[qyt]','$_POST[lat]','$_POST[long]','$_POST[cel]','Spital')";
$shtoinr=mssql_query($shtoin);
	if($shtoinr)
	{
echo "<p style='color:green; font-size:16px; font-weight:bold;'>Veprimi u krye me sukses! </p>";
}}	?> 
			  <form method='POST' action='' style='width:80%; margin: 0 auto;'>
			  <select name='kat' style='padding:5px; width:100%;'>
			  <option value='Spitali'> Spital </option>
			  <option value='Qendera Spitalore'> Qender Spitalore </option>
			  <option value='Marteniteti'> Martenitet </option>
			  </select>
			  <input style='padding:5px; width:100%;' type='text' name='emri' placeholder='Emri i institucionit' required>
			  <input style='padding:5px; width:100%;' type='text' name='username' placeholder='Username' required>
			  <input style='padding:5px; width:100%;' type='text' name='pass' placeholder='Fjalekalimi' required>
			  <input style='padding:5px; width:100%;' type='text' name='ema' placeholder='E-mail'required>
			  <input style='padding:5px; width:100%;' type='text' name='qyt' placeholder='Qyteti'required>
			  <input style='padding:5px; width:100%;' type='text' name='lat' placeholder='Latitude'required>
			  <input style='padding:5px; width:100%;' type='text' name='long' placeholder='Longitude'required>
			  <input style='padding:5px; width:100%;' type='text' name='cel' placeholder='Kontakt'required>
			  <button style='width:20%; padding:5px 30px; float:right;'>Shto</button></br></br>
			  </form></br></br></br></br>
			  <?php } ?>
			  
<button id='b1' onclick="javascript:location.href='Bank Gjaku?u=<?php echo $u; ?>&v=Jep'">Kërkesat për dhurim gjaku</button>
<button id='b2' onclick="javascript:location.href='Bank Gjaku?u=<?php echo $u; ?>&v=Mer'">Kërkesat për të mar gjak</button>
<button id='b3' onclick="javascript:location.href='Bank Gjaku?u=<?php echo $u; ?>&v=KNJGJ'">Kërkesat për njësi gjaku</button>
<button id='b4' onclick="javascript:location.href='Bank Gjaku?u=<?php echo $u; ?>&v=Perdoruesit'">Fshi përdorues të regjistruar</button>
<button id='b5' onclick="javascript:location.href='Bank Gjaku?u=<?php echo $u; ?>&v=shtoinstitucion'">Shto nje institucion</button>
<button id='b6' onclick="javascript:location.href='Bank Gjaku?u=<?php echo $u; ?>&v=Institucione'">Fshi institucione të regjistruara</button>
<button  style='width:99.6%; padding:10px; ' onclick="javascript:location.href='Bank Gjaku?u=<?php echo $u; ?>&v=Njesit'">Njësit e gjakut </button>
		</aside>
         </section>
<style>
@media (max-width: 768px)
				{ #b1,#b2,#b3,#b4,#b5,#b6{width:100%; padding:5px;}}@media (min-width: 768px)
				{#b1,#b3,#b5{width:49%; padding:10px;}#b2,#b4,#b6{width:50%; padding:10px;}}	
.njoftime {

padding:10px;
border: 1px solid #c1cad5; 
border-radius:10px;
font-family:raleway;
margin-bottom:-1px;
background-color:#fff
}
</style>
		               		  
<footer style='margin-top:10px;'>  <div id="foo"> 
					<div class="c">
				
					<ul> 
<li style="display:inline; float:left; margin-top:-10px;">	
<a href="
https://www.facebook.com/pages/Blood-Donors-Circle/1069440686404740"><img src="images/facebook.png" title="facebook"></a>
<a href="
https://twitter.com/BloodDonorsAlb"><img src="images/twitter.png" title="twitter"></a>
<a href="
https://plus.google.com/u/0/115666163009451391914/about?tab=XX
" ><img src="images/google.png" title="google pluse"></a>
<a href="https://www.youtube.com/channel/UCu1fiqrAyol7b4Br4cb9e3w/feed" ><img src="images/youtube.png" title="Youtube"></a>
</li><li> <a href="index">&copy; By  MM 2015</a></li> 
</ul> </div> </div>
   </footer> </div> 
	<?php $gr="SELECT qesetegjakut.id,qesetegjakut.institucion,qesetegjakut.sasia,users.grupi,users.lat,users.long,qesetegjakut.grupi as qgrupi,users.id as uidi,users.kategoria,users.emri,users.mbiemri from qesetegjakut 
	JOIN users ON users.id=qesetegjakut.institucion AND qesetegjakut.sasia <= '10' AND qesetegjakut.institucion='$profile_id'";
	$grr=mssql_query($gr);echo mssql_get_last_message();
	WHILE($row=mssql_fetch_array($grr))
	{ 
$gru=$row['qgrupi'];
$se="SELECT id from users where  CONVERT(VARCHAR, grupi) ='$gru'";
$se2=mssql_query($se);echo mssql_get_last_message();
	WHILE($se3=mssql_fetch_array($se2))
	{
$string='Në bankën e gjakut ka mungesë të grupit '.$gru.', nëse keni mundësi paraqituni të dhuroni.<br/> DHURO GJAK SHPETO NJE JETE !';
if(!isset($_COOKIE['gruas'])){
$in="INSERT INTO njoftime (njoftimi, institucioni,users,seen,grupi,data ) VALUES ('$string','$row[institucion]','$se3[id]','1','$row[qgrupi]',getdate())"; 
		$inr=mssql_query($in);
		  setcookie( 'gruas', $gru, time()+9800);
		  if($inr)
			echo mssql_get_last_message();
	}
	}
	}
?>
<div id='result'></div>
         </body>
</html>

Batal

⬅ Naik ke NurSoft 24 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁App_Data	dir	—	2018-03-08 14:34	📂 Buka
📁BDC	dir	—	2018-03-17 17:27	📂 Buka
📁asd	dir	—	2018-03-17 17:25	📂 Buka
📁css	dir	—	2018-03-08 14:34	📂 Buka
📁images	dir	—	2018-03-08 14:34	📂 Buka
📁js	dir	—	2018-03-08 14:34	📂 Buka
📄.htaccess	htaccess	124 B	2019-03-16 01:44	✏️ Edit 👁️ View
🐘Aktivitete.php	php	13.8 KB	2018-03-17 18:00	✏️ Edit 👁️ View
🐘Bank Gjaku.php	php	26.1 KB	2018-03-08 14:34	✏️ Edit 👁️ View
🐘Spital.php	php	18.4 KB	2018-03-08 14:34	✏️ Edit 👁️ View
🐘activation.php	php	2 KB	2018-03-08 14:34	✏️ Edit 👁️ View
🗜️bdccc.zip	zip	8.4 MB	2018-03-17 00:17	✏️ Edit 👁️ View
🐘book_slots.php	php	2.2 KB	2018-03-08 14:34	✏️ Edit 👁️ View
🐘calendar.php	php	3.5 KB	2018-03-08 14:34	✏️ Edit 👁️ View
🐘class_calendar.php	php	13 KB	2018-03-08 14:34	✏️ Edit 👁️ View
🐘connect.php	php	111 B	2018-03-08 14:34	✏️ Edit 👁️ View
🐘feed.php	php	1.5 KB	2018-03-08 14:34	✏️ Edit 👁️ View
🐘index.php	php	41.4 KB	2018-03-17 18:10	✏️ Edit 👁️ View
🖼️logo.png	png	78 KB	2018-03-08 14:34	✏️ Edit 👁️ View
🐘logout.php	php	613 B	2018-03-08 14:34	✏️ Edit 👁️ View
🐘njoftimet.php	php	304 B	2018-03-08 14:34	✏️ Edit 👁️ View
🐘posts.php	php	10.2 KB	2018-03-08 14:34	✏️ Edit 👁️ View
🎨style.css	css	7.1 KB	2018-03-08 14:34	✏️ Edit 👁️ View
🐘users.php	php	54.8 KB	2018-03-08 14:34	✏️ Edit 👁️ View