Booya
collapse collapse

* User Info

 
 
Welcome, Guest. Please login or register.
Did you miss your activation email?

* Search


* Board Stats

  • stats Total Members: 1074
  • stats Total Posts: 18300
  • stats Total Topics: 2487
  • stats Total Categories: 7
  • stats Total Boards: 31
  • stats Most Online: 500

Author Topic: Player last online  (Read 4359 times)

0 Members and 1 Guest are viewing this topic.

Offline Breenild

  • BeBot Rookie
  • *
  • Posts: 4
  • Karma: +0/-0
Player last online
« on: January 29, 2010, 11:11:07 am »
This very small Module shows the date, when a Player on any of his alts was online.
The command is !laston
Note: this Module creates 2 new Views "player_last_seen" and "alts_alle" in your Database!

« Last Edit: February 07, 2010, 11:03:32 am by Breenild »

Offline Breenild

  • BeBot Rookie
  • *
  • Posts: 4
  • Karma: +0/-0
Re: Player last online
« Reply #1 on: January 30, 2010, 11:57:18 am »
I updated the View, which is created by this Module.
Please simply reinstall the Modul and simply restart the Bot to update.

Offline RaZeR

  • BeBot User
  • **
  • Posts: 28
  • Karma: +0/-0
Re: Player last online
« Reply #2 on: February 02, 2010, 07:54:14 am »
It looks like there is a problem creating the table. I received the following error when I tried this module:
Code: [Select]
MySQL ERROR(# 1) on query: CREATE or REPLACE VIEW alts_alle
                                                                        AS

select `a`.`alt` AS `alt`,`a`.`main` AS `main`

from `alts` `a`
                                                                        union

select distinct `a`.`main` AS `alt`,`a`.`main` AS `main`

from `alts` `a`
                                                                        union

select u.nickname as main, u.nickname as alt

from laradil_users u

where not exists (

        select * from alts a

        where a.alt = u.nickname  or

                a.main = u.nickname)
                                                                        order by
 main, alt
Table 'bebotdb1.laradil_users' doesn't existMySQL ERROR(# 2) on query: CREATE or
 replace VIEW player_last_seen
                                                                        AS

SELECT a.main AS main, max(u.last_seen) AS last_seen, max(w.level) AS max_level

FROM alts_alle a

join whois w

         on a.alt = w.nickname

join propbot_users u

         on a.alt = u.nickname

group by a.main
                                                                        union

select u.nickname AS main, u.last_seen AS last_seen, w.level AS max_level

from propbot_users u

join whois w

         on u.nickname = w.nickname

where not exists (

  select 1  from alts_alle a

  where a.alt = u.nickname

  )
                                                                        order by
 last_seen desc
Table 'bebotdb1.alts_alle' doesn't existPropbot [MOD-CUSTOM]    [LOAD]  LastOn.p
hp

Offline Breenild

  • BeBot Rookie
  • *
  • Posts: 4
  • Karma: +0/-0
Re: Player last online
« Reply #3 on: February 02, 2010, 05:42:00 pm »
Thanks for this error-report!

My Mistake was, that I coded my Botname as a Textconstant.
This is now fixed.

Please download again  and rerun.

« Last Edit: February 03, 2010, 10:26:22 am by Breenild »

Offline plugz

  • BeBot User
  • **
  • Posts: 35
  • Karma: +0/-0
Re: Player last online
« Reply #4 on: February 06, 2010, 02:33:22 am »
mmm, any reason the output comes in german and lists 8 pages of hits for all logins of any user?

Offline Breenild

  • BeBot Rookie
  • *
  • Posts: 4
  • Karma: +0/-0
Re: Player last online
« Reply #5 on: February 07, 2010, 11:26:04 am »
OK, here is a new Version of "laston".

I build in a little language localisation. The default Language  is english now.
If you want to set up german you only have to change the line
var $lang = "en";
to
var $lang = "de";

Note:
You need to add all alt-chars of one player to his mainchar by using the !alt add <nickname> command.
Alternativly a bot-admin can use !altadmin add <mainchar> <alt>

=>This script scans all alt-chars of a player an displays the login date of this alt, which was recently used.

p.s. sorry for my english :)

 

* Recent Posts

0.7.0 updates by bitnykk
[May 17, 2020, 04:22:04 pm]


Stats module by bitnykk
[April 16, 2020, 04:45:43 pm]


OnlineOrg by Hell
[February 28, 2020, 11:21:55 pm]


AO Bots - discord server by Kjellis1234
[January 23, 2020, 04:17:04 pm]


Offline AA training timer module by Kjellis1234
[August 29, 2019, 11:12:14 pm]

* Who's Online

  • Dot Guests: 124
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.

* Forum Staff

admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2020, SimplePortal