UosiU

-- phpMyAdmin SQL Dump
-- version 2.11.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Czas wygenerowania: 11 Lip 2008, 20:50
-- Wersja serwera: 5.0.51
-- Wersja PHP: 5.2.6
 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 
--
-- Baza danych: `bot`
--
 
-- --------------------------------------------------------
 
--
-- Struktura tabeli dla  `config`
--
 
CREATE TABLE IF NOT EXISTS `config` (
  `pause` INT(1) UNSIGNED NOT NULL DEFAULT '1',
  PRIMARY KEY  (`pause`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
 
-- --------------------------------------------------------
 
--
-- Struktura tabeli dla  `users`
--
 
CREATE TABLE IF NOT EXISTS `users` (
  `ID` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `number` VARCHAR(15) COLLATE utf8_polish_ci NOT NULL,
  `nick` VARCHAR(30) COLLATE utf8_polish_ci NOT NULL,
  `pause` INT(11) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci AUTO_INCREMENT=12 ;

#!/usr/bin/php
<?php
/*
  BOT KLASOWY 1.5
  Copyright (C) 2007,2008 by uosiu (uosiekspam on server uosiu with a dot info)
  GNU GPL v3 published
  This script comes without ANY warranty of work, in state 'as is'
  Author is not responsible for any demages or data loss or any other weird effects caused by this script
*/
 
//---- USER EDITABLE CONFIGURATION ---
$mysql_host = 'localhost';
$mysql_user = 'uosiu';
$mysql_passwd = 'tojezdtajnehasuoono';
$mysql_db = 'bot';
$ekg_pipe = '/home/uosiu/rurka';
$zapisz_passwd = 'cos';
global $zapisz_passwd;
//---- END OF USER EDITABLE CONFIGURATION
$lock=0;
mysql_pconnect($mysql_host, $mysql_user, $mysql_passwd);
mysql_select_db($mysql_db);
 
$odpowiedz = mysql_query("SELECT pause FROM `config` WHERE 1"); 
$row = mysql_fetch_assoc($odpowiedz);
//--- CHECK THAT BOT ISN'T LOCKED
 
if ($row['pause'] != 0) {
  while(true) {
    unset($row);
    unset($odpowiedz);
    $odpowiedz = mysql_query("SELECT pause FROM `config` WHERE 1"); 
    $row = mysql_fetch_assoc($odpowiedz);
    if ($row['pause'] == 0) break;
    echo "lock";
    sleep(2);
  }
}
$odpowiedz = mysql_query ("UPDATE `bot`.`config` SET `pause` = '1' WHERE `config`.`pause` = 0");
//--- GETTING NICK OF MSG SENDER
$odpowiedz = mysql_query(sprintf("SELECT nick FROM `users` WHERE number = %d LIMIT 1", (int) $argv[1])); 
$row = mysql_fetch_assoc($odpowiedz);
$nadawca = $row['nick'];
//--- CHECKING THAT USER IS SUBSCRIBED TO SPAMLIST ;)
if(empty($row)) {
  $zapisany=0;
}
else {
  $zapisany=1;
}
unset($odpowiedz);
unset($row);
 
 
//--- MSG SENDER NUMBER
$numer_nadawcy = $argv['1'];
 
//--- EXPLODING MSG
$tmp = explode(' ',$argv[2], 2);
$polecenie = $tmp[0];
$wartosci = $tmp[1];
 
 
//--- INCLUDING FUNCTIONS DEFINED IN EXTERNAL FILE
//require('funkcje.php');
/*
function zapisany($numer_nadawcy) {
  $a = mysql_query(sprintf("SELECT number FROM `users` WHERE number = %d LIMIT 1", (int) $numer_nadawcy)); 
  if(mysql_num_rows($a)==0) {
    return false;
  }
  else {
    return true;
  }
}
*/
function zapisani($numer_nadawcy) {
  echo $numer_nadawcy;
  $a = mysql_query("SELECT nick FROM `users` WHERE 1"); 
  $file = fopen('/home/uosiu/rurka', 'w');
  fwrite($file, "/msg $numer_nadawcy ");
  while ($b = mysql_fetch_assoc($a)) {
    fwrite($file, $b['nick'].', ');
  }
  fwrite($file, "\n");
  fclose($file);
}
 
function wypisz($numer_nadawcy) {
  $a = mysql_query(sprintf("DELETE FROM `users` WHERE number = %d LIMIT 1", (int) $numer_nadawcy));
  $b = mysql_fetch_assoc($a);
  $file = fopen('/home/uosiu/rurka', 'w');
  fwrite($file, "/msg ".$numer_nadawcy." Zostales/as wypisany/a z systemu wysylkowego klasy 2F\n");
  fclose($file);
}
 
function ping($numer_nadawcy) {
  $file = fopen('/home/uosiu/rurka', 'w');
  fwrite($file, "/msg ".$numer_nadawcy." pong\n");
  fclose($file);
}
 
function zapisz($numer_nadawcy, $password, $nick) {
$file = fopen('/home/uosiu/rurka' ,'w');
if (!zapisany($numer_nadawcy)) {
  if ( $password == "lo8jesteloelo") {
    fwrite($file, "/msg $numer_nadawcy Zostales/as zapisany/a do systemu wysylkowego klasy 2F. Witamy!\n");
    $a = mysql_query("INSERT INTO `bot`.`users` (`ID`, `number`, `nick`, `pause`) VALUES ( NULL, '$numer_nadawcy', '$nick', '0')");
    $b = mysql_fetch_assoc($a);
  }
}
else {
  fwrite($file, "/msg $numer_nadawcy Juz jestes zapisany/a!\n");
}
fclose($file);
}
 
function msg($numer_nadawcy, $nadawca, $tresc) {
//if (zapisany($numer_nadawcy)) {
$file = fopen('/home/uosiu/rurka' ,'w');
  $a = mysql_query("SELECT number FROM `users` WHERE pause = '0'"); 
  while ($b = mysql_fetch_assoc($a)) {
    if ($numer_nadawcy != $b['number']) {
      fwrite($file, "/msg ".$b['number']." <".$nadawca."> $tresc\n");
      sleep(1);
    }
  }
fclose($file);
//}
}
function pause($numer_nadawcy) {
  $file = fopen('/home/uosiu/rurka' ,'w');
  $odpowiedz = mysql_query(sprintf("SELECT pause FROM `users` WHERE number = %d LIMIT 1", (int) $numer_nadawcy)); 
  $row = mysql_fetch_assoc($odpowiedz);
  if ($row['pause'] == '0') {
    $odpowiedz = mysql_query(sprintf("UPDATE `bot`.`users` SET `pause` = '1' WHERE number = %d LIMIT 1", (int) $numer_nadawcy)); 
    fwrite($file, "/msg ".$numer_nadawcy." zapauzowano\n");
  }
  else {
    $odpowiedz = mysql_query(sprintf("UPDATE `bot`.`users` SET `pause` = '0' WHERE number = %d LIMIT 1", (int) $numer_nadawcy)); 
    fwrite($file, "/msg ".$numer_nadawcy." odpauzowano\n");
  }
fclose($file);
}
//--- PROCESSING MSG
switch ($polecenie) {
case "zapisz":
    $cos = explode(' ', $wartosci, 2);
    //zapisz($numer_nadawcy, password, nick)
    zapisz($numer_nadawcy, $cos[0], $cos[1]);
    break;
case "wypisz":
    wypisz($numer_nadawcy);
    break;
case "zapisani":
    if ($zapisany == 1) {
      zapisani($numer_nadawcy);
    }
    break;
case "msg":
    if ($zapisany == 1) {
      msg($numer_nadawcy, $nadawca, $wartosci);
    }
    break;
case "ping":
    if ($zapisany == 1) {
      ping($numer_nadawcy);
    }
    break;