Рейты

Merciful · 02.05.2010, 13:23

Так вопрос как менять рейты на серве? (Строго не судите поиск юзал ни чего не нашел)

P.S заранее спасибо

edaks9 · 02.05.2010, 20:03

в скрипте Exp.dat прописывай
на крайняк сделай джейд

edaks9 · 02.05.2010, 20:14

и вот для 223 серва можно прописать в инишке она кажется называется serverrate.ini но при этом откроетя баг с 99.9% его залатай вот так :
Вставляй в Query Analyser данную процедуру:

Код:

CREATE TRIGGER [Exp_223_Fix]
ON [tbl_general] 
AFTER UPDATE
AS 
BEGIN
DECLARE
@exp float,
@serial int,
@lostexp float

SELECT @exp = (Select Exp FROM inserted)
SELECT @serial = (Select Serial FROM inserted)
SELECT @lostexp = (Select LossExp FROM inserted)

IF (@Exp < 0) AND (@lostexp = 0)
BEGIN
SET @exp = (SELECT Exp FROM Deleted)
UPDATE tbl_general SET [Exp]=@exp WHERE [Serial]=@serial
END

ELSE IF (@Exp < 0)
BEGIN
SET @exp = (@exp + @lostexp)
UPDATE tbl_general SET [Exp]=@exp, [LossExp] = '0' WHERE [Serial]=@serial
END
ELSE
BEGIN
SET @exp = @exp*1
END 
END

для пт и магии вот
УДАЛЯЕМ ИЗ БАЗЫ ТАБЛИЦУ tbl_general И ДЕЛАЕМ запрос:

Код:

USE [ИМЯ ВАШЕЙ БАЗЫ]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl_general](
[Serial] [int] NOT NULL CONSTRAINT [DF_tbl_general_Serial] DEFAULT ((-1)),
[DCK] [bit] NOT NULL CONSTRAINT [DF_tbl_general_DCK] DEFAULT (0),
[TotalPlayMin] [int] NOT NULL CONSTRAINT [DF_tbl_general_TotalPlayMin] DEFAULT (0),
[Exp] [float] NOT NULL CONSTRAINT [DF_tbl_general_Exp] DEFAULT (0),
[LossExp] [float] NOT NULL CONSTRAINT [DF_tbl_general_LossExp] DEFAULT (0),
[HP] [int] NOT NULL CONSTRAINT [DF_tbl_general_HP] DEFAULT (1000),
[FP] [int] NOT NULL CONSTRAINT [DF_tbl_general_FP] DEFAULT (1000),
[SP] [int] NOT NULL CONSTRAINT [DF_tbl_general_SP] DEFAULT (1000),
[DP] [int] NOT NULL CONSTRAINT [DF_tbl_general_DP] DEFAULT (0),
[Map] [int] NOT NULL CONSTRAINT [DF_tbl_general_Map] DEFAULT (0),
[X] [float] NOT NULL CONSTRAINT [DF_tbl_general_X] DEFAULT (0),
[Y] [float] NOT NULL CONSTRAINT [DF_tbl_general_Y] DEFAULT (65535),
[Z] [float] NOT NULL CONSTRAINT [DF_tbl_general_Z] DEFAULT (0),
[BagNum] [int] NOT NULL CONSTRAINT [DF_tbl_general_BagNum] DEFAULT ((5)),
[EK0] [int] NOT NULL CONSTRAINT [DF_tbl_general_EK0] DEFAULT (0xffffffff),
[ED0] [smallint] NOT NULL CONSTRAINT [DF_tbl_general_ED0] DEFAULT (0),
[EK1] [int] NOT NULL CONSTRAINT [DF_tbl_general_EK1] DEFAULT (0xffffffff),
[ED1] [smallint] NOT NULL CONSTRAINT [DF_tbl_general_ED1] DEFAULT (0),
[EK2] [int] NOT NULL CONSTRAINT [DF_tbl_general_EK2] DEFAULT (0xffffffff),
[ED2] [smallint] NOT NULL CONSTRAINT [DF_tbl_general_ED2] DEFAULT (0),
[EK3] [int] NOT NULL CONSTRAINT [DF_tbl_general_EK3] DEFAULT (0xffffffff),
[ED3] [smallint] NOT NULL CONSTRAINT [DF_tbl_general_ED3] DEFAULT (0),
[EK4] [int] NOT NULL CONSTRAINT [DF_tbl_general_EK4] DEFAULT (0xffffffff),
[ED4] [smallint] NOT NULL CONSTRAINT [DF_tbl_general_ED4] DEFAULT (0),
[EK5] [int] NOT NULL CONSTRAINT [DF_tbl_general_EK5] DEFAULT (0xffffffff),
[ED5] [smallint] NOT NULL CONSTRAINT [DF_tbl_general_ED5] DEFAULT (0),
[F0] [int] NOT NULL CONSTRAINT [DF_tbl_general_F0] DEFAULT (16777215),
[F1] [int] NOT NULL CONSTRAINT [DF_tbl_general_F1] DEFAULT (33554431),
[F2] [int] NOT NULL CONSTRAINT [DF_tbl_general_F2] DEFAULT (50331647),
[F3] [int] NOT NULL CONSTRAINT [DF_tbl_general_F3] DEFAULT (67108863),
[F4] [int] NOT NULL CONSTRAINT [DF_tbl_general_F4] DEFAULT (83886079),
[F5] [int] NOT NULL CONSTRAINT [DF_tbl_general_F5] DEFAULT (100663295),
[F6] [int] NOT NULL CONSTRAINT [DF_tbl_general_F6] DEFAULT (117440511),
[F7] [int] NOT NULL CONSTRAINT [DF_tbl_general_F7] DEFAULT (134217727),
[F8] [int] NOT NULL CONSTRAINT [DF_tbl_general_F8] DEFAULT (150994943),
[F9] [int] NOT NULL CONSTRAINT [DF_tbl_general_F9] DEFAULT (167772159),
[F10] [int] NOT NULL CONSTRAINT [DF_tbl_general_F10] DEFAULT (184549375),
[F11] [int] NOT NULL CONSTRAINT [DF_tbl_general_F11] DEFAULT (201326591),
[F12] [int] NOT NULL CONSTRAINT [DF_tbl_general_F12] DEFAULT (218103807),
[F13] [int] NOT NULL CONSTRAINT [DF_tbl_general_F13] DEFAULT (234881023),
[F14] [int] NOT NULL CONSTRAINT [DF_tbl_general_F14] DEFAULT (251658239),
[F15] [int] NOT NULL CONSTRAINT [DF_tbl_general_F15] DEFAULT (268435455),
[F16] [int] NOT NULL CONSTRAINT [DF_tbl_general_F16] DEFAULT (285212671),
[F17] [int] NOT NULL CONSTRAINT [DF_tbl_general_F17] DEFAULT (301989887),
[F18] [int] NOT NULL CONSTRAINT [DF_tbl_general_F18] DEFAULT (318767103),
[F19] [int] NOT NULL CONSTRAINT [DF_tbl_general_F19] DEFAULT (335544319),
[F20] [int] NOT NULL CONSTRAINT [DF_tbl_general_F20] DEFAULT (352321535),
[F21] [int] NOT NULL CONSTRAINT [DF_tbl_general_F21] DEFAULT (369098751),
[F22] [int] NOT NULL CONSTRAINT [DF_tbl_general_F22] DEFAULT (385875967),
[F23] [int] NOT NULL CONSTRAINT [DF_tbl_general_F23] DEFAULT (402653183),
[F24] [int] NOT NULL CONSTRAINT [DF_tbl_general_F24] DEFAULT (419430399),
[F25] [int] NOT NULL CONSTRAINT [DF_tbl_general_F25] DEFAULT (436207615),
[F26] [int] NOT NULL CONSTRAINT [DF_tbl_general_F26] DEFAULT (452984831),
[F27] [int] NOT NULL CONSTRAINT [DF_tbl_general_F27] DEFAULT (469762047),
[F28] [int] NOT NULL CONSTRAINT [DF_tbl_general_F28] DEFAULT (503316479),
[F29] [int] NOT NULL CONSTRAINT [DF_tbl_general_F29] DEFAULT (520093695),
[F30] [int] NOT NULL CONSTRAINT [DF_tbl_general_F30] DEFAULT (536870911),
[F31] [int] NOT NULL CONSTRAINT [DF_tbl_general_F31] DEFAULT (553648127),
[F32] [int] NOT NULL CONSTRAINT [DF_tbl_general_F32] DEFAULT (570425343),
[F33] [int] NOT NULL CONSTRAINT [DF_tbl_general_F33] DEFAULT (587202559),
[F34] [int] NOT NULL CONSTRAINT [DF_tbl_general_F34] DEFAULT (603979775),
[F35] [int] NOT NULL CONSTRAINT [DF_tbl_general_F35] DEFAULT (620756991),
[F36] [int] NOT NULL CONSTRAINT [DF_tbl_general_F36] DEFAULT (637534207),
[F37] [int] NOT NULL CONSTRAINT [DF_tbl_general_F37] DEFAULT (654311423),
[F38] [int] NOT NULL CONSTRAINT [DF_tbl_general_F38] DEFAULT (671088639),
[F39] [int] NOT NULL CONSTRAINT [DF_tbl_general_F39] DEFAULT (687865855),
[F40] [int] NOT NULL CONSTRAINT [DF_tbl_general_F40] DEFAULT (704643071),
[F41] [int] NOT NULL CONSTRAINT [DF_tbl_general_F41] DEFAULT (721420287),
[F42] [int] NOT NULL CONSTRAINT [DF_tbl_general_F42] DEFAULT (738197503),
[F43] [int] NOT NULL CONSTRAINT [DF_tbl_general_F43] DEFAULT (771751935),
[F44] [int] NOT NULL CONSTRAINT [DF_tbl_general_F44] DEFAULT (788529151),
[F45] [int] NOT NULL CONSTRAINT [DF_tbl_general_F45] DEFAULT (805306367),
[F46] [int] NOT NULL CONSTRAINT [DF_tbl_general_F46] DEFAULT (822083583),
[F47] [int] NOT NULL CONSTRAINT [DF_tbl_general_F47] DEFAULT (838860799),
[F48] [int] NOT NULL CONSTRAINT [DF_tbl_general_F48] DEFAULT (855638015),
[F49] [int] NOT NULL CONSTRAINT [DF_tbl_general_F49] DEFAULT (872415231),
[F50] [int] NOT NULL CONSTRAINT [DF_tbl_general_F50] DEFAULT (889192447),
[F51] [int] NOT NULL CONSTRAINT [DF_tbl_general_F51] DEFAULT (905969663),
[F52] [int] NOT NULL CONSTRAINT [DF_tbl_general_F52] DEFAULT (922746879),
[F53] [int] NOT NULL CONSTRAINT [DF_tbl_general_F53] DEFAULT (939524095),
[F54] [int] NOT NULL CONSTRAINT [DF_tbl_general_F54] DEFAULT (956301311),
[F55] [int] NOT NULL CONSTRAINT [DF_tbl_general_F55] DEFAULT (973078527),
[F56] [int] NOT NULL CONSTRAINT [DF_tbl_general_F56] DEFAULT (989855743),
[F57] [int] NOT NULL CONSTRAINT [DF_tbl_general_F57] DEFAULT (1006632959),
[F58] [int] NOT NULL CONSTRAINT [DF_tbl_general_F58] DEFAULT (1040187391),
[F59] [int] NOT NULL CONSTRAINT [DF_tbl_general_F59] DEFAULT (1056964607),
[F60] [int] NOT NULL CONSTRAINT [DF_tbl_general_F60] DEFAULT (1073741823),
[F61] [int] NOT NULL CONSTRAINT [DF_tbl_general_F61] DEFAULT (1090519039),
[F62] [int] NOT NULL CONSTRAINT [DF_tbl_general_F62] DEFAULT (1107296255),
[F63] [int] NOT NULL CONSTRAINT [DF_tbl_general_F63] DEFAULT (1124073471),
[F64] [int] NOT NULL CONSTRAINT [DF_tbl_general_F64] DEFAULT (1140850687),
[F65] [int] NOT NULL CONSTRAINT [DF_tbl_general_F65] DEFAULT (1157627903),
[F66] [int] NOT NULL CONSTRAINT [DF_tbl_general_F66] DEFAULT (1174405119),
[F67] [int] NOT NULL CONSTRAINT [DF_tbl_general_F67] DEFAULT (1191182335),
[F68] [int] NOT NULL CONSTRAINT [DF_tbl_general_F68] DEFAULT (1207959551),
[F69] [int] NOT NULL CONSTRAINT [DF_tbl_general_F69] DEFAULT (1224736767),
[F70] [int] NOT NULL CONSTRAINT [DF_tbl_general_F70] DEFAULT (1241513983),
[F71] [int] NOT NULL CONSTRAINT [DF_tbl_general_F71] DEFAULT (1258291199),
[F72] [int] NOT NULL CONSTRAINT [DF_tbl_general_F72] DEFAULT (1275068415),
[F73] [int] NOT NULL CONSTRAINT [DF_tbl_general_F73] DEFAULT (1308622847),
[F74] [int] NOT NULL CONSTRAINT [DF_tbl_general_F74] DEFAULT (1325400063),
[F75] [int] NOT NULL CONSTRAINT [DF_tbl_general_F75] DEFAULT (1342177279),
[F76] [int] NOT NULL CONSTRAINT [DF_tbl_general_F76] DEFAULT (1358954495),
[F77] [int] NOT NULL CONSTRAINT [DF_tbl_general_F77] DEFAULT (1375731711),
[F78] [int] NOT NULL CONSTRAINT [DF_tbl_general_F78] DEFAULT (1392508927),
[F79] [int] NOT NULL CONSTRAINT [DF_tbl_general_F79] DEFAULT (1409286143),
[F80] [int] NOT NULL CONSTRAINT [DF_tbl_general_F80] DEFAULT (1426063359),
[F81] [int] NOT NULL CONSTRAINT [DF_tbl_general_F81] DEFAULT (1442840575),
[F82] [int] NOT NULL CONSTRAINT [DF_tbl_general_F82] DEFAULT (1459617791),
[F83] [int] NOT NULL CONSTRAINT [DF_tbl_general_F83] DEFAULT (1476395007),
[F84] [int] NOT NULL CONSTRAINT [DF_tbl_general_F84] DEFAULT (1493172223),
[F85] [int] NOT NULL CONSTRAINT [DF_tbl_general_F85] DEFAULT (1509949439),
[F86] [int] NOT NULL CONSTRAINT [DF_tbl_general_F86] DEFAULT (1526726655),
[F87] [int] NOT NULL CONSTRAINT [DF_tbl_general_F87] DEFAULT (1543503871),
[F88] [int] NOT NULL CONSTRAINT [DF_tbl_general_F88] DEFAULT (0xffffffff),
[F89] [int] NOT NULL CONSTRAINT [DF_tbl_general_F89] DEFAULT (0xffffffff),
[F90] [int] NOT NULL CONSTRAINT [DF_tbl_general_F90] DEFAULT (0xffffffff),
[F91] [int] NOT NULL CONSTRAINT [DF_tbl_general_F91] DEFAULT (0xffffffff),
[F92] [int] NOT NULL CONSTRAINT [DF_tbl_general_F92] DEFAULT (0xffffffff),
[F93] [int] NOT NULL CONSTRAINT [DF_tbl_general_F93] DEFAULT (0xffffffff),
[F94] [int] NOT NULL CONSTRAINT [DF_tbl_general_F94] DEFAULT (0xffffffff),
[F95] [int] NOT NULL CONSTRAINT [DF_tbl_general_F95] DEFAULT (0xffffffff),
[F96] [int] NOT NULL CONSTRAINT [DF_tbl_general_F96] DEFAULT (0xffffffff),
[F97] [int] NOT NULL CONSTRAINT [DF_tbl_general_F97] DEFAULT (0xffffffff),
[F98] [int] NOT NULL CONSTRAINT [DF_tbl_general_F98] DEFAULT (0xffffffff),
[F99] [int] NOT NULL CONSTRAINT [DF_tbl_general_F99] DEFAULT (0xffffffff),
[AK0] [tinyint] NOT NULL CONSTRAINT [DF_tbl_general_AK0] DEFAULT (0xff),
[AD0] [bigint] NOT NULL CONSTRAINT [DF_tbl_general_AD0] DEFAULT (0),
[AP0] [int] NOT NULL CONSTRAINT [DF_tbl_general_AP] DEFAULT (0),
[AK1] [tinyint] NOT NULL CONSTRAINT [DF_tbl_general_AK01] DEFAULT (0xff),
[AD1] [bigint] NOT NULL CONSTRAINT [DF_tbl_general_AD1] DEFAULT (0),
[AP1] [int] NOT NULL CONSTRAINT [DF_tbl_general_AP1] DEFAULT (0),
[AK2] [tinyint] NOT NULL CONSTRAINT [DF_tbl_general_AK01_1] DEFAULT (0xff),
[AD2] [bigint] NOT NULL CONSTRAINT [DF_tbl_general_AD2] DEFAULT (0),
[AP2] [int] NOT NULL CONSTRAINT [DF_tbl_general_AP2] DEFAULT (0),
[AK3] [tinyint] NOT NULL CONSTRAINT [DF_tbl_general_AK01_2] DEFAULT (0xff),
[AD3] [bigint] NOT NULL CONSTRAINT [DF_tbl_general_AD3] DEFAULT (0),
[AP3] [int] NOT NULL CONSTRAINT [DF_tbl_general_AP3] DEFAULT (0),
[WM0] [int] NOT NULL CONSTRAINT [DF_tbl_general_WM0] DEFAULT (2147483647),
[WM1] [int] NOT NULL CONSTRAINT [DF_tbl_general_WM1] DEFAULT (2147483647),
[DM] [int] NOT NULL CONSTRAINT [DF_tbl_general_DM] DEFAULT (2147483647),
[PM] [int] NOT NULL CONSTRAINT [DF_tbl_general_PM] DEFAULT (2147483647),
[MI0] [int] NOT NULL CONSTRAINT [DF_tbl_general_MI] DEFAULT (2147483647),
[MI1] [int] NOT NULL CONSTRAINT [DF_tbl_general_MI1] DEFAULT (2147483647),
[MI2] [int] NOT NULL CONSTRAINT [DF_tbl_general_MI2] DEFAULT (2147483647),
[SR] [int] NOT NULL CONSTRAINT [DF_tbl_general_SR] DEFAULT (2147483647),
[FM0] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM0] DEFAULT (2147483647),
[FM1] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM1] DEFAULT (2147483647),
[FM2] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM2] DEFAULT (2147483647),
[FM3] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM3] DEFAULT (2147483647),
[FM4] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM4] DEFAULT (2147483647),
[FM5] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM5] DEFAULT (2147483647),
[FM6] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM6] DEFAULT (2147483647),
[FM7] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM7] DEFAULT (2147483647),
[FM8] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM8] DEFAULT (2147483647),
[FM9] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM9] DEFAULT (2147483647),
[FM10] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM10] DEFAULT (2147483647),
[FM11] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM11] DEFAULT (2147483647),
[FM12] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM12] DEFAULT (2147483647),
[FM13] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM13] DEFAULT (2147483647),
[FM14] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM14] DEFAULT (2147483647),
[FM15] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM15] DEFAULT (2147483647),
[FM16] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM16] DEFAULT (2147483647),
[FM17] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM17] DEFAULT (2147483647),
[FM18] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM18] DEFAULT (2147483647),
[FM19] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM19] DEFAULT (2147483647),
[FM20] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM20] DEFAULT (2147483647),
[FM21] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM21] DEFAULT (2147483647),
[FM22] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM22] DEFAULT (2147483647),
[FM23] [int] NOT NULL CONSTRAINT [DF_tbl_general_FM23] DEFAULT (2147483647),
[SM0] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM0] DEFAULT (357913952),
[SM1] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM1] DEFAULT (357913952),
[SM2] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM2] DEFAULT (357913952),
[SM3] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM3] DEFAULT (357913952),
[SM4] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM4] DEFAULT (357913952),
[SM5] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM5] DEFAULT (357913952),
[SM6] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM6] DEFAULT (357913952),
[SM7] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM7] DEFAULT (357913952),
[SM8] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM8] DEFAULT (357913952),
[SM9] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM9] DEFAULT (357913952),
[SM10] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM10] DEFAULT (357913952),
[SM11] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM11] DEFAULT (357913952),
[SM12] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM12] DEFAULT (429496736),
[SM13] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM13] DEFAULT (429496736),
[SM14] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM14] DEFAULT (429496736),
[SM15] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM15] DEFAULT (429496736),
[SM16] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM16] DEFAULT (429496736),
[SM17] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM17] DEFAULT (0),
[SM18] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM18] DEFAULT (357913952),
[SM19] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM19] DEFAULT (357913952),
[SM20] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM20] DEFAULT (357913952),
[SM21] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM21] DEFAULT (357913952),
[SM22] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM22] DEFAULT (357913952),
[SM23] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM23] DEFAULT (357913952),
[SM24] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM01] DEFAULT (715827904),
[SM25] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM02] DEFAULT (0),
[SM26] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM03] DEFAULT (0),
[SM27] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM04] DEFAULT (715827904),
[SM28] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM05] DEFAULT (715827904),
[SM29] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM06] DEFAULT (0),
[SM30] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM01_1] DEFAULT (536870912),
[SM31] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM211] DEFAULT (536870912),
[SM32] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM221] DEFAULT (0),
[SM33] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM231] DEFAULT (536870912),
[SM34] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM241] DEFAULT (536870912),
[SM35] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM251] DEFAULT (0),
[SM36] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM261] DEFAULT (715827904),
[SM37] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM271] DEFAULT (715827904),
[SM38] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM281] DEFAULT (0),
[SM39] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM291] DEFAULT (715827904),
[SM40] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM40] DEFAULT (0),
[SM41] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM401] DEFAULT (0),
[SM42] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM402] DEFAULT (0),
[SM43] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM403] DEFAULT (0),
[SM44] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM404] DEFAULT (0),
[SM45] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM405] DEFAULT (-2147483647),
[SM46] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM406] DEFAULT (0),
[SM47] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM407] DEFAULT (0),
[SM48] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM408] DEFAULT (0),
[SM49] [int] NOT NULL CONSTRAINT [DF_tbl_general_SM409] DEFAULT (0),
[LeftResList] [varchar](160) COLLATE Latin1_General_CI_AS NOT NULL CONSTRAINT [DF_tbl_general_LeftResList] DEFAULT ('*'),
[Class0] [smallint] NOT NULL CONSTRAINT [DF_tbl_general_Class0] DEFAULT ((-1)),
[Class1] [smallint] NOT NULL CONSTRAINT [DF_tbl_general_Class1] DEFAULT ((-1)),
[Class2] [smallint] NOT NULL CONSTRAINT [DF_tbl_general_Class2] DEFAULT ((-1)),
[ClassInitCnt] [int] NOT NULL CONSTRAINT [DF_tbl_general_ClassInitCnt] DEFAULT (0),
[LastClassGrade] [tinyint] NOT NULL CONSTRAINT [DF_tbl_general_LastClassGrade] DEFAULT (0),
[PvpPoint] [float] NOT NULL CONSTRAINT [DF_tbl_general_PvPPoint] DEFAULT (0),
[PvpCashBag] [float] NOT NULL CONSTRAINT [DF_tbl_general_PvPCashBag] DEFAULT (0),
[BindMapCode] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL CONSTRAINT [DF_tbl_general_BindMapCode] DEFAULT ('0'),
[BindDummy] [varchar](12) COLLATE Latin1_General_CI_AS NOT NULL CONSTRAINT [DF_tbl_general_BindDummy] DEFAULT ('0'),
[GuildSerial] [int] NULL CONSTRAINT [DF_tbl_General_GuildSerial] DEFAULT (0xffffffff),
[GuildGrade] [tinyint] NULL CONSTRAINT [DF_tbl_General_GuildGrade] DEFAULT (0xff),
[GuildRank] [smallint] NULL CONSTRAINT [DF_tbl_general_GuildRank] DEFAULT (0xffff),
[tmRaceBossVote] [datetime] NOT NULL CONSTRAINT [DF_tbl_general_tmracebossvote] DEFAULT ('1990-01-01'),
[RDDelay] [int] NOT NULL CONSTRAINT [DF_tbl_general_RDDelay] DEFAULT (0),
[TakeLastMentalTicket] [int] NOT NULL CONSTRAINT [DF_tbl_general_TakeLastMentalTicket] DEFAULT (0),
[TakeLastCriTicket] [int] NOT NULL CONSTRAINT [DF_tbl_general_TakeLastCriTicket] DEFAULT (0),
[ES0] [bigint] NOT NULL DEFAULT (0),
[ET0] [int] NOT NULL DEFAULT (0xffffffff),
[ES1] [bigint] NOT NULL DEFAULT (0),
[ET1] [int] NOT NULL DEFAULT (0xffffffff),
[ES2] [bigint] NOT NULL DEFAULT (0),
[ET2] [int] NOT NULL DEFAULT (0xffffffff),
[ES3] [bigint] NOT NULL DEFAULT (0),
[ET3] [int] NOT NULL DEFAULT (0xffffffff),
[ES4] [bigint] NOT NULL DEFAULT (0),
[ET4] [int] NOT NULL DEFAULT (0xffffffff),
[ES5] [bigint] NOT NULL DEFAULT (0),
[ET5] [int] NOT NULL DEFAULT (0xffffffff),
[AS0] [bigint] NOT NULL DEFAULT (0),
[AS1] [bigint] NOT NULL DEFAULT (0),
[AS2] [bigint] NOT NULL DEFAULT (0),
[AS3] [bigint] NOT NULL DEFAULT (0),
[FS0] [bigint] NOT NULL DEFAULT (80350831968256),
[FS1] [bigint] NOT NULL DEFAULT (80350831968256),
[FS2] [bigint] NOT NULL DEFAULT (80350831968256),
[FS3] [bigint] NOT NULL DEFAULT (80350831968256),
[FS4] [bigint] NOT NULL DEFAULT (80350831968256),
[FS5] [bigint] NOT NULL DEFAULT (80350831968256),
[FS6] [bigint] NOT NULL DEFAULT (80350831968256),
[FS7] [bigint] NOT NULL DEFAULT (80350831968256),
[FS8] [bigint] NOT NULL DEFAULT (80350831968256),
[FS9] [bigint] NOT NULL DEFAULT (80350831968256),
[FS10] [bigint] NOT NULL DEFAULT (80350831968256),
[FS11] [bigint] NOT NULL DEFAULT (80350831968256),
[FS12] [bigint] NOT NULL DEFAULT (80350831968256),
[FS13] [bigint] NOT NULL DEFAULT (80350831968256),
[FS14] [bigint] NOT NULL DEFAULT (80350831968256),
[FS15] [bigint] NOT NULL DEFAULT (80350831968256),
[FS16] [bigint] NOT NULL DEFAULT (80350831968256),
[FS17] [bigint] NOT NULL DEFAULT (80350831968256),
[FS18] [bigint] NOT NULL DEFAULT (80350831968256),
[FS19] [bigint] NOT NULL DEFAULT (80350831968256),
[FS20] [bigint] NOT NULL DEFAULT (80350831968256),
[FS21] [bigint] NOT NULL DEFAULT (80350831968256),
[FS22] [bigint] NOT NULL DEFAULT (80350831968256),
[FS23] [bigint] NOT NULL DEFAULT (80350831968256),
[FS24] [bigint] NOT NULL DEFAULT (80350831968256),
[FS25] [bigint] NOT NULL DEFAULT (80350831968256),
[FS26] [bigint] NOT NULL DEFAULT (80350831968256),
[FS27] [bigint] NOT NULL DEFAULT (80350831968256),
[FS28] [bigint] NOT NULL DEFAULT (80350831968256),
[FS29] [bigint] NOT NULL DEFAULT (80350831968256),
[FS30] [bigint] NOT NULL DEFAULT (80350831968256),
[FS31] [bigint] NOT NULL DEFAULT (80350831968256),
[FS32] [bigint] NOT NULL DEFAULT (80350831968256),
[FS33] [bigint] NOT NULL DEFAULT (80350831968256),
[FS34] [bigint] NOT NULL DEFAULT (80350831968256),
[FS35] [bigint] NOT NULL DEFAULT (80350831968256),
[FS36] [bigint] NOT NULL DEFAULT (80350831968256),
[FS37] [bigint] NOT NULL DEFAULT (80350831968256),
[FS38] [bigint] NOT NULL DEFAULT (80350831968256),
[FS39] [bigint] NOT NULL DEFAULT (80350831968256),
[FS40] [bigint] NOT NULL DEFAULT (80350831968256),
[FS41] [bigint] NOT NULL DEFAULT (80350831968256),
[FS42] [bigint] NOT NULL DEFAULT (80350831968256),
[FS43] [bigint] NOT NULL DEFAULT (80350831968256),
[FS44] [bigint] NOT NULL DEFAULT (80350831968256),
[FS45] [bigint] NOT NULL DEFAULT (80350831968256),
[FS46] [bigint] NOT NULL DEFAULT (80350831968256),
[FS47] [bigint] NOT NULL DEFAULT (80350831968256),
[FS48] [bigint] NOT NULL DEFAULT (80350831968256),
[FS49] [bigint] NOT NULL DEFAULT (80350831968256),
[FS50] [bigint] NOT NULL DEFAULT (80350831968256),
[FS51] [bigint] NOT NULL DEFAULT (80350831968256),
[FS52] [bigint] NOT NULL DEFAULT (80350831968256),
[FS53] [bigint] NOT NULL DEFAULT (80350831968256),
[FS54] [bigint] NOT NULL DEFAULT (80350831968256),
[FS55] [bigint] NOT NULL DEFAULT (80350831968256),
[FS56] [bigint] NOT NULL DEFAULT (80350831968256),
[FS57] [bigint] NOT NULL DEFAULT (80350831968256),
[FS58] [bigint] NOT NULL DEFAULT (80350831968256),
[FS59] [bigint] NOT NULL DEFAULT (80350831968256),
[FS60] [bigint] NOT NULL DEFAULT (80350831968256),
[FS61] [bigint] NOT NULL DEFAULT (80350831968256),
[FS62] [bigint] NOT NULL DEFAULT (80350831968256),
[FS63] [bigint] NOT NULL DEFAULT (80350831968256),
[FS64] [bigint] NOT NULL DEFAULT (80350831968256),
[FS65] [bigint] NOT NULL DEFAULT (80350831968256),
[FS66] [bigint] NOT NULL DEFAULT (80350831968256),
[FS67] [bigint] NOT NULL DEFAULT (80350831968256),
[FS68] [bigint] NOT NULL DEFAULT (80350831968256),
[FS69] [bigint] NOT NULL DEFAULT (80350831968256),
[FS70] [bigint] NOT NULL DEFAULT (80350831968256),
[FS71] [bigint] NOT NULL DEFAULT (80350831968256),
[FS72] [bigint] NOT NULL DEFAULT (80350831968256),
[FS73] [bigint] NOT NULL DEFAULT (80350831968256),
[FS74] [bigint] NOT NULL DEFAULT (80350831968256),
[FS75] [bigint] NOT NULL DEFAULT (80350831968256),
[FS76] [bigint] NOT NULL DEFAULT (80350831968256),
[FS77] [bigint] NOT NULL DEFAULT (80350831968256),
[FS78] [bigint] NOT NULL DEFAULT (80350831968256),
[FS79] [bigint] NOT NULL DEFAULT (80350831968256),
[FS80] [bigint] NOT NULL DEFAULT (80350831968256),
[FS81] [bigint] NOT NULL DEFAULT (80350831968256),
[FS82] [bigint] NOT NULL DEFAULT (80350831968256),
[FS83] [bigint] NOT NULL DEFAULT (80350831968256),
[FS84] [bigint] NOT NULL DEFAULT (80350831968256),
[FS85] [bigint] NOT NULL DEFAULT (80350831968256),
[FS86] [bigint] NOT NULL DEFAULT (80350831968256),
[FS87] [bigint] NOT NULL DEFAULT (80350831968256),
[FS88] [bigint] NOT NULL DEFAULT (0),
[FS89] [bigint] NOT NULL DEFAULT (0),
[FS90] [bigint] NOT NULL DEFAULT (0),
[FS91] [bigint] NOT NULL DEFAULT (0),
[FS92] [bigint] NOT NULL DEFAULT (0),
[FS93] [bigint] NOT NULL DEFAULT (0),
[FS94] [bigint] NOT NULL DEFAULT (0),
[FS95] [bigint] NOT NULL DEFAULT (0),
[FS96] [bigint] NOT NULL DEFAULT (0),
[FS97] [bigint] NOT NULL DEFAULT (0),
[FS98] [bigint] NOT NULL DEFAULT (0),
[FS99] [bigint] NOT NULL DEFAULT (0),
[MaxLevel] [int] NOT NULL DEFAULT (0),
[PvP_0] [float] NOT NULL CONSTRAINT [DF_tbl_general_PvP_0] DEFAULT (0),
[PK_0] [int] NOT NULL CONSTRAINT [DF_tbl_general_PK_0] DEFAULT (0),
[PvP_1] [float] NOT NULL CONSTRAINT [DF_tbl_general_PvP_1] DEFAULT (0),
[PK_1] [int] NOT NULL CONSTRAINT [DF_tbl_general_PK_1] DEFAULT (0),
[PvP_2] [float] NOT NULL CONSTRAINT [DF_tbl_general_PvP_2] DEFAULT (0),
[PK_2] [int] NOT NULL CONSTRAINT [DF_tbl_general_PK_2] DEFAULT (0),
[CharacterGrade] [int] NULL CONSTRAINT [DF_tbl_general__CharacterGrade] DEFAULT (0),
[Die_0] [int] NOT NULL CONSTRAINT [DF_tbl_general_Die_0] DEFAULT (0),
[Die_1] [int] NOT NULL CONSTRAINT [DF_tbl_general_Die_1] DEFAULT (0),
[Die_2] [int] NOT NULL CONSTRAINT [DF_tbl_general_Die_2] DEFAULT (0),
[GuildStatus] [tinyint] NOT NULL CONSTRAINT [DF_tbl_general_GuildStatus] DEFAULT (0),
CONSTRAINT [PK_tbl_general] PRIMARY KEY CLUSTERED
(
[Serial] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

все вроде с тебя спасибок

Segas22 · 12.05.2010, 23:32

edaks9 если пвп сервак то проще в ини поставить 1 и сделать джейды )
в них то можно засунуть все что угодно

edaks9 · 15.05.2010, 00:02

Ну так я в первом посте и написал про джейд... Может мне надо было еще и прожевать 100500 раз прожеваное?? Мне кажется что этого достаточно...

TheDroot · 22.05.2010, 17:46

а у меня вот в 2.2.3 при изменении рейтов в инишнике ничего не меняется.

в чем проблема?