CreatePlayer Stored Proceedure for Theif

[Kallyanna]

Since I dnt remember who made the origional...... General i think....
Give them most of the Credit

Kal_db/Programability/Stored Proceedures

If you have this in your DB already.... change CREATE PROCEEDURE to ALTER PROCEEDURE

if not then make new Copy n paste then press F5

USE [Kal_db]
GO
/****** Object:  StoredProcedure [dbo].[CreatePlayer]    Script Date: 10/06/2013 15:46:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE 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
DECLARE @theifx int
DECLARE @theify int
DECLARE @theifz int
DECLARE @theifm int




--***************************************
SET @startitems = 1 --set to 0 to disable
--Knight*********************************
SET @knightx = 277091 -- X Coord
SET @knighty = 267423 -- Y Coord
SET @knightz = 39870 -- Z Coord
SET @knightm = 0 -- MAP, 0 for normal world
--Mage***********************************
SET @magex = 277118 -- X Coord
SET @magey = 267406 -- Y Coord
SET @magez = 39870 -- Z Coord
SET @magem = 0 -- MAP, 0 for normal world
--Archer*********************************
SET @archerx = 277138 -- X Coord
SET @archery = 267371 -- Y Coord
SET @archerz = 39870 -- Z Coord
SET @archerm = 0 -- MAP, 0 for normal world
--Theif**********************************
SET @theifx = 277138 -- X Coord
SET @theify = 267371 -- Y Coord
SET @theifz = 39870 -- Z Coord
SET @theifm = 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
ELSE IF (@Class = 3) --theif
begin
Set @x = @theifx
Set @y = @theify
Set @z = @theifz
Set @map = @theifm
end

--Global Gamemaster, liest Admin in Login Table
SET @globalgm = (SELECT [Admin] FROM kal_auth.dbo.Login WHERE [UID] = @UID)
IF (@globalgm > 1)
begin
--SET @Name = "[GM]" + @name --Benötigt relog und gibt fehler
SET @GM = @globalgm
end
ELSE
begin
SET @GM = 0
end

--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, @GM, @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, 16, 0, 128, 500, 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, 18, 0, 128, 200, 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, 20, 0, 128, 10, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
--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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
--accessoires und animal
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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
--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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
--accessoires und animal
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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
--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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
--accessoires und animal
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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
end
ELSE IF (@Class = 3) --theif
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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
--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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
--accessoires und animal
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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 )
end
end

To change the start position =

EDIT THIS

--***************************************
SET @startitems = 1 --set to 0 to disable
--Knight*********************************
SET @knightx = 277091 -- X Coord
SET @knighty = 267423 -- Y Coord
SET @knightz = 39870 -- Z Coord
SET @knightm = 0 -- MAP, 0 for normal world
--Mage***********************************
SET @magex = 277118 -- X Coord
SET @magey = 267406 -- Y Coord
SET @magez = 39870 -- Z Coord
SET @magem = 0 -- MAP, 0 for normal world
--Archer*********************************
SET @archerx = 277138 -- X Coord
SET @archery = 267371 -- Y Coord
SET @archerz = 39870 -- Z Coord
SET @archerm = 0 -- MAP, 0 for normal world
--Theif**********************************
SET @theifx = 277138 -- X Coord
SET @theify = 267371 -- Y Coord
SET @theifz = 39870 -- Z Coord
SET @theifm = 0 -- MAP, 0 for normal world
--***************************************

Also to use this.... you MUST EDIT YOU DB SERVER!

FIND THIS IN A HEX EDITOR!

INSERT INTO Player ( [UID], [Name], [Class],  [Strength], Health, Intelligence, Wisdom, Dexterity, [CurHP], [CurMP],  [Map], [X], [Y], [Z], [Face], [Hair]) VALUES ( %d, '%s', %d, %d, %d, %d,  %d, %d, %d, %d, %d, %d, %d, %d, %d, %d)
 

copy and paste this in its place!

EXEC CreatePlayer %d,%s,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d.......................................................................................................................................................................

And VOILA! You can make custom weapons to spawn in new players inventories and items and change the Start coordinates.....

NOTE! UNLESS YOU ARE USING THE TERMINA NEW CLIENT RE-PACK....YOU WILL SPAWN INSIDE A MOUNTAIN!!!!!!!!! so change the start coords before you start!!!!!!!!!!!!!!

[MentaL]

[ShiinY]

Nice1 :)

[Justdoing]

Kallyanna can make it in clean repack but it wanna a engine +cry.dll

[Kallyanna]

You have to add it yourself hun, :) sorry but if you dnt do these things for yourself, you wont learn....took me ages and with alot of help to get as far as i am today with knowing how to do stuff :) it is all about trial and error... PLENTY of nice peeps on RZ around to help and give advice :)

[Hazem Hoster]

That was pretty useful to use and recheck my files . Thank you! =D

[insert]

@Kallyanna


Where in Stored Procedures do I go?

[ASN]

@Kallyanna


Where in Stored Procedures do I go?

And you dare to lead a private server?:O Well "good luck"

Read this:
http://forum.ragezone.com/f315/intro...ooking-551652/

[wulkan1237]

hmm invalid column name 'Admin'

all SP from termina work good only this one...

[Smul Karme]

where i can find : im finsih stored but left it sorry for my bad english

INSERT INTO Player ( [UID], [Name], [Class], [Strength], Health, Intelligence, Wisdom, Dexterity, [CurHP], [CurMP], [Map], [X], [Y], [Z], [Face], [Hair]) VALUES ( %d, '%s', %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d)

[Kallyanna]

where i can find : im finsih stored but left it sorry for my bad english

INSERT INTO Player ( [UID], [Name], [Class], [Strength], Health, Intelligence, Wisdom, Dexterity, [CurHP], [CurMP], [Map], [X], [Y], [Z], [Face], [Hair]) VALUES ( %d, '%s', %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d)

You hexedit your Database server

[WindF]

i need This dll please :)

[Kallyanna]

Its not a dll its a database stored proceedure, you can just add it right in if you follow my instructions carefully

[Zerker]

it dont give me the items out why not?

[Bruniak]

Msg 207, Level 16, State 1, Procedure CreatePlayer, Line 103
Invalid column name 'Admin'.

Same problem How Fix ?

[Zerker]

Create a column with the Name Admin in db_auth - Login