SMF Support > SMF 2.0.x Support

How Subscription update a custom table on my database?

(1/4) > >>

MoneyMan87:
How can i make when someone make a donate with Subscriptions upgrade a custom table in my databse?
i Want when he make the Subscription to upgrade to Premium member(ok i have do it this is easy) now i want to update a custom table from my database how can i do it please? i want update this:
--- Code: ---΄premium΄ FROM  ΄s_servers΄ WHERE  ΄`id_member`=΄id from member who have make the donate΄
--- End code ---
How can i do it please?

Arantor:
Um, the subscription itself will quite happily do the group change all by itself without any custom changes - have you made some changes to it then?

Also, what function would this code serve? Do you need to remove them from that table when they're not longer subscribed? Why can't you just use the core code (what is the core missing that you need, exactly)?

MoneyMan87:
I want when make the sub upgade one more stat from a custom table from database how can i do it? i have it in the same database with the forum

Arantor:
I don't understand why you need to make this extra change.

There are tables in SMF you could just as easily query to get the same information, without having to duplicate the workload.

MoneyMan87:
because my script hs own database but i have it in the same with the smf and look when someone make the donae i want to update and a table for my script too.

Navigation

[0] Message Index

[#] Next page