Final Fantasy Republic Forums  
 Home | Forums | Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
     
    
        
     
 
Final Fantasy Republic Forums  
Username:

Password:
CAPTCHA:
  
        
Closed Thread
 
LinkBack Thread Tools Display Modes
  Bahamuth
 
Registered User
 
Posts: 5
 
Reg: Mar 16 2002
 
ID: 295
 
RP: 0
 
None
None
None
None
     
 
Default  Problemes With itemshop !
03.17.02, 13:23:53
  Post #1 (permalink)
 
     

Hi all !
I downloaded Itemshop v 3.0 on vb.org bu i think there is one problems , when i finish the install , i start itemshop.php but there is a ****ing sql error in the field session

Code:
Database error in vBulletin 2.2.2:

Invalid SQL: SELECT weaponsid AS weaponsid,name,element,abilities,cost FROM weapons ORDER BY name
mysql error: Unknown column 'field7' in 'field list'

mysql error number: 1054

Date: Sunday 17th of March 2002 10:15:56 PM
Script: http://mywebsite/itemshop.php
Referer:
look it's my installation.txt
I removed all the php modification and template modification.
I think it's a problems with user custom field !


################################################## ##
# [FFR] Item Shop v 3.0 Revision 2 #
# ================================================IN FO=== #
# Written By: afterlab (Eric Lavender) #
# afterlab's Site: http://www.ffrepublic.com #
# Demo: http://forums.ffrepublic.com/itemshop.php #
# All copyright notices regarding the Item Shop modification, must remain. #
# Support: afterlab@msn.com #
# Thank You for downloading, and installing the Item Shop. Enjoy! #
################################################## ##
# Files Added: itemshop.php, accessories.php, armors.php, weapons.php #
# Files Edited: /admin/index.php, /admin/functions.php, member.php #
# Templates Added: itemshop, card_weapons, card_armor, card_accessories #
# weapons, armor, accessories #
# Templates Edited: getinfo, postbit #
################################################## ##

==========================================
# TAKE BACKUPS OF YOUR DATABASE BEFORE INSTALLING!#
==========================================
# Uploading Files #
==========================================
# install_itemshop.php ==> Admin Directory #
# accessories.php ==> Admin Directory #
# armors.php ==> Admin Directory #
# weapons.php ==> Admin Directory #
# itemshop.php ==> Root Directory #
==========================================

Your first step should be to run the file, install_itemshop.php.
That file will automatically add the required database changes needed.

==========================================
# Open index.php (admin directory) #
==========================================
# Find: #
==========================================
==========================================
# Below that, add: #
==========================================

==========================================
# Open functions.php (admin directory) #
==========================================
# Find: #
==========================================
==========================================
# Below that, add: #
==========================================

// ########################### find weapons ###########################

// ########################### find armor ###########################

// ########################### find accessories ###########################

==========================================
# Open member.php (root directory) #
==========================================
# Find: #
==========================================
==========================================
# Below that, add: #
==========================================

// ########################### find weapons ###########################


// ########################### find armor ###########################

// ########################### find accessories ###########################

======================================
# Done with member.php. Upload to root directory. #
======================================
# Now, onto editing the templates. #
======================================
# First, open the template, getinfo #
# Then add the following wherever you want: #
======================================

======================================
# After that, open the template, postbit #
# Then add the following wherever you want: #
======================================
======================================
# After that, add a new template, card_accessory #
# Insert the following wherever you want it: #
======================================
======================================
# After that, add a new template, card_armor #
# Insert the following wherever you want it: #
======================================
======================================
# After that, add a new template, card_weapon #
# Insert the following wherever you want it: #
======================================
======================================
# After that, add a new template, itemshop #
# Insert the following: #
======================================
======================================
# Add the template, accessories #
======================================
# Insert the following: #
======================================
======================================
# Add the template, armors #
======================================
# Insert the following: #
======================================
======================================
# Add the template, weapons #
======================================
# Insert the following: #
======================================

##################################
# Congratulations! You're done. Enjoy! ~ afterlab #
##################################

Can you help me ?
Attached Files
File Type: txt instructions.txt (15.5 KB, 41 views)

Last edited by Bahamuth : 03.17.02 at 13:28:02.
  Bahamuth is offline
View Bahamuths Profile! Find more posts by Bahamuth!  
  afterlab
 
 
afterlab's Avatar
Founder of FFR
 
Posts: 3,376
 
Reg: Jul 17 2001
 
ID: 1
 
RP: 150
 
Final Fantasy XI
Jamestown Story
50 First Dates
Alternative Press
XBox 360
     
 
Default  03.17.02, 13:36:04
  Post #2 (permalink)
 
     

Redownload the Item Shop. It's been upgraded to Item Shop 3.2.

Download in attachment.
______________________________________



From the founder of Final Fantasy Republic
Gamertag Nation


Last edited by afterlab : 03.19.02 at 13:37:13.
  afterlab is offline
View afterlabs Profile! Find more posts by afterlab! Visit afterlabs Homepage!  
  Bahamuth
 
Registered User
 
Posts: 5
 
Reg: Mar 16 2002
 
ID: 295
 
RP: 0
 
None
None
None
None
     
 
Default  03.17.02, 14:05:11
  Post #3 (permalink)
 
     

Ok man i test it now
Thaks a lot for you help and congratulation for you great Hack
  Bahamuth is offline
View Bahamuths Profile! Find more posts by Bahamuth!  
  Bahamuth
 
Registered User
 
Posts: 5
 
Reg: Mar 16 2002
 
ID: 295
 
RP: 0
 
None
None
None
None
     
 
Default  03.17.02, 16:30:59
  Post #4 (permalink)
 
     

Arg !!!!!!!!!!!

Code:
Database error in vBulletin 2.2.2:

Invalid SQL: SELECT weaponsid AS weaponsid,name,element,abilities,cost FROM weapons ORDER BY name
mysql error: Unknown column  'element' in field list

mysql error number: 1054

Date: Monday 18th of March 2002 01:21:49 AM
Please help me !
  Bahamuth is offline
View Bahamuths Profile! Find more posts by Bahamuth!  
  afterlab
 
 
afterlab's Avatar
Founder of FFR
 
Posts: 3,376
 
Reg: Jul 17 2001
 
ID: 1
 
RP: 150
 
Final Fantasy XI
Jamestown Story
50 First Dates
Alternative Press
XBox 360
     
 
Default  03.17.02, 16:54:42
  Post #5 (permalink)
 
     

Sorry.. Try this new install file.

NOTE: Make sure that you run uninstall_itemshop.php first before you run the new install_itemshop.php script again.

(Zip File above also updated)

Last edited by afterlab : 03.19.02 at 13:36:59.
  afterlab is offline
View afterlabs Profile! Find more posts by afterlab! Visit afterlabs Homepage!  
  Bahamuth
 
Registered User
 
Posts: 5
 
Reg: Mar 16 2002
 
ID: 295
 
RP: 0
 
None
None
None
None
     
 
Default  03.17.02, 18:56:08
  Post #6 (permalink)
 
     

It is still me, All work perfectly except only one thing. When I go in Itemshop.php and I buy an items, it does not appear in my curent items.
But it appear in all post and in my userinfo.

Look This picture :

Have you a solution with this problem?
  Bahamuth is offline
View Bahamuths Profile! Find more posts by Bahamuth!  
  Bahamuth
 
Registered User
 
Posts: 5
 
Reg: Mar 16 2002
 
ID: 295
 
RP: 0
 
None
None
None
None
     
 
Default  03.19.02, 07:43:58
  Post #7 (permalink)
 
     

No solution ?
  Bahamuth is offline
View Bahamuths Profile! Find more posts by Bahamuth!  
  
 
Posts: n/a
 
ID:
 
RP:
     
 
Default  03.19.02, 08:29:27
  Post #8 (permalink)
 
     

That is a beautiful, red question mark.

<img src="http://www.point-blank.cc/blownaway.jpg">
 
 
  afterlab
 
 
afterlab's Avatar
Founder of FFR
 
Posts: 3,376
 
Reg: Jul 17 2001
 
ID: 1
 
RP: 150
 
Final Fantasy XI
Jamestown Story
50 First Dates
Alternative Press
XBox 360
     
 
Default  03.19.02, 13:36:37
  Post #9 (permalink)
 
     

Argh.. Some reason this will not work for other people. Closing thread, hack, and attachments.
  afterlab is offline
View afterlabs Profile! Find more posts by afterlab! Visit afterlabs Homepage!  
Closed Thread



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
[A] For All Your Itemshop Error Reporting Crater Seraph Midgar Library 8 09.15.02 08:42:00
[S] Item Submissions EDO Midgar Library 59 09.10.02 16:17:08
[FFR] New Itemshop 4.0 (Workups) Crater Seraph Webmaster's Pub 104 06.26.02 13:27:34
tata!! Itemshop! rake Webmaster's Pub 72