Ejemplo n.º 1
0
<?php

require_once "./xmlWriter.php";
require_once '../database/Database.php';
$database = new Database('master');
$comName = $_GET['communityName'];
$userId = $_GET['userId'];
$query = 'SELECT id FROM communities WHERE name = "' . $comName . '"';
$query = $database->query($query);
if (mysql_num_rows($query) > 0) {
    echo "-1";
} else {
    $xml = new cXmlWriter();
    $xml->push("NewlyInsertedCommunity");
    $xml->push("CommunityInformation");
    $time = time();
    $query = 'INSERT INTO communities (user, name, created)
              VALUES("' . $userId . '",
              "' . $comName . '",
              "' . $time . '")';
    $database->query($query);
    $communityId = mysql_insert_id();
    // store the community id and name
    // get the creator of the community group
    $creatorQuery = "SELECT user FROM communities WHERE id = '" . $communityId . "'";
    $creatorResult = mysql_query($creatorQuery);
    $creatorId = mysql_result($creatorResult, 0, "user");
    $creatorQuery = "SELECT username FROM users WHERE id = '" . $creatorId . "'";
    $creatorResult = mysql_query($creatorQuery);
    $creatorName = mysql_result($creatorResult, 0, "username");
    $xml->element("communityGroupId", $communityId);
if (mysql_num_rows($q) == 0) {
    $time = time();
    //echo "New website\n";
    $q = 'INSERT INTO websites (user, community, name, created, type, scrapeNumTopLevel, scrapeInterval) 
			VALUES (
			"' . $userId . '", 
			"' . $communityId . '", 
			"' . $websiteName . '", 
			"' . $time . '", 
			"' . $type . '", 
			"' . $scrapeNumTopLevel . '", 
			"' . $scrapeInterval . '")';
    $database->query($q);
    $websiteId = mysql_insert_id();
    // declare the return storage XML object
    $xml = new cXmlWriter();
    $xml->push("head");
    $xml->push("WebsiteInformation");
    // store the website information in the XML return object
    $xml->element("id", $websiteId);
    $xml->element("communityId", $communityId);
    $xml->element("name", $websiteName);
    $xml->element("createdTime", $time);
    $xml->element("type", $type);
    // create the database for this new website
    $database = new Database('root');
    $database->query('CREATE DATABASE IF NOT EXISTS ' . $websiteName);
    $database = new Database($websiteName);
    $database->query(file_get_contents('../database/website.txt'), true);
    // insert regexes
    $q = 'INSERT INTO regexes
Ejemplo n.º 3
0
$num_rows = mysql_num_rows($query);
if ($num_rows > 0) {
    echo "-1";
} else {
    $time = time();
    $query = 'INSERT INTO websites (user, community, name, created, type)
              VALUES("' . $userId . '",
              "' . $community . '",
              "' . $websiteName . '",
              "' . $time . '",
              "' . $type . '")';
    $database->query($query);
    $websiteId = mysql_insert_id();
    $database = new Database('root');
    $database->query('CREATE DATABASE ' . $websiteName);
    $database = new Database(strtolower($websiteName));
    // causes problem
    $database->query(file_get_contents('./database/website_temp.txt'));
    $xml = new cXmlWriter();
    $xml->push("NewlyInsertedWebsite");
    $xml->push("WebsiteInformation");
    // store the website id, name, and URL
    $xml->element("websiteId", $websiteId);
    $xml->element("websiteName", $websiteName);
    $xml->element("websiteURL", $websiteURL);
    $xml->element("websiteType", $type);
    $xml->element("websiteCreatedTime", $time);
    $xml->pop();
    $xml->pop();
    echo $xml->getXML();
}
Ejemplo n.º 4
0
        $query = "SELECT id FROM allowedkeywords WHERE community = '" . $communityId . "' AND word = '" . $name . "'";
        $result = $database->query($query);
        $xml = new cXmlWriter();
        $xml->push("NewKeyword");
        $xml->push("Information");
        $id = mysql_result($result, 0, "id");
        $xml->element("id", $id);
        $xml->element("communityId", $communityId);
        $xml->element("name", $name);
        $xml->element("type", "ak");
        $xml->pop();
        $xml->pop();
        echo $xml->getXML();
    } else {
        if ($type === "rw") {
            $database->query("DELETE FROM websites WHERE community = '" . $communityId . "' AND name = '" . $name . "'");
            $database = new Database('root');
            $database->query("DROP DATABASE " . $name);
            $xml = new cXmlWriter();
            $xml->push("RemoveWebsite");
            $xml->push("Information");
            $xml->element("name", $name);
            $xml->element("communityId", $communityId);
            $xml->pop();
            $xml->pop();
            echo $xml->getXML();
        } else {
            echo "-1";
        }
    }
}
Ejemplo n.º 5
0
    $xml = new cXmlWriter();
    $xml->push("LoggedInAccountInformation");
    $xml->push("UserAccountInformation");
    $xml->pop();
    $xml->pop();
    echo $xml->getXML();
} else {
    $q = mysql_fetch_array($q);
    $_SESSION['userId'] = $q['id'];
    $realName = 'SELECT realName 
                  FROM users 
                  WHERE username = "******"
                  AND password = password("' . $password . '")';
    $realName = $database->query($realName);
    $realName = mysql_fetch_array($realName);
    $xml = new cXmlWriter();
    $xml->push("LoggedInAccountInformation");
    // store the user account information
    $xml->push("UserAccountInformation");
    $xml->element("fullName", $realName[0]);
    $xml->element("email", $email);
    $xml->element("password", $password);
    $xml->element("userId", $q[0]);
    $xml->pop();
    // store the user's community group information along with the websites
    // and keywords
    $xml->push("MyCommunityGroups");
    $query = 'SELECT * FROM communities WHERE user = "******"';
    $result = $database->query($query);
    $num_rows = mysql_num_rows($result);
    $xml->element("NumberOfCommunityGroups", $num_rows);
Ejemplo n.º 6
0
$communityId = $_GET['community'];
$websiteName = $_GET['websiteName'];
$database = new Database('communityanalysis');
$q = 'SELECT * FROM allowedkeywords
      WHERE community = "' . $communityId . '"';
// grab all of the keywords which pertain to the community passed in
$q = $database->query($q);
$keywordArray = array();
for ($i = 0; $i < mysql_num_rows($q); $i++) {
    $keywordArray[$i] = mysql_result($q, $i, "word");
}
// switch over to the database which represents our website
//$database = new Database($websiteName);
$database = new Database($websiteName);
// create an XML object
$xml = new cXmlWriter();
$xml->push("WebsiteAnalytics");
$xml->push("Information");
$xml->element("communityId", $communityId);
$xml->element("websiteName", $websiteName);
$xml->pop();
// Keyword Data Section starts here
$xml->push("Keywords");
// loop through database keywords and try to fetch each one
// from the website database keyword list
$counter = 0;
for ($i = 0; $i < count($keywordArray); $i++) {
    $q = 'SELECT id FROM keywords WHERE word = "' . $keywordArray[$i] . '"';
    $q = $database->query($q);
    if (mysql_num_rows($q) > 0) {
        // store the keyword
Ejemplo n.º 7
0
<?php

require_once "./xmlWriter.php";
// connect to the mySQL server and select the database
$host = 'csil-srprj-2.cs.uiuc.edu';
$user = '******';
$password = '******';
$link = mysql_connect($host, $user, $password) or die('Could not connect: ' . mysql_error());
mysql_select_db('communityanalysis') or die('Could not select database<br/>');
$query = "SELECT * FROM websites";
$result = mysql_query($query);
$xml = new cXmlWriter();
$xml->push("head");
$xml->push("AllWebsites");
$xml->element("numberOfWebsites", mysql_num_rows($result));
for ($i = 0; $i < mysql_num_rows($result); $i++) {
    $xml->push("Website" . $i);
    $id = mysql_result($result, $i, "id");
    $name = mysql_result($result, $i, "name");
    $type = mysql_result($result, $i, "type");
    $xml->element("id", $id);
    $xml->element("name", $name);
    $xml->element("type", $type);
    $xml->pop();
}
$xml->pop();
$xml->pop();
echo $xml->getXML();
Ejemplo n.º 8
0
// hostname or ip of server (for local testing, localhost should work)
$dbServer = 'localhost';
// username and password to log onto db server
$dbUser = '******';
$dbPass = '******';
// name of database
$dbName = 'communityanalysis';
$link = mysql_connect("{$dbServer}", "{$dbUser}", "{$dbPass}") or die("Could not connect");
//print "Connected successfully<br>";
mysql_select_db("{$dbName}") or die("Could not select database");
//print "Database selected successfully<br>";
$query = 'SELECT * FROM websites';
$result = mysql_query($query, $link);
// get the number of rows for the table
$num_rows = mysql_num_rows($result);
$xml = new cXmlWriter();
$xml->push("MasterRecordsDatabase");
$xml->push("Communities");
for ($i = 0; $i < $num_rows; $i++) {
    $xml->push("Community" . $i);
    $xml->element("id", mysql_result($result, $i, "id"));
    $xml->element("domain", mysql_result($result, $i, "domain"));
    $xml->element("type", mysql_result($result, $i, "type"));
    $xml->pop();
}
$xml->pop();
$xml->pop();
echo $xml->getXML();
/*
	if($_GET['getData1'] == "1")
	{
Ejemplo n.º 9
0
<?php

// hostname or ip of server (for local testing, localhost should work)
$dbServer = 'localhost';
// username and password to log onto db server
$dbUser = '******';
$dbPass = '******';
// grab the arguments passed from the HTTPService component
$array = array($_GET["mArgsArray"]);
// grab the database name as the first argument in $array
$dbName = $array[0];
$link = mysql_connect("{$dbServer}", "{$dbUser}", "{$dbPass}") or die("Could not connect");
mysql_select_db("{$dbName}") or die("Could not select database");
$xml = new cXmlWriter();
$xml->push("ForumCommunitySingleDatabase");
$xml->push("BasicAnalysis");
// parse the users table for entries and store them in the XML
$query = 'SELECT * FROM analysis';
$result = mysql_query($query, $link);
// get the number of rows for the table
$num_rows = mysql_num_rows($result);
// store the user data table data in the xml
$xml->push("analysis");
for ($i = 0; $i < $num_rows; $i++) {
    $xml->push("Block" . $i);
    if (mysql_result($result, $i, "type") == "id") {
        if (mysql_result($result, $i, "table") == "keywords") {
            $xml->element("type", "keywords");
            $xml->element("field", mysql_result($result, $i, "field"));
            $id = mysql_result($result, $i, "value");
            $xml->element("word", mysql_result(mysql_query("SELECT * FROM keywords WHERE id = {$id}", $link), 0, "word"));