vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   uCash & uShop v2.0.0 (https://vborg.vbsupport.ru/showthread.php?t=107233)

Gio~Logist 02-05-2006 10:37 PM

HERE WE GO GUYS!
Installation should work 100% now!

Here is the updated zip.

NuclioN 02-05-2006 10:37 PM

Quote:

Originally Posted by gio~logist
What happens to you on step 7?

Don't know sir, it now gives an error by step 5:

Database error in vBulletin 3.5.2:

Invalid SQL:
UPDATE forum
SET
`ucash_perthread` = '1',
`ucash_perreply` = '1',
`ucash_perview` = '1';

MySQL Error : Unknown column 'ucash_perthread' in 'field list'
Error Number : 1054

Gio~Logist 02-05-2006 10:40 PM

Quote:

Originally Posted by NuclioN
Don't know sir, it now gives an error by step 5:

Database error in vBulletin 3.5.2:

Invalid SQL:
UPDATE forum
SET
`ucash_perthread` = '1',
`ucash_perreply` = '1',
`ucash_perview` = '1';

MySQL Error : Unknown column 'ucash_perthread' in 'field list'
Error Number : 1054

Do the following to delete all instances of ushop and ucash (this will delete everything in ushop and ucash)

Code:

DELETE *
FROM `yoursite_test`.`datastore`
WHERE `title` LIKE '%ushop%'
OR `data` LIKE '%ushop%'
LIMIT 0 , 30

Then
Code:

DELETE *
FROM `yoursite_test`.`datastore`
WHERE `title` LIKE '%ucash%'
OR `data` LIKE '%ucash%'
LIMIT 0 , 30


Replace yoursite with whatever your databases have before the name.

eNforce 02-05-2006 10:42 PM

It finally installs :D

When I go to update allowed usergroups in the uShop settings I get this:


Warning: Invalid argument supplied for foreach() in /includes/functions_ushop.php on line 535

Warning: Invalid argument supplied for foreach() in /admincp/ushop/ushop_admin.usergroupenmasse.php on line 11

Warning: Invalid argument supplied for foreach() in /admincp/ushop/ushop_admin.usergroupenmasse.php on line 15

Warning: Invalid argument supplied for foreach() in /admincp/ushop/ushop_admin.usergroupenmasse.php on line 18

Edit: I clicked Saved Values and now it appears to be working.

ThePimp 02-05-2006 10:45 PM

TADA! Worked! Now, I'll test it and see if it works live.

Thanks!

Gio~Logist 02-05-2006 10:45 PM

Quote:

Originally Posted by eNforce
It finally installs :D

When I go to update allowed usergroups in the uShop settings I get this:


Warning: Invalid argument supplied for foreach() in /includes/functions_ushop.php on line 535

Warning: Invalid argument supplied for foreach() in /admincp/ushop/ushop_admin.usergroupenmasse.php on line 11

Warning: Invalid argument supplied for foreach() in /admincp/ushop/ushop_admin.usergroupenmasse.php on line 15

Warning: Invalid argument supplied for foreach() in /admincp/ushop/ushop_admin.usergroupenmasse.php on line 18

Edit: I clicked Saved Values and now it appears to be working.


If anyone gets that error just go to update in mass >> save values. That will fix it.

Wachtmeister 02-05-2006 10:48 PM

Will this work with table prefixes? When i read the error messages, i guess it will not... ?

NuclioN 02-05-2006 10:49 PM

Got it installed now :) Tnx for your great support.

Gio~Logist 02-05-2006 10:49 PM

Quote:

Originally Posted by Wachtmeister
Will this work with table prefixes? When i read the error messages, i guess it will not... ?


It should :p

Gio~Logist 02-05-2006 10:50 PM

Quote:

Originally Posted by NuclioN
Got it installed now :) Tnx for your great support.

:p Thank you for your patience.

Lurk 02-05-2006 10:51 PM

I get this on ushop.php

Code:

Warning: implode(): Bad arguments. in /includes/functions_ushop.php on line 70

Warning: Invalid argument supplied for foreach() in /includes/functions_ushop.php on line 86

Warning: Cannot modify header information - headers already sent by (output started at /home/lurk/public_html/forum/includes/class_core.php:2983) in /ushop.php on line 143


Gio~Logist 02-05-2006 10:53 PM

Quote:

Originally Posted by Lurk
I get this on ushop.php

Code:

Warning: implode(): Bad arguments. in /includes/functions_ushop.php on line 70

Warning: Invalid argument supplied for foreach() in /includes/functions_ushop.php on line 86

Warning: Cannot modify header information - headers already sent by (output started at /home/lurk/public_html/forum/includes/class_core.php:2983) in /ushop.php on line 143


Refresh. Some files need to be refreshed so that everything updates :p

maroulis 02-05-2006 10:55 PM

something else in case everybody else is as NooB as me :) I've renamed my /admincp to something else. Make sure you copy the /admincp files to whatever your new directory is. I'm eating right now but will try the new installer in a bit...

BIG THANKS TO GIO for sorting out the problems - KUDOS GUYS!

Lurk 02-05-2006 10:55 PM

Quote:

Originally Posted by gio~logist
Refresh. Some files need to be refreshed so that everything updates :p

Wow, thank you so much. Every hack needs someone like you. ;)

Gio~Logist 02-05-2006 10:56 PM

I've noticed a lot of people who installed it successfuly didn't click install!


Don't forget to

CLICK INSTALL!

Gio~Logist 02-05-2006 10:56 PM

Quote:

Originally Posted by maroulis
something else in case everybody else is as NooB as me :) I've renamed my /admincp to something else. Make sure you copy the /admincp files to whatever your new directory is. I'm eating right now but will try the new installer in a bit...

BIG THANKS TO GIO for sorting out the problems - KUDOS GUYS!

:p Glad everything worked out :p

Gio~Logist 02-05-2006 10:57 PM

Quote:

Originally Posted by Lurk
Wow, thank you so much. Every hack needs someone like you. ;)


:p Thank you. Just trying to make sure everyone gets to experience the true ability of this hack and not the ability of your error messages hehe.

eNforce 02-05-2006 10:58 PM

/installed :)

For my Most Sold list the items listed area already up to 70 sold, this isn't correct is it?

maroulis 02-05-2006 10:58 PM

gio let me know if you have a donate button... would like to be the first to offer you some $$ via PayPal.. I think EVERYBODY who installed it should it's the LEAST we can do for finally turning this over..!

HOTM here we come !! :)

Gio~Logist 02-05-2006 11:00 PM

Quote:

Originally Posted by eNforce
/installed :)

For my Most Sold list the items listed area already up to 70 sold, this isn't correct is it?

Try updating things in the admincp and/or refresh. Shouldn't show as 70.

Also, don't forget to click
INSALL

Gio~Logist 02-05-2006 11:01 PM

Quote:

Originally Posted by maroulis
gio let me know if you have a donate button... would like to be the first to offer you some $$ via PayPal.. I think EVERYBODY who installed it should it's the LEAST we can do for finally turning this over..!

HOTM here we come !! :)


Thank you :p Thank you very much!

You can donate to me at gio@dopegfx.com

Gio~Logist 02-05-2006 11:02 PM

DON'T FORGET,

The newest available zip is located at:
https://vborg.vbsupport.ru/showpost....&postcount=121

I have contacted a mod who will hopefully update the first post for me.

eNforce 02-05-2006 11:06 PM

When trying to use the 'Give Points in Mass' feature:

Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE user SET ucash=ucash+posts*0.05 WHERE (usergroupid IN ('6') OR '6' IN (membergroupids)) AND Array[\'ucash_pointsfield\' '';

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 '[\'ucash_pointsfield\' ''' at line 1
Error Number : 1064
Date : Sunday, February 5th 2006 @ 08:04:49 PM
Script : http://www.seriosgaming.com/admincp/ucash_admin.php
Referrer : http://www.seriosgaming.com/admincp/...=pointsenmasse
IP Address :
Username :
Classname :

Gio~Logist 02-05-2006 11:10 PM

Quote:

Originally Posted by eNforce
When trying to use the 'Give Points in Mass' feature:

Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE user SET ucash=ucash+posts*0.05 WHERE (usergroupid IN ('6') OR '6' IN (membergroupids)) AND Array[\'ucash_pointsfield\' '';

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 '[\'ucash_pointsfield\' ''' at line 1
Error Number : 1064
Date : Sunday, February 5th 2006 @ 08:04:49 PM
Script : http://www.seriosgaming.com/admincp/ucash_admin.php
Referrer : http://www.seriosgaming.com/admincp/...=pointsenmasse
IP Address :
Username :
Classname :

Just tested the function and it works fine. Try redoing it. Perhaps you typed something in wrong.

ThePimp 02-05-2006 11:13 PM

Points don't seem to be showing in the postbit or memberinfo. Any ideas?

eNforce 02-05-2006 11:15 PM

Quote:

Originally Posted by ThePimp
Points don't seem to be showing in the postbit or memberinfo. Any ideas?

Yeah same here, was just going to post this.

Even after giving everyone points.

Gio~Logist 02-05-2006 11:16 PM

Quote:

Originally Posted by ThePimp
Points don't seem to be showing in the postbit or memberinfo. Any ideas?

Make sure you edited the right style ;)

ThePimp 02-05-2006 11:17 PM

Quote:

Originally Posted by gio~logist
Make sure you edited the right style ;)

I only have one style.
I wonder if it has to do with "Points Table?" in Ucash Settings? What table is "points" stored in?

All it shows is: Points: (Donate) in the postbit legacy.

NuclioN 02-05-2006 11:18 PM

I've noticed that admins can not see the points in postbit_legacy

Gio~Logist 02-05-2006 11:22 PM

Quote:

Originally Posted by ThePimp
I only have one style.
I wonder if it has to do with "Points Table?" in Ucash Settings? What table is "points" stored in?

All it shows is: Points: (Donate) in the postbit legacy.

User table i believe.

ThePimp 02-05-2006 11:24 PM

Quote:

Originally Posted by gio~logist
User table i believe.

Mine's using a prefix of vb3_user <-- Should I change to this?

Also, I don't see an actual "points" column in vb3_user, or nothing similar.

Gio~Logist 02-05-2006 11:24 PM

Does it show points in richest members?

Gio~Logist 02-05-2006 11:25 PM

Quote:

Originally Posted by ThePimp
Mine's using a prefix of vb3_user <-- Should I change to this?

Also, I don't see an actual "points" column in vb3_user, or nothing similar.

There's a "ucash" column

ThePimp 02-05-2006 11:25 PM

Quote:

Originally Posted by gio~logist
Does it show points in richest members?

As far as I can see, nobody has any points yet. I've done a few test posts, and so have others. Nothing as of yet.

ThePimp 02-05-2006 11:26 PM

Quote:

Originally Posted by gio~logist
There's a "ucash" column

Yes, I see that. Thus far, 0.00 across the board. No points for anyone. They must not be worthy. heh

NuclioN 02-05-2006 11:27 PM

Quote:

Originally Posted by gio~logist
Does it show points in richest members?

No i've looked that also. It's showing no points in all sections of the store

maroulis 02-05-2006 11:29 PM

I can see points at uStore but at Postbit Legacy which I'm using doesn't show any $ just donate in brackets.

Bluestrike2 02-05-2006 11:30 PM

I installed the original zip during the first half :(.

Anyhow, I got this error:

Code:

Database error in vBulletin 3.5.3:

Invalid SQL:
ALTER TABLE forum
        ADD `ucash_perthread` varchar(20) NOT NULL default '',
        ADD `ucash_perreply` varchar(20) NOT NULL default '',
        ADD `ucash_perview` varchar(20) NOT NULL default '',
        ADD `ucash_perdownload` varchar(20) NOT NULL default '';

MySQL Error  : Duplicate column name 'ucash_perthread'
Error Number : 1060
Date        : Sunday, February 5th 2006 @ 08:29:41 PM
Script      : http://www.mlgteams.com/forum/installer/index.php
Referrer    : http://www.mlgteams.com/forum/installer/index.php
IP Address  : 67.186.45.208
Username    : Bluestrike2
Classname    : vb_database

How would I go about deleting these columns? I just deleted the tables, but don't know what to do here. Thank you for everything!

Gio~Logist 02-05-2006 11:31 PM

Quote:

Originally Posted by Bluestrike2
I installed the original zip during the first half :(.

Anyhow, I got this error:

Code:

Database error in vBulletin 3.5.3:

Invalid SQL:
ALTER TABLE forum
        ADD `ucash_perthread` varchar(20) NOT NULL default '',
        ADD `ucash_perreply` varchar(20) NOT NULL default '',
        ADD `ucash_perview` varchar(20) NOT NULL default '',
        ADD `ucash_perdownload` varchar(20) NOT NULL default '';

MySQL Error  : Duplicate column name 'ucash_perthread'
Error Number : 1060
Date        : Sunday, February 5th 2006 @ 08:29:41 PM
Script      : http://www.mlgteams.com/forum/installer/index.php
Referrer    : http://www.mlgteams.com/forum/installer/index.php
IP Address  : 67.186.45.208
Username    : Bluestrike2
Classname    : vb_database

How would I go about deleting these columns? I just deleted the tables, but don't know what to do here. Thank you for everything!


Look at my post that said how to delete all tables.

Gio~Logist 02-05-2006 11:37 PM

I found the error guys.

Re upload this product and overwrite.


All times are GMT. The time now is 09:34 AM.

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.04795 seconds
  • Memory Usage 1,843KB
  • 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
  • (6)bbcode_code_printable
  • (22)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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