EQDKP bot

[gp1001]

I am looking for someone or some people in the comunity that are willing to do some coding.

I would like to see a bot that can retrieve requested data from a mysql database and send the results back to the requester.

Examples:

/tell dkpbot dkp - would return the current dkp for the person sending the tell.
/tell dkpbot lastloots supernoob - Would return Itemname / Date / RaidName of the last 5 items looted by supernoob
/tell dkpbot last30 - would return the requesters attendance for the last 30 days.
/tell dkpbot last60 - would return the requesters attendnace for the last 60 days.
/tell dkpbot last90 - would return the requesters attendnace for the last 90 days.

/tell dkpbot -50 supernoob for being an rtard! - would give supernoob a -50 adjustment with "for being an rtard!" in the comment. I would also like to be able to give positive adjustments as well. This would need to be limited to certain people only.

More functionality but this is what came to mind at the moment.

I am willing to pitch in 50$ to get this started in the hopes that other people in the community that use a dkp system would chip in what they could to help pay for the project. If the community is not willing to chip in, I am willing to pay 50$ up front and then 20$ intervals over time until the project is complete.

If I end up funding the entire project, I would like to have the source kept private though.

Thanks!

 

[Pygar]

I don't dkp and have no vested interest in coding this. However, if the bounty offer gets over $150 I'll make it.

 

[v01d]

I don't understand why you need a bot to interact with your DKP database when the game has a fully functional web browser built in.

v01d

 

[gp1001]

I don't understand why you need a bot to interact with your DKP database when the game has a fully functional web browser built in.

v01d

LOL, kind of like saying I dont understand why you need a bot, each PC comes with a keyboard.

It makes it easier, no flipping through pages trying to find the info you need,
Plus try entering in info on the ingame web browser with innerspace loaded.
And the ingame browser is FAR from full functional...

 

[Amadeus]

By the way ..I keep meaning to put in a new TLO/datatype into my extensions to give users an easy way to do md5 hash/encryption stuff with lavishscript.

And, I think this is a good idea. The nice thing about a script like this is that it could be easily ported to other games.

Also, remember that each lavishscript script is like a thread. So, you could write a seperate thread/script for interacting with a mysql datatype, etc. Seriously, there is just about nothing that lavishscript cannot do really, given the right kind of ingenuity and creativity. I personally think it's a lot better than dealing with all of the hassle and bugs of .NET.

 

[mycroft]

Hmm...might be interesting to see how to read/write to an SQL database..

 

[gp1001]

I have started to get the Mysql qeuries togeather =)

 

[Amadeus]

Honestly, the best idea would be to write a php webpage that sits on a server and does the MySQL interaction for you (since php is so easy to use in regards to MySQL).

Then, I could write a simple extension that would allow you to easily interact with a webpage like that and would have shit come back to you as 'events'.

Actually, I'll start working on that....that's a good idea. Or, perhaps I'll just add it to all of my extensions.

ie, you could do something like:

ISXEQ2:Send[http://www.mypage.com/AccesDB.php?user=blah&pass=blah]

And then there would be an event like ISXEQ2_HTTPResponse(string FromURL, int Length, string Data)

That's a rough thought process ...but would be easy to add. I'd probably think of a better way to do it once I got started.

 

[Pygar]

Some reason I thought there was some stuff in IS for consuming webservices. Basically http post as described, then read in the xml set's returned from the PHP page.

It's been a couple years since I was playing with that though, so I could be horribly wrong.

 

[gp1001]

Honestly, the best idea would be to write a php webpage that sits on a server and does the MySQL interaction for you (since php is so easy to use in regards to MySQL).

Then, I could write a simple extension that would allow you to easily interact with a webpage like that and would have shit come back to you as 'events'.

Actually, I'll start working on that....that's a good idea. Or, perhaps I'll just add it to all of my extensions.

ie, you could do something like:

ISXEQ2:Send[http://www.mypage.com/AccesDB.php?user=blah&pass=blah]

And then there would be an event like ISXEQ2_HTTPResponse(string FromURL, int Length, string Data)

That's a rough thought process ...but would be easy to add. I'd probably think of a better way to do it once I got started.

Thats exactly how I am doing it ATM... I have different queries in setup in .php I target the Player and click the ingame macro. It returns the results in the browser.

Example ingame macro.

/browser http://www.mypage.com/AccesDB.php?user=?%t

But like I said the ingame browser sometimes crashes EQ2 and on other times I cant get the damn browser to go away.