In case nobody saw this, here it is again. This is the most important thing to be woring on right now. It's what will jumpstart our pledges...
Do we need some kind of information from Gage before doing it?
its a little complicated...
i need to know what the script language for generating the pages are
how is it storing the emails (sql, mysql, access db, plain text file?)
what's the connection info for the database
is the database and the web pages on the same server
can gage create db tables?
how is it pulling the data of current pledge numbers from the database?
can you run both php and aspx on the server?
DB Design:
[emails]
entry_id *key
email
amount
date
ip
ref_url
referrer_id
[promoters]
user_id *key
referrer_id
username
date_created
hits
SQL strings:
get number of pledges:
select count(*) as pledges from emails
get total amount:
select sum(amount) as amount from emails
get all promoters sorted by hits:
select username, hits from promoters where hits > 0 order by hits desc
get top 5 promoters sorted by hits:
select top 5 username, hits from promoters where hits > 0 order by hits desc
update promoter hits:
update promoters set hits = (select count(emails.email) from emails where promoters.referrer_id=emails.referrer_id) where referrer_id = @in_value
then what's left is to put that data on the webpage.
