When someone beats a high score arcade automatically sends you a PM saying so and so beat ur high score. Now I was getting these messages from a non admin user which shouldnt have been sending them. I read one of your fax and edited my proarcade.php file with this
Joined: Jun 23, 2005 Posts: 582 Location: United States
Posted: Mon Apr 23, 2007 10:23 pm Post subject:
Greetings BooF and welcome to the boards! Apologies for the delay M8, been all over the place lately You may have to refresh my memory, for it has been awhile since I have messed with the script. Was there not an issue like this that had been common? Was this the fix you seek?
Quote:
ALTER TABLE nuke_users ADD user_allow_arcadepm TINYINT( 0 ) DEFAULT '1' NOT NULL;
If not, apologies for being useless. I remember when updating the MOD, there was a whole set of issues that had to be resolved. Unfortunately, did no documentation.
I actually already have that user in nuke_users except it looks like this
user_allow_arcadepm TINYINT( 4 ) DEFAULT '1' NOT NULL;
I removed user and re-added the way you gave me but it still shows up with TINYINT(4)
Im a MySQL beginner so that doesnt mean much to me and I dunno if thats even the problem.
As I stated the arcpm worked fine when I initially installed it but only for user ID 2 which the user with that ID is not the one that should be sending the arcpm. I changed it so the arcpm would be sent from user ID 42 which it does but the PM is blank with no content or subject. Its not even clickable.
Last edited by BooF on Tue Apr 24, 2007 6:15 pm; edited 1 time in total
Joined: Jun 23, 2005 Posts: 582 Location: United States
Posted: Fri Apr 27, 2007 3:14 pm Post subject:
Greetings, try this out. In fact, not so sure about this one. Do me a favor and compare with code you have now. I would, but a bit busy at the moment. This is from modules/Forums/proarcade.php.
Code:
$user_id = $row[1]['user_id'];
$sql = "SELECT user_allow_arcadepm FROM " . USERS_TABLE . " WHERE user_id = $user_id";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, "Error retrieving user arcade pm preference", '', __LINE__, __FILE__, $sql);
}
$row_check = $db->sql_fetchrow($result);
if ($row_check['user_allow_arcadepm'] == 1) {
$sql = "UPDATE " . USERS_TABLE . " SET user_new_privmsg = '1', user_last_privmsg = '9999999999' WHERE user_id = $user_id";
if (!($result = $db->sql_query($sql))) {
message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql);
}
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Forum FAQ
Search
Usergroups
Profile
Log in
You may have to refresh my memory, for it has been awhile since I have messed with the script. Was there not an issue like this that had been common? Was this the fix you seek?
