Private server tutorials

[trane.]

Originally Posted by Zombe

hmm, trane COULD quote my tutorial or add a link to it. I mean the one on how to change default stuff (check my sig).
Cuz I feel that tutorial will be forgotten soon.

Your tutorial added

[lolly0001]

Originally Posted by trane.

Yo,

Since some people were begging to do this, and since here are many new threads everyday (mostly questions) I decided to make this threads before I leave..

In this thread I will paste few tutorials posted by other people, no, not to leech, to make it faster for you to find what you need, and because you can't find it sometimes by search button. And searching it in each page is a bit bothering, isn't it? Well, so let's go.

I will paste each tut in ''code''

so example if you want to get Death lands on list on Braiken 1 teleporter you have to:

1) Go to location.csv (share/arrange/) and there find Death lands. That is the place where you want to teleport when you click on teleport button on your teleporter.
There is like 5-10 death lands which to chose?
If you look better there are coordinates of each so on what coords do you want to teleport, you chose that one. Remember the index number (entrance of Death Lands is index number 11220)
2) So now go to teleport (/share/arrange)
2008-09-2911:44,Teleport_StringIndex,UnitCount,UnitIndex_1,LocationIndex_1,String_1,Cost_1,Level_1


[B]Teleport_StringIndex
[How to give items/stats by default ] - Written by @ Zombe

	
	
Have you ever wanted to give an item(s) to every character as soon as it is created?
Well, I am here to show you how!

First we will open up the MSSQL's Enterprise Manager, and we will take a lot at the user_character table in the character database.
Have you ever noticed the [DEV] characters in there? Well, that is what we are looking for. They all have an user_no of 19999999999991, so you can find them by searching for that user_no in user_character table.

Ok, first lets take a look at their names.
[DEV]KNIGHT, [DEV]HUNTER, [DEV]MAGICIAN , etc. Obviously a char for each class.

Lets take a look at the stats of [DEV]KNIGHT. 6 str, 3 dex, 4 con, 2 spr. Nothing special. Except... Wait, aren't these the stats that all knights have when the chart is created by default? Yes, they are! So what if we would change all those stats to lets say 2000, save and then create a character?
WOW! My newly created character has 2k stats!

Ok, so that is the method how to customize the character, like starting level, starting health, starting shield, etc. You can make it different for each class, if you want.

Ok, but how about items, you ask?

I will do it so that the items would be equipped by default.
So lets go to user_suit, but leave user_character table open.
Lets say we are customizing a knight. Note the character no of [DEV]KNIGHT, that is DEKARON0000001.
Lets find that in the user_suit table. Ok, we found it. 1 entry.

line_no 4, wIndex 2421.

Hmm... Wait, that is a lvl 1 1h-sword! The very same one a newly created character gets, when he makes a new character!

So this is what we do.
We will make ourselves a new character. Then, mail the items you want the newly created character to have to the char you just created, or you can drop them by killing mobs/treasureboxes. Anyway, once you have the items you want, equip them. Make sure you equip ONLY what you want the newly created character to have, so check your mount/wings slot, your potion quickslots, everything.
Once you have it equipped, logout and go to your enterprise manager, user_character, find your character. Get it's character number, I will use A09090520000000003 as an example, because that is my number.
Then, go to user_suit, find the character_no DEKARON0000001 (for knight).
DELETE the 1 row that it has. Then find your character's no (A09090520000000003 as an example). Change the character_no on all lines to DEKARON0000001. Log back into your account again (Yes, all of your items you equipped will be gone), then create a new character.
Wow! He has all the items!

The same can be used for all classes, and it can be used the same way for inventory, skillls, almost everything. Also, you can edit the guild's MASTERCODE to change the default guild created.

[Auto reborn system] - Written by @ : lolpol
                                               @ Modified by: Janvier123



	
	
************************************************************************
***********************     Server Side Setup    ***********************
************************************************************************


1)   Open/start: "Query Analyzer"
2)   Login with your Login Name and password
3)   Copy and paste the following line:



[code]USE [character];
GO

ALTER TABLE [user_character] ADD [Reborn] [smallint] DEFAULT(0) NOT NULL;

4)   Press "Parse Query (ctrl + F5) and press Execute Query (F5)
5)   Copy and past the following lines:



	
	
USE [character];
GO

UPDATE dbo.user_character
SET wLevel = 1, dwExp = 0, wStatPoint = 250 * (Reborn + 1), nHP=106, nMP=16, dwMoney = dwMoney - (50000000), wStr = 6, wDex = 3, wCon = 4, wSpr = 2, wPosX = 336, wPosY = 366, Reborn = Reborn + 1, wMapIndex = 7, wSkillPoint = 0
WHERE (byPCClass = 0) AND (wlevel >= 170) AND (dwMoney >= (50000000)) AND (Reborn < 50);

UPDATE dbo.user_character
SET wLevel = 1, dwExp = 0, wStatPoint = 250 * (Reborn + 1), nHP=106, nMP=16, dwMoney = dwMoney - (50000000), wStr = 6, wDex = 3, wCon = 4, wSpr = 2, wPosX = 336, wPosY = 366, Reborn = Reborn + 1, wMapIndex = 7, wSkillPoint = 0
WHERE (byPCClass = 1) AND (wlevel >= 170) AND (dwMoney >= (50000000)) AND (Reborn < 50);

UPDATE dbo.user_character
SET wLevel = 1, dwExp = 0, wStatPoint = 250 * (Reborn + 1), nHP=106, nMP=16, dwMoney = dwMoney - (50000000), wStr = 6, wDex = 3, wCon = 4, wSpr = 2, wPosX = 336, wPosY = 366, Reborn = Reborn + 1, wMapIndex = 7, wSkillPoint = 0
WHERE (byPCClass = 2) AND (wlevel >= 170) AND (dwMoney >= (50000000)) AND (Reborn < 50);

UPDATE dbo.user_character
SET wLevel = 1, dwExp = 0, wStatPoint = 250 * (Reborn + 1), nHP=106, nMP=16, dwMoney = dwMoney - (50000000), wStr = 6, wDex = 3, wCon = 4, wSpr = 2, wPosX = 336, wPosY = 366, Reborn = Reborn + 1, wMapIndex = 7, wSkillPoint = 0
WHERE (byPCClass = 3) AND (wlevel >= 170) AND (dwMoney >= (50000000)) AND (Reborn < 50);

UPDATE dbo.user_character
SET wLevel = 1, dwExp = 0, wStatPoint = 250 * (Reborn + 1), nHP=106, nMP=16, dwMoney = dwMoney - (50000000), wStr = 6, wDex = 3, wCon = 4, wSpr = 2, wPosX = 336, wPosY = 366, Reborn = Reborn + 1, wMapIndex = 7, wSkillPoint = 0
WHERE (byPCClass = 4) AND (wlevel >= 170) AND (dwMoney >= (50000000)) AND (Reborn < 50);

UPDATE dbo.user_character
SET wLevel = 1, dwExp = 0, wStatPoint = 250 * (Reborn + 1), nHP=106, nMP=16, dwMoney = dwMoney - (50000000), wStr = 6, wDex = 3, wCon = 4, wSpr = 2, wPosX = 336, wPosY = 366, Reborn = Reborn + 1, wMapIndex = 7, wSkillPoint = 0
WHERE (byPCClass = 5) AND (wlevel >= 170) AND (dwMoney >= (50000000)) AND (Reborn < 50);

UPDATE dbo.user_character
SET wLevel = 1, dwExp = 0, wStatPoint = 250 * (Reborn + 1), nHP=106, nMP=16, dwMoney = dwMoney - (50000000), wStr = 6, wDex = 3, wCon = 4, wSpr = 2, wPosX = 336, wPosY = 366, Reborn = Reborn + 1, wMapIndex = 7, wSkillPoint = 0
WHERE (byPCClass = 6) AND (wlevel >= 170) AND (dwMoney >= (50000000)) AND (Reborn < 50);


6)   Press "Parse Query (ctrl + F5) and press Execute Query (F5)
     This will make all lvl 170 players reborn
     NOTE: Gm's with lvl 200+ will also be reborn!

     Note: That "WHERE (byPCClass = 6)" is the class, so 1 line for every class

7)   Close: "Query Analyzer"
8)   Start: "SQL Server Agent" (can be found in the taskbar or start menu)
9)   Open/start: "Enterprise Manager"
10)  Go to: Console Root/Microsoft SQL Servers/SQL Server Group/(local) (Windows NT)/Managemnt/SQL Server Agent/Jobs
11)  Right click in the right windows "New Job"
12)  In tab "General" look for "Name:" enter "reborn" of what ever you like
     In tab "Steps" click "new" 
     "Step name:" enter "Class0"
     "Type:" select: "Transact-SQL Script (TSQL)"
     "Database:" select: "character"
     "Command:" Enter the following line:




	
	
UPDATE dbo.user_character
SET wLevel = 1, dwExp = 0, wStatPoint = 250 * (Reborn + 1), nHP=106, nMP=16, dwMoney = dwMoney - (50000000), wStr = 6, wDex = 3, wCon = 4, wSpr = 2, wPosX = 336, wPosY = 366, Reborn = Reborn + 1, wMapIndex = 7, wSkillPoint = 0
WHERE (byPCClass = 0) AND (wlevel >= 170) AND (dwMoney >= (50000000)) AND (Reborn < 50);
      Press "Apply" then "ok"
      Repeat step: 12

      WARNING: DONT FORGET TO CHANGE "WHERE (byPCClass = 0)" FOR EACH CLASS!!!
 
      You should have 1 step for every class, if you dont it ok
13)   In tab "Schedules" click "New Schedule"
14)   "name:" enter "run" of what ever you want
      "Schedule Type" select "Recurring"
      Click "Change" and enter the following:


	Occurs: Daily
	Daily: Every 1 Day(s)
	Daily Frequency: Occurs Every: 1 Minute(s)
	Starting at: 0:00:00
	Ending at: 23:59:59
	Durdation: (today's date) 
		   No end Date

15)   Press "Ok" and "Apply" when asked"
      This will make all classes reborn every 1 Minute(s)
	IF! Lvl 170+
	IF! 50.000.000 Dill
	IF! Reborns less then 50 times

16)   Open/start: "Query Analyzer"
17)   Copy and past the following line:




	
	
USE [account];
GO


UPDATE dbo.user_profile
SET login_flag = 0, 
WHERE (login_flag0 = 1100);
18)    Make a job for this also (see step 12)
19)    Start All Jobs[/CODE]

Dekaron auto-updater - by ADHDKiD

	
	
This Updater was Original developed for Dekaron Oasis. I had started development on it, and put it off when I left the Dekaron scene. I'm back now, and I finished it today.

This is v8.
Video:
<<<@!1!@>>>

Updates For Version 0.0.9:

Fixing graphics for MoseRollOver & Mouse Click.
Fixing the Ability to drag the updater around.

[URL="http://www.elitepvpers.com/forum/attachments/2moons-pserver-hosting/22577d1242099285-release-tut-dekaron-auto-updater-dekaronupdater.rar"]Download here[/URL]

How to allow pking in all maps


Simple way - go to maplist.csv , search the column '' peacezone '' and change the numbers from 1 to 0 , PS : it's clientsided

How to make a char GM


	
	
Simply go to database, to user_database or how did you name it, find the character you want to be GM, and add [GM] in front of that name, for example [GM]trane
How to change copyrights - by Nightwish10


	
	
go to your client Folder Data/script/string and open strintable_system.txt

find:

NO (C)opyright

How to change exp/drop/dils drop rates


	
	
You can do it manually in monster.csv

You can change exp rate in formula.ini - line 19

You can change need exp to level up in /share/pc/exp.csv
How to install SQL 2000 and how to create a database





How to change mobs spawpoints - Written by derAtze

	
	
This tutorial will show u how to change the spawnpoints of mobs on teh map
for this expamle we will let a mob spawn in braiken at a NPC

Spawn points change

Go to Share then maps in that exapmle we use Braiken


map-> 00_braiken_castle
Now u open mon_00_braiken_castle.csv
and npc_00_braiken_castle.csv

Now look for the mob
1st ...... 2nd .. 3 .4
1903,15,29,29

1) is the monster in the index guck monster.csv stand there with the name.
2) i dunno mby respawn time
3) is the X cordinate
4) the y coordinate

next step
find the NPC npc_00_braiken-castle.csv

NpcIndex, 101
Directorate, 270
Location_X, 231
Location_Y, 191
Description, 14300

Now u knwo where the NPC is

old:1903,15,29,29
new 1903,15,231,191

Now your mob will be spawned at 231,191 instead of 29,29

btw coordinate are easy to find out with the bot from nebualr
How to change DeadFRont times - written by gedimasz


	
	
Left side:
[IMG]http://img22.imageshack.us/img22/7388/leftsidez.jpg[/IMG]

Right side:
[IMG]http://img16.imageshack.us/img16/8226/rightsidem.jpg[/IMG]
How to change NPC teleport locations - written by likinjo14

 - leave 
[B]UnitCount[/B] - number which means how many strings do you want to have on your teleport (string - teleport location on npc) make it 9 if you go higher then 9 will crash you when you go on npc in game, how many lines you want to have when you click on your teleporter,teleport
This numbers are alredy filled cause they already exist in some of teleporters change them if you want to change your port location with location already made in game, if you want to make new one near to these ones  already made in game do this on empty part 7 8 or 9 in your portal.csv)

B]UnitIndex

[/B]

 - 1 for Unit index 1 if you go to unitindex 8 make it 8 and so on

[B]LocationIndex[/B] - this is the number that means where you want to teleport (map,coords,...) that is number you gonna find in location (remember number from part 1. it is 11220 for death lands)

[B]String index[/B] - number wich means... i dont know just make it if your on unit index 1 make it 100, if your on unit index 2 make it 200 and so on (go till 9 (900) if you go to 10 or more will dc and crash in game

[B]Cost[/B] - number that means how much money you gotta pay for teleporting 

[B]Level[/B] - that number means lvl requairment for that teleporting

[U]Example[/U] at the end it should look like this to see Death lands in Braiken 2(North teleporter):
101,1,9,1,110,100,40,1,2,101,200,40,1,3,103,300,10,15,4,104,400,40,25,5,109,500,300,40,6,105,600,500,45,7,112,700,3500,65,[B]8,11220,800,50000,125[/B],9,0,0,0,0
[url=http://www.imagehosting.com/][img]http://img150.imageshack.us/img150/628/teleporter1.jpg[/img][/url]
[U]Hint:[/U] in the teleport i dont know which line is for what teleporter try it yourself, i just know that 1st one is for breiken 1 and 2nd is for loa 2

[U]Hint*:[/U]you gotta have teleport that you modified and client sided and server sided to see it works in game :)
[url=http://www.imagehosting.com/][img]http://img254.imageshack.us/img254/7263/teleport12.jpg[/img][/url]

How to ADD mobs to any map

How to add mobs

When u want to add a mob to braiken for example

u need to go to
Share->Map->mon_00_braiken_castle.csv

there u see teh list of mobs

....
101,15,283,85
102,15,248,456
102,15,277,444
102,15,308,461
102,15,320,451

just add your monster to it that u want

the moster ID's u find in Share->creatur->moster.csv

for exapmle oread 2280


Now u just add teh iD of oread to the mon_00_braiken_castle.csv
101,15,283,85
102,15,248,456
102,15,277,444
102,15,308,461
102,15,320,451
2280,15,50,50

it will spawn now in braiken on cooridinates 50:50

Hello,
I got a problem >.<
At Step 17) where I need to paste the text in query analyzer it says syntax error... why?

[trane.]

#Thread updated

I added some tutorials written by Bigshow107

[Bigshow107]

Originally Posted by trane.

#Thread updated

I added some tutorials written by Bigshow107

thanks trane <3


and hope you guys like it

[soulless80]

will this work with ms sql 2005 express edition?

[Bigshow107]

Originally Posted by soulless80

will this work with ms sql 2005 express edition?

those tut for game devsing not for making a pserver
what i mean is :
those tut for after hosting not b4

[asmadila1]

bro,i want to make guild n so how to change the guild text colour to others colour..like red or else??

[Bigshow107]

Originally Posted by asmadila1

bro,i want to make guild n so how to change the guild text colour to others colour..like red or else??

lol why you so mad?
BRO!!!!! <like you gone kill me ....

anyway
use <color=ff000>HI these will color it . and to know your specific color . search for web colors in google
to lazy ?
okey here you go

and here

[Onurtje1]

Holy....is there any EASYway to make ur server for fun pure pk /pvp?that can be done in like 20 mins?

[~Kakkarot~]

ye there is...i just keep wondering how ppl miss stickies

[sjomail]

CAn someone give me download link for the required programms to do this?

[155891059797]

thank trane

[mynats]

can i ask??my RAM just 3GB so can i make server???

[EliteWarrior]

Nice helpfull tutorials

[mynats]

yeah..that nice tut..