[Release] Simple bot. Someone that want it?

capasha · 2015-08-03 21:47:59

So I coded this bot to AMDs. Because he "really needs it". Which ends in doesn't want it.

Login Methods:

EverybodyEdits
Kongregate
Facebook
ArmorGAmes.

Other things.

Banlist with reason (MySQL)
Adminlist (MySQL)
WinList (MySQL)
Adds a sign there it says how many time YOU have won. When you touch it at a certain position.
Players win when they touch the crown. A new round will start after that.

Commands
!newround - Starts a new round.
!exit - Makes the bot quit.
!name <title> - Changes the room-title to title.
!admin <nick> - Adds nick to the adminlist.
!kick <nick> [reason] - Kicks nick from the room.
!ban <nick> [reason] - Bans nick from the room.
!edit <nick> - Gives nick edit rights.
!redit <nick> - Removes edit rights from nick.
!score [nick] - Shows the score for nick, or you.
!cmds - Shows the commands.

Before downloading and run the bot, like you think its just connect and have fun. Which it's not.
You need to get a MySQL database before you do anything else. Go to http://capasha.com/capasha/mysqlhowto/
And start follow the tutorial. You need to add Admins and Winners too.

Added the download for the bot here: http://www.mediafire.com/download/vmnf2 … nubbot.zip (Don't forget to use MySQL database with ban, admins and winners)
Added the sourcecode for download here: http://www.mediafire.com/download/vsdem … source.zip

#### MySQL ####

Table: Bans
Column: Name - (CHAR)
Column1: Reason - (CHAR)

Table: Admins
Column: Name - (CHAR)

Table: Winners
Column: Name - (CHAR)
Column1: Wins - (INT)

Ok. So i did a tutorial how to use MySQL and how to use it in C#.

How to setup MySQL Database for free: http://capasha.com/capasha/mysqlhowto/
How to read, update, delete the MySQL data: http://pastebin.com/KVbtzYfS

If anyone want it. Just write it in the thread. I will give out the sourcecode too.

Edit: Big thanks to EEJesse for the support on MySQL and wins saving/loading.

Hexagon · 2015-08-04 00:04:39

I'd like to have this bot. I'm interested in how the MySQL bits work, because I don't have a server installed at the moment.

Kirby · 2015-08-04 02:18:32

Wow I made a world that needs this exact bot. May I have a copy?

SmittyW · 2015-08-04 02:28:25

Sure, I'm interested. Are you going to edit it in the main post?

Xfrogman43 · 2015-08-04 02:32:47

Sure why not

Anch · 2015-08-04 03:31:23

I made the same bot for AMDS and he didn't use it.

SirJosh3917 · 2015-08-04 03:58:13

just host the link for downloading (source code included) ^-^

Xfrogman43 · 2015-08-04 04:45:42

anch159 wrote:

I made the same bot for AMDS and he didn't use it.

That's why I stopped making bots for people... that and I'm lazy.

rold1212 · 2015-08-04 05:29:39

same thing here, I'm definitely interested on how MySQL works with C#..

capasha · 2015-08-04 21:14:27

Ok. So i did a tutorial how to use MySQL and how to use it in C#.
The bot with source is coming tomorrow.

How to setup MySQL Database for free: http://capasha.com/capasha/mysqlhowto/
How to read, update, delete the MySQL data: http://pastebin.com/KVbtzYfS

Xfrogman43

capasha · 2015-08-04 21:23:40

anch159 wrote:

I made the same bot for AMDS and he didn't use it.

Yeah. I don't really have mood to make anything to him anymore.

SmittyW · 2015-08-05 16:05:56

capasha wrote:

Ok. So i did a tutorial how to use MySQL and how to use it in C#.
The bot with source is coming tomorrow.
How to setup MySQL Database for free: http://capasha.com/capasha/mysqlhowto/
How to read, update, delete the MySQL data: http://pastebin.com/KVbtzYfS

Thank you so much. This tutorial is great!
also give my thanks to jesse.

mrjawapa · 2015-08-05 18:01:21

I'll take it, if you don't mind.

ParadoxInTheVoid · 2015-08-05 18:06:27

It'd be cool to take a look at the MySQL, I could learn something from that.
EDIT: I also would like the bot.

capasha · 2015-08-07 22:27:39

Added the bot to the first post.

Hexagon · 2015-08-07 23:02:30

Using new MySqlConnection() and close() is hard on the ol' server for every request, but that works though.

Cyral · 2015-08-12 23:45:49

If you don't need an external DB, you can also download something like XAMPP which will provide phpMyAdmin and a MySQL server. One of the neat things about databases in C# is since all the vendor specific classes extend from DbConnection, DbCommand, etc, you can write methods which can use any DB provider depending on the connection string. (Which means you can embed SQLite into bots, and have an option to also connect to MySQL)

Hexagon

Official Everybody Edits Forums

#1 2015-08-03 21:47:59, last edited by capasha (2015-08-11 20:57:06)

[Release] Simple bot. Someone that want it?

#2 2015-08-04 00:04:39, last edited by Hexagon (2015-08-04 00:11:14)

Re: [Release] Simple bot. Someone that want it?

#3 2015-08-04 02:18:32

Re: [Release] Simple bot. Someone that want it?

#4 2015-08-04 02:28:25

Re: [Release] Simple bot. Someone that want it?

#5 2015-08-04 02:32:47

Re: [Release] Simple bot. Someone that want it?

#6 2015-08-04 03:31:23

Re: [Release] Simple bot. Someone that want it?

#7 2015-08-04 03:58:13

Re: [Release] Simple bot. Someone that want it?

#8 2015-08-04 04:45:42

Re: [Release] Simple bot. Someone that want it?

#9 2015-08-04 05:29:39

Re: [Release] Simple bot. Someone that want it?

#10 2015-08-04 21:14:27

Re: [Release] Simple bot. Someone that want it?

#11 2015-08-04 21:23:40

Re: [Release] Simple bot. Someone that want it?

#12 2015-08-05 16:05:56

Re: [Release] Simple bot. Someone that want it?

#13 2015-08-05 18:01:21

Re: [Release] Simple bot. Someone that want it?

#14 2015-08-05 18:06:27, last edited by ParadoxInTheVoid (2015-08-05 18:06:58)

Re: [Release] Simple bot. Someone that want it?

#15 2015-08-07 22:27:39, last edited by capasha (2015-08-07 22:28:08)

Re: [Release] Simple bot. Someone that want it?

#16 2015-08-07 23:02:30

Re: [Release] Simple bot. Someone that want it?

#17 2015-08-12 23:45:49

Re: [Release] Simple bot. Someone that want it?

Board footer