|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Old Forum | |
| pabennett 8/12/2008 8:41:30 AM | Hello Jeff, You have stated in the past that you are working on a way for us to view the information posted on the old forums. I would love to have access to these posts as they contain a lot of great of information from you and others. I know you are busy but I was wondering if you are any closer to accomplishing that goal? I would be willing to help in any way if needed. Patrick
| |
| jeff 8/12/2008 11:55:06 AM | The reason I took the old board down is that it was an ongoing target for ad-bots and kept getting hacked. Whoever hacked it the last time was able to insert blocks of HTML into the database - so that the web pages presenting posts made by users (and in some cases posts made by users themselves) contained malicious code. They were very sophisticated about the way they did this. The embedded HTML contains code that renders an html iframe element where the height and width is set to just a couple of pixels. The iframe renders so small that a human eye viewing a web page presenting the old board won't notice it. But the web content presented inside the iframe is coming from sites that attempt to load trojans and worms onto the user's machine. I did start a project where I created a VB interface to connect to and read the MySQL database used by the old board. My intent was to (and I will finish it at some point) write a VB routine that: 1. Stripped all of the iframes out of the MySQL database. 2. Read the following info from the MySQL database: a. user name b. date of post c. thread name or topic id d. text content of post 2. Write the above info only to an Access or SQL database. 3. Write a web interface to render the database created in step 2 and then upload both the web pages and database to a folder on the JCapper server. This would enable people to view the old board but not be able to make new posts there. 4. At some future point merge the database created in step 2 into the database I'm using to drive this board. At that point members of this board would be able to make posts in old threads if desired. I'll be honest with you guys... I haven't spent a lot of time on this recently - I've opted instead to work new features into JCapper. I feel new features are a better use of my time. And believe it or not there is some really cool new stuff on the way. I'm not against farming this out once I get things beyond step 2 above. But I wouldn't consider farming it out until I get things that far because the old MySQL database contains UserIds and PassWords which I feel are better kept locked down. As an example I used the same password for the old message board as I did for several ADWs as well as one of my local banks. That might not have been exactly smart on my part. But it made things easy to remember. One password for nearly everything. And if I had to make a guess I'd guess I'm not the only one who likes to operate like that. I may decide to take you up on your offer at some point. But until I get things beyond step 2 above I really can't. I hope you guys can understand. -jp .
| |
| dvlander 8/13/2008 10:25:32 AM | Access to the old forum messages would be nice but I prefer to have your energy spent on the wonderful program improvements that we are seeing. The CXN export has been very useful for me. Keep up the good work Jeff. Dale
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |