A (dirty) way to get the users name from your db

[Tribalx]

I tried to get a username into a session and call it whitin the chat, with alot of errors and 3 hours of pain (yeah it still hurts ffs )
On a diffrent approach (using the hot mysql database ) i have found a simple solution to fix it all. (we overrule some shiznit )

Q: How did i do it?
A: Simple wiseguy, yust with my fingers and a keyboard

Q: Can i modify the source?
A: It was 2 minutes work, so why shouldnt you

Q: Can i be your girlfriend?
A: No im sorry, i dont do E-dating, maybe next time

Enough bullsh!t, here is the source, with some explanation and guide lines

find: pfcuserconfig and scroll down to
$this->nickid = session_id();

// user parameters are cached in sessions

$this->_getParam("nick");

(somewhere around line 20-30)

paste this code under that line

Code: Select all

      
      $user = "";//username
      $pass = "";//password
      $host = "";//ussaly localhost
      $db = "";//database

      mysql_connect($host,$user,$pass)or die ("error"); // the connection
      mysql_select_db($db); // select your db
            
      $select = mysql_query("SELECT  the_user_name FROM a_table WHERE some_session_ip = '".$_SERVER['REMOTE_ADDR']."'"); // select the user
      $name = mysql_fetch_assoc($select);
      $nick = $name['player']; // now the username is located in $nick

1 line below your copied/pasted code you see this line
if (!isset($this->nick)) $this->_setParam("nick",""); // setup a blank nick if it is not yet in session

change that into:

Code: Select all

if (!isset($this->nick)) $this->_setParam("nick",$nick); // setup a blank nick if it is not yet in session

Now you might want to run some extra checks, so do it, no dont wait, why are you still reading?
aaarghhhhhh...

Have a nice day

[datacompboy]

I think, you do lot of strage things.
For show popup with user real name from info, just set up in chat-init script
$sql = "select nick, realname from users where id = ".$_SESSION['userid'];
$res = db_selectrow($sql);
$params['frozen_nick'] = true;
$params['nick'] = $res['nick'];
$params['nickmeta']['realname'] = $res['realname'];
... other parameters
$chat = new phpFreeChat($params);

that's all: user will have in chat his nick on site, and in user popup will be his real name.

[Tribalx]

and your not getting errors with that code?
becaus i have tried the exact same thing and it told me i had session errors

[datacompboy]

It works for me.

[KDB9000]

Do you know if there is away I can set phpfreechat's user ID to the user ID for my CMS system? I am making a plugin for e107 to use this system an would like it if you click on a users name and it pulls up their profile but the profile is uses the CMS's ID system. So I need a way for it to link the to together and if i can get phpfreechat's user ID to match the user ID of my CMS then I should be able to get it to work.

[roberte]

How do I use this one?

$sql = "select nick, realname from users where id = ".$_SESSION['userid'];
$res = db_selectrow($sql);
$params['frozen_nick'] = true;
$params['nick'] = $res['nick'];
$params['nickmeta']['realname'] = $res['realname'];
... other parameters
$chat = new phpFreeChat($params);


-------------------------------------------------------------------------------------------
Or This one?

$user = "";//username
$pass = "";//password
$host = "";//ussaly localhost
$db = "";//database

mysql_connect($host,$user,$pass)or die ("error"); // the connection
mysql_select_db($db); // select your db

$select = mysql_query("SELECT the_user_name FROM a_table WHERE some_session_ip = '".$_SERVER['REMOTE_ADDR']."'"); // select the user
$name = mysql_fetch_assoc($select);
$nick = $name['player']; // now the username is located in $nick

-------------------------------------------------------------------------------------------

I really need some help with this part. I must have my users' data in the chat. Which of these two are best and how do I do it step by step? Pleeeeeeaaaaaassssse help me!

[OldWolf]

What kind of system are you working with? It really depends on what your basing it from. If, for example, you were using phpbb, I'd suggest the integration already written for it. If you're using your own system, you should be able to figure out your own sessions. So, what sort of session system are you using?

[roberte]

I am working with PHPizabi. I am not much of a programmer by any means, but I love this chat application. Adding it to my site would make for a boost to my sites' use.