1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
<?php
/* InstaDisc Server - A Four Island Project */
include_once('db.php');
function instaDisc_checkVerification($username, $verification, $verificationID, $table, $nameField, $passField)
{
$getitem = "SELECT * FROM " . $table . " WHERE " . $nameField . " = \"" . mysql_escape_string($username) . "\"";
$getitem2 = mysql_query($getitem);
$getitem3 = mysql_fetch_array($getitem2);
if ($getitem3[$nameField] == $username)
{
$test = $username . ':' . $getitem3[$passField] . ':' . $verificationID;
return (md5($test) == $verification);
}
return false;
}
function instaDisc_sendItem($username, $id)
{
}
function instaDisc_sendUpdateNotice($softwareVersion)
{
$username = getConfig('owner');
$subscription = 'http://' . $_SERVER['HTTP_HOST'];
$title = 'Update your software to ' . $software;
$author = 'Hatkirby';
$url = 'http://fourisland.com/projects/instadisc/wiki/CentralSoftwareUpdate';
$semantics = array();
instaDisc_addItem($username, $subscription, $title, $author, $url, $semantics);
}
function instaDisc_sendDatabase($cserver)
{
}
function instaDisc_addItem($username, $subscription, $title, $author, $url, $semantics)
{
$getuser = "SELECT * FROM users WHERE username = \"" . mysql_escape_string($username) . "\"";
$getuser2 = mysql_query($getuser);
$getuser3 = mysql_fetch_array($getuser2);
if ($getuser3['username'] == $username)
{
$itemID = $getuser3['nextItemID'];
$setuser = "UPDATE users SET nextItemID = nextItemID+1 WHERE username = \"" . mysql_escape_string($username) . "\"";
$setuser2 = mysql_query($setuser);
$insitem = "INSERT INTO inbox (username, itemID, subscription, title, author, url, semantics) VALUES (\"" . mysql_escape_string($username) . "\", " . $itemID . ", \"" . mysql_escape_string($subscription) . "\", \"" . mysql_escape_string($title) . "\", \"" . mysql_escape_string($author) . "\", \"" . mysql_escape_string($url) . "\", \"" . mysql_escape_string(serialize($semantics)) . "\")";
$insitem2 = mysql_query($insitem);
instaDisc_sendItem($username, $itemID);
}
}
?>
|
