Lines Matching refs:s

63             $table = $row['name']; // no escaping needed, it's our own tables
126                 $s = sprintf('INSERT INTO data_%s SELECT *, 0 FROM temp_data_%s', $name, $name);
127                 $ok = $ok && $sqlite->query($s);
130                 $s = sprintf('INSERT INTO multi_%s SELECT *, 0 FROM temp_multi_%s', $name, $name);
131                 $ok = $ok && $sqlite->query($s);
135                 $s = sprintf('INSERT INTO data_%s SELECT *, pid FROM temp_data_%s', $name, $name);
136                 $ok = $ok && $sqlite->query($s);
139                 $s = sprintf('INSERT INTO multi_%s SELECT *, pid FROM temp_multi_%s', $name, $name);
140                 $ok = $ok && $sqlite->query($s);
144                 $s = "UPDATE data_$name SET pid = ''";
145                 $ok = $ok && $sqlite->query($s);
148                 $s = "UPDATE multi_$name SET pid = ''";
149                 $ok = $ok && $sqlite->query($s);
154             $s = $this->getLookupColsSql($sid);
155             $cols = $sqlite->queryAll($s);
163                     $f = 'UPDATE data_%s
164                              SET %s = \'["\'||%s||\'",0]\'
165                            WHERE %s != \'\'
166                              AND CAST(%s AS DECIMAL) != %s';
167                     $s = sprintf($f, $name, $colname, $colname, $colname, $colname, $colname);
168                     $ok = $ok && $sqlite->query($s);
171                     $f = 'UPDATE multi_%s
173                            WHERE colref = %s
175                     $s = sprintf($f, $name, $colno);
176                     $ok = $ok && $sqlite->query($s);
180                     $s = "UPDATE data_$name
184                     $ok = $ok && $sqlite->query($s);
187                     $s = "UPDATE multi_$name
191                     $ok = $ok && $sqlite->query($s);
200             $s = "DROP TABLE temp_$name";
201             $ok = $ok && $sqlite->query($s);
213         $s = 'ALTER TABLE schemas RENAME TO temp_schemas';
214         $ok = $ok && $sqlite->query($s);
221         $s = 'INSERT INTO schemas SELECT id, tbl, ts, user, comment, config FROM temp_schemas';
222         $ok = $ok && $sqlite->query($s);
250             $s = $this->getLookupColsSql($sid);
251             $cols = $sqlite->queryAll($s);
257                 $s = 'SELECT pid, rid, rev, ' . implode(', ', $colnames) . " FROM data_$name";
258                 $allValues = $sqlite->queryAll($s);
277                 $s = "SELECT colref, pid, rid, rev, row, value FROM multi_$name";
278                 $allValues = $sqlite->queryAll($s);
336             $table = $row['name']; // no escaping needed, it's our own tables
361             $table = $row['name']; // no escaping needed, it's our own tables