wow, for 40k entries in my DB takes about 27mins to run. 

638min runtime... just wow!  I think max I have had is 35 mins for 40k entries!

Hm, I got like 80mins for org and 440mins total update time usually, with 110k total entries, 80k of which are orged.

I'm still having some issues running the w_update.php.

I configured the whois-update.conf and have it in the same directory as my w_update.php file.  When I run the php file I get:


Fatal error: Call to undefined function mysql_connect() in C:\BeBot\w_update.php
 on line 117

----------

Line 117: $link = mysql_connect("localhost", $username, $password)

----------

select COUNT(*) from AOBot' at line 1
mysql> select COUNT(*) from whois;
+----------+
| COUNT(*) |
+----------+
|        2 |
+----------+
1 row in set (0.00 sec)

Any thoughts?

Bryan

It depends on what modules you are running.  If you just run the updated relay_guild, this will check only the cached data when someone joins the privategroup.

The way the whois cache works is that whenever it is queried, it will add an entry if it isn't found (downloaded the old way from FC site).  When you manually update the cache via that script instead of updating each single person, it will download the entire org data for each org it sees and add each person from that org.

So to fully populate it, you should update a few other plugins to take advantage of it.  You can look here for a mostly complete list of available plugins.  Ones that (imo) you should update would be the whois module and the towerattack module as these take great advantage of the caching features.  Once you have installed the whois update, then !whois one person from each org you can think of and run your update script again, it will soon fill up to a large level :-)  You should also notice a nice speed boost in the bot whenever the whois cache is utilised (especially with !whois requests as previously this could take a long time if the FC site is slow).

Let me know if you need any further information.

Cheers,

-jj-

Btw, on the php.ini issue, here is mine:

; Error handling and logging ;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
display_errors = On
display_startup_errors = On
log_errors = On
log_errors_max_len = 0
error_log = ./log/php_errors.txt
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

; BeBot will normally use about 10-13megs with default
; modules. Default php memory limit is 8megs.
; Raise default on hosts that permitt it.
memory_limit = 20M

; Mainly for windows where additional modules are always required
extension_dir = ./php_extension/
I'm not sure of any need to put that extension line in if your whois_update.php and whois_update.conf files are in the root directory of your bot.  The error handling on the first few lines isn't essential, just useful.

Edit:
I'm assuming your directory structure is bebot standard and you do have a directory called php_extension in the root (which contains the needed php_mysql.dll file along with some others).

-jj-

I'd guess you are using some updated Members module, but forgot to add the new fields to your members table.

Hi,

I am using the new using the new towerattack and whois module and I did update the roster so I’m not sure what’s wrong now.  I don’t get these errors with the default php files.  If I delete the members table will it be automatically recreated?

Bryan

I configured the whois-update.conf and have it in the same directory as my w_update.php file.  When I run the php file I get:


Fatal error: Call to undefined function mysql_connect() in C:\BeBot\w_update.php
 on line 117

----------

Line 117: $link = mysql_connect("localhost", $username, $password)
[/quote]

umm having the same problem here.. What did you find out?


Edit:
Looks like it dont like php5...used an older version.. one that came with .2 bot.. and it kind of works..

Warning: mysql_escape_string(): This function is deprecated; use mysql_real_esca
pe_string() instead. in C:\aobots\rsbot\aofbot\whoisupdate\whois-update.php on l
ine 224

Warning: mysql_escape_string(): This function is deprecated; use mysql_real_esca
pe_string() instead. in C:\aobots\rsbot\aofbot\whoisupdate\whois-update.php on l
ine 234


================================================
3 http queries for org information done!
4 total http queries done!
1265 entries in database associated with an org modified!
1266 entries in database modified!
1266 entries in the whois cache!
0min 37sec runtime for org updates!
0min 38sec total runtime!
================================================