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: 1542: 1543: 1544: 1545: 1546: 1547: 1548: 1549: 1550: 1551: 1552: 1553: 1554: 1555: 1556: 1557: 1558: 1559: 1560: 1561: 1562: 1563: 1564: 1565: 1566: 1567: 1568: 1569: 1570: 1571: 1572: 1573: 1574: 1575: 1576: 1577: 1578: 1579: 1580: 1581: 1582: 1583: 1584: 1585: 1586: 1587: 1588: 1589: 1590: 1591: 1592: 1593: 1594: 1595: 1596: 1597: 1598: 1599: 1600: 1601: 1602: 1603: 1604: 1605: 1606: 1607: 1608: 1609: 1610: 1611: 1612: 1613: 1614: 1615: 1616: 1617: 1618: 1619: 1620: 1621: 1622: 1623: 1624: 1625: 1626: 1627: 1628: 1629: 1630: 1631: 1632: 1633: 1634: 1635: 1636: 1637: 1638: 1639: 1640: 1641: 1642: 1643: 1644: 1645: 1646: 1647: 1648: 1649: 1650: 1651: 1652: 1653: 1654: 1655: 1656: 1657: 1658: 1659: 1660: 1661: 1662: 1663: 1664: 1665: 1666: 1667: 1668: 1669: 1670: 1671: 1672: 1673: 1674: 1675: 1676: 1677: 1678: 1679: 1680: 1681: 1682: 1683: 1684: 1685: 1686: 1687: 1688: 1689: 1690: 1691: 1692: 1693: 1694: 1695: 1696: 1697: 1698: 1699: 1700: 1701: 1702: 1703: 1704: 1705: 1706: 1707: 1708: 1709: 1710: 1711: 1712: 1713: 1714: 1715: 1716: 1717: 1718: 1719: 1720: 1721: 1722: 1723: 1724: 1725: 1726: 1727: 1728: 1729: 1730: 1731: 1732: 1733: 1734: 1735: 1736: 1737: 1738: 1739: 1740: 1741: 1742: 1743: 1744: 1745: 1746: 1747: 1748: 1749: 1750: 1751: 1752: 1753: 1754: 1755: 1756: 1757: 1758: 1759: 1760: 1761: 1762: 1763: 1764: 1765: 1766: 1767: 1768: 1769: 1770: 1771: 1772: 1773: 1774: 1775: 1776: 1777: 1778: 1779: 1780: 1781: 1782: 1783: 1784: 1785: 1786: 1787: 1788: 1789: 1790: 1791: 1792: 1793: 1794: 1795: 1796: 1797: 1798: 1799: 1800: 1801: 1802: 1803: 1804: 1805: 1806: 1807: 1808: 1809: 1810: 1811: 1812: 1813: 1814: 1815: 1816: 1817: 1818: 1819: 1820: 1821: 1822: 1823: 1824: 1825: 1826: 1827: 1828: 1829: 1830: 1831: 1832: 1833: 1834: 1835: 1836: 1837: 1838: 1839: 1840: 1841: 1842: 1843: 1844: 1845: 1846: 1847: 1848: 1849: 1850: 1851: 1852: 1853: 1854: 1855: 1856: 1857: 1858: 1859: 1860: 1861: 1862: 1863: 1864: 1865: 1866: 1867: 1868: 1869: 1870: 1871: 1872: 1873: 1874: 1875: 1876: 1877: 1878: 1879: 1880: 1881: 1882: 1883: 1884: 1885: 1886: 1887: 1888: 1889: 1890: 1891: 1892: 1893: 1894: 1895: 1896: 1897: 1898: 1899: 1900: 1901: 1902: 1903: 1904: 1905: 1906: 1907: 1908: 1909: 1910: 1911: 1912: 1913: 1914: 1915: 1916: 1917: 1918: 1919: 1920: 1921: 1922: 1923: 1924: 1925: 1926: 1927: 1928: 1929: 1930: 1931: 1932: 1933: 1934: 1935: 1936: 1937: 1938: 1939: 1940: 1941: 1942: 1943: 1944: 1945: 1946: 1947: 1948: 1949: 1950: 1951: 1952: 1953: 1954: 1955: 1956: 1957: 1958: 1959: 1960: 1961: 1962: 1963: 1964: 1965: 1966: 1967: 1968: 1969: 1970: 1971: 1972: 1973: 1974: 1975: 1976: 1977: 1978: 1979: 1980: 1981: 1982: 1983: 1984: 1985: 1986: 1987: 1988: 1989: 1990: 1991: 1992: 1993: 1994: 1995: 1996: 1997: 1998: 1999: 2000: 2001: 2002: 2003: 2004: 2005: 2006: 2007: 2008: 2009: 2010: 2011: 2012: 2013: 2014: 2015: 2016: 2017: 2018: 2019: 2020: 2021: 2022: 2023: 2024: 2025: 2026: 2027: 2028: 2029: 2030: 2031: 2032: 2033: 2034: 2035: 2036: 2037: 2038: 2039: 2040: 2041: 2042: 2043: 2044: 2045: 2046: 2047: 2048: 2049: 2050: 2051: 2052: 2053: 2054: 2055: 2056: 2057: 2058: 2059: 2060: 2061: 2062: 2063: 2064: 2065: 2066: 2067: 2068: 2069: 2070: 2071: 2072: 2073: 2074: 2075: 2076: 2077: 2078: 2079: 2080: 2081: 2082: 2083: 2084: 2085: 2086: 2087: 2088: 2089: 2090: 2091: 2092: 2093: 2094: 2095: 2096: 2097: 2098: 2099: 2100: 2101: 2102: 2103: 2104: 2105: 2106: 2107: 2108: 2109: 2110: 2111: 2112: 2113: 2114: 2115: 2116: 2117: 2118: 2119: 2120: 2121: 2122: 2123: 2124: 2125: 2126: 2127: 2128: 2129: 2130: 2131: 2132: 2133: 2134: 2135: 2136: 2137: 2138: 2139: 2140: 2141: 2142: 2143: 2144: 2145: 2146: 2147: 2148: 2149: 2150: 2151: 2152: 2153: 2154: 2155: 2156: 2157: 2158: 2159: 2160: 2161: 2162: 2163: 2164: 2165: 2166: 2167: 2168: 2169: 2170: 2171: 2172: 2173: 2174: 2175: 2176: 2177: 2178: 2179: 2180: 2181: 2182: 2183: 2184: 2185: 2186: 2187: 2188: 2189: 2190: 2191: 2192: 2193: 2194: 2195: 2196: 2197: 2198: 2199: 2200: 2201: 2202: 2203: 2204: 2205: 2206: 2207: 2208: 2209: 2210: 2211: 2212: 2213: 2214: 2215: 2216: 2217: 2218: 2219: 2220: 2221: 2222: 2223: 2224: 2225: 2226: 2227: 2228: 2229: 2230: 2231: 2232: 2233: 2234: 2235: 2236: 2237: 2238: 2239: 2240: 2241: 2242: 2243: 2244: 2245: 2246: 2247: 2248: 2249: 2250: 2251: 2252: 2253: 2254: 2255: 2256: 2257: 2258: 2259: 2260: 2261: 2262: 2263: 2264: 2265: 2266: 2267: 2268: 2269: 2270: 2271: 2272: 2273: 2274: 2275: 2276: 2277: 2278: 2279: 2280: 2281: 2282: 2283: 2284: 2285: 2286: 2287: 2288: 2289: 2290: 2291: 2292: 2293: 2294: 2295: 2296: 2297: 2298: 2299: 2300: 2301: 2302: 2303: 2304: 2305: 2306: 2307: 2308: 2309: 2310: 2311: 2312: 2313: 2314: 2315: 2316: 2317: 2318: 2319: 2320: 2321: 2322: 2323: 2324: 2325: 2326: 2327: 2328: 2329: 2330: 2331: 2332: 2333: 2334: 2335: 2336: 2337: 2338: 2339: 2340: 2341: 2342: 2343: 2344: 2345: 2346: 2347: 2348: 2349: 2350: 2351: 2352: 2353: 2354: 2355: 2356: 2357: 2358: 2359: 2360: 2361: 2362: 2363: 2364: 2365: 2366: 2367: 2368: 2369: 2370: 2371: 2372: 2373: 2374: 2375: 2376: 2377: 2378: 2379: 2380: 2381: 2382: 2383: 2384: 2385: 2386: 2387: 2388: 2389: 2390: 2391: 2392: 2393: 2394: 2395: 2396: 2397: 2398: 2399: 2400: 2401: 2402: 2403: 2404: 2405: 2406: 2407: 2408: 2409: 2410: 2411: 2412: 2413: 2414: 2415: 2416: 2417: 2418: 2419: 2420: 2421: 2422: 2423: 2424: 2425: 2426: 2427: 2428: 2429: 2430: 2431: 2432: 2433: 2434: 2435: 2436: 2437: 2438: 2439: 2440: 2441: 2442: 2443: 2444: 2445: 2446: 2447: 2448: 2449: 2450: 2451: 2452: 2453: 2454: 2455: 2456: 2457: 2458: 2459: 2460: 2461: 2462: 2463: 2464: 2465: 2466: 2467: 2468: 2469: 2470: 2471: 2472: 2473: 2474: 2475: 2476: 2477: 2478: 2479: 2480: 2481: 2482: 2483: 2484: 2485: 2486: 2487: 2488: 2489: 2490: 2491: 2492: 2493: 2494: 2495: 2496: 2497: 2498: 2499: 2500: 2501: 2502: 2503: 2504: 2505: 2506: 2507: 2508: 2509: 2510: 2511: 2512: 2513: 2514: 2515: 2516: 2517: 2518: 2519: 2520: 2521: 2522: 2523: 2524: 2525: 2526: 2527: 2528: 2529: 2530: 2531: 2532: 2533: 2534:
<?php
define('SMF_VERSION', '2.1 RC2');
define('SMF_FULL_VERSION', 'SMF ' . SMF_VERSION);
define('SMF_SOFTWARE_YEAR', '2020');
define('DB_SCRIPT_VERSION', '2-1');
define('SMF_INSTALLING', 1);
define('JQUERY_VERSION', '3.4.1');
define('POSTGRE_TITLE', 'PostgreSQL');
define('MYSQL_TITLE', 'MySQL');
define('SMF_USER_AGENT', 'Mozilla/5.0 (' . php_uname('s') . ' ' . php_uname('m') . ') AppleWebKit/605.1.15 (KHTML, like Gecko) SMF/' . strtr(SMF_VERSION, ' ', '.'));
if (!defined('TIME_START'))
define('TIME_START', microtime(true));
$GLOBALS['required_php_version'] = '5.4.0';
if (!defined('SMF'))
define('SMF', 1);
require_once('Sources/Class-Package.php');
$databases = array(
'mysql' => array(
'name' => 'MySQL',
'version' => '5.0.22',
'version_check' => 'return min(mysqli_get_server_info($db_connection), mysqli_get_client_info());',
'supported' => function_exists('mysqli_connect'),
'default_user' => 'mysql.default_user',
'default_password' => 'mysql.default_password',
'default_host' => 'mysql.default_host',
'default_port' => 'mysql.default_port',
'utf8_support' => function()
{
return true;
},
'utf8_version' => '5.0.22',
'utf8_version_check' => 'return mysqli_get_server_info($db_connection);',
'utf8_default' => true,
'utf8_required' => true,
'alter_support' => true,
'validate_prefix' => function(&$value)
{
$value = preg_replace('~[^A-Za-z0-9_\$]~', '', $value);
return true;
},
),
'postgresql' => array(
'name' => 'PostgreSQL',
'version' => '9.4',
'function_check' => 'pg_connect',
'version_check' => '$request = pg_query(\'SELECT version()\'); list ($version) = pg_fetch_row($request); list($pgl, $version) = explode(" ", $version); return $version;',
'supported' => function_exists('pg_connect'),
'always_has_db' => true,
'utf8_default' => true,
'utf8_required' => true,
'utf8_support' => function()
{
$request = pg_query('SHOW SERVER_ENCODING');
list ($charcode) = pg_fetch_row($request);
if ($charcode == 'UTF8')
return true;
else
return false;
},
'utf8_version' => '8.0',
'utf8_version_check' => '$request = pg_query(\'SELECT version()\'); list ($version) = pg_fetch_row($request); list($pgl, $version) = explode(" ", $version); return $version;',
'validate_prefix' => function(&$value)
{
global $txt;
$value = preg_replace('~[^A-Za-z0-9_\$]~', '', $value);
if ($value == 'pg_')
return $txt['error_db_prefix_reserved'];
if (preg_match('~^\d~', $value))
return $txt['error_db_prefix_numeric'];
return true;
},
),
);
global $txt;
initialize_inputs();
load_lang_file();
$installurl = $_SERVER['PHP_SELF'];
$incontext['steps'] = array(
0 => array(1, $txt['install_step_welcome'], 'Welcome', 0),
1 => array(2, $txt['install_step_writable'], 'CheckFilesWritable', 10),
2 => array(3, $txt['install_step_databaseset'], 'DatabaseSettings', 15),
3 => array(4, $txt['install_step_forum'], 'ForumSettings', 40),
4 => array(5, $txt['install_step_databasechange'], 'DatabasePopulation', 15),
5 => array(6, $txt['install_step_admin'], 'AdminAccount', 20),
6 => array(7, $txt['install_step_delete'], 'DeleteInstall', 0),
);
$incontext['page_title'] = $txt['smf_installer'];
$incontext['current_step'] = isset($_GET['step']) ? (int) $_GET['step'] : 0;
$incontext['overall_percent'] = 0;
foreach ($incontext['steps'] as $num => $step)
{
if ($num >= $incontext['current_step'])
{
$incontext['step_weight'] = $step[3];
$incontext['skip'] = false;
if (function_exists($step[2]) && $step[2]() === false)
break;
elseif (function_exists($step[2]))
$incontext['current_step']++;
$incontext['warning'] = '';
}
$incontext['overall_percent'] += $step[3];
}
installExit();
function initialize_inputs()
{
global $databases;
if (!isset($_SERVER['PHP_SELF']))
$_SERVER['PHP_SELF'] = isset($GLOBALS['HTTP_SERVER_VARS']['PHP_SELF']) ? $GLOBALS['HTTP_SERVER_VARS']['PHP_SELF'] : 'install.php';
error_reporting(E_ERROR | E_PARSE);
if (!isset($_GET))
{
$GLOBALS['_GET']['step'] = 0;
return;
}
if (!isset($_GET['obgz']))
{
ob_start();
if (ini_get('session.save_handler') == 'user')
@ini_set('session.save_handler', 'files');
if (function_exists('session_start'))
@session_start();
}
else
{
ob_start('ob_gzhandler');
if (ini_get('session.save_handler') == 'user')
@ini_set('session.save_handler', 'files');
session_start();
if (!headers_sent())
echo '<!DOCTYPE html>
<html>
<head>
<title>', htmlspecialchars($_GET['pass_string']), '</title>
</head>
<body style="background-color: #d4d4d4; margin-top: 16%; text-align: center; font-size: 16pt;">
<strong>', htmlspecialchars($_GET['pass_string']), '</strong>
</body>
</html>';
exit;
}
if (isset($_GET['delete']))
{
if (isset($_SESSION['installer_temp_ftp']))
{
$ftp = new ftp_connection($_SESSION['installer_temp_ftp']['server'], $_SESSION['installer_temp_ftp']['port'], $_SESSION['installer_temp_ftp']['username'], $_SESSION['installer_temp_ftp']['password']);
$ftp->chdir($_SESSION['installer_temp_ftp']['path']);
$ftp->unlink('install.php');
foreach ($databases as $key => $dummy)
{
$type = ($key == 'mysqli') ? 'mysql' : $key;
$ftp->unlink('install_' . DB_SCRIPT_VERSION . '_' . $type . '.sql');
}
$ftp->close();
unset($_SESSION['installer_temp_ftp']);
}
else
{
@unlink(__FILE__);
foreach ($databases as $key => $dummy)
{
$type = ($key == 'mysqli') ? 'mysql' : $key;
@unlink(dirname(__FILE__) . '/install_' . DB_SCRIPT_VERSION . '_' . $type . '.sql');
}
}
$secure = false;
if (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on')
$secure = true;
elseif (!empty($_SERVER['HTTP_X_FORWARDED_PROTO']) && $_SERVER['HTTP_X_FORWARDED_PROTO'] == 'https' || !empty($_SERVER['HTTP_X_FORWARDED_SSL']) && $_SERVER['HTTP_X_FORWARDED_SSL'] == 'on')
$secure = true;
header('location: http' . ($secure ? 's' : '') . '://' . (isset($_SERVER['HTTP_HOST']) ? $_SERVER['HTTP_HOST'] : $_SERVER['SERVER_NAME'] . ':' . $_SERVER['SERVER_PORT']) . dirname($_SERVER['PHP_SELF']) . '/Themes/default/images/blank.png');
exit;
}
if (function_exists('date_default_timezone_set'))
{
$ini_tz = ini_get('date.timezone');
if (!empty($ini_tz))
$timezone_id = $ini_tz;
else
$timezone_id = '';
if (!in_array($timezone_id, timezone_identifiers_list()))
{
$server_offset = @mktime(0, 0, 0, 1, 1, 1970);
$timezone_id = timezone_name_from_abbr('', $server_offset, 0);
}
date_default_timezone_set($timezone_id);
}
$_GET['step'] = (int) @$_GET['step'];
}
function load_lang_file()
{
global $incontext, $user_info, $txt;
$incontext['detected_languages'] = array();
if (file_exists(dirname(__FILE__) . '/Themes/default/languages'))
{
$dir = dir(dirname(__FILE__) . '/Themes/default/languages');
while ($entry = $dir->read())
{
if (substr($entry, 0, 8) == 'Install.' && substr($entry, -4) == '.php')
$incontext['detected_languages'][$entry] = ucfirst(substr($entry, 8, strlen($entry) - 12));
}
$dir->close();
}
if (empty($incontext['detected_languages']))
{
header('expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('last-modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');
header('cache-control: no-cache');
echo '<!DOCTYPE html>
<html>
<head>
<title>SMF Installer: Error!</title>
<style>
body {
font-family: sans-serif;
max-width: 700px; }
h1 {
font-size: 14pt; }
.directory {
margin: 0.3em;
font-family: monospace;
font-weight: bold; }
</style>
</head>
<body>
<h1>A critical error has occurred.</h1>
<p>This installer was unable to find the installer\'s language file or files. They should be found under:</p>
<div class="directory">', dirname($_SERVER['PHP_SELF']) != '/' ? dirname($_SERVER['PHP_SELF']) : '', '/Themes/default/languages</div>
<p>In some cases, FTP clients do not properly upload files with this many folders. Please double check to make sure you <strong>have uploaded all the files in the distribution</strong>.</p>
<p>If that doesn\'t help, please make sure this install.php file is in the same place as the Themes folder.</p>
<p>If you continue to get this error message, feel free to <a href="https://support.simplemachines.org/">look to us for support</a>.</p>
</div></body>
</html>';
die;
}
if (isset($_GET['lang_file']))
$_SESSION['installer_temp_lang'] = $_GET['lang_file'];
elseif (isset($GLOBALS['HTTP_GET_VARS']['lang_file']))
$_SESSION['installer_temp_lang'] = $GLOBALS['HTTP_GET_VARS']['lang_file'];
if (!isset($_SESSION['installer_temp_lang']) || preg_match('~[^\\w_\\-.]~', $_SESSION['installer_temp_lang']) === 1 || !file_exists(dirname(__FILE__) . '/Themes/default/languages/' . $_SESSION['installer_temp_lang']))
{
list ($_SESSION['installer_temp_lang']) = array_keys($incontext['detected_languages']);
if ($_SESSION['installer_temp_lang'] == 'Install.english.php' && count($incontext['detected_languages']) > 1)
list (, $_SESSION['installer_temp_lang']) = array_keys($incontext['detected_languages']);
}
require_once(dirname(__FILE__) . '/Themes/default/languages/' . $_SESSION['installer_temp_lang']);
preg_match('~^Install\.(.+[^-utf8])\.php$~', $_SESSION['installer_temp_lang'], $matches);
$user_info['language'] = $matches[1];
}
function load_database()
{
global $db_prefix, $db_connection, $sourcedir, $smcFunc, $modSettings, $db_port;
global $db_server, $db_passwd, $db_type, $db_name, $db_user, $db_persist, $db_mb4;
if (empty($sourcedir))
$sourcedir = dirname(__FILE__) . '/Sources';
require(dirname(__FILE__) . '/Settings.php');
if (!defined('SMF'))
define('SMF', 1);
if (empty($smcFunc))
$smcFunc = array();
$modSettings['disableQueryCheck'] = true;
if (!$db_connection)
{
require_once($sourcedir . '/Subs-Db-' . $db_type . '.php');
$options = array('persist' => $db_persist);
if (!empty($db_port))
$options['port'] = $db_port;
if (!empty($db_mb4))
$options['db_mb4'] = $db_mb4;
if (!$db_connection)
$db_connection = smf_db_initiate($db_server, $db_name, $db_user, $db_passwd, $db_prefix, $options);
}
}
function installExit($fallThrough = false)
{
global $incontext, $installurl, $txt;
header('content-type: text/html; charset=' . (isset($txt['lang_character_set']) ? $txt['lang_character_set'] : 'UTF-8'));
if (!$fallThrough)
{
template_install_above();
if (isset($incontext['sub_template']))
{
$incontext['form_url'] = $installurl . '?step=' . $incontext['current_step'];
call_user_func('template_' . $incontext['sub_template']);
}
else
{
if (function_exists('doStep' . $_GET['step']))
call_user_func('doStep' . $_GET['step']);
}
template_install_below();
}
die();
}
function Welcome()
{
global $incontext, $txt, $databases, $installurl;
$incontext['page_title'] = $txt['install_welcome'];
$incontext['sub_template'] = 'welcome_message';
if (isset($_POST['contbutt']))
return true;
if (is_readable(dirname(__FILE__) . '/Settings.php'))
{
$probably_installed = 0;
foreach (file(dirname(__FILE__) . '/Settings.php') as $line)
{
if (preg_match('~^\$db_passwd\s=\s\'([^\']+)\';$~', $line))
$probably_installed++;
if (preg_match('~^\$boardurl\s=\s\'([^\']+)\';~', $line) && !preg_match('~^\$boardurl\s=\s\'http://127\.0\.0\.1/smf\';~', $line))
$probably_installed++;
}
if ($probably_installed == 2)
$incontext['warning'] = $txt['error_already_installed'];
}
$incontext['supported_databases'] = array();
foreach ($databases as $key => $db)
{
if ($db['supported'])
{
$type = ($key == 'mysqli') ? 'mysql' : $key;
if (!file_exists(dirname(__FILE__) . '/install_' . DB_SCRIPT_VERSION . '_' . $type . '.sql'))
{
$databases[$key]['supported'] = false;
$notFoundSQLFile = true;
$txt['error_db_script_missing'] = sprintf($txt['error_db_script_missing'], 'install_' . DB_SCRIPT_VERSION . '_' . $type . '.sql');
}
else
$incontext['supported_databases'][] = $db;
}
}
if ((!function_exists('version_compare') || version_compare($GLOBALS['required_php_version'], PHP_VERSION, '>=')))
$error = 'error_php_too_low';
elseif (empty($incontext['supported_databases']))
$error = empty($notFoundSQLFile) ? 'error_db_missing' : 'error_db_script_missing';
elseif (!function_exists('session_start'))
$error = 'error_session_missing';
elseif (!file_exists(dirname(__FILE__) . '/index.php'))
$error = 'error_missing_files';
elseif (@ini_get('session.save_path') == '/tmp' && substr(__FILE__, 1, 2) == ':\\')
$error = 'error_session_save_path';
if (isset($error))
$incontext['error'] = $txt[$error];
if (!fixModSecurity() && !isset($_GET['overmodsecurity']))
$incontext['error'] = $txt['error_mod_security'] . '<br><br><a href="' . $installurl . '?overmodsecurity=true">' . $txt['error_message_click'] . '</a> ' . $txt['error_message_bad_try_again'];
if (!extension_loaded('mbstring'))
$incontext['error'] = $txt['install_no_mbstring'];
$supported_streams = stream_get_wrappers();
if (!in_array('https', $supported_streams))
$incontext['warning'] = $txt['install_no_https'];
return false;
}
function CheckFilesWritable()
{
global $txt, $incontext;
$incontext['page_title'] = $txt['ftp_checking_writable'];
$incontext['sub_template'] = 'chmod_files';
$writable_files = array(
'attachments',
'avatars',
'custom_avatar',
'cache',
'Packages',
'Smileys',
'Themes',
'agreement.txt',
'Settings.php',
'Settings_bak.php',
'cache/db_last_error.php',
);
foreach ($incontext['detected_languages'] as $lang => $temp)
$extra_files[] = 'Themes/default/languages/' . $lang;
if (function_exists('apache_get_modules') && in_array('mod_security', apache_get_modules()))
$writable_files[] = file_exists(dirname(__FILE__) . '/.htaccess') ? '.htaccess' : '.';
$failed_files = array();
if (substr(__FILE__, 1, 2) != ':\\')
{
$incontext['systemos'] = 'linux';
foreach ($writable_files as $file)
{
if (!file_exists(dirname(__FILE__) . '/' . $file))
@touch(dirname(__FILE__) . '/' . $file);
if (!is_writable(dirname(__FILE__) . '/' . $file))
{
@chmod(dirname(__FILE__) . '/' . $file, 0755);
if (!is_writable(dirname(__FILE__) . '/' . $file) && !@chmod(dirname(__FILE__) . '/' . $file, 0777))
$failed_files[] = $file;
}
}
foreach ($extra_files as $file)
@chmod(dirname(__FILE__) . (empty($file) ? '' : '/' . $file), 0777);
}
else
{
$incontext['systemos'] = 'windows';
foreach ($writable_files as $file)
{
if (is_dir(dirname(__FILE__) . '/' . $file))
$file .= '/index.php';
@chmod(dirname(__FILE__) . '/' . $file, 0777);
$fp = @fopen(dirname(__FILE__) . '/' . $file, 'r+');
if (!is_resource($fp))
$fp = @fopen(dirname(__FILE__) . '/' . $file, 'w');
if (!is_resource($fp))
$failed_files[] = $file;
@fclose($fp);
}
foreach ($extra_files as $file)
@chmod(dirname(__FILE__) . (empty($file) ? '' : '/' . $file), 0777);
}
$failure = count($failed_files) >= 1;
if (!isset($_SERVER))
return !$failure;
$incontext['failed_files'] = $failed_files;
if ($failure && substr(__FILE__, 1, 2) == ':\\')
{
$incontext['error'] = $txt['error_windows_chmod'] . '
<ul class="error_content">
<li>' . implode('</li>
<li>', $failed_files) . '</li>
</ul>';
return false;
}
elseif ($failure)
{
if (!isset($_POST['ftp_username']) && isset($_SESSION['installer_temp_ftp']))
{
$_POST['ftp_server'] = $_SESSION['installer_temp_ftp']['server'];
$_POST['ftp_port'] = $_SESSION['installer_temp_ftp']['port'];
$_POST['ftp_username'] = $_SESSION['installer_temp_ftp']['username'];
$_POST['ftp_password'] = $_SESSION['installer_temp_ftp']['password'];
$_POST['ftp_path'] = $_SESSION['installer_temp_ftp']['path'];
}
$incontext['ftp_errors'] = array();
require_once('Sources/Class-Package.php');
if (isset($_POST['ftp_username']))
{
$ftp = new ftp_connection($_POST['ftp_server'], $_POST['ftp_port'], $_POST['ftp_username'], $_POST['ftp_password']);
if ($ftp->error === false)
{
if (!$ftp->chdir($_POST['ftp_path']))
{
$incontext['ftp_errors'][] = $ftp->last_message;
$ftp->chdir(preg_replace('~^/home[2]?/[^/]+?~', '', $_POST['ftp_path']));
}
}
}
if (!isset($ftp) || $ftp->error !== false)
{
if (!isset($ftp))
$ftp = new ftp_connection(null);
elseif ($ftp->error !== false && empty($incontext['ftp_errors']) && !empty($ftp->last_message))
$incontext['ftp_errors'][] = $ftp->last_message;
list ($username, $detect_path, $found_path) = $ftp->detect_path(dirname(__FILE__));
if (empty($_POST['ftp_path']) && $found_path)
$_POST['ftp_path'] = $detect_path;
if (!isset($_POST['ftp_username']))
$_POST['ftp_username'] = $username;
$incontext['ftp'] = array(
'server' => isset($_POST['ftp_server']) ? $_POST['ftp_server'] : 'localhost',
'port' => isset($_POST['ftp_port']) ? $_POST['ftp_port'] : '21',
'username' => isset($_POST['ftp_username']) ? $_POST['ftp_username'] : '',
'path' => isset($_POST['ftp_path']) ? $_POST['ftp_path'] : '/',
'path_msg' => !empty($found_path) ? $txt['ftp_path_found_info'] : $txt['ftp_path_info'],
);
return false;
}
else
{
$_SESSION['installer_temp_ftp'] = array(
'server' => $_POST['ftp_server'],
'port' => $_POST['ftp_port'],
'username' => $_POST['ftp_username'],
'password' => $_POST['ftp_password'],
'path' => $_POST['ftp_path']
);
$failed_files_updated = array();
foreach ($failed_files as $file)
{
if (!is_writable(dirname(__FILE__) . '/' . $file))
$ftp->chmod($file, 0755);
if (!is_writable(dirname(__FILE__) . '/' . $file))
$ftp->chmod($file, 0777);
if (!is_writable(dirname(__FILE__) . '/' . $file))
{
$failed_files_updated[] = $file;
$incontext['ftp_errors'][] = rtrim($ftp->last_message) . ' -> ' . $file . "\n";
}
}
$ftp->close();
if (count($failed_files_updated) >= 1)
{
$incontext['failed_files'] = $failed_files_updated;
$incontext['ftp'] = $_SESSION['installer_temp_ftp'] += array(
'path_msg' => $txt['ftp_path_info'],
);
return false;
}
}
}
return true;
}
function DatabaseSettings()
{
global $txt, $databases, $incontext, $smcFunc, $sourcedir;
global $db_server, $db_name, $db_user, $db_passwd, $db_port, $db_mb4;
$incontext['sub_template'] = 'database_settings';
$incontext['page_title'] = $txt['db_settings'];
$incontext['continue'] = 1;
$incontext['db']['server'] = 'localhost';
$incontext['db']['user'] = '';
$incontext['db']['name'] = '';
$incontext['db']['pass'] = '';
$incontext['db']['type'] = '';
$incontext['supported_databases'] = array();
$foundOne = false;
foreach ($databases as $key => $db)
{
if ($db['supported'])
{
$incontext['supported_databases'][$key] = $db;
if (!$foundOne)
{
if (isset($db['default_host']))
$incontext['db']['server'] = ini_get($db['default_host']) or $incontext['db']['server'] = 'localhost';
if (isset($db['default_user']))
{
$incontext['db']['user'] = ini_get($db['default_user']);
$incontext['db']['name'] = ini_get($db['default_user']);
}
if (isset($db['default_password']))
$incontext['db']['pass'] = ini_get($db['default_password']);
$incontext['db']['port'] = '';
$incontext['db']['type'] = $key;
$foundOne = true;
}
}
}
if (isset($_POST['db_user']))
{
$incontext['db']['user'] = $_POST['db_user'];
$incontext['db']['name'] = $_POST['db_name'];
$incontext['db']['server'] = $_POST['db_server'];
$incontext['db']['prefix'] = $_POST['db_prefix'];
if (!empty($_POST['db_port']))
$incontext['db']['port'] = $_POST['db_port'];
}
else
{
$incontext['db']['prefix'] = 'smf_';
}
if (isset($_POST['db_type']))
{
$db_type = preg_replace('~[^A-Za-z0-9]~', '', $_POST['db_type']);
$db_prefix = $_POST['db_prefix'];
$valid_prefix = $databases[$db_type]['validate_prefix']($db_prefix);
if ($valid_prefix !== true)
{
$incontext['error'] = $valid_prefix;
return false;
}
$vars = array(
'db_type' => $db_type,
'db_name' => $_POST['db_name'],
'db_user' => $_POST['db_user'],
'db_passwd' => isset($_POST['db_passwd']) ? $_POST['db_passwd'] : '',
'db_server' => $_POST['db_server'],
'db_prefix' => $db_prefix,
'cookiename' => 'SMFCookie' . abs(crc32($_POST['db_name'] . preg_replace('~[^A-Za-z0-9_$]~', '', $_POST['db_prefix'])) % 1000),
);
if (!empty($_POST['db_port']))
{
if (($db_type == 'mysql' || $db_type == 'mysqli') && $_POST['db_port'] != ini_get($db_type . '.default_port'))
$vars['db_port'] = (int) $_POST['db_port'];
elseif ($db_type == 'postgresql' && $_POST['db_port'] != 5432)
$vars['db_port'] = (int) $_POST['db_port'];
}
if (!installer_updateSettingsFile($vars))
{
$incontext['error'] = $txt['settings_error'];
return false;
}
require(dirname(__FILE__) . '/Settings.php');
if (empty($sourcedir))
$sourcedir = dirname(__FILE__) . '/Sources';
if (!file_exists($sourcedir . '/Subs-Db-' . $db_type . '.php'))
{
$incontext['error'] = sprintf($txt['error_db_file'], 'Subs-Db-' . $db_type . '.php');
return false;
}
if (!defined('SMF'))
define('SMF', 1);
$modSettings['disableQueryCheck'] = true;
if (empty($smcFunc))
$smcFunc = array();
require_once($sourcedir . '/Subs-Db-' . $db_type . '.php');
$needsDB = !empty($databases[$db_type]['always_has_db']);
$options = array('non_fatal' => true, 'dont_select_db' => !$needsDB);
if (!empty($db_port))
$options['port'] = $db_port;
if (!empty($db_mb4))
$options['db_mb4'] = $db_mb4;
$db_connection = smf_db_initiate($db_server, $db_name, $db_user, $db_passwd, $db_prefix, $options);
if ($db_connection == null)
{
$db_error = @$smcFunc['db_error']();
$db_connection = smf_db_initiate($db_server, $db_name, $_POST['db_prefix'] . $db_user, $db_passwd, $db_prefix, $options);
if ($db_connection != null)
{
$db_user = $_POST['db_prefix'] . $db_user;
installer_updateSettingsFile(array('db_user' => $db_user));
}
}
if (!$db_connection)
{
$incontext['error'] = $txt['error_db_connect'] . '<div class="error_content"><strong>' . $db_error . '</strong></div>';
return false;
}
if (version_compare($databases[$db_type]['version'], preg_replace('~^\D*|\-.+?$~', '', eval($databases[$db_type]['version_check']))) > 0)
{
$incontext['error'] = $txt['error_db_too_low'];
return false;
}
if ($db_name != '' && !$needsDB)
{
$smcFunc['db_query']('', "
CREATE DATABASE IF NOT EXISTS `$db_name`",
array(
'security_override' => true,
'db_error_skip' => true,
),
$db_connection
);
if (!$smcFunc['db_select_db']($db_name, $db_connection) && $db_name != '')
{
$smcFunc['db_query']('', "
CREATE DATABASE IF NOT EXISTS `$_POST[db_prefix]$db_name`",
array(
'security_override' => true,
'db_error_skip' => true,
),
$db_connection
);
if ($smcFunc['db_select_db']($_POST['db_prefix'] . $db_name, $db_connection))
{
$db_name = $_POST['db_prefix'] . $db_name;
installer_updateSettingsFile(array('db_name' => $db_name));
}
}
if (!$smcFunc['db_select_db']($db_name, $db_connection))
{
$incontext['error'] = sprintf($txt['error_db_database'], $db_name);
return false;
}
}
return true;
}
return false;
}
function ForumSettings()
{
global $txt, $incontext, $databases, $db_type, $db_connection, $smcFunc;
$incontext['sub_template'] = 'forum_settings';
$incontext['page_title'] = $txt['install_settings'];
if (isset($_POST['db_type'], $databases[$_POST['db_type']]))
$db_type = $_POST['db_type'];
else
load_database();
$db_type = isset($_POST['db_type']) ? $_POST['db_type'] : $db_type;
$host = empty($_SERVER['HTTP_HOST']) ? $_SERVER['SERVER_NAME'] . (empty($_SERVER['SERVER_PORT']) || $_SERVER['SERVER_PORT'] == '80' ? '' : ':' . $_SERVER['SERVER_PORT']) : $_SERVER['HTTP_HOST'];
$secure = false;
if (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on')
$secure = true;
elseif (!empty($_SERVER['HTTP_X_FORWARDED_PROTO']) && $_SERVER['HTTP_X_FORWARDED_PROTO'] == 'https' || !empty($_SERVER['HTTP_X_FORWARDED_SSL']) && $_SERVER['HTTP_X_FORWARDED_SSL'] == 'on')
$secure = true;
$incontext['detected_url'] = 'http' . ($secure ? 's' : '') . '://' . $host . substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['PHP_SELF'], '/'));
$incontext['test_dbsession'] = (ini_get('session.auto_start') != 1);
$incontext['utf8_default'] = $databases[$db_type]['utf8_default'];
$incontext['utf8_required'] = $databases[$db_type]['utf8_required'];
$incontext['continue'] = 1;
if ( $db_type === 'postgresql')
{
load_database();
$result = $smcFunc['db_query']('', '
show standard_conforming_strings',
array(
'db_error_skip' => true,
)
);
if ($result !== false)
{
$row = $smcFunc['db_fetch_assoc']($result);
if ($row['standard_conforming_strings'] !== 'on')
{
$incontext['continue'] = 0;
$incontext['error'] = $txt['error_pg_scs'];
}
$smcFunc['db_free_result']($result);
}
}
$incontext['ssl_chkbx_protected'] = false;
$incontext['ssl_chkbx_checked'] = false;
require_once(dirname(__FILE__) . '/Sources/Subs.php');
if (https_redirect_active($incontext['detected_url']))
{
$incontext['ssl_chkbx_protected'] = true;
$incontext['ssl_chkbx_checked'] = true;
$_POST['force_ssl'] = true;
}
if (!ssl_cert_found($incontext['detected_url']))
{
$incontext['ssl_chkbx_protected'] = true;
$incontext['ssl_chkbx_checked'] = false;
}
if (isset($_POST['boardurl']))
{
if (substr($_POST['boardurl'], -10) == '/index.php')
$_POST['boardurl'] = substr($_POST['boardurl'], 0, -10);
elseif (substr($_POST['boardurl'], -1) == '/')
$_POST['boardurl'] = substr($_POST['boardurl'], 0, -1);
if (substr($_POST['boardurl'], 0, 7) != 'http://' && substr($_POST['boardurl'], 0, 7) != 'file://' && substr($_POST['boardurl'], 0, 8) != 'https://')
$_POST['boardurl'] = 'http://' . $_POST['boardurl'];
if (empty($_POST['force_ssl']))
$_POST['boardurl'] = strtr($_POST['boardurl'], array('https://' => 'http://'));
else
$_POST['boardurl'] = strtr($_POST['boardurl'], array('http://' => 'https://'));
$path = rtrim(str_replace(DIRECTORY_SEPARATOR, '/', __DIR__), '/');
$vars = array(
'boardurl' => $_POST['boardurl'],
'boarddir' => $path,
'sourcedir' => $path . '/Sources',
'cachedir' => $path . '/cache',
'packagesdir' => $path . '/Packages',
'tasksdir' => $path . '/Sources/tasks',
'mbname' => strtr($_POST['mbname'], array('\"' => '"')),
'language' => substr($_SESSION['installer_temp_lang'], 8, -4),
'image_proxy_secret' => substr(sha1(mt_rand()), 0, 20),
'image_proxy_enabled' => !empty($_POST['force_ssl']),
);
if (!installer_updateSettingsFile($vars))
{
$incontext['error'] = $txt['settings_error'];
return false;
}
require(dirname(__FILE__) . '/Settings.php');
if ((!empty($databases[$db_type]['utf8_support']) && !empty($databases[$db_type]['utf8_required'])) || (empty($databases[$db_type]['utf8_required']) && !empty($databases[$db_type]['utf8_support']) && isset($_POST['utf8'])))
{
if (!$databases[$db_type]['utf8_support']())
{
$incontext['error'] = sprintf($txt['error_utf8_support']);
return false;
}
if (!empty($databases[$db_type]['utf8_version_check']) && version_compare($databases[$db_type]['utf8_version'], preg_replace('~\-.+?$~', '', eval($databases[$db_type]['utf8_version_check'])), '>'))
{
$incontext['error'] = sprintf($txt['error_utf8_version'], $databases[$db_type]['utf8_version']);
return false;
}
else
installer_updateSettingsFile(array('db_character_set' => 'utf8'));
}
return true;
}
return false;
}
function DatabasePopulation()
{
global $db_character_set, $txt, $db_connection, $smcFunc, $databases, $modSettings, $db_type, $db_prefix, $incontext, $db_name, $boardurl;
$incontext['sub_template'] = 'populate_database';
$incontext['page_title'] = $txt['db_populate'];
$incontext['continue'] = 1;
if (isset($_POST['pop_done']))
return true;
require(dirname(__FILE__) . '/Settings.php');
load_database();
$result = $smcFunc['db_query']('', '
SELECT variable, value
FROM {db_prefix}settings',
array(
'db_error_skip' => true,
)
);
$newSettings = array();
$modSettings = array();
if ($result !== false)
{
while ($row = $smcFunc['db_fetch_assoc']($result))
$modSettings[$row['variable']] = $row['value'];
$smcFunc['db_free_result']($result);
if (!isset($modSettings['smfVersion']) || $modSettings['smfVersion'] != SMF_VERSION)
{
$incontext['error'] = $txt['error_versions_do_not_match'];
return false;
}
}
$modSettings['disableQueryCheck'] = true;
if (!empty($db_character_set) && $db_character_set == 'utf8' && !empty($databases[$db_type]['utf8_support']))
$smcFunc['db_query']('', '
SET NAMES {string:utf8}',
array(
'db_error_skip' => true,
'utf8' => 'utf8',
)
);
if (substr(__DIR__, -1) == '\\')
$attachdir = __DIR__ . 'attachments';
else
$attachdir = __DIR__ . '/attachments';
$replaces = array(
'{$db_prefix}' => $db_prefix,
'{$attachdir}' => json_encode(array(1 => $smcFunc['db_escape_string']($attachdir))),
'{$boarddir}' => $smcFunc['db_escape_string'](dirname(__FILE__)),
'{$boardurl}' => $boardurl,
'{$enableCompressedOutput}' => isset($_POST['compress']) ? '1' : '0',
'{$databaseSession_enable}' => isset($_POST['dbsession']) ? '1' : '0',
'{$smf_version}' => SMF_VERSION,
'{$current_time}' => time(),
'{$sched_task_offset}' => 82800 + mt_rand(0, 86399),
'{$registration_method}' => isset($_POST['reg_mode']) ? $_POST['reg_mode'] : 0,
);
foreach ($txt as $key => $value)
{
if (substr($key, 0, 8) == 'default_')
$replaces['{$' . $key . '}'] = $smcFunc['db_escape_string']($value);
}
$replaces['{$default_reserved_names}'] = strtr($replaces['{$default_reserved_names}'], array('\\\\n' => '\\n'));
if (substr($db_type, 0, 5) == 'mysql')
{
$engines = array();
$get_engines = $smcFunc['db_query']('', 'SHOW ENGINES', array());
while ($row = $smcFunc['db_fetch_assoc']($get_engines))
{
if ($row['Support'] == 'YES' || $row['Support'] == 'DEFAULT')
$engines[] = $row['Engine'];
}
$smcFunc['db_free_result']($get_engines);
$has_innodb = in_array('InnoDB', $engines);
$replaces['{$engine}'] = $has_innodb ? 'InnoDB' : 'MyISAM';
$replaces['{$memory}'] = (!$has_innodb && in_array('MEMORY', $engines)) ? 'MEMORY' : $replaces['{$engine}'];
if (!empty($databases[$db_type]['utf8_support']) && (!empty($databases[$db_type]['utf8_required']) || isset($_POST['utf8'])))
{
$replaces['{$engine}'] .= ' DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci';
$replaces['{$memory}'] .= ' DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci';
}
if (!$has_innodb)
{
$replaces['START TRANSACTION;'] = '';
$replaces['COMMIT;'] = '';
}
}
else
{
$has_innodb = false;
}
$type = ($db_type == 'mysqli' ? 'mysql' : $db_type);
$sql_lines = explode("\n", strtr(implode(' ', file(dirname(__FILE__) . '/install_' . DB_SCRIPT_VERSION . '_' . $type . '.sql')), $replaces));
$current_statement = '';
$exists = array();
$incontext['failures'] = array();
$incontext['sql_results'] = array(
'tables' => 0,
'inserts' => 0,
'table_dups' => 0,
'insert_dups' => 0,
);
foreach ($sql_lines as $count => $line)
{
if (substr(trim($line), 0, 1) != '#')
$current_statement .= "\n" . rtrim($line);
if (empty($current_statement) || (preg_match('~;[\s]*$~s', $line) == 0 && $count != count($sql_lines)))
continue;
if (preg_match('~^\s*INSERT INTO ([^\s\n\r]+?)~', $current_statement, $match) != 0 && in_array($match[1], $exists))
{
preg_match_all('~\)[,;]~', $current_statement, $matches);
if (!empty($matches[0]))
$incontext['sql_results']['insert_dups'] += count($matches[0]);
else
$incontext['sql_results']['insert_dups']++;
$current_statement = '';
continue;
}
if ($smcFunc['db_query']('', $current_statement, array('security_override' => true, 'db_error_skip' => true), $db_connection) === false)
{
if ((($db_type != 'mysql' && $db_type != 'mysqli') || mysqli_errno($db_connection) == 1050) && preg_match('~^\s*CREATE TABLE ([^\s\n\r]+?)~', $current_statement, $match) == 1)
{
$exists[] = $match[1];
$incontext['sql_results']['table_dups']++;
}
elseif (!preg_match('~^\s*CREATE( UNIQUE)? INDEX ([^\n\r]+?)~', $current_statement, $match) && !($db_type == 'postgresql' && preg_match('~^\s*CREATE OPERATOR (^\n\r]+?)~', $current_statement, $match)))
{
$incontext['failures'][$count] = $smcFunc['db_error']($db_connection);
}
}
else
{
if (preg_match('~^\s*CREATE TABLE ([^\s\n\r]+?)~', $current_statement, $match) == 1)
$incontext['sql_results']['tables']++;
elseif (preg_match('~^\s*INSERT INTO ([^\s\n\r]+?)~', $current_statement, $match) == 1)
{
preg_match_all('~\)[,;]~', $current_statement, $matches);
if (!empty($matches[0]))
$incontext['sql_results']['inserts'] += count($matches[0]);
else
$incontext['sql_results']['inserts']++;
}
}
$current_statement = '';
set_time_limit(60);
}
foreach ($incontext['sql_results'] as $key => $number)
{
if ($number == 0)
unset($incontext['sql_results'][$key]);
else
$incontext['sql_results'][$key] = sprintf($txt['db_populate_' . $key], $number);
}
if ((!empty($databases[$db_type]['utf8_support']) && !empty($databases[$db_type]['utf8_required'])) || (empty($databases[$db_type]['utf8_required']) && !empty($databases[$db_type]['utf8_support']) && isset($_POST['utf8'])))
$newSettings[] = array('global_character_set', 'UTF-8');
$url_parts = parse_url($boardurl);
if ($url_parts !== false)
{
unset($globalCookies, $globalCookiesDomain, $localCookies);
if (!empty($url_parts['host']) && (filter_var($url_parts['host'], FILTER_VALIDATE_IP) === false))
{
$url_parts['host'] = str_ireplace('www.', '', $url_parts['host']);
$pos1 = strrpos($url_parts['host'], '.');
if ($pos1 !== false)
{
$pos2 = strrpos(substr($url_parts['host'], 0, $pos1 - 1), '.');
if ($pos2 !== false)
{
$globalCookies = '1';
$globalCookiesDomain = substr($url_parts['host'], $pos2 + 1);
}
}
}
if (!empty($url_parts['path']) && strlen($url_parts['path']) > 1)
$localCookies = '1';
if (isset($globalCookies))
$newSettings[] = array('globalCookies', $globalCookies);
if (isset($globalCookiesDomain))
$newSettings[] = array('globalCookiesDomain', $globalCookiesDomain);
if (isset($localCookies))
$newSettings[] = array('localCookies', $localCookies);
}
if (!empty($_POST['stats']) && substr($boardurl, 0, 16) != 'http://localhost' && empty($modSettings['allow_sm_stats']) && empty($modSettings['enable_sm_stats']))
{
$incontext['allow_sm_stats'] = true;
$fp = @fsockopen('www.simplemachines.org', 80, $errno, $errstr);
if ($fp)
{
$out = 'GET /smf/stats/register_stats.php?site=' . base64_encode($boardurl) . ' HTTP/1.1' . "\r\n";
$out .= 'Host: www.simplemachines.org' . "\r\n";
$out .= 'Connection: Close' . "\r\n\r\n";
fwrite($fp, $out);
$return_data = '';
while (!feof($fp))
$return_data .= fgets($fp, 128);
fclose($fp);
preg_match('~SITE-ID:\s(\w{10})~', $return_data, $ID);
if (!empty($ID[1]))
$smcFunc['db_insert']('replace',
$db_prefix . 'settings',
array('variable' => 'string', 'value' => 'string'),
array(
array('sm_stats_key', $ID[1]),
array('enable_sm_stats', 1),
),
array('variable')
);
}
}
elseif (empty($_POST['stats']) && empty($incontext['allow_sm_stats']))
$smcFunc['db_query']('', '
DELETE FROM {db_prefix}settings
WHERE variable = {string:enable_sm_stats}',
array(
'enable_sm_stats' => 'enable_sm_stats',
'db_error_skip' => true,
)
);
if (!empty($_POST['force_ssl']))
$newSettings[] = array('force_ssl', 1);
if (!isset($modSettings['default_timezone']) && function_exists('date_default_timezone_set'))
{
$ini_tz = ini_get('date.timezone');
if (!empty($ini_tz))
$timezone_id = $ini_tz;
else
$timezone_id = '';
if (!in_array($timezone_id, timezone_identifiers_list()))
{
$server_offset = @mktime(0, 0, 0, 1, 1, 1970);
$timezone_id = timezone_name_from_abbr('', $server_offset, 0);
}
if (date_default_timezone_set($timezone_id))
$newSettings[] = array('default_timezone', $timezone_id);
}
if (!empty($newSettings))
{
$smcFunc['db_insert']('replace',
'{db_prefix}settings',
array('variable' => 'string-255', 'value' => 'string-65534'),
$newSettings,
array('variable')
);
}
$smiley_filenames = array(
':)' => 'smiley',
';)' => 'wink',
':D' => 'cheesy',
';D' => 'grin',
'>:(' => 'angry',
':(' => 'sad',
':o' => 'shocked',
'8)' => 'cool',
'???' => 'huh',
'::)' => 'rolleyes',
':P' => 'tongue',
':-[' => 'embarrassed',
':-X' => 'lipsrsealed',
':-\\' => 'undecided',
':-*' => 'kiss',
':\'(' => 'cry',
'>:D' => 'evil',
'^-^' => 'azn',
'O0' => 'afro',
':))' => 'laugh',
'C:-)' => 'police',
'O:-)' => 'angel'
);
$smiley_set_extensions = array('fugue' => '.png', 'alienine' => '.png');
$smiley_inserts = array();
$request = $smcFunc['db_query']('', '
SELECT id_smiley, code
FROM {db_prefix}smileys',
array()
);
while ($row = $smcFunc['db_fetch_assoc']($request))
{
foreach ($smiley_set_extensions as $set => $ext)
$smiley_inserts[] = array($row['id_smiley'], $set, $smiley_filenames[$row['code']] . $ext);
}
$smcFunc['db_free_result']($request);
$smcFunc['db_insert']('ignore',
'{db_prefix}smiley_files',
array('id_smiley' => 'int', 'smiley_set' => 'string-48', 'filename' => 'string-48'),
$smiley_inserts,
array('id_smiley', 'smiley_set')
);
if (!$has_innodb)
{
db_extend();
$tables = $smcFunc['db_list_tables']($db_name, $db_prefix . '%');
foreach ($tables as $table)
{
$smcFunc['db_optimize_table']($table) != -1 or $db_messed = true;
if (!empty($db_messed))
{
$incontext['failures'][-1] = $smcFunc['db_error']();
break;
}
}
}
if (substr($db_type, 0, 5) != 'mysql')
return false;
$privs = array();
$get_privs = $smcFunc['db_query']('', 'SHOW PRIVILEGES', array());
while ($row = $smcFunc['db_fetch_assoc']($get_privs))
{
if ($row['Privilege'] == 'Alter')
$privs[] = $row['Privilege'];
}
$smcFunc['db_free_result']($get_privs);
if (!empty($databases[$db_type]['alter_support']) && !in_array('Alter', $privs))
{
$incontext['error'] = $txt['error_db_alter_priv'];
return false;
}
if (!empty($exists))
{
$incontext['page_title'] = $txt['user_refresh_install'];
$incontext['was_refresh'] = true;
}
return false;
}
function AdminAccount()
{
global $txt, $db_type, $smcFunc, $incontext, $db_prefix, $db_passwd, $sourcedir, $db_character_set;
$incontext['sub_template'] = 'admin_account';
$incontext['page_title'] = $txt['user_settings'];
$incontext['continue'] = 1;
if (!empty($_POST['skip']))
return true;
require(dirname(__FILE__) . '/Settings.php');
load_database();
require_once($sourcedir . '/Subs-Auth.php');
require_once($sourcedir . '/Subs.php');
require_once($sourcedir . '/Load.php');
reloadSettings();
$smcFunc['strtolower'] = $db_character_set != 'utf8' && $txt['lang_character_set'] != 'UTF-8' ? 'strtolower' : function($string)
{
global $sourcedir;
if (function_exists('mb_strtolower'))
return mb_strtolower($string, 'UTF-8');
require_once($sourcedir . '/Subs-Charset.php');
return utf8_strtolower($string);
};
if (!isset($_POST['username']))
$_POST['username'] = '';
if (!isset($_POST['email']))
$_POST['email'] = '';
if (!isset($_POST['server_email']))
$_POST['server_email'] = '';
$incontext['username'] = htmlspecialchars($_POST['username']);
$incontext['email'] = htmlspecialchars($_POST['email']);
$incontext['server_email'] = htmlspecialchars($_POST['server_email']);
$incontext['require_db_confirm'] = empty($db_type);
$request = $smcFunc['db_query']('', '
SELECT id_member
FROM {db_prefix}members
WHERE id_group = {int:admin_group} OR FIND_IN_SET({int:admin_group}, additional_groups) != 0
LIMIT 1',
array(
'db_error_skip' => true,
'admin_group' => 1,
)
);
if ($smcFunc['db_num_rows']($request) != 0)
$incontext['skip'] = 1;
$smcFunc['db_free_result']($request);
if (isset($_POST['password1']) && !empty($_POST['contbutt']))
{
if ($incontext['require_db_confirm'] && $_POST['password3'] != $db_passwd)
{
$incontext['error'] = $txt['error_db_connect'];
return false;
}
if ($_POST['password1'] != $_POST['password2'])
{
$incontext['error'] = $txt['error_user_settings_again_match'];
return false;
}
if (strlen($_POST['password1']) < 4)
{
$incontext['error'] = $txt['error_user_settings_no_password'];
return false;
}
if (!file_exists($sourcedir . '/Subs.php'))
{
$incontext['error'] = sprintf($txt['error_sourcefile_missing'], 'Subs.php');
return false;
}
if (!empty($_POST['server_email']) && (empty($webmaster_email) || $webmaster_email == 'noreply@myserver.com'))
installer_updateSettingsFile(array('webmaster_email' => $_POST['server_email']));
$invalid_characters = preg_match('~[<>&"\'=\\\]~', $_POST['username']) != 0;
$_POST['username'] = preg_replace('~[<>&"\'=\\\]~', '', $_POST['username']);
$result = $smcFunc['db_query']('', '
SELECT id_member, password_salt
FROM {db_prefix}members
WHERE member_name = {string:username} OR email_address = {string:email}
LIMIT 1',
array(
'username' => $_POST['username'],
'email' => $_POST['email'],
'db_error_skip' => true,
)
);
if ($smcFunc['db_num_rows']($result) != 0)
{
list ($incontext['member_id'], $incontext['member_salt']) = $smcFunc['db_fetch_row']($result);
$smcFunc['db_free_result']($result);
$incontext['account_existed'] = $txt['error_user_settings_taken'];
}
elseif ($_POST['username'] == '' || strlen($_POST['username']) > 25)
{
$incontext['error'] = $_POST['username'] == '' ? $txt['error_username_left_empty'] : $txt['error_username_too_long'];
return false;
}
elseif ($invalid_characters || $_POST['username'] == '_' || $_POST['username'] == '|' || strpos($_POST['username'], '[code') !== false || strpos($_POST['username'], '[/code') !== false)
{
$incontext['error'] = $txt['error_invalid_characters_username'];
return false;
}
elseif (empty($_POST['email']) || !filter_var($_POST['email'], FILTER_VALIDATE_EMAIL) || strlen($_POST['email']) > 255)
{
$incontext['error'] = sprintf($txt['error_valid_admin_email_needed'], $_POST['username']);
return false;
}
elseif (empty($_POST['server_email']) || !filter_var($_POST['server_email'], FILTER_VALIDATE_EMAIL) || strlen($_POST['server_email']) > 255)
{
$incontext['error'] = $txt['error_valid_server_email_needed'];
return false;
}
elseif ($_POST['username'] != '')
{
if (!is_callable('random_int'))
require_once('Sources/random_compat/random.php');
$incontext['member_salt'] = substr(md5(random_int(0, PHP_INT_MAX)), 0, 4);
$_POST['username'] = preg_replace('~[\t\n\r\x0B\0\xA0]+~', ' ', $_POST['username']);
$ip = isset($_SERVER['REMOTE_ADDR']) ? substr($_SERVER['REMOTE_ADDR'], 0, 255) : '';
$_POST['password1'] = hash_password($_POST['username'], $_POST['password1']);
$incontext['member_id'] = $smcFunc['db_insert']('',
$db_prefix . 'members',
array(
'member_name' => 'string-25',
'real_name' => 'string-25',
'passwd' => 'string',
'email_address' => 'string',
'id_group' => 'int',
'posts' => 'int',
'date_registered' => 'int',
'password_salt' => 'string',
'lngfile' => 'string',
'personal_text' => 'string',
'avatar' => 'string',
'member_ip' => 'inet',
'member_ip2' => 'inet',
'buddy_list' => 'string',
'pm_ignore_list' => 'string',
'website_title' => 'string',
'website_url' => 'string',
'signature' => 'string',
'usertitle' => 'string',
'secret_question' => 'string',
'additional_groups' => 'string',
'ignore_boards' => 'string',
),
array(
$_POST['username'],
$_POST['username'],
$_POST['password1'],
$_POST['email'],
1,
0,
time(),
$incontext['member_salt'],
'',
'',
'',
$ip,
$ip,
'',
'',
'',
'',
'',
'',
'',
'',
'',
),
array('id_member'),
1
);
}
return true;
}
return false;
}
function DeleteInstall()
{
global $smcFunc, $db_character_set, $context, $txt, $incontext;
global $databases, $sourcedir, $modSettings, $user_info, $db_type, $boardurl;
$incontext['page_title'] = $txt['congratulations'];
$incontext['sub_template'] = 'delete_install';
$incontext['continue'] = 0;
require(dirname(__FILE__) . '/Settings.php');
load_database();
chdir(dirname(__FILE__));
require_once($sourcedir . '/Errors.php');
require_once($sourcedir . '/Logging.php');
require_once($sourcedir . '/Subs.php');
require_once($sourcedir . '/Load.php');
require_once($sourcedir . '/Security.php');
require_once($sourcedir . '/Subs-Auth.php');
reloadSettings();
if (!empty($incontext['account_existed']))
$incontext['warning'] = $incontext['account_existed'];
if (!empty($db_character_set) && !empty($databases[$db_type]['utf8_support']))
$smcFunc['db_query']('', '
SET NAMES {string:db_character_set}',
array(
'db_character_set' => $db_character_set,
'db_error_skip' => true,
)
);
$smcFunc['db_insert']('ignore',
'{db_prefix}log_activity',
array('date' => 'date', 'topics' => 'int', 'posts' => 'int', 'registers' => 'int'),
array(strftime('%Y-%m-%d', time()), 1, 1, (!empty($incontext['member_id']) ? 1 : 0)),
array('date')
);
$request = $smcFunc['db_query']('', '
SELECT variable, value
FROM {db_prefix}settings',
array(
'db_error_skip' => true,
)
);
if ($request)
{
while ($row = $smcFunc['db_fetch_row']($request))
$modSettings[$row[0]] = $row[1];
$smcFunc['db_free_result']($request);
}
if (isset($incontext['member_id']) && isset($incontext['member_salt']))
setLoginCookie(3153600 * 60, $incontext['member_id'], hash_salt($_POST['password1'], $incontext['member_salt']));
$result = $smcFunc['db_query']('', '
SELECT value
FROM {db_prefix}settings
WHERE variable = {string:db_sessions}',
array(
'db_sessions' => 'databaseSession_enable',
'db_error_skip' => true,
)
);
if ($smcFunc['db_num_rows']($result) != 0)
list ($db_sessions) = $smcFunc['db_fetch_row']($result);
$smcFunc['db_free_result']($result);
if (empty($db_sessions))
$_SESSION['admin_time'] = time();
else
{
$_SERVER['HTTP_USER_AGENT'] = substr($_SERVER['HTTP_USER_AGENT'], 0, 211);
$smcFunc['db_insert']('replace',
'{db_prefix}sessions',
array(
'session_id' => 'string', 'last_update' => 'int', 'data' => 'string',
),
array(
session_id(), time(), 'USER_AGENT|s:' . strlen($_SERVER['HTTP_USER_AGENT']) . ':"' . $_SERVER['HTTP_USER_AGENT'] . '";admin_time|i:' . time() . ';',
),
array('session_id')
);
}
updateStats('member');
updateStats('message');
updateStats('topic');
$smcFunc['strtolower'] = $db_character_set != 'utf8' && $txt['lang_character_set'] != 'UTF-8' ? 'strtolower' : function($string)
{
global $sourcedir;
if (function_exists('mb_strtolower'))
return mb_strtolower($string, 'UTF-8');
require_once($sourcedir . '/Subs-Charset.php');
return utf8_strtolower($string);
};
$request = $smcFunc['db_query']('', '
SELECT id_msg
FROM {db_prefix}messages
WHERE id_msg = 1
AND modified_time = 0
LIMIT 1',
array(
'db_error_skip' => true,
)
);
$context['utf8'] = $db_character_set === 'utf8' || $txt['lang_character_set'] === 'UTF-8';
if ($smcFunc['db_num_rows']($request) > 0)
updateStats('subject', 1, htmlspecialchars($txt['default_topic_subject']));
$smcFunc['db_free_result']($request);
require_once($sourcedir . '/ScheduledTasks.php');
if (isset($modSettings['recycle_board']))
{
scheduled_fetchSMfiles();
$user_info['ip'] = $_SERVER['REMOTE_ADDR'];
$user_info['id'] = isset($incontext['member_id']) ? $incontext['member_id'] : 0;
logAction('install', array('version' => SMF_FULL_VERSION), 'admin');
}
updateSettings(array(
'disabledBBC' => implode(',', $context['legacy_bbc']),
));
$incontext['dir_still_writable'] = is_writable(dirname(__FILE__)) && substr(__FILE__, 1, 2) != ':\\';
$incontext['probably_delete_install'] = isset($_SESSION['installer_temp_ftp']) || is_writable(dirname(__FILE__)) || is_writable(__FILE__);
updateSettings(array(
'bcrypt_hash_cost' => hash_benchmark(),
));
return false;
}
function installer_updateSettingsFile($vars, $rebuild = false)
{
global $sourcedir, $context, $db_character_set, $txt;
$context['utf8'] = (isset($vars['db_character_set']) && $vars['db_character_set'] === 'utf8') || (!empty($db_character_set) && $db_character_set === 'utf8') || (!empty($txt) && $txt['lang_character_set'] === 'UTF-8');
if (empty($sourcedir))
{
if (file_exists(dirname(__FILE__) . '/Sources') && is_dir(dirname(__FILE__) . '/Sources'))
$sourcedir = dirname(__FILE__) . '/Sources';
else
return false;
}
if (!is_writeable(dirname(__FILE__) . '/Settings.php'))
{
@chmod(dirname(__FILE__) . '/Settings.php', 0777);
if (!is_writeable(dirname(__FILE__) . '/Settings.php'))
return false;
}
require_once($sourcedir . '/Subs.php');
require_once($sourcedir . '/Subs-Admin.php');
return updateSettingsFile($vars, false, $rebuild);
}
function fixModSecurity()
{
$htaccess_addition = '
<IfModule mod_security.c>
# Turn off mod_security filtering. SMF is a big boy, it doesn\'t need its hands held.
SecFilterEngine Off
# The below probably isn\'t needed, but better safe than sorry.
SecFilterScanPOST Off
</IfModule>';
if (!function_exists('apache_get_modules') || !in_array('mod_security', apache_get_modules()))
return true;
elseif (file_exists(dirname(__FILE__) . '/.htaccess') && is_writable(dirname(__FILE__) . '/.htaccess'))
{
$current_htaccess = implode('', file(dirname(__FILE__) . '/.htaccess'));
if (strpos($current_htaccess, '<IfModule mod_security.c>') === false)
{
if ($ht_handle = fopen(dirname(__FILE__) . '/.htaccess', 'a'))
{
fwrite($ht_handle, $htaccess_addition);
fclose($ht_handle);
return true;
}
else
return false;
}
else
return true;
}
elseif (file_exists(dirname(__FILE__) . '/.htaccess'))
return strpos(implode('', file(dirname(__FILE__) . '/.htaccess')), '<IfModule mod_security.c>') !== false;
elseif (is_writable(dirname(__FILE__)))
{
if ($ht_handle = fopen(dirname(__FILE__) . '/.htaccess', 'w'))
{
fwrite($ht_handle, $htaccess_addition);
fclose($ht_handle);
return true;
}
else
return false;
}
else
return false;
}
function template_install_above()
{
global $incontext, $txt, $installurl;
echo '<!DOCTYPE html>
<html', $txt['lang_rtl'] == true ? ' dir="rtl"' : '', '>
<head>
<meta charset="', isset($txt['lang_character_set']) ? $txt['lang_character_set'] : 'UTF-8', '">
<meta name="robots" content="noindex">
<title>', $txt['smf_installer'], '</title>
<link rel="stylesheet" href="Themes/default/css/index.css">
<link rel="stylesheet" href="Themes/default/css/install.css">
', $txt['lang_rtl'] == true ? '<link rel="stylesheet" href="Themes/default/css/rtl.css">' : '', '
<script src="Themes/default/scripts/jquery-' . JQUERY_VERSION . '.min.js"></script>
<script src="Themes/default/scripts/script.js"></script>
</head>
<body>
<div id="footerfix">
<div id="header">
<h1 class="forumtitle">', $txt['smf_installer'], '</h1>
<img id="smflogo" src="Themes/default/images/smflogo.svg" alt="Simple Machines Forum" title="Simple Machines Forum">
</div>
<div id="wrapper">';
if (!empty($incontext['detected_languages']) && count($incontext['detected_languages']) > 1 && $incontext['current_step'] == 0)
{
echo '
<div id="upper_section">
<div id="inner_section">
<div id="inner_wrap">
<div class="news">
<form action="', $installurl, '" method="get">
<label for="installer_language">', $txt['installer_language'], ':</label>
<select id="installer_language" name="lang_file" onchange="location.href = \'', $installurl, '?lang_file=\' + this.options[this.selectedIndex].value;">';
foreach ($incontext['detected_languages'] as $lang => $name)
echo '
<option', isset($_SESSION['installer_temp_lang']) && $_SESSION['installer_temp_lang'] == $lang ? ' selected' : '', ' value="', $lang, '">', $name, '</option>';
echo '
</select>
<noscript><input type="submit" value="', $txt['installer_language_set'], '" class="button"></noscript>
</form>
</div><!-- .news -->
<hr class="clear">
</div><!-- #inner_wrap -->
</div><!-- #inner_section -->
</div><!-- #upper_section -->';
}
echo '
<div id="content_section">
<div id="main_content_section">
<div id="main_steps">
<h2>', $txt['upgrade_progress'], '</h2>
<ul class="steps_list">';
foreach ($incontext['steps'] as $num => $step)
echo '
<li', $num == $incontext['current_step'] ? ' class="stepcurrent"' : '', '>
', $txt['upgrade_step'], ' ', $step[0], ': ', $step[1], '
</li>';
echo '
</ul>
</div>
<div id="install_progress">
<div id="progress_bar" class="progress_bar progress_green">
<h3>'. $txt['upgrade_overall_progress'], '</h3>
<span id="overall_text">', $incontext['overall_percent'], '%</span>
<div id="overall_progress" class="bar" style="width: ', $incontext['overall_percent'], '%;"></div>
</div>
</div>
<div id="main_screen" class="clear">
<h2>', $incontext['page_title'], '</h2>
<div class="panel">';
}
function template_install_below()
{
global $incontext, $txt;
if (!empty($incontext['continue']) || !empty($incontext['skip']))
{
echo '
<div class="floatright">';
if (!empty($incontext['continue']))
echo '
<input type="submit" id="contbutt" name="contbutt" value="', $txt['upgrade_continue'], '" onclick="return submitThisOnce(this);" class="button">';
if (!empty($incontext['skip']))
echo '
<input type="submit" id="skip" name="skip" value="', $txt['upgrade_skip'], '" onclick="return submitThisOnce(this);" class="button">';
echo '
</div>';
}
if (count($incontext['steps']) - 1 !== (int) $incontext['current_step'])
echo '
</form>';
echo '
</div><!-- .panel -->
</div><!-- #main_screen -->
</div><!-- #main_content_section -->
</div><!-- #content_section -->
</div><!-- #wrapper -->
</div><!-- #footerfix -->
<div id="footer">
<ul>
<li class="copyright"><a href="https://www.simplemachines.org/" title="Simple Machines Forum" target="_blank" rel="noopener">' . SMF_FULL_VERSION . ' © ' . SMF_SOFTWARE_YEAR . ', Simple Machines</a></li>
</ul>
</div>
</body>
</html>';
}
function template_welcome_message()
{
global $incontext, $txt;
echo '
<script src="https://www.simplemachines.org/smf/current-version.js?version=' . urlencode(SMF_VERSION) . '"></script>
<form action="', $incontext['form_url'], '" method="post">
<p>', sprintf($txt['install_welcome_desc'], SMF_VERSION), '</p>
<div id="version_warning" class="noticebox hidden">
<h3>', $txt['error_warning_notice'], '</h3>
', sprintf($txt['error_script_outdated'], '<em id="smfVersion" style="white-space: nowrap;">??</em>', '<em id="yourVersion" style="white-space: nowrap;">' . SMF_VERSION . '</em>'), '
</div>';
if (template_warning_divs())
echo '
<h3>', $txt['install_all_lovely'], '</h3>';
if (empty($incontext['error']))
$incontext['continue'] = 1;
echo '
<script>
// Latest version?
function smfCurrentVersion()
{
var smfVer, yourVer;
if (!(\'smfVersion\' in window))
return;
window.smfVersion = window.smfVersion.replace(/SMF\s?/g, \'\');
smfVer = document.getElementById("smfVersion");
yourVer = document.getElementById("yourVersion");
setInnerHTML(smfVer, window.smfVersion);
var currentVersion = getInnerHTML(yourVer);
if (currentVersion < window.smfVersion)
document.getElementById(\'version_warning\').classList.remove(\'hidden\');
}
addLoadEvent(smfCurrentVersion);
</script>';
}
function template_warning_divs()
{
global $txt, $incontext;
if (!empty($incontext['error']))
echo '
<div class="errorbox">
<h3>', $txt['upgrade_critical_error'], '</h3>
', $incontext['error'], '
</div>';
elseif (!empty($incontext['warning']))
echo '
<div class="errorbox">
<h3>', $txt['upgrade_warning'], '</h3>
', $incontext['warning'], '
</div>';
return empty($incontext['error']) && empty($incontext['warning']);
}
function template_chmod_files()
{
global $txt, $incontext;
echo '
<p>', $txt['ftp_setup_why_info'], '</p>
<ul class="error_content">
<li>', implode('</li>
<li>', $incontext['failed_files']), '</li>
</ul>';
if (isset($incontext['systemos'], $incontext['detected_path']) && $incontext['systemos'] == 'linux')
echo '
<hr>
<p>', $txt['chmod_linux_info'], '</p>
<samp># chmod a+w ', implode(' ' . $incontext['detected_path'] . '/', $incontext['failed_files']), '</samp>';
if (!template_warning_divs())
return;
echo '
<hr>
<p>', $txt['ftp_setup_info'], '</p>';
if (!empty($incontext['ftp_errors']))
echo '
<div class="error_message">
', $txt['error_ftp_no_connect'], '<br><br>
<code>', implode('<br>', $incontext['ftp_errors']), '</code>
</div>';
echo '
<form action="', $incontext['form_url'], '" method="post">
<dl class="settings">
<dt>
<label for="ftp_server">', $txt['ftp_server'], ':</label>
</dt>
<dd>
<div class="floatright">
<label for="ftp_port" class="textbox"><strong>', $txt['ftp_port'], ': </strong></label>
<input type="text" size="3" name="ftp_port" id="ftp_port" value="', $incontext['ftp']['port'], '">
</div>
<input type="text" size="30" name="ftp_server" id="ftp_server" value="', $incontext['ftp']['server'], '">
<div class="smalltext block">', $txt['ftp_server_info'], '</div>
</dd>
<dt>
<label for="ftp_username">', $txt['ftp_username'], ':</label>
</dt>
<dd>
<input type="text" size="30" name="ftp_username" id="ftp_username" value="', $incontext['ftp']['username'], '">
<div class="smalltext block">', $txt['ftp_username_info'], '</div>
</dd>
<dt>
<label for="ftp_password">', $txt['ftp_password'], ':</label>
</dt>
<dd>
<input type="password" size="30" name="ftp_password" id="ftp_password">
<div class="smalltext block">', $txt['ftp_password_info'], '</div>
</dd>
<dt>
<label for="ftp_path">', $txt['ftp_path'], ':</label>
</dt>
<dd>
<input type="text" size="30" name="ftp_path" id="ftp_path" value="', $incontext['ftp']['path'], '">
<div class="smalltext block">', $incontext['ftp']['path_msg'], '</div>
</dd>
</dl>
<div class="righttext buttons">
<input type="submit" value="', $txt['ftp_connect'], '" onclick="return submitThisOnce(this);" class="button">
</div>
</form>
<a href="', $incontext['form_url'], '">', $txt['error_message_click'], '</a> ', $txt['ftp_setup_again'];
}
function template_database_settings()
{
global $incontext, $txt;
echo '
<form action="', $incontext['form_url'], '" method="post">
<p>', $txt['db_settings_info'], '</p>';
template_warning_divs();
echo '
<dl class="settings">';
if (count($incontext['supported_databases']) > 1)
{
echo '
<dt>
<label for="db_type_input">', $txt['db_settings_type'], ':</label>
</dt>
<dd>
<select name="db_type" id="db_type_input" onchange="toggleDBInput();">';
foreach ($incontext['supported_databases'] as $key => $db)
echo '
<option value="', $key, '"', isset($_POST['db_type']) && $_POST['db_type'] == $key ? ' selected' : '', '>', $db['name'], '</option>';
echo '
</select>
<div class="smalltext">', $txt['db_settings_type_info'], '</div>
</dd>';
}
else
{
echo '
<dd>
<input type="hidden" name="db_type" value="', $incontext['db']['type'], '">
</dd>';
}
echo '
<dt>
<label for="db_server_input">', $txt['db_settings_server'], ':</label>
</dt>
<dd>
<input type="text" name="db_server" id="db_server_input" value="', $incontext['db']['server'], '" size="30">
<div class="smalltext">', $txt['db_settings_server_info'], '</div>
</dd>
<dt>
<label for="db_port_input">', $txt['db_settings_port'], ':</label>
</dt>
<dd>
<input type="text" name="db_port" id="db_port_input" value="', $incontext['db']['port'], '">
<div class="smalltext">', $txt['db_settings_port_info'], '</div>
</dd>
<dt>
<label for="db_user_input">', $txt['db_settings_username'], ':</label>
</dt>
<dd>
<input type="text" name="db_user" id="db_user_input" value="', $incontext['db']['user'], '" size="30">
<div class="smalltext">', $txt['db_settings_username_info'], '</div>
</dd>
<dt>
<label for="db_passwd_input">', $txt['db_settings_password'], ':</label>
</dt>
<dd>
<input type="password" name="db_passwd" id="db_passwd_input" value="', $incontext['db']['pass'], '" size="30">
<div class="smalltext">', $txt['db_settings_password_info'], '</div>
</dd>
<dt>
<label for="db_name_input">', $txt['db_settings_database'], ':</label>
</dt>
<dd>
<input type="text" name="db_name" id="db_name_input" value="', empty($incontext['db']['name']) ? 'smf' : $incontext['db']['name'], '" size="30">
<div class="smalltext">
', $txt['db_settings_database_info'], '
<span id="db_name_info_warning">', $txt['db_settings_database_info_note'], '</span>
</div>
</dd>
<dt>
<label for="db_prefix_input">', $txt['db_settings_prefix'], ':</label>
</dt>
<dd>
<input type="text" name="db_prefix" id="db_prefix_input" value="', $incontext['db']['prefix'], '" size="30">
<div class="smalltext">', $txt['db_settings_prefix_info'], '</div>
</dd>
</dl>';
echo '
<script>
function toggleDBInput()
{
if (document.getElementById(\'db_type_input\').value == \'postgresql\')
document.getElementById(\'db_name_info_warning\').classList.add(\'hidden\');
else
document.getElementById(\'db_name_info_warning\').classList.remove(\'hidden\');
}
toggleDBInput();
</script>';
}
function template_forum_settings()
{
global $incontext, $txt;
echo '
<form action="', $incontext['form_url'], '" method="post">
<h3>', $txt['install_settings_info'], '</h3>';
template_warning_divs();
echo '
<dl class="settings">
<dt>
<label for="mbname_input">', $txt['install_settings_name'], ':</label>
</dt>
<dd>
<input type="text" name="mbname" id="mbname_input" value="', $txt['install_settings_name_default'], '" size="65">
<div class="smalltext">', $txt['install_settings_name_info'], '</div>
</dd>
<dt>
<label for="boardurl_input">', $txt['install_settings_url'], ':</label>
</dt>
<dd>
<input type="text" name="boardurl" id="boardurl_input" value="', $incontext['detected_url'], '" size="65">
<div class="smalltext">', $txt['install_settings_url_info'], '</div>
</dd>
<dt>
<label for="reg_mode">', $txt['install_settings_reg_mode'], ':</label>
</dt>
<dd>
<select name="reg_mode" id="reg_mode">
<optgroup label="', $txt['install_settings_reg_modes'], ':">
<option value="0" selected>', $txt['install_settings_reg_immediate'], '</option>
<option value="1">', $txt['install_settings_reg_email'], '</option>
<option value="2">', $txt['install_settings_reg_admin'], '</option>
<option value="3">', $txt['install_settings_reg_disabled'], '</option>
</optgroup>
</select>
<div class="smalltext">', $txt['install_settings_reg_mode_info'], '</div>
</dd>
<dt>', $txt['install_settings_compress'], ':</dt>
<dd>
<input type="checkbox" name="compress" id="compress_check" checked>
<label for="compress_check">', $txt['install_settings_compress_title'], '</label>
<div class="smalltext">', $txt['install_settings_compress_info'], '</div>
</dd>
<dt>', $txt['install_settings_dbsession'], ':</dt>
<dd>
<input type="checkbox" name="dbsession" id="dbsession_check" checked>
<label for="dbsession_check">', $txt['install_settings_dbsession_title'], '</label>
<div class="smalltext">', $incontext['test_dbsession'] ? $txt['install_settings_dbsession_info1'] : $txt['install_settings_dbsession_info2'], '</div>
</dd>
<dt>', $txt['install_settings_utf8'], ':</dt>
<dd>
<input type="checkbox" name="utf8" id="utf8_check"', $incontext['utf8_default'] ? ' checked' : '', '', $incontext['utf8_required'] ? ' disabled' : '', '>
<label for="utf8_check">', $txt['install_settings_utf8_title'], '</label>
<div class="smalltext">', $txt['install_settings_utf8_info'], '</div>
</dd>
<dt>', $txt['install_settings_stats'], ':</dt>
<dd>
<input type="checkbox" name="stats" id="stats_check" checked="checked">
<label for="stats_check">', $txt['install_settings_stats_title'], '</label>
<div class="smalltext">', $txt['install_settings_stats_info'], '</div>
</dd>
<dt>', $txt['force_ssl'], ':</dt>
<dd>
<input type="checkbox" name="force_ssl" id="force_ssl"', $incontext['ssl_chkbx_checked'] ? ' checked' : '',
$incontext['ssl_chkbx_protected'] ? ' disabled' : '', '>
<label for="force_ssl">', $txt['force_ssl_label'], '</label>
<div class="smalltext"><strong>', $txt['force_ssl_info'], '</strong></div>
</dd>
</dl>';
}
function template_populate_database()
{
global $incontext, $txt;
echo '
<form action="', $incontext['form_url'], '" method="post">
<p>', !empty($incontext['was_refresh']) ? $txt['user_refresh_install_desc'] : $txt['db_populate_info'], '</p>';
if (!empty($incontext['sql_results']))
{
echo '
<ul>
<li>', implode('</li><li>', $incontext['sql_results']), '</li>
</ul>';
}
if (!empty($incontext['failures']))
{
echo '
<div class="red">', $txt['error_db_queries'], '</div>
<ul>';
foreach ($incontext['failures'] as $line => $fail)
echo '
<li><strong>', $txt['error_db_queries_line'], $line + 1, ':</strong> ', nl2br(htmlspecialchars($fail)), '</li>';
echo '
</ul>';
}
echo '
<p>', $txt['db_populate_info2'], '</p>';
template_warning_divs();
echo '
<input type="hidden" name="pop_done" value="1">';
}
function template_admin_account()
{
global $incontext, $txt;
echo '
<form action="', $incontext['form_url'], '" method="post">
<p>', $txt['user_settings_info'], '</p>';
template_warning_divs();
echo '
<dl class="settings">
<dt>
<label for="username">', $txt['user_settings_username'], ':</label>
</dt>
<dd>
<input type="text" name="username" id="username" value="', $incontext['username'], '" size="40">
<div class="smalltext">', $txt['user_settings_username_info'], '</div>
</dd>
<dt>
<label for="password1">', $txt['user_settings_password'], ':</label>
</dt>
<dd>
<input type="password" name="password1" id="password1" size="40">
<div class="smalltext">', $txt['user_settings_password_info'], '</div>
</dd>
<dt>
<label for="password2">', $txt['user_settings_again'], ':</label>
</dt>
<dd>
<input type="password" name="password2" id="password2" size="40">
<div class="smalltext">', $txt['user_settings_again_info'], '</div>
</dd>
<dt>
<label for="email">', $txt['user_settings_admin_email'], ':</label>
</dt>
<dd>
<input type="text" name="email" id="email" value="', $incontext['email'], '" size="40">
<div class="smalltext">', $txt['user_settings_admin_email_info'], '</div>
</dd>
<dt>
<label for="server_email">', $txt['user_settings_server_email'], ':</label>
</dt>
<dd>
<input type="text" name="server_email" id="server_email" value="', $incontext['server_email'], '" size="40">
<div class="smalltext">', $txt['user_settings_server_email_info'], '</div>
</dd>
</dl>';
if ($incontext['require_db_confirm'])
echo '
<h2>', $txt['user_settings_database'], '</h2>
<p>', $txt['user_settings_database_info'], '</p>
<div class="lefttext">
<input type="password" name="password3" size="30">
</div>';
}
function template_delete_install()
{
global $incontext, $installurl, $txt, $boardurl;
echo '
<p>', $txt['congratulations_help'], '</p>';
template_warning_divs();
if ($incontext['dir_still_writable'])
echo '
<p><em>', $txt['still_writable'], '</em></p>';
if ($incontext['probably_delete_install'])
echo '
<label>
<input type="checkbox" id="delete_self" onclick="doTheDelete();">
<strong>', $txt['delete_installer'], !isset($_SESSION['installer_temp_ftp']) ? ' ' . $txt['delete_installer_maybe'] : '', '</strong>
</label>
<script>
function doTheDelete()
{
var theCheck = document.getElementById ? document.getElementById("delete_self") : document.all.delete_self;
var tempImage = new Image();
tempImage.src = "', $installurl, '?delete=1&ts_" + (new Date().getTime());
tempImage.width = 0;
theCheck.disabled = true;
}
</script>';
echo '
<p>', sprintf($txt['go_to_your_forum'], $boardurl . '/index.php'), '</p>
<br>
', $txt['good_luck'];
}
?>