Hello there, my name is Ty.
I'm needing to get a custom table(s) made for my users. I am not familiar enough with the coding side of form generation and database manipulation. However I do know what I want, effectively speaking.
I am currently running Joomla 1.5, w/ PHP Version 5.2.17 and Mysql 5.0.51a
with the relatively speaking extensions.
Community Builder,
Virtuemart,
AlphaUserPoints.
& a Vendor Suite that basically syncs the CB users with the VM vendors, so users can sell products to eachother.
I'm looking to have 3 types of payment methods for users to use when buying assets, from other users:
First being "Paypal", which is more or less done, I still need to work out how to track tangible assets during Pending/Shipped status's of the order. (which is not really the reason of this post)
Second being "Points", which like Paypal, is pretty much already done. (also not the reason why I am posting)
Third being "Mana", which is where IF X buyer is "connected" (CB friends) to X Vendor, & is "Honored" (a specific type of CB friend, definable per friend when "managing connections"), after both parties are "honored" to each other, they could use this 3rd type of payment option when purchasing stuff specifically from each other, thus rendering a credit for the vendor in the vendors table, under the associate buyers row. And vise versa (negative attribute to balance on buyers table for vendors row).
Heck just explaining this is hard. But I can show you a picture that better represents the "Mana" concept, but yea why I need a DB manipulation expert via whatever means.
But ultimately I would like to have these Users tables be rendered in a CB Tab called "My Mana" that shows a compiled list of all their "Honored" connections, column1 being Username, column2 being value of current balance. .....
Either defined automatically based of tables being updated by scripts,
or
Defined by me manually via a form to update User Mana tables, that selects the Vendor via dropdown list or AJAX field, then the Buyer via dropdown list or AJAX (filtering out non honored connections types) & a text field for Purchase Order Number, and a text field for $ value to be logged/updated.
...more semi relative info...
I am able to facilitate pay-per download,
If the User spending "Paypal"(cart api) or "Points", that give sale profit to MY paypal account if paid with "Paypal", then rewards the user(vendor) with 90% of the relative value in "Point" form. or If paid with "Points" it rewards the user(vendor) with 90% of the sales total in "Point" form, while deducting 100% of sales cost from user(buyer) "Points" total.
However If the user(buyer) pays with "Mana" I want 100% of the sales cost, to be attributed to the vendors balance(s) (in a 2nd column(balance) in the associated row, ...ie the vendor*username row on the buyer*username table,... and the buyer*username_row on the vendor*username_table)
No matter what the payment method, I am still needing to work out the tracking of physical assets if sold, (collecting ship to info from buyer then get to vendor, either in PO summary or email. However thats not really the steps I'm trying to accomplish at the moment.)
I'm needing to get a custom table(s) made for my users. I am not familiar enough with the coding side of form generation and database manipulation. However I do know what I want, effectively speaking.
I am currently running Joomla 1.5, w/ PHP Version 5.2.17 and Mysql 5.0.51a
with the relatively speaking extensions.
Community Builder,
Virtuemart,
AlphaUserPoints.
& a Vendor Suite that basically syncs the CB users with the VM vendors, so users can sell products to eachother.
I'm looking to have 3 types of payment methods for users to use when buying assets, from other users:
First being "Paypal", which is more or less done, I still need to work out how to track tangible assets during Pending/Shipped status's of the order. (which is not really the reason of this post)
Second being "Points", which like Paypal, is pretty much already done. (also not the reason why I am posting)
Third being "Mana", which is where IF X buyer is "connected" (CB friends) to X Vendor, & is "Honored" (a specific type of CB friend, definable per friend when "managing connections"), after both parties are "honored" to each other, they could use this 3rd type of payment option when purchasing stuff specifically from each other, thus rendering a credit for the vendor in the vendors table, under the associate buyers row. And vise versa (negative attribute to balance on buyers table for vendors row).
Heck just explaining this is hard. But I can show you a picture that better represents the "Mana" concept, but yea why I need a DB manipulation expert via whatever means.
But ultimately I would like to have these Users tables be rendered in a CB Tab called "My Mana" that shows a compiled list of all their "Honored" connections, column1 being Username, column2 being value of current balance. .....
Either defined automatically based of tables being updated by scripts,
or
Defined by me manually via a form to update User Mana tables, that selects the Vendor via dropdown list or AJAX field, then the Buyer via dropdown list or AJAX (filtering out non honored connections types) & a text field for Purchase Order Number, and a text field for $ value to be logged/updated.
...more semi relative info...
I am able to facilitate pay-per download,
If the User spending "Paypal"(cart api) or "Points", that give sale profit to MY paypal account if paid with "Paypal", then rewards the user(vendor) with 90% of the relative value in "Point" form. or If paid with "Points" it rewards the user(vendor) with 90% of the sales total in "Point" form, while deducting 100% of sales cost from user(buyer) "Points" total.
However If the user(buyer) pays with "Mana" I want 100% of the sales cost, to be attributed to the vendors balance(s) (in a 2nd column(balance) in the associated row, ...ie the vendor*username row on the buyer*username table,... and the buyer*username_row on the vendor*username_table)
No matter what the payment method, I am still needing to work out the tracking of physical assets if sold, (collecting ship to info from buyer then get to vendor, either in PO summary or email. However thats not really the steps I'm trying to accomplish at the moment.)
Hi Ty,
I'm pretty much completely confused about what the question is. As far as I understand it you want a list displayed using a compound MySQL query that looks up data in more than one table.
If that is the question then the answer is 'Yes' this could be done in ChronoForms.
I know only a very little about CB, VirtueMart, or AlphaUserPoints but if the data is in the database in reasonably accesible form then it can be read and manipulated.
Bob
I'm pretty much completely confused about what the question is. As far as I understand it you want a list displayed using a compound MySQL query that looks up data in more than one table.
If that is the question then the answer is 'Yes' this could be done in ChronoForms.
I know only a very little about CB, VirtueMart, or AlphaUserPoints but if the data is in the database in reasonably accesible form then it can be read and manipulated.
Bob
Wow, Greyhead
Thanks for the prompt response, and yea sorry about the lack of a clear technical description.
If by compound query you mean to show specific fields of data, from certain tables & rows relatively filtered.. & ..compiled with similar but different fields, from different rows & tables.... then yes. (Like below shows @ the 🤔 )
& If yes, then I guess it would be easier to try to explain my goal with 2 statements/questions.
How to collect & manipulate data:
1. Would it be possible to use Chronoforms to automatically create a new table if none exist for a user, -&-OR- update user specific tables. (and I would also be wanting to ensure that those same tables could be updated, via a php script during VM check out?)
How to display "compound" query:
2. Can I use the chrono-connectivity to display a compound Mysql query in a CB tab🤨 (or am I completely miss understanding the point of chrono-connectivity.)
...
If so ..I would also need to ensure that these queries would be relative to the logged in user.
🤔 Example of what I want the CB tab containing the compound query to render like, roughly🙂
As Greg, On Greg's Profile Tab:
_______| My Mana |_______
|Honored Connection | Current Balance|
[list] Bill ......................... 0
George .................... -3
Fred .................... +3
William .................... -5
Victor .................... +13
..................................
Positive Total ............. +16
Negative Total ............. -8
..................................
Differential ............... +8 [/list]
As Victor, On Victor's Profile Tab:
_______| My Mana |________
|Honored Connections | Current Balance|
[list]Bill ............... -5
George ............... +6
Greg ............... -13
.......................
Positive Total ........ +6
Negative Total ........ -18
.......................
Differential .......... -12 [/list]
And since I'm not a Database wizard, I don't know how the tables or forms would be optimally defined & designed in relation to Joomla, CB, VM, & AUP and their tables.
Thanks for the prompt response, and yea sorry about the lack of a clear technical description.
If by compound query you mean to show specific fields of data, from certain tables & rows relatively filtered.. & ..compiled with similar but different fields, from different rows & tables.... then yes. (Like below shows @ the 🤔 )
& If yes, then I guess it would be easier to try to explain my goal with 2 statements/questions.
How to collect & manipulate data:
1. Would it be possible to use Chronoforms to automatically create a new table if none exist for a user, -&-OR- update user specific tables. (and I would also be wanting to ensure that those same tables could be updated, via a php script during VM check out?)
How to display "compound" query:
2. Can I use the chrono-connectivity to display a compound Mysql query in a CB tab🤨 (or am I completely miss understanding the point of chrono-connectivity.)
...
If so ..I would also need to ensure that these queries would be relative to the logged in user.
🤔 Example of what I want the CB tab containing the compound query to render like, roughly🙂
As Greg, On Greg's Profile Tab:
_______| My Mana |_______
|Honored Connection | Current Balance|
[list] Bill ......................... 0
George .................... -3
Fred .................... +3
William .................... -5
Victor .................... +13
..................................
Positive Total ............. +16
Negative Total ............. -8
..................................
Differential ............... +8 [/list]
As Victor, On Victor's Profile Tab:
_______| My Mana |________
|Honored Connections | Current Balance|
[list]Bill ............... -5
George ............... +6
Greg ............... -13
.......................
Positive Total ........ +6
Negative Total ........ -18
.......................
Differential .......... -12 [/list]
And since I'm not a Database wizard, I don't know how the tables or forms would be optimally defined & designed in relation to Joomla, CB, VM, & AUP and their tables.
____________________
MORE DEFINING INFO
To sum up the process I'm trying to accomplish:
-If me and you both signed up to my site,
-then become "connected"(friends)
-then we both opt to set our connection type as "Honored" for eachother.
-We then could spend a credit or generate a debt when checking out, when buying assets specifically from each other.
EXAMPLE (capture/update): (after registered, connected, & honored enabled)
-If I buy X from You, for '1 Mana' ...after sale is finalized,..
-My profile tab, shows a '-1 Mana' balance next to Your name..(via a Compound Query relative to me)
-Your profile tab, shows a '+1 Mana' balance next to My name..(via a Compound Query relative to you)
Example (display): Effectively showing the same value in two locations
-A credit for you, relative to my store, in your CB tab,...
-& a credit for you in my CB tab (represented by being a negative -value tho when displaying on ... in this case... my tab).
All User to User debt/credit values should be invisible any non relative user(s) in all display instances, obviously to have a layer of privacy for users.
So later you could spend that +1 credit aka "Mana" on stuff I sell, perpetually back and forth. While those compound queries in the CB tabs stay "up to date".
I could just upload a diagram picture I put together showing the process I'm trying to accomplish.. if that would make understanding this easier. Because I know this is abstract, and not a stereotypical e-commerce I'm trying to setup, but that's kind of the point.
Thanks for your time.
MORE DEFINING INFO
To sum up the process I'm trying to accomplish:
-If me and you both signed up to my site,
-then become "connected"(friends)
-then we both opt to set our connection type as "Honored" for eachother.
-We then could spend a credit or generate a debt when checking out, when buying assets specifically from each other.
EXAMPLE (capture/update): (after registered, connected, & honored enabled)
-If I buy X from You, for '1 Mana' ...after sale is finalized,..
-My profile tab, shows a '-1 Mana' balance next to Your name..(via a Compound Query relative to me)
-Your profile tab, shows a '+1 Mana' balance next to My name..(via a Compound Query relative to you)
Example (display): Effectively showing the same value in two locations
-A credit for you, relative to my store, in your CB tab,...
-& a credit for you in my CB tab (represented by being a negative -value tho when displaying on ... in this case... my tab).
All User to User debt/credit values should be invisible any non relative user(s) in all display instances, obviously to have a layer of privacy for users.
So later you could spend that +1 credit aka "Mana" on stuff I sell, perpetually back and forth. While those compound queries in the CB tabs stay "up to date".
I could just upload a diagram picture I put together showing the process I'm trying to accomplish.. if that would make understanding this easier. Because I know this is abstract, and not a stereotypical e-commerce I'm trying to setup, but that's kind of the point.
Thanks for your time.
This topic is locked and no more replies can be posted.