TrinityCore NPCBots Repack (Update 25-06-2020)

[skuly]

7 and worldserver keep crashing i tried all updates and same error

lol just noticed p missed too

the file ALL_characters_update7.sql in the sqlupdates folder has this at the top that should delete the table.

DROP TABLE IF EXISTS `custom_solocraft_character_stats`;

You could try going using DBeaver or any other SQL DB Manager and delete the table custom_solocraft_character_stats from the characters DB yourself.

But I don't have that problem so there is a chance whatever is causing that error for you will make it happen again further in the SQL file.

[keitaro79]

thank you just decided to do a fresh install and it was successful and character got restored just can i back up all guild bank or it get deleted with update?

[skuly]

i just did a fresh install and it updated successfully now im going to try to upload my character thank you

How you can backup guild info?

I'd say just export all the guild tables in the Character BD and insert them into the new DB?

[skuly]

thank you just decided to do a fresh install and it was successful and character got restored just can i back up all guild bank or it get deleted with update?

I don't think any of the sqlupdates from atleast 4-7 drop the guild tables so it shouldn't effect guild.

I'm not sure why the updater wasn't dropping custom_solocraft_character_stats for you before.

And by fresh install you mean copy/pasted my update files in the repack and ran it again? not deleted whole repack and ran updater?

[skuly]

If anyone else wants help maybe we should talk on discord instead of posting here back and forth about it, I have a Discord Server or you can just message me on Discord if you prefer skuly#2475

[keitaro79]

i wll join you in a bit

[idahoki]

In update7 both authserver.exe and worldserver.exe have compiled in debug mode, please rebuild. I use "old" ones from update6 but i guess the most new features don't work this way.

[skuly]

In update7 both authserver.exe and worldserver.exe have compiled in debug mode, please rebuild. I use "old" ones from update6 but i guess the most new features don't work this way.

Ok I forgot to change it back to release when i built it, rebuilt it as Release and updated the link. DOWNLOAD

And yeah there seems to have been a few fixes to spells and quests in trinitycore the past 2 weeks, not sure of the NPCBot changes though.

But seems most of the trinitycore quest fixes were done via SQL files from what I can tell from looking at trinitycore commits.

[EterniaLloyd]

Ok I forgot to change it back to release when i built it, rebuilt it as Release and updated the link. DOWNLOAD

And yeah there seems to have been a few fixes to spells and quests in trinitycore the past 2 weeks, not sure of the NPCBot changes though.

But seems most of the trinitycore quest fixes were done via SQL files from what I can tell from looking at trinitycore commits.

Hello! First off, thank you for taking up the mantle in zaicopx's absence! This is the first time I'm updating using one of your updates. I downloaded zaicopx's Update 10 off the first post, pasted your Update 7 files into the repack folder, deleted the lua scripts I don't like (so pretty much everything except for transmog), and then ran the Update_DB batch file. When I did, I got these errors:

ERROR 1366 (HY000) at line 14836: Incorrect string value: '\x81 VAMO...' for column 'RewardText' at row 1
ERROR 1366 (HY000) at line 2743: Incorrect string value: '\x80\xD0\xBE\xD0\xBB\xD0...' for column 'Details' at row 1

Did I do something wrong? Any help you can provide would be greatly appreciated, since I would love to keep using this repack with the updated TrinityCore/NPCbots.

[skuly]

Hello! First off, thank you for taking up the mantle in zaicopx's absence! This is the first time I'm updating using one of your updates. I downloaded zaicopx's Update 10 off the first post, pasted your Update 7 files into the repack folder, deleted the lua scripts I don't like (so pretty much everything except for transmog), and then ran the Update_DB batch file. When I did, I got these errors:



Did I do something wrong? Any help you can provide would be greatly appreciated, since I would love to keep using this repack with the updated TrinityCore/NPCbots.

Seems it might be 3.3.5 worldserver error on applying updates . Issue #22632 . TrinityCore/TrinityCore . GitHub

and this Requirements - TrinityCore - TrinityCore Collaboration Platform says disable strict mode in mysql 5.7

So I made the updater write sql_mode = '' to the mysql credentialsFile , hopefully that fixes your problem.

I'm not sure why it only effects some people.

Try THIS updated update7

[YorlenyTravieso]

I made an Eluna script, hopefully this what you want.

https://mega.nz/file/q14mkYiD#HG458t...K6-I2QBsxUufw8

if something like this is what I'm looking for but I need it in an npc and that instead of whispering it to show it in a text of the npc

look what I'm creating is something fun 80 pvp just for fun and to play local when I'm done I'll share it here in the comments

Update your browser to use Google Drive, Docs, Sheets, Sites, Slides, and Forms - Google Drive Help

[skuly]

if something like this is what I'm looking for but I need it in an npc and that instead of whispering it to show it in a text of the npc

look what I'm creating is something fun 80 pvp just for fun and to play local when I'm done I'll share it here in the comments

Update your browser to use Google Drive, Docs, Sheets, Sites, Slides, and Forms - Google Drive Help

Ok, hice NPC y Command.

El texto va a la ventana NPC.


Ok, I made NPC and Command.

Text goes to NPC window.

https://mega.nz/file/aoZ0TLhB#JuNCIN...zyveC7mGfPI1Jg

[YorlenyTravieso]

😍😍😍😍😎😎😎

[YorlenyTravieso]

Ok, hice NPC y Command.

El texto va a la ventana NPC.


Ok, I made NPC and Command.

Text goes to NPC window.

https://mega.nz/file/aoZ0TLhB#JuNCIN...zyveC7mGfPI1Jg

excellent thank you very much

[ponchifek]

I have several questions about this repack:
1) I'd like to complete a dungeon and get all its loot from bosses. Can I somehow increase drop rate to 100% only for them?
2) How can I get honor and arena points to buy pvp gear?