adriann54

Upsiieee...my bad....I think I have forgotton to edit that in config files. My vamps where extracted and assembled =D I am sorry.

I tried to disable PvP in Dalaran ( which I think is a Sanctuary Area ), but I couldn't manage to disable it. Original Player.cpp: if(zone->flags & AREA_FLAG_SANCTUARY) // in sanctuary { SetByteFlag(UNIT_FIELD_BYTES_2, 1, UNIT_BYTE2_FLAG_SANCTUARY); if(sWorld.IsFFAPvPRealm()) SetFFAPvP(false); } Edited Player.cpp if(zone->flags & AREA_FLAG_SANCTUARY) // in sanctuary { SetByteFlag(UNIT_FIELD_BYTES_2, 1, UNIT_BYTE2_FLAG_SANCTUARY); if(sWorld.IsFFAPvPRealm()) SetFFAPvP(false); pvpInfo.endTimer = time(0); } I also added : UpdatePvP(false);

Maybe It will be implemented in MaNGOS a system for email login. I found this on Blizzard Forums : set realmlistbn "eu.logon.battle.net" -- It's using 3724 port and 1119

Have you encrypted again your email.password with SHA1 ?

Thank you for your response. I tried your script on my server and all services were online even if there were for real offline. Then I tried this script on a free webhosting service and I put my ip. The Result : mangosd - Operation Timed Out (Turned Off) realmd - Accepting Connections RA Console - Operation Timed Out SOAP - Operation Timed Out Apache - Accepting Connections MySQL - Operation Timed Out (No Remote Access) So I guess, is my server fold. I will reinstall it.

Thanks for your friendly reply. Even if didn't help me I figured out by myself where I can find them

Ok, thank you...I'll try to learn these syntaxes Edit: Where Can I find all of those syntaxes ?

I started to learn C++ and I know a little bit. Is there any kind of tutorial on how to code this thing? For Example : if (!caster || caster->GetTypeId() != TYPEID_PLAYER) return; What of these things are doing? ( if isn't any caster or caster is not a player then return ? )

Still the same, no errors. I guess my server is messed up.TE]

There's no error. The script just keep sayin that the server is always online, no matter what port I am using or if the server is online or offline. <?php if(($fp = fsockopen("my_ip","8085", $enumber, $evalue, 1)) !== FALSE){ echo "Online"; fclose($fp); }else{ echo "Offline"; } echo " Enumber:".$enumber." Evalue:".$evalue; ?> Output Online Enumber:0 Evalue:

Ok, I tried other ports and it's the same. Do you think is a apache-php problem ?

Still tells me that the server is online. So I tried this port : 3921038210931. And it says "Online".

I'm trying to make this script work but it always keeps saying that the server is online even if it's not. :-| Can someone give me a little help ?

I think he did because there are 4 tables before auction table

I would recommend you to reinstall your characters database. But however if you don't want to lose all of your data apply this query to your characters database : DROP TABLE IF EXISTS `auction`; CREATE TABLE `auction` ( `id` int(11) unsigned NOT NULL DEFAULT '0', `houseid` int(11) unsigned NOT NULL DEFAULT '0', `itemguid` int(11) unsigned NOT NULL DEFAULT '0', `item_template` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier', `itemowner` int(11) unsigned NOT NULL DEFAULT '0', `buyoutprice` int(11) NOT NULL DEFAULT '0', `time` bigint(40) NOT NULL DEFAULT '0', `buyguid` int(11) unsigned NOT NULL DEFAULT '0', `lastbid` int(11) NOT NULL DEFAULT '0', `startbid` int(11) NOT NULL DEFAULT '0', `deposit` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `item_guid` (`itemguid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Wait...you're the one who's hosting the server ? If yes check out if you have these ports forwarded : 8129,8085,3724. If not, then port-forward them.

I patched again my ScriptDev2, now is working. Thank you for your time

Yes I also patched the scriptdev2. And added your sql to my world db. I can take eye of archeus but it cannot fly. I keep falling with it.

Sorry ...just keep that in mind... if you have some problems with the installation check the guide and see if you missed something,

It didn't work for me... Installed patches, compiled, and run the sql to world db but still not working.

Next time read the entire guide. In your language: Data vitoare citeste tot ghidul

Thanks A Lot !

Hello... I didn't know where it will be the right place where I can start this thread so I started it here "Developer's Corner". I tried to make an registration page for mangos and it ended up with an error, now I'm blocked and I don't know where is the problem. <?php $db_user = "root"; // MySQL username $db_pass = "my_password"; // MySQL password $db_host = "localhost"; // MySQL Server Host $db_db = "mangos_logon"; // Account database if($_POST) { $con = mysql_connect($db_host,$db_user,$db_pass); if(!$con) $msg = "Unable to create a Database connection."; if($con) { 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."\\" LIMIT 1", $con); 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) . "');"; if(!mysql_query($query, $con)) echo "Creation of account ".$user." has failed. Please try again later."; else echo "Account ".$user." has been created."; } } @mysql_close($con); } } ?> It ends up with this error : Code Format echo "Creation of account ".$user." has failed. Please try again later."; Browser Format Creation of account test_user has failed. Please try again later.

How do I fix it ?

Hey...I got an error when I start MaNGOSD.exe 2009-07-19 23:30:32 Loading Loot Tables... 2009-07-19 23:30:32 2009-07-19 23:30:32 creature_loot_template : 2009-07-19 23:30:32 2009-07-19 23:30:32 >> Loaded 1 loot definitions (1 templates) 2009-07-19 23:30:32 ERROR:Table 'creature_loot_template' entry 80000 isn't creature entry and not referenced from loot, and then useless. It says that 80000 is not a creature entry but in creature_template I have this creature : insert into `creature_template` (`entry`, `heroic_entry`, `unk1`, `unk2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) values('80000','0','0','0','304','304','304','304','Chicken','',NULL,'3','5','500','500','100','100','100','7','7','0','8','1','0','100','200','0','10','1','2500','0','0','0','0','0','0','0','0','0','0','0','0','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','10000','10000','','0','3','1','1','0','0','0','0','0','0','1','0','0','0',''); While I am playing I can spawn this mob , but when I kill him it gives me only the money ( 1 gold ).