Magnuss
-
Posts
318 -
Joined
-
Last visited
-
Days Won
16
Posts posted by Magnuss
-
-
Once I was a top10 Wiki writer. But seems nobody is anymore interested in TC wiki, looking how old and outstanding the stuff is.
Anyway I'm blocked since weeks and nobody cares. And I lost the interest to contribute.
-
Make it in 32-bit if you want to distribute to players :-)
Surprising lot of people are using Win32 OS.
-
-
-
On Windows I use something like that:
@echo off
SET updatefile=updatefiles.txtecho -- %date% %time% Start reading files > %updatefile%
echo.for %%C in (.\*.sql) do (
echo INSERT INTO `updates` (name^) VALUES ('%%~nxC'^); >> %updatefile%
)echo Done !
pause-
1
-
-
Thanks, is there a recommended way how to do that ? Or just by hand ? (Quite a lot of files to add)
One possible way would be to install a complete empty DB and let the core add the filenames into the 'updates' table. After that I can export this table to an existing DB.
-
I can't edit the wiki. It tells my password is expired, but 1 or 2 months ago I have edited something.
I also can't revoked a new password. Don't get any e-mails.
-
WoD is claimed as experimental. The errors are normal.
At least I have also lot of them :-)
-
For years I have updated my 3.3.5 databases by hand with a small script. Was always working without any problem.
But now I wanted to change to automatic updates by the core. (I do that for WoD from the beginning, it's quite comfortable)
The problem: The core makes or tries to apply old updates I have already done long time ago. Of course this behaviour either destroys my data or gives errors. My last core compliation and DB update was on Feb 09, 2016.
1. I started the auth server. Here's a snipped of the log:
2016-03-04_18:11:35 DEBUG Checking update "2014_11_10_00_auth.sql"...
2016-03-04_18:11:35 DEBUG >> Update is already applied and is matching hash '0E3CB11'.
...... more similar lines2016-03-04_18:11:35 DEBUG Checking update "2015_03_20_00_auth.sql"...
2016-03-04_18:11:35 INFO >> Re-hashing update "2015_03_20_00_auth.sql" 'E8C5B74'...
...... more similar lines2016-03-04_18:11:35 DEBUG Checking update "2015_08_21_00_auth.sql"...
2016-03-04_18:11:35 INFO >> Applying update "2015_08_21_00_auth.sql" 'C31A9E1'...
2016-03-04_18:11:35 ERROR Warning: Using a password on the command line interface can be insecure.
.....
2016-03-04_18:11:35 INFO >> Applying update "2015_11_07_00_auth.sql" '0ACDD35'...
.....
2016-03-04_18:11:35 INFO >> Applying update "2016_01_13_00_auth.sql" '24615CC'...However I know for sure that I have made these updates already. Here's the log of my own script:
09.02.2016 11:14:56.75 Start importing files
09.02.2016 11:14:56.76 Importing: 2015_11_07_00_auth.sql
09.02.2016 11:14:56.76 Importing: 2016_01_13_00_auth.sql
09.02.2016 11:14:57.06 End importing filesWhat do I need to do or what I'm doing wrong ?
Edit:
Of course when I start the world server the updating process fails from the beginning because it tries to update 2015_06_26_00_characters_335.sql which I have done long time ago. -
I'm also wondering what is hotfixes db good for and how it is working.
-
You also have to access with a german client and you need german localisation in your db.
And you need to extract DBCs from a german client.
With this you can let DBC.Locale = 255 (Auto Detect)
That's so far what I'm remembering on 3.3.5a
-
If you have complied a TC server yourself there shouldn't be missing libraries. And if you don't have an actual server these files are useless for you.
BTW: These files are huge ! Makes no sense to upload them.
-
1
-
-
-
That's a word :-)
I found also this: http://stackoverflow.com/questions/15948767/why-should-we-build-64-bit-targets-for-c-application
The answer about the CPU registers I found interesting for me.
" Aside from the OBVIOUS reasons given above (mainly "using more than 2-3GB of memory"), the reason to compile for 64-bit is that x86-64 has 16 registers, where x86-32 has 8. Since one of those registers is the stackpointer and often rBP is reserved for "framepointer", the actual useful number of registers is 6 and 14 respectively. The additional registers allow, for example, larger number of parameters being passed in registers, and larger number of temporary variables being held in registers within a function. This has a positive effect on the actual execution speed of the code, as every time memory is used instead of a register, AT LEAST it leads to a more complex instruction, and often to an additional instruction having to be used. This in turn makes the code larger when there isn't enough registers "
-
I know that, but that's exactly the point: Most software does not address such high amount of memory.
Is there something at TC ?
It belong also not to the classical group of 'CAD/CAE-like programs, data managers, programs to work with digital media and applied scientific applications'.
But what do you recommend ?
-
Thanks, works but ...
... of course I had to download and install 32bit versions of Boost and OpenSSL to get it running. And to use the 32bit libeay32.dll. Hope it helps somebody else.
Beside of that .... is there any advantage to compile the core in 64bit ?
I have done it but for 90% of software the only 'advantage' is that the 64bit version blows up the file size. -
Hi,
I compiled server and tools successful in 64bit on windows. And everything is working.
However a friend has a Windows 32bit only and needed the connection_patcher as 32bit version. I wanted to recompile the tools only.
But in MSVS there is no option in the dropdown for win32 and in CMAKE I also couldn't figure out what I have to chance.
Any help is welcome ;-)
-
Sorry, havn't seen you are on Debian.
Windows binaries you have to compile on Windows OS, I guess.
-
If you have compiled yourself than it should be a connection_patcher.exe either in your build folder or in your installation folder. If not you may have to check the tool box on in CMake and recompile.
-
Either the content is lost or nobody has time to change it.
-
For WotLK I used something like that: sha1(strtoupper("$username:$password"))
But for WoD it seems not to work. The hash is longer.
Anybody has a PHP example for WOD ?
Edit:
Found here something:
https://community.trinitycore.org/topic/10812-solvedsql-query-for-battlenet_accounts/
-
https://trinitycore.atlassian.net/wiki/display/tc/GM+Commands
But it's not up to date.
-
Cool, thanks to pointing it.
I'm curious if I can setup it now after some fails :-)
-
As it's written in the wiki https://trinitycore.atlassian.net/wiki/display/tc/Installation+Guide 6.x is experimental. That's not even alpha.
I even was not able to set it up because my 6.x client has another build version than TC suports atm.
[Solved][TC 3.x] Guild Bank
in Help and Support
Posted
Can't give you a direct answer to your question.
But maybe a hint: Do you know that you can change in the config the amount of needed petitions to 0 ?
So I never had to found a guild by gm commands and also never discovered some problems.