Benutzerinformationen überspringen
Registrierungsdatum: 16. März 2008
Wohnort: Murnau (hergezogen)
WBB Version: alle
Kenne das für´s wbb2.für´s wbblite noch nicht.Wer das irgendwo mal gesehen hat ,kann es gerne posten.Ich habe es noch nicht gefunden. Mich hatte jemand gefragt ob es sows gibt
Habe mich dann mal selber probiert.|
|
PHP-Quelltext |
1 |
if($board['countuserposts'] && $post['userid'] && $post['visible']==1) $db->unbuffered_query("UPDATE bb".$n."_users SET userposts=userposts-1 WHERE userid = '$post[userid]'",1);
|
|
|
PHP-Quelltext |
1 |
//if($board['countuserposts'] && $post['userid'] && $post['visible']==1) $db->unbuffered_query("UPDATE bb".$n."_users SET userposts=userposts-1 WHERE userid = '$post[userid]'",1);
|
|
|
PHP-Quelltext |
1 2 |
$result = $db->query("SELECT COUNT(postid) AS posts, userid FROM bb".$n."_posts WHERE postid IN ($postids) AND visible=1 AND userid>0 GROUP BY userid");
while($row=$db->fetch_array($result)) $db->unbuffered_query("UPDATE bb".$n."_users SET userposts=userposts-'$row[posts]' WHERE userid='$row[userid]'",1);
|
|
|
PHP-Quelltext |
1 2 |
//$result = $db->query("SELECT COUNT(postid) AS posts, userid FROM bb".$n."_posts WHERE postid IN ($postids) AND visible=1 AND userid>0 GROUP BY userid");
//while($row=$db->fetch_array($result)) $db->unbuffered_query("UPDATE bb".$n."_users SET userposts=userposts-'$row[posts]' WHERE userid='$row[userid]'",1);
|
|
|
PHP-Quelltext |
1 2 |
$result = $db->query("SELECT COUNT(postid) AS posts, userid FROM bb".$n."_posts WHERE threadid='$threadid' AND visible=1 AND userid>0 GROUP BY userid");
while($row=$db->fetch_array($result)) $db->query("UPDATE bb".$n."_users SET userposts=userposts-'$row[posts]' WHERE userid='$row[userid]'");
|
|
|
PHP-Quelltext |
1 2 |
//$result = $db->query("SELECT COUNT(postid) AS posts, userid FROM bb".$n."_posts WHERE threadid='$threadid' AND visible=1 AND userid>0 GROUP BY userid");
// while($row=$db->fetch_array($result)) $db->query("UPDATE bb".$n."_users SET userposts=userposts-'$row[posts]' WHERE userid='$row[userid]'");
|
|
|
PHP-Quelltext |
1 2 3 4 5 6 |
if($newboard['countuserposts']==1) {
$result = $db->query("SELECT COUNT(postid) AS posts, userid FROM bb".$n."_posts WHERE threadid='$newthreadid' AND visible = 1 AND userid>0 GROUP BY userid");
while($row=$db->fetch_array($result)) $db->query("UPDATE bb".$n."_users SET userposts=userposts+'$row[posts]' WHERE userid='$row[userid]'");
}
}
}
|
|
|
PHP-Quelltext |
1 2 3 4 5 6 |
//if($newboard['countuserposts']==1) {
//$result = $db->query("SELECT COUNT(postid) AS posts, userid FROM bb".$n."_posts WHERE threadid='$newthreadid' AND visible = 1 AND userid>0 GROUP BY userid");
// while($row=$db->fetch_array($result)) $db->query("UPDATE bb".$n."_users SET userposts=userposts+'$row[posts]' WHERE userid='$row[userid]'");
}
}
|
Einbau auf eigene Gefahr.Backup der zu bearbeitenden Dateien machen.
Benutzerinformationen überspringen
Registrierungsdatum: 16. März 2008
Wohnort: Murnau (hergezogen)
WBB Version: alle

Ich wollte es ja auch erst auskommentieren
Benutzerinformationen überspringen
Registrierungsdatum: 22. März 2008
Wohnort: Lohr
WBB Version: alle
|
|
PHP-Quelltext |
1 2 |
/*$result = $db->query("SELECT COUNT(postid) AS posts, userid FROM bb".$n."_posts WHERE postid IN ($postids) AND visible=1 AND userid>0 GROUP BY userid");
while($row=$db->fetch_array($result)) $db->unbuffered_query("UPDATE bb".$n."_users SET userposts=userposts-'$row[posts]' WHERE userid='$row[userid]'",1);*/
|
Benutzerinformationen überspringen
Registrierungsdatum: 16. März 2008
Wohnort: Murnau (hergezogen)
WBB Version: alle
|
|
PHP-Quelltext |
1 2 3 4 |
/* if($newboard['countuserposts']==1) {
$result = $db->query("SELECT COUNT(postid) AS posts, userid FROM bb".$n."_posts WHERE threadid='$newthreadid' AND visible = 1 AND userid>0 GROUP BY userid");
while($row=$db->fetch_array($result)) $db->query("UPDATE bb".$n."_users SET userposts=userposts+'$row[posts]' WHERE userid='$row[userid]'");*/
}
|

|
|
PHP-Quelltext |
1 2 3 4 5 |
/* if($newboard['countuserposts']==1) {
$result = $db->query("SELECT COUNT(postid) AS posts, userid FROM bb".$n."_posts WHERE threadid='$newthreadid' AND visible = 1 AND userid>0 GROUP BY userid");
while($row=$db->fetch_array($result)) $db->query("UPDATE bb".$n."_users SET userposts=userposts+'$row[posts]' WHERE userid='$row[userid]'");*/
}
}
|
Zitat
Zur letzten Anweisung: Wenn du ein if auskommentierst, welches eine { öffnet, musst du auch die entsprechende } auskommentieren. Also hier einfach eine weitere Klammer auskommentieren.
|
|
PHP-Quelltext |
1 2 3 4 |
/*
$result = $db->query("SELECT COUNT(postid) AS posts, userid FROM bb".$n."_posts WHERE threadid='$newthreadid' AND visible = 1 AND userid>0 GROUP BY userid");
while($row=$db->fetch_array($result)) $db->query("UPDATE bb".$n."_users SET userposts=userposts+'$row[posts]' WHERE userid='$row[userid]'");
*/
|
Benutzerinformationen überspringen
Registrierungsdatum: 16. März 2008
Wohnort: Murnau (hergezogen)
WBB Version: alle

|
|
PHP-Quelltext |
1 |
if($board['countuserposts'] && $post['userid'] && $post['visible']==1) $db->unbuffered_query("UPDATE bb".$n."_users SET userposts=userposts-1 WHERE userid = '$post[userid]'",1);
|
|
|
PHP-Quelltext |
1 |
/*if($board['countuserposts'] && $post['userid'] && $post['visible']==1) $db->unbuffered_query("UPDATE bb".$n."_users SET userposts=userposts-1 WHERE userid = '$post[userid]'",1);*/
|
|
|
PHP-Quelltext |
1 2 |
$result = $db->query("SELECT COUNT(postid) AS posts, userid FROM bb".$n."_posts WHERE threadid='$threadid' AND visible=1 AND userid>0 GROUP BY userid");
while($row=$db->fetch_array($result)) $db->query("UPDATE bb".$n."_users SET userposts=userposts-'$row[posts]' WHERE userid='$row[userid]'");
|
|
|
PHP-Quelltext |
1 2 |
/* $result = $db->query("SELECT COUNT(postid) AS posts, userid FROM bb".$n."_posts WHERE threadid='$threadid' AND visible=1 AND userid>0 GROUP BY userid");
while($row=$db->fetch_array($result)) $db->query("UPDATE bb".$n."_users SET userposts=userposts-'$row[posts]' WHERE userid='$row[userid]'");*/
|
|
|
PHP-Quelltext |
1 2 |
$result = $db->query("SELECT COUNT(postid) AS posts, userid FROM bb".$n."_posts WHERE postid IN ($postids) AND visible=1 AND userid>0 GROUP BY userid");
while($row=$db->fetch_array($result)) $db->unbuffered_query("UPDATE bb".$n."_users SET userposts=userposts-'$row[posts]' WHERE userid='$row[userid]'",1);
|
|
|
PHP-Quelltext |
1 2 |
/* $result = $db->query("SELECT COUNT(postid) AS posts, userid FROM bb".$n."_posts WHERE postid IN ($postids) AND visible=1 AND userid>0 GROUP BY userid");
while($row=$db->fetch_array($result)) $db->unbuffered_query("UPDATE bb".$n."_users SET userposts=userposts-'$row[posts]' WHERE userid='$row[userid]'",1);*/
|
|
|
PHP-Quelltext |
1 |
if($newboard['countuserposts']==1)
|
|
|
PHP-Quelltext |
1 |
/*if($newboard['countuserposts']==1)*/
|
|
|
PHP-Quelltext |
1 |
$result=$db->query("SELECT userid, userposts FROM bb".$n."_users ORDER BY userid ASC",$perpage,$perpage*($page-1));
|
|
|
PHP-Quelltext |
1 |
/*$result=$db->query("SELECT userid, userposts FROM bb".$n."_users ORDER BY userid ASC",$perpage,$perpage*($page-1));*/
|
Feedback erwünscht
|
|
PHP-Quelltext |
1 |
//
|
Benutzerinformationen überspringen
Registrierungsdatum: 16. März 2008
Wohnort: Murnau (hergezogen)
WBB Version: alle
Forensoftware: Burning Board® 3.1.7, entwickelt von WoltLab® GmbH