Annotation of /branches/opensim_069/webroot/profile.php
Parent Directory
| 
Revision Log
Revision 57 - (view) (download)
| 1 : | melanie | 36 | <?PHP |
| 2 : | |||
| 3 : | include("databaseinfo.php"); | ||
| 4 : | |||
| 5 : | // | ||
| 6 : | // Search DB | ||
| 7 : | // | ||
| 8 : | mysql_connect ($DB_HOST, $DB_USER, $DB_PASSWORD); | ||
| 9 : | mysql_select_db ($DB_NAME); | ||
| 10 : | |||
| 11 : | # | ||
| 12 : | # Copyright (c)Melanie Thielker (http://opensimulator.org/) | ||
| 13 : | # | ||
| 14 : | |||
| 15 : | ###################### No user serviceable parts below ##################### | ||
| 16 : | |||
| 17 : | # | ||
| 18 : | # The XMLRPC server object | ||
| 19 : | # | ||
| 20 : | |||
| 21 : | $xmlrpc_server = xmlrpc_server_create(); | ||
| 22 : | |||
| 23 : | # | ||
| 24 : | # Classifieds | ||
| 25 : | # | ||
| 26 : | |||
| 27 : | # Avatar Classifieds Request | ||
| 28 : | |||
| 29 : | xmlrpc_server_register_method($xmlrpc_server, "avatarclassifiedsrequest", | ||
| 30 : | "avatarclassifiedsrequest"); | ||
| 31 : | |||
| 32 : | function avatarclassifiedsrequest($method_name, $params, $app_data) | ||
| 33 : | { | ||
| 34 : | $req = $params[0]; | ||
| 35 : | |||
| 36 : | $uuid = $req['uuid']; | ||
| 37 : | |||
| 38 : | |||
| 39 : | $result = mysql_query("select * from classifieds where ". | ||
| 40 : | "creatoruuid = '". mysql_escape_string($uuid) ."'"); | ||
| 41 : | |||
| 42 : | $data = array(); | ||
| 43 : | |||
| 44 : | while (($row = mysql_fetch_assoc($result))) | ||
| 45 : | { | ||
| 46 : | $data[] = array( | ||
| 47 : | "classifiedid" => $row["classifieduuid"], | ||
| 48 : | "name" => $row["name"]); | ||
| 49 : | } | ||
| 50 : | |||
| 51 : | $response_xml = xmlrpc_encode(array( | ||
| 52 : | 'success' => True, | ||
| 53 : | 'errorMessage' => "", | ||
| 54 : | 'data' => $data | ||
| 55 : | )); | ||
| 56 : | |||
| 57 : | print $response_xml; | ||
| 58 : | } | ||
| 59 : | |||
| 60 : | # Classifieds Update | ||
| 61 : | |||
| 62 : | fly-man- | 38 | xmlrpc_server_register_method($xmlrpc_server, "classified_update", |
| 63 : | "classified_update"); | ||
| 64 : | melanie | 36 | |
| 65 : | fly-man- | 38 | function classified_update($method_name, $params, $app_data) |
| 66 : | { | ||
| 67 : | $req = $params[0]; | ||
| 68 : | |||
| 69 : | $classifieduuid = $req['classifiedUUID']; | ||
| 70 : | $creator = $req['creatorUUID']; | ||
| 71 : | $category = $req['category']; | ||
| 72 : | $name = $req['name']; | ||
| 73 : | $description = $req['description']; | ||
| 74 : | $parceluuid = $req['parcelUUID']; | ||
| 75 : | $parentestate = $req['parentestate']; | ||
| 76 : | $snapshotuuid = $req['snapshotUUID']; | ||
| 77 : | $simname = $req['sim_name']; | ||
| 78 : | $globalpos = $req['globalpos']; | ||
| 79 : | $parcelname = $req['parcelname']; | ||
| 80 : | $classifiedflag = $req['classifiedFlags']; | ||
| 81 : | $priceforlist = $req['classifiedPrice']; | ||
| 82 : | |||
| 83 : | // Check if we already have this one in the database | ||
| 84 : | $check = mysql_query("select count(*) from classifieds WHERE ". | ||
| 85 : | "classifieduuid = '". mysql_escape_string($classifieduuid) ."'"); | ||
| 86 : | |||
| 87 : | while ($row = mysql_fetch_row($check)) | ||
| 88 : | { | ||
| 89 : | $ready = $row[0]; | ||
| 90 : | } | ||
| 91 : | |||
| 92 : | if ($ready == 0) | ||
| 93 : | { | ||
| 94 : | // Doing some late checking | ||
| 95 : | // Should be done by the module but let's see what happens when | ||
| 96 : | // I do it here | ||
| 97 : | |||
| 98 : | if($parcelname == "") | ||
| 99 : | { | ||
| 100 : | $parcelname = "Unknown"; | ||
| 101 : | } | ||
| 102 : | |||
| 103 : | if($parceluuid == "") | ||
| 104 : | { | ||
| 105 : | $parceluuid = "00000000-0000-0000-0000-0000000000000"; | ||
| 106 : | } | ||
| 107 : | |||
| 108 : | if($description == "") | ||
| 109 : | { | ||
| 110 : | $description = "No Description"; | ||
| 111 : | } | ||
| 112 : | |||
| 113 : | if($classifiedflag == 2) | ||
| 114 : | { | ||
| 115 : | $creationdate = time(); | ||
| 116 : | $expirationdate = time() + (7 * 24 * 60 * 60); | ||
| 117 : | } | ||
| 118 : | else | ||
| 119 : | { | ||
| 120 : | $creationdate = time(); | ||
| 121 : | $expirationdate = time() + (365 * 24 * 60 * 60); | ||
| 122 : | } | ||
| 123 : | |||
| 124 : | $insertquery = "insert into classifieds VALUES ". | ||
| 125 : | "('". mysql_escape_string($classifieduuid) ."',". | ||
| 126 : | "'". mysql_escape_string($creator) ."',". | ||
| 127 : | "". mysql_escape_string($creationdate) .",". | ||
| 128 : | "". mysql_escape_string($expirationdate) .",". | ||
| 129 : | "'". mysql_escape_string($category) ."',". | ||
| 130 : | "'". mysql_escape_string($name) ."',". | ||
| 131 : | "'". mysql_escape_string($description) ."',". | ||
| 132 : | "'". mysql_escape_string($parceluuid) ."',". | ||
| 133 : | "". mysql_escape_string($parentestate) .",". | ||
| 134 : | "'". mysql_escape_string($snapshotuuid) ."',". | ||
| 135 : | "'". mysql_escape_string($simname) ."',". | ||
| 136 : | "'". mysql_escape_string($globalpos) ."',". | ||
| 137 : | "'". mysql_escape_string($parcelname) ."',". | ||
| 138 : | "". mysql_escape_string($classifiedflag) .",". | ||
| 139 : | "". mysql_escape_string($priceforlist) .")"; | ||
| 140 : | |||
| 141 : | fly-man- | 49 | // Create a new record for this classified |
| 142 : | fly-man- | 38 | $result = mysql_query($insertquery); |
| 143 : | } | ||
| 144 : | else | ||
| 145 : | { | ||
| 146 : | |||
| 147 : | } | ||
| 148 : | |||
| 149 : | $response_xml = xmlrpc_encode(array( | ||
| 150 : | 'success' => True, | ||
| 151 : | 'errorMessage' => "", | ||
| 152 : | 'data' => $data | ||
| 153 : | )); | ||
| 154 : | |||
| 155 : | print $response_xml; | ||
| 156 : | } | ||
| 157 : | |||
| 158 : | melanie | 36 | # Classifieds Delete |
| 159 : | |||
| 160 : | xmlrpc_server_register_method($xmlrpc_server, "classified_delete", | ||
| 161 : | "classified_delete"); | ||
| 162 : | |||
| 163 : | function classified_delete($method_name, $params, $app_data) | ||
| 164 : | { | ||
| 165 : | $req = $params[0]; | ||
| 166 : | |||
| 167 : | $classifieduuid = $req['classifiedID']; | ||
| 168 : | |||
| 169 : | $result = mysql_query("delete from classifieds where ". | ||
| 170 : | "classifieduuid = '".mysql_escape_string($classifieduuid) ."'"); | ||
| 171 : | |||
| 172 : | $response_xml = xmlrpc_encode(array( | ||
| 173 : | 'success' => True, | ||
| 174 : | 'errorMessage' => "", | ||
| 175 : | 'data' => $data | ||
| 176 : | )); | ||
| 177 : | |||
| 178 : | print $response_xml; | ||
| 179 : | } | ||
| 180 : | |||
| 181 : | # | ||
| 182 : | # Picks | ||
| 183 : | # | ||
| 184 : | |||
| 185 : | # Avatar Picks Request | ||
| 186 : | |||
| 187 : | xmlrpc_server_register_method($xmlrpc_server, "avatarpicksrequest", | ||
| 188 : | "avatarpicksrequest"); | ||
| 189 : | |||
| 190 : | function avatarpicksrequest($method_name, $params, $app_data) | ||
| 191 : | { | ||
| 192 : | $req = $params[0]; | ||
| 193 : | |||
| 194 : | $uuid = $req['uuid']; | ||
| 195 : | |||
| 196 : | $result = mysql_query("select * from userpicks where ". | ||
| 197 : | "creatoruuid = '". mysql_escape_string($uuid) ."'"); | ||
| 198 : | |||
| 199 : | while (($row = mysql_fetch_assoc($result))) | ||
| 200 : | { | ||
| 201 : | $data[] = array( | ||
| 202 : | "pickid" => $row["pickuuid"], | ||
| 203 : | "name" => $row["name"]); | ||
| 204 : | } | ||
| 205 : | |||
| 206 : | $response_xml = xmlrpc_encode(array( | ||
| 207 : | 'success' => True, | ||
| 208 : | 'errorMessage' => "", | ||
| 209 : | 'data' => $data | ||
| 210 : | )); | ||
| 211 : | |||
| 212 : | print $response_xml; | ||
| 213 : | } | ||
| 214 : | |||
| 215 : | # Request Picks for User | ||
| 216 : | |||
| 217 : | xmlrpc_server_register_method($xmlrpc_server, "pickinforequest", | ||
| 218 : | "pickinforequest"); | ||
| 219 : | |||
| 220 : | function pickinforequest($method_name, $params, $app_data) | ||
| 221 : | { | ||
| 222 : | $req = $params[0]; | ||
| 223 : | |||
| 224 : | $uuid = $req['avatar_id']; | ||
| 225 : | $pick = $req['pick_id']; | ||
| 226 : | |||
| 227 : | $result = mysql_query("select * from userpicks where ". | ||
| 228 : | "creatoruuid = '". mysql_escape_string($uuid) ."' AND ". | ||
| 229 : | "pickuuid = '". mysql_escape_string($pick) ."'"); | ||
| 230 : | |||
| 231 : | fly-man- | 38 | while (($row = mysql_fetch_assoc($result))) |
| 232 : | melanie | 36 | { |
| 233 : | fly-man- | 38 | if ($row["description"] == "") |
| 234 : | { | ||
| 235 : | $row["description"] = "No description given"; | ||
| 236 : | } | ||
| 237 : | |||
| 238 : | melanie | 36 | $data[] = array( |
| 239 : | "pickuuid" => $row["pickuuid"], | ||
| 240 : | "creatoruuid" => $row["creatoruuid"], | ||
| 241 : | "toppick" => $row["toppick"], | ||
| 242 : | "parceluuid" => $row["parceluuid"], | ||
| 243 : | "name" => $row["name"], | ||
| 244 : | fly-man- | 38 | "description" => $row["description"], |
| 245 : | melanie | 36 | "snapshotuuid" => $row["snapshotuuid"], |
| 246 : | "user" => $row["user"], | ||
| 247 : | "originalname" => $row["originalname"], | ||
| 248 : | "simname" => $row["simname"], | ||
| 249 : | "posglobal" => $row["posglobal"], | ||
| 250 : | "sortorder"=> $row["sortorder"], | ||
| 251 : | "enabled" => $row["enabled"]); | ||
| 252 : | } | ||
| 253 : | |||
| 254 : | fly-man- | 38 | $response_xml = xmlrpc_encode(array( |
| 255 : | 'success' => True, | ||
| 256 : | 'errorMessage' => "", | ||
| 257 : | 'data' => $data | ||
| 258 : | )); | ||
| 259 : | melanie | 36 | |
| 260 : | print $response_xml; | ||
| 261 : | } | ||
| 262 : | |||
| 263 : | # Picks Update | ||
| 264 : | |||
| 265 : | xmlrpc_server_register_method($xmlrpc_server, "picks_update", | ||
| 266 : | "picks_update"); | ||
| 267 : | |||
| 268 : | function picks_update($method_name, $params, $app_data) | ||
| 269 : | { | ||
| 270 : | $req = $params[0]; | ||
| 271 : | |||
| 272 : | $pickuuid = $req['pick_id']; | ||
| 273 : | $creator = $req['creator_id']; | ||
| 274 : | $toppick = $req['top_pick']; | ||
| 275 : | $name = $req['name']; | ||
| 276 : | $description = $req['desc']; | ||
| 277 : | $parceluuid = $req['parcel_uuid']; | ||
| 278 : | $snapshotuuid = $req['snapshot_id']; | ||
| 279 : | fly-man- | 38 | $user = $req['user']; |
| 280 : | $original = $req['original']; | ||
| 281 : | melanie | 36 | $simname = $req['sim_name']; |
| 282 : | $posglobal = $req['pos_global']; | ||
| 283 : | $sortorder = $req['sort_order']; | ||
| 284 : | $enabled = $req['enabled']; | ||
| 285 : | |||
| 286 : | // Check if we already have this one in the database | ||
| 287 : | $check = mysql_query("select count(*) from userpicks WHERE ". | ||
| 288 : | "pickuuid = '". mysql_escape_string($pickuuid) ."'"); | ||
| 289 : | |||
| 290 : | while ($row = mysql_fetch_row($check)) | ||
| 291 : | { | ||
| 292 : | $ready = $row[0]; | ||
| 293 : | } | ||
| 294 : | |||
| 295 : | if ($ready == 0) | ||
| 296 : | { | ||
| 297 : | // Doing some late checking | ||
| 298 : | // Should be done by the module but let's see what happens when | ||
| 299 : | // I do it here | ||
| 300 : | |||
| 301 : | if($parceluuid == "") | ||
| 302 : | { | ||
| 303 : | $parceluuid = "00000000-0000-0000-0000-0000000000000"; | ||
| 304 : | } | ||
| 305 : | |||
| 306 : | if($description == "") | ||
| 307 : | { | ||
| 308 : | fly-man- | 38 | $description = "No Description"; |
| 309 : | melanie | 36 | } |
| 310 : | |||
| 311 : | if($user == "") | ||
| 312 : | { | ||
| 313 : | $user = "Unknown"; | ||
| 314 : | } | ||
| 315 : | |||
| 316 : | if($original == "") | ||
| 317 : | { | ||
| 318 : | $original = "Unknown"; | ||
| 319 : | } | ||
| 320 : | |||
| 321 : | $insertquery = "insert into userpicks VALUES ". | ||
| 322 : | "('". mysql_escape_string($pickuuid) ."',". | ||
| 323 : | "'". mysql_escape_string($creator) ."',". | ||
| 324 : | "'". mysql_escape_string($toppick) ."',". | ||
| 325 : | "'". mysql_escape_string($parceluuid) ."',". | ||
| 326 : | "'". mysql_escape_string($name) ."',". | ||
| 327 : | "'". mysql_escape_string($description) ."',". | ||
| 328 : | "'". mysql_escape_string($snapshotuuid) ."',". | ||
| 329 : | "'". mysql_escape_string($user) ."',". | ||
| 330 : | "'". mysql_escape_string($original) ."',". | ||
| 331 : | "'". mysql_escape_string($simname) ."',". | ||
| 332 : | "'". mysql_escape_string($posglobal) ."',". | ||
| 333 : | "'". mysql_escape_string($sortorder) ."',". | ||
| 334 : | "'". mysql_escape_string($enabled) ."')"; | ||
| 335 : | |||
| 336 : | fly-man- | 38 | //print $insertquery; |
| 337 : | |||
| 338 : | melanie | 36 | // Create a new record for this avatar note |
| 339 : | $result = mysql_query($insertquery); | ||
| 340 : | } | ||
| 341 : | else | ||
| 342 : | { | ||
| 343 : | // Doing some late checking | ||
| 344 : | // Should be done by the module but let's see what happens when | ||
| 345 : | // I do it here | ||
| 346 : | |||
| 347 : | if($parceluuid == "") | ||
| 348 : | { | ||
| 349 : | fly-man- | 38 | $parceluuid = "00000000-0000-0000-0000-00000000000"; |
| 350 : | melanie | 36 | } |
| 351 : | |||
| 352 : | fly-man- | 38 | if($description == "") |
| 353 : | { | ||
| 354 : | $description = "Test"; | ||
| 355 : | } | ||
| 356 : | |||
| 357 : | melanie | 36 | if($user == "") |
| 358 : | { | ||
| 359 : | $user = "Unknown"; | ||
| 360 : | } | ||
| 361 : | |||
| 362 : | if($original == "") | ||
| 363 : | { | ||
| 364 : | $original = "Unknown"; | ||
| 365 : | } | ||
| 366 : | |||
| 367 : | fly-man- | 38 | $updatequery1 = "update userpicks SET ". |
| 368 : | "parceluuid = '". mysql_escape_string($parceluuid) ."' WHERE ". | ||
| 369 : | melanie | 36 | "pickuuid = '". mysql_escape_string($pickuuid) ."'"; |
| 370 : | |||
| 371 : | fly-man- | 38 | $updatequery2 = "update userpicks SET ". |
| 372 : | "name = '". mysql_escape_string($name) ."' WHERE ". | ||
| 373 : | "pickuuid = '". mysql_escape_string($pickuuid) ."'"; | ||
| 374 : | |||
| 375 : | $updatequery3 = "update userpicks SET ". | ||
| 376 : | "description = '". mysql_escape_string($description) ."' WHERE ". | ||
| 377 : | "pickuuid = '". mysql_escape_string($pickuuid) ."'"; | ||
| 378 : | |||
| 379 : | $updatequery4 = "update userpicks SET ". | ||
| 380 : | "snapshotuuid = '". mysql_escape_string($snapshotuuid) ."' WHERE ". | ||
| 381 : | "pickuuid = '". mysql_escape_string($pickuuid) ."'"; | ||
| 382 : | |||
| 383 : | melanie | 36 | // Update the existing record |
| 384 : | fly-man- | 38 | $resultQ1 = mysql_query($updatequery1); |
| 385 : | $resultQ2 = mysql_query($updatequery2); | ||
| 386 : | $resultQ3 = mysql_query($updatequery3); | ||
| 387 : | $resultQ4 = mysql_query($updatequery4); | ||
| 388 : | melanie | 36 | } |
| 389 : | |||
| 390 : | $response_xml = xmlrpc_encode(array( | ||
| 391 : | 'success' => True, | ||
| 392 : | fly-man- | 38 | 'errorMessage' => "", |
| 393 : | 'data' => $data | ||
| 394 : | melanie | 36 | )); |
| 395 : | |||
| 396 : | print $response_xml; | ||
| 397 : | } | ||
| 398 : | |||
| 399 : | # Picks Delete | ||
| 400 : | |||
| 401 : | xmlrpc_server_register_method($xmlrpc_server, "picks_delete", | ||
| 402 : | "picks_delete"); | ||
| 403 : | |||
| 404 : | function picks_delete($method_name, $params, $app_data) | ||
| 405 : | { | ||
| 406 : | $req = $params[0]; | ||
| 407 : | |||
| 408 : | $pickuuid = $req['pick_id']; | ||
| 409 : | |||
| 410 : | $result = mysql_query("delete from userpicks where ". | ||
| 411 : | "pickuuid = '".mysql_escape_string($pickuuid) ."'"); | ||
| 412 : | |||
| 413 : | $response_xml = xmlrpc_encode(array( | ||
| 414 : | 'success' => True, | ||
| 415 : | fly-man- | 38 | 'errorMessage' => "", |
| 416 : | 'data' => $data | ||
| 417 : | melanie | 36 | )); |
| 418 : | |||
| 419 : | print $response_xml; | ||
| 420 : | } | ||
| 421 : | |||
| 422 : | # | ||
| 423 : | # Notes | ||
| 424 : | # | ||
| 425 : | |||
| 426 : | # Avatar Notes Request | ||
| 427 : | |||
| 428 : | |||
| 429 : | xmlrpc_server_register_method($xmlrpc_server, "avatarnotesrequest", | ||
| 430 : | "avatarnotesrequest"); | ||
| 431 : | |||
| 432 : | function avatarnotesrequest($method_name, $params, $app_data) | ||
| 433 : | { | ||
| 434 : | $req = $params[0]; | ||
| 435 : | |||
| 436 : | $uuid = $req['uuid']; | ||
| 437 : | $targetuuid = $req['avatar_id']; | ||
| 438 : | |||
| 439 : | $result = mysql_query("select * from usernotes where ". | ||
| 440 : | "useruuid = '". mysql_escape_string($uuid) ."' AND ". | ||
| 441 : | "targetuuid = '". mysql_escape_string($targetuuid) ."'"); | ||
| 442 : | |||
| 443 : | fly-man- | 38 | while (($row = mysql_fetch_assoc($result))) |
| 444 : | melanie | 36 | { |
| 445 : | $data[] = array( | ||
| 446 : | "targetid" => $row["targetuuid"], | ||
| 447 : | "notes" => $row["notes"]); | ||
| 448 : | } | ||
| 449 : | |||
| 450 : | $response_xml = xmlrpc_encode(array( | ||
| 451 : | 'success' => True, | ||
| 452 : | 'errorMessage' => "", | ||
| 453 : | 'data' => $data | ||
| 454 : | )); | ||
| 455 : | |||
| 456 : | print $response_xml; | ||
| 457 : | } | ||
| 458 : | |||
| 459 : | # Avatar Notes Update | ||
| 460 : | |||
| 461 : | xmlrpc_server_register_method($xmlrpc_server, "avatar_notes_update", | ||
| 462 : | "avatar_notes_update"); | ||
| 463 : | |||
| 464 : | function avatar_notes_update($method_name, $params, $app_data) | ||
| 465 : | { | ||
| 466 : | $req = $params[0]; | ||
| 467 : | |||
| 468 : | $uuid = $req['avatar_id']; | ||
| 469 : | $targetuuid = $req['target_id']; | ||
| 470 : | $notes = $req['notes']; | ||
| 471 : | |||
| 472 : | // Check if we already have this one in the database | ||
| 473 : | |||
| 474 : | $check = mysql_query("select count(*) from usernotes WHERE ". | ||
| 475 : | "useruuid = '". mysql_escape_string($uuid) ."' AND ". | ||
| 476 : | "targetuuid = '". mysql_escape_string($targetuuid) ."'"); | ||
| 477 : | |||
| 478 : | while ($row = mysql_fetch_row($check)) | ||
| 479 : | { | ||
| 480 : | $ready = $row[0]; | ||
| 481 : | } | ||
| 482 : | |||
| 483 : | if ($ready == 0) | ||
| 484 : | { | ||
| 485 : | // Create a new record for this avatar note | ||
| 486 : | $result = mysql_query("insert into usernotes VALUES ". | ||
| 487 : | "('". mysql_escape_string($uuid) ."',". | ||
| 488 : | "'". mysql_escape_string($targetuuid) ."',". | ||
| 489 : | "'". mysql_escape_string($notes) ."')"); | ||
| 490 : | } | ||
| 491 : | else if ($notes == "") | ||
| 492 : | { | ||
| 493 : | // Delete the record for this avatar note | ||
| 494 : | $result = mysql_query("delete from usernotes WHERE ". | ||
| 495 : | "useruuid = '". mysql_escape_string($uuid) ."' AND ". | ||
| 496 : | "targetuuid = '". mysql_escape_string($targetuuid) ."'"); | ||
| 497 : | } | ||
| 498 : | else | ||
| 499 : | { | ||
| 500 : | // Update the existing record | ||
| 501 : | $result = mysql_query("update usernotes SET ". | ||
| 502 : | "notes = '". mysql_escape_string($notes) ."' WHERE ". | ||
| 503 : | "useruuid = '". mysql_escape_string($uuid) ."' AND ". | ||
| 504 : | "targetuuid = '". mysql_escape_string($targetuuid) ."'"); | ||
| 505 : | } | ||
| 506 : | |||
| 507 : | $response_xml = xmlrpc_encode(array( | ||
| 508 : | 'success' => True, | ||
| 509 : | fly-man- | 38 | 'errorMessage' => "", |
| 510 : | 'data' => $data | ||
| 511 : | melanie | 36 | )); |
| 512 : | |||
| 513 : | print $response_xml; | ||
| 514 : | } | ||
| 515 : | |||
| 516 : | fly-man- | 42 | # Profile bits |
| 517 : | |||
| 518 : | fly-man- | 45 | xmlrpc_server_register_method($xmlrpc_server, "avatar_properties_request", |
| 519 : | "avatar_properties_request"); | ||
| 520 : | fly-man- | 42 | |
| 521 : | fly-man- | 45 | function avatar_properties_request($method_name, $params, $app_data) |
| 522 : | fly-man- | 42 | { |
| 523 : | $req = $params[0]; | ||
| 524 : | |||
| 525 : | $uuid = $req['avatar_id']; | ||
| 526 : | |||
| 527 : | fly-man- | 49 | $result = mysql_query("select profileURL from opensim.users where ". |
| 528 : | "UUID = '". mysql_escape_string($uuid) ."'"); | ||
| 529 : | fly-man- | 42 | |
| 530 : | while (($row = mysql_fetch_assoc($result))) | ||
| 531 : | { | ||
| 532 : | $data[] = array( | ||
| 533 : | "ProfileUrl" => $row["profileURL"]); | ||
| 534 : | } | ||
| 535 : | |||
| 536 : | $response_xml = xmlrpc_encode(array( | ||
| 537 : | 'data' => $data | ||
| 538 : | )); | ||
| 539 : | |||
| 540 : | print $response_xml; | ||
| 541 : | } | ||
| 542 : | |||
| 543 : | |||
| 544 : | fly-man- | 45 | // Profile Interests |
| 545 : | fly-man- | 42 | |
| 546 : | fly-man- | 45 | xmlrpc_server_register_method($xmlrpc_server, "avatar_interests_request", |
| 547 : | "avatar_interests_request"); | ||
| 548 : | |||
| 549 : | function avatar_interests_request($method_name, $params, $app_data) | ||
| 550 : | { | ||
| 551 : | $req = $params[0]; | ||
| 552 : | |||
| 553 : | $uuid = $req['avatar_id']; | ||
| 554 : | |||
| 555 : | while (($row = mysql_fetch_assoc($result))) | ||
| 556 : | { | ||
| 557 : | $data[] = array( | ||
| 558 : | "ProfileUrl" => $row["profileURL"]); | ||
| 559 : | } | ||
| 560 : | |||
| 561 : | $response_xml = xmlrpc_encode(array( | ||
| 562 : | 'data' => $data | ||
| 563 : | )); | ||
| 564 : | |||
| 565 : | print $response_xml; | ||
| 566 : | } | ||
| 567 : | |||
| 568 : | xmlrpc_server_register_method($xmlrpc_server, "avatar_interests_update", | ||
| 569 : | "avatar_interests_update"); | ||
| 570 : | |||
| 571 : | function avatar_interests_update($method_name, $params, $app_data) | ||
| 572 : | { | ||
| 573 : | $req = $params[0]; | ||
| 574 : | |||
| 575 : | $uuid = $req['avatar_id']; | ||
| 576 : | fly-man- | 49 | $skillstext = $req['skillstext']; |
| 577 : | $skillsmask = $req['skillsmask']; | ||
| 578 : | $languages = $req['languages']; | ||
| 579 : | $wanttext = $req['wanttext']; | ||
| 580 : | $wantmask = $req['wantmask']; | ||
| 581 : | fly-man- | 45 | |
| 582 : | fly-man- | 49 | $result = mysql_query("update userprofile set ". |
| 583 : | "profileCanDoMask = ". mysql_escape_string($skillsmask) .",". | ||
| 584 : | "profileCanDoText = '". mysql_escape_string($skillstext) ."',". | ||
| 585 : | "profileWantDoMask = ". mysql_escape_string($wantmask) .",". | ||
| 586 : | "profileWantDoText = '". mysql_escape_string($wanttext) ."',". | ||
| 587 : | "profileLanguagesText = '". mysql_escape_string($languages) ."' ". | ||
| 588 : | "where useruuid = '". mysql_escape_string($uuid) ."'" | ||
| 589 : | ); | ||
| 590 : | |||
| 591 : | fly-man- | 45 | $response_xml = xmlrpc_encode(array( |
| 592 : | 'success' => True, | ||
| 593 : | 'errorMessage' => "", | ||
| 594 : | 'data' => $data | ||
| 595 : | )); | ||
| 596 : | |||
| 597 : | print $response_xml; | ||
| 598 : | } | ||
| 599 : | |||
| 600 : | fly-man- | 49 | // User Preferences |
| 601 : | |||
| 602 : | xmlrpc_server_register_method($xmlrpc_server, "user_preferences_request", | ||
| 603 : | "user_preferences_request"); | ||
| 604 : | |||
| 605 : | function user_preferences_request($method_name, $params, $app_data) | ||
| 606 : | { | ||
| 607 : | $req = $params[0]; | ||
| 608 : | |||
| 609 : | $uuid = $req['avatar_id']; | ||
| 610 : | |||
| 611 : | $result = mysql_query("select imviaemail,visible,email from usersettings where ". | ||
| 612 : | "useruuid = '". mysql_escape_string($uuid) ."'"); | ||
| 613 : | |||
| 614 : | while (($row = mysql_fetch_assoc($result))) | ||
| 615 : | { | ||
| 616 : | $data[] = array( | ||
| 617 : | "imviaemail" => $row["imviaemail"], | ||
| 618 : | "visible" => $row["visible"], | ||
| 619 : | "email" => $row["email"]); | ||
| 620 : | } | ||
| 621 : | |||
| 622 : | $response_xml = xmlrpc_encode(array( | ||
| 623 : | 'success' => True, | ||
| 624 : | 'errorMessage' => "", | ||
| 625 : | 'data' => $data | ||
| 626 : | )); | ||
| 627 : | |||
| 628 : | print $response_xml; | ||
| 629 : | } | ||
| 630 : | |||
| 631 : | xmlrpc_server_register_method($xmlrpc_server, "user_preferences_update", | ||
| 632 : | "user_preferences_update"); | ||
| 633 : | |||
| 634 : | function user_preferences_update($method_name, $params, $app_data) | ||
| 635 : | { | ||
| 636 : | |||
| 637 : | $req = $params[0]; | ||
| 638 : | |||
| 639 : | $uuid = $req['avatar_id']; | ||
| 640 : | $wantim = $req['imViaEmail']; | ||
| 641 : | $directory = $req['visible']; | ||
| 642 : | |||
| 643 : | $result = mysql_query("update usersettings set ". | ||
| 644 : | "imviaemail = '".mysql_escape_string($wantim) ."', ". | ||
| 645 : | "visible = '".mysql_escape_string($directory) ."' where ". | ||
| 646 : | "useruuid = '". mysql_escape_string($uuid) ."'"); | ||
| 647 : | |||
| 648 : | $response_xml = xmlrpc_encode(array( | ||
| 649 : | 'success' => True, | ||
| 650 : | 'errorMessage' => "", | ||
| 651 : | 'data' => $data | ||
| 652 : | )); | ||
| 653 : | |||
| 654 : | print $response_xml; | ||
| 655 : | } | ||
| 656 : | |||
| 657 : | melanie | 36 | # |
| 658 : | # Process the request | ||
| 659 : | # | ||
| 660 : | |||
| 661 : | $request_xml = $HTTP_RAW_POST_DATA; | ||
| 662 : | xmlrpc_server_call_method($xmlrpc_server, $request_xml, ''); | ||
| 663 : | xmlrpc_server_destroy($xmlrpc_server); | ||
| 664 : | ?> |
| ViewVC Help | |
| Powered by ViewVC 1.0.0 |
