Couple of weird bugs

[kochon]

Ok I'm running in a couple of damned bugs and I'm about to go insane.

First, when I switch my matchserver to clan mode, i get random 999 pings. I'm not trying to run multiple servers, I just switch it to clan mode. It seems to occur when someone leaves a game, because we played like 10 clan matches in a row without quitting and all worked fine. Then we went into the expert channel to duel and the mess started. It also happened when we all left during a clanmatch then made another one. I dont know what the shit is wrong about that stuff.

server.ini :

[DB]
DNS="GunzDB"
USERNAME="KOCHON-PC\SQLEXPRESS"
PASSWORD="my password"

[SERVER]
MAXUSER=500
SERVERID=1
SERVERNAME="GunZone"
FREELOGINIP=""
KEEPERIP="MY WAN IP"
MONITORIP="MY WAN IP"
MONITORPORT=9000
MODE="clan"
COUNTRY="BRZ"
LANGUAGE="BRZ"
USETICKET="0"

[LANGUAGE]
LANG_TYPE="eng"

[LOCALE]
DBAgentPort=5100
DBAgentIP=127.0.0.1

[FILTER]
USE="0" 
ACCEPT_INVALID_IP="1"

[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="0"
USE_EVENT="0"
USE_FILECRC="0"
USE_MD5="0"

And there is also a weird glitch involving my DB. I changed the starting items because I reorganized my zitem with new numbers, and I updated the dbo.spInsertChar to the new item codes, then I started getting blank entries in dbo.Character when someone deletes his character and I get an error when I try to delete it. I must go to dbo.CharacterItem to delete the char's items then I can delete the character" SS:

.

Third and last problem: When I am in the process of creating my character the items do not display, when I click create and watch it in the characters selection screen, it's fine. Maybe client-sided, I don't know.

Please provide me with some useful protips you guys!

[MentaL]

[bounty-hunter]

if its homehosted then your internet might be playing up

[Linear88]

It's because of the check constraint.

[bunny1995]

remake GunzDB and Use Rev 6

[kochon]

if its homehosted then your internet might be playing up

Could you be more specific? it is homehosted, I'll buy a VPN or something when its ready.

It's because of the check constraint.

How to fix maybe?

remake GunzDB and Use Rev 6

Rev6 fails me, I get 999 ping with both server even with one of the two being empty. And my DB is fine. I won't dump all my characters, accounts and stuff just to start from scratch. I'd rather fix it.

Oh and please guys when you answer specify which issue you're helping with k thanks :P

[kochon]

bump
[useless text because of the damn character limit]