Hi, some changes to my mail:
global $wgUser, $wgOut; $skin = $wgUser->getSkin(); $table = 'mytable'; $id = 0; $wgOut->addHtml( $skin->link( $this->getTitle(), wfMsg('mymessage'), array(), array( 'action' => 'delete_all', 'table' => $table) ) ); ... global $wgRequest; $action = htmlentities( $wgRequest->getText( 'action' ) ); $table = htmlentities( $wgRequest->getText( 'table' ) ); switch( $action ) { case 'delete_all': $this->delete_all( $table ); break; default: break; } ... private function delete_all( $table ) { // $table == 'mytable' is for controlling that the user can't delete any Mediawiki tables if( ( $table == 'mytable' ) OR ( $table == 'mytable2' ) ) { $dbw = wfGetDB( DB_MASTER ); $dbw->delete( $table, '*' ); } } So you can add for all actions a function. Viele Grüße Jan -----Ursprüngliche Nachricht----- Von: mediawiki-l-boun...@lists.wikimedia.org [mailto:mediawiki-l-boun...@lists.wikimedia.org] Im Auftrag von Jan Luca Gesendet: Freitag, 28. August 2009 19:13 An: 'MediaWiki announcements and site admin list' Betreff: Re: [Mediawiki-l] Special Page: Executing SQL query with a browser click Hi, I would made it with a url parameter: $skin = $wgUser->getSkin(); $table = 'mytable'; $id = 0; $wgOut->addHtml( $skin->link( $this->getTitle(), wfMsg('mymessage'), array(), array( 'action' => 'delete', 'table' => $table, 'id' => $id ) ) ); ... $action = htmlentities( $wgRequest->getText( 'action' ) ); $table = htmlentities( $wgRequest->getText( 'table' ) ); $id = htmlentities( $wgRequest->getText( 'id' ) ); if( $action == 'delete' AND ( $table == 'mytable' ) ) $this->delete( $table, $id ); ... private function delete( $table, $id ) { $dbw = wfGetDB( DB_MASTER ); $dbw->delete( $table, array( 'id' => $id ) ); } Viele Grüße Jan -----Ursprüngliche Nachricht----- Von: mediawiki-l-boun...@lists.wikimedia.org [mailto:mediawiki-l-boun...@lists.wikimedia.org] Im Auftrag von Eric K Gesendet: Freitag, 28. August 2009 14:08 An: mediawiki-l@lists.wikimedia.org Betreff: [Mediawiki-l] Special Page: Executing SQL query with a browser click (sending again, my last message didnt appear in the list) ------------------- In my own special page, I've made a custom query (e.g., DELETE * from table). I want to display an HTML link, which when clicked by the user viewing that page executes that SQL query. How can I do that? _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l