Current Logins

[Cyndaquil]

Hello,

I am wondering how to create the User Login widget which can go on websites and/or forums?
If you could help that would be fantastic!

Thank You,
Chris

[MentaL]

[Bakey]

What widget O_O.

[Cyndaquil]

Basically it shows who logins into the game - Like on Terra, fine Terra has it but yeah its cool, it just auto refreshes when someone logs in.

[Flash1369]

i guess it refreshes every one second, donno if what you said is possibro.

[Cyndaquil]

i guess it refreshes every one second, donno if what you said is possibro.

Terra had it :o doesnt work atm and so did Sin Online.

[Meink]

You mean live logins.

[Bakey]

I made the one for Sin, nothing fancy, just a quick job.

[Cyndaquil]

Would you be so kind to release it Bakey ^^? Much appreciated if you do :)!

[Bakey]

Sorry, since I am a "shit dev", I don't feel good releasing it to other people because, it might have vulns in it.

[Cyndaquil]

Ok then :)! No problem. not gunna lose sleep over it O_o

[hamisgood87]

Sorry, since I am a "shit dev", I don't feel good releasing it to other people because, it might have vulns in it.

dat vulns, So scary x.x I shall look into this! Although I doubt I'll figure it out xD.
K so, I made something really quick, based off of another script I found in the forums. Yea I don't know php... Also it takes character name instead of account name. It does work, just tested it.

<?php  

    // CONFIG 
    $odbc_host = ''; 
    $odbc_user = ''; 
    $odbc_pass = ''; 
    // CONFIG END 
     
    echo '<h1><center>Last 5 players to log on</h1></center>'; 
    $odbc_link = odbc_connect ( "Driver={SQL Server};Server=".$odbc_host.";Database=World00_Character;" , $odbc_user , $odbc_pass ); 
     
    $sql[1] = 'SELECT TOP 5 nCharNo, sID, dLastLoginDate FROM tCharacter WHERE bDeleted = 0 ORDER  BY dLastLoginDate DESC'; 
    $rs[1] = odbc_exec ( $odbc_link , $sql[1] ); 
    if ( !$rs[1] ) 
        { 
        exit ( 'Error in SQL' ); 
        } 
     
    $i = 1; 
         
    echo '<table width="100%">'; 
    echo '    <tr>'; 
    echo '        <td>'; 
    echo '            <h3>#</h3>'; 
    echo '        </td>';
    echo '        <td>'; 
    echo '            <h3>Name</h3>'; 
    echo '        </td>';
    echo '    </tr>'; 
    while ( odbc_fetch_row ( $rs[1] ) ) 
        { 
        $sID = odbc_result ( $rs[1] , 'sID' ); ; 
        $sID = str_replace ( 'ä' , '&auml;' , str_replace ( 'Ä' , '&Auml;' , str_replace ( 'ö' , '&ouml;' , str_replace ( 'Ö' , '&Ouml;' , str_replace ( 'ü' , '&uuml;' , str_replace ( 'Ü' , '&Uuml;' , str_replace ( 'ß' , '&szlig;' , $sID ) ) ) ) ) ) ); 
         
        $nCharNo = odbc_result ( $rs[1] , 'nCharNo' ); 

         
        echo '    <tr>'; 
        echo '        <td>'; 
        echo '            '.$i; 
        echo '        </td>'; 
        echo '        <td>'; 
        echo '            '.$sID; 
        echo '        </td>';  
        echo '        <td>'; 
        echo '    </tr>'; 
         
        $i++; 
        } 
         
    odbc_close ( $odbc_link ); 
     
    echo '</table>'; 

?>

[xWhiteCore]

Terra had it :o doesnt work atm and so did Sin Online.

It's a simple PHP code i've it also...

[hamisgood87]

It's a simple PHP code i've it also...

Good job. We figured that out already.
Now that i look at the script I posted... I have realized something... It looks absolutely terrible.

[Bakey]

Completely wrong.

[hamisgood87]

Completely wrong.

What?

[Bakey]

1. That's character logins, not account logins.
2. That won't auto-refresh.
3. You're not caching so you're going to put a lot of stress on your server, doing query-per-second for every person viewing the page (After you get the refresh part fixed).
4. The code is just plain out messy, I could sit here and point out things that are bad practice.

[Gruntilda]

Thanks for letting me know Terra's didn't work, forgot about it c: Fixed -*-*

And btw, you could just look at T's html source and pretty much figure out how it was done.

http://tll2.extrinsicstudio.com

[Bakey]

Thanks for letting me know Terra's didn't work, forgot about it c: Fixed

Omg source pls.

[hamisgood87]

1. That's character logins, not account logins.
2. That won't auto-refresh.

#1 I think i said that for it being character.
#2 yea true.

3. You're not caching so you're going to put a lot of stress on your server, doing query-per-second for every person viewing the page (After you get the refresh part fixed).

I shall do that after looking into it!...cause I just have no idea.

4. The code is just plain out messy, I could sit here and point out things that are bad practice.

I don't know php and i pretty much just copied somebody else's code for something else and changed a few things.

[xWhiteCore]

What?

Bakey has right.. it's wrong...

[hamisgood87]

late again... We all already see that.

[josh2k7]

ok i have to say this Bakey who in there right mind said your "shit Dev" i would like to know this cause truthfully that person needs to take a .357 load it insert in there mouth and pull the trigger cause i know that you are not a "shit Dev" bakey your one of the best out there so i think someone is a complete retard and the world would be better off with out that person in it but yeah im sorry someone said that to you bakey

[Bakey]

Ceila did, on another forum. Things get around though, you know?

[josh2k7]

well bakey what i said is fact and he is just gonna have to deal with the fact that anyone who knows anything knows that you are a much better dev than ceila on one of ur bad days and ceila can go fuck him or herself cause i know u do so much better and ceila is just mad cause you wont teach the knowledge to him or her so ceila can go right on hating because we all know bakey haters will hate so i say this "fuck you ceila u wanna rag on someone rag on a noob like me dont lie about ppl who are better than you at developing"

[Cyndaquil]

well bakey what i said is fact and he is just gonna have to deal with the fact that anyone who knows anything knows that you are a much better dev than ceila on one of ur bad days and ceila can go fuck him or herself cause i know u do so much better and ceila is just mad cause you wont teach the knowledge to him or her so ceila can go right on hating because we all know bakey haters will hate so i say this "fuck you ceila u wanna rag on someone rag on a noob like me dont lie about ppl who are better than you at developing"

lol - I never said I could dev ^^? So basically it doesn't really affect me saying I can't dev. Anyhow I wont lie I did say Bakey is a shit dev; but that is just for Fiesta. Not things like PHP, or such. I haven't really seen any of Bakey's PHP or SQL work so I can't judge that, but from Dusk work he did; I didn't really like it, thought it was pretty crap. So josh please Don't get involved which shit you don't know about thx.

I would publicly like to apologise to you Bakey if this really made offended.