Difference between revisions of "PreCUSVNInfo"
(New page: 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 I...) |
(No difference)
|
Revision as of 20:31, 6 December 2007
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
