[Info] Creature_names + Recall Table + manual acc creation - AscentWiki

[latruwski]

Ok i made a post to ask people to use ascentwiki, but i guess no one does :-/
One solution is that i am gonna post some stuff requested by people on this forum here... Creature_names from ascentWiki as requested:

|entry
|The entry/ID of the creature. Used to reference records of this table und to spawn creature ingame.
|-
|name
|Name of the creature. Displayed ingame.
|-
|subname
|Subname of the creature. Displayed ingame below the creature_name. Most time function of the Creature.
|-
|info_str
|The MouseFlags
|-
|Flags1 - Unknown yet. this is NOT like npcflags in creature_proto
|-
|type
|Type of the Creature. Values:
{| class="wikitable" width="100%"
!Value
!Type
|-
|1
|Beast
|-
|2
|Dragonkin
|-
|3
|Demon
|-
|4
|Elemental
|-
|5
|Giant
|-
|6
|Undead
|-
|7
|Humanoid
|-
|8
|Critter
|-
|9
|Mechanical
|-
|10
|Not Specified (using by mounts creatures)
|-
|11
|Totem
|}
|-
|Family
|Family of the creature. Values:
{| class="wikitable" width="100%"
!Value
!Family
|-
|1    
|Wolf
|-
|2    
|Cat
|-
|3    
|Spider
|-
|4    
|Bear
|-
|5    
|Boar
|-
|6    
|Crocolisk
|-
|7    
|Carrion Bird
|-
|8    
|Crab
|-
|9    
|Gorilla
|-
|10    
|[UNUSED]
|-
|11    
|Raptor
|-
|12    
|Tallstrider
|-
|13    
|[UNUSED]
|-
|14    
|[UNUSED]
|-
|15    
|Felhunter
|-
|16    
|Voidwalker
|-
|17    
|Succubus
|-
|18    
|[UNUSED]
|-
|19    
|Doomguard
|-
|20    
|Scorpid
|-
|21    
|Turtle
|-
|22    
|[UNUSED]
|-
|23    
|Imp
|-
|24    
|Bat
|-
|25    
|Hyena
|-
|26    
|Owl
|-
|27    
|Wind Serpent
|-
|28    
|Remote Control
|-
|29    
|Felguard
|-
|30    
|Dragonhawk
|-
|31    
|Ravager
|-
|32    
|Warp Stalker
|-
|33    
|Sporebat
|-
|34    
|Nether Ray
|-
|35    
|Serpent
|}
|-
|Rank
|Rank of the Creature. Values:
{| class="wikitable" width="100%"
!Value
!Rank
|-
|0
|Normal
|-
|1
|Elite
|-
|2
|Rare Elite (?)
|-
|3
|World Boss
|-
|4
|Rare
|}
|-
|unk4
|Need info here. Pls edit if you know.
|-
|SpellDataID
|Need info here. Pls edit if you know.
|-
|male_displayid
|Model ID of the creature if it's male.
|-
|female_displayid
|Model ID of the creature if it's female.
|-
|male_displayid
|Second Model ID of the creature if it's male.
|-
|female_displayid
|Second Model ID of the creature if it's female.
|-
|Civilian
|1-> is Civilian 0->no Civilian. | '''Note:''' Civilians generally means if creature have aggro range or not.
|-
|Leader
|Indicates if Creature is the Leader of a Faction. 1=Leader 0=No Leader. An example would be Thrall.

still dont believe ascentWiki is nice? it has all table structures posted also! for example recall table:

CREATE TABLE `recall` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `MapId` int(10) unsigned NOT NULL default '0',
  `positionX` float NOT NULL default '0',
  `positionY` float NOT NULL default '0',
  `positionZ` float NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Tele Command';

So you wnt to create your recall location manually (not ingame)?
well its easy to make a query for that:

insert into recall values(a,b,c,d,e,f);

where:
a = entry (just pick a number that does not exist in the recall table yet
b = name, the recall name so you use .recall port name -> that name
c = mapID (map ID where you wnt to be teleported)
d = positionX, x coords of the place
e = positionY, y coords of the place
f = positionZ, z coords of the place
easy huh?

hmm lets see more, what info is there about creating an account manually?
here we go:
structure:

CREATE TABLE `accounts` (
  `acct` int(10) unsigned NOT NULL auto_increment,
  `login` varchar(32) collate utf8_unicode_ci NOT NULL,
  `password` varchar(32) collate utf8_unicode_ci NOT NULL,
  `gm` varchar(32) collate utf8_unicode_ci NOT NULL,
  `banned` tinyint(3) unsigned NOT NULL default '0',
  `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00',
  `lastip` varchar(16) collate utf8_unicode_ci NOT NULL,
  `email` varchar(64) collate utf8_unicode_ci NOT NULL,
  `flags` tinyint(3) unsigned NOT NULL default '0',
  `forceLanguage` varchar(5) collate utf8_unicode_ci NOT NULL default 'enUS',
  `muted` int(30) not null default 0,
  PRIMARY KEY  (`acct`),
  UNIQUE KEY `login` (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

info needed to manually create an account:
Acct:ID of the account number you are creating. (Go down from 1)
Login:Username of the account
Password:Password of the account
Gm:Use "az" for admin, "a" for GM, or blank for player.
Lastlogin: Don't touch it
LastIp: Don't touch it
Email:Email on the account (Not needed)
Flags:Use "0" for non-burning crusade and "8" for burning crusade.
Forcelanguage:enUS for US.

What about GMcommands? i see tons of reposts about it here but why do we need to post it if it is right here:
Gamemaster - Ascent Wiki
all commands + info

note: do not give me rep for this, it is only an 95% copy of ascentWiki (allthough i put some info on there too... i did not make this!)
AscentWiki: Main Page - Ascent Wiki

Why did i make this post? Dam lot people should use ascentwiki hell more! I hope i prove that AscentWiki is seriously handy with this post!
*Still hoping more people will start using it morehnoes:*

grtz