Posted - 2011.05.20 14:55:00 - [62]

 

Edited by: Psyrelle on 20/05/2011 14:55:07

Originally by: Nutty trader

---

Edited by: Nutty trader on 20/05/2011 13:56:09
And you have refreshed the page using ctrl+f5? It is the same error message? Sure you uploaded the new file and its got the correct name? If so then copy and paste the error message and the public DSN line here, just so it can all be double checked.

EDIT: Yer nutbolt here, silly forums.

---

error:

<br />
<b>Warning</b>: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host 'saphyron' (1) in <b>/home/saphyron/public_html/test_carebear/adodb5/drivers/adodb-mysql.inc.php</b> on line <b>365</b><br />
Connection failed

dsn:

public $Dsn = 'mysql://saphyron_caerbea:826066@localhost/saphyron_caerbear2';

Posted - 2011.05.20 16:03:00 - [64]

 

Originally by: Nutbolt

---

From what I can tell it still thinks the database host should be saphyron and not localhost. If you are sure you have uploaded the config file correctly etc... then only other thing I can think of is to start a new, delete the carebear_test folder off your server, upload it all again including the editted config file. If still no luck im out of ideas, sorry.

---

well now it works sorta.

Error 200: Current security level not high enough.

this error comes... what does that mean?

Posted - 2011.05.20 17:30:00 - [66]

 

Edited by: Psyrelle on 20/05/2011 18:06:18
Edited by: Psyrelle on 20/05/2011 17:32:47

Originally by: Nutbolt

---

Only thing I can think of is either the user doesn't have access to the database? or your api doesn't have access, are you a director or CEO of the corp your in and trying to pull the info from? Apart from that you need someone who actually understands the code to reply :p

---

pulling it from the ceo. maybe i need to supply full api and not limited

though i would love to know how im gonna automatically pull every hour or so

EDIT: it now works thank you

Posted - 2011.05.20 23:53:00 - [68]

 

Originally by: Psyrelle

---

pulling it from the ceo. maybe i need to supply full api and not limited

though i would love to know how im gonna automatically pull every hour or so

EDIT: it now works thank you

---

No worries, glad I could help. To get it to pull automatically you will need to setup a cron job which uses the cron page. That's about as much as I can say lol, the way I have cron jobs set up on my server is a little weird, so I will let someone else explain now :)

Posted - 2011.05.22 11:23:00 - [70]

 

Great code! Congrats.

On the main (sum) table, is it possible to add the number of kills made per member?

Posted - 2011.05.26 16:34:00 - [72]

 

The script is registering and displaying only 2 days since it has been installed (5 days ago installed, only the first 2 days there is SOME data displayed).

I am saying SOME data because there are characters that have made NPC and they are not displayed in the script statistic results.

Any idea if this is normal or if there are maybe bugs in the implementation ? Or... some API limitation ?

Posted - 2011.05.30 23:32:00 - [74]

 

bump.

Posted - 2011.05.31 15:32:00 - [76]

 

Originally by: Venetian Tar

---

Nice tool, took a bit to get working but it's great.

Thanks.

---

Are you experiencing any problems related with data not being pulled correctly from the API ?
I can't seem to understand why but in my installation I am only having access to reports for the past 1-2 days even if the script has been installed for more then 1 week.

Let me know. Thank you!

Posted - 2011.06.07 08:57:00 - [78]

 

Been away from EVE for a bit.

Updated the cron file: cron.php
to pull also the Incursion related data into the database, rest of the page doesn't need modifications since the data doesn't provide anything else other than the amount and sender (CONCORD in that case), no system or activity related information at all.

Alexandr Soljenitin, has the crontab been set up to execute cron.php every 30 minutes?

Posted - 2011.06.16 22:54:00 - [80]

 

Edited by: netbotix on 17/06/2011 01:05:34
I am having an issue with this where I dont think the chron is actually pulling any info. Is there a way I can debug the process? I ran chron.php and then go to the app and there is no data.

Also does

public $JournalTable = 'journal';

need to be the name of the master wallet or leave it as be?

thanks
cron.log

2011-06-16 22:56:21 Too soon
2011-06-16 22:57:56 Too soon
2011-06-16 23:05:24 Too soon
2011-06-16 23:09:39 Too soon
2011-06-16 23:12:56 Too soon
2011-06-16 23:17:33 Too soon
2011-06-16 23:40:38
4402301801
4402232098
4402189401
4402152558
4402133445
4402113028
4402071963
4402071961
4402071264
4402050531
4402027305
4401983618
4401937211
2011-06-16 23:41:17 Too soon
2011-06-17 01:03:42
4404549233
4404486061
4404471553
4404427859
4404413353
4404288495
4404288046
4404239581
4404239568
4404199995
4404199977
4404185886
4404157886
4404130745
4404076555
4404037659
4404037654
4404024842
4404012515
4403987316
4403987314
4403975072
4403961345
4403934371
4403934368
4403921489
4403908332
4403907990
4403895388
4403895376
4403857021
4403843669
4403843664
4403829807
4403829800
4403803330
4403753121
4403688737

Posted - 2011.07.08 13:09:00 - [82]

 

Well I got it to import.. doesn't seem like a long history but I can deal with it. Now my only problem is the cron job when automatically running does not import anything. If I manually run it, it does fine, but with a cron job it seems nothing is being imported.

I have verified that the cron job is running yet nothing seems to happen. Any idea? Does the troubleshooter echo for cron need to be turned off? Although it seems doing this makes no difference.
Thanks

Posted - 2011.08.28 14:36:00 - [84]

 

Edited by: Micha W on 30/08/2011 04:50:50
Edited by: Micha W on 29/08/2011 14:16:03
I have a error when i update the cron.php

Quote:

---

<b>Notice</b>: Undefined offset: 0 in <b>/home/miefevec/public_html/test/carebear/cron.php</b> on line <b>180</b><br />

---