Jump to content


Photo
- - - - -

Database Code in OpenShop 1.5


15 replies to this topic

#1 euroballoon.com

euroballoon.com

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 20 March 2018 - 09:26 AM

Hi everybody

 

I think our site (euroballoon.com) has been hacked and the database code was changed :(

 

Can anyone tell me where to find the database code and how to change it?

 

Best regards

 

Euroballoon

 

Thomas


  • 0

#2 MaxD

MaxD

    Administrator

  • Administrators
  • 703 posts

Posted 20 March 2018 - 10:37 AM

Why do you think so?


  • 0

#3 euroballoon.com

euroballoon.com

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 20 March 2018 - 10:45 AM

Why do you think so?

Because our host says that the database is not pointing to the right place and the website is coming up with a lot of errors and a lot less customers/orders...so something is definately wrong and the hosy (gigahost) says it is because of the database code :/


  • 0

#4 MaxD

MaxD

    Administrator

  • Administrators
  • 703 posts

Posted 20 March 2018 - 10:52 AM

That sound very strange, as your site shouldn't work at all if "database code" points to wrong place. Can you cite your hoster's words?


  • 0

#5 euroballoon.com

euroballoon.com

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 20 March 2018 - 10:53 AM

That sound very strange, as your site shouldn't work at all if "database code" points to wrong place. Can you cite your hoster's words?

Hello Thomas Hansen

The error occurs because the page can not connect to the database.

Is the correct database code used in the page configuration file?

Have you changed the database code recently?

Does it seem to log in via phpMyAdmin here:

<Https://phpmyadmin.gigahost.dk>


  • 0

#6 MaxD

MaxD

    Administrator

  • Administrators
  • 703 posts

Posted 20 March 2018 - 10:55 AM

Hmm, can you post that error message?


  • 0

#7 euroballoon.com

euroballoon.com

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 20 March 2018 - 11:06 AM

Euroballoon error 1.jpg


  • 0

#8 MaxD

MaxD

    Administrator

  • Administrators
  • 703 posts

Posted 20 March 2018 - 11:50 AM

That is not database code issue (you need to edit config.php files to cause that, and it will make your store not working totally).

That is your hoster's issues with MySQL server.


  • 0

#9 euroballoon.com

euroballoon.com

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 20 March 2018 - 01:00 PM

That is not database code issue (you need to edit config.php files to cause that, and it will make your store not working totally).

That is your hoster's issues with MySQL server.

 

Ok, i have presented this to the host, so hope he comes back with constructive good news...thanks for the help so far! :)


  • 0

#10 euroballoon.com

euroballoon.com

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 21 March 2018 - 02:16 PM

We had about a month ago a lot of random customer entries, random people from outside Denmark where we are placed, that logged in and made an account in the store...but i know it is fake and thinking that it is a BOT that did that. I have no idea what it would accomplish by that, since we don't have a store where you can pay and therefore not give out any sensitive information (Visa, etc...).

 

Any chance that they/it could have changed anything in the database which could lead to these errors you think?

 

Still don't know what they would accomplish :/


  • 0

#11 MaxD

MaxD

    Administrator

  • Administrators
  • 703 posts

Posted 21 March 2018 - 02:27 PM

Yep, there are some bots that create accounts in the shop. I don't know for sure, but maybe they are registering to post some spam - but there is no such ability at Opencart.

 

That couldn't cause that errors you had.


  • 0

#12 euroballoon.com

euroballoon.com

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 22 March 2018 - 11:20 AM

I am really happy for all your input and help :)

 

We still have problems with people cannot open the site and a lot less interaction/orders/calls/mails, so we really hope we can solve this soon :(

 

I have sent your reply to our host Gigahost and waiting for their reply, but i have copied and attached the system/database/mysql as a word document...maybe you can see if something is completely nonsense :)

<?php
final class MySQL {
	private $link;
	
	public function __construct($hostname, $username, $password, $database) {
		if (!$this->link = mysql_connect($hostname, $username, $password)) {
      		trigger_error('Error: Could not make a database link using ' . $username . '@' . $hostname);
		}

    	if (!mysql_select_db($database, $this->link)) {
      		trigger_error('Error: Could not connect to database ' . $database);
    	}
		
		mysql_query("SET NAMES 'utf8'", $this->link);
		mysql_query("SET CHARACTER SET utf8", $this->link);
		mysql_query("SET CHARACTER_SET_CONNECTION=utf8", $this->link);
		mysql_query("SET SQL_MODE = ''", $this->link);
  	}
		
  	public function query($sql) {
		if ($this->link) {
			$resource = mysql_query($sql, $this->link);
	
			if ($resource) {
				if (is_resource($resource)) {
					$i = 0;
			
					$data = array();
			
					while ($result = mysql_fetch_assoc($resource)) {
						$data[$i] = $result;
			
						$i++;
					}
					
					mysql_free_result($resource);
					
					$query = new stdClass();
					$query->row = isset($data[0]) ? $data[0] : array();
					$query->rows = $data;
					$query->num_rows = $i;
					
					unset($data);
					
					return $query;	
				} else {
					return true;
				}
			} else {
				trigger_error('Error: ' . mysql_error($this->link) . '<br />Error No: ' . mysql_errno($this->link) . '<br />' . $sql);
				exit();
			}
		}
  	}
	
	public function escape($value) {
		if ($this->link) {
			return mysql_real_escape_string($value, $this->link);
		}
	}
	
  	public function countAffected() {
		if ($this->link) {
    		return mysql_affected_rows($this->link);
		}
  	}

  	public function getLastId() {
		if ($this->link) {
    		return mysql_insert_id($this->link);
		}
  	}	
	
	public function __destruct() {
		if ($this->link) {
			mysql_close($this->link);
		}
	}
}
?>

  • 0

#13 MaxD

MaxD

    Administrator

  • Administrators
  • 703 posts

Posted 22 March 2018 - 11:58 AM

It's completely default mysql.php. Your code and setup are ok, it is hoster's issue.


  • 0

#14 euroballoon.com

euroballoon.com

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 22 March 2018 - 12:01 PM

It's completely default mysql.php. Your code and setup are ok, it is hoster's issue.

 

Ok, thanks a lot :D


  • 0

#15 euroballoon.com

euroballoon.com

    Newbie

  • Members
  • Pip
  • 9 posts

Posted 03 April 2018 - 01:47 PM

I am really happy for all your input and help :)

 

We still have problems with people cannot open the site and a lot less interaction/orders/calls/mails, so we really hope we can solve this soon :(

 

I have sent your reply to our host Gigahost and waiting for their reply, but i have copied and attached the system/database/mysql as a word document...maybe you can see if something is completely nonsense :)

<?php
final class MySQL {
	private $link;
	
	public function __construct($hostname, $username, $password, $database) {
		if (!$this->link = mysql_connect($hostname, $username, $password)) {
      		trigger_error('Error: Could not make a database link using ' . $username . '@' . $hostname);
		}

    	if (!mysql_select_db($database, $this->link)) {
      		trigger_error('Error: Could not connect to database ' . $database);
    	}
		
		mysql_query("SET NAMES 'utf8'", $this->link);
		mysql_query("SET CHARACTER SET utf8", $this->link);
		mysql_query("SET CHARACTER_SET_CONNECTION=utf8", $this->link);
		mysql_query("SET SQL_MODE = ''", $this->link);
  	}
		
  	public function query($sql) {
		if ($this->link) {
			$resource = mysql_query($sql, $this->link);
	
			if ($resource) {
				if (is_resource($resource)) {
					$i = 0;
			
					$data = array();
			
					while ($result = mysql_fetch_assoc($resource)) {
						$data[$i] = $result;
			
						$i++;
					}
					
					mysql_free_result($resource);
					
					$query = new stdClass();
					$query->row = isset($data[0]) ? $data[0] : array();
					$query->rows = $data;
					$query->num_rows = $i;
					
					unset($data);
					
					return $query;	
				} else {
					return true;
				}
			} else {
				trigger_error('Error: ' . mysql_error($this->link) . '<br />Error No: ' . mysql_errno($this->link) . '<br />' . $sql);
				exit();
			}
		}
  	}
	
	public function escape($value) {
		if ($this->link) {
			return mysql_real_escape_string($value, $this->link);
		}
	}
	
  	public function countAffected() {
		if ($this->link) {
    		return mysql_affected_rows($this->link);
		}
  	}

  	public function getLastId() {
		if ($this->link) {
    		return mysql_insert_id($this->link);
		}
  	}	
	
	public function __destruct() {
		if ($this->link) {
			mysql_close($this->link);
		}
	}
}
?>

<a href="http://www.pandoras-jewelry.us.com">pandora jewelry</a> <a href="http://www.pandorajewelrybracelet.us">pandora bracelet</a> <a href="http://www.yeezy--shoes.us.com">yeezy shoes</a> <a href="http://www.adidasyeezy-shoes.us">adidas yeezy</a> <a href="http://www.yeezy350boost-v2.us">yeezy boost 350 v2</a> <a href="http://www.yeezysboost350-v2.us.com">yeezy boost 350 v2</a> <a href="http://www.redbottomslouboutin.us.com">red bottoms louboutin</a> <a href="http://www.red-bottoms-shoes.us">red bottom shoes</a> <a href="http://www.louboutinoutletus.us.com">louboutin outlet</a> <a href="http://www.louboutin-outlets.us">louboutin shoes</a> <a href="http://www.air-vapor-max.us.com">nike air vapormax</a> <a href="http://www.vapormax-nike.us.com">nike vapor max</a> <a href="http://www.nike-airvapormax.us">vapor max</a> <a href="http://www.air-max-2018.us.com">air max 2018</a> <a href="http://www.nike-airmax2018.us">nike air max 2018</a> <a href="http://www.handbags-longchamp.us.com">longchamp handbags</a> <a href="http://www.longchampbag.us">longchamp bags</a> <a href="http://www.adidasoutlets.us">adidas outlet</a> <a href="http://www.adidas-outletstore.us.com">adidas outlet store</a> <a href="http://www.rihanna-puma.us.com">rihanna puma</a> <a href="http://www.rihannafenty.us.com">rihanna fenty puma</a> <a href="http://www.pumafentyshoes.us.com">fenty puma</a> 2018-0327y

pandora jewelry pandora bracelet yeezy shoes adidas yeezy yeezy boost 350 v2 yeezy boost 350 v2 red bottoms louboutin red bottom shoes louboutin outlet louboutin shoes nike air vapormax nike vapor max vapor max air max 2018 nike air max 2018 longchamp handbags longchamp bags adidas outlet adidas outlet store rihanna puma rihanna fenty puma fenty puma 2018-0327y

Say what?


  • 0

#16 Lisawhip

Lisawhip

    Member

  • Members
  • PipPip
  • 27 posts

Posted 19 September 2018 - 01:46 AM

timberland pro work boots adidas store north face outlet pandora bracelet charms nike outlet online oakley sunglasses for men adidas yeezy boost nike clearance air max 97 silver bullet pandora longchamp nike sneakersferragamo belt ecco shoes for men michael kors handbags christian louboutin shoes yeezy boost moncler outletmoncler jackets birkenstock sandals fitflop pandora jewelry 70 off clearance pandora jewelry red bottom retro 13timberlands mcm backpack timberland outlet adidas nmd fitflops oakley sunglasses birkenstock outlet fitflops adidas running shoes coach outlet air max 270 nike factory nike outlet store nike air max 97 puma tory burch sale pandora charms pandora harden shoes pandora jewelry adidas sneakers uggs clearance moncler jackets adidas store nike outlet store online shopping michael kors outlet red bottoms retro 12 adidas adidas ultra boost canada goose clothing nike shoes outlet mbt shoes canadian goose jacket ugg slippers retro 12 michael kors handbags superstar shoes cheap oakley sunglasses adidas boost adidas nmd timberland boots pandora charms soccer cleats louboutin shoes jordan sneakers nike vapor max flyknit nike outlet online pandora rings official site jordan retro 11 michael kors handbags coach handbags air max 97 south beach adidas shoes adidas store nike uk ralph lauren polo nike outlet store online shopping pandora bracelet pandora charms yeezy adidas ray ban glasses retro 12 nike outlet store onlineray ban sunglasses pandora jewelry official site air max 95 neon pandora jewelry adidas sneakers nike uk birkenstock outlet stores pandora jewelry official site nike vapor max plus nike outlet store online shopping birkenstock sandalsbirkenstock shoes pandora charms yeezy shoes polo ralph lauren outlet north outlet online michael kors outlet onlinefitflops sale clearance tory burch sandals nike shoes for women christian louboutin outlet tory burch outlet ysl handbags adidas superstar shoes soccer cleats jordan 14 pandora christian louboutin adidas yeezy ray ban eyeglassesadidas yeezy boost bottega veneta handbags puma outlet mcm backpack philipp plein nike vapor max flyknittimberland shoes yeezy sneakers adidas yeezy boost oakley eyeglasses kate spade outlet online michael kors handbags valentino nike clearance coach outlet ultra boost air jordan 10 pandora charms jordan 4 curry 5 pandora jewelry official site pandora jewelry official site nike air max 95 pandora jewelry ugg shoes salvatore ferragamo nike air vapormax flyknit nike uk adidas outlet air max 270 balenciaga sneakers nike sneakers retro 11 canada goose outlettimberland timberland yeezy moncler jackets adidas outlet nike air max birkenstock outlet red bottom shoesbirkenstock shoes nike sneakers timberland boots coach outlet kate spade purses birkenstock sandals fit flops oakley eyeglasses yeezy boost nike outlet store timberland pro work boots birkenstock outlet bottega veneta outlet pandora charms sale clearance nike outlet pandora charms sale clearance ecco shoes for women pandora jewelry official siteretro 11 coach outlet store retro 13 yeezy birkenstock sandals pandora bracelet timberland boots curry 5 michael kors outlet online yeezy oakley sunglasses moncler jackets nike shoes philipp plein cleats cheap nike shoes balenciaga nike soccer cleats pandora charms north face jackets clearance red bottom shoes canada goose sale ecco shoes for women timberland outlet nike outlet store nike factory store adidas yeezy louboutin nike store adidas soccer pandora jewelry jordan 10 air vapor max nike factory nike clearance adidas yeezy boost air jordan 14 jordan shoes adidas yeezy north face coats kate spade sale air max 98 harden shoes puma shoes louboutin shoes ultra boost oakleyfitflops nike nike shoes pandora jewelry official site coach outlet ysl handbags ray-ban sunglasses sale adidas outlet online nike air max 270 nike outlet store nike shoes uggs boots women coach factory outlet pandora outlet jordans sneakers moncler jackets nike outlet online fit flops for women kate spade ecco shoes for men retro 11 coach rayban sunglasses michael kors handbags pandora jewellery timberland outlet birkenstock sandals retro 13 uggs official sitered bottom shoes christian louboutin ray ban eyeglasses adidas nmd r1 jordan retro 11 birkenstock sandals jordan 8timberland yeezy shoes adidas shoes for women uggs official site nmd r1 fitflops pandora jewelry timberland boots for men pandora mbt pandora pandora jewelry timberland boots oakley glasses birkenstocks red bottom coach outlet uggs official site fitflops sale kate spade handbags nike roshe air max 2018 nike factory uggs boots nike air max 2018 adidas yeezy pandora jewelry nike air max 270 adidas shoes nike outlet nike outlet store online adidas canada goose jackets pandora cyber monday deals pandora charms cyber monday north face jackets black friday michael kors black friday pandora jewelry black friday coach handbags black friday pandora jewelry black friday deals michael kors black friday deals canada goose clothing pandora jewelry black friday coach cyber monday coach black friday deals north face black friday coach black friday sale 2018 michael kors cyber monday canada goose jacket michael kors cyber monday ugg slippers coach cyber monday canada goose outlet north face cyber monday 2018.0919W


  • 0



Reply to this topic



  



 

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Community Skin by Fredson Nunes Junior