|
You last visited: Today at 03:35
Advertisement
[RELEASE] FIND THE PM EVENT!
Discussion on [RELEASE] FIND THE PM EVENT! within the EO PServer Guides & Releases forum part of the EO PServer Hosting category.
11/14/2010, 01:40
|
#16
|
elite*gold: 246 
Join Date: Jan 2008
Posts: 1,712
Received Thanks: 896
|
Quote:
Originally Posted by FDO998
Quote:
('5156133', 'Teleport2Event', '2', '19580', '1903', '303', '291', '5156135', '1')
delete from cq_action where id >= 51561321 and id <= 51561328;
[Err] 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `cq_npc` (`id`, `name`, `type`, `lookface`, `mapid`
|
what im gotta do..? |
You need to add a semicolon ; at the end of each INSERT line. The OP left those out for some reason.
Like this:
Quote:
Originally Posted by zatchbell32505
TO ADD THE TELEPORT TO THERE
Code:
INSERT INTO `cq_npc` (`id`, `name`, `type`, `lookface`, `mapid`, `cellx`, `celly`, `task0`, `sort`) VALUES
('51561321', 'Teleport2Event', '2', '19580', '1000', '322', '417', '51561321', '1')[B][COLOR="Red"];[/COLOR][/B]
Now For the Teleporter there in the maze
Code:
INSERT INTO `cq_npc` (`id`, `name`, `type`, `lookface`, `mapid`, `cellx`, `celly`, `task0`, `sort`) VALUES
('5156133', 'Teleport2Event', '2', '19580', '1903', '303', '291', '5156135', '1')[B][COLOR="Red"];[/COLOR][/B]
|
Quote:
Originally Posted by SpongeBox
need a bit more detail than that... where is the INSERT part?
|
Since this is a release thread one would logically look for a query in the first post. 
|
|
|
|
11/14/2010, 07:02
|
#17
|
elite*gold: 0
Join Date: Sep 2010
Posts: 340
Received Thanks: 201
|
thx king_arthur..no wonder i wont works..now is working..tq!!!!!!!i love u!!!!!!!
|
|
|
|
|
11/15/2010, 19:29
|
#18
|
elite*gold: 0
Join Date: Jan 2010
Posts: 52
Received Thanks: 1
|
how to put the monsters on the map
|
|
|
|
|
11/16/2010, 00:59
|
#19
|
elite*gold: 246
Join Date: Jan 2008
Posts: 1,712
Received Thanks: 896
|
Quote:
Originally Posted by murillo123
how to put the monsters on the map
|
There are no monsters in this release. It's a "Find the PM" event.
|
|
|
|
|
11/16/2010, 10:00
|
#20
|
elite*gold: 0
Join Date: Dec 2009
Posts: 1,784
Received Thanks: 1,056
|
Quote:
Originally Posted by zatchbell32505
[SIZE="4"][COLOR="Red"]
TO ADD THE TELEPORT TO THERE
Code:
INSERT INTO `cq_npc` (`id`, `name`, `type`, `lookface`, `mapid`, `cellx`, `celly`, `task0`, `sort`) VALUES
('51561321', 'Teleport2Event', '2', '19580', '1000', '322', '417', '51561321', '1')
Now For the Teleporter there in the maze
Code:
INSERT INTO `cq_npc` (`id`, `name`, `type`, `lookface`, `mapid`, `cellx`, `celly`, `task0`, `sort`) VALUES
('5156133', 'Teleport2Event', '2', '19580', '1903', '303', '291', '5156135', '1')
Now For the Teleporters task nows
Code:
delete from cq_action where id >= 51561321 and id <= 51561328;
delete from cq_task where id >= 51561321 and id <= 51561328;
Insert into cq_action values
(51561321,51561322,0,101,0,'Want~To~Go~to~the~Event?'),
(51561322,51561325,0,102,0,'Event~Maze 51561323'),
(51561323,51561324,0,1003,0,'1903 300 295'),
(51561324,0,0,126,0,'Welcome~to~Event~Maze!'),
(51561325,51561326,0,102,0,'Nah,ill~stay~in~cronus 0'),
(51561326,51561327,0,104,0,'0 0 15110'),
(51561327,0,0,120,0,'');
Insert into cq_task values
(51561323,51561323,0,'','',0,0,999,-100000,100000,999,0,0,-1,0),
(51561321,51561321,0,'','',0,0,999,-100000,100000,999,0,0,-1,0);
Now for second telporters Task
Code:
delete from cq_action where id >= 5156133 and id <= 5156140;
delete from cq_task where id >= 5156133 and id <= 5156140;
Insert into cq_action values
(5156133,5156134,0,101,0,'Would~You~like~to~Leave~and~go~back~to~cronus?'),
(5156134,5156137,0,102,0,'Yes,Thank~you 5156135'),
(5156135,5156136,0,1003,0,'1000 291 465'),
(5156136,0,0,126,0,'Welcome~to~Cronus~Thanks~For~Joining~our~Event!'),
(5156137,5156138,0,102,0,' 0'),
(5156138,5156139,0,104,0,'0 0 19580'),
(5156139,0,0,120,0,'');
Insert into cq_task values
(5156135,5156135,0,'','',0,0,999,-100000,100000,999,0,0,-1,0),
(5156133,5156133,0,'','',0,0,999,-100000,100000,999,0,0,-1,0);
|
i see its organized but thats not enough after u explain u need to add the query in 1 part
Code:
INSERT INTO `cq_npc` (`id`, `name`, `type`, `lookface`, `mapid`, `cellx`, `celly`, `task0`, `sort`) VALUES ('51561321', 'Teleport2Event', '2', '19580', '1000', '322', '417', '51561321', '1');
INSERT INTO `cq_npc` (`id`, `name`, `type`, `lookface`, `mapid`, `cellx`, `celly`, `task0`, `sort`) VALUES ('5156133', 'Teleport2Event' '2','19580','1903','303','291','5156135','1'); delete from cq_action where id >= 51561321 and id <= 51561328;
delete from cq_task where id >= 51561321 and id <= 51561328;
Insert into cq_action values
(51561321,51561322,0,101,0,'Want~To~Go~to~the~Event?'),
(51561322,51561325,0,102,0,'Event~Maze 51561323'),
(51561323,51561324,0,1003,0,'1903 300 295'),
(51561324,0,0,126,0,'Welcome~to~Event~Maze!'),
(51561325,51561326,0,102,0,'Nah,ill~stay~in~cronus 0'),
(51561326,51561327,0,104,0,'0 0 15110'),
(51561327,0,0,120,0,'');
Insert into cq_task values
(51561323,51561323,0,'','',0,0,999,-100000,100000,999,0,0,-1,0),
(51561321,51561321,0,'','',0,0,999,-100000,100000,999,0,0,-1,0); delete from cq_action where id >= 5156133 and id <= 5156140;
delete from cq_task where id >= 5156133 and id <= 5156140;
Insert into cq_action values
(5156133,5156134,0,101,0,'Would~You~like~to~Leave~and~go~back~to~cronus?'),
(5156134,5156137,0,102,0,'Yes,Thank~you 5156135'),
(5156135,5156136,0,1003,0,'1000 291 465'),
(5156136,0,0,126,0,'Welcome~to~Cronus~Thanks~For~Joining~our~Event!',(5156137,5156138,0,102,0,' 0'),
(5156138,5156139,0,104,0,'0 0 19580'),
(5156139,0,0,120,0,'');
Insert into cq_task values
(5156135,5156135,0,'','',0,0,999,-100000,100000,999,0,0,-1,0),
(5156133,5156133,0,'','',0,0,999,-100000,100000,999,0,0,-1,0);
You Need To Make A Newbie side too Dont forget that 
BestRegards
~Sword~Stalker~
[the name will be changed to Anonymous xD]
|
|
|
|
 |
|
Similar Threads
|
Release Hack Find
02/16/2010 - Combat Arms Hacks, Bots, Cheats & Exploits - 4 Replies
Sorry Have forget ^^
New Hack not from me Test it
Features:
-Spammer
-Tapper
-CBL Checker
-Crosshair
-AFK BOT
-Aimbot
|
event: Find the GM???
12/30/2009 - Silkroad Online - 2 Replies
Anybody know anything about this event?:confused:
This is happening on all servers?
|
where can i find xmas event monsters ?
12/18/2009 - Silkroad Online - 9 Replies
i cant find them ?
i search everywhere but i cant find them omg stupid joymax wtf ?!
|
[Release]How to find Item Quality
12/16/2009 - CO2 PServer Guides & Releases - 3 Replies
Right, decided i would release this, anyone with common sense is probably already doing this but hopefully it will help someone.
public static int GetQuality(int ItemID)
{
return ItemID % 10;
}
Give the function the Static Item ID, and it will return the quality (1-9), this can be addapted to use an enum and return Super, Elite, Unique etc:
public static ItemQuality GetQuality(uint ItemID)
{
|
[Release]Pk Event
07/01/2009 - CO2 PServer Guides & Releases - 34 Replies
Okay, this is my first release for a LOTF PK event, so i hope you enjoy it! Any questions reply here or message me on msn at [email protected]. Also Credits to EmmeTheCoder for his Start/stop npc codes used for this.
Remember to hit Thanks!
First:
Go to General.cs and add this somewhere:
public static bool PKEvent = false;
Second:
Go to Character.cs and search for:
public void TimerElapsed(object source, ElapsedEventArgs e)
|
All times are GMT +1. The time now is 03:36.
|
|
![[RELEASE] FIND THE PM EVENT!](https://www.elitepvpers.com/forum/iconimages/eo-pserver-guides-releases/release-find-pm-event_ltr.gif){kind=small}
