Register for your free account! | Forgot your password?

You last visited: Today at 03:11

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[Release] My edited version of Redux

Discussion on [Release] My edited version of Redux within the CO2 PServer Guides & Releases forum part of the CO2 Private Server category.

Reply
 
Old 11/07/2016, 13:44   #46
 
zakkwilde_17's Avatar
 
elite*gold: 0
Join Date: Jul 2007
Posts: 137
Received Thanks: 4
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
zakkwilde_17 is offline  
Old 11/09/2016, 21:35   #47
 
cloudwind360's Avatar
 
elite*gold: 0
Join Date: Feb 2009
Posts: 295
Received Thanks: 29
off topic..

umm wat does fps unlock or unlocker do?

thanks in adv
cloudwind360 is offline  
Old 11/10/2016, 12:34   #48
 
- Cyrix's Avatar
 
elite*gold: 0
Join Date: Jun 2015
Posts: 34
Received Thanks: 7
Good @ Keep it up .
- Cyrix is offline  
Old 01/29/2018, 18:11   #49
 
elite*gold: 0
Join Date: Jan 2017
Posts: 20
Received Thanks: 0
can not create account , i can but can not log in.
oguray is offline  
Old 01/31/2018, 01:38   #50
 
pintinho12's Avatar
 
elite*gold: 0
Join Date: Jul 2009
Posts: 908
Received Thanks: 390
Quote:
Originally Posted by cloudwind360 View Post
off topic..

umm wat does fps unlock or unlocker do?

thanks in adv
it unlocks your fps
pintinho12 is offline  
Old 02/01/2019, 01:18   #51
 
elite*gold: 0
Join Date: Jan 2017
Posts: 20
Received Thanks: 0
Can't create an account.
oguray is offline  
Old 08/05/2019, 01:54   #52
 
elite*gold: 0
Join Date: Sep 2010
Posts: 13
Received Thanks: 2
PROBLEM

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
HOW TO FIX THIS PROBLEM? SOME PROBLEM TO ME
emobaba31 is offline  
Old 08/05/2019, 18:59   #53
 
pintinho12's Avatar
 
elite*gold: 0
Join Date: Jul 2009
Posts: 908
Received Thanks: 390
Hardcore
pintinho12 is offline  
Old 08/06/2019, 00:08   #54
 
elite*gold: 0
Join Date: Sep 2010
Posts: 13
Received Thanks: 2
Quote:
Originally Posted by pintinho12 View Post
Hardcore
tell me bro ? How to fix character create problem ?
emobaba31 is offline  
Old 08/06/2019, 20:30   #55
 
pintinho12's Avatar
 
elite*gold: 0
Join Date: Jul 2009
Posts: 908
Received Thanks: 390
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
pintinho12 is offline  
Old 08/08/2019, 21:36   #56
 
elite*gold: 0
Join Date: Nov 2008
Posts: 63
Received Thanks: 11
Thumbs up

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
darkhc is offline  
Old 08/13/2019, 01:49   #57
 
elite*gold: 0
Join Date: Aug 2019
Posts: 12
Received Thanks: 0
ur have scrip vip tokem 30 day ?
mohamed~Sallah is offline  
Old 10/25/2019, 23:46   #58
 
KingGannon's Avatar
 
elite*gold: 0
Join Date: Oct 2005
Posts: 26
Received Thanks: 2
To anyone who still cares about Redux

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)
KingGannon is offline  
Old 11/14/2019, 02:52   #59
 
elite*gold: 0
Join Date: Aug 2011
Posts: 6
Received Thanks: 0
if (location == 5)

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)
tiokill is offline  
Old 06/01/2020, 09:01   #60
 
elite*gold: 0
Join Date: Jun 2020
Posts: 1
Received Thanks: 0
wowowo

thanks buddy
khalednabawy is offline  
Reply




All times are GMT +2. The time now is 03:11.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.