change hg to db mode ?

dumper · Post by **dumper** » Thu Mar 22, 2007 3:51 pm

i think i got the new lvl up system workin now and lupool stored in db ... but now i always have waiting for response on serverchange ...
with normal config setup i cant even login ... and with the configs for sql files i cant change servers

does the chinese hg uses a diff serverchange function or something ??

MagicMan · Post by **MagicMan** » Fri Mar 23, 2007 4:49 am

i got the same problem but i'm sure it's in the cfg's...btw jimmy this is Big

bone-you · Post by **bone-you** » Fri Mar 23, 2007 6:02 am

MagicMan wrote: i got the same problem but i'm sure it's in the cfg's...btw jimmy this is Big

Don't know anyone by that name.

dumper · Post by **dumper** » Fri Mar 23, 2007 3:05 pm

nvm got the server change workin now ...
but another question about the sql querys from rage !
normal querys for ml and wl have only the .mdf and _idx.mdf but in the querys from rage there are .ldf files created in the db but i dunno for what ... dont know much about sql yet so dont blame me -.-

um ok i guess that are logs but how do i access them lol ... one is already 700mb but nothing is in the db yet -.-

Sprint · Post by **Sprint** » Fri Mar 23, 2007 4:25 pm

dumper wrote: nvm got the server change workin now ...
but another question about the sql querys from rage !
normal querys for ml and wl have only the .mdf and _idx.mdf but in the querys from rage there are .ldf files created in the db but i dunno for what ... dont know much about sql yet so dont blame me -.-

um ok i guess that are logs but how do i access them lol ... one is already 700mb but nothing is in the db yet -.-

an´empty db with a 700mb ldf logs, Wtf? what the fuck have u been doing with the db??
(the log file logs all events exept the dbconnection-requests wich are done about 1/sec lol and ofcourse not closeconn-statused events))

700MBare u shure cos my dad has a 500+MB db and it has over 50 000 000symbols in it

dumper · Post by **dumper** » Fri Mar 23, 2007 4:29 pm

i didnt do anything with it ... its created already with that size ...
and i have another problem .. when im using a different wl name to connect to the server then the ml server crashes -.-
well actually i get a db error and if i click yes or no then the ml crashes ...is that a problem with the db ?? using sqlexpress !
that are the sql querys i used -> <a href='http://www.hot.ee/rageatm/rage_database_scripts.rar' target='_blank'>http://www.hot.ee/rageatm/rage_database_scripts.rar</a>

dumper · Post by **dumper** » Sat Mar 24, 2007 2:25 am

how do i make that log smaller ? can i only reuce its size ? why is it set to such a size at beginning ? i tried to remove the log from the query but then i get db error when creating a char

MagicMan · Post by **MagicMan** » Sat Mar 24, 2007 6:31 am

if you used the sql dumps from here then of cause it will crash..just make sure you use the db thats in the script..then no more probs..if you want a different db name then you have to change it in the script and then parse it.

Hope this helped

dumper · Post by **dumper** » Sat Mar 24, 2007 9:33 am

what u mean db name ? i thought they are always the same (ws1 and mainlogin) ... and what about the log files from that scripts ? any way to remove it or make it smaller ?
um i think i removed the logs and the db options now ... since i dont know what the db options and logs are good for .. why use them

but i still get db error when connecting with different wl name to ml server

Sprint · Post by **Sprint** » Sat Mar 24, 2007 8:19 pm

I must ask something:
How is the accountcreation done in sql-server? Is there any websitescripts on making accounts to db? Or do u make account in client?

And who have done this? Im prolly going to do a website with account creation for sql based servers in aspx with full tutorials and well-commented stuff (this will prolly be my first and last thing i give out with full sources and stuff for HB)
I need to contact the person(s) who have done the sql based server (non korean)

dumper · Post by **dumper** » Sat Mar 24, 2007 8:46 pm

i dont know of any client where u can create accounts inside client for sql db ... same with changing passwords ..
im using php script for that ...

MagicMan · Post by **MagicMan** » Sun Mar 25, 2007 5:50 am

Just use Sparda's asp scripts on your web site and your done..btw you can link client to yopur web site..to make it easy....if you can't find them just hola..

Sprint · Post by **Sprint** » Sun Mar 25, 2007 7:31 am

duh can sum1 send me the sql-phps. Gonna make aspx site for hbfreaks as practice. With full tutorials of how setting the sql-shit up

(PM link to files or attach here)

dumper · Post by **dumper** » Sun Mar 25, 2007 9:01 pm

i got another question ... how do ppl protect the sql ml and wl servers from extasis ... when i try it still crashes the ml server

well it doesnt crash them directly but debug error pops up ... but only when using a map name thats already used by server ...when closing that errors ml crashes ...

@sprint - there are some phps in the sql files guides ....

Sprint · Post by **Sprint** » Mon Mar 26, 2007 4:37 pm

dumper wrote: i got another question ... how do ppl protect the sql ml and wl servers from extasis ... when i try it still crashes the ml server
well it doesnt crash them directly but debug error pops up ... but only when using a map name thats already used by server ...when closing that errors ml crashes ...

@sprint - there are some phps in the sql files guides ....

are u using patch?

and can u send me those scripts, i need em for making WDK (website development kit xD) in asp.net for sqlserver