ascent server problem

[Insanity]

I'm having a little bit of a trouble with an Ascent repack from Kanqaz...
Everytime I log out from WoW and then log on again, all my gear is gone.
I've tried the .save commando and .saveall but nothing keeps the gear ingame. Could you please help me?

Best Regards, Insanity

[latruwski]

do you have a table called playeritems in your database?
that could be the problem...


grtz

[Insanity]

I dont have one, I just have the playercreateinfo_items.

how should I solve the problem?

[latruwski]

I dont have one, I just have the playercreateinfo_items.

how should I solve the problem?

nonono you NEED one but your core/database might be old... try installing a new database and core rev...

core revs you can find here:
http://www.mmowned.com/forums/emulat...d-regular.html

and latest blizzlike database here:
http://www.mmowned.com/forums/emulat...t-spawned.html

use rev 2016 and this database...
if you wnt fundatabase Chrispee has the best one
http://www.mmowned.com/forums/emulat...-finished.html

grtz

[Insanity]

mmkay, but my rev isn't so old.
I just need the playeritems table. how do I get one?
can I create it myself? or do I have to download?

[latruwski]

mmkay, but my rev isn't so old.
I just need the playeritems table. how do I get one?
can I create it myself? or do I have to download?

here ya go:
2 tables: playeritems and playeritems_external...

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for playeritems
-- ----------------------------
CREATE TABLE `playeritems` (
  `ownerguid` int(10) unsigned NOT NULL DEFAULT '0',
  `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `entry` int(10) unsigned NOT NULL DEFAULT '0',
  `creator` int(10) unsigned NOT NULL DEFAULT '0',
  `count` int(10) unsigned NOT NULL DEFAULT '0',
  `charges` int(10) unsigned NOT NULL DEFAULT '0',
  `flags` int(10) unsigned NOT NULL DEFAULT '0',
  `randomprop` int(10) unsigned NOT NULL DEFAULT '0',
  `randomsuffix` int(11) NOT NULL DEFAULT '0',
  `itemtext` int(10) unsigned NOT NULL DEFAULT '0',
  `durability` int(10) unsigned NOT NULL DEFAULT '0',
  `containerslot` int(11) NOT NULL DEFAULT '-1',
  `slot` tinyint(4) NOT NULL DEFAULT '0',
  `enchantments` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`guid`),
  KEY `ownerguid` (`ownerguid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='playeritems';
-- ----------------------------
-- Table structure for playeritems_external
-- ----------------------------
CREATE TABLE `playeritems_external` (
  `ownerguid` int(10) unsigned NOT NULL DEFAULT '0',
  `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `entry` int(10) unsigned NOT NULL DEFAULT '0',
  `creator` int(10) unsigned NOT NULL DEFAULT '0',
  `count` int(10) unsigned NOT NULL DEFAULT '0',
  `charges` int(10) unsigned NOT NULL DEFAULT '0',
  `flags` int(10) unsigned NOT NULL DEFAULT '0',
  `randomprop` int(10) unsigned NOT NULL DEFAULT '0',
  `randomsuffix` int(30) NOT NULL,
  `itemtext` int(10) unsigned NOT NULL DEFAULT '0',
  `durability` int(10) unsigned NOT NULL DEFAULT '0',
  `containerslot` int(11) DEFAULT '-1',
  `slot` tinyint(4) NOT NULL DEFAULT '0',
  `enchantments` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`guid`),
  UNIQUE KEY `guid` (`guid`),
  KEY `ownerguid` (`ownerguid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='playeritems_external';

grtz