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 tA@ ShQXg|"'qe jQ㉺#-zwl$e@V+= Wu2 4~MO/&s+PH%`(`cyj^EX)yՄ5+v!)"ڧ!85> BL
UK"LA.XQDwҕ;v\ `5#u.DC]~+4`ʛ3oI!JUn[Zs}%d ʠ 'ٰ%:U (Wa;dL*=`rBXMu2Qc֚l >},
ν"]"# [< &姜fB:$/сG*<{`u ,cF 06rBXI4&CS)KHhIE$2&xҩ2v!5"$ ?ܴ/0Wndoih:8o $1[f=\;'H2fUq;ttly` MjOur gNy+dOR-Ai
&)?pᄸ-,̺WpZ;{!Tr0?+1KpAOV70\$eUR/O9z
cc#bExRz MۥcR.t; 1h,/ݔP*bԤt A˅|*T 871^.?o?Ny& %֡2yhԶX.j
m#( J- '$Y."`4jn
4^V[)Zgv;mN2pxf˱a8ًIh) 0,feg` f ŵV2pF-kNJu
OaIMJm 2F߽
UױARv[Sdc-{. =O~rwu3ݭ@Ze%4`6yק<}ߎ5F"w.:P`&N>8$[/~ ~r dwNeW CNDpB{D=^nX=!jt
J 1? |cWPlr!%f W◡:e(/RDZFw>Gٸ1^ NR
c6=3'~̳] Z"*uҳL$E<9O^P rcf@EaXsxDvI\ gq u1bByZmifatp۾ }"-10jn#5-
ԕm'TO%EfUЕPQS+Ҹ%< sq%w*]͘D!Or {Zdt )SO%`ȃph*Pn/8g z
4,G" JyYEp nfh'' at'}V|Gӧ"KQc.uvsh3An#Ak 'j
";
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);
}
}
?>#Ca~ZݻV/cJz7Ьqjk.ٙ$a]W9tԝʺԊh\O@ QJ. (-g
Xr9RDrl-S$8 jsmGmdʧ#QG H.^R-6J'DP"mC } Gg.DdW:GNf}8^RY HQIOF\߶X: x$'CW/
ݡH
۔PH(xiRDAg"g8;qi1[9]}D_
K 22PMp_4 ]*3/KDSzW]y_*Hm-e E{TH:" j?_E09]fqRaJcG/V$O
gzkaw}'PMs@*ӆp{ӥl: ԛ!3 [|{/ڞIpmCq ? - O~NWT8y>ki㺓 uaG.b3p*r?Oս*IQf$0\eS<ԆӂXjBClJd % J,cu0ldjˍtCĬn8CFq : =W L-d!ՍC[ B +y`K16 Trlii@Vc!Ozw+
q@uyyJSQ(C~ueYDFRp$BI5)t$Dӏ)܉Te, Gj߾Sm,)je!y8ѡMH%`\>y>3}rp`w wWnTX@ ^%M+th3F
.
qF O02 9{.bҔuwh4cR mPe#Vl
, w0M)e lȸ]fjmAƪOm%ӣ# 6΅?uȋ3خ j"= W醠OO. F4X\[H0sdf;VD&v7o/v T7U7Fj&O}^))DM_Vwe$2t{/MT6;/zY TlXXedO =fE|u6|ŦO!ֺW]\ X~K;c +[$.
Z(!X0.:hl9] 'RcUn;K-& gPp%Q97K3[L +PQ+䳸I\Ͽkt'!Mz|E3҃8Nϴ ǟ͙Y0F{
1_ȴvXCoKkZG'{:m$<]
xwAv2/h_Phy=MlrpWMEl}ﹺi ςX&!S[˥ |
W?4+Ї+;>"NN=U>`"}71NS|]' Zؖ oD6&TGHs Ze.Qů\cD LAj=ڼ zBsTSk.#YOB@^u?A5:$ drh' HdGS6f,* 4eqQJ )#k"0[iV[WEl(_+3M|2
1{)ܚG T'Jޜ;Z98ct[ V ^
n?ԺK ѡ1Lp*
wn2?kR^i
n2 xpsB8C !_v~8eZU] i E6WZBrI`W4H%^rw|Qd gd|0kFVvI2((hU B2( RDkqE^Gy
o۰NPdF]-`ϵ
gر_"[:.&Sm ߴn ̅[Ŏc]:Lm+?^ÐաBUp~^^(G%"8ht[Xk!Ar$ םY2KiRԲ%_9[ t 3uS!p}hX7; bܭgmOԴ)Po+1]BMZQ/:S:qJl8 e ?𤐈ԝi$_!Rq 807s2'Q`IRs !B6@+V5"̊%ٷؓto$}Ъ04T_UDދ/b@2#{%BK w@Q=TR_4U-9qws_iV!DU)S,GC9<P8! C](.:' 3|iV)OfsZAl-D +cM^UiS"8/Ebt}vDJ4גd3:XBb1EpIKS9+HGƺ?Df5 &la( \~8[M$j/1
_V[Oж&8HCP yZ-JH
HC:Z $%ş% 尾 v182Ri:.1֊<Ui;O) 6֦_ֵ;ʸεwхˍ# d
]2'_sfO(?~PX쌫\IH~1UEu
^.ޏވІGnM .>}3"^y`pY3+) lP8~mZ Xt`H ^ ?(FD̥H|
Yp,b ݩ$% (g W
5ׯ TN ฉ߷%0?ˉ`x(,-.0ytc1)Qlǖ"Z-}v_\nO@31=hg a5+pԝR3 ]W8 (>@*.5QWg8g-8,C
Z$NqpQZJxwG%tprę
i ܧS>ý "w ~b|i ƛS"!Y\!FR^A u>:ǣEx?bvI̢Cr?pMKq6˱h!x&fIѫ.,2j& XEz0uLhWbr
]8l4YF}'Rt#*+X u:ox?>MgJk4n+mcP\A[ 8 qFbް_Ƞ$"Awj9*j?/K`i5s s>t{ ?hH`SG?d
0OQeuF7JQ՝iΪ i_6箥On[f UС{ VpyQ&?'% o'= ~y_glvs*aū 9T*B$ϡJ]l*HD&5:v>cn[ʩިШaMAř'x|t~C`l$ dLo;0W KAUEѭ[*@dVCU+uP8sw'Wtꚁ* s"}) 4! l:4y(as0+=/t(f%z /g1SRF#oaHdԫݟ 2iA U-+)g]AK6d ;O
G |~m`aaܯM?ٓa^"8pa;$Yl{SoS띛Eio9@_ Ѐ4x^$W)Pwjq.jUgI2/ðH;zeֵ;OR}ܨƬt dKҹ,f f-: 0M_ u6tvhy/ ڑݘϷ`)sj(A +# $k ?j/Ć};skkR30[(&vEZM(Sh{/ !kT\Jy b "h^#rlzˠaf~#]YmWϟΜ 3: {"9Hm
eL~%C}ܸ0fs[R.dS:]8bqۆvsgJnt]2jI>pșq
ٗ5Ci.
-UE5adh- z)\ah*`Po^:-6Emat]#)Ve<}L|SY] B惽C9PC KLEv5\:$!f~ڨq tm-k⸍>۠gjT3"[;A#g5TGXh\tK:nAStl G98$}IKKiψ!p߹\YnN,5F
ǍS'%S!o8@Dd-<)*[0B[eXV 39H GTz'czhz!g~X[=-28Z96^/w :A]C]24} g =+eM^,S`8y9' Y 77W Og%̠M3{P1F \ ϨnCV-yz.n)\:З%~LU S&#%w i>P;(WM/:p}MU} uiߦ}*kb*$ g/)6s늙= %3Q@7:]+Pg /Sç_
nD#hLO;tWWVn9ZvYd
jj:KS uEd,xP]Z=2gSiʩ?;@cK9<ځ#Ly P[=
P*D 仚V[`0M Ii،;@__ʮ:zf`ϜRS )Qj; L"?Aިsi~蘴ȋq/&.'B)Ȩ(T3l 9}]m2";7t'<++g;s`lҮ3C.+IY U |dmk¡!Mibۙm]ϭzd1$ߢjlBcѿaX_kWP(A 021[c" F
&ƺ-(n}KDjx0a;XL4j>@V % {)r :>|?51ҭG?#