Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 14:41

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

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.

Reply
 
Old   #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
TheShinichi is offline  
Old 04/10/2012, 12:35   #2
 
zikor1337's Avatar
 
elite*gold: 0
Join Date: Mar 2010
Posts: 2,667
Received Thanks: 1,886
Code:
USE [SRO_VT_SHARD_INIT]
exec InitializeShardDB
zikor1337 is offline  
Thanks
1 User
Old 04/10/2012, 13:34   #3
 
elite*gold: 0
Join Date: Feb 2009
Posts: 60
Received Thanks: 7
Quote:
Originally Posted by zikor1337 View Post
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.
TheShinichi is offline  
Thanks
1 User
Old 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 [[;.
ღ ∂ Ropp is offline  
Old 04/10/2012, 18:43   #5
 
elite*gold: 0
Join Date: Feb 2009
Posts: 60
Received Thanks: 7
Quote:
Originally Posted by ღ ∂ropp View Post
FK__CharTrijob__Char
FK__InventoryForAvatar__Items
FK__ChestInfo__AccountJID

^-- fix it [[;.
Tell me how to fix it pls ?
TheShinichi is offline  
Thanks
1 User
Old 04/10/2012, 19:39   #6
 
eminem5's Avatar
 
elite*gold: 0
Join Date: Dec 2011
Posts: 651
Received Thanks: 266
Quote:
Originally Posted by TheShinichi View Post
Tell me how to fix it pls ?
she is still learning how :S
eminem5 is offline  
Old 04/11/2012, 01:17   #7
 
elite*gold: 0
Join Date: Feb 2009
Posts: 60
Received Thanks: 7
Quote:
Originally Posted by eminem5 View Post
she is still learning how :S
Yes yes Teach me pls
TheShinichi is offline  
Reply


Similar Threads 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.


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.