warsql

Dragoneye · Post by **Dragoneye** » Fri May 13, 2005 5:13 pm

me and z0 modifyed one script to war/news add/del script for eggdrop
it uses mysql database wich contains the information.
as far as i know my clan (farmitiimi) and z0's clan(jÄgarna)
are the only one who are using this script.
i.e. u can type !addwar team1 map1 1 1 map2 2 2 "gg nice match"
map1= map1 name like deepcanyon and 1 1 is the map score
then the bot will say:
privchannel [addwar] 1 war at database.
privchannel yourtag vs team1 3-3
pubchannel yourtag vs team1 3-3 , read more info at http://yourclanpage.com
also if u wanna u can make the bot change topic to
"http://yourclanpage.com - last war: team1 3-3"

then u can also view it with !lastwar command
and the bot will say:
[lastwar] id #1 * vs team1 * score 3-3 * maps map1,map2 report:gg nice match

more commands/info u can get by typing !help @ your channel where the bot is.

if ppl want this plz msg me ( Dragoneye^ @ qnet #farmitiimi), the packet contains default page(by uitto) & tcl script
tcl script needs fbsql.so wich comes in the packet but not might work in your eggdrop, more info @ http://www.fastbase.co.nz/fbsql/index.html
sry bad english / typo

n99 · Post by **n99** » Fri May 13, 2005 5:32 pm

Good initiative, dunno if you like the idea, but unless u intend to add alot more features I think it's a good idea to approach one of the big aq2 bot guys out here, for instance z0rbot, maybe this can offer this as an extended service, or even a fully integrated one...

sajh · Post by **sajh** » Fri May 13, 2005 10:37 pm

jep, quite useful script.. developed one of these about 1 year ago.. but noone wanted to use it

Hawk · Post by **Hawk** » Sat May 14, 2005 4:54 am

might be that it's to hard to set up for alot of people, requiring a mysql server and a linux box

Post by **Haudrauf** » Sat May 14, 2005 5:27 am

n99: It looks like a script for internal clan usage, not like it's about distributing clanwar-info to other channels except your own public clanchannel.

Right Dragoneye?

Dragoneye · Post by **Dragoneye** » Sat May 14, 2005 6:02 am

Haudrauf wrote:n99: It looks like a script for internal clan usage, not like it's about distributing clanwar-info to other channels except your own public clanchannel.

Right Dragoneye?

yeap only your own clan public/private channel's

Post by **imeiz** » Sat May 14, 2005 6:02 am

i think that with it you can add clanwars on your pages,

Dragoneye wrote:the packet contains default page(by uitto) & tcl script

Post by **Clown** » Sat May 14, 2005 7:57 am

And remind me why it must be private again?

Dragoneye · Post by **Dragoneye** » Sat May 14, 2005 8:24 am

Clown wrote:And remind me why it must be private again?

well u can turn it off if u wanna, but the privmsg is for u to c if your command worked & u writed it right.

Dragoneye · Post by **Dragoneye** » Sat Nov 05, 2005 2:46 pm

little update but im sure that no1 cares...

Commands for Farmitiimi members:
!disconnect : Disconnects from the database.
!addwar : Add's a cw type !addwar for more info.
!lastwar : Shows last played war.
!warstats : Shows how many cw's in database.
!delwar : Deletes war from the database type !delwar for more info.
!calc : Simple calculator.
!help : This file
!addnews : Add's a new news to the database.
!delnews : Removes selected news from the database.
!lastnews : Displays last added news to channel.
!newsstats : Displays how many news in database.
!addtag : Add's clan tag to database.
!say : Bot writes a message that you want

Commands for admins:
!join : Bot joins to channel.
!part : Bot leaves from the channel.
!restart : Bot reboots.
!rehash : Bot rehashes himself.

Commands for normal user:
!apua : Try it!
!farm : Displays players who are on our server
!farmers : Search Farmers from aq2-servers
!kuakettaja : Wizdom words
!readme : Sends this helpfile
!addme : If you are interested to join our group use this command and fill the format.
!challenge : If your clan wanna challenge us use this command.

tyldis · Post by **tyldis** » Sun Nov 06, 2005 4:57 am

Cool project! I'll see if I get around to modifying it for fubar's site one day.

Dragoneye · Post by **Dragoneye** » Sat Aug 12, 2006 7:48 am

*UPDATE*

Commands for Farmitiimi members:
!addwar : Add's a cw type !addwar for more info.
!delwar : Deletes war from the database type !delwar for more info.
!addnews : Add's a new news to the database.
!delnews : Removes selected news from the database.
!lastnews : Displays last added news to channel.
!lastwar : Shows last clanwar
!addtag : Add's selected tag
!deltag : Deletes selected tag
!taglist : Shows taglist
!tagstats : Shows how many tags & info is in the database
!warstats : Shows how many games have clan played
!newsstats : Shows how many news does bot have in the database
!cws : Shows clanwars against selected opponent
!memberlist : Shows memberlist
!memberinfo : Shows info from selected member
!say : Bot writes a message that you want
!3on3 : Add's 3on3 matchfind
!4on4 : Add's 4on4 matchfind
!kb : Kick and bans selected guy
!calc : Simple calculator.
!help : This file
!rcon : Rcon commands for maggies express 1/2.
!ws : Warannounce to server, when looking for cw. (need Gsbot/Z0rbot)

Master commands
!addmember : Add's new member
!delmember : Deletes selected member
!memberstatus : Changes memberstatus
!part : Part selected channel
!join : Join Selected channel
!rehash : Bot rehashes
!restart : Bot restats

Private commands.
!addinfo : Every member can add some personalinfo to the pages using this command

Commands for normal user:
!apua : Try it!
!farm : Displays players who are on our server
!farmers : Search Farmers from aq2-servers
!kuakettaja : Wizdom words
!readme : Sends this helpfile

z0 · Post by z0 » Mon Sep 11, 2006 7:24 am

great that u still develop this thingie dragon

will try it out again, nice to have, too bad hawks webserver is offline so i cant use it anymore.