[Grand Fantasia] Server files

[orion13]

@GaRocK I put inside the 2 def. in [common] section (I tried to put them in duplicate in Common and in MissionServer, we can no longer join the arenas, the buttons "Join" are in gray). In Common section, it's ok, we can join :

Portion of my setup.ini

Spoiler

[Common]
GameDBIP=127.0.0.1
GameDB=gf_gs
GameDBUser=spiritking
GameDBPassword=284ulj;6
Language=X
Locate=US
LogFile=Test.log
AccountDBIP=127.0.0.1
AccountDBName=gf_ls
AccountDBUser=spiritking
AccountDBPW=284ulj;6
TicketServerIP=127.0.0.1
TicketServerPort=7777
MissionServerIP=127.0.0.1
MissionServerPort=7654
BillingGatewayIP=127.0.0.1
BillingGatewayPort=5560
PingAlive=1
FBMsgUpdate=1
CrossWorldID=1010
MaintenanceDate=3
RankAward=1
NAT=0
AchievementGroupCheck=0
MemoryCheck=1
MemoryCheckTime=120
MemoryCheckSavingTime=300
MaxCharacterNumber=9
LuckyStarOpen=1
IsleWorldID=1010
PVPServer=1
BotServer=0
XTrap=0
Battlefield=1
FamilyBattle=1

-I found a quest that can't be completed because the NPC isn't there. I added it in Scene S100.ini (in Attachment)
Map : Kaslow (ID 100)
Coordinates : 309,154
Quest : Darkness cannot be seen !
NPC Name : <Suspicious Shadow> Alvin
NPC ID : 62213

Replace in :
Client/data/scene/
Server/data/scene (delete S100.ini.bin)

-Table "itemmall" generates errors in pgsql, some definitions are missing :
"on_sell_date"
"account_num_limit"
"allow_buy_level"
"new_account_day_limit"

My Table (Struture and Records):

Spoiler

-- ----------------------------
-- Table structure for itemmall
-- ----------------------------
DROP TABLE IF EXISTS "public"."itemmall";
CREATE TABLE "public"."itemmall" (
"item_id" int4 NOT NULL,
"item_group" int4 NOT NULL,
"item_index" int4 NOT NULL,
"item_num" int4 NOT NULL,
"money_unit" int4 NOT NULL,
"point" int4 NOT NULL,
"special_price" int4 NOT NULL,
"sell" int4 NOT NULL,
"not_sell_date" int4 NOT NULL,
"fortune_bag" text COLLATE "default" DEFAULT ''::text,
"note" text COLLATE "default" DEFAULT ''::text
)
WITH (OIDS=FALSE)

;

-- ----------------------------
-- Records of itemmall
-- ----------------------------
INSERT INTO "public"."itemmall" VALUES ('40019', '4', '10', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40020', '4', '9', '5', '1', '19', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40021', '4', '8', '5', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40022', '1', '5', '20', '1', '779', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40022', '4', '6', '20', '1', '779', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40022', '4', '7', '5', '1', '199', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40023', '4', '24', '5', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40025', '4', '25', '5', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40027', '4', '26', '5', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40029', '4', '27', '5', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40031', '4', '28', '5', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40033', '4', '11', '30', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40034', '4', '12', '30', '1', '39', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40035', '4', '13', '30', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40036', '4', '14', '30', '1', '69', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40038', '4', '15', '30', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40039', '4', '16', '30', '1', '39', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40040', '2', '9', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40040', '2', '10', '5', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40043', '2', '7', '15', '1', '89', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40043', '2', '8', '5', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40044', '2', '20', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40045', '2', '21', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40046', '2', '22', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40047', '2', '23', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40048', '2', '24', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40049', '2', '25', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40050', '2', '26', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40051', '2', '27', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40052', '2', '31', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40053', '2', '30', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40054', '2', '32', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40055', '2', '33', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40056', '2', '28', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40057', '2', '34', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40058', '2', '35', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40059', '2', '29', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40063', '2', '17', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40064', '2', '18', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40065', '2', '19', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40069', '2', '16', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40072', '2', '36', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40074', '2', '37', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40075', '2', '38', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40083', '2', '39', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40096', '2', '14', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40097', '2', '15', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40104', '4', '17', '30', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40105', '4', '18', '30', '1', '69', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40112', '1', '8', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40112', '8', '3', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40114', '8', '2', '1', '1', '449', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40115', '2', '60', '1', '1', '149', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40121', '2', '12', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40122', '8', '13', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40125', '2', '13', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40156', '4', '3', '3', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40157', '1', '7', '3', '1', '299', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40157', '4', '2', '3', '1', '299', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40158', '1', '6', '3', '1', '449', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40158', '4', '1', '3', '1', '449', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40159', '3', '9', '1', '1', '399', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40164', '3', '3', '1', '1', '399', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40165', '3', '4', '1', '1', '399', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40166', '3', '5', '1', '1', '399', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40167', '3', '6', '1', '1', '399', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40168', '3', '7', '1', '1', '399', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40169', '3', '8', '1', '1', '499', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40170', '3', '10', '1', '1', '19', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40175', '3', '11', '1', '1', '19', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40176', '3', '12', '1', '1', '19', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40177', '3', '13', '1', '1', '19', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40178', '3', '14', '1', '1', '19', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40179', '3', '15', '1', '1', '19', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40180', '3', '16', '1', '1', '19', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40182', '4', '4', '3', '1', '299', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40183', '5', '4', '5', '1', '19', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40184', '1', '11', '5', '1', '1699', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40184', '5', '1', '5', '1', '1699', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40184', '5', '2', '1', '1', '349', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40185', '5', '3', '1', '1', '199', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40186', '5', '9', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40187', '5', '10', '1', '1', '179', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40188', '1', '13', '5', '1', '1199', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40188', '5', '11', '1', '1', '249', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40190', '8', '5', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40191', '8', '6', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40192', '8', '7', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40193', '8', '8', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40200', '1', '12', '15', '1', '1449', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40200', '5', '7', '15', '1', '1499', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40200', '5', '8', '5', '1', '499', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40201', '5', '5', '15', '1', '999', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40201', '5', '6', '5', '1', '349', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40202', '8', '9', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40203', '6', '1', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40204', '6', '4', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40205', '6', '2', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40206', '6', '5', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40207', '6', '3', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40208', '6', '6', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40209', '4', '19', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40211', '4', '20', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40213', '4', '21', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40215', '4', '22', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40217', '4', '23', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40222', '1', '9', '1', '1', '899', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40222', '8', '1', '1', '1', '899', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40241', '2', '11', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40269', '6', '8', '1', '1', '149', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40273', '4', '5', '1', '1', '479', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40307', '3', '18', '1', '1', '199', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40308', '3', '17', '1', '1', '199', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40337', '6', '7', '1', '1', '149', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40362', '1', '1', '1', '1', '69', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40362', '1', '2', '5', '1', '299', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40362', '1', '3', '50', '1', '2499', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40362', '1', '4', '100', '1', '4799', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40362', '2', '1', '1', '1', '69', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40362', '2', '2', '5', '1', '299', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40362', '2', '3', '50', '1', '2499', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40362', '2', '4', '200', '1', '9499', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40388', '6', '9', '1', '1', '1199', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40739', '3', '1', '1', '1', '299', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40741', '3', '2', '1', '1', '299', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41065', '2', '41', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41066', '2', '42', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41067', '2', '43', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41068', '2', '44', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41069', '2', '45', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41070', '2', '46', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41071', '2', '47', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41072', '2', '48', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41073', '2', '49', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41074', '2', '50', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41075', '2', '51', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41077', '2', '52', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41078', '2', '53', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41079', '2', '54', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41080', '2', '55', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41081', '1', '15', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41081', '2', '40', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41082', '2', '56', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41085', '2', '57', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41086', '2', '58', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41087', '2', '59', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41089', '8', '4', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41090', '1', '10', '50', '1', '249', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41090', '2', '5', '250', '1', '1149', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41090', '2', '6', '50', '1', '249', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41091', '8', '10', '1', '1', '349', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41092', '8', '11', '1', '1', '179', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41093', '8', '12', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('42089', '1', '16', '1', '1', '1', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49003', '7', '7', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49004', '7', '8', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49015', '7', '4', '1', '1', '129', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49021', '7', '10', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49033', '7', '3', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49035', '7', '1', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49051', '7', '9', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49062', '1', '14', '5', '1', '449', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49062', '7', '5', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49092', '7', '6', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49097', '7', '2', '1', '1', '199', '0', '1', '0', '', '');

-- ----------------------------
-- Alter Sequences Owned By
-- ----------------------------

-- ----------------------------
-- Indexes structure for table itemmall
-- ----------------------------
CREATE UNIQUE INDEX "itemmall_pi_index" ON "public"."itemmall" USING btree (item_group, item_index, money_unit);

 

[mekomeko]

I would do a global tutorial because many of these files are similar or identical.

I don't have time today, but tonight or tomorrow I'll do a tutorial.

I await your tutorial, I hope that it will be as clear as the aura kingdom or similar..

 

[mudevs]

I await your tutorial, I hope that it will be as clear as the aura kingdom or similar..

https://forum.ragezone.com/f857/grand-fantasia-server-files-1210135-post9158535/#post9158535

 

[Tryout]

@GaRocK I put inside the 2 def. in [common] section (I tried to put them in duplicate in Common and in MissionServer, we can no longer join the arenas, the buttons "Join" are in gray). In Common section, it's ok, we can join :

Portion of my setup.ini

Spoiler

[Common]
GameDBIP=127.0.0.1
GameDB=gf_gs
GameDBUser=spiritking
GameDBPassword=284ulj;6
Language=X
Locate=US
LogFile=Test.log
AccountDBIP=127.0.0.1
AccountDBName=gf_ls
AccountDBUser=spiritking
AccountDBPW=284ulj;6
TicketServerIP=127.0.0.1
TicketServerPort=7777
MissionServerIP=127.0.0.1
MissionServerPort=7654
BillingGatewayIP=127.0.0.1
BillingGatewayPort=5560
PingAlive=1
FBMsgUpdate=1
CrossWorldID=1010
MaintenanceDate=3
RankAward=1
NAT=0
AchievementGroupCheck=0
MemoryCheck=1
MemoryCheckTime=120
MemoryCheckSavingTime=300
MaxCharacterNumber=9
LuckyStarOpen=1
IsleWorldID=1010
PVPServer=1
BotServer=0
XTrap=0
Battlefield=1
FamilyBattle=1

-I found a quest that can't be completed because the NPC isn't there. I added it in Scene S100.ini (in Attachment)
Map : Kaslow (ID 100)
Coordinates : 309,154
Quest : Darkness cannot be seen !
NPC Name : <Suspicious Shadow> Alvin
NPC ID : 62213

Replace in :
Client/data/scene/
Server/data/scene (delete S100.ini.bin)

-Table "itemmall" generates errors in pgsql, some definitions are missing :
"on_sell_date"
"account_num_limit"
"allow_buy_level"
"new_account_day_limit"

My Table (Struture and Records):

Spoiler

-- ----------------------------
-- Table structure for itemmall
-- ----------------------------
DROP TABLE IF EXISTS "public"."itemmall";
CREATE TABLE "public"."itemmall" (
"item_id" int4 NOT NULL,
"item_group" int4 NOT NULL,
"item_index" int4 NOT NULL,
"item_num" int4 NOT NULL,
"money_unit" int4 NOT NULL,
"point" int4 NOT NULL,
"special_price" int4 NOT NULL,
"sell" int4 NOT NULL,
"not_sell_date" int4 NOT NULL,
"fortune_bag" text COLLATE "default" DEFAULT ''::text,
"note" text COLLATE "default" DEFAULT ''::text
)
WITH (OIDS=FALSE)

;

-- ----------------------------
-- Records of itemmall
-- ----------------------------
INSERT INTO "public"."itemmall" VALUES ('40019', '4', '10', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40020', '4', '9', '5', '1', '19', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40021', '4', '8', '5', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40022', '1', '5', '20', '1', '779', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40022', '4', '6', '20', '1', '779', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40022', '4', '7', '5', '1', '199', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40023', '4', '24', '5', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40025', '4', '25', '5', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40027', '4', '26', '5', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40029', '4', '27', '5', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40031', '4', '28', '5', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40033', '4', '11', '30', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40034', '4', '12', '30', '1', '39', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40035', '4', '13', '30', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40036', '4', '14', '30', '1', '69', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40038', '4', '15', '30', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40039', '4', '16', '30', '1', '39', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40040', '2', '9', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40040', '2', '10', '5', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40043', '2', '7', '15', '1', '89', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40043', '2', '8', '5', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40044', '2', '20', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40045', '2', '21', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40046', '2', '22', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40047', '2', '23', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40048', '2', '24', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40049', '2', '25', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40050', '2', '26', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40051', '2', '27', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40052', '2', '31', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40053', '2', '30', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40054', '2', '32', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40055', '2', '33', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40056', '2', '28', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40057', '2', '34', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40058', '2', '35', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40059', '2', '29', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40063', '2', '17', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40064', '2', '18', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40065', '2', '19', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40069', '2', '16', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40072', '2', '36', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40074', '2', '37', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40075', '2', '38', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40083', '2', '39', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40096', '2', '14', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40097', '2', '15', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40104', '4', '17', '30', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40105', '4', '18', '30', '1', '69', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40112', '1', '8', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40112', '8', '3', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40114', '8', '2', '1', '1', '449', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40115', '2', '60', '1', '1', '149', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40121', '2', '12', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40122', '8', '13', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40125', '2', '13', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40156', '4', '3', '3', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40157', '1', '7', '3', '1', '299', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40157', '4', '2', '3', '1', '299', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40158', '1', '6', '3', '1', '449', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40158', '4', '1', '3', '1', '449', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40159', '3', '9', '1', '1', '399', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40164', '3', '3', '1', '1', '399', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40165', '3', '4', '1', '1', '399', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40166', '3', '5', '1', '1', '399', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40167', '3', '6', '1', '1', '399', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40168', '3', '7', '1', '1', '399', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40169', '3', '8', '1', '1', '499', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40170', '3', '10', '1', '1', '19', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40175', '3', '11', '1', '1', '19', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40176', '3', '12', '1', '1', '19', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40177', '3', '13', '1', '1', '19', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40178', '3', '14', '1', '1', '19', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40179', '3', '15', '1', '1', '19', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40180', '3', '16', '1', '1', '19', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40182', '4', '4', '3', '1', '299', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40183', '5', '4', '5', '1', '19', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40184', '1', '11', '5', '1', '1699', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40184', '5', '1', '5', '1', '1699', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40184', '5', '2', '1', '1', '349', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40185', '5', '3', '1', '1', '199', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40186', '5', '9', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40187', '5', '10', '1', '1', '179', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40188', '1', '13', '5', '1', '1199', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40188', '5', '11', '1', '1', '249', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40190', '8', '5', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40191', '8', '6', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40192', '8', '7', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40193', '8', '8', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40200', '1', '12', '15', '1', '1449', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40200', '5', '7', '15', '1', '1499', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40200', '5', '8', '5', '1', '499', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40201', '5', '5', '15', '1', '999', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40201', '5', '6', '5', '1', '349', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40202', '8', '9', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40203', '6', '1', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40204', '6', '4', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40205', '6', '2', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40206', '6', '5', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40207', '6', '3', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40208', '6', '6', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40209', '4', '19', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40211', '4', '20', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40213', '4', '21', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40215', '4', '22', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40217', '4', '23', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40222', '1', '9', '1', '1', '899', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40222', '8', '1', '1', '1', '899', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40241', '2', '11', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40269', '6', '8', '1', '1', '149', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40273', '4', '5', '1', '1', '479', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40307', '3', '18', '1', '1', '199', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40308', '3', '17', '1', '1', '199', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40337', '6', '7', '1', '1', '149', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40362', '1', '1', '1', '1', '69', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40362', '1', '2', '5', '1', '299', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40362', '1', '3', '50', '1', '2499', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40362', '1', '4', '100', '1', '4799', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40362', '2', '1', '1', '1', '69', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40362', '2', '2', '5', '1', '299', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40362', '2', '3', '50', '1', '2499', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40362', '2', '4', '200', '1', '9499', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40388', '6', '9', '1', '1', '1199', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40739', '3', '1', '1', '1', '299', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('40741', '3', '2', '1', '1', '299', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41065', '2', '41', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41066', '2', '42', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41067', '2', '43', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41068', '2', '44', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41069', '2', '45', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41070', '2', '46', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41071', '2', '47', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41072', '2', '48', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41073', '2', '49', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41074', '2', '50', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41075', '2', '51', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41077', '2', '52', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41078', '2', '53', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41079', '2', '54', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41080', '2', '55', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41081', '1', '15', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41081', '2', '40', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41082', '2', '56', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41085', '2', '57', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41086', '2', '58', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41087', '2', '59', '1', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41089', '8', '4', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41090', '1', '10', '50', '1', '249', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41090', '2', '5', '250', '1', '1149', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41090', '2', '6', '50', '1', '249', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41091', '8', '10', '1', '1', '349', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41092', '8', '11', '1', '1', '179', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('41093', '8', '12', '5', '1', '9', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('42089', '1', '16', '1', '1', '1', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49003', '7', '7', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49004', '7', '8', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49015', '7', '4', '1', '1', '129', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49021', '7', '10', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49033', '7', '3', '1', '1', '29', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49035', '7', '1', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49051', '7', '9', '1', '1', '49', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49062', '1', '14', '5', '1', '449', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49062', '7', '5', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49092', '7', '6', '1', '1', '99', '0', '1', '0', '', '');
INSERT INTO "public"."itemmall" VALUES ('49097', '7', '2', '1', '1', '199', '0', '1', '0', '', '');

-- ----------------------------
-- Alter Sequences Owned By
-- ----------------------------

-- ----------------------------
-- Indexes structure for table itemmall
-- ----------------------------
CREATE UNIQUE INDEX "itemmall_pi_index" ON "public"."itemmall" USING btree (item_group, item_index, money_unit);

Thanks! Btw, did you manage to run it on VPS to open it online?

 

[toto4c19]

Thank you for everyone's effort. I have a few question want to ask and seeking for assistance:

1. Is there any ini mod tool (i.e. editting the ini in a proper table format) rather than just using notepad.

2. Since I want to do map modification (the fsm), may I know which file/db ini controlls the boundary. (i.e. map boarder for controlling movement). So that after modification, the character can walk outside of the map.

3. I have ENG 006.074.64.64 and TW 006.543.61.61 client. Do they really work? I have tried changing the "version number" in postgre -> server db but can't get to the world. Do I need do extra work or changes?

4. Is there a discord opened for troubleshooting or we just post questions here for now?

 

[soras2]

Does anyone have any ideas on how to resolve the channel crash bug when another player switches channels?I looked and looked and nothin

g ,_,

 

[SirBalta]

Arena solution? When you start, you are teleported to a random location.

 

[Sukiya]

Everything is running and I can even create an account, but I have a problem connecting in the game as it shows an Error. I already disabled firewall and I am also using Ubuntu 22.04 from DigitalOcean.

LoginServer logs:

Spoiler

1,2023/01/22 09:23:37,[EVENT] Connected to database[127.0.0.1].
2,2023/01/22 09:23:37,[EVENT] Get 1 world servers from DB.
3,2023/01/22 09:23:37,[EVENT] Load 1 records of AccountID from database.
4,2023/01/22 09:23:37,[EVENT] Load login_version: [Unknown_Version(Login)] from database done.
5,2023/01/22 09:23:37,[LoginServer.cc:72],Init Default NetCommand Table...
6,2023/01/22 09:23:38,RSA size = 256 size(e) = 2
7,2023/01/22 09:23:38,RSA size = 256 size(e) = 2
8,2023/01/22 09:23:38,Server is rolling on TCP 0.0.0.0:6543.
9,2023/01/22 09:23:38,Connect to 127.0.0.1<0x88C0908:10>:7777.
10,2023/01/22 09:23:38,Connect to 127.0.0.1<0x88D2828:11>:5560.
11,2023/01/22 09:23:38,[EVENT] LoginServer (with BillingGateway support) booting...
12,2023/01/22 09:23:38,[EVENT] EventUpdatePopulation constructed.
13,2023/01/22 09:23:38,Add New Epoll 9
14,2023/01/22 09:23:38,Add New Epoll 10
15,2023/01/22 09:23:38,Add New Epoll 11
16,2023/01/22 09:23:38,[EVENT] Update world: [1010] state: [0] ver: [Unknown_Version] successful.
17,2023/01/22 09:23:44,EVAL(5.914996 secs): {Network I/O}
18,2023/01/22 09:23:44,EVAL(5.917359 secs): {Main Loop}
19,2023/01/22 09:23:44,[EVENT] Update world: [1010] state: [1] ver: [006.058.64.64] successful.
20,2023/01/22 09:23:44,[EVENT] Update population of 1 servers.
21,2023/01/22 09:23:50,EVAL(6.006086 secs): {Network I/O}
22,2023/01/22 09:23:50,EVAL(6.006763 secs): {Main Loop}
23,2023/01/22 09:23:50,[EVENT] Update population of 1 servers.
24,2023/01/22 09:23:56,EVAL(6.007114 secs): {Network I/O}
25,2023/01/22 09:23:56,EVAL(6.008818 secs): {Main Loop}
26,2023/01/22 09:23:56,[EVENT] Update population of 1 servers.
27,2023/01/22 09:24:02,EVAL(6.001472 secs): {Network I/O}
28,2023/01/22 09:24:02,EVAL(6.002438 secs): {Main Loop}
29,2023/01/22 09:24:02,[EVENT] Update population of 1 servers.
30,2023/01/22 09:24:08,EVAL(6.006152 secs): {Network I/O}
31,2023/01/22 09:24:08,EVAL(6.006901 secs): {Main Loop}
32,2023/01/22 09:24:08,[EVENT] Update population of 1 servers.
33,2023/01/22 09:24:14,EVAL(6.006240 secs): {Network I/O}
34,2023/01/22 09:24:14,EVAL(6.006835 secs): {Main Loop}
35,2023/01/22 09:24:14,[EVENT] Update population of 1 servers.
36,2023/01/22 09:24:20,EVAL(6.006112 secs): {Network I/O}
37,2023/01/22 09:24:20,EVAL(6.006847 secs): {Main Loop}
38,2023/01/22 09:24:20,[EVENT] Update population of 1 servers.
39,2023/01/22 09:24:26,EVAL(6.006112 secs): {Network I/O}
40,2023/01/22 09:24:26,EVAL(6.006843 secs): {Main Loop}
41,2023/01/22 09:24:26,[EVENT] Update population of 1 servers.
42,2023/01/22 09:24:32,EVAL(6.006106 secs): {Network I/O}
43,2023/01/22 09:24:32,EVAL(6.006755 secs): {Main Loop}
44,2023/01/22 09:24:32,[EVENT] Update population of 1 servers.
45,2023/01/22 09:24:35,SOCKET 12: accepted by 9
46,2023/01/22 09:24:35,TCP <0x88D5108:12>: connected from (null) [210.1.128.52].
47,2023/01/22 09:24:35,EVAL(2.905708 secs): {Network I/O}
48,2023/01/22 09:24:35,EVAL(2.906326 secs): {Main Loop}
49,2023/01/22 09:24:35,Add New Epoll 12
50,2023/01/22 09:24:35,TCP <0x88D5108:12>: connection from '210.1.128.52' encrypted.
51,2023/01/22 09:24:35,[EVENT] Bind AccountName: [inplay] with SessionID: [1] in NE_CL_ServerLoginAccount.
52,2023/01/22 09:24:35,[NE_CL_ServerLoginAccount.cc:104],[DEBUG] [ 210.1.128.52null) ] Name: [inplay], Version: [006.058.64.64] 53,2023/01/22 09:24:35,[NC_G_ClientAccountLogin.cc:10],CNE_G_ClientAccountLogin ReturnCode=1
54,2023/01/22 09:24:35,[NE_G_ClientAccountLogin.cc:70],[ERROR] This username: [inplay] is already using with WRONG account id.
55,2023/01/22 09:24:38,EVAL(2.885988 secs): {Network I/O}
56,2023/01/22 09:24:38,EVAL(2.886051 secs): {Main Loop}

I get this same error, anyone know how to fix it?

I was able to fix it, i had to change the psql version in the 1 click setup install file to be able to connect to the database and made sure the right ports were opened i am connected with vps tested that other can join and it was success.

 

[Kamuisensei]

I get this same error, anyone know how to fix it?

I have the same type of error, connecting via LAN, the server works as expected, but when connecting via WAN, it displays "system error"

 

[soras2]

Check id account in gf_ls and id_num on tb_user in gf_ms , check if they are equal in "account,tb_user"

execute this querry in gf_ls

S[COLOR=#569CD6]ELECT[/COLOR][COLOR=#D4D4D4] pg_catalog.setval([/COLOR][COLOR=#CE9178]'public.tb_user_idnum_seq'[/COLOR][COLOR=#D4D4D4], [/COLOR][COLOR=#B5CEA8]1[/COLOR][COLOR=#D4D4D4], true);[/COLOR]

he sets default sequence of idnum being start in 1

 

[Tryout]

I get this same error, anyone know how to fix it?

I was able to fix it, i had to change the psql version in the 1 click setup install file to be able to connect to the database and made sure the right ports were opened i am connected with vps tested that other can join and it was success.

Do you mind share us your install.sh or the 1 click setup install to work with vps users?

 

[jtb1]

So let's help a bit people in difficulty about ini

So time to publish my decrypter ini for GF (builded version - C++ - if you need source just dm me on discord)

Download :

You must be registered to see links

Virustotal :

You must be registered to see links

(since use crypto with no openssl taked as flag by some virus protect)

How to use : Drag and drop your .ini.bin files --> that will create on same folder a .ini decrypted

Also be care about :
-> AntiRoot vm they mostly infected (happen on 3 other game), so make your own VM (you can take useresu script from AK atuo setup and remplace db and file by gf)

-> Don't forget remove on hexa in your client (GrandFantasia.exe) the upload system
--->

You must be registered to see links

remplace by someting else or corrupt adress for avoid issue !

-> If you have issue with db you need change to en_US.ISO-8859-1 (you can do it auto by this way)
1°) do "dpkg-reconfigure locales"
2°) choose "en_US.ISO-8859-1" (or you langue.ISO-8859-1)
3°) On terminal, do this "pg_dumpall > savedb.bin" that will save your original db on savedb.bin
3°) now do "pg_dropcluster --stop 9.5 main" (change number if you use more modern version of postgresql)
5°) then "pg_createcluster --locale en_US.ISO-8859-1 --start 9.5 main" (change number if you use more modern version of postgresql)
6°) put back the db by execute this "psql -f savedb.bin"
7°) If you have no error, your db is now in en_US.ISO-8859-1 (latin1)

 

[jtb1]

Whatever camed originaly on this post gave my ini editor updated for gf (some fix vs ee/ak version)

Ini Reader (it's tool for open ini as "exel" mostly)

you can rename col on folder "header" after have open filefor first time (will be named YourFile.col)
Download :

You must be registered to see links

Virustotal :

You must be registered to see links

(false positive - if you need source just dm me on discord )

 

[Tiansuo]

Someone knows why this skill is??? And can't be used

 

[strikeburst]

Hi! Can you please show how you fixed this issue? I'm having the same problem but I can't seem to fix it.

 

[lucasbrito]

I'm on an A vps and it keeps giving this error when logging in "System Error" does anyone know how to solve it?



How did you resolve this error?

 

[I Am NoLimiT]

I'm on an A vps and it keeps giving this error when logging in "System Error" does anyone know how to solve it?



How did you resolve this error?

Double check your IP's maybe you didn't set the IP correctly base on your VPS IP Address.

 

[Agrumon]

[Problem solved]
Sorry.

 

[Tryout]

[Problem solved]
Sorry.

How did you resolve it? So a person like me who has trouble in a future like this issue will have an answer.

 

[lucasbrito]

In the worlds table do I put private or public IP?I put public IP and try to access the client with public IP.