Official Tutorial Center

ex visor
Loyal Member
Joined
May 17, 2007
Messages
2,738
Reaction score
939
Welcome to the official Tutorial Thread of the GunBound Section!



SETUP GunBound WC Guide
LAST UPDATE - DECEMBER, 22 2010


All files:



[ame="http://www.megaupload.com/?d=I97022IY"]NOTICE[/ame]

[ame="http://rapidshare.com/files/57217032/PartnerFix.exe"]Partner Agent[/ame]





1). Setting up your server
​


Install MySQL 4.x and configure an account with the username: root and no password (due to the default server configuration files - if you want to change this later you may do so).

You can use any MySQL Management System - for a quick DL of Apache 4.x click .

Create 4 database: admin, batch, gunbound, and user. Import the data from "DataBases" folder from the GunBound WC file.

There is really nothing to change in the database besides this one column. In the database GunBound, open the table applicationsetting and configure the following:

Notice & BaseURL: Your Server IP (either 127.0.0.1 -or- )
FullDownloadURL: Your Server IP/fetch.php

If you use another IP address rather than 127.0.0.1 you must add an account root for the new IP address:
​
Aaron - Official Tutorial Center - RaGEZONE Forums



2). Configure server settings

Go to Buddy Center. Find setting.txt. Configure all IP addresses with your MySQL IP (127.0.0.1 as default unless you changed it).

Go to Buddy Server. Find setting.txt. Configure all IP addresses with your MySQL IP (127.0.0.1 as default unless you changed it).

Go to the folders 8360 and 8363. Find setting.txt. Configure all IP addresses. DO NOT CHANGE THE ACCEPT LINE!

Once you've completed configuring the IP addresses use Partner Agent to reconfigure the 4 files.
When you open PartnerAgent browse through the server files and look for GunBoundServ3. If you've updated any MySQL Information (Usernames & Passwords) this will automatically update the MySQL Settings in your server files.

Now you can click Install Services and Start Server.

3). Setup Web Server

Install any webserver (there's EasyPHP in the above link).
Copy the nProtect Folder, GunBound Folder, and Fetch.php/.dll to your root folder (www)

When you update your Client your FETCH should look like this:

/nprotect
/fetch.php / /fetch.dll

4). Configure Client

Install the client. Once the client has been installed apply the patch. To apply the patch, you can either execute the file to path of your client, or you can drag & drop the files in the folder where your client has been downloaded.
---
Reconfigure NyxLauncher.INI

Code:
[NyxLauncher]
Url_Fetch=http://YOURIP/fetch.php
Url_ForgotPwd=http://www.yoursite.com/
Url_Signup=http://www.yoursite.com/register.html
Url_FindId=http://www.yoursite.com/
Url_Softnyx=http://www.yoursite.com/
Url_Ad=http://www.yoursite.com/
Ip=YOURIP
Port=8372
AppId=400
Version=401
CookieDomain=http://www.yoursite.com/
CookieName=Softnyx_Eng
LastGame=Gunbound

[Gunbound]
AppId=2101
Url_Notice=http://www.yoursite.com/notice/note_wc.htm
Url_ManualPatch=http://www.yoursite.com/
Url_FullDownload=http://www.yoursite.com/
Url_Fetch=http://YOURIP/fetch.php
---

When configuring GunBound.INI only configure:

IP=YourIP

---

VERY IMPORTANT STEP: Bypassing GameGuard.

Go to: Windows\System32\Drivers\etc\ open the file host.ics with notepad.
Insert the following lines. When you're done save the file as a read only file.

127.0.0.1 update.nprotect.com
127.0.0.1 update.nprotect.net
127.0.0.1 guard.gunbound.net

-- 127.0.0.1 can be changed to w.e IP your using

Make sure you backup the original host.ics before editing it.





Now Install and Start the server.
 
Last edited:
Re: WC-Tools/Guides/Files Update: 11/29/07

Gunbound-Force isn't but I can upload a patch that you can extract to C -> Gunbound WC
then it'll be english. But Grub.exe is 100% English (:<

EDIT: Here it is



Extract this to C -> Windows -> Gunbound WC then a pop-up will come up, click "Yes to All"
 
Re: WC-Tools/Guides/Files Update: 11/29/07

new GBTools [ OLD WEBSITE OF GBREVOLUTION, THE FIRST ]

- Bugs Fixed
- More pages added

preview ::alienmental:

NOTE: Screen shot of this in action in the attachment

I don't have in english, to download in portuguese :

download :
 

Attachments

  • gus - Official Tutorial Center - RaGEZONE Forums
    gus.webp
    60.5 KB · Views: 1,748
Last edited by a moderator:
Re: WC-Tools/Guides/Files Update: 11/29/07

Are you tired of all those useless accounts?
You try so hard, but its just no use to delete them one by one.
Well, your solution has finally come.
Try this script =].
It will delete all accounts that has not logged into your GunBound
WARNING: IT WILL DELETE ACCOUNTS UNUSED FOR SURE
This process might take a long time and could lag your GunBound and PC while executing.

PHP:
<?
set_time_limit(3600);

$SQL_User="root";
$SQL_Pass=" ";
$SQL_Host="127.0.0.1";
$SQL_Base="gunbound";

mysql_connect($SQL_Host,$SQL_User,$SQL_Pass);
mysql_select_db($SQL_Base);

$count = "0";
$row = mysql_query("SELECT * FROM `game` WHERE LastUpdateTime = '0000-00-00 00:00:00' ORDER BY Id ASC ");

while($data = mysql_fetch_array($row)){
mysql_query("DELETE FROM `buddylist` WHERE Id = '".$data['Id']."' ");
mysql_query("DELETE FROM `buddylist` WHERE Buddy = '".$data['Id']."' ");
mysql_query("DELETE FROM `cash` WHERE Id = '".$data['Id']."' ");
mysql_query("DELETE FROM `chest` WHERE Owner = '".$data['Id']."' ");
mysql_query("DELETE FROM `game` WHERE Id = '".$data['Id']."' ");
mysql_query("DELETE FROM `giftitem` WHERE Sender = '".$data['Id']."' ");
mysql_query("DELETE FROM `giftmsg` WHERE Sender = '".$data['Id']."' ");
mysql_query("DELETE FROM `gunwcuser` WHERE Id = '".$data['Id']."' ");
mysql_query("DELETE FROM `mobilerecord` WHERE Id = '".$data['Id']."' ");
mysql_query("DELETE FROM `receiptconsume` WHERE Id = '".$data['Id']."' ");
mysql_query("DELETE FROM `receiptgift` WHERE Id = '".$data['Id']."' ");
mysql_query("DELETE FROM `stagerecord` WHERE Id = '".$data['Id']."' ");
mysql_query("DELETE FROM `user` WHERE Id = '".$data['Id']."' ");

echo (" ".$data['Id']." <br>");
$count++;
}

echo (" <b>".$count." accounts deleted</b> ");

mysql_close();
?>
 
Re: WC-Tools/Guides/Files Update: 11/29/07

Does anybody know what error is this?:

Aaron - Official Tutorial Center - RaGEZONE Forums


Somebody Help-me PLEASE!
It's incorrect settings of your DB. You are using separated DBs (admin, batch, gunbound, users) instead of one.
Here's a little manual on how to merge those DBs into one.
I'm using phpMyAdmin.

1. Open your DB and press Export tab. Check or oncheck items under `Structure` and `Data` like on screenie.
howto#1 - Official Tutorial Center - RaGEZONE Forums
2. Copy generated text.
howto#2 - Official Tutorial Center - RaGEZONE Forums
3. Create new TEXT document in Wordpad or Notepad and paste the dump you've got.
howto#3 - Official Tutorial Center - RaGEZONE Forums
4. Do same as in #1 and #2 with the rest of Gunbound DBs and paste their dump into Wordpad. Save it with name "SQL.sql".
5. Now create new or existing DB (that will be your Gunbound DB) and go to Import tab. Select "SQL.sql" and press Go.
howto#4 - Official Tutorial Center - RaGEZONE Forums
6. Now change in all of your server's settings files DB name to your new DB's name.
 
Re: WC-Tools/Guides/Files Update: 11/29/07

Just use this as a web file people:

 
How to create new maps

The *.lnd files describe the outline of the land. A nonzero pixel value indicates that there is land there.

The *.img files contain the actual image data (foreground - frame 0, and background - frame 1).

The *1.img through *10.img (depending on the map itself) are animation frames for the animated background.

The p*.img files contain frames for the damage animations (fragments).

Each *1.img through *10.img (however many there are) has a corresponding epa animation descriptor which lists the frames used in each animation.

...where * is one of the map names { 'babo', 'brick', 'candy', 'cave', 'facky', 'hok', 'kettle', 'last', 'metro', 'mos', 'star' }.

"B-side" maps have the same background but a different land and thus a *b.img containing one frame with the different land detail. There is a corresponding *b.lnd with the land outline.

Open up InsideGB and explore around with it if the above information does not seem clear. It will become so gradually.

Credits: Username1

PS: You
 
Re: How to create new maps

IMG format
download attached file!
 

Attachments

[Tutorial] Changing title.img in Grafics.xfs

Programs needed:
-----------------------------------

Hex Editor + Header.hdr
-
iXFS -
Adobe Photoshop -
-----------------------------------

Step 1
--> Go to photoshop and create an image 800x600 edit as you want then do the following process:
Take a vertical flip the image ...

Aaron - Official Tutorial Center - RaGEZONE Forums


--> After going on Save As, select the format (*.BMP, *.DIB) and save with the name of IMG.
--> In the window will open then click Advanced Options and place the following settings.

Aaron - Official Tutorial Center - RaGEZONE Forums




Step 2
--> Open the file that you created in IMG.bmp Hex Workshop and select the first 72 pairs of numbers and without then delete them. as the image below:

Aaron - Official Tutorial Center - RaGEZONE Forums


--> After deleting the first 72 pairs of numbers going on File> Save


Step 3
> Now join the Archive header.hdr with Img.bmp by the following process:

-- Va Starts in >Programs Accessories>Command Prompt
-- Put the files in the folder header.hdr and Img.bmp the path indicated in Command Prompt in my case is

C:\Documents and Settings\Administrator

-- Now Create the file logomode.img through the following command in Command Prompt:

copy /b header.hdr+img.bmp title.img

Step 4
--> Open iXFS
--> Open graphics.xfs in iXFS, import the file title.img (in the folder will be shown in Command Prompt) that you created and give Finalize archive.

Ready now so get in your Gb and give the new logo of entry.

PS: The same process can be done to create the files logomode.img, titlemode.img just at 3 step you change the file name to the desired output.

Ex.: copy /b header.hdr+img.bmp title.img

title.img > Screen GunboundWC

Cr
 
Re: [Tutorial Center]

*** if your gonna make a tutorial make it readable at least, this **** is filled with random bullshit something a bafoon will write.

* Edited by MasterOfSky *

If you take a careful look, each reply is a tutorial, like it should be. If you're not smart enough to notice it, I'm sorry for you and I sincerely think your keyboard is packed, for you not drooling on it +_+

:2gunsfiring_v1:
 
Last edited by a moderator:
New Ranking Script (For those new ranks)

I think i'll get a sticky for this one
u better watch this MasterOfSky

total rank
PHP:
<?php
set_time_limit(1200);
#How Many
$rk[36]="1";
$rk[35]="1";
$rk[34]="1";
$rk[33]="3";
$rk[32]="3";
$rk[31]="5";
#Percentage
$rk[30]="0.1";
$rk[29]="1";
$rk[28]="3";
$rk[27]="6";
$rk[26]="10";
$rk[25]="20";
$rk[24]="30";
$rk[23]="40";
$rk[22]="50";
$rk[21]="60";
$rk[20]="70";
$rk[19]="80";
$rk[18]="90";
#GP
$rk[17]="15000";
$rk[16]="13000";
$rk[15]="12000";
$rk[14]="11000";
$rk[13]="10000";
$rk[12]="8800";
$rk[11]="7900";
$rk[10]="7000";
$rk[9]="6200";
$rk[8]="5400";
$rk[7]="4700";
$rk[6]="4000";
$rk[5]="3500";
$rk[4]="3000";
$rk[3]="2600";
$rk[2]="2200";
$rk[1]="1900";
$rk[0]="1600";
$rk[-1]="1400";
$rk[-2]="1200";
$rk[-3]="1100";
$rk[-4]="0";
mysql_connect('127.0.0.1','user','pass');
mysql_select_db('gunbound');
$info = mysql_query("SELECT Id, TotalScore, TotalGrade FROM game WHERE NoRankUpdate = '0' AND LastUpdateTime != '0000-00-00' ORDER BY TotalScore DESC");
$count=0;
while($row= mysql_fetch_array($info)){
$count++;
 
 mysql_query("UPDATE `game` SET TotalRank = '".$count."' WHERE Id = '".$row['Id']."' ");
 if($row['TotalGrade'] >= "-4" && $row['TotalGrade'] <= "36"){
  if($count == $rk[36]){
  mysql_query("UPDATE `game` SET TotalGrade = '36' WHERE Id = '".$row['Id']."' ");
  $h_grade = "36";
  }
  if($count > $rk[35] && $count <= ($rk[36] + $rk[35]) ){
  mysql_query("UPDATE `game` SET TotalGrade = '35' WHERE Id = '".$row['Id']."' ");
  $h_grade = "35";
  }
  if($count > ($rk[36] + $rk[35]) && $count <= ($rk[36] + $rk[35] + $rk[34]) ){
  mysql_query("UPDATE `game` SET TotalGrade = '34' WHERE Id = '".$row['Id']."' ");
  $h_grade = "34";
  }
 
  if($count > ($rk[36] + $rk[35] + $rk[34]) && $count <= ($rk[36] + $rk[35] + $rk[34] + $rk[33]) ){
  mysql_query("UPDATE `game` SET TotalGrade = '33' WHERE Id = '".$row['Id']."' ");
  $h_grade = "33";
  }
 
  if($count > ($rk[36] + $rk[35] + $rk[34] + $rk[33]) && $count <= ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32]) ){
  mysql_query("UPDATE `game` SET TotalGrade = '32' WHERE Id = '".$row['Id']."' ");
  $h_grade = "32";
  }
 
  if($count > ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32]) && $count <= ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32] + $rk[31]) ){
  mysql_query("UPDATE `game` SET TotalGrade = '31' WHERE Id = '".$row['Id']."' ");
  $h_grade = "31";
  }
  if ($count == ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32] + $rk[31]) ){
  $max = $row['TotalScore'];
  }
  if($count > ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32] + $rk[31]) ){
   for($rank = "30"; $rank >= "-4" && $rank <= "30"; $rank--){
    if($rank >= "18"){
    $update = ($max-($rk[$rank]*$max/100));
    } else {
    $update = $rk[$rank];
    }
    if($row['TotalScore'] >= $update){
    mysql_query("UPDATE `game` SET TotalGrade = '".$rank."' WHERE Id = '".$row['Id']."' ");
    break;
    }
   }
  }
 }
echo (" <b>No:</b> ".$count."  <b>Name:</b> ".$row['Id']." <b>GP:</b> ".$row['TotalScore']." <br> ");
}
?>

country rank
PHP:
<?php
set_time_limit(1200);
#How Many
$rk[36]="1";
$rk[35]="1";
$rk[34]="1";
$rk[33]="3";
$rk[32]="3";
$rk[31]="5";
#Percentage
$rk[30]="0.1";
$rk[29]="1";
$rk[28]="3";
$rk[27]="6";
$rk[26]="10";
$rk[25]="20";
$rk[24]="30";
$rk[23]="40";
$rk[22]="50";
$rk[21]="60";
$rk[20]="70";
$rk[19]="80";
$rk[18]="90";
#GP
$rk[17]="15000";
$rk[16]="13000";
$rk[15]="12000";
$rk[14]="11000";
$rk[13]="10000";
$rk[12]="8800";
$rk[11]="7900";
$rk[10]="7000";
$rk[9]="6200";
$rk[8]="5400";
$rk[7]="4700";
$rk[6]="4000";
$rk[5]="3500";
$rk[4]="3000";
$rk[3]="2600";
$rk[2]="2200";
$rk[1]="1900";
$rk[0]="1600";
$rk[-1]="1400";
$rk[-2]="1200";
$rk[-3]="1100";
$rk[-4]="0";
mysql_connect('127.0.0.1','user','pass');
mysql_select_db('gunbound');
for($country = "1"; $country <= "245"; $country++){
$info = mysql_query("SELECT Id, TotalScore, CountryGrade FROM game WHERE Country = '".$country."' AND NoRankUpdate = '0' AND LastUpdateTime != '0000-00-00' ORDER BY TotalScore DESC");
$crank = "0";
$count= "0";
if(mysql_num_rows($info) != "0"){
while($row= mysql_fetch_array($info)){
$crank++;
 
 mysql_query("UPDATE `game` SET CountryRank = '".$crank."' WHERE Id = '".$row['Id']."' ");
 if($row['CountryGrade'] >= "-4" && $row['CountryGrade'] <= "36"){
  $count++;
 
  if($count == $rk[36]){
  mysql_query("UPDATE `game` SET CountryGrade = '36' WHERE Id = '".$row['Id']."' ");
  $h_grade = "36";
  }
  if($count > $rk[35] && $count <= ($rk[36] + $rk[35]) ){
  mysql_query("UPDATE `game` SET CountryGrade = '35' WHERE Id = '".$row['Id']."' ");
  $h_grade = "35";
  }
  if($count > ($rk[36] + $rk[35]) && $count <= ($rk[36] + $rk[35] + $rk[34]) ){
  mysql_query("UPDATE `game` SET CountryGrade = '34' WHERE Id = '".$row['Id']."' ");
  $h_grade = "34";
  }
 
  if($count > ($rk[36] + $rk[35] + $rk[34]) && $count <= ($rk[36] + $rk[35] + $rk[34] + $rk[33]) ){
  mysql_query("UPDATE `game` SET CountryGrade = '33' WHERE Id = '".$row['Id']."' ");
  $h_grade = "33";
  }
 
  if($count > ($rk[36] + $rk[35] + $rk[34] + $rk[33]) && $count <= ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32]) ){
  mysql_query("UPDATE `game` SET CountryGrade = '32' WHERE Id = '".$row['Id']."' ");
  $h_grade = "32";
  }
 
  if($count > ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32]) && $count <= ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32] + $rk[31]) ){
  mysql_query("UPDATE `game` SET CountryGrade = '31' WHERE Id = '".$row['Id']."' ");
  $h_grade = "31";
  }
  if ($count == ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32] + $rk[31]) ){
  $max = $row['TotalScore'];
  }
  if($count > ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32] + $rk[31]) ){
   for($rank = "30"; $rank >= "-4" && $rank <= "30"; $rank--){
    if($rank >= "18"){
    $update = ($max-($rk[$rank]*$max/100));
    } else {
    $update = $rk[$rank];
    }
    if($row['TotalScore'] >= $update){
    mysql_query("UPDATE `game` SET CountryGrade = '".$rank."' WHERE Id = '".$row['Id']."' ");
    break;
    }
   }
  }
 }
echo (" <b>No:</b> ".$count."  <b>Name:</b> ".$row['Id']." <b>GP:</b> ".$row['TotalScore']." <br> ");
}
}
}
?>

of course u can edit them as u wish
like how many people u want for that certain rank
or the percentage of GP after the $rk[31] GPs
or the GP for the rest of the rank
OR...! make your own script if u dont want mine =]
 
Re: New Ranking Script (For those new ranks)

well
i knew that but i thought it was WAY too much GP so i based it off by percentages
and about putting TotalRank in the same Query as TotalGrade
well.. i just made an increment on $count and just updated the users rank by the order of TotalScore =]
the script is super fast (at least for me)
i really dont understand what u mean about putting TotalRank in the same query as TotalGrade =] (i think including TotalRank to the query and excluding an update if the rank is still the same, who knows =]?)

Here's a test. With your script:
Affected rows: 257281
Time: 246.284ms

..And then with a slight modification in which I made:
Affected rows: 257282
Time: 116.422ms

You see, for every user, it's doing the first TotalRank query, then the TotalGrade query. With the modification I made to it, it's now doing it all in one query, therefore the script will go about twice as fast, with half the processing power on MySQL.

To make it more memory efficient as well, kill the echo at the end of the script.

Enjoy:

PHP:
<?php
set_time_limit(1200);
#How Many
$rk[36]="1";
$rk[35]="1";
$rk[34]="1";
$rk[33]="3";
$rk[32]="3";
$rk[31]="5";
#Percentage
$rk[30]="0.1";
$rk[29]="1";
$rk[28]="3";
$rk[27]="6";
$rk[26]="10";
$rk[25]="20";
$rk[24]="30";
$rk[23]="40";
$rk[22]="50";
$rk[21]="60";
$rk[20]="70";
$rk[19]="80";
$rk[18]="90";
#GP
$rk[17]="15000";
$rk[16]="13000";
$rk[15]="12000";
$rk[14]="11000";
$rk[13]="10000";
$rk[12]="8800";
$rk[11]="7900";
$rk[10]="7000";
$rk[9]="6200";
$rk[8]="5400";
$rk[7]="4700";
$rk[6]="4000";
$rk[5]="3500";
$rk[4]="3000";
$rk[3]="2600";
$rk[2]="2200";
$rk[1]="1900";
$rk[0]="1600";
$rk[-1]="1400";
$rk[-2]="1200";
$rk[-3]="1100";
$rk[-4]="0";
mysql_connect('127.0.0.1','user','pass');
mysql_select_db('gunbound');
$info = mysql_query("SELECT Id, TotalScore, TotalGrade FROM game WHERE NoRankUpdate = '0' AND LastUpdateTime != '0000-00-00' ORDER BY TotalScore DESC");
$count=0;
while($row= mysql_fetch_array($info)){
$count++;
 if($row['TotalGrade'] >= "-4" && $row['TotalGrade'] <= "36"){
  if($count == $rk[36]){
  mysql_query("UPDATE `game` SET TotalGrade = '36',TotalRank = '".$count."' WHERE Id = '".$row['Id']."' ");
  $h_grade = "36";
  }
  if($count > $rk[35] && $count <= ($rk[36] + $rk[35]) ){
  mysql_query("UPDATE `game` SET TotalGrade = '35',TotalRank = '".$count."' WHERE Id = '".$row['Id']."' ");
  $h_grade = "35";
  }
  if($count > ($rk[36] + $rk[35]) && $count <= ($rk[36] + $rk[35] + $rk[34]) ){
  mysql_query("UPDATE `game` SET TotalGrade = '34',TotalRank = '".$count."' WHERE Id = '".$row['Id']."' ");
  $h_grade = "34";
  }
 
  if($count > ($rk[36] + $rk[35] + $rk[34]) && $count <= ($rk[36] + $rk[35] + $rk[34] + $rk[33]) ){
  mysql_query("UPDATE `game` SET TotalGrade = '33',TotalRank = '".$count."' WHERE Id = '".$row['Id']."' ");
  $h_grade = "33";
  }
 
  if($count > ($rk[36] + $rk[35] + $rk[34] + $rk[33]) && $count <= ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32]) ){
  mysql_query("UPDATE `game` SET TotalGrade = '32',TotalRank = '".$count."' WHERE Id = '".$row['Id']."' ");
  $h_grade = "32";
  }
 
  if($count > ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32]) && $count <= ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32] + $rk[31]) ){
  mysql_query("UPDATE `game` SET TotalGrade = '31',TotalRank = '".$count."' WHERE Id = '".$row['Id']."' ");
  $h_grade = "31";
  }
  if ($count == ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32] + $rk[31]) ){
  $max = $row['TotalScore'];
  }
  if($count > ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32] + $rk[31]) ){
   for($rank = "30"; $rank >= "-4" && $rank <= "30"; $rank--){
    if($rank >= "18"){
    $update = ($max-($rk[$rank]*$max/100));
    } else {
    $update = $rk[$rank];
    }
    if($row['TotalScore'] >= $update){
    mysql_query("UPDATE `game` SET TotalGrade = '".$rank."',TotalRank = '".$count."' WHERE Id = '".$row['Id']."' ");
    break;
    }
   }
  }
 }
echo (" <b>No:</b> ".$count."  <b>Name:</b> ".$row['Id']." <b>GP:</b> ".$row['TotalScore']." <br> ");
}
?>
 
Re: [Tutorial Center]

Hi all. Why I cant launch the game, starting button does not work. Help me please

"HOW TO START GAMES:
/shrduatlwkr
note: You have to be room master. Use this for "un-fair" games or if your start button doesn't work :p"

my english is bad and I do not understand that is here written. Explain for me comprehensible please, if possible that in picture. thx
 
Re: [Tutorial Center]Finding Avatar Codes

MasterOfSky said:
Ok people... I know most of you have been willing to learn this for a long time, and like 99,9% of the leechers here doesn
 
Re: WC-Tools/Guides/Files Update: 11/29/07

Are you tired of all those useless accounts?
You try so hard, but its just no use to delete them one by one.
Well, your solution has finally come.
Try this script =].
It will delete all accounts that has not logged into your GunBound
WARNING: IT WILL DELETE ACCOUNTS UNUSED FOR SURE
This process might take a long time and could lag your GunBound and PC while executing.

PHP:
<?
set_time_limit(3600);

$SQL_User="root";
$SQL_Pass=" ";
$SQL_Host="127.0.0.1";
$SQL_Base="gunbound";

mysql_connect($SQL_Host,$SQL_User,$SQL_Pass);
mysql_select_db($SQL_Base);

$count = "0";
$row = mysql_query("SELECT * FROM `game` WHERE LastUpdateTime = '0000-00-00 00:00:00' ORDER BY Id ASC ");

while($data = mysql_fetch_array($row)){
mysql_query("DELETE FROM `buddylist` WHERE Id = '".$data['Id']."' ");
mysql_query("DELETE FROM `buddylist` WHERE Buddy = '".$data['Id']."' ");
mysql_query("DELETE FROM `cash` WHERE Id = '".$data['Id']."' ");
mysql_query("DELETE FROM `chest` WHERE Owner = '".$data['Id']."' ");
mysql_query("DELETE FROM `game` WHERE Id = '".$data['Id']."' ");
mysql_query("DELETE FROM `giftitem` WHERE Sender = '".$data['Id']."' ");
mysql_query("DELETE FROM `giftmsg` WHERE Sender = '".$data['Id']."' ");
mysql_query("DELETE FROM `gunwcuser` WHERE Id = '".$data['Id']."' ");
mysql_query("DELETE FROM `mobilerecord` WHERE Id = '".$data['Id']."' ");
mysql_query("DELETE FROM `receiptconsume` WHERE Id = '".$data['Id']."' ");
mysql_query("DELETE FROM `receiptgift` WHERE Id = '".$data['Id']."' ");
mysql_query("DELETE FROM `stagerecord` WHERE Id = '".$data['Id']."' ");
mysql_query("DELETE FROM `user` WHERE Id = '".$data['Id']."' ");

echo (" ".$data['Id']." <br>");
$count++;
}

echo (" <b>".$count." accounts deleted</b> ");

mysql_close();
?>

Modified version for GBTH:

PHP:
<?

include "config.php";

if($_SERVER["REMOTE_ADDR"] == "127.0.0.1"){

set_time_limit(3600);

$count = "0";
$row = mysql_query("SELECT * FROM `game` WHERE LastUpdateTime = '0000-00-00 00:00:00' ORDER BY Id ASC ");

while($data = mysql_fetch_array($row)){
mysql_query("DELETE FROM `buddylist` WHERE Id = '".$data['Id']."' ") or die(mysql_error());
mysql_query("DELETE FROM `buddylist` WHERE Buddy = '".$data['Id']."' ") or die(mysql_error());
mysql_query("DELETE FROM `cash` WHERE Id = '".$data['Id']."' ") or die(mysql_error());
mysql_query("DELETE FROM `game` WHERE Id = '".$data['Id']."' ") or die(mysql_error());
mysql_query("DELETE FROM `receiptgift` WHERE Id = '".$data['Id']."' ") or die(mysql_error());
mysql_query("DELETE FROM `user` WHERE Id = '".$data['Id']."' ") or die(mysql_error());

echo (" ".$data['Id']." deleted<br>");
$count++;
}

echo (" <b>".$count." accounts deleted</b> ");
} else {
"OLD MACDONALD HAD A FARM, EE EYE EE EYE OOHH!";

}

?>
 
Back