Sql For Rpg

**BoYzONe** · 09.09.08, 10:55

hellow friends. Pls post here sql for rpg and jnp . Thanks very much[/b]

give me the script and i will give u the sql.

**inet** · 09.09.08, 11:06

as in thousands of people asking for this sql.... got mails from different persons...

there are still available out there remember there are 13 scripts of rpg for wap... please specify it.. then i'll provide it..

**friend** · 09.09.08, 11:14

pls gave sql for rpg like in pinoywap.net thanks in advance

**friend** · 10.09.08, 03:29

were are u bro inet?

**inet** · 10.09.08, 06:21

there are many RPG VERSIONS for instance there is the versions of lib3rty.com RPG script....

and many more like...

min0taur (pinoywap.net site admin/owner) has another version RPG with rambol...
gambit (pinoy9.com site admin/owner) has RPG tooo..
thanatos (Natasu.net site admin/owner) has too a good version..
busterkeaton (mobile69ers.com site admin/owner) has the nice version too...

THERE ARE STILL MANY VERSIONS OF IT...

i have my own version tooo.... the rangers RPG of my site pinoy2 community

the above friends have the full copy of the script with sql you can request to them... for as far i remember they purchased the script, some have it by exchange to another script or database sql, some paid for the improved script and some made improvements...

As you can see majority of Filipino have the script...

the RPG pinoy or PINOY RPG

WAS BASED ON CASPER BETA RPG SCRIPT WHATSOEVER THAT SCRIPT ORIGINALLY KNOWN..

PRIMARILLY ASK FOR THE SQL OF THE SCRIPT WITH MINOTAUR, IF MINOTAUR WILL NOT GIVE;

THEN ASK GAMBIT, IF HE WILL NOT GIVE;

THEN ASK THANATOS, IF HE WILL NOT GIVE;

THEN ASK BUSTERKEATON, IF HE WILL NOT GIVE;

YOU CAN NOW ASK ME....

I ASSURE YOU THAT IT IS VERY HARD TO REQUEST WITH THIS MATTER COZ THIS IS THE PRIMARY ATTRACTION OF THEIR WAPCOMMUNITY.. YOU MAY PAY THEM THEY MAY GIVE IT AND INSTALL IT WITH YOUR SITE, JUST APPROACH ME IF THEIR PRICE CAN BE CONSIDERED TO HIGH, I MAY GIVE IT AT A LOWER OR CHEAPER WITH BONUS OTHER SCRIPTS FREE...

THE JNP SCRIPT IS AVAILABLE WITH 6 VERSIONS... JUST TRY TO ASK TO THE ABOVE PERSONS..

I ALMOST FORGOT SOME PEOPLE HAVE THE SCRIPT... BUT I DONT KNOW THEM.. I JUST HAVE BROWSED THE WAPWORLD FOR HOW MANY YEARS... SO I HAVE SEEN MANY VERSIONS OF YOUR REQUEST..

ESPECIALLY I SEE LIB3RTY RPG SCRIPT IS ONE OF THE VERY DISTINCT MULTIPLAYER RPG SCRIPT I HAVE EVER SEEN... AND MANY OTHERS..

Purchase games to a filipino and they will give bonus scripts, just like me i gave bonus..

**inet** · 10.09.08, 06:56

have a look at this one, one of files that i have seen.. an rpg version

see... as i have said, there are many versions of it...

btw take care of the version that you poses they might spoil it...

i have downloaded it from somewhere else... just browse the web and the linkages in this forum.. and you will see the whole script..

i just visited the lower section of this forum and viewed the web section last month and whoalaaaa!!!!!!
found the ready to download file somewhere else..

just be mapagpasensya sa paghahanap...(hindi ko matranslate eh)

<div class='codetop'>CODE</div><div class='codemain' style='height:200px;white-space:pre;overflow:auto'><?php
header("Content-type: text/vnd.wap.wml");
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // expires in the past
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // Last modified, right now
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Pragma: no-cache");
echo "<?xml version=\"1.0\"?>";
echo "<!DOCTYPE wml PUBLIC \"-//WAPFORUM//DTD WML 1.1//EN\""." \"http://www.wapforum.org/DTD/wml_1.1.xml\">";
?>
<wml>
<head>
<meta forua="true" http-equiv="Cache-Control" content="max-age=0"/>
<meta forua="true" http-equiv="Cache-Control" content="must-revalidate"/>
</head>
<?php

include("config.php");
include("core.php");
$bcon = connectdb();
if (!$bcon)
{
echo "<card id=\"main\" title=\"n3sklub (ERROR!)\">";
echo "<p align=\"center\">";
echo "<img src=\"images/exit.gif\" alt=\"*\"/>
";
echo "Eroare, nu se poate conecta la baza d date!

";
echo "Aceasta eroare apare de obicei cand care serverul isi va reveni in cateva secunde!Daca problema persista va rugam sa luati legatura cat mai curand posibil cu LORD

";
//echo "Soon, we will offer services that doesn't depend on MySQL databse to let you enjoy our site, while the database is not connected
";
echo "Va multumim foarte mult pentru intelegere!";
echo "</p>";
echo "</card>";
echo "</wml>";
}

//$brws = explode(" ",$HTTP_USER_AGENT);
//$ubr = $brws[0];
$ubr=$_SERVER['HTTP_USER_AGENT'];
$uip = getip();
$action = $_GET["action"];
$sid = $_GET["sid"];
$who = $_GET["who"];
$set = $_GET["set"];
$code= $_GET["code"];
$uid=getuid_sid($sid);

//echo isbanned($uid);
if(isbanned($uid))
{
echo "<card id=\"main\" title=\"n3sklub.com\">";
echo "<p align=\"center\">";
echo "<img src=\"images/notok.gif\" alt=\"x\"/>
";
echo "Esti Banat(a)
";
$banto = mysql_fetch_array(mysql_query("SELECT timeto, pnreas, exid FROM lib3rtymrc_penalties WHERE uid='".$uid."' AND penalty='1' OR uid='".$uid."' AND penalty='2'"));
$banres = mysql_fetch_array(mysql_query("SELECT lastpnreas FROM lib3rtymrc_users WHERE id='".$uid."'"));

$remain = $banto[0]- time();
$rmsg = gettimemsg($remain);
echo "Timp ramas pana la debanare: $rmsg
";
$nick = getnick_uid($banto[2]);
echo "By: $nick
";
echo "Motiv ban: $banres[0]";
//echo "<a href=\"index.php\">Login</a>";
echo "</p>";
echo "</card>";
echo "</wml>";
exit();
}
// R.P.G.
addonline(getuid_sid($sid),"Joaca RPG","rpg.php?action=$main");
$res = mysql_query("UPDATE lib3rtymrc_users SET browserm='".$ubr."', ipadd='".$uip."' WHERE id='".getuid_sid($sid)."'");
///////////////////////////////////time
$res = mysql_fetch_array(mysql_query("SELECT lastact FROM lib3rtymrc_users WHERE id='".$uid."'"));
$lastact = $res[0];
$atime = time() - $lastact;

if($atime<1800){
$res = mysql_fetch_array(mysql_query("SELECT otime, mtime FROM lib3rtymrc_users where id='".$uid."'"));
$otime = $res[0] + $atime;
$mtime = $res[1] + $atime;
$res = mysql_query("UPDATE lib3rtymrc_users SET otime='".$otime."', mtime='".$mtime."' where id='".$uid."'");
}

//check gateway
$checking = mysql_fetch_array(mysql_query("SELECT uid, who FROM lib3rtymrc_rpg WHERE code='".$code."'"));
$nexts = mysql_fetch_array(mysql_query("SELECT next FROM lib3rtymrc_rpg WHERE code='".$code."'"));
$next = $nexts[0];
if($code!="")
{
$out = mysql_num_rows(mysql_query("SELECT * FROM lib3rtymrc_rpg WHERE code='".$code."'"));
if($out=="0")
{
echo "<card id=\"main\" title=\"RPG\">";
echo "<p align=\"centre\">";
echo "Ai pierdut incearca din nou!;)

";
echo "<a href=\"index.php?action=main&sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>Prim</a>";
echo "</p></card>";
echo "</wml>";
exit();
}
}
$altm = time()-(5*60*60);
$res = mysql_query("DELETE FROM lib3rtymrc_rpg WHERE timesent<'".$altm."'");
/*$rest = mysql_query("SELECT code FROM lib3rtymrc_rpg WHERE timesent<'".$altm."'");
if(mysql_num_rows($rest)!="0")
{
$coding = mysql_fetch_array($rest);
$codes = $coding[0];
$info = mysql_fetch_array(mysql_query("SELECT uid, who FROM lib3rtymrc_rpg WHERE code='".$codes."'"));
$utime = mysql_fetch_array(mysql_query("SELECT lastact FROM lib3rtymrc_users WHERE uid='".$info[0]."'"));
$wtime = mysql_fetch_array(mysql_query("SELECT lastact FROM lib3rtymrc_users WHERE who='".$info[1]."'"));
if($utime > $wtime)
if($utime < $altm)
{
$recb = mysql_fetch_array(mysql_query("SELECT gplus FROM lib3rtymrc_users WHERE id='".$uid."'"));
$attb = mysql_fetch_array(mysql_query("SELECT gplus FROM lib3rtymrc_users WHERE id='".$who."'"));
$bets = mysql_fetch_array(mysql_query("SELECT bet FROM lib3rtymrc_rpg WHERE code='".$code."'"));
$bet = $bets[0];
$newgplus = $attb[0] + $bet;
$res = mysql_query("UPDATE lib3rtymrc_users SET gplus='".$newgplus."' WHERE id='".$who."'");
$newgplus = $recb[0] - $bet;
$res = mysql_query("UPDATE lib3rtymrc_users SET gplus='".$newgplus."' WHERE id='".$uid."'");
$res = mysql_query("DELETE FROM lib3rtymrc_rpg WHERE code='".$code."'");
}
if($wtime > $utime)
if($wtime < $altm)
{
$recb = mysql_fetch_array(mysql_query("SELECT gplus FROM lib3rtymrc_users WHERE id='".$uid."'"));
$attb = mysql_fetch_array(mysql_query("SELECT gplus FROM lib3rtymrc_users WHERE id='".$who."'"));
$bets = mysql_fetch_array(mysql_query("SELECT bet FROM lib3rtymrc_rpg WHERE code='".$code."'"));
$bet = $bets[0];
$newgplus = $attb[0] - $bet;
$res = mysql_query("UPDATE lib3rtymrc_users SET gplus='".$newgplus."' WHERE id='".$who."'");
$newgplus = $recb[0] + $bet;
$res = mysql_query("UPDATE lib3rtymrc_users SET gplus='".$newgplus."' WHERE id='".$uid."'");
$res = mysql_query("DELETE FROM lib3rtymrc_rpg WHERE code='".$code."'");
}
}
*/

if($action=="main")
{
echo "<card id=\"main\" title=\"RPG\">";
echo "<p align=\"centre\">";
echo "Cate GP pariati?
";
//echo "GAME PLUS:

";
echo "<input name=\"bet\" format=\"*N\" maxlength=\"10\"/>
";
echo "<anchor>[Pariaza]";
echo "<go href=\"rpg.php?action=rpg&sid=$sid&who=$wh o\" method=\"post\">";
echo "<postfield name=\"bet\" value=\"$(bet)\"/>";
echo "</go></anchor>";
echo "
Regulament
";
echo "";
echo "1. Asigura-te ca ai suficiente GP+ inainte de a porni jocul
";
echo "2. Ai la dispozitie 100 de puncte viata
";
echo "3. Ai dreptul sa lovesti sau sa iti cumperi viata,tu iti alegi strategia
";
echo "4. Care termina primul cele 100 de puncte pierde.
";
echo "5. Daca timp de 5 minute nu joci,adversarul va castiga.
";
echo "6. Castigatorul castiga GP+ pariate.
";
//echo "4. Lastly enjoy the game to the fullest.
";
//echo "5. If there is any system failure and one loses his/her game plus, the site doesnt gives u any insurance without the finishing the complete game.
";
echo "7. Cand ai apasat butonul \"Pariaza\" inseamna ca ai acceptat conditiile si regulile jocului.
";
//echo "8. IF you DONOT ACCEPT ALL THE RULES AND CONDITIONS OF THE GAME, please dont proceed.
";
echo "
p.s.:aceasta este versiunea BETA a jocului
";
echo "";
echo "<a href=\"index.php?action=main&sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
echo "Prim</a>";
echo "</p>";
echo "</card>";
}
else if($action=="rpg")
{
$bet = $_POST["bet"];
if($bet=="")
$bet = 5;
echo "<card id=\"main\" title=\"RPG\">";
echo "<p align=\"centre\">";
$recb=mysql_fetch_array(mysql_query("SELECT gplus FROM lib3rtymrc_users WHERE id='".$uid."'"));
$attb=mysql_fetch_array(mysql_query("SELECT gplus FROM lib3rtymrc_users WHERE id='".$who."'"));
if(($attb[0] - $bet) < 0)
if(($recb[0] - $bet) < 0)
{
echo "Ne pare rau dar nu ai suficiente game plus pentru a juca RPG
";
echo "<a href=\"index.php?action=main&sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
echo "Prim</a>";
echo "</p>";
echo "</card>";
echo "</wml>";
exit();
}
do{
$code = rand(1,150000);
$check = mysql_num_rows(mysql_query("SELECT * FROM lib3rtymrc_rpg WHERE code='".$code."'"));
}while($check!=0);

$res = mysql_query("INSERT INTO lib3rtymrc_rpg SET uid='".$uid."', rhealth='100', who='".$who."', ahealth='100', bet='".$bet."', next='".$uid."', code='".$code."', timesent='".time()."'");
echo "»<a href=\"rpg.php?action=erpg&sid=$sid&who=$w ho&set=$uid&code=$code\">Sa inceapa jocul :D</a>
";
echo "<a href=\"index.php?action=main&sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
echo "Prim</a>";
echo "</p></card>";

}
else if($action=="reject")
{

echo "<card id=\"main\" title=\"RPG\">";
echo "<p align=\"centre\">";
$res = mysql_query("DELETE FROM lib3rtymrc_rpg WHERE code='".$code."'");
echo "
Joc refuzat cu succes
";
$wintext = "".getnick_uid($uid)." a refuzat invitatia la RPG [br/]P.S.:acesta este un pm automat";
$res = mysql_query("INSERT INTO lib3rtymrc_private SET text='".$wintext."', byuid='1', touid='".$who."', timesent='".time()."'");
$res = mysql_query("INSERT INTO lib3rtymrc_private SET text='".$wintext."', byuid='1', touid='".$uid."', timesent='".time()."'");
echo "<a href=\"index.php?action=main&sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
echo "Prim</a>";
echo "</p></card>";

}
else if($action=="erpg")
{
$repair = $_GET["repair"];
echo "<card id=\"main\" title=\"n3sklub.com\">";
//echo "<timer value=\"15\"/><p align=\"center\">";
echo "<p align=\"center\">";
echo "
";
echo getshoutbox($sid);
echo "
";
echo "</p>";
echo "<p align=\"centre\">";
echo "
";
if($repair=="0")
{
if($next==$checking[1])
{

$rech=mysql_fetch_array(mysql_query("SELECT rhealth FROM lib3rtymrc_rpg WHERE code='".$code."'"));
$atth=mysql_fetch_array(mysql_query("SELECT ahealth FROM lib3rtymrc_rpg WHERE code='".$code."'"));
$mx = $rech[0]/2;
$rep = rand(1,$mx);
$atth = $atth[0] + $rep;
$res = mysql_query("UPDATE lib3rtymrc_rpg SET ahealth='".$atth."', next='".$set."', timesent='".time()."' WHERE code='".$code."'");
echo "
you got a life of $rep points
";
$rech = $rech[0];
echo "".getnick_uid($checking[0]).": $rech
".getnick_uid($checking[1]).": $atth
";
}
else
{
$rech=mysql_fetch_array(mysql_query("SELECT rhealth FROM lib3rtymrc_rpg WHERE code='".$code."'"));
$atth=mysql_fetch_array(mysql_query("SELECT ahealth FROM lib3rtymrc_rpg WHERE code='".$code."'"));
$mx = $atth[0]/2;
$rep = rand(1,$mx);
$rech = $rech[0] + $rep;
$res = mysql_query("UPDATE lib3rtymrc_rpg SET rhealth='".$rech."', next='".$set."', timesent='".time()."' WHERE code='".$code."'");
echo "
Vindecarea ti-a adus $rep puncte de viata
";
$atth = $atth[0];
echo "".getnick_uid($checking[0]).": $rech
".getnick_uid($checking[1]).": $atth
";
}
}
else if($repair=="1"){

if($next==$checking[1])
{
$rech=mysql_fetch_array(mysql_query("SELECT rhealth FROM lib3rtymrc_rpg WHERE code='".$code."'"));
$atth=mysql_fetch_array(mysql_query("SELECT ahealth FROM lib3rtymrc_rpg WHERE code='".$code."'"));
$mx = $atth[0]/2;
$dam = rand(1,$mx);
$no = rand(0,17);
$utext = uverbs($no);
echo "
You $utext With $dam points
";
$rech = $rech[0] - $dam;
$atth = $atth[0];
if($rech<0)
{
//wining condition
echo "</p>";
echo "<p align=\"centre\">";
$recb = mysql_fetch_array(mysql_query("SELECT gplus FROM lib3rtymrc_users WHERE id='".$uid."'"));
$attb = mysql_fetch_array(mysql_query("SELECT gplus FROM lib3rtymrc_users WHERE id='".$who."'"));
$bets = mysql_fetch_array(mysql_query("SELECT bet FROM lib3rtymrc_rpg WHERE code='".$code."'"));
$bet = $bets[0];
$newgplus = $attb[0] + $bet;
$res = mysql_query("UPDATE lib3rtymrc_users SET gplus='".$newgplus."' WHERE id='".$who."'");
$newgplus = $recb[0] - $bet;
$res = mysql_query("UPDATE lib3rtymrc_users SET gplus='".$newgplus."' WHERE id='".$uid."'");
$res = mysql_query("DELETE FROM lib3rtymrc_rpg WHERE code='".$code."'");
echo "".getnick_uid($who)." has won over ".getnick_uid($uid)." with $bet game plus";
$wintext = "".getnick_uid($who)." has won over ".getnick_uid($uid)." with $bet game plus [br/] P.S.:acesta este un pm automat";
$res = mysql_query("INSERT INTO lib3rtymrc_private SET text='".$wintext."', byuid='1', touid='".$who."', timesent='".time()."'");
$res = mysql_query("INSERT INTO lib3rtymrc_private SET text='".$wintext."', byuid='1', touid='".$uid."', timesent='".time()."'");
echo "<a href=\"index.php?action=main&sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>Prim</a>";
echo "</p></card>";
echo "</wml>";
exit();
}
if($rech<0)
$rech=0;
$res = mysql_query("UPDATE lib3rtymrc_rpg SET rhealth='".$rech."', next='".$set."', timesent='".time()."' WHERE code='".$code."'");
echo "".getnick_uid($checking[0]).": $rech
".getnick_uid($checking[1]).": $atth
";
//$set = "0";
}
else
{
$rech=mysql_fetch_array(mysql_query("SELECT rhealth FROM lib3rtymrc_rpg WHERE code='".$code."'"));
$atth=mysql_fetch_array(mysql_query("SELECT ahealth FROM lib3rtymrc_rpg WHERE code='".$code."'"));
$mx = $rech[0]/2;
$dam = rand(1,$mx);
$no = rand(0,17);
$utext = uverbs($no);
echo "
You $utext With $dam points
";
$atth = $atth[0] - $dam;
$rech = $rech[0];
if($atth<0)
{
//wining condition
echo "</p>";
echo "<p align=\"centre\">";
$recb = mysql_fetch_array(mysql_query("SELECT gplus FROM lib3rtymrc_users WHERE id='".$uid."'"));
$attb = mysql_fetch_array(mysql_query("SELECT gplus FROM lib3rtymrc_users WHERE id='".$who."'"));
$bets = mysql_fetch_array(mysql_query("SELECT bet FROM lib3rtymrc_rpg WHERE code='".$code."'"));
$bet = $bets[0];
$newgplus = $attb[0] - $bet;
$res = mysql_query("UPDATE lib3rtymrc_users SET gplus='".$newgplus."' WHERE id='".$who."'");
$newgplus = $recb[0] + $bet;
$res = mysql_query("UPDATE lib3rtymrc_users SET gplus='".$newgplus."' WHERE id='".$uid."'");
$res = mysql_query("DELETE FROM lib3rtymrc_rpg WHERE code='".$code."'");
echo "".getnick_uid($uid)." has won over ".getnick_uid($who)." with $bet game plus";
$wintext = "".getnick_uid($uid)." has won over ".getnick_uid($who)." with $bet game plus[br/] P.S.:acesta este un pm automat";
$res = mysql_query("INSERT INTO lib3rtymrc_private SET text='".$wintext."', byuid='1', touid='".$who."', timesent='".time()."'");
$res = mysql_query("INSERT INTO lib3rtymrc_private SET text='".$wintext."', byuid='1', touid='".$uid."', timesent='".time()."'");
echo "<a href=\"index.php?action=main&sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>Home</a>";
echo "</p></card>";
echo "</wml>";
exit();
}
if($rech<0)
$rech=0;
$res = mysql_query("UPDATE lib3rtymrc_rpg SET ahealth='".$atth."', next='".$set."',timesent='".time()."&# 39; WHERE code='".$code."'");
echo "".getnick_uid($checking[0]).": $rech
".getnick_uid($checking[1]).": $atth
";
}
}
else{
$rech=mysql_fetch_array(mysql_query("SELECT rhealth FROM lib3rtymrc_rpg WHERE code='".$code."'"));
$atth=mysql_fetch_array(mysql_query("SELECT ahealth FROM lib3rtymrc_rpg WHERE code='".$code."'"));
echo "".getnick_uid($checking[0]).": $rech[0]
".getnick_uid($checking[1]).": $atth[0]
";
}
$nexts = mysql_fetch_array(mysql_query("SELECT next FROM lib3rtymrc_rpg WHERE code='".$code."'"));
$next = $nexts[0];
if($next==$uid)
{
if($next==$checking[0])
$set=$checking[1];
else
$set=$checking[0];
echo "<img src=\"images/mad.png\" alt=\"*\"/><a href=\"rpg.php?action=erpg&sid=$sid&who=$w ho&set=$set&repair=1&code=$code\">Atac a</a>
";
echo "<img src=\"images/2hearts.gif\" alt=\"*\"/><a href=\"rpg.php?action=erpg&sid=$sid&who=$w ho&set=$set&repair=0&code=$code\">Vind eca</a>
";
}
else
{
echo "<img src=\"images/clubs.png\" alt=\"*\"/><a href=\"rpg.php?action=erpg&time=";
echo date('dmHis');
echo "&sid=$sid&who=$who&code=$code\">ReFRE SH</a>";
}

echo "</p></card>";
}
?>
</wml></div>

**inet** · 15.09.08, 05:25

request in process bro....

i will update your site and make it good for rpg gaming.... for more services just email me...

making your wapsite improved just contact me...

**friend** · 16.09.08, 04:49

request in process bro....

i will update your site and make it good for rpg gaming.... for more services just email me...

making your wapsite improved just contact me...[/b]

Thanks bro
You may came there anytime . . . .

**Guest** · 06.11.08, 07:57

bro inet nosebleed if i create a sql table for rpg script! lol..wtf bugz

**keanvn** · 06.11.08, 08:07

haha...kawawa ka nmn copy paster

**Guest** · 28.11.08, 04:18

ai wag na pala inet madali lang pala hehehe..

Sql For Rpg

Sql For Rpg

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment