Scratch

you guys should make a modshareBB for the forums.

XenoK wrote:

you guys should make a modshareBB for the forums.

Nah. FluxBB works and it's really easy to integrate.
It's also really hard to program a forum system.
Here's a comparison:
Mod Share 3 has about 10K lines of code. FluxBB has about 45K.

Edit: Man! Outposted!

Last edited by jvvg (2012-09-16 13:58:50)

you two together code really fast!  I've been working on EternityX1 for at least one month, with help from P110.  Then again, we've taken prereleases, and procrastinated a bit too...

If you look at the first post, you'll see that we're interested in getting a site moderator. Anyone interested, please post here giving a short explanation of why you would be good for the job.

SJRCS_011 wrote:

Also, one question: what host will you be using? (x10, hourb, etc?)

Probably x10. However, my birthday is coming up, so we might decide to use FatCow instead.

SJRCS_011 wrote:

Side note:  jvvg, I'm still working on the JPlayer, but it won't be around anytime soon, unfortunately.   You can view the repo here

Oh well. If you ever get it working, please let us know.

SJRCS_011 wrote:

jvvg wrote:

SJRCS_011 wrote:

Also, one question: what host will you be using? (x10, hourb, etc?)

Probably x10. However, my birthday is coming up, so we might decide to use FatCow instead.

SJRCS_011 wrote:

Side note:  jvvg, I'm still working on the JPlayer, but it won't be around anytime soon, unfortunately.   You can view the repo here

Oh well. If you ever get it working, please let us know.

I'll finish it someday, the question is when 
Unlike you, I'm a rather slow coder XD
Though if you guys would like to help, I could add you to the repo, you'd just have to tell me your sourceforge usernames

I'm best at XHTML and PHP, and ok at JS, but not very good at Java. I'm not sure how much I could help.

However, LS might be able to help.

SJRCS_011 wrote:

jvvg, if you do end up using FatCow, I suggest, that for the domain name, you use a .net or .org rather than a .com, because .com often is interpreted as meaning a commercial business.

Yeah, we will use a .org.

jvvg wrote:

SJRCS_011 wrote:

1. Importing friends from Scratch
2. Link to Scratch account on user page
3. Use a user-generated project summary instead of manually filling in description and name of project
4. Automated backup scripts to backup the database and website to another site, from where an admin can download the backup
5. API similar to Scratch's (the scratchr api, not the images thing)

1. However, not all users on Scratch have Mod Share accounts, so I'm not sure how great an idea that would be.
2. Maybe. However, we are importing accounts from MS3, and not all of them are Scratch validated.
3. Please explain more - I don't quite understand
4. Good idea, except that I have no idea how to code a backup.    I just use phpMyAdmin (and now download database backups every week or so)
5. We probably will have some sort of API

Project Summary

LS97 wrote:

jvvg wrote:

5. We probably will have some sort of API

We're definitely having an API, because Bingo uses it for its browser 

I mean one not just for you. 

LS97 wrote:

We're looking for a dedicated moderator to occasionally check out users, projects, comments and forum posts. The moderator will have the power to block content and ban users. Please express any interest you have here, and we'll select whoever we think will fit the job best.

I would love to be a moderator, and I think I'd be a good canidate for a Mod Share IV moderator. I am a moderator on many popular forums, including:

Go Everywhere! Forums
CylonToast's Forums
The Rulez Forums

I have never been banned from Scratch.

Have any questions? You can get in touch with me here.

SJRCS_011 wrote:

jvvg wrote:

SJRCS_011 wrote:

1. Importing friends from Scratch
2. Link to Scratch account on user page
3. Use a user-generated project summary instead of manually filling in description and name of project
4. Automated backup scripts to backup the database and website to another site, from where an admin can download the backup
5. API similar to Scratch's (the scratchr api, not the images thing)

1. However, not all users on Scratch have Mod Share accounts, so I'm not sure how great an idea that would be.
2. Maybe. However, we are importing accounts from MS3, and not all of them are Scratch validated.
3. Please explain more - I don't quite understand
4. Good idea, except that I have no idea how to code a backup.    I just use phpMyAdmin (and now download database backups every week or so)
5. We probably will have some sort of API

2. Maybe just have it link to the accounts on scratch validated ones

4. I found some code from googling it:

Code:

<?php
include 'config.php';
include 'opendb.php';

$tableName  = 'mypet';
$backupFile = 'backup/mypet.sql';
$query      = "SELECT * INTO OUTFILE '$backupFile' FROM $tableName";
$result = mysql_query($query);

include 'closedb.php';
?>

Basically, you'd use this in a cron job, as well as the rest of the site backup, which then ftp's it to another site where you can retrieve it / automatically restore it.

Oh,. and code to restore a backup:

Code:

<?php
include 'config.php';
include 'opendb.php';

$tableName  = 'mypet';
$backupFile = 'mypet.sql';
$query      = "LOAD DATA INFILE 'backupFile' INTO TABLE $tableName";
$result = mysql_query($query);

include 'closedb.php';
?>

Scratch validation thing: on the new user system, all registrations must be Scratch validated so we don't have any way to store whether old accounts are validated.
Backup code: We can try that. However, I still think that manual backups every few days works. Also, I'm not sure if x10 supports cron jobs, and as the database gets bigger, that would probably have a significant impact on server performance.

SJRCS_011 wrote:

jvvg wrote:

SJRCS_011 wrote:

2. Maybe just have it link to the accounts on scratch validated ones

4. I found some code from googling it:

Code:

<?php
include 'config.php';
include 'opendb.php';

$tableName  = 'mypet';
$backupFile = 'backup/mypet.sql';
$query      = "SELECT * INTO OUTFILE '$backupFile' FROM $tableName";
$result = mysql_query($query);

include 'closedb.php';
?>

Basically, you'd use this in a cron job, as well as the rest of the site backup, which then ftp's it to another site where you can retrieve it / automatically restore it.

Oh,. and code to restore a backup:

Code:

<?php
include 'config.php';
include 'opendb.php';

$tableName  = 'mypet';
$backupFile = 'mypet.sql';
$query      = "LOAD DATA INFILE 'backupFile' INTO TABLE $tableName";
$result = mysql_query($query);

include 'closedb.php';
?>

Scratch validation thing: on the new user system, all registrations must be Scratch validated so we don't have any way to store whether old accounts are validated.
Backup code: We can try that. However, I still think that manual backups every few days works. Also, I'm not sure if x10 supports cron jobs, and as the database gets bigger, that would probably have a significant impact on server performance.

yeah, you can do cron jobs every 5 mins (i would think, though, that'd you do every week probably)
and the max execution time is 30 seconds

The other part is that we want to make all of the code work anywhere, in case we have to switch servers.