mana/manaserv - A flexible 2D MMORPG server

Age	Commit message (Collapse)	Author	Files	Lines
2012-04-04	Enhanced special support	Erik Schilling	1	-0/+11
	- Made the current charge being saved. - Added script binds: - chr_set_special_recharge_speed - chr_get_special_recharge_speed - chr_set_special_mana - chr_get_special_mana - get_special_info - Added special info lua class. Functions: - name - needed_mana - rechargeable - on_use - on_recharged - category Further the engine no longer sets charge to 0 after using of specials this allows more flexbilillity (like failing specials). Changes on the xml database: - recharge renamed to rechargeable (needed by client and server) - needed - the needed mana to trigger a special (server only) - rechargespeed - the defailt recharge speed in mana per tick (server only) - target - the type of target (either being or point) (server and client) I also made the lua engine pushing nil instead of a 0 light userdata when the pointer was 0. Database update needed. Change is tested. Mana-Mantis: #167, #156 Reviewed-by: bjorn.
2012-03-13	Fixed problems with map-bound world state variables	Thorbjørn Lindeijer	1	-0/+59
	Due to a wrong primary key, which covered only the state name, it was impossible to use the same state name on different maps. This has now been fixed. Another problem was that the map variables were being included in the global variables, because the related database query did not filter on the map_id column properly. While fixing that, the map_id column now allows explicitly marking a state variable as global (with the value 0) or system variables (with the value -1). System variables are currently not accessible from scripts, but that could be changed later. Reviewed-by: Yohann Ferreira Reviewed-by: Erik Schilling
2011-12-03	Allowed larger item amounts for mysql database.	Erik Schilling	1	-0/+9
	Changed range of amount to unsigned int(10). Sqlite update scripts is empty since no change was required here. Reviewed-by: Bertram.
2011-11-01	Renamed the db update 15 to 18 as requested by Bjorn.	Yohann Ferreira	1	-1/+1

2011-11-01	Merge github.com:mana/manaserv	Yohann Ferreira	1	-0/+0
	Conflicts: src/game-server/character.cpp src/scripting/lua.cpp
2011-10-26	End the confusion about the missing upgrade script	Thorbjørn Lindeijer	1	-0/+0
	Version 15 was skipped, and we'll never go back. Renamed the 15_to_16 update scripts to 14_to_16 to avoid confusing everybody who wants to update their DBs. Reviewed-by: Yohann Ferreira
2011-09-09	Add persistent items support based on seeseekey's work.	Yohann Ferreira	1	-0/+16
	Also made some random changes where useful, including: - Code formatting fixes, - Design fix about the fact that only the game config option should be checked. - Fixed the size of the values sent and receive to follow the rest of the development. - Fixed variables names to make them show what they are, and not why they are used. Resolves: Mana-Mantis #142.
2011-09-08	Merge github.com:mana/manaserv	Yohann Ferreira	1	-0/+7
	Conflicts: src/account-server/storage.cpp src/game-server/mapreader.cpp src/sql/mysql/createTables.sql
2011-09-05	Fixed size of mapid field in mysql database.	Erik Schilling	1	-0/+7
	Resolves: Mana-Mantis: #388. Reviewed-by: Bertram.
2011-08-30	Added missing sql update scripts.	Yohann Ferreira	1	-0/+21

2011-01-22	Fix the default slot values when upgrading the database to version 14.	Yohann Ferreira	1	-1/+1
	Reviewed-by: Cody. Resolves: Mana-Mantis #284.
2010-12-29	Made the server handle properly the characters slots.	Yohann Ferreira	1	-0/+10
	I turned the vector storing character data into a map, keeping the character's slot. Fixed a memleak along the way. Reviewed-by: Crush.
2010-12-27	Added @kick and @kill commands.	Philipp Sehmisch	1	-0/+1
	@kick disconnects the client connection of a character. The new error- code 11 (ERRMSG_ADMINISTRATIVE_LOGOFF) is not supported by the client yet. It will show a generic "The connection to server was lost" message instead. @kill kills the character by setting its HP to 0. Added @kick transaction code I forgot in last commit. Considering that this was just minutes ago I think that noone updated his database yet. So I don't think that a new database version is justified for this. Reviewed-by: Bertram
2010-12-27	Transaction logging of various command, new transaction codes and style fix.	Philipp Sehmisch	1	-0/+30
	The @mute, @goto, @attribute and @announce commands now logs transactions to the database. Added new transaction codes to database. I've preliminarily added a lot of codes for not yet supported commands so that we needn't do a database update with every single commit which implements one. Also using the equivalent "say" helper function in place of the "GameState::sayTo" method in the command handler. Reviewed-by: Kage
2010-10-17	Changed the mana_accounts.email field length to 64 characters.	Yohann Ferreira	1	-0/+10
	Reviewed-by: Crush. Resolves: Mana-mantis #251.
2010-09-27	SQLite: Do a proper upgrade of the mana_characters table	Thorbjørn Lindeijer	1	-11/+80
	We can't leave the obsolete columns around since they are marked as NOT NULL, so insertion to the table fails if no values are provided for them. With SQLite, our only option is to create the table and copy the data over, which is what the update script now does. The script was modified so that it is fine to run it again on a database that was already updated to version 11 before.
2010-09-12	Added script to update SQLite database to version 11	Thorbjørn Lindeijer	1	-0/+39
	Will not drop the attribute columns since this is not supported by SQLite. I'm just leaving them around for now and see if it causes any problems.
2010-08-07	Worked around a typo in the update script from version 7 to 8	Thorbjørn Lindeijer	2	-2/+3

2010-08-07	Fixed index creation on mana_char_kill_stats table	Thorbjørn Lindeijer	1	-0/+9
	Reviewed-by: Philipp Sehmisch
2010-07-09	Added LUA script bindings for manipulating the specials available to a ↵	Philipp Sehmisch	1	-0/+16
	character. Added script call for getting the cost of a special (recharge only for now) Deleting specials works server-sided but the client isn't informed about it properly. Specials without recharge cost don't appear for the player. Both of these features require an additional netcode message. Reviewed-by: Freeyorp
2010-01-08	Added tracing of kill count for each monster per character	Philipp Sehmisch	1	-0/+20

2009-10-24	Rebranding tmwserv to manaserv	Thorbjørn Lindeijer	1	-0/+122
	Includes a database update. Use update_6_to_7.sql to update existing sqlite databases.
2009-09-30	Adds tmw_char_status_effects tables to mySQL and SQLite	Chuck Miller	1	-0/+20

2009-08-23	Added table and view to prepare reporting of transaction log.	Andreas Habel	2	-4/+80
	Fixed database update "3 to 4". Added database update "4 to 5". Added indexes to table tmw_transaction for faster search when it gets bigger. Refactored layout of sqlite database script.
2009-08-17	Update table tmw_accounts. Added columns to store secret key and expiration	Andreas Habel	1	-0/+13
	time for password recovery via tmwweb/email.
2009-03-08	Fix error in sqlite 2 to 3 update script	Jared Adams	1	-1/+1

2009-03-05	Added transactions for chat events.	David Athay	1	-1/+1

2009-03-05	Added transactional history	David Athay	1	-0/+17

2008-12-01	Added new table to store online users. See mantis #553	Andreas Habel	1	-0/+30
	This upgrade will be the first, we provide database installation scripts and update scripts to upgrade from the previous version. For more details about database upgrades see http://wiki.themanaworld.org/index.php/Upgrade_Database and feel free to comment.