DataBase Count Idx

[LocaSimon]

i've deleted all of my Accounts and Charcters.. And The Chars Acc's in the Count Tables.. and still My Idx's Are 17000+ ... What Can We Do? i saw once a Topic about it here i tried to search for it but i cant find it :\...
Thank You

[MentaL]

[Alphakilo23]

The CharacterIdx is generated based on the login.cabal_auth_table.UserNum
If I recall it right it's (UserNum * 8) + Character-Slot.

The UserNum is an auto-incrementing ID, so even if you've deleted everything in the table it will not be reseted. You have two options:

1. DROP and CREATE the table (which is the clean solution, because all the data get's wiped off the table);
2. Run this script:
   

   USE [account]
   DBCC CHECKIDENT('cabal_auth_table', RESEED, 1) ;

   What it'll do is to just reset the auto-increment, so it'll start with '1' again. BUT if there are entries left in the table (f.ex. UserNum 1337) the 1337th user will find out that he can't register. Because the UserNum is the identity row and the primary key of the table, thus has to be unique.

TL;DR:
DROP and CREATE the table!

[LocaSimon]

i Runed the Script but still first char i make .. IDX 174000 :\

[PunkS7yle]

Dont run it, DROP and then CREATE the table. That will wipe it clean.

[m0ose]

-this will reset all data inside cabal_character_count_table

use account
TRUNCATE TABLE cabal_character_count_table

also you can look inside you database for:

_INIT_ACCOUNTDB
-INIT_GAMEDB

it will wipe your database clean

If you cannot find those script, look for Christmas box of chumpy.