Doomed Realms Source (Non-messy version)

Ahlwong · 2014-08-13T09:22:50.000Z

[QUOTE=Killergard;9745147]lovrman can i add you on skype so u can help me?[/QUOTE] Lovro barely uses skype tehe

Originally Posted by Killergard

lovrman can i add you on skype so u can help me?

Lovro barely uses skype

dude the source is broken i mean i tried setting it up it doesent work i get 1 mysql error constantly

Originally Posted by Killergard

dude the source is broken i mean i tried setting it up it doesent work i get 1 mysql error constantly

I can tell you that the source is not broken.

Originally Posted by filenub

I also wouldn't even call it a source.

I was corrected by Donran about this remark. I meant I wouldn't call it it's own source.

ok but when i try to use it i get 1 mysql error can you help me?

Originally Posted by Killergard

ok but when i try to use it i get 1 mysql error can you help me?

Then what is that 1 MySQL error?

it says no database was selected even tho i did select struct in your folder so i do not know how to fix it how do i post a screen of it?

can i just have you back on Skype donran i really need your help

can you /give pets and the pets codeing is fucked up

how do you /give pets?

dude wtf is up with the MySQL error constantly \New folder\\Doomed Realms\\Doomed Realms\\db\\struct.sql"
ERROR 1067 (42000) at line 12: Invalid default value for 'regTime'

Operation failed with exitcode 1
18:29:57 Import of C:\Users\Nikki\Desktop\Doomed Realms\New folder\Doomed Realms\Doomed Realms\db\struct.sql has finished with 1 errors
i get this error can someone help?

can someone please answer me for this error

Originally Posted by Killergard

can someone please answer me for this error

Well I'm not getting that error so you should check your MySQL version or check if it's your client causing it.
But you said you were so good at programming but too lazy to go into the struct.sql and change the default value of regTime?

Code:

DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uuid` varchar(128) NOT NULL,
  `password` varchar(256) NOT NULL,
  `name` varchar(64) NOT NULL DEFAULT 'DEFAULT',
  `rank` int(11) NOT NULL DEFAULT '0',
  `namechosen` tinyint(1) NOT NULL DEFAULT '0',
  `verified` tinyint(1) NOT NULL DEFAULT '1',
  `guild` int(11) NOT NULL,
  `guildRank` int(11) NOT NULL,
  `vaultCount` int(11) NOT NULL DEFAULT '1',
  `maxCharSlot` int(11) NOT NULL DEFAULT '2',
  `regTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `guest` tinyint(1) NOT NULL DEFAULT '0',
  `banned` tinyint(1) NOT NULL DEFAULT '0',
  `locked` varchar(512) NOT NULL,
  `ignored` varchar(512) NOT NULL,
  `guildFame` varchar(512) NOT NULL,
  `bonuses` varchar(512) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

Try chaging that to 0, if that doesn't work replace that whole line with this:

Code:

`regTime` varchar(256) NOT NULL DEFAULT '0000-00-00 00:00:00',

How to /give pets tutorial

You use the command /give <pet name> generator

Now have fun and no the pets are not screwed up. They are perfectly fine. Now if there are any more errors, work it out yourself. When I first received this source, I had to work out how to set it up by myself so why don't you too.

no i keep getting same error even though i did exactly what you said so i have no idea what to do im using Mysql 6.1

Everytime when i start the download it stops ....
that sucks...

Similar Threads

Tags for this Thread