Suspend Posting Ability?

[Beverly]

Hi Grudge,

Let me understand the general idea:
If a user gets to >500 posts and isn't a member of (for example) "paid" membergroup then they cannot post a reply on your board?

Correct! Someone had suggested that the emil/IM be sent notifying them that their ability to post WOULD be suspended, say at post 450, so they can join prior to being suspended.

I would appreciate any and all help! I am pretty noob at this stuff!

Beverly

[Grudge]

OK. I think I have got it all working OK. The code for sending the IM is a little messy but appears to work fine. This is what the MOD does at the moment:

In the mod settings menu on the admin screen there are several options:-
* Select amount of posts to send warning IM at
* Select amount of posts to suspend posts at
* Select membergroups except from this
* Select subject line for IM
* Select message for IM
* Select message to display when banned from posting

Now, admins AND global moderators are both excluded from the suspension (as I assume they are all paid up/need to be able to reply!).

What you need to do to use the mod is create a membergroup for all those people who have paid (maybe called Contributer?) Then add this membergroup to the list of groups except from posting. Then go through all the members who have paid and make them a member of this group.

Now... whenever a member makes a reply to a thread/ new thread it will check if they are part of the except member groups and if not it will check there post counts. If they have over the maximum amount they will get an error message with the message you entered on the mod settings screen. If they have not reached this limit, on the post which takes them over the IM warning limit they will be sent an IM. The IM will look like it is sent from the board name and a reply will go to the admin (I think!). A notification email will be sent to the user REGARDLESS of whether the user has notification enabled.

I've tested this as much as I can and it seems to work - but I haven't been able to try it on a busy board. Obviously insert normal disclaimer here about not being liable to any damage caused by this mod etc etc. If you find any bugs I will do my best to rectify them ASAP!

Anyway - you need to run this db file from your forum directory:
http://www.p0stwh0res.com/bins/mod/suspenduserdb.php

and then use this boardmod file:
http://www.p0stwh0res.com/bins/mod/suspend_user.mod

I have tested this on 1.5.3 on a clean installation and it works fine.

Hope this helps

[Beverly]

Hi Grudge,

OK I made the changes in the suspend_user.mod and uploaded to their various locations.

BUT when I ran suspenduserdb.php I got a LOT of errors,,, Looks to me like it is a PATH problem?


Warning: main(Settings.php): failed to open stream: No such file or directory in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 53

Warning: main(): Failed opening 'Settings.php' for inclusion (include_path='.;c:\php4\pear') in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 53

Notice: Undefined variable: db_server in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 55

Notice: Undefined variable: db_user in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 55

Notice: Undefined variable: db_passwd in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 55

Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10061) in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 55

Notice: Undefined variable: db_name in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 56

Warning: mysql_select_db(): Can't connect to MySQL server on 'localhost' (10061) in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 56

Warning: mysql_select_db(): A link to the server could not be established in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 56

Notice: Undefined variable: db_prefix in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 60

Warning: mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 60

Warning: mysql_query(): A link to the server could not be established in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 60
Table: Can't connect to MySQL server on 'localhost' (10061) Allready Exists, Skipping.

Notice: Undefined variable: db_prefix in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 66

Warning: mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 66

Warning: mysql_query(): A link to the server could not be established in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 66
Table: Can't connect to MySQL server on 'localhost' (10061) Allready Exists, Skipping.

Notice: Undefined variable: db_prefix in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 72

Warning: mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 72

Warning: mysql_query(): A link to the server could not be established in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 72
Table: Can't connect to MySQL server on 'localhost' (10061) Allready Exists, Skipping.

Notice: Undefined variable: db_prefix in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 78

Warning: mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 78

Warning: mysql_query(): A link to the server could not be established in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 78
Table: Can't connect to MySQL server on 'localhost' (10061) Allready Exists, Skipping.

Notice: Undefined variable: db_prefix in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 84

Warning: mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 84

Warning: mysql_query(): A link to the server could not be established in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 84
Table: Can't connect to MySQL server on 'localhost' (10061) Allready Exists, Skipping.

Notice: Undefined variable: db_prefix in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 90

Warning: mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 90

Warning: mysql_query(): A link to the server could not be established in D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php on line 90
Table: Can't connect to MySQL server on 'localhost' (10061) Allready Exists, Skipping.

There were 6 existing records when upgrading your SQL.

Ya know I think I see the problem,,,

the link you gave me

http://www.p0stwh0res.com/bins/mod/suspenduserdb.php

I rt clicked and save link target as,,, BUT it RAN on your server and I just got the error page!

I just opened the suspenduserdb.php copy I have on my computer and it ONLY has the error messages in it. Perhaps you need to zip or send me the file by email?

Beverly

[[Unknown]]

Make sure you have a copy of Settings.php in the same directory as the dbmod.

-[Unknown]

[Beverly]

Unknown,

The code of the suspenduserdb.php Looks like this:

<html>
<head>
   <title>YaBB SE DataBase Editor</title>
<style>
<!--
body {
   font-family : Verdana;
   font-size : 10pt;
}
td {
   font-size : 10pt;
}
-->
</style>
</head>
<body bgcolor="#FFFFFF">
<center><table border=0 cellspacing=1 cellpadding=4 bgcolor="#000000" width=90%>
<tr>
   <th bgcolor="#34699E"><font color="#FFFFFF">YaBB SE DB Editor</font></th>
</tr>
<tr>
<td bgcolor="#FFFFFF">
<br />
<b>Warning</b>:  main(Settings.php): failed to open stream: No such file or directory in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>53</b><br />
<br />
<b>Warning</b>:  main(): Failed opening 'Settings.php' for inclusion (include_path='.;c:\php4\pear') in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>53</b><br />
<br />
<b>Notice</b>:  Undefined variable:  db_server in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>55</b><br />
<br />
<b>Notice</b>:  Undefined variable:  db_user in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>55</b><br />
<br />
<b>Notice</b>:  Undefined variable:  db_passwd in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>55</b><br />
<br />
<b>Warning</b>:  mysql_connect(): Can't connect to MySQL server on 'localhost' (10061) in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>55</b><br />
<br />
<b>Notice</b>:  Undefined variable:  db_name in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>56</b><br />
<br />
<b>Warning</b>:  mysql_select_db(): Can't connect to MySQL server on 'localhost' (10061) in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>56</b><br />
<br />
<b>Warning</b>:  mysql_select_db(): A link to the server could not be established in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>56</b><br />
<br />
<b>Notice</b>:  Undefined variable:  db_prefix in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>60</b><br />
<br />
<b>Warning</b>:  mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>60</b><br />
<br />
<b>Warning</b>:  mysql_query(): A link to the server could not be established in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>60</b><br />
<font color=red>Table: Can't connect to MySQL server on 'localhost' (10061) Allready Exists, Skipping.</font><BR><br />
<b>Notice</b>:  Undefined variable:  db_prefix in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>66</b><br />
<br />
<b>Warning</b>:  mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>66</b><br />
<br />
<b>Warning</b>:  mysql_query(): A link to the server could not be established in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>66</b><br />
<font color=red>Table: Can't connect to MySQL server on 'localhost' (10061) Allready Exists, Skipping.</font><BR><br />
<b>Notice</b>:  Undefined variable:  db_prefix in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>72</b><br />
<br />
<b>Warning</b>:  mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>72</b><br />
<br />
<b>Warning</b>:  mysql_query(): A link to the server could not be established in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>72</b><br />
<font color=red>Table: Can't connect to MySQL server on 'localhost' (10061) Allready Exists, Skipping.</font><BR><br />
<b>Notice</b>:  Undefined variable:  db_prefix in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>78</b><br />
<br />
<b>Warning</b>:  mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>78</b><br />
<br />
<b>Warning</b>:  mysql_query(): A link to the server could not be established in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>78</b><br />
<font color=red>Table: Can't connect to MySQL server on 'localhost' (10061) Allready Exists, Skipping.</font><BR><br />
<b>Notice</b>:  Undefined variable:  db_prefix in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>84</b><br />
<br />
<b>Warning</b>:  mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>84</b><br />
<br />
<b>Warning</b>:  mysql_query(): A link to the server could not be established in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>84</b><br />
<font color=red>Table: Can't connect to MySQL server on 'localhost' (10061) Allready Exists, Skipping.</font><BR><br />
<b>Notice</b>:  Undefined variable:  db_prefix in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>90</b><br />
<br />
<b>Warning</b>:  mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>90</b><br />
<br />
<b>Warning</b>:  mysql_query(): A link to the server could not be established in <b>D:\DO_NOT_DELETE\http\bins\mod\suspenduserdb.php</b> on line <b>90</b><br />
<font color=red>Table: Can't connect to MySQL server on 'localhost' (10061) Allready Exists, Skipping.</font><BR></td></tr></table><P>There were <B>6</B> existing records when upgrading your SQL.

SO there is nothing there to RUN?

Beverly

[haase]

    chuckle.

Perhaps if he renamed it .txt or something, you could actually download it...  just clicking on it in that post, it's like we're trying to navigate to a page on his website.  That's why it's returning HTML...  when you click on it, it runs on his server, and then gives you the HTML output.

I hope we haven't messed up anything on his server by running it.

[Wamplet]

Hello, I am Grudge's friend over at his P0stwh0res site.

He said he is having DNS issues and cannot browse these forums correctly.  

In either case, he has asked me to post on behalf of himself.


Here is our chatlog excerpt that he wanted me to post:


Basically - I need the reply to say that the link for the db files is now:
http://www.p0stwh0res.com/bins/mod/suspenduserdb.txt

That I'm sorry I can't reply myself as I'm having a network problem and say that the file needs to be renamed to php after they save it!

[Beverly]

Hi Grudge's friend  

Thanks so much for the help, both you and Grudge!

I will be implementing this on Monday, so will let you know how it goes!

THANKS SOOOOOOOOOOO  Much for the help.

Beverly