Files
EQN/appServer/distquake_upload_subscription.php
2017-09-22 15:16:26 +02:00

90 lines
3.2 KiB
PHP

<?php
$ini = parse_ini_file("conf.ini", true);
mysql_connect($ini['db']['host'],$ini['db']['user'],$ini['db']['pass']);
mysql_select_db($ini['db']['db']);
if ($ini['db']['log']=="1"){
$arrival_time=microtime(true);
$filename=basename(__FILE__);
$filename="log_".$filename.".txt";
$chunck=strval($arrival_time)." ".$_SERVER['REQUEST_URI']."\r\n";
file_put_contents($filename,$chunck,FILE_APPEND);
}
mysql_set_charset("utf8");
$user_id=$_REQUEST['u_id'];
$token_sub=$_REQUEST['token_sub'];
$wallet_sub=$_REQUEST['wallet_sub'];
$sku=$_REQUEST['sku'];
$sql=mysql_query("select ID from subscriptions where user_id=$user_id limit 1");
if (mysql_num_rows($sql))
{
$add=0;
$id=mysql_result($sql,0,"ID");
}
else
{
$add=1;
}
if ($add==1){
if (strcmp($sku,'top_100a')==0){
$sql=mysql_query("insert into subscriptions (user_id,token,wallet,top_100,pro) values ($user_id,'$token_sub','$wallet_sub',1,0)");
}
if (strcmp($sku,'top_1000a')==0){
$sql=mysql_query("insert into subscriptions (user_id,token,wallet,top_1000,pro) values ($user_id,'$token_sub','$wallet_sub',1,0)");
}
if (strcmp($sku,'top_10000a')==0){
$sql=mysql_query("insert into subscriptions (user_id,token,wallet,top_10000,pro) values ($user_id,'$token_sub','$wallet_sub',1,0)");
}
if (strcmp($sku,'top_100a_annual')==0){
$sql=mysql_query("insert into subscriptions (user_id,token,wallet,top_100_annual,pro) values ($user_id,'$token_sub','$wallet_sub',1,0)");
}
if (strcmp($sku,'top_1000a_annual')==0){
$sql=mysql_query("insert into subscriptions (user_id,token,wallet,top_1000_annual,pro) values ($user_id,'$token_sub','$wallet_sub',1,0)");
}
if (strcmp($sku,'top_10000a_annual')==0){
$sql=mysql_query("insert into subscriptions (user_id,token,wallet,top_10000_annual,pro) values ($user_id,'$token_sub','$wallet_sub',1,0)");
}
if ($sql==true){
print("ok");
}
else{
print("ko");
}
}
else{
if (strcmp($sku,'top_100a')==0){
$sql=mysql_query("update subscriptions set token='$token_sub',wallet='$wallet_sub',top_100=1,pro=0 where ID=$id");
}
if (strcmp($sku,'top_1000a')==0){
$sql=mysql_query("update subscriptions set token='$token_sub',wallet='$wallet_sub',top_1000=1,pro=0 where ID=$id");
}
if (strcmp($sku,'top_10000a')==0){
$sql=mysql_query("update subscriptions set token='$token_sub',wallet='$wallet_sub',top_10000=1,pro=0 where ID=$id");
}
if (strcmp($sku,'top_100a_annual')==0){
$sql=mysql_query("update subscriptions set token='$token_sub',wallet='$wallet_sub',top_100_annual=1,pro=0 where ID=$id");
}
if (strcmp($sku,'top_1000a_annual')==0){
$sql=mysql_query("update subscriptions set token='$token_sub',wallet='$wallet_sub',top_1000_annual=1,pro=0 where ID=$id");
}
if (strcmp($sku,'top_10000a_annual')==0){
$sql=mysql_query("update subscriptions set token='$token_sub',wallet='$wallet_sub',top_10000_annual=1,pro=0 where ID=$id");
}
if ($sql==true){
print("ok");
}
else{
print("ko");
}
}
mysql_close();
?>