Db Sql Format

[Stik]

Do i just make a wwwroot folder in the mssqlserver directory and the put the accountcreator files in wwwroot, is there anything else i have to do?
what port does mssql use? do i have to forwar it in my router?


heres a char text dump

[Sparda]

Oh sorry those instructions was for IIS (Internet Information Services).

I'm running windows xp professional so IIS is an optional component that you can find on your windows xp pro disc. Once you have installed the IIS server you will find a new folder in your C:\ called 'Inetpub', 'wwwroot' folder exists in that Inetpub folder and that's where you should put those files in.

You don't have to worry about the ports, i've mentioned 2 files you have to configure because it uses the same DSN connections as the helbreath server.

For those who don't know what IIS is, IIS is a webserver that is created by Microsoft. It is able to host files with .asp file extension. The scripts i wrote requires this webserver (or any other webservers that can host asp). Since IIS and MSSQL uses the same library they'll interact easily.

To install IIS:
You must be running a professional version of Windows XP.
Run windows xp pro disc
Install optional components
Check Internet Information Services (IIS) > Next
Installation complete.

[Stik]

Im running microsoft mssql server2000 on winXP home,Looking thru the help files in ssql 2000 its sposed to have IIs (i think) but i cant see those folders anywhere.I made a wwwroot folder in the ssql directory but when i type http:// myip/accountcreator it comes back with connection was rejected (or something like that)

[nef]

stik u cant run iis on home edition, try to buy a professional or use apache with php sql scripts =/

[RageIlluminati]

Hi, strange problem occured in my server.... some guys made exp.. and like got to lvl 89 or 100 or smthing.. and then theyr exp got like rollback... from 6-7mil to 1,5 mil... levels are the same.. but they like have to exp all this exp again... to get a next lvl...


and in character_t there is golumn named: BlockDate... what that means??

[CDWriter]

BlockDate <-- is exactly what it means Block ......u cant tell me u have never loged on to HBINT or some where and never got Blocked til 2049 ?????


its to block the char when they dont pay ....also in your HB server do u have high exp rates , dont forget this is orginal server files so uping the exp on the creatures too high and u will fall into the exp bann ........too much too fast ....



Any ways Sparda how is it going with the Charactor editor or anything else you are createing for the sql ? the Account Maker and all the others u have Made are GREAT ....very nice job Sparda....I think i can talk for every one Big thanks here...

[Slayer]

I'm really confused with my item.cfg's and DarkKnight and DarkMage armors and weapons...


OK I understand what is W behind the armor.. but W behind weapons???

;------Num--Name-Type-EPos-Effect-ETValue-MaxLife-SEffect-Spr--SFrame--Price--Wgt--ApprV-Speed--L.Lmt--G.Lmt--SEV---R.Skill-Category-Color
Item = 724 DarkKnightHauberkW 1 3 2 18 18 0  0 0 0 30000 0 11 2 2400 1200 3 0 180 2 -3 -3 0 6 6
Item = 706 DarkKnightHauberk  1 3 2 18 18 0 10 9 0 30000 0  7 1 9600 1200 2 0 180 1 -3 -3 0 6 6
Item = 711 DarkMageHauberk    1 3 2 18 18 0  0 0 0 30000 0  7 1 9600 1200 2 0 180 1 -3 -3 0 6 6
Item = 729 DarkMageHauberkW  1 3 2 18 18 0  0 0 0 30000 0 11 2 2400 1200 3 0 180 2 -3 -3 0 6 6

Item = 725 DarkKnightFullHelmW 1 1 2 17 27 0  0 0 0 30000 0 21 1 3500 8500 1 0 180 2 -7 -7 -1 6 6
Item = 707 DarkKnightFullHelm  1 1 2 17 27 0 10 0 0 30000 0 21 1 18000 8500 1 0 180 1 -7 -7 -1 6 6

Item = 726 DarkKnightLeggingsW 1 4 2 21 28 1 1 1 1 30000 0 12 4 3000 2000 5 0 180 2 -6 -6 0 6 6
Item = 731 DarkMageLeggingsW  1 4 2 21 28 1 1 1 1 30000 0 12 4 3000 2000 5 0 180 2 -6 -6 0 6 6
Item = 708 DarkKnightLeggings  1 4 2 21 28 1 10 1 1 30000 0 8 3 12000 2000 4 0 180 1 -6 -6 0 6 6
Item = 713 DarkMageLeggings    1 4 2 21 28 1 1 1 1 30000 0 8 3 12000 2000 4 0 180 1 -6 -6 0 6 6

Item = 727 DarkKnightFlamebergW 1 9 1 4 7 0 4 7 0 30000 0 1 11  3700 6000 12 10 180 0 -15 10 8 1 6
Item = 709 DarkKnightFlameberge 1 9 1 4 7 0 4 7 0 30000 0 1 11 14800 6000 12 10 180 0 -15 10 8 1 6

Item = 728 DarkKnightPlateMailW 1 2 2 53 55 0 0 0 0 30000 0 13 5 6000 10000 6 0 180 2 -10 -10 0 6 6
Item = 710 DarkKnightPlateMail  1 2 2 53 55 0 0 0 0 30000 0  9 3 24000 10000 4 0 180 1 -10 -10 0 6 6

Item = 730 DarkMageChainMailW 1 2 2 36 38 0 0 0 0 30000 0 13 3 1200 3000 4 0 180 2 -12 -12 0 6 6
Item = 712 DarkMageChainMail  1 2 2 36 38 0 0 0 0 30000 0  9 1 4800 3000 2 0 180 1 -12 -12 0 6 6

Item = 732 DarkMageMagicStaffW 1 8 13 1 6 0 25 0 0 30000 10 17 1  6000 1000 36 3 180 0 0 0 21 8 6
Item = 714 DarkMageMagicStaff  1 8 13 1 6 0 25 0 0 30000 10 17 1 24000 1000 36 3 180 0 0 0 21 8 6

Item = 733 DarkMageRobeW 1 2 2 22 20 0 14 100 0 30000 0 13 6 8000 1000 7 0 180 2 0 0 0 11 6
Item = 715 DarkMageRobe  1 2 2 22 20 0 14 100 0 30000 0  9 5 8000 1000 6 0 180 1 0 0 0 11 6

Item = 745 BlackKnightTemple 1 9 1 2 10 2 2 12 2 30000  0 1 20 -14800 6000 14 10 180 0 -15 10 8 1 6
Item = 746 BlackMageTemple  1 8 13 1 6 0 28 0 0 30000 10 17 2 -24000 1000 37 3 180 0 0 0 21 8 6

Item = 719 DarkMageScaleMail  1 2 2 32 30 0 0 0 0 30000 0  9 2 4000 2000 3 0 180 1 -8 -8 0 6 6
Item = 776 DarkMageScaleMailW 1 2 2 32 30 0 0 0 0 30000 0 13 4 4000 2000 5 0 180 2 -8 -8 0 6 6

Item = 716 DarkMageLedderArmor 1 2 2 24 22 0 0 0 0 30000 0  9 0 8000 1500 1 0 180 1 -5 -5 0 6 6
Item = 775 DarkMageLArmorW    1 2 2 22 20 0 0 0 0 30000 0 13 2 8000 1500 3 0 180 2 -5 -5 0 6 6

Item = 717 DarkKnightRapier 1 8 1 1 7 0 1 7 0 30000 0 1 6 12000 1100 7 3 180 0 0 0 9 1 6
Item = 718 DarkKnightGreatSword 1 9 1 2  8 0 2 10 0 30000 0 1 10 12000 5200 11 8 180 0 -8 5 8 1 6
Item = 737 DarkKnightGiantSword 1 9 1 2 10 2 2 12 2 30000 0 1 18 14800 6000 13 10 120 0 -15 10 8 1 6
Item = 738 DarkMageMagicWand 1 8 13 1 6 0 28 0 0 30000 10 17 0 24000 1000 35 3 120 0 0 0 21 8 6

AND, is there any difference between darkknight and darkmage items?

and it seems DarkMage items are with lower prices.. why?

Price doesn't matter shit, DarkKnight item's are given out by gms.

[CDWriter]

the W stands for WAND it just the name was to long to add the rest of it to the word

[Stik]

Taken from eq. above
Item = 709 DarkKnightFlameberge 1 9 1 4 7 0 4 7 0 30000 0 1 11 14800 6000 12 10 180 0 -15 10 8 1 6

Item = 728 DarkKnightPlateMailW 1 2 2 53 55 0 0 0 0 30000 0 13 5 6000 10000 6 0 180 2 -10 -10 0 6 6
Item = 710 DarkKnightPlateMail 1 2 2 53 55 0 0 0 0 30000 0 9 3 24000 10000 4 0 180 1 -10 -10 0 6 6

the number after the 180 is g.lmt(gender limit)
0=no gender
1=Male
2=Female
so in the above,the W indicates its for a woman char.

[locobans]

Anyone knows how to make HGserver accepts 250stats :unsure:

[locobans]

Also...where is drop rate...rated in this HGserver...remember we had...old config file that had Primary Drop rate and Secondary Drop Rate... and stuff....

[CDWriter]

Ok locobans these are orginal files if u want to change the Level limit u will lose the Gibson Upgrading or Dk items at 180 these files only work like Orginals to 180 yes u could have it go higher but when u hit level 180 your exp will allways start over again but giving u 3 upgrade points whole perpose of geting these working 100% well that and heldenian and apoc.

Also...where is drop rate...rated in this HGserver.

NPCitem.cfg.....


[CONFIG]
//if u put 1 1 in the end u will have really high drops
//2 dices 100 faces each
//if u get 7 and 6, 7+6=13 the item drops so u have 1/100+1/100 chance of droping item
//and this chance is *1/(number of itens in the line)

;-----Name------------Type--ItemName-- %1 -- % 2 ---- ItemName-- %1 -- % 2 -

NpcItem = Cat 1 StoneOfMerien 1 500 [ENDITEM]
NpcItem = Orc 1 StoneOfMerien 1 500 [ENDITEM]

;-- 20 ~ 40 Level ------------
NpcItem = Zombie 1 KnecklaceOfPoisonPro 700 120 RingofMage 700 150 KnecklaceOfSufferent 700 130 [ENDITEM]
NpcItem = Scorpion 1 KnecklaceOfPoisonPro 600 120 RingofMage 600 150 KnecklaceOfSufferent 600 130 [ENDITEM]
NpcItem = Skeleton 1 MagicNecklace(DF+10) 550 120 MagicNecklace(DM+1) 550 150 MagicNecklace(RM10) 550 100 [ENDITEM]

;-- 40 ~ 50 Level -----------
NpcItem = Clay-Golem 1 MagicWand(M.Shield) 700 10 MagicNecklace(DF+10) 700 100 [ENDITEM]
NpcItem = Stone-Golem 1 MagicWand(M.Shield) 700 10 NecklaceOfStoneGol 700 140 [ENDITEM]
NpcItem = Hellbound 1 MagicNecklace(RM10) 400 75 KnecklaceOfLightPro 400 100 RingofWizard 400 110 RingofMage 400 190 [ENDITEM]
NpcItem = Giant-Frog 1 MagicNecklace(DF+10) 600 120 MagicNecklace(DM+1) 600 150 MagicNecklace(RM10) 600 15 [ENDITEM]

;-- 50 ~ 60 Level -----------
NpcItem = Cyclops 1 MagicNecklace(RM10) 400 75 KnecklaceOfLightPro 400 100 RingofMage 400 190 RingofGrandMage 400 400 [ENDITEM]
NpcItem = Troll 1 MagicNecklace(DF+10) 500 120 MagicNecklace(DM+1) 500 150 MagicNecklace(RM10) 500 15 [ENDITEM]

;-- 60 ~ 70 Level -----------
NpcItem = Orge 1 MagicNecklace(DF+10) 300 120 MagicNecklace(DM+1) 300 150 RingofOgrepower 300 300 MagicWand(M.Shield) 100 10 [ENDITEM]
NpcItem = Liche 1 NecklaceOfLiche 200 100 IceStormManual 200 100 MagicWand(MS30-LLF) 200 100 RingofGrandMage 200 100 RingofArcmage 200 150 [ENDITEM]

;-- 90 Level -----------

NpcItem = Unicorn 1 CancelManual 700 100 KlonessEsterk 200 70 KlonessAxe 200 100 KlonessBlade 300 150 MerienShield 200 150 [ENDITEM]
NpcItem = WereWolf 1 Flameberge+3(LLF) 30 30 MagicNecklace(DF+10) 300 120 MagicNecklace(DM+1) 300 150 GoldenAxe(LLF) 300 10 10000GoldPocket 2 50 50000GoldPocket 3 50 [ENDITEM]
NpcItem = Stalker 1 SwordofIceElemental 200 200 MagicNecklace(DF+10) 200 70 MagicNecklace(DM+1) 200 100 [ENDITEM]
NpcItem = Gagoyle 1 BloodyShockW.Manual 100 30 KnecklaceOfEfreet 100 50 RingofDragonpower 100 60 RingoftheXelima 100 80 KnecklaceOfEfreet 100 50 [ENDITEM]
NpcItem = Dark-Elf 1 DarkElfBow 300 100 RingoftheXelima 300 300 [ENDITEM]
NpcItem = Beholder 1 SwordofIceElemental 400 300 KnecklaceOfAirEle 400 200 MagicNecklace(DM+1) 400 100 [ENDITEM]

;-- Special Monster -----------

NpcItem = Demon 2 StoneOfXelima 20 20 BloodyShockW.Manual 700 140 [ENDITEM]
NpcItem = Hellclaw 2 MerienShield 600 100 MerienPlateMail(W) 600 110 MerienPlateMail(M) 600 120 KnecklaceOfIcePro 300 100 KnecklaceOfSufferent 300 110 KnecklaceOfLightPro 300 120 SwordofIceElemental 30 20 RingofWizard 30 25 RingofMage 30 35 EmeraldRing 20 30 MagicNecklace(DF+10) 10 40 MagicNecklace(RM10) 10 50 RubyRing 10 60 MagicNecklace(MS10) 10 70 MagicWand(M.Shield) 10 150 [ENDITEM]
NpcItem = Tigerworm 2 XelimaRapier 600 120 BloodSword 600 130 MagicWand(MS30-LLF) 600 150 KnecklaceOfEfreet 200 140 KnecklaceOfIceEle 200 150 KnecklaceOfAirEle 200 160 MagicNecklace(DF+10) 100 140 RingofWizard 100 150 Flameberge+3(LLF) 30 100 RingofGrandMage 50 110 RingofMage 1 10 SwordofIceElemental 1 12 RingofOgrepower 1 14 MagicNecklace(DM+1) 1 22 KnecklaceOfMedusa 1 18 [ENDITEM]


But dont change them if u dont know how they work Nefy did alot of testing on them and i added my own little break down on the top ...real close to what Nefy and BRCrazy did so they should get all the credit for that one ...

If u really want to change all what u have mentioned then i would not use these Orginals but would go with the HBx 3.01 atleast there Gibson upgrade and heldenian works also ....but i have not test them fullly ....


If anyone sees anything i may be wrong on let me know, always welcome fixes to my mistakes?

CDWriter

[nef]

cd about that we should give some credtid to BRCrazy, we did that formulation, usings sorces and c++ simulators, =]

[locobans]

I guess we will go...HBX 3.01.....Since they aint a way to change these stats in HGserver, tried a tutorial hexing the .exe file but couldnt...tho thx again CDWriter...

[jmh]

i'm sure there is a way to change max stats loco