Корисник:DCode/Stvarcici: Разлика помеѓу преработките
Избришана содржина Додадена содржина
Нема опис на уредувањето |
Нема опис на уредувањето |
||
Ред 988:
* echo 'pre>';
*/
?>
</pre>
== function/lib.php ==
<pre>
<?php
/*
* randomize - funkcija za generiranje na random prasanja
* argumenti:
* $kategorija - kategorija na prasanjeto - 1T + 3F, 2T + 2F, 1T - napisano
* $oblast - oblast od koja da se vadi prasanjeto (sport,muzika,film,kompjuteri...)
* $sledno - niza od veke odgovoreni prasanja
*/
function randomize($kategorija,$oblast,$sledno = NULL){
$pack = array();
require("mysql_connect.php");
$user = strip_tags(mysql_real_escape_string($_COOKIE['user']));
if (isset($sledno)){
$string = '';
foreach($sledno as &$i){
$string .= ' AND ID<>'.$i;
}
$query_q = 'SELECT * FROM prasanja WHERE userRef<>'.$user.' AND kategorija='.$kategorija.' AND oblast='.$oblast.$string.' ORDER BY RAND() LIMIT 1';
} else {
$query_q = 'SELECT * FROM prasanja WHERE userRef<>'.$user.' AND kategorija='.$kategorija.' AND oblast='.$oblast.' ORDER BY RAND() LIMIT 1';
}
$check_q = mysql_query($query_q) or die("1. query error <br/>".mysql_error());
$num = mysql_num_rows($check_q);
if($num == 0){
echo "???? ???????";
} else {
$check_q = mysql_fetch_array($check_q);
$pack['prasanje'] = $check_q['prasanje'];
$query_a = 'SELECT * FROM odgovori WHERE referenca='.$check_q['ID'].' ORDER BY RAND()';
$check_a = mysql_query($query_a) or die("2. query error <br/>".mysql_error());
$i = 1;
while($check = mysql_fetch_array($check_a)){
$pack['odgovor'.$i] = $check['odgovor'];
$i++;
}
}
mysql_close();
return $pack;
}
/*
* execute() e funkcija za zapisuvanje na prasanja vo bazata
* prima parametri:
* $kat - kategorija na prasanjata (1-3)
* $user - id na korisnikot
* $points - poeni za prasanjeto
* $oblast - oblast na prasanjeto "film,muzika,kompjuteri..."
* $answerTrue - niza od tochni odgovori
* $answerFalse (opcionalno) - niza od greshni odgovori
*/
function execute($kat,$user,$points,$oblast,$question,$answerTrue,$answerFalse = NULL){
$errors = array();
$query_question = 'INSERT INTO prasanja(prasanje,poeni,kategorija,oblast,userRef) VALUES(
"'.$question.'",'.$points.',"'.$kat.'","'.$oblast.'","'.$user.'"
);';
require("/functions/mysql_connect.php");
mysql_query($query_question) or $errors[] = "1. can't execute query <br/>".mysql_error();
$query_select = 'SELECT ID FROM prasanja WHERE userRef = "'.$user.'" ORDER BY dateCreated DESC LIMIT 1';
$check = mysql_query($query_select) or $errors[] = "2. can't execute query <br/>".mysql_error();;
$num = mysql_num_rows($check);
if($num == 0){
$errors[] = "3. no rows affected <br/>";
} else {
$fetch = mysql_fetch_array($check);
$id = $fetch['ID'];
}
if (empty($errors)){
foreach($answerTrue as &$i){
$query = 'INSERT INTO odgovori(odgovor,vistinitost,referenca) VALUES(
"'.$i.'",1,'.$id.');';
mysql_query($query) or $errors[] = "can't execute question query <br/>";
if(empty($errors)){
continue;
} else {
break;
}
}
} else {
foreach($errors as &$i){
echo $i."<br/";
}
}
if (empty($errors)){
if(isset($answerFalse)){
foreach($answerFalse as &$i){
$query = 'INSERT INTO odgovori(odgovor,vistinitost,referenca) VALUES(
"'.$i.'",0,'.$id.');';
mysql_query($query) or $errors[] = "can't execute question query <br/>";
if(empty($errors)){
continue;
} else {
break;
}
}
}
} else {
foreach($errors as &$i){
echo $i."<br/";
}
}
foreach($errors as &$i){
echo $i."<br/";
}
mysql_close();
}//end of functon
?>
</pre>
== scripts/main.js ==
<pre>
$(document).ready(function(){
/* page transition begin */
$('.container').css('display', 'none');
$('.container').fadeIn(200);
/* windows */
$('#najava').click(function(){
$('.popupBackground').fadeToggle(200);
$('#windowNajava').fadeToggle(200);
$('.popupWindow').css('left',$(window).width()/2 - 200 +'px');
$('.popupWindow').css('top',$(window).height()/2 - 200 +'px');
$('#logInput').focus();
});
$('#registracija').click(function(){
$('.popupBackground').fadeToggle(200);
$('#windowRegistracija').fadeToggle(200);
$('.popupWindow').css('left',$(window).width()/2 - 200 +'px');
$('.popupWindow').css('top',$(window).height()/2 - 200 +'px');
$('#regInput').focus();
});
$('.popupBackground').click(function(){
$('.popupBackground').fadeOut(200);
$('.popupWindow').fadeOut(200);
});
$('#userDrop').mouseover(function(){
$('.dropArea').slideDown(300);
document.getElementById("triagolnik").innerHTML = '▲';
});
$('.dropArea').mouseout(function(){
$('.dropArea').slideUp(300);
document.getElementById("triagolnik").innerHTML = '▼';
});
$(' body').click(function(){
$('.dropArea').slideUp(300);
document.getElementById("triagolnik").innerHTML = '▼';
});
$("#selectable").click(function(){
if($("#selectable").val() == 1)
{
$("#kat1").slideDown(300);
$("#kat2").slideUp(300);
$("#kat3").slideUp(300);
}
else if($("#selectable").val() == 2)
{
$("#kat2").slideDown(300);
$("#kat1").slideUp(300);
$("#kat3").slideUp(300);
}
else if($("#selectable").val() == 3)
{
$("#kat3").slideDown(300);
$("#kat2").slideUp(300);
$("#kat1").slideUp(300);
}
else
{
$("#kat1").slideUp(300);
$("#kat2").slideUp(300);
$("#kat3").slideUp(300);
}
});
});
</pre>
== logout.php ==
<pre>
<?php
if(isset($_COOKIE['user'],$_COOKIE['userName'])){
setcookie("user","",time()-3600);
setcookie("userName","",time()-3600);
} else {
echo "no cookie set";
}
header("Location:.");
?>
</pre>
| |||