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

[redzik]

Im trying manual add v4db(not v5 waiting for other version like fun etc) by sqlyog or navicat but I have problem with mysql what is included in v3 ultracore, while add show me: "2006 - MySQL server has gone away" and "1153 - Got a packet bigger than 'max_allowed_packet' bytes" so Mysql does not have config file. Im trying install normal mysql and there modify more allow packet etc. and later copy all DB to folder with ultracore. Because I cant download auto install, in my house I dont have internet with good transfer
why I see russia language in db?? They translated all db?? How this in game look like?(Im watching match serbia-poland and still install mysql, so dont know yet)

SRY again for my english. I still learn. Im from Poland

If you dont know what is id for item etc. Maybe try atlas loot and you can use it. and second good soft is trinity admin.

[fosterboy123]

ok guys here is my issue now!

i had the whole server working, changed some simple values within the config of the realm (like xp rates etc) and now i get this when i launch trinitycore.exe

as you can see, the conf file is clearly in the correct folder. i didnt screw up the config just changed some numbers!



EDIT: Fixed, apparently MOTD cannot be very long ^^

[secretdragon008]

Followed your steps in the detailed guide, and it worked perfect, all my chars and stuff is intact.
Looks like everything works, good work.

But i have a weird quest problem, that i can't figure out.
When i try to make a own quest, the problem is:

I can accept the quest from the npc, but after i have taken the quest and completed it.
I can't deliver it back to the npc.

Does this mean its a own table for assigning completed quest to the npc's? as it is for the creature_questrelation table.
I tried to look for a table like that, but i can't find it anywhere.... I guess it don't exist then.

[lucas13]

there is something in the quest_template table it self. i think its like a special npc that you can assign start and end to, not sure tho

[pryd]

Hello All:

I have just released our Ultra Core 8386 FUN / PVP Database with all my custom vendors, items, malls, etc minus my custom mounts ( expect them in my next release on fun / pvp ) + any forum fixes, + fixes that aren't posted on the forums.

I will be uploading my Custom SQLs for those of you who have your own custom worlds.
Also for those that are creating items / npcs / quests / etc. Make sure that all your customs are in SQL form. We do not currently support world database sql updates ( fixes such as the way YTDB has ) maybe one day..which means when we update our world we send the full thing out.
This isn't a problem for people who make their customs into SQLs.

Anyhow, feel free to see how I have created my custom quest teleporters.
They work, may not be perfect, but can be used as an example possibly to help you
create your other custom quests.

Make sure to align these for quests: Creature_template entry goes with creature-involved-relation and creature-quest-relation tables. Now you match involved relation table ID's with quest_template and quest start / end scripts.

Looks something like this:

Creature entry 3001
involved relation / questrelation - 3001, 97001 ( one for each table )
Quest Template - 97001
Quest End / Start - 97001

So, this isn't exact but it will clue you in on how it's done. ( not that I make quests..)
Use my custom teleporters as a reference ( find the custom sqls / csv files for reference on my PryDevServer: Ultra Core | Get PryDevServer: Ultra Core at SourceForge.net repo or in the fun / pvp database.

I will upload my customs today for all to use / see or reverse.

Oh and lastly, don't be afraid to contribute your customs on our http://prydevserver.com/forum/
for all to use. Being this is a community repack I would appreciate any contributions as will everyone else.

Thanks! and Enjoy!

[giorqa]

pryd :wave:+Rep:wave:

[secretdragon008]

Thank you so much Pryd. that worked perfect, on the quest guide i mean.
It was the creature-involved-relation that was the problem.
But i don't think we really need the Quest End / Start scripts, well we only need that if you want to enchant your quest even more.
I did read on the WIKI that it was for many other commands, like teleports as you said

I tried with some say commands, but its looks like the WIKI ID on say commands is outdated.
Since i got some red errors on it, in the TrinityCore saying that no such ID exsist, it was not the quest ID that was wrong, but the command and datalong ID.

The repacks looks nice, but i think i stick with the blizz one.
But i guess i can always grab the custom items SQL

[lorac]

you have to hand enter the quests at the moment
I am working on a better solution
Core support wise
are they errors or just warnings
Quest start quest end quest relation quest template all must be in sync for it to work properly
after this next release coming i will focus more on the quest commands and see if we can get a better solution in place

[spitfire21]

Sounds great sorry I haven't been alive lately (school) but it's almost done yay!!!

[OMGPWN]

Is their a way to set my server to a PvP server? I am loving the Blizzlike realm and I'm dieing to kill my friends on my rogue

[pryd]

Is their a way to set my server to a PvP server? I am loving the Blizzlike realm and I'm dieing to kill my friends on my rogue

Well the bliz world does not support malls, vendors etc.
If you still want to use the bliz world you could add the customs to it or custom starting locations, whatever your heart desires.

But at that point you might as well use the PVP world database that I provide considering
I've put all the customs, plus fixed any import errors.

My PVP world has players starting in malls, 1 for ally, 1 for horde.
And the players also start with some necessary spells.

Though more modification needs to happen for those world databases to function
perfectly, for example.

There are quest portals up allowing players to get between both malls.
To disable that feature, either change the quest permissions or remove the npc.

Back in the day, if a player dies in the mall, you may need to spawn resurrection
npcs ( where they revive ) and add portals allowing them to get back into the mall, etc.
These are some things to keep in mind, and in time I may fix.

[secretdragon008]

Awesome with a quest maker lorac.

Well about the quest_end/starts scripts commands not working.
Well they worked, i just did read wrong from the core.
It was not allowed to set 0 in the dataint, i set 0 there since i don't needed any text,but oh well...

[lorac]

Is their a way to set my server to a PvP server? I am loving the Blizzlike realm and I'm dieing to kill my friends on my rogue

###############################################################################
# SERVER SETTINGS
#
#    GameType
#        Server realm style
#        Default: 0 = NORMAL
#                 1 = PVP
#                 4 = NORMAL
#                 6 = RP
#                 8 = RPPVP
#                 16 FFA_PVP (free for all pvp mode like arena PvP in all
#                     zones except rest activated places and sanctuaries)

Taken from configs
Please use your configs
I think this was what you were asking about

[mariella_28]

bug with mounts

ImageShack Album - 4 images

nice work`s

[tarshot67]

Hello

I have a problem, when I select a vendor in the game it makes me small lags
and errors displayed in the console:

"ERROR: Creature 7419201 (Entry: 2605 have UNIT_NPC_FLAG_TRAINER but have empty trainer spell list. "

and

"ERROR: Creature entry 26303 have unknown gossip option 2 for menu 0"

Can you correct this in a new release ?

Sorry for my bad english, i'm french ^^