Thread: MMOFUSE 4.3.4 Blizzlike Cataclysm Repack

"CREATE TABLE `autobroadcast` (`realmid` INT(10) NOT NULL,
`id` INT(11) NOT NULL AUTO_INCREMENT,
`weight` TINYINT(3) NULL DEFAULT '1',
`text` LONGTEXT NOT NULL,
PRIMARY KEY (`id`, `realmid`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
AUTO_INCREMENT=1;
execute this in the auth db if you have problem starting up the server"

This should fix the auth errors, quoted from blindspell.

To your mysql error, you should make sure there's not another one running, open task lisk and check for existen mysql's, restart pc or whatever there will close it.

It might be à stupid question, but hiw do i exécute it? I just put it in somewhere or....

Originally Posted by swubu

right click desktop --> create new .txt ---> open it

copy paste

CREATE TABLE `autobroadcast` (`realmid` INT(10) NOT NULL,
`id` INT(11) NOT NULL AUTO_INCREMENT,
`weight` TINYINT(3) NULL DEFAULT '1',
`text` LONGTEXT NOT NULL,
PRIMARY KEY (`id`, `realmid`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
AUTO_INCREMENT=1;

save it as an .sql ( windows is going to blah bah just click yes ) ( also make sure you have the option hide extensions for know file types "OFF" not "ON" or else you cant change extensions )

how to change extensions


click start ---> control panel ---> folder option ---> click tab view ---> search for hide extensions for know file types and disable it ....

open Heidysql or which you have installed go to the authtable and inject that .sql you created ...


have funn

so...?
i tried to insert the new .sql file into heidisql.
For some reason it keeps on telling me that auth.autobroadcast already excists...

but the real problem is that i just don't find it in my folder.
and then to be honest... i'm not sure how to correctly add it in... :/

IT WORKED! thank you all