[ADMN] Redeem v1.5 - Transfer items and iConomy money from MySQL to player [1000]

Discussion in 'Inactive/Unsupported Plugins' started by Paah, Jul 4, 2011.

Page 3 of 3
  1. Offline

    Paah

    Redeem - The item redeemer
    Version: 1.5

    Redeem retrieves player's items from MySQL database and places them in his/her inventory. This is particularly useful for server admins who want to be able to grant items to their players as a thank you for donation automatically.

    How to use
    Users - Just type /redeem
    Admins:

    Show Spoiler
    Just insert correct MySQL information to the config file and reload/restart server.
    However, for the plugin to actually do anything, you will need some interaction on your website.
    Here is an example PHP script:
    Code:
    php said: 
<html>
<head>
<title>Redeem</title>
</head>
<body>
<form method="post" action="redeem.php">
Playername: <input type="text" name="Player" size="45" /> <br />
Data input: <input type="text" name="Input" size="45" /> <br />
<input type="submit" value="Add to database" />
</form>
</body>
</html>
    Name this whatever you want (.php)
    Code:
    php said: 
<?php
//Input correct values into this section
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'pass';
$dbname = 'minecraft';
$dbtable = 'redeem';
//---------------------------------------

$input = $_POST['Input'];
$player = $_POST['Player'];
$conn = mysql_connect ($dbhost, $dbuser, $dbpass) or die ('Error: ' . mysql_error());
mysql_select_db($dbname);
$query = "INSERT INTO `".$dbname."`.`".$dbtable."` (`player`, `item`) VALUES ('".$player."', '".$input."')";
mysql_query($query);
mysql_close($conn);
echo "Done!";
?>
    Name this one redeem.php and insert your mysql data into the appropriate section.
    Access the first file with your browser for simple data input form. Users will be immediately able to retrieve their items with /redeem command. Correct syntax for input is "<item> <amount>". Without amount it will default to 1. Item should either be the item's data value or name. "diamond 7" would grant 7 diamonds. Use item "money" for iConomy money. You can add ":<number>" behind item name to use damage values. For example "wool:15 27" for 27 black wool.

    Please note that this is not the recommended way to use this plugin. Quite honestly, it will be pretty much useless in this state. You should integrate it into your donation system / whatever you want to make the most of it. This is just overly basic example and functionality tester.



    Download
    <font color="red">If updating from 1.3 or lower, use command "/redeem convert" to update your database. (Requires op)</font>
    <Edit by Moderator: Redacted mediafire url>
    <Edit by Moderator: Redacted mediafire url>
    Place the connector into /lib/ folder in your server root. If you have the connector already no no need to download it again.


    Changelog:
    * 1.5 - Added support for damage values.
    * 1.4 - Updated database structure, sealed up memory leaks, fixed bugs..
    * 1.3 - Now supports iConomy5, use item "money".
    * 1.2 - Added automatic table creation
    * 1.1 - Fixed an issue related to connections.
    * 1.0 - Release

    Known bugs:
    * Plugin will think player's inventory is full if there are no free slots, even if there is partly empty stack of item.

    TODO:
    * Configurable messages
    * Grant permission nodes
    * Grant (permission) group memberships
    * Automatic group membership/permission expiration system
     
    Last edited by a moderator: Nov 27, 2016
    Paah, Jul 4, 2011
    #1
    blaize9 and olimoli123 like this.
  2. Offline

    BigZ94

    Could you put it for download please, would be awesome
     
    BigZ94, Mar 13, 2012
    #61
  3. Offline

    neoteknic

    Yes but it's translated in french, so I need to make a english version too.
    I will upload it soon on my server.
     
    neoteknic, Mar 14, 2012
    #62
  4. Offline

    Fluxty

    The MYSQL connector file is missing.
     
    Fluxty, May 2, 2012
    #63
  5. Offline

    md_5

    Long time no see Paah. You will notice that this thread has now been placed into the Inactive Plugin subforum.
    If you wish to revive this plugin, please ensure that you update and test compatibility with the latest recommended Bukkit build before reporting your original post, asking for it to be moved back to the release forum.

    Thanks for your time.
    md_5
     
    md_5, Oct 12, 2012
    #64
Page 3 of 3

Share This Page