Server Help

Light Hazard · Posted: 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.
_________________
-Owner of Lethal Weapon
-Super Hacker

Solo Ace · Posted: 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 · Posted: Sun Aug 01, 2004 5:45 am Post subject:

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

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

Uh, maybe.

50% Packetloss · Posted: 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 · Posted: 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.
_________________
This help is informational only. No representation is made or warranty given as to its content. User assumes all risk of use. Cyan~Fire assumes no responsibility for any loss or delay resulting from such use.
Wise men STILL seek Him.

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

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

SQL isn't that hard either, if I might add.
_________________
Performance is often the art of cheating carefully. - James Gosling

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

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

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

Very carefully

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

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

so how do i use MySQL with that duel plugin?

Smong · Posted: 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 · Posted: 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 · Novice Gender: Joined: Feb 17 2004 Posts: 55 Offline

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 · Posted: 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 · Novice Gender: Joined: Feb 17 2004 Posts: 55 Offline

thanks = it works?

Light Hazard · Posted: 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 · Novice Joined: Aug 27 2003 Posts: 70 Offline

Underlord · Novice Gender: Joined: Feb 17 2004 Posts: 55 Offline

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

blackmoon · Novice Joined: Aug 27 2003 Posts: 70 Offline

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 · Novice Gender: Joined: Feb 17 2004 Posts: 55 Offline

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

Dead! · Guest Offline

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 · Posted: 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 · Novice Joined: Aug 27 2003 Posts: 70 Offline

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.