mysql stuff with this site

TUFKATH · 09-04-2005, 04:12 PM

on http://shas.taylorhewitt.com

ive spent the past 15 minutes constantly deleting spam of this site by a ****ing loser. he is pissing me off so much! it wont end!

its set to automaticly submit to the mysql database, then withdraw it and post it there. what can i do so i have to verify it first?

thanks

mholt · 09-04-2005, 04:23 PM

Have them register first, or do a simple image verification.

Ah, these aren't bots. Okay, make sure they can only post maybe... once per day.

An easy way, yet easily breakable way to do this is to set a cookie that expires in 24 hours. Then, if the cookie exists as they try to post, do not allow it to be submitted.

nasaboy007 · 09-04-2005, 05:01 PM

yeah, cookies are a good idea. if u make them register, you can log their IP and set sessions and cookies and then have a lot of fun with them hehe.

but seriously, u can set a cookie so that it only allows a certain amount of submissions. sorta like flood control on forums.

TUFKATH · 09-04-2005, 06:22 PM

The thing is it's supposed to be completely anonymous...

RJ · 09-04-2005, 06:33 PM

You want to moderate the comments before they go public on your site? I don't know what script you're using, but it should be a simple job for a php coder to modify it to require moderation.

In short, add a column to your MySQL table named status and have it default to 0 when new entries are submitted. Then have your site only publically display rows where status=1. Then setup an admin page to view unapproved comments and approve them.

TUFKATH · 09-04-2005, 07:04 PM

Yeah I don't know how to do that...

RJ · 09-04-2005, 07:07 PM

Originally Posted by Taylor Hewitt

Yeah I don't know how to do that...

Did you write the script you have now?
????: NamePros.com http://www.namepros.com/programming/121057-mysql-stuff-with-this-site.html

I guess you can hire someone to code it for you, or if you want to make it a public project you we can help you code it here in the forum.

TUFKATH · 09-05-2005, 10:07 AM

Most other forums are made to be helpful free of cost but I don't really have money to spend on this sort of thing...

mholt · 09-05-2005, 10:17 AM

Here...

When they post a topic, use this:

setcookie("cookiename", "date_here_methinks", 60*60*24);

That sets a cookie that expires in 1 day.

Then, when they post.

if (isset($_COOKIE['cookiename']))
{
echo("ERROR > You can only post once per day.");
exit;
}

That should work

TUFKATH · 09-07-2005, 03:32 PM

What do I put for the date thingy?

TUFKATH · 09-08-2005, 06:43 PM

bump

mholt · 09-08-2005, 06:52 PM

Oh, the *date_here_methinks* thing?

PHP Code:

  $date = "F d Y";

That's off the top of my head, but that produces a human-formatted date. Replace "date_here_methinks" with:

$date

And that just puts the $date into the cookie as its content.

TUFKATH · 09-09-2005, 03:45 PM

Thanks.

But where do I put this stuff?

setcookie("cookiename", "date_here_methinks", 60*60*24);

if (isset($_COOKIE['cookiename']))
{
echo("ERROR > You can only post once per day.");
exit;
}

TUFKATH · 09-10-2005, 07:06 PM

bump

mholt · 09-10-2005, 07:17 PM

At the beginning of the file where the post is made. Before any other headers are sent.

TUFKATH · 09-10-2005, 07:22 PM

Quote:

Warning: Cannot modify header information - headers already sent by (output started at /home/www/taylorhewitt.com/shas/index.php:8) in /home/www/taylorhewitt.com/shas/index.php on line 24

That is what I got.

mholt · 09-10-2005, 09:42 PM

Yeah. Um, post your code IN [ PHP ] TAGS. This means you've already sent headers, or some sort of output, to the browser.

aween · 09-11-2005, 03:31 AM

you have to place the code in the upmost top of the page.

if the top page is:

<?php
// allot fo code

do it like this:
<?php
// the cookie code
// allot fo code

TUFKATH · 09-11-2005, 04:22 PM

Really I did that! Same error though...

Is this going to make the cookie set right after the submit button is pressed? That's my aim.

mholt · 09-11-2005, 04:29 PM

As I requested before, can you PLEASE COPY AND PASTE THE CODE HERE IN PHP TAGS?

Thanks!

TUFKATH · 09-12-2005, 02:25 PM

Sorry I didn't see! I PMed you the code.

mholt · 09-12-2005, 02:29 PM

Taylor.... -_- *grrrr*

I'm lowering your rep... I asked you to post it HERE so that everybody could see, and in [ PHP ] tags so it would be syntax highlighted!

TUFKATH · 09-14-2005, 02:59 PM

I'm sorry I just don't want everybody to see it incase somebody might get my mysql information. And what do you mean lowering my rep??

Encenta.com · 09-14-2005, 04:14 PM

You see that icon which looks like a set of scales underneath the user's information (to the left)?....yeah

TUFKATH · 09-14-2005, 04:57 PM

Yeah I know but it says it's even.

09-04-2005, 04:12 PM	THREAD STARTER #1 (permalink)
TUFKATH Account Suspended Join Date: Sep 2005 Location: Canada Posts: 1,373	mysql stuff with this site on http://shas.taylorhewitt.com ive spent the past 15 minutes constantly deleting spam of this site by a ****ing loser. he is pissing me off so much! it wont end! its set to automaticly submit to the mysql database, then withdraw it and post it there. what can i do so i have to verify it first? thanks

09-04-2005, 04:23 PM	#2 (permalink)
mholt DNOA Member Join Date: May 2004 Posts: 5,040	Have them register first, or do a simple image verification. Ah, these aren't bots. Okay, make sure they can only post maybe... once per day. An easy way, yet easily breakable way to do this is to set a cookie that expires in 24 hours. Then, if the cookie exists as they try to post, do not allow it to be submitted. Last edited by compuXP; 09-04-2005 at 04:36 PM.

09-04-2005, 05:01 PM	#3 (permalink)
nasaboy007 Senior Member Join Date: Jul 2005 Location: NJ Posts: 1,219	yeah, cookies are a good idea. if u make them register, you can log their IP and set sessions and cookies and then have a lot of fun with them hehe. but seriously, u can set a cookie so that it only allows a certain amount of submissions. sorta like flood control on forums. __________________ Hacksar.com - Your source for random computer tips and tricks! MySiteMemberships.com - Keep track of your site registration information! Like my post? Rep is appreciated!

09-04-2005, 06:33 PM	#5 (permalink)
RJ NamePros Webmaster Join Date: Feb 2003 Posts: 12,930 Follow @DomainBuyer	You want to moderate the comments before they go public on your site? I don't know what script you're using, but it should be a simple job for a php coder to modify it to require moderation. In short, add a column to your MySQL table named status and have it default to 0 when new entries are submitted. Then have your site only publically display rows where status=1. Then setup an admin page to view unapproved comments and approve them. __________________ @DomainBuyer facebook

09-08-2005, 06:52 PM	#12 (permalink)
mholt DNOA Member Join Date: May 2004 Posts: 5,040	Oh, the date_here_methinks thing? PHP Code: `$date = "F d Y";` That's off the top of my head, but that produces a human-formatted date. Replace "date_here_methinks" with: $date And that just puts the $date into the cookie as its content.

09-04-2005, 06:22 PM	THREAD STARTER #4 (permalink)
TUFKATH Account Suspended Join Date: Sep 2005 Location: Canada Posts: 1,373	The thing is it's supposed to be completely anonymous...

09-04-2005, 07:04 PM	THREAD STARTER #6 (permalink)
TUFKATH Account Suspended Join Date: Sep 2005 Location: Canada Posts: 1,373	Yeah I don't know how to do that...

09-05-2005, 10:07 AM	THREAD STARTER #8 (permalink)
TUFKATH Account Suspended Join Date: Sep 2005 Location: Canada Posts: 1,373	Most other forums are made to be helpful free of cost but I don't really have money to spend on this sort of thing...

09-05-2005, 10:17 AM	#9 (permalink)
mholt DNOA Member Join Date: May 2004 Posts: 5,040	Here... When they post a topic, use this: setcookie("cookiename", "date_here_methinks", 606024); That sets a cookie that expires in 1 day. Then, when they post. if (isset($_COOKIE['cookiename'])) { echo("ERROR > You can only post once per day."); exit; } That should work

09-07-2005, 03:32 PM	THREAD STARTER #10 (permalink)
TUFKATH Account Suspended Join Date: Sep 2005 Location: Canada Posts: 1,373	What do I put for the date thingy?

09-08-2005, 06:43 PM	THREAD STARTER #11 (permalink)
TUFKATH Account Suspended Join Date: Sep 2005 Location: Canada Posts: 1,373	bump

09-09-2005, 03:45 PM	THREAD STARTER #13 (permalink)
TUFKATH Account Suspended Join Date: Sep 2005 Location: Canada Posts: 1,373	Thanks. But where do I put this stuff? setcookie("cookiename", "date_here_methinks", 606024); if (isset($_COOKIE['cookiename'])) { echo("ERROR > You can only post once per day."); exit; }

09-10-2005, 07:06 PM	THREAD STARTER #14 (permalink)
TUFKATH Account Suspended Join Date: Sep 2005 Location: Canada Posts: 1,373	bump

09-10-2005, 07:17 PM	#15 (permalink)
mholt DNOA Member Join Date: May 2004 Posts: 5,040	At the beginning of the file where the post is made. Before any other headers are sent.

09-10-2005, 09:42 PM	#17 (permalink)
mholt DNOA Member Join Date: May 2004 Posts: 5,040	Yeah. Um, post your code IN [ PHP ] TAGS. This means you've already sent headers, or some sort of output, to the browser.

09-11-2005, 03:31 AM	#18 (permalink)
aween Pro Coder & Designer Join Date: Apr 2005 Location: Netherlands Posts: 967	you have to place the code in the upmost top of the page. if the top page is: <?php // allot fo code do it like this: <?php // the cookie code // allot fo code __________________ aween web development

09-11-2005, 04:22 PM	THREAD STARTER #19 (permalink)
TUFKATH Account Suspended Join Date: Sep 2005 Location: Canada Posts: 1,373	Really I did that! Same error though... Is this going to make the cookie set right after the submit button is pressed? That's my aim.

09-11-2005, 04:29 PM	#20 (permalink)
mholt DNOA Member Join Date: May 2004 Posts: 5,040	As I requested before, can you PLEASE COPY AND PASTE THE CODE HERE IN PHP TAGS? Thanks!

09-12-2005, 02:25 PM	THREAD STARTER #21 (permalink)
TUFKATH Account Suspended Join Date: Sep 2005 Location: Canada Posts: 1,373	Sorry I didn't see! I PMed you the code.

09-12-2005, 02:29 PM	#22 (permalink)
mholt DNOA Member Join Date: May 2004 Posts: 5,040	Taylor.... -_- grrrr I'm lowering your rep... I asked you to post it HERE so that everybody could see, and in [ PHP ] tags so it would be syntax highlighted!

09-14-2005, 02:59 PM	THREAD STARTER #23 (permalink)
TUFKATH Account Suspended Join Date: Sep 2005 Location: Canada Posts: 1,373	I'm sorry I just don't want everybody to see it incase somebody might get my mysql information. And what do you mean lowering my rep??

09-14-2005, 04:14 PM	#24 (permalink)
Encenta.com SQLdumpster.com Join Date: Jun 2005 Location: West Sussex, UK Posts: 573 Follow @MiseriaSK	You see that icon which looks like a set of scales underneath the user's information (to the left)?....yeah __________________ Encenta - Amazon Associates CMS

09-14-2005, 04:57 PM	THREAD STARTER #25 (permalink)
TUFKATH Account Suspended Join Date: Sep 2005 Location: Canada Posts: 1,373	Yeah I know but it says it's even.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Domain sale. 24 hours only.	HHDomains	Domains For Sale - Make Offer	1	08-09-2004 07:48 PM
Lots of domains. All priced to sell fast. Fontdb.com ShareForums.com and many more.	HHDomains	Domains For Sale - Make Offer	1	07-31-2004 01:11 PM
Completely Revamped Turnkey Games-Related Site for Sale	gph	Turnkey Websites For Sale	0	07-25-2004 04:30 PM