Questions & Answers

**TNT_Xplosiv** · 27-02-07

I may be an idiot, but I can't seem to get the black lobby fix to work.

before

Code:

USE [GunzDB]
GO
/****** Object:  StoredProcedure [dbo].[spInsertChar]    Script Date: 02/26/2007 19:16:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spInsertChar]
    @nAID INT,
    @nCharIndex INT,
    @szName nvarchar(32),
    @nSex INT,
    @nHair INT,
    @nFace INT,
    @nCostume INT
AS
BEGIN
    SET NOCOUNT ON;
    
    DECLARE @cnt INT
    SELECT @cnt=COUNT(*)
    FROM Character
    WHERE AID = @nAID
    
    DECLARE @cid INT
    SELECT @cid=COUNT(*)
    FROM Character

    INSERT INTO Character
    VALUES(@nAID,@szName,@cnt,50,@nSex,@nCostume,@nFace,@nHair,NULL,0,100000,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
END

after

Code:

setANSI_NULLSON
setQUOTED_IDENTIFIERON
GO
ALTERPROCEDURE [dbo].[spInsertChar]
@nAID INT,
@nCharIndex INT,
@szName nvarchar(32),
@nSex INT,
@nHair INT,
@nFace INT,
@nCostume INT
AS
BEGIN
SETNOCOUNTON;
 DECLARE @cnt INT
SELECT @cnt=COUNT(*)
FROMCharacter
WHERE AID = @nAID DECLARE @cid INT
SELECT @cid=COUNT(*)
FROMCharacter
 INSERTINTOCharacter
VALUES(@nAID,@szName,@cnt,50,@nSex,@nCostume,@nFace,@nHair,NULL,0,100,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null)
END

and I get this error after hitting Execute/!

Originally Posted by Error

Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'setANSI_NULLSON'.
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '.'.
Msg 102, Level 15, State 1, Line 11
Incorrect syntax near 'SETNOCOUNTON'.
Msg 102, Level 15, State 1, Line 14
Incorrect syntax near 'FROMCharacter'.
Msg 102, Level 15, State 1, Line 17
Incorrect syntax near 'FROMCharacter'.

Am I doing something wrong or is it just being gay?

I'm running MSSQL 2005 SP2, and I copy pasta'd Maxtrax's fix right over mine.

**RepublicOfAstra** · 27-02-07

Code:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<RepublicOfAstra>
-- Description:	<spInsertChar Procedure>
-- =============================================
ALTER PROCEDURE [dbo].[spInsertChar]
(
@AID tinyint,
@Charnum tinyint,
@Name varchar(50),
@Sex tinyint,
@Hair tinyint,
@Face tinyint,
@Costume tinyint
)	
AS



INSERT INTO Character(AID, CharNum, Name, [Level], Sex, Hair, Face, Costume, XP, BP, HP, AP, FR, CR, ER, WR, KillCount, DeathCount, PlayTime, CIID, FriendCID, CLID)

VALUES (@AID, @CharNum, @Name,99 ,@Sex, @Hair, @Face, @costume, 999999,9999999999999999,
0,100,1,1,1,1, NULL, NULL, NULL, NULL, NULL, 0);

Here's my spInsertChar. Just need to tweak the BP, XP, etc.

**TNT_Xplosiv** · 27-02-07

Originally Posted by RepublicOfAstra

Code:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        <RepublicOfAstra>
-- Description:    <spInsertChar Procedure>
-- =============================================
ALTER PROCEDURE [dbo].[spInsertChar]
(
@AID tinyint,
@Charnum tinyint,
@Name varchar(50),
@Sex tinyint,
@Hair tinyint,
@Face tinyint,
@Costume tinyint
)    
AS



INSERT INTO Character(AID, CharNum, Name, [Level], Sex, Hair, Face, Costume, XP, BP, HP, AP, FR, CR, ER, WR, KillCount, DeathCount, PlayTime, CIID, FriendCID, CLID)

VALUES (@AID, @CharNum, @Name,99 ,@Sex, @Hair, @Face, @costume, 999999,9999999999999999,
0,100,1,1,1,1, NULL, NULL, NULL, NULL, NULL, 0);

Here's my spInsertChar. Just need to tweak the BP, XP, etc.

Alright, it works, but I have to take out CIID and FriendCID (and their respective Values). It gives me errors on those. Anything I need to add to a different file?

**RepublicOfAstra** · 27-02-07

Originally Posted by TNT_Xplosiv

Alright, it works, but I have to take out CIID and FriendCID (and their respective Values). It gives me errors on those. Anything I need to add to a different file?

Honestly, I'm not sure. My DB is a lot different from the ones posted at Ragezone, since my team made our DB long before anyone else did. But I think you just need to use my spInsertChar and it should be good. I guess the values that were giving you errors were just for columns I have that the others don't.

**TNT_Xplosiv** · 27-02-07

Originally Posted by RepublicOfAstra

Honestly, I'm not sure. My DB is a lot different from the ones posted at Ragezone, since my team made our DB long before anyone else did. But I think you just need to use my spInsertChar and it should be good. I guess the values that were giving you errors were just for columns I have that the others don't.

Well, the problem with that is, I get nomsg (E-1) whenever I try to create a new character with the 2 sequences and values taken out. I'm not a pro at SQL but I'm pretty sure that shouldn't be happening.

**RepublicOfAstra** · 27-02-07

I thought you said that it works once you remove those 2?

Well, if it's still fucking up on you, just remove the stuff or replace the stuff in the proc I posted with the names of the columns in your Character table, or add the stuff in the proc into your Character table.

**TNT_Xplosiv** · 27-02-07

Originally Posted by RepublicOfAstra

I thought you said that it works once you remove those 2?

Well, if it's still fucking up on you, just remove the stuff or replace the stuff in the proc I posted with the names of the columns in your Character table, or add the stuff in the proc into your Character table.

I'll try that tomorrow and hope it works.

**bugmenot0** · 02-03-07

i got 3 problems i hope u all help me

1:
i cant access server idk why
2:
i have creat acc in SQL Server Management Studio Express
and its dont work
3:
reg page i got problem with that ican creat web but i got many warnings
and i dont know where i must type in SQL Server Management Studio Express
e_mail

**noffa** · 02-03-07

can sum1 post the files to fix the corrupted files of the default.mrs plz?

**NIRVANAdylan** · 04-03-07

I got a problem with maps.

One time i could play all my custom maps, But now for some reason they don't appear in the Map drop-down list it just shows the ordinary maps.

Anyone help?

**cosme** · 06-03-07

Originally Posted by NIRVANAdylan

I got a problem with maps.

One time i could play all my custom maps, But now for some reason they don't appear in the Map drop-down list it just shows the ordinary maps.

Anyone help?

insert in the \system\channelrule.xml in the client and the server :SniperHea

**swiftplayer** · 08-03-07

what do u mean by wamp icon? i dun see anything..

**TNT_Xplosiv** · 08-03-07

Alright, thanks to some help from a few friends, I got nomsg E-1 off. Now, I still get a black lobby. Any clue why my lobby is STILL black?

Edit:

Originally Posted by spInsertChar

USE [GunzDB]
GO
/****** Object: StoredProcedure [dbo].[spInsertChar] Script Date: 03/08/2007 15:27:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spInsertChar]
@nAID INT,
@nCharIndex INT,
@szName nvarchar(32),
@nSex INT,
@nHair INT,
@nFace INT,
@nCostume INT
AS
BEGIN
SET NOCOUNT ON;

DECLARE @cnt INT
SELECT @cnt=COUNT(*)
FROM Character
WHERE AID = @nAID

DECLARE @cid INT
SELECT @cid=COUNT(*)
FROM Character

INSERT INTO Character
VALUES(@nAID,@szName,@cnt,1,@nSex,@nCostume,@nFace,@nHair,NULL,0,1000000,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,NULL)
END

Originally Posted by dbo.Character

USE [GunzDB]
GO
/****** Object: Table [dbo].[Character] Script Date: 03/08/2007 15:29:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Character](
[AID] [int] NULL,
[Name] [varchar](50) NULL,
[CharIndex] [int] NULL,
[Level] [int] NULL,
[Sex] [int] NULL,
[Costume] [int] NULL,
[Face] [int] NULL,
[Hair] [int] NULL,
[ClanName] [varchar](50) NULL,
[XP] [int] NULL,
[BP] [money] NULL,
[head_itemid] [int] NULL,
[chest_itemid] [int] NULL,
[hands_itemid] [int] NULL,
[legs_itemid] [int] NULL,
[feet_itemid] [int] NULL,
[fingerl_itemid] [int] NULL,
[fingerr_itemid] [int] NULL,
[melee_itemid] [int] NULL,
[primary_itemid] [int] NULL,
[secondary_itemid] [int] NULL,
[custom1_itemid] [int] NULL,
[custom2_itemid] [int] NULL,
[CharNum] [int] NULL,
[CID] [int] IDENTITY(1,1) NOT NULL,
[HP] [int] NULL,
[AP] [int] NULL,
[FR] [int] NULL,
[CR] [int] NULL,
[ER] [int] NULL,
[WR] [int] NULL,
[KillCount] [int] NULL,
[DeathCount] [int] NULL,
[PlayTime] [int] NULL,
[CLID] [int] NULL,
[ClanGrade] [int] NULL,
[ClanContPoint] [int] NULL,
[head_slot] [int] NULL,
[chest_slot] [int] NULL,
[hands_slot] [int] NULL,
[legs_slot] [int] NULL,
[feet_slot] [int] NULL,
[fingerl_slot] [int] NULL,
[fingerr_slot] [int] NULL,
[melee_slot] [int] NULL,
[primary_slot] [int] NULL,
[secondary_slot] [int] NULL,
[custom1_slot] [int] NULL,
[custom2_slot] [int] NULL,
[QuestItemInfo] [varchar](8000) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

**swiftplayer** · 09-03-07

where can i download the gunz client? the other tut = download dead

**swiftplayer** · 09-03-07

k nvm anything above i got it all set... but the the wamp server.. where the link to where i go to let ppl see the registration page.... www.??? i got it online..but where do i see the registration =[

**hlcm** · 14-03-07

[QUOTE].1.5 How to change login background?
A.
<Change background; Credits to: Irwirkk for the whole tutorial>
1

**Carbine** · 14-03-07

got problem wif quest mode, i got gobin doll, and when i go equip i get client crashed, when i go shop brownse the quest item, my client crashes again

**Linear88** · 15-03-07

I got many errors for WAMP.

**RepublicOfAstra** · 17-03-07

Moved to the Gunz section since this isn't really a release more than a guide or FAQ.

**arnelis** · 20-03-07

look the png files in my default are corrupted their all zeros and i used ur guide too but i think i got it wrong could u please show it in little more detail sorry im just not to good with comps:(Like put files i have to make in interface and stuff

**antonf** · 20-03-07

Registrtion doesn`t work for me i delete in php.ini line mssql but this doesnt`t help
this error Fatal error: Call to undefined function: mssql_connect() in c:\apache\www\gunzon\index.php on line 47

**Dimon-z** · 20-03-07

Open you php.ini file
and delete ; in ;extension=php_mssql.dll
Sorry with my English :(

**antonf** · 20-03-07

Problem done! for others noobs (but am not noob !!!!! )
delete this ; in windows/php.ini and in php/php.ini !!!!!!!!!!!!
1st i delete only in windows/php.ini

**arnelis** · 20-03-07

Ok i know that i should read sticky about default.mrs i do that i unpack my default.mrs change color of loading bar.Than pack and mouse is gone.Than i put back my orginal.Unpack it edit image again do the thing and for last thing i type in ren default defualt.zip and it changes that file into default.zip but its not a zip file.And I open it rename it to default again and pack it and same thing happens mouse is gone.Oh and all png files are 0

**Linear88** · 22-03-07

My WAMP can't connect to SQL Server.

Questions & Answers

Thread Tools

Search Thread

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Re: Questions & Answers

Advertisement