Ran Manager

Quote:

---

PrinceOfPersia - Crash Log
[d:10:04 PM] Cannot insert explicit value for identity column in table 'ShopPurchase' when IDENTITY_INSERT is set to OFF.

---

How about the other shopPurchase supported with Identity set to On?

Quote:

---

Originally Posted by royaljourney

How about the other shopPurchase supported with Identity set to On?

---

It's automatically detected by the ran manager.
I believe your Purkey is not set as PK so it doesn't work on your database.
Set it to PK so it will work correctly

Quote:

---

Originally Posted by PrinceOfPersia2

It's automatically detected by the ran manager.
I believe your Purkey is not set as PK so it doesn't work on your database.
Set it to PK so it will work correctly

---

My shopPurchase sir already Identity is yes.

Quote:

---

Originally Posted by royaljourney

My shopPurchase sir already Identity is yes.

---

Yes I know its identity, what I'm saying is it should be set as PK (Primary Key).

sir

i want to ask . what this two thing use for ?

i)Import Item Table
ii) Import Skill Table

and how to import the table ?

Hi,

Thank you for the share. It's a great help. But I tried the sending items to online players function, even tried just sending an item to one player but it doesn't seem to work for me. Any idea why? Thanks!

Quote:

---

Originally Posted by devilzcry

Hi,

Thank you for the share. It's a great help. But I tried the sending items to online players function, even tried just sending an item to one player but it doesn't seem to work for me. Any idea why? Thanks!

---

What was the error? Can you check the crashlog file?
Post some screenshots so we can what is the actual problem.

Quote:

---

Originally Posted by stormcch

sir

i want to ask . what this two thing use for ?

i)Import Item Table
ii) Import Skill Table

and how to import the table ?

---

i)Import Item Table - to update your ShopItemMap
ii) Import Skill Table - to update the SkillTableRef use by skill editor

@PrinceofPersia2

Sir, I have a problem with Import Item Table. After I imported my itemstrtable.txt, all my items now are displayed in my RanCP without information.
http://img21.imageshack.us/img21/5029/itemshopt.jpg

I used to add Item in my ItemShop using the RanCP Admin Panel.
btw, i'm using Ran Extinction CP and ep7jamrandatabase.
Can i suggest a separate reading of

@PrinceofPersia2

Here's the crash log file.

Quote:

---

PrinceOfPersia - Crash Log
[d:4:45 AM] Cannot insert explicit value for identity column in table 'ShopPurchase' when IDENTITY_INSERT is set to OFF.

---

Quote:

---

Originally Posted by devilzcry

@PrinceofPersia2

Here's the crash log file.

---

Same like my post ^^

Quote:

---

Originally Posted by devilzcry

@PrinceofPersia2

Here's the crash log file.

---

Just read backwards and follow my advice and it will work fine.

@PrinceofPersia2

Here's the error while trying to make PurKey as PK (Primary Key)

Quote:

---

'LogShopPurchase' table
- Unable to create index 'PK_LogShopPurchase'.
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.LogShopPurchase' and the index name 'PK_LogShopPurchase'. The duplicate key value is (115748).
Could not create constraint. See previous errors.
The statement has been terminated.

---

Quote:

---

Originally Posted by devilzcry

@PrinceofPersia2

Here's the error while trying to make PurKey as PK (Primary Key)

---

Your ShopPurchase has duplicate values which is incorrect. Please make sure that there is only one record for purkey 115748.

@PrinceofPersia2

I`ve already set my Purkey as Primary Key, but I still got the same error

Quote:

---

PrinceOfPersia - Crash Log
[d:6:20 PM] Cannot insert explicit value for identity column in table 'ShopPurchase' when IDENTITY_INSERT is set to OFF.

---

Here`s the SS of my database.
Attachment 116621

Quote:

---

Originally Posted by devilzcry

@PrinceofPersia2

I`ve already set my Purkey as Primary Key, but I still got the same error



Here`s the SS of my database.
Attachment 116621

---

I can say that you are not using a default ShopPurchase table. The default table doesn't have purnum and purkey is configured as int (identity & PK). Base on your table structure, I can say that PurNum is the identity so it won't work for you even if you set that to PK.
I'll see if I can support that on next updates. Just to let you know, the current ran manager is not compatible with custom table structures.

@PrinceofPersia2

Ok I'll wait for your next update. Thank you so much for the help.

Hi,
I am experiencing a slight problem...
There is a character that supposed to have -1000 Bright points but, the Ran Manager only display '0' ...

Quote:

---

Originally Posted by SeiferXIII

Hi,
I am experiencing a slight problem...
There is a character that supposed to have -1000 Bright points but, the Ran Manager only display '0' ...

---

I guess its being reset since the control doesn't support -1000.
I will fixed it in next update.

Quote:

---

Originally Posted by PrinceOfPersia2

Yes I know its identity, what I'm saying is it should be set as PK (Primary Key).

---

how to set sir? noob<-----

Quote:

---

Originally Posted by caspian0

how to set sir? noob<-----

---

Edit the table then column list will show. select the column you want to make as PK then click the Key icon on the toolbar.

any update sir?
hope you can add donation feature also like gmc v5
:)

thanks

Quote:

---

Originally Posted by caspian0

any update sir?
hope you can add donation feature also like gmc v5
:)

thanks

---

I don't have time recently so I don't release any updates.
For donation feature, I will add that in the future.

@PrinceOfPersia2: this is 1 of my error when i am replacing itemsstrtable file and skillstrtable file in DB MANAGEMENT i use v 1.2 of your editor /MY 2 txt file is readable and this error still came i use ep7

Attachment 117145Attachment 117146

Updated v.1.3
a. Fixed negative value not suported for PK, life pt,etc
b. Item table file is now used for puton and inventory
c. Skill Table file is now used for skill editor
d. Fixed purkey not being detected when not set as primary key causing an error on send items due to identity problem

Quote:

---

Originally Posted by PrinceOfPersia2

Updated v.1.3
a. Fixed negative value not suported for PK, life pt,etc
b. Item table file is now used for puton and inventory
c. Skill Table file is now used for skill editor
d. Fixed purkey not being detected when not set as primary key causing an error on send items due to identity problem

---

wow thanks @prince its awesome GBU