Scratch

What does the .pt file open with?

Magnie wrote:

.pt opens in Panther.    http://pantherprogramming.weebly.com/

OH! LOL! I never noticed that! Thanks.

Where do you download panther from?????????

ScratchReallyROCKS wrote:

This is a really cool idea. Except, whenever I try to post it says "Failed to post" 

I would assume the reason is because the username/password are incorrect. The code restrictions for posting are:

($r0['user'] == $user && $r0['pass'] == $pass)

So unless you are trying to create a topic ( CT = Create Topic ) only people with the 'Owner' rank can create topics. ( I don't want the place to be spammed with topics when you type LT )

ScratchReallyROCKS wrote:

Magnie wrote:

ScratchReallyROCKS wrote:

This is a really cool idea. Except, whenever I try to post it says "Failed to post" 

I would assume the reason is because the username/password are incorrect. The code restrictions for posting are:

Code:

($r0['user'] == $user && $r0['pass'] == $pass)

So unless you are trying to create a topic ( CT = Create Topic ) only people with the 'Owner' rank can create topics. ( I don't want the place to be spammed with topics when you type LT )

Yeah, I forgot my password for ScratchReallyROCKS on it, so I jet made a new account called SRR 

I believe you meant *just

ScratchReallyROCKS wrote:

ssss wrote:

ScratchReallyROCKS wrote:

Yeah, I forgot my password for ScratchReallyROCKS on it, so I jet made a new account called SRR 

I believe you meant *just

Stupid iPod spellcheck. 

Fail much?

fullmoon wrote:

This is soooooooooo cool! But you should change it so you can use a single statement (like "VT 4") instead of typing "vt" then hitting enter and typing "4". Also, I can't make a new topic. Or better yet, just make it "v", "c", "p", and "l"...the "t" is redundant.

Also, you really should be SHA-1 or md5-encrypting your passwords. Just saying. 

they're already MD5'd, I believe    It is pretty cool!

fullmoon wrote:

This is soooooooooo cool! But you should change it so you can use a single statement (like "VT 4") instead of typing "vt" then hitting enter and typing "4". Also, I can't make a new topic. Or better yet, just make it "v", "c", "p", and "l"...the "t" is redundant.

Also, you really should be SHA-1 or md5-encrypting your passwords. Just saying. 

Yes, I was thinking of that as well, though I've forgotten how to do that in an "un-messy" way ( check every letter until it hits a space, cleaning out extra stuff, etc.    ) though I'll try to add that in the "Next version of the viewer" 

Yes, the passwords are MD5    I add extra text to the beginning and end for extra security against those "MD5 Decrypters"    Though I am thinking of using SHA-1 for more security. The full code for posting a message is:

<?php
$con = mysql_connect('localhost','username','password');
mysql_select_db("database", $con);
$tid = $_GET['tid'];
$text = $_GET['txt'];
$user = $_GET['u'];
$pass = $_GET['p'];
$pass = md5('some text here'.$pass);

$r0 = mysql_query("SELECT * FROM sn_users
WHERE user='$user'");

$r0 = mysql_fetch_array($r0);

if ($r0['user'] == $user && $r0['pass'] == $pass) {

$r1 = mysql_query("SELECT *
FROM `sn_posts`
WHERE pid = (
SELECT MAX( pid )
FROM `sn_posts` )");
$t1 = mysql_fetch_array($r1);
$pid = $t1['pid'] + 1;

$add_post = mysql_query("INSERT INTO sn_posts (`author`,`text`,`tid`,`pid`)
VALUES ('$user', '$text', '$tid', '$pid')");
echo 'Succesfully posted, now please revisit the topic to see the post.';
}
else { echo 'Failed to post.'; }
?>

Yes, I know my coding is messy 

Once Scratch gets HTTP POST and GET then I won't have to use Panther for this project. No offense towards Panther and it's team. 

Apparently I should use MySQLi instead of MySQL, so for the 'next version' I'll fix up my coding for MySQLi. I'm also open to any suggestions. 

If you made the id fields in the database "auto_increment", you wouldn't have to manually increment the id all the time.