Hi,

i am new to the list and wonder if i can ask some PHP question here: if i fail the meaning of this list pls just ignore. thanks for answer anyhow ;)

NEWSLETTER : i couldnt find a function like this in mediawiki and did not find an extension, too. during searching for extentions i decided to write a simple extension to mail a newsletter to registered users (only some dozend) but failed as i am not so trained with php

must mention that the newsletter function already worked fine when i separated the newslettersend-module and used the (a little modified)original emailform of specialpages to try it. but i wanted a special entry in specialpages as NEWSLETTER and now mixed something up. --the mailform appears but when i "submit" it complains class double-defined and i cant find out where --i also want to separate the db-connection as this seems to be a little unsecure ;) (how?)

best regards Arno

##----------------------------------------------------------- ##newsletter.php ##----------------------------------------------------------- <?php # to use : include this file from your LocalSettings.php like this # include("extensions/newsletter.php");

$wgExtensionFunctions[] = "wfnewsletter"; # This extension acts as a special page require_once( 'includes/SpecialPage.php' );

function wfnewsletter() { //START EXTENSION FUNC class NewsLetter extends SpecialPage { function NewsLetter() { SpecialPage::SpecialPage("NewsLetter"); }

function execute( $par ) { global $wgUser, $wgOut, $wgRequest; $nt = Title::newFromURL( "newFromURL"); $nu = User::newFromName( "newFromName"); $id = $nu->idForName(); $f = showForm($target); if ( "success" == $action ) { $f->showSuccess(); } else if ( "submit" == $action && $wgRequest->wasPosted() ) { $f->doSubmit(); } else { $f->showForm( "" ); } } // end execute function } // end Newsletter class global $wgMessageCache; SpecialPage::addPage( new NewsLetter ); $wgMessageCache->addMessage( "newsletter", "NEWSLETTER" );

function EmailUserForm( $addr, $target ) { global $wgRequest; $this->mAddress = $addr; $this->target = "NEWSLETTER"; $this->text = $wgRequest->getText( 'wpText' ); $this->subject = $wgRequest->getText( 'wpSubject' ); }//end function EmailUserForm

function showForm( $err ){ global $wgOut, $wgUser, $wgLang; $wgOut->setPagetitle("newsletter to all registered users"); if ( $this->subject === "" ) { $this->subject = "[..........yourwikiname.....-newsletter] no. "; } $emf = "sender"; $sender = $wgUser->getName(); $emr = "re"; $emm = "message"; $ems = "send"; $encSubject = htmlspecialchars( $this->subject );

$titleObj = Title::makeTitle( NS_SPECIAL, "Emailuser" ); $action = $titleObj->escapeLocalURL( "target={$this->target}&action=submit" );

if ( "" != $err ) { $wgOut->setSubtitle( wfMsg( "formerror" ) ); $wgOut->addHTML( "<p><font color='red' size='+1'>{$err}</font>\n" ); } $wgOut->addHTML( "<p> <form id="emailuser" method="post" action="{$action}"> <table border=0><tr> <td align=right>{$emf}:</td> <td align=left><strong>{$sender}</strong></td> </tr><tr> <td align=right>{$emt}:</td> <td align=left><strong>{$rcpt}</strong></td> </tr><tr> <td align=right>{$emr}:</td> <td align=left> <input type=text name="wpSubject" value="{$encSubject}"> </td> </tr><tr> <td align=right>{$emm}:</td> <td align=left> <textarea name="wpText" rows=10 cols=60 wrap=virtual>" . htmlspecialchars( $this->text ) . "</textarea> </td></tr><tr> <td>&nbsp;</td><td align=left> <input type=submit name="wpSend" value="{$ems}"> </td></tr></table> </form>\n" ); }//end function showForm

function doSubmit(){ global $wgOut, $wgUser, $wgLang, $wgOutputEncoding; $from = wfQuotedPrintable( $wgUser->getName() ) . " <" . $wgUser->getEmail() . ">"; $mailResult = newslettersend( $this->mAddress, $from, wfQuotedPrintable( $this->subject ), $this->text ); if (! $mailResult) { $titleObj = Title::makeTitle( NS_SPECIAL, "Emailuser" ); $encTarget = wfUrlencode( $this->target ); $wgOut->redirect( $titleObj->getFullURL( "target={$encTarget}&action=success" ) ); } else $wgOut->addHTML( wfMsg( "usermailererror" ) . $mailResult); }// end function doSubmit()

function showSuccess() { global $wgOut, $wgUser; $wgOut->setPagetitle( wfMsg( "emailsent" ) ); $wgOut->addHTML( wfMsg( "emailsenttext" ) ); $wgOut->returnToMain( false ); }//end function showSuccess()

function newslettersend( $to, $from, $subject, $body ){ global $wgUser, $wgSMTP, $wgOutputEncoding, $wgErrorString; $qto = wfQuotedPrintable( $to ); $headers = "MIME-Version: 1.0\r\n" . "Content-type: text/plain; charset={$wgOutputEncoding}\r\n" . "Content-transfer-encoding: 8bit\r\n" . //"From: {$from}\r\n" . "From: ..............yourname..........."; "X-Mailer: ..........your newsletter"; $wgErrorString = ""; set_error_handler( "mailErrorHandler" ); $Config_host = "localhost"; $ConfigDBname = "...............your db"; $Config_user = "...............dbuser"; $Config_password = "...............password"; //connect to SQL $db = mysql_connect($Config_host, $Config_user,$Config_password) or die ("no connection possible"); //select database mysql_select_db($ConfigDBname, $db) or die ("connection to DB failed"); // define query $z = 0; $sql = "SELECT * FROM user"; // execute query $result = mysql_query($sql); while($arr = mysql_fetch_array($result, MYSQL_ASSOC)) { $name = $arr['user_real_name']; $username = $arr['user_name']; $email = $arr['user_email']; mail( "......try with your own email-adress first.....",$subject, $body, $headers ); echo($name); $z++; } restore_error_handler(); return $wgErrorString;

//close query mysql_free_result($result); //close sql-connection mysql_close($db); }//end function newsletter

function mailErrorHandler( $code, $string ) { global $wgErrorString; $wgErrorString = preg_replace( "/^mail(): /", "", $string ); }//end function mailErrorHandler } # End of extension function

?>