rendered paste bodyusing System;
using System.Collections.Generic;
using System.Text;
using System.Text.RegularExpressions;
using System.Data.Common;
using System.Data;
using AoLib.Utils;
using MySql.Data.MySqlClient;
using SQLHelper;
using HelpBot;
namespace VhaBot.Plugins
{
public class HelpBotStorePlugin : PluginBase
{
private MySqlConnection conn;
private string StoreSlave = "helpstore";
public HelpBotStorePlugin()
{
this.Settings.Name = "HelpBot Store Plugin";
this.Settings.InternalName = "HelpBotStorePlugin";
this.Settings.Version = 1;
this.Settings.Author = "Daniel Eriksson";
this.Settings.RegisterCommand("store", UserLevel.Guest);
this.Settings.RegisterCommand("<a href=\"itemref://", UserLevel.Guest);
this.Settings.RegisterCommand("store", UserLevel.Guest);
this.Settings.RegisterCommand("store clear", UserLevel.Guest);
this.Settings.RegisterCommandAlias("store delete", "store clear");
this.Settings.RegisterCommandAlias("store del", "store clear");
this.Settings.RegisterCommand("store join", UserLevel.Guest);
this.Settings.RegisterCommand("store kick", UserLevel.Leader);
this.Settings.RegisterCommand("store leave", UserLevel.Guest);
this.Settings.RegisterCommand("store kick all", UserLevel.Guest);
this.Settings.RegisterCommand("store invite", UserLevel.Leader);
this.Settings.RegisterCommand("store last", UserLevel.Guest);
this.Settings.RegisterCommand("store items", UserLevel.Guest);
}
/// <summary>
/// Syncs local DB with Remote DB.
/// </summary>
private string GetLastItems()
{
string message = "";
try
{
conn = new MySqlConnection(HelpBotSettings.MySQLConnectString);
conn.Open();
DataRowCollection drc = SQL.Select("SELECT ", conn);
foreach (DataRow dr in drc)
{
}
}
catch (Exception ex)
{
Bot.Debug("Can't connect to database: "+ ex.ToString());
message = "Could not connect to the HelpBot Store database...";
}
finally
{
conn.Dispose();
conn.Close();
}
return message;
}
public override void OnInstall()
{
}
public override void OnUninstall()
{
}
public override void OnLoad()
{
Bot.SlaveEvents.PrivateChannelMessageEvent += new PrivateChannelMessageSlaveHandler(SlaveEvents_PrivateChannelMessageEvent);
}
void SlaveEvents_PrivateChannelMessageEvent(BotShell sender, SlaveArgs slave, PrivateChannelMessageArgs e)
{
Bot.Debug(slave.Slave.ToLower() + " - " + slave.SlaveID + " - " + e.Channel.ToLower());
if (slave.Slave.ToLower() == StoreSlave)
{
Bot.SendPrivateMessage("Iriphatz", String.Format("Well screw you to :D - {0}", slave.Slave));
}
// Bot.SendPrivateChannelMessage(slave.SlaveID, String.Format("Well screw you to :D - {0}", slave.Slave));
}
public override void OnUnload()
{
if (conn != null)
if (conn.State != ConnectionState.Closed)
conn.Close();
Bot.SlaveEvents.PrivateChannelMessageEvent -= new PrivateChannelMessageSlaveHandler(SlaveEvents_PrivateChannelMessageEvent);
}
public override void OnCommand(BotShell sender, CommandArgs e)
{
switch (e.Command)
{
case "<a href=\"itemref://":
/*
*
$itemname = html_entity_decode($itemname);
$itemname = mysql_escape_string($itemname);
$mySQLtablename = "helpbotstore";
$connection = mysql_connect($mySQLhostname, $mySQLusername, $mySQLpassword) or die(mysql_error());
mysql_select_db($mySQLdatabase) or die(mysql_error());
$query = "INSERT INTO `$mySQLtablename` ( `id` , `lowid` , `highid` , `ql` , `itemdesc` ,
`owner` , `entrydate` ) VALUES ('', '$lowID', '$highID', '$ql', '$itemname', '$sender', NOW( ))";
$result = mysql_query($query, $connection) or die(mysql_error());
mysql_close($connection);
*/
break;
case "store":
/* if ($total_number_of_items>1 && $guildchattell==0)
{
$mySQLtablename = "helpbotstore";
$connection = mysql_connect($mySQLhostname, $mySQLusername, $mySQLpassword) or die(mysql_error());
mysql_select_db($mySQLdatabase) or die(mysql_error());
$count = mysql_fetch_array(mysql_db_query($mySQLdatabase, "SELECT count(*) FROM `$mySQLtablename` WHERE
`owner`='$sender'", $connection)) or die(mysql_error());;
mysql_close($connection);
$reply="$total_number_of_items items added, ".$count[0]." total. To see them, do /tell $myname items";
send_message($sender,$reply,"\0",$guildchattell);
}
return;
*/
break;
case "store join":
if (e.FromSlave == true)
{
if (e.SlaveArgs.Slave.ToLower() == StoreSlave)
{
Bot.SendReply(e, "Inviting you to the Store Channel...");
Bot.PrivateChannel.Invite(e.SenderID, e.SlaveArgs.SlaveID);
}
}
break;
case "store invite":
if (e.FromSlave == true)
{
if (e.SlaveArgs.Slave.ToLower() == StoreSlave)
{
if (e.Args.Length == 1)
{
Bot.SendReply(e, String.Format("Inviting to {0} the Store Channel...", Bot.UppercaseFirst(e.Args[0])));
Bot.SendPrivateMessage(e.Args[0], String.Format("You got invited to the Store Channel by {0}", Bot.UppercaseFirst(e.Sender)));
Bot.PrivateChannel.Invite(e.Args[0], e.SlaveArgs.SlaveID);
}
else
{
Bot.SendReply(e, "Who should I invite to the Store channel? Syntax: store invite [name]");
}
}
}
break;
case "store leave":
if (e.FromSlave == true)
{
if (e.SlaveArgs.Slave.ToLower() == StoreSlave)
{
Bot.SendReply(e, "Kicking you from Store Channel...");
Bot.PrivateChannel.Kick(e.SenderID, e.SlaveArgs.SlaveID);
}
}
break;
case "store kick":
if (e.Args.Length == 1)
{
if (e.FromSlave == true)
{
if (e.SlaveArgs.Slave.ToLower() == StoreSlave)
{
Bot.SendReply(e, String.Format("Kicking {0} from the Store Channel...", Bot.UppercaseFirst(e.Args[0])));
Bot.PrivateChannel.Kick(e.Args[0], e.SlaveArgs.SlaveID);
}
}
}
else
{
Bot.SendReply(e, "Who should I kick from the Store channel? Syntax: store kick [name]");
}
break;
case "store kick all":
if (e.FromSlave == true)
{
if (e.SlaveArgs.Slave.ToLower() == StoreSlave)
{
Bot.SendReply(e, "Kicking all from the Store Channel...");
Bot.PrivateChannel.KickAll(e.SlaveArgs.SlaveID);
}
}
break;
case "store clear":
/*
* if ($word1=="delete" && $word2=="" && $word3=="")
{
$connection = mysql_connect($mySQLhostname, $mySQLusername, $mySQLpassword) or die(mysql_error());
mysql_select_db($mySQLdatabase) or die(mysql_error());
$query = "DELETE FROM `helpbotstore` WHERE `owner` = '$sender'";
$result = mysql_query($query,$connection) or die(mysql_error());
mysql_close($connection);
$reply="All your items are gone now. To see your items, do /tell $myname items";
}
*/
break;
case "store items":
/*
* if ($word1=="items" && $word3=="")
{
$nametolookup = ucfirst(ereg_replace('[^a-z0-9]',"",$word2));
if (strlen($nametolookup)<4)
$nametolookup = $sender;
$mySQLtablename = "helpbotstore";
$connection = mysql_connect($mySQLhostname, $mySQLusername, $mySQLpassword) or die(mysql_error());
mysql_select_db($mySQLdatabase) or die(mysql_error());
$count = mysql_fetch_array(mysql_db_query($mySQLdatabase, "SELECT count(*) FROM `$mySQLtablename` WHERE `owner`='$nametolooku$
$query = "SELECT * FROM `$mySQLtablename` WHERE `owner` = '$nametolookup' ORDER BY `id` DESC LIMIT 0,25";
$result = mysql_query($query, $connection) or die(mysql_error());
$i=0;
$window_contents="$nametolookup's 25 most recent items:\nVisit the Helpbot Store: #L \"http://helpbot.vhabot.net/\" \"/start $
while($myrow = mysql_fetch_array($result))
{
$i++;
$helpbotstore_lowid = $myrow["lowid" ];
$helpbotstore_highid = $myrow["highid" ];
$helpbotstore_ql = $myrow["ql" ];
$helpbotstore_itemdesc = $myrow["itemdesc" ];
if (strlen($window_contents)+400<$maximum_outgoing_size)
$window_contents.="</font><font color=#FBFB40> #L \"/make\" \"/tell $myname make $helpbotstore_lowid $helpbot$
}
mysql_close($connection);
$reply = "you have ".chr(17).$count[0]." items".chr(18)." for $nametolookup";
if ($count[0]>25)
$window_contents .= "</font><font color=#FBFB40> visit the Helpbot Store to see the rest of the items\n";
$window_contents .= "\n\n</font><font color=#FBFB40> NOTE: you can add many items in </font><font color=#F96096> one </font>$
send_message($sender,$reply,$window_contents,$guildchattell);
return;
}
*/
break;
case "store":
break;
}
}
}
}