OK, if you have ONE school in Alumni and want to implement my obituary category solution, create 2 sub-cats under the school called 'Classmates' and 'Obituary'.
modlisting.php
Line 316
Replace:
$xoopsDB->query("update ".$xoopsDB->prefix("alumni_listing")." set cid='$cat', name='$name', mname='$mname', lname='$lname', year='$year', studies='$studies', activities='$activities', extrainfo='$extrainfo', occ='$occ', date='$date', email='$email', submitter='$submitter', town='$town', valid='$valid', photo='$photo_old', photo2='$photo2_old' where lid=$lid");
with:
// pk set school var
if($cat == '2') {
$school = "Obituary";
}
else {
$school = "Classmates";
}
// pk update school var
$xoopsDB->query("update ".$xoopsDB->prefix("alumni_listing")." set cid='$cat', name='$name', mname='$mname', lname='$lname', school='$school', year='$year', studies='$studies', activities='$activities', extrainfo='$extrainfo', occ='$occ', date='$date', email='$email', submitter='$submitter', town='$town', valid='$valid', photo='$photo_old', photo2='$photo2_old' where lid=$lid");
admin/index.php
Line 349
Replace:
$xoopsDB->query("update ".$xoopsDB->prefix("alumni_listing")." set cid='$cat', name='$name', mname='$mname', lname='$lname', year='$year', studies='$studies', activities='$activities', extrainfo='$extrainfo', occ='$occ', date='$date', email='$email', submitter='$submitter', town='$town', valid='$valid', photo='$photo', photo2='$photo2' where lid=$lid");
with:
// pk set school var
if($cat == '2') {
$school = "Obituary";
}
else {
$school = "Classmates";
}
// pk update school var
$xoopsDB->query("update ".$xoopsDB->prefix("alumni_listing")." set cid='$cat', name='$name', mname='$mname', lname='$lname', year='$year', school='$school', studies='$studies', activities='$activities', extrainfo='$extrainfo', occ='$occ', date='$date', email='$email', submitter='$submitter', town='$town', valid='$valid', photo='$photo', photo2='$photo2' where lid=$lid");
I also changed the 'School' column header to 'Group'.
language/english/main.php
change
define("_ALUM_SCHOOL","School");
define("_ALUM_SCHOOL2","School");
to
define("_ALUM_SCHOOL","Group");
define("_ALUM_SCHOOL2","Group");
Now admin, or users, can move listings into the alumni obituary if required.
Now I just need to write some conditional statements to stop the 'contact me' link from appearing if someone is dead!
A thread is for life. Not just for Christmas.