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 |
74 |
sub php_header { |
sub php_header { |
75 |
my ($page_nr,@sql_update) = @_; |
my ($page_nr,@sql_update) = @_; |
76 |
my $out='<?php |
my $out='<?php |
77 |
include("common.php"); |
include_once("common.php"); |
78 |
if (isset($update)) { |
if (isset($update)) { |
79 |
$member_id=id_decode($a); |
$member_id=id_decode($a); |
80 |
'; |
'; |
81 |
$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]); |
82 |
$out.=' |
$out.=' |
83 |
$sql="update '.$dir.' set '.join(",\n",@sql_update).', |
$sql="update '.$poll.' set '.join(",\n",@sql_update).', |
84 |
do_stranice=\'$PHP_SELF\' |
do_stranice=\'$PHP_SELF\' |
85 |
where id=$id"; |
where id=$id"; |
86 |
# print "<pre>$sql</pre>"; |
print "<pre>$sql</pre>"; |
87 |
$result=pg_Exec($conn,fix_sql($sql)); |
$result=pg_Exec($conn,fix_sql($sql)); |
88 |
} elseif($do_stranice != $PHP_SELF) { |
} elseif($do_stranice != $PHP_SELF && isset($do_uri) && isset($a)) { |
89 |
Header("Location: $do_uri?a=$a"); |
Header("Location: $do_uri?a=$a"); |
90 |
exit; |
exit; |
91 |
} |
} |
123 |
|
|
124 |
die "Can't read $xmlfile" unless -r $xmlfile; |
die "Can't read $xmlfile" unless -r $xmlfile; |
125 |
|
|
126 |
if (defined $dir) { |
if (defined $poll) { |
127 |
die "$dir isn't a directory" unless -d $dir; |
die "$poll isn't a directory" unless -d $poll; |
128 |
} |
} |
129 |
else { |
else { |
130 |
$xmlfile =~ m!([^/.]+)(?:\.[^/.]*)?$!; |
$xmlfile =~ m!([^/.]+)(?:\.[^/.]*)?$!; |
131 |
$dir = $1; |
$poll = $1; |
132 |
if (-e $dir) { |
if (-e $poll) { |
133 |
die "$dir exists but isn't a directory" |
die "$poll exists but isn't a directory" |
134 |
unless -d $dir; |
unless -d $poll; |
135 |
} |
} |
136 |
else { |
else { |
137 |
mkdir $dir, 0755; |
mkdir $poll, 0755; |
138 |
} |
} |
139 |
} |
} |
140 |
|
|
178 |
|
|
179 |
print "p[$page_nr] "; |
print "p[$page_nr] "; |
180 |
|
|
181 |
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$!"; |
182 |
|
if ($page_nr <= 2) { |
183 |
|
print PAGE php_new_poll(); |
184 |
|
} |
185 |
print PAGE php_header($page_nr,@prelast_sql_update); |
print PAGE php_header($page_nr,@prelast_sql_update); |
186 |
my $next_fn=sprintf("%02d.php",$page_nr); |
my $next_fn=sprintf("%02d.php",$page_nr); |
187 |
$last_page=~s/##NEXTPAGE##/$next_fn/; |
$last_page=~s/##NEXTPAGE##/$next_fn/; |
189 |
close(PAGE); |
close(PAGE); |
190 |
|
|
191 |
$page_nr++; |
$page_nr++; |
192 |
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$!"; |
193 |
print PAGE php_header($page_nr,@last_sql_update); |
print PAGE php_header($page_nr,@last_sql_update); |
194 |
print PAGE "$html_header $html_kraj $html_footer"; |
print PAGE "$html_header $html_kraj $html_footer"; |
195 |
close(PAGE); |
close(PAGE); |
196 |
|
|
197 |
# dump sql structure |
# dump sql structure |
198 |
|
|
199 |
open(SQL,">$dir/$dir.sql") || die "$dir.sql: $!"; |
open(SQL,">$poll/$poll.sql") || die "$poll.sql: $!"; |
200 |
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"; |
201 |
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"; |
202 |
close(SQL); |
close(SQL); |
203 |
|
|
204 |
# dump common.php |
# dump common.php |
205 |
|
|
206 |
open(PHP,">$dir/common.php") || die "common.php: $!"; |
open(PHP,">$poll/common.php") || die "common.php: $!"; |
207 |
$common_php =~ s/##DB##/$dir/g; |
$common_php =~ s/##DB##/$poll/g; |
208 |
my $db_name = $prefix.$dir; |
my $db_name = $prefix.$poll; |
209 |
$common_php =~ s/##DB_NAME##/$db_name/g; |
$common_php =~ s/##DB_NAME##/$db_name/g; |
210 |
$common_php =~ s/##PREFIX##/$prefix/g; |
$common_php =~ s/##PREFIX##/$prefix/g; |
211 |
$common_php =~ s/##DB_USER##/$db_user/g; |
$common_php =~ s/##DB_USER##/$db_user/g; |
216 |
print PHP $common_php; |
print PHP $common_php; |
217 |
close(PHP); |
close(PHP); |
218 |
|
|
219 |
open(PHP,">$dir/head.php") || die "head.php: $!"; |
open(PHP,">$poll/head.php") || die "head.php: $!"; |
220 |
my $max_page = $page_nr - 1; |
my $max_page = $page_nr - 1; |
221 |
$head_php=~ s/##MAXPAGE##/$max_page/; |
$head_php=~ s/##MAXPAGE##/$max_page/; |
222 |
$head_php=~ s/##TEXT##/Ispunili ste %02d%% ankete/; |
$head_php=~ s/##TEXT##/Ispunili ste %02d%% ankete/; |
224 |
close(PHP); |
close(PHP); |
225 |
|
|
226 |
# 01.php -> index.php |
# 01.php -> index.php |
227 |
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"; |
228 |
|
|
229 |
################ |
################ |
230 |
## End of main |
## End of main |
306 |
&$subname($xp, $el, \%atts, \$new_closure); |
&$subname($xp, $el, \%atts, \$new_closure); |
307 |
} |
} |
308 |
else { |
else { |
309 |
$body .= $xp->recognized_string; |
$body .= x($xp->recognized_string); |
310 |
$new_closure = |
$new_closure = |
311 |
sub { |
sub { |
312 |
my ($xp, $text) = @_; |
my ($xp, $text) = @_; |
313 |
|
|
314 |
if (defined $text) { |
if (defined $text) { |
315 |
$body .= $text; |
$body .= x($text); |
316 |
} |
} |
317 |
else { |
else { |
318 |
$body .= "</$el>"; |
$body .= x("</$el>"); |
319 |
} |
} |
320 |
}; |
}; |
321 |
} |
} |
437 |
$str; |
$str; |
438 |
} # End sgml_escape |
} # End sgml_escape |
439 |
|
|
440 |
|
|
441 |
|
sub php_new_poll { |
442 |
|
return '<?php |
443 |
|
include_once("common.php"); |
444 |
|
if (isset($do_stranice) && $do_stranice !="") { |
445 |
|
Header("Location: $do_uri?a=$a"); |
446 |
|
exit; |
447 |
|
} |
448 |
|
$member_id=id_decode($a); |
449 |
|
$sql="insert into '.$poll.' ( http_referer,remote_addr,user_agent, member_id ) values (\'$HTTP_REFERER\',\'$REMOTE_ADDR\',\'$HTTP_USER_AGENT\',$member_id)"; |
450 |
|
|
451 |
|
# print "<pre>$sql</pre>"; |
452 |
|
$result=pg_Exec($conn,fix_sql($sql)); |
453 |
|
$lastoid=pg_getlastoid($result); |
454 |
|
$result = pg_Exec($conn,fix_sql("select id from '.$poll.' where oid=$lastoid")); |
455 |
|
$row=pg_fetch_row($result,0); |
456 |
|
$id=$row[0]; |
457 |
|
?>'; |
458 |
|
} |
459 |
|
|
460 |
################################################################ |
################################################################ |
461 |
|
|
462 |
package Poll; |
package Poll; |
474 |
print "p[$page_nr] "; |
print "p[$page_nr] "; |
475 |
|
|
476 |
if (defined $last_fn) { |
if (defined $last_fn) { |
477 |
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$!"; |
478 |
if ($page_nr == 2) { |
if ($page_nr < 2) { |
479 |
print PAGE '<?php |
print PAGE php_new_poll(); |
|
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]; |
|
|
?>'; |
|
|
|
|
480 |
} else { |
} else { |
481 |
print PAGE php_header($page_nr,@prelast_sql_update); |
print PAGE php_header($page_nr,@prelast_sql_update); |
482 |
} # last_sql_update |
} # last_sql_update |