Diablox

Look in mangosd.conf

# AlwaysMaxSkillForLevel

# Players will automatically gain max level dependent (weapon/defense) skill when logging in, leveling up etc.

# Default: 0 (false)

# 1 (true)

This one is not tested but i think it is working.

http://gist.github.com/364819

Empty game_event table.

git clone git://github.com/mangos/mangos.git

cd mangos

git reset --hard d6b3da1b8da9a110039c067091d58aa94b21a15d

Try this. It should revert back to 332

You will delete every single spell from all character. They even cant speek when you delete all spells. .reset spell does what you want to do.

Good example would be http://www.wowhead.com/quest=12733 where you need to duel 5 npc and you can do that 5 times with one npc but if you use this then you need to duel 5 difrent npc.

Now SVN-lovers can stop complaining and start doing something useful.

I think item text is now stored in item_instance table and mail text is stored in new field inside mail table.

9716_01_mangos_npc_vendor.sql does not work. This is fixed version

ALTER TABLE db_version CHANGE COLUMN required_9710_01_mangos_command required_9716_01_mangos_npc_vendor bit;

ALTER TABLE npc_vendor
 DROP PRIMARY KEY,
 ADD PRIMARY KEY  (`entry`,`item`,`ExtendedCost`);

MaNGOS 9324

YTDB 533

SD2 1565

Confirmed

I had over 2 weeks uptime whit avrege of 100 players (he didint crash after 2 weeks i just wanted to update the core)

1. Why you use SVN when mangos uses git?

2. Why do someone need all does commands? Is it so hard do learn mangos commands?

3. Why did you go whit 3.2.2 core when its not supported yet?

I can clone on other sistems but they are all 8.10

Only thing i cant think of is that i instaled 8.10 i did dist-update to 9.04 that is what i will do on my server (or to travel 150 km and reinstall the whole sistem).

BTW i downloaded source on antoher sistem copy paste it on VM server and was able to compile but i need git

EDIT: Solved Just reinstall git-core

I instaled 9.04 on VM and now a new problem starst to anoy!!

git clone git://github.com/mangos/mangos.git

Initialized empty Git repository in /mangos/.git/

remote: Counting objects: 35956, done.

remote: Compressing objects: 100% (7022/7022), done.

remote: Total 35956 (delta 29064), reused 35770 (delta 28881)

Receiving objects: 100% (35956/35956), 28.93 MiB | 231 KiB/s, done.

fatal: index-pack failed

I did tryed to compile openssl from source but it didnt help (maybe i did something wrong).

So i need to go to 9.10

Now i got this

../shared/Auth/libmangosauth.a(BigNumber.o): In function `BigNumber::SetRand(int)':

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/BigNumber.cpp:74: undefined reference to `BN_rand'

../shared/Auth/libmangosauth.a(BigNumber.o): In function `BigNumber::ModExp(BigNumber const&, BigNumber const&)':

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/BigNumber.cpp:145: undefined reference to `BN_CTX_new'

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/BigNumber.cpp:146: undefined reference to `BN_mod_exp'

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/BigNumber.cpp:147: undefined reference to `BN_CTX_free'

../shared/Auth/libmangosauth.a(BigNumber.o): In function `BigNumber::Exp(BigNumber const&)':

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/BigNumber.cpp:133: undefined reference to `BN_CTX_new'

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/BigNumber.cpp:134: undefined reference to `BN_exp'

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/BigNumber.cpp:135: undefined reference to `BN_CTX_free'

../shared/Auth/libmangosauth.a(BigNumber.o): In function `BigNumber::operator%=(BigNumber const&)':

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/BigNumber.cpp:121: undefined reference to `BN_CTX_new'

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/BigNumber.cpp:122: undefined reference to `BN_div'

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/BigNumber.cpp:123: undefined reference to `BN_CTX_free'

../shared/Auth/libmangosauth.a(BigNumber.o): In function `BigNumber::operator-=(BigNumber const&)':

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/BigNumber.cpp:91: undefined reference to `BN_sub'

../shared/Auth/libmangosauth.a(BigNumber.o): In function `BigNumber::operator+=(BigNumber const&)':

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/BigNumber.cpp:85: undefined reference to `BN_add'

../shared/Auth/libmangosauth.a(Sha1.o): In function `Sha1Hash::Finalize()':

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/Sha1.cpp:64: undefined reference to `SHA1_Final'

../shared/Auth/libmangosauth.a(Sha1.o): In function `Sha1Hash::UpdateData(unsigned char const*, int)':

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/Sha1.cpp:34: undefined reference to `SHA1_Update'

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/Sha1.cpp:34: undefined reference to `SHA1_Update'

../shared/Auth/libmangosauth.a(Sha1.o): In function `Sha1Hash::Initialize

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/Sha1.cpp:59: undefined reference to `SHA1_Init'

../shared/Auth/libmangosauth.a(Sha1.o): In function `~Sha1Hash':

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/Sha1.cpp:29: undefined reference to `SHA1_Init'

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/Sha1.cpp:29: undefined reference to `SHA1_Init'

../shared/Auth/libmangosauth.a(Sha1.o): In function `Sha1Hash':

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/Sha1.cpp:24: undefined reference to `SHA1_Init'

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/Sha1.cpp:24: undefined reference to `SHA1_Init'

../shared/Auth/libmangosauth.a(Sha1.o): In function `Sha1Hash::UpdateData(unsigned char const*, int

/home/alex/Desktop/mangos/objdir/src/shared/Auth/../../../../src/shared/Auth/Sha1.cpp:34: undefined reference to `SHA1_Update'

collect2: ld returned 1 exit status

I also have pkg-config installed and still geting the same error!!!!

Ubuntu 8.10 32bit

Also have this problem!!!

I started to think you forgot about it :D:D

Good job!!! Compiling right now.

Well i like the idea very much but i still cant figure out some things

Where do patch testers put their reports in this case where we have several patches testig at once?

How much will this help patches to get commited?

And how will you select patches for adding to your repo?

Dont get me wrong im just curios how will this work. Im trying to help testing but i dont have server whit enough testers

Try to use more or die (mysql_error()); and you will find your problem!! I did some fixes to your code. Tested and working

<?php
$db_user    = "root"; // MySQL username
$db_pass    = "protroad975"; // MySQL password
$db_host    = "localhost"; // MySQL Server Host
$db_db      = "realmd"; // Account database

if(isset($_POST['submit']))
{
$con = mysql_connect($db_host,$db_user,$db_pass) or die('Could not connect: ' . mysql_error());
mysql_select_db($db_db, $con);
$user = $_POST['login'];
$pass = $_POST['password'];
$email = $_POST['email'];
$pack = $_POST['expansion'];
function sha_password($user,$pass)
{
	$user = strtoupper($user);
	$pass = strtoupper($pass);
	return SHA1($user.':'.$pass);
}
$sha=sha_password($user,$pass);
if(!$user)
	echo "You have not inserted your username.";
else if(!$pass)
	echo "You have not inserted your password.";
else if(!$email)
	echo "You have not inserted your e-mail";
else
{
	$check = mysql_query("SELECT `username` FROM `account` WHERE `username`='".$user."' ", $con)  or die (mysql_error());
	if(mysql_numrows($check) > 0)
		echo "Account ".$user." already exists. Please Try Again";
	else
	{
		$query = "INSERT INTO `account`(`username`, `sha_pass_hash`, `email`, `expansion`) VALUES
('" . mysql_real_escape_string($user) . "', '" . mysql_real_escape_string($sha) . "', '" . mysql_real_escape_string($email) . "', '" . mysql_real_escape_string($pack) . "')";
		$do_query = mysql_query($query) or die (mysql_error());
		if(!mysql_query($do_query))
			echo "Account ".$user." has been created.";
		else
			echo "Creation of account ".$user." has failed. Please try again later.";
	}
}
@mysql_close($con);
}
?>

But you need to add more checks (for email, for username/password length, etc)

If you set this all players will see the announce

Battleground.QueueAnnouncer.Enable = 1

and if you set this only the player who enters the queue will see the announce

Battleground.QueueAnnouncer.PlayerOnly = 1

I think it cant be more simple then that :D

So even for a singlecore CPU we shoud do -j3 ??

Your setings for Autobroadcast?

Shoud be like this

AutoBroadcast.On = 1

AutoBroadcast.Center = 2

AutoBroadcast.Timer = 3600000