I'm not sure if this has been mentioned before but the module doesnt handle a command prefix starting with a \

The bot I run uses the command prefix "\." This made .symb send back \.pb links instead of .pb

Hopefully this isnt too sloppy but its the best I could come up with as a 'fix' right now. I would've wanted a 'cleaner' way to hide the if statement but I'm out of practice
function make_chatcommand($link, $title) {
$new_commpre = $this->bot->commpre;
if(substr_compare($new_commpre, '\\', 1))
$new_commpre = substr($new_commpre, 1);
return '<a href=\'chatcmd:///tell '.$this->bot->botname.' '.$new_commpre.$link.'\'>' . $title . '</a>';
}

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


The backslash is required since the prefix is used in rexexp matching, hence just "." will break, you need to escape it using \.

I'll probably have a proper look at this when i find the time to merge it into trunk.

Maybe it's possible to make it true regexp? So we can have multiple prefixes allowed.

Not sure what you're trying to say. The issue is that \ and . are used as part of regular expressions. If you are trying to match \ and . in a regular expression, you have to escape them using and extra backslash. \\ matches \ and \. matches .


There are 11 characters with special meanings in regular expressions: the opening square bracket [, the backslash \, the caret ^, the dollar sign $, the period or dot ., the vertical bar or pipe symbol |, the question mark ?, the asterisk or star *, the plus sign +, the opening round bracket ( and the closing round bracket ). These special characters are often called "metacharacters".

It is probally a good idea to just not use regex metacharacters as your command prefix. I don't know if escapting the characters in your configuration file will work...

Updated again -

- Added 280 infantry eye (oops!)
- Corrected QL error on 1 entry

http://www.jjones.co.uk/files/symbiants.sql
up to 875 symbs in DB.

Apart from undiscovered symbs dropping from PB's - sql is 100% - unless i missed a few out :-)

N.B. now only missing 100% confirmation on:
QL 270 Cognizant Waist Symbiant, Control Unit Aban*

* I added under Tailee Frees for the time being as this is the boss we think drops it.  Was confirmed by Ulna to drop from "Clan Inf Key" PB.

Did you import both databases?

-jj-

ok I was thinking maybe I shouldn't be importing wiht a GUI, does anyone know the line command version?

ok I was thinking maybe I shouldn't be importing wiht a GUI, does anyone know the line command version?

First and foremost, before importing data (or doing anything with your database that can potentially damage your existing data) take a backup. Yes, I know.. I know.. where's the excitement if you have a backup?

For the backup, do:

mysqldump -uusername databasename -p > backup.sql

Hitting enter and you'll be prompted for your password.

So if you have a mysql username that is 'leet' with a database named 'symbiants' it would be...

mysqldump -uleet symbiants -p > backup.sql

What happens here is that mysqldump will create a backup of the database 'symbiants.sql' into a file named 'backup.sql' which it'll create in the same directory you're in.

You guessed it, there are more fancy ways of doing this but the above command gets the job done.

Armed with our backup we can now continue on with our efforts to deliberately destroy import data to our database with the following:

mysql -uusername databasename -p < import.sql

Still using our example from above..

mysql -uleet symbiants -p < import.sql

Hitting enter, you'll be promted with "Enter password:" when the correct password has been entered, there won't be much happening on the screen given everything works out. It'll only prompt you with error messages etc., but what are the odds that that will happen and besides, that's a completely different question than what I'm trying to answer.

On the screenshot you provided I noticed you've already got Apache running and odds are that you've got PHP too. Therefore, I would warmly recommend having a look at phpmyadmin over at http://www.phpmyadmin.net/

It's not as fancy as the GUI tools you may be used to, but it's not so flashy that it gets in your way.

Hope that helps.

Sincerely,
Gilfar