API tools faq
paste
Guest User

index.php

a guest
Jan 17th, 2014
213
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 4.60 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3. include('../include/db.php');
  4. dbConnect();
  5. include('../include/config.php');
  6. include('../include/functions.php');
  7.  
  8. $today=date("Y-m-d H:i:s");
  9.  
  10. var_dump($_SESSION);
  11.  
  12. ?>
  13.  
  14. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  15. <html xmlns="http://www.w3.org/1999/xhtml">
  16.  
  17. <head>
  18. <title>Sportfant Home</title>
  19. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  20. <link href="../css/mainstyle.css" rel="stylesheet" type="text/css">
  21. <script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js" ></script>
  22. <script type="text/javascript" src="<?php echo $url; ?>js/functions.js"></script>
  23.  
  24. </head>
  25. <body>
  26. <?php
  27. if(strpos(curPageURL(),"checkout")===false)
  28.     $_SESSION['paypal_redirect']=curPageURL();
  29.    
  30. if(isset($_GET['paypal_code'])){
  31.     $pcode=mysql_real_escape_string($_GET['paypal_code']);
  32.     $result=mysql_query("select * from orders where code='$pcode' && confirmed=0");
  33.     if(mysql_num_rows($result)>0){
  34.         $payinfo=mysql_fetch_assoc($result);
  35.         mysql_query("update orders set confirmed=1 where id='$payinfo[id]' ");
  36.         mysql_query("update members set balance=balance+$payinfo[quantity] where id='$payinfo[member_id]' ");
  37.         mysql_query("insert into transactions (member_id,description,amount) values ('$payinfo[member_id]','Deposit','$payinfo[quantity]') ");
  38.     }
  39. }
  40.  
  41. if(isset($_SESSION['message'])){
  42.     echo "<div class='bigredbar'>".$_SESSION['message']."</div>";
  43.     unset($_SESSION['message']);
  44. }
  45.  
  46. if(isset($_SESSION[teamstuff])){
  47.     unset($_SESSION[teamstuff]);
  48. }
  49.  
  50. //if referral and user logged in, log them out
  51. if($_GET['referral'] && $_SESSION[user_id]){
  52.     unset($_SESSION[user_id]);
  53.     unset($_SESSION[username]);
  54.     unset($_SESSION[user_level]);
  55. }
  56.  
  57. $show_miss=0;
  58.  
  59. //get visitor's country
  60. $ip=$_SERVER['REMOTE_ADDR'];
  61. if(!isset($_SESSION['user_id'])){
  62.     $response=file_get_contents("http://api.ipinfodb.com/v3/ip-city/?key=e4dc977a58bf4974da9ba06f0e8925c00c4506fa1a21fe2c7c45dc839ab24214&ip=".$ip);
  63.     $response_arr=explode(";",$response);
  64.    
  65.     $usercountry=trim(ucwords(strtolower($response_arr[4])));   //user's country
  66.     $timediff=$response_arr[count($response_arr)-1];        //user's time difference relative to GMT
  67.     $usercity=trim(ucwords(strtolower($response_arr[6])));      //user's city
  68.    
  69.     if($usercountry=="Russian Federation")
  70.         $usercountry="Russia";
  71. }
  72. else{
  73.     //get current account info
  74.     $result=mysql_query("select * from members where id='$_SESSION[user_id]' ");
  75.     $accinfo=mysql_fetch_assoc($result);
  76.    
  77.     $next=$accinfo['account_type']+1;
  78.    
  79.     $today=date("Y-m-d");
  80.     $monthago=date("Y-m-d",time()-60*60*24*30);
  81.    
  82.     $meds=array(1,2,3,4,5,6,7,8,9,10,11);
  83.     //in the sub-arrays, keys are medal IDs and values are numbers of needed medals
  84.     $meds[1]=array(1=>0,2=>0,3=>0,4=>0,5=>0,6=>0,7=>0,8=>0,9=>0,10=>0,11=>0);
  85.     $meds[2]=array(1=>1,2=>1,3=>1,4=>1,5=>1,6=>0,7=>0,8=>0,9=>0,10=>0,11=>0);
  86.     $meds[3]=array(1=>3,2=>3,3=>3,4=>3,5=>3,6=>1,7=>0,8=>0,9=>0,10=>0,11=>0);
  87.     $meds[4]=array(1=>5,2=>5,3=>5,4=>5,5=>5,6=>2,7=>1,8=>0,9=>0,10=>0,11=>0);
  88.     $meds[5]=array(1=>7,2=>7,3=>7,4=>7,5=>7,6=>3,7=>2,8=>1,9=>0,10=>0,11=>0);
  89.     $meds[6]=array(1=>10,2=>9,3=>9,4=>9,5=>9,6=>5,7=>3,8=>2,9=>0,10=>0,11=>0);
  90.     $meds[7]=array(1=>13,2=>12,3=>12,4=>12,5=>12,6=>6,7=>4,8=>2,9=>1,10=>0,11=>0);
  91.     $meds[8]=array(1=>17,2=>15,3=>15,4=>15,5=>15,6=>8,7=>5,8=>3,9=>2,10=>0,11=>0);
  92.     $meds[9]=array(1=>19,2=>17,3=>17,4=>17,5=>17,6=>8,7=>6,8=>4,9=>3,10=>1,11=>0);
  93.     $meds[10]=array(1=>21,2=>19,3=>19,4=>19,5=>19,6=>8,7=>6,8=>4,9=>3,10=>2,11=>1);
  94.     $meds[11]=array(1=>21,2=>19,3=>19,4=>19,5=>19,6=>9,7=>7,8=>5,9=>4,10=>2,11=>2);
  95.    
  96.     $missing=0;
  97.    
  98.     foreach($meds[$next] as $medal_id => $num){
  99.         $result=mysql_query("select * from medals_awarded where member_id='$_SESSION[user_id]' && medal_id='$medal_id' && type='gold' order by date_time desc ");
  100.         $row=mysql_fetch_assoc($result);
  101.         $prev=mysql_num_rows($result);      //medals of this kind won up to this day
  102.         $total=$meds[$next][$medal_id]-$meds[$level][$medal_id];    //total spaces in the medal holder
  103.         $full=$prev-$meds[$level][$medal_id];
  104.         if($full>$total)
  105.             $full=$total;
  106.        
  107.         if($full<0)
  108.             $full=0;
  109.         $missing=$missing+$total-$full;
  110.     }
  111.    
  112.     //$missing is the number of missing medals
  113.     //if $missing is less than 3 and we're either on our office page or we haven't shown the popup for this level yet, show the popup
  114.     if($missing<3 && ($accinfo['medal_popup']<$accinfo['account_type'] || strpos(curPageURL(),"office.php")!==false)){
  115.         $show_miss=1;
  116.         mysql_query("update members set medal_popup=account_type where id='$_SESSION[user_id]' ");
  117.     }
  118.    
  119. }
  120. ?>
  121. <!-- page HTML -->
  122. </body>
  123. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!