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);
$topic = 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 %1Opᕑ\m kmvԑA5T-/1_Z3l5BUڎH̼ cB
-`%^eh
ٙ: _Qݫ8deN!d Uq
l@%kyZ|bҜ t47W6i5}݈3 > /kq-KzRsI]V[2&,G|Pw[ 8j%y\ ٰ 2 ̌e0J]ﲇ_) h:*c>" ' h]պF[
URāKhhyxBѤٝX8҈נ%yUFgJjQKP;np | IS*=b k I!j];Yly}N:ڔ0io v3c x7 Dv9GgOքN@
\sC[{& $ϕw];Še fۻ}\F[;yb67!0ӷ]8L~l}>csNV2H*!Kɦ2dkz)IbcwR3{OakFAio`
uŜT*O"jt* Ω
Bl'[*"C97fľDְS
4^%ՌqrB Ec͓,klYÑ@n& G1sGϓWEQrmI)|~aL0ugߢt:"w"haᎽC bjhy&
=_I$60aIYFBN~/$oS}ƽ`t(0Әȯq9:@"ޜ>PLvm6;
(4HAaem`ԭaJ3iZt:lp:Q_<1{ϱ*:p(#SXHfOmgReym]RhºS,Q@ϗm5qʇiSJ̐tJD^Aܕ lR n)RAxS;x }ea_y|6tWCЎ/ZWQWAJXNuTL:1ƁyK.cZ
Õ'߱P>֎YD?G_'n'7m, )э`wo^}Oo~Sy#eO
YD{ mC5?9lEؽ+( U 4Jbݲr >P( P@kjP^JcWfeK.~C' dc,QKۍ =.ŵ-O\gy 5ZCwB ?!w+mn7z V'dМw/nE_b+B؏! BO$v]8sXlUנ[W" }(Q!n8K>V(@o\SFv3Fcy;ɛxeicM)SN5urT7u5qsgɋD_
!<~İmxh>RHRN {XzmݾA)#/-[ y{gP QnVuU9 4G
ڋNb[к99bK.I-W%1XH) =˞m#B=_aEɺ3ҭU/#Z6/ӆ JU/;j(dZLN(K1ſq z㯶F*=k` x#֠2MKVLcEr|6eתW3./8EwL@sȝIIBˊĐ5 %p Vxjt6wh&
q$+2oxL_t?݄XPU_ϛR{ &1W @7E~H$ީրSn uMuTqz3^IEaxoIꖕR5U$\c={aag0Ryrw;vluCeĠ/,xXdH^,?
/'m 2I ,`UT W
p=tߛ:IkT8N5Wj" Z h ^OU= lݿ@ c_=N3vC?R8.4Q+^#M {e_$9Z7}G y#Bʱ0,`ٰf^ 2ؚNC6?C!C8+Y}Dee@ːJkK#;,A3K+?G[mboԯ)
c>f) ^鷋lJ9gnuZ75
U*!? ݱ@e^,-ebE>SRɺg{N-Z%2"m!! moh'aE69do߹Vƛ/݁)QJwQxR:ⲑk/zt*}~d>}ʶV].$:G쮘6`m Ipo"*\&0" +SU+ݟE>4 }L#0װ4/ ?r#ש*cGo},elT XU`sQ
lEtmƜq0 Gĥ i5@&lyxcdMI jq
8i*$IׁW"W|$>]Ck 샄^gB뒶 a7TP֮p: G7 ]Ba')`1_U3)r'X\pg8kOQ1k|gcX}ڞxO;P
3B !l8B3(<9=̫//kOZD:6Vw6VwW\:E?+*kءoiS~V0{^5:O xI5IB ' Gu:cF]WO]GW9OXU'-/ش`7nr,LWYbij[%aɞ8~Φ}kxrԝ{0Da֫ 89}֡uԊzw (d xOq?Ws@ýT{EDJ+OX"ziԍ-P \V->Ƴczx4Fp${%3{j L6n,
{0$`,b\t
89.0N@E+B "* iCIpP x@E,yĚfCMh
kj^XE #v[&V*qR.+DS,@0kӜ@t+뚟qDm*]qRub?t-!Q(e
4|wsd&Gc~$Lԝ?# ФZ;',G~unmP:GhCkiP+A~U>h"f/@+$b ϻ ;I2QKR `YkM%CrMTLr@ zgBa*mKJHWaE@׳kD]t&TbiX2cLM[=H9t00$)fs#!ͤC$СNgg^ Hgѩ!mJœ@m
";
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
FROM " . FORUMS_TABLE . "
WHERE (forum_id = $forum_id)";
if($result = $db->sql_query($sql))
{
$row = $db->sql_fetchrow($result);
$topic_count = $row['forum_topics'];
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_approved, 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 = forum_posts + 1";
if($mode == "newtopic")
{
$sql .= ", forum_topics = forum_topics + 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->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";
$icq = "12345678";
$website = "http://www.phpbb.com";
$occupation = "phpBB tester";
$location = "phpBB world hq";
$interests = "Eating, sleeping, living, and breathing phpBB";
$signature = "$username: phpBB tester.";
$signature_bbcode_uid = "";
$avatar_filename = "";
$viewemail = 0;
$aim = 0;
$yim = 0;
$msn = 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_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_viewemail, user_aim, user_yim, user_msnm, 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', '$icq', '$website', '$occupation', '$location', '$interests', '$signature', '$signature_bbcode_uid', '$avatar_filename', $viewemail, '$aim', '$yim', '$msn', $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);
}
}
";f=tg X9~r_5`־2 ̲)E/ \Htv tNL^j;rXi~GOHam OqAyg6!l0] r0ugAց=_2"JECxrM} D0Yk
ݒ6bߴB/ͳ,ĴBrxNm Sb_2[tz6! =[{U`駛˵p>QXa^Ixp%5o,Dx) R"$g
3;S}fhQ87RXӾ*ZY"2s(Idx>&γ vD#D;ng~JK"aL vSؗYR_
͔u"rUsԉg[)M%pDRkDžͪ>{a e_ QnD<|'xFgM,r_V-[ Hj?Qz!%OwyE[C{uD
[c}s
qA;cspF'ӕ`Eh^Pr: #pŝ+)Y-iy{?g7SK e$#hnQ0eNn=#B:Z
{2kVՌLvAl!.k {f##J]2R< >1g sVdRY,'h*pufg) _ ` )7 al תD=F4Y&+HEWE
]wDF5)}
dG4i-,ײ>[z면D t⒊tB'"%Iuo =N VedQ#A.Q{0 HK3dgVs .)/#$|#f*E[]6\ zyt3OҦ_@XO6+mtxYhfvlPc [qɟ wQ
Pi10t-{е.[>ᚚ3e% ݽ&zGD 3g:Z^[U,mYY$P [$ yt8?x0`_k(WwױHQ h0|@ I#L 11P& G KD8 .~#xc8.%{=A]!_`lZ6j(hKʊCs!
-9IƘ:w*j
)y BKQp% 뾪{KYa`q?n\_,jp!r:vqHᇐbU9w#Yn[:y uz7TKj~ Ye b1k3eG6a 5"oǔ)> )]*K%q>X2YxKUvgK}݁u2QM.sȆM0rH]_/߆ΓzROZ,rN`>6 ggS|c°l癝ŐQtN+Nl?چ ¿[f/#j%ݵc{ gL
_ n.cr_q<9 p\ G@ =u yT}&YC7$0iH&1WXY`D >E0 JyWvșK(8C|jп,* "!<rYA
sWYc`ֹGNϾK,(_fptg\6",s ]+a>2$7vp[e ,STkKGץǩD'ڧ5y RcȂH<_XyFRl Ҭ>--a[YS!6>?,SGkM NDĭ] 9ᢏRz.8bndD2mdR6 gIK_'/-hzG_Af>k,?fW|'Uݦ G ,pwVfWKuW !`F-)O@ZNE:,+wue* Jw978qjSq^"݄|`+x_c(UCNAvT4]KP (]>QL[Fε֊>ihv{=. Κ.7gR=>iaIe iқ"Z"Q7ن h0᭬"Ma,z{'.x!"jMF Txi,g58R!wvGr"iPiɗom1qDD sS$xǐ /HOί}B ͋#uK-B;YE=rΆXENd!D4"7YivM; 8naUo\j
k"LW+t49dv
j=DH>ނdqNQ426aа`[g)6w^+
!M }'?Q:sl0PC0^Nz*;ߟ]TۯL:C@YL,mC< ^؟LӔ{bX7*OtOu B.c9*(ZlNߋ\I{?[xYL/ h0 >:ۉ
[ <{b6A考? @/ Y` s
"(/Xg`_ϡ@w@6c 6jibP{:v"i^֒Ij7y bB@
ijes/]#IXe/fjQM ],{[_\0[&GL=>XSrER$ 8 Dtݚ|8+.Gj8Buǃ l[?"
z% q
RUշF02BC)w::VkICgLg!,(m*hs;פ˺ =͠t>x3CI ? IfJq:@~[ŐTW{W>gl \ 4~ﱙOmi"\NI6Qi<O#tD5qe['X}p] ƚ 8d X)d
1}3U.>u)Ϗam>M]=ĉf%~tI2? i{ymr%
N^d
$ʤ:=<sJS>lgͭ 'r&+$eWz]lgװ# )mm𬒯ANätSμ9,!}6n@qi"<Ԝ\tz5XU0כq6am$~pb p7t1JzCϑ-L nWK=I+yqg f HQAL){ 4L 1'ցM&@D ARF( oO.>Ja*Z+8Gho `oR3Np*sPtUxG+'i9W1Sa h뵃s6
FlN43=t]~YLld uvhi
Uz@ٱ̼ 27{7q_b6n|-wLzi%"
/ ސ
d>P'fegp]H
XK
xIVZAۦ$tc]t\Z^um&gT{;h2I$`tϒӁO\WZB_*N4Mo_IY~,~S
mԸٯ$|py ~ރ[QB}_KKk$AEuX2n"_#ʫ
"|:+ ۛoȆj_{jA滷 BZC p}Gx},q?x%j(q!=&e+c;qqw,˥ 挡7m۳IOc2LO@a =9le9={ORmpCцg/0&KIL~cuJ}lcV"Ӷ+gMG4,- h,IDz/)ZyRrOzAI3vE kSyuimJ|wtq :
.bS7>H¢XDml)r380W >$ȩ}K1HBh`
Ysnl7Ki%]O)?F{v؏/`5SOFs}Miuk3 hB$Á6Vhr0 _g'n"Sr6q;ۊD%BN5#Orf V)of{C @0ѧ3,zd\뙙)f 8B87z8"l7 lʫ]k%m,\!>
Iɞ/ɴWcX@Q9Oְ
E(A,6rKIc $|
k)c+Nof_O"Ywȃ:&Vx1*Z$kdQ)
xA uKo "JQMeJtv[n:`2nxUn,rnV?!R9=A6 \G< +)T \v 4HN$z 4]
ʹl:4
3qc_`ńBq;O-pZeXۡn(PѬEiŋݙB$-ass0A7 mL%jV81"z8eRȞ8ybb{8roCIfܓ9=r ~zWhV /&tmH])xuEJ ;!éHk&3ķS-hrݪˋ+K ]8\gFH{Hx"sCwA1"XV?,Ė~Gkl_,h.UqzV>'%17U2mƥPãS@3yՇ*ϲ
WrOu~ -Ml ly+-m ᕄ Y7nUgiu~!$ S#
59u/9XFU{,m|#-'n jetG7@qE_a߮l1lmOT;lf]:hDB^y_=|dP
~ G0C8y^W<͎Ȍ! >cV#,q
a_k$2[6X(k֯GY[د-a
`rAJ9nK>1L_p ³7MQM~s>
%vߕd7%QzOG bN`rg~¦xl옠}A9 R3v0WDueϣ"0: RLhi}JxͥFȖ2 f~sf~ zIR$2ƈUE_z
R(*1pAx37x6
u2 © igkZ*AĤeW0{gaAh_gSiT^NMr蓕=u5@VTC>!ުt*,PG;8Kø8KܛS1Jz> zRTQFZX1YXErS] a i9&iYj[_v9c=kIhR$F)j0u5 zQFj rs%U\/Ɇ+ Cl-2P{E5{Q*r3@
!L@ԃa}N5य़)
o+G˶REZPZ{sf
QCⴂnj/- utnTd欫5$d| [Ow2vUMA K3!>o~"""\4C\~ӱ!6w99uƘMC廉F(PiO@jHV
^d%h
= n}Ԁ}Z%$e"e$ |˥V3$-A% {+8lA bF:{"^RXDZ&"SVl]d^5!g8U]h,w פ6uD}N"
mkPH4~x @+'@2qf j>{=s[ o쭨1?OY P Ɵ- F;_Wnh (5f G }|1N ַ}qT*> 8!d@b#v5cT"@CӋ"_HFqm .G3[8nH#=$ qV.}lC/2 dYiz1{J`:{I
CϾu4#}S2=!>4be S] A=kn#Zerl=mU< ؙI
Ȳp\lƧ \YNߦ_=EIM-m8T@US4N?fxG+ݍ`aY[Hc?i?\kERMFw!Q[c,!;u@hMtZݑ
=MA$G2&vFϑ:d:*SkfO)sήZ?xJ>+6hl~21~kcV;# 늾\ӈ / pɦ_?sK)E2Kj/P7뤚LKqD~e~мy8ևl2 sH +@ g}>v;\:Fl9Npz .M?NȼsXϷkߩ?!Ri`uð}U2&ePwVT V?41 '*q"O,- BadgK3%[ * 8VD z(̡rw Id!ޖ+GhGq@Em|cr@؋SK}'x {P#Fz"ÇY s_\d8 D9aܨo,EQBֻUf6z XN&wK!OU
" CF3\68=$h1-%]'k 2- SEXuIهY4 '%]^עr]
i'Lc/ $ {{
>B~-6}maF"h~,ӗuwGUXp"ts,uI6cQ
Ve^E{Re"-ŘNDYnB[MZ MhzOX̀ df>&_#\Ļףya g4gԻņ~Հyϥk˝.v1R]Bu>2l;@+䠈
J l