SQL Modification for web shop #43


  • Other
  • Accepted
Open
Assigned to _ForgeUser7265008
  • _ForgeUser11931136 created this issue Jul 30, 2013

    hello,
    this plugin is interesting but is it possible to have a database that is not compressed?

    example:

    table sql = inventory

    row 1,2,3,4,5 ... = id, idplayer, inventory slot 1,2,3,4,5 ..., Item Name, enchantment, Number of items.

    table sql 2 =  player
    row 1 = id, player, server

    it would be very useful for creating a web shop for the server that automatically delivers what has been purchased.
    Finally there should be a system refresh that read the database every two minutes to update the player's inventory.

    Thank's

  • _ForgeUser11931136 added the tags New Other Jul 30, 2013
  • _ForgeUser7265008 posted a comment Jul 30, 2013

    Hello corsinu, basically Compression is easy to modify. You just need to create a Plugin and extend the Compressor interface and make a Version which does not compress anything. Adding a extra table which is not compressed does not seem to be usefull at all. Delivering items would be better if InventorySQL adds a extra Table for (post?-)delivery

  • _ForgeUser11931136 posted a comment Jul 30, 2013

    you can not make a special version not compressed for that? I know nothing about java I do not know how to create a plugin

    can you tell me how to do that? or, you can create this extension?

    thank's

  • _ForgeUser7337015 posted a comment Sep 15, 2013

    I'm looking for the same thing. I want to display the inventory on my website, but I can't use the inventory data compressed from the web.

    Thanks

  • _ForgeUser7265008 posted a comment Sep 16, 2013

    Decompressing in php is easy as pie:

    //Get mysql con 
    echo gzdecode($result['armor']);
    
    // Source: http://php.net/manual/en/function.gzdecode.php
    function gzdecode($data) { 
       return gzinflate(substr($data,10,-8)); 
    }
    

    Edited Sep 16, 2013
  • _ForgeUser7265008 removed a tag New Sep 18, 2013
  • _ForgeUser7265008 added a tag Accepted Sep 18, 2013

To post a comment, please login or register a new account.