SMF Staff doesn't work. Manual installation

[GasPipe]

Hi!

I installed SMF Staff modification manually. Now, when I try to push "Staff List" from menu or go to Staff page settings in admin panel, it says:

Database Error
Table 'sql_foorumi.smf_staff' doesn't exist
File: <MY SERVER>/Sources/Staff.php
Line: 169

Any suggestions?

Thanks.

[SMFHacks]

You need to install the database tables manually look inside the package for somethingsql.php and run the quieries inside that file manually.

[GasPipe]

OK, how should I do that? I have PHPMyAdmin 2.9.0.2.
I think that file you meant was staffsql.php. It looks like this from inside:

Code: [Select]

<?php
//SMFHacks.com
//Table SQL

//Create the Staff Table
db_query("CREATE TABLE IF NOT EXISTS `{$db_prefix}staff`
(ID_GROUP smallint(5) unsigned NOT NULL,
`roworder` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY  (`ID_GROUP`))", __FILE__, __LINE__);



//Insert the settings
db_query("REPLACE INTO {$db_prefix}settings VALUES ('smfstaff_showavatar', '0')", __FILE__, __LINE__);
db_query("REPLACE INTO {$db_prefix}settings VALUES ('smfstaff_showlastactive', '1')", __FILE__, __LINE__);
db_query("REPLACE INTO {$db_prefix}settings VALUES ('smfstaff_showdateregistered', '1')", __FILE__, __LINE__);
db_query("REPLACE INTO {$db_prefix}settings VALUES ('smfstaff_showcontactinfo', '1')", __FILE__, __LINE__);
db_query("REPLACE INTO {$db_prefix}settings VALUES ('smfstaff_showlocalmods', '1')", __FILE__, __LINE__);




?>