Server Help

Bot Questions - Duel Plugin

Light Hazard - Sun Aug 01, 2004 3:29 am
Post subject: Duel Plugin

I want a plugin similar to that of EG's where once you die you get warped to the safe IN the box and the bot keeps score just like EG. Only difference is, is that there are no !ch and instead players just go into corners to get warped to their respective duel boxes, incorporating the current 1v1 duel bot plugin that is in use currently.

Is it possible? If you have one, I would greatly appreciate it. I downloaded the Dueling Zone bot from mervbot.com but I have no idea how to use that stupid sql stuff. Thanks.

Solo Ace - Sun Aug 01, 2004 4:37 am
Post subject:

Stupid SQL stuff?

You're sounding like one of those "hi im too lazy to make a zone but i want one do it for me plz? k thx" people.

At least TRY to get it to work?

Bak - Sun Aug 01, 2004 5:45 am
Post subject:

what solo meant to say is why is a duel plugin using SQL?

Solo Ace - Sun Aug 01, 2004 5:49 am
Post subject:

Uh, maybe.

50% Packetloss - Sun Aug 01, 2004 7:15 am
Post subject:

catid has a duel bot on his site, it works in a similar way.
http://falcon.dnsvs.net/~gandalf4/catid/files/plugins/duel.zip

Cyan~Fire - Sun Aug 01, 2004 11:01 am
Post subject:

If you're having trouble understanding the INI (it's not SQL), IM me and I'll help you out.

Light Hazard - Sun Aug 01, 2004 12:18 pm
Post subject:

50% Packetloss wrote:

catid has a duel bot on his site, it works in a similar way.
http://falcon.dnsvs.net/~gandalf4/catid/files/plugins/duel.zip

yea that's the one that people are currently using, but I also want it to warp the players upon death and keep count

CypherJF - Sun Aug 01, 2004 8:22 pm
Post subject:

SQL isn't that hard either, if I might add.

Bak - Sun Aug 01, 2004 9:40 pm
Post subject:

how would I code for MYSQL in c/c++ cypher?

CypherJF - Sun Aug 01, 2004 10:24 pm
Post subject:

Very carefully

go check out underlord's alias plugin, it uses MySQL

Light Hazard - Tue Aug 03, 2004 12:50 pm
Post subject:

so how do i use MySQL with that duel plugin?

Smong - Wed Aug 04, 2004 1:54 pm
Post subject:

The mysql in duel is most likely for rankings. If you want to use it you'll also need a mysql server.

Light Hazard - Wed Aug 04, 2004 8:08 pm
Post subject:

okay so i have a mysql server..now when i use it, it puts peopel in line but it doesnt warp them or anything

Underlord - Wed Aug 04, 2004 10:42 pm
Post subject:

assuming you are using my Duel plugin...download latest source from here:

http://www.dzleagues.com/bots/duel/ (u need the duelsql.dll, duel.ini, dzstatbox.lvz)

if it's not warping anyone you probably didn't fill out the duel.ini correctly or the bot doesn't have correct mod/smod/sysop powers. be more specific or message me in ss.

btw posting ' I have no idea how to use that stupid sql stuff. Thanks.' isn't the greatest way to get bot help.

Light Hazard - Sat Aug 07, 2004 4:41 pm
Post subject:

geez Underlord, I didn't mean it by saying your bot sucked. i just don't like SQL. :-p thanks a lot man.

Underlord - Sat Aug 07, 2004 5:49 pm
Post subject:

thanks = it works?

Light Hazard - Sat Aug 14, 2004 7:31 pm
Post subject:

Yes, most of it works.
Now since it's MySQL, exactly how would I use it?
I am guessing the bot is there for rankings...but I dont have table.txt . Do you have a copy of it? Would I need anything else to put up these rankings on the site? It would be greatly appreciated.

You are of great help and I am deeply in your debt. Thank you.

blackmoon - Sun Aug 15, 2004 3:37 am
Post subject:

Underlord wrote:

assuming you are using my Duel plugin...download latest source from here:

http://www.dzleagues.com/bots/duel/ (u need the duelsql.dll, duel.ini, dzstatbox.lvz)

The ini says to refer to tables.txt, however, there is no tables.txt. Can you post them here or submit them to that dir? I'd like to try to set this up.

Underlord - Sun Aug 15, 2004 10:41 am
Post subject:

http://www.dzleagues.com/bots/duel/tables.txt

blackmoon - Sun Aug 15, 2004 1:44 pm
Post subject:

Thanks for the tables. Got it all set up, believe I got it all configured right, however, I have a problem. It shuts my server down by generating some errors. The mervBot console displays the following error:

MySQL Error: Access denied for user: 'davis_ssc@az.... ' <Using password: YES>

Any idea? perhaps I dont have my ini configured correctly?

Underlord - Sun Aug 15, 2004 4:59 pm
Post subject:

if you're using Cpanel X, need to setup 'Access Hosts' with IP in 'Manage Mysql'

Anonymous - Mon Aug 16, 2004 3:18 am
Post subject:

EG's duel bot doesn't use SQL, it uses a ranking system by divine.216

Infact the only bots that use sql are the public bots and a few of mine.

Solo Ace - Mon Aug 16, 2004 7:31 am
Post subject:

That's great useless info.

Anyway, just make sure the user davis_ssc's host has access to the MySQL server.

To give a user access from a host using MySQL CC:

[image link removed]

Specify the correct host in the Host field (duh), the '%' stands for all.

If you don't have access to the server's user administration ask the server administrator.

blackmoon - Mon Aug 16, 2004 9:47 am
Post subject:

Ok... I set up my ip in the Access Hosts. I know it works because I get a connect message from prize3.dll (the mysql plugin). Now... when I have two clients running and go into the duel, it errors my server and shuts it down. Maybe because I am running two clients on two computers but through a router?? Here is the error log DrWatson creates for the Mervbot or something.