XMB Forum Software
Not logged in [Login - Register]
Go To Bottom

Printable Version  
Author: Subject: Shop Hack FIXED!
RunnyBabbit
Member
***




Posts: 7
Registered: 4-28-2018
Member Is Offline


[*] posted on 5-12-2018 at 08:37 PM
Shop Hack FIXED!


While installing the hack, I noticed a few errors:

If you are using MyPHP V5 you will encounter a SQL error where it says you need to fix "TYPE=MyISAM"

You will need to edit the install.php file BEFORE the install and replace:
TYPE=MyISAM to
ENGINE=MyISAM

If too late, you can also go to your AdminCP and check your tables and edit each SQL entry.

For example:
If you see an error creating Shop_Cats
Go to the instal.php file and find:
Shop_Cats

You will see something like:
CREATE TABLE ".$tablepre."shop_cats (
id smallint(6) NOT NULL auto_increment,
cid smallint(6) NOT NULL default '0',
owner int(12) NOT NULL default '0',
catname varchar(100) NOT NULL default '',
description text NOT NULL,
displayorder int(10) NOT NULL default '0',
private varchar(30) NOT NULL default '1',
userlist text NOT NULL,
lastadd varchar(64) NOT NULL default '',
password varchar(32) NOT NULL default '',
status SET('on','off') NOT NULL default 'on',
creatoronly SET('on','off') NOT NULL default 'off',
views int(10) NOT NULL default '0',
items int(10) NOT NULL default '0',
ownermoney SET('on','off') NOT NULL default 'on',
PRIMARY KEY (id)
) TYPE=MyISAM

Edit the SQL to:
CREATE TABLE PREFIX_shop_cats (
id smallint(6) NOT NULL auto_increment,
cid smallint(6) NOT NULL default '0',
owner int(12) NOT NULL default '0',
catname varchar(100) NOT NULL default '',
description text NOT NULL,
displayorder int(10) NOT NULL default '0',
private varchar(30) NOT NULL default '1',
userlist text NOT NULL,
lastadd varchar(64) NOT NULL default '',
password varchar(32) NOT NULL default '',
status SET('on','off') NOT NULL default 'on',
creatoronly SET('on','off') NOT NULL default 'off',
views int(10) NOT NULL default '0',
items int(10) NOT NULL default '0',
ownermoney SET('on','off') NOT NULL default 'on',
PRIMARY KEY (id)
) ENGINE=MyISAM

Then go to your SQL data base and add:
CREATE TABLE PREFIX_shop_cats (
id smallint(6) NOT NULL auto_increment,
cid smallint(6) NOT NULL default '0',
owner int(12) NOT NULL default '0',
catname varchar(100) NOT NULL default '',
description text NOT NULL,
displayorder int(10) NOT NULL default '0',
private varchar(30) NOT NULL default '1',
userlist text NOT NULL,
lastadd varchar(64) NOT NULL default '',
password varchar(32) NOT NULL default '',
status SET('on','off') NOT NULL default 'on',
creatoronly SET('on','off') NOT NULL default 'off',
views int(10) NOT NULL default '0',
items int(10) NOT NULL default '0',
ownermoney SET('on','off') NOT NULL default 'on',
PRIMARY KEY (id)
) ENGINE=MyISAM

And press GO

You should see:
Your SQL query has been executed successfully

Go back to your AdminCP and check tables. Find any other tables that weren't correctly added and do the same process again.

Hope this helps anyone who may have issues installing. :)

TIP: It's easier to edit the the install.php
Find and REPLACE:
TYPE=MyISAM to ENGINE=MyISAM

I did this with 0 issues.





- Monique
View user's profile Visit user's homepage View All Posts By User
AlwaysLosingPasswords
Member
***




Posts: 21
Registered: 11-25-2022
Member Is Offline


[*] posted on 11-28-2022 at 04:52 AM


Good fix! Thank you. :xmb::)
View user's profile View All Posts By User

  Go To Top

Powered by XMB 1.9.12 (Debug Mode)
XMB Forum Software © 2001-2024 The XMB Group
[Queries: 16] [PHP: 20.2% - SQL: 79.8%]