CO Private Server

[t3hn00bz0r]

I have compiled the sql statments to create the required database and data. There are a few things that you must do before you can use this database:

1.) Before you ever run the commands in the sql file, you must make 4 directories and modify the first 4 statements to point to them. This sets up the tablespaces so that the data is stored in 4 different places.

2.) You must add a server to the server table. The name is the name of the server. This name must be used as the name in the server.dat file.

3.) You must create an account in the accounts table. Leave the password field blank! All that is needed is to set the account name.

After you have done all of this, you should be able to log onto the server. When the server is up, the password you first put in will become the password in the database (that's why you left it blank). Subsequent logon attempts will be checked for password validity. To make an account a GM account, set the "Flags" field of that account to 8.

Good luck and enjoy,
t3hn00bz0r

[t3hn00bz0r]

Sorry about the triple post, I forgot the sql in the last one.

EDIT: Added the CharacterID sequence.

[StarCelli1]

thanks a lot t3hn00bz0r

[StarCelli1]

....
CREATE TABLE "Characters"
(
"CharacterID" int4 NOT NULL DEFAULT nextval('"Characters_CharacterID_seq"'::regclass),
....

here it says: "ERROR: relation "characters_characterid_seq" does not exist"

can u help pls

[Disruption]

yah any private server working? can u try explain how to play on it? coz i hate the normal servers always full of ppl and mains sucks

[adrianna]

Originally posted by einhornchen@Jan 28 2006, 01:17
speak english

this is a german forum

[t3hn00bz0r]

I have added the CharacterID sequence to the table definitions sql file in my previous post. If you do not wish to re-download it, here it is:


CREATE SEQUENCE "Characters_CharacterID_seq"
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 41
CACHE 1;
ALTER TABLE "Characters_CharacterID_seq" OWNER TO postgres;

[StarCelli1]

now i can log in to my server, create a character and anything, BUT

1. there are no npcs
2. I cant use teleporters
3. When i log in im directly in Twin City not in Birth Village
4. When i log in i log in a Character named "Selector" not my one
5. If i Attack my Char that stands beside the "Selector" i get teleportet to Maple Forest

thats my problems and i dont know how to fix them, i've tried to add new portals over the pg database but they dont appear..

and i've one question, are there any GM Commands to use?

[Pocoto]

yes there is just a test server but in a few weeks they will upgrade it it will be like the normal servers but u will have more chance to find items and stuff it is more like pk server

[StarCelli1]

how do u want to know that?
there are no monsters and nothing works..

[Pocoto]

go on the congor site and u will know that too lol when i want to pk i just go there to train my fb skills soon the private server will be like the normals one BUT MUCH BETTER BETTER DROPS BETTER CHANCES better items 5x better than normal server

[StarCelli1]

we will see..... lol.....

[xprincex]

Can some one help me it brings up a error saying failed to initialize wehn i click on the client thingy can someone help me out

[t3hn00bz0r]

StarCell1:

"1. there are no npcs"

Yeah, they havent been implemented yet.

2. I cant use teleporters

See #1.

3. When i log in im directly in Twin City not in Birth Village
4. When i log in i log in a Character named "Selector" not my one
5. If i Attack my Char that stands beside the "Selector" i get teleportet to Maple Forest

Selector is a character selecter. You can have multiple characters on a single account. Look up the slash command parser to see the available commands. I wanted the character to start in Maple Forest for debugging purposes. You are free to change the server in any way that you want to.
Enjoy,
t3hn00bz0r

[monkeyleader]

wow this must have taken a long time to do... u got skills