How to Change your name to [ADMIN] / [GM]

[steven070]

WHEN I CHANGE MY NAME TO [ADMIN]
In SQL use this (runt he queries on gamedb):

select * from cabal_character_table where name='<your char name>'

Note the CharacterIdx. Now use:

update cabal_character_table set name='[admin]<your char name>' where characteridx=?

Change ? to your character idx.

MY CHAR IDX DONT WORK! it shows nothing. how do i fix this?

[MentaL]

[Yamachi]

How can your char idx not work? I don't understand... What are the exact SQL queries you are executing?

[m0ose]

@Yama
this is the query he use>
select * from cabal_character_table where name='<your char name>'
update cabal_character_table set name='[admin]<your char name>' where characteridx=?

@steven
my suggestion>
why not edit the ign directly? open character table and edit the name to anything you like.

[Yamachi]

m0ose, that is a query template.

[SheenBR]

well, its kinda obvius what to do...

select * from cabal_character_table where name='<your char name>'
update cabal_character_table set name='[admin]<your char name>' where characteridx=?

you see: "your char name", then you should edit with your char name o.o
with the results of the 1st query you'll be able to get the character index, whose number you'll need to pass to the 2nd query, the update one, which will update your character's name.

assuming a "blah" character:
select * from cabal_character_table where name='blah'
assuming "result" is the value of the IDX row, returned from the query above:

update cabal_character_table set name='[admin]blah' where characteridx=result

done.