Eudemons Server Files!!!

galdik · 05/17/2008, 12:08

Quote:

Originally Posted by likeicare

(Well, you can't buy hair and avvies but that's because something is probably missing/wrong in itemtype/cq_goods but I haven't looked into it since I'm busy translating cq_action atm ...

heh I wonder how it will look when everyone will came out with his translation xD doing myne too. cuz found some here but it messed up the action table and it was like half stuff (legion family ..) wasnt working

MySQL4 did mess it even more.

heh dumb me trying game servers in meantime of my exams >< ... :-(

yea what about SVN for translated stuff ??? deal ??
(for SVN SQLsyntax example

)
got some myne done too ... (using unworking jp>en from someone who maybe not played eudemons + jp original for mistakes validation )
benefits of this is that if you know what text you want change is it easy to find :-)

btw if we gonna translate it I guess I have to look in source code aswell cuz I didnt find messages for word gold or picked (drop some gold and pick it >> I mean those system messages left up)

# yop this will make smaller drop rates gonna made some for cq_levelexp soon too
# cuz we know why ... I will be using only the off. with checksum :-/ the other without wasnt working for me
UPDATE cq_dropitemrule SET chance=222000 WHERE chance=10000000;

got also backup of my PM char with alll stuff in it xD is sql file like the one above

likeicare · 05/17/2008, 21:56

Quote:

Originally Posted by galdik

heh I wonder how it will look when everyone will came out with his translation xD doing myne too. cuz found some here but it messed up the action table and it was like half stuff (legion family ..) wasnt working

MySQL4 did mess it even more.

heh dumb me trying game servers in meantime of my exams >< ... :-(

yea what about SVN for translated stuff ??? deal ??
(for SVN SQLsyntax example )
got some myne done too ... (using unworking jp>en from someone who maybe not played eudemons + jp original for mistakes validation )
benefits of this is that if you know what text you want change is it easy to find :-)

btw if we gonna translate it I guess I have to look in source code aswell cuz I didnt find messages for word gold or picked (drop some gold and pick it >> I mean those system messages left up)

# yop this will make smaller drop rates gonna made some for cq_levelexp soon too
# cuz we know why ... I will be using only the off. with checksum :-/ the other without wasnt working for me
UPDATE cq_dropitemrule SET chance=222000 WHERE chance=10000000;

got also backup of my PM char with alll stuff in it xD is sql file like the one above

Lol The older translated scripts do work but they were made for what was available at that time. I'm not sure if you could use them while making a fresh db (like taking the oldest one that was in January and using it before you use a db that came out after it was made), who knows that might work but I just built mine without them and then tried to use them and yeah... didn't work out good. XD

Eh you said mysql 4 messed it more, which mysql are you using? There's a few versions of 4 and I'm using 4.0.26 atm (tried 4.1 but it didn't work out well x_x) and everything works well.

SVN? Never used it. >< How I do my translations is I go around and get the numbers for the text from the npcs on my PM account, go to Global and screenie what they say (because I seriously don't have something good to say for these npcs so yeah lol), and then I made a dump of my action (using insert because update wasn't working for me whether I deleted the table and it recreated or just left the table as is) and just find the numbers in it and replace text. It's a long process but I'm not in a hurry to translate. I've already tweaked drops, compose rate, max stars, level exp, max level, fixed the grade table so it's the right info, etc... and my server isn't online so I don't mind it taking long since once it's done I'm done. XD

galdik · 05/18/2008, 04:55

okok best way you can help me is give me dump of the db.

yeach mostly its a way how I worked.

hope for that dump solve my monster and ppl names issue

problem with SQL is maybe also that in default files (who made it in db files chezz clever peps use dumps) isnt saved charset so it turn out that MySQL err file have lines with warnings and then I wonder how can be type INT (size 4) with numbers bigger than 4 digits .... <thats why its in that warning

SVN is for source codes we can use it too for this.
its like text based mutliple diff (differences inside text file)

good thing on those SQL commands (in my example) is independent same goes for dump mostly
my edits way is game >>find MySQL copy_contain>>rewrite text file
then I put all SQL queryes in MySQL

if you have backup of fresh db do dump of those
send me dump ;-) (del from it some stuff you not like .) >> compress it .zip or .rar etc

likeicare · 05/18/2008, 23:17

I don't have a fresh db though lol. I only have mine. XD But you can build a fresh one yourself, just use forcers two posts first (the first server files, then the one that fixes legions, families, etc...) and then pfj511s files from the oldest to the newest.

darkytoG · 05/19/2008, 02:36

when i made my own private server and run ACCserver it says only these 2 lines and disappear
server start...
kernel init ok.
i tried google for it but couldn't find a solution, does anyone know the solution here?

jizzer · 05/19/2008, 02:47

Darkytog check your port numbers. usually thats the only thing that makes it disappear for me

darkytoG · 05/19/2008, 04:07

well its the same port as it regular was

playg · 05/19/2008, 07:24

MSG shows error box then frezzes the npc one shows error then closes anyway tot fix that?

playg · 05/19/2008, 10:16

nvm fixed that now i get invalid pass/account. also how can i connect to my server do i change the ip?

galdik · 05/19/2008, 14:19

Quote:

Originally Posted by darkytoG

when i made my own private server and run ACCserver it says only these 2 lines and disappear
server start...
kernel init ok.

sure
its hard to tell it can be several stuff however
1. it should be problem with MySQL connect failed but I am not sure pls check if urs root username in MySQL have pass test (try log in)
did you run those SQL commands ??

Code:

SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('test');
ALTER TABLE `account`.`account` MODIFY COLUMN `password` VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
insert into account.account (name,password,reg_date) values ('test','53b6320eb06e2c62888a6d1739cd24bd',now());
grant all on account.* to 'ODBC'@'localhost';
grant all on my.* to 'ODBC'@'localhost';

2. check files account.ini config.ini others should be unchanged for ....phdev.rar version
made it like those change NAME_!_HERE for your server name

Code:

[Account1]
SERVERNAME=NAME_!_HERE
LOGINNAME=root
PASSWORD=test
FREE_DEBUG=3

Code:

[System]
LOGINLISTENPORT	= 9958
POINTLISTENPORT = 9870
SERVER_FULL_DELAY_SECS	= 5000
SERVER_BUSY_DELAY_SECS	= 3000
SERVERTITLE = NAME_!_HERE
SERVERNAME = NAME_!_HERE
LOGINNAME = root
PASSWORD = test
SERVERIP = 127.0.0.1

[Database]
DBHOSTNAME=127.0.0.1
DATABASENAME=my
DBUSER=root
DBPASSWORD=test

galdik · 05/19/2008, 14:26

Quote:

Originally Posted by playg

nvm fixed that now i get invalid pass/account. also how can i connect to my server do i change the ip?

you need EO client with revision 1078 >rewrite version.dat 1087 path up to like 1091 - + but I am not correct person for this (not running that way I got ver 1091client install it runns but I didnt solved problems with missing mob and other ppl names however someones keep telling me its not complede database with the default server ...phdev.rar wich I use)

how you can connect ?? did you read tutorial ?? chezzzz
for that old client versions it can be done in way like

again change that server name
it have to be same everywhere (in server configs and here)
you can change the "about:blank" later on to some web with yours game info ><
// about:blank < empty page
in <EO_client>/ini/oem.ini

Code:

[Oem]
Id=2010
; maybe something else can be here?

[AccountSetup]
Type=1

[ServerInfo]
URL=about:blank

[ServerStatus]
Link=about:blank

[Header]
GroupAmount=1
Group1=TEST GROUP

[Group1]
ServerAmount=1

Server1=NAME_!_HERE
Ip1=127.0.0.1
Pic1=Server1
ServerName1=NAME_!_HERE

playg · 05/19/2008, 16:34

mm il try it i used version 1083 maby thats y to fix error with ppls name and no mobs check page 10-20 i think answers around there

playg · 05/19/2008, 17:44

nop still get it

playg · 05/19/2008, 19:04

woo never fixed. i kno this sounds noob but whats diffence between [GM] and [PM]

galdik · 05/19/2008, 20:29

GM PM have alloved commands
thats main difference from normal ppls.

GM and PM diff?? hmmm definetly PM have some game dumps dont sure about it with just GM.
its meant in TQ that
GM ... with purpose to help ppls
PM ... hes more suited for game and NPC edits/testing

but imho it should be oposite way (not like TQ have)