Asbert75

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES (1, 1, 1, 15, -2666.66, -5007.84, 21.0859, 2.96613);
INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES (1, 2, 1, 15, -2666.66, -5007.84, 21.0859, 2.96613);
INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES (1, 4, 1, 15, -2666.66, -5007.84, 21.0859, 2.96613);
INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES (1, 5, 1, 15, -2666.66, -5007.84, 21.0859, 2.96613);
INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES (1, 8, 1, 15, -2666.66, -5007.84, 21.0859, 2.96613);
INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`

Asbert75

#include "ScriptPCH.h"
 
struct Rochet2
{
  uint8 icon;
  std::string name;
	uint32 HK, titleID;
};

/*

Asbert75

#include "ScriptPCH.h"
#include "Chat.h"

class cs_world_chat : public CommandScript
{
public:
    cs_world_chat() : CommandScript("cs_world_chat"){}

    ChatCommand * GetCommands() const
    {

Asbert75

Revision: TrinityCore rev. 45bae8d4b74d+ 2013-05-04 20:50:14 +0200 (master branch) (Win32, Release)
Date 10:5:2013. Time 21:35 
//=====================================================
*** Hardware ***
Processor: AMD Phenom(tm) 8650 Triple-Core Processor
Number Of Processors: 3
Physical Memory: 2620600 KB (Available: 722048 KB)
Commit Charge Limit: 4194303 KB

*** Operation System ***

Asbert75

Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.0g 18 Jan 2012 (library: OpenSSL 1.0.0g 18 Jan 2012)
Using ACE version: 6.1.4
TrinityCore rev. 45bae8d4b74d+ 2013-05-04 20:50:14 +0200 (master branch) (Win32, Release) (worldserver-daemon)
<Ctrl-C> to stop.

 ______                       __
/\__  _\       __          __/\ \__
\/_/\ \/ _ __ /\_\    ___ /\_\ \, _\  __  __
   \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \

Asbert75

#include "ScriptPCH.h"
#include "Chat.h"

int accLvl(Player * player)
{
  uint32 accID = player->GetSession()->GetAccountId();
	QueryResult acc = LoginDatabase.PQuery("SELECT * FROM account_access WHERE id = '%u'", accID);
	if (!acc)
		return 0;
	Field * accInfo = acc->Fetch();

Asbert75

-- Druid chest
INSERT INTO `playercreateinfo_item` (race,class,itemid,amount) VALUES (0,11,33694,1);
INSERT INTO `playercreateinfo_item` (race,class,itemid,amount) VALUES (0,11,33675,1);
INSERT INTO `playercreateinfo_item` (race,class,itemid,amount) VALUES (0,11,33771,1);

-- Druid hands
INSERT INTO `playercreateinfo_item` (race,class,itemid,amount) VALUES (0,11,33690,1);
INSERT INTO `playercreateinfo_item` (race,class,itemid,amount) VALUES (0,11,33671,1);
INSERT INTO `playercreateinfo_item` (race,class,itemid,amount) VALUES (0,11,33767,1);

Asbert75

-- DK chest
INSERT INTO `playercreateinfo_item` (race,class,itemid,amount) VALUES (0,6,90000,1);

-- DK hands
INSERT INTO `playercreateinfo_item` (race,class,itemid,amount) VALUES (0,6,90001,1);

/* DK head */
INSERT INTO `playercreateinfo_item` (race,class,itemid,amount) VALUES (0,6,90002,1);

/* DK legs */

Asbert75

-- Warlock chest
INSERT INTO `playercreateinfo_item` (race,class,itemid,amount) VALUES (0,9,33680,1);

-- Warlock hands
INSERT INTO `playercreateinfo_item` (race,class,itemid,amount) VALUES (0,9,33676,1);

/* Warlock head */
INSERT INTO `playercreateinfo_item` (race,class,itemid,amount) VALUES (0,9,33677,1);

Asbert75

-- Mage chest
INSERT INTO `playercreateinfo_item` (race,class,itemid,amount) VALUES (0,8,33760,1);

-- Mage hands
INSERT INTO `playercreateinfo_item` (race,class,itemid,amount) VALUES (0,8,33759,1);

/* Mage head */
INSERT INTO `playercreateinfo_item` (race,class,itemid,amount) VALUES (0,8,33758,1);