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

Page 100 of 223

« First

100

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)

Aramist

08-11-2010 02:31 AM

Ty u a lot Mayhem!

It fixed the front-end stuff...but now...when i click "store Items" in admin cp...it gives me another mysql error :P....again no prefix

Code:

Database error in vBulletin 4.0.5:



Invalid SQL:

select userid, username from user where userid='1';



MySQL Error   : Table 'mytable.user' doesn't exist

Error Number  : 1146

Request Date  : Wednesday, August 11th 2010 @ 12:27:55 AM

Error Date    : Wednesday, August 11th 2010 @ 12:27:55 AM

Script        : http://www.mysite.com/forum/admincp/market.php?do=store

Referrer      : http://www.mysite.com/forum/admincp/index.php?do=nav

IP Address    : MyIP

Username      : Aramist

Classname     : vB_Database

MySQL Version : 5.0.91-community

Sry for many reports....

ty man

Aramist

08-11-2010 02:49 AM

Me again....

I have solved my last report.

Changing at line 525 and 526 in admincp/market.php:

Code:

$finduser = $db->fetch_array($db->query_read("select userid, username from user where userid='$category[userid]'"));

        $finditem = $db->fetch_array($db->query_read("select name, type from market_store where marketid='$category[marketid]'"));

To:

Code:

$finduser = $db->fetch_array($db->query_read("select userid, username from " . TABLE_PREFIX . "user where userid='$category[userid]'"));

        $finditem = $db->fetch_array($db->query_read("select name, type from " . TABLE_PREFIX . "market_store where marketid='$category[marketid]'"));

I'm not sure if I'm correct, but, in my case, solved the problem.

Ty

TheMayhem

08-11-2010 02:56 AM

Quote:

Originally Posted by Aramist (Post 2081994)

Me again....

I have solved my last report.

Changing at line 525 and 526 in admincp/market.php:

Code:

$finduser = $db->fetch_array($db->query_read("select userid, username from user where userid='$category[userid]'"));

        $finditem = $db->fetch_array($db->query_read("select name, type from market_store where marketid='$category[marketid]'"));

To:

Code:

$finduser = $db->fetch_array($db->query_read("select userid, username from " . TABLE_PREFIX . "user where userid='$category[userid]'"));

        $finditem = $db->fetch_array($db->query_read("select name, type from " . TABLE_PREFIX . "market_store where marketid='$category[marketid]'"));

I'm not sure if I'm correct, but, in my case, solved the problem.

Ty

The way you fixed the error is the correct way, I've already applied both of your findings for the next release. Keep up the good work on finding bugs as I truly believe the next release will be the last before I mark this thing completely stable.

Aramist

08-11-2010 03:07 AM

TY u Man !!!

This Mod is fantástic ! Nominate it !

I'm not sure if there is, but would be great if u create an option, to automatic email an admin when someone buy an store item.

And i don't know if this is a bug, but i bought an store item to test...and the "Top Store Market Items" keep showing "0"....i guess this should show 1 now.....cause is was the only store item bought till the moment.

Best Regards

TheMayhem

08-11-2010 05:06 AM

Quote:

Originally Posted by Aramist (Post 2082000)

TY u Man !!!

This Mod is fant?stic ! Nominate it !

Thank you, it actually already is a current Mod of the Month for this month. :)

Quote:

Originally Posted by Aramist (Post 2082000)

I'm not sure if there is, but would be great if u create an option, to automatic email an admin when someone buy an store item.

There already kind of is. If you go to Settings and Staff Permissions and click on the Point Market: Market Items link. The very first setting asks you for a User ID to send a PM to when a user buys a store item. Now there isn't an option to do an email but it a PM should give you some notification.

Quote:

Originally Posted by Aramist (Post 2082000)

And i don't know if this is a bug, but i bought an store item to test...and the "Top Store Market Items" keep showing "0"....i guess this should show 1 now.....cause is was the only store item bought till the moment.

Best Regards

Yes that was a bug. I'm not sure how it wasn't reported before but I have fixed it for the next release. Good find :)

Combattente

08-11-2010 07:07 AM

Err.. the Gifts still aren't shown below the user's profile in the posts.. :(

Storyteller69

08-11-2010 11:15 AM

Many thanks, absolute great addon.
Just one question: Are there any news about the german translation?

Thanks in advance
Storyteller

Phalynx

08-11-2010 11:32 AM

Quote:

Originally Posted by Storyteller69 (Post 2082108)

Many thanks, absolute great addon.
Just one question: Are there any news about the german translation?

Thanks in advance
Storyteller

It's still in work. There are over 500 phrases, thats much of work.

fly	08-11-2010 12:25 PM

Thank you TheMayhem. We appreciate all your hard, free work. :) I shall be donating again as soon as I can.

You will be missed when the vB community eventually burns you out. :p

TheMayhem

08-11-2010 03:28 PM

Quote:

Originally Posted by Storyteller69 (Post 2082108)

Many thanks, absolute great addon.
Just one question: Are there any news about the german translation?

Thanks in advance
Storyteller

I'm planning on giving permission to a few people to do some language translations. Unfortunately or fortunately, the Point Market is one of the biggest 4x mod in terms of size and data so there is a crap load to translate and make look right. Phalynx is making progress on your german translation.

All times are GMT. The time now is 04:57 AM.

Page 100 of 223

100

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02183 seconds Memory Usage 1,755KB 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 (5)bbcode_code_printable (6)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: