How To

More
1 month 2 weeks ago - 4 days 13 hours ago #30 by Nightwolf
How To was created by Nightwolf

Part of the message is hidden for the guests. Please log in or register to see it.

login here: itopz.com/login

This message has attachments images.
Please log in or register to see it.

Last edit: 4 days 13 hours ago by Nightwolf.
The following user(s) said Thank You: Juvenil

Please Log in to join the conversation.

More
4 days 13 hours ago - 4 days 13 hours ago #74 by Nightwolf
Replied by Nightwolf on topic How To
Step 2 Create MySQL Table

First open the database of your server

Make new query

Execute the query

Go again in Table View

Dont save just go for Table View

Press F5 to refresh and voila donate_holder is there


Code
CREATE TABLE `donate_holder` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `id` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `playername` varchar(255) CHARACTER SET utf8 NOT NULL,
  `order_status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`no`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=latin1;

Part of the message is hidden for the guests. Please log in or register to see it.

login here: itopz.com/login/

This message has attachments images.
Please log in or register to see it.

This message has an attachment file.
Please log in or register to see it.

Last edit: 4 days 13 hours ago by Nightwolf.

Please Log in to join the conversation.

More
4 days 11 hours ago - 4 days 11 hours ago #76 by Nightwolf
Replied by Nightwolf on topic How To
Step 3 Create Database USER with specifically strict privileges for max security.

Open your server database

Now that we selected/opened the database click on the user

Simply click new user to add a new user

Set your username, allowed access host (pon%.cpe.hcn.%) and password

Click save and go to server privileges click on select/insert

Click on add privilege and select database and table with select/insert

How to find the donate_holder table and add privileges

Check donate_holder table and add select/insert

Save and go to add in donate panel the new user information


Images in normal resolution and 100% quality


login here: itopz.com/login/

This message has attachments images.
Please log in or register to see it.

This message has an attachment file.
Please log in or register to see it.

Last edit: 4 days 11 hours ago by Nightwolf.

Please Log in to join the conversation.

More
4 days 11 hours ago #77 by Nightwolf
Replied by Nightwolf on topic How To
Final Step 4 add a task that will check the table donate_holder for new donations and if a new donation found reward it to the player

Server Setup (JAVA)
Server side code: github.com/nightw0lv/DonatePanel

Please Log in to join the conversation.

Time to create page: 0.211 seconds
Powered by Kunena Forum