topic reply automessage not working

[honkytonkman]

this is part of genproc.php on wapdesire

 if($res)
      {
        $usts = mysql_fetch_array(mysql_query("SELECT posts, plusses FROM ibwf_users WHERE id='".$uid."'"));
        $res2 = mysql_fetch_array(mysql_query("SELECT name, authorid FROM ibwf_topics WHERE id='".$tid."'"));
      $usr = getnick_uid($uid);
      $tname = htmlspecialchars($res2[0]);
      if(($res2[1]!=$uid)&&(automsgs($res2[1]))){
      $msg = "Your Topic [topic=$tid]$tname"."[/topic] has been Replied to by $usr [br/][small][i]p.s: this is an automated pm[/i][/small]";
      autopm($msg, $res2[1]);
        }

the trouble is ..the automated pm gos on database but
it don't show on inbox of user (appears alert of 1 new message ,but
nothing inside..ghost inbox)

i don't find the error

[morse]

add autopm() funtion here from your core.php

[honkytonkman]

function autopm($msg, $who)
{
mysql_query("INSERT INTO ibwf_private SET text='".$msg."', byuid='1', touid='".$who."', unread='1', timesent='".time()."'");

}
is this?..

[ranzit2]

Change admin uid=1 from database

[morse]

see if the first id of the site does exist or not i.e som1 should have the id number 1, if there is nobody then it will remain a ghost pm

[something else]

could update autopm to:

function autopm($msg, $who,$from)
{
if($from==""){
$from = $who;
}

mysql_query("INSERT INTO ibwf_private SET text='".$msg."', byuid='".$from."', touid='".$who."', unread='1', timesent='".time()."'");

}

that way if u need to you can select who its from aswell

[CreativityKills]

Just go to db, edit ur id to 1 in ibwf_users.
If ure one of those lazy turds, quickly make a file in ur web folder and paste this:

<?php
include_once "config.php";
include "core.php";
if(mysql_query("UPDATE ibwf_users SET id='1
' WHERE name='INSERT_OWNER_USERNAME_HERE'")){
echo 'done, now delete this file';
}else{
echo mysql_error().'. . .meaning. . .mysql is high on drugs nw and cant complete ur request, or its likely u got d wrng table or maybe ure high or sumtin';
}
?>

run this file in ur web browser then DELETE IT if its working. NOTE, pms u sent to ppl will mysteriously disappear.

[CreativityKills]

Or if ur reeeally lazy, change the 1 in the autopm to ur user id.

[something else]

if you updating user id dont forget to change user id in forums and pms etc: sql aswell

[CreativityKills]

I'l translate What something else just said into sql language:
UPDATE ibwf_topics SET authorid='1' WHERE authorid='FORMER_USER_ID'";
UPDATE ibwf_posts SET uid='1' WHERE uid='FORMER_USER_ID'";
UPDATE ibwf_private SET byuid='1' WHERE byuid='FORMER_UID'";
UPDATE ibwf_private SET touid='1' WHERE touid='FORMER UID'";

U cud do more for ibwf_buds etc.