Jump to content

Deathpixel

Members
 View Profile  See their activity

  • Posts

    35

  • Joined

  • Last visited

  • Feedback

    0%

 Content Type 

Posts posted by Deathpixel

    Saranovic's Fire Capes

    in Services

    Posted

    Range level: 75

    Def level: 73
    Prayer level: 60
    Hitpoints level: 79
    What xp do you NOT want me to get(if any - cannot be ranged or hitpoints, lol.): i do not mind
    Have you added my Skype(Saranovicskype) yes i have, pmed you my name on skype
    If not, have you PM'd on OSBot?: i will in a sec
    Do you agree to the Terms of Service?: yep!
    Will you give Feedback?: ofcourse!

    NMZ Rewards

    in Runescape

    Posted

    why do you post that here lol, just try it

     

    buy 1 = 1 dose btw, so buy 4 = 1 pot

     

    because someone asked for a profit calc kind of thing, and what i wasn't sure if it gives you a full pot or  a (1)

    is that reason enough?

    NMZ Rewards

    in Runescape

    Posted · Edited by Deathpixel

    can you post a link here or pm me when it's done?

     

    Thanks

     

    sure thing

     

    if you buy a potion "benefit" at nmz, how much dosis is it? 

     

    [Runescape Profit Calculator] Google spreadsheets, up to date! (WIP)

    in Runescape

    Posted · Edited by Deathpixel

    Hello people!
    i am making a RS profit calculator in google spreadsheets, it grabs the price from the G.E. so it is always up to date!
     
    5V2WDfZ.pngHere is a snapshot,
    and here is the Link
    Done:

    Smelting ores
    Fletching
    Herb cleaner and UNF potion
    Cheapest prayer method
    Cheapest firemaking

    Cutting gems

    Cooking + cheapest food

    NMZ store

     

    TO DO:
    Tele tabs

    +

    more odd currency shop
    ideas are always welcome! either via PM or comment
     
    IF I MADE A MISTAKE, PLEASE TELL ME.

    • Like 5

    getting G.E. prices with Google Spreadsheets

    in Runescape

    Posted

     

    http://services.runescape.com/m=itemdb_oldschool/api/catalogue/detail.json?item=3831

    ^ This is the OSRS ge API, there's also one for rs3

    https://medium.com/@paulgambill/how-to-import-json-data-into-google-spreadsheets-in-less-than-5-minutes-a3fede1a014a

    EDIT: doesn't seem to work quite well, so I wrote a custom function:

     

    CELL FORMULA: =GetPriceRS3(<id>) or =GetPriceOSRS(<id>)




function GetPriceOSRS(id) {
  return GetPrice('http://services.runescape.com/m=itemdb_oldschool/api/catalogue/detail.json?item=', id);
}

function getPriceRS3(id) {
 return GetPrice('http://services.runescape.com/m=itemdb_rs/api/catalogue/detail.json?item=', id);
}

function GetPrice(url, id) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  
  var response = UrlFetchApp.fetch(url + id);
  var data = JSON.parse(response.getContentText());
  

  price = data['item']['current']['price'];
  if(price[price.length-1] === 'b') price = price.substr(0,price.length-1)*1000000000;
  else if(price[price.length-1] === 'm') price = price.substr(0,price.length-1)*1000000;
  else if(price[price.length-1] === 'k') price = price.substr(0,price.length-1)*1000;
  
  return parseInt(price);  
}

     

    got it working! thank you very much!

    • Like 1

    getting G.E. prices with Google Spreadsheets

    in Runescape

    Posted

    Hello people, i wanted to make a profit calc ETC with google spreadsheets but i have the hardest time making it grab the prices.

    =Index(ImportHtml(Concatenate("http://services.runescape.com/m=itemdb_rs/results.ws?query=guam"), "table", 1),4,3)

    did not work, though this should work for the RS3 G.E. but it does not

     

    the only way i hoped i could get it to work was via the find table thing as in the link above but the Oldschool RS G.E. 

     

    6ckxlAn.png

     

    it has a table but no link i could copy paste in

     

    if i go to the iron ore itself

     

    TysAVjm.png

     

    now it isn't in a table it can grab the price from all i could find is that the price is between <h3> and </h3>

     

    http://services.runescape.com/m=itemdb_oldschool/Iron_ore/viewitem?obj=440

     

    thought it was simple just grabbing a price from the G.E. with google spreadsheets... but nope

     

    all help will be appreciated :)

    won't start on my laptop but it works on my PC

    in Archive

    Posted · Edited by Deathpixel

    Hello everyone, Czar and Alek tried helping me in the chat 

    it works fine on my pc and but it wont even start on my laptop, i will include youtube videos and things i have tried

     

    cd C:\Program Files\Java\jre7\bin
java -jar C:\Users\DennisPC\Downloads\OSBot2.3.106.jar

    java -jar OSBot.jar 1255
pause
×
×
  • Create New...