[Share] Server fix lỗi + Việt hóa FULL [AHTT V2]

[gak0n2003]

Gia cát dự là sai đường dẫn admintool trong oss. bạn kiểm tra lại nhé! đó là 1 trong nhiều nguyên nhân...

--- Chế độ gộp bài viết ---



làm đúng theo chủ topic sẽ không lỗi, thử xóa cache đi xem trước khi cài lại.

Bác Quang Dũng có facebook không khi nào onl teamview kiểm tra hộ em với :X

[nobitajx2]

Bác nào hướng dẫn chạy web với, ném vào htdoc của xamp mak nó cứ trắng bóc

[gak0n2003]

Bác nào làm nó chạy được rồi cho em cái gì đó liên lạc được team view giúp em với
Em muốn chơi offline trên máy tính mà không cách nào vào được

[QuangDung]

Bác Quang Dũng có facebook không khi nào onl teamview kiểm tra hộ em với :X

bạn sai đường dẫn file swfobject.js trong file game.php

[nobitajx2]

bạn sai đường dẫn file swfobject.js trong file game.php

web bạn chạy đc không chỉ mình chạy web với

[kenpro7777]

id item lấy theo hình ảnh trong good ở client

Thanks bác bữa e ngồi mò lại nên thấy lun

Ko biết bác có tool gộp của nó ko , bác có inbox riêng e nhé , e hậu tạ sau

[nh0xIskate]

id item lấy theo hình ảnh trong good ở client

Muốn gộp được mỗi sever phải set s_id khác nhau, Nếu không sẽ trùng UID !
Lưu dữ liệu Server 2 là "arpg2'
Chạy lệnh SQL sau là gộp hoàn tất.
Dữ liệu sau khi gộp ở arpg, Xóa arpg2.

INSERT INTO `arpg`.`guild`(`guild_id`, `guild_name`, `create_time`, `guild_level`, `guild_exp`, `xiangfang_level`, `jianzhu_level1`, `jianzhu_exp1`, `jianzhu_level2`, `jianzhu_exp2`, `jianzhu_level3`, `jianzhu_exp3`, `jianzhu_level4`, `jianzhu_exp4`, `camp`, `notice`, `storage_use_limit`, `shop_use_limit`, `boss_level`, `boss_exp`, `boss_growup_value`, `last_update_dayid`, `warning_dismiss_days`, `applyfor_setup`, `boss_call_day_count`, `last_active_time`, `guild_task_score`, `tianci_tongbi_day_count`, `auto_kickout_setup`, `tower_defend_daycount`, `guild_max_capability`, `personal_tower_defend_max_wave`, `personal_equip_fb_max_layer`, `today_kill_shenjiang_flag`, `csqd_kill_boss_count`) SELECT `guild_id`, `guild_name`, `create_time`, `guild_level`, `guild_exp`, `xiangfang_level`, `jianzhu_level1`, `jianzhu_exp1`, `jianzhu_level2`, `jianzhu_exp2`, `jianzhu_level3`, `jianzhu_exp3`, `jianzhu_level4`, `jianzhu_exp4`, `camp`, `notice`, `storage_use_limit`, `shop_use_limit`, `boss_level`, `boss_exp`, `boss_growup_value`, `last_update_dayid`, `warning_dismiss_days`, `applyfor_setup`, `boss_call_day_count`, `last_active_time`, `guild_task_score`, `tianci_tongbi_day_count`, `auto_kickout_setup`, `tower_defend_daycount`, `guild_max_capability`, `personal_tower_defend_max_wave`, `personal_equip_fb_max_layer`, `today_kill_shenjiang_flag`, `csqd_kill_boss_count` FROM `arpg2`.`guild` WHERE 1;
INSERT INTO `arpg`.`guildevent`(`guild_id`, `event_index`, `FOR_INDEX`, `event_type`, `event_owner`, `event_owner_post`, `event_time`, `big_event`, `cannot_remove`, `param0`, `param1`, `param2`, `param3`, `sparam0`) SELECT `guild_id`, `event_index`, `FOR_INDEX`, `event_type`, `event_owner`, `event_owner_post`, `event_time`, `big_event`, `cannot_remove`, `param0`, `param1`, `param2`, `param3`, `sparam0` FROM `arpg2`.`guildevent` WHERE 1;
INSERT INTO `arpg`.`guildmember`(`guild_id`, `member_index`, `FOR_INDEX`, `uid`, `role_name`, `plat_name`, `level`, `sex`, `prof`, `post`, `gongxian`, `total_gongxian`, `zhangong`, `caifu`, `capability`, `vip_type`, `vip_level`, `join_time`, `last_login_time`, `guild_task_luck`, `blessing_count`, `be_blessing_count`) SELECT `guild_id`, `member_index`, `FOR_INDEX`, `uid`, `role_name`, `plat_name`, `level`, `sex`, `prof`, `post`, `gongxian`, `total_gongxian`, `zhangong`, `caifu`, `capability`, `vip_type`, `vip_level`, `join_time`, `last_login_time`, `guild_task_luck`, `blessing_count`, `be_blessing_count` FROM `arpg2`.`guildmember` WHERE 1;
INSERT INTO `arpg`.`guildstorage`(`guild_id`, `item_index`, `FOR_INDEX`, `item_id`, `item_is_bind`, `item_num`, `item_invalid_time`, `item_param`) SELECT `guild_id`, `item_index`, `FOR_INDEX`, `item_id`, `item_is_bind`, `item_num`, `item_invalid_time`, `item_param` FROM `arpg2`.`guildstorage` WHERE 1;
INSERT INTO `arpg`.`itemlist`(`role_id`, `itemlist_index`, `FOR_INDEX`, `item_id`, `is_bind`, `num`, `invalid_time`, `gold_price`, `param`, `special_param`) SELECT `role_id`, `itemlist_index`, `FOR_INDEX`, `item_id`, `is_bind`, `num`, `invalid_time`, `gold_price`, `param`, `special_param` FROM `arpg2`.`itemlist` WHERE 1;
INSERT INTO `arpg`.`login`(`plat_user_name`, `db_index`, `role_id_1`, `role_id_2`, `role_id_3`, `lastlogintime`, `createtime`, `forbidtime`, `is_anti_wallow`) SELECT `plat_user_name`, `db_index`, `role_id_1`, `role_id_2`, `role_id_3`, `lastlogintime`, `createtime`, `forbidtime`, `is_anti_wallow` FROM `arpg2`.`login` WHERE 1;
INSERT INTO `arpg`.`mount`(`role_id`, `mount_index`, `FOR_INDEX`, `mount_id`, `mount_name`, `strength_level`, `strength_lucky_val`, `grade`, `grade_bless_val`, `used_imageid`, `max_hp`, `gongji`, `fangyu`, `shanbi`, `mingzhong`, `baoji`, `jianren`, `movespeed`, `attr_flag`, `zz_maxhp`, `zz_gongji`, `zz_fangyu`, `zz_shanbi`, `zz_mingzhong`, `zz_baoji`, `zz_jianren`, `zz_up_val`, `zizhi`, `cur_liedan_index`, `today_liedan_times`, `liedanlist`) SELECT `role_id`, `mount_index`, `FOR_INDEX`, `mount_id`, `mount_name`, `strength_level`, `strength_lucky_val`, `grade`, `grade_bless_val`, `used_imageid`, `max_hp`, `gongji`, `fangyu`, `shanbi`, `mingzhong`, `baoji`, `jianren`, `movespeed`, `attr_flag`, `zz_maxhp`, `zz_gongji`, `zz_fangyu`, `zz_shanbi`, `zz_mingzhong`, `zz_baoji`, `zz_jianren`, `zz_up_val`, `zizhi`, `cur_liedan_index`, `today_liedan_times`, `liedanlist` FROM `arpg2`.`mount` WHERE 1;
INSERT INTO `arpg`.`pet`(`role_id`, `pet_index`, `FOR_INDEX`, `pet_id`, `pet_name`, `attr_id`, `image_pet_id`, `zizhi`, `jingli`, `level`, `exp`, `grow_level`, `grow_exp`, `hp`, `convert_bless_val`, `wuxing_level`, `wuxing_exp`, `liliang`, `jingzhun`, `tizhi`, `minjie`, `maxhp`, `maxmp`, `gongji`, `fangyu`, `shanbi`, `mingzhong`, `baoji`, `jianren`, `roll_info`, `passive_skill`, `active_skill`, `lingxue_ver`, `lingxue`) SELECT `role_id`, `pet_index`, `FOR_INDEX`, `pet_id`, `pet_name`, `attr_id`, `image_pet_id`, `zizhi`, `jingli`, `level`, `exp`, `grow_level`, `grow_exp`, `hp`, `convert_bless_val`, `wuxing_level`, `wuxing_exp`, `liliang`, `jingzhun`, `tizhi`, `minjie`, `maxhp`, `maxmp`, `gongji`, `fangyu`, `shanbi`, `mingzhong`, `baoji`, `jianren`, `roll_info`, `passive_skill`, `active_skill`, `lingxue_ver`, `lingxue` FROM `arpg2`.`pet` WHERE 1;
INSERT INTO `arpg`.`role`(`role_id`, `role_name`, `avatar`, `sex`, `scene_id`, `last_scene_id`, `level`, `professional`, `create_time`, `online_time`, `is_online`, `last_save_time`, `country`, `is_chongzhi`, `is_micro_pc`) SELECT `role_id`, `role_name`, `avatar`, `sex`, `scene_id`, `last_scene_id`, `level`, `professional`, `create_time`, `online_time`, `is_online`, `last_save_time`, `country`, `is_chongzhi`, `is_micro_pc` FROM `arpg2`.`role` WHERE 1;
INSERT INTO `arpg`.`roleskill`(`role_id`, `skill_index`, `FOR_INDEX`, `skill_level`, `skill_id`, `last_perform_time`) SELECT `role_id`, `skill_index`, `FOR_INDEX`, `skill_level`, `skill_id`, `last_perform_time` FROM `arpg2`.`roleskill` WHERE 1;
INSERT INTO `arpg`.`role_attr_detail`(`role_id`, `attr_data`, `role_name`, `level`, `sex`, `prof`, `camp`, `gold`, `gold_bind`, `coin`, `coin_bind`, `guild_id`, `guild_name`, `avatar`, `vip_type`, `evil`, `hp`, `max_hp`, `mp`, `max_mp`, `gongji`, `fangyu`, `mingzhong`, `shanbi`, `baoji`, `jianren`, `liliang`, `tizhi`, `jingzhun`, `minjie`, `feng_gongji`, `mu_gongji`, `shui_gongji`, `huo_gongji`, `feng_fangyu`, `mu_fangyu`, `shui_fangyu`, `huo_fangyu`, `baoshang`, `shouhu`, `chuantou`, `poji`, `capability`, `max_capability`, `all_charm`, `lover_uid`, `lover_name`, `authority_type`, `calling_petindex`, `forbid_talk_time`, `sublock_pw`, `rolechest_data_len`, `mentality_data`, `vip_data`, `active_degree_data`, `roleshop_data`, `welfare_data`, `rolehangup_data`, `rolecustom_data`, `itemcolddown_data`, `roleguildshop_data`, `evaluate_data`, `monitor_data`, `mounttime_data`, `mysteryshop_data`, `title_data`, `husongtask_data`, `xianbangtask_data`, `roleactivity_data`, `fbxianhunta_data`, `fbtowerdefend_data`, `guild_longhui_data`, `last_single_chat_monitor_time`, `last_single_chat_monitor_msg`, `last_world_chat_monitor_time`, `last_world_chat_monitor_msg`, `last_mail_monitor_time`, `last_mail_monitor_subject`, `today_online_time`, `lastday_online_time`, `xianjie_level`) SELECT `role_id`, `attr_data`, `role_name`, `level`, `sex`, `prof`, `camp`, `gold`, `gold_bind`, `coin`, `coin_bind`, `guild_id`, `guild_name`, `avatar`, `vip_type`, `evil`, `hp`, `max_hp`, `mp`, `max_mp`, `gongji`, `fangyu`, `mingzhong`, `shanbi`, `baoji`, `jianren`, `liliang`, `tizhi`, `jingzhun`, `minjie`, `feng_gongji`, `mu_gongji`, `shui_gongji`, `huo_gongji`, `feng_fangyu`, `mu_fangyu`, `shui_fangyu`, `huo_fangyu`, `baoshang`, `shouhu`, `chuantou`, `poji`, `capability`, `max_capability`, `all_charm`, `lover_uid`, `lover_name`, `authority_type`, `calling_petindex`, `forbid_talk_time`, `sublock_pw`, `rolechest_data_len`, `mentality_data`, `vip_data`, `active_degree_data`, `roleshop_data`, `welfare_data`, `rolehangup_data`, `rolecustom_data`, `itemcolddown_data`, `roleguildshop_data`, `evaluate_data`, `monitor_data`, `mounttime_data`, `mysteryshop_data`, `title_data`, `husongtask_data`, `xianbangtask_data`, `roleactivity_data`, `fbxianhunta_data`, `fbtowerdefend_data`, `guild_longhui_data`, `last_single_chat_monitor_time`, `last_single_chat_monitor_msg`, `last_world_chat_monitor_time`, `last_world_chat_monitor_msg`, `last_mail_monitor_time`, `last_mail_monitor_subject`, `today_online_time`, `lastday_online_time`, `xianjie_level` FROM `arpg2`.`role_attr_detail` WHERE 1;
INSERT INTO `arpg`.`role_attr_detail2`(`role_id`, `friendsetting_data`, `rolechest_data`, `effect_data`, `card_ver`, `card_data`, `equipfb_data`, `yuanlifb_common_data`, `yuanlifb_jingying_data`, `yuanlifb_autohook_data`, `vip_chest_data`, `equip_suit_data`, `pet_image_data`, `guild_task_data`, `xianjie_data`, `shenbing_data`, `gengu_data`, `autofb_data`, `newequipfb_data`, `xianjian_data`) SELECT `role_id`, `friendsetting_data`, `rolechest_data`, `effect_data`, `card_ver`, `card_data`, `equipfb_data`, `yuanlifb_common_data`, `yuanlifb_jingying_data`, `yuanlifb_autohook_data`, `vip_chest_data`, `equip_suit_data`, `pet_image_data`, `guild_task_data`, `xianjie_data`, `shenbing_data`, `gengu_data`, `autofb_data`, `newequipfb_data`, `xianjian_data` FROM `arpg2`.`role_attr_detail2` WHERE 1;
INSERT INTO `arpg`.`role_name_map`(`db_index`, `role_id`, `role_name`, `plat_user_name`) SELECT `db_index`, `role_id`, `role_name`, `plat_user_name` FROM `arpg2`.`role_name_map` WHERE 1;
INSERT INTO `arpg`.`shizhuang`(`role_id`, `part`, `FOR_INDEX`, `is_active`, `strength_level`, `lucky_val`, `select_seq`, `part_flag`, `is_active_part`, `active_sz_flag`, `history_active_sz_flag`, `time_sz_list`, `fulu_list`) SELECT `role_id`, `part`, `FOR_INDEX`, `is_active`, `strength_level`, `lucky_val`, `select_seq`, `part_flag`, `is_active_part`, `active_sz_flag`, `history_active_sz_flag`, `time_sz_list`, `fulu_list` FROM `arpg2`.`shizhuang` WHERE 1;
INSERT INTO `arpg`.`taskrecorder`(`role_id`, `task_id`, `FOR_INDEX`, `total_num`, `day_time`, `day_num`) SELECT `role_id`, `task_id`, `FOR_INDEX`, `total_num`, `day_time`, `day_num` FROM `arpg2`.`taskrecorder` WHERE 1;

Lệnh SQL Dọn rác server !

TRUNCATE `accountgold`;
TRUNCATE `accountidentity`;
TRUNCATE `achieve`;
TRUNCATE `blacklists`;
TRUNCATE `camp`;
TRUNCATE `command`;
TRUNCATE `content`;
TRUNCATE `crossrecord`;
TRUNCATE `crossstatus`;
TRUNCATE `cross_personrank`;
TRUNCATE `dailyfind`;
TRUNCATE `enemy`;
TRUNCATE `friends`;
TRUNCATE `guildachieve`;
TRUNCATE `guildapplyfor`;
TRUNCATE `guildunion`;
TRUNCATE `guildunion_applyfor`;
TRUNCATE `hotkey`;
TRUNCATE `lingmai`;
TRUNCATE `login_account`;
TRUNCATE `mail`;
TRUNCATE `offlineregister`;
TRUNCATE `personrank`;
TRUNCATE `publicnotice`;
TRUNCATE `publicsale`;
TRUNCATE `shop`;
TRUNCATE `shop_log`;
TRUNCATE `spread_ip`;
TRUNCATE `systemmail`;
TRUNCATE `systemmail_event`;
TRUNCATE `taskphase`;
TRUNCATE `teamrank`;
TRUNCATE `worldstatus`;
DELETE FROM `arpg`.`guild` WHERE `guild`.`guild_id` = 0;
DELETE FROM `arpg`.`guildevent` WHERE `guildevent`.`guild_id` = 0;
DELETE FROM `arpg`.`guildmember` WHERE `guildmember`.`guild_id` = 0;
DELETE FROM `arpg`.`guildstorage` WHERE `guildstorage`.`guild_id` = 0;
DELETE FROM `arpg`.`itemlist` WHERE `itemlist`.`role_id` = 0;
DELETE FROM `arpg`.`login` WHERE `login`.`role_id_1` = 0;
DELETE FROM `arpg`.`mount` WHERE `mount`.`role_id` = 0;
DELETE FROM `arpg`.`pet` WHERE `pet`.`role_id` = 0;
DELETE FROM `arpg`.`role` WHERE `role`.`role_id` = 0;
DELETE FROM `arpg`.`roleskill` WHERE `roleskill`.`role_id` = 0;
DELETE FROM `arpg`.`role_attr_detail` WHERE `role_attr_detail`.`role_id` = 0;
DELETE FROM `arpg`.`role_attr_detail2` WHERE `role_attr_detail2`.`role_id` = 0;
DELETE FROM `arpg`.`role_name_map` WHERE `role_name_map`.`role_id` = 0;
DELETE FROM `arpg`.`shizhuang` WHERE `shizhuang`.`role_id` = 0;
DELETE FROM `arpg`.`taskrecorder` WHERE `taskrecorder`.`role_id` = 0;

[kenpro7777]

Thanks bác để e test xem nt , có gì e tín dụng lại bác trong inbox nhé

[gak0n2003]

Hic vào được rồi mà bị lỗi thùng đồ
Chưa full thùng mà nó cứ báo full hoặc không nhìn thấy vật phẩm.
Bro nào đã fix được lỗi này. Hướng dẫn em với nhé

[kenpro7777]

Cho mình hỏi ngu vài phát là điều chỉnh lv nv nằm ỡ file nào , khi lên cấp 50 60 70 nó tặng KNB là ỡ file nào và điều chỉnh độ dài ký tự khi tạo nv , bác nào cao tay giúp mình với