Worked Bola's API

Install
go Windows + R odbcad32.exe
add new Data source SQL Server Native Client 11.0 for each DB
View attachment 148128
edit server.ini ODBC = "SQL Server"> ODBC = "SQL Server Native Client 11.0"

Stills the same, I'm almost sure it's something about the API, I just don't know what.
 
Finally u got it work david
I wish, someone release a clean DB of Bola DB, i'm tired to truncate the tables.
 
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
 
Yes

Api DBError log:

[Sun, 28 Sep 2014 03:41:07 +0800] Error from DB:connect(): not pass
[Sun, 28 Sep 2014 03:41:07 +0800] Error from :login: n
[Sun, 28 Sep 2014 03:42:25 +0800] Error from DB:connect(): pass
[Sun, 28 Sep 2014 03:45:01 +0800] Error from DB:connect(): pass
[Sun, 28 Sep 2014 03:45:46 +0800] Error from DB:connect(): pass
[Sun, 28 Sep 2014 03:46:15 +0800] Error from DB:connect(): pass
[Sun, 28 Sep 2014 03:46:29 +0800] Error from DB:connect(): pass
[Sun, 28 Sep 2014 03:46:43 +0800] Error from DB:connect(): pass
[Sun, 28 Sep 2014 03:46:57 +0800] Error from DB:connect(): pass
[Sun, 28 Sep 2014 03:47:16 +0800] Error from DB:connect(): pass
[Sun, 28 Sep 2014 03:47:27 +0800] Error from DB:connect(): pass
[Sun, 28 Sep 2014 03:47:33 +0800] Error from DB:connect(): pass
[Sun, 28 Sep 2014 03:51:50 +0800] Error from DB:connect(): pass
[Sun, 28 Sep 2014 03:52:21 +0800] Error from DB:connect(): pass
[Sun, 28 Sep 2014 04:28:44 +0800] Error from DB:connect(): pass
[Sun, 28 Sep 2014 00:31:45 +0200] Error from DB:connect(): pass

hey, is this ur db error? look at the time.
 
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? Raiderz_2014-10-16_08-47-44 - Worked Bola's API - RaGEZONE Forums
 
me erro in web is :Notice: Undefined variable: HTTP_RAW_POST_DATA in C:\xampp\htdocs\api.raiderzbr.to\public_html\index.php on line 8
-1 failed -1 success 0 failed -1 failed Unknown Request
help me pleassss

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