d>Պw2t5* h-]{sqM
w6=+!CbN3܇Îujzlj yM2!oꩉT3>QgX$hI=V9iDhB\IF*.n+Uj)\8<{Y
9= .7X5jN"ZON~L/OeFG~"難|\g J䅄e aϾ9 ,pRڐq h |f Iot6D9G;u 'Hbw
Ӎ꧵ j vG~i6=NP0_">N73V`C4_^[%Fo~͋z(393ӿ'Sag5CzK6,ߡuhem?zp} >Vq;H5o5-'s g?&^nLK~[azR q9^1g_p]'kNb ԛuK r#;d2iuY9TTh/SIvS>:DS8N->= LIYǿ}/=5ם+B(y6ESo",fJD b{5_*A|3knfXˮ?[7U
/}'/l&g^d-#*T҈%FK9L N *gd11#o Po٠ػ<
_D
cnk)6 *Xz' #OX|RZ B°=vbE|?S\ÕR[<sY6N0Z0˓ ̪(˫l;䇻 4Rtv;:q7蚀{
86ViYYfx7xѝy|k;ie5) a4 Ɣa=Vs1ODq5547i,ܞBBWa*)e #x!+~NJ @U uěmP$#P֜uR;/L4Sv gM
1]1hjRë.Og75،ٍQ+mǞ N)1wN/2rlX,mW%#P6sW {ouUӺv zoe~V,tv~$o%:vDi1lC@荗LZ
/T DjuG-hϨ~Hs(Ӈd|iBŵYKvX_n[u͕>?B]vh+`jengcEx-W?5e ZԚpPr㹹_Z}<-(ˢB'f}&e:aL^zP2!2*6 6 Ɓ"*A1@ m 0֨;uX=U U% ݹ]`n-M ˔\Ac^P/.U
y &lzz))C)ncۄ`gqq 5#~A1}U# W=ߔ~V}W _"BLJJD 餧Szc}mg+ IUVBxDPbK1~d)0N ]O $I~ y;"D3?;Fut)Cl?5E D9}+шDyrX$c_N x_lRX*/AKץ!冪 QBT5"T+W s m5 _Pi W]4_e\=s{ 1uh2}έCVCm[2۽ qY *۽ } g93h*ty S"K9P ,GItSv&Z!զv-
dw-sC|B|0%vN$XV'K \$\aDG##~JK|iv %L$>-1TGlR'撼b:#*$ ǡG"fײM;̡Ez#eLR|.4|Vzıw_(&LNu ^u[u
7P
O
n6bCP`([,`$TAl
ǎ&zSn J` htX۵!*KF:<UV 5؎ 5T7,qBPZnԂs1."]/w8lQ|tF.?$ w^DAbD6խ2:Xǒ'HAZʓ?Prt+7oi5BЍoI<%HN8J/[u[f&d `\Z~A"vӱ* £ Mʧ? Zjb}}TAMP|ݗcH$ 8r_|D!'OM7[h}q0
Y$5H$VȪRM ,L3\*&0O)o_*փc8Es _Hh۩ƅM[o\vfU
!2oH 5x ȏ24u8cHPot$߽zaaeGE %uX-pP ^ݻ|̆+7^ @28c LEw
V:6 1fASuN5u|~"̳
1xɢ{F, z=
h*CWQK:&gb\"埿m}471j<즆:8Qc(m |<;, \̇UЩ'}CﮑЯ+DX!MQQ11}~Ygji֙X/1ݔv㮉p J,D 5z(0|\Y4)Q)#P -l2ʹőuRE= wnR69D]Y$| AD'7 oE!y
hS̩q`r $tm-Um|ԏ-:N`p~ a0I5Eu
-@f3 AĤ) imUTmvn jW%=:&qޜUQeۼva
QG%xT(|T]8< <^J\r *Z@F k<2$~6niEcy I^Q*jl x7*pt5+}57z}*/7 Je1D 7
t!ck4r*)e$ƢhEtJ}~ug FS~ 9wJ$gLkbUwz/R{S9Z]>Y×rˌ.bl;GMoDE'.ߊK^J9KKÔٶꓗNNJ\^{hp<>:ף<7X z!6Vs zt> Z{ !AO7 ƙo.@XlOX|+UەK;!*f?7ri60qW@Y5nۗb75k"\ѢplHXeW,DžP;5B05y{+?#ӈ b7w/FX
n+}sE}Gpm$gFpV[tH \Q>IӖ0F% 6 /2@,uFDyVz̹@o &бv_1"2wk gK$&X P"RyLth\Ӊ<$*D_(
^3)Lۏ5ffA,0 l.k;9
DwXB
a8{fEeF7~d, |1HhĐ#~Ɠ.~ZFlM'Ǟغ++`~ 6
(pQ#AMYv,JzSC jէPP8u~=qMp~WaʣO(m||#l' t33 H;12c&s8 c$"6): Z@Yڹ횿RՋۏOP4W:C:.̝
nx yn0գ̢Qw4J O JS'T \c cG~~9^2 T/ gGrCa(Zo/zefBf
t*.4KL,0NKy\l: | }T)7&\ңpBk]I4QlѪ *L .]Dž g `6zŏxqRy$Ҟ-A C)oٿ p)i澷@ 0/j0^ `-:B.)vcA,kw pXG{IP̥:YmD!\PQ*d {3 ^U^%)/(kiZ'>dM3Ȼjv(EkHW@
jl=!h-ʟF}
]Z
{euq*b %n醋Wbõ pv}a>8nU2xSg9t&5{)߷Z
@! ZT}/?R (mJƭQj@NnEX,SBAE@4Rh红"XP2D"V/T" mT -|&&o߄չdQXӠ96_MooT5ڜ=:ٵY,w۸1w~.Byѽ"MN[<0\ȦU FdzOc`Rrt3zEOD녦 ?PP#D]zL;@$0@&:
.ͪ<؝%/4H ]
fJZptǮA 0ތ5#
^xl}p#0l$ pv{
CP)w\ն6)WEyP vܥz%ï]lԮq h L g;x@]R6ڗ4]|9D-T/| =A!ݜk,FމùU;\MZZǪ^
]6.\}
ju$[6-;]}Xuh$v=VC=kOR%]~Ft٭ 8jM27z4dE5
r?֬w6f˥nؑVvu4|w 3S*k-4ZbfI-R;1n{lV]Ps|h=0G;vIR$c}&d j.?Rh'f4+*f wyK!d6b[W.5h4s2tic@[B]e0zJikǘ"ZVTg Wk8Ֆ4K ԋn
ohui=~$1:sGEVg q-j09} v@$3#<9Y
hQѪ@p(t})K;n 8uM:GdPrKMӠsJ^p-YoW84 eAzyz?-J2HyY=Zܗ0FkaHE*ί %Um^ i0J_$=V.[F)鴜)㼯r_ZPk쳺Ii/O6Q9 0Yc+`)"o6=-9a0R>Jt3Deo%(.mMH #xýdmrUR8@yp2&3Ѵj_"ͼU េ K!?"־syڻ8
?J5k2)ݱ2\|^bו Ӊ|^ .|İΩ N[^4VPx^zK_~DpڽVqe,n.PwYK= %FhZt wήHF ]p"ϊcchCq"Q,ōR<?php
// -------------------------------------------------------------
//
// $Id$
//
// FILENAME : fill.php
// STARTED : Mon Sep 15, 2003
// COPYRIGHT : 2001, 2003 phpBB Group
// WWW : http://www.phpbb.com/
// LICENCE : GPL vs2.0 [ see /docs/COPYING ]
//
// -------------------------------------------------------------
//
// Security message:
//
// This script is potentially dangerous.
// Remove or comment the next line (die(".... ) to enable this script.
// Do NOT FORGET to either remove this script or disable it after you have used it.
//
die("Please read the first lines of this script for instructions on how to enable it");
define('IN_PHPBB', true);
$phpbb_root_path = './../';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/functions_admin.'.$phpEx);
set_time_limit(0);
header('Expires: 0');
ignore_user_abort(true);
// number of topics to create
$num_topics = 10000;
// number of topics to be generated per call
$batch_size = 2000;
// max number of posts per topic
$posts_per_topic = 500;
// general vars
$mode = (isset($_REQUEST['mode'])) ? $_REQUEST['mode'] : 'generate';
$start = (isset($_REQUEST['start'])) ? intval($_REQUEST['start']) : 0;
switch ($mode)
{
case 'generate':
$user_ids = $forum_ids = $topic_rows = array();
$sql = 'SELECT user_id FROM ' . USERS_TABLE . ' WHERE user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ') OR user_id = ' . ANONYMOUS;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$user_ids[] = $row['user_id'];
}
$db->sql_freeresult($result);
$sql = 'SELECT forum_id FROM ' . FORUMS_TABLE . ' WHERE forum_type = ' . FORUM_POST;
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$forum_ids[$row['forum_id']] = $row['forum_id'];
}
$db->sql_freeresult($result);
if (!$start)
{
$db->sql_query('TRUNCATE TABLE ' . POSTS_TABLE);
$db->sql_query('TRUNCATE TABLE ' . TOPICS_TABLE);
// $db->sql_query('TRUNCATE TABLE ' . TOPICS_TABLE . '_prefetch');
}
$db->sql_query('LOCK TABLES ' . POSTS_TABLE . ' WRITE, ' . TOPICS_TABLE . ' WRITE');
for ($topic_id = $start + 1; $topic_id < min($start + $batch_size, $num_topics + 1); ++$topic_id)
{
$forum_id = array_rand($forum_ids);
if (count($topic_rows) == 10)
{
$sql = 'INSERT IGNORE INTO ' . TOPICS_TABLE . " (topic_id, forum_id, topic_title, topic_reported)
VALUES " . implode(', ', $topic_rows);
$db->sql_query($sql);
$topic_rows = array();
}
$topic_rows[] = "($topic_id, $forum_id, '$forum_id-$topic_id', " . (($topic_id % 34) ? '0' : '1') . ')';
$sql = 'INSERT IGNORE INTO ' . POSTS_TABLE . ' (topic_id, forum_id, poster_id, post_subject, post_text, post_username, post_approved, post_time, post_reported)
VALUES ';
$rows = array();
$post_time = mt_rand(0, time());
$num_posts = $posts_per_topic; //mt_rand(1, $posts_per_topic);
for ($i = 0; $i < $num_posts; ++$i)
{
$poster_id = $user_ids[array_rand($user_ids)];
$poster_name = ($poster_id == ANONYMOUS) ? rndm_username() : '';
$rows[] = "($topic_id, $forum_id, $poster_id, '$forum_id-$topic_id-$i', '$forum_id-$topic_id-$i', '$poster_name', " . (mt_rand(0, 12) ? '1' : '0') . ', ' . ($post_time + $i * 60) . ', ' . (mt_rand(0, 32) ? '0' : '1') . ')';
}
$db->sql_query($sql . implode(', ', $rows));
}
if (count($topic_rows))
{
$sql = 'INSERT IGNORE INTO ' . TOPICS_TABLE . " (topic_id, forum_id, topic_title, topic_reported)
VALUES " . implode(', ', $topic_rows);
$db->sql_query($sql);
}
$db->sql_query('UNLOCK TABLES');
if ($topic_id >= $num_topics)
{
echo '<meta http-equiv="refresh" content="10; url=fill.' . $phpEx . '?mode=sync&' . time() . '">And now for something completely different...';
$db->sql_query('ANALYZE TABLES ' . TOPICS_TABLE . ', ' . POSTS_TABLE);
flush();
}
else
{
echo '<meta http-equiv="refresh" content="10; url=fill.' . $phpEx . '?start=' . $topic_id . '&' . time() . '">To the next page... (' . $topic_id . '/' . $num_topics . ')';
flush();
}
break;
case 'sync':
/* error_reporting(E_ALL);
$sync_all = TRUE;
if ($sync_all)
{
$s = explode(' ', microtime());
sync('topic', '', '', TRUE, FALSE);
// sync('forum');
$e = explode(' ', microtime());
echo '<pre><b>' . ($e[0] + $e[1] - $s[0] - $s[1]) . '</b></pre>';
echo '<a href="fill.' . $phpEx . '">Here we go again</a>';
}
else
{
$batch_size = $batch_size * 10;
$end = $start + $batch_size;
$s = explode(' ', microtime());
sync('topic', 'range', "topic_id BETWEEN $start AND $end", TRUE, FALSE);
$e = explode(' ', microtime());
echo '<pre>Time taken: <b>' . ($e[0] + $e[1] - $s[0] - $s[1]) . '</b></pre>';
if ($end < $num_topics)
{
$start += $batch_size;
echo '<meta http-equiv="refresh" content="0; url=fill.' . $phpEx . "?mode=sync&start=$start&" . time() . "\">And now for something completely different... ($start/$num_topics)";
}
else
{
echo '<a href="fill.' . $phpEx . '">Here we go again</a>';
}
}
if (isset($_GET['explain']))
{
trigger_error('Done');
}
*/
}
$db->sql_close();
function rndm_username()
{
static $usernames;
if (!isset($usernames))
{
$usernames = get_defined_functions();
$usernames = $usernames['internal'];
}
return $usernames[array_rand($usernames)];
}
?>