Xin hướng dẫn chạy Query NBB bị Lỗi Tài khoản bị tạm khóa

[chyozh]

Mình chạy tất cả các query đều ổn nhưng đến đoạn này thì nó báo lỗi Tài khoản bị tạm khóa


Xin các PRO hướng dẫn hoặc gợi ý một phần nào đó giúp em thông não phát :((

bó tay chịu trói rồi


IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='bank' )
BEGIN
Alter TABLE MEMB_INFO ADD bank bigint NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.bank'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.bank' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='vpoint' )
BEGIN
Alter TABLE MEMB_INFO ADD vpoint bigint NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.vpoint'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.vpoint' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='gcoin' )
BEGIN
Alter TABLE MEMB_INFO ADD gcoin bigint NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.gcoin'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.gcoin' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='gcoin_km' )
BEGIN
Alter TABLE MEMB_INFO ADD gcoin_km bigint NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.gcoin_km'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.gcoin_km' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='gcoin_km_day' )
BEGIN
Alter TABLE MEMB_INFO ADD gcoin_km_day bigint NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.gcoin_km_day'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.gcoin_km_day' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='memb__pwd2' )
BEGIN
Alter TABLE MEMB_INFO ADD memb__pwd2 varchar(32)
PRINT 'ADDED Column MEMB_INFO.memb__pwd2'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.memb__pwd2' END
Alter TABLE MEMB_INFO Alter COLUMN memb__pwd2 varchar(32)

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='memb__pwdmd5' )
BEGIN
Alter TABLE MEMB_INFO ADD memb__pwdmd5 varchar(32)
PRINT 'ADDED Column MEMB_INFO.memb__pwdmd5'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.memb__pwdmd5' END
Alter TABLE MEMB_INFO Alter COLUMN memb__pwdmd5 varchar(32)

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='pass2' )
BEGIN
Alter TABLE MEMB_INFO ADD pass2 varchar(32)
PRINT 'ADDED Column MEMB_INFO.pass2'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.pass2' END
Alter TABLE MEMB_INFO Alter COLUMN pass2 varchar(32)

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='jewel_chao' )
BEGIN
Alter TABLE MEMB_INFO ADD jewel_chao int NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.jewel_chao'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.jewel_chao' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='jewel_chao_day' )
BEGIN
Alter TABLE MEMB_INFO ADD jewel_chao_day int NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.jewel_chao_day'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.jewel_chao_day' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='jewel_cre' )
BEGIN
Alter TABLE MEMB_INFO ADD jewel_cre int NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.jewel_cre'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.jewel_cre' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='jewel_blue' )
BEGIN
Alter TABLE MEMB_INFO ADD jewel_blue int NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.jewel_blue'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.jewel_blue' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='passran' )
BEGIN
Alter TABLE MEMB_INFO ADD passran tinyint NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.passran'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.passran' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='checklogin' )
BEGIN
Alter TABLE MEMB_INFO ADD checklogin varchar(50) null
PRINT 'ADDED Column MEMB_INFO.checklogin'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.checklogin' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='time_checksms' )
BEGIN
Alter TABLE MEMB_INFO ADD time_checksms int NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.time_checksms'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.time_checksms' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='checksms_status' )
BEGIN
Alter TABLE MEMB_INFO ADD checksms_status tinyint NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.checksms_status'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.checksms_status' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='admin_block' )
BEGIN
Alter TABLE MEMB_INFO ADD admin_block tinyint NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.admin_block'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.admin_block' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='time_reg' )
BEGIN
Alter TABLE MEMB_INFO ADD time_reg datetime NOT NULL DEFAULT GetDate()
PRINT 'ADDED Column MEMB_INFO.time_reg'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.time_reg' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='ip' )
BEGIN
Alter TABLE MEMB_INFO ADD ip varchar(20) NULL
PRINT 'ADDED Column MEMB_INFO.ip'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.ip' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='thehe' )
BEGIN
Alter TABLE MEMB_INFO ADD thehe tinyint NOT NULL DEFAULT 1
PRINT 'ADDED Column MEMB_INFO.thehe'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.thehe' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='BlockTime' )
BEGIN
Alter TABLE MEMB_INFO ADD BlockTime int NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.BlockTime'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.BlockTime' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='BlockSlg' )
BEGIN
Alter TABLE MEMB_INFO ADD BlockSlg int NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.BlockSlg'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.BlockSlg' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='IPBonusPoint' )
BEGIN
Alter TABLE MEMB_INFO ADD IPBonusPoint int NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.IPBonusPoint'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.IPBonusPoint' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='nbb_pl' )
BEGIN
Alter TABLE MEMB_INFO ADD nbb_pl int NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.nbb_pl'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.nbb_pl' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='jewel_heart' )
BEGIN
Alter TABLE MEMB_INFO ADD jewel_heart int NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.jewel_heart'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.jewel_heart' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='WCoin' )
BEGIN
Alter TABLE MEMB_INFO ADD WCoin int NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.WCoin'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.WCoin' END

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='MEMB_INFO' AND COLUMN_NAME='SCFVipMoney' )
BEGIN
Alter TABLE MEMB_INFO ADD SCFVipMoney int NOT NULL DEFAULT 0
PRINT 'ADDED Column MEMB_INFO.SCFVipMoney'
END
ELSE BEGIN PRINT 'Exist Column MEMB_INFO.SCFVipMoney' END

[ziziboon]

bị khi vào game hay là đăng nhập web hả bạn

[lequangvu]

1 Câu hỏi khó hiểu, 30 charrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr

[The Gamer]

bị khi vào game hay là đăng nhập web hả bạn

tk tạm khóa thì 99% là khi đăng nhập game

[ziziboon]

Có các cách sau:

Xóa Trigger TheHe trong Memb_STAT đi
Trường hợp này xảy ra khi các bạn xóa hết dữ liệu trong database alphatest đi và open vẫn dùng lại database đó:


Khắc phục như sau:

Attack DB mới nếu như xóa hết cả tài khoản
Nếu không xóa tài khoản mà chỉ xóa nhân vật



Các bạn chạy sv như bình thường.
Vào game rồi tạo 1 nhân vật sau đó thoát ra.
vào lại tiếp --> tài khoản bị tạm khóa.
oke vậy là thành công rồi.
Tiếp theo là tắt SV đi rồi đợi Open bật là được

[tanlockgvn]

đang chạy query báo lỗi tk bị tạm khóa? phải câu hỏi vậy ko?