x-MU.net форум

https://forum.ragezone.com/f508/mu-online-web-browser-version-745179/

[Err] 1064 - 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 '/*
SQLyog Community Edition- MySQL GUI v6.03
Host - 5.0.18-nt : Database - ' at line 1
[Err] /*
SQLyog Community Edition- MySQL GUI v6.03
Host - 5.0.18-nt : Database - muonline
*********************************************************************
Server version : 5.0.18-nt
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `muonline`;

USE `muonline`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `characters` */

DROP TABLE IF EXISTS `characters`;

CREATE TABLE `characters` (
`id` int(11) NOT NULL auto_increment,
`owner` int(11) default NULL,
`name` varchar(20) character set utf8 collate utf8_bin default NULL,
`class` int(11) default NULL,
`level` int(11) default NULL,
`strength` int(11) default NULL,
`agility` int(11) default NULL,
`stamina` int(11) default NULL,
`energy` int(11) default NULL,
`points` int(11) default NULL,
`fruits` int(11) default NULL,
`skills` mediumtext character set utf8 collate utf8_bin,
`experience` int(25) default NULL,
`hp_cur` int(11) default NULL,
`mp_cur` int(11) default NULL,
`inventory` mediumtext character set utf8 collate utf8_bin,
`equipment` mediumtext character set utf8 collate utf8_bin,
`monsters` int(11) default NULL,
PRIMARY KEY  (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `market` */

DROP TABLE IF EXISTS `market`;

CREATE TABLE `market` (
`id` int(11) unsigned NOT NULL auto_increment,
`item_code` varchar(256) default NULL,
`owner_id` int(11) default NULL,
`pstore_id` int(11) default NULL,
`start_time` int(11) default NULL,
`item_type` varchar(3) default NULL,
`item_excellent` int(3) default NULL,
`req_class` int(3) default NULL,
`item_name` varchar(256) default NULL,
`price` int(11) default NULL,
PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `users` */

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
`id` int(11) unsigned NOT NULL auto_increment,
`ip` varchar(20) default NULL,
`regtime` int(11) unsigned default NULL,
`username` varchar(30) default NULL,
`password` varchar(40) default NULL,
`email` varchar(255) default NULL,
`lastvisit` int(11) unsigned default NULL,
`active_char` varchar(11) default 'av1',
`zen` int(11) unsigned default NULL,
`pstore_open` int(11) unsigned default '0',
`pstore_open_time` int(11) default NULL,
`pstore` mediumtext,
`npc32_kind` varchar(30) default NULL,
`npc32` mediumtext,
`vault` mediumtext,
PRIMARY KEY  (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

3 сообщение сверху,повнимательнее смотри.