Roster of C-GEN members

[DCoder]

Right, time for a status report...

I have all the posts and topics ready to import, but I still lack a lot of users.

The following is a list of people who have posted in your old forum, but have not yet identified themselves, along with how many posts they made:

Code:

mysql>
SELECT COUNT(pid) posts, username
FROM mybb_posts
WHERE ipaddress = '0.0.0.0' AND uid = 0
GROUP BY username
ORDER BY posts DESC;

+-------+---------------+
| posts | username ? ? ?|
+-------+---------------+
| ? ?62 | Hopalongtom ? |
| ? ?34 | YuriRuler90 ? |
| ? ?20 | zero2 ? ? ? ? |
| ? ?16 | The Eagle ? ? |
| ? ?15 | Painkiller ? ?|
| ? ?12 | Entith2290 ? ?|
| ? ?12 | (XT*Chris*TX) |
| ? ?11 | Nerdo ? ? ? ? |
| ? ?11 | Mr. Pokey ? ? |
| ? ?10 | Zerohour ? ? ?|
| ? ? 9 | Cylor ? ? ? ? |
| ? ? 8 | Flak ? ? ? ? ?|
| ? ? 8 | F-G ? ? ? ? ? |
| ? ? 8 | ctcdmb ? ? ? ?|
| ? ? 6 | mrruben5 ? ? ?|
| ? ? 6 | Joemarc ? ? ? |
| ? ? 6 | Littlebry ? ? |
| ? ? 5 | Zelab ? ? ? ? |
| ? ? 4 | darkmoonbeam ?|
| ? ? 4 | cannisrocks ? |
| ? ? 4 | someguy ? ? ? |
| ? ? 3 | Yoshi and Roy |
| ? ? 3 | RSeriouz ? ? ?|
| ? ? 3 | Rattus ? ? ? ?|
| ? ? 3 | GrumblyStuff ?|
| ? ? 3 | chrono118 ? ? |
| ? ? 2 | McSpivey ? ? ?|
| ? ? 2 | Ringleader064 |
| ? ? 2 | gamemate ? ? ?|
| ? ? 2 | Sypher_5 ? ? ?|
| ? ? 2 | Daemon ? ? ? ?|
| ? ? 1 | The Phiend ? ?|
| ? ? 1 | Katmandu ? ? ?|
| ? ? 1 | Blaze ? ? ? ? |
| ? ? 1 | Braddoc ? ? ? |
| ? ? 1 | winkey ? ? ? ?|
| ? ? 1 | Lee ? ? ? ? ? |
| ? ? 1 | Volrath ? ? ? |
| ? ? 1 | Synkopated ? ?|
| ? ? 1 | shadowlord ? ?|
| ? ? 1 | Wrecking Crew |
| ? ? 1 | Evolution ? ? |
| ? ? 1 | Aki Button ? ?|
+-------+---------------+
43 rows in set (0.05 sec)