 | [Solved] Donation MOD problem continues... |  |
 Posted: 05/04/2007 6:27 AM |
 |
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
 |
|
|
|
Joined: Apr 01, 2007
Local time: 2:07 AM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
 |
Hii 
The problem for my Donation MOD on live board continues. For the last month we received US 5.00 as donation and for the next month it should be 0. but now it shows that
Top 10 Donors [For: Your Donations are appreciated. All donations go towards furthering our purposes and goals. It will be used to provide the community with better services that further our mission.; We have collected out of our goal of 200 USD.; View Donors For Current Goal]
harvin83(USD5.00),
So there are 2 mistakes that the user harvin83(USD5.00) should not be listed for this new month and it says WE HAVE COLLECTED OUT OF OUR GOAL OF 200 USD. It doesn't say Collected how much? 
Can it be solved  |
|
|
|
|
| Back to Top |
|
|
| Re: Donation MOD problem continues... | |
| Posted: 05/04/2007 5:48 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 6:07 PM
Location: St Pete, FL
|
|
|
|
|
|
Ok, I found this flaw and fixed it for the missing amount toward the goal:
OPEN
index.php
FIND
| Code:
|
|
SELECT SUM(a.lw_money) FROM " . ACCT_HIST_TABLE
|
REPLACE WITH
| Code:
|
|
"SELECT SUM(a.lw_money) AS sum_money FROM " . ACCT_HIST_TABLE
|
FIND
| Code:
|
|
$curcollected = $row["SUM(a.lw_money)"];
|
REPLACE WITH
| Code:
|
|
$curcollected = ( $row['sum_money'] != '') ? $row['sum_money'] : 0;
|
So now you should get a number whether you have doners during the current period or not...
The listing of those that have donated doesn't take into account for any period. Since it appears that you want that option too, then I added the following:
OPEN
includes/functions.php
FIND
AFTER, ADD
| Code:
|
$donorswhere = '';
//format can only be 2004/08/04 yyyy/mm/dd
$starttime = 0;
$endtime = 0;
if(strlen($board_config['donate_start_time']) == 10)
{
$starttime = mktime(0, 0, 0, substr($board_config['donate_start_time'], 5, 2), substr($board_config['donate_start_time'], 8, 2), substr($board_config['donate_start_time'], 0, 4) );
}
if(strlen($board_config['donate_end_time']) == 10)
{
$endtime = mktime(0, 0, 0, substr($board_config['donate_end_time'], 5, 2), substr($board_config['donate_end_time'], 8, 2), substr($board_config['donate_end_time'], 0, 4) );
}
if($starttime > 0)
{
if($endtime <= $starttime)
{
$donorswhere = ' AND a.lw_date >= ' . $starttime;
}
else
{
$donorswhere = ' AND a.lw_date >= ' . $starttime . ' AND a.lw_date <= ' . $endtime;
}
}
|
FIND
| Code:
|
|
SELECT COUNT(*) FROM " . ACCT_HIST_TABLE
|
IN-LINE FIND
| Code:
|
|
u.user_id = a.user_id
|
IN-LINE AFTER, ADD
FIND
| Code:
|
|
$sql = "SELECT a.*, u.* FROM " . ACCT_HIST_TABLE
|
IN-LINE FIND
| Code:
|
|
u.user_id = a.user_id
|
IN-LINE AFTER, ADD
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Donation MOD problem continues... | |
| Posted: 05/04/2007 11:13 PM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 2:07 AM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
| Oh My God!! That much work was to be done! The MOD author was sleeping and wrote the MOD i think so. So many thing missing yeah... |
|
|
|
|
| Back to Top |
|
|
| Re: Donation MOD problem continues... | |
| Posted: 05/04/2007 11:51 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 6:07 PM
Location: St Pete, FL
|
|
|
|
|
|
It really doesn't look like the MOD author intended to fillter out those that donated in a different period from the top ten list. That might have been an after-thought to add it to the code above that section and he never got around to including it in the donor list too...
Since there really isn't much to go on here as far as testing is concerned, it is possible that there are bugs in the code that I created for you. So you really need to keep an eye on it and see what happens as you begin to get donors for your site...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Donation MOD problem continues... | |
| Posted: 05/04/2007 11:56 PM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 2:07 AM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
Okay. Sure. Till now only we got US$ 5.00
No one likes to give donation and all seems to be leechers on our forum  |
|
|
|
|
| Back to Top |
|
|
| Re: Donation MOD problem continues... | |
| Posted: 05/05/2007 12:01 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 6:07 PM
Location: St Pete, FL
|
|
|
|
|
|
I think most people are looking for free on the Internet. It is amazing that anyone can make any money from it. I do know of one forum where the admin charges each member to register and he doesn't have any trouble finding people who want to pay. But his community is geared for business professionals who want to compare notes, so the investment is worth it for them. If you can target a group who can't afford to live wthout your community, you could get more to contribute financially to it too...
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Donation MOD problem continues... | |
| Posted: 05/05/2007 12:06 AM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 2:07 AM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
Right you are. What we provide on our forum is every Asian community forum is providing for free. But we have everything related to fun and entertainment which others don't have everything in it. But still I am trying some other things like people can buy ad space on my site for which we are working everytime but till now no success whereas for my other sites I have got many ads 
Hopefully will get some ads in near future at FW  |
|
|
|
|
| Back to Top |
|
|
| Re: Donation MOD problem continues... | |
| Posted: 05/05/2007 12:19 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 6:07 PM
Location: St Pete, FL
|
|
|
|
|
|
I hope the ads work out for you. For me, if there are too many ads on a site, I probably would quickly close the page and never come back, so you might want to be careful about the quality of the ads that you have and not the quantity...
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Donation MOD problem continues... | |
| Posted: 05/05/2007 12:21 AM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 2:07 AM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
 Right.  |
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
![[ Hidden ]](templates/Helius_blue/images/lang_english/icon_email.gif "[ Hidden ]"){kind=icon}
