vb.org Archive
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Mini Mods - Auto-PM to Staff when a User is Banned (https://vborg.vbsupport.ru/showthread.php?t=118919)

Alan @ CIT 06-25-2006 04:30 PM
Sorry, this modification is only supported on vBulletin 3.6 Beta 2 or above.

Thanks,
Alan.

Adrian Schneider 06-25-2006 04:32 PM
Quote:
Originally Posted by bashy
Hi

After reading this post i went ahead and tried to install this but got this error
I am on 3.5.4
any ideas please?

Code:
Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
        (`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
        ('1', '5', 'AutoPM Staff on Ban', 'userdata_postsave', 'if ($usergroups_changed)\r\n{\r\n        // Check to see if the user has just been banned (in the last 10 seconds)\r\n        $ban_info_q = \"SELECT ban.userid, user.username\r\n                FROM \" . TABLE_PREFIX . \"userban AS ban\r\n                LEFT JOIN \" . TABLE_PREFIX . \"user AS user ON (ban.userid = user.userid)\r\n                WHERE ban.userid = \" . intval($userid) . \"\r\n                AND bandate > \" . (TIMENOW - 10) . \"\r\n                ORDER BY bandate DESC\r\n                LIMIT 1\";\r\n\r\n        if ($ban_info_a = $this->dbobject->query_first($ban_info_q))\r\n        {\r\n                // Users just been banned, so fetch the list of admins/mods to PM\r\n                $recipients_q = \"SELECT users.userid, users.username\r\n                        FROM \" . TABLE_PREFIX . \"user AS users\r\n                        LEFT JOIN \" . TABLE_PREFIX . \"administrator AS admins ON (admins.userid = users.userid)\r\n                        LEFT JOIN \" . TABLE_PREFIX . \"moderator AS mods ON (mods.userid = users.userid)\r\n                        WHERE users.userid IN (admins.userid)\r\n                        OR users.userid IN (mods.userid)\";\r\n\r\n                $recipients_r = $this->dbobject->query_read($recipients_q);\r\n\r\n                while ($recipients_a = $this->dbobject->fetch_array($recipients_r))\r\n                {\r\n                        $pmto_a[$recipients_a[\'userid\']] = $recipients_a[\'username\'];\r\n                }\r\n\r\n                // Create the final recipients list for the PM, removing the current user from the PM list\r\n                unset($pmto_a[$this->registry->userinfo[\'userid\']]);\r\n                $recipients = implode(\';\', $pmto_a);\r\n\r\n                global $vbphrase;\r\n\r\n                // Prepare the message title\r\n                $pm_title = construct_phrase(\r\n                        $vbphrase[\'x_has_been_banned\'],\r\n                        $ban_info_a[\'username\']\r\n                );\r\n\r\n                // Prepare the message text\r\n                $pm_text = construct_phrase(\r\n                        $vbphrase[\'autopm_on_ban_message\'],\r\n                        $ban_info_a[\'username\'],\r\n                        $this->registry->userinfo[\'username\']\r\n                );\r\n\r\n                // Send the PM\r\n                $force_it_baby[\'adminpermissions\'] = 2;\r\n                \r\n                $pm =& datamanager_init(\'PM\', $this->registry, ERRTYPE_SILENT);\r\n                $pm->set(\'fromuserid\', $this->registry->userinfo[\'userid\']);\r\n                $pm->set(\'fromusername\', $this->registry->userinfo[\'username\']);\r\n                $pm->set(\'title\', $pm_title);\r\n                $pm->set(\'message\', $pm_text);\r\n                $pm->set_recipients($recipients, $force_it_baby);\r\n                $pm->set(\'dateline\', TIMENOW);\r\n\r\n                if (!$pm->errors)\r\n                {        \r\n                        // No errors, so send the PM\r\n                        $pm->save();\r\n                }\r\n        }\r\n\r\n}', 'cit_pm_on_ban');

MySQL Error  : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date        : Sunday, June 25th 2006 @ 04:31:25 AM
Script      : http://www.bashys-place.com/forums/admincp/plugin.php
Referrer    : http://www.bashys-place.com/forums/admincp/plugin.php?do=productadd
Guys the "executionorder" field was added in vBulletin 3.6.

bashy 06-25-2006 05:27 PM
The only reason why i have tried this is because of what you said in another thread....

Quote:
https://vborg.vbsupport.ru/showthread.php?t=118919 - Should work fine with 3.5.4, but if you have any problems, let me know.
Hence trying this out.......its the part that says "but if you have any problems, let me know"
is why i posted here asking fro help...

Quote:
Originally Posted by Alan @ CIT
Sorry, this modification is only supported on vBulletin 3.6 Beta 2 or above.

Thanks,
Alan.

Alan @ CIT 06-25-2006 07:08 PM
"should" is the key word in my sentance :)

Thanks,
Alan.

bashy 06-25-2006 08:02 PM
Fair enough, thanks anyway!!

klaush 06-25-2006 08:02 PM
Quote:
Originally Posted by Alan @ CIT
"should" is the key word in my sentance :)

Thanks,
Alan.
So, Alan, can you port this to 3.5.x, or is it too difficult?

Alan @ CIT 06-26-2006 10:28 AM
Sorry, but I have no plans to back-port any of my 3.6 hacks to work with 3.5.x

Thanks,
Alan.

Eagle Creek 08-12-2006 06:27 PM
Am I able to edit the staff UG's?

Cause I have Admins, S-mods, Beheer, Mods.. They are all part of my forum staff.

php 08-13-2006 07:42 AM
looks and seems very nice, Thank You

Ncturnal 08-25-2006 09:20 PM
How can I limit the people this goes out to, like say just to admins. This was sent to anyone who can mod a particular forum and thus went to a lot of people we really didn't want seeing that message.


All times are GMT. The time now is 01:56 PM.
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01117 seconds
  • Memory Usage 1,749KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete