Converting to Drupal

I am building a site from scratch for a World of Warcraft guild.

They have informed me they want something with the same or similar functions to GuildPortal. This means user list, character list with various stats, gallery, forum, news, faq, event listing permitting users to sign up one of their characters and more.

I wanted some suggestions as to what modules may be best for this, or how I could go about it.

Current site is: www.forsakendeity.net

G,day i have just installed drupal with the intentions of installing a module to handle my tutorials on my site. I wish to have a module that works just like good-tutorials.com and would like to install it on my drupal. Can somebody please tell me where i can get one and import my tutorials from my previous site. As i will need to convert my mysql database information into the module so i can easily intergrate my old tutorials onto the new system.

I am currently converting a static site into drupal. Some of the existing pages use an external javascript file- some are image associated ones which display the larger picture when hovering over the thumbnail and others add a tabbed box to the page with the content contained within the tabs. I can't work out how to use the scripts with drupal. I am using a zen theme. Is there somewhere within drupal I can upload the scripts to?

i have a homebrew cms (also built on LAMP), with at least half a million "nodes". the data itself maps up pretty well with drupal nodes, but i need a database pro to help me babysit the migration. let's negotiate a rate and make it happen, hey?

I hired a web developer to redo my website, http://www.beyondquotes.com which is currently using Joomla. Since he does all of his work in Drupal, he said that it would be a relatively small matter to switch it over. But as time has gone on, I've become a little nervous about switching everything over Drupal mainly because I'm worried that it will affect my search engine rankings.

This is how I moved over my data from a Slashcode site to Drupal. It worked for me, might work for you, might not.

#Slash tables needed, dumpm'!

mysqldump --add-drop-table --opt -c story_topics_rendered journals journals_text users users_info comments comment_text stories story_text topics > SlashTables.sql

#need to change the name of the users and comments tables since they are the same in Drupal and Slash.

mysqldump -u -p db > db.sql
cp SlashTables.sql Good_Slash_Tables.sql
perl change.pl (this just changes the name of the users and comments tables)
mysql -u -p db_name < SlashTables.sql

##now, go to mysql and make the magic happen
##MOve over topics,Needs to go into term_data, term_hierarchy
gomysql
delete from term_data;
insert into term_data (tid,vid,name,description,weight) select tid,2,keyword,textname,0 from topics;
delete from term_hierarchy;
insert into term_hierarchy (tid,parent) select tid,0 from topics;

##Move over the Slash users into the Drupal users table.
##Move over all users who have, left a comment, written in their journal, logged into the site in the past 18 months(erso)
##maybe this needs to be done into 3 identical tables, then do a select out of them?

##Make Sure we get all the Journals Users (Slash users tables was renamed)

delete from users where uid > 2;