• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

unlock all maps on ep8 to automatically

Status
Not open for further replies.
Newbie Spellweaver
Joined
Jan 22, 2009
Messages
73
Reaction score
4
Does anyone know how to unlock all maps on ep8 to automatically create the Char ?
 
Banned
Banned
Joined
Aug 2, 2011
Messages
1,427
Reaction score
979
server01 > programability > Stored Procesures > cabal_sp_newchar

Code:
/*update cabal_character_table set style = style + 152 , WarpBField = 4095 , MapsBField = 4095 where CharacterIdx = [USER=1333352388]Character[/USER]idx*/
update cabal_character_table set Reputation = 0 , PNT = 0 where CharacterIdx = [USER=1333352388]Character[/USER]idx
 
Upvote 0
Newbie Spellweaver
Joined
Jan 22, 2009
Messages
73
Reaction score
4
server01 > programability > Stored Procesures > cabal_sp_newchar

Code:
/*update cabal_character_table set style = style + 152 , WarpBField = 4095 , MapsBField = 4095 where CharacterIdx = [USER=1333352388]Character[/USER]idx*/
update cabal_character_table set Reputation = 0 , PNT = 0 where CharacterIdx = [USER=1333352388]Character[/USER]idx

Erro:
Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@Characteridx".

Have to put the Account ID ? "@Characteridx".
 
Upvote 0
Banned
Banned
Joined
Aug 2, 2011
Messages
1,427
Reaction score
979
/*update cabal_character_table set style = style + 152 , WarpBField = 4095 , MapsBField = 4095 ,
 
Upvote 0
Status
Not open for further replies.
Back
Top