Open the N11 database, select postgreSQL for the upper left connection
Connection name: Fill in whatever you want
Hostname or IP address: 192.168.200.128
Port: 5432
Initial database: postgres
Username: postgres
Password: 123456
Then find the table player_room_container, right-click and select dump sql file, select "Structure and Data", and save it directly to the desktop, which is convenient for modification and upload.
Find the sql file you saved on the desktop and open it with Notepad++ text, pull down a little bit, and copy and replace the following paragraph under -- Table structure for player_room_container
DROP TABLE IF EXISTS "public"."player_room_container";
CREATE TABLE "public"."player_room_container" (
"id" int4 NOT NULL,
"item_id" int4 NOT NULL,
"durability" int4 NOT NULL,
"maker" text COLLATE "default" DEFAULT ''::character varying,
"identify" int2 DEFAULT 1,
"embedded_amount" int4 DEFAULT 0,
"embedded_id1" int4 DEFAULT '-1'::integer,
"create_time" int4 DEFAULT 1,
"due_date" int4 DEFAULT 0,
"container_index" int4 DEFAULT '-1'::integer,
"combo_id" int4 DEFAULT 0,
"strengthen" int4 DEFAULT 0,
"cur_maxdurability" int4 DEFAULT 0,
"bind" int4 DEFAULT 0,
"account_id" int4 NOT NULL,
"loc" int4 NOT NULL,
"witchcraft" int4 DEFAULT 0,
"quality" int2 DEFAULT 0,
"plus_parameter" int8 DEFAULT 0,
"color" int8 DEFAULT 0,
"item_level" int4 DEFAULT 1,
"item_exp" int4 DEFAULT 0,
"embedded_level1" int4 DEFAULT 0,
"embedded_exp1" int4 DEFAULT 0,
"combo_id1" int4 DEFAULT 0,
"combo_plusrate1" int4 DEFAULT 0,
"combo_id2" int4 DEFAULT 0,
"combo_plusrate2" int4 DEFAULT 0,
"combo_id3" int4 DEFAULT 0,
"combo_plusrate3" int4 DEFAULT 0,
"combo_id4" int4 DEFAULT 0,
"combo_plusrate4" int4 DEFAULT 0,
"embedded_comboid1" int4 DEFAULT 0,
"embedded_comboid2" int4 DEFAULT 0,
"extra1" int4 DEFAULT 0,
"extra2" int4 DEFAULT 0,
"extra3" int4 DEFAULT 0,
"extra4" int4 DEFAULT 0,
"extra5" int4 DEFAULT 0,
"extra6" int4 DEFAULT 0,
"extra7" int4 DEFAULT 0,
"bind_after_combine" int4 DEFAULT 0,
"come_from" int4 DEFAULT 0,
"locked" int4 DEFAULT 0,
"param1" int4 DEFAULT 0,
"param2" int4 DEFAULT 0,
"combo_id5" int4 DEFAULT 0,
"combo_plusrate5" int4 DEFAULT 0,
"combo_id6" int4 DEFAULT 0,
"combo_plusrate6" int4 DEFAULT 0,
"combo_id7" int4 DEFAULT 0,
"combo_plusrate7" int4 DEFAULT 0,
"combo_id8" int4 DEFAULT 0,
"combo_plusrate8" int4 DEFAULT 0
)
WITH (OIDS=FALSE)
;
Save the above ↑↑↑, then delete the player_room_container table in N11, right-click on the blank space in N11, and choose to run the sql file
Find the modified file on your desktop and start executing it. It will take 2 seconds. After finishing, refresh the blank space of n11, and the file will appear. Then enter the game and look at the cabin to enter.
In fact, my table is missing "combo_id" int4 DEFAULT 0, this field, just add it in and it's done. Generally speaking, there is basically no problem! If it still doesn’t work, just compare it yourself, the following ones are missing, just add them
When you're done, reopen the client without restarting the server!
"id" "item_id" "durability" "maker" "identify" "embedded_amount" "embedded_id1" "create_time" "due_date" "container_index" "combo_id" "strengthen" "cur_maxdurability" "bind" "account_id" "loc" "witchcraft "" Quality "" Plus_parameter "" COLOR "" Combo_plusRate5 "" Combo_id5 "" Combo_id6 "" Combo_plusRate6 "" Combo_id7 "" Combo_id8 "" Combo_id " usrate8 "item_level" "item_exp" "Embedded_level1" "Embedded_exp1" "Combo_id1" "" "" "" "" combo_plusrate1" "combo_id2" "combo_plusrate2" "combo_id3" "combo_plusrate3" "combo_id4" "combo_plusrate4" "embedded_comboid1" "embedded_comboid2" "extra1" "extra2" "extra3" "extra4" "extra5" "extra6" "extra7" "bind_after_com bin" "come_from" "locked" "param1" "param2"
It's very detailed, it's all over my mouth, I'm also a novice, thanks to this forum for allowing us novice to play a lot of games and learn a lot! ~Finally, let’s upload some picture steps! v
You must be registered to see links