tmw-eathena:tmw-ea-sql-test-bed.git
7 years agoAdd the login_sql server. master
Chuck Miller [Wed, 10 Mar 2010 02:43:08 +0000 (21:43 -0500)]
Add the login_sql server.

It doesn't compile yet... but is a start... still have a lot to work to go
*sigh*

I know commiting unfinsihed work is frowned upon, but this is so I can work on
it at school :)

7 years agoMerge branch 'master' of git://gitorious.org/tmw-eathena/mainline
Chuck Miller [Wed, 3 Mar 2010 01:33:36 +0000 (20:33 -0500)]
Merge branch 'master' of git://gitorious.org/tmw-eathena/mainline

7 years agoFix trades cancelling without proper reason.
No Name [Mon, 22 Feb 2010 06:06:57 +0000 (22:06 -0800)]
Fix trades cancelling without proper reason.

Addresses issue introduced by d6c7054 (by me).

7 years agoPad server whisper name with null characters.
No Name [Sat, 20 Feb 2010 03:56:02 +0000 (19:56 -0800)]
Pad server whisper name with null characters.

Prevents server whisper name from containing other trailing data as
memcpy will not check for a terminating null character in the source.

7 years agoCancel active trade if an item is removed from inventory.
No Name [Sat, 20 Feb 2010 03:41:40 +0000 (19:41 -0800)]
Cancel active trade if an item is removed from inventory.

Modifies the previous fix to now cancel if an item is deleted from a
player's inventory, including items that are used/consumed.

7 years agoFixed sending player's name when in a guild.
Chuck Miller [Mon, 22 Feb 2010 03:44:16 +0000 (22:44 -0500)]
Fixed sending player's name when in a guild.

Also changed up packet 0x0195, the client can now understand this packet

7 years agoFixed sending player's name when in a guild.
Chuck Miller [Mon, 22 Feb 2010 03:44:16 +0000 (22:44 -0500)]
Fixed sending player's name when in a guild.

Also changed up packet 0x0195, the client can now understand this packet

7 years agoSome more adjustments to the SQL backend
Chuck Miller [Mon, 22 Feb 2010 00:53:42 +0000 (19:53 -0500)]
Some more adjustments to the SQL backend

7 years agoMerge branch 'master' of git://gitorious.org/tmw-eathena/mainline
Chuck Miller [Sat, 20 Feb 2010 18:44:57 +0000 (13:44 -0500)]
Merge branch 'master' of git://gitorious.org/tmw-eathena/mainline

7 years agoAdd code for converting g_storage.txt file into sql
Chuck Miller [Sat, 20 Feb 2010 17:40:11 +0000 (12:40 -0500)]
Add code for converting g_storage.txt file into sql

7 years agoDo not report another player's base level.
No Name [Sat, 20 Feb 2010 08:02:23 +0000 (00:02 -0800)]
Do not report another player's base level.

Modifies three packets to no longer transmit another player's base
level, instead reporting zero.

7 years agoAdded sql for login.db, and code for populating it from account.txt
Chuck Miller [Sat, 20 Feb 2010 00:14:07 +0000 (19:14 -0500)]
Added sql for login.db, and code for populating it from account.txt

7 years agoAdd code for converting accreg.txt to sql
Chuck Miller [Fri, 19 Feb 2010 22:53:03 +0000 (17:53 -0500)]
Add code for converting accreg.txt to sql

7 years agoAdd party converter, and change sqlite to use prepare and bind statements for speed
Chuck Miller [Fri, 19 Feb 2010 22:22:05 +0000 (17:22 -0500)]
Add party converter, and change sqlite to use prepare and bind statements for speed

7 years agoHave the convert script save memo_point data
Chuck Miller [Fri, 19 Feb 2010 19:08:54 +0000 (14:08 -0500)]
Have the convert script save memo_point data

7 years agoMerge branch 'master' of git://gitorious.org/tmw-eathena/mainline
Chuck Miller [Fri, 19 Feb 2010 18:46:26 +0000 (13:46 -0500)]
Merge branch 'master' of git://gitorious.org/tmw-eathena/mainline

7 years agoAdded missing skill converting from athena.txt, and added storage converting
Chuck Miller [Fri, 19 Feb 2010 18:41:12 +0000 (13:41 -0500)]
Added missing skill converting from athena.txt, and added storage converting

7 years agomake login-server child REALLY exit when done writing DB
MadCamel [Fri, 19 Feb 2010 00:37:31 +0000 (19:37 -0500)]
make login-server child REALLY exit when done writing DB

7 years agoSetup the entire text-to-sql for the athena.txt file :)
Chuck Miller [Thu, 18 Feb 2010 05:12:00 +0000 (00:12 -0500)]
Setup the entire text-to-sql for the athena.txt file :)

also made some changes to "GNUmakefile" files

7 years agomake login-server exit after DB write is finished
MadCamel [Thu, 18 Feb 2010 15:28:02 +0000 (10:28 -0500)]
make login-server exit after DB write is finished

7 years agoAdd basic SQL platform
Chuck Miller [Thu, 18 Feb 2010 05:11:10 +0000 (00:11 -0500)]
Add basic SQL platform

7 years agoDelete old SQL stuff... its outdated and doesn't work
Chuck Miller [Wed, 17 Feb 2010 04:06:10 +0000 (23:06 -0500)]
Delete old SQL stuff... its outdated and doesn't work

7 years agoMerge branch 'master' of git://gitorious.org/+tmw-developers/tmw-eathena/tmw-ea-sql...
Chuck Miller [Wed, 17 Feb 2010 04:00:36 +0000 (23:00 -0500)]
Merge branch 'master' of git://gitorious.org/+tmw-developers/tmw-eathena/tmw-ea-sql-test-bed

7 years agoLogin-server now does forked writes of accounts DB
MadCamel [Fri, 12 Feb 2010 09:07:42 +0000 (04:07 -0500)]
Login-server now does forked writes of accounts DB

7 years agoRe-calculate player stats when an equipped item is removed.
MadCamel [Thu, 11 Feb 2010 10:52:53 +0000 (05:52 -0500)]
Re-calculate player stats when an equipped item is removed.

This fixes the issue where a player could drop/trade/store an equipped
item and still retain it's attack/def/etc buffs.

7 years agoCleaned up spamban code a little. Now logs location where ban was triggered.
MadCamel [Sat, 6 Feb 2010 17:27:20 +0000 (12:27 -0500)]
Cleaned up spamban code a little. Now logs location where ban was triggered.

It still needs to be refactored more but this'll do for now.

7 years agoFix a memory leak
MadCamel [Sat, 6 Feb 2010 16:53:56 +0000 (11:53 -0500)]
Fix a memory leak

7 years agoSpellcasting will no longer trigger spam bans
MadCamel [Fri, 5 Feb 2010 06:15:27 +0000 (01:15 -0500)]
Spellcasting will no longer trigger spam bans

I ran this by fate and he had no objections. If there are problems
with flooding/resource consumption we can put some rate limits in
the packet handlers. (That's on my TODO)

7 years agoAttempt to fix forking problem on platinum
Jared Adams [Mon, 18 Jan 2010 19:36:34 +0000 (19:36 +0000)]
Attempt to fix forking problem on platinum

7 years agoRemoved auto-generated source files
MadCamel [Fri, 5 Feb 2010 00:58:03 +0000 (19:58 -0500)]
Removed auto-generated source files

And added them to .gitignore. These three files are generated on
the fly by flex and bison during the build process and should not
be in the repository.

7 years agoWrite the accounts DB on a timer instead of player triggered events
MadCamel [Fri, 5 Feb 2010 00:24:51 +0000 (19:24 -0500)]
Write the accounts DB on a timer instead of player triggered events

Writing the DB is resource intensive and should be done as little as
possible. Putting it on a timer is intended to prevent buggy/malicious
clients from consuming large amounts of resources. This patch may
cause minor inconsistancies between the login and character server
databases, as they are both doing delayed writes, probably on different
schedules. I'm unable to see any huge consequences to this.

7 years agoMerge branch 'master' of git://gitorious.org/tmw-eathena/mainline
MadCamel [Wed, 3 Feb 2010 03:08:37 +0000 (22:08 -0500)]
Merge branch 'master' of git://gitorious.org/tmw-eathena/mainline

7 years agoAttempt to fix forking problem on platinum
Jared Adams [Mon, 18 Jan 2010 19:36:34 +0000 (19:36 +0000)]
Attempt to fix forking problem on platinum

7 years agoAdded password encryption to the accounts database, removed logging of plaintext...
MadCamel [Tue, 26 Jan 2010 23:44:06 +0000 (18:44 -0500)]
Added password encryption to the accounts database, removed logging of plaintext passwords Will auto-convert accounts DB to new format.

7 years agoAdded password encryption to the accounts database, removed logging of plaintext...
MadCamel [Tue, 26 Jan 2010 23:44:06 +0000 (18:44 -0500)]
Added password encryption to the accounts database, removed logging of plaintext passwords
Will auto-convert accounts DB to new format.

7 years agofixed a buffer overrun and use of uninitialized
Helmut Grohne [Tue, 19 Jan 2010 19:34:06 +0000 (20:34 +0100)]
fixed a buffer overrun and use of uninitialized

The target buffer for the memcpy only takes like 24 chars.
strcat on an uninitialized buffer is a bad idea.

7 years agofixed a few memory leaks
Helmut Grohne [Tue, 19 Jan 2010 19:33:25 +0000 (20:33 +0100)]
fixed a few memory leaks

7 years agofixed a few buffer overruns
Helmut Grohne [Tue, 19 Jan 2010 19:24:19 +0000 (20:24 +0100)]
fixed a few buffer overruns

strncpy does not always terminate strings. Unterminated strings
(without a length) are bad. So better terminate them.

7 years agoAttempt to fix forking problem on platinum
Jared Adams [Mon, 18 Jan 2010 19:36:34 +0000 (19:36 +0000)]
Attempt to fix forking problem on platinum

7 years agocharbaselvl now also performs charstreset to prevent stacking of points. @setup modif...
MadCamel [Sat, 9 Jan 2010 22:51:56 +0000 (17:51 -0500)]
charbaselvl now also performs charstreset to prevent stacking of points. @setup modified for new skill system

7 years agoFix IP checker tool to do case insensitive compare
Jared Adams [Tue, 5 Jan 2010 01:58:28 +0000 (18:58 -0700)]
Fix IP checker tool to do case insensitive compare

7 years agoTemporarily enclose astral soul modifications with ifdefs
Freeyorp [Wed, 30 Dec 2009 06:00:04 +0000 (19:00 +1300)]
Temporarily enclose astral soul modifications with ifdefs

Until the quests for this skill are available, this needs to be disabled on the
server

7 years agoRemove conflict markers
Freeyorp [Wed, 30 Dec 2009 01:23:19 +0000 (14:23 +1300)]
Remove conflict markers

7 years agoFixed "maximum skill points" computation
Fate [Tue, 29 Dec 2009 17:00:28 +0000 (17:00 +0000)]
Fixed "maximum skill points" computation

7 years agoAlso pass a variable @itemId when running equip scripts
Freeyorp [Mon, 28 Dec 2009 23:34:38 +0000 (12:34 +1300)]
Also pass a variable @itemId when running equip scripts

7 years agoRemove extra check when logging atcommands.
Freeyorp [Mon, 28 Dec 2009 11:47:09 +0000 (00:47 +1300)]
Remove extra check when logging atcommands.

This means that atcommands called in NPC scripts will be logged regardless
of whether the invoking player has @

7 years agoPass a variable @slotId when running equip scripts.
Freeyorp [Mon, 28 Dec 2009 09:22:03 +0000 (22:22 +1300)]
Pass a variable @slotId when running equip scripts.

7 years agoRemove the line GNUmakefile from the .gitignore
Chuck Miller [Sat, 26 Dec 2009 14:11:19 +0000 (09:11 -0500)]
Remove the line GNUmakefile from the .gitignore

Doesn't make sense its in there because its also in the repo

7 years agoMerge branch 'master' of git://gitorious.org/tmw-eathena/mainline
Chuck Miller [Sat, 26 Dec 2009 12:26:36 +0000 (07:26 -0500)]
Merge branch 'master' of git://gitorious.org/tmw-eathena/mainline

7 years agoUsed the "indent" C formatting program from GNU to do some clean ups
Chuck Miller [Fri, 25 Dec 2009 10:00:31 +0000 (05:00 -0500)]
Used the "indent" C formatting program from GNU to do some clean ups

The command options used was:
-nbad -bap -sc -bl -blf -bli0 -cli4 -cbi0
-di5 -nbc -bls -ip2 -nut -ts4 -bap -i4 -sob -npsl

7 years agoUsed the "indent" C formatting program from GNU to do some clean ups
Chuck Miller [Fri, 25 Dec 2009 10:00:31 +0000 (05:00 -0500)]
Used the "indent" C formatting program from GNU to do some clean ups

The command options used was:
-nbad -bap -sc -bl -blf -bli0 -cli4 -cbi0
-di5 -nbc -bls -ip2 -nut -ts4 -bap -i4 -sob -npsl

7 years agoMerge commit 'tmw/master'
MadCamel [Mon, 14 Dec 2009 04:45:02 +0000 (23:45 -0500)]
Merge commit 'tmw/master'

7 years agoUnequip items when adding to storage
MadCamel [Mon, 14 Dec 2009 03:51:42 +0000 (22:51 -0500)]
Unequip items when adding to storage

7 years agoCleaned up Makefile, Added -fstack-protector to cflags
MadCamel [Mon, 14 Dec 2009 03:41:31 +0000 (22:41 -0500)]
Cleaned up Makefile, Added -fstack-protector to cflags

7 years agoFix map authentication response
Jared Adams [Wed, 2 Dec 2009 14:52:59 +0000 (07:52 -0700)]
Fix map authentication response

This way,t he client will parse the duplicate login packet correctly when logging in.

7 years agoFix a segfault when the master of a summoned monster is not online
Freeyorp [Mon, 23 Nov 2009 02:23:25 +0000 (15:23 +1300)]
Fix a segfault when the master of a summoned monster is not online

8 years agoMerge branch 'master' of git://gitorious.org/tmw-eathena/mainline
MadCamel [Sun, 8 Nov 2009 11:25:42 +0000 (06:25 -0500)]
Merge branch 'master' of git://gitorious.org/tmw-eathena/mainline

8 years agoAllow deleting characters despite email
Jared Adams [Mon, 2 Nov 2009 23:09:40 +0000 (16:09 -0700)]
Allow deleting characters despite email

8 years agoAllow players to switch characters while alive
Jared Adams [Thu, 29 Oct 2009 23:54:00 +0000 (17:54 -0600)]
Allow players to switch characters while alive

8 years agoPrevent auto bans from multiplying
Jared Adams [Mon, 26 Oct 2009 01:36:15 +0000 (19:36 -0600)]
Prevent auto bans from multiplying

8 years agoGive level 99 character the GM hilight too
Jared Adams [Mon, 26 Oct 2009 01:15:39 +0000 (19:15 -0600)]
Give level 99 character the GM hilight too

8 years agoRemoved duplicate compile flag
MadCamel [Fri, 23 Oct 2009 15:48:12 +0000 (11:48 -0400)]
Removed duplicate compile flag

8 years agoAdd a tool for changing skills
Jared Adams [Thu, 15 Oct 2009 20:22:23 +0000 (14:22 -0600)]
Add a tool for changing skills

8 years agoMerge remote branch 'taw/master'
Jared Adams [Thu, 15 Oct 2009 12:38:48 +0000 (06:38 -0600)]
Merge remote branch 'taw/master'

8 years agoreport job level as zero
Fate [Sat, 10 Oct 2009 19:28:42 +0000 (19:28 +0000)]
report job level as zero

8 years agoBetter logging, initial job experience gathering, naming fixes to the skill script...
Fate [Sat, 10 Oct 2009 07:02:51 +0000 (07:02 +0000)]
Better logging, initial job experience gathering, naming fixes to the skill script commands

8 years agoMerge branch 'master' of gitorious.org:tmw-eathena/mainline
Fate [Thu, 8 Oct 2009 05:48:29 +0000 (05:48 +0000)]
Merge branch 'master' of gitorious.org:tmw-eathena/mainline

8 years agoMerge branch 'master' of git://gitorious.org/tmw-eathena/mainline
MadCamel [Tue, 6 Oct 2009 23:35:25 +0000 (19:35 -0400)]
Merge branch 'master' of git://gitorious.org/tmw-eathena/mainline

8 years agoMake sure the announce packet includes the nick
Jared Adams [Sat, 3 Oct 2009 18:08:30 +0000 (12:08 -0600)]
Make sure the announce packet includes the nick

Also remove @kamib, as it's difference doesn't affect our client.

8 years agoMake failed skill ups respond with right value
Jared Adams [Sat, 3 Oct 2009 16:42:20 +0000 (10:42 -0600)]
Make failed skill ups respond with right value

8 years agoMerge branch 'master' of git@gitorious.org:~madcamel/tmw-eathena/thealternateworld
MadCamel [Wed, 30 Sep 2009 17:58:34 +0000 (13:58 -0400)]
Merge branch 'master' of git@gitorious.org:~madcamel/tmw-eathena/thealternateworld

Conflicts:
src/common/utils.h

8 years agoMerge branch 'master' of git://gitorious.org/tmw-eathena/mainline
MadCamel [Wed, 30 Sep 2009 17:53:33 +0000 (13:53 -0400)]
Merge branch 'master' of git://gitorious.org/tmw-eathena/mainline

8 years agoAdded -fno-strict-aliasing to CFLAGS
MadCamel [Wed, 30 Sep 2009 17:52:13 +0000 (13:52 -0400)]
Added -fno-strict-aliasing to CFLAGS
This will likely fix a few minor weirdnesses and compiler warnings.

8 years agoRevert "Added -fno-strict-aliasing to CFLAGS This will likely fix a few minor weirdne...
MadCamel [Wed, 30 Sep 2009 17:50:50 +0000 (13:50 -0400)]
Revert "Added -fno-strict-aliasing to CFLAGS This will likely fix a few minor weirdnesses, and compiler warnings."

This reverts commit 765c84f370747e35902757b6771368009ae2a8f6.

8 years agoAdded -fno-strict-aliasing to CFLAGS This will likely fix a few minor weirdnesses...
MadCamel [Wed, 30 Sep 2009 17:42:54 +0000 (13:42 -0400)]
Added -fno-strict-aliasing to CFLAGS This will likely fix a few minor weirdnesses, and compiler warnings.

8 years agoAdded -fno-strict-aliasing to CFLAGS
MadCamel [Wed, 30 Sep 2009 17:42:54 +0000 (13:42 -0400)]
Added -fno-strict-aliasing to CFLAGS
This will likely fix a few minor weirdnesses, and compiler warnings.

8 years agoRevert "Prevent trading with other players who are shoping"
Jared Adams [Mon, 28 Sep 2009 19:05:53 +0000 (13:05 -0600)]
Revert "Prevent trading with other players who are shoping"

This reverts commit b3939b91deda8081c5b144109829599b05e81272.

8 years agoAdded astral soul skill, affecting all magic users: without this skill, antimagic...
Fate [Sun, 27 Sep 2009 17:34:52 +0000 (17:34 +0000)]
Added astral soul skill, affecting all magic users: without this skill, antimagic equipment carries a heavier penalty and spellpower beyond 200 is curved down.

8 years agoAdded resist-poison skill that reduces the amount of time spent poisoned
Fate [Sun, 27 Sep 2009 16:21:11 +0000 (16:21 +0000)]
Added resist-poison skill that reduces the amount of time spent poisoned

8 years agoMerge branch 'master' of gitorious.org:tmw-eathena/mainline
Fate [Sun, 27 Sep 2009 15:34:41 +0000 (15:34 +0000)]
Merge branch 'master' of gitorious.org:tmw-eathena/mainline

8 years agoAdded "Mallard's Eye" skill (45) for ranged weapon users: increase
Fate [Sun, 27 Sep 2009 15:32:58 +0000 (15:32 +0000)]
Added "Mallard's Eye" skill (45) for ranged weapon users:  increase
to-hit, increase range, decrease the malus effect of distance.
Also added an up to 31.25% damage bonus for hitting enemies that
are farther away (only affects ranged weapons).
Fixed a bug that would forget to recompute stats after changing
skill focus.

8 years agoFix a bug in mob exp determination
Jared Adams [Sun, 27 Sep 2009 05:34:23 +0000 (23:34 -0600)]
Fix a bug in mob exp determination

8 years agoAdd a no player drop flag for maps
Jared Adams [Sat, 26 Sep 2009 19:06:52 +0000 (13:06 -0600)]
Add a no player drop flag for maps

8 years agoInitial support for skill pools (available via at commands and
Fate [Sat, 26 Sep 2009 18:08:42 +0000 (18:08 +0000)]
Initial support for skill pools (available via at commands and
untested scripting commands.)  These changes also affect the format
of the skill_db.txt file.

8 years agoPrevent attacking while hidden
Jared Adams [Wed, 23 Sep 2009 00:03:32 +0000 (18:03 -0600)]
Prevent attacking while hidden

8 years agoSpellcasting disallowed while @hide is active
Fate [Tue, 22 Sep 2009 23:57:56 +0000 (23:57 +0000)]
Spellcasting disallowed while @hide is active

8 years ago@listnearby lists all nearby player names
Fate [Tue, 22 Sep 2009 23:53:13 +0000 (23:53 +0000)]
@listnearby lists all nearby player names

8 years agoInitial support for skill pools
Fate [Sun, 20 Sep 2009 00:30:15 +0000 (00:30 +0000)]
Initial support for skill pools

8 years agoWhen zipping server logs, zip with -f to overwrite
Fate [Sat, 19 Sep 2009 19:02:47 +0000 (19:02 +0000)]
When zipping server logs, zip with -f to overwrite

8 years agoReplace basic skill with three new skills
Jared Adams [Fri, 18 Sep 2009 21:49:51 +0000 (15:49 -0600)]
Replace basic skill with three new skills

We want to handle skills differently that eAthena was made too. All new skills are leveled by NPCs instead of using the job sysetm. Also fixes some bugs.

8 years agoPrevent trading with other players who are shoping
Jared Adams [Thu, 17 Sep 2009 17:21:23 +0000 (11:21 -0600)]
Prevent trading with other players who are shoping

8 years agoMRAND now wraps its modulo parameter in parentheses to avoid misassociation
Fate [Thu, 17 Sep 2009 16:12:21 +0000 (16:12 +0000)]
MRAND now wraps its modulo parameter in parentheses to avoid misassociation

8 years agoModified AI so mob stop walking to their target's last location when the target is...
MadCamel [Wed, 16 Sep 2009 14:26:38 +0000 (10:26 -0400)]
Modified AI so mob stop walking to their target's last location when the target is gone

This should help stop pileups at doors and make battle a bit more interesting

8 years agoFound and replaced more calls to rand()
MadCamel [Wed, 16 Sep 2009 11:49:36 +0000 (07:49 -0400)]
Found and replaced more calls to rand()

8 years agoLogging fix and extension to include trade informaiton
Fate [Tue, 15 Sep 2009 04:18:33 +0000 (04:18 +0000)]
Logging fix and extension to include trade informaiton

8 years agoOnly report characters as GMs to clients if their GM level is 60
Fate [Mon, 14 Sep 2009 21:58:12 +0000 (21:58 +0000)]
Only report characters as GMs to clients if their GM level is 60

8 years agoReplace logging mechanism: write out text file every ~20 minutes and try to gzip...
Fate [Mon, 14 Sep 2009 21:12:29 +0000 (21:12 +0000)]
Replace logging mechanism: write out text file every ~20 minutes and try to gzip.  If gzip fails, the old file still survives.

8 years agoWhen a player walks, make sure they stand up
Fate [Sun, 13 Sep 2009 21:11:49 +0000 (21:11 +0000)]
When a player walks, make sure they stand up

8 years agoUse gzip --rsyncable to compress map server logs to update the log file more frequently
Fate [Sun, 13 Sep 2009 19:56:26 +0000 (19:56 +0000)]
Use gzip --rsyncable to compress map server logs to update the log file more frequently

8 years agoImplemented pDeaf property (70) which makes PCs ignore regular PC chat (except for...
Fate [Sat, 12 Sep 2009 00:16:56 +0000 (00:16 +0000)]
Implemented pDeaf property (70) which makes PCs ignore regular PC chat (except for GMs)