x<?php
set_time_limit(0);

date_default_timezone_set("Europe/Warsaw");

//server
$server = "irc.onlinegamesnet.net";
$port = 6667;
$server_pass = " ";
//user
$nick = "Toster";
$ident = "Toster";
$realname = "Toster - Najlepsze suchary na rynku!";
//channels
$channels = ['## '];
//mysql
$mysql_server= " ";
$mysql_user= " ";
$mysql_pass= " ";
$mysql_database= " ";
$mysql_table_name= " ";
$mysql_table_column= " ";
// Admin area for mysql error
$adminnick = "Chire";
// END OF CONFIG AREA

$connected = 0;
$socket = fsockopen($server,$port,$errstr,$errno,2);

stream_set_blocking($socket,0);

sendRawCommand("PASS :$server_pass");
sendRawCommand("NICK $nick");
sendRawCommand("USER $ident - - :$realname");

while(true) {
    usleep(1000);
    while ($data = fgets($socket)) {
        echo($data);
        $data = str_replace("\r", "", $data);
        $data = str_replace("\n", "", $data);
        $ping = explode(' :', $data);
        $rpl = explode(' ', $data);
        $lookupcmd = explode('PRIVMSG', $data);
        @$lookupcmd = explode(' :', $lookupcmd[1]);
        $from_chan = explode(' ', $data);
        if($ping[0]=="PING") {
          sendRawCommand("PONG ".$ping[1]);
        }
        if($rpl[1]=="001") {
                $connected=1;
                $check_connection=1;
                for ($i=0; $i < count($channels) ; $i++) {
                        sendRawCommand("JOIN ".$channels[$i]);
                }
        }
        if($rpl[1]=="391" && $rplcheck=1) {
                $rplcheck = 2;
        }
        if(@$lookupcmd[1]==".joke") {
                $db = new mysqli($mysql_server, $mysql_user, $mysql_pass, $mysql_database);
                if($db->connect_errno > 0){
                        sendRawCommand("PRIVMSG ".$adminnick." :Unable to connect to database [' . $db->connect_error . ']");
                }
                else {
                        $result = $db->query("SELECT ".$mysql_table_column." FROM `".$mysql_table_name."` ORDER BY RAND() LIMIT 1");
                        $row = $result->fetch_assoc();
                        $joke = explode("\n", $row[$mysql_table_column]);
                        for ($i=0; $i<count($joke); $i++) {
                                sendRawCommand("PRIVMSG ".$from_chan[2]." :".$joke[$i]);
                        }
                }
                $db->close();
        }
    }
    if(date('i')%2==0 && @$connected==1 && @$check_connection==1) {
        sendRawCommand("time");
        $check_connection=0;
        $rplcheck=1;
    }
    if(date('i')%2!=0 && @$check_connection==0 && @$rplcheck>=1) {
        $check_connection=1;
        if($rplcheck==1) {
                socket_close($socket);
                usleep(200);

                $socket = fsockopen($server,$port,$errstr,$errno,2);

                        stream_set_blocking($socket,0);

                        sendRawCommand("PASS :$server_pass");
                        sendRawCommand("NICK $nick");
                        sendRawCommand("USER $ident - - :$realname");

                        $rplcheck=0;

        }
        $rplcheck=0;
    }
}

function sendRawCommand($sendstring) {
    global $socket;
    $sendstring = $sendstring . "\n";
    fputs($socket, $sendstring);
    return(1);
};
?>