PtokaX forum

Archive => Archived 5.0 boards => Finished Scripts => Topic started by: GeceBekcisi on 30 August, 2005, 23:13:25

Title: IPdbBOT
Post by: GeceBekcisi on 30 August, 2005, 23:13:25
The Ultimate IP Database Bot, IPdbBOT v1.00 and v2.50 (http://scriptdb.ptokax.ath.cx/download.php?view.147) by me.


What is this script and what it will be used for?

You can store IP data for users, and recall them when needed with this script. For example, no need to know which IPs did a user used in history, or how many and which users are from the same ISP as a user, etc etc. You can find detailed information by clicking here. (http://www.students.itu.edu.tr/~canem/ReadMe.htm)

Have fun!
Title:
Post by: GrinSlaW on 31 August, 2005, 00:47:10
sound intresting  :) i will check it out and report bugs  :P


cheers  :D
Title:
Post by: Xico on 31 August, 2005, 02:21:27
I tryed to get the script... and I got: "This address/url is invalid. If you clicked on a link, please inform the Administrator."

But I did get the information page. Promissing...
Title:
Post by: GrinSlaW on 31 August, 2005, 02:38:51
i hade no problems geting the script strange that you dont get it ?(

btw the script works perfect no bugs so far

cheers :D
Title:
Post by: GeceBekcisi on 31 August, 2005, 02:50:31
Link is working, and I am waiting for any possible bugs.
Title:
Post by: uffetjur on 31 August, 2005, 11:21:19
Line 7 Settings.ini
   ["sBot"] = frmHub:GetHubBotName()

Corrected:
   ["sBot"] = frmHub:GetHubBotName(),
Title:
Post by: GeceBekcisi on 31 August, 2005, 12:21:07
Fixed this small typing mistake, thanks for reporting uffetjur.

BTW, it would be nice that everyone, had posted their ISP databases here, either with a link to file or its content in [C0DE] ... [/C0DE] tags; to make all ppl benefit from it.

Also,
Title:
Post by: GeceBekcisi on 31 August, 2005, 14:31:22
Fixed a small tabulation error v2.02. Link above is edited.
Title:
Post by: Herman on 01 September, 2005, 03:56:50
I'm noob at this, but i've got a question. Looks like the script see nicks (example: Herman and herman) as two different nicks. Is it possible to make it case insensitive?
Title:
Post by: GeceBekcisi on 01 September, 2005, 04:17:02
Yeah, it is possible; gonna look tomorrow and make an option for that.

Best Regards
Title:
Post by: Herman on 01 September, 2005, 10:48:43
Hi, naggy Herman again. Got a suggestion for a improvment of the bot. Usercleaner(dunno if it's in there) Cleans the logfiles say every 4 weeks for users that havent been active since then?
Title:
Post by: bastya_elvtars on 01 September, 2005, 10:57:30
QuoteOriginally posted by Herman
I'm noob at this, but i've got a question. Looks like the script see nicks (example: Herman and herman) as two different nicks. Is it possible to make it case insensitive?

Mybe I am wrong, but PtokaX takes care of this, Joe and joE cannot be in a hub at the same time.
Title:
Post by: Herman on 01 September, 2005, 11:04:08
That might be so....but this is when i search the database. It shouldnt make difference there between say Herman and herman



//Edit


So it isnt possible then without the cpu usage?
Title:
Post by: bastya_elvtars on 01 September, 2005, 11:45:42
QuoteOriginally posted by Herman
That might be so....but this is when i search the database. It shouldnt make difference there between say Herman and herman

Yes, I will fix this in my userinfo and post the results here. :-)
Always the last used nick counts, HermaN, HeRmaN or anything else, but HeRMAn can be searched for with herman too. :D

-- // EDIT

Looked into my userinfo. It would kill all usernames, if it were used this way, or would use a lot of cpu.
Title:
Post by: Herman on 01 September, 2005, 14:54:13
What if the search database command can show all hits..Herman and herman and herMan?
Title:
Post by: bastya_elvtars on 01 September, 2005, 14:56:47
QuoteOriginally posted by Herman
What if the search database command can show all hits..Herman and herman and herMan?

Would use a lot of CPU then.
Title:
Post by: GeceBekcisi on 01 September, 2005, 15:24:48
QuoteOriginally posted by Herman
Is it possible to make it case insensitive?

Request rejected due to reasons bastya_elvtars told before me. Database conflicts, and rise of CPU usage...

QuoteOriginally posted by Herman
Cleans the logfiles say every 4 weeks for users that havent been active since then?

A reasonable request, will try to implement as soon as possible.
Title:
Post by: gander on 02 September, 2005, 16:17:23
the clean user thing is buildt into robocop 10e ... so you may have a conflict there
Title: Getting an error
Post by: Myers on 02 September, 2005, 21:07:08
Hello,
I get this error when i try to do an "ipinfo"

Script-Error: 09/02/05 20:59:38 - C:\Temp\PtokaX 0.3.3.21+\scripts\IPdbBOTv2.lua:261: attempt to concatenate global `sNick' (a nil value)

And i also got this error

Script-Error: 09/02/05 21:06:27 - C:\Temp\PtokaX 0.3.3.21+\scripts\IPdbBOTv2.lua:1080: attempt to index field `?' (a nil value)

Does anyone have an idea.


I run Ptokax 0.3.3.21e and Robocop 10.01e
Title:
Post by: Herman on 04 September, 2005, 16:59:06
QuoteOriginally posted by gander
the clean user thing is buildt into robocop 10e ... so you may have a conflict there


It's not cleaning the ptokax user database....it cleans the database that the Ip-bot have created
Title:
Post by: hnr21 on 04 September, 2005, 19:18:20
Can this script save MACs also?! This might be very handy for some LAN hubs ... 10x & good work ! :)
Title:
Post by: GrinSlaW on 04 September, 2005, 20:24:16
QuoteOriginally posted by Myers
Hello,
I get this error when i try to do an "ipinfo"

Script-Error: 09/02/05 20:59:38 - C:\Temp\PtokaX 0.3.3.21+\scripts\IPdbBOTv2.lua:261: attempt to concatenate global `sNick' (a nil value)

And i also got this error

Script-Error: 09/02/05 21:06:27 - C:\Temp\PtokaX 0.3.3.21+\scripts\IPdbBOTv2.lua:1080: attempt to index field `?' (a nil value)

Does anyone have an idea.


I run Ptokax 0.3.3.21e and Robocop 10.01e


hi
i get thoes error to

cheers
Title:
Post by: mateci on 04 September, 2005, 22:33:23
thx for reporting these;

QuoteOriginally posted by Myers

Script-Error: 09/02/05 20:59:38 - C:\Temp\PtokaX 0.3.3.21+\scripts\IPdbBOTv2.lua:261: attempt to concatenate global `sNick' (a nil value)

Script-Error: 09/02/05 21:06:27 - C:\Temp\PtokaX 0.3.3.21+\scripts\IPdbBOTv2.lua:1080: attempt to index field `?' (a nil value)

These errors are fixed.

The new uncompiled release IPdbBOT v2.03 is here (//www.students.itu.edu.tr%5C~cakmakab%5Cipbot.rar).
Title:
Post by: GrinSlaW on 05 September, 2005, 00:28:26
the link not working  :(


cheers
Title:
Post by: mateci on 05 September, 2005, 01:37:50
No, link is working ( i try with flashget and ie6).
Title:
Post by: GrinSlaW on 05 September, 2005, 02:34:36
yepp it works but not with Firefox  :rolleyes:

tnx


cheers
Title:
Post by: Herman on 05 September, 2005, 09:34:58
QuoteOriginally posted by mateci
thx for reporting these;

QuoteOriginally posted by Myers

Script-Error: 09/02/05 20:59:38 - C:\Temp\PtokaX 0.3.3.21+\scripts\IPdbBOTv2.lua:261: attempt to concatenate global `sNick' (a nil value)

Script-Error: 09/02/05 21:06:27 - C:\Temp\PtokaX 0.3.3.21+\scripts\IPdbBOTv2.lua:1080: attempt to index field `?' (a nil value)

These errors are fixed.

The new release IPdbBOT v2.03 is here (//www.students.itu.edu.tr%5C~cakmakab%5Cipbot.rar).


What is "fixed" in this new version, just the errors...or more?
Title:
Post by: mateci on 05 September, 2005, 11:39:33
QuoteOriginally posted by Herman
What is "fixed" in this new version, just the errors...or more?

From readmefile which comes with the .rar:

Added option about saving tables on timer on 02.09.2005
Fixed a few ipinfo command errors (Thx Myers for reporting) on 04.09.2005, v.2.03


Also added a program for fast changes in the settings.ini (thx my brother for this program) on 03.09.2005

Now im working on database cleaner and showing users which are using same isps. But i will wait Gecebekcisi's return for next release
Title:
Post by: GeceBekcisi on 06 September, 2005, 09:48:42
Hi peeps,

Now, I am really away from computer and working in a conference, maybe this weekend I can return. mateci will take care of small problems or requests till I return.

Goodbye for now...
Title:
Post by: uffetjur on 06 September, 2005, 11:15:59
Suggestion:
Nextr step for this development would be to add a possibility to block not added ip-ranges
Title:
Post by: Herman on 06 September, 2005, 17:34:31
I dont know about others, but i found that the IPBOT is lagging my hub very much. Is there something one can do to avoid this?
Title:
Post by: mateci on 06 September, 2005, 17:41:34
The uncompiled version is here (//www.students.itu.edu.tr%5C~cakmakab%5Cipbot.rar) and compiled version is here (//www.students.itu.edu.tr%5C~cakmakab%5Cipbotcompiled.rar).
Title:
Post by: GeceBekcisi on 06 September, 2005, 19:43:33
QuoteOriginally posted by Herman
I dont know about others, but i found that the IPBOT is lagging my hub very much. Is there something one can do to avoid this?

QuoteOriginally posted by mateci
if u change this to "0" with the ipbot program or directly from settings.ini, the lag will be decrease.

DNS lookup uses a better coding level than ISP lookup, but it may consume system resources as well.
Disabling order for settings are:
1) SaveInterval for settings (present in 2.03, otherwise use 1440 minutes for once a day for example)
2) ISP lookup
3) DNS lookup

Best regards
Title: IPdbBOT v2.50 and v3.00.RC1
Post by: GeceBekcisi on 26 February, 2006, 21:23:14
v2.50 is already out and v3.00 with SQL support coming soon. Check the first post please..

In some hubs, v3.00.RC1 failed in performance tests (like too long boot time and stalling hub while script is starting) when SQLite is enabled so you're free to select the type of your database, SQL or RAW.

Here are some stats from my hub:
<?Turquoise?> IPdbBOT v3.00.RC1 has been started. Showing performance stats as requested:
________________________________________
PtokaX Version : 0.3.4.0
SQLite Status : Disabled
Online Users : 1153
Stats Exec Time : 0.0470 seconds
Total Boot Time : 0.9530 seconds
Database Size : 1441107 bytes
Total Entries : 40524
Memory Usage : 14197 / 25756 KiB
????????????????????????????????????????


Here (http://lua.uknnet.com/attachment.php?attachmentid=205&sid=") is the link for the first public v3 release candidate for those who wants to test instantly.

Warning: This ZIP file is a renamed RAR file just because of stupid limitations on other LUA board.

Best regards.
Title: Re: IPdbBOT
Post by: GeceBekcisi on 09 March, 2006, 11:28:50
Release Candidate 2 is out. Grab it from here. (http://scriptdb.ptokax.ath.cx/download.php?view.187) Possibly this is the last pre-v3 IPdbBOT.

Major Changes:
* Removed SQLite since it was useless.
* Fixed lag for IP Info & History commands

Statistics:
<?Turquoise?> IPdbBOT v3.00.RC2 has been started. Showing performance stats as requested:
________________________________________
PtokaX Version : 0.3.4.0
Online Users : 2150
Stats Exec Time : 0.1250 seconds
Total Boot Time : 2.1560 seconds
Database Size : 2817067 bytes
Total Entries : 79373
Memory Usage : 27219 / 28022 KiB
????????????????????????????????????????


Best Regards
Title: Re: IPdbBOT
Post by: GeceBekcisi on 11 March, 2006, 17:58:29
I'd like to announce some information about RC3:

============================================================
Available commands for Master profile and descriptions of them, for IPdbBOT v.3.00.RC3
------------------------------------------------------------------------------------------------------------------------
• !query (<Nick> or <IP>)
If <Nick> is used, shows information of <Nick> if it's online, and other users with same IP.
Also shows the list of IPs <Nick> has used in history (Default: Last 10 IPs)
If <IP> is used, shows information about <IP> if it's online, and other users with same IP.
Also shows the list of users that has used <IP> in history.

• !query (<Nick> or <IP>) <LastXTimes>
Same as above except limiting the list size to <LastXTimes>

• !rangequery (<Nick> or <IP.Block> or <Start.IP> <End.IP>)
If <Nick> is used, shows users within same IP block of <Nick>
If <IP.Block> is used, sShows users with IPs between start and end of given <IP.Block>.
=> Example: !rangequery 127.0 for IPs between 127.0.0.0 - 127.0.255.255
If <Start.IP> <End.IP> is used, sShows users with IPs between <Start.IP> and <End.IP>

• !addisp <Start.IP> <End.IP> <Name>
Adds ISP <Name> to ISP database with <Start.IP> - <End.IP>

• !addsubisp <Start.IP> <End.IP> <Name>
Adds Sub ISP <Name> to ISP database with <Start.IP> - <End.IP>

• !delisp <Start.IP> <End.IP> <Name>
Deletes ISP <Name> from ISP database with <Start.IP> - <End.IP>

• !delsubisp <Start.IP> <End.IP> <Name>
Deletes Sub ISP <Name> from ISP database with <Start.IP> - <End.IP>

• !showisp
Shows all the ISPs in the database with their IP ranges

• !sameisp <Nick/IP>
Shows all users from the ISP of given <Nick> or <IP>

• !markisp <good/bad> <Start.IP> <End.IP> <Name>
Marks ISP <Name> with range <Start.IP> - <End.IP> as <good/bad>

• !markall <good/bad>
Marks all ISP as <good/bad>

• !whois <Nick/IP>
Shows WHOIS data for <Nick> or <IP>

• !ipbotname <NewName>
Changes bot's name with <NewName>

• !ipbotmenur <NewTitle>
Changes root menu's title with <NewTitle>.

• !ipbotmenus <NewTitle>
Changes sub menu's title with <NewTitle>.

• !ipbotenv <PM/MAIN>
Sets where IPdbBOT will reply your commands; "PM" for PM from bot, "MAIN" for main chat

• !ipbotlastx <NewValue>
Sets a new default LaxtXTimes value for queries without LaxtXTimes

• !ipbotdb <NewValue>
Sets a new database clean interval.
Note: Entries older than that interval will be deleted automatically each time you restart script.

• !ipbotisp <on/off>
Enables / Disables ISP Query. on = Enable, off = Disable

• !ipbotdns <on/off>
Enables / Disables DNS Query. on = Enable, off = Disable

• !ipbotdang <on/off>
Enables / Disables high amount of IP queries. on = Enable, off = Disable

• !ipbotrc <on/off>
Enables / Disables Range Access Control. on = Enable, off = Disable

• !ipbotrcrole <Allow/Block>
Allows / Blocks access from listed IP ranges

• !ipbotrclist <All/Marked>
Sets which IP ranges in ISP database will be controlled
<All> = All IP ranges , <Marked> = only marked ranges

• !ipbotcfg
Shows the current settings and statistics

• !ipbothelp
Shows this help message
============================================================

============================================================
*Current?Settings* ( for *IPdbBOT?v.3.00.RC3* )
------------------------------------------------------------------------------------------------------------------------
• Bot Name : ?Turquoise?
• Root Menu Title : TurkuazSohbet
• Sub Menu Title : IP Database
• Hub Owner Name : GeceBekcisi
• Bot Reply Environment : PM
• Default Last X Times : 10
• Database Clean Interval (in weeks) : 4
• Time Format : %d.%m.%Y - %X
• Command Spy : Enabled
• Performance Debugging : Enabled
• Setting Commands : Enabled
• PxWSA Library Usage : Enabled
• ISP Queries : Enabled
• DNS Queries : Disabled
• High Amount of IP Queries : Disabled
• Range Access Control : Disabled
• Range Control Role : Block
• Range Control Applies To : Marked ISPs
------------------------------------------------------------------------------------------------------------------------
*Current?Statistics*
------------------------------------------------------------------------------------------------------------------------
• PtokaX Version : 0.3.4.0
• Online Users : 1691
• Stats Exec Time : 0.1410 seconds
• Database Size : 3469728 bytes
• Total IP Entries : 97749
• Memory Usage : 37234 / 45917 KiB
============================================================


You'll find more when changelog is written and script is finished.
Also; I've to claim that I'll not rewrite the script in LUA 5.1 unless a-non-beta PtokaX supporting LUA 5.1 comes out.

Best regards
Title: Re: IPdbBOT
Post by: GeceBekcisi on 12 March, 2006, 14:22:38
Release Candidate 3 is out. Grab it from here. (http://scriptdb.ptokax.ath.cx/download.php?view.191)

Since Release Candidate 2

Major Changes:
* Added Range Access Control, an IP checker based on ISP database
--> (You can allow or block access from all or only marked ISP ranges)
* Added commands to change most of the settings on-the-fly
--> (Settings which need hub restart and hub owner access are excluded)
* Changed info & history commands, combined them into one command
--> (As a result, IPdbBOT is more easy to use now (At least I expect to be so) )
* Changed commands structure, they're more flexible now
--> (As one of results, each command has its ownprofile set)
* Removed PxWSA library dependency, now it's an option to use it.
--> (So all PtokaX versions using Lua 5.0 will be able to run this script)

Minor Changes:
* Added a command to show current settings & statistics
* Added a command to show users connecting from same ISP with an user or IP
* Added Nick correction in addition to IP correction (I'm not so sure if it works fool-proof)
--> (Ex: If geceBekcisi entered as an argument, script will return results for GeceBekcisi)
--> (Ex: If 127.000.00.00000001 entered as an argument, script will return results for 127.0.0.1)
* Changed commands reply format & environment
--> (Script will reply in global env setting instead of where you type commands)
* Some more stuff I can't remember without inspecting the code


I'll be expecting performance & bug reports, requests from you before releasing v3.00

Best Regards
Title: Re: IPdbBOT
Post by: GeceBekcisi on 12 March, 2006, 16:28:14
Discovered a bug; the command to show users connecting from same ISP with an user or IP searches all users in database where it should search only online users. Use this command with care unless new RC is out
Title: Re: IPdbBOT
Post by: GeceBekcisi on 12 March, 2006, 19:07:26
Release Candidate 3 pack is updated, please download it again. Please use the link above.

* Added performance debug setting command
* Fixed function names (critical bug)
* Fixed same ISP command (critical bug)
* Fixed mark all ISPs command

Best regards.
Title: Re: IPdbBOT
Post by: Jorgo on 29 May, 2006, 18:21:14
Hello :-)
I'd like to make a request for this bot, if I may. The bot is very nice so far and does almost everything I want, except:

Show all IPs with their login/logout period for the last x hours

I am thinking of seeing a quick overview for a fixed period, one IP per line. This is mainly to identify those mysterious users who pop in for 1 sec and logoff again.

Thanks for considering it!
Title: Re: IPdbBOT
Post by: Psycho_Chihuahua on 29 May, 2006, 20:12:49
IPDbBot is now called "UserBekcisi" so give that a try  ;)

http://ptxscriptdb.psycho-chihuahua.net/download.php?view.244
Title: Re: IPdbBOT
Post by: GeceBekcisi on 29 May, 2006, 22:07:09
Quote from: Jorgo on 29 May, 2006, 18:21:14
Hello :-)
I'd like to make a request for this bot, if I may. The bot is very nice so far and does almost everything I want, except:

Show all IPs with their login/logout period for the last x hours

I am thinking of seeing a quick overview for a fixed period, one IP per line. This is mainly to identify those mysterious users who pop in for 1 sec and logoff again.

Thanks for considering it!

Please, make your request here (http://forum.ptokax.org/index.php?topic=5964.0); and let me know more details of your wish..

Thanks for your interest.
Title: Re: IPdbBOT
Post by: speedX on 17 September, 2006, 17:47:50
hey i m not able to dload the IPdb script.....plzz help
Title: Re: IPdbBOT
Post by: Psycho_Chihuahua on 17 September, 2006, 18:09:34
as mentioned a couple of times already thats because the resource site is on a new server and has a new addy ;)

http://scriptdb.ptokax.ath.cx/download.php?view.244
Title: Re: IPdbBOT
Post by: speedX on 17 September, 2006, 19:14:30
this script is showing me this error

Quote
[22:14] Syntax ...est 0.3.5.1\scripts\UserBekcisi\System\Functions.lua:789: attempt to call a table value
Title: Re: IPdbBOT
Post by: GeceBekcisi on 17 September, 2006, 19:28:48
Can you post here the reply of !ubc command?
Can you tell me after doing what does this error happens? (command.log may help..)
And, which version of PtokaX you do use, LUA 5.1 or 5.02 ?

Also I have to admit that I am away from DC and scripting, so don't expect a quick fix if the bug is a tricky one.
Title: Re: IPdbBOT
Post by: jiten on 17 September, 2006, 19:38:52
That error happens when using a script that hasn't been converted to LUA 5.1 in a LUA 5.1 PtokaX build.
Title: Re: IPdbBOT
Post by: speedX on 17 September, 2006, 19:45:46
I am using Ptokax 0.3.5.1 lua 5.1
The error comes as i start the hub
and when i type !ubc nothin comes.....
Title: Re: IPdbBOT
Post by: GeceBekcisi on 17 September, 2006, 19:46:54
Thank you jiten, you couldn't say me it's time to convert it, you lazy boy in a more polite way :D

And speedX, IPdbBOt nor UserBekcisi is not yet converted to new LUA version. So please wait for someone (or me) to convert it or downgrade your hub to a PtokaX using LUA 5.02.
Title: Re: IPdbBOT
Post by: jiten on 17 September, 2006, 19:53:18
Quote from: GeceBekcisi on 17 September, 2006, 19:46:54
Thank you jiten, you couldn't say me it's time to convert it, you lazy boy in a more polite way :D

Oops... I'll try to be less impolite next time :P
Title: Re: IPdbBOT
Post by: red_neon on 13 February, 2007, 21:20:06
Need this script in lua 5.1.1  ::)  :'(
Title: Re: IPdbBOT
Post by: bastya_elvtars on 13 February, 2007, 21:53:13
Quote from: red_neon on 13 February, 2007, 21:20:06
Need this script in lua 5.1.1  ::)  :'(

Then request the conversion in the appropritate place.