USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Create_Char_R] Script Date: 07/14/2015 08:01:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
/****** 개체: 저장 프로시저 dbo.usp_Create_Char_R 스크립트 날짜: 2006-05-30 오후 12:53:23 ******/
SET @CharName = LTRIM(RTRIM(@CharName))
SET @SkillPoint = 5
SET @Ret = 0
SET @NameCnt = (SELECT ISNULL(COUNT(*),0) FROM Chars WHERE CharName=@CharName AND Del=0)
IF(@NameCnt <> 0)
BEGIN
RETURN -2
END
ELSE
BEGIN
IF EXISTS ( SELECT CharID FROM Chars WHERE CharName=@CharName AND Del = 1 AND [Level] >10 AND DeleteDate > DATEADD(dd, -7, GETDATE()) )
BEGIN
RETURN -2
END
BEGIN TRANSACTION
DECLARE @MaxLevel int
SET @MaxLevel=60
SET @Str = (
CASE
WHEN @Family=0 AND @Job=0 THEN @Str + (@MaxLevel-1)
WHEN @Family=3 AND @Job=0 THEN @Str + (@MaxLevel-1) ELSE @Str END)
SET @Rec = (
CASE
WHEN @Family=0 AND @Job=1 THEN @Rec + (@MaxLevel-1)
WHEN @Family=3 AND @Job=1 THEN @Rec + (@MaxLevel-1) ELSE @Rec END)
SET @Dex = (
CASE
WHEN @Family=1 AND @Job=2 THEN @Dex + (@MaxLevel-1)
WHEN @Family=2 AND @Job=2 THEN @Dex + (@MaxLevel-1) ELSE @Dex END)
SET @Luc = (
CASE
WHEN @Family=1 AND @Job=3 THEN @Luc + (@MaxLevel-1)
WHEN @Family=3 AND @Job=3 THEN @Luc + (@MaxLevel-1) ELSE @Luc END)
SET @Int = (
CASE
WHEN @Family=1 AND @Job=4 THEN @Int + (@MaxLevel-1)
WHEN @Family=2 AND @Job=4 THEN @Int + (@MaxLevel-1) ELSE @Int END)
SET @Wis = (
CASE
WHEN @Family=0 AND @Job=5 THEN @Wis + (@MaxLevel-1)
WHEN @Family=2 AND @Job=5 THEN @Wis + (@MaxLevel-1) ELSE @Wis END)
[Selling] DarkOrbit | De1 | Level 15 | > Starter Account < 03/25/2013 - DarkOrbit Trading - 6 Replies Servus,
Ich möchte gerne einen kleinen Deutschland 1 Account, den ich auf meiner Email gefunden habe, verkaufen.
Nun mal ein paar grobe Informationen:
~ 108.000.000 Ehrfahrungspunkte
~ 555.000 Ehre
- Rang Basic Lieutnant (2k RP zum nächsten)
- Schiff Goliath (+ Alle Designs aus dem Handel)
[NA] Selling Level 30 | 30+ Champs, 6k IP, Many Runes | GREAT STARTER ACCOUNT! 02/12/2013 - League of Legends Trading - 1 Replies Hey everyone,
I will be selling my North American server League of Legends account that is level 30 and has almost 400 ranked games played in this season alone.
I want to start a new account and drop this account for RP, the RP is going to be used to XP boost my way up to 30, buy champs and maybe a skin.\
I'll be asking for $50 straight RP gifted to my new level 10 noob account. We can work the trade out via skype.
Skype: Mattwilson91
Diablo III – KOSTENLOSE Starter Edition bis Level 13 bzw. Akt I Skelettkönig gratis b 08/22/2012 - Freebies - 0 Replies http://eu.media5.battle.net/cms/blog_header/LPLZMN 4ULZIP1344955701618.jpg
Die von Dämonen belagerte Welt Sanktuario braucht Helden.
Jetzt könnt ihr euch mit der brandneuen Diablo® III Starter Edition
KOSTENLOS dem apokalyptischen Kampf anschließen. Mit der exklusiv über
Battle.net® erhältlichen Starter Edition könnt ihr euch in Akt I bis zum
Skelettkönig vorkämpfen und Stufe 13 erreichen, ohne Diablo III kaufen
zu müssen.
how to change starter riding level to lvl.30? 07/24/2012 - Metin2 Private Server - 1 Replies i had edited starter contain a level.30 horse, but the riding level still was lvl.1 so player can't use the horse skill. please help me to solve it! :handsdown:
Can I use this quest? but i don't know where should I putting in.
http://www.elitepvpers.com/forum/metin2-pserver-g uides-strategies/505551-quest-stallbursche.html
[Request] Edit the Highest Level & Change the Item Level 10/23/2010 - CO2 Private Server - 2 Replies Hello Together ,
I have a question, how can i change the Highest level Like from 137 to 150.
And the Second question how an i change the level of a Item like from 132 to 135 and from 137 to 140 =)
I hope u understand my bad English*