"Simplified" [Job/FreePVP Kill] Fetching (vSRO 1.88) - Now works with NoticeWriter!

[B1QB0SS]

o.O you can decompile it easy!

[P0kemonMast]

o.O you can decompile it easy!

i tried , no success. Errors everywhere in the source

[Witchy Moo]

o.O you can decompile it easy!

No you cannot.

Seems like it wont work on a windowx xp 64b sp2 system. Tried on a random windows 7 machine and worked fine. Anyway you can release the source ? or pm me it ? To compile on this windows xp machine.

I took the source from this page.

To make it work with this Kill Fetching, Edit Form1.cs

Find these lines:

Spoiler:

string query = "SELECT top 1* from PlusNotice where sent = '0' ORDER BY date";

                        while (reader.Read())
                        {
                            mesaj.Text = (string)reader["message"];
                        }

using (SqlCommand cmd = new SqlCommand("update PlusNotice set sent = '1' where message = @mesaj", conn))

Change to these:

Spoiler:

string query = "SELECT TOP 1 * FROM _LogEventPVP WHERE isSent = 0 ORDER BY EventTime ASC";

                        while (reader.Read())
                        {
                            mesaj.Text = (string)reader["strDesc"];
                        }

using (SqlCommand cmd = new SqlCommand("UPDATE _LogEventPVP SET isSent = 1 WHERE strDesc = @mesaj", conn))

Build, and you're good to go. ;)

--
Another note, the original source was came with Visual Studio 2012 environment (I use VS2010), If you happen to have VS2010 also, you will not be able to open the project. But, you can change the environment in the .sln file before opening and converting. As follows:

Edit Notice writer (vSro).sln
Find these lines:

Spoiler:

Format Version 12.00

# Visual Studio 2012

Change to this:

Spoiler:

Format Version 10.00

# Visual Studio 2010

Save the Solution file, and now you'll be able to open using VS2010

Good luck

[B1QB0SS]

what about this .net problem?! it work for 3 times and wont work again!!

So Notice Writing For All Plus Values

How To Limit It ?!

i want it From 16 only

[Witchy Moo]

what about this .net problem?! it work for 3 times and wont work again!!

So Notice Writing For All Plus Values

How To Limit It ?!

i want it From 16 only

If iit once worked means it will work, check if the "isSent" is already "1" in your db, if it's "1", then notice won't be sent.

[B1QB0SS]

i want the notice system to send +16 and high not +1 and +2 etc

[Witchy Moo]

i want the notice system to send +16 and high not +1 and +2 etc

Well, this is a "Kill Fetching" thread, not PlusNotice. I think you parked at the wrong tree

[P0kemonMast]

Well I modified all the lines you told me to on form1. Here is my result.


Windows 7: - VS 2012 compiles it fine , VS 2010 also compiles it fine following you're steps for 2010
Windows xp - VS 2012 cant be installed on (im screwed in that part) , VS 2010 does not compile.

Problem is in XP. Windows 7 compiles fine , but in xp it does not. With xp it gives me a problem

Error	1	Invalid Resx file. The parameter is incorrect Line 1511, position 5.	C:\Documents and Settings\Administrator\Desktop\sources\Clientless_login\Form1.resx	1511	5	Notice writer (vSro)

the only thing in that line of the form1.resx is

</value>
  </data>
</root>

I dont see what could possibly be wrong there ? Except for the fact that it does not like windows xp lol. Im not a programmer especially in VS or C# ,so only way i can see me using this program is by switching my dev to a windows 7 machine instead of xp. Great >.>

[Witchy Moo]

... Im not a programmer especially in VS or C#...

we're both alike.

Btw, about your problem which happens to be in relation with Form1.resx file, it contains the icon, perhaps you wanna delete the Form1.resx file from Solution Explorer and recompile. I did try removing it and it still works, but I wouldn't know at your end, since I still using W7 :P, but, we wouldn't know until we try, right?

[B1QB0SS]

Well, this is a "Kill Fetching" thread, not PlusNotice. I think you parked at the wrong tree

Thanks For Telling me -.-

My Problem Fixed Btw :)



It Works! Both Systems Working ! Any One Want Help Just Add Me On Skype : gold.fish530

[Witchy Moo]

Thanks For Telling me -.-

My Problem Fixed Btw :)



It Works! Both Systems Working ! Any One Want Help Just Add Me On Skype : gold.fish530

Good for you, congratulations. I have a newbie question, did you made up that "Chinese (SHIELD) (B)" name? cause I still can't figure out how to get real item names from textdata_object to the notice unless we input all those item names into another table.

[B1QB0SS]

Good for you, congratulations. I have a newbie question, did you made up that "Chinese (SHIELD) (B)" name? cause I still can't figure out how to get real item names from textdata_object to the notice unless we input all those item names into another table.

huh I just added ObjName128 To _refObjcommon Items COdes!

About getting Reall Item Names Not A Problem! i'll try TO Add them All To New Table!

[Witchy Moo]

huh I just added ObjName128 To _refObjcommon Items COdes!

stupid me why wouldn't i think of that?... thanks for info.

[Crue]

to get Weapons name from textdata_equip&skill

[B1QB0SS]

stupid me why wouldn't i think of that?... thanks for info.

hmm Where i can Find Like Button?