[Aphrodite] Yellow Card Mod

[Case]

Code: Select all

code removed

[UseLess]

Greetings,

Well that looks fine in which case it's probably a problem with the auth array and possibly the auth table you may need to add the missing 'AUTH_' bits to the arrays for the extra user levels you've added and then go through every forum checking the permissions, it's easier if you use the permissions list so all forum permissions are displayed on a single page you can then set them all in one go. However this will possibly mean adding a mod to do it, unless you already have the mod installed and then any mods you've added to 'admin/admin_forumauth.php' will also need adding to 'admin/admin_forumauth_list.php' (or whatever the file is called for the list mod you install).

[Case]

I'm guessing there's no plan B that works for people who don't understand auth array's and adding missing AUTH_ bits?



Seems strange that it actually works fine. Guests or normal users can't actually ban/warn anyone but they can see the buttons.

I've tried setting the permissions to ADMIN but as a guest I can still see the buttons.

[Case]

I just noticed that when changing a users level to Administrator I get this error:

Couldn't update auth access

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'group_id = 17' at line 3

UPDATE phpbb_auth_access SET auth_view = 0, auth_read = 0, auth_post = 0, auth_reply = 0, auth_edit = 0, auth_delete = 0, auth_sticky = 0, auth_announce = 0 , auth_ban = 0, auth_greencard = 0, auth_bluecard = 0WHERE group_id = 17

Line : 204
File : admin_ug_auth.php

Could this have something to do with it?

Code: Select all

//
         // Delete any entries in auth_access, they are not required if user is becoming an
         // admin
         //
         $sql = "UPDATE " . AUTH_ACCESS_TABLE . "
            SET auth_view = 0, auth_read = 0, auth_post = 0, auth_reply = 0, auth_edit = 0, auth_delete = 0, auth_sticky = 0, auth_announce = 0, auth_ban = 0, auth_greencard = 0, auth_bluecard = 0WHERE group_id = $group_id";
         if ( !($result = $db->sql_query($sql)) )
         {
            message_die(GENERAL_ERROR, "Couldn't update auth access", "", __LINE__, __FILE__, $sql);
         }
      }

[Reiji Kurosaky]

Code: Select all

Couldn't update auth access

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'group_id = 17' at line 3

UPDATE phpbb_auth_access SET auth_view = 0, auth_read = 0, auth_post = 0, auth_reply = 0, auth_edit = 0, auth_delete = 0, auth_sticky = 0, auth_announce = 0 , auth_ban = 0, auth_greencard = 0, auth_bluecard = [highlight]0WHERE[/highlight] group_id = 17

Line : 204
File : admin_ug_auth.php

This is your error.

[Case]

Ah right.

I've corrected that error now but it hasn't made any difference to my original problem with the Yellow card mod.

Thank you anyway.

[Case]

Useless, any chance you could expand a bit on what I need to do to correct this error? Or have you pretty much posted everything I need to know?

No rush, just whenever you have the chance.

Thanks.

[Tasadduqkhan]

I am trying to install this mod but the tpls for subsilver are making me feel bad. I want to instal it for aphrodite but dont know what to edit.
Where should I start?

[Case]

Download this file Useless posted in his first post and follow the instructions.

http://custombuiltsoftware.co.uk/downlo ... rodite.zip

[Tasadduqkhan]

This is just the update to the previous yellow card hack.
I want to know how to edit the tpls of template (aphrodite)
Hoping you get it.
Thanks

[Tasadduqkhan]

I tried to install Yellow Card Mod using Easy mod every thing went fine but yellow card mod isn't showing up. Anyways I dont want to do it using Easy mod. So I need guidance to install it on ca_aphrodite.
Anyone ?

THanks

[Tasadduqkhan]

SOrry for posting so much.


http://img404.imageshack.us/img404/9472/navmenu0xw.jpg

The above image is the thing I got in my ACP but this isn't working.

What went wrong.

THanks

[Tasadduqkhan]

Anyhelp?

[UseLess]

Greetings,

Tasaddugkhan: You need to install the mod as detailed in the install file for the mod, the best thing do to is install the mod into subSilver and then see if it's all working as it should. If or when it is you can then alter the template files for the style your using and if it then does not work you know it's a template problem and not a php problem. You can then make the changes as detailed in this post to get it working with Aphrodite.

Case: do this;

Code: Select all

#
#-----[ OPEN ]-------------------------------------------------------
#

viewtopic.php

#
#-----[ FIND ]-------------------------------------------------------
#

$sql = "SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments" . $count_sql . "

#
#-----[ REPLACE WITH ]-----------------------------------------------
#

$sql = "SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments, f.auth_ban, f.auth_greencard, f.auth_bluecard" . $count_sql . "

#
#-----[ SAVE/CLOSE ALL FILES ]---------------------------------------
#
# EoM

as you can see you missed something... and sorry for the delay but been a little busy.

[Case]

Aghh! That's what it was?

I've give this a try later then.

Great stuff Useless, thanks again.