Jump to content
Sign in to follow this  
SweeTs

Offline Shop & Craft [309 Rev]

Recommended Posts


 

Datapack



CREATE TABLE IF NOT EXISTS `character_offline_trade` (
  `charId` int(10) unsigned NOT NULL,
  `time` bigint(13) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `title` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`charId`)
);
CREATE TABLE IF NOT EXISTS `character_offline_trade_items` (
  `charId` int(10) unsigned NOT NULL,
  `item` int(10) unsigned NOT NULL DEFAULT '0',
  `count` bigint(20) unsigned NOT NULL DEFAULT '0',
  `price` bigint(20) unsigned NOT NULL DEFAULT '0'
);

Edited by SweeTs

Share this post


Link to post
Share on other sites

Thank you ! I was looking for this. Tested and working fine without bugs for now.

 

About the sql , simply make sql file:

 

drop table IF EXISTS `character_offline_trade`;
CREATE TABLE `character_offline_trade` (
  `charId` int(11) NOT NULL,
  `time` bigint(20) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `title` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`charId`)
) ;

drop table IF EXISTS `character_offline_trade_items`;
CREATE TABLE `character_offline_trade_items` (
  `charId` int(10) NOT NULL DEFAULT '0',
  `item` int(10) NOT NULL DEFAULT '0',
  `count` int(20) NOT NULL DEFAULT '0',
  `price` int(20) NOT NULL DEFAULT '0'
) ;

 

 

Share this post


Link to post
Share on other sites

Thank you ! I was looking for this. Tested and working fine without bugs for now.

 

About the sql , simply make sql file:

 

drop table IF EXISTS `character_offline_trade`;
CREATE TABLE `character_offline_trade` (
  `charId` int(11) NOT NULL,
  `time` bigint(20) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `title` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`charId`)
) ;

drop table IF EXISTS `character_offline_trade_items`;
CREATE TABLE `character_offline_trade_items` (
  `charId` int(10) NOT NULL DEFAULT '0',
  `item` int(10) NOT NULL DEFAULT '0',
  `count` int(20) NOT NULL DEFAULT '0',
  `price` int(20) NOT NULL DEFAULT '0'
) ;

 

 

 

thank you man

Share this post


Link to post
Share on other sites

Why I can not make /packagesale ?

Thank you for response !

 

Kinda late, but meh :troll:

 

What you mean by that ? Since there is no such command on IL.

Edited by SweeTs

Share this post


Link to post
Share on other sites

Kinda late, but meh :troll:

 

What you mean by that ? Since there is no such command on IL.

There is SweeTs. Just saw it :).

While making a private store ( /vendor | SELL ), there is a little box "Package Sale" which you have to Check.

And bum, Package Sale Offline Mode.

I was surprised, been Searching and Searching and nothing.

Share this post


Link to post
Share on other sites

Yes, there is a box, but not a command :D

 

So, you get error when checking package sell, or it's not goin' offline mode? Since I dont get it :P

Edited by SweeTs

Share this post


Link to post
Share on other sites

Yes, there is a box, but not a command :D

 

So, you get error when checking package sell, or it's not goin' offline mode? Since I dont get it :P

No, your job is awesome, honestly.

I was looking for the Package Sale option, to test if it works in Offline Mode. And I was looking by ALT+C and I did not find it. That is when I made that post to ask you about Package Sale.

After that I saw the little box :).

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.



×