--
-- Table structure for table `intrebari`
--
CREATE TABLE `intrebari` (
`id` int(11) NOT NULL auto_increment,
`intrebare` text NOT NULL,
`raspuns` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3937 ;
--
-- Dumping data for table `intrebari`
--
INSERT INTO `intrebari` VALUES(1, 'Ce drog se gaseste in ceai si in cafea?', 'cofeina');
INSERT INTO `intrebari` VALUES(2, 'Cand a inceput sa creasaca importanta transportului naval?A.1940 B.1950 C.1960', '1950');
INSERT INTO `intrebari` VALUES(3, 'Ce sunt apele calcaroase?', 'ape bogate in calcar');
INSERT INTO `intrebari` VALUES(4, 'Care tara are cele mai mari rezerve de carbune cunoscute? A.Germania B.SUA C.China', 'SUA');
INSERT INTO `intrebari` VALUES(5, 'Cu aproximativ cati ani in urma a luat nastere sistemul nostru solar? A.460 de mil ani B.4600 de mil ani C.46000 de mil.ani', '4600');
INSERT INTO `intrebari` VALUES(6, 'Cate planete se rotesc in jurul soarelui?', '9');
INSERT INTO `intrebari` VALUES(7, 'Care este cea mai mica dintre felinele mici?', 'pisica cu labe negre');
INSERT INTO `intrebari` VALUES(8, 'Care este chatul unde va distrati cel mai bine?', 'WapTT');
INSERT INTO `intrebari` VALUES(9, 'Care este capitala Romaniei?', 'Bucuresti');
INSERT INTO `intrebari` VALUES(10, 'Unde traiesc coralii?', 'in mari');
--
-- Table structure for table `onlinetrivia`
--
CREATE TABLE `onlinetrivia` (
`lton` int(15) NOT NULL default '0',
`uid` int(100) NOT NULL default '0',
PRIMARY KEY (`lton`),
UNIQUE KEY `username` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `onlinetrivia`
--
INSERT INTO `onlinetrivia` VALUES(1203085332, 1262);
INSERT INTO `onlinetrivia` VALUES(1203085348, 567);
INSERT INTO `onlinetrivia` VALUES(1203085347, 568);
Note: Posts were merged-- --------------------------------------------------------
--
-- Table structure for table `trivia`
--
CREATE TABLE `trivia` (
`id` int(11) NOT NULL auto_increment,
`uid` text NOT NULL,
`mesaj` text NOT NULL,
`identificare` text,
`raspuns` text,
`timp` text NOT NULL,
`valid` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1806714 ;
--
-- Dumping data for table `trivia`
--
-- --------------------------------------------------------
Note: Posts were mergedmai am vreun set de 6000 de intrebari pt trivia.
Note: Posts were merged<?php
//welcome to php trivia
//if you need any help please email rambo_shmenaru@yahoo.com
//or come onto irc.netgamers.org #sulla and ask for pwhite
//you need to fill in the database information below
@mysql_connect( "alexwap_site", "alexwap_site", "changemenow" ) or die( "Couldn't connect to MySQL server." ); // CONNECT TO DB OR DIE
@mysql_select_db("bestplace_uv_ro01") or die( "Couldn't connect to Database" );
//there shouldn't be any need to edit below this line unless you want to change the design
?>
<h1> Trivia by r3mbo</h1>
<?php
if ($trivia_id == "")
{
$trivia_id = "1";
}
if ($answer)
{
$type = "1";
$sql2 = mysql_query("SELECT trivia_id, question, answer, alternative1, alternative2 from trivia where trivia_id = $trivia_id");
while($row = mysql_fetch_array($sql2)){
$answer2 = ($row["answer"]);
$alternative1 = ($row["alternative1"]);
$alternative2 = ($row["alternative2"]);
}
if ($answer == $answer2)
{
$correct = "1";
}
elseif ($answer == $alternative1)
{
$correct = "1";
}
elseif ($answer == $alternative2)
{
$correct = "1";
}
else
{
$wrong = "1";
}
if ($correct == "1")
{
$wrong = "0";
}
else
{
$correct = "0";
}
}
if( $type == "1" )
{
if ($correct == "1")
{
echo "<b>Raspuns corect...bravo te duce bibilica

</b><br><br>";
}
if ($wrong == "1")
{
echo "<b>Raspuns gresit</b><br><br>Raspunsul corect era ";
$sql3 = mysql_query("SELECT trivia_id, question, answer, alternative1, alternative2 from trivia where trivia_id = $trivia_id");
while($row = mysql_fetch_array($sql3)){
echo ($row["answer"]);
echo "<br><br>";
}
}
}
else
{
$sql = mysql_query("SELECT trivia_id, question, answer, alternative1, alternative2 from trivia where trivia_id = $trivia_id");
while($row = mysql_fetch_array($sql)){
echo ("<b>Question</b><br><br>". $row['question'] ." ");
}
echo "<br><br><br><form name=\"trivia\" method=\"post\" action=\"$php_self\">";
echo "<b>Answer</b><br><br><input type=\"text\" name=\"answer\" class=\"userinputnm\"><br><input type=\"Submit\" name=\"Submit\" value=\"Submit\" class=\"submitbuttonnm\">";
echo "</form>";
}
if ($trivia_id == "1")
{
$trivia_id1 = "1";
$text = "";
}
else
{
$trivia_id1 = $trivia_id - "1";
$text = "Intrebarea anterioara";
}
if ($trivia_id == "100")
{
$trivia_id2 = "2";
$text2 = "";
}
else
{
$trivia_id2 = $trivia_id + "1";
$text2 = "Intrebarea urmatoare";
}
echo "<a href=trivia.php?trivia_id=$trivia_id1>$text</a>";
echo " ";
echo "<a href=trivia.php?trivia_id=$trivia_id2>$text2</a>";
echo "<br><br><a href=index.php?action=main&sid=$sid/>Meniu prim</a>";
?>
Note: Posts were mergedasta de sus este o trivia mai simpla mai jos sql
Note: Posts were merged#
# Table structure for table `trivia`
#
CREATE TABLE trivia (
trivia_id int(4) unsigned zerofill NOT NULL auto_increment,
question text NOT NULL,
answer varchar(100) NOT NULL default '',
alternative1 varchar(100) default NULL,
alternative2 varchar(100) default NULL,
PRIMARY KEY (trivia_id)
) TYPE=MyISAM;
#
# Dumping data for table `trivia`
#
INSERT INTO trivia (trivia_id, question, answer, alternative1, alternative2) VALUES (0001, 'Cati mb are 1 G?', '1024', '1024', '1024');
INSERT INTO trivia (trivia_id, question, answer, alternative1, alternative2) VALUES (0002, 'Cum se numeste eroul grec care a rapit.o pe Elena,ducand.o in Troia?', 'Paris', 'paris', NULL);
INSERT INTO trivia (trivia_id, question, answer, alternative1, alternative2) VALUES (0003, 'Care este capitala Romaniei?', 'Bucuresti', 'bucuresti', '');
INSERT INTO trivia (trivia_id, question, answer, alternative1, alternative2) VALUES (0004, 'Cate oua face o broasca testoasa?', 'nu stiu', 'Nu Stiu', 'Nu stiu');
INSERT INTO trivia (trivia_id, question, answer, alternative1, alternative2) VALUES (0005, 'Cum i se spunea in evul mediu unei cetati sau unei asezari fortificate?', 'Burg', 'burg', '');
INSERT INTO trivia (trivia_id, question, answer, alternative1, alternative2) VALUES (0006, 'Capitala administrativa a Olandei?', 'Haga', 'haga', '');
Note: Posts were merged