<?php

 

require_once("config.php");

 

$sms_id = $_GET['id'];

$transaction = $_GET['transaction'];

$amount = $_GET['amount'];

$time = date("Y/m/d H:i");

$sms = mysql_escape_string(htmlspecialchars($_GET['sms'], ENT_QUOTES));

$from_nr = $_GET['from'];

$operator = $_GET['operator'];

$key = $_GET['key'];

 

$category = explode(" ", $sms);

 

if(TestTransaction($transaction, $mokejimai_pass, $id)){

 

	$sms = ereg_replace("".$category[0]." ".$category[1]." ", "", $sms);

 

	if( strtolower($category[1]) == 'kodas' ){

 

 

			$kodas = substr(uniqid(mt_rand(), TRUE), 0, 5);

 

			mysql_query("INSERT INTO `kodai` (`kodas`,`nr`,`operator`,`amount`, `sms_id`) VALUES ('$kodas', '$from_nr', '$operator', '$amount', '$sms_id')");

 

			echo 'Jusu kodas: '.$kodas.'.'.$web_adress;

 

 

			/*

			$row_next = mysql_fetch_array(mysql_query("SHOW TABLE STATUS LIKE 'sms'"));

			$category = $category[1];

			*/

 

 

			/*

			mysql_query("INSERT INTO sms SET sms_id='$sms_id', transaction='$transaction', amount='$amount', time='$time', sms='$sms', from_nr='$from_nr', operator='$operator', category='$category'");

 

 

			echo "Skelbimas patalpintas.\n Skelbimo adresas: ".$web_adress."skelbimas-".$row_next["Auto_increment"]."\n Saugos kodas: ".substr($transaction, 0, 3)."".$sms_id."";

			*/

		}elseif( ( $category[1]=="m" || $category[1]=="v" || $category[1]=="k" || $category[1]=="M" || $category[1]=="V" || $category[1]=="K" ) AND $category[2] == NULL ){

 

 

			$random_row = mysql_fetch_row(mysql_query("SELECT * FROM sms WHERE category='".$category[1]."' ORDER BY RAND() LIMIT 1"));

			if($random_row['0']!=NULL){

				@mysql_query("INSERT INTO sms_nr SET sms_id='$sms_id', transaction='$transaction', amount='$amount', time='$time', sms='$sms', from_nr='$from_nr', operator='$operator', skelbimo_id='".$random_row['0']."'");

				echo "Atsitiktinio skelbimo adresas: ".$web_adress."skelbimas-".$random_row['0']."\n Autoriaus(-es) telefono numeris: ".$random_row['5']."";

 

			}else{

				echo "Klaida, siuo metu skelbimu nera!";

			}

		}elseif(is_numeric($category[1]) && $category[1]>"" && $category[1]>0){

		$total = mysql_fetch_array(mysql_query("SELECT count(id) FROM sms WHERE id='".$category[1]."'"));

		$total = $total[0];

 

		if($total==1){

			$row = mysql_fetch_array(mysql_query("SELECT * FROM sms WHERE id='".$category[1]."' LIMIT 1"));

			$skelbimo_id = $category[1];

			mysql_query("INSERT INTO sms_nr SET sms_id='$sms_id', transaction='$transaction', amount='$amount', time='$time', sms='$sms', from_nr='$from_nr', operator='$operator', skelbimo_id='$skelbimo_id'");

			echo "Skelbimo adresas: ".$web_adress."skelbimas-".$category[1]."\n Autoriaus(-es) telefono numeris: ".$row['from_nr']."";

		}else{

			echo "Klaida, blogas skelbimo ID!";

		}

	}elseif($category[1]=="meile" || $category[1]=="MEILE"){

 

			$love = "".$category[2]." myli ".$category[3]." ".rand(60,100)."%";

 

			echo "$love\n Nepamirsk stebinti maloniomis staigmenomis savo mylimo zmogaus!";

			mysql_query("INSERT INTO sms_nr SET sms_id='$sms_id', transaction='$transaction', amount='$amount', time='$time', sms='$sms', from_nr='$from_nr', operator='$operator', meiles_sk='$love'");

 

	}else{

		echo "Klaida, paslauga neteikiama!";

	}

 

}else{

	echo "Klaida, zinute netikra!";

}

 

function TestTransaction( $transaction, $userPassword, $ordeID, $test = 0, $status = 1 ){

	return ( $transaction == md5("{$userPassword}|{$_SERVER['REMOTE_ADDR']}|{$ordeID}|{$test}|{$status}") );

}

 

?>