• Bem vindo à nossa comunidade - Quer se juntar ao resto dos nossos membros? Registre-se*Registros aprovados pela adminitração

Criando Server De Cabal 100 % Funcional e Português

Status
Não esta aberto para novas mensagens.

Triggerdante

Novato XPZ
O meu fiz tudo conforme o tuto

mas da esse erro no centos quando tento logar

Ate aparece a tela inicial do cabal mas....

VMware Workstation unrecoverable error: (vcpu-0)

Exception 0xc0000005 (access violation) has occurred.

A log file is available in "E:\Documents and Settings\Ricardo\Desktop\cabal\CentOS_4.7_with_installed_Cabal_Server0\CentOS 4.7 with installed Cabal Server\CentOS-4.7\vmware.log".  A core file is available in "E:\Documents and Settings\Ricardo\Desktop\cabal\CentOS_4.7_with_installed_Cabal_Server0\CentOS 4.7 with installed Cabal Server\CentOS-4.7\vmware-vmx-2172.dmp".  Please request support and include the contents of the log file and core file. 

To collect data to submit to VMware support, select Help > About and click "Collect Support Data". You can also run the "vm-support" script in the Workstation folder directly.

We will respond on the basis of your support entitlement.

e fecha o server alguem sabe o que eh ?
 

jnswarrior

Usuário XPZ
Ai parabens TATU, graças a vc to conseguindo jogar no meu proprio server^^, to upando meu char pra simular o que eu nao pude fazer no Cobr por falta de sorte, tipo dropar itens com amp espada dropar mitril AMP, matar a curiosidade de bater no pluminha solo, sem mexer na str original so vo inclementa os equipamentos, dentro das possibilidades do cobr, ETC nao vou colocar meu server online pros outros jogar.

agora so falta fazer ele trabalhar sem uso de net, ja to pesquisando um jeito de fazer isso, mais ta foda.

ENFIM, BRIGADÃO AI PRA VC TATU E AOS OUTROS MENBROS DESDE E DE OUTROS FORUNS QUE CONTRIBUIRAM PRA ISSO ACONTECER.

ABRAÇO TATU.

Finalmente to livre num mundo so pra mim kkkk.
 
Editado por um moderador:

jnswarrior

Usuário XPZ
quanto vc tava configurando o Centos vc mudo a senha dele pra uma senha Pessoal nao mudo??  agora coloca a sua senha pessoal que vc uso na no centos ai.

lembra desse comando que vc uso uso no Centos pra muda a senha >> passwd root
 

natangm

Novato XPZ
NAO CONSIGO CRIAR CHAR NO MEU SERVIDOR.... PONHO NOME DO CHAR... O NOME SOME MAIS CONTINUA NA MESMA TELA... COMO RESOLVER
default_huh.gif
? ME ADD NO MSN natangm@hotmail.com 
default_embarrassed.gif
 

grub

Novato XPZ
Ola Galera sou novo aki no forum, e  gostei muito !!!

tentei fazer meu server de cabal aki e conseguir, porem ta dano um erro aki de BD, mostra a seguinte mensagem quando vou criar um char:

" IMPOSSIVEL PROCEDER COM O COMANDO POR ERROS BD DESCONHECIDO. TENTE MAIS TARDE !"

olhei na net e achei isso que poderia ser o problema:

risos

aber ist richtig das ist ein Error denn Viele leute schon hatten Mas isso é verdade é um erro, porque muitas pessoas já haviam

aber egal Mas não importa

Zu beheben der Fehler ist einfach Recht simpel Para resolver o erro é simplesmente simples direito

zu suchen in der Gamedb para pesquisar na BD

Progamierbarkeit//Gespeicherte Prozeduen Prozeduen Progamierbarkeit / Armazenado

suche nach pesquise

der dbo.cabal_sp_newchar o dbo.cabal_sp_newchar

Ersetze das gegen das Substituí-lo contra o

co



USE [Gamedb]

GO

/****** Objekt:  StoredProcedure [dbo].[cabal_sp_newchar]    Skriptdatum: 07/23/2009 15:40:47 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

/****** Object: Stored Procedure dbo.cabal_sp_newchar Script Date: 2008-4-14 5:52:47 ******/

ALTER PROCEDURE [dbo].[cabal_sp_newchar] (@charname varchar(16), @characteridx int, @style int, @stylemast int)

AS

begin

SET NOCOUNT ON

if( exists ( select * from cabal_badwoard where badword=@charname ) ) select convert(int,0x04)

else if( exists ( select * from cabal_character_table where Name=@charname ) ) select convert(int,0x03)

else if( exists ( select * from cabal_character_table where characteridx=@characteridx ) ) select convert(int,0x02)

else if( @stylemast < 0x01 or @stylemast > 0x06 ) select convert(int,0x02)

else

begin

-----------------------------------------------------------------------------------------------

declare @RegTime dateTime, @userNum int, @serverIdx int, @result int

set @userNum = @characterIdx/8

set @serverIdx = dbo.getServerIdx()

set @RegTime = getDate()

set @result = convert(int, 0xA0) + @stylemast

------------------------------------------------------------------------------------------------

select charTable.*, etcTable.equipmentData, etcTable.inventoryData, etcTable.skillData,

etcTable.quickSlotData, etcTable.questData, etcTable.questFlagsData

into #tempTable

from account.dbo.cabal_newCharData_table as charTable,

account.dbo.cabal_newEtcData_table as etcTable,

( select top 1 charDataIdx, etcDataIdx from account.dbo.cabal_newFlagData_table

where channel = @serverIdx) as flagTable

where flagTable.etcDataIdx = etcTable.dataIdx and flagTable.charDataIdx = charTable.dataIdx

and charTable.classType = etcTable.classType and charTable.classType = @stylemast

IF( NOT EXISTS ( select * from #tempTable))

BEGIN

select convert(int, 0x01)

drop table #tempTable

return

END

-----------------------------------------------------------------------------------------------

--
default_huh.gif
??? ??

EXEC account.dbo.cabal_sp_update_character_count @userNum, @serverIdx, 1

--
default_huh.gif
??

insert into cabal_character_table( CharacterIdx, Name, LEV, [EXP], [sTR], DEX, [iNT], PNT, Rank, Alz,

WorldIdx, [Position], Style, HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField, Reputation, Reserved1 )

select @characteridx, @charname, LEV, [EXP], [sTR], [DEX], [iNT], [PNT], Rank, Alz,

WorldIdx, Position, @style, HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField, Reputation, Reserved1

from #TempTable

begin tran

insert into cabal_equipment_table (characterIdx, data) select @characteridx, equipmentData from #TempTable

insert into cabal_inventory_table (characterIdx, data) select @characteridx, inventoryData from #TempTable

insert into cabal_skilllist_table (characterIdx, data) select @characteridx, skillData from #TempTable

insert into cabal_quickslot_table (characterIdx, data) select @characteridx, quickSlotData from #TempTable

insert into cabal_questdata_table (characterIdx, data, flags) select @characteridx, questData, questFlagsData from #TempTable

commit tran

----------------------------------------------------------------------------------------------

--
default_huh.gif
0xA1 ~ 0xA6

drop table #tempTable

select convert(int, @result)

-----------------------------------------------------------------------------------------------

end

SET NOCOUNT OFF

end


para pesquisar na BD

Progamierbarkeit//Gespeicherte Prozeduen Prozeduen Progamierbarkeit / Armazenado

suche nach pesquise

dbo.cabal_sp_delchar dbo.cabal_sp_delchar

Ersetzen Substituir

Code: Código:

USE [Gamedb]

GO

/****** Objekt:  StoredProcedure [dbo].[cabal_sp_delchar]    Skriptdatum: 07/23/2009 15:38:24 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

/****** Object: Stored Procedure dbo.cabal_sp_delchar Script Date: 2008-4-14 5:52:47 ******/

ALTER PROCEDURE [dbo].[cabal_sp_delchar] (@characteridx int)

AS

begin

SET NOCOUNT ON

DECLARE @ROWCOUNT int

BEGIN

--If GuildMaster, return 0xB2

SELECT @ROWCOUNT = COUNT(A.GroupIndex) FROM GUILDGROUP A

INNER JOIN

(

SELECT GroupIndex FROM GUILDMEMBER WHERE CharacterIndex = @characteridx

) B

ON A.GroupIndex = B.GroupIndex

WHERE A.GroupPermission = 0

IF( @ROWCOUNT > 0 )

BEGIN

SELECT CONVERT(INT, 0xB2)

SET NOCOUNT OFF

RETURN

END

END

begin tran

INSERT INTO DELETED_CABAL_CHARACTER_TABLE(

CHARACTERIDX, NAME, LEV, EXP, STR, DEX, INT, PNT, RANK, ALZ, WORLDIDX, POSITION, STYLE, HP, MP, SWDPNT, MAGPNT, RANKEXP, FLAGS, WARPBFIELD, MAPSBFIELD, SP, PENALTYEXP, LOGOUTTIME, RP, REPUTATION, LOGINTIME, PLAYTIME, CHANNELIDX, CreateDate, EQUIPDATA, INVENDATA, SKILLDATA, QSLOTDATA, QDFLAGS, QSTDATA, QSTFLAGS, Level0, Level1, Level2, Level3, Level4, Exp0, Exp1, Exp2, Exp3, Exp4, CraftFlags, PKPenalty, Nation, BBeadData)

SELECT

A.CHARACTERIDX, NAME, LEV, EXP, STR, DEX, INT, PNT, RANK, ALZ, WORLDIDX, POSITION, STYLE, HP, MP, SWDPNT, MAGPNT, RANKEXP, A.FLAGS, WARPBFIELD, MAPSBFIELD, SP, PENALTYEXP, LOGOUTTIME, RP, REPUTATION, LOGINTIME, PLAYTIME, CHANNELIDX, CreateDate, B.DATA, C.DATA, D.DATA, E.DATA, F.FLAGS, G.DATA, G.FLAGS, H.Level0, H.Level1, H.Level2, H.Level3, H.Level4, H.Exp0, H.Exp1, H.Exp2, H.Exp3, H.Exp4, H.Flags, A.PKPenalty, A.Nation, I.DATA

FROM CABAL_CHARACTER_TABLE A

LEFT OUTER JOIN CABAL_EQUIPMENT_TABLE B ON A.CHARACTERIDX = B.CHARACTERIDX

LEFT OUTER JOIN CABAL_INVENTORY_TABLE C ON A.CHARACTERIDX = C.CHARACTERIDX

LEFT OUTER JOIN CABAL_SKILLLIST_TABLE D ON A.CHARACTERIDX = D.CHARACTERIDX

LEFT OUTER JOIN CABAL_QUICKSLOT_TABLE E ON A.CHARACTERIDX = E.CHARACTERIDX

LEFT OUTER JOIN CABAL_QDDATA_TABLE F ON A.CHARACTERIDX = F.CHARACTERIDX

LEFT OUTER JOIN CABAL_QUESTDATA_TABLE G ON A.CHARACTERIDX = G.CHARACTERIDX

LEFT OUTER JOIN CABAL_CRAFT_TABLE H ON A.CHARACTERIDX = H.CHARACTERIDX

LEFT OUTER JOIN CABAL_BBEAD_TABLE I ON A.CHARACTERIDX = I.CHARACTERIDX

WHERE A.CHARACTERIDX = @characteridx

delete from chat_buddy_table where (RegisterCharIdx = @characteridx) OR (RegisteeCharIdx = @characteridx)

delete from chat_buddygroup_table where CharIdx = @characteridx

delete from guildmember where characterindex = @characteridx

delete from cabal_bbead_table where CharacterIdx=@characteridx

delete from cabal_craft_table where Characteridx=@characteridx

delete from cabal_equipment_table where CharacterIdx=@characteridx

delete from cabal_inventory_table where CharacterIdx=@characteridx

delete from cabal_skilllist_table where CharacterIdx=@characteridx

delete from cabal_quickslot_table where CharacterIdx=@characteridx

delete from cabal_questdata_table where CharacterIdx=@characteridx

delete from cabal_qddata_table where CharacterIdx=@characteridx

delete from cabal_character_table where CharacterIdx=@characteridx

set @ROWCOUNT = @@ROWCOUNT

commit tran

IF( @ROWCOUNT > 0 )

BEGIN

--
default_huh.gif
?
default_huh.gif
???

DECLARE @USERNUM INT, @SERVERIDX INT

SET @USERNUM = @CHARACTERIDX/8

SET @SERVERIDX = DBO.GETSERVERIDX()

EXEC ACCOUNT.dbo.CABAL_SP_UPDATE_CHARACTER_COUNT @USERNUM, @SERVERIDX, -1

END

SELECT CONVERT(INT, 0xA1)

SET NOCOUNT OFF

end


O LINK DE ONDE PEGUEI ISSO É ESSE, ESTOU APRENDENDO USAR AS FERRAMENTAS DO FORUM AINDA.

Por favor, Entrar ou Registrar para ver o conteúdo das URLs!


conversei com o quenio ele disse para reinstalar o sql e restaurar as BD's novamente fiz isso porem continua o mesmo erro, alguem pode me ajudar por favor ?

desde já agradeço !

 
Editado por um moderador:

grub

Novato XPZ
APROVEITNDO FUI VE MEUS LOG'S LA NO /VAR/LOG/CABAL TA ASSIM:

[sat Nov  7 2009 14:50:13.934811 3086953376]: [##ERROR##] DB ERROR(CODE)    : 7399

[sat Nov  7 2009 14:50:13.934831 3086953376]: [##ERROR##] DB ERROR(VAR_INFO) :

[sat Nov  7 2009 14:50:13.934850 3086953376]: [##ERROR##] DB ERROR(SQLSTATE) : 42000

[sat Nov  7 2009 14:50:13.934902 3086953376]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ?              , ?        , ?        , ?        )}

[sat Nov  7 2009 14:50:16.943512 3086953376]: Database Connect success!

[sat Nov  7 2009 14:50:30.570488 3086953376]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx:
default_cool.gif


[sat Nov  7 2009 14:50:30.570548 3086953376]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][sql Server]OLE DB provider 'MSDASQL' reported an error. Authentication failed.

[sat Nov  7 2009 14:50:30.570570 3086953376]: [##ERROR##] DB ERROR(CODE)    : 7399

[sat Nov  7 2009 14:50:30.570590 3086953376]: [##ERROR##] DB ERROR(VAR_INFO) :

[sat Nov  7 2009 14:50:30.570609 3086953376]: [##ERROR##] DB ERROR(SQLSTATE) : 42000

[sat Nov  7 2009 14:50:30.570652 3086953376]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ?              , ?        , ?        , ?        )}

[sat Nov  7 2009 14:50:33.584300 3086953376]: Database Connect success!

[sat Nov  7 2009 14:50:33.594944 3076463520]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx:
default_cool.gif


[sat Nov  7 2009 14:50:33.595358 3076463520]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][sql Server]OLE DB provider 'MSDASQL' reported an error. Authentication failed.

[sat Nov  7 2009 14:50:33.595381 3076463520]: [##ERROR##] DB ERROR(CODE)    : 7399

[sat Nov  7 2009 14:50:33.595401 3076463520]: [##ERROR##] DB ERROR(VAR_INFO) :

[sat Nov  7 2009 14:50:33.595420 3076463520]: [##ERROR##] DB ERROR(SQLSTATE) : 42000

[sat Nov  7 2009 14:50:33.595440 3076463520]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ?              , ?        , ?        , ?        )}

[sat Nov  7 2009 14:50:36.608481 3076463520]: Database Connect success!

[sat Nov  7 2009 14:50:36.629629 3065973664]: [##ERROR##] OnIPCNewMyChartr fail (CharacterIdx:
default_cool.gif


[sat Nov  7 2009 14:50:36.629679 3065973664]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][sql Server]OLE DB provider 'MSDASQL' reported an error. Authentication failed.

[sat Nov  7 2009 14:50:36.629701 3065973664]: [##ERROR##] DB ERROR(CODE)    : 7399

[sat Nov  7 2009 14:50:36.629720 3065973664]: [##ERROR##] DB ERROR(VAR_INFO) :

[sat Nov  7 2009 14:50:36.629740 3065973664]: [##ERROR##] DB ERROR(SQLSTATE) : 42000

[sat Nov  7 2009 14:50:36.629759 3065973664]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_newchar( ?              , ?        , ?        , ?        )}

[sat Nov  7 2009 14:50:39.650498 3065973664]: Database Connect success!

ME DA UMA LUZ AE PROR FAVOR.......
 

andxxy

Usuário XPZ
Para quem criou o sever e não esta conseguindo criar o personagem, pode ser o ip no sql la em:

Security > Linked Servers > GAMESERVER

quando ele manda por o código:

DRIVER={SQL Server};SERVER=SEU IP;UID=USUARIO;PWD=SUA SENHA;

Você tem que colocar:

SEU IP: 127.0.0.1

USUARIO: SQL (se vc não mudou vai ser "sa" )

SUA SENHA: senha do SQL
 
Status
Não esta aberto para novas mensagens.
Topo Bottom