aktivacevip.php:
Spoiler: zobrazit
Kód: Vybrat vše
Dekujeme za SMS Vase VIP bylo aktivovano.
<?php
$server = "93.91.250.111";
$port = "*****";
$heslo = "*****";
#################################
# Nezasahovat! #
#################################
$price_explode = $_GET['shortcode'];
$price_explode = explode("90333", $price_explode);
$price = $price_explode['1'];
$player_explode = $_GET['sms'];
if(strpos($_GET['sms'], "pm $keyword") !== false){
$player_explode = explode("pm $keyword ", $player_explode);
} elseif(strpos($_GET['sms'], "PM $keyword2") !== false){
$player_explode = explode("PM $keyword2 ", $player_explode);
} elseif(strpos($_GET['sms'], "Pm $keyword") !== false){
$player_explode = explode("Pm $keyword ", $player_explode);
}
$player = $player_explode['1'];
$commands = array();
#################################
# Cenové hladiny #
#################################
switch($price) {
case 99: //Cena 99Kè
$commands[] = "pex user ".$player." group set Majitel"; //Prikazy, ktere se maji vykonat po prijeti SMS za 99Kè
$commands[] = "say Hráè§a ".$player." §dsi aktivoval §6ExtraVIP§d. Dìkujeme mu...";
break;
case 79: //Cena 79Kè
$commands[] = "pex user ".$player." group set Majitel";
$commands[] = "say Hráè§a ".$player." §dsi aktivoval §eGold§6VIP§d. Dìkujeme mu...";
break;
case 20: //Cena 50Kè
$commands[] = "pex user ".$player." group set Majitel";
$commands[] = "say Hráè§a ".$player." §dsi aktivoval §6VIP§d. Dìkujeme mu...";
break;
}
include_once("rcon.php");
$r = new rcon($server,$port,$heslo);
if($r->Auth())
{
foreach($commands as $command)
$r->rconCommand($command);
}
//---------------------------------------//
$cislo = $_GET['shortcode'];
$cela_sms = $_GET['sms'];
$zeme = $_GET['country'];
$operator = $_GET['operator'];
$id = $_GET['id'];
$stav = $_GET['status'];
$serverXw = "mysql.fakaheda.eu"; // jméno serveru
$loginXw = "30**_web"; // pøihlašovací jméno
$hesloXw = "****"; // heslo
$databazeXw = "30**_web"; // název databáze
$mysqlXw = new mysqli("$serverXw", "$loginXw", "$hesloXw", "$databazeXw"); // Pøipojení k databázi
if ($mysqlXw->connect_errno) {echo "Vyskytla se chyba pri zapisu o Databaze";}
else{
$query = "INSERT INTO `mp_vypis` (`cislo` ,`tvar_sms` ,`zeme` ,`operator` ,`id_mp` ,`stav`) VALUES ('$cislo', '$cela_sms', '$zeme', '$operator', '$id', '$stav');";
$res = mysqli_query($mysqlXw, $query);
$mysqlXw->close();}
?>
Výpis na web:
Spoiler: zobrazit
Kód: Vybrat vše
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="author" content="Welton123">
<title>Výpis sms plateb</title>
<style>
body {
background: grey;
font-family: SEGOE UI;
}
.login {
background: white;
width: 500px;
height: 200px;
border-radius: 25px;
border: 1px solid grey;
margin: 0 auto 0 auto;
margin-top: 75px;
border: 2px solid black;
}
.vypis {
background: white;
width: 90%;
height: auto;
border: 1px solid grey;
margin: 0 auto 0 auto;
margin-top: 75px;
}
.tvurce {
background: white;
width: 500px;
height: 20px;
border-radius: 25px;
border: 1px solid grey;
margin: 0 auto 0 auto;
margin-top: 75px;
border: 2px solid black;
}
</style>
</head>
<body>
<p style="color:#3E3E3E;font-size:75px;text-align:center;">Sms Platby Crazy-Sector.eu</p>
<?php
include ('heslo.php');
?>
<?php
if($_GET['heslo'] == $pass OR $_GET['heslo'] == 'ag907ha'){?>
<div class="vypis" align="center">
<table border="1" cellpadding="1" cellspacing="0" align="center" style="text-align:center;width:100%;border: 1px solid black;">
<tr style="background:#303030;color:white;font-weight:bold;">
<td>Pořadí</td>
<td>ID</td>
<td>Tvar SMS</td>
<td>Číslo</td>
<td>Země</td>
<td>Operátor</td>
<td>Datum</td>
<td>Stav</td>
</tr>
<?php
$server = "mysql.fakaheda.eu";
$dbuser = "30**_web";
$dbpass = "******";
$dbname = "30**_web";
mysql_connect($server, $dbuser, $dbpass);
mysql_select_db($dbname);
$poradi = 1;
$vypis = mysql_query("SELECT * FROM mp_vypis ORDER BY datum DESC");
while($row = mysql_fetch_assoc($vypis)){?>
<tr style="background:white;color:black;;">
<td style="font-weight:bold;color:red;"><?echo $poradi++?>.</td>
<td><?echo $row['id_mp']?></td>
<td style="color:blue;"><?echo $row['tvar_sms']?></td>
<td style="color:blue;"><?echo $row['cislo']?></td>
<td style="color:green;"><?echo $row['zeme']?></td>
<td><?echo $row['operator']?></td>
<td>
<?
$datetime = $row['datum'];
List ($datum, $cas) = Explode (" ", $datetime);
List ($rok, $mesic, $den) = Explode ("-", $datum);
List ($hodina, $minuta, $sekunda) = Explode (":", $cas);
echo "$den.$mesic.$rok v $hodina:$minuta:$sekunda";
?>
</td>
<td>
<?
if($row['stav'] == ""){
echo "<img title='Doručeno' style='cursor:help;' src='http://banlist.mysty.cz/images/success.png'>";
} else {
echo "<img title='Nedoručeno' style='cursor:help;' src='http://banlist.mysty.cz/images/error.png'>";
}
?>
</td>
</tr>
<?}?>
</table>
</div>
<div class="tvurce" style="margin-top:5px;width:90%;">
<span style="color:black;font-size:15px;margin-left:5px;">© <?php echo date('Y');?> McBOY</span><span style="color:black;font-size:15px;float:right;margin-right:5px;">Překodoval McBOY</span>
</div>
<?} else {?>
<div class="login" align="center">
<form action="" method="GET">
<input type="text" style="margin-top:65px;height:25px;font-size:20px;border:1px solid black;width:300px;text-align:center;" placeholder="HESLO" name="heslo"><br />
<input type="submit" style="margin-top:45px;height:25px;font-size:20px;border:1px solid black;width:150px;text-align:center;" value="Zobrazit Platby"><br />
</form>
</div>
<div class="tvurce" style="margin-top:5px;">
<span style="color:black;font-size:15px;margin-left:5px;">© <?php echo date('Y');?> McBOY</span><span style="color:black;font-size:15px;float:right;margin-right:5px;">Překodoval McBOY</span>
</div>
<?}
?>
</body>
</html>
Vím že je tam i to db ale nezapisuje to vím že musím vytvořit tabulku v mysql ale nevím ty hodnoty.
A ještě jestli bych vás mohl poprosit jestli by nešlo vyvolávat ten script pomocí hodnot přes url