[Release] My edited version of Redux

11/07/2016 13:44 zakkwilde_17#46
when I create a new character, I am faced with this problem:

Code:
NHibernate.Exceptions.GenericADOException: could not insert: [Redux.Database.Domain.DbCharacter#1003003][SQL: INSERT INTO characters (Name, Spouse, Lookface, Hair, Level, PreviousLevel, Money, WhMoney, WhPassword, CP, Experience, Strength, Agility, Spirit, Vitality, ExtraStats, Life, Mana, Map, X, Y, PrevMap, PrevX, PrevY, Pk, Profession, Profession1, Profession2, Profession3, QuizPoints, VirtuePoints, Online, HeavenBlessExpires, DoubleExpExpires, TrainingTime, OfflineTGEntered, LuckyTimeRemaining, StoredMeteors, StoredDBalls, StoredPhoenix, StoredDragon, StoredFury, StoredRainbow, StoredKylin, StoredVoilet, StoredMoon, StoredTortise, IsHunter, MonsterID, MonsterKills, MonsterCount, Newbie, VotePoints, VipExpire, VoteExpire, UID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] ---> MySql.Data.MySqlClient.MySqlException: Column 'WhPassword' cannot be null
   em MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   em MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
   em MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
   em MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
   em MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   em MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   em MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   em NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd) na d:\CSharp\NH\nhibernate\src\NHibernate\AdoNet\AbstractBatcher.cs:linha 216
   em NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation) na d:\CSharp\NH\nhibernate\src\NHibernate\AdoNet\NonBatchingBatcher.cs:linha 39
   em NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2643
   --- Fim do rastreamento de pilha de exceções internas ---
   em NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2663
   em NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 3015
   em NHibernate.Action.EntityInsertAction.Execute() na d:\CSharp\NH\nhibernate\src\NHibernate\Action\EntityInsertAction.cs:linha 59
   em NHibernate.Engine.ActionQueue.Execute(IExecutable executable) na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 136
   em NHibernate.Engine.ActionQueue.ExecuteActions(IList list) na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 126
   em NHibernate.Engine.ActionQueue.ExecuteActions() na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 169
   em NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session) na d:\CSharp\NH\nhibernate\src\NHibernate\Event\Default\AbstractFlushingEventListener.cs:linha 249
   em NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event) na d:\CSharp\NH\nhibernate\src\NHibernate\Event\Default\DefaultFlushEventListener.cs:linha 19
   em NHibernate.Impl.SessionImpl.Flush() na d:\CSharp\NH\nhibernate\src\NHibernate\Impl\SessionImpl.cs:linha 1479
   em NHibernate.Transaction.AdoTransaction.Commit() na d:\CSharp\NH\nhibernate\src\NHibernate\Transaction\AdoTransaction.cs:linha 187
   em Redux.Database.Repositories.Repository`2.Add(TValue obj) na F:\Project\Redux\Redux The Source\Redux 043\Redux\Database\Repositories\Repository.cs:linha 26
NHibernate.StaleStateException: Unexpected row count: 0; expected: 1
   em NHibernate.AdoNet.Expectations.BasicExpectation.VerifyOutcomeNonBatched(Int32 rowCount, IDbCommand statement) na d:\CSharp\NH\nhibernate\src\NHibernate\AdoNet\Expectations.cs:linha 29
   em NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation) na d:\CSharp\NH\nhibernate\src\NHibernate\AdoNet\NonBatchingBatcher.cs:linha 40
   em NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2777
   em NHibernate.Persister.Entity.AbstractEntityPersister.UpdateOrInsert(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2689
   em NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Int32[] dirtyFields, Boolean hasDirtyCollection, Object[] oldFields, Object oldVersion, Object obj, Object rowId, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2965
   em NHibernate.Action.EntityUpdateAction.Execute() na d:\CSharp\NH\nhibernate\src\NHibernate\Action\EntityUpdateAction.cs:linha 79
   em NHibernate.Engine.ActionQueue.Execute(IExecutable executable) na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 136
   em NHibernate.Engine.ActionQueue.ExecuteActions(IList list) na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 126
   em NHibernate.Engine.ActionQueue.ExecuteActions() na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 170
   em NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session) na d:\CSharp\NH\nhibernate\src\NHibernate\Event\Default\AbstractFlushingEventListener.cs:linha 249
   em NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event) na d:\CSharp\NH\nhibernate\src\NHibernate\Event\Default\DefaultFlushEventListener.cs:linha 19
   em NHibernate.Impl.SessionImpl.Flush() na d:\CSharp\NH\nhibernate\src\NHibernate\Impl\SessionImpl.cs:linha 1479
   em NHibernate.Transaction.AdoTransaction.Commit() na d:\CSharp\NH\nhibernate\src\NHibernate\Transaction\AdoTransaction.cs:linha 187
   em Redux.Database.Repositories.Repository`2.Update(TValue obj) na F:\Project\Redux\Redux The Source\Redux 043\Redux\Database\Repositories\Repository.cs:linha 42

EDIT

Solved :D
11/09/2016 21:35 cloudwind360#47
off topic..

umm wat does fps unlock or unlocker do?

thanks in adv
11/10/2016 12:34 - Cyrix#48
Good @[Only registered and activated users can see links. Click Here To Register...] Keep it up .
01/29/2018 18:11 oguray#49
can not create account , i can but can not log in.
01/31/2018 01:38 pintinho12#50
Quote:
Originally Posted by cloudwind360 View Post
off topic..

umm wat does fps unlock or unlocker do?

thanks in adv
it unlocks your fps
02/01/2019 01:18 oguray#51
Can't create an account.
08/05/2019 01:54 emobaba31#52
Quote:
Originally Posted by zakkwilde_17 View Post
when I create a new character, I am faced with this problem:

Code:
NHibernate.Exceptions.GenericADOException: could not insert: [Redux.Database.Domain.DbCharacter#1003003][SQL: INSERT INTO characters (Name, Spouse, Lookface, Hair, Level, PreviousLevel, Money, WhMoney, WhPassword, CP, Experience, Strength, Agility, Spirit, Vitality, ExtraStats, Life, Mana, Map, X, Y, PrevMap, PrevX, PrevY, Pk, Profession, Profession1, Profession2, Profession3, QuizPoints, VirtuePoints, Online, HeavenBlessExpires, DoubleExpExpires, TrainingTime, OfflineTGEntered, LuckyTimeRemaining, StoredMeteors, StoredDBalls, StoredPhoenix, StoredDragon, StoredFury, StoredRainbow, StoredKylin, StoredVoilet, StoredMoon, StoredTortise, IsHunter, MonsterID, MonsterKills, MonsterCount, Newbie, VotePoints, VipExpire, VoteExpire, UID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] ---> MySql.Data.MySqlClient.MySqlException: Column 'WhPassword' cannot be null
   em MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   em MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
   em MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
   em MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
   em MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   em MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   em MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   em NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd) na d:\CSharp\NH\nhibernate\src\NHibernate\AdoNet\AbstractBatcher.cs:linha 216
   em NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation) na d:\CSharp\NH\nhibernate\src\NHibernate\AdoNet\NonBatchingBatcher.cs:linha 39
   em NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2643
   --- Fim do rastreamento de pilha de exceções internas ---
   em NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2663
   em NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 3015
   em NHibernate.Action.EntityInsertAction.Execute() na d:\CSharp\NH\nhibernate\src\NHibernate\Action\EntityInsertAction.cs:linha 59
   em NHibernate.Engine.ActionQueue.Execute(IExecutable executable) na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 136
   em NHibernate.Engine.ActionQueue.ExecuteActions(IList list) na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 126
   em NHibernate.Engine.ActionQueue.ExecuteActions() na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 169
   em NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session) na d:\CSharp\NH\nhibernate\src\NHibernate\Event\Default\AbstractFlushingEventListener.cs:linha 249
   em NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event) na d:\CSharp\NH\nhibernate\src\NHibernate\Event\Default\DefaultFlushEventListener.cs:linha 19
   em NHibernate.Impl.SessionImpl.Flush() na d:\CSharp\NH\nhibernate\src\NHibernate\Impl\SessionImpl.cs:linha 1479
   em NHibernate.Transaction.AdoTransaction.Commit() na d:\CSharp\NH\nhibernate\src\NHibernate\Transaction\AdoTransaction.cs:linha 187
   em Redux.Database.Repositories.Repository`2.Add(TValue obj) na F:\Project\Redux\Redux The Source\Redux 043\Redux\Database\Repositories\Repository.cs:linha 26
NHibernate.StaleStateException: Unexpected row count: 0; expected: 1
   em NHibernate.AdoNet.Expectations.BasicExpectation.VerifyOutcomeNonBatched(Int32 rowCount, IDbCommand statement) na d:\CSharp\NH\nhibernate\src\NHibernate\AdoNet\Expectations.cs:linha 29
   em NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation) na d:\CSharp\NH\nhibernate\src\NHibernate\AdoNet\NonBatchingBatcher.cs:linha 40
   em NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2777
   em NHibernate.Persister.Entity.AbstractEntityPersister.UpdateOrInsert(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2689
   em NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Int32[] dirtyFields, Boolean hasDirtyCollection, Object[] oldFields, Object oldVersion, Object obj, Object rowId, ISessionImplementor session) na d:\CSharp\NH\nhibernate\src\NHibernate\Persister\Entity\AbstractEntityPersister.cs:linha 2965
   em NHibernate.Action.EntityUpdateAction.Execute() na d:\CSharp\NH\nhibernate\src\NHibernate\Action\EntityUpdateAction.cs:linha 79
   em NHibernate.Engine.ActionQueue.Execute(IExecutable executable) na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 136
   em NHibernate.Engine.ActionQueue.ExecuteActions(IList list) na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 126
   em NHibernate.Engine.ActionQueue.ExecuteActions() na d:\CSharp\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:linha 170
   em NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session) na d:\CSharp\NH\nhibernate\src\NHibernate\Event\Default\AbstractFlushingEventListener.cs:linha 249
   em NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event) na d:\CSharp\NH\nhibernate\src\NHibernate\Event\Default\DefaultFlushEventListener.cs:linha 19
   em NHibernate.Impl.SessionImpl.Flush() na d:\CSharp\NH\nhibernate\src\NHibernate\Impl\SessionImpl.cs:linha 1479
   em NHibernate.Transaction.AdoTransaction.Commit() na d:\CSharp\NH\nhibernate\src\NHibernate\Transaction\AdoTransaction.cs:linha 187
   em Redux.Database.Repositories.Repository`2.Update(TValue obj) na F:\Project\Redux\Redux The Source\Redux 043\Redux\Database\Repositories\Repository.cs:linha 42

EDIT

Solved :D
HOW TO FIX THIS PROBLEM? SOME PROBLEM TO ME
08/05/2019 18:59 pintinho12#53
Hardcore
08/06/2019 00:08 emobaba31#54
Quote:
Originally Posted by pintinho12 View Post
Hardcore
tell me bro ? How to fix character create problem ?
08/06/2019 20:30 pintinho12#55
I gave you the reply already.
If you don't know the basics of databases and programming, I can't help you. I've been working as a teacher for kids and teenagers for over 6 years and I'm tired of seeing lazy people who wants to get the job done with no efforts.
I simplified the error message for you.

Quote:
Column 'WhPassword' cannot be null
08/08/2019 21:36 darkhc#56
Quote:
Originally Posted by pintinho12 View Post
I gave you the reply already.
If you don't know the basics of databases and programming, I can't help you. I've been working as a teacher for kids and teenagers for over 6 years and I'm tired of seeing lazy people who wants to get the job done with no efforts.
I simplified the error message for you.
Totally agree with you.People who create servers without knowing
08/13/2019 01:49 mohamed~Sallah#57
ur have scrip vip tokem 30 day ?
10/25/2019 23:46 KingGannon#58
At the Characters SQL Database for creating a new character:
under the column Lookface
2xxy00z <-
xx = Face portrait (not going to list the many different face ids)

y = 1 Male Face options @ Beautician
y = 2 Female Face options @ Beautician

z=1 Small F
z=2 Large F
z=3 Small M
z=4 Large M

under the column Hair
xyy
x = Hair Color (3 - 9, anything outside will show no hair)
yy = Hairstyles (see below)


Barber.cs
Cut my Hair option will randomly style the new design only which are ID to 30-51.
For those who want the classic hairs you have to add that option to the NPC. And the classic hairs IDs are 10-17 and any numbers outside these range will show no hair.


Equipmentmanager.cs
One of the script region is preventing Trojans from equipping that left-handed Duals Weapons
Looking around the lines
if (location == 5)
11/14/2019 02:52 tiokill#59
Quote:
Originally Posted by KingGannon View Post
At the Characters SQL Database for creating a new character:
under the column Lookface
2xxy00z <-
xx = Face portrait (not going to list the many different face ids)

y = 1 Male Face options @ Beautician
y = 2 Female Face options @ Beautician

z=1 Small F
z=2 Large F
z=3 Small M
z=4 Large M

under the column Hair
xyy
x = Hair Color (3 - 9, anything outside will show no hair)
yy = Hairstyles (see below)


Barber.cs
Cut my Hair option will randomly style the new design only which are ID to 30-51.
For those who want the classic hairs you have to add that option to the NPC. And the classic hairs IDs are 10-17 and any numbers outside these range will show no hair.


Equipmentmanager.cs
One of the script region is preventing Trojans from equipping that left-handed Duals Weapons
Looking around the lines
if (location == 5)
Helo, Found a solution to fix the Duals Weapons problem?

if (location == 5)
06/01/2020 09:01 khalednabawy#60
thanks buddy