[Looking for a VPS and Setting Up Server in VPS]

try it sir. Free lang pag install ng ceres CP :( add mo nlang sa ym ung agent nyan. [email protected]

Thank you sir Elixir for a fast reply..

Are you using the same VPS?

so ganito yan kung vps pwedeng axwebs tapos ung remote desktop na sinasabi mo wala nun kase ang vps ay virtual private server pero may ibang ring application na kayang maaccess ung VPS through WinCP and pag on ng server through Putty

Posible un kung sa axwebs or kung anong VPS Hosting na nag poprovide ng Ragnarok Online needs kagaya ng Axwebs Frantech Bluesky

Actually sa axwebs ko nga po nakita sir yung vps na may remote desktop..

Ncontact ko na din po yung sa axwebs and still waiting for their reply..

So nag iinquire pa po ako ng ibang VPS hoster na may same feature.. Thanks..

[Looking for a VPS and Setting Up Server in VPS]

Hi guys! Sorry if this is not the right section to post this..

So naghahanap po ako ng VPS na makakapag host ng server ko 24/7, anu po ba marerecommend niyo?..

Kasi gusto ko po yung parang may remote desktop, para pwedeng ako na din po mag setup nung server, ksi ung mga files nasa pc ko din po..

Tska possible din po ba na yung CP ko nasa VPS din?.. Salamat po..

[Flux CP Guild Ranking Points]

Hello everyone..

So i've used a script for guild points..

function    script    GuildRanker    {
query_sql("select name from `guild` where guild_id = '"+.@gid+"'", .@gname$);
query_sql "CREATE TABLE IF NOT EXISTS `woe_extension`(`guild_id` int(11) unsigned NOT NULL,`guild_points` smallint(6) unsigned NOT NULL default '0')";
set .@TempGuild_id, .@gid;
query_sql("SELECT guild_points FROM woe_extension WHERE guild_id="+.@TempGuild_id, .@TempGuild_Points);
if ( .@TempGuild_id != 0 && .@TempGuild_Points == 0 ) {// guild not listed yet
set .@TempGuild_Points, .@TempGuild_Points + 1;
query_sql "INSERT INTO woe_extension (guild_id, guild_points) VALUES ("+.@TempGuild_id+","+.@TempGuild_Points+")";
announce "Guild ["+.@gname$+"] has just added One [1] WoE Points by conquering a Castle and with a running Guild Conqueror Points of "+.@TempGuild_Points+" !",bc_all;
}
if ( .@TempGuild_id != 0 && .@TempGuild_Points >= 1 ) { // guild is listed
set .@TempGuild_Points, .@TempGuild_Points + 1;
query_sql("UPDATE woe_extension SET guild_points="+.@TempGuild_Points+" WHERE guild_id="+.@TempGuild_id);
announce "Guild ["+.@gname$+"] has just added another One [1] WoE Points by conquering a Castle and with a running Guild Conqueror Points of "+.@TempGuild_Points+" !",bc_all;
}
return;

It's working and giving the points and it's recorded on the sql..

I want to integrate this point in the guild ranking feature of flux or maybe another ranking feature but i'm finding it hard to do so cause i can't understand the code such as:

$col  = "g.guild_id, g.name, g.guild_lv, g.exp, g.average_lv, g.emblem_len,";
$col .= "(SELECT COUNT(char_id) FROM {$server->charMapDatabase}.`char` WHERE `char`.guild_id = g.guild_id) AS members, ";
$col .= "(SELECT COUNT(castle_id) FROM {$server->charMapDatabase}.guild_castle WHERE guild_castle.guild_id = g.guild_id) AS castles";
$sql  = "SELECT $col FROM {$server->charMapDatabase}.guild AS g ";
$sql .= "LEFT JOIN {$server->charMapDatabase}.`char` AS ch ON ch.char_id = g.char_id ";
$sql .= "LEFT JOIN {$server->loginDatabase}.login ON login.account_id = ch.account_id ";

I tried to make a code but it's not working..

Thanks in advance..

[WoE Reward]

Hi! Here's a script from Goddameit which i have edited...

//Author : Goddameit
//Version : 2011/12/16 - 01:04
function script AllGuildMemberEvent {
if(!set(.@gid,getcastledata(getarg(0),1)))
 return;
query_sql("select account_id, char_id from `guild_member` where guild_id = '"+.@gid+"'", .@gmaid, .@gmcid);
for(set .@i,0;.@i
{
 if(isloggedin(.@gmaid[.@i]))
 getitem 12628,1,.@gmaid[.@i];
 }
}
- script AGME -1,{
OnAGME:
setarray .@maps$[0],"aldeg_cas01","aldeg_cas02","aldeg_cas03","aldeg_cas04","aldeg_cas05";
setarray .@maps$[5],"gefg_cas01","gefg_cas02","gefg_cas03","gefg_cas04","gefg_cas05";
setarray .@maps$[10],"payg_cas01","payg_cas02","payg_cas03","payg_cas04","payg_cas05";
setarray .@maps$[15],"prtg_cas01","prtg_cas02","prtg_cas03","prtg_cas04","prtg_cas05";
for( set .@i,0; .@i <= 19; set .@i, .@i+1)
{
 callfunc "AllGuildMemberEvent",.@maps$[.@i],0,
  "System","WoE Victory Reward","Congratulations! Your guild succeeded in   occupying "+ getcastlename(.@maps$[.@i]) +". This is your rewards.",
  501,1,1,0,
  "[You got a mail!! Please relogin to reupdate your mail list.]";
}
end;
}

For the cashpoints, just make an item that gives a cash point and add it's getitem command..

EDIT: I forgot to tell you to add onAgitEnd of your woe script..

donpcevent "AGME::OnAGME";

Hope it helps..

[Friend Setup Option not saving]

ROdataOptionInfo.lua

OptionInfoList["AutoOpen1to1Window_Friend"] = 1
OptionInfoList["PlaySound_Open1to1Window"] = 1

the problem might be

you added the save files inside your grf

this 3 files

ChatWndInfo_U.lua

OptionInfo.lua

UserKeys_s.lua

must not be found inside your grf

Thanks for the answer, i'm gonna try this..

Edit: Thank you very much.. It's working now..

[Friend Setup Option not saving]

Hello po, gumagamit ako ng Renewal client, 05-17b-2011

ang prob po, hindi nag sasave yung sa friend setup na

Open 1:1 Chat not between Friends

Open 1:1 Chat between Friends

Alarm when you receive a 1 on 1 Chat

So dinidisable ko po yung unang dalawa, yung open 1:1 Chat, kaso pag cnlose na po yung client, pag open ko po ulit, nka enable nanaman.

May nabasa ako dati na regarding daw sa diff na extended PM box, so i tried to diff another 05-17b-2011 na naka enable at yung isa hindi nka enable, pero same result lang po.

Maraming Salamat po sa makakatulong sa akin..

[Flux Integ. by jaypee]

Sir, how can i show the server status on all pages?..

I managed to put it on top and place it in header.php

but only shows in server status page...

Thanks..

[Client 2011 05 17 Gravity Error]

Ok, so i tried different clients ranging from 5-11 to 6-28 clients..

And i found out that its only the "GREEN DRAGON" mount which is giving me the error..

So I think it's sprite or act error..

I checked rdata.grf and it has the sprite and act for the green dragon,

So I really don't have any idea why it's causing such error...

Advance thanks to someone who can help..

God bless you guys..

[Client 2011 05 17 Gravity Error]

Hi guys.. I'm using the said client above.. all is well but I'm having trouble when using skills of a Rune Knight on a Dragon Mount...

When i cast Rune Knight's skills like dragon breath, concentration and enchant blade, it gives me a gravity error...

But using my admin account which doesn't show a dragon mount, i don't have gravity errors...

I really don't know what's causing the error...

I'm using the data folder from Judas... 07-16-2011

Btw, i'm using 3ceam 650..

There are no errors in the mapserver, char server and login server...

Thanks for those who will reply..