Removing Shop 2
-----
| Author | Message | |
|---|---|---|
|
BlinkyBill01 |
||
| Sat Aug 26, 2006 7:56 pm Post subject: Removing Shop 2 | ||
|
Hey Thoul, I want to get rid of Shop 2 and install Shop 3. Any idea how?
|
||
|
Thoul |
||
| Sat Aug 26, 2006 8:30 pm Post subject: re: Removing Shop 2 | ||
|
Uninstalling Shop 2 (or any mod, for that matter) is a matter of undoing the changes done during the install. It's a three step process. Get a copy of the instructions for Shop 2, you'll need that to do this.
For the first step, go through the various file edits again, but this time reverse the changes. For example, if there is a FIND action followed by a REPLACE WITH action, locate the REPLACE WITH code in your file and replace it with the FIND code. For any ADD or similar actions, find and delete the code that was added during installation. The second step is to delete the files that were added by the hack, like shop.php, shop_effects.php, and so on. All of these are listed near the top of the instructions. The third and final step is to remove the database portions of the hack. To do that, you'll need to run these SQL queries. Keep in mind that any and all data stored as part of the shop - shops, items, everything - will be deleted by this. Unless you make a backup of the database before doing this, none of that can be recovered. Code: DROP TABLE `phpbb_shopitems`;
DROP TABLE `phpbb_shops`; DELETE FROM phpbb_config WHERE config_name = 'multibuys'; DELETE FROM phpbb_config WHERE config_name = 'restocks'; DELETE FROM phpbb_config WHERE config_name = 'sellrate'; DELETE FROM phpbb_config WHERE config_name = 'viewtopic'; DELETE FROM phpbb_config WHERE config_name = 'viewprofile'; DELETE FROM phpbb_config WHERE config_name = 'viewinventory'; DELETE FROM phpbb_config WHERE config_name = 'specialshop'; DELETE FROM phpbb_config WHERE config_name = 'viewtopiclimit'; DELETE FROM phpbb_config WHERE config_name = 'shop_orderby'; DELETE FROM phpbb_config WHERE config_name = 'shop_give'; DELETE FROM phpbb_config WHERE config_name = 'shop_trade'; DELETE FROM phpbb_config WHERE config_name = 'shop_invlimit'; ALTER TABLE phpbb_users DROP `user_effects`; ALTER TABLE phpbb_users DROP `user_privs`; ALTER TABLE phpbb_users DROP `user_custitle`; ALTER TABLE phpbb_users DROP `user_specmsg`; ALTER TABLE phpbb_users DROP `user_items`; ALTER TABLE phpbb_users DROP `user_trade`; |
||
|
BlinkyBill01 |
||
| Sat Aug 26, 2006 11:49 pm Post subject: re: Removing Shop 2 | ||
|
ok, cool. It's all been removed and my forum is still running. NICE!
Now, here is a dumb question: have you released a modded version of Shop 3 or where can I go to get Zarath's 3.0? Also, the mods listed in this forum... are these all that have been released? I didn't know if other people made their own mods that would go with it? I'm trying to offer a lot of things to my forum members and didn't know if there were any unmentioned mods or mods that are being worked on 
Thanks again for all the help! |
||
|
Thoul |
||
| Sun Aug 27, 2006 10:50 am Post subject: re: Removing Shop 2 | ||
|
You can get Shop 3 from here:
http://www.zarath.com/mods/shop_mod_300.zip Also don't forget to apply the list of fixes to it: http://www.phpbbsmith.com/mb/about256.html Hm, I really should see about posting a version that has those fixes incorporated already. All of my Shop 3 mods can be found here: http://www.phpbbsmith.com/refinements.html#Shop%20Add-Ons There's one list there that I haven't mentioned in this forum, I think. There's only one other mod released that I know of, and that was NulAvatar. It can be found here: http://mods.nuladion.net/viewforum.php?f=1 Nuladion might have also updated some of his other Shop 2 mods since the last time I was there, so I'd look around that site a little just to be sure. |
||
|
BlinkyBill01 |
||
| Sun Aug 27, 2006 11:29 am Post subject: | ||
|
thank ya kindly, my man!
|
||
|
Thoul |
||
| Sun Aug 27, 2006 11:39 am Post subject: re: Removing Shop 2 | ||
|
You're welcome, I'm glad I could help.
|
||
|
andi |
||
| Tue Sep 12, 2006 12:27 pm Post subject: re: Removing Shop 2 | ||
|
thoul, i did the sql part and now im getting this huge error on my board
Database Connection Error! Table 'divascorner_com_-_phpbb.phpbb_shopitems' doesn't exist how can i fix this? 
|
||
|
andi |
||
| Tue Sep 12, 2006 1:23 pm Post subject: re: Removing Shop 2 | ||
|
nevermind, i just put in the install sql and it fixed the error but i still cant remove the shops sql without getting errors...
|
||
|
Thoul |
||
| Wed Sep 13, 2006 10:47 am Post subject: re: Removing Shop 2 | ||
|
Before removing the SQL, you need to remove the file edits. Until you remove those, the forum will still try to pull information from the shop SQL, whether it's there or not.
|
||
Page 1 of 1