Setup Server Tutorial

[bender77]

HELP ME PLEASE ADD ME PLEASE to msn or aim badxkidxpunk please i need help no one ever helps me im so close i cant get past the debugging

[lostsolder05]

you noob dont post that many times in a row post once and someone will help you

[light123]

Originally posted by bender77@Apr 7 2006, 04:47
HELP ME PLEASE ADD ME PLEASE to msn or aim badxkidxpunk please i need help no one ever helps me im so close i cant get past the debugging

Mn ppl like you make others to not bother posting.

[bender77]

that made no sense light

[light123]

Originally posted by bender77@Apr 8 2006, 01:11
that made no sense light

read it again and it might.

now i hink this post is dead.. no one is willing to help

[bender77]

*mummbles* cuz ur here

[Robsta]

would you stop flaming? bender, stop spamming for help, posting alot isn't going to help, and stop ******* spamming me in pm, I got mine to work, i told you what to do, if you can't figure something as simple as this out, THEN DONT BOTHER!

[tictaktoe]

wats the code for the co full sever thing

[TheOneNamedMaster]

I'm having problem with postegreSQL after I save it to my computer and try to open the installer it says:

This installation package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor to verify that this is a valid windows installer package.

err. How do I do this?

[TheOneNamedMaster]

eh wow thats real nice I can't install it in english but i can use portuguese wow lol just wow

[TheFake]

Nice guide

[Antironix]

Sry, but step 4 isn't clear for me.

I didn't see that i must make a server. I installen postegreSQL and i only must make a username and password, not a server.

Thank you if you can help me.

[conquermexico]

Originally posted by aidas2004@Mar 23 2006, 22:30
lostsolder05> just do simple query.
In PostgreSQL select u'r Conquer database and use Query button then copy/past all this ->

good luck...

the table.txt file is not longer available. can someone post it again pls

[conquermexico]

5. Get Table Definitions; and do a SQL Query to set up
Tablespaces. (Open table def. and copy all then paste into SQL Query window box)

ok i got the tables now

CREATE TABLESPACE "co_MainData"
 OWNER postgres
 LOCATION 'C:/COFullDB/Main/OtherData';

CREATE TABLESPACE "co_Indexes"
 OWNER postgres
 LOCATION 'C:/COFullDB/Main/Indexes';

CREATE TABLESPACE "co_CharacterData"
 OWNER postgres
 LOCATION 'C:/COFullDB/Main/CharacterData';

CREATE TABLESPACE "co_AuthTables"
 OWNER postgres
 LOCATION 'C:/COFullDB/Main/AuthTables';

-- Table: "Account"

-- DROP TABLE "Account";

CREATE TABLE "Account"
(
 "AccountID" varchar(16) NOT NULL,
 "Password" char(32),
 "LastLogon" timestamp,
 "LogonCount" int4 NOT NULL DEFAULT 0,
 "LogonAction" int2 NOT NULL DEFAULT 2, -- 0 = User does not exist (should never be on an active account)
 "Flags" int4 DEFAULT 0,
 "IPAddress" inet,
 CONSTRAINT "pkey_Account_AccountID" PRIMARY KEY ("AccountID") USING INDEX TABLESPACE "co_Indexes"
) 
WITHOUT OIDS TABLESPACE "co_AuthTables";
ALTER TABLE "Account" OWNER TO postgres;
COMMENT ON COLUMN "Account"."LogonAction" IS '0 = User does not exist (should never be on an active account)
1 = Normal Logon
2 = Create Character
4 = Banned';


-- Index: "ix_Account_AccountID"

-- DROP INDEX "ix_Account_AccountID";

CREATE UNIQUE INDEX "ix_Account_AccountID"
 ON "Account"
 USING btree
 ("AccountID")
 TABLESPACE "co_Indexes";

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


-- Table: "Characters"

-- DROP TABLE "Characters";

CREATE TABLE "Characters"
(
 "CharacterID" int4 NOT NULL DEFAULT nextval('"Characters_CharacterID_seq"'::regclass),
 "Account" char(16) NOT NULL,
 "Name" char(16) NOT NULL,
 "Level" int2 NOT NULL DEFAULT 1,
 "Experience" int4 NOT NULL DEFAULT 0,
 "Class" int4 NOT NULL,
 "Model" int4 NOT NULL,
 "Strength" int4 NOT NULL DEFAULT 0,
 "Agility" int4 NOT NULL DEFAULT 0,
 "Spirit" int4 NOT NULL DEFAULT 0,
 "Vitality" int4 NOT NULL DEFAULT 0,
 "Flags" int2 NOT NULL DEFAULT 0,
 "HP" int4 NOT NULL DEFAULT 1,
 "MP" int4 NOT NULL DEFAULT 0,
 "PKPoints" int4 NOT NULL DEFAULT 0,
 "LocationX" int4 NOT NULL DEFAULT 438,
 "LocationY" int4 NOT NULL DEFAULT 377,
 "Map" int4 NOT NULL DEFAULT 1011,
 "Money" int8 NOT NULL DEFAULT 0,
 "StatPoints" int2 NOT NULL DEFAULT 0,
 "Spouse" int4 NOT NULL DEFAULT 0,
 CONSTRAINT "pkey_Characters_CharacterID" PRIMARY KEY ("CharacterID") USING INDEX TABLESPACE "co_Indexes",
 CONSTRAINT "fkey_Characters_Account" FOREIGN KEY ("Account")
   REFERENCES "Account" ("AccountID") MATCH FULL
   ON UPDATE RESTRICT ON DELETE RESTRICT,
 CONSTRAINT "ukey_Characters_Name" UNIQUE ("Name") USING INDEX TABLESPACE "co_Indexes"
) 
WITHOUT OIDS TABLESPACE "co_CharacterData";
ALTER TABLE "Characters" OWNER TO postgres;




-- Table: "DefaultStats"

-- DROP TABLE "DefaultStats";

CREATE TABLE "DefaultStats"
(
 "Class" int2 NOT NULL,
 "Strength" int4 NOT NULL,
 "Agility" int4 NOT NULL,
 "Vitality" int4 NOT NULL,
 "Spirit" int4 NOT NULL,
 "Level" int2 NOT NULL,
 CONSTRAINT "pkey_DefaultStats_LevelClass" PRIMARY KEY ("Class", "Level") USING INDEX TABLESPACE "co_Indexes"
) 
WITHOUT OIDS;
ALTER TABLE "DefaultStats" OWNER TO postgres;




-- Table: "Portals"

-- DROP TABLE "Portals";

CREATE TABLE "Portals"
(
 "Name" varchar(12) NOT NULL,
 "FromMap" int4 NOT NULL DEFAULT 0,
 "FromX" int2 NOT NULL DEFAULT 0,
 "FromY" int2 NOT NULL DEFAULT 0,
 "ToMap" int2 NOT NULL DEFAULT 0,
 "ToX" int2 NOT NULL DEFAULT 0,
 "ToY" int2 NOT NULL DEFAULT 0,
 CONSTRAINT "pkey_Portals_Name" PRIMARY KEY ("Name") USING INDEX TABLESPACE "co_Indexes"
) 
WITHOUT OIDS;
ALTER TABLE "Portals" OWNER TO postgres;




-- Table: "Servers"

-- DROP TABLE "Servers";

CREATE TABLE "Servers"
(
 "ServerName" text NOT NULL,
 "IPAddress" text NOT NULL,
 CONSTRAINT "pkey_Servers_ServerName" PRIMARY KEY ("ServerName") USING INDEX TABLESPACE "co_Indexes"
) 
WITHOUT OIDS TABLESPACE "co_AuthTables";
ALTER TABLE "Servers" OWNER TO postgres;




-- Table: "Settings"

-- DROP TABLE "Settings";

CREATE TABLE "Settings"
(
 "Name" text NOT NULL,
 "Value" text NOT NULL,
 CONSTRAINT "pkey_Settings_Name" PRIMARY KEY ("Name") USING INDEX TABLESPACE "co_Indexes"
) 
WITHOUT OIDS;
ALTER TABLE "Settings" OWNER TO postgres;




INSERT INTO "DefaultStats" ("Class", "Strength", "Agility", "Vitality", "Spirit", "Level") VALUES (1, 5, 2, 3, 0, 1);
INSERT INTO "DefaultStats" ("Class", "Strength", "Agility", "Vitality", "Spirit", "Level") VALUES (1, 7, 2, 4, 0, 2);
INSERT INTO "DefaultStats" ("Class", "Strength", "Agility", "Vitality", "Spirit", "Level") VALUES (4, 2, 7, 1, 0, 1);
INSERT INTO "DefaultStats" ("Class", "Strength", "Agility", "Vitality", "Spirit", "Level") VALUES (10, 0, 2, 3, 5, 1);
INSERT INTO "DefaultStats" ("Class", "Strength", "Agility", "Vitality", "Spirit", "Level") VALUES (2, 5, 2, 3, 0, 1);

but when i make the sql query.

i got this msg.

ERROR: could not set permissions on directory "C:/COFullDB/Main/OtherData": Permission denied

can someone help me

sorry i found the solution on another place. i paste it so other ppl can get it

 right click on every folder and subfolder and be sure no one is write protected (sometimes Windows XP does this automatical) and then Share the folders in Local Network. Then try it again, it should work now..

[yhcnum]

I disabled teh second checkbox in the signing thing, adn created a test certificate, it still asked me for a password, so I tired the one I used as the test certificate and it sad it was the wrong password?

Edit:

Also - When installing PostgreSQL, I go through all the stuff and it installs, but always freezes at "Setting filesystem permissions..." and sits there not gaining any progress after that. What shuold I do about that?