- Joined
- Jun 22, 2012
- Messages
- 288
- Reaction score
- 28
Stills the same, I'm almost sure it's something about the API, I just don't know what.
Most visitors online was 8830 , on 6 Feb 2024
Worked Bola's API
- Thread starter gda123123
- Start date
Stills the same, I'm almost sure it's something about the API, I just don't know what.
- Joined
- Oct 14, 2010
- Messages
- 470
- Reaction score
- 20
no, just log in "sara"1234"" with out editing the xamp
- Joined
- Jun 22, 2012
- Messages
- 288
- Reaction score
- 28
Thanks man, I managed to get in game finally! xD, I've reinstalled the xampp and now it works with any account I made. Thanks for all the help guys! <3
- Joined
- Jul 8, 2008
- Messages
- 306
- Reaction score
- 338
Well done Davidsonjp 
I hope someone has the MRF tool that works well with the BOLA Client and will share it so we can edit and translate it
I hope someone has the MRF tool that works well with the BOLA Client and will share it so we can edit and translate it- Joined
- Oct 14, 2010
- Messages
- 470
- Reaction score
- 20
Finally u got it work david
I wish, someone release a clean DB of Bola DB, i'm tired to truncate the tables.
I wish, someone release a clean DB of Bola DB, i'm tired to truncate the tables.
- Joined
- Jul 8, 2008
- Messages
- 306
- Reaction score
- 338
Execute this query to truncate all tables (even with constraint) in a DB :
/* TRUNCATE ALL TABLES IN A DATABASE */
DECLARE DropAndCreateConstraintsTable TABLE
(
DropStmt VARCHAR(MAX)
,CreateStmt VARCHAR(MAX)
)
/* Gather information to drop and then recreate the current foreign key constraints */
INSERT DropAndCreateConstraintsTable
SELECT DropStmt = 'ALTER TABLE [' + ForeignKeys.ForeignTableSchema
+ '].[' + ForeignKeys.ForeignTableName + '] DROP CONSTRAINT ['
+ ForeignKeys.ForeignKeyName + ']; '
,CreateStmt = 'ALTER TABLE [' + ForeignKeys.ForeignTableSchema
+ '].[' + ForeignKeys.ForeignTableName
+ '] WITH CHECK ADD CONSTRAINT [' + ForeignKeys.ForeignKeyName
+ '] FOREIGN KEY([' + ForeignKeys.ForeignTableColumn
+ ']) REFERENCES [' + SCHEMA_NAME(sys.objects.schema_id)
+ '].[' + sys.objects.[name] + ']([' + sys.columns.[name]
+ ']); '
FROM sys.objects
INNER JOIN sys.columns
ON ( sys.columns.[object_id] = sys.objects.[object_id] )
INNER JOIN ( SELECT sys.foreign_keys.[name] AS ForeignKeyName
,SCHEMA_NAME(sys.objects.schema_id) AS ForeignTableSchema
,sys.objects.[name] AS ForeignTableName
,sys.columns.[name] AS ForeignTableColumn
,sys.foreign_keys.referenced_object_id AS referenced_object_id
,sys.foreign_key_columns.referenced_column_id AS referenced_column_id
FROM sys.foreign_keys
INNER JOIN sys.foreign_key_columns
ON ( sys.foreign_key_columns.constraint_object_id = sys.foreign_keys.[object_id] )
INNER JOIN sys.objects
ON ( sys.objects.[object_id] = sys.foreign_keys.parent_object_id )
INNER JOIN sys.columns
ON ( sys.columns.[object_id] = sys.objects.[object_id] )
AND ( sys.columns.column_id = sys.foreign_key_columns.parent_column_id )
) ForeignKeys
ON ( ForeignKeys.referenced_object_id = sys.objects.[object_id] )
AND ( ForeignKeys.referenced_column_id = sys.columns.column_id )
WHERE ( sys.objects.[type] = 'U' )
AND ( sys.objects.[name] NOT IN ( 'sysdiagrams' ) )
/* SELECT * FROM DropAndCreateConstraintsTable AS DACCT --Test statement*/
DECLARE dropstatement NVARCHAR(MAX)
DECLARE recreateStatement NVARCHAR(MAX)
/* Drop Constraints */
DECLARE Cur1 CURSOR READ_ONLY
FOR
SELECT DropStmt
FROM DropAndCreateConstraintsTable
OPEN Cur1
FETCH NEXT FROM Cur1 INTO dropstatement
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT 'Executing ' + dropstatement
EXECUTE sp_executesql dropstatement
FETCH NEXT FROM Cur1 INTO dropstatement
END
CLOSE Cur1
DEALLOCATE Cur1
/* Truncate all tables in the database in the dbo schema */
DECLARE DeleteTableStatement NVARCHAR(MAX)
DECLARE Cur2 CURSOR READ_ONLY
FOR
SELECT 'TRUNCATE TABLE [dbo].[' + TABLE_NAME + ']'
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'dbo'
AND TABLE_TYPE = 'BASE TABLE'
/* Change your schema appropriately if you don't want to use dbo */
OPEN Cur2
FETCH NEXT FROM Cur2 INTO DeleteTableStatement
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT 'Executing ' + DeleteTableStatement
EXECUTE sp_executesql DeleteTableStatement
FETCH NEXT FROM Cur2 INTO DeleteTableStatement
END
CLOSE Cur2
DEALLOCATE Cur2
/* Recreate foreign key constraints */
DECLARE Cur3 CURSOR READ_ONLY
FOR
SELECT CreateStmt
FROM DropAndCreateConstraintsTable
OPEN Cur3
FETCH NEXT FROM Cur3 INTO recreateStatement
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT 'Executing ' + recreateStatement
EXECUTE sp_executesql recreateStatement
FETCH NEXT FROM Cur3 INTO recreateStatement
END
CLOSE Cur3
DEALLOCATE Cur3
GO
/* TRUNCATE ALL TABLES IN A DATABASE */
DECLARE DropAndCreateConstraintsTable TABLE
(
DropStmt VARCHAR(MAX)
,CreateStmt VARCHAR(MAX)
)
/* Gather information to drop and then recreate the current foreign key constraints */
INSERT DropAndCreateConstraintsTable
SELECT DropStmt = 'ALTER TABLE [' + ForeignKeys.ForeignTableSchema
+ '].[' + ForeignKeys.ForeignTableName + '] DROP CONSTRAINT ['
+ ForeignKeys.ForeignKeyName + ']; '
,CreateStmt = 'ALTER TABLE [' + ForeignKeys.ForeignTableSchema
+ '].[' + ForeignKeys.ForeignTableName
+ '] WITH CHECK ADD CONSTRAINT [' + ForeignKeys.ForeignKeyName
+ '] FOREIGN KEY([' + ForeignKeys.ForeignTableColumn
+ ']) REFERENCES [' + SCHEMA_NAME(sys.objects.schema_id)
+ '].[' + sys.objects.[name] + ']([' + sys.columns.[name]
+ ']); '
FROM sys.objects
INNER JOIN sys.columns
ON ( sys.columns.[object_id] = sys.objects.[object_id] )
INNER JOIN ( SELECT sys.foreign_keys.[name] AS ForeignKeyName
,SCHEMA_NAME(sys.objects.schema_id) AS ForeignTableSchema
,sys.objects.[name] AS ForeignTableName
,sys.columns.[name] AS ForeignTableColumn
,sys.foreign_keys.referenced_object_id AS referenced_object_id
,sys.foreign_key_columns.referenced_column_id AS referenced_column_id
FROM sys.foreign_keys
INNER JOIN sys.foreign_key_columns
ON ( sys.foreign_key_columns.constraint_object_id = sys.foreign_keys.[object_id] )
INNER JOIN sys.objects
ON ( sys.objects.[object_id] = sys.foreign_keys.parent_object_id )
INNER JOIN sys.columns
ON ( sys.columns.[object_id] = sys.objects.[object_id] )
AND ( sys.columns.column_id = sys.foreign_key_columns.parent_column_id )
) ForeignKeys
ON ( ForeignKeys.referenced_object_id = sys.objects.[object_id] )
AND ( ForeignKeys.referenced_column_id = sys.columns.column_id )
WHERE ( sys.objects.[type] = 'U' )
AND ( sys.objects.[name] NOT IN ( 'sysdiagrams' ) )
/* SELECT * FROM DropAndCreateConstraintsTable AS DACCT --Test statement*/
DECLARE dropstatement NVARCHAR(MAX)
DECLARE recreateStatement NVARCHAR(MAX)
/* Drop Constraints */
DECLARE Cur1 CURSOR READ_ONLY
FOR
SELECT DropStmt
FROM DropAndCreateConstraintsTable
OPEN Cur1
FETCH NEXT FROM Cur1 INTO dropstatement
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT 'Executing ' + dropstatement
EXECUTE sp_executesql dropstatement
FETCH NEXT FROM Cur1 INTO dropstatement
END
CLOSE Cur1
DEALLOCATE Cur1
/* Truncate all tables in the database in the dbo schema */
DECLARE DeleteTableStatement NVARCHAR(MAX)
DECLARE Cur2 CURSOR READ_ONLY
FOR
SELECT 'TRUNCATE TABLE [dbo].[' + TABLE_NAME + ']'
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'dbo'
AND TABLE_TYPE = 'BASE TABLE'
/* Change your schema appropriately if you don't want to use dbo */
OPEN Cur2
FETCH NEXT FROM Cur2 INTO DeleteTableStatement
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT 'Executing ' + DeleteTableStatement
EXECUTE sp_executesql DeleteTableStatement
FETCH NEXT FROM Cur2 INTO DeleteTableStatement
END
CLOSE Cur2
DEALLOCATE Cur2
/* Recreate foreign key constraints */
DECLARE Cur3 CURSOR READ_ONLY
FOR
SELECT CreateStmt
FROM DropAndCreateConstraintsTable
OPEN Cur3
FETCH NEXT FROM Cur3 INTO recreateStatement
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT 'Executing ' + recreateStatement
EXECUTE sp_executesql recreateStatement
FETCH NEXT FROM Cur3 INTO recreateStatement
END
CLOSE Cur3
DEALLOCATE Cur3
GO
- Joined
- Oct 14, 2010
- Messages
- 470
- Reaction score
- 20
NC respond thx
- Joined
- Jun 22, 2012
- Messages
- 288
- Reaction score
- 28
You guys know how to change server rates?
- Joined
- Oct 14, 2010
- Messages
- 470
- Reaction score
- 20
edit System > LevelTable.xml ?
- Joined
- Jun 22, 2012
- Messages
- 288
- Reaction score
- 28
Editing this will only change the amount of exp required to the next level, what I mean is the exp, drop, drop amounts rate.
- Joined
- Oct 14, 2010
- Messages
- 470
- Reaction score
- 20
Edit bpart_reward, loot_global, randombox and recipe
- Joined
- Mar 4, 2009
- Messages
- 119
- Reaction score
- 5
hey, is this ur db error? look at the time.
- Joined
- Jun 22, 2012
- Messages
- 288
- Reaction score
- 28
- Joined
- Nov 27, 2012
- Messages
- 78
- Reaction score
- 5
ok i got it but levelTable.xml max 35 no 50 how to use and mobs level max 34 how to use level 50 or high lvl and mobs and gm command?
- Joined
- Jun 22, 2012
- Messages
- 288
- Reaction score
- 28
You can use showgmt, it'll open a tool where you can add items, skills, and all that stuff.
Shh, quiet, you might piss somebody off
Developer
- Joined
- Dec 23, 2011
- Messages
- 1,797
- Reaction score
- 2,161
is coded in game server, use ida and 010 hex editor to found
where game server ??
- Joined
- May 8, 2011
- Messages
- 150
- Reaction score
- 86
Read before you ask...
I already said, you should never visit the API by "BROWSER".
If you visit API without giving it the necessary variable,it shows failed.
API is for program to access the SQL database,NOT FOR HUMAN.
- Joined
- Dec 14, 2009
- Messages
- 132
- Reaction score
- 8
oww Finaly Server ok
very thanks much all
very thanks much all
Last edited:
RaGEZONE Sponsor
