cast or convert invalid attributes specified for type 'int'

DeLLyReis

Kayıtlı Üye
Katılım
5 Şubat 2014
Mesajlar
428
Reaction score
0
Puanları
16
Yaş
27
Web sitesi
pvp-time.com
Başlıkta da belirttiğim gibi ; cast or convert invalid attributes specified for type 'int'



hatası alıyorum.. Nasııl düzeltebilirim ?
 
Cevap: cast or convert invalid attributes specified for type 'int'



database in ile kullandığın invantory editör uyumsuz.

prosedür girmen gerekli fakat muhtemelen işe yaramayacak o yüzden db ara
 
Cevap: cast or convert invalid attributes specified for type 'int'



Şuan kullandığım tarzda database bulamam :/

Kod var mı elinde şansımı deniyeyim yinede ?
 
Cevap: cast or convert invalid attributes specified for type 'int'



Yardım konularında daha önce paylaştığım kodlar vardı forumda bu tarz konular var bakarsan bulursun..
 
Cevap: cast or convert invalid attributes specified for type 'int'



sql 2008 ve üstü ise bildiğim kadarıyla '' int '' yerine '' str '' geçiyordu forumda bunun açıklaması olcaktı dostum
 
Cevap: cast or convert invalid attributes specified for type 'int'



var olan item_bul prosedürünü silip bunu yükleyin



Kod:
CREATE procedure itemleri_bul

@StrUserID varchar(30)

AS

DECLARE

@length int, -- stritem uzunlugu

@i int, -- item'in stritem deki yeri

@dwid int,

@dur int,

@duar int,

@StackSize1 int,

@Sira int,

@Row int,

@name varchar(100),

@extname varchar(100),

@ext int





set @i = 14*0+1

set @length = 401



select @row=count(*) from userdata where struserid=@StrUserID



delete from itemler where struserid=@StrUserID



if @row>0

begin



WHILE @i < @length

Begin



Select @dwid=cast(cast(substring(cast(substring(strItem, @i,4) as varbinary(4)), 4,1)+substring(cast(substring(strItem, @i,4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, @i,4) as varbinary(4)), 2, 1)+substring(cast(substring(strItem, @i,4) as varbinary(4)), 1, 1) as varbinary(4)) as int), 

@dur = cast(cast(cast( substring(strItem, @i+5, 1) as varbinary(1))+cast(substring(strItem, @i+4, 1) as

varbinary(1)) as varbinary(2)) as smallint),

@StackSize1 = cast(cast(cast( substring(strItem, @i+7, 1) as varbinary(1))+cast(substring(strItem, @i+6, 1) as

varbinary(1)) as varbinary(2)) as smallint),

@StrUserID = strUserID

From UserData

Where strUserID = @StrUserID









insert into itemler (dwid,stacksize,durability,struserid,sira,itembasicname,extname)

values(@dwid,@stacksize1,@dur,@StrUserID,(@i-1) / 8,@extname,@name )



set @i=@i+8



end

end



GO
 
Cevap: cast or convert invalid attributes specified for type 'int'



Kod:
/****** Object:  StoredProcedure [dbo].[ITEMLERI_BUL]    Script Date: 10/02/2012 00:52:03 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER procedure [dbo].[ITEMLERI_BUL]

@StrUserID varchar(30)

AS

DECLARE

@length int, -- stritem uzunluğu

@i int, -- item'in stritem deki yeri

@dwid int,

@dur int,

@duar int,

@Kocuce int,

@StackSize1 int,

@Sira int,

@Row int,

@name varchar(100),

@extname varchar(100),

@ext int,

@strSerial int

set @i = 14*0+1

set @length = 401

select @Row=count(*) from userdata where struserid=@StrUserID

delete from itemler where struserid=@StrUserID

if @Row>0

begin

WHILE @i < @length

Begin

Select @dwid=cast(cast(substring(cast(substring(strItem, @i,4) as varbinary(4)), 4, 1)+substring(cast(substring(strItem, @i,4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, @i,4) as varbinary(4)), 2, 1)+substring(cast(substring(strItem, @i,4) as varbinary(4)), 1, 1) as varbinary(4)) as int),

@dur = cast(cast(cast( substring(strItem, @i+5, 1) as varbinary(1))+cast(substring(strItem, @i+4, 1) as varbinary(1)) as varbinary(2)) as smallint),

@strSerial = cast(cast(substring(cast(substring(strSerial, @i,4) as varbinary(4)), 4, 1)+substring(cast(substring(strSerial, @i,4) as varbinary(4)), 3, 1)+substring(cast(substring(strSerial, @i,4) as varbinary(4)), 2, 1)+substring(cast(substring(strSerial, @i,4) as varbinary(4)), 1, 1) as varbinary(4)) as int),

@StackSize1 = cast(cast(cast( substring(strItem, @i+7, 1) as varbinary(1))+cast(substring(strItem, @i+6, 1) as varbinary(1)) as varbinary(2)) as smallint),

@StrUserID = strUserID

From UserData

Where strUserID = @StrUserID

if @dwid=0

begin

set @extname='~~~~~~ item yok ~~~~~~'

set @name='~~~~~~ item yok ~~~~~~'

end

else

begin

set @extname='Bulunamadi'

select @extname=strname from item where num=@dwid

end

insert into itemler (dwid,stacksize,durability,struserid,sira,itembasicname) values(@dwid,@StackSize1,@dur,@StrUserID,(@i-1) / 8,@extname )

set @i=@i+8

end

select * from itemler where struserid=@StrUserID order by sira

end

Kod:
/****** Object:  StoredProcedure [dbo].[ITEMLERI_BUL_BANKA]    Script Date: 10/02/2012 00:53:13 ******/SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER procedure [dbo].[ITEMLERI_BUL_BANKA]

@StrUserID varchar(30)

AS

DECLARE

@length int, -- stritem uzunluğu

@i int, -- item'in stritem deki yeri

@dwid int, 

@dur int,

 @Kocuce int,

@StackSize1 int,

@Sira int,

@Row int,

@extname varchar(50),

@item varchar(30)





select @item=WareHouseData from warehouse where straccountid=@StrUserID

if @item is null

	update warehouse set warehousedata='' where straccountid=@StrUserID





delete from warehouse_itemler where struserid=@StrUserID





    set @i = 14*0+1

    set @length=1601





select @row=count(*) from warehouse where straccountid=@StrUserID





if @row>0 

  begin





WHILE @i < @length

Begin





--Buraya İşemek Yasaktır

Select @dwid=cast(cast(substring(cast(substring(WarehouseData, @i,4) as varbinary(4)), 4, 1)+substring(cast(substring(WarehouseData, @i,4) as varbinary(4)), 3, 1)+substring(cast(substring(WarehouseData, @i,4) as varbinary(4)), 2, 

1)+substring(cast(substring(WarehouseData, @i,4) as varbinary(4)), 1, 1) as varbinary(4)) as int),

@dur = cast(cast(cast( substring(WarehouseData, @i+5, 1) as varbinary(1))+cast(substring(WarehouseData, @i+4, 1) as varbinary(1)) as varbinary(2)) as smallint),

@StackSize1 = cast(cast(cast( substring(WarehouseData, @i+7, 1) as varbinary(1))+cast(substring(WarehouseData, @i+6, 1) as varbinary(1)) as varbinary(2)) as smallint),

        @StrUserID = straccountid

        From warehouse

        Where straccountid = @StrUserID





if @dwid=0 

begin

set @extname='~~~~~~ item yok ~~~~~~'

end

else

begin

set @extname='Bulunamadı'





select @extname=strname from item where num=@dwid

end





insert into warehouse_itemler values(@dwid,@stacksize1,@dur,@StrUserID,(@i-1) / 8,@extname )





set @i=@i+8





end





select * from warehouse_itemler where struserid=@StrUserID order by sira





end



Kod:
/****** Object:  StoredProcedure [dbo].[itemleri_encode]    Script Date: 10/02/2012 00:53:32 ******/SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO









ALTER procedure [dbo].[itemleri_encode]

@StrUserID varchar(30)

AS

DECLARE

@length int, -- stritem uzunluğu

@row int, -- yerine göre deişior.

@i int, -- item'in stritem deki yeri

@dwid int, -- dwid

@pos int,

@dur int,

@dur1 int,

@Kocuce int,

@ext int,

@StackSize1 int,

@strName varchar(30),

@strExtName varchar(30),

@strSerial int,

@CstrSerial varbinary(4),

@Cdwid varbinary(4),

@Cdur varchar(2),

@Source tinyint,

@NEWdwid int,

@StackSize int,

@Cstack varchar(2),

@sira int

set @sira=0

set @i = 14*0

set @length = 401

select @row=count( * ) from userdata where struserid=@StrUserID

if @row>0

begin

Select @dwid=dwid,

@dur = durability,

@StackSize1 = stacksize,

@StrUserID = strUserID

From itemler

Where strUserID = @StrUserID and sira=@sira

print @dwid

print @strSerial

Set @Cdwid = Substring(cast(@dwid as varbinary(4)), 4, 1) + Substring(cast(@dwid as varbinary(4)), 3, 1) + Substring(cast(@dwid as varbinary(4)), 2, 1) + Substring(cast(@dwid as varbinary(4)), 1, 1)

Set @CstrSerial = Substring(cast(@strSerial as varbinary(4)), 4, 1) + Substring(cast(@strSerial as varbinary(4)), 3, 1) + Substring(cast(@strSerial as varbinary(4)), 2, 1) + Substring(cast(@strSerial as varbinary(4)), 1, 1)

Set @Cdur = cast(Substring(cast(@dur as varbinary(2)), 2, 1)+Substring(cast(@dur as varbinary(2)), 1, 1) as varchar(2))

Set @Cstack = cast(Substring(cast(@StackSize1 as varbinary(2)), 2, 1)+Substring(cast(@StackSize1 as varbinary(2)), 1, 1) as varchar(2))

update UserData set

strItem = cast(cast(cast(@Cdwid as varchar(4)) + @Cdur + @Cstack as varchar(50)) as binary(400)),

strSerial = cast(cast(@CstrSerial as varchar(4)) as binary(400))

where strUserID = @StrUserID

set @i=@i+8

set @sira=@sira+1

WHILE @sira < 50

Begin

Select @dwid=dwid,

@dur = durability,

@StackSize1 = stacksize,

@StrUserID = strUserID

From itemler

Where strUserID = @StrUserID and sira=@sira

Set @Cdwid = Substring(cast(@dwid as varbinary(4)), 4, 1) + Substring(cast(@dwid as varbinary(4)), 3, 1) + Substring(cast(@dwid as varbinary(4)), 2, 1) + Substring(cast(@dwid as varbinary(4)), 1, 1)

Set @Cdur = cast(Substring(cast(@dur as varbinary(2)), 2, 1)+Substring(cast(@dur as varbinary(2)), 1, 1) as varchar(2))

Set @Cstack = cast(Substring(cast(@StackSize1 as varbinary(2)), 2, 1)+Substring(cast(@StackSize1 as varbinary(2)), 1, 1) as varchar(2))

set @CstrSerial = Substring(cast(@strSerial as varbinary(4)), 4, 1) + Substring(cast(@strSerial as varbinary(4)), 3, 1) + Substring(cast(@strSerial as varbinary(4)), 2, 1) + Substring(cast(@strSerial as varbinary(4)), 1, 1)

update UserData set

strItem = cast(substring(strItem, 1, @i) + cast(cast(@Cdwid as varchar(4)) + @Cdur + @Cstack as varchar(50)) + substring(strItem, @i+8, 401-@i) as binary(400)),

strSerial = cast(substring(strSerial, 1, @i) + cast(@CstrSerial as varchar(4)) + substring(strSerial, @i+8, 401-@i) as binary(400))

where strUserID = @StrUserID

--Buraya İşemek Yasaktır

set @i=@i+8

set @sira=@sira+1

end

end

Kod:
/****** Object:  StoredProcedure [dbo].[itemleri_encode_banka]    Script Date: 10/02/2012 00:53:50 ******/SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER procedure [dbo].[itemleri_encode_banka]

@StrUserID varchar(30)

AS

DECLARE

@length int, -- stritem uzunluğu

@row int, -- yerine göre deişior.

@i int, -- item'in stritem deki yeri

@dwid int, -- dwid

@pos int,

@dur int,

@dur1 int,

@ext int,

@StackSize1 int,

@strName varchar(30),

@strExtName varchar(30),

@Cdwid varbinary(4),

@cdur varchar(2),

@Source tinyint,

@NEWdwid int,

@StackSize int,

@cstack varchar(2),

@sira int





    set @sira=0

    set @i = 14*0

    set @length = 1601





select @row=count( * ) from warehouse where strAccountID=@StrUserID





if @row>0 

  begin









Select @dwid=dwid,

@dur = durability,

@StackSize1 = stacksize,

        @StrUserID = strUserID

        From warehouse_itemler

        Where strUserID = @StrUserID and sira=@sira





    Set @Cdwid = Substring(cast(@dwid as varbinary(4)), 4, 1) + Substring(cast(@dwid as varbinary(4)), 3, 1) + Substring(cast(@dwid as varbinary(4)), 2, 1) + Substring(cast(@dwid as varbinary(4)), 1, 1)

    Set @Cdur = cast(Substring(cast(@dur as varbinary(2)), 2, 1)+Substring(cast(@dur as varbinary(2)), 1, 1) as varchar(2))

    Set @Cstack = cast(Substring(cast(@StackSize1 as varbinary(2)), 2, 1)+Substring(cast(@StackSize1 as varbinary(2)), 1, 1) as varchar(2))









    update WareHouse set warehousedata = cast(cast(cast(@Cdwid as varchar(4)) + @Cdur + @Cstack as varchar(8))   as binary(400)) where strAccountID = @strUserID













set @i=@i+8

set @sira=@sira+1









WHILE @sira < 200

Begin





Select @dwid=dwid,

@dur = durability,

@StackSize1 = stacksize,

        @StrUserID = strUserID

        From warehouse_itemler

        Where strUserID = @StrUserID and sira=@sira





    Set @Cdwid = Substring(cast(@dwid as varbinary(4)), 4, 1) + Substring(cast(@dwid as varbinary(4)), 3, 1) + Substring(cast(@dwid as varbinary(4)), 2, 1) + Substring(cast(@dwid as varbinary(4)), 1, 1)

    Set @Cdur = cast(Substring(cast(@dur as varbinary(2)), 2, 1)+Substring(cast(@dur as varbinary(2)), 1, 1) as varchar(2))

    Set @Cstack = cast(Substring(cast(@StackSize1 as varbinary(2)), 2, 1)+Substring(cast(@StackSize1 as varbinary(2)), 1, 1) as varchar(2))









    update warehouse set warehousedata = cast( substring(warehousedata, 1, @i) + cast(cast(@Cdwid as varchar(4)) + @Cdur + @Cstack as varchar(8)) + substring(warehousedata, @i+8, 1601-@i) as binary(1600)) where strAccountID = @strUserID









set @i=@i+8

set @sira=@sira+1





end

end

delete from warehouse_itemler

AVCIeditörün sql 2008 için ayarlanmış prosedürleri
 
arkadaşlar dindirdiğim avcı editör içinde bu prosedürler var zaten nasıl düzelticeğim bu sorunu
 
Geri
Üst Alt
Reklam
Reklam