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:
<?php
$_zp_gallery = new Gallery();
class Gallery {
public $albumdir = NULL;
public $table = 'gallery';
protected $albums = NULL;
protected $theme;
protected $themes;
protected $lastalbumsort = NULL;
protected $data = array();
protected $unprotected_pages = array();
function __construct() {
$this->albumdir = ALBUM_FOLDER_SERVERPATH;
$data = getOption('gallery_data');
if ($data) {
$this->data = getSerializedArray($data);
}
if (isset($this->data['unprotected_pages'])) {
$pages = getSerializedArray($this->data['unprotected_pages']);
if (is_array($pages))
$this->unprotected_pages = $pages;
}
}
function getTitle($locale = NULL) {
$text = $this->get('gallery_title');
if ($locale !== 'all') {
$text = get_language_string($text, $locale);
}
$text = unTagURLs($text);
return $text;
}
function getBareTitle($locale = NULL) {
return getBare($this->getTitle($locale));
}
function setTitle($title) {
$this->set('gallery_title', tagURLs($title));
}
function getDesc($locale = NULL) {
$text = $this->get('Gallery_description');
if ($locale == 'all') {
return unTagURLs($text);
} else {
return applyMacros(unTagURLs(get_language_string($text, $locale)));
}
}
function setDesc($desc) {
$desc = tagURLs($desc);
$this->set('Gallery_description', $desc);
}
function getCopyrightNotice($locale = null) {
$text = $this->get('copyright_site_notice');
if ($locale == 'all') {
return unTagURLs($text);
} else {
return applyMacros(unTagURLs(get_language_string($text, $locale)));
}
}
function setCopyrightNotice($notice) {
$notice = tagURLs($notice);
$this->set('copyright_site_notice', $notice);
}
function getCopyrightRightsholder() {
$rightsholder = $this->get('copyright_site_rightsholder');
if ($rightsholder && $rightsholder != 'none') {
if ($rightsholder == 'custom') {
$rightsholder = $this->get('copyright_site_rightsholder_custom');
} else {
$rightsholder = Zenphoto_Administrator::getNameByUser($rightsholder);
}
}
if (empty($rightsholder)) {
$authority = new Zenphoto_Authority();
$master = $authority->getMasterUser();
$rightsholder = $master->getName();
}
return $rightsholder;
}
function getCopyrightURL() {
return $this->get('copyright_site_url');
}
function setCopyrightURL($url) {
$this->set('copyright_site_url', $url);
}
function getPassword() {
if (GALLERY_SECURITY != 'public') {
return NULL;
} else {
return $this->get('gallery_password');
}
}
function setPassword($value) {
$this->set('gallery_password', $value);
}
function getPasswordHint($locale = NULL) {
$text = $this->get('gallery_hint');
if ($locale !== 'all') {
$text = get_language_string($text, $locale);
}
$text = unTagURLs($text);
return $text;
}
function setPasswordHint($value) {
$this->set('gallery_hint', tagURLs($value));
}
function getUser() {
return($this->get('gallery_user'));
}
function setUser($value) {
$this->set('gallery_user', $value);
}
function getAlbumDir() {
return $this->albumdir;
}
function getAlbumSortKey($sorttype = null) {
if (empty($sorttype)) {
$sorttype = $this->getSortType();
}
return lookupSortKey($sorttype, 'sort_order', 'albums');
}
function getSortDirection() {
return $this->get('sort_direction');
}
function setSortDirection($value) {
$this->set('sort_direction', (int) ($value && true));
}
function getSortType() {
$type = $this->get('gallery_sorttype');
return $type;
}
function setSortType($value) {
$this->set('gallery_sorttype', $value);
}
function getAlbums($page = 0, $sorttype = null, $sortdirection = null, $care = true, $mine = NULL) {
if ($mine || is_null($this->albums) || $care && $sorttype . $sortdirection !== $this->lastalbumsort) {
if (is_null($sorttype)) {
$sorttype = $this->getSortType();
}
if (is_null($sortdirection)) {
if ($this->getSortDirection()) {
$sortdirection = 'DESC';
} else {
$sortdirection = '';
}
}
$albumnames = $this->loadAlbumNames();
$key = $this->getAlbumSortKey($sorttype);
$albums = $this->sortAlbumArray(NULL, $albumnames, $key, $sortdirection, $mine);
$this->albums = $albums;
$this->lastalbumsort = $sorttype . $sortdirection;
}
if ($page == 0) {
return $this->albums;
} else {
return array_slice($this->albums, galleryAlbumsPerPage() * ($page - 1), galleryAlbumsPerPage());
}
}
private function loadAlbumNames() {
$albumdir = $this->getAlbumDir();
$dir = opendir($albumdir);
$msg = '';
if (!$dir) {
if (!is_dir($albumdir)) {
$msg .= sprintf(gettext('Error: The “albums” directory (%s) cannot be found.'), $this->albumdir);
} else {
$msg .= sprintf(gettext('Error: The “albums” directory (%s) is not readable.'), $this->albumdir);
}
zp_error($msg);
}
$albums = array();
while ($dirname = readdir($dir)) {
if ($dirname[0] != '.' && (is_dir($albumdir . $dirname) || hasDynamicAlbumSuffix($dirname))) {
$albums[] = filesystemToInternal($dirname);
}
}
closedir($dir);
return zp_apply_filter('album_filter', $albums);
}
function getAllAlbums($albumobj = NULL, $rights = UPLOAD_RIGHTS, $includetitles = true) {
$allalbums = array();
$is_fulladmin = zp_loggedin(ADMIN_RIGHTS | MANAGE_ALL_ALBUM_RIGHTS);
if (isAlbumClass($albumobj)) {
$albums = $albumobj->getAlbums(0);
} else {
$albums = $this->getAlbums(0);
}
if (is_array($albums)) {
foreach ($albums as $folder) {
$album = newAlbum($folder);
if ($is_fulladmin || $album->isMyItem($rights)) {
if ($album->isDynamic()) {
if ($is_fulladmin || $rights == ALL_ALBUMS_RIGHTS) {
if ($includetitles) {
$allalbums[$album->getFileName()] = $album->getTitle();
} else {
$allalbums[] = $album->getFileName();
}
}
} else {
if ($includetitles) {
$allalbums[$album->getFileName()] = $album->getTitle();
} else {
$allalbums[] = $album->getFileName();
}
$allalbums = array_merge($allalbums, $this->getAllAlbums($album, $rights));
}
}
}
}
return $allalbums;
}
function getAllAlbumsFromDB($keeplevel_sortorder = false, $albumobj = NULL, $rights = UPLOAD_RIGHTS, $includetitles = true) {
$allalbums = array();
$is_fulladmin = zp_loggedin(ADMIN_RIGHTS | MANAGE_ALL_ALBUM_RIGHTS);
$sorttype = 'folder';
$sortdirection = ' ASC';
$sql = 'SELECT `folder` FROM ' . prefix('albums');
if (isAlbumClass($albumobj)) {
$sql .= " WHERE `folder` like '" . $albumobj->name . "/%'";
if ($keeplevel_sortorder) {
$sorttype = $albumobj->getSortType('album');
if ($albumobj->getSortDirection('album')) {
$sortdirection = ' DESC';
} else {
$sortdirection = ' ASC';
}
}
} else {
if ($keeplevel_sortorder) {
$sql .= " WHERE `parentid` IS NULL";
$sorttype = $this->getSortType();
if ($this->getSortDirection()) {
$sortdirection = ' DESC';
} else {
$sortdirection = ' ASC';
}
}
}
if ($sorttype == 'manual') {
$sorttype = 'sort_order';
}
$sql .= ' ORDER BY ' . $sorttype . $sortdirection;
$result = query($sql);
if ($result) {
while ($row = db_fetch_assoc($result)) {
$album = newAlbum($row['folder']);
if ($album->exists && ($is_fulladmin || $album->isMyItem($rights))) {
if ($album->isDynamic()) {
if ($is_fulladmin || $rights == ALL_ALBUMS_RIGHTS) {
if ($includetitles) {
$allalbums[$album->getFileName()] = $album->getTitle();
} else {
$allalbums[] = $album->getFileName();
}
}
} else {
if ($includetitles) {
$allalbums[$album->getFileName()] = $album->getTitle();
} else {
$allalbums[] = $album->getFileName();
}
if ($keeplevel_sortorder) {
$allalbums = array_merge($allalbums, $this->getAllAlbumsFromDB($keeplevel_sortorder, $album, $rights, $includetitles));
}
}
}
}
db_free_result($result);
}
return $allalbums;
}
function getAlbum($index) {
$this->getAlbums();
if ($index >= 0 && $index < $this->getNumAlbums()) {
return newAlbum($this->albums[$index]);
} else {
return false;
}
}
function getNumAlbums($db = false, $publishedOnly = false) {
$count = -1;
if (!$db) {
$this->getAlbums(0, NULL, NULL, false);
$count = count($this->albums);
} else {
$sql = '';
if ($publishedOnly) {
$sql = 'WHERE `show`=1';
}
$count = db_count('albums', $sql);
}
return $count;
}
function getThemes() {
if (empty($this->themes)) {
$themedir = SERVERPATH . "/themes";
$themes = array();
if ($dp = @opendir($themedir)) {
while (false !== ($dir = readdir($dp))) {
if (substr($dir, 0, 1) != "." && is_dir("$themedir/$dir")) {
$themefile = $themedir . "/$dir/theme_description.php";
$dir8 = filesystemToInternal($dir);
if (file_exists($themefile)) {
$theme_description = array();
require($themefile);
$themes[$dir8] = $theme_description;
} else {
$themes[$dir8] = array('name' => gettext('Unknown'), 'author' => gettext('Unknown'), 'version' => gettext('Unknown'), 'desc' => gettext('<strong>Missing theme info file!</strong>'), 'date' => gettext('Unknown'));
}
}
}
ksort($themes, SORT_LOCALE_STRING);
}
$this->themes = $themes;
}
return $this->themes;
}
function getCurrentTheme() {
$theme = NULL;
if (empty($this->theme)) {
$theme = $this->get('current_theme');
if (empty($theme) || !file_exists(SERVERPATH . "/" . THEMEFOLDER . "/$theme")) {
$themes = array_keys($this->getThemes());
if (!empty($themes)) {
$theme = array_shift($themes);
}
}
$this->theme = $theme;
}
return $this->theme;
}
function setCurrentTheme($theme) {
$this->set('current_theme', $this->theme = $theme);
}
function getNumImages($what = 0) {
switch ((int) $what) {
case 0:
return db_count('images', '');
break;
case 1:
$rows = query("SELECT `id` FROM " . prefix('albums') . " WHERE `show`=0");
$idlist = array();
$exclude = 'WHERE `show`=1';
if ($rows) {
while ($row = db_fetch_assoc($rows)) {
$idlist[] = $row['id'];
}
if (!empty($idlist)) {
$exclude .= ' AND `albumid` NOT IN (' . implode(',', $idlist) . ')';
}
db_free_result($rows);
}
return db_count('images', $exclude);
break;
case 2:
$count = 0;
$albums = $this->getAlbums(0);
foreach ($albums as $analbum) {
$album = newAlbum($analbum);
if (!$album->isDynamic()) {
$count = $count + $this->getImageCount($album);
}
}
return $count;
break;
}
}
private function getImageCount($album) {
$count = $album->getNumImages();
$albums = $album->getAlbums(0);
foreach ($albums as $analbum) {
$album = newAlbum($analbum);
if (!$album->isDynamic()) {
$count = $count + $this->getImageCount($album);
}
}
return $count;
}
function getNumComments($moderated = false) {
$sql = '';
if (!$moderated) {
$sql = "WHERE `inmoderation`=0";
}
return db_count('comments', $sql);
}
function garbageCollect($cascade = true, $complete = false, $restart = '') {
global $_zp_gallery;
if (empty($restart)) {
setOption('last_garbage_collect', time());
$sql = 'DELETE FROM ' . prefix('search_cache');
if (!$complete) {
$sql .= ' WHERE `date`<' . db_quote(date('Y-m-d H:m:s', time() - SEARCH_CACHE_DURATION * 60));
}
$result = query($sql);
$this->commentClean('images');
$this->commentClean('albums');
$this->commentClean('news');
$this->commentClean('pages');
$dead = array();
$result = query("SELECT `id`, `type`, `tagid`, `objectid` FROM " . prefix('obj_to_tag'));
if ($result) {
while ($row = db_fetch_assoc($result)) {
$tbl = $row['type'];
$dbtag = query_single_row("SELECT `id` FROM " . prefix('tags') . " WHERE `id`='" . $row['tagid'] . "'", false);
if (!$dbtag) {
$dead[] = $row['id'];
}
$dbtag = query_single_row("SELECT `id` FROM " . prefix($tbl) . " WHERE `id`='" . $row['objectid'] . "'", false);
if (!$dbtag) {
$dead[] = $row['id'];
}
}
db_free_result($result);
}
if (!empty($dead)) {
$dead = array_unique($dead);
query('DELETE FROM ' . prefix('obj_to_tag') . ' WHERE `id`=' . implode(' OR `id`=', $dead));
}
$dead = array();
$result = query("SELECT `id`, `type`, `adminid`, `objectid` FROM " . prefix('admin_to_object'));
if ($result) {
while ($row = db_fetch_assoc($result)) {
$dbtag = query_single_row("SELECT `id` FROM " . prefix('administrators') . " WHERE `id`='" . $row['adminid'] . "'", false);
if (!$dbtag) {
$dead[] = $row['id'];
}
$tbl = $row['type'];
$dbtag = query_single_row("SELECT `id` FROM " . prefix($tbl) . " WHERE `id`='" . $row['objectid'] . "'", false);
if (!$dbtag) {
$dead[] = $row['id'];
}
}
db_free_result($result);
}
if (!empty($dead)) {
$dead = array_unique($dead);
query('DELETE FROM ' . prefix('admin_to_object') . ' WHERE `id` IN(' . implode(',', $dead) . ')');
}
$dead = array();
$result = query("SELECT `id`, `news_id`, `cat_id` FROM " . prefix('news2cat'));
if ($result) {
while ($row = db_fetch_assoc($result)) {
$dbtag = query_single_row("SELECT `id` FROM " . prefix('news') . " WHERE `id`='" . $row['news_id'] . "'", false);
if (!$dbtag) {
$dead[] = $row['id'];
}
$dbtag = query_single_row("SELECT `id` FROM " . prefix('news_categories') . " WHERE `id`='" . $row['cat_id'] . "'", false);
if (!$dbtag) {
$dead[] = $row['id'];
}
}
db_free_result($result);
}
if (!empty($dead)) {
$dead = array_unique($dead);
query('DELETE FROM ' . prefix('news2cat') . ' WHERE `id` IN(' . implode(',', $dead) . ')');
}
$set_updateddate = false;
$dead = array();
$live = array('');
$deadalbumthemes = array();
$result = query("SELECT `id`, `folder`, `album_theme` FROM " . prefix('albums'));
while ($row = db_fetch_assoc($result)) {
$albumpath = internalToFilesystem($row['folder']);
$albumpath_valid = preg_replace('~/\.*/~', '/', $albumpath);
$albumpath_valid = ltrim(trim($albumpath_valid, '/'), './');
$illegal = $albumpath != $albumpath_valid;
$valid = file_exists(ALBUM_FOLDER_SERVERPATH . $albumpath_valid) && (hasDynamicAlbumSuffix($albumpath_valid) || is_dir(ALBUM_FOLDER_SERVERPATH . $albumpath_valid));
if ($valid && $illegal) {
$valid = query('UPDATE ' . prefix('albums') . ' SET `folder`=' . db_quote($albumpath_valid) . ' WHERE `id`=' . $row['id'], false);
debugLog(sprintf(gettext('Invalid album folder: %1$s %2$s'), $albumpath, $valid ? gettext('fixed') : gettext('discarded')));
}
if (!$valid || in_array($row['folder'], $live)) {
$dead[] = $row['id'];
if ($row['album_theme'] !== '') {
$deadalbumthemes[$row['id']] = $row['folder'];
}
} else {
$live[] = $row['folder'];
}
}
db_free_result($result);
if (count($dead) > 0) {
asort($dead);
$criteria = '(' . implode(',', $dead) . ')';
$sql1 = "DELETE FROM " . prefix('albums') . " WHERE `id` IN $criteria";
$n = query($sql1);
if (!$complete && $n && $cascade) {
$sql2 = "DELETE FROM " . prefix('images') . " WHERE `albumid` IN $criteria";
query($sql2);
$sql3 = "DELETE FROM " . prefix('comments') . " WHERE `type`='albums' AND `ownerid` IN $criteria";
query($sql3);
$sql4 = "DELETE FROM " . prefix('obj_to_tag') . " WHERE `type`='albums' AND `objectid` IN $criteria";
query($sql4);
}
}
if (count($deadalbumthemes) > 0) {
foreach ($deadalbumthemes as $id => $deadtable) {
$sql = 'DELETE FROM ' . prefix('options') . ' WHERE `ownerid`=' . $id;
query($sql, false);
}
}
if (count($dead) > 0) {
$result = query("SELECT `parentid`, `folder` FROM " . prefix('albums') . ' WHERE `id` IN(' . implode(',', $dead) . ')');
while ($row = db_fetch_assoc($result)) {
if($row['parentid'] != 0) {
$parentalbum = getItemByID('albums', $row['parentid']);
$parentalbum->setUpdateddate();
$parentalbum->save();
$parentalbum->setUpdatedDateParents();
}
}
}
}
if ($complete) {
if (empty($restart)) {
$albums = $_zp_gallery->getAlbums();
foreach ($albums as $album) {
checkAlbumParentid($album, NULL, 'debuglog');
}
$albumids = query("SELECT `id`, `mtime`, `folder`, `dynamic` FROM " . prefix('albums'));
if ($albumids) {
while ($analbum = db_fetch_assoc($albumids)) {
if (($mtime = filemtime(ALBUM_FOLDER_SERVERPATH . internalToFilesystem($analbum['folder']))) > $analbum['mtime']) {
$album = newAlbum($analbum['folder']);
$album->set('mtime', $mtime);
if ($this->getAlbumUseImagedate()) {
$album->setDateTime(NULL);
}
if ($album->isDynamic()) {
$data = file_get_contents($album->localpath);
$thumb = getOption('AlbumThumbSelect');
$words = $fields = '';
while (!empty($data)) {
$data1 = trim(substr($data, 0, $i = strpos($data, "\n")));
if ($i === false) {
$data1 = $data;
$data = '';
} else {
$data = substr($data, $i + 1);
}
if (strpos($data1, 'WORDS=') !== false) {
$words = "words=" . urlencode(substr($data1, 6));
}
if (strpos($data1, 'THUMB=') !== false) {
$thumb = trim(substr($data1, 6));
}
if (strpos($data1, 'FIELDS=') !== false) {
$fields = "&searchfields=" . trim(substr($data1, 7));
}
}
if (!empty($words)) {
if (empty($fields)) {
$fields = '&searchfields=tags';
}
}
$album->set('search_params', $words . $fields);
$album->set('thumb', $thumb);
}
$album->save();
zp_apply_filter('album_refresh', $album);
}
}
db_free_result($albumids);
}
$albumids = query("SELECT `id` FROM " . prefix('albums'));
$idsofalbums = array();
if ($albumids) {
while ($row = db_fetch_assoc($albumids)) {
$idsofalbums[] = $row['id'];
}
db_free_result($albumids);
}
$imageAlbums = query("SELECT DISTINCT `albumid` FROM " . prefix('images'));
$albumidsofimages = array();
if ($imageAlbums) {
while ($row = db_fetch_assoc($imageAlbums)) {
$albumidsofimages[] = $row['albumid'];
}
db_free_result($imageAlbums);
}
$orphans = array_diff($albumidsofimages, $idsofalbums);
if (count($orphans) > 0) {
$firstrow = array_pop($orphans);
$sql = "DELETE FROM " . prefix('images') . " WHERE `albumid`='" . $firstrow . "'";
foreach ($orphans as $id) {
$sql .= " OR `albumid`='" . $id . "'";
}
query($sql);
foreach ($this->getAlbums(0) as $folder) {
$album = newAlbum($folder);
if (!$album->isDynamic()) {
if (is_null($album->getDateTime())) {
$images = $album->getImages(0, 0);
if (count($images) > 0) {
$image = newImage($album, array_shift($images));
$album->setDateTime($image->getDateTime());
}
}
$album->garbageCollect(true);
$album->preLoad();
}
$album->save();
zp_apply_filter('album_refresh', $album);
}
}
}
$start = array_sum(explode(" ", microtime()));
if (!empty($restart)) {
$restartwhere = ' WHERE `id`>' . $restart . ' AND `mtime`=0';
} else {
$restartwhere = ' WHERE `mtime`=0';
}
define('RECORD_LIMIT', 5);
$sql = 'SELECT * FROM ' . prefix('images') . $restartwhere . ' ORDER BY `id` LIMIT ' . (RECORD_LIMIT + 2);
$images = query($sql);
if ($images) {
$c = 0;
while ($image = db_fetch_assoc($images)) {
$albumobj = getItemByID('albums', $image['albumid']);
if ($albumobj->exists && file_exists($imageName = internalToFilesystem(ALBUM_FOLDER_SERVERPATH . $albumobj->name . '/' . $image['filename']))) {
if ($image['mtime'] != $mtime = filemtime($imageName)) {
$imageobj = newImage($albumobj, $image['filename']);
$imageobj->set('mtime', $mtime);
$imageobj->updateMetaData();
$imageobj->updateDimensions();
$imageobj->save();
zp_apply_filter('image_refresh', $imageobj);
}
} else {
$sql = 'DELETE FROM ' . prefix('images') . ' WHERE `id`="' . $image['id'] . '";';
$result = query($sql);
$sql = 'DELETE FROM ' . prefix('comments') . ' WHERE `type` IN (' . zp_image_types('"') . ') AND `ownerid` ="' . $image['id'] . '";';
$result = query($sql);
}
if (++$c >= RECORD_LIMIT) {
return $image['id'];
}
}
db_free_result($images);
}
$resource = db_show('tables');
if ($resource) {
while ($row = db_fetch_assoc($resource)) {
$tbl = array_shift($row);
query('OPTIMIZE TABLE `' . $tbl . '`');
}
db_free_result($resource);
}
}
return false;
}
function commentClean($table) {
$ids = query('SELECT `id` FROM ' . prefix($table));
$idsofitems = array();
if ($ids) {
while ($row = db_fetch_assoc($ids)) {
$idsofitems[] = $row['id'];
}
db_free_result($ids);
}
$sql = "SELECT DISTINCT `ownerid` FROM " . prefix('comments') . ' WHERE `type` =' . db_quote($table);
$commentOwners = query($sql);
$idsofcomments = array();
if ($commentOwners) {
while ($row = db_fetch_assoc($commentOwners)) {
$idsofcomments [] = $row['ownerid'];
}
db_free_result($commentOwners);
}
$orphans = array_diff($idsofcomments, $idsofitems);
if (count($orphans) > 0) {
$sql = "DELETE FROM " . prefix('comments') . " WHERE `type`=" . db_quote($table) . " AND (`ownerid`=" . implode(' OR `ownerid`=', $orphans) . ')';
query($sql);
}
}
static function clearCache($cachefolder = NULL) {
if (is_null($cachefolder)) {
$cachefolder = SERVERCACHE;
}
removeDir($cachefolder, true);
}
function sortAlbumArray($parentalbum, $albums, $sortkey = '`sort_order`', $sortdirection = NULL, $mine = NULL) {
if (count($albums) == 0) {
return array();
}
if (is_null($mine) && zp_loggedin(MANAGE_ALL_ALBUM_RIGHTS)) {
$mine = true;
}
if (is_null($parentalbum)) {
$albumid = ' IS NULL';
$obj = $this;
$viewUnpublished = $mine;
} else {
$albumid = '=' . $parentalbum->getID();
$obj = $parentalbum;
$viewUnpublished = (zp_loggedin() && $obj->albumSubRights() & (MANAGED_OBJECT_RIGHTS_EDIT | MANAGED_OBJECT_RIGHTS_VIEW));
}
if (($sortkey == '`sort_order`') || ($sortkey == 'RAND()')) {
$order = false;
} else {
if (!is_null($sortdirection)) {
$order = strtoupper($sortdirection) == 'DESC';
} else {
$order = $obj->getSortDirection('album');
}
}
$sortkey = db_quote($sortkey, false);
$sql = 'SELECT * FROM ' . prefix("albums") . ' WHERE `parentid`' . $albumid . ' ORDER BY ' . $sortkey . ' ' . $sortdirection;
$result = query($sql);
$results = array();
while ($row = db_fetch_assoc($result)) {
$folder = $row['folder'];
if (($key = array_search($folder, $albums)) !== false) {
$results[$row['folder']] = $row;
unset($albums[$key]);
} else {
$id = $row['id'];
query("DELETE FROM " . prefix('albums') . " WHERE `id`=$id");
query("DELETE FROM " . prefix('comments') . " WHERE `type` ='images' AND `ownerid`= '$id'");
query("DELETE FROM " . prefix('obj_to_tag') . "WHERE `type`='albums' AND `objectid`=" . $id);
query("DELETE FROM " . prefix('albums') . " WHERE `id` = " . $id);
}
}
db_free_result($result);
foreach ($albums as $folder) {
$albumobj = newAlbum($folder);
if ($albumobj->exists) {
$results[$folder] = $albumobj->getData();
}
}
$results = sortByKey($results, $sortkey, $order);
$albums_ordered = array();
foreach ($results as $row) {
$folder = $row['folder'];
$album = newAlbum($folder);
switch (themeObject::checkScheduledPublishing($row)) {
case 1:
$album->setShow(0);
$album->save();
case 2:
$row['show'] = 0;
}
if ($mine || $row['show'] || (($list = $album->isMyItem(LIST_RIGHTS)) && is_null($album->getParent())) || (is_null($mine) && $list && $viewUnpublished)) {
$albums_ordered[] = $folder;
}
}
return $albums_ordered;
}
function getHitcounter() {
return $this->get('hitcounter');
}
function countHit() {
$this->set('hitcounter', $this->get('hitcounter') + 1);
$this->save();
}
function getWebsiteTitle($locale = NULL) {
$text = $this->get('website_title');
if ($locale !== 'all') {
$text = get_language_string($text, $locale);
}
$text = unTagURLs($text);
return $text;
}
function setWebsiteTitle($value) {
$this->set('website_title', tagURLs($value));
}
function getWebsiteURL() {
return $this->get('website_url');
}
function setWebsiteURL($value) {
$this->set('website_url', $value);
}
function getSecurity() {
return $this->get('gallery_security');
}
function setSecurity($value) {
$this->set('gallery_security', $value);
}
function getUserLogonField() {
return $this->get('login_user_field');
}
function setUserLogonField($value) {
$this->set('login_user_field', $value);
}
function getAlbumUseImagedate() {
return $this->get('album_use_new_image_date');
}
function setAlbumUseImagedate($value) {
$this->set('album_use_new_image_date', $value);
}
function getThumbSelectImages() {
return $this->get('thumb_select_images');
}
function setThumbSelectImages($value) {
$this->set('thumb_select_images', $value);
}
function getSecondLevelThumbs() {
return $this->get('multilevel_thumb_select_images');
}
function setSecondLevelThumbs($value) {
$this->set('multilevel_thumb_select_images', $value);
}
function getGallerySession() {
return $this->get('album_session');
}
function setGallerySession($value) {
$this->set('album_session', $value);
}
function isUnprotectedPage($page) {
return (in_array($page, $this->unprotected_pages));
}
function setUnprotectedPage($page, $on) {
if ($on) {
array_unshift($this->unprotected_pages, $page);
$this->unprotected_pages = array_unique($this->unprotected_pages);
} else {
$key = array_search($page, $this->unprotected_pages);
if ($key !== false) {
unset($this->unprotected_pages[$key]);
}
}
$this->set('unprotected_pages', serialize($this->unprotected_pages));
}
function getAlbumPublish() {
return $this->get('album_publish');
}
function setAlbumPublish($v) {
$this->set('album_publish', $v);
}
function getImagePublish() {
return $this->get('image_publish');
}
function setImagePublish($v) {
$this->set('image_publish', $v);
}
function getCodeblock() {
return unTagURLs($this->get("codeblock"));
}
function setCodeblock($cb) {
$this->set('codeblock', tagURLs($cb));
}
function checkforGuest(&$hint = NULL, &$show = NULL) {
if (!(GALLERY_SECURITY != 'public')) {
return false;
}
$hint = '';
$pwd = $this->getPassword();
if (!empty($pwd)) {
return 'zpcms_auth_gallery';
}
return 'zp_public_access';
}
function isProtected() {
return $this->checkforGuest() != 'zp_public_access';
}
function get($field) {
if (isset($this->data[$field])) {
return $this->data[$field];
}
return NULL;
}
function set($field, $value) {
$this->data[$field] = $value;
}
function save() {
setOption('gallery_data', serialize($this->data));
}
public function __toString() {
return 'Gallery object';
}
static function addImageHandler($suffix, $objectName) {
global $_zp_extra_filetypes;
$_zp_extra_filetypes[strtolower($suffix)] = $objectName;
}
static function validImage($filename) {
global $_zp_supported_images;
return in_array(getSuffix($filename), $_zp_supported_images);
}
static function validImageAlt($filename) {
global $_zp_extra_filetypes;
return @$_zp_extra_filetypes[getSuffix($filename)];
}
static function addAlbumHandler($suffix, $objectName) {
global $_zp_albumHandlers;
$_zp_albumHandlers[strtolower($suffix)] = $objectName;
}
}
?>