V14 setup guide & Other Releases (Tools)

[BGxApixen]

Things you need:
MSSQL 2005
FlyFF v14 Server Files - Repack posted SeriusUriel
AllInOne Database posted by SeriusUriel
Video Guide to set up ODBC's posted by SeriusUriel
Official eFlyFF Downloader (Installer) by Aneosoft & Gpotato


Setting up MSSQL
1. Install MSSQL (Make sure 'Hide advanced configuration' IS checked.) until it comes to the Mode to select.
2. Make sure "Management Studio Express" Is being installed on hard drive.
3. Select 'Mixed Mode' and enter a password and also repeat it to verify.
4. Go freely through the installation without changing anything and you've now completed installing MSSQL. Run MSSQL and type your infomation
Username: (Often root) sa
Password: What you typed in.


Executing the Databases
You will need the AllInOne database posted by SeriusUriel.

Open the SQL file using Notepad, Wordpad, or any other word document opener. Copy the whole file (Text) and select 'New Query' in MSSQL and paste the file inside.
You will gain an Error saying: "Cannot drop Table_Name because it didn't exist or you do not have the permission". That will be normal, it only comes up because it doesn't exist at the moment, ignore it. You will gain a message from SeriusUriel IN the error.


Setting up the v14 files.
Note: Spoilers ahead containing pictures & Text[Picture Guide & Word Guide]


Picture Guide

Spoiler:

First, Follow this guide EXACTLY. Read text in pictures at ALL times.

Spoiler:

Spoiler:

Spoiler:

Spoiler:

Spoiler:

Spoiler:

Spoiler:

Word Guide

Spoiler:

How to set up the files.

1. Extract the files using WinRAR.
2. Go into "Programs".
3. Open
AccountServer.ini

Spoiler:

TEST
AddTail( -1, 1, "Test(you may change the Cluster name)", "Your IP", 0, 1, 0 );
AddTail( 1, 1, "Channel(you may change the Channel name) 1-1", "Your IP", 0, 1, 600 );

DSN_NAME_LOGIN "login"
DB_ADMIN_ID_LOGIN "login"

DSN_NAME_LOG "log01"
DB_ADMIN_ID_LOG "log01"

MSG_VER "20070712"

DB_PWD_LOGIN "MSSQL Password"
DB_PWD_LOG "MSSQL Password"

Certifier.ini

Spoiler:

Account "127.0.0.1"
DSN_NAME_LOGIN "login"
DB_PWD_LOGIN "MSSQL Password"

Next, Open the "Script" Folder.

DatabaseServer.ini

Spoiler:

NOTE: ResourceFolder MUST be yours. EX:
C:\Users\Name\Documents\Name\Neurospace\v14\v14\V14\Resource



ResourceFolder "Your Resource Folder"

Sys 1

Account "127.0.0.1"

DSN_NAME_CHARACTER "character01"
DB_ADMIN_ID_CHARACTER "character01"

DSN_NAME_LOG "log01"
DB_ADMIN_ID_LOG "log01"

LANG 1

DB_PWD_LOG "MSSQL Password"
DB_PWD_CHARACTER ""
DB_PWD_BACKEND ""
DB_PWD_ITEMUPDATE ""

WorldServer.ini

Spoiler:

NOTE: ResourceFolder MUST be yours. EX:
C:\Users\Name\Documents\Name\Neurospace\v14\v14\V14\Resource


Sys 1
ResourceFolder "Your Resource Folder"
Key 101
DB "127.0.0.1"
Core "127.0.0.1"
LANG 1
18
Heartbeat 10101
GUILDWAR 1
GUILDBANK 1
WORMON 1
DROPITEM_REMOVE 0
GUILDCOMBAT 1
ARENA 1
SCHOOL 0
PK 1
STEAL 0
PKCOST 1
RECOMMEND 0
RAINBOWRACE 0
SECRETROOM 1
GUILDCOMBAT1TO1 1

You have now set up the Configuration Settings and can now complete the server and turn on the server in Number Order:

1. AccountServer.exe
2. DatabaseServer.exe
3. CoreServer.exe
4. Certifier.exe
5. LoginServer.exe
6. CacheServer.exe
7. WorldServer.exe_Fixed

Other Releases

Credits to aldieri for the links
Flyff ResEditor
Microsoft Excel+Word 2003
FlyFF o3d Converter
The Compressonator 1.50 x64
The Compressonator 1.50 x32
DYO Manager
Default .o3d's and a Template for making new cloaks. (Only Use if Needed)

Current Guides:
How to add a server/channel.
How to add a Box.
How to Add a Custom Cloak.
How to Make .o3d from .dds files.
How to convert .png to .dds.
How to add a buff pang.

How to add a server/channel - Credits to lmanso

Spoiler:

Original Thread:
http://forum.ragezone.com/f457/how-t...server-627687/



Hi Ragezone

P.S. THIS GUILD IS FOR SOMEONE WHO UNKNOWN

STEP 1
Open AccountServer.ini and look down this

AddTail( -1, 1, "Test", "192.168.1.2", 0, 1, 0 );
AddTail( 1, 1, "Channel 1-1", "192.168.1.2", 0, 1, 600 );

Purple = Server number
Blue = Channel number
DarkRed = Server / Channel Name
Red = IP server

You just add new line like this

AddTail( -1, 1, "Test", "192.168.1.2", 0, 1, 0 );
AddTail( 1, 1, "Channel 1-1", "192.168.1.2", 0, 1, 600 );
AddTail( 1, 2, "Channel 1-2", "192.168.1.2", 0, 1, 600 );

and if you want to add news server look down this

AddTail( -1, 1, "Test", "192.168.1.2", 0, 1, 0 );
AddTail( 1, 1, "Channel 1-1", "192.168.1.2", 0, 1, 600 );
AddTail( -1, 2, "Ladake", "192.168.1.2", 0, 1, 0 );
AddTail( 2, 1, "Ladake-1, "192.168.1.2", 0, 1, 0 );

Red = Number of server
DarkGreen = Server / Channel name
Indigo = Number of server

P.S You can change ip to another computer ip that make you run 2 computer

STEP 2
Open CoreServer.ini and look down this

Sys		"1"
Database	"192.168.1.2"
PartyExpRate	"1"



101
{
	1	0	0	30	30	00	00
	2	0	0	5	5	00	00
	3	0	0	3	3	00	00
	200	0	0	5	5	00	00
	201	0	0	5	5	00	00
        210	0	0	1	1	00	00 
        220	0	0	1	1	00	00 
        230	0	0	1	1	00	00 
        202	0	0	5	5	00	00 
	204	0	0	5	5	00	00
	205	0	0	2	2	00	00
	203	0	0	3	3	00	00
	206	0	0	2	2	00	00         
	207	0	0	2	2	00	00
        208	0	0	2	2	00	00
        241	0	0	1	1	00	00
        242	0	0	1	1	00	00
        243	0	0	1	1	00	00
        244	0	0	1	1	00	00
	21	0	0	1	1	00	00
	22	0	0	1	1	00	00
	23	0	0	1	1	00	00
	24	0	0	1	1	00	00
	25	0	0	1	1	00	00
	121	0	0	5	5	00	00
	122	0	0	5	5	00	00
	209	0	0	1	1	00	00
	151	0	0	2	2	00	00
	152	0	0	2	2	00	00
	153	0	0	2	2	00	00
	154	0	0	2	2	00	00
	155	0	0	2	2	00	00
	156	0	0	2	2	00	00
	157	0	0	2	2	00	00
	158	0	0	2	2	00	00
	159	0	0	2	2	00	00
	160	0	0	2	2	00	00
	161	0	0	2	2	00	00
	162	0	0	2	2	00	00
	163	0	0	2	2	00	00
	164	0	0	2	2	00	00
	165	0	0	2	2	00	00
	166	0	0	2	2	00	00
	167	0	0	2	2	00	00
}

Red = Server number
DarkRed = Key port

And now you just add like this

Sys		"1"
Database	"127.0.0.1"
PartyExpRate	"1"



101
{
	1	0	0	30	30	00	00
	2	0	0	5	5	00	00
	3	0	0	3	3	00	00
	200	0	0	5	5	00	00
	201	0	0	5	5	00	00
        210	0	0	1	1	00	00 
        220	0	0	1	1	00	00 
        230	0	0	1	1	00	00 
        202	0	0	5	5	00	00 
	204	0	0	5	5	00	00
	205	0	0	2	2	00	00
	203	0	0	3	3	00	00
	206	0	0	2	2	00	00         
	207	0	0	2	2	00	00
        208	0	0	2	2	00	00
        241	0	0	1	1	00	00
        242	0	0	1	1	00	00
        243	0	0	1	1	00	00
        244	0	0	1	1	00	00
	21	0	0	1	1	00	00
	22	0	0	1	1	00	00
	23	0	0	1	1	00	00
	24	0	0	1	1	00	00
	25	0	0	1	1	00	00
	121	0	0	5	5	00	00
	122	0	0	5	5	00	00
	209	0	0	1	1	00	00
	151	0	0	2	2	00	00
	152	0	0	2	2	00	00
	153	0	0	2	2	00	00
	154	0	0	2	2	00	00
	155	0	0	2	2	00	00
	156	0	0	2	2	00	00
	157	0	0	2	2	00	00
	158	0	0	2	2	00	00
	159	0	0	2	2	00	00
	160	0	0	2	2	00	00
	161	0	0	2	2	00	00
	162	0	0	2	2	00	00
	163	0	0	2	2	00	00
	164	0	0	2	2	00	00
	165	0	0	2	2	00	00
	166	0	0	2	2	00	00
	167	0	0	2	2	00	00
}

201
{
	1	0	0	30	30	00	00
	2	0	0	5	5	00	00
	3	0	0	3	3	00	00
	200	0	0	5	5	00	00
	201	0	0	5	5	00	00
        210	0	0	1	1	00	00 
        220	0	0	1	1	00	00 
        230	0	0	1	1	00	00 
        202	0	0	5	5	00	00 
	204	0	0	5	5	00	00
	205	0	0	2	2	00	00
	203	0	0	3	3	00	00
	206	0	0	2	2	00	00         
	207	0	0	2	2	00	00
        208	0	0	2	2	00	00
        241	0	0	1	1	00	00
        242	0	0	1	1	00	00
        243	0	0	1	1	00	00
        244	0	0	1	1	00	00
	21	0	0	1	1	00	00
	22	0	0	1	1	00	00
	23	0	0	1	1	00	00
	24	0	0	1	1	00	00
	25	0	0	1	1	00	00
	121	0	0	5	5	00	00
	122	0	0	5	5	00	00
	209	0	0	1	1	00	00
	151	0	0	2	2	00	00
	152	0	0	2	2	00	00
	153	0	0	2	2	00	00
	154	0	0	2	2	00	00
	155	0	0	2	2	00	00
	156	0	0	2	2	00	00
	157	0	0	2	2	00	00
	158	0	0	2	2	00	00
	159	0	0	2	2	00	00
	160	0	0	2	2	00	00
	161	0	0	2	2	00	00
	162	0	0	2	2	00	00
	163	0	0	2	2	00	00
	164	0	0	2	2	00	00
	165	0	0	2	2	00	00
	166	0	0	2	2	00	00
	167	0	0	2	2	00	00
}

DarkGreen = This is Channel 2 key port And channel 3 is 301 channel 4 is 401..................

and if you need to add server you gotna copy all thing of CoreServer to new folder and then open CoreServer.ini (The new one) and Edit this

Sys		"2"
Database	"192.168.1.2 if you run on 2 computer just change this ip"
PartyExpRate	"1"



102
{
	1	0	0	30	30	00	00
	2	0	0	5	5	00	00
	3	0	0	3	3	00	00
	200	0	0	5	5	00	00
	201	0	0	5	5	00	00
        210	0	0	1	1	00	00 
        220	0	0	1	1	00	00 
        230	0	0	1	1	00	00 
        202	0	0	5	5	00	00 
	204	0	0	5	5	00	00
	205	0	0	2	2	00	00
	203	0	0	3	3	00	00
	206	0	0	2	2	00	00         
	207	0	0	2	2	00	00
        208	0	0	2	2	00	00
        241	0	0	1	1	00	00
        242	0	0	1	1	00	00
        243	0	0	1	1	00	00
        244	0	0	1	1	00	00
	21	0	0	1	1	00	00
	22	0	0	1	1	00	00
	23	0	0	1	1	00	00
	24	0	0	1	1	00	00
	25	0	0	1	1	00	00
	121	0	0	5	5	00	00
	122	0	0	5	5	00	00
	209	0	0	1	1	00	00
	151	0	0	2	2	00	00
	152	0	0	2	2	00	00
	153	0	0	2	2	00	00
	154	0	0	2	2	00	00
	155	0	0	2	2	00	00
	156	0	0	2	2	00	00
	157	0	0	2	2	00	00
	158	0	0	2	2	00	00
	159	0	0	2	2	00	00
	160	0	0	2	2	00	00
	161	0	0	2	2	00	00
	162	0	0	2	2	00	00
	163	0	0	2	2	00	00
	164	0	0	2	2	00	00
	165	0	0	2	2	00	00
	166	0	0	2	2	00	00
	167	0	0	2	2	00	00
}

Navy = Server number
Red= Channel Key port for server 2 ( channel 2 is 202 ,Channel 3 is 302 .. . ..........)

STEP 3(FOR ADD NEW SERVER IF NOT ADD NOT DO IT)
Open loginserver.ini and add this line like this

DB		"192.168.1.2" <---- If you use 2 computer change this ip on computer 2
Core		"192.168.1.2" 


AddCache( "192.168.1.2" );
AddCache( "192.168.1.9" ); <--- Add this line and put another computer ip if use 1 not do this guide same computer 1 and computer 2 gotna have same


MSG_VER		"20070712"

STEP 4
copy all of wordserver ting and create new folder and past on it and than OPEN WorldServer.ini(on new folder) and look down this

Sys		1
ResourceFolder	"C:\V14\Resource"
Key		101
DB		"192.168.1.2"
Core		"192.168.1.2"
LANG		1
18
Heartbeat	10101

[COLOR="rgb(139, 0, 0)"]DarkRed[/COLOR] = server number
Red = Key port for channel

Example 1. I need to add channel 2 and key port is 201:

Sys		1
ResourceFolder	"C:\V14\Resource"
Key		201
DB		"192.168.1.2"
Core		"192.168.1.2"
LANG		1
18
Heartbeat	10101
GUILDWAR 1
GUILDBANK 1
WORMON 1
DROPITEM_REMOVE 0
GUILDCOMBAT 1
ARENA 1
SCHOOL 0
PK 0
STEAL 0
PKCOST 1
RECOMMEND 0
RAINBOWRACE 0
SECRETROOM 1
GUILDCOMBAT1TO1 1

Example 2. I need to add channel on server 2

Sys		2
ResourceFolder	"C:\V14\Resource"
Key		102
DB		"192.168.1.2"
Core		"192.168.1.2"
LANG		1
18
Heartbeat	10101
GUILDWAR 1
GUILDBANK 1
WORMON 1
DROPITEM_REMOVE 0
GUILDCOMBAT 1
ARENA 1
SCHOOL 0
PK 0
STEAL 0
PKCOST 1
RECOMMEND 0
RAINBOWRACE 0
SECRETROOM 1
GUILDCOMBAT1TO1 1

Example for who use 2 computer to run. I need to add channel 2

Sys		1
ResourceFolder	"C:\V14\Resource"
Key		201
DB		"192.168.1.2" Change this to host ip
Core		"192.168.1.2" Change this to host ip
LANG		1
18
Heartbeat	10101
GUILDWAR 1
GUILDBANK 1
WORMON 1
DROPITEM_REMOVE 0
GUILDCOMBAT 1
ARENA 1
SCHOOL 0
PK 0
STEAL 0
PKCOST 1
RECOMMEND 0
RAINBOWRACE 0
SECRETROOM 1
GUILDCOMBAT1TO1 1

How to runserver
1.AccountServer.exe
2.DatabaseServer.exe
3.CoreServer.exe
4.Certifier.exe
5.LoginServer.exe
6.CacheServer.exe
7.WorldServer.exe
8.WorldServer Channel2.exe

or if you add new server

1.AccountServer.exe
2.DatabaseServer.exe
3.CoreServer.exe
4.CoreServer Server2.exe
5.Certifier.exe
6.LoginServer.exe
7.CacheServer.exe
8.WorldServer Channel 1 for server 2.exe

How to runserver for who use 2 computer
On computer 1 Run normal
and run this on computer 2
1.loginserver.exe
2.CacheServer.exe ( In .ini files change ip to host server)
3.WorldServer.exe

Enjoy for it and try to do it ^^

How to add a Box (Example is adding Ancient Box, randomly gives user ancient weapon.)- Credit to aldieri.

Spoiler:

1) Open Propitem.txt(2megsish) Preferred Program: Microsoft Excel.
Search for: II_SYS_SYS_SCR_BXANGEL01
Copy Fields: A - DT from BXANGEL01
Add what you copied to the bottom of the file. in a new row.
Edit:(In the row you added.) II_SYS_SYS_SCR_BXANGEL01 to II_SYS_SYS_SCR_BXANCIENT01

Close and Save (For Now)

2) Open Propitem.txt.txt (The one that contains names and descriptions.)
Scroll to the very bottom.
Add the item (Ancient Box)
Add a discription.
Example:
IDS_PROPITEM_TXT_011300 Ancient Box
IDS_PROPITEM_TXT_011300 Gives a Random Ancient Weapon.
Close and save.
(Remember don't use the same number twice!!!)

3) Open Propitem.txt (2megish) Preferred Program: Microsoft Excel.
find your added 'BXANCIENT01'
Make sure your 'C' field (Using Excel) Matches the Propitem.txt.
Make sure your 'DT' field matches the Propitem.txt one as well.
Example:
C= IDS_PROPITEM_TXT_011300
DT=IDS_PROPITEM_TXT_011300

4) Open propGiftbox.inc
search for BXLEAGENDG01
after it add

GiftBox II_SYS_SYS_SCR_BXANCIENT01
{
	II_WEA_SWO_ANCIENT			500	1
	II_WEA_SWT_ANCIENT			1500	1
	II_WEA_AXE_ANCIENT			300	1
	II_WEA_AXT_ANCIENT			1700	1
	II_WEA_KNU_ANCIENT			1000	1
	II_WEA_CHE_ANCIENT			1000	1
	II_WEA_WAN_ANCIENT2			1000	1
	II_WEA_STA_ANCIENT			1000	1
	II_WEA_BOW_ANCIENT			300	1
	II_WEA_YOY_ANCIENT			1700	1
}

Save this file.

5) Open Defineitem.h
Go to the very end.
before #endif
add
#define II_SYS_SYS_SCR_BXANCIENT01 65000
Remember don't use the same number twice!!!
Save.

Then you'll need to add propitem.txt and propitem.txt.txt along with Defineitem.h to your datares's

How to Add a Custom Cloak. - Credit to aldieri

Spoiler:

1. Open mdlDyna.inc (Full screen/Maximize.)
a) Search for cloak you'll see a block of text under it.
b) We want to add a cloak. So go to the blink space
c) After II_ARM_S_CLO_CLO_SYSCLOAK20
d) Add

    "GenMatSuitbox"    II_ARM_S_CLO_CLO_BETA                MODELTYPE_MESH "maleCloakBeta/femaleCloakBeta"               0 MD_NEAR 0  1.0f 0 1 ATEX_NONE 1

----------------remember we are adding --Beta Cloak--
------Also Note that you will need to add the .o3d in Flyff>Model and the .dds files in Flyff>Model>Texture Flyff>Model>TextureLow and Flyff>Model>TextureMid-----
--the "maleCloakBeta/femaleCloakBeta" Determines which .o3d file your client reads.

Close and save that mdlDyna.inc.

2. Open DefineItem.h with notepad.
a) Search for cloak.
b) After #define II_ARM_S_CLO_CLO_SYSCLOAK20
c) Add #define II_ARM_S_CLO_CLO_BETACLOAK 65001
d) Just make sure the (65001) is something NOT used in this file.
e) Close and save.

Next up.

3. Open propitem.txt (2 megs) Preferred Program: Microsoft Excel
a) Search for II_CHR_S_CLO_CLO_STRONG.
b) Copy this row. A-DT.
c) Go to the end of the table and paste the line.
d) Change the name to a name you want we'll use BETA.
c) B will be II_CHR_S_CLO_CLO_BETA
d) You will need to change field 'c' to the number you changed it to in propitem.txt
e) In this case it will be IDS_PROPITEM_TXT_011302
f) BB, BC and BD are all stats that can be used on cloaks.
g) Change these accordingly to change the stats BB links to BE, BC Links to BF and BD links to BG.
h) You'll have to scroll over to DQ this is where we will determine the icon(this is what it will look like in your inventory) for the item. For this it will be "Itm_ArmCloCloStrong.dds" (This is an example.)
i) DT will then be the 'description you put in propitem.txt.txt' in this case it will be IDS_PROPITEM_TXT_011303.

How to Setup .o3d to work with custome .dds files. - Credit to aldieri.

Spoiler:

1. You'll need the .o3d converter from the links above.
b. Open the .o3d converter, for the sake of this guide i'll be using the Dragon cape .o3d files to make them work for your brand new cloak.
c. Search for Part_mDragoncape and Part_fDragoncape in your Model folder. (Copy and paste these somewhere easy)
d. With the o3d converter you'll now click 'File Load.o3d' (Load the ones from the step above)
e. You'll then go to Misc. 'Load DDS' (Then find the cloak you made, HAS TO BE .DDS If not look at the next guide.)
f. Then check and make sure in the Misc. Menu that Animated is checked.
g. Then go to File, save O3D, save it where its easily accessible make sure its named Part_maleCloak*NAME*, like in the guide above I used Part_maleCloakBeta.
h. You'll need need to place the .o3d in your client and server files and make sure the .dds you loaded(WITH THE SAME NAME) are in the Model Texture folders.

How to convert .png to .dds - credit to aldieri

Spoiler:

1. Open The Compressonator 1.50
a. Go to 'File Open'
b. Find your .png file that you made as your cloak.
c. Go to the menu 'Compress' You'll be using ATI 3Dc Compression.
d. The texture format used will be DXT3.
e. LEAVE THE REST DEFAULT
f. Click compress.
g. Go to 'File' then 'Save Compressed' then pick a name In the guide above I used Part_maleCloak*Name*.
Example:
Ex. 1) Part_maleCloakBeta
Ex. 2) Part_maleCloakTest

h. After you save it find where you placed it, if you want the female cloak to look the exact same, copy the .dds you just made paste it and rename the copy to Part_femaleCloak*name*.

How to EDIT a buff pang - Credits to ecKo9321

Spoiler:

Original Thread:
http://forum.ragezone.com/f457/buff-...1/#post5392700


Hi.

Today I'll show you how to change Buff Pang's LEVEL REQ and BUFF LEVEL

STEP 1:
Open with your FlyffResEditor datasub1.res from your Client;

STEP 2:
Search "Character.inc" and extract it on your desktop;

STEP 3:
Open it with your Notepad, and search [Ctrl+F] for "MaFl_Helper_ver12" (no quotes);

STEP 4:
Editing ~

Now change the BLUE and RED numbers:

Blue ~ Skill level
Red ~ Level Req

MaFl_Helper_ver12
{
	setting
	{
		AddMenu( MMI_DIALOG );
		AddMenu( MMI_NPC_BUFF );
//		( SKILL ID, 스킬레벨, 가능한 플레이어 최소, 최대 레벨, 지속시간(ms) )
		SetBuffSkill( SI_ASS_CHEER_QUICKSTEP, 7, 1, 60, 3600000 );
		SetBuffSkill( SI_ASS_CHEER_HASTE, 7, 1, 60, 3600000 );
		SetBuffSkill( SI_ASS_CHEER_HEAPUP, 7, 1, 60, 3600000 );
		SetBuffSkill( SI_ASS_CHEER_ACCURACY, 7, 1, 60, 3600000 );
		SetBuffSkill( SI_ASS_CHEER_CATSREFLEX, 7, 1, 60, 3600000 );
		SetBuffSkill( SI_ASS_CHEER_BEEFUP, 7, 1, 60, 3600000 );
		SetBuffSkill( SI_ASS_CHEER_MENTALSIGN, 7, 1, 60, 3600000 );	
		SetBuffSkill( SI_ASS_CHEER_CANNONBALL, 7, 1, 60, 3600000 );
		SetImage
		(
			IDS_CHARACTER_INC_000703
		);
		m_szDialog= "MaFl_Helper.txt";
	}

TO

MaFl_Helper_ver12
{
	setting
	{
		AddMenu( MMI_DIALOG );
		AddMenu( MMI_NPC_BUFF );
//		( SKILL ID, 스킬레벨, 가능한 플레이어 최소, 최대 레벨, 지속시간(ms) )
		SetBuffSkill( SI_ASS_CHEER_QUICKSTEP, 20, 1, 121, 3600000 );
		SetBuffSkill( SI_ASS_CHEER_HASTE, 20, 1, 121, 3600000 );
		SetBuffSkill( SI_ASS_CHEER_HEAPUP, 20, 1, 121, 3600000 );
		SetBuffSkill( SI_ASS_CHEER_ACCURACY, 20, 1, 121, 3600000 );
		SetBuffSkill( SI_ASS_CHEER_CATSREFLEX, 20, 1, 121, 3600000 );
		SetBuffSkill( SI_ASS_CHEER_BEEFUP, 20, 1, 121, 3600000 );
		SetBuffSkill( SI_ASS_CHEER_MENTALSIGN, 20, 1, 121, 3600000 );	
		SetBuffSkill( SI_ASS_CHEER_CANNONBALL, 20, 1, 121, 3600000 );
		SetImage
		(
			IDS_CHARACTER_INC_000703
		);
		m_szDialog= "MaFl_Helper.txt";
	}

STEP 5:
Now save the "Character.inc" and replace/put it on datasub1.res and your Resource Folder

YOU ARE DONE

Hope is USEFULL !
Happy FlyFFing <3

Cash shop page - Credits to Alexsh.

Spoiler:

Original Topic:
http://forum.ragezone.com/f457/offic...4/#post5451270


I've provided a few updates to the shop, and i've decided to release a more updated version. I also have found out that it only seems to work with wampserver, so read my guide on how to enable mssql on wampserver if you use xampp. ;)

Updates:
-Red Scroll changed to the attention item.
-Query to insert the red scroll into the shop database
-Query to add dPoints to your account (Secure PHP Script coming soon)
-Updated .png icons with transparent backgrounds.

Coming Soon:
-Send Gift Function Working [Not Yet Done]
-Secure PHP Add dPoint PHP Script

How to use:
First make a new column in your ACCOUNT_TBL named 'dpt'.
Second, execute the shop SQL into your Account database.
Third, edit the configuration file.
Finally, you can change what items are in the shop using the shop table. **Please note, this shop does not send items based on item ids, but based on the item names, therefore you have to type the correct, and exact name under the name column. This shop, as oppose to the old one inserts the item directly into the character's inventory as oppose to their mailbox.

If you decide to use this shop, thank me.

Edit: This shop also has an anti sql injection script that protects you from basic sql injections.


UPDATED Link: HERE

Update: Check out the inside of the shop
character: Root
username: root
password: root
Shop Login: HERE

Credits to aldieri for much of the credit code.


Credits:
Making the word & picture guide for v14 files - Apixen
Posting the AllInOne Database and repack - SeriusUriel
Cash shop online - Alexsh
exos58          - FlyFF ResEditor
Microsoft       - Excel + Word.
pipelli         - O3d Converter 
AMD             - The Compressonator
Kimmy Andersson - DYO Manager
GalaNet         - FlyFF
GlaphanKing     - For compiling the server file thread and keeping our wonderful FlyFF section going.
AllinOne DB     - Don't know the name (If someone finds the original poster let me know.)
ServerFiles     - ????? (Don't know the name for these files.)
How to add a channel/sever - lmanso
How to add a buff pang - ecKo9321
----If I forgot anyone just let me know.----

If I missed any credits, or information, please let me know.

-Apixen

[MentaL]

[Alexsh]

Thanks for the credits (:

[Improved]

It tells me, when i put in CHARACTER_01_DBF in the ODBC, databse not found. I looked in the Databse at mssmse, theres only the master, model, msdb, tempdb, what am i gonna do?

[blinked]

Great bundle of guides. :)

[aldieri]

Someone already 'compiled' 'guides'.

Edit: I also won't be checking this thread to help anyone using any one of my guides.

[manneke]

It's not adding a buff pang, but just changing his buffs.

[aldieri]

It's not adding a buff pang, but just changing his buffs.

Yeah, you have to use the DYO manager to add an npc. I'll add a guide to my list later..

[newage]

Thank you for teaching I need how to add Quest
Please forgive poor English :(

[heyheyloga]

can someone please help me make a patcher or helme with the hex editor!!
add me owesome_02@yahoo.com YM MSN

[Zakhary]

I have a problem with MSSQL installation. It dails in some points dunno why. I have installed first Management Studio Express too and can't connect there.
I can't finish that MYSQL 2005 installtion. Any ideas?

[Hells]

got penya hack fix ? :)

[wisp66]

SerusUriel created the all in one db ^^

---------- Post added at 12:09 PM ---------- Previous post was at 12:02 PM ----------

SerusUriel hes also the creator of the repack for heathj's server files release i could be wrong tho

[flashdeddy]

can u tell me what i must do with this error??

2010/ 1/11 00:24:51 OP: 15726047, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


2010/ 1/11 00:24:52 OP: 1264, 0.0, 0.0, 1262.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


2010/ 1/11 08:51:08 OP: 269774, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


2010/ 1/11 08:51:26 OP: 17255, 0.0, 0.0, 17253.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


2010/ 1/11 08:51:33 OP: 7057, 0.0, 0.0, 0.0, 0.0, 0.0, 7055.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


thx b4..

[imnotfake0991]

You should change the buff pang to say How To Edit.. Not How To ADD

[flashdeddy]

it doesn't work..
i have to delete the dialog from buff pang.. but it still don't change the error..

maybe i wrong set that..
can u give me specific step to fix it?

[wisp66]

here try this one its lvl 20 buffs with lvl 10 req tell me if that helps make sure its one in resource folder and 1 in the datasub1 heres link

[xooo123]

When I Install the Microsoft sql server.... It Does and Error! :(
The Sql server database service, MSXML6, Sql Server Management Studio Express, and Workstation Components,Books onlin.... Setup Failed! Please Someone help me.... :(
tianpaul_pp2 is my ym... and please teach me...

[flashdeddy]

it same as my character.inc
so what i must do??

[ianjawel]

tnx for your guide.........but when i install microsoft sql 2005 and in the last step when i click install it will stock and it restart my computer i dont know whats wrong if my computer or the microsoft sql 2005 installation....... plsss help me

[Detox]

*Thanked* il make my server v14 now :)

[Emc]

Thx for this thread i did everything but ma Server list is coming Empty , there is no error in error log files do you have any idea ...

[BGxApixen]

Thx for this thread i did everything but ma Server list is coming Empty , there is no error in error log files do you have any idea ...

Make sure you have the correct IP, and you have a server name, AND it connects to what ever it needs to connect TO.

[Jessert777]

hm I can connect to my char but when I hit next, it says: "Cannot connect to the server. Please check your network."

This is my Error.log

Spoiler:

2010/ 1/24 15:25:07
CDPCoreClient.OnJoin: server not found id: 1 account: jesse player: Jesse world: 1

[flashdeddy]

Error converting data type numeric to int

i get that's error in error log and cquery
any suggest??

[FullmetalRF]

how to fix KS Bug
Anyone can help me please?

thx vm

All KS MOBS =;/

Help PLSS