Bestrafung

I work for a GSP and all of our prices are config options using the tcadmin2_advanced module. Whenever a price changes for a single product it can take several hours to update each table. I'm trying to make a PHP script to simplify the process. I want to provide the PID and using the pid find and list all monthly, quarterly, and annually rows. Then using a simple input for what each slot costs let the PHP script calculate and replace the values allowing for 5 and 10% savings on the quarterly and annually fields respectively. I'm not a great PHP coder by any means but I believe I have enough information to get started except I'm not sure how to populate the configoption value using the pid. Here's what I've found so far: If I use 'SELECT configoption5 FROM tblproducts WHERE id="36"' I get the configoption name (ie. ConfigOption:Halo Slots). My problem is I don't know how to find the configoption[28] number using the name. I've been examining the database trying to figure this out for an embarrassingly long time now and would appreciate any assistance. If I'm trying to re-invent the wheel and someone has already done this that would be even better.

Thanks for the information. The Commission Delay is set to 3. The last affiliate signup was almost 3 weeks ago. I may look into that addon. The notification isn't very important just so long as we have control over affiliates.

This could very well be user error but I have been setting up the affiliate system and have a few minor issues. The first issue I have is that, even though I have the default value set to 5% in Setup > General Settings > Affiliates tab > Affiliate Earning Percentage, all of our recent affiliate signups are still not awarded any value and is defaulted to 0. I had to manually edit their affiliate accounts and set the percentage and calculate what their earnings should be. Am I overlooking something simple? The second issue I have is that we'd like to be able to approve or deny potential affiliates. I've looked seemingly everywhere but have not seen an option for requiring approval or even notifying staff/admins. Is this possible? Thanks for any assistance you may be able to provide.

Thank you for the reply. I wasn't able to get that working for some reason but it was probably just a syntax issue. I achieved the same result with a CSS rule which makes for less code. In a somewhat unrelated note, if anyone needs to add color to the priorities I figured that out as well. Change: {$ticket.urgency} To: <span class="{if $ticket.urgency === "High"}textred{elseif $ticket.urgency === "Medium"}textgreen{/if}">{$ticket.urgency}</span> Then add your CSS rules for .textred and .textgreen or change the names as needed.

I have created a custom WHMCS integration based on my website's theme using the documentation provided by the WHMCS team. I've customized mostly everything but have one small issue. On the client area home page the ticket statuses seem to only have a span to set the color. Would it be possible to add more CSS to the ticket status instead of just a simple color declaration? I mostly just want to change the font weight and add a text shadow. I'm sure it's a simple problem to fix but I'm not sure what file generates the span so any pointers would be appreciated.

We currently have Force Subscriptions set for our PayPal and this seems to work for the most part. The issue we have is that from time to time someone will cancel their subscription after the order and revert back to one time payments. For our GSP and web hosting services this isn't an issue. Some of the services we are offering are not automated however and this becomes an issue when we have to manually suspend/unsuspend while also trying to keep track of one time payments. Is there any way to force subscriptions on subsequent invoices instead of just the initial order? Or should we just put a notice in the template somehow urging them to resubscribe?

If anyone else has this issue it ended up being a PHP setting. The configurable options are saved as variables in an array. The array was being cut off at 1000 entries. Looking at the PHP error log I found: Replaced With and all is well again. I can now save and edit all my configurable options again. Hope this helps someone else.

I opened a support ticket on this a long time ago and we were never able to figure it out. My configurable options are used for pricing and don't change often so I kind of forgot about it. I had hoped that by now with all of the updates it would be resolved but the issue has cropped up again. When editing a configurable option with more than approximately 71 tables the changes aren't saved. New entries can't be added either. Using a debug script the developers provided indicates the array is being cut off prematurely and thus not being entered into the database. Entering the option and editing the prices manually via PHPMyAdmin seems to work. The option can then be seen in WHMCS but cannot be edited there. I've checked the PHP settings several times but still no luck. I'm still waiting for a response from the developers and if we figure it out I'll be sure to post here if possible for future Googlers. Here's my relevant info, let me know if I've left anything out. Any assistance would be much appreciated. Windows Server 2008 SP1 x64 (NT 6.0 build 6001) IIS 7.0 PHP 5.4.3 NTS, CGI/FastCGI MySQL Community Server 5.1.49 Win64 WHMCS 5.2.7 IIS PHP Runtime Limits: Maximum POST Size: 64M Upload Maximum File Size: 48M Maximum Execution Time: 90 Maximum Files to Upload: 20 Maximum Input Time: 90 Memory Limit: 192M

I'm modifying the Ajaxcart template for our site. I've already got the Group/Product image code showing instead of all of the radio buttons. I also have the group selection and product selection in divs, eventually I plan to attempt to convert the entire template to a tableless layout. Now I just want to modify it so the scrolling cart loads below the group selection, allowing the group selection the full width until the sidebar. Once a group is selected the div should collapse showing only the product selection and order completion form. If at all possible the product selection div should be hidden/collapsed until a group is selected. By default as soon as you click "Order" and go to the cart the first group is auto selected and the product for that group shown. I've attached some very basic images demonstrating the default layout and what I hope to achieve. Any help would be much appreciated.

I need to delay payment on a certain product by one week, kind of as a "trial period". I also still need to allow use of promo codes for a certain percentage off thereafter. The only real solution I saw on these forums was to change the way orders are processed globally and I only want this for one product. When the customer places the order I want it to wait one week before generating the first invoice, is this possible?

We have managed to integrate WHMCS into our Joomla website using an iframe but this causes the Paypal redirect to fail during an order. Is it possible to open the Paypal redirect in a new tab or window to allow the iframe-based order to complete? I've seen some people requesting assistance with this in the past but I haven't seen a fix yet.

I apologize if this has been covered already but I didn't find anything when I searched. I am using an iframe to integrate whmcs portal into my CMS website and am using the ajaxcart order template. When on the order page the FloatObject div does not move because the iframe window is stationary and sized large enough so there aren't double scrollbars. Is it possible to modify the code so that it can still move even though the iframe isn't scrollable? I have a feeling this isn't possible but would appreciate any assistance.

No one has any ideas? My entire billing setup is broken until this is worked out, I'd really appreciate any help.

I have written some code to allow me to only create a free voice server with a minimum game server purchase of 16 slots. Everything seems to be fine until you get into the billing issues this creates. WHMCS still charges for the voice server even if it isn't created by TCAdmin due to the minimum slot requirement. So here's an overview of some of the issues that I need help with: If I select a lower value than minimum requirement of game slots the voice slots aren't charged If less than the minimum game slots when selecting voice options receive an alert window That's all for now, I'll update as needed. If anyone needs the code for the tcadmin_module to achieve the first part let me know. I'm using the new Ajax order form. I'd appreciate any assistance with this and I apologize if this has already been mentioned somewhere, I didn't see anything in the searches.

If anyone else has this same issue after installing TCAdmin to a virtual directory here's the fix: In tcadmin_advanced.php change this line: $code = '<form action="'.($params["serversecure"]=='on' ? 'https':'http').'://'.$params["serverhostname"].'/Templates/Default/Login.aspx?returnto=%2fTemplates%2fDefault%2fuser_home.aspx%3fGoToServiceBillingID%3d'.$params["accountid"].'" method="post" target="_blank"> To this: $code = '<form action="'.($params["serversecure"]=='on' ? 'https':'http').'://'.$params["serverhostname"].'/Templates/Default/Login.aspx?returnto=%2ftcadmin%2fTemplates%2fDefault%2fuser_home.aspx%3fGoToServiceBillingID%3d'.$params["accountid"].'" method="post" target="_blank"> Note the change is to add %2ftcadmin, change tcadmin to whatever your virtual directory is.