uCash & uShop old support and thank you thread

/me Installs. I'm the first for the most aniticipated hack!!1

[Reeve of shinra]

hmmm I am trying to copy the change usergroup item and I get this error:

The usergroup I am looking to add is 36. I tried it as "36" and as "36,"

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]

Just wondering. Is there a bank with this hack?

[Zachery]

Originally Posted by LilPimp

Just wondering. Is there a bank with this hack?

Standard Feature.

[Zelda-King]

Thanks! Nice smooth upgrade (vB 3.0.1).

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

[Cloudrunner]

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]

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]

Originally Posted by Zelda-King

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.

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]

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

[Zachery]

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

[TRStealth]

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?