When I tried to setup the database using phpMyAdmin on a webserver by importing the SQL script it came up with a number of errors. This is due to the html commands used to show certain characters. The html codes typically end in ';' which terminates a line in phpMyAdmin.

If you setup the database on your own machine do it from the command prompt. In my case, on a windows machine I copied the items.sql file to the root and then setup the database in MySQL at the command prompt.


MySQL>Create database bebot;
MySQL>use bebot;


To get my bot working I downloaded the latest versions of Apache, MySQL and PHP. Having installed and configured them, about an hour, I then dropped BeBot into a folder in htdocs in the apache folder.
Copied the PHP essential files off this site and added 2 lines to the php.ini file.

extension=php_bz2.dll
extension=php_sockets.dll

Once done I then had a problem:

"Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in xxx\MySQL.php on line 36"

Go to the MySQL website and search for MySQL Administrator, download it and run it.
Then follow these instructions.
Go to start up variables, then to security and put a check in use old passwords.

Then go back to the MySQL command prompt and type


MySQL>\. c:/items     #note there is no trailing ';' for this


to import the database. This should take a minute at most and once done the database is ready.

After this go back to the MySQL Administrator to grant all permissions on all databases for your user. Then restarted the MySQL server.

In command prompt

net stop mysql
net start mysql

Then in the command prompt go to the folder for BeBot and type

php start.php

After that it worked absolutely fine and will be running our raids from now on.