Db Sql Format

[locobans]

How do I raise the Stat limit?

Stat limit

Hex HG server.
goto the address
0004f427
0004f477
0004f4c7
0004f517
0004f567
0004f5b7
00016fed
0001701d
0001704d
0001707d
000170ad
000170dd

which is c8, and change the string which is some funny letter to the stat limit you want (for players, you will be able to go to any stat, if your a gm.) Remember, again, file size cant be the same.

Then to get rid of the pop up box, you need hiew
goto this address for the box
.0040c682
.0040c697
.0040c6ac
.0040c6c0
.0040c6d5
.0040c6ea

for ok button.
.0045d1e7
.0045d202
.0045d21c
.0045d237
.0045d252
.0045d26c

for the txt telling you u cant raise your stats
.0045d315
.0045d335
.0045d353
.0045d371
.0045d38e
.0045d3ae

There you have it

That didint worked, since those address werent pointing to a c8 value :unsure:

[CDWriter]

lol thats from the 2.20 HG server info ...they dont use that same formula any more or the exp ban eather....

[locobans]

[12:06:02 AM] phoenix >>: ok well let me just tell you what the
              problem was in our mysql
[12:06:04 AM] phoenix >>: and maybe
[12:06:08 AM] phoenix >>: ud be able to find the same thing
[12:06:10 AM] phoenix >>: with mssql
[12:06:15 AM] phoenix >>: because im not sure about all the mssql
              stuff
[12:06:24 AM] phoenix >>: anyways in mysql
[12:06:28 AM] Locobans - A: ok
[12:06:36 AM] phoenix >>: we had level working fine
[12:06:39 AM] phoenix >>: for higher then 180
[12:06:40 AM] Locobans - A: me 2
[12:06:44 AM] phoenix >>: and we ran into the same thing
[12:06:45 AM] phoenix >>: wit stats
[12:06:48 AM] phoenix >>: now the problem we found was
[12:06:52 AM] phoenix >>: level was set to smallint
[12:06:54 AM] phoenix >>: but stats
[12:06:58 AM] phoenix >>: were set as
[12:07:01 AM] phoenix >>: tinyint
[12:07:17 AM] phoenix >>: which wwas messing up us having stats where
              we wanted
[12:07:22 AM] phoenix >>: anda lso in the login
[12:07:27 AM] phoenix >>: it was sending
[12:07:30 AM] phoenix >>: the stat levels
[12:07:35 AM] phoenix >>: as a tiny int to the database
[12:07:47 AM] phoenix >>: so what we had to do was cange the
              properties in the db so it was also a smallint
[12:07:48 AM] phoenix >>: like level
[12:07:53 AM] Locobans - A: ohhh...
[12:07:55 AM] phoenix >>: and also change hte login so it sent
[12:08:00 AM] phoenix >>: a smallint
[12:08:03 AM] phoenix >>: to the db instead of a tiny int
[12:08:15 AM] phoenix >>: thats the best i can tell u
[12:08:19 AM] phoenix >>: i dont know anyhting about mssql
[12:08:21 AM] phoenix >>: and rarely know mysql
[12:08:28 AM] Locobans - A: lol
[12:08:28 AM] Locobans - A: ok

HBMT is runing over 500 stats in SQL (they use MYSQL tho) they was having same problems as i am...

[Sparda]

Lots of people are being spoiled and it looks like they don't know the difference between a real server and a server that has been programmed by a helbreath-fan team...

[locobans]

Lots of people are being spoiled and it looks like they don't know the difference between a real server and a server that has been programmed by a helbreath-fan team...

LOL well i aint no guru, but i ve learn fast...started hb 2 years ago...played 1st priv serv then started my own...most of people remember it Hb-ZioN...since...it was popular few GMs of hbint/usa emaield us...about hbint/usa players leaving their servs and joining Hb-ZioN in mass-groups but...true...this is my first time actually runing or trying or messing with real files ^_^

I aint no coder, i can read some of the codes of the source, and mess around sometimes get cool results, but most of the time i just mess them up, tho thats my 1st step of learning (try it out), i dont qualify myself as coder, that i have a few question and trying to change some stuff on real files, its to me, normally...may i say....sorry if i caused any troubles, here...and gotta go to sleep


C ya
pwnt u easy

[molo]

ok i have every thing but this file i dont have in my SQL\data folder ca any one help to get it ?

mainlogin.sql(txt) other are missing please...

[Stik]

Here's mainlog.sql with the extra bits(shopid keycode)added to it

[jmh]

thanks

[Aryes]

... the Gibson Upgrading ...

Gibson? The actor? :huh:

Oh, nvm, I think you mean gizon...

Anyways, just joking

[wenmox]

Please don't ever post such a long post like that again lol. I'll help you nef in return u don't do that again

Right have you run the sql code into MS SQL?
If you have follow this:

open 'mainlogin' database, open 'account_t' in design mode (right click > design), add a new field called iShopID, datatype NCHAR. That should fix your account_t table.

open 'ws1' database, open 'character_t' in design mode, add a new field called iGizoneItemUpgradeLeft, datatype INT. That should fix your character_t table hopefully. That way you can login and create characters using the client.

Upgrade does work. I've upgrade my dark knight flameberge into dark knight temple +15

btw, has someone been able to use /enableadmincreateitem 147258 to create an item yet? there seems to be no /createitem command in the hgserver and all i've been doing is entering items manually and i hate doing that process....

Can someone tell me how to make an account pls im stuck here. I tried doing what CDWriter said but just get acc doesnt exist.

[jmh]

use the old 2.02 account maker

[wenmox]

use the old 2.02 account maker

where?download

[jmh]

<a href='http://helbreath.pri.ee/AccMaker.rar' target='_blank'>http://helbreath.pri.ee/AccMaker.rar</a>

[wenmox]

<a href='http://helbreath.pri.ee/AccMaker.rar' target='_blank'>http://helbreath.pri.ee/AccMaker.rar</a>

This file con't create account.
try

[jmh]

yes it does, just change the ip