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

[Artistry]

Does anybody mind telling me how I may edit what the Teleporter NPC says?

[lorac]

Warning............Adding AC1 or 2 will break the core
Theres a reason it was not patched into the core
I am working on porting it to UC but this is going to take some time
Patching it ........Voids all Responsibility to try to fix your core
I can not nor will not take the time to try to figure out why your core is not working if you patch it with AC1 or 2
Take a look at all this core has in it .......Why in the world would I leave out security if it worked?
Ive covered this about 30 - 40 posts ago
Our hooks / defines are "not" exactly like trinity core
Thus the different feel
Im not saying dont try
Im just saying it wont work
And you will have to redo everything
And erm isnt Rev 7776 3.2.2?

I dont see how people are able to hack levels
through client to core
Im not saying its not possable
but if someone would explain to me how maybe i can put in extra measures to stop it core side
Not only that
Turn on your fake message kick options
this should limit it if its lua hacks

Levels IMO
This has to be a external sql insertion

Please give me information so I can try to come up with a counter measure

:: Lorac's lesson of the day ::

For those who dont know what that file is
a patch is a file that directly writes the code into the C++ files that make up the core before compiling

:: Confusia says he who tweeks core ends up with a tweeked client::

::Now in responce to teleporter npc::
Which one
theres like 4-5 of them in
icc helper
ulduar helper
telenpc
pryds tele

If your talking about the shopping center entry
No way to
unless you compile it your self
Its in the code not db
Now if its telenpc
Look in the database you will see where it is
or should

One is in npc text
and the other is in npc tele something
you cant miss it
thats where you edit the telenpcs ports

[13ack.Stab]

lorac, would you mind taking a look at my post on the top of page 77 whenever you have some free time? ^_^

Thanks.

[spacemus]

Warning............Adding AC1 or 2 will break the core
Theres a reason it was not patched into the core
I am working on porting it to UC but this is going to take some time
Patching it ........Voids all Responsibility to try to fix your core
I can not nor will not take the time to try to figure out why your core is not working if you patch it with AC1 or 2
Take a look at all this core has in it .......Why in the world would I leave out security if it worked?
Ive covered this about 30 - 40 posts ago
Our hooks / defines are "not" exactly like trinity core
Thus the different feel
Im not saying dont try
Im just saying it wont work
And you will have to redo everything
And erm isnt Rev 7776 3.2.2?

I dont see how people are able to hack levels
through client to core
Im not saying its not possable
but if someone would explain to me how maybe i can put in extra measures to stop it core side
Not only that
Turn on your fake message kick options
this should limit it if its lua hacks

Levels IMO
This has to be a external sql insertion

Please give me information so I can try to come up with a counter measure

:: Lorac's lesson of the day ::

For those who dont know what that file is
a patch is a file that directly writes the code into the C++ files that make up the core before compiling

:: Confusia says he who tweeks core ends up with a tweeked client::

::Now in responce to teleporter npc::
Which one
theres like 4-5 of them in
icc helper
ulduar helper
telenpc
pryds tele

If your talking about the shopping center entry
No way to
unless you compile it your self
Its in the code not db
Now if its telenpc
Look in the database you will see where it is
or should

One is in npc text
and the other is in npc tele something
you cant miss it
thats where you edit the telenpcs ports

thx for this post mate i wont patch it i didnt do it yet waited first till u might answer to it

external .sql inject maybe does evryone got his db proteckted good? so ppl need a bind ip to enter? make sure u got a bind ip enter only

[shamanwise]

Warning............Adding AC1 or 2 will break the core
Theres a reason it was not patched into the core
I am working on porting it to UC but this is going to take some time
Patching it ........Voids all Responsibility to try to fix your core
I can not nor will not take the time to try to figure out why your core is not working if you patch it with AC1 or 2
Take a look at all this core has in it .......Why in the world would I leave out security if it worked?
Ive covered this about 30 - 40 posts ago
Our hooks / defines are "not" exactly like trinity core
Thus the different feel
Im not saying dont try
Im just saying it wont work
And you will have to redo everything
And erm isnt Rev 7776 3.2.2?

I dont see how people are able to hack levels
through client to core
Im not saying its not possable
but if someone would explain to me how maybe i can put in extra measures to stop it core side
Not only that
Turn on your fake message kick options
this should limit it if its lua hacks

Levels IMO
This has to be a external sql insertion

Please give me information so I can try to come up with a counter measure

:: Lorac's lesson of the day ::

For those who dont know what that file is
a patch is a file that directly writes the code into the C++ files that make up the core before compiling

:: Confusia says he who tweeks core ends up with a tweeked client::

::Now in responce to teleporter npc::
Which one
theres like 4-5 of them in
icc helper
ulduar helper
telenpc
pryds tele

If your talking about the shopping center entry
No way to
unless you compile it your self
Its in the code not db
Now if its telenpc
Look in the database you will see where it is
or should

One is in npc text
and the other is in npc tele something
you cant miss it
thats where you edit the telenpcs ports

Thank you!

For the levelup hacking players may use bots?
Yesterday, one player take a 80 lvl for the few hours (rate.kill=5 and rate.quest=5)

P.S.

How i may to return item id 52200 (Reins of the Crimson Deathcharger) to DB, in previos version of the repack, this item is present (i'm no sure about this).

[InvaderGir]

Can anyone help me with downloading? I hate sourforge.Which file should i download? UltracoreV2.exe? Or what?

[lorac]

Hey, guys. I've been using this for a few days now, and have remained shellshocked by the server's incredible stability and functionality.

You guys rock.

However, I have five questions:

1) How may I enable non-GMs to friendslist my GM characters?

2) I am not entirely sure as to how I may update my Trinity core to the latest version. This is what I think I need to do:

a) Back up my character database.
b) Make all-new databases.
c) Import my character database, as well as the new World and Realmd databases.
d) Use any character SQL updates that have numbers above my old version's number (i.e. if I were running character database 7000 before, and was updating to 7050, I would use all SQLs with numbers above 7000).
e) Do I need new dbcs/maps/vmaps? World of Warcraft has not been patched recently (still 3.3.3a). Does this matter?
f) Reconfigure files to use the new databases.
g) The final step in your walkthrough says to update the realmd database AFTER everything else.

Do I have this all correct?

3) In the 'Extras' folder in the Trinity directory, there are various things such as 'Wintergrasp,' 'TeleNPC2,' 'Bots,' and so on. The server I'm running is the Blizzlike PvE server, but it seems to already have Bots and the TeleNPC functioning. Are these .SQL files already included with the Trinity databases, or should I execute these as well?

4) I have not yet made my server open to the public. However, I have had some friends play through LAN. For whatever reason, the PvP functions (2v2 Skirmish Arena, etc.) do not seem to be functioning. Do I simply need to have more two or three people for these functions to work properly?

5) Each time I launch my server or kill a monster, I receive an error message in my TrinityCore console window, claiming that table '.\trinity\creature_respawn' is marked as crashed and should be repaired. Despite this error message, monsters seem to be respawning. Might you know what this means?

Thank you for your time!

Gms in friends
Make sure you keep the gm settings default in the inlist settings
and make sure you have 1 in friends

Ok Updating core........
If your using uc v2 .exe
you will need to dump to sql your character db ( when using the "not made yet" uc v3

If you just going to manually update

1. Grab the compiled files

2. Unzip the files

3. Place Core files into your server directory

4. Backup all your dbs

5. Batch all updates
Do not use the character.sql!!!!!!!!!
it will wipe your character db
use the char_#.sqls

Then batch the new world db
And your done

Extras
They should be included in db if i am not mistaken

(error)
Go into your world db
Highlight all tables
Then right click and select manage tables and repair
it will take a moment
this happens when your mysql goes away while server is running
or you suffer a blue screen or something odd

Can anyone help me with downloading? I hate sourforge.Which file should i download? UltracoreV2.exe? Or what?

If you want a pre set up server yes grab ucV2.exe

Thank you!

For the levelup hacking players may use bots?
Yesterday, one player take a 80 lvl for the few hours (rate.kill=5 and rate.quest=5)

P.S.

How i may to return item id 52200 (Reins of the Crimson Deathcharger) to DB, in previos version of the repack, this item is present (i'm no sure about this).

thx for this post mate i wont patch it i didnt do it yet waited first till u might answer to it

external .sql inject maybe does evryone got his db proteckted good? so ppl need a bind ip to enter? make sure u got a bind ip enter only

=5 means your going to get 5 X blizz exp
If using the pre built server the uc v2
I would suggest you go into your db with navicat
and change your connection password to root
using manage users
as for 52200 i dont know how to answer this

[Darkev0]

always i patch my Tdb to the newest rev 8074 i get a error and cant patch

here the error i use navicat

[Err] 1307 - Failed to CREATE PROCEDURE sp_delete_loot
[Err] CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_delete_loot`(IN loot_type VARCHAR(10),IN loot_entry INT(10),IN item_entry INT(10))
BEGIN
/*
 * DEGREE: BASIC
 * TABLES AFFECTED: *_loot_template
 * PROCS USED:  none
 *
 * loot_type - Type of loot to delete
 *           - The only acceptable values are 'FISH','NPC','GO','ITEM','DISENCH','PROSPECT','MILL','PICKPOCKET','SKIN','QUEST', or 'REF'
 * loot_entry - NULLABLE. If present, use entry as a qualifier in the specified table (if null, only use item)
 * item_entry - NULLABLE. If present, use item as a qualifier in the specified table (if null, only use entry)
 *
 * CALL `sp_delete_loot`('GO',20000,NULL); -- deletes all loot of gobj whose type=3 (chest) and data1 is 20000
 * CALL `sp_delete_loot`('PROSPECT',NULL,10000); -- deletes all loot of item_template entry 10000 from prospecting loot
 * CALL `sp_delete_loot`('NPC',20000,10000); -- deletes a loot of an npc whose lootid=20000 and drops item 10000 directly from 
 */
	IF loot_entry IS NOT NULL OR item_entry IS NOT NULL THEN
		CASE UCASE(loot_type)
			WHEN 'FISH' THEN BEGIN
				DELETE FROM `fishing_loot_template` WHERE `entry`=IFNULL(loot_entry,`entry`) AND `item`=IFNULL(item_entry,`item`);
			END;
			WHEN 'NPC' THEN BEGIN
				DELETE FROM `creature_loot_template` WHERE `entry`=IFNULL(loot_entry,`entry`) AND `item`=IFNULL(item_entry,`item`);
			END;
			WHEN 'GO' THEN BEGIN
				DELETE FROM `gameobject_loot_template` WHERE `entry`=IFNUofcLL(loot_entry,`entry`) AND `item`=IFNULL(item_entry,`item`);
			END;
			WHEN 'ITEM' THEN BEGIN
				DELETE FROM `item_loot_template` WHERE `entry`=IFNULL(loot_entry,`entry`) AND `item`=IFNULL(item_entry,`item`);
			END;
			WHEN 'DISENCH' THEN BEGIN
				DELETE FROM `disenchant_loot_template` WHERE `entry`=IFNULL(loot_entry,`entry`) AND `item`=IFNULL(item_entry,`item`);
			END;
			WHEN 'PROSPECT' THEN BEGIN
				DELETE FROM `propspecting_loot_template` WHERE `entry`=IFNULL(loot_entry,`entry`) AND `item`=IFNULL(item_entry,`item`);
			END;
			WHEN 'MILL' THEN BEGIN
				DELETE FROM `millling_loot_template` WHERE `entry`=IFNULL(loot_entry,`entry`) AND `item`=IFNULL(item_entry,`item`);
			END;
			WHEN 'PICKPOCKET' THEN BEGIN
				DELETE FROM `pickpocketing_loot_template` WHERE `entry`=IFNULL(loot_entry,`entry`) AND `item`=IFNULL(item_entry,`item`);
			END;
			WHEN 'SKIN' THEN BEGIN
				DELETE FROM `skinning_loot_template` WHERE `entry`=IFNULL(loot_entry,`entry`) AND `item`=IFNULL(item_entry,`item`);
			END;
			WHEN 'QUEST' THEN BEGIN
				DELETE FROM `quest_loot_template` WHERE `entry`=IFNULL(loot_entry,`entry`) AND `item`=IFNULL(item_entry,`item`);
			END;
			WHEN 'REF' THEN BEGIN
				IF loot_entry IS NOT NULL THEN
					DELETE FROM `creature_loot_template` WHERE `mincountOrRef`=-loot_entry;
					DELETE FROM `disenchant_loot_template` WHERE `mincountOrRef`=-loot_entry;
					DELETE FROM `fishing_loot_template` WHERE `mincountOrRef`=-loot_entry;
					DELETE FROM `gameobject_loot_template` WHERE `mincountOrRef`=-loot_entry;
					DELETE FROM `item_loot_template` WHERE `mincountOrRef`=-loot_entry;
					DELETE FROM `mail_loot_template` WHERE `mincountOrRef`=-loot_entry;
					DELETE FROM `milling_loot_template` WHERE `mincountOrRef`=-loot_entry;
					DELETE FROM `pickpocketing_loot_template` WHERE `mincountOrRef`=-loot_entry;
					DELETE FROM `prospecting_loot_template` WHERE `mincountOrRef`=-loot_entry;
					DELETE FROM `skinning_loot_template` WHERE `mincountOrRef`=-loot_entry;
					DELETE FROM `spell_loot_template` WHERE `mincountOrRef`=-loot_entry;
				END IF;
				
				DELETE FROM `reference_loot_template` WHERE `entry`=IFNULL(loot_entry,`entry`) AND `item`=IFNULL(item_entry,`item`);
			END;
			ELSE CALL INVALID_LOOT_TYPE;
		END CASE;
	ELSE 
		CALL MUST_PROVIDE_ENTRY_OR_ITEM;
	END IF;
END;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[spacemus]

hey any change i can patch in tinichat2 in this core with out breaking it ? becose AC1 and ac2 break it i wonder about tinichat2 :P i try it on a clean instal and let you know if it work if u didnt try it yet

[lorac]

hey any change i can patch in tinichat2 in this core with out breaking it ? becose AC1 and ac2 break it i wonder about tinichat2 :P i try it on a clean instal and let you know if it work if u didnt try it yet

I can tell you no it wont work
Or we would have used the all in one patch
Besides you are saying you are being hacked
Why would you add this exploitable option

We have tried to add it previously and it causes crashes and instibility and lag spikes so no it is not compatible

Darkev0
As for your batch fail
Try using sqlyog that may resolve the issue
If all else fails update Navicat to the newest free version

[13ack.Stab]

Where may I find the updates to execute on my databases?

I downloaded Win32_Release_8074, replaced my core files with those, backed up my databases, fixed my config files. I don't need to execute any of the .SQL files in the updates folder, right? None of the filenames have changed since the 8070 release.

I also downloaded TDB_8074_All. Inside of that folder was one called TDB_8070_All. The path looks like this: C:\Documents and Settings\USER\My Documents\Downloads\TDB_8074_All\TDB_8070_All

Is that okay?

If so, do I run the realmd.sql file on the realmd database, the TDB_rev29_Bliz.sql on my Trinity database, and... that's it? Nothing for the character database? I'm updating from 8070 to 8074. Again, none of the filenames have changed, so I'm a little confused.

Also, I have not yet made my server open to the public. However, I have had some friends play through LAN. For whatever reason, the PvP functions (2v2 Skirmish Arena, etc.) do not seem to be functioning. Do I simply need to have more two or three people for these functions to work properly?

[lorac]

Where may I find the updates to execute on my databases?

I downloaded Win32_Release_8074, replaced my core files with those, backed up my databases, fixed my config files. I don't need to execute any of the .SQL files in the updates folder, right? None of the filenames have changed since the 8070 release.

I also downloaded TDB_8074_All. Inside of that folder was one called TDB_8070_All. The path looks like this: C:\Documents and Settings\USER\My Documents\Downloads\TDB_8074_All\TDB_8070_All

Is that okay?

If so, do I run the realmd.sql file on the realmd database, the TDB_rev29_Bliz.sql on my Trinity database, and... that's it? Nothing for the character database? I'm updating from 8070 to 8074. Again, none of the filenames have changed, so I'm a little confused.

Also, I have not yet made my server open to the public. However, I have had some friends play through LAN. For whatever reason, the PvP functions (2v2 Skirmish Arena, etc.) do not seem to be functioning. Do I simply need to have more two or three people for these functions to work properly?

1. Batch the new world db
2. move the new core files into your server
No if memory serves me no changes to char db
However theres changes ......a lot of changes to all areas on the next core update
File names will remain the same even though its a new core
Most sql updates will have revision numbers in it

As for BG arenas
you need to make sure you have enough players to activate the Que
2v2 so forth
how ever you can access with the
debug bg
debug arena
commands
But wont function as it should due to the lack of players
2v2 you need to buy the arena team from arena vendor
and you need 2 of each faction in each team

[Darkev0]

I can tell you no it wont work
Or we would have used the all in one patch
Besides you are saying you are being hacked
Why would you add this exploitable option

We have tried to add it previously and it causes crashes and instibility and lag spikes so no it is not compatible

Darkev0
As for your batch fail
Try using sqlyog that may resolve the issue
If all else fails update Navicat to the newest free version

nope downloaded sqlyog but same error i dont know what to do know bugged

[spacemus]

I can tell you no it wont work
Or we would have used the all in one patch
Besides you are saying you are being hacked
Why would you add this exploitable option

We have tried to add it previously and it causes crashes and instibility and lag spikes so no it is not compatible

Darkev0
As for your batch fail
Try using sqlyog that may resolve the issue
If all else fails update Navicat to the newest free version

i never said i got hacked that was someone els and i got the chat working on 1 core atm and it runs fine but thx for the info

[Artistry]

Basically what I was asking is how on the Pryds TeleNPC [the human in the straw-hat] I'd like to change "Silvermoon" to "Horde Mall" and "Darnassus" to "Ally Mall" I've been trying to figure it out for like a week now.. could you give like, instructions o.o