Db Sql Format

[Stik]

Am sooooo close now...
I did all the above, i can make acount (useing the account maker),i can log in and create a character,BUT when i try to join game i get
"ERROR! Account(blahblah) password or level missmatch" in the world server window, any ideas

ps. What client works with this server, i'm useing HBusa 7.2 client

[jmh]

errm you should be using a 3.51 client hexxed to your ip..

[Stik]

Ok ty now it works.. Just the fine tuneing to do now

[RageIlluminati]

LIKE WTF?

tell me.. what kind of HGserver is that "HGServer-v3.61-(521).exe"???

is that Original HGserver from some china server or what?

it uses old format npc.cfg file... majestic item upgrade don't work :blink:

It seems this HG stinks...

[nef]

plz anyone help me, i am trying to put this stuff on 4 a long time, i did everything that said in the posts and nothing works, i will paste here my mainlogin.sql and ws1.sql, see if anyone find any error
MainLogin.sql
CREATE DATABASE [mainlogin] ON PRIMARY
(
NAME = N'mainlogin',
FILENAME = N'D:\MSSQL\data\mainlogin.mdf',
size= 10,
FILEGROWTH = 10%
)
GO

use mainlogin
GO

ALTER DATABASE [mainlogin] ADD FILEGROUP [Second]
go

ALTER DATABASE [mainlogin] ADD FILE
(
NAME = N'mainlogin_idx',
FILENAME = N'D:\MSSQL\data\mainlogin_idx.mdf',
size= 10,
FILEGROWTH = 10%
) TO FILEGROUP [Second]
go


CREATE TABLE ACCOUNT_T -- Account info. Table
(
cAccountID NCHAR(10) NOT NULL, -- Account ID 1
cPasswd NCHAR(10), -- Password 2
iAccountID INT NOT NULL, -- Account Unique Number 3
cLoginIpAddress NCHAR(20), -- Login Ip Address 8 -> 4
IsGMAccount BIT, -- GM Account ID 9 -> 5
cKEYCODE NCHAR ,
CreateDate SMALLDATETIME , -- Create Date 4 -> 6
LoginDate SMALLDATETIME , -- LogIn Date 7
LogoutDate SMALLDATETIME , -- LogOut Date 8
BlockDate SMALLDATETIME , -- Account Block Date 9

-- personal information
-- cRealName NCHAR(10), -- Real Name 10
cRealName NCHAR(30), -- Real Name 10
cSSN NCHAR(20), -- Person Number 11
-- cEmail NCHAR(50), -- E-MAIL 12
cEmail NCHAR(60), -- E-MAIL 12 -- for japan
cCharRecord NCHAR(100), -- Character Document 13
cQuiz NCHAR(45), -- QUIZ 14
cAnswer NCHAR(20), -- ANSWER 15
ValidDate SMALLDATETIME , -- Account Vaild Date 16
iValidTime INT, -- Account Vaild Time 17



CONSTRAINT PK_ACCOUNT_T PRIMARY KEY (cAccountID),
CONSTRAINT UniqlACCOUNT_ID UNIQUE (iAccountID)

)
GO
CREATE TABLE CODE_T
(
cKEYCODE NCHAR
)
go
CREATE TABLE WS1_T -- First World Server Characters Info Table
(
iAccountID INT NOT NULL, -- Account ID
cCharName NCHAR(10), -- Character Name
CONSTRAINT FK_WS1_T FOREIGN KEY (
iAccountID
) REFERENCES [ACCOUNT_T] (
iAccountID
) ON DELETE CASCADE ON UPDATE CASCADE

)

GO

CREATE TABLE WS2_T -- Second World Server Characters Info Table
(
iAccountID INT NOT NULL, -- Account Unique Number
cCharName NCHAR(10), -- Character Name

CONSTRAINT FK_WS2_T FOREIGN KEY (
iAccountID
) REFERENCES [ACCOUNT_T] (
iAccountID
) ON DELETE CASCADE ON UPDATE CASCADE

)
go

CREATE NONCLUSTERED INDEX WS1_IDX
ON WS1_T(iAccountID)
WITH FILLFACTOR = 80,STATISTICS_NORECOMPUTE on SECOND
go

-----------------------------
-- stored procedure
-----------------------------

-- save procedure
CREATE PROC sp_SetHeldenianWinner
@Winner CHAR(7),
@StartDate DATETIME,
@EndDate DATETIME,
@Type INT
AS
IF( @Winner = 'aresden' )
BEGIN
EXEC sp_SetHeldenianWinnerAresden
EXEC sp_SetHeldenianLoserElvine
END
ELSE IF ( @Winner = 'elvine' )
BEGIN
EXEC sp_SetHeldenianWinnerElvine
EXEC sp_SetHeldenianLoserAresden
ENd
ELSE IF ( @Winner = 'draw' )
BEGIN
EXEC sp_SetHeldenianDraw
END

INSERT INTO HeldenianReportT VALUES ( @StartDate, @EndDate, @Winner, @Type );
GO

CREATE PROC sp_SetHeldenianWinnerAresden
AS
UPDATE HeldenianResultT SET lastWar='win', lastResultCount=0 WHERE nation='aresden' and lastWar='lose'
UPDATE HeldenianResultT SET lastResultCount=lastResultCount+1, totalWin=totalWin+1 WHERE nation='aresden'
GO

CREATE PROC sp_SetHeldenianWinnerElvine
AS
UPDATE HeldenianResultT SET lastWar='win', lastResultCount=0 WHERE nation='elvine' and lastWar='lose'
UPDATE HeldenianResultT SET lastResultCount=lastResultCount+1, totalWin=totalWin+1 WHERE nation='elvine'
GO


CREATE PROC sp_SetHeldenianLoserAresden
AS
UPDATE HeldenianResultT SET lastWar='lose', lastResultCount=0 WHERE nation='aresden' and lastWar='win'
UPDATE HeldenianResultT SET lastResultCount=lastResultCount+1 WHERE nation='aresden'
GO

CREATE PROC sp_SetHeldenianLoserElvine
AS
UPDATE HeldenianResultT SET lastWar='lose', lastResultCount=0 WHERE nation='elvine' and lastWar='win'
UPDATE HeldenianResultT SET lastResultCount=lastResultCount+1 WHERE nation='elvine'
GO

CREATE PROC sp_SetHeldenianDraw
AS
UPDATE HeldenianResultT SET totalWin=totalWin+1 WHERE nation='draw'
GO

-- retrive procedure
CREATE PROC sp_GetHeldenianLastLoser
AS
SELECT * FROM HeldenianResultT WHERE lastWar='lose'
GO

CREATE PROC sp_GetHeldenianLastWinner
AS
SELECT * FROM HeldenianResultT WHERE lastWar='win'
GO





-----------------------------
-- stored procedure
-----------------------------

-- save procedure
CREATE PROC sp_SetCrusadeWinner
@Winner CHAR(7),
@StartDate DATETIME,
@EndDate DATETIME
AS
IF( @Winner = 'aresden' )
BEGIN
EXEC sp_SetCrusadeWinnerAresden
EXEC sp_SetCrusadeLoserElvine
END
ELSE IF ( @Winner = 'elvine' )
BEGIN
EXEC sp_SetCrusadeWinnerElvine
EXEC sp_SetCrusadeLoserAresden
ENd
ELSE IF ( @Winner = 'draw' )
BEGIN
EXEC sp_SetCrusadeDraw
END

INSERT INTO CrusadeReportT VALUES ( @StartDate, @EndDate, @Winner );
GO

CREATE PROC sp_SetCrusadeWinnerAresden
AS
UPDATE CrusadeResultT SET lastWar='win', lastResultCount=0 WHERE nation='aresden' and lastWar='lose'
UPDATE CrusadeResultT SET lastResultCount=lastResultCount+1, totalWin=totalWin+1 WHERE nation='aresden'
GO

CREATE PROC sp_SetCrusadeWinnerElvine
AS
UPDATE CrusadeResultT SET lastWar='win', lastResultCount=0 WHERE nation='elvine' and lastWar='lose'
UPDATE CrusadeResultT SET lastResultCount=lastResultCount+1, totalWin=totalWin+1 WHERE nation='elvine'
GO


CREATE PROC sp_SetCrusadeLoserAresden
AS
UPDATE CrusadeResultT SET lastWar='lose', lastResultCount=0 WHERE nation='aresden' and lastWar='win'
UPDATE CrusadeResultT SET lastResultCount=lastResultCount+1 WHERE nation='aresden'
GO

CREATE PROC sp_SetCrusadeLoserElvine
AS
UPDATE CrusadeResultT SET lastWar='lose', lastResultCount=0 WHERE nation='elvine' and lastWar='win'
UPDATE CrusadeResultT SET lastResultCount=lastResultCount+1 WHERE nation='elvine'
GO

CREATE PROC sp_SetCrusadeDraw
AS
UPDATE CrusadeResultT SET totalWin=totalWin+1 WHERE nation='draw'
GO

-- retrive procedure
CREATE PROC sp_GetCrusadeLastLoser
AS
SELECT * FROM CrusadeResultT WHERE lastWar='lose'
GO

CREATE PROC sp_GetCrusadeLastWinner
AS
SELECT * FROM CrusadeResultT WHERE lastWar='win'
GO


--------------------------------------------------------------
-- Crusade Information DB
--------------------------------------------------------------

-- Àü¸éÀüÀÌ Á¾·á µÉ¶§ ¸¶´Ù ±â·ÏÇÑ´Ù.
-- index¸¦ °ÉÁö ¾Ê°í °è¼Ó ´©ÀûµÈ´Ù.
CREATE TABLE CrusadeReportT (
startDate DATETIME NOT NULL,
endDate DATETIME NOT NULL,
winner CHAR(7) NOT NULL
CHECK (Winner IN ('aresden', 'elvine', 'draw'))
);

-- Àü¸éÀü¿¡ ´ëÇÑ ±â·ÏÀ» ´ã´Â´Ù.
-- aresden, elvine, draw ¿¡ ´ëÇÑ °¢°¢ ÇϳªÀÇ tuple ¸¸À» °¡Áø´Ù.
-- index ÇÊ¿ä ¾øÀ½.
CREATE TABLE CrusadeResultT (
nation CHAR(7) NOT NULL UNIQUE
CHECK (nation IN ('aresden', 'elvine', 'draw')),
totalWin INT DEFAULT 0,
lastWar CHAR(4) NOT NULL
CHECK (lastWar IN ('lose', 'win', 'draw')),
lastResultCount INT DEFAULT 0
);

INSERT INTO CrusadeResultT VALUES ('aresden', 0, 'lose', 0);
INSERT INTO CrusadeResultT VALUES ('elvine' , 0, 'lose', 0);
INSERT INTO CrusadeResultT VALUES ('draw' , 0, 'draw', 0);

CREATE TABLE HeldenianReportT (
startDate DATETIME NOT NULL,
endDate DATETIME NOT NULL,
winner CHAR(7) NOT NULL
CHECK (Winner IN ('aresden', 'elvine', 'draw')),
type INT NOT NULL
);

-- HeldenianResult table
CREATE TABLE HeldenianResultT (
nation CHAR(7) NOT NULL UNIQUE
CHECK (nation IN ('aresden', 'elvine', 'draw')),
totalWin INT DEFAULT 0,
lastWar CHAR(4) NOT NULL
CHECK (lastWar IN ('lose', 'win', 'draw')),
lastResultCount INT DEFAULT 0
);

INSERT INTO HeldenianResultT VALUES ('aresden', 0, 'lose', 0);
INSERT INTO HeldenianResultT VALUES ('elvine' , 0, 'lose', 0);
INSERT INTO HeldenianResultT VALUES ('draw' , 0, 'draw', 0);


WS1.sql

-----------------------------------------------------------------------------
-- SiemenTech co., LDT. WorldServer.sql
-- 2002.07.4 by SungHun Mun
-----------------------------------------------------------------------------

CREATE DATABASE [ws1] ON PRIMARY
(
NAME = N'ws1',
FILENAME = N'D\MSSQL\data\ws1.mdf',
size= 100,
FILEGROWTH = 10%
)
GO

ALTER DATABASE [ws1] ADD FILEGROUP [Second]
go

ALTER DATABASE [ws1] ADD FILE
(
NAME = N'ws1_idx',
FILENAME = N'D:\MSSQL\data\ws1_idx.mdf',
size= 10,
FILEGROWTH = 10%
) TO FILEGROUP [Second]
go

use ws1
go
CREATE TABLE CHARACTER_T -- Character Info. Table
(
-- CHARACTER ID
cCharName NCHAR(10) NOT NULL, -- Character Name
cAccountID NCHAR(10) NOT NULL, -- AccountID
CharID INT NOT NULL, -- Character ID
sID1 SMALLINT, -- ID Number 1
sID2 SMALLINT, -- ID Number 2
sID3 SMALLINT, -- ID Number 3


-- CHARACTER Ability
sLevel SMALLINT DEFAULT (1), -- Level
sStr SMALLINT, -- Strength of character
sVit SMALLINT, -- Vitality of character
sDex SMALLINT, -- Dexterity of character
sInt SMALLINT, -- Intelligent of character
sMag SMALLINT, -- Magic of character
sChar SMALLINT, -- Charisma of character
iExp INT DEFAULT (0), -- Experience of character
sUpStr SMALLINT DEFAULT (0), -- STR Up Point for next level up
sUpVit SMALLINT DEFAULT (0), -- Vit Up Point for next level up
sUpDex SMALLINT DEFAULT (0), -- Dex Up Point for next level up
sUpInt SMALLINT DEFAULT (0), -- Int Up Point for next level up
sUpMag SMALLINT DEFAULT (0), -- Mag Up Point for next level up
sUpChar SMALLINT DEFAULT (0), -- Char Up Point for next level up

-- CHARACTER Feature
bGender BIT, -- Gender(Character gender, male or female)
sSkin SMALLINT, -- Skin Color(Skin color--> black, white, yellow)
sHairStyle SMALLINT, -- Hair Style
sHairColor SMALLINT, -- Hair Color
sUnderWear SMALLINT, -- Underwear(underwear color)
iApprColor INT, -- Apperance Color
sAppr1 SMALLINT, -- Appearance Setting 1
sAppr2 SMALLINT, -- Appearance Setting 2
sAppr3 SMALLINT, -- Appearance Setting 3
sAppr4 SMALLINT, -- Appearance Setting 4

-- CHARACTER Location
cNation NCHAR(10) NOT NULL, -- Nation(Character's nation like aresden,elvine or NONE)
cMapLoc NCHAR(10) NOT NULL, -- Map Location(Current Character's position)
sLocX SMALLINT DEFAULT (-1), -- X Coordinates(Current character's x position in the map)
sLocY SMALLINT DEFAULT (-1), -- Y Coordinates(Current character's y position in the map)

-- CHARACTER Info.
cProfile NCHAR(70) NOT NULL, -- Profile(Character profile)
sAdminLevel SMALLINT, -- Administrator Level(GM>1, normal user=0)
iContribution INT, -- Contribution(Contribution point rises when character complete quest)
iLeftSpecTime INT, -- Remain Special Ability Time(If character use special ability, he can't do it within 20minutes)
cLockMapName NCHAR(10) NOT NULL, -- Locked Map Name(If character is locked at some map for some time, this means the locked map name)
iLockMapTime INT, -- Locked Map Time(And this is locked time)
FileSaveDate SMALLDATETIME , -- File Saved Date(last saved data date)
BlockDate SMALLDATETIME , -- Character Block Date(The GM can block character, and the character can't login until this date)

-- CHARACTER Guild Info.
cGuildName NCHAR(20) NOT NULL, -- Guild Name
iGuildID INT, -- Guild ID
sGuildRank SMALLINT, -- Guild Rank
sFightNum SMALLINT, -- Reserved FightZone ID(The fightzone id that the player has reserved)
sFightDate SMALLINT, -- Reserved FightZone Date(The reserved date that the player can use)
sFightTicket SMALLINT, -- Remain Reserved FightZone Ticket(Left counts of fightzone ticket)

-- CHARACTER Quest Info.
sQuestNum SMALLINT, -- Quest Number
sQuestID SMALLINT, -- Quest ID
sQuestCount SMALLINT, -- Quest Count(If the quest is slaying 10 slimes, this count means left count for player to complete the quest.)
sQuestRewType SMALLINT, -- Quest Reward Type(Kind of reward type, it could be experince or gold)
sQuestRewAmount SMALLINT, -- Quest Reward Amount(The amount of reward, ex.gold 1000)
bQuestCompleted BIT, -- Quest Completed(Whether player completed quest or not)

-- CHARCTER Event Info.
iEventID INT, -- Event ID

-- CHRACTER Crusade Info.
iWarCon INT, -- Charcter Crusade Contribution "character-war-contribution" 55
iCruJob INT, -- Crusade Job "crusade-job" 56
iCruID INT, -- Crusade ID "crusade-GUID" 57
iCruConstructPoint INT, -- Crusade Construct Point "construct-point" 58

-- CHARACTER Status
iPopular INT, -- Popularity(A player can evaluate other player. This is used for character rightness)
iHP INT, -- Hit Point(Current Hit point)
iMP INT, -- Magic Point(Current Mana point)
iSP INT, -- Stamina Point(Curren stamina point)
iEK INT, -- Enemy Kill Count(If a player capture enemy, this count rises)
iPK INT, -- Player Kill Count(If a player kill innocent friends, this count rises)
iRewardGold INT, -- Reward Gold(You can take the prize gold at city hall when you got captured enemy or completed quest.)
sDownSkillIDX SMALLINT, -- Down Skill Index(A character skill can't exceed 700. So if user want to raise other skill, he should down the other skill.)
sHunger SMALLINT, -- Hunger Status(A character is going to be hungry like the real human being. This is the parameter of hunger status. From 0 to 100)
sLeftSAC SMALLINT, -- Remain Super Attack Count(remained counts that character can use super attack)
iLeftShutupTime INT, -- Remain Shutup Time(If the GM gave a penalty to bad user, he can't chat for this time)
iLeftPopTime INT, -- Remain Popular Time(If a character evaluate other character, he can't do it again for some time to protect abuser)
iLeftForceRecallTime INT, -- Remain Force Recall Time(Time left when a character visits enemy's nation)
iLeftFirmStaminarTime INT, -- Remain Firm Staminar Time(Time left when a character eats super green potion)
iLeftDeadpenaltyTime INT, -- Remain Dead Penalty Time(To protect abuser, if a character dies, he can't go outside from his town for this time)

-- CHARACTER Magic Mastery Info.
cMagicMastery NCHAR(100) NOT NULL, -- Magic Mastery

-- CHARACTER Party Info.
iPartyID INT , -- Party ID
-- iGizoneItemUpgradeLeft INT -- highest Level Player Item Upgrade Left

cKEYCODE NCHAR

CONSTRAINT PK_CHARACTER_T PRIMARY KEY (cCharName),
CONSTRAINT CHARID UNIQUE (CharID)
)
GO
CREATE TABLE CODE_T
(
cKEYCODE NCHAR
)
go
CREATE TABLE CODE_T
(
cKEYCODE nchar
)
GO

CREATE TABLE SKILL_T -- Skill list Table take lessons
(
CharID INT NOT NULL, -- Character Name
sSkillID SMALLINT, -- SKill ID(Skill Name)
sSkillMastery SMALLINT, -- Skill Mastery(Skill Level)
iSkillSSN INT, -- Skill SSN(Left counts to skill up)

)
GO

CREATE NONCLUSTERED INDEX SKILL_IDX
ON SKILL_T(CharID)
WITH FILLFACTOR = 80,PAD_INDEX,STATISTICS_NORECOMPUTE on SECOND
go

CREATE TABLE ITEM_T -- Items list Table
(
CharID INT NOT NULL, -- Character Name(Character name who has these items.)
sItemID SMALLINT , -- Item Name
iCount INT DEFAULT (1), -- Item Count(number of item)
sItemType SMALLINT DEFAULT (0), -- Item Type
sID1 SMALLINT DEFAULT (0), -- Item Unique ID 1
sID2 SMALLINT DEFAULT (0), -- Item Unique ID 2
sID3 SMALLINT DEFAULT (0), -- Item Unique ID 3
sColor SMALLINT DEFAULT (0), -- Item Color( the color of the item)
sEffect1 SMALLINT DEFAULT (0), -- Item Effect Value 1
sEffect2 SMALLINT DEFAULT (0), -- Item Effect Value 2
sEffect3 SMALLINT DEFAULT (0), -- Item Effect Value 3
iLifeSpan INT DEFAULT (0), -- Item LifeSpan( Left lifespan of the item)
iAttribute INT DEFAULT (0), -- Item Attribute
bItemEquip BIT DEFAULT (0), -- Item Equip Status(this means the item is Equiped or not)
sItemPosX SMALLINT DEFAULT (40), -- Item X Coordinates(X position of item in the inventory window)
sItemPosY SMALLINT DEFAULT (30), -- Item Y Coordinates(Y position of item in the inventory window)
)
go

CREATE NONCLUSTERED INDEX ITEM_IDX
ON ITEM_T(CharID)
WITH FILLFACTOR = 70,PAD_INDEX,STATISTICS_NORECOMPUTE on SECOND
go


CREATE TABLE BANKITEM_T -- Items list table stored in warehouse
(
CharID INT NOT NULL, -- Character Name(Character name who has this item)
sItemID SMALLINT , -- Item Name(Item name)
iCount INT, -- Item Count(Number of item)
sItemType SMALLINT, -- Item Type
sID1 SMALLINT, -- Item Unique ID 1
sID2 SMALLINT, -- Item Unique ID 2
sID3 SMALLINT, -- Item Unique ID 3
sColor SMALLINT, -- Item Color( the color of the item)
sEffect1 SMALLINT, -- Item Effect Value 1
sEffect2 SMALLINT, -- Item Effect Value 2
sEffect3 SMALLINT, -- Item Effect Value 3
iLifeSpan INT, -- Item LifeSpan( left lifespan of the item)
iAttribute INT, -- Item Attribute

)
go

CREATE NONCLUSTERED INDEX BANKITEM_IDX
ON BANKITEM_T(CharID)
WITH FILLFACTOR = 80,PAD_INDEX,STATISTICS_NORECOMPUTE on SECOND
go

CREATE TABLE GUILD_T --
(
cGuildName NCHAR(20) NOT NULL, -- Guild Name
iGuildID INT, -- Guild ID
cMasterName NCHAR(10),
cLocation NCHAR(10),
sMemberNO SMALLINT,
CreateDate SMALLDATETIME
)
go
CREATE NONCLUSTERED INDEX GUILD_IDX
ON GUILD_T(cGuildName)
WITH FILLFACTOR = 80,PAD_INDEX,STATISTICS_NORECOMPUTE on SECOND
go

CREATE TABLE GUILDMEMBER_T --
(
cGuildName NCHAR(20) NOT NULL, -- Guild Name
cMemberName NCHAR(10),
JoinDate SMALLDATETIME
)

CREATE NONCLUSTERED INDEX GUILDMEMBER_IDX
ON GUILDMEMBER_T(cGuildName)
WITH FILLFACTOR = 80,PAD_INDEX,STATISTICS_NORECOMPUTE on SECOND
go

-----------------------------
-- stored procedure
-----------------------------

-- save procedure
CREATE PROC sp_SetHeldenianWinner
@Winner CHAR(7),
@StartDate DATETIME,
@EndDate DATETIME,
@Type INT
AS
IF( @Winner = 'aresden' )
BEGIN
EXEC sp_SetHeldenianWinnerAresden
EXEC sp_SetHeldenianLoserElvine
END
ELSE IF ( @Winner = 'elvine' )
BEGIN
EXEC sp_SetHeldenianWinnerElvine
EXEC sp_SetHeldenianLoserAresden
ENd
ELSE IF ( @Winner = 'draw' )
BEGIN
EXEC sp_SetHeldenianDraw
END

INSERT INTO HeldenianReportT VALUES ( @StartDate, @EndDate, @Winner, @Type );
GO

CREATE PROC sp_SetHeldenianWinnerAresden
AS
UPDATE HeldenianResultT SET lastWar='win', lastResultCount=0 WHERE nation='aresden' and lastWar='lose'
UPDATE HeldenianResultT SET lastResultCount=lastResultCount+1, totalWin=totalWin+1 WHERE nation='aresden'
GO

CREATE PROC sp_SetHeldenianWinnerElvine
AS
UPDATE HeldenianResultT SET lastWar='win', lastResultCount=0 WHERE nation='elvine' and lastWar='lose'
UPDATE HeldenianResultT SET lastResultCount=lastResultCount+1, totalWin=totalWin+1 WHERE nation='elvine'
GO


CREATE PROC sp_SetHeldenianLoserAresden
AS
UPDATE HeldenianResultT SET lastWar='lose', lastResultCount=0 WHERE nation='aresden' and lastWar='win'
UPDATE HeldenianResultT SET lastResultCount=lastResultCount+1 WHERE nation='aresden'
GO

CREATE PROC sp_SetHeldenianLoserElvine
AS
UPDATE HeldenianResultT SET lastWar='lose', lastResultCount=0 WHERE nation='elvine' and lastWar='win'
UPDATE HeldenianResultT SET lastResultCount=lastResultCount+1 WHERE nation='elvine'
GO

CREATE PROC sp_SetHeldenianDraw
AS
UPDATE HeldenianResultT SET totalWin=totalWin+1 WHERE nation='draw'
GO

-- retrive procedure
CREATE PROC sp_GetHeldenianLastLoser
AS
SELECT * FROM HeldenianResultT WHERE lastWar='lose'
GO

CREATE PROC sp_GetHeldenianLastWinner
AS
SELECT * FROM HeldenianResultT WHERE lastWar='win'
GO





-----------------------------
-- stored procedure
-----------------------------

-- save procedure
CREATE PROC sp_SetCrusadeWinner
@Winner CHAR(7),
@StartDate DATETIME,
@EndDate DATETIME
AS
IF( @Winner = 'aresden' )
BEGIN
EXEC sp_SetCrusadeWinnerAresden
EXEC sp_SetCrusadeLoserElvine
END
ELSE IF ( @Winner = 'elvine' )
BEGIN
EXEC sp_SetCrusadeWinnerElvine
EXEC sp_SetCrusadeLoserAresden
ENd
ELSE IF ( @Winner = 'draw' )
BEGIN
EXEC sp_SetCrusadeDraw
END

INSERT INTO CrusadeReportT VALUES ( @StartDate, @EndDate, @Winner );
GO

CREATE PROC sp_SetCrusadeWinnerAresden
AS
UPDATE CrusadeResultT SET lastWar='win', lastResultCount=0 WHERE nation='aresden' and lastWar='lose'
UPDATE CrusadeResultT SET lastResultCount=lastResultCount+1, totalWin=totalWin+1 WHERE nation='aresden'
GO

CREATE PROC sp_SetCrusadeWinnerElvine
AS
UPDATE CrusadeResultT SET lastWar='win', lastResultCount=0 WHERE nation='elvine' and lastWar='lose'
UPDATE CrusadeResultT SET lastResultCount=lastResultCount+1, totalWin=totalWin+1 WHERE nation='elvine'
GO


CREATE PROC sp_SetCrusadeLoserAresden
AS
UPDATE CrusadeResultT SET lastWar='lose', lastResultCount=0 WHERE nation='aresden' and lastWar='win'
UPDATE CrusadeResultT SET lastResultCount=lastResultCount+1 WHERE nation='aresden'
GO

CREATE PROC sp_SetCrusadeLoserElvine
AS
UPDATE CrusadeResultT SET lastWar='lose', lastResultCount=0 WHERE nation='elvine' and lastWar='win'
UPDATE CrusadeResultT SET lastResultCount=lastResultCount+1 WHERE nation='elvine'
GO

CREATE PROC sp_SetCrusadeDraw
AS
UPDATE CrusadeResultT SET totalWin=totalWin+1 WHERE nation='draw'
GO

-- retrive procedure
CREATE PROC sp_GetCrusadeLastLoser
AS
SELECT * FROM CrusadeResultT WHERE lastWar='lose'
GO

CREATE PROC sp_GetCrusadeLastWinner
AS
SELECT * FROM CrusadeResultT WHERE lastWar='win'
GO


--------------------------------------------------------------
-- Crusade Information DB
--------------------------------------------------------------

-- Àü¸éÀüÀÌ Á¾·á µÉ¶§ ¸¶´Ù ±â·ÏÇÑ´Ù.
-- index¸¦ °ÉÁö ¾Ê°í °è¼Ó ´©ÀûµÈ´Ù.
CREATE TABLE CrusadeReportT (
startDate DATETIME NOT NULL,
endDate DATETIME NOT NULL,
winner CHAR(7) NOT NULL
CHECK (Winner IN ('aresden', 'elvine', 'draw'))
);

-- Àü¸éÀü¿¡ ´ëÇÑ ±â·ÏÀ» ´ã´Â´Ù.
-- aresden, elvine, draw ¿¡ ´ëÇÑ °¢°¢ ÇϳªÀÇ tuple ¸¸À» °¡Áø´Ù.
-- index ÇÊ¿ä ¾øÀ½.
CREATE TABLE CrusadeResultT (
nation CHAR(7) NOT NULL UNIQUE
CHECK (nation IN ('aresden', 'elvine', 'draw')),
totalWin INT DEFAULT 0,
lastWar CHAR(4) NOT NULL
CHECK (lastWar IN ('lose', 'win', 'draw')),
lastResultCount INT DEFAULT 0
);

INSERT INTO CrusadeResultT VALUES ('aresden', 0, 'lose', 0);
INSERT INTO CrusadeResultT VALUES ('elvine' , 0, 'lose', 0);
INSERT INTO CrusadeResultT VALUES ('draw' , 0, 'draw', 0);

CREATE TABLE HeldenianReportT (
startDate DATETIME NOT NULL,
endDate DATETIME NOT NULL,
winner CHAR(7) NOT NULL
CHECK (Winner IN ('aresden', 'elvine', 'draw')),
type INT NOT NULL
);

-- HeldenianResult table
CREATE TABLE HeldenianResultT (
nation CHAR(7) NOT NULL UNIQUE
CHECK (nation IN ('aresden', 'elvine', 'draw')),
totalWin INT DEFAULT 0,
lastWar CHAR(4) NOT NULL
CHECK (lastWar IN ('lose', 'win', 'draw')),
lastResultCount INT DEFAULT 0
);

INSERT INTO HeldenianResultT VALUES ('aresden', 0, 'lose', 0);
INSERT INTO HeldenianResultT VALUES ('elvine' , 0, 'lose', 0);
INSERT INTO HeldenianResultT VALUES ('draw' , 0, 'draw', 0);

[Sparda]

Please don't ever post such a long post like that again lol. I'll help you nef in return u don't do that again

Right have you run the sql code into MS SQL?
If you have follow this:

open 'mainlogin' database, open 'account_t' in design mode (right click > design), add a new field called iShopID, datatype NCHAR. That should fix your account_t table.

open 'ws1' database, open 'character_t' in design mode, add a new field called iGizoneItemUpgradeLeft, datatype INT. That should fix your character_t table hopefully. That way you can login and create characters using the client.

Upgrade does work. I've upgrade my dark knight flameberge into dark knight temple +15

btw, has someone been able to use /enableadmincreateitem 147258 to create an item yet? there seems to be no /createitem command in the hgserver and all i've been doing is entering items manually and i hate doing that process....

[nef]

tks sparda, sry for the loooooonnnggg post, btw, still didnt work i dont know more what to do ¬¬ when i use the old client to create the account it saids, account create susfully, but when i go to the db to check it, the db is empty

[RageIlluminati]

Upgrade does work. I've upgrade my dark knight flameberge into dark knight temple +15

WTF? what HGserver you use? the same as I? this GoldenBoy GServer-v3.61-(521).exe

can you send your item and NPC *.cfg files?

I use this HGServer-v3.61-(521).exe HGserver.. and when I log in.. I see all these old Bugs.. that I saw when we started to convert our 2.19 server to new files..

all these blizzard don't freeze bugs... hammerstrip bugs... inhibition and cancel and MIM bugs...

this armor DK sword upgrading bugs... for me it seems to be the old 2.24b source HG server... am I right?

[Sparda]

Ah don't use the old client to create accounts. It won't work. Instead go into the database and create it manually, you'll atleast cAccountID, cPasswd and iAccountID for your account to work.

Rage i'm sorry but i really don't understand what you're trying to say. However about the item upgrade i've tested that both the v3.51 and v3.61 512 can upgrade items. It's just that your DK items must have your character ID.

Also if you want to be able to use the /enableadmincreateitem and /enableadmincommand u must use v3.51 server since they have removed those commands from v3.61.

[nef]

aahhh finally dude, tks a lot, finally it works \o\

[Stik]

What info goes into world.cfg my guess is its things like max lvl, drop rates etc but i could be totally wrong
Allso whats the format for npnitem.cfg atm my slimes only drop pots and gold.

When i try to log in to game on a character, i have to "alt esc" back to windows,then back to game before it will start. (just some useless info for others haveing problems connecting)

[Stik]

Ah don't use the old client to create accounts. It won't work. Instead go into the database and create it manually, you'll atleast cAccountID, cPasswd and iAccountID for your account to work.

Rage i'm sorry but i really don't understand what you're trying to say. However about the item upgrade i've tested that both the v3.51 and v3.61 512 can upgrade items. It's just that your DK items must have your character ID.

Also if you want to be able to use the /enableadmincreateitem and /enableadmincommand u must use v3.51 server since they have removed those commands from v3.61.

This accountcreater works ok,tried and tested <a href='http://helbreath.pri.ee/AccMaker.rar' target='_blank'>http://helbreath.pri.ee/AccMaker.rar</a>

[RageIlluminati]

Rage i'm sorry but i really don't understand what you're trying to say. However about the item upgrade i've tested that both the v3.51 and v3.61 512 can upgrade items. It's just that your DK items must have your character ID.

Hei... confirm for me.. In this HGserver you use... this "3.61".. does the blizzard freezes you? does hour BattleHammer strips armor?

And I had 4 majestic points.. but I couldn't upgrade my wand? what do you mean my DK wand must have my character ID? they should get binded after first upgrade... as far as I know...

[Sparda]

Freeze works fine and stripping works fine as well. As far as i'm concerned you don't know about the item ID system do u?

[drunk]

I was able to make an account and create a character but when I try to log on it it just sits at connected waiting for response.