Hesap Deiştirme Proc
Sifre Deistirme Proc
Hesap Ve Kullanici Silme
- Kod:
--JackaL/Ko-cuce.com 2008
--Kullanimi= AccChange 'hesap adi' , 'yeni hesap adi'
CREATE Procedure AccChange
@OldAcc varchar(50),
@NewAcc varchar(50)
as
update tb_user set straccountid = @NewAcc where straccountid = @OldAcc
update account_char set straccountid = @NewAcc where straccountid = @OldAcc
print 'Degistirilen Hesap : ' + @OldAcc
print 'Yeni Hesabiniz : ' + @NewAcc
print 'Coded By Jackal'
GO
Sifre Deistirme Proc
- Kod:
--JackaL/Ko-cuce.com 2008
--Kullanimi= Passchange 'hesap adi' , 'yeni sifre'
CREATE Procedure Passchange
@Account varchar(50),
@Passwd char(21)
as
update tb_user set strpasswd = @passwd where straccountid = @Account
print 'Degistirilen Hesap : ' + @account
print 'Yeni Sifreniz : ' + @passwd
print 'Coded By Jackal'
GO
Hesap Ve Kullanici Silme
- Kod:
--JackaL ko -cuce 2008
CREATE Procedure Hesapsil
--Kullanim hesapsil 'hesap adi' , 'Karakter Adi'
@Account varchar(50),
@User char(21)
as
delete from tb_user where straccountid = @Account
delete from account_char where straccountid = @Account
delete from userdata where struserid = @User
delete from warehouse where straccountid = @Account
print 'Silinen Hesap : ' + @account
print 'Coded By Jackal'
GO