mysql "Set"

[Garedx]

Str8 into the point ... some columns or tables in my database doesn't obey the Set command
ex:
when you create a character, the EntityID of account is supposed to be set as the EntityID
but that doesn't happen it remains 0
so u have to create a new character every time u login ... despite the entity is created is already
it just doesn't link to the account because the EntityID didn't set
the question is ... why doesn't it set?

[Aceking]

Without your code there isnt really a way to know for sure.

Although I think you are referring to Insert?

[Garedx]

okay i will get an example:
on Character creation :

PHP Code:

client.account.EntityID = client.Entity.EntityID;
account.save(); 


later on accounttable.cs

PHP Code:

public void Save()
         {
             if (exists)
             {
                 MySqlCommand cmd = new MySqlCommand(MySqlCommandType.UPDATE);
                 cmd.Update("accounts").Set("Password", Password).Set("IP", IP).Set("EntityID", EntityID).Set("LastCheck", (ulong)DateTime.Now.ToBinary()).Where("Username", Username).Set("festivalclaim",festival).Execute();
             }
             else
             {
                 try
                 {
                     MySqlCommand cmd = new MySqlCommand(MySqlCommandType.INSERT);
                     cmd.Insert("accounts").Insert("Username", Username).Insert("Password", Password).Insert("State", (byte)State).Execute();
                 }
                 catch (Exception e) { Program.SaveException(e); }
             } 


[Aceking]

Is anything being changed at all?

Try changing:

cmd.Update("accounts").Set("Password", Password).Set("IP", IP).Set("EntityID", EntityID).Set("LastCheck", (ulong)DateTime.Now.ToBinary()).Where("Username", Username).Set("festivalclaim",festival).Execute();

to

cmd.Update("accounts").Set("Password", Password).Set("IP", IP).Set("EntityID", EntityID).Set("LastCheck", (ulong)DateTime.Now.ToBinary()).Set("festivalclaim",festival).Where("Username", Username).Execute();

[Garedx]

Originally Posted by Aceking

Is anything being changed at all?

Try changing:

cmd.Update("accounts").Set("Password", Password).Set("IP", IP).Set("EntityID", EntityID).Set("LastCheck", (ulong)DateTime.Now.ToBinary()).Where("Username", Username).Set("festivalclaim",festival).Execute();

to

cmd.Update("accounts").Set("Password", Password).Set("IP", IP).Set("EntityID", EntityID).Set("LastCheck", (ulong)DateTime.Now.ToBinary()).Set("festivalclaim",festival).Where("Username", Username).Execute();

OMG o.O

I thought i removed that long time ago!!

ThnQ you are a savior .... It got to be the error of course

ThnQ again and *** mercy my memory -_-