85 |
|
|
86 |
my $html_header=suck_file("header.html"); |
my $html_header=suck_file("header.html"); |
87 |
my $html_separator=suck_file("separator.html"); |
my $html_separator=suck_file("separator.html"); |
88 |
|
my $html_next=suck_file("next.html"); |
89 |
my $html_footer=suck_file("footer.html"); |
my $html_footer=suck_file("footer.html"); |
90 |
|
|
91 |
#------------------------------------------------------------------ |
#------------------------------------------------------------------ |
92 |
|
|
93 |
sub php_header { |
sub php_header { |
94 |
my ($page_nr,@sql_update) = @_; |
my ($page_nr,@sql_update) = @_; |
95 |
my $out='<? |
my $out='<?php |
96 |
include("common.inc"); |
include("common.php"); |
97 |
if (isset($update)) { |
if (isset($update)) { |
98 |
$member_id=id_decode($a); |
$member_id=id_decode($a); |
99 |
'; |
'; |
115 |
#------------------------------------------------------------------ |
#------------------------------------------------------------------ |
116 |
|
|
117 |
# first, define some constants |
# first, define some constants |
118 |
my $common_inc=' |
my $common_php = suck_file("common.php"); |
|
$PREFIX="'.$prefix.'"; |
|
|
$DB_USER="'.$db_user.'"; |
|
|
$MEMBERS_DB="'.$prefix.'_members"; |
|
|
'; |
|
|
|
|
|
# then append rest of text |
|
|
|
|
|
$common_inc.=<<'End_of_common;'; |
|
|
|
|
|
$conn = pg_connect("dbname=$PREFIX$db user=$DB_USER"); |
|
|
$result=pg_Exec($conn,"set datestyle = 'german'"); |
|
|
|
|
|
set_magic_quotes_runtime(1); |
|
|
|
|
|
// return number of true answers |
|
|
|
|
|
function fix_checkboxes($var,$nr) { |
|
|
for($i=1; $i<=$nr; $i++) { |
|
|
if (isset($GLOBALS[$var."_".$i])) { |
|
|
$GLOBALS[$var."_".$i]="true"; |
|
|
$nr++; |
|
|
} else { |
|
|
$GLOBALS[$var."_".$i]="false"; |
|
|
} |
|
|
} |
|
|
return $nr; |
|
|
|
|
|
} |
|
|
|
|
|
function checked($var) { |
|
|
if ($var == "true" || $var == "t") return 1; |
|
|
return 0; |
|
|
} |
|
|
|
|
|
function id_encode($id) { |
|
|
return md5($id).strtr($id,"1234567890","abcdef1234"); |
|
|
} |
|
|
|
|
|
function id_decode($eid) { |
|
|
$id=substr(strtr($eid,"abcdef1234","1234567890"),32); |
|
|
if (md5($id) == substr($eid,0,32)) { |
|
|
return $id; |
|
|
} else { |
|
|
return 0; |
|
|
} |
|
|
} |
|
|
|
|
|
function fix_sql($sql) { |
|
|
$sql=ereg_replace(",([ \t\n\r]*),",",null\\1,",$sql); |
|
|
$sql=ereg_replace(",([ \t\n\r]*),",",null\\1,",$sql); |
|
|
$sql=ereg_replace(",([ \t\n\r]*),",",null\\1,",$sql); |
|
|
$sql=ereg_replace("=([ \t\n\r,]+)","=null\\1",$sql); |
|
|
$sql=ereg_replace("=([ \t\n\r,]*)$","=null\\1",$sql); |
|
|
return $sql; |
|
|
} |
|
|
|
|
|
function get_answer($p) { |
|
|
global $conn,$id,$db; |
|
|
$result = pg_Exec ($conn,"select $p from $db where id=$id"); |
|
|
if ($result && pg_numrows($result) > 0) { |
|
|
$row=pg_fetch_row($result,0); |
|
|
if (isset($row[0]) && $row[0] != "") { |
|
|
$GLOBALS[$p]=$row[0]; |
|
|
return $row[0]; |
|
|
} |
|
|
} |
|
|
$GLOBALS[$p]=0; |
|
|
return 0; |
|
|
} |
|
|
|
|
|
function get_answers($p) { |
|
|
global $conn,$id,$db; |
|
|
$result = pg_Exec ($conn,"select $p from $db where id=$id"); |
|
|
if ($result && pg_numrows($result) > 0) { |
|
|
$row=pg_fetch_array($result,0); |
|
|
$pit=split(",",$p); |
|
|
while(list($key,$val) = each($row)) { |
|
|
$GLOBALS[$key]=$val; |
|
|
} |
|
|
} |
|
|
} |
|
|
function get_member($pitanja,$uvjet) { |
|
|
global $member_id; |
|
|
$p_conn = pg_connect("dbname=$MEMBERS_DB user=$DB_USER"); |
|
|
if ($uvjet == "") $uvjet="true"; |
|
|
$result=pg_Exec($p_conn,"select id,$pitanja from member |
|
|
where $uvjet and id = $member_id"); |
|
|
$numrows=pg_numrows($result); |
|
|
if ($numrows) { |
|
|
$row=pg_fetch_array($result,0); |
|
|
$pit=split(",",$pitanja); |
|
|
while(list($key,$val) = each($row)) { |
|
|
$GLOBALS["member_".$key]=$val; |
|
|
} |
|
|
} |
|
|
} |
|
|
|
|
|
if (isset($a) && !isset($id) && !isset($pid)) { |
|
|
global $conn,$db,$do_stranice; |
|
|
$pid=id_decode($a); |
|
|
$result = pg_Exec ($conn,"select id,do_stranice from $db where member_id=$pid"); |
|
|
if ($result && pg_numrows($result) > 0) { |
|
|
$row=pg_fetch_array($result,0); |
|
|
$id=$row[id]; |
|
|
$do_stranice=$row[do_stranice]; |
|
|
$do_uri="http://".$SERVER_NAME.":".$SERVER_PORT.$row[do_stranice]; |
|
|
} |
|
|
} |
|
|
|
|
|
End_of_common; |
|
119 |
|
|
120 |
#------------------------------------------------------------------ |
#------------------------------------------------------------------ |
121 |
|
|
238 |
print SQL "create table $dir (do_stranice text default null, ",join(",\n",@sql_create),");\n"; |
print SQL "create table $dir (do_stranice text default null, ",join(",\n",@sql_create),");\n"; |
239 |
close(SQL); |
close(SQL); |
240 |
|
|
241 |
# dump common.inc |
# dump common.php |
242 |
|
|
243 |
|
open(PHP,">$dir/common.php") || die "common.php: $!"; |
244 |
|
$common_php =~ s/##DB##/$dir/g; |
245 |
|
my $db_name = $prefix.$dir; |
246 |
|
$common_php =~ s/##DB_NAME##/$db_name/g; |
247 |
|
$common_php =~ s/##PREFIX##/$prefix/g; |
248 |
|
$common_php =~ s/##DB_USER##/$db_user/g; |
249 |
|
$common_php =~ s/##PREFIX##/$prefix/g; |
250 |
|
my $members_db = $prefix."members"; |
251 |
|
$common_php =~ s/##MEMBERS_DB##/$members_db/g; |
252 |
|
|
253 |
open(PHP,">$dir/common.inc") || die "common.inc: $!"; |
print PHP $common_php; |
|
print PHP '<? $db="'.$dir.'";'; |
|
|
print PHP $common_inc; |
|
|
print PHP '?>'; |
|
254 |
close(PHP); |
close(PHP); |
255 |
|
|
256 |
open(PHP,">$dir/head.php") || die "head.php: $!"; |
open(PHP,">$dir/head.php") || die "head.php: $!"; |
257 |
my $max_page = $page_nr + 1; |
my $max_page = $page_nr - 1; |
258 |
$head_php=~ s/##MAXPAGE##/$max_page/; |
$head_php=~ s/##MAXPAGE##/$max_page/; |
259 |
$head_php=~ s/##TEXT##/Ispunili ste %02d%% ankete/; |
$head_php=~ s/##TEXT##/Ispunili ste %02d%% ankete/; |
260 |
print PHP $head_php; |
print PHP $head_php; |
494 |
$last_fn="index.php" if ($last_fn eq "01.php"); |
$last_fn="index.php" if ($last_fn eq "01.php"); |
495 |
open(PAGE, ">$dir/$last_fn") or die "Couldn't open $last_fn for writing:\n$!"; |
open(PAGE, ">$dir/$last_fn") or die "Couldn't open $last_fn for writing:\n$!"; |
496 |
if ($page_nr == 2) { |
if ($page_nr == 2) { |
497 |
print PAGE '<? |
print PAGE '<?php |
498 |
include("common.inc"); |
include("common.php"); |
499 |
if (isset($do_stranice) && $do_stranice !="") { |
if (isset($do_stranice) && $do_stranice !="") { |
500 |
Header("Location: $do_uri?a=$a"); |
Header("Location: $do_uri?a=$a"); |
501 |
exit; |
exit; |
527 |
@sql_update = (); |
@sql_update = (); |
528 |
|
|
529 |
$last_fn=sprintf("%02d.php",$page_nr); |
$last_fn=sprintf("%02d.php",$page_nr); |
530 |
$last_page="$html_header $body $html_footer"; |
$last_page="$html_header $body $html_next $html_footer"; |
531 |
# delete vars for next page |
# delete vars for next page |
532 |
$page_nr++; |
$page_nr++; |
533 |
$body=""; |
$body=""; |
806 |
} |
} |
807 |
|
|
808 |
#--------------------------------------------------------------- |
#--------------------------------------------------------------- |
|
|
|
|
sub slide { |
|
|
package main; |
|
|
|
|
|
my ($xp, $el, $attref, $ncref) = @_; |
|
|
|
|
|
my $prev = $page_number ? slidename($page_number) : $index; |
|
|
$page_number++; |
|
|
my $fn = slidename($page_number); |
|
|
my $next = slidename($page_number + 1); |
|
|
|
|
|
open(SLIDE, ">$dir/$fn") or die "Couldn't open $fn for writing:\n$!"; |
|
|
|
|
|
print SLIDE $prolog; |
|
|
|
|
|
undef @slidetitle; |
|
|
$body = ''; |
|
|
$inlist = 0; |
|
|
|
|
|
$$ncref = |
|
|
sub { |
|
|
my ($xp, $text) = @_; |
|
|
|
|
|
if (defined $text) { |
|
|
#ignore text at slide toplevel |
|
|
} |
|
|
else { |
|
|
$Titles[$page_number] = $slidetitle[0]; |
|
|
|
|
|
print SLIDE "<title>$slidetitle[0]</title>\n"; |
|
|
print SLIDE $style_link; |
|
|
print SLIDE "</head>\n"; |
|
|
|
|
|
if ($dostyle) { |
|
|
print SLIDE "<body>\n"; |
|
|
} |
|
|
else { |
|
|
print SLIDE "<body background=\"back.gif\">\n"; |
|
|
} |
|
|
|
|
|
my $navbar = "<table class=\"navbar\" width=\"100%\"><tr>\n"; |
|
|
$navbar .= "<td align=\"left\"><a href=\"$prev\">Previous</td>\n"; |
|
|
$navbar .= "<td align=\"left\"><a href=\"$index\">Index</td>\n"; |
|
|
$navbar .= "<td align=\"right\"><a href=\"$next\">Next</td>\n"; |
|
|
$navbar .= "</table>\n"; |
|
|
|
|
|
print SLIDE "$navbar<hr>\n"; |
|
|
if ($dostyle) { |
|
|
print SLIDE "<img class=\"logo\" src=\"logo.gif\">\n"; |
|
|
print SLIDE "<h1 class=\"title\">$slidetitle[1]</h1>\n"; |
|
|
} |
|
|
else { |
|
|
print SLIDE "<table width=\"100%\"><tr><td>\n"; |
|
|
print SLIDE "<img src=\"logo.gif\">\n"; |
|
|
print SLIDE "<td align=\"left\">"; |
|
|
print SLIDE "<h1>"; |
|
|
print SLIDE "<font size=\"7\" color=\"maroon\">$slidetitle[1]"; |
|
|
print SLIDE "</font></h1>\n"; |
|
|
print SLIDE "<tr><td colspan=\"2\">\n"; |
|
|
print SLIDE "<table width=\"80%\"><tr><td>\n"; |
|
|
print SLIDE "<font size=\"+2\">\n"; |
|
|
} |
|
|
print SLIDE $body; |
|
|
|
|
|
if ($inlist) { |
|
|
print SLIDE "\n</$inlist>\n"; |
|
|
} |
|
|
|
|
|
unless ($dostyle) { |
|
|
print SLIDE "\n</font>\n"; |
|
|
print SLIDE "\n</table></table>\n"; |
|
|
} |
|
|
|
|
|
print SLIDE "\n<hr>\n$navbar"; |
|
|
print SLIDE "</body>\n</html>\n"; |
|
|
close(SLIDE); |
|
|
} |
|
|
}; |
|
|
} # End slide |
|
|
|
|
|
sub title { |
|
|
package main; |
|
|
|
|
|
my ($xp, $el, $attref, $ncref) = @_; |
|
|
|
|
|
if ($xp->current_element eq 'slide') { |
|
|
start_mode($xp, 'pass'); |
|
|
|
|
|
$$ncref = |
|
|
sub { |
|
|
$slidetitle[0] = $Text; |
|
|
$slidetitle[1] = $Markedup_Text; |
|
|
}; |
|
|
} |
|
|
} # End title |
|
|
|
|
|
sub point { |
|
|
package main; |
|
|
|
|
|
my ($xp, $el, $attref, $ncref) = @_; |
|
|
|
|
|
if ($inlist and $inlist ne 'ul') { |
|
|
$body .= "\n</$inlist>\n"; |
|
|
$inlist = 0; |
|
|
} |
|
|
|
|
|
unless ($inlist) { |
|
|
$body .= "\n<ul>\n"; |
|
|
} |
|
|
|
|
|
$inlist = 0; |
|
|
|
|
|
if ($dostyle) { |
|
|
$body .= "\n<li><div class=\"point\">"; |
|
|
} |
|
|
else { |
|
|
$body .= "\n<li>"; |
|
|
} |
|
|
|
|
|
$$ncref = |
|
|
sub { |
|
|
my ($xp, $text) = @_; |
|
|
|
|
|
if (defined $text) { |
|
|
$text =~ s/\s+/ /g; |
|
|
$body .= $text; |
|
|
} |
|
|
else { |
|
|
if ($dostyle) { |
|
|
$body .= "</div></li>"; |
|
|
} |
|
|
$body .= "\n</$inlist>\n" |
|
|
if $inlist; |
|
|
$inlist = 'ul'; |
|
|
} |
|
|
}; |
|
|
|
|
|
} # End point |
|
|
|
|
|
sub item { |
|
|
package main; |
|
|
|
|
|
my ($xp, $el, $attref, $ncref) = @_; |
|
|
|
|
|
if ($inlist and $inlist ne 'ul') { |
|
|
$body .= "\n</$inlist>\n"; |
|
|
$inlist = 0; |
|
|
} |
|
|
|
|
|
unless ($inlist) { |
|
|
$body .= "\n<ul>\n"; |
|
|
} |
|
|
|
|
|
$inlist = 0; |
|
|
|
|
|
if ($dostyle) { |
|
|
$body .= "\n<li><div class=\"item\">"; |
|
|
} |
|
|
else { |
|
|
$body .= "\n<li><font face=\"monospace\">"; |
|
|
} |
|
|
|
|
|
$$ncref = |
|
|
sub { |
|
|
my ($xp, $text) = @_; |
|
|
|
|
|
if (defined $text) { |
|
|
$text =~ s/\s+/ /g; |
|
|
$body .= $text; |
|
|
} |
|
|
else { |
|
|
if ($dostyle) { |
|
|
$body .= "</div></li>"; |
|
|
} |
|
|
else { |
|
|
$body .= "</font>"; |
|
|
} |
|
|
$body .= "\n</$inlist>\n" |
|
|
if $inlist; |
|
|
$inlist = 'ul'; |
|
|
} |
|
|
}; |
|
|
} # End item |
|
|
|
|
|
sub def { |
|
|
package main; |
|
|
|
|
|
my ($xp, $el, $attref, $ncref) = @_; |
|
|
|
|
|
if ($inlist and $inlist ne 'dl') { |
|
|
$body .= "\n</$inlist>\n"; |
|
|
$inlist = 0; |
|
|
} |
|
|
|
|
|
unless ($inlist) { |
|
|
$body .= "\n<dl>\n"; |
|
|
} |
|
|
|
|
|
$inlist = 0; |
|
|
|
|
|
if ($dostyle) { |
|
|
$body .= "<dt><span class=\"defterm\">"; |
|
|
$body .= $attref->{term} ."</span></dt>\n"; |
|
|
$body .= "<dd><div class=\"def\">\n"; |
|
|
} |
|
|
else { |
|
|
$body .= "<dt><font face=\"monospace\" color=\"maroon\" style=\"bold\">"; |
|
|
$body .= $attref->{term} . "</font></dt>\n"; |
|
|
$body .= "<dd>"; |
|
|
} |
|
|
|
|
|
$$ncref = |
|
|
sub { |
|
|
my ($xp, $text) = @_; |
|
|
|
|
|
if (defined $text) { |
|
|
$text =~ s/\s+/ /g; |
|
|
$body .= $text; |
|
|
} |
|
|
else { |
|
|
if ($dostyle) { |
|
|
$body .= "</div></dd>\n"; |
|
|
} |
|
|
$body .= "\n</$inlist>\n" |
|
|
if $inlist; |
|
|
$inlist = 'dl'; |
|
|
} |
|
|
}; |
|
|
} # End def |
|
|
|
|
|
sub eg { |
|
|
package main; |
|
|
|
|
|
my ($xp, $el, $attref, $ncref) = @_; |
|
|
|
|
|
if ($dostyle) { |
|
|
$body .= "<div class=\"eg\"><pre>"; |
|
|
} |
|
|
else { |
|
|
$body .= "<table bgcolor=\"tan\" width=\"70%\"><tr><td>\n"; |
|
|
$body .= "<font size=\"+1\"><pre>"; |
|
|
} |
|
|
|
|
|
$$ncref = |
|
|
sub { |
|
|
my ($xp, $text) = @_; |
|
|
|
|
|
if (defined $text) { |
|
|
$body .= $text; |
|
|
} |
|
|
else { |
|
|
if ($dostyle) { |
|
|
$body .= "</pre></div>\n"; |
|
|
} |
|
|
else { |
|
|
$body .= "</pre></font></td></tr></table>\n" |
|
|
} |
|
|
} |
|
|
}; |
|
|
} # End eg |
|
|
|
|
|
sub key { |
|
|
package main; |
|
|
|
|
|
my ($xp, $el, $attref, $ncref) = @_; |
|
|
|
|
|
if ($dostyle) { |
|
|
$body .= "<span class=\"key\">"; |
|
|
} |
|
|
else { |
|
|
$body .= "<font face=\"monospace\" color=\"navy\">"; |
|
|
} |
|
|
|
|
|
$$ncref = |
|
|
sub { |
|
|
my ($xp, $text) = @_; |
|
|
|
|
|
if (defined $text) { |
|
|
$body .= $text; |
|
|
} |
|
|
else { |
|
|
if ($dostyle) { |
|
|
$body .= "</span>"; |
|
|
} |
|
|
else { |
|
|
$body .= "</font>"; |
|
|
} |
|
|
} |
|
|
}; |
|
|
} # End key |
|
|
|
|
|
sub abstract { |
|
|
package main; |
|
|
|
|
|
my ($xp, $el, $attref, $ncref) = @_; |
|
|
|
|
|
if ($dostyle) { |
|
|
$body .= "<span class=\"abstract\">"; |
|
|
} |
|
|
else { |
|
|
$body .= "<font color=\"green\">"; |
|
|
} |
|
|
|
|
|
$$ncref = |
|
|
sub { |
|
|
my ($xp, $text) = @_; |
|
|
|
|
|
if (defined $text) { |
|
|
$body .= $text; |
|
|
} |
|
|
else { |
|
|
if ($dostyle) { |
|
|
$body .= "</span>"; |
|
|
} |
|
|
else { |
|
|
$body .= "</font>"; |
|
|
} |
|
|
} |
|
|
}; |
|
|
} # End abstract |
|
|
|
|
|
sub screen { |
|
|
package main; |
|
|
|
|
|
my ($xp, $el, $attref, $ncref) = @_; |
|
|
|
|
|
if ($dostyle) { |
|
|
$body .= "<pre class=\"screen\">\n"; |
|
|
} |
|
|
else { |
|
|
$body .= "<table bgcolor=\"white\" border=\"1\" width=\"70%\"><tr><td>\n"; |
|
|
$body .= "<font size=\"+1\"><pre>"; |
|
|
} |
|
|
|
|
|
$$ncref = |
|
|
sub { |
|
|
my ($xp, $text) = @_; |
|
|
|
|
|
if (defined $text) { |
|
|
$body .= $text; |
|
|
} |
|
|
else { |
|
|
if ($dostyle) { |
|
|
$body .= "</pre>\n"; |
|
|
} |
|
|
else { |
|
|
$body .= "</pre></td></tr></table>\n"; |
|
|
} |
|
|
} |
|
|
}; |
|
|
} # End screen |
|
|
|
|
|
sub input { |
|
|
package main; |
|
|
|
|
|
my ($xp, $el, $attref, $ncref) = @_; |
|
|
|
|
|
if ($dostyle) { |
|
|
$body .= "<span class=\"input\">"; |
|
|
} |
|
|
else { |
|
|
$body .= "<b>"; |
|
|
} |
|
|
|
|
|
$$ncref = |
|
|
sub { |
|
|
my ($xp, $text) = @_; |
|
|
|
|
|
if (defined $text) { |
|
|
$body .= $text; |
|
|
} |
|
|
else { |
|
|
if ($dostyle) { |
|
|
$body .= "</span>"; |
|
|
} |
|
|
else { |
|
|
$body .= "</b>"; |
|
|
} |
|
|
} |
|
|
}; |
|
|
} # End input |
|
|
|
|
|
sub group { |
|
|
} # End group |
|
|
|
|
|
sub text { |
|
|
package main; |
|
|
|
|
|
my ($xp, $el, $attref, $ncref) = @_; |
|
|
|
|
|
$body .= "<p>\n"; |
|
|
|
|
|
$$ncref = |
|
|
sub { |
|
|
my ($xp, $text) = @_; |
|
|
|
|
|
if (defined $text) { |
|
|
$text =~ s/\s+/ /g; |
|
|
$body .= $text; |
|
|
} |
|
|
}; |
|
|
} # End text |
|
|
|
|
|
sub book { |
|
|
package main; |
|
|
|
|
|
my ($xp, $el, $attref, $ncref) = @_; |
|
|
|
|
|
start_mode($xp, 'object'); |
|
|
|
|
|
$$ncref = |
|
|
sub { |
|
|
my ($xp) = @_; |
|
|
|
|
|
if ($dostyle) { |
|
|
$body .= "<span class=\"booktitle\">"; |
|
|
$body .= sgml_escape($Object->{title}); |
|
|
$body .= "</span>\n"; |
|
|
} |
|
|
else { |
|
|
$body .= "<cite>" . sgml_escape($Object->{title}) . "</cite>\n"; |
|
|
} |
|
|
}; |
|
|
} |
|
|
|
|
|
sub aside { |
|
|
package main; |
|
|
|
|
|
my ($xp, $el, $attref, $ncref) = @_; |
|
|
|
|
|
if ($dostyle) { |
|
|
$body .= "<span class=\"aside\">["; |
|
|
} |
|
|
else { |
|
|
$body .= "<em>["; |
|
|
} |
|
|
|
|
|
|
|
|
$$ncref = |
|
|
sub { |
|
|
my ($xp, $text) = @_; |
|
|
|
|
|
if (defined $text) { |
|
|
$body .= $text; |
|
|
} |
|
|
else { |
|
|
if ($dostyle) { |
|
|
$body .= "]</span>\n"; |
|
|
} |
|
|
else { |
|
|
$body .= "]</em>"; |
|
|
} |
|
|
} |
|
|
}; |
|
|
} |
|
|
|
|
|
sub url { |
|
|
package main; |
|
|
|
|
|
my ($xp, $el, $attref, $ncref) = @_; |
|
|
|
|
|
my $url=''; |
|
|
|
|
|
$$ncref = |
|
|
sub { |
|
|
my ($xp, $text) = @_; |
|
|
|
|
|
if (defined($text)) { |
|
|
$url .= $text; |
|
|
} |
|
|
else { |
|
|
$body .= "<a href=\"$url\">$url</a>"; |
|
|
} |
|
|
} |
|
|
} |
|
|
|
|
|
## Local Variables: ## |
|
|
## mode:perl ## |
|
|
## End: ## |
|