vb.org Archive - uCash & uShop old support and thank you thread

Database error in vBulletin 3.0.3:

Invalid SQL:
### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO utt_store_asvs
(varname, title, desc, optioncode, value, actionid)
VALUES
('pju', 'Publically Joinable Usergroups?', 'Enter the usergroupids of the usergroups that users can buy access to in this action. Seperate ids by commas.', '', '36,', '1000000011')
mysql 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 'desc, optioncode, value, actionid)
VALUES
('pju', 'Publically

mysql error number: 1064

Date: Sunday 25th of July 2004 05:59:49 PM
Script: http://shinraonline.com/board/admincp/uttstoreadmin.php
Referer: http://shinraonline.com/board/adminc...actionid=11&s=
Username: Reeve of the Turks
IP Address: xx.xxx.xxx.xxx

edit: I dropped the utt_store_avs table from the database and went back through the install (which again loops on me) but I still get the above error when trying ot copy an action.

LilPimp

07-25-2004 07:51 PM

Just wondering. Is there a bank with this hack?

Zachery

07-25-2004 10:45 PM

Quote:

Originally Posted by LilPimp

Just wondering. Is there a bank with this hack?

Standard Feature.

Zelda-King

07-25-2004 11:09 PM

Thanks! Nice smooth upgrade (vB 3.0.1).

The template uttstore_inputs_input isn't cached in ushop.php.

Cloudrunner

07-25-2004 11:22 PM

Real quick, is there a way to have a random event happen that gives any user online X amount of points per event?

Thanks!

Zelda-King

07-27-2004 08:23 AM

Actually there're quite a lot of uncached templates;

Donate - uttstore_inputs_input (2)
Change Custom Title - uttstore_inputs_input (1)
Change Other User's Custom Title - uttstore_inputs_input (2)
Change Username - uttstore_inputs_input (1)
Glowing Username - uttstore_inputs_input (1)
Colored Username - uttstore_inputs_input (1)
Bank - uttstore_inputs_link (2), uttstore_inputs_text (1)
Sticky Thread - uttstore_inputs_input (1)
Thief - uttstore_inputs_input (2)
Give Forum Access - uttstore_inputs_dropdown (1), uttstore_inputs_input (1)
Deny Forum Access - uttstore_inputs_dropdown (1), uttstore_inputs_input (1)
Buy Forum Access - uttstore_inputs_dropdown (1)

I have the Buy Password disabled so that's untested.

Zachery

07-27-2004 01:33 PM

Quote:

Originally Posted by Zelda-King

In ushop.php find (around line 35)

PHP Code:


		
			
        'uttstore_nav_actionbits'

change too

PHP Code:


		
			
        'uttstore_nav_actionbits',
'uttstore_inputs_dropdown',
'uttstore_inputs_input'

Not the proper way to handle it, but it should work.

Reeve of shinra

07-27-2004 02:24 PM

How should I try to handle the issue I ran into? Should I uninstall and re-install it?

Zachery

07-27-2004 07:39 PM

Quote:

Originally Posted by Reeve of shinra

How should I try to handle the issue I ran into? Should I uninstall and re-install it?

You'll Need to wait for Link to respond as my php/sql is bad :p

TRStealth

07-27-2004 10:14 PM

I have most things working fine, except that for some reason the Shop link in the navbar template won't create the dropdown.

Can anyone help?

All times are GMT. The time now is 06:31 PM.

Page 149 of 232

149

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04262 seconds Memory Usage 1,745KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: