--DBADINIZ YAZAN YERE DB İSMİNİZİ YAZIN.
USE [DBADINIZ]
GO
/****** Object: StoredProcedure [dbo].[YENICHAR_LETTER] Script Date: 03/14/2012 18:56:09 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[YENICHAR_LETTER]
@account varchar(21)
AS
--Mustify tarafından kodlanmıştır. Bu satırı değiştiren Ajdardır.
begin
/*1 = Warrior
2 = Rogue
3 = Mage
4 = Priest
*/
declare @class smallint
print @class
select @class = class from userdata where struserid=@account
print @class
if @class=101 or @class=105 or @class=106 or @class=201 or @class=205 or @class=206
begin
exec send_item @account,'139440790' /* baal */
exec send_item @account,'156310050' /* raptor */
exec send_item @account,'135750280' /* giga */
exec send_item @account,'159420770' /* nebiros */
exec send_item @account,'197420350' /* gabs */
exec send_item @account,'129101220' /* hanguk */
exec send_item @account,'206001020' /* shell */
exec send_item @account,'206002020' /* shell */
exec send_item @account,'206003020' /* shell*/
exec send_item @account,'206004020' /* shell*/
exec send_item @account,'206005020' /* shell */
exec send_item @account,'330620435' /* rof*/
exec send_item @account,'330620435' /* rof */
exec send_item @account,'340610375' /* belt */
exec send_item @account,'320310415' /* neck */
exec send_item @account,'310511135' /* mino*/
exec send_item @account,'310511135' /* mino */
exec send_item @account,'149101230' /* hb*/
exec send_item @account,'910120360' /* quest*/
exec send_item @account,'139301530' /* avedon */
exec send_item @account,'379063000' /* scream sc */
end
if @class=102 or @class=107 or @class=108 or @class=202 or @class=207 or @class=208
begin
exec send_item @account,'246001520' /* shell*/
exec send_item @account,'246002520' /* shell*/
exec send_item @account,'246003520' /* shell*/
exec send_item @account,'246004520' /* shell*/
exec send_item @account,'246005520' /* shell*/
exec send_item @account,'310512145' /* hr*/
exec send_item @account,'310512145' /* hr*/
exec send_item @account,'128420820' /* raum*/
exec send_item @account,'128420820' /* raum*/
exec send_item @account,'180440790' /* wf*/
exec send_item @account,'169302420' /* ee*/
exec send_item @account,'119101210' /* dv*/
exec send_item @account,'910119310' /* self */
exec send_item @account,'119102420' /*chd*/
exec send_item @account,'169301540' /*helenid*/
exec send_item @account,'330620435' /* rof*/
exec send_item @account,'330620435' /* rof */
exec send_item @account,'340610375' /* belt */
exec send_item @account,'320310415' /* neck */
exec send_item @account,'379064000' /* valor */
end
if @class=103 or @class=109 or @class=110 or @class=203 or @class=209 or @class=210
begin
exec send_item @account,'330910605' /* flame ring */
exec send_item @account,'330910605' /* flame ring */
exec send_item @account,'330930625' /* imir ring */
exec send_item @account,'330930625' /* imir ring */
exec send_item @account,'330920625' /* shio tears */
exec send_item @account,'330920625' /* shio tears */
exec send_item @account,'320110315' /* elemental pend. */
exec send_item @account,'340410395' /* Glass belt */
exec send_item @account,'910123580' /* Staff of selfname */
exec send_item @account,'379065000' /* Absolute pw sc */
exec send_item @account,'310513155' /* Lich king */
exec send_item @account,'310513155' /* Lich king */
exec send_item @account,'800015000' /* Speed */
exec send_item @account,'379070000' /* 57 */
exec send_item @account,'379069000' /* 51 */
exec send_item @account,'266001510' /* complete */
exec send_item @account,'266002510' /* complete */
exec send_item @account,'266003510' /* complete */
exec send_item @account,'266004510' /* complete */
exec send_item @account,'266005510' /* complete */
exec send_item @account,'320310415' /* Iron Neck */
exec send_item @account,'800036000' /* rez sc */
exec send_item @account,'182430820' /* fulitol */
exec send_item @account,'184430880' /* faun */
exec send_item @account,'183230850' /* molok */
end
if @class=104 or @class=111 or @class=112 or @class=204 or @class=211 or @class=212
begin
exec send_item @account,'286001510' /* shell*/
exec send_item @account,'286002510' /* shell*/
exec send_item @account,'286003510' /* shell*/
exec send_item @account,'286004510' /* shell*/
exec send_item @account,'286005510' /* shell*/
exec send_item @account,'149101230' /* hb*/
exec send_item @account,'330620435' /* rof*/
exec send_item @account,'330620435' /* rof */
exec send_item @account,'340610375' /* belt */
exec send_item @account,'320310415' /* neck */
exec send_item @account,'170250270' /* cs */
exec send_item @account,'179102330' /* ds */
exec send_item @account,'310514165' /* lillime */
exec send_item @account,'310514165' /* lillime */
exec send_item @account,'190250280' /* lobo */
exec send_item @account,'190250300' /* lycaon */
exec send_item @account,'199301580' /* holy animor */
exec send_item @account,'910125380' /* self */
exec send_item @account,'197420350' /* gabs */
exec send_item @account,'198420440' /* leonar */
exec send_item @account,'379066000' /* judge */
exec send_item @account,'170250280' /* scorpion shield */
exec send_item @account,'281001020' /* paper */
exec send_item @account,'281002020' /* paper */
exec send_item @account,'281003020' /* paper */
exec send_item @account,'281004020' /* paper */
exec send_item @account,'281005020' /* paper */
end
if @class=101 update userdata set class = '106' where struserid = @account
if @class=201 update userdata set class = '206' where struserid = @account
if @class=102 update userdata set class = '108' where struserid = @account
if @class=202 update userdata set class = '208' where struserid = @account
if @class=103 update userdata set class = '110' where struserid = @account
if @class=203 update userdata set class = '210' where struserid = @account
if @class=104 update userdata set class = '111' where struserid = @account
if @class=204 update userdata set class = '211' where struserid = @account
end
