Advertisement
plaguewolf

Untitled

Oct 14th, 2015
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.97 KB | None | 0 0
  1.  
  2. key myRequest;
  3. string ownerUUID;
  4.  
  5. default
  6. {
  7. state_entry()
  8. {
  9. ownerUUID = llGetOwnerKey(llGetOwner());
  10. llOwnerSay("UUID: " + ownerUUID);
  11.  
  12.  
  13. myRequest = llHTTPRequest("http://myurl.com/db.php", [HTTP_METHOD, "POST",
  14. HTTP_MIMETYPE, "application/x-www-form-urlencoded"],
  15. "ownerUUID=" + (string)ownerUUID);
  16.  
  17. llOwnerSay((string)myRequest);
  18. }
  19.  
  20.  
  21. http_response(key request_id, integer status, list metadata, string body)
  22. {
  23. if (request_id == myRequest)
  24. {
  25. llOwnerSay((string)status + " " + body);
  26.  
  27. }
  28. }
  29.  
  30. }
  31.  
  32.  
  33. //////////////////
  34. PHP
  35. ///////////////////
  36.  
  37. <?php
  38. $database = "db";
  39. $table = "table";
  40. $db_host = "localhost";
  41. $db_user = "user";
  42. $db_pass = "pass";
  43.  
  44. // request data string
  45. $id = $_GET['id'];
  46. $uuid = $_GET['uuid'];
  47. $ownerUUID = $_GET['ownerUUID'];
  48. $object_name = $_GET['object_name'];
  49. $objectDNS = $_GET['objectDNS'];
  50.  
  51. mysql_connect($db_host, $db_user, $db_pass)or die("cannot connect to database!");
  52. mysql_select_db($database)or die("cannot select database");
  53.  
  54.  
  55. $result = mysql_query("SELECT * FROM $table WHERE ownerUUID='$ownerUUID'");
  56.  
  57. while($row = mysql_fetch_array($result, MYSQL_ASSOC))
  58. {
  59.  
  60.  
  61.  
  62. $id = $row['id'];
  63. $uuid = $row['uuid'];
  64. $ownerUUID = $row['ownerUUID'];
  65. $object_name = $row['object_name'];
  66. $objectDNS = $row['objectDNS'];
  67.  
  68. $id = htmlspecialchars($row['id'],ENT_QUOTES);
  69. $uuid = htmlspecialchars($row['uuid'],ENT_QUOTES);
  70. $ownerUUID = htmlspecialchars($row['ownerUUID'],ENT_QUOTES);
  71. $object_name = htmlspecialchars($row['object_name'],ENT_QUOTES);
  72.  
  73. // We will now print the comment to the screen
  74.  
  75. echo " <div style='margin:30px 0px;'>
  76. id: $id<br />
  77. uuid: $uuid<br />
  78. ownerUUID: $ownerUUID<br />
  79. object_name: $object_name<br />
  80. objectDNS: $objectDNS
  81. </div>
  82. ";
  83. }
  84.  
  85. mysql_close($con);
  86.  
  87.  
  88. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement