Db Sql Format

Discussion about Helbreath Server Files.
Post Reply
morbid
Regular
Posts: 69
Joined: Fri Jul 30, 2004 4:28 pm

Post by morbid »

no it doesnt....
jmh
Member
Posts: 156
Joined: Sat Dec 13, 2003 6:13 pm

Post by jmh »

YES IT DOES!

if you can't get it to work then you shouldn't even try to run a server.,
<a href='http://www.beehivemail.com/pages/index.php?refid=jmh1' target='_blank'><img src='http://img235.imageshack.us/img235/7226 ... er16vn.gif' border='0' alt='user posted image' /></a>
morbid
Regular
Posts: 69
Joined: Fri Jul 30, 2004 4:28 pm

Post by morbid »

o.O
Stik
Member
Posts: 135
Joined: Thu Jun 10, 2004 4:59 pm

Post by Stik »

For all those people that cant run IIs (needs xp pro), here's a PHP account creator you need appachi with php 4.

Edit. sry found a lil error.
If you change the name of this file, then allso edit name of the form action
in the txt
CDWriter
Member
Posts: 123
Joined: Sun Feb 22, 2004 12:08 am

Post by CDWriter »

and u need <ValidDate>12/2/3254 Or <iValidTime>1-10000 eather one but u must have 1 of them set

OK i thank u all who are makeing the PHP , ASP, ect stuff for everyone and shareing but u are forgeting 1 major thing .....the line above u need to give a ValidDate (something like 12/2/2070) this will let them play the game til 2070, and if u do use the ValidDate then iValidTime can be 0 or NULL (Ctrl-0) , but if u dont do this then u need iValidTime, like 99999 this will allow them to play for 99999 secs or even minutes not sure butt the time ends fast and u need to keep adding min to your players or they will not be able to log in after 2 weeks .....for some reason the time thing Subtracts faster then it should ........And its 100x easyer for the Sysop of the game ..other then going into all the charactors that are made and change the time again ....



:) so maybe i did not give a better break down of that line sorry about that ...
morbid
Regular
Posts: 69
Joined: Fri Jul 30, 2004 4:28 pm

Post by morbid »

Stik wrote: For all those people that cant run IIs (needs xp pro), here's a PHP account creator  you need appachi with php 4.
error -.- x/
Stik
Member
Posts: 135
Joined: Thu Jun 10, 2004 4:59 pm

Post by Stik »

CDWriter wrote:
and u need <ValidDate>12/2/3254 Or <iValidTime>1-10000 eather one but u must have 1 of them set

OK i thank u all who are makeing the PHP , ASP, ect stuff for everyone and shareing but u are forgeting 1 major thing .....the line above u need to give a ValidDate (something like 12/2/2070) this will let them play the game til 2070, and if u do use the ValidDate then iValidTime can be 0 or NULL (Ctrl-0) , but if u dont do this then u need iValidTime, like 99999 this will allow them to play for 99999 secs or even minutes not sure butt the time ends fast and u need to keep adding min to your players or they will not be able to log in after 2 weeks .....for some reason the time thing Subtracts faster then it should ........And its 100x easyer for the Sysop of the game ..other then going into all the charactors that are made and change the time again ....



:) so maybe i did not give a better break down of that line sorry about that ...
Yep thats why i put a valid date of 2015, that gives you 10 years of play ;)
that should be plenty.

Yes easyphp 1.7 should be ok but if you look in the easyphp folder and just run appachi, then your not loading mysql as well as mssql
morbid
Regular
Posts: 69
Joined: Fri Jul 30, 2004 4:28 pm

Post by morbid »

Error continues! someone halp!
Stik
Member
Posts: 135
Joined: Thu Jun 10, 2004 4:59 pm

Post by Stik »

Morbid it looks like maybe you have a dfferen acount_t layout,and the accountmaker is trying to update non existing fields, not 100% sure but thats what it looks like.
Have you added the iShopid int and CKeyCode NCHAR at the end of the account_t table

morbid
Regular
Posts: 69
Joined: Fri Jul 30, 2004 4:28 pm

Post by morbid »

yah... i have added iGizoneItemUpgradeLeft, datatype INT For Character_T and iShopID, datatype NCHAR for ACCOUNT_T
Stik
Member
Posts: 135
Joined: Thu Jun 10, 2004 4:59 pm

Post by Stik »

can you post a screenshot of the righthand side of your account_t table
morbid
Regular
Posts: 69
Joined: Fri Jul 30, 2004 4:28 pm

Post by morbid »

sure..
Stik
Member
Posts: 135
Joined: Thu Jun 10, 2004 4:59 pm

Post by Stik »

Ok theres the problem
make shopid type INT not nchar
add another line
cKEYCODE nCHAR(10)

and that should work


morbid
Regular
Posts: 69
Joined: Fri Jul 30, 2004 4:28 pm

Post by morbid »

^^ Now it Works! Ty Stik! ^^ ur the best =P! ahhh another problem.. xD =*! Now when i create my char and try to log It Cant connect to map.... Connected.. Waiting For Response! HALP HALP!
diwx
Outpost bitch
Posts: 513
Joined: Thu Dec 23, 2004 4:13 pm

Post by diwx »

wtF is this?! some enlighten me
Post Reply