Auto pm ?!

[Maddona]

i did every thing good at tables in my db and working fine in tables ? but in my nothing send ?! i dont know the wrong from my program ?! or my? produce ?

here table


here u can check one of my producers

 Spoiler

IF (@Operation = 41 AND @ItemRefID = 67138) ------ 100 Silk Scroll
BEGIN
DECLARE @JID int,
@Silk int;

SET @Silk = 100
SELECT @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @Silk where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID, @Silk, 0, 0
insert into iLegend_Tool.._SendPrivateChat ([Service],[Target],[Chat],[Date])
values (0,@lkcharname,'Congratulations You Got 100 Silk',getdate())
END

tell me if there any wrong? in my produce please ? guys

[​Exo]

Your tool doesn't work xD

[Snow*]

^that is correct.

Maybe the bot query got something wrong?

here is something form a released tool in e*pvp

        public static void Auto_PM()
        {
            try
            {
                while (true)
                {
                   
                    using (SqlDataReader r = new SqlCommand("USE iLegend_Tool select * from _SendPrivateChat where Service = 0", sqlCon.con).ExecuteReader())
                    {
                        while (r.Read())
                        {
                            string Message = Convert.ToString(r["Message"]);
                            SendNotice(Message);
                            sqlCon.exec("USE iLegend_Tool update _SendPrivateChat set Service = 1 where Message = '" + Message + "'");
                        }
                    }
                    Thread.Sleep(1000);
                }
            }
            catch (Exception ex) { Console.WriteLine("{0}", ex.Message); }
        }

maybe it will help you a bit

[Maddona]

Originally Posted by ​Exo

Your tool doesn't work xD

there is any program ?! working well ?! can u tell me ?!