RFWorld
Would you like to react to this message? Create an account in a few clicks or log in to continue.

RFWorldLog in

Rising Force World

ANNOUNCEMENT

HOW TO DOWNLOAD THE FILE?

CLICK THE LINK FILE YOU WANT TO DOWNLOAD, THEN CLICK FREE ACCESS, LAST STEP IS FOLLOW THE LINK TILL YOU FIND THE FILE ORIGINAL LINK,

THIS ADS LINK MANDATORY TO KEEP OUR FORUM ALIVE♥️


PLEASE SUPPORT US BY CLICK THE ADS LINK, TURN OFF ADBLOCK ♥️

OR YOU CAN SUPPORT US THROUGH PAYPAL / SAWERIA ♥️

THE FORUM WILL BE SHUT DOWN IN THE END OF THE YEAR

IF WE GOT NO SUPPORT ANYMORE Tears





[SOLVED] Default value tbl_general NO SKILL, PT GM

4 posters

description[SOLVED] Default value tbl_general NO SKILL, PT GM Empty[SOLVED] Default value tbl_general NO SKILL, PT GMJanuary 29th 2019, 00:58

more_horiz
Hiya Guys,

saya member baru, setelah sekian lama jadi silent reader, saya obrak abrik sana sini sampe lupa cara balikin lagi langsung aja ke pertanyaannya

1. Apakah ada yang punya Default Value dari tbl_general yang NO SKILL, PT GM, Bag 3 no Bag 5 kya di official ?

dan

2. Apakah ada yang punya Default Value dari serverrate.ini kya di official?

KHUSUS:

Saya udah coba edit sendiri sql nya untuk pertanyaan pertama, mungkin bisa ada yg bantu revisi kembali
(keluhan : Pt's melebihi batas maksimum per level, job, skill 
contoh
per level 10 pt's jarak dekat maksimum 7 tapi bisa jadi 10/7
per Job Launcher yang harusnya pt's perisai maksimum 55 bisa 99/55
per skill  basic skill maksimum 7 bisa 10/7)

mungkin ada yg berkenan meng share sql default sebelum di obrak abrik untuk kedua pertanyaan diatas

makasih gan saya baru mau mulai lg buat kpentingan offline saja main pure :v

dbo_tbl_general 

Code:

USE [RF_World]
GO

/****** Object:  Table [dbo].[tbl_base]    Script Date: 01/29/2019 00:52:11 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tbl_base](
 [Serial] [int] IDENTITY(1,1) NOT NULL,
 [DCK] [bit] NOT NULL,
 [Lock] [int] NOT NULL,
 [Name] [varchar](17) NOT NULL,
 [AccountSerial] [int] NOT NULL,
 [Account] [varchar](17) NOT NULL,
 [Slot] [int] NOT NULL,
 [Race] [int] NOT NULL,
 [Class] [char](4) NOT NULL,
 [Lv] [int] NOT NULL,
 [Dalant] [int] NOT NULL,
 [Gold] [int] NOT NULL,
 [BaseShape] [int] NOT NULL,
 [EK0] [int] NOT NULL,
 [EU0] [int] NOT NULL,
 [EK1] [int] NOT NULL,
 [EU1] [int] NOT NULL,
 [EK2] [int] NOT NULL,
 [EU2] [int] NOT NULL,
 [EK3] [int] NOT NULL,
 [EU3] [int] NOT NULL,
 [EK4] [int] NOT NULL,
 [EU4] [int] NOT NULL,
 [EK5] [int] NOT NULL,
 [EU5] [int] NOT NULL,
 [EK6] [int] NOT NULL,
 [EU6] [int] NOT NULL,
 [EK7] [int] NOT NULL,
 [EU7] [int] NOT NULL,
 [LastConnTime] [int] NOT NULL,
 [CreateTime] [datetime] NOT NULL,
 [DeleteTime] [datetime] NOT NULL,
 [DeleteName] [varchar](17) NULL,
 [FirstConnTime] [int] NULL,
 [HomeServer] [varchar](33) NOT NULL,
 [Arrange] [tinyint] NOT NULL,
 [ES0] [bigint] NOT NULL,
 [ET0] [int] NOT NULL,
 [ES1] [bigint] NOT NULL,
 [ET1] [int] NOT NULL,
 [ES2] [bigint] NOT NULL,
 [ET2] [int] NOT NULL,
 [ES3] [bigint] NOT NULL,
 [ET3] [int] NOT NULL,
 [ES4] [bigint] NOT NULL,
 [ET4] [int] NOT NULL,
 [ES5] [bigint] NOT NULL,
 [ET5] [int] NOT NULL,
 [ES6] [bigint] NOT NULL,
 [ET6] [int] NOT NULL,
 [ES7] [bigint] NOT NULL,
 [ET7] [int] NOT NULL,
 CONSTRAINT [PK_tbl_base] PRIMARY KEY CLUSTERED
(
 [Serial] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
 CONSTRAINT [IX_tbl_base] UNIQUE NONCLUSTERED
(
 [Name] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_DCK]  DEFAULT ((0)) FOR [DCK]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_Lock]  DEFAULT ((0)) FOR [Lock]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_Name]  DEFAULT ('*') FOR [Name]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_Account]  DEFAULT ((0)) FOR [AccountSerial]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_Account_1]  DEFAULT ('*') FOR [Account]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_Slot]  DEFAULT ((0)) FOR [Slot]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_Race]  DEFAULT ((0)) FOR [Race]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_Class_1]  DEFAULT ('000') FOR [Class]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_Lv]  DEFAULT ((0)) FOR [Lv]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_Dalant]  DEFAULT ((0)) FOR [Dalant]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_Gold]  DEFAULT ((0)) FOR [Gold]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_BaseShape]  DEFAULT (0x00000000) FOR [BaseShape]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_EK0]  DEFAULT (0xFFFFFFFF) FOR [EK0]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_EU0]  DEFAULT (0x0FFFFFFF) FOR [EU0]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_EK1]  DEFAULT (0xFFFFFFFF) FOR [EK1]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_EU1]  DEFAULT (0x0FFFFFFF) FOR [EU1]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_EK2]  DEFAULT (0xFFFFFFFF) FOR [EK2]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_EU2]  DEFAULT (0x0FFFFFFF) FOR [EU2]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_EK3]  DEFAULT (0xFFFFFFFF) FOR [EK3]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_EU3]  DEFAULT (0x0FFFFFFF) FOR [EU3]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_EK4]  DEFAULT (0xFFFFFFFF) FOR [EK4]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_EU4]  DEFAULT (0x0FFFFFFF) FOR [EU4]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_EK5]  DEFAULT (0xFFFFFFFF) FOR [EK5]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_EU5]  DEFAULT (0x0FFFFFFF) FOR [EU5]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_EK6]  DEFAULT (0xFFFFFFFF) FOR [EK6]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_EU6]  DEFAULT (0x0FFFFFFF) FOR [EU6]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_EK7]  DEFAULT (0xFFFFFFFF) FOR [EK7]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_EU7]  DEFAULT (0x0FFFFFFF) FOR [EU7]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_LastConnTime]  DEFAULT ((0)) FOR [LastConnTime]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_CreateTime_1]  DEFAULT (getdate()) FOR [CreateTime]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_DeleteTime]  DEFAULT ((0)) FOR [DeleteTime]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_DeleteName]  DEFAULT ('*') FOR [DeleteName]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF_tbl_base_FirstConnTime]  DEFAULT ((0)) FOR [FirstConnTime]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF__tbl_base__HomeSe__5031C87B]  DEFAULT ('*') FOR [HomeServer]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF__tbl_base__Arrang__5125ECB4]  DEFAULT ((1)) FOR [Arrange]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF__tbl_base__ES0__6787338D]  DEFAULT ((0)) FOR [ES0]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF__tbl_base__ET0__687B57C6]  DEFAULT (0xFFFFFFFF) FOR [ET0]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF__tbl_base__ES1__696F7BFF]  DEFAULT ((0)) FOR [ES1]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF__tbl_base__ET1__6A63A038]  DEFAULT (0xFFFFFFFF) FOR [ET1]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF__tbl_base__ES2__6B57C471]  DEFAULT ((0)) FOR [ES2]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF__tbl_base__ET2__6C4BE8AA]  DEFAULT (0xFFFFFFFF) FOR [ET2]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF__tbl_base__ES3__6D400CE3]  DEFAULT ((0)) FOR [ES3]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF__tbl_base__ET3__6E34311C]  DEFAULT (0xFFFFFFFF) FOR [ET3]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF__tbl_base__ES4__6F285555]  DEFAULT ((0)) FOR [ES4]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF__tbl_base__ET4__701C798E]  DEFAULT (0xFFFFFFFF) FOR [ET4]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF__tbl_base__ES5__71109DC7]  DEFAULT ((0)) FOR [ES5]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF__tbl_base__ET5__7204C200]  DEFAULT (0xFFFFFFFF) FOR [ET5]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF__tbl_base__ES6__72F8E639]  DEFAULT ((0)) FOR [ES6]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF__tbl_base__ET6__73ED0A72]  DEFAULT (0xFFFFFFFF) FOR [ET6]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF__tbl_base__ES7__74E12EAB]  DEFAULT ((0)) FOR [ES7]
GO

ALTER TABLE [dbo].[tbl_base] ADD  CONSTRAINT [DF__tbl_base__ET7__75D552E4]  DEFAULT (0xFFFFFFFF) FOR [ET7]
GO


description[SOLVED] Default value tbl_general NO SKILL, PT GM EmptyRe: [SOLVED] Default value tbl_general NO SKILL, PT GMJanuary 29th 2019, 23:18

more_horiz
bantu jawab gan...

1. dari pada pakai query, pakai panel gm capiroto aja ada di thread rf offline, ada option max lv 66, buka quest 50/55, insert guild, cash shop, premium dll.

2. Maksud nya official gmn ? rf official indo? krg tau sih kyknya non shareable, atau bisa kalkulasi sendiri... Very Happy

3. setahu ane pt melebihi itu ga ada sangkut paut sm sql gan, mgkn di client side dibagian Datatable>Character.edf mgkn ya, serverside nya class.dat maybe, CMIIW.  [SOLVED] Default value tbl_general NO SKILL, PT GM 1f605

description[SOLVED] Default value tbl_general NO SKILL, PT GM EmptyRe: [SOLVED] Default value tbl_general NO SKILL, PT GMFebruary 11th 2019, 13:11

more_horiz
Permasalahan PT biasanya ada d file berikut, Client: Character.edf & RF_Online.bin, Server: 4 file dat class mastery limit (SpecialistMasteryLimit.dat ; SpiritualistMasteryLimit.dat ; WarriorMasteryLimit.dat ; RangerMasteryLimit.dat). Coba d cek satu per satu, mungkin ada yg g sinkron.

Server Files + Client ny pake yg pure ga? (pure blm d otak-atik, terutama d bagian yg d sebutin d atas). Klw pure seharusny g ada masalah ketika execute query & in game juga PT ny pasti aman.

description[SOLVED] Default value tbl_general NO SKILL, PT GM EmptyRe: [SOLVED] Default value tbl_general NO SKILL, PT GMMarch 17th 2020, 02:12

more_horiz
Solved.


description[SOLVED] Default value tbl_general NO SKILL, PT GM EmptyRe: [SOLVED] Default value tbl_general NO SKILL, PT GM

more_horiz
privacy_tip Permissions in this forum:
You cannot reply to topics in this forum