$5 USD for a working script

mholt · 12-14-2005, 08:30 AM

Hello,

I need a PHP script that goes through all rows in a table and:

A) If the field "last_login" is 20 days old or more, it sends an email to the user, email field being "email" notifying that he/she has 10 days to do login to his/her account to keep it from being deleted.

B) DELETES the row if the "last_login" field is 30 days old or more.

The catch? This must be tested on YOUR OWN SERVER!

I want to see a WORKING SAMPLE - this script is for www.VirtualDN.com - and I simply cannot risk a script glitch on my own server.

The dates are stored in this PHP date() format: F d, Y

That's:

February 02, 2005

...similar to that. Convert it if you must but I need it to be bug-free.

Thanks for anybody who can do this... $5 will be sent via PayPal to a working script.
-Matt

sjp · 12-14-2005, 08:52 AM

You didn't give enough information (name of the user, mysql type of the date, database type, ...) but you can use this to create your own script:

PHP Code:

  <?

 
$link = mysql_connect('localhost', 'root', '');

 
if (!$link)

{

    die("Can't connect: " . mysql_error());

}

else

{

    mysql_select_db('foo');

 
    echo "Deleting users who didn't log in during the last 30 days<br />";

    

    mysql_query("delete from user_table where date_sub(curdate(), interval 30 day) > last_login");

    

    $result = mysql_query("select id, email from user_table where date_sub(curdate(), interval 20 day) > last_login");

    

    if (!$result)

    {

        die("Error: Invalid query: " . mysql_error());

    }

    

    echo "Sending mail top users who didn't log in during the last twenty days:<br />";

    

    while ($row = mysql_fetch_assoc($result))

    {

        if (mail($row['email'], "Log in", "Or your account is killed"))

        {

            echo 'Sent mail to user with ID ' . $row['id'] . "<br />";

        }

        else

        {

            echo 'Mailing user with ID ' . $row['id'] . " failed <br />";

        }

    }

}

 
?>

mholt · 12-14-2005, 12:14 PM

I told you the type of date - F d, Y which really only fits in VARCHAR... use some logic. Database type... MySQL .... really: What other database system implements w/ PHP so well and is used so commonly?

I am not willing to buy a script from somebody that does not know what they're doing. Please write an original script for you to get your $5 - again it must be tested on your own server.

sjp · 12-14-2005, 12:20 PM

Quote:

Originally Posted by compuXP

I am not willing to buy a script from somebody that does not know what they're doing.

I really appreciate 15 year olds who store timedate stamps in varchar fields telling me I don't know what I'm doing. The script works well (assuming you knew how to set up database tables, which you unfortunately don't) and it's tested on my server.

Edit: Here, because I'm a nice guy: Look into the MySQL cast operator to create a workaround for your horrible table design. Something like "select cast(last_login as date) from table". Maybe you're lucky and that works.

mholt · 12-14-2005, 01:00 PM

I'm glad you appreciate the fact that I told you that you don't know what you're doing. Your welcome.

And, obviously you don't know what you're doing since I specifically ask that I see a sample of it.

Now bug off and I would appreciate it if somebody else could follow my criteria.

UKMatt · 12-14-2005, 02:32 PM

lol, after talking to him like that ... do you really expect someone to help you ???

mch · 12-14-2005, 03:14 PM

Yeah, you need to post the table structure at least. And honestly, if this is such a critical thing for you (and obviously it is and you can't risk screwing up your server/database/site), I think you should offer more.

BTW, sjp's solutions looks fine to me (different coding style, though

).

mholt · 12-14-2005, 03:17 PM

Table structure ... why? I give you the fields that are used ...

jdk · 12-16-2005, 01:50 PM

Wow, very interesting thread. Let me get right on this for you.

mholt · 12-16-2005, 01:57 PM

THANK you!

Many thanks again. I look forward to seeing your results

mholt · 12-18-2005, 04:38 PM

Any progress?

Btw, jdk, how am I supposed to reply to your PM when you have disabled Private Messages?

jdk · 12-18-2005, 04:58 PM

I sent an email to tech to find out why since in my options it says they are enabled.

12-14-2005, 08:30 AM	#1 (permalink)
mholt DNOA Member Join Date: May 2004 Location: Utah Posts: 5,041 18.01 NP$ (Donate)	$5 USD for a working script Hello, I need a PHP script that goes through all rows in a table and: A) If the field "last_login" is 20 days old or more, it sends an email to the user, email field being "email" notifying that he/she has 10 days to do login to his/her account to keep it from being deleted. B) DELETES the row if the "last_login" field is 30 days old or more. The catch? This must be tested on YOUR OWN SERVER! I want to see a WORKING SAMPLE - this script is for www.VirtualDN.com - and I simply cannot risk a script glitch on my own server. The dates are stored in this PHP date() format: F d, Y That's: February 02, 2005 ...similar to that. Convert it if you must but I need it to be bug-free. Thanks for anybody who can do this... $5 will be sent via PayPal to a working script. -Matt __________________ codeboards A high-quality community of programmers -- Join today and post! We want new members!

12-14-2005, 08:52 AM	#2 (permalink)
sjp NamePros Member Join Date: Oct 2005 Location: Andromeda Posts: 136 369.50 NP$ (Donate)	You didn't give enough information (name of the user, mysql type of the date, database type, ...) but you can use this to create your own script: PHP Code: <? $link = mysql_connect('localhost', 'root', ''); if (!$link) { die("Can't connect: " . mysql_error()); } else { mysql_select_db('foo'); echo "Deleting users who didn't log in during the last 30 days<br />"; mysql_query("delete from user_table where date_sub(curdate(), interval 30 day) > last_login"); $result = mysql_query("select id, email from user_table where date_sub(curdate(), interval 20 day) > last_login"); if (!$result) { die("Error: Invalid query: " . mysql_error()); } echo "Sending mail top users who didn't log in during the last twenty days:<br />"; while ($row = mysql_fetch_assoc($result)) { if (mail($row['email'], "Log in", "Or your account is killed")) { echo 'Sent mail to user with ID ' . $row['id'] . "<br />"; } else { echo 'Mailing user with ID ' . $row['id'] . " failed <br />"; } } } ?> __________________ Christmas FAQ \| Hussein Trial Blog \| News for developers \| Find your IP address \| Anti-Spyware resource \| The Interweb \| Halloween FAQ \| sweetgifts.us \| lqfp.com

12-14-2005, 12:14 PM	#3 (permalink)
mholt DNOA Member Join Date: May 2004 Location: Utah Posts: 5,041 18.01 NP$ (Donate)	I told you the type of date - F d, Y which really only fits in VARCHAR... use some logic. Database type... MySQL .... really: What other database system implements w/ PHP so well and is used so commonly? I am not willing to buy a script from somebody that does not know what they're doing. Please write an original script for you to get your $5 - again it must be tested on your own server. __________________ codeboards A high-quality community of programmers -- Join today and post! We want new members!

12-14-2005, 01:00 PM	#5 (permalink)
mholt DNOA Member Join Date: May 2004 Location: Utah Posts: 5,041 18.01 NP$ (Donate)	I'm glad you appreciate the fact that I told you that you don't know what you're doing. Your welcome. And, obviously you don't know what you're doing since I specifically ask that I see a sample of it. Now bug off and I would appreciate it if somebody else could follow my criteria. __________________ codeboards A high-quality community of programmers -- Join today and post! We want new members!

12-14-2005, 02:32 PM	#6 (permalink)
UKMatt NamePros Member Join Date: Dec 2005 Posts: 99 32.30 NP$ (Donate)	lol lol, after talking to him like that ... do you really expect someone to help you ???

12-14-2005, 03:14 PM	#7 (permalink)
mch NamePros Regular Join Date: Nov 2005 Location: EU Posts: 248 99.25 NP$ (Donate)	Yeah, you need to post the table structure at least. And honestly, if this is such a critical thing for you (and obviously it is and you can't risk screwing up your server/database/site), I think you should offer more. BTW, sjp's solutions looks fine to me (different coding style, though ).

12-14-2005, 03:17 PM	#8 (permalink)
mholt DNOA Member Join Date: May 2004 Location: Utah Posts: 5,041 18.01 NP$ (Donate)	Table structure ... why? I give you the fields that are used ... __________________ codeboards A high-quality community of programmers -- Join today and post! We want new members!

12-16-2005, 01:50 PM	#9 (permalink)
jdk Senior Member Join Date: Jul 2004 Location: Florida Posts: 1,223 306.40 NP$ (Donate)	Wow, very interesting thread. Let me get right on this for you. __________________ All bids are valid for 24 hours unless otherwise stated.

12-16-2005, 01:57 PM	#10 (permalink)
mholt DNOA Member Join Date: May 2004 Location: Utah Posts: 5,041 18.01 NP$ (Donate)	THANK you! Many thanks again. I look forward to seeing your results __________________ codeboards A high-quality community of programmers -- Join today and post! We want new members!

12-18-2005, 04:38 PM	#11 (permalink)
mholt DNOA Member Join Date: May 2004 Location: Utah Posts: 5,041 18.01 NP$ (Donate)	Any progress? Btw, jdk, how am I supposed to reply to your PM when you have disabled Private Messages? __________________ codeboards A high-quality community of programmers -- Join today and post! We want new members!

12-18-2005, 04:58 PM	#12 (permalink)
jdk Senior Member Join Date: Jul 2004 Location: Florida Posts: 1,223 306.40 NP$ (Donate)	I sent an email to tech to find out why since in my options it says they are enabled. __________________ All bids are valid for 24 hours unless otherwise stated.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Huge Script Pack for $5 with Resale Rights	dsforsaken	Scripts For Sale	32	12-03-2005 08:46 PM
[urgent] Help! Mass_Add script not working for olate	WuLabsWuTecH	Programming	0	04-23-2005 02:49 PM
Domain Parking Script	ezimedia	Parking & Traffic Monetization	3	03-02-2004 11:17 PM