Won System Problem (inventory windows)

[tristano98 6]

Hello, i'm have add won system in my FS  but have this syserr :

This Fixed.... 

Spoiler

SYSERR: Aug 18 02:50:12 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id=31278' at line 1 (query: SELECT id, name, job, voice, dir, x, y, z, map_index, exit_x, exit_y, exit_map_index, hp, mp, stamina, random_hp, random_sp, playtime, gold, level, level_step, st, ht, dx, iq, exp, stat_point, skill_point, sub_skill_point, stat_reset_count, part_base, part_hair, part_sash, skill_level, quickslot, skill_group, alignment, mobile, horse_level, horse_riding, horse_hp, horse_hp_droptime, horse_stamina, UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play), horse_skill_point, chequeFROM player WHERE id=31278 errno: 1064)
SYSERR: Aug 18 02:50:12 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 0

 

New Error in Inventory Windows 

Edited August 24, 2022 by Metin2 Dev
Core X - External 2 Internal

[[007]DawisHU 262]

Hello,
problem in Player.player. Player table crashed
Right syntax
 

Quote

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for player
-- ----------------------------
DROP TABLE IF EXISTS `player`;
CREATE TABLE `player` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(24) NOT NULL DEFAULT 'NONAME',
  `job` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `voice` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `dir` tinyint(2) NOT NULL DEFAULT '0',
  `x` int(11) NOT NULL DEFAULT '0',
  `y` int(11) NOT NULL DEFAULT '0',
  `z` int(11) NOT NULL DEFAULT '0',
  `map_index` int(11) NOT NULL DEFAULT '0',
  `exit_x` int(11) NOT NULL DEFAULT '0',
  `exit_y` int(11) NOT NULL DEFAULT '0',
  `exit_map_index` int(11) NOT NULL DEFAULT '0',
  `hp` smallint(4) NOT NULL DEFAULT '0',
  `mp` smallint(4) NOT NULL DEFAULT '0',
  `stamina` smallint(6) NOT NULL DEFAULT '0',
  `random_hp` smallint(5) unsigned NOT NULL DEFAULT '0',
  `random_sp` smallint(5) unsigned NOT NULL DEFAULT '0',
  `playtime` int(11) NOT NULL DEFAULT '0',
  `level` tinyint(2) unsigned NOT NULL DEFAULT '1',
  `level_step` tinyint(1) NOT NULL DEFAULT '0',
  `st` smallint(3) NOT NULL DEFAULT '0',
  `ht` smallint(3) NOT NULL DEFAULT '0',
  `dx` smallint(3) NOT NULL DEFAULT '0',
  `iq` smallint(3) NOT NULL DEFAULT '0',
  `exp` int(11) NOT NULL DEFAULT '0',
  `gold` int(11) NOT NULL DEFAULT '0',
  `stat_point` smallint(3) NOT NULL DEFAULT '0',
  `skill_point` smallint(3) NOT NULL DEFAULT '0',
  `quickslot` tinyblob NOT NULL,
  `ip` varchar(15) NOT NULL DEFAULT '0.0.0.0',
  `part_main` smallint(6) NOT NULL DEFAULT '0',
  `part_base` tinyint(4) NOT NULL DEFAULT '0',
  `part_hair` smallint(4) NOT NULL DEFAULT '0',
  `skill_group` tinyint(4) NOT NULL DEFAULT '0',
  `skill_level` blob NOT NULL,
  `alignment` int(11) NOT NULL DEFAULT '0',
  `last_play` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `change_name` tinyint(1) NOT NULL DEFAULT '0',
  `mobile` varchar(24) DEFAULT NULL,
  `sub_skill_point` smallint(3) NOT NULL DEFAULT '0',
  `stat_reset_count` tinyint(4) NOT NULL DEFAULT '0',
  `horse_hp` smallint(4) NOT NULL DEFAULT '0',
  `horse_stamina` smallint(4) NOT NULL DEFAULT '0',
  `horse_level` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `horse_hp_droptime` int(10) unsigned NOT NULL DEFAULT '0',
  `horse_riding` tinyint(1) NOT NULL DEFAULT '0',
  `horse_skill_point` smallint(3) NOT NULL DEFAULT '0',
  `bossazrail` int(11) NOT NULL DEFAULT '0',
  `bosscol` int(11) NOT NULL DEFAULT '0',
  `bossdokuz` int(11) NOT NULL DEFAULT '0',
  `bossalev` int(11) NOT NULL DEFAULT '0',
  `jatekos_nev` varchar(24) CHARACTER SET ascii NOT NULL DEFAULT 'NONAME',
  `statusz` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '0',
  `szint` varchar(20) CHARACTER SET ascii NOT NULL DEFAULT 'Inaktiv',
  `lejarati_ido` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `account_id_idx` (`account_id`),
  KEY `name_idx` (`name`),
  KEY `jatekos_nev_idx` (`jatekos_nev`) USING BTREE,
  KEY `lejarati_ido` (`lejarati_ido`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=68753 DEFAULT CHARSET=latin1;

jatekos_nev status szint lejarati ido  = my job for upgraded vip sys just delete fields

 

[tristano98 6]

1 hour ago, [007]DawisHU said:

Hello,
problem in Player.player. Player table crashed
Right syntax
 

 

 

not work ....  i'm login, select character and the loading bar is blocked....  not syserr client

 

[[007]DawisHU 262]

Just now, tristano98 said:

 

not work ....  i'm login, select character and the loading bar is blocked....  not syserr client

 

check mysql player table empty u need to create new char

and old char PID give to new

easier : create new account

[tristano98 6]

6 minutes ago, [007]DawisHU said:

check mysql player table empty u need to create new char

and old char PID give to new

easier : create new account

Not Work

[[007]DawisHU 262]

29 minutes ago, tristano98 said:

Not Work

with new acc?

[tristano98 6]

2 minutes ago, [007]DawisHU said:

with new acc?

yes

[sxvoyz 60]

(query: SELECT id, name, job, voice, dir, x, y, z, map_index, exit_x, exit_y, exit_map_index, hp, mp, stamina, random_hp, random_sp, playtime, gold, level, level_step, st, ht, dx, iq, exp, stat_point, skill_point, sub_skill_point, stat_reset_count, part_base, part_hair, part_sash, skill_level, quickslot, skill_group, alignment, mobile, horse_level, horse_riding, horse_hp, horse_hp_droptime, horse_stamina, UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play), horse_skill_point, chequeFROM player WHERE id=31278 errno: 1064)

Syntax error.

[tristano98 6]

23 hours ago, sxvoyz said:

(query: SELECT id, name, job, voice, dir, x, y, z, map_index, exit_x, exit_y, exit_map_index, hp, mp, stamina, random_hp, random_sp, playtime, gold, level, level_step, st, ht, dx, iq, exp, stat_point, skill_point, sub_skill_point, stat_reset_count, part_base, part_hair, part_sash, skill_level, quickslot, skill_group, alignment, mobile, horse_level, horse_riding, horse_hp, horse_hp_droptime, horse_stamina, UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play), horse_skill_point, chequeFROM player WHERE id=31278 errno: 1064)

Syntax error.

fix, thanks 

[tristano98 6]

New Problem in inventory windows 

Edited August 24, 2022 by Metin2 Dev
Core X - External 2 Internal

[[007]DawisHU 262]

On Monday, August 21, 2017 at 4:37 PM, sxvoyz said:

(query: SELECT id, name, job, voice, dir, x, y, z, map_index, exit_x, exit_y, exit_map_index, hp, mp, stamina, random_hp, random_sp, playtime, gold, level, level_step, st, ht, dx, iq, exp, stat_point, skill_point, sub_skill_point, stat_reset_count, part_base, part_hair, part_sash, skill_level, quickslot, skill_group, alignment, mobile, horse_level, horse_riding, horse_hp, horse_hp_droptime, horse_stamina, UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(last_play), horse_skill_point, chequeFROM player WHERE id=31278 errno: 1064)

Syntax error.

Not good 

In quest local coins = insert here select querry.

And quest cmdchat(""..coins.."")