SMFShop - Shop MOD

[houston]

I keep getting this error when I go to the Manage Boards and Categories Panel

Code Select Expand

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '=> 1,
b.permission_mode, c.ID_CAT, c.name AS cName, c.catOrd
File: /home/eaglebay/public_html/forum/Sources/Subs-Boards.php
Line: 1468

The problem lies with this install.xml command

Code Select Expand

<operation>
<search position="before"><![CDATA[b.override_theme,
]]></search>
<add><![CDATA'countMoney' => 1,
]]></add>
</operation>

I know that this code <add><![CDATA'countMoney' => 1,

Should actually be <add><![CDATA['countMoney' => 1,

The installation adds this to the file <![CDATA['countMoney' => 1, and I change it to this 'countMoney' => 1, as it should be.

So why am I getting the error and not able to access the Manage Boards and Categories Panel

Thanks for any help.

[Saku]

on Subs-Boards.php
search
b.override_theme,

replace:

b.override_theme, b.countMoney,

[houston]

on Subs-Boards.php
search
b.override_theme,

replace:

b.override_theme, b.countMoney,

That did it. Thanks alot for your quick response. 

[Bigguy]

I really need help with this mod. I`m getting alot of errors from it. These are some of the errors i`m getting from it.

EDIT: Umm, I have just looked at this file and the last line in it is like 350 or something, there is no lines after that so there cant be a line 936 is this why there is an error ??

    

Today at 09:12:16 PM
Apply Filter: Only show the error messages of this IP address *********      Apply Filter: Only show the error messages of this session 511940c7ee4f8d357bac0ffa41591f6a
Apply Filter: Only show the error messages of this URL http://www.mywworld.com/smf/index.php?board=67.0
Apply Filter: Only show the errors with the same message
8: Undefined index: shop
File: /home/*****/public_html/smf/Themes/cold/MessageIndex.template.php (eval?)
Line: 936
   
Apply Filter: Only show the error messages of this member zvez    Today at 09:12:26 PM
Apply Filter: Only show the error messages of this IP address ********      Apply Filter: Only show the error messages of this session 511940c7ee4f8d357bac0ffa41591f6a
Apply Filter: Only show the error messages of this URL http://www.mywworld.com/smf/index.php
Apply Filter: Only show the errors with the same message
8: Undefined index: shop
File: /home/*****/public_html/smf/Themes/cold/BoardIndex.template.php (eval?)
Line: 936
   
Apply Filter: Only show the error messages of this member Bigguy    Today at 09:12:58 PM
Apply Filter: Only show the error messages of this IP address *******      Apply Filter: Only show the error messages of this session 766b2a4ada7a4a46400d2b8d91ccaba8
Apply Filter: Only show the error messages of this URL http://www.mywworld.com/smf/index.php
Apply Filter: Only show the errors with the same message
8: Undefined index: shop
File: /home/*****/public_html/smf/Themes/cold/MessageIndex.template.php (eval?)
Line: 936

[Bigguy]

I have looked at my "boardindex.template.php" and my "Messageindex.template.php" and neither one of them contain info about the shop. Is this the problem.

[Purplemadness]

FTP Information Required
Some of the files this package needs to modify are not writable. This needs to be changed by logging into FTP and chmoding the files.
FTP Server: Port: localhost   
Username:   XXXX
Password:   XXXXXX
Local path to SMF: public_html/forums

after i enterall my FTP information, i click on the Proceed button. it takes me back 2 the same page. IDK what 2 do anymore. I need help

Same here =(

[Bigguy]

Can anyone help.or am I asking a stupid question or something. I have searched for answers.

[Saku]

Code Select Expand

<file name="$boarddir/Themes/default/ManageBoards.template.php">
<operation>
<search position="before"><![CDATA[<input type="checkbox" name="override_theme"', $context['board']['override_theme'] ? ' checked="checked"' : '', ' class="check" />
</td>
</tr>';]]></search>
<add><![CDATA[
    //BEGIN SMFShop Shop MOD 1.3 (Build 6) code
loadLanguage("Shop");
echo '                     <tr>
<td>
<b>', $txt['shop_count_points'], '</b><br />
', $txt['shop_count_points_msg'], '<br /><br />
</td>
<td valign="top" align="right">
<input type="checkbox" name="countMoney"', $context['board']['countMoney'] ? ' checked="checked"' : '', ' class="check" />
</td>
</tr>';
//END SHOP MOD
]]></add>
</operation>
</file>

    <file name="$boarddir/Themes/default/Display.template.php">
        <operation>
            <search position="replace"><![CDATA[
// Show how many posts they have made.
echo '
', $txt[26], ': ', $message['member']['posts'], '<br />
<br />';
]]></search>
           <add><![CDATA[
// Show how many posts they have made.
// echo '
// ', $txt[26], ': ', $message['member']['posts'], '<br />
// <br />';

            //BEGIN Shop MOD 0.2 Code
echo '
', $txt[26], ': ', $message['member']['posts'], '<br />
';

            //I couldn't find where all these $message['member'][whatever] variables
            //are set, so I just send an extra database query to get the member's
            //money. Can someone tell me where (file and line) the $message variables
            //are set?
            global $ID_MEMBER, $db_prefix;

            $result_money = db_query("SELECT money
                                      FROM {$db_prefix}members
                                      WHERE ID_MEMBER = {$message['member']['id']}
                                      LIMIT 1", __FILE__, __LINE__);
            $row_money = mysql_fetch_array($result_money, MYSQL_ASSOC);

            echo $modSettings['shopCurrencyPrefix'].$row_money['money'].$modSettings['shopCurrencySuffix']."<br><br>";
            //END SHOP MOD
           

            //BEGIN SMFShop MOD 1.1 (Build 4) CODE
            echo "<a href='$scripturl?action=shop;do=invother2;membertype=id;member={$message['member']['id']}'>View Inventory</a><br>";
            //END SMFShop MOD 1.1 code
]]></add>
        </operation>
    </file>
    <file name="$boarddir/Themes/default/index.template.php">
        <operation>
            <search position="before"><![CDATA[
<a href="', $scripturl, '?action=calendar">', ($settings['use_image_buttons'] ? '<img src="' . $settings['images_url'] . '/' . $context['user']['language'] . '/calendar.gif" alt="' . $txt['calendar24'] . '" style="margin: 2px 0;" border="0" />' : $txt['calendar24']), '</a>', $context['menu_separator'];
]]></search>
            <add><![CDATA[
    //BEGIN Shop MOD 0.2 Code
    echo "<a href='{$scripturl}?action=shop'>", ($settings['use_image_buttons'] ? "<img src='{$settings['images_url']}/{$context['user']['language']}/shop.gif' alt='{$txt['shop']}' style='margin: 2px 0;' border='0' />" : $txt['shop']), "</a>{$context['menu_separator']}";
    //END SHOP MOD
]]></add>
        </operation>
    </file>
the are no change to be made in BoardIndex.template.php and MessageIndex.template.php
put here the line 936 of your files...

[Bigguy]

But there is NO line 936, the lines only go up to 350 or something then its all blank after that. How do I know this I`m using a program called php designer 2005 and it counts the rows of code in a file. I only have 350 lines of code so HOW DO I put this on line 936.

If anyone wants a complete history of this problem please refer to these posts in this thread :

#550
#551
#562
#566
#569
#694
#701

[Daniel15]

Hi everyone,
Due to the inability to handle everyone's support questions in this one thread, I have created a bug tracker on my site. You may visit the support area of my site at http://support.dansoftaus.uni.cc/. Use the bug tracker for bugs, and the support ticket system for anything else (feature requests, installation help, etc, etc). Also, if I'm online, there is a live support feature, which is basically like a live chat site.

Also, about the FTP problem, I don't think that's related to SMFShop. Maybe it's something to do with the package manager.

Please also remember that the SMFShop install package for SMF 1.1 is UNOFFICIAL.

ANOTHER NOTE: The dansoftaustralia.net domain is currently unavailable. Pleas access my site by going to http://www.dansoftaus.uni.cc/

[Daniel15]

IMPORTANT! A security vulnerability has been found in the dointerest.php file. To fix it, please replace your dointerest.php file with this:


if(!isset($_SERVER["HTTP_HOST"])) {

include("../../SSI.php");

$interest_rate = $modSettings['shopInterest'] / 100;

db_query("UPDATE {$db_prefix}members

  SET moneyBank = moneyBank + (moneyBank*{$interest_rate})", __FILE__, __LINE__);

echo "Interest added at ".date("d/m/Y h:i:s A");
}


Thanks,
--daniel15

[Yuri]

1.     Extract File     ./Sources/shop/items/AddToPostCount.php     
2.    Extract File    ./Sources/shop/items/ChangeOtherTitle.php    
3.    Extract File    ./Sources/shop/items/filedownload.php    
4.    Extract File    ./Sources/shop/items/IncreaseKarma.php    
5.    Extract File    ./Sources/shop/items/IncreaseTimeLoggedIn.php    
6.    Extract File    ./Sources/shop/items/morespace.php    
7.    Extract File    ./Sources/shop/items/RandomMoney.php    
8.    Extract File    ./Sources/shop/items/Rock.php    
9.    Extract File    ./Sources/shop/items/Steal.php    
10.    Extract File    ./Sources/shop/items/testitem.php    
11.    Extract File    ./Sources/shop/items/testitem2.php    
12.    Extract File    ./Sources/shop/item_engine.php    
13.    Extract File    ./Sources/shop/Shop.php    
14.    Extract File    ./Sources/shop/ShopAdmin.php    
15.    Extract File    Themes/default/Shop.template.php    
16.    Extract File    Themes/default/ShopAdmin.template.php    
17.    Extract File    Themes/default/languages/Shop.english.php    
18.    Execute Modification    ./Themes/default/Display.template.php    Failure
19.    Execute Code    updateScript.php    


help , plz ?? I use 1.0.5 

[Daniel15]

VERSION 1.31 RELEASED! This fixes a number of bugs, and also fixed a major security hole in dointerest.php. It is recommended that all users of SMFShop upgrade to the newest version.

Good news for SMF 1.1 users! SMFShop 1.31 now has a SMF 1.1 package! This, however, is not tested by me. I recommend that you test it on a testing board before installing it on a public site!

Changes in 1.31:
* A MAJOR security update to dointerest.php file!
* The Display Name is now used to display members' names, instead of their login name
* Everywhere where you had to manually enter in a member's name has now been replaced with the SMF 'Select Member' function (frequently requested)
* View Other Members' Inventory function can no longer use a member's ID to get their inventory (due to feedback from the SMF developers)

Files which have been changed in 1.31:
* Sources/shop/ShopAdmin.php
* Sources/shop/ShopAdmin.template.php
* Sources/shop/Shop.php
* Sources/shop/Shop.template.php
* Sources/shop/dointerest.php
* Themes/default/language/Shop.english.php
* Sources/shop/items/ChangeOtherTitle.php
* Sources/shop/items/DecreasePost.php
* Sources/shop/items/Steal.php

Modified Edits:
* Themes/default/Display.template.php

Texts which have been removed:
* $txt['shop_member_type_error']

Get it from the SMFShop MOD page

Also, remember that official SMFShop support is available at http://support.dansoftaus.uni.cc/ Use the bug tracker for bug reports, and the support ticket system for everything else.

[Moocat]

EXCELLENT JOB, DAN!

this is matt, btw, the guy who put that ticket in your site i can't wait to try it!

[Moocat]

ummm... unfortunately, the package doesn't work... either get "fatal error" and some long string of godknowswhat (only saw it once and can't replicate... had to reinstall smf and delete table entries). when it doesn't do that, i get "hacking attempt". like the file said in the case of the "internal server error", my public_html folder did get changed to 777, so i chmodded it back to 755.... refreshed... and it told me that smf_shop_items or whatever had already been created. a little help please?

ps : stupidly forgot to mention: using the 1.1 RC1 version.... with smf 1.1 RC1, ofc.

[Daniel15]

Try the SMF 1.1 version again (can you please try it with a fresh install of SMF - no mods). There was a slight problem with one of the SQL statements which made it think that there was a hacking attempt...

[J. Williams]

Excellent work daniel15

Hope that smf 1.1 will treat it with care (hopefully but it might not)

[ArkServer]

Unknown column 'countMoney' in 'field list'
File: Sources\Post.php
Line: 1604

Can anyone make export the SQL file for me? i cant install it with the install file!

http://arkserver.servehttp.com/forum/index.php
When i click "shop" i only see a blank screen.

Download the modified files here if you want: http://arkserver.servehttp.com/smf/
maybe you guys/girls can see what i did wrong..

[ArkServer]

Ok ignore the post before me, i fixed it all. Did manual install and manually added the SQL. Tho i have 1 more question: How can i add an item?

Item Administration
|--- Add Items

doesnt work, it shows an empty itemlist

[Moocat]

the first three tries i made were with the original smf install. re-downloading and trying agian. thanks.