View source for PreCU - Dummy SVN Changes

<pre>
Revision: 300
Author: ead
Date: 4:00:45 PM, Sunday, June 24, 2007
Message:
06-24-07 EAD		FOUND <= SHULD BE < IN smaptbl  THANKS F00F OF #c++ zirc
FIXED SMAP CRASH WHEN NOT RUNNING SERVER IN IDE
----
Modified : /smap/smap.cpp
Modified : /src/ZoneServer/smap.cpp


Revision: 299
Author: ead
Date: 2:40:53 PM, Sunday, June 24, 2007
Message:
smap singlton commit
----
Deleted : /smap/Debug/BuildLog.htm
Deleted : /smap/Debug/mt.dep
Deleted : /smap/Debug/stree.exe
Deleted : /smap/Debug/stree.exe.intermediate.manifest
Deleted : /smap/Debug/stree.map
Added : /smap/smap.cpp
Added : /smap/smap.h
Added : /smap/smap.ncb
Modified : /smap/smap.sln
Modified : /smap/smap.suo
Added : /smap/smap.vcproj
Added : /smap/smap.vcproj.LANMASTERCMD.pat.user
Added : /smap/smapmain.cpp
Deleted : /smap/stree.ncb
Deleted : /smap/stree.vcproj
Deleted : /smap/stree.vcproj.LANMASTERCMD.pat.user


Revision: 298
Author: ead
Date: 1:45:52 PM, Sunday, June 24, 2007
Message:
SVN ERROR IN THE ROLL BACK  DBSCRIPT FOLDER CHANGES WERNT DETECTED OR UPLOADED
----
Modified : /dbScript/swgprecu.1.sql
Modified : /dbScript/swgprecu.sql.changelog.txt
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/ZoneServer/smap.cpp


Revision: 297
Author: ead
Date: 4:19:25 AM, Sunday, June 24, 2007
Message:
ROLL BACK TO 281  CODE WAS COMMITED UNTESTED AND BROEKN   IT IS ROLLED BACK    THERE WAS NO EXCUSES FOR NOT TESTING PROPERLY  THIS VERSON IS EXTREAMLY STABLE I WALKED IT UNDER A LADDER ON A BROKEN MIRROR  AT 1313 HOURS  AND COULDNT CRASH IT

BROKEN COMMITS/UNTESTED COMMITS WILL RESULT IN CASTRATION 
AND REMOVAL OF SVN RIGHTS  AND I WONT GIVE THEM BACK THIS TIME !!!!!!!!!!!!

also contanes working smap  modded version of config and tlog making there file save and read path idiot proof  somthing we defnalty need with some of the programmers that have commited lately

also moved config file ini reads to a cpp verson  I WILL MOVE WRITES LATER

THE CODE IS STABLE  WORKING AND CRASH PROOF  KEEP IT THAT WAY OR ELSE!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
----
Modified : /src/LoginServer/LoginClient.cpp
Modified : /src/LoginServer/PacketFactory.cpp
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/OverTime.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/PacketFactory.h
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/ZoneServer/ZoneServer.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h
Modified : /src/shared/crc.cpp
Modified : /src/shared/crc.h


Revision: 296
Author: meanmon13
Date: 12:56:55 AM, Sunday, June 24, 2007
Message:
Improved handling of string in place structure
----
Modified : /src/ZoneServer/ObjControllers.cpp


Revision: 295
Author: maach_ine
Date: 12:16:51 AM, Sunday, June 24, 2007
Message:
Identified unknown byte in ObjControllers -- ObjectMenuRequest.

Changed HandleZone - Handle_PlaceBuilding to work with a DeedItem not a list of them.

Modified the Database functions GetDeedObject and InventoryDeed to return a single DeedObject, not a list pointer of them.

Added checks to SpawnFellowPlayer calls and to SpawnFellowPlayer itself -- if the fellow player's ObjID is invalid, don't spawn him!
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/PacketFactory.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 294
Author: ead
Date: 12:02:58 AM, Sunday, June 24, 2007
Message:
smap files added from prev commit
----
Added : /src/ZoneServer/smap.cpp
Added : /src/ZoneServer/smap.h


Revision: 293
Author: ead
Date: 11:51:08 PM, Saturday, June 23, 2007
Message:
06-23-07 EAD		IDIOT PROOFED FILE PATHS
06-23-07 EAD		INTAL COMMIT SMAP LOADS  BUT DOSNT STOP
06-23-07 EAD		INTAL COMMIT SMAP LOADS  BUT DOSNT STOP  
			OWER SERVER DOSE NOT SUPPORT SHUTDOWN FUNCTIONS!!!! THIS IS A HELA PROBLEM
----
Modified : /ProjectFiles/SWGPreCU.vcproj
Modified : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/SWGPreCU_Zone.cpp
Modified : /src/ZoneServer/ZoneServer.h
Modified : /src/shared/config.cpp
Modified : /src/shared/tlog.cpp


Revision: 292
Author: meanmon13
Date: 12:01:08 PM, Saturday, June 23, 2007
Message:
When a player loges out when mounted or they crash while mounted... both their avatar and mount will be removed from the zone
----
Modified : /src/LoginServer/LoginClient.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/OverTime.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/ZoneServer/ZoneServer.cpp
Modified : /src/ZoneServer/ZoneServer.h


Revision: 291
Author: Zewi
Date: 4:26:41 PM, Friday, June 22, 2007
Message:
on more time for starter, items
----
Modified : /dbScript/swgprecu.1.sql


Revision: 290
Author: Zewi
Date: 4:20:18 PM, Friday, June 22, 2007
Message:
quick fix again!!!
----
Modified : /dbScript/swgprecu.1.sql


Revision: 289
Author: Zewi
Date: 4:09:16 PM, Friday, June 22, 2007
Message:
try now just human male Artisian
----
Modified : /dbScript/swgprecu.1.sql


Revision: 288
Author: maach_ine
Date: 3:26:50 PM, Friday, June 22, 2007
Message:
Merged PlasmaFlow's building spawning code from the experimental SVN.  It seems to work on my computer.
----
Modified : /dbScript/BuildingDeeds.4.sql
Modified : /dbScript/swgprecu.1.sql
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h
Modified : /src/shared/crc.cpp
Modified : /src/shared/crc.h


Revision: 287
Author: maach_ine
Date: 11:07:33 AM, Friday, June 22, 2007
Message:
Corrected CRC for Shared Rodian Female model.  Multizone should now work for all characters.
----
Modified : /src/ZoneServer/Constants.h


Revision: 286
Author: meanmon13
Date: 12:53:00 AM, Friday, June 22, 2007
Message:
Players will be removed from the world if they have been link dead for more then 1 min. Recommiting the &travel command some other stability changes... see merge tool for details 
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/OverTime.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 285
Author: compileserver
Date: 10:34:17 PM, Thursday, June 21, 2007
Message:
FIXED FILE NAME  
REMOVED DISTRUCTIVE COMMAND 
PREVENTED DATABASE FROM AUTOCHOOSING  SWGPRECU
----
Added : /dbScript/cellobject.5.sql(Copy from path: /dbScript/cellobject.sql, Revision, 284
Deleted : /dbScript/cellobject.sql


Revision: 284
Author: Zewi
Date: 10:21:06 PM, Thursday, June 21, 2007
Message:
zewi---I think starter items work now...
Reminder only Starter iteams for Artisain are in right now...so this is for testing!!!
----
Modified : /dbScript/swgprecu.1.sql
Modified : /src/shared/Database.cpp


Revision: 283
Author: Zewi
Date: 8:14:11 PM, Thursday, June 21, 2007
Message:
quick starter item fix.. 
----
Modified : /dbScript/swgprecu.1.sql


Revision: 282
Author: Zewi
Date: 7:56:12 PM, Thursday, June 21, 2007
Message:
Zewi---staring a new Item_Template with names. Artisain is done.. there are no crashes(someitmes the client will
crash(very rare only happend once with a charester that doesnt start with starter items,, but not the server.) However, the Rodain Male,Human Female,Bothan male and Feamle, Ithorian Male and Female.. do not crash 
the server like it did before.. However, they dont start with their starter items!! More then likley something in the code.
                                   ONLY AT THIS TIME MAKE AN ARTISAIN!!! NOTHING ELSE!!!!!
----
Modified : /dbScript/swgprecu.1.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 281
Author: ead
Date: 12:51:22 AM, Thursday, June 21, 2007
Message:
ROLL BACK TO 207 
A CERTAN PERSON HAS MEARLY PUT THERE CODE RIGHT BACK IN AFTER ROLL BACKS  REBREAKING THE SAME SHIT OVER AND OVER AND THE SOURCE OF ALL THE MEMORY LEAKS HEAP CORRPUT  STACK BREAKING  BULLSHIT AND EVERYTHING LEADS BACK TO SAME SAYED PERSON WHO IS HAVING SOME ACCOUNT PROBLEMS NOW 
MEANMON13 ZEWI NOGARD EAD LORDCORM
----
Modified : /ProjectFiles/SWGPreCU.sln
Modified : /ProjectFiles/SWGPreCU.vcproj
Modified : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Deleted : /Release
Deleted : /Weather Client
Added : /dbScript/BuildingDeeds.4.sql(Copy from path: /dbScript/BuildingDeeds.4.sql, Revision, 207
Deleted : /dbScript/Deeds.sql
Deleted : /dbScript/Terminals.sql
Added : /dbScript/cellobject.sql(Copy from path: /dbScript/cellobject.sql, Revision, 207
Deleted : /dbScript/filter.ods
Modified : /dbScript/static_npcs.3.sql
Modified : /dbScript/swgprecu.1.sql
Modified : /dbScript/swgprecu.sql.changelog.txt
Deleted : /dbScript/tickettable.sql
Added : /smap/Debug/BuildLog.htm(Copy from path: /smap/Debug/BuildLog.htm, Revision, 207
Added : /smap/Debug/mt.dep(Copy from path: /smap/Debug/mt.dep, Revision, 207
Deleted : /smap/Debug/smap.exe
Added : /smap/Debug/stree.exe(Copy from path: /smap/Debug/stree.exe, Revision, 207
Added : /smap/Debug/stree.exe.intermediate.manifest(Copy from path: /smap/Debug/stree.exe.intermediate.manifest, Revision, 207
Added : /smap/Debug/stree.map(Copy from path: /smap/Debug/stree.map, Revision, 207
Added : /smap/Release/BuildLog.htm(Copy from path: /smap/Release/BuildLog.htm, Revision, 207
Deleted : /smap/Release/smap.exe
Added : /smap/Release/vc80.idb(Copy from path: /smap/Release/vc80.idb, Revision, 207
Modified : /smap/main.cpp
Deleted : /smap/smap.ncb
Modified : /smap/smap.sln
Modified : /smap/smap.suo
Deleted : /smap/smap.vcproj
Deleted : /smap/smap.vcproj.LANMASTERCMD.pat.user
Added : /smap/stree.ncb(Copy from path: /smap/stree.ncb, Revision, 207
Added : /smap/stree.vcproj(Copy from path: /smap/stree.vcproj, Revision, 207
Added : /smap/stree.vcproj.LANMASTERCMD.pat.user(Copy from path: /smap/stree.vcproj.LANMASTERCMD.pat.user, Revision, 207
Modified : /src/LoginServer/PacketFactory.cpp
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/PacketFactory.h
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/ZoneServer/ZoneServer.cpp
Modified : /src/ZoneServer/ZoneServer.h
Modified : /src/ZoneServer/admin.cpp
Modified : /src/shared/Common.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h
Modified : /src/shared/config.cpp
Modified : /src/shared/opcodes.h
Modified : /src/shared/tlog.cpp


Revision: 280
Author: maach_ine
Date: 7:46:42 PM, Wednesday, June 20, 2007
Message:
A couple of bug squashes.  Moved some database query code that was outside of the database into the database.  Added a raceIndex int to the ZoneClient for use when we are looking up data by the array position of the character race.

****** STARTER ITEMS ARE TOTALLY BROKEN IN THIS COMMIT PENDING A COMMIT BY INTERESTING *******

****** MULTI-ZONE IS CONFIRMED BROKEN IN THIS AND EARLIER COMMITS FOR MOST SPECIES!!  ONLY CONFIRMED WORKING SPECIES IS HUMAN MALE!!! PRIORITY 1 TOFIX!!! ******
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 279
Author: plasmaflow
Date: 12:29:05 PM, Wednesday, June 20, 2007
Message:
All changes have been documented in the change logs.
All changes have been tested to work.
No changes to Database Structure or data.

Changes as follows

HandleZone.cpp
Added gm = LoadedPlayerInfo.gm; in HANDLE_SelectCharacter to set the Zclient Global gm to tell if a player is a gm or not.

ZoneClient.h
Added bool gm; to Zclient::


Database.cpp
Added Function StaticNPC AddStaticNPC(StaticNPC _npcData); // This function adds a new Static NPC To the Static NPCS Table.
						Changed GetPlayerData to get if the player is a gm or not this also adds the tag of [GM]or [DEV] to the players name.
						To dawn the new tag you need to set your account gm setting to: 0=not GM, 1=GM 2=DEV This will also set a global for the
						client called gm which is a boolean to determine if the player is a gm or not.
						Added Function Terminal AddTerminal(Terminal _terminalData);//This function adds a new Terminal to the Terminals Table.

Database.h
Added Function int AddStaticNPC(StaticNPC _npcData); // This function adds a new Static NPC To the Static NPCS Table.
						Terminal AddTerminal(Terminal _terminalData);//This function adds a new Terminal to the Terminals Table.

ObjControllers.cpp

					 Added new & Commands  &Place with sub command npc, terminal, building, lair
					 These commands allow for a gm to place any of these using his own coords and orientation
					 they also take a first name or last name and deal with the object being placed inside or
					 outside a cell. This will speed up the population of databases since placing an object
					 in the world saves it to the database and spawns the item automatically.
					 Added &help command to list available commands. When adding more commands to the help list
					 add new messages in no more than 2 full lines of text or it causes a client crash.
----
Modified : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 278
Author: Zewi
Date: 10:59:58 AM, Wednesday, June 20, 2007
Message:
houses work again/deeds!
----
Modified : /dbScript/swgprecu.1.sql


Revision: 277
Author: Zewi
Date: 10:45:03 AM, Wednesday, June 20, 2007
Message:
finished starter item deed proplm.. still places a bank!!
----
Modified : /dbScript/swgprecu.1.sql


Revision: 276
Author: maach_ine
Date: 9:52:35 AM, Wednesday, June 20, 2007
Message:
Recommit, and a bug fix in what I wrote earlier.  Previously, if there were no ticket destinations, we would crash getting the first destination.

Notes from original commit follow.

Fixed memory leakage in PacketFactory functions BUILD_EnterTicketPurchaseModeMessage and BUILD_PlanetTravelPointListResponse.

Both were creating 2 lists using "new" without deleting them afterward.  Now they create only 1 "new" list, which is deleted afterwards.

Updated HandleZone function HANDLE_PlanetTravelListRequest -- it will now read the planet name from the packet, determine the planet ID that the name matches up with, and then set a variable so that we send back appropriate data.
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 275
Author: Zewi
Date: 3:21:10 AM, Wednesday, June 20, 2007
Message:
 Zewi Updated the starter item to spawn house if u look at the swgprecu squl file and went down to the 
starter items u would notice that the last zero is for deeds `deed_id` int not null,  it was zero when u have a deed the
number needs to be 1.. so instead of this INSERT INTO `starter_items` VALUES( 7, 'crafting_artisan', 101601749, 9288, 0, 0, 0, 0, 0);
it needed to be this INSERT INTO `starter_items` VALUES( 7, 'crafting_artisan', 101601749, 9288, 0, 0, 0, 0, 1);  However u dont spawn 
a house u spawn soemthing else, I have looked into the DEEDS sql and have checked that and everything is right number 9288(from the Item_template
is the correct number for Naboo small house style.02 so i do not no what the proplem is unless numbers are off some where!!! or hard coded!!
it worked once when this was first implemented but someone complied over the ones with a zero or the one(1) was never implemented So the house deed works
but it is not spawing a naboo house it spawns a bank.. more then lilkly this is harded coded!!!
----
Modified : /dbScript/swgprecu.1.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 274
Author: ead
Date: 2:18:45 AM, Wednesday, June 20, 2007
Message:
ROLLBACK TO 258 DUE TO BROKEN STUFF
DEEDS BROKEN 
CLOHTING/STARTER ITEMS BROKEN
AN @ COMMAND WAS ADDED
DECISION BY MEANMON ZEWI EAD
----
Added : /Documents/Database Item Documentation.txt(Copy from path: /Documents/Database Item Documentation.txt, Revision, 258
Added : /Documents/[GUIDE]Getting started (Setting up your server).URL(Copy from path: /Documents/[GUIDE]Getting started (Setting up your server).URL, Revision, 258
Deleted : /dbScript/Deeds.5.sql
Modified : /dbScript/LoadOrder.txt
Deleted : /dbScript/Terminals.4.sql
Added : /dbScript/Terminals.sql(Copy from path: /dbScript/Terminals.sql, Revision, 258
Modified : /dbScript/static_npcs.3.sql
Modified : /dbScript/swgprecu.1.sql
Modified : /dbScript/swgprecu.sql.changelog.txt
Deleted : /dbScript/tickettable.6.sql
Added : /dbScript/tickettable.sql(Copy from path: /dbScript/tickettable.sql, Revision, 258
Modified : /src/LoginServer/SWGPreCU_Login.cpp
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h
Modified : /src/shared/config.cpp
Modified : /src/shared/config.h


Revision: 273
Author: Zewi
Date: 1:33:41 AM, Wednesday, June 20, 2007
Message:
Updated the starter item to spawn house if u look at the swgprecu squl file and went down to the 
starter items u would notice that the las zero is for deeds `deed_id` int not null, will it was zero when u have a deed the
number needs to be 1.. so instead of this INSERT INTO `starter_items` VALUES( 7, 'crafting_artisan', 101601749, 9288, 0, 0, 0, 0, 0);
it needed to be this INSERT INTO `starter_items` VALUES( 7, 'crafting_artisan', 101601749, 9288, 0, 0, 0, 0, 1);  However u dont spawn 
a house u spawn soemthing else, I have looked into the DEEDS sql and have checked that and everything is right number 9288 is the correct 
number for Naboo small house style.02 so i do not no what the proplem is unless numbers are off some where!!! or hard coded!!
it wored once when this was first implemented but someone compied over the ones with a zero or the one was never implemented So the house deed works
but it is not spawing the right thing.
----
Modified : /dbScript/swgprecu.1.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 272
Author: maach_ine
Date: 10:13:57 PM, Tuesday, June 19, 2007
Message:
Fixed memory leakage in PacketFactory functions BUILD_EnterTicketPurchaseModeMessage and BUILD_PlanetTravelPointListResponse.

Both were creating 2 lists using "new" without deleting them afterward.  Now they create only 1 "new" list, which is deleted afterwards.

Updated HandleZone function HANDLE_PlanetTravelListRequest -- it will now read the planet name from the packet, determine the planet ID that the name matches up with, and then set a variable so that we send back appropriate data.
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 271
Author: plasmaflow
Date: 2:24:08 PM, Tuesday, June 19, 2007
Message:
All changes have been documented in the change logs.
All changes have been tested to work.
No changes to Database Structure or data.

Changes as follows

config.cpp
Updated default login server port from 44457 to 44453

HandleZone.cpp
Added gm = LoadedPlayerInfo.gm; in HANDLE_SelectCharacter to set the Zclient Global gm to tell if a player is a gm or not.

ZoneClient.h
Added bool gm; to Zclient::


Database.cpp
Added Function StaticNPC AddStaticNPC(StaticNPC _npcData); // This function adds a new Static NPC To the Static NPCS Table.
						Changed GetPlayerData to get if the player is a gm or not this also adds the tag of [GM]or [DEV] to the players name.
						To dawn the new tag you need to set your account gm setting to: 0=not GM, 1=GM 2=DEV This will also set a global for the
						client called gm which is a boolean to determine if the player is a gm or not.
						Added Function Terminal AddTerminal(Terminal _terminalData);//This function adds a new Terminal to the Terminals Table.

Database.h
Added Function int AddStaticNPC(StaticNPC _npcData); // This function adds a new Static NPC To the Static NPCS Table.
						Terminal AddTerminal(Terminal _terminalData);//This function adds a new Terminal to the Terminals Table.

ObjControllers.cpp
Added check to see if player is a GM or not to allow or disallow usage of & commands
					 Added new & Commands  &Place with sub command npc, terminal, building, lair
					 These commands allow for a gm to place any of these using his own coords and orientation
					 they also take a first name or last name and deal with the object being placed inside or
					 outside a cell. This will speed up the population of databases since placing an object
					 in the world saves it to the database and spawns the item automatically.
					 Added &help command to list available commands. When adding more commands to the help list
					 add new messages in no more than 2 full lines of text or it causes a client crash.
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h
Modified : /src/shared/config.cpp


Revision: 270
Author: interesting
Date: 9:37:04 AM, Tuesday, June 19, 2007
Message:
Removed two obsolete document files.
Both were created by me and are no longer up to date.
----
Deleted : /Documents/Database Item Documentation.txt
Deleted : /Documents/[GUIDE]Getting started (Setting up your server).URL


Revision: 269
Author: compileserver
Date: 1:33:04 AM, Tuesday, June 19, 2007
Message:
06-18-07 ead			added login port number support
FIXED DEBUG START ORDER
----
Modified : /src/LoginServer/SWGPreCU_Login.cpp
Modified : /src/shared/config.cpp
Modified : /src/shared/config.h


Revision: 268
Author: compileserver
Date: 11:55:25 PM, Monday, June 18, 2007
Message:
COMMIT BY EAD REMOVED DROP IF EXIST FROM static_npcs.3.sql
----
Modified : /dbScript/static_npcs.3.sql


Revision: 267
Author: compileserver
Date: 11:46:44 PM, Monday, June 18, 2007
Message:
COMMIT BY EAD VIA COMPILE SERVER updated sql file names
----
Modified : /dbScript/LoadOrder.txt
Deleted : /dbScript/Terminals.sql
Added : /dbScript/tickettable.6.sql(Copy from path: /dbScript/tickettable.sql, Revision, 266
Deleted : /dbScript/tickettable.sql


Revision: 266
Author: Zewi
Date: 10:58:45 PM, Monday, June 18, 2007
Message:
fixed Driod/terminal in theed shuttle port #1
----
Modified : /dbScript/Terminals.4.sql
Modified : /dbScript/static_npcs.3.sql


Revision: 265
Author: Zewi
Date: 10:37:40 PM, Monday, June 18, 2007
Message:
updated what sql files to load!!! AGAIN!!!
----
Added : /dbScript/Deeds.5.sql
Added : /dbScript/Terminals.4.sql


Revision: 264
Author: Zewi
Date: 10:33:11 PM, Monday, June 18, 2007
Message:
updated what sql files to load!!!
----
Modified : /dbScript/swgprecu.sql.changelog.txt
Modified : /src/ZoneServer/ObjControllers.cpp


Revision: 263
Author: ead
Date: 8:57:43 AM, Monday, June 18, 2007
Message:
REV 262 REVERT  SMAP IS GETTING MESSED WITH BY SOME OTHER PEACE OF CODE IT WORKS FINE IN THE IDE IN DEBUG BUT WHEN RUN STANDALONE  IT CRASHES  WHILE MALLOCING CELL 198 OF PLANET 0
----
Modified : /Lib/AutoItX3.lib
Modified : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Modified : /debug/ZoneServer/AutoItX3.dll
Modified : /debug/loginserver/AutoItX3.dll
Modified : /smap/Debug/smap.exe
Modified : /smap/Release/smap.exe
Modified : /smap/main.cpp
Modified : /smap/smap.ncb
Modified : /smap/smap.suo
Modified : /smap/smap.vcproj
Modified : /src/ZoneServer/SWGPreCU_Zone.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/ZoneServer/ZoneServer.cpp
Modified : /src/ZoneServer/ZoneServer.h
Modified : /src/shared/AutoIt3.h


Revision: 262
Author: ead
Date: 1:24:58 AM, Monday, June 18, 2007
Message:
06-18-07 EAD	FIXED/ADDED SMAP FUNCTONALTY SMAP IS NOT YET INTGRATED OR WORKING IT MEARLY STARTS AND STOPS WITHOUT ERROR A MEMORY MANAGMENT ERROR STILL EXIST IN OWER PROGRAM  NOT IN SMAP  THAT WAS CAUSING A CRASH WITH SMAPS 500X500 ARRAY  ANY ARRAY ADDED TO THE ZSERVER SINGLETON WILL CAUSE A CRASH IF IT IS BIG ENUFF  THIS WAS A STATICLY MADE ARRAY SMAP[500][500] AND SHULD NEVER CAUSE A PROB CURRENTLY USING MALLOC TO MAKE THE ARRAY SMAP IS DOUBLE POINTER AS A TEMP FIX TELL THE MEMORY LEAK NOT CAUSED BY SMAP CAN BE FOUND
other msic changes to smap project 
updated AutoItX3 ini systems libarys and header to latist version as a atempt to find the memory leak   

the leak i do not beleve to be in autoit as it landed on line 104 config.cpp
	if( (vread[0] == bad[0] && vread[1] == bad[1] && vread[2] == bad[2]) || reconfig)
im guessing the leak just simply shows up in config  but that config is liekly not the source  but that i dont know for shure
----
Modified : /Lib/AutoItX3.lib
Modified : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Modified : /debug/ZoneServer/AutoItX3.dll
Modified : /debug/loginserver/AutoItX3.dll
Modified : /smap/Debug/smap.exe
Modified : /smap/Release/smap.exe
Modified : /smap/main.cpp
Modified : /smap/smap.ncb
Modified : /smap/smap.suo
Modified : /smap/smap.vcproj
Modified : /src/ZoneServer/SWGPreCU_Zone.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/ZoneServer/ZoneServer.cpp
Modified : /src/ZoneServer/ZoneServer.h
Modified : /src/shared/AutoIt3.h


Revision: 261
Author: plasmaflow
Date: 9:40:25 PM, Sunday, June 17, 2007
Message:
Added back function in CanLogin to lowercase the name
of users logging in and store it as lower case only.

All we do is this.

printf("UserName As entered:%s\n",username.c_str());
	for (int i=0;i<username.length();i++)
	{
		username[i]=tolower(username[i]);	
	}
	printf("UserName As Lowered:%s\n",username.c_str());

This has been tested to work with user names that are multi case and names with numbers like TeSt and T3St.

Plasma
----
Modified : /src/shared/Database.cpp


Revision: 260
Author: plasmaflow
Date: 6:42:34 PM, Sunday, June 17, 2007
Message:
Change log update my IDE did not update the notes properly from my notes file
----
Modified : /src/shared/Database.cpp


Revision: 259
Author: plasmaflow
Date: 6:30:09 PM, Sunday, June 17, 2007
Message:
Changed UpdatePlayerPos Function to now save the planet id properly. it also updates the population properly when you move from planet to planet.
----
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/shared/Database.cpp


Revision: 258
Author: ead
Date: 12:06:27 AM, Sunday, June 17, 2007
Message:
smap roll back
----
Modified : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/ZoneServer/ZoneServer.cpp
Modified : /src/ZoneServer/ZoneServer.h
Deleted : /src/ZoneServer/player.h


Revision: 257
Author: meanmon13
Date: 12:05:46 AM, Sunday, June 17, 2007
Message:
smap commit -- too be reverted
----
Modified : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/ZoneServer/ZoneServer.cpp
Modified : /src/ZoneServer/ZoneServer.h
Added : /src/ZoneServer/player.h


Revision: 256
Author: ead
Date: 11:36:51 PM, Saturday, June 16, 2007
Message:
smap roll back 
----
Modified : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Modified : /smap/smap.ncb
Modified : /smap/smap.suo
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/ZoneServer/ZoneServer.cpp
Modified : /src/ZoneServer/ZoneServer.h
Deleted : /src/ZoneServer/player.h
Modified : /src/shared/Common.h


Revision: 255
Author: meanmon13
Date: 9:46:19 PM, Saturday, June 16, 2007
Message:
smap commit -- too be rolled back
----
Modified : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Modified : /smap/smap.ncb
Modified : /smap/smap.suo
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/ZoneServer/ZoneServer.cpp
Modified : /src/ZoneServer/ZoneServer.h
Added : /src/ZoneServer/player.h
Modified : /src/shared/Common.h


Revision: 254
Author: ead
Date: 7:41:23 PM, Saturday, June 16, 2007
Message:
fixed smap project
----
Modified : /smap/Release/smap.exe
Added : /smap/smap.ncb
Modified : /smap/smap.sln
Modified : /smap/smap.suo
Added : /smap/smap.vcproj
Added : /smap/smap.vcproj.LANMASTERCMD.pat.user


Revision: 253
Author: meanmon13
Date: 7:16:35 PM, Saturday, June 16, 2007
Message:
found issue with 247... the planet id of the player was not being saved right when using the &travel command... I am unable to fix this because i cannot change how the position update saves planet ids... thus &travel only works for the planet the player is currently on... fix how position update saves planet id and interplentary travel will again be possible
----
Modified : /src/LoginServer/PacketFactory.cpp
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 252
Author: ead
Date: 6:23:43 PM, Saturday, June 16, 2007
Message:
removal of rev 247
----
Modified : /Release/PingServer/BuildLog.htm
Modified : /Release/PingServer/PingServer.exe
Modified : /Release/SWGPreCU_Ping.cod
Modified : /Release/SWGPreCU_Ping.obj
Modified : /Release/mt.dep
Modified : /Release/vc80.idb
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/shared/Database.cpp


Revision: 251
Author: ead
Date: 6:05:43 PM, Saturday, June 16, 2007
Message:
fix on termnals  REMOVED  IF EXIST DROP 
preposed changes to word and name filter
----
Modified : /dbScript/Terminals.sql
Added : /dbScript/filter.ods


Revision: 250
Author: lordcorm
Date: 4:30:31 PM, Saturday, June 16, 2007
Message:
Database tickets.
----
Added : /dbScript/tickettable.sql
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 249
Author: Zewi
Date: 2:35:06 PM, Saturday, June 16, 2007
Message:
Added more trainers to the Static NPC SQL file Thanks to Interesting for helping getting location's
----
Modified : /dbScript/Terminals.sql
Modified : /dbScript/static_npcs.3.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 248
Author: nogard
Date: 1:44:59 PM, Saturday, June 16, 2007
Message:
Fxied Zewi cry baby tantrum...
----
Modified : /Weather Client/SWGWeather.exe
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/admin.cpp


Revision: 247
Author: meanmon13
Date: 1:21:12 PM, Saturday, June 16, 2007
Message:
as per Zewi's request i added in an in-game command for easy travel

the command is "&travel" proper usage is "&travel (local or planet_id) x z y"

NOTE: shuttles will practically be a cut and paste job of the &travel command code
----
Modified : /Release/PingServer/BuildLog.htm
Modified : /Release/PingServer/PingServer.exe
Modified : /Release/SWGPreCU_Ping.cod
Modified : /Release/SWGPreCU_Ping.obj
Modified : /Release/mt.dep
Modified : /Release/vc80.idb
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/shared/Database.cpp


Revision: 246
Author: Zewi
Date: 1:46:30 AM, Saturday, June 16, 2007
Message:
Fixed Static NPC's and Terminal SQL. Per Lords Request
----
Modified : /dbScript/Terminals.sql
Modified : /dbScript/static_npcs.3.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 245
Author: lordcorm
Date: 1:37:47 AM, Saturday, June 16, 2007
Message:
fix saving possission, step 1 of tickets
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/shared/Common.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 244
Author: nogard
Date: 9:16:22 PM, Friday, June 15, 2007
Message:

----
Modified : /src/ZoneServer/HandleZone.cpp


Revision: 243
Author: nogard
Date: 8:00:25 PM, Friday, June 15, 2007
Message:
Reverted back...
----
Modified : /Weather Client/README.txt
Modified : /Weather Client/SWGWeather.exe
Deleted : /Weather Client/VText.dll


Revision: 242
Author: nogard
Date: 7:54:00 PM, Friday, June 15, 2007
Message:
Added missing DLL
----
Modified : /Weather Client/README.txt
Added : /Weather Client/VText.dll


Revision: 241
Author: nogard
Date: 7:48:15 PM, Friday, June 15, 2007
Message:
Added Config Files and Such dont work 100% yet
----
Added : /Weather Client/Config
Added : /Weather Client/Config/Config.CFG
Modified : /Weather Client/SWGWeather.exe


Revision: 240
Author: nogard
Date: 7:30:09 PM, Friday, June 15, 2007
Message:
Opps forgot to add a file
----
Added : /Weather Client/MSWINSCK.OCX
Modified : /Weather Client/README.txt


Revision: 239
Author: nogard
Date: 7:23:38 PM, Friday, June 15, 2007
Message:
Added Abunch of stuff
added Weather Client/SWGWeather.exe for chaning NABOO ONLY atm but it does change them all program wise. must be on you pc atm untill i write the InitSocket
added /pickup 
/drop
/open
/flourish 
music and dance works .
----
Added : /Weather Client
Added : /Weather Client/EARTH.ICO
Added : /Weather Client/README.txt
Added : /Weather Client/SWGWeather.exe
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/PacketFactory.h
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/ZoneServer/ZoneServer.cpp
Modified : /src/ZoneServer/ZoneServer.h
Modified : /src/ZoneServer/admin.cpp
Modified : /src/shared/opcodes.h


Revision: 238
Author: Zewi
Date: 7:03:18 PM, Friday, June 15, 2007
Message:

----
Added : /dbScript/Terminals.sql


Revision: 237
Author: Zewi
Date: 6:59:05 PM, Friday, June 15, 2007
Message:
Added Trainers in Naboo Theed(some are facing the wrong way that needs to be fixed) Aslo
Added a Terminals SQl file for Ticket Droids and terminals.
----
Modified : /dbScript/static_npcs.3.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 236
Author: lordcorm
Date: 5:29:42 PM, Friday, June 15, 2007
Message:
for zewi
----
Modified : /src/ZoneServer/HandleZone.cpp


Revision: 235
Author: ead
Date: 1:01:51 AM, Friday, June 15, 2007
Message:
recommited formating changes UPDATE BEFORE YOU COMMIT OR DIE
SMAP WORKS FIXED CRASH  20000 OBJECTS LOADED IN 32Mhz  or 15 miliseconds
----
Deleted : /smap/Debug/BuildLog.htm
Deleted : /smap/Debug/mt.dep
Added : /smap/Debug/smap.exe
Deleted : /smap/Debug/stree.exe
Deleted : /smap/Debug/stree.exe.intermediate.manifest
Deleted : /smap/Debug/stree.map
Deleted : /smap/Release/BuildLog.htm
Added : /smap/Release/smap.exe
Deleted : /smap/Release/vc80.idb
Modified : /smap/main.cpp
Modified : /smap/smap.suo
Deleted : /smap/stree.ncb
Deleted : /smap/stree.vcproj
Deleted : /smap/stree.vcproj.LANMASTERCMD.pat.user
Modified : /src/shared/config.cpp


Revision: 234
Author: maach_ine
Date: 4:09:54 PM, Thursday, June 14, 2007
Message:
Update for Zewi's placing NPCs around the galaxy.

Slightly modified the @warp command to be more useable.  The format MUST still be:

@warp XXXX YYYY ZZZZ
OR
@warp -XXXX -YYYY -ZZZZ
OR
any combination of +- XXXX, YYYY, ZZZZ.

Added:
@planet command

Format MUST be:

@planet II

The planet ID MUST BE 2 characters long, or the zone server will crash.  The planet ID MUST be a positive number, or the client will crash.

NOTE:  The above commands WILL BE REMOVED when Zewi is done with them.  That is why they are not more user friendly.

Updates to the Zone Client:  It is now aware of what planet it should be on.  For purposes of sending the StartScene packet, the client is now aware of it's X,Y,Z co-ordinates earlier in the zoning in process.
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 233
Author: maach_ine
Date: 11:58:19 PM, Wednesday, June 13, 2007
Message:
****** SEMI-STABLE COMMIT ******

DO NOT START A CHAT LINE WITH THE CHARACTER @ AND HAVE "warp" IN THE CHAT LINE OR YOU WILL CRASH THE SERVER UNLESS YOU FOLLOW THE FORMAT LAID OUT BELOW.

This commit is the first step in handling player warping.  The format needed is:

@warp XXXX YYYY ZZZZ

where XXXX, YYYY and ZZZZ are the coordinates we want to warp to.

TODO:  Build the correct packets to send after we update the player's posX, posY, posZ
----
Modified : /src/ZoneServer/ObjControllers.cpp


Revision: 232
Author: lordcorm
Date: 7:19:08 PM, Wednesday, June 13, 2007
Message:
you now can save in cells :) and euip weapons :)
----
Modified : /dbScript/swgprecu.1.sql
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 231
Author: ead
Date: 11:12:54 PM, Tuesday, June 12, 2007
Message:
06-12-07 Ead		cleaned up time format now uses hh:mm:sec
06-12-07 Ead		cleanup of database quarry/connect error message   nolonger will it be hard to read
----
Modified : /src/shared/config.cpp
Modified : /src/shared/tlog.cpp


Revision: 230
Author: ead
Date: 10:54:45 PM, Tuesday, June 12, 2007
Message:
06-12-07 EAD		iStance was not set to 0 on creation   sometimes for pepole
					without  compile option (set values to 0 on start) enabled  would get stuck incapactated
----
Modified : /src/ZoneServer/ZoneClient.cpp


Revision: 229
Author: Zewi
Date: 9:59:05 PM, Tuesday, June 12, 2007
Message:
Added deeds to itmes per lordcorms request!!
----
Modified : /dbScript/static_npcs.3.sql
Modified : /dbScript/swgprecu.1.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 228
Author: lordcorm
Date: 6:31:40 PM, Tuesday, June 12, 2007
Message:

----
Added : /Release
Added : /Release/PingServer
Added : /Release/PingServer/BuildLog.htm
Added : /Release/PingServer/PingServer.exe
Added : /Release/PingServer.exe.intermediate.manifest
Added : /Release/SWGPreCU_Ping.cod
Added : /Release/SWGPreCU_Ping.obj
Added : /Release/mt.dep
Added : /Release/vc80.idb


Revision: 227
Author: lordcorm
Date: 6:08:42 PM, Tuesday, June 12, 2007
Message:
not used any more
----
Deleted : /dbScript/BuildingDeeds.4.sql
Deleted : /dbScript/cellobject.sql


Revision: 226
Author: lordcorm
Date: 6:07:37 PM, Tuesday, June 12, 2007
Message:
Made changes to item handling system.....  a temperary fix for equipping stuff, cell objectsare now handled throw the item table.
----
Added : /dbScript/Deeds.sql
Modified : /dbScript/swgprecu.1.sql
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 225
Author: ead
Date: 10:39:09 PM, Monday, June 11, 2007
Message:
06-11-07 EAD			added lordcorms databasedef.h and set it up moddeed existing ussage of _galaxy_id
----
Modified : /ProjectFiles/SWGPreCU.sln
Modified : /ProjectFiles/SWGPreCU.vcproj
Modified : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 224
Author: ead
Date: 7:58:06 PM, Monday, June 11, 2007
Message:
REVERT TO REV 207
----
Modified : /ProjectFiles/SWGPreCU.sln
Modified : /ProjectFiles/SWGPreCU.vcproj
Modified : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Modified : /dbScript/BuildingDeeds.4.sql
Modified : /dbScript/DevCityBackup.sql
Modified : /dbScript/LoadOrder.txt
Deleted : /dbScript/Planets.6.sql
Deleted : /dbScript/Waypoints.7.sql
Deleted : /dbScript/cellobject.5.sql
Deleted : /dbScript/datapad.sql
Modified : /dbScript/item_template.2.SQL
Modified : /dbScript/static_npcs.3.sql
Modified : /dbScript/swgprecu.1.sql
Modified : /dbScript/swgprecu.sql.changelog.txt
Deleted : /dbScript/tickettable.8.sql
Deleted : /dbScript/tickettable.sql
Added : /smap/Debug/BuildLog.htm(Copy from path: /smap/Debug/BuildLog.htm, Revision, 207
Added : /smap/Debug/mt.dep(Copy from path: /smap/Debug/mt.dep, Revision, 207
Added : /smap/Debug/stree.exe.intermediate.manifest(Copy from path: /smap/Debug/stree.exe.intermediate.manifest, Revision, 207
Added : /smap/Debug/stree.map(Copy from path: /smap/Debug/stree.map, Revision, 207
Modified : /smap/main.cpp
Modified : /smap/smap.suo
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h
Deleted : /src/shared/databasedef.h
Modified : /src/shared/opcodes.h


Revision: 223
Author: ead
Date: 9:05:42 PM, Sunday, June 10, 2007
Message:
06-10-07 EAD			start of name filter rebuild  server works now
fixed build order and start order
PING SERVER SHULD NOT BE BUILT THIS IS CORRECT  
PING SERVER SHULD BE STARTED IN NON DEBUG RELASE MODE  NOMATTER WHAT MODE WE ARE IN
these 2 things are set up properly now
----
Modified : /ProjectFiles/SWGPreCU.sln
Modified : /src/shared/Database.cpp


Revision: 222
Author: lordcorm
Date: 6:35:49 PM, Sunday, June 10, 2007
Message:
Database fixes
----
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h
Modified : /src/shared/databasedef.h


Revision: 221
Author: lordcorm
Date: 5:22:32 PM, Sunday, June 10, 2007
Message:
New SQL update, as ead says do not touch this file without talking to him, YOUR NOT HELPING IF YOUR GOING FAST!
----
Modified : /dbScript/swgprecu.1.sql


Revision: 220
Author: ead
Date: 5:05:08 PM, Sunday, June 10, 2007
Message:
06-10-07 EAD			BROKEN COMMIT FOR MERGE WITH LOARDCORM  
----
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h
Modified : /src/shared/databasedef.h


Revision: 219
Author: maach_ine
Date: 9:32:16 AM, Sunday, June 10, 2007
Message:
FIXED:  Invalid pointer in ZoneServer.vcproj  -- was looking for databasedef.h in the ZoneServer subdirectory instead of the shared subdirectory.

FIXED/PATCHED:  DBConnect::GetPlanets() no longer causes a server crash.  Cause of crash:  Array index out of bounds where i = 128.  Increased size of arrays by 1.
----
Modified : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 218
Author: ead
Date: 4:10:49 AM, Sunday, June 10, 2007
Message:
FORGOT TO ADD FILE databasedef.h
06-09-07 lordcorm		intial commit  to database.cpp to be moved over 
06-09-07 EAD			added row def file for lordcorm     do not use numbers as iterators for rows use the def name now

-- 06-09-07 EAD removed the swg precu master.sql as part of partal code roll back it may be back after cleanup

fixed build order   pingserver is not bulit by default and shuld be built manualy if you need its exe 
----
Added : /src/shared/databasedef.h


Revision: 217
Author: ead
Date: 4:10:18 AM, Sunday, June 10, 2007
Message:
06-09-07 lordcorm		intial commit  to database.cpp to be moved over 
06-09-07 EAD			added row def file for lordcorm     do not use numbers as iterators for rows use the def name now

-- 06-09-07 EAD removed the swg precu master.sql as part of partal code roll back it may be back after cleanup

fixed build order   pingserver is not bulit by default and shuld be built manualy if you need its exe 
----
Modified : /ProjectFiles/SWGPreCU.sln
Modified : /ProjectFiles/SWGPreCU.vcproj
Modified : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Deleted : /dbScript/SWG Pre CU Master.sql
Modified : /dbScript/swgprecu.sql.changelog.txt
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 216
Author: lordcorm
Date: 12:33:31 AM, Sunday, June 10, 2007
Message:
Database Structures for EAD :D
----
Modified : /src/shared/Database.h


Revision: 215
Author: ead
Date: 12:08:25 AM, Sunday, June 10, 2007
Message:
removed 
bDoesQueryExist(string query);
bDidQueryExecute(string query);
rewrote del item and del charater  latter of witch will only set del flag to true
item shuld dump data to a log file before deleat is run
----
Deleted : /smap/Debug/BuildLog.htm
Deleted : /smap/Debug/mt.dep
Deleted : /smap/Debug/stree.exe.intermediate.manifest
Deleted : /smap/Debug/stree.map
Modified : /smap/main.cpp
Modified : /smap/smap.suo
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 214
Author: ead
Date: 7:30:11 PM, Saturday, June 09, 2007
Message:
-- 06-09-07 EAD ADDED del COLUM TO CHARATER  SET TO 1 IF TOON WAS DELEETED
----
Modified : /dbScript/swgprecu.1.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 213
Author: ead
Date: 3:50:43 PM, Saturday, June 09, 2007
Message:
Database.cpp Database.h
fixed canlogin	only uses max of 2 sqlquarrys  encrypt key is recreated in database.cpp at sever start
fixed canlogin	encryption of passwords  works right now
BUG FOUND	DBConnect::GetPlanets()	CAUSES CRASH  commented out its function call
BUG FOUND	DBConnect::InventoryDeed crash if result empty  added if result and fixed result and row names

removed datapad.9.sql  it is integrated with the swgprecu.1.sql

REMOVED  DROP IF EXIST IN ALL SQL FILES

DISTRUCTIVE COMMANDS ARE NOT TO BE AUTOMATED BY SQL FILES  YOU NEED TO STOP AND THINK ABOUT WHAT YOU ARE ABOUT TO DELETE BEFORE YOU DO IT 
DROP COMMANDS ARE NOT ALLOWED IN SQL FILES  FINAL DECISION!!!!!
----
Modified : /dbScript/BuildingDeeds.4.sql
Modified : /dbScript/Planets.6.sql
Modified : /dbScript/Waypoints.7.sql
Modified : /dbScript/cellobject.5.sql
Deleted : /dbScript/datapad.9.sql
Modified : /dbScript/item_template.2.SQL
Modified : /dbScript/static_npcs.3.sql
Modified : /dbScript/swgprecu.1.sql
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 212
Author: lordcorm
Date: 7:44:52 PM, Friday, June 08, 2007
Message:
Fixed the packets for containment message when equiping and unequipping to go to chatrange and not player
----
Modified : /src/ZoneServer/HandleZone.cpp


Revision: 211
Author: plasmaflow
Date: 7:38:30 PM, Friday, June 08, 2007
Message:
Updated sql Files
Change log updated
LoadOrder.txt updated
We have 9 individual files to load as of this commit.

SWG Pre CU Master.sql has been updated and tested to load.
----
Modified : /dbScript/LoadOrder.txt
Modified : /dbScript/SWG Pre CU Master.sql
Added : /dbScript/datapad.9.sql
Modified : /dbScript/swgprecu.sql.changelog.txt
Added : /dbScript/tickettable.8.sql


Revision: 210
Author: lordcorm
Date: 7:15:00 PM, Friday, June 08, 2007
Message:
Updated
--------
Made Datapad db driven so update your DB's with datapad.sql.

Made it so you can equip and unequip items in your inventory and it will save to db.

----
Modified : /dbScript/cellobject.5.sql
Added : /dbScript/datapad.sql
Added : /dbScript/tickettable.sql
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 209
Author: plasmaflow
Date: 4:01:43 PM, Friday, June 08, 2007
Message:
Corrected Alaguerranos retrieval of the coordinates when the new waypoint button on the data pad was pressed. X and Y were inverted.

changed waypoint save function to accept the name of the waypoint since the /way command can pass the name.

/way x y command op codes have been added.
----
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 208
Author: plasmaflow
Date: 3:42:14 PM, Friday, June 08, 2007
Message:
NEW SQL FILES NEEDED TO WORK.

ADDED A NEW SQL MASTER FILE I WILL KEEP UP TO DATE AS NEW TABLES ARISE TO LOAD A SINGLE SCRIPT.

Corrected bug where females would get no items iven if in the template table.

Waypoints table is in.
Planets table is in.
cellobjects 5 file is updates.
LoadOrder.txt updated.

SQL Change log is updated,
----
Modified : /dbScript/BuildingDeeds.4.sql
Modified : /dbScript/DevCityBackup.sql
Modified : /dbScript/LoadOrder.txt
Added : /dbScript/Planets.6.sql
Added : /dbScript/SWG Pre CU Master.sql
Added : /dbScript/Waypoints.7.sql
Added : /dbScript/cellobject.5.sql
Modified : /dbScript/item_template.2.SQL
Modified : /dbScript/swgprecu.1.sql
Modified : /dbScript/swgprecu.sql.changelog.txt
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h
Modified : /src/shared/opcodes.h


Revision: 207
Author: nogard
Date: 3:48:28 AM, Friday, June 08, 2007
Message:
added in OpenContainers and THe Posture update and some goodies 
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/PacketFactory.h
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/opcodes.h


Revision: 206
Author: nelk
Date: 9:57:38 PM, Thursday, June 07, 2007
Message:
crafting logs ftw
----
Added : /Documents/Packets/Crafting/crafting.txt
Added : /Documents/Packets/Crafting/crafting2.txt
Added : /Documents/Packets/Crafting/craftingcopperinc.txt


Revision: 205
Author: Alaguerrano
Date: 5:55:33 PM, Thursday, June 07, 2007
Message:
**First Step to get Create New Waypoint**
By now the zone server console shows, the charID who wants to create a new waypoint, and the coords and planet of the new waypoint.
Changes:
-In opcodes.h Added requestwaypointatposition opcode in CommandQueueEnqueue_CRCs
-In Constants.h Added requestwaypointatposition in PacketIdentifyer CommandQueueEnqueues[]
-In ObjControllers.cpp Added HANDLE_ObjController_CommandQueueEnqueue_requestwaypointatposition function.
By now, it shows in the zone server console the CharacterID who requests the new waypoint, the coords and the planet of the new waypoint.
TODO: Driven from DB. Need a waypoint table. Code the answer to the client from the server.
-In ZoneClient.h Added void HANDLE_ObjController_CommandQueueEnqueue_requestwaypointatposition(ByteBuffer &Packet);
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/opcodes.h


Revision: 204
Author: Interesting
Date: 5:37:10 PM, Thursday, June 07, 2007
Message:
Added the missing CRC.

Thanks zewi.
----
Modified : /dbScript/item_template.2.SQL


Revision: 203
Author: meanmon13
Date: 5:23:17 PM, Thursday, June 07, 2007
Message:
hopefully out of order packets should not be an issue... its a quick fix not a perminate solution but it shouldn't be an issue
----
Modified : /src/ZoneServer/ZoneClient.cpp


Revision: 202
Author: Interesting
Date: 2:36:47 PM, Thursday, June 07, 2007
Message:
Starter items are now named correctly and added to the bottom of the database as plasmaflow suggested.
Final phase will be tomorrow; I'm going to verify the entries and update the starting item table.
----
Modified : /dbScript/item_template.2.SQL


Revision: 201
Author: ead
Date: 10:44:52 PM, Wednesday, June 06, 2007
Message:
06-06-07 EAD FIXED NULLS IN `static_npcs` IE  C++ CANT DO NULLS IT CRASHES THE SERVER  DONT USE THEM PLS  THANKS
----
Modified : /dbScript/static_npcs.3.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 200
Author: Zewi
Date: 9:28:11 PM, Wednesday, June 06, 2007
Message:
fixed naboo player house deed!
----
Modified : /dbScript/swgprecu.1.sql


Revision: 199
Author: Zewi
Date: 8:43:19 PM, Wednesday, June 06, 2007
Message:
building database update
----
Modified : /dbScript/BuildingDeeds.4.sql


Revision: 198
Author: Zewi
Date: 8:37:37 PM, Wednesday, June 06, 2007
Message:
Added to the BuildingDeeds Sql file!
----
Modified : /dbScript/BuildingDeeds.4.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 197
Author: lordcorm
Date: 8:30:07 PM, Wednesday, June 06, 2007
Message:
DB stuff for adding NPC's to cells!
----
Modified : /dbScript/static_npcs.3.sql
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 196
Author: nogard
Date: 7:46:38 PM, Wednesday, June 06, 2007
Message:
added the fixes for lordcorm in SpawnCreature 
buildings should no longer spawn each time a player logs in
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 195
Author: maach_ine
Date: 7:21:19 PM, Wednesday, June 06, 2007
Message:
Bug squashing: 

Fixed client crash when player character list larger than 4 or 5 players.  (Tested for list up to 10 characters long).

We no longer send the character's last name in BUILD_EnumerateCharacterId if the character's last name is " " or a 0-length string.  (Fix for Wookiees)

HANDLE_LoginClusterStatus now sends back the actual status of the Zone Server according to the database (was previously sending back an online status no matter what.)
----
Modified : /src/LoginServer/HandleLogin.cpp
Modified : /src/LoginServer/PacketFactory.cpp


Revision: 194
Author: lordcorm
Date: 6:05:47 PM, Wednesday, June 06, 2007
Message:
Woops forgot the new .sql file for cellobjects. Sorry meanmon for the double commit
----
Added : /dbScript/cellobject.sql


Revision: 193
Author: lordcorm
Date: 6:04:57 PM, Wednesday, June 06, 2007
Message:
Fixed PlasmaFlows function to update player data in the Database.

Added cell object spawning from DB! Player Housing soon! Yay!
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 192
Author: meanmon13
Date: 5:18:31 PM, Wednesday, June 06, 2007
Message:
Housekeeping changes and new system for CommandQueueEnqueue :-D
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/ByteBuffer.cpp
Modified : /src/shared/ByteBuffer.h
Modified : /src/shared/opcodes.h


Revision: 191
Author: plasmaflow
Date: 3:09:20 PM, Wednesday, June 06, 2007
Message:
Dev City File updated first rev before i implement the whole city. Sorry city over water cannot be done. Due to  buildings not meshing up with the platforms over water. When exiting the building on a platform over water you end up in the water.

City is on the cove now.

Default spawn coords will randomize around the new starport.
changed several log entries from printing to the console. will keep on changin more as i can.

Player update now will check if coords are cell based when cell coords are passed i will update the function to save cell instead of world coords.

Npc table contains the ticket droid. Removed the hardcoded npc from code and added it to the npc table.
NOTE NPC TABLE HAS TO BE LOADED

*****BUG******
If an account has 4 characters or more defined the client will crash on login. Aparently enum character will pass something wrong to the client.
----
Modified : /dbScript/DevCityBackup.sql
Modified : /dbScript/static_npcs.3.sql
Modified : /dbScript/swgprecu.sql.changelog.txt
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 190
Author: meanmon13
Date: 3:01:20 PM, Wednesday, June 06, 2007
Message:
ChatSendToRoom is now handled
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/opcodes.h


Revision: 189
Author: maach_ine
Date: 1:45:21 PM, Wednesday, June 06, 2007
Message:
Housekeeping.  Removed a couple of debug printfs that are no longer needed.
----
Modified : /src/ZoneServer/HandleZone.cpp


Revision: 188
Author: Interesting
Date: 12:40:36 PM, Wednesday, June 06, 2007
Message:
Phase 2 of corrections to the starting items. This was done with both zewi, plasmaflow, AND maach's approval. 

Please do not un-do this work, or modify it in any way until I finish phase 3 tomorrow.
----
Modified : /dbScript/item_template.2.SQL


Revision: 187
Author: Interesting
Date: 11:39:45 AM, Wednesday, June 06, 2007
Message:
Deleted all the names from the item table in preparation for adding new entries for starter items.

Talk to plasmaflow before yelling at me :P
----
Modified : /dbScript/item_template.2.SQL


Revision: 186
Author: maach_ine
Date: 11:34:36 AM, Wednesday, June 06, 2007
Message:
Fixed character creation crash.  Issue was:

If a character was created with no hair, we were attempting to read the hair customization data anyway.  This involved creating arrays with invalid lengths, writing data to non-existant arrays, performing replace functions on empty strings, etc.  We now check to see if the hair object exists before we try to read any other hair data.  If there is a hair object, great.  If not, we skip all that.  Every character can now be created, with or without hair (although some currently have no starter items.)
----
Modified : /src/ZoneServer/HandleZone.cpp


Revision: 185
Author: Interesting
Date: 11:09:55 AM, Wednesday, June 06, 2007
Message:
Deleted obsolete table from the dbscript folder.
----
Deleted : /dbScript/starter_items.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 184
Author: Interesting
Date: 9:35:23 AM, Wednesday, June 06, 2007
Message:
Cleaned the change log. Come on people, start being a little more neat when updating it.
----
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 183
Author: meanmon13
Date: 4:15:18 AM, Wednesday, June 06, 2007
Message:
swoops will be destroyed when dismounting... this is a temprarary fix until it can be figured out why remounting does not work
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/PacketFactory.h
Modified : /src/shared/opcodes.h


Revision: 182
Author: meanmon13
Date: 2:33:32 AM, Wednesday, June 06, 2007
Message:
swoop movement test
----
Modified : /src/ZoneServer/ObjControllers.cpp


Revision: 181
Author: meanmon13
Date: 2:13:35 AM, Wednesday, June 06, 2007
Message:
Swoop movement fix :-D
----
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 180
Author: meanmon13
Date: 1:41:40 AM, Wednesday, June 06, 2007
Message:
swoop movment test
----
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 179
Author: meanmon13
Date: 1:27:46 AM, Wednesday, June 06, 2007
Message:
swoop movment test
----
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 178
Author: maach_ine
Date: 1:18:40 AM, Wednesday, June 06, 2007
Message:
Fixed:

Creo3 packet on NPC spawn crashing client.
NPCs having same ham as you.
Fellow players having same HAM as you.
Fellow players having same hair as you (if they did).
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 177
Author: meanmon13
Date: 12:39:56 AM, Wednesday, June 06, 2007
Message:
The swoop that is called from the datapad is now mountable via the /command .... /mount   it can be dismounted via /dismount   it can not be destroyed at the momement soon to be remidied!!! >.< swoop movment should also work
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 176
Author: ead
Date: 11:45:30 PM, Tuesday, June 05, 2007
Message:
added numbers to sql files  IF YOU WANT TO ADD A FILE PEPOLE MUST SOURCE  YOU MUST DO  SQLFILENAME.NUMBER/ORDER.SQL  AND IT MUST BE RUN BY 2 OTHER DEVS FIRST 
----
Added : /dbScript/BuildingDeeds.4.sql(Copy from path: /dbScript/BuildingDeeds.sql, Revision, 175
Deleted : /dbScript/BuildingDeeds.sql
Added : /dbScript/item_template.2.SQL(Copy from path: /dbScript/item_template.SQL, Revision, 175
Deleted : /dbScript/item_template.SQL
Modified : /dbScript/profession_skill_tree.prelemnary.sql
Added : /dbScript/static_npcs.3.sql(Copy from path: /dbScript/static_npcs.sql, Revision, 175
Deleted : /dbScript/static_npcs.sql
Added : /dbScript/swgprecu.1.sql(Copy from path: /dbScript/swgprecu.sql, Revision, 175
Deleted : /dbScript/swgprecu.sql


Revision: 175
Author: nelk
Date: 6:59:31 PM, Tuesday, June 05, 2007
Message:
Added Planetary Map Locations.Rtf
----
Added : /Documents/Packets/NGE
Added : /Documents/Packets/NGE/Planetary Map Locations.Rtf


Revision: 174
Author: nogard
Date: 4:58:35 PM, Tuesday, June 05, 2007
Message:
Added LORDcorms Travel stuff for him to fix and make DB driven
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/PacketFactory.h
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/opcodes.h
Modified : /src/shared/tlog.cpp


Revision: 173
Author: Alaguerrano
Date: 4:20:35 PM, Tuesday, June 05, 2007
Message:
-Third time i have committed my Delete items of Inventory from DB, and from UI.
Please, dont delete my work again. :(
------
Alaguerrano
----
Modified : /src/ZoneServer/ObjControllers.cpp


Revision: 172
Author: maach_ine
Date: 1:19:31 PM, Tuesday, June 05, 2007
Message:
Updated new character start coordinates as per Meanmon.
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 171
Author: maach_ine
Date: 1:16:11 PM, Tuesday, June 05, 2007
Message:
Bugfixes
----
Modified : /dbScript/item_template.SQL
Modified : /dbScript/swgprecu.sql


Revision: 170
Author: plasmaflow
Date: 12:37:03 PM, Tuesday, June 05, 2007
Message:
**** YOU WILL NEED TO LOAD NEW swgprecu.sql FILE ******

We now update player position as we move based on a settable tick counter in each galaxy.
The default value is 10000 in a new column in the database for the galaxy table. column added at the end of the Galaxy table.
Setting default is 10000 but may be settable, recommended not to go below 200 and to be bumped up as more players play in the server or updates may overwhelm the server, also if you don't move no update is done until the player inactivity message is sent. 

Added a new set of resource tables to the main sql file as per maach_ines file.

Added a new File for letting you know what to load so your server works. File name is : LoadOrder.txt
We need to keep this file up to date. Im working on creating a script file that will load all the files for you.

all database changes are documented in the swgprecu.sql.changelog.txt file.

Various routines not used have been removed many have been documented. comments on all change logs have been added. (hope i didnt forget any).

This ocmpile has been tested and is stable needs multizone testing tho.
----
Added : /dbScript/LoadOrder.txt
Modified : /dbScript/swgprecu.sql
Modified : /dbScript/swgprecu.sql.changelog.txt
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 169
Author: maach_ine
Date: 12:17:04 PM, Tuesday, June 05, 2007
Message:
Updated design of ResourceData.sql  based on feedback from Nogard & PlasmaFlow.
----
Modified : /dbScript/ResourceData.sql


Revision: 168
Author: maach_ine
Date: 11:13:06 AM, Tuesday, June 05, 2007
Message:
Upload of Resources .sql file for merging into the main SQL script.  First step in getting spawnable resources, now that we have surveying and are working on crafting.
----
Added : /dbScript/ResourceData.sql


Revision: 167
Author: plasmaflow
Date: 9:27:09 AM, Tuesday, June 05, 2007
Message:
Documented various functions as per eads request.
Corrected problem with names containing ' character.
CreateNewCharacter in Database.cpp now checks for the presence of the ' character and inserts a literal \ so my sql will store the ' as a literal and not interpret it to be a string delimiter.

This check is also done for the character bio where all ' characters will be corrected to be \' when sent to the db.

Updated Dev City file in preparation for Dev City in northen Naboo Cove.

Updated HandleZone.cpp, somone added 60 to the function that requests buildings to be spawned. 
This was being passed SpawnBuilding(((60 * it->sBuildingID)+BUILDINGS_OFFSET),it->sBuildingCRC , it->cellCount, it->oN, it->oS, it->oE, it->oW, it->bX, it->bZ, it->bY);
in HANDLE_SelectCharacter.
SpawnBuilding function already adds 60 to the building id to correct for cell spacing between buildings. if you need to know what the database id of a building is you need to use the following formula.

((sBuildingID - BUILDINGS_OFFSET) / 60)

Login server now sets the population in the db to 0 when booting up.
----
Modified : /src/LoginServer/LoginServer.cpp
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 166
Author: meanmon13
Date: 3:54:17 AM, Tuesday, June 05, 2007
Message:
Swoop spawning is in :-D improved from the last time it was implemented
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/PacketFactory.h
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 165
Author: ead
Date: 12:27:43 AM, Tuesday, June 05, 2007
Message:
ADDED TO DO LIST AND CUPLE CLEANUPS TO Database.cpp 

EACH FUNCTION NOW HAS SOME INFO ON WHATS NEEDED TO MAKE IT MORE READABLE  AND FIGURE OUT PROGRAM FLOW

THIS IS REQUIRED AND WE NEED TO START DOCUMENTING MORE    IF YOUR OUT OF THE LOOP FOR A DAY YOU CAN GET WEEKS BEHIND QUICKLY WITHOUT DOCUMENTAION
----
Modified : /src/shared/Database.cpp


Revision: 164
Author: nelk
Date: 9:50:44 PM, Monday, June 04, 2007
Message:
Breaks for Crafting, Surveying and Vendors(Bazaar)
----
Added : /Documents/Packets/Bazaar/Client-Server/AuctionQueryHeadersMessage.Rtf
Added : /Documents/Packets/Bazaar/Server-Client/AuctionQueryHeadersResponseMessage.Rtf
Added : /Documents/Packets/Crafting
Added : /Documents/Packets/Crafting/ObjControllerMessage_requestcraftingsession.Rtf
Added : /Documents/Packets/Survey
Added : /Documents/Packets/Survey/Break For entire Process
Added : /Documents/Packets/Survey/Break For entire Process/Survey Break.Rtf


Revision: 163
Author: nelk
Date: 6:21:25 PM, Monday, June 04, 2007
Message:
Fixed text error
----
Modified : /Documents/Packets/Bazaar/Server-Client/IsVendorOwnerResponseMessage.Rtf


Revision: 162
Author: lordcorm
Date: 3:30:10 PM, Monday, June 04, 2007
Message:
Added Update to the BuildingDeeds.sql file so it works correctly.
Added parts to the soe disconnect function so it save character positions, Plasma will be taking care of the rest. Also added to the Spawning Packet for SceneStart packet to use the players coords in the database and use the planet_id in the database so it will now load your characters positions from the database and save them after you log out and load the correct planet :D cheers!
----
Modified : /dbScript/BuildingDeeds.sql
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/shared/Database.cpp


Revision: 161
Author: nelk
Date: 3:17:01 PM, Monday, June 04, 2007
Message:
New structure for packet documents added :D
Added what little actual plain text packet documents and structs I had to the folder
----
Added : /Documents/Packets/Bazaar
Added : /Documents/Packets/Bazaar/Client-Server
Added : /Documents/Packets/Bazaar/Server-Client
Added : /Documents/Packets/Bazaar/Server-Client/IsVendorOwnerResponseMessage.Rtf
Added : /Documents/Packets/Client-Server
Added : /Documents/Packets/Client-Server/ObjControllerMessage
Added : /Documents/Packets/Client-Server/ObjControllerMessage/getattributesbatch
Added : /Documents/Packets/Client-Server/ObjControllerMessage/getattributesbatch/getattributesbatch.Rtf
Added : /Documents/Packets/Client-Server/ObjControllerMessage/getattributesbatch/getattributesbatch.doc
Added : /Documents/Packets/Client-Server/ObjControllerMessage/getattributesbatch/getattributesbatch.txt
Added : /Documents/Packets/Misc
Added : /Documents/Packets/Misc/Place_structure.Rtf
Added : /Documents/Packets/Server-Client
Added : /Documents/Packets/Server-Client/AttributeListMessage
Added : /Documents/Packets/Server-Client/AttributeListMessage/AttributeListMessage.Rtf
Added : /Documents/Packets/Server-Client/AttributeListMessage/AttributeListMessage.doc
Added : /Documents/Packets/Server-Client/AttributeListMessage/AttributeListMessage.txt
Added : /Documents/Packets/Server-Client/ErrorMessage
Added : /Documents/Packets/Server-Client/ErrorMessage/ErrorMessage.Rtf
Added : /Documents/Packets/Server-Client/ObjControllerMessage
Added : /Documents/Packets/Server-Client/ObjControllerMessage/CommandAddToQueue
Added : /Documents/Packets/Server-Client/ObjControllerMessage/CommandAddToQueue/CommandAddToQueue.Rtf
Added : /Documents/Packets/Server-Client/ObjControllerMessage/CommandRemoveFromQueue
Added : /Documents/Packets/Server-Client/ObjControllerMessage/CommandRemoveFromQueue/CommandRemoveFromQueue.rtf
Added : /Documents/Packets/Server-Client/PlayClientEffectObjectMessage
Added : /Documents/Packets/Server-Client/PlayClientEffectObjectMessage/PlayClientEffectObjectMessage.rtf
Added : /Documents/Packets/Server-Client/Unknown WTF packets
Added : /Documents/Packets/Server-Client/Unknown WTF packets/Delta Play 1.rtf
Added : /Documents/Packets/Server-Client/Unknown WTF packets/ObjCtrl 1.rtf
Added : /Documents/Packets/ToDo


Revision: 160
Author: nelk
Date: 3:12:04 PM, Monday, June 04, 2007
Message:
Reorder docs
----
Deleted : /Documents/Bazaar
Added : /Documents/Packets


Revision: 159
Author: nelk
Date: 3:00:48 PM, Monday, June 04, 2007
Message:

----
Added : /Documents/Bazaar
Added : /Documents/Bazaar/IsVendorOwnerResponseMessage.Rtf


Revision: 158
Author: lordcorm
Date: 12:16:55 PM, Monday, June 04, 2007
Message:
Added database building spawning from database with right cell counts.
Added cell_num to the BuildingDeeds.sql file to get the right cell count! YAY!
----
Modified : /dbScript/BuildingDeeds.sql
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp


Revision: 157
Author: ead
Date: 9:13:39 PM, Sunday, June 03, 2007
Message:
R0LL BACK TO REV 147 
----
Deleted : /Documents/Bosoa_db_test.xls
Replacing : /dbScript/starter_items.sql(Copy from path: /dbScript/starter_items.sql, Revision, 147
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/PacketFactory.h
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/opcodes.h


Revision: 156
Author: ead
Date: 6:17:01 PM, Sunday, June 03, 2007
Message:
ROLLBACK OF 155 AT MEAMONS REQUEST
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/OverTime.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/PacketFactory.h
Modified : /src/ZoneServer/ZoneClient.h


Revision: 155
Author: meanmon13
Date: 5:48:11 PM, Sunday, June 03, 2007
Message:
swoops can now be spawned and ridden
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/OverTime.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/PacketFactory.h
Modified : /src/ZoneServer/ZoneClient.h


Revision: 154
Author: meanmon13
Date: 2:17:59 PM, Sunday, June 03, 2007
Message:
Submitted Boasa's datapack work... its incomplete but it contains a shit load of data
----
Added : /Documents/Bosoa_db_test.xls


Revision: 153
Author: Interesting
Date: 1:12:00 PM, Sunday, June 03, 2007
Message:
Err..apparently this was the new version of the table. Sorry *blush*.
----
Added : /dbScript/starter_items.sql


Revision: 152
Author: Interesting
Date: 1:10:46 PM, Sunday, June 03, 2007
Message:
Removed my starter item table as it is obsolete and was making the dbscript folder kind of confusing.
----
Deleted : /dbScript/starter_items.sql


Revision: 151
Author: Alaguerrano
Date: 9:16:16 AM, Sunday, June 03, 2007
Message:
**LORDCORM DONT DELETE MY WORK AGAIN!!!!!!!! DO YOU HAVE A PROBLEM WITH ME OR WITH SVN?**
I dont know why Lordcorm in HIS rev 147 COMMITED OBJCONTROLLERS,CPP without before donwload THE SAME FILE FROM rev 146 MINE.
Result: My work of rev 146 dont work. 

PLEASE, BEFORE COMMIT, DOWNLOAD THE LASTEST REV.
THIS IS THE SECOND TIME I SAY YOU THE SAME. THE NEXT TIME YOU WILL MAKE ME WORK TWICE I KILL YOUUUUUUUU!!!!
:P
----
Modified : /src/ZoneServer/ObjControllers.cpp


Revision: 150
Author: meanmon13
Date: 7:30:16 AM, Sunday, June 03, 2007
Message:
Static and Intangable items are now in... this means non tano world items and datapad items now work.... also swoops are in with one exception... the swoop will not spawn :-( its sending the packets but nothing is happening... this needs to be looked into further
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/PacketFactory.h
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 149
Author: ead
Date: 2:51:40 AM, Sunday, June 03, 2007
Message:

----
Deleted : /smap/Debug/main.obj
Deleted : /smap/Debug/stree.ilk
Deleted : /smap/Debug/stree.pdb
Deleted : /smap/Debug/vc80.idb
Deleted : /smap/Debug/vc80.pdb


Revision: 148
Author: nogard
Date: 2:13:21 AM, Sunday, June 03, 2007
Message:
Group Chat Needs to be handle but the id is 1337
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/opcodes.h


Revision: 147
Author: lordcorm
Date: 1:22:07 AM, Sunday, June 03, 2007
Message:
Spawning Buildings from Deeds work now :D Spawning Static NPC's! :D and Credits from DB! :D
Lordcorm is the pwnsauce!
Any question contact me!
----
Modified : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/bin/Debug/log.log
Added : /dbScript/BuildingDeeds.sql
Modified : /dbScript/swgprecu.sql
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/PacketFactory.h
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 146
Author: Alaguerrano
Date: 12:33:01 AM, Sunday, June 03, 2007
Message:
Little fixed with Delete items of inventory from UI.
----
Modified : /src/ZoneServer/ObjControllers.cpp


Revision: 145
Author: Alaguerrano
Date: 12:21:18 AM, Sunday, June 03, 2007
Message:
**Delete Items of inventory from DB and UI**
-In Database.cpp added new bool function named DeleteItem()
This bool function use serial_item, return true if the item have been deleted from DB and false if not.
-In Database.h added bool DeleteItem(uint64 serial_item);
-In ObjControllers.cpp added Change Log for this File.
Added GNU General Public License for this File.
Added case 0xE7AEC4FB: { //Delete Item
Delete the item of inventory from DB and from UI.
//TODO Make a System Message 'Item Deleted' in-game.
----
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 144
Author: nogard
Date: 11:25:00 PM, Saturday, June 02, 2007
Message:
LordcormsStuff
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 143
Author: ead
Date: 10:03:18 PM, Saturday, June 02, 2007
Message:
msic debug additions  SMAP
----
Modified : /smap/Debug/BuildLog.htm
Modified : /smap/Debug/main.obj
Modified : /smap/Debug/mt.dep
Modified : /smap/Debug/stree.exe
Modified : /smap/Debug/stree.ilk
Modified : /smap/Debug/stree.map
Modified : /smap/Debug/stree.pdb
Modified : /smap/Debug/vc80.idb
Modified : /smap/Debug/vc80.pdb
Modified : /smap/main.cpp
Added : /smap/smap.sln
Added : /smap/smap.suo
Modified : /smap/stree.ncb
Deleted : /smap/stree.sln
Deleted : /smap/stree.suo
Modified : /smap/stree.vcproj


Revision: 142
Author: ead
Date: 9:54:47 PM, Saturday, June 02, 2007
Message:
added smap baseline simiworking demo
----
Added : /smap
Added : /smap/Debug
Added : /smap/Debug/BuildLog.htm
Added : /smap/Debug/main.obj
Added : /smap/Debug/mt.dep
Added : /smap/Debug/stree.exe
Added : /smap/Debug/stree.exe.intermediate.manifest
Added : /smap/Debug/stree.ilk
Added : /smap/Debug/stree.map
Added : /smap/Debug/stree.pdb
Added : /smap/Debug/vc80.idb
Added : /smap/Debug/vc80.pdb
Added : /smap/Release
Added : /smap/Release/BuildLog.htm
Added : /smap/Release/vc80.idb
Added : /smap/fptime.h
Added : /smap/main.cpp
Added : /smap/stree.ncb
Added : /smap/stree.sln
Added : /smap/stree.suo
Added : /smap/stree.vcproj
Added : /smap/stree.vcproj.LANMASTERCMD.pat.user


Revision: 141
Author: zewi
Date: 9:01:12 PM, Saturday, June 02, 2007
Message:
All starter Items Have Names!
----
Modified : /dbScript/item_template.SQL
Modified : /dbScript/item_template.ods
Modified : /dbScript/swgprecu.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 140
Author: meanmon13
Date: 6:23:40 PM, Saturday, June 02, 2007
Message:
Players will now be removed from zone when they disconnect 

Also spat text will no longer fully generate an emote when "lol"...etc is
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/PacketFactory.h
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/shared/opcodes.h


Revision: 139
Author: meanmon13
Date: 4:51:21 PM, Saturday, June 02, 2007
Message:
Emotes are in :-D
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/PacketFactory.h
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/opcodes.h


Revision: 138
Author: nogard
Date: 4:42:10 PM, Saturday, June 02, 2007
Message:
Added in Building From deeds
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/PacketFactory.h
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/opcodes.h


Revision: 137
Author: zewi
Date: 4:31:30 PM, Saturday, June 02, 2007
Message:
item_template is now its own MSQl file. 
Starter items are now DONE completly 
----
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 136
Author: zewi
Date: 4:29:53 PM, Saturday, June 02, 2007
Message:

----
Modified : /dbScript/item_template.SQL
Modified : /dbScript/swgprecu.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 135
Author: ead
Date: 2:41:35 PM, Saturday, June 02, 2007
Message:
!!!!!!!!!I WILL CASTRATE ANYONE WHO DOSE NOT WRITE ALL CHANGES IN DETAL DONE TO SQL IN THE CHANGE LOG AND SVN!!!!!!!!!!!!
-- 06-02-07 ead		THE FOLOWING PEPOLE HAVE FAILED TO UPDATE THE SQL LOG AFTER MAKING CHANGES
MEANMON13  MOVED THE ITEM_TEMPLATE OVER TO THE WRONG FILE   AND DIDNT NOTE THE CHANGE ANYWARE
CHANGES HAVE BEEN UNDONE  AS IT SHULD OF NEVER BEEN MOVED OVER 
!!!!!!!!!I WILL CASTRATE ANYONE WHO DOSE NOT WRITE ALL CHANGES IN DETAL DONE TO SQL!!!!!!!!!!!!
----
Modified : /dbScript/swgprecu.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 134
Author: lordcorm
Date: 2:21:55 PM, Saturday, June 02, 2007
Message:
Nogard's InventoryDeed() function to check to see if the item id is a deed :) get us houses NOW! :P
----
Modified : /dbScript/DevCityBackup.sql
Modified : /dbScript/swgprecu.sql
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 133
Author: zewi
Date: 2:19:44 PM, Saturday, June 02, 2007
Message:

----
Modified : /dbScript/item_template.SQL
Modified : /dbScript/item_template.ods
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 132
Author: meanmon13
Date: 1:52:22 PM, Saturday, June 02, 2007
Message:
Weapons can now be spawned :-p Booya!
----
Modified : /dbScript/swgprecu.sql
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/PacketFactory.h


Revision: 131
Author: lordcorm
Date: 11:30:42 AM, Saturday, June 02, 2007
Message:
You will now see other people spawn with there equiped items!
----
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 130
Author: zewi
Date: 2:51:14 AM, Saturday, June 02, 2007
Message:
Starter items, please read Changelog for update!
----
Modified : /dbScript/item_template.ods
Modified : /dbScript/swgprecu.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 129
Author: zewi
Date: 2:03:03 AM, Saturday, June 02, 2007
Message:
starter items update
----
Modified : /dbScript/swgprecu.sql


Revision: 128
Author: lordcorm
Date: 12:56:51 AM, Saturday, June 02, 2007
Message:
fix!
----
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 127
Author: zewi
Date: 12:39:35 AM, Saturday, June 02, 2007
Message:
starter Items
----
Modified : /dbScript/swgprecu.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 126
Author: Alaguerrano
Date: 10:26:54 PM, Friday, June 01, 2007
Message:
**Deleted Character´s items from DB when have been deleted the Chracter in Character Selection**
 Before, when you had been deleted a Character (for expample: character_id=25) from DB in Character Selection, and you made a new Character (With the same character_id like the other old Character), the inventory show twice items, because the old items from the old Character havent been deleted.
Now works correct!!
TODO: In item table from DB it is necessary add galaxy_id field. Now the function DeleteCharacter() use only the field character_id to delete the Character´s items, the correct way it is using both fields: character_id and galaxy_id in item table from DB, because it is possible that there will have two Characters with the same character_id and different galaxy_id.
----
Modified : /src/shared/Database.cpp


Revision: 125
Author: meanmon13
Date: 5:03:29 PM, Friday, June 01, 2007
Message:
Added bitmask support! read the comments in Constants.h for intructions on how to use bitmasks

Fixed the issue with hair...a few other housekeeping changes
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Common.h
Modified : /src/shared/opcodes.h


Revision: 124
Author: plasmaflow
Date: 12:30:17 PM, Friday, June 01, 2007
Message:
The function for adding the starter items needed
to have some safety if we didnt find items to give to the player. The  function now checks to see if items were returned or not.
----
Modified : /src/shared/Database.cpp


Revision: 123
Author: Alaguerrano
Date: 11:05:33 AM, Friday, June 01, 2007
Message:
I dont know why Lordcorm commited rev 115 without before donwload my rev 114.
Result: My work of rev 114 dont work for him. He updated a Database.cpp in rev 115 older, because he didnt download my rev 114 before he updated his rev.
My rev 114 worked perfect "Delete Character from DB, in Character Selection"
PLEASE, BEFORE OF COMMIT, DOWNLOAD THE LASTEST REV.
----
Modified : /src/shared/Database.cpp


Revision: 122
Author: plasmaflow
Date: 9:57:51 AM, Friday, June 01, 2007
Message:
Corrected starter_items.sql file
change log updated.

profession names were saved like

crafting_artisan_novice
the client passes
crafting_artisan

seems _novice suffix is not passed.
----
Modified : /dbScript/starter_items.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 121
Author: plasmaflow
Date: 9:46:28 AM, Friday, June 01, 2007
Message:
various corrections and updates regarding starting items.
column profession was spelled proffesion so sql query did never find items to add to the toons.
Comments on changelog
----
Modified : /dbScript/item_template.SQL
Modified : /dbScript/starter_items.sql
Modified : /dbScript/swgprecu.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 120
Author: meanmon13
Date: 4:40:44 AM, Friday, June 01, 2007
Message:
Fixed the issue with hair not loading at all... problem was that the HAIR_OFFSET was not being applyed to the id.. someone made up an offset that conflicted with the inventory id....

ALSO

zoneserver crashs during login... on lines 861 and 862 of PacketFactory

		QRow = mysql_fetch_row(QResult);
		SpawnItem(it->equiped ,ObjID, it->serial+ITEM_OFFSET, atof(QRow[8]) ," ", QRow[3], QRow[3],0,0,0,1,0,0,0,InventoryID,false,false);

the error is an Access Violation! please fix this because we can not zone currently...

same error accurrs during character creation 
on line 1402 of Database.cpp
	while((IRow = mysql_fetch_row(IResult)) != NULL)

this is on a fresh revision and freshly sources database
----
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 119
Author: meanmon13
Date: 3:17:12 AM, Friday, June 01, 2007
Message:
a small present for Nogard :-p 
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/opcodes.h


Revision: 118
Author: meanmon13
Date: 3:00:40 AM, Friday, June 01, 2007
Message:
SVN freezes when downloading the content of the release folder... deleted till this issue can be fixed
----
Deleted : /Release


Revision: 117
Author: ead
Date: 1:49:59 AM, Friday, June 01, 2007
Message:
05-31-07 PINGSERVER LEAN AND MEAN  BY EAD
will add ini port numbers tomarow this file is finished and shuld not need any major changes
it is optimised as good as it gets
full runtime compile optmisations are in use asm output shows me that it cant get faster not even with asm unless a faster network lib is used
pingserver is set to build to release all the time
----
Modified : /ProjectFiles/PingServer/PingServer.vcproj
Modified : /ProjectFiles/SWGPreCU.sln
Modified : /ProjectFiles/SWGPreCU.vcproj
Added : /Release
Added : /Release/PingServer
Added : /Release/PingServer/AutoItX3.dll
Added : /Release/PingServer/libmysql.dll
Added : /Release/PingServer/zlib1.dll
Deleted : /debug/PingServer
Deleted : /src/PingServer/PingServer.cpp
Deleted : /src/PingServer/PingServer.h
Modified : /src/PingServer/SWGPreCU_Ping.cpp


Revision: 116
Author: meanmon13
Date: 1:23:53 AM, Friday, June 01, 2007
Message:
the nightmare of the 146h spam has been ended... no features added this rev just handling of the 146 to shut it up and make it stop wasting bandwidth
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/PacketFactory.h
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/opcodes.h


Revision: 115
Author: lordcorm
Date: 12:19:51 AM, Friday, June 01, 2007
Message:
starter items!
----
Modified : /dbScript/swgprecu.sql
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 114
Author: Alaguerrano
Date: 10:12:12 PM, Thursday, May 31, 2007
Message:
**Delete Character from DB in Character Selection works 100% :-D**
-In HandleLogin.cpp commented several lines in HANDLE_ClientDeleteCharacter.
-In LoginClient.h added two news variables character_id and galaxy_id.
-In PacketFactory.cpp added new stuff to LClient::BUILD_ServerDeleteCharacter()
-In Database.cpp, the function DeleteCharacter() works 100% and will returns false if the Character have not been deleted and will returns true if the Character have been deleted from DB.
Now the Character is deleted from DB!!! :-D

------------------
Alaguerrano.
----
Modified : /src/LoginServer/HandleLogin.cpp
Modified : /src/LoginServer/LoginClient.h
Modified : /src/LoginServer/PacketFactory.cpp
Modified : /src/shared/Database.cpp


Revision: 113
Author: Nelk
Date: 8:14:45 PM, Thursday, May 31, 2007
Message:

----
Added : /Documents/Radials.xls


Revision: 112
Author: plasmaflow
Date: 12:59:07 PM, Thursday, May 31, 2007
Message:
Corrected SpawnBuilding Function.
This function has to change the incoming sBuildingID
and change it to : 
(((sBuildindID * 60 )+ sBuildingID)+BUILDINGS_OFFSET)
each building needs to be separated in their id by 60.
This obeys the rules of cell spawning.

When spawning a building only pass the Database ID and do not manipulate it.

sql Changelog has been updated.

Added a new SQL file containing the Dev city Buildings.
Includes: Starport, Cantina, Bank, Merchant Tent and a Guild Hall. Also you may be able to find the Downed At-At and the landed Lambda Shuttle.
More to come for the city.

added a new text file called "Cell Sizes.txt" under documents. These values need to be converted to consts if not reference it to be able to spawn a building. Each building has a given cell size. without it, it wont spawn.

PlasmaFlow
----
Added : /Documents/Cell Sizes.txt
Modified : /Documents/[GUIDE]Getting started (Setting up your server).URL
Added : /dbScript/DevCityBackup.sql
Modified : /dbScript/swgprecu.sql.changelog.txt
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 111
Author: plasmaflow
Date: 8:34:41 AM, Thursday, May 31, 2007
Message:
item_template.SQL changes done.
Corrected error where table would not load.
Comments in changelog file.
Added auto increment to items_template table.
----
Modified : /dbScript/item_template.SQL
Modified : /dbScript/swgprecu.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 110
Author: meanmon13
Date: 5:57:45 AM, Thursday, May 31, 2007
Message:
reworked the porject structure to better handle future growth and development. Object Controller Messages are now handled via function pointers... this should speed up handling of chat and movement and in the future will speed up handling of combat packets. Updated the Header_Architecture.ppt file with the two new files... Please have a look at it for an understanding of how they fit into the project. Other housekeeping changes
----
Modified : /Documents/Header_Architecture.ppt
Modified : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Modified : /src/LoginServer/Constants.h
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Added : /src/ZoneServer/ObjControllers.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Added : /src/ZoneServer/PacketFactory.h
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Common.h
Modified : /src/shared/opcodes.h


Revision: 109
Author: ead
Date: 11:00:43 PM, Wednesday, May 30, 2007
Message:
added a space before a comment to fix sql file
----
Modified : /dbScript/swgprecu.sql


Revision: 108
Author: ead
Date: 10:29:17 PM, Wednesday, May 30, 2007
Message:
-- 05-30-07 ead		rewrite of item_template
detales 
item_template is in its own file for size   using assumed inserts insted of full inserts 1/2 its orginal size and 50% faster to insert
removed the item template data dump from main sql file 
----
Modified : /dbScript/item_template.SQL
Added : /dbScript/item_template.ods
Modified : /dbScript/swgprecu.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 107
Author: Alaguerrano
Date: 9:18:39 PM, Wednesday, May 30, 2007
Message:
**Second step to Delete Character from Character Selection**
Now, the server send the correct packet to the client, and show in-game screen "The character have been deleted", but still it is necessary to finish the DB function to deleted from DB.
-In HandleLogin.cpp added new stuff to HANDLE_ClientDeleteCharacter.
-In LoginClient.h added ByteBuffer* BUILD_ServerDeleteCharacter(); 
-In PacketFactory.cpp added LClient::BUILD_ServerDeleteCharacter()
and the correct packet to send to the client. :-D
-In Database.cpp added new bool function named DeleteCharacter()
This bool function by now, always return true like if the Character was deleted from DB.
TODO: Make this function works 100% and will returns false if the Character have not been deleted 
and will returns true if the Character have been deleted.
-In Database.h added bool DeleteCharacter(int character_id, int galaxy_id);
-In opcodes.h added ServerDeleteCharacter opcode.
----
Modified : /src/LoginServer/HandleLogin.cpp
Modified : /src/LoginServer/LoginClient.h
Modified : /src/LoginServer/PacketFactory.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h
Modified : /src/shared/opcodes.h


Revision: 106
Author: Alaguerrano
Date: 7:33:15 PM, Wednesday, May 30, 2007
Message:
**First Step to Delete Character from Character Selection**
-In HandleLogin.cpp added HANDLE_ClientDeleteCharacter, first step to delete Character from Character Selection. From now, only show in console the Character´s Char Id and
Galaxy ID that we want to delete. :)
-In LoginClient.h added Change Log for this File.
And added new stuff to ClientDeleteCharacter, in line 78 and 116.
-In opcodes.h added Added ClientDeleteCharacter opcode.
----
Modified : /src/LoginServer/HandleLogin.cpp
Modified : /src/LoginServer/LoginClient.h
Modified : /src/shared/opcodes.h


Revision: 105
Author: nogard
Date: 7:04:17 PM, Wednesday, May 30, 2007
Message:
Fixed Cell Movement and added item_template.SQL  all the items spawnable are in that ... TODO: Add names for them  Delete all exesting data in the item_template before u add 
----
Added : /dbScript/item_template.SQL
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp


Revision: 104
Author: meanmon13
Date: 6:56:36 PM, Wednesday, May 30, 2007
Message:
ID constants are in USE THEM when spawning items...

#define NPC_OFFSET 25000000
#define BUILDINGS_OFFSET 50000000
#define CELL_ITEM_OFFSET 60000000
#define WORLD_OBJECT_OFFSET 70000000
#define ITEM_OFFSET 100000000

NOTE: the structure_spawn table's id is going to need to increment by 25 :-D This is to handle the building's cell ids
----
Modified : /src/LoginServer/Constants.h
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 103
Author: meanmon13
Date: 3:48:41 PM, Wednesday, May 30, 2007
Message:
Fixed character selection screen and character login stuffs and other good stuff fixes... fixty fix fix fix
----
Modified : /src/LoginServer/Constants.h
Modified : /src/LoginServer/PacketFactory.cpp
Modified : /src/ZoneServer/HandleZone.cpp


Revision: 102
Author: maach_ine
Date: 3:00:15 PM, Wednesday, May 30, 2007
Message:
Starting ham based on character species and starting profession now works!
----
Deleted : /dbScript/starting_ham.sql
Modified : /dbScript/swgprecu.sql
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp


Revision: 101
Author: maach_ine
Date: 2:43:08 PM, Wednesday, May 30, 2007
Message:
Re-fixed starting ham table.
----
Modified : /dbScript/starting_ham.sql


Revision: 100
Author: maach_ine
Date: 2:12:01 PM, Wednesday, May 30, 2007
Message:
Changed some of the values to line up better with what's in the code.
----
Modified : /dbScript/starting_ham.sql


Revision: 99
Author: plasmaflow
Date: 1:46:34 PM, Wednesday, May 30, 2007
Message:
Added variables to control hair object data.
Meanmon or Maach_Ine need to pass the data to the packet.
uint8 * iCharacterCustomHairData;
int iCharacterCustomHairDataLen;
string iCharacterHairObject;
int iCharacterHairObjectLen;

Updated SQL Log file to reflect last changes to the file.
----
Modified : /dbScript/swgprecu.sql.changelog.txt
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 98
Author: Interesting
Date: 1:36:20 PM, Wednesday, May 30, 2007
Message:
Uploaded a table that will tell the client which race/class combination gets how much starting health, action, mind, etc.
Also uploaded some documentation on it.
----
Added : /Documents/RaceID.rtf
Added : /Documents/Starting_HAM_by_species_and_profession.xls
Added : /Documents/ham.txt
Added : /dbScript/starting_ham.sql


Revision: 97
Author: plasmaflow
Date: 11:44:44 AM, Wednesday, May 30, 2007
Message:
Updated Commit sql File updated.
U WILL NEED TO USE THIS FILE
----
Modified : /dbScript/swgprecu.sql


Revision: 96
Author: plasmaflow
Date: 11:42:29 AM, Wednesday, May 30, 2007
Message:
*******NEW SQL FILE IN THIS COMMIT******
        YOU WILL NEED TO LOAD IT
****************************************
New Config file variables added.

Clustering variables to enable clustering.
NOTE CLUSTERING NOT IMPLEMENTED YET TAKE DEFAULTS PLS.
These will enable clustering all other values will be db driven.
int clustering_enabled  = Is it on or off?
int cluster_id = What cluster group does the server belong to?
int cluster_member_id = Who is the server in the cluster?
We now check to see if we want to encrypt the passwords in the db.
int enable_encryption
If we want to encrypt we need to set the encryption key. No longer than 100 chars. it is used to encrypt.
This allows for an encrypted user db to be used somewhere else so long as the keys match.
char encryption_key[100]

We now check for auto registration to be enabled or not.
int auto_registration


Hair Data is now saved to the db.

New SQL columns added to character table.

`custom_data_len` int unsigned default null,
`starting_profession` varchar(255),

Starting profession will save the profession chosen on startup.

BUG FIX
-------
Wookies were being saved with the first name as last name and first name.

Corrected.
----
Modified : /dbScript/swgprecu.sql
Modified : /src/LoginServer/HandleLogin.cpp
Modified : /src/LoginServer/LoginServer.cpp
Modified : /src/PingServer/SWGPreCU_Ping.cpp
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/SWGPreCU_Zone.cpp
Modified : /src/ZoneServer/ZoneServer.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h
Modified : /src/shared/config.cpp
Modified : /src/shared/config.h


Revision: 95
Author: meanmon13
Date: 10:15:33 PM, Tuesday, May 29, 2007
Message:
"Header_Architecture.ppt" has been updated... EVERYONE look @ it for a better understand of the program and how it flows... there will be a quiz!!! Muhahahaha
----
Modified : /Documents/Header_Architecture.ppt
Modified : /ProjectFiles/SWGPreCU.vcproj


Revision: 94
Author: nogard
Date: 10:14:56 PM, Tuesday, May 29, 2007
Message:
Added the Delta's for Creo 6
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/opcodes.h


Revision: 93
Author: maach_ine
Date: 9:34:08 PM, Tuesday, May 29, 2007
Message:
Fixed "the other players" appearance data not showing.
----
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 92
Author: Alaguerrano
Date: 8:29:24 PM, Tuesday, May 29, 2007
Message:
-In Database.cpp added new stuff for Name Filter System. Now the Name Filter System detect if the FullName Character is or not is the same that other FullName Character in DB. If it is the same, dont let to create a new Char with name used for other person.
-In HandleZone.cpp added case 3 for SWITCH with the result of the CheckNewCharacter Function.
This case is when FullName Character is the same that other FullName Character in DB.
TODO:This option must be coded to respond the correct packet to the client. For the moment, use the default QUEUE_ClientCreateCharacterFailed
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/shared/Database.cpp


Revision: 91
Author: zstars
Date: 8:29:06 PM, Tuesday, May 29, 2007
Message:
-Added old memory debugger.
----
Modified : /ProjectFiles/PingServer/PingServer.vcproj
Modified : /ProjectFiles/SWGPreCU.vcproj
Modified : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Added : /src/shared/Debug.cpp
Added : /src/shared/Debug.h


Revision: 90
Author: meanmon13
Date: 6:35:30 PM, Tuesday, May 29, 2007
Message:
added a bool for itmes for loading weapons... weapons haven't been implemented yet
----
Modified : /src/ZoneServer/OverTime.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 89
Author: nogard
Date: 6:21:53 PM, Tuesday, May 29, 2007
Message:
Added the stuff meanmon wanted includes cell movement YAY!
----
Modified : /src/LoginServer/PacketFactory.cpp
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/opcodes.h
Modified : /src/shared/tlog.cpp


Revision: 88
Author: Alaguerrano
Date: 5:51:45 PM, Tuesday, May 29, 2007
Message:
-Fixed problem with Wookiee Race in CheckNewCharacter. Wookiee Race has only FirstName, and the LastName empty now is not a rule to Char Name would be Denied.
Now works perfect with Wookiee Race!!
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 87
Author: nogard
Date: 5:13:05 PM, Tuesday, May 29, 2007
Message:
Fixed Maachs Customization thing ... yeas.. it works
----
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 86
Author: maach_ine
Date: 4:31:06 PM, Tuesday, May 29, 2007
Message:
Fixing what I broke last rev.  Removed customization data, as it severely broke multi-zone.
----
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 85
Author: maach_ine
Date: 4:08:24 PM, Tuesday, May 29, 2007
Message:
WORKING APPEARANCE CUSTOMIZATION DATA!!!

Note to self:  If one is going to change the size of a packet, it is strongly advisable to tell the client the new size, else the client generally crashes.

* Machine smacks himself around a bit with a large trout
----
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 84
Author: maach_ine
Date: 4:02:14 PM, Tuesday, May 29, 2007
Message:
One of these days, I'll learn to upload ALL the files.
----
Added : /src/LoginServer/Constants.h


Revision: 83
Author: maach_ine
Date: 3:40:42 PM, Tuesday, May 29, 2007
Message:
Fixed what was broken last commit.  This is now a working revision.

Change:  We now see the correct species for ourselves when we enter zone.

We can now also see the species of other players correctly.

NOTE:  If the species array index is NOT read properly from the database, the zone server WILL ABSOLUTELY MOST DEFINITELY CRASH, as the array index is being initialized to -1.
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp


Revision: 82
Author: maach_ine
Date: 2:58:55 PM, Tuesday, May 29, 2007
Message:
In-progress commit so that others can test the code.

THIS REVISION MAY NOT BE STABLE!!!

----
Modified : /ProjectFiles/SWGPreCU.vcproj
Modified : /dbScript/swgprecu.sql
Modified : /src/LoginServer/HandleLogin.cpp
Modified : /src/LoginServer/LoginServer.h
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 81
Author: meanmon13
Date: 11:02:47 AM, Tuesday, May 29, 2007
Message:
movment tweak
----
Modified : /src/ZoneServer/OverTime.cpp
Modified : /src/ZoneServer/ZoneClient.cpp


Revision: 80
Author: plasmaflow
Date: 9:36:50 AM, Tuesday, May 29, 2007
Message:
Smooth movement tested to work perfectly.
Server updates population properly
server reads galaxy value from ini file so we can now cluster several servers.
We also now load the local galaxy values from db and set them. Not only the cluster.
Motd is database driven
neew motd column in galaxy table,
u need to load this sql file.
----
Modified : /dbScript/swgprecu.sql
Modified : /src/LoginServer/LoginServer.cpp
Modified : /src/LoginServer/SWGPreCU_Login.cpp
Modified : /src/PingServer/PingServer.cpp
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneServer.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h
Modified : /src/shared/config.cpp
Modified : /src/shared/config.h


Revision: 79
Author: meanmon13
Date: 9:23:40 AM, Tuesday, May 29, 2007
Message:
the players postion should now be updated before sending the updatetransformmessage
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/OverTime.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 78
Author: maach_ine
Date: 9:32:38 PM, Monday, May 28, 2007
Message:
Player HAM values are now read from the database.
----
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 77
Author: meanmon13
Date: 8:47:16 PM, Monday, May 28, 2007
Message:
Movment debug commit... we need to calculate the new postion the player should be at according to their speed and direction and send those new values in the UTM
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/OverTime.cpp
Modified : /src/ZoneServer/ZoneClient.cpp


Revision: 76
Author: meanmon13
Date: 6:27:38 PM, Monday, May 28, 2007
Message:
Comands fix defautl value refinement
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ZoneClient.cpp


Revision: 75
Author: Alaguerrano
Date: 5:52:17 PM, Monday, May 28, 2007
Message:
--Added in Database.cpp, in the function CheckNewCharacter a process to check if FirstName or LastName are empty fields.
--Added in HandleZone.cpp, new stuff in ClientCreateCharacter,
Added case 2 for SWITCH with the result of the CheckNewCharacter Function.
This case is when the Character FirstName or LastName is EMPTY.
TODO:This option must be coded to respond the correct packet to the client. For the moment, use the default QUEUE_ClientCreateCharacterFailed
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/shared/Database.cpp


Revision: 74
Author: meanmon13
Date: 5:33:49 PM, Monday, May 28, 2007
Message:
commmand update
----
Modified : /src/ZoneServer/HandleZone.cpp


Revision: 73
Author: meanmon13
Date: 5:05:30 PM, Monday, May 28, 2007
Message:
ingame commands &rt and &rd
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/OverTime.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 72
Author: Nelk
Date: 3:25:01 PM, Monday, May 28, 2007
Message:
Added the source of the Admin tool to the SVN
Deleted the old folder containing the exe only
----
Deleted : /AdminTool
Added : /Pre-Cu Emu Admin Tool
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/Dialog
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/Dialog/Login.Designer.vb
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/Dialog/Login.resx
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/Dialog/Login.vb
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/Main.Designer.vb
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/Main.resx
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/Main.vb
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/My Project
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/My Project/Application.Designer.vb
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/My Project/Application.myapp
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/My Project/AssemblyInfo.vb
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/My Project/Resources.Designer.vb
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/My Project/Resources.resx
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/My Project/Settings.Designer.vb
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/My Project/Settings.settings
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/Packets
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/Packets/AUTH.vb
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/Packets/ServerWide.vb
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/Parsing
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool.vbproj
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/bin
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/bin/Debug
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/bin/Debug/Pre-Cu Emu Admin Tool.exe
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/bin/Debug/Pre-Cu Emu Admin Tool.pdb
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/bin/Debug/Pre-Cu Emu Admin Tool.vshost.exe
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/bin/Debug/Pre-Cu Emu Admin Tool.xml
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/bin/Debug/ecrypt.dll
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/bin/Debug/log.log
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/bin/Debug/zlib1.dll
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/bin/Release
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/bin/Release/Pre-Cu Emu Admin Tool.exe
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/bin/Release/Pre-Cu Emu Admin Tool.pdb
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/bin/Release/Pre-Cu Emu Admin Tool.rar
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/bin/Release/Pre-Cu Emu Admin Tool.xml
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/bin/Release/ecrypt.dll
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/bin/Release/log.log
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/bin/Release/zlib1.dll
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/ecrypt.dll
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Debug
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Debug/Pre-Cu Emu Admin Tool.exe
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Debug/Pre-Cu Emu Admin Tool.pdb
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Debug/Pre-Cu Emu Admin Tool.vbproj.GenerateResource.Cache
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Debug/Pre-Cu Emu Admin Tool.xml
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Debug/Pre_Cu_Emu_Admin_Tool.Login.resources
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Debug/Pre_Cu_Emu_Admin_Tool.Main.resources
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Debug/Pre_Cu_Emu_Admin_Tool.Resources.resources
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Debug/TempPE
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Debug/TempPE/My Project.Resources.Designer.vb.dll
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Pre-Cu Emu Admin Tool.vbproj.FileList.txt
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Release
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Release/Pre-Cu Emu Admin Tool.exe
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Release/Pre-Cu Emu Admin Tool.pdb
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Release/Pre-Cu Emu Admin Tool.vbproj.GenerateResource.Cache
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Release/Pre-Cu Emu Admin Tool.xml
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Release/Pre_Cu_Emu_Admin_Tool.Login.resources
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Release/Pre_Cu_Emu_Admin_Tool.Main.resources
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Release/Pre_Cu_Emu_Admin_Tool.Resources.resources
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Release/TempPE
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/obj/Release/TempPE/My Project.Resources.Designer.vb.dll
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool/zlib1.dll
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool.sln
Added : /Pre-Cu Emu Admin Tool/Pre-Cu Emu Admin Tool.suo


Revision: 71
Author: lordcorm
Date: 2:17:34 PM, Monday, May 28, 2007
Message:

----
Modified : /dbScript/swgprecu.sql
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 70
Author: lordcorm
Date: 12:22:37 PM, Monday, May 28, 2007
Message:
Made inventory work from DB, dont equip weapons because they will not work yet. Make sure to update you .sql file, i changed the hex numbers in the item_template table to normal decimal numbers for CRC's also changed some other stuff in the .sql
----
Modified : /dbScript/starter_items.sql
Modified : /dbScript/static_npcs.sql
Modified : /dbScript/swgprecu.sql
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 69
Author: meanmon13
Date: 4:25:46 AM, Monday, May 28, 2007
Message:
smooth movment tweak
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/OverTime.cpp


Revision: 68
Author: meanmon13
Date: 3:57:31 AM, Monday, May 28, 2007
Message:
reset creo4 values could have led to issues with smooth movment
----
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp


Revision: 67
Author: meanmon13
Date: 3:34:01 AM, Monday, May 28, 2007
Message:
smooth movment test
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 66
Author: meanmon13
Date: 2:54:18 AM, Monday, May 28, 2007
Message:
smooth movment test
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/OverTime.cpp
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 65
Author: meanmon13
Date: 1:14:01 AM, Monday, May 28, 2007
Message:
Nelk fixed the admin tool and i added server side code to handle it
----
Modified : /AdminTool/Pre-Cu Emu Admin Tool.exe
Modified : /ProjectFiles/PingServer/PingServer.vcproj
Modified : /ProjectFiles/SWGPreCU.vcproj
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/ZoneServer/ZoneServer.cpp
Modified : /src/ZoneServer/ZoneServer.h
Modified : /src/ZoneServer/admin.cpp
Modified : /src/ZoneServer/admin.h


Revision: 64
Author: ead
Date: 11:57:40 PM, Sunday, May 27, 2007
Message:
-- 05-27-07 ead			ADDED base releaseitem_stat_wep item_stat_armor 
detals
added the above 2 tables and most of the stats involved in each
more to come
added wep_id and armor_id  unsigned int to item table   
if null  dont look up the stats table 
if not null use value to look up items stats row
----
Modified : /dbScript/swgprecu.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 63
Author: maach_ine
Date: 10:22:27 PM, Sunday, May 27, 2007
Message:
Readded EncodeSQL, DecodeSQL, QuoteSQL from Core 1 Rev Z as discussed with Meanmon.

Altered character creation string to add values for new database required fields.
----
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 62
Author: ead
Date: 8:03:57 PM, Sunday, May 27, 2007
Message:
roll back to rev 54 at request of meanmon
reson
buggy code put in without testing    causses crahses
broke multizone
broke charater creation
added memory leak

change affecting only /reporoot/src/*.* folder and sub folders
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 61
Author: ead
Date: 7:40:46 PM, Sunday, May 27, 2007
Message:
roll back of rev 60
----
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 60
Author: lordcorm
Date: 6:27:36 PM, Sunday, May 27, 2007
Message:

----
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 59
Author: maach_ine
Date: 5:22:02 PM, Sunday, May 27, 2007
Message:
HAM values of:  Current HAM, MAX HAM, HAM Wounds are now database driven.  Encumberances and other modifiers may be calculated during Zone insertion.
----
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 58
Author: ead
Date: 4:38:51 PM, Sunday, May 27, 2007
Message:
-- 05-27-07 ead 		ADDED professsion_skill_tree.prelemnary.sql
DETALS
this file is a dump of what the datapack team me a someone i cant rember wer working on 
the entire medic profession is in as a example

idea is that
profession table has sktr1-4  each corasponds to a stree id number
stree table has 4 skills that make up that colum of the skill 
each profession can require a skill  or  unlock another skill  same with each skill 
its not compleat   there are no crc's   but  its a great start 
also added the start of xp types  agan its a start  no crcs yet but gives us somthign to work from 
----
Added : /dbScript/profession_skill_tree.prelemnary.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 57
Author: Interesting
Date: 3:59:55 PM, Sunday, May 27, 2007
Message:
Added starting item table for approval.
----
Modified : /Documents/Database Item Documentation.txt
Added : /dbScript/starter_items.sql


Revision: 56
Author: ead
Date: 3:45:34 PM, Sunday, May 27, 2007
Message:
-- 05-27-07 ead			added ham stats to charater table  more stats to come  working on item stats now
DETALS
ADDED COLUMS

MAX HELTH		`h_hea``h_str``h_con`
DAMAGE ON PLAYER	`h_d_hea``h_d_str``h_d_con`
WOUND ON PLAYER		`h_w_hea``h_w_str``h_w_con`
MAX HELTH		`a_act` `a_qui` `a_sta`
DAMAGE ON PLAYER	`a_d_act``a_d_qui``a_d_sta`
WOUND ON PLAYER		`a_w_act``a_w_qui``a_w_sta`
MAX HELTH		`m_mind` `m_foc``m_wil`
DAMAGE ON PLAYER	`m_d_mind``m_d_foc``m_d_wil`
WOUND ON PLAYER		`m_w_mind``m_w_foc``m_w_wil`
ALL UNSIGNED SMALLINT 5
----
Modified : /dbScript/swgprecu.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 55
Author: maach_ine
Date: 11:12:16 AM, Sunday, May 27, 2007
Message:
After consulting with Meanmon on appearance data, got authorization to cut/copy/paste the functions EncodeSQL, DecodeSQL, and QuoteSQL from Core 1 Rev Z into the DBConnect class.  These are PRIVATE functions and are not meant to be used outside the database object.

Appearance data is now being correctly saved in the database, and correctly loaded from it.

TOFIX:  Client crashes when actually sending this appearance data in the CREO3 packet.  A byte by byte comparison of the data the client sends during character creation, and the data the server sends during zoning, reveals that the appearance data is IDENTICAL.

A comparison of our CREO3 packet to a Core 1 CREO3 packet reveals them to be IDENTICAL except:  We send the entire species string where Core 1 does not, our HAM wound update counter is correct, Core 1's was not.

Hackishly added support for different character race toons to be zoned in.  The current implementation is VERY inefficient.  TODO:  Alter the Database's character table:  species_id field.  It is to be a Byte value (or smaller), and will hold the species ID.  Human Male = 0, Human Female = 1, etc. etc.
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 54
Author: meanmon13
Date: 7:40:14 AM, Sunday, May 27, 2007
Message:
smoothed out movment some... fixed issue where the last person spawned was the name sent to everyone else when zoning was finished... a few housekeeping changes... possible fixes to the memory leak.
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 53
Author: meanmon13
Date: 5:48:58 AM, Sunday, May 27, 2007
Message:
created a new function named SpawnFellowPlayer() using this function will result in the spawning of actual players instead of client controlled npcs. Fellow players are finally decent and have titles... this involved changing the SpawnItem() function a little (sorry Lordcorm). Some housekeeping changes... The server has a very small memory leak that could prove to be a big problem if we don't nip it right now... not sure what its related too. Also made movment a little smoother
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/OverTime.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/ZoneServer/ZoneServer.cpp


Revision: 52
Author: lordcorm
Date: 1:53:17 AM, Sunday, May 27, 2007
Message:

----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/shared/Database.cpp


Revision: 51
Author: meanmon13
Date: 1:44:10 AM, Sunday, May 27, 2007
Message:
Added an admin class to be used with the admin tool... also included alpha version of the admin tool... the encryption between the two is not working right atm so it doesn't work.
----
Added : /AdminTool
Added : /AdminTool/Pre-Cu Emu Admin Tool.exe
Added : /AdminTool/ecrypt.dll
Added : /AdminTool/zlib1.dll
Modified : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/ZoneServer/ZoneServer.cpp
Modified : /src/ZoneServer/ZoneServer.h
Added : /src/ZoneServer/admin.cpp
Added : /src/ZoneServer/admin.h


Revision: 50
Author: meanmon13
Date: 10:49:07 PM, Saturday, May 26, 2007
Message:
MOTD and global system messages have been implemented!
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Common.h
Modified : /src/shared/opcodes.h


Revision: 49
Author: meanmon13
Date: 8:58:48 PM, Saturday, May 26, 2007
Message:
fixed issue with recipiant IDs
----
Modified : /src/ZoneServer/OverTime.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/shared/ByteBuffer.cpp
Modified : /src/shared/ByteBuffer.h


Revision: 48
Author: meanmon13
Date: 8:20:28 PM, Saturday, May 26, 2007
Message:
Spatical chat now works
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/OverTime.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/ByteBuffer.cpp
Modified : /src/shared/ByteBuffer.h
Modified : /src/shared/Common.h


Revision: 47
Author: lordcorm
Date: 5:45:30 PM, Saturday, May 26, 2007
Message:

----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 46
Author: meanmon13
Date: 5:25:10 PM, Saturday, May 26, 2007
Message:
movment should be smoother
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/OverTime.cpp


Revision: 45
Author: meanmon13
Date: 4:24:50 PM, Saturday, May 26, 2007
Message:
If all goes well this should be smooth movment
----
Modified : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Modified : /src/ZoneServer/HandleZone.cpp
Added : /src/ZoneServer/OverTime.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/ZoneServer/ZoneServer.cpp
Modified : /src/ZoneServer/ZoneServer.h
Modified : /src/shared/Common.h
Modified : /src/shared/Sockets.h
Deleted : /src/shared/common.cpp


Revision: 44
Author: Interesting
Date: 9:41:08 AM, Saturday, May 26, 2007
Message:
Uploaded Static NPC table, the only NPC we have is hard coded.
----
Added : /dbScript/static_npcs.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 43
Author: ead
Date: 11:40:29 PM, Friday, May 25, 2007
Message:
added asm timmmer function
----
Modified : /src/shared/Common.h
Added : /src/shared/common.cpp


Revision: 42
Author: Alaguerrano
Date: 10:59:08 PM, Friday, May 25, 2007
Message:
**NAME FILTER SYSTEM**
-- In Database.cpp created new function named CheckNewCharacter.
It is called from HANDLE_ClientCreateCharacter() in HandleZone.cpp before it have been created a new char.
It takes the FirstName and LastName values of the new Character, and checks with filter_name table DB
Returns 1 if FirstName or LastName are in filter_name table
Returns 0 if they are not in filter_name table.
It is not a bool function, it is a INT function because the name_response_codes in DB there are more than two options.
This functions it isnt done 100%, the rest of the name_response_codes must be coded.
This is only the first step to a completed name filter system.
-- In Database.h added int CheckNewCharacter(string sFirstName, string sLastName); line 218
-- In HandleZone.cpp added a call to the CheckNewCharacter Function to check the filter name in line 97.
Added a SWITCH with the result of the CheckNewCharacter Function.
Case 0: is when the Character FirstName and LastName is NOT in the filter_name table from DB. Then executes the older New Char Creation System.
Case 1: is when the Character FirstName and LastName IS in the filter_name table from DB.
					         TODO:This option must be coded to respond the correct packet to the client. From now use the default QUEUE_ClientCreateCharacterFailed.
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 41
Author: meanmon13
Date: 6:06:50 PM, Friday, May 25, 2007
Message:
test commit --- movment related
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 40
Author: meanmon13
Date: 5:10:35 PM, Friday, May 25, 2007
Message:
test commit -- movment related
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 39
Author: Interesting
Date: 5:01:34 PM, Friday, May 25, 2007
Message:
Woopsy. Last commit didn't delete my table all the way through.
----
Deleted : /dbScript/spawned_structures.sql


Revision: 38
Author: Interesting
Date: 4:59:43 PM, Friday, May 25, 2007
Message:
Final of the housekeeping changes to the changelog file.
Deleted spawned_structures.sql file now that its been added to the database.
----
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 37
Author: meanmon13
Date: 4:08:58 PM, Friday, May 25, 2007
Message:
another test commit related to movment
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 36
Author: plasmaflow
Date: 3:43:05 PM, Friday, May 25, 2007
Message:
Login server will now upon boot set galaxy status in database to 0 = off line.

Zone Server will now upon boot set galaxy status in database to 2 = on line

Galaxies will be reloaded and status updated upon server receiving a new connection requesting that we enum the cluster.

added a new function SetServerStatus
takes GalaxyID as int and status as int to set status 
of the galaxies in the cluster.
added new function GetServerStatus that takes 1 argument int GalaxyID and returns the curretn state of the galaxy requested. 0=offline 1=loading 2=online.
These status are queried from the database.

Minor changes on some data types on the sql file have been done and logged in the log file.

Spawned Structures sql file added by interesting has been added to the sql file and tested to load properly.
----
Modified : /dbScript/swgprecu.sql
Modified : /dbScript/swgprecu.sql.changelog.txt
Modified : /src/LoginServer/HandleLogin.cpp
Modified : /src/LoginServer/LoginServer.cpp
Modified : /src/LoginServer/PacketFactory.cpp
Modified : /src/PingServer/PingServer.cpp
Modified : /src/ZoneServer/ZoneServer.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 35
Author: meanmon13
Date: 3:33:29 PM, Friday, May 25, 2007
Message:
test commit.. added support for movement.. needs to be tested
----
Modified : /src/LoginServer/PacketFactory.cpp
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/opcodes.h


Revision: 34
Author: Interesting
Date: 10:47:40 AM, Friday, May 25, 2007
Message:
Cleaned up the Changelog a tad, just evened up a few bars of text.
Uploaded a table to handle Admin Spawned world objects. This table is not for player housing.
----
Added : /dbScript/spawned_structures.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 33
Author: plasmaflow
Date: 9:40:54 AM, Friday, May 25, 2007
Message:
Did some minor DB Changes for the appearance data.
Left a comment in the character creation query area in Database.cpp.

Need someone to help me build a byte based query using a char * variable.
----
Modified : /dbScript/swgprecu.sql
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 32
Author: meanmon13
Date: 4:13:57 AM, Friday, May 25, 2007
Message:
did some house keeping changes... a little this... a little that... ohyea btw... mutlizone works :-p Enjoy!!!!!
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 31
Author: meanmon13
Date: 12:25:16 AM, Friday, May 25, 2007
Message:
Test commit
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 30
Author: maach_ine
Date: 4:03:41 PM, Thursday, May 24, 2007
Message:
For PlasmaFlow:  Added the newCharacterCustomizationData pointer to the paramaters list passed to the function DBConnect::CreateNewCharacter.

The database will call it appearanceData.
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 29
Author: maach_ine
Date: 11:14:20 AM, Thursday, May 24, 2007
Message:
All HAM-related entries in the CREO 1, 3, 4, 6 packets are now soft-coded, preparatory to HAM values being stored in the database.

Fixed a minor error related to loading character data from the database.  The code was reporting that the query failed when in fact it succeeded, and reporting that it succeeded when in fact it failed.
----
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 28
Author: plasmaflow
Date: 10:40:55 AM, Thursday, May 24, 2007
Message:
New function added to load a variable and pass all of the data in the character table and place it inside of SpawnPlayer. New function name is GetPlayerData it takes one int as argument and the int must be the ObjID or the character id in the Database.

All values are passed in this variable. so adding the rest to the spawn player function is just a matter of addressing it from the variable as LoadedPlayerData.varname, each subscript has the appropriate data type.
Also change the sql file, types for coordinates in the character table have been changed to float. Decimal was not converting right when the row was read into the PlayerData Variable.
Scale in the sql file was changed to FLOAT as well.

PLASMAFLOW
----
Modified : /dbScript/swgprecu.sql
Modified : /dbScript/swgprecu.sql.changelog.txt
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 27
Author: Alaguerrano
Date: 9:24:27 AM, Thursday, May 24, 2007
Message:
**CREATE NEW ACCOUNT IN DB WORKS**
Fixed the query to create a new account to DB. String sID it is now obsolete with the new hacked station id.
Now creating a new account to DB works correctly.

------------
Alaguerrano
----
Modified : /src/shared/Database.cpp


Revision: 26
Author: meanmon13
Date: 4:12:03 AM, Thursday, May 24, 2007
Message:
Multizone fixed :-D Players should see each other however there will be no movement, no chat.. etc You will only see that a "fellow player" is logged in.
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/shared/ByteBuffer.cpp
Modified : /src/shared/ByteBuffer.h


Revision: 25
Author: ead
Date: 2:37:24 AM, Thursday, May 24, 2007
Message:
fixed build problem and it makes the table right now
----
Modified : /src/shared/Database.cpp


Revision: 24
Author: meanmon13
Date: 2:06:39 AM, Thursday, May 24, 2007
Message:
Fixed issue where an access violation was being thrown... also player posture wasn't being set by the db so we were zoning in incapped.. this has been temp fixed till posture is pulled from the db
----
Modified : /src/ZoneServer/PacketFactory.cpp


Revision: 23
Author: ead
Date: 2:03:38 AM, Thursday, May 24, 2007
Message:
hacked station id so it is = to account_id tell station_id can be fully removed
combined account creation in to the canconnect reducing another sql quarry
----
Modified : /src/shared/Database.cpp


Revision: 22
Author: ead
Date: 1:13:59 AM, Thursday, May 24, 2007
Message:
FIXED ACCOUNT CREATION   REMOVED ANOTHER MYSQL QUARRY   COMBINED  CreateNewUser IN TO CanLogin
----
Modified : /src/shared/Database.cpp


Revision: 21
Author: maach_ine
Date: 12:10:31 AM, Thursday, May 24, 2007
Message:
Soft-coded almost all of the Creo3 packet.  Appearance Data is causing a crash.

Added some private variables to the ZoneClient, and initialized them in the ZoneClient constructor.

Added constants for the 9 parts of the HAM bar, for going through the HAM array.

Added a couple of checks to verify that we have a useable scale and name for the character, whatever else happens.
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 20
Author: nogard
Date: 9:55:31 PM, Wednesday, May 23, 2007
Message:
Nogard's Commit with Some new goodies to make DB driven ...
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/opcodes.h


Revision: 19
Author: ead
Date: 8:41:56 PM, Wednesday, May 23, 2007
Message:
Database.cpp
rewrote account function removed 3 of the 4 mysql quarrys  added much needed comments 
added database function standard instructions
----
Modified : /src/shared/Database.cpp


Revision: 18
Author: meanmon13
Date: 3:29:36 PM, Wednesday, May 23, 2007
Message:
debugging commit
----
Modified : /src/ZoneServer/ZoneClient.cpp


Revision: 17
Author: Interesting
Date: 3:24:09 PM, Wednesday, May 23, 2007
Message:
Added a Chatroom List table.
Updated Item_Template to have the CRC values for the item in order to spawn items faster.
----
Modified : /dbScript/swgprecu.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 16
Author: plasmaflow
Date: 2:19:18 PM, Wednesday, May 23, 2007
Message:
New characters are now saved and pulled properly from db.
also Proper pull of appearance CRC has  been corrected,
?you need to use database included in this commit or else it wont work.
Some fields in database .sql file have been changed.,
Log entries for sql file have been updated.
Character table appearance crc has been chnaged to bigint since toon crc values can be that long.
Source code functions have been changed to match.
Proper Database ID is now returned from CreateNewCharacter function.

PLASMAFLOW
----
Modified : /dbScript/swgprecu.sql
Modified : /dbScript/swgprecu.sql.changelog.txt
Modified : /src/LoginServer/PacketFactory.cpp
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h
Modified : /src/shared/config.cpp
Modified : /src/shared/config.h


Revision: 15
Author: Interesting
Date: 12:14:33 PM, Wednesday, May 23, 2007
Message:
Added a table to track player health and stat information. Specifics in the change log.
Cleaned the change log to make it look pretty.
----
Modified : /dbScript/swgprecu.sql
Modified : /dbScript/swgprecu.sql.changelog.txt


Revision: 14
Author: meanmon13
Date: 10:34:38 AM, Wednesday, May 23, 2007
Message:
You will be able to see anyone that logins in AFTER you. This is a test commit... single zone still works as before
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/ZoneServer/ZoneServer.cpp
Modified : /src/ZoneServer/ZoneServer.h
Modified : /src/shared/Common.h


Revision: 13
Author: meanmon13
Date: 2:37:10 AM, Wednesday, May 23, 2007
Message:
Fixed an access violation issue with packet identification! This issue has been fully debugged :-)
----
Modified : /src/LoginServer/LoginClient.cpp
Modified : /src/LoginServer/LoginClient.h
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 12
Author: meanmon13
Date: 12:57:14 AM, Wednesday, May 23, 2007
Message:
further optimized packet identification and fixed a small bug related to that
----
Modified : /src/LoginServer/LoginClient.cpp
Modified : /src/LoginServer/LoginClient.h
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/ZoneClient.cpp


Revision: 11
Author: meanmon13
Date: 11:40:05 PM, Tuesday, May 22, 2007
Message:
fixed a small issue that was happening when i packet is unhandled
----
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/ZoneClient.cpp


Revision: 10
Author: meanmon13
Date: 6:27:10 PM, Tuesday, May 22, 2007
Message:
Incomming packet identification has been optimized for the zone server! The function IdentifyPacket has been erased in lue of a list of function pointer handlers
----
Modified : /src/LoginServer/LoginClient.h
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 9
Author: meanmon13
Date: 3:21:17 AM, Tuesday, May 22, 2007
Message:
optimized the zone server's packet queue... it now automatically mutlipackets outgoing packets when there is more then 1 packet contained in the queue... as a result zone time should be SIGNIFICANTLY decreased! Instead of sending 40+ individual packets its now only 11 mutlipackets.  
----
Modified : /ProjectFiles/PingServer/PingServer.vcproj
Modified : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 8
Author: ead
Date: 2:56:23 AM, Tuesday, May 22, 2007
Message:
fixed 3 freaky stray values at start of file that dont show up in any editor but hexplorer  and cause mysql panic
----
Modified : /dbScript/swgprecu.sql


Revision: 7
Author: ead
Date: 1:28:00 AM, Tuesday, May 22, 2007
Message:
changed for db compatablty 
removedsGalaxyIPaddress 
added sGalaxyIPWAN sGalaxyIPLAN

DATABASE NOTES\/\/\/\/\/
-- 05-21-07 ead			massive updates fixes and changes   50% done as it sits 
				
-- = == CHANGE  + == ADDED ~ == droped
--	TABLE ACCOUNT
--=ACCOUNT ID     UNSIGNED =
--=USERNAME PASSWORD  LENGHT FROM 20 TO 30 
--=GM TINYINT U
--=BANNED ACTIVE  BINARY 1 
--=joindate lastlogin to timestamp
--+lastlogin added ON UPDATE CURRENT_TIMESTAMP
--	TABLE CHARATER
--=CHARATER ID ACCOUNT ID  GALAXY ID  TO INT UNSIGNED
--=GUILD INSTANCE_ID TO SMALLINT UNSIGNED
--=X Y Z N S E W CELLX CELLY CELLZ CELLON CELLOS CELLOE CELLOW FROM FLOAT TO DECMAL 5,1
--=PLANET_ID LOTS FACTION_ID TO TINYINT UNSIGND
--=APPERANCELEN HAIRLEN TO INT UNSIGNED
--=biography longtext4,294,967,295 characters to text65,535 characters
--=lfg helper roleplayer archived 
--~height   was dupicate of scale
--~profession   wrong format  unplanned unlayed out yet
--	TABLE galaxy
--+ip_lan
--=ip to ip_Wan
--=ip_wan ip_lan to varachar 16
--=zoneport pingport to smallint
--=status max_characters_per_account to tinyint unsignd
--=distance to gmt_time_offset int to tinyint
--=max_characters_per_server to int unsignd
--+active_feature_profile
--	TABLE game_features
--~active_feature_profile
--=id int unsignd
--=min pvp lvl email_gateway_port smallint unsigned
--=flatten_name pvp_only non_combat_pvp_only factional_pvp_only filter_names email_gateway_allowed email_gateway_use_password --=email_gateway_send_cleartextpass email_gateway_system_wide to binary 1
--=locale_value to server_lang
--TABLE item
--+salt int signed
--=container to container_id  this is null unless its a contaner then it corasponds to a container id from container table
--=appearance int100 to int   there is no such thing as int 100  11 is max
--=equipped int to biinary 1
--	TABLE MERGE from item stats
--+cur_condition int unsignd // current condition
--+min_condition // greater than 0 prevents item distruction
--+max condition int unsignd //orginal starting conditon
--+dec_condition int unsignd //standard ammount to decrment  componet of math to find true value  after damage and spetchals are considerd
--stats of a item we arnt ready to do  heavy condsideration must be done before we do stats
--	TABLE DROP item_stats table was merged in to item 
--~droped item_stats
--
--_____________________________________________________________________________________
--
-- -----------------------------------------------------------------------------------------------------
--NOTICE I PLAN TO SPLIT THE DB IN TO MULTIPLE FILES  1 TO A TABLE TO MAKE UPDATEING EASER 
--AND SO ONLY RELEVENT TABLES NEED LOCKED DURING CHANGES EAD
-- -----------------------------------------------------------------------------------------------------
--NOTICE   I EXPECT DETALED LOGS OF ALL CHANGES MADE  SEE MY RECENT CHANGE LOG FOR EXAMPLE 
--  + = ~ ARE SUGESTIONS FOR ADD CHANGE DROP SPELLING EM OUT WILL WORK  
--I JUST WANT TO SEE A LOG OF EVERY CHANGE YOU MAKE YOUR OWN STYLE THAT GETS THE SAME INFO ACROSS WILL WORK JUST MAKE IT LOGICAL
-- COMMITS MISSING A LOG OR NOT LISTING EVERY CHANGE WILL BE ROLLED BACK TO PREVENT THIS FILE FROM BECOMEING A MESS AGAN
--THIS MEANS THE WHOLE COMMIT     AND I KNOW THIS LEVAL OF LOGGING IS INPRACTCAL IN THE SOURCE BUT IN SQL  IT IS REQUIRED
--THANK YOU FOR YOUR ASSTANCE EAD
-- -----------------------------------------------------------------------------------------------------
----
Modified : /dbScript/swgprecu.sql
Added : /dbScript/swgprecu.sql.changelog.txt
Modified : /src/LoginServer/PacketFactory.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 6
Author: Alaguerrano
Date: 9:01:30 PM, Monday, May 21, 2007
Message:
Uppercase in Generate Random Name.
==================================
Added two new string variables in GenerateRandomName() 'String FirstName' and 'String LastName'. These variables have the Generate Random Name and Lastname with the first letter uppercase.
And added the way to change lowercase to uppercase first letter in Generate Radom Name and Lastname.

Now the Generate Random Name works with the first letters uppercase.

----------
Alaguerrano
----
Modified : /src/shared/Database.cpp


Revision: 5
Author: meanmon13
Date: 4:55:50 PM, Monday, May 21, 2007
Message:
The Login Server has now been optimized to the point that you can spam logging in and out so fast that it crashs the client!!

Optimizations include: 
*complete removal of the IdentifyPacket() function... it is now handled by a list that contains function pointers to the functions that handle the variaous packet.
*Mutlipacketing of outgoing packets. Instead of sending 4 seperate packets... they are combined and sent as one.

Some houskeeping changes in the login server
----
Modified : /src/LoginServer/HandleLogin.cpp
Modified : /src/LoginServer/LoginClient.cpp
Modified : /src/LoginServer/LoginClient.h
Modified : /src/ZoneServer/Constants.h
Modified : /src/ZoneServer/PacketFactory.cpp
Modified : /src/ZoneServer/ZoneClient.h


Revision: 4
Author: Alaguerrano
Date: 1:20:10 PM, Monday, May 21, 2007
Message:
*** COMMITTED BY PLASMAFLOW ***

Name Generator is now its own routine and returns a name back to the handler as a string.
----
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/ZoneServer/ZoneClient.cpp
Modified : /src/ZoneServer/ZoneClient.h
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 3
Author: Alaguerrano
Date: 12:37:59 PM, Monday, May 21, 2007
Message:
*** COMMITED BY PLASMAFLOW ***

Name Generator Fix, Will not crash or cause issues.
All Database calls have been moved from Name Gen to Database.cpp and Database.h.

Tested Name Gen to generate names as fast as 6 or more within the same 1/2 second.
----
Modified : /dbScript/swgprecu.sql
Modified : /src/ZoneServer/HandleZone.cpp
Modified : /src/shared/Database.cpp
Modified : /src/shared/Database.h


Revision: 2
Author: Alaguerrano
Date: 5:30:02 PM, Sunday, May 20, 2007
Message:
Fix a problem with Random Name Generator routine. Before, when you tried to generate a Random Name in-game, and make it more of three times, crash the server.
Now fixed, commented the duplicated line 170 in HandleZone.cpp.
----
Modified : /src/ZoneServer/HandleZone.cpp


Revision: 1
Author: meanmon13
Date: 2:39:47 PM, Sunday, May 20, 2007
Message:
Hopefully last svn switch :-\
----
Added : /Documents
Added : /Documents/Approved Char Name Request Decoded.txt
Added : /Documents/Credits.txt
Added : /Documents/Database Item Documentation.txt
Added : /Documents/Denied Char Name Request.txt
Added : /Documents/Header_Architecture.ppt
Added : /Documents/Header_Architecture_rev90.jpg
Added : /Documents/License.pdf
Added : /Documents/License.txt
Added : /Documents/Life of a Login Server Packet.rtf
Added : /Documents/SWGPreCU Packet Documentation.rtf
Added : /Documents/[GUIDE]Getting started (Setting up your server).URL
Added : /Documents/master_opcode_list.txt
Added : /Lib
Added : /Lib/AutoItX3.lib
Added : /Lib/libmysql.dll
Added : /Lib/libmysql.lib
Added : /Lib/libzdll.a
Added : /Lib/mysqlclient.lib
Added : /Lib/mysys-nt.lib
Added : /Lib/regex.lib
Added : /Lib/strings.lib
Added : /Lib/zdll.exp
Added : /Lib/zdll.lib
Added : /Lib/zlib.lib
Added : /Lib/zlib1.exp
Added : /Lib/zlib1.lib
Added : /ProjectFiles
Added : /ProjectFiles/PingServer
Added : /ProjectFiles/PingServer/PingServer.vcproj
Added : /ProjectFiles/SWGPreCU.sln
Added : /ProjectFiles/SWGPreCU.vcproj
Added : /ProjectFiles/ZoneServer
Added : /ProjectFiles/ZoneServer/ZoneServer.vcproj
Added : /dbScript
Added : /dbScript/swgprecu.sql
Added : /debug
Added : /debug/PingServer
Added : /debug/PingServer/AutoItX3.dll
Added : /debug/PingServer/Logs
Added : /debug/PingServer/Logs/CoreLogs
Added : /debug/PingServer/Logs/LoginLogs
Added : /debug/PingServer/Logs/PacketLogs
Added : /debug/PingServer/Logs/PingLogs
Added : /debug/PingServer/Logs/ZoneLogs
Added : /debug/PingServer/libmysql.dll
Added : /debug/PingServer/zlib1.dll
Added : /debug/ZoneServer
Added : /debug/ZoneServer/AutoItX3.dll
Added : /debug/ZoneServer/Logs
Added : /debug/ZoneServer/Logs/CoreLogs
Added : /debug/ZoneServer/Logs/LoginLogs
Added : /debug/ZoneServer/Logs/PacketLogs
Added : /debug/ZoneServer/Logs/PingLogs
Added : /debug/ZoneServer/Logs/ZoneLogs
Added : /debug/ZoneServer/libmysql.dll
Added : /debug/ZoneServer/zlib1.dll
Added : /debug/loginserver
Added : /debug/loginserver/AutoItX3.dll
Added : /debug/loginserver/Logs
Added : /debug/loginserver/Logs/CoreLogs
Added : /debug/loginserver/Logs/LoginLogs
Added : /debug/loginserver/Logs/PacketLogs
Added : /debug/loginserver/Logs/PingLogs
Added : /debug/loginserver/Logs/ZoneLogs
Added : /debug/loginserver/libmysql.dll
Added : /debug/loginserver/zlib1.dll
Added : /src
Added : /src/License.h
Added : /src/LoginServer
Added : /src/LoginServer/HandleLogin.cpp
Added : /src/LoginServer/LoginClient.cpp
Added : /src/LoginServer/LoginClient.h
Added : /src/LoginServer/LoginServer.cpp
Added : /src/LoginServer/LoginServer.h
Added : /src/LoginServer/PacketFactory.cpp
Added : /src/LoginServer/SWGPreCU_Login.cpp
Added : /src/PingServer
Added : /src/PingServer/PingServer.cpp
Added : /src/PingServer/PingServer.h
Added : /src/PingServer/SWGPreCU_Ping.cpp
Added : /src/ScratchPad.h
Added : /src/ZoneServer
Added : /src/ZoneServer/Constants.h
Added : /src/ZoneServer/HandleZone.cpp
Added : /src/ZoneServer/PacketFactory.cpp
Added : /src/ZoneServer/SWGPreCU_Zone.cpp
Added : /src/ZoneServer/ZoneClient.cpp
Added : /src/ZoneServer/ZoneClient.h
Added : /src/ZoneServer/ZoneServer.cpp
Added : /src/ZoneServer/ZoneServer.h
Added : /src/shared
Added : /src/shared/AutoIt3.h
Added : /src/shared/ByteBuffer.cpp
Added : /src/shared/ByteBuffer.h
Added : /src/shared/Common.h
Added : /src/shared/Compression.cpp
Added : /src/shared/Compression.h
Added : /src/shared/Crypto.cpp
Added : /src/shared/Crypto.h
Added : /src/shared/Database.cpp
Added : /src/shared/Database.h
Added : /src/shared/Sockets.h
Added : /src/shared/config.cpp
Added : /src/shared/config.h
Added : /src/shared/crc.cpp
Added : /src/shared/crc.h
Added : /src/shared/opcodes.h
Added : /src/shared/tlog.cpp
Added : /src/shared/tlog.h
Added : /src/shared/zconf.h
Added : /src/shared/zlib.h



</pre>