PreCU - Dummy SVN Changes
From SWGANH Wiki
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