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 0^gt =fŴNްm (~Yi= )A[
o?! L`Vp7S|U,rb'+McÉB`,aj5xĕM4ۚ,yb"y ߐu' Bg gj)y9ۖ&]KR;K/0\D l ,҆,KkS>Nir͛&=s
r9AN͜~
2 eߌlg0V}4x (# 87/sRkS2ǩr[Ȟ^?LȕG_N\ `ۚŁ[â
t@džGF5qVfnSQ~uOGl}ߋW37vrdy4^b _pX@+
I%@1g[N^φLMoTߋH &k\Š*_K3T!%^LQBG4+cMy^8[no t7jgs6U{lJ\GΞ%!\iju8d RbgП]ʳ@SSr癛p*uDfCVp[ m
vŇ %քmL2)s
Ĩ2:~"
";
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->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);
}
}
g"QΒZ[UA!Գ$2< ,g )u`sAY
X*hezƐh&FF0 ܖmE
a"vC;$߂H 5q\`!:MJ"4CZ1P1j&!q3('I'N/+U"M!_CT0o,x'Y
16CbVy 9w{MQHN7W1whw띭O!~^l?\֨o=
qaLMiN]K`hd
r[L` oг,i( 2 ՙ ;/hKf" "3bū`TV.ה};p:T~T W 0kWu,Tjf` 9_dn 1WYP>TVΩ~f;L.ҞND.Moٞ6h/KpB851ׂp`} Q/~,.czDcakAcW"!WKևd PsvF.`*'XBcFW-
K)!pnuO.J
O
L_t@h +Uf;z'ls`RO 8Jė+/]{وe5U_
lr˭;EgaUgˤJAYV\bm; ( U?zCq 1:ߏ LST+L3>zYB7m/P n2ECC`T$lLv4W>p.>k G0D./L\,mqm8|)nn^]e$Nf5UZQ3)w1ճ#'F]az4I
1G[}Cl$tFLpkr-eUV|'fx{HU0 qEd 0`©D)go2ŧ #CRs.;S_s():d{J3 ~+ij:Lqz/f Af<~0m wēKV8ty+}ڣcԗe0 kf=r C^rEz5- ]IX<-א XNxSx߱dkYxP >s^4pQW
߰ˊ
m?*䂎ZҶ']^-Ϡj{U 4_GuBI$\̈́'2ʂM&y
S"dLG@4p溟J?/Ӎo&io SV#Ɏ,PԶ.Ӛq5]cYyeL@ U&< vْ@h"t_U-kOΉ; 7cہeU*E\Si6~*k#k.5ZvV١E`\A",9~$mezso{&z KaZE7[/5,:ELF^"it1ϛ'lf}2~C&g80, +l7>a`&M_k)
Kj e9(*0%#ӯBn|]DEܸbRj@ANH `CHjƹ G
'g9Q$th2I.5}ˊ(ZhqYjD#@DND()!D)^)Hf@ȤhxB94U'騛7əldd >Ĥ彎/f U pkF8z!-]+jQ0eˢQR=+7V"兞F(j9IegU@ @X5 wx 05aS~flݳ_l;]0[i}fED R""EJ5nDgϾ70q&4X p|*"Җ fj}QApsI1TT)~u
@Mbw `3˹qfV(#Z5@ Y,e| oJg} ??4,w&
X^o&;FǵEy)PGQP ,x^h8[2E( j;kќkae,NGC :[JgV0FX,$߫,P\Q*!-6 S9TPqs'o"e,T:S\ISh" mV[_!YS;UFp z"}܍fأOy<iV%z3@%%Z ٛfezB/z*EC4x{rLF0/W;) iX}9~vrȅd`,Zv*OH>f9 hy_ryAA.+]:adVGxQY1UK^W2}t8rVoESՠ3^)uO\iݺxq-aOAEd.627kݮOFj R$
w(;ڗܾ^xC{%AJ: hQ_qG<Эޞ6 pDN
\4+v][ Wv8{&f/[;
Rw?!D [>Jɞ'3]yag{nni\Ҋo%K6@>?^VůZo7
F~on6ZNHPJp|Q|hV[$:D2 ֑s
IW>/I㝌9 Kb4Sv0gK
uB3Vܙvm|174D]Q`c d2x Tk2 BZY歆X9Aiӣkv#џ'MeHY-%l:1ɤKbr
_
g__]|)WWr- *EM̷q!{-~zvE<+ ?X5D&nNq
{$^3~W8-
o^
@[EfHb 8n֦X0+rXO FMgt[8]( IUZOij0)NG5 @]Y3 90R5
DFK`>Ͳf3HI!KP!=z1hz K/%{ ǚ* RYlYAڢ COcb7O4=B8~ȐĹ:Ex dDJVV
FEĕUxGUN
*v(Oo :E h ;د 4ƙ5GyѰwsy-DGW4ww `g.6;>C)IcQAp(Kl c z H)< }sOy'}ăNC$| _ol xi fgӳ`CHg,xBK/
/~[>v ĸn
RM0 gC0br
>Jf?d͠4=1ଽE~!~}y9w?N&
qS9-.k\}Dm)T"5H?{[GLɴ#
AIAsAu
69(*e{YΤjKm GȈ 8ƭ35#1HH .r1pFI_ʀCυàAQy"2ʌHr)e~, -d
\@"f % +fG^W(+6
Wlԫ렾y&SP$A /?Q NoF#|4 A,jkKV{P 'b8dw 1}"]GiblVGI
=m4e:nm2٤x͛ .EM)nerp=a `pf'jHyO6r'b
0c !/ؙ鐕 jr5Lxj:%\42SqgR7Ymuh''O9+hH+ҟ(dTf'y! [- ПNsh{ٙw!ÿBtu(ɛ^
}2 { nCJ$Ѯςn-toB8ڂe`<=YIحiG=1» AtJYM zaQ t8~5Jnv %Chx]kFyOTl#҉+V;Fh` lgR1k/\6Ke rPOmgv8sÇZc*"mxgXW z`;ݘE
XifJoE K _ldi9"^?ڝ YQy6 K\C&r4LO;浂bL~D , A\fP
X~O5'gJbt^ R3ɡ* nvҶ6% AviϽE*`
5ز=$z_փ ۊ"[X(
rB~2P }U B~TS x]*Lw@z;:q}#3nr( \G6ul>5ƷoЍlJ ) 8 SS~f&IUln|݃ 3F_/IPֳa >>k@:Ayg~_^TTcC)m}'xdI{$ ѮOjPEo_?^3-d5wluOƩ>o%zGtv5,41Lm4)Ms %Q_מ
q
4.u^IDT qn G*8ui7S3g] ݮĔ14gQ@%,N
TshUhqeq$T8óR<K 0]?3hmlpv2]RƊ` ju+w؏V(u;02B6aA*~L4
- x_O& F{&HՓ &[崋@qIXR%'t 3o Z8hJ錯vf~_ f``&Q@_'- 6<PpSQT|g}G=ހ .
UPu3+*vUP>ʛ!{K=j/zˀ?дǵnD$HKr6 %ƌΜ~
` 8iR`Ivr} jM1I~iAfFU@0vrBU" Օ
KB$J_7!d Z7d%·7^s'@ iƾ$B3f,SGݟtU:5?|9LGzS!%#3yHU'!xшc2 .y^5EvW[n,I #JԮH>UgwɝC{@zߚ˲_
eh
se
P~}yUKk~5O 91K3.6 b }yF(!my=sO|? i96T 1WyrTGfM@D2J;o{a"RxZ~?슅b E*vq
zt ot L
-WE,n#L#L˾
Dx(k&w ӡ,B z.okp\ <4ɒLܘViC{o p`3xywD-:u C9\ޯ qC 33ibyU?[DiV:Ȇvk
U8Lj,`34/'Cbm܂僫$ ۲fK]:1'ƒ+nD"B1Y('Ie tM:yt Db0 Ar}./+'f@)p(B`}'2^1( ]o+D:MR>&<3m*yWS|-mS0e0sk%"bl&۵Ey$v|$&<w(ŲxgD1EjdC.
+3 WZHƛxl5@[׀An,AHx/t7[$ujO>SXpzZz{tfLA~J U
{F7»yTyqhK9
PVAGF عiK}84s$[IP7$,j,^Dv7 FBi2cEB8 tu V#N@$70 PNJ-w;ġ`®hZL0SGU/ց>읉3Pq0ʟu?@,d@2Ý['ܽfSt
O֦;ՙ<:e-GC,:h0Y ,gܘ1`TXva8þ/R͵T'0UT`Ed9Ʌ
|~_cx#nTyx AdfCȘG2H֫;ݵday9V+e en4.3?DX,z:0S ԏUIPRX7hbv慽_? EqnA_υ et,q>,pߦQz26@d #j8 U싆ρJbHʘU8ɚj~V* vgNzX9w L Y/ߪJ*P]T{C6n_}dU-_ڼ1%KX Qm 9m+vg)C.!E_ed+! 4fGhE1Y$4`bft8\>} b;2Y@gPу;)B^(Q rg7 m5;sLɝAczqe2"4wDg 9{q mv1||@jL?w$Ä-I,2yCZz)kZ% Yah
qbg B-Ҫ}1$j i Ё-5^#"0(*Eh, .p~Eje2ssALawS:EsD%Eit"IP #] 8Z~̸=1?*%v/3LyW] ƴRIh%drV,Qa9+ϡ++9itia55WO:^8hBMطpѡ[FEz&lH'V^gcL}W:Rs\X#?j{Ңuɽ$+>:v0 *+5hγ=/W ir+X`#LRTjuc] IAˍ M+e )XO ᛣ(\DwCyl
BSVYqS!bVM^v9k1/L.wh̛_m_l 1Pd~.8,PU`'_`devY!N';oBbN7T>o7 -5Bʛ(G=Љ ϰHֻʪ/оELm2dܳ uc~kQ~l';#O#ڟ+B)j^.be;*g*$xI7D(UqQ
ss {g$ad"zB}o!pꢌ1lYt#zP儗g.OwOe i
szxiYjNܠ3% G)B$*r J]IG*Y.PIZRxe$d- 4( `sRTVh6%Me .tT I(qThy,P-+$@ QCY'P: Ov56d^E TeT- WIފdSUoϣZXi4,^,!
}
C^KjѤU%裏(ܧ?-m"<Ȣ\&6Kyw8Sf/MWzݹ|E
aӤO`;hV K
5DT{2P$B٩}~Y(8
3ZZ lIO '6 :Dwd"r\()nB'N^*[m
Wo=sVQ3
s:r,}GE mdOҲeĘo,X>Y"DC.ceۗ_'5Jw
C)sC43 bV7ESϭ5 dlG dX.5)tS(uR8KeW[߹Φ6i8SC /2t~h
Q{a
c sFN\HWΑςqZ$Q[{Ц{Zh!( Gdu=%/^x }b0(a z~vIX^Sr`氮q l
^ÙPж
˵L
1OU"ef+f }른E@ Gam I,EJۉkZa '
US㶬E*ˢWnDN(a.o^ja}