Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 483

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/functions_content.php on line 661

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/functions_content.php on line 661

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/functions_content.php on line 661

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/functions_content.php on line 661

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/functions_content.php on line 661

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/functions_content.php on line 661

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/functions_content.php on line 661

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/functions_content.php on line 661

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/ubercode/public_html/forum/includes/bbcode.php on line 112
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3729: Cannot modify header information - headers already sent by (output started at /includes/bbcode.php:483)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3731: Cannot modify header information - headers already sent by (output started at /includes/bbcode.php:483)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3732: Cannot modify header information - headers already sent by (output started at /includes/bbcode.php:483)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3733: Cannot modify header information - headers already sent by (output started at /includes/bbcode.php:483)
ubercode.com • View topic - UC update release
Page 1 of 1

UC update release

PostPosted: Fri Mar 19, 2010 2:01 pm
by onykage
when will the next update for UC be released? Also what changes and or updates can we look forward to with the new release? And will you be released an RC version of the ide first?

Re: UC update release

PostPosted: Fri Mar 19, 2010 5:49 pm
by ubercode
Hello

The current release is version 1.2 - this is a full release available to all licenced users and there's an announcement on the news page http://www.ubercode.com/news.html

There's a list of everything in the version 1.2 release here: http://www.ubercode.com/version-history.html

This should be quite stable as it's being under development for a while. The next release (due later this year or early next year) will include the ability to build an installer directly from a compiled program, and it may include SQL Server express as a built in database.

Kind regards, Will

Re: UC update release

PostPosted: Mon Oct 18, 2010 9:24 pm
by onykage
SWEET!

SQL injection!!!

Its too bad ive had to write an entire lib just to do that very task :twisted:

all fun aside,

does the new SQL feature have security protocols to protect against sql injection threats?

Can you elaborate slightly on some of the features that the new SQL functions will have/not have?

Re: UC update release

PostPosted: Tue Oct 19, 2010 5:30 pm
by ubercode
Most SQL functions will be provided by a new helper library. Basically you create a connection to the database, you can save the connection, then you open it. When open you can retrieve single values, rows or entire result sets, and you can run commands in the database. Finally you close the connection. The helper library is called SQLUTIL and it contains:

Code: Select all
SqlLoginDialog
// Modal dialog that prompts for the database connection details, builds a
// connection string based on user input and optionally saves it in a file.

SqlConnection
// Public type for SQL connections.

SqlOpen
// Open a SQL database connection using settings from a connection string.
// Return the connection object and an optional error message.

SqlClose
// Close the SQL connection (safe even if the connection was never opened).

IsSqlConnectionOpen
// Return True if the connection is open or False otherwise.

SqlUseDB
// Change the current database in an open SQL Connection.

SqlTestConnection
// Test a connection to the database and show a success/failure message.

SqlCommand
// Run a command - This shows a message box if the connection is not open.

SqlLookup
// Run a query and return a single value, equivalent to:
// SELECT TOP 1 <columns> FROM <tab> [WHERE <condition>]
// This shows a message box if an error occurred.

SqlLookupRow
// Run a query and return a single row, equivalent to:
// SELECT TOP 1 <columns> FROM <tab> [WHERE <condition>]
// This shows a message box if an error occurred.

SqlCount
// Count the number of records matching an optional condition, equivalent to:
// SELECT Count(<columns>) FROM <tab> [WHERE <condition>]
// This shows a message box if an error occurred.

SqlSelect
// Run a query and return a table (tabluar result set), equivalent to:
// SELECT <columns> FROM <tab> [WHERE <condition>]
// This shows a message box if an error occurred.

SqlDatabases
// Return a list of databases matching the specified pattern.
// This shows a message box if an error occurred.

SqlTables
// Return a list of tables matching the specified pattern.
// This shows a message box if an error occurred.

SqlColumns
// Return a list of columns in a given table matching the specified pattern.
// This shows a message box if an error occurred.