1 |
#!/usr/bin/perl -w |
#!/usr/bin/perl -w |
2 |
# |
# |
3 |
|
# Dobrica Pavlinusic <dpavlin@rot13.org> |
4 |
|
# |
5 |
|
# Originally made for proof. during April 2001; later released under GPL v2 |
6 |
|
# |
7 |
|
# 2003-04-dd general cleanup in preparation of release |
8 |
|
|
9 |
use strict; |
use strict; |
10 |
|
|
11 |
use XML::Parser; |
use XML::Parser; |
12 |
use Text::Iconv; |
use common; |
|
|
|
|
# output charset |
|
|
my $charset='ISO-8859-2'; |
|
|
|
|
|
Text::Iconv->raise_error(0); # Conversion errors raise exceptions |
|
|
my $from_utf8 = Text::Iconv->new('UTF8', $charset); |
|
|
sub x { |
|
|
return $from_utf8->convert($_[0]); |
|
|
} |
|
13 |
|
|
14 |
$|=1; |
$|=1; |
15 |
|
|
16 |
my $Usage =<<'End_of_Usage;'; |
my $Usage =<<'End_of_Usage;'; |
17 |
slides [-h] [-d dir] [-mode mode] slide-doc |
I will write usage information here. I promise! |
|
|
|
|
Convert a slideshow document into html, with a separate html document |
|
|
for each slide and an index to all of them. |
|
|
|
|
|
-h Print this message and exit |
|
|
|
|
|
-w warn about unrecognized tags |
|
|
|
|
|
-d Use dir as directory into which to write html pages. Defaults |
|
|
to basename of supplied doc file. |
|
|
|
|
|
-mode Output mode. Choices are html, html-style. Default is |
|
|
html-style. |
|
|
|
|
18 |
End_of_Usage; |
End_of_Usage; |
19 |
|
|
20 |
my @Modes = qw(object pass skip); |
my @Modes = qw(object pass skip); |
21 |
|
|
22 |
my $dir; |
my $poll; |
23 |
my $dowarn = 1; |
my $dowarn = 1; |
|
my $dostyle = 0; |
|
24 |
|
|
25 |
my $pitanje_nr = 0; # curr. pitanje |
my $pitanje_nr = 0; # curr. pitanje |
26 |
my $pitanje_tag = ""; # originalni oblik broja pitanja |
my $pitanje_tag = ""; # originalni oblik broja pitanja |
53 |
# this is usename in database |
# this is usename in database |
54 |
my $db_user="dpavlin"; |
my $db_user="dpavlin"; |
55 |
|
|
56 |
|
# This option allows users to fill poll without using invitation URL. |
57 |
|
# That also means it's unpossible for them to return to exiting poll |
58 |
|
# because they don't have thair own unique ID. Howver, it enables simple |
59 |
|
# polls to be conducted by just publishing URL to them. |
60 |
|
my $without_invitation=0; |
61 |
|
|
62 |
|
# This will remove numbers before answers. That enables you to have |
63 |
|
# answers written like: |
64 |
|
# 1.1 red |
65 |
|
# 1.2 black |
66 |
|
# and users will see just "red" and "black" |
67 |
|
my $remove_nrs_in_answers=0; |
68 |
|
|
69 |
#------------------------------------------------------------------ |
#------------------------------------------------------------------ |
70 |
|
|
71 |
sub suck_file { |
sub suck_file { |
87 |
sub php_header { |
sub php_header { |
88 |
my ($page_nr,@sql_update) = @_; |
my ($page_nr,@sql_update) = @_; |
89 |
my $out='<?php |
my $out='<?php |
90 |
include("common.php"); |
include_once("common.php"); |
91 |
if (isset($update)) { |
if (isset($update)) { |
92 |
$member_id=id_decode($a); |
$member_id=id_decode($a); |
93 |
'; |
'; |
94 |
$out.=$php_addon[$page_nr-2] if (defined $php_addon[$page_nr-2]); |
$out.=$php_addon[$page_nr-2] if (defined $php_addon[$page_nr-2]); |
95 |
$out.=' |
$out.=' |
96 |
$sql="update '.$dir.' set '.join(",\n",@sql_update).', |
$sql="update '.$poll.' set '.join(",\n",@sql_update).', |
97 |
do_stranice=\'$PHP_SELF\' |
do_stranice=\'$PHP_SELF\' |
98 |
where id=$id"; |
where id=$id"; |
99 |
# print "<pre>$sql</pre>"; |
# print "<pre>$sql</pre>"; |
100 |
$result=pg_Exec($conn,fix_sql($sql)); |
$result=pg_Exec($conn,fix_sql($sql)); |
101 |
} elseif($do_stranice != $PHP_SELF) { |
} elseif($do_stranice != $PHP_SELF && isset($do_uri) && isset($a)) { |
102 |
Header("Location: $do_uri?a=$a"); |
Header("Location: $do_uri?a=$a"); |
103 |
exit; |
exit; |
104 |
} |
} |
128 |
print $Usage; |
print $Usage; |
129 |
exit; |
exit; |
130 |
} |
} |
|
elsif ($opt eq '-d') { |
|
|
$dir = shift; |
|
|
} |
|
|
elsif ($opt eq '-w') { |
|
|
$dowarn = 1; |
|
|
} |
|
|
elsif ($opt eq '-mode') { |
|
|
my $marg = shift; |
|
|
if ($marg eq 'html') { |
|
|
$dostyle = 0; |
|
|
} |
|
|
else { |
|
|
die "Unrecognized mode: $marg\n$Usage"; |
|
|
} |
|
|
} |
|
|
else { |
|
|
die "Unrecognized option: $opt\n$Usage"; |
|
|
} |
|
131 |
} # End of option processing |
} # End of option processing |
132 |
|
|
133 |
my $docfile = shift; |
my $xmlfile = shift; |
134 |
|
|
135 |
die "No docfile provided:\n$Usage" unless defined $docfile; |
die "No poll xml file provided!\n$Usage" unless defined $xmlfile; |
136 |
|
|
137 |
die "Can't read $docfile" unless -r $docfile; |
die "Can't read $xmlfile" unless -r $xmlfile; |
138 |
|
|
139 |
if (defined $dir) { |
if (defined $poll) { |
140 |
die "$dir isn't a directory" unless -d $dir; |
die "$poll isn't a directory" unless -d $poll; |
141 |
} |
} |
142 |
else { |
else { |
143 |
$docfile =~ m!([^/.]+)(?:\.[^/.]*)?$!; |
$xmlfile =~ m!([^/.]+)(?:\.[^/.]*)?$!; |
144 |
$dir = $1; |
$poll = $1; |
145 |
if (-e $dir) { |
if (-e $poll) { |
146 |
die "$dir exists but isn't a directory" |
die "$poll exists but isn't a directory" |
147 |
unless -d $dir; |
unless -d $poll; |
148 |
} |
} |
149 |
else { |
else { |
150 |
mkdir $dir, 0755; |
mkdir $poll, 0755; |
151 |
} |
} |
152 |
} |
} |
153 |
|
|
154 |
my $in_slideshow = 0; |
my $in_poll = 0; |
155 |
my $after_head = 0; |
my $after_head = 0; |
156 |
|
|
157 |
my $Mode = 0; |
my $Mode = 0; |
162 |
my $Object; |
my $Object; |
163 |
my @Ostack = (); |
my @Ostack = (); |
164 |
|
|
165 |
my $intext = 0; |
#my $intext = 0; |
166 |
my $closure; |
my $closure; |
167 |
my @closure_stack = (); |
my @closure_stack = (); |
168 |
|
|
169 |
my $style_link = ''; |
#my $style_link = ''; |
170 |
|
|
171 |
my $index = 'index.html'; |
#my $index = 'index.html'; |
172 |
my @slidetitle; |
#my @slidetitle; |
173 |
my $body; |
my $body; |
174 |
my $inlist = 0; |
#my $inlist = 0; |
175 |
|
|
176 |
my @Titles; |
#my @Titles; |
177 |
|
|
178 |
my $header; |
my $header; |
179 |
|
|
|
my $prolog = "<html><head>\n"; |
|
|
$prolog .= "<!-- Generated by $0 on " . gmtime() . " GMT -->\n"; |
|
|
|
|
180 |
my $page_number = 0; |
my $page_number = 0; |
181 |
|
|
182 |
my $p = new XML::Parser(ErrorContext => 3, |
my $p = new XML::Parser(ErrorContext => 3, |
183 |
Handlers => {Start => \&starthndl, |
Handlers => {Start => \&starthndl, |
184 |
End => \&endhndl, |
End => \&endhndl, |
185 |
Char => \&text}); |
Char => \&text}); |
186 |
$p->parsefile($docfile); |
$p->parsefile($xmlfile); |
187 |
|
|
188 |
#---------------------------------------------------------- |
#---------------------------------------------------------- |
189 |
|
|
191 |
|
|
192 |
print "p[$page_nr] "; |
print "p[$page_nr] "; |
193 |
|
|
194 |
open(PAGE, ">$dir/$last_fn") or die "Couldn't open $last_fn for writing:\n$!"; |
open(PAGE, ">$poll/$last_fn") or die "Couldn't open $last_fn for writing:\n$!"; |
195 |
print PAGE php_header($page_nr,@prelast_sql_update); |
print PAGE php_header($page_nr,@prelast_sql_update); |
196 |
my $next_fn=sprintf("%02d.php",$page_nr); |
my $next_fn=sprintf("%02d.php",$page_nr); |
197 |
$last_page=~s/##NEXTPAGE##/$next_fn/; |
$last_page=~s/##NEXTPAGE##/$next_fn/; |
199 |
close(PAGE); |
close(PAGE); |
200 |
|
|
201 |
$page_nr++; |
$page_nr++; |
202 |
open(PAGE, ">$dir/$next_fn") or die "Couldn't open $next_fn for writing:\n$!"; |
open(PAGE, ">$poll/$next_fn") or die "Couldn't open $next_fn for writing:\n$!"; |
203 |
print PAGE php_header($page_nr,@last_sql_update); |
print PAGE php_header($page_nr,@last_sql_update); |
204 |
print PAGE "$html_header $html_kraj $html_footer"; |
print PAGE "$html_header $html_kraj $html_footer"; |
205 |
close(PAGE); |
close(PAGE); |
206 |
|
|
207 |
# dump sql structure |
# dump sql structure |
208 |
|
|
209 |
open(SQL,">$dir/$dir.sql") || die "$dir.sql: $!"; |
open(SQL,">$poll/$poll.sql") || die "$poll.sql: $!"; |
210 |
|
print SQL "drop database ".$prefix.$poll.";\n"; |
211 |
|
print SQL "create database ".$prefix.$poll.";\n"; |
212 |
|
print SQL "\\connect ".$prefix.$poll.";\n"; |
213 |
print SQL "create table poslani ( member_id int4 not null, unesen timestamp default now() );\n"; |
print SQL "create table poslani ( member_id int4 not null, unesen timestamp default now() );\n"; |
214 |
print SQL "create table $dir (do_stranice text default null, ",join(",\n",@sql_create),");\n"; |
print SQL "create table $poll (do_stranice text default null, ",join(",\n",@sql_create),");\n"; |
215 |
close(SQL); |
close(SQL); |
216 |
|
|
217 |
# dump common.php |
# dump common.php |
218 |
|
|
219 |
open(PHP,">$dir/common.php") || die "common.php: $!"; |
open(PHP,">$poll/common.php") || die "common.php: $!"; |
220 |
$common_php =~ s/##DB##/$dir/g; |
$common_php =~ s/##DB##/$poll/g; |
221 |
my $db_name = $prefix.$dir; |
my $db_name = $prefix.$poll; |
222 |
$common_php =~ s/##DB_NAME##/$db_name/g; |
$common_php =~ s/##DB_NAME##/$db_name/g; |
223 |
$common_php =~ s/##PREFIX##/$prefix/g; |
$common_php =~ s/##PREFIX##/$prefix/g; |
224 |
$common_php =~ s/##DB_USER##/$db_user/g; |
$common_php =~ s/##DB_USER##/$db_user/g; |
225 |
$common_php =~ s/##PREFIX##/$prefix/g; |
$common_php =~ s/##PREFIX##/$prefix/g; |
226 |
my $members_db = $prefix."members"; |
my $members_db = $prefix."members"; |
227 |
$common_php =~ s/##MEMBERS_DB##/$members_db/g; |
$common_php =~ s/##MEMBERS_DB##/$members_db/g; |
228 |
|
$common_php =~ s/##WITHOUT_INVITATION##/$without_invitation/g; |
229 |
|
|
230 |
print PHP $common_php; |
print PHP $common_php; |
231 |
close(PHP); |
close(PHP); |
232 |
|
|
233 |
open(PHP,">$dir/head.php") || die "head.php: $!"; |
open(PHP,">$poll/head.php") || die "head.php: $!"; |
234 |
my $max_page = $page_nr - 1; |
my $max_page = $page_nr - 1; |
235 |
$head_php=~ s/##MAXPAGE##/$max_page/; |
$head_php=~ s/##MAXPAGE##/$max_page/; |
236 |
$head_php=~ s/##TEXT##/Ispunili ste %02d%% ankete/; |
$head_php=~ s/##TEXT##/Ispunili ste %02d%% ankete/; |
237 |
print PHP $head_php; |
print PHP $head_php; |
238 |
close(PHP); |
close(PHP); |
239 |
|
|
240 |
|
# 01.php -> index.php |
241 |
|
rename "$poll/01.php","$poll/index.php" || die "can't rename '$poll/01.php' to index.php"; |
242 |
|
|
243 |
################ |
################ |
244 |
## End of main |
## End of main |
245 |
################ |
################ |
246 |
|
|
247 |
# return unique name of pitanje |
# return unique name of pitanje |
248 |
sub new_pit { |
sub new_pit { |
249 |
my $out="p".$pitanje_nr.$p_suffix; |
my $out="p".$pitanje_nr; |
250 |
|
$out .= "_".$p_suffix if ($p_suffix); |
251 |
$curr_suffix=$p_suffix; |
$curr_suffix=$p_suffix; |
252 |
$p_suffix++; |
$p_suffix++; |
253 |
return $out; |
return $out; |
258 |
return "p".$pitanje_nr.$curr_suffix; |
return "p".$pitanje_nr.$curr_suffix; |
259 |
} |
} |
260 |
|
|
261 |
|
#---------------------------------------------------------- |
262 |
|
|
263 |
sub starthndl { |
sub starthndl { |
264 |
my ($xp, $el, %atts) = @_; |
my ($xp, $el, %atts) = @_; |
265 |
|
|
266 |
# return unless ($in_slideshow or $el eq 'slideshow'); |
# return unless ($in_poll or $el eq 'slideshow'); |
267 |
|
|
268 |
unless ($in_slideshow) { |
unless ($in_poll) { |
269 |
$in_slideshow = $xp->depth + 1; |
$in_poll = $xp->depth + 1; |
270 |
return; |
return; |
271 |
} |
} |
272 |
|
|
313 |
|
|
314 |
my $new_closure; |
my $new_closure; |
315 |
|
|
316 |
my $subname = "Slideshow::$el"; |
my $subname = "Poll::$el"; |
317 |
|
|
318 |
if (defined &$subname) { |
if (defined &$subname) { |
319 |
no strict 'refs'; |
no strict 'refs'; |
321 |
&$subname($xp, $el, \%atts, \$new_closure); |
&$subname($xp, $el, \%atts, \$new_closure); |
322 |
} |
} |
323 |
else { |
else { |
324 |
$body .= $xp->recognized_string; |
$body .= x($xp->recognized_string); |
325 |
$new_closure = |
$new_closure = |
326 |
sub { |
sub { |
327 |
my ($xp, $text) = @_; |
my ($xp, $text) = @_; |
328 |
|
|
329 |
if (defined $text) { |
if (defined $text) { |
330 |
$body .= $text; |
$body .= x($text); |
331 |
} |
} |
332 |
else { |
else { |
333 |
$body .= "</$el>"; |
$body .= x("</$el>"); |
334 |
} |
} |
335 |
}; |
}; |
336 |
} |
} |
342 |
sub endhndl { |
sub endhndl { |
343 |
my ($xp, $el) = @_; |
my ($xp, $el) = @_; |
344 |
|
|
345 |
return unless $in_slideshow; |
return unless $in_poll; |
346 |
|
|
347 |
my $lev = $xp->depth; |
my $lev = $xp->depth; |
348 |
|
|
349 |
if ($lev == $in_slideshow - 1) { |
if ($lev == $in_poll - 1) { |
350 |
$in_slideshow = 0; |
$in_poll = 0; |
351 |
$xp->finish; |
$xp->finish; |
352 |
return; |
return; |
353 |
} |
} |
397 |
$closure = pop(@closure_stack); |
$closure = pop(@closure_stack); |
398 |
} # End endhndl |
} # End endhndl |
399 |
|
|
400 |
|
#---------------------------------------------------------- |
401 |
|
|
402 |
sub text { |
sub text { |
403 |
my ($xp, $data) = @_; |
my ($xp, $data) = @_; |
404 |
|
|
405 |
return unless $in_slideshow; |
return unless $in_poll; |
406 |
|
|
407 |
if ($Mode ) { |
if ($Mode ) { |
408 |
|
|
452 |
$str; |
$str; |
453 |
} # End sgml_escape |
} # End sgml_escape |
454 |
|
|
|
sub slidename { |
|
|
my ($num) = @_; |
|
|
|
|
|
sprintf("slide%03d.html", $num); |
|
|
} # End slidename |
|
455 |
|
|
456 |
################################################################ |
################################################################ |
457 |
|
|
458 |
package Slideshow; |
package Poll; |
459 |
|
|
460 |
sub page { |
sub page { |
461 |
package main; |
package main; |
470 |
print "p[$page_nr] "; |
print "p[$page_nr] "; |
471 |
|
|
472 |
if (defined $last_fn) { |
if (defined $last_fn) { |
473 |
# 01.php -> index.php |
open(PAGE, ">$poll/$last_fn") or die "Couldn't open $last_fn for writing:\n$!"; |
474 |
$last_fn="index.php" if ($last_fn eq "01.php"); |
print PAGE php_header($page_nr,@prelast_sql_update); |
|
open(PAGE, ">$dir/$last_fn") or die "Couldn't open $last_fn for writing:\n$!"; |
|
|
if ($page_nr == 2) { |
|
|
print PAGE '<?php |
|
|
include("common.php"); |
|
|
if (isset($do_stranice) && $do_stranice !="") { |
|
|
Header("Location: $do_uri?a=$a"); |
|
|
exit; |
|
|
} |
|
|
$member_id=id_decode($a); |
|
|
$sql="insert into '.$dir.' ( http_referer,remote_addr,user_agent, member_id ) values (\'$HTTP_REFERER\',\'$REMOTE_ADDR\',\'$HTTP_USER_AGENT\',$member_id)"; |
|
|
|
|
|
# print "<pre>$sql</pre>"; |
|
|
$result=pg_Exec($conn,fix_sql($sql)); |
|
|
$lastoid=pg_getlastoid($result); |
|
|
$result = pg_Exec($conn,fix_sql("select id from '.$dir.' where oid=$lastoid")); |
|
|
$row=pg_fetch_row($result,0); |
|
|
$id=$row[0]; |
|
|
?>'; |
|
|
|
|
|
} else { |
|
|
print PAGE php_header($page_nr,@prelast_sql_update); |
|
|
} # last_sql_update |
|
|
|
|
|
|
|
475 |
my $next_fn=sprintf("%02d.php",$page_nr); |
my $next_fn=sprintf("%02d.php",$page_nr); |
476 |
$last_page=~s/##NEXTPAGE##/$next_fn/; |
$last_page=~s/##NEXTPAGE##/$next_fn/; |
477 |
print PAGE $last_page; |
print PAGE $last_page; |
501 |
$$ncref = sub { |
$$ncref = sub { |
502 |
my ($xp, $text) = @_; |
my ($xp, $text) = @_; |
503 |
if (defined($text)) { |
if (defined($text)) { |
504 |
$body.=$text; |
$body.=x($text); |
505 |
chomp $text; |
chomp $text; |
506 |
$pitanje_tag .= $text; |
$pitanje_tag .= x($text); |
507 |
} else { |
} else { |
508 |
$pitanje_nr = $pitanje_tag; |
$pitanje_nr = $pitanje_tag; |
509 |
$pitanje_nr =~ s/[^0-9a-zA-Z]//g; |
$pitanje_nr =~ s/[^0-9a-zA-Z]//g; |
604 |
|
|
605 |
my @dropdown_data; |
my @dropdown_data; |
606 |
|
|
607 |
|
my $default_value = x($attref->{default_value}) || 'null'; |
608 |
|
my $default_text = x($attref->{default_text}) || '-'; |
609 |
|
|
610 |
$$ncref = sub { |
$$ncref = sub { |
611 |
my ($xp, $text) = @_; |
my ($xp, $text) = @_; |
612 |
|
|
613 |
if (defined $text) { |
if (defined $text) { |
614 |
chomp $text; |
chomp $text; |
615 |
$text=~s/^\s*//g; |
$text=~s/^\s*//g; |
616 |
$text=~s/^[\d\.\s]+//g; |
$text=~s/^[\d\.\s]+//g if ($remove_nrs_in_answers); |
617 |
$text=~s/\s*$//g; |
$text=~s/\s*$//g; |
618 |
push @dropdown_data,x($text) if ($text ne ""); |
push @dropdown_data,x($text) if ($text ne ""); |
619 |
} else { |
} else { |
621 |
my $id=1; |
my $id=1; |
622 |
my $p=new_pit(); |
my $p=new_pit(); |
623 |
$body.="<select name=$p >\n"; |
$body.="<select name=$p >\n"; |
624 |
$body.="<option value=null>-</option>\n"; |
$body.="<option value=\"$default_value\">$default_text</option>\n"; |
625 |
foreach $opt (@dropdown_data) { |
foreach $opt (@dropdown_data) { |
626 |
if (defined($opt) && $opt ne "") { |
if (defined($opt) && $opt ne "") { |
627 |
$body.="<option value=$id>$opt</option>\n"; |
$body.="<option value=$id>$opt</option>\n"; |
681 |
if (defined $text) { |
if (defined $text) { |
682 |
chomp $text; |
chomp $text; |
683 |
$text=~s/^\s*//g; |
$text=~s/^\s*//g; |
684 |
$text=~s/^[\d\.\s]+//g; |
$text=~s/^[\d\.\s]+//g if ($remove_nrs_in_answers); |
685 |
$text=~s/\s*$//g; |
$text=~s/\s*$//g; |
686 |
push @radiobuttons_data,x($text) if ($text ne ""); |
push @radiobuttons_data,x($text) if ($text ne ""); |
687 |
} else { |
} else { |
726 |
if (defined $text) { |
if (defined $text) { |
727 |
chomp $text; |
chomp $text; |
728 |
$text=~s/^\s*//g; |
$text=~s/^\s*//g; |
729 |
$text=~s/^[\d\.\s]+//g; |
$text=~s/^[\d\.\s]+//g if ($remove_nrs_in_answers); |
730 |
$text=~s/\s*$//g; |
$text=~s/\s*$//g; |
731 |
push @checkboxes_data,x($text) if ($text ne ""); |
push @checkboxes_data,x($text) if ($text ne ""); |
732 |
} else { |
} else { |
764 |
} |
} |
765 |
} |
} |
766 |
|
|
767 |
|
print "\n\nTo create database for poll $poll use:\n\n"; |
768 |
|
print "\$ psql template1 < $poll/$poll.sql\n\n"; |
769 |
|
print "THIS WILL DISTROY ALL DATA IN EXISTING DATABASE ".$prefix.$poll." !!\n"; |
770 |
|
|
771 |
|
# read configuration data |
772 |
|
# |
773 |
|
# FIX: write actually this :-) |
774 |
|
sub config { |
775 |
|
package main; |
776 |
|
my ($xp, $el, $attref, $ncref) = @_; |
777 |
|
|
778 |
|
$$ncref = sub { |
779 |
|
my ($xp, $text) = @_; |
780 |
|
$db_user=x($attref->{db_user}); |
781 |
|
$prefix=x($attref->{prefix}); |
782 |
|
$without_invitation=x($attref->{without_invitation}) && |
783 |
|
print "Pool is without need for unique ID (and invitation URLs).\n"; |
784 |
|
$remove_nrs_in_answers=x($attref->{$remove_nrs_in_answers}) && |
785 |
|
print "Numbers before answers will be removed.\n"; |
786 |
|
} |
787 |
|
} |
788 |
|
|
789 |
#--------------------------------------------------------------- |
#--------------------------------------------------------------- |