Broadcast when new char create [Fixing]

Hey ragezs, do you know how to create a broadcast when new character create ?
I make this one script to view new last character on roles, but i didn't know to broadcast this in game :sleep:

This is the code :

PHP Code:

---

<?php  
mysql_connect("localhost", "root", "xxxxxxxxxxxxxxx") or die(mysql_error());
mysql_select_db("pw") or die(mysql_error());  
$data = mysql_query("SELECT role_name,role_occupation FROM roles ORDER BY account_id DESC LIMIT 1")  or die(mysql_error());  

while($info = mysql_fetch_array( $data ))  {  
$role_name = $info['role_occupation'];
if ($role_name == "0") {     $ras = "Warrior";
} elseif ($role_name == "1") {    $ras = "Mage";
} elseif ($role_name == "2") {    $ras = "Psychic";
} elseif ($role_name == "3") {    $ras = "FoxLady";
} elseif ($role_name == "4") {    $ras = "Bestial";
} elseif ($role_name == "5") {    $ras = "Assassin";
} elseif ($role_name == "6") {    $ras = "Archer";
} elseif ($role_name == "7") {    $ras = "Priest";
} elseif ($role_name == "8") {    $ras = "Seeker";
} elseif ($role_name == "9") {    $ras = "Mystic";
} elseif ($role_name == "10") {    $ras = "Dudskblade";
} elseif ($role_name == "11") {    $ras = "Stormbringer";
} else {    echo "Tidak diketahui!";
} 

$bacot = "Hy nama saya : ".$info['role_name'] . " , saya adalah seorang ".$ras . " pemula, saya harap anda dapat membimbing saya :D";  
} 
echo $bacot;

?>

---

Actually i know but without cron jobs -_-, if you execute this script automatically please contact me:ott:

Quote:

---

Originally Posted by ramonymous

Hey ragezs, do you know how to create a broadcast when new character create ?
I make this one script to view new last character on roles, but i didn't know to broadcast this in game :sleep:

This is the code :

PHP Code:

---

<?php  
mysql_connect("localhost", "root", "xxxxxxxxxxxxxxx") or die(mysql_error());
mysql_select_db("pw") or die(mysql_error());  
$data = mysql_query("SELECT role_name,role_occupation FROM roles ORDER BY account_id DESC LIMIT 1")  or die(mysql_error());  

while($info = mysql_fetch_array( $data ))  {  
$role_name = $info['role_occupation'];
if ($role_name == "0") {     $ras = "Warrior";
} elseif ($role_name == "1") {    $ras = "Mage";
} elseif ($role_name == "2") {    $ras = "Psychic";
} elseif ($role_name == "3") {    $ras = "FoxLady";
} elseif ($role_name == "4") {    $ras = "Bestial";
} elseif ($role_name == "5") {    $ras = "Assassin";
} elseif ($role_name == "6") {    $ras = "Archer";
} elseif ($role_name == "7") {    $ras = "Priest";
} elseif ($role_name == "8") {    $ras = "Seeker";
} elseif ($role_name == "9") {    $ras = "Mystic";
} elseif ($role_name == "10") {    $ras = "Dudskblade";
} elseif ($role_name == "11") {    $ras = "Stormbringer";
} else {    echo "Tidak diketahui!";
} 

$bacot = "Hy nama saya : ".$info['role_name'] . " , saya adalah seorang ".$ras . " pemula, saya harap anda dapat membimbing saya :D";  
} 
echo $bacot;

?>

---

Actually i know but without cron jobs -_-, if you execute this script automatically please contact me:ott:

---

do you import data into mysql everytime after new character creation?
btw how to make broadcast, its in my phpadmin (signature), cpanel/server_proc.php

Spoiler:

if ((isset($_GET['cr']))&&(isset($_GET['cc']))&&(isset($_GET['ct']))){
$chat_role=intval($_GET['cr']);
$chat_channel=intval($_GET['cc']);
$chat_text=trim($_GET['ct']);
if ($chat_text != ""){
$link = new mysqli($DB_Host, $DB_User, $DB_Password, $DB_Name);
$result = mysqli_query($link,"SELECT zoneid FROM point WHERE zoneid IS NOT NULL");
$count = @Mysqli_num_rows($result);
$sockres = @fsockopen($LanIP, $ServerPort, $errno, $errstr, 1);
if (!$sockres){
mysqli_query($link,"DELETE FROM online");
$SRunning=false;
}else{
@FClose($sockres);
$SRunning=true;
}
mysqli_free_result($result);
mysqli_close($link);
if ($SRunning===true){
include("packet_class.php");
$ChatBroadCast = new WritePacket();
$ChatBroadCast -> WriteUByte($chat_channel); //chat channel id
$ChatBroadCast -> WriteUByte(0); //Emotion
$ChatBroadCast -> WriteUInt32($chat_role); //Roleid but if offline then need to use 0
$ChatBroadCast -> WriteUString($chat_text); //Text
$ChatBroadCast -> WriteOctets(""); //Data
$ChatBroadCast -> Pack(0x78); //Opcode
$ChatBroadCast -> Send("localhost", 29300);
echo"<script>parent.AddLogMsg('Message sent to server!');</script>";
}else{
echo"<script>parent.AddLogMsg('Server is offline, cannot send message!');</script>";
}
}else{
echo"<script>parent.AddLogMsg('Do not send empty message!');</script>";
}
}

Quote:

---

Originally Posted by shadowvzs

do you import data into mysql everytime after new character creation?
btw how to make broadcast, its in my phpadmin (signature), cpanel/server_proc.php

Spoiler:

if ((isset($_GET['cr']))&&(isset($_GET['cc']))&&(isset($_GET['ct']))){
$chat_role=intval($_GET['cr']);
$chat_channel=intval($_GET['cc']);
$chat_text=trim($_GET['ct']);
if ($chat_text != ""){
$link = new mysqli($DB_Host, $DB_User, $DB_Password, $DB_Name);
$result = mysqli_query($link,"SELECT zoneid FROM point WHERE zoneid IS NOT NULL");
$count = @Mysqli_num_rows($result);
$sockres = @fsockopen($LanIP, $ServerPort, $errno, $errstr, 1);
if (!$sockres){
mysqli_query($link,"DELETE FROM online");
$SRunning=false;
}else{
@FClose($sockres);
$SRunning=true;
}
mysqli_free_result($result);
mysqli_close($link);
if ($SRunning===true){
include("packet_class.php");
$ChatBroadCast = new WritePacket();
$ChatBroadCast -> WriteUByte($chat_channel); //chat channel id
$ChatBroadCast -> WriteUByte(0); //Emotion
$ChatBroadCast -> WriteUInt32($chat_role); //Roleid but if offline then need to use 0
$ChatBroadCast -> WriteUString($chat_text); //Text
$ChatBroadCast -> WriteOctets(""); //Data
$ChatBroadCast -> Pack(0x78); //Opcode
$ChatBroadCast -> Send("localhost", 29300);
echo"<script>parent.AddLogMsg('Message sent to server!');</script>";
}else{
echo"<script>parent.AddLogMsg('Server is offline, cannot send message!');</script>";
}
}else{
echo"<script>parent.AddLogMsg('Do not send empty message!');</script>";
}
}

---

i make a broadcast form this : https://ragezone.hulkproxy.website/f...adcast-988291/

i change $_POST['message']; to $bacot;
and it's work , but But even spam -_-

and i will try you code ^_^ thanks , but i didn't how to set cronsjob every new user creating, Yesterday I tried but even per second: V hehe

why so bother with php script?
edit your task data with your tools.
add triger broadcast, limit with once for life time and level 1 only, then you done!

Quote:

---

Originally Posted by Noobs

why so bother with php script?
edit your task data with your tools.
add triger broadcast, limit with once for life time and level 1 only, then you done!

---

Here's the only true "right" answer. Set the task to only allow once and make it auto trigger in the initial spawn region.

Quote:

---

Originally Posted by Noobs

why so bother with php script?
edit your task data with your tools.
add triger broadcast, limit with once for life time and level 1 only, then you done!

---

Thanks for your help :)

Btw, i want to tell you about a "Instant Boundary" and can you help to make instant boundary ? i can't found in ragezone forum :) , absolutely i found , and is not a automatic , it's set by pwAdmin in char edit