Updated copyright notice as there are changes in this year

[mailer.git] / inc / db / lib-mysql3.php

diff --git a/inc/db/lib-mysql3.php b/inc/db/lib-mysql3.php
index d7a7fd3872ea7f8138fb851a8c0be9aace892320..e20b271d441016ce53c29f553404890a75f197cb 100644 (file)
--- a/inc/db/lib-mysql3.php
+++ b/inc/db/lib-mysql3.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -159,7 +159,7 @@ function SQL_NUMROWS ($resource) {
 }
 
 // SQL affected rows
-function SQL_AFFECTEDROWS() {
+function SQL_AFFECTEDROWS () {
        // Valid link resource?
        if (!SQL_IS_LINK_UP()) return FALSE;
 
@@ -223,6 +223,14 @@ function SQL_CONNECT ($host, $login, $password, $F, $L) {
                 * working database link.
                 */
                SQL_SET_LINK(__FUNCTION__, __LINE__, $linkResource);
+
+               // Init charsets (UTF-8 is default now)
+               SQL_QUERY("SET
+       `character_set_results`='utf8',
+       `character_set_client`='utf8',
+       `character_set_connection`='utf8',
+       `character_set_database`='utf8',
+       `character_set_server`='utf8'", __FUNCTION__, __LINE__);
        } // END - if
 
        // Return the resource
@@ -274,10 +282,10 @@ function SQL_FREERESULT ($resource) {
        return $res;
 }
 
-// Get id from last INSERT command
-function SQL_INSERTID () {
+// Get id from last INSERT command and secure id
+function SQL_INSERT_ID () {
        if (!SQL_IS_LINK_UP()) return FALSE;
-       return mysql_insert_id();
+       return bigintval(mysql_insert_id());
 }
 
 // Escape a string for the database