possible to add a filter which would first fetch killmails, post mails over xxx value, and then it would filter solo kills out over xxx value from rest of the mails and post any that are solo kill over xxx value and trash the rest?

see https://scrutinizer-ci.com/g/shibdib/Dramiel/inspections/c5cd6aa0-59cf-4f33-adac-65dd1a8dae2f/issues/files/src/plugins/onMessage/price.php?status=new&orderField=path&order=asc&fileId=src%2Flib%2FeveApi.php&honorSelectedPaths=0#inspectioncomment-42582683

hey

I get this error from my supervisor log and not sure how to proceed from here

2016-07-08 22:03:41,343 INFO RPC interface 'supervisor' initialized
2016-07-08 22:03:41,343 CRIT Server 'unix_http_server' running without any HTTP authentication checking
2016-07-08 22:03:41,344 INFO daemonizing the supervisord process
2016-07-08 22:03:41,344 INFO supervisord started with pid 511
2016-07-08 22:07:29,173 INFO spawned: 'dramiel' with pid 680
2016-07-08 22:07:29,221 INFO exited: dramiel (exit status 1; not expected)
2016-07-08 22:07:30,223 INFO spawned: 'dramiel' with pid 681
2016-07-08 22:07:30,260 INFO exited: dramiel (exit status 1; not expected)
2016-07-08 22:07:32,264 INFO spawned: 'dramiel' with pid 682
2016-07-08 22:07:32,310 INFO exited: dramiel (exit status 1; not expected)
2016-07-08 22:07:35,314 INFO spawned: 'dramiel' with pid 685
2016-07-08 22:07:35,353 INFO exited: dramiel (exit status 1; not expected)
2016-07-08 22:07:36,354 INFO gave up: dramiel entered FATAL state, too many start retries too quickly
2016-07-08 22:47:23,546 INFO spawned: 'dramiel' with pid 1639
2016-07-08 22:47:23,602 INFO exited: dramiel (exit status 1; not expected)
2016-07-08 22:47:24,604 INFO spawned: 'dramiel' with pid 1640
2016-07-08 22:47:24,673 INFO exited: dramiel (exit status 1; not expected)
2016-07-08 22:47:26,678 INFO spawned: 'dramiel' with pid 1641
2016-07-08 22:47:26,725 INFO exited: dramiel (exit status 1; not expected)
2016-07-08 22:47:29,730 INFO spawned: 'dramiel' with pid 1646
2016-07-08 22:47:29,771 INFO exited: dramiel (exit status 1; not expected)
2016-07-08 22:47:30,772 INFO gave up: dramiel entered FATAL state, too many start retries too quickly

i added the below into dramiel.conf so not sure where i went wrong

[program:dramiel] command=php /directory to your bot folder/Dramiel/Dramiel.php autostart=true autorestart=true stopasgroup=true stderr_logfile=/directory to your bot folder/Dramiel/log/dramielError.log stdout_logfile=/directory to your bot folder/Dramiel/log/dramielOther.log stdout_logfile_maxbytes=100KB stdout_logfile_backups=3 stderr_logfile_maxbytes=100KB stderr_logfile_backups=3 priority=998

my bot is printing shipName and systemName as unknown after updating

http://prntscr.com/cxuj7s first hit is before i updated and the 2nd is after i updated

Can we add an option to show all pilots involved for zkillboard?

Hello.

I get the below

typeID 6 is an unmapped notification, please create a Github issue with this entire message and please include what the in-game notification is. againstID: 98344248 cost: null declaredByID: 99006495 delayHours: null hostileState: null

Ally Has Joined a War
From: CONCORD
Sent: 2016.10.22 23:08

P I R A T has joined Advanced Exports in a war against you. Their participation in the war will start at 2016.10.23 03:08

Hi.

Some reason my bot isnt working anymore.

get error

PHP Fatal error: Call to undefined method React\HttpClient\ChunkedStreamDecoder::end() in /home/Dramiel/vendor/react/http-client/src/Response.php on line 111

Hello, there is a problem. set set up the bot. do it and request it to me at my request meets 1 10 times.
where is the problem?

hey

i updated the bot to the newest version, but somehow, if I start for example !jita Paladin the bot will die and be restarted.

Anyway to add a feature to the getkillmail to only post mails over a value?
and if solo kill then a lower value.

We spoke briefly the other day, and here's the github issue:

Backstory:

We're a small group of players that want to simplify our IT by switching the majority of services to Discord. In order to do this, I want to have the ability to have recruits send their API data via discord, so that all the recruiters can see it. From how I used to do this with Slack was by implementing a form that parsed the data directly in a separate channel.

What would I like to see?

Ideally, Dramiel would be expanded to offer the following functionality to users:

• Dramiel sends a welcome message to people who join the server.
• Dramiel accepts commands in private that can send data such as applications.
• Dramiel removes all messages in other channels that contain the commands ment for private use
• When Dramiel gets a command (say !apply) then the text in that message gets parsed into a separate channel on Discord.

As a result of the above, players can join a corporate discord, share their API key(s) with the recruitment team and have the bot safely paste that into a channel dedicated to recruiters. By removing the data from public channels you also remove the risk of sharing API data with strangers.

Ideally if time allows the commands are addable / editable / expandable to span multiple channels etc.

I'm trying to figure a way to pull isk value of kill. I the api zkill uses seems to have a /iskValue/#/ for it but I can't seem to figure a way to work. Any help would be appreciated.

https://github.com/zKillboard/zKillboard/wiki/API-(Killmails)

https://zkillboard.com/api/xml/no-attackers/no-items/orderDirection/asc/afterKillID/{$lastMail}/allianceID/{$this->allianceID}/ is the address its pulling the kills from correct? Cause when I manually add the address with the correct allianceID and any killmail# it goes to a blank page

Is it possible to have this bot integrate with slack?

Is it possible to make so you can apply more than 1 key from differend accounts and have it fetch notifications more often
like 1 key = fetch ever 30 min, 2 keys = every 15 min, 3 keys every 10m
and have config options to define how often it should scan and how many keys is suppiled
Like
"keys" => "#", // Numbers of keys you have supplied
"interval" => "#" // how often in min it should try and fetch notifications

Awesome idea, however if you are carrying out an unrefined reaction with a unit of 1, it will flag a siphon, as its not an inc of 100. Is there a possible fix for this?

Hi

Would it be possible to have fleetup added onto the bot. would be nice to have operation timers broadcast when one is added and when its about to start.

Hi.
If i use the entry !pc ibis it spits out

Buy:
   Low: 112.97
   Avg: 655.23
   High: 125,917.38
Sell:
   Low: 1.00
   Avg: 38,931.80
   High: 250,000.00

however if i specify a trade i with !pc Jita ibis i get

Buy:
   Low: 0.00
   Avg: 0.00
   High: 0.00
Sell:
   Low: 0.00
   Avg: 0.00
   High: 0.00

any idea why its doing this?

When accessing the auth portion of this bot, i have my site set to subdomain.domain.com/auth/. When i go to subdomain.domain.com i do see the discord authentication site, but after authenticating, i get the following:

{"error":"invalid_scope","error_description":"The requested scopes either don't exist, or are not valid for this client"}

hi
all functions seem to work well. however no fleet up broadcasts worked

only warning message i get in the logs

`PHP` Warning:  Invalid argument supplied for foreach() in /home/Dramiel/src/plugins/onTick/fleetUpOperations.php on line 103
PHP Warning:  Invalid argument supplied for foreach() in /home/Dramiel/src/plugins/onTick/fleetUpOperations.php on line 103
PHP Warning:  Invalid argument supplied for foreach() in /home/Dramiel/src/plugins/onTick/fleetUpOperations.php on line 103
PHP Warning:  Invalid argument supplied for foreach() in /home/Dramiel/src/plugins/onTick/fleetUpOperations.php on line 152``

Dramiel$ php Dramiel.php
PHP Fatal error: Uncaught Error: Call to a member function sendMessage() on null in /home/menfi/Dramiel/src/plugins/onTick/getKillmails.php:168
Stack trace:
#0 /home/menfi/Dramiel/src/plugins/onTick/getKillmails.php(119): getKillmails->getKM()
#1 /home/menfi/Dramiel/Dramiel.php(145): getKillmails->tick()
#2 [internal function]: {closure}(Object(React\EventLoop\Timer\Timer))
#3 /home/menfi/Dramiel/vendor/react/event-loop/src/Timer/Timers.php(90): call_user_func(Object(Closure), Object(React\EventLoop\Timer\Timer))
#4 /home/menfi/Dramiel/vendor/react/event-loop/src/StreamSelectLoop.php(177): React\EventLoop\Timer\Timers->tick()
#5 /home/menfi/Dramiel/vendor/team-reflex/discord-php/src/Discord/WebSockets/WebSocket.php(927): React\EventLoop\StreamSelectLoop->run()
#6 /home/menfi/Dramiel/Dramiel.php(214): Discord\WebSockets\WebSocket->run()
#7 {main}

thrown in /home/menfi/Dramiel/src/plugins/onTick/getKillmails.php on line 168

after finally get the bot up and running but noticed it didn't post any killmails in the channel
I created a channel for the bot to post mails in which the admin role got full rights to.
plugin is enabled

This is the setting for getkillmails

"getKillmails" => array(
        "channel" => 236234773876441088, //killmails post to this channel
        "corpID" => 98171644, //corpid for killmails
        "allianceID" => 0, //allianceid for killmails (Leave as 0 if using it for a corp)
        "lossMails" => "true", //set as true to post both kills and losses, false to post only kills.
        "spamAmount" => 10, //Max amount of kills the bot will post every 10 minutes. Default is 15 and won't get the bot kicked for spamming.
        "startMail" => 0, //Put the zkill killID of your latest killmail. Otherwise it will pull from the beginning of time.
    ),

in the drameilLog.log i only see this

[2016-10-13 23:18:28] Dramiel.INFO: Logger Initiated [] []
[2016-10-13 23:18:28] Dramiel.INFO: Loading background plugins [] []
[2016-10-13 23:18:28] Dramiel.INFO: Loaded: 2 background plugins [] []
[2016-10-13 23:18:28] Dramiel.INFO: Loading in chat plugins [] []
[2016-10-13 23:18:28] Dramiel.INFO: Loaded: 8 chat plugins [] []
[2016-10-13 23:18:29] Dramiel.INFO: Discord WebSocket is ready!  [] []
[2016-10-13 23:18:34] Dramiel.INFO: Checking for new killmails. [] []
[2016-10-13 23:18:46] Dramiel.INFO: All kills posted, newest kill id is 56581518 [] []

but it haven't posted any mails in any channel nor did it post any errors

Sorry i dont want to be spamming freak.
i got the below warnings. However both functions dont work. So not sure if its the code or invalid data. Ive double checked the data and it is correct

The issues ive encountered so far
Fleetup

PHP Warning:  Invalid argument supplied for foreach() in /home/Dramiel/src/plugins/onTick/fleetUpOperations.php on line 143
PHP Warning:  Invalid argument supplied for foreach() in /home/Dramiel/src/plugins/onTick/fleetUpOperations.php on line 97

and Jabber:

/home/Dramiel/src/twisted/run.py:20: SyntaxWarning: import * only allowed at module level
  def main():

any ideas

As the title says. Do a entry like !hunt Passari and it pulls info from dotlan or zkillboard about kills etc. This is possible on slack and will perhaps be beneficial to alot of pvp alliances.

Example of the slack bot.

!hunt passari


hunterbot BOT [6:50 PM]  
http://evemaps.dotlan.net/range/Panther,5/Passari
```# of player kills: 42
# of NPC kills: 3532
# of Fighter losses: 0
# of jumps: 2185
Top systems by player kill: Akidagi(9), Reitsato(7), Asakai(4)
    **Reitsato**
        Alliance Commitment: Templis CALSF(1), A Band Apart.(1)
        Top Killers: Methea Selenis(1)
        Alliance Losses: Templis CALSF(15 m)
    **Asakai**
        Alliance Commitment: United Fleet(7), None(5), Pen Is Out(3)
        Top Killers: Fubball(3), Alice Moris(2), Ryslan Sharipov(1)
        Alliance Losses: Pen Is Out(36 m), United Fleet(15 m), None(12 m)
    **Akidagi**
        Alliance Commitment: None(5), Snuggle Struggle.(1)
        Top Killers: WarGod(3)
        Alliance Losses: Snuggle Struggle.(14 m), None(11 m)
Top systems by NPC kills: FY0W-N(494), XD-TOV(433), V0DF-2(355)
Top systems by NPC kill delta: Aurohunen(147, V0DF-2(65), A8A-JN(62)
Top systems by carrier fighter loss: Nisuwa(0), C8VC-S(0), V7-FB4(0)
Top systems by Jumps: Kedama(126), EC-P8R(118), Akidagi(101)

Not sure if I should really report this over on the auth page. Figured that they come together.

Thank you very much for the nod in the right direction with the last issue!!! Figured out the problem and now the bot works lovely...

New issue comes with the auth system when I try to access the
http://192.168.1.1/auth/ (Using real IP and not domain name. 192.168.1.1 just there as example)

I get big colorful page that give me below.

ErrorException thrown with message "Undefined property: stdClass::$access_token"

Stacktrace:
#11 ErrorException in /var/www/html/EVE-Discord-Auth/app.php:37
#10 Slim\Slim:handleErrors in /var/www/html/EVE-Discord-Auth/app.php:37
#9 {closure} in <#unknown>:0
#8 call_user_func_array in /var/www/html/EVE-Discord-Auth/vendor/slim/slim/Slim/Route.php:468
#7 Slim\Route:dispatch in /var/www/html/EVE-Discord-Auth/vendor/slim/slim/Slim/Slim.php:1357
#6 Slim\Slim:call in /var/www/html/EVE-Discord-Auth/vendor/slim/slim/Slim/Middleware/Flash.php:85
#5 Slim\Middleware\Flash:call in /var/www/html/EVE-Discord-Auth/vendor/slim/slim/Slim/Middleware/MethodOverride.php:92
#4 Slim\Middleware\MethodOverride:call in /var/www/html/EVE-Discord-Auth/vendor/zeuxisoo/slim-whoops/src/Zeuxisoo/Whoops/Provider/Slim/WhoopsMiddleware.php:87
#3 Zeuxisoo\Whoops\Provider\Slim\WhoopsMiddleware:call in /var/www/html/EVE-Discord-Auth/vendor/slim/slim/Slim/Middleware/PrettyExceptions.php:67
#2 Slim\Middleware\PrettyExceptions:call in /var/www/html/EVE-Discord-Auth/vendor/slim/slim/Slim/Slim.php:1302
#1 Slim\Slim:run in /var/www/html/EVE-Discord-Auth/app.php:91
#0 require_once in /var/www/html/EVE-Discord-Auth/public/index.php:3

I configured AUTH as below (Numbers changed to protect the guilty)

// CREST
$config["sso"] = array(
    "clientID" => "3e4ba87b847e98e1d54ff51cb4804750", // https://developers.eveonline.com/
    "secretKey" => "EV9fB8jygRGLaFAIZSjf7gMDPHcS8ttQOPFMmwCg",
    "callbackURL" => "http://192.168.1.1/auth/", // Include trailing / (Will be the url_to_the_index.com/auth/)
);

$config["db"] = array(
    "url" => "localhost",
    "user" => "discorduser",
    "pass" => "xxxxxxxxx",
    "dbname" => "discord"
);

$config["discord"] = array(
    "inviteLink" => "https://discord.gg/8C4bdJb" //Make sure it's set to never expire and set to a public channel.
);

And for the main config

    //SSO Auth
    "auth" => array(
        "corpID" => 0,
        "allianceID" => 99999999, // ID for Alliance from ZKIll
        "corpMemberRole" => "Member", // The name of the role your CORP members will be assigned too if the auth plugin is active.
        "allyMemberRole" => "Member", // The name of the role your ALLY members will be assigned too if the auth plugin is active.
        "alertChannel" => 0, // if using periodic check put the channel you'd like the bot to log removing users in. (Recommended you don't use an active chat channel)
        "nameEnforce" => "false", // put "true" or "false", if you'd like to make sure people's name match character names
        "url" => "http://192.168.1.1/auth/" // put a url here if using sso auth for ur sso page.
    ),

Could just be bad config and reaching out for any advice folk might have..

In dramiel error logs I am getting
PHP Warning: Invalid argument supplied for foreach() in /var/www/Dramiel/src/plugins/onTick/fleetUpOperations.php on line 103

everything else seems to work great..
From settings file

    "fleetUpOperations", // integrate with fleet up and post any new operations and then ping them when they get close

    //Fleet up linking will share operations to a specific channel and then reping them when it gets within 30 minutes of form up
    "fleetUp" => array(
        "channelID" => 12345678901234567890, //We got from discord
        "userID" => 12345, //fleet up user id
        "groupID" => 12345, //fleet up group id
        "apiKey" => "LotsofLettersandNumbers", //fleet up api code, link to application Dramiel Bot
    ),

From http://fleet-up.com/Api/MyKeys
I get userID and then API Code which I assume is "apiKey"

I decided to do a git pull to get the latest version, and update the config (copying over info to new config.php file) and started the bot, wouldn't respond to any commands, checked error log and was greeted with this:

PHP Fatal error:  Uncaught exception 'Discord\Exceptions\PartRequestFailedException' with message 'Erorr code 403: You do not have permission to do this. FORBIDDEN - {"code": 50013, "message": "Missing Permissions"} - guilds/104777608939487232/members/204340407654416385' in /home/leon/discordbot/Dramiel/vendor/team-reflex/discord-php/src/Discord/Parts/Part.php:231
Stack trace:
#0 /home/leon/discordbot/Dramiel/src/plugins/onTick/authCheck.php(134): Discord\Parts\Part->save()
#1 /home/leon/discordbot/Dramiel/src/plugins/onTick/authCheck.php(94): authCheck->checkAuth()
#2 /home/leon/discordbot/Dramiel/Dramiel.php(145): authCheck->tick()
#3 [internal function]: {closure}(Object(React\EventLoop\Timer\Timer))
#4 /home/leon/discordbot/Dramiel/vendor/react/event-loop/src/Timer/Timers.php(90): call_user_func(Object(Closure), Object(React\EventLoop\Timer\Timer))
#5 /home/leon/discordbot/Dramiel/vendor/react/event-loop/src/StreamSelectLoop.php(177): React\EventLoop\Timer\Timers->tick()
#6 /home/leon/discordbot/Dramiel/vendor/team-reflex/ in /home/leon/discordbot/Dramiel/vendor/team-reflex/discord-php/src/Discord/Parts/Part.php on line 231

If i comment out guildID and periodicCheck in config.php the bot responds, but raises errors for missing guildID and periodicCheck

Any thoughts?

Corp and Alliance Killmails in one Channel is Working good. Now the next step. to add Multible Alliances "2-3" to post in DIFFERENT Channels.

Thank you for your time

Current Jobs (Released, in testing)

• Standings Support for Auth

URGENT
Nothing ATM

Medium Priority

• ESI API - #101

Low Priority

• Recruiting plugin - #66
• Hunting Bot - #14
• Add Atom support to the RSS Reader

Completed and passed testing

• Isk Value (JSON usage for killmails) - #48
• #79
• Ability to restrict bot from responding in certain channels
• Auth issues with large guilds
• Multiple Killmails to separate channels - #63
• Siphon detection overhaul (multi corp support, and no longer matters if you level out silos when you empty them)
• Expand auth to support multiple groups - #62
• auth queue
• Multi accounts pulling notifications - #72

Scrapped

• onMessage queue support

PHP Warning: filesize(): stat failed for /home/Dramiel/src/lib/../../database/ccpData.sqlite in /home/Dramiel/src/lib/updateCCPData.php on line 37
PHP Warning: fopen(https://www.fuzzwork.co.uk/dump/sqlite-latest.sqlite.bz2): failed to open stream: Connection timed out in /home/Dramiel/src/lib/cURL.php on line 76
PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1 no such table: mapSolarSystems' in /home/Dramiel/src/lib/Db.php:128
Stack trace:
#0 /home/Dramiel/src/lib/Db.php(128): PDO->prepare('SELECT solarSys...')
#1 /home/Dramiel/src/plugins/onMessage/price.php(66): dbQuery('SELECT solarSys...', Array, 'ccp')
#2 /home/Dramiel/Dramiel.php(116): price->init(Array, Object(Discord\Discord), Object(Monolog\Logger))
#3 {main}

thrown in /home/Dramiel/src/lib/Db.php on line 128
PHP Warning: fopen(https://www.fuzzwork.co.uk/dump/sqlite-latest.sqlite.bz2): failed to open stream: Connection timed out in /home/Dramiel/src/lib/cURL.php on line 76
PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1 no such table: mapSolarSystems' in /home/Dramiel/src/lib/Db.php:128
Stack trace:
#0 /home/Dramiel/src/lib/Db.php(128): PDO->prepare('SELECT solarSys...')
#1 /home/Dramiel/src/plugins/onMessage/price.php(66): dbQuery('SELECT solarSys...', Array, 'ccp')
#2 /home/Dramiel/Dramiel.php(116): price->init(Array, Object(Discord\Discord), Object(Monolog\Logger))
#3 {main}

thrown in /home/Dramiel/src/lib/Db.php on line 128

not sure what to do about this

I have a few questions on tweaking.

FleetUp doesnt seem to post new operations when posted only upcoming ones.

What is the interval for "upcoming" to post and does it re-ping a few times? How can I modify this so say upcoming is 12hrs instead of 1 or whatever it is now.

What is the poller interval for notifications because I have a bot on Slack that seems to get notifications 5-6 minutes faster than this, is this adjustable? If so, where?

Any plans for expansion into posting updated/new FleetUP doctrine/fitting changes? Or responding to a command to spit a link to a fitting?

Fresh LAMP droplet from Digital Ocean, updated PHP to 5.6.23. Followed instructions in Wiki, this is what I am getting.

root@lamp-nwtl:/etc/supervisor/conf.d# php /home/bots/Dramiel/Dramiel.php
PHP Notice:  Undefined index: guildID in /home/bots/Dramiel/src/plugins/onMessage/auth.php on line 75
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1 no such table: mapSolarSystems' in /home/bots/Dramiel/src/lib/Db.php:130
Stack trace:
#0 /home/bots/Dramiel/src/lib/Db.php(130): PDO->prepare('SELECT solarSys...')
#1 /home/bots/Dramiel/src/plugins/onMessage/price.php(64): dbQuery('SELECT solarSys...', Array, 'ccp')
#2 /home/bots/Dramiel/Dramiel.php(112): price->init(Array, Object(Discord\Discord), Object(Monolog\Logger))
#3 {main}
  thrown in /home/bots/Dramiel/src/lib/Db.php on line 130

Hi Folks.

Is it possible to have the Dramiel work that if u do !fleet or something similar it can display all the fleetup fleets?

It would be extremly useful for my group since we use fleetup alot

a plugin which could read RRS feeds such as new_eden_news_bot on reddit which will read from defined RRS feeds

You have a user agent which is entirely non-descriptive of what it's actually doing.

This has led to some delays in locating exactly which machines have been causing some issues.

Update it to specify where the requests are actually coming from. Ideally with a user defined thing, so it's unique per installation.

Would it be possible to have multiple alliances on the auth check?

Thanks

Thanks for adding the silo fix for reactions!

Good Job.

Hello, i have created a new bot on a new ubuntu server, it has no issue removing roles from people, but everytime we try to add i get Failure: There are no roles available for your corp/alliance., i'm not sure what this error means, doing a little debuging seems it cannot get any roles back. any help would be great thank you.

PHP Notice: Trying to get property of non-object in /opt/Dramiel/src/plugins/onMessage/auth.php on line 147
PHP Notice: Trying to get property of non-object in /opt/Dramiel/src/plugins/onMessage/auth.php on line 148

I run fuzzwork.co.uk, and every so often, I get someone downloading the database once per minute. This isn't a small amount of bandwidth, and is entirely unnecessary.

I'm seeing them download the md5, then download the database, at lease once per minute.

This leads to me banning the IP, which is less than ideal for everyone involved.

see https://scrutinizer-ci.com/g/shibdib/Dramiel/inspections/c5cd6aa0-59cf-4f33-adac-65dd1a8dae2f/issues/files/src/plugins/onTick/siphons.php?status=all&selectedSeverities%5B0%5D=15&selectedSeverities%5B1%5D=10&orderField=path&order=asc&honorSelectedPaths=0#inspectioncomment-42582684

Hi.
Bot says:
typeID 135 is an unmapped notification, please create a Github issue with this entire message and please include what the in-game notification is. charID: 93100628 myIsk: 93246544.0 totalIsk: 2011363862.34

Ingame notification:
Nickolas Timmothy chose to share the value of the ESS pool. The pool was 2 011 363 862 ISK. Your share was 93 246 544 ISK.

PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 26 file is encrypted or is not a database'

Has anyone came across this, Error Log is spewing it and bot is not coming online.

• ta

see https://scrutinizer-ci.com/g/shibdib/Dramiel/inspections/c5cd6aa0-59cf-4f33-adac-65dd1a8dae2f/issues/files/src/plugins/onTick/getKillmails.php?status=all&selectedLabels%5B0%5D=2&orderField=path&order=asc&honorSelectedPaths=0#inspectioncomment-41103171

Hi.

currently when a war is declared or declared invalid a broadcast is sent saying New war declared by.

It doesnt give the name of the group declaring the war.

Hi Everyone.

We declared war again some ppl. however the bot displays the below. Is it possible to add who we wardeccing or who is wardeccing us?

@everyone | War declared by Wrecking Machine.. Fighting begins in roughly 24 hours.

Thanks

So i was wondering if i would be able to just delete the php code that is currently used to pull the API and just replace it with json

http://i.imgur.com/eTFoU1F.png

Is the dramiel db supposed to be empty? I've restarted several times. Made sure configs look good. Only thing that seems to be affected is killmails being posted. None are being posted.

Logs look like this:

[2016-07-28 15:32:12] Dramiel.INFO: All kills posted, newest kill id is  [] []
[2016-07-28 15:32:14] Dramiel.INFO: Checking for new killmails. [] []
[2016-07-28 15:32:14] Dramiel.INFO: All kills posted, newest kill id is  [] []
[2016-07-28 15:32:16] Dramiel.INFO: Checking for new killmails. [] []
[2016-07-28 15:32:16] Dramiel.INFO: All kills posted, newest kill id is  [] []
[2016-07-28 15:32:17] Dramiel.INFO: Checking for new killmails. [] []
[2016-07-28 15:32:17] Dramiel.INFO: All kills posted, newest kill id is  [] []
[2016-07-28 15:32:18] Dramiel.INFO: Checking for new killmails. [] []
[2016-07-28 15:32:18] Dramiel.INFO: All kills posted, newest kill id is  [] []
[2016-07-28 15:32:20] Dramiel.INFO: Checking for new killmails. [] []
[2016-07-28 15:32:20] Dramiel.INFO: All kills posted, newest kill id is  [] []
[2016-07-28 15:32:22] Dramiel.INFO: Checking for new killmails. [] []
[2016-07-28 15:32:22] Dramiel.INFO: All kills posted, newest kill id is  [] []
[2016-07-28 15:32:24] Dramiel.INFO: Checking for new killmails. [] []
[2016-07-28 15:32:24] Dramiel.INFO: All kills posted, newest kill id is  [] []
[2016-07-28 15:32:26] Dramiel.INFO: Checking for new killmails. [] []
[2016-07-28 15:32:27] Dramiel.INFO: All kills posted, newest kill id is  [] []
[2016-07-28 15:32:27] Dramiel.INFO: Checking for new killmails. [] []
[2016-07-28 15:32:28] Dramiel.INFO: All kills posted, newest kill id is  [] []
[2016-07-28 15:32:29] Dramiel.INFO: Checking for new killmails. [] []
[2016-07-28 15:32:29] Dramiel.INFO: All kills posted, newest kill id is  [] []
[2016-07-28 15:32:31] Dramiel.INFO: Checking for new killmails. [] []
[2016-07-28 15:32:31] Dramiel.INFO: All kills posted, newest kill id is  [] []
[2016-07-28 15:32:33] Dramiel.INFO: Checking for new killmails. [] []
[2016-07-28 15:32:33] Dramiel.INFO: All kills posted, newest kill id is  [] []
[2016-07-28 15:32:35] Dramiel.INFO: Checking for new killmails. [] []
[2016-07-28 15:32:35] Dramiel.INFO: All kills posted, newest kill id is  [] []
[2016-07-28 15:32:37] Dramiel.INFO: Checking for new killmails. [] []

1. Set up the Bot as per Manual getting these errors
2. Is there a command to pull data from Zkillboard?
3. thanks to that we need LAMP for this server, would it not be nice to create a GUI config.php for the Browser?
4. how can i check if the connection between the Discordbot and Mysql are working?

Thank you for the time invested

----dramielLog.log--------
[2016-10-01 09:54:36] Dramiel.INFO: Checking for new killmails. [] []
[2016-10-01 09:54:36] Dramiel.INFO: All kills posted, newest kill id is [] []
[2016-10-01 09:54:41] Dramiel.INFO: Checking for new killmails. [] []
[2016-10-01 09:54:41] Dramiel.INFO: All kills posted, newest kill id is [] []
[2016-10-01 09:54:46] Dramiel.INFO: Checking for new killmails. [] []
[2016-10-01 09:54:46] Dramiel.INFO: All kills posted, newest kill id is [] []
[2016-10-01 09:54:51] Dramiel.INFO: Checking for new killmails. [] []
[2016-10-01 09:54:51] Dramiel.INFO: All kills posted, newest kill id is [] []
[2016-10-01 09:54:56] Dramiel.INFO: Checking for new killmails. [] []
[2016-10-01 09:54:56] Dramiel.INFO: All kills posted, newest kill id is [] []
[2016-10-01 09:55:01] Dramiel.INFO: Checking for new killmails. [] []
[2016-10-01 09:55:01] Dramiel.INFO: All kills posted, newest kill id is [] []
[2016-10-01 09:55:06] Dramiel.INFO: Checking for new killmails. [] []
[2016-10-01 09:55:06] Dramiel.INFO: All kills posted, newest kill id is [] []
---------dramielOther.log----------
[2016-10-01 09:54:15] DiscordPHP.INFO: starting connection to websocket {"gateway":"wss://gateway.discord.gg/?v=6&encoding=json"} []
[2016-10-01 09:54:15] DiscordPHP.INFO: websocket connection has been created [] []
[2016-10-01 09:54:15] DiscordPHP.INFO: received hello [] []
[2016-10-01 09:54:15] DiscordPHP.INFO: identifying {"payload":{"op":2,"d":{"token":"XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX","properties":{"$os":"Linux","$browser":"DiscordPHP/v4.0.1 DiscordBot (https://github.com/teamreflex/DiscordPHP, v4.0.1)","$device":"DiscordPHP/v4.0.1 DiscordBot (https://github.com/teamreflex/DiscordPHP, v4.0.1)","$referrer":"https://github.com/teamreflex/DiscordPHP","$referring_domain":"https://github.com/teamreflex/DiscordPHP"},"compress":true}}} []
[2016-10-01 09:54:15] DiscordPHP.INFO: heartbeat timer initilized {"interval":41250} []
[2016-10-01 09:54:15] DiscordPHP.INFO: did not parse private channels [] []
[2016-10-01 09:54:15] DiscordPHP.INFO: stored guilds {"count":0} []
[2016-10-01 09:54:15] DiscordPHP.INFO: all guilds are now available {"count":2} []
[2016-10-01 09:54:15] DiscordPHP.INFO: loadAllMembers option is disabled, not setting chunking up [] []
[2016-10-01 09:54:15] DiscordPHP.INFO: client is ready [] []
-----------dramielError.log-------
PHP Warning: simplexml_load_string(): in /var/www/html/bot/src/plugins/onTick/getKillmails.php on line 148
PHP Warning: simplexml_load_string(): ^ in /var/www/html/bot/src/plugins/onTick/getKillmails.php on line 148
PHP Warning: simplexml_load_string(): Entity: line 5: parser error : Opening and ending tag mismatch: meta line 4 and head in /var/www/html/bot/src/plugins/onTick/getKillmails.php on line 148
PHP Warning: simplexml_load_string(): in /var/www/html/bot/src/plugins/onTick/getKillmails.php on line 148
PHP Warning: simplexml_load_string(): ^ in /var/www/html/bot/src/plugins/onTick/getKillmails.php on line 148
PHP Warning: simplexml_load_string(): Entity: line 9: parser error : Opening and ending tag mismatch: head line 3 and html in /var/www/html/bot/src/plugins/onTick/getKillmails.php on line 148
PHP Warning: simplexml_load_string(): in /var/www/html/bot/src/plugins/onTick/getKillmails.php on line 148
PHP Warning: simplexml_load_string(): ^ in /var/www/html/bot/src/plugins/onTick/getKillmails.php on line 148
PHP Warning: simplexml_load_string(): Entity: line 9: parser error : Premature end of data in tag html line 2 in /var/www/html/bot/src/plugins/onTick/getKillmails.php on line 148
PHP Warning: simplexml_load_string(): in /var/www/html/bot/src/plugins/onTick/getKillmails.php on line 148
PHP Warning: simplexml_load_string(): ^ in /var/www/html/bot/src/plugins/onTick/getKillmails.php on line 148
PHP Warning: simplexml_load_string(): Entity: line 5: parser error : Opening and ending tag mismatch: meta line 4 and head in /var/www/html/bot/src/plugins/onTick/getKillmails.php on line 148
PHP Warning: simplexml_load_string(): in /var/www/html/bot/src/plugins/onTick/getKillmails.php on line 148
PHP Warning: simplexml_load_string(): ^ in /var/www/html/bot/src/plugins/onTick/getKillmails.php on line 148
PHP Warning: simplexml_load_string(): Entity: line 9: parser error : Opening and ending tag mismatch: head line 3 and html in /var/www/html/bot/src/plugins/onTick/getKillmails.php on line 148
PHP Warning: simplexml_load_string(): in /var/www/html/bot/src/plugins/onTick/getKillmails.php on line 148
PHP Warning: simplexml_load_string(): ^ in /var/www/html/bot/src/plugins/onTick/getKillmails.php on line 148
PHP Warning: simplexml_load_string(): Entity: line 9: parser error : Premature end of data in tag html line 2 in /var/www/html/bot/src/plugins/onTick/getKillmails.php on line 148

Got a ping with the below

typeID 129 is an unmapped notification, send Mr Twinkie this whole message via evemail or github issue. applicationText: '' charID: 812411659 corpID: 1962136043

Fresh install, did the config, renamed it but when i try and start it i just get this
and can't figure out what is going on or why it happens

discord@digfordiamonds:/home/dramiel/Dramiel# php Dramiel.php  
[2016-10-13 20:53:07] DiscordPHP.INFO: gateway retrieved and set    {"gateway":"wss://gateway.discord.gg/?v=6&encoding=json"} []   
[2016-10-13 20:53:07] DiscordPHP.INFO: starting connection to websocket {"gateway":"wss://gateway.discord.gg/?v=6&encoding=json"} []    
[2016-10-13 20:53:08] DiscordPHP.INFO: websocket connection has been created [] []    
[2016-10-13 20:53:08] DiscordPHP.INFO: received hello [] []   
[2016-10-13 20:53:08] DiscordPHP.INFO: identifying {"payload":{"op":2,"d": {"token":"236189299199049739","properties":{"$os":"Linux","$browser":"DiscordPHP/v4.0.2 DiscordBot (https://github.com/teamreflex/DiscordPHP, v4.0.2)","$device":"DiscordPHP/v4.0.2 DiscordBot (https://github.com/teamreflex/DiscordPHP, v4.0.2)","$referrer":"https://github.com/teamreflex/DiscordPHP","$referring_domain":"https://github.com/teamreflex/DiscordPHP"},"compress":true}}} []  
[2016-10-13 20:53:08] DiscordPHP.INFO: heartbeat timer initilized {"interval":41250} []  
[2016-10-13 20:53:08] DiscordPHP.WARNING: websocket closed {"op":4004,"reason":"Authentication failed."} []

Thank you for your dedication!!!

I seem to have run into a issue. I have some doubts as to my setting up config.
supervisorctl restart dramiel runs nicely.

But when I try to talk to to the bot "!help" get nothing. Went to log error and below over and over.

PHP Fatal error:  Call to a member function sendMessage() on a non-object in /var/www/html/src/plugins/onTick/periodicStatusCheck.php on line 122
PHP Notice:  Undefined index: guildID in /var/www/html/src/plugins/onMessage/auth.php on line 79
PHP Notice:  Undefined index: periodicCheck in /var/www/html/src/plugins/onTick/authCheck.php on line 107

Here are the parts of my config that I have changed.

`"token" => "XxXxXxX0Xxx1MTExNjI5MzE0.XxXXxX.BdRCYqokTqTSGU1yU_gm0uUWutA"`

Have checked this 3 times.. This is from https://discordapp.com/developers/applications/me/
"My Applications" and the "APP BOT USER" and token below.

    "user" => "xxxxxxxxxx",
    "pass" => "xxxxxxxxxx",

$config["eve"] = array(
    "apiKeys" => array(
        "user1" => array(
            "keyID" => "123456789",   
              "vCode" => "XXXX",   `    

(Main Char api "Char info+Standings)

"characterID" => 1234 (Char ID from Discord. Tried ID for char from zkill but no difference)

When I turn on the zkill by adding
"allianceID" => 1234567, (Alliance iD I get from zkill did not add one for corp)

Error changes to

PHP Fatal error:  Call to a member function sendMessage() on a non-object in /var/www/html/src/plugins/onTick/periodicStatusCheck.php on line 122
PHP Notice:  Undefined index: guildID in /var/www/html/src/plugins/onMessage/auth.php on line 79
PHP Notice:  Undefined index: periodicCheck in /var/www/html/src/plugins/onTick/authCheck.php on line 107

I have added the bot a few times. I did notice that it does not show up under "Authorised Applications".
https://discordapp.com/oauth2/authorize?&client_id=xxx&scope=bot
xxx = Client/Application ID from https://discordapp.com/developers/applications/me/

Did not set up auth yet.

Thank you!!

I noticed a while after i performed a git pull, that i'm no longer getting killmail updates of any kind, when i check the error log I have this:

PHP Warning:  simplexml_load_string(): Entity: line 1: parser error : Start tag expected, '<' not found in /home/leon/discordbot/Dramiel/src/plugins/onTick/getKillmails.php on line 133
PHP Warning:  simplexml_load_string(): [{"killID":55100424,"solarSystemID":30001442,"killTime":"2016-07-14 18:13:00","m in /home/leon/discordbot/Dramiel/src/plugins/onTick/getKillmails.php on line 133
PHP Warning:  simplexml_load_string(): ^ in /home/leon/discordbot/Dramiel/src/plugins/onTick/getKillmails.php on line 133

Any thoughts?