Jump to content

OldGrim

Members
  • Content Count

    25
  • Joined

  • Last visited

Community Reputation

0 Neutral

About OldGrim

  • Rank
    Member
  • Birthday 11/03/1949

Contact Methods

  • Website URL
    https://fortworthbonsai.org

Profile Information

  • Gender
    Male
  • Location
    Ft. Worth, Texas
  • Interests
    Computing, RC models, oil painting, music, graphic art, guitar and keyboard playing.
  • Age
    71
  1. Point taken. Thanks for explanation.
  2. As a final remark I would like to say that after reading through thousands of posts on this forum over the years, that there are many users that use many different CMS systems and I've never seen anyone get denied help just because of their system in use. Most of the time when given suggestions or sample code I am able to modify it to fit within my particular system parameters. So I am sorry Barand that you feel that way.
  3. Well, OK I guess. I converted my topics table to use InnoDB instead of MyISAM; so I guess I'll proceed from there and seek help elsewhere. Thanks for all your help in the past Barand.
  4. OK I have tried every way I can think of to make this work but it gives errors. [08-May-2021 07:16:17 America/Chicago] PHP Parse error: syntax error, unexpected 'function' (T_FUNCTION) in /home/whisperw/blog.whisperwillow.net/grims_blog/include/latest_topics.php on line 18 I tried the function in an external file to no avail. Here is what I have now: <?php echo "<div class='col-sm-12'>\n"; echo "<table width='100%' border='0'><tr><td><span class='hdspan2'><b>".$locale['gb_810']."</b></span></td></tr></table>\n"
  5. OK thanks. I have to go to work now but will apply the changes tonight and report back on the results.
  6. Well that's fine and dandy but! What is this? | 10 | Cat 1 1 1 | 4 | I don't understand what the 1 1 1 is after Cat.
  7. Well I get the gist of what you are showing me but am not sure how I would relate it to the actual topic db table. For instance: Is this what you mean? | id | topic_title | topic_sub | topic_parent_id | | 3 | People | 0 | 0 | | 9 | Celebrities | 1 | 3 | I can figure out most things but I am a little confused here.
  8. I am having trouble adding sub-topics to my home made blog system running under PHP-Fusion CMS with PHPver7.4.16 with cgi/fcgi interface and MySQL5.7.34-log. Here are 2 images: Here is the module that produces the output. <?php echo "<div class='col-sm-12'>\n"; echo "<table width='100%' border='0'><tr><td><span class='hdspan2'><b>".$locale['gb_810']."</b></span></td></tr></table>\n"; echo "<table align='center' width='80%' border='0'>\n"; $result = dbquery("SELECT * FROM ".DB_GRIMS_BLOG_TOPICS." ORDER BY topic_
  9. OK I tried it your way and it still works fine. Slightly less code; thanks man!!
  10. Do you actually mean: $data = dbarray($result); if (!$data) { $id = null; $title = null; $evday = null; } else { $id = $data['post_id']; $title = $data['post_title']; $evday = strtotime($data['post_date']); }
  11. Thanks again Barand. This now works fine. $result = dbquery("SELECT post_id, post_title, post_date FROM ".DB_GRIMS_BLOG_POST." WHERE active='1' AND MONTH(post_date) = '$cMonth' AND DAY(post_date) = '$d'"); $data = dbarray($result); if (empty($data['post_id'])) { $id = null; } else { $id = $data['post_id']; } if (empty($data['post_title'])) { $title = null; } else { $title = $data['post_title']; } if (empty($data['post_date'])) { $evday = null; } else { $evday = strtotime($data['post_date']); } As I said before you guys are the greatest! Mainly because you know how to make U
  12. Actually it's dead on. If you count the 2 events plus the bool{false} items they total 30 items (30 days in April). The dbquery is inside the forLoop which counts and prints the days of the month in the calendar. I have tried many many different scenarios of having the query outside the forLoop but they just won't work. If I could solve the "bool{false}" counts I'd be home free. In older versions of PHP this wasn't a problem but if I lower the active PHP version version it causes other problems that are even more difficult to solve. I may be asking the impossible here but I thought I'd try. Yo
  13. This is the output of var_dump($data); array(3) { ["post_id"]=> string(2) "35" ["post_title"]=> string(8) "Fake Day" ["post_date"]=> string(10) "2021-04-01" } bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) array(3) { ["post_id"]=> string(2) "36" ["post_title"]=> string(12) "Carbon Tales" ["post_date"]=> string(10) "2021-04-18" } bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false) bool(false)
  14. CMS: PHP-Fusion version 9.03.110, PHP version: 7.4.16, MySQL Server Version: 5.7.33-log, DB Driver: PDO MySQL My own support people at PHP-Fusion main site have been unable to help me with this problem and I'm hoping for some new eyes and new input on this error. First of all my script works perfectly fine and outputs the result desired. I know that my script is not using PDO prepared statements and I am not prepared to modify it to do so because too much would have to be changed. And I'm not fluent on PDO. My script is an event calendar and can be seen at this url: https://windy.whi
  15. One final note: We did change it Barand, When any previous month is selected and then an active date in that month is clicked, instead of 'filtered.php' it now pulls up our 'archive_files.php' then from there the month archive desired is clicked. Our little problem is now solved and our calendar scripts, indeed the entire blog system is now ready for production. Thanks once again for all your help. 😉
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.