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: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 239: 240: 241: 242: 243: 244: 245: 246: 247: 248: 249: 250: 251: 252: 253: 254: 255: 256: 257: 258: 259: 260: 261: 262: 263: 264: 265: 266: 267: 268: 269: 270: 271: 272: 273: 274: 275: 276: 277: 278: 279: 280: 281: 282: 283: 284: 285: 286: 287: 288: 289: 290: 291: 292: 293: 294: 295: 296: 297: 298: 299: 300: 301: 302: 303: 304: 305: 306: 307: 308: 309: 310: 311: 312: 313: 314: 315: 316: 317: 318: 319: 320: 321: 322: 323: 324: 325: 326: 327: 328: 329: 330: 331: 332: 333: 334: 335: 336: 337: 338: 339: 340: 341: 342: 343: 344: 345: 346: 347: 348: 349: 350: 351: 352: 353: 354: 355: 356: 357: 358: 359: 360: 361: 362: 363: 364: 365: 366: 367: 368: 369: 370: 371: 372: 373: 374: 375: 376: 377: 378: 379: 380: 381: 382: 383: 384: 385: 386: 387: 388: 389: 390: 391: 392: 393: 394: 395: 396: 397: 398: 399: 400: 401: 402: 403: 404: 405: 406: 407: 408: 409: 410: 411: 412: 413: 414: 415: 416: 417: 418: 419: 420: 421: 422: 423: 424: 425: 426: 427: 428: 429: 430: 431: 432: 433: 434: 435: 436: 437: 438: 439: 440: 441: 442: 443: 444: 445: 446: 447: 448: 449: 450: 451: 452: 453: 454: 455: 456: 457: 458: 459: 460: 461: 462: 463: 464: 465: 466: 467: 468: 469: 470: 471: 472: 473: 474: 475: 476: 477: 478: 479: 480: 481: 482: 483: 484: 485: 486: 487: 488: 489: 490: 491: 492: 493: 494: 495: 496: 497: 498: 499: 500: 501: 502: 503: 504: 505: 506: 507: 508: 509: 510: 511: 512: 513: 514: 515: 516: 517: 518: 519: 520: 521: 522: 523: 524: 525: 526: 527: 528: 529: 530: 531: 532: 533: 534: 535: 536: 537: 538: 539: 540: 541: 542: 543: 544: 545: 546: 547: 548: 549: 550: 551: 552: 553: 554: 555: 556: 557: 558: 559: 560: 561: 562: 563: 564: 565: 566: 567: 568: 569: 570: 571: 572: 573: 574: 575: 576: 577: 578: 579: 580: 581: 582: 583: 584: 585: 586: 587: 588: 589: 590: 591: 592: 593: 594: 595: 596: 597: 598: 599: 600: 601: 602: 603: 604: 605: 606: 607: 608: 609: 610: 611: 612: 613: 614: 615: 616: 617: 618: 619: 620: 621: 622: 623: 624: 625: 626: 627: 628: 629: 630: 631: 632: 633: 634: 635: 636: 637: 638: 639: 640: 641: 642: 643: 644: 645: 646: 647: 648: 649: 650: 651: 652: 653: 654: 655: 656: 657: 658: 659: 660: 661: 662: 663: 664: 665: 666: 667: 668: 669: 670: 671: 672: 673: 674: 675: 676: 677: 678: 679: 680: 681: 682: 683: 684: 685: 686: 687: 688: 689: 690: 691: 692: 693: 694: 695: 696: 697: 698: 699: 700: 701: 702: 703: 704: 705: 706: 707: 708: 709: 710: 711: 712: 713: 714: 715: 716: 717: 718: 719: 720: 721: 722: 723: 724: 725: 726: 727: 728: 729: 730: 731: 732: 733: 734: 735: 736: 737: 738: 739: 740: 741: 742: 743: 744: 745: 746: 747: 748: 749: 750: 751: 752: 753: 754: 755: 756: 757: 758: 759: 760: 761: 762: 763: 764: 765: 766: 767: 768: 769: 770: 771: 772: 773: 774: 775: 776: 777: 778: 779: 780: 781: 782: 783: 784: 785: 786: 787: 788: 789: 790: 791: 792: 793: 794: 795: 796: 797: 798: 799: 800: 801: 802: 803: 804: 805: 806: 807: 808: 809: 810: 811: 812: 813: 814: 815: 816: 817: 818: 819: 820: 821: 822: 823: 824: 825: 826: 827: 828: 829: 830: 831: 832: 833: 834: 835: 836: 837: 838: 839: 840: 841: 842: 843: 844: 845: 846: 847: 848: 849: 850: 851: 852: 853: 854: 855: 856: 857: 858: 859: 860: 861: 862: 863: 864: 865: 866: 867: 868: 869: 870: 871: 872: 873: 874: 875: 876: 877: 878: 879: 880: 881: 882: 883: 884: 885: 886: 887: 888: 889: 890: 891: 892: 893: 894: 895: 896: 897: 898: 899: 900: 901: 902: 903: 904: 905: 906: 907: 908: 909: 910: 911: 912: 913: 914: 915: 916: 917: 918: 919: 920: 921: 922: 923: 924: 925: 926: 927: 928: 929: 930: 931: 932: 933: 934: 935: 936: 937: 938: 939: 940: 941: 942: 943: 944: 945: 946: 947: 948: 949: 950: 951: 952: 953: 954: 955: 956: 957: 958: 959: 960: 961: 962: 963: 964: 965: 966: 967: 968: 969: 970: 971: 972: 973: 974: 975: 976: 977: 978: 979: 980: 981: 982: 983: 984: 985: 986: 987: 988: 989: 990: 991: 992: 993: 994: 995: 996: 997: 998: 999: 1000: 1001: 1002: 1003: 1004: 1005: 1006: 1007: 1008: 1009: 1010: 1011: 1012: 1013: 1014: 1015: 1016: 1017: 1018: 1019: 1020: 1021: 1022: 1023: 1024: 1025: 1026: 1027: 1028: 1029: 1030: 1031: 1032: 1033: 1034: 1035: 1036: 1037: 1038: 1039: 1040: 1041: 1042: 1043: 1044: 1045: 1046: 1047: 1048: 1049: 1050: 1051: 1052: 1053: 1054: 1055: 1056: 1057: 1058: 1059: 1060: 1061: 1062: 1063: 1064: 1065: 1066: 1067: 1068: 1069: 1070: 1071: 1072: 1073: 1074: 1075: 1076: 1077: 1078: 1079: 1080: 1081: 1082: 1083: 1084: 1085: 1086: 1087: 1088: 1089: 1090: 1091: 1092: 1093: 1094: 1095: 1096: 1097: 1098: 1099: 1100: 1101: 1102: 1103: 1104: 1105: 1106: 1107: 1108: 1109: 1110: 1111: 1112: 1113: 1114: 1115: 1116: 1117: 1118: 1119: 1120: 1121: 1122: 1123: 1124: 1125: 1126: 1127: 1128: 1129: 1130: 1131: 1132: 1133: 1134: 1135: 1136: 1137: 1138: 1139: 1140: 1141: 1142: 1143: 1144: 1145: 1146: 1147: 1148: 1149: 1150: 1151: 1152: 1153: 1154: 1155: 1156: 1157: 1158: 1159: 1160: 1161: 1162: 1163: 1164: 1165: 1166: 1167: 1168: 1169: 1170: 1171: 1172: 1173: 1174: 1175: 1176: 1177: 1178: 1179: 1180: 1181: 1182: 1183: 1184: 1185: 1186: 1187: 1188: 1189: 1190: 1191: 1192: 1193: 1194: 1195: 1196: 1197: 1198: 1199: 1200: 1201: 1202: 1203: 1204: 1205: 1206: 1207: 1208: 1209: 1210: 1211: 1212: 1213: 1214: 1215: 1216: 1217: 1218: 1219: 1220: 1221: 1222: 1223: 1224: 1225: 1226: 1227: 1228: 1229: 1230: 1231: 1232: 1233: 1234: 1235: 1236: 1237: 1238: 1239: 1240: 1241: 1242: 1243: 1244: 1245: 1246: 1247: 1248: 1249: 1250: 1251: 1252: 1253: 1254: 1255: 1256: 1257: 1258: 1259: 1260: 1261: 1262: 1263: 1264: 1265: 1266: 1267: 1268: 1269: 1270: 1271: 1272: 1273: 1274: 1275: 1276: 1277: 1278: 1279: 1280: 1281: 1282: 1283: 1284: 1285: 1286: 1287: 1288: 1289: 1290: 1291: 1292: 1293: 1294: 1295: 1296: 1297: 1298: 1299: 1300: 1301: 1302: 1303: 1304: 1305: 1306: 1307: 1308: 1309: 1310: 1311: 1312: 1313: 1314: 1315: 1316: 1317: 1318: 1319: 1320:
<?php
session_start();
include_once 'connect.php';
function checkLogin($username, $pass) {
global $dbPrefix, $pdo;
try {
$stmt = $pdo->prepare('SELECT * FROM ' . $dbPrefix . 'users WHERE username = ? AND password = ? AND is_blocked = 0');
$stmt->execute([$username, md5($pass)]);
$user = $stmt->fetch();
if ($user) {
return 200;
} else {
return false;
}
} catch (Exception $e) {
return false;
}
}
function checkLoginToken($token, $roomId, $isAdmin = false) {
global $dbPrefix, $pdo;
try {
if ($isAdmin) {
$stmt = $pdo->prepare('SELECT * FROM ' . $dbPrefix . 'agents WHERE token = ? AND roomId = ?');
$stmt->execute([$token, $roomId]);
} else {
$stmt = $pdo->prepare('SELECT * FROM ' . $dbPrefix . 'users WHERE token = ? AND roomId = ? AND is_blocked = 0');
$stmt->execute([$token, $roomId]);
}
$user = $stmt->fetch();
if ($user) {
return json_encode($user);
} else {
return false;
}
} catch (Exception $e) {
return false;
}
}
function insertScheduling($agent, $visitor, $agenturl, $visitorurl, $pass, $session, $datetime, $duration, $shortagenturl, $shortvisitorurl, $agentId = null, $agenturl_broadcast = null, $visitorurl_broadcast = null, $shortagenturl_broadcast = null, $shortvisitorurl_broadcast = null, $is_active = true) {
global $dbPrefix, $pdo;
$stmt = $pdo->prepare('SELECT * FROM ' . $dbPrefix . 'rooms WHERE roomId = ? or shortagenturl = ? or shortvisitorurl = ?');
$stmt->execute([$session, $shortagenturl, $shortvisitorurl]);
$userName = $stmt->fetch();
if ($userName) {
return false;
}
$is_active = ($is_active == 'true') ? 1 : 0;
try {
$sql = "INSERT INTO " . $dbPrefix . "rooms (agent, visitor, agenturl, visitorurl, password, roomId, datetime, duration, shortagenturl, shortvisitorurl, agent_id, agenturl_broadcast, visitorurl_broadcast, shortagenturl_broadcast, shortvisitorurl_broadcast, is_active) "
. "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$pdo->prepare($sql)->execute([$agent, $visitor, $agenturl, $visitorurl, md5($pass), $session, $datetime, $duration, $shortagenturl, $shortvisitorurl, $agentId, $agenturl_broadcast, $visitorurl_broadcast, $shortagenturl_broadcast, $shortvisitorurl_broadcast, (int) $is_active]);
return 200;
} catch (Exception $e) {
return 'Error';
}
}
function addRoom($lsRepUrl, $agentId = null, $roomId = null, $agentName = null, $visitorName = null, $agentShortUrl = null, $visitorShortUrl = null, $password = null, $config = 'config.json', $dateTime = null, $duration = null, $disableVideo = false, $disableAudio = false, $disableScreenShare = false, $disableWhiteboard = false, $disableTransfer = false, $is_active = true) {
global $dbPrefix, $pdo;
$stmt = $pdo->prepare('SELECT * FROM ' . $dbPrefix . 'rooms WHERE roomId = ? or shortagenturl = ? or shortvisitorurl = ?');
$stmt->execute([$roomId, $agentShortUrl, $visitorShortUrl]);
$userName = $stmt->fetch();
if ($userName) {
return false;
}
$is_active = ($is_active == 'true') ? 1 : 0;
try {
function generateRand($length) {
$characters = '0123456789abcdefghijklmnopqrstuvwxyz';
$charactersLength = strlen($characters);
$randomString = '';
for ($i = 0; $i < $length; $i++) {
$randomString .= $characters[rand(0, $charactersLength - 1)];
}
return $randomString;
}
$roomId = ($roomId) ? $roomId : generateRand(10);
$str = [];
$str['lsRepUrl'] = $lsRepUrl;
if ($agentName) {
$str['names'] = $agentName;
}
if ($visitorName) {
$str['visitorName'] = $visitorName;
}
if ($config) {
$str['config'] = $config;
}
if ($agentId) {
$str['agentId'] = $agentId;
}
if ($agentId) {
$str['agentId'] = $agentId;
}
if ($agentShortUrl) {
$agentShortUrl = $agentShortUrl;
$agentShortUrl_b = $agentShortUrl . '_b';
} else {
$agentShortUrl = generateRand(6);
$agentShortUrl_b = generateRand(6);
}
if ($visitorShortUrl) {
$visitorShortUrl = $visitorShortUrl;
$visitorShortUrl_b = $visitorShortUrl . '_b';
} else {
$visitorShortUrl = generateRand(6);
$visitorShortUrl_b = generateRand(6);
}
if ($dateTime) {
$str['agentId'] = $dateTime;
}
if ($duration) {
$str['duration'] = $duration;
}
if ($disableVideo) {
$str['disableVideo'] = $disableVideo;
}
if ($disableAudio) {
$str['disableAudio'] = $disableAudio;
}
if ($disableWhiteboard) {
$str['disableWhiteboard'] = $disableWhiteboard;
}
if ($disableScreenShare) {
$str['disableScreenShare'] = $disableScreenShare;
}
if ($disableTransfer) {
$str['disableTransfer'] = $disableTransfer;
}
$encodedString = base64_encode(json_encode($str));
$visitorUrl = $lsRepUrl . 'pages/r.html?room=' . $roomId . '&p=' . $encodedString;
$viewerBroadcastLink = $lsRepUrl . 'pages/r.html?room=' . $roomId . '&p=' . $encodedString . '&broadcast=1';
if ($password) {
$str['pass'] = $password;
}
if (isset($str['vistorName'])) {
unset($str['vistorName']);
}
$str['isAdmin'] = 1;
$encodedString = base64_encode(json_encode($str));
$agentUrl = $lsRepUrl . 'pages/r.html?room=' . $roomId . '&p=' . $encodedString . '&isAdmin=1';
$agentBroadcastUrl = $lsRepUrl . 'pages/r.html?room=' . $roomId . '&p=' . $encodedString . '&isAdmin=1&broadcast=1';
$sql = "INSERT INTO " . $dbPrefix . "rooms (agent, visitor, agenturl, visitorurl, password, roomId, datetime, duration, shortagenturl, shortvisitorurl, agent_id, agenturl_broadcast, visitorurl_broadcast, shortagenturl_broadcast, shortvisitorurl_broadcast, is_active) "
. "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$pdo->prepare($sql)->execute([$agentName, $visitorName, $agentUrl, $visitorUrl, md5($password), $roomId, $dateTime, $duration, $agentShortUrl, $visitorShortUrl, $agentId, $agentBroadcastUrl, $viewerBroadcastLink, $agentShortUrl_b, $visitorShortUrl_b, (int) $is_active]);
return 200;
} catch (Exception $e) {
return 'Error';
}
}
function editRoom($roomId, $agent, $visitor, $agenturl, $visitorurl, $pass, $session, $datetime, $duration, $shortagenturl, $shortvisitorurl, $agentId = null, $agenturl_broadcast = null, $visitorurl_broadcast = null, $shortagenturl_broadcast = null, $shortvisitorurl_broadcast = null, $is_active = 1) {
global $dbPrefix, $pdo;
try {
$is_active = ($is_active == 'true') ? 1 : 0;
$sql = "UPDATE " . $dbPrefix . "rooms set agent=?, visitor=?, agenturl=?, visitorurl=?, password=?, roomId=?, datetime=?, duration=?, shortagenturl=?, shortvisitorurl=?, agent_id=?, agenturl_broadcast=?, visitorurl_broadcast=?, shortagenturl_broadcast=?, shortvisitorurl_broadcast=?, is_active=?"
. " WHERE room_id = ?;";
$pdo->prepare($sql)->execute([$agent, $visitor, $agenturl, $visitorurl, md5($pass), $session, $datetime, $duration, $shortagenturl, $shortvisitorurl, $agentId, $agenturl_broadcast, $visitorurl_broadcast, $shortagenturl_broadcast, $shortvisitorurl_broadcast, (int) $is_active, $roomId]);
return 200;
} catch (Exception $e) {
return 'Error ' . $e->getMessage();
}
}
function updateRoomState($roomId, $is_active) {
global $dbPrefix, $pdo;
try {
$is_active = ($is_active == 'true') ? 1 : 0;
$sql = "UPDATE " . $dbPrefix . "rooms set is_active=?"
. " WHERE room_id = ?;";
$pdo->prepare($sql)->execute([(int) $is_active, $roomId]);
return 200;
} catch (Exception $e) {
return 'Error ' . $e->getMessage();
}
}
function insertRecording($roomId, $file, $agentId) {
global $dbPrefix, $pdo;
try {
$sql = "INSERT INTO " . $dbPrefix . "recordings (`room_id`, `filename`, `agent_id`, `date_created`) "
. "VALUES (?, ?, ?, ?)";
$pdo->prepare($sql)->execute([$roomId, $file, $agentId, date("Y-m-d H:i:s")]);
return 200;
} catch (Exception $e) {
return 'Error ' . $e->getMessage();
}
}
function deleteRecording($recordingId) {
global $dbPrefix, $pdo;
try {
$stmt = $pdo->prepare('SELECT * FROM ' . $dbPrefix . 'recordings WHERE recording_id = ?');
$stmt->execute([$recordingId]);
$rec = $stmt->fetch();
if ($rec) {
unlink('../server/recordings/' . $rec['filename']);
}
$array = [$recordingId];
$sql = 'DELETE FROM ' . $dbPrefix . 'recordings WHERE recording_id = ?';
$pdo->prepare($sql)->execute($array);
return true;
} catch (Exception $e) {
return false;
}
}
function getRecordings() {
global $dbPrefix, $pdo;
try {
$stmt = $pdo->prepare('SELECT * FROM ' . $dbPrefix . 'recordings order by date_created desc');
$stmt->execute();
$rows = array();
while ($r = $stmt->fetch()) {
if ($r['filename']) {
if (file_exists('recordings/' . $r['filename'])) {
$rows[] = $r;
}
if (file_exists('recordings/' . $r['filename'] . '.mp4')) {
$r['filename'] = $r['filename'] . '.mp4';
$rows[] = $r;
}
}
}
return json_encode($rows);
} catch (Exception $e) {
return $e->getMessage();
}
}
function insertChat($roomId, $message, $agent, $from, $participants, $agentId = null, $system = null, $avatar = null, $datetime = null) {
global $dbPrefix, $pdo;
try {
$sql = "INSERT INTO " . $dbPrefix . "chats (`room_id`, `message`, `agent`, `agent_id`, `from`, `date_created`, `participants`, `system`, `avatar`) "
. "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";
$pdo->prepare($sql)->execute([$roomId, $message, $agent, $agentId, $from, date("Y-m-d H:i:s", strtotime($datetime)), $participants, $system, $avatar]);
return 200;
} catch (Exception $e) {
return 'Error';
}
}
function getChat($roomId, $sessionId, $agentId = null) {
global $dbPrefix, $pdo;
try {
$additional = '';
$array = [$roomId, "%$sessionId%"];
if ($agentId && $agentId != 'false') {
$additional = ' AND agent_id = ?';
$array = [$roomId, $agentId, "%$sessionId%"];
}
$stmt = $pdo->prepare("SELECT * FROM " . $dbPrefix . "chats WHERE (`room_id`= ? or `room_id` = 'dashboard') $additional and participants like ? order by date_created asc");
$stmt->execute($array);
$rows = array();
while ($r = $stmt->fetch()) {
$r['date_created'] = strtotime($r['date_created']);
$rows[] = $r;
}
return json_encode($rows);
} catch (Exception $e) {
return false;
}
}
function getAgent($tenant) {
global $dbPrefix, $pdo;
try {
$array = [$tenant];
$stmt = $pdo->prepare("SELECT * FROM " . $dbPrefix . "agents WHERE `tenant`= ?");
$stmt->execute($array);
$user = $stmt->fetch();
if ($user) {
return json_encode($user);
} else {
return false;
}
} catch (Exception $e) {
return false;
}
}
function getAdmin($id) {
global $dbPrefix, $pdo;
try {
$array = [$id];
$stmt = $pdo->prepare("SELECT * FROM " . $dbPrefix . "agents WHERE `agent_id`= ?");
$stmt->execute($array);
$user = $stmt->fetch();
if ($user) {
return json_encode($user);
} else {
return false;
}
} catch (Exception $e) {
return false;
}
}
function getUser($id) {
global $dbPrefix, $pdo;
try {
$array = [$id];
$stmt = $pdo->prepare("SELECT * FROM " . $dbPrefix . "users WHERE `user_id`= ?");
$stmt->execute($array);
$user = $stmt->fetch();
if ($user) {
return json_encode($user);
} else {
return false;
}
} catch (Exception $e) {
return false;
}
}
function getRoom($roomId) {
global $dbPrefix, $pdo;
try {
$array = [$roomId];
$stmt = $pdo->prepare("SELECT * FROM " . $dbPrefix . "rooms WHERE `roomId`= ? AND `is_active` = 1");
$stmt->execute($array);
$room = $stmt->fetch();
if ($room) {
return json_encode($room);
} else {
return false;
}
} catch (Exception $e) {
return false;
}
}
function getRoomById($roomId) {
global $dbPrefix, $pdo;
try {
$array = [$roomId];
$stmt = $pdo->prepare("SELECT * FROM " . $dbPrefix . "rooms WHERE `room_id`= ? AND `is_active` = 1");
$stmt->execute($array);
$room = $stmt->fetch();
if ($room) {
return json_encode($room);
} else {
return false;
}
} catch (Exception $e) {
return false;
}
}
function getRooms($agentId = false) {
global $dbPrefix, $pdo;
try {
$additional = '';
$array = [];
if ($agentId && $agentId != 'false') {
$additional = ' WHERE agent_id = ? ';
$array = [$agentId];
}
$stmt = $pdo->prepare('SELECT * FROM ' . $dbPrefix . 'rooms ' . $additional . ' order by room_id desc');
$stmt->execute($array);
$rows = array();
while ($r = $stmt->fetch()) {
$rows[] = $r;
}
return json_encode($rows);
} catch (Exception $e) {
return false;
}
}
function deleteRoom($roomId, $agentId = false) {
global $dbPrefix, $pdo;
try {
$additional = '';
$array = [$roomId];
if ($agentId && $agentId != 'false') {
$additional = ' AND agent_id = ?';
$array = [$roomId, $agentId];
}
$sql = 'DELETE FROM ' . $dbPrefix . 'rooms WHERE room_id = ?' . $additional;
$pdo->prepare($sql)->execute($array);
return true;
} catch (Exception $e) {
return false;
}
}
function getAgents() {
global $dbPrefix, $pdo;
try {
$stmt = $pdo->prepare('SELECT * FROM ' . $dbPrefix . 'agents order by agent_id desc');
$stmt->execute();
$rows = array();
while ($r = $stmt->fetch()) {
$rows[] = $r;
}
return json_encode($rows);
} catch (Exception $e) {
return false;
}
}
function deleteAgent($agentId) {
global $dbPrefix, $pdo;
try {
$sql = 'DELETE FROM ' . $dbPrefix . 'agents WHERE agent_id = ?';
$pdo->prepare($sql)->execute([$agentId]);
return true;
} catch (Exception $e) {
return false;
}
}
function editAgent($agentId, $firstName, $lastName, $email, $tenant, $pass = null, $usernamehidden = null) {
global $dbPrefix, $pdo;
try {
$stmt = $pdo->prepare('SELECT * FROM ' . $dbPrefix . 'agents WHERE email = ? and agent_id <> ?');
$stmt->execute([$email, $agentId]);
$userName = $stmt->fetch();
if ($userName) {
return false;
}
$array = [$firstName, $lastName, $email, $tenant, $agentId];
$additional = '';
if ($pass) {
$additional = ', password = ?';
$array = [$firstName, $lastName, $email, $tenant, md5($pass), $agentId];
}
$sql = 'UPDATE ' . $dbPrefix . 'agents SET first_name=?, last_name=?, email=?, tenant=? ' . $additional . ' WHERE agent_id = ?';
if ($_SESSION["username"] == $usernamehidden) {
$_SESSION["agent"] = array('agent_id' => $agentId, 'first_name' => $firstName, 'last_name' => $lastName, 'tenant' => $tenant, 'email' => $email);
}
$pdo->prepare($sql)->execute($array);
return true;
} catch (Exception $e) {
return false;
}
}
function endMeeting($roomId, $agentId = null) {
global $dbPrefix, $pdo;
try {
$additional = '';
$array = [$roomId];
if ($agentId) {
$additional = ' AND agent_id = ?';
$array = [$roomId, $agentId];
}
return true;
} catch (Exception $e) {
return false;
}
}
function blockUser($username) {
global $dbPrefix, $pdo;
try {
$sql = 'UPDATE ' . $dbPrefix . 'users SET is_blocked=1 WHERE username = ?';
$pdo->prepare($sql)->execute(array($username));
return true;
} catch (Exception $e) {
return false;
}
}
function editAdmin($agentId, $firstName, $lastName, $email, $tenant, $pass = null) {
global $dbPrefix, $pdo;
try {
$stmt = $pdo->prepare('SELECT * FROM ' . $dbPrefix . 'agents WHERE email = ? and agent_id <> ?');
$stmt->execute([$email, $agentId]);
$userName = $stmt->fetch();
if ($userName) {
return false;
}
$array = [$firstName, $lastName, $email, $tenant, $agentId];
$additional = '';
if ($pass) {
$additional = ', password = ?';
$array = [$firstName, $lastName, $email, $tenant, md5($pass), $agentId];
}
$sql = 'UPDATE ' . $dbPrefix . 'agents SET first_name=?, last_name=?, email=?, tenant=? ' . $additional . ' WHERE agent_id = ?';
$_SESSION["agent"] = array('agent_id' => $agentId, 'first_name' => $firstName, 'last_name' => $lastName, 'tenant' => $tenant, 'email' => $email);
$pdo->prepare($sql)->execute($array);
return true;
} catch (Exception $e) {
return false;
}
}
function addAgent($user, $pass, $firstName, $lastName, $email, $tenant) {
global $dbPrefix, $pdo;
try {
$stmt = $pdo->prepare('SELECT * FROM ' . $dbPrefix . 'agents WHERE username = ? or email = ?');
$stmt->execute([$user, $email]);
$userName = $stmt->fetch();
if ($userName) {
return false;
}
$sql = 'INSERT INTO ' . $dbPrefix . 'agents (username, password, first_name, last_name, email, tenant) VALUES (?, ?, ?, ?, ?, ?)';
$pdo->prepare($sql)->execute([$user, md5($pass), $firstName, $lastName, $email, $tenant]);
return true;
} catch (Exception $e) {
return false;
}
}
function addFeedback($sessionId, $roomId, $rate, $text = '', $userId = '') {
global $dbPrefix, $pdo;
try {
$sql = 'INSERT INTO ' . $dbPrefix . 'feedbacks (session_id, room_id, rate, text, user_id, date_added) VALUES (?, ?, ?, ?, ?, ?)';
$pdo->prepare($sql)->execute([$sessionId, $roomId, $rate, $text, $userId, date("Y-m-d H:i:s")]);
return true;
} catch (Exception $e) {
return false;
}
}
function getUsers() {
global $dbPrefix, $pdo;
try {
$stmt = $pdo->prepare('SELECT * FROM ' . $dbPrefix . 'users order by user_id desc');
$stmt->execute();
$rows = array();
while ($r = $stmt->fetch()) {
$rows[] = $r;
}
return json_encode($rows);
} catch (Exception $e) {
return false;
}
}
function deleteUser($userId) {
global $dbPrefix, $pdo;
try {
$sql = 'DELETE FROM ' . $dbPrefix . 'users WHERE user_id = ?';
$pdo->prepare($sql)->execute([$userId]);
return true;
} catch (Exception $e) {
return false;
}
}
function editUser($userId, $name, $user, $pass, $blocked) {
global $dbPrefix, $pdo;
$additional = '';
$stmt = $pdo->prepare('SELECT * FROM ' . $dbPrefix . 'users WHERE username = ? and user_id <> ?');
$stmt->execute([$user, $userId]);
$userName = $stmt->fetch();
if ($userName) {
return false;
}
$array = [$user, $name, $blocked, $userId];
if ($pass) {
$additional = ', password = ?';
$array = [$user, $name, $blocked, md5($pass), $userId];
}
try {
$sql = 'UPDATE ' . $dbPrefix . 'users SET username=?, name=?, is_blocked=? ' . $additional . ' WHERE user_id = ?';
$pdo->prepare($sql)->execute($array);
return true;
} catch (Exception $e) {
return $e->getMessage();
}
}
function updateConfig($postData, $file) {
try {
$jsonString = file_get_contents('../config/' . $file . '.json');
$data = json_decode($jsonString, true);
foreach ($postData as $key => $value) {
$val = explode('.', $key);
if (isset($val[1]) && $value == 'true') {
$data[$val[0]][$val[1]] = true;
} else if (isset($val[1]) && $value == 'false') {
$data[$val[0]][$val[1]] = false;
} else if (isset($val[1]) && $value) {
$data[$val[0]][$val[1]] = $value;
} else if (isset($val[1])) {
unset($data[$val[0]][$val[1]]);
} else {
$data[$key] = $value;
}
}
$newJsonString = json_encode($data, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
file_put_contents('../config/' . $file . '.json', $newJsonString);
$currentVersion = file_get_contents('../pages/version.txt');
$curNumber = explode('.', $currentVersion);
if (count($curNumber) == 3) {
$currentVersion = $currentVersion . '.1';
} else {
$currentVersion = $curNumber[0] . '.' . $curNumber[1] . '.' . $curNumber[2] . '.' . ((int) $curNumber[3] + 1);
}
file_put_contents('../pages/version.txt', $currentVersion);
return true;
} catch (Exception $e) {
return false;
}
}
function addConfig($fileName) {
try {
$jsonString = file_get_contents('../config/config.json');
file_put_contents('../config/' . $fileName . '.json', $jsonString);
return true;
} catch (Exception $e) {
return false;
}
}
function updateLocale($postData, $file) {
try {
$jsonString = file_get_contents('../locales/' . $file . '.json');
$data = json_decode($jsonString, true);
foreach ($postData as $key => $value) {
$val = explode('.', $key);
if (isset($val[1]) && $value == 'true') {
$data[$val[0]][$val[1]] = true;
} else if (isset($val[1]) && $value == 'false') {
$data[$val[0]][$val[1]] = false;
} else if (isset($val[1]) && $value) {
$data[$val[0]][$val[1]] = $value;
} else if (isset($val[1])) {
unset($data[$val[0]][$val[1]]);
} else {
$data[$key] = $value;
}
}
$newJsonString = json_encode($data, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
file_put_contents('../locales/' . $file . '.json', $newJsonString);
$currentVersion = file_get_contents('../pages/version.txt');
$curNumber = explode('.', $currentVersion);
if (count($curNumber) == 3) {
$currentVersion = $currentVersion . '.1';
} else {
$currentVersion = $curNumber[0] . '.' . $curNumber[1] . '.' . $curNumber[2] . '.' . ((int) $curNumber[3] + 1);
}
file_put_contents('../pages/version.txt', $currentVersion);
return true;
} catch (Exception $e) {
return false;
}
}
function addLocale($fileName) {
try {
$jsonString = file_get_contents('../locales/en_US.json');
file_put_contents('../locales/' . $fileName . '.json', $jsonString);
return true;
} catch (Exception $e) {
return false;
}
}
function addUser($user, $name, $pass, $firstName = null, $lastName = null) {
global $dbPrefix, $pdo;
try {
$stmt = $pdo->prepare('SELECT * FROM ' . $dbPrefix . 'users WHERE username = ?');
$stmt->execute([$user]);
$userName = $stmt->fetch();
if ($userName) {
return false;
}
$sql = 'INSERT INTO ' . $dbPrefix . 'users (username, name, password, first_name, last_name) VALUES (?, ?, ?, ?, ?)';
$pdo->prepare($sql)->execute([$user, $name, md5($pass), $firstName, $lastName]);
return true;
} catch (Exception $e) {
return false;
}
}
function loginAgent($username, $pass) {
global $dbPrefix, $pdo;
try {
$stmt = $pdo->prepare('SELECT * FROM ' . $dbPrefix . 'agents WHERE username = ? AND password=?');
$stmt->execute([$username, md5($pass)]);
$user = $stmt->fetch();
if ($user) {
$_SESSION["tenant"] = ($user['is_master']) ? 'lsv_mastertenant' : $user['tenant'];
$_SESSION["username"] = $user['username'];
$_SESSION["agent"] = array('agent_id' => $user['agent_id'], 'first_name' => $user['first_name'], 'last_name' => $user['last_name'], 'tenant' => $user['tenant'], 'email' => $user['email']);
return true;
} else {
return false;
}
} catch (Exception $e) {
return false;
}
}
function loginAdmin($email, $pass) {
global $dbPrefix, $pdo;
try {
$stmt = $pdo->prepare('SELECT * FROM ' . $dbPrefix . 'agents WHERE email = ? AND password = ?');
$stmt->execute([$email, md5($pass)]);
$user = $stmt->fetch();
if ($user) {
return 200;
} else {
return false;
}
} catch (Exception $e) {
return false;
}
}
function getChats($agentId = false) {
global $dbPrefix, $pdo;
try {
$additional = '';
$array = [];
if ($agentId && $agentId != 'false') {
$additional = ' WHERE agent_id = ? ';
$array = [$agentId];
}
$stmt = $pdo->prepare('SELECT max(room_id) as room_id, max(date_created) as date_created, max(agent) as agent FROM ' . $dbPrefix . 'chats ' . $additional . ' group by room_id order by date_created desc');
$stmt->execute($array);
$rows = array();
while ($r = $stmt->fetch()) {
$stmt1 = $pdo->prepare('SELECT * FROM ' . $dbPrefix . 'chats where room_id=? order by date_created asc ');
$stmt1->execute([$r['room_id']]);
$rows1 = '<table>';
while ($r1 = $stmt1->fetch()) {
$rows1 .= '<tr><td><small>' . $r1['date_created'] . '</small></td><td>' . $r1['from'] . ': ' . $r1['message'] . '</td></tr>';
}
$rows1 .= '</table>';
$r['messages'] = $rows1;
$rows[] = $r;
}
return json_encode($rows);
} catch (Exception $e) {
return $e->getMessage();
}
}
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
if (isset($_POST['type']) && $_POST['type'] == 'login') {
echo checkLogin($_POST['email'], $_POST['password']);
}
if (isset($_POST['type']) && $_POST['type'] == 'logintoken') {
echo checkLoginToken($_POST['token'], $_POST['roomId'], @$_POST['isAdmin']);
}
if (isset($_POST['type']) && $_POST['type'] == 'scheduling') {
echo insertScheduling($_POST['agent'], $_POST['visitor'], $_POST['agenturl'], $_POST['visitorurl'], $_POST['password'], $_POST['session'], $_POST['datetime'], $_POST['duration'], $_POST['shortAgentUrl'], $_POST['shortVisitorUrl'], $_POST['agentId'], @$_POST['agenturl_broadcast'], @$_POST['visitorurl_broadcast'], @$_POST['shortAgentUrl_broadcast'], @$_POST['shortVisitorUrl_broadcast'], @$_POST['is_active']);
}
if (isset($_POST['type']) && $_POST['type'] == 'addroom') {
echo addRoom($_POST['lsRepUrl'], @$_POST['agentId'], @$_POST['roomId'], @$_POST['agentName'], @$_POST['visitorName'], @$_POST['agentShortUrl'], @$_POST['visitorShortUrl'], @$_POST['password'], @$_POST['config'], @$_POST['dateTime'], @$_POST['duration'], @$_POST['disableVideo'], @$_POST['disableAudio'], @$_POST['disableScreenShare'], @$_POST['disableWhiteboard'], @$_POST['disableTransfer'], @$_POST['is_active']);
}
if (isset($_POST['type']) && $_POST['type'] == 'editroom') {
echo editRoom($_POST['room_id'], $_POST['agent'], $_POST['visitor'], $_POST['agenturl'], $_POST['visitorurl'], $_POST['password'], $_POST['session'], $_POST['datetime'], $_POST['duration'], $_POST['shortAgentUrl'], $_POST['shortVisitorUrl'], $_POST['agentId'], @$_POST['agenturl_broadcast'], @$_POST['visitorurl_broadcast'], @$_POST['shortAgentUrl_broadcast'], @$_POST['shortVisitorUrl_broadcast'], @$_POST['is_active']);
}
if (isset($_POST['type']) && $_POST['type'] == 'changeroomstate') {
echo updateRoomState($_POST['room_id'], $_POST['is_active']);
}
if (isset($_POST['type']) && $_POST['type'] == 'addchat') {
echo insertChat($_POST['roomId'], $_POST['message'], $_POST['agent'], $_POST['from'], $_POST['participants'], @$_POST['agentId'], @$_POST['system'], @$_POST['avatar'], @$_POST['datetime']);
}
if (isset($_POST['type']) && $_POST['type'] == 'getchat') {
echo getChat($_POST['roomId'], $_POST['sessionId'], @$_POST['agentId']);
}
if (isset($_POST['type']) && $_POST['type'] == 'getrooms') {
echo getRooms(@$_POST['agentId']);
}
if (isset($_POST['type']) && $_POST['type'] == 'getchats') {
echo getChats(@$_POST['agentId']);
}
if (isset($_POST['type']) && $_POST['type'] == 'deleteroom') {
echo deleteRoom($_POST['roomId'], $_POST['agentId']);
}
if (isset($_POST['type']) && $_POST['type'] == 'getagents') {
echo getAgents();
}
if (isset($_POST['type']) && $_POST['type'] == 'deleteagent') {
echo deleteAgent($_POST['agentId']);
}
if (isset($_POST['type']) && $_POST['type'] == 'editagent') {
echo editAgent($_POST['agentId'], $_POST['firstName'], $_POST['lastName'], $_POST['email'], $_POST['tenant'], $_POST['password'], @$_POST['usernamehidden']);
}
if (isset($_POST['type']) && $_POST['type'] == 'editadmin') {
echo editAdmin($_POST['agentId'], $_POST['firstName'], $_POST['lastName'], $_POST['email'], $_POST['tenant'], $_POST['password']);
}
if (isset($_POST['type']) && $_POST['type'] == 'loginagent') {
echo loginAgent($_POST['username'], $_POST['password']);
}
if (isset($_POST['type']) && $_POST['type'] == 'loginadmin') {
echo loginAdmin($_POST['email'], $_POST['password']);
}
if (isset($_POST['type']) && $_POST['type'] == 'addagent') {
echo addAgent($_POST['username'], $_POST['password'], $_POST['firstName'], $_POST['lastName'], $_POST['email'], $_POST['tenant']);
}
if (isset($_POST['type']) && $_POST['type'] == 'addrecording') {
echo insertRecording($_POST['roomId'], $_POST['filename'], $_POST['agentId']);
}
if (isset($_POST['type']) && $_POST['type'] == 'getrecordings') {
echo getRecordings();
}
if (isset($_POST['type']) && $_POST['type'] == 'deleterecording') {
echo deleteRecording($_POST['recordingId']);
}
if (isset($_POST['type']) && $_POST['type'] == 'getusers') {
echo getUsers();
}
if (isset($_POST['type']) && $_POST['type'] == 'deleteuser') {
echo deleteUser($_POST['userId']);
}
if (isset($_POST['type']) && $_POST['type'] == 'edituser') {
echo editUser($_POST['userId'], $_POST['name'], $_POST['username'], @$_POST['password'], @$_POST['isBlocked']);
}
if (isset($_POST['type']) && $_POST['type'] == 'adduser') {
echo addUser($_POST['username'], $_POST['name'], $_POST['password'], @$_POST['firstName'], @$_POST['lastName']);
}
if (isset($_POST['type']) && $_POST['type'] == 'updateconfig') {
echo updateConfig($_POST['data'], $_POST['fileName']);
}
if (isset($_POST['type']) && $_POST['type'] == 'addconfig') {
echo addConfig($_POST['fileName']);
}
if (isset($_POST['type']) && $_POST['type'] == 'updatelocale') {
echo updateLocale($_POST['data'], $_POST['fileName']);
}
if (isset($_POST['type']) && $_POST['type'] == 'addlocale') {
echo addLocale($_POST['fileName']);
}
if (isset($_POST['type']) && $_POST['type'] == 'getagent') {
echo getAgent($_POST['tenant']);
}
if (isset($_POST['type']) && $_POST['type'] == 'getuser') {
echo getUser($_POST['id']);
}
if (isset($_POST['type']) && $_POST['type'] == 'getadmin') {
echo getAdmin($_POST['id']);
}
if (isset($_POST['type']) && $_POST['type'] == 'blockuser') {
echo blockUser($_POST['username']);
}
if (isset($_POST['type']) && $_POST['type'] == 'feedback') {
echo addFeedback($_POST['sessionId'], $_POST['roomId'], $_POST['rate'], @$_POST['text'], @$_POST['userId']);
}
if (isset($_POST['type']) && $_POST['type'] == 'getroom') {
echo getRoom($_POST['roomId']);
}
if (isset($_POST['type']) && $_POST['type'] == 'getroombyid') {
echo getRoomById($_POST['room_id']);
}
if (isset($_POST['type']) && $_POST['type'] == 'endmeeting') {
echo endMeeting($_POST['roomId'], @$_POST['agentId']);
}
}