[TUT] MySQL Scions of Fate Private

[patrat]

[Downloads]

MySQL-

You must be registered to see links

Navicat-

You must be registered to see links

Server/DB-

You must be registered to see links

You must be registered to see links

*extracts with 3 folders database, gameserver, loginserver

Client/Patch (i think we good up to 1.8 and beond)-

You must be registered to see links

You must be registered to see links

You must be registered to see links

You must be registered to see links

Luncher-

You must be registered to see links

You must be registered to see links

[links]

No-IP-

You must be registered to see links

DynDNS-

You must be registered to see links

[Guide]

(im not a guide writer so bare wit me)

Step 1
setting up MySQL

1) download MySQL
2) install MySQL (lots of next button pressing)
3) set up as default (just press next button)
4) when it asks for a password choose 123456 (unless u want to edit server files)

Step 2
Setting up navicat

1) install navicat (link provided)
2) open navicat
3) press connect
4) fill in the fallowing

Connection Name: PrivateSoF

Host name/ IP address: 127.0.0.1 (or localhost)

Port: 3306

User name: root

Password: 123456 (or what ever u choice in step 1 part 5)

5) press "ok"

Step 3 (big step)
Setting up DB (DB = data base)

1) open "PrivateSoF" from the tree on the left
2) right click the tree
3) Press "New Database...."
4) fill in as fallows

Enter database name: rxjhaccount
Character set: Default character set
Collation: Blank

5) Repeat part 4 three two more times but change rxjhaccount to rxjhgame and rxjhweb
6) Expand the Databases u just created
7) right click on rxjhweb and select "Execute Batch File"
8) where it says "File" press "..." (this is the browse button)
9) locate "rxjhweb.sql"
10) Press start
11) open the other trees (rxjhgame and rxjhweb)
12) open "Queries"
13) double click the querie (its named the same as the head of the tree)
14) press run (upper left corner)

Step 4
Starting Server

1) Open "LoginServer"
2) Run "LoginServer.exe" (in server/db download folder loginserver)
3) Open "GameServer"
4) Run "GameServer.exe" (in server/db download folder gameserver)

Step 5
Luncher Set up

1) place luncher in your chinese clients directory
2) Rename "YAMI Launcher" to what ever you like and run it


________________________________________________________
--------------------|Therory Public|----------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Step 1
Server files

1)Find your Wan IP (

You must be registered to see links

)
2) open "LoginConfig.ini"
3) change 127.0.0.1 to your WanIP

[LoginServer]
ServerName = posion
port = 1300

[ServerSql]
ip = [B][SIZE="3"][COLOR="Red"]WanIP Goes Here[/COLOR][/SIZE][/B]
port = 3306
name = root
code = 123456


[GameServer]
ServerCount = 2

4) Open "GameServerCount.txt"
5) Change 127.0.0.1 to WanIP

[B][SIZE="3"][COLOR="Red"]WanIP Goes Here[/COLOR][/SIZE][/B]	13000	posion
[B][SIZE="3"][COLOR="Red"]WanIP Goes Here[/COLOR][/SIZE][/B]	13000	posion

6) Open "GameConfig.ini"
7) Replace 127.0.0.1 with WanIP

[GameServer]
id = 0
Name = Posion
port = 13000
Money = 500
VIPEXP = 2
VIPMoney = 2
VIPDrop = 2
HP = 1
MP = 1
HEART = 1
FORCE = 1
BODY = 1
PERSON = 1
ATTACK = 1
DEFENSE = 1
TARGET = 1
AVOID = 1
[ServerSql]
ip = [B][SIZE="3"][COLOR="Red"]WanIP Goes Here[/COLOR][/SIZE][/B]
port = 3306
name =root
code = 123456


[LoginServer]
ip = [B][SIZE="3"][COLOR="Red"]WanIP Goes Here[/COLOR][/SIZE][/B]
port = 1300
WebStatic = http://127.0.0.1/login.asp

Step 2
Optional Dynamic DNS

1) registar and install either DynDNS or No-IP

You must be registered to see links

You must be registered to see links

2) do step 1 but replace WanIP with Dynamic DNS (web address)

Step 3
Luncher set up

1) open "InfBack"
2) right click "c4e04332.dat"
3) Press properties
4) uncheack "read-only"
5) open wit notpad
6) change 127.0.0.1 to Dynamic DNS or to WanIP

[UpdataSet]
UpExeUrl=192.168.1.2/
Version=2.32
CompelUp=0

UpFileUrl=192.168.1.2/
FileVer=0.00



[OPTION]
homepage=http://www.your.home.page.com

notice=http://www.your.home.page.com

Reg_IE_Size=712,452

IE_Main=

[IPLIST]
ServerCount=1


ServerName1=Your Server Name
ServerAddr1= [SIZE="3"][COLOR="Red"][B]Change me[/B][/COLOR][/SIZE]
Method1=0
Reg1=http://www.your.home.page.com/register/page.html
port1=1300

_________________________________________________________________________________
-----------------------------------|English patch|-------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Step 1
patching for 70% english

1) Open your english SoF client folder
2) Copy YBmsg.cfg
3) Open your private Client folder
4) Paste YBmsg.cfg

Step 2
GUI

1) Open your english SoF Data folder
2) Copy interface folder
3) Open your private Data folder
4) Paste interface folder

 

[jemelm]

Re: [Guide] MySQL Scions of Fate Private

nice one.. i follow your guide and now my server run smooth.. I want the client Please can u give me the direct link of the client.. Big Thanks!

 

[patrat]

Re: [Guide] MySQL Scions of Fate Private

thanks for input

client posted

ooh and if u make a public server i would appretiate it if u credited this site not me but this site in general i hate it when ppl make servers and dont share where they got it from i mean come on theres no reason not to help other ppl make a server its not like we are competing for the best server

also if u figure crud out i would love to know

heres some stuff i found out

editing weapons
attribute 1 is rubys
attribute 2-5 are gems

1010001912 in atribute 1 is atk [12] fire 10
1020001912 " " " is def [12] fire 10

70000999 in atribute 2-5 is SA 999%
20000999 " " " -" is def 999

this server changing the lvl will adjust the exp

fld_justice 1= order 2=choas 0= none/both

 

[KINGDAVID1]

Re: [Guide] MySQL Scions of Fate Private

nice, tnx!
could you give us also link for website working with mysql?

 

[patrat]

Re: [Guide] MySQL Scions of Fate Private

im working on making 1 but i think there was a chinese 1 ill see if i can find it


also i forgot to add the ports u need to open for public but if ur not an idiot u could figure it out but i should of posted it


Ports: 1300, 13001, 13000, 3306

i think

 

[playforfun]

Re: [Guide] MySQL Scions of Fate Private

no!no!no! don't port forward 3306! it's dangerous! @@"
haha, just kidding
Anyway, 3306 is MySQL port.
Port it if you wish your MySQL port expose to outsider(WAN MySQL incoming source, which is dangerous and might lead to hacker that trying to brute force your MySQL server. Use it only if you're really want external MySQL incoming source(connecting MySQL server using MySQL query browser or any MySQL Query-ing things from WAN source.))

1300 is Login Server port
13000(channel 1) to 13009(channel 10) is game server port
9000 is for cash web shop(not sure RXJH server for MySQL needed or not ~"~)


Anyway, nice guide but the launcher looks like same as mine last time I post up on last time haha

 

[joebabecom]

Re: [Guide] MySQL Scions of Fate Private

Thank. it work for me.

 

[playg]

Re: [Guide] MySQL Scions of Fate Private

nvm delete this please

 

[uyung93]

Re: [Guide] MySQL Scions of Fate Private

nice guide man! it work!

 

[sonbui]

Re: [Guide] MySQL Scions of Fate Private

do we have to download all 4 of the Client/Patch?
and when i open login server and game server with my wanip it says cant connect to mysql server.
when i open login server and game server with my dns webadress it says unknown mysql
since those didnt work i tryed hamachi and it said that hamachi is not allow to connect through the mysql server can anyone help me?
the only way to make it work is by puting 127.0.0.1
but that only makes i can play >.>

 

[spydogg21]

Re: [Guide] MySQL Scions of Fate Private

ok well i have it and its working and everything but i cant make an account and the web side isnt connecting to the SQL can you help?

 

[sonbui]

Re: [Guide] MySQL Scions of Fate Private

ok well i have it and its working and everything but i cant make an account and the web side isnt connecting to the SQL can you help?

to make an account u have to go to navicat then rxjh account
then tbl_account.
then a new window will come up.
FLD_ID = username
FLD_PASSWORD = password
FLD_SEX = gender (for male put 1)(for female put 0 or 2)

but i still need help with the mysql problem >.>

 

[spydogg21]

Re: [Guide] MySQL Scions of Fate Private

ok so now its working but how can i get it all translated?

 

[Yuio]

Re: [Guide] MySQL Scions of Fate Private

i need some help when i run my LoginServer.exe and gameserver.exe it wont work and it always say [host:my ip is not allow to connect to MySQL server] can some one help me?

 

[sonbui]

Re: [Guide] MySQL Scions of Fate Private

i need some help when i run my LoginServer.exe and gameserver.exe it wont work and it always say [host:my ip is not allow to connect to MySQL server] can some one help me?

same thing happan to me

 

[ichigo580]

Re: [Guide] MySQL Scions of Fate Private

how are you supposed to make it english? do you have to download the client from netgame and replace the files into the chinese client?

 

[patrat]

Re: [Guide] MySQL Scions of Fate Private

ull need to open up ur ports and test them to make sure that they are open if u use utorrent thy got a good port tester

and if any of u know php u could make a web site i was working on 1 but i lost interest

 

[wiri]

Re: [Guide] MySQL Scions of Fate Private

I dont connect to server :S

Help me pls
​

 

[chrisfisher]

Re: [Guide] MySQL Scions of Fate Private

hi this dnt work on that navicat

Connection Name: PrivateSoF

Host name/ IP address: 127.0.0.1 (or localhost)

Port: 3306

User name: root

Password: 123456 (or what ever u choice in step 1 part 5)

 

[spydogg21]

Re: [Guide] MySQL Scions of Fate Private

no one has a way to get the launcher and servers translated to english?