Messages

1

Bugs / Double Usernames?

« on: January 08, 2008, 05:30:35 pm »

Hello!  Let me say great job on the mods!  I love the shop and the many features people here have been able to create!  In my toying around with the shop, however, I think I may have found a possible bug. 

I'm trying to make my own change display name item that changes the username, display name, and another name I have in a linked database for a game.  On my site the three are linked, so it is imperative that a user has all 3 changed.  Everything works smoothly with the item, but I think I may have found a problem with the change username item.  The problem is that it doesn't seem that the username checks to see if a user name is already in use.  As a result, you end up getting duplicate usernames...which sounds like a problem to me.  This problem occurs both in the original smf shop change username item as well as my customized item.  I believe smf checks against this and doesn't allow it, so I'm assuming it is unintended for the SMF shop to have this "repeated username feature".  Is this a bug that I have stumbled upon?  How would one go about fixing this?

I would imagine you could look up the database to see if the name already exists, but I'm a newb at php and don't know how exactly one would go about doing that....

2

General SMFShop Discussion / Re: SMFPets is Finally Here (0.1 out)

« on: April 15, 2007, 03:16:26 am »

Never mind, i figured it out.  all of my problems keep happening because people keep putting apostrophes in the text fields.  Is there any way to format the pets mod so that it checks for these apostrophes and corrects them?

3

General SMFShop Discussion / Re: SMFPets is Finally Here (0.1 out)

« on: April 15, 2007, 03:03:57 am »

Ok does anyone else have this problem?  I have TechnoDragon's pet items installed, namely increase max ap, increase happiness, and increase health.  I've also updated the pete engine tot he latest version.  0.1.  Now, my useres always get this error whenever they try to access the shop.  Aka, my entire shop is down now because something went wrong with the pet mod.  I keep getting these update database errors everywhere.  How the heck do I update my database?  And if I don't have to, what the hell is wrong??

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 'red dangly part',
level = 1,
curap = 1,
maxap =' at line 2
File: /home/ninjasan/public_html/forum/Sources/shop/pet_engine.php
Line: 298

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.2, while your database is at version 1.1.1. The above error might possibly go away if you execute the latest version of upgrade.php.

It'd be nice if you guys could help me with this.  My entire site revolves around the shop system, and today is the day I tally the 2 different team's credit totals in order to determine whom is in control.  I can't really do that though, seeing as how the whole shop is down.  Help please.

4

General SMFShop Discussion / Re: SMFPets is Finally Here (0.1 out)

« on: April 14, 2007, 12:39:51 am »

i'm using the latest one.

5

General SMFShop Discussion / Re: SMFPets is Finally Here (0.1 out)

« on: April 13, 2007, 04:37:45 pm »

I figured it out, but now I have a problem when trying to feed a hungry pet with the food item.  I get the following error:

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 'WHERE pet_id = 3 AND ownerid = 1' at line 1
File: /home/ninjasan/public_html/forum/Sources/shop/items/Food.php
Line: 82

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.2, while your database is at version 1.1.1. The above error might possibly go away if you execute the latest version of upgrade.php.

The pet has a hunger level of 9 and the item is supposed to increase it by 10.  What's wrong?  Why do I get a database crash here?

6

General SMFShop Discussion / Re: SMFPets is Finally Here (0.1 out)

« on: April 13, 2007, 11:43:06 am »

Never mind, figured it out.  On the other hand, I do have a problem where my pet's image won't show up after I buy it.  He shows up in the shop, but when i buy it and go to the center to train him and see his stats it just says his name.  What's wrong with that?

7

General SMFShop Discussion / Re: SMFPets is Finally Here (0.1 out)

« on: April 13, 2007, 11:41:18 am »

Get the following error when trying to level up my pet:

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 's cool, and he's blue.',
hunger = 10,
age = 0,
' at line 7
File: /home/ninjasan/public_html/forum/Sources/shop/pet_engine.php
Line: 298

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.2, while your database is at version 1.1.1. The above error might possibly go away if you execute the latest version of upgrade.php.