[Help]Coding a Npc Thats stores stuff(Not a wh)

[duddz]

Ok i have been trying to get a Npc to Store PlusPoints. I want it so that every time i give a +1 stone it will add 1 point to PlusPoints Colum in my MySql Character table. Ive got it to take the stone, got the Colum ready, Just cant get it to add 1 point to it.
Im Using CoEmuV2
Any ideas on this?
Is it possibel

[Akarama]

are you using lotf?

[duddz]

[QUOTE=Akarama;2444066]are you using lotf?[/QUOTE

Oh sorry i forgot to say. Using CoEmuV2

[kinshi88]

        public static void SavePlusPoint(ClientSocket CSocket)
        {
            MySqlCommand Cmd = new MySqlCommand("UPDATE `characters` SET `PlusPoints` = " + CSocket.Client.PlusPoints + " WHERE `CharID` = " + CSocket.Client.ID + "", DatabaseConnection.NewConnection());
            Cmd.ExecuteNonQuery();
            Cmd.Connection.Close();
            Cmd.Connection.Dispose();
            Cmd.Dispose();
        }

[duddz]

Originally Posted by kinshi88

        public static void SavePlusPoint(ClientSocket CSocket)
        {
            MySqlCommand Cmd = new MySqlCommand("UPDATE `characters` SET `PlusPoints` = " + CSocket.Client.PlusPoints + " WHERE `CharID` = " + CSocket.Client.ID + "", DatabaseConnection.NewConnection());
            Cmd.ExecuteNonQuery();
            Cmd.Connection.Close();
            Cmd.Connection.Dispose();
            Cmd.Dispose();
        }

Thanks you!

[m7med]

I HAVE THIS ERROR

PLEASE HELP

[duddz]

Originally Posted by m7med

I HAVE THIS ERROR

PLEASE HELP

Your dont put it in NpcTalk.cs i believe its Database.cs

[TheLeGend209]

Originally Posted by m7med

I HAVE THIS ERROR

PLEASE HELP

You Must put that in Database.cs

[TheLeGend209]

Originally Posted by kinshi88

        public static void SavePlusPoint(ClientSocket CSocket)
        {
            MySqlCommand Cmd = new MySqlCommand("UPDATE `characters` SET `PlusPoints` = " + CSocket.Client.PlusPoints + " WHERE `CharID` = " + CSocket.Client.ID + "", DatabaseConnection.NewConnection());
            Cmd.ExecuteNonQuery();
            Cmd.Connection.Close();
            Cmd.Connection.Dispose();
            Cmd.Dispose();
        }

Ty Kinshi

[m7med]

i have an error in PlusPoints

i fixed
in Entities\Character.cs
i add
public uint PlusPoints = 0;

[n0mansland]

This isn't exactly a code.. That's just part of it... You still have to add a lot more parts in character.cs,npctalk.cs, etc. anyways duddz has already figured this out and released a Met Bank search for it and then use the codes in there...

[PeTe Ninja]

its actually very easy.

here is what you have to add.

1. Points(or w.e u want) in the source, and mysql or ini w.e u use.
2. a save ( super easy )
3. a npc or command that lets you put it in and/or take it out.

and your done.