

kevicho
Members-
Content count
36 -
Joined
-
Last visited
Profile Information
-
Real Name
kevin eaton
-
pbpBB2 and osC shared account creation
kevicho replied to anderskiel's topic in General Add-Ons Support
I looked at both and the above is what swung it for me. However :) Would it be possible for the username not to be mandatory, and if left blank to create a dummy user name of firstname + lastnames initial just for people who don't want a forum name? -
I tried similar but couldnt get it working. In the end i have cheated and created a new file and pointed those pages to that column right :)
-
Hi there, the fix is in post 682 :)
-
Does anyone know how i can get the article infoboxes to only appear on the article pages (ie all articles, new arcles and article info etc) ???
-
Includes/modules/article_listing.php This makes the articles appear in rows of 3 Change the if ($col==3) { bit to whatever number you want
-
Im going to post my article listing which now appears in columns of threes and i think is the same as yours Also beware i dont use one or two of the items that can be listable. Maybe this is considered scruffy code but i was pleased :D
-
pbpBB2 and osC shared account creation
kevicho replied to anderskiel's topic in General Add-Ons Support
Wow thats solved it, inspired fix there, although if you go into includes/configure.php there is a setting in there which is: define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' It was blank before, changed it to mysql and it worked first time :) (that will save reinstalls) Thanks everyone for the help :D -
I had a similar problem with this once on an older site i worked on, it turned out the admin input for the product description was overwritten by some code for a different input (cant remember exactly what now), so my admin side was saying product but outputting to something else (if you get what i mean lol) Might be worth going through the admin side of the install again, also might be worth using something like examdiff to check that theres nothing glaringly obvious between your test and pre live site (i hope this update wasnt put on your live live site lol) :)
-
Maybe a typo there, but is there a ; after your last ) ???
-
pbpBB2 and osC shared account creation
kevicho replied to anderskiel's topic in General Add-Ons Support
sorry mysql is 5.0.27-community-nt lol -
pbpBB2 and osC shared account creation
kevicho replied to anderskiel's topic in General Add-Ons Support
Just for info My config is win xp ip address 192.168.1.100 (which is set up as that in osc/phpbb config files and apache) Apache 2.2.3 PHP 5.2.0 php 5.0.27-community-nt Thanks for the help btw, i know it makes even even more awkward when the site isnt available over the net. Cheers Kev -
Just a note, i think that fix is backwards compatible, might be worth checking for future releases :)
-
Ok part 2 :) find in articles_new.php $listing_sql = "select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.topics_id left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id, " . TABLE_ARTICLES_DESCRIPTION . " ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' and a.articles_date_added > SUBDATE(now( ), INTERVAL '" . NEW_ARTICLES_DAYS_DISPLAY . "' DAY) order by a.articles_date_added desc, ad.articles_name"; Change to $listing_sql = "select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from ((" . TABLE_ARTICLES . " a), " . TABLE_ARTICLES_TO_TOPICS . " a2t) left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.topics_id left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id, " . TABLE_ARTICLES_DESCRIPTION . " ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' and a.articles_date_added > SUBDATE(now( ), INTERVAL '" . NEW_ARTICLES_DAYS_DISPLAY . "' DAY) order by a.articles_date_added desc, ad.articles_name"; this is the same fix as before, just been slightly renamed Hope this helps lots of people :)
-
I had the same problem with php5 installed. the above fix didnt work, and i had a similar issue with another mod, so i thought id try and give it a go Anyways I tried the fix from the other mod and it seems to be working, in articles.php in the various table outputs it has a query listing (if my terminology here sucks then sorry), this is the bit makes the all articles work, going to find the rest in a mo :) find $articles_all_query_raw = "select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.topics_id left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id, " . TABLE_ARTICLES_DESCRIPTION . " ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' order by a.articles_date_added desc, ad.articles_name"; change to $articles_all_query_raw = "select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from ((" . TABLE_ARTICLES . " a), " . TABLE_ARTICLES_TO_TOPICS . " a2t) left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.topics_id left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id, " . TABLE_ARTICLES_DESCRIPTION . " ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' order by a.articles_date_added desc, ad.articles_name"; notice the from ((" . TABLE_ARTICLES . " a), " . TABLE_ARTICLES_TO_TOPICS . " a2t) is changed, cant remember the reason for this, hope this solves some issues
-
pbpBB2 and osC shared account creation
kevicho replied to anderskiel's topic in General Add-Ons Support
ignore this post lol