Advertisement
Guest User

Plugin Chris

a guest
Mar 10th, 2016
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.52 KB | None | 0 0
  1. <?php
  2. namespace wcf\system\event\listener;
  3. use wcf\system\event\IEventListener;
  4.  
  5. /**
  6. * @author Christopher Walz
  7. * @license http://www.cwalz.de/forum/index.php?page=TermsOfLicense
  8. * @package de.cwalz.donationExtended
  9. */
  10. class DonationExtendedListener implements IEventListener {
  11.  
  12. /**
  13. * @see wcf\system\event\IEventListener::execute()
  14. */
  15. public function execute($eventObj, $className, $eventName) {
  16. if ($eventObj->getActionName() == 'create') {
  17. $returnValues = $eventObj->getReturnValues();
  18. $donation = $returnValues['returnValues'];
  19.  
  20. /*
  21. Über $donation->userID kommst du z.B. an die BenutzerID und über $donation->amount an den Spendenwert.
  22. Es stehen die hier alle Spaltennamen aus der Tabelle wcf1_donation zur Verfügung.
  23. */
  24.  
  25. // hier dein Script einfügen
  26. $mc_servername = "85.43.192.178";
  27. $mc_username = "plug";
  28. $mc_password = "bZgsJEse!";
  29. $mc_dbname = "hex";
  30. $forum_servername = "localhost";
  31. $forum_username = "web2945";
  32. $forum_password = "hegUksz!23";
  33. $forum_dbname = "usr_web2945_3";
  34.  
  35. try {
  36. //CONNECTION
  37. $conn = new PDO("mysql:host=$mc_servername;dbname=$mc_dbname", $mc_username, $mc_password);
  38. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  39.  
  40. $forum = new PDO("mysql:host=$forum_servername;dbname=$forum_dbname", $forum_username, $forum_password);
  41. $forum->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  42.  
  43. //New Update
  44. $userid = $donation->userID;
  45. //$userid = 1;
  46.  
  47. //GET KEY
  48. $getuserid = $forum->prepare("SELECT userOption30 FROM wcf1_user_option_value WHERE userID='".$userid."' LIMIT 1");
  49. $getuserid->execute();
  50.  
  51. //DEFINING KEY
  52. $reultadoa = $getuserid->fetch();
  53. $notkey = $reultadoa['userOption30'];
  54.  
  55. //print_r($notkey);
  56.  
  57. //GET KEY
  58. $receberkey = $conn->prepare("SELECT name FROM permissions WHERE value='".$notkey."' LIMIT 1");
  59. $receberkey->execute();
  60.  
  61. //DEFINING KEY
  62. $reultado = $receberkey->fetch();
  63. $key = $reultado['name'];
  64.  
  65. //This will show the key!
  66. //print_r($key);
  67.  
  68. //INSERT
  69. $inserir = "INSERT INTO permissions (name, type, permission, world, value) VALUES ('".$key."', '1', 'group-Premium-until', 'world', 1460116664)";
  70. $conn->exec($inserir);
  71.  
  72. //SUCCESS
  73.  
  74. }
  75. catch(PDOException $e) {
  76. //ERRORS
  77. echo "<meta charset='UTF-8'>Error:<br>" . $e->getMessage();
  78. }
  79. $conn = null;
  80. }
  81. }
  82. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement