80% Finished PHP Script to go from rank 11 to rank 12

**TimeBomb** · 17-07-09

Latest code as of 08/07/09:

Code:

<?PHP
$sql_server = "localhost"; //<-- MSSQL server address/ip
$sql_user = "sa"; //<-- MSSQL username
$sql_pass = "sa"; //<-- MSSQL password
$sql_data = "cabaldb"; //<-- MSSQL database
$conn=mssql_connect($sql_server,$sql_user,$sql_pass);
$xadb = mssql_select_db($sql_data,$conn);
$Data = '<html>Your Character Name: <br><form action=bypassrankcabal.php method=post><input type=text name=charname><br><br><input type=submit name=submit  value="Submit"></form></html>';
$char = $_POST['charname'];
	if (isset($_POST['charname'])){
 if(preg_match('%[a-zA-Z0-9[\]]%', $char)){
	$findcharrank = mssql_query("select * from  DBO.cabal_character_table where round(((((([Style] % (67108864)) % (131072)) % (8192)) % (256)) / 8 ),1) = 11 and name = '$char'");
        $total = mssql_fetch_array($findcharrank); 
	if ($total[0] == 1){
mssql_query("update dbo.cabal_character_table set [Style]=[Style]+8 where round(((((([Style] % (67108864)) % (131072)) % (8192)) % (256)) / 8 ),1) = 11 and name = '$char'");
echo '<b>', $char, ' is now Rank 12!<p></b>'; }
	else {	echo '<b>Character is either not rank 11, or can not be found.</b><p>';}

} else {
echo '<b>Invalid character used!<p></b>'; }
}
echo $Data;
?>

Main problem is that quests still seem to be a problem. Rank is updated but quests stay the same.

**MentaL**

80% Finished PHP Script to go from rank 11 to rank 12

**john_d** · 29-07-09

what you talking about class rank... is in style column.????

**TimeBomb** · 29-07-09

Yes. Rank as in style column.

**Yamachi** · 29-07-09

Um... this won't work at all o.O Why are you editing the "Rank" column? That's for skill rank, not class rank.

Originally Posted by timebomb

Yes. Rank as in style column.

He wasn't asking a question. john_d already knows that class rank is in the style column :P

**chumpywumpy** · 29-07-09

The "Rank" column is your skill rank (e.g. a.Master) not class as john_d says. Setting that to 12 will upset people.

**TimeBomb** · 29-07-09

This is a base file...
It has everything needed to make a rank-up bypass.
You need to get correct values from the database, and add more ifs.
Also, I am unsure if this bypass will work or not if you just update the style column. I think that a better idea would be to set all quests to finished that you would need to for going from rank 11 to rank 12.
Like I said, this is untested. Some of the variables are hypothetical, as I do not currently have access to a Cabal database, nor did I whilst writing this script.

For the quests finishing instead of ranking up by itself, you'd need something like this for each class:

Code:

	if ($row[rank] = 11)
	{
mssql_query("[query to finish one quest needed from r11->r12]")
	mssql_query("update DBO.cabal_character_table where Name =  '$char' set rank='12'")
	}
	else {echo "$char is not rank 11 and can not become rank  12.";}

[query to finish one quest needed from r11->r12] Where this code is you need to put a query needed to finish one of the quest IDs needed from rank 11 to 12. You'd need one of these queries for each quest needed to be finished [over 100 if I recall correctly]. Also, you need one of these if statements for each class [set the rank to rank 11 style number].

This code is for someone who has a basic knowledge of PHP and MSSQL queries. I am not going to release a full working script. This code is for people who just need some help starting out, or a template.

**Yamachi** · 29-07-09

While I'm in here, I'll give you a little more information on how the Rank column works. It's very simple; convert the number to hex. You'll end up with a 16 bit hex number. For example, 2570 (double trans) = 0x0A0A. The first byte is your sword rank, and the 2nd byte is your magic rank. If you wanted novice sword and trans magic, you'd have a hex number like this: 0x010A, which is 266 in decimal.

EDIT: I just read your last post, timebomb, and you're completely wrong. You don't need to do any quests in order to get class rank 12, and you don't need to edit the style column differently for every class. I'll give you a hint: convert the decimal value of the style column to binary. The last 3 bits define the class. I'll let you figure out the rest.

P.S. There'll be a guide to editing the style column on my wiki, which I'll post a link for once it's approved.

**bobinsset** · 29-07-09

hi,
there are more simple, give the quest for the nation.
To access other quests leveling.

my source code php :

$quest='0xb0200000000000000';
$updatequest=('update '.DB_GAM.'.dbo.cabal_questdata_table set Data='.$quest.' where CharacterIdx='.$idx );
mssql_query($updatequest) or die('Erreur SQL !'.$updatequest.','.mysql_error().'');

attention, clear other quest underway !

Diesel
(sorry for my english, im french)

**TimeBomb** · 04-08-09

Ok thanks to Yamachi, and some more browsing of ragezone, I have come up with a better script. It still may be a tad faulty, buggy, etc... so anyone who can test it and tell me the errors / fix it up please post here. Thanks, and good luck!

**TimeBomb** · 07-08-09

/bump and /update:
Newest code which includes a bit of sql injection protection as well as a pretty much fully working code is now on the main topic. My main problem now is that quests do not change upon ranking up. They go from rank 11 to 12 but their quests stay the same... they have to do all story quests to go from 12->13 now... any help or ideas? Thanks!

**Tommy1** · 07-08-09

Thanks alot.

~ TommY

**dragaobr** · 15-03-10

my erro is :

Not Found

The requested URL /bypassrankcabal.php was not found on this server.

80% Finished PHP Script to go from rank 11 to rank 12

Thread Tools

Search Thread

80% Finished PHP Script to go from rank 11 to rank 12

Re: 80% Finished PHP Script to go from rank 11 to rank 12

Re: 80% Finished PHP Script to go from rank 11 to rank 12

Re: 80% Finished PHP Script to go from rank 11 to rank 12

Re: 80% Finished PHP Script to go from rank 11 to rank 12

Re: 80% Finished PHP Script to go from rank 11 to rank 12

Re: 80% Finished PHP Script to go from rank 11 to rank 12

Re: 80% Finished PHP Script to go from rank 11 to rank 12

Re: 80% Finished PHP Script to go from rank 11 to rank 12

Re: 80% Finished PHP Script to go from rank 11 to rank 12

Re: 80% Finished PHP Script to go from rank 11 to rank 12

Re: 80% Finished PHP Script to go from rank 11 to rank 12

Advertisement