• Forum vBulletin altyapısından Xenforo altyapısına geçirildi, bu sebeple eski şifreleriniz ile foruma giriş yapamayacaksınız, parolamı unuttum adımından mailiniz ile şifre sıfırlayarak giriş yapabilirsiniz.

    Üyeliklerinde geçerli bir mail adresi olmadığı için sıfırlama yapamayacak kullanıcılar forum kullanıcı adlarını ve yeni şifrelerini yazarak info@maxigame.org adresine şifre sıfırlamak istediklerine dair bir mail göndersinler şifrelerini sıfırlayıp mail adreslerini güncelleyeceğiz. Şifreniz sıfırlandıktan sonra foruma giriş yapıp tekrar istediğiniz gibi değiştirebilirsiniz.

Orjinal Vsro Server Files (Sonunda Yayınlandı.)

coskun4444' Alıntı:
item bug olayını hala çözemedim ama sorunun nerede olduğunu sanırım buldum USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_STRG_MOVE_ITEM] Script Date: 09/17/2011 11:40:57 ******/
SETANSI_NULLSON
GO
SETQUOTED_IDENTIFIERON
GO
--------------------------------------------------------------------------------------------------------------------------
-- PROC #3
-- _STRG_MOVE_ITEM ! - by zone0000 ()
--------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------
-- _STRG_MOVE_ITEM Operation(35)(36) ()
-----------------------------------------------------------------
ALTERPROCEDURE [dbo].[_STRG_MOVE_ITEM]
@Operation ASTINYINT,
@UserJID ASINT,
@CharID ASINT,
@GuildID ASBIGINT,-- Operation 39, 40 LinkedItemID .
@Slot_From ASTINYINT,
@Slot_To ASTINYINT,
@Data ASINT,-- 0 .
@RemoveAndOverwrite ASTINYINT
AS
----------------
-- SP_UPDATE_SLOTS_INV 0
-- SP_UPDATE_SLOTS_CHEST 1
-- SP_DEPOSIT_ITEM 2
-- SP_WITHDRAW_ITEM 3
-- SP_UPDATE_SLOTS_INV_COS 16
-- SP_GUILD_CHEST_UPDATE_SLOT 29
-- SP_GUILD_CHEST_DEPOSIT_ITEM 30
-- SP_GUILD_CHEST_WITHDRAW_ITEM 31
-- SP_MOVE_ITEM_AVATAR_PC 35 -- Avatar
-- SP_MOVE_ITEM_PC_AVATAR 36 -- Avatar
-- SP_PUSH_ITEM_INTO_MAGIC_CUBE 39 -- MagicCube
-- SP_POP_ITEM_FROM_MAGIC_CUBE 40 -- MagicCube
----------------
IF (@Operation <> 0 AND @Operation <> 1 AND @Operation <> 2 AND @Operation <> 3 AND @Operation <> 16 AND @Operation <> 29 AND @Operation <> 30 AND @Operation <> 31
AND @Operation <> 35 AND @Operation <> 36 -- Avatar
AND @Operation <> 39 AND @Operation <> 40 )-- MagicCube
BEGIN
RETURN-1000
END
-- overwrite inventory ( reloading)
IF (@RemoveAndOverwrite <> 0 AND @Operation <> 0)
BEGIN
RETURN-1001
END
DECLARE @ItemID_From BIGINT
DECLARE @ItemID_To BIGINT
SET @ItemID_From = 0
SET @ItemID_To = 0
----------------------------------------------------------
-- Step1. Src Slot Dst Slot
----------------------------------------------------------
-------------- Src Item
IF (@Operation = 0 OR @Operation = 2 OR @Operation = 30)-- src: inventory
BEGIN
SELECT @ItemID_From = ItemID FROM _Inventory WHERE CharID = @CharID AND Slot = @Slot_From
END
ELSEIF (@Operation = 1 OR @Operation = 3)-- src: chest
BEGIN
SELECT @ItemID_From = ItemID FROM _Chest WHERE UserJID = @UserJID AND Slot = @Slot_From
END
ELSEIF (@Operation = 16)
BEGIN
SELECT @ItemID_From = ItemID FROM _InvCOS WHERE COSID = @CharID AND Slot = @Slot_From
END
ELSEIF (@Operation = 29 OR @Operation = 31)
BEGIN
SELECT @ItemID_From = ItemID FROM _GuildChest WHERE GuildID = @GuildID AND Slot = @Slot_From
END
-- Avatar ( Avatar -> PC )
ELSEIF (@Operation = 35)
BEGIN
SELECT @ItemID_From = ItemID FROM _InventoryForAvatar WHERE CharID = @CharID AND Slot = @Slot_From
END
-- Avatar ( PC -> Avatar )
ELSEIF (@Operation = 36)
BEGIN
SELECT @ItemID_From = ItemID FROM _Inventory WHERE CharID = @CharID AND Slot = @Slot_From
END
-- MagicCube ( PCInv -> MagicCube )
ELSEIF (@Operation = 39)
BEGIN
SELECT @ItemID_From = ItemID FROM _Inventory WHERE CharID = @CharID AND Slot = @Slot_From
END
-- MagicCube ( MagicCube -> PCInv )
ELSEIF (@Operation = 40)
BEGIN
SELECT @ItemID_From = ItemID FROM _InventoryForLinkedStorage WHERE LinkedItemID = @GuildID AND Slot = @Slot_From
END
-------------- Dst Item
IF (@Operation = 0 OR @Operation = 3 OR @Operation = 31)-- dst: inventory
BEGIN
SELECT @ItemID_To = ItemID FROM _Inventory WHERE CharID = @CharID AND Slot = @Slot_To
END
ELSEIF (@Operation = 1 OR @Operation = 2)-- dst: chest
BEGIN
SELECT @ItemID_To = ItemID FROM _Chest WHERE UserJID = @UserJID AND Slot = @Slot_To
END
ELSEIF (@Operation = 16)
BEGIN
SELECT @ItemID_To = ItemID FROM _InvCOS WHERE COSID = @CharID AND Slot = @Slot_To
END
ELSEIF (@Operation = 29 OR @Operation = 30)
BEGIN
SELECT @ItemID_To = ItemID FROM _GuildChest WHERE GuildID = @GuildID AND Slot = @Slot_To
END
-- Avatar ( Avatar -> PC )
ELSEIF (@Operation = 35)
BEGIN
SELECT @ItemID_To = ItemID FROM _Inventory WHERE CharID = @CharID AND Slot = @Slot_To
END
-- Avatar ( PC -> Avatar )
ELSEIF (@Operation = 36)
BEGIN
SELECT @ItemID_To = ItemID FROM _InventoryForAvatar WHERE CharID = @CharID AND Slot = @Slot_To
END
-- MagicCube ( PCInv -> MagicCube )
ELSEIF (@Operation = 39)
BEGIN
SELECT @ItemID_To = ItemID FROM _InventoryForLinkedStorage WHERE LinkedItemID = @GuildID AND Slot = @Slot_To
END
-- MagicCube ( MagicCube -> PCInv )
ELSEIF (@Operation = 40)
BEGIN
SELECT @ItemID_To = ItemID FROM _Inventory WHERE CharID = @CharID AND Slot = @Slot_To
END
--------------
IF (@RemoveAndOverwrite <> 0)
BEGIN
-- .
IF (@ItemID_From ISNULLOR @ItemID_To ISNULL)
BEGIN
RETURN-1003
END
IF (@ItemID_From = 0 OR @ItemID_To = 0)
BEGIN
RETURN-1004
END
END
ELSE
BEGIN
-- Source .
IF (@ItemID_From ISNULLOR @ItemID_From = 0)
BEGIN
RETURN-1005
END
IF (@ItemID_To ISNOTNULLAND @ItemID_To <> 0)
BEGIN
RETURN-1006
END
END
IF (@Operation = 0)
BEGIN
IF (@Slot_To < 13)
BEGIN
DECLARE @CheckValidity INT
EXEC @CheckValidity = _STRG_CHECKITEM_CANBE_EQUIPED@ItemID_From, @Slot_To
IF (@CheckValidity <= 0)
BEGIN
RETURN @CheckValidity
END
END
END
BEGINTRANSACTION
----------------------------------------------------------
-- Step2. Storage
----------------------------------------------------------
-------------- Src Slot
IF (@Operation = 0 OR @Operation = 2 OR @Operation = 30)
BEGIN
UPDATE _Inventory SET ItemID = 0 WHERE CharID = @CharID AND Slot = @Slot_From
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-2
END
END
ELSEIF (@Operation = 1 OR @Operation = 3)
BEGIN
UPDATE _Chest SET ItemID = 0 WHERE UserJID = @UserJID AND Slot = @Slot_From
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-2
END
END
ELSEIF (@Operation = 16)
BEGIN
UPDATE _InvCOS SET ItemID = 0 WHERE COSID = @CharID AND Slot = @Slot_From
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-2
END
END
ELSEIF (@Operation = 29 OR @Operation = 31)
BEGIN
UPDATE _GuildChest SET ItemID = 0 WHERE GuildID = @GuildID AND Slot = @Slot_From
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-2
END
END
-- Avatar ( Avatar -> PC )
ELSEIF (@Operation = 35 )
BEGIN
UPDATE _InventoryForAvatar SET ItemID = 0 WHERE CharID = @CharID AND Slot = @Slot_From
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-2
END
END
-- Avatar ( PC -> Avatar )
ELSEIF (@Operation = 36 )
BEGIN
UPDATE _Inventory SET ItemID = 0 WHERE CharID = @CharID AND Slot = @Slot_From
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-2
END
END
-- MagicCube ( PCInv -> MagicCube )
ELSEIF (@Operation = 39 )
BEGIN
UPDATE _Inventory SET ItemID = 0 WHERE CharID = @CharID AND Slot = @Slot_From
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-2
END
END
-- MagicCube ( MagicCube -> PCInv )
ELSEIF (@Operation = 40 )
BEGIN
UPDATE _InventoryForLinkedStorage SET ItemID = 0 WHERE LinkedItemID = @GuildID AND Slot = @Slot_From
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-2
END
END
-------------- Dst Slot
IF (@Operation = 0 OR @Operation = 3 OR @Operation = 31)
BEGIN
UPDATE _Inventory SET ItemID = @ItemID_From WHERE CharID = @CharID AND Slot = @Slot_To
END
ELSEIF (@Operation = 1 OR @Operation = 2)
BEGIN
UPDATE _Chest SET ItemID = @ItemID_From WHERE UserJID = @UserJID AND Slot = @Slot_To
END
ELSEIF (@Operation = 16)
BEGIN
UPDATE _InvCOS SET ItemID = @ItemID_From WHERE COSID = @CharID AND Slot = @Slot_To
END
ELSEIF (@Operation = 29 OR @Operation = 30)
BEGIN
UPDATE _GuildChest SET ItemID = @ItemID_From WHERE GuildID = @GuildID AND Slot = @Slot_To
END
-- Avatar ( Avatar -> PC )
ELSEIF (@Operation = 35)
BEGIN
UPDATE _Inventory SET ItemID = @ItemID_From WHERE CharID = @CharID AND Slot = @Slot_To
END
-- Avatar ( PC -> Avatar )
ELSEIF (@Operation = 36)
BEGIN
UPDATE _InventoryForAvatar SET ItemID = @ItemID_From WHERE CharID = @CharID AND Slot = @Slot_To
END
-- MagicCube ( PCInv -> MagicCube )
ELSEIF (@Operation = 39)
BEGIN
UPDATE _InventoryForLinkedStorage SET ItemID = @ItemID_From WHERE LinkedItemID = @GuildID AND Slot = @Slot_To
END
-- MagicCube ( MagicCube -> PCInv )
ELSEIF (@Operation = 40)
BEGIN
UPDATE _Inventory SET ItemID = @ItemID_From WHERE CharID = @CharID AND Slot = @Slot_To
END
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-3
END
----------------------------------------------------------
-- Step3. Overwrite !
----------------------------------------------------------
IF (@RemoveAndOverwrite <> 0)
BEGIN
DECLARE @Rvalue INT
EXEC @Rvalue = _STRG_FREE_ITEM_NoTX@ItemID_To
IF (@Rvalue < 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-4
END
END
----------------------------------------------------------
-- Step4. 4Byte Item Data ( !)
----------------------------------------------------------
DECLARE @Old_ItemData INT
SELECT @Old_ItemData = Data FROM _ITEMS WHERE ID64 = @ItemID_From
IF (@Old_ItemData ISNOTNULLAND @Old_ItemData <> @Data)
BEGIN
UPDATE _Items SET Data = @Data WHERE ID64 = @ItemID_From
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-4
END
END
----------------------------------------------------------
-- Step4. COMMIT
----------------------------------------------------------
COMMITTRANSACTION
RETURN 1
arkadaslar bu proceduredeki -1006 ile ilgili hata.düzenled,m ama olmadı::S
Genişletmek için tıkla ...

eminmisin bura olduğuna
 
coskun4444' Alıntı:
item bug olayını hala çözemedim ama sorunun nerede olduğunu sanırım buldum USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_STRG_MOVE_ITEM] Script Date: 09/17/2011 11:40:57 ******/
SETANSI_NULLSON
GO
SETQUOTED_IDENTIFIERON
GO
--------------------------------------------------------------------------------------------------------------------------
-- PROC #3
-- _STRG_MOVE_ITEM ! - by zone0000 ()
--------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------
-- _STRG_MOVE_ITEM Operation(35)(36) ()
-----------------------------------------------------------------
ALTERPROCEDURE [dbo].[_STRG_MOVE_ITEM]
@Operation ASTINYINT,
@UserJID ASINT,
@CharID ASINT,
@GuildID ASBIGINT,-- Operation 39, 40 LinkedItemID .
@Slot_From ASTINYINT,
@Slot_To ASTINYINT,
@Data ASINT,-- 0 .
@RemoveAndOverwrite ASTINYINT
AS
----------------
-- SP_UPDATE_SLOTS_INV 0
-- SP_UPDATE_SLOTS_CHEST 1
-- SP_DEPOSIT_ITEM 2
-- SP_WITHDRAW_ITEM 3
-- SP_UPDATE_SLOTS_INV_COS 16
-- SP_GUILD_CHEST_UPDATE_SLOT 29
-- SP_GUILD_CHEST_DEPOSIT_ITEM 30
-- SP_GUILD_CHEST_WITHDRAW_ITEM 31
-- SP_MOVE_ITEM_AVATAR_PC 35 -- Avatar
-- SP_MOVE_ITEM_PC_AVATAR 36 -- Avatar
-- SP_PUSH_ITEM_INTO_MAGIC_CUBE 39 -- MagicCube
-- SP_POP_ITEM_FROM_MAGIC_CUBE 40 -- MagicCube
----------------
IF (@Operation <> 0 AND @Operation <> 1 AND @Operation <> 2 AND @Operation <> 3 AND @Operation <> 16 AND @Operation <> 29 AND @Operation <> 30 AND @Operation <> 31
AND @Operation <> 35 AND @Operation <> 36 -- Avatar
AND @Operation <> 39 AND @Operation <> 40 )-- MagicCube
BEGIN
RETURN-1000
END
-- overwrite inventory ( reloading)
IF (@RemoveAndOverwrite <> 0 AND @Operation <> 0)
BEGIN
RETURN-1001
END
DECLARE @ItemID_From BIGINT
DECLARE @ItemID_To BIGINT
SET @ItemID_From = 0
SET @ItemID_To = 0
----------------------------------------------------------
-- Step1. Src Slot Dst Slot
----------------------------------------------------------
-------------- Src Item
IF (@Operation = 0 OR @Operation = 2 OR @Operation = 30)-- src: inventory
BEGIN
SELECT @ItemID_From = ItemID FROM _Inventory WHERE CharID = @CharID AND Slot = @Slot_From
END
ELSEIF (@Operation = 1 OR @Operation = 3)-- src: chest
BEGIN
SELECT @ItemID_From = ItemID FROM _Chest WHERE UserJID = @UserJID AND Slot = @Slot_From
END
ELSEIF (@Operation = 16)
BEGIN
SELECT @ItemID_From = ItemID FROM _InvCOS WHERE COSID = @CharID AND Slot = @Slot_From
END
ELSEIF (@Operation = 29 OR @Operation = 31)
BEGIN
SELECT @ItemID_From = ItemID FROM _GuildChest WHERE GuildID = @GuildID AND Slot = @Slot_From
END
-- Avatar ( Avatar -> PC )
ELSEIF (@Operation = 35)
BEGIN
SELECT @ItemID_From = ItemID FROM _InventoryForAvatar WHERE CharID = @CharID AND Slot = @Slot_From
END
-- Avatar ( PC -> Avatar )
ELSEIF (@Operation = 36)
BEGIN
SELECT @ItemID_From = ItemID FROM _Inventory WHERE CharID = @CharID AND Slot = @Slot_From
END
-- MagicCube ( PCInv -> MagicCube )
ELSEIF (@Operation = 39)
BEGIN
SELECT @ItemID_From = ItemID FROM _Inventory WHERE CharID = @CharID AND Slot = @Slot_From
END
-- MagicCube ( MagicCube -> PCInv )
ELSEIF (@Operation = 40)
BEGIN
SELECT @ItemID_From = ItemID FROM _InventoryForLinkedStorage WHERE LinkedItemID = @GuildID AND Slot = @Slot_From
END
-------------- Dst Item
IF (@Operation = 0 OR @Operation = 3 OR @Operation = 31)-- dst: inventory
BEGIN
SELECT @ItemID_To = ItemID FROM _Inventory WHERE CharID = @CharID AND Slot = @Slot_To
END
ELSEIF (@Operation = 1 OR @Operation = 2)-- dst: chest
BEGIN
SELECT @ItemID_To = ItemID FROM _Chest WHERE UserJID = @UserJID AND Slot = @Slot_To
END
ELSEIF (@Operation = 16)
BEGIN
SELECT @ItemID_To = ItemID FROM _InvCOS WHERE COSID = @CharID AND Slot = @Slot_To
END
ELSEIF (@Operation = 29 OR @Operation = 30)
BEGIN
SELECT @ItemID_To = ItemID FROM _GuildChest WHERE GuildID = @GuildID AND Slot = @Slot_To
END
-- Avatar ( Avatar -> PC )
ELSEIF (@Operation = 35)
BEGIN
SELECT @ItemID_To = ItemID FROM _Inventory WHERE CharID = @CharID AND Slot = @Slot_To
END
-- Avatar ( PC -> Avatar )
ELSEIF (@Operation = 36)
BEGIN
SELECT @ItemID_To = ItemID FROM _InventoryForAvatar WHERE CharID = @CharID AND Slot = @Slot_To
END
-- MagicCube ( PCInv -> MagicCube )
ELSEIF (@Operation = 39)
BEGIN
SELECT @ItemID_To = ItemID FROM _InventoryForLinkedStorage WHERE LinkedItemID = @GuildID AND Slot = @Slot_To
END
-- MagicCube ( MagicCube -> PCInv )
ELSEIF (@Operation = 40)
BEGIN
SELECT @ItemID_To = ItemID FROM _Inventory WHERE CharID = @CharID AND Slot = @Slot_To
END
--------------
IF (@RemoveAndOverwrite <> 0)
BEGIN
-- .
IF (@ItemID_From ISNULLOR @ItemID_To ISNULL)
BEGIN
RETURN-1003
END
IF (@ItemID_From = 0 OR @ItemID_To = 0)
BEGIN
RETURN-1004
END
END
ELSE
BEGIN
-- Source .
IF (@ItemID_From ISNULLOR @ItemID_From = 0)
BEGIN
RETURN-1005
END
IF (@ItemID_To ISNOTNULLAND @ItemID_To <> 0)
BEGIN
RETURN-1006
END
END
IF (@Operation = 0)
BEGIN
IF (@Slot_To < 13)
BEGIN
DECLARE @CheckValidity INT
EXEC @CheckValidity = _STRG_CHECKITEM_CANBE_EQUIPED@ItemID_From, @Slot_To
IF (@CheckValidity <= 0)
BEGIN
RETURN @CheckValidity
END
END
END
BEGINTRANSACTION
----------------------------------------------------------
-- Step2. Storage
----------------------------------------------------------
-------------- Src Slot
IF (@Operation = 0 OR @Operation = 2 OR @Operation = 30)
BEGIN
UPDATE _Inventory SET ItemID = 0 WHERE CharID = @CharID AND Slot = @Slot_From
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-2
END
END
ELSEIF (@Operation = 1 OR @Operation = 3)
BEGIN
UPDATE _Chest SET ItemID = 0 WHERE UserJID = @UserJID AND Slot = @Slot_From
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-2
END
END
ELSEIF (@Operation = 16)
BEGIN
UPDATE _InvCOS SET ItemID = 0 WHERE COSID = @CharID AND Slot = @Slot_From
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-2
END
END
ELSEIF (@Operation = 29 OR @Operation = 31)
BEGIN
UPDATE _GuildChest SET ItemID = 0 WHERE GuildID = @GuildID AND Slot = @Slot_From
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-2
END
END
-- Avatar ( Avatar -> PC )
ELSEIF (@Operation = 35 )
BEGIN
UPDATE _InventoryForAvatar SET ItemID = 0 WHERE CharID = @CharID AND Slot = @Slot_From
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-2
END
END
-- Avatar ( PC -> Avatar )
ELSEIF (@Operation = 36 )
BEGIN
UPDATE _Inventory SET ItemID = 0 WHERE CharID = @CharID AND Slot = @Slot_From
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-2
END
END
-- MagicCube ( PCInv -> MagicCube )
ELSEIF (@Operation = 39 )
BEGIN
UPDATE _Inventory SET ItemID = 0 WHERE CharID = @CharID AND Slot = @Slot_From
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-2
END
END
-- MagicCube ( MagicCube -> PCInv )
ELSEIF (@Operation = 40 )
BEGIN
UPDATE _InventoryForLinkedStorage SET ItemID = 0 WHERE LinkedItemID = @GuildID AND Slot = @Slot_From
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-2
END
END
-------------- Dst Slot
IF (@Operation = 0 OR @Operation = 3 OR @Operation = 31)
BEGIN
UPDATE _Inventory SET ItemID = @ItemID_From WHERE CharID = @CharID AND Slot = @Slot_To
END
ELSEIF (@Operation = 1 OR @Operation = 2)
BEGIN
UPDATE _Chest SET ItemID = @ItemID_From WHERE UserJID = @UserJID AND Slot = @Slot_To
END
ELSEIF (@Operation = 16)
BEGIN
UPDATE _InvCOS SET ItemID = @ItemID_From WHERE COSID = @CharID AND Slot = @Slot_To
END
ELSEIF (@Operation = 29 OR @Operation = 30)
BEGIN
UPDATE _GuildChest SET ItemID = @ItemID_From WHERE GuildID = @GuildID AND Slot = @Slot_To
END
-- Avatar ( Avatar -> PC )
ELSEIF (@Operation = 35)
BEGIN
UPDATE _Inventory SET ItemID = @ItemID_From WHERE CharID = @CharID AND Slot = @Slot_To
END
-- Avatar ( PC -> Avatar )
ELSEIF (@Operation = 36)
BEGIN
UPDATE _InventoryForAvatar SET ItemID = @ItemID_From WHERE CharID = @CharID AND Slot = @Slot_To
END
-- MagicCube ( PCInv -> MagicCube )
ELSEIF (@Operation = 39)
BEGIN
UPDATE _InventoryForLinkedStorage SET ItemID = @ItemID_From WHERE LinkedItemID = @GuildID AND Slot = @Slot_To
END
-- MagicCube ( MagicCube -> PCInv )
ELSEIF (@Operation = 40)
BEGIN
UPDATE _Inventory SET ItemID = @ItemID_From WHERE CharID = @CharID AND Slot = @Slot_To
END
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-3
END
----------------------------------------------------------
-- Step3. Overwrite !
----------------------------------------------------------
IF (@RemoveAndOverwrite <> 0)
BEGIN
DECLARE @Rvalue INT
EXEC @Rvalue = _STRG_FREE_ITEM_NoTX@ItemID_To
IF (@Rvalue < 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-4
END
END
----------------------------------------------------------
-- Step4. 4Byte Item Data ( !)
----------------------------------------------------------
DECLARE @Old_ItemData INT
SELECT @Old_ItemData = Data FROM _ITEMS WHERE ID64 = @ItemID_From
IF (@Old_ItemData ISNOTNULLAND @Old_ItemData <> @Data)
BEGIN
UPDATE _Items SET Data = @Data WHERE ID64 = @ItemID_From
IF (@@ROWCOUNT= 0 OR@@ERROR<> 0)
BEGIN
ROLLBACKTRANSACTION
RETURN-4
END
END
----------------------------------------------------------
-- Step4. COMMIT
----------------------------------------------------------
COMMITTRANSACTION
RETURN 1
arkadaslar bu proceduredeki -1006 ile ilgili hata.düzenled,m ama olmadı::S
Genişletmek için tıkla ...

İyi Hoşta Böyle bir Table yokki :S
 
-Teleport bugunu çözün bakalım accos sw den hepsini 0 yaptırdınız teleport olmuyor velet :D eu hariç hepsini açtım kasma yok deneyin oyunada alıyor hepside aktif :)

bunu geçtik - + basma özelliginde bug var max +8 oluyor db de 8 e kadar kodlanmış bu DB ler eksik cherno tamamını vermedi çok fazla geliştirilmesi lazım adam bizi ugraştırıyor resmen :S
 
darkanqel1' Alıntı:


sende beni ekle ö.m atıyorum yoksa görunmuor msn
Genişletmek için tıkla ...

bak dediğini yapıyorum ama bu hata var sen oraları doldurmamışsın 9. satır doldurmadan olmuyor işte bende orda hata yapıyrum Fatal error: Call to undefined function mssql_connect() in C:\AppServ\www\_inc\config.php on line 9
 
Vsro Dosyaları Hakkında Reklam,satış,rehber vb. konu ve mesajlar yasak!
 
Moderatörün son düzenlenenleri:
akbaba12' Alıntı:
bak dediğini yapıyorum ama bu hata var sen oraları doldurmamışsın 9. satır doldurmadan olmuyor işte bende orda hata yapıyrum Fatal error: Call to undefined function mssql_connect() in C:\AppServ\www\_inc\config.php on line 9
Genişletmek için tıkla ...

APP server yerine bir öneri olarakta sistemine PHP kurup fast CGI ile ilişkilendirebilirsin ve direk çalıştırabilirsin...
 
Bu sefer GameServer ilk actıktantan 20 saniye sonra kapanıyor ve halen SHARD MANAGER VE GAME SERVERDA database Connection Failed hatası var cozumu olan varmı :D
 
silkroadhosting' Alıntı:
Evet arkadaşlar Silkroad Server kurulumu yapıyoruz.Dedicated serverlerimiz bulunmaktadır!
INTEL E-3 1240
*Intel Quad Xeon e-3 1240 Cpu(13.6 Ghz 8mb Cache(8 çekirdek)
*8 gb ddr3 bellek
*2x500 gb 7.2k RPM NLS Disk
*1 Gbit TTNET Port
*IP KVM(Intel RMM)
*Windows ve Linux isletim sistemi(Windows Opsiyonel)
*3 Tb Aylık Trafik Kotası

Kurulum+Dedicated 200 TL

İsteyenlere daha ii özellikte Dedicated Server Kiralanır Server Kapasitesi 1000 kisi rahat kaldırır!

İsteyene sadece server kurulumda yapılır.
İletişim:toyzor@hotmail.com
Genişletmek için tıkla ...

TTnet ne zamandan beri dedicated başına 1 gbit vermeye izin veriyor acaba çok merak ediyorum...
 
Cert açılıp kapanıyor çözümü bulamadım
Resimler
sQGNo.jpg


xLd1D.jpg
 
Konuya cevap yazabilmek için giriş yapmanız veya üye olmanız gerekmektedir.

Benzer Konular

Black Pearl - Nautilius (07.09.2012)
15 16 17
Cevaplar
337
Görüntüleme
37K
-UnstoppabLe
-UnstoppabLe
PsychosociaI
Esro 1-6 Yeni İndirme Linkleri Elite 4 Açıldı 110Cap
2
Cevaplar
21
Görüntüleme
6K
lotleynek
Orjinal Vsro Server Files (Sonunda Yayınlandı.)
Cevaplar
0
Görüntüleme
2K
StrawBerry
Black Pearl Online - Download (11.06.2012)
12 13 14
Cevaplar
275
Görüntüleme
101K
Zenginefe
Zenginefe
TheKnightElf
  • Kilitli
EROAD Sroking Download (Güncelleme Tarihi : 24 Ocak 2012 )
Cevaplar
0
Görüntüleme
3K
TheKnightElf
TheKnightElf
Geri
Üst