Jump to content

Majestic12

VIP Member
  • Content Count

    1,409
  • Joined

  • Last visited

  • Days Won

    2
  • Feedback

    100%

Majestic12 last won the day on November 8 2014

Majestic12 had the most liked content!

Community Reputation

4 Neutral

About Majestic12

  • Rank
    Count

Profile Information

  • Current Mood
    Busy
  • Gender
    Male
  • Country
    EU

Recent Profile Visitors

2,470 profile views
  1. CREATE TABLE [SubStack]( [char_id] [int] NOT NULL DEFAULT 0, [baseClass0] [int] NOT NULL DEFAULT -1, [baseClass1] [int] NOT NULL DEFAULT -1, [baseClass2] [int] NOT NULL DEFAULT -1, [baseClass3] [int] NOT NULL DEFAULT -1, [stackClass0] [int] NOT NULL DEFAULT -1, [stackClass1] [int] NOT NULL DEFAULT -1, [stackClass2] [int] NOT NULL DEFAULT -1, [stackClass3] [int] NOT NULL DEFAULT -1 ) ON [PRIMARY] GO CREATE PROCEDURE lin_SaveSubStack ( @charId INT, @classIndex INT, @baseClass INT, @stackClass INT ) AS SET NOCOUNT ON; IF @classIndex = 0 BEGIN UPDATE [SubStack] SET [baseClass0] = @baseClass, [stackClass0] = @stackClass WHERE [char_id] = @charId IF @@ROWCOUNT=0 BEGIN INSERT INTO [SubStack] ([char_id], [baseClass0], [stackClass0] ) VALUES (@charId, @baseClass, @stackClass ) END END ELSE IF @classIndex = 1 BEGIN UPDATE [SubStack] SET [baseClass1] = @baseClass, [stackClass1] = @stackClass WHERE [char_id] = @charId IF @@ROWCOUNT=0 BEGIN INSERT INTO [SubStack] ([char_id], [baseClass1], [stackClass1] ) VALUES (@charId, @baseClass, @stackClass ) END END ELSE IF @classIndex = 2 BEGIN UPDATE [SubStack] SET [baseClass2] = @baseClass, [stackClass2] = @stackClass WHERE [char_id] = @charId IF @@ROWCOUNT=0 BEGIN INSERT INTO [SubStack] ([char_id], [baseClass2], [stackClass2] ) VALUES (@charId, @baseClass, @stackClass ) END END ELSE IF @classIndex = 3 BEGIN UPDATE [SubStack] SET [baseClass3] = @baseClass, [stackClass3] = @stackClass WHERE [char_id] = @charId IF @@ROWCOUNT=0 BEGIN INSERT INTO [SubStack] ([char_id], [baseClass3], [stackClass3] ) VALUES (@charId, @baseClass, @stackClass ) END END GO
  2. areadata.txt type=battle_zone area_begin name=[gludin_pvp] map_no = {17;22} type=battle_zone range = {{-88411;141732;-3752;-3352};{-87429;141733;-3752;-3352};{-87429;142708;-3752;-3352};{-88408;142708;-3752;-3352}} area_end
  3. Anyone have the source of fast load npc for vanganth extender?
×