_ExistsServiceOffRentItem

09/17/2011 16:35 ByMnkn#1
_ExistsServiceOffRentItem link give me plz not have dB ? and item buy game relog again comeing item ?

[Only registered and activated users can see links. Click Here To Register...]
09/17/2011 16:37 3lyka#2
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?
09/17/2011 16:44 Ferpa_#3
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 (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) )
begin
return -1
end


GO 
then press Execute button
09/17/2011 16:47 ByMnkn#4
item buggy have item cps sell and game relog again comeing item why ?
09/17/2011 16:48 deadpirate#5
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 fuck

Try use this command it will solve all ur problems

mysql> drop database SRO_VT_ACCOUNT;