CashShop Extract SQL

Results 1 to 12 of 12
  1. #1
    RaGEZONER maxcloud is offline
    MemberRank
    Feb 2009 Join Date
    312Posts

    CashShop Extract SQL

    This release is made for Generic's CashShop SQL Release. You can find it on Kdev...I hope this helps some people, and gives the pros a lol. :)


    CashExtract.java
    Code:
    // @Author Maxcloud of MapleFresh.
    
    package tools;
    
    import java.io.*;
    import java.util.Iterator;
    import provider.*;
    
    public class CashExtract
    {
    
        public CashExtract()
        {
        }
    
        public static void main(String args[])
            throws FileNotFoundException, IOException
        {
            File IntegerFile = MapleDataProviderFactory.fileInWZPath("Etc.wz");
            MapleDataProvider IntegerProvider = MapleDataProviderFactory.getDataProvider(IntegerFile);
            MapleData cash = IntegerProvider.getData("Commodity.img");
            String output = args[0];
            File outputDir = new File(output);
            File cashTxt = new File((new StringBuilder()).append(output).append("\\Commodity.txt").toString());
            outputDir.mkdir();
            cashTxt.createNewFile();
            System.out.println("Dumping Commodity.img string...");
            PrintWriter writer = new PrintWriter(new FileOutputStream(cashTxt));
            MapleData child;
            int countx;
            int genderx;
            int itemx;
            int onsalex;
            int periodx;
            int pricex;
            int priorityx;
            int snx;
            for(Iterator i$ = cash.getChildren().iterator(); i$.hasNext(); writer.println((new StringBuilder()).append("(").append(child.getName()).append(",").append(snx).append(",").append(itemx).append(",").append(countx).append(",").append(pricex).append(",").append(periodx).append(",").append(priorityx).append(",").append(genderx).append(",").append(onsalex).append(")").append(",").toString()))
            {
                child = (MapleData)i$.next();
                MapleData countData = child.getChildByPath("Count");
                MapleData genderData = child.getChildByPath("Gender");
                MapleData itemData = child.getChildByPath("ItemId");
                MapleData onsaleData = child.getChildByPath("OnSale");
                MapleData periodData = child.getChildByPath("Period");
                MapleData priceData = child.getChildByPath("Price");
                MapleData priorityData = child.getChildByPath("Priority");
                MapleData snData = child.getChildByPath("SN");
                String count = "0";
                countx = Integer.parseInt(count);
                String gender = "0";
                genderx = Integer.parseInt(gender);
                String item = "0";
                itemx = Integer.parseInt(item);
                String onsale = "0";
                onsalex = Integer.parseInt(onsale);
                String period = "0";
                periodx = Integer.parseInt(period);
                String price = "0";
                pricex = Integer.parseInt(price);
                String priority = "0";
                priorityx = Integer.parseInt(priority);
                String sn = "0";
                snx = Integer.parseInt(sn);
                if(countData != null)
                    countx = ((Integer)countData.getData()).intValue();
                if(genderData != null)
                    genderx = ((Integer)genderData.getData()).intValue();
                if(itemData != null)
                    itemx = ((Integer)itemData.getData()).intValue();
                if(onsaleData != null)
                    onsalex = ((Integer)onsaleData.getData()).intValue();
                if(periodData != null)
                    periodx = ((Integer)periodData.getData()).intValue();
                if(priceData != null)
                    pricex = ((Integer)priceData.getData()).intValue();
                if(priorityData != null)
                    priorityx = ((Integer)priorityData.getData()).intValue();
                if(snData != null)
                    snx = ((Integer)snData.getData()).intValue();
            }
    
            writer.flush();
            writer.close();
            System.out.println("Commodity.img complete.");
        }
    }
    Last edited by maxcloud; 27-01-10 at 03:57 PM.


  2. #2
    Member C_plus_plus is offline
    MemberRank
    Nov 2009 Join Date
    79Posts

    Re: CashShop Extract SQL

    Nice one :d

  3. #3
    return null; mertjuh is offline
    MemberRank
    Dec 2008 Join Date
    The NetherlandsLocation
    1,269Posts

    Re: CashShop Extract SQL

    I wish we know what this is

  4. #4
    Account Upgraded | Title Enabled! Generic230 is offline
    MemberRank
    Jul 2009 Join Date
    506Posts

    Re: CashShop Extract SQL

    Quote Originally Posted by maxcloud View Post
    This release is made for Generic's CashShop SQL Release. You can find it on Kdev...I hope this helps some people, and gives the pros a lol. :)


    CashExtract.java
    Code:
    // @Author Maxcloud of MapleFresh.
    
    package tools;
    
    import java.io.*;
    import java.util.Iterator;
    import provider.*;
    
    public class CashExtract
    {
    
        public CashExtract()
        {
        }
    
        public static void main(String args[])
            throws FileNotFoundException, IOException
        {
            File IntegerFile = MapleDataProviderFactory.fileInWZPath("Etc.wz");
            MapleDataProvider IntegerProvider = MapleDataProviderFactory.getDataProvider(IntegerFile);
            MapleData cash = IntegerProvider.getData("Commodity.img");
            String output = args[0];
            File outputDir = new File(output);
            File cashTxt = new File((new StringBuilder()).append(output).append("\\Commodity.txt").toString());
            outputDir.mkdir();
            cashTxt.createNewFile();
            System.out.println("Dumping Commodity.img string...");
            PrintWriter writer = new PrintWriter(new FileOutputStream(cashTxt));
            MapleData child;
            int countx;
            int genderx;
            int itemx;
            int onsalex;
            int periodx;
            int pricex;
            int priorityx;
            int snx;
            for(Iterator i$ = cash.getChildren().iterator(); i$.hasNext(); writer.println((new StringBuilder()).append("(").append(child.getName()).append(",").append(snx).append(",").append(itemx).append(",").append(countx).append(",").append(pricex).append(",").append(periodx).append(",").append(priorityx).append(",").append(genderx).append(",").append(onsalex).append(")").append(",").toString()))
            {
                child = (MapleData)i$.next();
                MapleData countData = child.getChildByPath("Count");
                MapleData genderData = child.getChildByPath("Gender");
                MapleData itemData = child.getChildByPath("ItemId");
                MapleData onsaleData = child.getChildByPath("OnSale");
                MapleData periodData = child.getChildByPath("Period");
                MapleData priceData = child.getChildByPath("Price");
                MapleData priorityData = child.getChildByPath("Priority");
                MapleData snData = child.getChildByPath("SN");
                String count = "0";
                countx = Integer.parseInt(count);
                String gender = "0";
                genderx = Integer.parseInt(gender);
                String item = "0";
                itemx = Integer.parseInt(item);
                String onsale = "0";
                onsalex = Integer.parseInt(onsale);
                String period = "0";
                periodx = Integer.parseInt(period);
                String price = "0";
                pricex = Integer.parseInt(price);
                String priority = "0";
                priorityx = Integer.parseInt(priority);
                String sn = "0";
                snx = Integer.parseInt(sn);
                if(countData != null)
                    countx = ((Integer)countData.getData()).intValue();
                if(genderData != null)
                    genderx = ((Integer)genderData.getData()).intValue();
                if(itemData != null)
                    itemx = ((Integer)itemData.getData()).intValue();
                if(onsaleData != null)
                    onsalex = ((Integer)onsaleData.getData()).intValue();
                if(periodData != null)
                    periodx = ((Integer)periodData.getData()).intValue();
                if(priceData != null)
                    pricex = ((Integer)priceData.getData()).intValue();
                if(priorityData != null)
                    priorityx = ((Integer)priorityData.getData()).intValue();
                if(snData != null)
                    snx = ((Integer)snData.getData()).intValue();
            }
    
            writer.flush();
            writer.close();
            System.out.println("Commodity.img complete.");
        }
    }
    cash shop SQL wasn't made by me, it was from someone else, i was told not to credit.

  5. #5
    Alpha Member Hennessy`' is offline
    MemberRank
    Dec 2009 Join Date
    in a CaveLocation
    2,298Posts

    Re: CashShop Extract SQL

    Wait I want to know what does this do

  6. #6
    Account Upgraded | Title Enabled! PinkGatsby is offline
    MemberRank
    Mar 2009 Join Date
    AmericaLocation
    434Posts

    Re: CashShop Extract SQL

    @ The above posters saying 'nice' etc.
    Do you see anything beneficial about this release ? Because I don't.

  7. #7
    Account Upgraded | Title Enabled! Colors is offline
    MemberRank
    Jan 2010 Join Date
    ParadiseLocation
    385Posts

    Re: CashShop Extract SQL

    Credits are missing.

  8. #8
    Valued Member FluffyMS is offline
    MemberRank
    Oct 2008 Join Date
    105Posts

    Re: CashShop Extract SQL

    If you read the top part, it's to extrAct cash items from the xmls to implement newer cs's into a previous version.

    So yeah, its beneficial, at least i think so.
    Posted via Mobile Device

  9. #9
    Account Upgraded | Title Enabled! Colors is offline
    MemberRank
    Jan 2010 Join Date
    ParadiseLocation
    385Posts

    Re: CashShop Extract SQL

    Quote Originally Posted by FluffyMS View Post
    If you read the top part, it's to extrAct cash items from the xmls to implement newer cs's into a previous version.

    So yeah, its beneficial, at least i think so.
    Posted via Mobile Device
    Alright sorry, =] i was just pointing it out.

  10. #10
    Account Upgraded | Title Enabled! PinkGatsby is offline
    MemberRank
    Mar 2009 Join Date
    AmericaLocation
    434Posts

    Re: CashShop Extract SQL

    Quote Originally Posted by FluffyMS View Post
    If you read the top part, it's to extrAct cash items from the xmls to implement newer cs's into a previous version.

    So yeah, its beneficial, at least i think so.
    Posted via Mobile Device
    LMFAOOO.. you're funny :)

  11. #11
    DIGLETT MASTER - UG LDR blawgwarmzz is offline
    MemberRank
    Sep 2009 Join Date
    undagrounmdLocation
    297Posts

    Re: CashShop Extract SQL

    Quote Originally Posted by PinkGatsby View Post
    LMFAOOO.. you're funny :)
    not standing up or anything, but did I miss a joke? O_O

  12. #12
    RaGEZONER maxcloud is offline
    MemberRank
    Feb 2009 Join Date
    312Posts

    Re: CashShop Extract SQL

    Quote Originally Posted by Alcohol View Post
    Credits are missing.
    lol?

    Quote Originally Posted by PinkGatsby View Post
    @ The above posters saying 'nice' etc.
    Do you see anything beneficial about this release ? Because I don't.
    How is it not beneficial? It creates a file, that enables you to update your Sql Cashshop.



Advertisement