Character Login

[Dark2482]

Someone know how i can put Bounty if u make a New Character then ur lv 1 with 0 Bounty i Want like 2000 someone knows where i can do that?

[MentaL]

[faytman]

The Search button is your best friend -.-...

[Dark2482]

The Answer button is my best friend -.-...

[faytman]

The Answer button is my best friend -.-...

stop spamming and use the freakin Search button

[wesman2232]

I have solved this about 3 -4 times already and there is tuts use the search button

[XZeenon]

go to the gunz database then go to stored procedures under Programmability then you should see the table that says dbo.spInsertChar right click then hit modify then scroll down till you see something like this..

INSERT INTO Character (AID, Name, CharNum, Level, Sex, Hair, Face, XP, BP, FR, CR, ER, WR, 
         		           GameCount, KillCount, DeathCount, RegDate, PlayTime, DeleteFlag)
Values (@AID, @Name, @CharNum, 1, @Sex, @Hair, @Face, 0, 0, 0, 0, 0, 0, 0, 0, 0, GETDATE(), 0, 0)
IF 0 <> @@ERROR BEGIN
	ROLLBACK TRAN
	RETURN (-1)
END

From there if you see after "@Face," there is.. "0, 0, 0, 0, 0, 0, 0, 0, 0," I think the bounty is the second last one so you would change it to.. "0, 0, 0, 0, 0, 0, 0, 2000, 0,"
Then execute the thing and it will save and if it is the wrong one try the second first one, but I think its the second last one anyway good luck with your server, and no problem.

Btw people that say use the search button do not know the asnwer and they are just trying to look smart or just don't feel like explaining it, and yes it's very annoying, sometimes you might search for a thread then you click it and it says the requested URL may not be found, some threads have been deleted. btw people STOP DOING THAT.
And no offence people, but give the guy a break.

[wesman2232]

go to the gunz database then go to stored procedures under Programmability then you should see the table that says dbo.spInsertChar right click then hit modify then scroll down till you see something like this..

INSERT INTO Character (AID, Name, CharNum, Level, Sex, Hair, Face, XP, BP, FR, CR, ER, WR, 
                            GameCount, KillCount, DeathCount, RegDate, PlayTime, DeleteFlag)
Values (@AID, @Name, @CharNum, 1, @Sex, @Hair, @Face, 0, 0, 0, 0, 0, 0, 0, 0, 0, GETDATE(), 0, 0)
IF 0 <> @@ERROR BEGIN
    ROLLBACK TRAN
    RETURN (-1)
END

From there if you see after "@Face," there is.. "0, 0, 0, 0, 0, 0, 0, 0, 0," I think the bounty is the second last one so you would change it to.. "0, 0, 0, 0, 0, 0, 0, 2000, 0,"
Then execute the thing and it will save and if it is the wrong one try the second first one, but I think its the second last one anyway good luck with your server, and no problem.

Btw people that say use the search button do not know the asnwer and they are just trying to look smart or just don't feel like explaining it, and yes it's very annoying, sometimes you might search for a thread then you click it and it says the requested URL may not be found, some threads have been deleted. btw people STOP DOING THAT.
And no offence people, but give the guy a break.

I know but I have said it about 3 - 4 times and it is in a tutorial im just telling them to actually search really good before posting.

[Dark2482]

Thank u man works.:)

[XZeenon]

Np, I know... I'm the best P:

[katsumi]

thanks xeenon