[NEW] EMU Expert Question/request/FAQ thread, QUESTIONS HERE!

[WoWLegend]

Hey guys,


just to make life easier for all of us, I'm restarting the EMU Expert support thread.

Post your questions here! (and only here...if you can)

[runiker]

hey how do you reduce the hearthstone cooldown i seen it done but i just need to fig it out thank you

[Gastricpenguin]

This is a base query to edit the cooldown on the hearthstone:

UPDATE `items` SET `spellcooldown_1`='30000' WHERE (`entry`='6948');


Change 30000 to any number (in miliseconds)
Then run the query. And then your hearthstone will have that cooldown

[C-Death]

Can you make it so when a boss is killed, the wall behind him (A GO WALL) Drops?

[runiker]

Ok i was told somthing else is there a way to make a custom hearthstone that will only port to a few innkeeps like a whole new system

like herthstone b will bring you back to innkeepers only we make but NOT the other city ones is there a way to change that?

[Gastricpenguin]

That would have to be done in C++ scripting, and would be very tough to define.

[runiker]

me or him if it is me thank you for helping me n e ways ill use the cool down instead.

[Hellgawd]

@Deathboy: You could use a mixture of LUA scripts and clever Game Objects, and it just might be possible.
Try looking for a door gameobject that falls down when opened, lock it closed, and have the LUA/C++ Script activate it (Makes it fall down.)
It wont be simple, though.
-Hell
(Yes, I am a self-exclaimed Emu Expert )

[Spartansp]

Ok i was told somthing else is there a way to make a custom hearthstone that will only port to a few innkeeps like a whole new system

like herthstone b will bring you back to innkeepers only we make but NOT the other city ones is there a way to change that?

yes it can be done without C++ just as making a custom portal without lua guide then you just need to put the same spell and its done if you dont get it ill explain better

[King Shaun]

Hehe nice, glad there is a new one, the other one was jam-packed!

[dann462]

Those any one have a compatible account db for ascent 3.5 stable?

[latruwski]

Those any one have a compatible account db for ascent 3.5 stable?

try this:

/*
SQLyog Enterprise - MySQL GUI v6.13
MySQL - 5.0.41-community-nt : Database - logon
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `accounts` */

CREATE TABLE `accounts` (
  `acct` int(10) unsigned NOT NULL auto_increment COMMENT 'Unique ID',
  `login` varchar(32) collate utf8_unicode_ci NOT NULL COMMENT 'Login username',
  `password` varchar(32) collate utf8_unicode_ci NOT NULL COMMENT 'Login password',
  `gm` varchar(32) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Game permissions',
  `banned` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Account Standing',
  `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'Last login timestamp',
  `lastip` varchar(16) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Last remote address',
  `email` varchar(64) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Contact e-mail address',
  `flags` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Client flags',
  `forceLanguage` varchar(5) collate utf8_unicode_ci NOT NULL default 'enUS',
  PRIMARY KEY  (`acct`),
  UNIQUE KEY `login` (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Account Information';

/*Table structure for table `ipbans` */

CREATE TABLE `ipbans` (
  `ip` varchar(16) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Remote host',
  `expire` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'Expiry time (s)',
  PRIMARY KEY  (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='IPBanner';

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

and wowlegend, thx m8 this needed a cleanup hard time

grtz

[Illidan1]

Yeah cheers bro, who new Thread , any Questioms

[dann462]

Well thanks latruwski +rep, but I have a problem now.
So when ppl send a mail to their other char it fail. I got this report in the ascent.exe:
Sql query failed due to [Column count doesn't match value count at row 1], Query: [REPLACE INTO mailbox VALUES <4,0,55,11,"Mail","test",0,' ',0,41,1204461960,1201869960,0,0,0>]

Any idea?

[mayogargler]

Hey, I started up private server just so me and my friends can have some fun. I'm using Ascent, and at the moment, it's an offline server. My friends want to be GMs on my server. I use navicat as my database, what do I put into the "gm" column to make them GMs. I know admin is "az", but I don't want the server to go crazy. Can anyone help?