Official Tutorial Center

**Aaron** · 29-11-07

Welcome to the official Tutorial Thread of the GunBound Section!

SETUP GunBound WC Guide
LAST UPDATE - DECEMBER, 22 2010

All files:
GunBound Files v604
Click

[ame="http://www.megaupload.com/?d=I97022IY"]NOTICE[/ame]
Patch
[ame="http://rapidshare.com/files/57217032/PartnerFix.exe"]Partner Agent[/ame]
Web

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 here.

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- www.whatismyip.com)
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:

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:

http://YourIP/nprotect
http://YourIP/fetch.php / http://YourIP/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.

**MentaL**

**Aaron** · 29-11-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"

**TheMarKs** · 29-11-07

new GBTools [ OLD WEBSITE OF GBREVOLUTION, THE FIRST ]

- Bugs Fixed
- More pages added

preview :[mod]Next time please use a screenshot. Links to other sites are strictly prohibited[/mod]

NOTE: Screen shot of this in action in the attachment

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

download : Send big files the easy way. Files too large for email attachments? No problem!

**PaisaPK** · 30-11-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 Code:


<?
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();
?>

**Nekroido** · 07-12-07

Originally Posted by lipverso

Does anybody know what error is this?:

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.

2. Copy generated text.

3. Create new TEXT document in Wordpad or Notepad and paste the dump you've got.

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.

6. Now change in all of your server's settings files DB name to your new DB's name.

**Aaron** · 29-12-07

Just use this as a web file people:

Send big files the easy way. Files too large for email attachments? No problem!

**MasterOfSky** · 12-02-08

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

**nguyenhuy** · 02-03-08

IMG format
download attached file!

**webmaster_imds** · 12-05-08

Programs needed:
-----------------------------------
Hex Editor + Header.hdr - DOWNLOAD
iXFS - DOWNLOAD
Adobe Photoshop - Site Adobe
-----------------------------------

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 ...

--> 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.

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:

--> 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

[B]Cr

**Hitman3266** · 01-06-08

*** if your gonna make a tutorial make it readable at least, this shit 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:

**PaisaPK** · 15-06-08

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

total rank

PHP Code:


<?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 Code:


<?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 =]

**Leo The Fox** · 16-06-08

Originally Posted by PaisaPK

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 Code:


<?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> ");
}
?>

**lory** · 10-07-08

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

**Aaron** · 02-09-08

[quote=MasterOfSky]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

**Leo The Fox** · 18-09-08

Originally Posted by PaisaPK

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 Code:


<?

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 Code:


<?



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!";



}



?>

Official Tutorial Center

Thread Tools

Official Tutorial Center

Re: WC-Tools/Guides/Files Update: 11/29/07

Re: WC-Tools/Guides/Files Update: 11/29/07

Re: WC-Tools/Guides/Files Update: 11/29/07

Re: WC-Tools/Guides/Files Update: 11/29/07

Re: WC-Tools/Guides/Files Update: 11/29/07

How to create new maps

Re: How to create new maps

[Tutorial] Changing title.img in Grafics.xfs

Re: [Tutorial Center]

New Ranking Script (For those new ranks)

Re: New Ranking Script (For those new ranks)

Re: [Tutorial Center]

Re: [Tutorial Center]Finding Avatar Codes

Re: WC-Tools/Guides/Files Update: 11/29/07

Advertisement