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:

1. Xóa Trigger TheHe trong Memb_STAT đi
2. 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:

1. Attack DB mới nếu như xóa hết cả tài khoản
2. 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?