tem a mesma funcionalidade deste [Only registered and activated users can see links. Click Here To Register...]
Código:
DECLARE
@Conta varchar(10),
@contador int
select @contador = 0
DECLARE LISTA CURSOR LOCAL FOR
SELECT memb___id FROM MuOnline2.dbo.MEMB_INFO
OPEN LISTA
FETCH NEXT FROM LISTA INTO @Conta
WHILE @@FETCH_STATUS = 0
begin
if (SELECT migrado FROM MuOnline2.dbo.MEMB_INFO where memb___id=@Conta) = 0
begin
select @contador = @contador + 1
--MIGRA CONTA
INSERT INTO MuOnline.dbo.MEMB_INFO (memb___id,memb__pwd,memb_name,mail_addr,fpas_ques,fpas_answ,sno__numb,bloc_code,ctl1_code,post_code,addr_info,tel__numb,phon_numb,addr_deta,mail_chek,cash,vip,datebegin,dateend,dateEndInteger) SELECT memb___id,memb__pwd,memb_name,mail_addr,fpas_ques,fpas_answ,sno__numb,bloc_code,ctl1_code,post_code,addr_info,tel__numb,phon_numb,addr_deta,mail_chek,cash,vip,datebegin,dateend,dateEndInteger from MuOnline2.dbo.MEMB_INFO where memb___id = @Conta
--CHARACTER
INSERT INTO MuOnline.dbo.AccountCharacter (Id,GameID1,GameID2,GameID3,GameID4,GameID5,GameIDC,MoveCnt) SELECT Id,GameID1,GameID2,GameID3,GameID4,GameID5,GameIDC,MoveCnt FROM MuOnline2.dbo.AccountCharacter WHERE Id = @Conta
INSERT INTO MuOnline.dbo.Character(AccountID, Name, cLevel, LevelUpPoint, Class, Experience, Strength, Dexterity, Vitality, Energy, Inventory, MagicList, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime, MDate, LDate, CtlCode, DbVersion, Quest, Leadership, ChatLimitTime, FruitPoint, Resets) SELECT AccountID, Name, cLevel, LevelUpPoint, Class, Experience, Strength, Dexterity, Vitality, Energy, Inventory, MagicList, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime, MDate, LDate, CtlCode, DbVersion, Quest, Leadership, ChatLimitTime, FruitPoint, Resets from MuOnline2.dbo.character where AccountID = @Conta
--MIGRAR BAUS
INSERT INTO MuOnline.dbo.warehouse(AccountID, Items, Money, EndUseDate, DbVersion, pw) SELECT AccountID, Items, Money, EndUseDate, DbVersion, pw from [MuOnline2].[dbo].[warehouse] where AccountID = @Conta
--MIGRAR BAUS EXTRAS
INSERT INTO MuOnline.dbo.Extwarehouse(VaultID, AccountID, Items, EndUseDate, DbVersion, Money, pw) SELECT VaultID, AccountID, Items, EndUseDate, DbVersion, Money, pw from MuOnline2.dbo.Extwarehouse where AccountID = @Conta
UPDATE MuOnline2.dbo.MEMB_INFO SET migrado = 1 WHERE memb___id = @Conta
end
FETCH NEXT FROM LISTA INTO @Conta
end
CLOSE LISTA
DEALLOCATE LISTA
print @contador