Dragon's Prophet Server Files VM

[cmb]

CMB id like any way to launch this i really wanna play but the stupid thing is driving me angry,i even closed explorer.exe on server to save some mb and disabled most crap stuff,i cannot launch server with 8 gb assigned...

You have to give it more memory, it should have at least 16GB minimum to run, zones takes about ~4GB of RAM on their own.

 

[Matar]

Thx
working fine

 

[xlw00tlx]

i managed to launch it with 8g but then it asked to click tutorial zone and i got stuck there,i will try to buy a new ram stick next month

 

[orion13]

How to change Secondary Password:
(necessary for buy items in the Cash Shop)

The Secondary Password has 6 digits
It is stored in the Database with MD5 encryption
Database P3_AllWorldDB
Table RoleData_Account
Secondary Password = Password

Example:
You want your Secondary Password to be 654321
654321 = C33367701511B4F6020EC61DED352059

Open MSSQL Management Studio and execute this Query:
(Replace xxx with your account name and your MD5 Password)

USE P3_AllWorldDB;
UPDATE RoleData_Account SET Password='C33367701511B4F6020EC61DED352059' WHERE Account='xxx';

How to add Diamonds:
(necessary for buy items in the Cash Shop)

Example:
You want to charge Account xxx (replace with yours) with 50000 Diamonds

USE P3_Billing;
UPDATE Bank SET Money1='50000' WHERE Account='xxx';

 

[pasztor7]

Hi here is the server files and the database, it has not been tested from the vm file it is good for testing and modifications.
If I have the time and energy, I will completely redesign the server.
good test on local machine
vmware is not required

You must be registered to see links

I forgot to write to the txt file
here too you need to find and edit ini files

\GameServer\Node\ search all mapping Global.ini

note :
not all of them are in it so you need to browse the folders

Server File MSSQL 2012 and Node

so much if i don't really touch it .
ISIS-Dev1 replace the name as follows.
IP : 127.0.0.1 = localhosting
or
Machine name = installed computer name [example (Tutorial1)]
or
Machine name + MSSQL name computer+sql [example (Tutorial1\MSSQL2012)]

 

[Ramazes]

​I can not connect, I write a connection error, what is the problem?

in client



















maybe me need open some ports or?

 

[pasztor7]

​I can not connect, I write a connection error, what is the problem?

in client



















maybe me need open some ports or?

these files are just for testing there are a lot of modifications needed for them to work well

cmb shared what should be the client.ini file above

 

[Ramazes]

maybe you can help, how to use?

 

[pasztor7]

maybe you can help, how to use?

clien.ini file add and run vmware file and run server .

what i shared i don't use it waiting for testing i would use vmnet 1-8 so no vm is running
[Server]
Ip=127.0.0.1
Port=16300

[Locale]
Language=eneu
[Option]
StreamingDL=0
[Debug]
SkipVersionCheck=1
SkipUpdate=true
ShowErrorList=0

 

[Ramazes]

I started the server, then I started the client with your settings. When connecting, it writes a connection error.

 

[pasztor7]

I started the server, then I started the client with your settings. When connecting, it writes a connection error.

I guess it's because vmware didn't give you the ip.
but many people have described that 8GB of sweet little will be rumbled by vmware

Now settings ip vmware:
Edit -> Virtual Network Editor now click
choose VMnet8 and write ip Subnet IP : 192.168.200.0 and Apply
click NAT Settings button new window opening write IP , Gateway IP : 192.168.200.128 and OK button 2 window 2 OK

You must be registered to see links

and

You must be registered to see links

minimum memori 12GB or 16GB


In principle, a 4 core processor is enough but if you have 8 cores it is best but 8 GB of memory will be low on the basis of giving me errors that give little to ram
that was all i could help

 

[Ramazes]

do this, as you tell, also can't connect.

 

[xlw00tlx]

set the vm ip ,change adapter to bridged and edit the ip in control panel,i had to set it to static and change a line in account ini because it asked for 192.168.200.1 ip
also,to start server you need zones 2,105 and 601 and idk what else
zone 105 is for the character creation,idk what zone 2 does,and 601 i think its the tutorial zone
it does not run with 8 gb ram,server only uses 3,5 gb ram and like 900 mb ram to up to 2 gb ram per map

 

[Ramazes]

What's is?

 

[Stylerbob]

has someone figured out how to give GM rights and log in to the site?

You must be registered to see links

on the vm server

 

[orion13]

You can grant GM Powers to an account with this query :
(replace xxx with an account name)

USE P3_AllWorldDB;
UPDATE RoleData_Account SET ManageLv='13' WHERE Account='xxx';

If you want to revert account to normal, use this:

USE P3_AllWorldDB;
UPDATE RoleData_Account SET ManageLv='0' WHERE Account='xxx';

GM Commands:
-You have a first list of commands (some have built-in editors) if you enter the command /help in Chat Window
-you have the GM Command List if you enter the command : /gm help
-each command must be preceded by /gm
Example /gm who

Commands List:

Spoiler

accountgmcommand
achieveclear
achievecounter
achievecounterclear
achievefirstclear
achievetimercounterreset
achievetimercounterresetbyname
activatetent
addbuff
addbuffex
addfriendheart
addfriendliness
addguilddonation
addguildfamous
addguildhonorpoint
addguildtp
addnestproperty
addpettp
addrankboardcounter
addrankboardcounter_ds
addrankboardcounterlast
addrecipe
addunionhonorpoint
assignaltarboss
asstorebaseitem
asstorebodyitem
asstoremoney
attackflag
bgcreate
bgend
bgjoin
bgreload
bgstart
billingdsystime
broadcast
callid
callplayer
catchpet
checknpcheight
checkobj
checkobjdata
clearaltarchallenge
clearcallpetparams
cleareggtouch
clearonekeyeggtouch
clearpassword
clearrankboardgetawardtime
cleartentitem
closemoneyexchange
clsclimotion
colorbank
completepetproccess
createcamera
creatobj
createpet
debugrole
del
delallitem
delcamera
delguild
delpetbag
delrecipe
dostring
drawheartreset
dsystime
eggtouch
enabledragonchecker
endpetfight
endpetrace
fieldrainreset
fightlist
friendgiftreset
full
getcrossworldvar
geturgereset
getvalue
give
giveaccountmoney
givebonusmoney
givedragonitem
givedragonpetskill
giveeq
givemoney
giverecipe
givetentmajorskill
givetentpet
gmhide
gmmsg
gotoid
gotoobjid
gotoplayer
help
house
houseegggrowper
houseeggtalent
houseeggtouch
initactivatedpound
initactivatedstock
instance
kick
kickid
killid
learnrideattackskill
luadebug
luaglobalvartest
moneyexchangeaddpoolvalue
moneyexchangerefreshquota
moneyexchangesetpoolupperbound
movecamera
openinstance
openmoneyexchange
pcall
peaddvar
peenter
pefail
pegetstatus
petgetvar
peleave
peobachieve
pereload
pesetvar
pestart
pestartall
pestop
pestopall
pesuccess
petfightreset
petraceautosign
petracestatustimeover
pettpreset
questclearallcnt
queststate
rankboarddebugtime
rankboarddebugtimeclear
rankboardreset
reloadobj
reloadplot
reloadtable
removeutilitylayout
resetaltarchallengelastnum
resetaltarchallengenum
resetcooldown
resetdailyquest
resetdonationlimit
reseteq
resetinstance
resetmagic
resetpeeventnum
resetpetcontest
resettaxallotnum
resettechbufftime
revivehere
room
runplot
searchobj
searchobjcount
setcatchval
setcrosswolrdvar
setdragonbookitem
setguildverflag
sethomepetclass
setliveactime
setluadegugwriterolevalue
setnestproperty
setnonagetime
setpetfightgmaccounthide
setpetfightruneallottime
setps
setrankboardcounter
setrankboardcounter_ds
setrankboardcounterlast
setregisterdragonbook
setrideattackskillset
setsysintvalue
setteamarrayid
settentpetflag
settentpetspeper
settentpetstarlvl
setunionleader
setuniontaxtime
setvalue
setvalueex
skillvalue
speak
spellmagic
startpetrace
sysspellmagic
testflag
testgivetentpetskill
testgivetentpetskill_force
testlog
testrideattack
testrideskillset
throwhouse
transportstate
updatevipexp
who
world
wpeaddvar
wpegetvar
wpereload
wpesetvar
zone

 

[oka5454]

can someone extract files from vm?

 

[harleyknd1]

This seems to be the same release as https://forum.ragezone.com/f857/dragonsprophet-server-1168551/

Same databases, same php files, same server monitor.

It's still missing the object data db and the world db to actually modify things. Only difference is that they made a vm that has the proper computer name to get the server to boot and put everything on the proper D:\ drive

 

[Shenra]

There is one server since 2017, looks like they have source code too

You must be registered to see links

Edit:

Found a second one

You must be registered to see links

As I saw, there is a client unpacker around but not a packer:

You must be registered to see links

 

[cmb]

There is one server since 2017, looks like they have source code too

You must be registered to see links

Edit:

Found a second one

You must be registered to see links

As I saw, there is a client unpacker around but not a packer:

You must be registered to see links

Everything you require has already been released. Source code is public, inside are the tools to unpack/pack/build patches/etc...