Juver files (bin / database) - no more selling

[aizen00]

RanUser.bak

[reshless]

How to fix item bank? I cannot take the item inside bank.

[masterband1427]

FIX FOR Character Name Not Available.

Spoiler:

USE [RanGame1]
GO

/****** Object: Table [dbo].[ChaInfo] Script Date: 12/27/2020 01:07:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ChaInfo](
[ChaNum] [int] IDENTITY(1,1) NOT NULL,
[SGNum] [int] NULL,
[UserNum] [int] NOT NULL,
[GuNum] [int] NULL,
[GuPosition] [int] NOT NULL,
[ChaName] [varchar](33) NOT NULL,
[ChaGuName] [varchar](33) NOT NULL,
[ChaTribe] [int] NOT NULL,
[ChaClass] [int] NOT NULL,
[ChaSchool] [int] NOT NULL,
[ChaHair] [int] NOT NULL,
[ChaFace] [int] NOT NULL,
[ChaLiving] [int] NOT NULL,
[ChaLevel] [int] NOT NULL,
[ChaReborn] [int] NOT NULL,
[ChaMoney] [money] NOT NULL,
[ChaPower] [bigint] NOT NULL,
[ChaDex] [bigint] NOT NULL,
[ChaSpirit] [bigint] NOT NULL,
[ChaStrong] [bigint] NOT NULL,
[ChaStrength] [bigint] NOT NULL,
[ChaIntel] [bigint] NOT NULL,
[ChaStRemain] [bigint] NOT NULL,
[ChaExp] [money] NOT NULL,
[ChaViewRange] [int] NOT NULL,
[ChaHP] [bigint] NOT NULL,
[ChaMP] [bigint] NOT NULL,
[ChaSP] [bigint] NOT NULL,
[ChaCP] [bigint] NOT NULL,
[ChaStartMap] [int] NOT NULL,
[ChaStartGate] [int] NOT NULL,
[ChaPosX] [float] NOT NULL,
[ChaPosY] [float] NOT NULL,
[ChaPosZ] [float] NOT NULL,
[ChaSaveMap] [int] NOT NULL,
[ChaSavePosX] [float] NOT NULL,
[ChaSavePosY] [float] NOT NULL,
[ChaSavePosZ] [float] NOT NULL,
[ChaReturnMap] [int] NOT NULL,
[ChaReturnPosX] [float] NOT NULL,
[ChaReturnPosY] [float] NOT NULL,
[ChaReturnPosZ] [float] NOT NULL,
[ChaBright] [int] NOT NULL,
[ChaAttackP] [int] NOT NULL,
[ChaDefenseP] [int] NOT NULL,
[ChaFightA] [int] NOT NULL,
[ChaShootA] [int] NOT NULL,
[ChaPK] [int] NOT NULL,
[ChaSkillPoint] [int] NOT NULL,
[ChaInvenLine] [int] NOT NULL,
[ChaDeleted] [int] NOT NULL,
[ChaOnline] [int] NOT NULL,
[ChaCreateDate] [datetime] NOT NULL,
[ChaDeletedDate] [datetime] NOT NULL,
[ChaStorage2] [datetime] NOT NULL,
[ChaStorage3] [datetime] NOT NULL,
[ChaStorage4] [datetime] NOT NULL,
[ChaGuSecede] [datetime] NOT NULL,
[ChaQuest] [image] NULL,
[ChaSkills] [image] NULL,
[ChaSkillSlot] [image] NULL,
[ChaActionSlot] [image] NULL,
[ChaPutOnItems] [image] NULL,
[ChaInven] [image] NULL,
[ChaCoolTime] [image] NULL,
[ChaSex] [int] NULL,
[ChaHairStyle] [int] NULL,
[ChaHairColor] [int] NULL,
[ChaReExp] [float] NOT NULL,
[ChaSpSID] [int] NULL,
[ChaSpMID] [int] NULL,
[ChaPersonalMap] [image] NULL,
[ChaEquipmentLockEnable] [bigint] NOT NULL,
[ChaEquipmentLockStatus] [bigint] NOT NULL,
[ChaPKScore] [bigint] NOT NULL,
[ChaPKDeath] [bigint] NOT NULL,
[ChaBadge] [varchar](33) NOT NULL,
[ChaActivity] [image] NULL,
[ChaActivityPoint] [int] NOT NULL,
[ChaContributionPoint] [money] NOT NULL,
[ChaItemFood] [image] NULL,
[ChaScaleRange] [float] NOT NULL,
[ChaCWDeath] [bigint] NOT NULL,
[ChaCWKill] [bigint] NOT NULL,

CONSTRAINT [PK_ChaInfo] PRIMARY KEY CLUSTERED
(
[ChaNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [SECONDARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_SGNum] DEFAULT ((0)) FOR [SGNum]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaCWDeath] DEFAULT ((0)) FOR [ChaCWDeath]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaCWKill] DEFAULT ((0)) FOR [ChaCWKill]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaScaleRange] DEFAULT ((1.0)) FOR [ChaScaleRange]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaActivityPoint] DEFAULT ((0)) FOR [ChaActivityPoint]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaBadge] DEFAULT (('')) FOR [ChaBadge]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaPKScore] DEFAULT ((0)) FOR [ChaPKScore]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaPKDeath] DEFAULT ((0)) FOR [ChaPKDeath]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaContributionPoint] DEFAULT ((0)) FOR [ChaContributionPoint]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaEquipmentLockEnable] DEFAULT ((0)) FOR [ChaEquipmentLockEnable]
GO
ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaEquipmentLockStatus] DEFAULT ((0)) FOR [ChaEquipmentLockStatus]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_GuNum] DEFAULT ((0)) FOR [GuNum]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_GuPosition] DEFAULT ((0)) FOR [GuPosition]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaGuName] DEFAULT ('') FOR [ChaGuName]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaTribe] DEFAULT ((0)) FOR [ChaTribe]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaClass] DEFAULT ((0)) FOR [ChaClass]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSchool] DEFAULT ((0)) FOR [ChaSchool]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaHair] DEFAULT ((0)) FOR [ChaHair]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaFace] DEFAULT ((0)) FOR [ChaFace]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaLiving] DEFAULT ((0)) FOR [ChaLiving]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaLevel] DEFAULT ((0)) FOR [ChaLevel]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF__ChaInfo__ChaRebo__2EDAF651] DEFAULT ((0)) FOR [ChaReborn]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaMoney] DEFAULT ((0)) FOR [ChaMoney]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaPower] DEFAULT ((0)) FOR [ChaPower]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaDex] DEFAULT ((0)) FOR [ChaDex]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSpirit] DEFAULT ((0)) FOR [ChaSpirit]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaStrong] DEFAULT ((0)) FOR [ChaStrong]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaStrength] DEFAULT ((0)) FOR [ChaStrength]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaIntel] DEFAULT ((0)) FOR [ChaIntel]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaStRemain] DEFAULT ((0)) FOR [ChaStRemain]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaExp] DEFAULT ((0)) FOR [ChaExp]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaViewRange] DEFAULT ((0)) FOR [ChaViewRange]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaHP] DEFAULT ((0)) FOR [ChaHP]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaMP] DEFAULT ((0)) FOR [ChaMP]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSP] DEFAULT ((0)) FOR [ChaSP]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaCP] DEFAULT ((0)) FOR [ChaCP]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaStartMap] DEFAULT ((0)) FOR [ChaStartMap]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaStartGate] DEFAULT ((0)) FOR [ChaStartGate]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaPosX] DEFAULT ((0)) FOR [ChaPosX]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaPosY] DEFAULT ((0)) FOR [ChaPosY]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaPosZ] DEFAULT ((0)) FOR [ChaPosZ]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSaveMap] DEFAULT ((-1)) FOR [ChaSaveMap]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSavePosX] DEFAULT ((0)) FOR [ChaSavePosX]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSavePosY] DEFAULT ((0)) FOR [ChaSavePosY]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSavePosZ] DEFAULT ((0)) FOR [ChaSavePosZ]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaReturnMap] DEFAULT ((-1)) FOR [ChaReturnMap]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaReturnPosX] DEFAULT ((0)) FOR [ChaReturnPosX]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaReturnPosY] DEFAULT ((0)) FOR [ChaReturnPosY]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaReturnPosZ] DEFAULT ((0)) FOR [ChaReturnPosZ]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaBright] DEFAULT ((0)) FOR [ChaBright]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaAttackP] DEFAULT ((0)) FOR [ChaAttackP]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaDefenseP] DEFAULT ((0)) FOR [ChaDefenseP]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaFightA] DEFAULT ((0)) FOR [ChaFightA]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaShootA] DEFAULT ((0)) FOR [ChaShootA]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaPK] DEFAULT ((0)) FOR [ChaPK]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSkillPoint] DEFAULT ((0)) FOR [ChaSkillPoint]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaInvenLine] DEFAULT ((0)) FOR [ChaInvenLine]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaDeleted] DEFAULT ((0)) FOR [ChaDeleted]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaOnline] DEFAULT ((0)) FOR [ChaOnline]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaCreateDate] DEFAULT (getdate()) FOR [ChaCreateDate]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaDeletedDate] DEFAULT (getdate()) FOR [ChaDeletedDate]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaStorage2] DEFAULT ('1970-02-01') FOR [ChaStorage2]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaStorage3] DEFAULT ('1970-02-01') FOR [ChaStorage3]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaStorage4] DEFAULT ('1970-02-01') FOR [ChaStorage4]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaGuSecede] DEFAULT ('1970-02-01') FOR [ChaGuSecede]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaReExp] DEFAULT ((0)) FOR [ChaReExp]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSpSID_1] DEFAULT ((0)) FOR [ChaSpSID]
GO

ALTER TABLE [dbo].[ChaInfo] ADD CONSTRAINT [DF_ChaInfo_ChaSpMID_1] DEFAULT ((0)) FOR [ChaSpMID]
GO

[johnteo13]

how to fix ?

[TheLeaker]

can someone share database .bak files.. ty in advanced

[knsk]

Can anyone share workable for Juver files database *.bak files (RanGame1, RanLog, RanShop, RanUser). I been tried many times clean delete up of table, views and stored procedures, with run re-query rangame1.sql with others too add on.
It still unable to login character ID after created character name.
Thank you for appreciate your reply.

[masterband1427]

Can anyone share workable for Juver files database *.bak files (RanGame1, RanLog, RanShop, RanUser). I been tried many times clean delete up of table, views and stored procedures, with run re-query rangame1.sql with others too add on.
It still unable to login character ID after created character name.
Thank you for appreciate your reply.

you need two Computer to play.. one for server one for client.. you better use Virtual Machines.. like VMWARE / Virtual Box. :)

[knsk]

you need two Computer to play.. one for server one for client.. you better use Virtual Machines.. like VMWARE / Virtual Box. :)

Yes, I am using desktop server (Dual E5-2686V4, 128G RAM) and have 30x ++ guest OS run by VMware Vsphere. My earlier was requesting someone, who can sharing workable database files the Juver files of the Destiny Ran. Nothing's to regards to 2 pc to play or sever client.
But the way, resolved now.
Thanks

- - - Updated - - -

Anyone got MiniA.exe/Game.exe file that can play 6 classes? Please sharing, thanks in advance.
Inside Juver bin game.exe only for 4 classes (Original Destiny MiniA.exe have 6 classes if login to Destiny server)
If use Destiny MiniA.exe to login for server (Juver bin tools), it will getting garbled (different code) words for login & password.

[alexmiller2]

Does anyone know how to make the GMTool work? I keep getting "Error Open User Database"

Here is my GMToolConfig.ini

user_db_server = .\SQLEXPRESS
user_db_database = RanUser
user_db_user = sa
user_db_pass = 1234
user_db_port = 1433

pretty much the same configure with gamedb, logdb and shopdb

I would really appreciate if someone give me some hints or tip.

[aizen00]

try to open your sql port

Does anyone know how to make the GMTool work? I keep getting "Error Open User Database"

Here is my GMToolConfig.ini

user_db_server = .\SQLEXPRESS
user_db_database = RanUser
user_db_user = sa
user_db_pass = 1234
user_db_port = 1433

pretty much the same configure with gamedb, logdb and shopdb

I would really appreciate if someone give me some hints or tip.

[buangnaka]

help unable to load param ini

[alexmiller2]

try to open your sql port

Thanks for the reply, still no luck. I've also tried changing the default port on SQL Manager to 1434, results are still the same.

-
Update - Fixed by installing a new OS.

[dheluxe]

Please upload the source now... hahaha 2021 already :)

[exwell]

share luncher..premeter cant use

- - - Updated - - -

I used a clean database , Im still having issue

The formal parameter "@pcID" was not declared as an OUTPUT parameter, but the actual parameter thats the error i get from my agentserver.

Can you share your db sir please? Also is the GMTool working for u?

- - - Updated - - -



try /zxc...drun for client parameter

hello wht luncher you use?

[johnteo13]

what sql version you use ?

share luncher..premeter cant use

- - - Updated - - -





hello wht luncher you use?