"(%i, %i, '%s', '%s', '%s', 'yes', %i, %i, %i, '%s')", array($_POST['CategoryID'],$_POST['OrderID'],$_POST['CategoryName'],$_POST['ShowCategory'],$_POST['CategoryType'],$_POST['InSubCategory'],$_POST['NumPostView'],$_POST['NumKarmaView'],$_POST['CategoryDesc']));
sql_query($query,$SQLStat);
if($Settings['sqltype']=="mysql"||$Settings['sqltype']=="mysqli"||
- $Settings['sqltype']=="pgsql"||$Settings['sqltype']=="sqlite") {
+ $Settings['sqltype']=="pgsql"||$Settings['sqltype']=="sqlite"||
+ $Settings['sqltype']=="sqlite3") {
$getperidq = sql_pre_query("SELECT DISTINCT \"PermissionID\" FROM \"".$Settings['sqltable']."catpermissions\" ORDER BY \"PermissionID\" ASC", array(null)); }
if($Settings['sqltype']=="cubrid") {
$getperidq = sql_pre_query("SELECT DISTINCT \"permissionid\" FROM \"".$Settings['sqltable']."catpermissions\" ORDER BY \"PermissionID\" ASC", array(null)); }
if($Settings['sqltype']=="mysql"||$Settings['sqltype']=="mysqli"||
$Settings['sqltype']=="pgsql"||$Settings['sqltype']=="cubrid") {
$getperidID=sql_result($getperidr,$getperidi,"PermissionID"); }
-if($Settings['sqltype']=="sqlite") {
+if($Settings['sqltype']=="sqlite"||$Settings['sqltype']=="sqlite3") {
$getperidID=sql_result($getperidr,$getperidi,"\"PermissionID\""); }
$getperidq2 = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."catpermissions\" WHERE \"PermissionID\"=%i", array($getperidID));
$getperidr2=sql_query($getperidq2,$SQLStat);
<td style="width: 50%;"><select size="1" class="TextBox" name="id" id="id">
<?php
if($Settings['sqltype']=="mysql"||$Settings['sqltype']=="mysqli"||
- $Settings['sqltype']=="pgsql"||$Settings['sqltype']=="sqlite") {
+ $Settings['sqltype']=="pgsql"||$Settings['sqltype']=="sqlite"||
+ $Settings['sqltype']=="sqlite3") {
$getperidq = sql_pre_query("SELECT DISTINCT \"PermissionID\" FROM \"".$Settings['sqltable']."catpermissions\"", array(null)); }
if($Settings['sqltype']=="cubrid") {
$getperidq = sql_pre_query("SELECT DISTINCT \"permissionid\" FROM \"".$Settings['sqltable']."catpermissions\"", array(null)); }
if($Settings['sqltype']=="mysql"||$Settings['sqltype']=="mysqli"||
$Settings['sqltype']=="pgsql"||$Settings['sqltype']=="cubrid") {
$getperidID=sql_result($getperidr,$getperidi,"PermissionID"); }
-if($Settings['sqltype']=="sqlite") {
+if($Settings['sqltype']=="sqlite"||$Settings['sqltype']=="sqlite3") {
$getperidID=sql_result($getperidr,$getperidi,"\"PermissionID\""); }
$getperidq2 = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."catpermissions\" WHERE \"PermissionID\"=%i ORDER BY \"CategoryID\" ASC", array($getperidID));
$getperidr2=sql_query($getperidq2,$SQLStat);
sql_query($query,$SQLStat);
if(!is_numeric($_POST['CPermissions'])) { $_POST['CPermissions'] = "0"; }
if($Settings['sqltype']=="mysql"||$Settings['sqltype']=="mysqli"||
- $Settings['sqltype']=="pgsql"||$Settings['sqltype']=="sqlite") {
+ $Settings['sqltype']=="pgsql"||$Settings['sqltype']=="sqlite"||
+ $Settings['sqltype']=="sqlite3") {
$getperidq = sql_pre_query("SELECT DISTINCT \"PermissionID\" FROM \"".$Settings['sqltable']."permissions\" ORDER BY \"PermissionID\" ASC", array(null)); }
if($Settings['sqltype']=="cubrid") {
$getperidq = sql_pre_query("SELECT DISTINCT \"permissionid\" FROM \"".$Settings['sqltable']."permissions\" ORDER BY \"PermissionID\" ASC", array(null)); }
if($Settings['sqltype']=="mysql"||$Settings['sqltype']=="mysqli"||
$Settings['sqltype']=="pgsql"||$Settings['sqltype']=="cubrid") {
$nextperid = sql_get_next_id($Settings['sqltable'],"permissions",$SQLStat); }
-if($Settings['sqltype']=="sqlite") {
+if($Settings['sqltype']=="sqlite"||$Settings['sqltype']=="sqlite3") {
$nextperid = sql_get_next_id($Settings['sqltable'],"\"permissions\"",$SQLStat); }
*/
while ($getperidi < $getperidnum) {
if($Settings['sqltype']=="mysql"||$Settings['sqltype']=="mysqli"||
$Settings['sqltype']=="pgsql"||$Settings['sqltype']=="cubrid") {
$getperidID=sql_result($getperidr,$getperidi,"PermissionID"); }
-if($Settings['sqltype']=="sqlite") {
+if($Settings['sqltype']=="sqlite"||$Settings['sqltype']=="sqlite3") {
$getperidID=sql_result($getperidr,$getperidi,"\"PermissionID\""); }
if($_POST['CPermissions']=="0") {
$getperidq2 = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."permissions\" WHERE \"PermissionID\"=%i", array($getperidID)); }
<td style="width: 50%;"><select size="1" class="TextBox" name="id" id="id">
<?php
if($Settings['sqltype']=="mysql"||$Settings['sqltype']=="mysqli"||
- $Settings['sqltype']=="pgsql"||$Settings['sqltype']=="sqlite") {
+ $Settings['sqltype']=="pgsql"||$Settings['sqltype']=="sqlite"||
+ $Settings['sqltype']=="sqlite3") {
$getperidq = sql_pre_query("SELECT DISTINCT \"PermissionID\" FROM \"".$Settings['sqltable']."permissions\"", array(null)); }
if($Settings['sqltype']=="cubrid") {
$getperidq = sql_pre_query("SELECT DISTINCT \"permissionid\" FROM \"".$Settings['sqltable']."permissions\"", array(null)); }
if($Settings['sqltype']=="mysql"||$Settings['sqltype']=="mysqli"||
$Settings['sqltype']=="pgsql"||$Settings['sqltype']=="cubrid") {
$getperidID=sql_result($getperidr,$getperidi,"PermissionID"); }
-if($Settings['sqltype']=="sqlite") {
+if($Settings['sqltype']=="sqlite"||$Settings['sqltype']=="sqlite3") {
$getperidID=sql_result($getperidr,$getperidi,"\"PermissionID\""); }
$getperidq2 = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."permissions\" WHERE \"PermissionID\"=%i ORDER BY \"ForumID\" ASC", array($getperidID));
$getperidr2=sql_query($getperidq2,$SQLStat);
<option selected="selected" value="0">none</option>
<?php
if($Settings['sqltype']=="mysql"||$Settings['sqltype']=="mysqli"||
- $Settings['sqltype']=="pgsql"||$Settings['sqltype']=="sqlite") {
+ $Settings['sqltype']=="pgsql"||$Settings['sqltype']=="sqlite"||
+ $Settings['sqltype']=="sqlite3") {
$getperidq = sql_pre_query("SELECT DISTINCT \"PermissionID\" FROM \"".$Settings['sqltable']."permissions\"", array(null)); }
if($Settings['sqltype']=="cubrid") {
$getperidq = sql_pre_query("SELECT DISTINCT \"permissionid\" FROM \"".$Settings['sqltable']."permissions\"", array(null)); }
if($Settings['sqltype']=="mysql"||$Settings['sqltype']=="mysqli"||
$Settings['sqltype']=="pgsql"||$Settings['sqltype']=="cubrid") {
$getperidID=sql_result($getperidr,$getperidi,"PermissionID"); }
-if($Settings['sqltype']=="sqlite") {
+if($Settings['sqltype']=="sqlite"||$Settings['sqltype']=="sqlite3") {
$getperidID=sql_result($getperidr,$getperidi,"\"PermissionID\""); }
$getperidq2 = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."permissions\" WHERE \"PermissionID\"=%i ORDER BY \"ForumID\" ASC", array($getperidID));
$getperidr2=sql_query($getperidq2,$SQLStat);
if($Settings['sqltype']=="mysql"||$Settings['sqltype']=="mysqli"||
$Settings['sqltype']=="pgsql"||$Settings['sqltype']=="cubrid") {
$nextperid = sql_get_next_id($Settings['sqltable'],"permissions",$SQLStat); }
-if($Settings['sqltype']=="sqlite") {
+if($Settings['sqltype']=="sqlite"||$Settings['sqltype']=="sqlite3") {
$nextperid = sql_get_next_id($Settings['sqltable'],"\"permissions\"",$SQLStat); }
*/
while ($getperidi < $getperidnum) {
if($Settings['sqltype']=="mysql"||$Settings['sqltype']=="mysqli"||
$Settings['sqltype']=="pgsql"||$Settings['sqltype']=="cubrid") {
$nextperid = sql_get_next_id($Settings['sqltable'],"permissions",$SQLStat); }
-if($Settings['sqltype']=="sqlite") {
+if($Settings['sqltype']=="sqlite"||$Settings['sqltype']=="sqlite3") {
$nextperid = sql_get_next_id($Settings['sqltable'],"\"permissions\"",$SQLStat); }
*/
while ($getperidi < $getperidnum) {
$Settings['sqltype']!="mysqli"&&
$Settings['sqltype']!="pgsql"&&
$Settings['sqltype']!="sqlite"&&
+ $Settings['sqltype']!="sqlite3"&&
$Settings['sqltype']!="cubrid") {
$Settings['sqltype'] = "mysql"; }
if($Settings['sqltype']=="mysql"||
if($Settings['sqltype']=="pgsql") {
$DBType['Server'] = "Postgres ".sql_server_info($SQLStat);
$DBType['Client'] = "Postgres ".sql_client_info($SQLStat); }
-if($Settings['sqltype']=="sqlite") {
+if($Settings['sqltype']=="sqlite"||$Settings['sqltype']=="sqlite3") {
$DBType['Server'] = "SQLite ".sql_server_info($SQLStat);
$DBType['Client'] = sql_client_info($SQLStat); }
if($Settings['sqltype']=="cubrid") {
sql_query($sqlgc,$SQLStat);
$sqlgc = sql_pre_query("SELECT setval('".$Settings['sqltable']."themes_id_seq', 1, false);", array(null));
sql_query($sqlgc,$SQLStat); }
-if($Settings['sqltype']=="sqlite") {
+if($Settings['sqltype']=="sqlite"||$Settings['sqltype']=="sqlite3") {
$sqlgc = sql_pre_query("DELETE FROM \"".$Settings['sqltable']."themes\";", array(null));
sql_query($sqlgc,$SQLStat); }
$skindir = dirname(realpath("sql.php"))."/".$SettDir['themes'];
$TableChCk = array_map("add_prefix",$TableChCk);
$tcount = count($TableChCk); $ti = 0;
$TblOptimized = 0;
-if($Settings['sqltype']!="sqlite") {
+if($Settings['sqltype']!="sqlite"||$Settings['sqltype']=="sqlite3") {
while ($ti < $tcount) {
if(isset($OptimizeAr["Msg_text"])) { unset($OptimizeAr["Msg_text"]); }
if(isset($OptimizeAr[3])) { unset($OptimizeAr[3]); }
isset($OptimizeAr[3])) { $OptimizeAr["Msg_text"] = $OptimizeAr[3]; }
if($OptimizeAr["Msg_text"]=="OK") {
++$TblOptimized; } } ++$ti; } }
-if($Settings['sqltype']=="sqlite") {
+if($Settings['sqltype']=="sqlite"||$Settings['sqltype']=="sqlite3") {
$OptimizeTea = sql_query(sql_pre_query("VACUUM", array(null)),$SQLStat); }
if($Settings['sqltype']=="mysql"||
$Settings['sqltype']=="mysqli"||
$OutPutLog = "MySQL Output: ".$TblOptimized." tables optimized."; }
if($Settings['sqltype']=="pgsql") {
$OutPutLog = "PGSQL Output: All tables optimized."; }
-if($Settings['sqltype']=="sqlite") {
+if($Settings['sqltype']=="sqlite"||$Settings['sqltype']=="sqlite3") {
$OutPutLog = "SQLite Output: All tables optimized."; }
if($Settings['sqltype']=="cubrid") {
$OutPutLog = "CUBRID Output: All tables optimized."; }
?><tr style="text-align: left;">
<td style="width: 50%;"><span class="TextBoxLabel">Database Client:</span></td>
<td style="width: 50%;"><?php echo $DBType['Client']; ?></td>
-</tr><?php } if($Settings['sqltype']=="sqlite") {
+</tr><?php } if($Settings['sqltype']=="sqlite"||$Settings['sqltype']=="sqlite3") {
?><tr style="text-align: left;">
<td style="width: 50%;"><span class="TextBoxLabel">Database File Size:</span></td>
<td style="width: 50%;"><?php echo sprintf("%u", filesize($Settings['sqldb']))." bytes"; ?></td>
<option <?php if($EditMemPerm['PermissionID']=="0") { echo "selected=\"selected\" "; } ?>value="0">use group info</option>
<?php
if($Settings['sqltype']=="mysql"||$Settings['sqltype']=="mysqli"||
- $Settings['sqltype']=="pgsql"||$Settings['sqltype']=="sqlite") {
+ $Settings['sqltype']=="pgsql"||$Settings['sqltype']=="sqlite"||
+ $Settings['sqltype']=="sqlite3") {
$getperidq = sql_pre_query("SELECT DISTINCT \"PermissionID\" FROM \"".$Settings['sqltable']."permissions\"", array(null)); }
if($Settings['sqltype']=="cubrid") {
$getperidq = sql_pre_query("SELECT DISTINCT \"permissionid\" FROM \"".$Settings['sqltable']."permissions\"", array(null)); }
if($Settings['sqltype']=="mysql"||$Settings['sqltype']=="mysqli"||
$Settings['sqltype']=="pgsql"||$Settings['sqltype']=="cubrid") {
$getperidID=sql_result($getperidr,$getperidi,"PermissionID"); }
-if($Settings['sqltype']=="sqlite") {
+if($Settings['sqltype']=="sqlite"||$Settings['sqltype']=="sqlite3") {
$getperidID=sql_result($getperidr,$getperidi,"\"PermissionID\""); }
$getperidq2 = sql_pre_query("SELECT * FROM \"".$Settings['sqltable']."permissions\" WHERE \"PermissionID\"=%i ORDER BY \"PermissionID\" ASC", array($getperidID));
$getperidr2=sql_query($getperidq2,$SQLStat);
<?php if($Settings['sqltype']=="mysql"||
$Settings['sqltype']=="mysqli"||
$Settings['sqltype']=="pgsql"||
- $Settings['sqltype']=="sqlite") { ?>
+ $Settings['sqltype']=="sqlite"||
+ $Settings['sqltype']=="sqlite3") { ?>
</tr><tr class="TableSMenuRow3">
<td class="TableSMenuColumn3"><a href="<?php echo url_maker($exfile['admin'],$Settings['file_ext'],"act=sqldumper",$Settings['qstr'],$Settings['qsep'],$prexqstr['admin'],$exqstr['admin']); ?>">SQL Dumper</a></td>
<?php } ?>
function sql_result($result,$row,$field=0) {
$check = true;
$num = 0;
+$result->reset();
while ($num<$row) {
$result->fetchArray();
$num++; }