Sortable nicer archives for WordPress 1.2

andrew_h, I tried using your mod for not listing a specific category, and it works fine when listing by category (where I wouldn’t mind if it actually didn’t exclude the category) and title. But for date sorting it doesn’t work at all.
https://binarybonsai.com/masterarchives

Im going to consider that the new “changes” are being handled between the originator and the user implementing those changes. If you cannot get something to work (even an extra change) please find me in #wordpress or email me and I will try to help out.
Good job with helping out!

Parse error: parse error, unexpected T_VARIABLE in /home/public_html/narchives.php on line 42
huh?

Hi Michael, no it wouldn’t since my changes act in the $_POST["orderby"] == 'category' part of the loop, to make changes in the date sort you would need to make changes around line 260. There may also be better ways of doing what I did (like altering the database call). For the time being I am happy as things now are for me though I might look at altering the dates within category sort order sometime.
Andrew

Has anyone checked your server error logs to see if you are getting the Cannot modify header information msg I posted above? I want to confirm that this error is appearing only on my install.
Thanks.
<rb>

Andrew, I don’t know PHP at all, is there a chance I can get you to mock up the changes I need and perhaps mail them to me, or simply post them here?

randy: No I am not getting header errors. I am getting database errors now that I have upgraded from the latest nightly however ?? “Where user_level > 0” and “invalid argument for foreach on line 62” – Just a heads up to those who keep up with the latest.

Mark, thank you! ?? You rock!

Hi Michael
I’m pretty busy right now so can’t help, sorry. If I get a chance later I will have another look but don’t hold your breath ??
Andrew

The database errors are because the table variables have changed in the new nightly builds…
check the file wp-setting.php for the changes…

Here’s the new table variables in the new nightlies…
$wpdb->posts = $table_prefix . ‘posts’;
$wpdb->users = $table_prefix . ‘users’;
$wpdb->categories = $table_prefix . ‘categories’;
$wpdb->post2cat = $table_prefix . ‘post2cat’;
$wpdb->comments = $table_prefix . ‘comments’;
$wpdb->links = $table_prefix . ‘links’;
$wpdb->linkcategories = $table_prefix . ‘linkcategories’;
$wpdb->options = $table_prefix . ‘options’;
$wpdb->optiontypes = $table_prefix . ‘optiontypes’;
$wpdb->optionvalues = $table_prefix . ‘optionvalues’;
$wpdb->optiongroups = $table_prefix . ‘optiongroups’;
$wpdb->optiongroup_options = $table_prefix . ‘optiongroup_options’;
$wpdb->postmeta = $table_prefix . ‘postmeta’;
And here is the old variables from the 1.2 release…
$tableposts = $table_prefix . ‘posts’;
$tableusers = $table_prefix . ‘users’;
$tablesettings = $table_prefix . ‘settings’; // only used during upgrade
$tablecategories = $table_prefix . ‘categories’;
$tablepost2cat = $table_prefix . ‘post2cat’;
$tablecomments = $table_prefix . ‘comments’;
$tablelinks = $table_prefix . ‘links’;
$tablelinkcategories = $table_prefix . ‘linkcategories’;
$tableoptions = $table_prefix . ‘options’;
$tableoptiontypes = $table_prefix . ‘optiontypes’;
$tableoptionvalues = $table_prefix . ‘optionvalues’;
$tableoptiongroups = $table_prefix . ‘optiongroups’;
$tableoptiongroup_options = $table_prefix . ‘optiongroup_options’;
$tablepostmeta = $table_prefix . ‘postmeta’;
in the narchive.php file… just replace the old variables for the new ones in the sql statements and it should work…

Just made the changes to the file and it works perfectly…
For those of you running the new nightlies.. you can grab the modded version here, fixed to work with the new naming scheme of the tables…
narchives 1.3alpha fix

The only thing missing from this is pagination. That way you can list lets say the first 50 posts and a link would appear on the bottom for the rest…
Or even better would be to list only a specific month with links to the other months…
Great addition to wordpress either way!

works great with one exception:
Selecting DATE and or TITLE – if I have ALL YEARS selected it will display nothing, I HAVE TO select a YEAR to have posts show up.
Selecting CATEGORY and have ALL YEARS selected, will display correctly.
Further up in this thread I saw somebody commenting on needing to add something:
if (!($_POST[“submit”])) { $m = date(‘Y’); }
– is this the problem? Do I need to add this someplace, and if yes, where?

Ah, thanks! I get it now. And it handles my initial problem of having an empty page returned when first hitting the narchives.php page.
Odd though that you don’t get the same problem with Title or Date display (i.e. that all years will return null and that a specific year has to be selected to return something). I didn’t change anything on the code, except for that one line now.
On the other hand, posting to this forum seems even weirder since yesterday! first the above 2 posts are there, then they are gone (this morning) and I repost, but now the repost is gone. After that I suddenly had some weird posting of ‘mine’ (i.e. my name but obviously a spam posting) show up in the forum but with no content when clicked onto the post link and then I posted a question about if it is possible to steal somebodies identity here (i.e. subscribe with the exact same name as already exists). but now that posting is gone plus the spam and the 2 postings from above show up again. LOL. I think I need an overhaul. It is Memorial Day after all;-)