How can i remove 300 free stat points for new characters?
От тук ли да я изтегля я пробвам тази MSE. http://www.microsoft.com/security_essentials/
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
/****** Object: Trigger dbo.Restrict_IntLUP Script Date: 21.6.2009 19:47:35 ******/
ALTER TRIGGER [Restrict_IntLUP] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].LevelUpPoint=0 From Inserted
Where [Character].accountid=inserted.accountid
and [Character].name=inserted.name
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Къде съм споменал, че имам проблеми с нелегалния уиндоус бе баламурници? Само пишете без да знаете. Но иначе искрено ме засмяхте с някои от коментарите.
@Richjis
here is the sql query =)
Code:SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO /****** Object: Trigger dbo.Restrict_IntLUP Script Date: 21.6.2009 19:47:35 ******/ ALTER TRIGGER [Restrict_IntLUP] ON [dbo].[Character] after Insert as Update [Character] set [Character].LevelUpPoint=0 From Inserted Where [Character].accountid=inserted.accountid and [Character].name=inserted.name GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO
it will set the starter points to 0 , Update [Character] set [Character].LevelUpPoint=0 From Inserted
change the "0" to anything u want good lucky
u must have other character, to be able to create summoner.Thanks this worked.
But i think i found a bug. When you make a new account you can login, then logout without creating character and then login again and you can create summoner, or you can create character and delete it and there will be option to create summoner.
Идеята ми беше следната.
Вие се оплаквате, че имате бъгнат Windows.
Вие все сте недоволни от нещата, които ви се предлагат, но не си давате сметка, че вие не сте платили за това нещо, а на всичкото отгоре искате и всичко да си ви върви без проблем.
Да, ама не.