The Arcive of Official vBulletin Modifications Site.

uCash & uShop old support and thank you thread · **Released**: 04-12-2004

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

U-Dox · #**892** 05-17-2004, 10:39 PM

I Gotta Problem. For Some Reason Tha "Thief" Option Isnt Workin Anymore.

it says "There seems to have been a slight problem with the database"

i dont know what to do. it was workin very well yesterday and my members love it. i didnt make any changes to the site at all to make it not work. What should i do?

Zachery · #**893** 05-17-2004, 10:40 PM

Right click and view source, we need to view the error message to see whats wrong.

U-Dox · #**894** 05-18-2004, 01:08 AM

Aight This Is What It Said

<html><head><title>StreetVerbz Database Error</title><style type="text/css"></style></head>
<body></table></td></tr></table></form>
<blockquote><p class="error"> </p><p class="error"><b>There seems to have been a slight problem with the StreetVerbz database.</b><br />
Please try again by pressing the <a href="javascript:window.location=window.location;" >refresh</a> button in your browser.</p><p class="error">An E-Mail has been dispatched to our <a href="mailto:dbmaster@example.com">Technical Staff</a>, who you can also contact if the problem persists.</p><p class="error">We apologise for any inconvenience.</p><form><textarea class="error" rows="15" cols="100" wrap="off">Database error in vBulletin 3.0.1:

Invalid SQL: UPDATE user SET uttpoints=uttpoints+5.00, reputation=reputation- WHERE userid='1'
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 'WHERE userid='1'' at line 1

mysql error number: 1064

Can You See The Problem?

Flow Fusion · #**895** 05-18-2004, 04:27 AM

How do I update the users money in the richest members info? My members are still getting very little money for each post even though I updated every forum?

Zachery · #**896** 05-18-2004, 04:29 AM

Quote:

Originally Posted by Flow Fusion

How do I update the users money in the richest members info? My members are still getting very little money for each post even though I updated every forum?

Did you edit the money per posts view thread settings? the forum settings are just multipliers, nothing more.

Flow Fusion · #**897** 05-18-2004, 02:46 PM

Quote:

Originally Posted by Zachery

Did you edit the money per posts view thread settings? the forum settings are just multipliers, nothing more.

I did edit that but this is what I get

http://www.giftedsouls.com/gs/ushop.php?do=richestusers

I also want to know about the errors I get when I upload the functions_showthread.php

as well as the showthread.php

I will post them later because I want to figure this out first.

Intex · #**898** 05-18-2004, 05:18 PM

** BUMP - Any help ? **

Quote:

Originally Posted by Intex

I've run the install file 'ushop_install.php' and eveything installed ok. I then completed all the file edits as instructed. However when I came to do the template updates, as soon as I went into AdminCP (or anywhere else on the site), I now get an error:

Code:

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in C:\Apache2\htdocs\forum\includes\init.php on line 508

Here is the PHP code (I've highlighted line 508 in the code *** below ***)

PHP Code:


			
        // add default special templates
        $specialtemplates = array_merge(array(
            'options',
            'cron',
            'forumcache',
            'usergroupcache',
            'stylecache',
            'arcadesettings'
        ), $specialtemplates);
*** THIS IS LINE 508 ***
        $datastoretemp = $DB_site->query("
            SELECT title, data
            FROM " . TABLE_PREFIX . "datastore
            WHERE title IN ('" . implode("', '", $specialtemplates) . "')
        ");
        unset($specials, $specialtemplates);

I've only got a few hacks installed (vbadvanced, v3 arcade and htl (which I didn't use to install this hack btw).

Any ideas?

sabret00the · #**899** 05-18-2004, 05:21 PM

Quote:

Originally Posted by Intex

I've run the install file 'ushop_install.php' and eveything installed ok. I then completed all the file edits as instructed. However when I came to do the template updates, as soon as I went into AdminCP (or anywhere else on the site), I now get an error:

Code:

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in C:\Apache2\htdocs\forum\includes\init.php on line 508

Here is the PHP code (I've highlighted line 508 in the code *** below ***)

PHP Code:


			
          // add default special templates
          $specialtemplates = array_merge(array(
              'options',
              'cron',
              'forumcache',
              'usergroupcache',
              'stylecache',
              'arcadesettings'
          ), $specialtemplates);
  *** THIS IS LINE 508 ***
          $datastoretemp = $DB_site->query("
              SELECT title, data
              FROM " . TABLE_PREFIX . "datastore
             WHERE title IN ('" . implode("', '", $specialtemplates) . "')
          ");
          unset($specials, $specialtemplates);

I've only got a few hacks installed (vbadvanced, v3 arcade and htl (which I didn't use to install this hack btw).

Any ideas?

do this

PHP Code:


			
           // add default special templates
           $specialtemplates = array_merge(array(
               'options',
               'cron',
               'forumcache',
               'usergroupcache',
               'stylecache',
               'arcadesettings',
           ), $specialtemplates);
  // *** THIS IS LINE 508 ***
           $datastoretemp = $DB_site->query("
               SELECT title, data
               FROM " . TABLE_PREFIX . "datastore
             WHERE title IN ('" . implode("', '", $specialtemplates) . "')
           ");
           unset($specials, $specialtemplates);

and tell me if it fixes the problem

Intex · #**900** 05-18-2004, 05:25 PM

sabret00the - Thx for the reply.

From what I can see you've put the $specialtemplates); on it's own line. Would this really make that much difference? BTW: the line where I said THIS IS LINE 508 was only put in there for posting here. It's not in the template at all.

Flow Fusion · #**901** 05-18-2004, 06:40 PM

Ok here are the errors I'm getting from the includes/functions.php

Parse error: parse error in /home/giftedso/public_html/gs/includes/functions.php on line 1871

Fatal error: Call to undefined function: is_browser() in /home/giftedso/public_html/gs/global.php on line 59

And this is the last file I need to upload. This is the mofo that is causeing the points to not move correctly I assume?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.22682 seconds Memory Usage 2,346KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (3)bbcode_php (4)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!