-=/PryDevServer-4TC:\=- Trinity Core!

[lucas13]

@furinex
that part confused me too but it seems that pryd didnt intend to change the name of the new TDB blizz. so its name is still TDB blizz 8070 but if you download the one in the repo you will see clearly difference in the size of the old one and this new trinityworld .sql file

EDIT:
it seems i was wrong, appearantly pryd or lorac uploaded a 8074 tdb blizz this evening

---------- Post added at 08:55 PM ---------- Previous post was at 08:35 PM ----------

Pryd or lorac i know you are working hard and i appreciate that!
even tho, i want to ask if you mind running the new TDB 8074 on a fresh DB table because, at least for me, the last 123 queries fails for me. and it has been like that since i started with your servers, i wonder if it is something important, ofc i dont hope so and i havent felt anything "wrong" yet but if you dont mind, please take a look at it

[secretdragon008]

Nice nice, i will set that up now.
The bot system is so awesome, the only downside with it that i have noticed.
Is if you have extra movement speed from talents or other spells, i kinda easily run away from it.
But i guess i can improve their movement speed in conf file.
I didn't read all in the conf. yesterday, just kinda swiped fast over it, but i mean i saw something about bots there.

[tinblue]

When Blizzard updated to 3.3 they made the Defias in Northshire Abbey non-agro for low level characters. Also, they added Diseased Wolves. Although your core has the diseased wolves (for some reason) you do not have the yellow diseased animation effect emanating from them. Also the Kobold Workers do not have glowing weapons when they should!

In addition your database/core? (Not sure which it is that's responsible for these kinds of inaccuracies) has the Defias icorrectly giving aggro to low level characters.

I have tried nearly all the other repacks and all of them adhere to the new 3.3 changes in this area except yours so I am confused why your's is out of date compared to others? Its nice you are focusing on custom mounts and working vehicles but some of us do like the more blizzlike experience of the early areas with level 1 characters!

And while I'm knit-picking there is an out of place festival tent in Goldshire for some reason! :-p

But on a positive note thanks for moving Deputy Willem in the last update to his correct position nearer the Abbey ;-)

[lorac]

Lucus13
I will be looking into it
I dont know why your throwing sql errors
I batched the sql with no errors as of yesterday morning
Again I will look into this to see what may be causing it
Remember Pryd uses Navicat for the sql dumps and thus the optimum tool is Navicat for the sql insertions


@secretdragon008
Make sure your speed is at 1 in your configs 1 - 1x retail

@ tinblue
A lot of the Data is still 3.2.2 due to the fact that it is based on TDB and Tdb doesnt change the data unless they have sniffs from retail
we have been 3.3.3 4 weeks at max
Retail changed a lot as far as the handling of start areas from 3.3.2 to 3.3.3 and we need to address it
you are correct theres a lot that is outdated
I personally focus on the Retail aspect
Pryd works on the custom and Nice Extras

As soon as i can get sqls just for the custom spawns in ICC ,ToC, Wg,ToCr Game objects and Creature_template will be doing a wipe on my side and working on start zone spawns and npcs and working
my way down the line
However this wont be an overnight fix

[eimoxs]

Lorac, can you link me a website for the 3.3.3a core or atleast a register page that would be so cool and by the way awesome repack

[secretdragon008]

Solved the bot speed problem.
Just modified each bot speed in navicat.

[spitfire21]

Hey lorac is 8074 source in tccustom so I can compile?
Oh and secretdragon they also teleport to you if you get to far.

[lucas13]

thanks lorac and i am also using the newest version of navicat so that shouldnt be the problem

[tinblue]

@ tinblue
A lot of the Data is still 3.2.2 due to the fact that it is based on TDB and Tdb doesnt change the data unless they have sniffs from retail
we have been 3.3.3 4 weeks at max
Retail changed a lot as far as the handling of start areas from 3.3.2 to 3.3.3 and we need to address it
you are correct theres a lot that is outdated
I personally focus on the Retail aspect
Pryd works on the custom and Nice Extras

As soon as i can get sqls just for the custom spawns in ICC ,ToC, Wg,ToCr Game objects and Creature_template will be doing a wipe on my side and working on start zone spawns and npcs and working
my way down the line
However this wont be an overnight fix

Thats really good to hear. I was getting a bit worried the priority of this repack was all fun stuff. Looking forward to the improvements you will bring lorac! Its appreciated.

[secretdragon008]

Oh and secretdragon they also teleport to you if you get to far.

Hehe ye i know, but i also know a weird bug that can happen then.
Sometimes if i run to far, the bot suddenly die, and when i return to him, he ress.

Um do the bots only give buffs/spells to GM's?
Since when i was on the GM account, he buffed and healed me all the time.
But when i was on a normal account, he didn't want to give me buffs, and even when i had the shaman bot i died in combat,
since he refused to heal me, and yes he was not OoM

[pryd]

Great news!

Lorac and I have found some new ICC scripts, thanks goes out to the developers for the share and they are simply amazing compared to what we had.

I have fixed the script_texts for Deathwhisper, Morrowgar, and the final King fight w/ Tirion and Father.. I still need to check / fix / create texts for Festergut, Prof Putricide and possibly a few others.

ICC Teleporter is working, kill the king and you get a special video surprise!

Also on a side note, I'm using a version of Navicat that happens to work extremely well with my server setup, Navicat Lite 8.1.16 for mysql. I tried the latest Navicat premium... it was much slower restoring / exporting .. albeit it had more features..

[secretdragon008]

Nice, I use Navicat 8 to, its flows really great.

[darkartur]

hey all its normal that most of the monsters in northend are frindly or have wrong faction idand the save 4 pit of sharon hals of refection and other its normal or its only my issue??

and if any one need a website here :

<?php

// Configuration.
//---------------
// Realm database.
$r_db = "realmd";
// IP (and port).
$ip = "127.0.0.1:3306";
// Username.
$user = "root";
// Password.
$pass = "ascent";
// Site title.
$title = "";
$title2 = "Trinity";
// End config.

$page = '<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<style type="text/css">
<!--
body {background:url(http://www.wallpaperez.net/wallpaper/games/Worgen-Cataclysm-1959.jpg) no-repeat center center fixed; }
//-->
</style>
 <img src="bilder/trinity.jpg" width=300 height=130 align="bottom" hspace=50 vspace=0>  
</head>
<title>' . $title . '</title>
</head>
 <body style="background-color:black;color:lime;font-family:verdana;">
<form method="post" action="' . $_SERVER["SCRIPT_NAME"] . '">
<p style="text-align:center;">
<strong>' . $title2 . '  ' . $title . '</strong>
<br /> Patch 3.3.3a <br>
<br /><br /><br />
Log-in Name:
<br /><input name="username" type="text" maxlength="14" /><br />
Password:
<br /><input name="password" type="password" maxlength="12" /><br />
Email:
<br /><input name="email" type="text" maxlength="30" />
<br /><input name="wotlk" type="checkbox" checked="checked" />wotlk <br /><br /><br />
<button type="submit">Erstellen</button>
</p>
</form>
</body>
</html>';

function error_s ($text) 
{
    echo("<p style=\"background-color:black;color:yellow;font-family:verdana;\">" . $text);
    echo("<br /><br /><a style=\"color:orange;\" href=\"" . $_SERVER["SCRIPT_NAME"] . "\">Go back...</a></p>");
};

$user_chars = "#[^a-zA-Z0-9_\-]#";
$email_chars = "/^[^0-9][A-z0-9_]+([.][A-z0-9_]+)*[@][A-z0-9_]+([.][A-z0-9_]+)*[.][A-z]{2,4}$/";

$con = @mysql_connect($ip, $user, $pass);
if (!$con) {
    error_s("Unable to connect to database: " . mysql_error());
};

if (!empty($_POST)) {
        if ((empty($_POST["username"]))||(empty($_POST["password"]))||(empty($_POST["email"]))||(empty($_POST["wotlk"])) ) {
                error_s("You did not enter all the required information.");
                exit();
        } else {
                $username = strtoupper($_POST["username"]);
                $password = strtoupper($_POST["password"]);
                $email = strtoupper($_POST["email"]);
                if (strlen($username) < 5) {
                        error_s("Username too short.");
                        exit();
               };
                if (strlen($username) > 14) {
                        error_s("Username too long.");
                        exit();
                };
                if (strlen($password) < 5) {
                        error_s("Password too short.");
                        exit();
                };
                if (strlen($password) > 12) {
                        error_s("Password too long.");
                        exit();
                };
                if (strlen($email) < 4) {
                        error_s("Email was too short.");
                        exit();
                };
                if (strlen($email) > 30) {
                        error_s("Email was too long.");
                        exit();
                };
                if (preg_match($user_chars,$username)) {
                        error_s("Username contained illegal characters.");
                        exit();
                };
                if (preg_match($user_chars,$password)) {
                        error_s("Password contained illegal characters.");
                        exit();
                };
                if (!preg_match($email_chars,$email)) {
                        error_s("Email was in an incorrect format.");
                        exit();
                };
                if ($_POST['wotlk'] != "on") {
                        $wotlk = "0";
                } else {
                        $wotlk = "2";
                };
                $username = mysql_real_escape_string($username);
                $password = mysql_real_escape_string($password);
                $email = mysql_real_escape_string($email);
                $qry = @mysql_query("select username from " . mysql_real_escape_string($r_db) . ".account where username = '" . $username . "'", $con);
                if (!$qry) {
                    error_s("Error querying database: " . mysql_error());
                };
                if ($existing_username = mysql_fetch_assoc($qry)) {
                        foreach ($existing_username as $key => $value) {
                                $existing_username = $value;
                        };
                };
                $existing_username = strtoupper($existing_username);
                if ($existing_username == strtoupper($_POST['username'])) {
                        error_s("That username is already taken.");
                        exit();
                };
                unset($qry);
                $qry = @mysql_query("select email from " . mysql_real_escape_string($r_db) . ".account where email = '" . $email . "'", $con);
                if (!$qry) {
                    error_s("Error querying database: " . mysql_error());
                };
                if ($existing_email = mysql_fetch_assoc($qry)) {
                        foreach ($existing_email as $key => $value) {
                                $existing_email = $value;
                        };
                };
                if ($existing_email == $_POST['email']) {
                        error_s("That email is already in use.");
                        exit();
                };
                unset($qry);
                $sha_pass_hash = sha1(strtoupper($username) . ":" . strtoupper($password));
                $register_sql = "insert into " . mysql_real_escape_string($r_db) . ".account (username, sha_pass_hash, email, expansion) values (upper('" . $username . "'),'" . $sha_pass_hash . "','" . $email . "','" . $wotlk . "')";
                $qry = @mysql_query($register_sql, $con);
                if (!$qry) {
                    error_s("Error creating account: " . mysql_error());
                };
                echo("Ihr Account wurde erstellt/Account created.");
                exit();
        };
} else {
        echo($page);
};

?>

[Darkev0]

is the link Download PryDevServer: Private Emulation WOTLK from SourceForge.net to download the instaler always updatet with the newest upadtes or i need to selfupdate this?

[eimoxs]

I get error with your site

Log-in Name:

Password:

Email:

wotlk


Erstellen
'; function error_s ($text) { echo("

" . $text); echo("

Go back...
"); }; $user_chars = "#[^a-zA-Z0-9_\-]#"; $email_chars = "/^[^0-9][A-z0-9_]+([.][A-z0-9_]+)*[@][A-z0-9_]+([.][A-z0-9_]+)*[.][A-z]{2,4}$/"; $con = @mysql_connect($ip, $user, $pass); if (!$con) { error_s("Unable to connect to database: " . mysql_error()); }; if (!empty($_POST)) { if ((empty($_POST["username"]))||(empty($_POST["password"]))||(empty($_POST["email"]))||(empty($_POST["wotlk"])) ) { error_s("You did not enter all the required information."); exit(); } else { $username = strtoupper($_POST["username"]); $password = strtoupper($_POST["password"]); $email = strtoupper($_POST["email"]); if (strlen($username) < 5) { error_s("Username too short."); exit(); }; if (strlen($username) > 14) { error_s("Username too long."); exit(); }; if (strlen($password) < 5) { error_s("Password too short."); exit(); }; if (strlen($password) > 12) { error_s("Password too long."); exit(); }; if (strlen($email) < 4) { error_s("Email was too short."); exit(); }; if (strlen($email) > 30) { error_s("Email was too long."); exit(); }; if (preg_match($user_chars,$username)) { error_s("Username contained illegal characters."); exit(); }; if (preg_match($user_chars,$password)) { error_s("Password contained illegal characters."); exit(); }; if (!preg_match($email_chars,$email)) { error_s("Email was in an incorrect format."); exit(); }; if ($_POST['wotlk'] != "on") { $wotlk = "0"; } else { $wotlk = "2"; }; $username = mysql_real_escape_string($username); $password = mysql_real_escape_string($password); $email = mysql_real_escape_string($email); $qry = @mysql_query("select username from " . mysql_real_escape_string($r_db) . ".account where username = '" . $username . "'", $con); if (!$qry) { error_s("Error querying database: " . mysql_error()); }; if ($existing_username = mysql_fetch_assoc($qry)) { foreach ($existing_username as $key => $value) { $existing_username = $value; }; }; $existing_username = strtoupper($existing_username); if ($existing_username == strtoupper($_POST['username'])) { error_s("That username is already taken."); exit(); }; unset($qry); $qry = @mysql_query("select email from " . mysql_real_escape_string($r_db) . ".account where email = '" . $email . "'", $con); if (!$qry) { error_s("Error querying database: " . mysql_error()); }; if ($existing_email = mysql_fetch_assoc($qry)) { foreach ($existing_email as $key => $value) { $existing_email = $value; }; }; if ($existing_email == $_POST['email']) { error_s("That email is already in use."); exit(); }; unset($qry); $sha_pass_hash = sha1(strtoupper($username) . ":" . strtoupper($password)); $register_sql = "insert into " . mysql_real_escape_string($r_db) . ".account (username, sha_pass_hash, email, expansion) values (upper('" . $username . "'),'" . $sha_pass_hash . "','" . $email . "','" . $wotlk . "')"; $qry = @mysql_query($register_sql, $con); if (!$qry) { error_s("Error creating account: " . mysql_error()); }; echo("Ihr Account wurde erstellt/Account created."); exit(); }; } else { echo($page); }; ?>

---------- Post added at 06:59 AM ---------- Previous post was at 06:40 AM ----------

Can someone give me a website for this core (3.3.3a)