[RELEASE] WORKING Fixed Serverfiles+English gameclient!

Quote:

Originally Posted by iamlegend93 bah, need help to fix some of the skills.. like domilationbomb for hunters.. and 2 seg skills you cant buy.. and aqua circle is not working! :(

i dont no how to fix demolition bomb but for the 2 seg skills i just checked the item.csv n found the index 4 them n just put them in the shop manually put them into shopset

Quote:

Originally Posted by jhustle I'm using the webman thing that comes with the server. Do I need to install/enable php?

Yupp, webman doesn't have PHP.

Anyway can anyone help me out setting up a ODBC link so the website works?

Ah. Thanks. Is there a guide to setting this up with Apache or anything?

Just download XAMPLite and enable just apache. Put the reg folder into your httpdocs and thats it. Thats the way I did it.

I still can't figure out how to set registration page and I see many are not able too.

But for those who want to make your own username and password with coin for d-shop, u can do this.

1) At sql server, go to cash database/user_cash. get any user no and copy.

2) Now, go to account database/user_profile and (find the copy user number like how it was done in the video) and edit the login name to your desire name. [Now password is in MD5 format. Google the MD5 convertor or use this site, [Only registered and activated users can see links. Click Here To Register...]. credit to CosmosTunes] Go convert your desire password to MD5 format can copy in your database.

3) I'm not sure, tbl_user db need to change or not, but i just change it on the login name and password.

4) go back to user_cash and edit the amount of coin you want.

Important, u need to get the user no from cash_user table first. Not all user at account database has D-Shop coin which link to user_cash database.

so, ill try again, question:

is it possible to make it work with MySQL, or does it absolutly have to use MSSQL???

afaik, MySQL has different platform then MSSQL. The important thing, can u restore the backup database and link it up like MSSQL, if yes, than it is possible.

i'm using MSSQL Dev 2008, btw.

hmm, no sure to be completly honest, but i can check, or if someone already has the answer to that so be it.

MySQL is easier to work with i know that much, and anytime you can stay away from a microsoft based product (minus the OS of course) the better off you will be, measure MySQL support against MSSQL support . . .

How to run the registration page, I get a ODBC error and I already did the system dns link.

the video link you had there, its not working, the link is broken, could you repair it , it'll be helpful for me, im trying to learn Sql, and how to. It'll be fun ;)

can somebody upload that i can buy obsidian (portal scroll),,, and that i can buy the obsidian from th 90 dungeon for hunter arrows pls upload would give many thanks^^

another leacher... search for it in itemcsv.csv and then replace it with 4001 as silkbotter said before-.-

Quote:

Originally Posted by Mimo___93 can somebody upload that i can buy obsidian (portal scroll),,, and that i can buy the obsidian from th 90 dungeon for hunter arrows pls upload would give many thanks^^

Post that in the Private Server Tweaks Thread, not here. This is a release thread, not a request thread.

but if i replace it than i buy i becom a return scroll but i replaced it in item csv then the return scroll has the number 6123 and the obsidian 4001

does any1 know how 2 manage storage database..?

these wIndex might be index of item in storage but character_no are all the same..

how to know which index belongs to which char? there is some line_no but idk what it is used for ..