Db Sql Format

Discussion about Helbreath Server Files.
Post Reply
Stik
Member
Posts: 135
Joined: Thu Jun 10, 2004 4:59 pm

Post by Stik »

Ok guys, sorry, i went to bed right after posting B4 :rolleyes:
I think the DC problem is the wlserver and log server are trying to share the same ntrnal port. I changed my cfg,s as shown here and i can now change map servers without DCing,but it does take a few seconds to connect to the new server for some reason,that might be a comunication problem with mssql.
Image

try it and let me know.
Top
RageIlluminati
Outpost bitch
Posts: 559
Joined: Wed Mar 30, 2005 6:45 am

Post by RageIlluminati »

yeahh.. this worked well.. don't get anymore DC.. ty stik...
<img src='http://helbreath.pri.ee/userbars/hbest-gamemaster2.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/hbsoccer-owner.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/scorpa-rider.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/logout-master.jpg' border='0' alt='user posted image' /> <br>.<br>................................Ego sum Rage, flagellum Dei!<br><br>The problem with America is stupidity. I'm not saying there should be a capital punishment for stupidity, but why don't we just take the safety labels off of everything and let the problem solve itself? (bash.org)
Top
nef
Regular
Posts: 59
Joined: Sun May 22, 2005 3:34 am

Post by nef »

well, here i just change my gateserver to the otherone and it was done, but nice one stik
anyone have a clue about why our heldenian dont work?
Top
kuak
just visiting
Posts: 4
Joined: Sun Dec 21, 2003 6:47 am

Post by kuak »

Stik wrote: Ok guys, sorry, i went to bed right after posting B4 :rolleyes:
I think the DC problem is the wlserver and log server are trying to share the same ntrnal port. I changed my cfg,s as shown here and i can now change map servers without DCing,but it does take a few seconds to connect to the new server for some reason,that might be a comunication problem with mssql.
Image

try it and let me know.
nice one!!!!!!
Top
Sparda
Regular
Posts: 44
Joined: Sat May 15, 2004 10:48 pm

Post by Sparda »

Ah good work stik, just to confirm i get no delays when changing servers so it could be a problem with your mssql :)
Top
Stik
Member
Posts: 135
Joined: Thu Jun 10, 2004 4:59 pm

Post by Stik »

Ive reinstalled mssql severall times but still get a 15-20 second delay when changeing servers,(changeing maps on same server is instant)
Anyway,has anyone sorted out npcitem.cfg, if not then thats my next job B)
Top
nef
Regular
Posts: 59
Joined: Sun May 22, 2005 3:34 am

Post by nef »

what u wnat for npcitem.cfg?i may help u with that, and i wanna put heldenian fight on =((((( :( :( :( :( :( :( :( :( :( :( :(
Top
CDWriter
Member
Posts: 123
Joined: Sun Feb 22, 2004 12:08 am

Post by CDWriter »

Thanks Stik we all are very gratefulll for that info ...now everyone the heldenina fight problem ...... ;)
Top
RageIlluminati
Outpost bitch
Posts: 559
Joined: Wed Mar 30, 2005 6:45 am

Post by RageIlluminati »

have anybody tried to get 2.24b HGserver to connect with SQLserver thing? I get it work.. connects to gateserver and so on.. but if you try to login.. character gets DC immediate... I tried to change ports and so on.. but I have no fcking ide.. why doesnt it work:-/

EDIT: with china HGserver.. I got now GMcommands to work.. can summon and createitems.. but I can't create items from item4.cfg.. that means my HGserver doesn't load item4.cfg... how to get crafting items to my HGserver??
<img src='http://helbreath.pri.ee/userbars/hbest-gamemaster2.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/hbsoccer-owner.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/scorpa-rider.jpg' border='0' alt='user posted image' /> <img src='http://helbreath.pri.ee/userbars/logout-master.jpg' border='0' alt='user posted image' /> <br>.<br>................................Ego sum Rage, flagellum Dei!<br><br>The problem with America is stupidity. I'm not saying there should be a capital punishment for stupidity, but why don't we just take the safety labels off of everything and let the problem solve itself? (bash.org)
Top
DarkieDuck
Loyal fan
Posts: 441
Joined: Wed Feb 18, 2004 7:10 am

Post by DarkieDuck »

isnt item4.cfg around 3.62?
hax
Top
Stik
Member
Posts: 135
Joined: Thu Jun 10, 2004 4:59 pm

Post by Stik »

Does anyone have the source files for HGserver and maybe worldserver :)
Top
nef
Regular
Posts: 59
Joined: Sun May 22, 2005 3:34 am

Post by nef »

aahh yes i have 4 sorces of wls here, let me open my magic box and get 4 u <_< <_< <_<
nobody will ever give us the sorce of wls, forget about it
Top
CDWriter
Member
Posts: 123
Joined: Sun Feb 22, 2004 12:08 am

Post by CDWriter »

Anyon eget this to connect behind a Dmzed router ?


if so can u post your cfgs for gate, wls, main, gserver


these are the only 2 porblems we have now for a complete 100% 3.51 server....oo and dont think your going to get crafting working on this one eather becuase the wls does not load in the item4.cfg or the skill data info for crafting ....the 2 minor porblems now are Starting a heldenian Fight and hosting behind a router? any one solve these please share ....And the HBx hosting behind a router stuff will not work so dont post me that crap ......


TEST it ...



CDWriter ;) thanks all ill have a full Instruction setup here soon for every one who needs it
Top
AzraeL
noob
Posts: 25
Joined: Mon May 30, 2005 4:30 am
Location: Neverland

Post by AzraeL »

CDWriter wrote: Anyon eget this to connect behind a Dmzed router ?


if so can u post your cfgs for gate, wls, main, gserver


these are the only 2 porblems we have now for a complete 100% 3.51 server....oo and dont think your going to get crafting working on this one eather becuase the wls does not load in the item4.cfg or the skill data info for crafting ....the 2 minor porblems now are Starting a heldenian Fight and hosting behind a router? any one solve these please share ....And the HBx hosting behind a router stuff will not work so dont post me that crap ......


TEST it ...



CDWriter ;) thanks all ill have a full Instruction setup here soon for every one who needs it
<a href='http://unadvised.net/forum/index.php?showtopic=4637' target='_blank'>????</a>
<img src='http://img114.echo.cx/img114/9788/firma4ou.jpg' border='0' alt='user posted image' />
Top
CDWriter
Member
Posts: 123
Joined: Sun Feb 22, 2004 12:08 am

Post by CDWriter »

AzraeL
????

and ???? is there something iam missing here AzraeL ?

Other then a Account maker script eather in php or what ever would work would be nice ......the Values u really need are below .....


Account[cAccountID]    XXXXX[cPasswd]  1001[iAccountID] <NULL>[cLoginIpAddress]  <NULL>[IsGMAccount] <NULL>[CreatDate] <NULL>[LoginDate] <NULL>[LogoutDate] <NULL>[BlockDate] CDWriter[cRealName]    <NULL>[SSN]    me@home.com[cEmail]  <NULL>[cCharRecord]  <NULL>[cQuiz]  <NULL>[cAnswer]    <SetDateValidatesAccount>[ValidDate]    <SetTimeValidatesAccountByTime>[iValidTime]    <KEYCODE-?>[cKEYCODE]
I also got it to connect with just cAccountID(Name) , cPasswd(XXXXX), iAccountID(start with 1001-UP) and u need <ValidDate>12/2/3254 Or <iValidTime>1-10000 eather one but u must have 1 of them set..... There is no such thing as a GM account so make sure u change the IsGMAccount and all other accounts u create will be 0 always. Siementech HB changed to this when they made it all SQL so they could give 1 GM char to others with out haveing them make new GM charactors..

for your code in php or asp i would use cAccountID(Name) , cPasswd(XXXXX), iAccountID(start with 1001-UP) and <ValidDate>12/2/3254


so u php or asp guru's get on the job please and make us something ....... ;) ;) ;) ;)


CDWriter
Top
Post Reply

Return to “Helbreath Server Setup / Configuration / Help”