Register for your free account! | Forgot your password?

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

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

Advertisement



how to delete from _Items table

Discussion on how to delete from _Items table within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Feb 2012
Posts: 551
Received Thanks: 46
how to delete from _Items table

i have a server that has been opened since years
and now my table _Items -which there are huge operations on it- is kinda full
so when any operation is executing the table will take little long time to do it
any solution to delete "lines" from it to prevent this completion ?
thebigbody is offline  
Old 11/26/2017, 07:31   #2
 
B1Q's Avatar
 
elite*gold: 350
Join Date: Aug 2015
Posts: 2,008
Received Thanks: 1,193
Code:
update _Inventory set ItemID=0 where ItemID=ID64
update _ItemPool set ItemID=0 where ItemID=ID64
delete from _Items where ID64=ID64
B1Q is offline  
Reply


Similar Threads Similar Threads
[Release][Query] List All _Items and who they belong too
01/02/2016 - SRO PServer Guides & Releases - 1 Replies
Ok... this query is fun... its not really useful in any systems because its not made for performance... but it will give you a list of every _Item in your database.... and it will tell you who it belongs too... this query works on char invo, avatar invo, pet invo, chest storage and guild storage.... I dont think there is anywhere else to store items,... except for open market... but we wont go there... the query... USE
Help SQL SERVER AUTOMATIC DELETE _invontory Table
07/08/2012 - SRO Private Server - 0 Replies
its not hack. i tested. My database size 5gb. a lot of invontory items have. i open server after user login in game then 5-10min _invontory deleted automatic.After restore backup database.User login then 5-10min again deleted :S . i think _Invontory table presedures limited.Any one can help ? :S i tested ALL SQL SERVER (2005-2008-2008 R2-2008 SP1 R2- I have now SQL SERVER 2012)
Exp table
09/22/2006 - Ragnarok Online PServer Hosting - 12 Replies
hi ich kenn mich gar nich mit der exp table aus und kapier dadrin auch 0. naja kann mir jmd. ne exp table machen die für base lvl 1111 ausgerichtet ist? falls raten benötigt werden kann ich die auch sagen naja guide würd mir auch reichen =P PS: wer was für mich macht oder mir was gibt bekommtn karma hehe (wenns die exp table ist 2 karmas)
Table of contents..
06/03/2006 - Silkroad Online - 1 Replies



All times are GMT +1. The time now is 05:27.


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.