[Done 1.5.1] Global Moderator center.

[Syrann]

I used the yabbpack to install the mod, but I'm getting the problem where the check marks aren't saving (under "Installed 'Mods' Settings and Options")  so all of the GM functions say "None".

Any suggestions?

[Syrann]

Okay, figured out that it has to do with the SQL-query.  Duh!

All better now.  

[Happy Axeman]

I am trying to Install the Mod via the Yabbpak, but once installed I cant click the the selection boxes for the Global mod to work either, I try running the SQL but I get this error message? I am completey new to MySQL so I have no idea   What am I doing wrong?

SQL-query :  

INSERT INTO < TBLPREFIX > settings
VALUES ('gmodnews', '1'), ('gmodcensor', '1'), ('gmodreserve', '1'), ('gmodban', '1')

MySQL said:

You have an error in your SQL syntax near '< TBLPREFIX > settings VALUES (  'gmodnews',  '1' ), (  'gmodcensor',  '1' )' at line 1

[Big P]

See where it says: < TBLPREFIX >. I take it you're meant to replace that with your actual YaBB SE table prefix. Something like yabbse_ or whatever you used when you installed it.

[[Unknown]]

The package manager replaces it for you....

-[Unknown]

[buster]

i like this mod. Is it an idea to add more functions?? For instance add forums and catagory's but don't let a moderator remove them if they made a mistake.

[[Unknown]]

IMHO, if you want your global mod to be able to do that.... just make them an admin.

-[Unknown]

[Ian_S]

This is an awesome mod but it needs more features like being able to access the attachement manager (they are the gmods they should be allowed)... They should also be able to Repair All Boards and Topics and Recount All Board Totals...

[plugplay]

I had no problem installing the mod but am experiencing a small problem. Whenever I go to Admin > 'Installed 'Mods' Settings and Options ' and turn on the 'Global Moderator' options and click Save, I doesn't stay on. I am using WinNT. What can I be doing wrong?

Thanks

[[Unknown]]

You didn't get the rows inserted into your table.

If you prefer a PHP file over an SQL one, you can use this.... the dbmod.php is the same in the 1.4.1 version.

http://gbaetc.homeip.net/yypack/globalmod141.zip

-[Unknown]

[plugplay]

Is there any way to fix this without switching versions?

[[Unknown]]

Is there any way to fix this without switching versions?

You misunderstand.  The 1.4.1 database modifications still work for 1.5.1.  If you cannot get the 1.5.1 SQL to work, use the one from the 1.4.1 zip file.... it works for BOTH versions.

-[Unknown]

[plugplay]

The reason why I want to do the changes manually is because I cannot un-install the mod (errors). Is there any way to do the necessary changes to get this version to work? Thanks

[[Unknown]]

This is the query you need:

INSERT INTO {$db_prefix}settings VALUES ('gmodnews', '1'), ('gmodcensor', '1'), ('gmodreserve', '1'). ('gmodban', '1');

That puts all the settings into the database.  Works for version 1.4.1 and 1.5.x of this mod.

-[Unknown]

[plugplay]

Thanks [Unknown] ,

I an not exactly sure how to add those fields into the database and would appreciate the instuctions on how to do it manually. Again many thanks.