Simple MYSQL database addition.

  • Posts: 11
  • Thank you received: 0
11 years 11 months ago #80737

On my website, it is possible to collect rewards by doing activities on the website.

Case scenario:
1. You vote on a website.
2. You get to pick a reward on the website.
3. The reward gets added to a mysql database.
4. You can collect the reward on the game.

What i need:
1. You buy an item in the shop.
2. The item gets added to the mysql database. (by an ID number + player name)
3. You can collect the item in game.

If i buy Hikaserial, can i get any support adding this?
I will provide the php files from the case scenario, which should make it fairly easy.

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
11 years 11 months ago #80767

Hi,

In which table do you want to add this data ?
It is possible thanks to a custom generator plugin to generate serials with your format "ID number + player name".
The basic process would store this data directly in an hikaserial table. It would be possible for the generator plugin to manually insert the data into another table.

With more information we would be able to give you more help for your project.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 11
  • Thank you received: 0
11 years 11 months ago #81449

I will upload the files i am using for my voting system.

you can test my voting system here:
home.rijnderscms.nl/vote.html

Here are the voting PHP and mysql files:
play.rijnderscms.nl/downloads/myvote.zip

Once you are hosting the PHP files, and you go 2 the website the first time,
it will make you set up the MYSQl DATABASE.
If it asks for an GTL toplist password just enter something random.

Also in the voting system in the end, it will ask you to enter your name in my game,
i would also like this to be added to the checkout, so it adds the name to the database.

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
11 years 11 months ago #81730

Hi,

I still don't understand nothing on what you want to do.
HikaSerial is a unique data generator for HikaShop. You can create generator plugin which could do a lot of things during the generation like, adding some data in another tables.
But HikaSerial has been design to work with HikaShop triggers (thanks to the bridge plugin "hikashop serials").

After that, the other checkout process are HikaShop integration, not HikaSerial.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 11
  • Thank you received: 0
11 years 11 months ago #81957

I want it to add data in a new table, the product ID + a filled in extra field.
That's all.

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
11 years 11 months ago #81959

Hi,

So the best solution is to implement a little custom plugin which would trigger the event onAfterOrderUpdate in order to check the order confirmation, load the full order, check all products in the order and add the data in your specific table.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Moderators: Obsidev
Time to create page: 0.066 seconds
Powered by Kunena Forum