Beiträge von Riddick

Riddick · 22. Oktober 2016

Wie kann man die Beschreibung im Yang (einzahl/auszahl) Fenster ändern?
Da steht ProfEnte dran.

Riddick · 22. Oktober 2016

Welche Files nutzt du?

Riddick · 20. Oktober 2016

Spoiler anzeigen

Code

[Err] 1366 - Incorrect string value: '\xFCstung' for column 'name' at row 1
[Err] CREATE DATABASE IF NOT EXISTS `anyshop`;
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `anyshop`.`categories`;
CREATE TABLE `anyshop`.`categories` (
`cat_id` int(255) NOT NULL DEFAULT '0',
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`cat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of category_names
-- ----------------------------
INSERT INTO `anyshop`.`categories` VALUES ('1', 'Waffe');
INSERT INTO `anyshop`.`categories` VALUES ('2', 'R�stung');
INSERT INTO `anyshop`.`categories` VALUES ('3', 'Sonstiges');
-- ----------------------------
-- Table structure for `itemshop_items`
-- ----------------------------
DROP TABLE IF EXISTS `anyshop`.`shopitems`;
CREATE TABLE `anyshop`.`shopitems` (
`vnum` int(12) NOT NULL DEFAULT '0',
`shop_id` int(255) NOT NULL DEFAULT '0',
`cat_id` int(255) DEFAULT NULL,
`preis` int(255) DEFAULT '1',
`rabatt` int(255) DEFAULT '0',
`angebot` datetime DEFAULT '0000-00-00 00:00:00',
`verkauft` int(255) DEFAULT '0',
PRIMARY KEY (`shop_id`,`vnum`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of itemshop_items
-- ----------------------------
INSERT INTO `anyshop`.`shopitems` VALUES ('19', '1', '1', '80', '50', '2016-08-26 07:13:25', '10');
INSERT INTO `anyshop`.`shopitems` VALUES ('39', '1', '1', '1', '0', '0000-00-00 00:00:00', '10');
INSERT INTO `anyshop`.`shopitems` VALUES ('55', '1', '1', '300', '0', '0000-00-00 00:00:00', '0');
INSERT INTO `anyshop`.`shopitems` VALUES ('108', '1', '1', '50', '0', '0000-00-00 00:00:00', '0');
INSERT INTO `anyshop`.`shopitems` VALUES ('189', '1', '1', '150', '0', '0000-00-00 00:00:00', '0');
INSERT INTO `anyshop`.`shopitems` VALUES ('209', '1', '1', '20', '0', '0000-00-00 00:00:00', '0');
INSERT INTO `anyshop`.`shopitems` VALUES ('299', '1', '1', '5000', '0', '0000-00-00 00:00:00', '0');
INSERT INTO `anyshop`.`shopitems` VALUES ('1009', '1', '1', '530', '0', '0000-00-00 00:00:00', '0');
INSERT INTO `anyshop`.`shopitems` VALUES ('1029', '1', '1', '1000', '0', '0000-00-00 00:00:00', '0');
INSERT INTO `anyshop`.`shopitems` VALUES ('3001', '1', '1', '200', '0', '0000-00-00 00:00:00', '0');
INSERT INTO `anyshop`.`shopitems` VALUES ('71050', '1', '3', '1', '0', '0000-00-00 00:00:00', '15');
-- ----------------------------
-- Table structure for `itemshop_names`
-- ----------------------------
DROP TABLE IF EXISTS `anyshop`.`shops`;
CREATE TABLE `anyshop`.`shops` (
`shop_id` int(255) NOT NULL DEFAULT '0',
`name` varchar(255) DEFAULT NULL,
`suffix` varchar(7) DEFAULT '',
`coin_column` varchar(255) DEFAULT NULL,
PRIMARY KEY (`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of itemshop_names
-- ----------------------------
INSERT INTO `anyshop`.`shops` VALUES ('1', 'ItemShop', 'I-Coins', 'coins');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Alles anzeigen

Weiß da wer weiter?
Hatte die SQL eingefügt aber die war erstaunlicherweise leer, dann habe ich die SQL neu heruntergeladen und dann war alles in der SQL drin.
Habe es dann versucht neu hoch zu laden aber kommt immer wieder der selbe Error.

Riddick · 17. Oktober 2016

Ist die SQL bewusst leer?

Beiträge von Riddick

Handelscenter von Kilroy.

Cube (Craft) probleme

[How to]Anyshop

[How to]Anyshop