Price Updates

FeroxC

Krytan Explorer

Join Date: Mar 2006

EOA

P/W

Very nice work ! i can imagine this would blend perfectly with my price list project:
http://katanak.targend.com
Check out the projects page.

and topic here
http://www.guildwarsguru.com/forum/s....php?t=3009350

The DPL webpage will be in php and access the data from a mysql database.

If you can get your prog to upload a text file with the data via FTP every couple of minutes then it wouldnt be difficult to include the data on the webpage.

Sign up on the forums if you want to chat about collaberateing this could be the ultimate price list.

another question what program did you use to find the memory locations ?. As i tried loading up t-search but it crashed so i assumed they used anti-debugging code.

Kariston The Swift

Lion's Arch Merchant

Join Date: Sep 2005

Sand Scorpions[SS]

R/Me

Nice idea if connected with a major forum such as guru.

Hunter Sharparrow

Hunter Sharparrow

Krytan Explorer

Join Date: Mar 2006

Jeepers Kreepers

R/Mo

That is pretty sweet LAMS3K. One thing I don't get is that you said it checked every 5 minuts and autologged it but the time doesn't match up. At the beginning it logged the time at 10 13 53 then 10 23 19 for a difference of 9 minutes and 26 seconds.

Would it be possible to come up with a program that can take this info and display it as a real time line graph and be able to change the price history. So the price would be your y value and the time your x value. You can then (in an input box below the graph) input the timeline you would like to see (past hour in increments of 5 minutes or the past 5 hours in increments of 1/2 hours).

LAMS3K

Academy Page

Join Date: Nov 2005

Fifteen Over Fifty[Rare]

R/Mo

Oops. I typed in 500 seconds instead of 300. So I guess it is closer to every 9 mins.

EDIT:
Quote:
Originally Posted by FeroxC
another question what program did you use to find the memory locations ?. As i tried loading up t-search but it crashed so i assumed they used anti-debugging code.
I used t-search to play around in the memory and find the addresses. I found that whenever the Rare Material window is opened all the variables in it are dynamically allocated. So I had to write something similar to t-search in my program.

We are first going to get a site up with tables and figure out how to make this fail-safe. Then Tainek and I will look over features.

Sereng Amaranth

Sereng Amaranth

Desert Nomad

Join Date: Jun 2005

The Amazon Basin [AB]

Quote:
Originally Posted by FeroxC
Very nice work ! i can imagine this would blend perfectly with my price list project:
http://katanak.targend.com
Check out the projects page.
May I help you on your web design? PLEASE!!!

FeroxC

Krytan Explorer

Join Date: Mar 2006

EOA

P/W

Ok looks like ill have to clone it.

Pi_Numurian

Pi_Numurian

Lion's Arch Merchant

Join Date: Mar 2006

Numurian Vanguard

Me/R

cool ty

LAMS3K

Academy Page

Join Date: Nov 2005

Fifteen Over Fifty[Rare]

R/Mo

Some data from a test earlier today. I can only get it to run for four hours and then GW gives an error. I have to edit my code. Anyways, attached is a zip file containing an htm(webpage) file. S=Sell B=Buy, when S is red the sell price went down, green is up. For B red means up and green means down. I did not get to see what error GW gave thanks to, lambda the great for turning off the computer.

The actual web interface allows for columns to be hidden and time offsets are allowed so one can convert the time to their timezone. It also allows looking at the buy&Sell/Buy/Sell prices alone.

twicky_kid

twicky_kid

Furnace Stoker

Join Date: Jun 2005

Quite Vulgar [FUN]

Quote:
Originally Posted by LAMS3K
S=Sell B=Buy, when S is red the sell price went down, green is up. For B red means up and green means down.
Wouldn't it make more since to have both S and B red when the cost go down to prevent confusion.

LAMS3K

Academy Page

Join Date: Nov 2005

Fifteen Over Fifty[Rare]

R/Mo

Quote:
Originally Posted by twicky_kid
Wouldn't it make more since to have both S and B red when the cost go down to prevent confusion.
No, both Buy and Sell can change without affecting the other. If you look at the Ectoplasm column you can see that the buy price went up to 7500 and the sell price stayed a constant 5500.

twicky_kid

twicky_kid

Furnace Stoker

Join Date: Jun 2005

Quite Vulgar [FUN]

Quote:
Originally Posted by LAMS3K
No, both Buy and Sell can change without affecting the other. If you look at the Ectoplasm column you can see that the buy price went up to 7500 and the sell price stayed a constant 5500.
Gotcha

LAMS3K

Academy Page

Join Date: Nov 2005

Fifteen Over Fifty[Rare]

R/Mo

This project is quite far from dead. The price grabbing program now works correctly, even when items go out-of-stock or other nusiances. This problem required a complete rewrite of the software. Most of the utilites are complete. Web page layout has been approved. CGI programs that work with the data are being debugged.

Currently working on:

Web pages, finalizing them for use with the CGI programs.
Theme
Fixing problems/bugs that arise if the CGI programs do not work with one another properly.

As for the name, it is abbreviated: C.S.E. Good luck guessing, so long as Tainek does not spoil it. Although he came up with it.

The next report will probably not be posted until just before or at release.

ETA: None yet

Attached is data from May 15th 2006. This is the raw data view, i.e. no analysis has been done. Time is GMT. This data is in an HTML format.

Alias_X

Alias_X

Desert Nomad

Join Date: Apr 2005

This would be extremely useful! In fact, my other computer is broken atm, and the one I am posting from can't run GW. I am dying to know the current price of Superior Absorbtion... can anyone pm me with it?

Tainek

Tainek

Wilds Pathfinder

Join Date: Dec 2005

[Rage]

Quote:
Originally Posted by LAMS3K

As for the name, it is abbreviated: C.S.E. Good luck guessing, so long as Tainek does not spoil it. Although he came up with it.

*chuckle*

i'd forgotton all about this thread


Yeah the projects coming on really well, we were almost ready to release until we hit a few speedbumps, and lams3k needed to re-write most of the backing code (the guys done so much more work than i have heh)

shouldnt be long now guys

Robin_Anadri

Robin_Anadri

Krytan Explorer

Join Date: Jun 2005

Atlanta, GA

Girl Power [GP]

Me/Mo

You guys are geniuses. This rocks.

LAMS3K

Academy Page

Join Date: Nov 2005

Fifteen Over Fifty[Rare]

R/Mo

I've almost finished the comparison data, here is a screenshot.



Features that you don't notice:

You can select which items you want displayed. I have them all select in the screenshot.

Times can be converted to just about any timezone. GMT-7 in the screenshot.

I need feedback on this. What do you think of the layout? Is it easy to understand? Is color scheme pleasing? Should any other statistics be calculated?

I would also like to see feature suggestions. It is far easier to put extra features in now than after releasing. If you would like to help with this in some way, i.e. data collector, data analysis, discussion moderator, maintainence, others I can't think of at the moment, contact me or Tainek. PM, E-Mail, Whisper, etc.

ETA: I'm going to allow at least a month. So, release in probably less than one month.

Note: In the screenshot only May 15 is good data. Everything else came before the advanced error handling was implemented.

Ennes X

Academy Page

Join Date: Nov 2005

Teh Outsiders [xxxx]

Hello, I am wondering about the status of this project. I have been entering the data into a spreadsheet manually in irregular intervals and your program seems to be exactly what I am looking for.

LAMS3K

Academy Page

Join Date: Nov 2005

Fifteen Over Fifty[Rare]

R/Mo

The current status: Finished, but waiting

All the software and web pages for the project are completed. Just waiting on Tainek to get the computers running the software and a webserver. He's a procrastinator

Tainek

Tainek

Wilds Pathfinder

Join Date: Dec 2005

[Rage]

Quote:
Originally Posted by LAMS3K
The current status: Finished, but waiting

All the software and web pages for the project are completed. Just waiting on Tainek to get the computers running the software and a webserver. He's a procrastinator

Yeah, im an aweful procastinator, took a break from the game, only got back in a few weeks ago, need to find a solution for webhosting (Difficult as i have no source of income at the moment) and its set

Tetris L

Tetris L

Jungle Guide

Join Date: May 2005

Germany

Servants of Fortuna

Please, get this going. It would be VERY helpful.

Maybe GWGuru could help with hosting?

Tainek

Tainek

Wilds Pathfinder

Join Date: Dec 2005

[Rage]

at the moment we're in need of webhosting (as my host has run off) , and im not earning atm so i cant afford it, so once we have webhosting we're go

Cottage Pie

Cottage Pie

Wilds Pathfinder

Join Date: Nov 2005

Birmingham, England

Taking Aegis

Mo/Me

...brilliant work! <3

Soldat

Soldat

Krytan Explorer

Join Date: Jun 2006

TX

Fashion Police [chic]

seriously ^^, cant wait til this is up and running for us. Thx for all that time, i couldn't figure it out if my 9 lives depended on it.

Warrior1986

Academy Page

Join Date: Aug 2006

Brotherhood of Kain

Holy sweetness. Can't wait to see it once its up and working. Will be a VERY helpful resource.

LAMS3K

Academy Page

Join Date: Nov 2005

Fifteen Over Fifty[Rare]

R/Mo

I was asked about the source code for this project. I see no point in keeping it confidential.

You can download it here:

http://rapidshare.de/files/33519930/..._Code.zip.html

As for the status of the project, Tainek says all we need is hosting and that is where it still stands.

BlueNovember

BlueNovember

Wilds Pathfinder

Join Date: Sep 2005

WTS GW2 items for Zkey

Mo/

Bumpity.
Someone host this awesome project? =(

Warrior1986

Academy Page

Join Date: Aug 2006

Brotherhood of Kain

Seconded.

Poison Ivy

Poison Ivy

Forge Runner

Join Date: Jan 2006

Toronto

Hopping

Mo/A

Woah...Buy low sell high on Rare Crafting Materiels just got promoted.

Relnor

Relnor

Lion's Arch Merchant

Join Date: Feb 2006

W/

What do you guys need for the hosting? I may be able to help, but no promises. I would love to see this project up and active.

jereiter

Ascalonian Squire

Join Date: Sep 2006

I am interested in the project and would like to know where it stands right now...It would a pity if could not work.

LAMS3K

Academy Page

Join Date: Nov 2005

Fifteen Over Fifty[Rare]

R/Mo

Issues/paranoia I have with the system:

All the data is stored in ASCII text files. The C/C++ CGI programs calculate and generate the page in real time. When displaying large amounts of data(Which I have been unable to acquire. Weeks-Months worth =( ) bandwidth may be a problem. The CGI programs have never had an extensive test for server load issues.

As for the data grabber itself, it lacks automation. It can't recover from an error seven or any error that returns back to the login screen or exits the trader window. Currently, the person maintaining the machine running the grabber is required to restart the grabber, login to GW, open the trader window, and search through memory for the address belonging to the price display next to the "Request Quote" button. I doubt that such automation is acceptable to ANet. As is, no person wants to be woken up at three in the morning by a computer speaker blaring at them due to GW contracting an error seven.

There are more. But I don't care to list them.

Improvements that need to be done:
  • Rewrite the grabber.
  • Use a database instead of text files for price data storage.
  • Support all traders, rather than just one.
  • Rewrite the datalyzer
  • Hunt down the unique item identifier for the diamond
  • Clean up the code that may have spawned from Charr droppings.
  • Other things

EDIT: Figured it out.

Surprising how reviewing an old piece of software suddenly brought about all the solutions to the problems, well... at least most of them. I have another project that is finished I was considering posting, a spike coordinator. Similar to TS/Vent except it takes 3-2-1-spike to a whole new accuracy. Set up your build in the main window and when the leader sends the start spike signal all players receive a sound telling them to use a prep or start attacking. The timing is so accurate that all damage hits at once if the team has consistent reaction times. Infuse Health becomes useless on it's own. Target is dead < 250 ms Screenshot: Clicky
Note: This program does not interact with the game at all. Do NOT ask for me to release it, if people were to use it, heads would be rolling.

I'll be working on the CSE(price updates system) but no ETA as of yet. I'll post updates in this thread.

Please note: I don't condone any type of "bot" that automates actions that increase any characteristics about a player/account this includes spam bots. Not even for educational purposes, if you want a bot, make one to farm mines in minesweeper.

MGBWYA

LAMS3K

Academy Page

Join Date: Nov 2005

Fifteen Over Fifty[Rare]

R/Mo

I found something interesting when searching for the unique item codes for dyes.

Yellow=2418
Brown=2419
Orange=2420
White=33025

It seems that brown dye has been in the game since the beginning. Jade and amber have a much higher number than the other materials, most likely because they were added later, the same as with white dye.

EDIT 1:

I found a better way to select items on the trader lists. However, there are problems with it and discrepancies between the traders, which make the task rather difficult.

[To be edited later with other info]

BlueNovember

BlueNovember

Wilds Pathfinder

Join Date: Sep 2005

WTS GW2 items for Zkey

Mo/

Any luck with webhosting Tainek?
Have the issues LAMS3K mentioned been looked into?

Very interesting project, and I'm sure there are people, other than those that have posted, who would find it most useful.

milan

Desert Nomad

Join Date: Nov 2005

BONE

N/

Sent you a pm ref hosting. Just need a few details of what you need and you'll be good to go.

LAMS3K

Academy Page

Join Date: Nov 2005

Fifteen Over Fifty[Rare]

R/Mo

I did find a much simpler and versatile way of grabbing the trader prices and it works flawlessly on a good PC. On a computer with 256MB of RAM or less it fails to find the memory addresses where the price values are stored. As for actually getting this project up and running, if Tainek can't supply these we will need:
  • A computer that will run GW, the grabbing program, and can be left running 24/7. It will also be required to run an automatic FTP program so the grabbed prices can be uploaded to the web server.
  • An account containing a character who has one of every rare material in his/her inventory. We won't need access to it if the person with the account is also running the grabber computer.
  • Said account must belong to a guild that owns a guild hall and has purchased a rare material trader. This guild hall must be empty of everyone except the grabbing character.
  • Of course a web host. Preferably a Windows server but Unix is workable. It needs to be able to run CGI programs, store HTML pages, and text files.

If you can provide any of the above post here or PM me.

ThisIsNi

ThisIsNi

Frost Gate Guardian

Join Date: Jan 2007

USA

W/E

How about if you could set it to make so when a price reaches X amount, you can have it notify you via MSN, Yahoo, ect?

nightemaster

Academy Page

Join Date: Apr 2006

R/Mo

Sorry to bring up an old thread, but whats the status on this project? I'm still really interested. Thanks

LAMS3K

Academy Page

Join Date: Nov 2005

Fifteen Over Fifty[Rare]

R/Mo

I can't work on it anymore. Here is the source: http://rapidshare.com/files/21919412...ource.rar.html

I release it with no warranty or support.

rcvf

Ascalonian Squire

Join Date: Jul 2007

I'm also sorry to bring up this old thread, but is there anyway to upload the source again ? I'm interested in this project, and all links are down.
Thank you.

Zodiak

Jungle Guide

Join Date: May 2005

Gatineau, Qc, Canada

Kiss of Anguish [KISS]

P/W

It is unfortunate that this project seems to have gone the same way as the Guildwars Live Auction project that My friend was working on that I was helping with