Jump to content

teuneboon

Members
  • Posts

    19
  • Joined

  • Last visited

Posts posted by teuneboon

  1. I tried hard, but I just keep getting #Error(Parse Error). This is the code I use:

    =Index(ImportHtml(Concat("http://itemdb-rs.runescape.com/results.ws?query=",A2), "table", 2),2,3)

     

    The spreadsheet is:

    http://spreadsheets.google.com/ccc?key=0AjhQ7wHYDKCOdE1MazltMXhhbnJ2NF9yQ2ZLSmdMVnc&hl=nl&authkey=CLqMvRY

    Check column J, the error is there. I used Chrome on Ubuntu to create this, but it should work, since when I view other spreadsheets that use this method it also works.

     

    For those who want to know what this is about: it will be my Merchanting Log, the first entry is fake by the way ;)

    Just tried your code on my sheet and it worked fine. I can't imagine browser/OS would make a difference. One thing I would try: make a new sheet (in the same doc) and try to get it working there, without all the other things you have on your current sheet. Just "Dark Bow" and your code. You may need to reload the sheet or something to get it to work, though I hardy ever find that to be the case.

    I tried it in all different browsers and on windows too. Still can't get it to work. This is just plain weird XD

    Yeah, very odd. Did you try it on a new sheet like I said above?

    Yes I did, also tried it on different pcs XD

  2. I tried hard, but I just keep getting #Error(Parse Error). This is the code I use:

    =Index(ImportHtml(Concat("http://itemdb-rs.runescape.com/results.ws?query=",A2), "table", 2),2,3)

     

    The spreadsheet is:

    http://spreadsheets.google.com/ccc?key=0AjhQ7wHYDKCOdE1MazltMXhhbnJ2NF9yQ2ZLSmdMVnc&hl=nl&authkey=CLqMvRY

    Check column J, the error is there. I used Chrome on Ubuntu to create this, but it should work, since when I view other spreadsheets that use this method it also works.

     

    For those who want to know what this is about: it will be my Merchanting Log, the first entry is fake by the way ;)

    Just tried your code on my sheet and it worked fine. I can't imagine browser/OS would make a difference. One thing I would try: make a new sheet (in the same doc) and try to get it working there, without all the other things you have on your current sheet. Just "Dark Bow" and your code. You may need to reload the sheet or something to get it to work, though I hardy ever find that to be the case.

    I tried it in all different browsers and on windows too. Still can't get it to work. This is just plain weird XD

  3. I tried hard, but I just keep getting #Error(Parse Error). This is the code I use:

    =Index(ImportHtml(Concat("http://itemdb-rs.runescape.com/results.ws?query=",A2), "table", 2),2,3)

     

    The spreadsheet is:

    http://spreadsheets.google.com/ccc?key=0AjhQ7wHYDKCOdE1MazltMXhhbnJ2NF9yQ2ZLSmdMVnc&hl=nl&authkey=CLqMvRY

    Check column J, the error is there. I used Chrome on Ubuntu to create this, but it should work, since when I view other spreadsheets that use this method it also works.

     

    For those who want to know what this is about: it will be my Merchanting Log, the first entry is fake by the way ;)

  4. I made a simple php script that uses curl to get the price of a ge item of the runescape site. Just place it on top of a .php file, and then you can call it by using: echo getprice(itemid); You can find the id of an item if you look at it in runescape grand exchange. Like for grain: http://teun.beijers.eu (making it english soon).

     

    <?php
    
    function getprice($id) {
    
       $url = "http://itemdb-rs.runescape.com/viewitem.ws?obj=".$id;
    
       $startat = "Market price: ";
    
       $stopat = "";
    
       $ch = curl_init();
    
       $timeout = 5;
    
       curl_setopt ($ch, CURLOPT_URL, $url);
    
       curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1);
    
       curl_setopt ($ch, CURLOPT_CONNECTTIMEOUT, $timeout);
    
       $start = curl_exec($ch);
    
       curl_close($ch);
    
       $exploded = explode($startat,$start);
    
       $exploded = explode($stopat,$exploded[1]);
    
       $result = str_replace('
    ','',nl2br($exploded[0]));
    
       return $result;
    
    }
    
    echo getprice(1947);//get grain price
    
    ?>

  5. I had this idea: there are lot's of user-made shops around in runescape? why not make a site where people can register a shop, manage sales, start auctions, recruit workers etc. With this I mean a non-forum site. I can script everything, but I'm not that good at making lay-outs, can someone help me by making a layout? Contact me on msn: [email protected]

  6. I learned that:

     

    -You can kill anyone, they respawn in a noob village anyway.

     

    -It has no use to kill a monster, they respawn anyway.

     

    -Monsters can carry heavy weapons/armour like a d chain, while you don't see them wearing them or having them in their pockets.

     

    -The weather never changes in some places

     

    -When you're born you're mature immidiatly

     

    -We have no mouths or noses :P

  7. this certainly will affect the prices of nature runes, since more people are going to craft here now and not in abbys.

     

     

     

    O, and I also have some data for you:

     

    lvl 75+ gets an avarage of 900+ exp a run

     

    It earns about 66% less than abbys

     

    The exp is about 175% of that of abbys

     

    exp is almost as good as law comp

     

     

     

    Correct me if this info isn't right

  8. Hi, I have 5m and some experience in merchanting, I used to merchant in airs(buying 14ea, selling 20 ea) and tanning cow hides. But with 5m it's a bit of a slow method. Anyone knows a method to make 5m into 10m in 2 weeks, and 10m to 15m in 1 week?(I'm non-member, becoming member in 4 weeks, that's where I need money for)

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.