Messages

16

Items / Re: Some Name Alteration Items

« on: June 13, 2006, 03:21:55 am »

This is a great shop item, but how can I revert all changed usernames back to normal? My shop items have a validity of only one month so after one month, all items bought will revert to the original, including these name alterations.

17

General SMFShop Discussion / Re: Problems uninstalling and re-installing Mod Shop

« on: June 10, 2006, 04:11:46 pm »

Ok, how do I do that? remove all shop settings from smf_settings table?

18

General SMFShop Discussion / "Database already installed" error

« on: June 10, 2006, 04:04:01 am »

Previously I was able to uninstall the Shop Mod but now that I tried to re-install it in the forum, I get an error saying

Database already installed on SMF Shop 2.1

There's supposedly no problem, but the thing is I cannot see the Admin Panel for the Shop Mod? It's not under Forum Maintenance where it's supposed to be.

How to successfully re-install the Mod Shop?

19

General SMFShop Discussion / Re: Can't get installScript.php to work

« on: June 10, 2006, 04:00:19 am »

followed the script above but got the following error:

#1064 - 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 'ALTER TABLE `smf_members` ADD `moneyBank` DECIMAL(9, 2) UNSIGNED

my mySQL version is 5.0.22. what do i do?

20

General SMFShop Discussion / Problems uninstalling and re-installing Mod Shop

« on: June 07, 2006, 04:02:47 am »

Our forum crashed the other time so I had to uninstall all mods. For Mod Shop, I encountered unsintallation errors so what I did was undo all edits in ALL the files associated with Mod Shop AND dropped the smf_shop_items and smf_inventory tables.

Yet when I tried to re-install the Mod Shop, I got an error saying the database already exists. What do I do then to properly re-install it?

21

General SMFShop Discussion / Re: Question on "Steal Credits"

« on: May 07, 2006, 05:21:33 am »

Hmm sorry I still don't get it.

Code: [Select]

global $sourcedir;
require_once($sourcedir . '/Subs-Post.php');


So I add the code above in all of the php files in Sources/ shop/ items ?

Code: [Select]

$result = db_query("SELECT memberName
FROM {$db_prefix}members
  WHERE ID_MEMBER = {$ID_MEMBER}'", __FILE__, __LINE__);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
 $theif = $row['memberName'];
$result = db_query("SELECT ID_MEMBER
FROM {$db_prefix}members
  WHERE memberName = '{$_POST['stealfrom']}'}'", __FILE__, __LINE__);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$pmfrom = array(
'id' => 1,
'name' => 'Your name',
'username' => 'Your name'
);
$pmto = array(
'to' => array($row['ID_MEMBER']),
'bcc' => array()
);
sendpm($pmto, 'PM Subject', "Pm body. Use {$theif} for the name of the guy who stole, and {$steal_amount} for the amount of points stolen", 0, $pmfrom);


Then this code above I should add only to steal.php, is that correct?

22

General SMFShop Discussion / Re: Question on "Steal Credits"

« on: May 07, 2006, 02:52:24 am »

Hmm sorry but when you said

Insert this code at the top of all your items

did you mean add it to all .php files that are in shop items, as in AddToPostCount.php, ChangeOtherTitle.php, etc? Hmm that's a lot of files to edit... 

And this one, I didn't get this. Which template do I need to edit and I'll add this at the end of which code again? 

And insert this code at the end of the code for the actual item before the return line.

And in the last line,

sendpm($pmto, 'PM Subject', "Pm body. Use {$theif} for the name

Should I really use that spelling for thief cos the correct spelling is "thief" 

Thanks for the help!

23

General SMFShop Discussion / Re: Can't add shop item images

« on: May 07, 2006, 02:47:54 am »

That did it! I tried to change the permissions via Usermin and it worked. Thanks guys!

24

General SMFShop Discussion / Re: Question on "Steal Credits"

« on: May 06, 2006, 10:35:24 pm »

I'll appreciate it if someone can code this

25

General SMFShop Discussion / Question on "Steal Credits"

« on: May 06, 2006, 07:07:40 pm »

My members are asking if it's possible to know who attempted to stole one's credits. Of course, once they knew who stole their credits, they can fight back!  Hopefully this is possible.

26

General SMFShop Discussion / Re: Award points only for posts in certain folders

« on: May 06, 2006, 10:40:18 am »

It worked! Thanks!

27

General SMFShop Discussion / Re: Can't add shop item images

« on: May 06, 2006, 10:34:19 am »

I'm using SmartFTP and the permissions for /forum is already 777.

However I can't chmod 777 the Sources/shop folder and everything under it. I get an "Operation not permitted" error. And Again  I have this error only for this mod, I've got no problem with other mods.

28

General SMFShop Discussion / Re: Can't add shop item images

« on: May 06, 2006, 09:06:24 am »

It still didn't work, I still get an "Operation not permitted" error when trying to upload files via SmartFTP. The thing is it only happens when I'm uploading files related to the shop mod. All the other times I don't experience any problem uploading any files.

29

General SMFShop Discussion / Re: Questions about Shop mod

« on: May 06, 2006, 08:58:14 am »

Ok, I just hope this should be included in the next version of the Shop mod, or if there's some codes I can add right now, let me know.

30

General SMFShop Discussion / Re: Questions about Shop mod

« on: May 06, 2006, 06:08:55 am »

Yup, that's what I did. But I'm concerned about other spammers like him. You mentioned that credits are deducted when a person deletes a post, but what if my mods deleted it? In my forum's case as I said the points didn't get deducted, so I hope this can be coded into the script.