Tabella spider/robot vuota?

[Carlo]

Quella tabella non lo toccata proprio.

Comunque torniamo al tuo problema.

[gennyna]

si dimmi cosa devo fare e la faccio

[Carlo]

Hai provato, a vedere dopo aver lanciato quello script se questi bot sono comparsi nella tabella prefix_users?

[gennyna]

sono già presenti perchè se lo voglio aggiungere dal pcA mi dice che sono già esistenti...!!

[Carlo]

Forse non centra per nulla, ma hai provato ad utilizzare la funzione "Sincronizza statistiche" dalla scheda principale dell'ACP?

[gennyna]

sisi provai già un paio di giorni fa

[Carlo]

Allora, rispondi a queste domande:
- la tabella phpbb_bots è vuota?
- l'utente con ID 16 è Google [Bot]?

[gennyna]

ecco il mio database:



se provo a cercarlo come utente mi dice:

Ultimo accesso:
07/12/2009, 10:20

[Carlo]

Ok, da qui capisco che tale tabella è vuota.

Esequi questa query SQL, per reinserire i Bot di default:

Codice: Seleziona tutto

INSERT INTO `phpbb_bots` (`bot_id`, `bot_active`, `bot_name`, `user_id`, `bot_agent`, `bot_ip`) VALUES (1, 1, 0x416473426f74205b476f6f676c655d, 3, 0x416473426f742d476f6f676c65, ''),
(2, 1, 0x416c657861205b426f745d, 4, 0x69615f6172636869766572, ''),
(3, 1, 0x416c7461205669737461205b426f745d, 5, 0x53636f6f7465722f, ''),
(4, 1, 0x41736b204a6565766573205b426f745d, 6, 0x41736b204a6565766573, ''),
(5, 1, 0x4261696475205b5370696465725d, 7, 0x42616964757370696465722b28, ''),
(6, 1, 0x457861626f74205b426f745d, 8, 0x457861626f742f, ''),
(7, 1, 0x4641535420456e7465727072697365205b437261776c65725d, 9, 0x4641535420456e746572707269736520437261776c6572, ''),
(8, 1, 0x4641535420576562437261776c6572205b437261776c65725d, 10, 0x464153542d576562437261776c65722f, ''),
(9, 1, 0x4672616e636973205b426f745d, 11, 0x687474703a2f2f7777772e6e656f6d6f2e64652f, ''),
(10, 1, 0x47696761626f74205b426f745d, 12, 0x47696761626f742f, ''),
(11, 1, 0x476f6f676c6520416473656e7365205b426f745d, 13, 0x4d65646961706172746e6572732d476f6f676c65, ''),
(12, 1, 0x476f6f676c65204465736b746f70, 14, 0x476f6f676c65204465736b746f70, ''),
(13, 1, 0x476f6f676c65204665656466657463686572, 15, 0x46656564666574636865722d476f6f676c65, ''),
(14, 1, 0x476f6f676c65205b426f745d, 16, 0x476f6f676c65626f74, ''),
(15, 1, 0x48656973652049542d4d61726b74205b437261776c65725d, 17, 0x68656973652d49542d4d61726b742d437261776c6572, ''),
(16, 1, 0x4865726974726978205b437261776c65725d, 18, 0x68657269747269782f312e, ''),
(17, 1, 0x49424d205265736561726368205b426f745d, 19, 0x69626d2e636f6d2f63732f637261776c6572, ''),
(18, 1, 0x4943437261776c6572202d2049436a6f6273, 20, 0x4943437261776c6572202d2049436a6f6273, ''),
(19, 1, 0x69636869726f205b437261776c65725d, 21, 0x69636869726f2f, ''),
(20, 1, 0x4d616a65737469632d3132205b426f745d, 22, 0x4d4a3132626f742f, ''),
(21, 1, 0x4d657461676572205b426f745d, 23, 0x4d657461676572426f742f, ''),
(22, 1, 0x4d534e204e657773426c6f6773, 24, 0x6d736e626f742d4e657773426c6f67732f, ''),
(23, 1, 0x4d534e205b426f745d, 25, 0x6d736e626f742f, ''),
(24, 1, 0x4d534e626f74204d65646961, 26, 0x6d736e626f742d6d656469612f, ''),
(25, 1, 0x4e472d536561726368205b426f745d, 27, 0x4e472d5365617263682f, ''),
(26, 1, 0x4e75746368205b426f745d, 28, 0x687474703a2f2f6c7563656e652e6170616368652e6f72672f6e757463682f, ''),
(27, 1, 0x4e757463682f435653205b426f745d, 29, 0x4e757463684356532f, ''),
(28, 1, 0x4f6d6e694578706c6f726572205b426f745d, 30, 0x4f6d6e694578706c6f7265725f426f742f, ''),
(29, 1, 0x4f6e6c696e65206c696e6b205b56616c696461746f725d, 31, 0x6f6e6c696e65206c696e6b2076616c696461746f72, ''),
(30, 1, 0x7073626f74205b5069637365617263685d, 32, 0x7073626f742f30, ''),
(31, 1, 0x5365656b706f7274205b426f745d, 33, 0x5365656b626f742f, ''),
(32, 1, 0x53656e736973205b437261776c65725d, 34, 0x53656e7369732057656220437261776c6572, ''),
(33, 1, 0x53454f20437261776c6572, 35, 0x53454f2073656172636820437261776c65722f, ''),
(34, 1, 0x53656f6d61205b437261776c65725d, 36, 0x53656f6d61205b53454f20437261776c65725d, ''),
(35, 1, 0x53454f536561726368205b437261776c65725d, 37, 0x53454f7365617263682f, ''),
(36, 1, 0x536e61707079205b426f745d, 38, 0x536e617070792f312e31202820687474703a2f2f7777772e75726c7472656e64732e636f6d2f2029, ''),
(37, 1, 0x537465656c6572205b437261776c65725d, 39, 0x687474703a2f2f7777772e746b6c2e6969732e752d746f6b796f2e61632e6a702f7e637261776c65722f, ''),
(38, 1, 0x53796e6f6f205b426f745d, 40, 0x53796e6f6f426f742f, ''),
(39, 1, 0x54656c656b6f6d205b426f745d, 41, 0x637261776c657261646d696e2e742d696e666f4074656c656b6f6d2e6465, ''),
(40, 1, 0x5475726e6974696e426f74205b426f745d, 42, 0x5475726e6974696e426f742f, ''),
(41, 1, 0x566f7961676572205b426f745d, 43, 0x766f79616765722f312e30, ''),
(42, 1, 0x5733205b536974657365617263685d, 44, 0x5733205369746553656172636820437261776c6572, ''),
(43, 1, 0x573343205b4c696e6b636865636b5d, 45, 0x5733432d636865636b6c696e6b2f, ''),
(44, 1, 0x573343205b56616c696461746f725d, 46, 0x5733435f2a56616c696461746f72, ''),
(45, 1, 0x576973654e7574205b426f745d, 47, 0x687474703a2f2f7777772e574953456e7574626f742e636f6d, ''),
(46, 1, 0x59614379205b426f745d, 48, 0x79616379626f74, ''),
(47, 1, 0x5961686f6f204d4d437261776c6572205b426f745d, 49, 0x5961686f6f2d4d4d437261776c65722f, ''),
(48, 1, 0x5961686f6f20536c757270205b426f745d, 50, 0x5961686f6f2120444520536c757270, ''),
(49, 1, 0x5961686f6f205b426f745d, 51, 0x5961686f6f2120536c757270, ''),
(50, 1, 0x5961686f6f5365656b6572205b426f745d, 52, 0x5961686f6f5365656b65722f, '');

[gennyna]

inserita ma senza nessun successo..