chibib0

Thank you guys for your help.

I already contacted them and its fine with them. I understand that you cannot recommend host.. but in my first post, i specified two shared host with its resource usage limits, what I ask is in that 2 shared host, where should my multisite may fit in.

Thank you.

Its just a starting site. Maybe around 100 sites or below and same to users, 100 and below. Then i’ll wait when it comes to the point that it is necessary to upgrade my hosting plan. What do you think is the preferred host to this?

Thank you.

Thank you guys! It works! ^_^v

@peredur

When i redefine the constants HEADER_IMAGE_WIDTH and HEADER_IMAGE_HEIGHT by creating a functions.php inside the child theme there is a “Cannot Redeclare Error”.

I figured it out.

Thanks.

Thank you sir! It works!

values with “$” is needed to be stored in my database.. as it will appear just like a plane “$” just with added text and not a function nor variable. Like storing “$100”.

Thank you sir..

I have another problem inserting another value.

// Address format data
function insert_addressformat_table($table_name3, $type) {
	global $wpdb;

$sql = "INSERT INTO {$table_name3} VALUES (1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country','$city / $country'), (2, '$firstname $lastname$cr$streets$cr$city, $state    $postcode$cr$country','$city, $state / $country'), (3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country','$state / $country'), (4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country'), (5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$country','$city / $country');";

	$wpdb->query($sql);
}

values with “$” is not inserted in the database.

By the way sir.. I have multiple INSERT INTOs

Can I do this,

function insert_configuration_table($table_name9, $type) {
	global $wpdb;

$sql = "INSERT INTO {$table_name9} (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, date_added) VALUES ('Free Shipping For Orders Over', 'MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER', '50', 'Provide free shipping for orders over the set amount.', '6', '4', 'currencies->format', now());
INSERT INTO {$table_name9} (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, use_function, date_added) VALUES ('Set Order Status', 'MODULE_PAYMENT_COD_ORDER_STATUS_ID', '0', 'Set the status of orders made with this payment module to this value', '6', '0', 'tep_cfg_pull_down_order_statuses(', 'tep_get_order_status_name', now());"; 

	$wpdb->query($sql);
}

Thanks.

Thank you sir for your help! I appreciate it a lot! ^_^v

if (!empty ($wpdb->charset))
     $charset_collate = "DEFAULT CHARACTER SET {$wpdb->charset}";
     if (!empty ($wpdb->collate))
     $charset_collate .= " COLLATE {$wpdb->collate}";

The code above is what you mean? I just got it from other sources and i actually don’t know their exact function.. so should i remove the above code?

@pbaylies

Thank you sir! it solves my problem!

1 another thing.. i have lots of insert into queries and each uses that function that i created.. do you have any suggestions/recommendations to make it simple?

How to that sir?

Well, basically im using dbdelta in this query since this is what I know. Do you recommend any alternative to successfully make the query work?

Thanks.

I found it already! ^_^v