Author Topic: Nano formulas module (Read 51915 times)

jjones666 · « **on:** February 25, 2007, 01:49:27 am »

One thing I saw from the !guides module was that having the nano formula locations in the bot was bloody handy. As we had a great codebase for searching database with Wolfbiter's !symb module, I spent the last few weeks taking a look at the in game nanos.

Information was taken from a variety of places, I checked all of the SL gardens myself - from what I remember RK nanos info mostly came from Jexai's, SL quest info from AO-Universe. As I mentioned 99.9% of the coding is Wolfbiter's original module.

- added all SL garden nanos.
- added all RK store nanos.
- added all RK mission nanos.
- added all RK dynaboss nanos.
- added all RK unique mob nanos.
- added all general type nanos.
- added SL static dungeon nanos.
- added SL quest nanos.
- added SL nanos which drop from random mobs.
- added SL jobe zone nanos (keeper and shade only).
- added LE VP nanos.
- search limited to 200 nanos to prevent bot crashing.

Obviously, this will work in same manner as the !symb module. Requires Glara's new module settings module (you can turn the icon display on and off in !settings).

As most of the work is manually done, its possibly got a few bad entries, please let me know if you find any.

Theres a nice little menu if you just do !nano, you can also see most of the searchterms in there.

PHP
SQL
Help

Cheers,

-jj-

EDIT: includes Wolfbiter's fix posted below.
EDIT: module tested with bebot 0.2.11.
EDIT: spelling error fixed, help added (thanks Pusikas).
EDIT: helpfile updated - SQL updated to 17.2 - added exact string search (thanks Wolfbiter).
EDIT: SQL updated to 17.3.

Wolfbiter · « **Reply #1 on:** February 25, 2007, 02:59:26 am »

Code: [Select]

        function make_chatcommand($link, $title)
        {
			return '<a href=\'chatcmd:///tell '.$this->bot->botname.' '.$this->bot->commpre.$link.'\'>' . $title . '</a>';
        }

Will cause problem on bots with stupid (regexp) triggers.

use:

Code: [Select]

        function make_chatcommand($link, $title)
        {
			return '<a href=\'chatcmd:///tell '.$this->bot->botname.' <pre>'.$link.'\'>' . $title . '</a>';
        }

buff · « **Reply #2 on:** February 28, 2007, 09:48:40 pm »

tried it today and did a search w/ !nano adv
then i get spammed from bot and eventually had to restart bot to stop the spam

bot will respond w/ found 2xx result with (page 1 of 2) then next is (page 2 of 2) then next is (page 1 of 2)(page 2 of 2) and go on

thought i would point it out so u can look into it

jjones666 · « **Reply #3 on:** February 28, 2007, 09:58:27 pm »

[Uprising] Jackjonez: !nano adv
[Uprising] Uprnet: 231 nano formulas found (displaying only 1-200) :: click to view (page 1 of 4)
[Uprising] Uprnet: 231 nano formulas found (displaying only 1-200) :: click to view (page 2 of 4)
[Uprising] Uprnet: 231 nano formulas found (displaying only 1-200) :: click to view (page 3 of 4)
[Uprising] Uprnet: 231 nano formulas found (displaying only 1-200) :: click to view (page 4 of 4)

Can you confirm what version of bebot you run, this was fixed ages ago?

Cheers,

-jj-

jjones666 · « **Reply #4 on:** March 01, 2007, 08:09:00 am »

Fix here:
http://bebot.link/index.php/topic,234.0

Would advise update to latest Bebot ASAP.

-jj-

jjones666 · « **Reply #5 on:** March 05, 2007, 01:08:42 pm »

As all mentioned problems were fixed, I added this to the A-Z.

Any comments on bad data yet or further problems with the plugin itself?

Cheers,

-jj-

p.s. tidied up the post somewhat also where problems had been fixed.

pusikas · « **Reply #6 on:** March 05, 2007, 02:18:38 pm »

The help you get from !nano uses the word "nansense" under location. Is that supposed to mean "Nascence", or "Nonsense"?

Edit: actually, the whole PHP file uses nansense... I, uhm... consider this a bug. ^^
Another Edit: wrong writing is in SQL as well

pusikas · « **Reply #7 on:** March 05, 2007, 02:32:27 pm »

And since my org kept bugging me that there was a helpfile missing, I turned the output of !nano into a helpfile. Changed nansense into nascence, tho, so may not work with JJ's php until he fixes it.

jjones666 · « **Reply #8 on:** March 10, 2007, 03:42:02 pm »

Updated .php and .sql to fix spelling error, you will need to drop and reimport database. Added the help file to first post.

Thanks,

-jj-

Earth · « **Reply #9 on:** March 21, 2007, 07:02:03 am »

How do I upload into SQL?

Malosar · « **Reply #10 on:** March 21, 2007, 06:27:51 pm »

For SQL manipulation, use a program called SQLYog. It's free and fairly easy to use compared to most. You can edit existing data, create/modify tables, import/export data etc.

pusikas · « **Reply #11 on:** March 22, 2007, 12:28:13 pm »

When I do something like

Code: [Select]

!nano Empowered Partial Reflective Fieldto see in what garden it is sold, I get 2 pages of hits, all nanos listed containing at least one of the four words in their name. Would it be possible to change the module to look for an exact hit when I put the searchstring into quotes? So that

Code: [Select]

!nano "Empowered Partial Reflective Field"returns only one hit? Or maybe something like

Code: [Select]

!nano exact Empowered Partial Reflective FieldOr maybe change the module so that the nanos are ordered by the number of "hits", meaning words that match in their name. Although I guess that would be harder to code than the two above suggestions.

I have tried to change that myself, but without much success yet. Gotta admit that I have trouble understanding some parts of the code.

jjones666 · « **Reply #12 on:** March 22, 2007, 01:48:29 pm »

Yeah the advantage to the current system is that you can use as many search terms as you like, ie. !nano soldier 100-125 slquest or whatever. So in the first case you're doing four seperate searches hence large amount of hits. The code is Wolfbiter's baby, and offhand, I can't think if this change is possible. Normally, I simply look by profession/QL for quickest results.

-jj-

Wolfbiter · « **Reply #13 on:** March 22, 2007, 03:39:41 pm »

I might look over my search methods after the weekend (if I feel like it or remember it) for something along the lines of "bla bla", I've had some other instances where this would have been usefull.

EDIT

Well.. sometimes I can't let go of an idea...

Code: [Select]

function nano($input)
		{
			$input = explode(" ",strtolower($input));
			$type = false;
			...

Replace that bit with

Code: [Select]

function nano($input)
		{
			$hftext = false;
			$ftext = false;
			preg_match_all('¤"([^"]+)"¤U',$input,$exact,PREG_SET_ORDER);
			foreach ($exact as $loop) {
				$ftext = ($ftext ? $ftext." or ":"")."name like '%".$loop[1]."%'";
				$hftext = (!$hftext ? "'$loop[1]'" : $hftext.", '$loop[1]'");
			}
			$input = preg_replace('¤".+"¤',"",$input);
			$input = preg_replace('|\s\s+|',' ',$input);
			$input = explode(" ",strtolower($input));
			$type = false;
			...
			//$ftext = false; <- if this isn't commented out the stuff in "" wont be searched for.
			//$hftext = false; <- same here

I've not tested it with a real script, I'll leave that up to jj, but it *should* work.

EDIT2
Corrected a typo

pusikas · « **Reply #14 on:** March 22, 2007, 04:28:44 pm »

Quote from: jjones666 on March 22, 2007, 01:48:29 pm

Normally, I simply look by profession/QL for quickest results.

Thanks for mentioning this, it did not occur to me, and would help as well, ofc. Currently plyaing a new soldier. I use auno.org to dig up the nanos I want, but I do not trust the site to give me valid info on where to buy SL nanos. Hence my asking. Is not the first time this has come up, tho. Some peeps from org told me they'd like exact matches before. I just did not see why this would be good until I had the need myself.

Author Topic: Nano formulas module (Read 51915 times)

jjones666

Nano formulas module

Wolfbiter

Re: Nano formulas module

buff

Re: Nano formulas module

jjones666

Re: Nano formulas module

jjones666

Re: Nano formulas module

jjones666

Re: Nano formulas module

pusikas

Re: Nano formulas module

pusikas

Re: Nano formulas module

jjones666

Re: Nano formulas module

Earth

Re: Nano formulas module

Malosar

Re: Nano formulas module

pusikas

Re: Nano formulas module

jjones666

Re: Nano formulas module

Wolfbiter

Re: Nano formulas module

pusikas

Re: Nano formulas module