Setup Server Tutorial

Page 5 of 17 « First 34 5 6715 Last »
04/07/2006 04:47 bender77#61
HELP ME PLEASE ADD ME PLEASE to msn [Only registered and activated users can see links. Click Here To Register...] or aim badxkidxpunk please i need help no one ever helps me im so close i cant get past the debugging
04/07/2006 04:55 lostsolder05#62
you noob dont post that many times in a row post once and someone will help you
04/07/2006 06:45 light123#63
Quote:
Originally posted by bender77@Apr 7 2006, 04:47
HELP ME PLEASE ADD ME PLEASE to msn [Only registered and activated users can see links. Click Here To Register...] 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.
04/08/2006 01:11 bender77#64
that made no sense light
04/08/2006 03:39 light123#65
Quote:
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
04/08/2006 06:50 bender77#66
*mummbles* cuz ur here
04/08/2006 18:29 Robsta#67
would you stop flaming? bender, stop spamming for help, posting alot isn't going to help, and stop fucking 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!
04/08/2006 22:25 tictaktoe#68
wats the code for the co full sever thing
04/11/2006 05:36 TheOneNamedMaster#69
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? :rolleyes:
04/11/2006 05:51 TheOneNamedMaster#70
eh wow thats real nice I can't install it in english but i can use portuguese wow lol just wow
04/12/2006 02:52 TheFake#71
Nice guide :)
04/15/2006 11:45 Antironix#72
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.
04/15/2006 19:36 conquermexico#73
Quote:
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 -> [Only registered and activated users can see links. Click Here To Register...]

good luck...
the table.txt file is not longer available. can someone post it again pls
04/15/2006 19:57 conquermexico#74
5. Get Table Definitions; [Only registered and activated users can see links. Click Here To Register...] 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

Code:
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.


Code:
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

Code:
 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..
04/15/2006 22:17 yhcnum#75
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?
Page 5 of 17 « First 34 5 6715 Last »