How To
3 years 10 months ago - 3 years 9 months ago #30
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.
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: 3 years 9 months ago by Nightwolf.
The following user(s) said Thank You: Juvenil
Please Log in to join the conversation.
3 years 9 months ago - 3 years 9 months ago #74
by Nightwolf
This message has attachments images.
This message has an attachment file.
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
Part of the message is hidden for the guests. Please log in or register to see it.
login here: itopz.com/login/
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: 3 years 9 months ago by Nightwolf.
Please Log in to join the conversation.
3 years 9 months ago - 2 years 1 month ago #76
by Nightwolf
This message has attachments images.
This message has an attachment file.
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/
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: 2 years 1 month ago by Nightwolf.
Please Log in to join the conversation.
3 years 9 months ago #77
by Nightwolf
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
Server Setup (JAVA)
Server side code: github.com/nightw0lv/DonatePanel
Please Log in to join the conversation.
Time to create page: 0.805 seconds
- You are here:
-
Home
-
Forum
-
Main Forum
-
Donate Panel (FREE)
- How To