Donations

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in the Customisations Database.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTICE: This forum is only for the announcement of new releases and/or updates of MODs. Any MOD support should be obtained through the Customisations Database in the support area designated for each MOD.

A direct link to support for each MOD is in the first post of the respective topic.
GameVixenZone
Registered User
Posts: 166
Joined: Mon Aug 17, 2009 9:26 am

Re: Donations

Post by GameVixenZone »

I have mine up the top as preferred as well. To do this just find this:

Code: Select all

<!-- INCLUDE forumlist_body.html -->
and place this on a line above:

Code: Select all

<!-- INCLUDE donations.html -->
User avatar
hatebreeder138
Registered User
Posts: 131
Joined: Thu Oct 15, 2009 6:04 am

Re: Donations

Post by hatebreeder138 »

Not sure what happened. follow the instructions every step of the way. i purged the cache, noticed i had a new tab called .mods in the ACP. clicked on it and get some error about table not found. now i get this when i go to my forums.


"SQL ERROR [ mysql4 ]

Table 'c527970_phpbb1.phpbb_3donations' doesn't exist [1146]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists."


PLEASE HELP!

here is the link to my forums.

www.702.clanservers.com/forum
User avatar
nwofearless
Registered User
Posts: 49
Joined: Tue Aug 25, 2009 11:51 pm
Location: Ireland
Contact:

Re: Donations

Post by nwofearless »

if you have phpmyadmin, open up your database and rename the 'phpbb_donations' table - (i think it hard coded in the install.php file to that value) to 'phpbb_3donations', and hopefully that will fix it.
-[Nwo]- ƒearless

AFK Manager Mod
User avatar
hatebreeder138
Registered User
Posts: 131
Joined: Thu Oct 15, 2009 6:04 am

Re: Donations

Post by hatebreeder138 »

bravo sir, i say... bravo!


thanks it worked.
RHitman
Registered User
Posts: 32
Joined: Fri Sep 26, 2008 2:25 am

Re: Donations

Post by RHitman »

Hello
Thanks for the help on this
But please excuse my ignorance on this but witch file do I look for these lines in. :oops:
and when you say on a line above
It would be like this
<!-- INCLUDE donations.html -->
<!-- INCLUDE forumlist_body.html -->
Thank you for your time
Ruben M
GameVixenZone wrote:I have mine up the top as preferred as well. To do this just find this:

Code: Select all

<!-- INCLUDE forumlist_body.html -->
and place this on a line above:

Code: Select all

<!-- INCLUDE donations.html -->
GameVixenZone
Registered User
Posts: 166
Joined: Mon Aug 17, 2009 9:26 am

Re: Donations

Post by GameVixenZone »

Sorry, it's in the index_body.html file. That is how it should look as you posted.
RHitman
Registered User
Posts: 32
Joined: Fri Sep 26, 2008 2:25 am

Re: Donations

Post by RHitman »

Hello
Thank you GameVixenZone
That worked great

Ruben
ProtoGT
Registered User
Posts: 141
Joined: Thu May 21, 2009 6:34 pm

Re: Donations

Post by ProtoGT »

Fatal error: Call to a member function sql_build_query() on a non-object in functions_display.php on line 20
satandream
Registered User
Posts: 383
Joined: Thu Mar 06, 2008 12:47 pm

Re: Donations

Post by satandream »

Well i have done the patches with linux but this sucker dont function as donations manually made dont show up in ACP/MODS ;)

I guess some validations before a mod go in this section is in place

I dont care if the mod author have some nice picture of how it works as it dont work for users using this mod
satandream
Registered User
Posts: 383
Joined: Thu Mar 06, 2008 12:47 pm

Re: Donations

Post by satandream »

delete please
Lost_inside
Registered User
Posts: 160
Joined: Wed Dec 30, 2009 12:25 pm

Re: Donations

Post by Lost_inside »

How do People donate with this?
Visit http://www.codingtech.net for online coding support free with your account.
Image
User avatar
Hippie459MN
Registered User
Posts: 948
Joined: Mon Oct 15, 2007 10:13 pm
Location: Minnesota, USA
Contact:

Re: Donations

Post by Hippie459MN »

Read the mod description. :D It only keeps track of donations.
indijanac
Registered User
Posts: 105
Joined: Wed Jan 14, 2009 1:10 am

Re: Donations

Post by indijanac »

indijanac wrote:Yeah, thanks :)

Somebody got colored usernames?
marcok
Registered User
Posts: 4
Joined: Sun Feb 18, 2007 12:12 am

Re: Donations

Post by marcok »

Hi,

Just installed the mod. Very simple when following the instructions and all is fine.

Just a couple of issues;
  • 1. The size of the donation for the "Top ten donors" is determined via an alphabetical sort, rather than a numeric sort. This means that 70 is larger than 100...
  • 2. If a person has donated more than once, the amounts are not added together. The person (if both are in the top 10, is just mentioned twice). But worse is when a person wants to go higher up, an additional payment would now not make it into the rank...
  • 3. also want to only show the totals of the donations made in the last 12 months.
I would like to make the statement like the following I puzzled together in mysqladmin:

Code: Select all

SELECT ut.username, ut.user_id, sum(dt.donation_amount)
FROM		phpbb_users ut
LEFT JOIN phpbb_donations dt
ON ut.user_email = dt.donation_email
Where str_to_date(dt.donation_date, '%d/%m/%Y') > (DATE_ADD(CURDATE(),INTERVAL -1 YEAR))
Group by ut.username
ORDER BY 3 DESC LIMIT 0, 10 
Is somebody able to rewrite this to the safe code required to be put into includes/functions_display.php
I'm scared that I put things at the wrong place and cause issues. Also offcourse the conversion from date in varchar is very assuming that it is Australian/Europe format. Not sure how to deal with that either as anything could have been typed into the varchar...

Kind regards,
Marco
2008paul
Registered User
Posts: 103
Joined: Tue Jun 09, 2009 8:22 pm
Contact:

Re: Donations

Post by 2008paul »

I'm getting

Code: Select all

SQL ERROR [ mysql4 ]

Table 'a3481120_site.DONATIONS_TABLE' doesn't exist [1146]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
I've done the edits other than the styles/prosilver/template/index_body.html as the style I use is a subsilver2 style.

Thanks

EDIT:

Also in ACP/MODS I'm getting

Code: Select all

SQL ERROR [ mysql4 ]

Table 'a3481120_site.DONATIONS_TABLE' doesn't exist [1146]

SQL

SELECT ut.username, ut.user_id, dt.* FROM (phpbb_users ut, DONATIONS_TABLE dt) WHERE ut.user_email = dt.donation_email ORDER BY dt.donation_date DESC

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/acp/acp_donations.php
LINE: 64
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_donations->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
Locked

Return to “[3.0.x] MOD Database Releases”