• Scheduled Server Maintenance | Friday 7 November

    Our hardware provider has scheduled RAM maintenance to address the recent server instability. Work is expected by 17:00 Central European time.

    Brief downtime or interruptions may occur while the faulty memory modules are replaced. We apologise for the recent disruption and appreciate your patience.

    Special thanks to our sponsor, HyperFilter!

    We keep our community safe. They keep our servers safe. Running your own game servers? Keep them protected with HyperFilter.

Kalonline request section

K

Kallyanna

🚫
Exiled
Got A Reaction
Joined
Jul 8, 2007
Messages
1,627
Reaction score
1,613
OK .. GUY AND GIRLS, MEN AND WOMEN,NOOBZ and NABZ




I bring to you THE KALONLINE REQUEST SECTION!

If you wish to have a File RE-UPLOADED please DO NOT POST IT IN THE "RELEASE" SECTION INSTEAD.................REPLY TO THIS POST

Way to make your post ..aka format:

EXAMPLE:
POST BY YOU -

Kallyanna said:
[Release] Jungle/Swamp Map - RaGEZONE - MMO development community <--- (YES I FAILED this on purpose) - LINK TO THE POST YOU WISH TO HAVE THE FILES FROM IF LINKS ARE BROKEN!



The links to these files are broken or are old er then 2013 can some one re- up load them please?
Click to expand...


If you flame this post ... ill throw bananas at you cos i like it an its fun... also its better then the monkey alternative xD :ott1:





WARNING ANY FLAMING I TURN IN TO BEAUTIFUL BUTTERFLIES! only i throw poo around here! lol *flings poops at everyone* ... since i ate all the bananas xD
 
Sort by date Sort by votes
greenmorse said:
Anybody have files of repacks from 2009 and older? Webadmin.. Avalanche.. or anything like that? All the links from release thread are dead.
Click to expand...

Repack - Webadim Ultimate
This is the Webadim Ultimate Full Repack
PK Password: BLACK#NASE#ÖÖ
To view the content, you need to sign in or register


This is the Paradise Kal Full Repack
To view the content, you need to sign in or register
 
Upvote 0
Someone have a fix for both monsters ? they read only 1x GTX file... i've test everything possible, stil get stuck with them :s

To view the content, you need to sign in or register
To view the content, you need to sign in or register
 
Upvote 0
SySy said:
Someone have a fix for both monsters ? they read only 1x GTX file... i've test everything possible, stil get stuck with them :s

To view the content, you need to sign in or register
To view the content, you need to sign in or register
Click to expand...

what is name of monsters
 
Upvote 0
M334 and M335 (Bone 1 - 8)

I fixed myself the doggebi on 3dsmax
To view the content, you need to sign in or register


Also most of the Private Invading (M334). The bones B2/B3/B4 aren't read ingame.
may i something wrong in Macro.dat.
 
Upvote 0
PHP: 
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[CreatePlayer]

@uid int,
  [USER=1333344765]name[/USER] varchar(14),
  [USER=437263]clas[/USER]s tinyint,
  [USER=1333337944]Strength[/USER] tinyint,
  [USER=1333358440]Health[/USER] tinyint,
  [USER=1333377165]Intelligence[/USER] tinyint,
  [USER=775152]Wisdom[/USER] tinyint,
  [USER=372998]dexterity[/USER] tinyint,
@curhp smallint,
@curmp smallint,
@map tinyint,
@x int,
@y int,
@z int,
  [USER=12229]face[/USER] tinyint,
  [USER=297467]Hai[/USER]r tinyint

AS

DECLARE @PID int
DECLARE @GM int
DECLARE  [USER=49]global[/USER]gm int
DECLARE @itemid int
DECLARE  [USER=829527]Start[/USER]items int
DECLARE  [USER=1333341659]knightX[/USER] int
DECLARE  [USER=112839]KnightY[/USER] int
DECLARE @knightz int
DECLARE @knightm int
DECLARE  [USER=229454]mage[/USER]x int
DECLARE  [USER=229454]mage[/USER]y int
DECLARE  [USER=592500]magez[/USER] int
DECLARE  [USER=229454]mage[/USER]m int
DECLARE  [USER=3043]archer[/USER]x int
DECLARE  [USER=3043]archer[/USER]y int
DECLARE  [USER=3043]archer[/USER]z int
DECLARE  [USER=3043]archer[/USER]m int

--***************************************
SET  [USER=829527]Start[/USER]items = 1 --set to 0 to disable
--Knight*********************************
SET  [USER=1333341659]knightX[/USER] = 257565 -- X Coord
SET  [USER=112839]KnightY[/USER] = 259394 -- Y Coord
SET @knightz = 16131 -- Z Coord
SET @knightm = 0 -- MAP, 0 for normal world
--Mage***********************************
SET  [USER=229454]mage[/USER]x = 257473 -- X Coord
SET  [USER=229454]mage[/USER]y = 259191 -- Y Coord
SET  [USER=592500]magez[/USER] = 16080 -- Z Coord
SET  [USER=229454]mage[/USER]m = 0 -- MAP, 0 for normal world
--Archer*********************************
SET  [USER=3043]archer[/USER]x = 257254 -- X Coord
SET  [USER=3043]archer[/USER]y = 259242 -- Y Coord
SET  [USER=3043]archer[/USER]z = 16104 -- Z Coord
SET  [USER=3043]archer[/USER]m = 0 -- MAP, 0 for normal world
--***************************************


--Start Koordinates für jedes Klasse extra zuweisen
IF   [USER=437263]clas[/USER]s = 0) --knight
   begin
   Set @x =  [USER=1333341659]knightX[/USER]
   Set @y =  [USER=112839]KnightY[/USER]
   Set @z = @knightz
   Set @map = @knightm
   end
ELSE IF   [USER=437263]clas[/USER]s = 1) --mage
   begin
   Set @x =  [USER=229454]mage[/USER]x
   Set @y =  [USER=229454]mage[/USER]y
   Set @z =  [USER=592500]magez[/USER]
   Set @map =  [USER=229454]mage[/USER]m
   end
ELSE IF   [USER=437263]clas[/USER]s = 2) --archer
   begin
   Set @x =  [USER=3043]archer[/USER]x
   Set @y =  [USER=3043]archer[/USER]y
   Set @z =  [USER=3043]archer[/USER]z
   Set @map =  [USER=3043]archer[/USER]m
   end
set  [USER=775152]Wisdom[/USER] =  [USER=775152]Wisdom[/USER]+200
--Charakter erstellen
begin
INSERT INTO Player ( [UID], [Admin], [Name], [Class], [Strength], [Health], [Intelligence], [Wisdom], [Dexterity], [CurHP], [CurMP], [Map], [X], [Y], [Z], [Face], [Hair]) VALUES ( @uid, 0,  [USER=1333344765]name[/USER],  [USER=437263]clas[/USER]s,  [USER=1333337944]Strength[/USER],  [USER=1333358440]Health[/USER]  [USER=1333377165]Intelligence[/USER]  [USER=775152]Wisdom[/USER],  [USER=372998]dexterity[/USER],@curhp,@curmp,  @map, @x, @y, @z,  [USER=12229]face[/USER],  [USER=297467]Hai[/USER]r)
end

--Jeder Klasse eigene Items geben
IF   [USER=829527]Start[/USER]items = 1)
begin
SET @PID = (select max([PID]) from Player WHERE [UID] = @UID)
SET @itemid =(select max([IID]) from Item)

   --common items
    IF (@itemid >= 1000000)
      begin
      SET @itemid =(select max([IID]) from Item) + 1
      end
    ELSE
      begin
      SET @itemid = 1000000
      end


    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 3022, 0, 128, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 3009, 0, 128, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 3000, 0, 128, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 538, 0, 128, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
    SET @itemid = @itemid + 1
    INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 471, 0, 128, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )

IF   [USER=437263]clas[/USER]s = 0) --knight
   begin
      --weapon
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 61, 46, 129, 1, 12, 12, 0, 8, 0, 0, 0, 0, 0, 8, 8 )
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 67, 46, 129, 1, 12, 12, 0, 8, 0, 0, 0, 0, 0, 8, 8 )
      --armor
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 49, 0, 129, 1, 12, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 50, 0, 129, 1, 8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 51, 0, 129, 1, 6, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 52, 0, 129, 1, 8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 53, 0, 129, 1, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
      --baked eel
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 268, 0, 128, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
      INSERT INTO Skill ( [Index] , [Level] , [PID] ) VALUES ( 23 , 5, @PID )
  end

ELSE IF   [USER=437263]clas[/USER]s = 2) --archer
   begin
      --weapon
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 64, 46, 129, 1, 12, 12, 0, 0, 8, 0, 0, 0, 0, 8, 8 )
      --armor
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 54, 0, 129, 1, 12, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 55, 0, 129, 1, 8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 56, 0, 129, 1, 6, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 57, 0, 129, 1, 8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 58, 0, 129, 1, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
         --baked eel
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 268, 0, 128, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
      INSERT INTO Skill ( [Index] , [Level] , [PID] ) VALUES ( 6 , 3, @PID )
   end

ELSE IF   [USER=437263]clas[/USER]s = 1) --mage
   begin
      --weapon
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 98, 46, 129, 1, 12, 12, 0, 8, 0, 0, 0, 0, 0, 8, 8 )
      --armor
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 85, 0, 129, 1, 12, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 86, 0, 129, 1, 8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 87, 0, 129, 1, 6, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 88, 0, 129, 1, 8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 89, 0, 129, 1, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
         --eel soup
      SET @itemid = @itemid + 1
      INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 268, 0, 128, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
      INSERT INTO Skill ( [Index] , [Level] , [PID] ) VALUES ( 24 , 1, @PID )
   end
end



Jonwr said:
does anybudy , got SQL Query Start with item?
Click to expand...

there you go
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[CreatePlayer]

@uid int, name varchar(14), class tinyint, Strength tinyint, Health tinyint, Intelligence tinyint, Wisdom tinyint, dexterity tinyint,
@curhp smallint,
@curmp smallint,
@map tinyint,
@x int,
@y int,
@z int, face tinyint, Hair tinyint

AS

DECLARE @PID int
DECLARE @GM int
DECLARE globalgm int
DECLARE @itemid int
DECLARE Startitems int
DECLARE knightX int
DECLARE KnightY int
DECLARE @knightz int
DECLARE @knightm int
DECLARE magex int
DECLARE magey int
DECLARE magez int
DECLARE magem int
DECLARE archerx int
DECLARE archery int
DECLARE archerz int
DECLARE archerm int

--***************************************
SET Startitems = 1 --set to 0 to disable
--Knight*********************************
SET knightX = 257565 -- X Coord
SET KnightY = 259394 -- Y Coord
SET @knightz = 16131 -- Z Coord
SET @knightm = 0 -- MAP, 0 for normal world
--Mage***********************************
SET magex = 257473 -- X Coord
SET magey = 259191 -- Y Coord
SET magez = 16080 -- Z Coord
SET magem = 0 -- MAP, 0 for normal world
--Archer*********************************
SET archerx = 257254 -- X Coord
SET archery = 259242 -- Y Coord
SET archerz = 16104 -- Z Coord
SET archerm = 0 -- MAP, 0 for normal world
--***************************************


--Start Koordinates für jedes Klasse extra zuweisen
IF class = 0) --knight
begin
Set @x = knightX
Set @y = KnightY
Set @z = @knightz
Set @map = @knightm
end
ELSE IF class = 1) --mage
begin
Set @x = magex
Set @y = magey
Set @z = magez
Set @map = magem
end
ELSE IF class = 2) --archer
begin
Set @x = archerx
Set @y = archery
Set @z = archerz
Set @map = archerm
end
set Wisdom = Wisdom+200
--Charakter erstellen
begin
INSERT INTO Player ( [UID], [Admin], [Name], [Class], [Strength], [Health], [Intelligence], [Wisdom], [Dexterity], [CurHP], [CurMP], [Map], [X], [Y], [Z], [Face], [Hair]) VALUES ( @uid, 0, name, class, Strength, Health Intelligence Wisdom, dexterity,@curhp,@curmp, @map, @x, @y, @z, face, Hair)
end

--Jeder Klasse eigene Items geben
IF Startitems = 1)
begin
SET @PID = (select max([PID]) from Player WHERE [UID] = @UID)
SET @itemid =(select max([IID]) from Item)

--common items
IF (@itemid >= 1000000)
begin
SET @itemid =(select max([IID]) from Item) + 1
end
ELSE
begin
SET @itemid = 1000000
end


INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 3022, 0, 128, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 3009, 0, 128, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 3000, 0, 128, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 538, 0, 128, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 471, 0, 128, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )

IF class = 0) --knight
begin
--weapon
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 61, 46, 129, 1, 12, 12, 0, 8, 0, 0, 0, 0, 0, 8, 8 )
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 67, 46, 129, 1, 12, 12, 0, 8, 0, 0, 0, 0, 0, 8, 8 )
--armor
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 49, 0, 129, 1, 12, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 50, 0, 129, 1, 8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 51, 0, 129, 1, 6, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 52, 0, 129, 1, 8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 53, 0, 129, 1, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
--baked eel
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 268, 0, 128, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
INSERT INTO Skill ( [Index] , [Level] , [PID] ) VALUES ( 23 , 5, @PID )
end

ELSE IF class = 2) --archer
begin
--weapon
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 64, 46, 129, 1, 12, 12, 0, 0, 8, 0, 0, 0, 0, 8, 8 )
--armor
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 54, 0, 129, 1, 12, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 55, 0, 129, 1, 8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 56, 0, 129, 1, 6, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 57, 0, 129, 1, 8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 58, 0, 129, 1, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
--baked eel
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 268, 0, 128, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
INSERT INTO Skill ( [Index] , [Level] , [PID] ) VALUES ( 6 , 3, @PID )
end

ELSE IF class = 1) --mage
begin
--weapon
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 98, 46, 129, 1, 12, 12, 0, 8, 0, 0, 0, 0, 0, 8, 8 )
--armor
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 85, 0, 129, 1, 12, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 86, 0, 129, 1, 8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 87, 0, 129, 1, 6, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 88, 0, 129, 1, 8, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 89, 0, 129, 1, 10, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
--eel soup
SET @itemid = @itemid + 1
INSERT INTO Item ( [PID], [IID], [Index], [Prefix], [Info], [Num], [MaxEnd], [CurEnd], [SetGem], [XAttack], [XMagic], [XDefense], [XHit], [XDodge], [Protect], [UpgrLevel], [UpgrRate]) VALUES ( @PID, @itemid, 268, 0, 128, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
INSERT INTO Skill ( [Index] , [Level] , [PID] ) VALUES ( 24 , 1, @PID )
end
end
Click to expand...
 
Upvote 0
Ismir93 said:
Repack - Webadim Ultimate
This is the Webadim Ultimate Full Repack
PK Password: BLACK#NASE#ÖÖ
To view the content, you need to sign in or register


This is the Paradise Kal Full Repack
To view the content, you need to sign in or register
Click to expand...

Hi, do you still have these files? can you reupload please? thanks in advance
 
Upvote 0
You must log in or register to reply here.

RaGEZONE Sponsor

    HyperFilter

About RaGEZONE

RaGEZONE® is a leading MMO and MMORPG development community offering source codes, server files, tutorials, tools, and private servers for developers and gamers.

Forum Statistics

Members online
1,377
Guests online
8,332
Total visitors
9,709
Totals may include hidden visitors.

RaGEZONE Partners

    non GamStop casinos
Back