Recent Posts

71

General Discussion / Re: [Event] Count to a million from 100...

« Last post by Ls on April 14, 2022, 08:04:39 AM »

104

72

General Discussion / Re: [Event] Count to a million from 100...

« Last post by FengShui on April 13, 2022, 05:11:35 PM »

103

73

Info and Tutorials / WoW server uptime script PHP for TrinityCore

« Last post by FengShui on April 13, 2022, 02:18:38 AM »

WoW server uptime script in PHP using PDO for TrinityCore.

It's custom, simple and secure.

Code: [Select]

<?php
// WoW server uptime and max. players
$query_uptime_wotlk = "SELECT starttime, maxplayers FROM uptime WHERE realmid = &#39;1&#39; ORDER BY starttime DESC LIMIT 1"; 
$query_con_uptime_wotlk = $conn -> prepare($query_uptime_wotlk);
$query_con_uptime_wotlk->execute();
$res_uptime_wotlk = $query_con_uptime_wotlk->fetch(PDO::FETCH_ASSOC);

$uptimetime = time() - $res_uptime_wotlk[&#39;starttime&#39;];

function format_uptime($seconds) {
$secs  = intval($seconds % 60);
$mins  = intval($seconds / 60 % 60);
$hours = intval($seconds / 3600 % 24);
$days  = intval($seconds / 86400);

$uptimeString=&#39;&#39;;

if ($days) {
$uptimeString .= $days;
$uptimeString .= ((1 === $days) ? &#39; day&#39; : &#39; days&#39;);
}
if ($hours) {
$uptimeString .= ((0 < $days) ? &#39;, &#39; : &#39;&#39;).$hours;
$uptimeString .= ((1 === $hours) ? &#39; hour&#39; : &#39; hours&#39;);
}
if ($mins) {
$uptimeString .= ((0 < $days || 0 < $hours) ? &#39;, &#39; : &#39;&#39;).$mins;
$uptimeString .= ((1 === $mins) ? &#39; minute&#39; : &#39; minutes&#39;);
}
if ($secs) {
$uptimeString .= ((0 < $days || 0 < $hours || 0 < $mins) ? &#39;, &#39; : &#39;&#39;).$secs;
$uptimeString .= ((1 === $secs) ? &#39; second&#39; : &#39; seconds&#39;);
}
return $uptimeString;
}

$staticUptime = format_uptime($uptimetime);
unset($uptimetime);

echo "
<div>
<span style=\"font-size:0.8em;color:#B0BEC5;\">Uptime: ".$staticUptime."</span><br />
<span style=\"font-size:0.8em;color:#B0BEC5;\">Max. players: ".$res_uptime_wotlk[maxplayers]."</span>
</div>";

unset($staticUptime);
unset($query_con_uptime_wotlk);
?>


Info!
' is single quote (')
You can customize the echo "" results according to your needs.
PDO is inherently secure.


--

74

General Discussion / Re: [Event] Count to a million from 100...

« Last post by Ls on April 12, 2022, 08:43:41 AM »

102

75

Druid / Feral DPS Druid PvE Pre-Raid BiS WotLK Patch 3.3.5a

« Last post by FengShui on April 11, 2022, 03:34:23 AM »

Feral DPS Druid PvE Pre-Raid BiS WotLK Patch 3.3.5a

Weakness Spectralizers Engineering (440)

The Severed Noose of Westwind The Admiral Revealed

Spaulders of Frozen Knives Sons of Hodir Reputation (Honored)

Cloak of Holy Extermination Argent Crusade Reputation (Honored)

Darkheart Chestguard Ebon Blade Reputation (Exalted)

Seafoam Gauntlets Leatherworking

Leggings of Visceral Strikes Leatherworking

Dragonfriend Bracers Wyrmrest Reputation (Exalted)

Glitterscale Wrap Oracles Reputation (Revered)

Jormscale Footpads Leatherworking

Ring of Scarlet Shadows Jewelcrafting

Oracle Talisman of Ablution Oracles Reputation (Exalted)

Staff of Trickery Heroic Violet Hold (Cyanigosa)





--

76

General Discussion / [Event] Count to a million from 100...

« Last post by Nemsy on April 09, 2022, 10:14:32 AM »

Hi everyone. This is a forum event and everyone can participate in this funny event...
* Different rewards for users at random numbers !
No Double Posting!

101

77

Info and Tutorials / Tameable Rares added in 5.4

« Last post by Nemsy on April 08, 2022, 08:45:03 AM »

Tameable Rares added in 5.4

Patrannache - is a rare elite level 86 crane found in Valley of the Four Winds. He remains invisible until a hunter uses a [Flare] to unveil him.
ID: 50885

Great Turtle-Furyshell - a rare tameable turtle which can spawn in any location in the waters around the Timeless Isle.
ID: 73161

Gu'chi the Swarmbringer - is a silkworm located in Timeless Isle.
ID: 72909

Bloodtooth - is a dragon turtle located in the Krasarang Wilds. It is always swimming around the shores.
ID: 50854

Savage - is a large, fearsome white tiger who prowls the lush Jade Forest, From Nectarbreeze Orchard to Sri-La Village.
ID: 50850

Primal Stalker - is a level 35 Elite NPC that can be found in Timeless Isle. This NPC is the objective of Path of the Mistwalker.
ID: 72805

Elder Great Turtle - is a level 35 Elite NPC that can be found in Timeless Isle. This NPC is the objective of Path of the Mistwalker.
ID: 72765

Elder Great Turtle - is a level 35 Elite NPC that can be found in Timeless Isle. This NPC is the objective of Path of the Mistwalker.
ID: 72765

Bombyx - is one of the new rare beasts available for hunters to tame. He is a large purple silkworm and resides in the Krasarang Wilds.
ID: 67820




--

78

Info and Tutorials / World of Warcraft Shadowlands World Bosses

« Last post by Nemsy on March 31, 2022, 11:52:34 PM »

World of Warcraft Shadowlands World Bosses

Mortanis - appears in the land of Maldraxxus, in the area called the House of the Chosen.

Oranomonos the Everbranching -  in the land of Adrenweald just outside Tirna Scithe.

Valinor, the Light of Eons -  in the Land of Bastion, near the Temple of Loyalty.

Nurgash Muckformed -  in the north of Revendreth near Dominance Keep.

79

Info and Tutorials / Vale of Eternal Blossoms Rares

« Last post by Ls on March 31, 2022, 11:48:28 PM »

Vale of Eternal Blossoms Rares

Escaped Mutation

The Forgotten

Zror’um the Infinite

Kilxl the Gaping Maw

Voidtender Malketh

Deeplord Zrihj

Will of N’Zoth

Tisiphon




--

80

Info and Tutorials / Pets and mounts in Northrend

« Last post by Nemsy on March 30, 2022, 12:30:21 PM »

Pets and mounts in Northrend

EVENTS
The Ghostly Skull

Giant Sewer Rat

Pengu



CRAFTING
Tailoring - Flying Carpet

Tailoring - Magnificent Flying Carpet

Engineering - Mechano-hog (Horde)

Engineering - Mekgineer’s Chopper (Alliance)



REPUTATION
Reins of the Green Proto-Drake (REVERED with The Oracles - Cracked Egg, https://www.wowhead.com/item=39883/cracked-egg)

Wyrmrest Accord - Red Drake 2000G, requires Exalted reputation

Sons of Hodir - Reins of the Ice Mammoth available at Revered, 1,000G

Sons of Hodir - Reins of the Grand Ice Mammoth available at Exalted, 10,000G

Brunnhildar Village - White Polar Bear mount

Lake Wintergrasp - Black War Mammoth



ACHIEVEMENTS
Black War Bear: For The Horde / For The Alliance

Plagued Proto-Drake - Glory of the Raider (normal)

Violet Proto-Drake - from Achievement: What a Long, Strange Trip It's Been

DROP
Bronze Proto-Drake - guaranteed drop from the Infinite Corrupter in Heroic CoT-Strat

Time-Lost Proto-Drake - guaranteed drop from the rare spawn Time-Lost Proto-Drake in Storm Peaks.

Blue Proto-Drake - low drop rate from Skadi in Heroic Utgarde Pinnacle.

Black Drake - drops from Sartharion in 10man Obsidian Sanctum with three adds alive when he is killed.

Twilight Drake - drops from Sartharion in 25man Obsidian Sanctum with 3 adds alive when he is killed.

Blue Drake - 10man Eye of Eternity. Low drop rate from Alexstraza’s Gift, the box which spawns after Malygos’ defeat.

Azure Drake - 25man Eye of Eternity. Low drop rate from Alexstraza’s Gift, the box which spawns after Malygos’ defeat.



--