Migration to PDO database abstraction layer

[mirrors/Kyberia-bloodline.git] / wwwroot / inc / smarty / node_methodz / function.get_id_by_name.php

diff --git a/wwwroot/inc/smarty/node_methodz/function.get_id_by_name.php b/wwwroot/inc/smarty/node_methodz/function.get_id_by_name.php
index 77552050f94fb8b70b14a8a9330734e66bc7cfce..ba6dab7b41b6e216a76ee0aaba85e869ee997cdb 100644 (file)
--- a/wwwroot/inc/smarty/node_methodz/function.get_id_by_name.php
+++ b/wwwroot/inc/smarty/node_methodz/function.get_id_by_name.php
@@ -1,14 +1,14 @@
 <?php
 function smarty_function_get_id_by_name($params,&$smarty) {
-    $name = mysql_real_escape_string($params['name']);
-    global $db;
-    $q="select user_id from users where login='$name'";
-    $set=$db->query($q);
-    if ($set->getNumRows() > 0) {
-        $set->next();
-        $id=$set->getString('user_id');
-    }
-    else $id = '1';
-    $smarty->assign('get_id_by_name',$id);
+       $name = db_escape_string($params['name']);
+       global $db;
+       $q="select user_id from users where login='$name'";
+       $set=$db->query($q);
+       if ($set && $set->getNumRows() > 0) {
+               $set->next();
+               $id=$set->getString('user_id');
+       }
+       else $id = '1';
+       $smarty->assign('get_id_by_name',$id);
 }
-?>
\ No newline at end of file
+