|
You last visited: Today at 14:41
Advertisement
How can remove all character data in SHARD ?
Discussion on How can remove all character data in SHARD ? within the SRO Private Server forum part of the Silkroad Online category.
04/10/2012, 12:33
|
#1
|
elite*gold: 0
Join Date: Feb 2009
Posts: 60
Received Thanks: 7
|
How can remove all character data in SHARD ?
Hi,
I am using vSRO 1.88.
I want to make a very very very clean db so I try to truncate all characters related tables in SHARD db but Forien key occurs. I can't to drop and re-create tables because fear db crashed !
Tell me any idea !
Thanks
|
|
|
04/10/2012, 12:35
|
#2
|
elite*gold: 0
Join Date: Mar 2010
Posts: 2,667
Received Thanks: 1,886
|
Code:
USE [SRO_VT_SHARD_INIT]
exec InitializeShardDB
|
|
|
04/10/2012, 13:34
|
#3
|
elite*gold: 0
Join Date: Feb 2009
Posts: 60
Received Thanks: 7
|
Quote:
Originally Posted by zikor1337
Code:
USE [SRO_VT_SHARD_INIT]
exec InitializeShardDB
|
Thanks for ur reply.
That 's result after run script:
Code:
(4 row(s) affected)
Msg 547, Level 16, State 0, Procedure InitializeShardDB, Line 16
The DELETE statement conflicted with the REFERENCE constraint "FK__CharTrijob__Char". The conflict occurred in database "SRO_VT_SHARD", table "dbo._CharTrijob", column 'CharID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Procedure InitializeShardDB, Line 20
The DELETE statement conflicted with the REFERENCE constraint "FK__InventoryForAvatar__Items". The conflict occurred in database "SRO_VT_SHARD", table "dbo._InventoryForAvatar", column 'ItemID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Procedure InitializeShardDB, Line 22
The DELETE statement conflicted with the REFERENCE constraint "FK__ChestInfo__AccountJID". The conflict occurred in database "SRO_VT_SHARD", table "dbo._ChestInfo", column 'JID'.
The statement has been terminated.
|
|
|
04/10/2012, 17:19
|
#4
|
elite*gold: 0
Join Date: Nov 2009
Posts: 1,163
Received Thanks: 1,161
|
FK__CharTrijob__Char
FK__InventoryForAvatar__Items
FK__ChestInfo__AccountJID
^-- fix it [[;.
|
|
|
04/10/2012, 18:43
|
#5
|
elite*gold: 0
Join Date: Feb 2009
Posts: 60
Received Thanks: 7
|
Quote:
Originally Posted by ღ ∂ropp
FK__CharTrijob__Char
FK__InventoryForAvatar__Items
FK__ChestInfo__AccountJID
^-- fix it [[;.
|
Tell me how to fix it pls ?
|
|
|
04/10/2012, 19:39
|
#6
|
elite*gold: 0
Join Date: Dec 2011
Posts: 651
Received Thanks: 266
|
Quote:
Originally Posted by TheShinichi
Tell me how to fix it pls ?
|
she is still learning how :S
|
|
|
04/11/2012, 01:17
|
#7
|
elite*gold: 0
Join Date: Feb 2009
Posts: 60
Received Thanks: 7
|
Quote:
Originally Posted by eminem5
she is still learning how :S
|
Yes yes Teach me pls
|
|
|
|
Similar Threads
|
Vsro Files Character Data Loading Failed
03/26/2012 - SRO Private Server - 8 Replies
Hello,
I installed windows new on my pc, before all working great.I can creat a new character but when i press start on my character i get a disconnect and in gameserver a message popup. What can i do?
http://img6.imagebanana.com/img/d0o7co0g/thumb/Un benannt.png
i hope anyone can help me, thank you
|
Parsing Character Data Packet
10/22/2011 - SRO Coding Corner - 6 Replies
Hello guys.
i have to say first thank you everyone here.
i learned a lot of thing from here. and sorry for my poor english. im working on it :P
So, my problem about character data.
i found Nep7Un2 post http://www.elitepvpers.com/forum/sro-ask-experts/3 90076-request-packet-structure-chardata-packet.htm l#post5289110 a while ago.
that is correct and i parsed all of data but im stuck on character coordinate.
i cant parsing it how can i calculate. i tried some way from walking structures like...
|
S> Ninja Gear + Character Full Data(Quitting)
10/30/2010 - Conquer Online 2 Trading - 1 Replies
All These Item And Character Are in GEM WORLD - RUBY
Sells super Full 1 Soc +5 Ninja Gear L120 +
Vest -1 238 HP
Hood -3 138 HP
Super +5 2 SDG Katana L120 n L124 .
Super +4 Necky L112
Super +6 SDG ring L126
Super +4 Hood SDG L52
|
[Request] Default character data user_character table
10/08/2009 - Dekaron Private Server - 5 Replies
hehehe, i was cleaning abit too much data today :mofo:
Can someone post a tsql-txt dump of the default chars in user_char ?
thanks alot! :handsdown:
|
wow character data lookup program
03/10/2005 - WoW Exploits, Hacks, Tools & Macros - 0 Replies
sicher nützlich für den ein oder anderen :)
------------
A small program to demonstrate a method for obtaining a pointer to WOW's character data. This pointer can then be used to access various information such as your character's x, y, and z location.
I wrote this because I have only seen methods of obtaining this pointer by rummaging through WOW's stack. The problem with this is it doesn't always find the pointer and sometimes it can lead to crashes.
To accomplish this, I simply...
|
All times are GMT +1. The time now is 14:41.
|
|