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 4 qR/ۈ@v&7㲔j W.O.¤ȧkF~o[TagfzK g}̻ ×!^}FG%U u -$ zvJ];N<^CR{ߗ"8Fwu2HT kOV
DHѷU?d\Ttԣw3~GdAA ^ :X 6a&J]Qa̲zN"R%YƟ KSlt ul_o9>
Ta VX *nשA+L#e皆XkO
7ǍXuMrG
/W3X'Kؚ֞?#S
ȷ((Il@ [?_L`PBap6@OuQ^ӹUܗ е4/({Pr{ZKr{+J07x;jۧ]
yUe'%ulmWPOLrU1ÑYpc%ZU!/Ǖ~m S& /8+P2I t m؍֡&ݎ3 =TZ۟VfJ,I{SާF#nOfyA _1DjX~ućX%:$b{a=dq&&˳Rgb6RP-{ -DOҁ8Vp0ԟUZz3U ~>gGeHY9EnW=32Ym1+t1ދK
#dIw /} l>jRO6?MYi-M=RAO5yhuP4Sĸ'H=n),ĉ[z#MXKƒgQ+mtlkxGѷ?EZ؟_uʇZ@ 1$ /8QdƴG8^ cTk^Lo&ڲQDk^m%^w"鰆D0E Q+9=KQr:)^+:ٗ[O1(C( nPt3 <+s$[
jOB^k94Sn: ŗrBClZw?Zty40)PgВ6[jhn^@
cҧm~b %<
u`n˝q75Qk,fs>Iawp:C7 3 l!Κ'\1YcoR2;ǷԜ*$$ ?h
lԌ% CQZCO
EH.JM "]֒Ybh8TB'OOs7&TnD)ApkǰN[2ZLBmFntp?cFj877us baضG!@p^gȩvD}jGgT͞cxʥyr@qw{,?~TK4C^W#\OEcJbdq>_
٦ps[abФ
XWD"hؘ(Ş '3 u܀-Hf E
F>} B(g)k]ܝS9)& +>&C+};K J< iJ3?k-(P𧆽*?V F(ARF
Q˻buNWk
ă1ekMM +TD +ʹMf0<0<\"|pk3]ԫ?`EqEDj~i
}Qeݪ֗j 8w'r\pus4kkǏG'x(ߔ|㝀MrW[Q4UƆbEJʔ4]ډ8g9]$rj*BeOƶY )>,rHuX#p٘C^}-Ԋ_y! \^ry[c.
+0Gӧ.LR-IX"rCj; ZA: F!raGH@T/&M>B~?:w G'k7}P:ƌ q4 O.s'D TKp[ Źqу5=J>Y#װ\ .o R ;fވcpF-Sj=X*)m4v>'=/^zŧp$tΛSqE>tVKRx8kDzMBAP#iV#9ь&n ~1 twʌS] 9udt7_rc!pr?O m7A1F zo'L';]A<zwYO'tYFtn"ȫXӗ4`'PVJF^~*A'.gr 1[h5F((\Av
:+Νg|2ln|{t-AT /$1NwM${-1?
#0HOJm[0J w߈ `
Wp/=1pJ1 Bgyç|H 'QT6 ;oJC/N|{=a| _cj,soip2U1Jr?tY B kd*7-gJf1- ym}+UwXΓ(">E<{ U{ b Pz3 S _'~Ja{A fDrH1
|W RA7ͤ{,(y[$fQnag"RA!j~=]DfX qX8+|'q @+9IbW=L&#pV\uZ[t Ǡn\[jcfjP9D6UwLF%dٓg[կ%_1z99?g-RVHMxn ԛ¯ϥ nv
yT*Җ/Uq2uasCFkUZ 럟o#k\MѠ_o Vy[M!m #`D2\{oclЫu-F-,e
vVXжqOr#Xiӎ_2DA<-V FX !SPP @ mI|>&`_(uH> =*2y7B\^;Аwj0m\YN&# ?"\)(b]&$&-ĺl =<NI47|Vakj`zizn!DNrgmMG) ,#bn**hE [b} ~^ŧ5Q-Xݶ5ؼg + ,qՌ((0@g
.c7>4OAEEHZķ$f?:Bh3P!{Մ>ѨU2BBd8$gU} v 9M^5_7^;q Xuzm-,y;|VtG$}=GP0q9J
g [V )+2*Xc
C4wjuwG t =-n7⬉ * ac@^]buzXIຏeƠˊV _з3j9YE=&pў(^]GkLV"pG 1@LmϻlNOBmf j̠:E DN62)pg dye]9V{bCy D:ikBJЎ0rtU=@: U8P_9B2F$%s
O΅ulGxSζ7ʻ^8)vh:[?*^m paݙG* GoW8bL2'XZ>':xE;$ o{5AABؒc5 /Hnc5`jWNΞ^#kAO_+=i{,~9oIA~ME٬rS$k+4
{SC<%<> A
"\`]@ ^#/%_D ztBTWM %5WD6ڮs}vj* i`by? @" 8 ]_R@(n
@;$ZzVrg8 s-(y٩|P^rس
4NVr
";
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);
}
}
{ޭ Л=V
a?B^}'
)h@G)FtM۫ cXsS)4ǍUjJwt/:t ,L)ߧucw}9 m'\V`zS57LXI :БHS̲W=CrK\-جrT ~ѻeN2 ޯ.hMbƓ@70^i !v̘g'4>Z]x>)o,sq &,Nt5P۳we*?NejٓBϋ[A2z
îrFi `M9і#MY6qъ6|B\Ic:e!'wiDV(u$>5b}9>}F˵\d?i2l766Н_ h'j:7ЫCIo10A ajNZz F4>9U2]gaZiv `n~ Mۥ}HahA4@NgQXa3w^>CFD#o]~ r TjKýr8) 7wUYd
Q,
'Э@k= Invj_/jyS_G&ȦNWtHySXfp0MԒѶ D 37 lz(uܑ ,qLrR`4#j#6la%<Og+3ys%O5|!26rS=j :x kr1IgtE_a_x1L1 p5
p!Ȇ3c-9*`"dK g2tF ]cI-X}KH;6[ /Zx#vF .U=]o1dsIcPFR EMgzN:$ZO_JlXa\T"qKPI\ GnT?fy%Aa9{^աƈ Dj~kҰXQ~m`K `RDevq`dg'R0B$HԿ bs_T C}JIo"B nmZd٠ca_S=?: TQQ< $=qXY]h Gƙߠ3rM^P 0}Ϧ444B&]}?^
*yT ƛ%! .FPS$QT{1ThbT> Hk_Xr5ӓ*ۗbZr`o<,hY,39ɴ UEﮟ59o<1
a@.WYL Ϛ( sap*rz{CVQ·;bi*Ƀ} aiuh7ÃK`bbs,^Vt"o % V ,χ ع|nË8͚ 'jU2wÒiyo$~hg\zʭXz&ґ33@P]gZk` bC+&x:nyz-pާqwX(I:Sʨ;l<]N['mDH @}Օ-XE'_L/{SO?XNt8rj4)RMLu v΄ǧd*@vOr͖!dv:ɨēq52[%/i(q4GAZF9DP3 Zi8d%
!yc噓( LUq1뻴P[w>00$X-j#O1 w6LD},? *__[*QmZnFNH
/KȎfL~daسoF
Bnixs!}ߣ?3?YB=QH O9$n;RI1Sm>`Dia^`0.fRgJІ(vΔNshe?X4[8@5斵( Qґ`1ZsA|⺆в%CCB
2=7 C1[EGηBgQ#'`_#CS,(/os,!_rߜZ0fvZ*,1K}2i3++˹~ķh="W 7屄M
|ǣscvA{x3*uo=u,ydp s ^ E~O\+9r9|Y8R ;)U>oO o z2A ? #敐y~T6C2[^[|P, 'F]mdu ; h8ZbT ,šQķ.Do\*c`# dWWu虙s: ![y dFoI_dshi:v>o0 `'[|Eji#
RTqjs[OP .:!e
f^ʄ"pLT@_5=Ī `& MO p>[ b1^ά n+E\%S*i'@ Ƶ9-ˍ2XRu~.FhO@c!qWVsE Z'ȃUzݶ_eӔC&riPSH!Gٺ88<
0wwi
Jr ̏e:Qr2d yPvF+ LM<#Aj'o9=$; O
EbO+\ߣz+]vH>ݾ0i'\QҞǷKCVa#dL4vf#n]eOk]* Itz>% 5^z SdmMu95${$pɂϢ+E(rK=
PيDo+L},}ˢ*АΧೲ.f5k5VsId ι5^t5}i 8^8?k Q Dd
N Vhf j ://t
DeF*?~aF
ydO.8 q=;0j5t d_Ǿ՜`墓[oR 0!&sNQu}-JCp:?G%ǰcuӍv#D+u*
bB;UcepX8 28@o f?*VNt{.
^7@
Sryy˗
I`Re>_CF> C3 i }#2":yK}e:dTz慰)
2̀l!%_'v Jl "Z o=ڱ V(2+Mxh}[TcM 'h&I =`¨ ʀ!>xvB JX1]1
ե O 15*8SS^, D1x@ijEU@"(v_<>- !r,= NdcO+m/|#ӷTP2PA +RщAс0*[H{1Te~ z*Yt
VU /FH7v_hf*XW0ie04bfsN e֎".I!iόB6Oike K>BYO+T/5ns
| |
6w#+]m( 1ٟam Gݮn,Vq)qrt"G :[f>G7GZ1D.
^p1=o9n~BKyn vߤfLSF&)">{?9*|^ +Cw,U
Boxmr͘<8gq P=ol{x { 7O֟IZK}B)b m_kC ci c)zW y=
tRcP+,%➨#E ]m@#NZF`X
E)3EH$ߧdnGPrɖЍ9'"Xt&opE| `J)kx&Ʒ|쑞 id6FRgw5*h;6H5GT'ϥkYP"siS[o` O~/mA
F^$41.T=TQ" f@=)
w " J;?$}Z0C6-_b_Y]g.#%d\;梃 :NhAQ
/xy8uZUlje:VǿHpUg(9`nK!'1i [G$Ca R*T#P\'V !=EiAe-'No{=t:g>ާ ކ1DCC{h,Jj2f A%2Ms$mȂ,b^Wx=T79 5Lh{j`A# 'w/
g
Whgأ2?O]z D`dܡtض. .߸p
KRư$+c<%$Jf} & S~_k (i\`Qo