tenta ver a culuna no sqlCitação:
Originally Posted by kingrox [Only registered and activated users can see links. Click Here To Register...]
Printable View
tenta ver a culuna no sqlCitação:
Originally Posted by kingrox [Only registered and activated users can see links. Click Here To Register...]
No sql fica 0 reset no char conta mais se eu relogar o char ai mostra 0 de novo
nome da tabela é ResetCount int desmarcado
No command.dat está assim?Citação:
Originally Posted by kingrox [Only registered and activated users can see links. Click Here To Register...]
CommandResetCount_AL0 = 1
CommandResetCount_AL1 = 1
CommandResetCount_AL2 = 1
CommandResetCount_AL3 = 1
sim
mano ..............
Como está sua procedure WZ_SetResetInfo ?Citação:
Originally Posted by kingrox [Only registered and activated users can see links. Click Here To Register...]
não encontrei isso não..
to usando a db que veio no muserver e não tem.
[Only registered and activated users can see links. Click Here To Register...]
Tenta rodar essa query.Citação:
Originally Posted by kingrox [Only registered and activated users can see links. Click Here To Register...]
Citação:
use [muonline]
go
/****** object: Storedprocedure [dbo].[wz_getresetinfo] script date: 05/31/2016 22:37:01 ******/
set ansi_nulls on
go
set quoted_identifier on
go
create procedure [dbo].[wz_getresetinfo]
@account varchar(10),
@name varchar(10)
as
begin
set nocount on
set xact_abort on
declare @reset int
declare @resetday int
declare @resetwek int
declare @resetmon int
select @reset=resetcount,@resetday=resetday,@resetwek=res etwek,@resetmon=resetmon from character where accountid=@account and name=@name
select @reset as reset,@resetday as resetday,@resetwek as resetwek,@resetmon as resetmon
set nocount off
set xact_abort off
end
Tem alguém sumindo com suas coisas rs... Executa o que o dhylaan te passouCitação:
Originally Posted by kingrox [Only registered and activated users can see links. Click Here To Register...]
@[Only registered and activated users can see links. Click Here To Register...], eu rodar esse server em 512MB de Ram da? apenas para configura-lo e tal?
Corrigindo a procedure deve ser assim:Citação:
Originally Posted by DhylaaN [Only registered and activated users can see links. Click Here To Register...]
Deve dar dhylaan, nunca testei com essa quantidadeCitação:
CREATE Procedure [dbo].[WZ_SetResetInfo]
@Account varchar(10),
@Name varchar(10),
@Reset int,
@ResetDay int,
@ResetWek int,
@ResetMon int
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
UPDATE Character SET ResetCount=@Reset WHERE AccountID=@Account AND Name=@Name
SET NOCOUNT OFF
SET XACT_ABORT OFF
END