Scratch

sparks · 2011-07-16 15:20:33

So sorry :S

EDIT: I placed a warning message on the admin page now, so hopefully that will solve the problem till I work our what's wrong... What's bizzare is that it sometimes works and sometimes does not! That makes it really hard to say what's going wrong!

Last edited by sparks (2011-07-16 15:22:13)

ProgrammingFreak · 2011-07-16 15:24:44

Hmm, I was going to edit the code, but I was surprised to see that there wasn't really anything wrong! sad

sparks · 2011-07-16 15:27:06

You looked at the code? Yes, the only explaination I can come up with is that the error is caused by what you did beforehand as it's all on one page.... maybe moving the about updater to a seperate page would do the trick? I could try that, since the fact that it works some of the time indicates that the table names and MySQL connections aren't typo'd.

P.S. what's with your sig? Are you selling your username?!

Last edited by sparks (2011-07-16 15:28:30)

Magnie · 2011-07-16 15:51:22

I found out why: You need to set/change on line 41. $_POST[about] does not work. So the way you are doing it right now won't work. It has to be $_POST['about'] .
Change:

Code:

mysql_query("UPDATE aboutme SET text = '$_POST[about]'
                WHERE name = '$_SESSION[adminUsername]'");

To:

Code:

$aboutTxt = $_POST['about'];
$adminUser = $_POST['adminUsername'];
mysql_query("UPDATE aboutme SET text = '$aboutTxt'
                WHERE name = '$adminUser'");

You keep placing they $_POST vars in the MySQL query and that will almost guarantee problems. And the quotes are needed in the $_POST vars. I suggest getting all the $_POST data in vars at the beginning of the code. And not in the middle.

Btw: You should recode it so it checks a list of users if they are admin/mod, and don't put it directly into the code where it checks if you are an Admin/Mod. It can cause problems when adding new helpers.

----

I understand how they want to discourage the FTP details so I won't try any further. tongue

Last edited by Magnie (2011-07-16 15:54:24)

sparks · 2011-07-16 16:12:24

Right, great, I will make the change, thanks very much!

I think rather than going for the "MySQL members list check" thing I'll just list members in a php page and include() it in. I'm not planning to add members often either smile

Magnie · 2011-07-16 16:47:51

Mmk, I'll test it.

---

Yep, it works! big_smile

---

Or maybe not... Can't really tell.

Last edited by Magnie (2011-07-16 16:57:49)

sparks · 2011-07-16 16:57:54

... well pleased to hear it, I haven't applied any changes yet... This is what I mean by sometimes works!

sparks · 2011-07-16 17:22:44

Still not working!

Last edited by sparks (2011-07-16 18:41:45)

Magnie · 2011-07-16 17:55:18

It's the same with $_SESSION vars too:
Wrong:

Code:

$result = mysql_query("SELECT * FROM aboutme
                WHERE name='$_SESSION[adminUsername]'");

Right:

Code:

$adminUser = $_SESSION['adminUsername'];
$result = mysql_query("SELECT * FROM aboutme
                WHERE name='$adminUser'");

sparks · 2011-07-16 18:12:08

Right. Got it! I think it works!

Magnie · 2011-07-16 18:16:56

It seems to work, I like the update as well. smile

sparks · 2011-07-16 18:29:33

What update? I'm working on a logout button now tongue

Magnie · 2011-07-16 18:32:00

The update where you login and then you have an option to change your "about me" page.

sparks · 2011-07-16 18:37:20

Alright, logging out works, that's mostly so I could check the "update about" page couldn't be used to change anything if you hadn't logged in tongue

Magnie · 2011-07-16 18:38:06

Hehe mmk.

sparks · 2011-07-16 18:40:19

I'm really looking forward to this front-end working. It's a shame that I have to be so secretive about the details but I can see where the scratch team are coming from hmm

sparks · 2011-07-16 19:13:36

the About updater now works! Please log in and fill it in!

Magnie · 2011-07-16 21:38:30

Doesn't seem to be updating for me.

scimonster · 2011-07-17 01:25:41

sparks wrote:
P.S. what's with your sig? Are you selling your username?!

PF is running for mod. wink

Magnie wrote:
Doesn't seem to be updating for me.

Me either. sad

sparks wrote:
Sorry sci, the updater sometimes works and sometimes does not I have no idea why and I'm trying to fix it. I can only recommend copying your changes to clipboard before posting, and then updating till the changes stick

And I wrote it in a text editor and kept it there, because I know it's glitchy. ;P

Last edited by scimonster (2011-07-17 01:26:16)

meowmeow55 · 2011-07-17 11:30:35

At least all these problems with updating give me time to think of something to type. tongue

RUMCHEERYPOOPOO · 2011-07-21 11:48:29

Just wondering, hows the integration with the old website stuff and the new website going?

sparks · 2011-07-21 11:52:35

IDK, we're sort of waiting on meowmeow to finish the front-end... Most of the pages aren't finished so there's not point moving them yet.

RUMCHEERYPOOPOO · 2011-07-21 14:05:48

cool

sparks · 2011-07-23 15:23:23

Okay, so how is work going on the site11 site everyone? And meowmeow55, any luck with that front-end?

sparks · 2011-07-25 12:59:13

I'm slowly moving pages across to the new site, it would be nice to see some other developers adding some code to the site11 site though!

Scratch

archived forums

#776 2011-07-16 15:20:33

Re: Welcome to your local block library! - Website development thread.

#777 2011-07-16 15:24:44

Re: Welcome to your local block library! - Website development thread.

#778 2011-07-16 15:27:06

Re: Welcome to your local block library! - Website development thread.

#779 2011-07-16 15:51:22

Re: Welcome to your local block library! - Website development thread.

Code:

Code:

#780 2011-07-16 16:12:24

Re: Welcome to your local block library! - Website development thread.

#781 2011-07-16 16:47:51

Re: Welcome to your local block library! - Website development thread.

#782 2011-07-16 16:57:54

Re: Welcome to your local block library! - Website development thread.

#783 2011-07-16 17:22:44

Re: Welcome to your local block library! - Website development thread.

#784 2011-07-16 17:55:18

Re: Welcome to your local block library! - Website development thread.

Code:

Code:

#785 2011-07-16 18:12:08

Re: Welcome to your local block library! - Website development thread.

#786 2011-07-16 18:16:56

Re: Welcome to your local block library! - Website development thread.

#787 2011-07-16 18:29:33

Re: Welcome to your local block library! - Website development thread.

#788 2011-07-16 18:32:00

Re: Welcome to your local block library! - Website development thread.

#789 2011-07-16 18:37:20

Re: Welcome to your local block library! - Website development thread.

#790 2011-07-16 18:38:06

Re: Welcome to your local block library! - Website development thread.

#791 2011-07-16 18:40:19

Re: Welcome to your local block library! - Website development thread.

#792 2011-07-16 19:13:36

Re: Welcome to your local block library! - Website development thread.

#793 2011-07-16 21:38:30

Re: Welcome to your local block library! - Website development thread.

#794 2011-07-17 01:25:41

Re: Welcome to your local block library! - Website development thread.

sparks wrote:

Magnie wrote:

sparks wrote:

#795 2011-07-17 11:30:35

Re: Welcome to your local block library! - Website development thread.

#796 2011-07-21 11:48:29

Re: Welcome to your local block library! - Website development thread.

#797 2011-07-21 11:52:35

Re: Welcome to your local block library! - Website development thread.

#798 2011-07-21 14:05:48

Re: Welcome to your local block library! - Website development thread.

#799 2011-07-23 15:23:23

Re: Welcome to your local block library! - Website development thread.

#800 2011-07-25 12:59:13

Re: Welcome to your local block library! - Website development thread.

Board footer