[Ссылки могут видеть только зарегистрированные пользователи. ]
Хроники: HF5
Размер: 17 MB
- Fix
Цитата:
Removed some SuppressWarnings annotations that are hiding possible problems:
* Removed some unused variables and methods.
* Added some serialVersionUID.
Refactoring SystemMessageId and NpcStringId to reuse parameter related classes:
* Many thanks to MELERIX for testing it in-game.
* Changed Builder from interface to abstract class, so it can contain newBuilder(String) method.
Attacked players in craft/shops stand up.
-- Attacked players in craft/shops stand up.
-- Sorry I forgot credits for Tryskell in [5451].
-- Adding L2Tower abstract class to manage common methods to L2FlameTowerInstance and L2ControlTowerInstance.
* Making the code more abstract reduce the code to maintain and improves the chances of spotting bugs.
* Following change sets will be about this kind of code refactoring (except bug fixes :P ).
-- Adding L2Tower abstract class to manage common methods to L2FlameTowerInstance and L2ControlTowerInstance.
* Making the code more abstract reduce the code to maintain and improves the chances of spotting bugs.
* Following change sets will be about this kind of code refactoring (except bug fixes :P ).
-- Refactored Quest item get related code to avoid duplicated code.
-- Cleanup.
-- Reusing "Get Heros" SQL related code.
* Some other minor fixes.
-- Fixed sps behaviour when using potions while casting magic skills. Thanks '''MELERIX''' for help.
* Builders Updates.
BETA/LIB: ECJ Lib Update.
* Updated WTP Settings.
-- L2Event fixes, thanks fakoykas.
-- Resource leaks fixes.
-- LoginController resource leak.
-- ItemAuctionInstance resource leak fixes.
*-- Added the missing new lines for warnings introduced in E4.2.
-- Some base stats formula reworks.
- Fixed Magical Critical Rate with retail formula (WIT modifier * 10).
- Fixed Critical Rate with retail formula.
- Improved some code and cleanup.
- Moved getLevelMod() in L2Character.java and deleted in some other files.
- Fixed Magical Critical Rate values in Skills.
- Added pDef on FuncPDefMod.java when Underwear and Cloak Slots are empty.
- Fixed mAtk/pAtkSpd formula for skills ((time in milliseconds / current pAtk/mAtkSpd) * base pAtk/mAtkSpd).
- Cleanup char_templates.sql.
-- JavaDocs for some classes.
-- Fix for [5468]. getLevelMod() at L2Character should not return 1, but '''(100.0 - 11 + getLevel()) / 100.0; '''
* Minor SVN prop changes.
-- Small fix for [5470] - this should't be there...
* MySQL Connector/J 5.1.21, Changelog here:
-- Builders back to ant 1.8.2 i wont change my whole eclipse just the for stupid ant.
-- Little cleanup of L2DoorInstance
-- More cleanup for [5468].
-- More cleanup for [5468].
-- LoginCrypt Optimization by FBIagent. Also a Javadoc update. Thanks.
-- Fixing ConcurrentModification in Siege
-- Small typo fix in l2jmods.properties, thanks darknessneo.
-- Unhardcoded recharge AutoSoulShot and some cleanup in L2Character. Thanks '''Zoey76''' for help.
-- Cleanup due [DP8969] (isHerbEffect check is redundant due already checked by isStatic).
-- Extensively use of try-with-resource:
* Using Statement instead PreparedStatement for queries with no parameters!
* Fixed many warning related to resource leaks.
* Rework of NpcTable to avoid duplicated code for retail and custom NPC data tables.
-- Fixing broken spiritshot behaviour in some skills. It turns out that in those skills, the sps charge is removed before the skill's effects are applied, thus the effects are executed without a sps charge.
Also reworked a bit the spiritshot uncharge method, no need to check the charge if its not NONE in order to change it to NONE.
-- Adding ssUncharge() method which is similar to spsUncharge(). Also cleaning-up the soulshot use of some skills.
Oh, and I removed the "shots on daggers dont affect skill damage" check, because its outdated and invalid.
-- Fixing a wrong check regarding skills usable on doors. UNLOCK_SPECIAL skillhandler is now properly working.
Also ((L2DoorInstance) target).isOpenableBySkill() check is already done in the skill handler, so we dont need it here.
-- DocumentParser support for recursive folder parsing.
-- A little more useful methods in StatsSet
-- Minor cleanup by UnAfraid request.
-- Little typo fix in NpcTable now custom npc's must be fine thanks DareStrike for report.
-- One more little typo in NpcTable
-- Removing duplicated code at L2CubicInstance.
-- Fixing shots related code:
* Closing #6251
* Please do not use ternary operators for '''explicit boolean''' values:
* return (EXP1) ? (EXP2) : false;
* Instead use:
* return (EXP1) && (EXP2);
* isSoulshotCharged and isSpiritshotCharged methods should both ask for Player, NPC and Summon.
* Fixed comments.
'''Note:''' ternary operators should be used for: EXP ? EXP1 : EXP2; for example.
-- Fixed encoding of some files.
-- Fixing Eclipse's default compiler compliance level Patch By: jurchiks
-- Another NpcTable typo Patch By: Tavo22
-- Typo fix in global on death listener..
-- Fixing Polymorph issue (Packet wasnt updated to H5) Reported by: valdaron.
Also review of AbstractNpcInfo/UserInfo/CharInfo packets.
Some flyType skills can be used while movement is disabled. (Warp, Blonk, Air Blink, etc.)
-- Minor update for Diego Vargas vegdamage formula.
-- !ServerPackets rework dropping getType method since is completely useless using getClass().getSimpleName() instead.
* Formatted all packets
* Cleaned all crappy comments
* Added a lot of TODO/FIXME/XXX comments
* Trigger packets cached to static variable STATIC_PACKET (As ActionFailed?)
* Upper-case hexadecimal letters (Such as 0xFE)
* Added missing public/private/protected final declarations
* And god knows what more..
-- Fixing little NPE since [5503] Reported by: DareStrike
(You haven't seen this)
-- Missing recompile MMOCore Lib from [5497].
LIBRARY: Updating ECJ's name from [5460]:
* There is no 4.2 version.
* The file name contains 3.8.1 version.
* The actual build version is 3.8.0.
* Can be checked using:
{{{
>java -jar ecj-3.8.1.jar -version
Eclipse Compiler for Java(TM) 0.C58, 3.8.0, Copyright IBM Corp 2000, 2012. All rights reserved.
}}}
-- Updating Java Engine library.
* Updated build name to keep trac of versions.
* __Don't forget to remove old libraries.__
* This will avoid warning flood in server console, since there are hidden in Eclipse settings they should also be hidden in game server's logs.
-- Fixing Auto-Equip Arrows/Bolts:
* They were equipped in left hand if weapon and arrow's grade matched.
* Closing #6255
* Arrows/Bolts was valid and fixed in this change-set.
* Beast Soulshot seems invalid.
* Pet ride was fixed in [5161], and currently working.
Reported By: vagabond
LIBRARY: Reverting [5508]:
* Even when the the version is 3.8.0 the internal build is slightly different for 3.x and 4.x branches.
* [[Ссылки могут видеть только зарегистрированные пользователи. ] Download JDT Core Batch Compiler]
Reported By: MELERIX
-- Fixing trade exploit that allows players to accept the trade when they are far from each other.
* Closing #6223
* Classes formatted.
* Minor typo in !SystemMessageId comment.
-- Null pointer access vulnerability fix:
* Related to pet name change and control item.
* Closing #5318
* Probably from forced database item delete.
-- Minor revert for hennas, from [5503-5505].
* Added class JavaDocs.
Reported By:
- franpisco
- Konstantinos
- u3games
-- Misc fixes:
* Removing unused method at !LoginServerThread.
* Avoiding useless log from c3p0.
* Minor update for log at !L2PetInstance.
* Minor update for class JavaDoc at !EnchantGroupsData.
* Minor format for !HennaInfo.
* Minor improvement for !RaidBossSpawnManager.
-- Fixing DB Installers somehow SQLFilter wasn't included in ant build.
-- Improving account ip whitelist feature now it supports multiple ips also a type blacklisted ip or allowed ip.
-- Little typo fix from [5517]
-- Moving EnchantHPBonusData to extend !DocumentParser:
* Using Java's !HashMap instead of Trove's map.
* !JavaDocs and formatting.
* Fixed #5980, exception when Olympiad enchant limit is zero or less.
-- Reworking Connection closing by using try-with-resource:
* Using Statement instead !PreparedStatement where parameters are not required.
* Minor change in formatter settings to give proper format to try-with-resource statement.
* Fixed many resource leaks.
-- Little typo fix after [5520] Reported by: Burner, powerfulguardian
-- Pets will no longer take party items without giving the chance to distribute them.
-- Some useful utils. I hope you find them as useful as I did
-- Extend Quest for ItemBypass (tnx JIV for it!)
-- Currently, summons that are affected by effects which use weapon/armor conditions (such as Boost Morale, Angelic Icon, Spirit of Shilen etc.) pass those conditions only if their owner passes them. This is wrong. Summons dont have weapons nor armors, therefore effects that require weapon/armor condition shouldnt affect summons no matter if their owner meets the requirements or not.
If you somehow think that this change is wrong, that summons should get the bonuses if their owners met the requirements, make a post and prove me that im wrong.
-- Fix for possible NPE in my последняя(ий) commit [5527]
-- Minor fix for Telnet:
-- Core-part for [DP9027]
-- Adding some new listeners
* Dlg Answer listener
* Notify when client sent DlgAnswer packet.
* RequestBypassToServerListener
* Notify when client sent RequestBypassToServer packet.
-- More listeners
* Added char create/delete/restore/select listener
* Added some TODO tasks
-- Typo fix from [5530] and little javadocs typo
-- If configuration files aren't present server shouldn't crash:
* [#update Fixed typo in default IdFactory, Compaction is disabled and default in file is BitSet.]
* [#update Fixed missing default for GameserverHostname, now is *]
* [#update Removed useless exceptions throws.]
* [#update Fixed some logs messages.]
* [#update Capitalized all properties file names.]
* [#update The AcceptNewGameServer default value in file is now true, same as it's in Config.java]
* On server set up there is no need to register it anymore (hexid.txt).
* [#update The LoginHostname default value is now 127.0.0.1]
* After !AcceptNewGameServer is set to true it will accept any game server, so binding it to localhost is required.
* [#update Restored DatapackRoot for login server.]
* [#update Changed some log level from config to info.]
* [#update if ipconfig.xml is missing Game Server is binded to localhost.]
* Fixed some !JavaDocs.
----
= UPDATE YOUR CONFIGURATION FILES PROPERLY = #update
{{{
#!html
}}}
-- Quest#getHtm() ArrayIndexOutOfBoundsException typo fix Reported by: DareStrike, thecast
--
* Rename getAttackStanceTask() method to hasAttackStanceTask()
* Epsilon approach for "TODO: (Zoey76) This is mathematically wrong." in L2Character
* Comment corrections in SystemMessage
* Some minor updates/fixes.
* Minor Update for Builders javac task to prevent Ant from creating empty dummy classes.
* Updated Eclipse settings (same that core) for Libs Projects and Community Server.
* Removed -switchDefault from warn settings in ECJ due is already ignored by default.
-- Object oriented Zone settings:
* This should allow safe reloading.
* [[Ссылки могут видеть только зарегистрированные пользователи. ] Forum thread: Safe zone reload]
Patch by: UnAfraid
-- Reverting some changes of [5537] please keep compatibility for the 1.8.2 version!
-- Core-Part for [DP9036] (Removing the terrible hack)
-- Fixing server stuck during zone reload.
-- Adding two useful methods to QuestState: isSet and getCond.
* Patch by: jurchiks
-- Moving wrong-placed listener.
-- Add Olympiad H5 Features:
* The new UI for match list will now appear.
* The new UI for match end will now appear.
* Added some TODO tasks
* Patch by: JIV
-- When you accept a quest, the game system examines your character's inventory and quest inventory to determine if your character has enough free inventory space for the quest item or items. Previously, if the combination of both inventories was 80% full, you could not accept the quest. This percentage has increased to 90%.
-- Cleanup of Olympiad classes and little typo fix.
-- Fixing Linux DB Installers Reported by: tukune
-- Olympiad config typo fix.
* Patch by: K4N4BS
-- Little Cleanup for [5548]
-- While player casting an it's target move behind a wall/door/etc.. cast must be aborted.
* Patch by: Tavo22
-- Removing flag unset when player die sometimes it can add karma if player had servitor alive and it was killed after the player.
* More Info: [Ссылки могут видеть только зарегистрированные пользователи. ]
* Reported by: Tavo22, facheme, blacksea
-- Minor improvement for RaidBossSpawnManager.
* The respawn should be controlled by AI when minRespawn and maxRespawn both are equal to 0.
* Formatting and Cleaning.
-- Config for geodata directory location.
(If you have more then one server now you can share same geodata files)
-- Config for pathnode directory location.
-- Minor fix for L2AttackableAI and L2RaidBossInstance.
* Attackables shouldn't add Static Objects like possible targets.
* Unharcoding Gordon in L2RaidBossInstance.
-- Fixing Logistics Officer's missing htmls.
* Patch by: malyelfik
-- Minor changes to getHtm() method by UnAfraid, there will be examples of use later.
-- Handlers rework:
* Using generic interface to standardize current and future handlers.
* Added removeHandler method.
* Cleanup of all the package.
* Misc:
* Little cleanup of QuestManager.
* Added the new Say2 npc types (In h5 there is a filter for them)
* TODO: Use them.
-- Minor fix for Crating feature, extra from [5395].
-- Fixing little typo with npc showName/targetable seems i swapped them in first implementation.
-- Fixing the method !addItemName(int) to support custom items as well.
-- Moving some npc instances to dp scripts:
* L2BirthdayCakeInstance
* L2CabaleBufferInstance
* L2TotemInstance
* And little some cleanup.
-- Addressing the problem with resource leaks.
* Using [[Ссылки могут видеть только зарегистрированные пользователи. ] encapsulation] to avoid the System.in input stream to get closed.
* build.xml changes to include it in tools by UnAfraid, thanks.
* Closing #6273
-- Fixing NPE for not existing child door.
* Reported by: Micr0
BETA/COMMUNITY/LIBS: Updated WTP Settings.
- Fix for Ticket #L5479.
- Updated Talisman's Skills also implemented the missing ones (except "Grey Talisman of Fishing" due require special support).
- FlagWar synthetic access fix.
LIBS/COMMUNITY/- Added the missing new lines for warnings introduced in E4.2.
- DP-Part for ??[L5468].
- Fixed Missing skillRadius in "Shock Stomp" Skill (Thanks Tavo22 for report), also some more changes for pcBaseStats.xml file.
- Moved servertopdir.xsd to (community/data/xsd), some other minor changes included.
- Fixed HTM links when you have ally with Ketra Orc.
- This part from [8585] is not needed with H5 Client.
- DUMMY skillTypes are not only for players.
- Little fix for Olympiad Undefeated. Thanks jurchiks
- Builders back to ant 1.8.2 i wont change my whole eclipse just the for stupid ant.
- Mutated Kaneus Quests improvements. Thanks jurchiks.
- Minor update for Maestro's Key Skill, due [L5477].
- Moved levelRange condition from [8967] to Item, also updated xsd for it.
- Herbs & Potions effects should be shared with Servitors, thanks u3games for report and Zoey76 for confirm it in retail.
- Warning fix and cleanup, anyway this skill handler should be an effect and the code should be rewritten.
- DP Part for [L5484].
- Shot checks on skillhandlers and effecthandlers cleanup.
- DP Part for [L5485]. Also mobs now will get their skill damage increased when they use shots.
- Deadly Strike - you should attack after you cast the skill.
- Fixing Sticky Mushroom Skill.
- Admin command "admin_teleport_reload" cleanup by UnAfraid.
* Instead use the standard //reload teleport
- Datapack part for [5489].
* Note that reloading all would do lot of damage to the game server, for that reason it was never implemented.
- Small typo fixes in database_installer.sh.
- Fixed [8976].
- Updated server_menu.htm (reloading part).
- Fix for Finding the Lost Soldiers (452), thanks Tavo22 for report and test.
* Thanks jurchiks for review.
- Fix for Finding the Lost Soldiers (452), thanks Tavo22 for report and test.
* Thanks jurchiks for review.
- Fixing some HTML typos.
- Fixed Town NPC Walkers initial positions and few other minor fixes related.
- Fixing Eclipse's default compiler compliance level Patch By: jurchiks
- The Clan points reward for these Clan quests have been doubled:
- A Clan's Reputation
- A Clan's Prestige
- A Clan's Fame
- Updating Guard's Kamaloka info.
* Note that the file names are retail like.
* Using Link action as retail does.
- Minor update for Diego Vargas vegdamage formula.
- Implemented Benom's Skills also fixed npcaidata for him.
- DP-Part for [L5503]
- Missing from [8658].
- Updated Throwing Dagger Skill, thanks Nik for report about missing isDebuff boolean.
- Missing blowChance in [8993], thanks Konstantinos for report.
- The success rate of Mass Fear skill has significantly increased in H5.
- The success rate of Demonic Blade Dance skill were increased and MP consumption were decreased in H5.
- The success rate of Throne Root skill was increased in H5, also fixed dotot effects.
- Html fixes for the Bandit Stronghold related NPCs.
- Ported some quests from Jython to Java and updated to H5:
- A Clan's Reputation (508).
- A Clan's Fame (509).
- A Clan's Prestige (510).
- QuestState improvements for Q10273 & Q10274. Patch by: jurchiks
- '''To the Primeval Isle''' Quest from Jython to Java.
- The starting level for the quest '''In Search of The Nest''' has been increased from 66 to 81 due to changes made to the Stakato Nest. ('''Source:''' [Ссылки могут видеть только зарегистрированные пользователи. ])
- Updated to H5.
- Ported from Jython to Java.
- DP-Part for [L5517]
- Also dropping the old userIP field in accounts table.
- More for [9004]
- Datapack for [5519].
- Reworking Connection closing by using try-with-resource:
* Using Statement instead !PreparedStatement where parameters are not required.
* Minor change in formatter settings to give proper format to try-with-resource statement.
* Fixed many resource leaks.
- Temple Champion Quests series from jython to Java.
* Added the new QuestState methods
* Fixed the HTML extensions
- Fixing a possible retail typo interfering with Primeral Isle mapregion. Thanks to facheme for reporting. Also minor fixes for [9009].
- Gracia Quests Improvements. Also a fix for Q137 TempleChampionPart 1 in [9010].
* Added the new QuestState methods
* Fixed HTML extensions
Patch by:
* jurchiks
Reported by:
* jurchiks
- Fix for the Q10271 The Enveloping Darkness after the latest improvements.
- Missing quests for Sailren Battle.
- The Name of Evil - 2 (126).
- Attack Sailren! (641)
- Fix for Ticket #5335
Patch by:
* flya1106
- TargetMe effect fix. It shouldn't affect non-enemies. Shield Strike will no longer change the target of a non-enemy player.
- Charge skills shouldn't be able to be cast while movement is disabled (it was broken in [L5501] ). Thanks Tavo22 for reporting.
- Ported '''Seven Signs Series of Doubt''' (192) from Jython to Java, also fixed olympiad quests items.
Patch by: '''Tavo22'''
- Updated scripts.cfg for the последняя(ий) quest and some Javadocs.
- Fixing Finding the Lost Soldiers (452) missing html and some JavaDocs.
* Please keep this format for Quest heading, thanks.
- '''Meeting the Elroki''' Quest from Jython to Java.
- Some fixes.
* Added formatter settings missing from [9007].
* Minor Fix for XSD from [9006].
* Temp Fix for Skill 2060 "Healing Medicine".
* Minor Fix for [9017] "is_freightable" is false by default.
- ItemBypass (tnx JIV.. again )
- Reorganize Spawnlist and Droplist tables:
* Reformatted and cleared
* Added some comments like npc/item name
* Sorted Spawnlist by Map Region Id and npcId.
* Sorted Droplist by npcId.
* Trimmed Droplist's chance field (6 digits after the .) without the ending zeros.
- Updating gatekeepers teleport locations to High Five.
- Teleport costs leaving Oren and Schuttgart have been changed ([Ссылки могут видеть только зарегистрированные пользователи. ]).
- Fixing some HTML typos.
- NPE fixes for the following quests:
* Q508_AClansReputation
* Q509_AClansFame
* Q510_AClansPrestige
- Dark Elven Changes 1 and 2 from jython to Java.
- Quest folder refactoring to sort them in alphabetical order.
The new template is Q(6 digits)_(Quest name) Example: Q00015_SweetWhispers
Suggested by: jurchiks and MELERIX
- Restoring deleted quest by mistake.
- DP-Part for [L5531-5532]
- Quest-related fixes:
- The Name of Evil - 1 Quest from Jython to Java.
- Closing #5337
- Closing #4898
- Added missing npcs for quest '''Resurrection of an Old Manager'''
- Closing tickets #4178 and #4837
- Updated faenor.xsd file, also fixed spawn location for NPC 36410.
- Fixed accounts_ipauth.sql fail on upgrade.
- '''A Powerful Primeval Creature''' Quest from Jython to Java and updated to High Five (thanks '''lion''' for the HTML), also fixed some primeval npcs coords.
- Fixed a typo in Pet shop multisell by Tavo22.
- Updating all java quests and htmls to match filename as Quest Name
* Since now on please quit using qn variable use the Questname.class.getSimpleName() instead.
* Also updated Quest 00453 Not Strong Enough to match our new Standard.
NOTE: Please make sure you run the update sql query!
- Formatting the following sql files:
* droplist (I was using god names sorry )
* npc
* npc_elementals
* npcaidata
* npcskills
* spawnlist
- The rest quest html update from [9036]
And little source format
- Tables now will be optimized during DB upgrade.
- Fix for ticket #5340.
- Updating external quest states (more from [9036]) Reported by: jurchiks
- DP-Part for [L5544]
- DP-Part for [L5545]
- Restoring reverted changes by mistake.
- "Possessor of a Precious Soul" quests ported to Java and Updated to H5. The Noblesse quest series has been reworked and made easier to complete:
* Possessor of a Precious Soul - 1:
* The acquisition rate of the Malruk Succubus Claw and Scarlet Moss items has increased.
* Monsters that give you Scarlet Moss were changed. Before (Splinter Stakato Drone) Now (Taik Orc Supply Leader - Cemetery)
* The request from the Head Blacksmith in the Town of Goddard, Noel, has been removed and is no longer available.
* Possessor of a Precious Soul - 3:
* The acquisition rate of the Ring of the Goddess: Waterbinder and the Necklace of the Goddess: Evergreen has doubled.
* The process of obtaining the Rain Song Staff of the Goddess has changed as follows:
* Method 1: Obtain the Rain Song Staff of the Goddess through Barakiel, the Flame of Splendor raid boss
* Method 2: Hunt Wailing of Splendor, Fang of Splendor, Crown of Splendor, and Shout of Splendor monsters to collect 100 Fragments of Rain Song Staff of the Goddess.
- Minor fixes for [9045]
* Added missing credits for ''mjaniko'' in Q00242.
* Added Social Action missing in Q00247.
* Fix for Barakiel in Q00246, also fixed retail typo in Q00247. Reported by: jurchiks
- Updating more htmls/scripts for the quest name changes from [9036]
* Reported by: digunan, Konstantinos, jurchiks
- Updated GranBoss/RaidBoss spawnlist tables, now using REPLACE for specific columns, also added some missing SQL updates.
- Missing Visual Skill Effect in Q00242. Patch by: joxit
- Replacing some HTML entities.
- Fix for players stuck at Frintezza's room after killing the monsters.
* Fix for #5316 and #4972.
* Slightly different approach than [8425].
* [[Ссылки могут видеть только зарегистрированные пользователи. ] Report at forums].
- Quest-related fixes:
- Finding the Lost Soldiers (452)
- making a quest retail like and fixing part of the logic.
- Patch by: Zoey76
- Review by: Adry_85
- Truth Beyond the Gate (636)
- Through the Gate Once More (637)
- How to Oppose Evil (692)
- Journey to Gracia (10267)
- Light Fragment (10272)
- Collecting in the Air (10274)
- some improvements and cleanup
- Other missing SQL Update (to remove some more old RaidBosses), also reverted [9048] to use "INSERT IGNORE" again.
- DP-Part for [L5555]
- Unardcoding instance of Territory Managers:
* Using retail htmls.
* Removed all the duplicated htmls, same way as retail does, we send Gludio's Npc htmls.
* Added all retail conditions to become noblesse.
* Inspired by malyelfik's work.
* Now noblesse quest are completed and related items are removed.
* Subclass quest is completed, depending if player's race is Kamael or not.
* If the player is under level 40 or hasn't completed the second class transfer, the Territory Manager will send a different html.
* Added level 75 missing check.
* Reworked the way item Ids and territory Ids are generated, bypass won't be exploited.
* Implementing AbstractNpcAI by UnAfraid and me.
* Sets a new standard to make NPC AIs, outside the core.
* Extends L2Script, you can use Listeners!
* Keeps the script and the htmls together, easy to modify and easy to disable/enable.
* Features removed in upcoming versions, could be retained as L2J customs.
- Retail HTML display for quest list limit.
- DP-Part for [L5558]
- Minor typo fix for Enchant of Destruction maximum enchant limit.
- HTML foreign characters replace:
* ? -> ' Accent mark to apostrophe, inspired by malyelfik's old contribution.
* … -> ... Ellipsis to three normal dots, suggested by jurchiks.
- HTML corrections and minor fixes for Possessor of a Precious Soul #3 and #4.
- Quest in Java:
* Help the Uncle! (42)
* Help the Sister! (43)
* Help the Son! (44)
* Pavel the Giant (121)
* Ominous News (122)
* I'm the Only One You Can Trust (240)
- Fixed Enchant Time for '''Chant of Protection''' and '''Divine Protection'''.
- DP-Part for [L5562]
- Little typo fix after [9063].
* Reported by: jurchiks
- Improved quest '''Secret Mission'''.
- Missing HTM for quest '''Secret Mission'''.
- Removed useless code from '''Prominence'''.
- Little typo fix and some improvements for quest '''Willie's Special Bait'''.
- Improved quest '''Fade to Black'''.
- Improved "Special Bait" quests.
[Ссылки могут видеть только зарегистрированные пользователи. ]
[Ссылки могут видеть только зарегистрированные пользователи. ]
ошибка. database_installer.bat
на компе MysQl 5.5
помогите в чём трабл?
исходный код батника:
Код:
@echo off
REM ##############################################
REM ## L2JDP Database Installer - (by DrLecter) ##
REM ##############################################
REM ## Interactive script setup - (by TanelTM) ##
REM ##############################################
REM Copyright (C) 2012 L2J DataPack
REM This program is free software; you can redistribute it and/or modify
REM it under the terms of the GNU General Public License as published by
REM the Free Software Foundation; either version 3 of the License, or (at
REM your option) any later version.
REM
REM This program is distributed in the hope that it will be useful, but
REM WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
REM or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License
REM for more details.
REM
REM You should have received a copy of the GNU General Public License along
REM with this program; if not, write to the Free Software Foundation, Inc.,
REM 675 Mass Ave, Cambridge, MA 02139, USA. Or contact the Official L2J
REM DataPack Project at http://www.l2jdp.com, http://www.l2jdp.com/forum or
REM #l2j @ irc://irc.freenode.net
set config_file=vars.txt
set config_version=0
set workdir="%cd%"
set full=0
set stage=0
set logging=0
set upgrade_mode=0
set backup=.
set logdir=.
set safe_mode=1
set cmode=c
set fresh_setup=0
:loadconfig
cls
title L2JDP Installer - Reading Configuration from File...
if not exist %config_file% goto configure
ren %config_file% vars.bat
call vars.bat
ren vars.bat %config_file%
call :colors 17
if /i %config_version% == 2 goto ls_backup
set upgrade_mode=2
echo It seems to be the first time you run this version of
echo database_installer but I found a settings file already.
echo I'll hopefully ask this questions just once.
echo.
echo Configuration upgrade options:
echo.
echo (1) Import and continue: I'll read your old settings and
echo continue execution, but since no new settings will be
echo saved, you'll see this menu again next time.
echo.
echo (2) Import and configure: This tool has some new available
echo options, you choose the values that fit your needs
echo using former settings as a base.
echo.
echo (3) Ignose stored settings: I'll let you configure me
echo with a fresh set of default values as a base.
echo.
echo (4) View saved settings: See the contents of the config
echo file.
echo.
echo (5) Quit: Did you came here by mistake?
echo.
set /P upgrade_mode="Type a number, press Enter (default is '%upgrade_mode%'): "
if %upgrade_mode%==1 goto ls_backup
if %upgrade_mode%==2 goto configure
if %upgrade_mode%==3 goto configure
if %upgrade_mode%==4 (cls&type %config_file%&pause&goto loadconfig)
if %upgrade_mode%==5 goto :eof
goto loadconfig
:colors
if /i "%cmode%"=="n" (
if not "%1"=="17" ( color F ) else ( color )
) else ( color %1 )
goto :eof
:configure
cls
call :colors 17
title L2JDP Installer - Setup
set config_version=2
if NOT %upgrade_mode% == 2 (
set fresh_setup=1
set mysqlBinPath=%ProgramFiles%\MySQL\MySQL Server 5.5\bin
set lsuser=root
set lspass=
set lsdb=l2jls
set lshost=localhost
set cbuser=root
set cbpass=
set cbdb=l2jcs
set cbhost=localhost
set gsuser=root
set gspass=
set gsdb=l2jgs
set gshost=localhost
set cmode=c
set backup=.
set logdir=.
)
set mysqlPath=%mysqlBinPath%\mysql.exe
echo New settings will be created for this tool to run in
echo your computer, so I need to ask you some questions.
echo.
echo 1-MySql Binaries
echo --------------------
echo In order to perform my tasks, I need the path for commands
echo such as 'mysql' and 'mysqldump'. Both executables are
echo usually stored in the same place.
echo.
if "%mysqlBinPath%" == "" (
set mysqlBinPath=use path
echo I can't determine if the binaries are available with your
echo default settings.
) else (
echo I can try to find out if the current setting actually works...
echo.
echo %mysqlPath%
)
if not "%mysqlBinPath%" == "use path" call :binaryfind
echo.
path|find "MySQL">NUL
if %errorlevel% == 0 (
echo I found MySQL is in your PATH, this will be used by default.
echo If you want to use something different, change 'use path' for
echo something else.
set mysqlBinPath=use path
) else (
echo Look, I can't find "MYSQL" in your PATH environment variable.
echo It would be good if you go and find out where "mysql.exe" and
echo "mysqldump.exe" are.
echo.
echo If you have no idea about the meaning of words such as MYSQL
echo or PATH, you'd better close this window, and consider googling
echo and reading about it. Setup and host an L2J server requires a
echo minimum of technical skills.
)
echo.
echo Write the path to your MySQL binaries (no trailing slash needed):
set /P mysqlBinPath="(default %mysqlBinPath%): "
cls
echo.
echo 2-Login Server settings
echo -----------------------
echo I order to connect to the MySQL Server, you should
echo specify the Login Server DataBase parameters here.
echo.
set /P lsuser="MySQL Username (default is '%lsuser%'): "
set /P lspass="Password (default is '%lspass%'): "
set /P lsdb="Database (default is '%lsdb%'): "
set /P lshost="Host (default is '%lshost%'): "
echo.
cls
echo.
echo 3-Community Server settings
echo ---------------------------
echo I order to connect to the MySQL Server, you should
echo specify the Community Server DataBase parameters here.
echo.
set /P cbuser="MySQL Username (default is '%cbuser%'): "
set /P cbpass="Password (default is '%cbpass%'): "
set /P cbdb="Database (default is '%cbdb%'): "
set /P cbhost="Host (default is '%cbhost%'): "
echo.
cls
echo.
echo 4-Game Server settings
echo ----------------------
echo I order to connect to the MySQL Server, you should
echo specify the Game Server DataBase parameters here.
echo.
set /P gsuser="User (default is '%gsuser%'): "
set /P gspass="Pass (default is '%gspass%'): "
set /P gsdb="Database (default is '%gsdb%'): "
set /P gshost="Host (default is '%gshost%'): "
echo.
cls
echo.
echo 5-Misc. settings
echo --------------------
set /P cmode="Color mode (c)olor or (n)on-color, default %cmode% : "
set /P backup="Path for your backups (default '%backup%'): "
set /P logdir="Path for your logs (default '%logdir%'): "
:safe1
set safemode=y
set /P safemode="Debugging messages and increase verbosity a lil bit (y/n, default '%safemode%'): "
if /i %safemode%==y (set safe_mode=1&goto safe2)
if /i %safemode%==n (set safe_mode=0&goto safe2)
goto safe1
:safe2
cls
echo.
if "%mysqlBinPath%" == "use path" (
set mysqlBinPath=
set mysqldumpPath=mysqldump
set mysqlPath=mysql
) else (
set mysqldumpPath=%mysqlBinPath%\mysqldump.exe
set mysqlPath=%mysqlBinPath%\mysql.exe
)
echo @echo off > %config_file%
echo set config_version=%config_version% >> %config_file%
echo set cmode=%cmode%>> %config_file%
echo set safe_mode=%safe_mode% >> %config_file%
echo set mysqlPath=%mysqlPath%>> %config_file%
echo set mysqlBinPath=%mysqlBinPath%>> %config_file%
echo set mysqldumpPath=%mysqldumpPath%>> %config_file%
echo set lsuser=%lsuser%>> %config_file%
echo set lspass=%lspass%>> %config_file%
echo set lsdb=%lsdb%>> %config_file%
echo set lshost=%lshost% >> %config_file%
echo set cbuser=%cbuser%>> %config_file%
echo set cbpass=%cbpass%>> %config_file%
echo set cbdb=%cbdb%>> %config_file%
echo set cbhost=%cbhost% >> %config_file%
echo set gsuser=%gsuser%>> %config_file%
echo set gspass=%gspass%>> %config_file%
echo set gsdb=%gsdb%>> %config_file%
echo set gshost=%gshost%>> %config_file%
echo set logdir=%logdir%>> %config_file%
echo set backup=%backup%>> %config_file%
echo.
echo Script setup complete, your settings were saved in the
echo '%config_file%' file. Remember: your passwords are stored
echo as clear text.
echo.
pause
goto loadconfig
:ls_backup
cls
call :colors 17
set cmdline=
set stage=1
title L2JDP Installer - Login Server DataBase Backup
echo.
echo Trying to make a backup of your Login Server DataBase.
set cmdline="%mysqldumpPath%" --add-drop-table -h %lshost% -u %lsuser% --password=%lspass% %lsdb% ^> "%backup%\ls_backup.sql" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto ls_db_ok
:ls_err1
cls
set lsdbprompt=y
call :colors 47
title L2JDP Installer - Login Server DataBase Backup ERROR!
echo.
echo Backup attempt failed! A possible reason for this to
echo happen, is that your DB doesn't exist yet. I could
echo try to create %lsdb% for you, or maybe you prefer to
echo contunue with the Community Server part of this tool.
echo.
echo ATTEMPT TO CREATE LOGINSERVER DATABASE:
echo.
echo (y) Yes
echo.
echo (n) No
echo.
echo (r) Reconfigure
echo.
echo (q) Quit
echo.
set /p lsdbprompt=Choose (default yes):
if /i %lsdbprompt%==y goto ls_db_create
if /i %lsdbprompt%==n goto cs_backup
if /i %lsdbprompt%==r goto configure
if /i %lsdbprompt%==q goto end
goto ls_err1
:ls_db_create
cls
call :colors 17
set cmdline=
set stage=2
title L2JDP Installer - Login Server DataBase Creation
echo.
echo Trying to create a Login Server DataBase.
set cmdline="%mysqlPath%" -h %lshost% -u %lsuser% --password=%lspass% -e "CREATE DATABASE %lsdb%" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto ls_db_ok
if %safe_mode% == 1 goto omfg
:ls_err2
cls
set omfgprompt=q
call :colors 47
title L2JDP Installer - Login Server DataBase Creation ERROR!
echo.
echo An error occured while trying to create a database for
echo your login server.
echo.
echo Possible reasons:
echo 1-You provided innacurate info , check user, password, etc.
echo 2-User %lsuser% don't have enough privileges for
echo database creation. Check your MySQL privileges.
echo 3-Database exists already...?
echo.
echo Unless you're sure that the pending actions of this tool
echo could work, i'd suggest you to look for correct values
echo and try this script again later.
echo.
echo (c) Continue running
echo.
echo (r) Reconfigure
echo.
echo (q) Quit now
echo.
set /p omfgprompt=Choose (default quit):
if /i %omfgprompt%==c goto cs_backup
if /i %omfgprompt%==r goto configure
if /i %omfgprompt%==q goto end
goto ls_err2
:ls_db_ok
cls
set loginprompt=u
call :colors 17
title L2JDP Installer - Login Server DataBase WARNING!
echo.
echo LOGINSERVER DATABASE install type:
echo.
echo (f) Full: WARNING! I'll destroy ALL of your existing login
echo data.
echo.
echo (u) Upgrade: I'll do my best to preserve all login data.
echo.
echo (s) Skip: I'll take you to the communityserver database
echo installation and upgrade options.
echo.
echo (r) Reconfigure: You'll be able to redefine MySQL path,
echo user and database information and start over with
echo those fresh values.
echo.
echo (q) Quit
echo.
set /p loginprompt=Choose (default upgrade):
if /i %loginprompt%==f goto ls_cleanup
if /i %loginprompt%==u goto ls_upgrade
if /i %loginprompt%==s goto cs_backup
if /i %loginprompt%==r goto configure
if /i %loginprompt%==q goto end
goto ls_db_ok
:ls_cleanup
call :colors 17
set cmdline=
title L2JDP Installer - Login Server DataBase Full Install
echo.
echo Deleting Login Server tables for new content.
set cmdline="%mysqlPath%" -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% ^< ls_cleanup.sql 2^> NUL
%cmdline%
if not %ERRORLEVEL% == 0 goto omfg
set full=1
echo.
echo Login Server tables has been deleted.
goto ls_install
:ls_upgrade
cls
echo.
echo Upgrading structure of Login Server tables.
echo.
echo @echo off> temp.bat
if exist ls_errors.log del ls_errors.log
for %%i in (..\sql\login\updates\*.sql) do echo "%mysqlPath%" -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% --force ^< %%i 2^>^> ls_errors.log >> temp.bat
call temp.bat> nul
del temp.bat
move ls_errors.log %workdir%
goto ls_install
:ls_install
cls
set cmdline=
if %full% == 1 (
title L2JDP Installer - Login Server DataBase Installing...
echo.
echo Installing new Login Server content.
echo.
) else (
title L2JDP Installer - Login Server DataBase Upgrading...
echo.
echo Upgrading Login Server content.
echo.
)
if %logging% == 0 set output=NUL
set dest=ls
for %%i in (..\sql\login\*.sql) do call :dump %%i
echo done...
echo.
goto cs_backup
:cs_backup
cls
call :colors 17
set cmdline=
set stage=3
title L2JDP Installer - Community Server DataBase Backup
echo.
echo Trying to make a backup of your Comunity Server DataBase.
set cmdline="%mysqldumpPath%" --add-drop-table -h %cbhost% -u %cbuser% --password=%cbpass% %cbdb% ^> "%backup%\cs_backup.sql" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto cs_db_ok
:cs_err1
cls
set cbdbprompt=y
call :colors 47
title L2JDP Installer - Community Server DataBase Backup ERROR!
echo.
echo Backup attempt failed! A possible reason for this to
echo happen, is that your DB doesn't exist yet. I could
echo try to create %cbdb% for you, or maybe you prefer to
echo continue with the GameServer part of this tool.
echo.
echo ATTEMPT TO CREATE COMMUNITY SERVER DATABASE:
echo.
echo (y) Yes
echo.
echo (n) No
echo.
echo (r) Reconfigure
echo.
echo (q) Quit
echo.
set /p cbdbprompt=Choose (default yes):
if /i %cbdbprompt%==y goto cs_db_create
if /i %cbdbprompt%==n goto gs_backup
if /i %cbdbprompt%==r goto configure
if /i %cbdbprompt%==q goto end
goto cs_err1
:cs_db_create
cls
call :colors 17
set cmdline=
set stage=4
title L2JDP Installer - Community Server DataBase Creation
echo.
echo Trying to create a Community Server DataBase...
set cmdline="%mysqlPath%" -h %cbhost% -u %cbuser% --password=%cbpass% -e "CREATE DATABASE %cbdb%" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto cs_db_ok
if %safe_mode% == 1 goto omfg
:cs_err2
cls
set omfgprompt=q
call :colors 47
title L2JDP Installer - Community Server DataBase Creation ERROR!
echo.
echo An error occured while trying to create a database for
echo your Community Server.
echo.
echo Possible reasons:
echo 1-You provided innacurate info , check user, password, etc.
echo 2-User %cbuser% don't have enough privileges for
echo database creation. Check your MySQL privileges.
echo 3-Database exists already...?
echo.
echo Unless you're sure that the pending actions of this tool
echo could work, i'd suggest you to look for correct values
echo and try this script again later.
echo.
echo (c) Continue running
echo.
echo (r) Reconfigure
echo.
echo (q) Quit now
echo.
set /p omfgprompt=Choose (default quit):
if /i %omfgprompt%==c goto gs_backup
if /i %omfgprompt%==r goto configure
if /i %omfgprompt%==q goto end
goto cs_err2
:cs_db_ok
cls
set communityprompt=u
call :colors 17
title L2JDP Installer - Community Server DataBase WARNING!
echo.
echo COMMUNITY SERVER DATABASE install type:
echo.
echo (f) Full: WARNING! I'll destroy ALL of your existing community
echo data (i really mean it: mail, forum, memo.. ALL)
echo.
echo (u) Upgrade: I'll do my best to preserve all of your community
echo data.
echo.
echo (s) Skip: I'll take you to the gameserver database
echo installation and upgrade options.
echo.
echo (r) Reconfigure: You'll be able to redefine MySQL path,
echo user and database information and start over with
echo those fresh values.
echo.
echo (q) Quit
echo.
set /p communityprompt=Choose (default upgrade):
if /i %communityprompt%==f goto cs_cleanup
if /i %communityprompt%==u goto cs_upgrade
if /i %communityprompt%==s goto gs_backup
if /i %communityprompt%==r goto configure
if /i %communityprompt%==q goto end
goto cs_db_ok
:cs_cleanup
call :colors 17
set cmdline=
title L2JDP Installer - Community Server DataBase Full Install
echo.
echo Deleting Community Server tables for new content.
set cmdline="%mysqlPath%" -h %cbhost% -u %cbuser% --password=%cbpass% -D %cbdb% ^< cs_cleanup.sql 2^> NUL
%cmdline%
if not %ERRORLEVEL% == 0 goto omfg
set full=1
echo.
echo Community Server tables has been deleted.
goto cs_install
:cs_upgrade
cls
echo.
echo Upgrading structure of Community Server tables.
echo.
echo @echo off> temp.bat
if exist cs_errors.log del cs_errors.log
for %%i in (..\sql\community\updates\*.sql) do echo "%mysqlPath%" -h %cbhost% -u %cbuser% --password=%cbpass% -D %cbdb% --force ^< %%i 2^>^> cs_errors.log >> temp.bat
call temp.bat> nul
del temp.bat
move cs_errors.log %workdir%
goto cs_install
:cs_install
cls
set cmdline=
if %full% == 1 (
title L2JDP Installer - Community Server DataBase Installing...
echo.
echo Installing new Community Server content.
echo.
) else (
title L2JDP Installer - Community Server DataBase Upgrading...
echo.
echo Upgrading Community Server content.
echo.
)
if %logging% == 0 set output=NUL
set dest=cb
for %%i in (..\sql\community\*.sql) do call :dump %%i
echo done...
echo.
goto gs_backup
:gs_backup
cls
call :colors 17
set cmdline=
set stage=5
title L2JDP Installer - Game Server DataBase Backup
echo.
echo Trying to make a backup of your Game Server DataBase.
set cmdline="%mysqldumpPath%" --add-drop-table -h %gshost% -u %gsuser% --password=%gspass% %gsdb% ^> "%backup%\gs_backup.sql" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto gs_db_ok
:gs_err1
cls
set gsdbprompt=y
call :colors 47
title L2JDP Installer - Game Server DataBase Backup ERROR!
echo.
echo Backup attempt failed! A possible reason for this to
echo happen, is that your DB doesn't exist yet. I could
echo try to create %gsdb% for you, but maybe you prefer to
echo continue with last part of the script.
echo.
echo ATTEMPT TO CREATE GAME SERVER DATABASE?
echo.
echo (y) Yes
echo.
echo (n) No
echo.
echo (r) Reconfigure
echo.
echo (q) Quit
echo.
set /p gsdbprompt=Choose (default yes):
if /i %gsdbprompt%==y goto gs_db_create
if /i %gsdbprompt%==n goto eof
if /i %gsdbprompt%==r goto configure
if /i %gsdbprompt%==q goto end
goto gs_err1
:gs_db_create
cls
call :colors 17
set stage=6
set cmdline=
title L2JDP Installer - Game Server DataBase Creation
echo.
echo Trying to create a Game Server DataBase...
set cmdline="%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -e "CREATE DATABASE %gsdb%" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto gs_db_ok
if %safe_mode% == 1 goto omfg
:gs_err2
cls
set omfgprompt=q
call :colors 47
title L2JDP Installer - Game Server DataBase Creation ERROR!
echo.
echo An error occured while trying to create a database for
echo your Game Server.
echo.
echo Possible reasons:
echo 1-You provided innacurate info, check username, pass, etc.
echo 2-User %gsuser% don't have enough privileges for
echo database creation.
echo 3-Database exists already...?
echo.
echo I'd suggest you to look for correct values and try this
echo script again later. But you can try to reconfigure it now.
echo.
echo (r) Reconfigure
echo.
echo (q) Quit now
echo.
set /p omfgprompt=Choose (default quit):
if /i %omfgprompt%==r goto configure
if /i %omfgprompt%==q goto end
goto gs_err2
:gs_db_ok
cls
set installtype=u
call :colors 17
title L2JDP Installer - Game Server DataBase WARNING!
echo.
echo GAME SERVER DATABASE install:
echo.
echo (f) Full: WARNING! I'll destroy ALL of your existing character
echo data (i really mean it: items, pets.. ALL)
echo.
echo (u) Upgrade: I'll do my best to preserve all of your character
echo data.
echo.
echo (s) Skip: We'll get into the last set of questions (cummulative
echo updates, custom stuff...)
echo.
echo (q) Quit
echo.
set /p installtype=Choose (default upgrade):
if /i %installtype%==f goto gs_cleanup
if /i %installtype%==u goto gs_upgrade
if /i %installtype%==s goto custom_ask
if /i %installtype%==q goto end
goto gs_db_ok
:gs_cleanup
call :colors 17
set cmdline=
title L2JDP Installer - Game Server DataBase Full Install
echo.
echo Deleting all Game Server tables for new content.
set cmdline="%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^< gs_cleanup.sql 2^> NUL
%cmdline%
if not %ERRORLEVEL% == 0 goto omfg
set full=1
echo.
echo Game Server tables has been deleted.
goto gs_install
:gs_upgrade
cls
echo.
echo Upgrading structure of Game Server tables (this could take awhile, be patient).
echo.
echo @echo off> temp.bat
if exist gs_errors.log del gs_errors.log
for %%i in (..\sql\game\updates\*.sql) do echo "%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% --force ^< %%i 2^>^> gs_errors.log >> temp.bat
call temp.bat> nul
del temp.bat
move gs_errors.log %workdir%
goto gs_install
:gs_install
cls
set cmdline=
if %full% == 1 (
title L2JDP Installer - Game Server DataBase Installing...
echo.
echo Installing new Game Server content.
echo.
) else (
title L2JDP Installer - Game Server DataBase Upgrading...
echo.
echo Upgrading Game Server content.
echo.
)
if %logging% == 0 set output=NUL
set dest=gs
for %%i in (..\sql\game\*.sql) do call :dump %%i
echo done...
echo.
goto custom_ask
:dump
set cmdline=
if /i %full% == 1 (set action=Installing) else (set action=Upgrading)
echo %action% %1>>"%output%"
echo %action% %~nx1
if "%dest%"=="ls" set cmdline="%mysqlPath%" -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% ^< %1 2^>^>"%output%"
if "%dest%"=="cb" set cmdline="%mysqlPath%" -h %cbhost% -u %cbuser% --password=%cbpass% -D %cbdb% ^< %1 2^>^>"%output%"
if "%dest%"=="gs" set cmdline="%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^< %1 2^>^>"%output%"
%cmdline%
if %logging%==0 if NOT %ERRORLEVEL%==0 call :omfg2 %1
goto :eof
:omfg2
cls
set ntpebcak=c
call :colors 47
title L2JDP Installer - Potential DataBase Issue at stage %stage%
echo.
echo Something caused an error while executing instruction :
echo %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb%
echo.
echo with file %~nx1
echo.
echo What we should do now?
echo.
echo (l) Log it: I will create a log for this file, then continue
echo with the rest of the list in non-logging mode.
echo.
echo (c) Continue: Let's pretend that nothing happened and continue with
echo the rest of the list.
echo.
echo (r) Reconfigure: Perhaps these errors were caused by a typo.
echo you can restart from scratch and redefine paths, databases
echo and user info again.
echo.
echo (q) Quit now
echo.
set /p ntpebcak=Choose (default continue):
if /i %ntpebcak%==c (call :colors 17 & goto :eof)
if /i %ntpebcak%==l (call :logginon %1 & goto :eof)
if /i %ntpebcak%==r (call :configure & exit)
if /i %ntpebcak%==q (call :end)
goto omfg2
:logginon
cls
call :colors 17
title L2JDP Installer - Game Server Logging Options turned on
set logging=1
if %full% == 1 (
set output=%logdir%\install-%~nx1.log
) else (
set output=%logdir%\upgrade-%~nx1.log
)
echo.
echo Per your request, i'll create a log file for your reading pleasure.
echo.
echo I'll call it %output%
echo.
echo If you already have such a file and would like to keep a copy.
echo go now and read it or back it up, because it's not going to be rotated
echo or anything, instead i'll just overwrite it.
echo.
pause
set cmdline="%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^<..\sql\%1 2^>^>"%output%"
date /t >"%output%"
time /t >>"%output%"
%cmdline%
echo Log file created, resuming normal operations...
call :colors 17
set logging=0
set output=NUL
goto :eof
:custom_ask
title L2JDP Installer - Custom Server Tables
cls
set cstprompt=n
echo.
echo L2J provides some "Custom Server Tables" for non-retail modifications
echo in order to avoid override the original Server Tables.
echo.
echo Remember that in order to get these additions actually working
echo you need to edit your configuration files.
echo.
set /p cstprompt=Install Custom Server Tables: (y) yes or (n) no (default no):
if /i %cstprompt%==y goto custom_install
if /i %cstprompt%==n goto mod_ask
:custom_install
cls
echo.
echo Installing Custom content.
echo @echo off> temp.bat
if exist custom_errors.log del custom_errors.log
for %%i in (..\sql\game\custom\*.sql) do echo "%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^< %%i 2^>^> custom_errors.log >> temp.bat
call temp.bat> nul
del temp.bat
move custom_errors.log %workdir%
goto mod_ask
:mod_ask
title L2JDP Installer - Mod Server Tables
cls
set cstprompt=n
echo.
echo L2J provides a basic infraestructure for some non-retail features
echo (aka L2J mods) to get enabled with a minimum of changes.
echo.
echo Some of these mods would require extra tables in order to work
echo and those tables could be created now if you wanted to.
echo.
echo Remember that in order to get these additions actually working
echo you need to edit your configuration files.
echo.
set /p cstprompt=Install Mod Server Tables: (y) yes or (n) no (default no):
if /i %cstprompt%==y goto mod_install
if /i %cstprompt%==n goto end
:mod_install
cls
echo.
echo Installing Mods content.
echo @echo off> temp.bat
if exist mods_errors.log del mods_errors.log
for %%i in (..\sql\game\mods\*.sql) do echo "%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^< %%i 2^>^> mods_errors.log >> temp.bat
call temp.bat> nul
del temp.bat
move mods_errors.log %workdir%
goto end
:omfg
set omfgprompt=q
call :colors 57
cls
title L2JDP Installer - Potential PICNIC detected at stage %stage%
echo.
echo There was some problem while executing:
echo.
echo "%cmdline%"
echo.
echo I'd suggest you to look for correct values and try this
echo script again later. But maybe you'd prefer to go on now.
if %stage% == 1 set label=ls_err1
if %stage% == 2 set label=ls_err2
if %stage% == 3 set label=cs_err1
if %stage% == 4 set label=cs_err2
if %stage% == 5 set label=gs_err1
if %stage% == 6 set label=gs_err2
echo.
echo (c) Continue running the script
echo.
echo (r) Reconfigure
echo.
echo (q) Quit now
echo.
set /p omfgprompt=Choose (default quit):
if /i %omfgprompt%==c goto %label%
if /i %omfgprompt%==r goto configure
if /i %omfgprompt%==q goto end
goto omfg
:binaryfind
if EXIST "%mysqlBinPath%" (echo Found) else (echo Not Found)
goto :eof
:end
call :colors 17
title L2JDP Installer - Script Execution Finished
cls
echo.
echo L2JDP Database Installer 2012
echo.
echo (C) 2004-2012 L2J DataPack Team
echo L2JDP Database Installer comes with ABSOLUTELY NO WARRANTY
echo This is free software, and you are welcome to redistribute it
echo under certain conditions; See the file gpl.txt for further
echo details.
echo.
echo Thanks for using our software.
echo visit http://www.l2jdp.com for more info about
echo the L2J DataPack Project.
echo.
pause
Последний раз редактировалось nachsitzen12; 25.08.2012 в 03:39.
[Ссылки могут видеть только зарегистрированные пользователи. ]
ошибка. database_installer.bat
на компе MysQl 5.5
помогите в чём трабл?
исходный код батника:
Код:
@echo off
REM ##############################################
REM ## L2JDP Database Installer - (by DrLecter) ##
REM ##############################################
REM ## Interactive script setup - (by TanelTM) ##
REM ##############################################
REM Copyright (C) 2012 L2J DataPack
REM This program is free software; you can redistribute it and/or modify
REM it under the terms of the GNU General Public License as published by
REM the Free Software Foundation; either version 3 of the License, or (at
REM your option) any later version.
REM
REM This program is distributed in the hope that it will be useful, but
REM WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
REM or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License
REM for more details.
REM
REM You should have received a copy of the GNU General Public License along
REM with this program; if not, write to the Free Software Foundation, Inc.,
REM 675 Mass Ave, Cambridge, MA 02139, USA. Or contact the Official L2J
REM DataPack Project at http://www.l2jdp.com, http://www.l2jdp.com/forum or
REM #l2j @ irc://irc.freenode.net
set config_file=vars.txt
set config_version=0
set workdir="%cd%"
set full=0
set stage=0
set logging=0
set upgrade_mode=0
set backup=.
set logdir=.
set safe_mode=1
set cmode=c
set fresh_setup=0
:loadconfig
cls
title L2JDP Installer - Reading Configuration from File...
if not exist %config_file% goto configure
ren %config_file% vars.bat
call vars.bat
ren vars.bat %config_file%
call :colors 17
if /i %config_version% == 2 goto ls_backup
set upgrade_mode=2
echo It seems to be the first time you run this version of
echo database_installer but I found a settings file already.
echo I'll hopefully ask this questions just once.
echo.
echo Configuration upgrade options:
echo.
echo (1) Import and continue: I'll read your old settings and
echo continue execution, but since no new settings will be
echo saved, you'll see this menu again next time.
echo.
echo (2) Import and configure: This tool has some new available
echo options, you choose the values that fit your needs
echo using former settings as a base.
echo.
echo (3) Ignose stored settings: I'll let you configure me
echo with a fresh set of default values as a base.
echo.
echo (4) View saved settings: See the contents of the config
echo file.
echo.
echo (5) Quit: Did you came here by mistake?
echo.
set /P upgrade_mode="Type a number, press Enter (default is '%upgrade_mode%'): "
if %upgrade_mode%==1 goto ls_backup
if %upgrade_mode%==2 goto configure
if %upgrade_mode%==3 goto configure
if %upgrade_mode%==4 (cls&type %config_file%&pause&goto loadconfig)
if %upgrade_mode%==5 goto :eof
goto loadconfig
:colors
if /i "%cmode%"=="n" (
if not "%1"=="17" ( color F ) else ( color )
) else ( color %1 )
goto :eof
:configure
cls
call :colors 17
title L2JDP Installer - Setup
set config_version=2
if NOT %upgrade_mode% == 2 (
set fresh_setup=1
set mysqlBinPath=%ProgramFiles%\MySQL\MySQL Server 5.5\bin
set lsuser=root
set lspass=
set lsdb=l2jls
set lshost=localhost
set cbuser=root
set cbpass=
set cbdb=l2jcs
set cbhost=localhost
set gsuser=root
set gspass=
set gsdb=l2jgs
set gshost=localhost
set cmode=c
set backup=.
set logdir=.
)
set mysqlPath=%mysqlBinPath%\mysql.exe
echo New settings will be created for this tool to run in
echo your computer, so I need to ask you some questions.
echo.
echo 1-MySql Binaries
echo --------------------
echo In order to perform my tasks, I need the path for commands
echo such as 'mysql' and 'mysqldump'. Both executables are
echo usually stored in the same place.
echo.
if "%mysqlBinPath%" == "" (
set mysqlBinPath=use path
echo I can't determine if the binaries are available with your
echo default settings.
) else (
echo I can try to find out if the current setting actually works...
echo.
echo %mysqlPath%
)
if not "%mysqlBinPath%" == "use path" call :binaryfind
echo.
path|find "MySQL">NUL
if %errorlevel% == 0 (
echo I found MySQL is in your PATH, this will be used by default.
echo If you want to use something different, change 'use path' for
echo something else.
set mysqlBinPath=use path
) else (
echo Look, I can't find "MYSQL" in your PATH environment variable.
echo It would be good if you go and find out where "mysql.exe" and
echo "mysqldump.exe" are.
echo.
echo If you have no idea about the meaning of words such as MYSQL
echo or PATH, you'd better close this window, and consider googling
echo and reading about it. Setup and host an L2J server requires a
echo minimum of technical skills.
)
echo.
echo Write the path to your MySQL binaries (no trailing slash needed):
set /P mysqlBinPath="(default %mysqlBinPath%): "
cls
echo.
echo 2-Login Server settings
echo -----------------------
echo I order to connect to the MySQL Server, you should
echo specify the Login Server DataBase parameters here.
echo.
set /P lsuser="MySQL Username (default is '%lsuser%'): "
set /P lspass="Password (default is '%lspass%'): "
set /P lsdb="Database (default is '%lsdb%'): "
set /P lshost="Host (default is '%lshost%'): "
echo.
cls
echo.
echo 3-Community Server settings
echo ---------------------------
echo I order to connect to the MySQL Server, you should
echo specify the Community Server DataBase parameters here.
echo.
set /P cbuser="MySQL Username (default is '%cbuser%'): "
set /P cbpass="Password (default is '%cbpass%'): "
set /P cbdb="Database (default is '%cbdb%'): "
set /P cbhost="Host (default is '%cbhost%'): "
echo.
cls
echo.
echo 4-Game Server settings
echo ----------------------
echo I order to connect to the MySQL Server, you should
echo specify the Game Server DataBase parameters here.
echo.
set /P gsuser="User (default is '%gsuser%'): "
set /P gspass="Pass (default is '%gspass%'): "
set /P gsdb="Database (default is '%gsdb%'): "
set /P gshost="Host (default is '%gshost%'): "
echo.
cls
echo.
echo 5-Misc. settings
echo --------------------
set /P cmode="Color mode (c)olor or (n)on-color, default %cmode% : "
set /P backup="Path for your backups (default '%backup%'): "
set /P logdir="Path for your logs (default '%logdir%'): "
:safe1
set safemode=y
set /P safemode="Debugging messages and increase verbosity a lil bit (y/n, default '%safemode%'): "
if /i %safemode%==y (set safe_mode=1&goto safe2)
if /i %safemode%==n (set safe_mode=0&goto safe2)
goto safe1
:safe2
cls
echo.
if "%mysqlBinPath%" == "use path" (
set mysqlBinPath=
set mysqldumpPath=mysqldump
set mysqlPath=mysql
) else (
set mysqldumpPath=%mysqlBinPath%\mysqldump.exe
set mysqlPath=%mysqlBinPath%\mysql.exe
)
echo @echo off > %config_file%
echo set config_version=%config_version% >> %config_file%
echo set cmode=%cmode%>> %config_file%
echo set safe_mode=%safe_mode% >> %config_file%
echo set mysqlPath=%mysqlPath%>> %config_file%
echo set mysqlBinPath=%mysqlBinPath%>> %config_file%
echo set mysqldumpPath=%mysqldumpPath%>> %config_file%
echo set lsuser=%lsuser%>> %config_file%
echo set lspass=%lspass%>> %config_file%
echo set lsdb=%lsdb%>> %config_file%
echo set lshost=%lshost% >> %config_file%
echo set cbuser=%cbuser%>> %config_file%
echo set cbpass=%cbpass%>> %config_file%
echo set cbdb=%cbdb%>> %config_file%
echo set cbhost=%cbhost% >> %config_file%
echo set gsuser=%gsuser%>> %config_file%
echo set gspass=%gspass%>> %config_file%
echo set gsdb=%gsdb%>> %config_file%
echo set gshost=%gshost%>> %config_file%
echo set logdir=%logdir%>> %config_file%
echo set backup=%backup%>> %config_file%
echo.
echo Script setup complete, your settings were saved in the
echo '%config_file%' file. Remember: your passwords are stored
echo as clear text.
echo.
pause
goto loadconfig
:ls_backup
cls
call :colors 17
set cmdline=
set stage=1
title L2JDP Installer - Login Server DataBase Backup
echo.
echo Trying to make a backup of your Login Server DataBase.
set cmdline="%mysqldumpPath%" --add-drop-table -h %lshost% -u %lsuser% --password=%lspass% %lsdb% ^> "%backup%\ls_backup.sql" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto ls_db_ok
:ls_err1
cls
set lsdbprompt=y
call :colors 47
title L2JDP Installer - Login Server DataBase Backup ERROR!
echo.
echo Backup attempt failed! A possible reason for this to
echo happen, is that your DB doesn't exist yet. I could
echo try to create %lsdb% for you, or maybe you prefer to
echo contunue with the Community Server part of this tool.
echo.
echo ATTEMPT TO CREATE LOGINSERVER DATABASE:
echo.
echo (y) Yes
echo.
echo (n) No
echo.
echo (r) Reconfigure
echo.
echo (q) Quit
echo.
set /p lsdbprompt=Choose (default yes):
if /i %lsdbprompt%==y goto ls_db_create
if /i %lsdbprompt%==n goto cs_backup
if /i %lsdbprompt%==r goto configure
if /i %lsdbprompt%==q goto end
goto ls_err1
:ls_db_create
cls
call :colors 17
set cmdline=
set stage=2
title L2JDP Installer - Login Server DataBase Creation
echo.
echo Trying to create a Login Server DataBase.
set cmdline="%mysqlPath%" -h %lshost% -u %lsuser% --password=%lspass% -e "CREATE DATABASE %lsdb%" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto ls_db_ok
if %safe_mode% == 1 goto omfg
:ls_err2
cls
set omfgprompt=q
call :colors 47
title L2JDP Installer - Login Server DataBase Creation ERROR!
echo.
echo An error occured while trying to create a database for
echo your login server.
echo.
echo Possible reasons:
echo 1-You provided innacurate info , check user, password, etc.
echo 2-User %lsuser% don't have enough privileges for
echo database creation. Check your MySQL privileges.
echo 3-Database exists already...?
echo.
echo Unless you're sure that the pending actions of this tool
echo could work, i'd suggest you to look for correct values
echo and try this script again later.
echo.
echo (c) Continue running
echo.
echo (r) Reconfigure
echo.
echo (q) Quit now
echo.
set /p omfgprompt=Choose (default quit):
if /i %omfgprompt%==c goto cs_backup
if /i %omfgprompt%==r goto configure
if /i %omfgprompt%==q goto end
goto ls_err2
:ls_db_ok
cls
set loginprompt=u
call :colors 17
title L2JDP Installer - Login Server DataBase WARNING!
echo.
echo LOGINSERVER DATABASE install type:
echo.
echo (f) Full: WARNING! I'll destroy ALL of your existing login
echo data.
echo.
echo (u) Upgrade: I'll do my best to preserve all login data.
echo.
echo (s) Skip: I'll take you to the communityserver database
echo installation and upgrade options.
echo.
echo (r) Reconfigure: You'll be able to redefine MySQL path,
echo user and database information and start over with
echo those fresh values.
echo.
echo (q) Quit
echo.
set /p loginprompt=Choose (default upgrade):
if /i %loginprompt%==f goto ls_cleanup
if /i %loginprompt%==u goto ls_upgrade
if /i %loginprompt%==s goto cs_backup
if /i %loginprompt%==r goto configure
if /i %loginprompt%==q goto end
goto ls_db_ok
:ls_cleanup
call :colors 17
set cmdline=
title L2JDP Installer - Login Server DataBase Full Install
echo.
echo Deleting Login Server tables for new content.
set cmdline="%mysqlPath%" -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% ^< ls_cleanup.sql 2^> NUL
%cmdline%
if not %ERRORLEVEL% == 0 goto omfg
set full=1
echo.
echo Login Server tables has been deleted.
goto ls_install
:ls_upgrade
cls
echo.
echo Upgrading structure of Login Server tables.
echo.
echo @echo off> temp.bat
if exist ls_errors.log del ls_errors.log
for %%i in (..\sql\login\updates\*.sql) do echo "%mysqlPath%" -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% --force ^< %%i 2^>^> ls_errors.log >> temp.bat
call temp.bat> nul
del temp.bat
move ls_errors.log %workdir%
goto ls_install
:ls_install
cls
set cmdline=
if %full% == 1 (
title L2JDP Installer - Login Server DataBase Installing...
echo.
echo Installing new Login Server content.
echo.
) else (
title L2JDP Installer - Login Server DataBase Upgrading...
echo.
echo Upgrading Login Server content.
echo.
)
if %logging% == 0 set output=NUL
set dest=ls
for %%i in (..\sql\login\*.sql) do call :dump %%i
echo done...
echo.
goto cs_backup
:cs_backup
cls
call :colors 17
set cmdline=
set stage=3
title L2JDP Installer - Community Server DataBase Backup
echo.
echo Trying to make a backup of your Comunity Server DataBase.
set cmdline="%mysqldumpPath%" --add-drop-table -h %cbhost% -u %cbuser% --password=%cbpass% %cbdb% ^> "%backup%\cs_backup.sql" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto cs_db_ok
:cs_err1
cls
set cbdbprompt=y
call :colors 47
title L2JDP Installer - Community Server DataBase Backup ERROR!
echo.
echo Backup attempt failed! A possible reason for this to
echo happen, is that your DB doesn't exist yet. I could
echo try to create %cbdb% for you, or maybe you prefer to
echo continue with the GameServer part of this tool.
echo.
echo ATTEMPT TO CREATE COMMUNITY SERVER DATABASE:
echo.
echo (y) Yes
echo.
echo (n) No
echo.
echo (r) Reconfigure
echo.
echo (q) Quit
echo.
set /p cbdbprompt=Choose (default yes):
if /i %cbdbprompt%==y goto cs_db_create
if /i %cbdbprompt%==n goto gs_backup
if /i %cbdbprompt%==r goto configure
if /i %cbdbprompt%==q goto end
goto cs_err1
:cs_db_create
cls
call :colors 17
set cmdline=
set stage=4
title L2JDP Installer - Community Server DataBase Creation
echo.
echo Trying to create a Community Server DataBase...
set cmdline="%mysqlPath%" -h %cbhost% -u %cbuser% --password=%cbpass% -e "CREATE DATABASE %cbdb%" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto cs_db_ok
if %safe_mode% == 1 goto omfg
:cs_err2
cls
set omfgprompt=q
call :colors 47
title L2JDP Installer - Community Server DataBase Creation ERROR!
echo.
echo An error occured while trying to create a database for
echo your Community Server.
echo.
echo Possible reasons:
echo 1-You provided innacurate info , check user, password, etc.
echo 2-User %cbuser% don't have enough privileges for
echo database creation. Check your MySQL privileges.
echo 3-Database exists already...?
echo.
echo Unless you're sure that the pending actions of this tool
echo could work, i'd suggest you to look for correct values
echo and try this script again later.
echo.
echo (c) Continue running
echo.
echo (r) Reconfigure
echo.
echo (q) Quit now
echo.
set /p omfgprompt=Choose (default quit):
if /i %omfgprompt%==c goto gs_backup
if /i %omfgprompt%==r goto configure
if /i %omfgprompt%==q goto end
goto cs_err2
:cs_db_ok
cls
set communityprompt=u
call :colors 17
title L2JDP Installer - Community Server DataBase WARNING!
echo.
echo COMMUNITY SERVER DATABASE install type:
echo.
echo (f) Full: WARNING! I'll destroy ALL of your existing community
echo data (i really mean it: mail, forum, memo.. ALL)
echo.
echo (u) Upgrade: I'll do my best to preserve all of your community
echo data.
echo.
echo (s) Skip: I'll take you to the gameserver database
echo installation and upgrade options.
echo.
echo (r) Reconfigure: You'll be able to redefine MySQL path,
echo user and database information and start over with
echo those fresh values.
echo.
echo (q) Quit
echo.
set /p communityprompt=Choose (default upgrade):
if /i %communityprompt%==f goto cs_cleanup
if /i %communityprompt%==u goto cs_upgrade
if /i %communityprompt%==s goto gs_backup
if /i %communityprompt%==r goto configure
if /i %communityprompt%==q goto end
goto cs_db_ok
:cs_cleanup
call :colors 17
set cmdline=
title L2JDP Installer - Community Server DataBase Full Install
echo.
echo Deleting Community Server tables for new content.
set cmdline="%mysqlPath%" -h %cbhost% -u %cbuser% --password=%cbpass% -D %cbdb% ^< cs_cleanup.sql 2^> NUL
%cmdline%
if not %ERRORLEVEL% == 0 goto omfg
set full=1
echo.
echo Community Server tables has been deleted.
goto cs_install
:cs_upgrade
cls
echo.
echo Upgrading structure of Community Server tables.
echo.
echo @echo off> temp.bat
if exist cs_errors.log del cs_errors.log
for %%i in (..\sql\community\updates\*.sql) do echo "%mysqlPath%" -h %cbhost% -u %cbuser% --password=%cbpass% -D %cbdb% --force ^< %%i 2^>^> cs_errors.log >> temp.bat
call temp.bat> nul
del temp.bat
move cs_errors.log %workdir%
goto cs_install
:cs_install
cls
set cmdline=
if %full% == 1 (
title L2JDP Installer - Community Server DataBase Installing...
echo.
echo Installing new Community Server content.
echo.
) else (
title L2JDP Installer - Community Server DataBase Upgrading...
echo.
echo Upgrading Community Server content.
echo.
)
if %logging% == 0 set output=NUL
set dest=cb
for %%i in (..\sql\community\*.sql) do call :dump %%i
echo done...
echo.
goto gs_backup
:gs_backup
cls
call :colors 17
set cmdline=
set stage=5
title L2JDP Installer - Game Server DataBase Backup
echo.
echo Trying to make a backup of your Game Server DataBase.
set cmdline="%mysqldumpPath%" --add-drop-table -h %gshost% -u %gsuser% --password=%gspass% %gsdb% ^> "%backup%\gs_backup.sql" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto gs_db_ok
:gs_err1
cls
set gsdbprompt=y
call :colors 47
title L2JDP Installer - Game Server DataBase Backup ERROR!
echo.
echo Backup attempt failed! A possible reason for this to
echo happen, is that your DB doesn't exist yet. I could
echo try to create %gsdb% for you, but maybe you prefer to
echo continue with last part of the script.
echo.
echo ATTEMPT TO CREATE GAME SERVER DATABASE?
echo.
echo (y) Yes
echo.
echo (n) No
echo.
echo (r) Reconfigure
echo.
echo (q) Quit
echo.
set /p gsdbprompt=Choose (default yes):
if /i %gsdbprompt%==y goto gs_db_create
if /i %gsdbprompt%==n goto eof
if /i %gsdbprompt%==r goto configure
if /i %gsdbprompt%==q goto end
goto gs_err1
:gs_db_create
cls
call :colors 17
set stage=6
set cmdline=
title L2JDP Installer - Game Server DataBase Creation
echo.
echo Trying to create a Game Server DataBase...
set cmdline="%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -e "CREATE DATABASE %gsdb%" 2^> NUL
%cmdline%
if %ERRORLEVEL% == 0 goto gs_db_ok
if %safe_mode% == 1 goto omfg
:gs_err2
cls
set omfgprompt=q
call :colors 47
title L2JDP Installer - Game Server DataBase Creation ERROR!
echo.
echo An error occured while trying to create a database for
echo your Game Server.
echo.
echo Possible reasons:
echo 1-You provided innacurate info, check username, pass, etc.
echo 2-User %gsuser% don't have enough privileges for
echo database creation.
echo 3-Database exists already...?
echo.
echo I'd suggest you to look for correct values and try this
echo script again later. But you can try to reconfigure it now.
echo.
echo (r) Reconfigure
echo.
echo (q) Quit now
echo.
set /p omfgprompt=Choose (default quit):
if /i %omfgprompt%==r goto configure
if /i %omfgprompt%==q goto end
goto gs_err2
:gs_db_ok
cls
set installtype=u
call :colors 17
title L2JDP Installer - Game Server DataBase WARNING!
echo.
echo GAME SERVER DATABASE install:
echo.
echo (f) Full: WARNING! I'll destroy ALL of your existing character
echo data (i really mean it: items, pets.. ALL)
echo.
echo (u) Upgrade: I'll do my best to preserve all of your character
echo data.
echo.
echo (s) Skip: We'll get into the last set of questions (cummulative
echo updates, custom stuff...)
echo.
echo (q) Quit
echo.
set /p installtype=Choose (default upgrade):
if /i %installtype%==f goto gs_cleanup
if /i %installtype%==u goto gs_upgrade
if /i %installtype%==s goto custom_ask
if /i %installtype%==q goto end
goto gs_db_ok
:gs_cleanup
call :colors 17
set cmdline=
title L2JDP Installer - Game Server DataBase Full Install
echo.
echo Deleting all Game Server tables for new content.
set cmdline="%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^< gs_cleanup.sql 2^> NUL
%cmdline%
if not %ERRORLEVEL% == 0 goto omfg
set full=1
echo.
echo Game Server tables has been deleted.
goto gs_install
:gs_upgrade
cls
echo.
echo Upgrading structure of Game Server tables (this could take awhile, be patient).
echo.
echo @echo off> temp.bat
if exist gs_errors.log del gs_errors.log
for %%i in (..\sql\game\updates\*.sql) do echo "%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% --force ^< %%i 2^>^> gs_errors.log >> temp.bat
call temp.bat> nul
del temp.bat
move gs_errors.log %workdir%
goto gs_install
:gs_install
cls
set cmdline=
if %full% == 1 (
title L2JDP Installer - Game Server DataBase Installing...
echo.
echo Installing new Game Server content.
echo.
) else (
title L2JDP Installer - Game Server DataBase Upgrading...
echo.
echo Upgrading Game Server content.
echo.
)
if %logging% == 0 set output=NUL
set dest=gs
for %%i in (..\sql\game\*.sql) do call :dump %%i
echo done...
echo.
goto custom_ask
:dump
set cmdline=
if /i %full% == 1 (set action=Installing) else (set action=Upgrading)
echo %action% %1>>"%output%"
echo %action% %~nx1
if "%dest%"=="ls" set cmdline="%mysqlPath%" -h %lshost% -u %lsuser% --password=%lspass% -D %lsdb% ^< %1 2^>^>"%output%"
if "%dest%"=="cb" set cmdline="%mysqlPath%" -h %cbhost% -u %cbuser% --password=%cbpass% -D %cbdb% ^< %1 2^>^>"%output%"
if "%dest%"=="gs" set cmdline="%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^< %1 2^>^>"%output%"
%cmdline%
if %logging%==0 if NOT %ERRORLEVEL%==0 call :omfg2 %1
goto :eof
:omfg2
cls
set ntpebcak=c
call :colors 47
title L2JDP Installer - Potential DataBase Issue at stage %stage%
echo.
echo Something caused an error while executing instruction :
echo %mysqlPath% -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb%
echo.
echo with file %~nx1
echo.
echo What we should do now?
echo.
echo (l) Log it: I will create a log for this file, then continue
echo with the rest of the list in non-logging mode.
echo.
echo (c) Continue: Let's pretend that nothing happened and continue with
echo the rest of the list.
echo.
echo (r) Reconfigure: Perhaps these errors were caused by a typo.
echo you can restart from scratch and redefine paths, databases
echo and user info again.
echo.
echo (q) Quit now
echo.
set /p ntpebcak=Choose (default continue):
if /i %ntpebcak%==c (call :colors 17 & goto :eof)
if /i %ntpebcak%==l (call :logginon %1 & goto :eof)
if /i %ntpebcak%==r (call :configure & exit)
if /i %ntpebcak%==q (call :end)
goto omfg2
:logginon
cls
call :colors 17
title L2JDP Installer - Game Server Logging Options turned on
set logging=1
if %full% == 1 (
set output=%logdir%\install-%~nx1.log
) else (
set output=%logdir%\upgrade-%~nx1.log
)
echo.
echo Per your request, i'll create a log file for your reading pleasure.
echo.
echo I'll call it %output%
echo.
echo If you already have such a file and would like to keep a copy.
echo go now and read it or back it up, because it's not going to be rotated
echo or anything, instead i'll just overwrite it.
echo.
pause
set cmdline="%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^<..\sql\%1 2^>^>"%output%"
date /t >"%output%"
time /t >>"%output%"
%cmdline%
echo Log file created, resuming normal operations...
call :colors 17
set logging=0
set output=NUL
goto :eof
:custom_ask
title L2JDP Installer - Custom Server Tables
cls
set cstprompt=n
echo.
echo L2J provides some "Custom Server Tables" for non-retail modifications
echo in order to avoid override the original Server Tables.
echo.
echo Remember that in order to get these additions actually working
echo you need to edit your configuration files.
echo.
set /p cstprompt=Install Custom Server Tables: (y) yes or (n) no (default no):
if /i %cstprompt%==y goto custom_install
if /i %cstprompt%==n goto mod_ask
:custom_install
cls
echo.
echo Installing Custom content.
echo @echo off> temp.bat
if exist custom_errors.log del custom_errors.log
for %%i in (..\sql\game\custom\*.sql) do echo "%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^< %%i 2^>^> custom_errors.log >> temp.bat
call temp.bat> nul
del temp.bat
move custom_errors.log %workdir%
goto mod_ask
:mod_ask
title L2JDP Installer - Mod Server Tables
cls
set cstprompt=n
echo.
echo L2J provides a basic infraestructure for some non-retail features
echo (aka L2J mods) to get enabled with a minimum of changes.
echo.
echo Some of these mods would require extra tables in order to work
echo and those tables could be created now if you wanted to.
echo.
echo Remember that in order to get these additions actually working
echo you need to edit your configuration files.
echo.
set /p cstprompt=Install Mod Server Tables: (y) yes or (n) no (default no):
if /i %cstprompt%==y goto mod_install
if /i %cstprompt%==n goto end
:mod_install
cls
echo.
echo Installing Mods content.
echo @echo off> temp.bat
if exist mods_errors.log del mods_errors.log
for %%i in (..\sql\game\mods\*.sql) do echo "%mysqlPath%" -h %gshost% -u %gsuser% --password=%gspass% -D %gsdb% ^< %%i 2^>^> mods_errors.log >> temp.bat
call temp.bat> nul
del temp.bat
move mods_errors.log %workdir%
goto end
:omfg
set omfgprompt=q
call :colors 57
cls
title L2JDP Installer - Potential PICNIC detected at stage %stage%
echo.
echo There was some problem while executing:
echo.
echo "%cmdline%"
echo.
echo I'd suggest you to look for correct values and try this
echo script again later. But maybe you'd prefer to go on now.
if %stage% == 1 set label=ls_err1
if %stage% == 2 set label=ls_err2
if %stage% == 3 set label=cs_err1
if %stage% == 4 set label=cs_err2
if %stage% == 5 set label=gs_err1
if %stage% == 6 set label=gs_err2
echo.
echo (c) Continue running the script
echo.
echo (r) Reconfigure
echo.
echo (q) Quit now
echo.
set /p omfgprompt=Choose (default quit):
if /i %omfgprompt%==c goto %label%
if /i %omfgprompt%==r goto configure
if /i %omfgprompt%==q goto end
goto omfg
:binaryfind
if EXIST "%mysqlBinPath%" (echo Found) else (echo Not Found)
goto :eof
:end
call :colors 17
title L2JDP Installer - Script Execution Finished
cls
echo.
echo L2JDP Database Installer 2012
echo.
echo (C) 2004-2012 L2J DataPack Team
echo L2JDP Database Installer comes with ABSOLUTELY NO WARRANTY
echo This is free software, and you are welcome to redistribute it
echo under certain conditions; See the file gpl.txt for further
echo details.
echo.
echo Thanks for using our software.
echo visit http://www.l2jdp.com for more info about
echo the L2J DataPack Project.
echo.
pause
Посмотри какая версия MySQL указана в батнике(путь к папке bin)
У тебя так примерно) в батнике (database_installer.bat)прописано путь к бд и мускула?
Код:
set fresh_setup=1
set mysqlBinPath=D:\Program Files2\VertrigoServ\Mysql
set lsuser=root
set lspass=root
set lsdb=l2jdblogin
set lshost=localhost
set cbuser=root
set cbpass=root
set cbdb=l2jcb
set cbhost=localhost
set gsuser=root
set gspass=root
set gsdb=l2jdbpvp
set gshost=localhost
set cmode=c
set backup=.
set logdir=.
Посмотри какая версия MySQL указана в батнике(путь к папке bin)
У тебя так примерно) в батнике (database_installer.bat)прописано путь к бд и мускула?
Код:
set fresh_setup=1
set mysqlBinPath=D:\Program Files2\VertrigoServ\Mysql
set lsuser=root
set lspass=root
set lsdb=l2jdblogin
set lshost=localhost
set cbuser=root
set cbpass=root
set cbdb=l2jcb
set cbhost=localhost
set gsuser=root
set gspass=root
set gsdb=l2jdbpvp
set gshost=localhost
set cmode=c
set backup=.
set logdir=.
и посмотри ты еще создал саму базу даных!
Код:
set mysqlBinPath=D:\Games\VertrigoServ\Mysql\bin
set lsuser=root
set lspass=пароль
set lsdb=l2jls
set lshost=localhost
set cbuser=root
set cbpass=пароль
set cbdb=l2jcs
set cbhost=localhost
set gsuser=root
set gspass=пароль
set gsdb=l2jgs
set gshost=localhost
set cmode=c
set backup=.
set logdir=.
set mysqlBinPath=D:\Games\VertrigoServ\Mysql\bin
set lsuser=root
set lspass=пароль
set lsdb=l2jls
set lshost=localhost
set cbuser=root
set cbpass=пароль
set cbdb=l2jcs
set cbhost=localhost
set gsuser=root
set gspass=пароль
set gsdb=l2jgs
set gshost=localhost
set cmode=c
set backup=.
set logdir=.
Вот так указан путь, базы созданые .
Код:
set fresh_setup=1
set mysqlBinPath=%ProgramFiles%\MySQL\MySQL Server 5.5\bin (Здесь пропиши свою папку к мускула норм)
set lsuser=root
set lspass= (Здесь пароля нету!!)
set lsdb=l2jdb
set lshost=localhost
set cbuser=root
set cbpass=root
set cbdb=l2jcb
set cbhost=localhost
set gsuser=root
set gspass=root
set gsdb=l2jdb
set gshost=localhost
set cmode=c
set backup=.
set logdir=.
)
set fresh_setup=1
set mysqlBinPath=%ProgramFiles%\MySQL\MySQL Server 5.5\bin (Здесь пропиши свою папку к мускула норм)
set lsuser=root
set lspass= (Здесь пароля нету!!)
set lsdb=l2jdb
set lshost=localhost
set cbuser=root
set cbpass=root
set cbdb=l2jcb
set cbhost=localhost
set gsuser=root
set gspass=root
set gsdb=l2jdb
set gshost=localhost
set cmode=c
set backup=.
set logdir=.
)
Я бы сказала нормально - это включить мо3г )) те6е же дали подсказку , забавно
вот пример C:\Program Files\MySQL\MySQL Server 5.5\bin тут стоит мой 5.5 мусл )
ну у се6я на та4ке смотришь так же - где и какой и этот путь укажешь тут
set mysqlBinPath=D:\Games\VertrigoServ\Mysql\bin
Если у те6я версия 5.1 пищи 5.1 итд ниже показала пример ))
set mysqlBinPath=C:\Program Files\MySQL\MySQL Server 5.5\bin
Думаю разжевала и положила в рот ) с те6я спасибка
Всем борща и сметанки люди . )
Я бы сказала нормально - это включить мо3г )) те6е же дали подсказку , забавно
вот пример C:\Program Files\MySQL\MySQL Server 5.5\bin тут стоит мой 5.5 мусл )
ну у се6я на та4ке смотришь так же - где и какой и этот путь укажешь тут
set mysqlBinPath=D:\Games\VertrigoServ\Mysql\bin
Если у те6я версия 5.1 пищи 5.1 итд ниже показала пример ))
set mysqlBinPath=C:\Program Files\MySQL\MySQL Server 5.5\bin
Думаю разжевала и положила в рот ) с те6я спасибка
Всем борща и сметанки люди . )
и так ставил нихера тоже самое пишет. Проблема в тачке может быть?
Здравствуйте уважаемые форумчане, помогите в решении одной проблемы:
1) Я скачал сборку
2) Распаковал данную сборку и установил базу данных. Все прошло без ошибок.
3) Зарегестрировал сервер в базе. Настроил сервер на IP = 127.0.0.1, и указал настройки к базе данных.
4) Отредактировал l2.ini на IP= 127.0.0.1
Так вот, сервер запускается нормально, никаких ошибок не показывает. Далее я захожу в клиент и пытаюсь зайти на сервер (Автоматическая регестрация включена) и внизу клиент выдает ошибку: Невозможно соединиться с сервером.
В чем может быть проблема? Конфинги я не трогал, оставил все как есть, кроме IP и базы данных.
Кто ставил данную сборку, прошу отписаться какие настройки вы вводили для входа на сервер через клиент.
Регистрация: 04.06.2012
Сообщений: 402
Популярность: 26096
Сказал(а) спасибо: 36
l2jserver rev. 9070 [HF5]
ot effects.
)
)
Re: l2jserver rev. 9070 [HF5]
