vb.org Archive - Major Additions - Point Market System 3.1x

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)

Alright, I got the link working but I can't figure out how to modify the permissions. Even I can't access the market.

Quote:

Originally Posted by worldwidereefer (Post 2006568)

how do you know who won the lottery ticket ?

there is no notification or nothing ?......

Is there a way ?

I haven't been able to figure this out myself :)

For whatever reason I never scripted it for the 2x series soooo this morning I added that feature. :)

2.1.0 is officially released to you guys for using. This is the first time I haven't introduced any new market items; however, there are still many new features (Mostly Administrative). In addition, there are about a dozen bugs that are moderate to severe that have been addressed. I strongly encourage everyone to upgrade to a much more stable Point Market.

Everytime I try to edit something, I get this:

You currently do not have permissions to access this page.

In order to gain access to this page, please have a Super Administrator setup access for your account in the Settings & Staff Permissions page within the Administrative Control Panel.

You need to have a Super Administrator (defined in config.php in the includes folder) go to the Settings & Staff Permissions page in the Admin CP. They need to add an admin to the market permissions and setup what admin has what access. :) As you can tell after you visit that page, you have far more control over what Admins can and cannot do in comparison to before.

Quote:

Invalid SQL:
SELECT * FROM market_transactions AS mt CROSS JOIN ( SELECT marketid, COUNT(*) AS cnt FROM market_transactions GROUP BY marketid ORDER BY cnt DESC LIMIT 1) AS sq USING (marketid);

MySQL Error : Table 'inv4.market_transactions' doesn't exist
Error Number : 1146
Request Date : Sunday, May 16th 2010 @ 10:04:07 PM
Error Date : Sunday, May 16th 2010 @ 10:04:07 PM
Script : xxxxxxxxxxxxxxx/forum/market.php
Referrer : xxxxxxxxxxxxxxxxx/forum/forum.php
IP Address : xxxxxxxxxxxxxxx
Username : MKZ23
Classname : vB_Database
MySQL Version : 4.1.20

my table prefix is VB,inv4 is the db name,I'm not sure if its using the db name as a prefix or just not using the vb prefix but the table

the table "vbmarket_transactions" exists,any ideas of how I can quick fix this by making it look for the correct table.

btw the product looks great,I havent used it yet but I'm determined this is what I'll be using for my forum,thx

P.S. I took a look at the new main market.php file and noticed that "TABLE_PREFIX ." is missing where it used to be regarding fetching from the market_transactions table but I dont wanna go trying to fix something I know very little about

Just upgraded to 2.1 and everything seems to be going fine, thank you for your work :D

Quote:

Originally Posted by Bigj85 (Post 2038140)

deleted all the old files,uninstalled and installed 2.1.0

everything went fine with setting it up,doing permissions etc.
but then when I try to go to the market I get this error Database error in vBulletin 4.0.3:

my table prefix is VB,inv4 is the db name,I'm not sure if its using the db name as a prefix or just not using the vb prefix but the table

the table "vbmarket_transactions" exists,any ideas of how I can quick fix this by making it look for the correct table.

btw the product looks great,I havent used it yet but I'm determined this is what I'll be using for my forum,thx

P.S. I took a look at the new main market.php file and noticed that "TABLE_PREFIX ." is missing where it used to be regarding fetching from the market_transactions table but I dont wanna go trying to fix something I know very little about

Redownload the zip I have attached. Upload and overwrite all files and it should fix it. It was caused because your database is using a "vb" in front of all tables and I forgot to add the table prefix functionality to the fixed queries.

you rock man,already playing with the items and it looks great, thx again :)

Nominated!

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02803 seconds Memory Usage 1,747KB 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 (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)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
Messages: