Hoş Geldin, Ziyaretçi!

Forum içeriğine ve tüm hizmetlerimize erişim sağlamak için foruma kayıt olmalı ya da giriş yapmalısınız. Foruma üye olmak tamamen ücretsizdir.

Giriş yapŞimdi kayıt ol
dsgn kguard
ROLLET remastered
vsupload kguardedgeakademi
cleopatra legacy
ecr-online boş reklam

vSRO Çözüldü Vsro Orjinal Ünvanları Bozmadan Yeni title nasıl eklerim ?

A

angelofdeath

.
.
Katılım
7 Ara 2023
Mesajlar
3
Alınan Beğeni
0
Ödül Puanları
1
Konum
İstanbul
Bu kullanıcıyla bir anlaşma yapmak istiyorsanız, bu forumdan uzaklaştırıldığını lütfen unutmayın.
Merhaba.. Orijinal ünvanları bozmadan title eklemeye çalışıyorum fakat title ünvanı gelmiyor, reverse vs. çekiyor

Tablolar

Addlogitem

USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 9.12.2023 01:39:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤
-- DataBase : Shard Log
ALTER procedure [dbo].[_AddLogItem]
@CharID int,
@ItemRefID int,
@ItemSerial bigint,
@dwData int,
@TargetStorage tinyint,
@Operation tinyint,
@Slot_From tinyint,
@Slot_To tinyint,
@EventPos varchar(64),
@strDesc varchar(128),
@Gold bigint -- #ifdef EXTEND_GOLD_TYPE »ğÀÔ
as
declare @len_pos int
declare @len_desc int
set @len_pos = len(@EventPos)
set @len_desc = len(@strDesc)
if (@len_pos > 0 and @len_desc > 0)
begin
return -1
end
else if (@len_pos > 0 and @len_desc = 0)
begin
return -1
end
else if (@len_pos = 0 and @len_desc > 0)
begin
return -1
end
else if (@len_pos = 0 and @len_desc = 0)
begin
return -1
end
-- À¯·á ¾ÆÀÌÅÛ ±¸ÀÔÀ̸é!
-- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35
if (@Operation = 35)
begin
return -1
end
if (@Operation = 41) and (@ItemRefID = 41803) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 7 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41804) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 8 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41805) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 9 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41806) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 10 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41807) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 11 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41808) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 12 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41809) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 13 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41810) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 14 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41811) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 15 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41812) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 16 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41813) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 17 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41814) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 18 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41815) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 19 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41816) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 20 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41817) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 21 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41818) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 22 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41819) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 23 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41820) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 24 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41821) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 25 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41822) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 26 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41823) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 27 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41824) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 28 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41825) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 29 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41826) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 30 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41827) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 31 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41828) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 32 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41829) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 33 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41830) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 34 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41831) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 35 where CharID = @charID end
if (@Operation = 41) and (@ItemRefID = 41832) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 36 where CharID = @charID end



Hwanlevel

0 1397769301 200 0 0 0 0 0 0 0 0 xxx xxx xxx
1 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_1 UIO_SECOND_HWAN_EU_NAME_LEVEL_1
2 1397769301 200 1145127506 15 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_2 UIO_SECOND_HWAN_EU_NAME_LEVEL_2
3 1397769301 200 1145127506 20 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_3 UIO_SECOND_HWAN_EU_NAME_LEVEL_3
4 1397769301 200 1145127506 25 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_4 UIO_SECOND_HWAN_EU_NAME_LEVEL_4
5 1397769301 200 1145127506 30 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_5 UIO_SECOND_HWAN_EU_NAME_LEVEL_5
6 1397769301 200 1145127506 35 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_6 UIO_SECOND_HWAN_EU_NAME_LEVEL_6
7 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_7 UIO_SECOND_HWAN_EU_NAME_LEVEL_7
8 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_8 UIO_SECOND_HWAN_EU_NAME_LEVEL_8
9 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_9 UIO_SECOND_HWAN_EU_NAME_LEVEL_9
10 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_10 UIO_SECOND_HWAN_EU_NAME_LEVEL_10
11 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_11 UIO_SECOND_HWAN_EU_NAME_LEVEL_11
12 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_12 UIO_SECOND_HWAN_EU_NAME_LEVEL_12
13 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_13 UIO_SECOND_HWAN_EU_NAME_LEVEL_13
14 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_14 UIO_SECOND_HWAN_EU_NAME_LEVEL_14
15 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_15 UIO_SECOND_HWAN_EU_NAME_LEVEL_15
16 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_16 UIO_SECOND_HWAN_EU_NAME_LEVEL_16
17 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_17 UIO_SECOND_HWAN_EU_NAME_LEVEL_17
18 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_18 UIO_SECOND_HWAN_EU_NAME_LEVEL_18
19 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_19 UIO_SECOND_HWAN_EU_NAME_LEVEL_19
20 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_20 UIO_SECOND_HWAN_EU_NAME_LEVEL_20
21 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_21 UIO_SECOND_HWAN_EU_NAME_LEVEL_21
22 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_22 UIO_SECOND_HWAN_EU_NAME_LEVEL_22
23 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_23 UIO_SECOND_HWAN_EU_NAME_LEVEL_23
24 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_24 UIO_SECOND_HWAN_EU_NAME_LEVEL_24
25 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_25 UIO_SECOND_HWAN_EU_NAME_LEVEL_25
26 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_26 UIO_SECOND_HWAN_EU_NAME_LEVEL_26
27 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_27 UIO_SECOND_HWAN_EU_NAME_LEVEL_27
28 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_28 UIO_SECOND_HWAN_EU_NAME_LEVEL_28
29 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_29 UIO_SECOND_HWAN_EU_NAME_LEVEL_29
30 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_30 UIO_SECOND_HWAN_EU_NAME_LEVEL_30
31 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_31 UIO_SECOND_HWAN_EU_NAME_LEVEL_31
32 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_32 UIO_SECOND_HWAN_EU_NAME_LEVEL_32
33 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_33 UIO_SECOND_HWAN_EU_NAME_LEVEL_33
34 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_34 UIO_SECOND_HWAN_EU_NAME_LEVEL_34
35 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_35 UIO_SECOND_HWAN_EU_NAME_LEVEL_35
36 1397769301 200 1145127506 10 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_36 UIO_SECOND_HWAN_EU_NAME_LEVEL_36
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL



Objcommon

1 41803 ITEM_TITLE_SCROLL7 Title xxx SN_ITEM_TITLE_SCROLL7 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21335
1 41804 ITEM_TITLE_SCROLL8 Title xxx SN_ITEM_TITLE_SCROLL8 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21336
1 41805 ITEM_TITLE_SCROLL9 Title xxx SN_ITEM_TITLE_SCROLL9 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21337
1 41806 ITEM_TITLE_SCROLL10 Title xxx SN_ITEM_TITLE_SCROLL10 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21338
1 41807 ITEM_TITLE_SCROLL11 Title xxx SN_ITEM_TITLE_SCROLL11 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21339
1 41808 ITEM_TITLE_SCROLL12 Title xxx SN_ITEM_TITLE_SCROLL12 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21340
1 41809 ITEM_TITLE_SCROLL13 Title xxx SN_ITEM_TITLE_SCROLL13 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21341
1 41810 ITEM_TITLE_SCROLL14 Title xxx SN_ITEM_TITLE_SCROLL14 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21342
1 41811 ITEM_TITLE_SCROLL15 Title xxx SN_ITEM_TITLE_SCROLL15 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21343
1 41812 ITEM_TITLE_SCROLL16 Title xxx SN_ITEM_TITLE_SCROLL16 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21344
1 41813 ITEM_TITLE_SCROLL17 Title xxx SN_ITEM_TITLE_SCROLL17 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21345
1 41814 ITEM_TITLE_SCROLL18 Title xxx SN_ITEM_TITLE_SCROLL18 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21346
1 41815 ITEM_TITLE_SCROLL19 Title xxx SN_ITEM_TITLE_SCROLL19 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21347
1 41816 ITEM_TITLE_SCROLL20 Title xxx SN_ITEM_TITLE_SCROLL20 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21348
1 41817 ITEM_TITLE_SCROLL21 Title xxx SN_ITEM_TITLE_SCROLL21 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21349
1 41818 ITEM_TITLE_SCROLL22 Title xxx SN_ITEM_TITLE_SCROLL22 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21350
1 41819 ITEM_TITLE_SCROLL23 Title xxx SN_ITEM_TITLE_SCROLL23 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21351
1 41820 ITEM_TITLE_SCROLL24 Title xxx SN_ITEM_TITLE_SCROLL24 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21352
1 41821 ITEM_TITLE_SCROLL25 Title xxx SN_ITEM_TITLE_SCROLL25 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21353
1 41822 ITEM_TITLE_SCROLL26 Title xxx SN_ITEM_TITLE_SCROLL26 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21354
1 41823 ITEM_TITLE_SCROLL27 Title xxx SN_ITEM_TITLE_SCROLL27 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21355
1 41824 ITEM_TITLE_SCROLL28 Title xxx SN_ITEM_TITLE_SCROLL28 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21356
1 41825 ITEM_TITLE_SCROLL29 Title xxx SN_ITEM_TITLE_SCROLL29 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21357
1 41826 ITEM_TITLE_SCROLL30 Title xxx SN_ITEM_TITLE_SCROLL30 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21358
1 41827 ITEM_TITLE_SCROLL31 Title xxx SN_ITEM_TITLE_SCROLL31 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21359
1 41828 ITEM_TITLE_SCROLL32 Title xxx SN_ITEM_TITLE_SCROLL32 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21360
1 41829 ITEM_TITLE_SCROLL33 Title xxx SN_ITEM_TITLE_SCROLL33 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21361
1 41830 ITEM_TITLE_SCROLL34 Title xxx SN_ITEM_TITLE_SCROLL34 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21362
1 41831 ITEM_TITLE_SCROLL35 Title xxx SN_ITEM_TITLE_SCROLL35 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21363
1 41832 ITEM_TITLE_SCROLL36 Title xxx SN_ITEM_TITLE_SCROLL36 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21364




Objitem

1 41803 ITEM_TITLE_SCROLL7 Title xxx SN_ITEM_TITLE_SCROLL7 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21335
1 41804 ITEM_TITLE_SCROLL8 Title xxx SN_ITEM_TITLE_SCROLL8 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21336
1 41805 ITEM_TITLE_SCROLL9 Title xxx SN_ITEM_TITLE_SCROLL9 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21337
1 41806 ITEM_TITLE_SCROLL10 Title xxx SN_ITEM_TITLE_SCROLL10 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21338
1 41807 ITEM_TITLE_SCROLL11 Title xxx SN_ITEM_TITLE_SCROLL11 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21339
1 41808 ITEM_TITLE_SCROLL12 Title xxx SN_ITEM_TITLE_SCROLL12 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21340
1 41809 ITEM_TITLE_SCROLL13 Title xxx SN_ITEM_TITLE_SCROLL13 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21341
1 41810 ITEM_TITLE_SCROLL14 Title xxx SN_ITEM_TITLE_SCROLL14 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21342
1 41811 ITEM_TITLE_SCROLL15 Title xxx SN_ITEM_TITLE_SCROLL15 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21343
1 41812 ITEM_TITLE_SCROLL16 Title xxx SN_ITEM_TITLE_SCROLL16 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21344
1 41813 ITEM_TITLE_SCROLL17 Title xxx SN_ITEM_TITLE_SCROLL17 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21345
1 41814 ITEM_TITLE_SCROLL18 Title xxx SN_ITEM_TITLE_SCROLL18 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21346
1 41815 ITEM_TITLE_SCROLL19 Title xxx SN_ITEM_TITLE_SCROLL19 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21347
1 41816 ITEM_TITLE_SCROLL20 Title xxx SN_ITEM_TITLE_SCROLL20 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21348
1 41817 ITEM_TITLE_SCROLL21 Title xxx SN_ITEM_TITLE_SCROLL21 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21349
1 41818 ITEM_TITLE_SCROLL22 Title xxx SN_ITEM_TITLE_SCROLL22 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21350
1 41819 ITEM_TITLE_SCROLL23 Title xxx SN_ITEM_TITLE_SCROLL23 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21351
1 41820 ITEM_TITLE_SCROLL24 Title xxx SN_ITEM_TITLE_SCROLL24 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21352
1 41821 ITEM_TITLE_SCROLL25 Title xxx SN_ITEM_TITLE_SCROLL25 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21353
1 41822 ITEM_TITLE_SCROLL26 Title xxx SN_ITEM_TITLE_SCROLL26 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21354
1 41823 ITEM_TITLE_SCROLL27 Title xxx SN_ITEM_TITLE_SCROLL27 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21355
1 41824 ITEM_TITLE_SCROLL28 Title xxx SN_ITEM_TITLE_SCROLL28 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21356
1 41825 ITEM_TITLE_SCROLL29 Title xxx SN_ITEM_TITLE_SCROLL29 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21357
1 41826 ITEM_TITLE_SCROLL30 Title xxx SN_ITEM_TITLE_SCROLL30 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21358
1 41827 ITEM_TITLE_SCROLL31 Title xxx SN_ITEM_TITLE_SCROLL31 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21359
1 41828 ITEM_TITLE_SCROLL32 Title xxx SN_ITEM_TITLE_SCROLL32 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21360
1 41829 ITEM_TITLE_SCROLL33 Title xxx SN_ITEM_TITLE_SCROLL33 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21361
1 41830 ITEM_TITLE_SCROLL34 Title xxx SN_ITEM_TITLE_SCROLL34 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21362
1 41831 ITEM_TITLE_SCROLL35 Title xxx SN_ITEM_TITLE_SCROLL35 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21363
1 41832 ITEM_TITLE_SCROLL36 Title xxx SN_ITEM_TITLE_SCROLL36 SN_ITEM_TITLE_SCROLL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\scroll_return_thiefden_01.ddj xxx xxx 21364

Yardımlarınızı bekliyorum
 
Çözüm
SaltanatNaibi
SQL:
İçeriği görebilmek için Uye olmanız gerekiyor.

bu şekilde bir degişken oluşturup bu degişkeni UPDATE yapacak komuta ekleyebilirsin @CharIDTitle olarak
Üst üste post gönderildiği için tek mesajda birleştirildi:

Yada bir prosedür yazabilirsin bu prosedürüde Log veritabanında EXEC ile çagırabilirsin bu prosedürün içerisini SubQuerylerini eklersin yapılacak çok yol var
Tarihe göre sırala Oylara göre sırala
SaltanatNaibi

SaltanatNaibi

VSRO / SQL Server / PK2 Edit / Cyber Security /
.
.
Katılım
19 Ara 2018
Mesajlar
1,185
Çözümler
5
Alınan Beğeni
622
Ödül Puanları
113
Konum
/ Kali/Linux /
Bu kullanıcıyla bir anlaşma yapmak istiyorsanız, bu forumdan uzaklaştırıldığını lütfen unutmayın.
@charID kısmını @CharID olarak degiştirin fakat bu böyle olmaz bu şekilde çok yorar
Üst üste post gönderildiği için tek mesajda birleştirildi:

Birde char ID için bir girdi yok orda

DECLARE @CharName VARCHAR(64)=(SELECT CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] WITH (NOLOCK) WHERE CharID=@CharID)

bu şekilde eklenmesi gerekiyor
Üst üste post gönderildiği için tek mesajda birleştirildi:

Attıgım örnek CharID yi alman lazım ben charname16 yı aldım burda
 
Oyla 0
Thor852

Thor852

Love and Thunder
Elite
.
Katılım
22 Tem 2023
Mesajlar
437
Çözümler
1
Alınan Beğeni
1,338
Ödül Puanları
93
Konum
İstanbul
SaltanatNaibi' Alıntı:
@charID kısmını @CharID olarak degiştirin fakat bu böyle olmaz bu şekilde çok yorar
Üst üste post gönderildiği için tek mesajda birleştirildi:

Birde char ID için bir girdi yok orda

DECLARE @CharName VARCHAR(64)=(SELECT CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] WITH (NOLOCK) WHERE CharID=@CharID)

bu şekilde eklenmesi gerekiyor
Üst üste post gönderildiği için tek mesajda birleştirildi:

Attıgım örnek CharID yi alman lazım ben charname16 yı aldım burda
Genişletmek için tıkla ...
Cevap için teşekkürler

Ek olark orjinalleri bozmadan devam etmek istiyorsan eklemelerini 4 ten sonra yap iyi forumlar
 
Oyla 0
A

angelofdeath

.
.
Katılım
7 Ara 2023
Mesajlar
3
Alınan Beğeni
0
Ödül Puanları
1
Konum
İstanbul
Bu kullanıcıyla bir anlaşma yapmak istiyorsanız, bu forumdan uzaklaştırıldığını lütfen unutmayın.
SaltanatNaibi' Alıntı:
charID kısmını @CharID olarak degiştirin fakat bu böyle olmaz bu şekilde çok yorar
Genişletmek için tıkla ...
Ne yapabiliriz bunun olmaması için ?
Üst üste post gönderildiği için tek mesajda birleştirildi:

Thor852' Alıntı:
Cevap için teşekkürler

Ek olark orjinalleri bozmadan devam etmek istiyorsan eklemelerini 4 ten sonra yap iyi forumlar
Genişletmek için tıkla ...
Merhaba bende 6 olarak düşündüm sonrasına ekledim, sanırım düzeltmeye gerek yok silmedim ayarlarıyla oynamadım
 
Oyla 0
SaltanatNaibi

SaltanatNaibi

VSRO / SQL Server / PK2 Edit / Cyber Security /
.
.
Katılım
19 Ara 2018
Mesajlar
1,185
Çözümler
5
Alınan Beğeni
622
Ödül Puanları
113
Konum
/ Kali/Linux /
Bu kullanıcıyla bir anlaşma yapmak istiyorsanız, bu forumdan uzaklaştırıldığını lütfen unutmayın.
SQL:
İçeriği görebilmek için Uye olmanız gerekiyor.

bu şekilde bir degişken oluşturup bu degişkeni UPDATE yapacak komuta ekleyebilirsin @CharIDTitle olarak
Üst üste post gönderildiği için tek mesajda birleştirildi:

Yada bir prosedür yazabilirsin bu prosedürüde Log veritabanında EXEC ile çagırabilirsin bu prosedürün içerisini SubQuerylerini eklersin yapılacak çok yol var
 
Oyla 0
Çözüm
A

angelofdeath

.
.
Katılım
7 Ara 2023
Mesajlar
3
Alınan Beğeni
0
Ödül Puanları
1
Konum
İstanbul
Bu kullanıcıyla bir anlaşma yapmak istiyorsanız, bu forumdan uzaklaştırıldığını lütfen unutmayın.
SaltanatNaibi' Alıntı:
SQL:
İçeriği görebilmek için Uye olmanız gerekiyor.

bu şekilde bir degişken oluşturup bu degişkeni UPDATE yapacak komuta ekleyebilirsin @CharIDTitle olarak
Üst üste post gönderildiği için tek mesajda birleştirildi:

Yada bir prosedür yazabilirsin bu prosedürüde Log veritabanında EXEC ile çagırabilirsin bu prosedürün içerisini SubQuerylerini eklersin yapılacak çok yol var
Genişletmek için tıkla ...
Title sorunum çözüldü, db yorulmaması için proceduru nasıl yapacağımı dusunuyorum
 
Oyla 0
Cevap yazmak için giriş yap yada kayıt ol.
  Benzer konular Forum Tarih
vSRO Yardım Vsro Panel Kurulumu Hakkında VSRO Panel Sorunları ve Çözümleri 8 172
vSRO Çözüldü How VSRO adjusts taxes VSRO Özel İstek ve Çözümleri 3 104
vSRO Paylaşım vSRO Weapon Stat Editor VSRO Paylaşımları 2 88
vSRO Çözüldü Arkadaşlar vsro orjinal görseller lazım Çözümlenen Sorun Başlıkları 9 589
vSRO Çözüldü VSRO Orjinal Drop Rate Ayarlama Çözümlenen Sorun Başlıkları 13 2K

Benzer konular

Konular

10.2K

Mesajlar

120.3K

Kullanıcılar

10.1K

Son üye

kaelthasro

Uyarı
vSRO.ORG; 5651 Sayılı Kanun kapsamında BTK tarafından onaylı Yer Sağlayıcı'dır. Bu sebeple içerikleri kontrol etme ya da araştırma yükümlülüğü yoktur. Hukuka ve mevzuata aykırı olduğunu düşündüğünüz içeriği BURADAN bildirebilirsiniz. İletişime geçilmesi halinde ilgili kanunlar ve yönetmelikler çerçevesinde gerekli işlemler yapılacaktır.
Community platform by XenForo® © 2010-2021 XenForo Ltd.
XenForo Style eTiKeT™ 2020
XenForo 2 Türkçe 🇹🇷 eTiKeT™ 2021
Tepki lideri konular
AdBlock Detected

Anlıyoruz, reklamlar can sıkıcı!

Elbette, reklam engelleme yazılımı reklamları engellemede harika bir iş çıkarır, ancak aynı zamanda web sitemizin faydalı özelliklerini de engeller. En iyi site deneyimi için lütfen AdBlocker'ınızı devre dışı bırakın.

AdBlock'u Devre Dışı Bıraktım.