Search the Community
Showing results for tags 'updates'.
Found 3 results
Sale Updates (launchers) Updater functions: 1. Player's online output. 2. Server status output (ON/OFF). 3. Updater's new versions checking. 4. Any amount of hyperlinks and buttons can be added to the updater. 5. Switch between languages in the updater instantly (RU/EN is currently available). 6. Updater will recognize the language of the user's system and make it default (no need to switch languages manualy for international projects). 7. Upon successful update, the game will launch automatically. 8. Players may choose between download the full client or the local patch. 9. News output from your website into any field on the updater. 10. Shortcut to the desktop. Below you can find examples of my most recent works.
I've seen many tutorials (mainly for windows) where tutorial has you 'batch' all the SQL files into a a single *.sql and then the user would import that single file. There are some un-discussed issues with that method; This method does not allow easy identification of errors that might occur during the import of the query. This method could produce a large file that takes some time to load into memory and/or process Not to mention the batch process isn't needed; everyone should already have all the tools they need in order to just import the updates 'en mass'. Here are the scripts to use... Windows Version for /f %%a in ('dir /b *world*.sql') do "C:\PROGRA~1\MySQL\MYSQLS~1.5\bin\mysql.exe" -u [MYSQL User] --password=[User's Password] --database=[Database] < %%a Linux Version for file in *world*.sql; do mysql -u [MYSQL User] --password=[User's Password] [Database] < $file; done **Both examples assume the MySQL Server is running on localhost, if not add -h [Host IP] to the script(s). To process auth or character updates, simply change *world* and [Database] and viola! This may not be necessary any more with TrinityCore's new auto-update scripts, however rumors indicate that there are still some issues with that process. This will work for any core, or anything for that matter. Hope this helps..