Unofficial HCS Forum distribution - Long time no see since 2011 by CaptainRon at 9:57 PM EST on February 15, 2017

It's amazing what 6 years can do to a person.

Anyways, I'm back; I was here 6 years ago because I was interested in the forum software & making a proper distribution package for it. And so I did.

http://techemporium.vashid.us/hcsfs/

NOTE: This code is based on HCS Forum's 2011 update. It has yet to be brought up to current code updates, but that will happen soon enough.

And since this place is also a video game music forum, might as well share some of my FamiTracker-made music.

http://techemporium.bananabo.xyz/warlord/

Hope you guys enjoy either of these two treats &, if you're also interested in a little user administration script I made for HCS forum, just let me know & I'll post it here.

Greetz, hcs.

edited 10:00 PM EST February 15, 2017

edited 12:19 AM EST February 16, 2017

by maxton at 11:36 PM EST on February 15, 2017

Did you change your user name? I can't find your old posts

by CaptainRon at 11:49 PM EST on February 15, 2017

Yes, I did. My old user name was "Captain Ron" without quotes, but none of the old passwords I remembered worked, so I just created a new user.

Even though I really haven't added much into it, I'm starting to get back into trying to maintain this code in a more proper manner. Feel free to try it, ask me any questions about it if you need to.

edited 12:13 AM EST February 16, 2017

by CaptainRon at 4:22 PM EST on February 16, 2017

Well, I hope hcs is here to see this topic. I'm now trying to update the code to match what you currently have, but I'm wondering if there's any changed made to the SQL code to incorporate pinned topics, or if that's all handled within the forum's source code alone.

Sit tight, though; I'm updating the distribution package I made to be more current.

To sumarrise, this unofficial source distribution is dated at 2011 & contains all the same bugs otherwise found in hcs' original code from that era. Only minor changes to the forum's BB code tags have been done (namely, removing the random page title messages, removing the em tag & replacing it with a YouTube video embedding tag). Otherwise, the forum itself remains true to hcs' coding.

The upcoming update will include comments on what items can be changed (such as the section on pinned topics) & customized to suit your own site's installations (& the re-inclusion of the random page title messages, though commented out).

edited 4:25 PM EST February 16, 2017

by hcs at 11:30 PM EST on February 18, 2017

Howdy. Pinned threads (and permanently editable threads) are hard coded, the database doesn't know about 'em. The most notable change to the DB I can think of is the use of password hashes.

by CaptainRon at 3:42 PM EST on February 25, 2017

Great! Thanks for letting me know.

I take it that there's no real change to the DB template.

by hcs at 5:32 PM EST on February 25, 2017

Here's what a recent backup dump says:

CREATE TABLE `board` (
`idx` int(11) NOT NULL AUTO_INCREMENT,
`postedtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`lasttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`author` int(11) NOT NULL DEFAULT '0',
`replyto` int(11) NOT NULL DEFAULT '0',
`subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`message` text COLLATE utf8_unicode_ci,
`ip` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`idx`) USING HASH,
KEY `idx` (`idx`),
KEY `author` (`author`),
KEY `lasttime` (`lasttime`),
KEY `postedtime` (`postedtime`),
KEY `replyto` (`replyto`),
CONSTRAINT `board_ibfk_1` FOREIGN KEY (`author`) REFERENCES `users` (`idx`),
CONSTRAINT `board_ibfk_2` FOREIGN KEY (`replyto`) REFERENCES `board` (`idx`)
) ENGINE=InnoDB AUTO_INCREMENT=48851 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `users` (
`idx` int(11) NOT NULL AUTO_INCREMENT,
`joined` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`uname` varchar(31) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`lastlogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`prevlogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`logintoken` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`pass_hash` char(60) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`idx`),
KEY `idx` (`idx`)
) ENGINE=InnoDB AUTO_INCREMENT=1936 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

by _ray at 2:23 PM EDT on March 25, 2017

CaptainRon - Your site on vashid.us is down.

Why not put the source on Github (with the blessing of hcs of course!) so more developers can check out the code?

hcs - Your forum source references three files that are required:

require("dblogin.php");
require("dblogin_write.php");
require("random_compat-1.1.1/lib/random.php");

Any chance of providing that code as well?

by hcs at 5:46 PM EDT on March 25, 2017

You can get random_compat on GitHub, probably should use their latest stable release instead of the old one I'm using.

The login files just have functions that do MySQL login, looks like:

<?php
function dblogin() {
$dbh = mysqli_connect(server, user, password, database) or die(mysqli_error($dbh));
return $dbh;
}
?>

There are two as one user only has select permissions, and the other only select and update.

Go to Page 0

Search this thread

Show all threads

Reply to this thread:

User Name		Tags: bold: [b]bold[/b] italics: [i]italics[/i] emphasis: [em]emphasis[/em] underline: [u]underline[/u] small: [small]small[/small] Link: [url=http://www.google.com]Link[/url] [img=https://www.hcs64.com/images/mm1.png]
Password
Subject
Message