vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - ICash, Simple, stand alone point system. (https://vborg.vbsupport.ru/showthread.php?t=119086)

rcwild 12-30-2007 06:17 PM

Encountered another odd little quark ...

We're running Subdreamer CMS with a fixed-width skin. Our vBulletin forum uses the same skin. The skin has navigation tabs at the top of the page. Mouse-over on some of the tabs exposes sub-categories.

http://www.canyoneering.net/forums

When I am in the main forums page, the mouse-over works fine. When I am in the ICash page, subcategories under the tabs labeled "Programs" and "Resources" overlap. Same behavior in Safari and Firefox.

Assuming this is some kind of table issue. Is it fixable?

Blaine0002 12-30-2007 06:31 PM

It should be fixable, is it only producing that bug on the icash page? is it doing it on any other pages?

rcwild 12-30-2007 06:38 PM

Quote:

Originally Posted by Blaine0002 (Post 1412085)
It should be fixable, is it only producing that bug on the icash page? is it doing it on any other pages?

I've been checking it on every other page on the site and it is only happening on the ICash page.

PurpleButterfly 12-31-2007 04:03 AM

I uploaded & overwrote all the files, but can't import the new product, I get a database error. I've tried overwriting and also uninstalling the old product/uploading fresh, but both result in the same database error. I have no idea how/where to access SQL or even exactly what to do once I get there...please help! :)

PHP Code:

Database error in vBulletin 3.6.8:
Invalid SQL:
ALTER TABLE `usergroup`
ADD icashpermissions INT10 UNSIGNED NOT NULL DEFAULT '7';
MySQL Error  Duplicate column name 'icashpermissions'
Error Number 1060 


McCarroll21 12-31-2007 04:41 AM

Okay, I have a previous version of this installed on another message board, but I was wondering what I need to enter to get the following to appear correctly.

It's basically the same thing you enter in your phrase for the postbit edit, but I want to do my own edits and can't find out what to enter.

I'm looking for the phrase for cash in hand. It used to be $post[money], now it appears to be $userinfo[$moneyfield]. However, when I put that in, the decimals do not show.

I'm trying to us it with vBookie by setting the money rows to 'vbookie_cash' as it says in the first post. Could this be causing the decimal problem?

Also, trying to work around that, I entered 0 for the amount of decimals to show and it showed the decimal but no numbers after it. Like, it would say '500.' instead of showing '500' as it should have.

joellus 12-31-2007 10:57 AM

hi i have a problem, when a mod or admin, or user self delete a posting, this error comes!

Datenbankfehler in vBulletin 3.6.8:

Invalid SQL:

UPDATE bbuser AS user
SET user.money = user.money -
(
SELECT SUM(post.icash)
FROM bbpost AS post
WHERE post.postid = 233514 AND post.userid = user.userid
) WHERE user.userid = 3748;

MySQL-Fehler : 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 'SELECT SUM(post.icash)
FROM bbpost AS post
WHERE post
Fehler-Nr. : 1064
Datum : Monday, December 31st 2007 @ 01:28:21 PM
Skript : http://www.***************.net/inlin...postids=233514
Referrer : http://www.***************.net/inlin...eadid=15602&p=
IP-Adresse : ***************
Benutzername : ***************
Klassenname : vb_database

what can i do?

thanks!

Blaine0002 12-31-2007 11:08 AM

First of all go into phpmyadmin and check to make sure an 'icash' row exists in the table post.

TCE Killa 12-31-2007 12:38 PM

Is there a way you can put the ICash-Donate underneith the rep power on the post bit? Thanks.

PurpleButterfly 01-01-2008 04:26 PM

Quote:

Originally Posted by PurpleButterfly (Post 1412385)
I uploaded & overwrote all the files, but can't import the new product, I get a database error. I've tried overwriting and also uninstalling the old product/uploading fresh, but both result in the same database error. I have no idea how/where to access SQL or even exactly what to do once I get there...please help! :)


PHP Code:

Database error in vBulletin 3.6.8:
Invalid SQL:
ALTER TABLE `usergroup`
ADD icashpermissions INT10 UNSIGNED NOT NULL DEFAULT '7';
MySQL Error  Duplicate column name 'icashpermissions'
Error Number 1060 


Btw, this refers to our upgrade to 2.03. vb3.6 (running 3.6.8 forum).

We LOVE our IShop and can't live without it now! :( The donate items function no longer works since I can't import the new ICash product (I've even tried using the older versions). I've tripled checked all file uploads and everything I can think of, but just don't have the knowledge to fix this by myself. TIA for any help!:D

ctfortner 01-03-2008 05:36 PM

great mod. one question. is there any way to run a report or something like for points per user during a week, or month etc... I ask because my site currently has active posters, but there is no "contest" at the moment. but the current users are building points. if i start a contest a week from now that the most points for the month etc.., i wont be able to tell which points are old and which are new for the contest. hope that makes sense.

my contest would be something like most points in the month of february wins blah blah blah... is there a way i can say show me total points for this time period?


All times are GMT. The time now is 09:23 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02228 seconds
  • Memory Usage 1,758KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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