root/trunk/robots/delete_comm.bot.php

Revision 1, 0.7 KB (checked in by anonymous, 7 years ago)

initial import

Line 
1#!/usr/bin/php
2<?
3include ('../includes/includes.inc.php');
4include ('../includes/config/global.inc.php');
5
6$db =& DB::connect($dsn);
7if (DB::isError($db))
8                error_log($_SERVER['HTTP_HOST'].' | '.__FILE__.' | Connexion SQL impossible : '.$db->getMessage());
9
10$db->setFetchMode(DB_FETCHMODE_ASSOC);
11
12$tables = array ('blog_comment','community','community_event','community_post','community_topic','invitation','session','settings', 'todo','user_comm', 'rss_blog','rss_blog_ticket');
13
14foreach($tables as $table)
15    $db->query('DELETE FROM ! WHERE id=?', array($table, $argv[1]) );
16print $user['id'].' '.$user['fname'].' '.$user['lname']."\n";
17
18$db->disconnect();
19?>
Note: See TracBrowser for help on using the browser.