Junior Spellweaver
I followed the tutorial and all works but i noticed that in the store there are less items than normal and no premiums... i saw many server with alot more items in stre can u tell me how to get a decent amount of items in shop?
myself said:can you tell me how to add ports on windows firewall to make the server work also with windows firewall active?
why when i try to edit the procedure InsertChar to edit starting lvl and bounty e get errors when i try to run the query?
ok... where can i find the proc?
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);