Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
Prev Previous Post   Next Post Next
  #1  
Old 02-07-2004, 08:18 PM
thesatman thesatman is offline
 
Join Date: Aug 2002
Posts: 27
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Imap problem

Hi i'm trying to get a script working but having major problems, so would love some help please.

Here's the code-

PHP:

if (isset($sessuser)&&($action=="acceptall"))
{
$query="select password from users where username='$sessuser'";
$q->query($query);
$q->next_record();
$password=$q->f("password");
$query='select * from pending where userid='.$key;
$q->query($query);
if ($q->nf()>0)
$q->next_record();
$useridvar=$q->f("userid");
$fromevar=$q->f("frome");
$emailsubject=$q->f("subject");
$emailbody=stripslashes($q->f("body"));
$emailheader=stripslashes($q->f("header"));
$q2->query($query);
while ($q2->next_record())
{
{
$query='insert into emails values (NULL, '.$useridvar.', "'.$fromevar.'", 1) ';
$q->query($query);
}
{
$stream = @imap_open("{localhost:143}INBOX",$sessuser.'@'.$m ailservername, $password);
}
imap_append($stream,"{localhost:143}INBOX"
,$emailheader."\r\n"
.$emailbody."\r\n"
);
imap_close($stream);

$useridvar=$q2->f("userid");
$fromevar=$q2->f("frome");
$query='select COUNT(*) as numar from emails where (email="'.$fromevar.'")and(userid="'.$useridvar.'" )';
$q->query($query);
$q->next_record();
if($q->f("numar")==0)
{
$query='insert into emails values (NULL, '.$useridvar.', "'.$fromevar.'", 2) ';
$q->query($query);
}
$query='delete from pending where userid='.$key;
$q->query($query);
}
$action="pendingemails";
}



The above code collects emails stored in the mysql database and forward them to the user . The only problem is , if 10 emails are stored it will send email no.1 10 times... instead of each email once ???? I've been playing for the past 2 days now and can't seem to get it to work.

Any help would be much appricated. (Above code nothing to do with VB, but hope somebody can still help )

Thanks for your help

Chris.
Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:30 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03877 seconds
  • Memory Usage 2,242KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete