Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Rochet2 last won the day on February 22

Rochet2 had the most liked content!

Community Reputation

206 Excellent


About Rochet2

  • Rank
  • Birthday 10/26/1993

Contact Methods

  • Website URL
  • Skype

Profile Information

  • Gender
  • Location

Recent Profile Visitors

7401 profile views
  1. It would be best to avoid SQL queries if you can. However as you asked for an example of how to make this query, here is one: #include "DatabaseEnv.h" int64 count = CharacterDatabase.PQuery("SELECT COUNT(*) FROM characters_spells WHERE guid = %u", player->GetGUID().GetCounter())->Fetch()[0].GetInt64(); if (count >= 30) { } In this code - the include allows you to use CharacterDatabase variable, which is a global variable. - PQuery makes a database query and allows you to use printf like syntax to format variables into the SQL. - GetCounter returns the part of the guid that is usually used in DB for players and items to identify them. - Fetch returns the current row from the query result, we call this directly as we know that a result will be returned from this specific SQL. - [0] accesses the first column in the query result. In this case it is the count. - GetInt64() takes the column data and handles it as an int64 value. Most math in SQL is done with bigint, so using uint32 or similar may actually not work on some machines. Always use proper type! - the resulting value is stored into a variable "count" and then compared against 30.
  2. @Verytas Starting over with the source code that matches your client version (7.x) should fix the most imminent issues you have. (follow what I said before) TrinityCore seems to be in the middle of transitioning to 8.x. Guides have not been updated yet and without external tools you cannot use 8.x client yet with TC, so I would not personally recommend trying to use the latest master branch or 8.x clients yet.
  3. @Verytas Seems you are trying to use latest master branch with 7.x client. However master = For 7.3.5 you probably want to go back to the commit that supported that version. For example: git checkout -b 7.3.5 7.3.5/26972 See https://github.com/TrinityCore/TrinityCore/tags and https://git-scm.com/book/en/v2/Git-Basics-Tagging
  4. To print information about closest gameobject you can use .gobject target The information should contain the gameobject's guid. Then you can delete the object by its guid with .gobject delete <guid>
  5. At least I cannot see an edit button on the main page. Other pages seem editable. Main page: Any other page:
  6. The database links are also broken. https://trinitycore.atlassian.net/wiki/spaces/tc/overview?mode=global world database characters database auth database
  7. Hmm, on forum main page right side there is the same topics section twice https://community.trinitycore.org/
  8. Links on the main page of the wiki are also broken in same way: https://trinitycore.atlassian.net/wiki/spaces/tc/overview?mode=global "Description of TrinityCore DBC files contents" "How to add a custom script to your solution" "IRC: #Trinity @ irc.rizon.net (Rules)"
  9. mysql 8 not supported yet: https://github.com/TrinityCore/TrinityCore/issues/22188#issuecomment-407205183 https://trinitycore.atlassian.net/wiki/spaces/tc/pages/10977296/Windows+Requirements
  10. Hmm, why did you add that? I don't think I suggested such at least. The commit/changes I referenced had no mention of such code. https://github.com/TrinityCore/TrinityCore/commit/5734643cecbadfffb7ee1b66c9665d57108923f6#diff-82d123ab4d0745ba8103dc4b10c23d9f If you have 0 experience, maybe trying out the latest version of TC is easier. And if you are already are using the latest version, then you have probably mismatching dependencies or you installed only boost source without the precompiled binaries or similar - for that you should post information about your installation like what boost you have, how does the installation of it look etc. If you really need to try some old unsupported core .. maybe using old versions is an ok choice if you just want to get things working. Less recent boost usually means using a less recent compiler as well if you use the precompiled packages. Cherry-picking is taking only a specific commit/change. You can do that with the command "git cherry-pick <commit>". You can also just do the changes manually. Googling will get you far Hmm, after the other post you made I am not sure what exactly you did or tried. Maybe using the older version of compiler and boost is ok if you can't get anything to work and if they work. To be able to work with the latest tools and libs you would need the changes though.
  11. No. You should cherry-pick the commit I referenced. It should fix your problem with boost (clear cmake cache and retry configure after you cherry picked). Though I guess also using older versions would get rid of the error since it is caused by newer versions, but .. is using old stuff really the solution?
  12. With the boost you have you should be using win64. There was some problems with the new boost versions and the cmake script a while back. Maybe the 6.x core you have has the old cmake script that cannot handle the .1 in the folder name. For this reason I think I temporarily copied my lib64-msvc-14.1 folder and named it lib64-msvc-14.0. But instead of that maybe its better to check if your core has the needed boost cmake changes: https://github.com/TrinityCore/TrinityCore/commit/5734643cecbadfffb7ee1b66c9665d57108923f6#diff-82d123ab4d0745ba8103dc4b10c23d9f .. and now right after writing that I just went there and checked and it doesnt, so maybe cherry pick that commit or something.
  13. Which compiler did you choose in cmake? Did you choose Win64? or the one without it?
  14. Do you have the lib folder(s) with msvc in the name in the boost installation folder?
  15. Usually, if you have boost root set up properly, it can still fail if you are using the boost source instead of precompiled binaries or binaries compiled by yourself. For example, I have everything set up correctly, however when I hide lib64-msvc-14.0 and lib64-msvc-14.1 from my boost installation folder, Cmake will complain with CMake Error at cmake/macros/FindBoost.cmake:1231 (message): Unable to find the requested Boost libraries. Boost version: 1.64.0 Boost include path: C:/local/boost_1_64_0 Could not find the following static Boost libraries: boost_system boost_filesystem boost_thread boost_program_options boost_iostreams boost_regex No Boost libraries were found. You may need to set BOOST_LIBRARYDIR to the directory containing Boost libraries or BOOST_ROOT to the location of Boost. If you still have problems search on forum for TCE00020. Call Stack (most recent call first): dep/boost/CMakeLists.txt:44 (find_package)
  • Create New...