Server Help :: View topic - Prize3.dll (mysql prize plugin)

Server Help

Bot Questions - Prize3.dll (mysql prize plugin)

blackmoon - Sun Aug 15, 2004 4:30 am
Post subject: Prize3.dll (mysql prize plugin)

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!

Solo Ace - 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 - 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.. :/

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

CypherJF wrote:

You can figure this out by even opening the dll in notepad and searching for "SQL"; although not recommended.

Heh, I tried that, didn't look hard enough though.

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

heh

blackmoon - Mon Aug 16, 2004 3:56 am
Post subject:

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 - 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.

Anonymous - Mon Aug 16, 2004 10:06 am
Post subject:

You gonna share that plugin to the rest of us?

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

Does it not like spaces in the name?

blackmoon - Mon Aug 16, 2004 2:11 pm
Post subject:

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 - 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 - Tue Aug 17, 2004 6:21 am
Post subject:

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

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

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

[D1st0rt flaming comment erased]

Previous post updated.

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

Solo Ace wrote:

I guess it's just bugged

it is bugged yea... i was talking to splody not too long ago bout it he tried to fix it there was a typo or something in it :S

but he sent to 50% Packetloss to compile and 50 sent it to me and i tested it and it didnt work still so.. i dunno if hes ever gonna fix it

Solo Ace wrote:

harass Explody Thingy in game

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

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

ExplodyThingy - 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.

blackmoon - Fri Aug 20, 2004 5:15 pm
Post subject:

ExplodyThingy wrote:

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.

Cool.. thx... let us know when it is up.

CypherJF - 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 - Sat Aug 21, 2004 11:01 pm
Post subject:

u/l'd

blackmoon - Sun Aug 22, 2004 2:31 am
Post subject:

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??

Anonymous - Tue Aug 24, 2004 7:35 am
Post subject:

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 - Tue Aug 24, 2004 2:33 pm
Post subject:

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 - 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.