Modification Log

This hack will add a new option under Logs and Statistics in your Admin CP. It allows you to track which modifications you have installed on to your board by filling out the form in the hack to contain a name, Author name, Version Number,
Description and an Installation date.

This hack can be made dynamic so you do not have to add the info your self but a hack releaser would just need to add an extra query to the install to do it for you. In the future I intend to extend this to log which files have been modified in the hack and what queries have been run, possibly through making it into an installation system.

This hack was made out of a want to track what I have installed simply and without having to go to the trouble of installing the HTL. If the Author of that hack wants me to remove this I will as the original idea was essentially his.

2 hacks in 2 days


v 1.01 - Includes field for url to modification by HellRazor

[burnist]

They worrying thing is the thats the same version I'm using. I just looked at the vB install file and it had the equivelant line broken into
[sql]
PRIMARY KEY (modid)
)
[/sql]

Try that and maby it'll work

[outlaw621]

Originally Posted by burnist

They worrying thing is the thats the same version I'm using. I just looked at the vB install file and it had the equivelant line broken into
[sql]
PRIMARY KEY (modid)
)
[/sql]

Try that and maby it'll work

I tried the following but I got the same error:

CREATE TABLE modslog (
modid int(10) auto_increment,
name varchar(250),
description varchar(250),
authur varchar(250),
version varchar(250),
date int(10)
PRIMARY KEY (modid)
)

and I also tried it this way:

CREATE TABLE modslog (
modid int(10) auto_increment,
name varchar(250),
description varchar(250),
authur varchar(250),
version varchar(250),
date int(10)
PRIMARY KEY(modid)
)

I tired both ways via vBulletin and also in phpMyAdmin.

[burnist]

[sql]
CREATE TABLE modslog (
modid int(10) auto_increment,
name varchar(250),
description varchar(250),
authur varchar(250),
version varchar(250),
date int(10),
PRIMARY KEY(modid)
)
[/sql]

maby a comma after date int(10) may help =-/

[outlaw621]

Originally Posted by burnist

[sql]
CREATE TABLE modslog (
modid int(10) auto_increment,
name varchar(250),
description varchar(250),
authur varchar(250),
version varchar(250),
date int(10),
PRIMARY KEY(modid)
)
[/sql]

maby a comma after date int(10) may help =-/

That did it. Database was created without any errors. Thank you for all your help and patience.

[burnist]

That did it. Database was created without any errors. Thank you for all your help and patience.

No problem, happy to help :P

[jluerken]

Originally Posted by burnist

No problem, happy to help :P

What about the comment field? *smile*

[DS MrSinister]

I get this error when I try to add in the info of the hacks..

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO modslog (name,description,author,version,date) VALUES ('Modification Log','Manual Log of Modification add to vb','','1.0.0','1101452197')
mysql error: Unknown column 'author' in 'field list'

mysql error number: 1054

[HellRazor]

That error is due to a bad SQL query in the install text. In the SQL query, "author" is misspelled as "authur".

To fix this:

In AdminCP, go to Execute SQL Query under Import & Maintenance.

First execute this query to delete the incorrect table:

DROP TABLE IF EXISTS modslog;

Then execute this query to create a corrected table;

CREATE TABLE modslog (
modid int(10) auto_increment,
name varchar(250),
description varchar(250),
author varchar(250),
version varchar(250),
date int(10),
PRIMARY KEY(modid))

[HellRazor]

Also, the instructions tell you to place the phrases under Control Panel Global. This is partially incorrect.

Place modslog_actions and modslog_name under Control Panel Global.

Place modslog_moddeleted, modslog_modedited, and modslog_modadded under Control Panel Stop Message.

[HellRazor]

There is another spelling error in modslog.php, where "author" is again misspelled "author". If you don't correct this, the author's name will not get added when you enter a new modification to the log.