TP/Recall/DC char by sql or using some crazy opcodes...

[szokersonik]

Hey.

I dont even know how to begin this lol.

Okay whatever. The thing is simple but not so simple:

I decided to make Limit "+" on my server.

1.Im using this(this only one of few conditions)

 Spoiler

/*IF (@Operation = 90 AND (@strDesc ='[M] [Opt: +10]'))
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = 8 WHERE Serial64 = @erial
END */

and its half working. As we know full effect is after TP char.
How to do that then without external program?
I tryed few things like executing other procedures, like adding new params to elixirs , after conditions=true but this is not working. Char can be even DC after conditions = true, any idea how? I know i can do lower alch rates but is not my point

2. Im totly begginer in "c" lang and at opcodes and other similar things. So i decied to downloads some sources and start to learn with that I download "Notice" Source code, and i started do anything with that. Im using edxloader to get opcodes, After 2 days im able get uniques, recall chars etc and its working this example recalling char(i just have to write nick). A button executing this function

 Spoiler

string text = this.textBox2.Text;
Packet packet = new Packet(0x7010);

packet.WriteUInt8((byte)0x11);
packet.WriteUInt8((byte)0);

packet.WriteAscii(text);
this.t1.Stop();
Agent.Send(packet);

And the question is , how does it look like i mean code to recall char after exampled Alchemy succes "+10". I know that "c" must get infos from dbo._LogEventItem and read them i know that there must be conditions in "c" but on that stage where im begining my adventure with "c" im not able to make it correct or event build this somehow.

Thx for solution/tips/answers !

[xxnukertube]

i have DC system
i sell for just 30 $

[szokersonik]

Originally Posted by xxnukertube

i have DC system
i sell for just 30 $

Just make a simple wideo and put it here, then it will be more easier to us/me to make right choice:


hints: dont forget to run sro client in window. Thank you for cooperation.

[xxnukertube]

[xxnukertube]

^^