[ Noticias ]-
[ Noticias ]-
[ Noticias ]-
[ Noticias ]-
[ Noticias ]-
[ Noticias ]-
http://img408.imageshack.us/img408/9421/user193809pic5361211078.jpg Nome: MuXtrap
Vers�o: 97+99i
Xp: 5.000x
Site: www.muxtrap.dahora.net

Radio Portal'Snoop

Add Itens A Char Iniciante

Primeiro Abra o seu Query Analyser e Rode esta query em CabalCash:

USE [CabalCash]
GO
/****** Object: Table [dbo].[FreeItemLog] Script Date: 12/17/2009 18:35:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FreeItemLog](
[idx] [bigint] IDENTITY(1,1) NOT NULL,
[UserNum] [int] NOT NULL,
[ItemIdx] [int] NOT NULL,
[ItemOpt] [int] NOT NULL,
[DurationIdx] [int] NOT NULL,
[Claimed] [datetime] NOT NULL
) ON [PRIMARY]
Agora Abra Enterprise Manager Vá Em Database > Gamedb > Stored Procedures > stored procedures e de 2 Cliques em cabal_sp_newchar

Procure por :

-- ??? 0xA1 ~ 0xA6
drop table #tempTable
Insira uma linha abaixo do codigo acima:

-- #### Items gratis Para Cada Conta Nova Criada ####
declare @ItemIdx int, @ItemOpt int,@DurationIdx int

-- Configure seus items aqui
set @ItemIdx=1
set @ItemOpt=0
set @DurationIdx=31

if(not exists (select * from cabalcash.dbo.FreeItemLog where UserNum=@userNum and ItemIdx=@ItemIdx and ItemOpt=@ItemOpt and DurationIdx=@DurationIdx))
begin
insert into CabalCash.dbo.MyCashItem ( UserNum, TranNo, ServerIdx, ItemKindIdx, ItemOpt, DurationIdx )
values (@UserNum, 1, @ServerIdx, @ItemIdx, @ItemOpt, @DurationIdx )
insert into cabalcash.dbo.FreeItems ( UserNum, ItemIdx, ItemOpt, DurationIdx, Claimed )
values (@userNum,@ItemIdx,@ItemOpt,@DurationIdx,GetDate() )
end
-- #### FIM ITEMS GRATIS ADICIONADO By chumpywumpy ####
Ta aew Galera Qualquer Coisa só Perguntar