| Pages: 1 2 3 4 5 6 7 [8] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Da Trader
   |
Posted - 2008.10.05 09:37:00 -
[211]
Also a friendly bump. That's a great piece, which helps enormously when it works.
|
Mike'P
|
Posted - 2008.10.07 23:24:00 -
[212]
Edited by: Mike''P on 07/10/2008 23:25:26
Hi guys,
First off, to Ray, fantastic application, thanks for putting it out there!
[EDIT: just noticed the reference to the September explosion: I believe my patches below solve this - pressure off, Ray! ]
Second off, if any of you have been running it for over a year, you'll start to notice something a bit awry in your weekly and monthly figures - basically, the results from September last year will get mixed in with results for September this year if you're in the overview page looking at the 'month' or 'week' stats. A small bug has crept in.
It seems like Ray has sidestepped this in the next version with the date range approach to getting at that data, but in the meantime, to fix the issue with the current version, here's a little patchiness.
First port of call: functions.php. This is just about adding a $year argument to a few functions and including it into the SQL statement.
Locate the 'get_isk_week_in()' function, and modify it as below:-
function get_isk_week_in($wallet,$week,$year)
{
global $settings;
$query = "SELECT SUM(amount) AS amount FROM `".$settings[$wallet.'journaltable']."` WHERE `amount` > '0' AND WEEK(`date`,1) = ".$week." AND YEAR(`date`) = ".$year." ORDER BY `date` DESC";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
return number_format($row['amount'], 2, '.', ',');
}
I'm sure you can see what I've done there - an extra argument $year, and change the $query to test the YEAR as well as the WEEK:-)
Now do the same mod for the other 'get_isk_week_xx' functions and the 'get_isk_month_xx' functions.
Second port of call: overview.php.
Line 231: add this
$year = date("Y",mktime(0, 0, 0, $rowdate['date'][1], $rowdate['date'][2][0]-($n*7), rowdate['date'][0]));
Line 233: change to this:
$query = "SELECT * FROM `".$settings[$_GET['wallet'].'journaltable']."` WHERE WEEK(`date`,1) = ".$week." AND YEAR(`date`) = ".$year." ORDER BY `date` DESC";
Line 313: add this:
$year = date("Y",mktime(0, 0, 0, $rowdate['date'][1]-$n, $rowdate['date'][2][0], $rowdate['date'][0]));
Line 314: change to this:
$query = "SELECT * FROM `".$settings[$_GET['wallet'].'journaltable']."` WHERE MONTHNAME(`date`) = '".$month."' AND YEAR(`date`) = ".$year." ORDER BY `date` DESC";
and then change any references to the 'get_isk_xxx_xxx' functions modified in functions.php so that they have the extra '$year' argument.
I can make proper unix diffs if anyone wants them.
Hope that helps!
|
Salisuka
Caldari
98.4
|
Posted - 2008.10.10 08:59:00 -
[213]
Ray, will you release SEXY II if I pledge my first born to you?
|
Lep Erd
Minmatar
Pator Tech School
|
Posted - 2008.11.06 04:27:00 -
[214]
bumping in the vain hope that there's some updates on the horizon.
|
Lep Erd
Minmatar
Pator Tech School
|
Posted - 2008.12.18 04:06:00 -
[215]
 Originally by: Lep Erd
bumping in the vain hope that there's some updates on the horizon.
this... again.
|
You What
The Grill UK
|
Posted - 2008.12.26 16:14:00 -
[216]
bump as well
looking forward to new release as [sexy] is just must-have for me
|
Argator
|
Posted - 2009.01.04 14:53:00 -
[217]
A Must Have !! 
|
RaTTuS
BIG
Libertas Fidelitas
|
Posted - 2009.01.04 15:00:00 -
[218]
/me agrees
do it ray or I'll make the humper do something special for you 
--
BIG Lottery, BIG Deal, InEve
|
Ray McCormack
hirr
|
Posted - 2009.01.04 15:10:00 -
[219]
Meh, when it's ready. I got sidetracked with SEXY.net Desktop Edition, but SEXY 0.2b will be out before you see that.
|
Argator
|
Posted - 2009.01.04 15:57:00 -
[220]
It's nice to hear that.
|
Forceflow
Gallente
Center for Advanced Studies
|
Posted - 2009.01.22 03:20:00 -
[221]
I followed all the steps but I ended up with this sort of error message on all the tabs:
Notice: Undefined offset: 2 in C:\wamp\www\wallet\overview.php on line 47
Notice: Undefined offset: 1 in C:\wamp\www\wallet\overview.php on line 52
Warning: mktime() expects parameter 6 to be long, string given in C:\wamp\www\wallet\overview.php on line 52
Notice: Undefined variable: thisYear in C:\wamp\www\wallet\functions.php on line 629
Notice: Undefined variable: thisIni in C:\wamp\www\wallet\functions.php on line 631
An suggestions on what i'm doing wrong? |
Saira Jin
|
Posted - 2009.01.22 04:08:00 -
[222]
The demo no worky! Looks like somebody forgot to renew their domain name registration.
|
Eventy One
Magellan Exploration and Survey
|
Posted - 2009.03.12 16:36:00 -
[223]
/bump
|
Hurricane Carter
0ccam's Razor
Nexus-Alliance
|
Posted - 2009.03.29 20:46:00 -
[224]
tried to get it working, throws a bunch of errors that I can't figure out :s
Notice: Undefined index: wallet in C:\wamp\www\eow\wallet19092007\header.php on line 41
Notice: Undefined index: wallet in C:\wamp\www\eow\wallet19092007\header.php on line 42
Notice: Undefined index: length in C:\wamp\www\eow\wallet19092007\header.php on line 43
Notice: Undefined index: length in C:\wamp\www\eow\wallet19092007\header.php on line 44
Notice: Undefined index: length in C:\wamp\www\eow\wallet19092007\header.php on line 45
and
Notice: Undefined index: actions in C:\wamp\www\eow\wallet19092007\update.php on line 39
Notice: Undefined index: actions in C:\wamp\www\eow\wallet19092007\update.php on line 56
running latest WAMP versionso honestly don't know whats up. DB's are input but.... mmm don't know what to do at this point
|
Ommand
|
Posted - 2009.05.24 00:39:00 -
[225]
Just posting this here at Ray's request:
I was having some problems getting [SEXY] fully functional, try as I might nothing was showing up in the transactions tab and all of the journal entries were missing information. I talked to Ray and he noticed there was a problem fetching specifically the corporate transaction log, as seen by the series of errors below:
...updating corporate transactions for xxxx... ...A general error has occured, please try again later. for division 1000.
...updating corporate transactions for xxxx... ...A general error has occured, please try again later. for division 1001.
...updating corporate transactions for xxxx... ...A general error has occured, please try again later. for division 1002.
...updating corporate transactions for xxxx... ...A general error has occured, please try again later. for division 1003.
...updating corporate transactions for xxxx... ...A general error has occured, please try again later. for division 1004.
...updating corporate transactions for xxxx... ...A general error has occured, please try again later. for division 1005.
...updating corporate transactions for xxxx... ...A general error has occured, please try again later. for division 1006.
After much head scratching and bugging Ray I logged into "My Character" here on the eve-o site and attempted to receive said log through that interface, only to be confronted by the same error once again. Once I saw this I went and reset my api key and voila.. all was well again.
Apparently it's possible for one 'small' section of the API to be broken while the rest works flawlessly, who knew?
|
Arazmus Lionheart
|
Posted - 2009.07.13 14:55:00 -
[226]
Does this still work..
I have followed the steps perfectly, I have also looked through the php code (fairly adept at php) and yet I still get no data entered into the MySQL DB..
I get the following repeated indefinatly:
updating personal journal for 641814732... ...0 entries added successfully
i left it for 5 mins once and had over 500 lines of it.... The DB tables are correct and I have reinstalled and reinstalled.. Curl, GD and PHP are all set up correctly yet no joy.. any help?
|
| |
|
| Pages: 1 2 3 4 5 6 7 [8] :: one page |
| First page | Previous page | Next page | Last page |