next »

[joefhp]

Hi,
 I have installed the B3 on my UO server. The Welcome message comes up, and thats it. None of the commands work or anything. I am totally new to this, so if some one with some patence can help me get this working, it would be greatly appreciated. I have read around in the forums, but I cant find what i need.

[Courgette]

Hi,

You will get help by posting your b3.xml and b3.log (hide passwords).
Keep in mind that we need enough info from you to be able to reproduce your issue.

[Rei]

Hi,
 I have installed the B3 on my UO server. The Welcome message comes up, and thats it. None of the commands work or anything. I am totally new to this, so if some one with some patence can help me get this working, it would be greatly appreciated. I have read around in the forums, but I cant find what i need.

your issue is easy =)
if you have the message like what your bot connect on server and none of commands works , it might be a problem from your link to gamelog
post your B3.xml and be sure to remove the password of your ftp link ( if you use one ) , remove the password of your DB and your rcon !
also if you use a ftp link , try to go on internet with it

[joefhp]

your issue is easy =)
if you have the message like what your bot connect on server and none of commands works , it might be a problem from your link to gamelog
post your B3.xml and be sure to remove the password of your ftp link ( if you use one ) , remove the password of your DB and your rcon !
also if you use a ftp link , try to go on internet with it

I can connect to FTP, I get an error as well that says cannot connect to DB...I think thats where I went wrong, I dont know how to make a DB
 <?xml version="1.0" ?>
- <configuration>
- <settings name="b3">
  <set name="parser">cod</set>
  <set name="database">mysql://Joe:@69.28.221.8/b3_db</set>
  <set name="bot_name">B3</set>
  <set name="bot_prefix">^0(^2b3^0)^7:</set>
  <set name="time_format">%I:%M%p %Z %m/%d/%y</set>
  <set name="time_zone">EST</set>
  <set name="log_level">22</set>
  <set name="logfile">/path/to/b3.log</set>
  </settings>
- <settings name="server">
  <set name="rcon_password"></set>
  <set name="port">28960</set>
  <set name="game_log">http://ftp://Sarnoj:@Sarnoj@69.28.221.8/uo</set>
  <set name="public_ip">69.28.221.8</set>
  <set name="rcon_ip">69.28.221.8</set>
  <set name="punkbuster">on</set>
  </settings>
- <settings name="autodoc">
  <set name="type">html</set>
  <set name="maxlevel">100</set>
  <set name="destination">C:\\Program Files\\BigBrotherBot_1.4.0/log.html</set>
  </settings>
- <settings name="messages">
  <set name="kicked_by">%s^7 was kicked by %s^7 %sThe Supreme Being</set>
  <set name="kicked">%s^7 was kicked %sThe Supreme Being</set>
  <set name="banned_by">%s^7 was banned by %s^7 %sThe Supreme Being</set>
  <set name="banned">%s^7 was banned %sThe Supreme Being</set>
  <set name="temp_banned_by">%s^7 was temp banned by %s^7 for %s^7 %sThe Supreme Being</set>
  <set name="temp_banned">%s^7 was temp banned for %s^7 %sThe Supreme Being</set>
  <set name="unbanned_by">%s^7 was un-banned by %s^7 %sThe Supreme Being</set>
  <set name="unbanned">%s^7 was un-banned %sThe Supreme Being</set>
  </settings>
- <settings name="plugins">
  <set name="external_dir">C:\\Program Files\\BigBrotherBot_1.4.0\\extplugins</set>
  </settings>
- <plugins>
  <plugin name="censor" config="@conf/plugin_censor.xml" />
  <plugin name="spamcontrol" config="@conf/plugin_spamcontrol.xml" />
  <plugin name="admin" config="@conf/plugin_admin.xml" />
  <plugin name="tk" config="@conf/plugin_tk.xml" />
  <plugin name="stats" config="@conf/plugin_stats.xml" />
  <plugin name="pingwatch" config="@conf/plugin_pingwatch.xml" />
  <plugin name="adv" config="@conf/plugin_adv.xml" />
  <plugin name="status" config="@conf/plugin_status.xml" />
  <plugin name="welcome" config="@conf/plugin_welcome.xml" />
  <plugin name="punkbuster" config="@conf/plugin_punkbuster.xml" />
  <plugin name="xlrstats" config="C:\\Program Files\\BigBrotherBot_1.4.0\\extplugins" />
  </plugins>
  </configuration>

[GrossKopf]

You need access to a MySQL database. If you do not know how to do it, I'm sure whoever you have your webhosting can assist you with that.

[Rei]

<set name="game_log">http://ftp://Sarnoj:@Sarnoj@69.28.221.8/uo</set>
you have to put your FTP link for game_log
for make a DB , DL wampserver
when you dl it , you launch it , then you do a right clik
( )
you click PHPmyadmin , you should have a webpage which appear,
then :MySQL localhost
Create new database : you put : B3
--> create
 you click on Privileges , --> add new user -->
login information : username : B3
pasword : putapassword
retype : putagainthepassword

Database for user :
you chose ->  Grant all privileges on database "aa"
and you click go

now click Import , and browser b3.sql ( in your B3 folder .. ) --> Go
click again import , and browser xlrstats.sql ( in your B3 folder also ) --> Go

and then you have your DB ..

[joefhp]

So far so good, up to the point where I import b3 sql...I get
  #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?xml version="1.0"?> <configuration> <settings name="b3"> <set name="pars' at line 1

<set name="game_log">http://ftp://Sarnoj:@Sarnoj@69.28.221.8/uo</set>
you have to put your FTP link for game_log
for make a DB , DL wampserver
when you dl it , you launch it , then you do a right clik
( )
you click PHPmyadmin , you should have a webpage which appear,
then :MySQL localhost
Create new database : you put : B3
--> create
 you click on Privileges , --> add new user -->
login information : username : B3
pasword : putapassword
retype : putagainthepassword

Database for user :
you chose ->  Grant all privileges on database "aa"
and you click go

now click Import , and browser b3.sql ( in your B3 folder .. ) --> Go
click again import , and browser xlrstats.sql ( in your B3 folder also ) --> Go

and then you have your DB ..

[joefhp]

<set name="game_log">http://ftp://Sarnoj:@Sarnoj@69.28.221.8/uo</set>
you have to put your FTP link for game_log
for make a DB , DL wampserver
when you dl it , you launch it , then you do a right clik
( )
you click PHPmyadmin , you should have a webpage which appear,
then :MySQL localhost
Create new database : you put : B3
--> create
 you click on Privileges , --> add new user -->
login information : username : B3
pasword : putapassword
retype : putagainthepassword

Database for user :
you chose ->  Grant all privileges on database "aa"
and you click go

now click Import , and browser b3.sql ( in your B3 folder .. ) --> Go
click again import , and browser xlrstats.sql ( in your B3 folder also ) --> Go

and then you have your DB ..

[GrossKopf]

So far so good, up to the point where I import b3 sql...I get
  #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?xml version="1.0"?> <configuration> <settings name="b3"> <set name="pars' at line 1

Are you using B3 version 1.4.0? If so, maybe redownload it to be sure the b3.sql file wasn't corrupted in the download?

[joefhp]

I found it, let me try again

Are you using B3 version 1.4.0? If so, maybe redownload it to be sure the b3.sql file wasn't corrupted in the download?

[joefhp]

Still getting failed on conencting to DB. Get the welcome message in server, but thats it. Lost...

I found it, let me try again

[GrossKopf]

Replied in your other post. http://www.bigbrotherbot.net/forums/installation-support/b3-installation-issue/

[joefhp]

I dont think thats my post  LOL

Replied in your other post. http://www.bigbrotherbot.net/forums/installation-support/b3-installation-issue/

[GrossKopf]

Oops, glanced at the name and saw the J but missed that it was a different person!

[Witch]

Did u check all privileges for DB user u made?