how do I start even as Halloween or xmas?
how do I start even as Halloween or xmas?
This is the current recommended setup guide:
https://docs.google.com/document/d/1...AV5il0/preview
Here's some minor/obvious tricks I found so far with server:
loadBalanceShardSpecific.cfg
Remove the 'Ignore' script error from DBServer during launch:
Make sure that Hostrange/IP is set to this if you're Localhost instead of the 192.168xxxxx. You should no longer have to click 'Ignore' on the script error when server is loading up.Code:ServerRole HostRange 127.0.0.1 127.0.0.255 PrimaryRole Cityzone Mission SecondaryRole None End ServerRole HostRange 127.0.0.1 PrimaryRole Cityzone Mission SecondaryRole None Server Command "ChatServer.exe -noreserved" End // Server // Command "AccountServer64.exe" // End End
servers.cfg
Change DefaultAccessLevel 0 to DefaultAccessLevel 10 and every new character you make will have Level 10 GM powers
Check the 'data\server\db\commands.cfg' to see the list of GM commands
It also lets you use /mmm which is a GM Menu
In the Commands list some of the commands require arguments to work, EX:
influence_add ____ (Add Influence aka Money by value)
isvip (Changes account to be VIP)
experience_add ____ (Add Experience by value)
xpdebt_remove ____ (Removes Debt from Player Name)
train ____ (Let's you level up anywhere with Player Name)
respec_grant (Gives you a free GM Respec)
Find //MapServerParams "-debug" and change it to MapServerParams "-nopopup" to make the map popups less annoying. Apparently it removes the script errors when entering certain door missions.
.EXE
On the Score.exe shortcut you use as a client just remove the '-console' if the cmd prompt that opens annoys you.
.BAT
Make a Bat file autolauncher:
cd "E:\COH I25\bin"
start dbserver.exe -zonelaunchers 1
Timeout 16
start launcher64.exe -noversioncheck
exit
Just put the .Bat file in the same folder as the DBServer and Launcher shortcuts
MISC
Apparently the file (account_server.cfg) is actually misnamed; it should be auction_server.cfg in the '\\data\server\db' folder. Found by Discord user, haven't tested.
EDIT:
It looks like 'self' is an accepted parameter for GM Commands instead of Player Name, example:
/train self
/xpdebt_remove self
Last edited by gorkn; 25-04-19 at 09:36 PM.
New info: Put the line Transient 1 line in maps.db for the zones you want to shut down when idle. Otherwise idle cleanup just compacts the working set but doesn't shut down the map.
Account SQL creation page:
<?phpfunction adler32($data)
{
$mod_adler = 65521;
$a = 1;
$b = 0;
$len = strlen($data);
for($index = 0; $index < $len; $index++)
{
$a = ($a + ord($data[$index])) % $mod_adler;
$b = ($b + $a) % $mod_adler;
}
return ($b << 16) | $a;
}
function game_hash_password($authname, $password)
{
$authname = strtolower($authname);
$a32 = adler32($authname);
$a32hex = sprintf('%08s', dechex($a32));
$a32hex = substr($a32hex, 6, 2) . substr($a32hex, 4, 2) . substr($a32hex, 2, 2) . substr($a32hex, 0, 2);
$digest = hash('sha512', $password . $a32hex, TRUE);
return $digest;
}
$authname = "test";
$password = "password";
$id = "1";
if (isset($_POST['authname']) && isset($_POST['password']))
{
$authname = trim($_POST['authname']);
$password = trim($_POST['password']);
$id = trim($_POST['id']);
$hash = bin2hex(game_hash_password($authname, $password));
$sql1 = "INSERT INTO cohauth.dbo.user_account (account, uid, forum_id, pay_stat) VALUES ('$authname', $id, $id, 1014);";
$sql2 = "INSERT INTO cohauth.dbo.user_auth (account, password, salt, hash_type) VALUES ('$authname', CONVERT(BINARY(128),'$hash'), 0, 1);";
$sql3 = "INSERT INTO cohauth.dbo.user_data (uid, user_data) VALUES ($id, 0x0080C2E000D00B0C000000000CB40058);";
$sql4 = "INSERT INTO cohauth.dbo.user_server_group (uid, server_group_id) VALUES ($id, 1)";
print ($sql1."<br>");
print ($sql2."<br>");
print ($sql3."<br>");
print ($sql4."<br>");
echo '<br>';
}
echo '<form method="post" autocomplete="off">';
echo '<span style="display: inline-block; width: 80px;">ID: </span><input name="id" value="'.$id.'"><br>';
echo '<span style="display: inline-block; width: 80px;">Login: </span><input type="text" value="'.$authname.'" name="authname" maxlength=14> <small>(maximum 14 characters; only letters and numbers)</small><br>';
echo '<span style="display: inline-block; width: 80px;">Password: </span><input type="text" value="'.$password.'" name="password" maxlength=16> <small>(between 8 and 16 characters)</small><br>';
echo '<br>';
echo '<input style="display: inline-block; width: 160px;" type="submit" value="Create SQL"></form>';
?>
Also here is Score.exe and bin files:
https://drive.google.com/open?id=1q0...-PEY2X1hyFTxIE
Last edited by Flyer8472; 25-04-19 at 09:50 PM.
Awesome job guys. @Flyer8472 you are the hero of this thread.
Server + Client + Source + Working = win.
All i did is synced copy paste from discord ;) Just watching. And sharing, i did not do anything. All credit is for the awesome discord channel guys! Without them we would have nothing. Literally. :D
Also we dont have the source for the working I25 server, only binaries, so the source is only for I24. What is broken yet.
AND: THere are issues must be fixed, for example the map server is not accepting external LAN connections not even from VPN...
there are smaller issues like base building that has some problems, some quest bugged but very few.... and ect ect... what will be fixed in i24 but this working server is I25 so no source. Sadfully :D So the more intresting source will be the earlyer I24 :D
Oh and: @DevilSpeak it is an epic game we were waiting for some kind of relase like this for more than a Decade now :D It is almost a legend :D Its from a time before microtransactions and the biggest concurence was wow for this game :D it was one of the best games at the time :D It was subscription based, but if you bought it you had all the content :D
Last edited by Flyer8472; 25-04-19 at 11:45 PM.
So I've been all over this thread trying to help and I have a confession - I never played City of Heroes! But my friends loved it. I'm glad we were able to all help each other out and make it work in less than one week :)
Based on the insane popularity of the Discord (I think a few thousand people are playing right now) we should definitely create a section for this game.
In the mean time, I'll set up a server and play CoH for the first time :)
EDIT: OH! And for those of you who want to enable ULTRA SPOON FEED MODE, here's a torrent of a pre-configured VMware VM image from the CoH Discord :)
magnet:?xt=urn:btih:B82416B2F87ABA9805AAECAE099B47DEBF0249E9&dn=Freedom.7z&tr=udp%3a%2f%2ftracker.openbittorrent.com%3a80%2fannounce&tr=udp%3a%2f%2ftracker.opentrackr.org%3a1337%2fannounce
Instructions: (THIS IS FOR LOCAL)
1. Download VMWare Player
2. Add the VM to VMWare Player
3. Once inside of Windows on the VM - Start Menu -> start dbserver -> start launcher
4. On your system, start the client from Score (Cityofheroes\score.exe -patchdir score -patchversion 2019.04.19 -db <VM IP> -noversioncheck
Last edited by ggnorekthx; 26-04-19 at 03:24 AM.
I am trying to set one up locally.. I keep getting an error. I have followed all of the steps in the instructions. Even thought maybe I messed up pretty bad so I uninstalled everything and tried again..
https://imgur.com/a/kiy4VsQ
Double check sa password (you are using password as the password, intentional?) in sql.
- - - Updated - - -
This runs great - gave it a good play through for the last day and so far everything seems to work nicely. Playing locally with the auth server run's pretty smoothly, little waiting on map loads but nothing major at all. Looking forward to the section.
I've gone deep into the GM commands and found out how to get a full list of all Badges. I've compiled this list of all the badges that give/unlock something.
SYNTAX: BadgeName (Ingame Badge Name Hero) (Ingame Badge Name Villain) [Notes about Badge/Accolade]
NOTE: Spawn ingame with /badge_grant ____ EX: '/badge_grant GoldClub'
NOTE: Names sometimes change between Heroes and Villains. Also some of these badge sets give extra badges depending on whether you're Hero or Villain.
NOTE: You can use /badge_remove ____ to remove any badges you add but you will keep the power. EX: '/badge_remove GoldClub' leaves you with 'Pocket D VIP Pass' power even though badge is gone.
InventorAccolade (Field Crafter) [Adds 'Portable Workbench' power]
ArchitectAccolade (Mission Engineer) [Adds 'Architect Comlink' power]
GoldClub (Pocket D VIP Gold Club Member) [Adds 'Pocket D VIP Pass' power]
CreySet (Conspiracy Theorist) [Adds the 'Crey CBX-9 Pistol' power]
HeadlineStealer (Yesterday's News) [Adds 'Stolen Immobilizer Ray' power]
RIWEAccolade (Watchwoman) [Adds 'Elusive Mind' power]
MagusSet (Archmage) (Arch-Mage of Agony) [Adds 'Eye of the Magus' power]
Demonic (Exorcised) (Demonic) [Adds 'Demonic Aura' power]
Megalomaniac (In Therapy) (Megalomaniac) [Adds 'Megalomaniac' power]
RiktiWarSet (Vanguard) [Adds 'Vanguard Medal' power]
GeasoftheKindOnes (Geas of the Kind Ones) [Adds 'Geas of the Kind Ones' power]
MayhemForceOfNature (Force of Nature) (Uninsurable) [Adds 'Force of Nature' power]
AtlasSet (Received the Atlas Medallion) (Tourist) (Atlas Shrugged) [Adds 'The Atlas Medallion' passive power]
Marshal (Ex-Marshal) (Marshal) [Adds the 'Marshal' passive power]
DimensionalHopperSet (Portal Jockey) [Adds 'Portal Jockey' passive power]
BornInBattle (Born in Battle) [Adds the 'Born In Battle' passive power]
FreedomPhalanxSet (Freedom Phalanx Reserve Member) (Freedom Phalanx Fallen) [Adds 'Freedom Phalanx Reserve' passive power]
HighPainThreshold (Gotten Soft) (High Pain Threshold) [Adds 'High Pain Threshold' passive power]
TaskForceCommander (Task Force Commander) (Task Force Abandoner) [Adds 'Task Force Commander' passive power]
MayhemInvader (Return Visitor) (Invader) [Adds 'Invader' passive power]
DJ_Warden (Police Chief) (Corrupt Commissioner) [Dayjob at 'Paragon City Hall' or any 'Police Department' to get 'Baton' power]
DJ_Security_Chief (Security Chief) (Security Breach) [Dayjob at 'Vault' or any 'Police Department' for 'Tear Gas' power]
DJ_Traveler (Traveler) (Border Crosser) [Dayjob at 'Train Station' or the 'Shadow Shard' for 'Traveler's Pack' power]
DJ_Entrepreneur (Entrepreneur) (Free Trade Advocate) [Dayjob at 'Wentworth's' or inside any 'Shop' for 'Entrepreneur Crafting Discount' tokens]
DJ_Scientist (Scientist) (Crackpot) [Dayjob at 'University' or inside the 'Portal Corps' building for 'Sleep Gas' power]
DJ_Doctor (Physician) [Dayjob at 'University' or inside any 'Hospital' for 'Revive Ally' power]
DJ_Alchemist (Alchemist) [Dayjob at 'Midnighter's Club' or inside any 'Hospital' for 'Vitalize' power]
DJ_Black_Ops (Defector) (Black Ops) [Dayjob at any 'Arachnos' controlled area or inside any 'Vault' for 'Smoke Bomb' power]
DJ_Trend_Setter (Socialite) [Dayjob at 'Pocket D' or any 'Tailor' for 'Beguile' power]
DJ_Soldier (Mercenary) [Dayjob at 'Vanguard Base' for 'Fragmentation Grenade' power]
DJ_Time_Traveler (Time Lord) [Dayjob at 'Cimerora' or 'Ouroboros' for 'Time Lord's Boon' power]
DJ_Archaeologist (Archaeologist) [Dayjob at 'Midnighter Club' or any 'Graveyard' for 'Rune of Purification' power]
DJ_Brood_Leader (Brood Leaver) (Brood Leader) [Dayjob at 'Grandville' or near any 'Black Helicopter' for 'Traveler's Pack' power]
DJ_Gladiator (Gladiator) [Dayjob at 'Arena' or any 'PvP Zone' for 'Combat Shield' power]
DJ_Rapid_Response_Member (Rapid Response Member) (Trouble Maker) [Dayjob near any 'Super Group Base Portal' for 'Base Teleporter' power]
DJ_Crey_Scientist (Whistleblower) (Crey Scientist) [Dayjob at 'Crey Industries' building or in any 'University' for 'Sleep Gas']
DJ_Web_Weaver (Anti-Arachnos Activist) (Web Weaver) [Dayjob at any 'Arachnos' controlled area or in the 'Arachnos Building' in 'Marconeville' for 'Web Grenade' power]
DJ_Black_Marketeer (Blockade Runner) (Profiteer) [Dayjob at 'Docks' or near the 'Black Market' for 'Entrepreneur Crafting Discount' token]
DJ_Master_Architect (Master Architect) [Dayjob at Unknown location for 'Vitalize' power]
IncarnateAlphaSlot (Alpha Unlocked) [Unlocks Alpha slots. Adds several new Level 50 Contacts]
IncarnateJudgementSlot (Judgement Unlocked) [Unlocks Judgement slots. Adds several new Level 50 Contacts]
IncarnateInterfaceSlot (Interface Unlocked) [Unlocks Interface slots. Adds several new Level 50 Contacts]
IncarnateLoreSlot (Lore Unlocked) [Unlocks Lore slots. Adds several new Level 50 Contacts]
IncarnateDestinySlot (Destiny Unlocked) [Unlocks Destiny slots. Adds several new Level 50 Contacts]
IncarnateHybridSlot (Hybrid Unlocked) [Unlocks Hybrid slots. Adds several new Level 50 Contacts]
IncarnateGenesisSlot (Genesis Unlocked) [Unlocks Genesis slots. Adds several new Level 50 Contacts]
IncarnateMindSlot (Mind Unlocked) [Unlocks Mind slots. Adds several new Level 50 Contacts]
IncarnateVitaeSlot (Vitae Unlocked) [Unlocks Vitae slots. Adds several new Level 50 Contacts]
IncarnateOmegaSlot (Omega Unlocked) [Unlocks Omega slots. Adds several new Level 50 Contacts]
Paragon (Paragon) [Unlocks 'Assemble the Team' power in the P2W Vendor under 'Prestige Powers > Travel > Teleport']
UnbrokenSpirit (The Unbroken Spirit) [Unlocks 'Renewal of Light' power in the P2W Vendor under 'Prestige Powers > Utility > Miscellaneous']
P_Relentless (Relentless) [Unlocks 'Return to Battle' power in the P2W Vendor under 'Prestige Powers > Utility > Miscellaneous']
Here's the complete list of the spawnable badge names on this TXT that I pulled out of the game with /badges_show_all
Also here's a link to the Wiki where someone compiled a ton of the Exploration badges
https://paragonwiki.com/wiki/Badges_...n_Paragon_Chat
Last edited by gorkn; 26-04-19 at 06:39 AM.
In-Game you can use the following commands to start events.
"/shardeventstart scriptdefs/Holiday_11_Event.scriptdef"
"/shardeventstart scriptdefs/Halloween_11_Event.scriptdef"
"/shardeventstart ScriptDefs/SpringFlingEvent.scriptdef"
"/shardeventstart ScriptDefs/NemesisPlotShard.scriptdef"
There is also "/shardeventstop" to stop said events, I'm not sure if an event is started if it lasts between server resets or not since not tried.
You have a misconfigured MSSQL Database in config files.You have to have a server, with an user configured for password authentication and external connection configuration enabled.
Also a Vote up for a Section! :D Can we bother @MentaL with this or it is too early on?
The most urgent thing with this source is solving the ip and NAT problem... For example: despite that in the source all IP is on my vpn, regardless who is connecting, always the server's physical ip gets to pass the clients, and they cannot connect... somehow we need to make the DBserver to pass on the VPN ip to the mapservers, and the mapservers to the clients... So in current state: Unless if your friends not directly on your physical network, you wont play with anyone else...
I found this on Discord this we could start on... :
Authserver sends the dbserver IP. dbserver sends the mapserver IP. mapserver sends another mapserver IP when you zone
Fix for the problem above:
SOLUTION: LAN 2 IP NAT fix:
If you have 2 IP in your system and the mapserver.exe binds to the wrong one, just hexedit mapserver.exe and at offset 0x3c9c60
Change the values starting from 00 column 53 to:
53 5B B8 00 00 00 00 C3 E9 08 C1 EA 10 C1 EB 18
This will eliminate wrong IP binding :D
Thx for this for Discord user RandomSolution !
Last edited by Flyer8472; 26-04-19 at 12:48 PM.
As shown in the instructions? I did set up the MSSQL as instructed, with the same sa user and the password is just password, in all 4 of the files asked to change. Is there a step in the instructions that are missing?
Digging into the error code online I may have some potential fixes to try. Will update later in case anyone else gets this issue
Last edited by LastKnownHero; 26-04-19 at 03:23 PM.