Merchant Archive
Thread: The Merchant's Buddy v.02 Beta
cant install it because I have no .net framework. Looking forward to test your program BUT :
whats the .net framework? What does it do ? Where can I get it ?
Running Windows XP (end 2002 version).
Thanks a lot
Novarider Tam
Indigo75 wrote:
The only tricky part of this is that the date string that SWG outputs to mail files is odd. I'm not sure what it's based on, so the only date i can go on is when you saved the mails to your disk.
I saved a message and reverse engineered the TIMESTAMP to known date/time in message using Excel.
The timestamp is number of seconds elapsed since a reference date & time.
Looks to me like the reference date/time is: 1 Jan 1970 06:00:00
To convert timestamp to date & time:
days = @int(timestamp/86400) {divide by total number of secs in day to find number of days}
remainder = timestamp - (days * 86400) {find number of seconds remaining on current day}
hour = @int(remainder / 3600) {find number of hours}
remainder = remainder - (hour * 3600)
minutes = @int(remainder/60) {find number of minutes}
remainder = remainder- (minutes * 60)
seconds = remainder
In Excel, add days to reference date (1/1/1970) to get the current date.
Wow, I think there are easier ways of handling that. 
Yeah, the date is all sorted out now, thanks. Just took figuring out the epoch for it and then finding how you read the epoch in C#, which isn't as easy as with other languages.
Found it in about two lines of code, though, so I'm set and reading the timestamp of the e-mail now. Yay! I've also got the price sorting correctly (not as text, but as numbers), and date/time sorting correctly.
I'm now looking into setting up the columns a bit nicer.
THANK YOU FOR PUTTING THIS TOGETHER AND MAKING IT AVAILABLE TO EVERYONE!!!
Finally was able to get .net installed ...
GREAT program and very useful.
Use it to categorize my customers into classes, which then get a discount ( 5 %, 10 %, 20 %, 30 %, 30 % and 2 cpu for ALL resources (which is the lower hard cap for discounts), and 33 % and 2 cpu/resource (for guild mates). The treshholds are three visits / 500k/ 1mill / 10 mill .. and someone who buys often and from various vendors usuallymoves up one category higher thanhis tradevolume ranking.Same happens if headvertises for the vendor and more people come and tell me that a certain customer has send them.
I usually did that by hand and with an excel sheet .. now THISprogram is a godsend !!
Looking forward to the next version.
Have fun
Novarider