Visual Warning Mod

[Kindred]

Chris,

Despite the lack of an actual QUESTION in your post, I assume you are asking "Why do I get this error and how do I fix it?".

You appear to have installed the mod twice.
You will have to go through the code and remove the double entries...

[Chris™]

Thought i put that in my post :\ and wouldnt it appear if it was installed once after i un installed it?

[Kindred]

not if you had a failed install one time...   the install was partial but failed midway means that some of the code was changed, but the installation did not complete, hence the "installed" flag was not set.

[BlackMagic48]

Visual warning 1.32 works with 1.1.2.
Please read the description, before posting. 

I'm not the author of this mod, so I can't update the information on this page.
If a moderator can do it, it would be nice. 

Despite this, it still says that the mod is not compatible with my forum.

[123kid]

could you help me out on how to make this mod work for moderators?

coz it only works on admin group! Moderators cant even see the warn button to make use for punk members

thnx in advance!!!

more power to you guyz!

[Eleglin]

Give the permissions for modérators on "members settings".

[dumbelljunkie]

I have seen this error message several times on this topic but still no real answers :

Code Select Expand

Databasefout: 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 ')
ORDER BY mem.lngfile
LIMIT 0' at line 8
Bestand: /home/vhosts/powerlifting-forum.nl/httpdocs/new_forum/Sources/Subs-Post.php
Regel: 771

Running on 1.1.2. It does seem to show the warning in the post

This is de sub-post.php lines 760 to 774

Code Select Expand

$request = db_query("
SELECT
mem.memberName, mem.realName, mem.ID_MEMBER, mem.emailAddress, mem.lngfile, mg.maxMessages,
mem.pm_email_notify, mem.instantMessages," . (allowedTo('moderate_forum') ? ' 0' : "
(mem.pm_ignore_list = '*' OR FIND_IN_SET($from[id], mem.pm_ignore_list))") . " AS ignored,
FIND_IN_SET($from[id], mem.buddy_list) AS is_buddy, mem.is_activated,
(mem.ID_GROUP = 1 OR FIND_IN_SET(1, mem.additionalGroups)) AS is_admin
FROM {$db_prefix}members AS mem
LEFT JOIN {$db_prefix}membergroups AS mg ON (mg.ID_GROUP = IF(mem.ID_GROUP = 0, mem.ID_POST_GROUP, mem.ID_GROUP))
WHERE mem.ID_MEMBER IN (" . implode(", ", $all_to) . ")
ORDER BY mem.lngfile
LIMIT " . count($all_to), __FILE__, __LINE__);
$notifications = array();
while ($row = mysql_fetch_assoc($request))
{

[qd-race]

Good mod. I need to mod for the other theme.

[Vampy]

This may be a stupid question and if it's been asked already then I apologise, but are the warnings viewable by all members or just board mods, Global mods and admins? Oh and does the warned member recieve an email or PM with the details of the warning?

I'd like a warning system in place but I don't want everyone to see who's been warned, how and why, just the mods etc

[Kindred]

As designed, the warning is visible to everyone.  (the whole point of a visual warning, after all)

the warning recipient receives a PM on the warned post.


you could modify it to only display the warning to mods, etc...   (but that defeats to purpose, IMO)

[123kid]

Give the permissions for modérators on "members settings".

thnx for this sir

more power!

[sharks]

i have an error when warn a post and this is error message

Code Select Expand

Hacking attempt...

UPDATE smf_messages
SET body = 'day co fai la lan ca'c oppa o thailand ko nhi?

[center][img]http://xxxxxxxx/forums/Themes/default/images/warnwarn.gif[/img] [color=green][/color][/center]'
WHERE ID_MSG = 26141
File: /home/xxxxxxxx/domains/xxxxxxxx/public_html/forums/Sources/VisualWarning.php
Line: 147


i think it's because of " ' " . how can i solve this problem ?
thx u

i get the same error, and reading from all the replies, it seems like this problem hasnt been fixed yet

can someone please consider to debug the visualwarning.php file on line 147 and explain in layman terms how do i fix it.
am about to drop this mod due to the excessive problems when using it, specifically the "hacking attempt..." error.

[sjmarsha]

I'm getting a few test faileds on this. Can someone help me with how to manually install on the following?

7.    Execute Modification    ./Sources/Post.php    Test failed
9.    Execute Modification    ./Sources/Karma.php    Test failed
10.    Execute Modification    ./Sources/Subs.php    Test failed

[tensop]

I have seen this error message several times on this topic but still no real answers :

Code Select Expand

Databasefout: 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 ')
ORDER BY mem.lngfile
LIMIT 0' at line 8
Bestand: /home/vhosts/powerlifting-forum.nl/httpdocs/new_forum/Sources/Subs-Post.php
Regel: 771

Running on 1.1.2. It does seem to show the warning in the post

This is de sub-post.php lines 760 to 774

Code Select Expand

$request = db_query("
SELECT
mem.memberName, mem.realName, mem.ID_MEMBER, mem.emailAddress, mem.lngfile, mg.maxMessages,
mem.pm_email_notify, mem.instantMessages," . (allowedTo('moderate_forum') ? ' 0' : "
(mem.pm_ignore_list = '*' OR FIND_IN_SET($from[id], mem.pm_ignore_list))") . " AS ignored,
FIND_IN_SET($from[id], mem.buddy_list) AS is_buddy, mem.is_activated,
(mem.ID_GROUP = 1 OR FIND_IN_SET(1, mem.additionalGroups)) AS is_admin
FROM {$db_prefix}members AS mem
LEFT JOIN {$db_prefix}membergroups AS mg ON (mg.ID_GROUP = IF(mem.ID_GROUP = 0, mem.ID_POST_GROUP, mem.ID_GROUP))
WHERE mem.ID_MEMBER IN (" . implode(", ", $all_to) . ")
ORDER BY mem.lngfile
LIMIT " . count($all_to), __FILE__, __LINE__);
$notifications = array();
while ($row = mysql_fetch_assoc($request))
{

yep, same error here

[p-chan]

hihi..I am using smf 1.1.2..when i tried installing the mod, I was told that there are 3 errors:
./Sources/Subs.php
./Sources/Karma.php
./Sources/Post.php

Any idea how to solve this? =)

[Kindred]

sounds like conflicts with existing modifications

you will have to apply the mod manually, looking for the correct code and using human intelligence to figure out what in the modified code looks correct.

[Hendricius]

I keep getting "Invalid Request Variable" when I submit some Visual Warning Mod actions.. I have several mods installed. Could you please tell me which template I need to remodify?

[Kindred]

without seeing the actual errors, we can't even begin to imagine...

[HecKel]

Hi!

I love this MOD, but my user's favorite theme is Saf-Multicolor..., how can I manually install this mod in this theme? I Can't find Post.template.php..., where should I put that code? Or is any version of this MOD to Saf-Multicolor?

Thanks in advance

HecKel

[Kindred]

if you do not have a post.template.php in your theme, then it will use the one in the dfeault directory and you don't have to do anything...

however, there are a bunch of other template files which I assume you WILL have to modify manually, to get it working on your theme, including display.template.php