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 |
|
|
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; |
24 |
|
|
25 |
my $pitanje_nr = 0; # curr. pitanje |
my $pitanje_nr = 0; # curr. pitanje |
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 |
#------------------------------------------------------------------ |
#------------------------------------------------------------------ |
63 |
|
|
64 |
sub suck_file { |
sub suck_file { |
80 |
sub php_header { |
sub php_header { |
81 |
my ($page_nr,@sql_update) = @_; |
my ($page_nr,@sql_update) = @_; |
82 |
my $out='<?php |
my $out='<?php |
83 |
include("common.php"); |
include_once("common.php"); |
84 |
if (isset($update)) { |
if (isset($update)) { |
85 |
$member_id=id_decode($a); |
$member_id=id_decode($a); |
86 |
'; |
'; |
87 |
$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]); |
88 |
$out.=' |
$out.=' |
89 |
$sql="update '.$dir.' set '.join(",\n",@sql_update).', |
$sql="update '.$poll.' set '.join(",\n",@sql_update).', |
90 |
do_stranice=\'$PHP_SELF\' |
do_stranice=\'$PHP_SELF\' |
91 |
where id=$id"; |
where id=$id"; |
92 |
# print "<pre>$sql</pre>"; |
# print "<pre>$sql</pre>"; |
93 |
$result=pg_Exec($conn,fix_sql($sql)); |
$result=pg_Exec($conn,fix_sql($sql)); |
94 |
} elseif($do_stranice != $PHP_SELF) { |
} elseif($do_stranice != $PHP_SELF && isset($do_uri) && isset($a)) { |
95 |
Header("Location: $do_uri?a=$a"); |
Header("Location: $do_uri?a=$a"); |
96 |
exit; |
exit; |
97 |
} |
} |
129 |
|
|
130 |
die "Can't read $xmlfile" unless -r $xmlfile; |
die "Can't read $xmlfile" unless -r $xmlfile; |
131 |
|
|
132 |
if (defined $dir) { |
if (defined $poll) { |
133 |
die "$dir isn't a directory" unless -d $dir; |
die "$poll isn't a directory" unless -d $poll; |
134 |
} |
} |
135 |
else { |
else { |
136 |
$xmlfile =~ m!([^/.]+)(?:\.[^/.]*)?$!; |
$xmlfile =~ m!([^/.]+)(?:\.[^/.]*)?$!; |
137 |
$dir = $1; |
$poll = $1; |
138 |
if (-e $dir) { |
if (-e $poll) { |
139 |
die "$dir exists but isn't a directory" |
die "$poll exists but isn't a directory" |
140 |
unless -d $dir; |
unless -d $poll; |
141 |
} |
} |
142 |
else { |
else { |
143 |
mkdir $dir, 0755; |
mkdir $poll, 0755; |
144 |
} |
} |
145 |
} |
} |
146 |
|
|
184 |
|
|
185 |
print "p[$page_nr] "; |
print "p[$page_nr] "; |
186 |
|
|
187 |
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$!"; |
188 |
print PAGE php_header($page_nr,@prelast_sql_update); |
print PAGE php_header($page_nr,@prelast_sql_update); |
189 |
my $next_fn=sprintf("%02d.php",$page_nr); |
my $next_fn=sprintf("%02d.php",$page_nr); |
190 |
$last_page=~s/##NEXTPAGE##/$next_fn/; |
$last_page=~s/##NEXTPAGE##/$next_fn/; |
192 |
close(PAGE); |
close(PAGE); |
193 |
|
|
194 |
$page_nr++; |
$page_nr++; |
195 |
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$!"; |
196 |
print PAGE php_header($page_nr,@last_sql_update); |
print PAGE php_header($page_nr,@last_sql_update); |
197 |
print PAGE "$html_header $html_kraj $html_footer"; |
print PAGE "$html_header $html_kraj $html_footer"; |
198 |
close(PAGE); |
close(PAGE); |
199 |
|
|
200 |
# dump sql structure |
# dump sql structure |
201 |
|
|
202 |
open(SQL,">$dir/$dir.sql") || die "$dir.sql: $!"; |
open(SQL,">$poll/$poll.sql") || die "$poll.sql: $!"; |
203 |
|
print SQL "drop database ".$prefix.$poll.";\n"; |
204 |
|
print SQL "create database ".$prefix.$poll.";\n"; |
205 |
|
print SQL "\\connect ".$prefix.$poll.";\n"; |
206 |
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"; |
207 |
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"; |
208 |
close(SQL); |
close(SQL); |
209 |
|
|
210 |
# dump common.php |
# dump common.php |
211 |
|
|
212 |
open(PHP,">$dir/common.php") || die "common.php: $!"; |
open(PHP,">$poll/common.php") || die "common.php: $!"; |
213 |
$common_php =~ s/##DB##/$dir/g; |
$common_php =~ s/##DB##/$poll/g; |
214 |
my $db_name = $prefix.$dir; |
my $db_name = $prefix.$poll; |
215 |
$common_php =~ s/##DB_NAME##/$db_name/g; |
$common_php =~ s/##DB_NAME##/$db_name/g; |
216 |
$common_php =~ s/##PREFIX##/$prefix/g; |
$common_php =~ s/##PREFIX##/$prefix/g; |
217 |
$common_php =~ s/##DB_USER##/$db_user/g; |
$common_php =~ s/##DB_USER##/$db_user/g; |
218 |
$common_php =~ s/##PREFIX##/$prefix/g; |
$common_php =~ s/##PREFIX##/$prefix/g; |
219 |
my $members_db = $prefix."members"; |
my $members_db = $prefix."members"; |
220 |
$common_php =~ s/##MEMBERS_DB##/$members_db/g; |
$common_php =~ s/##MEMBERS_DB##/$members_db/g; |
221 |
|
$common_php =~ s/##WITHOUT_INVITATION##/$without_invitation/g; |
222 |
|
|
223 |
print PHP $common_php; |
print PHP $common_php; |
224 |
close(PHP); |
close(PHP); |
225 |
|
|
226 |
open(PHP,">$dir/head.php") || die "head.php: $!"; |
open(PHP,">$poll/head.php") || die "head.php: $!"; |
227 |
my $max_page = $page_nr - 1; |
my $max_page = $page_nr - 1; |
228 |
$head_php=~ s/##MAXPAGE##/$max_page/; |
$head_php=~ s/##MAXPAGE##/$max_page/; |
229 |
$head_php=~ s/##TEXT##/Ispunili ste %02d%% ankete/; |
$head_php=~ s/##TEXT##/Ispunili ste %02d%% ankete/; |
231 |
close(PHP); |
close(PHP); |
232 |
|
|
233 |
# 01.php -> index.php |
# 01.php -> index.php |
234 |
rename "$dir/01.php","$dir/index.php" || die "can't rename '$dir/01.php' to index.php"; |
rename "$poll/01.php","$poll/index.php" || die "can't rename '$poll/01.php' to index.php"; |
235 |
|
|
236 |
################ |
################ |
237 |
## End of main |
## End of main |
239 |
|
|
240 |
# return unique name of pitanje |
# return unique name of pitanje |
241 |
sub new_pit { |
sub new_pit { |
242 |
my $out="p".$pitanje_nr.$p_suffix; |
my $out="p".$pitanje_nr; |
243 |
|
$out .= "_".$p_suffix if ($p_suffix); |
244 |
$curr_suffix=$p_suffix; |
$curr_suffix=$p_suffix; |
245 |
$p_suffix++; |
$p_suffix++; |
246 |
return $out; |
return $out; |
314 |
&$subname($xp, $el, \%atts, \$new_closure); |
&$subname($xp, $el, \%atts, \$new_closure); |
315 |
} |
} |
316 |
else { |
else { |
317 |
$body .= $xp->recognized_string; |
$body .= x($xp->recognized_string); |
318 |
$new_closure = |
$new_closure = |
319 |
sub { |
sub { |
320 |
my ($xp, $text) = @_; |
my ($xp, $text) = @_; |
321 |
|
|
322 |
if (defined $text) { |
if (defined $text) { |
323 |
$body .= $text; |
$body .= x($text); |
324 |
} |
} |
325 |
else { |
else { |
326 |
$body .= "</$el>"; |
$body .= x("</$el>"); |
327 |
} |
} |
328 |
}; |
}; |
329 |
} |
} |
445 |
$str; |
$str; |
446 |
} # End sgml_escape |
} # End sgml_escape |
447 |
|
|
448 |
|
|
449 |
################################################################ |
################################################################ |
450 |
|
|
451 |
package Poll; |
package Poll; |
463 |
print "p[$page_nr] "; |
print "p[$page_nr] "; |
464 |
|
|
465 |
if (defined $last_fn) { |
if (defined $last_fn) { |
466 |
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$!"; |
467 |
if ($page_nr == 2) { |
print PAGE php_header($page_nr,@prelast_sql_update); |
|
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 |
|
|
|
|
|
|
|
468 |
my $next_fn=sprintf("%02d.php",$page_nr); |
my $next_fn=sprintf("%02d.php",$page_nr); |
469 |
$last_page=~s/##NEXTPAGE##/$next_fn/; |
$last_page=~s/##NEXTPAGE##/$next_fn/; |
470 |
print PAGE $last_page; |
print PAGE $last_page; |
754 |
} |
} |
755 |
} |
} |
756 |
|
|
757 |
|
print "\n\nTo create database for poll $poll use:\n\n"; |
758 |
|
print "\$ psql template1 < $poll/$poll.sql\n\n"; |
759 |
|
print "THIS WILL DISTROY ALL DATA IN EXISTING DATABASE ".$prefix.$poll." !!\n"; |
760 |
|
|
761 |
# read configuration data |
# read configuration data |
762 |
# |
# |
763 |
# FIX: write actually this :-) |
# FIX: write actually this :-) |
769 |
my ($xp, $text) = @_; |
my ($xp, $text) = @_; |
770 |
$db_user=x($attref->{db_user}); |
$db_user=x($attref->{db_user}); |
771 |
$prefix=x($attref->{prefix}); |
$prefix=x($attref->{prefix}); |
772 |
|
$without_invitation=x($attref->{without_invitation}); |
773 |
} |
} |
774 |
} |
} |
775 |
|
|