Create a new version of paste: f60b2f99

Got an iPhone or iPad? We have a brand new Pastebin App for both devices, and it's totally free! Click here to download the new Pastebin App for iOS.

Public Pastes

Untitled1 sec ago
Untitled2 sec ago
Untitled5 sec ago
Untitled6 sec ago
Untitled6 sec ago
Untitled8 sec ago
Untitled11 sec ago
Mighty Fine 2012 M...23 sec ago

New Paste

// K, background story: I installed a chat on my website, it's coded with a mixture of JavaScript, PHP, and MySQL.
// MySQL tables are ajaxim_blocklists (blocked users), ajaxim_buddylists (this one should be obvious :P), ajaxim_chats (chatrooms), ajaxim_messages 
//(messages sent), and ajaxim_users (once again, obvious).
//Fields for blocklists: id, user, buddy
//Fields for buddylists: id, user, buddy, group
//Fields for chats: room, user, id
//Fields for messages: recipient, sender, message, type, stamp, id
//Fields for users: username, password, email, is_online, last_ping, last_ip, banned, admin, buddyicon, profile, id

//So, I registered a user named "ChatBot", but didn't use the site to log in
//Instead, I went into PHPMyAdmin, and set is_online to '1' (meaning online)
//Next, I created a .php file "Bot.php"

<?php
require('config.php');
mysql_connect($sql_host, $sql_user, $sql_pass);
mysql_select_db($sql_db);

$res = mysql_query("SELECT message FROM ".SQL_PREFIX."messages WHERE type = 'msg'");

while($arr = mysql_fetch_row($res)){
    
echo $arr[0]."<br />";
    }
 ?>

//So, that tells it to select the messages.
//My first problem is that I need it to select more than just the message. I need it to select sender, recipient, and message.
//Next problem is saving it to text.
//I asked someone how to use PHP to save something to a .txt file.
//He gave me this:

$myFile = "File.txt";
$fh = fopen($myFile, 'w') or die("can't open file");
$stringData = "$log\n";
fwrite($fh, $stringData);
$stringData = "meow\n";
fwrite($fh, $stringData);
fclose($fh);

//Next step, he said, was to save $res to a string, and write that string to the document, but he signed out before I had time to ask him how
//to do that.
//Another thing I want to do, is perhaps instead of .txt, make it .html, so I can format it, if at all possible. I want to have a table, sort of
//like this:
 __________________________________________________________________
| Sender | Recipient | Message                                     |
 ------------------------------------------------------------------
|   *    |     *     |                      *                      |
 ------------------------------------------------------------------
//Where * corresponds to the text that goes in that field.
//Except, hopefully an actual table, instead of just symbols.
//Then, based off of this, I'll be able to create tables where type = 'event' or type = 'chatmsg'

Optional Paste Settings

Syntax Highlighting:

Paste Expiration:

Paste Exposure:

Paste Name / Title:

Hello Guest
Sign Up or Login

You are currently not logged in, this means you can not edit or delete anything you paste. Sign Up or Login

Pastebin.com Tools & Applications

iPhone/iPad

Windows

Firefox

Chrome

WebOS

Android

Mac

Opera

Click.to

UNIX

WinPhone