Knight Online Koxp, MultiClient, Bypass, Bugs, Minor Pedal, Macro > Asiturk.com.tr - Prosedürler & Kodlar

Npc Silme Kodu / AI SERVER Açılmıyorsaki KOD

Thu, 12 Sep 2013 15:13:58 +0300

NPC SİLME KODU

Kod:
DELETE FROM K_Npc WHERE (sSid = 'Npc kodu') 

DELETE FROM K_Npcpos WHERE (npcid = 'Npc kodu')

NPC SİLDİN Aİ SERVER ACILMIYORSA

Kod:
delete from K_NPCPOS where npcid not in (Select ssid from K_NPC) and npcid not in (Select ssid from K_MONSTER)

DB Sıfırlama Kodu

Tue, 10 Sep 2013 11:42:00 +0300

Kod:
truncate table account_char

go

truncate table currentuser

go

truncate table deleted_userdata

go

truncate table knights

go

truncate table knights_rating

go

truncate table knights_user

go

truncate table tb_user

go

truncate table userdata

go

truncate table warehouse

go

truncate table np_kings

go

truncate table np_kings2

go

truncate table USER_SAVED_MAGIC

go

truncate table USERDATA_SKILLSHORTCUT

go

truncate table PREMIUM_SERVICE

go

truncate table KARUS_RANK

go

truncate table ELMO_RANK

go

truncate table HERO_USER

go

truncate table KNIGHTS

go

truncate table KNIGHTS_ALLIANCE

go

truncate table KNIGHTS_USER

go

Sorunsuz banka başlangiç

Tue, 10 Sep 2013 11:41:16 +0300

TABLO EKLE

Kod:
CREATE TABLE [dbo].[BANKASTART]( [Char] [smallint] NULL, [WareHouseData] [varchar](1600)NULL, ) ON [PRIMARY] GO INSERT INTO BANKASTART VALUES (1,NULL)

PROSEDÜRÜ EKLEYELİM

Kod:
USE [Kn_online] GO /****** Object: StoredProcedure [dbo].[StartBanka] Script Date: 08/23/2010 19:36:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[StartBanka] @AccountID char(21) AS --Yazan ve Cizen: AKI --pvpke.com DECLARE @row varchar(1600) SET @row = null SELECT @row = WareHouseData FROM WAREHOUSE WHERE strAccountID = @AccountID IF @row IS null BEGIN update WAREHOUSE set WarehouseData = ( select WarehouseData from BANKASTART where Char = '1' ) where strAccountID = @AccountID END

Create_New_Char Prosedürünü açın ve en alta inin GO komutunun üstüne yapıstırın.

Kod:
EXEC StartBanka @AccountID IF @@ERROR <> 0 BEGIN ROLLBACK TRAN SET @nRet = 4 RETURN END COMMIT TRAN SET @nRet = 0

Banka başlangıç itemlerini, İnventory editor ile ekleyin veya Oyundan daha önce açtığınız bir Char'ın bankasına ekleyin.

Öneri: Oyuna giriş ID'si BANKA , Şifresi BANKA , Oyundaki nickide BANKA olabilir. Ben BANKA giriş ID liye göre yazmaktayım.

İtemleri BANKA ID'li hesaba ekledikten sonra, Aşağıdaki kodu QA da uygulayın F5 yapın.

Kod:
update BANKASTART set WarehouseData = (select WarehouseData from WAREHOUSE where strAccountID like 'BANKA') where Char = '1'

Başlangıç Level Para Stat Point Skill Point Ayarlama

Tue, 10 Sep 2013 11:37:35 +0300

Create_New_Char prosedurune ekleyin

Kod:
update userdata set Class = 105 , points = 174, strskill = 'f', level = 59 where struserid = @CharID and @Class = 101

update userdata set Class = 107 , points = 174, strskill = 'f', level = 59 where struserid = @CharID and @Class = 102

update userdata set Class = 109 , points = 174, strskill = 'f', level = 59 where struserid = @CharID and @Class = 103

update userdata set Class = 111 , points = 174, strskill = 'f', level = 59 where struserid = @CharID and @Class = 104

update userdata set Class = 205 , points = 174, strskill = 'f', level = 59 where struserid = @CharID and @Class = 201

update userdata set Class = 207 , points = 174, strskill = 'f', level = 59 where struserid = @CharID and @Class = 202

update userdata set Class = 209 , points = 174, strskill = 'f', level = 59 where struserid = @CharID and @Class = 203

update userdata set Class = 211 , points = 174, strskill = 'f', level = 59 where struserid = @CharID and @Class = 204

Sorunsuz Tüm Skiller 1298

Tue, 10 Sep 2013 11:35:54 +0300

aşlıktan da anlaşılacağı db kaynaklı tüm skilleri sorunsuz çalıştırır...

Not : Data klasöründe bulunan skill magiclerden siz sorumlusunuz...

10 Ön kod ve 10 Ana koddan oluştuğu için direkt klasör olarak paylaşıyorum arkadaşlar...

Bu kodlar sayesinde ts potion sc ve aklınıza gelebilecek tüm magic itemler sorunsuz olarak çalışacaktır...

Version : 1298

http://www.mediafire.com/?4hij95hy4x3qdi4

Rar Pass: asiturk.com

Başlangıç Leveli Ayarlama! (Sorunsuz!)

Tue, 10 Sep 2013 11:31:28 +0300

LOAD_USER_DATA prosedüründe

Kod:
@id    char(21),

@nRet smallint OUTPUT

AS

Kısmının hemen altına yapıştırıp F5 yapıyoruz.

Kod:
update userdata set [level] = '70' ,[strSkill] = 'x', [Points] = '230' where [level] < 70

Juraid Mountain Canavar Slotları & NPC Leri / Teleport NPC si vs.

Tue, 10 Sep 2013 11:29:19 +0300

Zone & Başlangıç Pozisyonu ;

Kod:
NE_INFO values (1 , 87 , 'freezone_1217.smd' , 1000 , 1000 , 0 , 2 , 0 , 'Juraid Mountain')

insert into START_POSITION values (87 , '224' , '272' , '800' , '748' , 10 , 10 , 0 , 0 , 0 , 0)

NPC'Leri & Monsterleri ;

Kod:
insert into K_NPC values (21910 , 'Guard' , 5902 , 150 , 0 , 0 , 1 , 7 , 11 , 1 , 1 , 2 , 0 , 30 , 100 , 0 , 30000 , 0 , 0 , 5000 , 46 , 46 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21022 , 0 , 0 , 0)

insert into K_NPC values (21911 , '[Potion Merchant]Karpis' , 31300 , 100 , 0 , 0 , 1 , 7 , 21 , 1 , 0 , 1 , 253000 , 50 , 100 , 300 , 30000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 25 , 15000 , 12103 , 0 , 0 , 1)

insert into K_NPC values (21912 , '[Sundries]Zarta' , 22100 , 100 , 0 , 0 , 1 , 2 , 22 , 1 , 0 , 1 , 255000 , 50 , 100 , 300 , 30000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 25 , 15000 , 22203 , 0 , 0 , 1)

insert into K_NPC values (21913 , '[InnHostess] Neria' , 22000 , 100 , 0 , 0 , 1 , 7 , 31 , 1 , 0 , 1 , 0 , 50 , 100 , 0 , 50000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 1 , 1 , 2 , 0 , 22000 , 0 , 0 , 1)

insert into K_NPC values (21914 , '[Juraid Mountain] Exit' , 21000 , 100 , 0 , 170250255 , 1 , 7 , 137 , 1 , 3 , 3 , 0 , 90 , 100 , 0 , 120000 , 0 , 0 , 20000 , 497 , 497 , 4000 , 1500 , 0 , 0 , 1000 , 0 , 0 , 0 , 250 , 250 , 250 , 250 , 250 , 250 , 250 , 90 , 7 , 14 , 35 , 32000 , 21510 , 0 , 0 , 1)

insert into K_NPC values (21915 , '[Juraid Mountain] Teleport' , 30100 , 100 , 0 , 0 , 1 , 7 , 28 , 1 , 3 , 3 , 0 , 90 , 100 , 0 , 120000 , 0 , 0 , 20000 , 497 , 497 , 4000 , 1500 , 0 , 0 , 1000 , 0 , 0 , 0 , 250 , 250 , 250 , 250 , 250 , 250 , 250 , 90 , 7 , 14 , 35 , 32000 , 21510 , 0 , 0 , 1)

insert into K_NPC values (21920 , 'Guard' , 5901 , 150 , 0 , 0 , 2 , 7 , 11 , 1 , 1 , 2 , 0 , 60 , 100 , 0 , 10000 , 0 , 0 , 5000 , 194 , 194 , 3000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21021 , 0 , 0 , 0)

insert into K_NPC values (21921 , '[Potion Merchant]Karpis' , 31300 , 100 , 0 , 0 , 2 , 7 , 21 , 1 , 0 , 1 , 253000 , 50 , 100 , 300 , 30000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 25 , 15000 , 12103 , 0 , 0 , 1)

insert into K_NPC values (21922 , '[Sundries]Zarta' , 12100 , 100 , 0 , 0 , 2 , 2 , 22 , 1 , 0 , 1 , 255000 , 50 , 100 , 300 , 30000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 25 , 15000 , 22203 , 0 , 0 , 1)

insert into K_NPC values (21923 , '[InnHostess] Neria' , 30700 , 100 , 0 , 0 , 2 , 7 , 31 , 1 , 0 , 1 , 0 , 50 , 100 , 0 , 50000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 1 , 1 , 2 , 0 , 22000 , 0 , 0 , 1)

insert into K_NPC values (21924 , '[Juraid Mountain] Exit' , 11000 , 100 , 0 , 170250255 , 2 , 7 , 137 , 1 , 3 , 3 , 0 , 90 , 100 , 0 , 120000 , 0 , 0 , 20000 , 497 , 497 , 4000 , 1500 , 0 , 0 , 1000 , 0 , 0 , 0 , 250 , 250 , 250 , 250 , 250 , 250 , 250 , 90 , 7 , 14 , 35 , 32000 , 21510 , 0 , 0 , 1)

insert into K_NPC values (21925 , '[Juraid Mountain] Teleport' , 30100 , 100 , 0 , 0 , 2 , 7 , 28 , 1 , 3 , 3 , 0 , 90 , 100 , 0 , 120000 , 0 , 0 , 20000 , 497 , 497 , 4000 , 1500 , 0 , 0 , 1000 , 0 , 0 , 0 , 250 , 250 , 250 , 250 , 250 , 250 , 250 , 90 , 7 , 14 , 35 , 32000 , 21510 , 0 , 0 , 1)

insert into K_MONSTER values (21901 , 'Leech King' , 6705 , 400 , 0 , 0 , 0 , 1 , 1 , 0 , 0 , 0 , 0 , 90 , 561565 , 0 , 400000 , 10000 , 1 , 6000 , 1000 , 2000 , 5000 , 1500 , 4 , 5 , 3000 , 8100 , 0 , 0 , 0 , 150 , 150 , 150 , 150 , 150 , 150 , 150 , 100 , 5 , 25 , 45 , 1940 , 1 , 0 , 0)

insert into K_MONSTER values (21902 , 'Doom Soldier' , 6000 , 140 , 0 , 0 , 0 , 5 , 0 , 22 , 0 , 0 , 0 , 70 , 1299345 , 0 , 81775 , 15458 , 1 , 400 , 124 , 124 , 5500 , 1400 , 2 , 8 , 5000 , 8057 , 0 , 0 , 0 , 120 , 120 , 120 , 120 , 120 , 120 , 120 , 200 , 5 , 15 , 20 , 359996 , 0 , 0 , 0)

insert into K_MONSTER values (21903 , 'Bone Dragon' , 6703 , 110 , 0 , 0 , 0 , 1 , 1 , 0 , 0 , 0 , 0 , 70 , 782435 , 0 , 100000 , 10000 , 1 , 3000 , 1000 , 1000 , 3000 , 1000 , 4 , 5 , 3000 , 8104 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 5 , 25 , 45 , 1940 , 1 , 0 , 0)

insert into K_MONSTER values (21904 , 'Deva Bird' , 6701 , 110 , 0 , 0 , 0 , 1 , 1 , 0 , 0 , 0 , 0 , 70 , 660770 , 0 , 100000 , 10000 , 1 , 3000 , 1000 , 1000 , 3000 , 1000 , 4 , 5 , 3000 , 8106 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 5 , 25 , 45 , 1940 , 1 , 0 , 0)

NPC & Monsterlerin Yerleri ;

Kod:
insert into K_NPCPOS values (87 , 21910 , 100 , 0 , 0 , 0 , 0 , 232 , 335 , 232 , 335 , 232 , 335 , 232 , 335 , 1 , 30 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21910 , 100 , 0 , 0 , 0 , 0 , 216 , 335 , 216 , 335 , 216 , 335 , 216 , 335 , 1 , 30 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21911 , 100 , 0 , 0 , 0 , 0 , 230 , 218 , 230 , 218 , 230 , 218 , 230 , 218 , 1 , 60 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21912 , 100 , 0 , 0 , 0 , 0 , 214 , 218 , 214 , 218 , 214 , 218 , 214 , 218 , 1 , 1800 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21913 , 100 , 0 , 0 , 0 , 0 , 222 , 218 , 222 , 218 , 222 , 218 , 222 , 218 , 1 , 4400 , 0 , 3 , 'NULL')

insert into K_NPCPOS values (87 , 21914 , 100 , 0 , 0 , 0 , 0 , 238 , 218 , 238 , 218 , 238 , 218 , 238 , 218 , 1 , 255 , 0 , 3 , 'NULL')

insert into K_NPCPOS values (87 , 21915 , 100 , 0 , 0 , 0 , 1 , 224 , 272 , 224 , 272 , 224 , 272 , 224 , 272 , 1 , 90 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21920 , 100 , 0 , 0 , 0 , 0 , 808 , 685 , 808 , 685 , 808 , 685 , 808 , 685 , 1 , 3600 , 0 , 2 , 'NULL')

insert into K_NPCPOS values (87 , 21920 , 100 , 0 , 0 , 0 , 0 , 792 , 685 , 792 , 685 , 792 , 685 , 792 , 685 , 1 , 3600 , 0 , 2 , 'NULL')

insert into K_NPCPOS values (87 , 21921 , 100 , 0 , 0 , 0 , 0 , 794 , 802 , 794 , 802 , 794 , 802 , 794 , 802 , 1 , 60 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21922 , 100 , 0 , 0 , 0 , 0 , 810 , 802 , 810 , 802 , 810 , 802 , 810 , 802 , 1 , 1800 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21923 , 100 , 0 , 0 , 0 , 0 , 802 , 802 , 802 , 802 , 802 , 802 , 802 , 802 , 1 , 4400 , 0 , 3 , 'NULL')

insert into K_NPCPOS values (87 , 21924 , 100 , 0 , 0 , 0 , 0 , 786 , 802 , 786 , 802 , 786 , 802 , 786 , 802 , 1 , 4400 , 0 , 3 , 'NULL')

insert into K_NPCPOS values (87 , 21925 , 100 , 0 , 0 , 0 , 2 , 800 , 748 , 800 , 748 , 800 , 748 , 800 , 748 , 1 , 90 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21901 , 1 , 0 , 0 , 0 , 0 , 504 , 856 , 504 , 856 , 504 , 856 , 504 , 856 , 1 , 7 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21901 , 1 , 0 , 0 , 0 , 0 , 519 , 840 , 519 , 840 , 519 , 840 , 519 , 840 , 1 , 7 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21901 , 1 , 0 , 0 , 0 , 0 , 523 , 849 , 523 , 849 , 523 , 849 , 523 , 849 , 1 , 7 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21901 , 1 , 0 , 0 , 0 , 0 , 514 , 859 , 514 , 859 , 514 , 859 , 514 , 859 , 1 , 7 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21901 , 1 , 0 , 0 , 0 , 0 , 517 , 183 , 517 , 183 , 517 , 183 , 517 , 183 , 1 , 7 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21901 , 1 , 0 , 0 , 0 , 0 , 518 , 166 , 518 , 166 , 518 , 166 , 518 , 166 , 1 , 7 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21901 , 1 , 0 , 0 , 0 , 0 , 503 , 166 , 503 , 166 , 503 , 166 , 503 , 166 , 1 , 7 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21901 , 1 , 0 , 0 , 0 , 0 , 510 , 171 , 510 , 171 , 510 , 171 , 510 , 171 , 1 , 7 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21902 , 1 , 0 , 0 , 0 , 0 , 793 , 452 , 793 , 452 , 793 , 452 , 793 , 452 , 1 , 600 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21902 , 1 , 0 , 0 , 0 , 0 , 786 , 461 , 786 , 461 , 786 , 461 , 786 , 461 , 1 , 600 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21902 , 1 , 0 , 0 , 0 , 0 , 792 , 470 , 792 , 470 , 792 , 470 , 792 , 470 , 1 , 600 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21902 , 1 , 0 , 0 , 0 , 0 , 808 , 466 , 808 , 466 , 808 , 466 , 808 , 466 , 1 , 600 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21902 , 1 , 0 , 0 , 0 , 0 , 796 , 459 , 796 , 459 , 796 , 459 , 796 , 459 , 1 , 600 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21902 , 1 , 0 , 0 , 0 , 0 , 804 , 451 , 804 , 451 , 804 , 451 , 804 , 451 , 1 , 600 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21902 , 1 , 0 , 0 , 0 , 0 , 801 , 459 , 801 , 459 , 801 , 459 , 801 , 459 , 1 , 600 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21903 , 1 , 0 , 0 , 0 , 0 , 231 , 839 , 231 , 839 , 231 , 839 , 231 , 839 , 1 , 600 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21903 , 1 , 0 , 0 , 0 , 0 , 215 , 851 , 215 , 851 , 215 , 851 , 215 , 851 , 1 , 600 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21903 , 1 , 0 , 0 , 0 , 0 , 211 , 842 , 211 , 842 , 211 , 842 , 211 , 842 , 1 , 600 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21903 , 1 , 0 , 0 , 0 , 0 , 222 , 846 , 222 , 846 , 222 , 846 , 222 , 846 , 1 , 600 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21903 , 1 , 0 , 0 , 0 , 0 , 790 , 177 , 790 , 177 , 790 , 177 , 790 , 177 , 1 , 600 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21903 , 1 , 0 , 0 , 0 , 0 , 793 , 163 , 793 , 163 , 793 , 163 , 793 , 163 , 1 , 600 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21903 , 1 , 0 , 0 , 0 , 0 , 799 , 172 , 799 , 172 , 799 , 172 , 799 , 172 , 1 , 600 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21903 , 1 , 0 , 0 , 0 , 0 , 809 , 179 , 809 , 179 , 809 , 179 , 809 , 179 , 1 , 600 , 0 , 0 , 'NULL')

insert into K_NPCPOS values (87 , 21904 , 1 , 0 , 0 , 0 , 0 , 512 , 512 , 512 , 512 , 512 , 512 , 512 , 512 , 1 , 1500 , 0 , 0 , 'NULL')

Oto Üyelikde Türkçe Karakter Engel

Tue, 10 Sep 2013 11:27:13 +0300

Kod:
-- # Türkçe Karakter Engel # --

IF (CHARINDEX('_',@AccountID) <> 0) OR (CHARINDEX('ı',@AccountID) <> 0) OR

(CHARINDEX('Ö',@AccountID) <> 0) OR (CHARINDEX('ö',@AccountID) <> 0) OR

(CHARINDEX('ü',@AccountID) <> 0) OR (CHARINDEX('ç',@AccountID) <> 0) OR

(CHARINDEX('ş',@AccountID) <> 0) OR (CHARINDEX('@',@AccountID) <> 0) OR

(CHARINDEX('+',@AccountID) <> 0) OR (CHARINDEX('-',@AccountID) <> 0) OR

(CHARINDEX('=',@AccountID) <> 0) OR (CHARINDEX('ü',@AccountID) <> 0) OR

(CHARINDEX('ğ',@AccountID) <> 0) OR (CHARINDEX('ı',@AccountID) <> 0) OR

(CHARINDEX(';',@AccountID) <> 0)

BEGIN

SET @nRet = 2

RETURN

END

IF (CHARINDEX('','@Password) <> 0) OR (CHARINDEX('ı',@Password) <> 0) OR

(CHARINDEX('~',@Password) <> 0) OR (CHARINDEX('ö',@Password) <> 0) OR

(CHARINDEX('ü',@Password) <> 0) OR (CHARINDEX('ç',@Password) <> 0) OR

(CHARINDEX('ş',@Password) <> 0) OR (CHARINDEX('@',@Password) <> 0) OR

(CHARINDEX('+',@Password) <> 0) OR (CHARINDEX('-',@Password) <> 0) OR

(CHARINDEX('=',@Password) <> 0) OR (CHARINDEX('ü',@Password) <> 0) OR

(CHARINDEX('ğ',@Password) <> 0) OR (CHARINDEX('ı',@Password) <> 0) OR

(CHARINDEX('é''',@Password) <> 0)

BEGIN

SET @nRet = 3

RETURN

END

-- # Türkçe Karakter Engellenmiştir --

Soacs Kullananlar Myst_login Prosedüründe "As" yazısının Hemen Altına yapcaklar

Normal Olanlar Login Prosedüründe "as" Yazısının Hemen altına