Jump to content
×
×
  • Create New...
  • 0

Won System Problem (inventory windows)


tristano98

Question

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 

Screenshot_4.png

Link to comment
Share on other sites

10 answers to this question

Recommended Posts

  • 0

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

 

Link to comment
Share on other sites

  • 0

(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.

  • Love 1
Link to comment
Share on other sites

  • 0
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 

Link to comment
Share on other sites

  • 0
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.."")

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.


Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.