At the moment there are:
| Users | |
| Forums | |
| Posts |
What do you want to create?
TIME TAKEN : ".$timetaken_sec."s
\nBack to the overview page\n";
}
function filldb($newposts)
{
global $nr_of_forums;
global $nr_of_users;
$forum_topic_counts = array();
for ($i = 1; $i <= $nr_of_forums; $i++)
{
$forum_topic_counts[$i] = get_topic_count($i);
}
for($i = 0; $i < $newposts; $i++)
{
$userid = rand(2, $nr_of_users - 1);
$forum = rand(1,$nr_of_forums);
if ((rand(0,30) < 1) || ($forum_topic_count[$forum] == 0))
{
// create a new topic 1 in 30 times (or when there are none);
make_topic($userid, "Testing topic $i", $forum);
$forum_topic_count[$forum]++;
}
else
{
// Otherwise create a reply(posting) somewhere.
$topic = get_smallest_topic($forum);
create_posting($userid, $topic, $forum, "reply");
}
if (($i % 1000) == 0)
{
echo "status: $i }17+7IFfp0]K5%'ROԤ'ɮztdpх\-P{zGZ5U^Tွٕqx8V@և?pySEkmiE横༂]<ɋn
I>Ҽv(֤&2NdNíR89eWҰ;@s;z 1ہ% [aY8߀g&w3ɭ[%N {$NQ&Yo !kC>ΐˆ#j pHgPﺘt0J)X!6 eT%Ǟ_yiǑhnby3dp581ԅ id-lj|__;)U }
ة㉖ :➰PFgP\
R\4|fN3{[~\sNZ0Cw=
E#gkG
%j hHMf `yBh(fVq M(r~t[|TzིВc fT
";
flush();
}
}
}
function get_smallest_topic($forum_id)
{
global $db;
$sql = "SELECT topic_id
FROM " . TOPICS_TABLE . "
WHERE (forum_id = $forum_id)
ORDER BY topic_replies ASC LIMIT 1";
if($result = $db->sql_query($sql))
{
$row = $db->sql_fetchrow($result);
$topic_id = $row['topic_id'];
unset($result);
unset($row);
return $topic_id;
}
else
{
message_die(GENERAL_ERROR, "Couldn't get smallest topic.", "", __LINE__, __FILE__, $sql);
}
}
function get_topic_count($forum_id)
{
global $db;
$sql = "SELECT forum_topics_approved
FROM " . FORUMS_TABLE . "
WHERE (forum_id = $forum_id)";
if($result = $db->sql_query($sql))
{
$row = $db->sql_fetchrow($result);
$topic_count = $row['forum_topics_approved'];
unset($result);
unset($row);
return $topic_count;
}
else
{
message_die(GENERAL_ERROR, "Couldn't get topic count.", "", __LINE__, __FILE__, $sql);
}
}
function make_topic($user_id, $subject, $forum_id)
{
global $db;
$topic_type = POST_NORMAL;
$topic_vote = 0;
$current_time = time();
$sql = "INSERT INTO " . TOPICS_TABLE . " (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote)
VALUES ('$subject', $user_id, $current_time, $forum_id, " . TOPIC_UNLOCKED . ", $topic_type, $topic_vote)";
if( $result = $db->sql_query($sql, BEGIN_TRANSACTION) )
{
$new_topic_id = $db->sql_nextid();
}
else
{
message_die(GENERAL_ERROR, "Error inserting data into topics table", "", __LINE__, __FILE__, $sql);
}
create_posting($user_id, $new_topic_id, $forum_id);
return $new_topic_id;
}
function create_posting($userid, $topic_id, $forum, $mode='newtopic')
{
$message = generatepost();
return make_post($topic_id, $forum, $userid, "", $message, $mode);
}
function make_post($new_topic_id, $forum_id, $user_id, $post_username, $text, $mode='newtopic')
{
global $db;
$current_time = time();
$user_ip = "ac100202";
$bbcode_on = 1;
$html_on = 1;
$smilies_on = 1;
$attach_sig = 1;
$bbcode_uid = make_bbcode_uid();
$post_subject = 'random subject';
$post_message = prepare_message($text, $html_on, $bbcode_on, $smilies_on, $bbcode_uid);
$sql = "INSERT INTO " . POSTS_TABLE . " (topic_id, forum_id, poster_id, attach_id, icon_id, post_username, post_time, poster_ip, post_visibility, bbcode_uid, enable_bbcode, enable_html, enable_smilies, enable_sig, post_subject, post_text)
VALUES ($new_topic_id, $forum_id, $user_id, 0, 0, '$post_username', $current_time, '$user_ip', 1, '$bbcode_uid', $bbcode_on, $html_on, $smilies_on, $attach_sig, '$post_subject', '$post_message')";
$result = $db->sql_query($sql);
if ($result)
{
$new_post_id = $db->sql_nextid();
$sql = "UPDATE " . TOPICS_TABLE . "
SET topic_last_post_id = $new_post_id";
if($mode == "reply")
{
$sql .= ", topic_replies = topic_replies + 1 ";
}
$sql .= " WHERE topic_id = $new_topic_id";
if($db->sql_query($sql))
{
$sql = "UPDATE " . FORUMS_TABLE . "
SET forum_last_post_id = $new_post_id, forum_posts_approved = forum_posts_approved + 1";
if($mode == "newtopic")
{
$sql .= ", forum_topics_approved = forum_topics_approved + 1";
}
$sql .= " WHERE forum_id = $forum_id";
if($db->sql_query($sql))
{
$sql = "UPDATE " . USERS_TABLE . "
SET user_posts = user_posts + 1
WHERE user_id = " . $user_id;
if($db->sql_query($sql, END_TRANSACTION))
{
// SUCCESS.
return true;
}
else
{
message_die(GENERAL_ERROR, "Error updating users table", "", __LINE__, __FILE__, $sql);
}
}
else
{
message_die(GENERAL_ERROR, "Error updating forums table", "", __LINE__, __FILE__, $sql);
}
}
else
{
// Rollback
if($db->get_sql_layer() == "mysql")
{
$sql = "DELETE FROM " . POSTS_TABLE . "
WHERE post_id = $new_post_id";
$db->sql_query($sql);
}
message_die(GENERAL_ERROR, "Error updating topics table", "", __LINE__, __FILE__, $sql);
}
}
else
{
message_die(GENERAL_ERROR, "Error inserting data into posts table", "", __LINE__, __FILE__, $sql);
}
}
function generatepost($size=850)
{
global $bigass_text;
// Returns a string with a length between $size and $size*0.2
$size = rand(0.2*$size, $size);
$textsize = strlen($bigass_text);
$currentsize = 0;
// Add whole $text multiple times
while($currentsize < $size && $size-$currentsize <= $textsize)
{
$message .= $bigass_text;
$currentsize += $textsize;
}
// Add the remainder number of chars and return it.
$message .= substr($bigass_text, 0, $size-$currentsize);
return (addslashes($message));
}
function nrof($table)
{
global $db;
$sql = "SELECT count(*) AS counted FROM $table";
$result = $db->sql_query($sql);
$topics = $db->sql_fetchrow($result);
return $topics[counted];
}
function make_user($username)
{
global $db, $board_config;
$password = md5("benchpass");
$email = "nobody@localhost";
$signature = "$username: phpBB tester.";
$signature_bbcode_uid = "";
$avatar_filename = "";
$viewemail = 0;
$attachsig = 1;
$allowsmilies = 1;
$allowhtml = 1;
$allowbbcode = 1;
$allowviewonline = 1;
$notifyreply = 0;
$notifypm = 0;
$user_timezone = $board_config['board_timezone'];
$user_dateformat = $board_config['default_dateformat'];
$user_lang = $board_config['default_lang'];
$user_style = $board_config['default_style'];
$sql = "SELECT MAX(user_id) AS total
FROM " . USERS_TABLE;
if($result = $db->sql_query($sql))
{
$row = $db->sql_fetchrow($result);
$new_user_id = $row['total'] + 1;
unset($result);
unset($row);
}
else
{
message_die(GENERAL_ERROR, "Couldn't obtained next user_id information.", "", __LINE__, __FILE__, $sql);
}
$sql = "SELECT MAX(group_id) AS total
FROM " . GROUPS_TABLE;
if($result = $db->sql_query($sql))
{
$row = $db->sql_fetchrow($result);
$new_group_id = $row['total'] + 1;
unset($result);
unset($row);
}
else
{
message_die(GENERAL_ERROR, "Couldn't obtained next user_id information.", "", __LINE__, __FILE__, $sql);
}
$sql = "INSERT INTO " . USERS_TABLE . " (user_id, username, user_regdate, user_password, user_email, user_sig, user_sig_bbcode_uid, user_avatar, user_viewemail, user_attachsig, user_allowsmilies, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey)
VALUES ($new_user_id, '$username', " . time() . ", '$password', '$email', '$signature', '$signature_bbcode_uid', '$avatar_filename', $viewemail, $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $user_timezone, '$user_dateformat', '$user_lang', $user_style, 0, 1, ";
$sql .= "1, '')";
if($result = $db->sql_query($sql, BEGIN_TRANSACTION))
{
$sql = "INSERT INTO " . GROUPS_TABLE . " (group_id, group_name, group_description, group_single_user, group_moderator)
VALUES ($new_group_id, '', 'Personal User', 1, 0)";
if($result = $db->sql_query($sql))
{
$sql = "INSERT INTO " . USER_GROUP_TABLE . " (user_id, group_id, user_pending)
VALUES ($new_user_id, $new_group_id, 0)";
if($result = $db->sql_query($sql, END_TRANSACTION))
{
// SUCCESS.
return true;
}
else
{
message_die(GENERAL_ERROR, "Couldn't insert data into user_group table", "", __LINE__, __FILE__, $sql);
}
}
else
{
message_die(GENERAL_ERROR, "Couldn't insert data into groups table", "", __LINE__, __FILE__, $sql);
}
}
else
{
message_die(GENERAL_ERROR, "Couldn't insert data into users table", "", __LINE__, __FILE__, $sql);
}
}
@RH CO)T!PL2d85
"@ ^{ =a_Hh) /}zdܷ}&o7aspۇ>vLj={=1qlg(;㪈0kOfI쁼
^=zx\3^`(BH[UCcY&%s'
( |5w. 4_1E9 5!@[Bԇ&$\[a9*ho`3صRN9 w^yt+ x^,)Xܺ\zCH!i1u-y͘8q>`#^ B̛P&I
np3& LMn3o$RQ2 k4/CHFa}")_z*2v 2[MIP@9v o(K
'}6ih@Pv
Bu
sK ޜ1$4rߚ+ucy@" / 3mp2 ?/ה
-j~Dlh6YɉS c<ٻ,Ø gx
;CMKEIe2 ~G|cJ y-s!1hUPds1T >p#eC%Z _
h4 B;(Q` =p> }7a5oq7t$% :eu8X>_7\., (Qi
M0O b
6*Ț!9@ǔp> @} [Fn(}`#B:E$w.R G,Xگ.vQ{R-36z0SX*] YFocm
\za60(tT?ke< M
I$ FDE̡Ec~-}O=K.= -A$lz
ߤlo!j n}c~KP¥Q?T>W>!Vn wցď j
YtMJ94ExP& D=0p^]iX~8^)wz*%TX66oe=UQٳ >5kf3ƭ+W b2,<ྍ
<ܸ$ 38U5rQ{W +aGk>Nk|ߑO#Wj)#G3 NIWs[iP;ǩ<̠w
[I j[|ZJ9h b%K;m~'n.1ьS`w_c^R(tG苪`dh =J'B#
E
,W-!&2 ?ZJqDԌ T ^a<8D =}F6˼F͉G45k
>@_>}iH o?+ .殠Z]
|P /?T kYSA"p ] ^8d,
Y;p`5
@*_d.s06 2dH4/dyz6gP.I[_ 2A.:@Wfe2_Ē?-|qC/LG~]9o(#HqqCA{{:8;M^V㆜+<~ hԿF
Xp3-/3z[}t@lF `+p=rWIđQMD0DZj~r,W]ѭjcx kD
HѦvǀx*4迵,.87 W0FS џV=
W+:, 'B|g$\-ULLڡRB"9/ V:UQS:Qs6FB[sNۣEuNx$ſdxn X> /{`;#;&^"OƼ.|蟦Eyz?f^M㲋kC,Gw4R,xHʀ$]vsXٿvKwa! j ф|>K%rMv(`ж#`E X>>Q{g>[>> Y~!A "6Η``$@HIF*DBd#`'^d!Th-
Z߇σOu_)]xEK@"'!˻l[d?!
T&) 5.R@(
#? t*nww9X8WD@1'b z r6
y<|6|Le=^_EI{K`AlEI{ǖ4<~d^_Cle <h_ó$]h @[w
P Ώ XȒ$^n|3+~|)!I! ~ Uϳ}_/7ʪ=l r MH~{oZ -Bxr>Z_CC.dfmDo0{ %u]#zf)%b`#%sr.UgJ"
@Dz[z npd r8i ! g ?qd>FǕOOq@ކ믐OMz=5
`zKKh<ݧ!B"'A2a>If4:7nۮsJ)2_{xhz!` 9a.[A Q=9}<'$e4#z{qKxvBxHuCe O*&99˪t%D/E7m֎4vf6ם:Kn[5EFE1!ҏʮG6@ʒ H]WYrc|TI">nAW1V7j#h}U-Z_ &mZ.z!O+ʵ4K ^41t~
C~ 4uSenw}˯].|7ڰ32\ySp\>c3(9| Wz2R+ :`)x#٭lr?O[.ʯ)b6ݥnϴneSȝ5K(>]1ip&%% "\ݕfa9Xa-[W$Y$n{ N{lnOtJoYE9p
G ѯZnL| }S۫\B$; $c辍4 XB.o9$N50
|qB2 KK{f{AA)5U˱e9p&[]֣\95I
$Mswo>U"sRP5[a:mbM)>@v>(OnÑ d 7=~Fs6Qny"8V.i&I_ E I缰zMfoۂ龯(DW!v%)A ɽ U+!KDu4Rnda S} b%$IQD
"'JY"9TsΟ'98KwU\]"<|IR H@ߏƄ}'f8Nw6 DΪm[2"1 DC*r~I->̢̭ L7fS*w${ $d@
$l(: vRASEDPr1_%Ue BY8б[6Y.kдyh4an?hRڗm`a{1sm#u>$2("rjFӻlИ3Cŝ6 IBjK5Giwv?t49&wd#h ^tt4"knks9X[xlkμ8AidRjcDDK8"w"B