| 34 |
$uuid = $req['uuid']; |
$uuid = $req['uuid']; |
| 35 |
|
|
| 36 |
|
|
| 37 |
$result = mysql_query("select * from userclassifieds where ". |
$result = mysql_query("select * from ossearch.classifieds where ". |
| 38 |
"userUUID = '". mysql_escape_string($uuid) ."'"); |
"creatoruuid = '". mysql_escape_string($uuid) ."'"); |
| 39 |
|
|
| 40 |
$data = array(); |
$data = array(); |
| 41 |
|
|
| 42 |
while (($row = mysql_fetch_assoc($result))) |
while (($row = mysql_fetch_assoc($result))) |
| 43 |
{ |
{ |
| 44 |
$data[] = array( |
$data[] = array( |
| 45 |
"classifiedid" => $row["ClassifiedID"], |
"classifiedid" => $row["classifieduuid"], |
| 46 |
"name" => $row["Name"]); |
"name" => $row["name"]); |
| 47 |
} |
} |
| 48 |
|
|
| 49 |
$response_xml = xmlrpc_encode(array( |
$response_xml = xmlrpc_encode(array( |
| 65 |
$uuid = $req['uuid']; |
$uuid = $req['uuid']; |
| 66 |
|
|
| 67 |
$result = mysql_query("select * from userpicks where ". |
$result = mysql_query("select * from userpicks where ". |
| 68 |
"userUUID = '". mysql_escape_string($uuid) ."'"); |
"creatoruuid = '". mysql_escape_string($uuid) ."'"); |
| 69 |
|
|
| 70 |
while (($row = mysql_fetch_assoc($result))) |
while (($row = mysql_fetch_assoc($result))) |
| 71 |
{ |
{ |
| 72 |
$data[] = array( |
$data[] = array( |
| 73 |
"pickID" => $row["PickID"], |
"pickid" => $row["pickuuid"], |
| 74 |
"name" => $row["Name"]); |
"name" => $row["name"]); |
| 75 |
} |
} |
| 76 |
|
|
| 77 |
$response_xml = xmlrpc_encode(array( |
$response_xml = xmlrpc_encode(array( |
| 94 |
$targetuuid = $req['avatar_id']; |
$targetuuid = $req['avatar_id']; |
| 95 |
|
|
| 96 |
$result = mysql_query("select * from usernotes where ". |
$result = mysql_query("select * from usernotes where ". |
| 97 |
"userUUID = '". mysql_escape_string($uuid) ."' AND ". |
"useruuid = '". mysql_escape_string($uuid) ."' AND ". |
| 98 |
"TargetID = '". mysql_escape_string($targetuuid) ."'"); |
"targetuuid = '". mysql_escape_string($targetuuid) ."'"); |
| 99 |
|
|
| 100 |
while (($row = mysql_fetch_assoc($result))) |
while (($row = mysql_fetch_assoc($result))) |
| 101 |
{ |
{ |
| 102 |
$data[] = array( |
$data[] = array( |
| 103 |
"targetID" => $row["TargetID"], |
"targetid" => $row["targetuuid"], |
| 104 |
"notes" => $row["Notes"]); |
"notes" => $row["notes"]); |
|
} |
|
|
|
|
|
$response_xml = xmlrpc_encode(array( |
|
|
'success' => True, |
|
|
'errorMessage' => "", |
|
|
'data' => $data |
|
|
)); |
|
|
|
|
|
print $response_xml; |
|
|
} |
|
|
|
|
|
xmlrpc_server_register_method($xmlrpc_server, "classifiedclickthrough", |
|
|
"classifiedclickthrough"); |
|
|
|
|
|
function classifiedclickthrough($method_name, $params, $app_data) |
|
|
{ |
|
|
$req = $params[0]; |
|
|
|
|
|
$uuid = $req['uuid']; |
|
|
$targetuuid = $req['avatar_id']; |
|
|
|
|
|
$result = mysql_query("select * from usernotes where ". |
|
|
"userUUID = '". mysql_escape_string($uuid) ."' AND ". |
|
|
"TargetID = '". mysql_escape_string($targetuuid) ."'"); |
|
|
|
|
|
while (($row = mysql_fetch_assoc($result))) |
|
|
{ |
|
|
$data[] = array( |
|
|
"targetID" => $row["TargetID"], |
|
|
"notes" => $row["Notes"]); |
|
| 105 |
} |
} |
| 106 |
|
|
| 107 |
$response_xml = xmlrpc_encode(array( |
$response_xml = xmlrpc_encode(array( |
| 124 |
$pick = $req['pick_id']; |
$pick = $req['pick_id']; |
| 125 |
|
|
| 126 |
$result = mysql_query("select * from userpicks where ". |
$result = mysql_query("select * from userpicks where ". |
| 127 |
"CreatorID = '". mysql_escape_string($uuid) ."' AND ". |
"creatoruuid = '". mysql_escape_string($uuid) ."' AND ". |
| 128 |
"PickID = '". mysql_escape_string($pick) ."'"); |
"pickuuid = '". mysql_escape_string($pick) ."'"); |
| 129 |
|
|
| 130 |
while (($row = mysql_fetch_assoc($result))) |
while (($row = mysql_fetch_assoc($result))) |
| 131 |
{ |
{ |
| 132 |
$data[] = array( |
$data[] = array( |
| 133 |
"pickuuid" => $row["PickID"], |
"pickuuid" => $row["pickuuid"], |
| 134 |
"creatoruuid" => $row["CreatorID"], |
"creatoruuid" => $row["creatoruuid"], |
| 135 |
"toppick" => $row["TopPick"], |
"toppick" => $row["toppick"], |
| 136 |
"parceluuid" => $row["ParcelID"], |
"parceluuid" => $row["parceluuid"], |
| 137 |
"name" => $row["Name"], |
"name" => $row["name"], |
| 138 |
"description" => $row["Desc"], |
"description" => $row["desc"], |
| 139 |
"snapshotuuid" => $row["SnapshotID"], |
"snapshotuuid" => $row["snapshotuuid"], |
| 140 |
"user" => $row["User"], |
"user" => $row["user"], |
| 141 |
"originalname" => $row["OriginalName"], |
"originalname" => $row["originalname"], |
| 142 |
"posglobal" => $row["PosGlobal"], |
"posglobal" => $row["posglobal"], |
| 143 |
"sortorder"=> $row["SortOrder"], |
"sortorder"=> $row["sortorder"], |
| 144 |
"enabled" => $row["Enabled"]); |
"enabled" => $row["enabled"]); |
| 145 |
} |
} |
| 146 |
|
|
| 147 |
$response_xml = xmlrpc_encode(array( |
$response_xml = xmlrpc_encode(array( |