HristDead Posted August 26, 2013 Posted August 26, 2013 Updated. still error but less error now! [26-Aug-2013 03:59:32 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 11 [26-Aug-2013 04:01:58 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 11 [26-Aug-2013 04:02:00 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 11 [26-Aug-2013 04:10:36 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 11 [26-Aug-2013 04:10:39 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 11 [26-Aug-2013 04:13:07 America/Los_Angeles] PHP Warning: require(/home/server/public_html/merch/class.db.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 04:13:07 America/Los_Angeles] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required '/home/server/public_html/merch/class.db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/server/public_html/merchant_db/config.php on line 8 [26-Aug-2013 04:20:15 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 11 Quote
Sanasol Posted August 26, 2013 Author Posted August 26, 2013 script still can't find class.db.php config file check line 8 now must be require("class.db.php"); Quote
HristDead Posted August 26, 2013 Posted August 26, 2013 Thanks sanasol, it only gives me 1 error now on this line: $db->setErrorCallbackFunction("print_r", "text"); [26-Aug-2013 04:46:52 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 11 Quote
Sanasol Posted August 26, 2013 Author Posted August 26, 2013 $db = new db("mysql:host={$host};dbname={$dbname}", $user, $pass); var_dump($db); $db->setErrorCallbackFunction("print_r", "text"); do this in config and post what it will show... Quote
HristDead Posted August 26, 2013 Posted August 26, 2013 The page (www.----.com/merchant_db) now says "NULL". [26-Aug-2013 05:51:00 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 10 [26-Aug-2013 05:51:01 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 10 [26-Aug-2013 05:51:02 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 10 [26-Aug-2013 05:51:03 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 10 [26-Aug-2013 05:51:04 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 10 [26-Aug-2013 05:51:04 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 10 [26-Aug-2013 05:52:39 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 10 [26-Aug-2013 05:55:06 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 10 [26-Aug-2013 07:56:06 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 10 [26-Aug-2013 11:49:40 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 12 [26-Aug-2013 11:49:45 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 12 [26-Aug-2013 11:50:32 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 12 [26-Aug-2013 11:50:32 America/Los_Angeles] PHP Fatal error: Call to a member function setErrorCallbackFunction() on a non-object in /home/server/public_html/merchant_db/config.php on line 12 Quote
Sanasol Posted August 26, 2013 Author Posted August 26, 2013 script can't define db class. I don't know why... class.db.php in a folder? maybe try to change require path require($_SERVER['DOCUMENT_ROOT']."/merchant_db/class.db.php"); require($_SERVER['DOCUMENT_ROOT']."/merchant_db/Paginator.class.php"); Quote
Sanasol Posted August 26, 2013 Author Posted August 26, 2013 open class.db.php try { parent::__construct($dsn, $user, $passwd, $options); } catch (PDOException $e) { $this->error = $e->getMessage(); } add debug var_dump($e->getMessage()); try { parent::__construct($dsn, $user, $passwd, $options); } catch (PDOException $e) { var_dump($e->getMessage()); $this->error = $e->getMessage(); } Quote
HristDead Posted August 26, 2013 Posted August 26, 2013 did that, now it says this string(105) "SQLSTATE[28000] [1045] Access denied for user 'root'@'us10.la.thewebhostserver.com' (using password: YES)" NULL Quote
Sanasol Posted August 26, 2013 Author Posted August 26, 2013 can't connect to mysql... password wrong or something else. Change this to ur DB Host, DB user and DB name $host = "localhost"; $dbname = "san"; $user = "root"; $pass = "root"; Flux fix named item Flux fix refine array https://github.com/S-anasol/sanasol/commit/ed5d5ef1ce0f6481be1da7dda082ece16a44766d Quote
HristDead Posted August 26, 2013 Posted August 26, 2013 that is weird. i put the correct info. x.x do i need to request my host to open certain ports? Quote
Sanasol Posted August 26, 2013 Author Posted August 26, 2013 no, maybe ur mysql user can login only from localhost(if site stands separately from server), then you need add user perms for site ip i.e. root@us10.la.thewebhostserver.com Quote
Sanasol Posted August 29, 2013 Author Posted August 29, 2013 (edited) Added Demo and FluxCP demo re-uploaded attach with latest fixes Edited August 29, 2013 by Sanasol Quote
Sanasol Posted September 1, 2013 Author Posted September 1, 2013 Some fixes for both versions. FluxCP my and Yommy src Standalone my and Yommy src Thank RagnaOk for providing the veeery big data to detect bugs: http://ragnaok.net/vending_database/ Quote
Talaysen Posted September 25, 2013 Posted September 25, 2013 When I mouse over the map, nothing appears. Is that strictly part of this addon, or am I missing something from my FluxCP? Quote
Sanasol Posted September 25, 2013 Author Posted September 25, 2013 Check browser console(F12 in Chrome) any errors? Quote
Talaysen Posted September 25, 2013 Posted September 25, 2013 I didn't see anything that seemed to be related to the vending addon. Only error I saw seemed to have something to do with the rotational screenshot module on the bottom of the page. http://nymphro.com/?module=vending I made a 'test' account: Account: Test Password: Aa123456 Quote
Sanasol Posted September 25, 2013 Author Posted September 25, 2013 I think your php has short codes disabled change this line https://github.com/S-anasol/sanasol/blob/master/merchant_db_flux/vending/themes/default/vending/index.php#L103 to <span class='mapinfo' data-map='<?php echo $char->last_map?>' data-x='<?php echo $char->last_x?>' data-y='<?php echo $char->last_y?>'><?php echo htmlspecialchars($char->last_map)." ".htmlspecialchars($char->last_x).",".htmlspecialchars($char->last_y) ?></span> Quote
Break Posted September 28, 2013 Posted September 28, 2013 You do not want to modify the code so that a click on item page would lead to the corresponding page poring.ru base in a new window? Quote
Sanasol Posted September 28, 2013 Author Posted September 28, 2013 Серьезно? Совсем рук нету? <td>{$nick}{$vvs}<a href=\"http://www.poring.ru/items/{$row->nameid}.html\" target=\"_blank\">{$item}</a></td> 1 Quote
Limestone Posted October 5, 2013 Posted October 5, 2013 Where Source inserting shop info into database. Few source lines and a little bit of magic php + jsDecorated with new Twitter Bootstrap Remake of this http://www.eathena.ws/board/index.php?showtopic=255406 Installation /src/map/vending.c Function: vending_closevending After clif_closevendingboard(&sd->bl, 0); Add //vending to db [Sanasol] if( SQL_ERROR == Sql_Query(mmysql_handle,"delete from `vending` where `char_id`='%d'", sd->status.char_id) ) Sql_ShowDebug(mmysql_handle); //vending to db [Sanasol] Function: vending_purchasereq After // vending item pc_additem(sd, &vsd->status.cart[idx], amount, LOG_TYPE_VENDING); vsd->vending[vend_list[i]].amount -= amount; pc_cart_delitem(vsd, idx, amount, 0, LOG_TYPE_VENDING); clif_vendingreport(vsd, idx, amount); Add //vending to db [Sanasol] if(vsd->vending[vend_list[i]].amount >= 1) { if( SQL_ERROR == Sql_Query(mmysql_handle,"update `vending` set `amount`='%d' where `char_id`='%d' and `index`='%d'", vsd->vending[vend_list[i]].amount, vsd->status.char_id, vend_list[i]) ) Sql_ShowDebug(mmysql_handle); } else { if( SQL_ERROR == Sql_Query(mmysql_handle,"delete from `vending` where `char_id`='%d' and `index`='%d'", vsd->status.char_id, vend_list[i]) ) Sql_ShowDebug(mmysql_handle); } //vending to db [Sanasol] Function: vending_openvending After clif_openvending(sd,sd->bl.id,sd->vending); Add //vending to db [Sanasol] for( j = 0; j < count; j++ ) { int index = sd->vending[j].index; struct item_data* data = itemdb_search(sd->status.cart[index].nameid); int nameid = ( data->view_id > 0 ) ? data->view_id : sd->status.cart[index].nameid; int amount = sd->vending[j].amount; int price = cap_value(sd->vending[j].value, 0, (unsigned int)battle_config.vending_max_value); if( SQL_ERROR == Sql_Query(mmysql_handle,"INSERT INTO `vending` (`char_id`,`name`,`index`,`nameid`,`amount`,`price`,`refine`,`card0`,`card1`,`card2`,`card3`) VALUES (%d, '%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d')", sd->status.char_id, message, j, nameid, amount, price, sd->status.cart[index].refine, sd->status.cart[index].card[0], sd->status.cart[index].card[1], sd->status.cart[index].card[2], sd->status.cart[index].card[3]) ) Sql_ShowDebug(mmysql_handle); } //vending to db [Sanasol] /src/map/unit.c After case BL_PC: { struct map_session_data *sd = (struct map_session_data*)bl; if(sd->shadowform_id){ //if shadow target has leave the map struct block_list *d_bl = map_id2bl(sd->shadowform_id); if( d_bl ) status_change_end(d_bl,SC__SHADOWFORM,INVALID_TIMER); } //Leave/reject all invitations. if(sd->chatID) chat_leavechat(sd,0); if(sd->trade_partner) trade_tradecancel(sd); Add //vending to db [Sanasol] vending_closevending(sd); //vending to db [Sanasol] Create table CREATE TABLE IF NOT EXISTS `vending` ( `char_id` int(11) unsigned NOT NULL DEFAULT '0', `name` varchar(50) DEFAULT NULL, `index` tinyint(3) unsigned NOT NULL DEFAULT '0', `nameid` int(11) unsigned NOT NULL DEFAULT '0', `amount` int(11) unsigned NOT NULL DEFAULT '0', `price` bigint(20) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `card0` smallint(11) NOT NULL DEFAULT '0', `card1` smallint(11) NOT NULL DEFAULT '0', `card2` smallint(11) NOT NULL DEFAULT '0', `card3` smallint(11) NOT NULL DEFAULT '0', PRIMARY KEY (`char_id`,`index`), KEY `char_id` (`char_id`), KEY `nameid` (`nameid`) ) ENGINE=MyISAM; Screenshots Main page Map position tooltip For map showing need *.gat files Approximate position, accurate display at map could not to achieve And Search Item images very old, you need to add the new items FluxCP Screens [spoiler=Main Vending DB] [spoiler=Search] [spoiler=Map] Demo FluxCP Demo Sources Sources Sources FluxCP Addon Sources is absolutely free, but if you want you can do donation In attach web scripts with items images where to install the merchant_db.rar? Quote
Sanasol Posted October 5, 2013 Author Posted October 5, 2013 For flux you should upload this folder https://github.com/S-anasol/sanasol/tree/master/merchant_db_flux to fluxcp/addons/ Quote
Vincent Posted October 21, 2013 Posted October 21, 2013 (edited) error 1: error2: The Shopname and Charname are switched. An one are empty. Whats the prob? Edited October 23, 2013 by Vincent Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.