coś w tym stylu?
<?php
require_once( 'wp-blog-header.php' );
// pobieranie komentarzy z pliku z tablicy
require( 'komentarze.php' );
// pobieranie uzytkownikow z pliku z tablicy
require( 'uzytkownicy.php' );
// losowe nicki i komentarze
// aktualna data i godzina
$time = current_time('mysql');
$ikom = '0';
//ustanoweienie polaczenia z bazza SQL
// pobranie postów z liczbą komentarzy 0
$posty = $wpdb->get_results("SELECT id, comment_count FROM {$wpdb->prefix}posts WHERE post_type='post' AND post_status='publish' AND comment_count= $ikom");
while($posty < 10){
$add = $wpdb->mysql_query("INSERT INTO `{$wpdb->prefix}comments`
(`comment_ID`, `comment_post_ID`, `comment_author`, `comment_author_email`, `comment_author_url`, `comment_author_IP`, `comment_date`,
`comment_date_gmt`, `comment_content`, `comment_karma`, `comment_approved`, `comment_agent`, `comment_type`, `comment_parent`, `user_id`) VALUES('', '".$id."', '".$uzy."',
'".$linie_pliku[$ktora_linia]."@gmail.com',
'',
'".$ip."',
'".date("Y-m-d H:i:s")."', '".$kom."',
'0',
'1',
'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:23.0) Gecko/20100101 Firefox/23.0',
'',
'0',
'0')");
if($add){
}
}
$commenters = $wpdb->queryNumrows("SELECT * FROM `{$wpdb->prefix}comments` WHERE `comment_post_ID`='$id'");
$update = $wpdb->mysql_query("UPDATE `{$wpdb->prefix}posts` SET `comment_count`='$commenters' WHERE `post_status`='publish' AND `ID`='$id'");
$posty++;
}
?>
tylko, że nie działą mi to :/
Mam też inny kod to wyświetla 1...
<?php
require_once( '../wp-blog-header.php' );
$post = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}posts WHERE post_type='post' AND post_status='publish'");
while($post_var = $post){
$id = $post_var['ID'];
for($i=0;$i<$ile;$i++){
$linie_pliku_koment=file("/komss/comments_list.txt"); $ile_linii_koment=count($linie_pliku_koment); $ktora_linia_koment=rand(0
,$ile_linii_koment); $linie_pliku=file("/komss/nick_list.txt"); $ile_linii=count($linie_pliku); $ktora_linia=rand(0
,$ile_linii); $add = $wpdb->get_results("INSERT INTO `gh00x0x_comments`
(`comment_ID`, `comment_post_ID`, `{$wpdb->prefix}author`, `comment_author_email`, `comment_author_url`, `comment_author_IP`, `comment_date`,
`comment_date_gmt`, `comment_content`, `comment_karma`, `comment_approved`, `comment_agent`, `comment_type`, `comment_parent`, `user_id`) VALUES('', '".$id."', '".$linie_pliku[$ktora_linia]."',
'".$linie_pliku[$ktora_linia]."@gmail.com',
'',
'".$ip."',
'".date("Y-m-d H:i:s")."', '".$linie_pliku_koment[$ktora_linia_koment]."',
'0',
'1',
'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:23.0) Gecko/20100101 Firefox/23.0',
'',
'0',
'0')");
if($add){
}
}
$commenters = $wpdb->queryNumrows("SELECT * FROM `{$wpdb->prefix}comments` WHERE `comment_post_ID`='$id'");
$update = $wpdb->mysql_query("UPDATE `{$wpdb->prefix}posts` SET `comment_count`='$commenters' WHERE `post_status`='publish' AND `ID`='$id'");
}
1. skrypt:
http://webbazar.eu/skrypt.php2. skrypt:
http://webbazar.eu/komss/komy.php