DB Proc fix
cbp_load_hisec_event
SQL:ALTER PROCEDURE [dbo].[cbp_load_hisec_event] @LobbyServerID INT, @GrayTodayCount INT OUTPUT, @BlackTodayCount INT OUTPUT AS BEGIN SET NOCOUNT ON; set @GrayTodayCount = 0 set @BlackTodayCount = 0 declare @EventID int declare @curDate DATE -- Alterado para DATE set @curDate = CAST(GETDATE() AS DATE) -- Corrigido para evitar erro de conversão -- set @GrayTodayCount select @GrayTodayCount = TodayCount from CBT_HiSecTodayCount with (nolock) where ServerID = @LobbyServerID and HiSecID = 0 and LastDate = @curDate if (@@rowcount <= 0) begin set @GrayTodayCount = 0 update CBT_HiSecTodayCount set LastDate = @curDate, TodayCount = 0 where ServerID = @LobbyServerID and HiSecID = 0 if (@@rowcount <= 0) begin insert into CBT_HiSecTodayCount([ServerID],[HiSecID],[LastDate],[TodayCount]) values(@LobbyServerID, 0, @curDate, 0) end end -- set @BlackTodayCount select @BlackTodayCount = TodayCount from CBT_HiSecTodayCount with (nolock) where ServerID = @LobbyServerID and HiSecID = 1 and LastDate = @curDate if (@@rowcount <= 0) begin set @GrayTodayCount = 0 update CBT_HiSecTodayCount set LastDate = @curDate, TodayCount = 0 where ServerID = @LobbyServerID and HiSecID = 1 if (@@rowcount <= 0) begin insert into CBT_HiSecTodayCount([ServerID],[HiSecID],[LastDate],[TodayCount]) values(@LobbyServerID, 1, @curDate, 0) end end -- get largest correct EventID select top 1 @EventID = EventID from CBT_HiSecEvent with (nolock) where BeginTime <= GETDATE() and GETDATE() < EndTime and Enable = 1 group by EventID having COUNT(HiSecID) >= 2 and COUNT(HiSecID) = COUNT(distinct HiSecID) order by EventID desc if( @@ROWCOUNT <> 1 ) return 10 select HiSecID, HiSecCaseID, TodayLimit, DropRateBase from CBT_HiSecEvent with (nolock) where EventID = @EventID order by HiSecID RETURN @@ERROR END
cbp_____load_main_daily_quest
SQL:ALTER PROCEDURE [dbo].[cbp_____load_main_daily_quest] @out_Access int OUTPUT, @out_CheckoutTime datetime OUTPUT AS BEGIN SET NOCOUNT ON; -- Declaração de variáveis DECLARE @cur_time datetime DECLARE @cur_base_date date DECLARE @cur_base_dayofweek int DECLARE @cur_date datetime DECLARE @cur_dayofweek int DECLARE @char_cur_dayofweek nchar(1) -- Variáveis de controle de acesso DECLARE @cur_access_spid int DECLARE @cur_access_time datetime DECLARE @last_access_spid int DECLARE @last_access_time datetime DECLARE @last_access_end_time datetime DECLARE @row_count int -- Inicializando parâmetros de saída SET @out_Access = 0 SET @out_CheckoutTime = '1999-01-01 00:00:00' -- Inicializando variáveis de tempo SET @cur_time = GETDATE() SET @cur_access_time = @cur_time SET @cur_access_spid = @@SPID SET @cur_base_date = CAST(@cur_time AS DATE) SET @cur_base_dayofweek = DATEPART(dw, @cur_time) -- Lógica de bloqueio de acesso SELECT @last_access_spid = AccessSPID, @last_access_time = AccessTime DE CBT___AccessEntryLock COM (NOLOCK) ONDE AccessType = 1 DEFINIR @last_access_end_time = DATEADD(SECOND, 30, @last_access_time) SE (@last_access_spid <> -1 E @last_access_spid <> @cur_access_spid E @cur_access_time < @last_access_end_time) IR PARA ACCESS_FAIL -- Inserção no lock ATUALIZAÇÃO CBT___AccessEntryLock DEFINIR AccessSPID = @cur_access_spid, Tempo de acesso = @tempo_de_acesso_atual ONDE AccessType = 1 E AccessSPID = @last_access_spid E AccessTime = @last_access_time DEFINIR @row_count = @@ROWCOUNT SE (@row_count <> 1) IR PARA ACCESS_FAIL -- Agarrando dados DEFINIR @cur_date = DATEADD(DAY, -1, @cur_base_date) DEFINIR @cur_dayofweek = @cur_base_dayofweek - 1 DEFINIR @char_cur_dayofweek = CONVERTER(nchar(1), @cur_dayofweek) -- Inserindo registros para o dia anterior INSERT INTO CBT___QuestSchedule (QuestMainID, BeginTime, EndTime, State, SubQuestNum) SELECIONE a.QuestMainID, DATEADD(HOUR, a.DailyBeginHour, @cur_date), DATEADD(HORA, a.DailyBeginHour + a.DailyPeriodHour, @cur_date), 0, 0 DE CBT___QuestRegisterMain a ONDE @cur_date ENTRE a.BeginTime E a.EndTime E @cur_time >= DATEADD(HOUR, a.DailyBeginHour, @cur_date) E @cur_time < DATEADD(HOUR, a.DailyBeginHour + a.DailyPeriodHour, @cur_date) E CHARINDEX(@char_cur_dayofweek, a.ActivatedDaysofWeek) > 0 E NÃO EXISTE ( SELECIONE 1 DO CBT___QuestSchedule b ONDE b.BeginTime = DATEADD(HOUR, a.DailyBeginHour, @cur_date) E b.QuestMainID = a.QuestMainID ) -- Ajustando variáveis para o dia atual DEFINIR @cur_date = @cur_base_date DEFINIR @cur_dayofweek = @cur_base_dayofweek DEFINIR @char_cur_dayofweek = CONVERTER(nchar(1), @cur_dayofweek) -- Inserindo registros para o dia atual INSERT INTO CBT___QuestSchedule (QuestMainID, BeginTime, EndTime, State, SubQuestNum) SELECIONE a.QuestMainID, DATEADD(HOUR, a.DailyBeginHour, @cur_date), DATEADD(HORA, a.DailyBeginHour + a.DailyPeriodHour, @cur_date), 0, 0 DE CBT___QuestRegisterMain a ONDE @cur_date ENTRE a.BeginTime E a.EndTime E @cur_time >= DATEADD(HOUR, a.DailyBeginHour, @cur_date) E @cur_time < DATEADD(HOUR, a.DailyBeginHour + a.DailyPeriodHour, @cur_date) E CHARINDEX(@char_cur_dayofweek, a.ActivatedDaysofWeek) > 0 E NÃO EXISTE ( SELECIONE 1 DO CBT___QuestSchedule b ONDE b.BeginTime = DATEADD(HOUR, a.DailyBeginHour, @cur_date) E b.QuestMainID = a.QuestMainID ) -- indo saída SELECIONE OS 1 PRINCIPAIS QuestMainID, QuestSeqNo, BeginTime, EndTime DE CBT___QuestSchedule COM (NOLOCK) ONDE @cur_time >= BeginTime E @cur_time < EndTime ORDENAR POR QuestSeqNo DESC -- Liberando o lock ATUALIZAÇÃO CBT___AccessEntryLock DEFINIR AccessSPID = -1 ONDE AccessType = 1 E AccessSPID = @cur_access_spid E AccessTime = @cur_access_time -- Configurando saída DEFINIR @out_Access = 1 DEFINIR @out_CheckoutTime = @cur_time ACESSO_FALHA: DEFINIR NOCOUNT DESLIGADO; RETORNO @@ERRO FIM [/CÓDIGO] [/QUOTE] Alguém testou
QUAL NOME DO EVENTO 5 SHOT NA DB ?
you use ashlays release. there is a youtube video tutorial posted in these forums which shows you how to setup. search for it and follow it exactly as shown and it should workHey Everyone,
I just recently found out that the Combat Arms Source code was leaked. I've been going through the comments.
Can someone help me get my private server running and game launching? There seems to be three forums:
1. https://forum.ragezone.com/threads/release-compiled-server-client-fully-working.1238418/
2. https://forum.ragezone.com/threads/...nt-server-database-api-and-tools-src.1238933/
3. https://forum.ragezone.com/threads/...ngs-i-have-ca-r-ca-reloaded-ca-stuff.1237980/
Which files should I be downloading? If anyone can kindly help me out, I would appreciate it.
vce pode me ajudar estou com problema de Dserverque lindo é isso, quando você quer algo você não vai conseguir,
parece que o erro foi muito estúpido.
se alguém quiser compartilhar sua correção do dserver gratuitamente com a comunidade, seja bem-vindo.
The links are down man.. :/A message directly to Valofe:
I know you see this. I know you know of this. You've finally after all these years, made a public statement that referenced CA Reborn on your website and discord community.
"In the past, we’ve taken action against unauthorized CA private servers. While our handling of these matters—particularly in the case of the Reborn server—received criticism, we’ve taken those lessons to heart and have made efforts to approach this more thoughtfully."
You didn't learn **** from this. You didn't understand was Reborn was/is/will be (if it comes back). My public email is easy to find. My LinkedIn is easy to find. My DM's on Discord or here or elsewhere are open.
If you'd like to have a conversation, let's actually have one. Until then, this content stays up.
=====================================================================================
I'm kind of sick of all the things floating around for combat arms. People getting scammed by the fake sales of source code, and potential virus worries with binaries made by friends and I over the years. This post aims to put *everything I have* out there. Will this make Valofe mad? Maybe? I just want to end the negativity and scamming, but this stuff being public, I don't think is a major issue any more.
Mirror
Some MORE addon Mirrors to an other provider:
(Same files untouched just mirrored)
CA reborn:To view the content, you need to sign in or register
CAEUX:To view the content, you need to sign in or register
CAR1.1:To view the content, you need to sign in or register
CAR1.2:To view the content, you need to sign in or register
DB:To view the content, you need to sign in or register
SOURCE:To view the content, you need to sign in or register
(I can do this all...
March 31, 2025 updated links - I ended up switching to TeraBox to host all my files and go into some heavy organization. I know it requires sign up and maybe software install, but 1TB of storage for free, its the best place for me to upload at this time
CA-Reborn
[Hidden content]
CA-Reloaded UX Debug Build
[Hidden content]
Combat Arms Installers
These are posted in age order - some version numbers unknown but can tell by file size how old
[Hidden content]
Old CA Website Rebuilt
Largely thanks to archive.org and a friend for editing the HTML (manually I might add), here's an old variant of the original CA website
[Hidden content]
CA Source Code
I'm pretty much hands off on this stuff, I just had it and released it. I can't tell you how to use it
[Hidden content][/HIDEREACT]
Valofe on the attack again... They're attacking *everything* ca everywhere. not just their own versions, but even prior versions before they took over development - which isn't legal. They've done this before, even took down download links for contract jack and other lithtech jupiter games.The links are down man.. :/
You are completely right, I have them luckely i downloaded them already march 2025. i keep them safeValofe on the attack again... They're attacking *everything* ca everywhere. not just their own versions, but even prior versions before they took over development - which isn't legal. They've done this before, even took down download links for contract jack and other lithtech jupiter games.
Honestly I'm not interested in the fight. Others can reupload. I won't
A lot of the links are ok still, the 1024terabox links seem to work for no
Valofe on the attack again... They're attacking *everything* ca everywhere. not just their own versions, but even prior versions before they took over development - which isn't legal. They've done this before, even took down download links for contract jack and other lithtech jupiter games.
Honestly I'm not interested in the fight. Others can reupload. I won't