Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function getRandomString($length) {
- $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
- $string = '';
- for ($i = 0; $i < $length; $i++) {
- $string .= $characters[mt_rand(0, strlen($characters) - 1)];
- }
- return $string;
- }
- function new_ref()
- {
- $userip=$_SERVER['REMOTE_ADDR'];
- $query="SELECT * FROM cookie_ref_ips WHERE IP_address='$userip'";
- $exe=mysql_query($query);
- $num=mysql_num_rows($exe) or die(mysql_error());
- if ($num==0)
- {
- $refval=getRandomString(10);
- $query="SELECT * FROM cookie_ref_ips WHERE REF_val='$refval'";
- $exe=mysql_query($query);
- $num=mysql_num_rows($exe) or die(mysql_error());
- if($num==0)
- {
- $query="INSERT INTO cookie_ref_ips(IP_address,REF_val) values('$userip','$refval')";
- mysql_query($query);
- $query="INSERT INTO cookie_ref(REF_hits,ip,REF_val) values('0','$userip','$refval')";
- mysql_query($query);
- }
- }
- $query="INSERT INTO cookie_ref(IP_address,REF_val) values('$userip','$refval')";
- }
- function dbConnect() {
- // update this to your db details
- mysql_connect('localhost', 'microsof_user2', 'cupcake123')or die(mysql_error());
- mysql_select_db('microsof_league')or die(mysql_error());
- }
- function get_link()
- {
- $userip=$_SERVER['REMOTE_ADDR'];
- $query="SELECT * FROM cookie_ref_ips WHERE IP_address='$userip'";
- $exe=mysql_query($query);
- $exe2=mysql_fetch_array($exe) or die(mysql_error());
- $referal=$exe2['REF_val'];
- return $referal;
- }
- function update_hits()
- {
- if(isset($_GET['ref']))
- {
- $ip=$_SERVER['REMOTE_ADDR'];
- $ref=$_GET['ref'];
- $query="SELECT * FROM cookie_ref WHERE REF_val='$ref'";
- $exe=mysql_query($query);
- $result=mysql_fetch_array($exe);
- $Oip=$result['ip'];
- $hit_temp=$result['REF_hits'];
- $hit_temp++;
- if($ip!=$Oip)
- {
- $query="UPDATE cookie_ref set REF_hits='$hit_temp' WHERE REF_val='$ref'";
- mysql_query($query);
- }
- }
- }
- function count_hits()
- {
- $userip=$_SERVER['REMOTE_ADDR'];
- $query="SELECT * FROM cookie_ref WHERE ip='$userip'";
- $exe=mysql_query($query);
- $result=mysql_fetch_array($exe) or die(mysql_error());
- $count=$result['REF_hits'];
- return $count;
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement