web stats analysis

Author Archive

How to solve the problem orphan users in SQL Server databases?

First you need to know what is orphaned user?
SQL Server maintains user logins in the sysxlogins system table in the master database. Every time you add a user, or give a Windows account access, an entry is made in this table. Every user is assigned a security identifier (SID) in sysxusers. Each database has a table called sysusers that contains a list of users that have access to that database. Typically, the SID in the sysusers table matched the SID in sysxusers.
When a user entry exists in sysusers that that does not have a matching SID in sysxusers, that user is “orphaned.

Read the rest of this entry »

How to add more than one “Bank Transfer” Payment Gateway in WHMCS

Very Simple Solution By Code.top10idea.com

 

  • Connect Your FTP Account
  • Open your WHMCS Source Code Files
  • Download banktransfer.php file in to your local PC [PATH : /modules/gateways/banktransfer.php ]
  • Open banktransfer.php in to text editor / Dreamweaver Software
  • Save as file as different name [banktransfer1.php]
  • open bank1transfer.php file in to text editor
  • change the following three lines to the banktransfer1.php page

——————————————————————–
function banktransfer1_config() {

“Value” => “Bank Transfer 1″

function banktransfer1_link($params) {
——————————————————————–

Whole Coding

<?php

# Bank Transfer Payment Gateway Module for Other BANK Like AXIS BANK , DENA BANK, IDBI BANK, CITY BANK etc..

function banktransfer1_config() {

$configarray = array(
“FriendlyName” => array(
“Type” => “System”,
“Value” => “Bank Transfer 1″
),
“instructions” => array(
“FriendlyName” => “Bank Transfer Instructions”,
“Type” => “textarea”,
“Rows” => “5″,
“Value” => “Bank Name:\nPayee Name:\nSort Code:\nAccount Number:”,
“Description” => “The instructions you want displaying to customers who choose this payment method – the invoice number will be shown underneath the text entered above”,
),
);

return $configarray;

}

function banktransfer1_link($params) {
global $_LANG;

$code = ‘<p>’.nl2br($params['instructions']).’<br />’.$_LANG['invoicerefnum'].’: ‘.$params['invoiceid'].’</p>’;

return $code;

}

?>

—————————————————————-
face any problem then contact www.reseller99.com / live chat option / Chat with expert.

Add Cash payment gateway in WHMCS

Very Simple Solution By Code.top10idea.com

 

  •  Connect Your FTP Account
  • Open your WHMCS Source Code Files
  • Download banktransfer.php file in to your local PC  [PATH :  /modules/gateways/banktransfer.php ]
  • Open banktransfer.php in to text editor / Dreamweaver Software
  • Save as file as different name [cashtransfer.php]
  • open cashtransfer.php file in to text editor
  • change the following three lines to the cashtransfer.php page

——————————————————————–
function cashtransfer_config() {

“Value” => “cash Transfer”

function cashtransfer_link($params) {
——————————————————————–

Whole Coding

<?php

# Cash Transfer Payment Gateway Module

function cashtransfer_config() {

$configarray = array(
“FriendlyName” => array(
“Type” => “System”,
“Value” => “Cash Transfer”
),
“instructions” => array(
“FriendlyName” => “Cash Transfer Instructions”,
“Type” => “textarea”,
“Rows” => “5″,
“Value” => “Bank Name:\nPayee Name:\nSort Code:\nAccount Number:”,
“Description” => “The instructions you want displaying to customers who choose this payment method – the invoice number will be shown underneath the text entered above”,
),
);

return $configarray;

}

function cashtransfer_link($params) {
global $_LANG;

$code = ‘<p>’.nl2br($params['instructions']).’<br />’.$_LANG['invoicerefnum'].’: ‘.$params['invoiceid'].’</p>’;

return $code;

}

?>

—————————————————————-
face any problem then contact www.reseller99.com / live chat option /  Chat with expert.

How to Convert Currency into Words in Crystal Report

How to Convert Currency into Words in Crystal Report

Write one formula :

numbervar RmVal:=0;
numbervar Amt:=0;
numbervar pAmt:=0;
stringvar InWords :=”Rupees “;
Amt := {tbl_Cash.nFees};

if Amt > 10000000 then RmVal := truncate(Amt/10000000);

if Amt = 10000000 then RmVal := 1;
if RmVal = 1 then
InWords := InWords + ” ” + towords(RmVal,0) + ” crore”

else

Read the rest of this entry »

Asp.net Menu Theme.

There is some website for  providing menu Theme & CSS.

http://demos.telerik.com/aspnet-ajax/menu/examples/overview/defaultcs.aspx

http://menustyles.com

http://demo.essentialobjects.com/Demos/Slide%20Menu/Demo.aspx

http://demo.essentialobjects.com/Demos/Menu/Demo.aspx

http://www.lwis.net/free-css-drop-down-menu/?all

My Joomla website hacked and showing this text “_shell_atildi_.

When I open my joomla based website it has displaying the text “_shell_atildi_.”
My joomla website showing an error “_shell_atildi_

Cause : In the Joomla website all the file are not independent and also they are using the default page as index.php which has more commonly used in the website development. As a result hacker will attack on those common name file and they make edit on the commonly used file.

Read the rest of this entry »

With www prefix my domain is not working while without www its working

Cause : The CNAME and A records have not added properly.

Solution : Please add the A record with the domain name with and without www prefix

Login to the Plesk panel==>Under Web Site option click on DNS Settings
==> Then click on the Add record icon ==> then add the two A record
Example :
DOMAIN.TLD. A 128.74.34.80
www.DOMAIN.TLD. A 128.74.34.80

Read the rest of this entry »

How to run and access the wamp server without disabling the IIS .

 The How to run and access the wamp server without disabling the IIS .
If you had configure the wamp server at your pc and try to opening with http://localhost/
and it has opening with IIS page.

There is two way to run you wamp server at your machine

Way1 : To un check your IIS from
==>Go to start ==>Control panel ==>Administrative Tools ==>Disabled The IIS (Uncheck the box)

Way2 : Go to Wamp Server ICON from start or from task bar

Read the rest of this entry »

How to reset or change your Joomla administrator password?

If you want to change the joomla administrative password then you can run the simple MYSQL query and you can change the joomla admin .
If you are using the cPanel control panel as for hosting, then follow the below steps.
==>Login to the cPanel Control Panel
==>Please click on the PhpMyAdmin under Database section
Note : Please login through the client login , If you login through the root login you can not be able to connect your mysql database

Read the rest of this entry »

Could not load file or assembly ‘Microsoft.Office.Tools.Excel, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3

Error : Could not load file or assembly ‘Microsoft.Office.Tools.Excel, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3

Cause : The application uses Microsoft ASP.NET Microsoft.Office.Tools.Excel, Version=8.0.0.0 , but they had not been installed on the production machine or on the hosting server.

Read the rest of this entry »