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

[dann462]

Hey Mayogargler!

For GM use "a", but if you dont want to allow your friends to kick other or something like that, use these: http://www.mmowned.com/forums/emulat...tml#post551625

For exaple if you want to allow a player to use cheat commands and teleport use: "rq"

[latruwski]

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?

yes... the core is not compatible with the structure of the mailbox table in your database...
you said you were using 3.5 stable... delete the mailbox table from your DB and run this query:

CREATE TABLE `mailbox` (
  `message_id` int(10) unsigned NOT NULL default '0',
  `message_type` int(10) unsigned NOT NULL default '0',
  `player_guid` int(10) unsigned NOT NULL default '0',
  `sender_guid` int(10) unsigned NOT NULL default '0',
  `subject` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `body` longtext collate utf8_unicode_ci NOT NULL,
  `money` int(10) unsigned NOT NULL default '0',
  `attached_item_guid` bigint(20) unsigned NOT NULL default '0',
  `external_attached_item_guid` bigint(20) NOT NULL default '0',
  `cod` int(10) unsigned NOT NULL default '0',
  `stationary` int(10) unsigned NOT NULL default '0',
  `expiry_time` int(10) unsigned NOT NULL default '0',
  `delivery_time` int(10) unsigned NOT NULL default '0',
  `copy_made` int(10) unsigned NOT NULL default '0',
  `read_flag` tinyint(3) unsigned NOT NULL default '0',
  `deleted_flag` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

and test if it works then...

grtz

[latruwski]

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?

well you need to put the letters in there (abcdefg for example or efmopqr for example)... if you need to know what letters are corresponding to what commands check:
Gamemaster - Ascent Wiki

grtz

[**Sweeny**]

Hey you no how when you start up mysql on ac-web repacks, then go into sumthing like sqlyog then all the tables are there and stuff? how would I get all those tables and vendors etc. into an SQL file so I can just execute it into the database.??

[Gastricpenguin]

Right click on the table, and select the option "Backup Database as SQL Dump..."
Then choose a destination

[**Sweeny**]

No i no that :P but I mean when you use Mysql in ac-web repacks the tables are all made up.. I was wondering how too get all those tables into just 1 or 2 SQL files Im not looking too execute them into database.

EDIT: oh woops you mean I can transfer that table too any location like desktop? Thanks btw +rep

[Gastricpenguin]

Oh, you can right click on the database itself, then dump it.
And that is the correct option :P
Backup is the same thing as dump

[**Sweeny**]

Oh and 1 more question, how do I make it into a SQL file?? When i got into notepad then go save as.. it has the file types i want it only has .txt and all files and encoding has..unicode, unicode big edian and UTF-8

[Spartansp]

just save as (select from the dropdown menu all files) then save it as whatever.sql and you are done

[Gastricpenguin]

Just add the extension .SQL to the end of the name, instead of .txt :P

[**Sweeny**]

I dont get a choise to save as SQL

[Spartansp]

there is no choice... just look where it says.. save as text document(txt) and click on the arrow so you choose "all files" and save it with name like this "whatever.sql" click save youre done

[**Sweeny**]

k thnx gast

[Gastricpenguin]

Por ejemplo:

[2dgreengiant]

or ejemplo:

fail as it says text doxuments (*.txt)