Advertisement
Guest User

Untitled

a guest
Nov 13th, 2016
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1. <?php
  2. $host = "localhost";
  3. $user = "*****";
  4. $pass = "******";
  5. $data = "****";
  6.  
  7. $connection = mysql_connect($host,$user,$pass)
  8. or die("Could not connect: ".mysql_error());
  9. mysql_select_db($data,$connection)
  10. or die("Error in selecting the database:".mysql_error());
  11.  
  12. $Query1 = mysql_Query("SELECT * FROM catalog_items WHERE daily_gift = '1' ORDER BY RAND() LIMIT 1");
  13.  
  14. IF($gift = mysql_fetch_array($Query1)){
  15. $user = mysql_real_escape_string($gift['user_id']);
  16. $item = mysql_real_escape_string($gift['item_id']);
  17. $name = mysql_real_escape_string($gift['catalog_name']);
  18.  
  19.  
  20. $sql1 = mysql_Query("INSERT INTO `items` (user_id, base_item) VALUES ('".$_SESSION['user']['id']."', '"$gift['item_id']"')") or die(mysql_error());
  21. echo "<div style='padding:10px;background-color:green;border-radius:3px;font-family:arial;font-size:12px;color:#FFF;text-align:center;'>You have been given a <b>" . $name . "</b>!</div>";
  22.  
  23. }
  24. sleep(86400);
  25. if (sleep = 0)
  26. echo 'Reload this page'
  27. else (
  28. echo 'You must wait till tomorrow to open another gift'
  29. }
  30. exit();
  31. else {
  32.  
  33. }
  34. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement