[Guide]How to Create 9.4 Server !

[JohnnyGhost]

How to code an own launcher?

[thefear511]

Originally Posted by Albus1988

How to code an own launcher?

PHP Code:

RappelzCmdLauncher.exe Sframe.exe /auth_ip:127.0.0.1 /auth_port:9881 /use_nprotect:0 /help_url_w:611 /help_url_h:625 /locale:ASCII /country:US /cash /commercial_shop /layout_dir:6 /layout_auto:0 /cash_url_w:800 /cash_url_h:631 


do you mean .bat? this is .bat, if you want .exe then sorry I don't have enough knowledge about that I managed to make one similar to official but having issues with Patch bin.

Originally Posted by ThunderNikk

Nothing Important

Msg 241, Level 16, State 1, Line 2
Conversion failed when converting date and/or time from character string.
i tried to pick stuff from the code in my Guide which is "2017-10-20 18:56:17.000" and it didn't work either so i guess ill stick to mine for now

[ThunderNikk]

I am working on them I will null it for now.

[thefear511]

Originally Posted by ThunderNikk

I am working on them I will null it for now.

thx ill be waiting

[ThunderNikk]

I have fixed every entry type in the registration scripts except my old 7.4 Auth database allows account_id to be left out of the script and it auto populates it.

The new one for 9.4 gives an error complaining account_id can not be 'null' and aborts.

Both the 7.4 and the 9.4 auth are set to not allow 'null' in that column so I am trying to either find the difference or I am trying to code the script to find the max value and add+1

It is driving me batty tonight so maybe I will figure it out tomorrow.

[zreee]

thx a lot u are a hero i will test it now

[zreee]

everything working but i cant create accounts it give me this error
Cannot insert the value NULL into column ‘account id’, table ‘auth dbo account; column does not allow nulls. INSERT fails.
please help !!!!

[ThunderNikk]

Do this part and I will post a SQL insert command in a minute...

We are going to redesign the account table in the database a little bit so you are going to need to make sure that you have design editing turned on because I didn't at first.



1. Open your MSSQL server management window and connect to your database.
2. Expand your database folder
3. Expand your auth database
4. Expand you tables folder
5. Right click on your dbo.Account table and select design from the right click context menu
6. Select the row for account_id in the design window
7. In the bottom design pane scroll down to where you see "Identity Specification"
8. Expand that by clicking on the arrow to the left of it
9. Where it says (Is Identity) on the right side of that if you select the area where it says no use the drop down arrow and change it to yes
10. The two fields below it should say Identity Increment 1 and Identity Seed 1

Then last of all in the top design window go to the first row that is empty and add age

age, Int, and check the box to allow nulls

It is in the script and as long as we are making the user enter it we might as well collect that data.

11. Click on the save icon in the tool bar to save the changes you have just made to the dbo.Account table.

[ThunderNikk]

INSERT INTO [Auth].[dbo].[Account] ([account], [password], [email], [password2], [block], [IP_user], [last_login_server_idx], [Admin], [point], [datePassword], [pk_]) VALUES ('YourAccountNameHere', 'YourPasswordHere', 'YourEmailHere', 'YourPasswordHere', '0', '127.0.0.1', '1', '1', '0', '2017-10-20', '1');

Use that...

SQL password must be MD5 encrypted with your password md5 key.



If your key is 2011 then your password encryption would be 2011password

The following is an encryption for a password of admin (2011admin)

613b5247e3398350918cb622a3ec19e9

Find your md5 key in the auth.opt. Fill in the name you want for your account and your email and the rest of the values you wan't specific for your own account.

[Dark Blaze]

Well, here is a quick program I made to create accounts, it's pretty basic and takes care of pass hashing.

[maso1987]

Is there a chance to get working helmet and 8 Slot Belt ? IF yes how implement it :X

[ThunderNikk]

Originally Posted by Dark Blaze

Well, here is a quick program I made to create accounts, it's pretty basic and takes care of pass hashing.

How does it handle database connections or is it just set up for sa with a blank password?

[YuhaBah]

Originally Posted by thefear511

here's all the luas from revo files , maybe there is no script for hv buffs , you gotta make a script for it , its very easy if you want i can make a guide to how to make a script for every npc or new npc.

Hi, I would be very grateful if you could have such a guide

[Dark Blaze]

Originally Posted by ThunderNikk

How does it handle database connections or is it just set up for sa with a blank password?

It uses Windows Authentication, I can modify it to also have an option for user authentication.

[thefear511]

Originally Posted by YuhaBah

Hi, I would be very grateful if you could have such a guide

alright ill be working on it on my free time will include all .lua logics and functions also some premade rappelz .luas