Custom Query (13 matches)

Filters
 
Or
 
  
 
Columns

Show under each result:

Results (10 - 12 of 13)

← 1 2 3 4 5 →
Ticket Owner Reporter Resolution Summary
#21 Kris Deugau fixed Create minimal interface to change email notification settings
Description

With the who-and-on-which-events internals of the email notice settings moved into a database table, we need an interface to manage those settings.

#29 Kris Deugau Kris Deugau invalid test ticket
Description

testing email

#34 Kris Deugau fixed SQL cleanup - use DBI ? substitutions, move all SQL into IPDB.pm
Description

Much of the SQL currently uses: 

 $sth = $dbh->prepare("INSERT INTO table (cols) values ('$literal1','$literal2')");
 $sth->execute;

instead of: 

 $sth = $dbh->prepare("INSERT INTO table (cols) values (?,?)");
 $sth->execute($literal1, $literal2);

Switching to CGI::Simple (#15) is exposing several places where this is problematic.

This is also something of an SQL-injection security issue - using DBI's parameter replacement means that user data goes right into the table, instead of munging the SQL (deliberately or otherwise).

← 1 2 3 4 5 →
Batch Modify
Note: See TracBatchModify for help on using batch modify.
Note: See TracQuery for help on using queries.