Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Update issue #20799

Closed
leewheel opened this issue Dec 1, 2024 · 3 comments
Closed

SQL Update issue #20799

leewheel opened this issue Dec 1, 2024 · 3 comments

Comments

@leewheel
Copy link

leewheel commented Dec 1, 2024

Current Behaviour

image

Expected Blizzlike Behaviour

UPDATE acore_world.creature_loot_templateSETMinCount= 2,MaxCount= 3 WHEREEntry= 21212 ANDItem= 34062 ANDReference= 34062 ANDGroupId= 3; UPDATEacore_world.creature_loot_templateSETMinCount= 2,MaxCount= 3 WHEREEntry= 21215 ANDItem= 34059 ANDReference= 34059 ANDGroupId= 0; UPDATEacore_world.creature_loot_templateSETMinCount= 2,MaxCount= 3 WHEREEntry= 21214 ANDItem= 34060 ANDReference= 34060 ANDGroupId = 0;

Source

UPDATE acore_world.creature_loot_template SET MinCount = 2, MaxCount = 3 WHERE Entry = 21212 AND Item = 34062 AND Reference = 34062 AND GroupId = 3;
UPDATE acore_world.creature_loot_template SET MinCount = 2, MaxCount = 3 WHERE Entry = 21215 AND Item = 34059 AND Reference = 34059 AND GroupId = 0;
UPDATE acore_world.creature_loot_template SET MinCount = 2, MaxCount = 3 WHERE Entry = 21214 AND Item = 34060 AND Reference = 34060 AND GroupId = 0;

Steps to reproduce the problem

Run the worldserver.exe, just read the log

Extra Notes

No response

AC rev. hash/commit

Sory, Server crashed,so no hash can gei, but i imported This two days update

Operating system

Windows 10

Custom changes or Modules

No response

@sudlud
Copy link
Member

sudlud commented Dec 1, 2024

can't reproduce on fc9e730

edit: also we would have CI failing by now if this was an issue on a clean AC install.

@sudlud sudlud added the Invalid-Can't reproduce This doesn't seem right label Dec 1, 2024
@sudlud
Copy link
Member

sudlud commented Dec 1, 2024

also the commit hash is also the first message when starting the worldserver, can you please provide yours

@Kitzunu
Copy link
Member

Kitzunu commented Dec 1, 2024

Can't reproduce

@Kitzunu Kitzunu closed this as not planned Won't fix, can't repro, duplicate, stale Dec 1, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants