[DiscordArchive] where can i find this?
[DiscordArchive] where can i find this?
Original source
Search Tag: Fix mail_server_character (look below for sql)
rektbyfaith
05-08-2022, 05:17 PM #21Archived author: Goose • Posted: 2022-05-08T17:17:58.414000+00:00
Original source
Search Tag: Fix mail_server_character (look below for sql)
Original source
just tagging this message for future people using discord search
rektbyfaith
05-08-2022, 05:18 PM #22Archived author: Goose • Posted: 2022-05-08T17:18:10.723000+00:00
Original source
just tagging this message for future people using discord search
Original source
we are trying to figure out a solution for it...
rektbyfaith
05-08-2022, 05:18 PM #23Archived author: Kitzunu • Posted: 2022-05-08T17:18:35.103000+00:00
Original source
we are trying to figure out a solution for it...
Original source
lol
![[Image: unknown.png?ex=690c2fe9&is=690ade69&hm=4...f3cce880e&]](https://cdn.discordapp.com/attachments/284406375495368704/972910660214194196/unknown.png?ex=690c2fe9&is=690ade69&hm=45a2a4774fd9ea254b01f584a5c98a8424ea33fe5efa28ca4ef5eb7f3cce880e&)
rektbyfaith
05-08-2022, 05:19 PM #24Archived author: Goose • Posted: 2022-05-08T17:19:37.340000+00:00
Original source
lol
Original source
just skip the first insert
rektbyfaith
05-08-2022, 05:20 PM #25Archived author: Kitzunu • Posted: 2022-05-08T17:20:15.071000+00:00
Original source
just skip the first insert
Original source
rektbyfaith
05-08-2022, 05:20 PM #26Archived author: Kitzunu • Posted: 2022-05-08T17:20:16.778000+00:00
Original source
Original source
```sql
DROP TABLE IF EXISTS `mail_server_character`;
CREATE TABLE IF NOT EXISTS `mail_server_character` (
`guid` INT UNSIGNED NOT NULL,
`mailId` INT UNSIGNED NOT NULL,
PRIMARY KEY (`guid`, `mailId`)
) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4;
DROP TABLE IF EXISTS `mail_server_template`;
CREATE TABLE IF NOT EXISTS `mail_server_template` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`reqLevel` TINYINT UNSIGNED NOT NULL DEFAULT '0',
`reqPlayTime` INT UNSIGNED NOT NULL DEFAULT '0',
`moneyA` INT UNSIGNED NOT NULL DEFAULT '0',
`moneyH` INT UNSIGNED NOT NULL DEFAULT '0',
`itemA` INT UNSIGNED NOT NULL DEFAULT '0',
`itemCountA` INT UNSIGNED NOT NULL DEFAULT '0',
`itemH` INT UNSIGNED NOT NULL DEFAULT '0',
`itemCountH` INT UNSIGNED NOT NULL DEFAULT '0',
`subject` TEXT NOT NULL,
`body` TEXT NOT NULL,
`active` TINYINT UNSIGNED NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4;
```
this for character db
rektbyfaith
05-08-2022, 05:20 PM #27Archived author: Kitzunu • Posted: 2022-05-08T17:20:27.951000+00:00
Original source
```sql
DROP TABLE IF EXISTS `mail_server_character`;
CREATE TABLE IF NOT EXISTS `mail_server_character` (
`guid` INT UNSIGNED NOT NULL,
`mailId` INT UNSIGNED NOT NULL,
PRIMARY KEY (`guid`, `mailId`)
) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4;
DROP TABLE IF EXISTS `mail_server_template`;
CREATE TABLE IF NOT EXISTS `mail_server_template` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`reqLevel` TINYINT UNSIGNED NOT NULL DEFAULT '0',
`reqPlayTime` INT UNSIGNED NOT NULL DEFAULT '0',
`moneyA` INT UNSIGNED NOT NULL DEFAULT '0',
`moneyH` INT UNSIGNED NOT NULL DEFAULT '0',
`itemA` INT UNSIGNED NOT NULL DEFAULT '0',
`itemCountA` INT UNSIGNED NOT NULL DEFAULT '0',
`itemH` INT UNSIGNED NOT NULL DEFAULT '0',
`itemCountH` INT UNSIGNED NOT NULL DEFAULT '0',
`subject` TEXT NOT NULL,
`body` TEXT NOT NULL,
`active` TINYINT UNSIGNED NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=UTF8MB4;
```
this for character db
Original source
```sql
DELETE FROM `command` WHERE `name`='reload mail_server_template';
INSERT INTO `command` (`name`, `security`, `help`) VALUES
('reload mail_server_template', 3, 'Syntax: .reload mail_server_template\nReload server_mail_template table.');
```
This for world db
rektbyfaith
05-08-2022, 05:20 PM #28Archived author: Kitzunu • Posted: 2022-05-08T17:20:44.641000+00:00
Original source
```sql
DELETE FROM `command` WHERE `name`='reload mail_server_template';
INSERT INTO `command` (`name`, `security`, `help`) VALUES
('reload mail_server_template', 3, 'Syntax: .reload mail_server_template\nReload server_mail_template table.');
```
This for world db
Original source
thanks, now running the worldDB sql file
rektbyfaith
05-08-2022, 05:20 PM #29Archived author: Goose • Posted: 2022-05-08T17:20:45.906000+00:00
Original source
thanks, now running the worldDB sql file
Original source
that seemed to have fixed it!
rektbyfaith
05-08-2022, 05:23 PM #30Archived author: Goose • Posted: 2022-05-08T17:23:59.969000+00:00
Original source
that seemed to have fixed it!
1 Guest(s)
1 Guest(s)