Changelog

[Stephen Kise]

Author: Stephen Kise
Module: Changelog
Compatability: Tested on 1.1.2, should work on 1.1.0+
Current Version: Beta 1 (0.1b) (June 17, 2011)
File Submission: Here

This module needs a new table in the database. I SUGGEST OPENING THE ZIP AND READING THE README BEFORE THROWING IT IN THE MODULES FOLDER.
This has a file to be placed in the lib directory as well as the modules  directory. The READ ME file in the zip will tell you the stuff to add in the table you need to make in MySQL.
I have added !kickme in the author's section of the module because he helped me with the date(); function. (Thanks so much!)

[KaosKaizer]

Anytime you create, drop, or query a DB table from LotGD, you need to make sure you include db_prefix(); because some users will have a prefix for their tables. Just follow the updates below. EDIT, the first statement is from lib/changelog.php and the second is from modules/changelog.php.

Code:

<?php
// THIS
$sql = "INSERT INTO `changelog` ( `id` , `date` , `title` , `desc` , `affected` ) VALUES (NULL ,'".date("Y-m-d")."', '".$title."', '".$desc."', '".$affected."')";
// AND THIS
$sql = "SELECT * FROM changelog ORDER BY id DESC";
// SHOULD BE
$sql = "INSERT INTO `".db_prefix("changelog")."` ( `id` , `date` , `title` , `desc` , `affected` ) VALUES (NULL ,'".date("Y-m-d")."', '".$title."', '".$desc."', '".$affected."')";
// AND
$sql = "SELECT * FROM ".db_prefix("changelog")." ORDER BY id DESC";

[Stephen Kise]

Anytime you create, drop, or query a DB table from LotGD, you need to make sure you include db_prefix(); because some users will have a prefix for their tables. Just follow the updates below. EDIT, the first statement is from lib/changelog.php and the second is from modules/changelog.php.

Code:

<?php
// THIS
$sql = "INSERT INTO `changelog` ( `id` , `date` , `title` , `desc` , `affected` ) VALUES (NULL ,'".date("Y-m-d")."', '".$title."', '".$desc."', '".$affected."')";
// AND THIS
$sql = "SELECT * FROM changelog ORDER BY id DESC";
// SHOULD BE
$sql = "INSERT INTO `".db_prefix("changelog")."` ( `id` , `date` , `title` , `desc` , `affected` ) VALUES (NULL ,'".date("Y-m-d")."', '".$title."', '".$desc."', '".$affected."')";
// AND
$sql = "SELECT * FROM ".db_prefix("changelog")." ORDER BY id DESC";

Ah, I will remember that next time I have never used a prefix before so I sensed no need for it myself. I will note to make the changes for any future module releases

[Michelina]

I dropped this modules into my site and its spitting out a

Parse error: syntax error, unexpected '{' in /home/********/public_html/modules/changelog.php on line 39

I am asking for assistance as to why this has occurred.

I followed the READ ME in the module and placed both pieces in the correct folders.
I even tried to the prefix to the SQL to see if that was a problem.. it did not help.
I manually have created the table in my SQL so that it would be able to hook.

So anything at all at this point would be great.

[Stephen Kise]

I dropped this modules into my site and its spitting out a

Parse error: syntax error, unexpected '{' in /home/********/public_html/modules/changelog.php on line 39

I am asking for assistance as to why this has occurred.

I followed the READ ME in the module and placed both pieces in the correct folders.
I even tried to the prefix to the SQL to see if that was a problem.. it did not help.
I manually have created the table in my SQL so that it would be able to hook.

So anything at all at this point would be great.

When you have a syntax error, it just means that there is a typo or something is missing. In this case, find line 39:

Code:

<?php
if (db_table_exists(db_prefix("changelog")){
?>

Change it to:

Code:

<?php
if (db_table_exists(db_prefix("changelog"))){
?>

Then save the code. Putting the fixed version up in this attachment.

[Michelina]

Thanks for the fix.
It is working now.

Thank you Stephen!

[Stephen Kise]

Thanks for the fix.
It is working now.

Thank you Stephen!

Welcome.

[Srch]

Cleaned up my messy code. Added pagination, because it seems that making 200 changelog entries is not hard at all.

[~Ender~]

I installed the module and started adding things; however, instead of the added text showing up under 'View Changelog' it is showing up under the news. Pictures included.

[Eclypse ~ Xpert]

You didn't place the lib file into the lib folder where all the core files are.