BeBot - An Anarchy Online and Age Of Conan chat automaton

Development => Module Requests => Topic started by: Oreo on April 22, 2009, 02:25:17 am

Title: !nano module
Post by: Oreo on April 22, 2009, 02:25:17 am
This would be a fantastic module to have if possible, very similar to that of Budabot

!nano *nano name/part of name here*

http://budabot.aodevs.com/index.php/topic,222.0.html


something like this would be very awesome to have!
Title: Re: !nano module
Post by: Nogoal on April 22, 2009, 12:34:29 pm
Here's the one I use. Don't remember where I got it and if I changed stuff but it works on my bots.
Title: Re: !nano module
Post by: Khalem on April 22, 2009, 02:48:35 pm
Could you also post the nano table from your bot database as the module itself is useless without it.

[edit]

Came across this today http://forums.anarchy-online.com/showthread.php?t=543290
Wolfbiter is the original author of said module.
Title: Re: !nano module
Post by: Wolfbiter on April 22, 2009, 10:20:53 pm
The old script by jackjones
http://bebot.link/0-2-x-customunofficial-modules/nano-formulas-module/

Don't know if it's been ported to newer bebot.. but if someone wants to I've included sql dump used with my nanopage.
Title: Re: !nano module
Post by: Iohn on December 22, 2009, 10:57:10 pm
Hi,
I got bebot 0.6.5 running on a PHP 5.2.11 and mysql server 5.1.40.
I would very much like to run this nano module, but it's giving me a error,
the sql data is imported into my mysql server.
as you se below, I ran two commands on my sql server, on with the output from nano module and one modified.
the one modified works nicely. I could guess this is either updated PHP or MySql problem.

mysql> select * from nanos where (lowql=lowql) and (lowql=lowql) and (lowql=lowql) and (name like '%guardian of might%') ORDER BY lowql, profession LIMIT 0, 200;
ERROR 1054 (42S22): Unknown column 'lowql' in 'where clause'
mysql> select * from nanos where (nano like '%guardian of might%') ORDER BY profession LIMIT 0, 200;                                     +----------------------------+--------+---------+---------------------------------------------------------------------------------------------+-----+---------------+-------+------------+----------+----------------------------+-----+----+----+------+----+----+------+------+-----+-----------+----------+
| nano                       | aoid   | crystal | desc                                                                                        | ql  | stackingorder | icon  | profession | location | type                       | lvl | mm | bm | pm   | mc | ts | si   | spec | ncu | nanoorder | disabled |
+----------------------------+--------+---------+---------------------------------------------------------------------------------------------+-----+---------------+-------+------------+----------+----------------------------+-----+----+----+------+----+----+------+------+-----+-----------+----------+
| Guardian of Might          | 211162 |  211163 | Increases the strength and stamina of the Keeper by 40 points and the agility by 15 points. | 170 |            43 | 39228 | Keeper     | RK Dyna  | Strength and Stamina Buffs | 165 |  0 |  0 |  875 |  0 |  0 |  875 |    0 |  43 |      4300 |        0 |
| Improved Guardian of Might | 273365 |  273366 | Increases the strength and stamina of the Keeper by 80 points and the agility by 30 points. | 215 |            56 | 39228 | Keeper     | DB Quest | Strength and Stamina Buffs | 215 |  0 |  0 | 1244 |  0 |  0 | 1244 |    0 |  56 |      5600 |        0 |
+----------------------------+--------+---------+---------------------------------------------------------------------------------------------+-----+---------------+-------+------------+----------+----------------------------+-----+----+----+------+----+----+------+------+-----+-----------+----------+
2 rows in set (0.01 sec)

regards
SimplePortal 2.3.7 © 2008-2024, SimplePortal