Db Sql Format

Sparda · Post by **Sparda** » Fri May 20, 2005 6:07 pm

try using a different program like winrar to unzip the files.

CDWriter · Post by **CDWriter** » Sat May 21, 2005 6:42 pm

-Pitu-

i managed to create the account and the character i am in game but i star the heldenian and it finish instantly, how can i fix it dd?

i can`t insert the HeldenianResultT table and the crusade one

U help someone here in a pm and u expect in return there trying to help everyone else ...But no your like -Pitu- u give him all the help he needs and u think he would try and help u with just some text info u think u need but instead he blows u off like a peace of shit he his ....So if there is a DICKhead award on this forum he would GET it 5 pms to this person now and he reads them but then Never replys ........One word for u -Pitu- if it was not for all of us here helping others you would not have shit ........and if it was not for me with the Install insturctions u would not have gotten as far as u did by luck .....and lets not for get GoldenBoy who gave us these to play with and everyone else here who add comments and help ......all i asked was the order in witch u created your db in sql ...and 4 of your cfgs HMLserver.cfg , WLserver, HGserver, gate.cfg infos. i think this is everyones problem .......

-Pitu- ---- Fuck off and if i see u have a HB server running u know ill be DDosing it to death and i hope everyone else follows in.....

Ooo and i saved all my PMs from u so if others want to see them ill post them here .....as proof what a fucking dickhead u are.....

CDWriter

jmh · Post by **jmh** » Sat May 21, 2005 7:18 pm

I doubt he was able to get his server up and running and actually able to log in.

Stik · Post by **Stik** » Sat May 21, 2005 7:48 pm

Need a lil more help pls..
By adding a column called iShopID in the account_t table i can now create a valid acount and log into it.But when i try to create a character,it says new character created (in the client screen and in the mainlogin server screen)
but it does not show the character in the client ,and it only creates some items in the database and no character info.

Any ideas pls

Allso how does one generate the unique accountid number.

Many thanks
Mage

CDWriter · Post by **CDWriter** » Sat May 21, 2005 9:23 pm

iShopID in the account_t table

hmm ok u added this between what or at the end of Account_T?
what values u give it INT?
and if u got that far why are u asking for

Allso how does one generate the unique accountid number.

if your going to help

please be more helpfull in your questions and what u may have came up with ? <_<

Thanks

Sparda · Post by **Sparda** » Sat May 21, 2005 10:11 pm

tell us how you got iShopID, maybe we can help you if you tell us more information...

Stik · Post by **Stik** » Sun May 22, 2005 9:09 am

Sorry, i was a bit vague.
Looking thru the hex of mainlogserver.exe i noticed it was looking for a field called "shopid".
So useing enterprise manager in databases/mainlog/tables,right click on
ACCOUNT_T and choose design table,then at the bottom of the table add
iShopID INT 4
In the account info it seems to work with any number as a shop id,(i tried numbers betwen 1 and 100)

Had3s · Post by **Had3s** » Sun May 22, 2005 6:59 pm

iShopID the first i says thats is an int.
i put it at the end, andi used the default of int( like the rest i think) and its works.. the problems starts later... with the pj...

when u create a pj the items are created.. the skills are created.. but nothing more -.-

I was told that this was the easy part.... so...

Had3s · Post by **Had3s** » Sun May 22, 2005 7:00 pm

sry clone post..

RageIlluminati · Post by **RageIlluminati** » Sun May 22, 2005 8:21 pm

I tried to make one character related with my account.. but this crashed my client if I tried to log to chaacter windows.. that means.. I dont even see characters...

CDWriter · Post by **CDWriter** » Sun May 22, 2005 8:55 pm

Well start a char and account u know that works like

Account

like form the other servers that have been setup and u have played then make a char named GM1 or something but make it easy ....then add all the information form your TXT files for the older 2.24x simple i have char in screen and connected to account but every time i try to log in it tells me NO land are avaliable ?? and i have aresden connected ....hell i had them all connected at one time and it still gave me the same error?

Example what i get now

DarkieDuck · Post by **DarkieDuck** » Sun May 22, 2005 9:03 pm

u sure u had default connected?

CDWriter · Post by **CDWriter** » Sun May 22, 2005 10:49 pm

yes every HGserver was connected and showing on Mainlog and world and reported on Gate as active....but there still a few things missing in sql..

AscII%d \ Character %x-(1774) sql (%s) select * from CHARACTER_T where cCharName = ('%s') select * from CHARACTER_T where upper(cCharName) = upper('%s') and left(cCharName,1) = ('%c')

I know u all look at this like its all ready there but its not linking on the sql like it suppose too becuase this and CODE_T should interact with each other ...alone with CODE_T is used for changeing account passwords.....

Iam working on now but slow since i dont know Mssql that well .....thanks to a very good friend of mine Iluvatar we both have been working on this...

Sparda · Post by **Sparda** » Sun May 22, 2005 11:38 pm

My one can create characters and is working normally but i just can't seem to get into the game server because it just says "Connected. Waiting for response...."

any ideas?

CoLoOo · Post by **CoLoOo** » Sun May 22, 2005 11:50 pm

Sparda wrote: My one can create characters and is working normally but i just can't seem to get into the game server because it just says "Connected. Waiting for response...."

any ideas?

same 4 me