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: 1321: 1322: 1323: 1324: 1325: 1326: 1327: 1328: 1329: 1330: 1331: 1332: 1333: 1334: 1335: 1336: 1337: 1338: 1339: 1340: 1341: 1342: 1343: 1344: 1345: 1346: 1347: 1348: 1349: 1350: 1351: 1352: 1353: 1354: 1355: 1356: 1357: 1358: 1359: 1360: 1361: 1362: 1363: 1364: 1365: 1366: 1367: 1368: 1369: 1370: 1371: 1372: 1373: 1374: 1375: 1376: 1377: 1378: 1379: 1380: 1381: 1382: 1383: 1384: 1385: 1386: 1387: 1388: 1389: 1390: 1391: 1392: 1393: 1394: 1395: 1396: 1397: 1398: 1399: 1400: 1401: 1402: 1403: 1404: 1405: 1406: 1407: 1408: 1409: 1410: 1411: 1412: 1413: 1414: 1415: 1416: 1417: 1418: 1419: 1420: 1421: 1422: 1423: 1424: 1425: 1426: 1427: 1428: 1429: 1430: 1431: 1432: 1433: 1434: 1435: 1436: 1437: 1438: 1439: 1440: 1441: 1442: 1443: 1444: 1445: 1446: 1447: 1448: 1449: 1450: 1451: 1452: 1453: 1454: 1455: 1456: 1457: 1458: 1459: 1460: 1461: 1462: 1463: 1464: 1465: 1466: 1467: 1468: 1469: 1470: 1471: 1472: 1473: 1474: 1475: 1476: 1477: 1478: 1479: 1480: 1481: 1482: 1483: 1484: 1485: 1486: 1487: 1488: 1489: 1490: 1491: 1492: 1493: 1494: 1495: 1496: 1497: 1498: 1499: 1500: 1501: 1502: 1503: 1504: 1505: 1506: 1507: 1508: 1509: 1510: 1511: 1512: 1513: 1514: 1515: 1516: 1517: 1518: 1519: 1520: 1521: 1522: 1523: 1524: 1525: 1526: 1527: 1528: 1529: 1530: 1531: 1532: 1533: 1534: 1535: 1536: 1537: 1538: 1539: 1540: 1541:
<?php
if (!defined('SMF'))
die('No direct access...');
function markBoardsRead($boards, $unread = false)
{
global $user_info, $modSettings, $smcFunc;
if (!is_array($boards))
$boards = array($boards);
else
$boards = array_unique($boards);
if (empty($boards))
return;
if ($unread)
{
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}log_mark_read
WHERE id_board IN ({array_int:board_list})
AND id_member = {int:current_member}',
array(
'current_member' => $user_info['id'],
'board_list' => $boards,
)
);
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}log_boards
WHERE id_board IN ({array_int:board_list})
AND id_member = {int:current_member}',
array(
'current_member' => $user_info['id'],
'board_list' => $boards,
)
);
}
else
{
$markRead = array();
foreach ($boards as $board)
$markRead[] = array($modSettings['maxMsgID'], $user_info['id'], $board);
$smcFunc['db_insert']('replace',
'{db_prefix}log_mark_read',
array('id_msg' => 'int', 'id_member' => 'int', 'id_board' => 'int'),
$markRead,
array('id_board', 'id_member')
);
$smcFunc['db_insert']('replace',
'{db_prefix}log_boards',
array('id_msg' => 'int', 'id_member' => 'int', 'id_board' => 'int'),
$markRead,
array('id_board', 'id_member')
);
}
$result = $smcFunc['db_query']('', '
SELECT MIN(id_topic)
FROM {db_prefix}log_topics
WHERE id_member = {int:current_member}',
array(
'current_member' => $user_info['id'],
)
);
list ($lowest_topic) = $smcFunc['db_fetch_row']($result);
$smcFunc['db_free_result']($result);
if (empty($lowest_topic))
return;
$result = $smcFunc['db_query']('', '
SELECT lt.id_topic
FROM {db_prefix}log_topics AS lt
INNER JOIN {db_prefix}topics AS t /*!40000 USE INDEX (PRIMARY) */ ON (t.id_topic = lt.id_topic
AND t.id_board IN ({array_int:board_list}))
WHERE lt.id_member = {int:current_member}
AND lt.id_topic >= {int:lowest_topic}
AND lt.unwatched != 1',
array(
'current_member' => $user_info['id'],
'board_list' => $boards,
'lowest_topic' => $lowest_topic,
)
);
$topics = array();
while ($row = $smcFunc['db_fetch_assoc']($result))
$topics[] = $row['id_topic'];
$smcFunc['db_free_result']($result);
if (!empty($topics))
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}log_topics
WHERE id_member = {int:current_member}
AND id_topic IN ({array_int:topic_list})',
array(
'current_member' => $user_info['id'],
'topic_list' => $topics,
)
);
}
function MarkRead()
{
global $board, $topic, $user_info, $board_info, $modSettings, $smcFunc;
is_not_guest();
checkSession('get');
if (isset($_REQUEST['sa']) && $_REQUEST['sa'] == 'all')
{
$result = $smcFunc['db_query']('', '
SELECT b.id_board
FROM {db_prefix}boards AS b
WHERE {query_see_board}',
array(
)
);
$boards = array();
while ($row = $smcFunc['db_fetch_assoc']($result))
$boards[] = $row['id_board'];
$smcFunc['db_free_result']($result);
if (!empty($boards))
markBoardsRead($boards, isset($_REQUEST['unread']));
$_SESSION['id_msg_last_visit'] = $modSettings['maxMsgID'];
if (!empty($_SESSION['old_url']) && strpos($_SESSION['old_url'], 'action=unread') !== false)
redirectexit('action=unread');
if (isset($_SESSION['topicseen_cache']))
$_SESSION['topicseen_cache'] = array();
redirectexit();
}
elseif (isset($_REQUEST['sa']) && $_REQUEST['sa'] == 'unreadreplies')
{
$topics = array_map('intval', explode('-', $_REQUEST['topics']));
$request = $smcFunc['db_query']('', '
SELECT id_topic, unwatched
FROM {db_prefix}log_topics
WHERE id_topic IN ({array_int:selected_topics})
AND id_member = {int:current_user}',
array(
'selected_topics' => $topics,
'current_user' => $user_info['id'],
)
);
$logged_topics = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
$logged_topics[$row['id_topic']] = $row['unwatched'];
$smcFunc['db_free_result']($request);
$markRead = array();
foreach ($topics as $id_topic)
$markRead[] = array($modSettings['maxMsgID'], $user_info['id'], $id_topic, (isset($logged_topics[$topic]) ? $logged_topics[$topic] : 0));
$smcFunc['db_insert']('replace',
'{db_prefix}log_topics',
array('id_msg' => 'int', 'id_member' => 'int', 'id_topic' => 'int', 'unwatched' => 'int'),
$markRead,
array('id_member', 'id_topic')
);
if (isset($_SESSION['topicseen_cache']))
$_SESSION['topicseen_cache'] = array();
redirectexit('action=unreadreplies');
}
elseif (isset($_REQUEST['sa']) && $_REQUEST['sa'] == 'topic')
{
$result = $smcFunc['db_query']('', '
SELECT t.id_first_msg, t.id_last_msg, COALESCE(lt.unwatched, 0) as unwatched
FROM {db_prefix}topics as t
LEFT JOIN {db_prefix}log_topics as lt ON (lt.id_topic = t.id_topic AND lt.id_member = {int:current_member})
WHERE t.id_topic = {int:current_topic}',
array(
'current_topic' => $topic,
'current_member' => $user_info['id'],
)
);
$topicinfo = $smcFunc['db_fetch_assoc']($result);
$smcFunc['db_free_result']($result);
if (!empty($_GET['t']))
{
if ($_GET['t'] >= $topicinfo['id_last_msg'])
$earlyMsg = 0;
elseif ($_GET['t'] <= $topicinfo['id_first_msg'])
$earlyMsg = 0;
else
{
$result = $smcFunc['db_query']('', '
SELECT MAX(id_msg)
FROM {db_prefix}messages
WHERE id_topic = {int:current_topic}
AND id_msg >= {int:id_first_msg}
AND id_msg < {int:topic_msg_id}',
array(
'current_topic' => $topic,
'topic_msg_id' => (int) $_GET['t'],
'id_first_msg' => $topicinfo['id_first_msg'],
)
);
list ($earlyMsg) = $smcFunc['db_fetch_row']($result);
$smcFunc['db_free_result']($result);
}
}
elseif ($_REQUEST['start'] == 0)
$earlyMsg = 0;
else
{
$result = $smcFunc['db_query']('', '
SELECT id_msg
FROM {db_prefix}messages
WHERE id_topic = {int:current_topic}
ORDER BY id_msg
LIMIT {int:start}, 1',
array(
'current_topic' => $topic,
'start' => (int) $_REQUEST['start'],
)
);
list ($earlyMsg) = $smcFunc['db_fetch_row']($result);
$smcFunc['db_free_result']($result);
$earlyMsg--;
}
$smcFunc['db_insert']('replace',
'{db_prefix}log_topics',
array('id_msg' => 'int', 'id_member' => 'int', 'id_topic' => 'int', 'unwatched' => 'int'),
array($earlyMsg, $user_info['id'], $topic, $topicinfo['unwatched']),
array('id_member', 'id_topic')
);
redirectexit('board=' . $board . '.0');
}
else
{
$categories = array();
$boards = array();
if (isset($_REQUEST['c']))
{
$_REQUEST['c'] = explode(',', $_REQUEST['c']);
foreach ($_REQUEST['c'] as $c)
$categories[] = (int) $c;
}
if (isset($_REQUEST['boards']))
{
$_REQUEST['boards'] = explode(',', $_REQUEST['boards']);
foreach ($_REQUEST['boards'] as $b)
$boards[] = (int) $b;
}
if (!empty($board))
$boards[] = (int) $board;
if (isset($_REQUEST['children']) && !empty($boards))
{
$request = $smcFunc['db_query']('', '
SELECT b.id_board, b.id_parent
FROM {db_prefix}boards AS b
WHERE {query_see_board}
AND b.child_level > {int:no_parents}
AND b.id_board NOT IN ({array_int:board_list})
ORDER BY child_level ASC',
array(
'no_parents' => 0,
'board_list' => $boards,
)
);
while ($row = $smcFunc['db_fetch_assoc']($request))
if (in_array($row['id_parent'], $boards))
$boards[] = $row['id_board'];
$smcFunc['db_free_result']($request);
}
$clauses = array();
$clauseParameters = array();
if (!empty($categories))
{
$clauses[] = 'id_cat IN ({array_int:category_list})';
$clauseParameters['category_list'] = $categories;
}
if (!empty($boards))
{
$clauses[] = 'id_board IN ({array_int:board_list})';
$clauseParameters['board_list'] = $boards;
}
if (empty($clauses))
redirectexit();
$request = $smcFunc['db_query']('', '
SELECT b.id_board
FROM {db_prefix}boards AS b
WHERE {query_see_board}
AND b.' . implode(' OR b.', $clauses),
array_merge($clauseParameters, array(
))
);
$boards = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
$boards[] = $row['id_board'];
$smcFunc['db_free_result']($request);
if (empty($boards))
redirectexit();
markBoardsRead($boards, isset($_REQUEST['unread']));
foreach ($boards as $b)
{
if (isset($_SESSION['topicseen_cache'][$b]))
$_SESSION['topicseen_cache'][$b] = array();
}
if (!isset($_REQUEST['unread']))
{
$result = $smcFunc['db_query']('', '
SELECT b.id_board
FROM {db_prefix}boards AS b
WHERE b.id_parent IN ({array_int:parent_list})
AND {query_see_board}',
array(
'parent_list' => $boards,
)
);
if ($smcFunc['db_num_rows']($result) > 0)
{
$logBoardInserts = array();
while ($row = $smcFunc['db_fetch_assoc']($result))
$logBoardInserts[] = array($modSettings['maxMsgID'], $user_info['id'], $row['id_board']);
$smcFunc['db_insert']('replace',
'{db_prefix}log_boards',
array('id_msg' => 'int', 'id_member' => 'int', 'id_board' => 'int'),
$logBoardInserts,
array('id_member', 'id_board')
);
}
$smcFunc['db_free_result']($result);
if (empty($board))
redirectexit();
else
redirectexit('board=' . $board . '.0');
}
else
{
if (empty($board_info['parent']))
redirectexit();
else
redirectexit('board=' . $board_info['parent'] . '.0');
}
}
}
function getMsgMemberID($messageID)
{
global $smcFunc;
$result = $smcFunc['db_query']('', '
SELECT COALESCE(mem.id_member, 0)
FROM {db_prefix}messages AS m
LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
WHERE m.id_msg = {int:selected_message}
LIMIT 1',
array(
'selected_message' => (int) $messageID,
)
);
if ($smcFunc['db_num_rows']($result) > 0)
list ($memberID) = $smcFunc['db_fetch_row']($result);
else
$memberID = 0;
$smcFunc['db_free_result']($result);
return (int) $memberID;
}
function modifyBoard($board_id, &$boardOptions)
{
global $cat_tree, $boards, $smcFunc;
getBoardTree();
if (!isset($boards[$board_id]) || (isset($boardOptions['target_board']) && !isset($boards[$boardOptions['target_board']])) || (isset($boardOptions['target_category']) && !isset($cat_tree[$boardOptions['target_category']])))
fatal_lang_error('no_board');
$id = $board_id;
call_integration_hook('integrate_pre_modify_board', array($id, &$boardOptions));
$boardUpdates = array();
$boardUpdateParameters = array();
if (isset($boardOptions['move_to']))
{
if ($boardOptions['move_to'] == 'top')
{
$id_cat = $boardOptions['target_category'];
$child_level = 0;
$id_parent = 0;
$after = $cat_tree[$id_cat]['last_board_order'];
}
elseif ($boardOptions['move_to'] == 'bottom')
{
$id_cat = $boardOptions['target_category'];
$child_level = 0;
$id_parent = 0;
$after = 0;
foreach ($cat_tree[$id_cat]['children'] as $id_board => $dummy)
$after = max($after, $boards[$id_board]['order']);
}
elseif ($boardOptions['move_to'] == 'child')
{
$id_cat = $boards[$boardOptions['target_board']]['category'];
$child_level = $boards[$boardOptions['target_board']]['level'] + 1;
$id_parent = $boardOptions['target_board'];
if (isChildOf($id_parent, $board_id))
fatal_lang_error('mboards_parent_own_child_error', false);
elseif ($id_parent == $board_id)
fatal_lang_error('mboards_board_own_child_error', false);
$after = $boards[$boardOptions['target_board']]['order'];
if (!empty($boards[$id_parent]['tree']['children']) && empty($boardOptions['move_first_child']))
foreach ($boards[$id_parent]['tree']['children'] as $childBoard_id => $dummy)
$after = max($after, $boards[$childBoard_id]['order']);
}
elseif (in_array($boardOptions['move_to'], array('before', 'after')))
{
$id_cat = $boards[$boardOptions['target_board']]['category'];
$child_level = $boards[$boardOptions['target_board']]['level'];
$id_parent = $boards[$boardOptions['target_board']]['parent'];
$after = $boards[$boardOptions['target_board']]['order'] - ($boardOptions['move_to'] == 'before' ? 1 : 0);
}
else
trigger_error('modifyBoard(): The move_to value \'' . $boardOptions['move_to'] . '\' is incorrect', E_USER_ERROR);
$childList = array();
recursiveBoards($childList, $boards[$board_id]['tree']);
$childUpdates = array();
$levelDiff = $child_level - $boards[$board_id]['level'];
if ($levelDiff != 0)
$childUpdates[] = 'child_level = child_level ' . ($levelDiff > 0 ? '+ ' : '') . '{int:level_diff}';
if ($id_cat != $boards[$board_id]['category'])
$childUpdates[] = 'id_cat = {int:category}';
if (!empty($childList) && !empty($childUpdates))
$smcFunc['db_query']('', '
UPDATE {db_prefix}boards
SET ' . implode(',
', $childUpdates) . '
WHERE id_board IN ({array_int:board_list})',
array(
'board_list' => $childList,
'category' => $id_cat,
'level_diff' => $levelDiff,
)
);
$smcFunc['db_query']('', '
UPDATE {db_prefix}boards
SET board_order = board_order + {int:new_order}
WHERE board_order > {int:insert_after}
AND id_board != {int:selected_board}',
array(
'insert_after' => $after,
'selected_board' => $board_id,
'new_order' => 1 + count($childList),
)
);
$boardUpdates[] = 'id_cat = {int:id_cat}';
$boardUpdates[] = 'id_parent = {int:id_parent}';
$boardUpdates[] = 'child_level = {int:child_level}';
$boardUpdates[] = 'board_order = {int:board_order}';
$boardUpdateParameters += array(
'id_cat' => $id_cat,
'id_parent' => $id_parent,
'child_level' => $child_level,
'board_order' => $after + 1,
);
}
if (isset($boardOptions['posts_count']))
{
$boardUpdates[] = 'count_posts = {int:count_posts}';
$boardUpdateParameters['count_posts'] = $boardOptions['posts_count'] ? 0 : 1;
}
if (isset($boardOptions['board_theme']))
{
$boardUpdates[] = 'id_theme = {int:id_theme}';
$boardUpdateParameters['id_theme'] = (int) $boardOptions['board_theme'];
}
if (isset($boardOptions['override_theme']))
{
$boardUpdates[] = 'override_theme = {int:override_theme}';
$boardUpdateParameters['override_theme'] = $boardOptions['override_theme'] ? 1 : 0;
}
if (isset($boardOptions['access_groups']))
{
$boardUpdates[] = 'member_groups = {string:member_groups}';
$boardUpdateParameters['member_groups'] = implode(',', $boardOptions['access_groups']);
}
if (isset($boardOptions['deny_groups']))
{
$boardUpdates[] = 'deny_member_groups = {string:deny_groups}';
$boardUpdateParameters['deny_groups'] = implode(',', $boardOptions['deny_groups']);
}
if (isset($boardOptions['board_name']))
{
$boardUpdates[] = 'name = {string:board_name}';
$boardUpdateParameters['board_name'] = $boardOptions['board_name'];
}
if (isset($boardOptions['board_description']))
{
$boardUpdates[] = 'description = {string:board_description}';
$boardUpdateParameters['board_description'] = $boardOptions['board_description'];
}
if (isset($boardOptions['profile']))
{
$boardUpdates[] = 'id_profile = {int:profile}';
$boardUpdateParameters['profile'] = (int) $boardOptions['profile'];
}
if (isset($boardOptions['redirect']))
{
$boardUpdates[] = 'redirect = {string:redirect}';
$boardUpdateParameters['redirect'] = $boardOptions['redirect'];
}
if (isset($boardOptions['num_posts']))
{
$boardUpdates[] = 'num_posts = {int:num_posts}';
$boardUpdateParameters['num_posts'] = (int) $boardOptions['num_posts'];
}
$id = $board_id;
call_integration_hook('integrate_modify_board', array($id, $boardOptions, &$boardUpdates, &$boardUpdateParameters));
if (!empty($boardUpdates))
$smcFunc['db_query']('', '
UPDATE {db_prefix}boards
SET
' . implode(',
', $boardUpdates) . '
WHERE id_board = {int:selected_board}',
array_merge($boardUpdateParameters, array(
'selected_board' => $board_id,
))
);
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}board_permissions_view
WHERE id_board = {int:selected_board}',
array(
'selected_board' => $board_id,
)
);
if (!empty($boardUpdateParameters['deny_groups']))
{
$insert = array();
foreach ($boardOptions['deny_groups'] as $value)
$insert[] = array($value, $board_id, 1);
$smcFunc['db_insert']('insert',
'{db_prefix}board_permissions_view',
array('id_group' => 'int', 'id_board' => 'int', 'deny' => 'int'),
$insert,
array('id_group', 'id_board', 'deny')
);
}
if (!empty($boardUpdateParameters['member_groups']))
{
$insert = array();
foreach ($boardOptions['access_groups'] as $value)
$insert[] = array($value, $board_id, 0);
$smcFunc['db_insert']('insert',
'{db_prefix}board_permissions_view',
array('id_group' => 'int', 'id_board' => 'int', 'deny' => 'int'),
$insert,
array('id_group', 'id_board', 'deny')
);
}
if (isset($boardOptions['moderators']) || isset($boardOptions['moderator_string']) || isset($boardOptions['moderator_groups']) || isset($boardOptions['moderator_group_string']))
{
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}moderators
WHERE id_board = {int:board_list}',
array(
'board_list' => $board_id,
)
);
if (isset($boardOptions['moderator_string']) && trim($boardOptions['moderator_string']) != '')
{
$moderator_string = strtr($smcFunc['htmlspecialchars']($boardOptions['moderator_string'], ENT_QUOTES), array('"' => '"'));
preg_match_all('~"([^"]+)"~', $moderator_string, $matches);
$moderators = array_merge($matches[1], explode(',', preg_replace('~"[^"]+"~', '', $moderator_string)));
for ($k = 0, $n = count($moderators); $k < $n; $k++)
{
$moderators[$k] = trim($moderators[$k]);
if (strlen($moderators[$k]) == 0)
unset($moderators[$k]);
}
if (empty($boardOptions['moderators']))
$boardOptions['moderators'] = array();
if (!empty($moderators))
{
$request = $smcFunc['db_query']('', '
SELECT id_member
FROM {db_prefix}members
WHERE member_name IN ({array_string:moderator_list}) OR real_name IN ({array_string:moderator_list})
LIMIT {int:limit}',
array(
'moderator_list' => $moderators,
'limit' => count($moderators),
)
);
while ($row = $smcFunc['db_fetch_assoc']($request))
$boardOptions['moderators'][] = $row['id_member'];
$smcFunc['db_free_result']($request);
}
}
if (!empty($boardOptions['moderators']))
{
$inserts = array();
foreach ($boardOptions['moderators'] as $moderator)
$inserts[] = array($board_id, $moderator);
$smcFunc['db_insert']('insert',
'{db_prefix}moderators',
array('id_board' => 'int', 'id_member' => 'int'),
$inserts,
array('id_board', 'id_member')
);
}
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}moderator_groups
WHERE id_board = {int:board_list}',
array(
'board_list' => $board_id,
)
);
if (isset($boardOptions['moderator_group_string']) && trim($boardOptions['moderator_group_string']) != '')
{
$moderator_group_string = strtr($smcFunc['htmlspecialchars']($boardOptions['moderator_group_string'], ENT_QUOTES), array('"' => '"'));
preg_match_all('~"([^"]+)"~', $moderator_group_string, $matches);
$moderator_groups = array_merge($matches[1], explode(',', preg_replace('~"[^"]+"~', '', $moderator_group_string)));
for ($k = 0, $n = count($moderator_groups); $k < $n; $k++)
{
$moderator_groups[$k] = trim($moderator_groups[$k]);
if (strlen($moderator_groups[$k]) == 0)
unset($moderator_groups[$k]);
}
if (empty($boardOptions['moderator_groups']))
$boardOptions['moderator_groups'] = array();
if (!empty($moderator_groups))
{
$request = $smcFunc['db_query']('', '
SELECT id_group
FROM {db_prefix}membergroups
WHERE group_name IN ({array_string:moderator_group_list})
AND hidden = {int:visible}
AND min_posts = {int:negative_one}
AND id_group NOT IN ({array_int:invalid_groups})
LIMIT {int:limit}',
array(
'visible' => 0,
'negative_one' => -1,
'invalid_groups' => array(1, 3),
'moderator_group_list' => $moderator_groups,
'limit' => count($moderator_groups),
)
);
while ($row = $smcFunc['db_fetch_assoc']($request))
{
$boardOptions['moderator_groups'][] = $row['id_group'];
}
$smcFunc['db_free_result']($request);
}
}
if (!empty($boardOptions['moderator_groups']))
{
$inserts = array();
foreach ($boardOptions['moderator_groups'] as $moderator_group)
$inserts[] = array($board_id, $moderator_group);
$smcFunc['db_insert']('insert',
'{db_prefix}moderator_groups',
array('id_board' => 'int', 'id_group' => 'int'),
$inserts,
array('id_board', 'id_group')
);
}
updateSettings(array('settings_updated' => time()));
}
if (isset($boardOptions['move_to']))
reorderBoards();
clean_cache('data');
if (empty($boardOptions['dont_log']))
logAction('edit_board', array('board' => $board_id), 'admin');
}
function createBoard($boardOptions)
{
global $boards, $smcFunc;
if (!isset($boardOptions['board_name']) || trim($boardOptions['board_name']) == '' || !isset($boardOptions['move_to']) || !isset($boardOptions['target_category']))
trigger_error('createBoard(): One or more of the required options is not set', E_USER_ERROR);
if (in_array($boardOptions['move_to'], array('child', 'before', 'after')) && !isset($boardOptions['target_board']))
trigger_error('createBoard(): Target board is not set', E_USER_ERROR);
$boardOptions += array(
'posts_count' => true,
'override_theme' => false,
'board_theme' => 0,
'access_groups' => array(),
'board_description' => '',
'profile' => 1,
'moderators' => '',
'inherit_permissions' => true,
'dont_log' => true,
);
$default_memgrps = '-1,0';
$board_columns = array(
'id_cat' => 'int', 'name' => 'string-255', 'description' => 'string', 'board_order' => 'int',
'member_groups' => 'string', 'redirect' => 'string',
);
$board_parameters = array(
$boardOptions['target_category'], $boardOptions['board_name'], '', 0,
$default_memgrps, '',
);
call_integration_hook('integrate_create_board', array(&$boardOptions, &$board_columns, &$board_parameters));
$board_id = $smcFunc['db_insert']('',
'{db_prefix}boards',
$board_columns,
$board_parameters,
array('id_board'),
1
);
$insert = array();
foreach (explode(',', $default_memgrps) as $value)
$insert[] = array($value, $board_id, 0);
$smcFunc['db_insert']('',
'{db_prefix}board_permissions_view',
array('id_group' => 'int', 'id_board' => 'int', 'deny' => 'int'),
$insert,
array('id_group', 'id_board', 'deny'),
1
);
if (empty($board_id))
return 0;
modifyBoard($board_id, $boardOptions);
if ($boardOptions['inherit_permissions'])
{
getBoardTree();
if (!empty($boards[$board_id]['parent']))
{
$request = $smcFunc['db_query']('', '
SELECT id_profile
FROM {db_prefix}boards
WHERE id_board = {int:board_parent}
LIMIT 1',
array(
'board_parent' => (int) $boards[$board_id]['parent'],
)
);
list ($boardOptions['profile']) = $smcFunc['db_fetch_row']($request);
$smcFunc['db_free_result']($request);
$smcFunc['db_query']('', '
UPDATE {db_prefix}boards
SET id_profile = {int:new_profile}
WHERE id_board = {int:current_board}',
array(
'new_profile' => $boardOptions['profile'],
'current_board' => $board_id,
)
);
}
}
clean_cache('data');
logAction('add_board', array('board' => $board_id), 'admin');
return $board_id;
}
function deleteBoards($boards_to_remove, $moveChildrenTo = null)
{
global $sourcedir, $boards, $smcFunc;
if (empty($boards_to_remove))
return;
getBoardTree();
call_integration_hook('integrate_delete_board', array($boards_to_remove, &$moveChildrenTo));
if ($moveChildrenTo === null)
{
$child_boards_to_remove = array();
foreach ($boards_to_remove as $board_to_remove)
recursiveBoards($child_boards_to_remove, $boards[$board_to_remove]['tree']);
if (!empty($child_boards_to_remove))
$boards_to_remove = array_unique(array_merge($boards_to_remove, $child_boards_to_remove));
}
else
{
foreach ($boards_to_remove as $id_board)
{
if ($moveChildrenTo === 0)
fixChildren($id_board, 0, 0);
else
fixChildren($id_board, $boards[$moveChildrenTo]['level'] + 1, $moveChildrenTo);
}
}
$request = $smcFunc['db_query']('', '
SELECT id_topic
FROM {db_prefix}topics
WHERE id_board IN ({array_int:boards_to_remove})',
array(
'boards_to_remove' => $boards_to_remove,
)
);
$topics = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
$topics[] = $row['id_topic'];
$smcFunc['db_free_result']($request);
require_once($sourcedir . '/RemoveTopic.php');
removeTopics($topics, false);
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}log_mark_read
WHERE id_board IN ({array_int:boards_to_remove})',
array(
'boards_to_remove' => $boards_to_remove,
)
);
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}log_boards
WHERE id_board IN ({array_int:boards_to_remove})',
array(
'boards_to_remove' => $boards_to_remove,
)
);
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}log_notify
WHERE id_board IN ({array_int:boards_to_remove})',
array(
'boards_to_remove' => $boards_to_remove,
)
);
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}moderators
WHERE id_board IN ({array_int:boards_to_remove})',
array(
'boards_to_remove' => $boards_to_remove,
)
);
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}moderator_groups
WHERE id_board IN ({array_int:boards_to_remove})',
array(
'boards_to_remove' => $boards_to_remove,
)
);
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}calendar
WHERE id_board IN ({array_int:boards_to_remove})',
array(
'boards_to_remove' => $boards_to_remove,
)
);
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}message_icons
WHERE id_board IN ({array_int:boards_to_remove})',
array(
'boards_to_remove' => $boards_to_remove,
)
);
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}boards
WHERE id_board IN ({array_int:boards_to_remove})',
array(
'boards_to_remove' => $boards_to_remove,
)
);
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}board_permissions_view
WHERE id_board IN ({array_int:boards_to_remove})',
array(
'boards_to_remove' => $boards_to_remove,
)
);
updateStats('message');
updateStats('topic');
updateSettings(array(
'calendar_updated' => time(),
));
updateSettings(array('settings_updated' => time()));
clean_cache('data');
foreach ($boards_to_remove as $id_board)
logAction('delete_board', array('boardname' => $boards[$id_board]['name']), 'admin');
reorderBoards();
}
function reorderBoards()
{
global $cat_tree, $boardList, $boards, $smcFunc;
getBoardTree();
$board_order = 0;
foreach ($cat_tree as $catID => $dummy)
{
foreach ($boardList[$catID] as $boardID)
if ($boards[$boardID]['order'] != ++$board_order)
$smcFunc['db_query']('', '
UPDATE {db_prefix}boards
SET board_order = {int:new_order}
WHERE id_board = {int:selected_board}',
array(
'new_order' => $board_order,
'selected_board' => $boardID,
)
);
}
cache_put_data('board_order', null, -3600);
}
function fixChildren($parent, $newLevel, $newParent)
{
global $smcFunc;
$result = $smcFunc['db_query']('', '
SELECT id_board
FROM {db_prefix}boards
WHERE id_parent = {int:parent_board}',
array(
'parent_board' => $parent,
)
);
$children = array();
while ($row = $smcFunc['db_fetch_assoc']($result))
$children[] = $row['id_board'];
$smcFunc['db_free_result']($result);
$smcFunc['db_query']('', '
UPDATE {db_prefix}boards
SET id_parent = {int:new_parent}, child_level = {int:new_child_level}
WHERE id_parent = {int:parent_board}',
array(
'new_parent' => $newParent,
'new_child_level' => $newLevel,
'parent_board' => $parent,
)
);
foreach ($children as $child)
fixChildren($child, $newLevel + 1, $child);
}
function getTreeOrder()
{
global $smcFunc;
static $tree_order = array(
'cats' => array(),
'boards' => array(),
);
if (!empty($tree_order['boards']))
return $tree_order;
if (($cached = cache_get_data('board_order', 86400)) !== null)
{
$tree_order = $cached;
return $cached;
}
$request = $smcFunc['db_query']('', '
SELECT b.id_board, b.id_cat
FROM {db_prefix}boards AS b
ORDER BY b.board_order',
array()
);
foreach ($smcFunc['db_fetch_all']($request) as $row)
{
if (!in_array($row['id_cat'], $tree_order['cats']))
$tree_order['cats'][] = $row['id_cat'];
$tree_order['boards'][] = $row['id_board'];
}
$smcFunc['db_free_result']($request);
cache_put_data('board_order', $tree_order, 86400);
return $tree_order;
}
function sortBoards(array &$boards)
{
$tree = getTreeOrder();
$ordered = array();
foreach ($tree['boards'] as $board)
if (!empty($boards[$board]))
{
$ordered[$board] = $boards[$board];
if (is_array($ordered[$board]) && !empty($ordered[$board]['boards']))
sortBoards($ordered[$board]['boards']);
if (is_array($ordered[$board]) && !empty($ordered[$board]['children']))
sortBoards($ordered[$board]['children']);
}
$boards = $ordered;
}
function sortCategories(array &$categories)
{
$tree = getTreeOrder();
$ordered = array();
foreach ($tree['cats'] as $cat)
if (!empty($categories[$cat]))
{
$ordered[$cat] = $categories[$cat];
if (!empty($ordered[$cat]['boards']))
sortBoards($ordered[$cat]['boards']);
}
$categories = $ordered;
}
function getBoardModerators(array $boards)
{
global $smcFunc, $scripturl, $txt;
if (empty($boards))
return array();
$request = $smcFunc['db_query']('', '
SELECT mem.id_member, mem.real_name, mo.id_board
FROM {db_prefix}moderators AS mo
INNER JOIN {db_prefix}members AS mem ON (mem.id_member = mo.id_member)
WHERE mo.id_board IN ({array_int:boards})',
array(
'boards' => $boards,
)
);
$moderators = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
{
if (empty($moderators[$row['id_board']]))
$moderators[$row['id_board']] = array();
$moderators[$row['id_board']][] = array(
'id' => $row['id_member'],
'name' => $row['real_name'],
'href' => $scripturl . '?action=profile;u=' . $row['id_member'],
'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '" title="' . $txt['board_moderator'] . '">' . $row['real_name'] . '</a>',
);
}
$smcFunc['db_free_result']($request);
return $moderators;
}
function getBoardModeratorGroups(array $boards)
{
global $smcFunc, $scripturl, $txt;
if (empty($boards))
return array();
$request = $smcFunc['db_query']('', '
SELECT mg.id_group, mg.group_name, bg.id_board
FROM {db_prefix}moderator_groups AS bg
INNER JOIN {db_prefix}membergroups AS mg ON (mg.id_group = bg.id_group)
WHERE bg.id_board IN ({array_int:boards})',
array(
'boards' => $boards,
)
);
$groups = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
{
if (empty($groups[$row['id_board']]))
$groups[$row['id_board']] = array();
$groups[$row['id_board']][] = array(
'id' => $row['id_group'],
'name' => $row['group_name'],
'href' => $scripturl . '?action=groups;sa=members;group=' . $row['id_group'],
'link' => '<a href="' . $scripturl . '?action=groups;sa=members;group=' . $row['id_group'] . '" title="' . $txt['board_moderator'] . '">' . $row['group_name'] . '</a>',
);
}
return $groups;
}
function getBoardTree()
{
global $cat_tree, $boards, $boardList, $smcFunc;
$boardColumns = array(
'COALESCE(b.id_board, 0) AS id_board', 'b.id_parent', 'b.name AS board_name',
'b.description', 'b.child_level', 'b.board_order', 'b.count_posts', 'b.member_groups',
'b.id_theme', 'b.override_theme', 'b.id_profile', 'b.redirect', 'b.num_posts',
'b.num_topics', 'b.deny_member_groups', 'c.id_cat', 'c.name AS cat_name',
'c.description AS cat_desc', 'c.cat_order', 'c.can_collapse',
);
$extraBoardColumns = array();
$extraBoardParameters = array();
call_integration_hook('integrate_pre_boardtree', array(&$extraBoardColumns, &$extraBoardParameters));
$boardColumns = array_unique(array_merge($boardColumns, $extraBoardColumns));
$boardParameters = array_unique($extraBoardParameters);
$request = $smcFunc['db_query']('', '
SELECT
' . implode(', ', $boardColumns) . '
FROM {db_prefix}categories AS c
LEFT JOIN {db_prefix}boards AS b ON (b.id_cat = c.id_cat)
WHERE {query_see_board}
ORDER BY c.cat_order, b.child_level, b.board_order',
$boardParameters
);
$cat_tree = array();
$boards = array();
$last_board_order = 0;
while ($row = $smcFunc['db_fetch_assoc']($request))
{
if (!isset($cat_tree[$row['id_cat']]))
{
$cat_tree[$row['id_cat']] = array(
'node' => array(
'id' => $row['id_cat'],
'name' => $row['cat_name'],
'description' => $row['cat_desc'],
'order' => $row['cat_order'],
'can_collapse' => $row['can_collapse']
),
'is_first' => empty($cat_tree),
'last_board_order' => $last_board_order,
'children' => array()
);
$prevBoard = 0;
$curLevel = 0;
}
if (!empty($row['id_board']))
{
if ($row['child_level'] != $curLevel)
$prevBoard = 0;
$boards[$row['id_board']] = array(
'id' => $row['id_board'],
'category' => $row['id_cat'],
'parent' => $row['id_parent'],
'level' => $row['child_level'],
'order' => $row['board_order'],
'name' => $row['board_name'],
'member_groups' => explode(',', $row['member_groups']),
'deny_groups' => explode(',', $row['deny_member_groups']),
'description' => $row['description'],
'count_posts' => empty($row['count_posts']),
'posts' => $row['num_posts'],
'topics' => $row['num_topics'],
'theme' => $row['id_theme'],
'override_theme' => $row['override_theme'],
'profile' => $row['id_profile'],
'redirect' => $row['redirect'],
'prev_board' => $prevBoard
);
$prevBoard = $row['id_board'];
$last_board_order = $row['board_order'];
if (empty($row['child_level']))
{
$cat_tree[$row['id_cat']]['children'][$row['id_board']] = array(
'node' => &$boards[$row['id_board']],
'is_first' => empty($cat_tree[$row['id_cat']]['children']),
'children' => array()
);
$boards[$row['id_board']]['tree'] = &$cat_tree[$row['id_cat']]['children'][$row['id_board']];
}
else
{
if (!isset($boards[$row['id_parent']]['tree']))
fatal_lang_error('no_valid_parent', false, array($row['board_name']));
if ($boards[$row['id_parent']]['tree']['node']['level'] != $row['child_level'] - 1)
$smcFunc['db_query']('', '
UPDATE {db_prefix}boards
SET child_level = {int:new_child_level}
WHERE id_board = {int:selected_board}',
array(
'new_child_level' => $boards[$row['id_parent']]['tree']['node']['level'] + 1,
'selected_board' => $row['id_board'],
)
);
$boards[$row['id_parent']]['tree']['children'][$row['id_board']] = array(
'node' => &$boards[$row['id_board']],
'is_first' => empty($boards[$row['id_parent']]['tree']['children']),
'children' => array()
);
$boards[$row['id_board']]['tree'] = &$boards[$row['id_parent']]['tree']['children'][$row['id_board']];
}
}
call_integration_hook('integrate_boardtree_board', array($row));
}
$smcFunc['db_free_result']($request);
$boardList = array();
foreach ($cat_tree as $catID => $node)
{
$boardList[$catID] = array();
recursiveBoards($boardList[$catID], $node);
}
}
function recursiveBoards(&$_boardList, &$_tree)
{
if (empty($_tree['children']))
return;
foreach ($_tree['children'] as $id => $node)
{
$_boardList[] = $id;
recursiveBoards($_boardList, $node);
}
}
function isChildOf($child, $parent)
{
global $boards;
if (empty($boards[$child]['parent']))
return false;
if ($boards[$child]['parent'] == $parent)
return true;
return isChildOf($boards[$child]['parent'], $parent);
}
?>