Register for your free account! | Forgot your password?

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

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

Advertisement



_ExistsServiceOffRentItem

Discussion on _ExistsServiceOffRentItem within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
ByMnkn's Avatar
 
elite*gold: 61
Join Date: Sep 2011
Posts: 341
Received Thanks: 57
_ExistsServiceOffRentItem

_ExistsServiceOffRentItem link give me plz not have dB ? and item buy game relog again comeing item ?

ByMnkn is offline  
Old 09/17/2011, 16:37   #2
 
3lyka's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 649
Received Thanks: 320
Can you explain something? how the hell you make the server works and ask how make gm . after 5 min u cry about how run server?
3lyka is offline  
Thanks
1 User
Old 09/17/2011, 16:44   #3
 
Ferpa_'s Avatar
 
elite*gold: 100
Join Date: Sep 2009
Posts: 1,195
Received Thanks: 379
in MSSQL right click on SRO_VT_ACCOUNT > New Query and paste this:

PHP Code:
/****** Object: StoredProcedure [dbo].[_ExistsServiceOffRentItem] Script Date: 09/13/2011 12:03:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE procedure 
[dbo].[_ExistsServiceOffRentItem]
as

if( 
exists (select from _Items with (nolockwhere RefItemID in (select RefItemID from _RefRentItem where Service ) ) )
begin
return -1
end


GO 
then press Execute button
Ferpa_ is offline  
Old 09/17/2011, 16:47   #4
 
ByMnkn's Avatar
 
elite*gold: 61
Join Date: Sep 2011
Posts: 341
Received Thanks: 57
item buggy have item cps sell and game relog again comeing item why ?
ByMnkn is offline  
Old 09/17/2011, 16:48   #5
 
elite*gold: 0
Join Date: May 2010
Posts: 110
Received Thanks: 34
Quote:
Originally Posted by 3lyka View Post
Can you explain something? how the hell you make the server works and ask how make gm . after 5 min u cry about how run server?
Just give up on all turk noobs There all thick as ****

Try use this command it will solve all ur problems

mysql> drop database SRO_VT_ACCOUNT;
deadpirate is offline  
Reply


Similar Threads Similar Threads
Real _ExistsServiceOffRentItem
09/14/2011 - SRO Private Server - 4 Replies
/****** Object: StoredProcedure . Script Date: 09/13/2011 12:03:44 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE procedure .



All times are GMT +1. The time now is 06:50.


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.