Jump to content


Photo

Web Vending Database (Standalone and FluxCP Addon)

Skill vend fluxcp

  • Please log in to reply
73 replies to this topic

#61 deadzero

deadzero

    Member

  • Members
  • PipPip
  • 12 posts
  • Github:FrosT

Posted 28 December 2015 - 01:11 PM

My flux don't show the item images, someone knows what?

#62 Lavenblade

Lavenblade

    Member

  • Members
  • PipPip
  • 25 posts
  • LocationWashington
  • Emulator:Hercules

Posted 03 March 2016 - 03:49 PM

What's the difference between yours and Yommy's version?



#63 Sanasol

Sanasol

    Advanced Member

  • Members
  • PipPipPip
  • 43 posts
  • LocationSt. Petersburg
  • Github:s-anasol

Posted 03 March 2016 - 04:46 PM

What's the difference between yours and Yommy's version?

just different src.

 

yommy's src plugin for herc

my src for herc/rathena. and not as plugin

 

better use yommy plugin(easier)

and my addon for site

it also support yommy's src

Yommy src versions: Standalone or FluxCP


Edited by Sanasol, 03 March 2016 - 04:47 PM.


#64 Lavenblade

Lavenblade

    Member

  • Members
  • PipPip
  • 25 posts
  • LocationWashington
  • Emulator:Hercules

Posted 04 March 2016 - 01:18 AM

Thank you very much for that information. :)

 

EDIT: What's the difference between your add-on and Yommy's? xD


Edited by Lavenblade, 04 March 2016 - 01:19 AM.


#65 Sanasol

Sanasol

    Advanced Member

  • Members
  • PipPipPip
  • 43 posts
  • LocationSt. Petersburg
  • Github:s-anasol

Posted 04 March 2016 - 09:40 AM

Thank you very much for that information. :)

 

EDIT: What's the difference between your add-on and Yommy's? xD

Yommy have addon for web site? I have no information about it.



#66 Lavenblade

Lavenblade

    Member

  • Members
  • PipPip
  • 25 posts
  • LocationWashington
  • Emulator:Hercules

Posted 04 March 2016 - 04:32 PM

Thank you very much for that information. :)

 

EDIT: What's the difference between your add-on and Yommy's? xD

Yommy have addon for web site? I have no information about it.

I thought that's what this is:

IMZKu4c.png

I assumed you and Yommy both had your own source, standalone, and fluxcp plugin. Maybe I am just misunderstanding. =(

 

EDIT: They all point to different repos on GitHub.


Edited by Lavenblade, 04 March 2016 - 04:33 PM.


#67 Sanasol

Sanasol

    Advanced Member

  • Members
  • PipPipPip
  • 43 posts
  • LocationSt. Petersburg
  • Github:s-anasol

Posted 04 March 2016 - 05:05 PM

 

Thank you very much for that information. :)

 

EDIT: What's the difference between your add-on and Yommy's? xD

Yommy have addon for web site? I have no information about it.

I thought that's what this is:



I assumed you and Yommy both had your own source, standalone, and fluxcp plugin. Maybe I am just misunderstanding. =(

 

EDIT: They all point to different repos on GitHub.

 

yes, you get confused :D

 

I have my variant of source code for server. And fluxcp addon which work with my sources.

 

Yommy coded other variant of source, which work different but doing same function. Then i modified my fluxcp addon for compatibility with Yommy sources.

 

So, yommy's src easier to install coz plugin. Thats why i strongly commend install it(yommy's plugin) and install my fluxcp addon(if you need it on site ofc)

 

I hope now its clear, coz english not my native :D



#68 Lavenblade

Lavenblade

    Member

  • Members
  • PipPip
  • 25 posts
  • LocationWashington
  • Emulator:Hercules

Posted 04 March 2016 - 08:13 PM

Yes, that makes sense I think. So your FlucCP Add-on works backwards compatible with your source patch and Yommy's plugin.

Yommys FluxCP Add-on only works for her plugin, and not your source patch.

So you recommend using your FluxCP Add-on just incase I decide to switch from plugin to patch since it's backwards compatible?



#69 Sanasol

Sanasol

    Advanced Member

  • Members
  • PipPipPip
  • 43 posts
  • LocationSt. Petersburg
  • Github:s-anasol

Posted 04 March 2016 - 08:15 PM

Yes, that makes sense I think. So your FlucCP Add-on works backwards compatible with your source patch and Yommy's plugin.

Yommys FluxCP Add-on only works for her plugin, and not your source patch.

So you recommend using your FluxCP Add-on just incase I decide to switch from plugin to patch since it's backwards compatible?

no you wiil need get other addon version.



#70 Lavenblade

Lavenblade

    Member

  • Members
  • PipPip
  • 25 posts
  • LocationWashington
  • Emulator:Hercules

Posted 04 March 2016 - 10:08 PM

I guess I just don't understand the differences between your Add-on and Yommy's. They have two different links on Github but seem to be the same.



#71 canditw

canditw

    Advanced Member

  • Members
  • PipPipPip
  • 81 posts

Posted 19 April 2016 - 04:57 AM

How do I add the icons for the images? The one for Flux hercules or vending_he



EDIT: Ignore this, I Found it.


Edited by canditw, 19 April 2016 - 04:07 PM.


#72 joaolipinski

joaolipinski

    Member

  • Members
  • PipPip
  • 13 posts

Posted 07 October 2016 - 09:17 PM

excuse revive the topic but I am an error and could not solve

 

ERROR
vending.c: In function ‘vending_closevending’:vending.c:63: error: ‘SQL_ERROR’ undeclared (first use in this function)
vending.c:63: error: (Each undeclared identifier is reported only once
vending.c:63: error: for each function it appears in.)
vending.c:63: error: ‘SQL’ undeclared (first use in this function)
vending.c:64: warning: implicit declaration of function ‘Sql_ShowDebug’
vending.c:64: warning: nested extern declaration of ‘Sql_ShowDebug’
vending.c: In function ‘vending_purchasereq’:
vending.c:205: error: too few arguments to function ‘clif->vendingreport’
vending.c:209: error: ‘SQL_ERROR’ undeclared (first use in this function)
vending.c:209: error: ‘SQL’ undeclared (first use in this function)
vending.c: In function ‘vending_openvending’:
vending.c:336: error: ‘SQL_ERROR’ undeclared (first use in this function)
vending.c:336: error: ‘SQL’ undeclared (first use in this function)

 

 

 

I applied in this source

 

diff --git a/src/map/unit.c b/src/map/unit.cindex 22c7165..9b0aa6a 100644
--- a/src/map/unit.c
+++ b/src/map/unit.c
@@ -2135,6 +2135,9 @@ int unit_remove_map_(struct block_list *bl, clr_type clrtype, const char* file,
                 chat->leavechat(sd,0);
             if(sd->trade_partner)
                 trade->cancel(sd);
+            //vending to db [Sanasol]
+            vending->close(sd);
+            //vending to db [Sanasol]
             buyingstore->close(sd);
             searchstore->close(sd);
             if(sd->state.storage_flag == 1)
diff --git a/src/map/vending.c b/src/map/vending.c
index 2784d46..0f213a2 100644
--- a/src/map/vending.c
+++ b/src/map/vending.c
@@ -37,6 +37,10 @@ void vending_closevending(struct map_session_data* sd) {
     if( sd->state.vending ) {
         sd->state.vending = false;
         clif->closevendingboard(&sd->bl, 0);
+        //vending to db [Sanasol]
+        if( SQL_ERROR == SQL->Query(map->mysql_handle,"delete from `vending` where `char_id`='%d'", sd->status.char_id) )
+        Sql_ShowDebug(map->mysql_handle);
+        //vending to db [Sanasol]
         idb_remove(vending->db, sd->status.char_id);
     }
 }
@@ -174,7 +178,18 @@ void vending_purchasereq(struct map_session_data* sd, int aid, unsigned int uid,
         vsd->vending[vend_list[i]].amount -= amount;
         pc->cart_delitem(vsd, idx, amount, 0, LOG_TYPE_VENDING);
         clif->vendingreport(vsd, idx, amount);
-
+        //vending to db [Sanasol]
+        if(vsd->vending[vend_list[i]].amount >= 1)
+        {
+            if( SQL_ERROR == SQL->Query(map->mysql_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(map->mysql_handle);
+        }
+        else
+        {
+            if( SQL_ERROR == SQL->Query(map->mysql_handle,"delete from `vending` where `char_id`='%d' and `index`='%d'", vsd->status.char_id, vend_list[i]) )
+                Sql_ShowDebug(map->mysql_handle);
+        }
+        //vending to db [Sanasol]
         //print buyer's name
         if( battle_config.buyer_name ) {
             char temp[256];
@@ -281,6 +296,19 @@ void vending_openvending(struct map_session_data* sd, const char* message, const
     safestrncpy(sd->message, message, MESSAGE_SIZE);


     clif->openvending(sd,sd->bl.id,sd->vending);
+     //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(map->mysql_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(map->mysql_handle);
+    }
+    //vending to db [Sanasol]
     clif->showvendingboard(&sd->bl,message,0);
     
     idb_put(vending->db, sd->vender_id, sd);

 


#73 astralprojection

astralprojection

    Advanced Member

  • Members
  • PipPipPip
  • 144 posts

Posted 28 December 2016 - 03:51 AM

excuse revive the topic but I am an error and could not solve

 

ERROR
vending.c: In function ‘vending_closevending’:vending.c:63: error: ‘SQL_ERROR’ undeclared (first use in this function)
vending.c:63: error: (Each undeclared identifier is reported only once
vending.c:63: error: for each function it appears in.)
vending.c:63: error: ‘SQL’ undeclared (first use in this function)
vending.c:64: warning: implicit declaration of function ‘Sql_ShowDebug’
vending.c:64: warning: nested extern declaration of ‘Sql_ShowDebug’
vending.c: In function ‘vending_purchasereq’:
vending.c:205: error: too few arguments to function ‘clif->vendingreport’
vending.c:209: error: ‘SQL_ERROR’ undeclared (first use in this function)
vending.c:209: error: ‘SQL’ undeclared (first use in this function)
vending.c: In function ‘vending_openvending’:
vending.c:336: error: ‘SQL_ERROR’ undeclared (first use in this function)
vending.c:336: error: ‘SQL’ undeclared (first use in this function)

 

 

 

I applied in this source

 

diff --git a/src/map/unit.c b/src/map/unit.cindex 22c7165..9b0aa6a 100644
--- a/src/map/unit.c
+++ b/src/map/unit.c
@@ -2135,6 +2135,9 @@ int unit_remove_map_(struct block_list *bl, clr_type clrtype, const char* file,
                 chat->leavechat(sd,0);
             if(sd->trade_partner)
                 trade->cancel(sd);
+            //vending to db [Sanasol]
+            vending->close(sd);
+            //vending to db [Sanasol]
             buyingstore->close(sd);
             searchstore->close(sd);
             if(sd->state.storage_flag == 1)
diff --git a/src/map/vending.c b/src/map/vending.c
index 2784d46..0f213a2 100644
--- a/src/map/vending.c
+++ b/src/map/vending.c
@@ -37,6 +37,10 @@ void vending_closevending(struct map_session_data* sd) {
     if( sd->state.vending ) {
         sd->state.vending = false;
         clif->closevendingboard(&sd->bl, 0);
+        //vending to db [Sanasol]
+        if( SQL_ERROR == SQL->Query(map->mysql_handle,"delete from `vending` where `char_id`='%d'", sd->status.char_id) )
+        Sql_ShowDebug(map->mysql_handle);
+        //vending to db [Sanasol]
         idb_remove(vending->db, sd->status.char_id);
     }
 }
@@ -174,7 +178,18 @@ void vending_purchasereq(struct map_session_data* sd, int aid, unsigned int uid,
         vsd->vending[vend_list[i]].amount -= amount;
         pc->cart_delitem(vsd, idx, amount, 0, LOG_TYPE_VENDING);
         clif->vendingreport(vsd, idx, amount);
-
+        //vending to db [Sanasol]
+        if(vsd->vending[vend_list[i]].amount >= 1)
+        {
+            if( SQL_ERROR == SQL->Query(map->mysql_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(map->mysql_handle);
+        }
+        else
+        {
+            if( SQL_ERROR == SQL->Query(map->mysql_handle,"delete from `vending` where `char_id`='%d' and `index`='%d'", vsd->status.char_id, vend_list[i]) )
+                Sql_ShowDebug(map->mysql_handle);
+        }
+        //vending to db [Sanasol]
         //print buyer's name
         if( battle_config.buyer_name ) {
             char temp[256];
@@ -281,6 +296,19 @@ void vending_openvending(struct map_session_data* sd, const char* message, const
     safestrncpy(sd->message, message, MESSAGE_SIZE);


     clif->openvending(sd,sd->bl.id,sd->vending);
+     //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(map->mysql_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(map->mysql_handle);
+    }
+    //vending to db [Sanasol]
     clif->showvendingboard(&sd->bl,message,0);
     
     idb_put(vending->db, sd->vender_id, sd);

 

 

add:

#include "common/sql.h"



#74 DevLong

DevLong

    Member

  • Members
  • PipPip
  • 11 posts

Posted 28 December 2016 - 01:50 PM

I'm having the same error when compiling, I already added #include "common/sql.h" to vending.c

 

Sem_t_tulo.png







Also tagged with one or more of these keywords: Skill, vend, fluxcp

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users


This topic has been visited by 686 user(s)