Author Topic: Updated bebot to PHP5 + new Online,Loot and teammodule (Read 15665 times)

Zacix · « **on:** August 02, 2005, 04:07:06 pm »

First of all, if you want to use this updates, be aware that other official updates might not work as intended. That being said, I think these updates are alot better

. Second, you MUST update to PHP5. The change from PHP4 to PHP5 is severe when it comes to how objects are handled. Don't think any of these modules will work with PHP4 (Haven't tested though, just take my word for it

). Third, ONLY do this if you have a pure raidbot. I've taken away some functionality for guild and so on.

First you need PHP5:
PHP5

In this zip file you will find php.exe, php5ts.dll,php_bz2.dll, php_mysql.dll and php_sockets.dll. Copy them to your Bot-root-folder and overwrite the current ones.

AOChat v1.17:
AOChat v1.17

Also copy to your bot-root folder.

You now have to make a folder called "includes" in your botfolder, and put these files there: includes

Now, after a while coding on the bot, I realised that a many modules are dependent on who is in the bot and so on. All my future releases will be dependent on the new online module, but the current ones don't.

Online module

I also strongly recommend to update main.php and bot.php. I think I've done some fixes there :shock:
main
bot

New lootmodule, needs it's own table of items...I got tired of waiting for updates here, so I made my own.

Items
import this by doing: source /path/items.sql on the mysql commandline.
Loot module

Teamsmodule, same as earlier released for PHP4 with some corrections for PHP5:
Teams module

New _items.php
_item.php

Zacix · « **Reply #1 on:** August 12, 2005, 07:36:30 pm »

Updated loot module with loot history and fixed a bug. Just type !loothistory, and you should see the last 15 items won. There are also Previous/Next links in the blob to see older loot.

craized · « **Reply #2 on:** August 13, 2005, 01:31:44 am »

Ooh, shiny.

Nice work.

Zacix · « **Reply #3 on:** August 13, 2005, 03:34:35 am »

Forgot to upload new _items.php to put in the include folder. Also did a little bugfix on the instant translator for Bio Material in the loot module, so everyone should get that one as well...

Ever · « **Reply #4 on:** August 22, 2005, 03:37:11 am »

You propably want to change the PHP5 link since the php-5.1.0b3 isn't working with AOChat, but for example version php-5.0.4 does.

Plus in addition to copy those files that are in your guide you need to create php.ini to the bot root folder, containing at leat:

Code: [Select]


extension_dir = ./

extension=php_bz2.dll
extension=php_mysql.dll
extension=php_sockets.dll

Shelly · « **Reply #5 on:** August 22, 2005, 04:32:44 am »

Quote from: "Zacix"

First you need PHP5:
PHP5

In this zip file you will find php.exe, php5ts.dll,php_bz2.dll, php_mysql.dll and php_sockets.dll. Copy them to your Bot-root-folder and overwrite the current ones.

Hum... Guess I'll need to play with this a bit to see what needs to be done to run this on Linux... You may want to include a link (see below) to the PHP5 source code for Unix systems too. ;-)

PHP Downloads

Perhaps I can get it running on Fedora Core 4... *rubs her hands in anticipation of the new challenges*

Xenixa · « **Reply #6 on:** August 25, 2005, 09:37:58 am »

Zacix,

You may want to run the following Query on your items table as there is more there than you need. Namely NPC items. Luckily you included the item type column in your items.sql

Code: [Select]

DELETE FROM aodb WHERE aodb.itemtype = 'NPC'

Use what ever Query program you like and connect to whatever you named your bots Database. You'll eliminate alot of items that do not need to be there.

Zacix · « **Reply #7 on:** August 25, 2005, 11:09:52 am »

Quote from: "Xenixa"

Zacix,

You may want to run the following Query on your items table as there is more there than you need. Namely NPC items. Luckily you included the item type column in your items.sql

Code: [Select]
DELETE FROM aodb WHERE aodb.itemtype = 'NPC'

Use what ever Query program you like and connect to whatever you named your bots Database. You'll eliminate alot of items that do not need to be there.

Thx for the tip, although, it doesn't really matter. That table isn't used for the !items command anyway. It's used purely for getting iconids. I will however make use of this table for !items command as well when I get the time to rewrite it.

Xenixa · « **Reply #8 on:** August 25, 2005, 04:12:21 pm »

Speaking of which, and not to hijack the thread. But how did you go about parsing the items to a sql file? I been playing with Jayden's AODB.ResourceTool but the sql output plugin he has puts out way more info than needed. Would take me forever to re-write a schema that only grabs what I want out of that dump.

Any links you know of to tips or FAQ's on how to generate a sql file from the Ctree database that AO uses?
Actually I was playing with the idea of using the XML to MySQL php class. Use Auno's downloadable XML file( http://auno.org/dev/aoxml.html ) as the source and only parse whats needed into a MySQL table for use in the !items module.

Zacix · « **Reply #9 on:** August 26, 2005, 10:50:28 am »

Quote from: "Xenixa"

Speaking of which, and not to hijack the thread. But how did you go about parsing the items to a sql file? I been playing with Jayden's AODB.ResourceTool but the sql output plugin he has puts out way more info than needed. Would take me forever to re-write a schema that only grabs what I want out of that dump.

Any links you know of to tips or FAQ's on how to generate a sql file from the Ctree database that AO uses?
Actually I was playing with the idea of using the XML to MySQL php class. Use Auno's downloadable XML file( http://auno.org/dev/aoxml.html ) as the source and only parse whats needed into a MySQL table for use in the !items module.

I used Jayden's AODB.ResourceTool and made an XML file, after that I used Angels AODBXMLParser to parse the xml. It used to be on http://dl.angelsbot.de/tools/AODBXMLParser, but it seems it's not working anymore :/

Xenixa · « **Reply #10 on:** August 26, 2005, 01:37:58 pm »

Ya it looks like there is an error on the Angelsbot server. Or the the file got moved.

You still have a copy of AODBXMLparser 2.6 you could e-mail out possibly?
Send to: [email protected]

Would be very grateful of you if you did.

Xenixa

Zacix · « **Reply #11 on:** August 31, 2005, 10:44:09 am »

Quote from: "Xenixa"

Zacix,

You may want to run the following Query on your items table as there is more there than you need. Namely NPC items. Luckily you included the item type column in your items.sql

Code: [Select]
DELETE FROM aodb WHERE aodb.itemtype = 'NPC'

Use what ever Query program you like and connect to whatever you named your bots Database. You'll eliminate alot of items that do not need to be there.

Actually, found an item which has the tag NPC that is used ingame. Fire_Slapon_XX03. I know I get this one from time to time when I do a RK mission.

I'll also email you the parser...if I find it -.-

Zarkingu · « **Reply #12 on:** September 10, 2005, 05:34:51 pm »

Is there any chance that you would make some kinda of Command Access Control module for these plugins. All the commands in for example the loot module can be used by everyone as it is now. I use this bot for a raidbot and would like some kinda of restrictions on who get access to what (Superadmin, admin, raidleader). I've been trying to modify this myself, but with limited knowledge in PHP it allways end up working in a different way than I planned