Register for your free account! | Forgot your password?

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

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

Advertisement



[RELEASE] Little query for ID columns.

Discussion on [RELEASE] Little query for ID columns. within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
mertcoskun's Avatar
 
elite*gold: 0
Join Date: Oct 2010
Posts: 177
Received Thanks: 108
[RELEASE] Little query for ID columns.

Hi all.maybe you need these queries.ID columns will start from '1'.

execute shard database.Have fun.
note:use this for the clean database!

DBCC CHECKIDENT ('_char',RESEED,0)
DBCC CHECKIDENT ('_TrainingCamp',RESEED,0)
DBCC CHECKIDENT ('_CharCOS',RESEED,0)
DBCC CHECKIDENT ('_Items',RESEED,0)
DBCC CHECKIDENT ('_Guild',RESEED,0)
DBCC CHECKIDENT ('_AlliedClans',RESEED,0)
mertcoskun is offline  
Old 03/01/2012, 13:38   #2
 
Dr.Abdelfattah's Avatar
 
elite*gold: 7
Join Date: May 2010
Posts: 2,115
Received Thanks: 2,374
can't used on shard db contain data (like chars, etc)
Dr.Abdelfattah is offline  
Old 03/01/2012, 13:39   #3
 
mertcoskun's Avatar
 
elite*gold: 0
Join Date: Oct 2010
Posts: 177
Received Thanks: 108
Quote:
Originally Posted by Dr.Abdelfattah View Post
can't used on shard db contain data (like chars, etc)
yes brouther.this is for clean databases.
mertcoskun is offline  
Reply


Similar Threads Similar Threads
Requesting a query for adding new columns in db
01/28/2012 - SRO Private Server - 3 Replies
Hi i'm requesting a query to add more columns into a table, i need 3 more columns at shardservice since cleaned the db it only appears one column atm. So if anyone got one feel free to post it. Thanks in advance!
CSV excel columns..
10/19/2011 - Dekaron - 2 Replies
.
itemtype new columns!
07/28/2011 - CO2 Programming - 4 Replies
in the oldest patches itemtype was like this: 111003 IronHelmet 21 0 15 0 0 0 0 0 0 0 150 0 0 0 3 0 0 0 0 3998 3998 0 0 0 0 0 0 0 0 1 1000 0 0 0 0 Warrior`sHelmet None 5 now the itemtype looks like this: 111003 IronHelmet 21 0 15 0 0 0 0 0 0 0 150 0 0 0 3 0 0 0 0 3899 3899 0 0 0 0 0 0 0 0 0 1 1000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Warrior`sHelmet None 5 0 0 0
[Release]FlyingDragon Query
02/28/2011 - EO PServer Guides & Releases - 6 Replies
I made this Query using these files: FlyingDragons This is my very first query I made so let me know if it works! (P.S. RedDragon soon to come)



All times are GMT +1. The time now is 22:28.


Powered by vBulletin®
Copyright ©2000 - 2026, 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 ©2026 elitepvpers All Rights Reserved.