[uCash/uShop] Transactions Addon With a 'message'

Hi

This is my first 'hack' per-say (released ), so do bear with me

This is a hack I had made for my site, for some weird reason I have no answer to ..anyways, it will add an option for your users to add a message when he/she donates to another person on your board, and displays transactions based on a userid input (e.g. transaction.php?userid=1), the default showing the transactions done by the person currently logged in, and a global transaction, showing all donations made on your board

BIG Thanks goes to Deaths for the help he provided me on in putting this hack together.

ChangeLog

• Version 1.2 (11/7/05)
  • Added "View {username}'s Transations" link into postbit(_legacy)
  • Fixed Page Generation issues
  • Phrase added to show error message if no transactions exist
  • Made the install file a bit easier to understand

That about sums it all up..please click INSTALL if you use this hack

[TyleR]

Changed & Updated. Thanks Marco

[Marco van Herwaarden]

Looking save now

Just one tip for future coding:

PHP Code:

    $getuser = $DB_site->query('SELECT * from ' . TABLE_PREFIX . 'utt_store_history WHERE userid="' . $userid . '" AND action="Donate" ORDER BY historyid DESC'); 


There is no need to stop the string and insert a variable if you use double-quotes (") around the the string. Also numerical var's in a query don't need to be quoted at all, and if quoting alphanumerical data best to use single quotes ('). So the above line could also be written as:

PHP Code:

    $getuser = $DB_site->query("SELECT * from " . TABLE_PREFIX . "utt_store_history WHERE userid=$userid AND action='Donate' ORDER BY historyid DESC"); 


[Vevina]

sweet installed

[TyleR]

heh

[TyleR]

if anyone can 'teach' me the pagination, please send me a PM

[TyleR]

woo, thanks Deaths..this now has pagination

Updating the zip & sending out an update now

[Vevina]

This is awesome just what i wanted ThankYou

[Deaths]

No problem mate .

[jzewatsky]

I'm not clear on where the message is shown when a user donates to another user. Also, does the option to leave a message when donating extend to using Admin Donate?

Thanks for all you work.

[redcow]

thanks