Scratch

LS97 wrote:

I felt like I needed to bring this up again.

rookwood,
I am trying to host this on my own site because I am expanding on it and turning this into a bigger project (which includes end-user browser extensions and more). You've done such a good job on this that I didn't want to start from scratch, but rest assured that if this project succeeds credit will be given.

Your source works, I imagine, but what databases do I need to host and how do I implement it?

Besides, there's an 'include mysql.php' that I need, possibly?

Oh, and the background images.

i could help.......

comp500 wrote:

LS97 wrote:

I felt like I needed to bring this up again.

rookwood,
I am trying to host this on my own site because I am expanding on it and turning this into a bigger project (which includes end-user browser extensions and more). You've done such a good job on this that I didn't want to start from scratch, but rest assured that if this project succeeds credit will be given.

Your source works, I imagine, but what databases do I need to host and how do I implement it?

Besides, there's an 'include mysql.php' that I need, possibly?

Oh, and the background images.

i could help.......

aaaaaaaand I could host it on github.....

and lol 60 sec rule 

Sorry, I was on holiday, you need 4 tables, for each forum, and for seperate posts and topics.
Although you've done yours already, I'll put it here just in case.
postrate
tbg_postrate
topicrate
tbg_topicrate

the mysql.php has

$mysql_host = "DBHost";
$mysql_database = "DatabaseName";
$mysql_user = "YourMySQLUsernameHere";
$mysql_password = "YourMySQLPasswordHere";
$bdrq = 'Bad request. The link you followed is***incorrect or outdated.';//Replace *** with a space otherwise it won't work.

Last edited by rookwood101 (2011-11-02 11:41:45)

rookwood101 wrote:

Sorry, I was on holiday, you need 4 databases, for each forum, and for seperate posts and topics.
Although you've done yours already, I'll put it here just in case.
postrate
tbg_postrate
topicrate
tbg_topicrate

the mysql.php has

Code:

$mysql_host = "DBHost";
$mysql_database = "DatabaseName";
$mysql_user = "YourMySQLUsernameHere";
$mysql_password = "YourMySQLPasswordHere";
$bdrq = 'Bad request. The link you followed is***incorrect or outdated.';//Replace *** with a space otherwise it won't work.

Ah, I see!
The only problem is I don't have enough to make 4 databases, so I'll just stick with mine.
Thanks anyways!!!

rookwood101 wrote:

LS97 wrote:

rookwood101 wrote:

Sorry, I was on holiday, you need 4 tables, for each forum, and for seperate posts and topics.
Although you've done yours already, I'll put it here just in case.
postrate
tbg_postrate
topicrate
tbg_topicrate

the mysql.php has

Code:

$mysql_host = "DBHost";
$mysql_database = "DatabaseName";
$mysql_user = "YourMySQLUsernameHere";
$mysql_password = "YourMySQLPasswordHere";
$bdrq = 'Bad request. The link you followed is***incorrect or outdated.';//Replace *** with a space otherwise it won't work.

Ah, I see!
The only problem is I don't have enough to make 4 databases, so I'll just stick with mine.
Thanks anyways!!!

nononon four tables sorry 

oooooooooooooooooooooh.
I'll still keep mine 

elfin8er wrote:

You guys gonna update this? I miss it.

too much commitment having to host all the tables and stuff, although I agree it was nice 

it dosent work.


http://scratch.mit.edu/forums/viewtopic.php?id=91538

What does the .tk extension stand for?

Squawkers13 wrote:

What does the .tk extension stand for?

Tokelau.

Squawkers13 wrote:

Sidharth wrote:

Here is the bookmarklet that can generate code for you based on the forum page or post you are on:

Like this one: http://rookwood101.tk/topicrate.php?id= … ;type=post

TO USE:
    *Higlight code, press Ctrl and C simultaneously
    *Create new bookmark in your browser
    *Change its name to whatever and also the url to the code you copied

Code:

javascript: (function () {
    var teststring = document.location.href;
    if (teststring.substr(0, 47) == 'http://scratch.mit.edu/forums/viewtopic.php?id=' || teststring.substr(0, 42) == 'http://scratch.mit.edu/forums/edit.php?id=' || teststring.substr(0, 48) == 'http://scratch.mit.edu/forums/viewtopic.php?pid=' || teststring.substr(0, 55) == 'http://scratch.mit.edu/forums/post.php?action=post&tid=' || teststring.substr(0, 43) == 'http://scratch.mit.edu/forums/post.php?tid=') {
        var topicID = /(\d)+/gi.exec(teststring)[0];
        if (teststring.substr(0, 48) == 'http://scratch.mit.edu/forums/viewtopic.php?pid=' || teststring.substr(0, 42) == 'http://scratch.mit.edu/forums/edit.php?id=') {
            var BBCODE = '[url=http://rookwood101.tk/topicrate.php?id=' + topicID + '&ret=add&type=post][url]http://rookwood101.tk/topicrate.php?id=' + topicID + '&ret=image&type=post[/url][/url]';
        } else {
            var BBCODE = '[url=http://rookwood101.tk/topicrate.php?id=' + topicID + '&ret=add][url]http://rookwood101.tk/topicrate.php?id=' + topicID + '&ret=image[/url][/url]';
        }
        var NENENENE = prompt('BBCode: Press Ctrl(cmd on Mac)-c, then Ctrl(cmd on Mac)-v to paste it', BBCODE);
    } else {
        if (teststring.substr(0, 50) == 'http://scratch.mit.edu/tbgforums/viewtopic.php?id=' || teststring.substr(0, 42) == 'http://scratch.mit.edu/tbgforums/edit.php?id=' || teststring.substr(0, 51) == 'http://scratch.mit.edu/tbgforums/viewtopic.php?pid=' || teststring.substr(0, 58) == 'http://scratch.mit.edu/tbgforums/post.php?action=post&tid=' || teststring.substr(0, 46) == 'http://scratch.mit.edu/tbgforums/post.php?tid=') {
            var topicID = /(\d)+/gi.exec(teststring)[0];
            if (teststring.substr(0, 48) == 'http://scratch.mit.edu/tbgforums/viewtopic.php?pid=' || teststring.substr(0, 42) == 'http://scratch.mit.edu/tbgforums/edit.php?id=') {
                var BBCODE = '[url=http://rookwood101.tk/topicrate.php?id=' + topicID + '&ret=add&forum=tbg&type=post][url]http://rookwood101.tk/topicrate.php?id=' + topicID + '&ret=image&forum=tbg&type=post[/url][/url]';
            } else {
                var BBCODE = '[url=http://rookwood101.tk/topicrate.php?id=' + topicID + '&ret=add&forum=tbg][url]http://rookwood101.tk/topicrate.php?id=' + topicID + '&ret=image&forum=tbg[/url][/url]';
            }
            var NENENENE = prompt('BBCode: Press Ctrl(cmd on Mac)-c, then Ctrl(cmd on Mac)-v to paste it', BBCODE);
        } else {
            alert('BAD URL!');
        }
    }

})();

Now works in TBG forums and a lot more page types covered (now you can "like" posts, too!  If you want the button to be for the forum thread, then make sure you don't have a ?pid=xxxxxx at the end. 


Tell me if it doesn't work 

EDITed EDIT: Now you can like posts too!!.

EDIT: OOPS, the type=post thing was getting added to even non-post pages. Fixed.

EDIT: Does anyone want it to be able to set style? I'm not for that, I can do it manually, but does someone else want it?

IMPROVEMENTS:
    *You can generate code to like a post too, just click on the time stamp of the postand run the bookmarklet.
    *You can generate code while posting a reply
    *You can generate code while editing a post
    *Everything works on the text-based games forum (I hope! I'm way too lazy to test it)
    *7/31/2011 - Now uses an anonymous function.

EDIT: Now made a code generator for top liked list! HERE

DON'T BLOCK POPUPS!
Don't worry, it will redirect you back here when it's done.
Source:

Code:

(function () {
    var number = prompt('Rank 1 to what number?', 'Number here');
    var imglink = 'http://rookwood101.tk/topicrate.php?ret=top';
    var urllink = 'http://rookwood101.tk/topicrate.php?ret=toplink';
    if (number <= 1) {
        alert('BAD NUMBER!');
    } else {

        var intbg = prompt('Are you in the text-based games forum? (\'yes\'/\'no\')');

        var posts = prompt('Do you want posts? (\'yes\'/\'no\')');
        if (posts === 'yes') {
            imglink = imglink + '&type=post';
            urllink = urllink + '&type=post';
        }
        if (intbg === 'yes') {
            imglink = imglink + '&forum=tbg';
            urllink = urllink + '&forum=tbg';
        }
        var wind1 = window.open('', '', 'width=200,height=100');
        var count = 0;
        for (count = 1; count <= number; count++) {
            wind1.document.write('<a href=\'' + urllink + '&rank=' + count + '\'><img src=\'' + imglink + '&rank=' + count + '\' /></a> <br />');
        }
        for (count = 1; count <= number; count++) {
            wind1.document.write('[url= + urllink + '&rank=' + count + ][url]' + imglink + '&rank=' + count + '[/url][/url] <br />');
        }
    }
})();

EDIT: edited whole post to use rookwood101.tk 

help rookwood!
it makes no sense!
please help get gen code for:
scratch.mit.edu/forums/viewtopic.php?id=91769

This will not work anymore, sorry. I turned the service off.

Heh, this might actually be useful for my own forums. Thanks for explaining it!