Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 12:43

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement
Bitcoin Dice Game


[Guide]How to Create 9.4 Server !

Discussion on [Guide]How to Create 9.4 Server ! within the Rappelz Private Server forum part of the Rappelz category.

Reply
 
Old 11/03/2017, 22:06   #16
 
elite*gold: 7
Join Date: Jul 2012
Posts: 33
Received Thanks: 4
How to code an own launcher?



JohnnyGhost is offline  
Old 11/03/2017, 23:55   #17
 
elite*gold: 0
Join Date: Nov 2012
Posts: 847
Received Thanks: 197
Quote:
Originally Posted by Albus1988 View Post
How to code an own launcher?
PHP Code:
RappelzCmdLauncher.exe Sframe.exe /auth_ip:127.0.0.1 /auth_port:9881 /use_nprotect:/help_url_w:611 /help_url_h:625 /locale:ASCII /country:US /cash /commercial_shop /layout_dir:/layout_auto:/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.

Quote:
Originally Posted by ThunderNikk View Post
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


thefear511 is offline  
Old 11/04/2017, 00:33   #18
Moderator

 
elite*gold: 1
Join Date: Dec 2012
Posts: 4,061
Received Thanks: 1,286
I am working on them I will null it for now.
ThunderNikk is offline  
Thanks
1 User
Old 11/04/2017, 02:30   #19
 
elite*gold: 0
Join Date: Nov 2012
Posts: 847
Received Thanks: 197
Quote:
Originally Posted by ThunderNikk View Post
I am working on them I will null it for now.
thx ill be waiting


thefear511 is offline  
Old 11/04/2017, 04:15   #20
Moderator

 
elite*gold: 1
Join Date: Dec 2012
Posts: 4,061
Received Thanks: 1,286
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.
ThunderNikk is offline  
Thanks
1 User
Old 11/04/2017, 13:24   #21
 
elite*gold: 0
Join Date: Jan 2015
Posts: 4
Received Thanks: 0
thx a lot u are a hero i will test it now
zreee is offline  
Old 11/05/2017, 18:44   #22
 
elite*gold: 0
Join Date: Jan 2015
Posts: 4
Received Thanks: 0
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 !!!!
zreee is offline  
Old 11/05/2017, 19:02   #23
Moderator

 
elite*gold: 1
Join Date: Dec 2012
Posts: 4,061
Received Thanks: 1,286
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.

https://support.microsoft.com/en-us/...-saving-change

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 is offline  
Thanks
2 Users
Old 11/05/2017, 19:15   #24
Moderator

 
elite*gold: 1
Join Date: Dec 2012
Posts: 4,061
Received Thanks: 1,286
Code:
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.
ThunderNikk is offline  
Thanks
1 User
Old 11/05/2017, 22:02   #25
 
elite*gold: 0
Join Date: Sep 2015
Posts: 695
Received Thanks: 1,103
If somebody wants to use it, I'll drop my tool here for hashing acc-passwords.
Nothing special, but if it helps...

(the (hidepass) doesn't show the password in plain text)
Attached Files
File Type: rar Password2Hash.rar (717.3 KB, 894 views)
File Type: rar Password2Hash(hidepass).rar (714.9 KB, 423 views)
InkDevil is offline  
Thanks
3 Users
Old 11/06/2017, 00:46   #26
 
elite*gold: 0
Join Date: Mar 2016
Posts: 228
Received Thanks: 70
Well, here is a quick program I made to create accounts, it's pretty basic and takes care of pass hashing.

Dark Blaze is offline  
Thanks
3 Users
Old 11/06/2017, 00:52   #27
 
elite*gold: 0
Join Date: Nov 2017
Posts: 21
Received Thanks: 4
Is there a chance to get working helmet and 8 Slot Belt ? IF yes how implement it :X
maso1987 is offline  
Old 11/06/2017, 01:04   #28
Moderator

 
elite*gold: 1
Join Date: Dec 2012
Posts: 4,061
Received Thanks: 1,286
Quote:
Originally Posted by Dark Blaze View Post
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?
ThunderNikk is offline  
Old 11/06/2017, 08:16   #29
 
elite*gold: 0
Join Date: Apr 2017
Posts: 104
Received Thanks: 8
Quote:
Originally Posted by thefear511 View Post
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
YuhaBah is offline  
Thanks
1 User
Old 11/06/2017, 11:20   #30
 
elite*gold: 0
Join Date: Mar 2016
Posts: 228
Received Thanks: 70
Quote:
Originally Posted by ThunderNikk View Post
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.


Dark Blaze is offline  
Thanks
1 User
Reply



« How to Make Rappelz NPC | I want help .. prevent the player from killing a monster »

Similar Threads Similar Threads
[HELP] How create some weapons in ShStudio? / Crash item mall / can't create new mobs
02/27/2014 - Shaiya PServer Development - 2 Replies
Hey, Before say "use the search button" or "see other topic for resolve ur problem" i have search and i don't have found any fix for my problem :/ I have 4 big problem: -1: When i buy an item in my item mall IG the game crash (please try to recconect to the server ERROR 0) i don't have found help after 2 days of search -2: When i want create a boss/mobs IG (only boss and mobs who i have add in my Monster.SData) i have this error in the tchat "Not authorized to create!" why i have this...
How create a trainer in cheat engine, and how to create autoassemble scripts [16 June
06/17/2012 - Facebook - 3 Replies
Many people asked me that... Maybe some of these people are from here.. or maybe not.. Anyway.. heres 25 minutes video ;D which should help? How create a trainer in cheat engine, and how to create autoassemble scripts - YouTube And yea.. I noticed that there 360p and 720p only.. no idea where the 460p gone... :x put 720p and full screen, otherwise in normal size its looks crappy
[HELP] How to create a new shop. SHOP CREATE
12/31/2010 - CO2 Private Server - 5 Replies
#closed
is possible to create a hack to create items +7
07/14/2008 - Dekaron - 25 Replies
How can I create a hack to create items +7



All times are GMT +2. The time now is 12:43.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

BTC: 33E6kMtxYa7dApCFzrS3Jb7U3NrVvo8nsK
ETH: 0xc6ec801B7563A4376751F33b0573308aDa611E05

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2020 elitepvpers All Rights Reserved.