Server Help

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

Okay... I am using Explody Thingy's prize3.dll plugin that uses mysql. I have setup my database, however, it says to configure your CFG to your db. Is it a .cfg or .ini file? and..... does anyone have one I can use as a template? it doesn't have one and I have no clue on how to set it up! heeeelp!
_________________
No, that was just a love tap... here's the bitch slap!

-Pimp Daddy Black

Solo Ace · Posted: Sun Aug 15, 2004 5:07 am Post subject:

To splody: Where did the libmysql.dll go?
Doesn't it require it?

And yeah, I have no idea how it's supposed to find out where the MySQL settings of it are, either.

CypherJF · Posted: Sun Aug 15, 2004 6:24 am Post subject:

It requires libmysql.dll, you can grab this from practically anywhere; and I believe the INI filename is, sql.ini; with the:
[sql]
Name=
Host=
Port=3306
User=
Pass=

Am probably wrong about it though; You can figure this out by even opening the dll in notepad and searching for "SQL" (although not recommended).

I had helped someone else out who was trying to use this, and yeah; I thought explody said he included the new files; you should also talk to him for a new possible version, that someone said he had.. :/
_________________
Performance is often the art of cheating carefully. - James Gosling

Solo Ace · Posted: Sun Aug 15, 2004 6:28 am Post subject:

CypherJF · Posted: Sun Aug 15, 2004 6:29 am Post subject:

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

Okies.... I got some good info from this thread and from another thread I posted in about the Duel plugin... so I got it to connect to my db... I setup my db like the directions said.... so now when I do a !help prizeadd to the bot, it gives me this:

FE_Pub_Bot> !prizeadd [-s=<#>[,<#>...]] [-b=<#>] [-x=mm:dd:yyyy] <Name>
FE_Pub_Bot> -s=<#>[,<#>] Add specials. ex: -s=10 -s=10,15,20.
FE_Pub_Bot> -b=<#> Add bounty. ex: -s=10 -s=10000.
FE_Pub_Bot> -x=<##:##:####> Set expiration. ex: -x=01:01:2009. UNIMPLEMENTED

Sooooo.. I do:

/!prizeadd -b=1000 Blackmoon 2.0

And I get:

FE_Pub_Bot> Error: Missing recipient name.

Anyone help me out with this? possibly??

Solo Ace · Posted: Mon Aug 16, 2004 7:06 am Post subject:

I guess it's just bugged, harass Explody Thingy in game.

You might want to try checking if you provided a correct name.

HELP! · Guest Offline

You gonna share that plugin to the rest of us?

D1st0rt · Posted: Mon Aug 16, 2004 10:35 am Post subject:

Does it not like spaces in the name?
_________________

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

I've tried it without spaces and with the other sysop Ghost-Rider. Still no go.

Also, you can get the plugin from catid.ssihosting.com and go into Explody Thingy's section. That is where I got it from.

Solo Ace · Posted: Tue Aug 17, 2004 1:02 am Post subject:

Haha, a section.

YEAH SPLODY, YOUR PAGES ARE JUST A SECTION OF CATID'S.

NOTE FOR D1ST0RT:
</JOKE></SARCASM>

D1st0rt · Posted: Tue Aug 17, 2004 6:21 am Post subject:

just cuz theres a link to his site from mervbot.com...

Solo Ace · Posted: Tue Aug 17, 2004 6:33 am Post subject:

Yeah I know, but ... /me sighs.

[D1st0rt flaming comment erased]

Previous post updated.

Deadly · Posted: Thu Aug 19, 2004 7:09 pm Post subject:

D1st0rt · Posted: Fri Aug 20, 2004 3:42 pm Post subject:

oooh somebody gettin angry. That was directed more at blackmoon anyways

ExplodyThingy · Posted: Fri Aug 20, 2004 4:16 pm Post subject:

The zip is old. Its fixed now, Ill upload it tonight probably. I just put a ! operator on the wrong line, and didnt package the cfg or ini or whatever i used. Oh and I use cfg and ini interchangably.
_________________
There are no stupid question, but there are many inquisitive idiots.
Loot

Dr Brain> I hate clean air and clean water. I'm a member of Evil Conservitive Industries

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

CypherJF · Posted: Sat Aug 21, 2004 12:55 am Post subject:

I had either e-mailed explody or ?messaged him about the missing ini/cfg a long time ago; but obviously the msg never got through lol.. I'm glad that it's being updated, etc etc.

ExplodyThingy · Posted: Sat Aug 21, 2004 11:01 pm Post subject:

u/l'd

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

Explody... you are the man!

however.... it says it has connected to my db and when I do !prizeadd it says the prize has been added.... but.....

it says... unknown column in 'specials' in 'field list'. ???? any idea? the old readme text with the table setups says that specials must be a 32bit value... how do you set that??

Explody · Guest Offline

Dont remember, I used MySQLL CC and played with a GUI. Its should be an int size 32, or bigint or whatever mysql calls it. And try naming it Specials not specials.

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

I renamed 'specials' to 'special' and it seemed to work.... now... I cannot set the expiration date (I believe it is unimplemented, right?)... and players cannot !prizelist or !prizeme <#> to the bot.

ExplodyThingy · Posted: Fri Aug 27, 2004 3:36 pm Post subject:

Expiration dates dont work because Im lazy about parsing things.

Use !prizeview Im lazy about updating help and docs that come with things. Dont use the <>s or quotes or anything else either, just the number.