Julianx's Shopping Center!

[phc_chaos]

I'm sorry for this being totally irrelevant, but I don't have time for another page to load and I gtg. But, Phc, if you want to be looked at as a religious type, get the bible phrase right. It's not "if you deny me in front of your friends'. It's "if you deny me before man." Don't act like you stand up for something and screw it up along the way.

you just made my freakin day.. i just laughed at that comment..
besides I didnt mean to post it and it was from a "myspace" bulletin from one of my friends.

Dude I've read the bible about 50 times so dont blame me for the actions of my friends


:banghead:

[Mesmoras]

Well then catch the error and fix it :squint:

[phc_chaos]

Well then catch the error and fix it :squint:

blah

:l2p:

[killerkid3029]

I tryed i this thing i have an antirx sever and it wont work it comes up with an error can can only get half of it maby im not putting it in the right place or something plz tell me what im doing rong?

[Froogle]

Try using Julian's old mall, I made my fix for the latest Ascent cores. Sorry mate

[Fronix]

I get an super wired error LOL!

Query:
ALTER TABLE realmlist ADD `dbinfo` varchar(255) DEFAULT NULL

Error occured at:2007-09-16 23:26:00
Line no.:11
Error Code: 1060 - Duplicate column name 'dbinfo'

Query:
CREATE TABLE `characters` (
`guid` int(11) unsigned NOT NULL default '0',
`acct` int(20) unsigned NOT NULL default '0',
`name` varchar(21) NOT NULL default '',
`race` smallint(3) unsigned NOT NULL,
`class` smallint(3) unsigned NOT NULL,
`gender` tinyint(1) unsigned NOT NULL,
`level` int(3) unsigned NOT NULL,
`xp` int(30) unsigned NOT NULL,
`exploration_data` longtext NOT NULL,
`skills` longtext NOT NULL,
`watched_faction_index` bigint(40) unsigned NOT NULL,
`selected_pvp_title` int(30) unsigned NOT NULL,
`available_pvp_titles` int(30) unsigned NOT NULL,
`gold` int(30) unsigned NOT NULL,
`ammo_id` int(30) unsigned NOT NULL,
`available_prof_points` int(30) unsigned NOT NULL,
`available_talent_points` int(30) unsigned NOT NULL,
`current_hp` int(30) unsigned NOT NULL,
`current_power` int(30) unsigned NOT NULL,
`pvprank` int(30) unsigned NOT NULL,
`bytes` int(30) unsigned NOT NULL,
`bytes2` int(30) unsigned NOT NULL,
`player_flags` int(30) unsigned NOT NULL,
`player_bytes` int(30) unsigned NOT NULL,
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`mapId` int( unsigned NOT NULL default '0',
`zoneId` int( unsigned NOT NULL default '0',
`taximask` longtext NOT NULL,
`banned` int(6) unsigned NOT NULL default '0',
`banReason` varchar(50) NOT NULL,
`timestamp` text NOT NULL,
`online` int(11) default NULL,
`bindpositionX` float NOT NULL default '0',
`bindpositionY` float NOT NULL default '0',
`bindpositionZ` float NOT NULL default '0',
`bindmapId` int( unsigned NOT NULL default '0',
`bindzoneId` int( unsigned NOT NULL default '0',
`isResting` int(1) NOT NULL default '0',
`restState` int(5) NOT NULL default '0',
`restTime` int(5) NOT NULL default '0',
`playedtime` longtext NOT NULL,
`deathstate` int(2) NOT NULL default '0',
`TalentResetTimes` int(3) NOT NULL default '0',
`first_login` tinyint(1) NOT NULL default '0',
`forced_rename_pending` tinyint(1) unsigned NOT NULL default '0',
`publicNote` varchar(32) NOT NULL default '',
`officerNote` varchar(32) NOT NULL default '',
`guildid` int(10) unsigned NOT NULL default '0',
`guildRank` int(10) unsigned NOT NULL default '0',
`charterId` int(10) NOT NULL,
`totalstableslots` int(10) unsigned NOT NULL default '0',
`instance_id` int(10) NOT NULL default '0',
`entrypointmap` int(4) NOT NULL default '0',
`entrypointx` float NOT NULL default '0',
`entrypointy` float NOT NULL default '0',
`entrypointz` float NOT NULL default '0',
`entrypointo` float NOT NULL default '0',
`entrypointinstance` int(10) NOT NULL default '0',
`taxi_path` int(10) NOT NULL default '0',
`taxi_lastnode` int(10) NOT NULL default '0',
`taxi_mountid` int(10) NOT NULL default '0',
`transporter` int(10) NOT NULL default '0',
`transporter_xdiff` float NOT NULL default '0',
`transporter_ydiff` flo
ULL default '0',
`transporter_zdiff` float NOT NULL default '0',
`spells` longtext NOT NULL,
`deleted_spells` longtext NOT NULL,
`reputation` longtext NOT NULL,
`actions` longtext NOT NULL,
`auras` longtext NOT NULL,
`finished_quests` longtext NOT NULL,
`lastDailyReset` int(30) NOT NULL,
`killsToday` int(10) NOT NULL default '0',
`killsYesterday` int(10) NOT NULL default '0',
`killsLifeTime` int(10) NOT NULL default '0',
`honorToday` int(10) NOT NULL default '0',
`honorYesterday` int(10) NOT NULL default '0',
`honorPoints` int(10) NOT NULL default '0',
`difficulty` int(4) NOT NULL default '0',
UNIQUE KEY `guid` (`guid`),
KEY `acct` (`acct`),
KEY `guildid` (`guildid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-09-18 15:25:24
Line no.:269
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'flo
ULL default '0',
`transporter_zdiff` float NOT NULL default '0',
`spells`' at line 68

Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(2 NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

Error occured at:2007-09-18 15:51:58
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
CREATE TABLE `accounts` (
`acct` int(20) unsigned NOT NULL auto_increment,
`login` varchar(16) NOT NULL default '',
`password` varchar(16) default NULL,
`gm` varchar(10) default '0',
`banned` int(30) unsigned NOT NULL default '0',
`lastlogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`lastip` varchar(15) default NULL,
`email` varchar(50) default NULL,
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1

Error occured at:2007-09-21 23:12:17
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
CREATE TABLE `accounts` (
`acct` int(20) unsigned NOT NULL auto_increment,
`login` varchar(16) NOT NULL default '',
`password` varchar(16) default NULL,
`gm` varchar(10) default '0',
`banned` int(30) unsigned NOT NULL default '0',
`lastlogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`lastip` varchar(15) default NULL,
`email` varchar(50) default NULL,
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1

Error occured at:2007-09-21 23:12:19
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
CREATE TABLE `accounts` (
`acct` int(20) unsigned NOT NULL auto_increment,
`login` varchar(16) NOT NULL default '',
`password` varchar(16) default NULL,
`gm` varchar(10) default '0',
`banned` int(30) unsigned NOT NULL default '0',
`lastlogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`lastip` varchar(15) default NULL,
`email` varchar(50) default NULL,
`flags` int(11) NOT NULL default '0',
PRIMARY KEY (`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1

Error occured at:2007-09-21 23:12:20
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
/* Creature Names */
INSERT INTO creature_names VALUES (50000, "Armor", "Dungeon I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0)

Error occured at:2007-10-04 18:57:24
Line no.:64
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
/* Creature Names */
INSERT INTO creature_names VALUES (50000, "Armor", "Dungeon I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0)

Error occured at:2007-10-04 19:04:32
Line no.:64
Error Code: 1136 - Column count doesn't match value count at row 1

Im using Milestone 0.2 DB and JuianX's V5 ascent.exe and logonserver.exe its like Rev: 1648 or somthing. But why do i get the error

[Mesmoras]

Shut up and search for it, Gastric posted a guide on it and it's a sticky for christ's sake

[phc_chaos]

Shut up and search for it, Gastric posted a guide on it and it's a sticky for christ's sake

true.

Thanks to whoever posted the navicat help.





__________________________________________________________

"Slow Computer, I HATE YOU!"
Master hate computer?
"YES!"
Self destruct sequence initiated. Activiating atomic core in t-minus 10 seconds.
HOLY F***
"No I dont hate you I'm sorry!"
Deactivating.
"Pheww."
*Click*
Beep, beep
:shock: "WHAT THE!?"
:runaway: :runaway: :runaway:
*BOOM*

[phc_chaos]

THE VENDORS arent showing but the portals are..

everytime i try to spawn them using .npc spawn 50008 it says Invalid npc <id>

why is this? any command for spawning of vendors? please help..

and then this.. [Err] 1050 - Table 'accounts' already exists
[Msg] Finished - Unsuccessfully
when I tried executing..

[Illlidan]

I only get : [Err] 1136 - Column count doesn't match value count at row 1
[Err] /* Creature Names */
INSERT INTO creature_names VALUES (50000, "Armor", "Dungeon I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Using Navicat 8.0 and MySQL 5.0

[assassin2011]

someone should make a cool gm addon like that
it would be much easier

[latruwski]

Nice but whats that ''Tele ticket item skill spell comm object ban'' is it a GM addon (or something like that) then where can i get it? Anyway this was nice!

use search and you would come up with this:
http://www.mmowned.com/forums/progra...-gm-addon.html
if you need an update go to the ascenthomepage:
AscentEmu.com - Ascent Emulator

and about comments from other players: you are all wrong it is working !
i am playing on a server with the best completed DB and best ascent core (ascent devs own it) and its working ! (using patch 2.2.2)

grtz

[phc_chaos]

use search and you would come up with this:
http://www.mmowned.com/forums/progra...-gm-addon.html
if you need an update go to the ascenthomepage:
AscentEmu.com - Ascent Emulator

and about comments from other players: you are all wrong it is working !
i am playing on a server with the best completed DB and best ascent core (ascent devs own it) and its working ! (using patch 2.2.2)

grtz

no it is not working!! haha (no vendors showy up but portals do?) WTF!

[silviu2008]

please julianx tell me Display id for the portal you use!!! please!

[iccy]

Error occured at:2007-10-11 15:05:01
Line no.:137
Error Code: 1136 - Column count doesn't match value count at row 1

nvm......................................................................