Plus Auto Notice(Sample + Source)

[Comandante]

:D

http://forum.ragezone.com/f722/db-lo...lobals-934558/

System iSRO

So i'm doing something good then :)

btw if you wanna make it show only +12 you can add

if(@strdesc_seperado='12')

statement

[denise456]

Same Here

[MaDenGo]

i need help to add it :)

[Caosfox]

@comandante, this part creates the non stop spam "string text = mesaj.Text;"
mesaj = texbox object. everytime the timer runs, read the value on that box and send the packet with that value
how to fix?.. make some filter like "if (blablalbla)"
or create a new empty and hidden texbox and transfer the value to the packet from there, like: ( this are parts of the code)

textBox1.Text = (string)reader["message"];
mesaj.Text = textBox1.Text;

and
string text = textBox1.Text;
Packet packet = new Packet(0x7025);
packet.WriteUInt8((byte)7);
packet.WriteUInt8((byte)0);
packet.WriteAscii(text);
if (!string.IsNullOrEmpty(text))
{
Agent.Send(packet);
textBox1.Text = "";
}

this way, the packet value is sent 1 time from a hidden non visible clone of mesaj textbox, is sent 1 time and cleaned form the hidden one but still visible at the form form mesaj

is a weird and tricky way, but is what i can do with my limited knowlege of c/c#

[totfliega2007]

i add id but how i can change ITEM_CH_BLADE_xxx to Ingame name=Coper Blade or so?

[Comandante]

@comandante, this part creates the non stop spam "string text = mesaj.Text;"
mesaj = texbox object. everytime the timer runs, read the value on that box and send the packet with that value
how to fix?.. make some filter like "if (blablalbla)"
or create a new empty and hidden texbox and transfer the value to the packet from there, like: ( this are parts of the code)

textBox1.Text = (string)reader["message"];
mesaj.Text = textBox1.Text;

and
string text = textBox1.Text;
Packet packet = new Packet(0x7025);
packet.WriteUInt8((byte)7);
packet.WriteUInt8((byte)0);
packet.WriteAscii(text);
if (!string.IsNullOrEmpty(text))
{
Agent.Send(packet);
textBox1.Text = "";
}

this way, the packet value is sent 1 time from a hidden non visible clone of mesaj textbox, is sent 1 time and cleaned form the hidden one but still visible at the form form mesaj

is a weird and tricky way, but is what i can do with my limited knowlege of c/c#

Fixed with my way :) From now, old/empty notices won't be sent.

i add id but how i can change ITEM_CH_BLADE_xxx to Ingame name=Coper Blade or so?

Check my posts.

[totfliega2007]

I see it but you could have explained it better ..
because I understand it non.






well no matter thx for nothing

[Comandante]

I see it but you could have explained it better ..
because I understand it non.






well no matter thx for nothing

It's not my problem. As i said before i'm not going to make a full guide and "people with brain can handle it"... Some people borns with brain some doesn't. Some people will give thanks for developing their server some doesn't... So... You're welcome dude.

i need help to add it :)

What's the problem?

[egsro]

Seriosuly you did a great job with the base idea
but i can tell you that your c# code is a miss :D
how ever i took your sql procedure system into my tool


and thank you for sharing anyway

[Comandante]

Seriosuly you did a great job with the base idea
but i can tell you that your c# code is a miss :D
how ever i took your sql procedure system into my tool


and thank you for sharing anyway

Hehe :) it was just a little sample which took my 1 hr, i'm not even going to use that on my server with this version :) still developing that for better performance. Since i've shared the base i think you guys can develope that too :)) You're welcome.

[Caosfox]

yup, love your work!
even if for you took only 1 hour... for me is almost impossible ( but google is my best friend ^^)
works perfect to save globals and notices to db ( with some modifications, ofc), but logdb is going to scream for mercy if do that
maybe can make another db so save it... but lazy

[Comandante]

yup, love your work!
even if for you took only 1 hour... for me is almost impossible ( but google is my best friend ^^)
works perfect to save globals and notices to db ( with some modifications, ofc), but logdb is going to scream for mercy if do that
maybe can make another db so save it... but lazy

My SQL server using a lot of RAM. So i must use another version of this for a stable server with good performance. I'm decreasing logging level to minimum. Only some kind of items and GM commands. Logging them to txt from DB and then deleting the original one from DB. Otherwise SQL usage will be so high.

[Caosfox]

true that.

indeed is better for the db to write to text file and the program works faster ( dont even need to write from db to txt, simply to program to txt)

[BlackRoseGaming]

niceeee

[matrixasd2]

Can You Help Me ..
There A problem , Table _itemPluslog is Loading Fine .

The Table of PlusNotice is Empty Nothing Load

How Can Fix This Table To Make Him Loading