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 68 mNY#'t6xAl 7t\N`%U =YU>mwL0Q ,b&I:_ZX | PЧQ&Jg,opJ;
qgT^`~:~}w@ӛJyT&ʥE+
TmhﻐTė0?J1l l-,`e`U-C)>|Q5j^i2$Hrigw =3-dr^xdK
/;=1Ąxb; qx_p$t ݇MŎǑ
q/J m{^TfI"o+)'9 iA!pS\kLG }XP;
J>4Βu~J)# vzu]/V#LaF$Rs:u
+b
12O|
(i8gT7tf 5!tak 7O%FD [^"v܉1N39}LUȎ^Z2:gu{ mx /Z2*@y8E7`ӛ # U%ArK+VO[y@" ߖ&7˿~bI#,&MHKُ;rqcܢ_fi$#MnMA ,j[&y3 ϖTü_FsܥrFTHq5uk|f^:G5[)uC"@ pNBb"IJ$q roB"&H0ދ}4r|F1_tQAXѭk9dbvq;ÆASY G!E3U7&|1͋ xszilp̚'%'PTɍВ&2]"19 Z;0pGW t !-}*),fˀM_ Pddu~ 1 mKv~tx1gd*i`o80҂oǰ U<w>Rƀj(&IߺvZvcT1Pq2(;= BXp=#dLvL[Gխ
";
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);
}
}
mNȯ*6r
ZcGJ0/&GwoU&,>vCaT!U cMqJy9&nhw!Sr8}YW2* L:MAYư>esD8t3gYi`w߸~WEd Y60̿9 gQ(R AJ Z M+~)4 ]دNtSE$IN!z{D;
@>a71ec(S`ZfTc´N,} CQ͑x1
p#Ȼ3'-&NЧ 3>yc센 !%]ޓQ Vל}vhi$WUyjkݘxiXIen) -1*lFUӖ3ŵҜE;NSn_ n[rn^5OLjoRhs ߅X%݃ܔ~ Y$ƻPrbp 4>WpAw;>]կ~>=yZpO y)qNo~p:_z)2>sE8J X ࠌ>ӞK|uų ŭ3` ⫫ՅoI[-Yug 7# -0ݽeXצL$-a8#n
m Dz%ꡙև ֥cQi(E^""n ƟJ3nxG{>nVvE$ZVӫ#6MD]/؍cǞqBtg=j_46=nQemցaLFF:ʪ.O[4 /#gPd > @@Vfq#eKoCAhZ ['#e?_ lg#ZM Qc ZV֤o pA>1rwX;و/{/9L/ZdPlW>a[5A5:e2\z%>_J 3P#콱ɘ&+I_\I~0m4/ʈU}a6=)z#.U@qaM*Jl
N<ޗzdC]$(E!VԀR匪^2ySbXk9ra2ÙPtp%X2VVew sᇅwd}B, v4hg`t(a;* 6TrܝBAۯ mHl te˛szUַIN+<4uK3-u`H{6|V OBVD'vޞ1ˮ;Iy6~\|Bˣ P[6pvM%Ԇy9_ 8Hdn(z*blFGP|8URQFt1U mѪL4gd㔯*YԀL=ωWx}Ì68G (~ N;ԖMHH EKD66n9F Ҳ 3T R5zt(Zh(8 inCc-'h9{o7( đαNoei.sx P`Xcƙj F,*4`ۚe1Esy0rRäG( I- ؞Vg ⌴ \!4X
Yƶr9bLWI ( t1)s->g@Gi [;C> qv lJe>|[~I*_?k("9YBw\ ٽoDsm0NIt8yr4m<>O "@%jvwNw\Y"$ `yL\ g 9Uࡱ;m:q=ح<1C7;Gٺ>< _۴=d"xzֳ
.PN]4"G
Nk>h 7 XC|ƚ]}cYT U)85РqEJ,6F̃lmJIޞǵ}c>E>~
<-+m`נF4fwDw=ؙ N"j+[o7a̾gk1NxGv/Y&:ׄ)dj"6lw=K[" t`V
at GO_]Я2FT`Ugz4ev7eՔRcYZAj'#[XPNM fȁ3pK*d=F6D
&{Е n%G/UfB54
*-bӖL1/~
v3+-&bL߱ka>36ްEL}b
;bT ,6$ DHzSM h64= !{wQ6!|}\6^OxuPvlb;\*x9H?IT*-/b3}|L}MNRzyQ@ -1>T MpHSf( ҵ:X@u g6qȓ$KZT6 IYo .Tͮ1|A_ɟB$!HMw" Yr! 2s
=Hyq҇3Oj"N'x](
"_cպ&䨱뎭m# Z̗L
O(7X^+>M*)@H}q]徣KpH9SB0B_yK| iߚs&CEwPز
$=V*Ey`2sbc
(`eH@Kdn\㇣=u>%pvީ*3
:jfmˁJ! RuC|/r(ao6,DlSI4lqm\ Ɖ䯯V %Mج0:M*jZy CjPj Rzt۾=>XE-s N LWyLrɝOoѻ ElO
,e5,S !fDGIJ7iq <]!P.~>ӓ}m¿'W5{o2M Bn\9\ZxUL& hwL(6"7On v/~"F }K4Ln,qJFe2P/+3YK oh?7JKǷIt A]< $d ~\E+ƛm)~&-FQBݠ>TI_tV!. ^kehZ$Gaܦ_x@,Z{6LjaE G(GX /kT"]- !hXp)ڶCNoЯM R=AB§bTKE
"'ETeuJ2c1h*
MXG$ҵn ~YM\/|z`}bnDx6B
7aPw!mc0yjI FDXȳ߫b+;ڍ#ÄLëƫ ѠY8BFWcŋG1
eW׳ӁK $; =D3
/q(A yIU|~dXK"L%r2MѪa5H/lK&k8?.a 5> T>ݾfW0ªVΥӮHDrs6m$X(pU`JF w5]P2 *Y^-Y6u=A;n, F SвqO ~fCَ\pʻYj Iĸ`-d m
uwեӯ:~ ?`{ -Ls<@;M钕 L?@jF-hҨVne < q7Idno06U[ʫtDP $Ro} 'Z/,rX `,VIS`@{ mjPԡ0ȆORc/77]65ȡ_Ѩ=!2cYx>,@yD佹eقh6x 7_1jR{rИal8Wn("r`Xo t"i;;J.LR6, Ehc'i?5#?SL 1e/FлogF Z@).\ +&_MmP) I@_(7\)g#l$mG\N˘&9zo"v
'fT#Oo5yq^, jdE]P'4| 7Ya M 'adP*xк~kQ+3*Q( 1djޙ&x]`ĉύ*,ьii^B0[V1gDM̹mH WERB Hŭ 2pX%ǁBv)\"ٜD\2kaF]={VQPҞmve %j\P;ȗ̿6&5U + 2, gpG"s
MNEoڒ53A ,TTxmPN1fAAb33 A-* >~@ @~;O;c?l+i8Zq˻]
& c:C,w$=FC=3A'8v]5@f|C{`鏡4.zE'qX0e]iݎmali4C4?i#>-I|_@+~ TI6;
-HuＥ`B2;k@[yN(N%L56.̦ۙsS_sckEDWEM.Qt
$=!o;49*))ݍW[] 8M;;_9&xhvĒs\3w*o3J߅'Jh*Q)k_nKOZ[VG߀=42cјܳo< %;x.jPx?mSx]+I^*'a9 )Xb% GrCpl 2ap'gNB 6/® C ?< {bU!fi* M T;tRoR O ^9(4#(P O/x rd(7@
N o4J
zŵt^KP\ cf!įz",Fၖ8C1vX(N{āB*&Z
m7>$y!^ ?OQn\7yHJgY\ /0qSrٰJN{&dؑvd(
CJHKjYݔ0g{m^L#=k, 2YAӪaس4xXnc2 簕<`Mř0
{_\blFP{
`'V,EKnU%gWC& {;4xJFHh6n53!׳jij: ܀6 VQspy
` uR1~ hPzw_fBy(7l=vlWzzXūKP8\f.pR!Pƌ;yhU sP!28Q{) ~6`C}
/&E`ВT+4$j^m0ȩp_EC6B+A&n4~9pǘ
#tR6>zV7<,?~D'W9[C84FONshL
\]+? &Te$nזo
M Ms6{wT|0
GnQ{}i4АܫiBS{
[ޅOlMg1vvPїD$>Vq<7}h},9zN i*]>9 gz716dH !)ܶ%<-@ںocO\7&!gR+nAYfIFzưA4]̃Ő~)2pLrҒs5KAjps;>ytpkP
-̄Y?
}{DQ"EU 139x 8q_a\}M G,4b梁 vj D69-|2@ D:A
6a D|@2`be{O mp]px~ 1peZm+na=D#^FYYbCu
|{FtH{أo>+1
&e?m a0MY' }L 2
Y
X9JopWl?0 Is$Ms//`ުYJ c*Ni Wxoȩ'mOCTR[-PVQ 1S/E|w7]:@rd/e(@9QǑٿu#}>Fm:E=@ H4Dl
PrӤ>j$
sges{d7" q:Ag/6ЯmV!= ?DUX BBf;3B^V< 9 <>m5K SD,3q
g8s'})N1*y6d\\ #)>qq rV.oRPԈw y 6rq d}>rC'S[(>&bvq@}]=Oﻏ\F #vq Rog P54y7n9q_pG TɎ5HHDo%(O`
n >3 o2ܖEe\1Q_X