TrinityCore NPCBots Repack (Update 25-06-2020)

[YorlenyTravieso]

Ok I added Multivendor npc and made a lua_script to access and edit it.

You can download Update6 HERE

Vendor ID = 999999

Spawn it with .add npc 999999.

thanks friend

[DrTremal]

Hi all,

Hoping someone can help... First of all -ive spent about 4 days trying to solve this, doesnt help that i have a fractured collar bone, so im typing one fingered with my left hand, so bare with!

Essentialy i have a similar problem as others have had, but despite me trawling here and elsewhere for hours, the answer escapes me...

So i have attached a pdf with the relevant data...

Would be glad if someone can help me with this - cant get it working on the LAN or WAN - only on the actual server itself will the client login and pass the real selection screen.

[skuly]

Hi all,

Hoping someone can help... First of all -ive spent about 4 days trying to solve this, doesnt help that i have a fractured collar bone, so im typing one fingered with my left hand, so bare with!

Essentialy i have a similar problem as others have had, but despite me trawling here and elsewhere for hours, the answer escapes me...

So i have attached a pdf with the relevant data...

Would be glad if someone can help me with this - cant get it working on the LAN or WAN - only on the actual server itself will the client login and pass the real selection screen.

It could be something with ddns.net, I've tested with my wan ip and it works have you tried using your wan and see if it works with wan.

I am goign to make a ddns.net account and try using it. See if I have the same issue or not.

[DrTremal]

Yes, i think so:

fw allow apps.jPG

[skuly]

This is strange, seems you did everything right, I just created a ddns/no-ip account and used their program to keep my home ip bound to the address and added it to my database... everythign seems to work.

I logged in on second pc using the DDNS address and there was no issues.

So I don't know why you are having the problem.


I didn't make any changes to my conf files just added my ddns.net address to the auth.realmlist table and opened ports 8085 and 3724 to portfarwarding on router BOTH UDP/TCP

[skuly]

When I host a server it adds 2 Auth and 2 World to my inbound rules but nothing to outbound.



I assume you've tried deleting all the inbound rules and running auth and world again so you get asked to allow them ?

[DrTremal]

Yeh i removed the wow entries and the Trinity stuff, reloaded and let it prompt for access - put tick in public as well as private for world and auth servers, still no joy... might take the nucleur option and remove it all except port forwarding and check im pulling the latest repack...

Thanks btw for taking the time to look into this, its very much appreciated.

[skuly]

Yeh i removed the wow entries and the Trinity stuff, reloaded and let it prompt for access - put tick in public as well as private for world and auth servers, still no joy... might take the nucleur option and remove it all except port forwarding and check im pulling the latest repack...

Thanks btw for taking the time to look into this, its very much appreciated.

I don't know how you set the ports for inbound if I try to set ports I get errors, I have to use ANY .

Maybe you can try setting everything to ANY with Protocol TCP.

Any maybe you have to restart Auth and World exe 's when testing changes.

I think I give up though,

[DrTremal]

Well i re-downloaded the pack and then applied all your updates (1-6), set the dns in the auth db, checked realmlist in client was set to dns, tested - same issue, so i removed the specific ports 8085 and 3724 and set one of them to allow all ports through, still doesnt work ahh im at a loss on this.

Im assuming essentialy - even with the last complete repack pushed a few pages back (think page 6 on here) - this is the process:

Unpack core, data - all now in one folder in the root called wow-npc, in there i also put the client in a folder called Client.

Register dns (beansontoast.ddns.net) and test

Forwarded the two ports on the router 3724 & 8085 (set as both TCP and UDP) - port forwarded tested using external site.


Run start server - get prompted to allow access to private network for auth and world server .exe's - ticked public as well as private.

Access fw and set rule for inbound traffic on 3724 and 8085 to allow traffic

Load client on server, log in - access / create toon and play

Load same client on pc on same subnet / lan - can log in, but offered realm selection over and over

Same above for external to the lan.

Tried opening all ports on fw - still fails, turned fw off, still fails.

Edit:

Not sure if relevant but should this be showing 127.0.0.1?

trinity.JPG

...silly question, but is there some server side logging that might show why its knocking player back to realm selection screen?

[skuly]

Well i re-downloaded the pack and then applied all your updates (1-6), set the dns in the auth db, checked realmlist in client was set to dns, tested - same issue, so i removed the specific ports 8085 and 3724 and set one of them to allow all ports through, still doesnt work ahh im at a loss on this.

Im assuming essentialy - even with the last complete repack pushed a few pages back (think page 6 on here) - this is the process:

Unpack core, data - all now in one folder in the root called wow-npc, in there i also put the client in a folder called Client.

Register dns (beansontoast.ddns.net) and test

Forwarded the two ports on the router 3724 & 8085 (set as both TCP and UDP) - port forwarded tested using external site.


Run start server - get prompted to allow access to private network for auth and world server .exe's - ticked public as well as private.

Access fw and set rule for inbound traffic on 3724 and 8085 to allow traffic

Load client on server, log in - access / create toon and play

Load same client on pc on same subnet / lan - can log in, but offered realm selection over and over

Same above for external to the lan.

Tried opening all ports on fw - still fails, turned fw off, still fails.

Edit:

Not sure if relevant but should this be showing 127.0.0.1?

trinity.JPG

...silly question, but is there some server side logging that might show why its knocking player back to realm selection screen?

Authserver shouldn't be showing 127.0.0.1 if you changed it in the auth.realmlist table
It should be showing beansontoast.ddns.net

This repacks last update before I started making updates to is was Update 10, it's post #95

[DrTremal]

Odd, i double checked and it looks ok to me?

dbase.jpg

[skuly]

Odd, i double checked and it looks ok to me?

dbase.jpg

That seems to be the table properties not the actual data. You need to switch to the data section and I bet you it says 127.0.0.1 there.





I made a batch file that will update the database for you if you can't figure it out. realmlist_updater.zip
But you probably won't need my batch file once you switch to the Data tab in heidisql you should see it says 127.0.0.1 and is causing the problem.

[DrTremal]

Authserver shouldn't be showing 127.0.0.1 if you changed it in the auth.realmlist table
It should be showing beansontoast.ddns.net

This repacks last update before I started making updates to is was Update 10, it's post #95 (TrinityCore NPCBots Repack (Update 25-06-2020))

You Sir, are a genius! That was it! All this time i was just changing a label or something as opposed to the actual data! Dammmmmnnnn...! Thanks bud, i owe you a beer for that one, days ive spent trying to solve it and all along it was that! Ahhhh relief !!! Hurray! Give this man a beer or two!

[skuly]

You Sir, are a genius! That was it! All this time i was just changing a label or something as opposed to the actual data! Dammmmmnnnn...! Thanks bud, i owe you a beer for that one, days ive spent trying to solve it and all along it was that! Ahhhh relief !!! Hurray! Give this man a beer or two!

In Heidi it says "basic" in DBeaver it says "properties".

When the table gets created the basic/properties are told to the sql server like if the values can be signed or unsigned 8/16 bit integers or whatever and a default can be set or it can be set to null.

So yeah that is just the information from when the table was created or for when exported and that address was the default.. so if you export that table for others to use to create the table in thier dB the default would be beansontoast.ddns.net when the table gets created.

This is pretty new to me too but when I made the sql updates and the updater batch files I learned the basics of this. I had to create cms database for the blizzlikecm too..

And when I had to learn some Lua so I could understand Eluna and how to write to and read from the database via an eluna script I found out about how some tables use integers etc.

[DrTremal]

Ah i see, my only experience in sql has been with MS SQL Manager, so yeh slightly different to Heidi, enough to confuse me for a good while, so thanks again, it may have seemed obvious to you and others, but to me, it was like bashing my head on a rock

Side note, is there a guild vendor in this? i created a guild but couldnt see any of the guild stuff for sale, im assuming they arent in the game as its a single player project, so rewards gained from large groups ie guilds probably isnt the most logical thing to include..that sound about right?

Thanks again for your help and advice on this, its priceless!