Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- namespace wcf\system\event\listener;
- use wcf\system\event\IEventListener;
- /**
- * @author Christopher Walz
- * @license http://www.cwalz.de/forum/index.php?page=TermsOfLicense
- * @package de.cwalz.donationExtended
- */
- class DonationExtendedListener implements IEventListener {
- /**
- * @see wcf\system\event\IEventListener::execute()
- */
- public function execute($eventObj, $className, $eventName) {
- if ($eventObj->getActionName() == 'create') {
- $returnValues = $eventObj->getReturnValues();
- $donation = $returnValues['returnValues'];
- /*
- Über $donation->userID kommst du z.B. an die BenutzerID und über $donation->amount an den Spendenwert.
- Es stehen die hier alle Spaltennamen aus der Tabelle wcf1_donation zur Verfügung.
- */
- // hier dein Script einfügen
- $mc_servername = "85.43.192.178";
- $mc_username = "plug";
- $mc_password = "bZgsJEse!";
- $mc_dbname = "hex";
- $forum_servername = "localhost";
- $forum_username = "web2945";
- $forum_password = "hegUksz!23";
- $forum_dbname = "usr_web2945_3";
- try {
- //CONNECTION
- $conn = new PDO("mysql:host=$mc_servername;dbname=$mc_dbname", $mc_username, $mc_password);
- $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $forum = new PDO("mysql:host=$forum_servername;dbname=$forum_dbname", $forum_username, $forum_password);
- $forum->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- //New Update
- $userid = $donation->userID;
- //$userid = 1;
- //GET KEY
- $getuserid = $forum->prepare("SELECT userOption30 FROM wcf1_user_option_value WHERE userID='".$userid."' LIMIT 1");
- $getuserid->execute();
- //DEFINING KEY
- $reultadoa = $getuserid->fetch();
- $notkey = $reultadoa['userOption30'];
- //print_r($notkey);
- //GET KEY
- $receberkey = $conn->prepare("SELECT name FROM permissions WHERE value='".$notkey."' LIMIT 1");
- $receberkey->execute();
- //DEFINING KEY
- $reultado = $receberkey->fetch();
- $key = $reultado['name'];
- //This will show the key!
- //print_r($key);
- //INSERT
- $inserir = "INSERT INTO permissions (name, type, permission, world, value) VALUES ('".$key."', '1', 'group-Premium-until', 'world', 1460116664)";
- $conn->exec($inserir);
- //SUCCESS
- }
- catch(PDOException $e) {
- //ERRORS
- echo "<meta charset='UTF-8'>Error:<br>" . $e->getMessage();
- }
- $conn = null;
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement