|
You last visited: Today at 21:21
Advertisement
[RELEASE]Naturalion Point System
Discussion on [RELEASE]Naturalion Point System within the Metin2 PServer Guides & Strategies forum part of the Metin2 Private Server category.
03/10/2013, 10:15
|
#1
|
elite*gold: 0 
Join Date: Mar 2013
Posts: 154
Received Thanks: 507
|
[RELEASE]Naturalion Point System
#Sql
PHP Code:
/*
Navicat MySQL Data Transfer
Source Server : HaveBeen™
Source Server Version : 50095
Source Host : ---
Source Database : player
Target Server Type : MYSQL
Target Server Version : 50095
File Encoding : 65001
Date: 2013-03-10 11:02:58
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `naturalion`
-- ----------------------------
DROP TABLE IF EXISTS `naturalion`;
CREATE TABLE `naturalion` (
`id` int(50) NOT NULL,
`name` varchar(24) NOT NULL,
`naturalionpoint` int(40) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of naturalion
-- ----------------------------
#Quest ;
PHP Code:
--[[
-- Naturalion Point System
-- Quest Writer By : HaveBeen™
]]--
quest naturalion begin
state start begin
function kill()
-- Get Vid
local vid = npc.get_vid()
local a = pc.select(vid)
local name,point = pc.get_name(),game.get_event_flag(pc.get_name().."_point")
pc.select(a)
if(point > 5) then
game.set_event_flag(pc.get_name().."_point",game.get_event_flag(pc.get_name().."_point")+math.floor(point/2))
mysql_query("Update player.naturalion set naturalionpoint = '"..game.get_event_flag(pc.get_name().."_point").."' WHERE name = '"..pc.get_name().."' ")
local b = pc.select(vid)
game.set_event_flag(pc.get_name().."_point",game.get_event_flag(pc.get_name().."_point")-math.floor(game.get_event_flag(pc.get_name().."_point")/2))
mysql_query("Update player.naturalion set naturalionpoint = '"..game.get_event_flag(pc.get_name().."_point").."' WHERE name = '"..pc.get_name().."' ")
pc.select(b)
chat(name.." Got Half The Score ")
chat(" Now Points : : "..game.get_event_flag(pc.get_name().."_point"))
elseif(point >= 1 and point <= 3 or point < 0) then
game.set_event_flag(pc.get_name().."_point",game.get_event_flag(pc.get_name().."_point")+1)
mysql_query("Update player.naturalion set naturalionpoint = '"..game.get_event_flag(pc.get_name().."_point").."' WHERE name = '"..pc.get_name().."' ")
local c = pc.select(vid)
game.set_event_flag(pc.get_name().."_point",game.get_event_flag(pc.get_name().."_point")-1)
mysql_query("Update player.naturalion set naturalionpoint = '"..game.get_event_flag(pc.get_name().."_point").."' WHERE name = '"..pc.get_name().."' ")
pc.select(c)
chat(name.." Get Points ")
chat(" Now Points : : "..game.get_event_flag(pc.get_name().."_point"))
end
end
function Rank()
say_title("Naturalion Point System Rank: ")
say("")
---
local query = mysql_query("SELECT * FROM player.naturalion ORDER BY naturalionpoint desc limit 10")
maxs = table.getn(query)
i = 0
repeat
i = i + 1
say(i..". "..query.name[i].." "..query.naturalionpoint[i])
until i == maxs
end
when login with game.get_event_flag(pc.get_name().."_point") == 0 and pc.getqf("naturalion") != 1 begin
pc.setqf("naturalion",1)
game.set_event_flag(pc.get_name().."_point",game.get_event_flag(pc.get_name().."_point")+2)
mysql_query("INSERT INTO player.naturalion VALUES ('"..pc.get_player_id().."','"..pc.get_name().."','"..game.get_event_flag(pc.get_name().."_point").."' ) ")
end
when kill with npc.is_pc() begin
naturalion.kill()
end
end
end
Mysql Screen ;
King Regards
Mfg HaveBeen™
|
|
|
|
03/10/2013, 10:56
|
#2
|
elite*gold: 0
Join Date: Apr 2012
Posts: 89
Received Thanks: 25
|
Good work bro..
|
|
|
|
|
03/10/2013, 10:58
|
#3
|
elite*gold: 15
Join Date: Sep 2010
Posts: 844
Received Thanks: 975
|
you really want to update via sql all 0.5 seconds? xD
|
|
|
|
|
03/10/2013, 11:24
|
#4
|
elite*gold: 0
Join Date: Apr 2010
Posts: 69
Received Thanks: 34
|
thanks man
|
|
|
|
|
03/10/2013, 14:36
|
#5
|
elite*gold: 0
Join Date: Mar 2013
Posts: 154
Received Thanks: 507
|
Quote:
Originally Posted by Sp0ngeb0b ist cool
you really want to update via sql all 0.5 seconds? xD
|
Look Again 
|
|
|
|
|
03/10/2013, 15:25
|
#6
|
elite*gold: 15
Join Date: Sep 2010
Posts: 844
Received Thanks: 975
|
Quote:
Originally Posted by HaveBeen™
Look Again |
lol? you changed the quest after my comment
|
|
|
|
|
03/10/2013, 15:42
|
#7
|
elite*gold: 0
Join Date: Jun 2011
Posts: 60
Received Thanks: 10
|
niceeee
Quote:
Originally Posted by HaveBeen™
#Sql
PHP Code:
/*
Navicat MySQL Data Transfer
Source Server : HaveBeen™
Source Server Version : 50095
Source Host : ---
Source Database : player
Target Server Type : MYSQL
Target Server Version : 50095
File Encoding : 65001
Date: 2013-03-10 11:02:58
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `naturalion`
-- ----------------------------
DROP TABLE IF EXISTS `naturalion`;
CREATE TABLE `naturalion` (
`id` int(50) NOT NULL,
`name` varchar(24) NOT NULL,
`naturalionpoint` int(40) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of naturalion
-- ----------------------------
#Quest ;
PHP Code:
--[[
-- Naturalion Point System
-- Quest Writer By : HaveBeen™
]]--
quest naturalion begin
state start begin
function kill()
-- Get Vid
local vid = npc.get_vid()
local a = pc.select(vid)
local name,point = pc.get_name(),game.get_event_flag(pc.get_name().."_point")
pc.select(a)
if(point > 5) then
game.set_event_flag(pc.get_name().."_point",game.get_event_flag(pc.get_name().."_point")+math.floor(point/2))
mysql_query("Update player.naturalion set naturalionpoint = '"..game.get_event_flag(pc.get_name().."_point").."' WHERE name = '"..pc.get_name().."' ")
local b = pc.select(vid)
game.set_event_flag(pc.get_name().."_point",game.get_event_flag(pc.get_name().."_point")-math.floor(game.get_event_flag(pc.get_name().."_point")/2))
mysql_query("Update player.naturalion set naturalionpoint = '"..game.get_event_flag(pc.get_name().."_point").."' WHERE name = '"..pc.get_name().."' ")
pc.select(b)
chat(name.." Got Half The Score ")
chat(" Now Points : : "..game.get_event_flag(pc.get_name().."_point"))
elseif(point >= 1 and point <= 3 or point < 0) then
game.set_event_flag(pc.get_name().."_point",game.get_event_flag(pc.get_name().."_point")+1)
mysql_query("Update player.naturalion set naturalionpoint = '"..game.get_event_flag(pc.get_name().."_point").."' WHERE name = '"..pc.get_name().."' ")
local c = pc.select(vid)
game.set_event_flag(pc.get_name().."_point",game.get_event_flag(pc.get_name().."_point")-1)
mysql_query("Update player.naturalion set naturalionpoint = '"..game.get_event_flag(pc.get_name().."_point").."' WHERE name = '"..pc.get_name().."' ")
pc.select(c)
chat(name.." Get Points ")
chat(" Now Points : : "..game.get_event_flag(pc.get_name().."_point"))
end
end
function Rank()
say_title("Naturalion Point System Rank: ")
say("")
---
local query = mysql_query("SELECT * FROM player.naturalion ORDER BY naturalionpoint desc limit 10")
maxs = table.getn(query)
i = 0
repeat
i = i + 1
say(i..". "..query.name[i].." "..query.naturalionpoint[i])
until i == maxs
end
when login with game.get_event_flag(pc.get_name().."_point") == 0 and pc.getqf("naturalion") != 1 begin
pc.setqf("naturalion",1)
game.set_event_flag(pc.get_name().."_point",game.get_event_flag(pc.get_name().."_point")+2)
mysql_query("INSERT INTO player.naturalion VALUES ('"..pc.get_player_id().."','"..pc.get_name().."','"..game.get_event_flag(pc.get_name().."_point").."' ) ")
end
when kill with npc.is_pc() begin
naturalion.kill()
end
end
end
Mysql Screen ;
King Regards
Mfg HaveBeen™
|
|
|
|
|
|
03/10/2013, 16:13
|
#8
|
elite*gold: 0
Join Date: Mar 2013
Posts: 154
Received Thanks: 507
|
Quote:
Originally Posted by Sp0ngeb0b ist cool
lol? you changed the quest after my comment |
maybe 
|
|
|
|
|
09/05/2015, 16:32
|
#9
|
elite*gold: 0
Join Date: Nov 2013
Posts: 26
Received Thanks: 1
|
what is the naturalion point system
i don't know what you meen :x
|
|
|
|
|
09/10/2015, 09:01
|
#10
|
elite*gold: 0
Join Date: Sep 2014
Posts: 44
Received Thanks: 5
|
40k game work ?
|
|
|
|
|
09/11/2015, 14:02
|
#11
|
elite*gold: 1810
Join Date: Jan 2012
Posts: 2,180
Received Thanks: 1,617
|
Quote:
Originally Posted by Bekir Akdemir
40k game work ?
|
You need a SQL and lua, it's simple to include it.
|
|
|
|
 |
Similar Threads
|
Automatic sale system of TQ Point Cards by krisswoj.com (PayPal)
05/18/2014 - Conquer Online 2 Trading - 170 Replies
Automatic sale system working again!
http://krisswoj.com/style/krisswoj_logo.gif
Read it - Before you are going to buy somewhere that you don’t know!
---------------------------------
Hello dear players!
|
Crystal Online # 80 Cap # Only Chinese # Job War Point System #
12/14/2012 - SRO PServer Advertising - 52 Replies
http://d1212.hizliresim.com/14/c/gtm9h.png
General
WebSite : Crystal Online - The best of the best !
Facebook Page : Crystal Online | Facebook
Method of Payment : PayPal , Bank Account
|
BlackPearl Online # 110-120 Cap Servers # New Skills # New Point System
07/04/2012 - SRO PServer Advertising - 90 Replies
http://i1059.photobucket.com/albums/t438/GM_Shine/ bp_logo.png
Infinity(110 Cap)
Server Information :
~Files : Old vSro Files
~Start Level : 100
~Start Items : 10dg 100 lvl +7 set & 98+7 weapon (for easy leveling)
~Start SP : 2m
~Exp/SP Rate : 80x
|
Hymera # New Fantasy Skills # Job War Point System # Black Set
07/04/2012 - SRO PServer Advertising - 70 Replies
- Exp Rate : 100x
- SP Rate : 100x (you will start with 2m sp)
- You will start special items.
- Drop Rate : 10x
- Gold Drop Rate: 2x
- Job Rate: Normal
- Level Cap : 110
- Skill Cap: 110
- Mastery : 330
- Race : Eu & Ch
|
All times are GMT +2. The time now is 21:21.
|
|
![[RELEASE]Naturalion Point System](https://www.elitepvpers.com/forum/iconimages/metin2-pserver-guides-strategies/release-naturalion-point-system_ltr.gif){kind=small}
